{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","I Treated The Whole Field ","I Did Not Treat The Field"],"not_rendered":{"charts":2,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":35,"n_cols":11,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,1,15,9],[17,1,32,9],[34,1,34,9]]}
[]
[null,"\n\nRoot Rot Treatment ROI Calculator\nInstructions\ncottonrootrot.com"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"\nThere are two tabs in this calculator: \"I Treated The Field for Root Rot.\" and \"I Did Not Treat The Field for Root Rot.\" Just chose choose the tab that applies to the field you want to analyze.\n\nThe \"I Treated The Field for Root Rot\" spreadsheet will calculate the return on investment based on reducing fungicide costs through AeroInfo mapping and precision treatment prescription.\n\nThe \"I Did Not Treat The Field for Root Rot\" spreadsheet will calculate the return on investment from AeroInfo mapping and precision treatment prescription on an untreated field. This also includes an estimated yield gain in the treated areas.\n\nAt the top of each spreadsheet, enter the specifics for your field in the yellow cells. The ROI for the field will be calculated and displayed at the bottom. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Questions about the calculator or want more info? Just reach out to us by clicking here: ",null,null,null,null,null,null,null,null,"Got Rot?"]

{"sheet":"I Treated The Whole Field ","index":1,"n_rows":37,"n_cols":6,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"YEAR 1\n(Mapping)","YEAR 2\n(1st Precision Treatment)","YEAR 3\n(2nd Precision Treatment)"]
[null,"Enter Total Acres In Field"]
["Enter some basic details ","Estimate the percentage of the field that has root rot"]
["about your field","Enter your TopGuard application cost per acre"]
[]
[]
[null,null,null,"YEAR 1\n(Mapping)","YEAR 2\n(1st Precision Treatment)","YEAR 3\n(2nd Precision Treatment)"]
[null,"Estimated root rot acres",null,null,{"$f":"+D2*D3","v":0},{"$f":"+E8","v":0}]
[]
["Treatment Cost","Buffer Percentage (This is the area around the treated area we use as an application buffer)",null,null,0.2,0.2]
[]
[null,"Total Treated Acres",null,{"$f":"+D2","v":0},{"$f":"+E8+(E10*E8)","v":0},{"$f":"+F8+(F10*F8)","v":0}]
[]
[null,"Your Treatment Cost",null,{"$f":"+D4*D12","v":0},{"$f":"+E4*E12","v":0},{"$f":"+F4*F12","v":0}]
[]
[null,null,"CHOOSE YES/NO FROM DROP DOWN\n",null,0,0]
[null,"I Need A Map (I'll Write My Own Prescription)","No",{"$f":"IF(C17=\"Yes\", +D2*5,0)","v":0},0,0]
["Mapping & Prescription Cost (Chose One)","I Need A Prescription Written (I'll Send The Map)","No",{"$f":"IF(C18=\"Yes\", +D2*5,0)","v":0},0,0]
[null,"I Need A Map & Prescription","No",{"$f":"IF(C19=\"Yes\", +D2*10,0)","v":0},0,0]
[]
[null,"Total Cost",null,{"$f":"SUM(D17:D19)","v":0},{"$f":"+E16+E14","v":0},{"$f":"+F16+F14","v":0}]
[]
[null,"What you would have spent to treat the whole field",null,null,{"$f":"+D2*E4","v":0},{"$f":"+D2*F4","v":0}]
[]
[null,"Annual treatment savings",null,null,{"$f":"+E23-E21","v":0},{"$f":"+F23-F21","v":0}]
[]
[null,"Cumulative savings (treatment savings - mapping cost)",null,null,{"$f":"+E25-D21","v":0},{"$f":"+E27+F25","v":0}]
[]
[null,"ROI",null,null,{"$f":"IF(D21,E27/D21,0)","v":0},{"$f":"IF(D21,F27/D21,0)","v":0}]
[]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[]
[]
[null,null,null,null,false]
[null,null,null,null,true]
[null,null,null,null,true]

{"sheet":"I Did Not Treat The Field","index":2,"n_rows":44,"n_cols":13,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[null,null,"YEAR 1\n(Mapping)","YEAR 2\n(1st Precision Treatment)","YEAR 3\n(2nd Precision Treatment)"]
[null,"Enter the total acres of your field"]
[null,"Enter your average yield in pounds per acre for this field"]
["Enter some basic details ","Estimate the percentage of the field that has root rot"]
["about your field","Enter your TopGuard application cost per acre"]
[null,"Estimate the percent of control in the root rot areas"]
[null,"Enter your forecast cotton price (Cents/LB)"]
[null,"Enter your forecast cottonseed price ($/Ton)"]
[]
[]
[null,null,"YEAR 1\n(Mapping)","YEAR 2\n(1st Precision Treatment)","YEAR 3\n(2nd Precision Treatment)"]
[null,"Estimated root rot acres",null,{"$f":"+C4*C2","v":0},{"$f":"+C4*C2","v":0}]
[]
[null,"Buffer Percentage (This is the area around the treated area we use as an application buffer)",null,0.2,0.2]
["Treatment Cost"]
[null,"Total Treated Acres",null,{"$f":"+D12+(D14*D12)","v":0},{"$f":"+E12+(E14*E12)","v":0}]
[]
[null,"Your Treatment Cost",null,{"$f":"+D5*D16","v":0},{"$f":"+E16*E5","v":0}]
[]
[null,"Mapping & Prescription Cost @ $10 per acre",{"$f":"+C2*10","v":0},0,0]
[]
[null,"Total Field Treatment Cost",{"$f":"+C20+C18","v":0},{"$f":"+D20+D18","v":0},0]
[]
[]
[null,"Estimated yield pick up in PPA in the treated areas",null,{"$f":"+D12*($C3*D6)","v":0},{"$f":"+E12*($C3*E6)","v":0}]
[]
[null,"Dollar value of the yield pick up",null,{"$f":"+D25*D7","v":0},{"$f":"+E25*E7","v":0}]
["Gain from Treating"]
[null,"Estimated cottonseed yield pick up (Cotton LBs x 140%)",null,{"$f":"+D25*1.4","v":0},{"$f":"+E25*1.4","v":0}]
[]
[null,"Dollar value of cottonseed pick up",null,{"$f":"+D29*(D8/2000)","v":0},{"$f":"+E29*(E8/2000)","v":0}]
[]
[null,"Total value of yield gain with precision treatment",null,{"$f":"+D31+D27","v":0},{"$f":"+E31+E27","v":0}]
[]
[null,"Net gain after prescription & treatment costs"," ",{"$f":"+D33-D22-C22","v":0},{"$f":"+E33-E22","v":0}]
[]
[null,"Cumulative net gain after prescription & treatment costs",null,{"$f":"D35","v":0},{"$f":"D37+E35","v":0}]
[]
[null,"ROI after prescription and treatment costs"," ",{"$f":"IF(C22,D37/(C22+D22),0)","v":0},{"$f":"IF(C22,E37/(C22+D22+E22),0)","v":0}]
[null,null," "," "," ",null,null,null," ",null," ",null," "]
[null,null," "," ",null,null,null,null,"  "]
[null,null,null,{"$f":"IF(D39>0, \"RECOUP INVESTMENT IN 1 YEAR\",\" \")","v":" "},null,null,null,null," "]
[null,null,null,null,null,null,null,null," "]
[null,null,{"$f":"IF(E39>0, \"GAINS CONTINUE YEAR AFTER YEAR WITH NO ADDITIONAL INVESTMENT\",\" \")","v":" "},null,null,null,null,null," "]