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 앱
기본 메뉴