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?

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" <[email protected]> wrote in message
news:[email protected]...
>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?