{"text_format":"3","workbook":"xlsx","n_sheets":12,"sheets":["Table 5-1","Table 5-2","Table 5-3","Table 5-5","Table 5-6","Table 5-7","Table 5-8","Table 5-9","Table 5-10","Table 5-11","Table 5-12","Table 5-13"],"not_rendered":{"macros":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Table 5-1","index":0,"n_rows":28,"n_cols":5,"rows_kept":28,"merged":[[0,0,0,4],[1,0,1,1],[1,2,1,4],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2]]}
["Oklahoma Comprehensive Water Plan - Public Water Supply Planning Guide\nTable 5-1: Water System Management To-Do List"]
["System Name"]
[null,"Task",null,"Person Responsible","Target Completion Date"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]

{"sheet":"Table 5-2","index":1,"n_rows":87,"n_cols":8,"rows_kept":87,"merged":[[0,0,0,15],[1,0,1,2],[1,3,1,15],[2,1,2,15],[3,0,10,0],[3,2,3,3],[3,4,3,15],[4,2,4,3],[4,4,4,15],[5,2,5,3],[5,4,5,15],[6,2,6,3],[6,4,6,15],[7,2,7,3],[7,4,7,15],[8,2,8,3],[8,4,8,15],[9,2,9,3],[9,4,9,15],[10,1,10,15],[11,1,11,15],[12,0,15,0],[12,1,12,15],[13,1,13,15],[14,1,14,15],[15,1,15,15],[16,1,16,15],[17,0,18,0],[17,1,17,6],[17,7,17,15],[18,1,18,6],[18,7,18,15],[19,1,19,15],[20,0,25,0],[20,2,20,3],[20,4,20,15],[21,2,21,3],[21,8,21,15],[22,2,22,3],[22,8,22,15],[23,2,23,3],[23,8,23,15],[24,2,24,15],[25,1,25,15],[26,1,26,15],[27,0,27,15],[28,1,28,15],[29,0,33,0],[29,2,29,5],[29,7,29,15],[30,2,30,5],[30,7,30,15],[31,2,31,5],[31,7,31,15],[32,2,32,5],[32,7,32,15],[33,1,33,15],[34,1,34,15],[35,0,40,0],[35,2,35,4],[35,5,35,15],[36,2,36,4],[36,5,36,15],[37,2,37,4],[37,5,37,15],[38,2,38,4],[38,5,38,15],[39,2,39,4],[39,5,39,15],[40,1,40,15],[41,1,41,15],[42,0,44,0],[42,2,42,3],[42,4,43,15],[43,2,43,3],[44,1,44,15],[45,1,45,15],[46,1,46,15],[47,1,47,15],[48,0,54,0],[48,2,48,5],[48,6,53,15],[49,2,49,5],[50,2,50,5],[51,2,51,5],[52,2,52,5],[53,2,53,5],[54,1,54,15],[55,0,55,15],[56,1,56,15],[57,0,59,0],[57,1,57,15],[58,1,58,6],[58,7,58,15],[59,1,59,6],[59,7,59,15],[60,1,60,15],[61,0,63,0],[61,1,61,15],[62,1,62,6],[62,7,62,15],[63,1,63,6],[63,7,63,15],[64,1,64,15],[65,0,67,0],[65,1,65,15],[66,1,66,6],[66,7,66,15],[67,1,67,6],[67,7,67,15],[68,0,68,15],[69,1,69,15],[70,2,70,5],[70,7,70,14],[70,15,77,15],[71,2,71,5],[71,7,71,14],[72,2,72,5],[72,7,72,14],[73,2,73,5],[73,7,73,14],[74,2,74,5],[74,7,74,14],[75,2,75,5],[75,7,75,14],[76,2,76,5],[76,7,76,14],[77,2,77,6],[77,7,77,14],[78,1,78,15],[79,1,79,15],[80,1,80,6],[80,7,80,15],[81,1,81,6],[81,7,81,15],[82,1,82,15],[83,1,83,15],[84,1,84,6],[84,7,84,15],[85,1,85,6],[85,7,85,15],[86,1,86,15],[87,1,87,15]]}
["Oklahoma Comprehensive Water Plan - Public Water Supply Planning Guide\nTable 5-2: (page 1 of 4) System Management"]
["System Name"]
[1,"Select type of system ownership (check all that apply)."]
[null,null,"Type of Ownership",null,"Name"]
[null,null,"Water association"]
[null,null,"Local government"]
[null,null,"Corporation"]
[null,null,"Single private owner"]
[null,null,"Partnership"]
[null,null,"Other, describe below."]
[]
[2,"List name(s) of owner(s), below. (Use additional sheet if necessary.)"]
[]
[]
[]
[]
[3,"If there are written system rules, attach or identify physical and/or electronic location of information below. \n                                                                                                              Is documentation attached?"]
[null,"Physical Location",{"$nulls":5},"Electronic Location"]
[]
[4,"Identify and check below who makes major decisions for the system (such as when to make capital improvements, how to finance improvements, when to expand/consolidate, etc.)."]
[null,null,"SINGLE PARTY (Identify):"]
[null,null,"BOARD\n   Number of members:  ",null,null,"Length of service (years):",null,"Selected by:"]
[null,null,"SYSTEM USER GROUP\n   Number of members: ",null,null,"Length of service (years):",null,"Selected by:"]
[null,null,"COMMISSION\n   Number of members:  ",null,null,"Length of service (years):",null,"Selected by:"]
[null,null,"State below any other decision-making individuals or parties not listed above and describe association with organization."]
[]
[]
["Table 5-2: (page 2 of 4) System Management"]
[5,"How often do those responsible for decision making meet?"]
[null,null," Monthly"]
[null,null," Annually"]
[null,null," When necessary, describe below."]
[null,null," Other, describe below."]
[]
[6," If all system users are notified about these meetings, identify how users are notified (check all that apply)."]
[null,null,"Notice on water bill."]
[null,null,"Telephone distribution list"]
[null,null,"Email distribution list"]
[null,null,"Notice in local paper"]
[null,null,"Other, describe below."]
[]
[7,"If water bills are mailed, select and check frequency below."]
[null,null,"Monthly"]
[null,null,"Other, describe below."]
[null," "]
[8,"If water bills are not mailed, describe below the notification process and frequency."]
[null," "]
[9,"What is the plan for financing future system improvements (check all that apply)?"]
[null,null,"Reserve account(s)"]
[null,null,"Loans"]
[null,null,"Grants"]
[null,null,"System user rates or one time fees"]
[null,null,"Unknown at this time"]
[null,null,"Other, describe below."]
[]
["Table 5-2: (page 3 of 4) System Management"]
[10,"If the system has paid employees and there are policies in place regarding personnel management (salaries, benefits, hiring/firing, supervision, raises, etc.), describe the process and attach documentation or identify physical and/or electronic location of information below.                                                                                                               Is documentation attached?"]
[]
[null,"Physical Location",{"$nulls":5},"Electronic Location"]
[]
[11,"If the system has an operator, and there a plan in place in the event of operator loss, describe the process and attach or identify physical and/or electronic location of information below.                           Is documentation attached?"]
[]
[null,"Physical Location",{"$nulls":5},"Electronic Location"]
[]
[12,"If there is a process to record and respond to customer complaints, describe the process and attach or identify physical and/or electronic location of information below.                                           Is documentation attached?"]
[]
[null,"Physical Location",{"$nulls":5},"Electronic Location"]
[]
["Table 5-2: (page 4 of 4) System Management"]
[13,"If the system has insurance policies, check all that apply and list coverage amounts: "]
[null,null,"Policy Coverage",{"$nulls":4},"Coverage Amount"]
[null,null,"Commercial General Liability"]
[null,null,"Automobile Liability"]
[null,null,"Garage Liability"]
[null,null,"Excess/Umbrella Liability"]
[null,null,"Workers Compensation and Employers Liability"]
[null,null,"Employment Practices Liability"]
[null,null,"Other, describe below"]
[]
[null,"Attach documentation or identify physical and/or electronic location \nof information below.                                                                                              Is documentation attached?"]
[null,"Physical Location",{"$nulls":5},"Electronic Location"]
[]
[14,"If the system has written safety procedures, describe the process and attach or identify physical and/or electronic location of information below.                                                                                                                     Is documentation attached?"]
[]
[null,"Physical Location",{"$nulls":5},"Electronic Location"]
[]
[15,"Identify and list below the person/party responsible for conducting financial transactions (maintaining records, customer billings, making debt payments, etc.) "]

{"sheet":"Table 5-3","index":2,"n_rows":7,"n_cols":3,"rows_kept":7,"merged":[[0,0,0,13],[1,0,1,2],[1,3,1,13],[2,0,2,13],[3,2,3,13],[4,2,4,13],[5,2,5,13],[6,0,6,13],[7,1,7,13]]}
["Oklahoma Comprehensive Water Plan - Public Water Supply Planning Guide\nTable 5-3: System Management Checklist"]
["System Name"]
["Check each completed task."]
[null,null,"Completed system management table."]
[null,null,"Identified any potential changes to current practices on To-Do list."]
[null,null,"Attached documentation used to develop tables or have identied physical and/or electronic location of information."]
["State below any Information needed to finalize incomplete task(s)."]

{"sheet":"Table 5-5","index":3,"n_rows":33,"n_cols":12,"rows_kept":33,"merged":[[0,0,0,15],[1,0,1,2],[1,3,1,15],[2,0,2,15],[3,0,6,0],[3,1,3,15],[4,8,4,15],[5,1,5,6],[5,7,5,15],[6,1,6,6],[6,7,6,15],[7,0,7,15],[8,0,17,0],[8,1,9,2],[8,3,9,4],[8,5,8,15],[9,5,9,6],[9,7,9,8],[9,9,9,10],[9,11,9,15],[10,1,10,2],[10,3,10,4],[10,5,10,6],[10,7,10,8],[10,9,10,10],[10,11,10,15],[11,1,11,2],[11,3,11,4],[11,5,11,6],[11,7,11,8],[11,9,11,10],[11,11,11,15],[12,1,12,2],[12,3,12,4],[12,5,12,6],[12,7,12,8],[12,9,12,10],[12,11,12,15],[13,1,14,2],[13,3,14,4],[13,5,13,15],[14,5,14,6],[14,7,14,8],[14,9,14,10],[14,11,14,15],[15,1,15,2],[15,3,15,4],[15,5,15,6],[15,7,15,8],[15,9,15,10],[15,11,15,15],[16,1,16,2],[16,3,16,4],[16,5,16,6],[16,7,16,8],[16,9,16,10],[16,11,16,15],[17,1,17,2],[17,3,17,4],[17,5,17,6],[17,7,17,8],[17,9,17,10],[17,11,17,15],[18,0,18,15],[19,0,23,0],[19,1,19,2],[19,3,19,4],[19,5,19,6],[19,8,19,9],[19,11,19,15],[20,1,20,2],[20,3,20,4],[20,5,20,6],[20,8,20,9],[20,11,20,15],[21,1,21,2],[21,3,21,4],[21,5,21,6],[21,8,21,9],[21,11,21,15],[22,1,22,2],[22,3,22,4],[22,5,22,6],[22,8,22,9],[22,11,22,15],[23,1,23,3],[23,6,23,15],[24,0,24,15],[25,0,27,0],[25,2,25,5],[25,6,25,15],[26,2,26,4],[26,5,26,15],[27,1,27,15],[28,0,28,15],[29,0,31,0],[29,1,29,7],[29,8,29,15],[30,1,30,7],[30,8,31,15],[31,1,31,4],[31,5,31,7],[32,0,32,15]]}
["Oklahoma Comprehensive Water Plan - Public Water Supply Planning Guide\nTable 5-5: Rate Schedule Information"]
["System Name"]
["Rate Schedule - Describe below."]
[]
[null,"Attach rate documentation or identify physical and/or electronic location below.           ",{"$nulls":6},"Is documentation is attached? "]
[null,"Physical Location",{"$nulls":5},"Electronic Location"]
[]
["Declining and Inclining Blocks - Identify any blocks the system has in place and describe the usage per block by customer type."]
[null,"Declining Block Structure ",null,"Rate/Unit ",null,"Usage per Block by Customer Type"]
[{"$nulls":5},"Type & Usage ",null,"Type & Usage ",null,"Type & Usage ",null,"Type & Usage "]
[]
[]
[]
[null,"Inclining Block Structure ",null,"Rate/Unit ",null,"Usage per Block by Customer Type"]
[{"$nulls":5},"Type & Usage ",null,"Type & Usage ",null,"Type & Usage ",null,"Type & Usage "]
[]
[]
[]
["Billable Gallons by Customer Type                                                 "]
[null,"Customer Type ",null,"No. of Customers",null,"Billable Gallons",null,null,"Customer Type",null,"Customers","Billable Gallons"]
[]
[]
[]
[null,"Billing period:             Monthly",null,null,"Other: (describe)"]
["Water Rate Changes - Describe the System's policy for changing water rates.  Select one of the options below."]
[null,null,"A vote is requried to change rates.          By whom?"]
[null,null,"A vote is not requried to change rates.",null,null,"Describe below the process for changing rates"]
[]
["Billing Process for Metered and Non-Metered customers."]
[null,"Metered - Describe the metering process.",{"$nulls":6},"Non-Metered - Describe water usage determination process."]
[]
[null,"What percentage1 of customers is metered?                         %"]
["1Enter percentage as decimal equivalent: (e.g., .002 for .20% or .02 for 2.00%)"]

{"sheet":"Table 5-6","index":4,"n_rows":13,"n_cols":13,"rows_kept":13,"merged":[[0,0,0,12],[1,1,1,12],[2,0,2,12],[3,0,4,1],[3,2,3,5],[3,6,3,7],[3,8,4,9],[3,10,4,11],[3,12,4,12],[4,2,4,3],[4,4,4,5],[5,0,5,1],[5,2,5,3],[5,4,5,5],[5,8,5,9],[5,10,5,11],[6,0,6,1],[6,2,6,3],[6,4,6,5],[6,8,6,9],[6,10,6,11],[7,0,7,1],[7,2,7,3],[7,4,7,5],[7,8,7,9],[7,10,7,11],[8,0,8,1],[8,2,8,3],[8,4,8,5],[8,8,8,9],[8,10,8,11],[9,0,9,1],[9,2,9,3],[9,4,9,5],[9,8,9,9],[9,10,9,11],[10,0,10,1],[10,2,10,3],[10,4,10,5],[10,8,10,9],[10,10,10,11],[11,0,11,1],[11,2,11,3],[11,4,11,5],[11,8,11,9],[11,10,11,11],[12,0,12,12],[13,0,13,12],[14,0,34,12]]}
["Oklahoma Comprehensive Water Plan - Public Water Supply Planning Guide\nTable 5-6: Existing System Debt"]
["System Name"]
["List below and provide information on the system's existing debt."]
["Debt Name and/or \nLending Institution",null,"Amount of Debt",{"$nulls":3},"Tiime for Repayment",null,"Interest Rate1",null,"Annual \nPayment",null,"Payment Interval"]
[null,null,"Original",null,"Remaining",null,"Original","Remaining"]
{"$rows_empty":7}
["1Enter percentage as decimal equivalent: (e.g., .002 for .20% or .02 for 2.00%)"]

{"sheet":"Table 5-7","index":5,"n_rows":14,"n_cols":6,"rows_kept":14,"merged":[[0,0,0,5],[1,0,1,1],[1,2,1,5],[2,0,2,2],[3,0,3,2],[4,0,4,2],[5,0,5,2],[6,0,6,2],[7,0,7,2],[8,0,8,2],[9,0,9,2],[10,0,10,2],[11,0,11,2],[12,0,12,2],[13,1,13,3]]}
["Oklahoma Comprehensive Water Plan - Public Water Supply Planning Guide\nTable 5-7: Funded System Improvement Projects"]
["System Name"]
["Project Name",null,null,"Project Description or Purpose","Cost Estimate","Funding Source"]
{"$rows_empty":10}
[null,"Funded Projects Total Estimated Cost",null,null,{"$f":"SUM(E4:E13)","v":{"v":0,"d":"$0.00"}}]

{"sheet":"Table 5-8","index":6,"n_rows":14,"n_cols":6,"rows_kept":14,"merged":[[0,0,0,5],[1,1,1,5],[2,0,2,1],[2,3,2,4],[3,0,3,1],[3,3,3,4],[4,0,4,1],[4,3,4,4],[5,0,5,1],[5,3,5,4],[6,0,6,1],[6,3,6,4],[7,0,7,1],[7,3,7,4],[8,0,8,1],[8,3,8,4],[9,0,9,1],[9,3,9,4],[10,0,10,1],[10,3,10,4],[11,0,11,1],[11,3,11,4],[12,0,12,1],[12,3,12,4],[13,0,13,2],[13,3,13,4]]}
["Oklahoma Comprehensive Water Plan - Public Water Supply Planning Guide\nTable 5-8: Unfunded System Improvement Projects"]
["System Name"]
["Project Name",null,"Project Description or Purpose","Cost Estimate",null,"Funding Source Suggestion"]
{"$rows_empty":10}
["Known Unfunded Projects Total Estimated Cost",null,null,{"$f":"SUM(D4:E13)","v":{"v":0,"d":"$0.00"}}]

{"sheet":"Table 5-9","index":7,"n_rows":14,"n_cols":7,"rows_kept":14,"merged":[[0,0,0,6],[1,1,1,6],[2,0,2,2],[2,4,2,5],[3,0,3,2],[3,4,3,5],[4,0,4,2],[4,4,4,5],[5,0,5,2],[5,4,5,5],[6,0,6,2],[6,4,6,5],[7,4,7,5],[8,4,8,5],[9,0,9,2],[9,4,9,5],[10,4,10,5],[11,4,11,5],[12,0,12,2],[12,4,12,5],[13,0,13,3],[13,4,13,5]]}
["Oklahoma Comprehensive Water Plan - Public Water Supply Planning Guide\nTable 5-9: Capital Improvement Projects Budget"]
["System Name"]
["Project Name",null,null,"Project Description or Purpose","Cost Estimate",null,"Year"]
{"$rows_empty":10}
["CIP Total Estimated Cost",{"$nulls":3},{"$f":"SUM(E4:F13)","v":{"v":0,"d":"$0.00"}}]

{"sheet":"Table 5-10","index":8,"n_rows":11,"n_cols":9,"rows_kept":11,"merged":[[0,0,0,8],[1,0,1,2],[1,3,1,8],[2,0,3,3],[4,1,4,3],[5,0,9,0],[5,2,5,3],[6,2,6,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,1,10,3]]}
["Oklahoma Comprehensive Water Plan - Public Water Supply Planning Guide\nTable 5-10: Operational Budget"]
["System Name"]
["Budget Item",{"$nulls":3},"Year","Year","Year","Year","Year"]
[]
["A","Operating revenues (including water rates, service impact fees, other)"]
["Expenses","B","Operating Expenses (including salaries and benefits, insurance, routine and preventative maintenance, others less power, chemicals and other variable expenses)"]
[null,"C","Operating expenses due to CIP"]
[null,"D","Other expenses (including emergency or unplanned repairs/projects, professional services, training, etc.)"]
[null,"E","Taxes (paid by the water system)"]
[null,"F","Debt payments"]
["G","Budget Total [ A – (B through F) ]"]

{"sheet":"Table 5-11","index":9,"n_rows":7,"n_cols":9,"rows_kept":7,"merged":[[0,0,0,8],[1,0,1,1],[1,2,1,8],[2,0,3,3],[4,1,4,3],[5,1,5,3],[6,1,6,3]]}
["Oklahoma Comprehensive Water Plan - Public Water Supply Planning Guide\nTable 5-11: Reserve/Savings Account Balances"]
["System Name"]
["Budget Item",{"$nulls":3},"Year","Year","Year","Year","Year"]
[]
["A","Operating Reserve Account"]
["B","Emergency Replacement Reserve Account"]
["C","Total Reserve/Savings Account Balances"]

{"sheet":"Table 5-12","index":10,"n_rows":10,"n_cols":10,"rows_kept":10,"merged":[[0,0,0,9],[1,0,1,2],[1,3,1,9],[2,0,3,4],[4,1,4,4],[5,0,8,0],[5,1,8,1],[5,2,5,4],[6,2,6,4],[7,2,7,4],[8,2,8,4],[9,1,9,4]]}
["Oklahoma Comprehensive Water Plan - Public Water Supply Planning Guide\nTable 5-12: Capital Improvements Budget"]
["System Name"]
["Budget Item",{"$nulls":4},"Year","Year","Year","Year","Year"]
[]
["A","Capital Improvement Project (CIP) Costs"]
["Financing Sources","B","1. Grants"]
[null,null,"2. Reserves"]
[null,null,"3. Loans/Bonds"]
[null,null,"4. User Charges "]
["C","CIP Total [A – (B1 through B4)]"]

{"sheet":"Table 5-13","index":11,"n_rows":8,"n_cols":3,"rows_kept":8,"merged":[[0,0,0,13],[1,0,1,2],[1,3,1,13],[2,0,2,13],[3,0,6,0],[3,2,3,13],[4,2,4,13],[5,2,5,13],[6,2,6,13],[7,0,7,13],[8,1,8,13]]}
["Oklahoma Comprehensive Water Plan - Public Water Supply Planning Guide\nTable 5-13: Operational Costs and Budgets Information Checklist"]
["System Name"]
["Check each completed task."]
[null,null,"Completed operational budget table."]
[null,null,"Completed capital improvements budget table."]
[null,null,"Attached documentation used to develop tables or have identified physical and/or electronic location of information"]
[null,null,"Used EPA's Setting Small Drinking Water System Rates for a Sustainable Future document in this process."]
["State below any Information needed to finalize incomplete task(s)"]