{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Introduction","Replant Net Return Estimator","Formulas & Definitions"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":5,"comments":1,"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":"Introduction","index":0,"n_rows":34,"n_cols":8,"rows_kept":34,"cut":false,"hidden":false,"merged":[[31,1,31,11],[32,1,32,11],[33,1,33,11],[2,3,2,9],[3,3,3,9],[5,1,5,12],[6,1,6,12],[7,1,7,12],[9,1,9,6],[10,1,10,6],[9,7,9,12],[10,7,10,12]]}
[]
[]
[null,null,null,"Replant Net Return Estimator"]
[null,null,null,"Version 1.0"]
[]
[null,"Aaron Smith"]
[null,"Assistant Professor - Crop Marketing Specialist"]
[null,"Office: (865) 974-7476     Email: aaron.smith@utk.edu"]
[]
[null,"Becky Bowling",null,null,null,null,null,"Ed Burns"]
[null,"Extension Specialist I",null,null,null,null,null,"Extension Agent III, Franklin County"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Programs in agriculture and natural resources, 4-H youth development, family and consumer sciences, and resource development."]
[null,"University of Tennessee Institute of Agriculture, U.S. Department of Agriculture and country governments cooperating."]
[null,"UT Extension provide equal opportunities in programs and employment."]

{"sheet":"Replant Net Return Estimator","index":1,"n_rows":121,"n_cols":17,"rows_kept":121,"cut":false,"hidden":false,"merged":[[31,1,31,7],[25,1,25,7],[26,1,26,7],[1,1,1,3],[10,2,10,3],[12,2,12,3],[21,2,21,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[22,2,22,3],[2,2,2,3],[16,2,16,3],[8,2,8,3],[9,2,9,3],[3,2,3,3],[23,2,23,3],[0,1,0,7],[9,5,15,7],[2,6,2,7],[3,6,3,7],[6,6,6,7],[7,6,7,7],[16,5,18,7],[7,2,7,3],[15,1,15,3],[1,5,1,7],[4,6,4,7],[4,2,4,3],[11,2,11,3],[13,2,13,3],[0,9,0,15],[20,2,20,3],[5,2,5,3],[6,2,6,3],[14,2,14,3],[5,6,5,7]]}
[null,"Replant Net Return Estimator",null,null,null,null,null,null,null,"****These will be hidden****"]
[null,"Assumptions",null,null,null,"Estimated Yield, Revenue, Cost, and Net Return"]
[null,null,"Corn",null,null,"Estimated Yield (No-Replant)",{"$f":"M24/M27*((1-C19)*M27)","v":105},null,null,"Crop",null,"Destruction Method",null,null,"Planting Dates",null,"Corn"]
[null,"Harvest Price ($/Bu)",4.8,null,null,"Estimated Yield (Replant)",{"$f":"IF(C3=J4,M24*(((100+0.0404*M21-0.0175*M21^2))/100),M24*(((143.78-1.273*M21)/100)))","v":145.00274999999999},null,null,"Corn",null,"Chemical",null,null,"2014-03-20",null,"2014-04-05"]
[null,"Target Yield (Bu)",150,null,null,"Change in Revenue",{"$f":"M9","v":1920.1319999999996},null,null,"Soybeans",null,"Tillage ",null,null,"2014-03-21",null,"2014-05-10"]
[null,"Seed Price ($/Thousand Seeds)",3.13,null,null,"Replant Cost",{"$f":"M10","v":1409.4},null,null,null,null,"None",null,null,"2014-03-22",null,"2014-05-25"]
[null,"Seeding Rate (Thousand Seeds/Acre)",28000,null,null,"Estimated Net Returns from Replant",{"$f":"M9-M10","v":510.73199999999952},null,null,"Replant",null,null,null,null,"2014-03-23"]
[null,"Seed/Plant Mortality (%)",0.1,null,null,{"$f":"IF(C3=J4,\"Should I Replant Corn\",\"Should I Replant Soybeans\")","v":"Should I Replant Corn"},{"$f":"IF(G7>0,J8,J9)","v":"YES"},null,null,"YES",null,null,null,null,"2014-03-24"]
[null,"Burndown ($/Acre)",15.13,null,null,null,null,null,null,"NO",null,"Revenue",{"$f":"C17*(G4-G3)*M28","v":1920.1319999999996},null,"2014-03-25",null,"Soybeans"]
[null,"Tillage ($/Acre)",17.72,null,null,"Disclaimer:  The information provided within represents estimates that are a result of a set of calculations that are described in more detail in the instructions.  Changes in parameter values and corresponding costs are estimates and the user should use their own reasonable judgment to reflect whether the estimates are appropriate before acting on the results. The University of Tennessee will not be liable for any claim or damage brought against the user by any third party, nor will the University of Tennessee be liable for any consequential, indirect or special damages suffered by the user as a result of using the estimator.",null,null,null,null,null,"Cost",{"$f":"+M12+M13+M14+M15+M16","v":1409.4},null,"2014-03-26",null,"2014-05-15"]
[null,"Planting ($/Acre)",12.88,null,null,null,null,null,null,null,null,"Cost Breakdown",null,null,"2014-03-27",null,"2014-06-25"]
[null,"Diesel ($/Gal)",3.9,null,null,null,null,null,null,null,null,"Seed Cost",{"$f":"C17*((M25/1000)*M26)","v":876.4},null,"2014-03-28",null,"2014-07-05"]
[null,"Road Speed, Machinery (MPH)",25,null,null,null,null,null,null,null,null,"Destruction Cost",{"$f":"IF(C22=L4,C9,IF(C22=L5,C10,0))*C17+IF(C22=L6,0,(C18*2/C13*M18*C12+C18*2/C13*C15))","v":222.6},null,"2014-03-29"]
[null,"Number of Additional Trips",3,null,null,null,null,null,null,null,null,"Seeding Cost",{"$f":"+C11*C17+C18*2/C13*M18*C12+C18*2/C13*C15","v":174.20000000000002},null,"2014-03-30"]
[null,"Operator Labor Cost ($/hr)",11,null,null,null,null,null,null,null,null,"Other Costs",{"$f":"+C24*C17","v":0},null,"2014-03-31"]
[null,"Replant Scenario",null,null,null,null,null,null,null,null,null,"Additional Trips",{"$f":"(C18*2/C13*M18*C12)*C14+(C18*2/C13*C15)*C14","v":136.19999999999999},null,"2014-04-01"]
[null,"Acres to be Replanted",10,null,null,"Questions and comments should be directed to Dr. Aaron Smith, Assistant Professor, University of Tennessee. Phone: (865) 974-7476, Email: aaron.smith@utk.edu",null,null,null,null,null,null,null,null,"2014-04-02"]
[null,"Distance to Field (Miles One Way)",25,null,null,null,null,null,null,null,null,"Fuel Use (Gal/Hr)",3,null,"2014-04-03"]
[null,"Estimated Yield Loss - Replant Area (%)",0.3,null,null,null,null,null,null,null,null,null,null,null,"2014-04-04"]
[null,"Original Planting Date","2014-04-05",null,null,null,null,null,null,null,null,"End of Optimal Planting Period",{"$f":"C21","v":"2014-05-10"},null,"2014-04-05"]
[null,"End of Optimal Planting Period","2014-05-10",null,null,null,null,null,null,null,null,"Days from Optimal",{"$f":"IF(C23-M20>0,C23-M20,0)","v":15},null,"2014-04-06"]
[null,"Destruction Method","Tillage ",null,null,null,null,null,null,null,null,null,null,null,"2014-04-07"]
[null,"Replant Date","2014-05-25",null,null,null,null,null,null,null,null,"Days between Plantings",{"$f":"C23-C20","v":50},null,"2014-04-08"]
[null,"Other Replant Costs ($/Acre)",0,null,null,null,null,null,null,null,null,"Target Yield (Bu/Acre)",{"$f":"+C5","v":150},null,"2014-04-09"]
[null,null,null,null,null,null,null,null,null,null,null,"Seeding Rate (Seeds/Acre)",{"$f":"+C7","v":28000},null,"2014-04-10"]
[null,"Users may type over the default values in the orange boxes with any valid number that reflects their specific circumstance.",null,null,null,null,null,null,null,null,null,"Seed Cost ($/Thousand seeds)",{"$f":"+C6","v":3.13},null,"2014-04-11"]
[null,"Yellow boxes reveal drop down menus from which users can select from a range of options.",null,null,null,null,null,null,null,null,null,"Plants per Acre (Goal)",{"$f":"M25*(1-C8)","v":25200},null,"2014-04-12"]
[null,null,null,null,null,null,null,null,null,null,null,"Harvest Price ($/Bu)",{"$f":"C4","v":4.8},null,"2014-04-13"]
[null,"***Prior to making any replant decisions be sure to consult your crop insurance provider. ***",null,null,null,null,null,null,null,null,null,null,null,null,"2014-04-14"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-04-15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-04-16"]
[null,null,null,null,null,null,null,null,null,"Corn",null,null,null,null,"2014-04-17"]
[null,null,null,null,null,null,null,null,null,4.8,null,null,null,null,"2014-04-18"]
[null,null,null,null,null,null,null,null,null,150,null,null,null,null,"2014-04-19"]
[null,null,null,null,null,null,null,null,null,3.13,null,null,null,null,"2014-04-20"]
[null,null,null,null,null,null,null,null,null,28000,null,null,null,null,"2014-04-21"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-04-22"]
[null,null,null,null,null,null,null,null,null,"Soybeans",null,null,null,null,"2014-04-23"]
[null,null,null,null,null,null,null,null,null,11.6,null,null,null,null,"2014-04-24",null,{"$f":"VALUE(O39)","v":41753}]
[null,null,null,null,null,null,null,null,null,45,null,null,null,null,"2014-04-25",null,{"$f":"VALUE(O40)","v":41754}]
[null,null,null,null,null,null,null,null,null,0.36,null,null,null,null,"2014-04-26",null,{"$f":"VALUE(O41)","v":41755}]
[null,null,null,null,null,null,null,null,null,150000,null,null,null,null,"2014-04-27",null,41756]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-04-28",null,41757]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-04-29",null,41758]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-04-30",null,41759]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-05-01",null,41760]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-05-02",null,41761]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-05-03",null,41762]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-05-04",null,41763]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-05-05",null,41764]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-05-06",null,41765]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-05-07",null,41766]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-05-08",null,41767]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-05-09",null,41768]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-05-10",null,41769]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-05-11",null,41770]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-05-12",null,41771]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-05-13",null,41772]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-05-14",null,41773]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-05-15",null,41774]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-05-16",null,41775]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-05-17",null,41776]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-05-18",null,41777]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-05-19",null,41778]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-05-20",null,41779]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-05-21",null,41780]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-05-22",null,41781]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-05-23",null,41782]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-05-24",null,41783]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-05-25",null,41784]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-05-26",null,41785]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-05-27",null,41786]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-05-28",null,41787]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-05-29",null,41788]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-05-30",null,41789]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-05-31",null,41790]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-06-01",null,41791]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-06-02",null,41792]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-06-03",null,41793]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-06-04",null,41794]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-06-05",null,41795]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-06-06",null,41796]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-06-07",null,41797]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-06-08",null,41798]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-06-09",null,41799]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-06-10",null,41800]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-06-11",null,41801]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-06-12",null,41802]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-06-13",null,41803]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-06-14",null,41804]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-06-15",null,41805]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-06-16",null,41806]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-06-17",null,41807]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-06-18",null,41808]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-06-19",null,41809]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-06-20",null,41810]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-06-21",null,41811]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-06-22",null,41812]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-06-23",null,41813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-06-24",null,41814]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-06-25",null,41815]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-06-26",null,41816]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-06-27",null,41817]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-06-28",null,41818]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-06-29",null,{"$f":"VALUE(O105)","v":41819}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-06-30",null,41820]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-07-01",null,41821]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-07-02",null,41822]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-07-03",null,41823]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-07-04",null,41824]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-07-05",null,41825]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-07-06",null,41826]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-07-07",null,41827]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-07-08",null,41828]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-07-09",null,41829]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-07-10",null,41830]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-07-11",null,41831]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-07-12",null,41832]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-07-13",null,41833]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-07-14",null,41834]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-07-15",null,41835]

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