{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Introduction","Site-Specific Inputs","Calculated Parameters","Pathway Summary","OR-GREET4.0","EF Tables","EF General","Old Fuel_Specs"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":6,"defined_names":236,"comments":4,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":44,"n_cols":6,"rows_kept":44,"cut":false,"hidden":false,"merged":[[2,2,2,6],[3,2,3,6]]}
[]
[null,null,null,null,null,{"$error":"#VALUE!"}]
[null,null,"Low Carbon Fuel Standard\nTier 1 CI Calculator for Sugarcane Ethanol (Release Date: 08/12/2024)"]
[null,null,"The Tier 1 Calculator for Sugarcane Ethanol (T1 Sugarcane Calculator) offers a simplified interface for calculating the carbon intensity of sugarcane-derived ethanol produced from sugarcane juice or molasses feedstocks. \n\nTo begin, navigate to the \"Site-Specific Inputs\" worksheet and enter all relevant project data. For Tier 1 pathways, a minimum of 3 months of operational data is required. Inputs entered by the applicant are limited to all yellow cells (see Color Key below). Inputs that do not apply to the fuel pathway may be left blank. Cells containing calculated or predefined input values may not be modified without DEQ approval via a Tier 2 pathway. \n\nCarbon Intensity (CI) results are provided on the \"Pathway Summary\" worksheet, along with calculated input results and finished fuel quantities. Pathway-specific Operating Conditions that may be added by DEQ prior to pathway certification.\n\nThe \"Predefined Inputs\" worksheet contains input values, emission factors, and unit conversion tables from the Argonne National Labs GREET 2022 model, with additional modeling inputs from EPA eGRID,  CARB EMFAC,  Purdue University GTAP, Stanford OPGEE, and the CFP pathway database.\n\nThe \"Calculated Parameters\" contains additional calculations to determine the upstream impacts (Mass Allocation Ratio) of Sugarcane Farming and Transport on the production of sugarcane molasses (a by-product of the Table Sugar production process) used for ethanol production.  This model also permits the applicant to model the theoretical output of finished table sugar and ethanol produced, and compare it to the reported output of table sugar and ethanol produced.                                                                                                                                                                                                                                                                                                                                                                                                                                                           \n\nAdditional Notes: In order for macros to function properly, the \"Enable Content\" button in Microsoft Excel must be selected upon opening this calculator. In order to ensure that CI calculations reflect the most recent inputs, select \"Automatic\" calculations from the \"Calculation Options\" in the \"Formulas\" toolbar or press F9 (if using Microsoft Excel)."]
[null,null,null,"Color Key",null,"CFP Website Resources"]
[null,null,null,"User Input",null,"CFP Program Overview"]
[null,null,null,"Calculated Value",null,"Tier 1 Pathway Calculators and Instruction Manuals"]
[null,null,null,"OR-GREET4.0 Input",null,"Tier 1 Pathway Application Process"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"`"]

{"sheet":"Site-Specific Inputs","index":1,"n_rows":57,"n_cols":56,"rows_kept":57,"cut":false,"hidden":false,"merged":[[38,5,38,6],[39,5,39,6],[2,15,2,16],[1,1,1,2],[8,1,8,2],[1,4,1,26],[2,17,2,18],[5,9,6,9],[5,10,6,10],[5,11,6,11],[5,12,6,12],[5,13,6,13],[5,14,6,14],[5,15,6,15],[5,16,6,16],[5,17,6,17],[2,28,2,31],[2,19,2,26],[2,5,2,10],[24,1,24,2],[2,13,2,14],[2,11,2,12],[10,1,11,1],[12,1,13,1],[15,1,16,1],[17,1,19,1],[5,5,6,5],[5,4,6,4],[5,6,6,6],[5,7,6,7],[5,8,6,8],[5,23,6,23],[5,24,6,24],[5,25,6,25],[5,26,6,26],[5,18,6,18],[5,19,6,19],[5,20,6,20],[5,21,6,21],[5,22,6,22]]}
[]
[null,"Section 1: Applicant Information",null,null,"Section 4: Monthly Operational Data"]
[null,"1.1 Application Number",null,null,null,"Feedstock Parameters",null,null,null,null,null,"Externally-Sourced Feedstock",null,"Externally-Sourced Biomass",null,"Process Energy",null,"Process Parameters",null,"Fuel and Co-Product Production",null,null,null,null,null,null,null,null,"Section 1: Pathway Inputs Selection"]
[null,"1.2 Company Name",null,null,null,"Feedstock Procured","Feedstock Transport","Feedstock Procured","Feedstock Transport","Total Feedstock","Feedstock Transport","External Molasses","Ethanol Produced","External Biomass*","Electricity Cogenerated","Electricity Procured","Electricity Exported"]
[null,"1.3 Company ID",null,null,4.0999999999999996,4.2,4.3,4.4000000000000004,4.5,4.5999999999999996,4.7,4.8,4.9000000000000004,4.0999999999999996,4.1100000000000003,4.12,4.13,4.1399999999999997,4.1500000000000004,4.16,4.17,4.18,4.1900000000000004,4.2,4.21,4.22,4.2300000000000004]
[null,"1.4 Fuel Production Facility Address",null,null,"Reporting Month ","Applicant-Owned Farms (Propria Farms)","Transport Distance from Applicant-Owned Farms (weighted average)","Partnership Farms (Terceiros Farms)","Transport Distance from Partnership Farms (weighted average)","Total Sugarcane Procured (Calculated)","Filter Cake Transport & Distribution Distance (Calculated)","Externally-Sourced Molasses","Ethanol Produced from Externally-Sourced Molasses**","Externally-Sourced Biomass (bagasse equivalents)","Electricity Generated from Externally-Sourced Biomass**","Electricity Purchased from the Public Grid","Surplus Cogenerated Electricity Exported","Juice Share for Sugar Production (weighted average)","Fraction Sucrose Content of Juice (weighted average)","Anhydrous Ethanol Produced","Moisture Content (Anhydrous Ethanol)","Adjusted Anhydrous Ethanol Produced","Hydrous Ethanol Produced","Moisture Content (Hydrous Ethanol)","Adjusted Hydrous Ethanol Produced","Finished or Table Sugar Produced","Total Ethanol Produced"]
[null,"1.5 Facility ID"]
[null,null,null,null,"Month/YYYY","metric tons (tonnes)","km","metric tons (tonnes)","km","metric tons (tonnes)","km","metric tons (tonnes)","m3","metric tons (tonnes)","kWh","kWh","kWh","%","\"0.000\"","m3 (Reported at 20 C/68 F)","%","wet m3","m3 (Reported at 20 C/68 F)","%","wet m3","metric tons (tonnes)","m3, dry basis"]
[null,"Section 2: Pathway Inputs",null,null,null,null,null,null,null,{"$f":"IFERROR(IF((F9+H9)>0,(F9+H9),\"0\"),\"\")","v":"0"},{"$f":"IFERROR(((F9*G9+H9*I9)/J9)+2/AQ$56,\"0\")","v":"0"},null,null,null,{"$f":"IF((N9*('OR-GREET4.0'!E$44-'Calculated Parameters'!$D$156)*'OR-GREET4.0'!E$46*'OR-GREET4.0'!E$47*'OR-GREET4.0'!E$48/kWh2Btu)>0,(N9*('OR-GREET4.0'!E$44-'Calculated Parameters'!$D$156)*'OR-GREET4.0'!E$46*'OR-GREET4.0'!E$47*'OR-GREET4.0'!E$48/kWh2Btu),0)","v":0},null,null,null,null,null,null,{"$f":"IFERROR(IF((T9-M9*$W$34)>0,(T9-M9*$W$34),0),\"0\")","v":"0"},null,null,{"$f":"IFERROR(IF((W9-M9*$Z$34)>0,(W9-M9*$Z$34),0),\"0\")","v":"0"},null,{"$f":"IFERROR(V9*(1-U9)+Y9*(1-X9),\"0\")","v":0}]
[null,"2.1 Pathway CIs","Composite",null,null,null,null,null,null,"0","0",null,null,null,{"$f":"IF((N10*('OR-GREET4.0'!E$44-'Calculated Parameters'!$D$156)*'OR-GREET4.0'!E$46*'OR-GREET4.0'!E$47*'OR-GREET4.0'!E$48/kWh2Btu)>0,(N10*('OR-GREET4.0'!E$44-'Calculated Parameters'!$D$156)*'OR-GREET4.0'!E$46*'OR-GREET4.0'!E$47*'OR-GREET4.0'!E$48/kWh2Btu),0)","v":0},null,null,null,null,null,null,"0",null,null,"0",null,{"$f":"IFERROR(V10*(1-U10)+Y10*(1-X10),\"0\")","v":0}]
[null,"2.2 Feedstocks",null,null,null,null,null,null,null,"0","0",null,null,null,{"$f":"IF((N11*('OR-GREET4.0'!E$44-'Calculated Parameters'!$D$156)*'OR-GREET4.0'!E$46*'OR-GREET4.0'!E$47*'OR-GREET4.0'!E$48/kWh2Btu)>0,(N11*('OR-GREET4.0'!E$44-'Calculated Parameters'!$D$156)*'OR-GREET4.0'!E$46*'OR-GREET4.0'!E$47*'OR-GREET4.0'!E$48/kWh2Btu),0)","v":0},null,null,null,null,null,null,"0",null,null,"0",null,{"$f":"IFERROR(V11*(1-U11)+Y11*(1-X11),\"0\")","v":0}]
[null,null,null,null,null,null,null,null,null,"0","0",null,null,null,{"$f":"IF((N12*('OR-GREET4.0'!E$44-'Calculated Parameters'!$D$156)*'OR-GREET4.0'!E$46*'OR-GREET4.0'!E$47*'OR-GREET4.0'!E$48/kWh2Btu)>0,(N12*('OR-GREET4.0'!E$44-'Calculated Parameters'!$D$156)*'OR-GREET4.0'!E$46*'OR-GREET4.0'!E$47*'OR-GREET4.0'!E$48/kWh2Btu),0)","v":0},null,null,null,null,null,null,"0",null,null,"0",null,0]
[null,"2.3 Process Energy",null,null,null,null,null,null,null,"0","0",null,null,null,{"$f":"IF((N13*('OR-GREET4.0'!E$44-'Calculated Parameters'!$D$156)*'OR-GREET4.0'!E$46*'OR-GREET4.0'!E$47*'OR-GREET4.0'!E$48/kWh2Btu)>0,(N13*('OR-GREET4.0'!E$44-'Calculated Parameters'!$D$156)*'OR-GREET4.0'!E$46*'OR-GREET4.0'!E$47*'OR-GREET4.0'!E$48/kWh2Btu),0)","v":0},null,null,null,null,null,null,"0",null,null,"0",null,0]
[null,null,null,null,null,null,null,null,null,"0","0",null,null,null,{"$f":"IF((N14*('OR-GREET4.0'!E$44-'Calculated Parameters'!$D$156)*'OR-GREET4.0'!E$46*'OR-GREET4.0'!E$47*'OR-GREET4.0'!E$48/kWh2Btu)>0,(N14*('OR-GREET4.0'!E$44-'Calculated Parameters'!$D$156)*'OR-GREET4.0'!E$46*'OR-GREET4.0'!E$47*'OR-GREET4.0'!E$48/kWh2Btu),0)","v":0},null,null,null,null,null,null,"0",null,null,"0",null,0]
[null,"2.4 Coproduct",null,null,null,null,null,null,null,"0","0",null,null,null,{"$f":"IF((N15*('OR-GREET4.0'!E$44-'Calculated Parameters'!$D$156)*'OR-GREET4.0'!E$46*'OR-GREET4.0'!E$47*'OR-GREET4.0'!E$48/kWh2Btu)>0,(N15*('OR-GREET4.0'!E$44-'Calculated Parameters'!$D$156)*'OR-GREET4.0'!E$46*'OR-GREET4.0'!E$47*'OR-GREET4.0'!E$48/kWh2Btu),0)","v":0},null,null,null,null,null,null,"0",null,null,"0",null,{"$f":"IFERROR(V15*(1-U15)+Y15*(1-X15),\"0\")","v":0}]
[null,"2.5 Finished Products",null,null,null,null,null,null,null,"0","0",null,null,null,{"$f":"IF((N16*('OR-GREET4.0'!E$44-'Calculated Parameters'!$D$156)*'OR-GREET4.0'!E$46*'OR-GREET4.0'!E$47*'OR-GREET4.0'!E$48/kWh2Btu)>0,(N16*('OR-GREET4.0'!E$44-'Calculated Parameters'!$D$156)*'OR-GREET4.0'!E$46*'OR-GREET4.0'!E$47*'OR-GREET4.0'!E$48/kWh2Btu),0)","v":0},null,null,null,null,null,null,"0",null,null,"0",null,0]
[null,null,null,null,null,null,null,null,null,"0","0",null,null,null,{"$f":"IF((N17*('OR-GREET4.0'!E$44-'Calculated Parameters'!$D$156)*'OR-GREET4.0'!E$46*'OR-GREET4.0'!E$47*'OR-GREET4.0'!E$48/kWh2Btu)>0,(N17*('OR-GREET4.0'!E$44-'Calculated Parameters'!$D$156)*'OR-GREET4.0'!E$46*'OR-GREET4.0'!E$47*'OR-GREET4.0'!E$48/kWh2Btu),0)","v":0},null,null,null,null,null,null,"0",null,null,"0",null,0]
[null," 2.6 Fuel Transport & Distribution",null,null,null,null,null,null,null,"0","0",null,null,null,{"$f":"IF((N18*('OR-GREET4.0'!E$44-'Calculated Parameters'!$D$156)*'OR-GREET4.0'!E$46*'OR-GREET4.0'!E$47*'OR-GREET4.0'!E$48/kWh2Btu)>0,(N18*('OR-GREET4.0'!E$44-'Calculated Parameters'!$D$156)*'OR-GREET4.0'!E$46*'OR-GREET4.0'!E$47*'OR-GREET4.0'!E$48/kWh2Btu),0)","v":0},null,null,null,null,null,null,"0",null,null,"0",null,0]
[null,null,null,null,null,null,null,null,null,"0","0",null,null,null,{"$f":"IF((N19*('OR-GREET4.0'!E$44-'Calculated Parameters'!$D$156)*'OR-GREET4.0'!E$46*'OR-GREET4.0'!E$47*'OR-GREET4.0'!E$48/kWh2Btu)>0,(N19*('OR-GREET4.0'!E$44-'Calculated Parameters'!$D$156)*'OR-GREET4.0'!E$46*'OR-GREET4.0'!E$47*'OR-GREET4.0'!E$48/kWh2Btu),0)","v":0},null,null,null,null,null,null,"0",null,null,"0",null,0]
[null,null,null,null,null,null,null,null,null,"0","0",null,null,null,{"$f":"IF((N20*('OR-GREET4.0'!E$44-'Calculated Parameters'!$D$156)*'OR-GREET4.0'!E$46*'OR-GREET4.0'!E$47*'OR-GREET4.0'!E$48/kWh2Btu)>0,(N20*('OR-GREET4.0'!E$44-'Calculated Parameters'!$D$156)*'OR-GREET4.0'!E$46*'OR-GREET4.0'!E$47*'OR-GREET4.0'!E$48/kWh2Btu),0)","v":0},null,null,null,null,null,null,"0",null,null,"0",null,0]
[null," 2.7 Port of Ethanol Export","Port of Santos (Sao Paulo)",null,null,null,null,null,null,"0","0",null,null,null,{"$f":"IF((N21*('OR-GREET4.0'!E$44-'Calculated Parameters'!$D$156)*'OR-GREET4.0'!E$46*'OR-GREET4.0'!E$47*'OR-GREET4.0'!E$48/kWh2Btu)>0,(N21*('OR-GREET4.0'!E$44-'Calculated Parameters'!$D$156)*'OR-GREET4.0'!E$46*'OR-GREET4.0'!E$47*'OR-GREET4.0'!E$48/kWh2Btu),0)","v":0},null,null,null,null,null,null,"0",null,null,"0",null,0]
[null," 2.8 Ethanol Sold","Anhydrous Only; Undenatured",null,null,null,null,null,null,"0","0",null,null,null,{"$f":"IF((N22*('OR-GREET4.0'!E$44-'Calculated Parameters'!$D$156)*'OR-GREET4.0'!E$46*'OR-GREET4.0'!E$47*'OR-GREET4.0'!E$48/kWh2Btu)>0,(N22*('OR-GREET4.0'!E$44-'Calculated Parameters'!$D$156)*'OR-GREET4.0'!E$46*'OR-GREET4.0'!E$47*'OR-GREET4.0'!E$48/kWh2Btu),0)","v":0},null,null,null,null,null,null,"0",null,null,"0",null,0]
[null," 2.9 Choose Region the for Burn Area Evaluation","Standard for Non-Sao Paulo States",null,null,null,null,null,null,"0","0",null,null,null,{"$f":"IF((N23*('OR-GREET4.0'!E$44-'Calculated Parameters'!$D$156)*'OR-GREET4.0'!E$46*'OR-GREET4.0'!E$47*'OR-GREET4.0'!E$48/kWh2Btu)>0,(N23*('OR-GREET4.0'!E$44-'Calculated Parameters'!$D$156)*'OR-GREET4.0'!E$46*'OR-GREET4.0'!E$47*'OR-GREET4.0'!E$48/kWh2Btu),0)","v":0},null,null,null,null,null,null,"0",null,null,"0",null,0]
[null,"** Requires an Operating Condition from DEQ",null,null,null,null,null,null,null,"0","0",null,null,null,{"$f":"IF((N24*('OR-GREET4.0'!E$44-'Calculated Parameters'!$D$156)*'OR-GREET4.0'!E$46*'OR-GREET4.0'!E$47*'OR-GREET4.0'!E$48/kWh2Btu)>0,(N24*('OR-GREET4.0'!E$44-'Calculated Parameters'!$D$156)*'OR-GREET4.0'!E$46*'OR-GREET4.0'!E$47*'OR-GREET4.0'!E$48/kWh2Btu),0)","v":0},null,null,null,null,null,null,"0",null,null,"0",null,0]
[null,"Section 3: Static Operational Data",null,null,null,null,null,null,null,"0","0",null,null,null,{"$f":"IF((N25*('OR-GREET4.0'!E$44-'Calculated Parameters'!$D$156)*'OR-GREET4.0'!E$46*'OR-GREET4.0'!E$47*'OR-GREET4.0'!E$48/kWh2Btu)>0,(N25*('OR-GREET4.0'!E$44-'Calculated Parameters'!$D$156)*'OR-GREET4.0'!E$46*'OR-GREET4.0'!E$47*'OR-GREET4.0'!E$48/kWh2Btu),0)","v":0},null,null,null,null,null,null,"0",null,null,"0",null,0]
[null,"3.1 Grid Electricity Region","Brazil",null,null,null,null,null,null,"0","0",null,null,null,{"$f":"IF((N26*('OR-GREET4.0'!E$44-'Calculated Parameters'!$D$156)*'OR-GREET4.0'!E$46*'OR-GREET4.0'!E$47*'OR-GREET4.0'!E$48/kWh2Btu)>0,(N26*('OR-GREET4.0'!E$44-'Calculated Parameters'!$D$156)*'OR-GREET4.0'!E$46*'OR-GREET4.0'!E$47*'OR-GREET4.0'!E$48/kWh2Btu),0)","v":0},null,null,null,null,null,null,"0",null,null,"0",null,0]
[null,"3.2 Biomass-to-Bagasse Equivalent Multiplier","Consult DEQ Staff",null,null,null,null,null,null,"0","0",null,null,null,{"$f":"IF((N27*('OR-GREET4.0'!E$44-'Calculated Parameters'!$D$156)*'OR-GREET4.0'!E$46*'OR-GREET4.0'!E$47*'OR-GREET4.0'!E$48/kWh2Btu)>0,(N27*('OR-GREET4.0'!E$44-'Calculated Parameters'!$D$156)*'OR-GREET4.0'!E$46*'OR-GREET4.0'!E$47*'OR-GREET4.0'!E$48/kWh2Btu),0)","v":0},null,null,null,null,null,null,"0",null,null,"0",null,0]
[null,"3.3 Denaturant Accounting","Default 2.5% CBOB Blend",null,null,null,null,null,null,"0","0",null,null,null,{"$f":"IF((N28*('OR-GREET4.0'!E$44-'Calculated Parameters'!$D$156)*'OR-GREET4.0'!E$46*'OR-GREET4.0'!E$47*'OR-GREET4.0'!E$48/kWh2Btu)>0,(N28*('OR-GREET4.0'!E$44-'Calculated Parameters'!$D$156)*'OR-GREET4.0'!E$46*'OR-GREET4.0'!E$47*'OR-GREET4.0'!E$48/kWh2Btu),0)","v":0},null,null,null,null,null,null,"0",null,null,"0",null,0]
[null,"Ethanol Transport",null,null,null,null,null,null,null,"0","0",null,null,null,{"$f":"IF((N29*('OR-GREET4.0'!E$44-'Calculated Parameters'!$D$156)*'OR-GREET4.0'!E$46*'OR-GREET4.0'!E$47*'OR-GREET4.0'!E$48/kWh2Btu)>0,(N29*('OR-GREET4.0'!E$44-'Calculated Parameters'!$D$156)*'OR-GREET4.0'!E$46*'OR-GREET4.0'!E$47*'OR-GREET4.0'!E$48/kWh2Btu),0)","v":0},null,null,null,null,null,null,"0",null,null,"0",null,0]
[null,"3.4 From Ethanol Plant By Truck (km)",null,null,null,null,null,null,null,"0","0",null,null,null,{"$f":"IF((N30*('OR-GREET4.0'!E$44-'Calculated Parameters'!$D$156)*'OR-GREET4.0'!E$46*'OR-GREET4.0'!E$47*'OR-GREET4.0'!E$48/kWh2Btu)>0,(N30*('OR-GREET4.0'!E$44-'Calculated Parameters'!$D$156)*'OR-GREET4.0'!E$46*'OR-GREET4.0'!E$47*'OR-GREET4.0'!E$48/kWh2Btu),0)","v":0},null,null,null,null,null,null,"0",null,null,"0",null,0]
[null,"3.5 By Pipeline (km)",null,null,null,null,null,null,null,"0","0",null,null,null,{"$f":"IF((N31*('OR-GREET4.0'!E$44-'Calculated Parameters'!$D$156)*'OR-GREET4.0'!E$46*'OR-GREET4.0'!E$47*'OR-GREET4.0'!E$48/kWh2Btu)>0,(N31*('OR-GREET4.0'!E$44-'Calculated Parameters'!$D$156)*'OR-GREET4.0'!E$46*'OR-GREET4.0'!E$47*'OR-GREET4.0'!E$48/kWh2Btu),0)","v":0},null,null,null,null,null,null,"0",null,null,"0",null,0]
[null,"3.6 Ocean Transport Route to Oregon","Via Panama Canal",null,null,null,null,null,null,"0","0",null,null,null,{"$f":"IF((N32*('OR-GREET4.0'!E$44-'Calculated Parameters'!$D$156)*'OR-GREET4.0'!E$46*'OR-GREET4.0'!E$47*'OR-GREET4.0'!E$48/kWh2Btu)>0,(N32*('OR-GREET4.0'!E$44-'Calculated Parameters'!$D$156)*'OR-GREET4.0'!E$46*'OR-GREET4.0'!E$47*'OR-GREET4.0'!E$48/kWh2Btu),0)","v":0},null,null,null,null,null,null,"0",null,null,{"$f":"IFERROR(IF((W32-M32*$Z$34)>0,(W32-M32*$Z$34),0),\"0\")","v":"0"},null,{"$f":"IFERROR(V32*(1-U32)+Y32*(1-X32),\"0\")","v":0}]
[null,"3.7 Ethanol Tranpsort by Ocean Tanker (km)",null,null,"2-Year Total",{"$f":"SUM(F9:F32)","v":0},{"$f":"IFERROR(SUMPRODUCT(F9:F32,G9:G32)/F33,0)","v":0},{"$f":"SUM(H9:H32)","v":0},{"$f":"IFERROR(SUMPRODUCT(H9:H32,I9:I32)/H$33,0)","v":0},{"$f":"IFERROR(SUM(J9:J32),\"\")","v":0},{"$f":"IFERROR(AVERAGE(K9:K32),\"0.0\")","v":"0.0"},{"$f":"SUM(L9:L32)","v":0},{"$f":"SUM(M9:M32)","v":0},{"$f":"SUM(N9:N32)","v":0},0,0,0,{"$f":"IFERROR(SUMPRODUCT($J9:$J32,$R9:$R32)/$J33,0)","v":0},{"$f":"IFERROR(SUMPRODUCT($J9:$J32,$S9:$S32)/$J$33,\"0.0\")","v":"0.0"},{"$f":"SUM(T9:T32)","v":0},{"$f":"IFERROR(SUMPRODUCT($T9:$T32*$U9:$U32)/$T$33,\"0.00%\")","v":"0.00%"},{"$f":"SUM(V9:V32)","v":0},{"$f":"SUM(W9:W32)","v":0},{"$f":"IFERROR(SUMPRODUCT($W9:$W32*$X9:$X32)/$W$33,\"0.00%\")","v":"0.00%"},{"$f":"SUM(Y9:Y32)","v":0},{"$f":"IFERROR(SUM(Z9:Z32),\"0\")","v":0},{"$f":"IF(SUM(AA8:AA32)>0,SUM(AA8:AA32),0)","v":0}]
[null,"3.8 Oregon Port to Terminal (miles)",40,null,"*Externally-sourced non-bagasse biomass must be reported as bagasse equivalent biomass.  Consult CARB Staff for Operating Condition.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(T33/(T33+W33),\"\")","v":""},null,null,{"$f":"IFERROR(1-W34,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'EF Tables'!Z74-'EF Tables'!AA74","v":0}]
[null,"3.9 Terminal to Refueling Stations (miles)",50,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Ethanol (gal):",{"$f":"IF(AA33*264.1593>0,AA33*264.1593,\"0\")","v":"0"}]
[null,"3.10 Applicable Credit for Mechanized Harvesting",{"$f":"IF('Site-Specific Inputs'!C$23=\"\",\"\",IF('Site-Specific Inputs'!$C$23=\"Standard for Sao Paulo State\",'OR-GREET4.0'!E31,'OR-GREET4.0'!E32))","v":0.65}]
[]
[]
[null,"2.5  Provisional Pathway Application (Y/N):"]
[]
[]
[null,null,null,null,null,"3.5  Ethanol Transport Distance by Truck from Oregon Port to Terminal (miles):"]
[null,null,null,null,null,"3.6  Ethanol Transport Distance by Truck from Oregon Terminal to Refueling Station (miles)"]
[null,null,null,"3.4  Anhydrous Ethanol Transport Distance by Ocean Tanker to Oregon (km):"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"g2T",null,1.1023100000000001E-6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"gal2L",null,3.7854109999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MT2T",null,1.102311311]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"m32gal",null,264.17210710000001]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ethanol energy density (MJ/gal)",null,80.532413030499995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ethanol LHV (Btu/gal)",null,76330]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh2Btu",null,3412.141641601248]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Btu2J",null,1055.05585]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"km2mi",null,0.62137119223732995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'EF Tables'!Z74+'EF Tables'!Z75","v":0}]

{"sheet":"Calculated Parameters","index":2,"n_rows":167,"n_cols":36,"rows_kept":167,"cut":false,"hidden":false,"merged":[[119,5,120,5],[115,2,115,3],[12,7,12,10],[14,7,14,10],[31,1,31,11],[66,1,66,14],[77,1,77,14],[88,7,88,12],[88,1,88,6],[89,1,89,4],[89,7,89,10],[114,2,114,3],[95,8,95,9],[94,11,95,11],[94,5,95,5],[90,7,90,8],[112,2,112,3],[110,2,110,3],[109,2,109,3],[98,12,99,12],[11,7,11,10],[13,7,13,10],[15,7,15,10],[92,2,92,3],[90,1,90,2],[27,1,27,3],[25,1,25,3],[24,1,24,3],[94,12,95,12],[98,6,99,6],[95,2,95,3],[94,6,95,6],[2,1,2,10],[8,1,8,6],[26,1,26,3],[3,1,3,10],[5,1,5,10],[6,1,6,10],[7,1,7,10],[9,1,9,6],[8,7,8,10],[16,7,16,10],[17,7,17,10],[18,7,18,10],[10,7,10,10],[9,7,9,10],[4,1,4,10],[127,11,128,11],[123,5,124,5],[125,5,126,5],[127,5,128,5],[28,1,28,3],[123,11,124,11],[125,11,126,11],[108,2,108,3],[107,2,107,3],[121,5,122,5],[113,2,113,3],[121,11,122,11],[119,11,120,11],[114,8,114,9],[115,8,115,9],[92,8,92,9]]}
[]
[]
[null,"Section 5:  Calculation of Production Yields and Mass Allocation Ratio "]
[null," Step 5.a:  It is imperative that any previous versions of the Tier 1 Simplified CI Calculator for Sugarcane Ethanol (v.3.0) be closed. Select \"Data\" from the Excel File Menu (Header) above.  Then Click the \"Solver\" icon menu above to the far right of the header.  Ensure that the \"Set Objective\" refers to Cell E27, and is set to a value of 0.0.  See instructions below to install the \"Solver AddIn\" functionality to your current version of Microsoft Excel.    "]
[null,"Step 5.b:  Do not change any of the constraints defined in the window (see Section 5 User Instruction in the Instruction Manual for the Simplified CI Calculator). Then Click the \"Solve\" Button."]
[null,"Step 5.c:  The Solver will go through several iterations to find a solution.  The \"Calculate CI\" may need to be executed repeatedly if the iterations are not automatic until a solution is found.  A new window \"Solver Results\" will open up.  Solver will display the message that a solution has been found.                                                                                                                                                                                   "]
[null,"Step 5.d: Click OK. If a solution has not been found, it is an indication that there is a material imbalance.  Check the \"Site-Specific Inputs\" data for accuracy, then repeat Step 5.a until a solution has been found, and all constraints and optimality conditions have been satisfied.  "]
[null," Step 5.e:  If a solution has not still been found, then check the juice shares (fraction juice allocated to sugar production), and the fraction of sucrose in the cane juice that enters production.  The level of sucrose (eta_j) could be lower due to process losses even if measured higher at the gate or after crush."]
[null,"Gopal-Kammen Model Parameters",null,null,null,null,null,"Instructions to Install \"Solver Add-In\" Functionality to Current Version of Microsoft Excel"]
[null,"Mill-specific values for ethanol yield calculation and ethanol production modeling",null,null,null,null,null,"1.  Click or go to \"File\" in the Header Menu"]
[null,"5.1  ηj (tonnes of fermentable sugars in juice/tonne of cane)",null,null,null,null,{"$f":"'Site-Specific Inputs'!$S$33","v":"0.0"},"2.  Click or Select \"Options\" on the far Left Side Menu."]
[null,"5.2  ηs (tonnes of sucrose in final sugar/tonne of sucrose into sugar factory)",null,null,null,null,0.44785231540141363,"3.  A new Window \"Excel Options\" opens up.   Select \"Add-ins\" on the Left Side Menu."]
[null,"5.3  Sucrose in Molasses (tonnes sucrose in molasses/tonne of sugarcane)",null,null,null,null,{"$f":"eta_j*(1-eta_s)","v":0},"4.  In the Dialogue Box Select \"Solver Add-in\" either in the \"Active Application,\" or \"Inactive Application Add-ins.\"  Click OK.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standard Value"]
[null,"5.4  ηe (dry tonnes of EtOH/tonne of fermentable sugars into distillery)",null,null,null,null,0.4755493167221394,"5.  If you don’t see the \"Solver Add-in,\" do the following:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"User Defined "]
[null,"5.5  LHV of anhydrous EtOH (MMBtu/dry tonne EtOH)",null,null,"Select Standard or User Values from the Drop Down Menus Below","Enter User Defined Values Below, if Applicable, then Press F9.",25.545515394912986,"6.  At the Bottom of the Dialogue Box, Select or Manage \"Excel Add-Ins\" from the Drop-down Menu.  Then Select \"Go.\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standard Value"]
[null,"5.6  Choose ms (tonnes of sucrose in final sugar/tonne of final sugar product)",null,null,"Standard Value",0.995,{"$f":"IF(E16=\"Standard Value\",0.99,F16)","v":0.99},"7.  An \"Add-Ins\" Window will Open.  In the Window, Select or Check the Box for \"Solver Add-in,\" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"User Defined "]
[null,"5.7  Choose mm (tonnes of fermentable sugars in std molasses/tonne of std molasses)",null,null,"Standard Value",0.52500000000000002,{"$f":"IF(E17=\"Standard Value\",0.5,F17)","v":0.5},"    and the Box for \"Analysis ToolPak.\"  Then Click OK."]
[null,"Yield of Finished Sugar, Standard Molasses, and Ethanol",null,null,null,"Cane Juice-to-Molasses","Cane Juice-to-Ethanol","8.  Go to the Excel Header Menu and select \"Data.\"  The \"Solver\" function (?->) is located at the far right in the \"Analyze\" box.   "]
[null,"Fraction of sugarcane juice sent to finished sugar",null,null,null,1,0]
[null,"Finished sugar yield (tonnes of finished sugar/tonne of cane)",null,null,null,{"$f":"F19*$G$11*$G$12/$G$16","v":0},{"$f":"G19*$G$11*$G$12/$G$16","v":0}]
[null,"By-product molasses yield (tonnes of std molasses/tonnes of cane)",null,null,null,{"$f":"F19*$G$13/$G$17","v":0},{"$f":"G19*$G$13/$G$17","v":0}]
[null,"EtOH Yield (liters of EtOH/metric tonne cane)",null,null,null,{"$f":"$G$14*$G$11*(1-F19*$G$12)/('OR-GREET4.0'!F$77*'OR-GREET4.0'!C$97/'OR-GREET4.0'!F$101)","v":0},{"$f":"$G$14*$G$11*(1-G19*$G$12)/('OR-GREET4.0'!F$77*'OR-GREET4.0'!C$97/'OR-GREET4.0'!F$101)","v":0}]
[null,"EtOH Yield (gal of EtOH / metric tonne cane)",null,null,null,{"$f":"IF('Site-Specific Inputs'!R$33=0%,0,F22/'OR-GREET4.0'!F$101)","v":0},{"$f":"IF('Site-Specific Inputs'!R$33=100%,0,G22/'OR-GREET4.0'!F$101)","v":0}]
[null,null,null,null,null,"Molasses-Ethanol","Cane Juice-Ethanol"]
[null,"5.8  Modeled ethanol production (dry gal)",null,null,{"$f":"SUM(F25:G25)","v":0},{"$f":"F23*'Site-Specific Inputs'!$R$33*'Site-Specific Inputs'!$J$33","v":0},{"$f":"G23*(1-'Site-Specific Inputs'!$R$33)*'Site-Specific Inputs'!$J$33","v":0}]
[null,"5.9  Adjusted reported ethanol production (dry gal)",null,null,{"$f":"((SUMPRODUCT('Site-Specific Inputs'!V9:V32,(1-'Site-Specific Inputs'!U9:U32))+SUMPRODUCT('Site-Specific Inputs'!Y9:Y32,(1-'Site-Specific Inputs'!X9:X32)))*'OR-GREET4.0'!C102)","v":0}]
[null,"5.10  Difference between modeled and adjusted reported ethanol production numbers",null,null,{"$f":"E26-(F25+G25)","v":0}]
[null,"5.11  Modeled finished sugar production (metric tonnes)",null,null,{"$f":"F20*'Site-Specific Inputs'!$R$33*'Site-Specific Inputs'!$J$33","v":0}]
[null,"5.12  Reported finished sugar production (metric tonnes)",null,null,{"$f":"'Site-Specific Inputs'!$Z$33","v":0},{"$f":"ABS(E30)","v":0}]
[null,"5.13  Difference between modeled and reported Finished Sugar Production:",null,null,{"$f":"'Site-Specific Inputs'!$Z$33-$E$28","v":0},"5.14 Mass Allocation Ratio:",{"$f":"IFERROR(IF('Site-Specific Inputs'!R$33=0%,0,G13/G11),\"0.0\")","v":0}]
[]
[null,"Section 6:  Verify Fuel and Co-Product Production Information"]
[null,"6.1 Ethanol Produced from Cane Juice, dry gal",{"$f":"G$25","v":0},"6.3  Ethanol Produced from Molasses, dry gal",{"$f":"F$25","v":0},"6.5  Total Ethanol Produced, dry gal",{"$f":"F25+G25","v":0},"6.7  Net Surplus Cogenerated Electricity Exported (kWh)",{"$f":"('Site-Specific Inputs'!Q33-'Site-Specific Inputs'!P33)","v":0},"6.9  Electricity Co-Product Credit (kWh/gal) (Molasses Feedstock)",{"$f":"IFERROR('EF Tables'!G$73,0)","v":0},"6.11  Composite Electricity Co-Product Credit (kWh/gal)"]
[null,"6.2  Juice-to-Ethanol Yield (gal/tonne cane)",{"$f":"$G$23","v":0},"6.4  Molasses-to-Ethanol Yield (gal/tonne cane)",{"$f":"$F$23","v":0},"6.6  Total Finished Sugar Produced, metric tons",{"$f":"'Site-Specific Inputs'!Z33","v":0},"6.8  Net Electricity Credited to Pathway (kWh)",{"$f":"IFERROR(I$33-'Site-Specific Inputs'!O$33,\"0\")","v":0},"6.10  Electricity Co-Product Credit (kWh/gal) (Cane Juice Feedstock)",{"$f":"IFERROR('EF Tables'!G$74,0)","v":0},{"$f":"IFERROR(IF(I34>0,'EF Tables'!G$75,0),\"0.0\")","v":0}]
[]
[null,"Select Regional Electricity Mix"]
[null,"1-U.S Ave Mix"]
[null,"2-User Defined Mix"]
[null,"3-CAMX Mix"]
[null,"4-NWPP Mix"]
[null,"5-AZNM Mix"]
[null,"6-RMPA Mix"]
[null,"7-MROW Mix"]
[null,"8-SPNO Mix"]
[null,"9-SPSO Mix"]
[null,"10-ERCT Mix"]
[null,"11-MROE Mix"]
[null,"12-SRMW Mix",null,null,null,0]
[null,"13-SRMV Mix"]
[null,"14-RFCM Mix"]
[null,"15-RFCW Mix"]
[null,"16-SRTV Mix"]
[null,"17-SRSO Mix"]
[null,"18-NEWE Mix"]
[null,"19-NYUP Mix"]
[null,"20-RFCE Mix"]
[null,"21-NYLI Mix"]
[null,"22-NYCW Mix"]
[null,"23-SRVC Mix"]
[null,"24-FRCC Mix"]
[null,"25-AKMS Mix"]
[null,"26-AKGD Mix"]
[null,"27-HIOA Mix"]
[null,"28-HIMS Mix",null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL CI (gCO2e/MJ)"]
[null,"29-Brazilian Mix"]
[null,"30-Canadian Mix"]
[null,"Section 7: Emissions Factor (EF)-based Aggregated CI Impact Determination for Sugarcane Juice Feedstock"]
[null,null,"Sugarcane Agriculture & Farming Impacts  (gCO2e/m.t. cane) ","Cane & Filtercake Transport (gCO2e/tonne-mile)","Straw Burning Emissions  (gCO2e/m.t. cane) ","Sugar Production Emissions  (gCO2e/m.t. cane) ","Net Surplus Cogenerated Electricity Credit (gCO2e/kWh)","Ethanol Production Emissions  (gCO2e/gal) ","Anhydrous Ethanol Truck Transport in Brazil Emissions (gCO2e/gal-mile)","Anhydrous Ethanol Pipeline Transport in Brazil Emissions (gCO2e/gal-mile)","Anhydrous Ethanol Ocean Transport Emissions (gCO2e/gal-mile)","Ethanol Truck Transport in Oregon Emissions (gCO2e/gal-mile)","Denaturant Emissions (gCO2e/gal)","ILUC (gCO2e/gal) ","TOTAL CI (gCO2e/MJ)"]
[null,"Emissions Factor (EF)",{"$f":"IFERROR('EF General'!O22,\"0.0\")","v":0},{"$f":"IFERROR('EF Tables'!H$14/SUM('EF Tables'!#REF!+'EF Tables'!D$8),\"0.0\")","v":"0.0"},{"$f":"'EF General'!$D$37","v":17336.27700000006},"NA",{"$f":"'EF Tables'!H$85","v":0},{"$f":"IFERROR('EF General'!I$92,\"0.0\")","v":0},{"$f":"'EF General'!$K$170","v":0.40478481320180215},{"$f":"'EF General'!$D$170","v":5.1924761005547257E-2},{"$f":"'EF General'!H$170","v":8.7114531831325004E-2},{"$f":"'EF General'!$L$170","v":0.40486360391257098},{"$f":"IFERROR('EF General'!I$116,\"0.0\")","v":0},{"$f":"IFERROR('EF General'!H$126,\"0.0\")","v":950.28621164000003}]
[null,"Total Cane Procured (m.t.):",{"$f":"IF('Site-Specific Inputs'!$J$33>0,'Site-Specific Inputs'!$J$33,\"-\")","v":"-"},{"$f":"'Site-Specific Inputs'!$J$33","v":0},{"$f":"'Site-Specific Inputs'!$J$33","v":0},0,{"$f":"CONCATENATE(('Site-Specific Inputs'!Q$33-'Site-Specific Inputs'!P$33-'Site-Specific Inputs'!O$33),\" kWh\")","v":"0 kWh"},{"$f":"'Site-Specific Inputs'!$J$33","v":0},{"$f":"CONCATENATE(('Site-Specific Inputs'!$C$30/1.609),\" total truck miles\")","v":"0 total truck miles"},{"$f":"CONCATENATE(('Site-Specific Inputs'!$C$31/1.609),\" total truck miles\")","v":"0 total truck miles"},{"$f":"CONCATENATE('Site-Specific Inputs'!C$33/1.609,\" ocean miles\")","v":"0 ocean miles"},{"$f":"CONCATENATE('Site-Specific Inputs'!C$34+'Site-Specific Inputs'!C$35,\" miles\")","v":"90 miles"},{"$f":"'Site-Specific Inputs'!$J$33","v":0},{"$f":"'Site-Specific Inputs'!$J$33","v":0},{"$f":"IFERROR(N74+M74+E121+H74+D121+I74+G74+F74+E74+D74+C74,\"-\")","v":"-"}]
[null,"Total Ethanol Produced (dry gal):",{"$f":"IF('Site-Specific Inputs'!$AA$33>0,'Site-Specific Inputs'!$AA$33*264.1596,\"-\")","v":"-"},{"$f":"'Site-Specific Inputs'!$AA$33*264.1596","v":0},{"$f":"'Site-Specific Inputs'!$AA$33*264.1596","v":0},0,{"$f":"'Site-Specific Inputs'!$AA$33*264.1596","v":0},{"$f":"'Site-Specific Inputs'!$AA$33*264.1596","v":0},{"$f":"'Site-Specific Inputs'!$V$33*(1-'Site-Specific Inputs'!$U$33)*264.1596","v":0},{"$f":"'Site-Specific Inputs'!$V$33*(1-'Site-Specific Inputs'!$U$33)*264.1596","v":0},{"$f":"'Site-Specific Inputs'!$V$33*(1-'Site-Specific Inputs'!$U$33)*264.1596","v":0},{"$f":"'Site-Specific Inputs'!$V$33*(1-'Site-Specific Inputs'!$U$33)*264.1596/0.975","v":0},{"$f":"'Site-Specific Inputs'!$V$33*(1-'Site-Specific Inputs'!$U$33)*264.1596","v":0},{"$f":"'Site-Specific Inputs'!$AA$33*264.1596","v":0},{"$f":"IFERROR(N75+M75+H75+D124+E124+I75+G75+F75+E75+D75+C75,\"-\")","v":"-"}]
[null,"Total Emissions (gCO2e)",{"$f":"IF('Site-Specific Inputs'!J$33>0,C69*'Site-Specific Inputs'!$J$33,\"-\")","v":"-"},{"$f":"D69*(('Site-Specific Inputs'!$K$33)/1.609)*('Site-Specific Inputs'!J$33)","v":0},{"$f":"E69*'Site-Specific Inputs'!$J$33","v":0},0,{"$f":"-G69*('Site-Specific Inputs'!Q$33-'Site-Specific Inputs'!P$33-'Site-Specific Inputs'!O$33)","v":0},{"$f":"H69*'Site-Specific Inputs'!$AA$33*264.1596","v":0},{"$f":"I69*(('Site-Specific Inputs'!C$30/1.609))*I71*264.1596","v":0},{"$f":"J69*(('Site-Specific Inputs'!C$31/1.609))*J71*264.1596","v":0},{"$f":"K69*(K71)*(('Site-Specific Inputs'!C$33/1.609))","v":0},{"$f":"L69*('Site-Specific Inputs'!$C$34+'Site-Specific Inputs'!$C$35)*L71","v":0},{"$f":"M69*M71","v":0},{"$f":"N69*('Site-Specific Inputs'!$AA$33*264.1596)","v":0}]
[null,"Emissions (Sugarcane for Sugar) (gCO2e)",{"$f":"IFERROR((C74/$G$30)-C74,\"-\")","v":"-"},{"$f":"IFERROR((D$74/$G$30)-D$74,\"-\")","v":"-"},{"$f":"E72-E75-E74","v":0},0,{"$f":"G72-G75-G74","v":0},{"$f":"IFERROR(H72-H75-H74,\"-\")","v":"-"},{"$f":"IFERROR(I72-I75-I74,\"-\")","v":"-"},{"$f":"IFERROR(J72-J75-J74,\"-\")","v":"-"},{"$f":"IFERROR(K72-K75-K74,\"-\")","v":"-"},{"$f":"IFERROR(L72-L75-L74,\"-\")","v":"-"},0,{"$f":"IFERROR(N72-N75-N74,\"-\")","v":"-"}]
[null,"Emissions (Sugarcane for Molasses) (gCO2e)",{"$f":"IFERROR((C72-C75)*G$30,\"-\")","v":"-"},{"$f":"(D72-D75)*G$30","v":0},{"$f":"(E72-E75)*G30","v":0},0,{"$f":"(G72-G75)*G$30","v":0},{"$f":"IFERROR(H72-H75,\"-\")","v":"-"},{"$f":"IFERROR(I72-I75,\"-\")","v":"-"},{"$f":"IFERROR(J72-J75,\"-\")","v":"-"},{"$f":"IFERROR(K72-K75,\"-\")","v":"-"},{"$f":"IFERROR(L72-L75,\"-\")","v":"-"},{"$f":"'EF Tables'!C$124*'Calculated Parameters'!F$25*76330*1055.06/10^6","v":0},{"$f":"IFERROR(N72-N75,\"-\")","v":"-"}]
[null,"Emissions (Sugarcane for Juice) (gCO2e)",{"$f":"IFERROR(C72*(1-'Site-Specific Inputs'!$R$33),\"-\")","v":"-"},{"$f":"D72*(1-'Site-Specific Inputs'!R$33)","v":0},{"$f":"E72*(1-'Site-Specific Inputs'!$R$33)","v":0},0,{"$f":"G72*(1-'Site-Specific Inputs'!R$33)","v":0},{"$f":"IFERROR(H72*$G$25/($F$25+$G$25),\"-\")","v":"-"},{"$f":"IFERROR(I72*$G$25/($F$25+$G$25),\"-\")","v":"-"},{"$f":"IFERROR(J72*$G$25/($F$25+$G$25),\"-\")","v":"-"},{"$f":"IFERROR(K72*$G$25/($F$25+$G$25),\"-\")","v":"-"},{"$f":"IFERROR(L72*$G$25/($F$25+$G$25),\"-\")","v":"-"},{"$f":"'EF Tables'!D$124*'Calculated Parameters'!G$25*76330*1055.06/10^6","v":0},{"$f":"IFERROR(N72*$G$25/($F$25+$G$25),\"-\")","v":"-"}]
[null," CI Calc Using EF (gCO2e/MJ)",{"$f":"IF('Site-Specific Inputs'!R$33=100%,\"-\",IFERROR((C69*C70*((1-'Site-Specific Inputs'!R$33)+'Site-Specific Inputs'!$R$33*$G$30)/($C71*76330*1055.06/10^6)),\"-\"))","v":"-"},{"$f":"IF('Site-Specific Inputs'!R$33=100%,0,IFERROR(SUM(D$74:D$75)/((F$25+G$25)*76330*1055.06/10^6),0))","v":0},{"$f":"IF('Site-Specific Inputs'!R$33=100%,0,IFERROR((1-'Site-Specific Inputs'!$C$36)*E69*'Site-Specific Inputs'!J$33*((1-'Site-Specific Inputs'!$R$33)+'Site-Specific Inputs'!$R$33*$G$30)/($E71*76330*1055.06/10^6),0))","v":0},0,{"$f":"IF('Site-Specific Inputs'!R$33=100%,0,-G69*L$34/(76330*1055.06/10^6))","v":0},{"$f":"IF('Site-Specific Inputs'!AA33=0,0,IF('Site-Specific Inputs'!R$33=100%,0,H69/(76330*1055.06/10^6)))","v":0},{"$f":"IF('Site-Specific Inputs'!AA33=0,0,IF('Site-Specific Inputs'!R$33=100%,0,I69*(('Site-Specific Inputs'!C$30/1.609))*10^6/(76330*1055.06)))","v":0},{"$f":"IF('Site-Specific Inputs'!AA$33=0%,0,J69*(('Site-Specific Inputs'!C$31/1.609))*10^6/(76330*1055.06))","v":0},{"$f":"IF('Site-Specific Inputs'!AA33=0,0,IF('Site-Specific Inputs'!R$33=100%,0,K69*(('Site-Specific Inputs'!C$33/1.609)*10^6/(76330*1055.06))))","v":0},{"$f":"IF('Site-Specific Inputs'!AA33=0,0,IF('Site-Specific Inputs'!R$33=100%,0,L69*('Site-Specific Inputs'!$C$34+'Site-Specific Inputs'!$C$35)*10^6/(76330*1055.06)))","v":0},{"$f":"IF('Site-Specific Inputs'!R$33=100%,0,M69/(76330*1055.06/10^6))","v":0},{"$f":"IF('Site-Specific Inputs'!AA33=0,0,IF('Site-Specific Inputs'!R$33=100%,0,N69/(76330*1055.06/10^6)))","v":0},{"$f":"IF('Site-Specific Inputs'!R$33=100%,0,IFERROR(N76+M76+L76+K76+I76+H76+G76+F76+E76+D76+C76,\"0.00\"))","v":"0.00"}]
[null,null,null,null,null,null,null,null,"Checked","Checked","Checked","Checked"]
[null,"Section 8: Emissions Factor (EF)-based Aggregated CI Impact Determination for Sugarcane Molasses Feedstock"]
[null,null,"Sugarcane Agriculture & Farming Impacts  (gCO2e/m.t. cane) ","Cane & Filtercake Transport (gCO2e/tonne-mile)","Straw Burning Emissions  (gCO2e/m.t. cane) ","Sugar Production Emissions  (gCO2e/m.t. cane) ","Net Surplus Cogenerated Electricity Credit (gCO2e/kWh)","Ethanol Production Emissions  (gCO2e/gal) ","Anhydrous Ethanol Truck Transport in Brazil Emissions (gCO2e/gal-mile)","Anhydrous Ethanol Pipeline Transport in Brazil Emissions (gCO2e/gal-mile)","Anhydrous Ethanol Ocean Transport Emissions (gCO2e/gal-mile)","Ethanol Truck Transport in Oregon Emissions (gCO2e/gal-mile)","Denaturant Emissions (gCO2e/gal)","ILUC (gCO2e/gal) ","TOTAL CI (gCO2e/MJ)"]
[null,"Emissions Factor (EF)",{"$f":"IFERROR('EF General'!J31,\"-\")","v":0},{"$f":"IFERROR('EF Tables'!H$14/SUM('EF Tables'!#REF!+'EF Tables'!D$8),\"0.0\")","v":"0.0"},{"$f":"'EF General'!$D$37","v":17336.27700000006},{"$f":"3700/(2000*0.4536/1000)","v":4078.4832451499119},{"$f":"'EF Tables'!G$85","v":0},{"$f":"IFERROR('EF General'!I$92,\"0.0\")","v":0},{"$f":"'EF General'!$K$170","v":0.40478481320180215},{"$f":"'EF General'!$D$170","v":5.1924761005547257E-2},{"$f":"'EF General'!H$170","v":8.7114531831325004E-2},{"$f":"'EF General'!$L$170","v":0.40486360391257098},{"$f":"IFERROR('EF General'!I$115,\"0.0\")","v":0},{"$f":"IFERROR('EF General'!H$126,\"0.0\")","v":950.28621164000003}]
[null,"Total Cane Procured (m.t.):",{"$f":"IF('Site-Specific Inputs'!$J$33>0,'Site-Specific Inputs'!$J$33,\"-\")","v":"-"},{"$f":"'Site-Specific Inputs'!$J$33","v":0},{"$f":"'Site-Specific Inputs'!$J$33","v":0},{"$f":"'Site-Specific Inputs'!$J$33","v":0},{"$f":"CONCATENATE(('Site-Specific Inputs'!Q$33-'Site-Specific Inputs'!P$33-'Site-Specific Inputs'!O$33),\" kWh\")","v":"0 kWh"},{"$f":"'Site-Specific Inputs'!$J$33","v":0},{"$f":"CONCATENATE(('Site-Specific Inputs'!$C$30/1.609),\" total truck miles\")","v":"0 total truck miles"},{"$f":"CONCATENATE(('Site-Specific Inputs'!$C$31/1.609),\" total truck miles\")","v":"0 total truck miles"},{"$f":"CONCATENATE('Site-Specific Inputs'!C$33/1.609,\" ocean miles\")","v":"0 ocean miles"},{"$f":"CONCATENATE('Site-Specific Inputs'!C$34+'Site-Specific Inputs'!C$35,\" miles\")","v":"90 miles"},{"$f":"'Site-Specific Inputs'!$J$33","v":0},{"$f":"'Site-Specific Inputs'!$J$33","v":0}]
[null,"Total Ethanol Produced (dry gal):",{"$f":"IF('Site-Specific Inputs'!$AA$33>0,'Site-Specific Inputs'!$AA$33*264.1596,\"-\")","v":"-"},{"$f":"'Site-Specific Inputs'!$AA$33*264.1596","v":0},{"$f":"'Site-Specific Inputs'!$AA$33*264.1596","v":0},{"$f":"'Site-Specific Inputs'!$AA$33*264.1596","v":0},{"$f":"'Site-Specific Inputs'!$AA$33*264.1596","v":0},{"$f":"'Site-Specific Inputs'!$AA$33*264.1596","v":0},{"$f":"'Site-Specific Inputs'!$V$33*(1-'Site-Specific Inputs'!$U$33)*264.1596","v":0},{"$f":"'Site-Specific Inputs'!$V$33*(1-'Site-Specific Inputs'!$U$33)*264.1596","v":0},{"$f":"'Site-Specific Inputs'!$V$33*(1-'Site-Specific Inputs'!$U$33)*264.1596","v":0},{"$f":"'Site-Specific Inputs'!$V$33*(1-'Site-Specific Inputs'!$U$33)*264.1596/0.975","v":0},{"$f":"'Site-Specific Inputs'!$V$33*(1-'Site-Specific Inputs'!$U$33)*264.1596","v":0},{"$f":"'Site-Specific Inputs'!$AA$33*264.1596","v":0}]
[null,"Total Emissions (gCO2e)",{"$f":"IF('Site-Specific Inputs'!J$33>0,C80*'Site-Specific Inputs'!$J$33,\"-\")","v":"-"},{"$f":"D80*(('Site-Specific Inputs'!$K$33)/1.609)*('Site-Specific Inputs'!J$33)","v":0},{"$f":"E80*'Site-Specific Inputs'!$J$33","v":0},{"$f":"F80*'Site-Specific Inputs'!$J$33*'Site-Specific Inputs'!R$33","v":0},{"$f":"-G80*('Site-Specific Inputs'!Q$33-'Site-Specific Inputs'!P$33-'Site-Specific Inputs'!O$33)","v":0},{"$f":"H80*'Site-Specific Inputs'!$AA$33*264.1596","v":0},{"$f":"I80*(('Site-Specific Inputs'!C$30/1.609))*I82*264.1596","v":0},{"$f":"J80*(('Site-Specific Inputs'!C$31/1.609))*J82*264.1596","v":0},{"$f":"K80*(K82)*(('Site-Specific Inputs'!C$33/1.609))","v":0},{"$f":"L80*('Site-Specific Inputs'!$C$34+'Site-Specific Inputs'!$C$35)*L82","v":0},{"$f":"M80*M82","v":0},{"$f":"N80*('Site-Specific Inputs'!$AA$33*264.1596)","v":0}]
[null,"Emissions (Sugarcane for Sugar) (gCO2e)",{"$f":"IFERROR((C85/$G$30)-C85,\"-\")","v":"-"},{"$f":"IFERROR((D$74/$G$30)-D$74,\"-\")","v":"-"},{"$f":"E83-E86-E85","v":0},{"$f":"F$80*'Site-Specific Inputs'!J$33*'Site-Specific Inputs'!R$33","v":0},{"$f":"G83-G86-G85","v":0},{"$f":"IFERROR(H83-H86-H85,\"-\")","v":"-"},{"$f":"IFERROR(I83-I86-I85,\"-\")","v":"-"},{"$f":"IFERROR(J83-J86-J85,\"-\")","v":"-"},{"$f":"IFERROR(K83-K86-K85,\"-\")","v":"-"},{"$f":"IFERROR(L83-L86-L85,\"-\")","v":"-"},0,{"$f":"IFERROR(N83-N86-N85,\"-\")","v":"-"}]
[null,"Emissions (Sugarcane for Molasses) (gCO2e)",{"$f":"IFERROR((C83-C86)*G$30,\"-\")","v":"-"},{"$f":"(D83-D86)*G$30","v":0},{"$f":"(E83-E86)*G30","v":0},{"$f":"F80*'Site-Specific Inputs'!$J$33*G$30*'Site-Specific Inputs'!R$33","v":0},{"$f":"(G83-G86)*G$30","v":0},{"$f":"IFERROR(H83-H86,\"-\")","v":"-"},{"$f":"IFERROR(I83-I86,\"-\")","v":"-"},{"$f":"IFERROR(J83-J86,\"-\")","v":"-"},{"$f":"IFERROR(K83-K86,\"-\")","v":"-"},{"$f":"IFERROR(L83-L86,\"-\")","v":"-"},{"$f":"'EF Tables'!C$124*'Calculated Parameters'!F$25*76330*1055.06/10^6","v":0},{"$f":"IFERROR(N83-N86,\"-\")","v":"-"}]
[null,"Emissions (Sugarcane for Juice) (gCO2e)",{"$f":"IFERROR(C83*(1-'Site-Specific Inputs'!$R$33),0)","v":0},{"$f":"D83*(1-'Site-Specific Inputs'!R$33)","v":0},{"$f":"E83*(1-'Site-Specific Inputs'!$R$33)","v":0},0,{"$f":"G83*(1-'Site-Specific Inputs'!R$33)","v":0},{"$f":"IFERROR(H83*$G$25/($F$25+$G$25),\"-\")","v":"-"},{"$f":"IFERROR(I83*$G$25/($F$25+$G$25),\"-\")","v":"-"},{"$f":"IFERROR(J83*$G$25/($F$25+$G$25),\"-\")","v":"-"},{"$f":"IFERROR(K83*$G$25/($F$25+$G$25),\"-\")","v":"-"},{"$f":"IFERROR(L83*$G$25/($F$25+$G$25),\"-\")","v":"-"},{"$f":"'EF Tables'!D$124*'Calculated Parameters'!G$25*76330*1055.06/10^6","v":0},{"$f":"IFERROR(N83*$G$25/($F$25+$G$25),\"-\")","v":"-"}]
[null," CI Calc Using EF (gCO2e/MJ)",{"$f":"IF('Site-Specific Inputs'!R$33=0%,\"-\",IFERROR(C80*C81*((1-'Site-Specific Inputs'!R$33)+'Site-Specific Inputs'!$R$33*$G$30)/($C82*76330*1055.06/10^6),0))","v":"-"},{"$f":"IF('Site-Specific Inputs'!R$33=0%,0,IFERROR(SUM(D$74:D$75)/((F$25+G$25)*76330*1055.06/10^6),\"0.0\"))","v":0},{"$f":"IF('Site-Specific Inputs'!R$33=0%,0,IFERROR((1-'Site-Specific Inputs'!$C$36)*E80*'Site-Specific Inputs'!J$33*((1-'Site-Specific Inputs'!$R$33)+'Site-Specific Inputs'!$R$33*$G$30)/($E82*76330*1055.06/10^6),\"0.0\"))","v":0},{"$f":"IF('Site-Specific Inputs'!R$33=0%,0,IFERROR(F80*'Site-Specific Inputs'!J$33*'Site-Specific Inputs'!$R$33*$G$30/($F$25*76330*1055.06/10^6),0))","v":0},{"$f":"IF('Site-Specific Inputs'!R$33=0%,0,-G80*L$34/(76330*1055.06/10^6))","v":0},{"$f":"IF('Site-Specific Inputs'!R$33=0%,0,H80/(76330*1055.06/10^6))","v":0},{"$f":"IF('Site-Specific Inputs'!R$33=0%,0,I80*(('Site-Specific Inputs'!C$30/1.609))*10^6/(76330*1055.06))","v":0},{"$f":"IF('Site-Specific Inputs'!R$33=0%,0,J80*(('Site-Specific Inputs'!C$31/1.609))*10^6/(76330*1055.06))","v":0},{"$f":"IF('Site-Specific Inputs'!R$33=0%,0,K80*(('Site-Specific Inputs'!C$33/1.609)*10^6/(76330*1055.06)))","v":0},{"$f":"IF('Site-Specific Inputs'!R$33=0%,0,L80*('Site-Specific Inputs'!$C$34+'Site-Specific Inputs'!$C$35)*10^6/(76330*1055.06))","v":0},{"$f":"IF('Site-Specific Inputs'!R$33=0%,0,M80/(76330*1055.06/10^6))","v":0},{"$f":"IF('Site-Specific Inputs'!R$33=0%,0,N80/(76330*1055.06/10^6))","v":0},{"$f":"IF('Site-Specific Inputs'!R$33=0%,\"0.00\",IF('Site-Specific Inputs'!R33=0,0,N87+M87+L87+K87+I87+H87+G87+F87+E87+D87+C87))","v":"0.00"}]
[null,null,null,null,0,null,null,null,"Checked","Checked","Checked","Checked"]
[null," Section 9.a:  CI Calculations for Sugarcane Juice-based Ethanol",null,null,null,null,null," Section 9.b:  CI Calculations for Sugarcane Molasses-based Ethanol"]
[null,"Sugarcane Juice-based Ethanol",null,null,null,"Juice-to-Fuel Share",{"$f":"1-M90","v":1},"Sugarcane Molasses-based Ethanol",null,null,null,"Juice-to-Sugar Share",{"$f":"'Site-Specific Inputs'!R33","v":0}]
[null,"eGRID (Electricity Mix) region",null,{"$f":"'Site-Specific Inputs'!#REF!","v":{"$error":"#REF!"}},"Value","Total Emissions (gCO2e)","CI, gCO2e/MJ","eGRID (Electricity Mix) region",null,{"$f":"'Site-Specific Inputs'!#REF!","v":{"$error":"#REF!"}},"Value","Total Emissions (gCO2e)","CI, gCO2e/MJ"]
[null,"Feedstock Production","Sugarcane Farming",null,null,null,null,"Feedstock Production","Sugarcane Farming"]
[null,null,"Farming Energy, Btu/metric tonne cane",null,95000,{"$f":"CONCATENATE('EF Tables'!$U$38,\" per m.t. cane\")","v":"8306.89666302434 per m.t. cane"},{"$f":"IFERROR(IF('Site-Specific Inputs'!$R$33=100%,0,'EF Tables'!U$40),\"0.0\")","v":"-"},null,"Farming Energy, Btu/metric tonne cane",null,95000,{"$f":"CONCATENATE('EF Tables'!$U$38,\" per m.t. cane\")","v":"8306.89666302434 per m.t. cane"},{"$f":"IFERROR(IF('Site-Specific Inputs'!R$33=0%,0,'EF Tables'!U$39),\"0.0\")","v":0}]
[null,null,"Fertilizers and Ag Chemicals",null,null,{"$f":"CONCATENATE('EF Tables'!$V$38,\" per  m.t.cane\")","v":"8163.02660731458 per  m.t.cane"},{"$f":"IFERROR(IF('Site-Specific Inputs'!$R$33=100%,0,'EF Tables'!R$35),\"0.0\")","v":0},null,"Fertilizers and Agricultural Chemicals",null,null,{"$f":"CONCATENATE('EF Tables'!$V$38,\" per  m.t.cane\")","v":"8163.02660731458 per  m.t.cane"},{"$f":"IFERROR(IF('Site-Specific Inputs'!R$33=0%,0,'EF Tables'!Q$35),\"0.0\")","v":0}]
[null,null,"N2O in Soil",null,null,{"$f":"CONCATENATE('EF Tables'!$W$38,\" per m.t.cane\")","v":"14385.152317146 per m.t.cane"},{"$f":"IFERROR(IF('Site-Specific Inputs'!$R$33=100%,0,'EF Tables'!W$40),\"0.0\")","v":"-"},null,"N2O in Soil",null,null,{"$f":"CONCATENATE('EF Tables'!$W$38,\" per m.t.cane\")","v":"14385.152317146 per m.t.cane"},{"$f":"IFERROR(IF('Site-Specific Inputs'!R$33=0%,0,'EF Tables'!W$39),0)","v":0}]
[null,null,"N content above and below ground, g N2/tonne cane",null,1036,null,null,null,"N content above and below ground, g N2/tonne cane",null,1036]
[null,null,"Sugarcane Straw Burning in Field",null,null,null,{"$f":"IFERROR(IF('Site-Specific Inputs'!$R$33=100%,0,'EF Tables'!J$43),\"0.0\")","v":0},null,"Sugarcane Straw Burning in Field",null,null,null,{"$f":"IFERROR(IF('Site-Specific Inputs'!R$33=0%,0,'EF Tables'!J$42),\"0.0\")","v":0}]
[null,null,"Sugarcane Transport to Mill",null,null,null,null,null,"Sugarcane Transport to Mill"]
[null,null,null,"Cane transport by MDT, miles",{"$f":"'EF Tables'!D8","v":2},null,{"$f":"IFERROR(IF('Site-Specific Inputs'!$R$33=100%,0,'EF Tables'!H$16),\"0.0\")","v":0},null,null,"Cane transport by MDT, miles",{"$f":"'EF Tables'!D8","v":2},null,{"$f":"IFERROR(IF('Site-Specific Inputs'!R$33=0%,0,'EF Tables'!H$15),\"0.0\")","v":0}]
[null,null,null,"Cane transport by HDDT, miles",{"$f":"IFERROR('EF Tables'!#REF!,\"0.0\")","v":"0.0"},null,null,null,null,"Cane transport by HDDT, miles",{"$f":"IFERROR('EF Tables'!#REF!,\"0.0\")","v":"0.0"}]
[null,null,"Filtercake Transport to Cane Farm",null,null,null,null,null,"Filtercake Transport to Cane Farm"]
[null,null,null,"Filtercake transport by HDDT, miles",{"$f":"IFERROR(SUM(E99:E100),\"0.0\")","v":2},null,{"$f":"IFERROR(IF('Site-Specific Inputs'!$R$33=100%,0,'EF Tables'!E$28),\"0.0\")","v":0},null,null,"Filtercake transport by HDDT, miles",{"$f":"IFERROR(SUM(K99:K100),\"0.0\")","v":2},null,{"$f":"IFERROR(IF('Site-Specific Inputs'!R$33=0%,0,'EF Tables'!E$27),\"0.0\")","v":0}]
[null,null,"Co-product and Other Credits",null,null,null,null,null,"Co-product and Other Credits"]
[null,null,null,"Net Surplus Cogenerated Electricity Export, kWh/gal",{"$f":"K34","v":0},null,{"$f":"IFERROR(IF('Site-Specific Inputs'!$R$33=100%,0,'EF Tables'!R$71),\"0.0\")","v":0},null,null,"Net Surplus Cogenerated Electricity Export, kWh/gal",{"$f":"K33","v":0},null,{"$f":"IFERROR(IF('Site-Specific Inputs'!R$33=0%,0,'EF Tables'!Q$71),\"0.0\")","v":0}]
[null,null,null,"Mechanized Harvesting (%)",{"$f":"'Site-Specific Inputs'!C36","v":0.65},null,{"$f":"IFERROR(IF('Site-Specific Inputs'!$R$33=100%,0,-'EF Tables'!J43*'Site-Specific Inputs'!C36),0)","v":0},null,null,"Mechanized Harvesting (%)",{"$f":"'Site-Specific Inputs'!C36","v":0.65},null,{"$f":"IFERROR(IF('Site-Specific Inputs'!S$32=0%,0,-'EF Tables'!J42*'Calculated Parameters'!K105),\"0.0\")","v":0}]
[null,"Fuel Production","Sugar Production (gCO2e/wet tonne cane)",null,{"$f":"'EF Tables'!C45","v":4078.4832451499119},null,{"$f":"0","v":0},"Fuel Production","Sugar Production (gCO2e/wet tonne cane)",null,{"$f":"'EF Tables'!C45","v":4078.4832451499119},null,{"$f":"IFERROR(IF('Site-Specific Inputs'!R$33=0%,0,'EF Tables'!Q44),0)","v":0}]
[null,null,"Ethanol Production",null,null,null,null,null,"Ethanol Production"]
[null,null,"Total feedstock used, metric tonnes cane",null,{"$f":"('Site-Specific Inputs'!$J$33*(1-'Site-Specific Inputs'!R33))/2","v":0},null,null,null,"Total feedstock used, metric tonnes cane",null,{"$f":"'Site-Specific Inputs'!$J$33*'Site-Specific Inputs'!R33/2","v":0}]
[null,null,"Total undenatured ethanol, gallons",null,{"$f":"G25","v":0},null,null,null,"Total undenatured ethanol, gallons",null,{"$f":"F25","v":0}]
[null,null,"Ethanol Yield, gal ethanol / tonne cane",null,{"$f":"C34","v":0},null,null,null,"Ethanol Yield, gal ethanol / tonne cane",null,{"$f":"E34","v":0}]
[null,null,"     Biomass (HHV), tons (See Non-Biogenic Emissions Below)",null,null,null,null,null,"     Biomass (HHV), tons (See Non-Biogenic Emissions Below)"]
[null,null,null,"Average Moisture, %",null,null,null,null,null,"Average Moisture, %"]
[null,null,"     Electricity, kWh/gal ethanol",null,7.1419999999999999E-3,null,null,null,"     Electricity, kWh/gal ethanol",null,7.1419999999999999E-3]
[null,null,"Non-biogenic (CH4/N2O) in Bagasse Combustion ",null,null,null,{"$f":"IFERROR(IF('Site-Specific Inputs'!$R$33=100%,0,'EF Tables'!R60),\"0.0\")","v":0},null,"Non-biogenic (CH4/N2O) in Bagasse Combustion ",null,null,null,{"$f":"IF('Site-Specific Inputs'!R$33=0%,0,'EF Tables'!Q60)","v":0}]
[null,null,"Total Plant Energy Consumption, Btu/gal",null,{"$f":"E116+E113*3412.96","v":324.37536032000003},null,null,null,"Total Plant Energy Consumption, Btu/gal",null,{"$f":"K116+K113*3412.96","v":324.37536032000003}]
[null,null,"     Residual Oil (10% Lubricant Burned),  Btu/gal EtOH",null,300,null,{"$f":"IF('Site-Specific Inputs'!AA33=0,0,IF('Site-Specific Inputs'!$R$33=100%,0,'EF Tables'!R$54))","v":0},null,"     Residual Oil (10% Lubricant Burned),  Btu/gal EtOH",null,300,null,{"$f":"IF('Site-Specific Inputs'!R$33=0%,0,'EF Tables'!Q54)","v":0}]
[null,null,null,"Chemicals Usage (Lime, g/tonne cane)",880,null,{"$f":"IF('Site-Specific Inputs'!AA33=0,0,IF('Site-Specific Inputs'!$R$33=100%,0,'EF Tables'!R$55))","v":0},null,null,"Chemicals Usage (Lime, g/tonne cane)",880,null,{"$f":"IFERROR(IF('Site-Specific Inputs'!R$33=0%,0,'EF Tables'!Q55),\"0.0\")","v":0}]
[null,null,null,"Chemicals Usage (Yeast, g/gal ethanol) (11)",{"$f":"D167","v":3.3432768916330025},null,{"$f":"IF('Site-Specific Inputs'!AA33=0,0,IF('Site-Specific Inputs'!$R$33=100%,0,'EF Tables'!R$56))","v":0},null,null,"Chemicals Usage (Yeast, g/gal ethanol) (11)",{"$f":"D167","v":3.3432768916330025},null,{"$f":"IFERROR(IF('Site-Specific Inputs'!R$33=0%,0,'EF Tables'!Q56),\"0.0\")","v":0}]
[null,null,"Ethanol Transport and Distribution",null,null,null,{"$f":"IF('Site-Specific Inputs'!AA33=0,0,IF('Site-Specific Inputs'!$R$33<100%,SUM('EF Tables'!P91:P95),0))","v":0},null,"Ethanol Transport and Distribution",null,null,null,{"$f":"IF('Site-Specific Inputs'!R$33=0%,0,SUM('EF Tables'!O91:O95))","v":0}]
[null,null,null,"From Ethanol Plant to Brazil Port","Mode:  HDD Truck",{"$f":"CONCATENATE('Pathway Summary'!$F$9,\" dry gals\")","v":" dry gals"},null,null,null,"From Ethanol Plant to Brazil Port","Mode:  HDD Truck",{"$f":"CONCATENATE('Pathway Summary'!$F$9,\" dry gals\")","v":" dry gals"}]
[null,null,null,"Miles",{"$f":"'Site-Specific Inputs'!$C$30/1.609","v":0},null,null,null,null,"Miles",{"$f":"'Site-Specific Inputs'!$C$30/1.609","v":0}]
[null,null,null,"From Ethanol Plant to Brazil Port or Terminal:","Mode:  Pipeline",{"$f":"CONCATENATE('Pathway Summary'!$F$9,\" dry gals\")","v":" dry gals"},null,null,null,"From Ethanol Plant to Brazil Port or Terminal:","Mode:  Pipeline",{"$f":"CONCATENATE('Pathway Summary'!$F$9,\" dry gals\")","v":" dry gals"}]
[null,null,null,"Miles",{"$f":"'Site-Specific Inputs'!$C$31/1.609","v":0},null,null,null,null,"Miles",{"$f":"'Site-Specific Inputs'!$C$31/1.609","v":0}]
[null,null,null,"From Brazil Port to Oregon Port","Mode: Ocean tanker",1,null,null,null,"From Brazil Port to Oregon Port","Mode: Ocean Tanker",1]
[null,null,null,"Miles",{"$f":"'Site-Specific Inputs'!$C$33/1.609","v":0},null,null,null,null,"Miles",{"$f":"'Site-Specific Inputs'!$C$33/1.609","v":0}]
[null,null,null,"From Oregon Port to Blending Terminal","Mode:  HDD Truck",1,null,null,null,"From Oregon Port to Blending Terminal","Mode:  HDD Truck",1]
[null,null,null,"Miles",40,null,null,null,null,"Miles",40]
[null,null,null,"Oregon Blending Terminal to Refueling Station","Mode:  HDD Truck",1,null,null,null,"Oregon Blending Terminal to Refueling Station","Mode:  HDD Truck",1]
[null,null,null,"Miles",50,null,null,null,null,"Miles",50]
[null,null,"Denaturant, g/MJ",null,null,null,{"$f":"IF('Site-Specific Inputs'!AA33=0,0,IF('Site-Specific Inputs'!$R$33=100%,0,'EF Tables'!D124))","v":0},null,"Denaturant, g/MJ",null,null,null,{"$f":"IF('Site-Specific Inputs'!AA33=0,0,IF('Site-Specific Inputs'!R$33=0%,0,'EF Tables'!C124))","v":0}]
[null,null,"Indirect Land Use, g/MJ",null,null,null,{"$f":"IF('Site-Specific Inputs'!AA33=0,0,IF('Site-Specific Inputs'!$R$33=100%,0,11.8))","v":0},"Composite CI (gCO2e/MJ)","Indirect Land Use, g/MJ",null,null,null,{"$f":"IF('Site-Specific Inputs'!AA33=0,0,IF('Site-Specific Inputs'!$R$33>0,11.8,0))","v":0}]
[null,null,"Total Well-to-Tank CI, g/MJ",null,null,null,{"$f":"IFERROR(SUM(G93:G131),0)","v":0},{"$f":"IFERROR((M132*K109+G132*E109)/(K109+E109),\"0.0\")","v":"0.0"},"Total Well-to-Tank CI, g/MJ",null,null,null,{"$f":"IF(SUM(M93:M131)>0,SUM(M93:M131),\"0.00\")","v":"0.00"}]
[]
[null,"Footnotes:"]
[null,"(1)  Filter Cake is assumed to be returned to the fields from where the sugarcane was harvested.  Hence it is the weighted average distance of all sugarcane procured from Company-owned and Partnership sugarcane farms, plus 2 miles for distribution on the farms."]
[]
[null,"(2)  The fraction of sugarcane that was mechanically harvested applies to the 9-month or 12-month annual sugarcane harvest cycle. "]
[]
[null,"(3)  The Juice-to-Sugar Share is the monthly weighted average fraction of juice that is directed to Table or Finished Sugar production.  Preferably, this is measured after the cane has been crushed, "]
[null,"      and the juice has been treated for pH and decanted.  The juice-to sugar share is then the quantity of juice sent to sugar production or factory / total juice crushed after losses (mass basis).  "]
[]
[null,"(4)  The level of sucrose in the juice is a proxy for all sugars that can be crystallized or fermented into table sugar and ethanol, respectively.  The percentage sucrose in the pre-treated juice is measured "]
[null,"       after the pH of the juice has been adjusted, the juice has been decanted, and enters the table sugar or ethanol production process.  "]
[null,"      This level of sucrose is not the same as the sucrose measured in the juice extracted immediately after the sugarcane crush (as production losses, and some dilution of the juice are expected)."]
[]
[null,"(5)  Adjusted Anhydrous and Hydrous Ethanol Production:  The anhydrous and hydrous ethanol produced is adjusted by the estimated amount of ethanol produced from externally acquired molasses.  "]
[]
[null,"(6)  Note: To calculate CI after all data entered, click \"Calculate\" button.  Else, go to the \"Data\" tab in the Excel Header above, click \"Solver\",  then click \"Solve\" and accept the dialogue box after it finds solution."]
[]
[null,"(7)  A Site-Specific fraction for Mechanized Harvesting applicable to a cluster of sugarcane farms from where cane is procured is not supported in the Tier 1 Simplified CI Calculator at this time.  "]
[]
[null,"(8)  The Net Electricity Credited to the pathway is gross amount (Field 5.7) less Transmissions & Distribution losses for Brazil (Field 1.8), and adjusted in proportion to fermentable sugars allocated to juice and molasses production."]
[]
[null,"(9)  Staff assumes that steam leaves the Steam Turbine/Generator as Saturated Steam at 150 psi (10.55 kgf/cm2, 10.2 atm, 358deg F/181deg C) "]
[null,"Enthalpy of Saturated Steam at Exit Conditions  =",null,"2,633.174 Btu/kg or 1,194.4 Btu/lb"]
[null,"Therefore, Energy Remaining in Exit Steam =",null,{"$f":"2633.174*1000","v":2633174},"Btu/metric tonne steam"]
[null,"Useful Energy  =  (LHV Bagasse - Enthalpy of Exit Steam) x Steam Boiler Efficiency  x  Power Conversion Efficiency"]
[]
[null,"(10)  The Exported Volume of anhydrous ethanol is adjusted to account for temperature correction in Oregon/U.S.A.  All liquid fuel amounts reported in the LRT-CBTS must be adjusted to standard temperature conditions adjusted to standard "]
[null,"      of 60°F using the relation   Vs,e  =  Va,e  x  (-0.0006301 x T  + 1.0378), where "]
[null,"      Vs,e is the standardized volume of ethanol at 60 °F, in gallons; and Va,e is the standardized volume of ethanol at 60 °F, in gallons; and T is the actual temperature of the batch, in °F."]
[]
[null,"(11)  Yeast usage is assumed to parallel the yeast usage for corn-derived ethanol; 0.358 kg/tonne of corn (Wang et al, 2012).*"]
[null,"*Michael Wang et al 2012 Environ. Res. Lett. 7 045905"]
[null,"Therefore, Yeast Usage is 358 g/1000 kg corn or ",null,{"$f":"1000*2.2046/56","v":39.36785714285714},"bushels of corn"]
[null,"Assuming, Corn-based ethanol yields to be ",null,2.72,"gallons per bushel corn"]
[null,"Yeast Usage  =  358 g / (3.3937 bu  x 2.72 gal / bu)  =  ",null,{"$f":"358/(D165*D166)","v":3.3432768916330025},"g yeast / gallon of ethanol."]

{"sheet":"Pathway Summary","index":3,"n_rows":51,"n_cols":18,"rows_kept":51,"cut":false,"hidden":false,"merged":[[38,1,38,12],[40,1,40,12],[1,14,1,17],[3,2,4,12],[5,1,5,12],[6,3,9,3],[6,4,6,12],[11,8,11,10],[30,1,32,1],[0,0,41,0],[0,1,0,12],[1,1,4,1],[1,2,2,12],[10,1,10,12],[11,1,11,4],[11,5,11,6],[13,1,18,1],[19,1,21,1],[23,1,28,1],[12,11,12,12],[39,1,39,12],[41,1,41,12],[35,1,35,7],[36,1,36,7],[37,1,37,7]]}
[]
[null,{"$error":"#VALUE!"},"Sugarcane Ethanol Pathway Summary"]
[]
[null,null,"FOR APPLICANT ONLY - CONTAINS CONFIDENTIAL BUSINESS INFORMATION - DO NOT DISTRIBUTE"]
[]
[]
[null,"Application #",{"$f":"IF('Site-Specific Inputs'!C3=\"\",\"\",'Site-Specific Inputs'!C3)","v":""},null,"Finished Fuel Quantities"]
[null,"Company Name and ID",{"$f":"IF('Site-Specific Inputs'!C4=\"\",\"\",CONCATENATE('Site-Specific Inputs'!C4,\" \",\"(\",'Site-Specific Inputs'!C5,\")\"))","v":""},null,"Unit","Undenatured Anhydrous Ethanol Produced","Denaturant Added","Denatured Anhydrous Ethanol Produced","Total Ethanol from Sugarcane Juice","Total Ethanol from Sugarcane Molasses","Total Ethanol Produced","Ethanol Yield from Sugarcane Juice","Ethanol Yield from Sugarcane Molasses"]
[null,"Facility Address and ID",{"$f":"IF('Site-Specific Inputs'!C6=\"\",\"\",'Site-Specific Inputs'!C6)","v":""},null,"gallons",{"$f":"IF('Site-Specific Inputs'!V$33>0,'Site-Specific Inputs'!$V$33*'OR-GREET4.0'!C102,\"\")","v":""},{"$f":"IF('EF Tables'!G114>0,'EF Tables'!G114,\"\")","v":""},{"$f":"IF(SUM(F9:G9)>0,SUM(F9:G9),\"\")","v":""},{"$f":"IF('Calculated Parameters'!G$25>0,'Calculated Parameters'!G$25,\"\")","v":""},{"$f":"IF('Calculated Parameters'!F$25>0,'Calculated Parameters'!F$25,\"\")","v":""},{"$f":"IFERROR(J9+I9,\"\")","v":""},{"$f":"IF('Calculated Parameters'!G$23>0,'Calculated Parameters'!G$23,\"\")","v":""},{"$f":"IF('Calculated Parameters'!F$23>0,'Calculated Parameters'!F$23,\"\")","v":""}]
[null,"Operational Data Period",{"$f":"IF('Site-Specific Inputs'!E9>0,CONCATENATE(TEXT(MIN('Site-Specific Inputs'!E9:E32),\"mm/yyyy\"),\" — \",TEXT(MAX('Site-Specific Inputs'!E9:E32),\"mm/yyyy\")),)","v":0},null,"MJ (LHV)",{"$f":"IFERROR(F9*'OR-GREET4.0'!$D$77,\"\")","v":""},{"$f":"IFERROR(G9*'OR-GREET4.0'!D75,\"\")","v":""},{"$f":"IF(SUM(F10:G10)>0,SUM(F10:G10),\"\")","v":""},{"$f":"IFERROR(I9*'OR-GREET4.0'!$D$77,\"\")","v":""},{"$f":"IFERROR(J9*'OR-GREET4.0'!$D$77,\"\")","v":""},{"$f":"IFERROR(K9*'OR-GREET4.0'!$D$77,\"\")","v":""},"(gallons/m.t. cane)","(gallons/m.t. cane)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NO"]
[null,"Fuel Pathway Inputs",null,null,null,"Emission Factors",null,"Emissions ","Carbon Intensity\ngCO2e/MJ d-EtOH, LHV"]
[null,"Category","Name","Value","Unit","Value","Unit","gCO2e","Sugarcane Ethanol Composite","Sugarcane Juice","Sugarcane Molasses"]
[null,"Feedstock Production","Sugarcane Farming",{"$f":"IF('Site-Specific Inputs'!J$33>0,'Site-Specific Inputs'!J$33,\"\")","v":""},"metric tons sugarcane",{"$f":"'EF Tables'!U$38","v":8306.8966630243394},"gCO2e/metric ton cane",{"$f":"IFERROR(F14*D14,\"\")","v":""},{"$f":"IFERROR((J14*'Calculated Parameters'!G$25+K14*'Calculated Parameters'!F$25)/('Calculated Parameters'!F$25+'Calculated Parameters'!G$25),\"\")","v":""},{"$f":"IFERROR(H14*(1-'Site-Specific Inputs'!R$33)/('Calculated Parameters'!G$25*'OR-GREET4.0'!D$77)*(F10/H10),\"\")","v":""},{"$f":"IFERROR(H14*'Site-Specific Inputs'!R$33*'Calculated Parameters'!G$30/('Calculated Parameters'!F$25*'OR-GREET4.0'!$D$77)*(F10/H10),\"\")","v":""}]
[null,null,"Fertilizer & Agricultural Chemicals",{"$f":"IF('Site-Specific Inputs'!J$33>0,'Site-Specific Inputs'!J$33,\"\")","v":""},"metric tons sugarcane",{"$f":"'EF Tables'!V$38","v":8163.0266073145758},"gCO2e/metric ton cane",{"$f":"IFERROR(F15*D15,\"\")","v":""},{"$f":"IFERROR((J15*'Calculated Parameters'!G$25+K15*'Calculated Parameters'!F$25)/('Calculated Parameters'!F$25+'Calculated Parameters'!G$25),\"\")","v":""},{"$f":"IFERROR(H15*(1-'Site-Specific Inputs'!R$33)/('Calculated Parameters'!G$25*'OR-GREET4.0'!D$77)*(F10/H10),\"\")","v":""},{"$f":"IFERROR(H15*'Site-Specific Inputs'!R$33*'Calculated Parameters'!G$30/('Calculated Parameters'!F$25*'OR-GREET4.0'!$D$77)*(F10/H10),\"\")","v":""}]
[null,null,"N2O from N fertilizer and Above/Below Ground Biomass",{"$f":"IF('Site-Specific Inputs'!J$33>0,'Site-Specific Inputs'!J$33,\"\")","v":""},"metric tons sugarcane",{"$f":"'EF Tables'!W$38","v":14385.15231714599},"gCO2e/metric ton cane",{"$f":"IFERROR(F16*D16,\"\")","v":""},{"$f":"IFERROR((J16*'Calculated Parameters'!G$25+K16*'Calculated Parameters'!F$25)/('Calculated Parameters'!F$25+'Calculated Parameters'!G$25),\"\")","v":""},{"$f":"IFERROR(H16*(1-'Site-Specific Inputs'!R$33)/('Calculated Parameters'!G$25*'OR-GREET4.0'!D$77)*(F10/H10),\"\")","v":""},{"$f":"IFERROR(H16*'Site-Specific Inputs'!R$33*'Calculated Parameters'!G$30/('Calculated Parameters'!F$25*'OR-GREET4.0'!$D$77)*(F10/H10),\"\")","v":""}]
[null,null,"Straw Burning in Field",{"$f":"IF('Site-Specific Inputs'!J$33>0,'Site-Specific Inputs'!J$33,\"\")","v":""},"metric tons sugarcane",{"$f":"'OR-GREET4.0'!E$30","v":17336},"gCO2e/metric ton cane",{"$f":"IFERROR(F17*D17,\"\")","v":""},{"$f":"IFERROR((J17*'Calculated Parameters'!G$25+K17*'Calculated Parameters'!F$25)/('Calculated Parameters'!F$25+'Calculated Parameters'!G$25),\"\")","v":""},{"$f":"IFERROR(H17*(1-'Site-Specific Inputs'!R$33)/('Calculated Parameters'!G$25*'OR-GREET4.0'!D$77)*(F10/H10),\"\")","v":""},{"$f":"IFERROR(H17*'Site-Specific Inputs'!R$33*'Calculated Parameters'!G$30/('Calculated Parameters'!F$25*'OR-GREET4.0'!$D$77)*(F10/H10),\"\")","v":""}]
[null,null,"Credit for Mechanized Harvesting",{"$f":"IF('Site-Specific Inputs'!J$33>0,'Site-Specific Inputs'!J$33,\"\")","v":""},"metric tons sugarcane",{"$f":"'Site-Specific Inputs'!C36","v":0.65},"Reduction in Straw Burning Emissions",{"$f":"IFERROR(-F18*H17,\"\")","v":""},{"$f":"IFERROR((J18*'Calculated Parameters'!G$25+K18*'Calculated Parameters'!F$25)/('Calculated Parameters'!F$25+'Calculated Parameters'!G$25),\"\")","v":""},{"$f":"IFERROR(H18*(1-'Site-Specific Inputs'!R$33)/('Calculated Parameters'!G$25*'OR-GREET4.0'!D$77)*(F10/H10),\"\")","v":""},{"$f":"IFERROR(H18*'Site-Specific Inputs'!R$33*'Calculated Parameters'!G$30/('Calculated Parameters'!F$25*'OR-GREET4.0'!$D$77)*(F10/H10),\"\")","v":""}]
[null,null,"Sugarcane Land Use Change",{"$f":"IFERROR(K9*'OR-GREET4.0'!D$77,\"\")","v":""},"MJ sugarcane EtOH, LHV",{"$f":"'OR-GREET4.0'!E33","v":11.8},"gCO2e/MJ sugarcane EtOH, LHV",{"$f":"IFERROR(D19*F19,\"\")","v":""},{"$f":"IFERROR((J19*'Calculated Parameters'!G$25+K19*'Calculated Parameters'!F$25)/('Calculated Parameters'!F$25+'Calculated Parameters'!G$25),\"\")","v":""},{"$f":"IFERROR(H19/K10*(F10/H10),\"\")","v":""},{"$f":"IFERROR(H19/K10*(F10/H10),\"\")","v":""},null,null,null,null,null,"gallons","MJ (LHV)"]
[null,"Feedstock Transport","Field Harvest to Stack",{"$f":"IF('Site-Specific Inputs'!J33*'OR-GREET4.0'!E$34>0,'Site-Specific Inputs'!J33*'OR-GREET4.0'!E$34,\"\")","v":""},"metric ton-miles",{"$f":"'OR-GREET4.0'!E38","v":388.3},"gCO2e/metric ton-mile",{"$f":"IFERROR(D20*F20,\"\")","v":""},{"$f":"IFERROR((J20*'Calculated Parameters'!G$25+K20*'Calculated Parameters'!F$25)/('Calculated Parameters'!F$25+'Calculated Parameters'!G$25),\"\")","v":""},{"$f":"IFERROR(H20*'OR-GREET4.0'!E$42/('Calculated Parameters'!G$25*'OR-GREET4.0'!D$77)*(F10/H10),\"\")","v":""},{"$f":"IFERROR(('Calculated Parameters'!$G$30*H20/'Site-Specific Inputs'!$J$33)/('Calculated Parameters'!E$34*'OR-GREET4.0'!C$77*'OR-GREET4.0'!H$87)*(F10/H10),\"\")","v":""}]
[null,null,"From Stack to Fuel Production Facility ",{"$f":"IFERROR('Site-Specific Inputs'!J33*('Site-Specific Inputs'!F33*'Site-Specific Inputs'!G33+'Site-Specific Inputs'!H33*'Site-Specific Inputs'!I33)/('Site-Specific Inputs'!F33+'Site-Specific Inputs'!H33)/1.609,\"\")","v":""},"metric ton-miles",{"$f":"'OR-GREET4.0'!E39","v":282.48799540421578},"gCO2e/metric ton-mile",{"$f":"IFERROR(D21*F21,\"\")","v":""},{"$f":"IFERROR((J21*'Calculated Parameters'!G$25+K21*'Calculated Parameters'!F$25)/('Calculated Parameters'!F$25+'Calculated Parameters'!G$25),\"\")","v":""},{"$f":"IFERROR(H21*'OR-GREET4.0'!E$42/('Calculated Parameters'!G$25*'OR-GREET4.0'!D$77)*(F10/H10),\"\")","v":""},{"$f":"IFERROR(('Calculated Parameters'!$G$30*H21/'Site-Specific Inputs'!$J$33)/('Calculated Parameters'!E$34*'OR-GREET4.0'!C$77*'OR-GREET4.0'!H$87)*(F10/H10),\"\")","v":""}]
[null,null,"Return of Filtercake from Fuel Production Facility to Field",{"$f":"IF('OR-GREET4.0'!E40*'Site-Specific Inputs'!J33*('Site-Specific Inputs'!K33/1.609)/1000>0,'OR-GREET4.0'!E40*'Site-Specific Inputs'!J33*('Site-Specific Inputs'!K33/1.609)/1000,\"\")","v":""},"metric ton-miles",{"$f":"'OR-GREET4.0'!E39","v":282.48799540421578},"gCO2e/metric ton-mile",{"$f":"IFERROR(D22*F22,\"\")","v":""},{"$f":"IFERROR((J22*'Calculated Parameters'!G$25+K22*'Calculated Parameters'!F$25)/('Calculated Parameters'!F$25+'Calculated Parameters'!G$25),\"\")","v":""},{"$f":"IFERROR(H22*'OR-GREET4.0'!E$42/('Calculated Parameters'!G$25*'OR-GREET4.0'!D$77)*(F10/H10),\"\")","v":""},{"$f":"IFERROR(('Calculated Parameters'!$G$30*H22/'Site-Specific Inputs'!$J$33)/('Calculated Parameters'!E$34*'OR-GREET4.0'!C$77*'OR-GREET4.0'!H$87)*(F10/H10),\"\")","v":""}]
[null,"Molasses Production","Finished (Table Sugar Production)",{"$f":"'OR-GREET4.0'!E$43","v":4078.48},"gCO2e/metric tons cane",{"$f":"D23*'Site-Specific Inputs'!J33*'Site-Specific Inputs'!R33","v":0},"gCO2e (Sugar Production)",{"$f":"IF(F23*'Calculated Parameters'!G30>0,F23*'Calculated Parameters'!G30,\"\")","v":""},{"$f":"IFERROR((J23*'Calculated Parameters'!G$25+K23*'Calculated Parameters'!F$25)/('Calculated Parameters'!F$25+'Calculated Parameters'!G$25),\"\")","v":""},null,{"$f":"IFERROR(H23/J10*(F10/H10),\"\")","v":""}]
[null,"Ethanol Production","Biomass Generated",{"$f":"IF('Site-Specific Inputs'!J33*'OR-GREET4.0'!E45*(1-'OR-GREET4.0'!E46)>0,'Site-Specific Inputs'!J33*'OR-GREET4.0'!E45*(1-'OR-GREET4.0'!E46),\"\")","v":""},"dry metric tons",{"$f":"('OR-GREET4.0'!E44/10^6)*('OR-GREET4.0'!E49*'OR-GREET4.0'!K73+'OR-GREET4.0'!K74*'OR-GREET4.0'!E50+'OR-GREET4.0'!E51*'OR-GREET4.0'!K75+'OR-GREET4.0'!K76*'OR-GREET4.0'!E52)","v":33327.87379533959},"gCO2e/dry metric tons",{"$f":"IFERROR(D24*F24,\"\")","v":""},{"$f":"IFERROR((J24*'Calculated Parameters'!G$25+K24*'Calculated Parameters'!F$25)/('Calculated Parameters'!F$25+'Calculated Parameters'!G$25),\"\")","v":""},{"$f":"IFERROR(H24*'OR-GREET4.0'!E42/I10*(F10/H10),\"\")","v":""},{"$f":"IFERROR(H24*(1-'OR-GREET4.0'!E42)*'Calculated Parameters'!G30/J10*(F10/H10),\"\")","v":""}]
[null,null,"Grid Electricity Purchased",{"$f":"IF('Site-Specific Inputs'!P33>0,'Site-Specific Inputs'!P33,\"\")","v":""},null,{"$f":"'OR-GREET4.0'!E56","v":110.5727335921882},"gCO2e/kWh","",{"$f":"IFERROR((J25*'Calculated Parameters'!G$25+K25*'Calculated Parameters'!F$25)/('Calculated Parameters'!F$25+'Calculated Parameters'!G$25),\"\")","v":""},{"$f":"IFERROR(H25*'OR-GREET4.0'!E42/'Pathway Summary'!I10*(F10/H10),\"\")","v":""},{"$f":"IFERROR(H25*'Site-Specific Inputs'!R33*'Calculated Parameters'!G30/'Pathway Summary'!J10*(F10/H10),\"\")","v":""}]
[null,null,"Chemical Use (Lime)",{"$f":"K$9","v":""},"total gal Ethanol ",{"$f":"IF('OR-GREET4.0'!E$54>0,'OR-GREET4.0'!E$54,\"\")","v":37.258229999999998},"gCO2e/gal Ethanol ",{"$f":"IFERROR(F26*D26,\"\")","v":""},{"$f":"IFERROR((J26*'Calculated Parameters'!G$25+K26*'Calculated Parameters'!F$25)/('Calculated Parameters'!F$25+'Calculated Parameters'!G$25),\"\")","v":""},{"$f":"IFERROR(F26*I$9/I$10*(F10/H10),\"\")","v":""},{"$f":"IFERROR(F26*J$9/J$10*(F10/H10),\"\")","v":""}]
[null,null,"Process Fuel (Residual Oil)",{"$f":"K$9","v":""},"total gal Ethanol ",{"$f":"IF('OR-GREET4.0'!E53>0,'OR-GREET4.0'!E$53,\"\")","v":2.96854},"gCO2e/gal Ethanol",{"$f":"IFERROR(F27*D27,\"\")","v":""},{"$f":"IFERROR((J27*'Calculated Parameters'!G$25+K27*'Calculated Parameters'!F$25)/('Calculated Parameters'!F$25+'Calculated Parameters'!G$25),\"\")","v":""},{"$f":"IFERROR(F27*I$9/I$10*(F10/H10),\"\")","v":""},{"$f":"IFERROR(F27*J$9/J$10*(F10/H10),\"\")","v":""}]
[null,null,"Chemical Use (Yeast)",{"$f":"K$9","v":""},"total gal Ethanol ",{"$f":"IF('OR-GREET4.0'!E$55>0,'OR-GREET4.0'!E$55,\"\")","v":7.7611325000000004},"gCO2e/gal Ethanol","",{"$f":"IFERROR((J28*'Calculated Parameters'!G$25+K28*'Calculated Parameters'!F$25)/('Calculated Parameters'!F$25+'Calculated Parameters'!G$25),\"\")","v":""},{"$f":"IFERROR(F28*I$9/I$10*(F10/H10),\"\")","v":""},{"$f":"IFERROR(F28*J$9/J$10*(F10/H10),\"\")","v":""}]
[null,null,"Evaporative Emissions (Non-Combustive )",{"$f":"IFERROR(H$10,\"\")","v":""},"MJ denatured-EtOH",8.6694746909554699E-2,"gCO2e/MJ d-EtOH","",{"$f":"IFERROR(H29/H10,\"\")","v":""},{"$f":"IFERROR(H29/H10,\"\")","v":""},{"$f":"IFERROR(H29/H10,\"\")","v":""}]
[null,"Co-Product Credit","Surplus Cogenerated Electricity Export Credit",{"$f":"IF('EF Tables'!F$75>0,'EF Tables'!F$75,\"\")","v":""},"Net KWh Credited",{"$f":"IF('Site-Specific Inputs'!C26=\"Brazil\",'OR-GREET4.0'!E56,'Site-Specific Inputs'!C27)","v":110.5727335921882},"gCO2e/kWh Electricity Exported ","",{"$f":"IFERROR((J30*'Calculated Parameters'!G$25+K30*'Calculated Parameters'!F$25)/('Calculated Parameters'!F$25+'Calculated Parameters'!G$25),\"\")","v":""},{"$f":"IFERROR(-H$30/($K$9*'OR-GREET4.0'!$D$77)*(F10/H10),\"\")","v":""},{"$f":"IFERROR(-H$30/($K$9*'OR-GREET4.0'!$D$77)*(F10/H10),\"\")","v":""}]
[null,"Finished Fuel Transport","Truck Transport to Port / Terminal",{"$f":"IFERROR(('Site-Specific Inputs'!C30/1.609)*F$9,\"\")","v":""},"gallon-miles",{"$f":"'OR-GREET4.0'!E60","v":0.57399999999999995},"gCO2e/gal-mile","",{"$f":"IFERROR(H31/H10,\"\")","v":""},{"$f":"IFERROR(H31/H10,\"\")","v":""},{"$f":"IFERROR(H31/H10,\"\")","v":""}]
[null,null,"Pipeline Transport to Terminal",{"$f":"IFERROR(('Site-Specific Inputs'!C31/1.609)*F$9,\"\")","v":""},"gallon-miles",{"$f":"'OR-GREET4.0'!E61","v":4.6100000000000002E-2},"gCO2e/gal-mile","",{"$f":"IFERROR(H32/H10,\"\")","v":""},{"$f":"IFERROR(H32/H10,\"\")","v":""},{"$f":"IFERROR(H32/H10,\"\")","v":""}]
[null,null,"Ocean Transport to Oregon Port",{"$f":"IFERROR(('Site-Specific Inputs'!C$33/1.609)*F$9,\"\")","v":""},"gallon-miles",6.0782642925416429E-2,"gCO2e/gal-mile",{"$f":"IFERROR(D$33*F$33,\"\")","v":""},{"$f":"IFERROR(H33/H10,\"\")","v":""},{"$f":"IFERROR(H33/H10,\"\")","v":""},{"$f":"IFERROR(H33/H10,\"\")","v":""}]
[null,"Oregon Port","Denaturant Added",{"$f":"IF(G$10>0,G$10,\"\")","v":""},"MJ, LHV",{"$f":"'OR-GREET4.0'!H75","v":97.91},"gCO2e/MJ (LHV)",{"$f":"IFERROR(D34*F34,\"\")","v":""},{"$f":"IFERROR(H34/H10,\"\")","v":""},{"$f":"IFERROR(H34/H10,\"\")","v":""},{"$f":"IFERROR(H34/H10,\"\")","v":""}]
[null,"Finished Fuel Transport in Oregon","Oregon Port to Refueling Stations ",{"$f":"IFERROR(('OR-GREET4.0'!E64)*H$9,\"\")","v":""},"gallon-miles",{"$f":"'OR-GREET4.0'!E63","v":0.57399999999999995},"gCO2e/gal-mile",{"$f":"IFERROR(D35*F35,\"\")","v":""},{"$f":"IFERROR(H35/H10,\"\")","v":""},{"$f":"IFERROR(H35/H10,\"\")","v":""},{"$f":"IFERROR(H$35/H$10,\"\")","v":""}]
[null,"Fuel Pathway Carbon Intensity (gCO2e/MJ Denatured Ethanol, LHV)",null,null,null,null,null,null,{"$f":"IFERROR(('Pathway Summary'!K36*'Pathway Summary'!J10+'Pathway Summary'!J36*'Pathway Summary'!I10)/('Pathway Summary'!J10+'Pathway Summary'!I10),\"0.00\")","v":"0.00"},{"$f":"IFERROR(SUM(J14:J35),\"0.00\")","v":0},{"$f":"IFERROR(SUM(K14:K35),\"0.00\")","v":0}]
[null,"Margin of Safety (entered by applicant)"]
[null,"Certified Fuel Pathway Composite Carbon Intensity (gCO2e/MJ Denatured Ethanol, LHV)",null,null,null,null,null,null,{"$f":"IF((I36+I37)>0,(I36+I37),\"\")","v":""},null,null,null,{"$f":"IFERROR(#REF!+#REF!,\"\")","v":""}]
[]
[null,"Operating Conditions"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"`"]

{"sheet":"OR-GREET4.0","index":4,"n_rows":138,"n_cols":11,"rows_kept":138,"cut":false,"hidden":false,"merged":[[4,8,4,9],[9,8,9,9],[32,8,32,9],[33,8,33,9],[34,8,34,9],[76,9,76,10],[80,1,80,7],[82,1,82,8],[103,1,103,6],[105,1,105,8],[70,1,70,7],[70,9,70,10],[71,1,72,1],[71,2,71,4],[71,5,72,5],[71,6,73,6],[71,7,72,7],[72,2,72,3],[43,1,58,1],[43,2,52,2],[59,1,64,1],[59,2,64,2],[53,2,54,2],[56,2,57,2],[0,6,0,7],[3,2,9,2],[10,2,23,2],[24,2,25,2],[3,1,32,1],[1,1,1,5],[39,1,40,1],[34,2,35,2],[37,2,38,2],[26,2,29,2],[30,2,31,2],[39,2,40,2],[33,1,38,1]]}
[]
[null,"Tier 1 Sugarcane-derived Ethanol Calculator Inputs and Emission Factors"]
[null,"Category","Sub-Category","Name","Value","Unit"]
[null,"Feedstock Production","Farming","Total Farming Energy",93900,"Btu/tonne sugarcane"]
[null,null,null,"Individual Fuel Shares"]
[null,null,null,"Diesel Fuel",36385,"Btu/tonne sugarcane"]
[null,null,null,"Gasoline",11685,"Btu/tonne sugarcane"]
[null,null,null,"Natural Gas",19324,"Btu/tonne sugarcane"]
[null,null,null,"Liquefied Petroleum Gas",17956,"Btu/tonne sugarcane"]
[null,null,null,"Electricity",8550,"Btu/tonne sugarcane"]
[null,null,"Fertilizers and Pesticides","Fertilizer Use at",0.8,"Mechanized Harvesting Level"]
[null,null,null,"Nitrogen",996,"(g / tonne)"]
[null,null,null,"P2O5",317,"(g / tonne)"]
[null,null,null,"K2O",1371.28,"(g / tonne)"]
[null,null,null,"CaCO3",5200,"(g / tonne)"]
[null,null,null,"Herbicide",45,"(g / tonne)"]
[null,null,null,"Pesticide",2.5,"(g / tonne)"]
[null,null,null,"Fertilizer Use at",0.65,"Mechanized Harvesting Level"]
[null,null,null,"Nitrogen",1119,"(g / tonne)"]
[null,null,null,"P2O5",311,"(g / tonne)"]
[null,null,null,"K2O",1237,"(g / tonne)"]
[null,null,null,"CaCO3",5200,"(g / tonne)"]
[null,null,null,"Herbicide",45,"(g / tonne)"]
[null,null,null,"Pesticide",3,"(g / tonne)"]
[null,null,"N2O in soil","N in N2O as % of N in N fertilizer ",1.325E-2,"IPCC Tier 1;"]
[null,null,null,"N in N2O as % of N in biomass",1.225E-2,"IPCC Tier 1;"]
[null,null,"Field Straw Burning","Straw Yield",0.23799999999999999," dry tonne/wet tonne of sugarcane"]
[null,null,null,"Moisture in straw",0.15]
[null,null,null,"Fraction of Straw Burnt in Field, %",0.9]
[null,null,null,"Straw Burning Emissions Factor",17336,"gCO2e/tonne cane"]
[null,null,"Mechanized Harvesting Credit","Standard (Sao Paulo State)",0.8]
[null,null,null," Non-Sao Paulo States",0.65]
[null,null,"Land Use Change","Sugarcane",11.8,"gCO2e/MJ Ethanol "]
[null,"Feedstock Transport","Field to Stack Transport Distance (Standard)","Field Sugarcane Collection to Stack, MDT",2,"miles"]
[null,null,"Stack to Fuel Production Facility Distance","Applicant-Owned Farms (Propria) ",{"$f":"'Site-Specific Inputs'!G$33/1.609","v":0},"weighted average distance (miles)"]
[null,null,null,"Partnership Farms (Terceiros) ",{"$f":"'Site-Specific Inputs'!I33/1.609","v":0},"weighted average distance (miles)"]
[null,null,"Sugarcane Transport ","Transport Loss Factor",1.0204,"%W/%W"]
[null,null,"Transport Emissions","Medium Heavy-Duty Truck ",388.3,"gCO2e/tonne-mile"]
[null,null,null,"Heavy Heavy-Duty Truck",282.48799540421578,"gCO2e/tonne-mile"]
[null,"Return of Filtercake to Field","Filtercake Transport","Filter Cake Yield and Application Rate",2.87,"kg/metric tonne cane"]
[null,null,null,"From Fuel Production Facility to Farms",{"$f":"'Site-Specific Inputs'!K33","v":"0.0"},"weighted average distance (miles)"]
[null,"Mass Allocation of Juice","Juice Share for Ethanol Plant ","Juice Allocated for Fermentation",{"$f":"1-'Site-Specific Inputs'!R33","v":1},"mass fraction of sugarcane for ethanol"]
[null,"Finished (Table) Sugar Production","Total Production Emissions","Production Emissions",4078.48,"gCO2e/wet tonne cane"]
[null,"Fuel Production","Process Fuel","Sugarcane bagasse",13648337," Btu/metric tonne"]
[null,null,null,"Bagasse yield",0.28000000000000003,"wet tonne per wet tonne of sugarcane"]
[null,null,null,"Moisture in bagasse",0.5,"%"]
[null,null,null,"Steam generation efficiency",0.8,"%"]
[null,null,null,"Power Generation Efficiency",0.3,"%"]
[null,null,null,"CH4 Emissions Factor",31.65,"g/mmBtu of fuel combusted"]
[null,null,null,"N2O Emissions Factor",4.22,"g/mmBtu of fuel combusted"]
[null,null,null,"VOC Emissions Factor",28.31,"g/mmBtu of fuel combusted"]
[null,null,null,"CO Emissions Factor",194,"g/mmBtu of fuel combusted"]
[null,null,null,"Residual Oil Use",2.96854,"gCO2e/gal EtOH"]
[null,null,"Chemicals and Enzymes","Chemicals - Lime Use",37.258229999999998,"gCO2e/gal ethanol"]
[null,null,null,"Yeast Use",7.7611325000000004,"gCO2e/gal Ethanol"]
[null,null,"Grid Electricity / Displaced Electricity","Grid Electricity CI",110.5727335921882,"gCO2e/kWh purchased or displaced"]
[null,null,"Coproducts","Electric Transmission & Distribution Losses",8.1000000000000003E-2]
[null,null,null,"Surplus Cogenerated Electricity Exported",110.5727335921882,"gCO2e/kWh"]
[null,null,"Denaturant","Default Blend Value",2.5000000000000001E-2,"%V/%V"]
[null,"Undenatured and Denatured Ethanol Transport","Fuel Production Facility to Refueling Station in Oregon","Heavy Heavy-Duty Truck Transport in Brazil",0.57399999999999995,"gCO2e/gal-mile"]
[null,null,null,"Pipeline to Port Terminal",4.6100000000000002E-2,"gCO2e/gal-mile"]
[null,null,null,"Ocean Tanker to Oregon Port",6.08E-2,"gCO2e/gal-mile"]
[null,null,null,"Heavy Heavy-Duty Truck in Oregon",0.57399999999999995,"gCO2e/gal-mile"]
[null,null,null,"Standard Distance",90,"miles"]
[null,null,null,"Loss Factor",1.0004999999999999,"%V/%V"]
[null,"Tailpipe Emissions","Non-CO2 Combustion Emissions","Standard Value",0,"gCO2e/gal Ethanol"]
[]
[]
[null,"Fuel Specifications, Unit Conversion, eGRID Emission Factors and GWP Values"]
[]
[null,"Fuel Specifications",null,null,null,null,null,null,null,"Global Warming Potentials (CO2e)"]
[null,null,"Heating Value",null,null,"Density","LHV/HHV","Lookup Table Carbon Intensity",null,"CO2",1]
[null,null,"LHV",null,"HHV",null,null,null,null,"CH4",25]
[null,"Liquid Fuels","BTU/gal","MJ/gal","BTU/gal","grams/gal",null,"gCO2e/MJ",null,"N2O",298]
[null,"CBOB",116090,122.48,124340,2767,0.93400000000000005,97.91,null,"VOC",3.1166666666666667]
[null,"Low-sulfur diesel",127453,134.47,136314,3142,0.93500000000000005,104.92,null,"CO",1.5714285714285714]
[null,"Ethanol",76330,80.53,84530,2988,0.90299302022950434,null,null,"Source: 'Fuel_Specs' worksheet, OR-GREET4.0"]
[null,"Gaseous Fuels (at 60F and 1atm)","BTU/ft3","MJ/ft3","BTU/ft3","grams/ft3","LHV/HHV","CI (gCO2e/MJ)"]
[null,"Natural gas",930,{"$f":"C79*H87","v":0.98120194049999987},1030,20.8,{"$f":"C79/E79","v":0.90291262135922334},71.556165719999996]
[null,"Methane",910,{"$f":"C80*H87","v":0.96010082349999992},1010,19.2,{"$f":"C80/E80","v":0.90099009900990101}]
[null,"Source: 'Fuel_Specs' worksheet, OR-GREET4.0"]
[]
[null,"Unit Conversion"]
[null,"Energy","1 J","1kJ","1 MJ","1Wh","1 kWh","1 BTU","1 MMBtu"]
[null,"J",1,1000,1000000,3600,3600000,1055.05585,1055055850]
[null,"kJ",1E-3,1,1000,3.6,3600,1.05505585,1055055.8500000001]
[null,"MJ",9.9999999999999995E-7,1E-3,1,3.5999999999999999E-3,3.6,1.0550558499999999E-3,1055.05585]
[null,"Wh",2.7777777777777778E-4,0.27777777777777779,277.77777777777777,1,1000,0.29307106944444444,293071.06944444444]
[null,"kWh",2.7777777777777776E-7,2.7777777777777778E-4,0.27777777777777779,1E-3,1,2.9307106944444444E-4,293.07106944444445]
[null,"BTU",9.4781712266701337E-4,0.94781712266701335,947.81712266701334,3.4121416416012482,3412.141641601248,1,1000000]
[null,"MMBtu",9.4781712266701324E-10,9.4781712266701337E-7,9.4781712266701326E-4,3.4121416416012478E-6,3.4121416416012479E-3,9.9999999999999995E-7,1]
[null,"Mass","1 g","1 kg","1 metric ton","1 lb","1 short ton"]
[null,"g",1,1000,1000000,453.59237000000002,907184.74]
[null,"kg",1E-3,1,1000,0.45359237000000002,907.18474000000003]
[null,"metric ton",9.9999999999999995E-7,1E-3,1,4.5359237000000004E-4,0.90718474000000004]
[null,"lb",2.2046226218487759E-3,2.2046226218487757,2204.6226218487759,1,2000]
[null,"short ton",1.102311310924388E-6,1.1023113109243879E-3,1.1023113109243878,5.0000000000000001E-4,1]
[null,"Volume","1 m3","1 ml","1 L","1 gal","1 ft3"]
[null,"m3",1,9.9999999999999995E-7,1E-3,3.7854109999999998E-3,2.8316846999999999E-2]
[null,"ml",1000000,1,1000.0000000000001,3785.4110000000001,28316.847000000002]
[null,"L",1000,1E-3,1,3.7854109999999999,28.316846999999999]
[null,"gal",264.17210707106841,2.6417210707106839E-4,0.26417210707106842,1,7.4805211375990615]
[null,"ft3",35.314666212661322,3.5314666212661319E-5,3.5314666212661321E-2,0.13368052594273649,1]
[null,"Source: 'Fuel_Specs' worksheet, OR-GREET4.0"]
[]
[null,"Grid Electricity EF (gCO2e/kWh)"]
[]
[null,"ORMX",403.07602628539564]
[null,"AKMS",305.05954532367315]
[null,"AZNM",452.59799644549014]
[null,"Brazil",110.5727335921882]
[null,"CAMX",329.31550896542888]
[null,"Canada",142.58733454776279]
[null,"ERCT",470.46037472212373]
[null,"FRCC",500.08978131814308]
[null,"HIMS",729.76964401039049]
[null,"HIOA",993.04090753329433]
[null,"MROE",835.17296460818841]
[null,"MROW",522.27552659353967]
[null,"NEWE",343.93337546212689]
[null,"NWPP",341.73208620640725]
[null,"NYCW",522.5910041112935]
[null,"AKGD",739.37369659441038]
[null,"NYUP",153.92030405584592]
[null,"PRMS",864.84803647299793]
[null,"RFCE",403.02327991490318]
[null,"RFCM",647.65601416559605]
[null,"RFCW",571.73848830541249]
[null,"RMPA",581.24471143848814]
[null,"SPNO",518.57796111835]
[null,"SPSO",538.18467102575312]
[null,"SRMV",480.14759046268892]
[null,"SRMW",820.12969419368847]
[null,"SRSO",508.71583031653392]
[null,"SRTV",503.56199416646967]
[null,"SRVC",370.78940202248185]
[null,"User Defined",{"$f":"IF('Site-Specific Inputs'!C26=\"User Defined\",'Site-Specific Inputs'!C27,\"Not Permitted\")","v":"Not Permitted"}]
[null,"Source: https://www.epa.gov/egrid"]

{"sheet":"EF Tables","index":5,"n_rows":185,"n_cols":23,"rows_kept":185,"cut":false,"hidden":true,"merged":[[29,3,29,8],[43,1,43,2],[59,1,59,2],[31,9,31,12],[42,16,42,17],[52,16,52,17],[31,16,31,17],[27,16,27,17],[69,16,69,17],[57,16,57,17],[33,16,33,17],[35,16,35,17],[37,16,37,17],[39,16,39,17],[154,5,154,9],[106,9,106,10],[125,5,125,7],[4,2,4,6],[5,2,6,2],[5,3,6,3],[5,4,7,4],[5,5,7,5],[5,6,7,6],[5,7,7,7],[17,4,19,4],[16,2,16,3],[17,2,18,2],[17,3,19,3],[17,5,18,5],[24,7,24,8],[30,19,30,22],[159,7,160,7],[119,1,120,1],[86,21,86,26],[86,18,86,20],[84,18,84,19],[89,16,89,17],[158,8,158,13],[158,1,158,6],[89,14,89,15],[98,1,98,5],[87,1,88,1],[89,2,89,10],[86,2,86,10],[142,8,142,9],[155,10,155,11],[119,2,119,3],[129,1,129,3],[128,1,128,3],[46,16,46,17],[49,16,49,17],[47,2,47,7],[115,8,115,10]]}
["References for Sugarcane Ethanol Pathways (HIDE SHEET)"]
[]
["I.","Factors for Sugarcane Transport to Mill"]
[]
[null,null,"Sugarcane Transport to Mill"]
[null,null,"HDD (grams/ton-mile cane transported)","MDD (grams/ton-mile cane transported)","HDD (grams/tonne cane transported)","MDD (grams/tonne cane transported)","Total (grams/tonne cane transported)","Total (gCO2e/tonne cane transported)"]
[]
[null,null,{"$f":"IFERROR((SUMPRODUCT('Site-Specific Inputs'!F9:F32,'Site-Specific Inputs'!G9:G32)+SUMPRODUCT('Site-Specific Inputs'!H9:H32,'Site-Specific Inputs'!I9:I32))/(SUM('Site-Specific Inputs'!F9:F32)+SUM('Site-Specific Inputs'!H9:H32))/1.609,0)","v":0},2]
[null,"              VOC",7.4692232219487203E-2,0.13450006050928978,{"$f":"C$8*C9*1000/(2000*0.4536)","v":0},{"$f":"$D$8*D9*1000/(2000*0.4536)","v":0.29651688824799338},{"$f":"F9+E9","v":0.29651688824799338},{"$f":"G9*'Old Fuel_Specs'!D58","v":0.92414430170624606},null,null,"GWP"]
[null,"              CO",0.25974062687574484,0.46746395261846391,{"$f":"C$8*C10*1000/(2000*0.4536)","v":0},{"$f":"$D$8*D10*1000/(2000*0.4536)","v":1.0305642694410579},{"$f":"F10+E10","v":1.0305642694410579},{"$f":"G10*'Old Fuel_Specs'!D59","v":1.619458137693091},null,"     VOC",{"$f":"'Old Fuel_Specs'!D58","v":3.1166666666666667}]
[null,"              CH4",0.46371655906083331,0.83702080652373223,{"$f":"C8*C11*1000/(2000*0.4536)","v":0},{"$f":"$D$8*D11*1000/(2000*0.4536)","v":1.8452839649994095},{"$f":"F11+E11","v":1.8452839649994095},{"$f":"G11*25","v":46.132099124985238},null,"     CO",{"$f":"'Old Fuel_Specs'!D59","v":1.5714285714285714}]
[null,"              N2O",1.0481701204258615E-3,1.8910417671681749E-3,{"$f":"C8*C12*1000/(2000*0.4536)","v":0},{"$f":"$D$8*D12*1000/(2000*0.4536)","v":4.1689633314995036E-3},{"$f":"F12+E12","v":4.1689633314995036E-3},{"$f":"G12*298","v":1.2423510727868521},null,"     CH4",25]
[null,"              CO2",189.01416468414587,341.36016284200048,{"$f":"C8*C13*1000/(2000*0.4536)","v":0},{"$f":"$D$8*D13*1000/(2000*0.4536)","v":752.55767822310509},{"$f":"F13+E13","v":752.55767822310509},{"$f":"G13","v":752.55767822310509},null,"     N2O",298]
[null,null,null,null,null,null,"Total CO2e/tonne cane",{"$f":"SUM(H9:H13)","v":802.47573086027649}]
[null,null,null,null,null,null,"Total CO2e/MJ (mol feedstock)",{"$f":"IFERROR('Calculated Parameters'!G30*H14/('Calculated Parameters'!E34*76330*1055.06/10^6),0)","v":0}]
["II.","Factors for Filtercake Transport to Fields",null,null,null,null,"Total CO2e/MJ  (cane juice feedstock)",{"$f":"IFERROR(H14/('Calculated Parameters'!C34*76330*1055.06/10^6),0)","v":0}]
[null,"Filtercake Application Rate","Filtercake Transport to the Cane Fields"]
[null,2.87,"HDD (grams/ton-mile cane transported)","HDD (grams/tonne cane transported)","Total (gCO2e/tonne cane transported)","HDD (grams/tonne-mile cane transported)"]
[null,"(kg/MT Cane)"]
[null,null,{"$f":"C8+D8","v":2}]
[null,"              VOC",7.4692232219487203E-2,{"$f":"(B$18/1000)*$C$20*C21*1000/(2000*0.4536)","v":4.7258974089490357E-4},{"$f":"D21*K10","v":1.4729046924557827E-3},{"$f":"C21*2204.6/2000","v":8.2333247575540738E-2}]
[null,"              CO",0.25974062687574484,{"$f":"(B$18/1000)*$C$20*C22*1000/(2000*0.4536)","v":1.643420633010114E-3},{"$f":"D22*K11","v":2.582518137587322E-3},{"$f":"C22*2204.6/2000","v":0.28631209300513355}]
[null,"              CH4",0.46371655906083331,{"$f":"(B$18/1000)*$C$20*C23*1000/(2000*0.4536)","v":2.9340090928231736E-3},{"$f":"D23*25","v":7.3350227320579345E-2},0.51115476305275653]
[null,"              N2O",1.0481701204258615E-3,{"$f":"(B$18/1000)*$C$20*C24*1000/(2000*0.4536)","v":6.6319405767685678E-6},{"$f":"D24*298","v":1.9763182918770333E-3},1.155397923745427E-3]
[null,"              CO2",189.01416468414587,{"$f":"(B$18/1000)*$C$20*C25*1000/(2000*0.4536)","v":1.1959229555632687},{"$f":"D25","v":1.1959229555632687},208.35031373133396,null,"\"EF\""]
[null,null,null,null,{"$f":"SUM(E21:E25)","v":1.2753049240057681},"Total CO2e/tonne cane",null,{"$f":"E26+H14","v":803.75103578428229},"gCO2e/tonne"]
[null,null,null,null,{"$f":"IFERROR('Calculated Parameters'!$G$30*E26/('Calculated Parameters'!E$34*76330*1055.06/10^6),0)","v":0},"Total CO2e/MJ (mol feedstock)",null,{"$f":"C8+D8","v":2},"miles total transport"]
[null,null,null,null,{"$f":"IFERROR(E26/('Calculated Parameters'!C$34*76330*1055.06/10^6),0)","v":0},"Total CO2e/MJ (cane juice feedstock)",null,{"$f":"H26/H27","v":401.87551789214115},"gCO2e/tonne-mile",null,null,null,null,null,null,null,"AGGREGATION WORK AREA"]
["III.","Factors for Sugarcane Farming, Fertilizer, Herbicide/Insecticide Use, and Sugarcane/Filtercake Transport, and Harvesting.",null,null,null,null,null,null,null,null,"Applicable Fraction"]
[null,null,null,"Sugarcane Farming, Fertilizer, and Herbicide/Insecticide Use (grams/tonne cane)",null,null,null,null,null,null,{"$f":"'Site-Specific Inputs'!$C$36","v":0.65},null,null,null,null,null,"Molasses CI   (g CO2/MJ)   ","Juice-to-Ethanol CI                           (gCO2e/MJ)"]
[null,null,"Sugarcane Farming*","Nitrogen","P2O5","K2O","CaCO3","Herbicide","Insecticide","Sugarcane Straw Field Burning","Mechanized Harvesting","Sugarcane Transportation","Sugarcane Filtercake Transportation","Feedstock Total (g/tonne)",null,null,null,null,null,"Disaggregated Impacts of Sugarcane Agriculture and Farming "]
[null,"Total Emissions: grams/mmBtu of fuel throughput, except as noted","Per tonne",{"$f":"IF('OR-GREET4.0'!$E$31=80%,'EF Tables'!B161,'EF Tables'!I161)","v":995.8},{"$f":"IF('OR-GREET4.0'!$E$31=80%,'EF Tables'!C161,'EF Tables'!J161)","v":317.32639999999998},{"$f":"IF('OR-GREET4.0'!$E$31=80%,'EF Tables'!D161,'EF Tables'!K161)","v":1371.2800000000002},5200,45,2.5,"Per tonne",null,null,null,null,null,null,"Sugarcane Farming",null,null,null,"Cane Farming Only ","Fertilizer, and Herbicide / Insecticide Only Total (g/tonne)","N2O in Soil"]
[null,"     VOC",10.422054469930288,{"$f":"IF('OR-GREET4.0'!$E$31=80%,'EF Tables'!B162,'EF Tables'!I162)","v":6.5274987328704572},{"$f":"IF('OR-GREET4.0'!$E$31=80%,'EF Tables'!C162,'EF Tables'!J162)","v":8.4559716784210731E-2},{"$f":"IF('OR-GREET4.0'!$E$31=80%,'EF Tables'!D162,'EF Tables'!K162)","v":0.12907929955928368},2.1601620825538296E-2,9.0645915510573896E-2,6.0164466504487781E-3,1499.4000000000003,{"$f":"IF(K$30=\"\",\"0\",-J33*$K$30)","v":-974.61000000000024},{"$f":"G9","v":0.29651688824799338},{"$f":"D21","v":4.7258974089490357E-4},{"$f":"SUM(C33:M33)","v":542.36844568011975},null,null,{"$f":"IFERROR(U39,0)","v":"-"},{"$f":"IFERROR(U40,0)","v":"-"},null,"     VOC",{"$f":"(C33)","v":10.422054469930288},{"$f":"SUM(D33:I33)","v":6.8594017322005136},{"$f":"\"-\"","v":"-"}]
[null,"     CO",89.462591301913264,{"$f":"IF('OR-GREET4.0'!$E$31=80%,'EF Tables'!B163,'EF Tables'!I163)","v":7.4268370136333539},{"$f":"IF('OR-GREET4.0'!$E$31=80%,'EF Tables'!C163,'EF Tables'!J163)","v":0.29203537828204451},{"$f":"IF('OR-GREET4.0'!$E$31=80%,'EF Tables'!D163,'EF Tables'!K163)","v":0.6598283307788132},6.7691478327730759E-2,0.60890024007568,5.6644478013006386E-2,19706.400000000001,-12809.160000000002,{"$f":"G10","v":1.0305642694410579},{"$f":"D22","v":1.643420633010114E-3},{"$f":"SUM(C34:M34)","v":6996.8467359110964},null,null,"Fertilizer, and Herbicide/Insecticide Use",null,null,"     CO",{"$f":"C34","v":89.462591301913264},{"$f":"SUM(D34:I34)","v":9.1119369191106276},{"$f":"\"-\"","v":"-"}]
[null,"     CH4",26.843955459841467,{"$f":"IF('OR-GREET4.0'!$E$31=80%,'EF Tables'!B164,'EF Tables'!I164)","v":30.271724752940987},{"$f":"IF('OR-GREET4.0'!$E$31=80%,'EF Tables'!C164,'EF Tables'!J164)","v":0.50069505703710349},{"$f":"IF('OR-GREET4.0'!$E$31=80%,'EF Tables'!D164,'EF Tables'!K164)","v":1.2791465052048252},0.23384721567894584,1.6117190426016517,0.10760505321108269,578.34,-375.92100000000005,{"$f":"G11","v":1.8452839649994095},{"$f":"D23","v":2.9340090928231736E-3},{"$f":"SUM(C35:M35)","v":265.11591106060825},null,null,{"$f":"IFERROR('Calculated Parameters'!G30*$V$38/('Calculated Parameters'!F23*76330*1055.06/10^6),0)","v":0},{"$f":"IFERROR($V$38/('Calculated Parameters'!G23*76330*1055.06/10^6),0)","v":0},null,"     CH4",{"$f":"C35","v":26.843955459841467},{"$f":"SUM(D35:I35)","v":34.004737626674597},"-"]
[null,"     N2O",0.255953688148156,{"$f":"IF('OR-GREET4.0'!$E$31=80%,'EF Tables'!B165,'EF Tables'!I165)","v":4.0357816737929983},{"$f":"IF('OR-GREET4.0'!$E$31=80%,'EF Tables'!C165,'EF Tables'!J165)","v":5.2509366571280068E-3},{"$f":"IF('OR-GREET4.0'!$E$31=80%,'EF Tables'!D165,'EF Tables'!K165)","v":1.3616863343370889E-2},7.8699736313397851E-4,1.5857843947861914E-2,9.1288993314194604E-4,14.994000000000003,-9.746100000000002,{"$f":"G12","v":4.1689633314995036E-3},{"$f":"D24","v":6.6319405767685678E-6},{"$f":"(SUM(C36:M36)+D40)","v":57.852559700357169},null,null,"N2O in Soil",null,null,"     N2O",{"$f":"C36","v":0.255953688148156},{"$f":"SUM(D36:I36)","v":4.0722072050376354},{"$f":"D40","v":48.272323211899298}]
[null,"     CO2",7386.4574356496732,{"$f":"IF('OR-GREET4.0'!$E$31=80%,'EF Tables'!B166,'EF Tables'!I166)","v":2725.6016074967788},{"$f":"IF('OR-GREET4.0'!$E$31=80%,'EF Tables'!C166,'EF Tables'!J166)","v":183.7176199621845},{"$f":"IF('OR-GREET4.0'!$E$31=80%,'EF Tables'!D166,'EF Tables'!K166)","v":483.86837402097723},67.579295069710994,668.10471564844909,42.333708600624746,355469.2350000001,-231055.00275000007,{"$f":"G13","v":752.55767822310509},{"$f":"D25","v":1.1959229555632687},{"$f":"(SUM(C37:M37)+D38+F38+J38+K38)","v":1173.13647962705},null,null,{"$f":"IFERROR(W39,0)","v":"-"},{"$f":"IFERROR(W40,0)","v":"-"},null,"     CO2",{"$f":"C37","v":7386.4574356496732},{"$f":"SUM(D37:I37)+D38+F38","v":6063.6931927987252},"-"]
[null,"     CO2 from Land use change",null,{"$f":"IF('OR-GREET4.0'!$E$31=80%,'EF Tables'!B167,'EF Tables'!I167)","v":766.7918719999999},"CO2 from urea use",{"$f":"IF('OR-GREET4.0'!$E$31=80%,'EF Tables'!D167,'EF Tables'!K167)","v":1125.6960000000001},"CO2 from CaCO3 use",null,null,-392700.00000000006,255255.00000000006,"CO2 uptaken from the air",null,null,null,null,"Cane Transport",null,null,"Total gCO2e/tonne cane:",{"$f":"U33*K10+U34*K11+U35*25+U36*298+U37","v":8306.8966630243394},{"$f":"V33*K10+V34*K11+V35*25+V36*298+V37","v":8163.0266073145758},{"$f":"W36*298","v":14385.15231714599}]
[null,"     VOC from bulk terminal",null,{"$f":"IF('OR-GREET4.0'!$E$31=80%,'EF Tables'!B168,'EF Tables'!I168)","v":38.022111463605057},"NO from N fertilizer and above/below ground biomass",null,null,null,null,null,null,null,null,null,null,null,{"$f":"H15","v":0},{"$f":"H16","v":0},null,"gCO2e/MJ (Molasses Feedstock)",{"$f":"IFERROR('Calculated Parameters'!$G$30*U38/('Calculated Parameters'!$E$34*76330/10^6)/1055.06,\"-\")","v":"-"},{"$f":"IFERROR('Calculated Parameters'!G30*V38/('Calculated Parameters'!$E$34*76330/10^6)/1055.06,\"-\")","v":"-"},{"$f":"IFERROR($D$40*298*'Calculated Parameters'!$G$30/('Calculated Parameters'!$E$34*76330*1055.06/10^6),\"-\")","v":"-"}]
[null,"     VOC from refueling station",null,{"$f":"IF('Site-Specific Inputs'!C23=\"Standard for Non-Sao Paulo States\",'EF Tables'!I169,'EF Tables'!B169)","v":48.272323211899298},"N2O from N fertilizer and above/below ground biomass",null,null,null,null,null,null,null,null,null,null,null,"Filtercake Transport",null,null,"gCO2e/MJ (Sugacane Juice Feeedstock)",{"$f":"IFERROR(U38/('Calculated Parameters'!$C$34*76330/10^6)/1055.06,\"-\")","v":"-"},{"$f":"IFERROR(V38/('Calculated Parameters'!$C$34*76330/10^6)/1055.06,\"-\")","v":"-"},{"$f":"IFERROR($D$40*298/('Calculated Parameters'!$C$34*76330*1055.06/10^6),\"-\")","v":"-"}]
[null,"*EFs based upon 95,000 Btu/m.t.cane.  If this number, fuel shares, or eGRID Mix changes then EF must be updated.",null,null,null,null,null,null,"Total Straw Bunring gCO2e/tonne cane:",{"$f":"J33*K10+J34*K11+J35*25+J36*298+J37+J38","v":17336.27700000006},null,null,null,null,null,null,{"$f":"E27","v":0},{"$f":"E28","v":0}]
[null,null,null,null,null,null,null,null,"Total gCO2e/MJ (mol feedstock):",{"$f":"IFERROR('Calculated Parameters'!G30*J41/('Calculated Parameters'!E34*76330*1055.06/10^6),0)","v":0},{"$f":"IFERROR(-'EF Tables'!J42*'Site-Specific Inputs'!$C$36,0)","v":0}]
["IV.","Sugar Production Emissions ",null,null,null,null,null,null,"Total gCO2e/MJ (cane juice feedstock):",{"$f":"IFERROR($J$41/('Calculated Parameters'!$C34*76330*1055.06/10^6),0)","v":0},{"$f":"IFERROR(-'EF Tables'!J43*'Site-Specific Inputs'!$C$36,0)","v":0},null,null,null,null,null,"Sugar Production Emissions "]
[null,"Sugar Production (Gopal-Kammen, 2009)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(($C$45/'Calculated Parameters'!$F$23/'Site-Specific Inputs'!$AR$50)*'Calculated Parameters'!$G$30,0)","v":0},0]
[null,"gCO2e/wet tonne cane",{"$f":"3700/(2000*0.4536/1000)","v":4078.4832451499119}]
[]
["V.","Sugarcane Ethanol Production",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Straw Burning Emissions"]
[null,null,"per gallon",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(J42,0)","v":0},{"$f":"IFERROR(J43,0)","v":0}]
[null,"Total Emissions: grams/mmBtu of fuel throughput, except as noted","Lime per gallon of Ethanol {\"EtOH\")*","Lime emissions per tonne of cane","Lime emissions per tonne of cane (Molasses Feedstock)","Lime emissions per tonne of cane (Cane Juice Feedstock)","Yeast Use, gram per gallon of ethanol produced","Residual Oil "]
[null,"     VOC",1.7919529029604402E-3,{"$f":"C50*'Calculated Parameters'!G23","v":0},{"$f":"IFERROR(D50*'Calculated Parameters'!G$30/'Calculated Parameters'!F$23,\"-\")","v":"-"},{"$f":"IFERROR(D50/'Calculated Parameters'!G$23,\"-\")","v":"-"},3.0344230115090338E-3,2.008659993777293E-4,null,null,null,null,null,null,null,null,"Mechanized Harvesting Credit"]
[null,"     CO",4.7041000194101125E-3,{"$f":"C51*'Calculated Parameters'!G23","v":0},{"$f":"IFERROR(D51*'Calculated Parameters'!G$30/'Calculated Parameters'!F$23,\"-\")","v":"-"},{"$f":"IFERROR(D51/'Calculated Parameters'!G$23,\"-\")","v":"-"},1.2099836308370682E-2,1.4521597533251494E-3,null,null,null,null,null,null,null,null,{"$f":"IFERROR(K42,0)","v":0},{"$f":"IFERROR(K43,0)","v":0}]
[null,"     CH4",3.0808032904760519E-2,{"$f":"C52*21.4","v":0.65929190416187511},{"$f":"IFERROR(D52*'Calculated Parameters'!G$30/'Calculated Parameters'!F$23,\"-\")","v":"-"},{"$f":"IFERROR(D52/'Calculated Parameters'!G$23,\"-\")","v":"-"},2.6746640682810869E-2,5.0725565976123205E-3]
[null,"     N2O",7.1677509707761416E-5,{"$f":"C53*21.4","v":1.5338987077460943E-3},{"$f":"IFERROR(D53*'Calculated Parameters'!G$30/'Calculated Parameters'!F$23,\"-\")","v":"-"},{"$f":"IFERROR(D53/'Calculated Parameters'!G$23,\"-\")","v":"-"},2.5864130127566153E-4,5.7417101611958054E-5,null,null,null,null,null,null,null,null,"Ethanol Production Emissions"]
[null,"     CO2",36.453695651503487,{"$f":"C54*21.4","v":780.1090869421746},{"$f":"IFERROR(D54*'Calculated Parameters'!G$30/'Calculated Parameters'!F$23,\"-\")","v":"-"},{"$f":"IFERROR(D54/'Calculated Parameters'!G$23,\"-\")","v":"-"},6.9869200445179285,2.8217089939383406,null,null,null,null,null,null,null," Residual Oil",{"$f":"IF('Site-Specific Inputs'!R$33=0%,0,H58/(76330*1055.06/10^6))","v":0},{"$f":"IF('Site-Specific Inputs'!R$33=100%,0,IF('Site-Specific Inputs'!AA33>0,H58*10^6/(76330*1055.06),\"-\"))","v":"-"}]
[null,"     CO2 from Land use change",null,null,null,null,null,null,null,null,null,null,null,null,null," Lime Use",{"$f":"IF('Site-Specific Inputs'!R$33=0%,0,$E$58*10^6/(76330*1055.06))","v":0},{"$f":"IF('Site-Specific Inputs'!R$33=100%,0,IF('Site-Specific Inputs'!AA33>0,F58*10^6/(76330*1055.06),\"-\"))","v":"-"}]
[null,"     VOC from bulk terminal",null,null,null,null,null,null,null,null,null,null,null,null,null,"Yeast Use",{"$f":"IF('Site-Specific Inputs'!R$33=0%,0,G58*10^6/(76330*1055.06))","v":0},{"$f":"IF('Site-Specific Inputs'!R$33=100%,0,IF('Site-Specific Inputs'!AA33>0,G58*10^6/(76330*1055.06),\"-\"))","v":"-"}]
[null,"     VOC from refueling station"]
[null,null,{"$f":"C50*'OR-GREET4.0'!K75+'OR-GREET4.0'!K76*C51+C52*25+C53*298+C54","v":37.258233449069664},"(gCO2e/gal ethanol)",{"$f":"IFERROR((E50*$K$10+E51*$K$11+E52*25+E53*298+E54),\"-\")","v":"-"},{"$f":"IFERROR((F50*$K$10+F51*$K$11+F52*25+F53*298+F54),\"-\")","v":"-"},{"$f":"(G50*$K$10+G51*$K$11+G52*25+G53*298+G54)","v":7.7611324829054666},{"$f":"(H50*$K$10+H51*$K$11+H52*25+H53*298+H54)","v":2.968541202850393},null,null,null,null,null,null,null,null,"Non-biogenic GHG emissions from sugarcane bagassee combustion"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Allocated to Cane Molasses","Allocated to Juice-EtOH"]
[null,"Non-biogenic GHG emissions from sugarcane bagassee combustion",null,"(grams/mmBtu fuel burned)","Pollutant Emissions (grams for total cane)","Emissions (gCO2e/total cane throughput)","Allocated to Cane Molasses","Allocated to Juice-EtOH",null,null,null,null,null,null,null,null,{"$f":"IF('Site-Specific Inputs'!R$33=0%,0,G65)","v":0},{"$f":"IF('Site-Specific Inputs'!R$33=100%,0,H65)","v":0}]
[null,"     VOC",null,28.305199565933879,{"$f":"D61*('Old Fuel_Specs'!$H$77/10^6)*'Old Fuel_Specs'!$C$78*'Old Fuel_Specs'!$C$79*'Site-Specific Inputs'!$J$33","v":0},{"$f":"E61*$K$10","v":0}]
[null,"     CO",null,194.00139826261949,{"$f":"D62*('Old Fuel_Specs'!$H$77/10^6)*'Old Fuel_Specs'!$C$78*'Old Fuel_Specs'!$C$79*'Site-Specific Inputs'!$J$33","v":0},{"$f":"E62*$K$11","v":0}]
[null,"     CH4",null,31.65,{"$f":"D63*('Old Fuel_Specs'!$H$77/10^6)*'Old Fuel_Specs'!$C$78*'Old Fuel_Specs'!$C$79*'Site-Specific Inputs'!$J$33","v":0},{"$f":"E63*$K$12","v":0},{"$f":"F$65*'Site-Specific Inputs'!S$32*'Calculated Parameters'!G30","v":0},{"$f":"F$65*(1-'Site-Specific Inputs'!R$33)","v":0},"(gCO2e)"]
[null,"     N2O",null,4.22,{"$f":"D64*('Old Fuel_Specs'!$H$77/10^6)*'Old Fuel_Specs'!$C$78*'Old Fuel_Specs'!$C$79*'Site-Specific Inputs'!$J$33","v":0},{"$f":"E64*K$13","v":0},{"$f":"'Calculated Parameters'!E33","v":0},{"$f":"'Calculated Parameters'!C$33","v":0},"(gal Ethanol)"]
[null,null,null,null,null,{"$f":"SUM(F60:F64)","v":0},{"$f":"IFERROR(G63/(G64*76330*1055.06/10^6),0)","v":0},{"$f":"IFERROR(H63/(H64*76330*1055.06/10^6),0)","v":0},"(gCO2e/MJ)"]
[null,null,null,null,null,null,null,{"$f":"H63/H64","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
["VI.","Surplus Cogenerated Electricity Export Credit ",null,null,null,null,{"$f":"'Calculated Parameters'!$I$33","v":0},"kWh per year",null,null,null,null,null,null,null,null,"Electricity Co-Product Credit"]
[null,null,"Ethanol Volume","Allocated to Feedstock","Energy Export ","Energy Export ",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF('Site-Specific Inputs'!#REF!=\"Yes\",-$G$84,\"0.0\"),0)","v":0},{"$f":"IFERROR(IF('Site-Specific Inputs'!#REF!=\"Yes\",-$H$84,\"0.0\"),0)","v":0}]
[null,"Feedstock"," (gal)","(kWh/year)","After Allocation","After T&D Losses","(kWh/gal Ethanol)","(Btu/gal Ethanol)"]
[null,"Molasses-to-EtOH",{"$f":"'Calculated Parameters'!F$25","v":0},{"$f":"('Site-Specific Inputs'!$Q$33-'Site-Specific Inputs'!$P$33-'Site-Specific Inputs'!$O$33)*'Site-Specific Inputs'!$R$33","v":0},{"$f":"D73*'Calculated Parameters'!$G$30","v":0},{"$f":"E73*(1-'OR-GREET4.0'!E$57)","v":0},{"$f":"IFERROR(F73/C73,0)","v":0},{"$f":"G73*3412.96","v":0}]
[null,"Juice-to-EtOH",{"$f":"'Calculated Parameters'!G$25","v":0},{"$f":"('Site-Specific Inputs'!$Q$33-'Site-Specific Inputs'!$P$33-'Site-Specific Inputs'!$O$33)*(1-'Site-Specific Inputs'!$R$33)","v":0},{"$f":"D74","v":0},{"$f":"E74*(1-'OR-GREET4.0'!E$57)","v":0},{"$f":"IFERROR(F74/C74,0)","v":0},{"$f":"G74*3412.96","v":0}]
[null,null,{"$f":"SUM(C73:C74)","v":0},{"$f":"SUM(D73:D74)","v":0},{"$f":"SUM(E73:E74)","v":0},{"$f":"SUM(F73:F74)","v":0},{"$f":"IFERROR(F75/C75,\"0.0\")","v":"0.0"},{"$f":"IFERROR(G75*3412.96,\"0.0\")","v":0}]
[null,"Pollutant","Electricity Emissions Displaced","Electricity Emissions Displaced","Electricity Emissions Displaced","Electricity Emissions Displaced","Electricity Emissions Displaced","Electricity Emissions Displaced"]
[null,null,"g/mmBtu ","g/mmBtu *","Mol Feedstock (g/gal)","Juice Feedstock (g/gal)","Mol Feedstock (gCO2e/gal)","Juice Feedstock (gCO2e/gal)"]
[null,"VOC",{"$f":"J146","v":8.7143693207039234},{"$f":"C78","v":8.7143693207039234},{"$f":"D78*H$73/10^6","v":0},{"$f":"IFERROR(D78*H$74/10^6,0)","v":0},{"$f":"E78*3.12","v":0},{"$f":"F78*K10","v":0}]
[null,"CO",{"$f":"J147","v":51.095114283737615},{"$f":"C79","v":51.095114283737615},{"$f":"D79*H$73/10^6","v":0},{"$f":"IFERROR(D79*H$74/10^6,0)","v":0},{"$f":"E79*1.57","v":0},{"$f":"F79*K11","v":0}]
[null,"CH4",{"$f":"J152","v":136.37644521511183},136.37644521511183,{"$f":"D80*H$73/10^6","v":0},{"$f":"IFERROR(D80*H$74/10^6,0)","v":0},{"$f":"E80*25","v":0},{"$f":"F80*25","v":0}]
[null,"N2O",{"$f":"J153","v":2.9174345141708642},2.9174345141708642,{"$f":"D81*H$73/10^6","v":0},{"$f":"IFERROR(D81*H$74/10^6,0)","v":0},{"$f":"E81*298","v":0},{"$f":"F81*298","v":0}]
[null,"CO2",{"$f":"J154","v":51929.383455402705},51929.383455402705,{"$f":"D82*H$73/10^6","v":0},{"$f":"IFERROR(D82*H$74/10^6,0)","v":0},{"$f":"E82","v":0},{"$f":"F82","v":0}]
[null,null,null,null,null,"gCO2e/gal",{"$f":"SUM(G78:G82)","v":0},{"$f":"SUM(H78:H82)","v":0}]
[null,null,null,null,null,"gCO2e/MJ",{"$f":"G83/(76330*1055.06/10^6)","v":0},{"$f":"H83/(76330*1055.06/10^6)","v":0}]
[null,null,null,null,null,"gCO2e/kWh",{"$f":"IFERROR(G83/G73,0)","v":0},{"$f":"IFERROR(H83/G74,0)","v":0}]
["VII.","Ethanol Transportation and Distribution"]
[null,null,"Ethanol produced in Brazil, and used in U.S."]
[null,"Distance Transported (mi)","Pipeline","Rail","Truck","Ocean Tanker","Barge","Pipeline","Rail","Truck","Truck"]
[null,null,{"$f":"'Site-Specific Inputs'!C$31/1.609","v":0},0,{"$f":"'Site-Specific Inputs'!C$30/1.609","v":0},{"$f":"'Site-Specific Inputs'!C$33/1.609","v":0},null,null,null,{"$f":"'Site-Specific Inputs'!C34","v":40},{"$f":"'Site-Specific Inputs'!C35","v":50}]
[null,"Pollutant","Total Emissions: grams/mmBtu fuel transported",null,null,null,null,null,null,null,null,"Total Ethanol T&D (g / mmBtu)","gCO2e/mmbtu",null,"Total Ethanol T&D",null,"Total Ethanol T&D"]
[null,"              VOC",{"$f":"$C$89*C102","v":0},{"$f":"$D$89*D102","v":0},{"$f":"$E$89*E102","v":0},{"$f":"$F$89*F102","v":0},null,null,null,{"$f":"$J$89*J102","v":7.7867690350263072E-2},{"$f":"$K$89*K102","v":9.7334612937828843E-2},{"$f":"SUM(C91:K91)","v":0.17520230328809192},{"$f":"L91*K$10","v":0.54604717858121976},null,{"$f":"L91*K10/Btu2J","v":5.1755286564329251E-4},{"$f":"O91","v":5.1755286564329251E-4},{"$f":"IF('Site-Specific Inputs'!R$33=0%,\"-\",M97)","v":"-"},{"$f":"IF('Site-Specific Inputs'!AA33=0,\"-\",IF('Site-Specific Inputs'!R33<100%,SUM('EF Tables'!P91:P95),0))","v":"-"}]
[null,"              CO",{"$f":"$C$89*C103","v":0},{"$f":"$D$89*D103","v":0},{"$f":"$E$89*E103","v":0},{"$f":"$F$89*F103","v":0},null,null,null,{"$f":"$J$89*J103","v":0.2703215196420557},{"$f":"$K$89*K103","v":0.33790189955256961},{"$f":"SUM(C92:K92)","v":0.6082234191946253},{"$f":"L92*K$11","v":0.95577965873441117},null,{"$f":"L92*K11/Btu2J","v":9.0590432604530959E-4},{"$f":"O92","v":9.0590432604530959E-4}]
[null,"              CH4",{"$f":"$C$89*C104","v":0},{"$f":"$D$89*D104","v":0},{"$f":"$E$89*E104","v":0},{"$f":"$F$89*F104","v":0},null,null,null,{"$f":"$J$89*J104","v":0.48740944777415635},{"$f":"$K$89*K104","v":0.60926180971769539},{"$f":"SUM(C93:K93)","v":1.0966712574918518},{"$f":"L93*25","v":27.416781437296294},null,{"$f":"L93*K12/Btu2J","v":2.5986094894688557E-2},{"$f":"O93","v":2.5986094894688557E-2}]
[null,"              N2O",{"$f":"$C$89*C105","v":0},{"$f":"$D$89*D105","v":0},{"$f":"$E$89*E105","v":0},{"$f":"$F$89*F105","v":0},null,null,null,{"$f":"$J$89*J105","v":1.0995013361412556E-3},{"$f":"$K$89*K105","v":1.3743766701765695E-3},{"$f":"SUM(C94:K94)","v":2.4738780063178253E-3},{"$f":"L94*298","v":0.73721564588271193},null,{"$f":"L94*K13/Btu2J","v":6.9874561226565589E-4},{"$f":"O94","v":6.9874561226565589E-4}]
[null,"              CO2",{"$f":"$C$89*C106","v":0},{"$f":"$D$89*D106","v":0},{"$f":"$E$89*E106","v":0},{"$f":"$F$89*F106","v":0},null,null,null,{"$f":"$J$89*J106","v":198.98449895791683},{"$f":"$K$89*K106","v":248.73062369739603},{"$f":"SUM(C95:K95)","v":447.71512265531283},{"$f":"L95","v":447.71512265531283},null,{"$f":"L95/Btu2J","v":0.42435205932966757},{"$f":"O95","v":0.42435205932966757}]
[null,null,null,null,null,"(incl back haul)",null,null,null,null,null,null,{"$f":"SUM(M91:M95)","v":477.37094657580747},"gCO2e/mmbtu",{"$f":"SUM(O91:O95)","v":0.45246035702831039},{"$f":"SUM(P91:P95)","v":0.45246035702831039}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M96/1055.06","v":0.45245857730916489},"gCO2e/MJ"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M96*76330/(10^6)","v":36.437724352131383},"gCO2e/gal"]
[null,"Total Emissions: grams/mmBtu fuel transported"]
[null,"Mode:","Pipeline","Rail","Truck","Ocean Tanker",null,null,null,"Truck","Truck"]
[null,"Emissions Factor","per mile","per mile","per mile","per mile",null,null,null,"per mile","per mile"]
[null,"              VOC",1.1583900553158093E-4,8.0802665022184316E-4,1.9464796500630354E-3,9.8747213689900307E-4,null,null,null,1.9466922587565768E-3,1.9466922587565768E-3]
[null,"              CO",7.4236625894237628E-4,2.64870669196906E-3,6.7564754438934494E-3,2.2356064711734082E-3,null,null,null,6.7580379910513926E-3,6.7580379910513926E-3]
[null,"              CH4",1.6760202626231434E-3,2.3761999851173877E-3,1.2180426717482555E-2,1.9634717089718899E-3,null,null,null,1.2185236194353908E-2,1.2185236194353908E-2]
[null,"              N2O",4.435033015887945E-5,2.9676823779122772E-5,2.7487357793112717E-5,2.5366676043747497E-5,null,null,null,2.7487533403531389E-5,2.7487533403531389E-5]
[null,"              CO2",0.62362223764246549,1.077277590949282,4.9737036434699036,1.078051466623372,null,null,null,4.9746124739479205,4.9746124739479205]
[]
[]
["VIII.","Denatured Ethanol  (D-EtOH) Calculator"]
[]
[null,null,"Molasses-to-Ethanol","Cane Juice-to-Ethanol"]
[null,"Volume % Ethanol in D-EtOH",{"$f":"1-C113","v":0.97499999999999998},{"$f":"1-D113","v":0.97499999999999998},"v/v EtOH/D-EtOH","Anhyd EtOH",{"$f":"G113/D112","v":0},"Total Denatured Ethanol",null,"LCFS Reference CI of CARBOB"]
[null,"Volume % of Denaturant (CARBOB and \"Other\") in D-EtOH",2.5000000000000001E-2,2.5000000000000001E-2,"v/v CARBOB/D-EtOH",null,{"$f":"'Site-Specific Inputs'!V33*(1-'Site-Specific Inputs'!U33)*'OR-GREET4.0'!C102","v":0},"Anhydrous Ethanol Produced"]
[null,"Energy % Denaturant in D-EtOH",{"$f":"G115","v":""},{"$f":"G115","v":""},"MJ/MJ CARBOB/D-EtOH",null,{"$f":"G112-G113","v":0},"Denaturant Added",null,"CARBOB CI",{"$f":"'OR-GREET4.0'!H$75","v":97.91}]
[null,"CARBOB CI *",{"$f":"$K$114-(5.87493397896155*$K$12+3.21914073294522*$K$13)/1055.06","v":96.861550349845771},{"$f":"$K$114-(5.87493397896155*$K$12+3.21914073294522*$K$13)/1055.06","v":96.861550349845771},"g CO2e/MJ CARBOB",null,{"$f":"IF(G114>0,G114*'OR-GREET4.0'!D75/('OR-GREET4.0'!D75*G114+'EF Tables'!G113*'OR-GREET4.0'!D77),\"\")","v":""},"Energy % Denaturant in D-EtOH"]
[null,"Denaturant, g/MJ",{"$f":"IFERROR((1-$C$114)*(C122+C123)+$C$114*$C$115-(C122+C123),0)","v":0},{"$f":"IFERROR((1-$D$114)*(D122+D123)+$D$114*$D$115-(D122+D123),0)","v":0},"g CO2e/MJ",null,null,null,"Changing these values will result in an incorrect CARFG and Denaturant calculation"]
[null,"*  Without Tailpipe N2O and CH4 emissions impact."]
[]
[]
[null,"CI Summary","(gCO2e/MJ)"]
["IX.",null,"Molasses","Cane Juice"]
[null,"CI (feedstock+fuel)",{"$f":"SUM(Q32:Q95)","v":0},{"$f":"SUM(R32:R95)","v":0}]
[null,"iLUC",11.8,11.8]
[null,"Denaturant",{"$f":"C116","v":0},{"$f":"D116","v":0}]
[null,"Total CI (g/MJ)",{"$f":"SUM(C122:C124)","v":11.8},{"$f":"SUM(D122:D124)","v":11.8}]
[]
[null,"3) Electric Transmission and Distribution Loss",null,8.1000000000000003E-2,null,"10) Calculation of Fuel-Cycle Energy Use, Water Consumption, and Emissions of other regional generation mixes"]
[null,null,null,null,null,null,"Brazil",null,null,"Brazil"]
[null,null,null,null,null,"Type","Average",null,null,"Average"]
[null,"2.2) Electricity Generation Mixes, Combustion Technolgy Shares and Power Plant Energy Conversion Efficiencies for GREET Calculation",null,null,null,"Year",2014,null,null,"CA-GREETv2.0"]
[null,null,"Feedstock Production: Brazillian Mix","Generation Mix for Stationary Applications",null,"Petroleum",{"$f":"D132","v":5.6800000000000003E-2},null,null,3.3700000000000001E-2]
[null,"Residual Oil-Fired Power Plants",null,5.6800000000000003E-2,null,"NG",{"$f":"D136","v":0.1298},null,null,7.8899999999999998E-2]
[null,"     Boiler",null,null,null,"Coal",{"$f":"D141","v":4.3200000000000002E-2},null,null,1.8700000000000001E-2]
[null,"     Internal Combustion Engine",null,null,null,"Biomass",{"$f":"D144","v":7.3800000000000004E-2},null,null,6.9800000000000001E-2]
[null,"     Gas Turbine",null,null,null,"Nuclear",{"$f":"D147","v":2.4799999999999999E-2},null,null,2.5999999999999999E-2]
[null,"Natural Gas-Fired Power Plants",null,0.1298,null,"Hydro",{"$f":"D148-G137","v":0.6633},null,null,0.76449999999999996]
[null,"     Boiler",null,null,null,"Others",8.3000000000000001E-3,null,null,8.3000000000000001E-3]
[null,"     Simple-cycle gas turbine",null,null,null,"T&D Loss",8.1000000000000003E-2,null,null,8.1000000000000003E-2]
[null,"     Combined-cycle gas turbine",null,null,null,"Btu or Gallons or Grams per mmBtu of Electricity Available at User Sites*"]
[null,"     Internal Combustion Engine",null,null,null,"Total energy",1717630.9685949294]
[null,"Coal-Fired Power Plants",null,4.3200000000000002E-2,null,"Fossil fuels",695566.73695560358]
[null,"     Boiler",null,null,null,"Coal",135973.26152480763]
[null,"     IGCC",null,null,null,"Natural gas",356645.04684469459]
[null,"Biomass Power Plants",null,7.3800000000000004E-2,null,"Petroleum",202948.42858610136]
[null,"     Boiler",null,null,null,"Water consumption",946.2397455218221,"Feedstock","Fuel","Total"]
[null,"     IGCC",null,null,null,"VOC",null,5.634073844916248,3.0802954757876759,{"$f":"I146+H146","v":8.7143693207039234}]
[null,"Nuclear Power Plants",null,2.4799999999999999E-2,null,"CO",null,14.217774472018359,36.877339811719253,{"$f":"I147+H147","v":51.095114283737615}]
[null,"Other Power Plants (hydro, wind, geothermal, etc.)",null,0.67159999999999997]
[null,"     Hydroelectric"]
[null,"     Geothermal"]
[null,"     Wind"]
[null,"     Solar PV",null,null,null,"CH4",null,132.17349663534631,4.2029485797655211,{"$f":"I152+H152","v":136.37644521511183}]
[null,"     Others (Biogenic Waste, Pumped Storage, etc.)",null,null,null,"N2O",null,0.48921935487986817,2.4282151592909962,{"$f":"I153+H153","v":2.9174345141708642}]
[null,null,"Sum:",{"$f":"SUM(D132:D153)","v":1},null,"CO2",null,4477.1822558724307,47452.201199530275,{"$f":"I154+H154","v":51929.383455402705}]
[null,null,null,null,null,"*  From CA-GREET3.0 (\"Electric\" #9) Fuel-Cycle Energy Use, Water Consumption, and Emissions of Electric Generation: Btu or Gallons or Grams per mmBtu of Electricity Available at User Sites (wall outlets))"]
[]
[]
[null,"Agricultural Inputs for 80% Mechanization*",null,995.8,"N Fertilizer based upon 0.53% (N in straw Content)",null,null,null,"Agricultural Inputs for 65% Mechanization",null,{"$f":"800+318.82","v":1118.82},"N Fertilizer based upon 0.53% (N in straw Content)"]
[null,"Sugarcane Farming, Fertilizer, and Herbicide/Insecticide Use (grams/tonne cane)*",null,null,null,null,null,null,"Sugarcane Farming, Fertilizer, and Herbicide/Insecticide Use (grams/tonne cane)*"]
[null,"Nitrogen**","P2O5","K2O","CaCO3","Herbicide","Insecticide","Pollutant","Nitrogen**","P2O5","K2O","CaCO3","Herbicide","Insecticide"]
[null,995.8,317.32639999999998,1371.2800000000002,5200,45,2.5,null,1118.82,311.07889999999998,1237.405,5200,45,2.5]
[null,6.5274987328704572,8.4559716784210731E-2,0.12907929955928368,1.9766987700185736E-2,9.0793786477985611E-2,6.1038909248327181E-3,"VOC",7.3336517115510045,8.2894910986113388E-2,0.11647757618513754,1.9766987700185736E-2,9.0793786477985611E-2,6.1038909248327181E-3]
[null,7.4268370136333539,0.29203537828204451,0.6598283307788132,6.325330668673268E-2,0.60416158166708478,5.6411438243670835E-2,"CO",8.3440592186053681,0.28628580615121307,0.59541076632588319,6.325330668673268E-2,0.60416158166708478,5.6411438243670835E-2]
[null,30.271724752940987,0.50069505703710349,1.2791465052048252,0.19104320677477579,1.6003084641562688,0.10716998614455636,"CH4",31.898502969875601,0.49083740772447371,1.1542662922765419,0.19104320677477579,1.6003084641562688,0.10716998614455636]
[null,4.0357816737929983,5.2509366571280068E-3,1.3616863343370889E-2,6.9694993887489838E-4,1.5790047513060415E-2,9.0982094476982302E-4,"N2O",4.533535545106381,5.1475565829664895E-3,1.2287479424627977E-2,6.9694993887489838E-4,1.5790047513060415E-2,9.0982094476982302E-4]
[null,2725.6016074967788,183.7176199621845,483.86837402097723,47.379502029646027,664.78504061973513,42.135331101154748,"CO2",3062.216280972752,180.10060029185848,436.62938667188848,47.379502029646027,664.78504061973513,42.135331101154748]
[null,766.7918719999999,"CO2 from urea use",1125.6960000000001,"CO2 from CaCO3 use",null,null,null,861.49147699999992,"CO2 from urea use",1125.6960000000001,"CO2 from CaCO3 use"]
[null,38.022111463605057,"NO from N fertilizer and above/below ground biomass",null,null,null,null,null,40.90486096360506,"NO from N fertilizer and above/below ground biomass"]
[null,44.800995461899298,"N2O from N fertilizer and above/below ground biomass",null,null,null,null,null,48.272323211899298,"N2O from N fertilizer and above/below ground biomass"]
[null,"* Per CA-GREET3.0",null,null,null,null,null,null,"* Per CA-GREET3.0"]
[null,"**  Nitrogen amount reflects 800 g/m.t. cane applied + 195.83 g / m.t. sugarcane for Nitrogen lost in burnt straw at 80% mechanization level.",null,null,null,null,null,null,"**  Nitrogen amount reflects 800 g/m.t. cane applied +  318.82 g / m.t. sugarcane for Nitrogen lost in burnt straw at 65% mechanization level."]
[null,"     The supplemental Nitrogen needed also reflects 75% fraction of sugarcane straw left in unburnt fields (25% Harvested).",null,null,null,null,null,null,"     The supplemental Nitrogen needed also reflects 75% fraction of sugarcane straw left in unburnt fields (25% Harvested)."]
[]
[]
[null,"Options for Mechanized Harvesting",null,null,"Options for Port of Export",null,null,"Options for Ocean Transport Route to California",null,"Choices for Field 1.6 (Provisional Pathway)?:"]
[null,"Standard for Sao Paulo State","Standard for Non-Sao Paulo States",null,"Port of Santos (Sao Paulo)",null,null,"Via Panama Canal",null,"Yes"]
[null,0.8,0.65,null,"Port of Ilha D'Agua (Rio de Janeiro)",null,null,"Via Cape Horn",null,"No"]
[null,null,null,null,null,null,null,"Via Strait of Magellan"]
[null,"Return of Nitrogen to Soil via Filtercake and Vinasse Application"]
[null,null,"Filtercake","Vinasse"]
[null,"Application (kg dry filtercake or L vinasse/MT sugarcane)",{"$f":"5*30%/6/87.1*1000","v":2.8702640642939152},570]
[null,"N content (g N/kg dry filtercake or L vinasse)",12.5,0.36]
[null,"N in soil from filtercake and vinasse (g N/MT sugarcane)",35.878300803673937,205.2]
[null,"Moisture content (wt%)",0.65]
[null,"See CA-GREET3.0, \"EtOH\" Worksheet (Row 111-115)."]

{"sheet":"EF General","index":6,"n_rows":173,"n_cols":20,"rows_kept":173,"cut":false,"hidden":true,"merged":[]}
[]
["Generalized Emissions Factors (EF General) for CI Determination (HIDE SHEET)."]
[]
[]
["Factor 1 - Sugarcane Farming Impacts",null,null,null,null,null,"gCO2e/MJ"]
["Sugarcane Farming",null,null,null,null,null,{"$f":"IF('Site-Specific Inputs'!S32=0,'Calculated Parameters'!G93,'Calculated Parameters'!M93)","v":"-"}]
["Fertilizers",null,null,null,null,null,{"$f":"IF('Site-Specific Inputs'!S$32=0,'Calculated Parameters'!G94,'Calculated Parameters'!M94)","v":0}]
["N2O in Soil",null,null,null,null,null,{"$f":"IF('Site-Specific Inputs'!S$32=0,'Calculated Parameters'!G95,'Calculated Parameters'!M95)","v":"-"}]
[null,null,null,null,null,"Total:",{"$f":"SUM(G6:G8)","v":0},"gCO2e"]
[null,null,null,null,null,null,null,{"$f":"10^6","v":1000000},"J","Btu"]
[null,null,null,null,null,null,null,1055.06,"J",76330,"Btu"]
[null,null,null,null,null,null,null,null,null,null,"gal"]
[]
[null,null,null,null,null,null,null,null,null,"For Molasses Feedstock  =  Sugarcane Farming Impacts (gCO2e/gal)  x Yield of Ethanol (gal/m.t. cane)   / Mass Allocation Ratio"]
["Factor 1 - Sugarcane Farming Impacts",null,null,null,null,"=",{"$f":"G9*H11*J11/H10","v":0},"gCO2e",null,{"$f":"G15","v":0},{"$f":"H15","v":"gCO2e"},{"$f":"'Calculated Parameters'!F$23","v":0},"gal","=",{"$f":"J15*L15","v":0},"gCO2e",{"$f":"'Site-Specific Inputs'!J$33","v":0},"m.t. cane",{"$f":"'Site-Specific Inputs'!R33","v":0},"Juice Share"]
[null,null,null,null,null,null,null,"gal EtOH",null,null,{"$f":"H16","v":"gal EtOH"},null,"mt cane",null,null,"mt cane"]
[]
[null,null,null,null,null,null,null,null,"=",{"$f":"O15*Q15*S15","v":0},"gCO2e"]
[]
[]
["Factor 2 - Sugarcane Straw Burning",null,null,null,null,null,null,null,null,"For Sugarcane Juice Feedstock  =  Sugarcane Farming Impacts (gCO2e/gal)  x Yield of Ethanol "]
[null,null,null,null,null,null,null,null,null,{"$f":"G15","v":0},"gCO2e",{"$f":"'Calculated Parameters'!G$23","v":0},"gal","=",{"$f":"J22*L22","v":0},"gCO2e",{"$f":"'Site-Specific Inputs'!J$33","v":0},"m.t. cane"]
[null,null,"g/tonne cane","gCO2e/mt cane",null,null,null,null,null,null,"gal EtOH",null,"mt cane",null,null,"mt cane",null,null,{"$f":"1-S15","v":1},"Juice Share"]
["     VOC",null,1499.4000000000003,{"$f":"C24*'EF Tables'!K$10","v":4673.130000000001}]
["     CO",null,19706.400000000001,{"$f":"C25*'EF Tables'!K$11","v":30967.200000000001},null,null,null,null,"=",{"$f":"O22*Q22*S23","v":0},"gCO2e"]
["     NOx"]
["     PM10"]
["     PM2.5",null,null,null,null,null,null,null,"=",{"$f":"J25+J18","v":0},"gCO2e",null,null,"cane for juice","cane for mol"]
["     SOx",null,null,null,null,null,null,null,null,null,null,{"$f":"'Site-Specific Inputs'!J33","v":0},"mt cane",{"$f":"1-'Site-Specific Inputs'!R33","v":1},{"$f":"'Site-Specific Inputs'!S32*'Calculated Parameters'!G30","v":0}]
["     BC"]
["     OC",null,null,null,null,null,null,null,"=",{"$f":"IFERROR(J28/(L29*(N29+O29)),0)","v":0},"gCO2e/m.t. cane"]
["     CH4",null,578.34,{"$f":"C32*25","v":14458.5}]
["     N2O",null,14.994000000000003,{"$f":"C33*298","v":4468.2120000000014},null,null,"Net Sugarcane Straw Burning Impacts (Juice Feedstock)  =  (gCO2e/m.t. cane)  x  (1 - Mech %)"]
["     CO2",null,355469.2350000001,{"$f":"C34","v":355469.2350000001},null,null,"Net Sugarcane Straw Burning Impacts (Juice Feedstock)  =  17,313.1  x  (1 - Mech %) gCO2e/m.t. cane"]
["     Misc. CO2",null,-392700.00000000006,{"$f":"C35","v":-392700.00000000006}]
[null,null,null,null,null,null,"Net Sugarcane Straw Burning Impacts (Mol Feedstock)  =  (gCO2e/m.t. cane)  x  (1 - Mech %)  x M.A.R."]
[null,null,null,{"$f":"SUM(D24:D35)","v":17336.27700000006},"gCO2e/mt cane",null,"Net Sugarcane Straw Burning Impacts (Mol Feedstock)  =  17,313.1  x  (1 - Mech %) /  M.A.R.  gCO2e/m.t. cane"]
[]
["Factor 3 - Sugarcane & Filtercake Transport "]
[]
[null,{"$f":"'Site-Specific Inputs'!$J$34","v":0},"\"X\" miles Cane transport to Mill",null,2.8702640642939152,"Yield kg dry filtercake/MT sugarcane"]
[null,null,null,"2 miles cane","2 miles Filtercake","\"X\" Miles Filtercake"]
[null,"hddt","mddt","mddt","hddt","hddt"]
[null,"g/tonne-mile","g/tonne-mile","g/tonne cane","g/tonne cane","g/tonne-mile"]
["VOC",{"$f":"'EF Tables'!F21","v":8.2333247575540738E-2},{"$f":"'EF Tables'!F9/2","v":0.14825844412399669},{"$f":"2*C45","v":0.29651688824799338},{"$f":"2*B45*(E$41/1000)","v":4.7263632362537738E-4},{"$f":"B45","v":8.2333247575540738E-2}]
["CO",{"$f":"'EF Tables'!F22","v":0.28631209300513355},{"$f":"'EF Tables'!F10/2","v":0.51528213472052897},{"$f":"2*C46","v":1.0305642694410579},{"$f":"2*B46*(E$41/1000)","v":1.6435826234508242E-3},{"$f":"B46","v":0.28631209300513355}]
["CH4",{"$f":"'EF Tables'!F23","v":0.51115476305275653},{"$f":"'EF Tables'!F11/2","v":0.92264198249970475},1.8452839649994095,2.9342982953659965E-3,{"$f":"B47","v":0.51115476305275653}]
["N2O",{"$f":"'EF Tables'!F24","v":1.155397923745427E-3},{"$f":"'EF Tables'!F12/2","v":2.0844816657497518E-3},4.1689633314995036E-3,6.6325942809726007E-6,{"$f":"B48","v":1.155397923745427E-3}]
["CO2",{"$f":"'EF Tables'!F25","v":208.35031373133396},{"$f":"'EF Tables'!F13/2","v":376.27883911155254},752.55767822310509,1.1960408365748219,{"$f":"B49","v":208.35031373133396}]
["CO2e",{"$f":"B45*3.12+B46*1.57+B47*25+B48*298+B49","v":222.17988110738276},{"$f":"C45*3.12+C46*1.57+C47*25+C48*298+C49","v":401.23762350761672},{"$f":"D45*3.12+D46*1.57+D47*25+D48*298+D49","v":802.47524701523344},{"$f":"E45*3.12+E46*1.57+E47*25+E48*298+E49","v":1.2754298571032305},{"$f":"F45*3.12+F46*1.57+F47*25+F48*298+F49","v":222.17988110738276}]
[]
["Sugarcane & Filtercake Transport ",null," = (\"X\" miles * 307.47) +  665.78",null,null,{"$f":"(B50*B41)+(E$41/1000)*(B41*B50)+D50+E50","v":803.75067687233661},"gCO2/tonne cane"]
[]
["Sugarcane & Filtercake Transport ",null," = (\"X\" miles * 307.47) +  665.78 (Juice Feedstock)"]
["Sugarcane & Filtercake Transport ",null," = ((\"X\" miles * 307.47) +  665.78 ) * M.A.R. (Molasses Feedstock)"]
[]
[]
["Factor 4 - Electricity Co-Product Credit"]
[]
["For Cane Juice Feedstock",null,null,null,null,null,null,null,null,null,null,null,"Conversely,"]
[{"$f":"'EF Tables'!H84","v":0},"gCO2e/MJ Ethanol",null,"=",{"$f":"ABS(A61)","v":0},"gCO2e"]
[null,null,null,null,null,1000000,"J","Btu","1 gal","1 m.t.cane",null,null,{"$f":"E61*F63*I63/F62","v":0},"g CO2e",{"$f":"'Calculated Parameters'!G25","v":0},"gal"]
[null,null,null,null,null,1055.06,"J","Btu",76330,{"$f":"'Calculated Parameters'!$G$23","v":0},"gal",null,null,"gal",null,"yr"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M62*O62","v":0},"g CO2e","allocated to juice-to-ethanol"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"yr"]
[" Electricity Co-Product Credit:",null,null,"=",{"$f":"-E61*F63*I63*J63/F62","v":0},"gCO2e","for",{"$f":"'Calculated Parameters'!K$34","v":0},"kWh","Electricity Displaced"]
[null,null,null,null,null,"m.t. cane",null,null,"gal ",null,null,null,{"$f":"IFERROR((M64/(1-'Site-Specific Inputs'!R$33))-M64,0)","v":0},"g CO2e","allocated to sugar production"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"yr"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M67*'Calculated Parameters'!G30","v":0}]
["For Molasses Feedstock",null,null,null,null,null,null,null,null,null,null,null,{"$f":"M67-M69","v":0}]
[{"$f":"'EF Tables'!G84","v":0},"gCO2e/MJ Ethanol",null,"=",{"$f":"ABS(A71)","v":0},"gCO2e",null,null,null,null,null,null,{"$f":"M70+M69+M64","v":0},"g CO2e","alloated to all production"]
[null,null,null,null,null,1000000,"J","Btu","1 gal","1 m.t.cane",null,null,null,"yr"]
[null,null,null,null,null,1055.06,"J","Btu",76330,{"$f":"'Calculated Parameters'!F$23","v":0},"gal",null,{"$f":"'Calculated Parameters'!I33","v":0},"KWh per year"]
[]
[null,null,null,null,null,null,0]
[" Electricity Co-Product Credit:",null,null,"=",{"$f":"-E71*F73*I73*J73/F72","v":0},"gCO2e","for",{"$f":"'Calculated Parameters'!K$33","v":0},"kWh","Electricity Displaced"]
[null,null,null,null,null,"m.t.cane",null,null,"gal "]
[]
[]
[]
[]
["Factor 5 - Sugar Production Emissions for Molasses Feedstock"]
["Sugar Production Emissions",null,null,null,null,{"$f":"'EF Tables'!C45","v":4078.4832451499119},"gCO2e/m.t. cane"]
["Mass Allocation Ratio",null,null,null,null,"M.A.R."]
["Sugar Production Emissions",null,null,null,"=  4078.5  x  M.T. Cane for Sugar Production",null,null,"gCO2e"]
["Sugar Production Emissions Applicable to Molasses ",null,null,null,"=  4078.5 x M.T. of Cane for Sugar Production x M.A.R.",null,null,"gCO2e"]
[]
[]
["Factor 6 -  Ethanol Production "]
[null,null,{"$f":"'Calculated Parameters'!G116+'Calculated Parameters'!G114+'Calculated Parameters'!G117+'Calculated Parameters'!G118","v":0},"gCO2e/MJ Ethanol","Juice"]
[]
[null,null,{"$f":"IF('Site-Specific Inputs'!S32=0,'EF General'!C90,'Calculated Parameters'!M116+'Calculated Parameters'!M114+'Calculated Parameters'!M117+'Calculated Parameters'!M118)","v":0},"gCO2e",null,null,null,"=",{"$f":"C92*D94*G94/D93","v":0},"gCO2e"]
[null,null,null,1000000,"J","Btu","1 gal",null,null,"gal Ethanol"]
[null,null,null,1055.06,"J","Btu",76330]
[]
[]
[null,"For Molasses Feedstock"]
[null,"=",{"$f":"I92","v":0},"gCO2e",{"$f":"'Calculated Parameters'!F23","v":0},"gal Ethanol","=",{"$f":"I92","v":0},"gCO2e",{"$f":"E98","v":0},"gal Ethanol","=",{"$f":"IFERROR(H98*J98/J99,0)","v":0},"gCO2e"]
[null,null,null,"gal Ethanol","M.A.R","m.t. cane",null,null,"gal Ethanol",{"$f":"'Calculated Parameters'!G30","v":0},"m.t. cane",null,null,"m.t. cane"]
[]
[null,"For Cane Juice Feedstock"]
[null,"=",{"$f":"I92","v":0},"gCO2e",{"$f":"'Calculated Parameters'!G23","v":0},"gal Ethanol","=",{"$f":"C102","v":0},"gCO2e",{"$f":"E102","v":0},"gal Ethanol","=",{"$f":"H102*J102","v":0},"gCO2e"]
[null,null,null,"gal Ethanol",null,"m.t. cane",null,null,"gal Ethanol",null,"m.t. cane",null,null,"m.t. cane"]
[]
[]
["Factor 7 - Denaturant Emissions",null,null,null,null,{"$f":"'EF Tables'!C124","v":0},"gCO2e",null,null,{"$f":"'Calculated Parameters'!F23","v":0},"gal",{"$f":"'Site-Specific Inputs'!J$33","v":0},"mt cane",{"$f":"'Calculated Parameters'!G$30","v":0},{"$f":"'Site-Specific Inputs'!R$33","v":0}]
["Denaturant Emissions Impact  =  3.30 - CI (feedstk+fuel) x 0.0376",null,null,null,null,1000000,"J","Btu","gal",null,"m.t. cane",null,"yr"]
[null,null,null,null,null,1055.06,"J","Btu",76330]
[]
[null,null,null,null,null,{"$f":"F106*J106*L106*N106*O106*1055.06*76330/1000000","v":0},"gCO2e"]
[null,null,null,null,null,null,"yr"]
[]
[null,null,null,"feedstock","gal","MJ","CI","gCO2e","EF  gCO2e/gal",null,"Demo CI"]
[]
[null,null,null,"molasses",{"$f":"'Calculated Parameters'!F25","v":0},{"$f":"E115*76330*1055.06/10^6","v":0},{"$f":"'EF Tables'!C124","v":0},{"$f":"G115*F115","v":0},{"$f":"IFERROR(H115/E115,0)","v":0},{"$f":"IFERROR(I115/I117,0)","v":0},{"$f":"IFERROR(K117*J115,0)","v":0}]
[null,null,null,"juice",{"$f":"'Calculated Parameters'!G25","v":0},{"$f":"E116*76330*1055.06/10^6","v":0},{"$f":"'EF Tables'!D124","v":0},{"$f":"G116*F116","v":0},{"$f":"IFERROR(H116/E116,0)","v":0},{"$f":"IFERROR(I116/I117,0)","v":0},{"$f":"IFERROR(K117*J116,0)","v":0}]
[null,null,null,null,{"$f":"SUM(E115:E116)","v":0},{"$f":"SUM(F115:F116)","v":0},null,{"$f":"SUM(H115:H116)","v":0},{"$f":"IFERROR(H117/E117,0)","v":0},"EF ",{"$f":"I117/(76330*1055.06/10^6)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR((I115*E115+I116*E116)/E117,0)","v":0},"weighted avg"]
[]
[]
["Factor 8 - ILUC"]
[]
["ILUC",{"$f":"11.8","v":11.8},"gCO2e"]
[null,null,"MJ "]
[]
["ILUC  =  ",{"$f":"B123","v":11.8},"gCO2e",null,null,null,"=",{"$f":"B126*E128*C128/C127","v":950.28621164000003},"gCO2e",{"$f":"H126*'Calculated Parameters'!$F$25","v":0},"gCO2e mol feedstock"]
[null,null,1000000,"J","Btu","1 gal EtOH",null,null,"gal Ethanol",{"$f":"H126*'Calculated Parameters'!$G$25","v":0},"gCO2e juice feedstock"]
[null,null,1055.06,"J",76330,"Btu",null,null,null,{"$f":"SUM(J126:J127)","v":0},"gCO2e"]
[]
["ILUC juice","=",{"$f":"H126","v":950.28621164000003},"gCO2e",{"$f":"'Calculated Parameters'!G23","v":0},"gal Ethanol"]
[null,null,null,"gal Ethanol",null,"m.t.cane","=",{"$f":"C130*E130","v":0},"gCO2e",{"$f":"H131*'Site-Specific Inputs'!J$33*(1-'Calculated Parameters'!F$70)*(1-'Site-Specific Inputs'!R$33)","v":0},"gCO2e"]
[null,null,null,null,null,null,null,null,"m.t.cane"]
[]
[]
["ILUC mol","=",{"$f":"H126","v":950.28621164000003},"gCO2e",{"$f":"'Calculated Parameters'!F23","v":0},"gal Ethanol"]
[null,null,null,"gal Ethanol",null,"m.t.cane","=",{"$f":"C135*E135","v":0},"gCO2e",{"$f":"H$136*'Site-Specific Inputs'!J$33*'Site-Specific Inputs'!R$33","v":0},"gCO2e"]
[null,null,null,null,null,null,null,null,"m.t.cane"]
[]
[]
[]
[]
["Factor 9 - Ethanol Transport & Distribution"]
[]
["For Cane Juice Feedstock",null,{"$f":"'Calculated Parameters'!G$119","v":0},"gCO2"]
[null,null,null,"MJ"]
[]
[null,"=",{"$f":"C144","v":0},"gCO2",null,null,"=",{"$f":"C147*F149*C149/C148","v":0},"gCO2e",{"$f":"'Calculated Parameters'!G$23","v":0},"gal","=",{"$f":"J147*H147","v":0},"gCO2e"]
[null,null,1000000,"J","Btu","gal",null,null,"gal EtOH",null,"mt cane",null,null,"mt cane"]
[null,null,1055.06,"J","Btu",76330]
[]
["For Cane Molasses Feedstock",null,{"$f":"'Calculated Parameters'!M119","v":0},"gCO2"]
[null,null,null,"MJ"]
[]
[null,"=",{"$f":"C151","v":0},"gCO2",null,null,"=",{"$f":"C154*F156*C156/C155","v":0},"gCO2e",{"$f":"'Calculated Parameters'!F$23","v":0},"gal","=",{"$f":"J154*H154","v":0},"gCO2e"]
[null,null,1000000,"J","Btu","gal",null,null,"gal EtOH",null,"mt cane",null,null,"mt cane"]
[null,null,1055.06,"J","Btu",76330]
[]
[]
[]
[]
["VII.","EF for Ethanol Transportation and Distribution",null,null,null,null,null,null,null,null,"in Brazil, miles","in California, miles"]
[null,"Mode & Distance Transported (mi)","Pipeline:",{"$f":"'Site-Specific Inputs'!C$31/1.609","v":0},"Rail:",0,"Ocean Tanker:",{"$f":"'Site-Specific Inputs'!C$33/1.609","v":0},"Total Truck Transport in Brazil:","Total Truck Transport in California:",{"$f":"'Site-Specific Inputs'!C30/1.609","v":0},{"$f":"'Site-Specific Inputs'!C34+'Site-Specific Inputs'!C35","v":90}]
[null,"Pollutant","g per mmBtu-mile","gCO2e per mmBtu-mi","g per mmBtu-mile","gCO2e per mmBtu-mi","g per mmBtu-mile","gCO2e per mmBtu-mi","g per mmBtu-mile","g per mmBtu-mile","gCO2e/mmBtu-mi","gCO2e/mmBtu-mi"]
[null,"              VOC",{"$f":"'EF Tables'!C102","v":1.1583900553158093E-4},{"$f":"C164*'EF Tables'!K$10","v":3.6103156724009392E-4},{"$f":"'EF Tables'!D102","v":8.0802665022184316E-4},{"$f":"E164*'EF Tables'!K$10","v":2.5183497265247445E-3},{"$f":"'EF Tables'!F102","v":9.8747213689900307E-4},{"$f":"G164*'EF Tables'!K$10","v":3.0776214933352264E-3},{"$f":"'EF Tables'!E102","v":1.9464796500630354E-3},{"$f":"'EF Tables'!K102","v":1.9466922587565768E-3},{"$f":"I164*'EF Tables'!K$10","v":6.06652824269646E-3},{"$f":"J164*'EF Tables'!K$10","v":6.0671908731246647E-3}]
[null,"              CO",{"$f":"'EF Tables'!C103","v":7.4236625894237628E-4},{"$f":"C165*'EF Tables'!K$11","v":1.1665755497665912E-3},{"$f":"'EF Tables'!D103","v":2.64870669196906E-3},{"$f":"E165*'EF Tables'!K$11","v":4.1622533730942372E-3},{"$f":"'EF Tables'!F103","v":2.2356064711734082E-3},{"$f":"G165*'EF Tables'!K$11","v":3.5130958832724985E-3},{"$f":"'EF Tables'!E103","v":6.7564754438934494E-3},{"$f":"'EF Tables'!K103","v":6.7580379910513926E-3},{"$f":"I165*'EF Tables'!K$11","v":1.0617318554689706E-2},{"$f":"J165*'EF Tables'!K$11","v":1.0619773985937903E-2}]
[null,"              CH4",{"$f":"'EF Tables'!C104","v":1.6760202626231434E-3},{"$f":"C166*25","v":4.1900506565578581E-2},{"$f":"'EF Tables'!D104","v":2.3761999851173877E-3},{"$f":"E166*25","v":5.940499962793469E-2},{"$f":"'EF Tables'!F104","v":1.9634717089718899E-3},{"$f":"G166*25","v":4.9086792724297251E-2},{"$f":"'EF Tables'!E104","v":1.2180426717482555E-2},{"$f":"'EF Tables'!K104","v":1.2185236194353908E-2},{"$f":"I166*25","v":0.30451066793706388},{"$f":"J166*25","v":0.3046309048588477}]
[null,"              N2O",{"$f":"'EF Tables'!C105","v":4.435033015887945E-5},{"$f":"C167*298","v":1.3216398387346076E-2},{"$f":"'EF Tables'!D105","v":2.9676823779122772E-5},{"$f":"E167*298","v":8.8436934861785867E-3},{"$f":"'EF Tables'!F105","v":2.5366676043747497E-5},{"$f":"G167*298","v":7.5592694610367543E-3},{"$f":"'EF Tables'!E105","v":2.7487357793112717E-5},{"$f":"'EF Tables'!K105","v":2.7487533403531389E-5},{"$f":"I167*298","v":8.1912326223475898E-3},{"$f":"J167*298","v":8.1912849542523543E-3}]
[null,"              CO2",{"$f":"'EF Tables'!C106","v":0.62362223764246549},{"$f":"C168","v":0.62362223764246549},{"$f":"'EF Tables'!D106","v":1.077277590949282},{"$f":"E168","v":1.077277590949282},{"$f":"'EF Tables'!F106","v":1.078051466623372},{"$f":"G168","v":1.078051466623372},{"$f":"'EF Tables'!E106","v":4.9737036434699036},{"$f":"'EF Tables'!K106","v":4.9746124739479205},{"$f":"I168","v":4.9737036434699036},{"$f":"J168","v":4.9746124739479205}]
[null,null,"total gCO2e per mmBtu-mi",{"$f":"SUM(D164:D168)","v":0.68026674971239687},"total gCO2e per mmBtu-mi",{"$f":"SUM(F164:F168)","v":1.1522068871630142},"total gCO2e per mmBtu-mi",{"$f":"SUM(H164:H168)","v":1.1412882461853138},"total gCO2e per mmBtu-mi","total gCO2e per mmBtu-mi",{"$f":"SUM(K164:K168)","v":5.3030893908267016},{"$f":"SUM(L164:L168)","v":5.3041216286200834}]
[null,null,"gCO2e/gal-mi",{"$f":"D169*76330/(10^6)","v":5.1924761005547257E-2},"gCO2e/gal-mi",{"$f":"F169*76330/(10^6)","v":8.7947951697152874E-2},"gCO2e/gal-mi",{"$f":"H169*76330/(10^6)","v":8.7114531831325004E-2},"gCO2e/gal-mi","gCO2e/gal-mi",{"$f":"K169*76330/(10^6)","v":0.40478481320180215},{"$f":"L169*76330/(10^6)","v":0.40486360391257098}]
[null,null,"gCO2e/gal",{"$f":"D170*D162","v":0},"gCO2e/gal",{"$f":"F170*F162","v":0},"gCO2e/gal",{"$f":"H170*H162","v":0},"gCO2e/gal","gCO2e/gal",{"$f":"K170*K162","v":0},{"$f":"L170*L162","v":36.43772435213139}]
[null,null,"gCO2e/MJ",{"$f":"D171*10^6/(76330*1055.06)","v":0},"gCO2e/MJ",{"$f":"F171*10^6/(76330*1055.06)","v":0},"gCO2e/MJ",{"$f":"H171*10^6/(76330*1055.06)","v":0},"gCO2e/MJ","gCO2e/MJ",{"$f":"K171*10^6/(76330*1055.06)","v":0},{"$f":"L171*10^6/(76330*1055.06)","v":0.45245857730916494}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"H172+F172+D172+K172+L172","v":0.45245857730916494}]

{"sheet":"Old Fuel_Specs","index":7,"n_rows":83,"n_cols":9,"rows_kept":83,"cut":false,"hidden":true,"merged":[[43,2,43,3],[39,2,39,3],[37,2,37,3],[51,2,51,3],[52,2,52,3],[38,2,38,3],[40,2,40,3],[42,2,42,3],[53,2,53,3],[54,2,54,3],[45,2,45,3],[46,2,46,3],[48,2,48,3],[49,2,49,3],[50,2,50,3],[47,2,47,3],[33,2,33,3],[21,2,21,3],[22,2,22,3],[11,2,11,3],[12,2,12,3],[31,2,31,3],[32,2,32,3],[24,2,24,3],[25,2,25,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[16,4,19,4],[1,1,1,4],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3]]}
[]
[null,"General References for Sugarcane-based Ethanol Pathways (HIDE)"]
[]
[null,"Feedstock Type","Sugarcane Juice","Molasses","Sources"]
[null,"Juice-to-Sugar share, %",null,"User Defined"]
[null,"Sucrose in Sugarcane Juice (Entering Process)",null,"User Defined"]
[null,"a. Farming Energy"]
[null,"Total Farming Energy","95,000 Btu/tonne",null,"OR-GREET 3.0"]
[null,"     Diesel fuel",36385]
[null,"     Gasoline",11685]
[null,"     Natural gas",20425]
[null,"Liquefied petroleum gas",17860]
[null,"     Electricity",8550]
[null,"b. Fertilizer Use","65% Mechanization","80% Mechanization"]
[null,"Nitrogen",1118.82,996,"OR-GREET 3.0"]
[null,"P2O5",311.10000000000002,317.3,"(g / tonne)"]
[null,"K2O",1237.4000000000001,1371.3,"(Revised per 15-day Changes; N% in Sugarcane Straw revision to 0.53%)"]
[null,"CaCO3",5200,5200]
[null,"Herbicide",45,45]
[null,"Pesticide",2.5,2.5]
[null,"c. N2O in soil"]
[null,"N in N2O as % of N in N fertilizer ",1.325E-2,null,"OR-GREET 3.0"]
[null,"N in N2O as % of N in biomass",1.225E-2,null,"OR-GREET 3.0"]
[null,"d. Cane Transport"]
[null,"Raw feedstock to collection point by MDT, mi",2,null,"OR-GREET 3.0"]
[null,"To Ethanol plant by HDDT mi","User Defined"]
[null,"e. Straw Burning"]
[null,"Straw yield: dry tonne/wet tonne of sugarcane",0.2142,null,"OR-GREET 3.0"]
[null,"Moisture in straw",0.15,null,"OR-GREET 3.0"]
[null,"Burn Field, %",0.9,null,"OR-GREET 3.0"]
[null,"f. Mechanized Harvesting Credit"]
[null,"Mechanized field, %","Standard (Sao Paulo State) at 80%, or",null,"OR-GREET 3.0"]
[null,null," (Non-Sao Paulo State) at 65%",null,"OR-GREET 3.0"]
[null,"g. Filter Cake T&D, miles","Same as Cane Transport +2 miles."]
[null,"h. Sugar Production"]
[null,"gCO2e/wet ton of cane",null,3700,"(Gopal et al, 2009).1"]
[null,"i. Ethanol Production"]
[null,"Total Plant Energy (Btu/gal)"]
[null,"Residual oil",300,null,"OR-GREET 3.0"]
[null,"Chemical Use, g/tonne of cane"]
[null,"Lime",880,null,"OR-GREET 3.0"]
[null,"j. Fuel Distribution"]
[null,"Distribution by HDT to blending terminal, miles",40,null,"OR-GREET 3.0"]
[null,"Distribution by HDT to stations, miles",50,null,"OR-GREET 3.0"]
[null,"k. Fuel Properties"]
[null,"Density of EtOH (LHV), grams/gal",2988,null,"OR-GREET 3.0"]
[null,"Sugarcane bagasse, Btu/ton",12381771.311916806,null,"OR-GREET 3.0"]
[null,"Sugarcane bagasse, Btu/metric tonne",{"$f":"C47*1000/(2000*0.4536)","v":13648336.984035278},null,null,{"$f":"C48*100*0.5","v":682416849.20176387},"btu of energy avail (theoretical)","*Staff to Fix; This Cell has Formula Dependents"]
[null,"Bagasse yield: wet tonne per wet tonne of sugarcane",0.28000000000000003,null,"OR-GREET 3.0"]
[null,"Moisture in bagasse",0.5,null,"OR-GREET 3.0",{"$f":"F48*0.3","v":204725054.76052916},"combustion efficiency","*Staff to Fix; This Cell has Formula Dependents"]
[null,"Steam generation efficiency",0.8,null,"OR-GREET 3.0",{"$f":"F50*0.8","v":163780043.80842334},"steam boiler efficiency","*Staff to Fix; This Cell has Formula Dependents"]
[null,"Power Generation Efficiency",0.3,null,"OR-GREET 3.0",{"$f":"F51*0.99","v":162142243.3703391},"electrical generator efficiency","*Staff to Fix; This Cell has Formula Dependents"]
[null,"l. Sugarcane bagasse, emissions, grams/mmBtu fuel burned","Small Industrial Boiler",null,"OR-GREET 3.0",{"$f":"F52/3412.96","v":47507.806528743109},"kWh"]
[null,"m. Electricity Mix emissions, grams/mmBtu Available at User Sites","Brazil Electricity Mix",null,"OR-GREET 3.0",{"$f":"F53/0.99","v":47987.683362366777}]
[null,"n. Electric Transmission and Distribution Loss","8.1% (Brazil)",null,"OR-GREET 3.0"]
[null,"o.  Global Warming Potentials of GHGs"]
[null,"      Carbon and Sulfur Ratios of Pollutants",null,"GWP relative to CO2"]
[null,"Carbon ratio of VOC",0.85,{"$f":"C58/C61","v":3.1166666666666667},"OR-GREET 3.0"]
[null,"Carbon ratio of CO",{"$f":"12/28","v":0.42857142857142855},{"$f":"C59/C61","v":1.5714285714285714},"OR-GREET 3.0"]
[null,"Carbon ratio of CH4",{"$f":"12/16","v":0.75}]
[null,"Carbon ratio of CO2",{"$f":"12/44","v":0.27272727272727271}]
[null,"Sulfur ratio of SO2",{"$f":"32/64","v":0.5}]
[]
[]
[]
[null,"1. Gopal, A. and Kammen, D., 2009.  “Molasses for ethanol: the economic and environmental impacts of a new pathway for the "]
[null,"lifecycle greenhouse gas analysis of sugarcane ethanol,” (Table 1), Gopal, A., and Kammen, D., Environmental Research Letters, 4 (2009) 044005 (5pp)."]
[]
[]
[]
[]
[]
[null,"Ethanol fuel properties"]
[]
[null,"Density of EtOH, grams/gal",null,2988,"(OR-GREET 3.0)"]
[null,null,null,"LHV","Ton to MT",null,null,"Btu/dry m.t. "]
[null,"Sugarcane bagasse, Btu/ton",null,12381771.311916806,0.90720000000000001,null,"Bagasse, Btu/metric ton",{"$f":"'Old Fuel_Specs'!D77/E77","v":13648336.98403528}]
[null,"Bagasse yield: wet tonne per wet tonne of sugarcane",0.28000000000000003,null,null,null,"steam generation efficiency",0.8]
[null,"Moisture in bagasse",0.5,null,null,null,"Power Generation Efficiency",0.3]
[null,null,null,null,null,null,"Less Enthalpy of Steam Leaving the Steam Generator* (assume steam is saturated at exit of turbine/steam generator)"]
[]
[null,null,null,null,null,null,"Hv,sat  =  1194.4 Btu/lb",{"$f":"1194.4*2.2046","v":2633.1742400000003},"Btu/kg"]
[null,null,null,null,null,null,"(150 psi, 358 F)",{"$f":"H82*1000","v":2633174.2400000002},"Btu/tonne"]