How to Use the Efficient Producer
Lifecycle Greenhouse Gas Calculator
Version 1*1
oEPA
United States
Environmental Protection
Agency

-------
How to Use the Efficient Producer
Lifecycle Greenhouse Gas Calculator
Version 1.1
Transportation and Climate Division
Office of Transportation and Air Quality
U.S. Environmental Protection Agency
United States
Environmental Protection
^1	Agency
EPA-420-B-16-083
October 2016

-------
1. Introduction
The U.S. Environmental Protection Agency is providing instructions on how to use version 1.1 of the
Efficient Producer Lifecycle Greenhouse Gas Calculator (the "GHG Calculator"). The GHG Calculator is a
spreadsheet tool available for download through the EPA's website for the U.S. Renewable Fuel
Standard (RFS) program. It is intended to help ethanol producers understand and be able to reproduce
the Agency's lifecycle GHG calculations for certain types of ethanol evaluated through the Agency's
Efficient Producer petition process (EP3).1
Disclaimer: This document provides general information and is not intended to contradict the RFS
regulations at 40 CFR Part 80 Subpart M, or the signed determination documents issued pursuant to
the petition process at 40 CFR 80.1416. To the extent there are any discrepancies, the RFS
regulations and/or the petition determination documents control and override the information in
this document.
This document is intended for companies that are interested in using the GHG Calculator in the context
of the EP3. Specifically, it provides instructions on how to fill out and submit the GHG Calculator as part
of an Efficient Producer (EP) petition. It also explains how facilities that have already been evaluated
through the EP3 can use the GHG Calculator to calculate the rolling average lifecycle GHG emissions for
the fuel they produce through a qualifying facility/process.2
Table 1 summarizes the three different spreadsheets that EPA released in September 2014 as part of
version 1.0 of the GHG Calculator. As shown in the table, the three spreadsheets that comprised version
1.0 have been consolidated into one spreadsheet for version 1.1.
Table 1: Summary of Versions 1.0 and 1.1 of the Efficient Producer Lifecycle GHG Calculator
Version
Spreadsheet
For use by:
Version 1.0 GHG
Calculators
Efficient Producer Lifecycle GHG Calculator -
Dry Mill Corn Ethanol Version 1.0
Dry mill ethanol plant using only
corn starch feedstock
Efficient Producer Lifecycle GHG Calculator -
Dry Mill Grain Sorghum Ethanol Version 1.0
Dry mill ethanol plant using only
grain sorghum feedstock
Efficient Producer Lifecycle GHG Calculator -
Dry Mill Corn Starch and Grain Sorghum
Ethanol Version 1.0
Dry mill ethanol plant using only
corn starch and/or grain sorghum
feedstock
Version 1.1 GHG
Calculator
Efficient Producer Lifecycle GHG Calculator -
Version 1.1
Dry mill ethanol plant using only
corn starch and/or grain sorghum
feedstock
1	For information about the EP3, see the following EPA web page:
https://www.epa.gov/renewable-fuel-standard-program/how-prepare-efficient-producer-petition-under-
renewable-fuel
2	EPA petition evaluations are available on the agency's website:
https://www.epa.gov/renewable-fuel-standard-program/approved-pathways-renewable-fuel
1

-------
Since releasing version 1.0 of the GHG Calculator, the Agency has issued a significant number of EP
petition determinations and received valuable input from stakeholders. Based on the Agency's
experience and the input received, we made a number of improvements for version 1.1. These
improvements are summarized in Section 2 of this document.
Section 3 includes frequently asked questions about using the GHG Calculator. Section 4 provides an
overview of the GHG Calculator spreadsheet, and instructions on how to use each tab when preparing
an EP petition submission or using the GHG Calculator to calculate the rolling average lifecycle GHG
emissions for ethanol produced through a previously approved EP pathway.
The agency welcomes public input on improving the GHG Calculator and accompanying documentation.
Please send input to the EPA Fuels Programs Support Line at supportffiepamts-support.com and use the
subject line "Efficient Producer GHG Calculator." The EPA will make updates and improvements as
warranted based on public input and updates to the EP3.
2.	Improvements for Version 1.1
Based on the Agency's experience and input received, we made a number of improvements for version
1.1 of the GHG Calculator, including:
•	More detailed instructions
•	Consolidation from three spreadsheets to one
•	Modifications and updates to certain formulas3
•	New results summary tab and other user-experience updates
•	Updates to further expedite EPA review of EP petition submissions
3.	Frequently Asked Questions about Using the GHG Calculator
This section answers anticipated questions about the GHG Calculator, and includes contact information
for further questions.
What is the Purpose of the GHG Calculator?
The GHG Calculator is provided to help certain ethanol producers calculate the lifecycle GHG emissions
associated with their fuel using the EPA's methodology. The GHG Calculator serves two primary
functions:
1. Help producers prepare an EP petition submission: The GHG Calculator provides a tool that
allows producers to submit the mass and energy balance data required for EP petitions. It also
allows petitioners to see whether their pathway qualifies for the applicable lifecycle GHG
reduction thresholds based on the mass and energy data they provide. Further, it helps
expedite EPA petition reviews because the GHG results are automatically calculated. Before
starting an EP petition, please carefully review the information provided on EPA's website,
including the document titled How to Prepare an Efficient Producer Petition.4
3	Modified/updated formulas include standard volume calculations, fuel production process GHG emissions, and
consideration of periods of missing data.
4	https://www.epa.gov/renewable-fuel-standard-program/how-prepare-efficient-producer-petition-renewable-
fuel-standard
2

-------
2.	Help producers with an activated EP pathway calculate their fuel's 365-day rolling average
lifecycle GHG emissions as part of their ongoing recordkeeping and reporting requirements:
3.	Each of the EP determinations that EPA has completed specifies a number of conditions the
petitioner must satisfy in order to generate RINsfor non-grandfathered ethanol produced
through an EP pathway. One of the conditions is that the petitioner must have documentation
showing that RINs are only generated if, on average, all the ethanol they produced during a
specified averaging time period (typically 365 days or shorter in certain circumstances) satisfies
a certain lifecycle GHG reduction threshold. To satisfy this condition, the petitioner calculates
their fuel's 365-day rolling average lifecycle GHG emissions according to the formulas specified
in the EP determination document issued to the petitioner by EPA. The EPA has provided the
GHG Calculator spreadsheet on its website to help ethanol producers calculate the 365-day
rolling average lifecycle GHG emissions for their fuel.
Why should I include the GHG Calculator as part of my EP petition submission?
The RFS regulations (see 40 CFR 80.1416) specify that all petitions for new fuel pathways must include a
mass and energy balance for the requested pathway. For an EP petition this requirement is satisfied by
including a GHG Calculator that has been properly filled in with data about your fuel production process.
Furthermore, the GHG Calculator is set up to calculate the lifecycle GHG emissions for the ethanol
produced at your facility, so it can provide a demonstration of how your facility can meet the required
GHG reduction thresholds.
What data are required to complete the GHG Calculator for an EP petition submission?
The GHG Calculator requires the following data inputs:
•	Volume of feedstocks used in fuel production processes for all of the ethanol produced at your
facility during a specified time period (including ethanol that does not generate RINs or is
exempt from the GHG reduction requirements per 40 CFR 80.1403).
•	All of the energy used for feedstock, fuel and co-product operations.5
•	The volume of ethanol produced by your facility.
For your petition, data should be provided for a period of time encompassing at least 365 consecutive
days. Either historical or projected data are acceptable. If you provide historical data for your facility,
include at least the most recent 365-day period. Projected data may be more appropriate if your facility
is undertaking process efficiency improvements or for other reasons. If projected data is provided, then
it should be representative of anticipated average annual facility operations.
Do I need to enter daily data in the GHG Calculator when submitting an EP petition?
No, not when submitting an EP petition. However, daily data are required when using the GHG
Calculator to calculate the rolling average lifecycle GHG emissions for ethanol produced through a
previously approved EP pathway (and for associated recordkeeping).
5 Energy for feedstock, fuel and co-product operations should include all energy used in any building that is used in
any part for the storage and/or processing of feedstock and all energy used in any building that is used in any part
for the production and/or storage of fuel intermediates, finished fuel or co-products. It also includes any energy
related to feedstock or waste handling.
3

-------
When entering data into the GHG Calculator for an EP petition submission there are two options: (1)
enter daily data using one row for each day, or (2) enter aggregate data using one row for a period of
time encompassing at least 365-consecutive days. Examples of how each option would look for
electricity use data are shown below in Figure 1 and Figure 2. In both figures, the facility uses 100 kWh
of electricity each day. In Figure 1, these data are entered for 365 separate days. In Figure 2, the total
electricity use during the 365-day period is entered in one row corresponding with the first day in the
time period. Both approaches are equally valid when preparing the GHG Calculator for an EP petition.
Using the daily data approach illustrated in Figure 1, the GHG Calculator will pull data from all of the
rows encompassing the time period from 4/1/2014 to 3/31/2015. Using the aggregate data approach
illustrated in Figure 2, the GHG Calculator will only use the data entered in the first row.
Figure 1: Example of daily electricity use data entered using one row for each day


Meter 1
Day
Daily Electricity
Use
Previous Day
Meter Reading
Daily Meter
Reading
Daily Amount
Used
DD/MM/YYYY
Amount (kWh)
Amount (kWh)
Amount (kWh)
Amount (kWh)
4/1/2014
100
-
100
100
4/2/2014
100
100
200
100
[...]
[...]
[...]
[...]
[...]
3/30/2015
100
36,300
36,400
100
3/31/2015
100
36,400
36,500
100
Figure 2: Example of aggregate electricity use data entered using one row for a period encompassing
at Least 365-Consecutive Days


Meter 1
Day
Daily Electricity
Use
Previous Day
Meter Reading
Daily Meter
Reading
Daily Amount
Used
DD/MM/YYYY
Amount (kWh)
Amount (kWh)
Amount (kWh)
Amount (kWh)
4/1/2014
36,500
-
36,500
36,500
4/2/2014
-
36,500

(36,500)
4/3/2014
-
-

-
If you use the aggregate data entry approach shown in Figure 2, in the Cover Sheet tab you must enter
the first date in the time period you are entering data for in both of the Averaging Time Period fields.
We also ask that you explain the time period for the aggregate data in the Notes section, as shown
below in Figure 3.
Figure 3: Example of how to fill out the Averaging Time Period fields in the Cover Sheet when entering
aggregate data for a time period from 4/1/2014 to 3/31/2015
Averaging Time Period

Earliest date that you are entering data for (DD/MM/YYYY):
4/1/2014
Latest date you are entering data for (DD/MM/YYYY):
4/1/2014
4

-------

Data for the 365-day period

from 4/1/14 to 3/31/15 are
Notes:
entered in one row.
What if the GHG Calculator shows that my fuel does not meet the applicable GHG
reduction threshold?
If you are using the GHG Calculator for an EP petition submission, the data entered into the GHG
Calculator and submitted as part of your EP petition should demonstrate that your fuel meets the
applicable GHG reduction threshold (20% reduction for renewable fuel or 50% reduction for advanced
biofuel). If you submit a GHG Calculator that does not demonstrate adequate GHG reductions, EPA will
return your petition as incomplete.
Please keep in mind that should your EP pathway be approved and activated, in order to generate RINs
through your activated EP pathway you will need to monitor, calculate and record your fuel's lifecycle
GHG emissions on a 365-day rolling average basis to demonstrate that it is meeting the applicable GHG
reductions. If the GHG Calculator shows that your fuel does not meet the 20% GHG reduction threshold
specified in the CAA, RINs may not be generated for non-grandfathered volumes of fuel.
Are coproducts accounted for in the GHG Calculator?
In addition to producing ethanol, dry mill plants also produce distillers grains and solubles (DGS) as a
coproduct. Many plants also extract corn or sorghum oil as an additional coproduct. In the GHG
Calculator the GHG impacts of the DGS and oil coproducts are accounted for in the upstream GHG
emissions factors for corn and grain sorghum. This is because our analyses of the upstream emissions
attributable to corn and grain sorghum used for ethanol account for the agricultural sector impacts of
the DGS and corn oil coproducts. In our modeling, the DGS are considered a replacement animal feed
and thus reduce the demand for other sources of animal feed and the GHG emissions associated with
their production and use. Extracted oil is also accounted for in the vegetable oil and biodiesel markets.6
Who should I contact if I have more questions?
Please direct any further questions to the EPA Fuels Programs Support Line at support@epamts-
support.com. Your questions will be delegated to appropriate EPA staff (or EPA contractor) for
response.
4. Tab-by-Tab Instructions
This section includes on overview of the GHG Calculator spreadsheet, and instructions on how to use
each tab when preparing an EP petition or using the GHG Calculator to calculate the rolling average
lifecycle GHG emissions for ethanol produced through a previously approved EP pathway. It begins with
an explanation of the purpose of the GHG Calculator, followed by a brief introduction to each tab in the
spreadsheet.
6 For more information on our corn ethanol modeling see the March 2010 rule (75 FR 14670), and for more
information on our grain sorghum modeling see the December 2012 grain sorghum rule (77 FR 74592).
5

-------
Overview of the Tabs in the GHG Calculator
Table 2 lists the tabs in the GHG Calculator with a brief description. Tabs that are new for version 1.1
are shown in red text. The GHG Calculator includes three types of tabs: data entry tabs (green
background), calculation tabs (blue background), and information tabs (clear background).
Table 2: Overview of the Tabs in the GHG Calculator Spreadsheet
Tab Name
Description
Cover Sheet
Basic information regarding the fuel pathway.
Instructions
Basic instructions for using the spreadsheet
Contact Info
Enter contact information for petitioner's Responsible Corporate
Officer
Corn Use Data
Data entry for corn use in bushels.
Corn Moisture Data
Data entry for the moisture content of corn deliveries.
Sorghum Use Data
Data entry for grain sorghum use in bushels.
Sorghum Moisture Data
Data entry for the moisture content of grain sorghum deliveries.
Natural Gas Use Data
Data entry for natural gas use in standard cubic feet.
Biogas Use Data
Data entry for biogas use in standard cubic feet.
Electricity Use Data
Data entry for grid electricity use in kilowatt hours.
Coal Use Data
Data entry for coal use in tons.
Biomass Use Data
Data entry for biomass use dry pounds.
Ethanol Production Data
Data entry for ethanol production in standard gallons.
Confirm Data
Confirm that data is entered properly for each day.
Quick Check
Automatic check for missing information
Daily Data Summary
Summary of daily feedstock and energy use, and fuel production data.
Time Series Results
Time series of daily and rolling average lifecycle GHG results.
Results Summary
Updated 365-day rolling average lifecycle GHG results.
Corn Ethanol GHG Calcs
Daily and rolling average GHG calculations for corn ethanol.
Sorghum Ethanol GHG Calcs
Daily and rolling average GHG calculations for grain sorghum ethanol.
Emis Facs
Emission factors and unit conversions used in the GHG calculations.
Abbreviations
Descriptions of abbreviations used in the GHG Calculator
For-EPA-Use
The data collected in this tab helps the EPA review EP petitions.
This rest of this section includes instructions for each tab of the GHG Calculator.
Cover Sheet
The Cover Sheet asks for five categories of information to be entered in the green-shaded cells.
Facility information:
•	Company Name: Enter the name of the company that owns the fuel production facility.
•	Company ID: The company's four-digit identification number from CDX OTAQReg (if the
company does not yet have an ID number enter "N/A").
•	Facility Name: Enter a name for the fuel production facility (e.g., the company name followed by
the name of the city where the facility is located).
•	Facility ID: The facility's five-digit identification number from CDX OTAQReg (enter "N/A" if one
does not exist).
6

-------
•	Facility City: The city where the fuel production facility is located.
•	Facility State: The state where the fuel production facility is located.
Fuel Pathway Information:
•	Has the EPA has activated an Efficient Producer pathway(s) for your fuel?
Select "No" if you are preparing the GHG Calculator as part of an EP petition.
Select "Yes" if EPA has previously approved an EP pathway for your fuel, and the Agency has
accepted your registration for the fuel pathway.7
Some of the instructions below differ depending on your answer to this question. In these
cases, if you answered "Yes" follow the instructions below for that apply "For EP petitions" and
if you answered "No" follow the instructions that apply "For activated EP pathways."
•	New Pathway Requested: Use the drop-down menu to select the appropriate option from the
following:
o Renewable fuel (D-code 6) RINs for non-grandfathered corn ethanol.
o Advanced biofuel (D-code 5) RINs for grain sorghum ethanol.
o Both, D6 RINs for non-grandfathered corn ethanol and D5 RINs for grain sorghum
ethanol.
Most petitioners will select the first option. If you select one of the other options your petition
must demonstrate a 50% lifecycle GHG reduction for grain sorghum ethanol compared to the
gasoline baseline, or the EPA will send it back as incomplete.
If you have an activated EP pathway, the signed EP determination document issued by EPA for
your facility will specify the type of RIN (D-code) that ethanol produced through your EP
pathway is eligible to generate.
•	My facility's corn ethanol does not match any of the pathways in Table 1 to 40 CFR 80.1426
because the facility: Use the drop-down menu to select the appropriate option from the
following:
o dries more than 65% of the DGS it markets annually and does not use two of the
advanced technologies in Table 2 to 40 CFR 80.1426
o dries more than 50% of the DGS it markets annually and does not use any of the
advanced technologies in Table 2 to 40 CFR 80.1426
o N/A
7 Your EP pathway is considered to be activated after your registration for the pathway has been accepted by EPA
and you are able to access your EP pathway in EMTS. You should receive an email notification when your pathway
is activated.
7

-------
The list of advanced technologies in Table 2 to 40 CFR 80.1426 is available on EPA's web page.8
If you are requesting a pathway for non-grandfathered corn ethanol and none of these options
look appropriate there may be an existing pathway for your fuel. If your petition only requests a
pathway for grain sorghum ethanol select N/A.
•	My facility's sorghum ethanol does not match any of the advanced biofuel pathways in Table 1
to 40 CFR 80.1426 because the facility: Use the drop-down menu to select the appropriate
option from the following:
o does not use biogas from landfills, waste treatment plants, and/or waste digesters for all
process energy and for on-site production of all electricity used at the site
o uses more than 0.15 kWh of electricity from the grid per gallon of ethanol produced,
calculated on a per batch basis
o N/A
If your petition only requests a pathway for corn ethanol select N/A.
Averaging Time Period:
For EP petitions:
•	Earliest date that you are entering data for: In the following sheets, you will enter data on
feedstock use, energy use and fuel production. In this cell, enter the earliest date that you are
entering data for. For example, if you are entering data for the time period from April 1, 2014 to
March 31, 2015, you should enter "4/1/2014."
•	Latest date that you are entering data for:
o If you are entering daily data in the GHG Calculator, enter the latest date that you are
entering data for. For example, if you are entering daily data for the time period from
April 1, 2014 to March 31, 2015, you should enter "3/31/2015" in this field,
o If you are entering aggregate data in the GHG Calculator, enter the same date that you
entered under "Earliest date that you are entering data for." For example, if you are
entering aggregate data for the time period from April 1, 2014 to March 31, 2015, you
should enter "4/1/2014" in this field.9 If you are using this approach, you should explain
the time period for your aggregate data in the Notes field on the Cover Sheet (see
below).
o For details on choosing daily data or aggregate data, see the frequently asked question
in this document titled: Do I need to enter daily data in the GHG Calculator for an EP
petition?
For activated EP pathways:
•	Date EPA activated your EP pathwav(s): Enter the day that EPA activated your EP3 pathway.10
8	https://www.epa.gov/renewable-fuel-standard-program/approved-pathwavs-renewable-fuel
9	This is necessary because the GHG Calculator was originally designed for daily data entries.
10	The day your EP pathway was activated is the day that your registration for the pathway was accepted by EPA
and you were able to access your EP3 pathway in EMTS. You should have received an email notification when your
EP pathway was activated.
8

-------
• Today's date: Enter today's date.
Feedstock Checklist:
•	Does this facility use corn starch feedstock?
•	For EP petitions: Select "Yes" if your facility uses or intends to use a non-negligible
amount of corn starch to produce ethanol. Note, even if your petition is requesting a
pathway for ethanol made from grain sorghum, you must select "Yes" if your facility
uses corn starch.
•	For previously activated EP pathways: Enter "Yes" if EPA evaluated corn starch as a
feedstock for your facility's EP pathway. (The signed EP determination document issued
by EPA for your facility will specify whether EPA evaluated corn starch as a feedstock for
your facility's EP pathway.)
•	Does this facility use grain sorghum feedstock?
•	For petitioners: Select "Yes" if your facility uses or intends to use grain sorghum
feedstock to produce ethanol. Note, even if your petition is requesting a pathway for
ethanol made from corn starch, you must select "Yes" if your facility uses grain
sorghum.
•	For previously activated EP pathways: Enter "Yes" if EPA evaluated grain sorghum as a
feedstock for your facility's EP pathway. (The signed EP determination document issued
by EPA for your facility will specify whether EPA evaluated grain sorghum as a feedstock
for your facility's EP pathway.)
•	Does this facility use any other feedstocks? Select "Yes" or "No" from the drop-down options. If
you select "Yes" an error message will appear in the next row of the spreadsheet. This is
because the EP3 currently only allows for the use of corn starch and/or grain sorghum
feedstocks.11
Other Information:
•	Baseline volume per 40 CFR 80.14003: Enter the "grandfathered" baseline volume for your
facility in gallons. If your facility does not qualify as a grandfathered facility (e.g., if it was not in
operation or had not commenced construction prior to December 19, 2007) leave this field
blank. This information is for EPA's reference only, it does not impact the GHG Calculator
results.12
•	Notes: Use this field to enter important notes about the data entered in the GHG Calculator. For
example, if data are not provided on a daily basis, use this field to explain how the data are
reported (for details see: Do I need to enter daily data in the GHG Calculator for an EP petition?).
Contact Info
Use this tab to enter information about the responsible corporate officer (RCO) and the point of contact
(POC) for the petitioning facility. The signed determination document responding to your petition will
be addressed and mailed to the RCO using the information provided in this tab. Questions during the
11	Parties who use other feedstocks and seek a new fuel pathway, may submit a standard petition pursuant to 40
CFR 80.1416. For information on how to submit a standard petition see: https://www.epa.gov/renewable-fuel-
standard-program/how-submit-complete-petition-approved-pathwav-under-renewable-fuel
12	For more information on what is meant by "grandfathered" fuel see: https://www.epa.gov/renewable-fuel-
standard-program/program-overview-renewable-fuel-standard-program
9

-------
petition review process will be sent to the POC. (The POC and RCO may be the same person.) The entry
fields on this tab (e.g., name, address, city) should be self-explanatory. Please spell out job titles, street
names, etc., and refrain from using unnecessary abbreviations. If you have questions about how to
enter data on this tab please send them to the Fuels Programs Support Line.13
Corn Use Data
On this tab enter your facility's corn use, in bushels, in the green-shaded cells. Two data entry methods
are available (use only one):
•	Inventory approach: Enter the starting inventory, shipments received and ending inventories.
All units are entered in bushels.
•	Direct measurement approach: Enter the amount used each day (or for a multi-day period if
entering aggregate data, see Section 4(A) of this document for details)
The GHG Calculator is designed for users to choose one data entry method (inventory or direct
measurement) and use that method for all data entry in the sheet. The tool does not support using both
methods on a single day, or switching between methods for different entry dates.
For each entry method there is an optional notes column to provide additional information about how
the data were collected.
Corn Moisture Data
Enter all of the corn deliveries to your facility including the moisture content, in mass percent, of each
and every delivery. This information is used to calculate the standardized bushels of corn at 15.5%
moisture.
The dates in column A are entered manually. If your facility receives more than one shipment on a given
day, you can use multiple rows to record shipments for that day. If your facility does not receive corn
shipments for a given day you can skip to the next day. Examples of this are illustrated below in Figure
3. Optional columns are provided to record additional information about each delivery, including time,
number, type and other notes.
Figure 3: Example data entry in the Corn Moisture Data tab
Day
[...]
Amount of Corn in Delivery
Moisture Content
DD/MM/YYYY
[...]
Bu
Mass %
4/1/2014
[...]
100
15.5%
4/1/2014
[...]
200
14%
4/5/2014
[...]
100
15.5%
For the calculator to work properly, a delivery amount greater than zero and a moisture content must
be entered for the date listed in cell A4 (i.e., the earliest date that you are entering data for). If there
were no corn deliveries on the date listed in cell A4 then enter the previous day inventory and the
average moisture content for the corn in inventory.
13 https://www.epa.gov/renewable-fuel-standard-program/forms/contact-us-about-renewable-fuel-standard-
program
10

-------
Sorghum Use Data
On this tab enter your facility's grain sorghum use, in bushels. Two data entry methods are available:
inventory approach or direct measurement approach (for explanation see the instructions for the Corn
Use Data tab, above). The GHG Calculator is designed for users to choose one data entry method
(inventory or direct measurement) and use that method for all data entry in the sheet. The tool does not
support using both methods on a single day, or switching between methods for different entry dates.
For each entry method there is an optional notes column to provide additional information about how
the data were collected.
Sorghum Moisture Data
On this tab enter all of the grain sorghum deliveries to your facility including the moisture content, in
mass percent, of each and every delivery. This information is used to calculate the standardized bushels
of grain sorghum at 13% moisture. (See the data entry example given above for the Corn Moisture Data
tab.)
For the calculator to work properly, a delivery amount greater than zero and a moisture content must
be entered for the date listed in cell A4 (i.e., the earliest date that you are entering data for). If there
were no sorghum deliveries on the date listed in cell A4 then enter the previous day inventory and the
average moisture content for the sorghum in inventory.
Natural Gas Use Data
On this tab enter your facility's natural gas use in standard cubic feet.
Space is provided for you to record data from as many meters as necessary. For example, to add data
from an additional meter, copy columns H-J and paste them into columns L-N. Relabel the meter
number, or give it a new name. Repeat these steps as many times as needed moving from left to right in
the spreadsheet. Finally, revise the formula in column B so that it sums the "Daily Amount Used" from
all of the meters you have added (make sure to use the fill down in Excel so the formula is accurate for
all of the applicable rows).
Biogas Use Data
On this tab enter your facility's biogas use in standard cubic feet. You must specify the methane
content, in volume percent, for the biogas your facility uses. If methane is measured directly, then enter
100% in the percent methane column for each meter.
Space is provided for you to record data from as many meters as necessary. For example, to add data
from an additional meter, copy columns J-N and paste them into columns P-T. Relabel the meter
number, or give it a new name. Repeat these steps as many times as needed moving from left to right in
the spreadsheet. Finally, revise the formula in column B so that it sums the "Daily Amount CH4 Used"
from all of the meters you have added (make sure to "fill down" the formula so that it is accurate for all
of the applicable rows).
Electricity Use Data
On this tab enter your facility's use of grid electricity in kilowatt hours. Space is provided for you to
record data from as many meters as necessary (See the instructions for the Natural Gas Use Data for
details on how to add meters).
11

-------
Coal Use Data
On this tab enter your facility's coal use in tons. Two data entry methods are available: inventory
approach or direct measurement approach (for explanation see the instructions for the Corn Use Data
tab, above). The GHG Calculator is designed for users to choose one data entry method (inventory or
direct measurement) and use that method for all data entry in the sheet. The tool does not support
using both methods on a single day, or switching between methods for different entry dates.
Biomass Use Data
On this tab enter the amount of biomass used by your facility as process heat fuel in dry pounds. Two
data entry methods are available: inventory approach or direct measurement approach (for explanation
see the instructions for the Corn Use Data tab, above). For both data entry methods, you must enter
the mass and average moisture content (weight percent) of the biomass used by your facility.
The GHG Calculator is designed for users to choose one data entry method (inventory or direct
measurement) and use that method for all data entry in the sheet. The tool does not support using both
methods on a single day, or switching between methods for different entry dates.
At this time to qualify for the EP3, all biomass used for process heat fuel must meet the RFS regulatory
definition for crop residue at 40 CFR 80.1401.14 See the July 2014 RFS rule (79 FR 42128) for more
information on what EPA considers to be a crop residue for the RFS program.15
Ethanol Production Data
On this tab enter the amount of all ethanol produced at your facility. Two data entry methods are
provided:
•	Direct Measurement Approach: Enter the standardized volume of undenatured (200 proof)
ethanol produced at your facility, in gallons adjusted to 60° F.
•	Actual Temperature and Volume Approach: Enter the actual volume of undenatured ethanol
produced at your facility, in gallons, and the average temperature of the ethanol in degrees
Fahrenheit (volume and temperature should be measured at the same time).
The GHG Calculator allows users to switch between measurement approaches, and/or use both
approaches for the same day.
Confirm Data
After reviewing the data entered in the tabs listed above select from the following two options for each
day that you entered data for:
14	Per 40 CFR 80.1401: Crop residue means biomass left over from the harvesting or processing of planted crops
from existing agricultural land and any biomass removed from existing agricultural land that facilitates crop
management (including biomass removed from such lands in relation to invasive species control or fire
management), whether or not the biomass includes any portion of a crop or crop plant. Biomass is considered crop
residue only if the use of that biomass for the production of renewable fuel has no significant impact on demand
for the feedstock crop, products produced from that feedstock crop, and all substitutes for the crop and its
products, nor any other impact that would result in a significant increase in direct or indirect GHG emissions.
15	Examples of materials that EPA considers crop residue are: sugarcane and sweet sorghum bagasse; kernel fiber
from barley, corn, oats, rice, rye, grain sorghum and wheat; and stover from corn and grain sorghum; straw from
barley, oats, rice, rye, soybeans and wheat.
12

-------
1.	CONFIRMED: For this date valid data were properly collected through continuous monitoring
and accurately recorded in this spreadsheet.
2.	MISSING DATA: On this date one or more of the required data inputs were not properly
collected or reported.
When submitting a GHG Calculator as part of a petition, you should select option one (confirmed) for all
of the dates that you entered data for. If you choose MISSING DATA for any of the dates that you
entered data for your petition will be returned as incomplete.
If you choose MISSING DATA or leave this cell blank for any of the dates, the GHG Calculator will
evaluate all of the ethanol produced on that date as having lifecycle greenhouse gas emissions of 98.2
kgC02e/mmBtu, the lifecycle GHG emissions for the gasoline baseline.16
Quick Check
Provides a quick check of whether you are missing required information.
For EP petitions, if this tab identifies any missing information (marked as "ERRORS") your petition will be
returned as incomplete.
This tab is meant as a tool to help users do a quick check for missing information. It is not meant as full
check of the completeness or accuracy of the information entered in the GHG Calculator. Even if this
tab does not identify missing or erroneous information, EPA may still return your petition as incomplete
if we find missing or incorrect data. It is the petitioner's responsibility to ensure that the data provided
are complete and accurate. Similarly, for producers with an activated EP pathway, it is the fuel
producer's responsibility to ensure that the data provided are complete and accurate.
Daily Data Summary
This tab provides a summary of the data entered in the preceding data entry tabs. We recommend
reviewing the information on this tab as a way to help identify and prevent errors.
Time Series Results
This tab provides a time series look at your fuel's lifecycle GHG emissions based on the data you
entered. Daily and rolling average results are provided for corn and grain sorghum ethanol. The 365-
day rolling average GHG results are based on the average lifecycle GHGs for the fuel produced over the
preceding 365 days. Results are provided for corn ethanol and grain sorghum ethanol in terms of
kgC02e/mmBtu. The tab also shows on which days the corn ethanol produced at your facility meets the
20% GHG reduction threshold and the days when the grain sorghum ethanol meets the 50% GHG
reduction threshold. The percent GHG reductions compared to the gasoline baseline are also displayed
here.
Results Summary
After all of the data is properly entered in the data entry tabs, this tab provides a summary of the 365-
day rolling average lifecycle GHG emissions during the specified averaging time period for the corn
and/or grain sorghum ethanol produced at your facility.
16 Details on what constitutes valid versus missing data should be provided in the EP determination document for
your facility and the Compliance Monitoring Plan included as part of your registration for the EP3 pathway.
13

-------
For an EP petition, the results on this tab should show that your fuel meets the applicable GHG
reduction threshold (20% reduction for renewable fuel or 50% reduction for advanced biofuel). If you
submit a GHG Calculator that does not demonstrate adequate GHG reductions, EPA will return the
petition as incomplete.
Corn Ethanol GHG Calcs
This tab is used to calculate the daily and 365-day rolling average lifecycle GHG emissions for corn
ethanol based on the data entered in the preceding tabs. This tab is protected from editing.
Grain Sorghum Ethanol GHG Calcs
This tab is used to calculate the daily and 365-day rolling average lifecycle GHG emissions for grain
sorghum ethanol based on the data entered in the preceding tabs. This tab is protected from editing.
Emis Facs
This information tab includes the GHG emissions factors used by the GHG Calculator. These values are
for reference and protected from editing.
Abbreviations
This tab includes a list of abbreviations used on other tabs. It also stores list data used on other tabs,
and is protected from editing.
For-EPA-Use
The EPA uses this tab to expedite review of GHG Calculators that are submitted as part of EP3 petitions.
It is protected from editing.
14

-------
Appendix 1: Abbreviations and Acronyms
Abbreviation or Acronym
Description
Btu
British Thermal Units
bu
Bushel
CAA
Clean Air Act
CFR
Code of Federal Regulations
ch4
Methane
DGS
Distillers grains and solubles
EISA
Energy Independence and Security Act
EP
Efficient Producer
EP3
Efficient Producer petition process
EPA
Environmental Protection Agency
F
Fahrenheit
FR
Federal Register
gal
Gallon
GHG
Greenhouse gas
Hr
Hour
kgC02e
Kilograms of carbon dioxide-equivalent emissions
kWh
Kilowatt hour
lb
Pound
LCA
Life cycle assessment
LHV
Lower heating value
mmBtu
Million British Thermal Units
RFS
Renewable Fuel Standard
RIN
Renewable Identification Number
scf
Standard cubic feet
std. gal
Standardized gallon of ethanol at 60° F
15

-------
Appendix 2: Lifecycle GHG Equations
The GHG Calculator uses the following equations to calculate the lifecycle GHG emissions for corn and
grain sorghum ethanol.
Corn Ethanol
The 365-day rolling average lifecycle GHG emissions are calculated using the following formula:
LCghgc = GHGuc + GHGpc + GHGd
Where:
LCghgc = Lifecycle GHG emissions, in kgC02e/mmBtu, of the volume of all corn ethanol produced at the
facility during the averaging time period.
GHG uc — Upstream GHG emissions, in kgC02e/mmBtu, related to the production and transport of the
volume of corn starch feedstock used to produce all corn ethanol produced at the facility during the
averaging time period, calculated per the formula below.
GHG pc - Process GHG emissions, in kgC02e/mmBtu, related to the processes used for conversion of corn
into ethanol during the averaging period, including energy used for feedstock, fuel and co-product
operations, as calculated per the formula below.
GHGd = Downstream GHG emissions, in kgC02e/mmBtu, related to the distribution and use of all corn
ethanol produced during the averaging period, calculated per the formula below.
GHGuc is calculated according to the following formula:
9.73 * Bc
CM C —
Uc (Vs * 0.076 * Rc)
Where:
9.73 = Upstream emissions factor for corn, in kgC02e per bushel, based on the lifecycle GHG modeling
done by EPA for the March 2010 RFS rule.
Bc = Bushels of corn used as feedstock to produce ethanol during the averaging time period in terms of a
standard bushel at 15.5% moisture. Bc is be calculated according to the following formula:
d - 0.155,
Where:
BCm = Bushels of corn used to produce ethanol during the averaging time period.
mc = Average moisture content of corn, in mass percent, for the corn delivered for use as
feedstock to produce ethanol during the averaging time period.
0.155 = Moisture content of a standard bushel of corn at 56 pounds per bushel.
Vs = Standardized volume of all ethanol produced at the facility during the averaging time period
(including both corn starch and grain sorghum ethanol), in gallons of undenatured ethanol. In
16

-------
determining the standardized volume, the actual volumes of ethanol shall be adjusted to a standard
temperature of 60 degrees Fahrenheit using the following formula:
Vc= VA*\ 1 - 0.00114*
5"
{T + 459.67}*-
5"
{60 + 459.67}*-
Where:
VA = Actual volume of undenatured ethanol, in gallons.
T = Actual temperature of ethanol, in degrees Fahrenheit, measured at the same time that VA is
measured.
0.00114 = Coefficient to standardize volumes of undenatured ethanol.
60 = Standard temperature, in degrees Fahrenheit, for volumes of ethanol.
459.67 and 5/9 = Conversion factors for Fahrenheit to Kelvin
0.076 = Energy content of ethanol, in mmBtu/gallon (lower heating value).
Rr = (V—t:—\ which is the ratio of corn feedstock used, on a mass basis.
c Vbc+bgs;'
Where:
Bgs = Bushels of grain sorghum used as feedstock to produce ethanol during the averaging time
period in terms of a standard bushel at 13% moisture. BGs is be calculated according to the
following formula:
/1 - mas
Brc = Brs * 	—
c	 0 13
BGSm = Measured bushels of grain sorghum used as feedstock to produce ethanol during the
averaging time period.
mgs = Average moisture content of grain sorghum, in mass percent, for the grain sorghum
delivered for use as feedstock to produce ethanol during the averaging time period.
0.13 = Moisture content of a standard bushel of grain sorghum at 56 pounds per bushel.
GHGpc is calculated according to the following formula:
GHG therm i GHGelec
niin _ 0.963 * Rgs + Rc 0.993 * RGS + Rc
GHGpc -	. 0.076
Where:
GHGjherm = GHG emissions, in kgC02e, associated with producing and using thermal energy used for
feedstock, fuel and co-product operations during the averaging period. GHGjherm is calculated according
to the following formula:
17

-------
3
GHGtherm =
PEp * LHVpEp * EFPEiP) + BIO* EFbi0
p=1
Where:
p = Type of fuel used.
PEp = a measure of the amount of fuel p used as energy used for feedstock, fuel and co-product
operations, as follows:
PEi = Standard cubic feet (scf) of natural gas used in feedstock, fuel and co-product
operations.
PE2 = Standard cubic feet (scf) of biogas CH4 from landfills, waste treatment plants and/or
waste digesters used as energy used for feedstock, fuel and co-product operations.
PE3 = Tons of coal, used as energy used for feedstock, fuel and co-product operations.
LHVpe,p = Lower Heating Value factor for fuel type p, as follows:
LHVpe,i = 983 Btu per scf of natural gas.
LHVpe,2 = 983 Btu per scf of biogas CH4.
LHVpe,3 = 19,546,300 Btu per ton of coal.
EFpe,p = Lifecycle GHG emissions factor for fuel type p, (based on lower heating value) as follows:
EFpe,i = 6.86 * 10"5 kgC02e per Btu of natural gas.
EFpe,2 = 3.64 * 10"7 kgC02e per Btu of biogas CH4.
EFpe,3 = 1.12 * 10"4 kgC02e per Btu of coal.
BIO = Dry pounds (0% moisture) of biomass used as energy used for feedstock, fuel and co-
product operations.
EFbio = 5.40*10"3 kgC02e per dry lbs of crop residue biomass.
Rgs = fD BGd—\ which is the ratio of grain sorghum feedstock used, on a mass basis.
VBc+Bgs/
GHG elec - GHG emissions, in kgC02e, associated with producing and using electrical energy for
feedstock, fuel and co-product operations during the averaging period. GHGelec is calculated according
to the following formula:
GHGelec = ELEC * EFeiec
Where:
ELEC = kWh of Grid electricity used as energy used for feedstock, fuel and co-product
operations.
EFeiec = 0.750 kgC02e per kWh of grid electricity, based on the United States grid average.
18

-------
0.963 = Adjustment factor for grain sorghum processing using 3.7% less thermal energy than corn
ethanol processing.
0.993 = Adjustment factor for grain sorghum processing using 0.7% less electrical energy than corn
ethanol processing.
GHGd is calculated to be 2.1 kgCCbe per mmBtu of ethanol.
Days with missing data
For all corn ethanol produced by the facility during a day where there is missing data on any of the
factors described above, the corn ethanol produced on all such days is assessed as having lifecycle GHG
emissions of 98.2 kgC02e per mmBtu. In the spreadsheet, this is done by adjusting GHGD so that the
lifecycle GHG emissions for those days equals 98.2 kgC02e per mmBtu.
Grain Sorghum Ethanol
The 365-day rolling average lifecycle GHG emissions are calculated using the following formula:
LCghggs = GHGugs + GHG PGS + GHGd
Where the terms in the equation are the similar to the terms specified above for corn ethanol lifecycle
GHG emissions, but with references to corn replaced with grain sorghum.
GHGugs is calculated according to the following formula:
8.93 * Bqs
CMC =
Ugs (Ks * 0.076* Rqs)
Where:
8.93 = Upstream emissions factor for grain sorghum, in kgC02e per bushel, based on the lifecycle GHG
modeling done by EPA for the December 2012 grain sorghum rule.
GHGpgs is calculated according to the following formula:
	THERM	* 0 963 H	GHGELEc	 q gqo
rrrr _ 0.963 *RCS + RC	+ 0.993 * Rcs + Rc
GH(JPSS ~	Vs * 0.076
Days with missing data
Days with missing data for grain sorghum ethanol are treated the same as days with missing data for
corn ethanol (see above).
19

-------