Compute CO2 emissions of flights to understand your climate impact.
开发者:
应用详情更新日期:2023年9月28日
适用于:
2万+
概览
An add-on for Google Sheets to compute flight emissions.

Be sure to enable the Add-on in every new spreadsheet by going to Extensions > Flight emissions for Google 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!
其他信息
定价免费
开发者
Flight Emissions for Sheets”将请求获得以下权限。了解详情
Flight Emissions for Sheets”将需要访问您的 Google 账号
这样可让Flight Emissions for Sheets
查看和管理其中已安装此应用的电子表格
连接到外部服务
查看您的 Google 账号的主电子邮件地址
查看您的个人信息,包括您已公开的任何个人信息
评价
语言:
排序依据:
Google 不会核实评价或评分。 详细了解评价
没有评论
搜索
清除搜索内容
关闭搜索框
Google 应用
主菜单