Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
materials calculations
Hi,
My son fits out new houses with shelving. He measures and notes all the requirements. The data will look something like this: 12 lengths of 0.9 metres 15 lengths of 1.4 metres 8 lengths of 2.1 metres 4 lengths of 2.5 meters Shelving comes in a range of standard lengths: 1.8m, 2.4m, 3.0m, 3.6m Currently he spends a great deal of time trying to figure how many of each standard length to buy, to keep waste (and therefore cost) to a minimum. He asked me if Excel could do this sort of thing. €œOf course!€ I said. However, after several attempts, I am no closer to a solution than when I started. Can anyone tell me how to even start, or point me to a site that deals with this sort of issue? Regards €“ Dave. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
materials calculations
Maybe this gets you started:
http://www.solver.com/solutions/procutstock.htm -- Kind regards, Niek Otten Microsoft MVP - Excel "Dave" wrote in message ... Hi, My son fits out new houses with shelving. He measures and notes all the requirements. The data will look something like this: 12 lengths of 0.9 metres 15 lengths of 1.4 metres 8 lengths of 2.1 metres 4 lengths of 2.5 meters Shelving comes in a range of standard lengths: 1.8m, 2.4m, 3.0m, 3.6m Currently he spends a great deal of time trying to figure how many of each standard length to buy, to keep waste (and therefore cost) to a minimum. He asked me if Excel could do this sort of thing. €œOf course!€ I said. However, after several attempts, I am no closer to a solution than when I started. Can anyone tell me how to even start, or point me to a site that deals with this sort of issue? Regards €“ Dave. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Indented Bill of Materials? | Excel Discussion (Misc queries) | |||
VBA Learning Materials | Excel Discussion (Misc queries) | |||
how do i set up a drop down list of materials? | Excel Discussion (Misc queries) | |||
Bill of Materials / Router | Excel Discussion (Misc queries) | |||
RAW MATERIALS SCHEDULE | Excel Worksheet Functions |