{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Macro","License","Sizing Tool","Design Flow","Septic Tank","ABR","Septic + Cocopeat","ABR + Cocopeat"],"not_rendered":{"charts":0,"images":31,"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":"Macro","index":0,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":false,"merged":[[23,2,23,3]]}
[]
[null,"Enable Macros"]
[]
[null,"Before you can use RTI's Septic Tank/ABR Tool you will need to enable Macros in Excel."]
[]
[]
[" "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Once you have enabled Macros in Excel, continue to the Septic Tank/ABR Tool."]

{"sheet":"License","index":1,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":true,"merged":[[24,2,24,4],[24,6,24,8]]}
[]
[null,"RTI's Septic Tank/ABR Tool"]
[]
[]
[]
[null,"Terms and conditions:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"I agree to these conditions:  "]
[]
[]
[]
[]
["Version 1.0 ",null,null,null,null,"Expires: "]

{"sheet":"Sizing Tool","index":2,"n_rows":21,"n_cols":8,"rows_kept":21,"cut":false,"hidden":true,"merged":[[3,0,6,13]]}
["Project Sizing Tool"]
[]
[]
["To determine the primary treatment system best suited for your project's wastewater, fill out the information in this page and the following Design Flow page. This tool will provide guidance on whether a septic tank or an anaerobic baffled reactor is required, as well as sizing suggestions and construction information."]
[]
[]
[]
[]
[null,"1. Describe your Project:"]
[]
[]
[]
[null,"2. Waste flow rate:",null,null,null,"%"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Click the image to return to the website"]

{"sheet":"Design Flow","index":3,"n_rows":40,"n_cols":14,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
["Standard Values of Wastewater Generation"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"#Units",null,"Total Flow"]
[]
[null,"Residential Housing:",null,null,null,"Flow per person",null,280,"L/day",null,0,null,{"$f":"+H9*K9","v":0},"L/day"]
[]
[]
[null,"Public Market:",null,null,null,"Flow per stall",null,25,"L/day",null,25,null,{"$f":"+H12*K12","v":625},"L/day"]
[]
[]
[null,"Slaughterhouse:",null,null,null,"Slaughterhouse"]
[null,null,null,null,null,null,"Chicken",5,"L/animal",null,0,null,{"$f":"+H16*K16","v":0},"L/day"]
[null,null,null,null,null,null,"Hogs",45,"L/animal",null,0,null,{"$f":"+H17*K17","v":0},"L/day"]
[null,null,null,null,null,null,"Sheep",45,"L/animal",null,0,null,{"$f":"+H18*K18","v":0},"L/day"]
[null,null,null,null,null,null,"Cows",125,"L/animal",null,0,null,{"$f":"+H19*K19","v":0},"L/day"]
[]
[]
[null,"Hospital and Healthcare:",null,null,null,"Flow Per bed",null,1135,"L/day",null,1350,null,{"$f":"+H22*K22","v":1532250},"L/day"]
[]
[]
[null,"Hotel/Resort/Restaurant:",null,null,null,"Flow per room",null,450,"L/day",null,0,null,{"$f":"+H25*K25","v":0},"L/day"]
[]
[]
[null,"Office Building:",null,null,null,"Flow per person",null,95,"L/day",null,0,null,{"$f":"+H28*K28","v":0},"L/day"]
[null,null,null,null,null,"(8 hour shift)"]
[]
[null,"School:",null,null,null,"Flow per room",null,450,"L/day",null,450,null,{"$f":"+H31*K31","v":202500},"L/day"]
[]
[]
[null,"Other (from chart):",null,null,null,null,null,0,"L/day",null,0,null,0,"L/day"]
[]
[]
[null,"Community  (a mix of residential and commercial sources):",null,null,null,null,null,null,null,null,0,null,{"$f":"+H37*K37","v":0},"L/day"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"TOTAL:",null,{"$f":"SUM(M9:M37)/1000","v":1735.375},"m³/day"]

{"sheet":"Septic Tank","index":4,"n_rows":37,"n_cols":13,"rows_kept":37,"cut":false,"hidden":true,"merged":[[12,4,12,5],[32,5,32,6],[0,0,1,2],[3,10,4,13],[3,1,3,3],[4,1,4,3],[5,1,5,3]]}
["Septic Tank"]
[]
[]
[null,"Daily flow volume:",null,null,null,"L",null,"Tank depth:",1.2,"m"]
[null,"Septic tank volume:",null,null,null,"L",null,"Tank width:",null,"m"]
[null,"Volume in m³:",null,null,null,"m³",null,"Tank length:",null,"m"]
[]
[null,null,null,null,"Profile View of Septic Tank"]
[null,null,"(grade)",null,null,null,null,null,null,null," 0.6 m"]
[]
[]
[]
[null,null,null,null,"(liquid level)"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"1.2 m"]
[null,null,"1.0 m"]
[null,null,null,null,null,null,null,null,null,null,null,".9 m"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null," "," "]
[]
[]
[]
[]
[null,null,null,null,null,"End View of Septic Tank"]
[]
["      NOTES:"]
["      1.  All dimensions are in meters"]
["      2.  Drawing are not to scale"]
["      3.  These are suggested values only",null,null,null,null,"(liquid level)",null,null,null,null,null,"View Cocopeat filter addition to Septic Tank"]
["      4.  Always confirm calculations with"]
["            a sanitary engineer"]
[null,null,null,null,"1.2 m"]
[null,null,null,null,null,null,null,{"$f":"+L18","v":".9 m"}]

{"sheet":"ABR","index":5,"n_rows":37,"n_cols":16,"rows_kept":37,"cut":false,"hidden":true,"merged":[[32,6,32,7],[14,0,14,1],[13,0,13,1],[15,0,15,1],[0,0,1,4],[12,6,12,7],[7,1,10,3]]}
["Anaerobic Baffled Reactor"]
[]
[]
[]
[null,"1. Anaerobic Baffled Reactor Storage Factor:"]
[]
[]
[null,null,null,null,null,null,"Profile View of Anaerobic Baffled Reactor"]
[null,null,null,null,"(grade)",null,null,null,null,null,null,null,null," 0.6 m"]
[]
[]
[]
[null,null,null,null,null,null,"(liquid level)"]
["Daily flow volume:",null,null,"L"]
["ABR volume:",null,null,"L"]
["Volume in m³:",null,null,"m³",null,null,null,null,null,null,null,null,null,null,null,"1.8 m"]
[null,null,null,null,"1.6 m"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.5 m"]
[null,"Tank depth:",1.8,"m",null,null,null,null,null,null,"    1.25 m"]
[null,"Tank width:",null,"m"]
[null,"Tank length:",null,"m"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[]
[]
[]
[]
[null,null,null,null,null,null,"End View of Anaerobic Baffled Reactor"]
[]
[null,"NOTES:"]
[null,"1.  All dimensions are in meters"]
[null,"2.  Drawings are not to scale"]
[null,"3.  These are suggested values only",null,null,null,null,"(liquid level)",null,null,null,null,null,"View addition of cocopeat filter to ABR"]
[null,"4.  Always confirm calculations with"]
[null,"      a sanitary engineer"]
[null,null,null,null,null,"1.8 m"]
[null,null,null,null,null,null,null,null,"1.5 m"]

{"sheet":"Septic + Cocopeat","index":6,"n_rows":31,"n_cols":18,"rows_kept":31,"cut":false,"hidden":true,"merged":[[22,1,22,3],[23,1,23,3],[24,1,24,3],[0,0,1,5],[4,8,5,15]]}
["Septic Tank with Cocopeat Filter"]
[]
[]
[]
[null,"1. Cocopeat Filter Pump Flow:",null,null,null,"L/min",null,null,"Pump run time should not exceed 20 minutes per cycle.  A larger pump and pump flow volume is recommended."]
[]
[]
[null,null,null,null,null,"Cocopeat Filter",null,null,null,null,null,null,null,"Profile View of Cocopeat Filter"]
[null,null,null,null,"Daily flow volume:",{"$f":"'Septic Tank'!E4","v":0},"L",null,"PVC Sch. 40 1\" pipe with 1/8\" weep holes every 12\""]
[null,null,null,null,"Surface area of peat filter:",{"$f":"F9/175","v":0},"m²"]
[null,null,null,null,"Volume per dose:",{"$f":"F9/12","v":0},"L"]
[null,null,null,null,"Pump run time per cycle:",25.5,"min",null,null,null,null,null,"Cocopeat Fill Material"]
[null,null,null,null,null,null,null,null,"Filter box","Filter box",null,null,null,null,null,"Timer settings"]
[null,null,null,null,null,null,null,null,null,null,null,".75 m",null,null,"Run Time:",{"$f":"F12","v":25.5},"min"]
[null,null,null,"Profile View of Septic Tank",null,null,null,null,null,null,null,null,null,null,"Lag Time:",{"$f":"120-P14","v":94.5},"min"]
["(grade)",null,null,null,null,null,null,null,{"$f":"'Septic Tank'!K9","v":" 0.6 m"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"4\" thin wall plastic pipe with 1/2\" perforations"]
[null,null,"(liquid level)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"To discharge"]
[]
[null,null,null,null,"Septic Tank",null,null,null,null,null,"pump control float"]
[null,"Daily flow volume:",null,null,{"$f":"'Septic Tank'!E4","v":0},"L",null,null,null,{"$f":"'Septic Tank'!M16","v":"1.2 m"}]
[{"$f":"'Septic Tank'!C17","v":"1.0 m"},"Septic tank volume:",null,null,{"$f":"'Septic Tank'!E5","v":0},"L"]
[null,"Volume in m³:",null,null,{"$f":"'Septic Tank'!E6","v":0},"m³"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Effluent pump"]
[null,null,null,{"$f":"'Septic Tank'!F22","v":0},null,null,null,{"$f":"'Septic Tank'!J22","v":0}]
[null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,{"$f":"'Septic Tank'!H25","v":0}]

{"sheet":"ABR + Cocopeat","index":7,"n_rows":32,"n_cols":19,"rows_kept":32,"cut":false,"hidden":true,"merged":[[0,0,1,4],[19,2,19,3],[4,8,5,17]]}
["ABR with Cocopeat Filter"]
[]
[]
[]
[null,"1. Cocopeat Filter Pump Flow:",null,null,null,"L/min",null,null,"Pump run time should not exceed 20 minutes per cycle.  A larger pump and pump flow volume is recommended."]
[]
[]
[null,null,null,null,null,"Cocopeat Filter",null,null,null,null,null,null,null,null,"Profile View of Cocopeat Filter"]
[null,null,null,null,"Daily flow volume:",{"$f":"ABR!C14","v":0},"L",null,null,"PVC Sch. 40 1\" pipe with 1/8\" weep holes every 12\""]
[null,null,null,null,"Surface area of peat filter:",{"$f":"F9/500/0.75","v":0},"m²"]
[null,null,null,null,"Volume per dose:",{"$f":"F9/12","v":0},"L"]
[null,null,null,null,"Pump run time per cycle:",51,"min",null,null,null,null,null,null,"Cocopeat Fill Material"]
[null,null,null,null,null,null,null,null,null,"Filter box","Filter box",null,null,null,null,null,"Timer settings"]
[null,null,null,null,null,null,null,null,null,null,null,null,".75 m",null,null,"Run Time:",{"$f":"F12","v":51},"min"]
[null,null,"Profile View of Anaerobic Baffled Reactor",null,null,null,null,null,null,null,null,null,null,null,null,"Lag Time:",{"$f":"120-Q14","v":69},"min"]
["(grade)",null,null,null,null,null,null,null,null,{"$f":"ABR!N9","v":" 0.6 m"}]
[]
[]
[null,null,null,null,null,null,null,{"$f":"ABR!L12","v":0},null,null,null,null,null,"4\" thin wall plastic pipe with 1/2\" perforations"]
[null,null,"(liquid level)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"To discharge"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"pump control float"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"ABR!P16","v":"1.8 m"}]
[{"$f":"ABR!E17","v":"1.6 m"}]
[]
[null,null,null,null,null,null,{"$f":"ABR!K19","v":"    1.25 m"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Effluent pump"]
[null,null,null,{"$f":"ABR!H22","v":0}]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[null,null,null,null,null,null,{"$f":"ABR!K25","v":0}]