Cutting Optimization Spreadsheet for Bar Stock

Hello,

I would like to call upon your programming skills because if I rely on my own knowledge, I'm in trouble... :-)

My request concerns creating an Excel file that allows me to calculate the best arrangement of cuts to optimize the waste from a bar that can have different lengths depending on the case.

Specifically, I have several "lengths to cut," and these values can vary depending on the situation. I’ll start with an example with the following values:

- 714 mm (quantity 1)
- 688 mm (quantity 14)
- 637 mm (quantity 12)
- 237 mm (quantity 8)
- 234 mm (quantity 6)
- 512 mm (quantity 2)

The bars from which I will be making the cuts described above will be 3000 mm in my case (but they can vary depending on the situation).

I need to find the best arrangement to fit the "lengths to cut" into a 3000 mm bar, knowing that the “lengths to cut” I integrate into my first bar must be deducted from the total quantities to be cut.

Example:

714 + 688 + 688 + 637 = 2727 mm ==> waste: 3000 - 2727 = 273 mm

remaining to cut:

- 714 (0 remaining)
- 688 mm (14-2 = 12 remaining)
- 637 (12-1 = 11 remaining)
- 237 mm (8 remaining)
- 234 (6 remaining)
- 512 (2 remaining)

Repeat these operations until there are no more "lengths to cut" while optimizing all the bars.

I would also like to put a safety margin of -10 or -15 mm (variable data) on the length of the 3000 mm bar.

Thank you very much for your help.

I hope to hear from you soon, I really do! :-)