Compute CO2 emissions of flights to understand your climate impact.
開發者:
商店資訊更新日期:2025年6月4日
適用裝置:
2萬+
總覽
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.
其他資訊
定價無須支付費用
開發人員
Flight Emissions for Sheets 將會要求下方所示的權限。瞭解詳情
Flight Emissions for Sheets 將需要存取您的 Google 帳戶
這項操作將授予「Flight Emissions for Sheets」下列權限:
查看及管理已安裝這個應用程式的試算表
連線至外部服務
查看您的主要 Google 帳戶電子郵件地址
查看您的個人資訊,包括您已公開的任何個人資訊
評論
語言:
排序依據:
Google 不會驗證評論或評分。 進一步瞭解評論內容
沒有留言
搜尋
清除搜尋內容
關閉搜尋
Google 應用程式
主選單