{"text_format":"1","workbook":"xls","n_sheets":2,"sheets":["Staffing","Final Table"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":1,"defined_names":15,"comments":685,"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","formulas":"cached_only"}

{"sheet":"Staffing","index":0,"n_rows":698,"n_cols":35,"rows_kept":698,"cut":false,"hidden":false,"merged":[[1,0,1,6],[0,0,0,6]],"flags":["formulas_cached_only"]}
[]
["THE NORTHEAST GUIDE FOR ESTIMATING STAFFING AT PUBLICLY AND PRIVATELY OWNED WASTEWATER TREATMENT PLANTS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Staffing Choices","Choice","Values",null,"Design Flow Choices","Choice",null,"Unit # Choices",null,"Ranges",null,null,"Testing",null,"Yard work",null,null,null,null,"Activity",null,"SCADA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"One Shift",1,260,null,"0.25-0.5 mgd",7,null,0,null,1.5,2,null,1,null,100,60,100,60,null,0.1,null,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"One Plus Shift",null,null,null,"0.5-1.0 mgd",null,null,1,null,2.25,2.5,null,2,null,200,120,120,80,null,0.2,null,"No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"24/7",null,null,null,"1.0-5.0 mgd",null,null,2,null,3,3,null,4,"Weekly",400,400,400,160,null,0.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5.0-10.0 mgd",null,null,3,null,4.5,null,null,12,"Quarterly",null,null,null,null,null,0.45]
[null,null,null,"Total Staffing Hours:",0,null,null,null,null,null,null,null,null,null,null,null,null,"10.0-20.0 mgd",null,null,4,null,6,null,null,26,null,null,null,null,null,null,0.6]
["Data Notes","# of Units","Design Flow","Process/Activity/Flow","Hours","Calculated","Subtotal",null,null,null,null,null,null,null,null,null,null,">20 mgd",null,null,5,null,7,null,null,39]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Default",null,null,6,null,8,8,null,52,"Monthly"]
[null,null,null,"Begin Chart 1 – Basic and Advanced Operations and Processes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,null,9,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,10.5,10]
["Data Notes","# of Units","Design Flow","Process","Hours","Calculated","Subtotal",null,null,null,null,null,null,null,null,null,null,null,null,null,9,null,12,12.5]
[null,null,"0.25-0.5 mgd","Preliminary Treatment",0.5,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,18,15]
["# of units",null,"0.25-0.5 mgd","Primary Clarification",0.5,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,null,24]
[null,null,"0.25-0.5 mgd","Activated Sludge",2,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[null,null,"0.25-0.5 mgd","Activated Sludge w/BNR",3,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13]
[null,null,"0.25-0.5 mgd","Rotating Biological Contactor",1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14]
["# of tanks",null,"0.25-0.5 mgd","Sequencing Batch Reactor",1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15]
[null,null,"0.25-0.5 mgd","Extended Aeration (w/o primary)",2.5,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16]
[null,null,"0.25-0.5 mgd","Extended Aeration w/BNR",3.5,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17]
[null,null,"0.25-0.5 mgd","Pure Oxygen Facility","X",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18]
[null,null,"0.25-0.5 mgd","Pure Oxygen Facility w/BNR","X",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19]
[null,null,"0.25-0.5 mgd","Trickling Filter",1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[null,null,"0.25-0.5 mgd","Oxidation Ditch (w/o primary)",2.5,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21]
[null,null,"0.25-0.5 mgd","Oxidation Ditch w/BNR",3.5,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22]
[null,null,"0.25-0.5 mgd","Aeration Lagoon",1.5,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23]
[null,null,"0.25-0.5 mgd","Stabilization Pond",1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24]
[null,null,"0.25-0.5 mgd","Innovative Alternative Technologies",2,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25]
[null,null,"0.25-0.5 mgd","Nitrification",0.25,0]
[null,null,"0.25-0.5 mgd","Denitrification",0.25,0]
[null,null,"0.25-0.5 mgd","Phosphorus Removal (Biological)",0.25,0]
[null,null,"0.25-0.5 mgd","Phosphorus Removal (Chemical/Physical)",0.25,0]
[null,null,"0.25-0.5 mgd","Membrane Processes",0.25,0]
[null,null,"0.25-0.5 mgd","Cloth Filtration",0.25,0]
[null,null,"0.25-0.5 mgd","Granular Media Filters (Carbon, sand, anthracite, garnet)",0.5,0]
[null,null,"0.25-0.5 mgd","Water Reuse",0.25,0]
[null,null,"0.25-0.5 mgd","Plant Reuse Water",0.1,0]
[null,null,"0.25-0.5 mgd","Chlorination",0.5,0]
[null,null,"0.25-0.5 mgd","Dechlorination",0.5,0]
[null,null,"0.25-0.5 mgd","Ultraviolet Disinfection",0.5,0]
["# of units",null,"0.25-0.5 mgd","Wet Odor Control",0.5,0]
["# of units",null,"0.25-0.5 mgd","Dry Odor Control",0.25,0]
[null,null,"0.25-0.5 mgd","Septage Handling",0.5,0]
[null,null,"0.5-1.0 mgd","Preliminary Treatment",0.5,0]
["# of units",null,"0.5-1.0 mgd","Primary Clarification",0.5,0]
[null,null,"0.5-1.0 mgd","Activated Sludge",4,0]
[null,null,"0.5-1.0 mgd","Activated Sludge w/BNR",6,0]
["Choose Range",null,"0.5-1.0 mgd","Rotating Biological Contactor",2.25,0]
["# of tanks",null,"0.5-1.0 mgd","Sequencing Batch Reactor",1,0]
[null,null,"0.5-1.0 mgd","Extended Aeration (w/o primary)",5,0]
[null,null,"0.5-1.0 mgd","Extended Aeration w/BNR",7,0]
[null,null,"0.5-1.0 mgd","Pure Oxygen Facility","X"]
[null,null,"0.5-1.0 mgd","Pure Oxygen Facility w/BNR","X"]
[null,null,"0.5-1.0 mgd","Trickling Filter",1,0]
[null,null,"0.5-1.0 mgd","Oxidation Ditch (w/o primary)",5,0]
[null,null,"0.5-1.0 mgd","Oxidation Ditch w/BNR",7,0]
[null,null,"0.5-1.0 mgd","Aeration Lagoon",1.5,0]
[null,null,"0.5-1.0 mgd","Stabilization Pond",1,0]
[null,null,"0.5-1.0 mgd","Innovative Alternative Technologies",3,0]
[null,null,"0.5-1.0 mgd","Nitrification",0.25,0]
[null,null,"0.5-1.0 mgd","Denitrification",0.25,0]
[null,null,"0.5-1.0 mgd","Phosphorus Removal (Biological)",0.25,0]
[null,null,"0.5-1.0 mgd","Phosphorus Removal (Chemical/Physical)",0.5,0]
[null,null,"0.5-1.0 mgd","Membrane Processes",0.25,0]
[null,null,"0.5-1.0 mgd","Cloth Filtration",0.25,0]
[null,null,"0.5-1.0 mgd","Granular Media Filters (Carbon, sand, anthracite, garnet)",1,0]
[null,null,"0.5-1.0 mgd","Water Reuse",0.25,0]
[null,null,"0.5-1.0 mgd","Plant Reuse Water",0.1,0]
[null,null,"0.5-1.0 mgd","Chlorination",0.5,0]
[null,null,"0.5-1.0 mgd","Dechlorination",0.5,0]
[null,null,"0.5-1.0 mgd","Ultraviolet Disinfection",0.5,0]
["# of units",null,"0.5-1.0 mgd","Wet Odor Control",0.5,0]
["# of units",null,"0.5-1.0 mgd","Dry Odor Control",0.25,0]
[null,null,"0.5-1.0 mgd","Septage Handling",0.5,0]
[null,null,"1.0-5.0 mgd","Preliminary Treatment",1,0]
["# of units",null,"1.0-5.0 mgd","Primary Clarification",0.5,0]
[null,null,"1.0-5.0 mgd","Activated Sludge",6,0]
[null,null,"1.0-5.0 mgd","Activated Sludge w/BNR",8,0]
["Choose Range",null,"1.0-5.0 mgd","Rotating Biological Contactor",6,0]
["# of tanks",null,"1.0-5.0 mgd","Sequencing Batch Reactor",1,0]
[null,null,"1.0-5.0 mgd","Extended Aeration (w/o primary)",8,0]
[null,null,"1.0-5.0 mgd","Extended Aeration w/BNR",10,0]
[null,null,"1.0-5.0 mgd","Pure Oxygen Facility","X"]
[null,null,"1.0-5.0 mgd","Pure Oxygen Facility w/BNR","X"]
[null,null,"1.0-5.0 mgd","Trickling Filter",2,0]
[null,null,"1.0-5.0 mgd","Oxidation Ditch (w/o primary)",8,0]
[null,null,"1.0-5.0 mgd","Oxidation Ditch w/BNR",10,0]
[null,null,"1.0-5.0 mgd","Aeration Lagoon",1.5,0]
[null,null,"1.0-5.0 mgd","Stabilization Pond",1,0]
[null,null,"1.0-5.0 mgd","Innovative Alternative Technologies","X"]
[null,null,"1.0-5.0 mgd","Nitrification",0.5,0]
[null,null,"1.0-5.0 mgd","Denitrification",0.5,0]
[null,null,"1.0-5.0 mgd","Phosphorus Removal (Biological)",0.5,0]
[null,null,"1.0-5.0 mgd","Phosphorus Removal (Chemical/Physical)",1,0]
[null,null,"1.0-5.0 mgd","Membrane Processes",0.5,0]
[null,null,"1.0-5.0 mgd","Cloth Filtration",0.5,0]
[null,null,"1.0-5.0 mgd","Granular Media Filters (Carbon, sand, anthracite, garnet)",1,0]
[null,null,"1.0-5.0 mgd","Water Reuse",0.5,0]
[null,null,"1.0-5.0 mgd","Plant Reuse Water",0.1,0]
[null,null,"1.0-5.0 mgd","Chlorination",1,0]
[null,null,"1.0-5.0 mgd","Dechlorination",1,0]
[null,null,"1.0-5.0 mgd","Ultraviolet Disinfection",1,0]
["# of units",null,"1.0-5.0 mgd","Wet Odor Control",1,0]
["# of units",null,"1.0-5.0 mgd","Dry Odor Control",0.5,0]
[null,null,"1.0-5.0 mgd","Septage Handling",1,0]
[null,null,"5.0-10.0 mgd","Preliminary Treatment",2,0]
["# of units",null,"5.0-10.0 mgd","Primary Clarification",1,0]
["Choose Range",null,"5.0-10.0 mgd","Activated Sludge",7,0]
["Choose Range",null,"5.0-10.0 mgd","Activated Sludge w/BNR",9,0]
[null,null,"5.0-10.0 mgd","Rotating Biological Contactor",6,0]
["# of tanks",null,"5.0-10.0 mgd","Sequencing Batch Reactor",1,0]
[null,null,"5.0-10.0 mgd","Extended Aeration (w/o primary)","X"]
[null,null,"5.0-10.0 mgd","Extended Aeration w/BNR","X"]
["Choose Range",null,"5.0-10.0 mgd","Pure Oxygen Facility",9,0]
["Choose Range",null,"5.0-10.0 mgd","Pure Oxygen Facility w/BNR",10,0]
[null,null,"5.0-10.0 mgd","Trickling Filter",3,0]
[null,null,"5.0-10.0 mgd","Oxidation Ditch (w/o primary)","X"]
[null,null,"5.0-10.0 mgd","Oxidation Ditch w/BNR","X"]
[null,null,"5.0-10.0 mgd","Aeration Lagoon","X"]
[null,null,"5.0-10.0 mgd","Stabilization Pond","X"]
[null,null,"5.0-10.0 mgd","Innovative Alternative Technologies","X"]
[null,null,"5.0-10.0 mgd","Nitrification",0.5,0]
[null,null,"5.0-10.0 mgd","Denitrification",0.5,0]
[null,null,"5.0-10.0 mgd","Phosphorus Removal (Biological)",0.5,0]
[null,null,"5.0-10.0 mgd","Phosphorus Removal (Chemical/Physical)",2,0]
[null,null,"5.0-10.0 mgd","Membrane Processes",0.5,0]
[null,null,"5.0-10.0 mgd","Cloth Filtration",0.5,0]
[null,null,"5.0-10.0 mgd","Granular Media Filters (Carbon, sand, anthracite, garnet)",1.5,0]
[null,null,"5.0-10.0 mgd","Water Reuse",0.5,0]
[null,null,"5.0-10.0 mgd","Plant Reuse Water",0.15,0]
[null,null,"5.0-10.0 mgd","Chlorination",1,0]
[null,null,"5.0-10.0 mgd","Dechlorination",1,0]
[null,null,"5.0-10.0 mgd","Ultraviolet Disinfection",1,0]
["# of units",null,"5.0-10.0 mgd","Wet Odor Control",1,0]
["# of units",null,"5.0-10.0 mgd","Dry Odor Control",0.5,0]
[null,null,"5.0-10.0 mgd","Septage Handling",1,0]
[null,null,"10.0-20.0 mgd","Preliminary Treatment",3,0]
["# of units",null,"10.0-20.0 mgd","Primary Clarification",1,0]
["Choose Range",null,"10.0-20.0 mgd","Activated Sludge",8,0]
["Choose Range",null,"10.0-20.0 mgd","Activated Sludge w/BNR",12,0]
[null,null,"10.0-20.0 mgd","Rotating Biological Contactor","X"]
["# of tanks",null,"10.0-20.0 mgd","Sequencing Batch Reactor",1,0]
[null,null,"10.0-20.0 mgd","Extended Aeration (w/o primary)","X"]
[null,null,"10.0-20.0 mgd","Extended Aeration w/BNR","X"]
[null,null,"10.0-20.0 mgd","Pure Oxygen Facility",10,0]
[null,null,"10.0-20.0 mgd","Pure Oxygen Facility w/BNR",15,0]
[null,null,"10.0-20.0 mgd","Trickling Filter",4,0]
[null,null,"10.0-20.0 mgd","Oxidation Ditch (w/o primary)","X"]
[null,null,"10.0-20.0 mgd","Oxidation Ditch w/BNR","X"]
[null,null,"10.0-20.0 mgd","Aeration Lagoon","X"]
[null,null,"10.0-20.0 mgd","Stabilization Pond","X"]
[null,null,"10.0-20.0 mgd","Innovative Alternative Technologies","X"]
[null,null,"10.0-20.0 mgd","Nitrification",1,0]
[null,null,"10.0-20.0 mgd","Denitrification",1,0]
[null,null,"10.0-20.0 mgd","Phosphorus Removal (Biological)",1,0]
[null,null,"10.0-20.0 mgd","Phosphorus Removal (Chemical/Physical)",3,0]
[null,null,"10.0-20.0 mgd","Membrane Processes",1,0]
[null,null,"10.0-20.0 mgd","Cloth Filtration",0.5,0]
[null,null,"10.0-20.0 mgd","Granular Media Filters (Carbon, sand, anthracite, garnet)",1.5,0]
[null,null,"10.0-20.0 mgd","Water Reuse",0.5,0]
[null,null,"10.0-20.0 mgd","Plant Reuse Water",0.25,0]
[null,null,"10.0-20.0 mgd","Chlorination",1,0]
[null,null,"10.0-20.0 mgd","Dechlorination",1,0]
[null,null,"10.0-20.0 mgd","Ultraviolet Disinfection",1,0]
["# of units",null,"10.0-20.0 mgd","Wet Odor Control",1,0]
["# of units",null,"10.0-20.0 mgd","Dry Odor Control",0.5,0]
[null,null,"10.0-20.0 mgd","Septage Handling",1,0]
[null,null,">20 mgd","Preliminary Treatment",4,0]
["# of units",null,">20 mgd","Primary Clarification",1,0]
[null,null,">20 mgd","Activated Sludge",24,0]
[null,null,">20 mgd","Activated Sludge w/BNR",28,0]
[null,null,">20 mgd","Rotating Biological Contactor","X"]
["# of  tanks",null,">20 mgd","Sequencing Batch Reactor",1,0]
[null,null,">20 mgd","Extended Aeration (w/o primary)","X"]
[null,null,">20 mgd","Extended Aeration w/BNR","X"]
[null,null,">20 mgd","Pure Oxygen Facility",18,0]
[null,null,">20 mgd","Pure Oxygen Facility w/BNR",24,0]
[null,null,">20 mgd","Trickling Filter",8,0]
[null,null,">20 mgd","Oxidation Ditch (w/o primary)","X"]
[null,null,">20 mgd","Oxidation Ditch w/BNR","X"]
[null,null,">20 mgd","Aeration Lagoon","X"]
[null,null,">20 mgd","Stabilization Pond","X"]
[null,null,">20 mgd","Innovative Alternative Technologies","X"]
[null,null,">20 mgd","Nitrification",2,0]
[null,null,">20 mgd","Denitrification",2,0]
[null,null,">20 mgd","Phosphorus Removal (Biological)",2,0]
[null,null,">20 mgd","Phosphorus Removal (Chemical/Physical)",4,0]
[null,null,">20 mgd","Membrane Processes",1,0]
[null,null,">20 mgd","Cloth Filtration",0.5,0]
[null,null,">20 mgd","Granular Media Filters (Carbon, sand, anthracite, garnet)",3,0]
[null,null,">20 mgd","Water Reuse",0.5,0]
[null,null,">20 mgd","Plant Reuse Water",0.25,0]
[null,null,">20 mgd","Chlorination",1,0]
[null,null,">20 mgd","Dechlorination",1,0]
[null,null,">20 mgd","Ultraviolet Disinfection",1,0]
["# of units",null,">20 mgd","Wet Odor Control",1,0]
["# of units",null,">20 mgd","Dry Odor Control",0.5,0]
[null,null,">20 mgd","Septage Handling",1,0]
[null,null,"All"]
[null,null,"All","End of Chart 1 – Basic and Advanced Operations and Processes SUBTOTAL:",null,null,0]
[null,null,"All"]
[null,null,"All","* Secondary Clarification has been built into basic operations processes."]
[null,null,"All","* Activated Sludge process includes RAS and WAS pumping."]
[null,null,"All"]
[null,null,"All"]
[null,null,"All"]
[null,null,"All"]
[null,null,"All","Begin Chart 2 – Maintenance"]
[null,null,"All"]
["Unit Descriptons","# of Units","All","Activity/Flow","Hours","Calculated","Subtotal"]
["# of screens",null,"0.25-0.5 mgd","Manually Cleaned Screens",0.25,0]
["# of screens",null,"0.25-0.5 mgd","Mechanically Cleaned Screens",0.25,0]
["# of screens",null,"0.25-0.5 mgd","Mechanically Cleaned Screens with grinders/washer/         compactors",0.25,0]
["# of units",null,"0.25-0.5 mgd","Comminutor/Macerator",0.25,0]
["# of chambers",null,"0.25-0.5 mgd","Aerated Grit Chambers",0.1,0]
["# of units",null,"0.25-0.5 mgd","Vortex Grit Removal",0.1,0]
["# of units",null,"0.25-0.5 mgd","Gravity Grit Removal",0.1,0]
[]
["# of tanks",null,"0.25-0.5 mgd","Additional Process Tanks",0.1,0]
["# of chemicals added for processes",null,"0.25-0.5 mgd","Chemical Addition (varying dependent upon degree of treatment)",0.1,0]
["# of clarifiers",null,"0.25-0.5 mgd","Circular Clarifiers",0.25,0]
["# of clarifiers",null,"0.25-0.5 mgd","Chain and Flight Clarifiers",0.25,0]
["# of clarifiers",null,"0.25-0.5 mgd","Traveling Bridge Clarifiers","X"]
["# of clarifiers",null,"0.25-0.5 mgd","Squircle Clarifiers",0.25,0]
["X",null,"0.25-0.5 mgd","Pumps",100,0]
["# of trains",null,"0.25-0.5 mgd","Rotating Biological Contactor",0.15,0]
["# of TFs",null,"0.25-0.5 mgd","Trickling Filters",0.15,0]
["# of tanks",null,"0.25-0.5 mgd","Sequencing Batch Reactor",0.15,0]
["# of mixers",null,"0.25-0.5 mgd","Mechanical Mixers",0.1,0]
["# of blowers",null,"0.25-0.5 mgd","Aeration Blowers",0.2,0]
["# of cartridges",null,"0.25-0.5 mgd","Membrane Bioreactor",0.1,0]
["# of systems",null,"0.25-0.5 mgd","Subsurface Disposal System",0.1,0]
["X",null,"0.25-0.5 mgd","Groundwater Discharge",0.1,0]
["# of digesters",null,"0.25-0.5 mgd","Aerobic Digestion",0.1,0]
["# of digesters",null,"0.25-0.5 mgd","Anaerobic Digestion","X"]
["# of basins",null,"0.25-0.5 mgd","Gravity Thickening",0.1,0]
["# of belts",null,"0.25-0.5 mgd","Gravity Belt Thickening",0.15,0]
["# of presses",null,"0.25-0.5 mgd","Belt Filter Press",0.15,0]
["# of units",null,"0.25-0.5 mgd","Mechanical Dewatering (Plate Frame and Centrifuges)",0.15,0]
["# of units",null,"0.25-0.5 mgd","Dissolved Air Floatation","X"]
["X",null,"0.25-0.5 mgd","Chlorination (gas)",0.1,0]
["X",null,"0.25-0.5 mgd","Chlorination (liq.)",0.2,0]
["X",null,"0.25-0.5 mgd","Dechlorination (gas)",0.1,0]
["X",null,"0.25-0.5 mgd","Dechlorination (liq.)",0.2,0]
["# of racks",null,"0.25-0.5 mgd","Ultraviolet",0.1,0]
["# of units",null,"0.25-0.5 mgd","Biofilter",0.5,0]
["# of units",null,"0.25-0.5 mgd","Activated Carbon",0.5,0]
["# of units",null,"0.25-0.5 mgd","Wet Scrubbers","X"]
["# of screens",null,"0.25-0.5 mgd","Microscreens",0.1,0]
["# of units",null,"0.25-0.5 mgd","Pure Oxygen","X"]
["# of units",null,"0.25-0.5 mgd","Final Sand Filters",0.2,0]
["# of different types of probes",null,"0.25-0.5 mgd","Probes/Instrumentation/Calibration",0.1,0]
["# of screens",null,"0.5-1.0 mgd","Manually Cleaned Screens",0.25,0]
["# of screens",null,"0.5-1.0 mgd","Mechanically Cleaned Screens",0.25,0]
["# of screens",null,"0.5-1.0 mgd","Mechanically Cleaned Screens with grinders/washer/         compactors",0.5,0]
["# of units",null,"0.5-1.0 mgd","Comminutor/Macerator",0.25,0]
["# of chambers",null,"0.5-1.0 mgd","Aerated Grit Chambers",0.1,0]
["# of units",null,"0.5-1.0 mgd","Vortex Grit Removal",0.1,0]
["# of units",null,"0.5-1.0 mgd","Gravity Grit Removal",0.1,0]
[]
["# of tanks",null,"0.5-1.0 mgd","Additional Process Tanks",0.1,0]
["# of chemicals added for processes",null,"0.5-1.0 mgd","Chemical Addition (varying dependent upon degree of treatment)",0.1,0]
["# of clarifiers",null,"0.5-1.0 mgd","Circular Clarifiers",0.25,0]
["# of clarifiers",null,"0.5-1.0 mgd","Chain and Flight Clarifiers",0.25,0]
["# of clarifiers",null,"0.5-1.0 mgd","Traveling Bridge Clarifiers","X"]
["# of clarifiers",null,"0.5-1.0 mgd","Squircle Clarifiers",0.25,0]
["X",null,"0.5-1.0 mgd","Pumps",100,0]
["# of trains",null,"0.5-1.0 mgd","Rotating Biological Contactor",0.15,0]
["# of TFs",null,"0.5-1.0 mgd","Trickling Filters",0.15,0]
["# of tanks",null,"0.5-1.0 mgd","Sequencing Batch Reactor",0.15,0]
["# of mixers",null,"0.5-1.0 mgd","Mechanical Mixers",0.1,0]
["# of blowers",null,"0.5-1.0 mgd","Aeration Blowers",0.2,0]
["# of cartridges",null,"0.5-1.0 mgd","Membrane Bioreactor",0.1,0]
["# of systems",null,"0.5-1.0 mgd","Subsurface Disposal System",0.1,0]
["X",null,"0.5-1.0 mgd","Groundwater Discharge",0.1,0]
["# of digesters",null,"0.5-1.0 mgd","Aerobic Digestion",0.1,0]
["# of digesters",null,"0.5-1.0 mgd","Anaerobic Digestion",0.2,0]
["# of basins",null,"0.5-1.0 mgd","Gravity Thickening",0.1,0]
["# of belts",null,"0.5-1.0 mgd","Gravity Belt Thickening",0.15,0]
["# of presses",null,"0.5-1.0 mgd","Belt Filter Press",0.15,0]
["# of units",null,"0.5-1.0 mgd","Mechanical Dewatering (Plate Frame and Centrifuges)",0.15,0]
["# of units",null,"0.5-1.0 mgd","Dissolved Air Floatation",0.1,0]
["X",null,"0.5-1.0 mgd","Chlorination (gas)",0.1,0]
["X",null,"0.5-1.0 mgd","Chlorination (liq.)",0.2,0]
["X",null,"0.5-1.0 mgd","Dechlorination (gas)",0.1,0]
["X",null,"0.5-1.0 mgd","Dechlorination (liq.)",0.2,0]
["# of racks",null,"0.5-1.0 mgd","Ultraviolet",0.1,0]
["# of units",null,"0.5-1.0 mgd","Biofilter",0.5,0]
["# of units",null,"0.5-1.0 mgd","Activated Carbon",0.5,0]
["# of units",null,"0.5-1.0 mgd","Wet Scrubbers","X"]
["# of screens",null,"0.5-1.0 mgd","Microscreens",0.1,0]
["# of units",null,"0.5-1.0 mgd","Pure Oxygen","X"]
["# of units",null,"0.5-1.0 mgd","Final Sand Filters",0.2,0]
["# of different types of probes",null,"0.5-1.0 mgd","Probes/Instrumentation/Calibration",0.1,0]
["# of screens",null,"1.0-5.0 mgd","Manually Cleaned Screens",0.25,0]
["# of screens",null,"1.0-5.0 mgd","Mechanically Cleaned Screens",0.25,0]
["# of screens",null,"1.0-5.0 mgd","Mechanically Cleaned Screens with grinders/washer/         compactors",1,0]
["# of units",null,"1.0-5.0 mgd","Comminutor/Macerator",0.25,0]
["# of chambers",null,"1.0-5.0 mgd","Aerated Grit Chambers",0.25,0]
["# of units",null,"1.0-5.0 mgd","Vortex Grit Removal",0.25,0]
["# of units",null,"1.0-5.0 mgd","Gravity Grit Removal",0.15,0]
[]
["# of tanks",null,"1.0-5.0 mgd","Additional Process Tanks",0.1,0]
["# of chemicals added for processes",null,"1.0-5.0 mgd","Chemical Addition (varying dependent upon degree of treatment)",0.1,0]
["# of clarifiers",null,"1.0-5.0 mgd","Circular Clarifiers",0.5,0]
["# of clarifiers",null,"1.0-5.0 mgd","Chain and Flight Clarifiers",0.5,0]
["# of clarifiers",null,"1.0-5.0 mgd","Traveling Bridge Clarifiers","X"]
["# of clarifiers",null,"1.0-5.0 mgd","Squircle Clarifiers",0.5,0]
["X",null,"1.0-5.0 mgd","Pumps",250,0]
["# of trains",null,"1.0-5.0 mgd","Rotating Biological Contactor",0.25,0]
["# of TFs",null,"1.0-5.0 mgd","Trickling Filters",0.15,0]
["# of tanks",null,"1.0-5.0 mgd","Sequencing Batch Reactor",0.15,0]
["# of mixers",null,"1.0-5.0 mgd","Mechanical Mixers",0.1,0]
["# of blowers",null,"1.0-5.0 mgd","Aeration Blowers",0.2,0]
["# of cartridges",null,"1.0-5.0 mgd","Membrane Bioreactor",0.1,0]
["# of systems",null,"1.0-5.0 mgd","Subsurface Disposal System",0.1,0]
["X",null,"1.0-5.0 mgd","Groundwater Discharge",0.1,0]
["# of digesters",null,"1.0-5.0 mgd","Aerobic Digestion",0.1,0]
["# of digesters",null,"1.0-5.0 mgd","Anaerobic Digestion",0.2,0]
["# of basins",null,"1.0-5.0 mgd","Gravity Thickening",0.1,0]
["# of belts",null,"1.0-5.0 mgd","Gravity Belt Thickening",0.15,0]
["# of presses",null,"1.0-5.0 mgd","Belt Filter Press",0.15,0]
["# of units",null,"1.0-5.0 mgd","Mechanical Dewatering (Plate Frame and Centrifuges)",0.15,0]
["# of units",null,"1.0-5.0 mgd","Dissolved Air Floatation",0.1,0]
["X",null,"1.0-5.0 mgd","Chlorination (gas)",0.1,0]
["X",null,"1.0-5.0 mgd","Chlorination (liq.)",0.2,0]
["X",null,"1.0-5.0 mgd","Dechlorination (gas)",0.1,0]
["X",null,"1.0-5.0 mgd","Dechlorination (liq.)",0.2,0]
["# of racks",null,"1.0-5.0 mgd","Ultraviolet",0.1,0]
["# of units",null,"1.0-5.0 mgd","Biofilter",0.5,0]
["# of units",null,"1.0-5.0 mgd","Activated Carbon",0.5,0]
["# of units",null,"1.0-5.0 mgd","Wet Scrubbers","X"]
["# of screens",null,"1.0-5.0 mgd","Microscreens",0.1,0]
["# of units",null,"1.0-5.0 mgd","Pure Oxygen","X"]
["# of units",null,"1.0-5.0 mgd","Final Sand Filters",0.2,0]
["# of different types of probes",null,"1.0-5.0 mgd","Probes/Instrumentation/Calibration",0.1,0]
["# of screens",null,"5.0-10.0 mgd","Manually Cleaned Screens",0.25,0]
["# of screens",null,"5.0-10.0 mgd","Mechanically Cleaned Screens",1,0]
["# of screens",null,"5.0-10.0 mgd","Mechanically Cleaned Screens with grinders/washer/         compactors",2,0]
["# of units",null,"5.0-10.0 mgd","Comminutor/Macerator",0.5,0]
["# of chambers",null,"5.0-10.0 mgd","Aerated Grit Chambers",0.5,0]
["# of units",null,"5.0-10.0 mgd","Vortex Grit Removal",0.5,0]
["# of units",null,"5.0-10.0 mgd","Gravity Grit Removal",0.2,0]
[]
["# of tanks",null,"5.0-10.0 mgd","Additional Process Tanks",0.1,0]
["# of chemicals added for processes",null,"5.0-10.0 mgd","Chemical Addition (varying dependent upon degree of treatment)",0.1,0]
["# of clarifiers",null,"5.0-10.0 mgd","Circular Clarifiers",0.5,0]
["# of clarifiers",null,"5.0-10.0 mgd","Chain and Flight Clarifiers",0.5,0]
["# of clarifiers",null,"5.0-10.0 mgd","Traveling Bridge Clarifiers","X"]
["# of clarifiers",null,"5.0-10.0 mgd","Squircle Clarifiers",0.5,0]
["X",null,"5.0-10.0 mgd","Pumps",500,0]
["# of trains",null,"5.0-10.0 mgd","Rotating Biological Contactor",0.25,0]
["# of TFs",null,"5.0-10.0 mgd","Trickling Filters",0.25,0]
["# of tanks",null,"5.0-10.0 mgd","Sequencing Batch Reactor",0.25,0]
["# of mixers",null,"5.0-10.0 mgd","Mechanical Mixers",0.1,0]
["# of blowers",null,"5.0-10.0 mgd","Aeration Blowers",0.2,0]
["# of cartridges",null,"5.0-10.0 mgd","Membrane Bioreactor",0.2,0]
["# of systems",null,"5.0-10.0 mgd","Subsurface Disposal System",0.1,0]
["X",null,"5.0-10.0 mgd","Groundwater Discharge",0.1,0]
["# of digesters",null,"5.0-10.0 mgd","Aerobic Digestion",0.1,0]
["# of digesters",null,"5.0-10.0 mgd","Anaerobic Digestion",0.3,0]
["# of basins",null,"5.0-10.0 mgd","Gravity Thickening",0.1,0]
["# of belts",null,"5.0-10.0 mgd","Gravity Belt Thickening",0.25,0]
["# of presses",null,"5.0-10.0 mgd","Belt Filter Press",0.25,0]
["# of units",null,"5.0-10.0 mgd","Mechanical Dewatering (Plate Frame and Centrifuges)",0.25,0]
["# of units",null,"5.0-10.0 mgd","Dissolved Air Floatation",0.1,0]
["X",null,"5.0-10.0 mgd","Chlorination (gas)",0.2,0]
["X",null,"5.0-10.0 mgd","Chlorination (liq.)",0.3,0]
["X",null,"5.0-10.0 mgd","Dechlorination (gas)",0.2,0]
["X",null,"5.0-10.0 mgd","Dechlorination (liq.)",0.3,0]
["# of racks",null,"5.0-10.0 mgd","Ultraviolet",0.15,0]
["# of units",null,"5.0-10.0 mgd","Biofilter",0.5,0]
["# of units",null,"5.0-10.0 mgd","Activated Carbon",0.75,0]
["# of units",null,"5.0-10.0 mgd","Wet Scrubbers",0.15,0]
["# of screens",null,"5.0-10.0 mgd","Microscreens",0.15,0]
["# of units",null,"5.0-10.0 mgd","Pure Oxygen",0.2,0,"`"]
["# of units",null,"5.0-10.0 mgd","Final Sand Filters",0.2,0]
["# of different types of probes",null,"5.0-10.0 mgd","Probes/Instrumentation/Calibration",0.1,0]
["# of screens",null,"10.0-20.0 mgd","Manually Cleaned Screens",0.5,0]
["# of screens",null,"10.0-20.0 mgd","Mechanically Cleaned Screens",3,0]
["# of screens",null,"10.0-20.0 mgd","Mechanically Cleaned Screens with grinders/washer/         compactors",4,0]
["# of units",null,"10.0-20.0 mgd","Comminutor/Macerator",0.75,0]
["# of chambers",null,"10.0-20.0 mgd","Aerated Grit Chambers",0.75,0]
["# of units",null,"10.0-20.0 mgd","Vortex Grit Removal",0.75,0]
["# of units",null,"10.0-20.0 mgd","Gravity Grit Removal",0.25,0]
[]
["# of tanks",null,"10.0-20.0 mgd","Additional Process Tanks",0.1,0]
["# of chemicals added for processes",null,"10.0-20.0 mgd","Chemical Addition (varying dependent upon degree of treatment)",0.3,0]
["# of clarifiers",null,"10.0-20.0 mgd","Circular Clarifiers",0.75,0]
["# of clarifiers",null,"10.0-20.0 mgd","Chain and Flight Clarifiers",0.75,0]
["# of clarifiers",null,"10.0-20.0 mgd","Traveling Bridge Clarifiers",0.75,0]
["# of clarifiers",null,"10.0-20.0 mgd","Squircle Clarifiers",0.75,0]
["X",null,"10.0-20.0 mgd","Pumps",750,0]
["# of trains",null,"10.0-20.0 mgd","Rotating Biological Contactor","X"]
["# of TFs",null,"10.0-20.0 mgd","Trickling Filters",0.4,0]
["# of tanks",null,"10.0-20.0 mgd","Sequencing Batch Reactor",0.4,0]
["# of mixers",null,"10.0-20.0 mgd","Mechanical Mixers",0.15,0]
["# of blowers",null,"10.0-20.0 mgd","Aeration Blowers",0.3,0]
["# of cartridges",null,"10.0-20.0 mgd","Membrane Bioreactor",0.3,0]
["# of systems",null,"10.0-20.0 mgd","Subsurface Disposal System",0.3,0]
["X",null,"10.0-20.0 mgd","Groundwater Discharge",0.15,0]
["# of digesters",null,"10.0-20.0 mgd","Aerobic Digestion",0.15,0]
["# of digesters",null,"10.0-20.0 mgd","Anaerobic Digestion",0.6,0]
["# of basins",null,"10.0-20.0 mgd","Gravity Thickening",0.3,0]
["# of belts",null,"10.0-20.0 mgd","Gravity Belt Thickening",0.4,0]
["# of presses",null,"10.0-20.0 mgd","Belt Filter Press",0.4,0]
["# of units",null,"10.0-20.0 mgd","Mechanical Dewatering (Plate Frame and Centrifuges)",0.4,0]
["# of units",null,"10.0-20.0 mgd","Dissolved Air Floatation",0.3,0]
["X",null,"10.0-20.0 mgd","Chlorination (gas)",0.3,0]
["X",null,"10.0-20.0 mgd","Chlorination (liq.)",0.45,0]
["X",null,"10.0-20.0 mgd","Dechlorination (gas)",0.3,0]
["X",null,"10.0-20.0 mgd","Dechlorination (liq.)",0.45,0]
["# of racks",null,"10.0-20.0 mgd","Ultraviolet",0.25,0]
["# of units",null,"10.0-20.0 mgd","Biofilter",0.5,0]
["# of units",null,"10.0-20.0 mgd","Activated Carbon",0.75,0]
["# of units",null,"10.0-20.0 mgd","Wet Scrubbers",0.25,0]
["# of screens",null,"10.0-20.0 mgd","Microscreens",0.25,0]
["# of units",null,"10.0-20.0 mgd","Pure Oxygen",0.3,0]
["# of units",null,"10.0-20.0 mgd","Final Sand Filters",0.3,0]
["# of different types of probes",null,"10.0-20.0 mgd","Probes/Instrumentation/Calibration",0.1,0]
["# of screens",null,">20 mgd","Manually Cleaned Screens",1,0]
["# of screens",null,">20 mgd","Mechanically Cleaned Screens",4,0]
["# of screens",null,">20 mgd","Mechanically Cleaned Screens with grinders/washer/         compactors",5,0]
["# of units",null,">20 mgd","Comminutor/Macerator",1,0]
["# of chambers",null,">20 mgd","Aerated Grit Chambers",1,0]
["# of units",null,">20 mgd","Vortex Grit Removal",1,0]
["# of units",null,">20 mgd","Gravity Grit Removal",0.5,0]
[]
["# of tanks",null,">20 mgd","Additional Process Tanks",0.1,0]
["# of chemicals added for processes",null,">20 mgd","Chemical Addition (varying dependent upon degree of treatment)",0.8,0]
["# of clarifiers",null,">20 mgd","Circular Clarifiers",1,0]
["# of clarifiers",null,">20 mgd","Chain and Flight Clarifiers",1,0]
["# of clarifiers",null,">20 mgd","Traveling Bridge Clarifiers",1,0]
["# of clarifiers",null,">20 mgd","Squircle Clarifiers",1,0]
["X",null,">20 mgd","Pumps",1500,0]
["# of trains",null,">20 mgd","Rotating Biological Contactor","X"]
["# of TFs",null,">20 mgd","Trickling Filters",0.5,0]
["# of tanks",null,">20 mgd","Sequencing Batch Reactor",0.5,0]
["# of mixers",null,">20 mgd","Mechanical Mixers",0.2,0]
["# of blowers",null,">20 mgd","Aeration Blowers",0.4,0]
["# of cartridges",null,">20 mgd","Membrane Bioreactor",0.4,0]
["# of systems",null,">20 mgd","Subsurface Disposal System",0.4,0]
["X",null,">20 mgd","Groundwater Discharge",0.2,0]
["# of digesters",null,">20 mgd","Aerobic Digestion",0.2,0]
["# of digesters",null,">20 mgd","Anaerobic Digestion",1,0]
["# of basins",null,">20 mgd","Gravity Thickening",0.4,0]
["# of belts",null,">20 mgd","Gravity Belt Thickening",0.5,0]
["# of presses",null,">20 mgd","Belt Filter Press",0.5,0]
["# of units",null,">20 mgd","Mechanical Dewatering (Plate Frame and Centrifuges)",0.5,0]
["# of units",null,">20 mgd","Dissolved Air Floatation",0.4,0]
["X",null,">20 mgd","Chlorination (gas)",0.4,0]
["X",null,">20 mgd","Chlorination (liq.)",0.6,0]
["X",null,">20 mgd","Dechlorination (gas)",0.4,0]
["X",null,">20 mgd","Dechlorination (liq.)",0.6,0]
["# of racks",null,">20 mgd","Ultraviolet",0.3,0]
["# of units",null,">20 mgd","Biofilter",0.5,0]
["# of units",null,">20 mgd","Activated Carbon",1,0]
["# of units",null,">20 mgd","Wet Scrubbers",0.3,0]
["# of screens",null,">20 mgd","Microscreens",0.3,0]
["# of units",null,">20 mgd","Pure Oxygen",0.4,0]
["# of units",null,">20 mgd","Final Sand Filters",0.6,0]
["# of different types of probes",null,">20 mgd","Probes/Instrumentation/Calibration",0.1,0]
[null,null,"All"]
[null,null,"All","End of Chart 2 – Maintenance  SUBTOTAL:",null,null,0]
[null,null,"All"]
[null,null,"All"]
[null,null,"All"]
[null,null,"All"]
[null,null,"All","Begin Chart 3 – Laboratory Operations"]
[null,null,"All"]
["Frequency of test","# of times test is run for selected time frame","All","Tests","Hours","Calculated","Subtotal"]
[null,null,"All","Acidity",0.75,0]
[null,null,"All","Alkalinity, total",0.75,0]
[null,null,"All","Biochemical Oxygen Demand (BOD)",2.5,0]
[null,null,"All","Chemical Oxygen Demand (COD)",2.5,0]
[null,null,"All","Chloride",0.5,0]
[null,null,"All","Chlorine, Total Residual",0.25,0]
[null,null,"All","Coliform, Total, Fecal, E.Coli",1,0]
[null,null,"All","Dissolved Oxygen (DO)",0.25,0]
[null,null,"All","Hydrogen Ion (pH)",0.25,0]
[null,null,"All","Metals",3,0]
[null,null,"All","Toxicity",2,0]
[null,null,"All","Ammonia",2,0]
[null,null,"All","Total Nitrogen",2,0]
[null,null,"All","Oil and Grease",3,0]
[null,null,"All","Total and Dissolved Phosphorus",2,0]
[null,null,"All","Solids, Total, Dissolved, and Suspended",3,0]
[null,null,"All","Specific Conductance",0.25,0]
[null,null,"All","Sulfate",1,0]
[null,null,"All","Surfactants",1,0]
[null,null,"All","Temperature",0.25,0]
[null,null,"All","Total Organic Carbon (TOC)",0.25,0]
[null,null,"All","Turbidity",0.25,0]
[null,null,"All","Bacteriological Enterococci",1,0]
[null,null,"All","Lab QA/QC Program",1,0]
[null,null,"All","Process Control Testing",3,0]
[null,null,"All","Sampling for Contracted Lab Services",0.25,0]
[null,null,"All","Sampling for Monitoring Groundwater wells",0.5,0]
[null,null,"All"]
[null,null,"All","End of Chart 3 – Laboratory Operations  SUBTOTAL:",null,null,0]
[null,null,"All"]
[null,null,"All","*Sampling time is built into testing time estimates."]
[null,null,"All"]
[null,null,"All"]
[null,null,"All","Begin Chart 4 – Biosolids/Sludge Handling"]
[null,null,"All"]
["Unit Descriptons","# of Units","All","Process","Hours","Calculated","Subtotal"]
[null,null,"0.25-0.5 mgd","Belt Filter Press",1,0]
[null,null,"0.25-0.5 mgd","Plate & Frame Press",1,0]
[null,null,"0.25-0.5 mgd","Gravity Thickening",0.25,0]
[null,null,"0.25-0.5 mgd","Gravity Belt Thickening",0.25,0]
[null,null,"0.25-0.5 mgd","Rotary Press",0.25,0]
[null,null,"0.25-0.5 mgd","Dissolved Air Floatation","X"]
[null,null,"0.25-0.5 mgd","Alkaline Stabilization",0.25,0]
[null,null,"0.25-0.5 mgd","Aerobic Digestion",0.5,0]
[null,null,"0.25-0.5 mgd","Anaerobic Digestion",0.25,0]
[null,null,"0.25-0.5 mgd","Centrifuges",1,0]
[null,null,"0.25-0.5 mgd","Composting",1,0]
[null,null,"0.25-0.5 mgd","Incineration","X"]
[null,null,"0.25-0.5 mgd","Air Drying – Sand Beds",0.5,0]
[null,null,"0.25-0.5 mgd","Land Application",0.25,0]
[null,null,"0.25-0.5 mgd","Transported Off-Site for Disposal",0.25,0]
[null,null,"0.25-0.5 mgd","Static Dewatering",1,0]
[null,null,"0.5-1.0 mgd","Belt Filter Press",3,0]
[null,null,"0.5-1.0 mgd","Plate & Frame Press",1.5,0]
[null,null,"0.5-1.0 mgd","Gravity Thickening",0.25,0]
[null,null,"0.5-1.0 mgd","Gravity Belt Thickening",0.25,0]
[null,null,"0.5-1.0 mgd","Rotary Press",0.25,0]
[null,null,"0.5-1.0 mgd","Dissolved Air Floatation",0.5,0]
[null,null,"0.5-1.0 mgd","Alkaline Stabilization",0.25,0]
[null,null,"0.5-1.0 mgd","Aerobic Digestion",0.5,0]
[null,null,"0.5-1.0 mgd","Anaerobic Digestion",0.25,0]
[null,null,"0.5-1.0 mgd","Centrifuges",1,0]
["Choose Range",null,"0.5-1.0 mgd","Composting",2,0]
[null,null,"0.5-1.0 mgd","Incineration","X"]
[null,null,"0.5-1.0 mgd","Air Drying – Sand Beds",0.5,0]
[null,null,"0.5-1.0 mgd","Land Application",0.5,0]
[null,null,"0.5-1.0 mgd","Transported Off-Site for Disposal",1,0]
[null,null,"0.5-1.0 mgd","Static Dewatering",1,0]
[null,null,"1.0-5.0 mgd","Belt Filter Press",6,0]
[null,null,"1.0-5.0 mgd","Plate & Frame Press",3,0]
[null,null,"1.0-5.0 mgd","Gravity Thickening",0.5,0]
[null,null,"1.0-5.0 mgd","Gravity Belt Thickening",0.5,0]
[null,null,"1.0-5.0 mgd","Rotary Press",0.5,0]
[null,null,"1.0-5.0 mgd","Dissolved Air Floatation",0.5,0]
[null,null,"1.0-5.0 mgd","Alkaline Stabilization",0.25,0]
[null,null,"1.0-5.0 mgd","Aerobic Digestion",0.5,0]
[null,null,"1.0-5.0 mgd","Anaerobic Digestion",0.5,0]
[null,null,"1.0-5.0 mgd","Centrifuges",3,0]
[null,null,"1.0-5.0 mgd","Composting",4,0]
[null,null,"1.0-5.0 mgd","Incineration","X"]
[null,null,"1.0-5.0 mgd","Air Drying – Sand Beds","X"]
[null,null,"1.0-5.0 mgd","Land Application",0.5,0]
[null,null,"1.0-5.0 mgd","Transported Off-Site for Disposal",4,0]
[null,null,"1.0-5.0 mgd","Static Dewatering","X"]
[null,null,"5.0-10.0 mgd","Belt Filter Press",8,0]
[null,null,"5.0-10.0 mgd","Plate & Frame Press",8,0]
[null,null,"5.0-10.0 mgd","Gravity Thickening",0.5,0]
[null,null,"5.0-10.0 mgd","Gravity Belt Thickening",0.5,0]
[null,null,"5.0-10.0 mgd","Rotary Press",0.5,0]
[null,null,"5.0-10.0 mgd","Dissolved Air Floatation",1,0]
[null,null,"5.0-10.0 mgd","Alkaline Stabilization",0.25,0]
[null,null,"5.0-10.0 mgd","Aerobic Digestion",1,0]
[null,null,"5.0-10.0 mgd","Anaerobic Digestion",1.5,0]
[null,null,"5.0-10.0 mgd","Centrifuges",8,0]
[null,null,"5.0-10.0 mgd","Composting",8,0]
[null,null,"5.0-10.0 mgd","Incineration","X"]
[null,null,"5.0-10.0 mgd","Air Drying – Sand Beds","X"]
[null,null,"5.0-10.0 mgd","Land Application","X"]
[null,null,"5.0-10.0 mgd","Transported Off-Site for Disposal",8,0]
[null,null,"5.0-10.0 mgd","Static Dewatering","X"]
[null,null,"10.0-20.0 mgd","Belt Filter Press",8,0]
[null,null,"10.0-20.0 mgd","Plate & Frame Press",8,0]
[null,null,"10.0-20.0 mgd","Gravity Thickening",1,0]
[null,null,"10.0-20.0 mgd","Gravity Belt Thickening",1,0]
[null,null,"10.0-20.0 mgd","Rotary Press",1,0]
[null,null,"10.0-20.0 mgd","Dissolved Air Floatation",1,0]
[null,null,"10.0-20.0 mgd","Alkaline Stabilization",0.25,0]
[null,null,"10.0-20.0 mgd","Aerobic Digestion",1.5,0]
[null,null,"10.0-20.0 mgd","Anaerobic Digestion",2.5,0]
[null,null,"10.0-20.0 mgd","Centrifuges",8,0]
[null,null,"10.0-20.0 mgd","Composting",8,0]
[null,null,"10.0-20.0 mgd","Incineration",24,0]
[null,null,"10.0-20.0 mgd","Air Drying – Sand Beds","X"]
[null,null,"10.0-20.0 mgd","Land Application","X"]
[null,null,"10.0-20.0 mgd","Transported Off-Site for Disposal",8,0]
[null,null,"10.0-20.0 mgd","Static Dewatering","X"]
["Per Shift",null,">20 mgd","Belt Filter Press",8,0]
[null,null,">20 mgd","Plate & Frame Press",8,0]
[null,null,">20 mgd","Gravity Thickening",1,0]
[null,null,">20 mgd","Gravity Belt Thickening",2,0]
[null,null,">20 mgd","Rotary Press",2,0]
[null,null,">20 mgd","Dissolved Air Floatation",1,0]
[null,null,">20 mgd","Alkaline Stabilization",0.25,0]
[null,null,">20 mgd","Aerobic Digestion",2,0]
[null,null,">20 mgd","Anaerobic Digestion",4,0]
[null,null,">20 mgd","Centrifuges",8,0]
["Per shift",null,">20 mgd","Composting",8,0]
[null,null,">20 mgd","Incineration",24,0]
[null,null,">20 mgd","Air Drying – Sand Beds","X"]
[null,null,">20 mgd","Land Application","X"]
[null,null,">20 mgd","Transported Off-Site for Disposal",8,0]
[null,null,">20 mgd","Static Dewatering","X"]
[null,null,"All"]
[null,null,"All","End of Chart 4 – Biosolids/Sludge Handling SUBTOTAL:",null,null,0]
[null,null,"All"]
[null,null,"All"]
[null,null,"All"]
[null,null,"All"]
[null,null,"All","Begin Chart 5 – Yardwork"]
[null,null,"All"]
["Unit Descriptons","# of Units","All","Process","Hours","Calculated","Subtotal"]
[null,null,"0.25-0.5 mgd","Janitorial/Custodial Staff",100,0]
[null,null,"0.25-0.5 mgd","Snow removal",60,0]
[null,null,"0.25-0.5 mgd","Mowing",100,0]
["# of vechicles",null,"0.25-0.5 mgd","Vehicle Maintenance",25,0]
[null,null,"0.25-0.5 mgd","Facility Painting",60,0]
[null,null,"0.25-0.5 mgd","Rust removal",60,0]
[null,null,"0.5-1.0 mgd","Janitorial/Custodial Staff",100,0]
[null,null,"0.5-1.0 mgd","Snow removal",60,0]
[null,null,"0.5-1.0 mgd","Mowing",100,0]
["# of vechicles",null,"0.5-1.0 mgd","Vehicle Maintenance",25,0]
[null,null,"0.5-1.0 mgd","Facility Painting",60,0]
[null,null,"0.5-1.0 mgd","Rust removal",60,0]
[null,null,"1.0-5.0 mgd","Janitorial/Custodial Staff",200,0]
[null,null,"1.0-5.0 mgd","Snow removal",120,0]
[null,null,"1.0-5.0 mgd","Mowing",120,0]
["# of vechicles",null,"1.0-5.0 mgd","Vehicle Maintenance",25,0]
[null,null,"1.0-5.0 mgd","Facility Painting",80,0]
[null,null,"1.0-5.0 mgd","Rust removal",80,0]
[null,null,"5.0-10.0 mgd","Janitorial/Custodial Staff",200,0]
[null,null,"5.0-10.0 mgd","Snow removal",120,0]
[null,null,"5.0-10.0 mgd","Mowing",120,0]
["# of vechicles",null,"5.0-10.0 mgd","Vehicle Maintenance",25,0]
[null,null,"5.0-10.0 mgd","Facility Painting",80,0]
[null,null,"5.0-10.0 mgd","Rust removal",80,0]
[null,null,"10.0-20.0 mgd","Janitorial/Custodial Staff",400,0]
[null,null,"10.0-20.0 mgd","Snow removal",400,0]
[null,null,"10.0-20.0 mgd","Mowing",400,0]
["# of vechicles",null,"10.0-20.0 mgd","Vehicle Maintenance",25,0]
[null,null,"10.0-20.0 mgd","Facility Painting",160,0]
[null,null,"10.0-20.0 mgd","Rust removal",160,0]
[null,null,">20 mgd","Janitorial/Custodial Staff",400,0]
[null,null,">20 mgd","Snow removal",400,0]
[null,null,">20 mgd","Mowing",400,0]
["# of vechicles",null,">20 mgd","Vehicle Maintenance",25,0]
[null,null,">20 mgd","Facility Painting",160,0]
[null,null,">20 mgd","Rust removal",160,0]
[null,null,"All"]
[null,null,"All","End of Chart 5 – Yardwork   SUBTOTAL:",null,null,0]
[null,null,"All"]
[null,null,"All"]
[null,null,"All"]
[null,null,"All"]
[null,null,"All","Begin Chart 6 – Automation/SCADA"]
[null,null,"All"]
[null,null,"All","Automation/SCADA","Yes/No"]
[null,null,"All","Automated attendant or Interactive voice recognition (IVR) equipment","No"]
[null,null,"All","Automated Meter Reading (AMR), Touchpad meters or other automated metering technology","No"]
[null,null,"All","Automatic Call Director (ACD)","No"]
[null,null,"All","Billing system","No"]
[null,null,"All","Computerized Facilities Management (FM) System","No"]
[null,null,"All","Computerized preventative maintenance","No"]
[null,null,"All","Computerized recordkeeping","No"]
[null,null,"All","E-mail","No"]
[null,null,"All","Geographical Information System (GIS)","No"]
[null,null,"All","Integrated purchasing and inventory","No"]
[null,null,"All","Internet website","No"]
[null,null,"All","Laboratory Information Management System (LIMS)","No"]
[null,null,"All","Local Area Network (LAN)","No"]
[null,null,"All","Supervisory Control and Data Acquisition (SCADA)","No"]
[null,null,"All","Telemetry","No"]
[null,null,"All","Utility customer information system (CIS) package","No"]
[null,null,"All"]
[null,null,"All","End of Chart 6 – Automation/SCADA"]
[null,null,"All"]
[null,null,"All"]
[null,null,"All"]
[null,null,"All"]
[null,null,"All","Begin Chart 7 – Considerations for Additional Plant Staffing"]
[null,null,"All"]
[null,null,"All","Activities","Yes/No"]
[null,null,"All","Management responsibilities (i.e., human resources, budgeting, outreach, training, town/city meetings, scheduling, etc.) and responsibility for clerical duties (i.e., billing, reports, correspondence, phones, time sheets, mailings, etc.)","No"]
[null,null,"All","Plant staff responsible for collection system operation and maintenance, pump station inspections, and/or combined sewer overflows","No"]
[null,null,"All","Plant operators responsible for snow plowing, road/sidewalk repair, or other municipal project","No"]
[null,null,"All","Plant staff involved in generating additional energy","No"]
[null,null,"All","Plant receives an extra high septage and/or grease load (higher than designed organic and grease loadings) or plant takes in sludge from other treatment plants","No"]
[null,null,"All","Plant is producing a Class A Biosolid product","No"]
[null,null,"All","Plant operators responsible for operating generators and emergency power","No"]
[null,null,"All","Plant responsible for industrial pre-treatment program","No"]
[null,null,"All","Plant staff responsible for plant upgrades and large projects done both on-site and off-site (i.e., collection systems, manholes, etc.)","No"]
[null,null,"All","Plant operators responsible for machining parts on-site","No"]
[null,null,"All","Age of plant and equipment (over 15 years of age)","No"]
[]
[null,null,"All","End of Chart 7 – Considerations for Additional Plant Staffing"]
[]
[null,null,null,"*If you are done click on the \"Final Table\" Tab below to view estimated staffing."]

{"sheet":"Final Table","index":1,"n_rows":51,"n_cols":2,"rows_kept":51,"cut":false,"hidden":false,"merged":[[19,0,19,2],[20,0,20,2],[21,0,21,2],[6,0,6,2],[18,0,18,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[22,0,22,2],[26,0,26,2],[27,0,27,2],[28,0,28,2],[25,0,25,2],[23,0,23,2],[24,0,24,2],[29,0,29,2],[30,0,30,2],[31,0,31,2],[32,0,32,2],[33,0,33,2],[34,0,34,2],[35,0,35,2],[36,0,36,2],[37,0,37,2],[38,0,38,2],[39,0,39,2],[40,0,40,2],[47,0,47,2],[48,0,48,2],[49,0,49,2],[42,0,42,2],[43,0,43,2],[44,0,44,2],[45,0,45,2],[0,0,0,2],[1,0,1,2],[7,0,7,2],[2,0,2,2],[3,0,3,2],[5,0,5,2],[17,1,17,2],[51,0,53,2],[4,1,4,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[50,0,50,2],[46,0,46,2],[11,1,11,2],[41,0,41,2]],"flags":["formulas_cached_only"]}
[]
["THE NORTHEAST GUIDE FOR ESTIMATING STAFFING AT PUBLICLY AND PRIVATELY OWNED WASTEWATER TREATMENT PLANTS (One Shift)"]
["Plant Name: "]
[]
["Design Flow: ","Actual Flow: "]
[]
[]
["FINAL ESTIMATES"]
["Chart #","Annual Hours"]
["Chart 1 – Basic and Advanced Operations and Processes",0]
["Chart 2 – Maintenance",0]
["Chart 3 – Laboratory Operations",0]
["Chart 4 – Biosolids/Sludge Handling",0]
["Chart 5 – Yardwork",0]
["Estimated Operation and Maintenance Hours",0]
["Estimated Operation and Maintenance Staff",0]
["Estimated Additional Staff from Chart 7"]
["TOTAL STAFFING ESTIMATE",0]
["Note: The Total Staff estimate from Charts 1-5 will not be the final amount of staff necessary to run the facility.  Please review Chart 7 for additional staffing needs."]
["Chart 6 - Automation/SCADA"]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[]
["Chart 7 - Considerations for Additional Plant Staffing"]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
["Note: The user should attach supporting information to justify additional staffing needs from Chart 7."]
["Final Comments:"]