Chargeable weight and rate calculators inside the quote
Your own rate spreadsheet as a block in the lane quote: cube, cubic and actual weight, zone rate or minimum and fuel surcharge, with the results written into the price lines.
- 5/5 on G2
- 4.2 on Capterra
- Building QuoteCloud since 2013
QuoteCloud's Spreadsheet block is a full spreadsheet inside the quote, on Essentials and up. Carriers rebuild their rate calculator there or import the .xlsx: chargeable weight, zone lookups, minimums and fuel surcharge. Any cell connects to a price line's description and unit price, and the quote total comes back into a cell.
Last reviewed by the QuoteCloud team
A drawing of one pallet on a platform scale beside the dashed outline of its cube, with dimension strings of 1200 by 1000 millimetres and its height, and the scale's readout on a post, shown enlarged. A live route runs from the scale to the lane calculator. Two loads take turns. Light homewares: 6 pallets 1.5 metres high at 180 kg each, so the cube is 10.80 cubic metres, cubic weight 2,700 kg beats actual weight 1,080 kg, and the linehaul line to Port Ellery is $837.00. Stoneware: 10 pallets 1 metre high at 620 kg each, cube 12.00 cubic metres, cubic weight 3,000 kg, actual weight 6,200 kg wins, and the linehaul line to Lakeview is $1,364.00. In each, the chargeable weight cell is =MAX(B7,B8), and the linehaul line's description and unit price come from cells C14 and B14 of the Quote tab.
Every cell that prices the quote, wired to its line
Choose a connection, or point at a cell or a line. Two cells set each freight line, and the quote total comes back into the sheet.
Callan Mercer's lane calculator · Quote tab
=MAX(B9*B12,B13)
Quote tab
| Row | A | B | C |
|---|---|---|---|
| 1 | Lane quote | Value | Line description · note |
| 9 | Chargeable weight (kg) | 2,700 | The greater of the two |
| 10 | Lane | Northgate → Port Ellery | Chosen from the Rates tab |
| 11 | Zone | Long-haul | |
| 12 | Rate per kg | $0.31 | Your zone rate |
| 13 | Minimum charge | $160 | Your zone minimum |
| 14 | Linehaul | $837.00 | Linehaul Northgate → Port Ellery · 6 pallets · 2,700 kg chargeable |
| 15 | Fuel surcharge | $154.85 | Fuel surcharge 18.5% of linehaul |
| 16 | Quote total | Price table$1,165.84 | From the price table, inc tax |
| 17 | All-in per pallet | $194.31 | Total ÷ pallets |
The lane quote in the editor · lines and their cells
Your quote
Freight
AccessorialsTick what the delivery needs
- Subtotal
- $1,059.85
- Tax (10%)
- $105.99
- Total Total → Quote!B16
- $1,165.84
Quote!C14 sets the linehaul line's description (“Linehaul Northgate → Port Ellery · 6 pallets · 2,700 kg chargeable”) and Quote!B14, =MAX(B9*B12,B13), sets its unit price: $837.00.
Connecting a cell to a price line sets that line's description and unit price. Quantities stay on the line, so each freight line is one consignment. Accessorials are ordinary optional lines with your prices.
Your rates on their own tab, where one change reaches the next quote
The Rates tab holds what Callan's desk agrees once and uses all year: which zone each lane falls in, the rate per kg and minimum for each zone, the cubic conversion factor, this month's fuel surcharge and the accessorial prices.
The Quote tab looks them up with XLOOKUP, so a new fuel percentage typed into the template's Rates tab is in the next quote that leaves the desk. Click a cell to see its value or formula, and switch tabs at the bottom.
- Lanes to zones, zones to rates
- Cubic conversion and fuel surcharge as cells
- Accessorial prices beside them
Spreadsheet block: Essentials and up
Lane calculator · click a cell
$0.31
Quote tab
| Row | A | B | C |
|---|---|---|---|
| 1 | Lane quote | Value | Line description · note |
| 2 | Pallets | 6 | Typed from the request |
| 3 | Height per pallet (m) | 1.50 | On a 1.2 × 1.0 m pallet |
| 4 | Weight per pallet (kg) | 180 | Typed from the request |
| 5 | Cube (m³) | 10.80 | |
| 6 | Cubic conversion | 250 | kg per m³, your factor |
| 7 | Cubic weight (kg) | 2,700 | |
| 8 | Actual weight (kg) | 1,080 | |
| 9 | Chargeable weight (kg) | 2,700 | The greater of the two |
| 10 | Lane | Northgate → Port Ellery | Chosen from the Rates tab |
| 11 | Zone | Long-haul | |
| 12 | Rate per kg | $0.31 | Your zone rate |
| 13 | Minimum charge | $160 | Your zone minimum |
| 14 | Linehaul | $837.00 | Linehaul Northgate → Port Ellery · 6 pallets · 2,700 kg chargeable |
| 15 | Fuel surcharge | $154.85 | Fuel surcharge 18.5% of linehaul |
| 16 | Quote total | Price table$1,165.84 | From the price table, inc tax |
| 17 | All-in per pallet | $194.31 | Total ÷ pallets |
Rates tab
| Row | A | B | C |
|---|---|---|---|
| 1 | Lane | Zone | km |
| 2 | Northgate → Riverside | Metro | 38 |
| 3 | Northgate → Lakeview | Regional | 210 |
| 4 | Northgate → Port Ellery | Long-haul | 640 |
| 5 | Northgate → Ashcombe | Remote | 1,180 |
| 6 | Zone | Per kg | Minimum |
| 7 | Metro | $0.14 | $75 |
| 8 | Regional | $0.22 | $110 |
| 9 | Long-haul | $0.31 | $160 |
| 10 | Remote | $0.48 | $240 |
| 11 | Cubic conversion | 250 | kg per m³ |
| 12 | Fuel surcharge | 18.5% | This month |
| 13 | Tail-lift delivery | $68 | Per consignment |
| 14 | Booked delivery time | $22 | Per consignment |
- Typed in
- Your rate or factor
- Connected to the price table
Formulas freight pricing desks already use
Normal spreadsheet formulas, including lookups and cross-tab references. Use your own; these are the ones in Wexmoor's sample.
Chargeable weight
=MAX(B7,B8) charges the greater of cubic weight and actual weight.
Cubic weight
=B5*B6 multiplies the cube by your conversion factor, kept on the Rates tab as =Rates!B11.
Zone from the lane
=XLOOKUP(B10, Rates!A2:A5, Rates!B2:B5) finds the zone, and the same lookup finds its rate and minimum.
Rate or minimum
=MAX(B9*B12,B13) charges the weight at the zone rate, or the minimum when that's higher. IF works too.
Fuel surcharge
=ROUND(B14*Rates!B12,2) applies this month's percentage to linehaul, rounded to the cent.
Storage per month
=B2*B3*B4 gives pallets × weeks × rate for a 3PL proposal's storage line.
Bring your rate spreadsheet to the trial
Free for 14 days, no credit card required. Send us your rate calculator and your current quote, and we'll convert one template for you during the trial.
The same idea for warehousing: pallets × weeks × rate
Tomasz's 3PL pricing model sits in the warehousing proposal as its own Spreadsheet block. The customer's forecast goes into the typed cells; your storage, receiving, pick and pack and packaging rates sit beside them.
Each charge cell is connected to a monthly line in the proposal, description and price, so the customer sees the basis of every line. The monthly charges are shown in the agreement; Wexmoor invoices actual volumes from its own systems.
- Forecast in typed cells
- Your rates as cells
- Monthly lines from connected cells
Spreadsheet block and price tables: Essentials and up
3PL & warehousing proposalsYour 3PL pricing model
=B9*B10
Storage tab
| Row | A | B | C |
|---|---|---|---|
| 1 | Monthly charges | Value | Note |
| 2 | Pallets stored (average) | 180 | From your forecast |
| 3 | Weeks per month | 4.33 | Your billing basis |
| 4 | Storage per pallet per week | $4.80 | Your rate |
| 5 | Pallet storage | $3,741.12 | Pallet storage, 180 pallets average |
| 6 | Inbound pallets a month | 120 | From your forecast |
| 7 | Receiving per pallet | $9.50 | Unload, check, put away |
| 8 | Inbound handling | $1,140.00 | |
| 9 | Orders a month | 3,200 | From your forecast |
| 10 | Pick & pack per order | $2.10 | Up to 3 lines |
| 11 | Pick & pack | $6,720.00 | |
| 12 | Packaging per order | $0.65 | Carton, fill, label |
| 13 | Packaging | $2,080.00 | |
| 14 | Monthly estimate | $13,681.12 | At forecast volumes |
- Typed in
- Your rate or factor
- Connected to the price table
Set-up and monthly charges
| Item | Qty | Rate | Amount |
|---|---|---|---|
| Set-up, one-off | $5,200 | ||
Warehouse system set-up and SKU load1,840 SKUs from your item file
|
1 | $1,850 | $1,850.00 |
Dedicated zone: racking reconfigured220 pallet positions, Eastvale bay 4
|
1 | $2,400 | $2,400.00 |
Pack stations and label printersTwo stations, your carton sizes
|
1 | $950 | $950.00 |
| Monthly charges at forecast volumes | $0 | ||
Pallet storage, 180 pallets averageDescription and price from Storage!C5 · B5
|
Monthly | $3,741.12 | $3,741.12/mo |
Inbound handling, 120 palletsStorage!B8
|
Monthly | $1,140 | $1,140.00/mo |
Pick & pack, 3,200 ordersStorage!B11
|
Monthly | $6,720 | $6,720.00/mo |
Packaging, 3,200 ordersStorage!B13
|
Monthly | $2,080 | $2,080.00/mo |
| Options Tick to add | |||
Returns processingAbout 150 returns a month at $1.80
|
Monthly | $270 | $270.00/mo |
Peak-season overflow, 60 palletsNovember to December
|
1 | $2,496 | $2,496.00 |
- Subtotal
- $5,200.00
- Tax (10%)
- $520.00
- Total
- $5,720.00
- Monthly, invoiced by Wexmoor on actual volumes
- $13,951.12/mo
- Set-up deposit on signing (50%)
- $2,860.00
Turning your rate spreadsheet into a calculator in the quote
Done once, in the template. Every quote made from it then prices itself the same way.
Import your .xlsx
Add a Spreadsheet block to your lane template and import the calculator, with its tabs and formulas.
Mark the inputs
Label the cells your desk types into: pallets, height, weight, lane. Zapier can fill them from a booking form.
Connect the lines
Connect the linehaul and fuel cells to their price lines' description and unit price.
Bring the total back
Send the price table total into a cell for the all-in price per pallet or a margin check.
Lock what reps shouldn't change
On Business, lock fixed blocks such as your conditions of carriage. Locking is per block, so the calculator stays editable.
Rate calculator questions, answered
Can we import our existing rate spreadsheet?
Yes. The Spreadsheet block imports .xlsx files and supports normal spreadsheet formulas, several tabs and cross-tab references, on Essentials and up. Import your calculator, label the input cells, then connect the cells that hold each line's description and unit price.
Does a cell set the quantity on a line?
No. A connected cell sets a price line's description and unit price, and a price table total can come back into a cell. Quantities stay on the line as usual, so a consignment line is usually quantity one with its price from the sheet.
Does QuoteCloud know our fuel surcharge or distances?
No. Your fuel surcharge, cubic conversion factor, zone rates, minimums and lanes are cells on your own Rates tab. QuoteCloud runs the formulas you set up; it doesn't fetch fuel indexes, distances, tolls or carrier rates from anywhere.
Can our booking form fill in the calculator?
Yes, through Zapier, on Essentials and up. A zap can create the quote from your template and write the booking form's pallets, height, weight and lane into the input cells. Writing cells through the QuoteCloud API isn't confirmed, so use Zapier for that step.
Can we stop reps changing our terms and wording?
On the Business plan you can lock whole blocks in a template, such as your conditions of carriage and claims wording. Locking works on blocks, not single cells, so keep the calculator your desk types into in its own unlocked block and protect the wording around it.
Can the calculator handle volume breaks?
Yes, in your own sheet: put the weight breaks in a table on the Rates tab and look the rate up with a formula. QuoteCloud's price table itself has no tiered pricing rules, so the sheet does that work and sets the line's unit price.
More for freight & 3PL teams
Every page of the logistics guide.
-
Lane & spot freight quotesA priced lane quote back the same hour: chargeable weight, linehaul, fuel and accessorials, accepted online.Explore
-
3PL & warehousing proposalsPallets × weeks × rate, handling, pick and pack in a calculator, an onboarding plan and a set-up fee paid on signing.Explore
-
Contract rate schedulesA customer's lanes, zones, minimums and accessorials in one schedule, approved, signed and dated to expire.Explore
- Freight tenders & RFQ responsesA shipper's lane list answered lane by lane, with your service, insurances and terms as locked library blocks.
- AI-drafted quotes & reports with MCPAn AI assistant connected through QuoteCloud's MCP service drafts quotes and reports from your data for your team to review.
- Quarterly service reportsShipments, on-time delivery and claims for each contract customer, with next quarter's options priced inside.
- Rate reviews & contract renewalsExpiring schedules found early, the new rates sent to every contract customer, and each one signed before expiry.
- Pricing approvals & marginsDiscounts and big contracts routed to the right manager, with cost and margin visible only to your team.
- TMS, CRM & accounting integrationsYour transport management system, CRM and accounts, connected the way each one really connects.
- Logistics templatesReal QuoteCloud templates for transport agreements, storage, service levels and quotes.
- QuoteCloud implementation for freight & 3PLYour rate tables rebuilt as a calculator, your templates converted, approvals set and the pricing desk trained.
- FAQAnswers to the questions carriers, forwarders, 3PLs and couriers ask most.
Your rate spreadsheet, pricing every quote
Free for 14 days. No credit card required.