Bar Cutting Optimization????

[sajferris]

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

 

[Niek Otten]

Look here:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|
| 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?action=getinfo&userid=37323
| View this thread: http://www.excelforum.com/showthread.php?threadid=570272
|