{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Evaluation","Dropdown menus"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":5,"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":"Evaluation","index":0,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,1,0,3],[1,1,1,3],[15,1,15,3]]}
[" ","NGIQ Dripper & Spray Stake Selection Tool"]
[null,"This tool calculates the Mean Application Rate (MAR) and appropriateness of a drip or spray stake irrigation system for the selected growing media and container size"]
[null,null,"Select values from dropdown menus in grey boxes","Warnings"]
[null,"Container size","Not Selected"]
[null,"Main growing media components","Not Selected"]
[null,"Growing media absorption rate - mm/hr",{"$f":"IF(OR(C5=\"Not Selected\",C5=0),\"Insufficient data\",VLOOKUP(C5,'Dropdown menus'!H3:I17,2,FALSE))","v":"Insufficient data"}]
[null,"Emitter type","Not Selected"]
[null,"Emitter discharge rate - L/hr","Not Selected"]
[null,"Number of arrows per dripper (select 1 for spray stakes)","Not Selected"]
[null,"Arrows per container (select 1 for spray stakes if one per container)","Not Selected",{"$f":"IF(C7=\"Spray stake\",\"\",IF(VLOOKUP(Evaluation!C4,'Dropdown menus'!A2:D22,2,FALSE)<=Evaluation!C10,\"\",\"The number of arrows per container is less than recommended for this container size. Sufficient lateral movement of water will not occur and not all of the growing media will be irrigated.\"))","v":""}]
[null,"Arrows or spray stakes per container required",{"$f":"IF(C7=\"Spray Stake\",1,IF(C4=\"Not selected\",\"Insufficient data\",VLOOKUP(C4,'Dropdown menus'!A2:B22,2,FALSE)))","v":"Insufficient data"},{"$f":"IF(C10<C11,\"This is the minimum number of arrows required per container to achieve sufficient lateral movement within the growing media\",\"\")","v":""}]
[null,"Number of containers per dripper",{"$f":"IF(OR(C9=\"not selected\",C10=\"not selected\"),\"Insufficient data\",C9/C10)","v":"Insufficient data"}]
[null,"Flow rate per arrow - L/hr",{"$f":"IF(C12=\"Insufficient data\", \"Insufficient data\",C8/C9)","v":"Insufficient data"},{"$f":"(IF(C13<0.5,\"Dripper discharge rate is insufficient for uniform distribution. Increase dripper discharge rates or decrease arrows/dripper to provide a minimum of 0.5L/hr for each arrow.\",\"\"))","v":""}]
[null,"Mean Application Rate (MAR) - mm/hr",{"$f":"IF(C5=\"Not selected\",\"Insufficient data\",IF(C5=\"\",\"Insufficient data\",IF(C12=\"Insufficient data\",\"Insufficient data\",C8/(VLOOKUP(C4,'Dropdown menus'!A2:D22,4,FALSE)*C12))))","v":"Insufficient data"},{"$f":"IF(C13=\"Insufficient data\",\"\",IF(C14>25,\"This mean application rate (MAR) exceeds the rate normally regarded as an acceptable maximum within the industry (25 mm/hr).\",IF(C14>C6,\"Warning: This mean application rate (MAR) exceeds the absorption rate of the growing media selected.\",\"\")))","v":""}]
[]
[null,"Except as required by law and only to the extent so required the Nursery & Garden Industry Queensland provides no warranty, express or implied, as to, or shall in any way be liable (including liability in negligence) directly or indirectly for any loss, damages, costs, expenses or reliance arising out of or in connection with, the accuracy, currency, completeness or balance of (or otherwise), or any errors in or omissions from, any test results, recommendations statements or other information provided to you."]
[]
[]
[null,null,null,null,1]

{"sheet":"Dropdown menus","index":1,"n_rows":102,"n_cols":12,"rows_kept":102,"cut":false,"hidden":false,"merged":[]}
["Container size",null,null,null,"Arrows per container","Dripper discharge rate","Arrows per dripper","Growing media","MAR",null,"Emitter type"]
["Not Selected","arrows/container allowed","diam (mm)","Area (m2)","Not Selected","Not Selected","Not Selected","Not Selected","MAR","Not Selected","Not Selected","Old MAR rate from original calculator"]
["100 mm diam.",1,100,{"$f":"PI()*(C3*0.001/2)^2","v":7.8539816339744835E-3},1,0.5,1,"Bark 100%",15,1,"Dripper ",10]
["140 mm diam.",1,140,1.5393804002589988E-2,2,1,2,"Bark 85% + Sand 15%",15,2,"Spray Stake",10]
["150 mm diam.",1,150,1.7671458676442587E-2,3,1.2,4,"Bark 100% + Wetting Agent",20,3,null,15]
["175 mm diam.",1,175,2.405281875404686E-2,4,1.5,6,"Bark 85% + Sand 15% + Wetting Agent",20,4,null,15]
["200 mm diam.",1,200,3.1415926535897934E-2,5,2,8,"Bark 75% + Sand 15% + Coir 10%",20,5,null,20]
["220 mm diam.",2,220,3.8013271108436497E-2,6,2.5,10,"Bark 50% + Coir 50%",20,6,null,20]
["250 mm diam.",2,250,4.9087385212340517E-2,7,3,12,"Coir 100%",25,7,null,25]
["300 mm diam.",2,300,7.0685834705770348E-2,8,4,14,null,null,8]
["330 mm diam.",2,330,8.5529859993982132E-2,9,6,16,null,null,9]
["350 mm diam.",4,350,9.6211275016187439E-2,10,8,18,null,null,10]
["4 L bag",1,122,1.168986626400762E-2,12,10,20,null,null,11]
["25 L bag",2,330,8.5529859993982132E-2,14,12,22,null,null,12]
["45 L bag",4,370,0.10752100856911066,16,14,24,null,null,13]
["75 L bag",4,450,0.15904312808798329,18,16,26,null,null,14]
["100 L bag",4,500,0.19634954084936207,20,18,28,null,null,15]
["200 L bag",4,650,0.33183072403542191,22,20,30,null,null,16]
["300 L bag",6,820,0.52810172506844433,24,22,null,null,null,17]
["400 L bag",8,950,0.70882184246619717,26,24,null,null,null,18]
["500 L bag",8,970,0.73898113194065906,28,26,null,null,null,19]
["1000 L bag",20,1450,1.6512996385431351,30,28,null,null,null,20]
[null,null,null,null,null,30,null,null,null,21]
[null,null,null,{"$f":"D19/$D$18*4","v":6.3659171597633151},null,35,null,null,null,22]
[null,null,null,{"$f":"D20/$D$18*4","v":8.5443786982248522},null,40,null,null,null,23]
[null,null,null,8.9079289940828392,null,45,null,null,null,24]
[null,null,null,{"$f":"D22/$D$18*4","v":19.905325443786982},null,50,null,null,null,25]
[null,"Based on 200 mm","Based on 330 mm ","Based on 350 mm","Based on 200 L ",60,null,null,null,26]
["For 300 L bag",16.810000000000002,12.348943985307622,21.955918367346939,6.3659171597633151,70,null,null,null,27]
["For 400 L bag",22.5625,16.574839302112029,29.469387755102037,8,80,null,null,null,28]
["For 500 L bag",23.522499999999997,17.280073461891639,30.723265306122439,8,90,null,null,null,29]
["For 1000 L bag",52.5625,38.613406795224975,68.653061224489775,19.905325443786982,100,null,null,null,30]
[null,null,null,null,null,110,null,null,null,31]
[null,null,null,null,null,120,null,null,null,32]
[null,null,null,null,null,130,null,null,null,33]
[null,null,null,null,null,140,null,null,null,34]
[null,null,null,null,null,150,null,null,null,35]
[null,null,null,null,null,null,null,null,null,36]
[null,null,null,null,null,null,null,null,null,37]
[null,null,null,null,null,null,null,null,null,38]
[null,null,null,null,null,null,null,null,null,39]
[null,null,null,null,null,null,null,null,null,40]
[null,null,null,null,null,null,null,null,null,41]
[null,null,null,null,null,null,null,null,null,42]
[null,null,null,null,null,null,null,null,null,43]
[null,null,null,null,null,null,null,null,null,44]
[null,null,null,null,null,null,null,null,null,45]
[null,null,null,null,null,null,null,null,null,46]
[null,null,null,null,null,null,null,null,null,47]
[null,null,null,null,null,null,null,null,null,48]
[null,null,null,null,null,null,null,null,null,49]
[null,null,null,null,null,null,null,null,null,50]
[null,null,null,null,null,null,null,null,null,51]
[null,null,null,null,null,null,null,null,null,52]
[null,null,null,null,null,null,null,null,null,53]
[null,null,null,null,null,null,null,null,null,54]
[null,null,null,null,null,null,null,null,null,55]
[null,null,null,null,null,null,null,null,null,56]
[null,null,null,null,null,null,null,null,null,57]
[null,null,null,null,null,null,null,null,null,58]
[null,null,null,null,null,null,null,null,null,59]
[null,null,null,null,null,null,null,null,null,60]
[null,null,null,null,null,null,null,null,null,61]
[null,null,null,null,null,null,null,null,null,62]
[null,null,null,null,null,null,null,null,null,63]
[null,null,null,null,null,null,null,null,null,64]
[null,null,null,null,null,null,null,null,null,65]
[null,null,null,null,null,null,null,null,null,66]
[null,null,null,null,null,null,null,null,null,67]
[null,null,null,null,null,null,null,null,null,68]
[null,null,null,null,null,null,null,null,null,69]
[null,null,null,null,null,null,null,null,null,70]
[null,null,null,null,null,null,null,null,null,71]
[null,null,null,null,null,null,null,null,null,72]
[null,null,null,null,null,null,null,null,null,73]
[null,null,null,null,null,null,null,null,null,74]
[null,null,null,null,null,null,null,null,null,75]
[null,null,null,null,null,null,null,null,null,76]
[null,null,null,null,null,null,null,null,null,77]
[null,null,null,null,null,null,null,null,null,78]
[null,null,null,null,null,null,null,null,null,79]
[null,null,null,null,null,null,null,null,null,80]
[null,null,null,null,null,null,null,null,null,81]
[null,null,null,null,null,null,null,null,null,82]
[null,null,null,null,null,null,null,null,null,83]
[null,null,null,null,null,null,null,null,null,84]
[null,null,null,null,null,null,null,null,null,85]
[null,null,null,null,null,null,null,null,null,86]
[null,null,null,null,null,null,null,null,null,87]
[null,null,null,null,null,null,null,null,null,88]
[null,null,null,null,null,null,null,null,null,89]
[null,null,null,null,null,null,null,null,null,90]
[null,null,null,null,null,null,null,null,null,91]
[null,null,null,null,null,null,null,null,null,92]
[null,null,null,null,null,null,null,null,null,93]
[null,null,null,null,null,null,null,null,null,94]
[null,null,null,null,null,null,null,null,null,95]
[null,null,null,null,null,null,null,null,null,96]
[null,null,null,null,null,null,null,null,null,97]
[null,null,null,null,null,null,null,null,null,98]
[null,null,null,null,null,null,null,null,null,99]
[null,null,null,null,null,null,null,null,null,100]