Reference¶

This section describes all available custom functions provided by IBM Envizi for Excel.

Each function calls the IBM Envizi Emissions API from Excel to calculate greenhouse gas (GHG) emissions based on provided inputs.

General Notes¶

All functions must be entered directly into Excel cells.
Arguments in square brackets ([ ]) are optional.
Errors are returned as Excel error messages.
Units must follow the supported unit conventions defined in Envizi.

Functions¶

Location-based Emissions¶

Syntax

=ENVIZI.LOCATION(type, value, unit, country, [stateProvince], [date], [powerGrid])

Parameters

type – Activity type
value – Numeric activity value
unit – Unit of measurement (default: kWh if not specified)
country – ISO alpha-3 country code
stateProvince (optional) – Geographic state or province
date (optional) – Activity date
powerGrid (optional) – Power grid region identifier

—

Alternate Syntax (factorId)

=ENVIZI.LOCATION_BY_FACTORID(factorId, value, [unit])

factorId – Factor ID from Envizi
value – Numeric activity value
unit (optional) – Unit of measurement

Outputs

Column	Description
`Total CO2e`	The total emissions expressed as carbon dioxide equivalent (CO2e). This is the sum of all GHGs weighted by their global warming potential (GWP).
`CO2`	Direct carbon dioxide (CO2) emissions reported separately.
`CH4`	Methane (CH4) emissions reported separately.
`N2O`	Nitrous oxide (N2O) emissions reported separately.
`HFC`	Hydrofluorocarbon (HFC) emissions reported separately.
`PFC`	Perfluorocarbon (PFC) emissions reported separately.
`SF6`	Sulfur hexafluoride (SF6) emissions reported separately.
`NF3`	Nitrogen trifluoride (NF3) emissions reported separately.
`bioCO2`	Biogenic carbon dioxide (bioCO2) emissions, if applicable.
`directCO2`	Direct CO2 emissions explicitly reported when available.
`Unit`	Unit of measurement for the emissions result.
`Description`	Provides details on the factor set used in the calculation.
`Transaction Id`	Unique identifier for the calculation transaction, used for reference and auditing.

—

Stationary Source Emissions¶

=ENVIZI.STATIONARY(type, value, unit, country, [stateProvince], [date])

=ENVIZI.STATIONARY_BY_FACTORID(factorId, value, unit)

Outputs

Column	Description
`Total CO2e`	The total emissions expressed as carbon dioxide equivalent (CO2e). This is the sum of all GHGs weighted by their global warming potential (GWP).
`CO2`	Direct carbon dioxide (CO2) emissions reported separately.
`CH4`	Methane (CH4) emissions reported separately.
`N2O`	Nitrous oxide (N2O) emissions reported separately.
`HFC`	Hydrofluorocarbon (HFC) emissions reported separately.
`PFC`	Perfluorocarbon (PFC) emissions reported separately.
`SF6`	Sulfur hexafluoride (SF6) emissions reported separately.
`NF3`	Nitrogen trifluoride (NF3) emissions reported separately.
`bioCO2`	Biogenic carbon dioxide (bioCO2) emissions, if applicable.
`directCO2`	Direct CO2 emissions explicitly reported when available.
`Unit`	Unit of measurement for the emissions result.
`Description`	Provides details on the factor set used in the calculation.
`Transaction Id`	Unique identifier for the calculation transaction, used for reference and auditing.

—

Fugitive Emissions¶

=ENVIZI.FUGITIVE(type, value, unit, country, [stateProvince], [date])

=ENVIZI.FUGITIVE_BY_FACTORID(factorId, value, unit)

Outputs

Column	Description
`Total CO2e`	The total emissions expressed as carbon dioxide equivalent (CO2e). This is the sum of all GHGs weighted by their global warming potential (GWP).
`CO2`	Direct carbon dioxide (CO2) emissions reported separately.
`CH4`	Methane (CH4) emissions reported separately.
`N2O`	Nitrous oxide (N2O) emissions reported separately.
`HFC`	Hydrofluorocarbon (HFC) emissions reported separately.
`PFC`	Perfluorocarbon (PFC) emissions reported separately.
`SF6`	Sulfur hexafluoride (SF6) emissions reported separately.
`NF3`	Nitrogen trifluoride (NF3) emissions reported separately.
`bioCO2`	Biogenic carbon dioxide (bioCO2) emissions, if applicable.
`directCO2`	Direct CO2 emissions explicitly reported when available.
`Unit`	Unit of measurement for the emissions result.
`Description`	Provides details on the factor set used in the calculation.
`Transaction Id`	Unique identifier for the calculation transaction, used for reference and auditing.

—

Mobile Emissions¶

=ENVIZI.MOBILE(type, value, unit, country, [stateProvince], [date])

=ENVIZI.MOBILE_BY_FACTORID(factorId, value, unit)

Outputs

Column	Description
`Total CO2e`	The total emissions expressed as carbon dioxide equivalent (CO2e). This is the sum of all GHGs weighted by their global warming potential (GWP).
`CO2`	Direct carbon dioxide (CO2) emissions reported separately.
`CH4`	Methane (CH4) emissions reported separately.
`N2O`	Nitrous oxide (N2O) emissions reported separately.
`HFC`	Hydrofluorocarbon (HFC) emissions reported separately.
`PFC`	Perfluorocarbon (PFC) emissions reported separately.
`SF6`	Sulfur hexafluoride (SF6) emissions reported separately.
`NF3`	Nitrogen trifluoride (NF3) emissions reported separately.
`bioCO2`	Biogenic carbon dioxide (bioCO2) emissions, if applicable.
`directCO2`	Direct CO2 emissions explicitly reported when available.
`Unit`	Unit of measurement for the emissions result.
`Description`	Provides details on the factor set used in the calculation.
`Transaction Id`	Unique identifier for the calculation transaction, used for reference and auditing.

—

Transportation and Distribution¶

=ENVIZI.TRANSPORTATION_AND_DISTRIBUTION(type, value, unit, country, [stateProvince], [date])

=ENVIZI.TRANSPORTATION_AND_DISTRIBUTION_BY_FACTORID(factorId, value, unit)

Outputs

Column	Description
`Total CO2e`	The total emissions expressed as carbon dioxide equivalent (CO2e). This is the sum of all GHGs weighted by their global warming potential (GWP).
`CO2`	Direct carbon dioxide (CO2) emissions reported separately.
`CH4`	Methane (CH4) emissions reported separately.
`N2O`	Nitrous oxide (N2O) emissions reported separately.
`HFC`	Hydrofluorocarbon (HFC) emissions reported separately.
`PFC`	Perfluorocarbon (PFC) emissions reported separately.
`SF6`	Sulfur hexafluoride (SF6) emissions reported separately.
`NF3`	Nitrogen trifluoride (NF3) emissions reported separately.
`bioCO2`	Biogenic carbon dioxide (bioCO2) emissions, if applicable.
`directCO2`	Direct CO2 emissions explicitly reported when available.
`Unit`	Unit of measurement for the emissions result.
`Description`	Provides details on the factor set used in the calculation.
`Transaction Id`	Unique identifier for the calculation transaction, used for reference and auditing.

—

Calculation¶

=ENVIZI.CALCULATION(type, value, unit, country, [stateProvince], [date], [powerGrid])

=ENVIZI.CALCULATION_BY_FACTORID(factorId, value, unit)

Outputs

Column	Description
`Total CO2e`	The total emissions expressed as carbon dioxide equivalent (CO2e). This is the sum of all GHGs weighted by their global warming potential (GWP).
`CO2`	Direct carbon dioxide (CO2) emissions reported separately.
`CH4`	Methane (CH4) emissions reported separately.
`N2O`	Nitrous oxide (N2O) emissions reported separately.
`HFC`	Hydrofluorocarbon (HFC) emissions reported separately.
`PFC`	Perfluorocarbon (PFC) emissions reported separately.
`SF6`	Sulfur hexafluoride (SF6) emissions reported separately.
`NF3`	Nitrogen trifluoride (NF3) emissions reported separately.
`bioCO2`	Biogenic carbon dioxide (bioCO2) emissions, if applicable.
`directCO2`	Direct CO2 emissions explicitly reported when available.
`Unit`	Unit of measurement for the emissions result.
`Description`	Provides details on the factor set used in the calculation.
`Transaction Id`	Unique identifier for the calculation transaction, used for reference and auditing.

—

Factor¶

=ENVIZI.FACTOR(type, unit, country, [stateProvince], [date])

=ENVIZI.FACTORBYID(factorId, [unit])

Outputs

Column	Description
`factorSet`	The emission factor dataset used for calculation (e.g., DEFRA, EPA).
`source`	Reference source of the factor (e.g., publication, license link).
`activityType`	Category of data (e.g., Electricity - Scope 3).
`activityUnit`	Unit of input activity data (e.g., kWh, liters).
`name`	Human-readable name of the factor (e.g., “Electricity: UK - 2023”).
`Description`	Text description of the factor (e.g., “Electricity generated”).
`effectiveFrom`	Dates for which the factor is valid from.
`effectiveTo`	Dates for which 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`	The total emissions expressed as carbon dioxide equivalent (CO2e), sum of all GHGs weighted by GWP.
`CO2`	Carbon dioxide (CO2) emissions reported separately.
`CH4`	Methane (CH4) emissions reported separately.
`N2O`	Nitrous oxide (N2O) emissions reported separately.
`HFC`	Hydrofluorocarbon (HFC) emissions reported separately.
`PFC`	Perfluorocarbon (PFC) emissions reported separately.
`SF6`	Sulfur hexafluoride (SF6) emissions reported separately.
`NF3`	Nitrogen trifluoride (NF3) emissions reported separately.
`bioCO2`	Biogenic carbon dioxide (bioCO2) emissions, if applicable.
`indirectCO2e`	Indirect CO2 equivalent emissions reported separately.
`Unit`	Output measurement unit (typically kgCO2e).
`Transaction Id`	Unique identifier for the calculation transaction, used for reference and auditing.

—

Factor Search¶

=ENVIZI.FACTOR_SEARCH(search, country, [stateProvince], [date])

Outputs

Column	Description
`factorSet`	The emission factor dataset used for calculation (e.g., DEFRA, EPA).
`source`	Reference source of the factor (e.g., publication, license link).
`activityType`	Category of data (e.g., Electricity - Scope 3).
`activityUnit`	Unit of input activity data (e.g., kWh, liters).
`region`	Geographic region where the factor applies.
`factorId`	Factor ID from Envizi.