Company X is based in Denmark. They ship pallets to Norway, and the carrier's prices are calculated based on pallet type and postcode in Norway. In addition to the base prices, they also pay a diesel fee. 

The price sheet from the carrier:

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 be able 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

Zones-CountryList

Zones and country code:

CountryList-ZipCodeInterval

Postcode ranges are defined in zones:

Routes

Routes are defined based on the zones:

The SenderZone is not defined because it is irrelevant to the price calculation in this example. 

BasePrices

The BasePrices are set to 0 because Pallets are defined as goods types and are considered a fee the way the prices are calculated. 

GoodsTypes-1

The price of the HalfPallet is defined for each route. Order determines the order in which different values are calculated to make up the total price. 

GoodsTypes-2

Euro pallet and the price for each route. Prices differ depending on the number of pallets.

Fees-1

The diesel fee of 33% is defined here. Notice that "IndicatorBasis" is set to ToPreviousValue, which means that it will be calculated based on the price of the pallets. Order is higher than under the previous tabs to make sure that the diesel fee is calculated after the price for each goods type. 

Download sample file

The "CustomerName - CarrierName - Pallets" file contains all the values from the use case.