{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Summary","Calculator","EF Tables","EF General","Fuel_Specs"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":6,"defined_names":187,"comments":2,"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":"Summary","index":0,"n_rows":48,"n_cols":13,"rows_kept":48,"cut":false,"hidden":false,"merged":[[1,3,1,7],[6,2,6,4],[6,6,6,7],[2,3,2,5],[2,6,2,7],[5,2,5,3],[3,3,3,5],[3,6,3,7]]}
[]
[null,null,"                                                ","Summary of the Tier 1 Sugarcane-derived Ethanol Pathway\nRelease Date:  August 13, 2018 (corrected)         "]
[null,null,"Applicant:",{"$f":"\" \" &Calculator!C21","v":" "},null,null,{"$f":"\"Location: \" &Calculator!F21","v":"Location: "}]
[null,null,"Description:","Ethanol produced from Sugarcane Juice and Molasses, and exported to California by Ocean Tanker.",null,null,{"$f":"\"Application Number: \" &Calculator!C23","v":"Application Number: "}]
[]
[null,null,"Feedstock Production Electricity Mix",null,{"$f":"Calculator!I23","v":"29-Brazilian Mix"},null,"Fuel Production Electricity Mix",{"$f":"Calculator!I23","v":"29-Brazilian Mix"}]
[null,null,"Feedstock Production",null,null,null,"Fuel Production",null,null,"Carbon Intensity (gCO2e/MJ)","Conservative Margin of Safety (gCO2e/MJ)","Total Carbon Intensity (gCO2e/MJ)","Correspondent Volume (gallons)"]
[null,null,"Feedstock Production","Column2","Column1",null,"Fuel Production","Column1"]
[null,null,"Amount of Sugarcane Procured, metric tonnes ",null,null,null,"Total Undenatured Ethanol Volume, gallons",{"$f":"H10+H11","v":0},null,{"$f":"H15","v":"0.0"},0,{"$f":"J9+K9","v":0},{"$f":"H14","v":0}]
[null,null,null,"Propria and Terceiros (in Portuguese)",{"$f":"Calculator!G$59","v":0},null,"Undenatured Ethanol from Cane Juice, dry gallons",{"$f":"Calculator!G$86","v":0}]
[null,null,"Ethanol Yield, gal/metric tonne sugarcane",null,{"$f":"IFERROR((Calculator!F$86*Calculator!F$84+Calculator!G$86*Calculator!G$84)/(Calculator!F$86+Calculator!G$86),\"0\")","v":"0"},null,"Undenatured Ethanol from Molasses, dry gallons",{"$f":"Calculator!F$86","v":0}]
[]
[null,null,"Feedstock Transport",null,null,null,"Total Denatured Ethanol Volume, gallons"]
[null,null,null,"From Field to Ethanol Plant","MDD Truck",null,"Anhydrous Denatured Ethanol Volume, dry gal",{"$f":"Calculator!$S$59*(1-Calculator!$R$59)*264.1596/(1-'EF Tables'!$D$113)","v":0}]
[null,null,null,"Shares",1,null,"Total Well-to Tank CI, gCO2e/MJ",{"$f":"Calculator!G17","v":"0.0"}]
[null,null,null,"Miles",2]
[null,null,null,"From Field to Ethanol Plant","HDD Truck",null,"Energy Consumption"]
[null,null,null,"Shares",1,null,"Residual Oil (Btu/gal)",300]
[null,null,null,"Miles",{"$f":"IFERROR((Calculator!D59*Calculator!C59+Calculator!E59*Calculator!F59)/(Calculator!C59+Calculator!E59)/1.609,\"0\")","v":"0"},null,"Biomass (Btu/gal)",{"$f":"IFERROR(E10*0.28*0.5*13648337/H9,\"0\")","v":"0"}]
[null,null,null,null,null,null,"Electricity, (kWh/gal)",{"$f":"IFERROR(Calculator!M59/(Calculator!X59*64.1593),\"0\")","v":"0"}]
[null,null,"Co-Product Credit, Cogenerated Electricity Exports"]
[null,null,null,"Net Cogenerated Surplus Electricity Exported (kWh/yr)",{"$f":"IF(Calculator!I21=\"Yes\",(Calculator!N59-Calculator!M59),0)","v":0},null,"Chemical Usage"]
[null,null,null,"Total Annual Ethanol Produced (gal)",{"$f":"Calculator!G94","v":0},null,"Lime (grams/tonne cane), standard value",880]
[null,null,null,"Co-Product Credit Before Allocation (kWh/gal)",{"$f":"Calculator!L95","v":"0.0"}]
[null,null,null,null,null,null,"Fuel Transport"]
[null,null,"Mechanized Harvesting Level",null,null,null,"By HD Truck from Ethanol Plant to Port, miles",{"$f":"Calculator!C27/1.609","v":0}]
[null,null,null," Fraction Sugarcane Harvested Mechanically",{"$f":"Calculator!K$23","v":""},null,"By Ocean Transport to California Port, miles",{"$f":"Calculator!E27/1.609","v":0}]
[null,null,null,"Burn Area Evaluation Method",{"$f":"Calculator!K21","v":0},null,"Route",{"$f":"Calculator!E26","v":0}]
[]
[]
[null,null,"Filter Cake Transport","Miles",{"$f":"Calculator!H59/1.609","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Via Panama Canal"]
[null,null,"Via Panama Canal"]
[null,null,"Via Cape Horn"]
[null,null,"Via Strait of Magellan"]

{"sheet":"Calculator","index":1,"n_rows":226,"n_cols":53,"rows_kept":226,"cut":false,"hidden":false,"merged":[[30,18,30,21],[24,1,24,6],[180,11,181,11],[180,5,181,5],[171,2,171,3],[175,2,175,3],[176,8,176,9],[82,1,82,4],[153,2,153,3],[150,1,150,2],[175,8,175,9],[174,8,174,9],[173,8,173,9],[171,8,171,9],[170,8,170,9],[63,21,63,22],[64,21,64,22],[159,6,160,6],[159,12,160,12],[156,8,156,9],[149,1,149,12],[73,7,73,10],[75,7,75,10],[155,5,156,5],[155,11,156,11],[182,5,183,5],[184,5,185,5],[15,4,15,5],[15,1,15,2],[14,1,14,2],[14,4,14,5],[21,2,21,3],[19,1,19,10],[150,7,150,8],[176,2,176,3],[156,2,156,3],[155,6,156,6],[168,2,168,3],[169,2,169,3],[174,2,174,3],[173,2,173,3],[21,5,21,6],[72,1,72,5],[1,12,1,15],[2,12,2,15],[3,12,3,15],[4,12,4,15],[11,1,11,6],[1,4,1,7],[7,1,7,10],[8,1,8,10],[9,1,9,10],[1,8,1,10],[2,8,2,10],[3,8,3,10],[4,8,4,10],[5,8,5,10],[12,7,12,8],[13,1,13,2],[13,4,13,5],[13,7,13,8],[20,5,20,6],[16,1,16,5],[20,2,20,3],[22,5,22,6],[83,1,83,4],[79,1,79,4],[80,1,80,4],[78,1,78,4],[81,1,81,4],[71,1,71,5],[73,1,73,5],[22,2,22,3],[74,1,74,5],[31,1,31,11],[69,7,69,10],[77,7,77,10],[78,7,78,10],[64,1,64,10],[79,7,79,10],[31,12,31,23],[151,7,151,8],[92,1,92,11],[170,2,170,3],[69,1,69,6],[68,1,68,10],[63,1,63,10],[127,1,127,13],[70,1,70,6],[169,8,169,9],[168,8,168,9],[153,8,153,9],[151,1,151,2],[155,12,156,12],[85,1,85,3],[138,1,138,13]]}
[]
[null,null,null,null,null,null,null,null,"Yellow Cells require User Input"]
[null,null,null,null,null,null,null,null,"Light Blue Cells show CI results "]
[null,null,null,null,null,null,null,null,"Green Cells show the calculation button"]
[null,null,null,null,null,null,null,null,"Gray Cells are Intermediate or Calculated Values"]
[]
[]
[null,"Tier 1 Simplified CI Calculator for Sugarcane-derived Ethanol"]
[]
[]
[]
[null,"Pathway Summary and Calculated CI (gCO2e/MJ)"]
[null,"Pathway Summary:","Sugarcane-based Ethanol produced in Brazil; transported to California for use as a transportation fuel."]
[null,"Sugarcane Molasses-based Ethanol CI",null,{"$f":"IFERROR(N$148,\"0.0\")","v":"0.00"},"Sugarcane Juice-based Ethanol CI",null,{"$f":"IFERROR(N$137,\"0.00\")","v":"0.00"}]
[null,"Ethanol Volume (Molasses Feedstock), gal",null,{"$f":"F$86","v":0},"Ethanol Volume (Sugarcane Juice Feedstock), gal",null,{"$f":"G$86","v":0}]
[null,"Ethanol Yield (Molasses Feedstock), gal/tonne sugarcane",null,{"$f":"F$84","v":0},"Ethanol Yield (Juice Feedstock), gal/tonne sugarcane",null,{"$f":"IF(O$59=100%,0,G$84)","v":0}]
[null,"Composite CI (gCO2e/MJ):",null,null,null,null,{"$f":"IFERROR((D14*D15+G14*G15)/(D15+G15),\"0.0\")","v":"0.0"}]
[]
[]
[null,"Section 1:  Applicant & Mill Specific Information"]
[null,"1.1  Company Name",null,null,"1.4  Mill Location, including State/Country",null,null,"1.7 Credit for Export of Net Surplus Cogenerated Electricity",null,"1.10 Choose Applicable Burn Area Evaluation for Cane Farms, then Click \"SELECT\" button"]
[null,"1.2  Company or Facility ID",null,null,"1.5  Harvest Cycle",null,null,"1.8  Electric Transmission and Distribution Loss",8.1000000000000003E-2,"1.11  Reference Year for Burn Area Evaluation",2017]
[null,"1.3  Application Number",null,null,"1.6  Provisional Pathway Application?",null,null,"1.9  Regional Electric Mix (Feedstock/Fuel)","29-Brazilian Mix","1.12  Applicable Mechanized Harvesting Credit (2, 7).",{"$f":"IF(K21=\"\",\"\",IF($K$21=\"Standard for Sao Paulo State\",80%,65%))","v":""}]
[]
[null,"Section 2:  Finished Fuel Transport Information"]
[null,"2.1  Anhydrous Ethanol Volume Transported by Truck (dry gal)",{"$f":"IF(S$59>0,$S$59*(1-$R$59)*264.1593,\"\")","v":""},"2.3  Anhydrous Ethanol Ocean Transport Route to California",null,"2.5  Ethanol Transport Distance by Truck from California Port to Terminal (miles)",{"$f":"40","v":40}]
[null," 2.2  Anhydrous Ethanol Transport Distance (km) by Truck to Port",null,"2.4  Anhydrous Ethanol Transport Distance by Ocean Tanker to California (km)",null,"2.6  Ethanol Transport Distance by Truck from California Terminal to Refueling Station (miles)",50]
[null,null,null,null,null,null,null,null,null,"Via Panama Canal"]
[null,null,null,null,null,null,null,null,null,"Via Strait of Magellan"]
[null,null,null,null,null,null,null,null,null,"Via Cape Horn"]
[]
[null,"Section 3:  Monthly Feedstock, Fuel, and Co-Product Production Data",null,null,null,null,null,null,null,null,null,null,"Section 3:  Monthly Feedstock, Fuel, and Co-Product Production Data"]
[null,"3.1  Reporting Month (MM/YYYY)"," 3.2  Cane Sourced from Applicant-owned Farms (Propria Farms)","3.3  Transport Distance of Cane Sourced from Applicant-Owned Farms (weighted average)"," 3.4  Cane Purchased from Partnership Farms (Terceiros Farms)","3.5  Transport Distance of Cane Sourced from Partnership Farms (weighted average distance)","3.6  Total Sugarcane Procured (Calculated)","3.7  Filter Cake Transport & Distribution Distance (1)","3.8  Amount of Externally Acquired or Purchased Bagasse","3.9  Amount of Electricity Generated from Externally Acquired or Purchased Bagasse (9)","3.10  Amount of Externally Acquired or Purchased Molasses","3.11 Amount of Ethanol Produced from Externally Acquired or Purchased Molasses","3.12  Amount of Purchased Electricity from the Grid","3.13  Surplus Electricity Cogenerated and Exported","3.14  Juice Allocated to Sugar Production (weighted average) (3)","3.15  Fraction Sucrose Entering Sugar Production (monthly weighted average) (4)","3.16  Anhydrous Ethanol Production (Reported at 20 C / 68 F) (10)","3.17  Moisture Content (Anhydrous Ethanol)","3.18  Adjusted Anhydrous Ethanol Production (5, 10)","3.19  Hydrous Ethanol Production (Reported at 20 C / 68 F) (10)","3.20  Moisture Content (Hydrous Ethanol)","3.21  Adjusted Hydrous Ethanol Production (5, 10))","3.22  Amount of Finished/Table Sugar Produced","3.23  Total Ethanol Production (Reported at 20 C / 68 F) (10)"]
[null,"Production Data","Metric Tons","Km","Metric Tons","Km","Metric Tons","Km","Metric Tons","kWh","Metric Tons","m3","kWh","kWh","%","\"0.000\"","m3","%","wet m3","m3","%","wet m3","Metric Tons"," (dry m3)"]
[null,null,null,null,null,null,{"$f":"IFERROR(IF((C35+E35)>0,(C35+E35),\"0\"),\"\")","v":"0"},{"$f":"IFERROR(((C35*D35+E35*F35)/G35)+2/AN$59,\"0\")","v":"0"},null,{"$f":"IF((I35*(Fuel_Specs!$C$48-$D$215)*Fuel_Specs!$C$50*Fuel_Specs!$C$51*Fuel_Specs!$C$52/kWh2Btu)>0,(I35*(Fuel_Specs!$C$48-$D$215)*Fuel_Specs!$C$50*Fuel_Specs!$C$51*Fuel_Specs!$C$52/kWh2Btu),0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF((Q35-L35*$Q$60)>0,(Q35-L35*$Q$60),0),\"0\")","v":"0"},null,null,{"$f":"IFERROR(IF((T35-L35*$T$60)>0,(T35-L35*$T$60),0),\"0\")","v":"0"},null,{"$f":"IFERROR(S35*(1-R35)+V35*(1-U35),\"0\")","v":0}]
[null,null,null,null,null,null,{"$f":"IFERROR(IF((C36+E36)>0,(C36+E36),\"0\"),\"\")","v":"0"},{"$f":"IFERROR(((C36*D36+E36*F36)/G36)+2/AN$59,\"0\")","v":"0"},null,{"$f":"IF((I36*(Fuel_Specs!$C$48-$D$215)*Fuel_Specs!$C$50*Fuel_Specs!$C$51*Fuel_Specs!$C$52/kWh2Btu)>0,(I36*(Fuel_Specs!$C$48-$D$215)*Fuel_Specs!$C$50*Fuel_Specs!$C$51*Fuel_Specs!$C$52/kWh2Btu),0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF((Q36-L36*$Q$60)>0,(Q36-L36*$Q$60),0),\"0\")","v":"0"},null,null,{"$f":"IFERROR(IF((T36-L36*$T$60)>0,(T36-L36*$T$60),0),\"0\")","v":"0"},null,{"$f":"IFERROR(S36*(1-R36)+V36*(1-U36),\"0\")","v":0}]
[null,null,null,null,null,null,{"$f":"IFERROR(IF((C37+E37)>0,(C37+E37),\"0\"),\"\")","v":"0"},{"$f":"IFERROR(((C37*D37+E37*F37)/G37)+2/AN$59,\"0\")","v":"0"},null,{"$f":"IF((I37*(Fuel_Specs!$C$48-$D$215)*Fuel_Specs!$C$50*Fuel_Specs!$C$51*Fuel_Specs!$C$52/kWh2Btu)>0,(I37*(Fuel_Specs!$C$48-$D$215)*Fuel_Specs!$C$50*Fuel_Specs!$C$51*Fuel_Specs!$C$52/kWh2Btu),0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF((Q37-L37*$Q$60)>0,(Q37-L37*$Q$60),0),\"0\")","v":"0"},null,null,{"$f":"IFERROR(IF((T37-L37*$T$60)>0,(T37-L37*$T$60),0),\"0\")","v":"0"},null,{"$f":"IFERROR(S37*(1-R37)+V37*(1-U37),\"0\")","v":0},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,null,null,null,null,null,{"$f":"IFERROR(IF((C38+E38)>0,(C38+E38),\"0\"),\"\")","v":"0"},"0",null,{"$f":"IF((I38*(Fuel_Specs!$C$48-$D$215)*Fuel_Specs!$C$50*Fuel_Specs!$C$51*Fuel_Specs!$C$52/kWh2Btu)>0,(I38*(Fuel_Specs!$C$48-$D$215)*Fuel_Specs!$C$50*Fuel_Specs!$C$51*Fuel_Specs!$C$52/kWh2Btu),0)","v":0},null,null,null,null,null,null,null,null,"0",null,null,"0",null,0]
[null,null,null,null,null,null,{"$f":"IFERROR(IF((C39+E39)>0,(C39+E39),\"0\"),\"\")","v":"0"},"0",null,{"$f":"IF((I39*(Fuel_Specs!$C$48-$D$215)*Fuel_Specs!$C$50*Fuel_Specs!$C$51*Fuel_Specs!$C$52/kWh2Btu)>0,(I39*(Fuel_Specs!$C$48-$D$215)*Fuel_Specs!$C$50*Fuel_Specs!$C$51*Fuel_Specs!$C$52/kWh2Btu),0)","v":0},null,null,null,null,null,null,null,null,"0",null,null,"0",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"Choices for Field 1.6:"]
[null,null,null,null,null,null,"0","0",null,{"$f":"IF((I40*(Fuel_Specs!$C$48-$D$215)*Fuel_Specs!$C$50*Fuel_Specs!$C$51*Fuel_Specs!$C$52/kWh2Btu)>0,(I40*(Fuel_Specs!$C$48-$D$215)*Fuel_Specs!$C$50*Fuel_Specs!$C$51*Fuel_Specs!$C$52/kWh2Btu),0)","v":0},null,null,null,null,null,null,null,null,"0",null,null,"0",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,null,null,null,null,null,"0","0",null,{"$f":"IF((I41*(Fuel_Specs!$C$48-$D$215)*Fuel_Specs!$C$50*Fuel_Specs!$C$51*Fuel_Specs!$C$52/kWh2Btu)>0,(I41*(Fuel_Specs!$C$48-$D$215)*Fuel_Specs!$C$50*Fuel_Specs!$C$51*Fuel_Specs!$C$52/kWh2Btu),0)","v":0},null,null,null,null,null,null,null,null,"0",null,null,"0",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[null,null,null,null,null,null,"0","0",null,{"$f":"IF((I42*(Fuel_Specs!$C$48-$D$215)*Fuel_Specs!$C$50*Fuel_Specs!$C$51*Fuel_Specs!$C$52/kWh2Btu)>0,(I42*(Fuel_Specs!$C$48-$D$215)*Fuel_Specs!$C$50*Fuel_Specs!$C$51*Fuel_Specs!$C$52/kWh2Btu),0)","v":0},null,null,null,null,null,null,null,null,"0",null,null,"0",null,0]
[null,null,null,null,null,null,"0","0",null,{"$f":"IF((I43*(Fuel_Specs!$C$48-$D$215)*Fuel_Specs!$C$50*Fuel_Specs!$C$51*Fuel_Specs!$C$52/kWh2Btu)>0,(I43*(Fuel_Specs!$C$48-$D$215)*Fuel_Specs!$C$50*Fuel_Specs!$C$51*Fuel_Specs!$C$52/kWh2Btu),0)","v":0},null,null,null,null,null,null,null,null,"0",null,null,"0",null,0]
[null,null,null,null,null,null,"0","0",null,{"$f":"IF((I44*(Fuel_Specs!$C$48-$D$215)*Fuel_Specs!$C$50*Fuel_Specs!$C$51*Fuel_Specs!$C$52/kWh2Btu)>0,(I44*(Fuel_Specs!$C$48-$D$215)*Fuel_Specs!$C$50*Fuel_Specs!$C$51*Fuel_Specs!$C$52/kWh2Btu),0)","v":0},null,null,null,null,null,null,null,null,"0",null,null,"0",null,0]
[null,null,null,null,null,null,"0","0",null,{"$f":"IF((I45*(Fuel_Specs!$C$48-$D$215)*Fuel_Specs!$C$50*Fuel_Specs!$C$51*Fuel_Specs!$C$52/kWh2Btu)>0,(I45*(Fuel_Specs!$C$48-$D$215)*Fuel_Specs!$C$50*Fuel_Specs!$C$51*Fuel_Specs!$C$52/kWh2Btu),0)","v":0},null,null,null,null,null,null,null,null,"0",null,null,"0",null,0]
[null,null,null,null,null,null,"0","0",null,{"$f":"IF((I46*(Fuel_Specs!$C$48-$D$215)*Fuel_Specs!$C$50*Fuel_Specs!$C$51*Fuel_Specs!$C$52/kWh2Btu)>0,(I46*(Fuel_Specs!$C$48-$D$215)*Fuel_Specs!$C$50*Fuel_Specs!$C$51*Fuel_Specs!$C$52/kWh2Btu),0)","v":0},null,null,null,null,null,null,null,null,"0",null,null,"0",null,0]
[null,null,null,null,null,null,"0","0",null,{"$f":"IF((I47*(Fuel_Specs!$C$48-$D$215)*Fuel_Specs!$C$50*Fuel_Specs!$C$51*Fuel_Specs!$C$52/kWh2Btu)>0,(I47*(Fuel_Specs!$C$48-$D$215)*Fuel_Specs!$C$50*Fuel_Specs!$C$51*Fuel_Specs!$C$52/kWh2Btu),0)","v":0},null,null,null,null,null,null,null,null,"0",null,null,"0",null,0]
[null,null,null,null,null,null,"0","0",null,{"$f":"IF((I48*(Fuel_Specs!$C$48-$D$215)*Fuel_Specs!$C$50*Fuel_Specs!$C$51*Fuel_Specs!$C$52/kWh2Btu)>0,(I48*(Fuel_Specs!$C$48-$D$215)*Fuel_Specs!$C$50*Fuel_Specs!$C$51*Fuel_Specs!$C$52/kWh2Btu),0)","v":0},null,null,null,null,null,null,null,null,"0",null,null,"0",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"g2T",null,1.1023100000000001E-6]
[null,null,null,null,null,null,"0","0",null,{"$f":"IF((I49*(Fuel_Specs!$C$48-$D$215)*Fuel_Specs!$C$50*Fuel_Specs!$C$51*Fuel_Specs!$C$52/kWh2Btu)>0,(I49*(Fuel_Specs!$C$48-$D$215)*Fuel_Specs!$C$50*Fuel_Specs!$C$51*Fuel_Specs!$C$52/kWh2Btu),0)","v":0},null,null,null,null,null,null,null,null,"0",null,null,"0",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"gal2L",null,3.7854109999999999]
[null,null,null,null,null,null,"0","0",null,{"$f":"IF((I50*(Fuel_Specs!$C$48-$D$215)*Fuel_Specs!$C$50*Fuel_Specs!$C$51*Fuel_Specs!$C$52/kWh2Btu)>0,(I50*(Fuel_Specs!$C$48-$D$215)*Fuel_Specs!$C$50*Fuel_Specs!$C$51*Fuel_Specs!$C$52/kWh2Btu),0)","v":0},null,null,null,null,null,null,null,null,"0",null,null,"0",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"MT2T",null,1.102311311]
[null,null,null,null,null,null,"0","0",null,{"$f":"IF((I51*(Fuel_Specs!$C$48-$D$215)*Fuel_Specs!$C$50*Fuel_Specs!$C$51*Fuel_Specs!$C$52/kWh2Btu)>0,(I51*(Fuel_Specs!$C$48-$D$215)*Fuel_Specs!$C$50*Fuel_Specs!$C$51*Fuel_Specs!$C$52/kWh2Btu),0)","v":0},null,null,null,null,null,null,null,null,"0",null,null,"0",null,0]
[null,null,null,null,null,null,"0","0",null,{"$f":"IF((I52*(Fuel_Specs!$C$48-$D$215)*Fuel_Specs!$C$50*Fuel_Specs!$C$51*Fuel_Specs!$C$52/kWh2Btu)>0,(I52*(Fuel_Specs!$C$48-$D$215)*Fuel_Specs!$C$50*Fuel_Specs!$C$51*Fuel_Specs!$C$52/kWh2Btu),0)","v":0},null,null,null,null,null,null,null,null,"0",null,null,"0",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"m32gal",null,264.17210710000001]
[null,null,null,null,null,null,"0","0",null,{"$f":"IF((I53*(Fuel_Specs!$C$48-$D$215)*Fuel_Specs!$C$50*Fuel_Specs!$C$51*Fuel_Specs!$C$52/kWh2Btu)>0,(I53*(Fuel_Specs!$C$48-$D$215)*Fuel_Specs!$C$50*Fuel_Specs!$C$51*Fuel_Specs!$C$52/kWh2Btu),0)","v":0},null,null,null,null,null,null,null,null,"0",null,null,"0",null,0]
[null,null,null,null,null,null,"0","0",null,{"$f":"IF((I54*(Fuel_Specs!$C$48-$D$215)*Fuel_Specs!$C$50*Fuel_Specs!$C$51*Fuel_Specs!$C$52/kWh2Btu)>0,(I54*(Fuel_Specs!$C$48-$D$215)*Fuel_Specs!$C$50*Fuel_Specs!$C$51*Fuel_Specs!$C$52/kWh2Btu),0)","v":0},null,null,null,null,null,null,null,null,"0",null,null,"0",null,0,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,"0","0",null,{"$f":"IF((I55*(Fuel_Specs!$C$48-$D$215)*Fuel_Specs!$C$50*Fuel_Specs!$C$51*Fuel_Specs!$C$52/kWh2Btu)>0,(I55*(Fuel_Specs!$C$48-$D$215)*Fuel_Specs!$C$50*Fuel_Specs!$C$51*Fuel_Specs!$C$52/kWh2Btu),0)","v":0},null,null,null,null,null,null,null,null,"0",null,null,"0",null,0,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,"0","0",null,{"$f":"IF((I56*(Fuel_Specs!$C$48-$D$215)*Fuel_Specs!$C$50*Fuel_Specs!$C$51*Fuel_Specs!$C$52/kWh2Btu)>0,(I56*(Fuel_Specs!$C$48-$D$215)*Fuel_Specs!$C$50*Fuel_Specs!$C$51*Fuel_Specs!$C$52/kWh2Btu),0)","v":0},null,null,null,null,null,null,null,null,"0",null,null,"0",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh2Btu",null,3412.141641601248]
[null,null,null,null,null,null,"0","0",null,{"$f":"IF((I57*(Fuel_Specs!$C$48-$D$215)*Fuel_Specs!$C$50*Fuel_Specs!$C$51*Fuel_Specs!$C$52/kWh2Btu)>0,(I57*(Fuel_Specs!$C$48-$D$215)*Fuel_Specs!$C$50*Fuel_Specs!$C$51*Fuel_Specs!$C$52/kWh2Btu),0)","v":0},null,null,null,null,null,null,null,null,"0",null,null,"0",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"Btu2J",null,1055.05585]
[null,null,null,null,null,null,"0","0",null,{"$f":"IF((I58*(Fuel_Specs!$C$48-$D$215)*Fuel_Specs!$C$50*Fuel_Specs!$C$51*Fuel_Specs!$C$52/kWh2Btu)>0,(I58*(Fuel_Specs!$C$48-$D$215)*Fuel_Specs!$C$50*Fuel_Specs!$C$51*Fuel_Specs!$C$52/kWh2Btu),0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF((Q58-L58*$Q$60)>0,(Q58-L58*$Q$60),0),\"0\")","v":"0"},null,null,{"$f":"IFERROR(IF((T58-L58*$T$60)>0,(T58-L58*$T$60),0),\"0\")","v":"0"},null,{"$f":"IFERROR(S58*(1-R58)+V58*(1-U58),\"0\")","v":0}]
[null,"2-Year Total",{"$f":"SUM(C35:C58)","v":0},{"$f":"IFERROR(SUMPRODUCT(C35:C58,D35:D58)/C59,0)","v":0},{"$f":"SUM(E35:E58)","v":0},{"$f":"IFERROR(SUMPRODUCT(E35:E58,F35:F58)/E$59,0)","v":0},{"$f":"IFERROR(SUM(G35:G58),\"\")","v":0},{"$f":"IFERROR(AVERAGE(H35:H58),\"0.0\")","v":"0.0"},{"$f":"SUM(I35:I58)","v":0},0,0,0,0,0,{"$f":"IFERROR(SUMPRODUCT($G35:$G58,$O35:$O58)/$G59,0)","v":0},{"$f":"IFERROR(SUMPRODUCT($G35:$G58,$P35:$P58)/$G$59,\"0.0\")","v":"0.0"},{"$f":"SUM(Q35:Q58)","v":0},{"$f":"IFERROR(SUMPRODUCT($Q35:$Q58*$R35:$R58)/$Q$59,\"0.00%\")","v":"0.00%"},{"$f":"SUM(S35:S58)","v":0},{"$f":"SUM(T35:T58)","v":0},{"$f":"IFERROR(SUMPRODUCT($T35:$T58*$U35:$U58)/$T$59,\"0.00%\")","v":"0.00%"},{"$f":"SUM(V35:V58)","v":0},{"$f":"IFERROR(SUM(W35:W58),\"0\")","v":0},{"$f":"IF(SUM(X34:X58)>0,SUM(X34:X58),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"km2mi",null,0.62137119223732995]
[null,"annual avg",null,null,"Mi ->",{"$f":"F61/1.609","v":0},null,{"$f":"H59*AN59","v":0},"<- Mi",null,null,null,null,null,null,null,{"$f":"Q59/(Q59+T59)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"1-Q60","v":{"$error":"#DIV/0!"}},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}]
[null,null,null,null,"Km: ->",{"$f":"IFERROR((SUMPRODUCT(C35:C58,D35:D58)+SUMPRODUCT(E35:E58,F35:F58))/(SUM(C35:C58)+SUM(E35:E58)),0)","v":0}]
[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(X59*264.1593>0,X59*264.1593,\"0\")","v":"0"}]
[]
[null,"Section 4:  Calculation of Production Yields and Mass Allocation Ratio "]
[null," Step 4a (6):  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 E88, and is set to a value of 0.0.  See instructions below to install the \"Solver Add-In\" functionality to your current version of Microsoft Excel.  "]
[null,"Step 4b:  Do not change any of the constraints defined in the window (see User Instruction documentation for Section 4).  Then Click the \"Solve\" Button."]
[null,"Step 4c:  The Solver will go through several iterations to find a solution.  A new window \"Solver Results\" will open up.  Solver will display the message that a solution has been found."]
[null,"Step 4d: Click OK. If a solution has not been found, then check the data for accuracy (Step 2), and then repeat Step 3 until a solution has been found, and all constriants and optimality conditions have been satisfied.  "]
[null," Step 4e:  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 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,"4.1  ηj (tonnes of fermentable sugars in juice/tonne of cane)",null,null,null,null,{"$f":"$P$59","v":"0.0"},"2.  Click or Select \"Options\" on the far Left Side Menu."]
[null,"4.2  ηs (tonnes of sucrose in final sugar/tonne of sucrose into sugar factory)",null,null,null,null,0.63253307049759833,"3.  A new Window \"Excel Options\" opens up.   Select \"Add-ins\" on the Left Side Menu."]
[null,"4.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,null,null,"Standard Value"]
[null,"4.4  ηe (dry tonnes of EtOH/tonne of fermentable sugars into distillery)",null,null,null,null,0.45227713625588484,"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,null,null,"User Defined "]
[null,"4.5  LHV of anhydrous EtOH (MMBtu/dry tonne EtOH)",null,null,"Select from the Drop Down Menu Below","Enter User Defined Values Below, if Applicable, then 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,null,null,"Standard Value"]
[null,"4.6  Choose ms (tonnes of sucrose in final sugar/tonne of final sugar product)",null,null,"Standard Value",0.995,{"$f":"IF(E77=\"Standard Value\",0.99,F77)","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,null,null,"User Defined "]
[null,"4.7  Choose mm (tonnes of fermentable sugars in std molasses/tonne of std molasses)",null,null,"Standard Value",0.52500000000000002,{"$f":"IF(E78=\"Standard Value\",0.5,F78)","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 delect \"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":"F80*$G$72*$G$73/$G$77","v":0},{"$f":"G80*$G$72*$G$73/$G$77","v":0}]
[null,"By-product molasses yield (tonnes of std molasses/tonnes of cane)",null,null,null,{"$f":"F80*$G$74/$G$78","v":0},{"$f":"G80*$G$74/$G$78","v":0}]
[null,"EtOH Yield (liters of EtOH/metric tonne cane)",null,null,null,{"$f":"$G$75*$G$72*(1-F80*$G$73)/(Fuel_Specs!$D$75*$AN$48/$AN$49)","v":0},{"$f":"$G$75*$G$72*(1-G80*$G$73)/(Fuel_Specs!$D$75*$AN$48/$AN$49)","v":0}]
[null,"EtOH Yield (gal of EtOH / metric tonne cane)",null,null,null,{"$f":"IF(O$59=0%,0,F83/$AN$49)","v":0},{"$f":"IF(O$59=100%,0,G83/$AN$49)","v":0}]
[null,null,null,null,null,"Molasses-Ethanol","Cane Juice-Ethanol"]
[null,"4.8  Modeled ethanol production (dry gal)",null,null,{"$f":"SUM(F86:G86)","v":0},{"$f":"F84*$O$59*$G$59","v":0},{"$f":"G84*(1-$O$59)*$G$59","v":0}]
[null,"4.9  Adjusted reported ethanol production (dry gal)",null,null,{"$f":"((SUMPRODUCT(S35:S58,(1-R35:R58))+SUMPRODUCT(V35:V58,(1-U35:U58)))*AN52)","v":0}]
[null,"4.10  Difference between  modeled and adjusted reported ethanol production numbers",null,null,{"$f":"E87-(F86+G86)","v":0}]
[null,"4.11  Modeled finished sugar production (metric tonnes)",null,null,{"$f":"F81*$O$59*$G$59","v":0}]
[null,"4.12  Reported finished sugar production (metric tonnes)",null,null,{"$f":"$W$59","v":0},{"$f":"ABS(E91)","v":0}]
[null,"4.13  Difference between modeled and reported Finished Sugar Production:",null,null,{"$f":"$W$59-$E$89","v":0},"4.14 Mass Allocation Ratio:",{"$f":"IFERROR(IF(O$59=0%,0,G74/G72),\"0.0\")","v":0}]
[]
[null,"Section 5:  Verify Fuel and Co-Product Production Information"]
[null,"5.1  Amount of Ethanol Produced from Cane Juice, dry gal",{"$f":"G$86","v":0},"5.3  Ethanol Volume from Molasses, dry gal",{"$f":"F$86","v":0},"5.5  Total Ethanol Volume Produced, dry gal",{"$f":"F86+G86","v":0},"5.7  Net Surplus Cogenerated Electricity Exported (kWh)",{"$f":"(N59-M59)","v":0},"5.9  Electricity Co-Product Credit (kWh/gal) (Molasses Feedstock)",{"$f":"IFERROR('EF Tables'!G$73,0)","v":0},"5.11  Composite Electricity Co-Product Credit (kWh/gal)"]
[null,"5.2  Cane Juice-to-Ethanol Yield (gal/wet tonne cane)",{"$f":"$G$84","v":0},"5.4  Molasses-to-Ethanol Yield (gal/wet tonne cane)",{"$f":"$F$84","v":0},"5.6  Total Amount of Finished Sugar Produced, metric tons",{"$f":"W59","v":0},"5.8  Net Electricity Credited to Pathway (kWh) (8)",{"$f":"IFERROR(I$94*(1-I$22)*O$59*G$91+I$94*(1-I$22)*(1-O$59),\"0\")","v":0},"5.10  Electricity Co-Product Credit (kWh/gal) (Cane Juice Feedstock)",{"$f":"IFERROR('EF Tables'!G$74,0)","v":0},{"$f":"IFERROR(IF($I$21=\"No\", 0, 'EF Tables'!G$75),\"0.0\")","v":"0.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,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,"29-Brazilian Mix"]
[null,"30-Canadian Mix"]
[null,"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 Ocean Transport Emissions (gCO2e/gal-mile)","Ethanol Truck Transport in California 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'!C$8+'EF Tables'!D$8),\"0.0\")","v":401.23786543013824},{"$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'!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($G$59>0,$G$59,\"-\")","v":"-"},{"$f":"$G$59","v":0},{"$f":"$G$59","v":0},0,{"$f":"CONCATENATE((N$59-M$59-J$59),\" kWh\")","v":"0 kWh"},{"$f":"$G$59","v":0},{"$f":"CONCATENATE(($C$27/1.609),\" total truck miles\")","v":"0 total truck miles"},{"$f":"CONCATENATE(E$27/1.609,\" ocean miles\")","v":"0 ocean miles"},{"$f":"CONCATENATE(G$26+G$27,\" miles\")","v":"90 miles"},{"$f":"$G$59","v":0},{"$f":"$G$59","v":0}]
[null,"Total Ethanol Produced (dry gal):",{"$f":"IF($X$59>0,$X$59*264.1596,\"-\")","v":"-"},{"$f":"$X$59*264.1596","v":0},0,0,0,0,{"$f":"$S$59*(1-$R$59)*264.1596","v":0},{"$f":"$S$59*(1-$R$59)*264.1596","v":0},{"$f":"$S$59*(1-$R$59)*264.1596/0.975","v":0},{"$f":"$S$59*(1-$R$59)*264.1596","v":0},{"$f":"$X$59*264.1596","v":0}]
[null,"Total Emissions (gCO2e)",{"$f":"IF(G$59>0,C130*$G$59,\"-\")","v":"-"},{"$f":"D130*(($H$59)/1.609)*(G$59)","v":0},{"$f":"E130*$G$59","v":0},0,{"$f":"-G130*(N$59-M$59-J$59)","v":0},{"$f":"H130*$X$59*264.1596","v":0},{"$f":"I130*((C$27/1.609))*I132*264.1596","v":0},{"$f":"J130*(J132)*((E$27/1.609))","v":0},{"$f":"K130*($G$26+$G$27)*K132","v":0},{"$f":"L130*L132","v":0},{"$f":"M130*($X$59*264.1596)","v":0}]
[null,"Emissions (Sugarcane for Sugar) (gCO2e)",{"$f":"IFERROR((C135/$G$91)-C135,\"-\")","v":"-"},{"$f":"IFERROR((D$135/$G$91)-D$135,\"-\")","v":"-"},{"$f":"E133-E136-E135","v":0},0,{"$f":"G133-G136-G135","v":0},{"$f":"IFERROR(H133-H136-H135,\"-\")","v":"-"},"-",{"$f":"IFERROR(J133-J136-J135,\"-\")","v":"-"},{"$f":"IFERROR(K133-K136-K135,\"-\")","v":"-"},0,{"$f":"IFERROR(M133-M136-M135,\"-\")","v":"-"}]
[null,"Emissions (Sugarcane for Molasses) (gCO2e)",{"$f":"IFERROR((C133-C136)*G$91,\"-\")","v":"-"},{"$f":"(D133-D136)*G$91","v":0},{"$f":"(E133-E136)*G91","v":0},0,{"$f":"(G133-G136)*G$91","v":0},{"$f":"IFERROR(H133-H136,\"-\")","v":"-"},"-",{"$f":"IFERROR(J133-J136,\"-\")","v":"-"},{"$f":"IFERROR(K133-K136,\"-\")","v":"-"},{"$f":"'EF Tables'!C$124*Calculator!F$86*76330*1055.06/10^6","v":0},{"$f":"IFERROR(M133-M136,\"-\")","v":"-"},{"$f":"IFERROR(M135+L135+K182+H135+J182+I135+G135+F135+E135+D135+C135,\"-\")","v":"-"}]
[null,"Emissions (Sugarcane for Juice) (gCO2e)",{"$f":"IFERROR(C133*(1-$O$59),\"-\")","v":"-"},{"$f":"D133*(1-O$59)","v":0},{"$f":"E133*(1-$O$59)","v":0},0,{"$f":"G133*(1-O$59)","v":0},{"$f":"IFERROR(H133*$G$86/($F$86+$G$86),\"-\")","v":"-"},"-",{"$f":"IFERROR(J133*$G$86/($F$86+$G$86),\"-\")","v":"-"},{"$f":"IFERROR(K133*$G$86/($F$86+$G$86),\"-\")","v":"-"},{"$f":"'EF Tables'!D$124*Calculator!G$86*76330*1055.06/10^6","v":0},{"$f":"IFERROR(M133*$G$86/($F$86+$G$86),\"-\")","v":"-"},{"$f":"IFERROR(M136+L136+H136+J183+K183+I136+G136+F136+E136+D136+C136,\"-\")","v":"-"}]
[null," CI Calc Using EF (gCO2e/MJ)",{"$f":"IF(O$59=100%,\"-\",IFERROR((C130*C131*((1-O$59)+$O$59*$G$91)/($C132*76330*1055.06/10^6)),\"-\"))","v":"-"},{"$f":"IF(O$59=100%,0,IFERROR(SUM(D$135:D$136)/((F$86+G$86)*76330*1055.06/10^6),0))","v":0},{"$f":"IF(O$59=100%,0,IFERROR((1-$K$23)*E130*G$59*((1-$O$59)+$O$59*$G$91)/($E132*76330*1055.06/10^6),0))","v":0},0,{"$f":"IF(O$59=100%,0,-G130*L$95/(76330*1055.06/10^6))","v":0},{"$f":"IF(X59=0,0,IF(O$59=100%,0,H130/(76330*1055.06/10^6)))","v":0},{"$f":"IF(X59=0,0,IF(O$59=100%,0,I130*((C$27/1.609))*10^6/(76330*1055.06)))","v":0},{"$f":"IF(X59=0,0,IF(O$59=100%,0,J130*((E$27/1.609)*10^6/(76330*1055.06))))","v":0},{"$f":"IF(X59=0,0,IF(O$59=100%,0,K130*($G$26+$G$27)*10^6/(76330*1055.06)))","v":0},{"$f":"IF(O$59=100%,0,L130/(76330*1055.06/10^6))","v":0},{"$f":"IF(X59=0,0,IF(O$59=100%,0,M130/(76330*1055.06/10^6)))","v":0},{"$f":"IF(O$59=100%,0,IFERROR(M137+L137+K137+J137+I137+H137+G137+F137+E137+D137+C137,\"0.00\"))","v":"0.00"}]
[]
[null,"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 Ocean Transport Emissions (gCO2e/gal-mile)","Ethanol Truck Transport in California 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'!C$8+'EF Tables'!D$8),\"0.0\")","v":401.23786543013824},{"$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'!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($G$59>0,$G$59,\"-\")","v":"-"},{"$f":"$G$59","v":0},{"$f":"$G$59","v":0},{"$f":"$G$59","v":0},{"$f":"CONCATENATE((N$59-M$59-J$59),\" kWh\")","v":"0 kWh"},{"$f":"$G$59","v":0},{"$f":"CONCATENATE(($C$27/1.609),\" total truck miles\")","v":"0 total truck miles"},{"$f":"CONCATENATE(E$27/1.609,\" ocean miles\")","v":"0 ocean miles"},{"$f":"CONCATENATE(G$26+G$27,\" miles\")","v":"90 miles"},{"$f":"$G$59","v":0},{"$f":"$G$59","v":0}]
[null,"Total Ethanol Produced (dry gal):",{"$f":"IF($X$59>0,$X$59*264.1596,\"-\")","v":"-"},{"$f":"$X$59*264.1596","v":0},0,0,0,0,{"$f":"$S$59*(1-$R$59)*264.1596","v":0},{"$f":"$S$59*(1-$R$59)*264.1596","v":0},{"$f":"$S$59*(1-$R$59)*264.1596/0.975","v":0},{"$f":"$S$59*(1-$R$59)*264.1596","v":0},{"$f":"$X$59*264.1596","v":0}]
[null,"Total Emissions (gCO2e)",{"$f":"IF(G$59>0,C141*$G$59,\"-\")","v":"-"},{"$f":"D141*(($H$59)/1.609)*(G$59)","v":0},{"$f":"E141*$G$59","v":0},{"$f":"F141*$G$59*O$59","v":0},{"$f":"-G141*(N$59-M$59-J$59)","v":0},{"$f":"H141*$X$59*264.1596","v":0},{"$f":"I141*((C$27/1.609))*I143*264.1596","v":0},{"$f":"J141*(J143)*((E$27/1.609))","v":0},{"$f":"K141*($G$26+$G$27)*K143","v":0},{"$f":"L141*L143","v":0},{"$f":"M141*($X$59*264.1596)","v":0}]
[null,"Emissions (Sugarcane for Sugar) (gCO2e)",{"$f":"IFERROR((C146/$G$91)-C146,\"-\")","v":"-"},{"$f":"IFERROR((D$135/$G$91)-D$135,\"-\")","v":"-"},{"$f":"E144-E147-E146","v":0},{"$f":"F$141*G$59*O$59","v":0},{"$f":"G144-G147-G146","v":0},{"$f":"IFERROR(H144-H147-H146,\"-\")","v":"-"},{"$f":"IFERROR(I144-I147-I146,\"-\")","v":"-"},{"$f":"IFERROR(J144-J147-J146,\"-\")","v":"-"},{"$f":"IFERROR(K144-K147-K146,\"-\")","v":"-"},0,{"$f":"IFERROR(M144-M147-M146,\"-\")","v":"-"}]
[null,"Emissions (Sugarcane for Molasses) (gCO2e)",{"$f":"IFERROR((C144-C147)*G$91,\"-\")","v":"-"},{"$f":"(D144-D147)*G$91","v":0},{"$f":"(E144-E147)*G91","v":0},{"$f":"F141*$G$59*G$91*O$59","v":0},{"$f":"(G144-G147)*G$91","v":0},{"$f":"IFERROR(H144-H147,\"-\")","v":"-"},{"$f":"IFERROR(I144-I147,\"-\")","v":"-"},{"$f":"IFERROR(J144-J147,\"-\")","v":"-"},{"$f":"IFERROR(K144-K147,\"-\")","v":"-"},{"$f":"'EF Tables'!C$124*Calculator!F$86*76330*1055.06/10^6","v":0},{"$f":"IFERROR(M144-M147,\"-\")","v":"-"}]
[null,"Emissions (Sugarcane for Juice) (gCO2e)",{"$f":"IFERROR(C144*(1-$O$59),0)","v":0},{"$f":"D144*(1-O$59)","v":0},{"$f":"E144*(1-$O$59)","v":0},0,{"$f":"G144*(1-O$59)","v":0},{"$f":"IFERROR(H144*$G$86/($F$86+$G$86),\"-\")","v":"-"},{"$f":"IFERROR(I144*$G$86/($F$86+$G$86),\"-\")","v":"-"},{"$f":"IFERROR(J144*$G$86/($F$86+$G$86),\"-\")","v":"-"},{"$f":"IFERROR(K144*$G$86/($F$86+$G$86),\"-\")","v":"-"},{"$f":"'EF Tables'!D$124*Calculator!G$86*76330*1055.06/10^6","v":0},{"$f":"IFERROR(M144*$G$86/($F$86+$G$86),\"-\")","v":"-"}]
[null," CI Calc Using EF (gCO2e/MJ)",{"$f":"IF(O$59=0%,\"-\",IFERROR(C141*C142*((1-O$59)+$O$59*$G$91)/($C143*76330*1055.06/10^6),0))","v":"-"},{"$f":"IF(O$59=0%,0,IFERROR(SUM(D$135:D$136)/((F$86+G$86)*76330*1055.06/10^6),\"0.0\"))","v":0},{"$f":"IF(O$59=0%,0,IFERROR((1-$K$23)*E141*G$59*((1-$O$59)+$O$59*$G$91)/($E143*76330*1055.06/10^6),\"0.0\"))","v":0},{"$f":"IF(O$59=0%,0,IFERROR(F141*G$59*$O$59*$G$91/($F$86*76330*1055.06/10^6),0))","v":0},{"$f":"IF(O$59=0%,0,-G141*L$95/(76330*1055.06/10^6))","v":0},{"$f":"IF(O$59=0%,0,H141/(76330*1055.06/10^6))","v":0},{"$f":"IF(O$59=0%,0,I141*((C$27/1.609))*10^6/(76330*1055.06))","v":0},{"$f":"IF(O$59=0%,0,J141*((E$27/1.609)*10^6/(76330*1055.06)))","v":0},{"$f":"IF(O$59=0%,0,K141*($G$26+$G$27)*10^6/(76330*1055.06))","v":0},{"$f":"IF(O$59=0%,0,L141/(76330*1055.06/10^6))","v":0},{"$f":"IF(O$59=0%,0,M141/(76330*1055.06/10^6))","v":0},{"$f":"IF(O$59=0%,\"0.00\",IF(O59=0,0,M148+L148+K148+J148+I148+H148+G148+F148+E148+D148+C148))","v":"0.00"}]
[]
[null," CI Calculations"]
[null,"Sugarcane Molasses-based Ethanol",null,null,null,"Juice-to-Sugar Share",{"$f":"Calculator!O59","v":0},"Sugarcane Juice-based Ethanol",null,null,null,"Juice-to-Fuel Share",{"$f":"1-G151","v":1}]
[null,"eGRID (Electricity Mix) region",null,{"$f":"I23","v":"29-Brazilian Mix"},"Value","Total Emissions (gCO2e)","CI, gCO2e/MJ","eGRID (Electricity Mix) region",null,{"$f":"I23","v":"29-Brazilian Mix"},"Value","Total Emissions (gCO2e)","CI, gCO2e/MJ"]
[null,"Feedstock Production","Sugarcane Farming",null,null,null,null,null,"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(O$59=0%,0,'EF Tables'!U$39),\"0.0\")","v":0},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($O$59=100%,0,'EF Tables'!U$40),\"0.0\")","v":"-"}]
[null,null,"Fertilizers and Agricultural Chemicals",null,null,{"$f":"CONCATENATE('EF Tables'!$V$38,\" per  m.t.cane\")","v":"8732.48871025698 per  m.t.cane"},{"$f":"IFERROR(IF(O$59=0%,0,'EF Tables'!Q$35),\"0.0\")","v":0},null,"Fertilizers and Ag Chemicals",null,null,{"$f":"CONCATENATE('EF Tables'!$V$38,\" per  m.t.cane\")","v":"8732.48871025698 per  m.t.cane"},{"$f":"IFERROR(IF($O$59=100%,0,'EF Tables'!R$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(O$59=0%,0,'EF Tables'!W$39),0)","v":0},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($O$59=100%,0,'EF Tables'!W$40),\"0.0\")","v":"-"}]
[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(O$59=0%,0,'EF Tables'!J$42),\"0.0\")","v":0},null,"Sugarcane Straw Burning in Field",null,null,null,{"$f":"IFERROR(IF($O$59=100%,0,'EF Tables'!J$43),\"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(O$59=0%,0,'EF Tables'!H$15),\"0.0\")","v":0},null,null,"Cane transport by MDT, miles",{"$f":"'EF Tables'!D8","v":2},null,{"$f":"IFERROR(IF($O$59=100%,0,'EF Tables'!H$16),\"0.0\")","v":0}]
[null,null,null,"Cane transport by HDDT, miles",{"$f":"IFERROR('EF Tables'!C$8,\"0.0\")","v":0},null,null,null,null,"Cane transport by HDDT, miles",{"$f":"IFERROR('EF Tables'!$C$8,\"0.0\")","v":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(E160:E161),\"0.0\")","v":2},null,{"$f":"IFERROR(IF(O$59=0%,0,'EF Tables'!E$27),\"0.0\")","v":0},null,null,"Filtercake transport by HDDT, miles",{"$f":"IFERROR(SUM(K160:K161),\"0.0\")","v":2},null,{"$f":"IFERROR(IF($O$59=100%,0,'EF Tables'!E$28),\"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":"K94","v":0},null,{"$f":"IFERROR(IF(O$59=0%,0,'EF Tables'!Q$71),\"0.0\")","v":0},null,null,"Net Surplus Cogenerated Electricity Export, kWh/gal",{"$f":"K95","v":0},null,{"$f":"IFERROR(IF($O$59=100%,0,'EF Tables'!R$71),\"0.0\")","v":"0.0"}]
[null,null,null,"Mechanized Harvesting (%)",{"$f":"K23","v":""},null,{"$f":"IFERROR(IF(O$59=0%,0,-'EF Tables'!J42*Calculator!E166),\"0.0\")","v":0},null,null,"Mechanized Harvesting (%)",{"$f":"K23","v":""},null,{"$f":"IFERROR(IF($O$59=100%,0,-'EF Tables'!J43*Calculator!K23),0)","v":0}]
[null,"Ethanol Production","Sugar Production (gCO2e/wet tonne cane)",null,{"$f":"'EF Tables'!C45","v":4078.4832451499119},null,{"$f":"IFERROR(IF(O$59=0%,0,'EF Tables'!Q44),0)","v":0},null,"Sugar Production (gCO2e/wet tonne cane)",null,{"$f":"'EF Tables'!C45","v":4078.4832451499119},null,{"$f":"0","v":0}]
[null,null,"Ethanol Production",null,null,null,null,null,"Ethanol Production"]
[null,null,"Total feedstock used, metric tonnes cane",null,{"$f":"$G$59*O59/2","v":0},null,null,null,"Total feedstock used, metric tonnes cane",null,{"$f":"($G$59*(1-O59))/2","v":0}]
[null,null,"Total undenatured ethanol, gallons",null,{"$f":"F86","v":0},null,null,null,"Total undenatured ethanol, gallons",null,{"$f":"G86","v":0}]
[null,null,"Ethanol Yield, gal ethanol / tonne cane",null,{"$f":"E95","v":0},null,null,null,"Ethanol Yield, gal ethanol / tonne cane",null,{"$f":"C95","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":"IF(O$59=0%,0,'EF Tables'!Q60)","v":0},null,"Non-biogenic (CH4/N2O) in Bagasse Combustion ",null,null,null,{"$f":"IFERROR(IF($O$59=100%,0,'EF Tables'!R60),\"0.0\")","v":0}]
[null,null,"Total Plant Energy Consumption, Btu/gal",null,{"$f":"E177+E174*3412.96","v":324.37536032000003},null,null,null,"Total Plant Energy Consumption, Btu/gal",null,{"$f":"K177+K174*3412.96","v":324.37536032000003}]
[null,null,"     Residual Oil (10% Lubricant Burned),  Btu/gal EtOH",null,300,null,{"$f":"IF(O$59=0%,0,'EF Tables'!Q54)","v":0},null,"     Residual Oil (10% Lubricant Burned),  Btu/gal EtOH",null,300,null,{"$f":"IF(X59=0,0,IF($O$59=100%,0,'EF Tables'!R$54))","v":0}]
[null,null,null,"Chemicals Usage (Lime, g/tonne cane)",880,null,{"$f":"IFERROR(IF(O$59=0%,0,'EF Tables'!Q55),\"0.0\")","v":0},null,null,"Chemicals Usage (Lime, g/tonne cane)",880,null,{"$f":"IF(X59=0,0,IF($O$59=100%,0,'EF Tables'!R$55))","v":0}]
[null,null,null,"Chemicals Usage (Yeast, g/gal ethanol) (11)",{"$f":"D226","v":3.3432768916330025},null,{"$f":"IFERROR(IF(O$59=0%,0,'EF Tables'!Q56),\"0.0\")","v":0},null,null,"Chemicals Usage (Yeast, g/gal ethanol) (11)",{"$f":"D226","v":3.3432768916330025},null,{"$f":"IF(X59=0,0,IF($O$59=100%,0,'EF Tables'!R$56))","v":0}]
[null,null,"Ethanol Transport and Distribution",null,null,null,{"$f":"IF(O$59=0%,0,SUM('EF Tables'!O91:O95))","v":0},null,"Ethanol Transport and Distribution",null,null,null,{"$f":"IF(X59=0,0,IF($O$59<100%,SUM('EF Tables'!P91:P95),0))","v":0}]
[null,null,null,"From Ethanol Plant to Brazil Port","Mode:  HDD Truck",{"$f":"CONCATENATE($C$26,\" dry gals\")","v":" dry gals"},null,null,null,"From Ethanol Plant to Brazil Port","Mode:  HDD Truck",{"$f":"CONCATENATE($C$26,\" dry gals\")","v":" dry gals"}]
[null,null,null,"Miles",{"$f":"$C$27/1.609","v":0},null,null,null,null,"Miles",{"$f":"$C$27/1.609","v":0}]
[null,null,null,"From Brazil Port to California Port","Mode: Ocean Tanker",1,null,null,null,"From Brazil Port to California Port","Mode: Ocean tanker",1]
[null,null,null,"Miles",{"$f":"$E$27/1.609","v":0},null,null,null,null,"Miles",{"$f":"$E$27/1.609","v":0}]
[null,null,null,"From California Port to Blending Terminal","Mode:  HDD Truck",1,null,null,null,"From California Port to Blending Terminal","Mode:  HDD Truck",1]
[null,null,null,"Miles",40,null,null,null,null,"Miles",40]
[null,null,null,"California Blending Terminal to Refueling Station","Mode:  HDD Truck",1,null,null,null,"California 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(X59=0,0,IF(O$59=0%,0,'EF Tables'!C124))","v":0},null,"Denaturant, g/MJ",null,null,null,{"$f":"IF(X59=0,0,IF($O$59=100%,0,'EF Tables'!D124))","v":0}]
[null,null,"Indirect Land Use, g/MJ",null,null,null,{"$f":"IF(X59=0,0,IF($O$59>0,11.8,0))","v":0},"Composite CI (gCO2e/MJ)","Indirect Land Use, g/MJ",null,null,null,{"$f":"IF(X59=0,0,IF($O$59=100%,0,11.8))","v":0}]
[null,null,"Total Well-to-Tank CI, g/MJ",null,null,null,{"$f":"IF(SUM(G154:G190)>0,SUM(G154:G190),\"0.00\")","v":"0.00"},{"$f":"IFERROR((G191*E170+M191*K170)/(E170+K170),\"0.0\")","v":"0.0"},"Total Well-to-Tank CI, g/MJ",null,null,null,{"$f":"IFERROR(SUM(M154:M190),0)","v":0}]
[]
[null,"Footnotes:"]
[null,"(1)  Filter Cake is assumed to be returned to the fields from where the sugarcane was harvested.  Hence it is the weighter 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 California/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/(D224*D225)","v":3.3432768916330025},"g yeast / gallon of ethanol."]

{"sheet":"EF Tables","index":2,"n_rows":185,"n_cols":23,"rows_kept":185,"cut":false,"hidden":false,"merged":[[119,2,119,3],[129,1,129,3],[128,1,128,3],[46,16,46,17],[49,16,49,17],[47,2,47,7],[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],[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],[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],[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]]}
["References for Sugarcane Ethanol Pathways"]
[]
["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":"Calculator!$F$60","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*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*Fuel_Specs!D59","v":1.619458137693091},null,"     VOC",{"$f":"Fuel_Specs!D58","v":3.1166666666666667}]
[null,"              CH4",0.46371655906083331,0.83702080652373223,{"$f":"$C$8*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":"Fuel_Specs!D59","v":1.5714285714285714}]
[null,"              N2O",1.0481701204258615E-3,1.8910417671681749E-3,{"$f":"$C$8*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":"$C$8*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(Calculator!G91*H14/(Calculator!E95*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/(Calculator!C95*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(Calculator!$G$91*E26/(Calculator!E$95*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/(Calculator!C$95*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":"Calculator!$K$23","v":""},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(Calculator!$K$23=80%,'EF Tables'!B161,'EF Tables'!I161)","v":1118.82},{"$f":"IF(Calculator!$K$23=80%,'EF Tables'!C161,'EF Tables'!J161)","v":311.07889999999998},{"$f":"IF(Calculator!$K$23=80%,'EF Tables'!D161,'EF Tables'!K161)","v":1237.405},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(Calculator!$K$23=80%,'EF Tables'!B162,'EF Tables'!I162)","v":7.3336517115510045},{"$f":"IF(Calculator!$K$23=80%,'EF Tables'!C162,'EF Tables'!J162)","v":8.2894910986113388E-2},{"$f":"IF(Calculator!$K$23=80%,'EF Tables'!D162,'EF Tables'!K162)","v":0.11647757618513754},2.1601620825538296E-2,9.0645915510573896E-2,6.0164466504487781E-3,1499.4000000000003,{"$f":"IF(K$30=\"\",\"0\",-J33*$K$30)","v":"0"},{"$f":"G9","v":0.29651688824799338},{"$f":"D21","v":4.7258974089490357E-4},{"$f":"SUM(C33:M33)","v":1517.7703321296283},null,null,{"$f":"IFERROR(U39,0)","v":"-"},{"$f":"IFERROR(U40,0)","v":"-"},null,"     VOC",{"$f":"(C33)","v":10.422054469930288},{"$f":"SUM(D33:I33)","v":7.651288181708817},{"$f":"\"-\"","v":"-"}]
[null,"     CO",89.462591301913264,{"$f":"IF(Calculator!$K$23=80%,'EF Tables'!B163,'EF Tables'!I163)","v":8.3440592186053681},{"$f":"IF(Calculator!$K$23=80%,'EF Tables'!C163,'EF Tables'!J163)","v":0.28628580615121307},{"$f":"IF(Calculator!$K$23=80%,'EF Tables'!D163,'EF Tables'!K163)","v":0.59541076632588319},6.7691478327730759E-2,0.60890024007568,5.6644478013006386E-2,19706.400000000001,"0",{"$f":"G10","v":1.0305642694410579},{"$f":"D22","v":1.643420633010114E-3},{"$f":"SUM(C34:M34)","v":19806.853790979487},null,null,"Fertilizer, and Herbicide/Insecticide Use",null,null,"     CO",{"$f":"C34","v":89.462591301913264},{"$f":"SUM(D34:I34)","v":9.9589919874988819},{"$f":"\"-\"","v":"-"}]
[null,"     CH4",26.843955459841467,{"$f":"IF(Calculator!$K$23=80%,'EF Tables'!B164,'EF Tables'!I164)","v":31.898502969875601},{"$f":"IF(Calculator!$K$23=80%,'EF Tables'!C164,'EF Tables'!J164)","v":0.49083740772447371},{"$f":"IF(Calculator!$K$23=80%,'EF Tables'!D164,'EF Tables'!K164)","v":1.1542662922765419},0.23384721567894584,1.6117190426016517,0.10760505321108269,578.34,"0",{"$f":"G11","v":1.8452839649994095},{"$f":"D23","v":2.9340090928231736E-3},{"$f":"SUM(C35:M35)","v":642.528951415302},null,null,{"$f":"IFERROR(Calculator!G91*$V$38/(Calculator!F84*76330*1055.06/10^6),0)","v":0},{"$f":"IFERROR($V$38/(Calculator!G84*76330*1055.06/10^6),0)","v":0},null,"     CH4",{"$f":"C35","v":26.843955459841467},{"$f":"SUM(D35:I35)","v":35.496777981368297},"-"]
[null,"     N2O",0.255953688148156,{"$f":"IF(Calculator!$K$23=80%,'EF Tables'!B165,'EF Tables'!I165)","v":4.533535545106381},{"$f":"IF(Calculator!$K$23=80%,'EF Tables'!C165,'EF Tables'!J165)","v":5.1475565829664895E-3},{"$f":"IF(Calculator!$K$23=80%,'EF Tables'!D165,'EF Tables'!K165)","v":1.2287479424627977E-2},7.8699736313397851E-4,1.5857843947861914E-2,9.1288993314194604E-4,14.994000000000003,"0",{"$f":"G12","v":4.1689633314995036E-3},{"$f":"D24","v":6.6319405767685678E-6},{"$f":"(SUM(C36:M36)+D40)","v":68.094980807677643},null,null,"N2O in Soil",null,null,"     N2O",{"$f":"C36","v":0.255953688148156},{"$f":"SUM(D36:I36)","v":4.5685283123581133},{"$f":"D40","v":48.272323211899298}]
[null,"     CO2",7386.4574356496732,{"$f":"IF(Calculator!$K$23=80%,'EF Tables'!B166,'EF Tables'!I166)","v":3062.216280972752},{"$f":"IF(Calculator!$K$23=80%,'EF Tables'!C166,'EF Tables'!J166)","v":180.10060029185848},{"$f":"IF(Calculator!$K$23=80%,'EF Tables'!D166,'EF Tables'!K166)","v":436.62938667188848},67.579295069710994,668.10471564844909,42.333708600624746,355469.2350000001,"0",{"$f":"G13","v":752.55767822310509},{"$f":"D25","v":1.1959229555632687},{"$f":"(SUM(C37:M37)+D38+F38+J38+K38)","v":-22646.402498916315},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":6444.1514642552829},"-"]
[null,"     CO2 from Land use change",null,{"$f":"IF(Calculator!$K$23=80%,'EF Tables'!B167,'EF Tables'!I167)","v":861.49147699999992},"CO2 from urea use",{"$f":"IF(Calculator!$K$23=80%,'EF Tables'!D167,'EF Tables'!K167)","v":1125.6960000000001},"CO2 from CaCO3 use",null,null,-392700.00000000006,"0","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":8732.4887102569846},{"$f":"W36*298","v":14385.15231714599}]
[null,"     VOC from bulk terminal",null,{"$f":"IF(Calculator!$K$23=80%,'EF Tables'!B168,'EF Tables'!I168)","v":40.90486096360506},"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(Calculator!G91*U38/(Calculator!$E$95*76330/10^6)/1055.06,\"-\")","v":"-"},{"$f":"IFERROR(Calculator!G91*V38/(Calculator!$E$95*76330/10^6)/1055.06,\"-\")","v":"-"},{"$f":"IFERROR($D$40*298*Calculator!$G$91/(Calculator!$E$95*76330*1055.06/10^6),\"-\")","v":"-"}]
[null,"     VOC from refueling station",null,{"$f":"IF(Calculator!$K$23=80%,'EF Tables'!B169,'EF Tables'!I169)","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/(Calculator!$C$95*76330/10^6)/1055.06,\"-\")","v":"-"},{"$f":"IFERROR(V38/(Calculator!$C$95*76330/10^6)/1055.06,\"-\")","v":"-"},{"$f":"IFERROR($D$40*298/(Calculator!$C$95*76330*1055.06/10^6),\"-\")","v":"-"}]
[null,null,null,null,null,null,null,null,"Total Straw Bunring gCO2e/tonne cane:",{"$f":"J33*3.12+J34*1.57+J35*25+J36*298+J37+J38","v":17313.12300000008},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(Calculator!G91*J41/(Calculator!E95*76330*1055.06/10^6),0)","v":0},{"$f":"IFERROR(-'EF Tables'!J42*Calculator!$K$23,0)","v":0}]
["IV.","Sugar Production Emissions ",null,null,null,null,null,null,"Total gCO2e/MJ (cane juice feedstock):",{"$f":"IFERROR($J$41/(Calculator!$C95*76330*1055.06/10^6),0)","v":0},{"$f":"IFERROR(-'EF Tables'!J43*Calculator!$K$23,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/Calculator!$F$84/Calculator!$AN$54)*Calculator!$G$91,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 (default yield)","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*21.4","v":3.8347792123353416E-2},{"$f":"IFERROR(D50*Calculator!G$91/Calculator!F$84,\"-\")","v":"-"},{"$f":"IFERROR(D50/Calculator!G$84,\"-\")","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*21.4","v":0.10066774041537641},{"$f":"IFERROR(D51*Calculator!G$91/Calculator!F$84,\"-\")","v":"-"},{"$f":"IFERROR(D51/Calculator!G$84,\"-\")","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*Calculator!G$91/Calculator!F$84,\"-\")","v":"-"},{"$f":"IFERROR(D52/Calculator!G$84,\"-\")","v":"-"},2.6746640682810869E-2,5.0725565976123205E-3]
[null,"     N2O",7.1677509707761416E-5,{"$f":"C53*21.4","v":1.5338987077460943E-3},{"$f":"IFERROR(D53*Calculator!G$91/Calculator!F$84,\"-\")","v":"-"},{"$f":"IFERROR(D53/Calculator!G$84,\"-\")","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*Calculator!G$91/Calculator!F$84,\"-\")","v":"-"},{"$f":"IFERROR(D54/Calculator!G$84,\"-\")","v":"-"},6.9869200445179285,2.8217089939383406,null,null,null,null,null,null,null," Residual Oil",{"$f":"IF(Calculator!O$59=0%,0,H58/(76330*1055.06/10^6))","v":0},{"$f":"IF(Calculator!O$59=100%,0,IF(Calculator!X59>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(Calculator!O$59=0%,0,$E$58*10^6/(76330*1055.06))","v":0},{"$f":"IF(Calculator!O$59=100%,0,IF(Calculator!X59>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(Calculator!O$59=0%,0,G58*10^6/(76330*1055.06))","v":0},{"$f":"IF(Calculator!O$59=100%,0,IF(Calculator!X59>0,G58*10^6/(76330*1055.06),\"-\"))","v":"-"}]
[null,"     VOC from refueling station"]
[null,null,null,"(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(Calculator!O$59=0%,0,G65)","v":0},{"$f":"IF(Calculator!O$59=100%,0,H65)","v":0}]
[null,"     VOC",null,28.305199565933879,{"$f":"D61*(Fuel_Specs!$H$77/10^6)*Fuel_Specs!$C$78*Fuel_Specs!$C$79*Calculator!$G$59","v":0},{"$f":"E61*$K$10","v":0}]
[null,"     CO",null,194.00139826261949,{"$f":"D62*(Fuel_Specs!$H$77/10^6)*Fuel_Specs!$C$78*Fuel_Specs!$C$79*Calculator!$G$59","v":0},{"$f":"E62*$K$11","v":0}]
[null,"     CH4",null,31.65,{"$f":"D63*(Fuel_Specs!$H$77/10^6)*Fuel_Specs!$C$78*Fuel_Specs!$C$79*Calculator!$G$59","v":0},{"$f":"E63*$K$12","v":0},{"$f":"F$65*Calculator!O$59*Calculator!G91","v":0},{"$f":"F$65*(1-Calculator!O$59)","v":0},"(gCO2e)"]
[null,"     N2O",null,4.22,{"$f":"D64*(Fuel_Specs!$H$77/10^6)*Fuel_Specs!$C$78*Fuel_Specs!$C$79*Calculator!$G$59","v":0},{"$f":"E64*K$13","v":0},{"$f":"Calculator!E94","v":0},{"$f":"Calculator!C$94","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)"]
[]
[]
[]
[]
["VI.","Surplus Cogenerated Electricity Export Credit ",null,null,null,null,{"$f":"Calculator!$I$94","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(Calculator!I21=\"Yes\",-$G$84,\"0.0\"),0)","v":"0.0"},{"$f":"IFERROR(IF(Calculator!I21=\"Yes\",-$H$84,\"0.0\"),0)","v":"0.0"}]
[null,"Feedstock"," (gal)","(kWh/year)","After Allocation","After T&D Losses","(kWh/gal Ethanol)","(Btu/gal Ethanol)"]
[null,"Molasses-to-EtOH",{"$f":"Calculator!F$86","v":0},{"$f":"(Calculator!$N$59-Calculator!$M$59-Calculator!$J$59)*Calculator!$O$59","v":0},{"$f":"D73*Calculator!$G$91","v":0},{"$f":"E73*(1-Calculator!I$22)","v":0},{"$f":"IFERROR(F73/C73,0)","v":0},{"$f":"G73*3412.96","v":0}]
[null,"Juice-to-EtOH",{"$f":"Calculator!G$86","v":0},{"$f":"(Calculator!$N$59-Calculator!$M$59-Calculator!$J$59)*(1-Calculator!$O$59)","v":0},{"$f":"D74","v":0},{"$f":"E74*(1-Calculator!I$22)","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,0,0,{"$f":"Calculator!C$27/1.609","v":0},{"$f":"Calculator!E$27/1.609","v":0},null,null,null,{"$f":"Calculator!G26","v":40},{"$f":"Calculator!G27","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(Calculator!O$59=0%,\"-\",M97)","v":"-"},{"$f":"IF(Calculator!X59=0,\"-\",IF(Calculator!O59<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",null,null,null,"2010 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,"Energy % Denaturant in D-EtOH",3.7600000000000001E-2,3.7600000000000001E-2,"MJ/MJ CARBOB/D-EtOH",null,null,null,"CARBOB CI",101.43]
[null,"2010 CARBOB CI *",{"$f":"$J$114-(5.87493397896155*$K$12+3.21914073294522*$K$13)/1055.06","v":100.38155034984578},{"$f":"$J$114-(5.87493397896155*$K$12+3.21914073294522*$K$13)/1055.06","v":100.38155034984578},"g CO2e/MJ CARBOB"]
[null,"Denaturant, g/MJ",{"$f":"IFERROR((1-$C$114)*(C122+C123)+$C$114*$C$115-(C122+C123),0)","v":3.3306662931542004},{"$f":"IFERROR((1-$D$114)*(D122+D123)+$D$114*$D$115-(D122+D123),0)","v":3.3306662931542004},"g CO2e/MJ",null,null,"changing these values will result in an incorrect "]
[null,"*  Without Tailpipe N2O and CH4 emissions impact.",null,null,null,null,null,"CARFG and Denaturant calculation"]
[]
[]
[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":3.3306662931542004},{"$f":"D116","v":3.3306662931542004}]
[null,"Total CI (g/MJ)",{"$f":"SUM(C122:C124)","v":15.130666293154201},{"$f":"SUM(D122:D124)","v":15.130666293154201}]
[]
[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,"Standard for Sao Paulo State","Standard for Non-Sao Paulo States"]
[null,0.8,0.65]
[]
[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":3,"n_rows":173,"n_cols":20,"rows_kept":173,"cut":false,"hidden":false,"merged":[]}
[]
["Generalized Emissions Factors (EF General) for CI Determination"]
[]
[]
["Factor 1 - Sugarcane Farming Impacts",null,null,null,null,null,"gCO2e/MJ"]
["Sugarcane Farming",null,null,null,null,null,{"$f":"IF(Calculator!O59=0,Calculator!M154,Calculator!G154)","v":"-"}]
["Fertilizers",null,null,null,null,null,{"$f":"IF(Calculator!O$59=0,Calculator!M155,Calculator!G155)","v":0}]
["N2O in Soil",null,null,null,null,null,{"$f":"IF(Calculator!O$59=0,Calculator!M156,Calculator!G156)","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":"Calculator!F$84","v":0},"gal","=",{"$f":"J15*L15","v":0},"gCO2e",{"$f":"Calculator!G$59","v":0},"m.t. cane",{"$f":"Calculator!O59","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":"Calculator!G$84","v":0},"gal","=",{"$f":"J22*L22","v":0},"gCO2e",{"$f":"Calculator!G$59","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":"Calculator!G59","v":0},"mt cane",{"$f":"1-Calculator!O59","v":1},{"$f":"Calculator!O59*Calculator!G91","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":"Calculator!$F$60","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":"Calculator!G86","v":0},"gal"]
[null,null,null,null,null,1055.06,"J","Btu",76330,{"$f":"Calculator!$G$84","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":"Calculator!K$95","v":0},"kWh","Electricity Displaced"]
[null,null,null,null,null,"m.t. cane",null,null,"gal ",null,null,null,{"$f":"IFERROR((M64/(1-Calculator!O$59))-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*Calculator!G91","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":"Calculator!F$84","v":0},"gal",null,{"$f":"Calculator!I94","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":"Calculator!K$94","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":"Calculator!M177+Calculator!M175+Calculator!M178+Calculator!M179","v":0},"gCO2e/MJ Ethanol","Juice"]
[]
[null,null,{"$f":"IF(Calculator!O59=0,'EF General'!C90,Calculator!G177+Calculator!G175+Calculator!G178+Calculator!G179)","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":"Calculator!F84","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":"Calculator!G91","v":0},"m.t. cane",null,null,"m.t. cane"]
[]
[null,"For Cane Juice Feedstock"]
[null,"=",{"$f":"I92","v":0},"gCO2e",{"$f":"Calculator!G84","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":3.3306662931542004},"gCO2e",null,null,{"$f":"Calculator!F84","v":0},"gal",{"$f":"Calculator!G$59","v":0},"mt cane",{"$f":"Calculator!G$91","v":0},{"$f":"Calculator!O$59","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":"Calculator!F86","v":0},{"$f":"E115*76330*1055.06/10^6","v":0},{"$f":"'EF Tables'!C124","v":3.3306662931542004},{"$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":"Calculator!G86","v":0},{"$f":"E116*76330*1055.06/10^6","v":0},{"$f":"'EF Tables'!D124","v":3.3306662931542004},{"$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*Calculator!$F$86","v":0},"gCO2e mol feedstock"]
[null,null,1000000,"J","Btu","1 gal EtOH",null,null,"gal Ethanol",{"$f":"H126*Calculator!$G$86","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":"Calculator!G84","v":0},"gal Ethanol"]
[null,null,null,"gal Ethanol",null,"m.t.cane","=",{"$f":"C130*E130","v":0},"gCO2e",{"$f":"H131*Calculator!G$59*(1-Calculator!E$86)*(1-Calculator!O$59)","v":0},"gCO2e"]
[null,null,null,null,null,null,null,null,"m.t.cane"]
[]
[]
["ILUC mol","=",{"$f":"H126","v":950.28621164000003},"gCO2e",{"$f":"Calculator!F84","v":0},"gal Ethanol"]
[null,null,null,"gal Ethanol",null,"m.t.cane","=",{"$f":"C135*E135","v":0},"gCO2e",{"$f":"H$136*Calculator!G$59*Calculator!O$59","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":"Calculator!M$180","v":0},"gCO2"]
[null,null,null,"MJ"]
[]
[null,"=",{"$f":"C144","v":0},"gCO2",null,null,"=",{"$f":"C147*F149*C149/C148","v":0},"gCO2e",{"$f":"Calculator!G$84","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":"Calculator!G180","v":0},"gCO2"]
[null,null,null,"MJ"]
[]
[null,"=",{"$f":"C151","v":0},"gCO2",null,null,"=",{"$f":"C154*F156*C156/C155","v":0},"gCO2e",{"$f":"Calculator!F$84","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:",0,"Rail:",0,"Ocean Tanker:",{"$f":"Calculator!E$27/1.609","v":0},"Total Truck Transport in Brazil:","Total Truck Transport in California:",{"$f":"Calculator!C27/1.609","v":0},{"$f":"Calculator!G26+Calculator!G27","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":"Fuel_Specs","index":4,"n_rows":83,"n_cols":9,"rows_kept":83,"cut":false,"hidden":false,"merged":[[16,4,19,4],[1,1,1,4],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,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],[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],[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]]}
[]
[null,"General References for Sugarcane-based Ethanol Pathways"]
[]
[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,"CA-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,"CA-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,"CA-GREET 3.0"]
[null,"N in N2O as % of N in biomass",1.225E-2,null,"CA-GREET 3.0"]
[null,"d. Cane Transport"]
[null,"Raw feedstock to collection point by MDT, mi",2,null,"CA-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,"CA-GREET 3.0"]
[null,"Moisture in straw",0.15,null,"CA-GREET 3.0"]
[null,"Burn Field, %",0.9,null,"CA-GREET 3.0"]
[null,"f. Mechanized Harvesting Credit"]
[null,"Mechanized field, %","Standard (Sao Paulo State) at 80%, or",null,"CA-GREET 3.0"]
[null,null," (Non-Sao Paulo State) at 65%",null,"CA-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,"CA-GREET 3.0"]
[null,"Chemical Use, g/tonne of cane"]
[null,"Lime",880,null,"CA-GREET 3.0"]
[null,"j. Fuel Distribution"]
[null,"Distribution by HDT to blending terminal, miles",40,null,"CA-GREET 3.0"]
[null,"Distribution by HDT to stations, miles",50,null,"CA-GREET 3.0"]
[null,"k. Fuel Properties"]
[null,"Density of EtOH (LHV), grams/gal",2988,null,"CA-GREET 3.0"]
[null,"Sugarcane bagasse, Btu/ton",12381771.311916806,null,"CA-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)"]
[null,"Bagasse yield: wet tonne per wet tonne of sugarcane",0.28000000000000003,null,"CA-GREET 3.0"]
[null,"Moisture in bagasse",0.5,null,"CA-GREET 3.0",{"$f":"F48*0.3","v":204725054.76052916},"combustion efficiency"]
[null,"Steam generation efficiency",0.8,null,"CA-GREET 3.0",{"$f":"F50*0.8","v":163780043.80842334},"steam boiler efficiency"]
[null,"Power Generation Efficiency",0.3,null,"CA-GREET 3.0",{"$f":"F51*0.99","v":162142243.3703391},"electrical generator efficiency"]
[null,"l. Sugarcane bagasse, emissions, grams/mmBtu fuel burned","Small Industrial Boiler",null,"CA-GREET 3.0",{"$f":"F52/3412.96","v":47507.806528743109},"kWh"]
[null,"m. Electrciity Mix emissions, grams/mmBtu Available at User Sites","Brazil Electricity Mix",null,"CA-GREET 3.0",{"$f":"F53/0.99","v":47987.683362366777}]
[null,"n. Electric Transmission and Distribution Loss","8.1% (Brazil)",null,"CA-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},"CA-GREET 3.0"]
[null,"Carbon ratio of CO",{"$f":"12/28","v":0.42857142857142855},{"$f":"C59/C61","v":1.5714285714285714},"CA-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]
[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":"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"]