IV._San_Mateo_County_Government_Operations_GHG_Inventory_Example.xlsm

Read Me Greenhouse Gas Inventory Tool Overview

Purpose

This excel spreadsheet serves as a tool to quantify and report greenhouse gas emissions on the County or City scale in accordance with International Council for Local Environmental Initiatives (ICLEI) greenhouse gas accounting standards. Specifically, this tool utilizes ICLEI's Local Goverment Operations Protocol (LGOP) for estimating emissions associated with municipal operations.

Overview of Tabs

Report Tables Collection of data tables used for writing a technical report based on GHG Inventory Assessment Results

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

Dashboard Contains a series of charts and tables summarizing GHG Inventory Tool results

Constants & Efs Localized location of emission factor inputs, emission factor defaults, and parameter constants that may be used to quantify GHG emissions. Input information here regarding the region being assessed and the inventory year which will be referenced globally

Demographics Input regional demographic data into this tab

Community Inventory Where raw data is processed, analyzed, and summarized for each sector of a community-based GHG inventory. Use the "Data Processing" subsection under each sector for manipulating raw data to input into summary tables under the "Summary Tables" subsections. Under the "Pivot & Query Tables (streamlined)" subsection of the Transportation sector, right click within tables to refresh when raw data is added or new use selections are made (note - there are limited user input cells in the subsection).

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

Raw - " " Input and store raw data under tabs with this heading format to indicate data is as-provided

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

Text information that is to be input by the user

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

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

Clear Input Cells

Dashboard

Total Transportation Infrastructure Natural Gas Solid Waste Wastewater Infrastructure Refrigerants Infrastructure Other Fuels Water Infrastructure Electricity 19886.198509930287 9849.8824388564281 3250.1912034073493 177.6199132368711 145.79058522557176 80.038919106200012 5.8850410122767306E-4 0

Total Employee Commute On-road Vehicle Fleet Gasoline Off-road Vehicle Fleet Diesel On-road Vehicle Fleet Diesel Reimb. Business Travel Off-road Vehicle Fleet Gasoline Off-road Vehicle Fleet Propane On-road Vehicle Fleet Propane On-road Vehicle Fleet Electric Buildings & Facilities Buildings & Facilities Leaks Landfill Methane Process Emissions Water Treatement Refrigerants Back-up Generators Local Water Imported/Purchased Buildings & Facilities/Streetlights & Traffic Signals T & D Buildings & Facilities/Streetlights & Traffic Signals Transportation Infrastructure Natural Gas Solid Waste Wastewater Infrastructure Refrigerants Infrastructure Other Fuels Water Infrastructure Electricity 15947.763703641338 2642.2926456850942 651.19627958049989 452.4954195754475 147.88586744261031 41.670920755499992 1.8248400309999995 1.0688332187989997 0 7873.4172068269027 1976.4652320295249 3149.2763937697209 100.91480963762865 177.6199132368711 145.79058522557176 80.038919106200012 5.8850410122767306E-4 0 0 0

Sheet3

2023 Government Operations GHG Emissions Footprint

Buildings and Facilities

Dashboard_BE

Forecast Community Inventory GHG Emissions Forecast

tc={B94C9F24-1475-422B-91C8-4992B11F8F6D}: [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:

Source: https://cltc.ucdavis.edu/sites/default/files/files/publication/title-24-2013-code-changes-140318.pdf Efficiency Increase from 2013 to 2016 tc={B8EF8655-7248-4C53-8FD9-06EBBF46197A}: [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:

Residential: https://www.cityofberkeley.info/uploadedFiles/Planning_and_Development/Level_3_-_Commissions/Commission_for_Energy/EC2016-09-28_Item%204-Combined.pdf

Commercial: https://www.calbo.org/sites/main/files/file-attachments/2015-06-10_adoption_hearing_presentation.pdf?1520982919 Efficiency Increase from 2016 to 2019 tc={B150143D-F669-4602-B3E1-8AF0C21AACD4}: [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:

Source: https://www.energy.ca.gov/sites/default/files/2020-03/Title_24_2019_Building_Standards_FAQ_ada.pdf tc={B94C9F24-1475-422B-91C8-4992B11F8F6D}: [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:

Source: https://cltc.ucdavis.edu/sites/default/files/files/publication/title-24-2013-code-changes-140318.pdf tc={B8EF8655-7248-4C53-8FD9-06EBBF46197A}: [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:

Residential: https://www.cityofberkeley.info/uploadedFiles/Planning_and_Development/Level_3_-_Commissions/Commission_for_Energy/EC2016-09-28_Item%204-Combined.pdf

Commercial: https://www.calbo.org/sites/main/files/file-attachments/2015-06-10_adoption_hearing_presentation.pdf?1520982919

[Add Notes or Sources]

Source: https://cltc.ucdavis.edu/sites/default/files/files/publication/title-24-2013-code-changes-140318.pdf

Residential: https://www.cityofberkeley.info/uploadedFiles/Planning_and_Development/Level_3_-_Commissions/Commission_for_Energy/EC2016-09-28_Item%204-Combined.pdf

Commercial: https://www.calbo.org/sites/main/files/file-attachments/2015-06-10_adoption_hearing_presentation.pdf?1520982919

Source: https://www.energy.ca.gov/sites/default/files/2020-03/Title_24_2019_Building_Standards_FAQ_ada.pdf

Targets

Base 2021 2030 2035 2040 2045 #N/A #N/A #N/A #N/A #N/A Difference 2021 2030 2035 2040 2045 #N/A 0 0 0 0 BAU Forecast 2021 2030 2035 2040 2045 #N/A #N/A #N/A #N/A #N/A Adjusted Forecast 2021 2030 2035 2040 2045 #N/A #N/A #N/A #N/A #N/A SB 32 Mass Emissions Pathway []MT CO2e

2021 2030 2035 2040 2045 0 0 0 0 0 SB 32 Per Capita Emissions Pathway (translated to mass emissions) 0 MT CO2e

2021 2030 2035 2040 2045 0 0 0 0 0 GHG Emissions (MT CO2e)

Base 2021 2030 2035 2040 2045 #N/A #N/A #N/A #N/A #N/A Difference 2021 2030 2035 2040 2045 0 0 0 0 0 BAU Forecast 2021 2030 2035 2040 2045 #N/A #N/A #N/A #N/A #N/A Adjusted Forecast 2021 2030 2035 2040 2045 #N/A #N/A #N/A #N/A #N/A SB 32 Mass Emissions Pathway (translated to per capita emissions) 0 MT CO2e

2021 2030 2035 2040 2045 0 0 0 0 0 SB 32 Per Capita Emissions Pathway []MT CO2e/capita

#REF!

2021 2030 2035 2040 2045 0 0 0 0 0 GHG Emissions (MT CO2e per capita)

SPARQ

SPARQ Tool

CO2e Emissions Reduction Goals and Targets GHG Target Achievement Actions Reductions Legend

Custom 1 ERROR:#N/A ERROR:#N/A

Custom 2 ERROR:#N/A ERROR:#N/A

Custom Target 2030 2045

Building Energy Measures

100% 100% Decrease in electricity emissions (% by 2030/2045) ERROR:#N/A ERROR:#N/A

New Building Electrification ERROR:#N/A ERROR:#N/A

Existing Building Electrification ERROR:#N/A ERROR:#N/A

Transportation Measures

5% 8% Active transportation mode share (% by 2030/2045) ERROR:#REF! ERROR:#REF!

Public Transit ERROR:#REF! ERROR:#REF!

10% 15% Public transit mode share (% by 2030/2045) ERROR:#REF! ERROR:#REF!

Zero-Emission Vehicles ERROR:#REF! ERROR:#REF!

Offroad Equipment Decarbonization ERROR:#N/A ERROR:#N/A

10% 100% Reduce emissions from offroad equipment (% by 2030/2045) ERROR:#N/A ERROR:#N/A

Solid Waste Measures

75% 100% Reduction in landfilled organic waste (% by 2030/2045) ERROR:#N/A ERROR:#N/A

Wastewater Measures

40% 100% Reduction in wastewater operations/process GHG emissions (% by 2030/2045) ERROR:#N/A ERROR:#N/A

Water Measures

10% 20% Reduction in volume of community water usage (% by 2030/2045) ERROR:#N/A ERROR:#N/A

Carbon Sequestration Measures

70% 100% Compliance with compost procurement requirements of SB 1383 (% by 2030/2045) 0 0

Tree Planting 0 0

350 1,100 Total trees planted by 2030/2045 0 0

Measure CO2e Reductions

Year 2030 Offroad Equipment Decarbonization Active Transportation Public Transit Zero-Emission Vehicles Transportation 2869.1354420006583 0 0 #N/A Year 2045 Offroad Equipment Decarbonization Active Transportation Public Transit Zero-Emission Vehicles Transportation 32564.480551604374 0 0 #N/A

2045 GHG Reduction Contribution

Achieved Remaining #N/A #N/A 2030 GHG Reduction Contribution

Achieved Remaining #N/A #N/A 2045 GHG Reduction Contribution

Achieved Remaining #N/A #N/A 2030 GHG Reduction Contribution

Achieved Remaining #N/A #N/A 2045 GHG Reduction Contribution

Achieved Remaining #N/A #N/A

Baseline

Column1 2030 2045 #N/A #N/A #N/A Target - SB 32

Column1 2030 2045 #N/A 0 0 GHG Reduction

Column1 2030 2045 #N/A #N/A #N/A Target - Custom 1

Column1 2030 2045 0 0 0 Target - Custom 2

Column1 2030 2045 0 0 0

CO2e Reduction SB 32 Target Tracker

Target - SB 32 2030 2045 #N/A #N/A GHG Reduction []

2030 2045 #N/A #N/A #N/A #N/A

Publicly Accessible Electric Vehicle Charger Demand

Number of Evs

Year 2045 Year 2030 834.31229191255852 828.5274752309773

Measure CO2e Reductions

Year 2030 Carbon-free Electricity New Building Electrification Existing Building Electrification Building Energy #N/A #N/A #N/A Year 2045 Carbon-free Electricity New Building Electrification Existing Building Electrification Building Energy #N/A #N/A #N/A

2030 GHG Reduction Contribution

Achieved Remaining #N/A #N/A 2045 GHG Reduction Contribution

Achieved Remaining #N/A #N/A 2030 GHG Reduction Contribution

Achieved Remaining 0 0 2045 GHG Reduction Contribution

Achieved Remaining 0 0 2030 GHG Reduction Contribution

Achieved Remaining #N/A #N/A 2045 GHG Reduction Contribution

Achieved Remaining #N/A #N/A 2030 GHG Reduction Contribution

Achieved Remaining #N/A #N/A

SPARQ_BE

SPARQ Tool Lists

Emission Reductions Emission Reductions