Eight measuring tools for a spreadsheet order

Five of the eight are measuring instruments rather than calculators — a checklist, a window grid, a size conversion, a declared-value check and a link normaliser. Only two of them produce a money figure. That balance is deliberate: most of the cost of a bad order is decided before any money is quoted.

QC checklist

Static checklists tell you what to look at. This one tells you what the answers add up to: ship, query the seller, or return to the warehouse.

Shipping window

Peak surcharges are announced months ahead and then forgotten. This grid keeps all forty-eight cells in one place and tells you how far to move a shipment.

Total cost

Every other calculator gives a single total. This one shows which of the six segments produced it, and how wide the range around it is.

Freight

Most estimates fail because the parcel bills on volume, not mass. This tool shows the gap before you pay for it.

Declared value

Under-declaring lowers duty and the compensation ceiling together. This tool shows both numbers on the same screen so the trade-off is visible.

Insurance

The usual answer is “it depends”. This tool gives you the declared value at which it stops depending.

Size conversion

Shoe sizing and garment sizing do not convert the same way. This tool keeps the two methods separate instead of forcing one table onto both.

Link normaliser

A dead row is usually a link that lost a parameter, not an item that disappeared. This tool tells the two apart.

How the tools pass values to each other

Each tool accepts its inputs from the address bar, so a result calculated once does not need retyping. The billed weight from the freight tool carries into the landed-cost tool, and the declared value carries into the insurance tool. Nothing is stored between visits — the hand-off works within a single click-through.

Parameter hand-offs between tools
FromToWhat travels
FreightTotal costBilled weight and the original dimensions
Declared valueInsuranceDeclared value
Declared valueTotal costItem value
Shipping windowTotal costMonth and region
QC checklistFreightWeight band

A worked example: /measure/freight/?weight=3.2&len=44&wid=32&hei=26 hands the resulting billed weight straight to the cost tool.

What each tool does not do

Stated limits, per tool
ToolWhat it does not do
QC checklistIt does not judge photo quality — it records your judgement.
Shipping windowIt reflects published carrier announcements, not live capacity.
Total costThe range comes from a census of 96 entries, not from your specific order.
FreightThe 5000 divisor is the common default; some carriers use 6000 or 4000.
Declared valueIt models duty from published thresholds and does not assess your shipment.
InsuranceLoss probability comes from published carrier claims data, not from your route specifically.
Size conversionGarment conversion uses chest and waist measurements, not a single letter size.
Link normaliserIt recognises six platform domains; anything else is reported as unsupported rather than guessed.

Every tool page lists its own limits in full. A tool that does not state its limits is not a measurement, it is an opinion.

Open the current entry list