{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["budgets","longRun"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":48,"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":"budgets","index":0,"n_rows":397,"n_cols":54,"rows_kept":397,"cut":false,"hidden":false,"merged":[[77,2,77,7],[78,4,78,5],[79,4,79,5],[80,1,80,7],[1,5,3,7],[4,2,4,7],[9,1,11,3],[7,4,7,5],[8,1,8,7]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,3,4,5,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH4*1000+41","v":17113041},{"$f":"VLOOKUP($T3,$T$9:$Y$397,U$2,FALSE)","v":160},125,189,217,173,{"$f":"AVERAGE(U3:Y3)+10","v":182.8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH4*1000+81","v":17113081},56,52,56,63,57,{"$f":"AVERAGE(U4:Y4)+2","v":58.8},null,null,"Illinois",17,"IL",null,{"$f":"E80","v":"McLean"},{"$f":"VLOOKUP(AG4,$AG$11:$AH$113,2,FALSE)","v":17113}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Indiana",18,"IN"]
[]
[null,null,"2016 Budgets",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N11:O42)","v":0}]
[null,null,null,"Default budget:   ","Central Illinois - High",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"code",2011,2012,2013,2014,2015,null,null,null,null,null,null,null,null,null,null,null,null,null,"Corn"]
[null,{"$f":"IF(N9=0,\"\",\"Budget inputs vary from defaults. Hit 'Use Defaults' to use default entries.\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N14:O59)","v":0},null,null,null,null,null,17001041,134,112,152,200,150]
[null,"Enter budget information in blue text cells.  Clicking \"Use Default\" will replace all items.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(AM11:AS11)","v":"Northern Illinois"},null,17001081,41,40,43,51,44]
[null,null,null,null,"Corn","Soybeans","Average",null,null,null,null,null,null,null,null,null,null,"Central Illinois - High",null,17003041,100,108,173,191,143,null,"Adams",17001,null,"Adams",18001,null,{"$f":"IF($E$79=$AC$4,AA11,AD11)","v":"Adams"},{"$f":"IF($AC$4=$E$79,AB11,AE11)","v":17001},null,1,null,null,"Northern Illinois","Central Illinois - High","Central Illinois - Low","Southern Illinois","Indiana - High","Indiana - Avg","Indiana - Low",null,null,{"$f":"AM11","v":"Northern Illinois"},"Central Illinois - High","Central Illinois - Low","Southern Illinois","Indiana - High","Indiana - Avg","Indiana - Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Central Illinois - Low",null,17003081,35,43,46,55,45,null,"Alexander",17003,null,"Allen",18003,null,"Alexander",17003,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Southern Illinois",null,17005041,117,93,150,179,135,null,"Bond",17005,null,"Bartholomew",18005,null,"Bond",17005,null,3]
[null,null,null,"Percent of acres",{"$f":"K14","v":0.6},{"$f":"1-E14","v":0.4},{"$f":"SUM(E14:F14)","v":1},null,null,null,{"$f":"HLOOKUP($E$8,$AM$11:$AS$59,AJ14,FALSE)","v":0.6},{"$f":"1-K14","v":0.4},null,{"$f":"IF(E14=K14,0,1)","v":0},{"$f":"IF(F14=L14,0,1)","v":0},null,null,"Indiana - High",null,17005081,36,30,39,50,39,null,"Boone",17007,null,"Benton",18007,null,"Boone",17007,null,4,"Percent of acres",null,0.6,0.6,0.6,0.6,0.5,0.5,0.5,null,"Percent of acres"]
[null,null,null,"Yield per acre",{"$f":"K15","v":198},{"$f":"L15","v":57},null,null,null,null,{"$f":"HLOOKUP($E$8,$AM$11:$AS$59,AJ15,FALSE)","v":198},{"$f":"HLOOKUP($E$8,$AV$11:$BB$52,AJ15,FALSE)","v":57},null,0,0,null,null,"Indiana - Avg",null,17007041,180,113,178,188,165,null,"Brown",17009,null,"Blackford",18009,null,"Brown",17009,null,{"$f":"AJ14+1","v":5},"Yield per acre",null,194,198,184,162,198,165,132,null,"Yield per acre",59,57,52,47,60,50,40]
[null,null,null,"Futures price ($/bu.)",{"$f":"K16","v":4.3499999999999996},{"$f":"L16","v":10.3},null,null,null,null,4.3499999999999996,10.3,null,0,0,null,null,"Indiana - Low",null,17007081,60,44,51,57,53,null,"Bureau",17011,null,"Boone",18011,null,"Bureau",17011,null,{"$f":"AJ15+1","v":6},"Futures price ($/bu.)",null,4.3499999999999996,{"$f":"AM16","v":4.3499999999999996},{"$f":"AN16","v":4.3499999999999996},4.3499999999999996,4.3499999999999996,4.3499999999999996,4.3499999999999996,null,"Futures price ($/bu.)",10.3,{"$f":"AV16","v":10.3},{"$f":"AW16","v":10.3},10.3,10.3,10.3,10.3]
[null,null,null,"Basis ($/bu.)",{"$f":"K17","v":0.3},{"$f":"L17","v":0.3},null,null,null,null,0.3,0.3,null,0,0,null,null,null,null,17009041,127,112,176,194,152,null,"Calhoun",17013,null,"Brown",18013,null,"Calhoun",17013,null,7,"Basis ($/bu.)",null,0.3,{"$f":"AM17","v":0.3},{"$f":"AN17","v":0.3},0.3,0.3,0.3,0.3,null,"Basis ($/bu.)",0.3,0.3,0.3,0.3,0.3,0.3,0.3]
[null,null,null,"Cash price ($/bu.)",{"$f":"E16-E17","v":4.05},{"$f":"F16-F17","v":10},null,null,null,null,null,null,null,null,null,null,null,null,null,17009081,39,36,47,51,43,null,"Carroll",17015,null,"Carroll",18015,null,"Carroll",17015,null,8,"Cash price ($/bu.)",null,null,null,null,null,null,null,null,null,"Cash price ($/bu.)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17011041,177,145,186,195,176,null,"Cass",17017,null,"Cass",18017,null,"Cass",17017,null,9]
[null,null,"Revenue",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17011081,57,55,55,60,57,null,"Champaign",17019,null,"Clark",18019,null,"Champaign",17019,null,10]
[null,null,null,"Crop revenue",{"$f":"E18*E15","v":801.9},{"$f":"F18*F15","v":570},{"$f":"E21*$E$14+F21*$F$14","v":709.14},null,null,null,null,null,null,null,null,null,null,null,null,17013041,144,107,165,194,153,null,"Christian",17021,null,"Clay",18021,null,"Christian",17021,null,11,"Crop revenue",null,null,null,null,null,null,null,null,null,"Crop revenue"]
[null,null,null,"Other revenue",{"$f":"K22","v":0},{"$f":"L22","v":0},{"$f":"E22*$E$14+F22*$F$14","v":0},null,null,null,0,{"$f":"HLOOKUP($E$8,$AV$11:$BB$52,AJ22,FALSE)","v":0},null,{"$f":"IF(E22=K22,0,1)","v":0},{"$f":"IF(F22=L22,0,1)","v":0},null,null,null,null,17013081,43,41,46,46,44,null,"Clark",17023,null,"Clinton",18023,null,"Clark",17023,null,12,"Other revenue",null,null,null,null,null,null,null,null,null,"Other revenue"]
[null,null,null,"ARC/PLC payments",{"$f":"ROUND(IF(E88=$S$76,E109,E111)*E103,)","v":0},{"$f":"ROUND(IF(F88=$S$76,F109,F111)*F103,)","v":11},{"$f":"E23*E103+F23*F103","v":4.4000000000000004},null,null,null,null,null,null,null,null,null,null,null,null,17015041,183,156,198,194,183,null,"Clay",17025,null,"Crawford",18025,null,"Clay",17025,null,13,"ARC payments",null,null,null,null,null,null,null,null,null,"ARC payments"]
[null,null,null,"Crop insurance",{"$f":"MAX(0,MAX(E18,E86)*E85*E84-E16*E15)","v":0},{"$f":"MAX(0,MAX(F18,F86)*F85*F84-F16*F15)","v":0},{"$f":"E24*$E$14+F24*$F$14","v":0},null,null,null,null,null,null,null,null,null,null,null,null,17015081,64,59,57,60,60,null,"Clinton",17027,null,"Daviess",18027,null,"Clinton",17027,null,14,"Crop insurance",null,null,null,null,null,null,null,null,null,"Crop insurance"]
[null,null,"Total revenue",null,{"$f":"SUM(E21:E23)","v":801.9},{"$f":"SUM(F21:F23)","v":581},{"$f":"SUM(G21:G24)","v":713.54},null,null,null,null,null,null,null,null,null,null,null,null,17017041,164,122,184,207,169,null,"Coles",17029,null,"Dearborn",18029,null,"Coles",17029,null,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17017081,50,39,52,53,49,null,"Cook",17031,null,"Decatur",18031,null,"Cook",17031,null,16]
[null,null,"Expenses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17019041,164,123,168,215,168,null,"Crawford",17033,null,"DeKalb",18033,null,"Crawford",17033,null,17]
[null,null,null,"Fertilizer",{"$f":"K28","v":138},49,{"$f":"E28*$E$14+F28*$F$14","v":102.4},null,null,null,138,{"$f":"HLOOKUP($E$8,$AV$11:$BB$52,AJ28,FALSE)","v":49},null,{"$f":"IF(E28=K28,0,1)","v":0},{"$f":"IF(F28=L28,0,1)","v":0},null,null,null,null,17019081,51,47,53,64,54,null,"Cumberland",17035,null,"Delaware",18035,null,"Cumberland",17035,null,18,"Fertilizer",null,144,138,138,138,156,147,137,null,"Fertilizer",37,49,43,49,67,57,47]
[null,null,null,"Pesticide",60,41,52.400000000000006,null,null,null,60,41,null,{"$f":"IF(E29=K29,0,1)","v":0},{"$f":"IF(F29=L29,0,1)","v":0},null,null,null,null,17021041,155,129,199,216,175,null,"DeKalb",17037,null,"Dubois",18037,null,"DeKalb",17037,null,19,"Pesticide",null,60,60,60,60,43,43,43,null,"Pesticide",39,41,41,41,28,28,28]
[null,null,null,"Seed",123,78,105,null,null,null,123,78,null,0,0,null,null,null,null,17021081,52,55,56,58,55,null,"De Witt",17039,null,"Elkhart",18039,null,"De Witt",17039,null,20,"Seed",null,124,123,128,119,123,123,100,null,"Seed",78,78,80,78,74,74,74]
[null,null,null,"Drying",23,1,14.2,null,null,null,23,1,null,0,0,null,null,null,null,17023041,138,107,172,197,154,null,"Douglas",17041,null,"Fayette",18041,null,"Douglas",17041,null,21,"Drying",null,28,23,18,16,37,30,24,null,"Drying",1,1,1,1,0,0,0]
[null,null,null,"Storage",5,7,5.8000000000000007,null,null,null,5,7,null,0,0,null,null,null,null,17023081,45,38,48,57,47,null,"DuPage",17043,null,"Floyd",18043,null,"DuPage",17043,null,22,"Storage",null,5,5,5,5,6,6,5,null,"Storage",3,7,7,7,6,6,5]
[null,null,null,"Crop insurance",27,16,22.6,null,null,null,27,16,null,0,0,null,null,null,null,17025041,119,85,149,172,131,null,"Edgar",17045,null,"Fountain",18045,null,"Edgar",17045,null,23,"Crop insurance",null,28,27,26,24,20,20,20,null,"Crop insurance",19,16,16,16,15,15,15]
[null,null,null,"Other direct expenses",0,0,0,null,null,null,0,0,null,0,0,null,null,null,null,17025081,32,25,40,48,36,null,"Edwards",17047,null,"Franklin",18047,null,"Edwards",17047,null,24,"Other direct expenses",null,0,0,0,0,0,0,0,null,"Other direct expenses",0,0,0,0,0,0,0]
[null,null,"Total direct expenses",null,{"$f":"SUM(E28:E34)","v":376},{"$f":"SUM(F28:F34)","v":192},{"$f":"SUM(G28:G34)","v":302.40000000000003},null,null,null,null,null,null,null,null,null,null,null,null,17027041,116,97,158,181,138,null,"Effingham",17049,null,"Fulton",18049,null,"Effingham",17049,null,25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17027081,34,28,39,52,38,null,"Fayette",17051,null,"Gibson",18051,null,"Fayette",17051,null,26]
[null,null,null,"Machine hire/lease",{"$f":"K37","v":11},10,{"$f":"E37*$E$14+F37*$F$14","v":10.6},null,null,null,11,{"$f":"HLOOKUP($E$8,$AV$11:$BB$52,AJ37,FALSE)","v":10},null,{"$f":"IF(E37=K37,0,1)","v":0},{"$f":"IF(F37=L37,0,1)","v":0},null,null,null,null,17029041,152,118,182,210,166,null,"Ford",17053,null,"Grant",18053,null,"Ford",17053,null,27,"Machine hire/lease",null,19,11,13,10,0,0,0,null,"Machine hire/lease",17,10,10,9,0,0,0]
[null,null,null,"Utilities",5,5,5,null,null,null,5,5,null,0,0,null,null,null,null,17029081,46,44,56,60,52,null,"Franklin",17055,null,"Greene",18055,null,"Franklin",17055,null,28,"Utilities",null,5,5,5,6,5,5,5,null,"Utilities",5,5,5,5,5,5,5]
[null,null,null,"Machine repair",25,22,23.8,null,null,null,25,22,null,0,0,null,null,null,null,17031041,123,114,125,143,126,null,"Fulton",17057,null,"Hamilton",18057,null,"Fulton",17057,null,29,"Machine repair",null,31,25,28,33,22,22,22,null,"Machine repair",27,22,22,22,18,18,18]
[null,null,null,"Fuel and oil",20,21,20.399999999999999,null,null,null,20,21,null,0,0,null,null,null,null,17031081,43,46,39,42,43,null,"Gallatin",17059,null,"Hancock",18059,null,"Gallatin",17059,null,30,"Fuel and oil",null,20,20,20,20,19,19,19,null,"Fuel and oil",24,21,21,21,11,11,11]
[null,null,null,"Light Vehicle",2,2,2,null,null,null,2,2,null,0,0,null,null,null,null,17033041,144,101,151,183,145,null,"Greene",17061,null,"Harrison",18061,null,"Greene",17061,null,31,"Light Vehicle",null,2,2,2,2,0,0,0,null,"Light Vehicle",2,2,2,2,0,0,0]
[null,null,null,"Machinery depreciation",69,63,66.599999999999994,null,null,null,69,63,null,0,0,null,null,null,null,17033081,42,29,46,50,42,null,"Grundy",17063,null,"Hendricks",18063,null,"Grundy",17063,null,32,"Machinery depreciation",null,75,69,68,73,48,48,48,null,"Machinery depreciation",68,63,63,63,38,38,38]
[null,null,null,"Other power costs",0,0,0,null,null,null,0,0,null,0,0,null,null,null,null,17035041,147,111,171,194,156,null,"Hamilton",17065,null,"Henry",18065,null,{"$f":"IF($E$79=$AC$4,AA43,AD43)","v":"Hamilton"},{"$f":"IF($AC$4=$E$79,AB43,AE43)","v":17065},null,33,"Other power costs",null,0,0,0,0,0,0,0,null,"Other power costs",0,0,0,0,0,0,0]
[null,null,"Total power expenses",null,{"$f":"SUM(E37:E43)","v":132},{"$f":"SUM(F37:F43)","v":123},{"$f":"SUM(G37:G43)","v":128.39999999999998},null,null,null,null,null,null,null,null,null,null,null,null,17035081,46,43,49,55,48,null,"Hancock",17067,null,"Howard",18067,null,"Hancock",17067,null,34]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17037041,184,159,193,192,182,null,"Hardin",17069,null,"Huntington",18069,null,"Hardin",17069,null,35]
[null,null,null,"Hired labor",{"$f":"K46","v":19},16,{"$f":"E46*$E$14+F46*$F$14","v":17.8},null,null,null,19,{"$f":"HLOOKUP($E$8,$AV$11:$BB$52,AJ46,FALSE)","v":16},null,{"$f":"IF(E46=K46,0,1)","v":0},{"$f":"IF(F46=L46,0,1)","v":0},null,null,null,null,17037081,60,51,58,60,57,null,"Henderson",17071,null,"Jackson",18071,null,"Henderson",17071,null,36,"Hired labor",null,21,19,{"$f":"AN46+1","v":20},21,14,14,14,null,"Hired labor",17,16,16,16,14,14,14]
[null,null,null,"Building repair and rent",8,5,6.8,null,null,null,8,5,null,{"$f":"IF(E47=K47,0,1)","v":0},{"$f":"IF(F47=L47,0,1)","v":0},null,null,null,null,17039041,178,134,197,219,182,null,"Henry",17073,null,"Jasper",18073,null,"Henry",17073,null,37,"Building repair and rent",null,11,8,{"$f":"AN47","v":8},{"$f":"AO47","v":8},5,5,5,null,"Building repair and rent",5,5,5,5,5,5,5]
[null,null,null,"Building depreciation",7,10,8.1999999999999993,null,null,null,7,10,null,0,0,null,null,null,null,17039081,56,55,59,63,58,null,"Iroquois",17075,null,"Jay",18075,null,"Iroquois",17075,null,38,"Building depreciation",null,18,7,{"$f":"AN48","v":7},{"$f":"AO48","v":7},10,10,10,null,"Building depreciation",10,10,10,10,10,10,10]
[null,null,null,"Insurance",10,10,10,null,null,null,10,10,null,0,0,null,null,null,null,17041041,154,118,187,222,170,null,"Jackson",17077,null,"Jefferson",18077,null,"Jackson",17077,null,39,"Insurance",null,13,10,{"$f":"AN49","v":10},10,10,10,10,null,"Insurance",9,10,10,10,10,10,10]
[null,null,null,"Misc.",8,9,8.4,null,null,null,8,9,null,0,0,null,null,null,null,17041081,50,45,51,66,53,null,"Jasper",17079,null,"Jennings",18079,null,"Jasper",17079,null,40,"Misc.",null,8,8,8,8,10,7,5,null,"Misc.",10,9,9,9,10,7,5]
[null,null,null,"Interest",12,10,11.2,null,null,null,12,10,null,0,0,null,null,null,null,17043041,157,165,179,199,175,null,"Jefferson",17081,null,"Johnson",18081,null,"Jefferson",17081,null,41,"Interest",null,18,12,{"$f":"AN51+1","v":13},{"$f":"AO51+1","v":14},12,12,11,null,"Interest",14,10,10,10,7,7,6]
[null,null,null,"Other overhead expenses",0,0,0,null,null,null,0,0,null,0,0,null,null,null,null,17043081,49,66,43,56,54,null,"Jersey",17083,null,"Knox",18083,null,"Jersey",17083,null,42,"Other overhead expenses",null,0,0,0,0,0,0,0,null,"Other overhead expenses",0,0,0,0,0,0,0]
[null,null,"Total overhead expenses",null,{"$f":"SUM(E46:E52)","v":64},{"$f":"SUM(F46:F52)","v":60},{"$f":"SUM(G46:G52)","v":62.399999999999991},null,null,null,null,null,null,null,null,null,null,null,null,17045041,154,118,186,200,165,null,"Jo Daviess",17085,null,"Kosciusko",18085,null,"Jo Daviess",17085,null,43]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17045081,54,39,57,61,53,null,"Johnson",17087,null,"LaGrange",18087,null,"Johnson",17087,null,44]
[null,null,"Total expenses",null,{"$f":"E35+E44+E53","v":572},{"$f":"F35+F44+F53","v":375},{"$f":"G35+G44+G53","v":493.2},null,null,null,null,null,null,null,null,null,null,null,null,17047041,136,86,149,166,134,null,"Kane",17089,null,"Lake",18089,null,"Kane",17089,null,45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17047081,43,35,42,53,43,null,"Kankakee",17091,null,"LaPorte",18091,null,"Kankakee",17091,null,46]
[null,null,"Operator and land return",null,{"$f":"E25-E55","v":229.89999999999998},{"$f":"F25-F55","v":206},220.33999999999997,null,null,null,null,null,null,null,null,null,null,null,null,17049041,153,102,172,187,154,null,"Kendall",17093,null,"Lawrence",18093,null,"Kendall",17093,null,47]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17049081,44,42,45,59,48,null,"Knox",17095,null,"Madison",18095,null,"Knox",17095,null,48]
[null,null,null,"Cash rent",{"$f":"K59","v":286},{"$f":"E59","v":286},{"$f":"F59","v":286},null,null,null,286,{"$f":"K59","v":286},null,{"$f":"IF(E59=K59,0,1)","v":0},{"$f":"IF(F59=L59,0,1)","v":0},null,null,null,null,17051041,133,94,161,178,142,null,"Lake",17097,null,"Marion",18097,null,"Lake",17097,null,49,"Cash rent",null,258,286,236,158,295,235,180]
[null,null,null,"Operator labor and equity",{"$f":"K60","v":40},{"$f":"E60","v":40},{"$f":"F60","v":40},null,null,null,40,null,null,null,null,null,null,null,null,17051081,41,35,43,50,42,null,"LaSalle",17099,null,"Marshall",18099,null,"LaSalle",17099]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17053041,137,118,164,198,154,null,"Lawrence",17101,null,"Martin",18101,null,"Lawrence",17101]
[null,null,"Farmer net return",null,{"$f":"E25-E55-E59-E60","v":-96.100000000000023},{"$f":"F25-F55-F59-F60","v":-120},{"$f":"G25-G55-G59-G60","v":-105.66000000000003},null,null,null,null,null,null,null,null,null,null,null,null,17053081,44,41,48,58,48,null,"Lee",17103,null,"Miami",18103,null,"Lee",17103]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17055041,116,84,163,158,130,null,"Livingston",17105,null,"Monroe",18105,null,"Livingston",17105]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17055081,32,27,41,44,36,null,"Logan",17107,null,"Montgomery",18107,null,"Logan",17107]
[null,null,"Breakeven Cash Rents",null,null,null,"$/acre",null,null,null,null,null,null,null,null,null,null,null,null,17057041,151,120,168,191,158,null,"McDonough",17109,null,"Morgan",18109,null,"McDonough",17109]
[null,null,null,"Cash costs (non-land costs - depreciation)",null,null,{"$f":"G25-G55+G42+G48","v":295.13999999999993},null,null,null,null,null,null,null,null,null,null,null,null,17057081,50,45,50,53,50,null,"McHenry",17111,null,"Newton",18111,null,"McHenry",17111]
[null,null,null,"Non-land costs",null,null,{"$f":"G66-G42-G48","v":220.33999999999995},null,null,null,null,null,null,null,null,null,null,null,null,17059041,144,102,188,187,155,null,"McLean",17113,null,"Noble",18113,null,"McLean",17113]
[null,null,null,"Non-land costs plus operator labor and equity",null,null,{"$f":"G67-G60","v":180.33999999999995},null,null,null,null,null,null,null,null,null,null,null,null,17059081,41,35,46,50,43,null,"Macon",17115,null,"Ohio",18115,null,"Macon",17115]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17061041,158,113,166,197,159,null,"Macoupin",17117,null,"Orange",18117,null,"Macoupin",17117]
[null,null,"Breakeven Prices",null,"$/bushel","$/bushel",null,null,null,null,null,null,null,null,null,null,null,null,null,17061081,47,49,48,53,49,null,"Madison",17119,null,"Owen",18119,null,"Madison",17119]
[null,null,null,"Cash non-land costs",{"$f":"(E25-E42-E48)/E15","v":3.6661616161616162},{"$f":"(F25-F42-F48)/F15","v":8.9122807017543852},null,null,null,null,null,null,null,null,null,null,null,null,null,17063041,155,119,192,204,168,null,"Marion",17121,null,"Parke",18121,null,"Marion",17121]
[null,null,null,"Cash non-land + cash rent",{"$f":"(E55+E59-E48-E42)/E15","v":3.9494949494949494},{"$f":"(F55+F59-F48-F42)/F15","v":10.315789473684211}]
[null,null,null,"Non-land costs + cash rent",{"$f":"(E55+E59-SUM(E22:E24))/E15","v":4.333333333333333},{"$f":"(F55+F59-SUM(F22:F24))/F15","v":11.403508771929825},null,null,null,null,null,null,null,null,null,null,null,null,null,17063081,50,44,56,58,52,null,"Marshall",17123,null,"Perry",18123,null,{"$f":"IF($E$79=$AC$4,AA73,AD73)","v":"Marshall"},{"$f":"IF($AC$4=$E$79,AB73,AE73)","v":17123}]
[null,null,null,"All costs included",{"$f":"(E55+E59+E60)/E15","v":4.5353535353535355},{"$f":"(F55+F59+F60)/F15","v":12.298245614035087},null,null,null,null,null,null,null,null,null,null,null,null,null,17065041,120,88,166,197,143,null,"Mason",17125,null,"Pike",18125,null,"Mason",17125]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17065081,32,28,40,46,37,null,"Massac",17127,null,"Porter",18127,null,"Massac",17127]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,"ARC",17067041,134,133,177,217,165,null,"Menard",17129,null,"Posey",18129,null,"Menard",17129]
[null,null,"Insurance and Program Input for 2016",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.55000000000000004,"PLC",17067081,45,48,47,52,48,null,"Mercer",17131,null,"Pulaski",18131,null,"Mercer",17131]
[null,null,"Click \"Use Defaults to Bring in Defaults for State/County Choice",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.6,null,17069041,109,84,148,176,129,null,"Monroe",17133,null,"Putnam",18133,null,"Monroe",17133]
[null,null,null,"State","Illinois",null,null,null,null,null,null,null,null,null,null,null,null,0.65,null,17069081,26,29,34,38,32,null,"Montgomery",17135,null,"Randolph",18135,null,"Montgomery",17135]
[null,null,null,"County","McLean",null,null,null,null,null,null,null,null,null,null,null,null,0.7,null,17071041,159,162,174,206,175,null,"Morgan",17137,null,"Ripley",18137,null,"Morgan",17137]
[null,{"$f":"IF(M81=0,\"\",\"Input differs from defaults.  Hit 'Use Defaults' to use default entries.\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M84:N104)","v":0},null,null,null,null,0.75,null,17071081,55,55,50,52,53,null,"Moultrie",17139,null,"Rush",18139,null,"Moultrie",17139]
[null,null,null,null,{"$f":"E11","v":"Corn"},{"$f":"F11","v":"Soybeans"},null,null,null,null,null,null,null,null,null,null,null,0.8,null,17073041,174,139,184,192,172,null,"Ogle",17141,null,"St. Joseph",18141,null,"Ogle",17141]
[null,null,"Crop Insurance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.85,null,17073081,60,51,54,57,56,null,"Peoria",17143,null,"Scott",18143,null,"Peoria",17143]
[null,null,null,"RP coverage level",{"$f":"K84","v":0.85},0.85,null,null,null,null,0.85,0.85,{"$f":"IF(E84=K84,0,1)","v":0},0,null,null,null,null,null,17075041,155,120,174,184,158,null,"Perry",17145,null,"Shelby",18145,null,"Perry",17145]
[null,null,null,"TA-APH yield",183,59,null,null,null,null,{"$f":"ROUND(Z3,)","v":183},{"$f":"ROUND(Z4,)","v":59},0,0,null,null,null,null,null,17075081,45,45,48,57,49,null,"Piatt",17147,null,"Spencer",18147,null,"Piatt",17147]
[null,null,null,"Projected price",4.3499999999999996,10.3,null,null,null,null,4.3499999999999996,{"$f":"AV16","v":10.3},0,0,null,null,null,null,null,17077041,118,95,171,167,138,null,"Pike",17149,null,"Starke",18149,null,"Pike",17149]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17077081,33,30,39,46,37,null,"Pope",17151,null,"Steuben",18151,null,"Pope",17151]
[null,null,"Program on farm",null,{"$f":"K88","v":"ARC"},{"$f":"L88","v":"ARC"},null,null,null,null,"ARC","ARC",{"$f":"IF(E88=K88,0,1)","v":0},{"$f":"IF(F88=L88,0,1)","v":0},null,null,null,null,null,17079041,146,100,146,184,144,null,"Pulaski",17153,null,"Sullivan",18153,null,"Pulaski",17153]
[null,null,"Program yield (only for PLC)",null,{"$f":"K89","v":147},{"$f":"L89","v":48},null,null,null,null,{"$f":"ROUND(AVERAGE(U3:Y3)*0.85,)","v":147},{"$f":"ROUND(AVERAGE(U4:Y4)*0.85,)","v":48},{"$f":"IF(E89=K89,0,1)","v":0},{"$f":"IF(F89=L89,0,1)","v":0},null,null,null,null,null,17079081,42,39,40,55,44,null,"Putnam",17155,null,"Switzerland",18155,null,"Putnam",17155]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17081041,110,80,151,162,126,null,"Randolph",17157,null,"Tippecanoe",18157,null,"Randolph",17157]
[null,null,"County Yields                              2011",null,{"$f":"K91","v":160},56,null,null,null,null,{"$f":"TRANSPOSE(U3:Y3)","v":160},{"$f":"TRANSPOSE(U4:Y4)","v":56},{"$f":"IF(E91=K91,0,1)","v":0},{"$f":"IF(F91=L91,0,1)","v":0},null,null,null,null,null,17081081,29,25,38,45,34,null,"Richland",17159,null,"Tipton",18159,null,"Richland",17159]
[null,null,null,"2012  ",125,52,null,null,null,null,125,52,{"$f":"IF(E92=K92,0,1)","v":0},{"$f":"IF(F92=L92,0,1)","v":0},null,null,null,null,null,17083041,149,113,182,198,161,null,"Rock Island",17161,null,"Union",18161,null,"Rock Island",17161]
[null,null,null,"2013  ",189,56,null,null,null,null,189,56,0,0,null,null,null,null,null,17083081,47,44,51,51,48,null,"St. Clair",17163,null,"Vanderburgh",18163,null,"St. Clair",17163]
[null,null,null,"2014  ",217,63,null,null,null,null,217,63,0,0,null,null,null,null,null,17085041,171,113,170,176,158,null,"Saline",17165,null,"Vermillion",18165,null,"Saline",17165]
[null,null,null,"2015  ",173,57,null,null,null,null,173,57,0,0,null,null,null,null,null,17085081,61,35,49,55,50,null,"Sangamon",17167,null,"Vigo",18167,null,"Sangamon",17167]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17087041,127,82,154,141,126,null,"Schuyler",17169,null,"Wabash",18169,null,"Schuyler",17169]
[null,null,"Market Year Average Prices     2011",null,{"$f":"K97","v":6.22},12.5,null,null,null,null,6.22,12.5,{"$f":"IF(E97=K97,0,1)","v":0},{"$f":"IF(F97=L97,0,1)","v":0},null,null,null,null,null,17087081,37,28,45,40,38,null,"Scott",17171,null,"Warren",18171,null,"Scott",17171]
[null,null,null,"2012  ",6.89,14.4,null,null,null,null,6.89,14.4,0,0,null,null,null,null,null,17089041,175,140,191,182,172,null,"Shelby",17173,null,"Warrick",18173,null,"Shelby",17173]
[null,null,null,"2013  ",4.46,13,null,null,null,null,4.46,13,0,0,null,null,null,null,null,17089081,57,46,56,57,54,null,"Stark",17175,null,"Washington",18175,null,"Stark",17175]
[null,null,null,"2014  ",3.65,10.050000000000001,null,null,null,null,3.65,10.050000000000001,0,0,null,null,null,null,null,17091041,153,119,172,171,154,null,"Stephenson",17177,null,"Wayne",18177,null,"Stephenson",17177]
[null,null,null,"2015  ",3.9,9.75,null,null,null,null,3.9,9.75,0,0,null,null,null,null,null,17091081,48,44,46,53,48,null,"Tazewell",17179,null,"Wells",18179,null,"Tazewell",17179]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17093041,165,111,182,173,158,null,"Union",17181,null,"White",18181,null,"Union",17181]
[null,null,"Program acres",null,{"$f":"K103","v":0.6},{"$f":"L103","v":0.4},null,null,null,null,{"$f":"E14","v":0.6},{"$f":"1-K103","v":0.4},{"$f":"IF(E103=K103,0,1)","v":0},{"$f":"IF(F103=L103,0,1)","v":0},null,null,null,null,null,17093081,54,43,51,59,52,null,"Vermilion",17183,null,"Whitley",18183,null,"Vermilion",17183]
[null,null,"Farm yield minus county yield",null,{"$f":"K104","v":-5},{"$f":"L104","v":-3},null,null,null,null,-5,-3,0,0,null,null,null,null,null,17095041,169,160,190,199,180,null,"Wabash",17185,null,null,null,null,"Wabash",17185]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17095081,62,56,55,57,58,null,"Warren",17187,null,null,null,null,"Warren",17187]
[null,null,"ARC Benchmark Yield",null,{"$f":"ROUND((SUM(E91:E95)-MAX(E91:E95)-MIN(E91:E95))/3,1)","v":174},{"$f":"ROUND((SUM(F91:F95)-MAX(F91:F95)-MIN(F91:F95))/3,1)","v":56.3},null,null,null,null,null,null,null,null,null,null,null,null,null,17097041,151,114,153,124,136,null,"Washington",17189,null,null,null,null,"Washington",17189]
[null,null,"ARC Benchmark Price",null,{"$f":"(SUM(E97:E101)-MAX(E97:E101)-MIN(E97:E101))/3","v":4.8599999999999985},{"$f":"(SUM(F97:F101)-MAX(F97:F101)-MIN(F97:F101))/3","v":11.850000000000001},null,null,null,null,null,null,null,null,null,null,null,null,null,17097081,45,40,44,45,44,null,"Wayne",17191,null,null,null,null,"Wayne",17191]
[null,null,"ARC Guarantee",null,{"$f":"E106*E107*0.86","v":727.25039999999979},{"$f":"F106*F107*0.86","v":573.75330000000008},null,null,null,null,null,null,null,null,null,null,null,null,null,17099041,177,134,187,194,173,null,"White",17193,null,null,null,null,"White",17193]
[null,null,"2015 ARC Payment",null,{"$f":"0.85*MIN(MAX(0,E108-E18*(E15+E104)),E106*E107*0.1)","v":0},{"$f":"0.85*MIN(MAX(0,F108-F18*(F15+F104)),F106*F107*0.1)","v":28.69030500000007},null,null,null,null,null,null,null,null,null,null,null,null,null,17099081,59,49,54,60,56,null,"Whiteside",17195,null,null,null,null,"Whiteside",17195]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17101041,142,92,147,176,139,null,"Will",17197,null,null,null,null,"Will",17197]
[null,null,"PLC payment ",null,{"$f":"0.85*MAX(0,3.75-E18)*E89","v":0},{"$f":"0.85*MAX(0,8.4-F18)*F89","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,17101081,45,34,41,45,41,null,"Williamson",17199,null,null,null,null,"Williamson",17199]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17103041,171,142,171,180,166,null,"Winnebago",17201,null,null,null,null,"Winnebago",17201]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17103081,59,52,53,59,56,null,"Woodford",17203,null,null,null,null,"Woodford",17203]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17105041,156,118,179,210,166]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17105081,52,41,55,59,52]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17107041,173,125,198,229,181]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17107081,55,47,56,64,56]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17109041,167,138,187,209,175]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17109081,58,50,53,54,54]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17111041,176,121,159,179,159]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17111081,51,42,49,56,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17113041,160,125,189,217,173]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17113081,56,52,56,63,57]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17115041,153,125,193,234,176]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17115081,47,44,55,67,53]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17117041,130,111,168,197,152]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17117081,40,46,48,58,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17119041,118,104,164,189,144]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17119081,35,36,42,53,42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17121041,138,88,159,182,142]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17121081,38,27,41,51,39]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17123041,178,124,191,205,175]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17123081,56,45,53,60,54]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17125041,164,111,179,194,162]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17125081,46,30,43,53,43]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17127041,129,79,170,163,135]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17127081,39,31,49,45,41]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17129041,169,117,197,221,176]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17129081,51,41,54,60,52]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17131041,162,180,176,192,178]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17131081,53,56,47,57,53]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17133041,115,97,145,180,134]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17133081,34,39,33,46,38]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17135041,138,113,182,203,159]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17135081,44,42,49,57,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17137041,157,127,191,221,174]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17137081,50,46,55,59,53]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17139041,156,121,181,222,170]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17139081,48,45,56,64,53]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17141041,179,141,189,192,175]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17141081,60,50,53,60,56]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17143041,168,160,178,206,178]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17143081,58,54,50,57,55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17145041,114,77,135,142,117]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17145081,33,24,33,41,33]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17147041,157,130,187,233,177]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17147081,53,51,57,69,58]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17149041,151,111,164,198,156]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17149081,44,44,44,50,46]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17151041,125,82,169,158,134]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17151081,37,35,44,50,42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17153041,137,97,170,177,145]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17153081,40,37,44,46,42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17155041,176,134,187,191,172]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17155081,58,53,55,59,56]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17157041,109,86,147,178,130]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17157081,36,34,38,45,38]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17159041,127,85,145,175,133]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17159081,35,26,36,52,37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17161041,176,159,182,184,175]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17161081,59,50,45,54,52]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17163041,128,100,158,171,139]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17163081,36,31,39,49,39]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17165041,132,92,171,174,142]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17165081,37,29,46,46,40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17167041,165,131,198,225,180]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17167081,56,49,56,63,56]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17169041,144,115,168,202,157]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17169081,45,37,49,52,46]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17171041,145,119,168,200,158]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17171081,44,43,52,54,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17173041,146,114,177,204,160]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17173081,44,46,48,56,49]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17175041,181,148,190,205,181]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17175081,59,51,56,58,56]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17177041,181,113,179,187,165]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17177081,59,43,54,57,53]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17179041,173,133,176,221,176]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17179081,57,51,53,61,56]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17181041,108,102,162,183,139]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17181081,36,29,45,52,41]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17183041,148,119,177,202,162]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17183081,45,46,53,62,52]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17185041,138,96,158,178,143]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17185081,45,41,45,52,46]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17187041,177,164,186,214,185]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17187081,59,57,54,58,57]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17189041,117,90,158,176,135]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17189081,31,25,36,48,35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17191041,113,85,143,183,131]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17191081,34,27,40,51,38]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17193041,139,93,179,195,152]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17193081,41,37,42,50,43]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17195041,163,139,179,183,166]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17195081,54,53,49,59,54]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17197041,162,126,149,176,153]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17197081,51,44,46,56,49]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17199041,124,83,173,160,135]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17199081,31,28,42,42,36]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17201041,162,106,172,187,157]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17201081,52,39,52,53,49]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17203041,187,123,192,216,180]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17203081,60,46,56,61,56]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18001041,146,110,176,172,151]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18001081,48,59,51,60,55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18003041,131,108,181,184,151]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18003081,44,53,51,54,51]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18005041,120,102,176,197,149]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18005081,40,37,50,59,47]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18007041,164,119,179,198,165]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18007081,50,47,51,62,53]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18009041,161,119,173,157,153]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18009081,48,57,52,47,51]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18011041,159,120,190,200,167]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18011081,52,40,55,61,52]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18013041,127,95,157,142,130]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18013081,40,41,46,51,45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18015041,167,120,197,204,172]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18015081,56,43,61,64,56]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18017041,149,115,191,188,161]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18017081,52,48,58,56,54]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18019041,116,94,161,170,135]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18019081,33,35,52,54,44]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18021041,141,106,154,197,150]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18021081,42,34,45,55,44]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18023041,176,148,192,213,182]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18023081,56,55,57,65,58]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18025041,110,78,147,188,131]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18025081,27,32,37,42,35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18027041,156,108,182,203,162]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18027081,44,32,48,54,45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18029041,109,88,145,160,126]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18029081,38,38,43,49,42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18031041,121,109,183,202,154]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18031081,44,46,56,64,53]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18033041,123,97,164,158,136]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18033081,40,44,41,47,43]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18035041,146,111,174,172,151]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18035081,49,52,52,55,52]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18037041,153,105,181,184,156]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18037081,46,38,55,55,49]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18039041,146,94,148,140,132]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18039081,47,50,44,53,49]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18041041,132,106,172,185,149]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18041081,45,39,49,59,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18043041,99,92,168,147,127]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18043081,30,34,48,46,40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18045041,154,116,182,203,164]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18045081,46,40,54,62,51]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18047041,125,102,179,188,149]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18047081,45,41,52,56,49]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18049041,155,126,178,172,158]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18049081,44,41,49,51,46]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18051041,157,109,177,193,159]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18051081,47,34,48,54,46]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18053041,140,122,181,185,157]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18053081,44,54,54,56,52]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18055041,131,99,141,184,139]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18055081,43,35,37,52,42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18057041,125,122,173,196,154]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18057081,52,54,50,60,54]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18059041,147,109,173,188,154]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18059081,45,44,51,59,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18061041,105,88,168,175,134]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18061081,28,32,47,52,40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18063041,130,113,184,198,156]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18063081,40,36,53,61,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18065041,150,110,193,186,160]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18065081,50,45,54,57,52]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18067041,164,154,198,200,179]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18067081,53,59,58,61,58]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18069041,136,106,192,179,153]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18069081,44,51,54,54,51]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18071041,120,91,149,167,132]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18071081,41,45,45,51,46]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18073041,157,141,172,166,159]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18073081,47,50,52,53,51]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18075041,153,104,167,165,147]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18075081,48,51,50,55,51]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18077041,114,88,145,184,133]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18077081,41,37,42,48,42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18079041,116,97,156,184,138]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18079081,39,39,47,51,44]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18081041,108,105,173,184,143]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18081081,36,40,51,60,47]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18083041,154,106,179,193,158]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18083081,46,35,46,54,45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18085041,151,107,177,166,150]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18085081,45,48,52,51,49]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18087041,134,93,164,124,129]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18087081,42,42,45,45,44]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18089041,154,159,155,166,159]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18089081,46,48,39,50,46]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18091041,160,128,182,163,158]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18091081,47,51,51,52,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18093041,124,91,154,179,137]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18093081,38,33,40,55,42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18095041,156,120,181,195,163]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18095081,54,49,53,60,54]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18097041,112,99,172,176,140]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18097081,37,34,49,55,44]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18099041,158,104,170,173,151]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18099081,45,49,50,53,49]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18101041,138,106,180,183,152]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18101081,40,31,50,52,43]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18103041,137,126,175,171,152]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18103081,47,47,52,54,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18105041,125,97,184,175,145]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18105081,37,32,47,51,42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18107041,167,120,196,205,172]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18107081,55,40,58,63,54]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18109041,113,101,180,195,147]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18109081,37,32,50,61,45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18111041,166,125,162,179,158]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18111081,49,50,48,56,51]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18113041,131,104,164,158,139]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18113081,41,44,44,48,44]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18115041,96,95,171,177,135]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18115081,30,28,56,53,42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18117041,131,103,181,195,153]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18117081,36,32,53,57,45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18119041,120,94,148,153,129]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18119081,35,29,44,47,39]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18121041,147,104,169,182,151]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18121081,42,32,54,58,47]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18123041,130,92,170,166,140]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18123081,31,40,41,51,41]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18125041,139,97,169,170,144]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18125081,43,37,46,49,44]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18127041,153,166,178,175,168]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18127081,48,55,48,53,51]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18129041,153,102,193,197,161]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18129081,43,40,50,58,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18131041,153,110,163,154,145]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18131081,42,40,42,48,43]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18133041,142,113,182,197,159]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18133081,43,34,52,58,47]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18135041,143,104,171,176,149]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18135081,47,47,51,56,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18137041,112,100,170,176,140]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18137081,39,43,46,49,44]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18139041,141,112,193,194,160]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18139081,49,41,54,60,51]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18141041,153,133,158,158,151]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18141081,46,54,48,49,49]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18143041,121,108,164,189,146]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18143081,43,48,51,56,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18145041,116,104,179,187,147]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18145081,41,37,54,62,49]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18147041,133,99,185,172,147]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18147081,38,43,51,51,46]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18149041,137,100,162,155,139]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18149081,37,40,45,43,41]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18151041,120,92,176,151,135]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18151081,44,37,40,44,41]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18153041,155,106,157,195,153]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18153081,45,34,47,55,45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18155041,112,95,161,150,130]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18155081,39,28,49,51,42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18157041,160,117,185,206,167]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18157081,49,40,55,62,52]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18159041,165,158,191,212,182]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18159081,56,61,57,63,59]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18161041,141,118,212,197,167]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18161081,46,45,58,59,52]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18163041,149,104,180,187,155]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18163081,43,37,52,55,47]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18165041,152,107,184,213,164]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18165081,46,37,56,61,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18167041,139,97,160,166,141]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18167081,44,30,49,51,44]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18169041,143,104,179,179,151]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18169081,43,46,50,50,47]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18171041,159,117,183,209,167]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18171081,50,47,53,62,53]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18173041,139,97,183,174,148]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18173081,41,41,51,54,47]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18175041,122,92,145,175,134]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18175081,37,34,41,55,42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18177041,118,106,177,182,146]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18177081,39,41,51,57,47]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18179041,147,120,200,186,163]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18179081,46,53,56,57,53]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18181041,168,118,184,193,166]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18181081,50,43,52,57,51]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18183041,114,109,181,180,146]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18183081,36,52,53,54,49]

{"sheet":"longRun","index":1,"n_rows":182,"n_cols":19,"rows_kept":182,"cut":false,"hidden":false,"merged":[[25,3,25,4],[43,3,43,4],[54,5,54,9],[35,5,35,9],[66,5,66,9],[17,5,17,9],[27,5,27,6],[45,5,45,6],[62,5,62,9]]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Corn %",{"$f":"budgets!E14/SUM(budgets!E14:F14)","v":0.6}]
[null,null,"Input -- Prices and Yields for Next Five Years",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bean %",{"$f":"1-S5","v":0.4}]
[]
[null,null,null,"Yields for 2016 through 2020"]
[]
[null,null,null,null,"Bu Increase"]
[null,null,null,null,"per Year",2016,2017,2018,2019,2020]
[null,null,null,"Corn",2,{"$f":"budgets!E15","v":198},{"$f":"F12+$E$12","v":200},{"$f":"G12+$E$12","v":202},{"$f":"H12+$E$12","v":204},{"$f":"I12+$E$12","v":206}]
[null,null,null,"Soybeans",0.5,{"$f":"budgets!F15","v":57},{"$f":"F13+$E$13","v":57.5},{"$f":"G13+$E$13","v":58},58.5,59]
[]
[]
[null,null,null,"Corn Price Scenarios"]
[]
[null,null,null,null,null,"Year"]
[null,null,null,"Price Scenario",null,2016,2017,{"$f":"G19+1","v":2018},{"$f":"H19+1","v":2019},{"$f":"I19+1","v":2020}]
[]
[]
[null,null,null,"FAPRI",null,3.97,4.0199999999999996,4.1500000000000004,4.2,4.2]
[null,null,null,"Long-run",null,4.5999999999999996,{"$f":"F23","v":4.5999999999999996},{"$f":"G23","v":4.5999999999999996},{"$f":"H23","v":4.5999999999999996},{"$f":"I23","v":4.5999999999999996}]
[null,null,null,"Low",null,3.5,3.5,3.5,3.5,3.5]
[null,null,null,"High",null,4.8,4.8,4.8,4.8,4.8]
[null,null,null,"User-defined",null,4.2,4.2,4.2,4.2,4.2]
[]
[null,null,null,"Price scenario ",null,"User-defined",null,"  << this scenario will be used in analysis"]
[]
[null,null,null,"Price per bushel",null,{"$f":"VLOOKUP($F$28,$D$22:$J$26,3,FALSE)","v":4.2},{"$f":"VLOOKUP($F$28,$D$22:$J$26,4,FALSE)","v":4.2},{"$f":"VLOOKUP($F$28,$D$22:$J$26,5,FALSE)","v":4.2},{"$f":"VLOOKUP($F$28,$D$22:$J$26,6,FALSE)","v":4.2},{"$f":"VLOOKUP($F$28,$D$22:$J$26,7,FALSE)","v":4.2}]
[null,null,null,"Revenue per acre",null,{"$f":"F12*F30","v":831.6},{"$f":"G12*G30","v":840},848.40000000000009,856.80000000000007,865.2]
[]
[]
[null,null,null,"Soybean Price Scenarios"]
[]
[null,null,null,null,null,"Year"]
[null,null,null,"Price Scenario",null,2016,2017,{"$f":"G37+1","v":2018},{"$f":"H37+1","v":2019},{"$f":"I37+1","v":2020}]
[]
[]
[null,null,null,{"$f":"D22","v":"FAPRI"},null,9.58,10,10.36,10.5,10.5]
[null,null,null,"Long-run",null,10.5,{"$f":"F41","v":10.5},{"$f":"G41","v":10.5},{"$f":"H41","v":10.5},{"$f":"I41","v":10.5}]
[null,null,null,"Low",null,9,9,9,9,9]
[null,null,null,"High",null,10.8,10.8,10.8,10.8,10.8]
[null,null,null,"User-defined",null,{"$f":"budgets!F18","v":10},{"$f":"F44","v":10},{"$f":"G44","v":10},10,10]
[]
[null,null,null,"Price scenario ",null,"User-defined",null,"  << this scenario will be used in analysis"]
[]
[null,null,null,"Price per bushel",null,{"$f":"VLOOKUP($F$46,$D$40:$J$44,3,FALSE)","v":10},{"$f":"VLOOKUP($F$46,$D$40:$J$44,4,FALSE)","v":10},{"$f":"VLOOKUP($F$46,$D$40:$J$44,5,FALSE)","v":10},{"$f":"VLOOKUP($F$46,$D$40:$J$44,6,FALSE)","v":10},{"$f":"VLOOKUP($F$46,$D$40:$J$44,7,FALSE)","v":10}]
[null,null,null,"Revenue per acre",null,{"$f":"F48*F13","v":570},{"$f":"G48*G13","v":575},580,585,590]
[]
[]
[null,null,"Costs Changes"]
[]
[null,null,null,null,"Change",2016,2017,{"$f":"G54+1","v":2018},{"$f":"H54+1","v":2019},{"$f":"I54+1","v":2020}]
[null,null,null,null,"Per Year","Costs per acre"]
[null,null,null,"Corn",0,{"$f":"budgets!E55","v":572},{"$f":"F56*(1+$E$56)","v":572},{"$f":"G56*(1+$E$56)","v":572},{"$f":"H56*(1+$E$56)","v":572},{"$f":"I56*(1+$E$56)","v":572}]
[null,null,null,"Soybean",0,{"$f":"budgets!F55","v":375},{"$f":"F57*(1+$E$57)","v":375},{"$f":"G57*(1+$E$57)","v":375},375,375]
[]
[]
[]
[null,null,"Projected Cash Flow Over the Next Five Years"]
[]
[null,null,null,null,null,"Year"]
[null,null,null,null,null,{"$f":"F54","v":2016},{"$f":"G54","v":2017},2018,2019,2020]
[]
[]
[null,null,null,null,null,"$ per acre"]
[null,null,"Crop revenue",null,null,{"$f":"ROUND(F31*$S$5+$F49*$S$6,)","v":727},{"$f":"ROUND(G31*$S$5+$F49*$S$6,)","v":732},{"$f":"ROUND(H31*$S$5+$F49*$S$6,)","v":737},{"$f":"ROUND(I31*$S$5+$F49*$S$6,)","v":742},{"$f":"ROUND(J31*$S$5+$F49*$S$6,)","v":747}]
[null,null,"Other revenue",null,null,{"$f":"budgets!$G$22","v":0},{"$f":"budgets!$G$22","v":0},{"$f":"budgets!$G$22","v":0},{"$f":"budgets!$G$22","v":0},{"$f":"budgets!$G$22","v":0}]
[null,null,"ARC/PLC payment",null,null,{"$f":"ROUND(F161,0)","v":11},{"$f":"ROUND(G161,0)","v":0},0,0,0]
[null,null,"Crop insurance",null,null,{"$f":"ROUND(F182,)","v":0},{"$f":"ROUND(G182,)","v":0},0,0,0]
[null,"  Total revenue",null,null,null,{"$f":"SUM(F68:F71)","v":738},{"$f":"SUM(G68:G71)","v":732},737,742,747]
[]
[null,"  Total expenses",null,null,null,{"$f":"ROUND(F56*$S$5+$S$6*F57,)","v":493},{"$f":"ROUND(G56*$S$5+$S$6*G57,)","v":493},{"$f":"ROUND(H56*$S$5+$S$6*H57,)","v":493},{"$f":"ROUND(I56*$S$5+$S$6*I57,)","v":493},{"$f":"ROUND(J56*$S$5+$S$6*J57,)","v":493}]
[]
[null,"  Operator and land return",null,null,null,{"$f":"F72-F74","v":245},{"$f":"G72-G74","v":239},244,249,254]
[]
[null,null,"Cash rent",null,null,{"$f":"N78","v":286},{"$f":"N78","v":286},{"$f":"N78","v":286},{"$f":"N78","v":286},{"$f":"N78","v":286},null,null,null,{"$f":"budgets!E59","v":286}]
[]
[null,"  Farmer net income",null,null,null,{"$f":"F76-F78","v":-41},{"$f":"G76-G78","v":-47},-42,-37,-32]
[]
[null,null,"Operator labor, equity",null,null,{"$f":"N82","v":40},{"$f":"N82","v":40},{"$f":"N82","v":40},{"$f":"N82","v":40},{"$f":"N82","v":40},null,null,null,{"$f":"budgets!E60","v":40}]
[]
[null,"  Farmer net return",null,null,null,{"$f":"F80-F82","v":-81},{"$f":"G80-G82","v":-87},-82,-77,-72]
[]
[]
[null,"  Break-even rents"]
[null,null,"Cash costs (no depreciation)",null,null,{"$f":"F72-F74+SUM(F112:F113)","v":319.8},{"$f":"G72-G74+SUM(G112:G113)","v":313.8},{"$f":"H72-H74+SUM(H112:H113)","v":318.8},{"$f":"I72-I74+SUM(I112:I113)","v":323.8},{"$f":"J72-J74+SUM(J112:J113)","v":328.8}]
[null,null,"Non-land costs",null,null,{"$f":"(F72-F74)","v":245},{"$f":"(G72-G74)","v":239},244,249,254]
[null,null,"All costs included",null,null,{"$f":"(F72-F74-F82)","v":205},{"$f":"(G72-G74-G82)","v":199},204,209,214]
[]
[]
[null,"   Working capital analysis"]
[null,null,null,"Beginning","$/acre"]
[null,null,null,"working cap.",500]
[null,null,"Full Loaded Costs Less Depr and Op Labor ",null,null,{"$f":"F72-F74-F78+SUM(F112:F113)+E95","v":533.79999999999995},{"$f":"G72-G74-G78+SUM(G112:G113)+F96","v":561.59999999999991},{"$f":"H72-H74-H78+SUM(H112:H113)+G96","v":594.39999999999986},{"$f":"I72-I74-I78+SUM(I112:I113)+H96","v":632.19999999999982},{"$f":"J72-J74-J78+SUM(J112:J113)+I96","v":674.99999999999977}]
[null,null,"Full Loaded Costs Less Depreciation ",null,null,{"$f":"F72-F74-F78-F82+SUM(F112:F113)+E95","v":493.8},{"$f":"G72-G74-G78-G82+SUM(G112:G113)+F97","v":481.6},{"$f":"H72-H74-H78-H82+SUM(H112:H113)+G97","v":474.40000000000003},{"$f":"I72-I74-I78-I82+SUM(I112:I113)+H97","v":472.20000000000005},{"$f":"J72-J74-J78-J82+SUM(J112:J113)+I97","v":475.00000000000006}]
[null,null,"Full Loaded Cost Less Operator Labor",null,null,{"$f":"F72-F74-F78+E95","v":459},{"$f":"G72-G74-G78+F98","v":412},{"$f":"H72-H74-H78+G98","v":370},333,301]
[null,null,"All Costs Included",null,null,{"$f":"F72-F74-F78-F82+E95","v":419},{"$f":"G72-G74-G78-G82+F99","v":332},{"$f":"H72-H74-H78-H82+G99","v":250},173,101]
[]
[null,"  Working capital to total expenses"]
[null,null,"All Costs Included",null,null,{"$f":"F99/(F74+F78)","v":0.53786906290115533},{"$f":"G99/(G74+G78)","v":0.42618741976893454},0.3209242618741977,0.22207958921694479,0.12965340179717585]
[]
[]
[]
[null,"  Rent analysis"]
[null,null,null,"Market cash rent",null,{"$f":"F78","v":286},{"$f":"G78","v":286},{"$f":"H78","v":286},{"$f":"I78","v":286},{"$f":"J78","v":286}]
[null,null,null,"Equitable cash rent",null,{"$f":"F90","v":205},{"$f":"G90","v":199},{"$f":"H90","v":204},{"$f":"I90","v":209},{"$f":"J90","v":214}]
[null,null,null,"Premium",null,{"$f":"F107-F108","v":81},{"$f":"G107-G108","v":87},{"$f":"H107-H108","v":82},77,72]
[]
[]
[null,null,null,null,null,{"$f":"(budgets!E42+budgets!E48)*budgets!$E$14","v":45.6},{"$f":"F112*(1+$E$56)","v":45.6},{"$f":"G112*(1+$E$56)","v":45.6},45.6,45.6]
[null,null,null,null,null,{"$f":"(budgets!$F$48+budgets!$F$42)*budgets!$F$14","v":29.200000000000003},{"$f":"F113*(1+$E$57)","v":29.200000000000003},{"$f":"G113*(1+$E$57)","v":29.200000000000003},29.200000000000003,29.200000000000003]
[null,"Corn ARC payment calc"]
[null,"Corn",null,null,"Year 1",{"$f":"budgets!E91","v":160},{"$f":"F116","v":125},{"$f":"G116","v":189},{"$f":"H116","v":217},{"$f":"I116","v":173}]
[null,"Yields",null,null,"Year 2",{"$f":"budgets!E92","v":125},{"$f":"F117","v":189},217,173,193]
[null,null,null,null,"Year 3",{"$f":"budgets!E93","v":189},217,173,193,195]
[null,null,null,null,"Year 4",{"$f":"budgets!E94","v":217},173,193,195,197]
[null,null,null,null,"Year 5",{"$f":"budgets!E95","v":173},{"$f":"F12+budgets!$E$104","v":193},{"$f":"G12+budgets!$E$104","v":195},{"$f":"H12+budgets!$E$104","v":197},{"$f":"I12+budgets!$E$104","v":199}]
[]
[]
[null,"Corn ",null,null,"Year 1",{"$f":"budgets!E97","v":6.22},{"$f":"F123","v":6.89},{"$f":"G123","v":4.46},3.65,3.9]
[null,"Prices",null,null,"Year 2",{"$f":"budgets!E98","v":6.89},{"$f":"F124","v":4.46},3.65,3.9,4.2]
[null,null,null,null,"Year 3",{"$f":"budgets!E99","v":4.46},3.65,3.9,4.2,4.2]
[null,null,null,null,"Year 4",{"$f":"budgets!E100","v":3.65},3.9,4.2,4.2,4.2]
[null,null,null,null,"Year 5",{"$f":"budgets!E101","v":3.9},{"$f":"F30","v":4.2},{"$f":"G30","v":4.2},{"$f":"H30","v":4.2},{"$f":"I30","v":4.2}]
[]
[]
[null,"Bench yield",null,null,null,{"$f":"ROUND((SUM(F115:F119)-MIN(F115:F119)-MAX(F115:F119))/3,1)","v":174},{"$f":"ROUND((SUM(G115:G119)-MIN(G115:G119)-MAX(G115:G119))/3,1)","v":185},192.3,195,195]
[null,"Bench price",null,null,null,{"$f":"ROUND((SUM(F122:F126)-MAX(F122:F126)-MIN(F122:F126))/3,2)","v":4.8600000000000003},{"$f":"ROUND((SUM(G122:G126)-MAX(G122:G126)-MIN(G122:G126))/3,2)","v":4.1900000000000004},4.0999999999999996,4.0999999999999996,4.2]
[null,"Bench rev",null,null,null,{"$f":"ROUND(F129*F130,2)","v":845.64},{"$f":"ROUND(G129*G130,2)","v":775.15},788.43,799.5,819]
[null,"ARC pay",null,null,null,{"$f":"ROUND(MIN(MAX(0,F131*0.86-F30*(F12+budgets!$E$104)),0.1*F131),2)","v":0},{"$f":"ROUND(MIN(MAX(0,G131*0.86-G30*(G12+budgets!$E$104)),0.1*G131),2)","v":0},{"$f":"ROUND(MIN(MAX(0,H131*0.86-H30*(H12+budgets!$E$104)),0.1*H131),2)","v":0},{"$f":"ROUND(MIN(MAX(0,I131*0.86-I30*(I12+budgets!$E$104)),0.1*I131),2)","v":0},{"$f":"ROUND(MIN(MAX(0,J131*0.86-J30*(J12+budgets!$E$104)),0.1*J131),2)","v":0}]
[]
[]
[]
[null,"Bean",null,null,"Year 1",{"$f":"budgets!F91","v":56},{"$f":"budgets!G91","v":0},{"$f":"budgets!H91","v":0},{"$f":"budgets!I91","v":0},{"$f":"budgets!J91","v":0}]
[null,"Yields",null,null,"Year 2",{"$f":"budgets!F92","v":52},{"$f":"budgets!G92","v":0},{"$f":"budgets!H92","v":0},{"$f":"budgets!I92","v":0},{"$f":"budgets!J92","v":0}]
[null,null,null,null,"Year 3",{"$f":"budgets!F93","v":56},{"$f":"budgets!G93","v":0},{"$f":"budgets!H93","v":0},{"$f":"budgets!I93","v":0},{"$f":"budgets!J93","v":0}]
[null,null,null,null,"Year 4",{"$f":"budgets!F94","v":63},{"$f":"budgets!G94","v":0},{"$f":"budgets!H94","v":0},{"$f":"budgets!I94","v":0},{"$f":"budgets!J94","v":0}]
[null,null,null,null,"Year 5",{"$f":"budgets!F95","v":57},{"$f":"budgets!G95","v":0},{"$f":"budgets!H95","v":0},{"$f":"budgets!I95","v":0},{"$f":"budgets!J95","v":0}]
[]
[]
[null,"Bean",null,null,"Year 1",{"$f":"budgets!F97","v":12.5},{"$f":"budgets!G97","v":0},{"$f":"budgets!H97","v":0},{"$f":"budgets!I97","v":0},{"$f":"budgets!J97","v":0}]
[null,"Prices",null,null,"Year 2",{"$f":"budgets!F98","v":14.4},{"$f":"budgets!G98","v":0},{"$f":"budgets!H98","v":0},{"$f":"budgets!I98","v":0},{"$f":"budgets!J98","v":0}]
[null,null,null,null,"Year 3",{"$f":"budgets!F99","v":13},{"$f":"budgets!G99","v":0},{"$f":"budgets!H99","v":0},{"$f":"budgets!I99","v":0},{"$f":"budgets!J99","v":0}]
[null,null,null,null,"Year 4",{"$f":"budgets!F100","v":10.050000000000001},{"$f":"budgets!G100","v":0},{"$f":"budgets!H100","v":0},{"$f":"budgets!I100","v":0},{"$f":"budgets!J100","v":0}]
[null,null,null,null,"Year 5",{"$f":"budgets!F101","v":9.75},{"$f":"budgets!G101","v":0},{"$f":"budgets!H101","v":0},{"$f":"budgets!I101","v":0},{"$f":"budgets!J101","v":0}]
[]
[]
[null,"Bench yield",null,null,null,{"$f":"ROUND((SUM(F136:F140)-MIN(F136:F140)-MAX(F136:F140))/3,1)","v":56.3},{"$f":"ROUND((SUM(G136:G140)-MIN(G136:G140)-MAX(G136:G140))/3,1)","v":0},0,0,0]
[null,"Bench price",null,null,null,{"$f":"ROUND((SUM(F143:F147)-MAX(F143:F147)-MIN(F143:F147))/3,2)","v":11.85},{"$f":"ROUND((SUM(G143:G147)-MAX(G143:G147)-MIN(G143:G147))/3,2)","v":0},0,0,0]
[null,"Bench rev",null,null,null,{"$f":"ROUND(F150*F151,2)","v":667.16},{"$f":"ROUND(G150*G151,2)","v":0},0,0,0]
[null,"ARC pay",null,null,null,{"$f":"ROUND(MIN(MAX(0,F152*0.86-F48*(F13+budgets!$F$104)),F152*0.1)*0.85,2)","v":28.69},{"$f":"ROUND(MIN(MAX(0,G152*0.86-G48*(G13+budgets!$F$104)),G152*0.1)*0.85,2)","v":0},{"$f":"ROUND(MIN(MAX(0,H152*0.86-H48*(H13+budgets!$F$104)),H152*0.1)*0.85,2)","v":0},{"$f":"ROUND(MIN(MAX(0,I152*0.86-I48*(I13+budgets!$F$104)),I152*0.1)*0.85,2)","v":0},{"$f":"ROUND(MIN(MAX(0,J152*0.86-J48*(J13+budgets!$F$104)),J152*0.1)*0.85,2)","v":0}]
[]
[]
[null,"PLC"]
[null,null,"Corn",null,null,{"$f":"MAX(0,3.75-F30)*budgets!$E$89*0.85","v":0},{"$f":"MAX(0,3.75-G30)*budgets!$E$89*0.85","v":0},{"$f":"MAX(0,3.75-H30)*budgets!$E$89*0.85","v":0},{"$f":"MAX(0,3.75-I30)*budgets!$E$89*0.85","v":0},{"$f":"MAX(0,3.75-J30)*budgets!$E$89*0.85","v":0}]
[null,null,"Beans",null,null,{"$f":"MAX(0,8.4-F48)*budgets!$F$89*0.85","v":0},{"$f":"MAX(0,8.4-G48)*budgets!$F$89*0.85","v":0},{"$f":"MAX(0,8.4-H48)*budgets!$F$89*0.85","v":0},{"$f":"MAX(0,8.4-I48)*budgets!$F$89*0.85","v":0},{"$f":"MAX(0,8.4-J48)*budgets!$F$89*0.85","v":0}]
[null,null,"Wgt",null,null,{"$f":"F157*budgets!$E$103+longRun!F158*budgets!$F$103","v":0},{"$f":"G157*budgets!$E$103+longRun!G158*budgets!$F$103","v":0},{"$f":"H157*budgets!$E$103+longRun!H158*budgets!$F$103","v":0},{"$f":"I157*budgets!$E$103+longRun!I158*budgets!$F$103","v":0},{"$f":"J157*budgets!$E$103+longRun!J158*budgets!$F$103","v":0}]
[]
[null,"Program payments",null,null,null,{"$f":"IF(budgets!$E$88=\"ARC\",longRun!F132,longRun!F157)*budgets!$E$103+IF(budgets!$F$88=\"ARC\",longRun!F153,longRun!F158)*budgets!$F$103","v":11.476000000000001},{"$f":"IF(budgets!$E$88=\"ARC\",longRun!G132,longRun!G157)*budgets!$E$103+IF(budgets!$F$88=\"ARC\",longRun!G153,longRun!G158)*budgets!$F$103","v":0},{"$f":"IF(budgets!$E$88=\"ARC\",longRun!H132,longRun!H157)*budgets!$E$103+IF(budgets!$F$88=\"ARC\",longRun!H153,longRun!H158)*budgets!$F$103","v":0},{"$f":"IF(budgets!$E$88=\"ARC\",longRun!I132,longRun!I157)*budgets!$E$103+IF(budgets!$F$88=\"ARC\",longRun!I153,longRun!I158)*budgets!$F$103","v":0},{"$f":"IF(budgets!$E$88=\"ARC\",longRun!J132,longRun!J157)*budgets!$E$103+IF(budgets!$F$88=\"ARC\",longRun!J153,longRun!J158)*budgets!$F$103","v":0}]
[]
[]
[null,"Crop Insurance -- corn"]
[null,null,"TA-Yield",null,null,{"$f":"budgets!E85","v":183},{"$f":"ROUND(F165+(F12-F165)/10,0)","v":185},{"$f":"ROUND(G165+(G12-G165)/10,0)","v":187},{"$f":"ROUND(H165+(H12-H165)/10,0)","v":189},{"$f":"ROUND(I165+(I12-I165)/10,0)","v":191}]
[null,null,"projected price",null,null,{"$f":"budgets!E86","v":4.3499999999999996},{"$f":"G30+budgets!$E$17","v":4.5},{"$f":"H30+budgets!$E$17","v":4.5},{"$f":"I30+budgets!$E$17","v":4.5},{"$f":"J30+budgets!$E$17","v":4.5}]
[null,null,"coverage level",null,null,{"$f":"budgets!E84","v":0.85},{"$f":"budgets!F84","v":0.85},{"$f":"budgets!G84","v":0},{"$f":"budgets!H84","v":0},{"$f":"budgets!I84","v":0}]
[null,null,"harvest price",null,null,{"$f":"F30+budgets!$E$17","v":4.5},{"$f":"G30+budgets!$E$17","v":4.5},{"$f":"H30+budgets!$E$17","v":4.5},{"$f":"I30+budgets!$E$17","v":4.5},{"$f":"J30+budgets!$E$17","v":4.5}]
[null,null,"Guarantee",null,null,{"$f":"MAX(F168,F166)*F165*F167","v":699.97500000000002},{"$f":"MAX(G168,G166)*G165*G167","v":707.625},0,0,0]
[null,null,"Revenue",null,null,{"$f":"F168*F12","v":891},{"$f":"G168*G12","v":900},{"$f":"H168*H12","v":909},{"$f":"I168*I12","v":918},{"$f":"J168*J12","v":927}]
[null,null,"Pay",null,null,{"$f":"MAX(0,F169-F170)","v":0},{"$f":"MAX(0,G169-G170)","v":0},0,0,0]
[]
[null,"Crop Insurance -- soybeans"]
[null,null,"TA-Yield",null,null,{"$f":"budgets!F85","v":59},{"$f":"F174+(F13-F174)/5","v":58.6},{"$f":"G174+(G13-G174)/5","v":58.38},{"$f":"H174+(H13-H174)/5","v":58.304000000000002},{"$f":"I174+(I13-I174)/5","v":58.343200000000003}]
[null,null,"projected price",null,null,{"$f":"budgets!F86","v":10.3},{"$f":"G48+budgets!$F$17","v":10.3},{"$f":"H48+budgets!$F$17","v":10.3},{"$f":"I48+budgets!$F$17","v":10.3},{"$f":"J48+budgets!$F$17","v":10.3}]
[null,null,"coverage level",null,null,{"$f":"budgets!F84","v":0.85},{"$f":"F176","v":0.85},{"$f":"G176","v":0.85},0.85,0.85]
[null,null,"harvest price",null,null,{"$f":"F48+budgets!$F$17","v":10.3},{"$f":"G48+budgets!$F$17","v":10.3},{"$f":"H48+budgets!$F$17","v":10.3},{"$f":"I48+budgets!$F$17","v":10.3},{"$f":"J48+budgets!$F$17","v":10.3}]
[null,null,"Guarantee",null,null,{"$f":"MAX(F175,F177)*F176*F174","v":516.54500000000007},{"$f":"MAX(G175,G177)*G176*G174","v":513.04300000000001},{"$f":"MAX(H175,H177)*H176*H174","v":511.11690000000004},510.45152000000007,510.79471600000005]
[null,null,"Revenue",null,null,{"$f":"F177*F13","v":587.1},{"$f":"G177*G13","v":592.25},{"$f":"H177*H13","v":597.40000000000009},{"$f":"I177*I13","v":602.55000000000007},{"$f":"J177*J13","v":607.70000000000005}]
[null,null,"Pay",null,null,{"$f":"MAX(0,F178-F179)","v":0},{"$f":"MAX(0,G178-G179)","v":0},{"$f":"MAX(0,H178-H179)","v":0},0,0]
[]
[null,"Insurance payment",null,null,null,{"$f":"F171*budgets!$E$14+longRun!F180*budgets!$F$14","v":0},{"$f":"G171*budgets!$E$14+longRun!G180*budgets!$F$14","v":0},{"$f":"H171*budgets!$E$14+longRun!H180*budgets!$F$14","v":0},{"$f":"I171*budgets!$E$14+longRun!I180*budgets!$F$14","v":0},{"$f":"J171*budgets!$E$14+longRun!J180*budgets!$F$14","v":0}]