Bar Cutting Optimization????

Hello, can anyone help me please? I am trying to create a worksheet from Excel that will allow me to optimize bar cutting lengths for example. I will have metal bars of a standard length and will need to cut various different lengths from this. Once i imput my smaller cut lengths and quantities of each i want the worksheet to be able to work out how many total bars i need to order of standard length and if possible identify which smaller bits need to be cut ffom the bigger bits. It might seem a bit difficult to comprehend but anyone who has used a bar cutting optimizer will understand my query! If anyone has already set up such a worksheet i would be most grateful if they could either let me know how i can get it or how to create one. Thanks

Look here:

http://www.solver.com/proframe.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"sajferris" <[email protected]> wrote in message
news:[email protected]...
|
| Hello, can anyone help me please? I am trying to create a worksheet from
| Excel that will allow me to optimize bar cutting lengths for example. I
| will have metal bars of a standard length and will need to cut various
| different lengths from this. Once i imput my smaller cut lengths and
| quantities of each i want the worksheet to be able to work out how many
| total bars i need to order of standard length and if possible identify
| which smaller bits need to be cut ffom the bigger bits. It might seem a
| bit difficult to comprehend but anyone who has used a bar cutting
| optimizer will understand my query! If anyone has already set up such a
| worksheet i would be most grateful if they could either let me know how
| i can get it or how to create one. Thanks
|
|
| --
| sajferris
| ------------------------------------------------------------------------
| sajferris's Profile: http://www.excelforum.com/member.php...o&userid=37323
| View this thread: http://www.excelforum.com/showthread...hreadid=570272
|