{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Instructions","Agency Information","Facility Effluent Treatment","Revenues & Expenses","Gravity Pipes-Manholes","Proposed Gravity Pipes-Manholes","Pressure Lines","Proposed Pressure Lines","Pump Stations","Proposed Pump Stations","Treatment Unit","Proposed Treatment Unit","Project Priorization","Funding Plan","Certification","Sheet4"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":5,"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":"Instructions","index":0,"n_rows":160,"n_cols":9,"rows_kept":160,"cut":false,"hidden":false,"merged":[[124,2,124,8],[125,2,125,8],[126,2,126,8],[127,2,127,8],[129,2,131,4],[132,2,134,4],[128,2,128,4],[128,5,128,8],[99,1,99,8],[100,1,100,8],[101,1,101,8],[102,1,102,8],[103,1,103,8],[114,7,114,8],[105,7,105,8],[106,7,106,8],[107,7,107,8],[108,7,108,8],[109,7,109,8],[110,7,110,8],[111,7,111,8],[112,7,112,8],[113,7,113,8],[109,3,109,6],[73,1,73,8],[75,3,75,6],[74,2,74,8],[74,1,97,1],[69,1,70,8],[41,1,41,8],[44,1,44,8],[43,1,43,8],[42,1,42,8],[60,1,60,2],[58,1,58,2],[57,1,57,2],[56,1,56,2],[55,1,55,2],[54,1,54,2],[53,1,53,2],[60,3,60,5],[52,1,52,8],[63,6,63,8],[62,6,62,8],[58,3,58,8],[57,3,57,8],[61,6,61,8],[60,6,60,8],[110,3,110,6],[111,3,111,6],[86,4,86,8],[87,4,87,8],[88,4,88,8],[89,4,89,8],[90,4,90,8],[91,4,91,8],[81,3,81,6],[82,3,82,6],[83,3,83,6],[84,3,84,6],[85,2,85,8],[106,3,106,6],[107,3,107,6],[108,3,108,6],[1,7,1,8],[51,1,51,2],[50,1,50,2],[49,1,49,2],[48,1,48,2],[47,1,47,2],[46,1,46,2],[28,2,28,8],[29,2,29,8],[51,3,51,5],[50,3,50,5],[49,3,49,5],[30,2,30,8],[35,1,35,8],[40,1,40,8],[45,1,45,8],[46,3,46,5],[51,6,51,8],[50,6,50,8],[49,6,49,8],[48,6,48,8],[47,6,47,8],[46,6,46,8],[0,1,0,8],[1,1,1,6],[24,1,24,8],[26,2,26,8],[27,2,27,8],[12,1,12,8],[19,2,19,8],[18,2,18,8],[17,2,17,8],[16,2,16,8],[15,2,15,8],[14,2,14,8],[13,2,13,8],[2,1,2,8],[3,2,3,8],[4,2,4,8],[5,2,5,8],[6,2,6,8],[11,2,11,8],[10,2,10,8],[9,2,9,8],[20,1,20,8],[8,2,8,8],[7,2,7,8],[138,2,138,4],[139,2,140,4],[141,2,143,4],[53,3,53,8],[138,5,138,8],[139,5,139,8],[140,5,140,8],[141,5,141,8],[142,5,142,8],[143,5,143,8],[129,5,129,8],[92,2,92,8],[104,2,104,8],[115,2,115,8],[76,3,76,6],[77,3,77,6],[78,3,78,6],[79,3,79,6],[80,3,80,6],[71,1,71,8],[72,1,72,8],[64,6,64,8],[65,3,65,5],[65,6,65,8],[63,3,63,5],[62,3,62,5],[61,3,61,5],[54,3,54,8],[56,3,56,8],[55,3,55,8],[65,1,65,2],[64,1,64,2],[63,1,63,2],[62,1,62,2],[61,1,61,2],[157,3,157,8],[158,3,158,8],[159,1,159,8],[149,1,149,8],[150,3,150,8],[151,3,151,8],[152,3,152,8],[153,3,153,8],[119,3,119,8],[121,3,121,8],[130,5,130,8],[131,5,131,8],[132,5,132,8],[133,5,133,8],[134,5,134,8],[144,5,144,8],[144,2,144,4],[137,5,137,8],[136,5,136,8],[135,5,135,8],[137,2,137,4],[136,2,136,4],[135,2,135,4],[120,3,120,8],[104,1,122,1],[25,2,25,8],[154,1,154,8],[155,1,155,8],[156,3,156,8],[116,3,116,8],[117,3,117,8],[118,3,118,8],[93,3,93,5],[93,6,93,8],[94,3,94,5],[95,3,95,5],[96,3,96,5],[94,6,94,8],[95,6,95,8],[96,6,96,8],[112,3,112,6],[113,3,113,6],[114,3,114,6],[105,3,105,6],[48,3,48,5],[47,3,47,5],[59,1,59,8],[64,3,64,5]]}
[null,"ASSET INVENTORY REPORT FORM"]
[null,null,null,null,null,null,null,"Kentucky Division of Water’s Asset Inventory Report,           as required by 401 KAR 5:006"]
[null,"In accordance with 401 KAR 5:006, regional planning agencies are required to submit an asset inventory report to the Cabinet, if: (a) It has been ten (10) years since the regional planning agency submitted a regional facility plan or asset inventory report; and (b) the regional planning agency does not meet the requirements established in Section 2(2) of the regulation. The asset inventory report requires regional planning agencies to take inventory of the physical assets of their wastewater system(s), assess their condition, prioritize capital needs, and develop a plan for funding those needs.  By incorporating this planning tool into their daily operations, the Cabinet expects regional planning agencies to achieve the following benefits:"]
[null,null,"a. Reduce overall cost of system operation and maintenance;"]
[null,null,"b. Target capital investments toward critical assets;"]
[null,null,"c. Improve compliance record and remediate or correct illegal overflows or bypasses; "]
[null,null,"d. Acquire a better understanding of treatment and/or collection system components;"]
[null,null,"e. Reduce borrowing costs. Funding agencies prefer lending to municipalities which properly manage and operate their assets;"]
[null,null,"f.  Potentially improve bond credit ratings;"]
[null,null,"g. Make a sound case for rate increases to local governing boards and rate payers; "]
[null,null,"h. Prolong the useful life of their assets. Knowing the condition of assets allows regional planning agencies to make timely repairs; and"]
[null,null,"i.  Reduce duplication of efforts and improve the allocation of staff time and other resources. "]
[null,"A complete report consists of this form and copies of supporting documentation.  All regional planning agencies that wish to use this report to demonstrate compliance with the requirements of 401 KAR 5:006, Section 4 must complete all seven sections of the report and provide copies of the supporting documentation required under section VI. This report form consists of seven (7) sections:"]
[null,null,"I.              REGIONAL PLANNING AGENCY DATA "]
[null,null,"II.             REVENUES AND EXPENSES"]
[null,null,"III.            ASSET INVENTORY"]
[null,null,"IV.            PROJECT PRIORITIZATION "]
[null,null,"V.             FUNDING PLAN"]
[null,null,"VI.            COPIES OF SUPPORTING DOCUMENTATION"]
[null,null,"VII.           CERTIFICATION"]
[null,"Most of the information required in the form is self-explanatory. The instructions in some of the sections are given to highlight some of the information that may require interpretation or additional clarification. You may add extra pages for entering additional asset inventory information especially ft you are a regional planning agency with multiple treatment plants.  If you need to include additional information, attach the extra pages and put the question number next to your answers and/or copy and paste the asset inventory tables on the additional pages. It’s quite likely that all of the details of the asset inventory presented in this report will not apply to every wastewater system. If the parameter does not apply then indicate by entering N/A in the blank or modify the worksheets so they conform to the particular needs of your system. For additional information or assistance, contact the Kentucky Division of Water, Wastewater Planning Section (502) 564-3410."]
[]
[]
[]
[null,"I. REGIONAL PLANNING AGENCY DATA. These subsections provide the basic information necessary to identify and characterize the system. The point of contact information must include an organization and an individual. The address can be a mailing address (e.g., P.O. Box).  The physical location of the facility is required for treatment plants only. The address should be the physical location of the facility, and not a P.O. Box.  Descriptive addresses are acceptable if no physical address exists."]
[null,null,"1. Regional Planning Agency Information.   Basic system information."]
[null,null,"2. Discharge Information. Facilities may have multiple discharge types (e.g., discharge to another facility, subsurface discharge, outfall to surface waters, reuse). Additionally, one or more facilities may discharge to the facility. Please review and enter discharge information carefully. If multiple discharges apply, enter percentages which must add to up 100%. "]
[null,null,"3. Facility Effluent Treatment Level. Please indicate the level of treatment available at the treatment plant.  Current Treatment Level should be selected if the facility is or will be in operation as of the date of report submittal. Projected Treatment Level should be entered if the facility will be in operation for all or part of the 10-year period after the date of report submittal. Treatment levels include primary (45mg/l<BOD; process in which the effluent is treated to remove floating debris and solids by screening and sedimentation); advanced primary (process in which chemicals are added to further treat primary effluent and increase the amount of solid matter removed); secondary (the effluent must meet the minimum removal standards for Biochemical Oxygen Demand, total suspended solids, and pH); and advanced (a level of treatment that is more stringent than secondary treatment or produces a significant reduction in nonconventional or toxic pollutants present in the facility’s effluent; the treatment level is considered advanced if the BOD permit limit is less than 20 mg/l or the facility has one or more advanced treatment processes."]
[null,null,"4. Facility Type.  Enter all the facility types that apply to the system. Facility type includes treatment plant, collection (combined sewers, separate sewers, interceptor sewers, and biosolids handling facility.  Indicate whether the facility is currently used by placing a check mark in “Present” column(s) or whether it is planned to be used in the future by placing a check mark in “Projected” column(s)."]
[null,null,"5. Flow and Population Served. Each year's data must be based on a 12-month time period.  Subcategories a through d apply to treatment plants. If applicable, indicate the projected design capacity for treatment plants.  The population served information table has two main components; each must be completed for the present condition and the 10-year projected condition.  "]
[null,null,"6. Treatment Plant Discharge Limits.  List the discharge limits for each parameter listed in the most current KPDES permits.  If the parameter does not apply to the permits, then indicate by entering N/A in the blank."]
[]
[]
[]
[]
[null,"II. REVENUES AND EXPENSES.   Data items in this section are necessary to understand the financial condition of the system.  The information provided can be estimated or based upon audit reports.  "]
[]
[]
[]
[]
[null,"III. ASSET INVENTORY. This is the most extensive section of the report and will allow the Division of Water to evaluate the types of assets, anticipated failure and replacement or rehabilitation costs. The data items required should be readily available to most operators or managers. Most systems already have some form of inventory established but not centralized.  The following asset inventory is designed to collect data and information into a centralized format. The inventory provides a format where information and data will be listed in the categorized asset tables and include corresponding characteristics, assigned assessment and failure mode ratings, and assigned strategies to renew or maintain the assets.  Taking an initial inventory of assets can be a labor intensive job. Systems should start by identifying their critical assets to prepare the initial inventory.  The collection of assessment data and information can be done through the direct inspection, observation, repairs, operation and maintenance routines, investigation/ monitoring/reporting, and analysis of data. Because systems need to continue to collect new data and information and build upon initial inventories, an ongoing, organized, and systematic collection of data should be established so the process develops.  One of the most important outcomes of the assessments is determining the remaining useful life of an asset.  A number of factors can affect the useful life of assets, including routine service and proper maintenance, excessive use, and environmental conditions such as topography, soil, or climate. "]
[null,"1.  What is the State of My Assets? Assessing the state of assets is one of the core components of developing an asset inventory. It provides the critical information needed to assess condition, performance and reliability of system components. The measure of performance for a wastewater system can be based on four critical areas: customer service level, regulatory compliance, risk to public health and safety, and environmental protection.  Conduct assessments on the condition, performance and reliability of current wastewater system assets using the definitions and tables below and assign the ratings to the following tables.  Assessments are to be evaluated on a scale of 1 to 5."]
[null,"·   Current Condition- Rates the condition of the asset.  The higher the number the better the condition of the asset."]
[null,"·   Current Performance- Rates whether the asset meets capacity requirements now and in the future.  The higher the number the better the performance of the asset."]
[null,"·   Current Reliability- Rates the asset based on its frequency of breaking down.  The higher the number the better the reliability of the asset."]
[null,"a. Current Condition Assessment"]
[null,"Rating",null,"Remaining Useful Life",null,null,"Maintenance Level"]
[null,5,null,"New or Excellent Condition",null,null,"Normal Preventive Maintenance"]
[null,4,null,"Minor Defects Only",null,null,"Normal Preventive Maintenance, Minor Corrective Maintenance"]
[null,3,null,"Moderate Deterioration",null,null,"Normal Preventive Maintenance, Major Corrective Maintenance"]
[null,2,null,"Signification Deterioration",null,null,"Major repair, rehabilitate"]
[null,1,null,"Beyond Useful Life",null,null,"Unit Must Be Replaced"]
[null,"b. Current Performance Assessment "]
[null,"Rating",null,"Description"]
[null,5,null,"Exceeds/Meets all Performance Targets"]
[null,4,null,"Minor Performance Deficiencies"]
[null,3,null,"Considerable Performance Deficiencies"]
[null,2,null,"Major Performance Deficiencies"]
[null,1,null,"Fails to Meet Performance Targets"]
[null,"c. Current Reliability Assessment"]
[null,"Rating",null,"Remaining Life",null,null,"Frequency of Failure"]
[null,5,null,"New",null,null,"Almost Negligible "]
[null,4,null,"Seldom Breakdown",null,null,"More than 10 years"]
[null,3,null,"Occasional Breakdown",null,null,"Every 5 Years"]
[null,2,null,"Periodic Breakdown",null,null,"Every 2 Years"]
[null,1,null,"Continuous Breakdown",null,null,"1 Year or Less"]
[]
[]
[]
[null,"2.  Which Assets are the Most Critical? Critical assets have high failure risks (old, poor condition, etc.) and/or major consequences if they do fail (major expense, system failure, safety concerns, environmental damage, water quality impacts, etc.). Some components of a system should take precedence for investment based on risk due to age, condition, and importance or consequence. Components found to be in poor condition, or with severe defects and high failure modes, should be addressed as soon as possible after they are discovered. Less severe defects can be prioritized for more frequent inspection or cleaning, repair, rehabilitation, or replacement. Conduct critical rating assessments of current wastewater system assets using the definitions and tables below and assign the ratings to the following tables: "]
[]
[null,"·   Consequence of Failure- Rates the asset based on the consequences of failure.  Failure of some assets could be detrimental to the total system or facility components. The lower the number the lower the risk. "]
[null,"·   Probability of Failure- Rates the asset based on the percentage of effective life consumed- as an asset ages the likelihood of failure increases.  The lower the number the lower the probability of failure. Enter the percentage shown.  "]
[null,"·   Redundancy- Rates the criticality of the assets based on the availability of backup. Available backup reduces risk. "]
[null,null,"a. Consequence of Failure"]
[null,null,"Rating","Description",null,null,null,"Percentage (%) Affected","Level"]
[null,null,1,"Minor Component Failure",null,null,null,"0 - 25%","Asset"]
[null,null,2,"Major Component Failure",null,null,null,"25 -50%","Asset"]
[null,null,3,"Multiple Asset Failure",null,null,null,"25 - 50%","Facility/Sub-system"]
[null,null,4,"Major Facility Failure",null,null,null,"50 - 100%","Facility"]
[null,null,5,"Minor Sanitary System Failure",null,null,null,"20 - 40%","Total System"]
[null,null,6,"Medium Sanitary System Failure",null,null,null,"40 - 60%","Total System"]
[null,null,7,"Intermdetiate Sanitary System Failure",null,null,null,"60 - 80%","Total System"]
[null,null,8,"Significant Sanitary System Failure",null,null,null,"80 - 90%","Total System"]
[null,null,9,"Total",null,null,null,"90 - 100","Total System"]
[null,null,"b. Probablity of Falure"]
[null,null,"Rating",null,"Percentage (%) of Effective Life Consumed"]
[null,null,1,null,0.2]
[null,null,2,null,0.4]
[null,null,3,null,0.6]
[null,null,4,null,0.8]
[null,null,5,null,1]
[null,null,"c. Curent Redundancy Assessement"]
[null,null,"Rating","Level of Redundancy",null,null,"Reduce Probability of Failure by:"]
[null,null,1,"50% Backup",null,null,0.5]
[null,null,2,"100% Backup",null,null,0.9]
[null,null,3,"200% Secondary Backup",null,null,0.98]
[]
[]
[null,"3.  Renewal and Maintenance Strategy: This asset inventory report will help regional planning agencies acquire a better understanding of their systems and make more informed decisions about future capital investments. An important part of conducting an inventory is determining a strategy of how to manage assets through renewal and maintenance. At some point, continuing to repair the asset will no longer be cost-effective and it will need to be rehabilitated or replaced. A preventive maintenance program will enable you to maximize the useful lives of your assets and can help you avoid problems and cut down or delay replacement costs. Conduct assessments on strategies to renew or maintain assets using the definitions and tables below and assign the options to the following tables: "]
[null,"·   Renewal Strategy- Record decisions on what will be done with each asset.  "]
[null,"·   Maintenance Strategy- Record decisions on the type of maintenance tactics to perform based on the selected renewal strategy."]
[null,"·   Recommended Renewal Date- Renewal date is equivalent to the end of useful life date of an asset per the manufacturer.  You may enter a different date based on your renewal strategy.  This can be used in calculating the future value of the renewal strategy. "]
[null,"·   Costs of Renewal Option- For this example assume all assets will be replaced. Enter your estimate of what the renewal strategy will cost in today’s dollars"]
[null,null,"a. Renewal Strategies"]
[null,null,"Option","Description",null,null,null,"Type"]
[null,null,1,"Do Nothing",null,null,null,"Non-Capital"]
[null,null,2,"Continue with Status Quo",null,null,null,"Non-Capital"]
[null,null,3,"Maintain Differently",null,null,null,"Non-Capital"]
[null,null,4,"Operate Differently",null,null,null,"Non-Capital"]
[null,null,5,"Repair",null,null,null,"Capital"]
[null,null,6,"Refurbish/Rehabilitate",null,null,null,"Capital"]
[null,null,7,"Replace Asset with Similar Asset",null,null,null,"Capital"]
[null,null,8,"Replace with a New or Improved Asset",null,null,null,"Capital"]
[null,null,9,"Reduce Levels of Service or Cause of Failure",null,null,null,"Non-Asset"]
[null,null,"b. Maintenance Strategy"]
[null,null,"Option","Maintenance Tactic"]
[null,null,1,"PM - Preventive Maintenance"]
[null,null,2,"CBM - Condition based maintenance"]
[null,null,3,"UBM - Usage based maintenance"]
[null,null,4,"RTF - Run to failure"]
[null,null,5,"CM - Corrective maintenance"]
[]
[]
[null,null,"Asset Inventory Table Instructions"]
[null,null,"Putting together the inventory requires organization of assets and decisions regarding what level of asset should be included.  This format allows for any level of detail desired, and is capable of classifying a great deal of information about the assets.  Key points are to (1) organize the asset inventory from large to small units; (2) gather information and insert into the appropriate categories; (3) after basic hierarchy is established, additional information can be added as it is obtained (Refer to the table of Examples of Asset Categories and Category Hierarchy)."]
[null,null,"List as many assets within each categorized table as you can and as many characteristics of each asset. Characteristics will vary by asset type. Use the assessment and strategy ratings defined above while taking into account the current condition of each asset, its service history, and your experience based on the characteristics of your system (e.g., weather conditions, operation and maintenance routines).  Get the best information you can, but use estimates if you need to.  For the collection system tables (Tables 4 through 7), grouping of collection lines is recommended.  For example, if collection lines were put into place in the same area during the same period of time and are composed of the same diameter and material, then enter the total linear footage of the same group instead of segmenting them (e.g., downtown, 10,000 feet, 8 inch diameter, Cast Iron, circa 1950)."]
[null,null,"Examples of Asset Categories and Category Hierarchy"]
[null,null,"Asset Categories",null,null,"Asset Category Hierarchy"]
[null,null,"Headworks",null,null,"Screening- Bar Screens, Screens"]
[null,null,null,null,null,"Grit Removal- Blower, Auger, Grit Pumps, Pipes/Valves"]
[null,null,null,null,null,"Electrical- Motor Control"]
[null,null,"Raw Sewage Pumping",null,null,"Pumps- Pump #1, Pump #2, Pipes/Valves"]
[null,null,null,null,null,"Electrical- Motor Control Center, Generator"]
[null,null,null,null,null,"Instrumentation- Flow Meter, Level Sensors"]
[null,null,"Pump Stations"]
[null,null,"Building and Grounds "]
[null,null,"Panels- Alarm/Electrical "]
[null,null,"Collection Structure",null,null,"Manholes- Grinder Pumps"]
[null,null,"Collection System Pipe ",null,null,"Gravity"]
[null,null,null,null,null,"Force Main- Air-Relief Valves"]
[null,null,"Collection Systen Lift Station",null,null,"Pumps- Pump 1,2,3, etc., Valve and Piping"]
[null,null,null,null,null,"Instrumentation- Flow Meter"]
[null,null,null,null,null,"Electrical- Motor Control, Standby Generator"]
[null,null,"Treatment Unit Processes"]
[]
[]
[]
[]
[null,"IV. Project Prioritization and Fund Plan Table Instructions:  \n\nPreparing the asset inventory report allows regional planning agencies to prioritize rehabilitation and replacement projects.  The estimated cost of rehabilitation and replacement activities associated with your highest priority assets are required for completing the funding plan worksheet. Gather information on all of the costs associated with the rehabilitation or replacement of an asset and provide a citation for the source of the estimate.  Costs should only account for funds you will need to replace or rehabilitate your capital assets, and should not include routine operation and maintenance costs. To determine what a rehabilitation or replacement project might cost, you can:\n "]
[null,null,"1.","Consult with your engineer;"]
[null,null,"2.","Ask local contractors for estimated costs;"]
[null,null,"3.","Contact equipment manufacturers; and"]
[null,null,"4.","Talk to other systems about the cost of their rehabilitations or replacements."]
[null,"It is important that you update this worksheet every year, and as new information becomes available, because your system’s priorities and finances may change. Costs of new assets or rehabilitations may also change. Updating your worksheet annually and setting aside the required reserve amount will help ensure that you have enough money to cover the cost of future rehabilitation and replacement projects."]
[null,"It may be overwhelming to see how much money you should be saving each year to fund the replacement and rehabilitation of your assets. You can fund capital improvements by saving the total per year cost of replacements in a reserve account. Alternatively, you can use the money you already have more efficiently and put the savings towards replacing and rehabilitating your assets. Here are some strategies that could help you use your current resources more efficiently or raise additional funds:"]
[null,null,"1.","Form partnerships with other wastewater systems to reduce operating costs. This may allow you to simplify management and obtain bulk purchasing agreements."]
[null,null,"2.","Consider increasing rates to raise revenue."]
[null,null,"3.","Apply for financial assistance. Banks and government funding agencies can help fund infrastructure projects such as treatment system upgrades and collection line repairs. For large projects, you may want to research funding options such as state and federal clean water grant and loan programs."]
[null,"Key decision makers (for example, the board of directors, elected officials of the community, or owners of manufactured housing associations) make critical decisions about the finances of wastewater systems. For this reason, they need to understand the financial needs related to the rehabilitation and replacement of the system’s equipment and assets. The information compiled in this report should be presented to key decision makers and incorporated into the annual budget. This information should be reviewed annually and modified as necessary. The decision makers can also present this information to the public at board meetings."]

{"sheet":"Agency Information","index":1,"n_rows":49,"n_cols":10,"rows_kept":49,"cut":false,"hidden":false,"merged":[[17,8,17,11],[21,1,21,6],[18,1,18,4],[17,1,17,4],[12,5,12,12],[13,5,13,12],[17,5,17,7],[12,2,12,4],[14,6,14,11],[18,5,18,7],[19,5,19,7],[18,8,18,11],[5,1,6,1],[4,2,4,4],[7,2,7,4],[8,2,8,8],[0,1,0,12],[5,2,5,11],[7,8,7,9],[2,1,3,1],[4,5,4,7],[4,9,4,10],[8,9,8,12],[7,10,7,12],[6,2,6,11],[10,5,10,12],[11,5,11,12],[1,4,1,11],[2,2,2,11],[3,2,3,11],[9,2,9,8],[9,9,9,12],[41,1,41,4],[40,1,40,4],[39,1,39,4],[24,1,24,4],[19,1,19,4],[23,1,23,4],[22,1,22,4],[28,1,28,4],[26,1,26,4],[27,1,27,4],[49,6,49,9],[50,6,50,9],[36,5,36,12],[27,5,27,12],[28,5,28,12],[29,5,29,12],[30,5,30,12],[34,5,34,12],[46,6,46,11],[45,6,45,11],[44,6,44,11],[43,6,43,11],[38,8,38,11],[51,6,51,9],[14,2,14,4],[48,6,48,9],[43,1,46,4],[48,1,51,4],[36,1,36,4],[35,1,35,4],[34,1,34,4],[39,8,39,9],[40,8,40,9],[41,8,41,9],[30,1,30,4],[29,1,29,4],[32,1,32,12],[26,5,26,12],[35,5,35,12],[22,5,22,12],[25,5,25,12],[23,5,23,12],[24,5,24,12],[19,8,19,11]]}
[1,"Regional Planning Agency Information"]
[null,"Regional Planning Agency Name"]
[null,"Mailing Address"]
[]
[null,"City",null,null,null,"State",null,null,null,"Zip"]
[null,"Physical Address            (if different)"]
[]
[null,"City",null,null,null,null,"Zip"]
[null,"Contact Person"]
[null,"Title"]
[null,"Telephone Number"]
[null,"Fax Number"]
[null,"E-mail Address"]
[null,"Website"]
[null,"KPDES/KISOP Number"]
[]
[null,"Name of watershed(s) within the planning area",null,null,null,null,null,null,"Hydrological Unit Code (HUC) 10"]
[]
[]
[]
[]
[null,"Waterbodies within the planning area listed as impaired waters in the Integrated Report to Congress on Water Quality in Kentucky."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[2,"Discharge Information"]
[null,"Discharge Type (e.g. discharge to another facility, subsurface discharge, outfall to surface waters, reuse)"]
[]
[]
[]
[]
[null,"Name of Receiving Water(s)",null,null,null,null,"Milepoint",null,"or       Latitude and Longitude        "]
[]
[]
[]
[]
[null,"Does the WWTP discharge its effluent in another manner besides directly to a stream (e.g. land application, underground percolation, hydrologic controlled release [HCR], well injection)?  If yes, provide method."]
[]
[]
[]
[]
[null,"Does the system discharge to or receive wastewater from other municipalities or service area?  Provide applicable names and KPDES and/or KISOP permit numbers."]

{"sheet":"Facility Effluent Treatment","index":2,"n_rows":75,"n_cols":10,"rows_kept":75,"cut":false,"hidden":false,"merged":[[58,2,58,3],[82,1,82,2],[80,1,80,2],[78,1,78,2],[76,1,76,2],[60,1,60,3],[74,1,74,3],[62,1,62,3],[64,1,64,3],[66,1,66,3],[68,1,68,3],[70,1,70,3],[72,1,72,3],[37,0,44,0],[42,1,42,7],[36,7,36,8],[36,4,36,5],[37,4,37,5],[37,7,37,8],[40,4,40,5],[40,7,40,8],[43,4,43,5],[43,7,43,8],[44,7,44,8],[44,4,44,5],[41,7,41,8],[41,4,41,5],[0,1,0,9],[24,1,24,9],[8,1,8,9],[4,5,4,6],[4,2,4,3],[4,7,4,9],[1,0,1,9],[3,5,3,9],[2,5,2,9],[6,8,6,9],[6,4,6,6],[16,1,16,2],[14,1,14,2],[12,1,12,2],[10,1,10,2],[22,7,22,9],[56,1,56,3],[51,1,51,3],[35,4,35,5],[35,7,35,8],[38,4,38,5],[38,7,38,8],[36,1,36,3],[38,1,38,3],[44,1,44,3],[41,1,41,3],[50,1,50,9],[52,1,52,3],[54,1,54,3],[34,1,34,6],[34,7,34,8],[39,1,39,5],[26,7,26,8],[26,1,26,2],[28,1,28,2],[32,7,32,8],[26,4,26,5],[32,4,32,6],[33,4,33,6],[33,7,33,8],[20,7,20,9],[22,1,22,2],[20,1,20,2],[25,7,25,8],[25,4,25,5],[16,7,16,9],[18,7,18,9],[18,1,18,2],[14,7,14,9],[12,7,12,9],[10,7,10,9],[6,0,6,3],[2,1,2,3],[3,1,3,3],[9,0,9,2],[9,6,9,8]]}
[3,"Facility Effluent Treatment Level"]
["What levels of treatment are provided?  Check all that apply."]
[null,"Preliminary",null,null,null,"Secondary"]
[null,"Primary",null,null,null,"Advanced"]
[null,"Other Describe:",null,null,null,"Other Describe:"]
[]
["Projected (Indicate the level of treatment and projected date):"]
[]
[4,"Facility Type  "]
["Facility Type",null,null,null,"Present",null,"Projected"]
[null,"Headworks"]
[]
[null,"Treatment"]
[]
[null,"Disinfectikon"]
[]
[null,"biosolids"]
[]
[]
[]
[]
[]
[]
[]
[5,"Flow and Population Served.   Each year's data must be based on a 12-month time period"]
[null,null,null,null,"Present",null,null,"Projected in 10 years"]
["a.","Design Flow Rate (mgd)"]
[null,null,null,null,"2 Yrs Ago",null,"Last Year",null,"This Year"]
["b.","Annual average daily flow rate (mgd)"]
[null,null,null,null,"2 Yrs Ago",null,"Last Year",null,"This Year"]
["c.","Maximum (Peak) daily flow rate (mgd)"]
[]
["d.","Average daily flow projected in 10 years (mgd)"]
[]
["e.","Average inflow & Infiltration. Estimates should be based on most recent data (mgd)"]
[null,null,null,null,"Present",null,null,"Projected in 10 years"]
["f.","Residential flow contribution (mgd)"]
[null,null,null,null,"Present",null,null,"Projected in 10 years"]
[null,"Commercial/industrial flow contribution (mgd)"]
[null,"(Projections should be based on 1,000 to 1,500 gallons per day/acre)"]
[null,null,null,null,"Present",null,null,"Projected in 10 years"]
[null,"Population served (persons)"]
[null,"(Calculations should be based on Census data specific to the service area or No. of accounts X 2.5)"]
[null,null,null,null,"Present",null,null,"Projected in 10 years"]
[null,"Unserved population in the planning area"]
[]
[null,"Does the system have a pretreatment program?",null,null,"Yes",null,null,"No"]
[]
[]
[]
[6,"Treatment Plant Discharge Limits"]
[null,"Parameter",null,null,"Monthly Average",null,"Daily Maximum",null,"Daily Minimum"]
[null,"Biological Oxygen Demand (BOD5; mg/l) or CBOD5",null,null,null,null,null,null,null,"mg/l"]
[]
[null,"Total Suspended Solids (TSS; mg/l)",null,null,null,null,null,null,null,"mg/l"]
[]
[null,"Ammonia Nitrogen:  Summer",null,null,null,null,null,null,null,"mg/l"]
[]
[null,null,"      Winter",null,null,null,null,null,null,"mg/l"]
[]
[null,"Dissolved Oxygen (mg/l)",null,null,null,null,null,null,null,"mg/l"]
[]
[null,"Fecal Coliform (colonies/100ml)",null,null,null,null,null,null,null,"col/100 mls"]
[]
[null,"Escherichia coli (colonies/100ml)",null,null,null,null,null,null,null,"col/100 mls"]
[]
[null,"pH (standard units)",null,null,null,null,null,null,null,"S.U."]
[]
[null,"Total Residual Chlorine (mg/l)",null,null,null,null,null,null,null,"mg/l"]
[]
[null,"Phosphorus (Total; mg/l)",null,null,null,null,null,null,null,"mg/l"]
[]
[null,"Total Nitrogen (mg/l)",null,null,null,null,null,null,null,"mg/l"]
[]
[null,"Biomonitoring (Tuc)",null,null,null,null,null,null,null,"Tuc"]

{"sheet":"Revenues & Expenses","index":3,"n_rows":47,"n_cols":19,"rows_kept":47,"cut":false,"hidden":false,"merged":[[36,6,36,7],[36,9,36,10],[36,12,36,13],[36,15,36,16],[41,3,41,4],[41,6,41,7],[41,9,41,10],[41,12,41,13],[41,15,41,16],[38,3,38,4],[38,6,38,7],[38,9,38,10],[38,12,38,13],[42,3,42,4],[42,6,42,7],[42,9,42,10],[42,12,42,13],[42,15,42,16],[42,18,42,19],[44,1,44,2],[44,3,44,4],[44,6,44,7],[44,9,44,10],[44,12,44,13],[44,15,44,16],[44,18,44,19],[31,12,31,13],[31,9,31,10],[31,6,31,7],[31,3,31,4],[33,3,33,4],[33,6,33,7],[33,9,33,10],[33,12,33,13],[33,15,33,16],[32,3,32,4],[32,6,32,7],[32,9,32,10],[32,12,32,13],[32,15,32,16],[35,3,35,4],[40,1,40,2],[40,3,40,4],[40,6,40,7],[40,9,40,10],[40,12,40,13],[40,15,40,16],[40,18,40,19],[35,6,35,7],[35,9,35,10],[35,12,35,13],[35,15,35,16],[35,18,35,19],[39,3,39,4],[39,6,39,7],[39,9,39,10],[39,12,39,13],[39,15,39,16],[32,1,36,1],[34,3,34,4],[34,6,34,7],[34,9,34,10],[34,12,34,13],[36,3,36,4],[28,12,28,13],[28,15,28,16],[28,18,28,19],[30,1,30,2],[30,3,30,4],[30,6,30,7],[30,9,30,10],[30,12,30,13],[30,15,30,16],[30,18,30,19],[0,1,0,19],[24,1,24,4],[24,6,24,17],[25,3,25,4],[12,18,12,19],[14,18,14,19],[16,18,16,19],[18,18,18,19],[20,18,20,19],[22,18,22,19],[14,15,14,16],[12,15,12,16],[11,3,11,4],[22,9,22,10],[20,9,20,10],[18,9,18,10],[14,3,14,4],[12,3,12,4],[2,13,2,15],[2,9,2,10],[2,1,2,7],[4,1,4,6],[4,9,4,12],[6,9,6,10],[46,18,46,19],[31,18,31,19],[33,18,33,19],[32,18,32,19],[39,18,39,19],[22,15,22,16],[20,15,20,16],[18,15,18,16],[16,15,16,16],[46,15,46,16],[26,15,26,16],[26,18,26,19],[34,15,34,16],[34,18,34,19],[36,18,36,19],[31,15,31,16],[41,18,41,19],[38,15,38,16],[38,18,38,19],[45,1,45,2],[46,1,46,2],[46,3,46,4],[46,6,46,7],[46,9,46,10],[46,12,46,13],[16,9,16,10],[14,9,14,10],[12,9,12,10],[22,12,22,13],[20,12,20,13],[18,12,18,13],[16,12,16,13],[14,12,14,13],[12,12,12,13],[26,1,26,2],[26,3,26,4],[26,6,26,7],[26,9,26,10],[26,12,26,13],[28,1,28,2],[28,3,28,4],[28,6,28,7],[28,9,28,10],[6,13,6,15],[5,9,5,10],[5,13,5,15],[22,6,22,7],[20,6,20,7],[18,6,18,7],[16,6,16,7],[16,1,16,2],[18,1,18,2],[20,1,20,2],[22,1,22,2],[21,1,21,2],[22,3,22,4],[20,3,20,4],[18,3,18,4],[16,3,16,4],[1,16,1,17],[2,16,2,17],[8,16,8,17],[9,16,9,17],[10,6,10,17],[12,1,12,2],[14,1,14,2],[6,1,6,6],[9,1,9,6],[8,9,8,10],[3,7,3,17],[4,16,4,17],[5,16,5,17],[6,16,6,17],[7,16,7,17],[1,9,1,10],[1,13,1,15],[14,6,14,7],[12,6,12,7],[7,9,7,10],[7,13,7,15],[8,1,8,7],[8,13,8,15],[10,1,10,4]]}
[8,"REVENUES AND EXPENSES"]
[null,null,null,null,null,null,null,null,null,"Year",null,null,null,"Month"]
["1.","Current Fiscal Year and First Month of the Fiscal Year"]
[]
["2.","Median Household Income (MHI) of the Service Area ",null,null,null,null,null,"$"]
[null,null,null,null,null,null,null,null,null,"Residential",null,null,null,"Commercial"]
["3.","Current User Charge Per Month  per 4,000 gallons",null,null,null,null,null,"$",null,null,null,null,"$"]
[null,null,null,null,null,null,null,null,null,"Residential",null,null,null,"Commercial"]
["4.","Projected User Charge Per Mo. Over Next Two Years per 4,000 gal.             $",null,null,null,null,null,null,null,null,null,null,"$"]
[]
["5.","Annual Revenues                                                                         ",null,null,null,null,"Enter Expected Future Changes in Revenues (in current year dollars)"]
[null,null,null,"Current Year",null,null,"Year",null,null,"Year",null,null,"Year",null,null,"Year",null,null,"Year"]
[null,"Total retail user charges"]
[]
[null,"Total wholesale user charges"]
[]
[null,"Interest earned"]
[]
[null,"Funds drawn from reserves"]
[]
[null,"Other revenues"]
[null,"(tap-on fees; impact fees, etc.)"]
[null,"TOTAL",null,{"$f":"SUM(D13:E21)","v":0},null,null,{"$f":"SUM(G13:H21)","v":0},null,null,{"$f":"SUM(J13:K21)","v":0},null,null,{"$f":"SUM(M13:N21)","v":0},null,null,{"$f":"SUM(P13:Q21)","v":0},null,null,{"$f":"SUM(S13:T21)","v":0}]
[]
["6.","Annual Expenses                                                                         ",null,null,null,null,"Enter Expected Future Changes in Expenses (in current year dollars)"]
[null,null,null,"Current Year",null,null,"Year",null,null,"Year",null,null,"Year",null,null,"Year",null,null,"Year"]
[null,"Salaries, wages, benefits"]
[]
[null,"Supplies, equipment, chemicals"]
[]
[null,"Repairs and parts"]
[null,null,null,"Electric",null,null,"Electric",null,null,"Electric",null,null,"Electric",null,null,"Electric",null,null,"Electric"]
[null,"Utilities"]
[null,null,null,"Water",null,null,"Water",null,null,"Water",null,null,"Water",null,null,"Water",null,null,"Water"]
[]
[null,null,null,"Gas",null,null,"Gas",null,null,"Gas",null,null,"Gas",null,null,"Gas",null,null,"Gas"]
[]
[]
[null,"Payments to other facilities"]
[]
[null,"Funds added to reserves"]
[]
[null,"Debt service"]
[]
[null,"Other expenses"]
[]
[null,"TOTAL",null,{"$f":"SUM(D27:E45)","v":0},null,null,{"$f":"SUM(G27:H45)","v":0},null,null,{"$f":"SUM(J27:K45)","v":0},null,null,{"$f":"SUM(M27:N45)","v":0},null,null,{"$f":"SUM(P27:Q45)","v":0},null,null,{"$f":"SUM(S27:T45)","v":0}]

{"sheet":"Gravity Pipes-Manholes","index":4,"n_rows":452,"n_cols":19,"rows_kept":452,"cut":false,"hidden":false,"merged":[[0,0,2,0],[1,7,1,9],[1,10,1,12],[1,13,1,16],[1,1,2,1],[0,1,0,16],[1,5,2,5],[1,6,2,6]]}
[null,"Collection System: Gravity Pipes & Manholes - Existing"]
[null,"Description","Description of Manholes","Pipe Length","Pipe Size","Pipe Material","Year Installed","Assessment Ratings",null,null,"Failure Ratings",null,null,"Renewal and Maintenance Strategy"]
[null,null,"(diameter, material, lid type)","Feet","Inches",null,null,"Condition","Performance","Reliability","Consequence","Probability","Redundancy","Renewal Strategy","Maintenance Strategy","R&M Date","Estimated Cost of R&M Option  $"]
["Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9","Column10","Column11","Column12","Column13","Column14","Column15","Column16","Column17",null,5]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[{"$f":"+A5+1","v":2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[{"$f":"+A6+1","v":3},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[5]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[15]
[16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[21]
[22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[{"$f":"+A70+1","v":67}]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]
[101]
[102]
[103]
[104]
[105]
[106]
[107]
[108]
[109]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122]
[123]
[124]
[125]
[126]
[127]
[128]
[129]
[130]
[{"$f":"+A134+1","v":131}]
[132]
[133]
[134]
[135]
[136]
[137]
[138]
[139]
[140]
[141]
[142]
[143]
[144]
[145]
[146]
[147]
[148]
[149]
[150]
[151]
[152]
[153]
[154]
[155]
[156]
[157]
[158]
[159]
[160]
[161]
[162]
[163]
[164]
[165]
[166]
[167]
[168]
[169]
[170]
[171]
[172]
[173]
[174]
[175]
[176]
[177]
[178]
[179]
[180]
[181]
[182]
[183]
[184]
[185]
[186]
[187]
[188]
[189]
[190]
[191]
[192]
[193]
[194]
[{"$f":"+A198+1","v":195}]
[196]
[197]
[198]
[199]
[200]
[201]
[202]
[203]
[204]
[205]
[206]
[207]
[208]
[209]
[210]
[211]
[212]
[213]
[214]
[215]
[216]
[217]
[218]
[219]
[220]
[221]
[222]
[223]
[224]
[225]
[226]
[227]
[228]
[229]
[230]
[231]
[232]
[233]
[234]
[235]
[236]
[237]
[238]
[239]
[240]
[241]
[242]
[243]
[244]
[245]
[246]
[247]
[248]
[249]
[250]
[251]
[252]
[253]
[254]
[255]
[256]
[257]
[258]
[{"$f":"+A262+1","v":259}]
[260]
[261]
[262]
[263]
[264]
[265]
[266]
[267]
[268]
[269]
[270]
[271]
[272]
[273]
[274]
[275]
[276]
[277]
[278]
[279]
[280]
[281]
[282]
[283]
[284]
[285]
[286]
[287]
[288]
[289]
[290]
[291]
[292]
[293]
[294]
[295]
[296]
[297]
[298]
[299]
[300]
[301]
[302]
[303]
[304]
[305]
[306]
[307]
[308]
[309]
[310]
[311]
[312]
[313]
[314]
[315]
[316]
[317]
[318]
[319]
[320]
[321]
[322]
[{"$f":"+A326+1","v":323}]
[324]
[325]
[326]
[327]
[328]
[329]
[330]
[331]
[332]
[333]
[334]
[335]
[336]
[337]
[338]
[339]
[340]
[341]
[342]
[343]
[344]
[345]
[346]
[347]
[348]
[349]
[350]
[351]
[352]
[353]
[354]
[355]
[356]
[357]
[358]
[359]
[360]
[361]
[362]
[363]
[364]
[365]
[366]
[367]
[368]
[369]
[370]
[371]
[372]
[373]
[374]
[375]
[376]
[377]
[378]
[379]
[380]
[381]
[382]
[383]
[384]
[385]
[386]
[{"$f":"+A390+1","v":387}]
[388]
[389]
[390]
[391]
[392]
[393]
[394]
[395]
[396]
[397]
[398]
[399]
[400]
[401]
[402]
[403]
[404]
[405]
[406]
[407]
[408]
[409]
[410]
[411]
[412]
[413]
[414]
[415]
[416]
[417]
[418]
[419]
[420]
[421]
[422]
[423]
[424]
[425]
[426]
[427]
[428]
[429]
[430]
[431]
[432]
[433]
[434]
[435]
[436]
[437]
[438]
[439]
[440]
[441]
[442]
[443]
[444]
[445]
[446]
[447]
[{"$f":"+A451+1","v":448}]

{"sheet":"Proposed Gravity Pipes-Manholes","index":5,"n_rows":452,"n_cols":19,"rows_kept":452,"cut":false,"hidden":false,"merged":[[1,10,3,10],[1,15,3,15],[1,1,3,1],[1,2,3,2],[0,0,3,0],[0,1,0,15],[1,11,3,11],[1,7,3,7],[1,14,3,14],[1,12,1,13],[1,3,1,6],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,6,3,6],[1,8,2,8],[1,9,2,9]]}
[null,"Collection System Gravity Pipes and Manholes - Proposed Projects"]
[null,"Proposed Project Title","Project Description","Type",null,null,null,"Number of New Manholes","Pipe Length","Pipe Size","Pipe Material","Year Planned","If Known",null,"Plans & Specs Approved?","Funding In Place?"]
[null,null,null,"Extension","Rehab","Replace","Abandon",null,null,null,null,null,"Manufacturer's Predicted Life","Estimated Project Cost "]
[null,null,null,null,null,null,null,null,"Feet","Inches",null,null,"Years","$",null,null,null,null,"Yes"]
["Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9","Column10","Column11","Column12","Column13","Column14","Column15","Column16",null,null,"No"]
[1]
[{"$f":"+A6+1","v":2}]
[{"$f":"+A7+1","v":3}]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[{"$f":"+A71+1","v":67}]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]
[101]
[102]
[103]
[104]
[105]
[106]
[107]
[108]
[109]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122]
[123]
[124]
[125]
[126]
[127]
[128]
[129]
[130]
[{"$f":"+A135+1","v":131}]
[132]
[133]
[134]
[135]
[136]
[137]
[138]
[139]
[140]
[141]
[142]
[143]
[144]
[145]
[146]
[147]
[148]
[149]
[150]
[151]
[152]
[153]
[154]
[155]
[156]
[157]
[158]
[159]
[160]
[161]
[162]
[163]
[164]
[165]
[166]
[167]
[168]
[169]
[170]
[171]
[172]
[173]
[174]
[175]
[176]
[177]
[178]
[179]
[180]
[181]
[182]
[183]
[184]
[185]
[186]
[187]
[188]
[189]
[190]
[191]
[192]
[193]
[194]
[{"$f":"+A199+1","v":195}]
[196]
[197]
[198]
[199]
[200]
[201]
[202]
[203]
[204]
[205]
[206]
[207]
[208]
[209]
[210]
[211]
[212]
[213]
[214]
[215]
[216]
[217]
[218]
[219]
[220]
[221]
[222]
[223]
[224]
[225]
[226]
[227]
[228]
[229]
[230]
[231]
[232]
[233]
[234]
[235]
[236]
[237]
[238]
[239]
[240]
[241]
[242]
[243]
[244]
[245]
[246]
[247]
[248]
[249]
[250]
[251]
[252]
[253]
[254]
[255]
[256]
[257]
[258]
[{"$f":"+A263+1","v":259}]
[260]
[261]
[262]
[263]
[264]
[265]
[266]
[267]
[268]
[269]
[270]
[271]
[272]
[273]
[274]
[275]
[276]
[277]
[278]
[279]
[280]
[281]
[282]
[283]
[284]
[285]
[286]
[287]
[288]
[289]
[290]
[291]
[292]
[293]
[294]
[295]
[296]
[297]
[298]
[299]
[300]
[301]
[302]
[303]
[304]
[305]
[306]
[307]
[308]
[309]
[310]
[311]
[312]
[313]
[314]
[315]
[316]
[317]
[318]
[319]
[320]
[321]
[322]
[{"$f":"+A327+1","v":323}]
[324]
[325]
[326]
[327]
[328]
[329]
[330]
[331]
[332]
[333]
[334]
[335]
[336]
[337]
[338]
[339]
[340]
[341]
[342]
[343]
[344]
[345]
[346]
[347]
[348]
[349]
[350]
[351]
[352]
[353]
[354]
[355]
[356]
[357]
[358]
[359]
[360]
[361]
[362]
[363]
[364]
[365]
[366]
[367]
[368]
[369]
[370]
[371]
[372]
[373]
[374]
[375]
[376]
[377]
[378]
[379]
[380]
[381]
[382]
[383]
[384]
[385]
[386]
[{"$f":"+A391+1","v":387}]
[388]
[389]
[390]
[391]
[392]
[393]
[394]
[395]
[396]
[397]
[398]
[399]
[400]
[401]
[402]
[403]
[404]
[405]
[406]
[407]
[408]
[409]
[410]
[411]
[412]
[413]
[414]
[415]
[416]
[417]
[418]
[419]
[420]
[421]
[422]
[423]
[424]
[425]
[426]
[427]
[428]
[429]
[430]
[431]
[432]
[433]
[434]
[435]
[436]
[437]
[438]
[439]
[440]
[441]
[442]
[443]
[444]
[445]
[446]
[447]

{"sheet":"Pressure Lines","index":6,"n_rows":452,"n_cols":19,"rows_kept":452,"cut":false,"hidden":false,"merged":[[0,0,2,0],[0,1,0,16],[1,1,2,1],[1,7,1,9],[1,10,1,12],[1,13,1,16],[1,5,2,5],[1,6,2,6]]}
[null,"Pressure Line/Force Mains and Air-Release Valves - Existing"]
[null,"Description","Description of AR Valves","Pipe Length","Pipe Size","Pipe Material","Year Installed","Assessment Ratings",null,null,"Failure Ratings",null,null,"Renewal and Maintenance Strategy"]
[null,null,"(size and type)","Feet","Inches",null,null,"Condition","Performance","Reliability","Consequence","Probability","Redundancy","Renewal Strategy","Maintenance Strategy","R&M Date","Estimated Cost of R&M Option  $"]
["Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9","Column10","Column11","Column12","Column13","Column14","Column15","Column16","Column17",null,5]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[{"$f":"+A5+1","v":2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[{"$f":"+A6+1","v":3},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[5]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[15]
[16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[21]
[22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[{"$f":"+A70+1","v":67}]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]
[101]
[102]
[103]
[104]
[105]
[106]
[107]
[108]
[109]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122]
[123]
[124]
[125]
[126]
[127]
[128]
[129]
[130]
[{"$f":"+A134+1","v":131}]
[132]
[133]
[134]
[135]
[136]
[137]
[138]
[139]
[140]
[141]
[142]
[143]
[144]
[145]
[146]
[147]
[148]
[149]
[150]
[151]
[152]
[153]
[154]
[155]
[156]
[157]
[158]
[159]
[160]
[161]
[162]
[163]
[164]
[165]
[166]
[167]
[168]
[169]
[170]
[171]
[172]
[173]
[174]
[175]
[176]
[177]
[178]
[179]
[180]
[181]
[182]
[183]
[184]
[185]
[186]
[187]
[188]
[189]
[190]
[191]
[192]
[193]
[194]
[{"$f":"+A198+1","v":195}]
[196]
[197]
[198]
[199]
[200]
[201]
[202]
[203]
[204]
[205]
[206]
[207]
[208]
[209]
[210]
[211]
[212]
[213]
[214]
[215]
[216]
[217]
[218]
[219]
[220]
[221]
[222]
[223]
[224]
[225]
[226]
[227]
[228]
[229]
[230]
[231]
[232]
[233]
[234]
[235]
[236]
[237]
[238]
[239]
[240]
[241]
[242]
[243]
[244]
[245]
[246]
[247]
[248]
[249]
[250]
[251]
[252]
[253]
[254]
[255]
[256]
[257]
[258]
[{"$f":"+A262+1","v":259}]
[260]
[261]
[262]
[263]
[264]
[265]
[266]
[267]
[268]
[269]
[270]
[271]
[272]
[273]
[274]
[275]
[276]
[277]
[278]
[279]
[280]
[281]
[282]
[283]
[284]
[285]
[286]
[287]
[288]
[289]
[290]
[291]
[292]
[293]
[294]
[295]
[296]
[297]
[298]
[299]
[300]
[301]
[302]
[303]
[304]
[305]
[306]
[307]
[308]
[309]
[310]
[311]
[312]
[313]
[314]
[315]
[316]
[317]
[318]
[319]
[320]
[321]
[322]
[{"$f":"+A326+1","v":323}]
[324]
[325]
[326]
[327]
[328]
[329]
[330]
[331]
[332]
[333]
[334]
[335]
[336]
[337]
[338]
[339]
[340]
[341]
[342]
[343]
[344]
[345]
[346]
[347]
[348]
[349]
[350]
[351]
[352]
[353]
[354]
[355]
[356]
[357]
[358]
[359]
[360]
[361]
[362]
[363]
[364]
[365]
[366]
[367]
[368]
[369]
[370]
[371]
[372]
[373]
[374]
[375]
[376]
[377]
[378]
[379]
[380]
[381]
[382]
[383]
[384]
[385]
[386]
[{"$f":"+A390+1","v":387}]
[388]
[389]
[390]
[391]
[392]
[393]
[394]
[395]
[396]
[397]
[398]
[399]
[400]
[401]
[402]
[403]
[404]
[405]
[406]
[407]
[408]
[409]
[410]
[411]
[412]
[413]
[414]
[415]
[416]
[417]
[418]
[419]
[420]
[421]
[422]
[423]
[424]
[425]
[426]
[427]
[428]
[429]
[430]
[431]
[432]
[433]
[434]
[435]
[436]
[437]
[438]
[439]
[440]
[441]
[442]
[443]
[444]
[445]
[446]
[447]
[{"$f":"+A451+1","v":448}]

{"sheet":"Proposed Pressure Lines","index":7,"n_rows":452,"n_cols":19,"rows_kept":452,"cut":false,"hidden":false,"merged":[[0,0,3,0],[0,1,0,15],[1,1,3,1],[1,2,3,2],[1,3,1,6],[1,7,3,7],[1,8,2,8],[1,12,1,13],[1,14,3,14],[1,15,3,15],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,6,3,6],[1,9,2,9],[1,10,3,10],[1,11,3,11]]}
[null,"Pressure Line/Force Main and Air-Release Valves - Proposed Projects"]
[null,"Proposed Project Title","Project Description","Type",null,null,null,"Number of New AR Valves","Pipe Length","Pipe Size","Pipe Material","Year Planned","If Known",null,"Plans & Specs Approved?","Funding In Place?"]
[null,null,null,"Expansion","Rehab","Replace","Abandon",null,null,null,null,null,"Manufacturer's Predicted Life","Estimated Project Cost "]
[null,null,null,null,null,null,null,null,"Feet","Inches",null,null,"Years","$",null,null,null,null,"Yes"]
["Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9","Column10","Column11","Column12","Column13","Column14","Column15","Column16",null,null,"No"]
[1]
[{"$f":"+A6+1","v":2}]
[{"$f":"+A7+1","v":3}]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[{"$f":"+A71+1","v":67}]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]
[101]
[102]
[103]
[104]
[105]
[106]
[107]
[108]
[109]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122]
[123]
[124]
[125]
[126]
[127]
[128]
[129]
[130]
[{"$f":"+A135+1","v":131}]
[132]
[133]
[134]
[135]
[136]
[137]
[138]
[139]
[140]
[141]
[142]
[143]
[144]
[145]
[146]
[147]
[148]
[149]
[150]
[151]
[152]
[153]
[154]
[155]
[156]
[157]
[158]
[159]
[160]
[161]
[162]
[163]
[164]
[165]
[166]
[167]
[168]
[169]
[170]
[171]
[172]
[173]
[174]
[175]
[176]
[177]
[178]
[179]
[180]
[181]
[182]
[183]
[184]
[185]
[186]
[187]
[188]
[189]
[190]
[191]
[192]
[193]
[194]
[{"$f":"+A199+1","v":195}]
[196]
[197]
[198]
[199]
[200]
[201]
[202]
[203]
[204]
[205]
[206]
[207]
[208]
[209]
[210]
[211]
[212]
[213]
[214]
[215]
[216]
[217]
[218]
[219]
[220]
[221]
[222]
[223]
[224]
[225]
[226]
[227]
[228]
[229]
[230]
[231]
[232]
[233]
[234]
[235]
[236]
[237]
[238]
[239]
[240]
[241]
[242]
[243]
[244]
[245]
[246]
[247]
[248]
[249]
[250]
[251]
[252]
[253]
[254]
[255]
[256]
[257]
[258]
[{"$f":"+A263+1","v":259}]
[260]
[261]
[262]
[263]
[264]
[265]
[266]
[267]
[268]
[269]
[270]
[271]
[272]
[273]
[274]
[275]
[276]
[277]
[278]
[279]
[280]
[281]
[282]
[283]
[284]
[285]
[286]
[287]
[288]
[289]
[290]
[291]
[292]
[293]
[294]
[295]
[296]
[297]
[298]
[299]
[300]
[301]
[302]
[303]
[304]
[305]
[306]
[307]
[308]
[309]
[310]
[311]
[312]
[313]
[314]
[315]
[316]
[317]
[318]
[319]
[320]
[321]
[322]
[{"$f":"+A327+1","v":323}]
[324]
[325]
[326]
[327]
[328]
[329]
[330]
[331]
[332]
[333]
[334]
[335]
[336]
[337]
[338]
[339]
[340]
[341]
[342]
[343]
[344]
[345]
[346]
[347]
[348]
[349]
[350]
[351]
[352]
[353]
[354]
[355]
[356]
[357]
[358]
[359]
[360]
[361]
[362]
[363]
[364]
[365]
[366]
[367]
[368]
[369]
[370]
[371]
[372]
[373]
[374]
[375]
[376]
[377]
[378]
[379]
[380]
[381]
[382]
[383]
[384]
[385]
[386]
[{"$f":"+A391+1","v":387}]
[388]
[389]
[390]
[391]
[392]
[393]
[394]
[395]
[396]
[397]
[398]
[399]
[400]
[401]
[402]
[403]
[404]
[405]
[406]
[407]
[408]
[409]
[410]
[411]
[412]
[413]
[414]
[415]
[416]
[417]
[418]
[419]
[420]
[421]
[422]
[423]
[424]
[425]
[426]
[427]
[428]
[429]
[430]
[431]
[432]
[433]
[434]
[435]
[436]
[437]
[438]
[439]
[440]
[441]
[442]
[443]
[444]
[445]
[446]
[447]

{"sheet":"Pump Stations","index":8,"n_rows":454,"n_cols":19,"rows_kept":454,"cut":false,"hidden":false,"merged":[[2,7,3,7],[2,8,3,8],[2,14,3,14],[1,1,3,1],[0,0,3,0],[0,1,0,15],[2,2,3,2],[2,15,3,15],[2,9,3,9],[2,10,3,10],[2,11,3,11],[2,12,3,12],[2,13,3,13],[1,3,2,3],[1,4,2,4],[1,6,1,8],[1,9,1,11],[1,12,1,15],[1,5,3,5],[2,6,3,6]]}
[null,"Pump Stations - Existing"]
[null,"Pump Station Name","Type","Capacity","Total Dynamic Head","Year Installed","Assessment Ratings",null,null,"Failure Ratings",null,null,"Renewal and Maintenance Strategy"]
[null,null,"(e.g. submersible, centrifugal, etc.)",null,null,null,"Condition","Performance","Reliability","Consequence","Probability","Redundancy","Renewal Strategy","Maintenance Strategy","R&M Date","Estimated Cost of R&M Option  $"]
[null,null,null,"gpm","Feet",null,null,null,null,null,null,null,null,null,null,null,null,null,5]
["Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9","Column10","Column11","Column12","Column13","Column14","Column15","Column16",null,null,4]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[{"$f":"+A6+1","v":2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[{"$f":"+A7+1","v":3},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[4]
[5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[14]
[15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[20]
[21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[{"$f":"+A71+1","v":67}]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]
[101]
[102]
[103]
[104]
[105]
[106]
[107]
[108]
[109]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122]
[123]
[124]
[125]
[126]
[127]
[128]
[129]
[130]
[{"$f":"+A135+1","v":131}]
[132]
[133]
[134]
[135]
[136]
[137]
[138]
[139]
[140]
[141]
[142]
[143]
[144]
[145]
[146]
[147]
[148]
[149]
[150]
[151]
[152]
[153]
[154]
[155]
[156]
[157]
[158]
[159]
[160]
[161]
[162]
[163]
[164]
[165]
[166]
[167]
[168]
[169]
[170]
[171]
[172]
[173]
[174]
[175]
[176]
[177]
[178]
[179]
[180]
[181]
[182]
[183]
[184]
[185]
[186]
[187]
[188]
[189]
[190]
[191]
[192]
[193]
[194]
[{"$f":"+A199+1","v":195}]
[196]
[197]
[198]
[199]
[200]
[201]
[202]
[203]
[204]
[205]
[206]
[207]
[208]
[209]
[210]
[211]
[212]
[213]
[214]
[215]
[216]
[217]
[218]
[219]
[220]
[221]
[222]
[223]
[224]
[225]
[226]
[227]
[228]
[229]
[230]
[231]
[232]
[233]
[234]
[235]
[236]
[237]
[238]
[239]
[240]
[241]
[242]
[243]
[244]
[245]
[246]
[247]
[248]
[249]
[250]
[251]
[252]
[253]
[254]
[255]
[256]
[257]
[258]
[{"$f":"+A263+1","v":259}]
[260]
[261]
[262]
[263]
[264]
[265]
[266]
[267]
[268]
[269]
[270]
[271]
[272]
[273]
[274]
[275]
[276]
[277]
[278]
[279]
[280]
[281]
[282]
[283]
[284]
[285]
[286]
[287]
[288]
[289]
[290]
[291]
[292]
[293]
[294]
[295]
[296]
[297]
[298]
[299]
[300]
[301]
[302]
[303]
[304]
[305]
[306]
[307]
[308]
[309]
[310]
[311]
[312]
[313]
[314]
[315]
[316]
[317]
[318]
[319]
[320]
[321]
[322]
[{"$f":"+A327+1","v":323}]
[324]
[325]
[326]
[327]
[328]
[329]
[330]
[331]
[332]
[333]
[334]
[335]
[336]
[337]
[338]
[339]
[340]
[341]
[342]
[343]
[344]
[345]
[346]
[347]
[348]
[349]
[350]
[351]
[352]
[353]
[354]
[355]
[356]
[357]
[358]
[359]
[360]
[361]
[362]
[363]
[364]
[365]
[366]
[367]
[368]
[369]
[370]
[371]
[372]
[373]
[374]
[375]
[376]
[377]
[378]
[379]
[380]
[381]
[382]
[383]
[384]
[385]
[386]
[{"$f":"+A391+1","v":387}]
[388]
[389]
[390]
[391]
[392]
[393]
[394]
[395]
[396]
[397]
[398]
[399]
[400]
[401]
[402]
[403]
[404]
[405]
[406]
[407]
[408]
[409]
[410]
[411]
[412]
[413]
[414]
[415]
[416]
[417]
[418]
[419]
[420]
[421]
[422]
[423]
[424]
[425]
[426]
[427]
[428]
[429]
[430]
[431]
[432]
[433]
[434]
[435]
[436]
[437]
[438]
[439]
[440]
[441]
[442]
[443]
[444]
[445]
[446]
[{"$f":"+A451+1","v":447}]
[{"$f":"+A452+1","v":448}]
[{"$f":"+A451+1","v":447}]

{"sheet":"Proposed Pump Stations","index":9,"n_rows":452,"n_cols":19,"rows_kept":452,"cut":false,"hidden":false,"merged":[[0,1,0,14],[1,11,1,12],[1,13,3,13],[1,14,3,14],[0,0,3,0],[1,1,3,1],[1,2,3,2],[2,3,3,3],[1,3,1,6],[2,4,3,4],[2,5,3,5],[2,6,3,6],[1,8,2,8],[1,9,2,9],[2,7,3,7],[1,10,3,10]]}
[null,"Pump Stations - Proposed Projects"]
[null,"Proposed Project Title","Pump Station Name","Type",null,null,null,"Type","Capacity","Total Dynamic Head","Year Planned","If Known",null,"Plans & Specs Approved?","Funding In Place?"]
[null,null,null,"Expansion","Rehab","Replace","Abandon","e.g. submersible, centrifugal, etc.)",null,null,null,"Manufacturer's Predicted Life","Estimated Project Cost "]
[null,null,null,null,null,null,null,null,"gpm","Feet",null,"Years","$",null,null,null,null,null,"Yes"]
["Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9","Column10","Column11","Column12","Column13","Column14","Column15",null,null,null,"No"]
[1]
[{"$f":"+A6+1","v":2}]
[{"$f":"+A7+1","v":3}]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[{"$f":"+A71+1","v":67}]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]
[101]
[102]
[103]
[104]
[105]
[106]
[107]
[108]
[109]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122]
[123]
[124]
[125]
[126]
[127]
[128]
[129]
[130]
[{"$f":"+A135+1","v":131}]
[132]
[133]
[134]
[135]
[136]
[137]
[138]
[139]
[140]
[141]
[142]
[143]
[144]
[145]
[146]
[147]
[148]
[149]
[150]
[151]
[152]
[153]
[154]
[155]
[156]
[157]
[158]
[159]
[160]
[161]
[162]
[163]
[164]
[165]
[166]
[167]
[168]
[169]
[170]
[171]
[172]
[173]
[174]
[175]
[176]
[177]
[178]
[179]
[180]
[181]
[182]
[183]
[184]
[185]
[186]
[187]
[188]
[189]
[190]
[191]
[192]
[193]
[194]
[{"$f":"+A199+1","v":195}]
[196]
[197]
[198]
[199]
[200]
[201]
[202]
[203]
[204]
[205]
[206]
[207]
[208]
[209]
[210]
[211]
[212]
[213]
[214]
[215]
[216]
[217]
[218]
[219]
[220]
[221]
[222]
[223]
[224]
[225]
[226]
[227]
[228]
[229]
[230]
[231]
[232]
[233]
[234]
[235]
[236]
[237]
[238]
[239]
[240]
[241]
[242]
[243]
[244]
[245]
[246]
[247]
[248]
[249]
[250]
[251]
[252]
[253]
[254]
[255]
[256]
[257]
[258]
[{"$f":"+A263+1","v":259}]
[260]
[261]
[262]
[263]
[264]
[265]
[266]
[267]
[268]
[269]
[270]
[271]
[272]
[273]
[274]
[275]
[276]
[277]
[278]
[279]
[280]
[281]
[282]
[283]
[284]
[285]
[286]
[287]
[288]
[289]
[290]
[291]
[292]
[293]
[294]
[295]
[296]
[297]
[298]
[299]
[300]
[301]
[302]
[303]
[304]
[305]
[306]
[307]
[308]
[309]
[310]
[311]
[312]
[313]
[314]
[315]
[316]
[317]
[318]
[319]
[320]
[321]
[322]
[{"$f":"+A327+1","v":323}]
[324]
[325]
[326]
[327]
[328]
[329]
[330]
[331]
[332]
[333]
[334]
[335]
[336]
[337]
[338]
[339]
[340]
[341]
[342]
[343]
[344]
[345]
[346]
[347]
[348]
[349]
[350]
[351]
[352]
[353]
[354]
[355]
[356]
[357]
[358]
[359]
[360]
[361]
[362]
[363]
[364]
[365]
[366]
[367]
[368]
[369]
[370]
[371]
[372]
[373]
[374]
[375]
[376]
[377]
[378]
[379]
[380]
[381]
[382]
[383]
[384]
[385]
[386]
[{"$f":"+A391+1","v":387}]
[388]
[389]
[390]
[391]
[392]
[393]
[394]
[395]
[396]
[397]
[398]
[399]
[400]
[401]
[402]
[403]
[404]
[405]
[406]
[407]
[408]
[409]
[410]
[411]
[412]
[413]
[414]
[415]
[416]
[417]
[418]
[419]
[420]
[421]
[422]
[423]
[424]
[425]
[426]
[427]
[428]
[429]
[430]
[431]
[432]
[433]
[434]
[435]
[436]
[437]
[438]
[439]
[440]
[441]
[442]
[443]
[444]
[445]
[446]
[447]

{"sheet":"Treatment Unit","index":10,"n_rows":453,"n_cols":19,"rows_kept":453,"cut":false,"hidden":false,"merged":[[2,13,3,13],[1,11,1,14],[2,14,3,14],[0,0,3,0],[1,1,3,1],[1,5,1,7],[1,8,1,10],[2,2,3,2],[2,5,3,5],[2,6,3,6],[2,7,3,7],[2,8,3,8],[2,9,3,9],[0,1,0,14],[2,10,3,10],[2,11,3,11],[2,12,3,12],[1,3,3,3],[1,4,3,4]]}
[null,"Treatment Units (Preliminary, Secondary, Disinfection, Advanced, Biosolids, Handling) - Existing"]
[null,"Treatement Units",null,"Numberof Units","Year Installed","Assessment Ratings",null,null,"Failure Ratings",null,null,"Renewal and Maintenance Strategy"]
[null,null,"Unit Process",null,null,"Condition","Performance","Reliability","Consequence","Probability","Redundancy","Renewal Strategy","Maintenance Strategy","R&M Date","Estimated Cost of R&M Option $"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
["Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9","Column10","Column11","Column12","Column13","Column14","Column15",null,null,null,4]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[{"$f":"+A6+1","v":2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[{"$f":"+A7+1","v":3},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[{"$f":"+A8+1","v":4}]
[5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[14]
[15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[20]
[21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[{"$f":"+A72+1","v":68}]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]
[101]
[102]
[103]
[104]
[105]
[106]
[107]
[108]
[109]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122]
[123]
[124]
[125]
[126]
[127]
[128]
[129]
[130]
[131]
[{"$f":"+A136+1","v":132}]
[133]
[134]
[135]
[136]
[137]
[138]
[139]
[140]
[141]
[142]
[143]
[144]
[145]
[146]
[147]
[148]
[149]
[150]
[151]
[152]
[153]
[154]
[155]
[156]
[157]
[158]
[159]
[160]
[161]
[162]
[163]
[164]
[165]
[166]
[167]
[168]
[169]
[170]
[171]
[172]
[173]
[174]
[175]
[176]
[177]
[178]
[179]
[180]
[181]
[182]
[183]
[184]
[185]
[186]
[187]
[188]
[189]
[190]
[191]
[192]
[193]
[194]
[195]
[{"$f":"+A200+1","v":196}]
[197]
[198]
[199]
[200]
[201]
[202]
[203]
[204]
[205]
[206]
[207]
[208]
[209]
[210]
[211]
[212]
[213]
[214]
[215]
[216]
[217]
[218]
[219]
[220]
[221]
[222]
[223]
[224]
[225]
[226]
[227]
[228]
[229]
[230]
[231]
[232]
[233]
[234]
[235]
[236]
[237]
[238]
[239]
[240]
[241]
[242]
[243]
[244]
[245]
[246]
[247]
[248]
[249]
[250]
[251]
[252]
[253]
[254]
[255]
[256]
[257]
[258]
[259]
[{"$f":"+A264+1","v":260}]
[261]
[262]
[263]
[264]
[265]
[266]
[267]
[268]
[269]
[270]
[271]
[272]
[273]
[274]
[275]
[276]
[277]
[278]
[279]
[280]
[281]
[282]
[283]
[284]
[285]
[286]
[287]
[288]
[289]
[290]
[291]
[292]
[293]
[294]
[295]
[296]
[297]
[298]
[299]
[300]
[301]
[302]
[303]
[304]
[305]
[306]
[307]
[308]
[309]
[310]
[311]
[312]
[313]
[314]
[315]
[316]
[317]
[318]
[319]
[320]
[321]
[322]
[323]
[{"$f":"+A328+1","v":324}]
[325]
[326]
[327]
[328]
[329]
[330]
[331]
[332]
[333]
[334]
[335]
[336]
[337]
[338]
[339]
[340]
[341]
[342]
[343]
[344]
[345]
[346]
[347]
[348]
[349]
[350]
[351]
[352]
[353]
[354]
[355]
[356]
[357]
[358]
[359]
[360]
[361]
[362]
[363]
[364]
[365]
[366]
[367]
[368]
[369]
[370]
[371]
[372]
[373]
[374]
[375]
[376]
[377]
[378]
[379]
[380]
[381]
[382]
[383]
[384]
[385]
[386]
[387]
[{"$f":"+A392+1","v":388}]
[389]
[390]
[391]
[392]
[393]
[394]
[395]
[396]
[397]
[398]
[399]
[400]
[401]
[402]
[403]
[404]
[405]
[406]
[407]
[408]
[409]
[410]
[411]
[412]
[413]
[414]
[415]
[416]
[417]
[418]
[419]
[420]
[421]
[422]
[423]
[424]
[425]
[426]
[427]
[428]
[429]
[430]
[431]
[432]
[433]
[434]
[435]
[436]
[437]
[438]
[439]
[440]
[{"$f":"+A445+1","v":441}]
[442]
[443]
[444]
[445]
[446]
[447]
[448]

{"sheet":"Proposed Treatment Unit","index":11,"n_rows":453,"n_cols":13,"rows_kept":453,"cut":false,"hidden":false,"merged":[[1,7,3,7],[1,8,3,8],[0,0,3,0],[1,5,1,6],[1,4,3,4],[1,3,3,3],[1,1,3,1],[1,2,3,2],[0,1,0,8]]}
[null,"Treatment Units - Proposed Projects"]
[null,"Proposed Projects","Treatment Unit","Number of Units","Year Planned","If Known",null,"Plans & Specs Approved?","Funding In Place?"]
[null,null,null,null,null,"Manufacturer's Predicted Life","Estimated Project Cost"]
[null,null,null,null,null,"Years","$",null,null,null,null,null,"Yes"]
["Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9",null,null,null,"No"]
[1]
[{"$f":"+A6+1","v":2}]
[{"$f":"+A7+1","v":3}]
[{"$f":"+A8+1","v":4}]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[{"$f":"+A72+1","v":68}]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]
[101]
[102]
[103]
[104]
[105]
[106]
[107]
[108]
[109]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122]
[123]
[124]
[125]
[126]
[127]
[128]
[129]
[130]
[131]
[{"$f":"+A136+1","v":132}]
[133]
[134]
[135]
[136]
[137]
[138]
[139]
[140]
[141]
[142]
[143]
[144]
[145]
[146]
[147]
[148]
[149]
[150]
[151]
[152]
[153]
[154]
[155]
[156]
[157]
[158]
[159]
[160]
[161]
[162]
[163]
[164]
[165]
[166]
[167]
[168]
[169]
[170]
[171]
[172]
[173]
[174]
[175]
[176]
[177]
[178]
[179]
[180]
[181]
[182]
[183]
[184]
[185]
[186]
[187]
[188]
[189]
[190]
[191]
[192]
[193]
[194]
[195]
[{"$f":"+A200+1","v":196}]
[197]
[198]
[199]
[200]
[201]
[202]
[203]
[204]
[205]
[206]
[207]
[208]
[209]
[210]
[211]
[212]
[213]
[214]
[215]
[216]
[217]
[218]
[219]
[220]
[221]
[222]
[223]
[224]
[225]
[226]
[227]
[228]
[229]
[230]
[231]
[232]
[233]
[234]
[235]
[236]
[237]
[238]
[239]
[240]
[241]
[242]
[243]
[244]
[245]
[246]
[247]
[248]
[249]
[250]
[251]
[252]
[253]
[254]
[255]
[256]
[257]
[258]
[259]
[{"$f":"+A264+1","v":260}]
[261]
[262]
[263]
[264]
[265]
[266]
[267]
[268]
[269]
[270]
[271]
[272]
[273]
[274]
[275]
[276]
[277]
[278]
[279]
[280]
[281]
[282]
[283]
[284]
[285]
[286]
[287]
[288]
[289]
[290]
[291]
[292]
[293]
[294]
[295]
[296]
[297]
[298]
[299]
[300]
[301]
[302]
[303]
[304]
[305]
[306]
[307]
[308]
[309]
[310]
[311]
[312]
[313]
[314]
[315]
[316]
[317]
[318]
[319]
[320]
[321]
[322]
[323]
[{"$f":"+A328+1","v":324}]
[325]
[326]
[327]
[328]
[329]
[330]
[331]
[332]
[333]
[334]
[335]
[336]
[337]
[338]
[339]
[340]
[341]
[342]
[343]
[344]
[345]
[346]
[347]
[348]
[349]
[350]
[351]
[352]
[353]
[354]
[355]
[356]
[357]
[358]
[359]
[360]
[361]
[362]
[363]
[364]
[365]
[366]
[367]
[368]
[369]
[370]
[371]
[372]
[373]
[374]
[375]
[376]
[377]
[378]
[379]
[380]
[381]
[382]
[383]
[384]
[385]
[386]
[387]
[{"$f":"+A392+1","v":388}]
[389]
[390]
[391]
[392]
[393]
[394]
[395]
[396]
[397]
[398]
[399]
[400]
[401]
[402]
[403]
[404]
[405]
[406]
[407]
[408]
[409]
[410]
[411]
[412]
[413]
[414]
[415]
[416]
[417]
[418]
[419]
[420]
[421]
[422]
[423]
[424]
[425]
[426]
[427]
[428]
[429]
[430]
[431]
[432]
[433]
[434]
[435]
[436]
[437]
[438]
[439]
[440]
[441]
[442]
[443]
[444]
[445]
[446]
[447]
[448]

{"sheet":"Project Priorization","index":12,"n_rows":451,"n_cols":8,"rows_kept":451,"cut":false,"hidden":false,"merged":[[0,0,2,0],[0,1,0,7],[1,4,1,5],[1,7,2,7],[1,2,2,2],[1,3,2,3],[1,1,2,1]]}
[null,"Project Priorization"]
[null,"Project Title","Location","Brief Description","Schedule",null,"Cost Estimate","Source of Funding"]
[null,null,null,null,"Start Date","End Date","$"]
["Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8"]
[1]
[{"$f":"+A5+1","v":2}]
[{"$f":"+A6+1","v":3}]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[{"$f":"+A70+1","v":67}]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]
[101]
[102]
[103]
[104]
[105]
[106]
[107]
[108]
[109]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122]
[123]
[124]
[125]
[126]
[127]
[128]
[129]
[130]
[{"$f":"+A134+1","v":131}]
[132]
[133]
[134]
[135]
[136]
[137]
[138]
[139]
[140]
[141]
[142]
[143]
[144]
[145]
[146]
[147]
[148]
[149]
[150]
[151]
[152]
[153]
[154]
[155]
[156]
[157]
[158]
[159]
[160]
[161]
[162]
[163]
[164]
[165]
[166]
[167]
[168]
[169]
[170]
[171]
[172]
[173]
[174]
[175]
[176]
[177]
[178]
[179]
[180]
[181]
[182]
[183]
[184]
[185]
[186]
[187]
[188]
[189]
[190]
[191]
[192]
[193]
[194]
[{"$f":"+A198+1","v":195}]
[196]
[197]
[198]
[199]
[200]
[201]
[202]
[203]
[204]
[205]
[206]
[207]
[208]
[209]
[210]
[211]
[212]
[213]
[214]
[215]
[216]
[217]
[218]
[219]
[220]
[221]
[222]
[223]
[224]
[225]
[226]
[227]
[228]
[229]
[230]
[231]
[232]
[233]
[234]
[235]
[236]
[237]
[238]
[239]
[240]
[241]
[242]
[243]
[244]
[245]
[246]
[247]
[248]
[249]
[250]
[251]
[252]
[253]
[254]
[255]
[256]
[257]
[258]
[{"$f":"+A262+1","v":259}]
[260]
[261]
[262]
[263]
[264]
[265]
[266]
[267]
[268]
[269]
[270]
[271]
[272]
[273]
[274]
[275]
[276]
[277]
[278]
[279]
[280]
[281]
[282]
[283]
[284]
[285]
[286]
[287]
[288]
[289]
[290]
[291]
[292]
[293]
[294]
[295]
[296]
[297]
[298]
[299]
[300]
[301]
[302]
[303]
[304]
[305]
[306]
[307]
[308]
[309]
[310]
[311]
[312]
[313]
[314]
[315]
[316]
[317]
[318]
[319]
[320]
[321]
[322]
[{"$f":"+A326+1","v":323}]
[324]
[325]
[326]
[327]
[328]
[329]
[330]
[331]
[332]
[333]
[334]
[335]
[336]
[337]
[338]
[339]
[340]
[341]
[342]
[343]
[344]
[345]
[346]
[347]
[348]
[349]
[350]
[351]
[352]
[353]
[354]
[355]
[356]
[357]
[358]
[359]
[360]
[361]
[362]
[363]
[364]
[365]
[366]
[367]
[368]
[369]
[370]
[371]
[372]
[373]
[374]
[375]
[376]
[377]
[378]
[379]
[380]
[381]
[382]
[383]
[384]
[385]
[386]
[{"$f":"+A390+1","v":387}]
[388]
[389]
[390]
[391]
[392]
[393]
[394]
[395]
[396]
[397]
[398]
[399]
[400]
[401]
[402]
[403]
[404]
[405]
[406]
[407]
[408]
[409]
[410]
[411]
[412]
[413]
[414]
[415]
[416]
[417]
[418]
[419]
[420]
[421]
[422]
[423]
[424]
[425]
[426]
[427]
[428]
[429]
[430]
[431]
[432]
[433]
[434]
[435]
[436]
[437]
[438]
[439]
[440]
[441]
[442]
[443]
[444]
[445]
[446]
[447]

{"sheet":"Funding Plan","index":13,"n_rows":451,"n_cols":6,"rows_kept":451,"cut":false,"hidden":false,"merged":[[1,4,2,4],[1,1,2,1],[0,1,0,5],[1,0,2,0]]}
[null,"V.  Funding Plan"]
[null,"Project Title","Overall Project Budget","Available Funding Amount","Available Funding Source","Unfunded Amount"]
[null,null,"$","$",null,"$"]
["Column1","Column2","Column3","Column4","Column5","Column6"]
[1]
[{"$f":"+A5+1","v":2}]
[{"$f":"+A6+1","v":3}]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[{"$f":"+A70+1","v":67}]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]
[101]
[102]
[103]
[104]
[105]
[106]
[107]
[108]
[109]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122]
[123]
[124]
[125]
[126]
[127]
[128]
[129]
[130]
[{"$f":"+A134+1","v":131}]
[132]
[133]
[134]
[135]
[136]
[137]
[138]
[139]
[140]
[141]
[142]
[143]
[144]
[145]
[146]
[147]
[148]
[149]
[150]
[151]
[152]
[153]
[154]
[155]
[156]
[157]
[158]
[159]
[160]
[161]
[162]
[163]
[164]
[165]
[166]
[167]
[168]
[169]
[170]
[171]
[172]
[173]
[174]
[175]
[176]
[177]
[178]
[179]
[180]
[181]
[182]
[183]
[184]
[185]
[186]
[187]
[188]
[189]
[190]
[191]
[192]
[193]
[194]
[{"$f":"+A198+1","v":195}]
[196]
[197]
[198]
[199]
[200]
[201]
[202]
[203]
[204]
[205]
[206]
[207]
[208]
[209]
[210]
[211]
[212]
[213]
[214]
[215]
[216]
[217]
[218]
[219]
[220]
[221]
[222]
[223]
[224]
[225]
[226]
[227]
[228]
[229]
[230]
[231]
[232]
[233]
[234]
[235]
[236]
[237]
[238]
[239]
[240]
[241]
[242]
[243]
[244]
[245]
[246]
[247]
[248]
[249]
[250]
[251]
[252]
[253]
[254]
[255]
[256]
[257]
[258]
[{"$f":"+A262+1","v":259}]
[260]
[261]
[262]
[263]
[264]
[265]
[266]
[267]
[268]
[269]
[270]
[271]
[272]
[273]
[274]
[275]
[276]
[277]
[278]
[279]
[280]
[281]
[282]
[283]
[284]
[285]
[286]
[287]
[288]
[289]
[290]
[291]
[292]
[293]
[294]
[295]
[296]
[297]
[298]
[299]
[300]
[301]
[302]
[303]
[304]
[305]
[306]
[307]
[308]
[309]
[310]
[311]
[312]
[313]
[314]
[315]
[316]
[317]
[318]
[319]
[320]
[321]
[322]
[{"$f":"+A326+1","v":323}]
[324]
[325]
[326]
[327]
[328]
[329]
[330]
[331]
[332]
[333]
[334]
[335]
[336]
[337]
[338]
[339]
[340]
[341]
[342]
[343]
[344]
[345]
[346]
[347]
[348]
[349]
[350]
[351]
[352]
[353]
[354]
[355]
[356]
[357]
[358]
[359]
[360]
[361]
[362]
[363]
[364]
[365]
[366]
[367]
[368]
[369]
[370]
[371]
[372]
[373]
[374]
[375]
[376]
[377]
[378]
[379]
[380]
[381]
[382]
[383]
[384]
[385]
[386]
[{"$f":"+A390+1","v":387}]
[388]
[389]
[390]
[391]
[392]
[393]
[394]
[395]
[396]
[397]
[398]
[399]
[400]
[401]
[402]
[403]
[404]
[405]
[406]
[407]
[408]
[409]
[410]
[411]
[412]
[413]
[414]
[415]
[416]
[417]
[418]
[419]
[420]
[421]
[422]
[423]
[424]
[425]
[426]
[427]
[428]
[429]
[430]
[431]
[432]
[433]
[434]
[435]
[436]
[437]
[438]
[439]
[440]
[441]
[442]
[443]
[444]
[445]
[446]
[447]

{"sheet":"Certification","index":14,"n_rows":35,"n_cols":4,"rows_kept":35,"cut":false,"hidden":false,"merged":[[9,1,9,4],[19,1,19,4],[18,1,18,4],[26,1,26,3],[0,1,0,4],[1,1,1,4],[4,2,4,4],[3,2,3,4],[2,2,2,4],[17,1,17,3],[6,2,6,4],[7,1,7,4],[8,1,8,4],[10,1,10,4],[5,2,5,4],[12,3,12,5],[14,3,14,5],[21,3,21,5],[23,3,23,5],[35,1,35,3],[27,1,27,3],[28,1,28,3],[29,1,29,3],[30,1,30,3],[31,1,31,3],[32,1,32,3],[33,1,33,3],[34,1,34,3]]}
[null,"VI. COPIES OF SUPPORTING DOCUMENTATION"]
[null,"All regional planning agencies must provide copies of the supporting documentation listed below.  Copies should be attached to this form."]
[null,"1.","Regional planning agency organization chart (including names of members)"]
[null,"2.","Sewer use ordinance"]
[null,"3.","Current user rate schedule"]
[null,"4.","Wastewater system maps- (a) One (1) up-to-date map, suitable for photocopying, should indicate the planning area boundary, service area boundary, watershed boundaries, county boundaries, adjacent populated places, cities and/or towns, surface waterbodies, drinking water supply areas; (b) Up-to-date map(s), suitable for photocopying, including locations of wastewater treatment facilities (including package treatment plant(s)), discharge location(s), collection lines (gravity, force main, interceptors), and pump stations. "]
[null,"5.","A list of wastewater systems studies since the last planning update (e.g., Infiltration& inflow reports, CSO reports, sewer system evaluation studies, on-site/cluster system reports, other relevant reports.)"]
[null,"VII. CERTIFICATION.   Signature is required to guarantee the validity of the data."]
[null,"This section must be certified by an elected official (e.g. Mayor, County Judge Executive)  AND a designated official representing the regional planning agency (e.g. Kentucky licensed professional engineer employed by or under contract with the regional planning agency, Public Works Director, General Manager, Superintendent)"]
[null,"Local Elected Official"]
[null,"I certify the information entered in this form is accurate to the best of my knowledge."]
[]
[null,"Name:"]
[]
[null,"Title:"]
[]
[null,"Signature:",null,"Date:"]
[]
[null,"Designated Official"]
[null,"I certify the information entered in this form is accurate to the best of my knowledge."]
[]
[null,"Name:"]
[]
[null,"Title:"]
[]
[null,"Signature:",null,"Date:"]
[]
[null,"SEND COMPLETED FORMS TO:"]
[]
[null,"Division of Water"]
[null,"Wastewater Planning Section"]
[null,"200 Fair Oaks Lane"]
[null,"Frankfort, Kentucky 40601"]
[]
[null,"For additional information, call (502) 564-3410."]

{"sheet":"Sheet4","index":15,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}