Functions in Emissions Calculations in Excel
You use custom Microsoft Excel functions to calculate greenhouse gas (GHG) emissions, get more information about emission factors, and return results or metadata.
About these functions
In Excel, enter functions directly into the cells, or when the drop-down opens, select the appropriate function. Values in square brackets ( [ ] ) are optional.
Errors are shown as Excel error messages. For more information, see Errors in Excel.
You can use the auto-selected factor to calculate emissions, or you can specify a factor. For example, you might want to use a factor that is more appropriate to your region. For more information, see Viewing factor details.
Calculate scope 1: stationary emissions
Use the following function to calculate stationary emissions with the auto-selected factor:
=ENVIZI.STATIONARY(type, value, unit, country, [stateProvince], [date])
Use the following function to calculate stationary emissions with a factor that you selected:
=ENVIZI.STATIONARY_BY_FACTORID(factorId, value, unit)
| Column | Description |
|---|---|
| Total CO2e | The total emissions expressed as carbon dioxide equivalent (CO2e). This total is the sum of all greenhouse gasses (GHGs) weighted by their global warming potential (GWP). |
| CO2 | CO2 (carbon dioxide) emissions |
| CH4 | CH4 (methane) emissions |
| N2O | N2O (nitrous oxide) emissions |
| HFC | HFC (hydrofluorocarbon) emissions |
| PFC | PFC (Perfluorocarbon) emissions |
| SF6 | SF6 (sulfur hexafluoride) emissions |
| NF3 | NF3 (nitrogen trifluoride) emissions |
| bioCO2 | bioCO2 (biogenic carbon dioxide) emissions, if applicable |
| directCO2 | Direct CO2 emissions explicitly reported when available |
| Unit | Unit of measurement for the emissions result. |
| Description | Details of the factor set used in the calculation. |
| Transaction ID | Unique identifier for the calculation transaction. This ID is used for reference and auditing |
Calculate scope 1: mobile emissions
Use the following function to calculate mobile emissions with the auto-selected factor:
=ENVIZI.MOBILE(type, value, unit, country, [stateProvince], [date])
Use the following function to calculate mobile emissions with a factor that you selected:
=ENVIZI.MOBILE_BY_FACTORID(factorId, value, unit)
For a description of each result of the calculation, see Table 1.
Calculate scope 1: fugitive emissions
Use the following function to calculate fugitive emissions with the auto-selected factor:
=ENVIZI.FUGITIVE(type, value, unit, country, [stateProvince], [date])
Use the following function to calculate fugitive emissions with a factor that you selected:
=ENVIZI.FUGITIVE_BY_FACTORID(factorId, value, unit)
For a description of each result of the calculation, see Table 1.
Calculate scope 2: location emissions
Use the following function to calculate location emissions with the auto-selected factor:
=ENVIZI.LOCATION(type, value, unit, country, [stateProvince], [date], [powerGrid])
Use the following function to calculate location emissions with a factor that you selected:
=ENVIZI.LOCATION_BY_FACTORID(factorId, value, [unit])
For a description of each result of the calculation, see Table 1.
Calculate scope 3: transportation and distribution emissions
Use the following function to calculate transportation and distribution emissions with the auto-selected factor:
=ENVIZI.TRANSPORTATION_AND_DISTRIBUTION(type, value, unit, country, [stateProvince],
[date])
Use the following function to calculate transportation and distribution emissions with a factor that you selected:
=ENVIZI.TRANSPORTATION_AND_DISTRIBUTION_BY_FACTORID(factorId, value, unit)
For a description of each result of the calculation, see Table 1.
Calculate financed emissions
Use the following functions to calculate financed emissions for economic activity.
Use the following function to calculate emissions for economic activity with the auto-selected factor:
=ENVIZI.ECONOMIC_ACTIVITY(type, value, unit, country, [stateProvince],
[date])Use the following function to calculate emissions for economic activity with a factor that you selected:
=ENVIZI.ECONOMIC_ACTIVITY_BY_FACTORID(factorId, value,
unit)Use the following functions to calculate financed emissions for real estate.
=ENVIZI.REAL_ESTATE(type, value, unit, country, [stateProvince],
[date])Use the following function to calculate emissions for real estate with a factor that you selected:
=ENVIZI.REAL_ESTATE_BY_FACTORID(factorId, value, unit)For a description of each result of the calculation, see Table 1.
For more information about calculating financed emissions, see Calculating financed emissions
Calculate factors without a scope
Use the following functions to calculate emissions when scope information is not available.
Use the following function to calculate emissions with the auto-selected factor:
=ENVIZI.CALCULATION(type, value, unit, country, [stateProvince], [date],
[powerGrid])
Use the following function to calculate emissions with a factor that you selected:
=ENVIZI.CALCULATION_BY_FACTORID(factorId, value, unit)
For a description of each result of the calculation, see Table 1.
See factor details
Use the following functions to see the details of each factor.
=ENVIZI.FACTOR(type, unit, country, [stateProvince], [date])
=ENVIZI.FACTORBYID(factorId, [unit])
| Column | Description |
|---|---|
| factorSet | The emission factor dataset that is used for calculation, for example, DEFRA or EPA. |
| source | Reference source of the factor, for example, publication or license link. |
| activityType | Category of data, for example, Electricity - Scope 3. |
| activityUnit | Unit of input activity data, for example, kWh or liters. |
| name | Human-readable name of the factor, for example, Electricity: UK - 2023. |
| Description | Text description of the factor, for example, Electricity generated. |
| effectiveFrom | Dates the factor is valid from. |
| effectiveTo | Dates the factor is valid to. |
| publishedFrom | Publication period of the factor set from. |
| publishedTo | Publication period of the factor set to. |
| region | Geographic region where the factor applies. |
| Total CO2e | CO2 (carbon dioxide) emissions |
| CO2 | CH4 (methane) emissions |
| CH4 | N2O (nitrous oxide) emissions |
| N2O | HFC (hydrofluorocarbon) emissions |
| HFC | PFC (Perfluorocarbon) emissions |
| PFC | SF6 (sulfur hexafluoride) emissions |
| SF6 | NF3 (nitrogen trifluoride) emissions |
| NF3 | bioCO2 (biogenic carbon dioxide) emissions, if applicable |
| bioCO2 | CO2 (carbon dioxide) emissions |
| indirectCO2e | Indirect CO2 equivalent emissions reported separately. |
| Unit | Output measurement unit. Typically kgCO2e. |
| Transaction Id | Unique identifier for the calculation transaction, which is used for reference and auditing. |
Search factors
=ENVIZI.FACTOR_SEARCH(search, country, [stateProvince], [date])
| Column | Description |
|---|---|
| factorSet | The emission factor dataset used for calculation (for example, DEFRA, EPA). |
| source | Reference source of the factor (for example, publication, license link). |
| activityType | Category of data (for example, Electricity - Scope 3). |
| activityUnit | Unit of input activity data (for example, kWh, liters). |
| region | Geographic region where the factor applies. |
| factorId | Factor ID from Envizi Emissions API. |
Get an AI-recommended activity type
The emission factors catalog includes thousands of activity types. The activity type recommender is a feature that uses AI to help you choose an appropriate activity type when you are not sure which one to use. In the Activity name cell, you describe your activity in plain language, for example flight to Paris. The add‑in then recommends an activity type for your calculation and shows a confidence score to help you judge how good the match is. Scores range from 0 to 1, where values closer to 1 indicate a stronger match.
You must review the recommended activity type and decide whether it is appropriate to your activity. If you agree with the recommendation, you can then enter the remaining details, such as units, values, or country. If you don’t agree with the recommended data type, you can search for a different one from a drop-down.
=ENVIZI.RECOMMEND_ACTIVITY_TYPE(search,country,[stateProvince],[data],[page],[size])
Match headers to the template
The template for Envizi™ Emissions Calculations in Excel is provided with all features enabled. If you're using your own template, you can download the Envizi Emissions Calculations in Excel template to explore how all the functions and features work. You can also optionally add the column headers from the template to your own template. You can then follow the function exactly as written, and column headers, such as CO2e and CH4, match the calculated results.
- To add the input headers, in an empty cell, use the function
=ENVIZI.HEADERS(("stationary"),[true]). - To add the input and output headers, in an empty cell, use the function
=ENVIZI.HEADERS(("stationary"),[true],[true]). - To add the input and output headers, including headers related to the activity type recommender,
use
=ENVIZI.HEADERS(("stationary"),[true],[true][true]). What is the activity type recommender?