An add-on for Google Sheets to compute specific future, typical, and past Scope 3 flight emission estimates using the Travel Impact Model.

It supports three functions:
- FLIGHT_EMISSIONS
- TYPICAL_FLIGHT_EMISSIONS
- SCOPE3_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 future 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 future or today, 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)

You can 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.

Finally, you can compute Scope 3 flight emissions for past flights (since 2019) for GHG reporting with the SCOPE3_FLIGHT_EMISSIONS function. Emissions are computed using cascading logic:
1. If you provide origin, destination, operating_carrier_code, flight_number, and departure_date, we return the estimated emissions for that specific flight.
2. If no specific flight is found, we compute typical emissions for the given origin, destination, and year (from departure_date).
3. If typical emissions are not found, we compute distance-based emissions with the given distance_km and year (from departure_date).

Parameters:
- origin: (Optional) IATA airport code for flight origin, e.g. 'ZRH'. Can be a range of cells.
- destination: (Optional) IATA airport code for flight destination, e.g. 'BOS'. Can be a range of cells.
- operating_carrier_code: (Optional) IATA carrier code, e.g. 'LX'. Can be a range of cells.
- flight_number: (Optional) 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, from 2019-01-01 onwards, e.g. DATE(2022, 7, 1) or DATE(2022; 7; 1). For the specific flight emissions, this date can be up to today. For typical and distance-based emissions, this can be up to the current year (i.e. future dates in the current year can only return typical or distance-based emissions). 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.
- distance_km: (Optional) Distance in kilometers, e.g. 1000. Can be a range of cells.
- emissions_type: (Optional) The type of emissions to return: "wtt" (well-to-tank), "ttw" (tank-to-wake), or "wtw" (well-to-wake). If omitted, an array of all three values is returned. Can be a range of cells.

Returns:
- Well-to-tank, tank-to-wake, and well-to-wake flight emissions for one passenger in kilograms of CO2 as an array of 3 values, or a single value if emissions_type is specified, or an error message.