{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","Inputs","Results","Fields","Notes","Ammortization"],"not_rendered":{"charts":12,"images":6,"macros":1,"external_links":3,"defined_names":18,"comments":4,"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":"Instructions","index":0,"n_rows":58,"n_cols":11,"rows_kept":58,"cut":false,"hidden":false,"merged":[[29,1,35,10],[4,1,5,8],[4,12,5,22],[7,2,7,3],[7,4,7,5],[7,12,8,12],[36,1,36,4],[38,1,38,10],[39,1,39,10],[40,1,40,10],[43,1,44,10],[49,10,49,11],[49,1,49,3],[49,4,49,5],[49,7,49,8],[55,1,55,5],[55,6,55,8]]}
[]
[]
[null,"KSU-Guidance & Section Control Profit Calculator"]
[]
[null,"A computer spreadsheet program to analyze the economics of investing in machine guidance and section control technologies."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Version- 5.20.2016"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"How the Calculator Works:"]
[null,"This spreadsheet examines:"]
[null,"1) economics of guidance systems in the context of overlap, which impacts machine and crop input usage per land acre"]
[null,"2) economics of boom/machine section control, which impacts crop input usage and reduced yield on headlands"]
[]
[null,"Typical uses would involve crop spraying, planting, tillage, etc. Dollar-valued calculations generally are on a per \"applied\" acre basis. A farm with 3,000 acres that sprays each acre three times a year would have 9,000 applied acres. Per-applied acre benefits are used along with user-entered information on total acres of use, total investment, ammortization years, and interest rate to calculate three results: (a) net benefits per acre (no salvage value of technology is considered). (b) years for payback, and (c) return on investment (ROI). Each of these three individual measures is calculated, holding the other two at user-entered values. If you use the same technology for different machine operation, you need to allocate the investment across the different machines."]
[]
[]
[]
[]
[]
[]
[null,"INSTRUCTIONS FOR THE USER:"]
[null,"Be sure to \"Enable Content\" and \"Enable Macros\" for the spreadsheet to function correctly."]
[null,"The user inputs information for a field of interest (or an average for their farm).  Users can enter individual field information (size and shape) in the Fields tab to determine an average for their entire farm.  Even if individual field information is entered in the Fields tab, the user must still enter values for a typical or average field in the Inputs tab."]
[null,"In the Inputs and Fields tabs, blue shaded numbers are inputs and all other numbers are calculated from these inputs.  The spreadsheet automatically recalculates every time an additional input is entered.  Thus, it is important to wait until all data have been entered and reviewed before interpreting any of the calculated results (i.e., black numbers)."]
[null,"Several of the input cells and calculated values have a red diamond in the upper right hand corner of the cell (if the comments do not appear go to View / Comments on the Excel menu -- you may need to click and then again).  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,"For additional assistance in using this spreadsheet, please download the written tutorial and/or watch the instruction video available through the link below:"]
[]
[]
[]
[]
[null,"Developers:"]
[null,"Kevin C. Dhuyvetter",null,null,"Craig M. Smith",null,null,"Terry L. Kastens",null,null,"Dietrich L. Kastens"]
[null,"Former Agricultural Economist",null,null,"Associate Professor",null,null,"Professor Emeritus",null,null,"Geographer"]
[null,"Kansas State University",null,null,"Fort Hays State Univ.",null,null,"Kansas State Univ.",null,null,"Kastens Inc."]
[null,null,null,null,"cmsmith11@fhsu.edu",null,null,"terrykastens@gmail.com",null,null,"dietrich@kastensinc.com"]
[]
[null,"ACKNOWLEDGEMENTS:"]
[null,"This project was sponsored by PrecisionAg Institute ",null,null,null,null,"www.precisionagworks.com"]
[]
[null,"Copyright 2016 AgManager.info, K-State Department of Agricultural Economics"]

{"sheet":"Inputs","index":1,"n_rows":447,"n_cols":9,"rows_kept":447,"cut":false,"hidden":false,"merged":[[185,1,185,8],[139,1,139,8],[149,3,149,8],[142,3,142,8],[156,3,156,8]]}
[]
[null,"Economic Analysis of Guidance Systems and Section Controls"]
[]
[null,"Section A:  Whole-farm information -- INPUTS"]
[null,"Size of typical field",null,null,null,"acres",80]
[null,"Maximum width of field, perpendicular to direction of swaths (passes)",null,null,null,"feet",2000]
[null,"Running distance of headlands to cover for field",null,null,null,"feet",6000]
[null,"Calculated average angle of approach to headland in degrees (0-90)",null,null,null,{"$f":"Inputs!C372","v":"degrees"},{"$f":"IF(ISNUMBER(DEGREES(ASIN(2*G6/G7))),DEGREES(ASIN(2*G6/G7)),\"n/a\")","v":41.810314895778596}]
[null,"Interest rate for investment analysis, percent",null,null,null,"interest",0.06]
[null,"Number of years for amortization",null,null,null,"years",5]
[null,"Annual non-ownership costs for current technology (e.g., subscriptions, fees, support)",null,null,null,"$/farm",0]
[null,"Annual non-ownership costs for new technology (e.g., subscriptions, fees, support)",null,null,null,"$/farm",3000]
[]
[null,"Cost and income categories to include in net benefits total"]
[null,"   Machine costs",null,null,null,null,1]
[null,"   Input costs",null,null,null,null,1]
[null,"   Yield revenue",null,null,null,null,1]
[null,"   Non-ownership costs",null,null,null,null,0]
[]
[null,"Section B:  Equipment-specific information -- INPUTS",null,null,null,null,null,null,"Farm"]
[null,"Implement/farming operation",null,"Sprayer","Planter","Fertilizer","Other 1","Other 2","Total/Avg"]
[null,"Include in whole-farm analysis (1=Yes, 0=No)",null,1,1,1,0,0]
[null,"Number of swaths (passes) needed to cover headlands","count",2,1,2,2,2,{"$f":"(SUMPRODUCT(D23:H23,$D$36:$H$36,$D$22:$H$22))/$I$36","v":1.8}]
[null,"Width of machine","feet",90,40,48,60,90,63.2]
[null,"Turnaround speed is this portion of field speed","percent",0.67,0.75,0.67,0.5,0.5,0.68600000000000005]
[null,{"$f":"Inputs!B367","v":"Area in headlands"},{"$f":"Inputs!C367","v":"acres"},{"$f":"D367","v":24.266528925619834},{"$f":"E367","v":5.5096418732782366},{"$f":"F367","v":13.041322314049587},{"$f":"G367","v":16.15702479338843},{"$f":"H367","v":24.266528925619834},16.025068870523416]
[null,"Number of machine or boom sections to be controlled","count",5,8,4,5,5,5.2]
[null,"Reaction distance (overlap) on manual shutoff of boom","feet",15,10,15,15,15,14]
[]
[null,"Custom rate of machine operation, $/ application acre",null,5,15,7.5,6,6,{"$f":"(SUMPRODUCT(D30:H30,$D$36:$H$36,$D$22:$H$22))/$I$36","v":8}]
[null,"Cost of input (fertilizer, herbicide, etc.), $/application acre",null,15,60,35,15,15,{"$f":"(SUMPRODUCT(D31:H31,$D$36:$H$36,$D$22:$H$22))/$I$36","v":32}]
[null,"Lost yield revenue for doubling up, $/doubled-up acre",null,0,50,0,0,0,{"$f":"(SUMPRODUCT(D32:H32,$D$36:$H$36,$D$22:$H$22))/$I$36","v":10}]
[null,"Current overlap to consider","percent",7.0000000000000007E-2,0.02,0.04,7.0000000000000007E-2,7.0000000000000007E-2,{"$f":"(SUMPRODUCT(D33:H33,$D$36:$H$36,$D$22:$H$22))/$I$36","v":4.8000000000000001E-2}]
[null,"Expected overlap to consider","percent",1.4999999999999999E-2,0,1.4999999999999999E-2,0.02,1.4999999999999999E-2,{"$f":"(SUMPRODUCT(D34:H34,$D$36:$H$36,$D$22:$H$22))/$I$36","v":1.2E-2}]
[]
[null,"Total acres of use annually","acres",10000,5000,10000,7500,10000,{"$f":"SUMPRODUCT(D36:H36,$D$22:$H$22)","v":25000}]
[null,"Expected autoguidance investment"]
[null,"autoguidance","dollars",15000,7500,7500,5000,15000,{"$f":"SUMPRODUCT(D38:H38,$D$22:$H$22)","v":30000}]
[null,"boom section/control","dollars",10000,20000,10000,10000,10000,{"$f":"SUMPRODUCT(D39:H39,$D$22:$H$22)","v":40000}]
[null,"autoguidance, $/acre",null,{"$f":"IF(D36=0,\"n/a\",D38/D36)","v":1.5},{"$f":"IF(E36=0,\"n/a\",E38/E36)","v":1.5},{"$f":"IF(F36=0,\"n/a\",F38/F36)","v":0.75},{"$f":"IF(G36=0,\"n/a\",G38/G36)","v":0.66666666666666663},{"$f":"IF(H36=0,\"n/a\",H38/H36)","v":1.5},{"$f":"I38/I36","v":1.2}]
[null,"boom/section control, $/acre",null,{"$f":"IF(D36=0,\"n/a\",D39/D36)","v":1},{"$f":"IF(E36=0,\"n/a\",E39/E36)","v":4},{"$f":"IF(F36=0,\"n/a\",F39/F36)","v":1},{"$f":"IF(G36=0,\"n/a\",G39/G36)","v":1.3333333333333333},{"$f":"IF(H36=0,\"n/a\",H39/H36)","v":1},{"$f":"I39/I36","v":1.6}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Section C:  Summed net benefits to overlap-reducing technology -- OUTPUT"]
[]
[null,null,null,{"$f":"D21","v":"Sprayer"},"Planter","Fertilizer","Other 1","Other 2","Total/Avg"]
[null,"Sub-section C1","overlap %","Sum of net annual benefits, $/applied acre"]
[null,null,{"$f":"C252","v":"High"},{"$f":"IF(D$36=0,\"n/a\",D277*$G$15+D296*$G$16+D315*$G$17-D328*$G$18)","v":0},0,0,0,0,{"$f":"(SUMPRODUCT(D144:H144,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0}]
[null,null,{"$f":"C253","v":"|"},0.25209865715753121,0.36506534171707594,0.25387693982131765,0.25194372671946663,0.26209724743705998,{"$f":"(SUMPRODUCT(D145:H145,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0.27540330713495476}]
[null,null,{"$f":"C254","v":"to"},0.49692078535585527,0.7264358421241508,0.50448345637943781,0.49725709753997016,0.51661253910525051,{"$f":"(SUMPRODUCT(D146:H146,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0.54584886511894748}]
[null,null,{"$f":"C255","v":"|"},0.73477551077383119,1.0841672047693214,0.75188220512117443,0.73619714841010264,0.76386801567895546,{"$f":"(SUMPRODUCT(D147:H147,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0.8114965273118665}]
[null,null,{"$f":"C256","v":"Low"},0.96595469873769257,1.4383140191297725,0.9961342512535527,0.9690078011994494,1.004167830282209,{"$f":"(SUMPRODUCT(D148:H148,$D$36:$H$36,$D$22:$H$22))/$I$36","v":1.0724983838224527}]
[]
[null,"Sub-section C2","overlap %","Investment supported by net annual benefits, $/applied acre"]
[null,null,{"$f":"C252","v":"High"},{"$f":"IF(D$36=0,\"n/a\",(1-(1+$G$9)^(-$G$10))/$G$9*D144)","v":0},0,0,0,0,{"$f":"(1-(1+$G$9)^(-$G$10))/$G$9*I144","v":0}]
[null,null,{"$f":"C253","v":"|"},1.0619312538001324,1.5377880248141849,1.0694220272935659,1.0612786304335475,1.1040489534003288,{"$f":"(1-(1+$G$9)^(-$G$10))/$G$9*I145","v":1.1600989174003165}]
[null,null,{"$f":"C254","v":"to"},2.0932111205278807,3.0600120339007089,2.1250678420697668,2.0946277897928907,2.1761599508961109,{"$f":"(1-(1+$G$9)^(-$G$10))/$G$9*I146","v":2.2993139918192012}]
[null,null,{"$f":"C255","v":"|"},3.0951417521042401,4.5669066708683026,3.1672013718637309,3.1011302069994673,3.217689966197979,{"$f":"(1-(1+$G$9)^(-$G$10))/$G$9*I147","v":3.4183185837608487}]
[null,null,{"$f":"C256","v":"Low"},4.0689525914597002,6.0587018864537328,4.196079845542088,4.0818133697032266,4.22992020291088,{"$f":"(1-(1+$G$9)^(-$G$10))/$G$9*I148","v":4.5177533520914626}]
[]
[null,"Sub-section C3","overlap %","Investment supported by net annual benefits"]
[null,null,{"$f":"C252","v":"High"},{"$f":"IF(D$36=0,\"n/a\",D$36*D151)","v":0},0,0,0,0,{"$f":"I$36*I151","v":0}]
[null,null,{"$f":"C253","v":"|"},10619.312538001324,7688.940124070924,10694.22027293566,7959.5897282516062,11040.489534003289,{"$f":"I$36*I152","v":29002.472935007911}]
[null,null,{"$f":"C254","v":"to"},20932.111205278808,15300.060169503544,21250.67842069767,15709.70842344668,21761.59950896111,{"$f":"I$36*I153","v":57482.849795480026}]
[null,null,{"$f":"C255","v":"|"},30951.4175210424,22834.533354341514,31672.013718637307,23258.476552496006,32176.899661979791,{"$f":"I$36*I154","v":85457.964594021221}]
[null,null,{"$f":"C256","v":"Low"},40689.525914597005,30293.509432268664,41960.798455420882,30613.600272774198,42299.202029108797,{"$f":"I$36*I155","v":112943.83380228656}]
[]
[null,"Sub-section C4","overlap %","Payback in years for given investment"]
[null,null,{"$f":"C252","v":"High"},"n/a","n/a","n/a","n/a","n/a","n/a"]
[null,null,{"$f":"C253","v":"|"},{"$f":"IF(D$36=0,\"n/a\",IF(D145<D$40*$G$9,\"won't pay\",-LN(1-D$40*$G$9/D145)/LN(1+$G$9)))","v":7.578919480419831},4.8579540854738044,3.3483446513145361,2.9670189821317949,7.2192171218767829,{"$f":"IF(I145<I$40*$G$9,\"won't pay\",-LN(1-I$40*$G$9/I145)/LN(1+$G$9))","v":5.2008156958524117}]
[null,null,{"$f":"C254","v":"to"},3.4291373959170532,2.2699336140343735,1.6034642235663654,1.439213201957978,3.2850616250076801,{"$f":"IF(I146<I$40*$G$9,\"won't pay\",-LN(1-I$40*$G$9/I146)/LN(1+$G$9))","v":2.4276019111882072}]
[null,null,{"$f":"C255","v":"|"},2.2424105470055267,1.4872770792027383,1.0591519869075727,0.95874575158149122,2.1514175334695205,{"$f":"IF(I147<I$40*$G$9,\"won't pay\",-LN(1-I$40*$G$9/I147)/LN(1+$G$9))","v":1.5945128276329337}]
[null,null,{"$f":"C256","v":"Low"},1.6784690963950202,1.1089390969653119,0.79333591982573393,0.72346518571323815,1.6114987321695011,{"$f":"IF(I148<I$40*$G$9,\"won't pay\",-LN(1-I$40*$G$9/I148)/LN(1+$G$9))","v":1.1926189705684482}]
[]
[null,"Sub-section C5","overlap %","Sum of annual net benefits including cost of investment, $/applied acre"]
[null,null,{"$f":"C252","v":"High"},"n/a","n/a","n/a","n/a","n/a","n/a"]
[null,null,{"$f":"C253","v":"|"},{"$f":"IF(D$36=0,\"n/a\",D278*$G$15+D297*$G$16+D316*$G$17-D329*$G$18-(-PMT($G$9,$G$10,D$40)))","v":-0.10399594348925323},8.9707410702914991E-3,7.5829639497925427E-2,9.3679459765340228E-2,-9.3997353209724466E-2,{"$f":"(SUMPRODUCT(D173:H173,$D$36:$H$36,$D$22:$H$22))/$I$36","v":-9.47237338247282E-3}]
[null,null,{"$f":"C254","v":"to"},0.14082618470907082,0.37034124147736636,0.32643615605604559,0.33899283058584373,0.16051793845846607,{"$f":"(SUMPRODUCT(D174:H174,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0.2609731846015198}]
[null,null,{"$f":"C255","v":"|"},0.37868091012704674,0.72807260412253694,0.57383490479778221,0.57793288145597621,0.40777341503217102,{"$f":"(SUMPRODUCT(D175:H175,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0.52662084679443899}]
[null,null,{"$f":"C256","v":"Low"},0.60986009809090813,1.0822194184829881,0.81808695093016048,0.81074353424532297,0.64807322963542457,{"$f":"(SUMPRODUCT(D176:H176,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0.78762270330502504}]
[]
[null,"Sub-section C6","overlap %","ROI given benefits, years, and investment, %"]
[null,null,{"$f":"C252","v":"High"},"n/a","n/a","n/a","n/a","n/a","n/a"]
[null,null,{"$f":"C253","v":"|"},{"$f":"IF(D$36=0,\"n/a\",RATE($G$10,D145,-D$40,0,0,D145/D$40))","v":-5.5319544650773274E-2},6.9212858713411082E-2,0.20559157041682352,0.25793879685452281,-4.3396645783631532E-2,{"$f":"RATE($G$10,I145,-I$40,0,0,I145/I$40)","v":4.7691386626036066E-2}]
[null,null,{"$f":"C254","v":"to"},0.19578107706676581,0.39144030442788857,0.61057466508685132,0.69211829473613862,0.21356056493006217,{"$f":"RATE($G$10,I146,-I$40,0,0,I146/I$40)","v":0.35545643929655063}]
[null,null,{"$f":"C255","v":"|"},0.39817398872415122,0.66655629522630033,0.96860184669900296,1.0756319284228388,0.42150915598453753,{"$f":"RATE($G$10,I147,-I$40,0,0,I147/I$40)","v":0.61462315538535373}]
[null,null,{"$f":"C256","v":"Low"},0.57819449222461794,0.92235019720790923,1.3078938890242711,1.4365874887792638,0.60697564164851492,{"$f":"RATE($G$10,I148,-I$40,0,0,I148/I$40)","v":0.85281769073447466}]
[]
[]
[null,"Section D:  Section control on headlands analysis (affects applied input amounts and yield loss only, not machine operation cost) -- OUTPUT"]
[null,"Sub-section D1"]
[null,"Input cost and yield revenue savings relative to manual whole boom control, expressed as $/applied acre in whole field and associated with:"]
[null,"   automatic control of whole boom","$/acre",{"$f":"IF(D$36=0,\"n/a\",($G$16*D$31+$G$17*D$32)*(D$347-D348)-$G$18*$G$12/$I$36*D39/(D38+D39))","v":0.26972789849599726},{"$f":"IF(E$36=0,\"n/a\",($G$16*E$31+$G$17*E$32)*(E$347-E348)-$G$18*$G$12/$I$36*E39/(E38+E39))","v":1.2753800632588512},{"$f":"IF(F$36=0,\"n/a\",($G$16*F$31+$G$17*F$32)*(F$347-F348)-$G$18*$G$12/$I$36*F39/(F38+F39))","v":0.61965766569645975},{"$f":"IF(G$36=0,\"n/a\",($G$16*G$31+$G$17*G$32)*(G$347-G348)-$G$18*$G$12/$I$36*G39/(G38+G39))","v":0.27043399247111777},{"$f":"IF(H$36=0,\"n/a\",($G$16*H$31+$G$17*H$32)*(H$347-H348)-$G$18*$G$12/$I$36*H39/(H38+H39))","v":0.26972789849599726},{"$f":"(SUMPRODUCT(D189:H189,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0.61083023832875305}]
[null,"   manual control of boom sections","$/acre",{"$f":"IF(D$36=0,\"n/a\",($G$16*D$31+$G$17*D$32)*(D$347-D349)-$G$18*$G$12/$I$36*D39/(D38+D39))","v":0.72375589975825572},{"$f":"IF(E$36=0,\"n/a\",($G$16*E$31+$G$17*E$32)*(E$347-E349)-$G$18*$G$12/$I$36*E39/(E38+E39))","v":2.4953569537704259},{"$f":"IF(F$36=0,\"n/a\",($G$16*F$31+$G$17*F$32)*(F$347-F349)-$G$18*$G$12/$I$36*F39/(F38+F39))","v":0.83135799796567411},{"$f":"IF(G$36=0,\"n/a\",($G$16*G$31+$G$17*G$32)*(G$347-G349)-$G$18*$G$12/$I$36*G39/(G38+G39))","v":0.48376703247366837},{"$f":"IF(H$36=0,\"n/a\",($G$16*H$31+$G$17*H$32)*(H$347-H349)-$G$18*$G$12/$I$36*H39/(H38+H39))","v":0.72375589975825572},{"$f":"(SUMPRODUCT(D190:H190,$D$36:$H$36,$D$22:$H$22))/$I$36","v":1.1211169498436571}]
[null,"   automatic control of boom sections","$/acre",{"$f":"IF(D$36=0,\"n/a\",($G$16*D$31+$G$17*D$32)*(D$347-D350)-$G$18*$G$12/$I$36*D39/(D38+D39))","v":0.99348379825425281},{"$f":"IF(E$36=0,\"n/a\",($G$16*E$31+$G$17*E$32)*(E$347-E350)-$G$18*$G$12/$I$36*E39/(E38+E39))","v":3.7707370170292767},{"$f":"IF(F$36=0,\"n/a\",($G$16*F$31+$G$17*F$32)*(F$347-F350)-$G$18*$G$12/$I$36*F39/(F38+F39))","v":1.4510156636621341},{"$f":"IF(G$36=0,\"n/a\",($G$16*G$31+$G$17*G$32)*(G$347-G350)-$G$18*$G$12/$I$36*G39/(G38+G39))","v":0.75420102494478602},{"$f":"IF(H$36=0,\"n/a\",($G$16*H$31+$G$17*H$32)*(H$347-H350)-$G$18*$G$12/$I$36*H39/(H38+H39))","v":0.99348379825425281},{"$f":"(SUMPRODUCT(D191:H191,$D$36:$H$36,$D$22:$H$22))/$I$36","v":1.7319471881724102}]
[null,"Sub-section D2"]
[null,"Investment supported by annual input savings on given acres for:"]
[null,"   automatic control of whole boom","$/acre",{"$f":"IF(D$36=0,\"n/a\",(1-(1+$G$9)^(-$G$10))/$G$9*D189)","v":1.136192031581285},5.3723647913041006,2.6102235104279559,1.1391663562712888,1.136192031581285,{"$f":"(1-(1+$G$9)^(-$G$10))/$G$9*I189","v":2.5730391750645167}]
[null,"   manual control of boom sections","$/acre",3.0487231417312093,10.511351264122132,3.5019823234710241,2.0378027282426756,3.0487231417312093,{"$f":"(1-(1+$G$9)^(-$G$10))/$G$9*I190","v":4.7225524389053195}]
[null,"   automatic control of boom sections","$/acre",4.1849151733124934,15.88371605542623,6.1122058338989813,3.176969084513964,4.1849151733124934,{"$f":"(1-(1+$G$9)^(-$G$10))/$G$9*I191","v":7.2955916139698367}]
[null,"Sub-section D3"]
[null,"Investment supported by annual input savings on given acres for:"]
[null,"   automatic control of whole boom","$/farm",{"$f":"IF(D$36=0,\"n/a\",D$36*D194)","v":11361.920315812849},26861.823956520504,26102.23510427956,8543.7476720346658,11361.920315812849,{"$f":"I$36*I194","v":64325.979376612915}]
[null,"   manual control of boom sections",{"$f":"C199","v":"$/farm"},30487.231417312094,52556.756320610657,35019.823234710238,15283.520461820068,30487.231417312094,{"$f":"I$36*I195","v":118063.81097263299}]
[null,"   automatic control of boom sections",{"$f":"C200","v":"$/farm"},41849.151733124934,79418.580277131157,61122.058338989817,23827.26813385473,41849.151733124934,{"$f":"I$36*I196","v":182389.79034924592}]
[null,"Sub-section D4"]
[null,"Payback in years for given investment"]
[null,"   automatic control of whole boom","years",{"$f":"IF(D$36=0,\"n/a\",IF(D189<D$41*$G$9,\"won't pay\",-LN(1-D$41*$G$9/D189)/LN(1+$G$9)))","v":4.3179580070875909},3.5778197934928468,1.7477912522729795,6.0190317795990289,4.3179580070875909,{"$f":"IF(I189<I$41*$G$9,\"won't pay\",-LN(1-I$41*$G$9/I189)/LN(1+$G$9))","v":2.9343585064388362}]
[null,"   manual control of boom sections","years",1.4851783266763137,1.7354629610737888,1.2855554207858628,3.102261556833656,1.4851783266763137,{"$f":"IF(I190<I$41*$G$9,\"won't pay\",-LN(1-I$41*$G$9/I190)/LN(1+$G$9))","v":1.5363040838601889}]
[null,"   automatic control of boom sections","years",1.0690803929795702,1.1286266356730212,0.72473634200104009,1.9243645432691874,1.0690803929795702,{"$f":"IF(I191<I$41*$G$9,\"won't pay\",-LN(1-I$41*$G$9/I191)/LN(1+$G$9))","v":0.97864132180774666}]
[null,"Sub-section D5"]
[null,"Sum of annual net benefits including cost of investment, $/applied acre"]
[null,"   automatic control of whole boom","$/acre",{"$f":"IF(D$36=0,\"n/a\",D189-(-PMT($G$9,$G$10,D$41)))","v":3.2331498064807673E-2},0.32579446153409286,0.38226126526527016,-4.6094541437135039E-2,3.2331498064807673E-2,{"$f":"I189-(-PMT($G$9,$G$10,I$41))","v":0.23099599763884965}]
[null,"   manual control of boom sections","$/acre",0.48635949932706612,1.5457713520456675,0.59396159753448452,0.16723849856541556,0.48635949932706612,{"$f":"I190-(-PMT($G$9,$G$10,I$41))","v":0.74128270915375372}]
[null,"   automatic control of boom sections","$/acre",0.75608739782306322,2.8211514153045183,1.2136192632309446,0.43767249103653322,0.75608739782306322,{"$f":"I191-(-PMT($G$9,$G$10,I$41))","v":1.3521129474825069}]
[null,"Sub-section D6"]
[null,"       ROI given benefits, years, and investment, %"]
[null,"   automatic control of whole boom","%",{"$f":"IF(ISNUMBER(RATE($G$10,D189,-D$41,0,0,D189/D$41))=TRUE,RATE($G$10,D189,-D$41,0,0,D189/D$41),\"n/a\")","v":0.10876156098613332},0.17871149143852777,0.55050970386805576,4.6944995562622979E-3,0.10876156098613332,0.26295814336395379]
[null,"   manual control of boom sections","%",0.66764082825668802,0.55528733657670548,0.78555161074868418,0.23812056980005902,0.66764082825668802,0.64199322319159247]
[null,"   automatic control of boom sections","%",0.95905449757211747,0.90512193821158216,1.434031623070642,0.48814786993904347,0.95905449757211747,1.0527699461235205]
[]
[null,"These are needed for the listboxes:",{"$f":"D21","v":"Sprayer"}]
[null,null,{"$f":"E21","v":"Planter"}]
[null,null,{"$f":"F21","v":"Fertilizer"}]
[null,null,{"$f":"G21","v":"Other 1"}]
[null,null,{"$f":"H21","v":"Other 2"}]
[null,null,"Whole Farm"]
[]
[null,"Titles for figures:","Acres applied annually",null,"x-axis (figures 1 and 2)"]
[null,null,"Payback, years",null,"y -axis (figure 1)"]
[null,null,"Return on investment, %",null,"y1-axis (figure 2)"]
[null,null,"Net benefits, $/ac",null,"y2-axis (figure 2)"]
[null,null,"Percent of base acres applied annually"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Intermediate calculations"]
[null,null,null,{"$f":"D21","v":"Sprayer"},"Planter","Fertilizer","Other 1","Other 2","Total/Avg"]
[null,null,"Overlap %"]
[null,null,"High",{"$f":"D33","v":7.0000000000000007E-2},0.02,0.04,7.0000000000000007E-2,7.0000000000000007E-2,4.8000000000000001E-2]
[null,null,"|",{"$f":"AVERAGE(D244,D246)","v":5.6250000000000008E-2},1.4999999999999999E-2,3.3750000000000002E-2,5.7500000000000009E-2,5.6250000000000008E-2,3.9E-2]
[null,null,"to",{"$f":"AVERAGE(D244,D248)","v":4.2500000000000003E-2},0.01,2.75E-2,4.5000000000000005E-2,4.2500000000000003E-2,0.03]
[null,null,"|",{"$f":"AVERAGE(D246,D248)","v":2.8750000000000001E-2},5.0000000000000001E-3,2.1249999999999998E-2,3.2500000000000001E-2,2.8750000000000001E-2,2.0999999999999998E-2]
[null,null,"Low",{"$f":"D34","v":1.4999999999999999E-2},0,1.4999999999999999E-2,0.02,1.4999999999999999E-2,1.2E-2]
[]
[]
[null,"Section C:  Value of overlap","overlap %","Machine efficiency vs overlap percentages (includes turnaround slowdown)"]
[null,null,"High",{"$f":"$G$5/(($G$5+((1/(1-D244)-1)*D443+($G$7*D$24*D244*(D$23-1))/43560)+((D$343*(D$360/(D$24-D244*D$24)/43560)+((PI()*(D$24*(1-D244/2))^2)/2*((D$360/(D$24-D244*D$24)-1)/43560)+(D$28*D$24*(1-D244)*((D$360/(D$24-D244*D$24)*2)/43560*$C$386))+(1/D$25-1)*((D$343*(D$360/(D$24-D244*D$24)/43560)+((PI()*(D$24*(1-D244/2))^2)/2*((D$360/(D$24-D244*D$24)-1)/43560)+(D$28*D$24*(1-D244)*((D$360/(D$24-D244*D$24)*2)/43560*$C$386))))))))))","v":0.75426140571108424},0.88340184595499371,0.83215489479382854,0.75354962604980091,0.70674044379951451,{"$f":"(SUMPRODUCT(D252:H252,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0.81124688939296374}]
[null,null,"|",0.76296375239940972,0.88738923564147598,0.83680740187371117,0.7618531431164286,0.71470218967577126,{"$f":"(SUMPRODUCT(D253:H253,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0.81738630883754348}]
[null,null,"to",0.77160501004215798,0.89137152524678698,0.84145060564423302,0.77011258308186881,0.72260235353493496,{"$f":"(SUMPRODUCT(D254:H254,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0.82349655132391375}]
[null,null,"|",0.78018558943995064,0.89534871804881766,0.8460845185942355,0.778328123059149,0.73044137501915674,{"$f":"(SUMPRODUCT(D255:H255,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0.82957778682343808}]
[null,null,"Low",0.78870589935914592,0.89932081733525548,0.85070915322963758,0.78649994025166658,0.73821969167550017,{"$f":"(SUMPRODUCT(D256:H256,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0.83563018450256454}]
[null,null,"overlap %","Crop input efficiency vs overlap percentages"]
[null,null,"High",{"$f":"IF(D$36=0,\"n/a\",D$358/(D$358+((1/(1-D244)-1)*(D$358-(D$24+(D$24-D244*D$24)*(D$23-1))*D$361/43560)+(D$361*D$24*D244*(D$23-1))/43560)+(((D$24*(D$24/TAN(RADIANS(DEGREES(ASIN(2*(D$24-D244*D$24)/(D$361/(D$360/(D$24-D244*D$24)))))))))/2+D$24*D$28)*2*D$360/(D$24-D244*D$24)/43560)))","v":0.87396140841098968},0.94615824817731153,0.91891381924605176,0.88699322951290593,0.87396140841098968,{"$f":"(SUMPRODUCT(D258:H258,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0.90638174069827893}]
[null,null,"|",0.88511062889558589,0.95066952535686233,0.92443926754735728,0.89780943348738607,0.88511062889558589,{"$f":"(SUMPRODUCT(D259:H259,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0.91395386364854969}]
[null,null,"to",0.89621537942320251,0.9551778048795182,0.92995925743463292,0.90859906031038185,0.89621537942320251,{"$f":"(SUMPRODUCT(D260:H260,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0.92150541571903766}]
[null,null,"|",0.90727592552464909,0.95968308973211447,0.93547379699217548,0.919362207818192,0.90727592552464909,{"$f":"(SUMPRODUCT(D261:H261,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0.92903650695315276}]
[null,null,"Low",0.91829253062094951,0.9641853828975202,0.94098289428832438,0.93009897336749514,0.91829253062094951,{"$f":"(SUMPRODUCT(D262:H262,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0.93654724654321353}]
[null,null,"overlap %","Doubling-up of inputs on headlands field efficiency vs overlap percentages"]
[null,null,"High",{"$f":"IF(D$36=0,\"n/a\",D$358/(D$358+((((D$24*(D$24/TAN(RADIANS((DEGREES(ASIN(2*(D$24-D244*D$24)/(D$361/(D$360/(D$24-D244*D$24))))))))))/2+D$24*D$28)*2)*(D$360/(D$24-D244*D$24))/43560)))","v":0.92540322571980094},0.96348116434677467,0.9523644511033551,0.94347525720188674,0.92540322571980094,{"$f":"(SUMPRODUCT(D264:H264,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0.9438033035986173}]
[null,null,"|",0.92641008564635519,0.96365980259020823,0.9526579852950775,0.94418307823174596,0.92641008564635519,{"$f":"(SUMPRODUCT(D265:H265,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0.94435918889461468}]
[null,null,"to",0.92739012763162032,0.96383670166096169,0.95294792407807705,0.94487339137529702,0.92739012763162032,{"$f":"(SUMPRODUCT(D266:H266,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0.94490256101607129}]
[null,null,"|",0.92834440904681037,0.96401188683415739,0.95323433310881023,0.94554683828085562,0.92834440904681037,{"$f":"(SUMPRODUCT(D267:H267,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0.94543387422907976}]
[null,null,"Low",0.92927393239784717,0.9641853828975202,0.95351727645478546,0.9462040296207056,0.92927393239784717,{"$f":"(SUMPRODUCT(D268:H268,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0.94595356012055709}]
[]
[null,"Sub-section C1:  Machine operations","overlap %","Custom rate for machine operations equivalent (uses turnaround slowdown), $/applied acre"]
[null,null,"High",{"$f":"IF(D$36=0,\"n/a\",D$378/D252*D$30)","v":5.1149707793594645},15.135323680751046,7.5837798729710126,6.1318794924142654,6.1346625331088589,{"$f":"(SUMPRODUCT(D271:H271,$D$36:$H$36,$D$22:$H$22))/$I$36","v":8.1065649970823994}]
[null,"To compare different overlaps","|",5.0566295424623569,15.067314704394047,7.5416153444638976,6.0650474966736043,6.0663227059322224,{"$f":"(SUMPRODUCT(D272:H272,$D$36:$H$36,$D$22:$H$22))/$I$36","v":8.0527608956493104}]
[null,null,"to",5,15,7.5,6,5.9999999999999991,{"$f":"(SUMPRODUCT(D273:H273,$D$36:$H$36,$D$22:$H$22))/$I$36","v":8}]
[null,null,"|",4.9450093701169733,14.933369098734547,7.4589233151520569,5.9366677903530736,5.9356086189612434,{"$f":"(SUMPRODUCT(D274:H274,$D$36:$H$36,$D$22:$H$22))/$I$36","v":7.9482468938545221}]
[null,null,"Low",4.8915889349193211,14.867411741140007,7.4183750326102462,5.8749851869189911,5.873067557124199,{"$f":"(SUMPRODUCT(D275:H275,$D$36:$H$36,$D$22:$H$22))/$I$36","v":7.8974679352398285}]
[null,null,"overlap %","Advantage due to reduced overlap for machine operation (relative to topmost row), $/applied acre"]
[null,null,"High",{"$f":"IF(D$36=0,\"n/a\",D$271-D271)","v":0},0,0,0,0,{"$f":"(SUMPRODUCT(D277:H277,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0}]
[null,"To compare one % overlap with another just subtract one","|",5.8341236897107684E-2,6.800897635699954E-2,4.2164528507115051E-2,6.6831995740661121E-2,6.8339827176636447E-2,{"$f":"(SUMPRODUCT(D278:H278,$D$36:$H$36,$D$22:$H$22))/$I$36","v":5.3804101433089002E-2}]
[null,"row's values from another in same column (i.e., same field)","to",0.11497077935946454,0.13532368075104628,8.3779872971012637E-2,0.13187949241426544,0.13466253310885978,{"$f":"(SUMPRODUCT(D279:H279,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0.10656499708240014}]
[null,null,"|",0.16996140924249126,0.20195458201649963,0.12485655781895577,0.19521170206119187,0.19905391414761553,{"$f":"(SUMPRODUCT(D280:H280,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0.15831810322787876}]
[null,null,"Low",0.22338184444014342,0.26791193961103943,0.16540484036076641,0.25689430549527437,0.26159497598465986,{"$f":"(SUMPRODUCT(D281:H281,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0.20909706184257182}]
[null,null,"overlap %","Investment supported by above annual cost savings (relative to topmost row), $/applied acre"]
[null,null,"High",{"$f":"IF(D$36=0,\"n/a\",(1-(1+$G$9)^(-$G$10))/$G$9*D277)","v":0},0,0,0,0,{"$f":"(SUMPRODUCT(D283:H283,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0}]
[null,"To compare one % overlap with another just subtract one","|",0.24575451351048694,0.28647854909962006,0.17761233291882483,0.28152067857504331,0.28787221311068328,{"$f":"(SUMPRODUCT(D284:H284,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0.22664244839164871}]
[null,"row's values from another in same column (i.e., same field)","to",0.48429874737207507,0.57003257212516412,0.35291130286238986,0.5555243979046407,0.56724757774030554,{"$f":"(SUMPRODUCT(D285:H285,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0.44889053451881883}]
[null,null,"|",{"$f":"IF(D$36=0,\"n/a\",(1-(1+$G$9)^(-$G$10))/$G$9*D280)","v":0.71593928523678485},0.85070616761536488,0.52594124254696162,0.82230270428120944,0.83848749933052336,{"$f":"(SUMPRODUCT(D286:H286,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0.66689344463657152}]
[null,null,"Low",0.94096559187253503,1.1285425521382124,0.69674535949297145,1.0821322691863502,1.1019332033237152,{"$f":"(SUMPRODUCT(D287:H287,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0.88079289097384506}]
[]
[null,"Sub-section C2:  Crop input cost","overlap %","Crop input cost equivalent, $/applied acre"]
[null,null,"High",{"$f":"IF(D$36=0,\"n/a\",D$383/D258*D$31)","v":15.381950005996391},60.571969227319975,35.420703583408425,15.365377605125705,15.381950005996391,{"$f":"(SUMPRODUCT(D290:H290,$D$36:$H$36,$D$22:$H$22))/$I$36","v":32.43545528122592}]
[null,"To compare different overlaps","|",15.188192585735967,60.284532915113502,35.208991172094223,15.180265874146899,15.188192585735967,{"$f":"(SUMPRODUCT(D291:H291,$D$36:$H$36,$D$22:$H$22))/$I$36","v":32.21578008615478}]
[null,null,"to",15,60,35,15,15,{"$f":"(SUMPRODUCT(D292:H292,$D$36:$H$36,$D$22:$H$22))/$I$36","v":32}]
[null,null,"|",14.817135904465051,59.718326712174083,34.793677936106207,14.824392158776794,14.817135904465051,{"$f":"(SUMPRODUCT(D293:H293,$D$36:$H$36,$D$22:$H$22))/$I$36","v":31.787990878663319}]
[null,null,"Low",14.639377151698842,59.439470157226431,34.589974172515639,14.65326410942153,14.639377151698842,{"$f":"(SUMPRODUCT(D294:H294,$D$36:$H$36,$D$22:$H$22))/$I$36","v":31.579634561131076}]
[null,null,"overlap %","Advantage due to reduced overlap for crop input expense (relative to topmost row), $/applied acre"]
[null,null,"High",{"$f":"IF(D$36=0,\"n/a\",D$290-D290)","v":0},0,0,0,0,{"$f":"(SUMPRODUCT(D296:H296,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0}]
[null,"To compare one % overlap with another just subtract one","|",0.19375742026042353,0.28743631220647359,0.2117124113142026,0.18511173097880551,0.19375742026042353,{"$f":"(SUMPRODUCT(D297:H297,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0.21967519507114516}]
[null,"row's values from another in same column (i.e., same field)","to",0.38195000599639073,0.57196922731997546,0.42070358340842517,0.36537760512570472,0.38195000599639073,{"$f":"(SUMPRODUCT(D298:H298,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0.43545528122592148}]
[null,null,"|",0.56481410153133993,0.85364251514589284,0.62702564730221866,0.54098544634891077,0.56481410153133993,{"$f":"(SUMPRODUCT(D299:H299,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0.64746440256260207}]
[null,null,"Low",0.74257285429754916,1.1324990700935444,0.83072941089278629,0.71211349570417504,0.74257285429754916,{"$f":"(SUMPRODUCT(D300:H300,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0.85582072009484311}]
[null,null,"overlap %","Investment supported by above annual cost savings (relative to topmost row), $/applied acre"]
[null,null,"High",{"$f":"IF(D$36=0,\"n/a\",(1-(1+$G$9)^(-$G$10))/$G$9*D296)","v":0},0,0,0,0,{"$f":"(SUMPRODUCT(D302:H302,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0}]
[null,"To compare one % overlap with another just subtract one","|",0.8161767402896456,1.210786312195111,0.891809694374741,0.77975795185850416,0.8161767402896456,{"$f":"(SUMPRODUCT(D303:H303,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0.92535183630477691}]
[null,"row's values from another in same column (i.e., same field)","to",1.6089123731558055,2.409342459620671,1.772156539207377,1.53910339188825,1.6089123731558055,{"$f":"(SUMPRODUCT(D304:H304,$D$36:$H$36,$D$22:$H$22))/$I$36","v":1.8342960568694071}]
[null,null,"|",{"$f":"IF(D$36=0,\"n/a\",(1-(1+$G$9)^(-$G$10))/$G$9*D299)","v":2.3792024668674556},3.5958528166197947,2.6412601293167692,2.2788275027182578,2.3792024668674556,{"$f":"(SUMPRODUCT(D305:H305,$D$36:$H$36,$D$22:$H$22))/$I$36","v":2.7273556017976488}]
[null,null,"Low",3.1279869995871654,4.770498070048899,3.4993344860491171,2.999681100516876,3.1279869995871654,{"$f":"(SUMPRODUCT(D306:H306,$D$36:$H$36,$D$22:$H$22))/$I$36","v":3.6050282082642928}]
[]
[null,"Sub-section C3:  Lost yield revenue with doubling up of inputs","overlap %","Lost yield revenue with doubling up of inputs, $/applied acre"]
[null,null,"High",{"$f":"IF(D$36=0,\"n/a\",(1/D264-1)*D$32)","v":0},1.8951504712593215,0,0,0,{"$f":"(SUMPRODUCT(D309:H309,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0.37903009425186429}]
[null,"To compare different overlaps","|",0,1.8855304181057186,0,0,0,{"$f":"(SUMPRODUCT(D310:H310,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0.37710608362114367}]
[null,null,"to",0,1.8760075372061924,0,0,0,{"$f":"(SUMPRODUCT(D311:H311,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0.37520150744123848}]
[null,null,"|",0,1.8665803636523925,0,0,0,{"$f":"(SUMPRODUCT(D312:H312,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0.37331607273047845}]
[null,null,"Low",0,1.8572474618341328,0,0,0,{"$f":"(SUMPRODUCT(D313:H313,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0.37144949236682651}]
[null,null,"overlap %","Advantage due to reduced overlap for yield revenue (relative to topmost row), $/applied acre"]
[null,null,"High",{"$f":"IF(D$36=0,\"n/a\",D$309-D309)","v":0},0,0,0,0,{"$f":"(SUMPRODUCT(D315:H315,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0}]
[null,"To compare one % overlap with another just subtract one","|",0,9.6200531536028144E-3,0,0,0,{"$f":"(SUMPRODUCT(D316:H316,$D$36:$H$36,$D$22:$H$22))/$I$36","v":1.9240106307205627E-3}]
[null,"row's values from another in same column (i.e., same field)","to",0,1.9142934053129057E-2,0,0,0,{"$f":"(SUMPRODUCT(D317:H317,$D$36:$H$36,$D$22:$H$22))/$I$36","v":3.8285868106258114E-3}]
[null,null,"|",0,2.8570107606928907E-2,0,0,0,{"$f":"(SUMPRODUCT(D318:H318,$D$36:$H$36,$D$22:$H$22))/$I$36","v":5.7140215213857815E-3}]
[null,null,"Low",0,3.790300942518865E-2,0,0,0,{"$f":"(SUMPRODUCT(D319:H319,$D$36:$H$36,$D$22:$H$22))/$I$36","v":7.5806018850377299E-3}]
[null,null,"overlap %","Investment supported by above annual cost savings (relative to topmost row), $/applied acre"]
[null,null,"High",{"$f":"IF(D$36=0,\"n/a\",(1-(1+$G$9)^(-$G$10))/$G$9*D315)","v":0},0,0,0,0,{"$f":"(SUMPRODUCT(D321:H321,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0}]
[null,"To compare one % overlap with another just subtract one","|",0,4.0523163519453786E-2,0,0,0,{"$f":"(SUMPRODUCT(D322:H322,$D$36:$H$36,$D$22:$H$22))/$I$36","v":8.1046327038907569E-3}]
[null,"row's values from another in same column (i.e., same field)","to",0,8.0637002154873627E-2,0,0,0,{"$f":"(SUMPRODUCT(D323:H323,$D$36:$H$36,$D$22:$H$22))/$I$36","v":1.6127400430974725E-2}]
[null,null,"|",{"$f":"IF(D$36=0,\"n/a\",(1-(1+$G$9)^(-$G$10))/$G$9*D318)","v":0},0.12034768663314299,0,0,0,{"$f":"(SUMPRODUCT(D324:H324,$D$36:$H$36,$D$22:$H$22))/$I$36","v":2.4069537326628598E-2}]
[null,null,"Low",0,0.15966126426662078,0,0,0,{"$f":"(SUMPRODUCT(D325:H325,$D$36:$H$36,$D$22:$H$22))/$I$36","v":3.1932252853324156E-2}]
[]
[null,"Sub-section C4:  Non-ownership costs of technology","overlap %","Non-ownership costs of technology, $/applied acre"]
[null,null,"High",{"$f":"IF(D$36=0,\"n/a\",$G11/$I36*D38/(D38+D39))","v":0},{"$f":"IF(E$36=0,\"n/a\",$G11/$I36*E38/(E38+E39))","v":0},{"$f":"IF(F$36=0,\"n/a\",$G11/$I36*F38/(F38+F39))","v":0},{"$f":"IF(G$36=0,\"n/a\",$G11/$I36*G38/(G38+G39))","v":0},{"$f":"IF(H$36=0,\"n/a\",$G11/$I36*H38/(H38+H39))","v":0},{"$f":"(SUMPRODUCT(D328:H328,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0}]
[null,null,"|",{"$f":"IF(D$36=0,\"n/a\",(D328+D330)/2)","v":1.7999999999999999E-2},{"$f":"IF(E$36=0,\"n/a\",(E328+E330)/2)","v":8.1818181818181825E-3},{"$f":"IF(F$36=0,\"n/a\",(F328+F330)/2)","v":1.2857142857142857E-2},{"$f":"IF(G$36=0,\"n/a\",(G328+G330)/2)","v":0.01},{"$f":"IF(H$36=0,\"n/a\",(H328+H330)/2)","v":1.7999999999999999E-2},{"$f":"(SUMPRODUCT(D329:H329,$D$36:$H$36,$D$22:$H$22))/$I$36","v":1.3979220779220777E-2}]
[null,null,"to",{"$f":"IF(D$36=0,\"n/a\",(D328+D332)/2)","v":3.5999999999999997E-2},{"$f":"IF(E$36=0,\"n/a\",(E328+E332)/2)","v":1.6363636363636365E-2},{"$f":"IF(F$36=0,\"n/a\",(F328+F332)/2)","v":2.5714285714285714E-2},{"$f":"IF(G$36=0,\"n/a\",(G328+G332)/2)","v":0.02},{"$f":"IF(H$36=0,\"n/a\",(H328+H332)/2)","v":3.5999999999999997E-2},{"$f":"(SUMPRODUCT(D330:H330,$D$36:$H$36,$D$22:$H$22))/$I$36","v":2.7958441558441554E-2}]
[null,null,"|",{"$f":"IF(D$36=0,\"n/a\",(D330+D332)/2)","v":5.3999999999999992E-2},{"$f":"IF(E$36=0,\"n/a\",(E330+E332)/2)","v":2.4545454545454547E-2},{"$f":"IF(F$36=0,\"n/a\",(F330+F332)/2)","v":3.8571428571428569E-2},{"$f":"IF(G$36=0,\"n/a\",(G330+G332)/2)","v":0.03},{"$f":"IF(H$36=0,\"n/a\",(H330+H332)/2)","v":5.3999999999999992E-2},{"$f":"(SUMPRODUCT(D331:H331,$D$36:$H$36,$D$22:$H$22))/$I$36","v":4.1937662337662329E-2}]
[null,null,"Low",{"$f":"IF(D$36=0,\"n/a\",$G12/$I36*D38/(D38+D39))","v":7.1999999999999995E-2},{"$f":"IF(E$36=0,\"n/a\",$G12/$I36*E38/(E38+E39))","v":3.272727272727273E-2},{"$f":"IF(F$36=0,\"n/a\",$G12/$I36*F38/(F38+F39))","v":5.1428571428571428E-2},{"$f":"IF(G$36=0,\"n/a\",$G12/$I36*G38/(G38+G39))","v":0.04},{"$f":"IF(H$36=0,\"n/a\",$G12/$I36*H38/(H38+H39))","v":7.1999999999999995E-2},{"$f":"(SUMPRODUCT(D332:H332,$D$36:$H$36,$D$22:$H$22))/$I$36","v":5.5916883116883108E-2}]
[]
[]
[]
[null,"Section D:  Boom/nozzle/machine section shutoff on headlands analysis (affects applied input amounts and yield loss only, not machine operation cost):"]
[null,null,null,{"$f":"D21","v":"Sprayer"},"Planter","Fertilizer","Other 1","Other 2","Total/Avg"]
[null,"Typical overlap in distance traveled before manually shut off boom","feet",{"$f":"D28","v":15},10,15,15,15,14]
[null,"Width of whole machine or boom","feet",{"$f":"D24","v":90},40,48,60,90,63.2]
[null,"Width of section of machine or boom","feet",{"$f":"IF(D36=0,\"n/a\",D24/D27)","v":18},{"$f":"IF(E36=0,\"n/a\",E24/E27)","v":5},{"$f":"IF(F36=0,\"n/a\",F24/F27)","v":12},{"$f":"IF(G36=0,\"n/a\",G24/G27)","v":12},{"$f":"IF(H36=0,\"n/a\",H24/H27)","v":18},{"$f":"I24/I27","v":12.153846153846153}]
[null,"Distance into headland before whole boom can theoretically be shut off","feet",{"$f":"IF(D36=0,\"n/a\",D339/TAN(RADIANS(D372)))","v":100.62305898749051},{"$f":"IF(E36=0,\"n/a\",E339/TAN(RADIANS(E372)))","v":44.721359549995782},{"$f":"IF(F36=0,\"n/a\",F339/TAN(RADIANS(F372)))","v":53.665631459994941},{"$f":"IF(G36=0,\"n/a\",G339/TAN(RADIANS(G372)))","v":67.082039324993687},{"$f":"IF(H36=0,\"n/a\",H339/TAN(RADIANS(H372)))","v":100.62305898749051},{"$f":"I339/TAN(RADIANS(I372))","v":70.659748088993339}]
[null,"Distance into headland before boom section can theoretically be shut off","feet",{"$f":"IF(D36=0,\"n/a\",D340/TAN(RADIANS(D372)))","v":20.124611797498101},{"$f":"IF(E36=0,\"n/a\",E340/TAN(RADIANS(E372)))","v":5.5901699437494727},{"$f":"IF(F36=0,\"n/a\",F340/TAN(RADIANS(F372)))","v":13.416407864998735},{"$f":"IF(G36=0,\"n/a\",G340/TAN(RADIANS(G372)))","v":13.416407864998739},{"$f":"IF(H36=0,\"n/a\",H340/TAN(RADIANS(H372)))","v":20.124611797498101},{"$f":"I340/TAN(RADIANS(I372))","v":13.588413094037181}]
[null,"Area doubled up on for each pass, manual control of whole boom","square feet",{"$f":"IF(D36=0,\"n/a\",((D339*D341)/2+D339*D338)*2)","v":11756.075308874146},{"$f":"IF(E36=0,\"n/a\",((E339*E341)/2+E339*E338)*2)","v":2588.8543819998313},{"$f":"IF(F36=0,\"n/a\",((F339*F341)/2+F339*F338)*2)","v":4015.9503100797574},{"$f":"IF(G36=0,\"n/a\",((G339*G341)/2+G339*G338)*2)","v":5824.9223594996211},{"$f":"IF(H36=0,\"n/a\",((H339*H341)/2+H339*H338)*2)","v":11756.075308874146},{"$f":"((I339*I341)/2+I339*I338)*2","v":6235.2960792243794}]
[null,"Area doubled up on for each pass, automatic control of whole boom","square feet",{"$f":"IF(D36=0,\"n/a\",((D339*D341)/2)*2)","v":9056.0753088741458},{"$f":"IF(E36=0,\"n/a\",((E339*E341)/2)*2)","v":1788.8543819998313},{"$f":"IF(F36=0,\"n/a\",((F339*F341)/2)*2)","v":2575.9503100797574},{"$f":"IF(G36=0,\"n/a\",((G339*G341)/2)*2)","v":4024.9223594996211},{"$f":"IF(H36=0,\"n/a\",((H339*H341)/2)*2)","v":9056.0753088741458},{"$f":"((I339*I341)/2)*2","v":4465.696079224379}]
[null,"Area doubled up on for each pass, manual control of boom sections","square feet",{"$f":"IF(D36=0,\"n/a\",((D340*D342)/2*D27+D338*D339)*2)","v":4511.2150617748284},{"$f":"IF(E36=0,\"n/a\",((E340*E342)/2*E27+E338*E339)*2)","v":1023.6067977499789},{"$f":"IF(F36=0,\"n/a\",((F340*F342)/2*F27+F338*F339)*2)","v":2083.9875775199394},{"$f":"IF(G36=0,\"n/a\",((G340*G342)/2*G27+G338*G339)*2)","v":2604.9844718999243},{"$f":"IF(H36=0,\"n/a\",((H340*H342)/2*H27+H338*H339)*2)","v":4511.2150617748284},{"$f":"((I340*I342)/2*I27+I338*I339)*2","v":2628.3877075431501}]
[null,"Area doubled up on for each pass, automatic control of boom sections","square feet",{"$f":"IF(D36=0,\"n/a\",((D340*D342)/2*D27)*2)","v":1811.2150617748289},{"$f":"IF(E36=0,\"n/a\",((E340*E342)/2*E27)*2)","v":223.60679774997891},{"$f":"IF(F36=0,\"n/a\",((F340*F342)/2*F27)*2)","v":643.98757751993935},{"$f":"IF(G36=0,\"n/a\",((G340*G342)/2*G27)*2)","v":804.9844718999243},{"$f":"IF(H36=0,\"n/a\",((H340*H342)/2*H27)*2)","v":1811.2150617748289},{"$f":"((I340*I342)/2*I27)*2","v":858.78770754314985}]
[null,"Portion of field with headland overlap of crop inputs, manual whole boom","percent",{"$f":"IF(D36=0,\"n/a\",D$365*D343/D$359)","v":7.8294851546254443E-2},{"$f":"IF(E36=0,\"n/a\",E$365*E343/E$359)","v":3.7520150744123848E-2},{"$f":"IF(F36=0,\"n/a\",F$365*F343/F$359)","v":4.9375285609067392E-2},{"$f":"IF(G36=0,\"n/a\",G$365*G343/G$359)","v":5.8342852204213536E-2},{"$f":"IF(H36=0,\"n/a\",H$365*H343/H$359)","v":7.8294851546254443E-2},{"$f":"I$365*I343/I$359","v":6.5348947474305197E-2}]
[null,"Portion of field with headland overlap of crop inputs, auto whole boom","percent",{"$f":"IF(D36=0,\"n/a\",D$365*D344/D$359)","v":6.0312991646521291E-2},{"$f":"IF(E36=0,\"n/a\",E$365*E344/E$359)","v":2.5925786532679747E-2},{"$f":"IF(F36=0,\"n/a\",F$365*F344/F$359)","v":3.1670780874882828E-2},{"$f":"IF(G36=0,\"n/a\",G$365*G344/G$359)","v":4.0313919372805686E-2},{"$f":"IF(H36=0,\"n/a\",H$365*H344/H$359)","v":6.0312991646521291E-2},{"$f":"I$365*I344/I$359","v":4.6802675415815322E-2}]
[null,"Portion of field with headland overlap of crop inputs, manual boom section","percent",{"$f":"IF(D36=0,\"n/a\",D$365*D345/D$359)","v":3.00444582290374E-2},{"$f":"IF(E36=0,\"n/a\",E$365*E345/E$359)","v":1.483508752802907E-2},{"$f":"IF(F36=0,\"n/a\",F$365*F345/F$359)","v":2.5622199952905274E-2},{"$f":"IF(G36=0,\"n/a\",G$365*G345/G$359)","v":2.6091716705968982E-2},{"$f":"IF(H36=0,\"n/a\",H$365*H345/H$359)","v":3.00444582290374E-2},{"$f":"I$365*I345/I$359","v":2.754678656153127E-2}]
[null,"Portion of field with headland overlap of crop inputs, auto boom section","percent",{"$f":"IF(D36=0,\"n/a\",D$365*D346/D$359)","v":1.2062598329304257E-2},{"$f":"IF(E36=0,\"n/a\",E$365*E346/E$359)","v":3.2407233165849684E-3},{"$f":"IF(F36=0,\"n/a\",F$365*F346/F$359)","v":7.9176952187207071E-3},{"$f":"IF(G36=0,\"n/a\",G$365*G346/G$359)","v":8.0627838745611392E-3},{"$f":"IF(H36=0,\"n/a\",H$365*H346/H$359)","v":1.2062598329304257E-2},{"$f":"I$365*I346/I$359","v":9.00051450304141E-3}]
[]
[]
[]
[]
[]
[]
[null,"Intermediate calculated inputs"]
[null,"Size of field","acres",{"$f":"Inputs!G5","v":80},{"$f":"D358","v":80},{"$f":"E358","v":80},{"$f":"F358","v":80},{"$f":"G358","v":80},{"$f":"H358","v":80}]
[null,"Size of field","square feet",{"$f":"D358*43560","v":3484800},3484800,3484800,3484800,3484800,3484800]
[null,"Maximum width of field, perpendicular to direction of swaths (passes)","feet",{"$f":"G6","v":2000},{"$f":"D360","v":2000},2000,2000,2000,2000]
[null,"Running distance of headlands to cover for field","feet",{"$f":"Inputs!G7","v":6000},6000,6000,6000,6000,6000]
[null,"Typical swath overlap in percent of machine width (selected below)","percent",{"$f":"AVERAGE(D33:D34)","v":4.2500000000000003E-2},0.01,2.75E-2,4.5000000000000005E-2,4.2500000000000003E-2,0.03]
[]
[null,"Effective width of equipment allowing for overlap","feet",{"$f":"D24-D362*D24","v":86.174999999999997},{"$f":"E24-E362*E24","v":39.6},{"$f":"F24-F362*F24","v":46.68},{"$f":"G24-G362*G24","v":57.3},{"$f":"H24-H362*H24","v":86.174999999999997},{"$f":"(SUMPRODUCT(D364:H364,$D$36:$H$36,$D$22:$H$22))/$I$36","v":61.061999999999998}]
[null,"Number of passes in field","count",{"$f":"IF(D36=0,\"n/a\",D360/D364)","v":23.208587177255584},{"$f":"IF(E36=0,\"n/a\",E360/E364)","v":50.505050505050505},{"$f":"IF(F36=0,\"n/a\",F360/F364)","v":42.844901456726653},{"$f":"IF(G36=0,\"n/a\",G360/G364)","v":34.904013961605585},{"$f":"IF(H36=0,\"n/a\",H360/H364)","v":23.208587177255584},36.52240555460299]
[null,"Width of headland","feet",{"$f":"(D24+D364*(D23-1))","v":176.17500000000001},{"$f":"(E24+E364*(E23-1))","v":40},{"$f":"(F24+F364*(F23-1))","v":94.68},{"$f":"(G24+G364*(G23-1))","v":117.3},{"$f":"(H24+H364*(H23-1))","v":176.17500000000001},116.342]
[null,"Area in headlands","acres",{"$f":"D366*D361/43560","v":24.266528925619834},{"$f":"E366*E361/43560","v":5.5096418732782366},{"$f":"F366*F361/43560","v":13.041322314049587},{"$f":"G366*G361/43560","v":16.15702479338843},{"$f":"H366*H361/43560","v":24.266528925619834},16.025068870523416]
[null,"Area in field proper (i.e., non-headlands)","acres",{"$f":"D358-D367","v":55.733471074380162},{"$f":"E358-E367","v":74.490358126721759},{"$f":"F358-F367","v":66.95867768595042},{"$f":"G358-G367","v":63.84297520661157},{"$f":"H358-H367","v":55.733471074380162},63.974931129476587]
[null,"Implied perimeter distance for each pass (i.e., the 2 ends)","feet",{"$f":"IF(D36=0,\"n/a\",D361/D365)","v":258.52499999999998},{"$f":"IF(E36=0,\"n/a\",E361/E365)","v":118.8},{"$f":"IF(F36=0,\"n/a\",F361/F365)","v":140.04},{"$f":"IF(G36=0,\"n/a\",G361/G365)","v":171.9},{"$f":"IF(H36=0,\"n/a\",H361/H365)","v":258.52499999999998},183.18600000000001]
[null,"Avg length of a pass (distance before must turnaround)","feet",{"$f":"IF(D36=0,\"n/a\",(D368*43560)/D364/D365)","v":1213.8750000000002},{"$f":"IF(E36=0,\"n/a\",(E368*43560)/E364/E365)","v":1622.3999999999999},{"$f":"IF(F36=0,\"n/a\",(F368*43560)/F364/F365)","v":1458.3600000000001},{"$f":"IF(G36=0,\"n/a\",(G368*43560)/G364/G365)","v":1390.5},{"$f":"IF(H36=0,\"n/a\",(H368*43560)/H364/H365)","v":1213.8750000000002},1393.374]
[null,"Running distance of headland per acre","feet",{"$f":"D361/D358","v":75},{"$f":"E361/E358","v":75},{"$f":"F361/F358","v":75},{"$f":"G361/G358","v":75},{"$f":"H361/H358","v":75},75]
[null,"Average angle of approach to headland in degrees (0-90)","degrees",{"$f":"IF(D36=0,\"n/a\",DEGREES(ASIN(2*D364/D369)))","v":41.810314895778603},{"$f":"IF(E36=0,\"n/a\",DEGREES(ASIN(2*E364/E369)))","v":41.810314895778603},{"$f":"IF(F36=0,\"n/a\",DEGREES(ASIN(2*F364/F369)))","v":41.810314895778603},{"$f":"IF(G36=0,\"n/a\",DEGREES(ASIN(2*G364/G369)))","v":41.810314895778596},{"$f":"IF(H36=0,\"n/a\",DEGREES(ASIN(2*H364/H369)))","v":41.810314895778603},41.810314895778603]
[null,"Machine efficiency"]
[null,"Excess area covered due to machine overlap","acres",{"$f":"(1/(1-D362)-1)*D368+(D361*D24*D362*(D23-1))/43560","v":3.0006689251882639},{"$f":"(1/(1-E362)-1)*E368+(E361*E24*E362*(E23-1))/43560","v":0.75242785986588123},{"$f":"(1/(1-F362)-1)*F368+(F361*F24*F362*(F23-1))/43560","v":2.0752512269221746},{"$f":"(1/(1-G362)-1)*G368+(G361*G24*G362*(G23-1))/43560","v":3.380208558694993},{"$f":"(1/(1-H362)-1)*H368+(H361*H24*H362*(H23-1))/43560","v":3.0006689251882639},{"$f":"(SUMPRODUCT(D374:H374,$D$36:$H$36,$D$22:$H$22))/$I$36","v":2.1808536328173518}]
[null,"Total area covered by machine","acres",{"$f":"($G5+D374+(D380+D385+D386))","v":96.855814283995187},{"$f":"($G5+E374+(E380+E385+E386))","v":87.500106844464838},{"$f":"($G5+F374+(F380+F385+F386))","v":90.784353281321231},{"$f":"($G5+G374+(G380+G385+G386))","v":93.630561919873671},{"$f":"($G5+H374+(H380+H385+H386))","v":96.855814283995187},{"$f":"(SUMPRODUCT(D375:H375,$D$36:$H$36,$D$22:$H$22))/$I$36","v":92.556088395019529}]
[null,"Machine efficiency (acres in field / area covered)","percent",{"$f":"D358/D375","v":0.82597003175698347},0.91428459787144489,0.8812091192861965,0.85442187208554499,0.82597003175698347,0.86434076231234536]
[null,"Total \"area equivalent\" covered by machine w/ speed adjustment","acres",{"$f":"IF(D36=0,\"n/a\",D375+(1/D25-1)*(D380+D385+D386))","v":103.67999035624337},{"$f":"IF(E36=0,\"n/a\",E375+(1/E25-1)*(E380+E385+E386))","v":89.749333172664493},{"$f":"IF(F36=0,\"n/a\",F375+(1/F25-1)*(F380+F385+F386))","v":95.073911009607329},{"$f":"IF(G36=0,\"n/a\",G375+(1/G25-1)*(G380+G385+G386))","v":103.88091528105235},{"$f":"IF(H36=0,\"n/a\",H375+(1/H25-1)*(H380+H385+H386))","v":110.71095964280211},{"$f":"(SUMPRODUCT(D377:H377,$D$36:$H$36,$D$22:$H$22))/$I$36","v":97.451427180873168}]
[null,"Machine efficiency (acres in field / \"area equivalent\" covered)","percent",{"$f":"IF(D36=0,\"n/a\",D358/D377)","v":0.77160501004215798},{"$f":"IF(E36=0,\"n/a\",E358/E377)","v":0.89137152524678698},{"$f":"IF(F36=0,\"n/a\",F358/F377)","v":0.84145060564423302},{"$f":"IF(G36=0,\"n/a\",G358/G377)","v":0.77011258308186881},{"$f":"IF(H36=0,\"n/a\",H358/H377)","v":0.72260235353493485},{"$f":"I358/I377","v":0.82092178959593143}]
[null,"Crop input efficiency assuming manual control of whole boom or machine"]
[null,"Excess area for crop inputs at turnarounds due to angle and reaction time","acres",{"$f":"IF(D36=0,\"n/a\",D343*D365/43560)","v":6.2635881237003561},{"$f":"IF(E36=0,\"n/a\",E343*E365/43560)","v":3.0016120595299078},{"$f":"IF(F36=0,\"n/a\",F343*F365/43560)","v":3.9500228487253914},{"$f":"IF(G36=0,\"n/a\",G343*G365/43560)","v":4.6674281763370828},{"$f":"IF(H36=0,\"n/a\",H343*H365/43560)","v":6.2635881237003561},{"$f":"(SUMPRODUCT(D380:H380,$D$36:$H$36,$D$22:$H$22))/$I$36","v":4.6857668008762809}]
[null,"Doubling-up of inputs on headlands field efficiency","percent",{"$f":"IF(D36=0,\"n/a\",D358/(D358+D380))","v":0.92739012763162032},{"$f":"IF(E36=0,\"n/a\",E358/(E358+E380))","v":0.96383670166096169},{"$f":"IF(F36=0,\"n/a\",F358/(F358+F380))","v":0.95294792407807705},{"$f":"IF(G36=0,\"n/a\",G358/(G358+G380))","v":0.94487339137529702},{"$f":"IF(H36=0,\"n/a\",H358/(H358+H380))","v":0.92739012763162032},{"$f":"I358/(I358+I380)","v":0.94466877991559028}]
[null,"Total area to which crop inputs are applied","acres",{"$f":"IF(D36=0,\"n/a\",D358+D374+D380)","v":89.264257048888624},{"$f":"IF(E36=0,\"n/a\",E358+E374+E380)","v":83.75403991939578},{"$f":"IF(F36=0,\"n/a\",F358+F374+F380)","v":86.025274075647573},{"$f":"IF(G36=0,\"n/a\",G358+G374+G380)","v":88.047636735032071},{"$f":"IF(H36=0,\"n/a\",H358+H374+H380)","v":89.264257048888624},{"$f":"(SUMPRODUCT(D382:H382,$D$36:$H$36,$D$22:$H$22))/$I$36","v":86.86662043369364}]
[null,"Crop input efficiency (acres in field / area applied)","percent",{"$f":"IF(D36=0,\"n/a\",D358/D382)","v":0.89621537942320251},{"$f":"IF(E36=0,\"n/a\",E358/E382)","v":0.9551778048795182},{"$f":"IF(F36=0,\"n/a\",F358/F382)","v":0.92995925743463292},{"$f":"IF(G36=0,\"n/a\",G358/G382)","v":0.90859906031038185},{"$f":"IF(H36=0,\"n/a\",H358/H382)","v":0.89621537942320251},{"$f":"I358/I382","v":0.92095214019595695}]
[]
[null,"Area in semi-circle",null,{"$f":"((PI()*(D24*(1-D362/2))^2)/2*(D365-1)/43560)","v":6.2141467667870032},2.827793279522687,3.3816687373541043,4.2055147165220443,6.2141467667870032,4.9641053737517424]
[null,"Q-adjustment factor for machine coverage (percent increase)",1,{"$f":"(D28*D24*(1-D362)*(D365*2)/43560*$C386)","v":1.3774104683195592},0.91827364554637281,1.3774104683195594,1.3774104683195592,1.3774104683195592,1.439190711738813]
[]
[]
[null,"Per acre costs of technology relative to farm size","% of base",{"$f":"D21","v":"Sprayer"},"Planter","Fertilizer","Other 1","Other 2","Total/Avg"]
[null,"Overlap reducing tech",0.8,{"$f":"IF(D$36=0,\"n/a\",-D$38/(D$36*$C390))","v":-1.875},-1.875,-0.9375,-0.83333333333333337,-1.875,{"$f":"(SUMPRODUCT(D390:H390,$D$36:$H$36,$D$22:$H$22))/$I$36","v":-1.5}]
[null,null,0.9,-1.6666666666666667,-1.6666666666666667,-0.83333333333333337,-0.7407407407407407,-1.6666666666666667,{"$f":"(SUMPRODUCT(D391:H391,$D$36:$H$36,$D$22:$H$22))/$I$36","v":-1.3333333333333335}]
[null,null,1,-1.5,-1.5,-0.75,-0.66666666666666663,-1.5,{"$f":"(SUMPRODUCT(D392:H392,$D$36:$H$36,$D$22:$H$22))/$I$36","v":-1.2}]
[null,null,1.1000000000000001,-1.3636363636363635,-1.3636363636363635,-0.68181818181818177,-0.60606060606060608,-1.3636363636363635,{"$f":"(SUMPRODUCT(D393:H393,$D$36:$H$36,$D$22:$H$22))/$I$36","v":-1.0909090909090908}]
[null,null,1.2,-1.25,-1.25,-0.625,-0.55555555555555558,-1.25,{"$f":"(SUMPRODUCT(D394:H394,$D$36:$H$36,$D$22:$H$22))/$I$36","v":-1}]
[]
[null,"Boom/section control tech",{"$f":"C390","v":0.8},{"$f":"IF(D$36=0,\"n/a\",-D$39/(D$36*$C396))","v":-1.25},-5,-1.25,-1.6666666666666667,-1.25,{"$f":"(SUMPRODUCT(D396:H396,$D$36:$H$36,$D$22:$H$22))/$I$36","v":-2}]
[null,null,{"$f":"C391","v":0.9},-1.1111111111111112,-4.4444444444444446,-1.1111111111111112,-1.4814814814814814,-1.1111111111111112,{"$f":"(SUMPRODUCT(D397:H397,$D$36:$H$36,$D$22:$H$22))/$I$36","v":-1.7777777777777779}]
[null,null,{"$f":"C392","v":1},-1,-4,-1,-1.3333333333333333,-1,{"$f":"(SUMPRODUCT(D398:H398,$D$36:$H$36,$D$22:$H$22))/$I$36","v":-1.6}]
[null,null,{"$f":"C393","v":1.1000000000000001},-0.90909090909090906,-3.6363636363636362,-0.90909090909090906,-1.2121212121212122,-0.90909090909090906,{"$f":"(SUMPRODUCT(D399:H399,$D$36:$H$36,$D$22:$H$22))/$I$36","v":-1.4545454545454544}]
[null,null,{"$f":"C394","v":1.2},-0.83333333333333337,-3.3333333333333335,-0.83333333333333337,-1.1111111111111112,-0.83333333333333337,{"$f":"(SUMPRODUCT(D400:H400,$D$36:$H$36,$D$22:$H$22))/$I$36","v":-1.3333333333333335}]
[]
[null,"Payback of technology relative to farm size","% of base",{"$f":"D389","v":"Sprayer"},"Planter","Fertilizer","Other 1","Other 2","Total/Avg"]
[null,"Overlap reducing tech",{"$f":"C390","v":0.8},{"$f":"IF(D$36=0,\"n/a\",IF(D$148<-D390*$G$9,\"won't pay\",IF(D$148=0,\"n/a\",-LN(1+D390*$G$9/D$148)/LN(1+$G$9))))","v":2.1250522381000581},1.3977434167876257,0.99753556519309083,0.90919931789080488,2.0391796601721692,1.5041889048523602]
[null,null,{"$f":"C391","v":0.9},1.8755172294625371,1.2366969421925438,0.88379149270372515,0.80576562752732117,1.8002645864988525,1.330396642084039]
[null,null,{"$f":"C392","v":1},1.6784690963950202,1.1089390969653119,0.79333591982573393,0.72346518571323815,1.6114987321695011,1.1926189705684482]
[null,null,{"$f":"C393","v":1.1000000000000001},1.5189139221392942,1.005112761935,0.71967980147531285,0.65642078999861331,1.4585835004806371,1.0807087432996296]
[null,null,{"$f":"C394","v":1.2},1.3870751484404436,0.91906807471264429,0.65854026733183524,0.60074984268229781,1.3321867698480336,0.98800446025887023]
[]
[null,"Boom/section control tech",{"$f":"C403","v":0.8},{"$f":"IF(D$36=0,\"n/a\",IF(D$191<-D396*$G$9,\"won't pay\",IF(D$191=0,\"n/a\",-LN(1+D396*$G$9/D$191)/LN(1+$G$9))))","v":1.3470904379949666},1.4227743750731638,0.91080556872361773,2.4411691683947634,1.3470904379949666,1.2322770119041195]
[null,null,{"$f":"C404","v":0.9},{"$f":"IF(D$36=0,\"n/a\",IF(D$191<-D397*$G$9,\"won't pay\",IF(D$191=0,\"n/a\",-LN(1+D397*$G$9/D$191)/LN(1+$G$9))))","v":1.1920847549187168},1.2587369476619115,{"$f":"IF(F$36=0,\"n/a\",IF(F$191<-F397*$G$9,\"won't pay\",IF(F$191=0,\"n/a\",-LN(1+F397*$G$9/F$191)/LN(1+$G$9))))","v":0.80718481901487515},2.1521363585348063,1.1920847549187168,1.0909057746677342]
[null,null,{"$f":"C405","v":1},1.0690803929795702,1.1286266356730212,0.72473634200104009,1.9243645432691874,1.0690803929795702,0.97864132180774666]
[null,null,{"$f":"C406","v":1.1000000000000001},0.96909210298205295,1.0229015886548845,0.65757187694578245,1.7402283893262442,0.96909210298205295,0.88733170054147203]
[null,null,{"$f":"C407","v":1.2},0.88621124156547426,0.93529220830995752,0.60180158539088935,1.5882765408941908,0.88621124156547426,0.81160971110486091]
[]
[null,"NB incl. costs of technology relative to farm size","% of base",{"$f":"D402","v":"Sprayer"},"Planter","Fertilizer","Other 1","Other 2","Total/Avg"]
[null,"Overlap reducing tech",{"$f":"C390","v":0.8},{"$f":"IF(D$36=0,\"n/a\",D$281*$G$15+D$300*$G$16+D$319*$G$17-D$332*$G$18-(-PMT($G$9,$G$10,-D390)))","v":0.52083644792921202},0.99319576832129197,0.77357512584931243,0.77117746750679139,0.55904957947372846,{"$f":"(SUMPRODUCT(D416:H416,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0.71640378317566822}]
[null,null,{"$f":"C391","v":0.9},0.57029403135237655,1.0426533517444565,0.79830391756089469,0.79315861569486446,0.60850716289689299,{"$f":"(SUMPRODUCT(D417:H417,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0.75596984991419969}]
[null,null,{"$f":"C392","v":1},0.60986009809090813,1.0822194184829881,0.81808695093016048,0.81074353424532297,0.64807322963542457,{"$f":"(SUMPRODUCT(D418:H418,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0.78762270330502504}]
[null,null,{"$f":"C393","v":1.1000000000000001},0.64223233451334316,1.1145916549054231,0.834273069141378,0.82513119487751629,0.6804454660578596,{"$f":"(SUMPRODUCT(D419:H419,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0.8135204924429732}]
[null,null,{"$f":"C394","v":1.2},0.66920919819870561,1.1415685185907856,0.84776150098405922,0.83712091207101069,0.70742232974322206,{"$f":"(SUMPRODUCT(D420:H420,$D$36:$H$36,$D$22:$H$22))/$I$36","v":0.83510198339126307}]
[]
[null,"Boom/section control tech",{"$f":"C416","v":0.8},{"$f":"IF(D$36=0,\"n/a\",D$191-(-PMT($G$9,$G$10,-D396)))","v":0.69673829771526585},2.5837550148733284,1.1542701631231471,0.35854035755946995,0.69673829771526585,{"$f":"(SUMPRODUCT(D422:H422,$D$36:$H$36,$D$22:$H$22))/$I$36","v":1.2571543873100308}]
[null,null,{"$f":"C417","v":0.9},0.72971001999737539,2.7156419040017674,1.1872418854052567,0.40250265393561624,0.72971001999737539,{"$f":"(SUMPRODUCT(D423:H423,$D$36:$H$36,$D$22:$H$22))/$I$36","v":1.3099091429614063}]
[null,null,{"$f":"C418","v":1},0.75608739782306322,2.8211514153045183,1.2136192632309446,0.43767249103653322,0.75608739782306322,{"$f":"(SUMPRODUCT(D424:H424,$D$36:$H$36,$D$22:$H$22))/$I$36","v":1.3521129474825069}]
[null,null,{"$f":"C419","v":1.1000000000000001},0.77766888877135321,2.9074773790976782,1.2352007541792345,0.46644781230091981,0.77766888877135321,{"$f":"(SUMPRODUCT(D425:H425,$D$36:$H$36,$D$22:$H$22))/$I$36","v":1.3866433329997707}]
[null,null,{"$f":"C420","v":1.2},0.7956534645615948,2.9794156822586446,1.253185329969476,0.49042724668790866,0.7956534645615948,{"$f":"(SUMPRODUCT(D426:H426,$D$36:$H$36,$D$22:$H$22))/$I$36","v":1.4154186542641571}]
[]
[null,"Payback years data for figures",null,{"$f":"D402","v":"Sprayer"},"Planter","Fertilizer","Other 1","Other 2","Total/Avg"]
[null,"  Guidance",null,{"$f":"IF(COUNT(D403)=1,D403,NA())","v":2.1250522381000581},1.3977434167876257,0.99753556519309083,0.90919931789080488,2.0391796601721692,1.5041889048523602]
[null,null,null,1.8755172294625371,1.2366969421925438,0.88379149270372515,0.80576562752732117,1.8002645864988525,1.330396642084039]
[null,null,null,1.6784690963950202,1.1089390969653119,0.79333591982573393,0.72346518571323815,1.6114987321695011,1.1926189705684482]
[null,null,null,{"$f":"IF(COUNT(D406)=1,D406,NA())","v":1.5189139221392942},1.005112761935,0.71967980147531285,0.65642078999861331,1.4585835004806371,1.0807087432996296]
[null,null,null,{"$f":"IF(COUNT(D407)=1,D407,NA())","v":1.3870751484404436},0.91906807471264429,0.65854026733183524,0.60074984268229781,1.3321867698480336,0.98800446025887023]
[]
[null,"  Section control",null,{"$f":"IF(COUNT(D409)=1,D409,NA())","v":1.3470904379949666},1.4227743750731638,0.91080556872361773,2.4411691683947634,1.3470904379949666,1.2322770119041195]
[null,null,null,1.1920847549187168,1.2587369476619115,0.80718481901487515,2.1521363585348063,1.1920847549187168,1.0909057746677342]
[null,null,null,1.0690803929795702,1.1286266356730212,0.72473634200104009,1.9243645432691874,1.0690803929795702,0.97864132180774666]
[null,null,null,{"$f":"IF(COUNT(D412)=1,D412,NA())","v":0.96909210298205295},1.0229015886548845,0.65757187694578245,1.7402283893262442,0.96909210298205295,0.88733170054147203]
[null,null,null,{"$f":"IF(COUNT(D413)=1,D413,NA())","v":0.88621124156547426},0.93529220830995752,0.60180158539088935,1.5882765408941908,0.88621124156547426,0.81160971110486091]
[]
[null,"Intermediate calculations"]
[null,null,{"$f":"C320","v":"overlap %"},{"$f":"D428","v":"Sprayer"},"Planter","Fertilizer","Other 1","Other 2","Total/Avg"]
[null,"Area in field proper (i.e., non-headlands), acres","High",{"$f":"D$358-((D$24+(D$24-D244*D$24)*(D$23-1)))*D$361/43560","v":56.074380165289256},74.490358126721759,67.04132231404958,64.049586776859499,56.074380165289256,64.664859504132224]
[null,null,"|",55.903925619834709,74.490358126721759,67,63.946280991735534,55.903925619834709,64.602181818181819]
[null,null,"to",55.733471074380162,74.490358126721759,66.95867768595042,63.84297520661157,55.733471074380162,64.5395041322314]
[null,null,"|",55.563016528925615,74.490358126721759,66.917355371900825,63.739669421487605,55.563016528925615,64.476826446280995]
[null,null,"Low",55.392561983471076,74.490358126721759,66.876033057851245,63.63636363636364,55.392561983471076,64.414148760330576]

{"sheet":"Results","index":2,"n_rows":623,"n_cols":11,"rows_kept":623,"cut":false,"hidden":false,"merged":[[621,1,621,5],[622,1,622,5],[615,1,615,5],[618,1,618,5],[619,1,619,5],[620,1,620,5],[614,1,614,5],[497,1,497,5],[498,1,498,5],[499,1,499,5],[500,1,500,5],[607,1,607,10],[612,1,612,5],[613,1,613,5],[501,1,501,5],[492,1,492,5],[493,1,493,5],[494,1,494,5],[377,1,377,5],[378,1,378,5],[379,1,379,5],[380,1,380,5],[486,1,486,10],[376,1,376,5],[257,1,257,5],[258,1,258,5],[259,1,259,5],[491,1,491,5],[131,1,131,5],[251,1,251,5],[371,1,371,5],[372,1,372,5],[373,1,373,5],[370,1,370,5],[365,1,365,10],[135,1,135,5],[136,1,136,5],[252,1,252,5],[255,1,255,5],[256,1,256,5],[137,1,137,5],[138,1,138,5],[250,1,250,5],[244,1,244,10],[134,1,134,5],[249,1,249,5],[1,1,1,10],[123,1,123,10],[6,1,6,5],[7,1,7,5],[8,1,8,5],[9,1,9,5],[16,1,16,5],[12,1,12,5],[13,1,13,5],[14,1,14,5],[15,1,15,5],[128,1,128,5],[129,1,129,5],[130,1,130,5]]}
[]
[null,{"$f":"\"Analysis of Precision Ag Technologies for \"& Inputs!D21&\" vs. Applied Acres\"","v":"Analysis of Precision Ag Technologies for Sprayer vs. Applied Acres"}]
[]
[null,{"$f":"\"Acres applied annually (average field size = \"&Inputs!$G$5&\" acres)\"","v":"Acres applied annually (average field size = 80 acres)"},null,null,null,null,{"$f":"I4*Inputs!C$390","v":8000},{"$f":"I4*Inputs!C$391","v":9000},{"$f":"Inputs!$D$36","v":10000},{"$f":"I4*Inputs!C$393","v":11000},{"$f":"I4*Inputs!C$394","v":12000}]
[]
[null,{"$f":"\"Guidance system (going from \"&FIXED(Inputs!$D$33*100,2)&\"% to \"&FIXED(Inputs!$D$34*100,2)&\"% overlap)\"","v":"Guidance system (going from 7.00% to 1.50% overlap)"}]
[null,{"$f":"Inputs!$D$143","v":"Sum of net annual benefits, $/applied acre"},null,null,null,null,{"$f":"I7","v":0.96595469873769257},{"$f":"I7","v":0.96595469873769257},{"$f":"Inputs!D148","v":0.96595469873769257},{"$f":"I7","v":0.96595469873769257},{"$f":"I7","v":0.96595469873769257}]
[null,"Payback for given investment, years",null,null,null,null,{"$f":"Inputs!D403","v":2.1250522381000581},{"$f":"Inputs!D404","v":1.8755172294625371},{"$f":"Inputs!D405","v":1.6784690963950202},{"$f":"Inputs!D406","v":1.5189139221392942},{"$f":"Inputs!D407","v":1.3870751484404436}]
[null,"Sum of annual net benefits including cost of investment, $/applied acre",null,null,null,null,{"$f":"Inputs!D416","v":0.52083644792921202},{"$f":"Inputs!D417","v":0.57029403135237655},{"$f":"Inputs!D418","v":0.60986009809090813},{"$f":"Inputs!D419","v":0.64223233451334316},{"$f":"Inputs!D420","v":0.66920919819870561}]
[null,"ROI given benefits, years, and investment, %",null,null,null,null,{"$f":"IF(Inputs!$D$390=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$D$148,Inputs!$D$390,0,0,Inputs!$D$148/-Inputs!$D$390))","v":0.42859841324151743},{"$f":"IF(Inputs!$D$391=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$D$148,Inputs!$D$391,0,0,Inputs!$D$148/-Inputs!$D$391))","v":0.50434677776745018},{"$f":"IF(Inputs!$D$392=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$D$148,Inputs!$D$392,0,0,Inputs!$D$148/-Inputs!$D$392))","v":0.57819449222461794},{"$f":"IF(Inputs!$D$393=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$D$148,Inputs!$D$393,0,0,Inputs!$D$148/-Inputs!$D$393))","v":0.65054017530931008},{"$f":"IF(Inputs!$D$394=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$D$148,Inputs!$D$394,0,0,Inputs!$D$148/-Inputs!$D$394))","v":0.72167976151913282}]
[]
[null,{"$f":"\"Section control (controlling \"&Inputs!$D$24&\"' implement in \"&Inputs!$D$27&\" sections)\"","v":"Section control (controlling 90' implement in 5 sections)"}]
[null,{"$f":"Inputs!$D$143","v":"Sum of net annual benefits, $/applied acre"},null,null,null,null,{"$f":"I13","v":0.99348379825425281},{"$f":"I13","v":0.99348379825425281},{"$f":"Inputs!D191","v":0.99348379825425281},{"$f":"I13","v":0.99348379825425281},{"$f":"I13","v":0.99348379825425281}]
[null,"Payback for given investment, years",null,null,null,null,{"$f":"Inputs!D409","v":1.3470904379949666},{"$f":"Inputs!D410","v":1.1920847549187168},{"$f":"Inputs!D411","v":1.0690803929795702},{"$f":"Inputs!D412","v":0.96909210298205295},{"$f":"Inputs!D413","v":0.88621124156547426}]
[null,"Sum of annual net benefits including cost of investment, $/applied acre",null,null,null,null,{"$f":"Inputs!D422","v":0.69673829771526585},{"$f":"Inputs!D423","v":0.72971001999737539},{"$f":"Inputs!D424","v":0.75608739782306322},{"$f":"Inputs!D425","v":0.77766888877135321},{"$f":"Inputs!D426","v":0.7956534645615948}]
[null,"ROI given benefits, years, and investment, %",null,null,null,null,{"$f":"IF(Inputs!$D$396=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$D$191,Inputs!$D$396,0,0,Inputs!$D$191/-Inputs!$D$396))","v":0.74577412574902346},{"$f":"IF(Inputs!$D$397=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$D$191,Inputs!$D$397,0,0,Inputs!$D$191/-Inputs!$D$397))","v":0.85323255680295951},{"$f":"IF(Inputs!$D$398=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$D$191,Inputs!$D$398,0,0,Inputs!$D$191/-Inputs!$D$398))","v":0.95905449757211747},{"$f":"IF(Inputs!$D$399=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$D$191,Inputs!$D$399,0,0,Inputs!$D$191/-Inputs!$D$399))","v":1.0636315148096092},{"$f":"IF(Inputs!$D$400=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$D$191,Inputs!$D$400,0,0,Inputs!$D$191/-Inputs!$D$400))","v":1.1672460418989608}]
[null,"Guidance system and Section control ROI, %",null,null,null,null,{"$f":"IF(Inputs!$D$390+Inputs!$D$396=0,\"n/a/\",RATE(Inputs!$G$10,(Inputs!$D$148+Inputs!$D$191),(Inputs!$D$390+Inputs!$D$396),0,0,(Inputs!$D$148+Inputs!$D$191)/-(Inputs!$D$390+Inputs!$D$396)))","v":0.55891732674641825},{"$f":"IF(Inputs!$D$391+Inputs!$D$397=0,\"n/a/\",RATE(Inputs!$G$10,(Inputs!$D$148+Inputs!$D$191),(Inputs!$D$391+Inputs!$D$397),0,0,(Inputs!$D$148+Inputs!$D$191)/-(Inputs!$D$391+Inputs!$D$397)))","v":0.64723327857426294},{"$f":"IF(Inputs!$D$392+Inputs!$D$398=0,\"n/a/\",RATE(Inputs!$G$10,(Inputs!$D$148+Inputs!$D$191),(Inputs!$D$392+Inputs!$D$398),0,0,(Inputs!$D$148+Inputs!$D$191)/-(Inputs!$D$392+Inputs!$D$398)))","v":0.73374075175826547},{"$f":"IF(Inputs!$D$393+Inputs!$D$399=0,\"n/a/\",RATE(Inputs!$G$10,(Inputs!$D$148+Inputs!$D$191),(Inputs!$D$393+Inputs!$D$399),0,0,(Inputs!$D$148+Inputs!$D$191)/-(Inputs!$D$393+Inputs!$D$399)))","v":0.81884065899796143},{"$f":"IF(Inputs!$D$394+Inputs!$D$400=0,\"n/a/\",RATE(Inputs!$G$10,(Inputs!$D$148+Inputs!$D$191),(Inputs!$D$394+Inputs!$D$400),0,0,(Inputs!$D$148+Inputs!$D$191)/-(Inputs!$D$394+Inputs!$D$400)))","v":0.90282748880289743}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["  "]
[null,{"$f":"\"Analysis of Precision Ag Technologies for \"& Inputs!E21&\" vs. Applied Acres\"","v":"Analysis of Precision Ag Technologies for Planter vs. Applied Acres"}]
[]
[null,{"$f":"\"Acres applied annually (average field size = \"&Inputs!$G$5&\" acres)\"","v":"Acres applied annually (average field size = 80 acres)"},null,null,null,null,{"$f":"I126*Inputs!C$390","v":4000},{"$f":"I126*Inputs!C$391","v":4500},{"$f":"Inputs!$E$36","v":5000},{"$f":"I126*Inputs!C$393","v":5500},{"$f":"I126*Inputs!C$394","v":6000}]
[]
[null,{"$f":"\"Guidance system (going from \"&FIXED(Inputs!$E$33*100,2)&\"% to \"&FIXED(Inputs!$E$34*100,2)&\"% overlap)\"","v":"Guidance system (going from 2.00% to 0.00% overlap)"}]
[null,{"$f":"Inputs!$D$143","v":"Sum of net annual benefits, $/applied acre"},null,null,null,null,{"$f":"I129","v":1.4383140191297725},{"$f":"I129","v":1.4383140191297725},{"$f":"Inputs!E148","v":1.4383140191297725},{"$f":"I129","v":1.4383140191297725},{"$f":"I129","v":1.4383140191297725}]
[null,"Payback for given investment, years",null,null,null,null,{"$f":"Inputs!E403","v":1.3977434167876257},{"$f":"Inputs!E404","v":1.2366969421925438},{"$f":"Inputs!E405","v":1.1089390969653119},{"$f":"Inputs!E406","v":1.005112761935},{"$f":"Inputs!E407","v":0.91906807471264429}]
[null,"Sum of annual net benefits including cost of investment, $/applied acre",null,null,null,null,{"$f":"Inputs!E416","v":0.99319576832129197},{"$f":"Inputs!E417","v":1.0426533517444565},{"$f":"Inputs!E418","v":1.0822194184829881},{"$f":"Inputs!E419","v":1.1145916549054231},{"$f":"Inputs!E420","v":1.1415685185907856}]
[null,"ROI given benefits, years, and investment, %",null,null,null,null,{"$f":"IF(Inputs!$E$390=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$E$148,Inputs!$E$390,0,0,Inputs!$E$148/-Inputs!$E$390))","v":0.71546610049378367},{"$f":"IF(Inputs!$E$391=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$E$148,Inputs!$E$391,0,0,Inputs!$E$148/-Inputs!$E$391))","v":0.81974134526755826},{"$f":"IF(Inputs!$E$392=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$E$148,Inputs!$E$392,0,0,Inputs!$E$148/-Inputs!$E$392))","v":0.92235019720790923},{"$f":"IF(Inputs!$E$393=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$E$148,Inputs!$E$393,0,0,Inputs!$E$148/-Inputs!$E$393))","v":1.0236866328731709},{"$f":"IF(Inputs!$E$394=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$E$148,Inputs!$E$394,0,0,Inputs!$E$148/-Inputs!$E$394))","v":1.1240357155748353}]
[]
[null,{"$f":"\"Section control (controlling \"&Inputs!$E$24&\"' implement in \"&Inputs!$E$27&\" sections)\"","v":"Section control (controlling 40' implement in 8 sections)"}]
[null,{"$f":"Inputs!$D$143","v":"Sum of net annual benefits, $/applied acre"},null,null,null,null,{"$f":"I135","v":3.7707370170292767},{"$f":"I135","v":3.7707370170292767},{"$f":"Inputs!E191","v":3.7707370170292767},{"$f":"I135","v":3.7707370170292767},{"$f":"I135","v":3.7707370170292767}]
[null,"Payback for given investment, years",null,null,null,null,{"$f":"Inputs!E409","v":1.4227743750731638},{"$f":"Inputs!E410","v":1.2587369476619115},{"$f":"Inputs!E411","v":1.1286266356730212},{"$f":"Inputs!E412","v":1.0229015886548845},{"$f":"Inputs!E413","v":0.93529220830995752}]
[null,"Sum of annual net benefits including cost of investment, $/applied acre",null,null,null,null,{"$f":"Inputs!E422","v":2.5837550148733284},{"$f":"Inputs!E423","v":2.7156419040017674},{"$f":"Inputs!E424","v":2.8211514153045183},{"$f":"Inputs!E425","v":2.9074773790976782},{"$f":"Inputs!E426","v":2.9794156822586446}]
[null,"ROI given benefits, years, and investment, %",null,null,null,null,{"$f":"IF(Inputs!$E$396=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$E$191,Inputs!$E$396,0,0,Inputs!$E$191/-Inputs!$E$396))","v":0.70122385994470859},{"$f":"IF(Inputs!$E$397=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$E$191,Inputs!$E$397,0,0,Inputs!$E$191/-Inputs!$E$397))","v":0.8040130222362849},{"$f":"IF(Inputs!$E$398=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$E$191,Inputs!$E$398,0,0,Inputs!$E$191/-Inputs!$E$398))","v":0.90512193821158216},{"$f":"IF(Inputs!$E$399=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$E$191,Inputs!$E$399,0,0,Inputs!$E$191/-Inputs!$E$399))","v":1.0049456064097808},{"$f":"IF(Inputs!$E$400=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$E$191,Inputs!$E$400,0,0,Inputs!$E$191/-Inputs!$E$400))","v":1.1037702449402806}]
[null,"Guidance system and Section control ROI, %",null,null,null,null,{"$f":"IF(Inputs!$E$390+Inputs!$E$396=0,\"n/a/\",RATE(Inputs!$G$10,(Inputs!$E$148+Inputs!$E$191),(Inputs!$E$390+Inputs!$E$396),0,0,(Inputs!$E$148+Inputs!$E$191)/-(Inputs!$E$390+Inputs!$E$396)))","v":0.70511219225054955},{"$f":"IF(Inputs!$E$391+Inputs!$E$397=0,\"n/a/\",RATE(Inputs!$G$10,(Inputs!$E$148+Inputs!$E$191),(Inputs!$E$391+Inputs!$E$397),0,0,(Inputs!$E$148+Inputs!$E$191)/-(Inputs!$E$391+Inputs!$E$397)))","v":0.80830644483502112},{"$f":"IF(Inputs!$E$392+Inputs!$E$398=0,\"n/a/\",RATE(Inputs!$G$10,(Inputs!$E$148+Inputs!$E$191),(Inputs!$E$392+Inputs!$E$398),0,0,(Inputs!$E$148+Inputs!$E$191)/-(Inputs!$E$392+Inputs!$E$398)))","v":0.90982421954126536},{"$f":"IF(Inputs!$E$393+Inputs!$E$399=0,\"n/a/\",RATE(Inputs!$G$10,(Inputs!$E$148+Inputs!$E$191),(Inputs!$E$393+Inputs!$E$399),0,0,(Inputs!$E$148+Inputs!$E$191)/-(Inputs!$E$393+Inputs!$E$399)))","v":1.0100602430740315},{"$f":"IF(Inputs!$E$394+Inputs!$E$400=0,\"n/a/\",RATE(Inputs!$G$10,(Inputs!$E$148+Inputs!$E$191),(Inputs!$E$394+Inputs!$E$400),0,0,(Inputs!$E$148+Inputs!$E$191)/-(Inputs!$E$394+Inputs!$E$400)))","v":1.1093004235799637}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["  "]
[null,{"$f":"\"Analysis of Precision Ag Technologies for \"& Inputs!F21&\" vs. Applied Acres\"","v":"Analysis of Precision Ag Technologies for Fertilizer vs. Applied Acres"}]
[]
[null,{"$f":"\"Acres applied annually (average field size = \"&Inputs!$G$5&\" acres)\"","v":"Acres applied annually (average field size = 80 acres)"},null,null,null,null,{"$f":"I247*Inputs!C$390","v":8000},{"$f":"I247*Inputs!C$391","v":9000},{"$f":"Inputs!$F$36","v":10000},{"$f":"I247*Inputs!C$393","v":11000},{"$f":"I247*Inputs!C$394","v":12000}]
[]
[null,{"$f":"\"Guidance system (going from \"&FIXED(Inputs!$F$33*100,2)&\"% to \"&FIXED(Inputs!$F$34*100,2)&\"% overlap)\"","v":"Guidance system (going from 4.00% to 1.50% overlap)"}]
[null,{"$f":"Inputs!$D$143","v":"Sum of net annual benefits, $/applied acre"},null,null,null,null,{"$f":"I250","v":0.9961342512535527},{"$f":"I250","v":0.9961342512535527},{"$f":"Inputs!F148","v":0.9961342512535527},{"$f":"I250","v":0.9961342512535527},{"$f":"I250","v":0.9961342512535527}]
[null,"Payback for given investment, years",null,null,null,null,{"$f":"Inputs!F403","v":0.99753556519309083},{"$f":"Inputs!F404","v":0.88379149270372515},{"$f":"Inputs!F405","v":0.79333591982573393},{"$f":"Inputs!F406","v":0.71967980147531285},{"$f":"Inputs!F407","v":0.65854026733183524}]
[null,"Sum of annual net benefits including cost of investment, $/applied acre",null,null,null,null,{"$f":"Inputs!F416","v":0.77357512584931243},{"$f":"Inputs!F417","v":0.79830391756089469},{"$f":"Inputs!F418","v":0.81808695093016048},{"$f":"Inputs!F419","v":0.834273069141378},{"$f":"Inputs!F420","v":0.84776150098405922}]
[null,"ROI given benefits, years, and investment, %",null,null,null,null,{"$f":"IF(Inputs!$F$390=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$F$148,Inputs!$F$390,0,0,Inputs!$F$148/-Inputs!$F$390))","v":1.0318617558373033},{"$f":"IF(Inputs!$F$391=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$F$148,Inputs!$F$391,0,0,Inputs!$F$148/-Inputs!$F$391))","v":1.1705497515051702},{"$f":"IF(Inputs!$F$392=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$F$148,Inputs!$F$392,0,0,Inputs!$F$148/-Inputs!$F$392))","v":1.3078938890242711},{"$f":"IF(Inputs!$F$393=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$F$148,Inputs!$F$393,0,0,Inputs!$F$148/-Inputs!$F$393))","v":1.4442505310088904},{"$f":"IF(Inputs!$F$394=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$F$148,Inputs!$F$394,0,0,Inputs!$F$148/-Inputs!$F$394))","v":1.5798687989836471}]
[]
[null,{"$f":"\"Section control (controlling \"&Inputs!$F$24&\"' implement in \"&Inputs!$F$27&\" sections)\"","v":"Section control (controlling 48' implement in 4 sections)"}]
[null,{"$f":"Inputs!$D$143","v":"Sum of net annual benefits, $/applied acre"},null,null,null,null,{"$f":"I256","v":1.4510156636621341},{"$f":"I256","v":1.4510156636621341},{"$f":"Inputs!F191","v":1.4510156636621341},{"$f":"I256","v":1.4510156636621341},{"$f":"I256","v":1.4510156636621341}]
[null,"Payback for given investment, years",null,null,null,null,{"$f":"Inputs!F409","v":0.91080556872361773},{"$f":"Inputs!F410","v":0.80718481901487515},{"$f":"Inputs!F411","v":0.72473634200104009},{"$f":"Inputs!F412","v":0.65757187694578245},{"$f":"Inputs!F413","v":0.60180158539088935}]
[null,"Sum of annual net benefits including cost of investment, $/applied acre",null,null,null,null,{"$f":"Inputs!F422","v":1.1542701631231471},{"$f":"Inputs!F423","v":1.1872418854052567},{"$f":"Inputs!F424","v":1.2136192632309446},{"$f":"Inputs!F425","v":1.2352007541792345},{"$f":"Inputs!F426","v":1.253185329969476}]
[null,"ROI given benefits, years, and investment, %",null,null,null,null,{"$f":"IF(Inputs!$F$396=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$F$191,Inputs!$F$396,0,0,Inputs!$F$191/-Inputs!$F$396))","v":1.1346211724959494},{"$f":"IF(Inputs!$F$397=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$F$191,Inputs!$F$397,0,0,Inputs!$F$191/-Inputs!$F$397))","v":1.2849472203677015},{"$f":"IF(Inputs!$F$398=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$F$191,Inputs!$F$398,0,0,Inputs!$F$191/-Inputs!$F$398))","v":1.434031623070642},{"$f":"IF(Inputs!$F$399=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$F$191,Inputs!$F$399,0,0,Inputs!$F$191/-Inputs!$F$399))","v":1.5822143973965381},{"$f":"IF(Inputs!$F$400=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$F$191,Inputs!$F$400,0,0,Inputs!$F$191/-Inputs!$F$400))","v":1.7297305309752513}]
[null,"Guidance system and Section control ROI, %",null,null,null,null,{"$f":"IF(Inputs!$F$390+Inputs!$F$396=0,\"n/a/\",RATE(Inputs!$G$10,(Inputs!$F$148+Inputs!$F$191),(Inputs!$F$390+Inputs!$F$396),0,0,(Inputs!$F$148+Inputs!$F$191)/-(Inputs!$F$390+Inputs!$F$396)))","v":1.0906902695266485},{"$f":"IF(Inputs!$F$391+Inputs!$F$397=0,\"n/a/\",RATE(Inputs!$G$10,(Inputs!$F$148+Inputs!$F$191),(Inputs!$F$391+Inputs!$F$397),0,0,(Inputs!$F$148+Inputs!$F$191)/-(Inputs!$F$391+Inputs!$F$397)))","v":1.2360184011122841},{"$f":"IF(Inputs!$F$392+Inputs!$F$398=0,\"n/a/\",RATE(Inputs!$G$10,(Inputs!$F$148+Inputs!$F$191),(Inputs!$F$392+Inputs!$F$398),0,0,(Inputs!$F$148+Inputs!$F$191)/-(Inputs!$F$392+Inputs!$F$398)))","v":1.3800616695191996},{"$f":"IF(Inputs!$F$393+Inputs!$F$399=0,\"n/a/\",RATE(Inputs!$G$10,(Inputs!$F$148+Inputs!$F$191),(Inputs!$F$393+Inputs!$F$399),0,0,(Inputs!$F$148+Inputs!$F$191)/-(Inputs!$F$393+Inputs!$F$399)))","v":1.5231672296860106},{"$f":"IF(Inputs!$F$394+Inputs!$F$400=0,\"n/a/\",RATE(Inputs!$G$10,(Inputs!$F$148+Inputs!$F$191),(Inputs!$F$394+Inputs!$F$400),0,0,(Inputs!$F$148+Inputs!$F$191)/-(Inputs!$F$394+Inputs!$F$400)))","v":1.6655761777336437}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["  "]
[null,{"$f":"\"Analysis of Precision Ag Technologies for \"& Inputs!G21&\" vs. Applied Acres\"","v":"Analysis of Precision Ag Technologies for Other 1 vs. Applied Acres"}]
[]
[null,{"$f":"\"Acrs applied annually (average field size = \"&Inputs!$G$5&\" acres)\"","v":"Acrs applied annually (average field size = 80 acres)"},null,null,null,null,{"$f":"I368*Inputs!C$390","v":6000},{"$f":"I368*Inputs!C$391","v":6750},{"$f":"Inputs!$G$36","v":7500},{"$f":"I368*Inputs!C$393","v":8250},{"$f":"I368*Inputs!C$394","v":9000}]
[]
[null,{"$f":"\"Guidance system (going from \"&FIXED(Inputs!$F$33*100,2)&\"% to \"&FIXED(Inputs!$F$34*100,2)&\"% overlap)\"","v":"Guidance system (going from 4.00% to 1.50% overlap)"}]
[null,{"$f":"Inputs!$D$143","v":"Sum of net annual benefits, $/applied acre"},null,null,null,null,{"$f":"I371","v":0.9690078011994494},{"$f":"I371","v":0.9690078011994494},{"$f":"Inputs!G148","v":0.9690078011994494},{"$f":"I371","v":0.9690078011994494},{"$f":"I371","v":0.9690078011994494}]
[null,"Payback for given investment, years",null,null,null,null,{"$f":"Inputs!G403","v":0.90919931789080488},{"$f":"Inputs!G404","v":0.80576562752732117},{"$f":"Inputs!G405","v":0.72346518571323815},{"$f":"Inputs!G406","v":0.65642078999861331},{"$f":"Inputs!G407","v":0.60074984268229781}]
[null,"Sum of annual net benefits including cost of investment, $/applied acre",null,null,null,null,{"$f":"Inputs!G416","v":0.77117746750679139},{"$f":"Inputs!G417","v":0.79315861569486446},{"$f":"Inputs!G418","v":0.81074353424532297},{"$f":"Inputs!G419","v":0.82513119487751629},{"$f":"Inputs!G420","v":0.83712091207101069}]
[null,"ROI given benefits, years, and investment, %",null,null,null,null,{"$f":"IF(Inputs!$G$390=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$G$148,Inputs!$G$390,0,0,Inputs!$G$148/-Inputs!$G$390))","v":1.1367003509512361},{"$f":"IF(Inputs!$G$391=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$G$148,Inputs!$G$391,0,0,Inputs!$G$148/-Inputs!$G$391))","v":1.2872637297074567},{"$f":"IF(Inputs!$G$392=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$G$148,Inputs!$G$392,0,0,Inputs!$G$148/-Inputs!$G$392))","v":1.4365874887792638},{"$f":"IF(Inputs!$G$393=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$G$148,Inputs!$G$393,0,0,Inputs!$G$148/-Inputs!$G$393))","v":1.5850113024561068},{"$f":"IF(Inputs!$G$394=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$G$148,Inputs!$G$394,0,0,Inputs!$G$148/-Inputs!$G$394))","v":1.7327698675136722}]
[]
[null,{"$f":"\"Section control (controlling \"&Inputs!$G$24&\"' implement in \"&Inputs!$G$27&\" sections)\"","v":"Section control (controlling 60' implement in 5 sections)"}]
[null,{"$f":"Inputs!$D$143","v":"Sum of net annual benefits, $/applied acre"},null,null,null,null,{"$f":"I377","v":0.75420102494478602},{"$f":"I377","v":0.75420102494478602},{"$f":"Inputs!G191","v":0.75420102494478602},{"$f":"I377","v":0.75420102494478602},{"$f":"I377","v":0.75420102494478602}]
[null,"Payback for given investment, years",null,null,null,null,{"$f":"Inputs!G409","v":2.4411691683947634},{"$f":"Inputs!G410","v":2.1521363585348063},{"$f":"Inputs!G411","v":1.9243645432691874},{"$f":"Inputs!G412","v":1.7402283893262442},{"$f":"Inputs!G413","v":1.5882765408941908}]
[null,"Sum of annual net benefits including cost of investment, $/applied acre",null,null,null,null,{"$f":"Inputs!G422","v":0.35854035755946995},{"$f":"Inputs!G423","v":0.40250265393561624},{"$f":"Inputs!G424","v":0.43767249103653322},{"$f":"Inputs!G425","v":0.46644781230091981},{"$f":"Inputs!G426","v":0.49042724668790866}]
[null,"ROI given benefits, years, and investment, %",null,null,null,null,{"$f":"IF(Inputs!$G$396=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$G$191,Inputs!$G$396,0,0,Inputs!$G$191/-Inputs!$G$396))","v":0.35255023319695228},{"$f":"IF(Inputs!$G$397=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$G$191,Inputs!$G$397,0,0,Inputs!$G$191/-Inputs!$G$397))","v":0.42131801948179681},{"$f":"IF(Inputs!$G$398=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$G$191,Inputs!$G$398,0,0,Inputs!$G$191/-Inputs!$G$398))","v":0.48814786993904347},{"$f":"IF(Inputs!$G$399=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$G$191,Inputs!$G$399,0,0,Inputs!$G$191/-Inputs!$G$399))","v":0.55343334697401536},{"$f":"IF(Inputs!$G$400=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$G$191,Inputs!$G$400,0,0,Inputs!$G$191/-Inputs!$G$400))","v":0.61746815260195664}]
[null,"Guidance system and Section control ROI, %",null,null,null,null,{"$f":"IF(Inputs!$G$390+Inputs!$G$396=0,\"n/a/\",RATE(Inputs!$G$10,(Inputs!$G$148+Inputs!$G$191),(Inputs!$G$390+Inputs!$G$396),0,0,(Inputs!$G$148+Inputs!$G$191)/-(Inputs!$G$390+Inputs!$G$396)))","v":0.62923892182422658},{"$f":"IF(Inputs!$G$391+Inputs!$G$397=0,\"n/a/\",RATE(Inputs!$G$10,(Inputs!$G$148+Inputs!$G$191),(Inputs!$G$391+Inputs!$G$397),0,0,(Inputs!$G$148+Inputs!$G$191)/-(Inputs!$G$391+Inputs!$G$397)))","v":0.72461797797145511},{"$f":"IF(Inputs!$G$392+Inputs!$G$398=0,\"n/a/\",RATE(Inputs!$G$10,(Inputs!$G$148+Inputs!$G$191),(Inputs!$G$392+Inputs!$G$398),0,0,(Inputs!$G$148+Inputs!$G$191)/-(Inputs!$G$392+Inputs!$G$398)))","v":0.81824924941938393},{"$f":"IF(Inputs!$G$393+Inputs!$G$399=0,\"n/a/\",RATE(Inputs!$G$10,(Inputs!$G$148+Inputs!$G$191),(Inputs!$G$393+Inputs!$G$399),0,0,(Inputs!$G$148+Inputs!$G$191)/-(Inputs!$G$393+Inputs!$G$399)))","v":0.91053174475684107},{"$f":"IF(Inputs!$G$394+Inputs!$G$400=0,\"n/a/\",RATE(Inputs!$G$10,(Inputs!$G$148+Inputs!$G$191),(Inputs!$G$394+Inputs!$G$400),0,0,(Inputs!$G$148+Inputs!$G$191)/-(Inputs!$G$394+Inputs!$G$400)))","v":1.0017566513095013}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["  "]
[null,{"$f":"\"Analysis of Precision Ag Technologies for \"& Inputs!H21&\" vs. Applied Acres\"","v":"Analysis of Precision Ag Technologies for Other 2 vs. Applied Acres"}]
[]
[null,{"$f":"\"Acres applied annually (average field size = \"&Inputs!$G$5&\" acres)\"","v":"Acres applied annually (average field size = 80 acres)"},null,null,null,null,{"$f":"I489*Inputs!C$390","v":8000},{"$f":"I489*Inputs!C$391","v":9000},{"$f":"Inputs!$H$36","v":10000},{"$f":"I489*Inputs!C$393","v":11000},{"$f":"I489*Inputs!C$394","v":12000}]
[]
[null,{"$f":"\"Guidance system (going from \"&FIXED(Inputs!$F$33*100,2)&\"% to \"&FIXED(Inputs!$F$34*100,2)&\"% overlap)\"","v":"Guidance system (going from 4.00% to 1.50% overlap)"}]
[null,{"$f":"Inputs!$D$143","v":"Sum of net annual benefits, $/applied acre"},null,null,null,null,{"$f":"I492","v":1.004167830282209},{"$f":"I492","v":1.004167830282209},{"$f":"Inputs!H148","v":1.004167830282209},{"$f":"I492","v":1.004167830282209},{"$f":"I492","v":1.004167830282209}]
[null,"Payback for given investment, years",null,null,null,null,{"$f":"Inputs!H403","v":2.0391796601721692},{"$f":"Inputs!H404","v":1.8002645864988525},{"$f":"Inputs!H405","v":1.6114987321695011},{"$f":"Inputs!H406","v":1.4585835004806371},{"$f":"Inputs!H407","v":1.3321867698480336}]
[null,"Sum of annual net benefits including cost of investment, $/applied acre",null,null,null,null,{"$f":"Inputs!H416","v":0.55904957947372846},{"$f":"Inputs!H417","v":0.60850716289689299},{"$f":"Inputs!H418","v":0.64807322963542457},{"$f":"Inputs!H419","v":0.6804454660578596},{"$f":"Inputs!H420","v":0.70742232974322206}]
[null,"ROI given benefits, years, and investment, %",null,null,null,null,{"$f":"IF(Inputs!$H$390=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$H$148,Inputs!$H$390,0,0,Inputs!$H$148/-Inputs!$H$390))","v":0.45280653783797203},{"$f":"IF(Inputs!$H$391=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$H$148,Inputs!$H$391,0,0,Inputs!$H$148/-Inputs!$H$391))","v":0.53083407294241658},{"$f":"IF(Inputs!$H$392=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$H$148,Inputs!$H$392,0,0,Inputs!$H$148/-Inputs!$H$392))","v":0.60697564164851492},{"$f":"IF(Inputs!$H$393=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$H$148,Inputs!$H$393,0,0,Inputs!$H$148/-Inputs!$H$393))","v":0.68163088817307937},{"$f":"IF(Inputs!$H$394=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$H$148,Inputs!$H$394,0,0,Inputs!$H$148/-Inputs!$H$394))","v":0.75509596949363145}]
[]
[null,{"$f":"\"Section control (controlling \"&Inputs!$H$24&\"' implement in \"&Inputs!$H$27&\" sections)\"","v":"Section control (controlling 90' implement in 5 sections)"}]
[null,{"$f":"Inputs!$D$143","v":"Sum of net annual benefits, $/applied acre"},null,null,null,null,{"$f":"I498","v":0.99348379825425281},{"$f":"I498","v":0.99348379825425281},{"$f":"Inputs!H191","v":0.99348379825425281},{"$f":"I498","v":0.99348379825425281},{"$f":"I498","v":0.99348379825425281}]
[null,"Payback for given investment, years",null,null,null,null,{"$f":"Inputs!H409","v":1.3470904379949666},{"$f":"Inputs!H410","v":1.1920847549187168},{"$f":"Inputs!H411","v":1.0690803929795702},{"$f":"Inputs!H412","v":0.96909210298205295},{"$f":"Inputs!H413","v":0.88621124156547426}]
[null,"Sum of annual net benefits including cost of investment, $/applied acre",null,null,null,null,{"$f":"Inputs!H422","v":0.69673829771526585},{"$f":"Inputs!H423","v":0.72971001999737539},{"$f":"Inputs!H424","v":0.75608739782306322},{"$f":"Inputs!H425","v":0.77766888877135321},{"$f":"Inputs!H426","v":0.7956534645615948}]
[null,"ROI given benefits, years, and investment, %",null,null,null,null,{"$f":"IF(Inputs!$H$396=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$H$191,Inputs!$H$396,0,0,Inputs!$H$191/-Inputs!$H$396))","v":0.74577412574902346},{"$f":"IF(Inputs!$H$397=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$H$191,Inputs!$H$397,0,0,Inputs!$H$191/-Inputs!$H$397))","v":0.85323255680295951},{"$f":"IF(Inputs!$H$398=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$H$191,Inputs!$H$398,0,0,Inputs!$H$191/-Inputs!$H$398))","v":0.95905449757211747},{"$f":"IF(Inputs!$H$399=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$H$191,Inputs!$H$399,0,0,Inputs!$H$191/-Inputs!$H$399))","v":1.0636315148096092},{"$f":"IF(Inputs!$H$400=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$H$191,Inputs!$H$400,0,0,Inputs!$H$191/-Inputs!$H$400))","v":1.1672460418989608}]
[null,"Guidance system and Section control ROI, %",null,null,null,null,{"$f":"IF(Inputs!$H$390+Inputs!$H$396=0,\"n/a/\",RATE(Inputs!$G$10,(Inputs!$H$148+Inputs!$H$191),(Inputs!$H$390+Inputs!$H$396),0,0,(Inputs!$H$148+Inputs!$H$191)/-(Inputs!$H$390+Inputs!$H$396)))","v":0.57283550376752679},{"$f":"IF(Inputs!$H$391+Inputs!$H$397=0,\"n/a/\",RATE(Inputs!$G$10,(Inputs!$H$148+Inputs!$H$191),(Inputs!$H$391+Inputs!$H$397),0,0,(Inputs!$H$148+Inputs!$H$191)/-(Inputs!$H$391+Inputs!$H$397)))","v":0.66253475201610357},{"$f":"IF(Inputs!$H$392+Inputs!$H$398=0,\"n/a/\",RATE(Inputs!$G$10,(Inputs!$H$148+Inputs!$H$191),(Inputs!$H$392+Inputs!$H$398),0,0,(Inputs!$H$148+Inputs!$H$191)/-(Inputs!$H$392+Inputs!$H$398)))","v":0.75043703220541547},{"$f":"IF(Inputs!$H$393+Inputs!$H$399=0,\"n/a/\",RATE(Inputs!$G$10,(Inputs!$H$148+Inputs!$H$191),(Inputs!$H$393+Inputs!$H$399),0,0,(Inputs!$H$148+Inputs!$H$191)/-(Inputs!$H$393+Inputs!$H$399)))","v":0.83694304704685174},{"$f":"IF(Inputs!$H$394+Inputs!$H$400=0,\"n/a/\",RATE(Inputs!$G$10,(Inputs!$H$148+Inputs!$H$191),(Inputs!$H$394+Inputs!$H$400),0,0,(Inputs!$H$148+Inputs!$H$191)/-(Inputs!$H$394+Inputs!$H$400)))","v":0.92234676296670726}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["  "]
[null,"Analysis of Precision Agricultural Technologies for Whole Farm"]
[]
[null,{"$f":"\"Percent of acres applied annually (base = \"&FIXED(Inputs!$I$36,0)&\" acres)\"","v":"Percent of acres applied annually (base = 25,000 acres)"},null,null,null,null,{"$f":"Inputs!C390","v":0.8},{"$f":"Inputs!C391","v":0.9},{"$f":"Inputs!C392","v":1},{"$f":"Inputs!C393","v":1.1000000000000001},{"$f":"Inputs!C394","v":1.2}]
[]
[null,"Guidance system"]
[null,{"$f":"Inputs!$D$143","v":"Sum of net annual benefits, $/applied acre"},null,null,null,null,{"$f":"I613","v":1.0724983838224527},{"$f":"I613","v":1.0724983838224527},{"$f":"Inputs!I148","v":1.0724983838224527},{"$f":"I613","v":1.0724983838224527},{"$f":"I613","v":1.0724983838224527}]
[null,"Payback for given investment, years",null,null,null,null,{"$f":"Inputs!I403","v":1.5041889048523602},{"$f":"Inputs!I404","v":1.330396642084039},{"$f":"Inputs!I405","v":1.1926189705684482},{"$f":"Inputs!I406","v":1.0807087432996296},{"$f":"Inputs!I407","v":0.98800446025887023}]
[null,"Sum of annual net benefits including cost of investment, $/applied acre",null,null,null,null,{"$f":"Inputs!I416","v":0.71640378317566822},{"$f":"Inputs!I417","v":0.75596984991419969},{"$f":"Inputs!I418","v":0.78762270330502504},{"$f":"Inputs!I419","v":0.8135204924429732},{"$f":"Inputs!I420","v":0.83510198339126307}]
[null,"ROI given benefits, years, and investment, %",null,null,null,null,{"$f":"IF(Inputs!$I$390=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$I$148,Inputs!$I$390,0,0,Inputs!$I$148/-Inputs!$I$390))","v":0.65791813174003166},{"$f":"IF(Inputs!$I$391=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$I$148,Inputs!$I$391,0,0,Inputs!$I$148/-Inputs!$I$391))","v":0.75622862601206264},{"$f":"IF(Inputs!$I$392=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$I$148,Inputs!$I$392,0,0,Inputs!$I$148/-Inputs!$I$392))","v":0.85281769073447466},{"$f":"IF(Inputs!$I$393=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$I$148,Inputs!$I$393,0,0,Inputs!$I$148/-Inputs!$I$393))","v":0.94808297524759355},{"$f":"IF(Inputs!$I$394=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$I$148,Inputs!$I$394,0,0,Inputs!$I$148/-Inputs!$I$394))","v":1.042313867948325}]
[]
[null,"Section control"]
[null,{"$f":"Inputs!$D$143","v":"Sum of net annual benefits, $/applied acre"},null,null,null,null,{"$f":"I619","v":1.7319471881724102},{"$f":"I619","v":1.7319471881724102},{"$f":"Inputs!I191","v":1.7319471881724102},{"$f":"I619","v":1.7319471881724102},{"$f":"I619","v":1.7319471881724102}]
[null,"Payback for given investment, years",null,null,null,null,{"$f":"Inputs!I409","v":1.2322770119041195},{"$f":"Inputs!I410","v":1.0909057746677342},{"$f":"Inputs!I411","v":0.97864132180774666},{"$f":"Inputs!I412","v":0.88733170054147203},{"$f":"Inputs!I413","v":0.81160971110486091}]
[null,"Sum of annual net benefits including cost of investment, $/applied acre",null,null,null,null,{"$f":"Inputs!I422","v":1.2571543873100308},{"$f":"Inputs!I423","v":1.3099091429614063},{"$f":"Inputs!I424","v":1.3521129474825069},{"$f":"Inputs!I425","v":1.3866433329997707},{"$f":"Inputs!I426","v":1.4154186542641571}]
[null,"ROI given benefits, years, and investment, %",null,null,null,null,{"$f":"IF(Inputs!$I$396=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$I$191,Inputs!$I$396,0,0,Inputs!$I$191/-Inputs!$I$396))","v":0.8229585154547695},{"$f":"IF(Inputs!$I$397=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$I$191,Inputs!$I$397,0,0,Inputs!$I$191/-Inputs!$I$397))","v":0.93864344553559531},{"$f":"IF(Inputs!$I$398=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$I$191,Inputs!$I$398,0,0,Inputs!$I$191/-Inputs!$I$398))","v":1.0527699461235205},{"$f":"IF(Inputs!$I$399=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$I$191,Inputs!$I$399,0,0,Inputs!$I$191/-Inputs!$I$399))","v":1.165722113059779},{"$f":"IF(Inputs!$I$400=0,\"n/a\",RATE(Inputs!$G$10,Inputs!$I$191,Inputs!$I$400,0,0,Inputs!$I$191/-Inputs!$I$400))","v":1.2777747282325049}]
[null,"Guidance system and Section control ROI, %",null,null,null,null,{"$f":"IF(Inputs!$I$390+Inputs!$I$396=0,\"n/a/\",RATE(Inputs!$G$10,(Inputs!$I$148+Inputs!$I$191),(Inputs!$I$390+Inputs!$I$396),0,0,(Inputs!$I$148+Inputs!$I$191)/-(Inputs!$I$390+Inputs!$I$396)))","v":0.75284625418113182},{"$f":"IF(Inputs!$I$391+Inputs!$I$397=0,\"n/a/\",RATE(Inputs!$G$10,(Inputs!$I$148+Inputs!$I$191),(Inputs!$I$391+Inputs!$I$397),0,0,(Inputs!$I$148+Inputs!$I$191)/-(Inputs!$I$391+Inputs!$I$397)))","v":0.8610514141875999},{"$f":"IF(Inputs!$I$392+Inputs!$I$398=0,\"n/a/\",RATE(Inputs!$G$10,(Inputs!$I$148+Inputs!$I$191),(Inputs!$I$392+Inputs!$I$398),0,0,(Inputs!$I$148+Inputs!$I$191)/-(Inputs!$I$392+Inputs!$I$398)))","v":0.96762713441480275},{"$f":"IF(Inputs!$I$393+Inputs!$I$399=0,\"n/a/\",RATE(Inputs!$G$10,(Inputs!$I$148+Inputs!$I$191),(Inputs!$I$393+Inputs!$I$399),0,0,(Inputs!$I$148+Inputs!$I$191)/-(Inputs!$I$393+Inputs!$I$399)))","v":1.0729643747672351},{"$f":"IF(Inputs!$I$394+Inputs!$I$400=0,\"n/a/\",RATE(Inputs!$G$10,(Inputs!$I$148+Inputs!$I$191),(Inputs!$I$394+Inputs!$I$400),0,0,(Inputs!$I$148+Inputs!$I$191)/-(Inputs!$I$394+Inputs!$I$400)))","v":1.1773449226165937}]

{"sheet":"Fields","index":3,"n_rows":11,"n_cols":104,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"All Fields Data"]
[]
[]
[null,"Field characteristics section",null,"Acre-wtd."]
[null,"Field name","units","average","Field #1","Field #2","Field #3","Field #4","Field #5","Field #6","Field #7","Field #8","Field #9","Field #10","Field #11","Field #12","Field #13","Field #14","Field #15","Field #16","Field #17","Field #18","Field #19","Field #20","Field #21","Field #22","Field #23","Field #24","Field #25","Field #26","Field #27","Field #28","Field #29","Field #30","Field #31","Field #32","Field #33","Field #34","Field #35","Field #36","Field #37","Field #38","Field #39","Field #40","Field #41","Field #42","Field #43","Field #44","Field #45","Field #46","Field #47","Field #48","Field #49","Field #50","Field #51","Field #52","Field #53","Field #54","Field #55","Field #56","Field #57","Field #58","Field #59","Field #60","Field #61","Field #62","Field #63","Field #64","Field #65","Field #66","Field #67","Field #68","Field #69","Field #70","Field #71","Field #72","Field #73","Field #74","Field #75","Field #76","Field #77","Field #78","Field #79","Field #80","Field #81","Field #82","Field #83","Field #84","Field #85","Field #86","Field #87","Field #88","Field #89","Field #90","Field #91","Field #92","Field #93","Field #94","Field #95","Field #96","Field #97","Field #98","Field #99","Field #100"]
[null,"Size of field","acres",{"$f":"(SUMPRODUCT(E7:CZ7,$E$7:$CZ$7))/$D$8","v":75.402234636871512},50,88,75,55,90]
[null,"Total acres","acres",{"$f":"SUM(E7:CZ7)","v":358}]
[null,"Maximum width of field, perpendicular to direction of swaths (passes)","feet",{"$f":"(SUMPRODUCT(E9:CZ9,$E$7:$CZ$7))/$D$8","v":1897.1927374301677},1690.5,2015,1897,1565,2100]
[null,"Running distance of headlands to cover for field","feet",{"$f":"(SUMPRODUCT(E10:CZ10,$E$7:$CZ$7))/$D$8","v":6000.0698324022351},7760,5000,6000,5755,6150]
[null,"Average angle of approach to headland in degrees (0-90)","degrees",null,{"$f":"IF(ISERR(DEGREES(ASIN(2*E9/E10))),\"\",DEGREES(ASIN(2*E9/E10)))","v":25.829581834142484},{"$f":"IF(ISERR(DEGREES(ASIN(2*F9/F10))),\"\",DEGREES(ASIN(2*F9/F10)))","v":53.706941506570416},{"$f":"IF(ISERR(DEGREES(ASIN(2*G9/G10))),\"\",DEGREES(ASIN(2*G9/G10)))","v":39.222482206987834},32.947811135161757,43.072781346752492,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERR(DEGREES(ASIN(2*BC9/BC10))),\"\",DEGREES(ASIN(2*BC9/BC10)))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERR(DEGREES(ASIN(2*CI9/CI10))),\"\",DEGREES(ASIN(2*CI9/CI10)))","v":""},"","","","","","","","","","","","","","","","",""]

{"sheet":"Notes","index":4,"n_rows":110,"n_cols":5,"rows_kept":110,"cut":false,"hidden":false,"merged":[]}
[" "]
[null,"Figure 1.  Representation of how values in spreadsheet are calculated"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null," "]
[]
[]
[null,"Notes regarding how angle of approach is calculated given perimeter (running feet of headland)"]
[null,null,"and number of passes"]
[null,null,"p = perimeter distance per pass = running feet of headland divided by number of passes"]
[null,null,"c = p/2, or"]
[null,null,"w = width of swath"]
[null,null,"c = (w2 + b2)0.5"]
[null,null,"sine(a) = w/c, where angle a is expressed in radians"]
[null,null,"a = arcsine(w/c), where angle a is expressed in radians"," "]
[null,"Note that in Excel the angle must be expressed in radians for formulas to work"]
[]
[null,"Distance machine must travel into headland before whole boom can be shut off = b"]
[null,null,"tan(a) = w/b, where angle a is expressed in radians"]
[null,null,"b = w/tan(a), or"]
[null,null,"b = (c2 - w2)0.5"]
[null,"Crop input overlap area per pass = (Area A plus Q) times 2 since each pass has two ends"]
[null,null,"d = reaction distance of travel before manually shutoff boom"]
[null,null,"Q = d*w"]
[null,null,"Input overlap area per pass = (w*b/2 + Q)*2"]
[]
[null,"Notes about radians and degrees"]
[null,"A radian is defined this way:"]
[null,"If you have a circle with an angle whose vertex is at the center of that circle... "]
[null,"And if that angle is of such a size that the amount of the circumference of the circle which that angle intercepts"]
[null,null,"has an arc length equal to the length of the radius... "]
[null,"Then that angle has a measurement of one radian. "]
[null,"Here's another way to say it:"]
[null,"A central angle to a circle has a size of one radian if it subtends an arc length on the circle equal in length to"]
[null,null,"the radius."]
[null,"Excel formula for computing the number of degrees in a radian = 360/2/PI() "]
[null,"1 radian = 57.2957 degrees"]
[null,"1 degree = 0.0174532 radians"]
[null,"What is the reasoning behind these values? It works this way:"]
[null,"How many times can you trace an arc length equal to the size of the radius as you move around the "]
[null,null,"circumference of a circle? Well, here's the formula for the circumference of a circle:"]
[null,"C=2*pi*r"]
[null,"C is the circumference, and r is the radius."]
[null,"Looks like there are two pi radii around the circumference of a circle, or about 2 times 3.14, i.e., about 6.28, radii "]
[null,null,"around the circumference of a circle. Each one of these radius lengths would designate one radian, so there"]
[null,null,"are about 6.28 radians in a full circle."]
[]
[null,"A couple of relevant trigonometric functions:"]
[null,"Sine is the ratio of the length of the side opposite the acute angle to the hypotenuse in a right triangle."]
[null,"Tangent is the ratio of the length of the side opposite the acute angle to the adjacent side in a right triangle."]
[]
[]
[null,"Odd1 field (one on left in picture below)"]
[null,"167.4 acres; farmed north-south; 3960 feet west to east at widest point"]
[null,"Headland length is 16700 feet (whole perimeter)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Odd2 field"]
[null,"269.9 acres; farmed north-south; 5502 feet west to east at widest point"]
[null,"Headland length is 30690 feet (whole perimeter)"]

{"sheet":"Ammortization","index":5,"n_rows":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":false,"merged":[[30,1,32,6],[1,1,1,2]]}
[]
[null,"Amortization factors"]
[]
[null,null,"Interest Rate"]
[null,"Years",0.06,7.0000000000000007E-2,0.08,0.09,0.1]
[null,1,{"$f":"C$5/(1-(1+C$5)^(-$B6))","v":1.0599999999999981},1.07,1.0799999999999985,1.0899999999999992,1.0999999999999996]
[null,2,0.54543689320388289,0.55309178743961329,0.56076923076923058,0.56846889952153068,0.57619047619047592]
[null,3,0.374109812790551,0.38105166568166948,0.38803351404632802,0.39505475732894041,0.40211480362537733]
[null,4,0.2885914923732732,0.29522811666726351,0.30192080445403918,0.30866866209109761,0.31547080370609765]
[null,5,0.23739640043118937,0.24389069444137404,0.25045645456683652,0.25709245695674476,0.26379748079474524]
[null,6,0.20336262847489525,0.20979579975832816,0.21631538622900967,0.22291978329203693,0.22960738036266728]
[null,7,0.17913501805901066,0.18555321963115931,0.19207240142841048,0.19869051683359293,0.20540549970059557]
[null,8,0.16103594264812895,0.16746776249075465,0.17401476059182208,0.18067437783749626,0.18744401757481335]
[null,9,0.14702223500306358,0.15348647013842193,0.16007970917199471,0.1667988020571548,0.17364053907434343]
[null,10,0.13586795822038372,0.14237750272736471,0.14902948869707536,0.15582008990903373,0.16274539488251152]
[]
[null,"payment formula>",null,"PMT=PV*int/[1-(1+int)^(-N)]"]
[null,"payback time formula>",null,"N=-ln[1-PV*int/PMT]/ln(1+int)"]
[]
[null,null,null,"amortization","investment","payback","internal rate"]
[null,null,null,"mathematics","supported","in years","of return"]
[null,"interest rate (in)>",null,0.08,{"$f":"D22","v":0.08},{"$f":"D22","v":0.08},{"$f":"RATE(G23,G26,-G25,0,0,D22)","v":0.14418535244890601}]
[null,"number of years (N) >",null,4,{"$f":"D23","v":4},{"$f":"IF(E29<(D25*D22/D27),\"won't pay\",-LN(1-F25*D22/E26)/LN(1+D22))","v":3.4148291632617847},{"$f":"D23","v":4}]
[null,"payment factor>",null,{"$f":"D22/(1-(1+D22)^(-D23))","v":0.30192080445403918}]
[null,"investment (PV) >",null,13000,{"$f":"E29*E27*(1-(1+E22)^(-E23))/E22","v":14904.570780199503},{"$f":"D25","v":13000},{"$f":"D25","v":13000}]
[null,"annual payment (PMT) >",null,{"$f":"D22/(1-(1+D22)^(-D23))*D25","v":3924.9704579025092},{"$f":"D27*E29","v":4500},{"$f":"E27*F29","v":4500},{"$f":"F27*G29","v":4500}]
[null,"acres used on annually>",null,15000,{"$f":"D27","v":15000},{"$f":"E27","v":15000},{"$f":"F27","v":15000}]
[null,"investment per acre>",null,{"$f":"D25/D27","v":0.8666666666666667}]
[null,"annual cost/benefit per acre>",null,{"$f":"D26/D27","v":0.26166469719350061},0.3,{"$f":"E29","v":0.3},{"$f":"F29","v":0.3}]
[]
[null,"Note: The information contained in this tab is for illustrative purposes only.  Calculated values in the Results tab are based on information entered in the Inputs tab, but using the concepts shown here."]
[]
[]
[null,null,null," "]