{"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":36,"n_cols":51,"rows_kept":36,"cut":false,"hidden":false,"merged":[[5,1,5,36],[5,37,5,50],[9,49,9,50],[6,0,7,0],[7,48,7,50],[7,6,7,10],[6,1,6,10],[7,1,7,5],[6,37,6,46],[7,37,7,44],[7,45,7,47],[0,0,0,1],[0,11,0,13],[0,4,0,5],[0,9,0,10],[1,0,4,0],[1,11,4,15],[11,49,13,49],[11,50,13,50],[14,49,15,49],[14,50,15,50],[16,49,17,50]]}
["Producer Operational Data Summary",null,"Applicant:",null,"ABC Company",null,null,"U.S",null,"Ethanol Production Location:",null,"DEF Town, XY State"]
["CI Restults","Corn, Wet DGS",73.59,null,"(example CI)",null,"Sorghum, Wet DGS",74.150000000000006,null,"(example CI)",null,"DRAFT - FOR DISCUSSION ONLY - DO NOT USE"]
[null,"Corn, Modified DGS",null,null,"(example CI)",null,"Sorghum, Modified DGS",null,null,"(example CI)"]
[null,"Corn, Dry DGS",null,null,"(example CI)",null,"Sorghum, Dry DGS",null,null,"(example CI)"]
[null,null,{"$f":"AL36*B36/(B36+G36)","v":75043829.674382105},null,null,null,null,{"$f":"AL36*G36/(B36+G36)","v":16524730.325617889}]
["Process:"]
["Data Years"]
[null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3-CAMX Mix"]
["Beg Inv","Corn",null,null,null,null,"Sorghum",null,null,null,null,"Dry DGS",null,null,null,null,"Modified DGS",null,null,null,null,"Wet DGS",null,null,null,null,"Syrup",null,null,null,null,"Corn Oil",null,null,null,null,null,null,null,null,1234560]
["Monthly Data","Corn Used (calculated)","Corn Received","Corn Inventory Adjustment","Ending Corn Inventory","Corn Transport","Sorghum Used (calculated)","Sorghum Received","Sorghum Inventory Adjustment","Ending Sorghum Inventory","Sorghum Transport","Dry DGS Produced\n(calculated)","Dry DGS Inventory Adjustment","Dry DGS Shipments","Dry DGS Ending inventory","Moisture Content","Modified DGS Produced (calculated)","Modified DGS Inventory Adjustment","Modified DGS Shipments","Modified DGS Ending Inventory","Moisture Content","Wet DGS Produced (calculated)","Wet DGS Inventory Adjustment","Wet DGS  Shipments","Wet DGS Ending Inventory","Moisture Content","Syrup Produced (calculated)","Syrup Inventory Adjustment","Syrup Shipments","Syrup Ending Inventory","Moisture Content","Corn Oil Produced (calculated)","Corn Oil Inventory Adjustment","Corn Oil Shipments","Corn Oil Ending Inventory","Moisture Content","DGS Yield (calculated)","Ethanol Produced (calculated)","Ethanol Inventory Adjustment","Denatured Ethanol Shipments","Ending Denatured Ethanol ","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","%","Tons","Tons","Tons","Tons","%","lbs.","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",{"$f":"E9+C12-E12","v":330000},1330000,null,1000000,"By HDT Truck",{"$f":"J9+H12-J12","v":0},null,null,null,"By HDT Truck",{"$f":"N12+O12-O9","v":888},null,588,300,0.1,{"$f":"S12+T12-T9","v":0},null,0,0,0,{"$f":"X12+Y12-Y9","v":53000},null,50000,3000,0.68,{"$f":"AC12+AD12-AD9","v":2.2000000000000002},null,1,1.2,0.65,{"$f":"AH12+AI12-AI9","v":1400000},null,500000,900000,5.0000000000000001E-3,{"$f":"(((L12*(1-P12)+Q12*(1-U12)+V12*(1-Z12)+AA12*(1-AE12))*2000+AF12*(1-AJ12)))/AL12","v":19.08079356546191},1934560,null,1000000,{"$f":"AO9+AL12+AM12-AN12","v":2169120},75500,95,"By HDT Truck",0,"Pipeline, miles",null,1600000,null,"By Rail",1396]
["Month 2",{"$f":"E12+C13-E13","v":1300000},1200000,null,900000,50,{"$f":"J12+H13-J13","v":0},null,null,null,50,{"$f":"N13+O13-O12","v":1100},null,800,600,0.11,{"$f":"S13+T13-T12","v":0},null,0,0,0,{"$f":"X13+Y13-Y12","v":52100},null,55000,100,0.68,{"$f":"AC13+AD13-AD12","v":1.0000000000000002},null,1,1.2,0.65,{"$f":"AH13+AI13-AI12","v":450000},null,500000,850000,{"$f":"AJ12","v":5.0000000000000001E-3},6.0593983050847449,5900000,-10000,1000000,{"$f":"AO12+AL13+AM13-AN13","v":7059120},78000,10,80,0,80,null,1500000]
["Month 3",{"$f":"E13+C14-E14","v":1200000},1400000,null,1100000,"By Rail",{"$f":"J13+H14-J14","v":0},null,null,null,"By Rail",{"$f":"N14+O14-O13","v":116},null,136,580,0.11,{"$f":"S14+T14-T13","v":0},null,0,0,0,{"$f":"X14+Y14-Y13","v":55485},null,55555,30,0.68,{"$f":"AC14+AD14-AD13","v":1.0000000000000002},null,1,1.2,0.65,{"$f":"AH14+AI14-AI13","v":600000},null,500000,950000,{"$f":"AJ13","v":5.0000000000000001E-3},5.5022090909090897,6600000,null,1000000,{"$f":"AO13+AL14+AM14-AN14","v":12659120},67000,260,"By Rail",0,null,null,1500000]
["Month 4",1200000,1400000,null,1300000,1400,400000,1000000,null,600000,1400,132,null,100,612,0.11,0,null,0,0,0,22215,null,22225,20,0.68,1.0000000000000002,null,1,1.2,0.65,250000,null,500000,700000,5.0000000000000001E-3,3.8689499999999994,3800000,null,1000000,15459120,73000,200,2000,0,null,null,1500000,null,"By Heavy Duty Diesel Truck",100]
["Month 5",1139000,839000,null,1000000,null,2200000,2000000,null,400000,null,135,null,135,612,0.11,0,null,0,0,0,79992,null,80000,12,0.68,1.0000000000000002,null,1,1.2,0.65,300000,null,500000,500000,5.0000000000000001E-3,8.7685389830508456,5900000,null,1000000,20359120,53000,100,null,0,null,null,1500000]
["Month 6",800000,1300000,null,1500000,null,650000,700000,null,450000,null,135,null,135,612,0.11,0,null,0,0,0,90010,null,90000,22,0.68,1.0000000000000002,null,1,1.2,0.65,984000,null,500000,984000,5.0000000000000001E-3,10.893792592592591,5400000,null,1500000,24259120,73000,81,null,0,null,null,1500000,null,"By Other Modes"]
["Month 7",2200000,1500000,null,800000,null,450000,null,null,null,null,435,null,435,612,0.11,0,null,0,0,0,79980,null,80000,2,0.68,1.0000000000000002,null,1,1.2,0.65,{"$f":"AH18+AI18-AI17","v":916000},null,800000,1100000,5.0000000000000001E-3,23.667690241718887,2234000,null,2566000,23927120,77000,105,null,0,null,null,1500000]
["Month 8",1300000,1500000,null,1000000,null,0,null,null,null,null,133,null,133,612,0.11,0,null,0,0,0,50031,null,50000,33,0.68,1.0000000000000002,null,1,1.2,0.65,460000,null,600000,960000,5.0000000000000001E-3,8.6092052631578948,3800000,null,1000000,26727120,78999,90,null,0,null,null,1500000,null,"Specify Mode",0]
["Month 9",1580000,1280000,null,700000,null,0,null,null,null,null,461,null,461,612,0.11,0,null,0,0,0,29972,null,30000,5,0.68,1.0000000000000002,null,1,1.2,0.65,380000,null,580000,760000,5.0000000000000001E-3,9.2643000000000004,2200000,null,2600000,26327120,72000,86,null,0,null,null,1500000,null,"Specify Mode",0]
["Month 10",790000,1290000,null,1200000,null,0,null,null,null,null,314,null,314,612,0.11,0,null,0,0,0,52273,null,52222,56,0.68,1.0000000000000002,null,1,1.2,0.65,550000,null,690000,620000,5.0000000000000001E-3,21.600993749999997,1600000,null,3200000,24727120,68000,66,null,0,null,null,1500000]
["Month 11",1750000,1550000,null,1000000,null,0,null,null,null,null,133,null,133,612,0.11,0,null,0,0,0,55398,null,55444,10,0.68,1.0000000000000002,null,1,1.2,0.65,80000,null,500000,200000,5.0000000000000001E-3,12.77562857142857,2800000,null,2000000,25527120,80000,116,null,0,null,null,1500000]
["Month 12",950000,1450000,null,1500000,null,0,null,null,null,null,161,null,161,612,0.11,0,null,0,0,0,10991,null,11000,1,0.68,1.0000000000000002,null,1,1.2,0.65,1200000,null,500000,900000,5.0000000000000001E-3,2.2409263157894737,3800000,null,1000000,28327120,85000,115,null,0,null,null,1500000]
["Month 13",1908000,1308000,null,900000,null,0,null,null,null,null,131,null,131,612,0.11,0,null,0,0,0,11049,null,11000,50,0.68,1.0000000000000002,null,1,1.2,0.65,500000,null,500000,900000,5.0000000000000001E-3,2.0533526315789472,3800000,null,1000000,31127120,80000,111,null,0,null,null,1500000]
["Month 14",1208000,1308000,null,1000000,null,0,null,null,null,null,111,null,111,612,0.11,0,null,0,0,0,11000,null,11000,50,0.68,1.0000000000000002,null,1,1.2,0.65,155500.46999999997,null,500000,555500.47,5.0000000000000001E-3,1.9455270967499998,3800000,null,1000000,33927120,60000,128,null,0,null,null,1500000]
["Month 15",1418000,1308000,null,890000,null,0,null,null,null,null,120,null,120,612,0.11,0,null,0,0,0,10980,null,11000,30,0.68,1.0000000000000002,null,1,1.2,0.65,680467.5,null,500000,735967.97,5.0000000000000001E-3,2.0838329374999995,3800000,-25000,1000000,36702120,82000,126,null,0,null,null,1500000]
["Month 16",1198000,1308000,null,1000000,null,0,null,null,null,null,145,null,145,612,0.11,0,null,0,0,0,10990,null,11000,20,0.68,1.0000000000000002,null,1,1.2,0.65,544032.03,null,500000,780000,5.0000000000000001E-3,2.0615031236447368,3800000,null,1000000,39502120,80000,120,null,0,null,null,1500000]
["Month 17",1251110,1308000,null,1056890,null,0,null,null,null,null,123,null,123,612,0.11,0,null,0,0,0,11040,null,11000,60,0.68,1.0000000000000002,null,1,1.2,0.65,688000,null,500000,968000,5.0000000000000001E-3,2.0973157894736838,3800000,null,1000000,42302120,82000,116,null,0,null,null,1500000]
["Month 18",1702350,1308000,null,662540,null,0,null,null,null,null,56,null,56,612,0.11,0,null,0,0,0,10995,null,11000,55,0.68,1.0000000000000002,null,1,1.2,0.65,212000,null,500000,680000,5.0000000000000001E-3,1.9337157894736841,3800000,null,1000000,45102120,77040,116,null,0,null,null,1500000]
["Month 19",720540,1308000,null,1250000,null,{"$f":"J29+H30-J30","v":300000},1000000,null,700000,null,548,null,548,612,0.11,0,null,0,0,0,10996,null,11000,51,0.68,1.0000000000000002,null,1,1.2,0.65,590000,null,500000,770000,5.0000000000000001E-3,2.2633236842105262,3800000,null,1000000,47902120,79000,86,null,0,null,null,1500000]
["Month 20",1670000,1408000,null,988000,null,1670000,1500000,null,530000,null,102,null,102,612,0.11,0,null,0,0,0,10970,null,11000,21,0.68,1.0000000000000002,null,1,1.2,0.65,730000,null,500000,1000000,5.0000000000000001E-3,2.0866868421052631,3800000,null,1000000,50702120,77000,86,null,0,null,null,1500000]
["Month 21",1743000,1408000,null,653000,null,640000,700000,null,590000,null,23,null,23,612,0.11,0,null,0,0,0,10991,null,11000,12,0.68,1.0000000000000002,null,1,1.2,0.65,400000,null,500000,900000,5.0000000000000001E-3,1.9668105263157889,3800000,null,1000000,53502120,58000,89,null,0,null,null,1500000]
["Month 22",625360,1208000,null,1235640,null,{"$f":"J32+H33-J33","v":590000},null,null,null,null,110,null,110,612,0.11,0,null,0,0,0,11001,null,11000,13,0.68,1.0000000000000002,null,1,1.2,0.65,655000,null,500000,1055000,5.0000000000000001E-3,2.0760171052631575,3800000,null,1000000,56302120,99000,134,null,0,null,null,1500000]
["Month 23",1743640,1508000,null,1000000,null,0,null,null,null,null,200,null,200,612,0.11,0,null,0,0,0,10997,null,11000,10,0.68,1.0000000000000002,null,1,1.2,0.65,645000,null,500000,1200000,5.0000000000000001E-3,2.1148828947368417,3800000,null,1000000,59102120,87000,111,null,0,null,null,1500000]
["Month 24",1608000,1508000,null,900000,null,0,null,null,null,null,222,null,222,612,0.11,0,null,0,0,0,11009,null,11000,19,0.68,1.0000000000000002,null,1,1.2,0.65,300000,null,500000,1000000,5.0000000000000001E-3,2.0368736842105259,3800000,null,1000000,61902120,80000,127,null,0,null,null,1500000]
["Total or Average",{"$f":"SUM(B12:B35)","v":31335000},{"$f":"SUM(C12:C35)","v":32235000},null,{"$f":"SUM(E12:E35)","v":24536070},null,{"$f":"SUM(G12:G35)","v":6900000},6900000,null,3270000,null,{"$f":"SUM(L12:L35)","v":6034},null,{"$f":"SUM(N12:N35)","v":5422},{"$f":"SUM(O12:O35)","v":14332},{"$f":"AVERAGE(P12:P35)","v":0.10958333333333335},{"$f":"SUM(Q12:Q35)","v":0},null,{"$f":"SUM(S12:S35)","v":0},0,{"$f":"AVERAGE(U12:U35)","v":0},{"$f":"SUM(V12:V35)","v":763465},null,{"$f":"SUM(X12:X35)","v":763446},{"$f":"SUM(Y12:Y35)","v":3682},{"$f":"AVERAGE(Z12:Z35)","v":0.67999999999999983},{"$f":"SUM(AA12:AA35)","v":25.200000000000003},null,{"$f":"SUM(AC12:AC35)","v":24},{"$f":"SUM(AD12:AD35)","v":28.79999999999999},{"$f":"AVERAGE(AE12:AE35)","v":0.65000000000000024},{"$f":"SUM(AF12:AF35)","v":13669999.999999998},null,{"$f":"SUM(AH12:AH35)","v":12670000},{"$f":"SUM(AI12:AI35)","v":19968468.440000001},{"$f":"AVERAGE(AJ12:AJ35)","v":5.0000000000000018E-3},5.6021678000979112,{"$f":"SUM(AL12:AL35)","v":91568560},{"$f":"SUM(AM12:AM35)","v":-35000},30866000,{"$f":"SUM(AO12:AO35)","v":795602880},{"$f":"SUM(AP12:AP35)","v":1821539},2674,null,0,null,{"$f":"SUM(AU12:AU35)","v":0},36100000,{"$f":"SUM(AW12:AW35)","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":[]}