{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Macro","License","Site Plan Checklist","Soil Depth","Soil Texture and Structure","Permeability","Seasonally High Groundwater","Slope and Topography","Land Use","Setbacks","Site Output Page"],"not_rendered":{"charts":0,"images":68,"macros":1,"external_links":0,"defined_names":2,"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":"Macro","index":0,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Enable Macros"]
[]
[null,"Before you can use RTI's Site Evaluation Tool you will need to enable Macros in Excel."]
[]
[]
[" "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Once you have enabled Macros in Excel, continue to the Site Evaluation Tool."]

{"sheet":"License","index":1,"n_rows":24,"n_cols":4,"rows_kept":24,"cut":false,"hidden":true,"merged":[[23,4,23,5],[23,1,23,2]]}
[]
[null,"RTI's Site Evaluation Tool"]
[]
[]
[]
[null,"Terms and conditions:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"I agree to these conditions:  "]
[]
[]
[]
["Version 1.0 ",null,null,"Expires: "]

{"sheet":"Site Plan Checklist","index":2,"n_rows":22,"n_cols":15,"rows_kept":22,"cut":false,"hidden":true,"merged":[[2,0,4,12],[5,2,5,10],[19,2,19,8],[18,2,18,8],[8,2,8,8],[9,2,9,8],[10,2,10,8],[11,2,11,8],[12,2,12,8],[13,2,13,8],[7,2,7,8],[14,2,14,8],[15,2,15,8],[16,2,16,8],[17,2,17,8]]}
["Step 1: Site Plan Checklist"]
[]
["A site plan is the best way to represent information about your project. Once completed, it will help you determine the area available for your wastewater system, pumping requirements, and verify setback compliance.  If you do not have a site plan sketch already, create one using the information and tools provided on the ning website: "]
[]
[]
[null,null,"http://watsanexp.ning.com/page/site-plan-sketch "]
[]
[null,"Number","Task",null,null,null,null,null,null,"Yes","No","Help"]
[null,1," North arrow shown"]
[null,2," Site plan is drawn to scale"]
[null,3," Nearest street or road shown"]
[null,4," Property lines shown"]
[null,5," Parking area shown"]
[null,6," All buildings and existing septic tanks"]
[null,7," Location of well, water line, other features requiring setbacks shown"]
[null,8," Location of surface water and floodplains"]
[null,9," Greywater discharge point shown",null,null,null,null,null,null,null,null,null,null,null,"Click the image to return to the website"]
[null,10," Building sewer line from house to septic tank, septic tank to sewer"]
[null,11," Topography. provide arrows that indicate the slope"]
[null,12," Area map and directions to the site"]
[]
[null,"How much land area is available for wastewater system installation:",null,null,null,null,null,null,null,null,null,"m"]

{"sheet":"Soil Depth","index":3,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":true,"merged":[[26,9,29,13],[13,8,13,12]]}
["Step 2: Soil Depth"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Click the image to return to the website"]
[null,"1. What is the depth of your test hole:",null,null,null,null,"m"]

{"sheet":"Soil Texture and Structure","index":4,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
["Step 3: Soil Texture and Structure"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["      1. What is the size of your DEWATS System?"]
[]
[null,null,null,null,null,null,null,null,null,null,"       Click the image to return to the website"]
[]
[]
["      2. If your site has a leach trench, you will need to test your soil permeability:"]

{"sheet":"Permeability","index":5,"n_rows":21,"n_cols":15,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["Soil Percolation Test"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Soil Application Rate:",null,null,null,"  L/m² per day"]

{"sheet":"Seasonally High Groundwater","index":6,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["Step 4: Seasonally High Groundwater"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["     Did you encounter groundwater while digging the test holes?"]
[]
["     Are there any signs of soil coloration or mottling?"]
[null,null,null,null,null,null,null,null,null,"               Click the image to return to the website"]
["     Is the site within a floodplain?"]

{"sheet":"Slope and Topography","index":7,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["Step 5: Slope and Topography"]
[]
[]
[]
[]
[]
[]
[]
[]
["      1. What is the Vertical distance between your source and your treatment site:"]
[]
[null,null,null,null,"m"]
[null,null,null,null,null,null,null,null,"                  Click the image to return to the website"]
["      2. What is the Horizontal distance between your source and your treatment site:"]
[]
[null,null,null,null,"m"]
[]
[]
[null,null,"Site Slope:",null,null,"%"]

{"sheet":"Land Use","index":8,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["Step 6: Land Use of Surrounding Lots"]
[]
[]
[]
[]
[]
[]
[]
[]
["       What is distance between the closest residential community and your site:"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Click the image to return to the website"]

{"sheet":"Setbacks","index":9,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":true,"merged":[[22,8,22,10],[24,8,24,10],[25,8,25,10],[26,8,26,10],[27,8,27,10],[23,1,23,10],[30,1,30,7],[7,8,7,10],[8,1,8,10],[9,8,9,10],[10,8,10,10],[12,8,12,10],[13,8,13,10],[15,8,15,10],[16,8,16,10],[28,1,28,10],[13,1,13,7],[15,1,15,7],[16,1,16,7],[29,8,29,10],[30,8,30,10],[18,1,18,7],[31,1,31,10],[19,8,19,10],[20,8,20,10],[21,8,21,10],[17,8,17,10],[18,8,18,10],[25,1,25,7],[26,1,26,7],[27,1,27,7],[29,1,29,7],[19,1,19,7],[20,1,20,7],[21,1,21,7],[22,1,22,7],[24,1,24,7],[17,1,17,7],[4,1,5,10],[14,1,14,10],[7,1,7,7],[9,1,9,7],[10,1,10,7],[12,1,12,7],[11,1,11,10]]}
["Site Setbacks"]
[]
[null,null,"Site setback standards for Country:"]
[]
[null,"The setback distances listed below are from the wastewater system and other sensitive features and shall be used unless county-specific setbacks are provided"]
[]
[]
[null," Situation  ",null,null,null,null,null,null," Setback (meters)   "]
[null," Building  "]
[null," Wastewater field upslope of building  ",null,null,null,null,null,null,6]
[null," Wastewater field down slope of building  ",null,null,null,null,null,null,6]
[null," Allotment boundary  "]
[null," Wastewater field upslope of adjacent lot  ",null,null,null,null,null,null,6]
[null," Wastewater field down slope of adjacent lot  ",null,null,null,null,null,null,6]
[null," Services  "]
[null," Water supply pipe  ",null,null,null,null,null,null,3]
[null," Potable supply channel (wastewater field upslope)  ",null,null,null,null,null,null,3]
[null," Potable supply channel (wastewater down slope)  ",null,null,null,null,null,null,300]
[null," Gas  ",null,null,null,null,null,null,20]
[null," Underground water tank  ",null,null,null,null,null,null,3]
[null," Stormwater drain  ",null,null,null,null,null,null,15]
[null," Swimming pool  ",null,null,null,null,null,null,6]
[null," Cutting / escarpment   ",null,null,null,null,null,null,6]
[null," Surface waters (upslope from)  "]
[null," Dam or reservoir (potable, including food production)*  ",null,null,null,null,null,null,300]
[null," Dam or reservoir (stock & non potable)  ",null,null,null,null,null,null,300]
[null," Stream or channel (continuous or ephemeral, non potable)  ",null,null,null,null,null,null,60]
[null," Stream (potable water supply catchment)  ",null,null,null,null,null,null,60]
[null," Groundwater well"]
[null," Potable",null,null,null,null,null,null,35]
[null,"Non-potable",null,null,null,null,null,null,35]
[null," * does not apply to dams and reservoirs above ground level  "]

{"sheet":"Site Output Page","index":10,"n_rows":29,"n_cols":18,"rows_kept":29,"cut":false,"hidden":true,"merged":[[28,1,30,17],[23,1,23,17],[21,1,21,17],[25,1,26,17]]}
["Site Evaluation Output Page"]
[]
["1. Site Information:"]
[]
[null,"a)  Available Area for Wastewater System: ",null,null,null,null,null,null,null,null,null,"m"," b)  Site Slope:",null,null,null,null,"%"]
[]
[]
[null,"c)  Soil Depth:",null,null,null,null,"m","d)  Distance of residential community:",null,null,null,null,null,null,null,null,"m"]
[]
[]
[null,"e)  Lagoon Wetland Size:"]
[]
[]
[null,"f)  Site Application Rate:",null,null,null,null,null,"     L/m² per day",null,null,"g)  Site within floodplain"]
[]
[]
[null,"h)  Groundwater at Site:",null,null,null,null,null,null,null,"i)  Soil Coloration or Molting:"]
[]
[]
["2. Considerations:"]
[]
[null,"1. If the site slope is over 15%, a wastewater systm cannot be installed at this site."]
[]
[null,"2. If site is within a floodplain, facilities will require protection to withstand a 100 year flood event."]
[]
[null,"3. Depending on the distance between residential communities and your site, odor and noise control may be required."]
[]
[]
[null,"4. On-site soils based effluent feasibility cannot be determined: Complete a percolation test for the leach trench area and submit results in the permeability page. Percolation test results for the leach trench area should be between 1.57 and 95 minutes per 2cms."]