{"text_format":"1","workbook":"xlsx","n_sheets":28,"sheets":["ENT","Dom","Com","SYS","SepDom","SepCom","Hol","Atu","Wtp","Evap","Toi","Gry","Roo","Wor","SITE","DISP","Lea","LeaClay","IrD","IrC","Bed","Tre","Mou","Soa","Aes","Fil","LAY","LAYIrr"],"not_rendered":{"charts":0,"images":21,"macros":1,"external_links":0,"defined_names":3,"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":"row_number_cap","date_system":"1900"}

{"sheet":"ENT","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[[30,1,30,4]],"read":"row_number_cap"}

{"sheet":"Dom","index":1,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,"Bedrooms","Combined"]
[null,null,null,null,null,null,null,1,564]
[null,null,null,null,null,null,null,2,564]
[null,null,null,null,null,null,null,3,761]
["Total number of bedrooms for dwelling",null,"bedrooms",null,null,null,null,4,829]
[{"$f":"IF(B5>5, \"Maximum number of occupants for dwelling\",\"\")","v":""},null,{"$f":"IF(B5>5, \"persons\",\"\")","v":""},null,null,null,null,5,829]
["Total daily hydraulic loading",{"$f":"IF(B5=\"\",\"\",IF(B5<6,(VLOOKUP(B5,H1:I6,2,FALSE)),IF(B6=\"\",\"\",IF(B6<6,829,B6*150))))","v":""},"L/day",null,null,null,null,6]
[null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,10]

{"sheet":"Com","index":2,"n_rows":24,"n_cols":21,"rows_kept":24,"cut":false,"hidden":false,"merged":[[14,2,14,5]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Commercial","Combined","Combined","Black","Grey"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Public Building (frequent use)",30,"30 L/person/day",15,{"$f":"R2-T2","v":15}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Public Building (infrequent use)",10,"10 L/person/day",5,{"$f":"R3-T3","v":5}]
[null,"Type of premises / use","Hydraulic loading","Loading","Number of \npersons / dwelling","Total loading for \npremises / use (L/day)",null,null,null,null,null,null,null,null,null,null,"Factories & Shops ",70,"70 L/person/day",45,{"$f":"R4-T4","v":25}]
[null,null,{"$f":"VLOOKUP(B5,Q:S,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(B5,Q$2:T$1048576,2,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"IF(E5=\"\",\"\",D5*E5)","v":""},null,null,null,null,null,null,null,null,null,null,"Additional Wastewater - Food Production",1,"Enter Volume (L/day) >>>"]
[null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF(E6=\"\",\"\",D6*E6)","v":""},null,null,null,null,null,null,null,null,null,null,"Aged Home Accomodation - 2 bedroom unit",564,"564 L/dwelling"]
[null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,"",null,null,null,null,null,null,null,null,null,null,"Aged Home Accomodation - 3 bedroom unit",761,"761 L/dwelling"]
[null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,"",null,null,null,null,null,null,null,null,null,null,"Aged Home Accomodation - 4/5 bedroom unit",829,"829 L/dwelling"]
[null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,"",null,null,null,null,null,null,null,null,null,null,"Aged Home Accomodation - Communal System",150,"150L/person/day"]
[null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,"",null,null,null,null,null,null,null,null,null,null,"Caravan Park - 3 persons / bay",140,"140 L/person/day",90,{"$f":"R10-T10","v":50}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Caravan Park - 2 bedroom park home/chalet",564,"564 L/dwelling"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Caravan Park - 3 bedroom park home/chalet",761,"761 L/dwelling"]
[null,"Total daily hydraulic loading",{"$f":"SUM(F5:F10)","v":0},null,"L/day",null,null,null,null,null,null,null,null,null,null,null,"Caravan Park - 4 bedroom park home/chalet",829,"829 L/dwelling"]
[null,"Proposed total daily loading (if any)",null,null,"L/day",null,null,null,null,null,null,null,null,null,null,null,"Camping Grounds - 2 persons / tent site",140,"140 L/person/day",90,{"$f":"R14-T14","v":50}]
[null,null,{"$f":"IF(C14=\"\",\"\",IF(C14<C13,\"The proposed loading rate is less than the loading rate prescribed under the Regulations. Proposed system might be undersized. Proceed to next step to verify.\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"Clubs",15,"15 L/person/day",10,{"$f":"R15-T15","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clubs (Licensed)",35,"35 L/person/day",25,{"$f":"R16-T16","v":10}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hotel",180,"180 L/person/day",90,{"$f":"R17-T17","v":90}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minesite Accomodation Camp",180,"180 L/person/day",90,90]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Motel",140,"140 L/person/day",70,{"$f":"R19-T19","v":70}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"School (boarding)",140,"140 L/person/day",70,70]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"School (day)",45,"45 L/person/day",30,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Swimming Pool",15,"15 L/person/day",10,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drive in theatres (2 persons / car)",10,"10 L/person/day",10,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Construction Camps (temporary)",45,"45 L/person/day",25,20]

{"sheet":"SYS","index":3,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[{"$f":"Dom!B5","v":0}]

{"sheet":"SepDom","index":4,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[8,1,8,2],[4,1,4,2],[5,1,5,2],[0,1,0,2]]}
[null,"Domestic Septic Tanks"]
[]
[null,"Total number of bedrooms",{"$f":"Dom!B5","v":0}]
[null,"Total septic tank volume required",{"$f":"IF(C3>5,((C3*270)+1820),3180)","v":3180},"L"]
[null,{"$f":"IF(C4=3180,\"Standard 1500mm and 1200mm septic tanks adequate.\",\"\")","v":"Standard 1500mm and 1200mm septic tanks adequate."}]
[null,{"$f":"IF(C4=3180,\"OR\",\"\")","v":"OR"}]
[null,"Single baffled tank system"]
[null,"Baffled septic tank volume required",{"$f":"C4","v":3180},"L"]
[null,{"$f":"IF(C4=3180,\"\",\"OR\")","v":""}]
[null,{"$f":"IF(C4=3180,\"\",\"Dual tanks system\")","v":""}]
[null,{"$f":"IF(C4=3180,\"\",\"Primary tank volume required\")","v":""},{"$f":"IF(C4=3180,\"\",C4*2/3)","v":""},{"$f":"IF(C4=3180,\"\",\"L\")","v":""}]
[null,{"$f":"IF(C4=3180,\"\",\"Secondary tank volume required\")","v":""},{"$f":"IF(C4=3180,\"\",C4/3)","v":""},{"$f":"IF(C4=3180,\"\",\"L\")","v":""}]
[]
[]
[]
[null,"Does proposed septic tanks meet requirements?",null,{"$f":"IF(C16=\"No\",\"Contact applicant to upgrade tanks\",\"\")","v":""}]

{"sheet":"SepCom","index":5,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[8,1,8,2],[0,1,0,2]]}
[null,"Commercial Septic Tanks"]
[]
[null,"Daily Hydraulic Loading ",{"$f":"MAX(Com!C13,Com!C14)","v":0},"L/day"]
[null,"Total septic tank volume required",{"$f":"C3+1820","v":1820},"L"]
[]
[null,"Dual tanks system"]
[null,"Primary tank volume required",{"$f":"C4*2/3","v":1213.3333333333333},"L"]
[null,"Secondary tank volume required",{"$f":"C4/3","v":606.66666666666663},"L"]
[null,"OR"]
[null,"Single baffled tank system"]
[null,"Baffled septic tank volume required",{"$f":"C4","v":1820},"L"]
[]
[]
[]
[null,"Does proposed septic tanks meet requirements?",null,{"$f":"IF(C15=\"No\",\"Contact applicant to upgrade tanks\",\"\")","v":""}]

{"sheet":"Hol","index":6,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2]]}
[null,"Holding Tanks"]
[]
[null,"Daily Hydraulic Loading",{"$f":"MAX(Com!C13,Com!C14)","v":0},"L"]
[null,"Proposed septic tank volume",null,"L"]
[]
[]
[]
[null,"Minimum pump out frequency",{"$f":"ROUNDDOWN(C4/C3,0)","v":{"$error":"#DIV/0!"}},"days"]
[]
[null,"Controls and management requirements met?"]
[null,{"$f":"\"Confirmation received from licensed waste contractor that pump outs can be undertaken every \"&ROUNDDOWN(C8,0)&\" day(s).\"","v":{"$error":"#DIV/0!"}},null,null,{"$f":"IF(D11=\"No\",\"Formal confirmation from \nlicensed waste required.\",\"\")","v":""}]
[null,"High water level alarms in place",null,null,{"$f":"IF(D12=\"No\",\"High water level alarms required.\",\"\")","v":""}]
[null,"Maximum length of use is less than 12 months",null,null,{"$f":"IF(D13=\"No\",\"Holding tanks only approved for a maximum use of 12 months.\",\"\")","v":""}]

{"sheet":"Atu","index":7,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,"Aerobic Treatment Units"]
[null,"Daily hydraulic loading",{"$f":"MAX(Dom!B7,Com!C13,Com!C14)","v":0},"L/day"]
[null,"Refering to the approved listing, is the proposed system certified to cater for the daily hydraulic loading?",null,{"$f":"IF(C3=\"No\",\"Aerobic Treatment Unit / Wastewater Treatment Plant with larger hydraulic capacity required.\",\"\")","v":""}]
[null,"Is the treated sewage able to meet the following nutrient targets: <1mg/L Phosphorus; <10mg/L Nitrogen?"]

{"sheet":"Wtp","index":8,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,2],[2,1,2,2]]}
[null,"Wastewater Treatment Plants"]
[null,"Daily hydraulic loading",{"$f":"MAX(Dom!B7,Com!C13,Com!C14)","v":0},"L/day"]
[null,"Engineering certification for the WWTP is required. \nHave the following certification documents been provided:"]
[null,"Is the WWTP certified to be able to produce secondary treated effluent quality? (BOD<20mg/L; TSS<30mg/L)",null,{"$f":"IF(C4=\"No\",\"Required\",\"\")","v":""}]
[null,"Is the WWTP certified to be able to meet the following nutrient targets: <1mg/L Phosphorus; <10mg/L Nitrogen?",null,{"$f":"IF(C5=\"No\",\"Proceed to next section to determine if required.\",\"\")","v":""}]
[null,"Is the WWTP certified to be able to produce treated effluent with <10cfu/100mL E. coli AND FAC >0.5mg/L?",null,{"$f":"IF(C6=\"No\",\"Disposal method must be of a method/location where there are no potential contact with public/personnel onsite.\",\"\")","v":""}]
[null,"Structural design certification for all tanks and chambers.",null,{"$f":"IF(C7=\"No\",\"Required\",\"\")","v":""}]
[null,"Hydraulic loading capacity indicating peak and average flow rate volumes.",null,""]
[null,"Minimum of 15 serviceable life years.",null,""]
[null,"Proof of current professional indemnity insurance coverage for the design works.",null,""]
[null,"Proof of engineer's qualification accreditation with Engineers Australia",null,""]

{"sheet":"Evap","index":9,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,1,0,2],[2,1,2,2]]}
[null,"Evaporation Ponds"]
[null,"Daily hydraulic loading",{"$f":"MAX(Dom!B7,Com!C13,Com!C14)","v":0},"L/day"]
[null,"Engineering certification for the evaporation ponds is required. \nHave the following information been provided:"]
[null,"Pre-treatment requirements before discharge into ponds.",null,{"$f":"IF(C4=\"No\",\"Required\",\"\")","v":""}]
[null,"Water balance calculations.",null,{"$f":"IF(C5=\"No\",\"Required\",\"\")","v":""}]
[null,"Evaporation ponds dimensions and design specifications.",null,""]
[null,"Formal certification of the hydraulic loading capacity for the ponds.",null,""]
[null,"Proof of current professional indemnity insurance coverage for the design works.",null,""]
[null,"Proof of engineer's qualification accreditation with Engineers Australia",null,""]

{"sheet":"Toi","index":10,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,"Waterless Toilets"]
[null,"Is the lot  size a minimum of 1000m2?",null,{"$f":"IF(C2=\"No\",\"Composting toilets not suitable for use at this location.\",\"\")","v":""}]
[null,"Is the system for continuous OR Weekend/Vacation use?"]
[null,"If there are multiple systems have applicant provide information on how the use of the systems will be evenly distributed?",null,{"$f":"IF(C4=\"No\",\"Further confirmation from applicant required.\",\"\")","v":""}]
[null,"Refering to the approved listing, is the proposed system certified to cater for the maximum daily occupancy?",null,{"$f":"IF(C5=\"No\",\"Advice applicant to pick an approved system from the DOH listing.\",\"\")","v":""}]
[null,"Is/Will there be an onsite system where the greywater generated onsite will be disposed?",null,{"$f":"IF(C6=\"No\",\"Greywater treatment and disposal system required.\",\"\")","v":""}]
[null,"Have the proposed installation cover all aspects detailed on the product approval?",null,{"$f":"IF(C7=\"No\",\"Advice applicant on non-compliances and amend application where required.\",\"\")","v":""}]

{"sheet":"Gry","index":11,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,"Greywater System"]
[null,"What type of greywater system is proposed?",null,{"$f":"IF(AND(C2=\"Greywater Diversion Device\",Com!C13>0),\"Greywater Diversion Devices not permitted in commercial installations.\",\"\")","v":""}]
[null,"Is the greywater system on the DOH approved listing?",null,{"$f":"IF(C3=\"No\",\"Advice applicant to pick an approved system from the DOH listing.\",\"\")","v":""}]

{"sheet":"Roo","index":12,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,"Rootzone"]
[null,"System approved for single dwelling units up to 8 persons OR non-residential developments with wastewater flow of up to 1200L/day.",{"$f":"IF(OR(AND(Dom!B5>0,Dom!B5<6),AND(Dom!B5>0,Dom!B7<1201),AND(Com!C13>0,MAX(Com!C13:C14)<1201)),\"Compliant\",\"Not Compliant\")","v":"Not Compliant"},{"$f":"IF(AND(C2=\"Greywater Diversion Device\",Com!C13>0),\"Greywater Diversion Devices not permitted in commercial installations.\",\"\")","v":""}]
[null,"Have the proposed installation cover all aspects detailed on the product approval?",null,{"$f":"IF(C3=\"No\",\"Advice applicant on non-compliances and amend application where required.\",\"\")","v":""}]

{"sheet":"Wor","index":13,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,"Wormsmart"]
[null,"System approved for single dwelling units up to 10 persons OR non-residential developments with wastewater flow of up to 1800L/day.",{"$f":"IF(OR(AND(Dom!B5>0,Dom!B5<6),AND(Dom!B5>0,Dom!B7<1801),AND(Com!C13>0,MAX(Com!C13:C14)<1801)),\"Compliant\",\"Not Compliant\")","v":"Not Compliant"},{"$f":"IF(AND(C2=\"Greywater Diversion Device\",Com!C13>0),\"Greywater Diversion Devices not permitted in commercial installations.\",\"\")","v":""}]
[null,"Have the proposed installation cover all aspects detailed on the product approval?",null,{"$f":"IF(C3=\"No\",\"Advice applicant on non-compliances and amend application where required.\",\"\")","v":""}]

{"sheet":"SITE","index":14,"n_rows":21,"n_cols":34,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Site Conditions",null,null,null,null,null,null,null,null,null,null,null,"Soil","Flat - 10%",null,null,"Non-Pdwsa-Primary","Non-Pdwsa-Secondary","PDWSA","SSA",null,"Sand",">3.0",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"IF(C3=W1,X1,IF(C3=W2,X2,IF(C3=W3,X3,IF(C3=W4,X4,IF(C3=W5,X5,IF(C3=W6,X6,\"\"))))))","v":""},null,null,"Soil","Design Loading Rate","Design Irrigation Rate","DLR - Secondary","Mound"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Sand","10 - 20%",null,"Sand",1.5,0.6,2,1.5,null,"Gravel",">3.0",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"IF(C3=W1,Y1,IF(C3=W2,Y2,IF(C3=W3,Y3,IF(C3=W4,Y4,IF(C3=W5,Y5,IF(C3=W6,Y6,\"\"))))))","v":""},null,null,"Sand",30,5,50,32]
[null,"Soil type",null,{"$f":"IF(OR(AND(C3=\"Light Clay\",C4=\"<0.06\"),C3=\"Medium / \nHeavy Clay\"),\"Primary treatment systems are not suitable for this soil type. Consider secondary treatment systems  or ETA/ETS beds.\",\"\")","v":""},{"$f":"IF(F3=\"Yes\",VLOOKUP(C3,Q:S,3,FALSE),VLOOKUP(C3,Q:S,2,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(Atu!C3=\"Yes\",Atu!C4,IF(Wtp!C4=\"Yes\",Wtp!C5))","v":false},null,null,null,null,null,null,null,"Gravel","20 - 30%",null,"Gravel",1,0.6,2,1.5,null,"Loam","1.5-3.0","0.5-1.5",{"$f":"\"\"","v":""},{"$f":"IF(C3=W1,Z1,IF(C3=W2,Z2,IF(C3=W3,Z3,IF(C3=W4,Z4,IF(C3=W5,Z5,IF(C3=W6,Z6,\"\"))))))","v":""},null,null,"Sand>3.0",30,5,50,32]
[null,"Indicative permeability of constant head - soil permeability test (Ksat)(m/d) - if known",null,null,{"$f":"C3&C4","v":""},null,null,null,null,null,null,null,null,"Loam",">30%",null,"Loam",0.6,0.6,2,1.5,null,"Clay loam","0.5-1.5","0.12-0.5","0.06-0.12",null,null,null,"Gravel",20,5,50,32]
[null,{"$f":"IF(OR(Atu!C3=\"Yes\",Wtp!C4=\"Yes\",Roo!C3=\"Yes\",Wor!C3=\"Yes\"),\"DLR - Trenches/Beds/Leach Drains (mm/day)\nDIR - Irrigation (mm/day)\",\"Design Loading Rate (mm/day)\")","v":"Design Loading Rate (mm/day)"},{"$f":"IF(OR(Atu!C3=\"Yes\",Wtp!C4=\"Yes\",Roo!C3=\"Yes\",Wor!C3=\"Yes\"),SITE!AG21&\"\n\"&SITE!AF21,SITE!AE21)","v":{"$error":"#N/A"}},{"$f":"IF(C5=\"Not Suitable\",\"Primary treatment system is not suitable for this soil type. Consider secondary treatment systems  or ETA/ETS beds.\",\"\")","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"Clay loam",null,null,"Clay loam",0.6,0.6,2,1.5,null,"Light clay","0.12-0.5","0.06-0.12","<0.06",null,null,null,"Gravel>3.0",20,5,50,32]
[null,"Is the land application area installed on imported fill that is different from the native soil type?",null,{"$f":"IF(C6=\"Yes\",\"Sizing of disposal system must be based on native soil type.\",\"\")","v":""},null,null,null,null,null,null,null,null,null,"Light clay",null,null,"Light clay",0.6,0.6,2,1.5,null,"Medium / \nHeavy Clay","0.06-0.5","<0.06",{"$f":"\"\"","v":""},null,null,null,"Loam",20,4,50,24]
[null,"Slope of land application area (%)",null,{"$f":"IF(OR(C7=\"1:4\",C7=\"1:3.3\",C7=\"1:2.9\",C7=\"1:2.5\"),\"Land application area should be engineered to prevent run-off.\",\"\")","v":""},null,null,null,null,null,null,null,null,null,"Medium / \nHeavy Clay",null,null,"Medium / \nHeavy Clay",0.6,0.6,2,1.5,null,null,null,null,null,null,null,null,"Loam1.5-3.0",20,4,50,24]
[null,"Is the land application area located in a Public Drinking Water Source Area?",null,{"$f":"IF(C8=\"Yes\",\"Minimum setback distance of 2 metres between groundwater to the discharge point of the disposal system required by GSP.\",\"\")","v":""},{"$f":"IF(C8=\"Yes\",2,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Loam0.5-1.5",15,4,30,16]
[null,"Is the land application area located in a Sewage Sensitive Area?",null,{"$f":"IF(C9=\"Yes\",\"Minimum setback distance of 1.5 metres between groundwater to the discharge point of the disposal system required by GSP.\",\"\")","v":""},{"$f":"IF(C9=\"Yes\",1.5,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clay loam",15,3.5,30,16]
[null,"Depth of natural ground level to highest known permanent/seasonal or tidal water table (metres)",null,{"$f":"IF(AND(F3=\"No\",E8=0,E9=0,E3>0.6),\"A minimum setback distance of \"&E10&\" metres between groundwater to the discharge point of the disposal system required by GSP. Setback distance can be reduced to 0.6 metres with a secondary treatment system capable of nutrient removal.\",\"A minimum setback distance of \"&E10&\" metres between groundwater to the discharge point of the disposal system required by GSP.\")","v":{"$error":"#N/A"}},{"$f":"MAX(E3,E8,E9)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clay loam0.5-1.5",15,3.5,30,16]
[null,"Is land application area suceptible to stormwater intrusion?",null,{"$f":"IF(C11=\"Yes\",\"Interception drains / stormwater diversion drains are required to divert stormwater away from land application area\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clay loam0.12-0.5",10,3.5,20,8]
[null,"Is the land application area located outside the 1:10 year flood zone?",null,{"$f":"IF(C12=\"No\",\"Land application area needs to be relocated outside the 1:10 year flood zone.\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clay loam0.06-0.12",5,3.5,10,5]
[null,"Minimum of 600mm adsorption zone achievable?",null,{"$f":"IF(C13=\"No\",\"Site modification OR relocation of land application area is required.\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Light clay",8,3,12,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Light clay0.12-0.5",8,3,12,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Light clay0.06-0.12",5,3,10,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Light clay<0.06","Not Suitable",3,8,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Medium / \nHeavy Clay","Not Suitable",2,"Not Suitable",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Medium / \nHeavy Clay0.06-0.5","Not Suitable",2,"Not Suitable",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Medium / \nHeavy Clay<0.06","Not Suitable",2,"Not Suitable",5]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(E4,AD1:AF19,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E4,AD1:AF19,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E4,AD1:AG19,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E4,AD1:AH19,5,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"DISP","index":15,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Disposal Systems"]
[]
[{"$f":"IF(OR(SITE!C3=\"Light Clay\",SITE!C3=\"Medium / \nHeavy Clay\"),1,\"\")","v":""}]
[{"$f":"Dom!B5","v":0}]

{"sheet":"Lea","index":16,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,"Leach Drains"]
[null,"Soil Type",{"$f":"SITE!C3","v":0},{"$f":"IF(C4=\"Not Suitable\",\"Leach drains are not suitable for this soil type. Consider secondary treatment systems  or ETA/ETS beds.\",\"\")","v":{"$error":"#N/A"}}]
[null,"Daily Hydraulic Loading ",{"$f":"MAX(Dom!B7,Com!C13,Com!C14)","v":0},"L/day"]
[null,"Design Loading Rate of Soils",{"$f":"IF(OR(Atu!C3=\"Yes\",Wtp!C4=\"Yes\",Roo!C3=\"Yes\",Wor!C3=\"Yes\"),SITE!AG21,SITE!AE21)","v":{"$error":"#N/A"}},"L/m2/day"]
[null,"Referring to the approved listing, what is the prescribed infiltrative area for the leach drain?",null,"m2/m"]
[null,"Total length of leach drains required",{"$f":"IF(C4=\"Not Suitable\",\"Not Suitable\",C3/C4/C5)","v":{"$error":"#N/A"}},"m"]
[null,"Recommended layout",{"$f":"IF(C4=\"Not Suitable\",\"Not Suitable\",EVEN(C6/20) & \" x \"& ROUND(C6/EVEN(C6/20),1))","v":{"$error":"#N/A"}},"m"]
[null,"Confirm that the top of the leach drain is not more than 300mm from the finished surface level.",null,{"$f":"IF(C8=\"No\",\"The topsoil for the leach drain must not be more than 300mm.\",\"\")","v":""}]
[null,"Inverted?"]

{"sheet":"LeaClay","index":17,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,"Leach Drains"]
[null,"Soil Type",{"$f":"SITE!C3","v":0},{"$f":"IF(C4=\"Not Suitable\",\"Leach drains are not suitable for this soil type. Consider secondary treatment systems  or ETA/ETS beds.\",\"\")","v":{"$error":"#N/A"}}]
[null,"Daily Hydraulic Loading ",{"$f":"MAX(Dom!B7,Com!C13,Com!C14)","v":0},"L/day"]
[null,"Design Loading Rate of Soils",{"$f":"IF(OR(Atu!C3=\"Yes\",Wtp!C4=\"Yes\",Roo!C3=\"Yes\",Wor!C3=\"Yes\"),SITE!AG21,SITE!AE21)","v":{"$error":"#N/A"}},"L/m2/day"]
[null,"Referring to the approved listing, what is the prescribed infiltrative area for the leach drain?",null,"m2/m"]
[]
[]
[null,null,"é"]
[null,"Enter width of the fill >>>>>>>>>>>>>>>>>>>>>>>>>>",null,"m"]
[null,"Total length of leach drains required",{"$f":"IF(C4=\"Not Suitable\",\"Not Suitable\",C3/C4/IF(C9>4,4,C9))","v":{"$error":"#N/A"}},"m"]
[null,"Recommended layout",{"$f":"IF(C4=\"Not Suitable\",\"Not Suitable\",EVEN(C10/22) & \" x \"& ROUND(C10/EVEN(C10/22),1))","v":{"$error":"#N/A"}},"m"]
[null,"Confirm that the top of the leach drain is not more than 300mm from the finished surface level.",null,{"$f":"IF(C12=\"No\",\"The topsoil for the leach drain must not be more than 300mm.\",\"\")","v":""}]
[null,"Inverted?"]

{"sheet":"IrD","index":18,"n_rows":7,"n_cols":12,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,"Irrigation System",null,null,null,"Flat - 10%",1,1,null,"Bedroom","surface","sub"]
[null,"Soil Type",{"$f":"SITE!C3","v":0},null,null,"10 - 20%",0.8,1.2,"DIR reduced by 20% due to installation on sloping area.",1,60,60]
[null,"Daily Hydraulic Loading ",{"$f":"Dom!B7","v":""},null,null,"20 - 30%",0.5,1.5,"DIR reduced by 50% due to installation on sloping area.",2,80,80]
[null,"Design Irrigation Rate of Soils",{"$f":"SITE!AF21*VLOOKUP(SITE!C7,IrD!F:G,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(SITE!C7,IrD!F:I,4,FALSE)","v":{"$error":"#N/A"}},null,">30%",0,0,"Advice required from suitably qualified and experience person. Terracing of irrigation area required.",3,90,90]
[null,"Irrigation system type",null,null,null,null,null,null,null,4,150,100]
[null,"Permission to reduce irrigation granted?",null,null,null,null,null,null,null,5,150,150]
[null,"Total irrigation area size required",{"$f":"IF(AND(Dom!B5<6,C6=\"Yes\",C2=\"Sand\",IrD!C5=\"Surface\"),VLOOKUP(Dom!B5,IrD!J:L,2,FALSE),IF(AND(Dom!B5<6,C6=\"Yes\",C2=\"Sand\",OR(C5=\"Sub-surface\",C5=\"Sub-strata\")),VLOOKUP(Dom!B5,IrD!J:L,3,FALSE),IF(Dom!B5>5,Dom!B7/IrD!C4,150*VLOOKUP(SITE!C7,IrD!F:H,3,FALSE))))","v":{"$error":"#N/A"}},"m2"]

{"sheet":"IrC","index":19,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,"Irrigation System",null,null,null,"Flat - 10%",1,1]
[null,"Soil Type",{"$f":"SITE!C3","v":0},null,null,"10 - 20%",0.8,1.2,"DIR reduced by 20% due to installation on sloping area."]
[null,"Daily Hydraulic Loading ",{"$f":"MAX(Com!C13:C14)","v":0},null,null,"20 - 30%",0.5,1.5,"DIR reduced by 50% due to installation on sloping area."]
[null,"Design Irrigation Rate of Soils",{"$f":"SITE!AF21*VLOOKUP(SITE!C7,IrC!F:G,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(SITE!C7,IrC!F:I,4,FALSE)","v":{"$error":"#N/A"}},null,">30%",0,0,"Advice required from suitably qualified and experience person. Terracing of irrigation area required."]
[null,"Irrigation system type"]
[null,"Total irrigation area size required",{"$f":"IF(C4=0,0,C3/C4)","v":{"$error":"#N/A"}},"m2"]

{"sheet":"Bed","index":20,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,"Conventional Bed"]
[null,"Soil Type",{"$f":"SITE!C3","v":0},{"$f":"IF(C4=\"Not Suitable\",\"Conventional bed are not suitable for this soil type. Consider secondary treatment systems  or ETA/ETS beds.\",\"\")","v":{"$error":"#N/A"}}]
[null,"Daily Hydraulic Loading ",{"$f":"MAX(Dom!B7,Com!C13,Com!C14)","v":0},"L/day"]
[null,"Design Loading Rate of Soils",{"$f":"IF(OR(Atu!C3=\"Yes\",Wtp!C4=\"Yes\",Roo!C3=\"Yes\",Wor!C3=\"Yes\"),SITE!AG21,SITE!AE21)","v":{"$error":"#N/A"}},"L/m2/day"]
[]
[null,null,"é"]
[null,"Enter width of the bed >>>>>>>>>>>>>>>>>>>>>>>>>",null,"m"]
[null,"Total length of beds required",{"$f":"IF(C4=\"Not Suitable\",\"Not Suitable\",C3/C4/IF(C7>4,4,C7))","v":{"$error":"#N/A"}},"m"]
[null,"Recommended layout",{"$f":"IF(C4=\"Not Suitable\",\"Not Suitable\",EVEN(C8/22) & \" x \"& ROUND(C8/EVEN(C8/22),1))","v":{"$error":"#N/A"}},"m"]
[null,"Confirm that the topsoil depth is not more than 150mm.",null,{"$f":"IF(C10=\"No\",\"The topsoil for the leach drain must not be more than 150mm.\",\"\")","v":""}]

{"sheet":"Tre","index":21,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,"Conventional Trench"]
[null,"Soil Type",{"$f":"SITE!C3","v":0},{"$f":"IF(C4=\"Not Suitable\",\"Conventional bed are not suitable for this soil type. Consider secondary treatment systems  or ETA/ETS beds.\",\"\")","v":{"$error":"#N/A"}}]
[null,"Daily Hydraulic Loading ",{"$f":"MAX(Dom!B7,Com!C13,Com!C14)","v":0},"L/day"]
[null,"Design Loading Rate of Soils",{"$f":"IF(OR(Atu!C3=\"Yes\",Wtp!C4=\"Yes\",Roo!C3=\"Yes\",Wor!C3=\"Yes\"),SITE!AG21,SITE!AE21)","v":{"$error":"#N/A"}},"L/m2/day"]
[]
[null,null,"é"]
[null,"Enter width of the bed >>>>>>>>>>>>>>>>>>>>>>>>>",null,"m"]
[null,"Total length of beds required",{"$f":"IF(C4=\"Not Suitable\",\"Not Suitable\",C3/C4/IF(C7>4,4,C7))","v":{"$error":"#N/A"}},"m"]
[null,"Recommended layout",{"$f":"IF(C4=\"Not Suitable\",\"Not Suitable\",EVEN(C8/22) & \" x \"& ROUND(C8/EVEN(C8/22),1))","v":{"$error":"#N/A"}},"m"]
[null,"Confirm that the topsoil depth is not more than 150mm.",null,{"$f":"IF(C10=\"No\",\"The topsoil for the leach drain must not be more than 150mm.\",\"\")","v":""}]

{"sheet":"Mou","index":22,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,"Mound"]
[null,"Soil Type",{"$f":"SITE!C3","v":0},{"$f":"IF(C4=\"Not Suitable\",\"Leach drains are not suitable for this soil type. Consider secondary treatment systems  or ETA/ETS beds.\",\"\")","v":{"$error":"#N/A"}}]
[null,"Daily Hydraulic Loading ",{"$f":"MAX(Dom!B7,Com!C13,Com!C14)","v":0},"L/day"]
[null,"Design Loading Rate of Soils",{"$f":"SITE!AH21","v":{"$error":"#N/A"}},"mm/day"]
[null,"Minimum Distribution Bed Area",{"$f":"C3/40","v":0},"m2"]
[null,"Distribution Bed Length to Width Ratio",null,"Typically between 6 to 8"]
[null,"Distribution Bed Width Required",{"$f":"ROUND(SQRT(C5/C6),2)","v":{"$error":"#DIV/0!"}},"m"]
[null,"Distribution Bed Length Required",{"$f":"C7*C6","v":{"$error":"#DIV/0!"}}]
[null,"Mound height",{"$f":"SUM(C10:C13)/1000","v":0},"m"]
[null,"T1 (mm)",null,"Mininum 225mm"]
[null,"T2 (mm)",null,"Minimum 300mm"]
[null,"T3 (mm)",null,"Minimum 150mm"]
[null,"T4 (mm)",null,"Minimum 600mm"]
[null,"Fill batter slope: 1 in :",null,"minimum 3"]
[null,"Slope of land application area (degrees)",null,"degrees"]
[null,"Mound extent upslope",{"$f":"ROUND(C9/((1/C14)+TAN(C15*((22/7)/180))),2)","v":{"$error":"#DIV/0!"}},"m"]
[null,"Mound extent downslope",{"$f":"ROUND((C9+(C7*(TAN(C15*(22/7)/180))))/((1/C14)-(TAN(C15*(22/7)/180))),2)","v":{"$error":"#DIV/0!"}},"m"]
[null,"Mound extent across slope (upslope)",{"$f":"ROUND(C9*C14,2)","v":0},"m"]
[null,"Mound extent across slope (downslope)",{"$f":"ROUND((C9+(C7*(TAN(C15*(22/7)/180))))*C14,2)","v":{"$error":"#DIV/0!"}},"m"]
[null,"Toe loading Rate",{"$f":"ROUND(C3/(C8+(2*C18)),1)","v":{"$error":"#DIV/0!"}},"Must be <125L/m/d"]
[null,"Mound Base Loading Rate",{"$f":"ROUND(C3/((C8+2*C18)*(C7+C17)),1)","v":{"$error":"#DIV/0!"}},"mm/day"]
[null,"Is mound base loading rate less than Design Loading Rate for soil?",{"$f":"IF(C4>=C21,\"Yes\",\"No\")","v":{"$error":"#N/A"}},{"$f":"IF(C22=\"Yes\",\"System Compliant\",\"System Undersized\")","v":{"$error":"#N/A"}}]

{"sheet":"Soa","index":23,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,"Soakwells"]
[null,"Soil Type",{"$f":"SITE!C3","v":0},{"$f":"IF(C2=\"Sand\",\"\",\"Soakwells only suitable for use in sandy soils. Choose another disposal type.\")","v":"Soakwells only suitable for use in sandy soils. Choose another disposal type."}]
[null,"Daily Hydraulic Loading ",{"$f":"MAX(Dom!B7,Com!C13,Com!C14)","v":0},"L/day"]
[null,"Design Loading Rate of Soils",{"$f":"IF(OR(Atu!C3=\"Yes\",Wtp!C4=\"Yes\",Roo!C3=\"Yes\",Wor!C3=\"Yes\"),SITE!AG21,SITE!AE21)","v":{"$error":"#N/A"}},"L/m2/day"]
[null,"Referring to the approved listing, what is the prescribed infiltrative area for the soakwell?",null,"m2/soakwell"]
[null,"Total number of soakwells required",{"$f":"IF(C2=\"Sand\",ROUNDUP(C3/C4/C5,0),\"Not Suitable\")","v":"Not Suitable"},"soakwells"]

{"sheet":"Aes","index":24,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,"Advanced Enviroseptic"]
[]
[null,"Input the following parameters into the AES sizing tool:"]
[null,"Soil Type",{"$f":"SITE!C3","v":0},{"$f":"IF(C6=\"Not Suitable\",\"Leach drains are not suitable for this soil type. Consider secondary treatment systems  or ETA/ETS beds.\",\"\")","v":{"$error":"#N/A"}}]
[null,"Daily Hydraulic Loading ",{"$f":"MAX(Dom!B7,Com!C13,Com!C14)","v":0},"L/day"]
[null,"Design Loading Rate of Soils",{"$f":"IF(OR(Atu!C3=\"Yes\",Wtp!C4=\"Yes\",Roo!C3=\"Yes\",Wor!C3=\"Yes\"),SITE!AG21,SITE!AE21)","v":{"$error":"#N/A"}},"mm/day"]
[null,"Does the proposed system meet the minimum requirements prescribed by the sizing tool?"]

{"sheet":"Fil","index":25,"n_rows":6,"n_cols":7,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,"Filtrex ",null,null,null,1,"ATS2"]
[null,"Soil Type",{"$f":"SITE!C3","v":0},{"$f":"IF(OR(C2=\"Light Clay\",C2=\"Medium / \nHeavy Clay\"),\"Filtrex system not approved for installation in clay soils. Select another disposal system.\",\"\")","v":""},null,2,"ATS2"]
[null,"Daily Hydraulic Loading ",{"$f":"MAX(Dom!B7,Com!C13,Com!C14)","v":0},"L/day",null,3,"ATS4"]
[null,"Filtrex system required",{"$f":"IF(AND(Dom!B5>=1,Dom!B5<7),VLOOKUP(Dom!B5,Fil!F:G,2,FALSE),\"GENX-ATS\")","v":"GENX-ATS"},null,null,4,"ATS4"]
[null,null,null,null,null,5,"ATS5"]
[null,"Total Filtrex GENX-ATS cage length required",{"$f":"IF(OR(C2=\"Light Clay\",C2=\"Medium / \nHeavy Clay\"),\"Not Suitable\",\"2 x \"&ROUND(((0.0152*C3)+0.0434),2))","v":"2 x 0.04"},"m",null,6,"ATS6"]

{"sheet":"LAY","index":26,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,"Onsite system layout"]
[]
[null,"Are all premises, treatment system and disposal systems located on ONE single lot?"]
[null,"Can the following setback distances be met?"]

{"sheet":"LAYIrr","index":27,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,"Onsite system layout"]
[]
[null,"Are all premises, treatment system and disposal systems located on ONE single lot?"]
[null,"Can the following setback distances be met?"]