{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["DOSE"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"DOSE","index":0,"n_rows":49,"n_cols":23,"rows_kept":49,"cut":false,"hidden":false,"merged":[[0,7,0,23],[30,3,30,5],[30,1,30,2],[26,7,26,10],[25,7,25,10],[0,0,0,5],[20,7,20,9],[21,3,21,5],[30,7,30,9],[3,0,3,1],[13,3,13,5],[15,3,15,5],[10,3,10,5],[12,3,12,5],[28,1,28,2],[25,0,25,1],[5,0,5,1],[7,0,7,1],[29,19,29,21],[9,1,9,5],[10,1,10,2],[12,1,12,2],[34,11,34,13],[34,15,34,17],[34,19,34,21],[36,3,36,5],[36,7,36,9],[36,11,36,13],[36,15,36,17],[36,19,36,21],[32,11,32,13],[8,0,8,2],[26,19,26,21],[28,19,28,21],[18,3,18,5],[26,0,26,1],[20,3,20,5],[19,3,19,5],[11,3,11,5],[19,7,19,8],[19,9,19,13],[21,7,21,8],[21,9,21,11],[19,1,21,1],[14,1,14,2],[16,1,16,5],[44,11,44,13],[44,15,44,17],[25,19,25,21],[25,11,25,13],[26,15,26,17],[28,15,28,17],[26,11,26,13],[28,11,28,13],[25,15,25,17],[32,15,32,17],[32,19,32,21],[29,15,29,17],[30,15,30,17],[30,11,30,13],[44,19,44,21],[29,11,29,13],[41,11,41,13],[41,15,41,17],[41,19,41,21],[40,3,40,5],[40,7,40,9],[40,11,40,13],[40,15,40,17],[40,19,40,21],[44,3,44,5],[44,7,44,9],[14,7,14,8],[28,3,28,5],[29,3,29,5],[29,7,29,9],[41,3,41,5],[41,7,41,9],[14,3,14,5],[32,3,32,5],[32,7,32,9],[34,3,34,5],[34,7,34,9],[12,22,12,23],[16,18,16,20],[41,0,41,2],[12,17,12,20],[14,17,14,20],[38,7,38,9],[38,11,38,13],[38,15,38,17],[38,19,38,21],[38,3,38,5],[30,19,30,21],[28,7,28,9],[32,1,32,2],[34,1,34,2],[36,1,36,2],[38,1,38,2]]}
["DOSE",null,null,null,null,null,null,"1.  Enter data on crop structure in the green cells (lines 1, 2 and 3) to allow the tool to calculate tCH, tLWA and tTRV of orchard. \n2.  Enter spray volume in yellow cell, either per ha ground (line 4) or per 10 000 m2 tLWA (line 5) to allow the tool to perform all conversions.\n3.  Click on one of the light grey buttons (line 6), to select the dose expression model to be converted.\n4.  Enter in the light red cell (line 7) the dose to be converted and press ENTER to get doses converted according to the other dose expression models."]
[null,"NOTE!  The tool is only intended to be used for dose conversion in relation to efficacy trials",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D15=\"\",\"(?)\",IF(D15<=0,\"(?)\",D15))","v":"(?)"}]
[]
["Select APPLICATION TECHNIQUE"]
[]
["Select CROP"]
[]
["Select GROWTH STAGE"]
[]
[null,"ENTER data on crop structure:"]
[1,"Treated Canopy Height - tCH [m]"]
[]
[2,"Row Spacing - R [m]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L27<=0,\"(?)\",IF(L27=\"CH<=0 !\",\"(?)\",IF(L27=\"\",\"(?)\",L27)))","v":"(?)"}]
[]
[3,"Mid-width of treated canopy - W [m]"]
[]
[null,"ENTER spray volume rate:",null,null,null,null,null,null,{"$f":"IF(D20>0,1,IF(D22>0,2,0))","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(D13=\"\",\"(?)\",IF(D13<=0,\"(?)\",D13))","v":"(?)"}]
[]
[]
[4," Spray Volume  ","[L/haGA]",null,null,null,"=",{"$f":"IF(D20=\"\",\"\",IF(D22>0,\"\",IF(D20<=0,\"Q_GA<=0 !\",IF(AND(I17=1,P27=\"\"),\"Enter crop data\",D20/P27*10000))))","v":""},null,"L/10 000 m2tLWA"]
[]
[5,null,"[L/10 000 m2tLWA]",null,null,null,"=",{"$f":"IF(D22=\"\",\"\",IF(D20>0,\"\",IF(D22<=0,\"Q_LWA<=0!\",IF(AND(I17=2,P27=\"\"),\"Enter crop data\",D22*P27/10000))))","v":""},null,"L/haGA"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"tCH\ntreated Canopy Height\n[m]\n",null,null,null,"tLWA\ntreated Leaf Wall Area\n[m2/ha]\n",null,null,null,"tTRV\ntreated Tree Row Volume\n[m3/ha]\n"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D11=\"\",\"\",IF(D11<=0,\"CH<=0 !\",D11))","v":""},null,null,null,{"$f":"IF(D11=\"\",\"\",IF(D11<=0,\"CH<=0 !\",IF(D13=\"\",\"\",IF(D13<=0,\"R<=0 !\",2*L27*10000/D13))))","v":""},null,null,null,{"$f":"IF(D11=\"\",\"\",IF(D11<=0,\"CH<=0 !\",IF(D15=\"\",\"\",IF(D13=\"\",\"\",IF(D13<=0,\"R<=0 !\",IF(D15<=0,\"W<=0 !\",IF(D15>=D13,\"W>=R !\",L27*D15*10000/D13)))))))","v":""}]
[]
["6","SELECT dose expression model to be converted (click on the button)",null,"Concentration      [%]",null,null,null,"Ground  Dose       [kg/ha]",null,null,null,"CH Dose    [kg/ha/mCH]",null,null,null,"LWA Dose [kg/10000m2LWA]",null,null,null,"TRV Dose [kg/10000m3TRV]"]
[]
["7","ENTER Concentration [%]",null,null,null,null,null,{"$f":"IF(D31=\"\",\"\",IF(AND(D31>=0,I17=0),\"Spray Volume not entered\",IF(AND(I17=2,D31>=0,P27=\"\"),\"Crop data not entered\",IF(I17=2,D31*D22*P27/1000000,IF(I17=1,D31*D20/100,\"\")))))","v":""},null,null,null,{"$f":"IF(D31=\"\",\"\",IF(AND(D31>=0,I17=0),\"Spray Volume not entered\",IF(L27=\"\",\"Crop data not entered\",IF(AND(I17=2,D31>=0,P27=\"\"),\"Crop data not entered\",IF(I17>0,H31/L27,\"\")))))","v":""},null,null,null,{"$f":"IF(D31=\"\",\"\",IF(AND(D31>=0,I17=0),\"Spray Volume not entered\",IF(AND(D31>=0,P27=\"\"),\"Crop data not entered\",IF(I17>0,H31/P27*10000,\"\"))))","v":""},null,null,null,{"$f":"IF(D31=\"\",\"\",IF(AND(D31>=0,I17=0),\"Spray Volume not entered\",IF(AND(D31>=0,T27=\"\"),\"Crop data not entered\",IF(I17>0,H31/T27*10000,\"\"))))","v":""}]
[]
["7","ENTER Ground Area Dose [kg or L/ha]",null,{"$f":"IF(H33=\"\",\"\",IF(AND(H33>=0,I17=0),\"Spray Volume not entered\",IF(AND(H33>=0,L27=\"\"),\"Crop data not entered\",IF(I17=2,H33*1000000/D22/P27,IF(I17=1,H33/D20*100,\"\")))))","v":""},null,null,null,null,null,null,null,{"$f":"IF(H33=\"\",\"\",IF(AND(H33>=0,I17=0),\"Spray Volume not entered\",IF(AND(H33>=0,L27=\"\"),\"Crop data not entered\",IF(I17>0,H33/L27,\"\"))))","v":""},null,null,null,{"$f":"IF(H33=\"\",\"\",IF(AND(H33>=0,I17=0),\"Spray Volume not entered\",IF(AND(H33>=0,P27=\"\"),\"Crop data not entered\",IF(I17>0,H33/P27*10000,\"\"))))","v":""},null,null,null,{"$f":"IF(H33=\"\",\"\",IF(AND(H33>=0,I17=0),\"Spray Volume not entered\",IF(AND(H33>=0,T27=\"\"),\"Crop data not entered\",IF(I17>0,H33/T27*10000,\"\"))))","v":""}]
[]
["7","ENTER tCH Dose [kg or L/ha/m tCH]",null,{"$f":"IF(L35=\"\",\"\",IF(L27=\"\",\"Crop data not enetered\",IF(AND(I17=2,P27=\"\"),\"Crop data not enetered\",IF(I17=0,\"Spray Volume not entered\",IF(I17=2,L35*L27*100/D22/P27*10000,L35*L27*100/D20)))))","v":""},null,null,null,{"$f":"IF(L35=\"\",\"\",IF(L27=\"\",\"Crop data not enetered\",L35*L27))","v":""},null,null,null,null,null,null,null,{"$f":"IF(L35=\"\",\"\",IF(P27=\"\",\"Crop data not enetered\",L35*D13/2))","v":""},null,null,null,{"$f":"IF(L35=\"\",\"\",IF(T27=\"\",\"Crop data not enetered\",L35*D13/D15))","v":""}]
[]
["7","ENTER tLWA Dose [kg or L/10 000m2 tLWA]",null,{"$f":"IF(P37=\"\",\"\",IF(P27=\"\",\"Crop data not enetered\",IF(AND(I17=2,P27=\"\"),\"Crop data not enetered\",IF(I17=0,\"Spray Volume not entered\",IF(I17=2,P37*P27/D22/P27*100,P37*P27/D20/100)))))","v":""},null,null,null,{"$f":"IF(P37=\"\",\"\",IF(P27=\"\",\"Crop data not enetered\",P37*P27/10000))","v":""},null,null,null,{"$f":"IF(P37=\"\",\"\",IF(P27=\"\",\"Crop data not enetered\",P37*P27/10000/L27))","v":""},null,null,null,null,null,null,null,{"$f":"IF(P37=\"\",\"\",IF(T27=\"\",\"Crop data not enetered\",P37*2/D15))","v":""}]
[]
["7","ENTER tTRV Dose [kg or L/10 000m3tTRV]",null,{"$f":"IF(T39=\"\",\"\",IF(T27=\"\",\"Crop data not enetered\",IF(AND(I17=2,P27=\"\"),\"Crop data not enetered\",IF(I17=0,\"Spray Volume not entered\",IF(I17=2,T39*T27/D22/P27*100,T39*T27/D20/100)))))","v":""},null,null,null,{"$f":"IF(T39=\"\",\"\",IF(T27=\"\",\"Crop data not enetered\",T39*T27/10000))","v":""},null,null,null,{"$f":"IF(T39=\"\",\"\",IF(T27=\"\",\"Crop data not enetered\",T39*T27/10000/L27))","v":""},null,null,null,{"$f":"IF(T39=\"\",\"\",IF(T27=\"\",\"Crop data not enetered\",T39*T27/P27))","v":""}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"1.  Enter data on crop structure in the green cells (lines 1, 2 and 3) to allow the tool to calculate tCH, tLWA and tTRV of orchard. "]
[null,null,null,null,null,null,null,null,null,null,null,"2.  Enter spray volume in yellow cell, either per ha ground (line 4) or per 10 000 m2 tLWA (line 5) to allow the tool to perform all conversions."]
[null,null,null,null,null,null,null,null,null,null,null,"3.  Click on one of the light grey buttons (line 6), to select the dose expression model to be converted."]
[null,null,null,null,null,null,null,null,null,null,null,"4.  Enter in the light red cell (line 7) the dose to be converted and press ENTER to get doses converted according to the other dose expression models."]