{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Intro","Spraying economics"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":3,"defined_names":9,"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":"Intro","index":0,"n_rows":43,"n_cols":12,"rows_kept":43,"cut":false,"hidden":false,"merged":[[28,1,29,11],[30,1,31,11],[33,1,34,4],[33,6,34,8],[42,1,42,11],[4,1,5,8],[4,13,5,23],[7,2,7,3],[7,4,7,5],[7,13,8,13],[27,1,27,4]]}
[]
[]
[null,"KSU-Economics of Spraying Field Crops"]
[]
[null,"An Excel spreadsheet to analyze the economics of spraying a crop field based on the anticipated yield response."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Version- 7.8.16"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"INSTRUCTIONS FOR THE USER:"]
[null,"Be sure to \"Enable Content\" and \"Enable Macros\" for the spreadsheet to function correctly. This spreadsheet uses macros to print , however printing can also be done manually by highlighting the desired range and using the menu print commands."]
[]
[null,"All blue numbers are inputs and all black numbers are calculated from these inputs.  Several input cells (i.e., blue number) have a red diamond in the upper right hand corner of the cell.  By moving your mouse cursor over this diamond, a brief description of the input will be displayed on the screen."]
[]
[null,"FOR MORE INFORMATION:"]
[null,"With Questions Contact:",null,null,null,null,"Originally Developed by:"]
[]
[null,"Terry Griffin",null,null,null,null,"Doug Jardine",null,null,null,"Kevin C. Dhuyvetter, Ph.D."]
[null,"Agricultural Economist",null,null,null,null,"Extension Plant Pathologist",null,null,null,"Former Agricultural Economist"]
[null,"Kansas State University",null,null,null,null,"Kansas State University",null,null,null,"Kansas State University"]
[null,"twgriffin@ksu.edu",null,null,null,null,"jardine@k-state.edu"]
[null,"785-532-3527",null,null,null,null,"(785)-532-1386"]
[]
[]
[null,"Copyright 2016 AgManager.info, K-State Department of Agricultural Economics"]

{"sheet":"Spraying economics","index":1,"n_rows":28,"n_cols":17,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Economics of spraying field crops",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version: 7.8.2016"]
[]
[null,"INPUTS"]
[null,null,"Estimated yield without spraying, bu/ac",null,null,null,null,35,null,"Sensititivy Analysis -- Net Benefit of Spraying, $/ac"]
[null,null,"Estimated yield response with spraying, %",null,null,null,null,0.15]
[null,null,"Estimated yield response to spraying, bu/ac",null,null,null,null,{"$f":"H5*H6","v":5.25},null,null,"Crop","Estimated yield without spraying, bu/ac"]
[null,null,"Estimated yield with spraying, bu/ac",null,null,null,null,{"$f":"H5*(1+H6)","v":40.25},null,null,"price, $/bu",{"$f":"M8-P26","v":25},{"$f":"N8-P26","v":30},{"$f":"H5","v":35},{"$f":"N8+P26","v":40},{"$f":"O8+P26","v":45}]
[null,null,"Crop price, $/bu",null,null,null,null,4,null,null,{"$f":"K10-P27","v":3.5},{"$f":"(L$8*$H$6*($K9-$H$12)+$H$17)-($H$10+$H$11+$H$23)","v":-7.9},-5.3800000000000008,-2.8599999999999994,-0.33999999999999986,2.1799999999999997]
[null,null,"Chemical cost, $/ac",null,null,null,null,15,null,null,{"$f":"K11-P27","v":3.75},-6.9625000000000004,-4.254999999999999,-1.5474999999999994,1.1600000000000001,3.8674999999999997]
[null,null,"Application cost, $/ac",null,null,null,null,5.5,null,null,{"$f":"H9","v":4},-6.0250000000000004,-3.129999999999999,-0.23499999999999943,2.66,5.5549999999999997]
[null,null,"Hauling cost, $/bu",null,null,null,null,0.14000000000000001,null,null,{"$f":"K11+P27","v":4.25},-5.0874999999999986,-2.004999999999999,1.0775000000000006,4.1600000000000037,7.2425000000000033]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K12+P27","v":4.5},-4.1499999999999986,-0.87999999999999901,2.3900000000000006,5.6600000000000037,8.9300000000000033]
[null,"Partial Budget Analysis"]
[null,"Added Income, $/ac",null,null,null,null,null,null,null,"Sensititivy Analysis -- Net Benefit of Spraying, $/ac"]
[null,null,"Value of added bushels due to spraying",null,null,null,null,{"$f":"(H8-H5)*H9","v":21}]
[null,null,"Other",null,null,null,null,0,null,null,"Chemical","Estimated yield without spraying, bu/ac",null,null,null,null,"Breakeven"]
[null,null,"Total Added Income",null,null,null,null,{"$f":"H16+H17","v":21},null,null,"cost/$/ac",{"$f":"L8","v":25},{"$f":"M8","v":30},{"$f":"N8","v":35},{"$f":"O8","v":40},{"$f":"P8","v":45},"yield, bu/ac"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K20-P28","v":11},{"$f":"(L$8*$H$6*($H$9-$H$12)+$H$17)-($K19+$H$11+$H$23)","v":-2.0250000000000004},{"$f":"(M$8*$H$6*($H$9-$H$12)+$H$17)-($K19+$H$11+$H$23)","v":0.87000000000000099},{"$f":"(N$8*$H$6*($H$9-$H$12)+$H$17)-($K19+$H$11+$H$23)","v":3.7650000000000006},{"$f":"(O$8*$H$6*($H$9-$H$12)+$H$17)-($K19+$H$11+$H$23)","v":6.66},{"$f":"(P$8*$H$6*($H$9-$H$12)+$H$17)-($K19+$H$11+$H$23)","v":9.5549999999999997},{"$f":"(K19+H$11+H$23)/(H$9-H$12)","v":4.2746113989637307}]
[null,"Added Cost, $/ac",null,null,null,null,null,null,null,null,{"$f":"K21-P28","v":13},{"$f":"(L$8*$H$6*($H$9-$H$12)+$H$17)-($K20+$H$11+$H$23)","v":-4.0250000000000004},-1.129999999999999,1.7650000000000006,4.66,7.5549999999999997,{"$f":"(K20+H$11+H$23)/(H$9-H$12)","v":4.7927461139896375}]
[null,null,"Chemical cost + application cost",null,null,null,null,{"$f":"H10+H11","v":20.5},null,null,{"$f":"H10","v":15},-6.0250000000000004,-3.129999999999999,-0.23499999999999943,2.66,5.5549999999999997,{"$f":"(K21+H$11+H$23)/(H$9-H$12)","v":5.3108808290155443}]
[null,null,"Increased harvest and hauling cost",null,null,null,null,{"$f":"(H8-H5)*H12","v":0.7350000000000001},null,null,{"$f":"K21+P28","v":17},-8.0250000000000004,-5.129999999999999,-2.2349999999999994,0.66000000000000014,3.5549999999999997,{"$f":"(K22+H$11+H$23)/(H$9-H$12)","v":5.8290155440414511}]
[null,null,"Other",null,null,null,null,0,null,null,{"$f":"K22+P28","v":19},-10.025,-7.129999999999999,-4.2349999999999994,-1.3399999999999999,1.5549999999999997,{"$f":"(K23+H$11+H$23)/(H$9-H$12)","v":6.3471502590673579}]
[null,null,"Total Added Costs",null,null,null,null,{"$f":"SUM(H21:H23)","v":21.234999999999999}]
[]
[null,"Net Benefit of Spraying, $/ac",null,null,null,null,null,{"$f":"H18-H24","v":-0.23499999999999943},null,null,"Increment for crop yield, bu/ac",null,null,null,null,5]
[null,"Yield Response to Breakeven, bu/ac",null,null,null,null,null,{"$f":"(H10+H11+H23)/(H9-H12)","v":5.3108808290155443},null,null,"Increment for crop price, $/bu",null,null,null,null,0.25]
[null,"Yield Response to Breakeven, %",null,null,null,null,null,{"$f":"H27/H5","v":0.15173945225758698},null,null,"Increment for chemical cost, $/ac",null,null,null,null,2]