2. Main Tab
Pressing New opens the editor and creates a new PriceSheet from scratch. Because of the high degree of customization there are countless ways in which a PriceSheet can be set up. The following will provide you with the knowledge needed to write a correct PriceSheet from a weight vs distance matrix.
2.1 General Settings
This section contains the fields Name, Comment, Valid from and Valid to:
Name will be the file’s title as it appears in the CPC Center grid and Comment represents a small description about the file’s function and it is not mandatory like the Name. Also it is necessary to fill the interval for which the PriceSheet is valid. As expected the interval end date needs to be greater than what was entered in Valid from. Only the start date is mandatory, a blank Valid to field representing the fact that the PriceSheet never expires.
2.2 Calculation Type
There are up to four parameters that define the calculation method for each PriceSheet.
Very basic PriceSheet calculations are influenced by factors such as Weight, Volume or a comparing value called MaxWeightAndVolumeWeight.
If Weight is chosen as the basic Measurement for all price calculations in the PriceSheet then the price will vary according to weight. Later, when configuring the Prices tab the user will be able to configure how the price is influenced by weight.
The same applies for Volume.
MaxWeightAndVolumeWeight should be selected when a selection between a given weight and an equivalent VolumeWeight is required. The conversion from volume to an equivalent weight is handled by a constant marked Cubic meter calculated from a value provided by the carrier. With this method the largest value between the actual Weight and VolumeWeight is taken as the basis for all calculations.
Loadmeter works in the same way as Weight and is applicable to freight shipments with the quantity entered in the LoadMeter field as the basis for all calculations.
Similarly to MaxWeightAndVolumeWeight there is a method that compares an additional LoadmeterWeight element to Weight and VolumeWeight called MaxTWeightAndTVolumeWeightAndTLoadmeterWeight. The largest of these three values will constitute the basis for price calculations. As in the previous case LoadmeterWeight is calculated by using a specific conversion factor from the field Load Meter.
Choosing Package or Pallet means the basis for all calculations will be the number of packages or pallets provided.
GoodsType is used for quotes that tax a specific type of cargo. In this case the basis for price calculations will be influenced by the number of targeted GoodsTypes found inside the shipment.
The selection made here affects whether the calculation is made at the line level with PerPackage or for the entire shipment with PerShipment.
The field is mandatory and some restrictions apply. For example Fees on GoodsType cannot be enforced unless PerPackage is selected.
CPC supports distance based calculations. If the PriceSheet requires a distance input, then a distance covering method has to be specified:
Often two locations can be linked through more than one way thus creating short and long routes. The user must choose between the Fastest or the Shortest available routes. Once selected the distance will always be calculated according to the selected method and cannot be dynamically switched once the PriceSheet is uploaded and in use. The field is mandatory whenever a Distance method is chosen.
2.3 Price Settings
In this section the user chooses the Currency in which the prices are displayed and limits can be imposed on Min. price and Max. price values for which the calculation displays a result.
Results outside this defined range are displayed with a null value. It is common to use an unbounded value for Max. price.
The symbol * means all/any value.
2.4 Input Factors
Two Input Factors are used for conversions of VolumeWeight and LoadmeterWeight as mentioned previously Section 2.2.1
Load meter and Cubic meter are usually provided by the carrier and represent the amount that one unit of each type is charged in equivalent Weight. Because carriers may cite their loadmeter or volume values in different ways it is advisable to check the units and/or magnitude for the value attributed to these conversion factors.
To convert Volume to VolumeWeight a conversion constant called VolumeWeightFactor is employed and it is found in the PriceSheet XML. The value for this constant is derived from the input provided in the field Cubic meter.
VolumeWeightFactor=1000/(Cubic meter field value) [m3/ton]
[KG] represents the unit associated with VolumeWeight
[m3] for Volume
[m3/ton] for VolumeWeightFactor
2.5 Route Settings
The checkmark enables the Routes tab. Even when hidden in CPC Center the Routes are always contained in the PriceSheet XML.
The sections that follow will be introduced by covering the steps needed to map an implementation for a DHL Freight Weight vs Distance Matrix. The following is provided:
From the file we obtain information about the volume to weight conversion cited at 280 kg. MaxWeightAndVolumeWeight will be employed and the calculation will take place at PerPackage level. Since distances are involved Driving and Fastest will be the parameters for the corresponding zones.
The Main tab should look like this:
<Main Tab Pre-Filled again>
Press Save and the file is now a Draft.