{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Intro","yield response","User Input","model","Average Net Returns","Decision Chart"],"not_rendered":{"charts":3,"images":4,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Decision Chart","index":5,"reason":"not_a_worksheet"}],"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":"Intro","index":0,"n_rows":32,"n_cols":2,"rows_kept":32,"cut":false,"hidden":false,"merged":[[8,1,8,12],[0,1,0,12],[1,1,1,12],[4,1,4,12],[5,1,5,12],[6,1,6,12],[15,1,15,12],[25,1,25,11],[26,1,26,11],[27,1,27,11],[9,1,9,12],[10,1,10,12],[11,1,11,12],[12,1,12,12],[13,1,13,12],[14,1,14,12]]}
[null,"Corn-Preventing Planting Decision"]
[null,"Version 1.0 2023"]
[]
[]
[null,"Hence Duncan"]
[null,"University of Tennessee"]
[null,"Department of Agricultural and Resource Economics"]
[]
[null,"Student Mentors"]
[null,"Chris Boyer, Professor"]
[null,"University of Tennessee"]
[null,"Department of Agricultural and Resource Economics"]
[]
[null,"S. Aaron Smith, Associate Professor"]
[null,"University of Tennessee"]
[null,"Department of Agricultural and Resource Economics"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"The University of Tennessee is an EEO/AA/Title VI/Title IX/Section 504/ADA/ADEA institution in the provision of its education and employment programs and services. All qualified applicants will receive equal consideration for employment and admission without regard to race, color, national origin, religion, sex, pregnancy, marital status, sexual orientation, gender identity, age, physical or mental disability, genetic information, veteran status, and parental status."]
[]
[]
[]
[]
[]
[null," Grant no. 2021-67023-33819 "]

{"sheet":"yield response","index":1,"n_rows":90,"n_cols":23,"rows_kept":90,"cut":false,"hidden":true,"merged":[[0,8,0,19],[1,12,1,14],[1,17,1,19],[6,8,6,19],[7,12,7,14],[7,17,7,19]]}
[null,"Corn","Soybeans",null,null,null,null,null,"Corn",null,null,null,null,null,null,null,null,null,null,null,null,null,0.5]
["Intercept",61.700299999999999,-49.965400000000002,null,null,null,null,null,"Random Draw of Coefficients","=","Beta Coefficients","+","Cholesky",null,null,"*","Z score","Correlation",null,null,null,null,0.55000000000000004]
["day",2.6663999999999999,1.4556,null,null,null,null,null,{"$f":"K3+(MMULT(M3:O3,$Q$3:$Q$5))","v":92.702701378412016},null,61.700299999999999,null,40.733647026,0,0,null,{"$f":"_xll.CUSD($R$3:$T$5)","v":0.76110055548484035},1,-0.82499999999999996,0.81220000000000003,null,null,0.6]
["day*day",-1.465E-2,-5.2199999999999998E-3,null,null,null,null,null,{"$f":"K4+(MMULT(M4:O4,$Q$3:$Q$5))","v":2.345375146031984},null,2.6663999999999999,null,-0.46215846999999999,0.31655891759999999,0,null,{"$f":"_xll.CUSD($R$3:$T$5)","v":9.7056859127345296E-2},-0.82499999999999996,1,-0.99519999999999997,null,null,0.65]
[null,null,null,null,null,null,null,null,-1.3241668203727432E-2,null,-1.465E-2,null,1.8063691E-3,-1.279924E-3,2.1172230000000001E-4,null,{"$f":"_xll.CUSD($R$3:$T$5)","v":0.74497903250449027},0.81220000000000003,-0.99519999999999997,1,null,null,0.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.75]
[null,null,null,null,null,null,null,null,"Soybeans",null,null,null,null,null,null,null,null,null,null,null,null,null,0.8]
[null,null,null,null,null,null,null,null,"Random Draw of Coefficients","=","Beta Coefficients","+","Cholesky",null,null,"*","Z score","Correlation",null,null,null,null,0.85]
[null,null,null,null,null,null,null,null,{"$f":"K9+(MMULT(M9:O9,$Q$9:$Q$11))","v":-49.256291120210754},null,-49.965400000000002,null,10.274239631,0,0,null,{"$f":"_xll.CUSD($R$9:$T$11)","v":6.9018137132960122E-2},1,-0.98119999999999996,0.96889999999999998]
[null,null,null,null,null,null,null,null,{"$f":"K10+(MMULT(M10:O10,$Q$9:$Q$11))","v":1.4616147196196132},null,1.4556,null,-0.126753906,2.49689292E-2,0,null,{"$f":"_xll.CUSD($R$9:$T$11)","v":0.59125635576152547},-0.98119999999999996,1,-0.996]
[null,null,null,null,null,null,null,null,-5.1949175518617753E-3,null,-5.2199999999999998E-3,null,3.868899E-4,-3.8454999999999997E-5,9.1309099999999996E-5,null,{"$f":"_xll.CUSD($R$9:$T$11)","v":0.23126710399594685},0.96889999999999998,-0.996,1]
[]
[" Corn PD","Corn Expected Yields","Soybean PD","Soybean Expected Yields"]
["1900-05-20",{"$f":"$B$2+$B$3*A14+$B$4*A14*A14","v":146.40604999999999},"1900-05-20",{"$f":"$C$2+C14*$C$3+$C$4*C14*C14","v":51.495380000000011}]
["1900-05-21",{"$f":"$B$2+$B$3*A15+$B$4*A15*A15","v":144.92649999999998},"1900-05-21",{"$f":"$C$2+C15*$C$3+$C$4*C15*C15","v":51.473720000000014}]
["1900-05-22",143.41765000000004,"1900-05-22",51.441620000000015]
["1900-05-23",141.87949999999995,"1900-05-23",51.399080000000012]
["1900-05-24",140.31205,"1900-05-24",51.346100000000021]
["1900-05-25",138.71529999999996,"1900-05-25",51.282679999999971]
["1900-05-26",137.08925000000005,"1900-05-26",51.208819999999974]
["1900-05-27",135.43389999999999,"1900-05-27",51.124519999999976]
["1900-05-28",133.7492499999999,"1900-05-28",51.029779999999974]
["1900-05-29",132.03530000000006,"1900-05-29",50.924599999999998]
["1900-05-30",130.29204999999996,"1900-05-30",50.808980000000005]
["1900-05-31",128.51950000000005,"1900-05-31",50.68292000000001]
["1900-06-01",126.71764999999999,"1900-06-01",50.546420000000012]
["1900-06-02",124.88649999999996,"1900-06-02",50.399480000000011]
["1900-06-03",123.02605,"1900-06-03",50.242100000000022]
["1900-06-04",121.13629999999995,"1900-06-04",50.074280000000016]
["1900-06-05",119.21724999999998,"1900-06-05",49.896020000000021]
["1900-06-06",117.26890000000003,"1900-06-06",49.707320000000038]
["1900-06-07",115.29124999999993,"1900-06-07",49.508180000000038]
["1900-06-08",113.28430000000003,"1900-06-08",49.298600000000022]
["1900-06-09",111.24804999999998,"1900-06-09",49.078579999999988]
["1900-06-10",109.1825,"1900-06-10",48.848119999999994]
["1900-06-11",107.08764999999994,"1900-06-11",48.607219999999984]
["1900-06-12",104.96350000000001,"1900-06-12",48.355879999999985]
["1900-06-13",102.81004999999999,"1900-06-13",48.094099999999997]
["1900-06-14",100.62729999999993,"1900-06-14",47.821879999999993]
["1900-06-15",98.415250000000071,"1900-06-15",47.53922]
["1900-06-16",96.173900000000003,"1900-06-16",47.246120000000019]
["1900-06-17",93.903250000000071,"1900-06-17",46.942580000000021]
["1900-06-18",91.60329999999999,"1900-06-18",46.628600000000006]
["1900-06-19",89.274049999999932,"1900-06-19",46.304180000000031]
["1900-06-20",86.915500000000009,"1900-06-20",45.96932000000001]
["1900-06-21",84.527649999999937,"1900-06-21",45.62402000000003]
[null,null,"1900-06-22",45.268280000000033]
[null,null,"1900-06-23",44.90209999999999]
[null,null,"1900-06-24",44.525480000000044]
[null,null,"1900-06-25",44.138420000000053]
[null,null,"1900-06-26",43.740919999999988]
[null,null,"1900-06-27",43.332979999999992]
[null,null,"1900-06-28",42.914600000000007]
[null,null,"1900-06-29",42.485780000000005]
[null,null,"1900-06-30",42.046520000000015]
[null,null,"1900-07-01",41.596820000000008]
[null,null,"1900-07-02",41.136680000000013]
[null,null,"1900-07-03",40.6661]
[null,null,"1900-07-04",40.185080000000028]
[null,null,"1900-07-05",39.69362000000001]
[null,null,"1900-07-06",39.191720000000032]
[null,null,"1900-07-07",38.679380000000037]
[null,null,"1900-07-08",38.156600000000026]
[null,null,"1900-07-09",37.623380000000026]
[null,null,"1900-07-10",37.07971999999998]
[null,null,"1900-07-11",36.525619999999975]
[null,null,"1900-07-12",35.961079999999981]
[null,null,"1900-07-13",35.386099999999999]
[null,null,"1900-07-14",34.80068]
[null,null,"1900-07-15",34.204819999999984]
[null,null,"1900-07-16",33.598520000000008]
[null,null,"1900-07-17",32.981780000000015]
[null,null,"1900-07-18",32.354600000000005]
[null,null,"1900-07-19",31.716980000000007]
[null,null,"1900-07-20",31.06892000000002]
[null,null,"1900-07-21",30.410420000000016]
[null,null,"1900-07-22",29.741480000000024]
[null,null,"1900-07-23",29.062100000000015]
[null,null,"1900-07-24",28.372280000000018]
[null,null,"1900-07-25",27.672019999999975]
[null,null,"1900-07-26",26.961319999999972]
[null,null,"1900-07-27",26.240179999999981]
[null,null,"1900-07-28",25.508599999999973]
[null,null,"1900-07-29",24.766579999999976]
[null,null,"1900-07-30",24.014119999999991]
[null,null,"1900-07-31",23.251219999999989]
[null,null,"1900-08-01",22.477880000000056]
[null,null,"1900-08-02",21.694100000000049]
[null,null,"1900-08-03",20.899880000000053]
[null,null,"1900-08-04",20.095220000000069]

{"sheet":"User Input","index":2,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,3,1,4]]}
[]
[null,null,null,"User Input"]
[]
[]
[null,null,null,"Corn Price",5.86]
[null,null,null,"Soybean Price",13.3]
[null,null,null,"Pre-plant Cost Per Acre",190]
[null,null,null,"Post-plant Cost Corn Per Acre",490]
[null,null,null,"Cost of Planting Beans Per Acre",190]
[]
[null,null,null,"Corn APH",153]
[null,null,null,"Soybean APH",54]
[null,null,null,"Corn Coverage Level",0.7]
[null,null,null,"Bean Coverage Level",0.7]
[null,null,null,"Corn Insurance Premium",15]
[null,null,null,"Bean Insurance Premium",15]

{"sheet":"model","index":3,"n_rows":92,"n_cols":15,"rows_kept":92,"cut":false,"hidden":true,"merged":[]}
[{"$f":"'User Input'!D5","v":"Corn Price"},{"$f":"'User Input'!E5","v":5.86}]
[{"$f":"'User Input'!D6","v":"Soybean Price"},{"$f":"'User Input'!E6","v":13.3}]
[{"$f":"'User Input'!D7","v":"Pre-plant Cost Per Acre"},{"$f":"'User Input'!E7","v":190}]
[{"$f":"'User Input'!D8","v":"Post-plant Cost Corn Per Acre"},{"$f":"'User Input'!E8","v":490}]
[{"$f":"'User Input'!D9","v":"Cost of Planting Beans Per Acre"},{"$f":"'User Input'!E9","v":190}]
[]
[{"$f":"'User Input'!D11","v":"Corn APH"},165]
[{"$f":"'User Input'!D12","v":"Soybean APH"},{"$f":"'User Input'!E12","v":54}]
[{"$f":"'User Input'!D13","v":"Corn Coverage Level"},{"$f":"'User Input'!E13","v":0.7}]
[{"$f":"'User Input'!D14","v":"Bean Coverage Level"},{"$f":"'User Input'!E14","v":0.7}]
[{"$f":"'User Input'!D15","v":"Corn Insurance Premium"},{"$f":"'User Input'!E15","v":15},null,"Partial PP corn",{"$f":"($B$1*$B$7*$B$9*$B$14*$B$15)","v":130.28977500000002}]
[{"$f":"'User Input'!D16","v":"Bean Insurance Premium"},{"$f":"'User Input'!E16","v":15}]
[]
["PP coverage factor",0.55000000000000004]
["Partial PP factor",0.35]
[]
["Plant date","Full Prevented Planting","Late Corn","Insured Beans","35% + Uninsured Soybeans",null,"Corn days late","Corn insured revenue","Coverage change for corn",null,"Bean day late","Bean Ins Rev","Bean Cov Level"]
["1900-05-20",{"$f":"$B$1*$B$7*$B$9*$B$14","v":372.25650000000007},{"$f":"MAX($B$1*'yield response'!B14,H18)-$B$3-$B$4-$B$11","v":162.93945299999996},{"$f":"MAX($B$2*'yield response'!D14,model!L18)-$B$5-$B$3-$B$12","v":289.88855400000023},null,null,1,{"$f":"$B$1*$B$7*I18","v":670.06169999999997},{"$f":"($B$9-(0.01*$B$9*G18))","v":0.69299999999999995},null,0,{"$f":"$B$2*$B$8*M18","v":502.74},{"$f":"($B$10-(0.01*$B$10*K18))","v":0.7}]
["1900-05-21",{"$f":"$B$1*$B$7*$B$9*$B$14","v":372.25650000000007},{"$f":"MAX($B$1*'yield response'!B15,H19)-$B$3-$B$4-$B$11","v":154.26928999999996},{"$f":"MAX($B$2*'yield response'!D15,model!L19)-$B$5-$B$3-$B$12","v":289.60047600000019},null,null,2,{"$f":"$B$1*$B$7*I19","v":663.29340000000002},0.68599999999999994,null,0,{"$f":"$B$2*$B$8*M19","v":502.74},{"$f":"($B$10-(0.01*$B$10*K19))","v":0.7}]
["1900-05-22",372.25650000000007,{"$f":"MAX($B$1*'yield response'!B16,H20)-$B$3-$B$4-$B$11","v":145.4274290000003},{"$f":"MAX($B$2*'yield response'!D16,model!L20)-$B$5-$B$3-$B$12","v":289.17354600000021},null,null,3,656.52509999999995,0.67899999999999994,null,0,502.74,0.7]
["1900-05-23",372.25650000000007,{"$f":"MAX($B$1*'yield response'!B17,H21)-$B$3-$B$4-$B$11","v":136.41386999999975},{"$f":"MAX($B$2*'yield response'!D17,model!L21)-$B$5-$B$3-$B$12","v":288.6077640000002},null,null,4,649.7568,0.67199999999999993,null,0,502.74,0.7]
["1900-05-24",372.25650000000007,{"$f":"MAX($B$1*'yield response'!B18,H22)-$B$3-$B$4-$B$11","v":127.228613},{"$f":"MAX($B$2*'yield response'!D18,model!L22)-$B$5-$B$3-$B$12","v":287.90313000000037},null,null,5,642.98849999999993,0.66499999999999992,null,0,502.74,0.7]
["1900-05-25",372.25650000000007,{"$f":"MAX($B$1*'yield response'!B19,H23)-$B$3-$B$4-$B$11","v":117.8716579999998},{"$f":"MAX($B$2*'yield response'!D19,model!L23)-$B$5-$B$3-$B$12","v":287.05964399999959},null,null,6,636.22019999999998,0.65799999999999992,null,0,502.74,0.7]
["1900-05-26",372.25650000000007,{"$f":"MAX($B$1*'yield response'!B20,H24)-$B$3-$B$4-$B$11","v":108.34300500000029},{"$f":"MAX($B$2*'yield response'!D20,model!L24)-$B$5-$B$3-$B$12","v":286.07730599999968},null,null,7,629.45190000000002,0.65099999999999991,null,0,502.74,0.7]
["1900-05-27",372.25650000000007,{"$f":"MAX($B$1*'yield response'!B21,H25)-$B$3-$B$4-$B$11","v":98.642653999999993},{"$f":"MAX($B$2*'yield response'!D21,model!L25)-$B$5-$B$3-$B$12","v":284.95611599999972},null,null,8,622.68359999999996,0.64399999999999991,null,0,502.74,0.7]
["1900-05-28",372.25650000000007,{"$f":"MAX($B$1*'yield response'!B22,H26)-$B$3-$B$4-$B$11","v":88.770604999999478},{"$f":"MAX($B$2*'yield response'!D22,model!L26)-$B$5-$B$3-$B$12","v":283.69607399999973},null,null,9,615.91530000000012,0.63700000000000001,null,0,502.74,0.7]
["1900-05-29",372.25650000000007,{"$f":"MAX($B$1*'yield response'!B23,H27)-$B$3-$B$4-$B$11","v":78.726858000000448},{"$f":"MAX($B$2*'yield response'!D23,model!L27)-$B$5-$B$3-$B$12","v":282.29718000000003},null,null,10,609.14700000000005,0.63,null,0,502.74,0.7]
["1900-05-30",372.25650000000007,{"$f":"MAX($B$1*'yield response'!B24,H28)-$B$3-$B$4-$B$11","v":68.511412999999834},{"$f":"MAX($B$2*'yield response'!D24,model!L28)-$B$5-$B$3-$B$12","v":280.75943400000006},null,null,11,602.37870000000009,0.623,null,0,502.74,0.7]
["1900-05-31",372.25650000000007,{"$f":"MAX($B$1*'yield response'!B25,H29)-$B$3-$B$4-$B$11","v":58.124270000000365},{"$f":"MAX($B$2*'yield response'!D25,model!L29)-$B$5-$B$3-$B$12","v":279.08283600000016},null,null,12,595.61040000000003,0.61599999999999999,null,0,502.74,0.7]
["1900-06-01",372.25650000000007,{"$f":"MAX($B$1*'yield response'!B26,H30)-$B$3-$B$4-$B$11","v":47.565428999999995},{"$f":"MAX($B$2*'yield response'!D26,model!L30)-$B$5-$B$3-$B$12","v":277.26738600000022},null,null,13,588.84210000000007,0.60899999999999999,null,0,502.74,0.7]
["1900-06-02",372.25650000000007,{"$f":"MAX($B$1*'yield response'!B27,H31)-$B$3-$B$4-$B$11","v":36.834889999999746},{"$f":"MAX($B$2*'yield response'!D27,model!L31)-$B$5-$B$3-$B$12","v":275.31308400000023},null,null,14,582.07380000000001,0.60199999999999998,null,0,502.74,0.7]
["1900-06-03",372.25650000000007,{"$f":"MAX($B$1*'yield response'!B28,H32)-$B$3-$B$4-$B$11","v":25.932653000000073},{"$f":"MAX($B$2*'yield response'!D28,model!L32)-$B$5-$B$3-$B$12","v":273.21993000000032},null,null,15,575.30550000000005,0.59499999999999997,null,0,502.74,0.7]
["1900-06-04",372.25650000000007,{"$f":"MAX($B$1*'yield response'!B29,H33)-$B$3-$B$4-$B$11","v":14.858717999999726},{"$f":"MAX($B$2*'yield response'!D29,model!L33)-$B$5-$B$3-$B$12","v":270.98792400000025},{"$f":"$B$2*'yield response'!D14-model!$B$5-model!$B$3+model!$E$11-(0.35*$B$11)","v":429.92832900000025},null,16,568.53719999999998,0.58799999999999997,null,0,502.74,0.7,null,1]
["1900-06-05",372.25650000000007,{"$f":"MAX($B$1*'yield response'!B30,H34)-$B$3-$B$4-$B$11","v":3.6130849999999555},{"$f":"MAX($B$2*'yield response'!D30,model!L34)-$B$5-$B$3-$B$12","v":268.61706600000036},{"$f":"$B$2*'yield response'!D15-model!$B$5-model!$B$3+model!$E$11-(0.35*$B$11)","v":429.64025100000021},null,17,561.76890000000003,0.58099999999999996,null,0,502.74,0.7,null,2]
["1900-06-06",372.25650000000007,{"$f":"MAX($B$1*'yield response'!B31,H35)-$B$3-$B$4-$B$11","v":-7.8042459999998073},{"$f":"MAX($B$2*'yield response'!D31,model!L35)-$B$5-$B$3-$B$12","v":266.10735600000055},{"$f":"$B$2*'yield response'!D16-model!$B$5-model!$B$3+model!$E$11-(0.35*$B$11)","v":429.21332100000024},null,18,555.00059999999996,0.57399999999999995,null,0,502.74,0.7,null,3]
["1900-06-07",372.25650000000007,{"$f":"MAX($B$1*'yield response'!B32,H36)-$B$3-$B$4-$B$11","v":-19.393275000000358},{"$f":"MAX($B$2*'yield response'!D32,model!L36)-$B$5-$B$3-$B$12","v":263.45879400000058},{"$f":"$B$2*'yield response'!D17-model!$B$5-model!$B$3+model!$E$11-(0.35*$B$11)","v":428.64753900000022},null,19,548.23230000000001,0.56699999999999995,null,0,502.74,0.7]
["1900-06-08",372.25650000000007,{"$f":"MAX($B$1*'yield response'!B33,H37)-$B$3-$B$4-$B$11","v":-31.154001999999764},{"$f":"MAX($B$2*'yield response'!D33,model!L37)-$B$5-$B$3-$B$12","v":260.67138000000034},{"$f":"$B$2*'yield response'!D18-model!$B$5-model!$B$3+model!$E$11-(0.35*$B$11)","v":427.94290500000039},null,20,541.46399999999994,0.55999999999999994,null,0,502.74,0.7]
["1900-06-09",372.25650000000007,{"$f":"MAX($B$1*'yield response'!B34,H38)-$B$3-$B$4-$B$11","v":-43.086427000000072},{"$f":"MAX($B$2*'yield response'!D34,model!L38)-$B$5-$B$3-$B$12","v":257.74511399999983},{"$f":"$B$2*'yield response'!D19-model!$B$5-model!$B$3+model!$E$11-(0.35*$B$11)","v":427.09941899999961},null,21,534.69569999999999,0.55299999999999994,null,0,502.74,0.7]
["1900-06-10",372.25650000000007,{"$f":"MAX($B$1*'yield response'!B35,H39)-$B$3-$B$4-$B$11","v":-55.190549999999917},{"$f":"MAX($B$2*'yield response'!D35,model!L39)-$B$5-$B$3-$B$12","v":254.67999599999996},{"$f":"$B$2*'yield response'!D20-model!$B$5-model!$B$3+model!$E$11-(0.35*$B$11)","v":426.1170809999997},null,22,527.92740000000003,0.54600000000000004,null,0,502.74,0.7]
["1900-06-11",372.25650000000007,{"$f":"MAX($B$1*'yield response'!B36,H40)-$B$3-$B$4-$B$11","v":-67.466371000000322},{"$f":"MAX($B$2*'yield response'!D36,model!L40)-$B$5-$B$3-$B$12","v":251.47602599999982},{"$f":"$B$2*'yield response'!D21-model!$B$5-model!$B$3+model!$E$11-(0.35*$B$11)","v":424.99589099999974},null,23,521.15909999999997,0.53899999999999992,null,0,502.74,0.7]
["1900-06-12",372.25650000000007,{"$f":"MAX($B$1*'yield response'!B37,H41)-$B$3-$B$4-$B$11","v":-79.913889999999924},{"$f":"MAX($B$2*'yield response'!D37,model!L41)-$B$5-$B$3-$B$12","v":248.13320399999986},{"$f":"$B$2*'yield response'!D22-model!$B$5-model!$B$3+model!$E$11-(0.35*$B$11)","v":423.73584899999975},null,24,514.39080000000013,0.53200000000000003,null,0,502.74,0.7]
["1900-06-13",372.25650000000007,{"$f":"MAX($B$1*'yield response'!B38,H42)-$B$3-$B$4-$B$11","v":-92.533106999999973},{"$f":"MAX($B$2*'yield response'!D38,model!L42)-$B$5-$B$3-$B$12","v":244.65152999999998},{"$f":"$B$2*'yield response'!D23-model!$B$5-model!$B$3+model!$E$11-(0.35*$B$11)","v":422.33695500000005},null,25,507.62249999999995,0.52499999999999991,null,0,502.74,0.7]
["1900-06-14",372.25650000000007,null,{"$f":"MAX($B$2*'yield response'!D39,model!L43)-$B$5-$B$3-$B$12","v":241.03100399999994},{"$f":"$B$2*'yield response'!D24-model!$B$5-model!$B$3+model!$E$11-(0.35*$B$11)","v":420.79920900000008},null,26,500.85420000000005,0.51800000000000002,null,1,497.71260000000001,0.69299999999999995]
["1900-06-15",372.25650000000007,null,{"$f":"MAX($B$2*'yield response'!D40,model!L44)-$B$5-$B$3-$B$12","v":237.27162600000008},{"$f":"$B$2*'yield response'!D25-model!$B$5-model!$B$3+model!$E$11-(0.35*$B$11)","v":419.12261100000018},null,27,494.08590000000004,0.51100000000000001,null,2,492.68520000000001,0.68599999999999994]
["1900-06-16",372.25650000000007,null,{"$f":"MAX($B$2*'yield response'!D41,model!L45)-$B$5-$B$3-$B$12","v":233.3733960000003},{"$f":"$B$2*'yield response'!D26-model!$B$5-model!$B$3+model!$E$11-(0.35*$B$11)","v":417.30716100000024},null,28,487.31760000000003,0.504,null,3,487.65780000000001,0.67899999999999994]
["1900-06-17",372.25650000000007,null,{"$f":"MAX($B$2*'yield response'!D42,model!L46)-$B$5-$B$3-$B$12","v":229.33631400000036},{"$f":"$B$2*'yield response'!D27-model!$B$5-model!$B$3+model!$E$11-(0.35*$B$11)","v":415.35285900000025},null,29,480.54930000000002,0.497,null,4,482.63040000000001,0.67199999999999993]
["1900-06-18",372.25650000000007,null,{"$f":"MAX($B$2*'yield response'!D43,model!L47)-$B$5-$B$3-$B$12","v":225.16038000000015},{"$f":"$B$2*'yield response'!D28-model!$B$5-model!$B$3+model!$E$11-(0.35*$B$11)","v":413.25970500000034},null,30,473.78100000000006,0.49,null,5,477.60299999999995,0.66499999999999992]
["1900-06-19",372.25650000000007,null,{"$f":"MAX($B$2*'yield response'!D44,model!L48)-$B$5-$B$3-$B$12","v":220.84559400000046},{"$f":"$B$2*'yield response'!D29-model!$B$5-model!$B$3+model!$E$11-(0.35*$B$11)","v":411.02769900000027},null,31,467.01270000000005,0.48299999999999998,null,6,472.57559999999995,0.65799999999999992]
["1900-06-20",372.25650000000007,null,{"$f":"MAX($B$2*'yield response'!D45,model!L49)-$B$5-$B$3-$B$12","v":216.39195600000016},{"$f":"$B$2*'yield response'!D30-model!$B$5-model!$B$3+model!$E$11-(0.35*$B$11)","v":408.65684100000038},null,32,460.24440000000004,0.47599999999999998,null,7,467.54819999999995,0.65099999999999991]
["1900-06-21",372.25650000000007,null,{"$f":"MAX($B$2*'yield response'!D46,model!L50)-$B$5-$B$3-$B$12","v":211.79946600000039},{"$f":"$B$2*'yield response'!D31-model!$B$5-model!$B$3+model!$E$11-(0.35*$B$11)","v":406.14713100000057},null,33,453.47610000000003,0.46899999999999997,null,8,462.52079999999995,0.64399999999999991]
["1900-06-22",372.25650000000007,null,{"$f":"MAX($B$2*'yield response'!D47,model!L51)-$B$5-$B$3-$B$12","v":207.06812400000047},{"$f":"$B$2*'yield response'!D32-model!$B$5-model!$B$3+model!$E$11-(0.35*$B$11)","v":403.4985690000006},null,34,446.70780000000002,0.46199999999999997,null,9,457.49340000000001,0.63700000000000001]
["1900-06-23",372.25650000000007,null,{"$f":"MAX($B$2*'yield response'!D48,model!L52)-$B$5-$B$3-$B$12","v":202.19792999999993},{"$f":"$B$2*'yield response'!D33-model!$B$5-model!$B$3+model!$E$11-(0.35*$B$11)","v":400.71115500000036},null,35,439.93950000000001,0.45499999999999996,null,10,452.46600000000001,0.63]
["1900-06-24",372.25650000000007,null,{"$f":"MAX($B$2*'yield response'!D49,model!L53)-$B$5-$B$3-$B$12","v":197.1888840000006},{"$f":"$B$2*'yield response'!D34-model!$B$5-model!$B$3+model!$E$11-(0.35*$B$11)","v":397.78488899999985},null,36,433.1712,0.44799999999999995,null,11,447.43860000000001,0.623]
["1900-06-25",372.25650000000007,null,{"$f":"MAX($B$2*'yield response'!D50,model!L54)-$B$5-$B$3-$B$12","v":192.04098600000077},{"$f":"$B$2*'yield response'!D35-model!$B$5-model!$B$3+model!$E$11-(0.35*$B$11)","v":394.71977099999998},null,37,426.40290000000005,0.441,null,12,442.41120000000001,0.61599999999999999]
["1900-06-26",372.25650000000007,null,{"$f":"MAX($B$2*'yield response'!D51,model!L55)-$B$5-$B$3-$B$12","v":186.75423599999988},{"$f":"$B$2*'yield response'!D36-model!$B$5-model!$B$3+model!$E$11-(0.35*$B$11)","v":391.51580099999984},null,38,419.63460000000003,0.434,null,13,437.38380000000001,0.60899999999999999]
["1900-06-27",372.25650000000007,null,{"$f":"MAX($B$2*'yield response'!D52,model!L56)-$B$5-$B$3-$B$12","v":181.32863399999997},{"$f":"$B$2*'yield response'!D37-model!$B$5-model!$B$3+model!$E$11-(0.35*$B$11)","v":388.17297899999988},null,39,412.86630000000002,0.42699999999999999,null,14,432.35640000000001,0.60199999999999998]
["1900-06-28",372.25650000000007,null,{"$f":"MAX($B$2*'yield response'!D53,model!L57)-$B$5-$B$3-$B$12","v":175.76418000000012},{"$f":"$B$2*'yield response'!D38-model!$B$5-model!$B$3+model!$E$11-(0.35*$B$11)","v":384.691305},null,40,406.09800000000001,0.42,null,15,427.32900000000001,0.59499999999999997]
["1900-06-29",372.25650000000007,null,{"$f":"MAX($B$2*'yield response'!D54,model!L58)-$B$5-$B$3-$B$12","v":170.06087400000013},{"$f":"$B$2*'yield response'!D39-model!$B$5-model!$B$3+model!$E$11-(0.35*$B$11)","v":381.07077899999996},null,null,null,null,null,16,422.30160000000001,0.58799999999999997]
["1900-06-30",372.25650000000007,null,{"$f":"MAX($B$2*'yield response'!D55,model!L59)-$B$5-$B$3-$B$12","v":164.2187160000002},{"$f":"$B$2*'yield response'!D40-model!$B$5-model!$B$3+model!$E$11-(0.35*$B$11)","v":377.3114010000001},null,null,null,null,null,17,417.27420000000001,0.58099999999999996]
["1900-07-01",372.25650000000007,null,{"$f":"MAX($B$2*'yield response'!D56,model!L60)-$B$5-$B$3-$B$12","v":158.23770600000012},{"$f":"$B$2*'yield response'!D41-model!$B$5-model!$B$3+model!$E$11-(0.35*$B$11)","v":373.41317100000032},null,null,null,null,null,18,412.24680000000001,0.57399999999999995]
["1900-07-02",372.25650000000007,null,{"$f":"MAX($B$2*'yield response'!D57,model!L61)-$B$5-$B$3-$B$12","v":152.11784400000022},{"$f":"$B$2*'yield response'!D42-model!$B$5-model!$B$3+model!$E$11-(0.35*$B$11)","v":369.37608900000038},null,null,null,null,null,19,407.21940000000001,0.56699999999999995]
["1900-07-03",372.25650000000007,null,{"$f":"MAX($B$2*'yield response'!D58,model!L62)-$B$5-$B$3-$B$12","v":145.85913000000005},{"$f":"$B$2*'yield response'!D43-model!$B$5-model!$B$3+model!$E$11-(0.35*$B$11)","v":365.20015500000017},null,null,null,null,null,20,402.19200000000001,0.55999999999999994]
["1900-07-04",372.25650000000007,null,{"$f":"MAX($B$2*'yield response'!D59,model!L63)-$B$5-$B$3-$B$12","v":139.46156400000041},{"$f":"$B$2*'yield response'!D44-model!$B$5-model!$B$3+model!$E$11-(0.35*$B$11)","v":360.88536900000048},null,null,null,null,null,21,397.16460000000001,{"$f":"($B$10-(0.01*$B$10*K63))","v":0.55299999999999994}]
[null,null,null,null,null,null,null,null,null,null,22,392.13720000000006,0.54600000000000004]
[null,null,null,null,null,null,null,null,null,null,23,387.10979999999995,0.53899999999999992]
[null,null,null,null,null,null,null,null,null,null,24,382.08240000000006,0.53200000000000003]
[null,null,null,null,null,null,null,null,null,null,25,377.05499999999995,0.52499999999999991]
[null,null,null,null,null,null,null,null,null,null,26,372.02760000000001,0.51800000000000002]
[null,null,null,null,null,null,null,null,null,null,27,367.00020000000001,0.51100000000000001]
[null,null,null,null,null,null,null,null,null,null,28,361.97280000000001,0.504]
[null,null,null,null,null,null,null,null,null,null,29,356.94540000000001,0.497]
[null,null,null,null,null,null,null,null,null,null,30,351.91800000000001,0.49]
[null,null,null,null,null,null,null,null,null,null,31,346.89060000000001,0.48299999999999998]
[null,null,null,null,null,null,null,null,null,null,32,341.86320000000001,0.47599999999999998]
[null,null,null,null,null,null,null,null,null,null,33,336.83580000000001,0.46899999999999997]
[null,null,null,null,null,null,null,null,null,null,34,331.80840000000001,0.46199999999999997]
[null,null,null,null,null,null,null,null,null,null,35,326.78100000000001,0.45499999999999996]
[null,null,null,null,null,null,null,null,null,null,36,321.75360000000001,0.44799999999999995]
[null,null,null,null,null,null,null,null,null,null,37,316.72620000000001,0.441]
[null,null,null,null,null,null,null,null,null,null,38,311.69880000000001,0.434]
[null,null,null,null,null,null,null,null,null,null,39,306.67140000000001,0.42699999999999999]
[null,null,null,null,null,null,null,null,null,null,40,301.64400000000001,0.42]
[null,null,null,null,null,null,null,null,null,null,41,296.61660000000001,0.41299999999999998]
[null,null,null,null,null,null,null,null,null,null,42,291.58920000000001,0.40599999999999997]
[null,null,null,null,null,null,null,null,null,null,43,286.56180000000001,0.39899999999999997]
[null,null,null,null,null,null,null,null,null,null,44,281.53440000000001,0.39200000000000002]
[null,null,null,null,null,null,null,null,null,null,45,276.50700000000001,0.38500000000000001]
[null,null,null,null,null,null,null,null,null,null,46,271.4796,0.378]
[null,null,null,null,null,null,null,null,null,null,47,266.4522,0.371]
[null,null,null,null,null,null,null,null,null,null,48,261.4248,0.36399999999999999]
[null,null,null,null,null,null,null,null,null,null,49,256.3974,0.35699999999999998]
[null,null,null,null,null,null,null,null,null,null,50,251.37,0.35]

{"sheet":"Average Net Returns","index":4,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[[18,1,18,2],[2,1,2,2]]}
[]
[]
[null,"User Input"]
[]
[null,"Corn Price",{"$f":"+'User Input'!E5","v":5.86}]
[null,"Soybean Price",{"$f":"+'User Input'!E6","v":13.3}]
[null,"Pre-plant Cost Per Acre",{"$f":"+'User Input'!E7","v":190}]
[null,"Post-plant Cost corn Per Acre",{"$f":"+'User Input'!E8","v":490}]
[null,"Cost of Planting Beans Per Acre",{"$f":"+'User Input'!E9","v":190}]
[]
[null,"Corn APH",{"$f":"+'User Input'!E11","v":153}]
[null,"Soybean APH",{"$f":"+'User Input'!E12","v":54}]
[null,"Corn Coverage Level",{"$f":"+'User Input'!E13","v":0.7}]
[null,"Bean Coverage Level",{"$f":"+'User Input'!E14","v":0.7}]
[null,"Corn Insurance Premium",{"$f":"+'User Input'!E15","v":15}]
[null,"Bean Insurance Premium",{"$f":"+'User Input'!E16","v":15}]
[]
[]
[null,"Average Net Returns Per Acre"]
[]
[null,"Late Planting",{"$f":"AVERAGE(model!$C$18:$C$63)","v":43.101280999999993}]
[null,"100% PP",{"$f":"AVERAGE(model!$B$18:$B$63)","v":372.2564999999999}]
[null,"35% + Uninsured Soybeans",{"$f":"AVERAGE(model!$E$18:$E$63)","v":405.47361900000016}]
[null,"Insured Soybeans",{"$f":"AVERAGE(model!$D$18:$D$63)","v":237.58563900000019}]