{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["Directory","Total Costs","Equipment Ownership","Certificates & Licenses","Utilities","Software","Insurance","Maintenance & Repairs","Chemicals1","Chemicals2","Chemicals3","Chemicals4","Chemicals5","Chemicals6","Chemicals7","Chemicals8","Chemicals9","Chemicals10"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":34,"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":"Directory","index":0,"n_rows":33,"n_cols":13,"rows_kept":33,"cut":false,"hidden":false,"merged":[[30,1,30,4]]}
[]
[]
[null,null,"Drone Sprayer Cost Estimation Decision Aid"]
[]
[]
[null,"Directory",null,null,null,null,null,"User Notes",null,null,null,null,"Enabled"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Disabled"]
[null,"•  Standard Total Costs",null,null,null,null,null,"Value",null,"Requires user input for best cost estimation."]
[]
[null,null,"•  Equipment Ownership",null,null,null,null,"Value",null,"Indicates values are currently not included in cost estimation."]
[null,null,"•  Certificates & Licenses"]
[null,null,"•  Utilities",null,null,null,null,null,null,"Indicates a drop down menu."]
[null,null,"•  Software"]
[null,null,"•  Insurance"]
[null,null,"•  Maintenance & Repairs"]
[null,"Chemical Name"]
[null,"Corn Fungicide, 13.7 oz/acre","•  Chemical Component 1",null,"Enabled"]
[null,"Soybean Fungicide, 13.7 oz/acre","•  Chemical Component 2",null,"Enabled"]
[null,"Fungicide","•  Chemical Component 3",null,"Disabled"]
[null,"Pesticide ","•  Chemical Component 4",null,"Disabled"]
[null,"Herbicide","•  Chemical Component 5",null,"Disabled"]
[null,"Fungicide","•  Chemical Component 6",null,"Disabled"]
[null,"Pesticide ","•  Chemical Component 7",null,"Disabled"]
[null,"Herbicide","•  Chemical Component 8",null,"Disabled"]
[null,"Fungicide","•  Chemical Component 9",null,"Disabled"]
[null,"Pesticide ","•  Chemical Component 10",null,"Disabled"]
[]
[]
[null,"Contact"]
[null,"Josh Jackson"]
[null,"Biosystems and Agricultural Engineering Department"]
[null,"Email: joshjackson@uky.edu"]
[null,"Phone: (859) 612-7758"]

{"sheet":"Total Costs","index":1,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[[7,1,7,2]]}
[]
[]
[null,"Parameters"]
[]
[null,"Number of Flights Conducted Yearly",null,{"$f":"SUM(Chemicals1:Chemicals10!G48)","v":5682}]
[null,"Overall Acres Covered ",null,{"$f":"SUM(Chemicals1:Chemicals10!G45)","v":5000}]
[null,"Interest Rate",null,0.06]
[null,"Cost Viewpoint as Farmer or Service Provider",null,"Service Provider"]
[]
[null,"Expenditures","Initial Cost","Annual Cost","Cost Per Flight"]
[]
[null,"Capital Expenditure"]
[null,"      Equipment Ownership",{"$f":"'Equipment Ownership'!$G$43","v":128580},{"$f":"'Equipment Ownership'!$H$43","v":18741},{"$f":"'Equipment Ownership'!$I$43","v":3.29831045406547}]
[null,"      Interest (Opportunity Cost)",null,{"$f":"'Equipment Ownership'!J43","v":1559.5500518814795},{"$f":"'Equipment Ownership'!K43","v":0.27447202602630755}]
[]
[null,"Operational Expenditure"]
[null,"      Certificates & Licenses",{"$f":"'Certificates & Licenses'!$D$29","v":235},{"$f":"'Certificates & Licenses'!$E$29","v":147.5},{"$f":"'Certificates & Licenses'!$F$29","v":2.5959169306582191E-2},null,"Farmer"]
[null,"      Utilities",null,{"$f":"Utilities!K28","v":2040.49143},{"$f":"Utilities!L28","v":0.35911500000000002},null,"Service Provider"]
[null,"      Software",{"$f":"Software!$D$10","v":0},{"$f":"Software!E10","v":0},{"$f":"Software!F10","v":0}]
[null,"      Insurance",{"$f":"Insurance!$D$24","v":5000},{"$f":"Insurance!$E$24","v":5000},{"$f":"Insurance!$F$24","v":0.87997184090109115}]
[null,"      Maintenance & Repair",null,{"$f":"'Maintenance & Repairs'!$F$19","v":2700},{"$f":"'Maintenance & Repairs'!$G$19","v":0.4751847940865892}]
[]
[null,"Total Cost",{"$f":"SUM(C13:C21)","v":133815},{"$f":"SUM(D13:D21)","v":30188.541481881482},{"$f":"SUM(E13:E21)","v":5.3130132843860398}]
[]
[null,{"$f":"IF(D8=G18,\"Income\", \"Labor Cost\")","v":"Income"}]
[null,{"$f":"IF(D8=G18, \"Total Revenue\",\"Total Labor\")","v":"Total Revenue"},null,{"$f":"SUM(Chemicals1:Chemicals10!E89)","v":171359.65},{"$f":"D26/D5","v":30.158333333333331}]
[]
[null,"UAS Sprayer on a Per Acre Basis"]
[null,"UAS Cost Per Acre ",null,{"$f":"D23/D6","v":6.0377082963762962}]
[null,{"$f":"IF(D8=G18, \"UAS Revenue Per Acre\",\"UAS Labor Cost Per Acre\")","v":"UAS Revenue Per Acre"},null,{"$f":"D26/D6","v":34.271929999999998}]
[null,{"$f":"IF(D8=G18,\"Net Per Acre\",\"Total Cost Per Acre\")","v":"Net Per Acre"},null,{"$f":"IF(D8=G18,D30-D29,D30+D29)","v":28.234221703623703}]

{"sheet":"Equipment Ownership","index":2,"n_rows":43,"n_cols":11,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Equipment Information","Number of \nUnits","Purchase Price Per Unit","Years of \nEconomic Life ","Salvage \nValue","Total \nInitial Cost","Annual \nDepreciation","Cost Per \nFlight","Annual \nInterest","Interest Cost \nPer Flight"]
[]
[null,"Required"]
[null,"Sprayer UAS & Controller Station Package",3,18000,5,2000,{"$f":"D6*C6","v":54000},{"$f":"((D6-F6)/E6)*C6","v":9600},{"$f":"IFERROR((H6/'Total Costs'!$D$5),0)","v":1.6895459345300949},{"$f":"IF(C6=0,0,((D6+F6)/2)*'Total Costs'!$D$7)","v":600},{"$f":"J6/'Total Costs'!$D$5","v":0.10559662090813093}]
[null,"Battery Charger",2,1200,5,0,{"$f":"D7*C7","v":2400},480,{"$f":"H7/'Total Costs'!$D$5","v":8.4477296726504753E-2},{"$f":"IF(C7=0,0,((D7+F7)/2)*'Total Costs'!$D$7)","v":36},{"$f":"J7/'Total Costs'!$D$5","v":6.3357972544878568E-3}]
[null,"Tablet or Mobile Device",1,500,5,50,{"$f":"D8*C8","v":500},90,{"$f":"H8/'Total Costs'!$D$5","v":1.5839493136219639E-2},{"$f":"IF(C8=0,0,((D8+F8)/2)*'Total Costs'!$D$7)","v":16.5},{"$f":"J8/'Total Costs'!$D$5","v":2.903907074973601E-3}]
[null,"64 GB Micro SD Card (x4)",0,20,5,0,0,0,{"$f":"H9/'Total Costs'!$D$5","v":0},{"$f":"IF(C9=0,0,((D9+F9)/2)*'Total Costs'!$D$7)","v":0},{"$f":"J9/'Total Costs'!$D$5","v":0}]
[null,"Micro SD Card Reader",0,15,5,0,0,0,{"$f":"H10/'Total Costs'!$D$5","v":0},{"$f":"IF(C10=0,0,((D10+F10)/2)*'Total Costs'!$D$7)","v":0},{"$f":"J10/'Total Costs'!$D$5","v":0}]
[null,"Spare Batteries ",10,1000,5,0,{"$f":"D11*C11","v":10000},2000,{"$f":"H11/'Total Costs'!$D$5","v":0.35198873636043648},{"$f":"IF(C11=0,0,((D11+F11)/2)*'Total Costs'!$D$7)","v":30},{"$f":"J11/'Total Costs'!$D$5","v":5.279831045406547E-3}]
[null,"Landing Pad",0,20,5,0,0,0,{"$f":"H12/'Total Costs'!$D$5","v":0},{"$f":"IF(C12=0,0,((D12+F12)/2)*'Total Costs'!$D$7)","v":0},{"$f":"J12/'Total Costs'!$D$5","v":0}]
[null,"Spare Propellers",8,35,5,0,280,56,{"$f":"H13/'Total Costs'!$D$5","v":9.8556846180922215E-3},{"$f":"IF(C13=0,0,((D13+F13)/2)*'Total Costs'!$D$7)","v":1.05},{"$f":"J13/'Total Costs'!$D$5","v":1.8479408658922915E-4}]
[]
[null,"Optional "]
[null,"Wifi Hotspot",0,200,5,0,{"$f":"D16*C16","v":0},{"$f":"((D16-F16)/E16)*C16","v":0},{"$f":"H16/'Total Costs'!$D$5","v":0},{"$f":"IF(C16=0,0,((D16+F16)/2)*'Total Costs'!$D$7)","v":0},{"$f":"J16/'Total Costs'!$D$5","v":0}]
[null,"HDMI Cables",0,15,5,0,{"$f":"D17*C17","v":0},{"$f":"((D17-F17)/E17)*C17","v":0},{"$f":"H17/'Total Costs'!$D$5","v":0},{"$f":"IF(C17=0,0,((D17+F17)/2)*'Total Costs'!$D$7)","v":0},{"$f":"J17/'Total Costs'!$D$5","v":0}]
[null,"Lidar",0,8000,5,3000,0,0,{"$f":"H18/'Total Costs'!$D$5","v":0},{"$f":"IF(C18=0,0,((D18+F18)/2)*'Total Costs'!$D$7)","v":0},{"$f":"J18/'Total Costs'!$D$5","v":0}]
[null,"Multispec Camera",0,2000,5,500,0,0,{"$f":"H19/'Total Costs'!$D$5","v":0},{"$f":"IF(C19=0,0,((D19+F19)/2)*'Total Costs'!$D$7)","v":0},{"$f":"J19/'Total Costs'!$D$5","v":0}]
[null,"Thermal Camera",0,2000,5,0,0,0,{"$f":"H20/'Total Costs'!$D$5","v":0},{"$f":"IF(C20=0,0,((D20+F20)/2)*'Total Costs'!$D$7)","v":0},{"$f":"J20/'Total Costs'!$D$5","v":0}]
[null,"Other camera",0,1000,5,0,0,0,{"$f":"H21/'Total Costs'!$D$5","v":0},{"$f":"IF(C21=0,0,((D21+F21)/2)*'Total Costs'!$D$7)","v":0},{"$f":"J21/'Total Costs'!$D$5","v":0}]
[null,"Mounts",0,50,5,0,0,0,{"$f":"H22/'Total Costs'!$D$5","v":0},{"$f":"IF(C22=0,0,((D22+F22)/2)*'Total Costs'!$D$7)","v":0},{"$f":"J22/'Total Costs'!$D$5","v":0}]
[null,"Tank",1,500,5,0,{"$f":"D23*C23","v":500},{"$f":"((D23-F23)/E23)*C23","v":100},{"$f":"H23/'Total Costs'!$D$5","v":1.7599436818021823E-2},{"$f":"IF(C23=0,0,((D23+F23)/2)*'Total Costs'!$D$7)","v":15},{"$f":"J23/'Total Costs'!$D$5","v":2.6399155227032735E-3}]
[null,"Pump for tank",1,1200,5,0,{"$f":"D24*C24","v":1200},{"$f":"((D24-F24)/E24)*C24","v":240},{"$f":"H24/'Total Costs'!$D$5","v":4.2238648363252376E-2},{"$f":"IF(C24=0,0,((D24+F24)/2)*'Total Costs'!$D$7)","v":36},{"$f":"J24/'Total Costs'!$D$5","v":6.3357972544878568E-3}]
[null,"RTK Equipment",2,25000,10,2500,{"$f":"D25*C25","v":50000},{"$f":"((D25-F25)/E25)*C25","v":4500},{"$f":"H25/'Total Costs'!$D$5","v":0.791974656810982},{"$f":"IF(C25=0,0,((D25+F25)/2)*'Total Costs'!$D$7)","v":825},{"$f":"J25/'Total Costs'!$D$5","v":0.14519535374868003}]
[null,"Other",0,0,5,0,{"$f":"D26*C26","v":0},{"$f":"((D26-F26)/E26)*C26","v":0},{"$f":"H26/'Total Costs'!$D$5","v":0},{"$f":"IF(C26=0,0,((D26+F26)/2)*'Total Costs'!$D$7)","v":0},{"$f":"J26/'Total Costs'!$D$5","v":0}]
[null,"Other",0,0,5,0,0,0,{"$f":"H27/'Total Costs'!$D$5","v":0},{"$f":"IF(C27=0,0,((D27+F27)/2)*'Total Costs'!$D$7)","v":0},{"$f":"J27/'Total Costs'!$D$5","v":0}]
[null,"Other",0,0,5,0,0,0,{"$f":"H28/'Total Costs'!$D$5","v":0},{"$f":"IF(C28=0,0,((D28+F28)/2)*'Total Costs'!$D$7)","v":0},{"$f":"J28/'Total Costs'!$D$5","v":0}]
[null,"Other",0,0,5,0,0,0,{"$f":"H29/'Total Costs'!$D$5","v":0},{"$f":"IF(C29=0,0,((D29+F29)/2)*'Total Costs'!$D$7)","v":0},{"$f":"J29/'Total Costs'!$D$5","v":0}]
[]
[null,"Command Center Options"]
[null,"Sprayer Trailer",1,8000,5,0,{"$f":"D32*C32","v":8000},{"$f":"((D32-F32)/E32)*C32","v":1600},{"$f":"H32/'Total Costs'!$D$5","v":0.28159098908834918},{"$f":"I32/'Total Costs'!$D$5","v":4.9558428209846741E-5},{"$f":"J32/'Total Costs'!$D$5","v":8.7220042607966815E-9}]
[null,"Chair",2,50,5,0,100,20,{"$f":"H33/'Total Costs'!$D$5","v":3.5198873636043647E-3},{"$f":"I33/'Total Costs'!$D$5","v":6.1948035262308426E-7},{"$f":"J33/'Total Costs'!$D$5","v":1.0902505325995851E-10}]
[null,"Table ",1,100,10,0,100,10,{"$f":"H34/'Total Costs'!$D$5","v":1.7599436818021823E-3},{"$f":"I34/'Total Costs'!$D$5","v":3.0974017631154213E-7},{"$f":"J34/'Total Costs'!$D$5","v":5.4512526629979254E-11}]
[null,"Laptop",0,1500,5,0,0,0,{"$f":"H35/'Total Costs'!$D$5","v":0},{"$f":"I35/'Total Costs'!$D$5","v":0},{"$f":"J35/'Total Costs'!$D$5","v":0}]
[null,"Large Screen TV ",0,500,5,0,0,0,{"$f":"H36/'Total Costs'!$D$5","v":0},{"$f":"I36/'Total Costs'!$D$5","v":0},{"$f":"J36/'Total Costs'!$D$5","v":0}]
[null,"Generator",1,1500,20,600,1500,45,{"$f":"H37/'Total Costs'!$D$5","v":7.9197465681098197E-3},{"$f":"I37/'Total Costs'!$D$5","v":1.3938307934019395E-6},{"$f":"J37/'Total Costs'!$D$5","v":2.4530636983490666E-10}]
[null,"Power Converter",0,5,4.5,0,0,0,{"$f":"H38/'Total Costs'!$D$5","v":0},{"$f":"I38/'Total Costs'!$D$5","v":0},{"$f":"J38/'Total Costs'!$D$5","v":0}]
[null,"Mounts",0,75,4.5,0,0,0,{"$f":"H39/'Total Costs'!$D$5","v":0},{"$f":"I39/'Total Costs'!$D$5","v":0},{"$f":"J39/'Total Costs'!$D$5","v":0}]
[null,"Tent",0,200,3,0,0,0,{"$f":"H40/'Total Costs'!$D$5","v":0},{"$f":"I40/'Total Costs'!$D$5","v":0},{"$f":"J40/'Total Costs'!$D$5","v":0}]
[null,"Miscellaneous",0,1000,4.5,0,0,0,{"$f":"H41/'Total Costs'!$D$5","v":0},{"$f":"I41/'Total Costs'!$D$5","v":0},{"$f":"J41/'Total Costs'!$D$5","v":0}]
[]
[null,"Total Investment",null,null,null,null,{"$f":"SUM(G6:G41)","v":128580},{"$f":"SUM(H6:H41)","v":18741},{"$f":"SUM(I6:I41)","v":3.29831045406547},{"$f":"SUM(J6:J41)","v":1559.5500518814795},{"$f":"SUM(K6:K41)","v":0.27447202602630755}]

{"sheet":"Certificates & Licenses","index":3,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Certificates & Licenses for Sprayer Drones","Years \nValid","Purchase \nPrice","Annual \nCost","Cost Per \nFlight"]
[]
[null,"Required Federal"]
[null,"FAA Remote Pilot Certificate Knowledge Exam ",2,175,{"$f":"D6/C6","v":87.5},{"$f":"E6/'Total Costs'!$D$5","v":1.5399507215769095E-2}]
[null,"FAA UAS Registration",3,5,{"$f":"(D7*'Equipment Ownership'!C6)/C7","v":5},{"$f":"E7/'Total Costs'!$D$5","v":8.7997184090109117E-4}]
[null,"FAA Part 137 and 107.36 Exemptions (<55 lb.)",null,null,{"$f":"IFERROR((D8/C8),0)","v":0},{"$f":"E8/'Total Costs'!$D$5","v":0}]
[null,"Agricultural Aircraft Operator Certificate Application",null,null,{"$f":"IFERROR((D9/C9),0)","v":0},{"$f":"E9/'Total Costs'!$D$5","v":0}]
[null,"49 U.S.C. §44807 Exemption (> 55 lbs) ",null,null,0,{"$f":"E10/'Total Costs'!$D$5","v":0}]
[null,"FAA Part 61, 91, and 137 Exemptions (> 55 lb.)",null,null,0,{"$f":"E11/'Total Costs'!$D$5","v":0}]
[null,"Other ",0,0,0,{"$f":"E12/'Total Costs'!$D$5","v":0}]
[]
[null,"Optional Federal"]
[null,"FAA Study Material for Remote Pilot Test",1,20,{"$f":"IFERROR((D15/C15),0)","v":20},{"$f":"E15/'Total Costs'!$D$5","v":3.5198873636043647E-3}]
[null,"CFR § 107.35 (Operate Multiple Drones (< 55 lb.)",null,null,{"$f":"IFERROR((D16/C16),0)","v":0},{"$f":"E16/'Total Costs'!$D$5","v":0}]
[null,"Other ",0,0,0,{"$f":"E17/'Total Costs'!$D$5","v":0}]
[]
[null,"Required State (Kentucky)"]
[null,"Commercial Pesticide Applicator",1,10,{"$f":"IFERROR(D20/C20,0)","v":10},{"$f":"E20/'Total Costs'!$D$5","v":1.7599436818021823E-3}]
[null,"Commercial Pesticide Operator",1,25,{"$f":"IFERROR(D21/C21,0)","v":25},{"$f":"E21/'Total Costs'!$D$5","v":4.3998592045054559E-3}]
[null,"Other ",0,0,{"$f":"IFERROR((D22/C22),0)","v":0},{"$f":"E22/'Total Costs'!$D$5","v":0}]
[]
[null,"Required Other States"]
[null,"Other",0,0,{"$f":"IFERROR((D25/C25),0)","v":0},{"$f":"E25/'Total Costs'!$D$5","v":0}]
[null,"Other",0,0,0,{"$f":"E26/'Total Costs'!$D$5","v":0}]
[null,"Other",0,0,0,{"$f":"E27/'Total Costs'!$D$5","v":0}]
[]
[null,"Total Cost",null,{"$f":"SUM(D6:D28)","v":235},{"$f":"SUM(E6:E28)","v":147.5},{"$f":"SUM(F6:F28)","v":2.5959169306582191E-2}]

{"sheet":"Utilities","index":4,"n_rows":28,"n_cols":16,"rows_kept":28,"cut":false,"hidden":false,"merged":[[4,1,4,11],[12,1,12,11],[20,1,20,11],[26,1,26,9],[2,1,2,11],[3,1,3,11]]}
[]
[]
[null,"Select the Power Source"]
[null,"Batteries Only"]
[null,"Conventional Electric Resources"]
[null,"Equipment Information","Total \nCalculated \nFlights","% of Batteries Charged Using Conventional Electric ","Number of Batteries Recharged","Number of\nBatteries Used Per Flight","Charger Power \nRequirements (Watts)","Duration \nof Charge \n(Hours)","Cost Per \nkWh","Number of Batteries Simultaneously Charged","Annual \nCost","Cost Per \nFlight",null,null,"Batteries Only"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hybrid (Battery and Liquid Fuel)"]
[null,"UAS Battery",{"$f":"'Total Costs'!$D$5","v":5682},{"$f":"1-D16","v":5.0000000000000044E-2},{"$f":"C8*D8","v":284.10000000000025},1,2600,0.33,0.1,1,{"$f":"IF($B$4=$O$8,0,IFERROR((H8*G8*I8*F8/1000)*E8/J8,0))","v":24.375780000000027},{"$f":"K8/'Total Costs'!$D$5","v":4.2900000000000047E-3},null,null,"Fuel Only"]
[null,"Other",{"$f":"'Total Costs'!$D$5","v":5682},0,{"$f":"C9*D9","v":0},0.5,100,1,1.1000000000000001,1,{"$f":"IF($B$4=$O$8,0,IFERROR((H9*G9*I9*F9/1000)*E9/J9,0))","v":0},{"$f":"K9/'Total Costs'!$D$5","v":0}]
[]
[]
[]
[null,"Generator Fuel Use"]
[null,"Generator Fuel Use","Total Calculated Flights","% of Batteries Charged Using Generator Electric ","Number of Batteries Recharged","Number of\nBatteries Used Per Flight","Gallons of Fuel Used Per Hour by Generator","Duration of Charge (Hours)","Cost Per Gallon of Fuel","Number of Batteries Simultaneously Charged","Annual \nCost","Cost Per \nFlight"]
[]
[null,"Generator",{"$f":"'Total Costs'!$D$5","v":5682},0.95,{"$f":"C16*D16","v":5397.9},2,0.75,0.16600000000000001,3,2,{"$f":"IF(B4=O8,0,IFERROR((H16*G16*I16*F16)*E16/J16,0))","v":2016.11565},{"$f":"K16/C16","v":0.354825}]
[]
[]
[]
[]
[null,"Hybrid or Fuel Powered UAS"]
[null,"Hybrid or Fuel Powered UAS","Total Calculated Flights",{"$f":"IF(E24=\"Ounces\", \"Ounces of Fuel Used Per Flight\",IF(E24=\"Pints\",\"Pints of Fuel Used Per Flight\",IF(E24=\"Quarts\",\"Quarts of Fuel Used Per Flight\",\"Gallons of Fuel Used Per Flight\")))","v":"Ounces of Fuel Used Per Flight"},"Select UAS Fuel Units",null,null,null,"Cost Per Gallon \nof Fuel",null,"Annual \nCost","Cost Per \nFlight",null,null,null,"Ounces"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pints"]
[null,{"$f":"IF(B4=\"Hybrid (Battery and Liquid Fuel)\",\"Hybrid\",\"Fuel Powered ONLY UAS\")","v":"Fuel Powered ONLY UAS"},{"$f":"'Total Costs'!$D$5","v":5682},4,"Ounces",null,null,null,3,null,{"$f":"IF(B4=O6,0,IF(E24=\"Ounces\",CONVERT(D24,\"oz\",\"gal\")*C24*I24,IF(E24=\"Pints\",CONVERT(D24,\"us_pt\",\"gal\")*C24*I24,IF(E24=\"Quarts\",CONVERT(D24,\"qt\",\"gal\")*C24*I24,C24*D24*I24))))","v":0},{"$f":"IFERROR(K24/C24,0)","v":0},null,null,null,"Quarts"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gallons"]
[]
[null,"Total Utility Cost",null,null,null,null,null,null,null,null,"Annual \nCost","Cost Per \nFlight"]
[null,"Total Cost",null,null,null,null,null,null,null,null,{"$f":"SUM(K8:K9,K16,K24)","v":2040.49143},{"$f":"SUM(L8:L9,L16,L24)","v":0.35911500000000002}]

{"sheet":"Software","index":5,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Software","Years \nValid","Initial \nCost","Annual \nCost","Cost Per \nFlight"]
[]
[null,"Flight Software",0,0,{"$f":"IFERROR(D5/C5,0)","v":0},{"$f":"E5/'Total Costs'!$D$5","v":0}]
[null,"Post-Processing Software",0,0,{"$f":"IFERROR(D6/C6,0)","v":0},{"$f":"E6/'Total Costs'!$D$5","v":0}]
[null,"Upgrades & Support License",0,0,{"$f":"IFERROR(D7/C7,0)","v":0},{"$f":"E7/'Total Costs'!$D$5","v":0}]
[null,"Other",0,0,{"$f":"IFERROR(D8/C8,0)","v":0},{"$f":"E8/'Total Costs'!$D$5","v":0}]
[]
[null,"Total Cost",null,{"$f":"SUM(D5:D8)","v":0},{"$f":"SUM(E5:E8)","v":0},{"$f":"SUM(F5:F8)","v":0}]

{"sheet":"Insurance","index":6,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Insurance Information","Years \nValid","Intial \nCost","Annual \nCost","Cost Per\nFlight"]
[]
[null,"Hull Insurance",1,2500,{"$f":"IFERROR(D5/C5,0)","v":2500},{"$f":"E5/'Total Costs'!$D$5","v":0.43998592045054558}]
[null,"      Water Damage",null,null,{"$f":"IFERROR(D6/C6,0)","v":0},{"$f":"E6/'Total Costs'!$D$5","v":0}]
[null,"      Sensors",null,null,0,{"$f":"E7/'Total Costs'!$D$5","v":0}]
[]
[null,"Liability Insurance",1,2500,{"$f":"IFERROR(D9/C9,0)","v":2500},{"$f":"E9/'Total Costs'!$D$5","v":0.43998592045054558}]
[null,"Public Liability",null,null,{"$f":"IFERROR(D10/C10,0)","v":0},{"$f":"E10/'Total Costs'!$D$5","v":0}]
[null,"Chemical Liability",null,null,{"$f":"IFERROR(D11/C11,0)","v":0},{"$f":"E11/'Total Costs'!$D$5","v":0}]
[null,"Comprehensive Chemical Liability ",null,null,0,{"$f":"E12/'Total Costs'!$D$5","v":0}]
[null,"Crop Treated Liability ",null,null,0,{"$f":"E13/'Total Costs'!$D$5","v":0}]
[null,"Farmer Liability ",null,null,0,{"$f":"E14/'Total Costs'!$D$5","v":0}]
[null,"Adjacent Fields Liability ",null,null,0,{"$f":"E15/'Total Costs'!$D$5","v":0}]
[null,"Chemical Drift Liability ",null,null,0,{"$f":"E16/'Total Costs'!$D$5","v":0}]
[]
[null,"Additional Insurance",null,null,{"$f":"IFERROR(D18/C18,0)","v":0},{"$f":"E18/'Total Costs'!$D$5","v":0}]
[null,"Payload Coverage",null,null,{"$f":"IFERROR(D19/C19,0)","v":0},{"$f":"E19/'Total Costs'!$D$5","v":0}]
[null,"      Ground Station Coverage",null,null,0,{"$f":"E20/'Total Costs'!$D$5","v":0}]
[null,"      Non Owned Coverage",null,null,0,{"$f":"E21/'Total Costs'!$D$5","v":0}]
[null,"      Personal Injury Coverage",null,null,0,{"$f":"E22/'Total Costs'!$D$5","v":0}]
[]
[null,"Total Cost",null,{"$f":"SUM(D5:D22)","v":5000},{"$f":"SUM(E5:E22)","v":5000},{"$f":"SUM(F5:F22)","v":0.87997184090109115}]
[]
[null,"* Dedicated aviation insurance may have to be purchased."]

{"sheet":"Maintenance & Repairs","index":7,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[[22,1,24,6]]}
[]
[]
[null,"Equipment Information","Number of Units","Initial \nValue","Maintenance \n& Repair","Annual \nCost","Cost Per \nFlight"]
[]
[null,"Maintenance"]
[null,"UAS Platform ",{"$f":"'Equipment Ownership'!C6","v":3},{"$f":"'Equipment Ownership'!D6","v":18000},2.5000000000000001E-2,{"$f":"D6*E6*C6","v":1350},{"$f":"F6/'Total Costs'!$D$5","v":0.2375923970432946}]
[null,"      Mainframe",0,400,2.5000000000000001E-2,{"$f":"D7*E7*C7","v":0},{"$f":"F7/'Total Costs'!$D$5","v":0}]
[null,"      Power Plant",0,400,2.5000000000000001E-2,{"$f":"D8*E8*C8","v":0},{"$f":"F8/'Total Costs'!$D$5","v":0}]
[null,"      Navigation System",0,500,2.5000000000000001E-2,{"$f":"D9*E9*C9","v":0},{"$f":"F9/'Total Costs'!$D$5","v":0}]
[null,"      Electronic System",0,200,2.5000000000000001E-2,{"$f":"D10*E10*C10","v":0},{"$f":"F10/'Total Costs'!$D$5","v":0}]
[]
[null,"Repairs"]
[null,"UAS Platform",{"$f":"'Equipment Ownership'!C6","v":3},{"$f":"'Equipment Ownership'!D6","v":18000},{"$f":"E6","v":2.5000000000000001E-2},{"$f":"D13*E13*C13","v":1350},{"$f":"F13/'Total Costs'!$D$5","v":0.2375923970432946}]
[null,"      Mainframe",0,400,{"$f":"E7","v":2.5000000000000001E-2},{"$f":"D14*E14*C14","v":0},{"$f":"F14/'Total Costs'!$D$5","v":0}]
[null,"      Power Plant",{"$f":"C8","v":0},400,{"$f":"E8","v":2.5000000000000001E-2},{"$f":"D15*E15*C15","v":0},{"$f":"F15/'Total Costs'!$D$5","v":0}]
[null,"      Navigation System",{"$f":"C9","v":0},500,{"$f":"E9","v":2.5000000000000001E-2},{"$f":"D16*E16*C16","v":0},{"$f":"F16/'Total Costs'!$D$5","v":0}]
[null,"      Electronic System",{"$f":"C10","v":0},200,{"$f":"E10","v":2.5000000000000001E-2},{"$f":"D17*E17*C17","v":0},{"$f":"F17/'Total Costs'!$D$5","v":0}]
[]
[null,"Total Cost",null,null,null,{"$f":"SUM(F6:F17)","v":2700},{"$f":"SUM(G6:G17)","v":0.4751847940865892}]
[]
[null,"* Condition Based Maintenance = Cost Savings + Higher System Reliability + Reduced Liability"]
[]
[null,"* Impact of ineffective maintenance: Replacement cost of a lost UAS, cost of UAS accidents, reduced productivity due to loss of the actual time that the UAS is airborne, cancellation of contracts due to an on-site crash, liability exposure in the case of a crash causing personal injury, environmental damage or equipment damage"]

{"sheet":"Chemicals1","index":8,"n_rows":95,"n_cols":10,"rows_kept":95,"cut":false,"hidden":false,"merged":[[44,3,44,5],[45,3,45,5],[46,3,46,5],[47,3,47,5],[16,2,16,3],[16,4,16,5],[14,3,14,4],[2,1,2,5],[4,3,4,5],[5,2,5,5],[42,1,42,5]]}
[]
[]
[null,"Sheet Description "]
[]
[null,"Sheet Status",{"$f":"Directory!E17","v":"Enabled"},{"$f":"IF(C3=\"Disabled\",\"**To Activate Go to Directory Tab**\",\"\")","v":""}]
[null,"Chemical 1 Name",{"$f":"Directory!B17","v":"Corn Fungicide, 13.7 oz/acre"}]
[]
[]
[null,"Chemical & Drone Information",null,null,null,null,null,"oz Chem. Per Acre",null,"oz"]
[null,null,null,null,null,null,null,"pt Chem. Per Acre",null,"pt"]
[null,"Chemical Information",null,null,null,null,null,"qt Chem. Per Acre ",null,"qt"]
[null,"Chemical Cost",489.98,"per",2.5,"gal",null,null,null,"gal"]
[null,"Chemical Cost per Gallon",{"$f":"C12/IF(F12=\"oz\",CONVERT(E12,\"oz\",\"gal\"),IF(F12=\"pt\",CONVERT(E12,\"us_pt\",\"gal\"),IF(F12=\"qt\",CONVERT(E12,\"qt\",\"gal\"),E12)))","v":195.99200000000002},"/gal"]
[null,"Carrier Cost per Gallon",7.0000000000000001E-3,"/gal"]
[null,"Chemical Application Rate",13.7,"oz Chem. Per Acre"]
[null,null,null,null,null,null,{"$f":"IF(D15=\"oz Chem. Per Acre\",CONVERT($C$15,\"oz\",\"gal\")*$C$13+$C$14*($C$18-CONVERT($C$15,\"oz\",\"gal\")),IF(D15=\"pt Chem. Per Acre\",CONVERT($C$15,\"us_pt\",\"gal\")*$C$13+$C$14*($C$18-CONVERT($C$15,\"us_pt\",\"gal\")),CONVERT($C$15,\"qt\",\"gal\")*$C$13+$C$14*($C$18-CONVERT($C$15,\"qt\",\"gal\"))))","v":20.997519531249999}]
[null,"Spray Volume = (Chemical + Carrier)","Imperial Units",null,"Metric \nUnits",null,{"$f":"IF(D15=\"oz Chem. Per Acre\",-CONVERT($C$15,\"oz\",\"gal\")+$C$18,IF(D15=\"pt Chem. Per Acre\",-CONVERT(C15,\"us_pt\",\"gal\")+C18,-CONVERT(C15,\"qt\",\"gal\")+C18))","v":2.8929687500000001}]
[null,"Spray Volume Per Acre",3,"gal/acre",{"$f":"CONVERT(C18,\"gal\",\"l\")","v":11.356235351999999},"L/acre",{"$f":"IF(G17>=0,\"\",\"CHECK UNITS\")","v":""}]
[null,"Cost Per Spray Volume",{"$f":"G16/C18","v":6.9991731770833328},"/gal",{"$f":"C19/CONVERT(1,\"gal\",\"l\")","v":1.8489859430002062},"/L"]
[]
[null,"Drone Sprayer Specifications"]
[null,"Spray Tank Volume",2.64,"gal",{"$f":"CONVERT(C22,\"gal\",\"l\")","v":9.9934871097600002},"L"]
[null,"Max. Operating Speed for Spraying  ",15,"mph",{"$f":"CONVERT(C23,\"mph\",\"m/sec\")","v":6.7055999999999996},"m/s"]
[null,"Effective Spray Width",16.399999999999999,"ft",{"$f":"CONVERT(C24,\"ft\",\"m\")","v":4.9987199999999996},"m"]
[null,"Max. Flow Rate",1.32,"gal/min",{"$f":"CONVERT(C25,\"gal\",\"l\")","v":4.9967435548800001},"L/min"]
[null,"Max. Flight Time",15,"min",{"$f":"C26","v":15},"min"]
[null,"Max. Sprayer Application Time",13,"min",{"$f":"C27","v":13},"min"]
[]
[null,"Calculated Flow Rate Required at Max. Operating Speed",{"$f":"CONVERT(E29,\"l\",\"gal\")","v":1.4909077728807023},"gal/min",{"$f":"$E$18*E23*60*$E$24/4046.86","v":5.6436998523198056},"L/min",{"$f":"IF(E29>E25,\"Too High\",\"\")","v":"Too High"}]
[null,"Calculated Speed Required at Max. Operating Flow Rate",{"$f":"CONVERT(E30,\"m/sec\",\"mph\")","v":13.280499545416438},"mph",{"$f":"E25/E18*4046.86/E24/60","v":5.9369145167829647},"m/s"]
[]
[null,"SET Actual Operating Speed",{"$f":"CONVERT(E32,\"m/sec\",\"mph\")","v":13.280499545416438},"mph",{"$f":"IF(E30<E23,E30,E23)","v":5.9369145167829647},"m/s"]
[null,"Flow Rate at Actual Operating Speed",{"$f":"CONVERT(E33,\"l\",\"gal\")","v":1.3199999999999998},"gal/min",{"$f":"$E$18*E32*60*$E$24/4046.86","v":4.9967435548799992},"L/min"]
[]
[null,"Full Load"]
[null,"Operational Flight Time Required to Empty Tank Completely",{"$f":"E22/E33","v":2.0000000000000004},"min",{"$f":"C36","v":2.0000000000000004},"min",{"$f":"IF(C36>E27,\"* Partial Load\",IF(AND(C36<=E27,C36>=E27*0.8),\"*Watch Time\",\"* Good Time\"))","v":"* Good Time"}]
[null,"Acres Sprayed Per Flight",{"$f":"C36*E32*60*E24/4046.86","v":0.88000000000000034},"acre",{"$f":"C37","v":0.88000000000000034},"acre"]
[]
[null,"Partial Load "]
[null,"Application Amount",{"$f":"CONVERT(E40,\"l\",\"gal\")","v":17.16},"gal",{"$f":"E27*E33","v":64.957666213439992},"L"]
[null,"Acres Covered Per Flight",{"$f":"E41","v":5.7200000000000015},"acre",{"$f":"E27*E32*60*E24/4046.86","v":5.7200000000000015},"acre"]
[]
[null,"Flight Information"]
[]
[null,"Total Acres Sprayed",2500,"acres",null,null,{"$f":"IF(C5=\"Enabled\",C45,\"\")","v":2500}]
[null,"Number of Drones Available",{"$f":"'Equipment Ownership'!C6","v":3},"drones"]
[null,"Number of Drones Used",3,"drones"]
[null,"Total Number of Flights",{"$f":"ROUNDUP(IF(G36=\"* Partial Load\",C45/E41,C45/(C37)),0)","v":2841},"flights",null,null,{"$f":"IF(C5=\"Enabled\",C48,\"\")","v":2841}]
[]
[]
[null,"Personnel Information"]
[]
[null,"Overall Labor Cost",450,"/hour"]
[]
[null,null,null,null,{"$f":"IF(C47>1,\"Assumes Simulataneous UAS Spraying\",\"\")","v":"Assumes Simulataneous UAS Spraying"}]
[null,"Personnel Responsibilities","Time Allocated Per Flight (Minutes)","Labor Cost ($/hr)","Total Time (Hours)","Annual \nCost","Annual \nCost Per UAS","Cost Per \nFlight"]
[]
[null,"Flight Planning & Setup",0.1,{"$f":"$C$53","v":450},{"$f":"C58*$C$48/60/$C$47","v":1.5783333333333334},{"$f":"(D58*C58/60)*$C$48","v":2130.75},{"$f":"(D58*C58/60)*$C$48/$C$47","v":710.25},{"$f":"G58/($C$48/$C$47)","v":0.75}]
[null,"Ferrying",0.5,450,7.8916666666666666,10653.75,{"$f":"D59*C59/60*$C$48/$C$47","v":3551.25},{"$f":"G59/($C$48/$C$47)","v":3.75}]
[null,"Actual UAS Spraying Time",{"$f":"IF(G36=\"* Partial Load\",E27,Chemicals1!C36)","v":2.0000000000000004},450,31.566666666666674,42615.000000000007,14205.000000000002,15.000000000000002]
[null,"Time Spent Between Flights",0.5,450,7.8916666666666666,10653.75,3551.25,3.75]
[null,"Post-Processing",0,450,0,0,0,0]
[null,"Visual Observer",{"$f":"SUM(C58:C61)","v":3.1000000000000005},20,48.928333333333342,2935.7000000000007,978.56666666666695,1.0333333333333337]
[null,"Other",0,450,0,0,0,0]
[]
[null,"Personnel Total Cost",null,null,null,{"$f":"SUM(F58:F64)","v":68988.95},{"$f":"SUM(G58:G64)","v":22996.316666666666},{"$f":"SUM(H58:H64)","v":24.283333333333335}]
[]
[null,"Total Man Hours",null,null,{"$f":"SUM(E58:E64)","v":97.856666666666683}]
[null,"Pilot in Command (PIC) Hours",null,null,{"$f":"SUM(E58:E62,E64)","v":48.928333333333342}]
[null,"Pilot in Command (PIC) Weeks (40 hrs)",null,null,{"$f":"E69/40","v":1.2232083333333335}]
[null,"Capacity (Acres Per Hour) PIC",null,null,{"$f":"C45/E69","v":51.095139149095608}]
[]
[null,"Economic Considerations"]
[]
[null,"Cost Per Flight"]
[null,"Total UAS Cost of Application Per Flight",{"$f":"('Total Costs'!E23)+H66","v":29.596346617719377},"/flight"]
[null,"Total Chemical Cost Per Flight",{"$f":"E22*E19","v":18.477817187500001},"/flight"]
[null,"Total Cost (UAS & Chemical) Per Flight",{"$f":"SUM(C76:C77)","v":48.074163805219378},"/flight"]
[]
[null,"Cost Per Acre"]
[null,"Total UAS Cost of Application Per Acre",{"$f":"IF($G$36=\"* Partial Load\",$C$76/$E$41,$C$76/$C$37)","v":33.632212065590188},"/acre"]
[null,"Total Chemical Cost Per Acre",{"$f":"E19*E18","v":20.997519531249996},"/acre"]
[null,"Total Cost (UAS & Chemical) Per Acre",{"$f":"SUM(C81:C82)","v":54.629731596840188},"/acre"]
[]
[]
[null,"$/bu for Crop",8,"/bu"]
[null,"Breakeven Increase in \nYield Bu/Acre Required",{"$f":"C83/C86","v":6.8287164496050234},"bu"]
[]
[null,{"$f":"IF('Total Costs'!D8='Total Costs'!G17,\"Pilot in Command (PIC) Cost\",\"Pilot in Command (PIC) Income\")","v":"Pilot in Command (PIC) Income"},{"$f":"SUM(G58:G62,G64)*C47","v":66053.25},null,{"$f":"IF(C5=\"Enabled\",F66,\"\")","v":68988.95}]
[null,"Pilot in Command (PIC) ($/Flight)",{"$f":"C89/C48","v":23.25},"/flight"]
[]
[null,"Total Cost (UAS & Chemical) ",{"$f":"C83*C45","v":136574.32899210046}]
[]
[]
[null,"Desired Total UAS Cost of Application Per Acre",12,"/acre"]

{"sheet":"Chemicals2","index":9,"n_rows":95,"n_cols":10,"rows_kept":95,"cut":false,"hidden":false,"merged":[[2,1,2,5],[4,3,4,5],[5,2,5,5],[14,3,14,4],[16,2,16,3],[16,4,16,5],[42,1,42,5],[44,3,44,5],[45,3,45,5],[46,3,46,5],[47,3,47,5]]}
[]
[]
[null,"Sheet Description "]
[]
[null,"Sheet Status",{"$f":"Directory!E18","v":"Enabled"},{"$f":"IF(C3=\"Disabled\",\"**To Activate Go to Directory Tab**\",\"\")","v":""}]
[null,"Chemical 1 Name",{"$f":"Directory!B18","v":"Soybean Fungicide, 13.7 oz/acre"}]
[]
[]
[null,"Chemical & Drone Information",null,null,null,null,null,"oz Chem. Per Acre",null,"oz"]
[null,null,null,null,null,null,null,"pt Chem. Per Acre",null,"pt"]
[null,"Chemical Information",null,null,null,null,null,"qt Chem. Per Acre ",null,"qt"]
[null,"Chemical Cost",489.98,"per",2.5,"gal",null,null,null,"gal"]
[null,"Chemical Cost per Gallon",{"$f":"C12/IF(F12=\"oz\",CONVERT(E12,\"oz\",\"gal\"),IF(F12=\"pt\",CONVERT(E12,\"us_pt\",\"gal\"),IF(F12=\"qt\",CONVERT(E12,\"qt\",\"gal\"),E12)))","v":195.99200000000002},"/gal"]
[null,"Carrier Cost per Gallon",7.0000000000000001E-3,"/gal"]
[null,"Chemical Application Rate",13.7,"oz Chem. Per Acre"]
[null,null,null,null,null,null,{"$f":"IF(D15=\"oz Chem. Per Acre\",CONVERT($C$15,\"oz\",\"gal\")*$C$13+$C$14*($C$18-CONVERT($C$15,\"oz\",\"gal\")),IF(D15=\"pt Chem. Per Acre\",CONVERT($C$15,\"us_pt\",\"gal\")*$C$13+$C$14*($C$18-CONVERT($C$15,\"us_pt\",\"gal\")),CONVERT($C$15,\"qt\",\"gal\")*$C$13+$C$14*($C$18-CONVERT($C$15,\"qt\",\"gal\"))))","v":20.997519531249999}]
[null,"Spray Volume = (Chemical + Carrier)","Imperial Units",null,"Metric \nUnits",null,{"$f":"IF(D15=\"oz Chem. Per Acre\",-CONVERT($C$15,\"oz\",\"gal\")+$C$18,IF(D15=\"pt Chem. Per Acre\",-CONVERT(C15,\"us_pt\",\"gal\")+C18,-CONVERT(C15,\"qt\",\"gal\")+C18))","v":2.8929687500000001}]
[null,"Spray Volume Per Acre",3,"gal/acre",{"$f":"CONVERT(C18,\"gal\",\"l\")","v":11.356235351999999},"L/acre",{"$f":"IF(G17>=0,\"\",\"CHECK UNITS\")","v":""}]
[null,"Cost Per Spray Volume",{"$f":"G16/C18","v":6.9991731770833328},"/gal",{"$f":"C19/CONVERT(1,\"gal\",\"l\")","v":1.8489859430002062},"/L"]
[]
[null,"Drone Sprayer Specifications"]
[null,"Spray Tank Volume",2.64,"gal",{"$f":"CONVERT(C22,\"gal\",\"l\")","v":9.9934871097600002},"L"]
[null,"Max. Operating Speed for Spraying  ",15.66,"mph",{"$f":"CONVERT(C23,\"mph\",\"m/sec\")","v":7.0006463999999999},"m/s"]
[null,"Effective Spray Width",16.399999999999999,"ft",{"$f":"CONVERT(C24,\"ft\",\"m\")","v":4.9987199999999996},"m"]
[null,"Max. Flow Rate",1.32,"gal/min",{"$f":"CONVERT(C25,\"gal\",\"l\")","v":4.9967435548800001},"L/min"]
[null,"Max. Flight Time",15,"min",{"$f":"C26","v":15},"min"]
[null,"Sprayer Application Time",13,"min",{"$f":"C27","v":13},"min"]
[]
[null,"Calculated Flow Rate Required at Max. Operating Speed",{"$f":"CONVERT(E29,\"l\",\"gal\")","v":1.5565077148874533},"gal/min",{"$f":"$E$18*E23*60*$E$24/4046.86","v":5.8920226458218776},"L/min",{"$f":"IF(E29>E25,\"Too High\",\"\")","v":"Too High"}]
[null,"Calculated Speed Required at Max. Operating Flow Rate",{"$f":"CONVERT(E30,\"m/sec\",\"mph\")","v":13.280499545416438},"mph",{"$f":"E25/E18*4046.86/E24/60","v":5.9369145167829647},"m/s"]
[]
[null,"SET Actual Operating Speed",{"$f":"CONVERT(E32,\"m/sec\",\"mph\")","v":13.280499545416438},"mph",{"$f":"IF(E30<E23,E30,E23)","v":5.9369145167829647},"m/s"]
[null,"Flow Rate at Actual Operating Speed",{"$f":"CONVERT(E33,\"l\",\"gal\")","v":1.3199999999999998},"gal/min",{"$f":"$E$18*E32*60*$E$24/4046.86","v":4.9967435548799992},"L/min"]
[]
[null,"Full Load"]
[null,"Operational Flight Time Required to Empty Tank Completely",{"$f":"E22/E33","v":2.0000000000000004},"min",{"$f":"C36","v":2.0000000000000004},"min",{"$f":"IF(C36>E27,\"* Partial Load\",IF(AND(C36<=E27,C36>=E27*0.8),\"*Watch Time\",\"* Good Time\"))","v":"* Good Time"}]
[null,"Acres Sprayed Per Flight",{"$f":"C36*E32*60*E24/4046.86","v":0.88000000000000034},"acre",{"$f":"C37","v":0.88000000000000034},"acre"]
[]
[null,"Partial Load "]
[null,"Application Amount",{"$f":"CONVERT(E40,\"l\",\"gal\")","v":17.16},"gal",{"$f":"E27*E33","v":64.957666213439992},"L"]
[null,"Acres Covered Per Flight",{"$f":"E41","v":5.7200000000000015},"acre",{"$f":"E27*E32*60*E24/4046.86","v":5.7200000000000015},"acre"]
[]
[null,"Flight Information"]
[]
[null,"Total Acres Sprayed",2500,"acres",null,null,{"$f":"IF(C5=\"Enabled\",C45,\"\")","v":2500}]
[null,"Number of Drones Available",{"$f":"'Equipment Ownership'!C6","v":3},"drones"]
[null,"Number of Drones Used",3,"drones"]
[null,"Total Number of Flights",{"$f":"ROUNDUP(IF(G36=\"* Partial Load\",C45/E41,C45/(C37)),0)","v":2841},"flights",null,null,{"$f":"IF(C5=\"Enabled\",C48,\"\")","v":2841}]
[]
[]
[null,"Personnel Information"]
[]
[null,"Overall Labor Cost",450,"/hour"]
[]
[null,null,null,null,{"$f":"IF(C47>1,\"Assumes Simulataneous UAS Spraying\",\"\")","v":"Assumes Simulataneous UAS Spraying"}]
[null,"Personnel Responsibilities","Time Allocated Per Flight (Minutes)","Labor Cost ($/hr)","Total Time (Hours)","Annual \nCost","Annual \nCost Per UAS","Cost Per \nFlight"]
[]
[null,"Flight Planning & Setup",0.1,{"$f":"$C$53","v":450},{"$f":"C58*$C$48/60/$C$47","v":1.5783333333333334},{"$f":"(D58*C58/60)*$C$48","v":2130.75},{"$f":"(D58*C58/60)*$C$48/$C$47","v":710.25},{"$f":"G58/($C$48/$C$47)","v":0.75}]
[null,"Ferrying",0.5,450,7.8916666666666666,10653.75,{"$f":"D59*C59/60*$C$48/$C$47","v":3551.25},{"$f":"G59/($C$48/$C$47)","v":3.75}]
[null,"Actual UAS Spraying Time",{"$f":"IF(G36=\"* Partial Load\",E27,Chemicals2!C36)","v":2.0000000000000004},450,31.566666666666674,42615.000000000007,14205.000000000002,15.000000000000002]
[null,"Time Spent Between Flights",2,450,31.566666666666666,42615,14205,15]
[null,"Post-Processing",0,450,0,0,0,0]
[null,"Visual Observer",{"$f":"SUM(C58:C61)","v":4.6000000000000005},20,72.603333333333339,4356.2000000000007,1452.0666666666668,1.5333333333333334]
[null,"Other",0,450,0,0,0,0]
[]
[null,"Personnel Total Cost",null,null,null,{"$f":"SUM(F58:F64)","v":102370.7},{"$f":"SUM(G58:G64)","v":34123.566666666666},{"$f":"SUM(H58:H64)","v":36.033333333333331}]
[]
[null,"Total Man Hours",null,null,{"$f":"SUM(E58:E64)","v":145.20666666666668}]
[null,"Pilot in Command (PIC) Hours",null,null,{"$f":"SUM(E58:E62,E64)","v":72.603333333333339}]
[null,"Pilot in Command (PIC) Weeks (40 hrs)",null,null,{"$f":"E69/40","v":1.8150833333333334}]
[null,"Acres/Hour PIC",null,null,{"$f":"C45/E69","v":34.433680730912258}]
[]
[null,"Economic Considerations"]
[]
[null,"Cost Per Flight"]
[null,"Total UAS Cost of Application Per Flight",{"$f":"('Total Costs'!E23)+H66","v":41.346346617719369},"/flight"]
[null,"Total Chemical Cost Per Flight",{"$f":"E22*E19","v":18.477817187500001},"/flight"]
[null,"Total Cost (UAS & Chemical) Per Flight",{"$f":"SUM(C76:C77)","v":59.824163805219371},"/flight"]
[]
[null,"Cost Per Acre"]
[null,"Total UAS Cost of Application Per Acre",{"$f":"IF($G$36=\"* Partial Load\",$C$76/$E$41,$C$76/$C$37)","v":46.984484792862901},"/acre"]
[null,"Total Chemical Cost Per Acre",{"$f":"E19*E18","v":20.997519531249996},"/acre"]
[null,"Total Cost (UAS & Chemical) Per Acre",{"$f":"SUM(C81:C82)","v":67.982004324112893},"/acre"]
[]
[]
[null,"$/bu for Crop",10,"/bu"]
[null,"Breakeven Increase in \nYield Bu/Acre Required",{"$f":"C83/C86","v":6.7982004324112895},"bu"]
[]
[null,{"$f":"IF('Total Costs'!D8='Total Costs'!G17,\"Pilot in Command (PIC) Cost\",\"Pilot in Command (PIC) Income\")","v":"Pilot in Command (PIC) Income"},{"$f":"SUM(G58:G62,G64)*C47","v":98014.5},null,{"$f":"IF(C5=\"Enabled\",F66,\"\")","v":102370.7}]
[null,"Pilot in Command (PIC) ($/Flight)",{"$f":"C89/C48","v":34.5},"/flight"]
[]
[null,"Total Cost (UAS & Chemical) ",{"$f":"C83*C45","v":169955.01081028223}]
[]
[]
[null,"Desired Total UAS Cost of Application Per Acre",12,"/acre"]

{"sheet":"Chemicals3","index":10,"n_rows":95,"n_cols":10,"rows_kept":95,"cut":false,"hidden":false,"merged":[[2,1,2,5],[4,3,4,5],[5,2,5,5],[14,3,14,4],[16,2,16,3],[16,4,16,5],[42,1,42,5],[44,3,44,5],[45,3,45,5],[46,3,46,5],[47,3,47,5]]}
[]
[]
[null,"Sheet Description "]
[]
[null,"Sheet Status",{"$f":"Directory!E19","v":"Disabled"},{"$f":"IF(C3=\"Disabled\",\"**To Activate Go to Directory Tab**\",\"\")","v":""}]
[null,"Chemical 1 Name",{"$f":"Directory!B19","v":"Fungicide"}]
[]
[]
[null,"Chemical & Drone Information",null,null,null,null,null,"oz Chem. Per Acre",null,"oz"]
[null,null,null,null,null,null,null,"pt Chem. Per Acre",null,"pt"]
[null,"Chemical Information",null,null,null,null,null,"qt Chem. Per Acre ",null,"qt"]
[null,"Chemical Cost",489.98,"per",2.5,"gal",null,null,null,"gal"]
[null,"Chemical Cost per Gallon",{"$f":"C12/IF(F12=\"oz\",CONVERT(E12,\"oz\",\"gal\"),IF(F12=\"pt\",CONVERT(E12,\"us_pt\",\"gal\"),IF(F12=\"qt\",CONVERT(E12,\"qt\",\"gal\"),E12)))","v":195.99200000000002},"/gal"]
[null,"Carrier Cost per Gallon",7.0000000000000001E-3,"/gal"]
[null,"Chemical Application Rate",13.7,"oz Chem. Per Acre"]
[null,null,null,null,null,null,{"$f":"IF(D15=\"oz Chem. Per Acre\",CONVERT($C$15,\"oz\",\"gal\")*$C$13+$C$14*($C$18-CONVERT($C$15,\"oz\",\"gal\")),IF(D15=\"pt Chem. Per Acre\",CONVERT($C$15,\"us_pt\",\"gal\")*$C$13+$C$14*($C$18-CONVERT($C$15,\"us_pt\",\"gal\")),CONVERT($C$15,\"qt\",\"gal\")*$C$13+$C$14*($C$18-CONVERT($C$15,\"qt\",\"gal\"))))","v":20.997519531249999}]
[null,"Spray Volume = (Chemical + Carrier)","Imperial Units",null,"Metric \nUnits",null,{"$f":"IF(D15=\"oz Chem. Per Acre\",-CONVERT($C$15,\"oz\",\"gal\")+$C$18,IF(D15=\"pt Chem. Per Acre\",-CONVERT(C15,\"us_pt\",\"gal\")+C18,-CONVERT(C15,\"qt\",\"gal\")+C18))","v":2.8929687500000001}]
[null,"Spray Volume Per Acre",3,"gal/acre",{"$f":"CONVERT(C18,\"gal\",\"l\")","v":11.356235351999999},"L/acre",{"$f":"IF(G17>=0,\"\",\"CHECK UNITS\")","v":""}]
[null,"Cost Per Spray Volume",{"$f":"G16/C18","v":6.9991731770833328},"/gal",{"$f":"C19/CONVERT(1,\"gal\",\"l\")","v":1.8489859430002062},"/L"]
[]
[null,"Drone Sprayer Specifications"]
[null,"Spray Tank Volume",2.64,"gal",{"$f":"CONVERT(C22,\"gal\",\"l\")","v":9.9934871097600002},"L"]
[null,"Max. Operating Speed for Spraying  ",15.66,"mph",{"$f":"CONVERT(C23,\"mph\",\"m/sec\")","v":7.0006463999999999},"m/s"]
[null,"Effective Spray Width",16.399999999999999,"ft",{"$f":"CONVERT(C24,\"ft\",\"m\")","v":4.9987199999999996},"m"]
[null,"Max. Flow Rate",1.32,"gal/min",{"$f":"CONVERT(C25,\"gal\",\"l\")","v":4.9967435548800001},"L/min"]
[null,"Max. Flight Time",15,"min",{"$f":"C26","v":15},"min"]
[null,"Sprayer Application Time",13,"min",{"$f":"C27","v":13},"min"]
[]
[null,"Calculated Flow Rate Required at Max. Operating Speed",{"$f":"CONVERT(E29,\"l\",\"gal\")","v":1.5565077148874533},"gal/min",{"$f":"$E$18*E23*60*$E$24/4046.86","v":5.8920226458218776},"L/min",{"$f":"IF(E29>E25,\"Too High\",\"\")","v":"Too High"}]
[null,"Calculated Speed Required at Max. Operating Flow Rate",{"$f":"CONVERT(E30,\"m/sec\",\"mph\")","v":13.280499545416438},"mph",{"$f":"E25/E18*4046.86/E24/60","v":5.9369145167829647},"m/s"]
[]
[null,"SET Actual Operating Speed",{"$f":"CONVERT(E32,\"m/sec\",\"mph\")","v":13.280499545416438},"mph",{"$f":"IF(E30<E23,E30,E23)","v":5.9369145167829647},"m/s"]
[null,"Flow Rate at Actual Operating Speed",{"$f":"CONVERT(E33,\"l\",\"gal\")","v":1.3199999999999998},"gal/min",{"$f":"$E$18*E32*60*$E$24/4046.86","v":4.9967435548799992},"L/min"]
[]
[null,"Full Load"]
[null,"Operational Flight Time Required to Empty Tank Completely",{"$f":"E22/E33","v":2.0000000000000004},"min",{"$f":"C36","v":2.0000000000000004},"min",{"$f":"IF(C36>E27,\"* Partial Load\",IF(AND(C36<=E27,C36>=E27*0.8),\"*Watch Time\",\"* Good Time\"))","v":"* Good Time"}]
[null,"Acres Sprayed Per Flight",{"$f":"C36*E32*60*E24/4046.86","v":0.88000000000000034},"acre",{"$f":"C37","v":0.88000000000000034},"acre"]
[]
[null,"Partial Load "]
[null,"Application Amount",{"$f":"CONVERT(E40,\"l\",\"gal\")","v":17.16},"gal",{"$f":"E27*E33","v":64.957666213439992},"L"]
[null,"Acres Covered Per Flight",{"$f":"E41","v":5.7200000000000015},"acre",{"$f":"E27*E32*60*E24/4046.86","v":5.7200000000000015},"acre"]
[]
[null,"Flight Information"]
[]
[null,"Total Acres Sprayed",2500,"acres",null,null,{"$f":"IF(C5=\"Enabled\",C45,\"\")","v":""}]
[null,"Number of Drones Available",{"$f":"'Equipment Ownership'!C6","v":3},"drones"]
[null,"Number of Drones Used",3,"drones"]
[null,"Total Number of Flights",{"$f":"ROUNDUP(IF(G36=\"* Partial Load\",C45/E41,C45/(C37)),0)","v":2841},"flights",null,null,{"$f":"IF(C5=\"Enabled\",C48,\"\")","v":""}]
[]
[]
[null,"Personnel Information"]
[]
[null,"Overall Labor Cost",450,"/hour"]
[]
[null,null,null,null,{"$f":"IF(C47>1,\"Assumes Simulataneous UAS Spraying\",\"\")","v":"Assumes Simulataneous UAS Spraying"}]
[null,"Personnel Responsibilities","Time Allocated Per Flight (Minutes)","Labor Cost ($/hr)","Total Time (Hours)","Annual \nCost","Annual \nCost Per UAS","Cost Per \nFlight"]
[]
[null,"Flight Planning & Setup",0.1,{"$f":"$C$53","v":450},{"$f":"C58*$C$48/60/$C$47","v":1.5783333333333334},{"$f":"(D58*C58/60)*$C$48","v":2130.75},{"$f":"(D58*C58/60)*$C$48/$C$47","v":710.25},{"$f":"G58/($C$48/$C$47)","v":0.75}]
[null,"Ferrying",0.5,450,7.8916666666666666,10653.75,{"$f":"D59*C59/60*$C$48/$C$47","v":3551.25},{"$f":"G59/($C$48/$C$47)","v":3.75}]
[null,"Actual UAS Spraying Time",{"$f":"IF(G36=\"* Partial Load\",E27,Chemicals3!C36)","v":2.0000000000000004},450,31.566666666666674,42615.000000000007,14205.000000000002,15.000000000000002]
[null,"Time Spent Between Flights",0.5,450,7.8916666666666666,10653.75,3551.25,3.75]
[null,"Post-Processing",0,450,0,0,0,0]
[null,"Visual Observer",{"$f":"SUM(C58:C61)","v":3.1000000000000005},20,48.928333333333342,2935.7000000000007,978.56666666666695,1.0333333333333337]
[null,"Other",0,450,0,0,0,0]
[]
[null,"Personnel Total Cost",null,null,null,{"$f":"SUM(F58:F64)","v":68988.95},{"$f":"SUM(G58:G64)","v":22996.316666666666},{"$f":"SUM(H58:H64)","v":24.283333333333335}]
[]
[null,"Total Man Hours",null,null,{"$f":"SUM(E58:E64)","v":97.856666666666683}]
[null,"Pilot in Command (PIC) Hours",null,null,{"$f":"SUM(E58:E62,E64)","v":48.928333333333342}]
[null,"Pilot in Command (PIC) Weeks (40 hrs)",null,null,{"$f":"E69/40","v":1.2232083333333335}]
[null,"Acres/Hour PIC",null,null,{"$f":"C45/E69","v":51.095139149095608}]
[]
[null,"Economic Considerations"]
[]
[null,"Cost Per Flight"]
[null,"Total UAS Cost of Application Per Flight",{"$f":"('Total Costs'!E23)+H66","v":29.596346617719377},"/flight"]
[null,"Total Chemical Cost Per Flight",{"$f":"E22*E19","v":18.477817187500001},"/flight"]
[null,"Total Cost (UAS & Chemical) Per Flight",{"$f":"SUM(C76:C77)","v":48.074163805219378},"/flight"]
[]
[null,"Cost Per Acre"]
[null,"Total UAS Cost of Application Per Acre",{"$f":"IF($G$36=\"* Partial Load\",$C$76/$E$41,$C$76/$C$37)","v":33.632212065590188},"/acre"]
[null,"Total Chemical Cost Per Acre",{"$f":"E19*E18","v":20.997519531249996},"/acre"]
[null,"Total Cost (UAS & Chemical) Per Acre",{"$f":"SUM(C81:C82)","v":54.629731596840188},"/acre"]
[]
[]
[null,"$/bu for Crop",10,"/bu"]
[null,"Breakeven Increase in \nYield Bu/Acre Required",{"$f":"C83/C86","v":5.4629731596840188},"bu"]
[]
[null,{"$f":"IF('Total Costs'!D8='Total Costs'!G17,\"Pilot in Command (PIC) Cost\",\"Pilot in Command (PIC) Income\")","v":"Pilot in Command (PIC) Income"},{"$f":"SUM(G58:G62,G64)*C47","v":66053.25},null,{"$f":"IF(C5=\"Enabled\",F66,\"\")","v":""}]
[null,"Pilot in Command (PIC) ($/Flight)",{"$f":"C89/C48","v":23.25},"/flight"]
[]
[null,"Total Cost (UAS & Chemical) ",{"$f":"C83*C45","v":136574.32899210046}]
[]
[]
[null,"Desired Total UAS Cost of Application Per Acre",12,"/acre"]

{"sheet":"Chemicals4","index":11,"n_rows":95,"n_cols":10,"rows_kept":95,"cut":false,"hidden":false,"merged":[[2,1,2,5],[4,3,4,5],[5,2,5,5],[14,3,14,4],[16,2,16,3],[16,4,16,5],[42,1,42,5],[44,3,44,5],[45,3,45,5],[46,3,46,5],[47,3,47,5]]}
[]
[]
[null,"Sheet Description "]
[]
[null,"Sheet Status",{"$f":"Directory!E20","v":"Disabled"},{"$f":"IF(C3=\"Disabled\",\"**To Activate Go to Directory Tab**\",\"\")","v":""}]
[null,"Chemical 1 Name",{"$f":"Directory!B20","v":"Pesticide "}]
[]
[]
[null,"Chemical & Drone Information",null,null,null,null,null,"oz Chem. Per Acre",null,"oz"]
[null,null,null,null,null,null,null,"pt Chem. Per Acre",null,"pt"]
[null,"Chemical Information",null,null,null,null,null,"qt Chem. Per Acre ",null,"qt"]
[null,"Chemical Cost",489.98,"per",2.5,"gal",null,null,null,"gal"]
[null,"Chemical Cost per Gallon",{"$f":"C12/IF(F12=\"oz\",CONVERT(E12,\"oz\",\"gal\"),IF(F12=\"pt\",CONVERT(E12,\"us_pt\",\"gal\"),IF(F12=\"qt\",CONVERT(E12,\"qt\",\"gal\"),E12)))","v":195.99200000000002},"/gal"]
[null,"Carrier Cost per Gallon",7.0000000000000001E-3,"/gal"]
[null,"Chemical Application Rate",13.7,"oz Chem. Per Acre"]
[null,null,null,null,null,null,{"$f":"IF(D15=\"oz Chem. Per Acre\",CONVERT($C$15,\"oz\",\"gal\")*$C$13+$C$14*($C$18-CONVERT($C$15,\"oz\",\"gal\")),IF(D15=\"pt Chem. Per Acre\",CONVERT($C$15,\"us_pt\",\"gal\")*$C$13+$C$14*($C$18-CONVERT($C$15,\"us_pt\",\"gal\")),CONVERT($C$15,\"qt\",\"gal\")*$C$13+$C$14*($C$18-CONVERT($C$15,\"qt\",\"gal\"))))","v":20.997519531249999}]
[null,"Spray Volume = (Chemical + Carrier)","Imperial Units",null,"Metric \nUnits",null,{"$f":"IF(D15=\"oz Chem. Per Acre\",-CONVERT($C$15,\"oz\",\"gal\")+$C$18,IF(D15=\"pt Chem. Per Acre\",-CONVERT(C15,\"us_pt\",\"gal\")+C18,-CONVERT(C15,\"qt\",\"gal\")+C18))","v":2.8929687500000001}]
[null,"Spray Volume Per Acre",3,"gal/acre",{"$f":"CONVERT(C18,\"gal\",\"l\")","v":11.356235351999999},"L/acre",{"$f":"IF(G17>=0,\"\",\"CHECK UNITS\")","v":""}]
[null,"Cost Per Spray Volume",{"$f":"G16/C18","v":6.9991731770833328},"/gal",{"$f":"C19/CONVERT(1,\"gal\",\"l\")","v":1.8489859430002062},"/L"]
[]
[null,"Drone Sprayer Specifications"]
[null,"Spray Tank Volume",2.64,"gal",{"$f":"CONVERT(C22,\"gal\",\"l\")","v":9.9934871097600002},"L"]
[null,"Max. Operating Speed for Spraying  ",15.66,"mph",{"$f":"CONVERT(C23,\"mph\",\"m/sec\")","v":7.0006463999999999},"m/s"]
[null,"Effective Spray Width",16.399999999999999,"ft",{"$f":"CONVERT(C24,\"ft\",\"m\")","v":4.9987199999999996},"m"]
[null,"Max. Flow Rate",1.32,"gal/min",{"$f":"CONVERT(C25,\"gal\",\"l\")","v":4.9967435548800001},"L/min"]
[null,"Max. Flight Time",15,"min",{"$f":"C26","v":15},"min"]
[null,"Sprayer Application Time",13,"min",{"$f":"C27","v":13},"min"]
[]
[null,"Calculated Flow Rate Required at Max. Operating Speed",{"$f":"CONVERT(E29,\"l\",\"gal\")","v":1.5565077148874533},"gal/min",{"$f":"$E$18*E23*60*$E$24/4046.86","v":5.8920226458218776},"L/min",{"$f":"IF(E29>E25,\"Too High\",\"\")","v":"Too High"}]
[null,"Calculated Speed Required at Max. Operating Flow Rate",{"$f":"CONVERT(E30,\"m/sec\",\"mph\")","v":13.280499545416438},"mph",{"$f":"E25/E18*4046.86/E24/60","v":5.9369145167829647},"m/s"]
[]
[null,"SET Actual Operating Speed",{"$f":"CONVERT(E32,\"m/sec\",\"mph\")","v":13.280499545416438},"mph",{"$f":"IF(E30<E23,E30,E23)","v":5.9369145167829647},"m/s"]
[null,"Flow Rate at Actual Operating Speed",{"$f":"CONVERT(E33,\"l\",\"gal\")","v":1.3199999999999998},"gal/min",{"$f":"$E$18*E32*60*$E$24/4046.86","v":4.9967435548799992},"L/min"]
[]
[null,"Full Load"]
[null,"Operational Flight Time Required to Empty Tank Completely",{"$f":"E22/E33","v":2.0000000000000004},"min",{"$f":"C36","v":2.0000000000000004},"min",{"$f":"IF(C36>E27,\"* Partial Load\",IF(AND(C36<=E27,C36>=E27*0.8),\"*Watch Time\",\"* Good Time\"))","v":"* Good Time"}]
[null,"Acres Sprayed Per Flight",{"$f":"C36*E32*60*E24/4046.86","v":0.88000000000000034},"acre",{"$f":"C37","v":0.88000000000000034},"acre"]
[]
[null,"Partial Load "]
[null,"Application Amount",{"$f":"CONVERT(E40,\"l\",\"gal\")","v":17.16},"gal",{"$f":"E27*E33","v":64.957666213439992},"L"]
[null,"Acres Covered Per Flight",{"$f":"E41","v":5.7200000000000015},"acre",{"$f":"E27*E32*60*E24/4046.86","v":5.7200000000000015},"acre"]
[]
[null,"Flight Information"]
[]
[null,"Total Acres Sprayed",2500,"acres",null,null,{"$f":"IF(C5=\"Enabled\",C45,\"\")","v":""}]
[null,"Number of Drones Available",{"$f":"'Equipment Ownership'!C6","v":3},"drones"]
[null,"Number of Drones Used",3,"drones"]
[null,"Total Number of Flights",{"$f":"ROUNDUP(IF(G36=\"* Partial Load\",C45/E41,C45/(C37)),0)","v":2841},"flights",null,null,{"$f":"IF(C5=\"Enabled\",C48,\"\")","v":""}]
[]
[]
[null,"Personnel Information"]
[]
[null,"Overall Labor Cost",450,"/hour"]
[]
[null,null,null,null,{"$f":"IF(C47>1,\"Assumes Simulataneous UAS Spraying\",\"\")","v":"Assumes Simulataneous UAS Spraying"}]
[null,"Personnel Responsibilities","Time Allocated Per Flight (Minutes)","Labor Cost ($/hr)","Total Time (Hours)","Annual \nCost","Annual \nCost Per UAS","Cost Per \nFlight"]
[]
[null,"Flight Planning & Setup",0.1,{"$f":"$C$53","v":450},{"$f":"C58*$C$48/60/$C$47","v":1.5783333333333334},{"$f":"(D58*C58/60)*$C$48","v":2130.75},{"$f":"(D58*C58/60)*$C$48/$C$47","v":710.25},{"$f":"G58/($C$48/$C$47)","v":0.75}]
[null,"Ferrying",0.5,450,7.8916666666666666,10653.75,{"$f":"D59*C59/60*$C$48/$C$47","v":3551.25},{"$f":"G59/($C$48/$C$47)","v":3.75}]
[null,"Actual UAS Spraying Time",{"$f":"IF(G36=\"* Partial Load\",E27,Chemicals4!C36)","v":2.0000000000000004},450,31.566666666666674,42615.000000000007,14205.000000000002,15.000000000000002]
[null,"Time Spent Between Flights",0.5,450,7.8916666666666666,10653.75,3551.25,3.75]
[null,"Post-Processing",0,450,0,0,0,0]
[null,"Visual Observer",{"$f":"SUM(C58:C61)","v":3.1000000000000005},20,48.928333333333342,2935.7000000000007,978.56666666666695,1.0333333333333337]
[null,"Other",0,450,0,0,0,0]
[]
[null,"Personnel Total Cost",null,null,null,{"$f":"SUM(F58:F64)","v":68988.95},{"$f":"SUM(G58:G64)","v":22996.316666666666},{"$f":"SUM(H58:H64)","v":24.283333333333335}]
[]
[null,"Total Man Hours",null,null,{"$f":"SUM(E58:E64)","v":97.856666666666683}]
[null,"Pilot in Command (PIC) Hours",null,null,{"$f":"SUM(E58:E62,E64)","v":48.928333333333342}]
[null,"Pilot in Command (PIC) Weeks (40 hrs)",null,null,{"$f":"E69/40","v":1.2232083333333335}]
[null,"Acres/Hour PIC",null,null,{"$f":"C45/E69","v":51.095139149095608}]
[]
[null,"Economic Considerations"]
[]
[null,"Cost Per Flight"]
[null,"Total UAS Cost of Application Per Flight",{"$f":"('Total Costs'!E23)+H66","v":29.596346617719377},"/flight"]
[null,"Total Chemical Cost Per Flight",{"$f":"E22*E19","v":18.477817187500001},"/flight"]
[null,"Total Cost (UAS & Chemical) Per Flight",{"$f":"SUM(C76:C77)","v":48.074163805219378},"/flight"]
[]
[null,"Cost Per Acre"]
[null,"Total UAS Cost of Application Per Acre",{"$f":"IF($G$36=\"* Partial Load\",$C$76/$E$41,$C$76/$C$37)","v":33.632212065590188},"/acre"]
[null,"Total Chemical Cost Per Acre",{"$f":"E19*E18","v":20.997519531249996},"/acre"]
[null,"Total Cost (UAS & Chemical) Per Acre",{"$f":"SUM(C81:C82)","v":54.629731596840188},"/acre"]
[]
[]
[null,"$/bu for Crop",10,"/bu"]
[null,"Breakeven Increase in \nYield Bu/Acre Required",{"$f":"C83/C86","v":5.4629731596840188},"bu"]
[]
[null,{"$f":"IF('Total Costs'!D8='Total Costs'!G17,\"Pilot in Command (PIC) Cost\",\"Pilot in Command (PIC) Income\")","v":"Pilot in Command (PIC) Income"},{"$f":"SUM(G58:G62,G64)*C47","v":66053.25},null,{"$f":"IF(C5=\"Enabled\",F66,\"\")","v":""}]
[null,"Pilot in Command (PIC) ($/Flight)",{"$f":"C89/C48","v":23.25},"/flight"]
[]
[null,"Total Cost (UAS & Chemical) ",{"$f":"C83*C45","v":136574.32899210046}]
[]
[]
[null,"Desired Total UAS Cost of Application Per Acre",12,"/acre"]

{"sheet":"Chemicals5","index":12,"n_rows":95,"n_cols":10,"rows_kept":95,"cut":false,"hidden":false,"merged":[[2,1,2,5],[4,3,4,5],[5,2,5,5],[14,3,14,4],[16,2,16,3],[16,4,16,5],[42,1,42,5],[44,3,44,5],[45,3,45,5],[46,3,46,5],[47,3,47,5]]}
[]
[]
[null,"Sheet Description "]
[]
[null,"Sheet Status",{"$f":"Directory!E21","v":"Disabled"},{"$f":"IF(C3=\"Disabled\",\"**To Activate Go to Directory Tab**\",\"\")","v":""}]
[null,"Chemical 1 Name",{"$f":"Directory!B21","v":"Herbicide"}]
[]
[]
[null,"Chemical & Drone Information",null,null,null,null,null,"oz Chem. Per Acre",null,"oz"]
[null,null,null,null,null,null,null,"pt Chem. Per Acre",null,"pt"]
[null,"Chemical Information",null,null,null,null,null,"qt Chem. Per Acre ",null,"qt"]
[null,"Chemical Cost",489.98,"per",2.5,"gal",null,null,null,"gal"]
[null,"Chemical Cost per Gallon",{"$f":"C12/IF(F12=\"oz\",CONVERT(E12,\"oz\",\"gal\"),IF(F12=\"pt\",CONVERT(E12,\"us_pt\",\"gal\"),IF(F12=\"qt\",CONVERT(E12,\"qt\",\"gal\"),E12)))","v":195.99200000000002},"/gal"]
[null,"Carrier Cost per Gallon",7.0000000000000001E-3,"/gal"]
[null,"Chemical Application Rate",13.7,"oz Chem. Per Acre"]
[null,null,null,null,null,null,{"$f":"IF(D15=\"oz Chem. Per Acre\",CONVERT($C$15,\"oz\",\"gal\")*$C$13+$C$14*($C$18-CONVERT($C$15,\"oz\",\"gal\")),IF(D15=\"pt Chem. Per Acre\",CONVERT($C$15,\"us_pt\",\"gal\")*$C$13+$C$14*($C$18-CONVERT($C$15,\"us_pt\",\"gal\")),CONVERT($C$15,\"qt\",\"gal\")*$C$13+$C$14*($C$18-CONVERT($C$15,\"qt\",\"gal\"))))","v":20.997519531249999}]
[null,"Spray Volume = (Chemical + Carrier)","Imperial Units",null,"Metric \nUnits",null,{"$f":"IF(D15=\"oz Chem. Per Acre\",-CONVERT($C$15,\"oz\",\"gal\")+$C$18,IF(D15=\"pt Chem. Per Acre\",-CONVERT(C15,\"us_pt\",\"gal\")+C18,-CONVERT(C15,\"qt\",\"gal\")+C18))","v":2.8929687500000001}]
[null,"Spray Volume Per Acre",3,"gal/acre",{"$f":"CONVERT(C18,\"gal\",\"l\")","v":11.356235351999999},"L/acre",{"$f":"IF(G17>=0,\"\",\"CHECK UNITS\")","v":""}]
[null,"Cost Per Spray Volume",{"$f":"G16/C18","v":6.9991731770833328},"/gal",{"$f":"C19/CONVERT(1,\"gal\",\"l\")","v":1.8489859430002062},"/L"]
[]
[null,"Drone Sprayer Specifications"]
[null,"Spray Tank Volume",2.64,"gal",{"$f":"CONVERT(C22,\"gal\",\"l\")","v":9.9934871097600002},"L"]
[null,"Max. Operating Speed for Spraying  ",15.66,"mph",{"$f":"CONVERT(C23,\"mph\",\"m/sec\")","v":7.0006463999999999},"m/s"]
[null,"Effective Spray Width",16.399999999999999,"ft",{"$f":"CONVERT(C24,\"ft\",\"m\")","v":4.9987199999999996},"m"]
[null,"Max. Flow Rate",1.32,"gal/min",{"$f":"CONVERT(C25,\"gal\",\"l\")","v":4.9967435548800001},"L/min"]
[null,"Max. Flight Time",15,"min",{"$f":"C26","v":15},"min"]
[null,"Sprayer Application Time",13,"min",{"$f":"C27","v":13},"min"]
[]
[null,"Calculated Flow Rate Required at Max. Operating Speed",{"$f":"CONVERT(E29,\"l\",\"gal\")","v":1.5565077148874533},"gal/min",{"$f":"$E$18*E23*60*$E$24/4046.86","v":5.8920226458218776},"L/min",{"$f":"IF(E29>E25,\"Too High\",\"\")","v":"Too High"}]
[null,"Calculated Speed Required at Max. Operating Flow Rate",{"$f":"CONVERT(E30,\"m/sec\",\"mph\")","v":13.280499545416438},"mph",{"$f":"E25/E18*4046.86/E24/60","v":5.9369145167829647},"m/s"]
[]
[null,"SET Actual Operating Speed",{"$f":"CONVERT(E32,\"m/sec\",\"mph\")","v":13.280499545416438},"mph",{"$f":"IF(E30<E23,E30,E23)","v":5.9369145167829647},"m/s"]
[null,"Flow Rate at Actual Operating Speed",{"$f":"CONVERT(E33,\"l\",\"gal\")","v":1.3199999999999998},"gal/min",{"$f":"$E$18*E32*60*$E$24/4046.86","v":4.9967435548799992},"L/min"]
[]
[null,"Full Load"]
[null,"Operational Flight Time Required to Empty Tank Completely",{"$f":"E22/E33","v":2.0000000000000004},"min",{"$f":"C36","v":2.0000000000000004},"min",{"$f":"IF(C36>E27,\"* Partial Load\",IF(AND(C36<=E27,C36>=E27*0.8),\"*Watch Time\",\"* Good Time\"))","v":"* Good Time"}]
[null,"Acres Sprayed Per Flight",{"$f":"C36*E32*60*E24/4046.86","v":0.88000000000000034},"acre",{"$f":"C37","v":0.88000000000000034},"acre"]
[]
[null,"Partial Load "]
[null,"Application Amount",{"$f":"CONVERT(E40,\"l\",\"gal\")","v":17.16},"gal",{"$f":"E27*E33","v":64.957666213439992},"L"]
[null,"Acres Covered Per Flight",{"$f":"E41","v":5.7200000000000015},"acre",{"$f":"E27*E32*60*E24/4046.86","v":5.7200000000000015},"acre"]
[]
[null,"Flight Information"]
[]
[null,"Total Acres Sprayed",2500,"acres",null,null,{"$f":"IF(C5=\"Enabled\",C45,\"\")","v":""}]
[null,"Number of Drones Available",{"$f":"'Equipment Ownership'!C6","v":3},"drones"]
[null,"Number of Drones Used",3,"drones"]
[null,"Total Number of Flights",{"$f":"ROUNDUP(IF(G36=\"* Partial Load\",C45/E41,C45/(C37)),0)","v":2841},"flights",null,null,{"$f":"IF(C5=\"Enabled\",C48,\"\")","v":""}]
[]
[]
[null,"Personnel Information"]
[]
[null,"Overall Labor Cost",450,"/hour"]
[]
[null,null,null,null,{"$f":"IF(C47>1,\"Assumes Simulataneous UAS Spraying\",\"\")","v":"Assumes Simulataneous UAS Spraying"}]
[null,"Personnel Responsibilities","Time Allocated Per Flight (Minutes)","Labor Cost ($/hr)","Total Time (Hours)","Annual \nCost","Annual \nCost Per UAS","Cost Per \nFlight"]
[]
[null,"Flight Planning & Setup",0.1,{"$f":"$C$53","v":450},{"$f":"C58*$C$48/60/$C$47","v":1.5783333333333334},{"$f":"(D58*C58/60)*$C$48","v":2130.75},{"$f":"(D58*C58/60)*$C$48/$C$47","v":710.25},{"$f":"G58/($C$48/$C$47)","v":0.75}]
[null,"Ferrying",0.5,450,7.8916666666666666,10653.75,{"$f":"D59*C59/60*$C$48/$C$47","v":3551.25},{"$f":"G59/($C$48/$C$47)","v":3.75}]
[null,"Actual UAS Spraying Time",{"$f":"IF(G36=\"* Partial Load\",E27,Chemicals5!C36)","v":2.0000000000000004},450,31.566666666666674,42615.000000000007,14205.000000000002,15.000000000000002]
[null,"Time Spent Between Flights",0.5,450,7.8916666666666666,10653.75,3551.25,3.75]
[null,"Post-Processing",0,450,0,0,0,0]
[null,"Visual Observer",{"$f":"SUM(C58:C61)","v":3.1000000000000005},20,48.928333333333342,2935.7000000000007,978.56666666666695,1.0333333333333337]
[null,"Other",0,450,0,0,0,0]
[]
[null,"Personnel Total Cost",null,null,null,{"$f":"SUM(F58:F64)","v":68988.95},{"$f":"SUM(G58:G64)","v":22996.316666666666},{"$f":"SUM(H58:H64)","v":24.283333333333335}]
[]
[null,"Total Man Hours",null,null,{"$f":"SUM(E58:E64)","v":97.856666666666683}]
[null,"Pilot in Command (PIC) Hours",null,null,{"$f":"SUM(E58:E62,E64)","v":48.928333333333342}]
[null,"Pilot in Command (PIC) Weeks (40 hrs)",null,null,{"$f":"E69/40","v":1.2232083333333335}]
[null,"Acres/Hour PIC",null,null,{"$f":"C45/E69","v":51.095139149095608}]
[]
[null,"Economic Considerations"]
[]
[null,"Cost Per Flight"]
[null,"Total UAS Cost of Application Per Flight",{"$f":"('Total Costs'!E23)+H66","v":29.596346617719377},"/flight"]
[null,"Total Chemical Cost Per Flight",{"$f":"E22*E19","v":18.477817187500001},"/flight"]
[null,"Total Cost (UAS & Chemical) Per Flight",{"$f":"SUM(C76:C77)","v":48.074163805219378},"/flight"]
[]
[null,"Cost Per Acre"]
[null,"Total UAS Cost of Application Per Acre",{"$f":"IF($G$36=\"* Partial Load\",$C$76/$E$41,$C$76/$C$37)","v":33.632212065590188},"/acre"]
[null,"Total Chemical Cost Per Acre",{"$f":"E19*E18","v":20.997519531249996},"/acre"]
[null,"Total Cost (UAS & Chemical) Per Acre",{"$f":"SUM(C81:C82)","v":54.629731596840188},"/acre"]
[]
[]
[null,"$/bu for Crop",10,"/bu"]
[null,"Breakeven Increase in \nYield Bu/Acre Required",{"$f":"C83/C86","v":5.4629731596840188},"bu"]
[]
[null,{"$f":"IF('Total Costs'!D8='Total Costs'!G17,\"Pilot in Command (PIC) Cost\",\"Pilot in Command (PIC) Income\")","v":"Pilot in Command (PIC) Income"},{"$f":"SUM(G58:G62,G64)*C47","v":66053.25},null,{"$f":"IF(C5=\"Enabled\",F66,\"\")","v":""}]
[null,"Pilot in Command (PIC) ($/Flight)",{"$f":"C89/C48","v":23.25},"/flight"]
[]
[null,"Total Cost (UAS & Chemical) ",{"$f":"C83*C45","v":136574.32899210046}]
[]
[]
[null,"Desired Total UAS Cost of Application Per Acre",12,"/acre"]

{"sheet":"Chemicals6","index":13,"n_rows":95,"n_cols":10,"rows_kept":95,"cut":false,"hidden":false,"merged":[[2,1,2,5],[4,3,4,5],[5,2,5,5],[14,3,14,4],[16,2,16,3],[16,4,16,5],[42,1,42,5],[44,3,44,5],[45,3,45,5],[46,3,46,5],[47,3,47,5]]}
[]
[]
[null,"Sheet Description "]
[]
[null,"Sheet Status",{"$f":"Directory!E22","v":"Disabled"},{"$f":"IF(C3=\"Disabled\",\"**To Activate Go to Directory Tab**\",\"\")","v":""}]
[null,"Chemical 1 Name",{"$f":"Directory!B22","v":"Fungicide"}]
[]
[]
[null,"Chemical & Drone Information",null,null,null,null,null,"oz Chem. Per Acre",null,"oz"]
[null,null,null,null,null,null,null,"pt Chem. Per Acre",null,"pt"]
[null,"Chemical Information",null,null,null,null,null,"qt Chem. Per Acre ",null,"qt"]
[null,"Chemical Cost",489.98,"per",2.5,"gal",null,null,null,"gal"]
[null,"Chemical Cost per Gallon",{"$f":"C12/IF(F12=\"oz\",CONVERT(E12,\"oz\",\"gal\"),IF(F12=\"pt\",CONVERT(E12,\"us_pt\",\"gal\"),IF(F12=\"qt\",CONVERT(E12,\"qt\",\"gal\"),E12)))","v":195.99200000000002},"/gal"]
[null,"Carrier Cost per Gallon",7.0000000000000001E-3,"/gal"]
[null,"Chemical Application Rate",13.7,"oz Chem. Per Acre"]
[null,null,null,null,null,null,{"$f":"IF(D15=\"oz Chem. Per Acre\",CONVERT($C$15,\"oz\",\"gal\")*$C$13+$C$14*($C$18-CONVERT($C$15,\"oz\",\"gal\")),IF(D15=\"pt Chem. Per Acre\",CONVERT($C$15,\"us_pt\",\"gal\")*$C$13+$C$14*($C$18-CONVERT($C$15,\"us_pt\",\"gal\")),CONVERT($C$15,\"qt\",\"gal\")*$C$13+$C$14*($C$18-CONVERT($C$15,\"qt\",\"gal\"))))","v":20.997519531249999}]
[null,"Spray Volume = (Chemical + Carrier)","Imperial Units",null,"Metric \nUnits",null,{"$f":"IF(D15=\"oz Chem. Per Acre\",-CONVERT($C$15,\"oz\",\"gal\")+$C$18,IF(D15=\"pt Chem. Per Acre\",-CONVERT(C15,\"us_pt\",\"gal\")+C18,-CONVERT(C15,\"qt\",\"gal\")+C18))","v":2.8929687500000001}]
[null,"Spray Volume Per Acre",3,"gal/acre",{"$f":"CONVERT(C18,\"gal\",\"l\")","v":11.356235351999999},"L/acre",{"$f":"IF(G17>=0,\"\",\"CHECK UNITS\")","v":""}]
[null,"Cost Per Spray Volume",{"$f":"G16/C18","v":6.9991731770833328},"/gal",{"$f":"C19/CONVERT(1,\"gal\",\"l\")","v":1.8489859430002062},"/L"]
[]
[null,"Drone Sprayer Specifications"]
[null,"Spray Tank Volume",2.64,"gal",{"$f":"CONVERT(C22,\"gal\",\"l\")","v":9.9934871097600002},"L"]
[null,"Max. Operating Speed for Spraying  ",15.66,"mph",{"$f":"CONVERT(C23,\"mph\",\"m/sec\")","v":7.0006463999999999},"m/s"]
[null,"Effective Spray Width",16.399999999999999,"ft",{"$f":"CONVERT(C24,\"ft\",\"m\")","v":4.9987199999999996},"m"]
[null,"Max. Flow Rate",1.32,"gal/min",{"$f":"CONVERT(C25,\"gal\",\"l\")","v":4.9967435548800001},"L/min"]
[null,"Max. Flight Time",15,"min",{"$f":"C26","v":15},"min"]
[null,"Sprayer Application Time",13,"min",{"$f":"C27","v":13},"min"]
[]
[null,"Calculated Flow Rate Required at Max. Operating Speed",{"$f":"CONVERT(E29,\"l\",\"gal\")","v":1.5565077148874533},"gal/min",{"$f":"$E$18*E23*60*$E$24/4046.86","v":5.8920226458218776},"L/min",{"$f":"IF(E29>E25,\"Too High\",\"\")","v":"Too High"}]
[null,"Calculated Speed Required at Max. Operating Flow Rate",{"$f":"CONVERT(E30,\"m/sec\",\"mph\")","v":13.280499545416438},"mph",{"$f":"E25/E18*4046.86/E24/60","v":5.9369145167829647},"m/s"]
[]
[null,"SET Actual Operating Speed",{"$f":"CONVERT(E32,\"m/sec\",\"mph\")","v":13.280499545416438},"mph",{"$f":"IF(E30<E23,E30,E23)","v":5.9369145167829647},"m/s"]
[null,"Flow Rate at Actual Operating Speed",{"$f":"CONVERT(E33,\"l\",\"gal\")","v":1.3199999999999998},"gal/min",{"$f":"$E$18*E32*60*$E$24/4046.86","v":4.9967435548799992},"L/min"]
[]
[null,"Full Load"]
[null,"Operational Flight Time Required to Empty Tank Completely",{"$f":"E22/E33","v":2.0000000000000004},"min",{"$f":"C36","v":2.0000000000000004},"min",{"$f":"IF(C36>E27,\"* Partial Load\",IF(AND(C36<=E27,C36>=E27*0.8),\"*Watch Time\",\"* Good Time\"))","v":"* Good Time"}]
[null,"Acres Sprayed Per Flight",{"$f":"C36*E32*60*E24/4046.86","v":0.88000000000000034},"acre",{"$f":"C37","v":0.88000000000000034},"acre"]
[]
[null,"Partial Load "]
[null,"Application Amount",{"$f":"CONVERT(E40,\"l\",\"gal\")","v":17.16},"gal",{"$f":"E27*E33","v":64.957666213439992},"L"]
[null,"Acres Covered Per Flight",{"$f":"E41","v":5.7200000000000015},"acre",{"$f":"E27*E32*60*E24/4046.86","v":5.7200000000000015},"acre"]
[]
[null,"Flight Information"]
[]
[null,"Total Acres Sprayed",2500,"acres",null,null,{"$f":"IF(C5=\"Enabled\",C45,\"\")","v":""}]
[null,"Number of Drones Available",{"$f":"'Equipment Ownership'!C6","v":3},"drones"]
[null,"Number of Drones Used",3,"drones"]
[null,"Total Number of Flights",{"$f":"ROUNDUP(IF(G36=\"* Partial Load\",C45/E41,C45/(C37)),0)","v":2841},"flights",null,null,{"$f":"IF(C5=\"Enabled\",C48,\"\")","v":""}]
[]
[]
[null,"Personnel Information"]
[]
[null,"Overall Labor Cost",450,"/hour"]
[]
[null,null,null,null,{"$f":"IF(C47>1,\"Assumes Simulataneous UAS Spraying\",\"\")","v":"Assumes Simulataneous UAS Spraying"}]
[null,"Personnel Responsibilities","Time Allocated Per Flight (Minutes)","Labor Cost ($/hr)","Total Time (Hours)","Annual \nCost","Annual \nCost Per UAS","Cost Per \nFlight"]
[]
[null,"Flight Planning & Setup",0.1,{"$f":"$C$53","v":450},{"$f":"C58*$C$48/60/$C$47","v":1.5783333333333334},{"$f":"(D58*C58/60)*$C$48","v":2130.75},{"$f":"(D58*C58/60)*$C$48/$C$47","v":710.25},{"$f":"G58/($C$48/$C$47)","v":0.75}]
[null,"Ferrying",0.5,450,7.8916666666666666,10653.75,{"$f":"D59*C59/60*$C$48/$C$47","v":3551.25},{"$f":"G59/($C$48/$C$47)","v":3.75}]
[null,"Actual UAS Spraying Time",{"$f":"IF(G36=\"* Partial Load\",E27,Chemicals6!C36)","v":2.0000000000000004},450,31.566666666666674,42615.000000000007,14205.000000000002,15.000000000000002]
[null,"Time Spent Between Flights",0.5,450,7.8916666666666666,10653.75,3551.25,3.75]
[null,"Post-Processing",0,450,0,0,0,0]
[null,"Visual Observer",{"$f":"SUM(C58:C61)","v":3.1000000000000005},20,48.928333333333342,2935.7000000000007,978.56666666666695,1.0333333333333337]
[null,"Other",0,450,0,0,0,0]
[]
[null,"Personnel Total Cost",null,null,null,{"$f":"SUM(F58:F64)","v":68988.95},{"$f":"SUM(G58:G64)","v":22996.316666666666},{"$f":"SUM(H58:H64)","v":24.283333333333335}]
[]
[null,"Total Man Hours",null,null,{"$f":"SUM(E58:E64)","v":97.856666666666683}]
[null,"Pilot in Command (PIC) Hours",null,null,{"$f":"SUM(E58:E62,E64)","v":48.928333333333342}]
[null,"Pilot in Command (PIC) Weeks (40 hrs)",null,null,{"$f":"E69/40","v":1.2232083333333335}]
[null,"Acres/Hour PIC",null,null,{"$f":"C45/E69","v":51.095139149095608}]
[]
[null,"Economic Considerations"]
[]
[null,"Cost Per Flight"]
[null,"Total UAS Cost of Application Per Flight",{"$f":"('Total Costs'!E23)+H66","v":29.596346617719377},"/flight"]
[null,"Total Chemical Cost Per Flight",{"$f":"E22*E19","v":18.477817187500001},"/flight"]
[null,"Total Cost (UAS & Chemical) Per Flight",{"$f":"SUM(C76:C77)","v":48.074163805219378},"/flight"]
[]
[null,"Cost Per Acre"]
[null,"Total UAS Cost of Application Per Acre",{"$f":"IF($G$36=\"* Partial Load\",$C$76/$E$41,$C$76/$C$37)","v":33.632212065590188},"/acre"]
[null,"Total Chemical Cost Per Acre",{"$f":"E19*E18","v":20.997519531249996},"/acre"]
[null,"Total Cost (UAS & Chemical) Per Acre",{"$f":"SUM(C81:C82)","v":54.629731596840188},"/acre"]
[]
[]
[null,"$/bu for Crop",10,"/bu"]
[null,"Breakeven Increase in \nYield Bu/Acre Required",{"$f":"C83/C86","v":5.4629731596840188},"bu"]
[]
[null,{"$f":"IF('Total Costs'!D8='Total Costs'!G17,\"Pilot in Command (PIC) Cost\",\"Pilot in Command (PIC) Income\")","v":"Pilot in Command (PIC) Income"},{"$f":"SUM(G58:G62,G64)*C47","v":66053.25},null,{"$f":"IF(C5=\"Enabled\",F66,\"\")","v":""}]
[null,"Pilot in Command (PIC) ($/Flight)",{"$f":"C89/C48","v":23.25},"/flight"]
[]
[null,"Total Cost (UAS & Chemical) ",{"$f":"C83*C45","v":136574.32899210046}]
[]
[]
[null,"Desired Total UAS Cost of Application Per Acre",12,"/acre"]

{"sheet":"Chemicals7","index":14,"n_rows":95,"n_cols":10,"rows_kept":95,"cut":false,"hidden":false,"merged":[[2,1,2,5],[4,3,4,5],[5,2,5,5],[14,3,14,4],[16,2,16,3],[16,4,16,5],[42,1,42,5],[44,3,44,5],[45,3,45,5],[46,3,46,5],[47,3,47,5]]}
[]
[]
[null,"Sheet Description "]
[]
[null,"Sheet Status",{"$f":"Directory!E23","v":"Disabled"},{"$f":"IF(C3=\"Disabled\",\"**To Activate Go to Directory Tab**\",\"\")","v":""}]
[null,"Chemical 1 Name",{"$f":"Directory!B23","v":"Pesticide "}]
[]
[]
[null,"Chemical & Drone Information",null,null,null,null,null,"oz Chem. Per Acre",null,"oz"]
[null,null,null,null,null,null,null,"pt Chem. Per Acre",null,"pt"]
[null,"Chemical Information",null,null,null,null,null,"qt Chem. Per Acre ",null,"qt"]
[null,"Chemical Cost",489.98,"per",2.5,"gal",null,null,null,"gal"]
[null,"Chemical Cost per Gallon",{"$f":"C12/IF(F12=\"oz\",CONVERT(E12,\"oz\",\"gal\"),IF(F12=\"pt\",CONVERT(E12,\"us_pt\",\"gal\"),IF(F12=\"qt\",CONVERT(E12,\"qt\",\"gal\"),E12)))","v":195.99200000000002},"/gal"]
[null,"Carrier Cost per Gallon",7.0000000000000001E-3,"/gal"]
[null,"Chemical Application Rate",13.7,"oz Chem. Per Acre"]
[null,null,null,null,null,null,{"$f":"IF(D15=\"oz Chem. Per Acre\",CONVERT($C$15,\"oz\",\"gal\")*$C$13+$C$14*($C$18-CONVERT($C$15,\"oz\",\"gal\")),IF(D15=\"pt Chem. Per Acre\",CONVERT($C$15,\"us_pt\",\"gal\")*$C$13+$C$14*($C$18-CONVERT($C$15,\"us_pt\",\"gal\")),CONVERT($C$15,\"qt\",\"gal\")*$C$13+$C$14*($C$18-CONVERT($C$15,\"qt\",\"gal\"))))","v":20.997519531249999}]
[null,"Spray Volume = (Chemical + Carrier)","Imperial Units",null,"Metric \nUnits",null,{"$f":"IF(D15=\"oz Chem. Per Acre\",-CONVERT($C$15,\"oz\",\"gal\")+$C$18,IF(D15=\"pt Chem. Per Acre\",-CONVERT(C15,\"us_pt\",\"gal\")+C18,-CONVERT(C15,\"qt\",\"gal\")+C18))","v":2.8929687500000001}]
[null,"Spray Volume Per Acre",3,"gal/acre",{"$f":"CONVERT(C18,\"gal\",\"l\")","v":11.356235351999999},"L/acre",{"$f":"IF(G17>=0,\"\",\"CHECK UNITS\")","v":""}]
[null,"Cost Per Spray Volume",{"$f":"G16/C18","v":6.9991731770833328},"/gal",{"$f":"C19/CONVERT(1,\"gal\",\"l\")","v":1.8489859430002062},"/L"]
[]
[null,"Drone Sprayer Specifications"]
[null,"Spray Tank Volume",2.64,"gal",{"$f":"CONVERT(C22,\"gal\",\"l\")","v":9.9934871097600002},"L"]
[null,"Max. Operating Speed for Spraying  ",15.66,"mph",{"$f":"CONVERT(C23,\"mph\",\"m/sec\")","v":7.0006463999999999},"m/s"]
[null,"Effective Spray Width",16.399999999999999,"ft",{"$f":"CONVERT(C24,\"ft\",\"m\")","v":4.9987199999999996},"m"]
[null,"Max. Flow Rate",1.32,"gal/min",{"$f":"CONVERT(C25,\"gal\",\"l\")","v":4.9967435548800001},"L/min"]
[null,"Max. Flight Time",15,"min",{"$f":"C26","v":15},"min"]
[null,"Sprayer Application Time",13,"min",{"$f":"C27","v":13},"min"]
[]
[null,"Calculated Flow Rate Required at Max. Operating Speed",{"$f":"CONVERT(E29,\"l\",\"gal\")","v":1.5565077148874533},"gal/min",{"$f":"$E$18*E23*60*$E$24/4046.86","v":5.8920226458218776},"L/min",{"$f":"IF(E29>E25,\"Too High\",\"\")","v":"Too High"}]
[null,"Calculated Speed Required at Max. Operating Flow Rate",{"$f":"CONVERT(E30,\"m/sec\",\"mph\")","v":13.280499545416438},"mph",{"$f":"E25/E18*4046.86/E24/60","v":5.9369145167829647},"m/s"]
[]
[null,"SET Actual Operating Speed",{"$f":"CONVERT(E32,\"m/sec\",\"mph\")","v":13.280499545416438},"mph",{"$f":"IF(E30<E23,E30,E23)","v":5.9369145167829647},"m/s"]
[null,"Flow Rate at Actual Operating Speed",{"$f":"CONVERT(E33,\"l\",\"gal\")","v":1.3199999999999998},"gal/min",{"$f":"$E$18*E32*60*$E$24/4046.86","v":4.9967435548799992},"L/min"]
[]
[null,"Full Load"]
[null,"Operational Flight Time Required to Empty Tank Completely",{"$f":"E22/E33","v":2.0000000000000004},"min",{"$f":"C36","v":2.0000000000000004},"min",{"$f":"IF(C36>E27,\"* Partial Load\",IF(AND(C36<=E27,C36>=E27*0.8),\"*Watch Time\",\"* Good Time\"))","v":"* Good Time"}]
[null,"Acres Sprayed Per Flight",{"$f":"C36*E32*60*E24/4046.86","v":0.88000000000000034},"acre",{"$f":"C37","v":0.88000000000000034},"acre"]
[]
[null,"Partial Load "]
[null,"Application Amount",{"$f":"CONVERT(E40,\"l\",\"gal\")","v":17.16},"gal",{"$f":"E27*E33","v":64.957666213439992},"L"]
[null,"Acres Covered Per Flight",{"$f":"E41","v":5.7200000000000015},"acre",{"$f":"E27*E32*60*E24/4046.86","v":5.7200000000000015},"acre"]
[]
[null,"Flight Information"]
[]
[null,"Total Acres Sprayed",2500,"acres",null,null,{"$f":"IF(C5=\"Enabled\",C45,\"\")","v":""}]
[null,"Number of Drones Available",{"$f":"'Equipment Ownership'!C6","v":3},"drones"]
[null,"Number of Drones Used",3,"drones"]
[null,"Total Number of Flights",{"$f":"ROUNDUP(IF(G36=\"* Partial Load\",C45/E41,C45/(C37)),0)","v":2841},"flights",null,null,{"$f":"IF(C5=\"Enabled\",C48,\"\")","v":""}]
[]
[]
[null,"Personnel Information"]
[]
[null,"Overall Labor Cost",450,"/hour"]
[]
[null,null,null,null,{"$f":"IF(C47>1,\"Assumes Simulataneous UAS Spraying\",\"\")","v":"Assumes Simulataneous UAS Spraying"}]
[null,"Personnel Responsibilities","Time Allocated Per Flight (Minutes)","Labor Cost ($/hr)","Total Time (Hours)","Annual \nCost","Annual \nCost Per UAS","Cost Per \nFlight"]
[]
[null,"Flight Planning & Setup",0.1,{"$f":"$C$53","v":450},{"$f":"C58*$C$48/60/$C$47","v":1.5783333333333334},{"$f":"(D58*C58/60)*$C$48","v":2130.75},{"$f":"(D58*C58/60)*$C$48/$C$47","v":710.25},{"$f":"G58/($C$48/$C$47)","v":0.75}]
[null,"Ferrying",0.5,450,7.8916666666666666,10653.75,{"$f":"D59*C59/60*$C$48/$C$47","v":3551.25},{"$f":"G59/($C$48/$C$47)","v":3.75}]
[null,"Actual UAS Spraying Time",{"$f":"IF(G36=\"* Partial Load\",E27,Chemicals7!C36)","v":2.0000000000000004},450,31.566666666666674,42615.000000000007,14205.000000000002,15.000000000000002]
[null,"Time Spent Between Flights",0.5,450,7.8916666666666666,10653.75,3551.25,3.75]
[null,"Post-Processing",0,450,0,0,0,0]
[null,"Visual Observer",{"$f":"SUM(C58:C61)","v":3.1000000000000005},20,48.928333333333342,2935.7000000000007,978.56666666666695,1.0333333333333337]
[null,"Other",0,450,0,0,0,0]
[]
[null,"Personnel Total Cost",null,null,null,{"$f":"SUM(F58:F64)","v":68988.95},{"$f":"SUM(G58:G64)","v":22996.316666666666},{"$f":"SUM(H58:H64)","v":24.283333333333335}]
[]
[null,"Total Man Hours",null,null,{"$f":"SUM(E58:E64)","v":97.856666666666683}]
[null,"Pilot in Command (PIC) Hours",null,null,{"$f":"SUM(E58:E62,E64)","v":48.928333333333342}]
[null,"Pilot in Command (PIC) Weeks (40 hrs)",null,null,{"$f":"E69/40","v":1.2232083333333335}]
[null,"Acres/Hour PIC",null,null,{"$f":"C45/E69","v":51.095139149095608}]
[]
[null,"Economic Considerations"]
[]
[null,"Cost Per Flight"]
[null,"Total UAS Cost of Application Per Flight",{"$f":"('Total Costs'!E23)+H66","v":29.596346617719377},"/flight"]
[null,"Total Chemical Cost Per Flight",{"$f":"E22*E19","v":18.477817187500001},"/flight"]
[null,"Total Cost (UAS & Chemical) Per Flight",{"$f":"SUM(C76:C77)","v":48.074163805219378},"/flight"]
[]
[null,"Cost Per Acre"]
[null,"Total UAS Cost of Application Per Acre",{"$f":"IF($G$36=\"* Partial Load\",$C$76/$E$41,$C$76/$C$37)","v":33.632212065590188},"/acre"]
[null,"Total Chemical Cost Per Acre",{"$f":"E19*E18","v":20.997519531249996},"/acre"]
[null,"Total Cost (UAS & Chemical) Per Acre",{"$f":"SUM(C81:C82)","v":54.629731596840188},"/acre"]
[]
[]
[null,"$/bu for Crop",10,"/bu"]
[null,"Breakeven Increase in \nYield Bu/Acre Required",{"$f":"C83/C86","v":5.4629731596840188},"bu"]
[]
[null,{"$f":"IF('Total Costs'!D8='Total Costs'!G17,\"Pilot in Command (PIC) Cost\",\"Pilot in Command (PIC) Income\")","v":"Pilot in Command (PIC) Income"},{"$f":"SUM(G58:G62,G64)*C47","v":66053.25},null,{"$f":"IF(C5=\"Enabled\",F66,\"\")","v":""}]
[null,"Pilot in Command (PIC) ($/Flight)",{"$f":"C89/C48","v":23.25},"/flight"]
[]
[null,"Total Cost (UAS & Chemical) ",{"$f":"C83*C45","v":136574.32899210046}]
[]
[]
[null,"Desired Total UAS Cost of Application Per Acre",12,"/acre"]

{"sheet":"Chemicals8","index":15,"n_rows":95,"n_cols":10,"rows_kept":95,"cut":false,"hidden":false,"merged":[[2,1,2,5],[4,3,4,5],[5,2,5,5],[14,3,14,4],[16,2,16,3],[16,4,16,5],[42,1,42,5],[44,3,44,5],[45,3,45,5],[46,3,46,5],[47,3,47,5]]}
[]
[]
[null,"Sheet Description "]
[]
[null,"Sheet Status",{"$f":"Directory!E24","v":"Disabled"},{"$f":"IF(C3=\"Disabled\",\"**To Activate Go to Directory Tab**\",\"\")","v":""}]
[null,"Chemical 1 Name",{"$f":"Directory!B24","v":"Herbicide"}]
[]
[]
[null,"Chemical & Drone Information",null,null,null,null,null,"oz Chem. Per Acre",null,"oz"]
[null,null,null,null,null,null,null,"pt Chem. Per Acre",null,"pt"]
[null,"Chemical Information",null,null,null,null,null,"qt Chem. Per Acre ",null,"qt"]
[null,"Chemical Cost",489.98,"per",2.5,"gal",null,null,null,"gal"]
[null,"Chemical Cost per Gallon",{"$f":"C12/IF(F12=\"oz\",CONVERT(E12,\"oz\",\"gal\"),IF(F12=\"pt\",CONVERT(E12,\"us_pt\",\"gal\"),IF(F12=\"qt\",CONVERT(E12,\"qt\",\"gal\"),E12)))","v":195.99200000000002},"/gal"]
[null,"Carrier Cost per Gallon",7.0000000000000001E-3,"/gal"]
[null,"Chemical Application Rate",13.7,"oz Chem. Per Acre"]
[null,null,null,null,null,null,{"$f":"IF(D15=\"oz Chem. Per Acre\",CONVERT($C$15,\"oz\",\"gal\")*$C$13+$C$14*($C$18-CONVERT($C$15,\"oz\",\"gal\")),IF(D15=\"pt Chem. Per Acre\",CONVERT($C$15,\"us_pt\",\"gal\")*$C$13+$C$14*($C$18-CONVERT($C$15,\"us_pt\",\"gal\")),CONVERT($C$15,\"qt\",\"gal\")*$C$13+$C$14*($C$18-CONVERT($C$15,\"qt\",\"gal\"))))","v":20.997519531249999}]
[null,"Spray Volume = (Chemical + Carrier)","Imperial Units",null,"Metric \nUnits",null,{"$f":"IF(D15=\"oz Chem. Per Acre\",-CONVERT($C$15,\"oz\",\"gal\")+$C$18,IF(D15=\"pt Chem. Per Acre\",-CONVERT(C15,\"us_pt\",\"gal\")+C18,-CONVERT(C15,\"qt\",\"gal\")+C18))","v":2.8929687500000001}]
[null,"Spray Volume Per Acre",3,"gal/acre",{"$f":"CONVERT(C18,\"gal\",\"l\")","v":11.356235351999999},"L/acre",{"$f":"IF(G17>=0,\"\",\"CHECK UNITS\")","v":""}]
[null,"Cost Per Spray Volume",{"$f":"G16/C18","v":6.9991731770833328},"/gal",{"$f":"C19/CONVERT(1,\"gal\",\"l\")","v":1.8489859430002062},"/L"]
[]
[null,"Drone Sprayer Specifications"]
[null,"Spray Tank Volume",2.64,"gal",{"$f":"CONVERT(C22,\"gal\",\"l\")","v":9.9934871097600002},"L"]
[null,"Max. Operating Speed for Spraying  ",15.66,"mph",{"$f":"CONVERT(C23,\"mph\",\"m/sec\")","v":7.0006463999999999},"m/s"]
[null,"Effective Spray Width",16.399999999999999,"ft",{"$f":"CONVERT(C24,\"ft\",\"m\")","v":4.9987199999999996},"m"]
[null,"Max. Flow Rate",1.32,"gal/min",{"$f":"CONVERT(C25,\"gal\",\"l\")","v":4.9967435548800001},"L/min"]
[null,"Max. Flight Time",15,"min",{"$f":"C26","v":15},"min"]
[null,"Sprayer Application Time",13,"min",{"$f":"C27","v":13},"min"]
[]
[null,"Calculated Flow Rate Required at Max. Operating Speed",{"$f":"CONVERT(E29,\"l\",\"gal\")","v":1.5565077148874533},"gal/min",{"$f":"$E$18*E23*60*$E$24/4046.86","v":5.8920226458218776},"L/min",{"$f":"IF(E29>E25,\"Too High\",\"\")","v":"Too High"}]
[null,"Calculated Speed Required at Max. Operating Flow Rate",{"$f":"CONVERT(E30,\"m/sec\",\"mph\")","v":13.280499545416438},"mph",{"$f":"E25/E18*4046.86/E24/60","v":5.9369145167829647},"m/s"]
[]
[null,"SET Actual Operating Speed",{"$f":"CONVERT(E32,\"m/sec\",\"mph\")","v":13.280499545416438},"mph",{"$f":"IF(E30<E23,E30,E23)","v":5.9369145167829647},"m/s"]
[null,"Flow Rate at Actual Operating Speed",{"$f":"CONVERT(E33,\"l\",\"gal\")","v":1.3199999999999998},"gal/min",{"$f":"$E$18*E32*60*$E$24/4046.86","v":4.9967435548799992},"L/min"]
[]
[null,"Full Load"]
[null,"Operational Flight Time Required to Empty Tank Completely",{"$f":"E22/E33","v":2.0000000000000004},"min",{"$f":"C36","v":2.0000000000000004},"min",{"$f":"IF(C36>E27,\"* Partial Load\",IF(AND(C36<=E27,C36>=E27*0.8),\"*Watch Time\",\"* Good Time\"))","v":"* Good Time"}]
[null,"Acres Sprayed Per Flight",{"$f":"C36*E32*60*E24/4046.86","v":0.88000000000000034},"acre",{"$f":"C37","v":0.88000000000000034},"acre"]
[]
[null,"Partial Load "]
[null,"Application Amount",{"$f":"CONVERT(E40,\"l\",\"gal\")","v":17.16},"gal",{"$f":"E27*E33","v":64.957666213439992},"L"]
[null,"Acres Covered Per Flight",{"$f":"E41","v":5.7200000000000015},"acre",{"$f":"E27*E32*60*E24/4046.86","v":5.7200000000000015},"acre"]
[]
[null,"Flight Information"]
[]
[null,"Total Acres Sprayed",2500,"acres",null,null,{"$f":"IF(C5=\"Enabled\",C45,\"\")","v":""}]
[null,"Number of Drones Available",{"$f":"'Equipment Ownership'!C6","v":3},"drones"]
[null,"Number of Drones Used",3,"drones"]
[null,"Total Number of Flights",{"$f":"ROUNDUP(IF(G36=\"* Partial Load\",C45/E41,C45/(C37)),0)","v":2841},"flights",null,null,{"$f":"IF(C5=\"Enabled\",C48,\"\")","v":""}]
[]
[]
[null,"Personnel Information"]
[]
[null,"Overall Labor Cost",450,"/hour"]
[]
[null,null,null,null,{"$f":"IF(C47>1,\"Assumes Simulataneous UAS Spraying\",\"\")","v":"Assumes Simulataneous UAS Spraying"}]
[null,"Personnel Responsibilities","Time Allocated Per Flight (Minutes)","Labor Cost ($/hr)","Total Time (Hours)","Annual \nCost","Annual \nCost Per UAS","Cost Per \nFlight"]
[]
[null,"Flight Planning & Setup",0.1,{"$f":"$C$53","v":450},{"$f":"C58*$C$48/60/$C$47","v":1.5783333333333334},{"$f":"(D58*C58/60)*$C$48","v":2130.75},{"$f":"(D58*C58/60)*$C$48/$C$47","v":710.25},{"$f":"G58/($C$48/$C$47)","v":0.75}]
[null,"Ferrying",0.5,450,7.8916666666666666,10653.75,{"$f":"D59*C59/60*$C$48/$C$47","v":3551.25},{"$f":"G59/($C$48/$C$47)","v":3.75}]
[null,"Actual UAS Spraying Time",{"$f":"IF(G36=\"* Partial Load\",E27,Chemicals8!C36)","v":2.0000000000000004},450,31.566666666666674,42615.000000000007,14205.000000000002,15.000000000000002]
[null,"Time Spent Between Flights",0.5,450,7.8916666666666666,10653.75,3551.25,3.75]
[null,"Post-Processing",0,450,0,0,0,0]
[null,"Visual Observer",{"$f":"SUM(C58:C61)","v":3.1000000000000005},20,48.928333333333342,2935.7000000000007,978.56666666666695,1.0333333333333337]
[null,"Other",0,450,0,0,0,0]
[]
[null,"Personnel Total Cost",null,null,null,{"$f":"SUM(F58:F64)","v":68988.95},{"$f":"SUM(G58:G64)","v":22996.316666666666},{"$f":"SUM(H58:H64)","v":24.283333333333335}]
[]
[null,"Total Man Hours",null,null,{"$f":"SUM(E58:E64)","v":97.856666666666683}]
[null,"Pilot in Command (PIC) Hours",null,null,{"$f":"SUM(E58:E62,E64)","v":48.928333333333342}]
[null,"Pilot in Command (PIC) Weeks (40 hrs)",null,null,{"$f":"E69/40","v":1.2232083333333335}]
[null,"Acres/Hour PIC",null,null,{"$f":"C45/E69","v":51.095139149095608}]
[]
[null,"Economic Considerations"]
[]
[null,"Cost Per Flight"]
[null,"Total UAS Cost of Application Per Flight",{"$f":"('Total Costs'!E23)+H66","v":29.596346617719377},"/flight"]
[null,"Total Chemical Cost Per Flight",{"$f":"E22*E19","v":18.477817187500001},"/flight"]
[null,"Total Cost (UAS & Chemical) Per Flight",{"$f":"SUM(C76:C77)","v":48.074163805219378},"/flight"]
[]
[null,"Cost Per Acre"]
[null,"Total UAS Cost of Application Per Acre",{"$f":"IF($G$36=\"* Partial Load\",$C$76/$E$41,$C$76/$C$37)","v":33.632212065590188},"/acre"]
[null,"Total Chemical Cost Per Acre",{"$f":"E19*E18","v":20.997519531249996},"/acre"]
[null,"Total Cost (UAS & Chemical) Per Acre",{"$f":"SUM(C81:C82)","v":54.629731596840188},"/acre"]
[]
[]
[null,"$/bu for Crop",10,"/bu"]
[null,"Breakeven Increase in \nYield Bu/Acre Required",{"$f":"C83/C86","v":5.4629731596840188},"bu"]
[]
[null,{"$f":"IF('Total Costs'!D8='Total Costs'!G17,\"Pilot in Command (PIC) Cost\",\"Pilot in Command (PIC) Income\")","v":"Pilot in Command (PIC) Income"},{"$f":"SUM(G58:G62,G64)*C47","v":66053.25},null,{"$f":"IF(C5=\"Enabled\",F66,\"\")","v":""}]
[null,"Pilot in Command (PIC) ($/Flight)",{"$f":"C89/C48","v":23.25},"/flight"]
[]
[null,"Total Cost (UAS & Chemical) ",{"$f":"C83*C45","v":136574.32899210046}]
[]
[]
[null,"Desired Total UAS Cost of Application Per Acre",12,"/acre"]

{"sheet":"Chemicals9","index":16,"n_rows":95,"n_cols":10,"rows_kept":95,"cut":false,"hidden":false,"merged":[[2,1,2,5],[4,3,4,5],[5,2,5,5],[14,3,14,4],[16,2,16,3],[16,4,16,5],[42,1,42,5],[44,3,44,5],[45,3,45,5],[46,3,46,5],[47,3,47,5]]}
[]
[]
[null,"Sheet Description "]
[]
[null,"Sheet Status",{"$f":"Directory!E25","v":"Disabled"},{"$f":"IF(C3=\"Disabled\",\"**To Activate Go to Directory Tab**\",\"\")","v":""}]
[null,"Chemical 1 Name",{"$f":"Directory!B25","v":"Fungicide"}]
[]
[]
[null,"Chemical & Drone Information",null,null,null,null,null,"oz Chem. Per Acre",null,"oz"]
[null,null,null,null,null,null,null,"pt Chem. Per Acre",null,"pt"]
[null,"Chemical Information",null,null,null,null,null,"qt Chem. Per Acre ",null,"qt"]
[null,"Chemical Cost",489.98,"per",2.5,"gal",null,null,null,"gal"]
[null,"Chemical Cost per Gallon",{"$f":"C12/IF(F12=\"oz\",CONVERT(E12,\"oz\",\"gal\"),IF(F12=\"pt\",CONVERT(E12,\"us_pt\",\"gal\"),IF(F12=\"qt\",CONVERT(E12,\"qt\",\"gal\"),E12)))","v":195.99200000000002},"/gal"]
[null,"Carrier Cost per Gallon",7.0000000000000001E-3,"/gal"]
[null,"Chemical Application Rate",13.7,"oz Chem. Per Acre"]
[null,null,null,null,null,null,{"$f":"IF(D15=\"oz Chem. Per Acre\",CONVERT($C$15,\"oz\",\"gal\")*$C$13+$C$14*($C$18-CONVERT($C$15,\"oz\",\"gal\")),IF(D15=\"pt Chem. Per Acre\",CONVERT($C$15,\"us_pt\",\"gal\")*$C$13+$C$14*($C$18-CONVERT($C$15,\"us_pt\",\"gal\")),CONVERT($C$15,\"qt\",\"gal\")*$C$13+$C$14*($C$18-CONVERT($C$15,\"qt\",\"gal\"))))","v":20.997519531249999}]
[null,"Spray Volume = (Chemical + Carrier)","Imperial Units",null,"Metric \nUnits",null,{"$f":"IF(D15=\"oz Chem. Per Acre\",-CONVERT($C$15,\"oz\",\"gal\")+$C$18,IF(D15=\"pt Chem. Per Acre\",-CONVERT(C15,\"us_pt\",\"gal\")+C18,-CONVERT(C15,\"qt\",\"gal\")+C18))","v":2.8929687500000001}]
[null,"Spray Volume Per Acre",3,"gal/acre",{"$f":"CONVERT(C18,\"gal\",\"l\")","v":11.356235351999999},"L/acre",{"$f":"IF(G17>=0,\"\",\"CHECK UNITS\")","v":""}]
[null,"Cost Per Spray Volume",{"$f":"G16/C18","v":6.9991731770833328},"/gal",{"$f":"C19/CONVERT(1,\"gal\",\"l\")","v":1.8489859430002062},"/L"]
[]
[null,"Drone Sprayer Specifications"]
[null,"Spray Tank Volume",2.64,"gal",{"$f":"CONVERT(C22,\"gal\",\"l\")","v":9.9934871097600002},"L"]
[null,"Max. Operating Speed for Spraying  ",15.66,"mph",{"$f":"CONVERT(C23,\"mph\",\"m/sec\")","v":7.0006463999999999},"m/s"]
[null,"Effective Spray Width",16.399999999999999,"ft",{"$f":"CONVERT(C24,\"ft\",\"m\")","v":4.9987199999999996},"m"]
[null,"Max. Flow Rate",1.32,"gal/min",{"$f":"CONVERT(C25,\"gal\",\"l\")","v":4.9967435548800001},"L/min"]
[null,"Max. Flight Time",15,"min",{"$f":"C26","v":15},"min"]
[null,"Sprayer Application Time",13,"min",{"$f":"C27","v":13},"min"]
[]
[null,"Calculated Flow Rate Required at Max. Operating Speed",{"$f":"CONVERT(E29,\"l\",\"gal\")","v":1.5565077148874533},"gal/min",{"$f":"$E$18*E23*60*$E$24/4046.86","v":5.8920226458218776},"L/min",{"$f":"IF(E29>E25,\"Too High\",\"\")","v":"Too High"}]
[null,"Calculated Speed Required at Max. Operating Flow Rate",{"$f":"CONVERT(E30,\"m/sec\",\"mph\")","v":13.280499545416438},"mph",{"$f":"E25/E18*4046.86/E24/60","v":5.9369145167829647},"m/s"]
[]
[null,"SET Actual Operating Speed",{"$f":"CONVERT(E32,\"m/sec\",\"mph\")","v":13.280499545416438},"mph",{"$f":"IF(E30<E23,E30,E23)","v":5.9369145167829647},"m/s"]
[null,"Flow Rate at Actual Operating Speed",{"$f":"CONVERT(E33,\"l\",\"gal\")","v":1.3199999999999998},"gal/min",{"$f":"$E$18*E32*60*$E$24/4046.86","v":4.9967435548799992},"L/min"]
[]
[null,"Full Load"]
[null,"Operational Flight Time Required to Empty Tank Completely",{"$f":"E22/E33","v":2.0000000000000004},"min",{"$f":"C36","v":2.0000000000000004},"min",{"$f":"IF(C36>E27,\"* Partial Load\",IF(AND(C36<=E27,C36>=E27*0.8),\"*Watch Time\",\"* Good Time\"))","v":"* Good Time"}]
[null,"Acres Sprayed Per Flight",{"$f":"C36*E32*60*E24/4046.86","v":0.88000000000000034},"acre",{"$f":"C37","v":0.88000000000000034},"acre"]
[]
[null,"Partial Load "]
[null,"Application Amount",{"$f":"CONVERT(E40,\"l\",\"gal\")","v":17.16},"gal",{"$f":"E27*E33","v":64.957666213439992},"L"]
[null,"Acres Covered Per Flight",{"$f":"E41","v":5.7200000000000015},"acre",{"$f":"E27*E32*60*E24/4046.86","v":5.7200000000000015},"acre"]
[]
[null,"Flight Information"]
[]
[null,"Total Acres Sprayed",2500,"acres",null,null,{"$f":"IF(C5=\"Enabled\",C45,\"\")","v":""}]
[null,"Number of Drones Available",{"$f":"'Equipment Ownership'!C6","v":3},"drones"]
[null,"Number of Drones Used",3,"drones"]
[null,"Total Number of Flights",{"$f":"ROUNDUP(IF(G36=\"* Partial Load\",C45/E41,C45/(C37)),0)","v":2841},"flights",null,null,{"$f":"IF(C5=\"Enabled\",C48,\"\")","v":""}]
[]
[]
[null,"Personnel Information"]
[]
[null,"Overall Labor Cost",450,"/hour"]
[]
[null,null,null,null,{"$f":"IF(C47>1,\"Assumes Simulataneous UAS Spraying\",\"\")","v":"Assumes Simulataneous UAS Spraying"}]
[null,"Personnel Responsibilities","Time Allocated Per Flight (Minutes)","Labor Cost ($/hr)","Total Time (Hours)","Annual \nCost","Annual \nCost Per UAS","Cost Per \nFlight"]
[]
[null,"Flight Planning & Setup",0.1,{"$f":"$C$53","v":450},{"$f":"C58*$C$48/60/$C$47","v":1.5783333333333334},{"$f":"(D58*C58/60)*$C$48","v":2130.75},{"$f":"(D58*C58/60)*$C$48/$C$47","v":710.25},{"$f":"G58/($C$48/$C$47)","v":0.75}]
[null,"Ferrying",0.5,450,7.8916666666666666,10653.75,{"$f":"D59*C59/60*$C$48/$C$47","v":3551.25},{"$f":"G59/($C$48/$C$47)","v":3.75}]
[null,"Actual UAS Spraying Time",{"$f":"IF(G36=\"* Partial Load\",E27,Chemicals9!C36)","v":2.0000000000000004},450,31.566666666666674,42615.000000000007,14205.000000000002,15.000000000000002]
[null,"Time Spent Between Flights",0.5,450,7.8916666666666666,10653.75,3551.25,3.75]
[null,"Post-Processing",0,450,0,0,0,0]
[null,"Visual Observer",{"$f":"SUM(C58:C61)","v":3.1000000000000005},20,48.928333333333342,2935.7000000000007,978.56666666666695,1.0333333333333337]
[null,"Other",0,450,0,0,0,0]
[]
[null,"Personnel Total Cost",null,null,null,{"$f":"SUM(F58:F64)","v":68988.95},{"$f":"SUM(G58:G64)","v":22996.316666666666},{"$f":"SUM(H58:H64)","v":24.283333333333335}]
[]
[null,"Total Man Hours",null,null,{"$f":"SUM(E58:E64)","v":97.856666666666683}]
[null,"Pilot in Command (PIC) Hours",null,null,{"$f":"SUM(E58:E62,E64)","v":48.928333333333342}]
[null,"Pilot in Command (PIC) Weeks (40 hrs)",null,null,{"$f":"E69/40","v":1.2232083333333335}]
[null,"Acres/Hour PIC",null,null,{"$f":"C45/E69","v":51.095139149095608}]
[]
[null,"Economic Considerations"]
[]
[null,"Cost Per Flight"]
[null,"Total UAS Cost of Application Per Flight",{"$f":"('Total Costs'!E23)+H66","v":29.596346617719377},"/flight"]
[null,"Total Chemical Cost Per Flight",{"$f":"E22*E19","v":18.477817187500001},"/flight"]
[null,"Total Cost (UAS & Chemical) Per Flight",{"$f":"SUM(C76:C77)","v":48.074163805219378},"/flight"]
[]
[null,"Cost Per Acre"]
[null,"Total UAS Cost of Application Per Acre",{"$f":"IF($G$36=\"* Partial Load\",$C$76/$E$41,$C$76/$C$37)","v":33.632212065590188},"/acre"]
[null,"Total Chemical Cost Per Acre",{"$f":"E19*E18","v":20.997519531249996},"/acre"]
[null,"Total Cost (UAS & Chemical) Per Acre",{"$f":"SUM(C81:C82)","v":54.629731596840188},"/acre"]
[]
[]
[null,"$/bu for Crop",10,"/bu"]
[null,"Breakeven Increase in \nYield Bu/Acre Required",{"$f":"C83/C86","v":5.4629731596840188},"bu"]
[]
[null,{"$f":"IF('Total Costs'!D8='Total Costs'!G17,\"Pilot in Command (PIC) Cost\",\"Pilot in Command (PIC) Income\")","v":"Pilot in Command (PIC) Income"},{"$f":"SUM(G58:G62,G64)*C47","v":66053.25},null,{"$f":"IF(C5=\"Enabled\",F66,\"\")","v":""}]
[null,"Pilot in Command (PIC) ($/Flight)",{"$f":"C89/C48","v":23.25},"/flight"]
[]
[null,"Total Cost (UAS & Chemical) ",{"$f":"C83*C45","v":136574.32899210046}]
[]
[]
[null,"Desired Total UAS Cost of Application Per Acre",12,"/acre"]

{"sheet":"Chemicals10","index":17,"n_rows":95,"n_cols":10,"rows_kept":95,"cut":false,"hidden":false,"merged":[[2,1,2,5],[4,3,4,5],[5,2,5,5],[14,3,14,4],[16,2,16,3],[16,4,16,5],[42,1,42,5],[44,3,44,5],[45,3,45,5],[46,3,46,5],[47,3,47,5]]}
[]
[]
[null,"Sheet Description "]
[]
[null,"Sheet Status",{"$f":"Directory!E26","v":"Disabled"},{"$f":"IF(C3=\"Disabled\",\"**To Activate Go to Directory Tab**\",\"\")","v":""}]
[null,"Chemical 1 Name",{"$f":"Directory!B26","v":"Pesticide "}]
[]
[]
[null,"Chemical & Drone Information",null,null,null,null,null,"oz Chem. Per Acre",null,"oz"]
[null,null,null,null,null,null,null,"pt Chem. Per Acre",null,"pt"]
[null,"Chemical Information",null,null,null,null,null,"qt Chem. Per Acre ",null,"qt"]
[null,"Chemical Cost",489.98,"per",2.5,"gal",null,null,null,"gal"]
[null,"Chemical Cost per Gallon",{"$f":"C12/IF(F12=\"oz\",CONVERT(E12,\"oz\",\"gal\"),IF(F12=\"pt\",CONVERT(E12,\"us_pt\",\"gal\"),IF(F12=\"qt\",CONVERT(E12,\"qt\",\"gal\"),E12)))","v":195.99200000000002},"/gal"]
[null,"Carrier Cost per Gallon",7.0000000000000001E-3,"/gal"]
[null,"Chemical Application Rate",13.7,"oz Chem. Per Acre"]
[null,null,null,null,null,null,{"$f":"IF(D15=\"oz Chem. Per Acre\",CONVERT($C$15,\"oz\",\"gal\")*$C$13+$C$14*($C$18-CONVERT($C$15,\"oz\",\"gal\")),IF(D15=\"pt Chem. Per Acre\",CONVERT($C$15,\"us_pt\",\"gal\")*$C$13+$C$14*($C$18-CONVERT($C$15,\"us_pt\",\"gal\")),CONVERT($C$15,\"qt\",\"gal\")*$C$13+$C$14*($C$18-CONVERT($C$15,\"qt\",\"gal\"))))","v":20.997519531249999}]
[null,"Spray Volume = (Chemical + Carrier)","Imperial Units",null,"Metric \nUnits",null,{"$f":"IF(D15=\"oz Chem. Per Acre\",-CONVERT($C$15,\"oz\",\"gal\")+$C$18,IF(D15=\"pt Chem. Per Acre\",-CONVERT(C15,\"us_pt\",\"gal\")+C18,-CONVERT(C15,\"qt\",\"gal\")+C18))","v":2.8929687500000001}]
[null,"Spray Volume Per Acre",3,"gal/acre",{"$f":"CONVERT(C18,\"gal\",\"l\")","v":11.356235351999999},"L/acre",{"$f":"IF(G17>=0,\"\",\"CHECK UNITS\")","v":""}]
[null,"Cost Per Spray Volume",{"$f":"G16/C18","v":6.9991731770833328},"/gal",{"$f":"C19/CONVERT(1,\"gal\",\"l\")","v":1.8489859430002062},"/L"]
[]
[null,"Drone Sprayer Specifications"]
[null,"Spray Tank Volume",2.64,"gal",{"$f":"CONVERT(C22,\"gal\",\"l\")","v":9.9934871097600002},"L"]
[null,"Max. Operating Speed for Spraying  ",15.66,"mph",{"$f":"CONVERT(C23,\"mph\",\"m/sec\")","v":7.0006463999999999},"m/s"]
[null,"Effective Spray Width",16.399999999999999,"ft",{"$f":"CONVERT(C24,\"ft\",\"m\")","v":4.9987199999999996},"m"]
[null,"Max. Flow Rate",1.32,"gal/min",{"$f":"CONVERT(C25,\"gal\",\"l\")","v":4.9967435548800001},"L/min"]
[null,"Max. Flight Time",15,"min",{"$f":"C26","v":15},"min"]
[null,"Sprayer Application Time",13,"min",{"$f":"C27","v":13},"min"]
[]
[null,"Calculated Flow Rate Required at Max. Operating Speed",{"$f":"CONVERT(E29,\"l\",\"gal\")","v":1.5565077148874533},"gal/min",{"$f":"$E$18*E23*60*$E$24/4046.86","v":5.8920226458218776},"L/min",{"$f":"IF(E29>E25,\"Too High\",\"\")","v":"Too High"}]
[null,"Calculated Speed Required at Max. Operating Flow Rate",{"$f":"CONVERT(E30,\"m/sec\",\"mph\")","v":13.280499545416438},"mph",{"$f":"E25/E18*4046.86/E24/60","v":5.9369145167829647},"m/s"]
[]
[null,"SET Actual Operating Speed",{"$f":"CONVERT(E32,\"m/sec\",\"mph\")","v":13.280499545416438},"mph",{"$f":"IF(E30<E23,E30,E23)","v":5.9369145167829647},"m/s"]
[null,"Flow Rate at Actual Operating Speed",{"$f":"CONVERT(E33,\"l\",\"gal\")","v":1.3199999999999998},"gal/min",{"$f":"$E$18*E32*60*$E$24/4046.86","v":4.9967435548799992},"L/min"]
[]
[null,"Full Load"]
[null,"Operational Flight Time Required to Empty Tank Completely",{"$f":"E22/E33","v":2.0000000000000004},"min",{"$f":"C36","v":2.0000000000000004},"min",{"$f":"IF(C36>E27,\"* Partial Load\",IF(AND(C36<=E27,C36>=E27*0.8),\"*Watch Time\",\"* Good Time\"))","v":"* Good Time"}]
[null,"Acres Sprayed Per Flight",{"$f":"C36*E32*60*E24/4046.86","v":0.88000000000000034},"acre",{"$f":"C37","v":0.88000000000000034},"acre"]
[]
[null,"Partial Load "]
[null,"Application Amount",{"$f":"CONVERT(E40,\"l\",\"gal\")","v":17.16},"gal",{"$f":"E27*E33","v":64.957666213439992},"L"]
[null,"Acres Covered Per Flight",{"$f":"E41","v":5.7200000000000015},"acre",{"$f":"E27*E32*60*E24/4046.86","v":5.7200000000000015},"acre"]
[]
[null,"Flight Information"]
[]
[null,"Total Acres Sprayed",2500,"acres",null,null,{"$f":"IF(C5=\"Enabled\",C45,\"\")","v":""}]
[null,"Number of Drones Available",{"$f":"'Equipment Ownership'!C6","v":3},"drones"]
[null,"Number of Drones Used",3,"drones"]
[null,"Total Number of Flights",{"$f":"ROUNDUP(IF(G36=\"* Partial Load\",C45/E41,C45/(C37)),0)","v":2841},"flights",null,null,{"$f":"IF(C5=\"Enabled\",C48,\"\")","v":""}]
[]
[]
[null,"Personnel Information"]
[]
[null,"Overall Labor Cost",450,"/hour"]
[]
[null,null,null,null,{"$f":"IF(C47>1,\"Assumes Simulataneous UAS Spraying\",\"\")","v":"Assumes Simulataneous UAS Spraying"}]
[null,"Personnel Responsibilities","Time Allocated Per Flight (Minutes)","Labor Cost ($/hr)","Total Time (Hours)","Annual \nCost","Annual \nCost Per UAS","Cost Per \nFlight"]
[]
[null,"Flight Planning & Setup",0.1,{"$f":"$C$53","v":450},{"$f":"C58*$C$48/60/$C$47","v":1.5783333333333334},{"$f":"(D58*C58/60)*$C$48","v":2130.75},{"$f":"(D58*C58/60)*$C$48/$C$47","v":710.25},{"$f":"G58/($C$48/$C$47)","v":0.75}]
[null,"Ferrying",0.5,450,7.8916666666666666,10653.75,{"$f":"D59*C59/60*$C$48/$C$47","v":3551.25},{"$f":"G59/($C$48/$C$47)","v":3.75}]
[null,"Actual UAS Spraying Time",{"$f":"IF(G36=\"* Partial Load\",E27,Chemicals10!C36)","v":2.0000000000000004},450,31.566666666666674,42615.000000000007,14205.000000000002,15.000000000000002]
[null,"Time Spent Between Flights",0.5,450,7.8916666666666666,10653.75,3551.25,3.75]
[null,"Post-Processing",0,450,0,0,0,0]
[null,"Visual Observer",{"$f":"SUM(C58:C61)","v":3.1000000000000005},20,48.928333333333342,2935.7000000000007,978.56666666666695,1.0333333333333337]
[null,"Other",0,450,0,0,0,0]
[]
[null,"Personnel Total Cost",null,null,null,{"$f":"SUM(F58:F64)","v":68988.95},{"$f":"SUM(G58:G64)","v":22996.316666666666},{"$f":"SUM(H58:H64)","v":24.283333333333335}]
[]
[null,"Total Man Hours",null,null,{"$f":"SUM(E58:E64)","v":97.856666666666683}]
[null,"Pilot in Command (PIC) Hours",null,null,{"$f":"SUM(E58:E62,E64)","v":48.928333333333342}]
[null,"Pilot in Command (PIC) Weeks (40 hrs)",null,null,{"$f":"E69/40","v":1.2232083333333335}]
[null,"Acres/Hour PIC",null,null,{"$f":"C45/E69","v":51.095139149095608}]
[]
[null,"Economic Considerations"]
[]
[null,"Cost Per Flight"]
[null,"Total UAS Cost of Application Per Flight",{"$f":"('Total Costs'!E23)+H66","v":29.596346617719377},"/flight"]
[null,"Total Chemical Cost Per Flight",{"$f":"E22*E19","v":18.477817187500001},"/flight"]
[null,"Total Cost (UAS & Chemical) Per Flight",{"$f":"SUM(C76:C77)","v":48.074163805219378},"/flight"]
[]
[null,"Cost Per Acre"]
[null,"Total UAS Cost of Application Per Acre",{"$f":"IF($G$36=\"* Partial Load\",$C$76/$E$41,$C$76/$C$37)","v":33.632212065590188},"/acre"]
[null,"Total Chemical Cost Per Acre",{"$f":"E19*E18","v":20.997519531249996},"/acre"]
[null,"Total Cost (UAS & Chemical) Per Acre",{"$f":"SUM(C81:C82)","v":54.629731596840188},"/acre"]
[]
[]
[null,"$/bu for Crop",10,"/bu"]
[null,"Breakeven Increase in \nYield Bu/Acre Required",{"$f":"C83/C86","v":5.4629731596840188},"bu"]
[]
[null,{"$f":"IF('Total Costs'!D8='Total Costs'!G17,\"Pilot in Command (PIC) Cost\",\"Pilot in Command (PIC) Income\")","v":"Pilot in Command (PIC) Income"},{"$f":"SUM(G58:G62,G64)*C47","v":66053.25},null,{"$f":"IF(C5=\"Enabled\",F66,\"\")","v":""}]
[null,"Pilot in Command (PIC) ($/Flight)",{"$f":"C89/C48","v":23.25},"/flight"]
[]
[null,"Total Cost (UAS & Chemical) ",{"$f":"C83*C45","v":136574.32899210046}]
[]
[]
[null,"Desired Total UAS Cost of Application Per Acre",12,"/acre"]