Combines your cut lengths into the fewest profile bars, so each order length stays within the limit.
Order length of a bar = Σ(cut + kerf) + tolerance, and it can never exceed the max. So the cuts on one bar must total at most 3750 mm.
Pasting imports automatically. Extra columns such as ORDER LENGTH are ignored.
| Cut length (mm) | Qty |
|---|
Rows with the same cut length are merged automatically (e.g. the two 1225 rows).
Bar capacity = Max order length − Tolerance. Order length per bar = Σ(cut + kerf) + Tolerance (rounded up to the step, never above max).
The optimizer repeatedly finds the combination of cuts that fills a bar most completely (bounded knapsack, solved exactly), then repeats that pattern as many times as the remaining quantities allow. It runs many slightly randomized passes within the time limit and keeps the plan with the fewest bars, then the fewest different patterns.
Theoretical minimum bars = ROUNDUP( Σ(cut+kerf)×qty / (Max − Tol) , 0). The result shows how close the plan gets to it.
Excel check for one pattern row: =SUMPRODUCT(cuts,counts)+kerf*SUM(counts)+tol must be ≤ 3800.