E-Commerce NZ Shipping Matrix
Budget: $30 – $250 AUD
My courier has issued a comprehensive rate card and I need those numbers turned into a live Excel matrix that my e-commerce platform can read without further tweaks. The finished sheet must calculate charges by matching two factors—weight of the package and the destination zone—and return the correct variable-by-weight price every time.
I will supply:
• the original courier rate card
• an Excel template that already shows the required row / column layout
What I expect back:
• the completed matrix with formulas or look-ups inserted, fully tested across all weight breaks and zones
• a short note explaining any hidden helper tables or named ranges you create, so I can maintain it later
Accuracy is critical; the numbers in the final matrix must mirror the courier’s card exactly. Once it drops into our store, it should quote the right charge for any New Zealand order, first try.
I will supply:
• the original courier rate card
• an Excel template that already shows the required row / column layout
What I expect back:
• the completed matrix with formulas or look-ups inserted, fully tested across all weight breaks and zones
• a short note explaining any hidden helper tables or named ranges you create, so I can maintain it later
Accuracy is critical; the numbers in the final matrix must mirror the courier’s card exactly. Once it drops into our store, it should quote the right charge for any New Zealand order, first try.
Related categories:
PHP
Website Design
Data Entry
Excel
HTML
Excel Macros
Data Visualization
Data Analysis