Logistics CSV spreadsheet calculations

Overview

In this guide, you will learn how to calculate emissions for shipments by:

filling and uploading a CSV spreadsheet

This guide has been updated to reflect version 2 of spreadsheet calculations. However, we still support version 1 spreadsheets.

Who is this guide for?

This guide is aimed at Sustainability Specialists or Product Managers.

Feel free to contact our support team if you encounter any issues.

Calculations will count towards your tier limit, one per row.

logistics-csv-upload

Download CSV template

Navigate to the logistics spreadsheet calculation page.

Click on the 'Download CSV template' button to download the template.

There are 4 templates, one for every transport mode we support: rail, sea, road & air. Templates contain sample data. Amend and/or delete rows to fit your data. Combine the different transport modes into a shipment's legs for more complex journeys.

Do not delete the header row.

To test the flow, feel free to upload the template and see results.

Download CSV template

CSV format

Populate the CSV sheet using your preferred editor.

Ensure to save the file as csv with a .csv extension.

You may either omit or leave blank non-required columns.

Each row may contain up to 10 legs, only one leg is required. All legs have the same format, the table below describes all legs for correctness.

Files up to 2MB are supported

What to input?

Required inputs are:

Route or distance
Cargo weight
Transport mode

In addition, a value for version is required and must be set to 2.

Route or distance

Route

For shipment origin/destination, fill the source and eac leg{x}_destination column with one of the location types below:

A comma-seperated address, ending with a country code. Where the country code is a 3-letter ISO 3166 country code. This cannot be a country code alone, you must provide more than one address line.
```
Examples:
Apple Lane, London, SW1A 2AA, GBR
Ontario, CAN
```

A UN LOCODE. For a full list of options https://unece.org/trade/cefact/unlocode-code-list-country-and-territory.
An IATA or ICAO airport code
Geographical coordinates formatted as lat <number> lon <number>.

Example:
lat 12.33 lon -91.21

Distance

Input the distance in km in the column for leg1_distance_km. If you have distance data, you can use it instead of Route.

Cargo weight

Input either cargo weight in kg or in TEU, or both.

mass_kg: cargo weight in kilograms
containers: number of TEU (Twenty-foot Equivalent Units)

Transport mode

The transport method for the first leg is entered in leg1_method or leg1_vessel_identification or leg1_flight_number.

leg1_method: Must be in Lune’s accepted format. See the list of available transport methods in the Reference below. Examples: cargo_plane, container_ship, diesel_truck, truck_articulated_40t.
leg1_vessel_identification: The vessel's IMO number without the IMO prefix or a vessel name. When an identifier is provided, the leg's method is ignored.

The same format applies to let2_method, leg3_method, and so on.

Reference

versionenumrequired

The row's schema version.

Must be set to 2.

Enum:

shipment_idstring

Client shipment identifier

Acts as external id. The field represents the id in your system, which you may use to reconcile emission estimates.

client_account_idstring

The client account unique identifier.

When set, the emission estimate is stored against the client account.

For details in regards to Client Accounts visit https://docs.lune.co/general-concepts/accounts#client-accounts

client_account_handlestring^$|^[a-z0-9-_]+$

The client account handle is a unique user defined handle that identifies your customer.

A client account is created for every new handle and the emission estimate is stored against the client account.

If a client account is already associated with the handle, the emission estimate is stored against the existing client account.

For details in regards to Client Accounts visit https://docs.lune.co/general-concepts/accounts#client-accounts

Note: client_account_id takes precedence of client_account_handle.

client_account_external_pages_visibility

Controls the visibility of external pages such as sustainability and analytics pages. Defaults to hidden.

client_account_currencystring

The client account's currency.

This property must be set when client_account_handle is set.

You cannot overwrite a client account's currency.

client_account_namestring

The client account's name.

If no value is provided, this will equal the client account handle.

If client_account_name is different from the account's name in Lune's system, the account's name will be changed.

client_account_beneficiarystring

The client account's beneficiary.

This is the name that appears on future retirements that are made in this account. If none is present, the organisation beneficiary will be used instead.

If client_account_beneficiary is different from the account's beneficiary in Lune's system, the account's beneficiary will be changed.

is_shipmentenum

Is this an estimate for an actual shipment?

If left blank, false is used.

Enum:

true
false

shipped_at

The date and time of shipping the goods for the purpose of analytics (it doesn't affect emission calculations in any way).

If a value is provided when creating or updating an estimate we use the value. Otherwise defaults to the current time when creating estimates and remains unchanged when updating estimates.

This property must be formatted as RFC 3339, section 5.6 timestamp.

Examples:

2023-12-01T12:30:30.000Z
2023-12-01T12:30:30Z
2023-12-01T11:30:30+01.00

mass_kgstring^$|^[0-9]+(\.[0-9]+)?$

Shipment weight in kg.

One of mass_kg and containers is mandatory. You may provide both for more accurate estimates.

containersstring^$|^[0-9]+(\.[0-9]+)?$

Shipment in containers.

One of mass_kg and containers is mandatory. You may provide both for more accurate estimates.

source

Source location of shipment can be submitted in any of the formats defined below:

A comma-seperated address, ending with a country code. Where the country code is a 3-letter ISO 3166 country code. Cannot be a country code alone, must have more than one address line.

Examples: - Apple Lane, London, SW1A 2AA, GBR - Ontario, CAN
A UN LOCODE. For a full list of options https://unece.org/trade/cefact/unlocode-code-list-country-and-territory.
An IATA or ICAO airport code
Geographical coordinates formatted as 'lat <number> lon <number>'.

leg1_method

The transport method.

Required unless imo or vessel_name is provided.

Pick one of the following options.

Examples: cargo_plane, container_ship, diesel_truck.

leg1_destination

Source location of shipment can be submitted in any of the formats defined below:

A comma-seperated address, ending with a country code. Where the country code is a 3-letter ISO 3166 country code. Cannot be a country code alone, must have more than one address line.

Examples: - Apple Lane, London, SW1A 2AA, GBR - Ontario, CAN
A UN LOCODE. For a full list of options https://unece.org/trade/cefact/unlocode-code-list-country-and-territory.
An IATA or ICAO airport code
Geographical coordinates formatted as 'lat <number> lon <number>'.

leg1_refrigeratedenum

A container transport is either refrigerated or "dry" (not refrigerated). Dry transports result in lower emissions. For road transport this value is also taken in consideration if set to true, the appropriate refrigerated shipping method will be used.

Enum:

true
false

leg1_fuel

The vehicle's fuel.

Only supported for the following vehicles: truck_generic_van, truck_rigid_7_5t, truck_rigid_12t, truck_rigid_20t, truck_rigid_26t, truck_rigid_32t, truck_articulated_34t, truck_articulated_40t

leg1_trade_lane

trade_lane requires method to be `container_ship'.

leg1_departure_onstring^$|^[0-9]{4}-(1[0-2]|0[1-9])-(3[01]|[12][0-9]|0[1-9])$

The date of the departure from the previous leg's location.

Vessel tracking is only available for shipments that finished more than 24 hours ago. If leg1_departure_on and leg1_arrival_on and leg1_vessel_identification is provided, vessel tracking will be attempted.

leg1_arrival_onstring^$|^[0-9]{4}-(1[0-2]|0[1-9])-(3[01]|[12][0-9]|0[1-9])$

The date of arrival at the leg's destination.

leg1_vessel_identificationstring

The vessel's IMO number without the IMO prefix. OR The vessel's name. If an IMO is provided this property will be unused. When an identifier is provided, the leg's method is ignored.

leg1_flight_numberstring

Flight number in either ICAO or IATA format.

Requires leg1_departure_on.

leg1_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Shipment's distance for a given leg.

leg2_method

The transport method.

Required unless imo or vessel_name is provided.

Pick one of the following options.

Examples: cargo_plane, container_ship, diesel_truck.

leg2_destination

Source location of shipment can be submitted in any of the formats defined below:

A comma-seperated address, ending with a country code. Where the country code is a 3-letter ISO 3166 country code. Cannot be a country code alone, must have more than one address line.

Examples: - Apple Lane, London, SW1A 2AA, GBR - Ontario, CAN
A UN LOCODE. For a full list of options https://unece.org/trade/cefact/unlocode-code-list-country-and-territory.
An IATA or ICAO airport code
Geographical coordinates formatted as 'lat <number> lon <number>'.

leg2_refrigeratedenum

Enum:

true
false

leg2_fuel

The vehicle's fuel.

leg2_trade_lane

trade_lane requires method to be `container_ship'.

leg2_departure_onstring^$|^[0-9]{4}-(1[0-2]|0[1-9])-(3[01]|[12][0-9]|0[1-9])$

The date of the departure from the previous leg's location.

leg2_arrival_onstring^$|^[0-9]{4}-(1[0-2]|0[1-9])-(3[01]|[12][0-9]|0[1-9])$

The date of arrival at the leg's destination.

leg2_vessel_identificationstring

The vessel's IMO number without the IMO prefix. OR The vessel's name. If an IMO is provided this property will be unused. When an identifier is provided, the leg's method is ignored.

leg2_flight_numberstring

Flight number in either ICAO or IATA format.

Requires leg1_departure_on.

leg2_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Shipment's distance for a given leg.

leg3_method

The transport method.

Required unless imo or vessel_name is provided.

Pick one of the following options.

Examples: cargo_plane, container_ship, diesel_truck.

leg3_destination

Source location of shipment can be submitted in any of the formats defined below:

A comma-seperated address, ending with a country code. Where the country code is a 3-letter ISO 3166 country code. Cannot be a country code alone, must have more than one address line.

Examples: - Apple Lane, London, SW1A 2AA, GBR - Ontario, CAN
A UN LOCODE. For a full list of options https://unece.org/trade/cefact/unlocode-code-list-country-and-territory.
An IATA or ICAO airport code
Geographical coordinates formatted as 'lat <number> lon <number>'.

leg3_refrigeratedenum

Enum:

true
false

leg3_fuel

The vehicle's fuel.

leg3_trade_lane

trade_lane requires method to be `container_ship'.

leg3_departure_onstring^$|^[0-9]{4}-(1[0-2]|0[1-9])-(3[01]|[12][0-9]|0[1-9])$

The date of the departure from the previous leg's location.

leg3_arrival_onstring^$|^[0-9]{4}-(1[0-2]|0[1-9])-(3[01]|[12][0-9]|0[1-9])$

The date of arrival at the leg's destination.

leg3_vessel_identificationstring

The vessel's IMO number without the IMO prefix. OR The vessel's name. If an IMO is provided this property will be unused. When an identifier is provided, the leg's method is ignored.

leg3_flight_numberstring

Flight number in either ICAO or IATA format.

Requires leg1_departure_on.

leg3_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Shipment's distance for a given leg.

leg4_method

The transport method.

Required unless imo or vessel_name is provided.

Pick one of the following options.

Examples: cargo_plane, container_ship, diesel_truck.

leg4_destination

Source location of shipment can be submitted in any of the formats defined below:

A comma-seperated address, ending with a country code. Where the country code is a 3-letter ISO 3166 country code. Cannot be a country code alone, must have more than one address line.

Examples: - Apple Lane, London, SW1A 2AA, GBR - Ontario, CAN
A UN LOCODE. For a full list of options https://unece.org/trade/cefact/unlocode-code-list-country-and-territory.
An IATA or ICAO airport code
Geographical coordinates formatted as 'lat <number> lon <number>'.

leg4_refrigeratedenum

Enum:

true
false

leg4_fuel

The vehicle's fuel.

leg4_trade_lane

trade_lane requires method to be `container_ship'.

leg4_departure_onstring^$|^[0-9]{4}-(1[0-2]|0[1-9])-(3[01]|[12][0-9]|0[1-9])$

The date of the departure from the previous leg's location.

leg4_arrival_onstring^$|^[0-9]{4}-(1[0-2]|0[1-9])-(3[01]|[12][0-9]|0[1-9])$

The date of arrival at the leg's destination.

leg4_vessel_identificationstring

The vessel's IMO number without the IMO prefix. OR The vessel's name. If an IMO is provided this property will be unused. When an identifier is provided, the leg's method is ignored.

leg4_flight_numberstring

Flight number in either ICAO or IATA format.

Requires leg1_departure_on.

leg4_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Shipment's distance for a given leg.

leg5_method

The transport method.

Required unless imo or vessel_name is provided.

Pick one of the following options.

Examples: cargo_plane, container_ship, diesel_truck.

leg5_destination

Source location of shipment can be submitted in any of the formats defined below:

A comma-seperated address, ending with a country code. Where the country code is a 3-letter ISO 3166 country code. Cannot be a country code alone, must have more than one address line.

Examples: - Apple Lane, London, SW1A 2AA, GBR - Ontario, CAN
A UN LOCODE. For a full list of options https://unece.org/trade/cefact/unlocode-code-list-country-and-territory.
An IATA or ICAO airport code
Geographical coordinates formatted as 'lat <number> lon <number>'.

leg5_refrigeratedenum

Enum:

true
false

leg5_fuel

The vehicle's fuel.

leg5_trade_lane

trade_lane requires method to be `container_ship'.

leg5_departure_onstring^$|^[0-9]{4}-(1[0-2]|0[1-9])-(3[01]|[12][0-9]|0[1-9])$

The date of the departure from the previous leg's location.

leg5_arrival_onstring^$|^[0-9]{4}-(1[0-2]|0[1-9])-(3[01]|[12][0-9]|0[1-9])$

The date of arrival at the leg's destination.

leg5_vessel_identificationstring

The vessel's IMO number without the IMO prefix. OR The vessel's name. If an IMO is provided this property will be unused. When an identifier is provided, the leg's method is ignored.

leg5_flight_numberstring

Flight number in either ICAO or IATA format.

Requires leg1_departure_on.

leg5_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Shipment's distance for a given leg.

leg6_method

The transport method.

Required unless imo or vessel_name is provided.

Pick one of the following options.

Examples: cargo_plane, container_ship, diesel_truck.

leg6_destination

Source location of shipment can be submitted in any of the formats defined below:

A comma-seperated address, ending with a country code. Where the country code is a 3-letter ISO 3166 country code. Cannot be a country code alone, must have more than one address line.

Examples: - Apple Lane, London, SW1A 2AA, GBR - Ontario, CAN
A UN LOCODE. For a full list of options https://unece.org/trade/cefact/unlocode-code-list-country-and-territory.
An IATA or ICAO airport code
Geographical coordinates formatted as 'lat <number> lon <number>'.

leg6_refrigeratedenum

Enum:

true
false

leg6_fuel

The vehicle's fuel.

leg6_trade_lane

trade_lane requires method to be `container_ship'.

leg6_departure_onstring^$|^[0-9]{4}-(1[0-2]|0[1-9])-(3[01]|[12][0-9]|0[1-9])$

The date of the departure from the previous leg's location.

leg6_arrival_onstring^$|^[0-9]{4}-(1[0-2]|0[1-9])-(3[01]|[12][0-9]|0[1-9])$

The date of arrival at the leg's destination.

leg6_vessel_identificationstring

The vessel's IMO number without the IMO prefix. OR The vessel's name. If an IMO is provided this property will be unused. When an identifier is provided, the leg's method is ignored.

leg6_flight_numberstring

Flight number in either ICAO or IATA format.

Requires leg1_departure_on.

leg6_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Shipment's distance for a given leg.

leg7_method

The transport method.

Required unless imo or vessel_name is provided.

Pick one of the following options.

Examples: cargo_plane, container_ship, diesel_truck.

leg7_destination

Source location of shipment can be submitted in any of the formats defined below:

A comma-seperated address, ending with a country code. Where the country code is a 3-letter ISO 3166 country code. Cannot be a country code alone, must have more than one address line.

Examples: - Apple Lane, London, SW1A 2AA, GBR - Ontario, CAN
A UN LOCODE. For a full list of options https://unece.org/trade/cefact/unlocode-code-list-country-and-territory.
An IATA or ICAO airport code
Geographical coordinates formatted as 'lat <number> lon <number>'.

leg7_refrigeratedenum

Enum:

true
false

leg7_fuel

The vehicle's fuel.

leg7_trade_lane

trade_lane requires method to be `container_ship'.

leg7_departure_onstring^$|^[0-9]{4}-(1[0-2]|0[1-9])-(3[01]|[12][0-9]|0[1-9])$

The date of the departure from the previous leg's location.

leg7_arrival_onstring^$|^[0-9]{4}-(1[0-2]|0[1-9])-(3[01]|[12][0-9]|0[1-9])$

The date of arrival at the leg's destination.

leg7_vessel_identificationstring

The vessel's IMO number without the IMO prefix. OR The vessel's name. If an IMO is provided this property will be unused. When an identifier is provided, the leg's method is ignored.

leg7_flight_numberstring

Flight number in either ICAO or IATA format.

Requires leg1_departure_on.

leg7_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Shipment's distance for a given leg.

leg8_method

The transport method.

Required unless imo or vessel_name is provided.

Pick one of the following options.

Examples: cargo_plane, container_ship, diesel_truck.

leg8_destination

Source location of shipment can be submitted in any of the formats defined below:

A comma-seperated address, ending with a country code. Where the country code is a 3-letter ISO 3166 country code. Cannot be a country code alone, must have more than one address line.

Examples: - Apple Lane, London, SW1A 2AA, GBR - Ontario, CAN
A UN LOCODE. For a full list of options https://unece.org/trade/cefact/unlocode-code-list-country-and-territory.
An IATA or ICAO airport code
Geographical coordinates formatted as 'lat <number> lon <number>'.

leg8_refrigeratedenum

Enum:

true
false

leg8_fuel

The vehicle's fuel.

leg8_trade_lane

trade_lane requires method to be `container_ship'.

leg8_departure_onstring^$|^[0-9]{4}-(1[0-2]|0[1-9])-(3[01]|[12][0-9]|0[1-9])$

The date of the departure from the previous leg's location.

leg8_arrival_onstring^$|^[0-9]{4}-(1[0-2]|0[1-9])-(3[01]|[12][0-9]|0[1-9])$

The date of arrival at the leg's destination.

leg8_vessel_identificationstring

The vessel's IMO number without the IMO prefix. OR The vessel's name. If an IMO is provided this property will be unused. When an identifier is provided, the leg's method is ignored.

leg8_flight_numberstring

Flight number in either ICAO or IATA format.

Requires leg1_departure_on.

leg8_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Shipment's distance for a given leg.

leg9_method

The transport method.

Required unless imo or vessel_name is provided.

Pick one of the following options.

Examples: cargo_plane, container_ship, diesel_truck.

leg9_destination

Source location of shipment can be submitted in any of the formats defined below:

A comma-seperated address, ending with a country code. Where the country code is a 3-letter ISO 3166 country code. Cannot be a country code alone, must have more than one address line.

Examples: - Apple Lane, London, SW1A 2AA, GBR - Ontario, CAN
A UN LOCODE. For a full list of options https://unece.org/trade/cefact/unlocode-code-list-country-and-territory.
An IATA or ICAO airport code
Geographical coordinates formatted as 'lat <number> lon <number>'.

leg9_refrigeratedenum

Enum:

true
false

leg9_fuel

The vehicle's fuel.

leg9_trade_lane

trade_lane requires method to be `container_ship'.

leg9_departure_onstring^$|^[0-9]{4}-(1[0-2]|0[1-9])-(3[01]|[12][0-9]|0[1-9])$

The date of the departure from the previous leg's location.

leg9_arrival_onstring^$|^[0-9]{4}-(1[0-2]|0[1-9])-(3[01]|[12][0-9]|0[1-9])$

The date of arrival at the leg's destination.

leg9_vessel_identificationstring

The vessel's IMO number without the IMO prefix. OR The vessel's name. If an IMO is provided this property will be unused. When an identifier is provided, the leg's method is ignored.

leg9_flight_numberstring

Flight number in either ICAO or IATA format.

Requires leg1_departure_on.

leg9_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Shipment's distance for a given leg.

leg10_method

The transport method.

Required unless imo or vessel_name is provided.

Pick one of the following options.

Examples: cargo_plane, container_ship, diesel_truck.

leg10_destination

Source location of shipment can be submitted in any of the formats defined below:

A comma-seperated address, ending with a country code. Where the country code is a 3-letter ISO 3166 country code. Cannot be a country code alone, must have more than one address line.

Examples: - Apple Lane, London, SW1A 2AA, GBR - Ontario, CAN
A UN LOCODE. For a full list of options https://unece.org/trade/cefact/unlocode-code-list-country-and-territory.
An IATA or ICAO airport code
Geographical coordinates formatted as 'lat <number> lon <number>'.

leg10_refrigeratedenum

Enum:

true
false

leg10_fuel

The vehicle's fuel.

leg10_trade_lane

trade_lane requires method to be `container_ship'.

leg10_departure_onstring^$|^[0-9]{4}-(1[0-2]|0[1-9])-(3[01]|[12][0-9]|0[1-9])$

The date of the departure from the previous leg's location.

leg10_arrival_onstring^$|^[0-9]{4}-(1[0-2]|0[1-9])-(3[01]|[12][0-9]|0[1-9])$

The date of arrival at the leg's destination.

leg10_vessel_identificationstring

The vessel's IMO number without the IMO prefix. OR The vessel's name. If an IMO is provided this property will be unused. When an identifier is provided, the leg's method is ignored.

leg10_flight_numberstring

Flight number in either ICAO or IATA format.

Requires leg1_departure_on.

leg10_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Shipment's distance for a given leg.

Upload and wait for results

Once you've filled the sheet, drop the file in the appropriate box.

Depending on the size, it may take a few minutes to process the sheet.

You'll receive an email when the results are ready.

Please follow the link in your email to download the results.

We apply your API rate limit when processing a sheet.

Results

The following columns are added to the columns provided by you.

estimate_idstringrequired

The estimate's unique id.

To understand how we have calculated emissions, visit the following page:

https://dashboard.lune.co/calculate-emissions/multi-leg-shipping/<ESTIMATE_ID>/results

dashboard_urlstringrequired

The URL pointing to the specific emission calculation page in the Lune dashboard.

Here you can:

review your estimate
read how Lune has calculated your emissions
offset your emissions

client_account_analytics_urlstring

The URL pointing to the specific client account's analytics page.

This column is populated when client_account_handle is provided.

Here your customers can:

view their shipment analytics
view individual shipment estimates
read how Lune has calculated their emissions

total_mass_tco2string^$|^[0-9]+(\.[0-9]+)?$required

Overall emission estimate in tCO2e.

total_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$required

Overall shipment distance in km.

total_adjusted_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$required

Overall shipment distance in km inclusive of distance adjustment factors.

errorstringrequired

Describes the error that occured when processing the row.

When set, the row has failed to process and does not return results.

Please correct the provided data.

leg1_estimated_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$required

Leg estimated distance in km.

Equivalent to leg*_distance_km when leg*_distance_km is provided.

leg1_estimated_adjusted_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Leg estimated distance inclusive of distance adjustment factors in km.

leg1_total_tco2string^$|^[0-9]+(\.[0-9]+)?$required

Leg emission estimate in tCO2e.

leg2_estimated_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Leg estimated distance in km.

Equivalent to leg*_distance_km when leg*_distance_km is provided.

leg2_estimated_adjusted_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Leg estimated distance inclusive of distance adjustment factors in km.

leg2_total_tco2string^$|^[0-9]+(\.[0-9]+)?$

Leg emission estimate in tCO2e.

leg3_estimated_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Leg estimated distance in km.

Equivalent to leg*_distance_km when leg*_distance_km is provided.

leg3_estimated_adjusted_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Leg estimated distance inclusive of distance adjustment factors in km.

leg3_total_tco2string^$|^[0-9]+(\.[0-9]+)?$

Leg emission estimate in tCO2e.

leg4_estimated_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Leg estimated distance in km.

Equivalent to leg*_distance_km when leg*_distance_km is provided.

leg4_estimated_adjusted_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Leg estimated distance inclusive of distance adjustment factors in km.

leg4_total_tco2string^$|^[0-9]+(\.[0-9]+)?$

Leg emission estimate in tCO2e.

leg5_estimated_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Leg estimated distance in km.

Equivalent to leg*_distance_km when leg*_distance_km is provided.

leg5_estimated_adjusted_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Leg estimated distance inclusive of distance adjustment factors in km.

leg5_total_tco2string^$|^[0-9]+(\.[0-9]+)?$

Leg emission estimate in tCO2e.

leg6_estimated_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Leg estimated distance in km.

Equivalent to leg*_distance_km when leg*_distance_km is provided.

leg6_estimated_adjusted_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Leg estimated distance inclusive of distance adjustment factors in km.

leg6_total_tco2string^$|^[0-9]+(\.[0-9]+)?$

Leg emission estimate in tCO2e.

leg7_estimated_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Leg estimated distance in km.

Equivalent to leg*_distance_km when leg*_distance_km is provided.

leg7_estimated_adjusted_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Leg estimated distance inclusive of distance adjustment factors in km.

leg7_total_tco2string^$|^[0-9]+(\.[0-9]+)?$

Leg emission estimate in tCO2e.

leg8_estimated_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Leg estimated distance in km.

Equivalent to leg*_distance_km when leg*_distance_km is provided.

leg8_estimated_adjusted_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Leg estimated distance inclusive of distance adjustment factors in km.

leg8_total_tco2string^$|^[0-9]+(\.[0-9]+)?$

Leg emission estimate in tCO2e.

leg9_estimated_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Leg estimated distance in km.

Equivalent to leg*_distance_km when leg*_distance_km is provided.

leg9_estimated_adjusted_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Leg estimated distance inclusive of distance adjustment factors in km.

leg9_total_tco2string^$|^[0-9]+(\.[0-9]+)?$

Leg emission estimate in tCO2e.

leg10_estimated_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Leg estimated distance in km.

Equivalent to leg*_distance_km when leg*_distance_km is provided.

leg10_estimated_adjusted_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Leg estimated distance inclusive of distance adjustment factors in km.

leg10_total_tco2string^$|^[0-9]+(\.[0-9]+)?$

Leg emission estimate in tCO2e.

logistics-csv-drop

logistics-csv-email

Logistics CSV spreadsheet calculations

Overview​

Who is this guide for?​

Download CSV template​

CSV format​

What to input?​

Route or distance​

Cargo weight​

Transport mode​

Reference​

Upload and wait for results​

Results​

Overview

Who is this guide for?

Download CSV template

CSV format

What to input?

Route or distance

Cargo weight

Transport mode

Reference

Upload and wait for results

Results