Drop the workbook in. Whatever shape it is.
Merged headers, a legend sheet, three currencies, blacked-out cells, a lane ID column they invented. Nothing needs to be tidied first — the point of the feature is that their file is a mess and yours is not.
The columns map themselves. You fix what it got wrong, once.
Then it remembers — by header signature, per customer. The same shipper’s next round arrives already mapped, including the corrections you made and the custom columns you added.
“Shenzhen” is a city, not a gateway.
SZX, or two hours by truck to HKG for the capacity? It shows you the options with the reason for each and lets you choose — then keeps that choice for every later round, and prices the lane against the gateway you actually picked.
Four prices on every lane, not one.
The shipper’s target, what you believe wins it, your floor — derived from cost and your margin policy — and your walk-away, which the system never fills in for you. One number is not a negotiating position.
54 checks, before it leaves the building.
The decimal slip. The fill-down that overwrote line 212. A rate below your own walk-away with no reason written. Margin that reads healthy because the currency column is wrong. Each one says what it found, why it matters, and what to do.
Back into their template. Cell for cell.
Not a CSV they have to re-import. Their own workbook, their own layout, their formatting intact and their lane IDs unmoved — which is the difference between a submission that gets scored and one that gets returned.
Merged headers, three currencies, redacted cells, a lane reference they invented, and a sheet nobody should open. Nothing is tidied first.
Matched by header signature, per customer. The one correction you make is the one their next round arrives already carrying.
A city is not a gateway. It shows the options with the reason for each, then prices the lane against the one you picked.
The floor is derived from your cost and your margin policy. The walk-away stays empty until you write it — one number is not a negotiating position.
Fifty-four checks run before anything leaves. Each one says what it found, why it matters and what to do about it.
Their workbook, their layout, their formatting — one column filled in and the lane references untouched. That is the difference between a submission that gets scored and one that gets returned.