January 29, 2010

MEMORANDUM

TO: 			Air Docket EPA-HQ-OAR-2005-0161

SUBJECT:	GREET Model Spreadsheets Used in the Lifecycle Analysis

This memorandum accompanies four spreadsheets placed on the docket of
Version 1.8c.0 of the GREET model as used in the lifecycle analysis for
the final rulemaking. The spreadsheets were used to estimate greenhouse
gas emissions associated with the transport of sugarcane feedstock, the
transportation and distribution of domestic and imported ethanol,
production of agricultural inputs (fertilizers and chemicals), and
electricity production.  Results were input into separate impact
calculation spreadsheets that are also available on the docket.    

Below is a summary of modifications that were made in each spreadsheet
from default values in GREET.  For more information about these
assumptions and the use of the GREET model to calculate lifecycle
greenhouse gas emissions for the final rulemaking refer to RIA Chapter
2.

GREET1_8c_0_electric.xls

No changes made to domestic, Brazil based on marginal mix as described
in the RIA

GREET1_8c_0_ethanol_transport.xls

T&D GQ109 = 0

GREET1_8c_0_Fertilizer.xls

No changes, results just summarized for average production emissions

GREET1_8c_0_sugarcane_transport.xls

T&D AE7 = 42

T&D B41–B42 = 3.8

T&D_Flowcharts F1377 = 19

