|
Terror
Guest
|
 |
« Reply #15 on: January 20, 2009, 06:16:41 PM » |
|
Yeah, your way would make it much easier if something changed (much better for business etc. but then I'd probably have them in separate cells, so you wouldn't need to change every cell again)
|
|
|
|
|
Logged
|
|
|
|
|
Junta
Guest
|
|
« Reply #16 on: January 20, 2009, 06:23:54 PM » |
|
Yeah, your way would make it much easier if something changed (much better for business etc. but then I'd probably have them in separate cells, so you wouldn't need to change every cell again)
yep of course  I'd have used named ranges in the formulae anyway  |
|
|
|
|
Logged
|
|
|
|
|
claws
Guest
|
|
« Reply #17 on: January 20, 2009, 06:25:54 PM » |
|
I thought you were just being a typical consultant and going down the line of 'oh, you want separate ranges now?!? well that's not in the spec, i'd have to quote you again for that' |
|
|
|
|
Logged
|
|
|
|
|
Junta
Guest
|
|
« Reply #18 on: January 20, 2009, 06:28:00 PM » |
|
I thought you were just being a typical consultant and going down the line of 'oh, you want separate ranges now?!? well that's not in the spec, i'd have to quote you again for that' HAHA - YOU should be a consultant for that response! No, I like my customers to come back thanks |
|
|
|
|
Logged
|
|
|
|
Millicent Bystander
Clan admin
Karma: 740
 Offline
Gender: 
Posts: 2523
WDG Conception Expert
|
|
« Reply #19 on: January 26, 2009, 10:13:47 AM » |
|
Arrrrrrgh,
Boss has just looked at the pricelist and said "the prices look a bit high, can you reduce them, just a little bit".
*cries*
|
|
|
|
|
Logged
|
I find myself stark naked except for a pair of latex gloves attempting to pull on a pair of red tights on in my parent's spare bedroom.
|
|
|
Magathery
WDG Lube Liason and Slippery Genius
Karma: 956
Offline
Gender:
Posts: 4374
AKA - Ripsaw
|
|
« Reply #20 on: January 26, 2009, 10:16:23 AM » |
|
There there there.
/hug
|
|
|
|
|
Logged
|
 May the Fluke be with you... |
|
|
Millicent Bystander
Clan admin
Karma: 740
Offline
Gender:
Posts: 2523
WDG Conception Expert
|
|
« Reply #21 on: January 26, 2009, 10:25:49 AM » |
|
19,000 individual prices!!
Edit; Just been given a CD with an Excel pricelist from our supplier with our discount applied.... all that work for nothing. I want to go home to bed and stay there.
|
|
|
|
« Last Edit: January 26, 2009, 10:36:43 AM by Millicent Bystander »
|
Logged
|
I find myself stark naked except for a pair of latex gloves attempting to pull on a pair of red tights on in my parent's spare bedroom.
|
|
|
|
mark
Guest
|
|
« Reply #22 on: January 26, 2009, 10:39:18 AM » |
|
 Do you know how much you'll be adding/retracting to/from them? [A cd...wow I haven't seen a cd since forever] |
|
|
|
|
Logged
|
|
|
|
|
Terror
Guest
|
|
« Reply #23 on: January 26, 2009, 10:39:30 AM » |
|
Can you not just make a macro to reduce every cell by about 10-15%?
|
|
|
|
|
Logged
|
|
|
|
Millicent Bystander
Clan admin
Karma: 740
Offline
Gender:
Posts: 2523
WDG Conception Expert
|
|
« Reply #24 on: January 26, 2009, 11:03:37 AM » |
|
If only life was that simple, going through this new pricelist it turns out that the specs we get from this manufacturer are different from their standard specs so the prices are different.
I can't even copy/paste the cells from the CD as it is protected in some way
|
|
|
|
|
Logged
|
I find myself stark naked except for a pair of latex gloves attempting to pull on a pair of red tights on in my parent's spare bedroom.
|
|
|
|
claws
Guest
|
|
« Reply #25 on: January 26, 2009, 11:06:39 AM » |
|
You'd just do set A1 = 0.90, then formula C2 = B2 * A$1 (where B2 is your price), then copy/paste that formula down the entire sheet, and hide/delete the original column. Or just go back to bed and stay there ... wish I could too!
|
|
|
|
|
Logged
|
|
|
|
|
Terror
Guest
|
|
« Reply #26 on: January 26, 2009, 11:08:29 AM » |
|
If only life was that simple, going through this new pricelist it turns out that the specs we get from this manufacturer are different from their standard specs so the prices are different.
I can't even copy/paste the cells from the CD as it is protected in some way
Can't you just save your own copy without the protection, or do you not have the password? |
|
|
|
|
Logged
|
|
|
|
Millicent Bystander
Clan admin
Karma: 740
Offline
Gender:
Posts: 2523
WDG Conception Expert
|
|
« Reply #27 on: January 26, 2009, 11:25:48 AM » |
|
Its protected in a way that I can't even select the cells it's like a pdf document. It was probably done on specialist trade software.
|
|
|
|
|
Logged
|
I find myself stark naked except for a pair of latex gloves attempting to pull on a pair of red tights on in my parent's spare bedroom.
|
|
|
|
mark
Guest
|
|
« Reply #28 on: January 26, 2009, 11:33:22 AM » |
|
Its protected in a way that I can't even select the cells it's like a pdf document. It was probably done on specialist trade software.
So your suppliers are tools? |
|
|
|
|
Logged
|
|
|
|
|
Terror
Guest
|
|
« Reply #29 on: January 26, 2009, 11:36:17 AM » |
|
They expect you to change 16,000 data entries, when you need to individually input them all by hand?
You need a new line of work.
|
|
|
|
|
Logged
|
|
|
|
|
Total Members: 311
