{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Macro","License","Project Description","Design Flow","Water Meter Tool","Standard Values Tool","Organic Loading","Grease Management","Laundry Management","Market Management","Flow Variability","Other Factors","Output Page"],"not_rendered":{"charts":0,"images":45,"macros":1,"external_links":0,"defined_names":1,"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 Source Characterization Tool you will need to enable Macros in Excel."]
[]
[]
[" "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Once you have enabled Macros in Excel, continue to the  Source Characterization Tool."]

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

{"sheet":"Project Description","index":2,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
["Step 1: Project Description and Treatment Information"]
[null,"\"provide the information in the boxes below and in the succeeding pages of this toolkit.  When completed, the toolkit will organize the information in an output page\""]
[]
[]
[]
["1)","Your Name:"]
[]
[]
["2)","Project Name:"]
[]
[]
["3)","Street address or location of project:"]
[]
[]
["4)","Describe Project:"]

{"sheet":"Design Flow","index":3,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":true,"merged":[[15,4,15,5],[8,10,8,11],[11,10,11,11]]}
["Step 2: Determine the Design Flow"]
[]
[]
[null,null,"In this step you will estimate the volume of wastewater each day that will require treatment. There are three methods:"]
[null,null,null,null,null,"   input boxes are yellow, output boxes are white."]
[]
[null,null,null,"A. Water Meter Readings:",null,null,null,{"$f":"'Water Meter Tool'!L17","v":0},"m³/day"]
[]
[null,null,null,null,null,null,null,null,null,null,"Or"]
[null,null,null,"B. Standard Values:",null,null,null,{"$f":"'Standard Values Tool'!M40","v":0},"m³/day"]
[]
[null,null,null,null,null,null,null,null,null,null,"Or"]
[null,null,null,"C. Review Similar Projects:",null,null,null,0,"m³/day","             Input estimate in the yellow cell to the left."]
[]
[]
[null,null," ",null,"Design Flow:",null,{"$f":"MAX(H7,H10,H13)","v":0},"m³/day"]
[null," "]

{"sheet":"Water Meter Tool","index":4,"n_rows":17,"n_cols":13,"rows_kept":17,"cut":false,"hidden":true,"merged":[[15,3,15,4],[16,3,16,4],[4,3,4,4],[5,3,5,4],[6,3,6,4],[7,3,7,4],[8,3,8,4],[11,3,11,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[9,3,9,4],[10,3,10,4]]}
["Water Meter Tool"]
[]
[null,"1. Enter Water Meter Readings from your water bill.  ",null,null,null,null,"Enter your actual water consumption in the yellow boxes."]
[]
[null,null,"MONTH","CONSUMPTION",null,"(m³/month)",null,"Average daily water consumption:",null,null,null,{"$f":"SUM(D6:E17)/30/12","v":0},"m³/day"]
[null,null,"JAN"]
[null,null,"FEB",null,null,null,null,"Peak daily flow:",null,null,null,{"$f":"MAX(D6:E17)/30","v":0},"m³/day"]
[null,null,"MAR"]
[null,null,"APR",null,null,null,null,"2. Adjustment factor "]
[null,null,"MAY",null,null,null,null,"How much water delivered is converted to wastewater:"]
[null,null,"JUN",null,null,null,null,null,"a) Take into account irrigation, car washing, etc.  "]
[null,null,"JULY",null,null,null,null,null,"b) Use .85 as a starting place for residential sewage."]
[null,null,"AUG"]
[null,null,"SEPT",null,null,null,null,null,"Enter adjustment factor here:",null,null,85,"%"]
[null,null,"OCT"]
[null,null,"NOV"]
[null,null,"DEC",null,null,null,null,null,"Wastwater Design Flow: ",null,null,{"$f":"L7*L14/100","v":0},"m³/day"]

{"sheet":"Standard Values Tool","index":5,"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,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":6,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
["Step 3: Determine Organic Loading"]
[]
[null,"1. Your hydraulic loading from step 2 is:",null,null,null,{"$f":"'Design Flow'!G16","v":0},"m³/day"]
[]
[null,"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":"+F3","v":0},"m³/day","X",0," mg/L BOD"]
[]
[null,null,null,null,{"$f":"+E20*H20/1000","v":0},"BOD - Kg/day"]

{"sheet":"Grease Management","index":7,"n_rows":15,"n_cols":1,"rows_kept":15,"cut":false,"hidden":true,"merged":[[14,0,14,11]]}
["Step 4: Determining Pre-treatment Needs – Grease"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Are their food service, utensil washing or food manufacturing activities at your facility?"]

{"sheet":"Laundry Management","index":8,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["Step 5: Determining Pre-treatment Needs – Commercial laundry services"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Are there laundry operations at your facility?"]

{"sheet":"Market Management","index":9,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["Step 6: Determining Pre-treatment Needs – Markets"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Are there high concentrations of solids, debris or trash that may enter the sewer pipes or channel?"]

{"sheet":"Flow Variability","index":10,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["Step 7: Flow Variability"]
[]
[]
[]
[null,"1. Are there certain days of the week where the flow is significantly higher or lower than other days (i.e. Churches)? "]
[null,null,"If yes, consider using flow equalization methods."]
[]
[]
[]
[null,"2.  Does your project experience seasonal variability (i.e. Resorts)?  "]
[null,null,"If yes, take this into account when designing the facility. "]

{"sheet":"Other Factors","index":11,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
["Step 8: Other Factors to Consider"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Provide a brief description (max. 100 characters) of other factors to consider in developing your project."]

{"sheet":"Output Page","index":12,"n_rows":34,"n_cols":14,"rows_kept":34,"cut":false,"hidden":true,"merged":[[30,10,30,14],[35,1,37,16],[38,2,38,15],[13,5,13,6],[30,5,30,9],[33,4,34,16],[14,0,15,0],[4,4,4,9],[8,4,8,9],[26,5,26,6],[28,5,28,6],[22,1,22,5],[22,6,22,17],[4,11,4,12],[4,13,4,16],[12,6,12,8],[12,9,12,11],[12,12,12,14],[10,5,10,12],[6,4,6,9],[14,1,15,16]]}
["Output Page for Project"]
[]
["1)","Project Information:"]
[]
[null,"Your Name:",null,null,null,null,null,null,null,null,null,"Date:",null,"2012-02-21"]
[]
[null,"Project Name:"]
[]
[null,"Source Type:"]
[]
[null,"Project Location:"]
[]
[null,"Pretreatment Devices:"]
[]
["2)","Based on your inputs, a typical wastewater system configuration for your identified source might look like this:"]
[]
[]
[]
[]
[]
[]
[]
[null,"For More Information Visit:",null,null,null,null,{"$f":"HYPERLINK(\"http://watsanexp.ning.com/page/getting-started\")","v":"http://watsanexp.ning.com/page/getting-started"}]
[]
["3)","Use the following information about your project for next steps:"]
[]
[null,"Hydraulic Loading:",null,null,null,0,null,"m³/day"]
[]
[null,"Organic Loading:",null,null,null,0,null,"BOD/day"]
[]
[null,"Flow Variability:"]
[]
[]
[null,"Other Issues:"]