Icon

CO2 Emission Tracking

<p><strong>CO2 Emission Tracking</strong></p><p>This workflow shows how to compute CO2 emissions for the activities and operations of a fictitious software company. It accounts for electricity and HVAC consumption, employee commuting to work, etc., adopts two strategies to compute emissions and presents insights in a dashboard:</p><ul><li><p><strong>Primary data strategy:</strong> Activity data (energy (kW/h), distance (km), etc.) * CO2 emission estimate (kg)</p></li><li><p><strong>Secondary data strategy:</strong> Activity cost (Euros) * CO2 emission coefficient (tons)</p></li></ul>

URL: UK's gov greenhouse gas reporting: conversion factors 2023 https://www.gov.uk/government/publications/greenhouse-gas-reporting-conversion-factors-2023
URL: The Greenhouse Gas Protocol https://ghgprotocol.org/sites/default/files/standards/ghg-protocol-revised.pdf

CO2 Emission Calculation for Electricity and HVAC Usage on a daily basis for a year (Primary Data)

CO2 Scope level matching

Source: Greenhouse Gas Protocol

Scope 1: Covers direct emissions from sources the company owns or controls.

Scope 2: Covers purchased Electricity, Heat, Cold or Steam.

Scope 3: Covers indirect emissions like travel or commuting, advertisement, marketing etc.

CO2 Emission Calculation for Advertising and Market Research on a monthly basis for a year (Secondary Data)

Read CO2 Emission Coefficients

Source: Estimation by academics

Interactive dashboard of CO2 emissions

CO2 Emission Tracking


This workflow shows how to compute CO2 emissions for the activities and operations of a fictitious software company for the year 2023. It accounts for electricity and HVAC consumption, employees commuting to work, etc., adopts two strategies to compute emissions and presents insights in a dashboard:

  • Primary data strategy: Activity data (energy (kW/h), distance (km), etc.) * CO2 emission estimate (kg)

  • Secondary data strategy: Activity cost (Euros) * CO2 emission coefficient (tons)

Read Energy and HVAC usage dataset

Read and parse CO2 Emissions Estimates

Source: UK government

CO2 Emission Calculation for Employee Commute on a daily basis for a year (Primary Data)

Read Employee commute and attendance dataset

Read Advertising and Marketing Research dataset

Energy and HVAC usage(kW/h) in 2023
CSV Reader
Monthly bill of Advertisementand Market Research in 2023
CSV Reader
Aggregate emissions
Employee commute modeand distance (km) in 2023
CSV Reader
Employee dailypresence in the office in 2023
CSV Reader
VIsualize the CO2 impactof company activities
CO2 Emission View
Energy and HVAC consumption--> Scope 2
Constant Value Column Appender
CO2 emissions (kg) = Advertising & Market Research bill (Euros) * CO2 estimate (tons)* 1000
Advertising & Market Research
UK governmentgreenhouse gas reportingconversion factors2023 (condensed set)CO2 emissionsestimates are in kg
CO2 Emissions estimates
Advertising and MarketResearch --> Scope 3
Constant Value Column Appender
Employee commuting--> Scope 3
Constant Value Column Appender
Conversion tablefor Euro to CO2 Emissions (tons)
Excel Reader
CO2 emissions (kg) = Commute distance (km) * CO2 estimate (kg)
Employee Commute
CO2 emissions = Usage (kW/h) * CO2 estimate (kg)
Electricity & HVAC

Nodes

Extensions

Links