How to find method to cut steel coil by using excel.

V

vn

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?
 
T

tkt_tang

That's a cutting plan called nesting ; it requires Excel VBA
programming to effect a solution. Regards.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split text file into Excel sheet and separate the final results intoa new sheet 8
Excel 2000 formula to dynamically sum adjacent rows and columns whererows inserted/deleted 3
Can Excel calculate CAD CAM cut outs? 5
How to find data character width in Excel 2
How to use data from Access database to fill in cells in Excel 3
Sorting in Numerical Order 4
How to create a 3D surface graph from 3 columns of data: one columnfor x, one for y, and one for z 3
Remove lines from text file prior to importing in Excel 2

Top