Steel Rebars Cutting List Optimization Using Excel Formulas (for very large number of probabilities)

Mahmoud_Hossam_El_Deen Have bumped into this tread over and over again, trying to understand the issue and come up with a solution. Came up with a table that allows you to do some What-If analysis.

Re-using left-overs from lengths that allow only 1 pc out 1 rebar seems to be way to minimise waste. E.g. L 7 and 8 produce waste of 5 and 4 meters respectively. These are long enough to be used for some of the shorter lengths required (2.4, 3 and 3.5).

My table in the attached workbook is far from automatic. It would have to be re-done for every different set-up, but it may help you finding a solution or your problem. Move around the numbers in R7:T9 and see what happens. If not helpful, kindly ignore this post.