Automate Postcode Rate Calculator In Excel
Budget: $10 – $30 USD
Please see Excel sheet attached. Tab 1 (CALCULATOR) manually calculates a 'DELIVERY RATE' based on:
1) The number of pallets.
2) The service selected (nextday or economy).
3) The delivery postcode (a postcode is what we call a zip code in the UK).
This purpose of this spreadsheet is to demonstrate what the outcome of the calculations would be. If you explore the formulas you will see how I have linked the example delivery rates.
THE BRIEF:
Let users type in either full postcodes or part postcodes into the 'ENTER DELIVERY POSTCODE' column (column C on the 'CALCULATOR' tab). When they do this it would need to select the correct rate from the 'PRICE MATRIX' tab (this is the part that would need to be automated). The rate will depend on the 3 items listed above.
1) The number of pallets.
2) The service selected (nextday or economy).
3) The delivery postcode (a postcode is what we call a zip code in the UK).
This purpose of this spreadsheet is to demonstrate what the outcome of the calculations would be. If you explore the formulas you will see how I have linked the example delivery rates.
THE BRIEF:
Let users type in either full postcodes or part postcodes into the 'ENTER DELIVERY POSTCODE' column (column C on the 'CALCULATOR' tab). When they do this it would need to select the correct rate from the 'PRICE MATRIX' tab (this is the part that would need to be automated). The rate will depend on the 3 items listed above.