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 应用
主菜单