{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Calculator","Calculation","Reference"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":168,"comments":1,"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":"Calculator","index":0,"n_rows":38,"n_cols":41,"rows_kept":38,"cut":false,"hidden":false,"merged":[[8,31,10,31],[11,31,12,31],[19,24,19,27],[28,24,28,27],[29,24,29,27],[20,24,20,27],[21,24,21,27],[22,24,22,27],[24,24,24,27],[5,24,5,29],[14,24,14,28],[16,24,16,29],[17,24,17,27],[18,24,18,27],[8,24,8,28],[10,24,10,28],[9,24,9,28],[13,24,13,28],[12,24,12,28],[0,0,0,2],[0,15,0,17],[4,1,4,2],[0,4,0,5],[4,5,4,6],[3,23,3,30],[5,1,5,21],[4,9,4,11],[31,24,31,27],[4,16,4,20],[13,30,14,32],[4,29,4,30],[6,30,6,32],[8,32,10,32],[11,30,12,30],[11,32,12,32],[8,30,10,30],[7,24,7,29],[11,24,11,28],[6,24,6,29],[4,23,4,28]]}
["Simplified CI Calculator- Sugarcane Ethanol",null,null,"Company Name:","ABC Company",null,"Ethanol Production Location:"]
[null,"Composite CI, g/MJ",null,null,{"$f":"((IF($P$34=0, 0, Calculation!O83))*(AC25/(AC25+AD25)))+((IF($P$34=100, 0, Calculation!P83))*(AD25/(AC25+AD25)))","v":46.89450912041579},"Volume, gal",{"$f":"AC25+AD25","v":73293259.859843776},"Note- to calculate CI after all data entered, go to the \"Data\" tab in the ribbon above, click \"Solver\",  then click \"Solve\" and accept the dialogue box after it finds solution."]
[]
[]
[null,"Mechanized harvesting?",null,"Site-Specific",null,"Exported electricity?",null,"Yes",null,"Juice-to-Ethanol yield, gal/wet tonne cane",null,null,{"$f":"$AD$23","v":20.080345167080484},null,null,null,"Surplus electricity credit after mass allocation, kWh/gal",null,null,null,null,{"$f":"IF($H$5=\"No\", 0, AO11)","v":3.2049331746082972},null,"Electric Transmission and Distribution Loss",null,null,null,null,null,8.1000000000000003E-2]
["Process ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Parameters for Molassess Production"]
["Monthly Data"," Cane sourced from self-owned farms","Transport of cane sourced from self-owned farms (monthly weighted average distance)"," Cane purchased from other farms","Transport of cane sourced from other farms (monthly weighted average distance)","Total Sugarcane use (Calculated)","Mechanized Harvesting","Filter Cake T&D","Purchased or inter-mill transferred bagasse?","Electricity generated from purchased or inter-mill transferred bagasse","Purchased molasses?","Ethanol produced from purchased molasses","Purchased Electricity from the grid","Inter-mill electricity transferred in","Gross surplus electricity generation","Juice-to-Sugar share (monthly weighted average)","% Sucrose at gate (monthly weighted average)","Anhydrous ethanol production","Adjusted anhydrous ethanol production","Moisture Content","Hydrous ethanol production","Adjusted hydrous ethanol production","Moisture Content","Sugar production","Gopal-Kammen Model Parameters",null,null,null,null,null,"Ethanol Transport",null,null,null,"Surplus electricity credit calculations"]
["Unit","Metric Tons","Km","Metric Tons","Km","Metric Tons","%","Km","Metric Tons","kWh","Metric Tons","m3","kWh","kWh","kWh","%",null,"m3","m3","%","m3","m3","%","Metric Tons","Mill-specific values for ethanol yield calculation and ethanol production modeling",null,null,null,null,null,"Mode","Share","Km",null,"Standard","Site-Specific",{"$f":"IF(D5=\"Standard\",TRUE, FALSE)","v":false},"Yes","No"]
["Month 1",100000,50,200000,50,{"$f":"B9+D9","v":300000},0.8,{"$f":"(2/$AO$33)+$E$35","v":53.218688000000022},0,{"$f":"I9*Reference!$H$82*Reference!$C$84*Reference!$H$83*Reference!$H$84/kWh2Btu","v":0},0,0,null,null,null,0.9,0.13500000000000001,null,{"$f":"R9-L9*$R$34","v":0},null,null,{"$f":"U9-L9*$U$34","v":0},null,null,"ηj (tonnes of fermentable sugars in juice/tonne of cane)",null,null,null,null,{"$f":"$Q$34-0.01","v":0.12499999999999993},"By HDD from plant to port",1,483,null,"Surplus allocated based on TRS to sugar and ethanol",null,null,null,null,"Surplus electricity credit (kWh/gal)"]
["Month 2",100000,50,200000,50,{"$f":"B10+D10","v":300000},0.8,{"$f":"(2/$AO$33)+$E$35","v":53.218688000000022},0,{"$f":"I10*Reference!$H$82*Reference!$C$84*Reference!$H$83*Reference!$H$84/kWh2Btu","v":0},0,0,1000000,1500000,null,0.9,0.13500000000000001,null,0,null,null,0,null,null,"ηs (tonnes of sucrose in final sugar/tonne of sucrose into sugar factory)",null,null,null,null,0,null,null,null,null,null,null,"kWh/year","kWh/tonne cane",null,"Before mass allocation","after mass allocation"]
["Month 3",200000,50,200000,50,400000,0.8,53.218688000000022,0,{"$f":"I11*Reference!$H$82*Reference!$C$84*Reference!$H$83*Reference!$H$84/kWh2Btu","v":0},0,0,500000,200000,null,0.9,0.13500000000000001,null,0,null,null,0,null,null,"Sucrose in Molasses (tonnes sucrose in molasses/tonne of sugarcane)",null,null,null,null,{"$f":"AD9*(1-AD10)","v":0.12499999999999993},null,null,null,null,"Molasses-EtOH",null,{"$f":"($O$33-$N$33-$M$33-$J$33)/2*$P$34","v":234899999.99999994},{"$f":"AK11/$F$34","v":64.356164383561634},null,{"$f":"AL11/AC23","v":3.2049331746082972},{"$f":"AN11*AC32","v":3.2049331746082972}]
["Month 4",100000,50,200000,50,300000,0.8,53.218688000000022,0,{"$f":"I12*Reference!$H$82*Reference!$C$84*Reference!$H$83*Reference!$H$84/kWh2Btu","v":0},0,0,1000000,null,20000000,0.9,0.13500000000000001,8000,8000,3.0000000000000001E-3,10000,10000,0.05,50000,"ηe (dry tonnes of EtOH/tonne of fermentable sugars into distillery)",null,null,null,null,0.48,"By Ocean Tanker from port to CA port",1,15000,null,"Juice-EtOH",null,{"$f":"($O$33-$N$33-$M$33-$J$33)/2*(1-$P$34)","v":26100000.000000052},{"$f":"AK12/$F$34","v":7.1506849315068637}]
["Month 5",100000,50,200000,50,300000,0.8,53.218688000000022,0,{"$f":"I13*Reference!$H$82*Reference!$C$84*Reference!$H$83*Reference!$H$84/kWh2Btu","v":0},0,0,200000,2000000,15000000,0.9,0.13500000000000001,8000,8000,3.0000000000000001E-3,10000,10000,0.05,50000,"LHV of anhydrous EtOH (MMBtu/dry tonne EtOH)",null,null,null,null,25.545515000000002]
["Month 6",100000,50,200000,50,300000,0.8,53.218688000000022,0,{"$f":"I14*Reference!$H$82*Reference!$C$84*Reference!$H$83*Reference!$H$84/kWh2Btu","v":0},0,0,500000,200000,15000000,0.9,0.13500000000000001,8000,8000,3.0000000000000001E-3,10000,10000,0.05,50000,"ms (tonnes of sucrose in final sugar/tonne of final sugar product)",null,null,null,null,0.99,"By Other Modes"]
["Month 7",100000,50,200000,50,300000,0.8,53.218688000000022,0,{"$f":"I15*Reference!$H$82*Reference!$C$84*Reference!$H$83*Reference!$H$84/kWh2Btu","v":0},0,0,1000000,null,20000000,0.9,0.13500000000000001,8000,8000,3.0000000000000001E-3,10000,10000,0.05,60000,"mm (tonnes of fermentable sugars in std molasses/tonne of std molasses)",null,null,null,null,0.5]
["Month 8",100000,50,200000,50,300000,0.8,53.218688000000022,0,{"$f":"I16*Reference!$H$82*Reference!$C$84*Reference!$H$83*Reference!$H$84/kWh2Btu","v":0},0,0,200000,2000000,20000000,0.9,0.13500000000000001,8000,8000,3.0000000000000001E-3,10000,10000,0.05,80000,null,null,null,null,null,null,"Specify Mode",null,0]
["Month 9",100000,50,200000,50,300000,0.8,53.218688000000022,0,{"$f":"I17*Reference!$H$82*Reference!$C$84*Reference!$H$83*Reference!$H$84/kWh2Btu","v":0},0,0,1000000,1000000,20000000,0.9,0.13500000000000001,8000,8000,3.0000000000000001E-3,10000,10000,0.05,50000,"Yield of Finished Sugar, Standard Molasses, and Ethanol",null,null,null,null,null,"Specify Mode",null,0]
["Month 10",100000,50,200000,50,300000,0.8,53.218688000000022,0,{"$f":"I18*Reference!$H$82*Reference!$C$84*Reference!$H$83*Reference!$H$84/kWh2Btu","v":0},0,0,1000000,null,0,0.9,0.13500000000000001,8000,8000,3.0000000000000001E-3,10000,10000,0.05,50000,"Fraction of sugarcane juice sent to finished sugar",null,null,null,1,0]
["Month 11",100000,50,200000,50,300000,0.8,53.218688000000022,0,{"$f":"I19*Reference!$H$82*Reference!$C$84*Reference!$H$83*Reference!$H$84/kWh2Btu","v":0},0,0,1000000,500000,12000000,0.9,0.13500000000000001,8000,8000,3.0000000000000001E-3,10000,10000,0.05,60000,"Finished sugar yield (tons of finished sugar/ton of cane)",null,null,null,{"$f":"AC18*$AD$9*$AD$10/$AD$14","v":0},{"$f":"AD18*$AD$9*$AD$10/$AD$14","v":0}]
["Month 12",100000,50,200000,50,300000,0.8,53.218688000000022,0,{"$f":"I20*Reference!$H$82*Reference!$C$84*Reference!$H$83*Reference!$H$84/kWh2Btu","v":0},0,0,500000,null,1000000,0.9,0.13500000000000001,8000,8000,3.0000000000000001E-3,10000,10000,0.05,50000,"By-product molasses yield (tones of standard molasses/ton of cane)",null,null,null,{"$f":"AC18*$AD$11/$AD$15","v":0.24999999999999986},{"$f":"AD18*$AD$11/$AD$15","v":0}]
["Month 13",100000,50,200000,50,300000,0.8,53.218688000000022,0,{"$f":"I21*Reference!$H$82*Reference!$C$84*Reference!$H$83*Reference!$H$84/kWh2Btu","v":0},0,0,null,null,null,0.9,0.13500000000000001,8000,8000,null,10000,10000,null,null,"EtOH yield (liters of EtOH/ton cane)",null,null,null,{"$f":"$AD$12*$AD$9*(1-AC18*$AD$10)/(Reference!$D$80*$AO$22/$AO$23)","v":68.957252566251938},{"$f":"$AD$12*$AD$9*(1-AD18*$AD$10)/(Reference!$D$80*$AO$22/$AO$23)","v":68.957252566251938}]
["Month 14",100000,50,200000,50,300000,0.8,53.218688000000022,0,{"$f":"I22*Reference!$H$82*Reference!$C$84*Reference!$H$83*Reference!$H$84/kWh2Btu","v":0},0,0,null,null,null,0.9,0.13500000000000001,8000,8000,null,10000,10000,null,null,"EtOH yield (gal of EtOH/ton cane)",null,null,null,{"$f":"AC21/$AO$23","v":18.216582708258613},{"$f":"AD21/$AO$23","v":18.216582708258613},null,null,null,null,null,null,null,null,"g2T",null,1.1023100000000001E-6]
["Month 15",100000,50,200000,50,300000,0.8,53.218688000000022,0,{"$f":"I23*Reference!$H$82*Reference!$C$84*Reference!$H$83*Reference!$H$84/kWh2Btu","v":0},0,0,500000,null,null,0.9,0.13500000000000001,8000,8000,null,10000,10000,null,null,"EtOH yield (gal of EtOH/tonne cane)",null,null,null,{"$f":"AC22*$AO$24","v":20.080345167080484},{"$f":"AD22*$AO$24","v":20.080345167080484},null,null,null,null,null,null,null,null,"gal2L",null,3.7854109999999999]
["Month 16",100000,50,200000,50,300000,0.8,53.218688000000022,0,{"$f":"I24*Reference!$H$82*Reference!$C$84*Reference!$H$83*Reference!$H$84/kWh2Btu","v":0},0,0,1000000,2000000,6000000,0.9,0.13500000000000001,8000,8000,3.0000000000000001E-3,10000,10000,0.05,40000,null,null,null,null,"Molasses-EtOH","Juice-EtOH",null,null,null,null,null,null,null,null,"MT2T",null,1.102311311]
["Month 17",100000,50,200000,50,300000,0.8,53.218688000000022,0,{"$f":"I25*Reference!$H$82*Reference!$C$84*Reference!$H$83*Reference!$H$84/kWh2Btu","v":0},0,0,1000000,2500000,100000000,0.9,0.13500000000000001,8000,8000,3.0000000000000001E-3,10000,10000,0.05,50000,"Modeled ethanol production (gal)",null,null,null,{"$f":"AC23*$P$34*$F$34","v":65963933.873859383},{"$f":"AD23*(1-$P$34)*$F$34","v":7329325.9859843906}]
["Month 18",100000,50,200000,50,300000,0.8,53.218688000000022,0,{"$f":"I26*Reference!$H$82*Reference!$C$84*Reference!$H$83*Reference!$H$84/kWh2Btu","v":0},0,0,1500000,2000000,60000000,0.9,0.13500000000000001,8000,8000,3.0000000000000001E-3,10000,10000,0.05,25000,"Annual adjusted reported ethanol production (gal)",null,null,{"$f":"((SUMPRODUCT(S9:S32,(1-T9:T32))+SUMPRODUCT(V9:V32,(1-W9:W32)))*AO26)/2","v":48682692.584816404},null,{"$f":"SUM(AC25+AD25)","v":73293259.859843776},null,null,null,null,null,null,null,null,"m32gal",null,264.17210710000001]
["Month 19",100000,50,200000,50,300000,0.8,53.218688000000022,0,{"$f":"I27*Reference!$H$82*Reference!$C$84*Reference!$H$83*Reference!$H$84/kWh2Btu","v":0},0,0,1200000,null,50000000,0.9,0.13500000000000001,8000,8000,3.0000000000000001E-3,10000,10000,0.05,60000,"Difference between reported and modeled",null,null,{"$f":"AB26-(AC25+AD25)","v":-24610567.275027372}]
["Month 20",100000,50,200000,50,300000,0.8,53.218688000000022,0,{"$f":"I28*Reference!$H$82*Reference!$C$84*Reference!$H$83*Reference!$H$84/kWh2Btu","v":0},0,0,1000000,2000000,25000000,0.9,0.13500000000000001,8000,8000,3.0000000000000001E-3,10000,10000,0.05,40000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ethanol energy density (MJ/gal)",null,80.532413030499995]
["Month 21",100000,50,200000,50,300000,0.8,53.218688000000022,0,{"$f":"I29*Reference!$H$82*Reference!$C$84*Reference!$H$83*Reference!$H$84/kWh2Btu","v":0},0,0,2000000,null,30000000,0.9,0.13500000000000001,8000,8000,3.0000000000000001E-3,10000,10000,0.05,40000,"Modeled annual sugar production (tonnes)",null,null,null,{"$f":"AC19*$P$34*$F$34","v":0},null,null,null,null,null,null,null,null,null,"Ethanol LHV (Btu/gal)",null,76330]
["Month 22",100000,50,200000,50,300000,0.8,53.218688000000022,0,{"$f":"I30*Reference!$H$82*Reference!$C$84*Reference!$H$83*Reference!$H$84/kWh2Btu","v":0},0,0,null,null,50000000,0.9,0.13500000000000001,8000,8000,3.0000000000000001E-3,10000,10000,0.05,60000,"Difference between reported and modeled",null,null,null,{"$f":"X33/2-AC29","v":437500},{"$f":"ABS(AC30)","v":437500},null,null,null,null,null,null,null,null,"kWh2Btu",null,3412.141641601248]
["Month 23",100000,50,200000,50,300000,0.8,53.218688000000022,0,{"$f":"I31*Reference!$H$82*Reference!$C$84*Reference!$H$83*Reference!$H$84/kWh2Btu","v":0},0,0,null,null,60000000,0.9,0.13500000000000001,8000,8000,3.0000000000000001E-3,10000,10000,0.05,20000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Btu2J",null,1055.05585]
["Month 24",100000,50,200000,50,300000,0.8,53.218688000000022,0,{"$f":"I32*Reference!$H$82*Reference!$C$84*Reference!$H$83*Reference!$H$84/kWh2Btu","v":0},0,0,null,null,50000000,0.9,0.13500000000000001,8000,8000,3.0000000000000001E-3,10000,10000,0.05,40000,"Mass allocation for upstream emissions",null,null,null,{"$f":"AD11/AD9","v":1}]
["2-yr Total",{"$f":"SUM(B9:B32)","v":2500000},null,{"$f":"SUM(D9:D32)","v":4800000},null,{"$f":"SUM(F9:F32)","v":7300000},{"$f":"AVERAGE(G9:G32)","v":0.80000000000000027},{"$f":"AVERAGE(H9:H32)","v":53.218688000000014},null,{"$f":"SUM(J9:J32)","v":0},null,null,{"$f":"SUM(M9:M32)","v":16100000},{"$f":"SUM(N9:N32)","v":15900000},{"$f":"SUM(O9:O32)","v":554000000},{"$f":"AVERAGE(P9:P32)","v":0.8999999999999998},{"$f":"AVERAGE(Q9:Q32)","v":0.13499999999999993},{"$f":"SUM(R9:R32)","v":168000},null,{"$f":"AVERAGE(T9:T32)","v":3.0000000000000009E-3},{"$f":"SUM(U9:U32)","v":210000},null,{"$f":"AVERAGE(W9:W32)","v":5.0000000000000017E-2},{"$f":"SUM(X9:X32)","v":875000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"km2mi",null,0.62137119223732995]
["annual avg",null,null,"Mi ->",{"$f":"(SUMPRODUCT(B9:B32,C9:C32)+SUMPRODUCT(D9:D32,E9:E32))/(SUM(B9:B32)+SUM(D9:D32))*$AO$33","v":31.068559611866498},{"$f":"F33/2","v":3650000},{"$f":"IF(D5=\"Standard\", 65%, $G$33)","v":0.80000000000000027},{"$f":"H33*AO33","v":33.06855961186649},"<- Mi",null,null,null,null,null,null,{"$f":"P33","v":0.8999999999999998},{"$f":"Q33","v":0.13499999999999993},{"$f":"R33/(R33+U33)","v":0.44444444444444442},null,null,{"$f":"1-R34","v":0.55555555555555558},null,null,{"$f":"X33/2","v":437500}]
[null,null,null,"Km: ->",{"$f":"(SUMPRODUCT(B9:B32,C9:C32)+SUMPRODUCT(D9:D32,E9:E32))/(SUM(B9:B32)+SUM(D9:D32))","v":50},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"40219504*2","v":80439008}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"2/AO33","v":3.2186880000000206}]

{"sheet":"Calculation","index":1,"n_rows":83,"n_cols":27,"rows_kept":83,"cut":false,"hidden":false,"merged":[[61,2,61,10],[20,2,20,7],[22,26,22,28],[1,2,1,12],[2,3,2,6],[2,7,2,8],[3,2,3,12]]}
[null,"References for Sugarcane Ethanol Pathways",null,null,"Note: all grey cells are standard values."]
[null,null,"Sugarcane Farming",null,null,null,null,null,null,null,null,null,null,null,"Molasses CI (g/MJ)","Juice CI (g/MJ)","Cane transport (HDD)",null,{"$f":"Calculator!$E$34","v":31.068559611866498},"miles","filter cake transport",null,{"$f":"$S$2+2","v":33.068559611866498},"miles","Mecha harvesting",null,{"$f":"Calculator!$G$34","v":0.80000000000000027}]
[null,null,"Sugarcane Farming","Sugarcane Farming Fertilizer Use by Nutrient (grams of nutrient/tonne)",null,null,null,"Sugarcane Farming Pesticide Use (grams/tonne)",null,"Sugarcane Straw Field Burning","Mechanized Harvesting","Sugarcane Transportation","Sugarcane Filtercake Transportation"]
[null,"Total Emissions: grams/mmBtu of fuel throughput, except as noted","Per tonne",null,null,null,null,null,null,null,null,null,null,null,null,null,"HDD per mile","MD (2miles)",null,null,"per ton-mile"]
[null,"     VOC",10.504105694813655,5.2514540135223466,8.0929139018886778E-2,9.5667147377647851E-2,2.177654315938608E-2,9.0250730545817726E-2,5.9270211139706708E-3,1499.4000000000003,{"$f":"-J5*$AA$2","v":-1199.5200000000007},{"$f":"(Q5*$S$2+R5)/$Q$18","v":1.466299421548289},{"$f":"U5*$W$2*$Q$21*$Q$19/(1-65%)","v":2.2174968833608373E-2},{"$f":"SUM(C5:M5)/Calculator!$AC$23/EtOH_LHV*10^6","v":207.09323617139154},{"$f":"N5*R37/Btu2J*Calculator!$AC$32","v":0.6117596391390121},{"$f":"SUM(C5:M5)/Calculator!$AD$23/EtOH_LHV*10^6*R37/Btu2J","v":0.6117596391390121},3.7643828041852706E-2,0.16066494396228242,null,null,7.4180484670709743E-2]
[null,"     CO",139.19620479578481,6.0992984182105703,0.32918020455249408,0.63784737254498491,0.1349421426347186,0.73558149219769753,6.5384012382786655E-2,19706.400000000001,-15765.120000000006,5.0842051704585813,7.6888860175327242E-2,{"$f":"SUM(C6:M6)/Calculator!$AC$23/EtOH_LHV*10^6","v":2670.8110344357187},{"$f":"N6*R38/Btu2J*Calculator!$AC$32","v":3.9779778183296992},{"$f":"SUM(C6:M6)/Calculator!$AD$23/EtOH_LHV*10^6*R38/Btu2J","v":3.9779778183296992},0.13052514537866394,0.55708508562456216,null,null,0.25721131589324958]
[null,"     NOx",54.513342785712474,6.0135258094314548,1.4946829945210376,1.8271117470341462,0.35599085865950142,2.0009385859921123,0.1612632722716516,535.50000000000011,-428.40000000000026,13.661254867577291,0.20660030036473057,null,null,null,0.35072095201946235,1.4968871401696044,null,null,0.69112658192070531]
[null,"     PM10",3.7418639016719695,1.4251605802991218,0.42632735390934406,0.21165696986034233,3.3666022986191362E-2,0.2586264132395607,1.3855837607317553E-2,1670.7600000000002,-1336.6080000000006,0.3008172363912005,4.5492842345552231E-3,null,null,null,7.722783049848447E-3,3.2961060829341152E-2,null,null,1.5218425421760176E-2]
[null,"     PM2.5",3.4585280531571723,1.1704532563712335,0.33174227671165363,0.16779527897144847,1.7596464234012808E-2,0.17291332725396935,1.1100185811710012E-2,835.38000000000011,-668.30400000000031,0.26934763850347593,4.0733668727181548E-3,null,null,null,6.9148743007739375E-3,2.9512882983231074E-2,null,null,1.362636994564276E-2]
[null,"     SOx",3.1556182835898254,1.2770204091469335,18.852543520245039,0.72838276751081998,0.14443437227032124,2.5801269019990332,9.3551713378418319E-2,85.680000000000021,-68.54400000000004,1.6447031313986094,2.4872983064258239E-2,null,null,null,4.2223928447636623E-2,0.18021294461244911,null,null,8.3205976646813326E-2]
[null,"     CH4",21.033493964139364,8.2078964579638942,0.33736158631255703,0.65588800108167244,0.13889865189963393,1.0760838361426546,7.1079026636152093E-2,578.34,-462.6720000000002,7.0205619516436748,0.10617254578722367,{"$f":"SUM(C11:M11)/Calculator!$AC$23/EtOH_LHV*10^6","v":100.67993677540387},{"$f":"N11*R39/Btu2J*Calculator!$AC$32","v":2.3856541996190033},{"$f":"SUM(C11:M11)/Calculator!$AD$23/EtOH_LHV*10^6*R39/Btu2J","v":2.3856541996190033},0.18023660309828807,0.7692550211562752,null,null,0.35517212963486178]
[null,"     N2O",0.19812047669380217,5.885149931177609,4.8429666857309978E-3,9.4718318148000972E-3,1.6329280421502875E-3,1.463073570932614E-2,8.2231582684689293E-4,14.994000000000003,-11.995200000000006,7.8799588092052258E-2,1.1916927636767061E-3,{"$f":"(SUM(C12:M12)+D16)/Calculator!$AC$23/EtOH_LHV*10^6","v":33.152028660484326},{"$f":"N12*R40/Btu2J*Calculator!$AC$32","v":9.3637740038352746},{"$f":"(SUM(C12:M12)+D16)/Calculator!$AD$23/EtOH_LHV*10^6*R40/Btu2J","v":9.3637740038352746},2.0229961904873811E-3,8.6342060966594844E-3,null,null,3.9864924930192508E-3]
[null,"     CO2",7288.1025827488456,2946.8379608092018,179.48735010384448,364.80956621497108,105.17058857549327,664.01333249872368,42.477723884281183,355469.2350000001,-284375.38800000015,5315.0308103146726,80.379655639463579,{"$f":"(SUM(C13:M13)+D14+F14+J14+K14)/Calculator!$AC$23/EtOH_LHV*10^6","v":7360.6129938775775},{"$f":"N13/Btu2J*Calculator!$AC$32","v":6.976515028922476},{"$f":"(SUM(C13:M13)+D14+F14+J14+K14)/Calculator!$AD$23/EtOH_LHV*10^6/Btu2J","v":6.976515028922476},136.4510569399045,582.37704710769333,null,null,268.88884749922357]
[null,"     CO2 from Land use change",null,616,"CO2 from urea use",1125.6960000000001,"CO2 from CaCO3 use",null,null,-392700.00000000006,314160.00000000017,"CO2 uptaken from the air"]
[null,"     VOC from bulk terminal",null,35.161968377890773,"NO from N fertilizer and above/below ground biomass"]
[null,"     VOC from refueling station",null,41.619737477447934,"N2O from N fertilizer and above/below ground biomass"]
[]
[null,"Sugar Production",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.90718474000000004,"T2MT"]
[null,"gCO2e/wet tonne of cane",3700,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C$19/Calculator!$AC$23/Calculator!$AO$28","v":2.2880201141652217},null,1.1023113109243879E-3,"kg2T"]
[]
[null,null,"Sugarcane Ethanol Production",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"5*30%/6/87.1*1000","v":2.8702640642939152},"Application (kg dry filtercake or L vinasse/MT sugarcane)"]
[null,null,"per gallon"]
[null,"Total Emissions: grams/mmBtu of fuel throughput, except as noted","Residual oil","per dry ton bagasse ","bagasse, per gallon","lime, per wet tonne","lime, per gallon","Ethanol Production: Non-Combustion Emissions","Ethanol production",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sugarcane Bagasse (grams/mmBtu fuel burned)"]
[null,"     VOC",2.0556753880441374E-4,98.880825696967605,{"$f":"D24*$T$25","v":0.75992933572277155},6.7923424659481521E-2,{"$f":"F24/Calculator!$AD$23","v":3.3825825250670739E-3},2.2389999999999999,{"$f":"C24+E24+G24","v":0.76351748578664302},null,null,null,null,null,null,null,null,null,null,"dry ton bagasse/gallon",null,null,null,null,null,null,"Small Industrial Boiler"]
[null,"     CO",1.5313543394762028E-3,3490.0003526047421,26.821718274835302,0.72904159770798727,{"$f":"F25/Calculator!$AD$23","v":3.6306228386112145E-2},null,26.859555857560892,null,null,null,null,null,null,null,null,null,null,{"$f":"1/Calculator!$AD$23*(1-Reference!$C$84)/$Q$18*Reference!$C$83","v":7.685305319472837E-3},null,null,null,null,null,"VOC",7.9859999999999998]
[null,"     NOx",5.3852726992734794E-3,946.1035277148751,7.2710944743191464,1.1106764396909006,{"$f":"F26/Calculator!$AD$23","v":5.531162091335623E-2},null,7.3317913679317757,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CO",281.86599999999999]
[null,"     PM10",1.1512016580554959E-3,1072.2490138406833,8.2405610498693065,0.16362661857741134,{"$f":"F27/Calculator!$AD$23","v":8.1485959138620379E-3},0.85599999999999998,8.2498608474412247,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOx",76.411000000000001]
[null,"     PM2.5",5.6622258852855793E-4,536.13069780599767,4.1203281037811177,0.1034253931941455,{"$f":"F28/Calculator!$AD$23","v":5.1505784553793447E-3},0.14552000000000001,4.126044904825025,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PM10",86.599000000000004]
[null,"     SOx",2.0944945808154501E-2,519.74961436033175,3.9944344760374131,1.9714749485701142,{"$f":"F29/Calculator!$AD$23","v":9.8179335672084478E-2},null,4.1135587575176524,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PM2.5",43.3]
[null,"     CH4",3.1463164862294371E-3,391.88306202216688,3.0117409811702629,0.6984461339685234,{"$f":"F30/Calculator!$AD$23","v":3.4782576103997903E-2},null,3.0496698737604899,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SOx",41.976999999999997]
[null,"     N2O",5.6701308864880691E-5,52.251074936288916,0.40156546415603506,4.2341432349507577E-3,{"$f":"F31/Calculator!$AD$23","v":2.1086008232030641E-4},null,0.40183302554722022,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CH4",31.65]
[null,"     CO2",2.8272927133587076,1533227.150344305,11783.318774501266,1114.8678934419675,{"$f":"F32/Calculator!$AD$23","v":55.520355061907537},null,11841.666422276532,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N2O",4.22]
[null,"     CO2 from Land use change",null,null,null,null,null,-1540097.2936066666,{"$f":"H33*T25","v":-11836.117923061034},"CO2 credit from biomass burning",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CO2",123829.38690433203]
[null,"     VOC from bulk terminal"]
[null,"     VOC from refueling station"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GWP"]
[null,"Non-Biogenic Carbon from bagassee burned",null,"(grams/mmBtu fuel burned)",null,null,"emissions (grams)","gCO2E",null,null,null,null,null,null,null,null,"     VOC",3.1166666666666667]
[null,"     CH4",null,{"$f":"$AA$31","v":31.65},null,null,{"$f":"D38*Reference!$H$82/10^6*Reference!$C$83*Reference!$C$84*Calculator!$F$34","v":220740314.36345288},{"$f":"G38*$R$39","v":5518507859.0863218},null,"Allocated to sugar (Molasses)",null,null,null,null,{"$f":"$H$40*Calculator!$P$34*(1-eta_s)/(Calculator!AC25*Calculator!$AO$28)","v":2.420888999984613},{"$f":"O38","v":2.420888999984613},"     CO",1.5714285714285714]
[null,"     N2O",null,{"$f":"$AA$32","v":4.22},null,null,{"$f":"D39*Reference!$H$82/10^6*Reference!$C$83*Reference!$C$84*Calculator!$F$34","v":29432041.91512705},{"$f":"G39*R40","v":8770748490.7078609},null,"Allocated to juice-EtOH",null,null,null,null,null,null,"     CH4",25]
[null,null,null,null,null,null,null,{"$f":"SUM(H38:H39)","v":14289256349.794182},null,null,null,null,null,null,null,null,"     N2O",298]
[null,"Residual oil",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"0.1230449655856","v":0.12304496558560001},{"$f":"O41","v":0.12304496558560001}]
[null,"Lime",null,null,null,null,14.100170226162438,null,null,null,null,null,null,null,{"$f":"G42/Calculator!$AD$23","v":0.70218764213665585},{"$f":"O42","v":0.70218764213665585}]
[]
[null,"Surplus electricity credit ",{"$f":"(-Calculator!V5)*kWh2Btu","v":-10935.685943630255},"Btu/gal",null,null,null,null,null,null,null,null,null,null,null,null,"Grams per mmBtu of Electricity Available at User Sites (Brazil Mix)"]
[null,null,"g/gal",null,null,"g/mmBtu",null,null,"g/MJ",null,null,null,null,null,{"$f":"SUM(I46:I54)","v":-3.9822210864265597},{"$f":"O45","v":-3.9822210864265597},"VOC",7.0903885868871983]
[null,"     VOC",{"$f":"$C$44*(1-Calculator!$AD$5)*Calculation!R45/10^6","v":-7.1257663517334327E-2},null,null,{"$f":"C46/EtOH_LHV*10^6*$S$55","v":-0.93401824830857105},null,null,{"$f":"F46*R37/Btu2J","v":-2.7591179562311448E-3},null,null,null,null,null,null,null,"CO",120.90982963406086]
[null,"     CO",{"$f":"$C$44*(1-Calculator!$AD$5)*Calculation!R46/10^6","v":-1.2151311385014778},null,null,-15.927475045154377,null,null,{"$f":"F47*R38/Btu2J","v":-2.3722809893591098E-2},null,null,null,null,null,null,null,"NOx",94.60726107309857]
[null,"     NOx",{"$f":"$C$44*(1-Calculator!$AD$5)*Calculation!R47/10^6","v":-0.95079307618076403},null,null,-12.462632644448744,null,null,null,null,null,null,null,null,null,null,"PM10",66.784648668622523]
[null,"     PM10",{"$f":"$C$44*(1-Calculator!$AD$5)*Calculation!R48/10^6","v":-0.67117873225638536},null,null,-8.7975545767309207,null,null,null,null,null,null,null,null,null,null,"PM2.5",46.712731415456304]
[null,"     PM2.5",{"$f":"$C$44*(1-Calculator!$AD$5)*Calculation!R49/10^6","v":-0.46945806374196586},null,null,-6.1534770676832267,null,null,null,null,null,null,null,null,null,null,"SOx",102.53634649585328]
[null,"     SOx",{"$f":"$C$44*(1-Calculator!$AD$5)*Calculation!R50/10^6","v":-1.0304795551559458},null,null,-13.507132587787067,null,null,null,null,null,null,null,null,null,null,"CH4",69.974194427155581]
[null,"     CH4",{"$f":"$C$44*(1-Calculator!$AD$5)*Calculation!R51/10^6","v":-0.70323333344637018},null,null,-9.2177140511770084,null,null,{"$f":"F52*R39/Btu2J","v":-0.21841768023884728},null,null,null,null,null,null,null,"N2O",1.9179987111911503]
[null,"     N2O",{"$f":"$C$44*(1-Calculator!$AD$5)*Calculation!R52/10^6","v":-1.9275686390658211E-2},null,null,-0.25265833804904764,null,null,{"$f":"F53*R40/Btu2J","v":-7.1363221898268422E-2},null,null,null,null,null,null,null,"CO2",29361.459603158746]
[null,"     CO2",{"$f":"$C$44*(1-Calculator!$AD$5)*Calculation!R53/10^6","v":-295.07959728032546},null,null,-3867.7907043124233,null,null,{"$f":"F54/Btu2J","v":-3.6659582564396218}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ethanol T&D loss factor",null,1.0005044983835341]
[]
[]
[]
[]
[]
[null,"Ethanol transportation and distribution"]
[null,null,"Ethanol produced in Brazil, and used in U.S.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Ethanol transport in Brazil",null,null,"Brazilian port to US"]
[null,null,"Pipeline","Rail","Truck","Ocean Tanker","Barge","Pipeline","Rail","Truck","Truck",null,null,null,null,null,"Pipeline","Rail","Truck","Ocean Tanker","Barge","Pipeline","Rail","Truck","Truck"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"Calculator!AG9*Calculator!$AO$33","v":300.12228585063036},{"$f":"Calculator!AG12*Calculator!$AO$33","v":9320.5678835599501},null,null,null,40,50]
[]
[null,"Total Emissions: grams/mmBtu fuel transported",null,null,null,null,null,null,null,null,null,null,"EtOH T&D",null,null,null,null,null,"per mile","per mile"]
[null,"              VOC",null,null,{"$f":"S67*$S$64","v":0.65326053063216738},{"$f":"T67*$T$64","v":5.0020404886952914},null,null,null,8.7065914319644028E-2,0.10883239289955504,null,{"$f":"SUM(C67:K67)+SUM(J77:J78)","v":25.600199326546658},null,{"$f":"M67*R37/Btu2J","v":7.5623757643797168E-2},{"$f":"O67","v":7.5623757643797168E-2},null,null,2.1766478579911008E-3,5.3666692321592579E-4]
[null,"              CO",null,null,2.2650971000108266,11.45756706632773,null,null,null,0.30188989046127096,0.37736236307658871,null,{"$f":"SUM(C68:K68)","v":14.401916419876416},null,{"$f":"M68*R38/Btu2J","v":2.1450601828822698E-2},{"$f":"O68","v":2.1450601828822698E-2},null,null,7.5472472615317745E-3,1.2292777875194834E-3]
[null,"              NOx",null,null,6.0863139361205292,126.18524210100401,null,null,null,0.81117787289540544,1.0139723411192567,null,134.09670625113918,null,null,null,null,null,2.0279446822385135E-2,1.3538364150919966E-2]
[null,"              PM10",null,null,0.13401903088846454,10.737730314421905,null,null,null,1.7861923250200119E-2,2.2327404062750151E-2,null,10.911938672623318,null,null,null,null,null,4.4654808125500301E-4,1.1520467903422078E-3]
[null,"              PM2.5",null,null,0.1199988069745735,9.8757905413683762,null,null,null,1.5993321740098491E-2,1.9991652175123113E-2,null,10.031774322258173,null,null,null,null,null,3.9983304350246226E-4,1.0595696168672034E-3]
[null,"              SOx",null,null,0.73274232026590169,0.86441869370026636,null,null,null,9.7659168253914283E-2,0.12207396031739286,null,1.8168941425374752,null,null,null,null,null,2.4414792063478571E-3,9.2743135879624694E-5]
[null,"              CH4",null,null,3.127775922481133,6.187712664344863,null,null,null,0.4168668665995453,0.5210835832494316,null,10.253439036674973,null,{"$f":"M73*R39/Btu2J","v":0.24295962712957264},{"$f":"O73","v":0.24295962712957264},null,null,1.0421671664988632E-2,6.6387721667249884E-4]
[null,"              N2O",null,null,3.5106513699811215E-2,0.12687057653975967,null,null,null,4.6789612574500497E-3,5.8487015718125621E-3,null,0.17250475306883348,null,{"$f":"M74*R40/Btu2J","v":4.8723881692625447E-2},{"$f":"O74","v":4.8723881692625447E-2},null,null,1.1697403143625123E-4,1.3611893408720285E-5]
[null,"              CO2",null,null,2367.9337224359242,5461.7456413718637,null,null,null,315.59585330020246,394.49481662525307,null,8539.7700337332426,null,{"$f":"M75/Btu2J","v":8.0941402616110256},{"$f":"O75","v":8.0941402616110256},null,null,7.8898963325050611,0.58598850516453449]
[]
[null,"     VOC from bulk terminal",null,null,null,null,null,null,null,6.6669999999999998]
[null,"     VOC from refueling station",null,null,null,null,null,null,null,13.082000000000001]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"CI (feedstock+fuel)",null,{"$f":"SUM(O5:O75)","v":33.350499455196839},{"$f":"SUM(P5:P75)","v":31.062479341031619}]
[null,null,null,null,null,null,null,null,null,null,null,null,"iLUC",null,11.8,{"$f":"O81","v":11.8},null,null,"Denaturant"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Denaturant",null,{"$f":"$T$83-$T$82*(O80+O81)","v":1.9644229833947189},{"$f":"$T$83-$T$82*(P80+P81)","v":2.0483099158022329},null,null,"Energy % Denaturant in D-EtOH",3.6663546744264502E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total CI (g/MJ)",null,{"$f":"SUM(O80:O82)","v":47.114922438591556},{"$f":"SUM(P80:P82)","v":44.910789256833851},null,null,"Addition",3.6198004306972171]

{"sheet":"Reference","index":2,"n_rows":84,"n_cols":8,"rows_kept":84,"cut":false,"hidden":false,"merged":[[47,2,47,3],[48,2,48,3],[49,2,49,3],[50,2,50,3],[42,2,42,3],[43,2,43,3],[44,2,44,3],[45,2,45,3],[46,2,46,3],[30,2,30,3],[35,2,35,3],[37,2,37,3],[39,2,39,3],[40,2,40,3],[36,2,36,3],[34,2,34,3],[23,2,23,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[29,2,29,3],[16,2,16,3],[17,2,17,3],[19,2,19,3],[20,2,20,3],[22,2,22,3],[10,2,10,3],[13,2,13,3],[12,2,12,3],[14,2,14,3],[15,2,15,3],[5,2,5,3],[6,2,6,3],[7,2,7,3],[8,2,8,3],[9,2,9,3]]}
[null,"References for Sugarcane Ethanol Pathways"]
[null,"Feedstock Type","Sugarcane Juice","Molasses","Sources"]
[null,"Juice-to-Sugar share, %",null,"User Defined"]
[null,"Sucrose at gate",null,"User Defined"]
[null,"a. Farming Energy"]
[null,"Total Farming Energy","95,000 Btu/tonne",null,"GREET 1 2013"]
[null,"     Diesel fuel",36385]
[null,"     Gasoline",11685]
[null,"     Natural gas",20425]
[null,"Liquefied petroleum gas",17860]
[null,"     Electricity",8550]
[null,"b. Fertilizer Use"]
[null,"Nitrogen","800 g/tonne",null,"GREET 1 2013"]
[null,"P2O5",300]
[null,"K2O",1000]
[null,"CaCO3",5200]
[null,"Herbicide",45]
[null,"Pesticide",2.5]
[null,"c. N2O in soil"]
[null,"N in N2O as % of N in N fertilizer ",1.325E-2,null,"GREET 1 2013"]
[null,"N in N2O as % of N in biomass",1.225E-2,null,"GREET 1 2013"]
[null,"d. Cane Transport"]
[null,"Raw feedstock to collection point by MDT, mi",2,null,"GREET 1 2013"]
[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-GREET2.0"]
[null,"Moisture in straw",0.15,null,"CA-GREET2.0"]
[null,"Burn Field, %",1,null,"CA-GREET2.0"]
[null,"f. Mechanized Harvesting Credit"]
[null,"Mechanized field, %","User Defined or Standard at 65%"]
[null,"g. Filter Cake T&D, miles","same as cane transport"]
[null,"h. Sugar Production"]
[null,"CO2e/wet tonne of cane",null,3700,"Gopal et al, 2009.  “Molasses for ethanol: the economic and environmental impacts of a new pathway for the lifecycle greenhouse gas analysis of sugarcane ethanol,” Gopal, A., and Kammen, D., Environmental Research Letters, 4 (2009) 044005 (5pp)."]
[null,"i. Ethanol Production"]
[null,"Total Plant Energy (Btu/gal)"]
[null,"Residual oil",300,null,"CA-GREET2.0"]
[null,"Chemical Use, g/tonne of cane"]
[null,"Lime",880,null,"CA-GREET2.0"]
[null,"j. Fuel Distribution"]
[null,"Distribution by HDT to blending terminal, miles",40,null,"CA-GREET2.0"]
[null,"Distribution by HDT to stations, miles",50,null,"CA-GREET2.0"]
[null,"k. Fuel Properties"]
[null,"Density of EtOH (LHV), grams/gal",2988,null,"CA-GREET2.0"]
[null,"Sugarcane bagasse, Btu/ton",12381771.311916806,null,"CA-GREET2.0"]
[null,"Bagasse yield: wet tonne per wet tonne of sugarcane",0.28000000000000003,null,"CA-GREET2.0"]
[null,"Moisture in bagasse",0.5,null,"CA-GREET2.0"]
[null,"steam generation efficiency",0.8,null,"CA-GREET2.0"]
[null,"Power Generation Efficiency",0.3,null,"CA-GREET2.0"]
[null,"l. Sugarcane bagasse, emissions, grams/mmBtu fuel burned","Small Industrial Boiler",null,"GREET 1 2013"]
[null,"m. Electrciity Mix emissions, grams/mmBtu Available at User Sites","Brazil Electricity Mix",null,"CA-GREET2.0"]
[null,"n. Electric Transmission and Distribution Loss","8.1% (Brazil)",null,"CA-GREET1.8b Appendix"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Unit conversion"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Ethanol fuel properties"]
[null,null,null,"LHV"]
[null,"Density of EtOH, grams/gal",null,2988]
[]
[null,"Sugarcane bagasse, Btu/ton",null,12381771.311916806,null,null,"Bagasse, Btu/metric ton",{"$f":"Reference!D82/Calculation!$Q$18","v":13648566.566404991}]
[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]