III._San_Mateo_County_Countywide_Community_GHG_Inventory_Example.xlsx

Read Me RICAPS - Greenhouse Gas Inventory Tool Overview

Purpose

This excel workbook serves as a tool to quantify and report communitywide greenhouse gas (GHG) emissions for jurisdictions within San Mateo County. GHG emissions are quantified and reported in accordance with International Council for Local Environmental Initiatives (ICLEI) greenhouse gas accounting standards and methodologies used in previous annual inventories. Specifically, this tool utilizes ICLEI's U.S. Community Protocol methodology to estimate community-based greenhouse gas emissions. This tool was developed by Rincon Consultants, Inc. for the City/County Association of Governments' (C/CAG) Regionally Integrated Climate Action Planning Suite (RICAPS). RICAPS is an initiative sponsored by C/CAG to support its member cities and the County to develop climate action plans for their communities.

Methodology Updates

RICAPS previously provided GHG Inventories for years 2005 to 2017. In comparison to these inventories, some GHG emission sources have been added and updated to reference current best practices in community-level GHG emissions accounting. These updates are reflected in this 2023 GHG Inventory and the updated 2021 and 2005 GHG Inventories. The updates include:

1. Incoporation of methane leakage in the pipeline distribution of natural gas and at end-uses

2. Update of off-road transportation emissions using the newest OFFROAD2021 model (v1.0.3) from California Air Resources Board (CARB)

3. Use oforigin-destination accounting methdology as default for vehicles miles traveled (VMT) accounting

4. Update of on-road transportation emissions using the newest EMFAC2021 model (v1.0.2) from CARB

5. Inclusion of electricty transmission and distribution (T&D) losses

6. Updated waste calculations reflecting the 2014 jurisdictional baseline from CalRecycle for SB 1383

Overview of Tabs

Lists (Hide) Collection of lists used for drop-down selection options used in this GHG Inventory Tool

Dashboard Series of charts and tables summarizing GHG Inventory Tool results

Historic Emissions Table to input historic GHG emissions for the jurisdiciton (2005 to 2019) and summarize GHG emissions for the GHG Inventory Tool year.

Data Processing - Community Where raw data is processed, analyzed, and summarized for each sector of a community-based GHG inventory. Use the "Data Tables" subsection under each sector for manipulating raw data to input into summary tables under the "Summary Tables" subsections

Constants & EFs Location of emission factor defaults, parameter constants, and San Mateo County-specific emission factor inputs used to quantify GHG emissions. Input information here regarding the region being assessed and the inventory year which will be referenced throughout the workbook.

RAW - " " Location to input and store raw data for the GHG Inventory that was compiled and processed in other RICAPS tools and workbooks

Cell Color/Style Legend

Example Table text cells which are constant and locked or should not be manipulated

0,000 Table data cells which are constant or contain formulas that are locked or should not be manipulated

Example Indicates a total or final result which are automatically calculated for energy and transportation summary tables

Example Text information that is to be input by the user

0,000.00 Data that is to be input by the user

Example Table header style format used for constants, default values and emission factors, or data manupulation tables under "Data Tables" subsections

Example Table header style format used for tables which summarize or report inventory results

Missing Data Data that was not provided for the jurisdiction and for which associated GHG emissions are not calculated

Glossary

General

Emissions

Cell Notation

- Indicates that either 1) given value is not included or applicable; or 2) there is an error

Units

Summary of Updates

Date Updates

Lists (Hide) This page will be hiden from view upon finalization of the GHG Inventory Template Emily Saul: Emily Saul:

STEP 1 of 1: Hide tab before submitting to client.

Dashboard

2023 Building Energy

PG & E Electricity1 PG & E Electricity T & D2 PCE Electricity1 PCE Electricity T & D2 Residential Natural Gas Residential Natural Gas Leaks Nonresidential Natural Gas Nonresidential Natural Gas Leaks 110607.75459764092 5753.3157997887611 7936.5898312280824 412.82555494008039 627263.9204975001 176358.62243999998 487319.96047750005 137012.62595999998 GHG Emissions (MT CO2e)

2023 Transportation

On-road Passenger Total VMT On-road Commercial Total VMT On-road Passenger EVMT On-road Commercial EVMT 1336686.047166764 470021.48151063541 11482.075482465674 7.669847660782084

MT CO2e Building Energy On-road Transportation Solid Waste Off-road Equipment Wastewater Water 1801623.2478577113 1818197.2740075258 183087.55443389295 200243.92030720122 20079.623775283675 236.40236397913446 GHG Emissions (MT CO2e)

Annual

2023 Offroad

Off Road-Diesel Off Road-Gasoline Off Road-Natural Gas 66024.871429797247 115234.34143663404 18984.707440769944 GHG Emissions Over Time by Sector

Building Energy 2005 2021 2023 2513098.7748537268 1748711.1081993605 1801623.2478577113 On-road Transportation 2005 2021 2023 2150075.6909481385 1910470.7927453737 1818197.2740075258 Off-road Equipment 2005 2021 2023 169346.21712438343 190031.44975500202 200243.92030720122 Solid Waste* 2005 2021 2023 248082.7990115615 167456.34080238536 183087.55443389295 Wastewater 2005 2021 2023 0 19092.617750384175 20079.623775283675 Water 2005 2021 2023 0 1989.5506979181669 236.40236397913446

PCE Graphs

2005 Electricity Natural Gas On-road Transportation Off-road Equipment Solid Waste Wastewater Water 919294.97170584579 1593803.8031478813 2150075.6909481385 169346.21712438343 248082.7990115615 0 0 2021 Electricity Natural Gas On-road Transportation Off-road Equipment Solid Waste Wastewater Water 126468.25476510877 1388974.3376536625 1910470.7927453737 190031.44975500202 167456.34080238536 19092.617750384175 1989.5506979181669 2023 Electricity Natural Gas On-road Transportation Off-road Equipment Solid Waste Wastewater Water 124710.48578359783 1427955.129375 1818197.2740075258 200243.92030720122 183087.55443389295 20079.623775283675 236.40236397913446

Historic Emissions San Mateo County Historic GHG Emissions Summary

Emily Saul: Emily Saul:

Data Processing - Community San Mateo County Community Inventory Data Processing and Analysis

Emily Saul: Emily Saul:

STEP 3 of 11: Identify if each Emissions Source is to be included or excluded from the Inventory (based on baseline Inventory) Total Electricity Consumption [kWh] EV Electricity Use [kWh] tc={CC9F7DFE-6C95-4B90-8442-60E07C0CC44C}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Allocates total EV kWh based on proportion of total kWh provided . Adjusted Electricity Consumptiona [kWh] EF Source EF [MT CO2e/kWh] GHG Emissions [MT CO2e]

[MT CO2e]

Emily Saul: Emily Saul:

STEP 1 of 11: Set formulas equal to Raw Electricity Consumption column if no estimation needed. If estimation needed, write formulas specific to each Emissions Source to estimate electricity (can use EDRP data from Activity Data tab if appropriate. For most jurisdictions, you will need to subtract PCE electricity from Direct Access electricity. For Emission Sources with "N/A", fill formula in as zero. Estimation Methodology Notes Emily Saul: Emily Saul:

STEP 2 of 11: If Estimated Electricity Consumption was set equal to Raw Electricity Consumption column, leave blank. If estimated, write description of estimation methodology.

Emily Saul: Emily Saul:

STEP 6 of 11: Identify if each Emissions Source is to be included or excluded from the Inventory (based on baseline Inventory) Total Nat Gas Consumption [therms] End-use Leakage [percent] End-use Leakage [therms] Nat Gas Combusted [therms] EF [MT CO2e/therm] GHG Emissions [MT CO2e]

[MT CO2e]

[MT CO2e]

Emily Saul: Emily Saul:

STEP 4 of 11: Set formulas equal to Raw Natural Gas Consumption column if no estimation needed. If estimation needed, write formulas specifi to each Emissions Source to estimate natural gas. May use EDRP data from Acitivty Data tab if approriate. Estimation Methodology Notes Emily Saul: Emily Saul:

STEP 5 of 11: If Estimated Natural Gas Consumption was set equal to Raw Natural Gas Consumption column, leave blank. If estimated, write description of estimation methodology.

Note -

[millions of therms]

Emily Saul: Emily Saul:

STEP 7 of 11: Right click and refresh pivot table.

Data Tables

Emily Saul: Emily Saul:

STEP 10 of 11: Input results of the "CARB Landfill Emissions Tool_Version 1.3." Landfill Gas Collection Efficiency Percent of Landfill Covered by Gas Collection (%) Emily Saul: Emily Saul:

Emily Saul: Emily Saul:

STEP 8 of 11: Identify if GHG emissions from landfills are to be included or excluded from Inventory (based on baseline Inventory).

Emily Saul: Emily Saul:

STEP 6 of 11: Identify if each Emissions Source is to be included or excluded from the Inventory (based on baseline Inventory) Emily Saul: Emily Saul:

Data Tables Emily Saul: Emily Saul:

STEP 9 of 11: If Landfills are included, record data in the tables below that are to be input into the "CARB Landfill Emissions Tool_Version 1.3."

Emily Saul: Emily Saul:

STEP 3 of 11: Identify if each Emissions Source is to be included or excluded from the Inventory (based on baseline Inventory) Emily Saul: Emily Saul:

STEP 7 of 11: Right click and refresh pivot table.

tc={CC9F7DFE-6C95-4B90-8442-60E07C0CC44C}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Allocates total EV kWh based on proportion of total kWh provided .

Emily Saul: Emily Saul:

STEP 1 of 11: Set formulas equal to Raw Electricity Consumption column if no estimation needed. If estimation needed, write formulas specific to each Emissions Source to estimate electricity (can use EDRP data from Activity Data tab if appropriate. For most jurisdictions, you will need to subtract PCE electricity from Direct Access electricity. For Emission Sources with "N/A", fill formula in as zero.

Emily Saul: Emily Saul:

STEP 2 of 11: If Estimated Electricity Consumption was set equal to Raw Electricity Consumption column, leave blank. If estimated, write description of estimation methodology.

Emily Saul: Emily Saul:

Allocates total EV kWh based on proportion of total kWh provided .

Constants & EFs Constants and Emissions Factors

Emily Saul: Emily Saul:

STEP 1 of 1: Select City.

Note: Emission factors reported as MT CO2e/kWh are not subject to IPCC GWP adjustments (see tables above) and are dependent on the GWPs used from the reporting source

(g / mile)