Calculating emissions with a scope in the provided template

Edit online

Use scope-specific functions to calculate emissions for Scope 1, Scope 2, and Scope 3 activities in the template that is provided with IBM® Emissions Calculations in Excel.

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. Open the sheet for the scope category that you want to calculate emissions for. For example, to calculate stationary emissions, open the S1. Stationary sheet.
  2. Enter activity data, such as the value, unit, and country.
  3. Optional: Get AI to help select a activity type when you are unsure which one to use:
    1. In the Activity name cell, describe the activity. You can use natural language, for example, flight to Paris.
    2. In the Country cell, specify the country where the activity occurred.
    3. In the Recommended activity type cell, start typing RECOMMEND and when the full list of functions is displayed, select RECOMMEND_ACTIVITY_TYPE(search,country,[stateProvince],[data],[page],[size]).
    4. For the search value, select the Name cell and then select your specified country. You can also optionally specify the state or province, data, page, and size.
    5. Review the recommended activity type, confidence score, and description.
      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.
    6. Select the cell that has the suggested activity type.
    7. 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.
  4. Use a function to calculate emissions. In the Total CO2e 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].
  5. 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.
  6. 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.
  7. Review the results and save.