{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Macro","License","Introduction","Background","Inputs","Design Flow","Water Meter Tool","Standard Values Tool","Organic Loading","Wetland","Project Team","Septic Tank","ABR"],"not_rendered":{"charts":0,"images":56,"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":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Enable Macros"]
[]
[null,"Before you can use RTI's Weltand Tool you will need to enable Macros in Excel."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Once you have enabled Macros in Excel, continue to the Wetland Tool."]

{"sheet":"License","index":1,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":true,"merged":[[25,5,25,6],[27,5,27,6],[25,1,25,3]]}
[]
[null,null,null,null,"RTI's Wetland Tool"]
[]
[]
[]
[]
[null,"Terms and conditions:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"I agree to these conditions:"]
[]
[]
[]
["Version 1.0 ","2013-01-21T17:57:32",null,null,"Expires: ","2013-07-21T17:57:32"]

{"sheet":"Introduction","index":2,"n_rows":18,"n_cols":1,"rows_kept":18,"cut":false,"hidden":true,"merged":[[22,2,22,3],[2,0,4,7]]}
[]
[]
["RTI's Wetland Creator"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Language:"]

{"sheet":"Background","index":3,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":true,"merged":[[26,2,26,3],[0,0,1,9]]}
["Background Information on Constructed Wetlands"]

{"sheet":"Inputs","index":4,"n_rows":35,"n_cols":10,"rows_kept":35,"cut":false,"hidden":true,"merged":[[35,3,35,4],[0,0,1,6]]}
["Wetland Design Inputs"]
[]
[]
[]
[null,"1)","Flow Volume Per Day",null,null,"m³/d "]
[]
[]
[null,"2)","Oxygen Demand"]
[]
[]
[null,null,"a) Source Wastewater",null,null,"mg/L  "]
[null,null,"BOD"]
[]
[]
[]
[null,null,"b) Influent BOD after",null,null,"mg/L  "]
[null,null,"     ABR"]
[]
[null,null,"b) Target Effluent BOD",null,null,"mg/L  "]
[]
[]
[null,"3)","Wetland Media Depth",null,null,"m"]
[]
[]
[null,"4)","Temperature",null,null,null,null,null,null," "]
[]
[]
[null,"5)","Porosity"]
[]
[]
[]
[]
[]
[]
["Language:"]

{"sheet":"Design Flow","index":5,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":true,"merged":[[0,0,1,6],[9,8,9,9],[12,8,12,9],[19,3,19,4]]}
["Calculating Design Flow"]
[]
[]
[]
["1)","In this step you will estimate the volume of wastewater each day that will require treatment. There are three methods:"]
[null,null,null,null,"   input boxes are yellow, output boxes are white."]
[]
[null,"A)","Water Meter Readings:",null,null,{"$f":"'Water Meter Tool'!K12","v":0},"m³/day"]
[]
[null,null,null,null,null,null,null,null,"Or"]
[null,"B)","Standard Values:",null,null,{"$f":"'Standard Values Tool'!M40","v":0},"m³/day"]
[]
[null,null,null,null,null,null,null,null,"Or"]
[null,"C)","Review Similar Projects:",null,null,null,"m³/day","             Input estimate in the yellow cell to the left."]
[]
[]
["2)","Percentage of Design Flow  converted to wastewater:",null,null,null,null,85,"%"]
[]
[]
[null,null,null,"Design Flow:",null,{"$f":"MAX(F8,F11,F14)*G17/100","v":0},"m³/day"]

{"sheet":"Water Meter Tool","index":6,"n_rows":17,"n_cols":12,"rows_kept":17,"cut":false,"hidden":true,"merged":[[16,3,16,4],[10,3,10,4],[11,3,11,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[15,3,15,4],[9,3,9,4],[4,3,4,4],[5,3,5,4],[6,3,6,4],[7,3,7,4],[8,3,8,4]]}
["Water Meter Tool"]
[]
["1)","Enter Water Meter Readings from your water bill. (Enter your actual water consumption in the yellow boxes.)"]
[]
[null,null,"MONTH","CONSUMPTION",null,"(m³/month)"]
[null,null,"JAN",0]
[null,null,"FEB",0]
[null,null,"MAR",0]
[null,null,"APR",0]
[null,null,"MAY",0,null,null,"Average daily water consumption:",null,null,null,{"$f":"SUM(D6:E17)/30/12","v":0},"m³/day"]
[null,null,"JUN",0]
[null,null,"JULY",0,null,null,"Peak daily flow:",null,null,null,{"$f":"MAX(D6:E17)/30","v":0},"m³/day"]
[null,null,"AUG",0]
[null,null,"SEPT",0]
[null,null,"OCT",0]
[null,null,"NOV",0]
[null,null,"DEC",0]

{"sheet":"Standard Values Tool","index":7,"n_rows":40,"n_cols":14,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
["Standard Values of Wastewater Generation"]
[]
[]
[]
[]
["4)","Describe Project:"]
[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,0,null,{"$f":"+H12*K12","v":0},"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,0,null,{"$f":"+H22*K22","v":0},"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,0,null,{"$f":"+H31*K31","v":0},"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,{"$f":"SUM(K9:K34)","v":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":0},"m³/day"]

{"sheet":"Organic Loading","index":8,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":true,"merged":[[0,0,1,6]]}
["Step 4: Determine Organic Loading"]
[]
[]
["1)","Your hydraulic loading is:",null,null,0,"m³/day"]
[]
["2)","Now let's figure out the organic loading:"]
[]
[null,"Wastewater from residential communities is the baseline from which other sources are compared"]
[null,"     you may adjust the value in the yellow boxes based on local knowledge or evidence"]
[null,null,null,null,"BOD Concentration"]
[null,"Residential Housing",null," ",220," mg/L"]
[null,"Public Market",null,null,750," mg/L"]
[null,"Slaughterhouse",null,null,2500," mg/L"]
[null,"Hospital",null,null,750," mg/L"]
[null,"Hotel/Resort/Restaurant ",null,null,200," mg/L"]
[null,"Office Building ",null,null,200," mg/L"]
[null,"School",null,null,200," mg/L"]
[null,"Other",null,null,220," mg/L"]
[null,"Community",null,null,220," mg/L"]
[null,null,null,null," "]
[null,"Hydraulic loading",null,null,{"$f":"+E4","v":0},"m³/day","X",0," mg/L BOD"]
[]
[null,null,null,null,{"$f":"+E21*H21/1000","v":0},"BOD - Kg/day"]

{"sheet":"Wetland","index":9,"n_rows":34,"n_cols":20,"rows_kept":34,"cut":false,"hidden":true,"merged":[[33,15,33,16],[23,2,23,3],[0,0,1,4],[32,15,32,16],[23,11,23,12],[20,11,20,12],[24,11,24,12],[21,11,21,12],[22,5,23,7],[3,11,3,12],[4,11,4,12],[5,11,5,12],[2,0,4,4],[4,5,5,7],[41,1,41,3],[21,2,21,3],[22,2,22,3],[20,1,20,4],[22,11,22,12]]}
["Wetland Tool"]
[]
["3 Cell System",null,null,null,null,null,null,null,null,null,null,"Cell Liner Information"]
[null,null,null,null,null,null,null,null,null,null,"Liner Area:",70.716846421337863,null,"m²"]
[null,null,null,null,null,"Plan View of 1 Cell",null,null,null,null,"Liner Length:",5.0602394576985903,null,"m"]
[null,null,null,null,null,null,null,null,null,null,"Liner Width:",13.975000000000012,null,"m"]
[null,null,null,"Liner",null,null,null,null,null,null,null,null,null,null,null,"Liner"]
[]
[]
[null,null,null,null,null,null,"Surface Area:",null,"m²"]
[]
["Inflow BOD:",null,"mg/L",null,null,null,null,null,null,null,null,null,null,null,null,null,"Effluent BOD:"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,"mg/L"]
[]
[]
[null,null,null,null,"Thick Gravel",null,null,"Media",null,null,null,null,null,null,"Thick Gravel"]
[]
[]
[null,"Wetland Cell Summary",null,null,null,null,null,null,null,null,null,"Outputs"]
[null,"Wetland Cells:",null,null,null,null,null,null,null,null,"Total Surface Area:",128.46138986706029,null,"m²"]
[null,"Cell Volume:",null,null,"m³","Profile View of 1 Cell",null,null,null,null,"Total Media Volume:",102.76911189364824,null,"m³"]
[null,"Cell Surface Area:",null,null,"m²",null,null,null,null,null,"Concrete Blocks:",1855.4437874042321,null,"Blocks"]
[null,null,null,null,null,null,null,null,null,null,"Number of Plants:",128.46138986706029,null,"Plants"]
[]
[null,null,null,"Liner","0.75 m",null,null,null,null,null,null,null,null,null,"0.75 m","Liner"]
["Inflow BOD:",null,"mg/L",null,null,"0.01 m",null,"Water Level"]
[]
[null,null,null,null,null,null,"Volume:",null,"m³",null,null,null,null,null,null,null,null,"Wet well and cover"]
[null,null,null,null,null,null,null,null,null,"Depth:",null,"m"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Effluent outlet (variable height)"]
[]
[null,null,null,null,"Thick Gravel",null,null,"Media",null,null,null,null,null,null,"Thick Gravel","Effluent BOD:",null,null,"mg/L"]

{"sheet":"Project Team","index":10,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":true,"merged":[[0,0,1,6],[24,2,24,3]]}
["RTI/UTSB Wetlands Project Team"]

{"sheet":"Septic Tank","index":11,"n_rows":42,"n_cols":13,"rows_kept":42,"cut":false,"hidden":true,"merged":[[32,5,32,6],[0,0,1,2],[3,1,3,3],[3,10,4,13],[4,1,4,3],[5,1,5,3],[12,4,12,5]]}
["Septic Tank"]
[]
[]
[null,"Daily flow volume:",null,null,9000,"L",null,"Tank depth:",1.2,"m"]
[null,"Septic tank volume:",null,null,18000,"L",null,"Tank width:",2.1213203435596424,"m"]
[null,"Volume in m³:",null,null,18,"m³",null,"Tank length:",4.7093311627024068,"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,"3.14 m",null,null,null,"1.57 m"]
[null,null,null,null,null,null,null,null,null,null,null," "," "]
[]
[null,null,null,null,null,null,null,"4.71 m"]
[]
[]
[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)"]
["      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"}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"2.12 m"]

{"sheet":"ABR","index":12,"n_rows":42,"n_cols":16,"rows_kept":42,"cut":false,"hidden":true,"merged":[[32,6,32,7],[0,0,1,4],[7,1,10,3],[12,6,12,7],[13,0,13,1],[14,0,14,1],[15,0,15,1]]}
["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,null,null,null,null,null,"0.54 m"]
[null,null,null,null,null,null,"(liquid level)"]
["Daily flow volume:",null,10000,"L"]
["ABR volume:",null,13500,"L"]
["Volume in m³:",null,13.5,"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:",1.8371173070873836,"m"]
[null,"Tank length:",4.078400421733992,"m"]
[null,null,null,null,null,null,null,"1.36 m"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[]
[null,null,null,null,null,null,null,null,null,null,"4.08 m"]
[]
[]
[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"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"1.84 m"]