Home & DIY

Moving box weight allocation

Group listed item units within your chosen box mass budget.

Moving box weight allocation
Esc to restore

Your inputs

Comma-separated headings shown in the example. Up to 1,000 source rows; keep this project table small enough to review.

Up to 25 MB per file, 50,000 data rows, 200 columns and 2 million data cells. Fully blank rows and columns are ignored before row, column and cell limits are checked. Individual tools may have smaller result or chart limits.

Results update as you type. Larger files run when you press Update result.

Processed on your device

Your result

LOCAL & PRIVATE

Your result will appear here.

Your inputs stay in this browser. Nothing is uploaded or saved.

A clear answer. Here’s how.

Expands whole quantities into at most 2,000 units, sorts by mass descending and first-fit packs units into boxes. Rejects an item heavier than the supplied capacity. This heuristic may not minimise boxes and models mass only; it does not account for box tare, item dimensions, fragility, safe handling or packaging strength.

See a worked example

Worked example

A fixed demonstration, separate from the values you enter above.

Project CSV
Item,Quantity,KgEach
Books bundle,6,2
Pan,3,1.5
Cushion,4,0.4
Maximum listed contents mass per box (kg)
8

Example result

First 5 rows of the example result
BoxItemItem mass (kg)Box mass (kg)
1Books bundle #128
1Books bundle #228
1Books bundle #328
1Books bundle #428
2Books bundle #527.8

First-fit decreasing heuristic by mass only. Does not model dimensions, fragility, handling suitability or box strength; capacity is supplied by you.

Keep going.

Shelf carcass panel cut listPaver grid and edge-cut planWindow blind measurement worksheetPipe mean flow velocity