{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["ReadMe","Relevant Resources & Equipment","Asset Inventory Questionnaire","Asset Inventory Checklist","Asset Hierarchy","Example Asset Hierarchy","List for Asset Hierarchy","Asset Inventory Template","Example Asset Inventory"],"not_rendered":{"charts":0,"images":0,"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":"ReadMe","index":0,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[[10,1,10,9],[9,1,9,9],[0,0,1,9],[2,0,2,9],[3,1,3,9],[5,1,5,9],[6,1,6,9],[7,1,7,9],[4,1,4,9],[8,1,8,9]]}
["Asset Inventory Workbook Summary"]
[]
["Note:\nGreen cells should be populated.\nOrange cells are optional based on the asset."]
["Worksheet","General Overview"]
["Relevant Resources & Equipment","This worksheet includes a checklist of resources relevant to the development of an Asset Management Program. This includes repository information, software recommendations, and documentation that will feed into the asset information. The documentation aids in the operation and maintenance of the POTW."]
["Asset Inventory Questionnaire","This worksheet helps the user decide which assets should be included in the asset inventory. The municipality may choose to add additional questions to capture more assets."]
["Asset Inventory Checklist","This worksheet includes a checklist of attributes the user must record in order to complete the asset inventory. The attributes  should have a value, even if it is an estimated one."]
["Asset Hierarchy","This worksheet allows the user to build out a process location system for assets. The user can build a set of locations using pre-built dropdowns, specifying a location, treatment process, and treatment sub-process. After building out a list of locations in this manner, he or she can then assign the locations to assets in the Asset Inventory. As an example, a user creating a Chlorine Contact Tank location would select WWTP from the Level 1 dropdown, Disinfection from the Level 2 dropdown, then Chlorine Contact Tank in the Level 3 dropdown."]
["Example Asset Hierarchy","This worksheet includes an example asset hierarchy."]
["Asset Inventory Template","This worksheet provides a template for the user to record attribute information collected during the inventory process. This template can be used as the inventory or a tool to help load information into an asset management software system. The user may not have every attribute listed in the template or some attributes may not apply. The purpose is to populate as much relevant information as possible for each asset and estimate values for attributes that are required to complete future tasks. For example, a chlorine contact tank will not have a value for horsepower, but should include a value in the capacity column. Name plate data on mechanical equipment will often provide many of the important attributes, such as manufacturer, size, serial number, model number, horsepower, voltage, etc."]
["Example Asset Inventory","This worksheet includes an example asset inventory."]

{"sheet":"Relevant Resources & Equipment","index":1,"n_rows":33,"n_cols":3,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,3,2]]}
["Relevant Resources"]
["The resources listed below aid in the completion of a successful Asset Management Program. A preferred format is listed for best integration with the electronic repository. "]
[]
[]
[]
["Resource","Use ","Preferred Format"]
["Asset Vendor O&M Manuals","Asset Inventory","Scanned / digital"]
["Equipment Shop Drawings","Asset Inventory","Scanned / digital"]
["Facility Plans / Engineering Reports","Asset Inventory","Scanned / digital"]
["Facility Drawings","Asset Inventory","Scanned / digital"]
["Facility Maps","Asset Inventory","GIS"]
["Collection System Maps","Asset Inventory","GIS"]
["Copies of Purchase Orders or other procurement records for capital assets","Asset Inventory","Scanned / digital"]
["Past 5-year detailed annual budgets for wastewater collection and treatment facilities","Asset Inventory, Capital Improvement Plan, Rate Analysis ","Scanned / digital"]
["Manhole Inspection Data","Condition Scoring","Scanned / digital"]
["PACP CCTV Data","Condition Scoring","Scanned / digital"]
["Smoke Testing, Dye Testing, Other Condition Assessment Information ","Condition Scoring","Scanned / digital"]
["Sewer System Evaluation Studies","Condition Scoring","Scanned / digital"]
["Installation and Construction Records","Condition Scoring","Scanned / digital"]
["Previous Maintenance Logs","Management Capital Investments","Scanned / digital"]
["Historical work orders, records of problems and asset failures ","Management Capital Investments","Scanned / digital"]
["Documented standard operating procedures ","Management Capital Investments","Scanned / digital"]
["Documented preventive maintenance procedures and schedules","Management Capital Investments","Scanned / digital"]
["Any existing capital improvement plans, forecasts, potential projects","Capital Improvement Plan","Scanned / digital"]
["A copy of any existing Sewer Rate Model and Sewer Rate Study including sewer rate recommendations","Sewer Rate Analysis","Scanned / digital"]
["Details of current source of revenue for Wastewater System, rates, etc.","Sewer Rate Analysis","Scanned / digital"]
["Itemized annual administrative, operations and maintenance expenditures attributable to providing sewerage services over past 5 years","Sewer Rate Analysis","Scanned / digital"]
["Most recent Utility Comprehensive Annual Financial Report (that includes sewer utility)","Sewer Rate Analysis","Scanned / digital"]
["Current water and sewer rate structure","Sewer Rate Analysis","Scanned / digital"]
["Method by which sewer rates are set and data required, such as amount of water sold or customer billing analysis as applicable.","Sewer Rate Analysis","Scanned / digital"]
["Information on current debt including debt service expenditures, debt by source, repayment schedules ","Sewer Rate Analysis","Scanned / digital"]
["A summary of any funding / grant applications and awards","Long Term Funding Strategy","Scanned / digital"]
["The details of the municipality's debt Financing/Pay-Go Policy","Long Term Funding Strategy","Scanned / digital"]

{"sheet":"Asset Inventory Questionnaire","index":2,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[6,0,6,1],[0,0,0,2],[1,0,3,2]]}
["Asset Questionnaire"]
["Assets include equipment or components that are necessary for the conveyance and treatment of wastewater. Use the table below to determine if an item fits the definition of an asset. If the answer to any of the questions below is \"yes\", the item should be included in the asset inventory. Municipalities may chose to include more assets that what fit in the categories below."]
[]
[]
[]
[]
["Question  ",null,"Examples"]
[1,"Does it have a service life of three (3) or more years? ","Pumps, tanks, valves, actuators"]
[2,"Will it require unbudgeted expenditures to replace in the event of failure?","Clarifier mechanisms, bar screens"]
[3,"Is it necessary to provide a safe work environment? ","Alarm systems, gas detection systems"]
[4,"Is it required to comply with Local, State, or Federal regulatory standards? ","Samplers, disinfection systems, outfall pipe"]
[5,"Does it require documented calibrations or inspections?","Fire extinguishers, dissolved oxygen probes, flowmeters"]
[6,"Is it necessary for the supply of electricity? ","Control panels, automatic transfer switches"]
[7,"Does it require a special order with a long lead time?","Egg shaped pipes"]

{"sheet":"Asset Inventory Checklist","index":3,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[10,0,10,4],[10,5,10,10],[0,0,0,10],[9,0,9,4],[7,5,7,10],[8,5,8,10],[9,5,9,10],[8,0,8,4],[15,5,15,10],[16,5,16,10],[17,5,17,10],[7,0,7,4],[1,0,5,10],[13,0,13,4],[12,0,12,4],[11,0,11,4],[14,0,14,4],[11,5,11,10],[12,5,12,10],[13,5,13,10],[14,5,14,10],[16,0,16,4],[15,0,15,4],[17,0,17,4]]}
["Asset Inventory Checklist"]
["The checklist below identifies the necessary attributes to facilitate completion of an asset management program. Use this checklist during the inventory process. Sources of this data may include: As-built drawings, design drawings, manufacturers’ manuals, bid documents, staff knowledge, visual inspection, and photographs. This information applies to all collection system, wastewater treatment facility, and pump station assets. "]
[]
[]
[]
[]
[]
["Inventory Information",null,null,null,null,"Purpose"]
["GPS Coordinates",null,null,null,null,"GIS mapping"]
["Location Description (e.g., cross-streets, building, floor)",null,null,null,null,"Asset identification"]
["Elevations ",null,null,null,null,"Resilency"]
["Ownership",null,null,null,null,"Level of service, capital improvement planning"]
["Physical Qualities (e.g., invert elevation, diameter, depth, material)",null,null,null,null,"Condition scoring, consequence of failure"]
["Replacement Cost",null,null,null,null,"Capital improvement planning"]
["Cost Index Year (i.e., reference year for cost data)",null,null,null,null,"Capital improvement planning"]
["Installation Date",null,null,null,null,"Condition scoring, likelihood of failure"]
["Age (calculated)",null,null,null,null,"Condition scoring, likelihood of failure"]
["Design Life (from manufacturer or found in Risk Toolbox #5)",null,null,null,null,"Condition scoring, likelihood of failure"]

{"sheet":"Asset Hierarchy","index":4,"n_rows":110,"n_cols":4,"rows_kept":110,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,5,3]]}
["Asset Hierarchy"]
["This worksheet allows the user to build out a process based location system for assets. It is recommended the hierarchy is completed prior to completing the asset inventory. The user can build a set of locations using pre-built dropdowns, specifying a location, treatment process, and treatment sub-process. The dropdowns serve as examples. Team members can input their own locations in levels 1, 2, and 3. After building out a list of locations in this manner, they can then assign the locations to assets in the Asset Inventory. As an example, a user creating a Chlorine Contact Tank location would select WWTP from the Level 1 dropdown, Disinfection from the Level 2 dropdown, then Chlorine Contact Tank in the Level 3 dropdown."]
[]
[]
[]
[]
[]
[]
["Process Location ID","Level 1","Level 2","Level 3"]
["PL00001","WWTP","Disinfection","Chlorine Contact Tank"]
["PL00001"]
["PL00002"]
["PL00003"]
["PL00004"]
["PL00005"]
["PL00006"]
["PL00007"]
["PL00008"]
["PL00009"]
["PL00010"]
["PL00011"]
["PL00012"]
["PL00013"]
["PL00014"]
["PL00015"]
["PL00016"]
["PL00017"]
["PL00018"]
["PL00019"]
["PL00020"]
["PL00021"]
["PL00022"]
["PL00023"]
["PL00024"]
["PL00025"]
["PL00026"]
["PL00027"]
["PL00028"]
["PL00029"]
["PL00030"]
["PL00031"]
["PL00032"]
["PL00033"]
["PL00034"]
["PL00035"]
["PL00036"]
["PL00037"]
["PL00038"]
["PL00039"]
["PL00040"]
["PL00041"]
["PL00042"]
["PL00043"]
["PL00044"]
["PL00045"]
["PL00046"]
["PL00047"]
["PL00048"]
["PL00049"]
["PL00050"]
["PL00051"]
["PL00052"]
["PL00053"]
["PL00054"]
["PL00055"]
["PL00056"]
["PL00057"]
["PL00058"]
["PL00059"]
["PL00060"]
["PL00061"]
["PL00062"]
["PL00063"]
["PL00064"]
["PL00065"]
["PL00066"]
["PL00067"]
["PL00068"]
["PL00069"]
["PL00070"]
["PL00071"]
["PL00072"]
["PL00073"]
["PL00074"]
["PL00075"]
["PL00076"]
["PL00077"]
["PL00078"]
["PL00079"]
["PL00080"]
["PL00081"]
["PL00082"]
["PL00083"]
["PL00084"]
["PL00085"]
["PL00086"]
["PL00087"]
["PL00088"]
["PL00089"]
["PL00090"]
["PL00091"]
["PL00092"]
["PL00093"]
["PL00094"]
["PL00095"]
["PL00096"]
["PL00097"]
["PL00098"]
["PL00099"]
["PL00100"]

{"sheet":"Example Asset Hierarchy","index":5,"n_rows":23,"n_cols":4,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Process Location ID","Level 1","Level 2","Level 3"]
["PL00001","WWTP","-","-"]
["PL00002","WWTP","Headworks","-"]
["PL00003","WWTP","Headworks","Influent System"]
["PL00004","WWTP","Primary Treatment","-"]
["PL00005","WWTP","Primary Treatment","Primary Clarifier #1"]
["PL00006","WWTP","Primary Treatment","Primary Clarifier #2"]
["PL00007","WWTP","Secondary Treatment","-"]
["PL00008","WWTP","Secondary Treatment","Aeration Tank #1"]
["PL00009","WWTP","Disinfection","-"]
["PL00010","WWTP","Disinfection","UV Bank #1"]
["PL00011","Pump Stations","-","-"]
["PL00012","Pump Stations","Pump Station #1 - Central","-"]
["PL00013","Pump Stations","Pump Station #1 - Central","Influent System"]
["PL00014","Pump Stations","Pump Station #1 - Central","Suport Equipment"]
["PL00015","Pump Stations","Pump Station #2 - Lake Street","-"]
["PL00016","Pump Stations","Pump Station #2 - Lake Street","Influent System"]
["PL00017","Pump Stations","Pump Station #2 - Lake Street","Support Equipment"]
["PL00018","Conveyance","-","-"]
["PL00019","Conveyance","Manholes","-"]
["PL00020","Conveyance","Maholes","Flow Meters"]
["PL00021","Conveyance","Gravity Sewer","-"]
["PL00022","Conveyance","Pressure Sewer","-"]

{"sheet":"List for Asset Hierarchy","index":6,"n_rows":63,"n_cols":3,"rows_kept":63,"cut":false,"hidden":true,"merged":[[2,0,3,2]]}
["Asset Hierarchy Dropdown List"]
[]
["The user can add levels as needed for the processes in place at the POTW."]
[]
[]
["Level 1","Level 2","Level 3"]
["WWTP","Headworks","Aeration"]
["Collection","Primary Treatment","Bar Screen"]
["Pump Stations","Secondary Treatment","Belt Press"]
["Spare Equipment","Disinfection","Biological Nutrient Removal (BNR) System"]
[null,"Solids Handling","Blower"]
[null,"Chemical Treatment","Bypass"]
[null,"Support Systems","Channel"]
[null,"Pump Station","Chemical System"]
[null,"Collection-Manhole","Chlorine Contact Tank"]
[null,"Collection-Pipe","Chlorine Injection System"]
[null,null,"Classifier"]
[null,null,"Composting"]
[null,null,"Control Equipment"]
[null,null,"Digester"]
[null,null,"Discharge Piping"]
[null,null,"Disk Filters"]
[null,null,"Drain Piping"]
[null,null,"Drain Well"]
[null,null,"Dry Well"]
[null,null,"Effluent Channel"]
[null,null,"Effluent Piping"]
[null,null,"Effluent Pump"]
[null,null,"Electrical Equipment"]
[null,null,"Equalization Tank"]
[null,null,"Flow Meter"]
[null,null,"Flow Splitter"]
[null,null,"Grit Removal"]
[null,null,"HVAC"]
[null,null,"Influent Channel"]
[null,null,"Influent Piping"]
[null,null,"Manhole"]
[null,null,"Mechanical Bar Screen"]
[null,null,"Parshall Flume"]
[null,null,"RAS Pumps"]
[null,null,"SCADA/Communications"]
[null,null,"Screening"]
[null,null,"Screw Pumps"]
[null,null,"Scum Piping"]
[null,null,"Sensors/Instrumentation"]
[null,null,"Settling"]
[null,null,"Slide Gate"]
[null,null,"Sludge Blowers"]
[null,null,"Sludge Pumps"]
[null,null,"Sludge Storage Tank"]
[null,null,"Sludge Thickener"]
[null,null,"Stop Gate"]
[null,null,"Structures and Site"]
[null,null,"Suction Piping"]
[null,null,"Support Equipment"]
[null,null,"Tank"]
[null,null,"Trickling Filtration"]
[null,null,"UV Disinfection"]
[null,null,"Valve"]
[null,null,"Valve Pit"]
[null,null,"WAS Pumps"]
[null,null,"Weir Gate"]
[null,null,"Wet Well"]

{"sheet":"Asset Inventory Template","index":7,"n_rows":14,"n_cols":26,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,12],[1,0,7,12]]}
["Asset Inventory Template"]
["This worksheet is a template for the user to record attribute information collected during the inventory process. This template can be used as the inventory or a tool to help load information into an asset management software system. The user may not have every attribute listed in the template or some attributes may not apply. These attributes are displayed in orange. The purpose is to populate as much relevant information as possible for each asset and estimate values for attributes that are required to complete future tasks. For example, a chlorine contact tank will not have a value for horsepower, but should include a value in the capacity column. Name plate data on mechanical equipment will often provide many of the important attributes, such as manufacturer, size, serial number, model number, horsepower, voltage, etc."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Asset ID ","Asset Description","Location","Elevation","Process ","Process Location ID ","Installation Date","Replacement Cost","Classification (Condition Assessment Toolbox #4)","Condition Score \n(Condition Assessment Toolbox #4)","Likelihood of Failure Score\n(Risk Toolbox #5)","Consequence of Failure Score\n(Risk Toolbox #5)","Risk Score\n(Risk Toolbox #5)","Notes","Type","Capacity (GPM)","Horsepower","Inlet Size","Oulet Size","Material","Rating","Pressure (PSI)","Speed (RPM)","Voltage","Diameter (inches)","Size"]
["AS00096","Return Activiated Sludge Pump","Control Building - Basement Floor","900 ft","Secondary Treatment","PL00008","2017-05-05",20000,"Rotary Lobe Pump",2,{"$f":"((15-(-0.125*J13+0.75)*((15)+(15-3)))/15)*10","v":1},7,{"$f":"L13*K13","v":7},"EPDM Lobes\nPiggyback Motor\nManfacturer - Borger Vendor - JP Jager","Lobe Type A",120,20,4,6,"Stainless Steel","NA",90,300,280,"NA","NA"]
["AS00105","Gravity Sewer Pipe","35 Main Street","980 ft","Conveyance","PL00021","1982-05-07",90000,"Gravity Line",6,10,10,{"$f":"L14*K14","v":100},"ASTM F714\nManufacturer - Performance Pipe\nVendor - Vari-tech","NA","NA","NA","NA","NA","High Density Polyethylene","NA",150,"NA","NA",12,"NA"]

{"sheet":"Example Asset Inventory","index":8,"n_rows":29,"n_cols":25,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Asset ID ","Asset Description","Location","Process ","Process Location ID ","Installation Date","Replacement Cost","Classification (Condition Assessment Toolbox #4)","Condition Score \n(Condition Assessment Toolbox #4)","Likelihood of Failure Score\n(Risk Toolbox #5)","Consequence of Failure Score\n(Risk Toolbox #5)","Risk Score\n(Risk Toolbox #5)","Notes","Type","Capacity (GPM)","Horsepower","Inlet Size","Oulet Size","Material","Rating","Pressure (PSI)","Speed (RPM)","Voltage","Diameter (inches)","Size"]
["AS00132","Digester","Treatment Plant","Solids Handling","PL00017","1969-01-01",1200000,"Structure ",6,8.33,7.9,65.81]
["AS00133","Control Panel","Secondary Sludge Pump Station","Solids Handling","PL00016","1969-01-01",15000,"Electrical Switchboards",8.67,10,5.5,55]
["AS00134","Primary sludge pump","Sludge Process Room","Solids Handling","PL00016","2010-01-01",6500,"Electrical Switchboards",4,2,5.95,11.9]
["AS00135","Primary sludge pump - motor","Sludge Process Room","Solids Handling","PL00016","2010-01-01",830,"Conventional Pump",4,1.2,5.5,6.6]
["AS00136","Primary sludge pump - motor drive","Sludge Process Room","Solids Handling","PL00016","2010-01-01",1500,"Motor",4,1.2,5.5,6.6]
["AS00137","Primary sludge pump - VFD ABB","Sludge Process Room","Solids Handling","PL00016","2010-01-01",7800,"Electrical / Instrumentation Equipment",4,2,5.5,11]
["AS00138","Secondary sludge pump 2","Secondary Sludge Pump Station","Solids Handling","PL00016","1969-01-01",29000,"Conventional Pump",8,10,4.3,43]
["AS00139","Secondary sludge pump 2 - speed reducer","Secondary Sludge Pump Station","Solids Handling","PL00016","1969-01-01",750,"Electrical / Instrumentation Equipment",7,8.8000000000000007,4.3,37.840000000000003]
["AS00140","Secondary sludge pump 2 - motor","Secondary Sludge Pump Station","Solids Handling","PL00016","1969-01-01",700,"Motor",4,6.8,4.3,29.24]
["AS00141","Methane flame trap","Digester","Solids Handling","PL00017","2010-01-01",4000,"Pipes & Fittings - Ferrous",3,1,7.9,7.9]
["AS00142","Methane gas burner","Digester","Solids Handling","PL00017","2010-01-01",55000,"Pipes & Fittings - Ferrous",3,1,7.9,7.9]
["AS00143","Methane horizontal flame arrester","Digester","Solids Handling","PL00017","2010-01-01",8000,"Pipes & Fittings - Ferrous",3,1,7.9,7.9]
["AS00144","Methane sediment trap","Digester","Solids Handling","PL00017","2010-01-01",1000,"Pipes & Fittings - Ferrous",3,1,7.9,7.9]
["AS00145","Digester Supernatant Wet Well","Treatment Plant","Solids Handling","PL00017","1969-01-01",85000,"Structure ",4.67,6.67,6.55,43.69]
["AS00146","Digester Supernatant Manhole","Treatment Plant","Solids Handling","PL00017","1969-01-01",6000,"Pipes & Fittings - Ferrous",2,1.73,5.5,9.52]
["AS00147","Cover- Digester","Digester","Solids Handling","PL00017","1969-01-01",200000,"Structure ",5,8.8000000000000007,7.9,69.52]
["AS00148","Digester Gas Piping","Sludge Process Room","Solids Handling","PL00017","2010-01-01",5000,"Pipes & Fittings - Ferrous",2,1,7.9,7.9]
["AS00149","Supernatant Piping- Digester to Supernatant Wet Well","Digester","Solids Handling","PL00017","2010-01-01",11100,"Pipes & Fittings - Ferrous",3,1,5.95,5.95]
["AS00150","Recirculating Pump- Digester","Sludge Process Room","Solids Handling","PL00016","2017-01-01",19000,"Submersible Pump",2,1,6.55,6.55]
["AS00151","Heat exchanger- digester","Sludge Process Room","Solids Handling","PL00017","2005-01-01",10000,"HVAC",4,4.5,6.55,29.47]
["AS00152","Suction Piping- Digester to HEX Recirculation Pump","Digester","Solids Handling","PL00016","2005-01-01",750,"Pipes & Fittings - Ferrous",3,1,6.1,6.1]
["AS00153","Discharge Piping- HEX Recirculation Pump to Digester","Digester","Solids Handling","PL00016","2005-01-01",1250,"Pipes & Fittings - Ferrous",3,1,6.1,6.1]
["AS00154","Recirculating Pump Panel- Digester Recirculation","Sludge Process Room","Solids Handling","PL00016","2010-12-10",2000,"Electrical Switchboards",6,4,4.9000000000000004,19.600000000000001]
["AS00155","Digester Supernatant Pump 1","Treatment Plant","Solids Handling","PL00016","1969-01-01",16000,"Submersible Pump",3,10,3.85,38.5]
["AS00156","Digester Supernatant Pump 2","Treatment Plant","Solids Handling","PL00016","1969-01-01",16000,"Submersible Pump",3,10,3.85,38.5]
["AS00157","Discharge Piping- Digester Supernatant Pumps to Head of Plant","Treatment Plant","Solids Handling","PL00016","1969-01-01",42550,"Pipes & Fittings - Ferrous",3,10,5.95,59.5]