{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["EtOH Summary","EtOH","EF Tables","Fuel_Specs","NG and Imported Steam"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":3,"defined_names":45,"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":"EtOH Summary","index":0,"n_rows":32,"n_cols":15,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,2,1,7],[7,9,7,10],[6,2,6,3],[2,3,2,5],[2,6,2,7],[4,3,4,7],[7,6,7,7],[7,2,7,4]]}
[null,null,"Summary of the Tier 1 Starch and Fiber Ethanol Pathway(s) \nRelease Date:  August 13, 2018"]
[]
[null,null,"Applicant:",{"$f":"IF(EtOH!D21=\"\",\"\",EtOH!D21)","v":"ABCDEFG Ethanol"},null,null,{"$f":"CONCATENATE(\"Location:  \",EtOH!D24)","v":"Location:  HIJKLMN City, IA "}]
[null,null,"Application Number",{"$f":"IF(EtOH!H21=\"\",\"\",EtOH!H21)","v":"A0123"}]
[null,null,"Description:",{"$f":"IF(EtOH!G24=\"\",\"\",EtOH!G24)","v":"Midwest Corn ethanol "}]
[]
[null,null,"Feedstock Production Electricity Mix",null,"1- U.S Ave Mix",null,"Fuel Production Electricity Mix",{"$f":"EtOH!BM29","v":"3-CAMX Mix"}]
[null,null,"Feedstock Production",null,null,null,"Fuel Production",null,null,"Different Scenarios of Starch Ethanol Production",null,"Carbon Intensity (gCO2e/MJ)","Conservative Margin of Safety (gCO2e/MJ)","Total Carbon Intensity (gCO2e/MJ)","Correspondent Volumes (denatured gallons)"]
[null,null,"Feedstock Production","Column2","Column1",null,"Fuel Production","Column1",null,"Different Scenarios of Ethanol Production","Column1","Carbon Intensity, g/MJ","Column3","Column2","Correspondent Volumes, gallons"]
[null,null,"Corn Use, bushels",null,{"$f":"EtOH!D57","v":79775294},null,"Total Undenatured Ethanol, gallons",{"$f":"EtOH!AX57","v":218694177},null,null,"Dry DG",{"$f":"EtOH!D12","v":73.859993669256696},0,{"$f":"Table13[[#This Row],[Carbon Intensity, g/MJ]]+Table13[[#This Row],[Column3]]","v":73.859993669256696},{"$f":"EtOH!AG75","v":23759667.384553418}]
[null,null,"Sorghum Use, bushels",null,{"$f":"EtOH!L57","v":0},null,"Total Undenatured Starch Ethanol, gallons",{"$f":"EtOH!AE69+EtOH!AE70","v":215514643.64112416},null,"Corn Ethanol","Modified DG",{"$f":"EtOH!D14","v":0},0,{"$f":"Table13[[#This Row],[Carbon Intensity, g/MJ]]+Table13[[#This Row],[Column3]]","v":0},{"$f":"EtOH!AG76","v":0}]
[null,null,"Ethanol Yield, gal/bushels",null,{"$f":"EtOH!E80","v":2.7413772614864946},null,"Total Undenatured Fiber Ethanol, gallons",{"$f":"EtOH!BE57","v":3179533.3588758316},null,null,"Wet DG",{"$f":"EtOH!D16","v":64.072442660290676},0,{"$f":"Table13[[#This Row],[Carbon Intensity, g/MJ]]+Table13[[#This Row],[Column3]]","v":64.072442660290676},{"$f":"EtOH!AG77","v":195669027.42746791}]
[]
[null,null,"Feedstock Transport (Weighted Average)",null,null,null,"Energy Consumption",null,null,null,"Dry DG",{"$f":"EtOH!G12","v":0},0,{"$f":"Table13[[#This Row],[Carbon Intensity, g/MJ]]+Table13[[#This Row],[Column3]]","v":0},{"$f":"EtOH!AJ75","v":0}]
[null,null,"Corn Transport by HD Truck, miles",null,{"$f":"EtOH!H57","v":33.313526751255957},null,"Natural, HHV in MMBtu",{"$f":"EtOH!BG57","v":4468320},null,"Sorghum Ethanol","Modified DG",{"$f":"EtOH!G14","v":0},0,{"$f":"Table13[[#This Row],[Carbon Intensity, g/MJ]]+Table13[[#This Row],[Column3]]","v":0},{"$f":"EtOH!AJ76","v":0}]
[null,null,"Corn Transport by Rail, miles",null,{"$f":"EtOH!J57","v":"0"},null,"Biogas, HHV in MMBtu",{"$f":"EtOH!BH57","v":0},null,null,"Wet DG",{"$f":"EtOH!G16","v":0},0,{"$f":"Table13[[#This Row],[Carbon Intensity, g/MJ]]+Table13[[#This Row],[Column3]]","v":0},{"$f":"EtOH!AJ77","v":0}]
[null,null,null,null,null,null,"Biomass, Tons",{"$f":"EtOH!BI57","v":0}]
[null,null,"Sorghum Transport by HD Truck, miles",null,{"$f":"EtOH!P57","v":"0"},null,"Electricity, kWh",{"$f":"EtOH!BL57","v":116572914},null,"Corn/Sorghum Fiber Ethanol",null,{"$f":"EtOH!J10","v":24.20061441792167},0,{"$f":"Table13[[#This Row],[Carbon Intensity, g/MJ]]+Table13[[#This Row],[Column3]]","v":24.20061441792167},{"$f":"EtOH!AG78","v":3237278.1879786639}]
[null,null,"Sorghum Transport by Rail, miles",null,{"$f":"EtOH!R57","v":"0"},null,"Other Electricity, kWh",{"$f":"EtOH!BM57","v":0}]
[null,null,null,null,null,null,null,null,null,"Corn Ethanol","Composite ",{"$f":"IFERROR((L10*O10+L11*O11+L12*O12)/O20,0)","v":65.132235485844333},0,{"$f":"Table13[[#This Row],[Carbon Intensity, g/MJ]]+Table13[[#This Row],[Column3]]","v":65.132235485844333},{"$f":"EtOH!AE75","v":219428694.81202132}]
[null,null,"Co-Product Yield, bone-dry lb./gal",null,{"$f":"EtOH!AS57","v":5.0934875855428006},null,"Chemical Usage for Cellulosic",null,null,"Sorghum Ethanol","Composite",{"$f":"IFERROR((L14*O14+L15*O15+L16*O16)/O21,0)","v":0},0,{"$f":"Table13[[#This Row],[Carbon Intensity, g/MJ]]+Table13[[#This Row],[Column3]]","v":0},{"$f":"EtOH!AE76","v":0}]
[null,null,"Dry Distiller Grains, tons",null,{"$f":"EtOH!T57","v":66653},null,"Cellulosic Enzyme, lbs.",{"$f":"EtOH!BB57","v":0}]
[null,null,"Moisture, %",null,{"$f":"EtOH!W57","v":0.12628754894753424}]
[null,null,"Drying Energy, HHV in MMBtu",null,{"$f":"EtOH!X57","v":287991},null,"Fuel Transport"]
[null,null,"Modified Distiller Grains, tons",null,{"$f":"EtOH!Z57","v":0},null,"By HD Truck, miles",{"$f":"EtOH!BO35","v":53}]
[null,null,"Moisture, %",null,{"$f":"EtOH!AC57","v":0},null,"By Rail, miles",{"$f":"EtOH!BO33","v":2056}]
[null,null,"Drying Energy, HHV in MMBtu",null,{"$f":"EtOH!AD57","v":0}]
[null,null,"Wet Distiller Grains, tons",null,{"$f":"EtOH!AF57","v":1347074},null,"Denaturant Usage",{"$f":"IFERROR(EtOH!AY57/EtOH!AU57,0)","v":2.4174734901773957E-2}]
[null,null,"Moisture, %",null,{"$f":"EtOH!AI57","v":0.64397663380037029},null,"Denaturant, gallons",{"$f":"EtOH!AY57","v":3971796}]
[null,null,"Syrup DGS, tons",null,{"$f":"EtOH!AK57","v":0}]
[null,null,"Moisture, %",null,{"$f":"EtOH!AN57","v":0}]
[null,null,"Corn Oil, tons",null,{"$f":"EtOH!AP57/2000","v":19325.920999999998}]

{"sheet":"EtOH","index":1,"n_rows":113,"n_cols":69,"rows_kept":113,"cut":false,"hidden":false,"merged":[[72,29,72,36],[78,29,78,30],[76,8,76,10],[76,4,76,7],[75,1,75,10],[76,2,76,3],[90,2,90,3],[89,2,89,3],[81,2,81,3],[79,2,79,3],[67,4,67,5],[67,2,67,3],[91,2,91,3],[105,2,105,3],[107,2,107,3],[109,2,109,3],[96,2,96,3],[93,2,93,3],[95,2,95,3],[97,2,97,3],[103,2,103,3],[98,2,98,3],[100,2,100,3],[1,4,1,10],[23,1,23,2],[20,1,20,2],[11,4,11,5],[12,1,12,2],[12,4,12,5],[13,1,13,2],[13,4,13,5],[14,1,14,2],[22,1,22,2],[21,1,21,2],[20,3,20,5],[14,4,14,5],[15,1,15,2],[5,1,5,2],[11,1,11,2],[8,1,8,9],[9,1,9,2],[9,4,9,5],[9,7,9,8],[10,1,10,2],[10,4,10,5],[10,7,10,8],[30,65,30,66],[29,51,29,56],[29,65,29,66],[29,24,29,29],[29,30,29,34],[29,35,29,39],[66,39,66,40],[67,41,67,44],[67,25,67,28],[64,1,64,68],[58,65,58,66],[67,45,67,48],[67,12,67,13],[67,6,67,7],[25,4,25,7],[28,1,28,5],[29,1,29,5],[59,62,60,62],[59,59,60,59],[29,8,29,9],[29,18,29,23],[28,6,28,9],[59,60,60,60],[28,58,28,63],[29,45,29,49],[28,45,28,56],[29,14,29,15],[28,10,28,13],[29,16,29,17],[30,14,30,17],[30,6,30,9],[67,8,67,9],[67,10,67,11],[66,29,66,36],[66,37,66,38],[24,3,24,7],[15,4,15,5],[40,65,42,66],[29,58,29,64],[29,40,29,43],[29,10,29,13],[16,4,16,5],[28,18,28,44],[19,1,19,7],[21,3,21,7],[22,3,22,7],[23,3,23,4],[23,6,23,7],[24,1,24,2],[28,14,28,17],[16,1,16,2]]}
[]
[]
[]
[]
[]
[]
[null,null,"LCFS Tier 1 Simplified CI Calculator for Starch and Fiber Ethanol"]
[]
[null,"Pathway Summary and Estimated CI (g/MJ)",null,null,null,null,null,null,null,null,null,"Yellow Cells require user input"]
[null,"Corn Ethanol Composite CI, g/MJ ",null,{"$f":"IFERROR((D12*D13+D14*D15+D16*D17)/AE75,0)","v":65.132235485844333},"Sorghum Ethanol (Composite CI), g/MJ ",null,{"$f":"IFERROR((G12*G13+G14*G15+G16*G17)/AE76,0)","v":0},"Corn/Sorghum Fiber Ethanol CI, g/MJ",null,{"$f":"IF(BE57=0,0,(H89+H93+H97+H103+H105+H107+H109+H99+H101)*'EF Tables'!D77+(H111+H112+H113))","v":24.20061441792167},null,"Light Blue Cells show CI results "]
[null,"Denatured Volume, gal",null,{"$f":"AE75","v":219428694.81202132},"Denatured Volume, gal ",null,{"$f":"AE76","v":0},"Denatured Ethanol Volume, gal ",null,{"$f":"AE78","v":3237278.1879786639},null,"Green Cells show the calculation button"]
[null,"Corn Ethanol (Dry DGS) CI, g/MJ",null,{"$f":"IF(OR(D57=0,T57=0),0,(E82+E84+E86+E93+E95+E97+E103+E105+E107+E109+E99+E101)*'EF Tables'!D77+(E111+E112+E113))","v":73.859993669256696},"Sorghum Ethanol (Dry DGS) CI, g/MJ",null,{"$f":"IF(OR(T57=0,L57=0),0,(I82+I84+I86+I93+I95+I97+I103+I105+I107+I109+I99+I101)*'EF Tables'!D77+(I111+I112+I113))","v":0},null,null,null,null,"Gray Cells are Calculated Values"]
[null,"Denatured Volume, gal",null,{"$f":"AG75","v":23759667.384553418},"Denatured Volume, gal",null,{"$f":"AJ75","v":0}]
[null,"Corn Ethanol (Modified DGS) CI, g/MJ",null,{"$f":"IF(OR(D57=0,Z57=0),0,(F82+F84+F86+F93+F95+F97+F103+F105+F107+F109+F99+F101)*'EF Tables'!D77+(F111+F112+F113))","v":0},"Sorghum Ethanol (Modified DGS) CI, g/MJ",null,{"$f":"IF(OR(Z57=0,L57=0),0,(J82+J84+J86+J93+J95+J97+J103+J105+J107+J109+J99+J101)*'EF Tables'!D77+(J111+J112+J113))","v":0}," "," "," "]
[null,"Denatured Volume, gal",null,{"$f":"AG76","v":0},"Denatured Volume, gal",null,{"$f":"AJ76","v":0}," "," "," "]
[null,"Corn Ethanol (Wet DGS) CI, g/MJ",null,{"$f":"IF(OR(D57=0,AF57=0), 0,(G82+G84+G86+G93+G95+G97+G103+G105+G107+G109+G99+G101)*'EF Tables'!D77+(G111+G112+G113))","v":64.072442660290676},"Sorghum Ethanol (Wet DGS) CI, g/MJ",null,{"$f":"IF(OR(AF57=0,L57=0),0,(K82+K84+K86+K93+K95+K97+K103+K105+K107+K109+K99+K101)*'EF Tables'!D77+(K111+K112+K113))","v":0}," "," "," "]
[null,"Denatured Volume, gal",null,{"$f":"AG77","v":195669027.42746791},"Denatured Volume, gal",null,{"$f":"AJ77","v":0}," "," "," "]
[]
[]
[null,"Section 1.  Applicant Information"]
[null,"1.1. Company Name",null,"ABCDEFG Ethanol",null,null,"1.2. Application Number","A0123"]
[null,"1.3. Company ID ",null,1234]
[null,"1.4. Facility ID",null,1234]
[null,"1.5. Ethanol Production Location \n(City, State)",null,"HIJKLMN City, IA ",null,"1.6. Application Description","Midwest Corn ethanol "]
[null,"1.7. Electricity Mix Region for Feedstock",null,"1-U.S Ave Mix"]
[null,"1.8. Provisional Pathway?",null,"No"]
[]
[null,"Section 2. Feedstock Production Data for Starch Ethanol Production",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Section 3. Fuel Production Energy Consumption and Fuel Transport Data"]
[null,"Corn as Feedstock",null,null,null,null," Corn Transport ",null,null,null,"Sorghum as Feedstock",null,null,null,"Sorghum Transport",null,null,null,"Co-Product Production",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,"Fuel Production",null,null,null,null,null,null,null,null,null,null,null,null,"3.1. Electricity Mix Region for Fuel",null,null,null,null,null,"3-CAMX Mix",{"$f":"IF(BM29=\"2-User Defined Mix\",\"3.10. Enter Electricity Generation GHG Emission Factor \n(gCO2e/kWh)\",\"\")","v":""}]
[null,"Corn Inventory",null,null,null,null,"2.6. Corn Transport Data Category",null,"Conditional Default for Ethanol Plants in CA",null,"Sorghum Inventory",null,null,null,"2.12. Sorghum Transport Data Category",null,"User-Defined for Sorghum Transport",null,"Dry Distiller Grains",null,null,null,null,null,"Modified Distiller Grains",null,null,null,null,null,"Wet Distiller Grains",null,null,null,null,"Syrup",null,null,null,null,"Corn/Sorghum Oil",null,null,null,null,"Starch Ethanol Production",null,null,null,null,"2.46. \nDenaturant Data Category","Cellulosic Ethanol Production",null,null,null,null,null,null,"Energy Consumption ",null,null,null,null,null,null,"Fuel Transport and Distribution"]
[null,"2.1. \nReporting Month\n(MM/YYYY)","2.2. \nBeginning Corn Inventory","2.3. \nCorn Used (Calculated)","2.4. \nCorn Received","2.5. \nEnding Corn Inventory","2.7. Corn Transport from Collection Center to Ethanol Plant \n(Monthly weighted average)",null,null,null,"2.8. \nBeginning Sorghum Inventory","2.9. \nSorghum Used (Calculated)","2.10. \nSorghum Received","2.11. \nEnding Sorghum Inventory","2.13. Sorghum Transport from Collection Center to Ethanol Plant \n(Monthly weighted average)",null,null,null,"2.14. \nDry DG Beginning Inventory","2.15. \nDry Distiller Grains Produced","2.16. \nDry Distiller Grains Sales","2.17. \nDry DG Ending Inventory","2.18. \nMoisture Content \n(Monthly weighted average)","2.19. \nDrying Energy (metered)","2.20. \nModified DG Beginning Inventory","2.21. \nModified Distiller Grains Produced","2.22. \nModified Distiller Grains Sales","2.23. Modified DG Ending Inventory","2.24. \nMoisture Content \n(Monthly weighted average)","2.25. \nDrying Energy (metered)","2.26. \nWet DG Beginning Inventory","2.27. \nWet Distiller Grains Produced ","2.28. \nWet Distiller Grains Sales","2.29. \nWet DG Ending Inventory","2.30. \nMoisture Content (Monthly weighted average)","2.31.\nSyrup Beginning Inventory","2.32. \nSyrup Produced","2.33. \nSyrup Sales","2.34. \nSyrup Ending Inventory","2.35. \nMoisture Content (Monthly weighted average)","2.36. \nBeginning Oil Inventory","2.37. \nOil Produced","2.38. \nOil Sales","2.39. \nEnding Oil Inventory","2.40. \nCo-product Yield","2.41. \nBeginning Undenatured Ethanol ","2.42. \nDenatured Ethanol Sales ","2.43. \nUndenatured Ethanol Sales","2.44. \nEnding Undenatured Ethanol ","2.45. \nUndenatured Ethanol Produced","User-Defined Denaturant","2.47. \nBeginning Cellulosic Enzyme","2.48. \nCellulosic Enzyme Purchase","2.49. \nCellulosic Enzyme Use","2.50. \nEnding Cellulosic Enzyme","2.51. \nCorn/Sorghum\nFiber Allocation","2.52. \nUndenatured Corn/Sorghum\nFiber Ethanol",null,"3.2. \nNG Use","3.3. \nBiogas Use","3.4.\nBiomass Use","3.5.\nBiomass Moisture","3.6.\nBiomass Transport","3.7. \nElectricity Use from grid","3.8. \nElectricity from Co-located Solar or Wind","3.9. Finished Fuel Transport"]
[null,null,"Bushels","Bushels","Bushels","Bushels","2.7.a\nCorn Transported by HDDT \n(bushels)"," 2.7.b\nHDDT Mileage, miles","2.7.c\nCorn Transported by Rail \n(bushels)","2.7.d\nRail Mileage, miles","Bushels","Bushels","Bushels","Bushels","2.13.a\nSorghum Transported by HDDT (bushels)","2.13.b\nHDDT Mileage, miles","2.13.c\nSorghum Transported by Rail (bushels)","2.13.d\nRail Mileage, miles","Tons","Tons","Tons","Tons","%","mmBTU, HHV","Tons","Tons","Tons","Tons","%","mmBTU, HHV","Tons","Tons","Tons","Tons","%","Tons","Tons","Tons","Tons","%","lbs.","lbs.","lbs.","lbs.","Dry matter lbs./gal EtOH","Gallons \n@ 60o F","Gallons \n@ 60o F","Gallons \n@ 60o F","Gallons \n@ 60o F","Gallons \n@ 60o F","Gallons \n@ 60o F","lbs.","lbs.","lbs.","lbs.","%","Gallons @ \n60o F",null,"mmBTU (HHV)","mmBTU, HHV","Tons","%","Miles","kWh","kWh","Mode","Miles"]
[null,"2017-05-01",3545450,{"$f":"C33+E33-F33","v":1998327},1604333,3151456,1604333,30,null,null,null,{"$f":"K33+M33-N33","v":0},null,null,null,null,null,null,126,{"$f":"V33-S33+U33","v":3045},1533,1638,0.129,13162,null,{"$f":"AB33-Y33+AA33","v":0},null,null,null,null,1638,{"$f":"AH33-AE33+AG33","v":58904},59408,1134,0.66,null,{"$f":"AM33-AJ33+AL33","v":0},null,null,null,139034,{"$f":"AR33-AO33+AQ33","v":1763296},1778200,124130,{"$f":"IFERROR((((T33*(1-W33)+Z33*(1-AC33)+AF33*(1-AI33)+AK33*(1-AN33))*2000)+AP33*(1-0.01))/AX33,0)","v":5.0794807549780598},1115397,6551405,2850593,1152766,{"$f":"AW33-AT33+AU33+AV33-AY33","v":9273541},165826,null,null,{"$f":"AZ33-BC33+BA33","v":0},null,null,{"$f":"IFERROR(BD33*(AX33),0)","v":0},null,{"$f":"'NG and Imported Steam'!E4","v":177993},null,null,null,null,4717421,null,"3.9.a. By Rail",2056]
[null,"2017-06-01",3151456,{"$f":"C34+E34-F34","v":1894171},1812129,3069414,1812129,30,null,null,null,{"$f":"K34+M34-N34","v":0},null,null,null,null,null,null,1638,{"$f":"V34-S34+U34","v":2604},2352,1890,0.13600000000000001,10949,null,{"$f":"AB34-Y34+AA34","v":0},null,null,null,null,1134,{"$f":"AH34-AE34+AG34","v":54845},55097,882,0.65,null,{"$f":"AM34-AJ34+AL34","v":0},null,null,null,124130,{"$f":"AR34-AO34+AQ34","v":1178640},1147500,155270,{"$f":"IFERROR((((T34*(1-W34)+Z34*(1-AC34)+AF34*(1-AI34)+AK34*(1-AN34))*2000)+AP34*(1-0.01))/AX34,0)","v":9.4596807099495042},1152766,5097145,0,928299,{"$f":"AW34-AT34+AU34+AV34-AY34","v":4657458},215220,null,null,{"$f":"AZ34-BC34+BA34","v":0},null,2.2100000000000002E-2,{"$f":"IFERROR(BD34*(AX34),0)","v":102929.82180000001},null,{"$f":"'NG and Imported Steam'!E5","v":177879},null,null,null,null,5156131]
[null,"2017-07-01",3069414,3772665,3998121,3294870,3998121,30,null,null,null,{"$f":"K35+M35-N35","v":0},null,null,null,null,null,null,1890,{"$f":"V35-S35+U35","v":743},2507,126,0.08,550,null,{"$f":"AB35-Y35+AA35","v":0},null,null,null,null,882,62367,62367,882,0.66,null,{"$f":"AM35-AJ35+AL35","v":0},null,null,null,155270,1331733,1436180,50823,{"$f":"IFERROR((((T35*(1-W35)+Z35*(1-AC35)+AF35*(1-AI35)+AK35*(1-AN35))*2000)+AP35*(1-0.01))/AX35,0)","v":3.3261270966560379},928299,8104074,5810580,653623,{"$f":"AW35-AT35+AU35+AV35-AY35","v":13557839},82139,null,null,0,null,2.2100000000000002E-2,{"$f":"IFERROR(BD35*(AX35),0)","v":299628.24190000002},null,{"$f":"'NG and Imported Steam'!E6","v":199886},null,null,null,null,5156661,null,"3.9.b. By HDD Truck",53]
[null,"2017-08-01",3294870,4424883,3998250,2868237,3998250,30,null,null,null,0,null,null,null,null,null,null,126,1745,1720,151,0.08,2254,null,0,null,null,null,null,882,49014,48132,1764,0.57999999999999996,null,0,null,null,null,50823,1178903,1051500,178226,8.8179000528884206,653623,5249144,0,749034,5165592,178963,null,null,{"$f":"AZ36-BC36+BA36","v":0},null,1.8863653246326838E-2,{"$f":"IFERROR(BD36*(AX36),0)","v":97441.936299999943},null,{"$f":"'NG and Imported Steam'!E7","v":199994},null,null,null,null,5157587]
[null,"2017-09-01",2868237,4428661,3912113,2351689,3912113,30,null,null,null,0,null,null,null,null,null,null,151,5828,5525,454,0.13600000000000001,23999,null,0,null,null,null,null,1764,47585,48341,1008,0.66,null,0,null,null,null,178226,1712134,1802960,87400,3.954309107128485,749034,8239332,2844075,979921,11158358,155936,null,null,{"$f":"AZ37-BC37+BA37","v":0},null,null,{"$f":"IFERROR(BD37*(AX37),0)","v":0},null,{"$f":"'NG and Imported Steam'!E8","v":199986},null,null,null,null,5157462]
[null,"2017-10-01",2351689,4851134,3700000,1200555,3698239,30,null,null,null,0,null,null,null,null,null,null,454,3780,3604,630,0.13600000000000001,14274,null,0,null,null,null,null,1008,54686,54938,756,0.65,null,0,null,null,null,87400,2076696,1978040,186056,6.3149382909341467,979921,6194833,1689555,672500,7421762,155205,null,null,0,null,1.8499999999999999E-2,137302.59699999998,null,{"$f":"'NG and Imported Steam'!E9","v":200066},null,null,null,null,5156492]
[null,"2017-11-01",1339281,3838726,3700000,1200555,3398389,30,null,null,null,0,null,null,null,null,null,null,630,3226,3604,252,0.13600000000000001,42000,null,0,null,null,null,null,756,53267,53267,756,0.66,null,0,null,null,null,186056,2218282,2213760,190578,3.9503400032901395,672500,5317613,5200114,1448501,11136304,157424,null,null,0,null,1.8499999999999999E-2,206021.62399999998,null,{"$f":"'NG and Imported Steam'!E10","v":201074},null,null,null,null,5156492]
[null,"2017-12-01",2348865,3642779,3918174,2624260,3918174,30,null,null,null,0,null,null,null,null,null,null,252,4880,4502,630,0.126,17726,null,0,null,null,null,null,756,54337,54085,1008,0.65,null,0,null,null,null,190578,2080693,2235900,35371,6.163608449460237,1448501,8182478,489500,866789,7889214,201052,null,null,0,null,1.5169544012876323E-2,119675.77900000007,null,200000,null,null,null,null,5156492]
[null,"2018-01-01",2624260,3939038,3998384,2683606,3998384,35,null,null,null,0,null,null,null,null,null,null,630,2072,2198,504,0.13900000000000001,6833,null,0,null,null,null,null,1008,45618,46122,504,0.57999999999999996,null,0,null,null,null,35371,1490614,1438460,87525,6.1577523304146968,866789,4836517,1847766,1309814,{"$f":"AW41-AT41+AU41+AV41-AY41","v":7041987},85321,null,null,0,null,2.4400000000000002E-2,171824.4828,null,199900,null,null,null,null,5156492,null,"Finished Fuel Distribution Standard Value is at 90 miles by HDDT"]
[null,"2018-02-01",2683606,2090185,3997935,4591356,3997935,35,null,null,null,0,null,null,null,null,null,null,504,1805,2259,50,0.126,7435,null,0,null,null,null,null,504,59366,58736,1134,0.65,null,0,null,null,null,87525,2164875,2110640,141760,5.4321073908183264,1309814,5142198,3555415,1402400,{"$f":"AW42-AT42+AU42+AV42-AY42","v":8625486},164713,null,null,0,null,2.4400000000000002E-2,210461.85840000003,null,{"$f":"'NG and Imported Steam'!E13","v":166416},null,null,null,null,5158121]
[null,"2018-03-01",4591356,2911008,2931971,4612319,2931971,35,null,null,null,0,null,null,null,null,null,null,50,1605,1403,252,0.128,7209,null,0,null,null,null,null,1134,58643,59021,756,0.65,null,0,null,null,null,141760,1866364,1907380,100744,8.7407148244289026,1402400,3139562,2555210,1025893,5228053,90212,null,null,0,null,1.6285666250648683E-2,85142.326298702596,null,{"$f":"'NG and Imported Steam'!E14","v":167238},null,null,null,null,5157014]
[null,"2018-04-01",4612319,2129142,2958178,5441355,2958178,35,null,null,null,0,null,null,null,null,null,null,252,2502,2250,504,0.124,9901,null,0,null,null,null,null,756,60033,60183,606,0.64,null,0,null,null,null,100744,1374673,1344380,131037,3.4135042906692727,1025893,8001362,5910312,1692101,14345431,232451,null,null,0,null,null,0,null,{"$f":"'NG and Imported Steam'!E15","v":180011},null,null,null,null,5158036]
[null,"2018-05-01",5441355,2524248,2957835,5874942,2957835,35,null,null,null,0,null,null,null,null,null,null,504,3150,2999,655,0.126,15143,null,0,null,null,null,null,606,54197,53291,1512,0.65,null,0,null,null,null,131037,1673907,1709020,95924,4.4009339016851197,1692101,5691696,5555440,779854,10248113,86776,null,null,0,null,3.0099999999999998E-2,308468.20129999996,null,{"$f":"'NG and Imported Steam'!E16","v":187325},null,null,null,null,5157519]
[null,"2018-06-01",5874942,3562533,2963066,5275475,2963066,35,null,null,null,0,null,null,null,null,null,null,655,3645,3796,504,0.128,13294,null,0,null,null,null,null,1512,51846,52602,756,0.65,null,0,null,null,null,95924,1292675,1311200,77399,5.2649868257958383,779854,5149028,3325990,784734,8343578,136320,null,null,0,null,2.86E-2,238626.3308,null,{"$f":"'NG and Imported Steam'!E17","v":181087},null,null,null,null,5158105]
[null,"2018-07-01",5275475,4889315,2937465,3323625,2937465,35,null,null,null,0,null,null,null,null,null,null,504,2757,2807,454,0.13,9500,null,0,null,null,null,null,756,59464,59338,882,0.65,null,0,null,null,null,77399,1603664,1576928,104135,3.1864385341200929,784734,9848801,5555556,660814,15066855,213582,null,null,0,null,1.2200000000000001E-2,183815.63100000002,null,{"$f":"'NG and Imported Steam'!E18","v":183921},null,null,null,null,2244680]
[null,"2018-08-01",3323625,2869749,2957851,3411727,2957851,35,null,null,null,0,null,null,null,null,null,null,454,841,917,378,0.107,3908,null,0,null,null,null,null,882,52044,51565,1361,0.62,null,0,null,null,null,104135,1383608,1329560,158183,4.5247003977234677,660814,6101912,3022151,1016519,9376364,103404,null,null,0,null,1.2200000000000001E-2,114391.64080000001,null,{"$f":"'NG and Imported Steam'!E19","v":138304},null,null,null,null,5655716]
[null,"2018-09-01",3411727,3647867,2944894,2708754,2944894,35,null,null,null,0,null,null,null,null,null,null,378,4372,3616,1134,0.107,16938,null,0,null,null,null,null,1361,56234,56839,756,0.65,null,0,null,null,null,158183,1589843,1617100,130926,5.2339342333836791,1016519,9012489,1000078,473715,9313479,156284,null,null,0,null,2.98E-2,277541.67420000001,null,{"$f":"'NG and Imported Steam'!E20","v":182645},null,null,null,null,5155765]
[null,"2018-10-01",2708754,3468685,3358145,2598214,3358145,35,null,null,null,0,null,null,null,null,null,null,1134,3293,3923,504,0.107,14329,null,0,null,null,null,null,756,56403,56277,882,0.65,null,0,null,null,null,130926,1507959,1570890,67995,6.4893064615554215,473715,6251400,1100078,543445,7220537,200671,null,null,0,null,3.554765431143582E-2,256673.15321893187,null,{"$f":"'NG and Imported Steam'!E21","v":189662},null,null,null,null,5157443]
[null,"2018-11-01",2598214,3374450,2955033,2178797,2955033,35,null,null,null,0,null,null,null,null,null,null,504,4583,3701,1386,0.13,19507,null,0,null,null,null,null,882,54793,54667,1008,0.65,null,0,null,null,null,67995,1768948,1635900,201043,5.5282527336410698,543445,7360414,1065061,1025764,8697283,210511,null,null,0,null,1.7999999999999999E-2,156551.09399999998,null,{"$f":"'NG and Imported Steam'!E22","v":189930},null,null,null,null,5157043]
[null,"2018-12-01",2178797,3026272,2958220,2110745,2958220,35,null,null,null,0,null,null,null,null,null,null,1386,4256,4505,1137,0.13100000000000001,15570,null,0,null,null,null,null,1008,57790,57790,1008,0.65,null,0,null,null,null,201043,1606479,1633520,174002,7.395102485179982,1025764,6250072,1000078,677893,6685552,216727,null,null,0,null,1.7999999999999999E-2,120339.93599999999,null,{"$f":"'NG and Imported Steam'!E23","v":185330},null,null,null,null,5157500]
[null,"2019-01-01",2110745,1949966,3957842,4118621,3957842,35,null,null,null,0,null,null,null,null,null,null,1137,1504,1885,756,0.14099999999999999,6781,null,0,null,null,null,null,1008,54005,54635,378,0.61,null,0,null,null,null,174002,1325866,1306780,193088,4.9041805759391517,677893,8245745,1008335,987755,9383908,180034,null,null,0,null,9.8782969801277376E-3,{"$f":"IFERROR(BD53*(AX53),0)","v":92697.030058196513},null,{"$f":"'NG and Imported Steam'!E24","v":199332},null,null,null,null,3830586]
[null,"2019-02-01",4118621,2452940,3958457,5624138,3958457,35,null,null,null,0,null,null,null,null,null,null,756,1823,2503,76,0.13100000000000001,6139,null,0,null,null,null,null,378,67045,66188,1235,0.65,null,0,null,null,null,193088,2064962,2098640,159410,3.6725235719192679,987755,11359236,3104696,876677,14198462,154392,null,null,0,null,null,0,null,{"$f":"'NG and Imported Steam'!E25","v":182098},null,null,null,null,4637104]
[null,"2019-03-01",5624138,{"$f":"C55+E55-F55","v":5885976},2958173,2696335,2958173,35,null,null,null,0,null,null,null,null,null,null,76,631,682,25,0.128,2234,null,0,null,null,null,null,1235,63494,63595,1134,0.65,null,0,null,null,null,159410,1055057,1095220,119247,4.1205142881047072,876677,6279039,0,6116320,11307028,211654,null,null,0,null,null,0,null,{"$f":"'NG and Imported Steam'!E26","v":200356},null,null,null,null,4009844]
[null,"2019-04-01",2696335,2202574,2958015,3451776,2958015,35,null,null,null,0,null,null,null,null,null,null,25,1963,1686,302,0.13400000000000001,8356,null,0,null,null,null,null,1134,61094,61472,756,0.66,null,0,null,null,null,119247,1341971,1295060,166158,13.804440310585372,6116320,8689833,0,995459,3351993,216979,null,null,0,null,null,0,null,{"$f":"'NG and Imported Steam'!E27","v":177887},null,null,null,null,3807208]
[null,"Total or Ave.",null,{"$f":"SUM(D33:D56)","v":79775294},{"$f":"SUM(E33:E56)","v":78394584},null,{"$f":"SUM(G33:G56)","v":78091212},{"$f":"IFERROR((IF(MAX($H33:$H56)=0,\"0\",(SUMPRODUCT(G33:G56,H33:H56)/G57))),0)","v":33.313526751255957},{"$f":"SUM(I33:I56)","v":0},{"$f":"IFERROR((IF(MAX($J33:$J56)=0,\"0\",(SUMPRODUCT(I33:I56,J33:J56)/I57))),0)","v":"0"},null,{"$f":"SUM(L33:L56)","v":0},{"$f":"SUM(M33:M56)","v":0},null,{"$f":"SUM(O33:O56)","v":0},{"$f":"IFERROR(SUMPRODUCT($O$33:$O$56,P33:P56)/SUM(O33:O56),\"0\")","v":"0"},{"$f":"SUM(Q33:Q56)","v":0},{"$f":"IFERROR(SUMPRODUCT($Q$33:$Q$56,R33:R56)/SUM($Q$33:$Q$56),\"0\")","v":"0"},null,{"$f":"SUM(T33:T56)","v":66653},{"$f":"SUM(U33:U56)","v":66477},null,{"$f":"IFERROR(SUMPRODUCT(T33:T56,W33:W56)/T57,0)","v":0.12628754894753424},{"$f":"SUM(X33:X56)","v":287991},null,{"$f":"SUM(Z33:Z56)","v":0},{"$f":"SUM(AA33:AA56)","v":0},null,{"$f":"IFERROR(SUMPRODUCT(Z33:Z56,AC33:AC56)/(Z57),0)","v":0},{"$f":"SUM(AD33:AD56)","v":0},null,{"$f":"SUM(AF33:AF56)","v":1347074},{"$f":"SUM(AG33:AG56)","v":1347956},null,{"$f":"IFERROR(SUMPRODUCT(AF33:AF56,AI33:AI56)/AF57,0)","v":0.64397663380037029},null,{"$f":"SUM(AK33:AK56)","v":0},{"$f":"SUM(AL33:AL56)","v":0},null,{"$f":"IFERROR(SUMPRODUCT(AK33:AK56,AN33:AN56)/AK57,0)","v":0},null,{"$f":"SUM(AP33:AP56)","v":38651842},{"$f":"SUM(AQ33:AQ56)","v":38624718},null,5.0934875855428006,{"$f":"SUM(AT33:AT56)","v":27940528},{"$f":"SUM(AU33:AU56)","v":164295328},{"$f":"SUM(AV33:AV56)","v":58490583},27820590,{"$f":"AW57-AT57+AU57+AV57-AY57","v":218694177},{"$f":"SUM(AY33:AY56)","v":3971796},null,{"$f":"SUM(BA33:BA56)","v":0},{"$f":"SUM(BB33:BB56)","v":0},null,{"$f":"IFERROR(SUMPRODUCT(BD33:BD56,BE33:BE56)/BE57,0)","v":2.2851871518922182E-2},{"$f":"SUM(BE33:BE56)","v":3179533.3588758316},null,{"$f":"SUM(BG33:BG56)","v":4468320},{"$f":"SUM(BH33:BH56)","v":0},{"$f":"SUM(BI33:BI56)","v":0},{"$f":"IFERROR(SUMPRODUCT(BI33:BI56,BJ33:BJ56)/BI57,0)","v":0},{"$f":"IFERROR(SUMPRODUCT(BI33:BI56,BK33:BK56)/BI57,0)","v":0},{"$f":"SUM(BL33:BL56)","v":116572914},{"$f":"SUM(BM33:BM56)","v":0}]
[null,"Total mmBTU in HHV",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X57","v":287991},null,null,null,null,null,{"$f":"AD57","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":"BG57","v":4468320},null,{"$f":"BI57*(1-BJ57)","v":0}]
[null,"Convert to mmBTU, in LHV",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X58*Fuel_Specs!$H$10","v":260030.7087378641},null,null,null,null,null,{"$f":"AD58*Fuel_Specs!$H$10","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":"BG58*Fuel_Specs!$H$10","v":4034502.5242718449},{"$f":"BH57*Fuel_Specs!H11","v":0},null,null,null,null,null,"Finished Fuel Transport"]
[null,"Convert to BTU/gallons fuel throughput",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(BG59-AD59-X59)","v":3774471.8155339807},"3.3.a.\nEmission Factor for Biogas \ngCO2e/mmBTU","3.4.a.\nEmission Factor for Biomass \ngCO2e/dry ton",null,"3.6.a.\nEmission Factor for Biomass Transportation\ngCO2e/dry ton-mile",null,null,"HDD Truck","Rail"]
[null,"EF Units",null,"gCO2e/bushel",null,null,null,"gCO2e/bushel-mile",null,"gCO2e/bushel-mile",null,"gCO2e/bushel",null,null,null,"gCO2e/bushel-mile",null,"gCO2e/bushel-mile",null,null,null,null,null,"gCO2e/mmBTU NG",null,null,null,null,null,"gCO2e/mmBTU NG",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"gCO2e/lb DGS",null,null,null,null,null,null,null,null,"gCO2e/lb Enzyme",null,null,null,null,"gCO2e/mmBTU NG",null,null,null,null,"gCO2e/kWh","gCO2e/kWh","gCO2e/gal-mile","gCO2e/gal-mile"]
[null,"EF",null,{"$f":"'EF Tables'!G15","v":6442.0202632017244},null,null,null,4.3089549637508835,null,0.76393201937416344,null,{"$f":"'EF Tables'!G24","v":7267.7591501977295},null,null,null,4.3089549637508835,null,0.76393201937416344,null,null,null,null,null,73364.594643031145,null,null,null,null,null,73364.594643031145,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'EF Tables'!F56","v":179.05829368959908},null,null,null,null,null,null,null,null,1207.0688246826328,null,null,null,null,73424.194643031136,null,null,null,null,{"$f":"HLOOKUP($BM$29,'EF Tables'!$C$2:$AF$5,2,FALSE)","v":370.21536152172285},0,0.41360800857768881,8.9863129511840931E-2]
[null,"GHG Emissions, gCO2e",null,{"$f":"D57*D62","v":513914060450.87494},null,null,null,{"$f":"G57*H57*H62","v":11209719105.602552},null,{"$f":"I57*J57*J62","v":0},null,{"$f":"L57*L62","v":0},null,null,null,{"$f":"O57*P57*P62","v":0},null,{"$f":"Q57*R57*R62","v":0},null,null,null,null,null,{"$f":"X59*X62","v":19077047541.293495},null,null,null,null,null,{"$f":"AD59*AD62","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AS57*AS62*AX57","v":199455911806.76926},null,null,null,null,null,null,null,null,{"$f":"BB57*BB62","v":0},null,null,null,null,{"$f":"BG60*BG62","v":277137553258.4021},{"$f":"BH59*BH62","v":0},{"$f":"BI58*BI62","v":0},null,{"$f":"BK57*BK62*BI58","v":0},{"$f":"BL57*BL62","v":43157083500.150711},{"$f":"BM57*BM62","v":0},{"$f":"AX57*BO35*BN62","v":4794044140.9348497},{"$f":"AX57*BO33*BO62","v":40405628718.942169}]
[]
[null,"Allocation Calculations"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total DGS (dry basis)",null,null,"DGS allocated to Corn",null,"DGS allocated to Sorghum",null,"Drying emissions Allocated to Corn",null,"Drying Emissions Allocated to Sorghum",null,null,null,null,null,"Allocated Ethanol Gallons",null,null,null,null,null,null,null,"Corn/Sorghum Fiber Natural Gas and Electricity Emissions",null,"Corn/Sorghum Fiber Transportation Emissions",null,null,null,null,null,null,null,null,null,"Allocated Biogas Usage and Transportation Emissions",null,null,null,"Allocated Biomass Emissions",null,null,null,"Allocated Biomass Transportation Emissions"]
[null,null,"Corn Feedstock Usage",null,"Corn Farming, Fertilizers, and N2O in soil Emissions",null,"Corn Transportation Emissions",null,"Sorghum Feedstock Usage",null,"Sorghum Farming, Fertilizers, and N2O in soil Emissions",null,"Sorghum Transportation Emissions",null,"DGS totals ","dry tons","dry lbs","Corn","lbs","Sorghum","lbs","Drying emissions",null,null,null,"Allocated Co-Product Credit Emissions",null,null,null,"Total Ethanol Gallons Allocated (gals) ",null,"Corn","Gallons","MJ","Sorghum","Gallons","MJ",null,"gCO2e",null,"gCO2e","Allocated Natural Gas Emissions ",null,null,null,"Allocated Electricity Emissions ",null,null,null,"Corn",null,"Sorghum",null,"Corn",null,"Sorghum",null,"Corn",null,"Sorghum",null,"Allocated Truck Transportation Emissions",null,null,null,"Allocated Rail Transportation Emissions"]
[null,null,"Percent Corn Use",{"$f":"IFERROR(D57/(D57+L57),0)","v":1},"Corn","gCO2e","Corn","gCO2e","Percent Sorghum Used",{"$f":"IFERROR(L57/(L57+D57),0)","v":0},"Sorghum","gCO2e","Sorghum","gCO2e","DDGS",{"$f":"T57*(1-W57)","v":58235.555999999997},{"$f":"P69*2000","v":116471112},"DDGS",{"$f":"IFERROR(P69*$D$69*2000,0)","v":116471112},"DDGS",{"$f":"IFERROR(P69*$J$69*2000,0)","v":0},"Corn","gCO2e","Sorghum","gCO2e","Corn","gCO2e","Sorghum","gCO2e","corn",{"$f":"IFERROR((AX57*D69)-(AE72*D69),0)","v":215514643.64112416},"DDGS",{"$f":"IFERROR(AE69*S69/S72,0)","v":23335855.202530887},{"$f":"IFERROR(AG69*Fuel_Specs!B8/1000000*Fuel_Specs!H40,0)","v":1879292729.5901594},"DDGS",{"$f":"IFERROR(AE70*U69/U72,0)","v":0},{"$f":"IFERROR(AJ69*Fuel_Specs!B8/1000000*Fuel_Specs!H40,0)","v":0},"NG emissions ",{"$f":"IFERROR(BG63*AE72/AX57,0)","v":4029225229.8163242},"Truck ",{"$f":"IFERROR(AE72*BN62*BO35,0)","v":69699264.420861021},"Corn","gCO2e","Sorghum","gCO2e","Corn"," gCO2e","Sorghum","gCO2e","DGS",{"$f":"IFERROR(BH63*AG69/AX57,0)","v":0},"DGS",{"$f":"IFERROR(BH63*AJ69/AX57,0)","v":0},"DGS",{"$f":"IFERROR($BI$63*AG69/$AX$57,0)","v":0},"DGS",{"$f":"IFERROR($BI$63*AJ69/$AX$57,0)","v":0},"DGS",{"$f":"IFERROR($BK$63*AG69/$AX$57,0)","v":0},"DGS",{"$f":"IFERROR($BK$63*AJ69/$AX$57,0)","v":0},"Corn","gCO2e","Sorghum","gCO2e","Corn","gCO2e","Sorghum","gCO2e"]
[null,null,null,null,"DDGS",{"$f":"IFERROR(D63*AG69/AE69,0)","v":55646446564.422264},"DDGS",{"$f":"IFERROR((H63+J63+'EF Tables'!C29)*AG69/AE69,0)","v":2678594497.664145},null,null,"DDGS",{"$f":"IFERROR(L63*AJ69/AE70,0)","v":0},"DDGS",{"$f":"IFERROR((P63+R63+'EF Tables'!C34)*AJ69/AE70,0)","v":0},"MDGS",{"$f":"Z57*(1-AC57)","v":0},{"$f":"P70*2000","v":0},"MDGS",{"$f":"IFERROR(P70*$D$69*2000,0)","v":0},"MDGS",{"$f":"IFERROR(P70*$J$69*2000,0)","v":0},"DDGS",{"$f":"IFERROR(X$63*S69/Q69,0)","v":19077047541.293495},"DDGS",{"$f":"IFERROR(X63*U69/Q69,0)","v":0},"DDGS",{"$f":"IFERROR(AS63*S69/Q72,0)","v":21597020966.065708},"DDGS",{"$f":"IFERROR(AS63*U69/Q72,0)","v":0},"sorghum",{"$f":"IFERROR((AX57*J69)-(AE72*J69),0)","v":0},"MDGS",{"$f":"IFERROR(AE69*S70/S72,0)","v":0},{"$f":"IFERROR(AG70*Fuel_Specs!B8/1000000*Fuel_Specs!H40,0)","v":0},"MDGS",{"$f":"IFERROR(AE70*U70/U72,0)","v":0},{"$f":"IFERROR(AJ70*Fuel_Specs!B8/1000000*Fuel_Specs!H40,0)","v":0},"Electricity emissions ",{"$f":"IFERROR(BL63*AE72/AX57,0)","v":627448743.91657412},"Rail ",{"$f":"IFERROR(AE72*BO33*BO62,0)","v":587446113.84064412},"DDGS",{"$f":"IFERROR($BG$63*AG69/$AX$57,0)","v":29572080531.534969},"DDGS",{"$f":"IFERROR($BG$63*AJ69/$AX$57,0)","v":0},"DDGS",{"$f":"IFERROR($BL$63*AG69/$AX$57,0)","v":4605094956.5202732},"DDGS",{"$f":"IFERROR($BL$63*AJ69/$AX$57,0)","v":0},"MDGS",{"$f":"IFERROR(BH63*AG70/AX57,0)","v":0},"MDGS",{"$f":"IFERROR(BH63*AJ70/AX57,0)","v":0},"MDGS",{"$f":"IFERROR($BI$63*AG70/$AX$57,0)","v":0},"MDGS",{"$f":"IFERROR($BI$63*AJ70/$AX$57,0)","v":0},"MDGS",{"$f":"IFERROR($BK$63*AG70/$AX$57,0)","v":0},"MDGS",{"$f":"IFERROR($BK$63*AJ70/$AX$57,0)","v":0},"DDGS",{"$f":"IFERROR($BO$35*$BN$62*AG69,0)","v":511550519.73513329},"DDGS",{"$f":"IFERROR($BN$62*$BO$35*AJ69,0)","v":0},"DDGS",{"$f":"IFERROR($BO$33*$BO$62*AG69,0)","v":4311499803.4559374},"DDGS",{"$f":"IFERROR($BO$62*$BO$33*AJ69,0)","v":0}]
[null,null,null,null,"MDGS",{"$f":"IFERROR(D63*AG70/AE69,0)","v":0},"MDGS",{"$f":"IFERROR((H63+J63+'EF Tables'!C29)*AG70/AE69,0)","v":0},null,null,"MDGS",{"$f":"IFERROR(L63*AJ70/AE70,0)","v":0},"MDGS",{"$f":"IFERROR((P63+R63+'EF Tables'!C34)*AJ70/AE70,0)","v":0},"WDGS",{"$f":"AF57*(1-AI57)","v":479589.82},959179640,"WDGS",{"$f":"IFERROR(P71*$D$69*2000,0)","v":959179640},"WDGS",{"$f":"IFERROR(P71*$J$69*2000,0)","v":0},"MDGS",{"$f":"IFERROR(AD63*S70/Q70,0)","v":0},"MDGS",{"$f":"IFERROR(AD63*U70/Q70,0)","v":0},"MDGS",{"$f":"IFERROR(AS63*S70/Q72,0)","v":0},"MDGS",{"$f":"IFERROR(AS63*U70/Q72,0)","v":0},null,null,"WDGS",{"$f":"IFERROR(AE69*S71/S72,0)","v":192178788.43859327},{"$f":"IFERROR(AG71*Fuel_Specs!B8/1000000*Fuel_Specs!H40,0)","v":15476621566.237871},"WDGS",{"$f":"IFERROR(AE70*U71/U72,0)","v":0},{"$f":"IFERROR(AJ71*Fuel_Specs!B8/1000000*Fuel_Specs!H40,0)","v":0},null,null,null,null,"MDGS",{"$f":"IFERROR($BG$63*AG70/$AX$57,0)","v":0},"MDGS",{"$f":"IFERROR($BG$63*AJ70/$AX$57,0)","v":0},"MDGS",{"$f":"IFERROR($BL$63*AG70/$AX$57,0)","v":0},"MDGS",{"$f":"IFERROR($BL$63*AJ70/$AX$57,0)","v":0},"WDGS",{"$f":"IFERROR(BH63*AG71/AX57,0)","v":0},"WDGS",{"$f":"IFERROR(BH63*AJ71/AX57,0)","v":0},"WDGS",{"$f":"IFERROR($BI$63*AG71/$AX$57,0)","v":0},"WDGS",{"$f":"IFERROR($BI$63*AJ71/$AX$57,0)","v":0},"WDGS",{"$f":"IFERROR($BK$63*AG71/$AX$57,0)","v":0},"WDGS",{"$f":"IFERROR($BK$63*AJ71/$AX$57,0)","v":0},"MDGS",{"$f":"IFERROR($BO$35*$BN$62*AG70,0)","v":0},"MDGS",{"$f":"IFERROR($BN$62*$BO$35*AJ70,0)","v":0},"MDGS",{"$f":"IFERROR($BO$33*$BO$62*AG70,0)","v":0},"MDGS",{"$f":"IFERROR($BO$62*$BO$33*AJ70,0)","v":0}]
[null,null,null,null,"WDGS",{"$f":"IFERROR(D63*AG71/AE69,0)","v":458267613886.45264},"WDGS",{"$f":"IFERROR((H63+J63+'EF Tables'!C29)*AG71/AE69,0)","v":22059146357.042381},null,null,"WDGS",{"$f":"IFERROR(L63*AJ71/AE70,0)","v":0},"WDGS",{"$f":"IFERROR((P63+R63+'EF Tables'!C34)*AJ71/AE70,0)","v":0},"Total DGS",{"$f":"SUM(P69:P71)","v":537825.37600000005},{"$f":"SUM(Q69:Q71)","v":1075650752},"Total DGS from Corn",{"$f":"SUM(S69:S71)","v":1075650752},"Total DGS Sorghum",{"$f":"SUM(U69:U71)","v":0},"WDGS",0,"WDGS",0,"WDGS",{"$f":"IFERROR(AS63*S71/Q72,0)","v":177858890840.70352},"WDGS",{"$f":"IFERROR(AS63*U71/Q72,0)","v":0},"Corn/Sorghum Fiber",{"$f":"IFERROR(BE57,0)","v":3179533.3588758316},"Corn/Sorghum Fiber ",{"$f":"AE72","v":3179533.3588758316},{"$f":"IFERROR(AE72*Fuel_Specs!B8/1000000*Fuel_Specs!H40,0)","v":256055493.70124143},null,null,null,null,null,null,null,"WDGS",{"$f":"IFERROR($BG$63*AG71/$AX$57,0)","v":243536247497.05078},"WDGS",{"$f":"IFERROR($BG$63*AJ71/$AX$57,0)","v":0},"WDGS",{"$f":"IFERROR($BL$63*AG71/$AX$57,0)","v":37924539799.71386},"WDGS",{"$f":"IFERROR($BL$63*AJ71/$AX$57,0)","v":0},"Corn/Sorghum Fiber",{"$f":"IFERROR(BH63*AE72/AX57,0)","v":0},null,null,"Corn/Sorghum Fiber",{"$f":"IFERROR(BI63*AE72/AX57,0)","v":0},null,null,"Corn/Sorghum Fiber",{"$f":"IFERROR(BK63*AE72/AX57,0)","v":0},null,null,"WDGS",{"$f":"IFERROR($BO$35*$BN$62*AG71,0)","v":4212794356.7788553},"WDGS",{"$f":"IFERROR($BN$62*$BO$35*AJ71,0)","v":0},"WDGS",{"$f":"IFERROR($BO$33*$BO$62*AG71,0)","v":35506682801.645584},"WDGS",{"$f":"IFERROR($BO$62*$BO$33*AJ71,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,null,"Allocated Denatured Ethanol Gallons"]
[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,"Total Denatured Ethanol Gallons Allocated (gals) ",null,"Corn",null,null,"Sorghum"]
[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,"corn",{"$f":"IFERROR(AE69+(AE69*$AY$57/$AX$57),0)","v":219428694.81202132},"DDGS",{"$f":"IFERROR(AG69+(AG69*$AY$57/$AX$57),0)","v":23759667.384553418},null,"DDGS",{"$f":"IFERROR(AJ69+(AJ69*$AY$57/$AX$57),0)","v":0}]
[null,"Section 4. CI Calculation Details",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,"sorghum",{"$f":"IFERROR(AE70+(AE70*$AY$57/$AX$57),0)","v":0},"MDGS",{"$f":"IFERROR(AG70+(AG70*$AY$57/$AX$57),0)","v":0},null,"MDGS",{"$f":"IFERROR(AJ70+(AJ70*$AY$57/$AX$57),0)","v":0}]
[null,"Category","Parameters",null,"Corn Ethanol ",null,null,null,"Sorghum Ethanol ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WDGS",{"$f":"IFERROR(AG71+(AG71*$AY$57/$AX$57),0)","v":195669027.42746791},null,"WDGS",{"$f":"IFERROR(AJ71+(AJ71*$AY$57/$AX$57),0)","v":0}]
[null,null,null,null,"DDGS","MDGS","WDGS","Corn Fiber","DDGS","MDGS","WDGS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Corn/Sorghum Fiber",3237278.1879786639,"Corn/Sorghum Fiber ",{"$f":"IFERROR(AG72+(AG72*$AY$57/$AX$57),0)","v":3237278.1879786639}]
[null,"Feedstock Production","Electricity Mix",null,{"$f":"D25","v":"1-U.S Ave Mix"},null,null,null,{"$f":"D25","v":"1-U.S Ave Mix"}]
[null,null,"Ethanol Yield, gal/bu",null,{"$f":"IF(D57=0,0,IFERROR(AX57/(D57+L57),0))","v":2.7413772614864946},null,null,null,{"$f":"IF(L57=0,0,IFERROR(AX57/(D57+L57),0))","v":0}]
[null,null,"DGS Yield. Lbs DGS/gal ETOH",null,{"$f":"IF(D57=0,0,AS57)","v":5.0934875855428006},null,null,null,{"$f":"IF(L57=0,0,AS57)","v":0}]
[null,null,"Corn /Sorghum Farming, Fertilizers and Ag Chemicals, N2O in Soil, gCO2e/MJ",null,{"$f":"IFERROR((E83)/AH69,0)","v":29.610313331312557},{"$f":"IFERROR((F83)/AH70,0)","v":0},{"$f":"IFERROR((G83)/AH71,0)","v":29.610313331312554},null,{"$f":"IFERROR((I83)/AK69,0)","v":0},{"$f":"IFERROR((J83)/AK70,0)","v":0},{"$f":"IFERROR((K83)/AK71,0)","v":0}]
[null,null,null,"gCO2e",{"$f":"F70","v":55646446564.422264},{"$f":"F71","v":0},{"$f":"F72","v":458267613886.45264},null,{"$f":"L70","v":0},{"$f":"L71","v":0},{"$f":"L72","v":0}]
[null,null,"Corn/Sorghum Transport, gCO2e/MJ",null,{"$f":"IFERROR((E85)/AH69,0)","v":1.4253205237740154},{"$f":"IFERROR((F85)/AH70,0)","v":0},{"$f":"IFERROR((G85)/AH71,0)","v":1.4253205237740152},null,{"$f":"IFERROR((I85)/AK69,0)","v":0},{"$f":"IFERROR((J85)/AK70,0)","v":0},{"$f":"IFERROR((K85)/AK71,0)","v":0}]
[null,null,null,"gCO2e",{"$f":"H70","v":2678594497.664145},{"$f":"H71","v":0},{"$f":"H72","v":22059146357.042381},null,{"$f":"N70","v":0},{"$f":"N71","v":0},{"$f":"N72","v":0}]
[null,null,"Co-product Credit, gCO2e/MJ",null,{"$f":"IFERROR((E87)/AH69,0)","v":-11.49210052591202},{"$f":"IFERROR((F87)/AH70,0)","v":0},{"$f":"IFERROR((G87)/AH71,0)","v":-11.492100525912019},null,{"$f":"IFERROR((I87)/AK69,0)","v":0},{"$f":"IFERROR((J87)/AK70,0)","v":0},{"$f":"IFERROR((K87)/AK71,0)","v":0}]
[null,null,null,"gCO2e",{"$f":"IFERROR(-AA70,0)","v":-21597020966.065708},{"$f":"IFERROR(-AA71,0)","v":0},{"$f":"IFERROR(-AA72,0)","v":-177858890840.70352},null,{"$f":"IFERROR(-AC70,0)","v":0},{"$f":"IFERROR(-AC71,0)","v":0},{"$f":"IFERROR(-AC72,0)","v":0}]
[null,"Ethanol Production","Electricity Mix",null,{"$f":"BM29","v":"3-CAMX Mix"},null,null,null,{"$f":"BM29","v":"3-CAMX Mix"}]
[null,null,"Ethanol Production"]
[null,null,"Total feedstock used, bushels",null,{"$f":"(D57+L57)","v":79775294},null,null,null,{"$f":"IF(L57=0,0,D57+L57)","v":0}]
[null,null,"Total undenatured ethanol, gallons",null,{"$f":"AX57","v":218694177},null,null,null,{"$f":"IF(L57=0,0,AX57)","v":0}]
[null,null,"Ethanol Yield, gal ethanol /bushel",null,{"$f":"IFERROR(E91/(D57+L57),0)","v":2.7413772614864946},null,null,null,{"$f":"IF(L57=0,0,IFERROR(I91/(D57+L57),0))","v":0}]
[null,null,"Natural Gas Usage, gCO2e/MJ",null,{"$f":"IFERROR((E94)/AH69,0)","v":15.735749979719294},{"$f":"IFERROR((F94)/AH70,0)","v":0},{"$f":"IFERROR((G94)/AH71,0)","v":15.735749979719294},{"$f":"IFERROR((H94)/AH72,0)","v":15.735749979719296},{"$f":"IFERROR((I94)/AK69,0)","v":0},{"$f":"IFERROR((J94)/AK70,0)","v":0},{"$f":"IFERROR((K94)/AK71,0)","v":0}]
[null,null,"gCO2e",null,{"$f":"AQ70","v":29572080531.534969},{"$f":"AQ71","v":0},{"$f":"AQ72","v":243536247497.05078},{"$f":"AM69","v":4029225229.8163242},{"$f":"AS70","v":0},{"$f":"AS71","v":0},{"$f":"AS72","v":0}]
[null,null,"Natural Gas Usage for Drying, gCO2e/MJ",null,{"$f":"IFERROR((E96)/AH69,0)","v":10.151184666932577},{"$f":"IFERROR((F96)/AH70,0)","v":0},{"$f":"IFERROR((G96)/AH71,0)","v":0},null,{"$f":"IFERROR((I96)/AK69,0)","v":0},{"$f":"IFERROR((J96)/AK70,0)","v":0},{"$f":"IFERROR((K96)/AK71,0)","v":0}]
[null,null,"gCO2e",null,{"$f":"IFERROR(W70,0)","v":19077047541.293495},{"$f":"IFERROR(W71,0)","v":0},0,null,{"$f":"IFERROR(Y70,0)","v":0},{"$f":"IFERROR(Y71,0)","v":0},0]
[null,null,"Electricity Usage, gCO2e/MJ",null,{"$f":"IFERROR((E98)/AH69,0)","v":2.4504404683801249},{"$f":"IFERROR((F98)/AH70,0)","v":0},{"$f":"IFERROR((G98)/AH71,0)","v":2.450440468380124},{"$f":"IFERROR((H98)/AH72,0)","v":2.4504404683801249},{"$f":"IFERROR((I98)/AK69,0)","v":0},{"$f":"IFERROR((J98)/AK70,0)","v":0},{"$f":"IFERROR((K98)/AK71,0)","v":0}]
[null,null,"gCO2e",null,{"$f":"AU70","v":4605094956.5202732},{"$f":"AU71","v":0},{"$f":"AU72","v":37924539799.71386},{"$f":"AM70","v":627448743.91657412},{"$f":"AW70","v":0},{"$f":"AW71","v":0},{"$f":"AW72","v":0}]
[null,null,"Biogas Usage and Transportation, gCO2e/MJ",null,{"$f":"IFERROR(E100/AH69,0)","v":0},{"$f":"IFERROR(F100/AH70,0)","v":0},{"$f":"IFERROR(G100/AH71,0)","v":0},{"$f":"IFERROR(H100/AH72,0)","v":0},{"$f":"IFERROR(I100/AK69,0)","v":0},{"$f":"IFERROR(J100/AK70,0)","v":0},{"$f":"IFERROR(K100/AK71,0)","v":0}]
[null,null,null,"gCO2e",{"$f":"AY69","v":0},{"$f":"AY70","v":0},{"$f":"AY71","v":0},{"$f":"AY72","v":0},{"$f":"BA69","v":0},{"$f":"BA70","v":0},{"$f":"BA71","v":0}]
[null,null,"Biomass Usage and Transportation, gCO2e/MJ",null,{"$f":"IFERROR(E102/AH69,0)","v":0},{"$f":"IFERROR(F102/AH70,0)","v":0},{"$f":"IFERROR(G102/AH71,0)","v":0},{"$f":"IFERROR(H102/AH72,0)","v":0},{"$f":"IFERROR(I102/AK69,0)","v":0},{"$f":"IFERROR(J102/AK70,0)","v":0},{"$f":"IFERROR(K102/AK71,0)","v":0}]
[null,null,null,"gCO2e",{"$f":"BC69+BG69","v":0},{"$f":"BC70+BG70","v":0},{"$f":"BC71+BG71","v":0},{"$f":"BC72+BG72","v":0},{"$f":"BE69+BI69","v":0},{"$f":"BE70+BI70","v":0},{"$f":"BE71+BI71","v":0}]
[null,null,"Chemicals Usage (Standard)",null,{"$f":"IFERROR((E104)/AH69,0)","v":2.0200000000000005},{"$f":"IFERROR((F104)/AH70,0)","v":0},{"$f":"IFERROR((G104)/AH71,0)","v":2.02},{"$f":"IFERROR((H104)/AH72,0)","v":0},{"$f":"IFERROR((I104)/AK69,0)","v":0},{"$f":"IFERROR((J104)/AK70,0)","v":0},{"$f":"IFERROR((K104)/AK71,0)","v":0}]
[null,null,"gCO2e",null,{"$f":"'EF Tables'!C39*EtOH!AG69","v":3796171313.7721229},{"$f":"'EF Tables'!C39*AG70","v":0},{"$f":"'EF Tables'!C39*AG71","v":31262775563.800503},{"$f":"BB63","v":0},{"$f":"'EF Tables'!C39*AJ69","v":0},{"$f":"'EF Tables'!C39*AJ70","v":0},{"$f":"'EF Tables'!C39*AJ71","v":0}]
[null,null,"Ethanol Transport HDD Truck, gCO2e/MJ",null,{"$f":"IFERROR((E106)/AH69,0)","v":0.27220374542006204},{"$f":"IFERROR((F106)/AH70,0)","v":0},{"$f":"IFERROR((G106)/AH71,0)","v":0.27220374542006204},{"$f":"IFERROR((H106)/AH72,0)","v":0.27220374542006204},{"$f":"IFERROR((I106)/AK69,0)","v":0},{"$f":"IFERROR((J106)/AK70,0)","v":0},{"$f":"IFERROR((K106)/AK71,0)","v":0}]
[null,null,"From EtOH Plant to railyard, gCO2e",null,{"$f":"BK70","v":511550519.73513329},{"$f":"BK71","v":0},{"$f":"BK72","v":4212794356.7788553},{"$f":"AO69","v":69699264.420861021},{"$f":"BM70","v":0},{"$f":"BM71","v":0},{"$f":"BM72","v":0}]
[null,null,"Ethanol Transport Rail, gCO2e/MJ",null,{"$f":"IFERROR((E108)/AH69,0)","v":2.294214060199232},{"$f":"IFERROR((F108)/AH70,0)","v":0},{"$f":"IFERROR((G108)/AH71,0)","v":2.294214060199232},{"$f":"IFERROR((H108)/AH72,0)","v":2.2942140601992325},{"$f":"IFERROR((I108)/AK69,0)","v":0},{"$f":"IFERROR((J108)/AK70,0)","v":0},{"$f":"IFERROR((K108)/AK71,0)","v":0}]
[null,null,"From railyard to CA railyard, gCO2e",null,{"$f":"BO70","v":4311499803.4559374},{"$f":"BO71","v":0},{"$f":"BO72","v":35506682801.645584},{"$f":"AO70","v":587446113.84064412},{"$f":"BQ70","v":0},{"$f":"BQ71","v":0},{"$f":"BQ72","v":0}]
[null,null,"Ethanol Distribution, gCO2e/MJ",null,{"$f":"IFERROR((E110)/AH69,0)","v":0.46211275026445486},{"$f":"IFERROR((F110)/AH70,0)","v":0},{"$f":"IFERROR((G110)/AH71,0)","v":0.46211275026445481},{"$f":"IFERROR((H110)/AH72,0)","v":0.46211275026445486},{"$f":"IFERROR((I110)/AK69,0)","v":0},{"$f":"IFERROR((J110)/AK70,0)","v":0},{"$f":"IFERROR((K110)/AK71,0)","v":0}]
[null,null,"From terminal to fuel stations, gCO2e",null,{"$f":"'EF Tables'!D44","v":868445131.82290304},{"$f":"'EF Tables'!D45","v":0},{"$f":"'EF Tables'!D46","v":7151944156.7763567},{"$f":"'EF Tables'!D47","v":118326508.41460347},{"$f":"'EF Tables'!D49","v":0},{"$f":"'EF Tables'!D50","v":0},{"$f":"'EF Tables'!D51","v":0}]
[null,null,"Denaturant CI, gCO2e/MJ",null,{"$f":"IF(E93=0,0,'EF Tables'!D73)","v":1.0171571058401412},{"$f":"IF(F93=0,0,'EF Tables'!E73)","v":0},{"$f":"IF(G93=0,0,'EF Tables'!F73)","v":1.3859120200620794},{"$f":"IF(BE57=0,0,'EF Tables'!G73)","v":2.8884958745753977},{"$f":"IF(I93=0,0,'EF Tables'!I73)","v":0},{"$f":"IF(J93=0,0,'EF Tables'!J73)","v":0},{"$f":"IF(K93=0,0,'EF Tables'!K73)","v":0}]
[null,null,"Non-Combustion CI, gCO2e/MJ",null,{"$f":"'EF Tables'!C5","v":8.6694746909554699E-2},{"$f":"'EF Tables'!C5","v":8.6694746909554699E-2},{"$f":"'EF Tables'!C5","v":8.6694746909554699E-2},{"$f":"'EF Tables'!C5","v":8.6694746909554699E-2},{"$f":"'EF Tables'!C5","v":8.6694746909554699E-2},{"$f":"'EF Tables'!C5","v":8.6694746909554699E-2},{"$f":"'EF Tables'!C5","v":8.6694746909554699E-2}]
[null,null,"Indirect Land Use, gCO2e/MJ",null,{"$f":"'EF Tables'!D59","v":19.8},{"$f":"'EF Tables'!D59","v":19.8},{"$f":"'EF Tables'!D59","v":19.8},0,{"$f":"'EF Tables'!D60","v":19.399999999999999},{"$f":"'EF Tables'!D60","v":19.399999999999999},{"$f":"'EF Tables'!D60","v":19.399999999999999}]

{"sheet":"EF Tables","index":2,"n_rows":77,"n_cols":32,"rows_kept":77,"cut":false,"hidden":false,"merged":[[0,1,0,12],[42,6,42,8],[43,7,43,8]]}
[null,"Greenhouse Gases Emissions Factors Used in CA-GREET 3.0 for Carbon Intensity Calculations\n(see \"CA-GREET 3.0 for EF Table\")"]
[null,"GHG Emission Factors ","1-U.S Ave Mix","2-User Defined Mix","3-CAMX Mix","4-NWPP Mix","5-AZNM Mix","6-RMPA Mix","7-MROW Mix","8-SPNO Mix","9-SPSO Mix","10-ERCT Mix","11-MROE Mix","12-SRMW Mix","13-SRMV Mix","14-RFCM Mix","15-RFCW Mix","16-SRTV Mix","17-SRSO Mix","18-NEWE Mix","19-NYUP Mix","20-RFCE Mix","21-NYLI Mix","22-NYCW Mix","23-SRVC Mix","24-FRCC Mix","25-AKMS Mix","26-AKGD Mix","27-HIOA Mix","28-HIMS Mix","29-Brazilian Mix","30-Canadian Mix"]
[null,"Emissions from Electricity use (gCO2e/kWh) ",610.34189145985738,{"$f":"EtOH!BO29","v":0},370.21536152172285,476.66755891530761,460.82859297371101,851.03020657968534,684.35343913567101,792.60226004051526,795.05469323281625,638.59301682740761,892.00690603787143,924.3059717481699,614.24740326892186,785.91730144285464,738.42690476572875,682.14171976483931,628.53837254067525,356.89849018378067,231.08115430320504,462.51078261890473,627.05639089482747,356.83383543633607,493.61813345282064,601.65033646121844,161.95715526219328,747.57263119603965,1127.5361384383039,680.49572467317205,193.69249304296969,176.23247881407806]
[]
[null,"Non-combustion (gCO2e/MJ)",{"$f":"2.239/Fuel_Specs!$I$8*Fuel_Specs!$B$17*$D$77","v":8.6694746909554699E-2}]
[null,"Enzymes and Yeast (gCO2e/MJ)",2.02]
[]
[null,null,"Corn Farming, Fertilizers, N2O in soil"]
[null,null,null,"Farming","Fertilizers","N2O in soil","Total, gCO2e/bushel"]
[null,null,"VOC",0.75552649818355566,2.6284700113524333]
[null,null,"CO",7.4196917563006224,3.2528955301537494]
[null,null,"CH4",1.9010343935645428,5.9374487004087344]
[null,null,"N2O",1.8306015221492937E-2,0.77611204615524221,10.699418616296118]
[null,null,"CO2",615.26542084621849,2178.3114373452768]
[null,null,"Total, gCO2e/bushel",682.26071309105282,2571.332802454428,3188.4267476562432,{"$f":"SUM(D15:F15)","v":6442.0202632017244}]
[]
[null,null,"Sorghum Farming, Fertilizers, N2O in soil"]
[null,null,null,"Farming","Fertilizers","N2O is soil","Total, gCO2e/bushel"]
[null,null,"VOC",0.90587331877000532,2.8372222102601059]
[null,null,"CO",7.4240523696606688,3.6697143214335224]
[null,null,"CH4",2.1671043726982244,7.0329103313063337]
[null,null,"N2O",2.1981083149362379E-2,0.85546857419421163,11.606876093294462]
[null,null,"CO2",956.06916591625941,2332.2614999825964]
[null,null,"Total, gCO2e/bushel",1031.2868111985249,2777.6232631974553,3458.8490758017497,{"$f":"SUM(D24:F24)","v":7267.7591501977295}]
[]
[]
[null,null,"MDT Truck - Corn to Stack"]
[null,null,17.256321876909219,"gCO2e/bushel-mile"]
[null,null,{"$f":"(EtOH!E57)*10*C28","v":13528021749.103973},"gCO2e"]
[]
[]
[null,null,"MDT Truck - Sorghum to Stack"]
[null,null,17.256321876909219,"gCO2e/bushel-mile"]
[null,null,{"$f":"(EtOH!M57)*10*C33","v":0},"gCO2e"]
[]
[null,null,"Chemical usage"]
[null,null,{"$f":"C6*Fuel_Specs!H40","v":2131.2128170000001},"gCO2e/mmBTU"]
[null,null,{"$f":"C37/1000000","v":2.1312128170000002E-3},"gCO2e/BTU"]
[null,null,{"$f":"C38*Fuel_Specs!B8","v":162.67547432161001},"gCO2e/Gal"]
[]
[]
[null,null,"Finished Fuel Distribution"]
[null,null,"Corn",null,null,null,"HDT Truck Emission Factor - California Distribution"]
[null,null,"DDGS",{"$f":"90*G44*EtOH!AG69","v":868445131.82290304},"gCO2e",null,0.41350060967730418,"gCO2e/gal-mile"]
[null,null,"MDGS",{"$f":"90*G44*EtOH!AG70","v":0},"gCO2e"]
[null,null,"WDGS",{"$f":"90*G44*EtOH!AG71","v":7151944156.7763567},"gCO2e"]
[null,null,"Corn Fiber",{"$f":"90*G44*EtOH!AE72","v":118326508.41460347},"gCO2e"]
[null,null,"Sorghum"]
[null,null,"DDGS",{"$f":"90*G44*EtOH!AJ69","v":0},"gCO2e"]
[null,null,"MDGS",{"$f":"90*G44*EtOH!AJ70","v":0},"gCO2e"]
[null,null,"WDGS",{"$f":"90*G44*EtOH!AJ71","v":0},"gCO2e"]
[]
[]
[null,null,"Co-product Credit - Corn Ethanol"]
[null,null,"Corn","SBM","Urea","Total, gCO2e/bone-dry lb"]
[null,null,{"$f":"89.8572161376031+(EtOH!D69*(0.240701671413685*10+0.0601039241861255*EtOH!H57+0.0106557883668039*EtOH!J57))+(EtOH!J69*(0.240701671413685*10+0.0601039241861255*EtOH!P57+0.0106557883668039*EtOH!R57))","v":94.266506537969903},71.62932520698584,13.162461944643365,{"$f":"SUM(C56:E56)","v":179.05829368959908}]
[]
[null,null,"Indirect Land Use (ILUC)","gCO2e/MJ"]
[null,null,"Corn",19.8]
[null,null,"Sorghum",19.399999999999999]
[]
[null,null,"Denatured Ethanol  (D-EtOH) Calculator"]
[null,null,"Volume % Ethanol in D-EtOH",0.97499999999999998,null,"v/v EtOH/D-EtOH"]
[null,null,"Volume % of Denaturant (CARBOB and \"Other\") in D-EtOH",{"$f":"IFERROR(EtOH!AY57/EtOH!AU57,0)","v":2.4174734901773957E-2},null,"v/v CARBOB/D-EtOH"]
[null,null,"Energy % Denaturant in D-EtOH",{"$f":"IFERROR(D64*Fuel_Specs!$I$6/81.51,0)","v":3.6326293562873993E-2},null,"MJ/MJ CARBOB/D-EtOH"]
[null,null,"CARBOB CI *",100.81670870463032]
[null,null,"2010 Average Ethanol CI",77.8095,null,"g CO2e/MJ"]
[null,null,"2010 Denaturant CI (CARBOB CI without tailpipe N2O & CH4) ",99.768254930461183,null,"g CO2e/MJ"]
[null,null,"Net Denaturant Contribution to CI",{"$f":"((1-D65)*D67+D65*D68)-D67","v":0.79768017787914403},null,"g CO2e/MJ"]
[null,null,"2010  D-EtOH  CI ",{"$f":"(1-D65)*D67+D65*D68","v":78.607180177879144},null,"g CO2e/MJ"]
[null,null,null,"Corn - DDGS","Corn - MDGS","Corn - WDGS","Corn fiber",null,"Sorghum - DDGS","Sorghum - MDGS","Sorghum - WDGS"]
[null,null,"Enter CI of any anhydrous ethanol (including ILUC) here:",{"$f":"EtOH!E82+EtOH!E84+EtOH!E86+EtOH!E93+EtOH!E95+EtOH!E97+EtOH!E103+EtOH!E105+EtOH!E107+EtOH!E109+EtOH!E112+EtOH!E113+EtOH!E99+EtOH!E101","v":72.816133746999853},{"$f":"EtOH!F82+EtOH!F84+EtOH!F86+EtOH!F93+EtOH!F95+EtOH!F97+EtOH!F103+EtOH!F105+EtOH!F107+EtOH!F109+EtOH!F112+EtOH!F113+EtOH!F99+EtOH!F101","v":19.886694746909555},{"$f":"EtOH!G82+EtOH!G84+EtOH!G86+EtOH!G93+EtOH!G95+EtOH!G97+EtOH!G103+EtOH!G105+EtOH!G107+EtOH!G109+EtOH!G112+EtOH!G113+EtOH!G99+EtOH!G101","v":62.664949080067274},{"$f":"EtOH!H93+EtOH!H97+EtOH!H103+EtOH!H105+EtOH!H107+EtOH!H109+EtOH!H112+EtOH!H99+EtOH!H101","v":21.301415750892723},null,{"$f":"EtOH!I82+EtOH!I84+EtOH!I86+EtOH!I93+EtOH!I95+EtOH!I97+EtOH!I103+EtOH!I105+EtOH!I107+EtOH!I109+EtOH!I112+EtOH!I113+EtOH!I99+EtOH!I101","v":19.486694746909553},{"$f":"EtOH!J82+EtOH!J84+EtOH!J86+EtOH!J93+EtOH!J95+EtOH!J97+EtOH!J103+EtOH!J105+EtOH!J107+EtOH!J109+EtOH!J112+EtOH!J113+EtOH!J99+EtOH!J101","v":19.486694746909553},{"$f":"EtOH!K82+EtOH!K84+EtOH!K86+EtOH!K93+EtOH!K95+EtOH!K97+EtOH!K103+EtOH!K105+EtOH!K107+EtOH!K109+EtOH!K112+EtOH!K113+EtOH!K99+EtOH!K101","v":19.486694746909553}]
[null,null,"Denaturant, g/MJ",{"$f":"(1-$D$65)*D72+$D$65*$D$66-D72","v":1.0171571058401412},{"$f":"(1-$D$65)*E72+$D$65*$D$66-E72","v":2.9398874450756551},{"$f":"(1-$D$65)*F72+$D$65*$D$66-F72","v":1.3859120200620794},{"$f":"(1-$D$65)*G72+$D$65*$D$66-G72","v":2.8884958745753977},null,{"$f":"(1-$D$65)*I72+$D$65*$D$66-I72","v":2.9544179625008056},{"$f":"(1-$D$65)*J72+$D$65*$D$66-J72","v":2.9544179625008056},{"$f":"(1-$D$65)*K72+$D$65*$D$66-K72","v":2.9544179625008056}]
[]
[]
[null,null,"Loss Factor"]
[null,null,"For Feedstock and Fuel",1.0005044983835301]

{"sheet":"Fuel_Specs","index":3,"n_rows":48,"n_cols":9,"rows_kept":48,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
["1) Specifications of Fuels"]
[null,"Heating Value",null,"Density","C ratio","S ratio","S ratio"]
[null,"LHV","HHV",null,"(% by wt)","(ppm by wt)","Actual ratio by wt","LHV/HHV","Energy Density"]
["Liquid Fuels:","BTU/gal","BTU/gal","grams/gal",null,null,null,null,"MJ/gal"]
["Gasoline blendstock",116090,124340,2819,0.86299999999999999,null,null,null,122.48143362649999]
["CARBOB",113300,121351.72710827805,2767,0.85899999999999999,null,null,null,119.53782780499999]
["Ethanol",76330,84530,2988,0.52200000000000002,0,0,0.90299302022950434,80.532413030499995]
["Gaseous Fuels (at 60F and 1atm):","BTU/ft3","BTU/ft3","grams/ft3",null,null,null,"LHV/HHV","MJ/unit"]
["Natural gas",930,1030,20.8,0.72399999999999998,6,6.0000000000000002E-6,{"$f":"B10/C10","v":0.90291262135922334},0.98]
["Pure Methane",910,1010,19.2,null,null,null,{"$f":"B11/C11","v":0.90099009900990101}]
[]
["2) Global Warming Potentials of Greenhouse Gases: relative to CO2"]
["CO2",1]
["CH4",25]
["N2O",298]
["VOC",3.1166666666666667]
["CO",1.5714285714285714]
["NO2",0]
[]
[]
["3) Unit Conversion"]
["Mass","1 g","1 kg","1 metric ton","1 lb","1 short ton"]
["g",1,1000,1000000,453.59237000000002,907184.74]
["kg",1E-3,1,1000,0.45359237000000002,907.18474000000003]
["metric ton",9.9999999999999995E-7,1E-3,1,4.5359237000000004E-4,0.90718474000000004]
["lb",2.2046226218487759E-3,2.2046226218487757,2204.6226218487759,1,2000]
["short ton",1.102311310924388E-6,1.1023113109243879E-3,1.1023113109243878,5.0000000000000001E-4,1]
[]
["Volume","1 m3","1 ml","1 L","1 gal","1 ft3"]
["m3",1,9.9999999999999995E-7,1E-3,3.7854109999999998E-3,2.8316846999999999E-2]
["ml",1000000,1,1000.0000000000001,3785.4110000000001,28316.847000000002]
["L",1000,1E-3,1,3.7854109999999999,28.316846999999999]
["gal",264.17210707106841,2.6417210707106839E-4,0.26417210707106842,1,7.4805211375990615]
["ft3",35.314666212661322,3.5314666212661319E-5,3.5314666212661321E-2,0.13368052594273649,1]
[]
["Energy","1 J","1kJ","1 MJ","1Wh","1 kWh","1 BTU","1 mmBTU"]
["J",1,1000,1000000,3600,3600000,1055.05585,1055055850]
["kJ",1E-3,1,1000,3.6,3600,1.05505585,1055055.8500000001]
["MJ",9.9999999999999995E-7,1E-3,1,3.5999999999999999E-3,3.6,1.0550558499999999E-3,1055.05585]
["Wh",2.7777777777777778E-4,0.27777777777777779,277.77777777777777,1,1000,0.29307106944444444,293071.06944444444]
["kWh",2.7777777777777776E-7,2.7777777777777778E-4,0.27777777777777779,1E-3,1,2.9307106944444444E-4,293.07106944444445]
["BTU",9.4781712266701337E-4,0.94781712266701335,947.81712266701334,3.4121416416012482,3412.141641601248,1,1000000]
["mmBTU",9.4781712266701324E-10,9.4781712266701337E-7,9.4781712266701326E-4,3.4121416416012478E-6,3.4121416416012479E-3,9.9999999999999995E-7,1]
[]
["4) Corn Bushel Weight"]
[56,"lb/wet bushel"]
[{"$f":"A47*(1-15%)","v":47.6},"lb/dry bushel"]

{"sheet":"NG and Imported Steam","index":4,"n_rows":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"MMBTU"]
["Reporting Month","Total Natural Gas Billed","Imported Steam","Boiler Efficiency to Make Steam","Total Natural Gas Usage (Field 3.2.)"]
[null,"HHV","HHV","%","HHV"]
["2017-05-01",174216.9375,3020.85,0.8,{"$f":"B4+C4/D4","v":177993}]
["2017-06-01",177153.6875,580.25,0.8,{"$f":"B5+C5/D5","v":177879}]
["2017-07-01",198249.65,1309.0800000000002,0.8,199886]
["2017-08-01",196076.86249999999,3133.71,0.8,199994]
["2017-09-01",199529.76250000001,364.99,0.8,199986]
["2017-10-01",199015.57500000001,840.34,0.8,200066]
["2017-11-01",199207.85,1492.92,0.8,201074]
["2017-12-01",198546.1,1702.3200000000002,0.8,200674]
["2018-01-01",199724.61249999999,119.50999999999999,0.8,199874]
["2018-02-01",165760.22500000001,524.62,0.8,166416]
["2018-03-01",166453.9375,627.25,0.8,167238]
["2018-04-01",179445.83749999999,452.13,0.8,180011]
["2018-05-01",183880.38750000001,2755.69,0.8,187325]
["2018-06-01",180235.6875,681.05,0.8,181087]
["2018-07-01",183584.97500000001,268.82,0.8,183921]
["2018-08-01",134437.1875,3093.45,0.8,138304]
["2018-09-01",182239.08749999999,324.73,0.8,182645]
["2018-10-01",188661.9,800.08,0.8,189662]
["2018-11-01",188114.17499999999,1452.6599999999999,0.8,189930]
["2018-12-01",183252.42499999999,1662.06,0.8,185330]
["2019-01-01",199232.9375,79.25,0.8,199332]
["2019-02-01",181492.55,484.36,0.8,182098]
["2019-03-01",199622.26250000001,586.99,0.8,200356]
["2019-04-01",177372.16250000001,411.87,0.8,177887]