User’s Guide Local Greenhouse Gas Inventory Tool Government Operations Module May 2015

User's Guide

Local Greenhouse Gas Inventory
Tool: Government Operations
Module

May 2015
Prepared for:

State and Local Climate and Energy Program
U.S. Environmental Protection Agency

Prepared by:

ICF International
1725 Eye Street, NW
Suite 1000

Washington, DC 20006
Tel: (202) 862-1200
Fax: (202) 862-1144

GHG

INVENTORY

|| Local

Local Climate and Energy Program

-------
U.S. Environmental Protection Agency

Contents

List of Tables and Figures	ii

Acronyms and Abbreviations	iii

1.	Getting Started	1

Microsoft Excel Settings	1

Microsoft Excel Security	1

2.	Tool Overview	1

Navigating the Tool	4

Data Requirements	5

Tool Layout	8

Background Controls	8

GHG Emission Scopes	8

Inventory Calculations	9

3.	Sheet Instructions and Methodology	13

Control Sheet	13

Stationary Combustion and Electricity Consumption Inventory Sheets	13

Solid Waste Inventory Sheets	15

Wastewater Treatment Inventory Sheets	16

Employee Commute Inventory Sheet	16

Water Emissions Inventory Sheet	16

Agriculture & Land Management Inventory Sheet	17

Urban Forestry Inventory Sheet	17

Waste Generation Inventory Sheet	17

Additional Sources Inventory Sheet	17

4.	Uncertainty	18

5.	Tool References	18

Local Greenhouse Gas Inventory Tool: Government Operations Module i

May 2015

-------
U.S. Environmental Protection Agency

Tables and Figures

Tables	Page

Table 1. Required Data Inputs for the Local Greenhouse Gas Inventory Tool: Government Operations
Module —Inventory Calculations	6

Figures	Page

Figure 1. Enabling Macros, Excel 2010	2

Figure 2. Enabling Macros, Excel 2007	3

Figure 3. Table of Contents	4

Figure 4. Sheet Navigation and Tracking Tools	5

Figure 5. Table of Contents with Completed Sheet	5

Figure 6. Stationary and Electricity Data Sheets	14

Figure 7. Mobile Entry—Update Calculations	15

Local Greenhouse Gas Inventory Tool: Government Operations Module ii	May 2015

-------
U.S. Environmental Protection Agency

Acronyms and Abbreviations

%
BAU
BOD5

CH4
C02
CO2G
days/yr
eGRID
EPA
ft3
ft3/yr
G.G.E.

kg
kWh
kg N/day
LFG
LGOP
LGGIT
mcf
MMSCF
MMSCF/yr
MT
N20
WARM

percent

business-as-usual

Biological Oxygen Demand (the amount of oxygen consumed in five days by
decomposing waste, used to measure the amount of waste input or output
into a system)

Methane
Carbon dioxide

Carbon dioxide equivalent emissions
days per year

Emissions & Generation Resource Integrated Database

U.S. Environmental Protection Agency

cubic feet

cubic feet per year

gasoline gallon equivalent

kilograms

kilowatt-hours

kilograms of Nitrogen per day
Landfill gas

Local Government Operations Protocol

Local Greenhouse Gas Inventory Tool: Government Operations Module

thousand standard cubic feet

million standard cubic feet

million standard cubic feet per year

metric Tons

Nitrous oxide

EPA's WAste Reduction Model

Local Greenhouse Gas Inventory Tool: Government Operations Module iii

May 2015

-------
U.S. Environmental Protection Agency

Getting Started

1. Tool Overview

This User's Guide accompanies and explains the Local Greenhouse Gas Inventory Tool: Government
Operations Module. The module was developed to support municipal governments across the
United States to evaluate the greenhouse gas emissions associated with their municipal operations.
Understanding these emission levels provides a base year for tracking emission trends against,
developing mitigation strategies and policies, and assessing progress towards meeting goals.

The tool helps users to develop a municipal greenhouse gas inventory of city operations for a base
year, following the Local Government Operations Protocol (LGOP), version 1.1. A companion tool for
estimating greenhouse gas emissions at the community level is also available. While the
Government Operations Module estimates emissions at the local government level, the separate
Community Module estimates emissions for the community as a whole and follows the Global
Protocol for Community-Scale GHG Emissions. Any emissions estimated in the Government
Operations Module can be included in the Industrial/Commercial sector in the Community Module.

2. Getting Started

The Local Greenhouse Gas Inventory Tool: Government Operations Module (LGGIT) was developed
using Microsoft® Excel 2007 and 2010. The tool will only operate properly using Excel 2007 or later.
Before using the tool, ensure your computer meets the system requirements. In order to install and
run the tool, you must have:

• IBM-PC compatible computer with the Windows XP operating system or later;

• Microsoft® Excel 2007 or later, with calculation set to automatic and macros enabled;

• Hard drive with at least 20MB free; and

• Monitor display setting of 800 x 600 or greater.

Microsoft Excel Settings

For the tool to function properly, Excel must be set to automatic calculation. Go to the Formulas
ribbon and select "Calculation Options." Make sure that the box next to the "Automatic" option is
checked.

Running Macros in Microsoft Excel

To make the user's experience as smooth as possible, the LGGIT uses macros. Macros are series of
commands and functions that are stored in Excel that run automatically to perform tasks, which
allow the tool to carry out tasks in an automated way. Because macros are such a powerful tool,
Excel checks with the user for approval before allowing them to run.

Local Greenhouse Gas Inventory Tool: Government Operations Module 1

May 2015

-------
U.S. Environmental Protection Agency

If Excel's security settings are set at the default level, a Security Warning appears above the formula
box in Excel when the file is initially opened (Figure 1).

Figure 1. Enabling Macros, Excel 2010

Insert Page Layout Formulas Data Review View Developer Acrobat

|mt« -|n • A" »' - -¦ ||Sj

• as m m i-

$ - % r ^oo i°o Conditional Format Cell Insert I

<£T

Introduction

Local Inventory Tool

What is this tool?

Local Climate and Energy Program

This tool is designed to help municipalities evaluate the greenhouse gas reductions associated with their municipal operations. This tool can help
municipalities understand their greenhouse gas emissions, providing a baseline for tracking emission trends, developing mitigation strategies and
policies, and assessing progress.

o develop a baseline greenhouse gas inventory of municipal operations, accordingto the Local Government Operations

n 1.1.

The tool helps use
Protocol (LGOP), v

Use of default data:

This tool gives users the option of applyingtheirown locality-specific data or using default data pre-loaded by region. The default data are gathered
by federal agencies and other sources covering the default emission factors and system assumptions needed to calculate emissions accordingto the
LGOP.

Important Terminology:

Scope - A common means of categorizing direct and indirect i
and goals. There are three scopes of
Scope 1 - All direct GHG
Scope2 - Indirect GHG
municipal operations.

Scope 3 - All other indirect emissions not covered in Scope 2, such as emissions from vehicles not owned orcontrolled by the city (e.g.,
employeecommutes), waste disposal, or emissions from agriculture, land management, and urban forestry.

Emission Factors- An emission factor is an amount of GHG emissions associated with a unit of activity data. For example, kg C02 emitted perkwh
electricity produced (kgCOj/kWh), or lbC02 emitted per gallon of gasoline (lb C02/gal).

~i Introduction Read Me TOC Definitions Sheet Factors

5 to improve transparency and for identifying different types of climate policies

from municipal operations,
associated with the consumption of purchased or acquired electricity, steam, heating, or coolingfor

The Security Warning lets the user know that some active content from the spreadsheet has been
disabled, meaning that Excel has prevented the macros in the spreadsheet from functioning. Since
the Government Module needs macros in order to function properly, the user must enable macros.
To do so in Excel 2010, simply click the "Enable Content" button in the security message (Figure 1).
To do so in Excel 2007, click the "Options" button in the security message and then select, "Enable
this content" in the pop-up box (Figure 2). Enabling the macro content for the tool in these ways
only enables macros while you are using this spreadsheet. The security settings will return to your
default when you close the spreadsheet.

Local Greenhouse Gas Inventory Tool: Government Operations Module 2

May 2015

-------
U.S. Environmental Protection Agency

Figure 2. Enabling Macros, Excel 2007

¦ i a _

I i|T ;PC ^Unot&Ctntx - S - *fc • mjt 3

hi &

Normal 4 Ncxmal 5

Normal_OVR— I Normal

3f«-

ci*». -

9 Secuitty '

If the Security Warning does not appear when the tool is first opened, it may be necessary to change the
security settings for macros.

To change the settings in Excel 2010, follow the steps below:

1. Exit out of the tool and re-launch Microsoft Excel without opening the Government Module.

2. On the "File" tab, select Options from the bottom of the left-hand menu.

3. In the Excel Options pop-up box, click on "Trust Center" at the bottom of the left-hand
menu.

4. Click on the gray "Trust Center Settings" button.

5. When the Trust Center options box appears, click "Macro Settings" in the left-hand menu.

6. Select "Disable all macros with notification."

7. Click "OK" to exit out of all pop-up boxes.

8. Once the security level has been adjusted, open the tool and enable macros in the manner
described in Figure 1 above.

To change the settings in Excel 2007, follow the steps below:

1. Exit out of the tool and re-launch Microsoft Excel without opening the Government Module.

2. Click on the Microsoft Excel icon in the top left of the screen.

3. Scroll to the bottom of the menu and select the "Excel Options" button to the right of the
main menu.

4. When the Excel Options box appears, select "Trust Center" in the left hand menu of the box.

5. Click the gray "Trust Center Settings" button.

6. When the Trust Center options box appears, click "Macro Settings" in the left-hand menu.

Local Greenhouse Gas Inventory Tool: Government Operations Module 3

May 2015

-------
U.S. Environmental Protection Agency

7. Select "Disable all macros with notification."

8. Click "OK" to exit out of all pop-up boxes.

9. Once the security level has been adjusted, open the tool and enable macros in the manner
described in Figure 2 above.

Navigating the Tool

The Government Module's Table of Contents is its main navigational portal. The Table of Contents is
also used to track your progress throughout the tool. You may click on the name of any part of the
tool within the Table of Contents to be taken to that sheet (Figure 3). Every sheet also features an
arrow-shaped navigation button on the upper right-hand corner that returns the user to the Table of
Contents.

There are two main sections of this tool: Background Data Collection and Emissions Calculations. In
each, the user will enter data to configure the tool to their specific municipality and receive
customized results.

Figure 3. Table of Contents

Insert Page Layout

'.(I U 4 _J '_J

AJ*. I—® m Show All Comments

(P> Show Ink |

& Protect and Share Workbook
gP Allow Users to Edit Ranges

A B C D E 1

G H 1 J

K L M N 0 f

> Q F

I S T U V

W X ! Y Z t

A AB

Table of Contents

Clickir® on each bcscwiltakeyouto rtsrespectrve worksheet in the tool. Use thstabte of contents to keep track ofyour progressasyou movethroughthetool
Comp ieted sheets are filled in. Incomplete sheets have a white background, white sheas that requirenoaction by the user areingrey.

Inventory Control Sheet

Stationary Combustion -

Entry Sheet

Mobile Combustion -

EntrySheet

Electricity Use -
EntrySheet

Agriculture & Land
Management Sheet

Stat i onary Combustion: -
Ca l culat ton & Summary

Mobile Combust ion-
Summary Shea

Wastewater-
Ca Iculation & Su mmary

Electricity Use-
Calculation & Su rnmary

Inventory Emissions Summary

• ~> Introduction

. 3

Read Me TOC Definitions Sheet Factors

Stattonaiy-Entfy Stationary-Data aattonaty-Calcs M
-------
U.S. Environmental Protection Agency

Combustion - Entry" sheet has been completed. The "Mobile Combustion - Entry Sheet" box has
changed, and is now filled in with color.

Figure 4. Sheet Navigation and Tracking Tools

f"H id "O * ' Municipal GHG Planning Tool 6-13-Ilaj(lsm - Microsoft Excel

1 Home~l Instrt

Page Layout Formulas Data Review Vie*

Developer A
-------
U.S. Environmental Protection Agency

Data Requirements

The Government Module is designed to accept any level of data granularity in order to be flexible to
the needs and constraints of different municipalities. Data can be entered at any scale, ranging from
city-wide activity data to data by facility or meter. The more specific the data provided by the user,
however, the more accurate and useful the tool will be. See Box 1 for details.

The GHG inventory segment of the tool proceeds through ten main sectors of municipal government
emissions. These sectors and the type of data the user needs to provide are show in

Local Greenhouse Gas Inventory Tool: Government Operations Module 6

May 2015

-------
U.S. Environmental Protection Agency

Table 1. Gray cells indicate if a default value is available for that input or if the input is optional.

In general, this tool is pre-programmed with default emission factors and system assumptions
needed to calculate emissions from the LGOP. Default emission factors are generally provided from
national or state publications, and provide a relatively accurate estimate of emissions. If local, or
site-specific factors are available for your locality, those should be used to overwrite the default
factors. Wherever possible in the inventory process, default values from the LGOP are used. The tool
provides users the option to use default data or to override default values if they have city-specific
information.

Throughout the tool, cells are shaded yellow where the user is required to enter data.

Box 1. GHG Inventory Data Input Options

Option A: "Quick" Inventory

• Enter municipality-wide fuel, electricity, and water consumption data.

• This method takes less time, but does not allow the tool to as effectively calculate emission
levels.

Option B: Thorough Inventory

• Enter fuel, electricity, water consumption by facility or meter.

• This method requires more time and data availability from the user, but provides the most
detailed GHG inventory.

Local Greenhouse Gas Inventory Tool: Government Operations Module 7

May 2015

-------
U.S. Environmental Protection Agency

Table 1. Required Data Inputs for the Local Greenhouse Gas Inventory Tool: Government Operations
Module —Inventory Calculations

GHG Sectors

Input Data

Stationary Combustion of Fossil Fuels
(i.e., fuel use at city facilities)
Electricity Consumption

Mobile Combustion of Fossil Fuels
(i.e., fuel use by city fleet)

Solid Waste Management

Wastewater Treatment

Employee Commute

Agriculture & Land Management

Urban Forestry
Waste Generation
Water Use

Additional Emission Sources

Stationary fuel use (by fuel type)

Electricity consumed (kWh)

Electric utility

Fuel consumed (by fuel type) (gallons or G.G.E.)

Vehicle Miles Traveled (miles)

Vehicle Model Year

Vehicle Type

City Landfills (number)

Landfill Gas Collected (MMSCF/yr)

Fraction of Cm in landfill gas

Landfill Gas Collection Area (fraction)

Wastewater treatment process details (aerobic, anaerobic,

nitrification, denitrification)

Population served by wastewater treatment system(s) (people)
Population served by septic systems (people)

Digester gas produced daily (ft3/day)

Fraction of Cm in biogas
System BODs load/influent (kg BODs/day)

Fraction BODs removed in primary treatment
Industrial Nitrogen load (kg N/day)

Average total Nitrogen discharged (kg N/day)

Number of employees (people)

Employees who use each mode of transit (%)

Average one-way commute length (miles)

Work days per year (days/yr)

Synthetic fertilizer use (short tons N)

Organic fertilizer use (short tons)

Manure fertilizer use (short tons)

Total urban area (km2)

Urban area with tree cover (%)

Waste emissions (MTCChe from EPA's Waste Reduction Model)
Department contribution to total waste (%)

Percentage of imported water (%)

Water use (gallons)

GHG emissions from each additional source, by gas (MT CChe)

Local Greenhouse Gas Inventory Tool: Government Operations Module 8

May 2015

-------
U.S. Environmental Protection Agency

Tool Layout

There are two main sections of this tool: Background Data Collection, and Emissions Calculations. In
each, the user will enter data to configure the tool to their specific municipality and receive
customized results.

Background Controls

On the Inventory Control Sheet, identify the municipality, the inventory year for the inventory, and
set up and define city departments. Depending on what data are available and at what scale, the
user can determine how to configure the tool. The departments input into the tool do not need to
correspond to every department within the municipality, but set up to reflect organizational units
for which the most comprehensive data is available. For example, if the user has City-wide data,
they may set up only one department, "City." Alternatively, if the user has data broken down by
billing units which are different from city departments, they may name the "Departments" after
those units. You must enter a minimum of 1 department in this step.

The user will also set up information about their electricity providers. Users can select which eGRID
sub-region serves the area view the default emission factors, and can enter up to five utilities with
utility-specific emission factors (if available).

GHG Emission Scopes

To account for direct and indirect emissions, and to provide transparency and a guiding framework
for the inventory tool, GHG estimates are categorized according to 3 scopes. The following scopes
are defined by the Local Government Operations Protocol and are used throughout the tool:

Scope 1: All direct GHG emissions (with the exception of direct C02 emissions from biogenic
sources).

Scope 2: Indirect GHG emission associated with the use of purchased or acquired electricity, steam,
heating, or cooling.

Scope 3: All other indirect emissions not covered in Scope 2, such as emissions resulting from the
extraction and production of purchased materials and fuels, transport-related activities in vehicles
not owned or controlled by the reporting entity (e.g., employee commuting and business travel),
outsourced activities, waste disposal, etc.

In addition to accounting for emissions according to these 3 scopes, the LGOP provides guidance on
imports and exports by a local government, and how emissions for these should be taken into
account. As an example, waste imported into the city, and treated at a government run facility is
reported as Scope 1 emission estimates. Waste generated by the local government, and exported
and treated outside of the local government's boundaries is included in Scope 3 estimates. The
LGGIT accounts for in-boundary consumption and resulting emissions and excludes any emissions
released from products consumed or services exported from the locality.

Local Greenhouse Gas Inventory Tool: Government Operations Module 9

May 2015

-------
U.S. Environmental Protection Agency

C02 SF6 CH4 N20 HFCs PFCs

SCOPE 1

DIRECT

SCOPE 2 ^ SCOPE 3

INDIRECT A L INDIRECT

JK f EMPLOYEE BUSINESS TRAVEL

PURCHASED ELECTRICITY

PRODUCTION OF

igU^L. ¦ ¦ [Vffl PURCHASED ||(J

^ / ¦" ^ B-

PRODUCT

USE CONTRACTOR OWNED

OUTSOURCED ACTIVITIES VEHKLES

FUEL COMBUSTION

Source: WRI/WBCSD GHG protocol Corporate Standard, Chapter 4 (2004).

Some local governments also choose to purchase green power or renewable energy certificates (RECS),
According to section 6.2.4 of the LGOP, a local government "may not deduct these purchases from your
Scope 2 emissions because doing so would constitute double counting. This is because the renewable
energy portion of a utility's power supply is already accounted for in the region's eGRID factor." The
LGOP encourages local governments to disclose information about these activities in their inventory
report, but not to include them in the calculations as this would lead to double counting.

Since Scope 3 emissions vary in complexity and in the activities they represent, it is recommended that
users calculate emission estimates for additional sources outside the tool and enter the estimates in the
Additional Emission Sources worksheet. An example of Scope 3 calculations from one local government
is included in the box below.

Local Greenhouse Gas Inventory Tool: Government Operations Module 10

May 2015

-------
U.S. Environmental Protection Agency

City of Eugene 2000 and 2005 GHG Inventory Report Scope 3 Emissions

The City of Eugene included Scope 3 emissions from vehicle fuels used by City employees
commuting to work, disposal of the City's solid waste from internal operations, and the embodied
energy in goods and services purchased by the City.

• For embodied energy in goods and services purchased by the City, the City of
Eugene provided an estimate that was derived from a national model (developed
by Carnegie Mellon University) of the GHG emissions embodied in different types
of purchases. The City estimated that approximately 18,120 metric tonnes of GHG
emissions was attributable to $40 million in purchases of local goods and services.

Inventory Calculations

After the user has configured the tool on the Control Sheet, the tool will calculate the municipal
emissions, or the base year greenhouse gas inventory for the city's municipal operations. The
inventory is separated into the 10 main emission sources below, from the Local Government
Operations Protocol (LGOP), and these sources are further organized by scope. Users can also enter
emissions for any additional sources they would like to calculate outside of the tool, and enter the
estimates in the Additional Emission Sources worksheet.

1. Stationary Combustion of Fossil Fuels (Scope 1)

2. Building/Facility Electricity Consumption (Scope 2)

3. Mobile Combustion of Fossil Fuels (Fleet) (Scope 1)

4. Solid Waste Disposal (Scope 1)

5. Wastewater Treatment (Scope 1)

6. Employee Commutes (Scope 3)

7. Water Consumption in City Facilities (Scope 3)

8. Agriculture & Land Management (Scope 3)

9. Urban Forestry (Scope 3)

10. Waste Generation (Scope 3)

11. Additional Emission Sources (optional) (Scope 1, 2, or 3)

For each source, the user will be asked to enter data about relevant city activities (e.g. electricity
consumed, fuel used) during the inventory base year. The tool can be used to develop emissions
estimates for a base year, as well as used to track emissions over time if different versions of the
Excel file are saved. Default emission factors for each activity are provided, and the user is given the
option to override these factors, if necessary. There are multiple sheets for some emission sources,

Local Greenhouse Gas Inventory Tool: Government Operations Module 11

May 2015

-------
U.S. Environmental Protection Agency

but not for all sources. Each emissions source follows a distinct process the user will follow to
determine the emissions, as explained below:

Stationary Combustion, Electricity Use, and Mobile Combustion

1. Users enter activity/fuel use data on Entry Sheet OR

2. Users can batch import data on Data Sheet.

3. Emissions are calculated and summarized on the Calculation Sheet.

Solid Waste

1. Users answer questions about their city's solid waste disposal system on the Control Sheet.

2. Based on the answers to the questions, users will enter data about their solid waste system and
view emissions summary on the Entry, Calculation & Summary Sheet.

Wastewater Treatment

1. Users answer questions about their city's wastewater treatment system(s) on the Control Sheet.

2. Based on the answers to the questions, users will enter data about their wastewater treatment
systems on the Entry Sheet; and

3. Emissions will be calculated and summarized on the Calculation & Summary Sheet.

Employee Commutes, Water Consumption, Agriculture & Land Management, Urban Forestry, and
Waste Generation

1. Users will enter necessary data, and view emissions on a single sheet.

Additional Emission Sources

1. Users can enter emissions from up to 10 additional sources on a single sheet.

All municipal emissions for the inventory year are summarized on the Emissions Summary sheet.

The tool estimates emissions for the 6 Kyoto Gases- C02, CH4, N20, PFCs, HFCs, and SF6. Gases
included for each Scope are provided in the following table.

Local Government GHG Inventory Tool Worksheet

Gases Included

Scope 1

Stationary Combustion

co2, cm, n2o

Mobile Combustion

CO2, cm, n2o

Solid Waste

Wastewater

cm, n2o

Scope 2

Electricity Use

CO2, cm, n2o

Scope 3

Employee Commute (Scope 3)

CO2

Agriculture & Land Management (Scope 3)

n2o

Urban Forestry (Scope 3)

CO2 (sequestered)

Waste Generation (Scope 3)

Local Greenhouse Gas Inventory Tool: Government Operations Module 12

May 2015

-------
U.S. Environmental Protection Agency

Water Use (Scope 3)

C02, CH4, n2o

Other (Scope 1, 2, or 3)

Additional Emission Sources

CO2, CH4, N2O, HFCs, PFCs, SFs

Biogenic emissions are not included in the module, and as a standard practice the C02 emissions
occurring from biofuel combustion are not included in total inventory estimates. According to the
U.S. Environmental Protection Agency, biogenic C02 emissions are defined as C02 emissions related
to the natural carbon cycle, as well as those resulting from the combustion, harvest, combustion,
digestion, fermentation, decomposition, or processing of biologically based materials. EPA provides
examples of biogenic C02 emissions including:

• C02 from the combustion of biogas collected from biological decomposition of waste in
landfills, wastewater treatment, or manure management processes

• C02 from combustion of the biological fraction of municipal solid waste or biosolids

• C02 derived from combustion of biological material, including forest-derived and
agriculture-derived feedstocks.

According to the LGOP, because of the distinction between biogenic and anthropogenic emissions,
local governments should track the biogenic C02 emissions from biomass combustion separately
from Scope 1 direct emissions. In addition, the LGOP advises the following:

"Biogenic emissions related to forestry and land management should not be quantified under
this Protocol as the Protocol is designed to account primarily for the anthropogenic sources of
GHG emissions, and is not designed to assess the carbon stocks of government-owned lands
(see Section 2.3 in the LGOP). Biogenic emissions also occur from sources other than
combustion, such as the aerobic decomposition of organic matter. These non-combustion
biogenic emissions should not be included in your GHG inventory."

Emission factors for each calculation are included in the "Factors" worksheet of the module, and
specific sources for each of the emission factors are provided in the table below.

Scope 1

Emission Factor Source

Stationary Combustion

US EPA Mandatory Reporting Rule

Mobile Combustion

U.S. EPA, National GHG Inventory

Solid Waste

U.S. EPA, National GHG Inventory

Wastewater

U.S. EPA, National GHG Inventory

Scope 2

Electricity Use

EPA's eGRID

Scope 3

Employee Commute

U.S. EPA, National GHG Inventory

Agriculture & Land Management

U.S. EPA, National GHG Inventory

Urban Forestry

U.S. EPA, State Inventory Tools

Waste Generation

U.S. EPA, National GHG Inventory

Water Use

California Energy Commission

Local Greenhouse Gas Inventory Tool: Government Operations Module 13

May 2015

-------
U.S. Environmental Protection Agency

3. Sheet Instructions and Methodology

This section provides a guide to using the Government Operations Module to estimate greenhouse
gas emissions from municipal government operations. The methods and default values used for the
inventory component of this tool are from the LGOP. Calculation sheets are provided so that
methods and emission estimates are transparent in the tool. Instructions for completing each sheet
of the tool are below.

Control Sheet

Use the Control Sheet to configure the tool to your local government. Enter up to 20 municipal
departments, identify city electricity providers, and click the "Set Up" button (in Step 4 at the
bottom of the Control Sheet) to get started.

The module can be used to inventory GHG emissions from 2000 through 2020. EPA decided not to
include inventory years going back to 1990, as there is limited availability of emission factors dating
back to 1990 and local governments will likely not have data going back to 1990. According to the
LGOP, "It is good practice to compile an emissions inventory for the earliest year for which complete
and accurate data can be gathered. The base year for the UNFCCC and subsequent Kyoto Protocol is
calendar year 1990. However, required data from 1990 is often prohibitively difficult or impossible
to collect. Given that the priority for a greenhouse gas management program should be on practical
results, it is more important that the base year be documented with enough detail to provide a good
basis for local action planning than it is that all local governments produce an inventory with the
same, stipulated base year."

NOTE: Once you click the "Set Up" button, you may not go back and change city departments you
have already entered. You may add city departments, but be sure to click "Set Up" again.

Stationary Combustion and Electricity Consumption
Inventory Sheets

Entry Sheets

Enter annual stationary fuel use and electricity consumption for each entity for which you have data
in the yellow cells. These entities may be of any scale—the entire municipality, municipal
departments, buildings, or individual equipment such as furnaces. To use the form, first enter the
data for a given unit (Unit Description, Facility Type, Department, Fuel Type, and Fuel Consumption),
then click "Add/Update Record." The data will be saved in a data sheet, and the fields will remain
with the current data entered. The purpose of this process is to facilitate similar data entries for
multiple entries. You will receive a confirmation message when the record has been successfully
added. At any point, you may click "Reset Form" to clear all fields. If you would like to enter more
than one record at a time, you may proceed to the "Stationary-Data" or "Electricity-Data" sheet and
directly add data there.

If you would like to change any aspect of a previous entry, select "Edit Record." A drop-down menu
will appear. Select the entry you would like to change, make changes to the entry fields as needed,

Local Greenhouse Gas Inventory Tool: Government Operations Module 14

May 2015

-------
U.S. Environmental Protection Agency

and then click "Add/Update Record." To delete a record entirely, click the "Delete Record" button. A
dropdown menu will appear that contains the previously entered data. Select the entry to delete
from the drop-down, and confirm that this entry should be deleted. After you confirm that you
would like the entry deleted, the saved data will be erased.

If you enter data at the facility level, please specify the type of facility from the dropdown menu
under "Facility Type (if applicable)." Types of facilities include office buildings, warehouses, outdoor
lighting, wastewater infrastructure, health, school, and other.

Data Sheets

Data entered through the Entry Sheet forms appears here (Figure 6). If you would like to upload a
large set of data without using the form, you may do so by clicking the blue "Create Data File
Template" button. This will open up a new batch data template file, which has two tabs. The "Read
Me" tab explains any restrictions (such as units) you need to know when preparing your data file.
Complete the template data sheet with your data, then copy and paste it into the Data sheet below
the "Saved Data" section, beginning in Row 9.

Figure 6. Stationary and Electricity Data Sheets

Municipal GHG Planning fool 6-13-lla.xlsm - Microsoft Excel
Ins Acrobat

w s

A cut
§2 Copy
/ Format Painter
Opboud

Formulas

Page Layout
Csllbri * |ll *

B I n -11A •

Developer

SfE Merge & Center -
ignraent 15 1'

$ % •

Number

--¦IS

Formatting *

Normal 3
Format Bad

Normal_DVR.
Good
Styles

I... | Normal
Neutral

I- & 5a

Insert Delete Format

SM*-, Aj ft

Sort & Find &
.2 Clear* Filter- Select -

Electricity-Data

I Check if you have completed this sheet.

This sheet stores the individual data records added via the form on the previous sheet. If you wish to add multiple records at once
without using the input form, you may directly add data to this sheet. Please clickon the button to the right to generate a template file
with instructions for this process. Please be careful to follow the instructions and enter data using the format and parameters specified
in the template.

Create Data File
Template

Unit Description
Saved Data

Electricity Consumed (kWh) Facility Type

1111 First Street

Municipal Services

Southern California Edison

101910

Office Bu

ding

City Building

Municipal Services

Southern California Edison

118200

Office Bu

ding

15 Elm Street

Building

Southern California Edison

1672381

Office Bu

ding

Fire Station 1
Fire Station 2

Fire

Southern California Edison
Southern California Edison

139400
103240

Other
Other

Police Station B
Administrative Buildings

Police

Municipal Services

I^I^^^California Edison
SouthemCanr^^MMtt^

281840

Other
Office Bu

ding

Oak Plaza
Central Park

Municipal Services
Parks & Maintenance

Southern California Edison
Southern California Edison

117020

96 Street Building

Municipal Services

Southern California Edison

55950

Other

95 Dunster Street

Municipal Services

Southern California Edison

64680

Other

Finance Department

Finance

Southern California Edison

90990

Office Bu

ding

Art Museum

Municipal Services

Southern California Edison

97920

Other

Small Library

Library

Southern California Edison

133320

Other

33 Hayden Ave

Municipal Services

Southern California Edison

1362188

Office Bu

ding

City Hall

Municipal Services

Southern California Edison

122760

Office Bu

ding

Police Station A

Police

Southern California Edison

3431920

Other

Public Library

Library

Southern California Edison

841483

Other

City Building 2

Municipal Services

Southern California Edison

219040

Other

California Street

Municipal Services

Southern California Edison

56800

Office Bu

ding

M~4

~ n

TOC Definitions Sheet Factors

Control Sheet Stationary-Entry . Stationary-Data Stationary-Calcs

Electricity-Entry Electricity-Data Electriciti

Click here to
generate a
template file

Paste data from template file
here beginning in row 9. If
not using batch import, data
will appear here as entered
on Entry sheet.

Average: 957442.625

Sum: 45957246 |

The process for completing the mobile combustion sector follows nearly the same format as the
stationary and electricity sectors. However, due to the complicated nature of mobile emissions
calculations, one extra step is required. After all data has been entered, either through the Entry
Sheet form or the batch data template file, you must click the "Update Calculations" near the
bottom of the Mobile Entry sheet, as shown below in Figure 7.

Local Greenhouse Gas Inventory Tool: Government Operations Module 15

May 2015

-------
U.S. Environmental Protection Agency

Figure 7. Mobile Entry—Update Calculations

ft, \ J i ¦ ¦

Municipal GHG Planning Tool 6-13-llaj(lsm

- Microsoft Excel

a x

L A) .— : .

— Home Insert Page layout Formulas

Data Review View Developer Add-lns Acrobat

® -

" *

||jcalibrl -|ll

~~ ^ C°W ir If—

J Format Painter B ' » '1 J '

a" s S s Wrap Tent General •

Normal 3 | Normal_DVR... | Normal

BP)

[J Fill -
^2 Clear -

¦ &

Formatting - as Table -

Bad Good Neutral

sort a find a
Filter - Selecl*

Clipboard 11 Fort

:| Alignment * j | Number hm |

Styles

CtHs

Editing J

mob_entry_ID ~ f* \ 1

A B

C D

E F G

H 1

J K

L | M j

J Mobile-Entry

Return to Table of
Contents

J1? Check if you have completed this ^^tj

Afteryou have completed data entry, please click on the "Update Calculations" button in Step 3.

Add/Update Record Edit Record Delete Record

1) Describe the vehicle(s) you are entering

ID# Vehicle or vehicle group description

Vehicle Year

Vehicle Model (optional)

2) Enter the activity data for the year 2008

Fuel consumed ():

Vehicle miles traveled (VMT)*

* Helpful Hint: if you do not know the VMT for this entry, you can multiply the fuel consumed by the
MPG of the vehicle/vehicle group. Use your own efficiency data or see the table below for average MPG
by vehicle type and fuel. vehicle Miles = Gallons • Miles/Gallon

Click "Update Calculations" once all mobile
combustion data has been entered

Stationary-Entry Stationary-Data . Stationary-G

Solid Waste Inventory Sheets

Control Sheet

On the control sheet, first select whether your municipality has operational control over any
landfills. If not, you may opt to use the U.S. Environmental Protection Agency's (EPA) Waste
Reduction Model (WARM) to calculate your Scope 3 emissions. This step is optional, but can also be
used to calculate waste emission reductions.

For every landfill over which you have operational control, please select whether those landfills have
landfill gas collection systems and whether those systems are comprehensive or partial. Under the
LGOP, landfill gas (LFG) collection systems are considered "comprehensive" if the landfill is required
to have a LFG collection system under EPA's New Source Performance Standards or a system more
stringent as dictated by local regulations.

For these landfills that do not have LFG collection systems, you need to use the California Air
Resources Board's (CARB) Landfill Emissions Tool, which is based on the IPCC First Order Decay
(FOD) model. To use the model, you will need the annual waste deposited in each landfill as well as
the opening and closing year of each landfill. Once you have run the model, please paste the final
methane (CH4) emissions output for each landfill in the yellow cells on in the tool.

Calculations Sheet

Depending on your entries on the Solid Waste control sheet, you will be presented with formulas to
calculate your city's emissions from solid waste management. Enter values requested in the pale

Local Greenhouse Gas Inventory Tool: Government Operations Module 16

May 2015

-------
U.S. Environmental Protection Agency

yellow cells. Click on the checkbox to use default values for the fraction of CH4 in your city's landfill
gas. Your solid waste emissions will be summarized at the bottom of the sheet.

Wastewater Treatment Inventory Sheets
Control Sheet

On the wastewater control sheet, answer the series of questions about the type(s) of wastewater
treatment systems in your municipality. For every type of system (anaerobic or aerobic treatment
with or without nitrification/denitrification), you will be asked to provide the population served by
that system on the entry sheet. You will also answer questions about data availability for your
wastewater treatment systems.

Entry Sheet

The wastewater entry sheet provides data input cells based on your answers to the questions on the
wastewater control sheet. Enter data in the yellow cells in the specified units is requested.

Calculations Sheet

The calculation sheet shows the formulas used to determine your city's emissions from wastewater
treatment, using methodology from the LGOP. The gray cells link to the values you entered on the
Wastewater Entry Sheet.

Your total emissions are summarized in the table at the top of the sheet. You may scroll down to
view the detailed calculations, but no action is required on this sheet. If you would like to change
any of the entered values, you may do so on the entry sheet.

Employee Commute Inventory Sheet

The employee commute sheet will calculate Scope 3 emissions from employee commutes to work.
In the yellow cells, enter the number of employees per department, the proportion of those
employees who take various modes of transportation to work, average commute distance, and the
annual number of work days. Default data for every entry except number of employees has been
provided, but you may change them if you have better data.

Once you enter this information, the total emissions from employee commutes will be calculated.

Imported Water Inventory Sheet

The water sheet is where you will calculate the Scope 3 emissions associated with imported water
consumption by your municipal government. These emissions are indirectly associated with
electricity use and other emissions required to provide water to your city. This does not include the
electricity or energy use used directly at city water facilities. Any such electricity use associated with
water within your city (such as city water pumps) should be entered under the Electricity tab.

If your city imports water, enter the amount of water consumed by department during the
inventory year and where that water is imported from. Each import source is associated with

Local Greenhouse Gas Inventory Tool: Government Operations Module 17

May 2015

-------
U.S. Environmental Protection Agency

different emission factors, and will be used to calculate your city's indirect emissions from water
consumption.

Agriculture & Land Management Inventory Sheet

The agriculture & land management sheet is where you will calculate the Scope 3 emissions
associated with fertilizer application by your municipal government. These emissions are associated
with the application of synthetic, organic, and manure fertilizers. A portion of applied fertilizers
volatilize into the air in the form of N20.

Once you enter the information for each department on the amount of fertilizer applied by fertilizer
type, the total emissions from this source will be calculated.

Urban Forestry Inventory Sheet

The urban forestry sheet is where you will calculate the Scope 3 emissions associated with urban
trees (street trees, trees in parks, etc.) managed by your municipal government. Changes in carbon
stocks in urban trees are calculated by estimating the total urban area, the percent of that urban
area with tree cover, and applying a carbon storage factor to estimate carbon sequestration from
urban trees. Note the LGOP states that biogenic forestry emissions are not quantified under the
LGOP and can be reported optionally (see Section 2.3 in the LGOP). EPA decided to include these
estimates in the tool so that local governments could optionally estimate carbon stocks of
government-owned land if this was applicable.

Once you enter the information on the urban tree coverage for each department, the total carbon
sequestration from this source will be calculated.

Waste Generation Inventory Sheet

The waste generation sheet is where you will calculate the Scope 3 emissions associated with the
decomposition of waste generated within your borders by government operations, but landfilled
elsewhere. This sheet applies to waste produced directly or indirectly by government operations
activities and disposed of in a solid waste facility not operated by the municipality. To calculate
Scope 3 emissions from waste, utilize EPA's WAste Reduction Model (WARM) either as a web-based
calculator or an Excel spreadsheet. If the waste is disposed of in a facility operated by the
municipality, emissions should be calculated as Scope 1 emissions on the Solid Waste-Control and
Solid Waste-Entry sheets.

Once you enter the information for each department on the waste generation, the total emissions
from this source will be calculated.

Additional Sources Inventory Sheet

Use this sheet to enter emissions from any additional sources you would like to include in your
inventory. Assign each source to a city department, note what scope the emissions fall under, and
enter any greenhouse gas emissions in metric tons of carbon dioxide equivalent (MTC02e). In
Chapter 11, the LGOP provides a list of other processes and fugitive emissions that could be

Local Greenhouse Gas Inventory Tool: Government Operations Module 18

May 2015

-------
U.S. Environmental Protection Agency

estimated outside of the tool, and the results of the emissions calculations can be input on this

sheet.

4. Uncertainty

The GHG inventory component of the tool follows the methodology of the LGOP. Users should refer

to the LGOP for a discussion of the uncertainty associated with default assumptions.

5. Tool References

These references refer to resources cited in the Local Greenhouse Gas Inventory Tool:

Government Operations Module as well as in the User's Guide.

LGOP (Local Government Operations Protocol). 2010. Local Government Operations Protocol,
Version 1.1. California Air Resources Board, California Climate Action Registry, ICLEI - Local
Governments for Sustainability, and The Climate Registry. Available at:
http://www.arb.ca.gov/cc/protocols/localgov/localgov.htm.

CEC (California Energy Commission). 2000-2010. Total Electricity System Power. California Energy
Commission. Available at: http://energyalmanac.ca.gov/electricity/total_system_power.html.

CEC (California Energy Commission). 2006a. California Commercial End-Use Survey. California Energy
Commission. Available at: http://www.energy.ca.gov/ceus/.

CEC (California Energy Commission). 2006b. Refining Estimates of Water-Related Energy Use in
California. California Energy Commission. CEC-500-2006-118. Available at:
http://www.energy.ca.gov/2006publications/CEC-500-2006-118/CEC-500-2006-118.PDF.

FHWA (Federal Highway Administration). 2010. Highway Statistics 2008. Federal Highway
Administration, U.S. Department of Transportation. Available at:
http://www.fhwa.dot.gov/policyinformation/statistics/2008/.

U.S. Census Bureau. 2008. American Community Survey: Table S0801 - Commuting Characteristics.
U.S. Census Bureau. Available at:

http://factfinder2.census.gov/faces/nav/jsf/pages/index.xhtml.

U.S. EPA. 2010. Inventory of U.S. Greenhouse Gas Emissions and Sinks: 1990-2008. Office of
Atmospheric Programs, U.S. Environmental Protection Agency. EPA 430-R-06-002.

U.S. EPA. 2012. eGRID 2012 Version 1.0. Office of Clean Energy, U.S. Environmental Protection
Agency. Available at: http://www.epa.gov/cleanenergy/energy-resources/egrid/index.html.

U.S. EPA. 2010. eGRID 2007 Version 1.0. Office of Clean Energy, U.S. Environmental Protection
Agency. Available at: http://www.epa.gov/cleanenergy/energy-resources/egrid/index.html.

U.S. EPA. 2007. eGRID 2005 Version 1.1. Office of Clean Energy, U.S. Environmental Protection
Agency. Available at: http://www.epa.gov/cleanenergy/energy-resources/egrid/index.html.

Local Greenhouse Gas Inventory Tool: Government Operations Module 19

May 2015

-------
U.S. Environmental Protection Agency

U.S. EPA. 2002. Updating Fuel Economy Estimates in MOBILE6.3 - DRAFT. U.S. Environmental
Protection Agency. EPA420-P-02-005. Available at:
http://www.epa.gov/oms/models/mobile6/p02005.pdf.

6. Additional Resources

Below are additional resources that can help facilitate the development of your local government
GHG inventory.

Resource Name

Link

ENERGY STAR Portfolio Manager http://www.energystar.gov/buildings/about-us/how-can-we-help-

you/benchmark-energy-use/use-energy-star-benchmarking-tools

Local Government Operations http://www.arb.ca.gov/cc/protocols/localgov/localgov.htm
Protocol

Landfill Emissions Tool http://www.arb.ca.gov/cc/protocols/localgov/localgov.htm

EPA MOVES on-road Emissions http://www.epa.gov/oms/stateresources/ghgtravel.htm
Model

Local Climate Action Framework http://epa.gov/statelocalclimate/local/implementation/inventory.html

Local Greenhouse Gas Inventory Tool: Government Operations Module 20

May 2015

-------