Spreadsheet Function To Calculate Emissions from Vehicles by Type

CO2VEHICLETYPE function:
Emissions from Vehicles (by Type).

This calculates the footprint of a passenger vehicle based on its Type and Size, for a specific distance. For Scope 1, this should be used to report travel in vehicles that are owned or controlled by the reporting organization. If not owned/controlled by organization, the vehicle's emission is reported under Scope 3. This function is also used to calculate emissions related to employee business travel (including commuting) through trains, bus and taxis.

Introduction

Approach

We use emission factors, data, guidelines from sources like UK Government GHG factors, US Department of Energy, US Environmental Protection Agency and UK Society of Motor Manufacturers and Traders.

The function to calculate the emission takes the category of vehicle based on its type or size, the type of fuel that is used and the distance travelled in either miles or kilometers.

WTT (well-to-tank) emissions consist of all processes between the source of the fuel (the well) through the extraction, processing (refining), storage and delivery phases up until the point of use (the tank) in the vehicle. Using the "include_wtt" field will add the associated upstream emission.

Parameters

vehicle_type : Mandatory. The acceptable values are the following: Car-Type-Mini, Car-Type-Supermini, Car-Type-LowerMedium, Car-Type-UpperMedium, Car-Type-Executive, Car-Type-Luxury, Car-Type-Sports, Car-Type-4x4, Car-Type-MPV, Car-Size-Small, Car-Size-Medium, Car-Size-Large, Car-Size-Average, Motorbike-Size-Small, Motorbike-Size-Medium, Motorbike-Size-Large, Motorbike-Size-Average, Bus-LocalAverage, Bus-Coach, Taxi-Local, Train-National, Train-Local and Train-Tram.
distance_value : Mandatory. The distance travelled by vehicle.
distance_unit : Mandatory. The acceptable values are "km" for kilometers and "mi" for miles. This will default to "km", if any other value is passed.
fuel_type : Optional. There are 3 possible values here: Diesel, Petrol and Unknown. If in doubt, select the Unknown value, which is also the default.
include_wtt : Optional. As explained above. The default value is "Y".

Usage

Example

CO2VEHICLETYPE(vehicle_type, distance_value, distance_unit, [fuel_type], [include_wtt])

CO2VEHICLETYPE("Car-Type-Executive","11250","km","Unknown","Y")

Notes:

If you know the make and model of vehicle, we suggest to use this alternative function for more accurate results.
WTT is an optional factor in calculation. While it is your decision to include/exclude it, we suggest the calculations are consistent with that choice, esp when the results are compared between periods.