User’s Guide for States Using the Greenhouse Gas Synthesis Tool March 2018


User's Guide for States Using
the Greenhouse Gas Synthesis
Tool

March 2018

Prepared by:
ICF

Prepared for:

State Energy and Environment Program,
U.S. Environmental Protection Agency

This section of the User's Guide provides instruction on using the Synthesis Tool module of
the State Inventory Tool (SIT).

-------
Table of Contents

1.1	Getting Started	1

1.2	Synthesis Tool Overview	2

1.2.1	Data Requirements	3

1.2.2	Tool Layout	3

1.3	Methodology	3

1.4	Conclusion	6

-------
The Synthesis Tool

March 2018

1.1 Getting Started

The Synthesis Tool was developed using Microsoft® Excel 2000. While the module will
operate with older versions of Excel, it functions best with Excel 2000 or later. Some of the
Excel basics are outlined in the steps below. Before you use the Synthesis Tool, make sure
your computer meets the system requirements. In order to install and run the Synthesis
Tool, you must have:

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

• Microsoft® Excel 1997 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

Excel 2003 and Earlier: For the SIT modules to function properly, Excel must be set to
automatic calculation. To check this setting, launch Microsoft Excel before opening the
Synthesis module. Go to the Tools menu and select "Options..." Click on the "Calculations"
tab and make sure that the radio button next to "Automatic" is selected, and then click on
"OK" to close the window. The security settings (discussed next) can also be adjusted at
this time.

Excel 2007: For the SIT modules 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 from the pop-up menu.

Microsoft Excel Security

Excel 2003 and Earlier: Since the SIT employs macros, you must have Excel security set
to medium (recommended) or low (not recommended). To change this setting, launch
Microsoft Excel before opening the Synthesis module. Once in Excel, go to the Tools menu,
click on the Macro sub-menu, and then select "Security" (see Figure 1). The Security pop-
up box will appear. Click on the "Security Level" tab and select medium. When set to high,
macros are automatically disabled; when set to medium, Excel will give you the choice to
enable macros; when set to low, macros are always enabled.

When Excel security is set to medium, users are asked upon opening the module whether to
enable macros. Macros must be enabled in order for the Synthesis module to work. Once
they are enabled, the module will open to the control worksheet. A message box will
appear welcoming the user to the module. Clicking on the "x" in the upper-right-hand
corner of the message box will close it.

Excel 2007: If Excel's security settings are set at the default level a Security Warning
appears above the formula box in Excel when the Synthesis module is initially opened. 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 SIT needs macros in order to function properly, the user must click the
"Options" button in the security message and then select, "Enable this content" in the pop-
up box. Enabling the macro content for the SIT in this way only enables macros temporarily
in Excel but does not change the macro security settings. Once macros are enabled, a

State Greenhouse Gas Inventory Tool User's Guide for the Synthesis Tool 1.1

-------
The Synthesis Tool

March 2018

message box will appear welcoming the user to module. Click on the "x" in the upper right-
hand corner to close the message box.

If the Security Warning does not appear when the module is first opened, it may be
necessary to change the security settings for macros. To change the setting, first exit out
of the Synthesis module and re-launch Microsoft Excel before opening the Synthesis
module. Next, click on the Microsoft Excel icon in the top left of the screen. Scroll to the
bottom of the menu and select the "Excel Options" button to the right of the main menu.
When the Excel Options box appears, select "Trust Center" in left hand menu of the box.
Next, click the grey "Trust Center Settings" button. When the Trust Center options box
appears, click "Macro Settings" in the left hand menu and select "Disable all macros with
notification." Once the security level has been adjusted, open the Synthesis module and
enable macros in the manner described in the preceding paragraph.

Viewing and Printing Data and Results

The Synthesis Tool contains some features to allow users to adjust the screen view and the
appearance of the worksheets when they are printed. Once the tool has been opened, you
can adjust the zoom by going to the Module Options Menu, and either typing in a zoom
percentage or selecting one from the drop down menu. In addition, data may not all appear
on a single screen within each worksheet; if not, you may need to scroll up or down to view
additional information.

You may also adjust the print margins of the worksheets to ensure that desired portions of
the Synthesis Tool are printed. To do so, go to the File menu, and then select "Print
Preview." Click on "Page Break Preview" and drag the blue lines to the desired positions
(see Figure 2). To print this view, go to the File menu, and click "Print." To return to the
normal view, go to the File menu, click "Print Preview," and then click "Normal View."

Figure 1. Changing Security Settings

E Microsoft Excel - Bookl

:3j File Edit

View Insert Format I

Tools | Data Window Help

&
1>

Spelling...
Research,,,

Error Checking,,.

Alt+Click

I B I

C I

1 1

J 1

K 1

Speech

Shared Workspace.,,

Share Workbook...

~7_\

Track Changes

Compare and Merge Workbooks..,

Protection
Online Collaboration

Goal Seek...
Scenarios...

Formula Auditing

| Macro ~ |

1 Macros... Alt+F8
Record New Macro...

Add-Ins,,.

¦P

- 1

| Security...

Hutoi-orrecc upnons...
Customize,..

| Visual Basic Editor Alt+Fll

Options..,

> Microsoft Script Editor Alt+Shift+Fll

Figure 2. Adjusting Print Margins

1.2 Synthesis Tool Overview

The Synthesis Tool was designed as a companion to EPA's State Inventory Tool (SIT), which
estimates state-level emissions for 1990-2020. Users who have completed the historical

State Greenhouse Gas Inventory Tool User's Guide for the Synthesis Tool

1.2

-------
The Synthesis Tool

March 2018

emission estimation process using the SIT modules can import the historical emissions into
the Synthesis Tool to compile the time series for all modules from 1990 through 2020.

1.2.1 Data Requirements

Before using this module, the user should conduct greenhouse gas inventories for all
applicable sources using the individual sector modules. The individual sector modules
include the following: CO2 from Fossil Fuel Combustion, Electricity Consumption, Stationary
Combustion, Mobile Combustion, Coal Mining, Natural Gas and Oil Systems, Industrial
Processes, Agriculture, Land Use, Land-Use Change and Forestry, Municipal Solid Waste,
and Wastewater.

After completing each sector inventory, the user should export the data using the "Export
Data" button provided in the final step of each sector module. The modules will then create
an output file using a default file name. Please do not change the file names or alter the
output files in any way. Once the output files have been generated, the Synthesis module
can then be used.

1.2.2 Tool Layout

Since there are multiple steps to complete within the Synthesis Tool, it is important to have
an understanding of the Tool's overall design. The layout of the Synthesis Tool is presented
in Figure 3.

Figure 3. Flow of Information in the Synthesis Tool

Control Worksheet



Module Worksheets (for Reviewing Data)

1. Choose a State





2. Locate Output File, Import, and Review Data for Each Module:

C02 from Fossil Fuel Combustion ~~~\



Z02 from Fossil Fuel Combustion

Indirect C02 from Electricity Consumption



Indirect C02 from Electricity Consumption

Stationary Combustion



Stationary Combustion

Mobile Combustion



Mobile Combustion

Coal Mining

v J

Coal Mining

Natural Gas and Oil Systems

> , 3

Natural Gas and Oil Systems

Industrial Processes



Industrial Processes

Agriculture



Agriculture

Land-Use Change and Forestry



Forest Management and Land-Use Change

Municipal Solid Waste



Municipal Solid Waste

Wastewater



vJVastewater

3. Select Units and View Summary Worksheets^	> Summary Data





J By Sector: presented in table and graphical formats





I By Gas: presented in table and graphical formats





t By Intensity: presented in table and graphical formats

1.3 Methodology

This section provides a guide to using the Synthesis Tool to import emission estimates from
completed modules of the SIT. The following three steps describe how to import and view
the estimates provided by the eleven SIT modules: (1) select a state on the control
worksheet; (2) locate output file, import, and review data for each module; (3) select units
and view summary information.

State Greenhouse Gas Inventory Tool User's Guide for the Synthesis Tool

1.3

-------
The Synthesis Tool

March 2018

Step (1): Select a State on the Control Worksheet

To begin, select the state you are interested in evaluating. By selecting a state, the rest of
the tool will automatically reset to reflect the appropriate state default data and
assumptions for use in subsequent steps of the tool.

Step (2): Locate Output File, Import, and Review Data for Each Module

This step involves importing the output files containing emission estimates from the
individual modules. While the CO2 from Fossil Fuel Combustion (CO2FFC) module will be
used as an example of how to import and review data, the importing process is identical
across for all eleven SIT modules.

On the control worksheet, select the "Get CO2 from Fossil Fuel Combustion Data" button.
Once this button is selected, you will be prompted to locate the summary file exported from
the CO2FFC module (called "C02FFC_Summary") as shown in Figure 4.

Figure 4. Example of Importing Data in the Synthesis Tool

Sjj File Edit Module Options

Ostate Inventory Tool - Synthesis Module

State Inventory Tool - Synthesis Too/

This too! will collect data from the individual sector modules and combine them, the final step in conducting a/SHS inventory for your state.

Before using this module, the user should conduct greenhouse gas inventories for all applicable sources using the individual sector modules. After completing each sector
inventory, the user should export the data using the button provided in the final step of each sector module. The modules will then create an output file using a default file
name. Please do not change the file names or alter the output files in any way. Once all ten output files have been generated, the user of this Synthesis module should then
begin here by choosin2_astateiBiste£^;_whenJhe_user clicks on the buttons to get the data the user will be prompted to locate the output files. This module will then open
the specified file
the Synthesis Tool f

Select State

to attain correct

Its, please be sure to choose the proper f i les when prompted. Please see the User "s Guide for

Consult User's Guide |

| Colorado

2. Locate Output File Import, and Review Data for Each Module

Prompt to
Locate File

CO2 from Fossil Fuel Combustion
COj from Electricity Consumption
Stationary Combustion
Mobile Combustion
Coal Mining

Natural Gas and Oil Systems
Industrial Processes
Agriculture

Land Use, Land-Use Change, and Forestry
Municipal Solid Waste
Wastewater
3. View the Summary Sheets:

Get COZ from FF Combustion Data
Get C02 from ElectricityConsumption Data

Review Data

>
>

Get Mobile Combustion Data

Synthesis Tool

Please locate the summS^ file named C02FFC_5ummary.xls

Get Coal Data

Natural Gas end Oil Data

1 » 1

Get Industrial Processes Data

_J 1

Review Data

Get Agriculture Data

Review Data

Get Forestry Data

Review Data

Get Waste Data

Review Data

Get Wastewater Data

Review Data

Go to Summary by

Go to Summary by
Gas

y Go to Summary by^x.

y/ Intensity s'

If the file is imported successfully, the current date and time will appear in the column titled
"Summary File Imported on". This timestamp is useful to have if you are completing an
inventory on an annual basis and would like to know the last time data was imported into
the Synthesis Tool.

To review the data that was imported for a given module, click on the gray navigational
arrow to the right of the module you would like to review. The summary data worksheet by
sector for the CO2 from Fossil Fuel Combustion is shown in Figure 5. To return to the
control worksheet, click on the gray navigational arrow.

State Greenhouse Gas Inventory Tool User's Guide for the Synthesis Tool 1.4

-------
The Synthesis Tool

March 2018

Figure 5. Example of CQ2FFC Summary Worksheet

B State Inventory Tool - Synthesis Module



























I ^ File Edit Module Options



















Type a question For help



1































Summary or COZ Emissions from rossi rue

	

























Sheet



==



Return to



























.



























Control











1990

1991

1992

1*93

1994

1995

199«

1997

1998

1999

2000

20•



Residential

1.44

1.57

1.50

1.66

1.55

1.66

1.76

1.71

1.62

1.74

1.86

1.9



Coal

0.01

0.01

0.01

0.00

0.00

0.00

0.00

0.00

0.00

0.01

0.00

0.0



Petroleum

0.11

0.12

0.11

0.12

0.12

0.14

0.14

0.03

0.02

0.13

0.18

0.1



Natural «9os

1.33

1.44

1.39

1.54

1.43

1.52

1.62

1.68

1.60

1.61

1.67

1.7



Commercial

1.08

1.16

1.11

1.16

1.10

1.09

1.15

1.14

1.03

1.04

1.03

1.2



Coal

0.03

0.03

0.03

0.02

0.01

0.01

0.01

0.03

0.01

0.05

0.04

0.1



Petroleum

0.10

0.11

0.11

0.10

0.14

0.11

0.13

0.11

0.11

0.13

0.11

0.:



Natural Gos

0.96

1.02

0.97

1.04

0.95

0.97

1.01

1.00

0.91

0.85

0.87

0.9



Industrial

1.91

2.16

2.22

2.41

2.27

2.24

2.30

2.40

2.52

2.46

2.62

3.5



Coal

0.40

0.41

0.38

0.43

0.48

0.41

0.21

0.41

0.21

0.23

0.23

0.1



Petroleum

0.57

0.59

0.70

0.65

0.60

0.60

0.69

0.71

0.70

0.66

0.74

0.8



Natural Gas

0.94

1.17

1.14

1.34

1.19

1.22

1.41

1.28

1.61

1.57

1.64

2.1



Transportation

5.16

5.20

5.27

5.79

5.87

6.04

6.16

6.11

6.41

6.83

6.90

7.2



Coal





























Petroleum

5.02

5.08

5.14

5.68

5.72

5.87

5.99

5.93

6.27

6.70

6.76

7.1



Natural <9as

0.13

0.12

0.12

0.11

0.15

0.17

0.16

0.18

0.14

0.13

0.14

0.1



Electric Utilities

8.44

8.26

8.52

8.67

9.04

8.78

9.24

9.29

9.41

9.48

10.44

11.0



Coal

8.25

8.06

8.32

8.49

8.74

8.43

8.

81

8.88

8.90

8.85

9.45

9.7



Petroleum

0.01

0.01

0.01

0.00

0.00

0.00

0.01

0.00

0.01

0.01

0.02

0.0



Natural Gas

0.19

0.19

0.19

0.19

0.29

0.35

0.42

0.40

0.50

0.62

0.96

1.2



International Bunker Fuels



























Petroleum



























TOTAL

18.03

18.36

18.62

19.70

19.83

19.81

20.60

20.65

20.99

21.55

22.85

24.9

Coal

8.68

8.50

8.73

8.93

9.24

8.85

9.03

9.32

9.12

9.14

9.73

10.0

Petroleum

5.81

5.91

6.07

6.55

6.59

6.73

6.96

6.77

7.10

7.63

7.83

8.2

Natural Gos

3.55

3.95

3.81

4.22

4.01

4.23

4.61

4.55

4.77

4.78

5.29

6.6





























Step (3): View Summary Information

Once the data from all of the modules has been imported, you can view estimates in
MMTCO2E on the final summary worksheet. A summary of the modules by sector, gas, or
intensity (per capita and by gross state product) is provided within the Synthesis module.
An example of the sector summary worksheet is shown in Figure 6. In addition, the results
are displayed in graphical format at the bottom of the summary worksheets.

State Greenhouse Gas Inventory Tool User's Guide for the Synthesis Tool

1.5

-------
The Synthesis Tool

March 2018

~ State Inventory Tool - Synthesis Module

Figure 6. Example of Summary Worksheet by Sector

i SJ File Edit Module Options

Summary of &HG Emissions by Sector in Colorado
(MMTCQ2E)	

Go to Summary by"-
Sas /

Go to Summary by
Intensity >

Indirect COj from Electricity Consumption*	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A 204.43

* Emissions from Electricity Consumption are not included in totals in order to avoid double counting with Fossil Fuel Combustion estimates.

Energy

CO2 from Fossil Fuel Combustion
Stationary Combustion
Mobile Combustion
Coal Mining

Natural Gas and Oil Systems
Industrial Processes
Agriculture

Enteric Fermentation
Manure Management
Rice Cultivation
Agricultural Soil Management
Burning of Agricultural Crop Waste
LULUCF
Waste

Municipal Solid Waste
Wastewater

1.4 Conclusion

Once the results of all eleven modules are imported into the Synthesis Tool, you will have a
complete inventory for your state. These results may be used to create an inventory
document, if you so desire. In addition, you may use these historical estimates as the basis
for emission projections in EPA's Projection Tool. For instructions on using the Projection
Tool, please consult the Projection Tool User's Guide.

State Greenhouse Gas Inventory Tool User's Guide for the Synthesis Tool

1.6

-------