Shipping cost may depend on parcel volume as well as scale weight. The divisor and rounding rules must be verified against your carrier agreement. This worksheet is a checking aid, not a quoted shipping price.
Enter parcel dimensions
Use A for product/SKU, B for width, C for length, D for height (all in cm), E for the divisor in your carrier agreement, and F for the raw volumetric value. A 30×20×10 cm parcel is 6,000 cm³; with an illustrative divisor of 3,000, F2 is 2. That divisor is not a universal rule.
Measure the packed outer parcel, not the bare product. Mixed units or an incorrect divisor create a systematic error across your catalog.
| Width (cm) | Length (cm) | Height (cm) | Example divisor | Raw result |
|---|---|---|---|---|
| 30 | 20 | 10 | 3,000 | 2 |
=B2*C2*D2/E2Separate billable units from price
Use G for actual scale weight, H for the carrier's billable unit, and I for the contracted charge. Some tariffs evaluate kg and volumetric units together; confirm the chosen unit and rounding in your current terms.
PTT's shipping calculator and current tariff illustrate why this check matters. Remote-area charges, cash-on-delivery, returns, or extra services can change the price; the raw formula is not an invoice.
Review the product catalog
Flag missing or zero dimensions and mixed units. Sorting by the largest volumetric result can help you review packaging decisions.
SheetCommand can sort and preview supported files, but it does not read carrier contracts or fetch live rates. Apply the formula in Excel and confirm actual prices with your carrier.
Frequently asked questions
Is the divisor always 3,000?
No. That number is illustrative; use the divisor and rounding rules from your carrier agreement.
Is volumetric weight the shipping price?
No. Current carrier tariffs and extra-service rules determine the charge.
Sources and further reading
SheetCommand
Review your e-commerce export
SheetCommand previews, sorts, and summarizes supported CSV/Excel files; it does not connect to marketplaces or carriers.