An add-on for Google Sheets to compute flight emissions and typical flight emissions using the Travel Impact Model.
It supports two functions:
- FLIGHT_EMISSIONS
- TYPICAL_FLIGHT_EMISSIONS
Be sure to enable the Add-on in every new spreadsheet by going to Extensions > Flight Emissions for Sheets > Enable the Add-on in this spreadsheet.
You can then compute the emissions of specific flights with the FLIGHT_EMISSIONS function.
Parameters:
- origin: IATA airport code for flight origin, e.g. 'ZRH'. Can be a range of cells.
- destination: IATA airport code for flight destination, e.g. 'BOS'. Can be a range of cells.
- operating_carrier_code: IATA carrier code, e.g. 'LX'. Can be a range of cells.
- flight_number: Flight number, e.g. 54. Can be a range of cells.
- departure_date: Date of the flight in the time zone of the origin airport. Must be a date in the present or future, e.g. DATE(2024, 7, 1) or DATE(2024; 7; 1). Can be a range of cells.
- passenger_class: The class of the seat (economy, premiumEconomy, first, business) or the IATA/SSIM cabin code (Y=economy, W=premiumEconomy, F=first, C=business, ...). Can be a range of cells.
Returns:
- Emissions for one passenger in kilograms of CO2, or error message.
Full example:
=FLIGHT_EMISSIONS("ZRH", "BOS", "LX", 54, DATE(2024, 7, 1), "economy")
or:
=FLIGHT_EMISSIONS("ZRH"; "BOS"; "LX"; 54; DATE(2024; 7; 1); "economy")
You can also use it with cell ranges. If you have origin airports in column A, destination airports in column B etc:
=FLIGHT_EMISSIONS(A1:A2, B1:B2, C1:C2, D1:D2, E1:E2, F1:F2)
or:
=FLIGHT_EMISSIONS(A1:A2; B1:B2; C1:C2; D1:D2; E1:E2; F1:F2)
Warning: only future flights can be computed!
You can also compute the typical flight emissions between two airports with the TYPICAL_FLIGHT_EMISSIONS function.
Parameters:
- origin: IATA airport code for flight origin, e.g. 'ZRH'. Can be a range of cells.
- destination: IATA airport code for flight destination, e.g. 'BOS'. Can be a range of cells.
- passenger_class: The class of the seat (economy, premiumEconomy, first, business) or the IATA/SSIM cabin code (Y=economy, W=premiumEconomy, F=first, C=business, ...). Can be a range of cells.
Returns:
- Typical flight emissions for one passenger in kilograms of CO2, or error message.