{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"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":"Sheet1","index":0,"n_rows":33,"n_cols":46,"rows_kept":33,"cut":false,"hidden":false,"merged":[[3,1,3,31],[3,32,3,45],[6,44,6,45],[4,0,5,0],[5,43,5,45],[5,7,5,10],[1,0,2,0],[1,1,1,2],[1,6,1,7],[1,11,2,14],[2,1,2,2],[2,6,2,7],[0,0,0,2],[0,11,0,12],[0,4,0,5],[0,6,0,7],[0,9,0,10],[8,44,10,44],[8,45,10,45],[11,44,12,44],[11,45,12,45],[13,44,14,45],[4,1,4,10],[5,1,5,6],[4,32,4,41],[5,32,5,39],[5,40,5,42]]}
["Producer Operational Data Summary",null,null,"Applicant:","ABC Company",null,"Feedstock Production Location:",null,"U.S","Ethanol Production Location:",null,"DEF Town, XY State"]
["CI Restults","Corn Ethanol CI, g/MJ",null,73.59,"(example CI)",null,"Sorghum Ethanol CI, g/MJ",null,74.150000000000006,"(example CI)",null,"DRAFT - FOR DISCUSSION ONLY - DO NOT USE"]
[null,"Volume, gal",null,{"$f":"AJ33*C33/(C33+H33)","v":75729360.919827402},null,null,"Volume, gal",null,{"$f":"AJ33*H33/(C33+H33)","v":15839199.0801726}]
["Process:","Inputs for Corn and Sorghum and Co-products",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inputs for Ethanol Production"]
["Data Years","Step 1) Select Feedstock Production Region ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Step 2) Select Region for Ethanol Production (Dry Mill)"]
[null,"Select Regional Electricity Mix for Feedstock Production:",null,null,null,null,null,"7-MROW 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,"Select Regional Electricity Mix for Fuel Production",null,null,null,null,null,null,null,"3-CAMX Mix"]
["Monthly Data","Beginning Corn Inventory","Corn Used (calculated)","Corn Received","Ending Corn Inventory","Corn Transport","Beginning Sorghum Inventory","Sorghum Used (calculated)","Sorghum Received","Ending Sorghum Inventory","Sorghum Transport","Dry DGS Produced\n(calculated)","Dry DGS Sales","Dry DGS Ending inventory","Moisture Content","Modified DGS Produced (calculated)","Modified DGS Sales","Modified DGS Ending Inventory","Moisture Content","Wet DGS Produced (calculated)","Wet DGS  Sales","Wet DGS Ending Inventory","Moisture Content","Syrup Produced (calculated)","Syrup Sales","Syrup Ending Inventory","Moisture Content","Corn Oil Produced (calculated)","Corn Oil Sales","Corn Oil Ending Inventory","Moisture Content","DGS Yield (calculated)","Beginning Denatured Ethanol ","Denatured Ethanol Sales ","Ending Denatured Ethanol ","Ethanol Produced (calculated)","NG Use from Invoices","Biomass Use from Invoices","Biomass Transport Distance","Biogas Use from Invoices","Biogas Parameters","Other Thermal Energy Use","Electricity from Utility Invoices","Other Electricity   Sources","Ethanol Transport"]
["Unit","Bushels","Bushels","Bushels","Bushels","Miles","Bushels","Bushels","Bushels","Bushels","Miles","Tons","Tons","Tons","%","Tons","Tons","Tons","%","Tons","Tons","Tons","%","Tons","Tons","Tons","%","lbs.","lbs.","lbs.","%","Dry matter lbs/gal EtOH","Gallons @ 60o F","Gallons @ 60o F","Gallons @ 60o F","Gallons @ 60o F","MMBtu, HHV","Dry Tons","Miles","MMBtu, HHV",null,"MMBtu, HHV","kWh","kWh","Mode","Miles"]
["Month 1",1000000,{"$f":"B9+D9-E9","v":1330000},1330000,1000000,"By HDT Truck",null,null,null,null,"By HDT Truck",{"$f":"M9+N9-0","v":888},588,300,0.1,{"$f":"Q9+R9-0","v":0},0,0,0,{"$f":"U9+V9-0","v":53000},50000,3000,0.68,{"$f":"Y9+Z9-0","v":2.2000000000000002},1,1.2,0.65,{"$f":"AC9+AD9-0","v":1400000},500000,900000,5.0000000000000001E-3,{"$f":"(((L9*(1-O9)+P9*(1-S9)+T9*(1-W9)+X9*(1-AA9))*2000+AB9*(1-AE9)))/AJ9","v":19.08079356546191},1234560,1000000,1700000,{"$f":"AG9-AH9+AI9","v":1934560},75500,95,"By HDT Truck",0,"Pipeline, miles",null,1600000,null,"By Rail",1396]
["Month 2",1000000,{"$f":"B10+D10-E10","v":1300000},1200000,900000,50,null,null,null,null,50,{"$f":"M10+N10-N9","v":1100},800,600,0.11,{"$f":"Q10+R10-R9","v":0},0,0,0,{"$f":"U10+V10-V9","v":52100},55000,100,0.68,{"$f":"Y10+Z10-Z9","v":1.0000000000000002},1,1.2,0.65,{"$f":"AC10+AD10-AD9","v":450000},500000,850000,{"$f":"AE9","v":5.0000000000000001E-3},6.0593983050847449,{"$f":"AI9","v":1700000},1000000,5200000,{"$f":"AG10-AH10+AI10","v":5900000},78000,10,80,0,80,null,1500000]
["Month 3",1000000,1300000,1400000,1100000,"By Rail",null,null,null,null,"By Rail",{"$f":"M11+N11-N10","v":116},136,580,0.11,{"$f":"Q11+R11-R10","v":0},0,0,0,{"$f":"U11+V11-V10","v":55485},55555,30,0.68,{"$f":"Y11+Z11-Z10","v":1.0000000000000002},1,1.2,0.65,{"$f":"AC11+AD11-AD10","v":600000},500000,950000,{"$f":"AE10","v":5.0000000000000001E-3},5.5022090909090897,{"$f":"AI10","v":5200000},1000000,2400000,6600000,67000,260,"By Rail",0,null,null,1500000]
["Month 4",1000000,1100000,1400000,1300000,1400,500000,{"$f":"G12+I12-J12","v":900000},1000000,600000,1400,132,100,612,0.11,0,0,0,0,22215,22225,20,0.68,1.0000000000000002,1,1.2,0.65,250000,500000,700000,5.0000000000000001E-3,3.8689499999999994,2400000,1000000,2400000,3800000,73000,200,2000,0,null,null,1500000,null,"By Heavy Duty Diesel Truck",100]
["Month 5",1000000,839000,839000,1000000,null,500000,2100000,2000000,400000,null,135,135,612,0.11,0,0,0,0,79992,80000,12,0.68,1.0000000000000002,1,1.2,0.65,300000,500000,500000,5.0000000000000001E-3,8.7685389830508456,2400000,1000000,4500000,5900000,53000,100,null,0,null,null,1500000]
["Month 6",1000000,800000,1300000,1500000,null,500000,750000,700000,450000,null,135,135,612,0.11,0,0,0,0,90010,90000,22,0.68,1.0000000000000002,1,1.2,0.65,984000,500000,984000,5.0000000000000001E-3,10.893792592592591,4500000,1500000,2400000,5400000,73000,81,null,0,null,null,1500000,null,"By Other Modes"]
["Month 7",1000000,1700000,1500000,800000,null,null,null,null,null,null,435,435,612,0.11,0,0,0,0,79980,80000,2,0.68,1.0000000000000002,1,1.2,0.65,{"$f":"AC15+AD15-AD14","v":916000},800000,1100000,5.0000000000000001E-3,23.667690241718887,2400000,2566000,2400000,2234000,77000,105,null,0,null,null,1500000]
["Month 8",1000000,1500000,1500000,1000000,null,null,null,null,null,null,133,133,612,0.11,0,0,0,0,50031,50000,33,0.68,1.0000000000000002,1,1.2,0.65,460000,600000,960000,5.0000000000000001E-3,8.6092052631578948,2400000,1000000,2400000,3800000,78999,90,null,0,null,null,1500000,null,"Specify Mode",0]
["Month 9",1000000,1580000,1280000,700000,null,null,null,null,null,null,461,461,612,0.11,0,0,0,0,29972,30000,5,0.68,1.0000000000000002,1,1.2,0.65,380000,580000,760000,5.0000000000000001E-3,9.2643000000000004,2400000,2600000,2400000,2200000,72000,86,null,0,null,null,1500000,null,"Specify Mode",0]
["Month 10",1000000,1090000,1290000,1200000,null,null,null,null,null,null,314,314,612,0.11,0,0,0,0,52273,52222,56,0.68,1.0000000000000002,1,1.2,0.65,550000,690000,620000,5.0000000000000001E-3,21.600993749999997,2400000,3200000,2400000,1600000,68000,66,null,0,null,null,1500000]
["Month 11",1000000,1550000,1550000,1000000,null,null,null,null,null,null,133,133,612,0.11,0,0,0,0,55398,55444,10,0.68,1.0000000000000002,1,1.2,0.65,80000,500000,200000,5.0000000000000001E-3,12.77562857142857,2400000,2000000,2400000,2800000,80000,116,null,0,null,null,1500000]
["Month 12",1000000,950000,1450000,1500000,null,null,null,null,null,null,161,161,612,0.11,0,0,0,0,10991,11000,1,0.68,1.0000000000000002,1,1.2,0.65,1200000,500000,900000,5.0000000000000001E-3,2.2409263157894737,2400000,1000000,2400000,3800000,85000,115,null,0,null,null,1500000]
["Month 13",1000000,1408000,1308000,900000,null,null,null,null,null,null,131,131,612,0.11,0,0,0,0,11049,11000,50,0.68,1.0000000000000002,1,1.2,0.65,500000,500000,900000,5.0000000000000001E-3,2.0533526315789472,2400000,1000000,2400000,3800000,80000,111,null,0,null,null,1500000]
["Month 14",1000000,1308000,1308000,1000000,null,null,null,null,null,null,111,111,612,0.11,0,0,0,0,11000,11000,50,0.68,1.0000000000000002,1,1.2,0.65,155500.46999999997,500000,555500.47,5.0000000000000001E-3,1.9455270967499998,2400000,1000000,2400000,3800000,60000,128,null,0,null,null,1500000]
["Month 15",1000000,1418000,1308000,890000,null,null,null,null,null,null,120,120,612,0.11,0,0,0,0,10980,11000,30,0.68,1.0000000000000002,1,1.2,0.65,680467.5,500000,735967.97,5.0000000000000001E-3,2.0838329374999995,2400000,1000000,2400000,3800000,82000,126,null,0,null,null,1500000]
["Month 16",1000000,1308000,1308000,1000000,null,null,null,null,null,null,145,145,612,0.11,0,0,0,0,10990,11000,20,0.68,1.0000000000000002,1,1.2,0.65,544032.03,500000,780000,5.0000000000000001E-3,2.0615031236447368,2400000,1000000,2400000,3800000,80000,120,null,0,null,null,1500000]
["Month 17",1000000,1251110,1308000,1056890,null,null,null,null,null,null,123,123,612,0.11,0,0,0,0,11040,11000,60,0.68,1.0000000000000002,1,1.2,0.65,688000,500000,968000,5.0000000000000001E-3,2.0973157894736838,2400000,1000000,2400000,3800000,82000,116,null,0,null,null,1500000]
["Month 18",1000000,1645460,1308000,662540,null,null,null,null,null,null,56,56,612,0.11,0,0,0,0,10995,11000,55,0.68,1.0000000000000002,1,1.2,0.65,212000,500000,680000,5.0000000000000001E-3,1.9337157894736841,2400000,1000000,2400000,3800000,77040,116,null,0,null,null,1500000]
["Month 19",1000000,1058000,1308000,1250000,null,500000,{"$f":"G27+I27-J27","v":800000},1000000,700000,null,548,548,612,0.11,0,0,0,0,10996,11000,51,0.68,1.0000000000000002,1,1.2,0.65,590000,500000,770000,5.0000000000000001E-3,2.2633236842105262,2400000,1000000,2400000,3800000,79000,86,null,0,null,null,1500000]
["Month 20",1000000,1420000,1408000,988000,null,500000,1470000,1500000,530000,null,102,102,612,0.11,0,0,0,0,10970,11000,21,0.68,1.0000000000000002,1,1.2,0.65,730000,500000,1000000,5.0000000000000001E-3,2.0866868421052631,2400000,1000000,2400000,3800000,77000,86,null,0,null,null,1500000]
["Month 21",1000000,1755000,1408000,653000,null,500000,610000,700000,590000,null,23,23,612,0.11,0,0,0,0,10991,11000,12,0.68,1.0000000000000002,1,1.2,0.65,400000,500000,900000,5.0000000000000001E-3,1.9668105263157889,2400000,1000000,2400000,3800000,58000,89,null,0,null,null,1500000]
["Month 22",1000000,972360,1208000,1235640,null,null,null,null,null,null,110,110,612,0.11,0,0,0,0,11001,11000,13,0.68,1.0000000000000002,1,1.2,0.65,655000,500000,1055000,5.0000000000000001E-3,2.0760171052631575,2400000,1000000,2400000,3800000,99000,134,null,0,null,null,1500000]
["Month 23",1000000,1508000,1508000,1000000,null,null,null,null,null,null,200,200,612,0.11,0,0,0,0,10997,11000,10,0.68,1.0000000000000002,1,1.2,0.65,645000,500000,1200000,5.0000000000000001E-3,2.1148828947368417,2400000,1000000,2400000,3800000,87000,111,null,0,null,null,1500000]
["Month 24",1000000,1608000,1508000,900000,null,null,null,null,null,null,222,222,612,0.11,0,0,0,0,11009,11000,19,0.68,1.0000000000000002,1,1.2,0.65,300000,500000,1000000,5.0000000000000001E-3,2.0368736842105259,2400000,1000000,2400000,3800000,80000,127,null,0,null,null,1500000]
["Total or Average",{"$f":"SUM(B9:B32)","v":24000000},{"$f":"SUM(C9:C32)","v":31698930},{"$f":"SUM(D9:D32)","v":32235000},{"$f":"SUM(E9:E32)","v":24536070},null,3000000,{"$f":"SUM(H9:H32)","v":6630000},6900000,3270000,null,{"$f":"SUM(L9:L32)","v":6034},{"$f":"SUM(M9:M32)","v":5422},{"$f":"SUM(N9:N32)","v":14332},{"$f":"AVERAGE(O9:O32)","v":0.10958333333333335},{"$f":"SUM(P9:P32)","v":0},{"$f":"SUM(Q9:Q32)","v":0},0,{"$f":"AVERAGE(S9:S32)","v":0},{"$f":"SUM(T9:T32)","v":763465},{"$f":"SUM(U9:U32)","v":763446},{"$f":"SUM(V9:V32)","v":3682},{"$f":"AVERAGE(W9:W32)","v":0.67999999999999983},{"$f":"SUM(X9:X32)","v":25.200000000000003},{"$f":"SUM(Y9:Y32)","v":24},{"$f":"SUM(Z9:Z32)","v":28.79999999999999},{"$f":"AVERAGE(AA9:AA32)","v":0.65000000000000024},{"$f":"SUM(AB9:AB32)","v":13669999.999999998},{"$f":"SUM(AC9:AC32)","v":12670000},{"$f":"SUM(AD9:AD32)","v":19968468.440000001},{"$f":"AVERAGE(AE9:AE32)","v":5.0000000000000018E-3},{"$f":"(((L33*(1-O33)+P33*(1-S33)+T33*(1-W33)+X33*(1-AA33))*2000+AB33*(1-AE33)))/AJ33","v":5.6021678000979112},{"$f":"SUM(AG9:AG32)","v":60634560},30866000,{"$f":"SUM(AI9:AI32)","v":61800000},{"$f":"SUM(AJ9:AJ32)","v":91568560},{"$f":"SUM(AK9:AK32)","v":1821539},2674,null,0,null,{"$f":"SUM(AP9:AP32)","v":0},36100000,{"$f":"SUM(AR9:AR32)","v":0}]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}