{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["EtOH Summary","EtOH","EF Tables","Fuel_Specs"],"not_rendered":{"charts":0,"images":3,"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:  November 28, 2022"]
[]
[null,null,"Applicant:",{"$f":"IF(EtOH!D21=\"\",\"\",EtOH!D21)","v":""},null,null,{"$f":"CONCATENATE(\"Location:  \",EtOH!D24)","v":"Location:  "}]
[null,null,"Application Number",{"$f":"IF(EtOH!H21=\"\",\"\",EtOH!H21)","v":""}]
[null,null,"Description:",{"$f":"IF(EtOH!G24=\"\",\"\",EtOH!G24)","v":""}]
[]
[null,null,"Feedstock Production Electricity Mix",null,"1- U.S Ave Mix",null,"Fuel Production Electricity Mix",{"$f":"EtOH!BM29","v":"2-WAMX 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":0},null,"Total Undenatured Ethanol, gallons",{"$f":"EtOH!AX57","v":0},null,null,"Dry DG",{"$f":"EtOH!D12","v":0},0,{"$f":"Table13[[#This Row],[Carbon Intensity, g/MJ]]+Table13[[#This Row],[Column3]]","v":0},{"$f":"EtOH!AG75","v":0}]
[null,null,"Sorghum Use, bushels",null,{"$f":"EtOH!L57","v":0},null,"Total Undenatured Starch Ethanol, gallons",{"$f":"EtOH!AE69+EtOH!AE70","v":0},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":0},null,"Total Undenatured Fiber Ethanol, gallons",{"$f":"EtOH!BE57","v":0},null,null,"Wet DG",{"$f":"EtOH!D16","v":0},0,{"$f":"Table13[[#This Row],[Carbon Intensity, g/MJ]]+Table13[[#This Row],[Column3]]","v":0},{"$f":"EtOH!AG77","v":0}]
[]
[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":"0"},null,"Natural, HHV in MMBtu",{"$f":"EtOH!BG57","v":0},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":0},null,"Corn/Sorghum Fiber Ethanol",null,{"$f":"EtOH!J10","v":0},0,{"$f":"Table13[[#This Row],[Carbon Intensity, g/MJ]]+Table13[[#This Row],[Column3]]","v":0},{"$f":"EtOH!AG78","v":0}]
[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":0},0,{"$f":"Table13[[#This Row],[Carbon Intensity, g/MJ]]+Table13[[#This Row],[Column3]]","v":0},{"$f":"EtOH!AE75","v":0}]
[null,null,"Co-Product Yield, bone-dry lb./gal",null,{"$f":"EtOH!AS57","v":0},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":0},null,"Cellulosic Enzyme, lbs.",{"$f":"EtOH!BB57","v":0}]
[null,null,"Moisture, %",null,{"$f":"EtOH!W57","v":0}]
[null,null,"Drying Energy, HHV in MMBtu",null,{"$f":"EtOH!X57","v":0},null,"Fuel Transport"]
[null,null,"Modified Distiller Grains, tons",null,{"$f":"EtOH!Z57","v":0},null,"By HD Truck, miles",{"$f":"EtOH!BO35","v":0}]
[null,null,"Moisture, %",null,{"$f":"EtOH!AC57","v":0},null,"By Rail, miles",{"$f":"EtOH!BO33","v":0}]
[null,null,"Drying Energy, HHV in MMBtu",null,{"$f":"EtOH!AD57","v":0}]
[null,null,"Wet Distiller Grains, tons",null,{"$f":"EtOH!AF57","v":0},null,"Denaturant Usage",{"$f":"IFERROR(EtOH!AY57/EtOH!AU57,0)","v":0}]
[null,null,"Moisture, %",null,{"$f":"EtOH!AI57","v":0},null,"Denaturant, gallons",{"$f":"EtOH!AY57","v":0}]
[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":0}]

{"sheet":"EtOH","index":1,"n_rows":113,"n_cols":71,"rows_kept":113,"cut":false,"hidden":false,"merged":[[6,68,6,70],[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,null,"Tier 1 Simplified CI Calculator for Starch and Fiber Ethanol",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"This map shows Emissions & Generation Resource Integrated Database (eGRID) "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"US Average","US Average"]
[null,"Pathway Summary and Estimated CI (g/MJ)",null,null,null,null,null,null,null,null,null,"Yellow Cells require user input",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"WAMX","Western Electricity Coordinating Council - California"]
[null,"Corn Ethanol Composite CI, g/MJ ",null,{"$f":"IFERROR((D12*D13+D14*D15+D16*D17)/AE75,0)","v":0},"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'!D79+(H111+H112+H113))","v":0},null,"Light Blue Cells show CI results ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"CAMX","Western Electricity Coordinating Council - California"]
[null,"Denatured Volume, gal",null,{"$f":"AE75","v":0},"Denatured Volume, gal ",null,{"$f":"AE76","v":0},"Denatured Ethanol Volume, gal ",null,{"$f":"AE78","v":0},null,"Green Cells show the calculation button",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"NWPP","Western Electricity Coordinating Council - Northwest"]
[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'!D79+(E111+E112+E113))","v":0},"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'!D79+(I111+I112+I113))","v":0},null,null,null,null,"Gray Cells are Calculated Values",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"AZNM","Western Electricity Coordinating Council - Southwest"]
[null,"Denatured Volume, gal",null,{"$f":"AG75","v":0},"Denatured Volume, gal",null,{"$f":"AJ75","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"RMPA","Western Electricity Coordinating Council - Rockies"]
[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'!D79+(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'!D79+(J111+J112+J113))","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"MROW","Midwest Reliability Organization West"]
[null,"Denatured Volume, gal",null,{"$f":"AG76","v":0},"Denatured Volume, gal",null,{"$f":"AJ76","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"SPNO","SERC Reliability Corporation - North"]
[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'!D79+(G111+G112+G113))","v":0},"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'!D79+(K111+K112+K113))","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"SPSO","SERC Reliability Corporation - South"]
[null,"Denatured Volume, gal",null,{"$f":"AG77","v":0},"Denatured Volume, gal",null,{"$f":"AJ77","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"ERCT","Electric Reliability Council of Texas - All"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"MROE","Midwest Reliability Organization East"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"SRMW","SERC Reliability Corporation - Midwest"]
[null,"Section 1.  Applicant Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"SRMV","SERC Reliability Corporation - Mississippi Valley"]
[null,"1.1. Company Name",null,null,null,null,"1.2. Application Number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"RFCM","Reliability First Corporation - Michigan"]
[null,"1.3. Company ID ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"RFCW","Reliability First Corporation - Midwest"]
[null,"1.4. Facility ID",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"SRTV","SERC Reliability Corporation - Tennessee Valley"]
[null,"1.5. Ethanol Production Location \n(City, State)",null,null,null,"1.6. Application Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,"SRSO","SERC Reliability Corporation - South"]
[null,"1.7. Electricity Mix Region for Feedstock",null,"1-U.S Ave Mix",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"NEWE","Northeast Power Coordinating Council - New England"]
[null,"1.8. Provisional Pathway?",null,"No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,"NYUP","Northeast Power Coordinating Council - Upstate New York"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"RFCE","Reliability First Corporation - East"]
[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,null,null,null,null,null,null,null,null,21,"NYLI","Northeast Power Coordinating Council - Long Island"]
[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,"2-WAMX Mix",{"$f":"IF(BM29=\"2-User Defined Mix\",\"3.10. Enter Electricity Generation GHG Emission Factor \n(gCO2e/kWh)\",\"\")","v":""},null,null,22,"NYCW","Northeast Power Coordinating Council - New York Westchester"]
[null,"Corn Inventory",null,null,null,null,"2.6. Corn Transport Data Category",null,"User-Defined for Corn Transport",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,null,23,"SRVC","SERC Reliability Corporation - Virginia/Carolina"]
[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","Denaturant as Standard Value","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,24,"FRCC","Florida Reliability Coordinating Council"]
[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,25,"AKMS","Alaska Systems Coordinating Council - Miscellaneous"]
[null,null,null,{"$f":"C33+E33-F33","v":0},null,null,null,null,null,null,null,{"$f":"K33+M33-N33","v":0},null,null,null,null,null,null,null,{"$f":"V33-S33+U33","v":0},null,null,null,null,null,{"$f":"AB33-Y33+AA33","v":0},null,null,null,null,null,{"$f":"AH33-AE33+AG33","v":0},null,null,null,null,{"$f":"AM33-AJ33+AL33","v":0},null,null,null,null,{"$f":"AR33-AO33+AQ33","v":0},null,null,{"$f":"IFERROR((((T33*(1-W33)+Z33*(1-AC33)+AF33*(1-AI33)+AK33*(1-AN33))*2000)+AP33*(1-0.01))/AX33,0)","v":0},null,null,null,null,{"$f":"AW33-AT33+AU33+AV33-AY33","v":0},{"$f":"AU33*0.025","v":0},null,null,{"$f":"AZ33-BC33+BA33","v":0},null,null,{"$f":"IFERROR(BD33*(AX33),0)","v":0},null,null,null,null,null,null,null,null,"3.9.a. By Rail",null,null,26,"AKGD","Alaska Systems Coordinating Council - Alaska Grid"]
[null,null,null,{"$f":"C34+E34-F34","v":0},null,null,null,null,null,null,null,{"$f":"K34+M34-N34","v":0},null,null,null,null,null,null,null,{"$f":"V34-S34+U34","v":0},null,null,null,null,null,{"$f":"AB34-Y34+AA34","v":0},null,null,null,null,null,{"$f":"AH34-AE34+AG34","v":0},null,null,null,null,{"$f":"AM34-AJ34+AL34","v":0},null,null,null,null,{"$f":"AR34-AO34+AQ34","v":0},null,null,{"$f":"IFERROR((((T34*(1-W34)+Z34*(1-AC34)+AF34*(1-AI34)+AK34*(1-AN34))*2000)+AP34*(1-0.01))/AX34,0)","v":0},null,null,null,null,{"$f":"AW34-AT34+AU34+AV34-AY34","v":0},0,null,null,{"$f":"AZ34-BC34+BA34","v":0},null,null,{"$f":"IFERROR(BD34*(AX34),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,27,"HIOA","Hawaii Island Chamber of Commerce - Oahu"]
[null,null,null,0,null,null,null,null,null,null,null,{"$f":"K35+M35-N35","v":0},null,null,null,null,null,null,null,{"$f":"V35-S35+U35","v":0},null,null,null,null,null,{"$f":"AB35-Y35+AA35","v":0},null,null,null,null,null,0,null,null,null,null,{"$f":"AM35-AJ35+AL35","v":0},null,null,null,null,0,null,null,{"$f":"IFERROR((((T35*(1-W35)+Z35*(1-AC35)+AF35*(1-AI35)+AK35*(1-AN35))*2000)+AP35*(1-0.01))/AX35,0)","v":0},null,null,null,null,{"$f":"AW35-AT35+AU35+AV35-AY35","v":0},0,null,null,0,null,null,0,null,null,null,null,null,null,null,null,"3.9.b. By HDD Truck",null,null,28,"HIMS","Hawaii Island Chamber of Commerce - Miscellaneous"]
[null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,0,null,null,null,null,0,0,null,null,{"$f":"AZ36-BC36+BA36","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,29,null,"Brazillian Mix"]
[null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,0,null,null,null,null,0,0,null,null,{"$f":"AZ37-BC37+BA37","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,30,null,"Canadian Mix"]
[null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,0,null,null,null,null,null,null,null,null,null,null,null,31,"ORGN","Western Electricity Coordinating Council - Oregon"]
[null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,0,null,null,null,null,null,null,null,null,null,null,null,32,null,"User Defined"]
[null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,0]
[null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,0,null,null,null,null,{"$f":"AW41-AT41+AU41+AV41-AY41","v":0},0,null,null,0,null,null,0,null,null,null,null,null,null,null,null,"Finished Fuel Distribution Standard Value is at 90 miles by HDDT"]
[null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,0,null,null,null,null,{"$f":"AW42-AT42+AU42+AV42-AY42","v":0},0,null,null,0,null,null,0]
[null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,0]
[null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,0]
[null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,0]
[null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,0]
[null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,0]
[null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,0]
[null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,0]
[null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,0]
[null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,0]
[null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,0]
[null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,0]
[null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,0]
[null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,0]
[null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,0,null,null,null,null,0,0,null,null,0,null,null,0]
[null,"Total or Ave.",null,{"$f":"SUM(D33:D56)","v":0},{"$f":"SUM(E33:E56)","v":0},null,{"$f":"SUM(G33:G56)","v":0},{"$f":"IFERROR((IF(MAX($H33:$H56)=0,\"0\",(SUMPRODUCT(G33:G56,H33:H56)/G57))),0)","v":"0"},{"$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":0},{"$f":"SUM(U33:U56)","v":0},null,{"$f":"IFERROR(SUMPRODUCT(T33:T56,W33:W56)/T57,0)","v":0},{"$f":"SUM(X33:X56)","v":0},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":0},{"$f":"SUM(AG33:AG56)","v":0},null,{"$f":"IFERROR(SUMPRODUCT(AF33:AF56,AI33:AI56)/AF57,0)","v":0},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":0},{"$f":"SUM(AQ33:AQ56)","v":0},null,0,{"$f":"SUM(AT33:AT56)","v":0},{"$f":"SUM(AU33:AU56)","v":0},{"$f":"SUM(AV33:AV56)","v":0},0,{"$f":"AW57-AT57+AU57+AV57-AY57","v":0},{"$f":"0.025*AU57","v":0},null,{"$f":"SUM(BA33:BA56)","v":0},{"$f":"SUM(BB33:BB56)","v":0},null,{"$f":"IFERROR(SUMPRODUCT(BD33:BD56,BE33:BE56)/BE57,0)","v":0},{"$f":"SUM(BE33:BE56)","v":0},null,{"$f":"SUM(BG33:BG56)","v":0},{"$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":0},{"$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":0},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":0},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":0},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":0},{"$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":0},"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'!G17","v":6425.2286335106528},null,null,null,4.3089549637508835,null,0.76393201937416344,null,{"$f":"'EF Tables'!G26","v":7249.0943609672258},null,null,null,4.3089549637508835,null,0.76393201937416344,null,null,null,null,null,{"$f":"'EF Tables'!$C$8","v":73352.021744961938},null,null,null,null,null,{"$f":"'EF Tables'!$C$8","v":73352.021744961938},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'EF Tables'!$F$58","v":173.97795576227313},null,null,null,null,null,null,null,null,1207.0688246826328,null,null,null,null,{"$f":"'EF Tables'!$C$7","v":73411.621744961929},null,null,null,null,{"$f":"HLOOKUP($BM$29,'EF Tables'!$C$2:$AH$5,2,FALSE)","v":228.64550547041199},0,{"$f":"'EF Tables'!$H$45","v":0.41353565695950523},{"$f":"'EF Tables'!$H$47","v":8.9848888223393514E-2}]
[null,"GHG Emissions, gCO2e",null,{"$f":"D57*D62","v":0},null,null,null,{"$f":"G57*H57*H62","v":0},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":0},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":0},null,null,null,null,null,null,null,null,{"$f":"BB57*BB62","v":0},null,null,null,null,{"$f":"BG60*BG62","v":0},{"$f":"BH59*BH62","v":0},{"$f":"BI58*BI62","v":0},null,{"$f":"BK57*BK62*BI58","v":0},{"$f":"BL57*BL62","v":0},{"$f":"BM57*BM62","v":0},{"$f":"AX57*BO35*BN62","v":0},{"$f":"AX57*BO33*BO62","v":0}]
[]
[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":0},"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":0},{"$f":"P69*2000","v":0},"DDGS",{"$f":"IFERROR(P69*$D$69*2000,0)","v":0},"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":0},"DDGS",{"$f":"IFERROR(AE69*S69/S72,0)","v":0},{"$f":"IFERROR(AG69*Fuel_Specs!B8/1000000*Fuel_Specs!H40,0)","v":0},"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":0},"Truck ",{"$f":"IFERROR(AE72*BN62*BO35,0)","v":0},"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":0},"DDGS",{"$f":"IFERROR((H63+J63+'EF Tables'!D31)*AG69/AE69,0)","v":0},null,null,"DDGS",{"$f":"IFERROR(L63*AJ69/AE70,0)","v":0},"DDGS",{"$f":"IFERROR((P63+R63+'EF Tables'!D36)*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":0},"DDGS",{"$f":"IFERROR(X63*U69/Q69,0)","v":0},"DDGS",{"$f":"IFERROR(AS63*S69/Q72,0)","v":0},"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":0},"Rail ",{"$f":"IFERROR(AE72*BO33*BO62,0)","v":0},"DDGS",{"$f":"IFERROR($BG$63*AG69/$AX$57,0)","v":0},"DDGS",{"$f":"IFERROR($BG$63*AJ69/$AX$57,0)","v":0},"DDGS",{"$f":"IFERROR($BL$63*AG69/$AX$57,0)","v":0},"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":0},"DDGS",{"$f":"IFERROR($BN$62*$BO$35*AJ69,0)","v":0},"DDGS",{"$f":"IFERROR($BO$33*$BO$62*AG69,0)","v":0},"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'!D31)*AG70/AE69,0)","v":0},null,null,"MDGS",{"$f":"IFERROR(L63*AJ70/AE70,0)","v":0},"MDGS",{"$f":"IFERROR((P63+R63+'EF Tables'!D36)*AJ70/AE70,0)","v":0},"WDGS",{"$f":"AF57*(1-AI57)","v":0},0,"WDGS",{"$f":"IFERROR(P71*$D$69*2000,0)","v":0},"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":0},{"$f":"IFERROR(AG71*Fuel_Specs!B8/1000000*Fuel_Specs!H40,0)","v":0},"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":0},"WDGS",{"$f":"IFERROR((H63+J63+'EF Tables'!D31)*AG71/AE69,0)","v":0},null,null,"WDGS",{"$f":"IFERROR(L63*AJ71/AE70,0)","v":0},"WDGS",{"$f":"IFERROR((P63+R63+'EF Tables'!D36)*AJ71/AE70,0)","v":0},"Total DGS",{"$f":"SUM(P69:P71)","v":0},{"$f":"SUM(Q69:Q71)","v":0},"Total DGS from Corn",{"$f":"SUM(S69:S71)","v":0},"Total DGS Sorghum",{"$f":"SUM(U69:U71)","v":0},"WDGS",0,"WDGS",0,"WDGS",{"$f":"IFERROR(AS63*S71/Q72,0)","v":0},"WDGS",{"$f":"IFERROR(AS63*U71/Q72,0)","v":0},"Corn/Sorghum Fiber",{"$f":"IFERROR(BE57,0)","v":0},"Corn/Sorghum Fiber ",{"$f":"AE72","v":0},{"$f":"IFERROR(AE72*Fuel_Specs!B8/1000000*Fuel_Specs!H40,0)","v":0},null,null,null,null,null,null,null,"WDGS",{"$f":"IFERROR($BG$63*AG71/$AX$57,0)","v":0},"WDGS",{"$f":"IFERROR($BG$63*AJ71/$AX$57,0)","v":0},"WDGS",{"$f":"IFERROR($BL$63*AG71/$AX$57,0)","v":0},"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":0},"WDGS",{"$f":"IFERROR($BN$62*$BO$35*AJ71,0)","v":0},"WDGS",{"$f":"IFERROR($BO$33*$BO$62*AG71,0)","v":0},"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":0},"DDGS",{"$f":"IFERROR(AG69+(AG69*$AY$57/$AX$57),0)","v":0},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":0},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",0,"Corn/Sorghum Fiber ",{"$f":"IFERROR(AG72+(AG72*$AY$57/$AX$57),0)","v":0}]
[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":0},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":0},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":0},{"$f":"IFERROR((F83)/AH70,0)","v":0},{"$f":"IFERROR((G83)/AH71,0)","v":0},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":0},{"$f":"F71","v":0},{"$f":"F72","v":0},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":0},{"$f":"IFERROR((F85)/AH70,0)","v":0},{"$f":"IFERROR((G85)/AH71,0)","v":0},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":0},{"$f":"H71","v":0},{"$f":"H72","v":0},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":0},{"$f":"IFERROR((F87)/AH70,0)","v":0},{"$f":"IFERROR((G87)/AH71,0)","v":0},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":0},{"$f":"IFERROR(-AA71,0)","v":0},{"$f":"IFERROR(-AA72,0)","v":0},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":"2-WAMX Mix"},null,null,null,{"$f":"BM29","v":"2-WAMX Mix"}]
[null,null,"Ethanol Production"]
[null,null,"Total feedstock used, bushels",null,{"$f":"(D57+L57)","v":0},null,null,null,{"$f":"IF(L57=0,0,D57+L57)","v":0}]
[null,null,"Total undenatured ethanol, gallons",null,{"$f":"AX57","v":0},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":0},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":0},{"$f":"IFERROR((F94)/AH70,0)","v":0},{"$f":"IFERROR((G94)/AH71,0)","v":0},{"$f":"IFERROR((H94)/AH72,0)","v":0},{"$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":0},{"$f":"AQ71","v":0},{"$f":"AQ72","v":0},{"$f":"AM69","v":0},{"$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":0},{"$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":0},{"$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":0},{"$f":"IFERROR((F98)/AH70,0)","v":0},{"$f":"IFERROR((G98)/AH71,0)","v":0},{"$f":"IFERROR((H98)/AH72,0)","v":0},{"$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":0},{"$f":"AU71","v":0},{"$f":"AU72","v":0},{"$f":"AM70","v":0},{"$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":0},{"$f":"IFERROR((F104)/AH70,0)","v":0},{"$f":"IFERROR((G104)/AH71,0)","v":0},{"$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'!C41*EtOH!AG69","v":0},{"$f":"'EF Tables'!C41*AG70","v":0},{"$f":"'EF Tables'!C41*AG71","v":0},{"$f":"BB63","v":0},{"$f":"'EF Tables'!C41*AJ69","v":0},{"$f":"'EF Tables'!C41*AJ70","v":0},{"$f":"'EF Tables'!C41*AJ71","v":0}]
[null,null,"Ethanol Transport HDD Truck, gCO2e/MJ",null,{"$f":"IFERROR((E106)/AH69,0)","v":0},{"$f":"IFERROR((F106)/AH70,0)","v":0},{"$f":"IFERROR((G106)/AH71,0)","v":0},{"$f":"IFERROR((H106)/AH72,0)","v":0},{"$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":0},{"$f":"BK71","v":0},{"$f":"BK72","v":0},{"$f":"AO69","v":0},{"$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":0},{"$f":"IFERROR((F108)/AH70,0)","v":0},{"$f":"IFERROR((G108)/AH71,0)","v":0},{"$f":"IFERROR((H108)/AH72,0)","v":0},{"$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 WA railyard, gCO2e",null,{"$f":"BO70","v":0},{"$f":"BO71","v":0},{"$f":"BO72","v":0},{"$f":"AO70","v":0},{"$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},{"$f":"IFERROR((F110)/AH70,0)","v":0},{"$f":"IFERROR((G110)/AH71,0)","v":0},{"$f":"IFERROR((H110)/AH72,0)","v":0},{"$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'!D46","v":0},{"$f":"'EF Tables'!D47","v":0},{"$f":"'EF Tables'!D48","v":0},{"$f":"'EF Tables'!D49","v":0},{"$f":"'EF Tables'!D51","v":0},{"$f":"'EF Tables'!D52","v":0},{"$f":"'EF Tables'!D53","v":0}]
[null,null,"Denaturant CI, gCO2e/MJ",null,{"$f":"IF(E93=0,0,'EF Tables'!D75)","v":0},{"$f":"IF(F93=0,0,'EF Tables'!E75)","v":0},{"$f":"IF(G93=0,0,'EF Tables'!F75)","v":0},{"$f":"IF(BE57=0,0,'EF Tables'!G75)","v":0},{"$f":"IF(I93=0,0,'EF Tables'!I75)","v":0},{"$f":"IF(J93=0,0,'EF Tables'!J75)","v":0},{"$f":"IF(K93=0,0,'EF Tables'!K75)","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'!D61","v":19.8},{"$f":"'EF Tables'!D61","v":19.8},{"$f":"'EF Tables'!D61","v":19.8},0,{"$f":"'EF Tables'!D62","v":19.399999999999999},{"$f":"'EF Tables'!D62","v":19.399999999999999},{"$f":"'EF Tables'!D62","v":19.399999999999999}]

{"sheet":"EF Tables","index":2,"n_rows":79,"n_cols":34,"rows_kept":79,"cut":false,"hidden":false,"merged":[[0,1,0,12]]}
[null,"Greenhouse Gases Emissions Factors Used in WA-GREET for Carbon Intensity Calculations\n(see \"WA-GREET for EF Table\")"]
[null,"GHG Emission Factors ","1-U.S Ave Mix","2-WAMX 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","31-ORMX Mix","32-User Defined Mix"]
[null,"Emissions from Electricity use (gCO2e/kWh) ",578.81547108787004,228.64550547041199,368.98203495539849,476.16373764191144,459.16880044914376,852.19897614032618,684.29005614750861,793.25577052723531,796.11091071314377,638.3672025198199,893.56248571959043,925.99986512528915,613.66928309105072,786.7786546446066,738.59106333639113,681.88615253075625,627.94048246799673,353.78141954175078,227.88353339618712,459.89499004632711,627.41007019082952,353.22717258193455,491.19172855757063,601.2274513040627,160.39623912489697,748.59491973645083,1145.1044253269501,682.96015864794208,181.5105027899846,166.05006134477424,462.03283199582938,{"$f":"EtOH!$BO$25","v":0}]
[]
[null,"Non-combustion (gCO2e/MJ)",{"$f":"2.239/Fuel_Specs!$I$8*Fuel_Specs!$B$17*$D$79","v":8.6694746909554699E-2}]
[null,"Enzymes and Yeast (gCO2e/MJ)",2.02]
[null,"Natiral Gas for Ethanol Production (g CO2e/MMBtu)",73411.621744961929]
[null,"Natiral Gas for Drying DGS (g CO2e/MMBtu)",73352.021744961938]
[]
[null,null,"Corn Farming, Fertilizers, N2O in soil"]
[null,null,null,"Farming","Fertilizers","N2O in soil","Total, gCO2e/bushel"]
[null,null,"VOC",0.50796653236777622,2.6136788993906119]
[null,null,"CO",4.1882508511792897,3.1793523934435308]
[null,null,"CH4",1.8429199231414202,5.8876258933381758]
[null,null,"N2O",1.8238369301727231E-2,0.77587032046168969,10.699418616296118]
[null,null,"CO2",618.71521069727191,2166.8718496917859]
[null,null,"Total, gCO2e/bushel",{"$f":"D12*Fuel_Specs!$B$17+D13*Fuel_Specs!$B$18+D14*Fuel_Specs!$B$15+D15*Fuel_Specs!$B$16+D16","v":678.38794223878824},{"$f":"E12*Fuel_Specs!$B$17+E13*Fuel_Specs!$B$18+E14*Fuel_Specs!$B$15+E15*Fuel_Specs!$B$16+E16","v":2558.4139436156215},{"$f":"F12*Fuel_Specs!$B$17+F13*Fuel_Specs!$B$18+F14*Fuel_Specs!$B$15+F15*Fuel_Specs!$B$16+F16","v":3188.4267476562432},{"$f":"SUM(D17:F17)","v":6425.2286335106528}]
[]
[null,null,"Sorghum Farming, Fertilizers, N2O in soil"]
[null,null,null,"Farming","Fertilizers","N2O is soil","Total, gCO2e/bushel"]
[null,null,"VOC",0.62376859740921908,2.8215355785189469]
[null,null,"CO",4.9311662899332873,3.5920269462934842]
[null,null,"CH4",2.0873943807254394,6.9583505708664086]
[null,null,"N2O",2.1953622897582663E-2,0.85514334333300857,11.606876093294462]
[null,null,"CO2",961.5691234210542,2317.0261879650534]
[null,null,"Total, gCO2e/bushel",{"$f":"D21*Fuel_Specs!$B$17+D22*Fuel_Specs!$B$18+D23*Fuel_Specs!$B$15+D24*Fuel_Specs!$B$16+D25","v":1029.9892169563952},{"$f":"E21*Fuel_Specs!$B$17+E22*Fuel_Specs!$B$18+E23*Fuel_Specs!$B$15+E24*Fuel_Specs!$B$16+E25","v":2760.2560682090811},{"$f":"F21*Fuel_Specs!$B$17+F22*Fuel_Specs!$B$18+F23*Fuel_Specs!$B$15+F24*Fuel_Specs!$B$16+F25","v":3458.8490758017497},{"$f":"SUM(D26:F26)","v":7249.0943609672258}]
[]
[]
[null,null,"Corn Transport","MDT Truck - Farm to Stack","HDDT","Rail"]
[null,null,"gCO2e/bushel-mile",17.253246445439522,4.3082012069138749,0.76381095330066706]
[null,null,"gCO2e",{"$f":"(EtOH!E57)*10*D30","v":0}]
[]
[]
[null,null,"Sorghum","MDT Truck - Farm to Stack","HDDT","Rail"]
[null,null,"gCO2e/bushel-mile",17.253246445439522,4.3082012069138749,0.76381095330066706]
[null,null,"gCO2e",{"$f":"(EtOH!M57)*10*D35","v":0}]
[]
[null,null,"Chemical usage"]
[null,null,{"$f":"C6*Fuel_Specs!H40","v":2131.2128170000001},"gCO2e/mmBTU"]
[null,null,{"$f":"C39/1000000","v":2.1312128170000002E-3},"gCO2e/BTU"]
[null,null,{"$f":"C40*Fuel_Specs!B8","v":162.67547432161001},"gCO2e/Gal"]
[]
[]
[null,null,"Finished Fuel Distribution",null,null,null,"Washington EtOH Distribution (gCO2e/gal-mile)"]
[null,null,"Corn",null,null,null,"HDT Truck",0.41353565695950523]
[null,null,"DDGS",{"$f":"90*H45*EtOH!AG69","v":0},"gCO2e",null,"Barge",7.3847486205478666E-2]
[null,null,"MDGS",{"$f":"90*H45*EtOH!AG70","v":0},"gCO2e",null,"Rail",8.9848888223393514E-2]
[null,null,"WDGS",{"$f":"90*H45*EtOH!AG71","v":0},"gCO2e"]
[null,null,"Corn Fiber",{"$f":"90*H45*EtOH!AE72","v":0},"gCO2e"]
[null,null,"Sorghum"]
[null,null,"DDGS",{"$f":"90*H45*EtOH!AJ69","v":0},"gCO2e"]
[null,null,"MDGS",{"$f":"90*H45*EtOH!AJ70","v":0},"gCO2e"]
[null,null,"WDGS",{"$f":"90*H45*EtOH!AJ71","v":0},"gCO2e"]
[null,null,null,"-"]
[]
[null,null,"Co-product Credit - Corn Ethanol",null,null,null,null,"DGS Displacement Ratio (lb/lb DGS)"]
[null,null,"Corn","SBM","Urea","Total, gCO2e/bone-dry lb",null,"Corn",0.78112205459050155]
[null,null,{"$f":"89.622996275385+(EtOH!D67*(D30*$I$57*10+E30*I57*EtOH!H55+F30*I57*EtOH!J55))+(EtOH!J67*(D35*I57*10+E35*I57*EtOH!P55+F35*I57*EtOH!R55))","v":89.622996275385006},71.267197718100505,13.087761768787599,{"$f":"SUM(C58:E58)","v":173.97795576227313},null,"SMB",0.30717599109096505]
[null,null,null,null,null,null,null,"Urea",2.2667827464434721E-2]
[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":0},null,"v/v CARBOB/D-EtOH"]
[null,null,"Energy % Denaturant in D-EtOH",{"$f":"IFERROR(D66*Fuel_Specs!$I$6/81.51,0)","v":0},null,"MJ/MJ CARBOB/D-EtOH"]
[null,null,"CARBOB CI *",100.36608993092545]
[null,null,"2010 Average Ethanol CI",75.391974932875655,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-D67)*D69+D67*D70)-D69","v":0},null,"g CO2e/MJ"]
[null,null,"2010  D-EtOH  CI ",{"$f":"(1-D67)*D69+D67*D70","v":75.391974932875655},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":19.886694746909555},{"$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":19.886694746909555},{"$f":"EtOH!H93+EtOH!H97+EtOH!H103+EtOH!H105+EtOH!H107+EtOH!H109+EtOH!H112+EtOH!H99+EtOH!H101","v":8.6694746909554699E-2},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$67)*D74+$D$67*$D$68-D74","v":0},{"$f":"(1-$D$67)*E74+$D$67*$D$68-E74","v":0},{"$f":"(1-$D$67)*F74+$D$67*$D$68-F74","v":0},{"$f":"(1-$D$67)*G74+$D$67*$D$68-G74","v":0},null,{"$f":"(1-$D$67)*I74+$D$67*$D$68-I74","v":0},{"$f":"(1-$D$67)*J74+$D$67*$D$68-J74","v":0},{"$f":"(1-$D$67)*K74+$D$67*$D$68-K74","v":0}]
[]
[]
[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"]