Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to find method to cut steel coil by using excel.
I would like to use excel to help my work. My work concern about
planning to slit steel from big coil to small coil by specific size. Sample : - Mother coil width = 1,000 mm. (for every coil) - Slit coil Type_1 width = 42 mm. Q’ty need = 200 Coil. - Slit coil Type_2 width = 50 mm. Q’ty need = 300 Coil. - Slit coil Type_3 width = 62 mm. Q’ty need = 50 Coil. - Slit coil Type_4 width = 70 mm. Q’ty need = 40 Coil. How can I use excel to calculate this problem for smallest scrap? |
#2
|
|||
|
|||
For a quick overview, here is one reference to the "cutting stock" problem.
http://www.solver.com/proframe.htm HTH -- Dana DeLouis Win XP & Office 2003 "vn" wrote in message om... I would like to use excel to help my work. My work concern about planning to slit steel from big coil to small coil by specific size. Sample : - Mother coil width = 1,000 mm. (for every coil) - Slit coil Type_1 width = 42 mm. Q’ty need = 200 Coil. - Slit coil Type_2 width = 50 mm. Q’ty need = 300 Coil. - Slit coil Type_3 width = 62 mm. Q’ty need = 50 Coil. - Slit coil Type_4 width = 70 mm. Q’ty need = 40 Coil. How can I use excel to calculate this problem for smallest scrap? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I find the cell address of the 2nd largest of a set? | Excel Discussion (Misc queries) | |||
Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) |