Company A is a Finnish catering company based in Helsinki. They deliver food to companies up to 20 km away and have distance and weight-based pricing for their deliveries. 

Their prices look like this:

Below, you can see how this setup is made in the Excel template. You can download the sample Excel file in the bottom of this article, replace the prices with the prices from your carrier, and add more rows. Once the Excel template has been filled in, it can be uploaded using the CPC interface. Read more about file upload here: CPC Lesson 1 - Activation and file upload

Tabs in the Excel template

The following shows the tabs in the Excel sheet that are used to configure this use case. Names of fields and columns must remain exactly as in the template for the system to read and convert the Excel sheet to XML.

PriceCalculationSet

The main settings of the file. 

For a detailed explanation of each field, see CPC Excel template: PriceCalculationSet tab explained

Zone-DistanceInterval

The distance intervals are defined as zones:

Routes

Routes are defined based on the zones:

BasePrices

BasePrices are defined according to the weight intervals:

It is important to specify intervals correctly to avoid missing prices.
ValueFrom = included in the interval
ValueTo = up to but not included in the interval
The values in ValueFrom and ValueTo in consecutive intervals must always be identical to avoid intervals without prices.

Download sample file

The "Distance" file contains all the tabs and values from the use case.