Flight Emissions for Sheets

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.