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

Look he

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"sajferris" wrote in message
...
|
| 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
|

[quote=sajferris;353517]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. .....

This optimizer, is not exactly a worksheet, but easily can import data and send results directly to a spreadsheet:
http://www.1d-solutions.com/home.htm

M.C.J.

Hi,

You need "length cutting optimization" add-in for Excel.
Just google for it.