{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Planner v1.4","Instructions","Release notes","Data"],"not_rendered":{"images":6,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Planner v1.4","index":0,"n_rows":81,"n_cols":14,"rows_kept":81,"merged":[[0,0,0,13],[1,0,1,13],[2,0,2,13],[3,0,3,13],[8,0,8,4],[8,8,8,13],[9,0,9,4],[9,8,9,13],[11,1,11,4],[13,1,13,4],[15,0,15,4],[19,8,19,13],[25,0,25,4],[25,8,25,13],[28,8,28,9],[30,8,30,9],[32,8,32,9],[34,8,34,9],[36,8,36,9],[38,8,38,9],[41,0,41,13],[46,0,46,1],[47,0,47,1],[48,0,48,1],[52,9,52,11],[80,0,80,13]]}
["+SPRAY Application Planner "]
["(Software support from v2.014)"]
["Instructions"]
["This tool can be used as a guideline to ensure correct application rates for a desired field / plot. Follow instructions below:"]
["1)","Fill out required information in GREEN cells, select required information in BLUE cells. Results in WHITE cells."]
["2)","Cell turns YELLOW if close to limit. Cell turns RED if above or below limit. Change parameters respectively."]
["3)","Fill tanks according to recipe below - ATTENTION: Added water amount in application tank must be precise."]
[]
["Settings",{"$nulls":7},"Calculations"]
["User",{"$nulls":7},"Field"]
[]
["Name:",{"$nulls":7},"No crops per hectare",{"$nulls":3},{"$f":"IFERROR(100/$D$20*100/$D$22*10000,\"N/A\")","v":"N/A"},"crops/ha"]
[]
["Date:",{"$nulls":7},"Total sprayed area %",{"$nulls":3},{"$f":"IFERROR(IF(D24=\"Band Spray\",((D37*10)*(100/D20)/10000),((ROUNDUP(($D$29+$D$31)/D33,0)*D33*D37/100)*M12*10^-4/10000)),\"N/A\")","v":"N/A"}]
[]
["Field",{"$nulls":7},"Actual application rate",{"$nulls":3},{"$f":"IFERROR(D18*M14,\"N/A\")","v":"N/A"},"l/ha"]
[]
["Nominal Appl. Rate (Default 300)",null,{"$f":"\"(\"&F18&\" to \"&G18&\")\"","v":"(N/A to 600)"},null,"l/ha",{"$f":"IFERROR(IF(ROUNDUP(20/G40*D18,0)<150,150,ROUNDUP(20/G40*D18,0)),\"N/A\")","v":"N/A"},600,null,"Savings %",{"$nulls":3},{"$f":"IFERROR(1-M14,\"N/A\")","v":"N/A"}]
[{"$nulls":3},89]
["Row distance",null,{"$f":"\"(\"&F20&\" to \"&G20&\")\"","v":"(22,5 to 100)"},null,"cm",22.5,100,null,"Applications"]
[]
["Crop distance",null,{"$f":"\"(\"&F22&\" to \"&G22&\")\"","v":"(3 to 50)"},null,"cm",3,50,{"$nulls":4},"Field or plot area [ha]",null,"Hectares"]
[]
["Spot- or Band spray",null,null,"Spot Spray",{"$nulls":7},"Required water amount [Litres]",{"$f":"IFERROR(M22*M16,\"N/A\")","v":"N/A"},"Litres"]
[]
["Sprayer",{"$nulls":7},"Product specifications"]
["Nozzle type (Default TP250025 = 25̊   )",null,null,"TP250025",null,{"$f":"+VLOOKUP(D27,Data!C1:D6,2,FALSE)","v":25},null,null,"Product name",null,null,"Dosis/ha","Total Dosis","Units"]
[]
["Spray distance before plant",null,{"$f":"\"(\"&F29&\" to \"&G29&\")\"","v":"(20 to -20)"},null,"mm",20,{"$f":"+IF(D22*10<100,D22*10-F29,100)","v":-20},{"$nulls":5},{"$f":"IF(L29=\"\",\"\",(L29/$D$18*$M$24))","v":""}]
[]
["Spray distance after plant",null,{"$f":"\"(\"&F31&\" to \"&G31&\")\"","v":"(20 to 20)"},null,"mm",20,{"$f":"IF(IF(100<D22*10-D29,100,D22*10-D29)<20,\"20\",IF(100<D22*10-D29,100,D22*10-D29))","v":"20"},{"$nulls":5},{"$f":"IF(L31=\"\",\"\",(L31/$D$18*$M$24))","v":""}]
[]
["Pulse distance (Default 20)",null,{"$f":"\"(\"&F33&\" to \"&G33&\")\"","v":"(10 to 50)"},null,"mm",{"$f":"IFERROR(IF(ROUNDUP(20/G40*D33,0)<10,10,ROUNDUP(20/G40*D33,0)),10)","v":10},50,{"$nulls":5},{"$f":"IF(L33=\"\",\"\",(L33/$D$18*$M$24))","v":""}]
[]
["Spray pressure (Default 3,0)",null,{"$f":"\"(\"&F35&\" to \"&G35&\")\"","v":"(2 to 4)"},null,"bar",2,4,{"$nulls":5},{"$f":"IF(L35=\"\",\"\",(L35/$D$18*$M$24))","v":""}]
[]
["Spray band width",null,{"$f":"\"(\"&F37&\" to \"&G37&\")\"","v":"(67 to 99)"},null,"mm",{"$f":"IFERROR(IF(ROUNDUP(20/G40*D37,0)<(TAN(RADIANS(F27/2))*150*2),ROUNDUP(TAN(RADIANS(F27/2))*150*2,0),ROUNDUP(20/G40*D37,0)),ROUNDUP(TAN(RADIANS(F27/2))*150*2,0))","v":67},{"$f":"ROUNDDOWN((IF(F27=25,TAN(RADIANS(25/2))*225*2,TAN(RADIANS(40/2))*225*2)),0)","v":99},{"$nulls":5},{"$f":"IF(L37=\"\",\"\",(L37/$D$18*$M$24))","v":""}]
[{"$nulls":3},208]
["Required nozzle height",null,null,{"$f":"+IF(OR(D37/(2*TAN(RADIANS((F27/2))))<F39,D37/(2*TAN(RADIANS((F27/2))))>G39),\"N/A\",D37/(2*TAN(RADIANS((F27/2)))))","v":"N/A"},"mm",150,225,{"$nulls":5},{"$f":"IF(L39=\"\",\"\",(L39/$D$18*$M$24))","v":""}]
[{"$nulls":6},{"$f":"(D37*D33/10^6/10000*D18*1000)/(95/60/1000*SQRT(D35/3))-0.3","v":{"$error":"#DIV/0!"}}]
[]
["+SPRAY Dosing recipe"]
[]
[]
[]
[]
["Total Water (Minimum)",null,{"$f":"IFERROR(C49+C48,\"N/A\")","v":{"v":55,"d":"55.0"}},"Litres",{"$nulls":5},"Water for spray (Exact)",null,{"$f":"IFERROR(IF(M24/2>50,50,M24/2),\"\")","v":""},"Litres"]
["Water for cleaning",null,5,"Litres",{"$nulls":5},{"$f":"IF(I29=\"\",\"\",I29)","v":""},null,{"$f":"IF(M29=\"\",\"\",(IF($M$24/2>50,(100/$M$24*M29),M29)))","v":""},{"$f":"IF(N29=\"\",\"\",N29)","v":""}]
["Water for spray",null,{"$f":"IFERROR(IF(L47>50,50,L47),\"N/A\")","v":{"v":50,"d":"50.0"}},"Litres",{"$nulls":5},{"$f":"IF(I31=\"\",\"\",I31)","v":""},null,{"$f":"IF(M31=\"\",\"\",(IF($M$24/2>50,(100/$M$24*M31),M31)))","v":""},{"$f":"IF(N31=\"\",\"\",N31)","v":""}]
[{"$nulls":9},{"$f":"IF(I33=\"\",\"\",I33)","v":""},null,{"$f":"IF(M33=\"\",\"\",(IF($M$24/2>50,(100/$M$24*M33),M33)))","v":""},{"$f":"IF(N33=\"\",\"\",N33)","v":""}]
[{"$nulls":9},{"$f":"IF(I35=\"\",\"\",I35)","v":""},null,{"$f":"IF(M35=\"\",\"\",(IF($M$24/2>50,(100/$M$24*M35),M35)))","v":""},{"$f":"IF(N35=\"\",\"\",N35)","v":""}]
[{"$nulls":9},{"$f":"IF(I37=\"\",\"\",I37)","v":""},null,{"$f":"IF(M37=\"\",\"\",(IF($M$24/2>50,(100/$M$24*M37),M37)))","v":""},{"$f":"IF(N37=\"\",\"\",N37)","v":""}]
{"$rows_empty":28}
["+SPRAY Application Planner Tool v1.4 - Released 06-03-2026 PFM"]

{"sheet":"Instructions","index":1,"n_rows":41,"n_cols":1,"rows_kept":41}
["The +SPRAY Application Planner is used to evaluate settings of the sprayer and calculate the amount of product and water needed for a specific spray operation. The tool can be used before moving to the field and adjustment on the sprayer can be done in advance as for example height of the nozzle position and nozzle type."]
[]
["If conditions are known in advance, it can be the easiest to change nozzles and adjust the height before moving to the field. The planning tool can be a way to test different settings to identify the right combination of band width and water volumes. "]
[]
["In case a desired setting is not allowed(too high or too low) the respective out-of-range values will be displayed with red."]
["In case a desired setting is close to the respective out-of-range values will be displayed with yellow."]
["                             "]
["The +SPRAY Application Planner contains 3 tables. The tables are prepared for entering your data"]
["The 3 tables in the sheet are:"]
["  "]
["Enter values were indicated with green in the tables “Settings”. The field “Required nozzle height” is calculated based on the other data entered."]
["In “Normal Application Rate” enter the water volume that would the target for a conventional broadacre spray"]
["In “Row distance” enter row distance used when seeded in cm."]
["In “Crop distance” enter distance between plants in the row when seeding in cm. From this value, the planner calculates the number of plants per hectare."]
["In “Spot- or band spray”, you select whether the spray is a spot spray , or if it is as a band spray in the complete length of the row."]
["In “Nozzle type”, you select whether you will use a 25-degree nozzle (TP250025)(narrow bands) or the 40-degree nozzle (TP400025)(wider bands)"]
["In “Spray distance before crop” you enter how far ahead (in mm) of the plant the spot spray shall begin"]
["In “Spray distance after crop” you enter how far after the plant (in mm), the spray shall continue. The sum of the two will be the length of the spot"]
["In \"Pulse distance\" you enter the desired distance between each spray burst on the soil, determining the spray pattern / overlap."]
["In \"Spray pressure\" you enter the desired operating pressure in the system.  Careful going below 2 bar, as it greatly affects the nozzle distribution pattern."]
["In “Spray band width” you enter the targeted band width in millimetres"]
["Required nozzle height is calculated - THIS IS THE SETTING YOU NEED TO MOUNT THE NOZZLES IN ON THE DROID"]
[]
[]
[]
["."]
["The result of the data entered in “Settings” can be found in the table “Calculations”."]
["In this table you enter the area planned to be treated. And can see the calculated need for chemicals for the complete operation. In the example, 7,8 ha are covered of which only 4,8% of the area is treated resulting in a total need for 112,3 liters for the complete operation."]
[]
["·         “No crops per hectare” is the number of plants per hectare achieved when seeded."]
["·         “Actual application rate” is the water volume sprayed per hectare by the FarmDroid"]
["·         “Total sprayed area % is calculated from the plot size and the number of plants per hectare"]
["·         “Savings %” are the residual and not sprayed part of the field"]
["·         In “Field or plot area (ha)” you enter the area of the field or part of a field that shall be covered in the spray operation. This field must be filled out, and based on the area, a final recipe is calculated."]
["·         “Required water amount (Litres)” is the total amount of water (both tanks) which is needed for a spray operation with the entered specifications."]
[]
["The results are transferred to the table “Dosing recipe”, See here under. I"]
[]
["In this example, 55 liter of clean water is suggested to be added to the clean water tank, and 50 liter in the application tank. The total volume in this tank must be exactly 50 liter in this example to meet the correct solution for the final application on the ground. The additional 5 liters in the clean water tank are used for flushing, priming and in the end cleaning the system. "]
["The recipe can never exceed an application volume higher than 100 liter since 5 liter must be kept in the clean water tank for cleaning and flushing. "]
["Be aware that this limit is included in the calculation of the recipe, and if a higher volume is needed, a new mixture must be calculated."]

{"sheet":"Release notes","index":2,"n_rows":6,"n_cols":3,"rows_kept":6}
["Version","Release date","Note"]
["1.0","2024-04-11","First release"]
["1.1","2024-04-24","Fixed calculation error \"actual apl litres/ha\" (minor detail with no effect on recipe)"]
["1.2","2024-06-04","Changed max tank volume to 55 litres. Changed min allowable application rate limit (Nozzle opening timing). Minor changes to fit SAS sw2.008"]
["1.3","2025-02-26"," Raised min. allowable application rate limit (Nozzle opening timing). Minor changes to fit SAS sw2.010"]
["1.4","2026-03-06"," Raised min. allowable application rate limit (Nozzle opening timing). Added min. value for info. Updated looks."]

{"sheet":"Data","index":3,"n_rows":6,"n_cols":4,"rows_kept":6,"hidden":true}
["Units","Spraytype","Nozzle spray angle","Nozzle spray angle"]
["","Spot Spray","TP250025",25]
["Milliliters","Band Spray","TP400025",40]
["Litres"]
["Grams"]
["Kilograms"]