Self-serve rate card import
Uploading rate cards for carriers you connect with
To use a non parcel carrier, you will need to add a rate card
A rate card simply shows where a carrier will deliver to and how much that delivery will cost...
If you are using ROUTE in Event you will need to connect to carriers. To allocate routes to your connected carrier you need a rate card.
Carriers in Event have a standard universal rate card or you can arrange and negotiate your own rates.
This guide assumes you have created an account with a carrier, connected to them through Event and now need to upload your negotiated rate card so you can start allocating routes.
Connect and allocate
-
Decide on a carrier and create an account [contract] with the carrier (outside of Event)
-
Connect to your chosen carrier through Event*
-
Receive a 'carrier now connected' notification
-
Create a rate card, upload.
-
Start allocating routes to your carrier
* A carrier will add themselves to EVENT through being invited. They only need to be invited once and in doing so will create access, login details and a 'connected' presence in the Event ecosystem overall for all current and future Accounts to connect to. You just need to upload a rate card..
Use the rate card template below and follow the instructions here to upload it.
* There is not set requirement for naming a rate card upload file. We will add a date time stamp to make sure it is unique
Do not change the format of these rate cards!
Download, change the date but not the headers or the tab names
Which rate card do i use?
The rate card templates are simply based on the a tariff in WEIGHT or PALLET based.
Are you adding a groupage pallet tariff or one based on weight?
hint: FTL is always added as weight.
See the examples below to help you quickly create a rate card.
If creating an FTL tariff, use the Template 1. This includes EXW.
If creating an Groupage PALLET based tariff, use the Template 1
If creating an Groupage WEIGHT based tariff, use the Template 2
Standard plt / weight tariff
click to
download
Template 1
FTL all postcode Rate card template PLT - Day / night / weekend / holiday
19-04-2023 - AP
Hint: Any postcodes not used can be added as '0' rate to be used as adhoc
This tariff includes where a carrier provides different costs based on the time of day or day of week
It is only for the FTL sheet, not for Groupage
Column J cannot be used if any of columns O-T are being used. Leave J as = blank
Column U can be used with either column J or columns O-T. It can also be used on its own.
The daytime setting can be configured in AccountVITALS / Setup Basics / Rate Card
Bank holidays can be configured in AccountVITALS / Setup Basics / Holidays
The headers for columns O-U will be used to show as the servie in Change Carrier
Template 2
Groupage all UK postcode rate card template PLT. Upto 10 plts
12-02-2019 - AP
Hint: Any postcodes not used can be added as '0' rate to be used as adhoc
Template 3
Rate card template weight - Groupage
12-02-2019 - AP
Hint: Its important to define if the Groupage tariff is per weight band or pallet. The excel spreed sheet tab defines this
Template 4
Rate card template weight bands- Groupage
17-09-2021 - AP
This function includes 2 new columns. 'PER' column and 'ROUNDING' column.
PER = rate per kg. This can be 1 as std or 100kg
ROUNDING = set to round by, e.g. 10 (to mearest 10)
The PER calculation example is:
99-250kg line in tariff
rate = 39.98
Set PER rate as 100kg
Shipped 145kg
Set rounding to 10kg (nearest 10kg) so 150kg
calculated rate = 39.98 x 1.5
Template 4a
Rate card template weight bands with minimum charge
14-09-2022 - AP
Template 5
Template 5
Rate card template pallet per lifts - Groupage
17-09-2021 - AP
This function is the standard Groupage rate card by pallet.
The difference is a configuration to set between per plt or per lift.
This Lift configuration will use the stackability from the Stop. If 7 plts and stackable, lifts = 3 lifts
The default is per pallet.
Groupage rate card by m3
Template 6
GRP rate card by m3
08-05-2021 - AP
Hint: Any postcodes not used can be added as '0' rate to be used as adhoc
Use column F & G for calculating Stop volume (10-15 m3 band = 4.50 x total m3)
Use column H & I for calculating Stop volume as a fixed total cost (10-15 m3 band = 180.00 fixed rate)
To set the calcuation at PLANNED or DESPATCHED status, use the configuration in Carrier VITALS
To speed up creating multi equipment type FTL rate cards...
Template 7
FTL x3 equipment types UK postcodes template
12-02-2019 - AP
Template 8
FTL x2 equipment types UK postcodes template
12-02-2019 - AP
Distance tariff by metric
Template 9
Distance tariff from a source point
12-02-2019 - AP
This distance tariff allows for a cost to be calculated from a source postcode and by a metric, i.e. per tonne
Distance tariff from point A-B
Template 10
Distance tariff from a source point
12-02-2019 - AP
This distance tariff allows for a cost to be calculated based on the actual distance banding from any location to any location.
It is not dependant on any metric, simply a cost per distance by an equipment type
Day rate tariff
A day rate tariff is a rate that a carrier charges for either a specific amount of time or a set distance.
Using the day rate tariff in Event will impact the way in which a rate is calculated in ROUTE2.
A user can select a Day Rate carrier, see the rate in Change Carrier.
To create a connected Day of trips for a vehicle, the user cn drag a route onto the Day rate route line.
The route will be updated with a Trip number automatically
Template 11
Day rate tariff for distance or time
25-02-2021 - AP
Max distance
Max distance = the maximum distance this vehicle can travel in 1 day for the tariff. Either set to 99999 to activate TIME columns or add in the actual max distance.
To use only mileage as a calculator, you need to set the time band as 00:00 - 23:59. This will ignore the time.
To / From Band Time
To / From Band Time =This time is used to determine the starting and ending time of this vehicle.
To / From Band Time =This time is used to determine the starting and ending time of this vehicle.
to use only the time band as a claculator, you need to set the max mileage as 99999
How does Day Rate tariff work in ROUTE2?
Day Rates are basically FLEET routing. A Day Rate is all about getting as many trips per day from the vehicle for a set price.
A Day Rate carrier will do as many routes in one day as possible. We call these connected routes 'Trips'.
For example:
-
Day Rate carrier vehicle 1, 1st route = Trip 1.1
-
Day Rate carrier vehicle 1, 2nd route = Trip 1.2
-
Day Rate carrier vehicle 1, 3rd route = Trip 1.3
-
Day Rate carrier vehicle 2, 1st route = Trip 2.1
-
Day Rate carrier vehicle 2, 2nd route = Trip 2.2
To create a Trip you must allocate the route to a carrier that has a Day Rate.
To create a multi trip you can drag any Route onto the Trip.
To change the Trip sequence you do this in Route Detail for the Trip.
To change from a Day Rate carrier you Change Carrier.
The cost for a Day Rate is based on the tariff. The tariff will be based on the total distance or total time.
If distance, the logic is:
-
The distance for a Trip, double it to create the return leg
-
The distance is fixed for the tariff, so ROUTE2 will not let a user add a trip if the total distance for all trips is greater than the max mileage
-
Example: Tariff = max 300 miles. Trip 1.1 = 100miles return, Trip 1.2 = 100 miles return, Trip 1.3 = 102 miles return, then Trip 1.3 cannot be added as 2 miles over agreement.
-
The time tariff is calculated as the total time for the Trips plus waiting time.
-
Time is a return time. In ROUTE2 we only show 1 way, you will need to double this if Day Rate carrier
-
There is a 45 min waiting / loading / unloading time
If time, the logic is:
So you can recognise it in ROUTE2. Now create your rate card.
To create a FLEET Route you need to allocate to your Day Rate carrier. The Route will show the 'return trip' icon and a TRIP NUMBER
You can also change view and look at the Gant view
So you can recognise it in ROUTE2. Now create your rate card.
Parcel tariff by service
Template 12
Parcel tariff by weight and service
11-10-2021 - AP
Tariff for calculating parcel wieght and service through SLM rules
Do I have to create a file per carrier?
No. To make it easier you can add all carriers onto 1 file and import or create separately. Decision is yours...
What if i want to use a carrier but i have no rate card?
You do not need to add a rate card for a carrier to be able to use the carrier in Event.
Using Event's 'Spot Rate' function lets you allocate to any carrier at any time
How does Spot Rate work?
How to build a rate card
Groupage, FTL, EXW carriers all need a rate card in Event...
This guide will step through how to build a rate card
For a carrier to be available in Event, they must have a rate for the destination. The rate can be 0.00. Use the template provided below.
A rate card is added based on being a weight based rate card or PLT based. If you are adding a Groupage tariff for weight use the weight card, it PLT use the PLT card. For FTL it is always imported as weight.
When complete please e-mail currently to: antony.pratt@3t-europe.com Email header: Rate Card Upload. Environment: QA, LIVE Carrier name
For a carrier to be available in Event, they must have a rate for the destination. The rate can be 0.00. Use the template provided below.
Rate Card Validation
So once you have uploaded a rate card, AMI will validate the contents and notify you of the result.
The validation will include format and contents, providing information, where a failure occurs on what the failure is.
Initial validation that must be passed to proceed;
1. Correct column headers
Validation will fail if the headers are named differently to the template.
Validation error message ' Column headers are not named correctly'
2. Correct order of the columns
Validation will fail if the columns are not in the correct position.
Validation error message ' Columns are not in the required positions'
3. Carrier ID
Validation will pass if the carrier ID exists on the Account being uploaded to and will fail if the carrier does not exist in Account receiving upload.
Validation error message for notification and storing ' Carrier ID must match the carrier's code in Carrier VITALS'
Specific validation
1. Origin country
Is required. Format is ISO code.
Validation error message ' Add a valid ISO 2 digit country code, i.e. US, GB'
2. Origin code
Is required. Format can be numbers or letters. CV, 01, 850.
Validation error message 'Valid post or area code required in the format of at least the 1st 2 digits of the code, i.e. CV, 11, 98'
3. Destination country
Is required. Format ISO code.
Validation error message ' Add a valid ISO 2 digit country code, i.e. US, GB'
4. Destination code
Is required. Format can be numbers or letters. CV22 6HL, CV22, CV, 01, 01000, 10000. Validation error message 'Valid post or area code required in the format of at least the 1st 2 digits of the code, i.e. CV22, 11, 98'
5. FromBand
Is required. A number of at least 0. Can be format 1.000000001.
Validation error message 'Must add a number in the format 1'
Example: for FTL this would be 1
6. ToBand
Is required. A number of at least 0. Can be format 1.000000001 if Groupage.
Validation error message 'Must add a number in the format 2.000000001'
Example: for FTL this would be 99999
7. Stop rate
Is required if Delivery type = FTL. Format must be 0.00.
Validation error message ''Rate must be included for FTL and cannot be left empty. It can be 0.00'
8. Equipment
Is required. Validate the equipment type against the Account Equipment database and if a match can be found allow, if no match fail validation.
Validation error message '[failed equipment name] is not a valid equipment type for this Account. Please use a valid type or update your equipment'
9. SLM rule
Not required. Default is blank. This is a specialist rule for RULE ASSIST only.
Max characters = 10
Validation error message where not matching rule is found in SLM 'No matching rule found in Route Assist rules'
To use this rule, ROUTE ASSIST rules for the carrier must match those in the rate card.
To use this function, add the SLM rules to the ROUTE ASSIST column called 'Groupage type'
*this rule will lookup ROUTE ASSIST rule, take the associated Groupage Type and when looking up the rate card, will look to match a SLM rule to the Groupage type added.
10. Mode
Is required. Must be LAND, AIR or SEA. AMI will default to LAND if not added. If added but not one of the 3...
Validation error message 'Mode must equal LAND, SEA or AIR in this format'
11. Service
Is required. Default is Economy. AMI will default to Economy if not added.
If added but not Economy, check for match in Account's Service and update.
No validation message.
12. Delivery type
Is required. Must be '2' for FTL or '4' for Groupage.
Validation error message 'Delivery type must be '4' for GROUPAGE or '2' for FTL'
13. Cost
Is required. validation just a number. Must be a number in format 0.00, 200.00. Can be 0.00 if no rate is known.
Validation error message 'A rate must be included and cannot be left empty. Format is 0.00. It can even be 0.00'