We are working for a steel mill and can produce "any" size in the source plate (within our dimensional program): and I can't seem to find a excel script or program that quite simply finds the size of the optimal plate in the dimensional program when we get a request for plates that we have to cut down and produce combined.
Commercial nesting programs all have the stock option: where they have limited options of source plates to choose from, hence I cant find any good commercial alternatives.
Normally this is not a large problem, but if the specification is large andunfortunate in dimensions it would be very good to have a way of finding the optimal dimensions of the source plates.
Basically: what the software should do is the following (very simple example):
Settings (in a excel table that is editable):
Thickness: Max Width Max Length
1 100 1000
2 200 2000
3 300 2500
I have a complete table for this http://dansteel.dk/data/files/Pllaengder%20-%202015-01-28.pdf
So, I select a series of cells of the same thickness (length - width - thickness) and the program identifies the dimension and number of plates that creates the least amount of scrap (or the one that creates zero scrap).
9 pcs of 10 x 100 and 2 pcs of 5 x 50 plates would give a result of 1 plate of 100 x 1000.
*The settings should have a cell padding option per thickness for all cutts that are inside of the plate.
In the finished product i would like to input on the "parts" page:
and then generate (grouped/based on thickness) the optimal sizes to produce, with the consideration that we need a minimum number of each source plate (based on the fact that we prefferably need to produce at least 3800 KG).