Calculating emissions with a scope in your own template

Edit online

Use scope-specific functions to calculate emissions for Scope 1, Scope 2, and Scope 3 activities in your own template.

Before you begin

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 IBM® 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.

The following examples show how to add headers for the stationary scope:

  • 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?

About this task

You can calculate emissions by using the factor that is automatically selected for you, or you can specify the factor that you want the calculation to use. To specify the factor, you need to know the unique factor ID. You can find the ID in three ways:

To see all supported scopes in Envizi Emissions Calculations in Excel, open the Emission factors catalog and see the scopes in the Filters section.

Tip: To see all the available calculation functions, in any cell, type =ENVIZI and a drop-down that lists all functions is displayed. For more detailed information about each function, see Functions in Emissions Calculations in Excel.

Procedure

  1. Enter activity data, such as the value, unit, and country.
  2. Optional: Get AI to help select an activity type when you are unsure which one to use.
    1. In a cell, describe the activity. You can use natural language, for example, flight to Paris.
    2. In a cell, specify the country where the activity occurred.
    3. In an empty cell, start typing RECOMMEND and when the full list of functions is displayed, select RECOMMEND_ACTIVITY_TYPE(search,country,[stateProvince],[data],[page],[size]). For the search value, select your description of the activity and then select your specified country. You can also optionally specify the data, page, and size.
      A recommended activity type, confidence score, and description are displayed.
    4. Review the recommended activity type.
      Confidence scores range from 0 to 1, where values closer to 1 indicate a stronger match.
      If you agree with the recommendation, continue to the next step. If you do not agree with the recommendation, you can insert a drop-down in the cell with the recommendation. You can then search for and select a different activity type.
    5. Select the cell that has the suggested activity type.
    6. On the IBM Envizi tab, from the ribbon, click Insert all activity types.
      The cell now has a drop-down that you can use to select another activity type.
  3. Use a function to calculate emissions. In an empty cell, start typing =ENVIZI, and the full list of functions is displayed in a drop-down.
    Each scope category has a function.
    Option Description
    If you want to use the automatically selected factor... From the drop-down, select the function that applies to your scope category. For example, to calculate stationary emissions, select ENVIZI.STATIONARY and the full function is displayed: ENVIZI.STATIONARY(type, value, unit, country, [stateProvince], [date]).
    If you want to specify the factor for the calculation... From the drop-down, select the function that applies to your scope category. For example, to calculate stationary emissions by factor ID, select ENVIZI.STATIONARY_BY_FACTORID and the full function is displayed: ENVIZI.STATIONARY(type, value, unit, country, [stateProvince], [date].
  4. Select the cell that contains each value as shown in the function, followed by a comma.
    For example, the first value in the stationary function is type, so you select the cell where you specified the activity type and then add a comma. Repeat the process for each value in the function.
  5. When you finish entering values, type a closing parenthesis and press Enter.
    You can now see calculations for emissions, such as CO2, CH4, and N2O.
  6. Review the results and save.