{"text_format":"1","workbook":"xlsx","n_sheets":22,"sheets":["AFFIDAVIT","F-1","F-2","F-3","F-4","F-5","F-6","F-7","F-8","S-1","S-2","S-3","S-4","S-5","W-1","W-2","W-3","W-4","W-5","W-6","RATEOFRETURN","ENTRY"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":23,"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":"1904"}

{"sheet":"AFFIDAVIT","index":0,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"STATE OF TENNESSEE"]
[]
[]
[]
[]
[null,"COUNTY OF ..................................."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"We the undersigned",null,null,null,null,null,null,"   "]
[null,"and",null,null,null,null,null,null,"  "]
[null,"of",null,null,null,null,null,null,"  "]
[null,"on our oath do severally say that the foregoing return has been prepared,"]
[null,"under our direction, from the original books, papers and records of said"]
[null,"utility; that we have carefully examined the same, and declare the same to be"]
[null,"a correct statement of the business and affairs of said utility for the period"]
[null,"covered by the return in respect to each and every matter and thing therein"]
[null,"set forth, to the best of our knowledge, information and belief."]
[]
[]
[]
[]
[null,null,null,null,null,"........................................................................................................",null,null," "]
[null,null,null,null,null,"(Chief Officer)"]
[]
[null,null,null,null,null,"........................................................................................................",null,null," "]
[null,null,null,null,null,"(Officer in charge of accounts)"]
[]
[]
[]
[null,"Subscribed and sworn to before me this......................................",null,null,null,"   "]
[null,"day of.............................................................., 20.......",null,null,null,"   "]
[null,"...................................................................................................",null,null,null,"  "]
[null,"Notary Public, .....................................County, ..........",null,null,null,"   "]
[null,"My commission will expire..................................................",null,null,null,"  "]
[null,"...............................................................................................",null,null,null,"   "]
[null,"(Seal)"]

{"sheet":"F-1","index":1,"n_rows":64,"n_cols":6,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"F-1"]
[]
[1,"TABLE OF CONTENTS",null,null,null,1]
[2,null,null,null,null,2]
[3,null,null,null,null,3]
[4,"AFFIDAVIT - First page of this Report",null,null,null,4]
[5,"FINANCIAL SECTION",null,"WATER SECTION",null,5]
[6,"Identification and ownership........................................................................................................","F-2","Water Utility Plant Accounts.............................................................","W-1",6]
[7,"Officers & Managers..................................................................................................","F-2","Analysis Of Accumulated Depreciation By Primary Account....................................................","W-2",7]
[8,"Income Statement.........................................................................","F-3","Water Operation & Maintenance Expense............................................................................","W-3",8]
[9,"Comparative Balance Sheet...................................................................","F-4","Water Customers......................................................................................................","W-3",9]
[10,"Net Utility Plant...............................................................................................","F-5","Pumping & Purchased Water Statistics..................................................................","W-4",10]
[11,"Accumulated Depreciation & Amortization of Utility Plant........................................................","F-5","Sales For Resale............................................................................................","W-4",11]
[12,"Capital Stock................................................................................................","F-6","Wells & Well Pumps..................................................................................","W-5",12]
[13,"Retained Earnings................................................................................................................................","F-6","Reservoirs................................................................................................","W-5",13]
[14,"Proprietary Capital.........................................................................................","F-6","High Service Pumping..................................................................................................","W-5",14]
[15,"Long-Term Debt............................................................................................................................","F-6","Source Of Supply.............................................................................................................","W-6",15]
[16,"Taxes Accrued...........................................................................................................","F-7","Water Treatment Facilities....................................................................................................","W-6",16]
[17,"Payments For Services Rendered By Other Than Employees....................","F-7","Other Water System Information.....................................................................................................","W-6",17]
[18,"Contributions In Aid Of Construction.................................................................","F-8",null,null,18]
[19,"Additions To Contributions In Aid Of Construction (Credits)................................","F-8",null,null,19]
[20,null,null,null,null,20]
[21,null,null,"SEWER SECTION",null,21]
[22,null,null,"Sewer Utility Plant Accounts.............................................................","S-1",22]
[23,null,null,"Analysis Of Accumulated Depreciation By Primary Account....................................................","S-2",23]
[24,null,null,"Sewer Operation & Maintenance Expense............................................................................","S-3",24]
[25,null,null,"Sewer Customers.............................................................................................","S-3",25]
[26,null,null,"Pumping Equipment...................................................................................","S-4",26]
[27,null,null,"Service Connections.......................................................................................................................","S-4",27]
[28,null,null,"Collecting Mains, Force Mains, & Manholes...............................................................................","S-4",28]
[29,null,null,"Treatment Plant........................................................................................","S-5",29]
[30,null,null,"Master Lift Station Pumps.........................................................................................","S-5",30]
[31,null,null,"Other Sewer System Information..............................................................................................","S-5",31]
[32,null,null,null,null,32]
[33,null,null,null,null,33]
[34,null,null,null,null,34]
[35,null,null,"SUPPLEMENTAL FINANCIAL DATA",null,35]
[36,null,null,"Rate Base....................................................................................................","SU-1",36]
[37,null,null,"Adjusted Net Operating Income............................................................................","SU-1",37]
[38,null,null,null,null,38]
[39,null,null,null,null,39]
[40,null,null,null,null,40]
[41,null,null,null,null,41]
[42,null,null,null,null,42]
[43,null,null,null,null,43]
[44,null,null,null,null,44]
[45,null,null,null,null,45]
[46,null,null,null,null,46]
[47,null,null,null,null,47]
[48,null,null,null,null,48]
[49,null,null,null,null,49]
[50,null,null,null,null,50]
[51,null,null,null,null,51]
[52,null,null,null,null,52]
[53,null,null,null,null,53]
[54,null,null,null,null,54]
[55,null,null,null,null,55]
[56,null,null,null,null,56]
[57,null,null,null,null,57]
[58,null,null,null,null,58]
[59,null,null,null,null,59]
[60,null,null,null,null,60]
[61,null,null,null,null,61]
[62,null,null,null,null,62]

{"sheet":"F-2","index":2,"n_rows":71,"n_cols":11,"rows_kept":71,"cut":false,"hidden":false,"merged":[]}
["F-2"]
[null,"Name of Respondent",null,null,null,"This Report is:",null,"Date of Report","Year of Report"]
[null,{"$f":"ENTRY!D2","v":"Your Company Name"},null,null,null,{"$f":"'F-3'!C6","v":"(1) _X_ An Original"},null,"(Mo, Da, Yr)"]
[null,"  ",null,null,null,{"$f":"'F-3'!C7","v":"(2) ___ A Resubmission"},null,{"$f":"ENTRY!D4","v":"Date report compiled"},{"$f":"ENTRY!D3","v":"Fiscal Year End Date"}]
[1,null,null,null,null,"IDENTIFICATION & OWNERSHIP",null,null,null,null,1]
[2,null,null,null,null,null,null,null,null,null,2]
[3,"Report of:",null,null,null,null,null,null,null,null,3]
[4,null,null,null,null,"(REPORT THE EXACT NAME OF UTILITY)",null,null,null,null,4]
[5,null,null,null,null,null,null,null,null,null,5]
[6,"Located at:",null,null,null,null,"Year Ended:",null,null,null,6]
[7,null,null,null,null,null,null,null,null,null,7]
[8,null,null,null,null,null,null,null,null,null,8]
[9,"Date Utility was Originally Organized:",null,null,null,null,null,null,null,null,9]
[10,null,null,null,null,null,null,null,null,null,10]
[11,null,null,null,null,null,null,null,null,null,11]
[12,null,null,null,null,null,null,null,null,null,12]
[13,"Location of Office Where Accounts and Records are Kept:",null,null,null,null,null,null,null,null,13]
[14,null,null,null,null,null,null,null,null,null,14]
[15,null,null,null,null,null,null,null,null,null,15]
[16,null,null,null,null,null,null,null,null,null,16]
[17,"Give the Name,Title,&Office Address of the Officer of the Utility to Whom Correspondence Should be Addressed Concerning this Report:",null,null,null,null,null,null,null,null,17]
[18,null,null,null,null,null,"Telephone:",null,null,null,18]
[19,null,null,null,null,null,null,null,null,null,19]
[20,null,null,null,null,null,null,null,null,null,20]
[21,null,null,null,null,null,null,null,null,null,21]
[22,null,null,null,null,"OFFICERS & MANAGERS",null,null,null,null,22]
[23,null,null,null,null,null,null,null,null,null,23]
[24,null,null,null,null,null,null,null,null,null,24]
[25,null,"NAME",null,null,"TITLE",null,"SALARY",null,null,25]
[26,null,null,null,null,null,null,null,null,null,26]
[27,null,null,null,null,null,null,null,null,null,27]
[28,null,null,null,null,null,null,null,null,null,28]
[29,null,null,null,null,null,null,null,null,null,29]
[30,null,null,null,null,null,null,null,null,null,30]
[31,null,null,null,null,null,null,null,null,null,31]
[32,null,null,null,null,null,null,null,null,null,32]
[33,null,null,null,null,null,null,null,null,null,33]
[34,null,null,null,null,null,null,null,null,null,34]
[35,null,null,null,null,null,null,null,null,null,35]
[36,null,null,null,null,"OWNERSHIP",null,null,null,null,36]
[37,"Report every corporation or individual owning or holding directly or indirectly 5 percent or more of the voting securities of",null,null,null,null,null,null,null,null,37]
[null,"the reporting utility."]
[38,null,null,null,null,null,null,null,null,null,38]
[39,null,null,null,null,null,null,null,null,null,39]
[40,null,null,null,null,null,"Percent","Salary","Meetings",null,40]
[41,null,null,null,null,null,"Ownership","Charged","Attended",null,41]
[42,null,"Name",null,null,"Address","In Utility","Utility","During Year",null,42]
[43,null,null,null,null,null,null,null,null,null,43]
[44,null,"(a)",null,null,"(b)","(c)","(d)","(e)",null,44]
[45,null,null,null,null,null,null,null,null,null,45]
[46,null,null,null,null,null,null,null,null,null,46]
[47,null,null,null,null,null,null,null,null,null,47]
[48,null,null,null,null,null,null,null,null,null,48]
[49,null,null,null,null,null,null,null,null,null,49]
[50,null,null,null,null,null,null,null,null,null,50]
[51,null,null,null,null,null,null,null,null,null,51]
[52,null,null,null,null,null,null,null,null,null,52]
[53,null,null,null,null,null,null,null,null,null,53]
[54,null,null,null,null,null,null,null,null,null,54]
[55,null,null,null,null,null,null,null,null,null,55]
[56,null,null,null,null,null,null,null,null,null,56]
[57,null,null,null,null,null,null,null,null,null,57]
[58,null,null,null,null,null,null,null,null,null,58]
[59,null,null,null,null,null,null,null,null,null,59]
[60,null,null,null,null,null,null,null,null,null,60]
[61,null,null,null,null,null,null,null,null,null,61]
[62,null,null,null,null,null,null,null,null,null,62]
[63,null,null,null,null,null,null,null,null,null,63]
[64,null,null,null,null,null,null,null,null,null,64]
[65,null,null,null,null,null,null,null,null,null,65]
[66,null,null,null,null,null,null,null,null,null,66]

{"sheet":"F-3","index":3,"n_rows":62,"n_cols":8,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,null,null,null,"F-3"]
[null,"Name of Respondent","This Report is:",null,null,"Date of Report","Year of Report"]
[null,{"$f":"ENTRY!D2","v":"Your Company Name"},{"$f":"'F-4'!D6","v":"(1) _X_ An Original"},null,null,"(Mo, Da, Yr)"]
[null,"  ",{"$f":"'F-4'!D7","v":"(2) ___ A Resubmission"},null,null,{"$f":"ENTRY!D4","v":"Date report compiled"},{"$f":"ENTRY!D3","v":"Fiscal Year End Date"}]
[1,"INCOME STATEMENT",null,null,null,null,null,1]
[2,null,null,null,null,null,null,2]
[3,null,"Ref",null,null,null,null,3]
[4,"Account Name","Page","Water","Sewer","Other","Total",4]
[5,"(a)","(b)","(c)","(d)","(e)","(f)",5]
[6,null,null,null,null,null,null,6]
[7,"Gross Revenue:",null,null,null,null,null,7]
[8,"     Residential",null,0,0,0,{"$f":"D15+E15+F15","v":0},8]
[9,"     Commercial",null,0,0,0,0,9]
[10,"     Industrial",null,0,0,0,0,10]
[11,"     Multi-Family",null,0,0,0,0,11]
[12,"     Other (Please Specify)",null,{"$f":"ENTRY!E123+ENTRY!E124","v":0},0,0,0,12]
[13,"     Other (Please Specify)",null,0,0,0,0,13]
[14,"     Other (Please Specify)",null,0,0,0,0,14]
[15,"     Other (Please Specify)",null,0,0,0,0,15]
[16,"          Total Gross Revenue",null,{"$f":"SUM(D15:D22)","v":0},{"$f":"SUM(E15:E22)","v":0},{"$f":"SUM(F15:F22)","v":0},{"$f":"SUM(G15:G22)","v":0},16]
[17,null,null,null,null,null,null,17]
[18,null,null,null,null,null,null,18]
[19,null,null,null,null,null,null,19]
[20,"Operation & Maint. Expense","W3/S3",{"$f":"'W-3'!G29","v":0},{"$f":"'S-3'!G30","v":0},0,{"$f":"D27+E27+F27","v":0},20]
[21,"Depreciation Expense","F-5",0,0,0,0,21]
[22,"Amortization Expense",null,0,0,0,0,22]
[23,"Other Expense (Please Specify)",null,0,0,0,0,23]
[24,"Other Expense (Please Specify)",null,0,0,0,0,24]
[25,"Taxes Other Than Income","F-7",0,0,0,0,25]
[26,"Income Taxes","F-7",0,0,0,0,26]
[27,"     Total Operating Expenses",null,{"$f":"SUM(D27:D33)","v":0},{"$f":"SUM(E27:E33)","v":0},{"$f":"SUM(F27:F33)","v":0},{"$f":"SUM(G27:G33)","v":0},27]
[28,null,null,null,null,null,null,28]
[29,null,null,null,null,null,null,29]
[30,null,null,null,null,null,null,30]
[31,"Net Operating Income",null,{"$f":"D23-D34","v":0},{"$f":"E23-E34","v":0},{"$f":"F23-F34","v":0},{"$f":"G23-G34","v":0},31]
[32,null,null,null,null,null,null,32]
[33,null,null,null,null,null,null,33]
[34,null,null,null,null,null,null,34]
[35,"Other Income:",null,null,null,null,null,35]
[36,"     Nonutility Income",null,0,0,0,{"$f":"D43+E43+F43","v":0},36]
[37,"     Other (Please Specify)",null,{"$f":"-ENTRY!E180","v":0},0,0,{"$f":"D44+E44+F44","v":0},37]
[38,"     Other (Please Specify)",null,0,0,0,{"$f":"D45+E45+F45","v":0},38]
[39,"     Other (Please Specify)",null,0,0,0,{"$f":"D46+E46+F46","v":0},39]
[40,"     Other (Please Specify)",null,0,0,0,{"$f":"D47+E47+F47","v":0},40]
[41,"          Total Other Income",null,{"$f":"SUM(D43:D47)","v":0},{"$f":"SUM(E43:E47)","v":0},{"$f":"SUM(F43:F47)","v":0},{"$f":"SUM(G43:G47)","v":0},41]
[42,null,null,null,null,null,null,42]
[43,null,null,null,null,null,null,43]
[44,null,null,null,null,null,null,44]
[45,"Other Deductions:",null,null,null,null,null,45]
[46,"     Misc. Nonutility Expenses",null,0,0,0,{"$f":"D53+E53+F53","v":0},46]
[47,"     Other (Please Specify)",null,{"$f":"ENTRY!E181+ENTRY!E182+ENTRY!E184","v":0},0,0,{"$f":"D54+E54+F54","v":0},47]
[48,"     Other (Please Specify)",null,0,0,0,{"$f":"D55+E55+F55","v":0},48]
[49,"     Other (Please Specify)",null,0,0,0,{"$f":"D56+E56+F56","v":0},49]
[50,"     Other (Please Specify)",null,0,0,0,{"$f":"D57+E57+F57","v":0},50]
[51,"          Total Other Deductions",null,{"$f":"SUM(D53:D57)","v":0},{"$f":"SUM(E53:E57)","v":0},{"$f":"SUM(F53:F57)","v":0},{"$f":"SUM(G53:G57)","v":0},51]
[52,null,null,null,null,null,null,52]
[53,null,null,null,null,null,null,53]
[54,null,null,null,null,null,null,54]
[55,"Net Income",null,{"$f":"D23-D34+D48-D58","v":0},{"$f":"E38+E48-E58","v":0},{"$f":"F38+F48-F58","v":0},{"$f":"G38+G48-G58","v":0},55]

{"sheet":"F-4","index":4,"n_rows":62,"n_cols":8,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["F-4"]
[null,"Name of Respondent",null,"This Report is:",null,"Date of Report","Year of Report"]
[null,{"$f":"ENTRY!D2","v":"Your Company Name"},null,{"$f":"'F-5'!C6","v":"(1) _X_ An Original"},null,"(Mo, Da, Yr)"]
[null,"  ",null,{"$f":"'F-5'!C7","v":"(2) ___ A Resubmission"},null,{"$f":"ENTRY!D4","v":"Date report compiled"},{"$f":"ENTRY!D3","v":"Fiscal Year End Date"}]
[1,"COMPARATIVE BALANCE SHEET",null,null,null,null,null,1]
[2,null,null,null,null,null,null,2]
[3,null,null,null,"Ref",null,null,3]
[4,"Account Name",null,null,"Page","Current Year","Previous Year",4]
[5,"(a)",null,null,"(b)","(c)","(d)",5]
[6,null,null,null,null,null,null,6]
[7,null,null,null,null,null,null,7]
[8,"ASSETS",null,null,null,null,null,8]
[9,null,null,null,null,null,null,9]
[10,"Utility Plant in Service (101-105)",null,null,"F5/W1/S1",0,0,10]
[11,"Accum. Depreciation and Amortization (108)",null,null,"F5/W2/S2",0,0,11]
[12,"     Net Utility Plant",null,null,null,{"$f":"F17-F18","v":0},{"$f":"G17-G18","v":0},12]
[13,null,null,null,null,null,null,13]
[14,"Cash",null,null,null,0,0,14]
[15,"Customer Accounts Receivable (141)",null,null,null,0,0,15]
[16,"Other Assets (Please Specify)",null,null,null,0,0,16]
[17,"Other Assets (Please Specify)",null,null,null,0,0,17]
[18,"Other Assets (Please Specify)",null,null,null,0,0,18]
[19,"Other Assets (Please Specify)",null,null,null,0,0,19]
[20,"          Total Assets",null,null,null,{"$f":"SUM(F19:F26)","v":0},{"$f":"SUM(G19:G26)","v":0},20]
[21,null,null,null,null,null,null,21]
[22,null,null,null,null,null,null,22]
[23,null,null,null,null,null,null,23]
[24,null,null,null,null,null,null,24]
[25,"LIABILITIES AND CAPITAL",null,null,null,null,null,25]
[26,null,null,null,null,null,null,26]
[27,"Common Stock Issued (201)",null,null,"F-6",0,0,27]
[28,"Preferred Stock Issued (204)",null,null,"F-6",0,0,28]
[29,"Other Paid-In Capital (211)",null,null,null,0,0,29]
[30,"Retained Earnings (215)",null,null,"F-6",0,0,30]
[31,"Capital (Proprietary & Partnership-218)",null,null,"F-6",0,0,31]
[32,"          Total Capital",null,null,null,{"$f":"SUM(F34:F38)","v":0},{"$f":"SUM(G34:G38)","v":0},32]
[33,null,null,null,null,null,null,33]
[34,null,null,null,null,null,null,34]
[35,null,null,null,null,null,null,35]
[36,null,null,null,null,null,null,36]
[37,"Long-Term Debt (224)",null,null,"F-6",0,0,37]
[38,"Accounts Payable (231)",null,null,null,0,0,38]
[39,"Notes Payable (232)",null,null,null,0,0,39]
[40,"Customer Deposits (235)",null,null,null,0,0,40]
[41,"Accrued Taxes (236)",null,null,null,0,0,41]
[42,"Other Liabilities (Please Specify)",null,null,null,0,0,42]
[43,"Other Liabilities (Please Specify)",null,null,null,0,0,43]
[44,"Other Liabilities (Please Specify)",null,null,null,0,0,44]
[45,"Other Liabilities (Please Specify)",null,null,null,0,0,45]
[46,"Other Liabilities (Please Specify)",null,null,null,0,0,46]
[47,"Advances for Construction",null,null,null,0,0,47]
[48,"Contributions In Aid Of Const.-Net (271-2)",null,null,"F-8",0,0,48]
[49,"          Total Liabilities",null,null,null,{"$f":"SUM(F44:F55)","v":0},{"$f":"SUM(G44:G55)","v":0},49]
[50,null,null,null,null,null,null,50]
[51,null,null,null,null,null,null,51]
[52,null,null,null,null,null,null,52]
[53,null,null,null,null,null,null,53]
[54,null,null,null,null,null,null,54]
[55,"          Total Liabilities & Capital",null,null,null,{"$f":"F39+F56","v":0},{"$f":"G39+G56","v":0},55]

{"sheet":"F-5","index":5,"n_rows":62,"n_cols":8,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,null,null,null,"F-5"]
[null,"Name of Respondent","This Report is:",null,null,"Date of Report","Year of Report"]
[null,{"$f":"ENTRY!D2","v":"Your Company Name"},{"$f":"'F-6'!D6","v":"(1) _X_ An Original"},null,null,"(Mo, Da, Yr)"]
[null,"  ",{"$f":"'F-6'!D7","v":"(2) ___ A Resubmission"},null,null,{"$f":"ENTRY!D4","v":"Date report compiled"},{"$f":"ENTRY!D3","v":"Fiscal Year End Date"}]
[1,"NET UTILITY PLANT",null,null,null,null,null,1]
[2,null,null,null,null,null,null,2]
[3,null,null,null,null,null,null,3]
[4,"Plant Accounts (101-107) Inclusive",null,"Water","Sewer","Other","Total",4]
[5,"(a)",null,"(c)","(d)","(e)","(f)",5]
[6,null,null,null,null,null,null,6]
[7,null,null,null,null,null,null,7]
[8,"     Utility Plant in Service (101)",null,0,0,0,{"$f":"D15+E15+F15","v":0},8]
[9,"     Construction Work in Progress (105)",null,{"$f":"ENTRY!D61","v":0},0,0,0,9]
[10,"     Other (Please Specify)",null,0,0,0,0,10]
[11,"     Other (Please Specify)",null,0,0,0,0,11]
[12,"     Other (Please Specify)",null,0,0,0,0,12]
[13,"     Other (Please Specify)",null,0,0,0,0,13]
[14,"     Other (Please Specify)",null,0,0,0,0,14]
[15,"     Other (Please Specify)",null,0,0,0,0,15]
[16,"          Total Utility Plant",null,{"$f":"SUM(D15:D22)","v":0},{"$f":"SUM(E15:E22)","v":0},{"$f":"SUM(F15:F22)","v":0},{"$f":"SUM(G15:G22)","v":0},16]
[17,null,null,null,null,null,null,17]
[18,null,null,null,null,null,null,18]
[19,null,null,null,null,null,null,19]
[20,null,null,null,null,null,null,20]
[21,null,null,null,null,null,null,21]
[22,null,null,null,null,null,null,22]
[23,"ACCUMULATED DEPRECIATION AND AMORTIZATION OF UTILITY PLANT",null,null,null,null,null,23]
[24,null,null,null,null,null,null,24]
[25,null,null,null,null,null,null,25]
[26,"Account 108",null,"Water","Sewer","Other","Total",26]
[27,"(a)",null,"(c)","(d)","(e)","(f)",27]
[28,null,null,null,null,null,null,28]
[29,null,null,null,null,null,null,29]
[30,"Balance First of Year",null,{"$f":"'W-2'!G39","v":0},0,0,{"$f":"D37+E37+F37","v":0},30]
[31,null,null,null,null,null,null,31]
[32,"Credits During Year:",null,null,null,null,null,32]
[33,"     Accruals charged to Depreciation Account",null,0,0,0,{"$f":"D40+E40+F40","v":0},33]
[34,"     Salvage",null,0,0,0,0,34]
[35,"     Other Credits (Please Specify):",null,0,0,0,0,35]
[36,"     Other Credits (Please Specify):",null,0,0,0,0,36]
[37,"     Other Credits (Please Specify):",null,0,0,0,0,37]
[38,"     Other Credits (Please Specify):",null,0,0,0,0,38]
[39,"Total Credits",null,{"$f":"SUM(D40:D45)","v":0},{"$f":"SUM(E40:E45)","v":0},{"$f":"SUM(F40:F45)","v":0},{"$f":"SUM(G40:G45)","v":0},39]
[40,null,null,null,null,null,null,40]
[41,null,null,null,null,null,null,41]
[42,"Debits During Year:",null,null,null,null,null,42]
[43,"     Book/Historical Cost of Plant Retired",null,{"$f":"'W-2'!H39","v":0},0,0,{"$f":"D50+E50+F50","v":0},43]
[44,"     Cost of Removal",null,0,0,0,0,44]
[45,"     Other Debits (Please Specify):",null,0,0,0,0,45]
[46,"     Other Debits (Please Specify):",null,0,0,0,0,46]
[47,"     Other Debits (Please Specify):",null,0,0,0,0,47]
[48,"     Other Debits (Please Specify):",null,0,0,0,0,48]
[49,"Total Debits",null,{"$f":"SUM(D50:D55)","v":0},{"$f":"SUM(E50:E55)","v":0},{"$f":"SUM(F50:F55)","v":0},{"$f":"SUM(G50:G55)","v":0},49]
[50,null,null,null,null,null,null,50]
[51,null,null,null,null,null,null,51]
[52,"Balance End of Year",null,{"$f":"D37+D46-D56","v":0},{"$f":"E37+E46-E56","v":0},{"$f":"F37+F46-F56","v":0},{"$f":"G37+G46-G56","v":0},52]
[53,null,null,null,null,null,null,53]
[54,null,null,null,null,null,null,54]
[55,null,null,null,null,null,null,55]

{"sheet":"F-6","index":6,"n_rows":62,"n_cols":8,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["F-6"]
[null,"Name of Respondent",null,"This Report is:",null,"Date of Report","Year of Report"]
[null,{"$f":"ENTRY!D2","v":"Your Company Name"},null,{"$f":"'F-7'!D6","v":"(1) _X_ An Original"},null,"(Mo, Da, Yr)"]
[null,"  ",null,{"$f":"'F-7'!D7","v":"(2) ___ A Resubmission"},null,{"$f":"ENTRY!D4","v":"Date report compiled"},{"$f":"ENTRY!D3","v":"Fiscal Year End Date"}]
[1,"CAPITAL STOCK (201 - 204)",null,null,null,null,null,1]
[2,null,null,null,null,null,null,2]
[3,null,null,null,null,null,null,3]
[4,null,null,null,null,"Common","Preferred",4]
[5,null,null,null,null,"Stock","Stock",5]
[6,"(a)",null,null,null,"(b)","(c)",6]
[7,"Par or stated value per share",null,null,null,0,0,7]
[8,"Shares Authorized",null,null,null,0,0,8]
[9,"Shares issued and outstanding",null,null,null,0,0,9]
[10,"Total par value of stock issued",null,null,null,0,0,10]
[11,"Dividends declared per share for year",null,null,null,0,0,11]
[12,null,null,null,null,null,null,12]
[13,"RETAINED EARNINGS (215)",null,null,null,null,null,13]
[14,null,null,null,null,null,null,14]
[15,null,null,null,null,"Appropriated","Unappropriated",15]
[16,"(a)",null,null,null,"(b)","(c)",16]
[17,"Balance first of year",null,null,null,0,{"$f":"ENTRY!D81","v":0},17]
[18,"Changes during year NET INCOME/(NET LOSS)",null,null,null,0,0,18]
[19,"Changes during year (Please Specify)",null,null,null,0,0,19]
[20,"Changes during year (Please Specify)",null,null,null,0,0,20]
[21,"Changes during year (Please Specify)",null,null,null,0,0,21]
[22,"Changes during year (Please Specify)",null,null,null,0,0,22]
[23,"Changes during year (Please Specify)",null,null,null,0,0,23]
[24,"Balance end of year",null,null,null,{"$f":"SUM(F24:F30)","v":0},{"$f":"SUM(G24:G30)","v":0},24]
[25,"PROPRIETARY CAPITAL (218)",null,null,null,null,null,25]
[26,null,null,null,null,null,null,26]
[27,null,null,null,null,null,null,27]
[28,null,null,"NONE",null,"Proprietor","Partner",28]
[29,"(a)",null,null,null,"(b)","(c)",29]
[30,"Balance first of year",null,null,null,0,0,30]
[31,"Changes during year (Please Specify)",null,null,null,0,0,31]
[32,"Changes during year (Please Specify)",null,null,null,0,0,32]
[33,"Changes during year (Please Specify)",null,null,null,0,0,33]
[34,"Changes during year (Please Specify)",null,null,null,0,0,34]
[35,"Changes during year (Please Specify)",null,null,null,0,0,35]
[36,"Changes during year (Please Specify)",null,null,null,0,0,36]
[37,"Balance end of year",null,null,null,{"$f":"SUM(F37:F43)","v":0},{"$f":"SUM(G37:G43)","v":0},37]
[38,"LONG-TERM DEBT (224)",null,null,null,null,null,38]
[39,null,null,null,null,null,null,39]
[40,null,null,null,null,null,"Year End",40]
[41,"Description of Obligation including Issue & Maturity Dates",null,null,"NONE","Interest Rate","Balance",41]
[42,"(a)",null,null,null,"(b)","(c)",42]
[43,"Debt #1",null,null,null,0,0,43]
[44,"Debt #2",null,null,null,0,0,44]
[45,"Debt #3",null,null,null,0,0,45]
[46,"Debt #4",null,null,null,0,0,46]
[47,"Debt #5",null,null,null,0,0,47]
[48,"Debt #6",null,null,null,0,0,48]
[49,"Debt #7",null,null,null,0,0,49]
[50,"Debt #8",null,null,null,0,0,50]
[51,"Debt #9",null,null,null,0,0,51]
[52,"Debt #10",null,null,null,0,0,52]
[53,"Debt #11",null,null,null,0,0,53]
[54,"Debt #12",null,null,null,0,0,54]
[55,"     Total Long-Term Debt",null,null,null,null,{"$f":"SUM(G50:G61)","v":0},55]

{"sheet":"F-7","index":7,"n_rows":62,"n_cols":8,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,null,null,null,"F-7"]
[null,"Name of Respondent",null,"This Report is:",null,"Date of Report","Year of Report"]
[null,{"$f":"ENTRY!D2","v":"Your Company Name"},null,{"$f":"'F-8'!D6","v":"(1) _X_ An Original"},null,"(Mo, Da, Yr)"]
[null,"  ",null,{"$f":"'F-8'!D7","v":"(2) ___ A Resubmission"},null,{"$f":"ENTRY!D4","v":"Date report compiled"},{"$f":"ENTRY!D3","v":"Fiscal Year End Date"}]
[1,"TAXES ACCRUED (236)",null,null,null,null,null,1]
[2,null,null,null,null,null,null,2]
[3,null,null,null,null,null,null,3]
[4,"Description",null,"Water","Sewer","Other","Total",4]
[5,"(a)",null,"(b)","(c)","(d)","(e)",5]
[6,null,null,null,null,null,null,6]
[7,"Balance First of year",null,0,0,0,{"$f":"D14+E14+F14","v":0},7]
[8,null,null,null,null,null,null,8]
[9,"Accruals Charged:",null,null,null,null,null,9]
[10,"     Federal Income Tax",null,0,0,0,{"$f":"D17+E17+F17","v":0},10]
[11,"     Local Property tax",null,0,0,0,0,11]
[12,"     State ad valorem tax",null,0,0,0,0,12]
[13,"     TN State Sales Tax",null,0,0,0,0,13]
[14,"     Regulatory Assessment Fee",null,0,0,0,0,14]
[15,"     Payroll Tax",null,0,0,0,0,15]
[16,"     Other Taxes (Please Specify)",null,0,0,0,0,16]
[17,"     Other Taxes (Please Specify)",null,0,0,0,0,17]
[18,"          Total Taxes Accrued",null,{"$f":"SUM(D17:D24)","v":0},{"$f":"SUM(E17:E24)","v":0},{"$f":"SUM(F17:F24)","v":0},{"$f":"SUM(G17:G24)","v":0},18]
[19,null,null,null,null,null,null,19]
[20,"Taxes Paid",null,null,null,null,null,20]
[21,"     Federal Income Tax",null,0,0,0,{"$f":"D28+E28+F28","v":0},21]
[22,"     Local Property tax",null,0,0,0,0,22]
[23,"     State ad valorem tax",null,0,0,0,0,23]
[24,"     TN State Sales Tax",null,0,0,0,0,24]
[25,"     Regulatory assessment fee",null,0,0,0,0,25]
[26,"     Payroll Tax",null,0,0,0,0,26]
[27,{"$f":"B23","v":"     Other Taxes (Please Specify)"},null,0,0,0,0,27]
[28,{"$f":"B24","v":"     Other Taxes (Please Specify)"},null,0,0,0,0,28]
[29,"          Total Taxes Paid",null,{"$f":"SUM(D28:D35)","v":0},{"$f":"SUM(E28:E35)","v":0},{"$f":"SUM(F28:F35)","v":0},{"$f":"SUM(G28:G35)","v":0},29]
[30,null,null,null,null,null,null,30]
[31,null,null,null,null,null,null,31]
[32,"Balance End of Year",null,{"$f":"D14+D25-D36","v":0},{"$f":"E14+E25-E36","v":0},{"$f":"F14+F25-F36","v":0},{"$f":"G14+G25-G36","v":0},32]
[33,null,null,null,null,null,null,33]
[34,null,null,null,null,null,null,34]
[35,"PAYMENTS FOR SERVICES RENDERED BY OTHER THAN EMPLOYEES",null,null,null,null,null,35]
[36,null,null,null,null,null,null,36]
[37,"Report all info concerning rate, management, construction, advertising, labor relations, or other  professional services rendered to the",null,null,null,null,null,37]
[38,"Utility for which total payments during the year to any Corp, Ptnshp, indiv, or organization of any kind, amounted to $500 or more.",null,null,null,null,null,38]
[39,null,null,null,null,null,null,39]
[40,"Name of Recipient",null,"Amount","Description of Service",null,null,40]
[41,null,null,null,null,null,null,41]
[42,null,null,null,null,null,null,42]
[43,null,null,null,null,null,null,43]
[44,null,null,null,null,null,null,44]
[45,null,null,null,null,null,null,45]
[46,null,null,null,null,null,null,46]
[47,null,null,null,null,null,null,47]
[48,null,null,null,null,null,null,48]
[49,null,null,null,null,null,null,49]
[50,null,null,null,null,null,null,50]
[51,null,null,null,null,null,null,51]
[52,null,null,null,null,null,null,52]
[53,null,null,null,null,null,null,53]
[54,null,null,null,null,null,null,54]
[55,null,null,null,null,null,null,55]

{"sheet":"F-8","index":8,"n_rows":62,"n_cols":8,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["F-8"]
[null,"Name of Respondent",null,"This Report is:",null,"Date of Report","Year of Report"]
[null,{"$f":"ENTRY!D2","v":"Your Company Name"},null,{"$f":"'S-1'!D6","v":"(1) _X_ An Original"},null,"(Mo, Da, Yr)"]
[null,"  ",null,{"$f":"'S-1'!D7","v":"(2) ___ A Resubmission"},null,{"$f":"ENTRY!D4","v":"Date report compiled"},{"$f":"ENTRY!D3","v":"Fiscal Year End Date"}]
[1,"CONTRIBUTIONS IN AID OF CONSTRUCTION (271)",null,null,null,null,null,1]
[2,null,null,null,null,null,null,2]
[3,null,null,null,null,null,null,3]
[4,"Description",null,null,"Water","Sewer","Total",4]
[5,"(a)",null,null,"(b)","(c)","(d)",5]
[6,null,null,null,null,null,null,6]
[7,"Balance First of Year",null,null,0,0,{"$f":"D14+E14+F14","v":0},7]
[8,"     Add Credits During Year",null,null,0,0,{"$f":"D15+E15+F15","v":0},8]
[9,"     Less Charges During Year",null,null,0,0,{"$f":"D16+E16+F16","v":0},9]
[10,"Balance End of Year",null,null,{"$f":"ENTRY!D95","v":0},{"$f":"F14+F15-F16","v":0},{"$f":"G14+G15-G16","v":0},10]
[11,null,null,null,null,null,null,11]
[12,"     Less Accumulated Amortization",null,null,0,0,{"$f":"D19+E19+F19","v":0},12]
[13,"Net Contributions in Aid of Construction",null,null,{"$f":"E17-E19","v":0},{"$f":"F17-F19","v":0},{"$f":"G17-G19","v":0},13]
[14,null,null,null,null,null,null,14]
[15,null,null,null,null,null,null,15]
[16,null,null,null,null,null,null,16]
[17,null,null,null,null,null,null,17]
[18,null,null,null,null,null,null,18]
[19,"ADDITIONS TO CONTRIBUTIONS IN AID OF CONSTRUCTION DURING YEAR (CREDITS)",null,null,null,null,null,19]
[20,null,null,null,null,null,null,20]
[21,null,null,null,null,null,null,21]
[22,"Report below all developers or contractors agreements from ",null,null,"Indicate \"Cash\"",null,null,22]
[23,"which cash or property was received during the year",null,null,"or \"Property\"","Water","Sewer",23]
[24,"(a)",null,null,"(b)","(c)","(d)",24]
[25,"Contractor or Developer #1",null,null,null,0,0,25]
[26,"Contractor or Developer #2",null,null,null,0,0,26]
[27,"Contractor or Developer #3",null,null,null,0,0,27]
[28,"Contractor or Developer #4",null,null,null,0,0,28]
[29,"Contractor or Developer #5",null,null,null,0,0,29]
[30,"Contractor or Developer #6",null,null,null,0,0,30]
[31,"Contractor or Developer #7",null,null,null,0,0,31]
[32,"Contractor or Developer #8",null,null,null,0,0,32]
[33,"Contractor or Developer #9",null,null,null,0,0,33]
[34,"Contractor or Developer #10",null,null,null,0,0,34]
[35,"Contractor or Developer #11",null,null,null,0,0,35]
[36,"Contractor or Developer #12",null,null,null,0,0,36]
[37,"Contractor or Developer #13",null,null,null,0,0,37]
[38,"Contractor or Developer #14",null,null,null,0,0,38]
[39,"Contractor or Developer #15",null,null,null,0,0,39]
[40,"Contractor or Developer #16",null,null,null,0,0,40]
[41,"Contractor or Developer #17",null,null,null,0,0,41]
[42,"Contractor or Developer #18",null,null,null,0,0,42]
[43,"Contractor or Developer #19",null,null,null,0,0,43]
[44,"Contractor or Developer #20",null,null,null,0,0,44]
[45,"Contractor or Developer #21",null,null,null,0,0,45]
[46,"Contractor or Developer #22",null,null,null,0,0,46]
[47,"Contractor or Developer #23",null,null,null,0,0,47]
[48,"Contractor or Developer #24",null,null,null,0,0,48]
[49,"Contractor or Developer #25",null,null,null,0,0,49]
[50,"Contractor or Developer #26",null,null,null,0,0,50]
[51,"Contractor or Developer #27",null,null,null,0,0,51]
[52,"Contractor or Developer #28",null,null,null,0,0,52]
[53,"Contractor or Developer #29",null,null,null,0,0,53]
[54,"Contractor or Developer #30",null,null,null,0,0,54]
[55,"     Total Credits During Year",null,null,null,{"$f":"SUM(F32:F61)","v":0},{"$f":"SUM(G32:G61)","v":0},55]

{"sheet":"S-1","index":9,"n_rows":62,"n_cols":8,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,"",null,null,null,null,"S-1"]
[null,"Name of Respondent",null,"This Report is:",null,"Date of Report","Year of Report"]
[null,{"$f":"ENTRY!D2","v":"Your Company Name"},null,{"$f":"'S-2'!G6","v":"(1) _X_ An Original"},null,"(Mo, Da, Yr)"]
[null,"  ",null,{"$f":"'S-2'!G7","v":"(2) ___ A Resubmission"},null,{"$f":"ENTRY!D4","v":"Date report compiled"},{"$f":"ENTRY!D4","v":"Date report compiled"}]
[1,"SEWER UTILITY PLANT ACCOUNTS",null,null,null,null,null,1]
[2,null,null,null,null,null,null,2]
[3,"Acct",null,null,null,null,null,3]
[4,"No.","Account Name","Previous Year","Additions","Retirements","Current Year",4]
[5,"(a)","(b)","(c)","(d)","(e)","(f)",5]
[6,null,null,null,null,null,null,6]
[7,351,"Organization",0,0,0,{"$f":"D14+E14-F14","v":0},7]
[8,352,"Franchises",0,0,0,0,8]
[9,353,"Land & Land Rights",0,0,0,0,9]
[10,354,"Structures & Improvements",0,0,0,0,10]
[11,360,"Collection Sewers - Force",0,0,0,0,11]
[12,361,"Collection Sewers - Gravity",0,0,0,0,12]
[13,362,"Special Collecting Structures",0,0,0,0,13]
[14,363,"Services to Customers",0,0,0,0,14]
[15,364,"Flow Measuring Devices",0,0,0,0,15]
[16,365,"Flow Measuring Installations",0,0,0,0,16]
[17,370,"Receiving Wells",0,0,0,0,17]
[18,371,"Pumping Equipment",0,0,0,0,18]
[19,380,"Treatment & Disposal Equipment",0,0,0,0,19]
[20,381,"Plant Sewers",0,0,0,0,20]
[21,382,"Outfall Sewer Lines",0,0,0,0,21]
[22,389,"Other Plant & Miscellaneous Equipment",0,0,0,0,22]
[23,390,"Office Furniture & Equipment",0,0,0,{"$f":"D30+E30-F30","v":0},23]
[24,391,"Transportation Equipment",0,0,0,0,24]
[25,392,"Stores Equipment",0,0,0,0,25]
[26,393,"Tools, Shop & Garage Equipment",0,0,0,0,26]
[27,394,"Laboratory Equipment",0,0,0,0,27]
[28,395,"Power Operated Equipment",0,0,0,0,28]
[29,396,"Communication Equipment",0,0,0,0,29]
[30,397,"Miscellaneous Equipment",0,0,0,0,30]
[31,398,"Other Tangible Plant",0,0,0,0,31]
[32,null,"     Total Sewer Plant",{"$f":"SUM(D14:D38)","v":0},{"$f":"SUM(E14:E38)","v":0},{"$f":"SUM(F14:F38)","v":0},{"$f":"SUM(G14:G38)","v":0},32]
[33,null,null,null,null,null,null,33]
[34,null,null,null,null,null,null,34]
[35,null,null,null,null,null,null,35]
[36,null,null,null,null,null,null,36]
[37,null,null,null,null,null,null,37]
[38,null,null,null,null,null,null,38]
[39,null,null,null,null,null,null,39]
[40,null,null,null,null,null,null,40]
[41,null,null,null,null,null,null,41]
[42,null,null,null,null,null,null,42]
[43,null,null,null,null,null,null,43]
[44,null,null,null,null,null,null,44]
[45,null,null,null,null,null,null,45]
[46,null,null,null,null,null,null,46]
[47,null,null,null,null,null,null,47]
[48,null,null,null,null,null,null,48]
[49,null,null,null,null,null,null,49]
[50,null,null,null,null,null,null,50]
[51,null,null,null,null,null,null,51]
[52,null,null,null,null,null,null,52]
[53,null,null,null,null,null,null,53]
[54,null,null,null,null,null,null,54]
[55,null,null,null,null,null,null,55]

{"sheet":"S-2","index":10,"n_rows":61,"n_cols":11,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["S-2",null,null,null,null,null,null,null,null,null,"S-2"]
[null,"Name of Respondent",null,null,null,null,"This Report is:",null,"Date of Report","Year of Report"]
[null,{"$f":"ENTRY!D2","v":"Your Company Name"},null,null,null,null,{"$f":"'S-3'!D6","v":"(1) _X_ An Original"},null,"(Mo, Da, Yr)"]
[null,"  ",null,null,null,null,{"$f":"'S-3'!D7","v":"(2) ___ A Resubmission"},null,{"$f":"ENTRY!D4","v":"Date report compiled"},{"$f":"ENTRY!D3","v":"Fiscal Year End Date"}]
[1,"ANALYSIS OF ACCUMULATED DEPRECIATION BY PRIMARY ACCOUNT - SEWER",null,null,null,null,null,null,null,null,1]
[2,null,null,null,null,null,null,null,null,null,2]
[3,null,null,"Average","Average","Depreciation","Accumulated",null,null,"Accumulated",3]
[4,"Account",null,"Service Life","Salvage Value","Rate","Depreciation Balance",null,null,"Depreciation Balance",4]
[5,"Number","Account","in Years","in Percent","Applied*","Previous Year","Debits","Credits","End of Year",5]
[6,"(a)","(b)","(c)","(d)","(e)","(f)","(g)","(h)","(i)",6]
[7,null,null,null,null,null,null,null,null,null,7]
[8,354,"Structures & Improvements",0,0,0,0,0,0,{"$f":"G15-H15+I15","v":0},8]
[9,360,"Collection Sewers - Force",0,0,0,0,0,0,0,9]
[10,361,"Collection Sewers - Gravity",0,0,0,0,0,0,0,10]
[11,362,"Special Collecting Structures",0,0,0,0,0,0,0,11]
[12,363,"Services to Customers",0,0,0,0,0,0,0,12]
[13,364,"Flow Measuring Devices",0,0,0,0,0,0,0,13]
[14,365,"Flow Measuring Installations",0,0,0,0,0,0,0,14]
[15,370,"Receiving Wells",0,0,0,0,0,0,0,15]
[16,371,"Pumping Equipment",0,0,0,0,0,0,0,16]
[17,380,"Treatment & Disposal Equipment",0,0,0,0,0,0,0,17]
[18,381,"Plant Sewers",0,0,0,0,0,0,0,18]
[19,382,"Outfall Sewer Lines",0,0,0,0,0,0,0,19]
[20,389,"Other Plant & Miscellaneous Equipment",0,0,0,0,0,0,0,20]
[21,390,"Office Furniture & Equipment",0,0,0,0,0,0,0,21]
[22,391,"Transportation Equipment",0,0,0,0,0,0,0,22]
[23,392,"Stores Equipment",0,0,0,0,0,0,0,23]
[24,393,"Tools, Shop & Garage Equipment",0,0,0,0,0,0,{"$f":"G31-H31+I31","v":0},24]
[25,394,"Laboratory Equipment",0,0,0,0,0,0,0,25]
[26,395,"Power Operated Equipment",0,0,0,0,0,0,0,26]
[27,396,"Communication Equipment",0,0,0,0,0,0,0,27]
[28,397,"Miscellaneous Equipment",0,0,0,0,0,0,0,28]
[29,398,"Other Tangible Plant",0,0,0,0,0,0,0,29]
[30,null,"     Totals",null,null,null,{"$f":"SUM(G15:G36)","v":0},{"$f":"SUM(H15:H36)","v":0},{"$f":"SUM(I15:I36)","v":0},{"$f":"SUM(J15:J36)","v":0},30]
[31,null,null,null,null,null,null,null,null,null,31]
[32,null,null,null,null,null,null,null,null,null,32]
[33,null,"*State basis used for percetages used in schedule.",null,null,null,null,null,null,null,33]
[34,null,null,null,null,null,null,null,null,null,34]
[35,null,null,null,null,null,null,null,null,null,35]
[36,null,null,null,null,null,null,null,null,null,36]
[37,null,null,null,null,null,null,null,null,null,37]
[38,null,null,null,null,null,null,null,null,null,38]
[39,null,null,null,null,null,null,null,null,null,39]
[40,null,null,null,null,null,null,null,null,null,40]
[41,null,null,null,null,null,null,null,null,null,41]
[42,null,null,null,null,null,null,null,null,null,42]
[43,null,null,null,null,null,null,null,null,null,43]
[]
[]
[]
[]
[]
[]
[]
["!!!   PLEASE   !!!"]
["DO NOT CHANGE THE FORMULAS OR FORMATTING OF THIS SPREADSHEET"]
[]
[null,null,null,""]

{"sheet":"S-3","index":11,"n_rows":62,"n_cols":8,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,"",null,null,null,null,"S-3"]
[null,"Name of Respondent",null,"This Report is:",null,"Date of Report","Year of Report"]
[null,{"$f":"ENTRY!D2","v":"Your Company Name"},null,{"$f":"'S-4'!D6","v":"(1) _X_ An Original"},null,"(Mo, Da, Yr)"]
[null,"  ",null,{"$f":"'S-4'!D7","v":"(2) ___ A Resubmission"},null,{"$f":"ENTRY!D4","v":"Date report compiled"},{"$f":"ENTRY!D3","v":"Fiscal Year End Date"}]
[1,"SEWER OPERATION & MAINTENANCE EXPENSE",null,null,null,null,"N/A",1]
[2,null,null,null,null,null,null,2]
[3,null,null,null,null,null,null,3]
[4,"Acct",null,null,null,null,null,4]
[5,"No.","Description",null,null,null,"Amount",5]
[6,null,"(a)",null,null,null,"(b)",6]
[7,701,"Salaries & Wages - Employees",null,null,null,0,7]
[8,703,"Salaries & Wages - Officers, Directors & Stockholders",null,null,null,0,8]
[9,704,"Employee Pensions & Benefits",null,null,null,0,9]
[10,710,"Purchased Sewage Treatment",null,null,null,0,10]
[11,711,"Sludge Removal Expense",null,null,null,0,11]
[12,715,"Purchased Power",null,null,null,0,12]
[13,716,"Fuel for Power Production",null,null,null,0,13]
[14,718,"Chemicals",null,null,null,0,14]
[15,720,"Materials & Supplies",null,null,null,0,15]
[16,730,"Contractual Services",null,null,null,0,16]
[17,740,"Rents",null,null,null,0,17]
[18,750,"Transportation Expense",null,null,null,0,18]
[19,755,"Insurance Expense",null,null,null,0,19]
[20,765,"Regulatory Commission Expense",null,null,null,0,20]
[21,770,"Bad Debt Expense",null,null,null,0,21]
[22,775,"Miscellaneous Expenses",null,null,null,0,22]
[23,null,"     Total Sewer Operation & Maintenance Expense",null,null,null,{"$f":"SUM(G14:G29)","v":0},23]
[24,null,null,null,null,null,null,24]
[25,null,null,null,null,null,null,25]
[26,null,null,null,null,null,null,26]
[27,null,null,null,null,null,null,27]
[28,null,null,null,null,null,null,28]
[29,"SEWER CUSTOMERS",null,null,null,null,null,29]
[30,null,null,null,null,null,null,30]
[31,null,null,"Customers",null,null,"Customers",31]
[32,"Description",null,"First of Year","Additions","Disconnections","End of Year",32]
[33,"(a)",null,"(b)","(c)","(d)","(e)",33]
[34,"Metered Customers:",null,null,null,null,null,34]
[35,null,"5/8 Inch",0,0,0,{"$f":"D42+E42-F42","v":0},35]
[36,null,"3/4 Inch",0,0,0,0,36]
[37,null,"1.0 Inch",0,0,0,0,37]
[38,null,"1.5 Inch",0,0,0,0,38]
[39,null,"2.0 Inch",0,0,0,0,39]
[40,null,"2.5 Inch",0,0,0,0,40]
[41,null,"3.0 Inch",0,0,0,0,41]
[42,null,"4.0 Inch",0,0,0,0,42]
[43,null,"6.0 Inch",0,0,0,0,43]
[44,null,"8.0 Inch",0,0,0,0,44]
[45,null,"Other (Please Specify)",0,0,0,0,45]
[46,null,"Other (Please Specify)",0,0,0,0,46]
[47,null,"Other (Please Specify)",0,0,0,0,47]
[48,"Unmetered Customers",null,0,0,0,0,48]
[49,"Total Customers",null,{"$f":"SUM(D42:D55)","v":0},{"$f":"SUM(E42:E55)","v":0},{"$f":"SUM(F42:F55)","v":0},{"$f":"SUM(G42:G55)","v":0},49]
[50,null,null,null,null,null,null,50]
[51,null,null,null,null,null,null,51]
[52,null,null,null,null,null,null,52]
[53,null,null,null,null,null,null,53]
[54,null,null,null,null,null,null,54]
[55,null,null,null,null,null,null,55]

{"sheet":"S-4","index":12,"n_rows":64,"n_cols":8,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["S-4"]
[null,"Name of Respondent",null,"This Report is:",null,"Date of Report","Year of Report"]
[null,{"$f":"ENTRY!D2","v":"Your Company Name"},null,{"$f":"'S-5'!D6","v":"(1) _X_ An Original"},null,"(Mo, Da, Yr)"]
[null,"  ",null,{"$f":"'S-5'!D7","v":"(2) ___ A Resubmission"},null,{"$f":"ENTRY!D4","v":"Date report compiled"},{"$f":"ENTRY!D3","v":"Fiscal Year End Date"}]
[1,"PUMPING EQUIPMENT",null,null,null,null,null,1]
[2,null,null,null,null,null,null,2]
[3,null,null,null,null,null,null,3]
[4,null,null,"Lift","Lift","Lift","Lift",4]
[5,null,null,"Station","Station","Station","Station",5]
[6,"Description***",null,"#1","#2","#3","#4",6]
[7,"(a)",null,"(b)","(c)","(d)","(e)",7]
[8,null,null,null,null,null,null,8]
[9,null,null,null,null,null,null,9]
[10,"Make, Model, or Type of Pump",null,null,null,null,null,10]
[11,null,null,null,null,null,null,11]
[12,"Year Installed",null,null,null,null,null,12]
[13,null,null,null,null,null,null,13]
[14,"Rated Capacity (GPM)",null,null,null,null,null,14]
[15,null,null,null,null,null,null,15]
[16,"Size (HP)",null,null,null,null,null,16]
[17,null,null,null,null,null,null,17]
[18,"Power (Electric/Mechanical)",null,null,null,null,null,18]
[19,null,null,null,null,null,null,19]
[20,"Make, Model or Type of Motor",null,null,null,null,null,20]
[21,null,null,null,null,null,null,21]
[22,"SERVICE CONNECTIONS",null,null,null,null,null,22]
[23,null,null,null,null,null,null,23]
[24,null,null,null,null,null,null,24]
[25,null,null,"Service","Service","Service","Service",25]
[26,null,null,"Connection","Connection","Connection","Connection",26]
[27,"Description***",null,"#1","#2","#3","#4",27]
[28,"(a)",null,"(b)","(c)","(d)","(e)",28]
[29,null,null,null,null,null,null,29]
[30,"Size (Inches)",null,null,null,null,null,30]
[31,"Type (PVC, VCP, etc)",null,null,null,null,null,31]
[32,"Average Length (Feet)",null,null,null,null,null,32]
[33,null,null,null,null,null,null,33]
[34,"Connections-Beginning of Year",null,0,0,0,0,34]
[35,"Connections-Added during Year",null,0,0,0,0,35]
[36,"Connection-Retired during Year",null,0,0,0,0,36]
[37,"Connections-End of Year",null,{"$f":"D41+D42-D43","v":0},{"$f":"E41+E42-E43","v":0},{"$f":"F41+F42-F43","v":0},{"$f":"G41+G42-G43","v":0},37]
[38,null,null,null,null,null,null,38]
[39,"Number of Inactive Connections",null,0,0,0,0,39]
[40,null,null,null,null,null,null,40]
[41,"COLLECTING MAINS, FORCE MAINS, & MANHOLES",null,null,null,null,null,41]
[42,null,null,null,null,null,null,42]
[43,null,null,null,null,null,null,43]
[44,null,null,null,"Collecting","Force",null,44]
[45,null,null,null,"Mains","Mains","Manholes",45]
[46,"Description",null,null,null,null,null,46]
[47,"(a)",null,null,"(b)","(c)","(d)",47]
[48,null,null,null,null,null,null,48]
[49,"Size (Inches)",null,null,null,null,null,49]
[50,"Type",null,null,null,null,null,50]
[51,"Length/Number-Beginning of Year",null,null,0,0,0,51]
[52,"Length/Number-Added During Year",null,null,0,0,0,52]
[53,"Length/Number-Retired During Year",null,null,0,0,0,53]
[54,"Length/Number-End of Year",null,null,{"$f":"E58+E59-E60","v":0},{"$f":"F58+F59-F60","v":0},{"$f":"G58+G59-G60","v":0},54]
[55,null,null,null,null,null,null,55]
[]
[null,"***If more space is needed to list equipment please attach additional sheets as necessary. "]

{"sheet":"S-5","index":13,"n_rows":64,"n_cols":8,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,"",null,null,null,null,"S-5"]
[null,"Name of Respondent",null,"This Report is:",null,"Date of Report","Year of Report"]
[null,{"$f":"ENTRY!D2","v":"Your Company Name"},null,{"$f":"'W-1'!D6","v":"(1) _X_ An Original"},null,"(Mo, Da, Yr)"]
[null,"  ",null,{"$f":"'W-1'!D7","v":"(2) ___ A Resubmission"},null,{"$f":"ENTRY!D4","v":"Date report compiled"},{"$f":"ENTRY!D3","v":"Fiscal Year End Date"}]
[1,"TREATMENT PLANT",null,null,null,null,null,1]
[2,null,null,null,null,null,null,2]
[3,null,null,null,null,null,null,3]
[4,null,null,"Treatment","Treatment","Treatment","Treatment",4]
[5,null,null,"Facility","Facility","Facility","Facility",5]
[6,"Description***",null,"#1","#2","#3","#4",6]
[7,"(a)",null,"(b)","(c)","(d)","(e)",7]
[8,null,null,null,null,null,null,8]
[9,"Manufacturer",null,null,null,null,null,9]
[10,"Type",null,null,null,null,null,10]
[11,"Steel or Concrete",null,null,null,null,null,11]
[12,"Total Capacity",null,null,null,null,null,12]
[13,"Average Daily Flow",null,null,null,null,null,13]
[14,"Effluent Disposal",null,null,null,null,null,14]
[15,"Total Gallons of Sewage Treated",null,null,null,null,null,15]
[16,null,null,null,null,null,null,16]
[17,"MASTER LIFT STATION PUMPS",null,null,null,null,null,17]
[18,null,null,null,null,null,null,18]
[19,null,null,null,null,null,null,19]
[20,null,null,"Master","Master","Master","Master",20]
[21,null,null,"Pump","Pump","Pump","Pump",21]
[22,"Description***",null,"#1","#2","#3","#4",22]
[23,"(a)",null,"(b)","(c)","(d)","(e)",23]
[24,null,null,null,null,null,null,24]
[25,"Manufacturer",null,null,null,null,null,25]
[26,"Capacity (GPM)",null,null,null,null,null,26]
[27,"Size (HP)",null,null,null,null,null,27]
[28,"Power (Electric/Mechanical)",null,null,null,null,null,28]
[29,"Make, Model, or Type of Motor",null,null,null,null,null,29]
[30,null,null,null,null,null,null,30]
[31,"OTHER SEWER SYSTEM INFORMATION",null,null,null,null,null,31]
[32,null,null,null,null,null,null,32]
[33,null,null,null,null,null,null,33]
[34,"Present Number of Equivalent Residential Customer's * being served",null,null,null,null,null,34]
[35,"Maximum Number of Equivalent Residential Customer's * that the system can efficiently serve",null,null,null,null,null,35]
[36,"Estimated Annual Increase in Equivalent Residential Customers *",null,null,null,null,null,36]
[37,null,null,null,null,null,null,37]
[38,"*  Equivalent Residential Customers = (Total Gallons Treated / 365 Days) / 275 Gallons Per Day.",null,null,null,null,null,38]
[39,"    Total Gallons Treated includes both sewage treated and purchased sewage treatment.",null,null,null,null,null,39]
[40,null,null,null,null,null,null,40]
[41,"State any plans and estimated completion dates for any enlargements of this system:",null,null,null,null,null,41]
[42,null,null,null,null,null,null,42]
[43,null,null,null,null,null,null,43]
[44,null,null,null,null,null,null,44]
[45,"If the present systems do not meet environmental requirements, please submit the following:",null,null,null,null,null,45]
[46,null,"A.  An evaluation of the present plant or plants in regard to meeting the requirements.",null,null,null,null,46]
[47,null,"B.  Plans for funding and construction of the required upgrading.",null,null,null,null,47]
[48,null,"C.  The date construction will begin.",null,null,null,null,48]
[49,null,null,null,null,null,null,49]
[50,"What is the percent of the certificated area that have service connections installed?",null,null,null,null,null,50]
[51,null,null,null,null,null,null,51]
[52,null,null,null,null,null,null,52]
[53,null,null,null,null,null,null,53]
[54,null,null,null,null,null,null,54]
[55,null,null,null,null,null,null,55]
[]
[null,"***If more space is needed to list equipment please attach additional sheets as necessary. "]

{"sheet":"W-1","index":14,"n_rows":62,"n_cols":8,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"W-1",""]
[null,"Name of Respondent",null,"This Report is:",null,"Date of Report","Year of Report"]
[null,{"$f":"ENTRY!D2","v":"Your Company Name"},null,{"$f":"'W-2'!G6","v":"(1) _X_ An Original"},null,"(Mo, Da, Yr)"]
[null,"  ",null,{"$f":"'W-2'!G7","v":"(2) ___ A Resubmission"},null,{"$f":"ENTRY!D4","v":"Date report compiled"},{"$f":"ENTRY!D3","v":"Fiscal Year End Date"}]
[1,"WATER UTILITY PLANT ACCOUNTS",null,null,null,null,null,1]
[2,null,null,null,null,null,null,2]
[3,"Acct",null,null,null,null,null,3]
[4,"No.","Account Name","Previous Year","Additions","Retirements","Current Year",4]
[5,"(a)","(b)","(c)","(d)","(e)","(f)",5]
[6,null,null,null,null,null,null,6]
[7,301,"Organization",0,0,0,{"$f":"D14+E14-F14","v":0},7]
[8,302,"Franchises",0,0,0,{"$f":"D15+E15-F15","v":0},8]
[9,303,"Land & Land Rights",0,0,0,0,9]
[10,304,"Structures & Improvements",0,0,0,0,10]
[11,305,"Collecting & Impounding Reservoirs",0,0,0,0,11]
[12,306,"Lake, River & Other Intakes",0,0,0,0,12]
[13,307,"Wells & Springs",0,0,0,0,13]
[14,308,"Infiltration Galleries & Tunnels",0,0,0,0,14]
[15,309,"Supply Mains",0,0,0,0,15]
[16,310,"Power Generation Equipment",0,0,0,0,16]
[17,311,"Pumping Equipment",0,0,0,0,17]
[18,320,"Water Treatment Equipment",0,0,0,0,18]
[19,330,"Distribution Reservoirs & Standpipes",0,0,0,0,19]
[20,331,"Transmission & Distribution Mains",0,0,0,0,20]
[21,333,"Services",0,0,0,0,21]
[22,334,"Meters & Meter Installations",0,0,0,0,22]
[23,335,"Hydrants",0,0,0,0,23]
[24,339,"Other Plant & Miscellaneous Equipment",0,0,0,0,24]
[25,340,"Office Furniture & Equipment",0,0,0,0,25]
[26,341,"Transportation Equipment",0,0,0,0,26]
[27,342,"Stores Equipment",0,0,0,0,27]
[28,343,"Tools, Shop & Garage Equipment",0,0,0,0,28]
[29,344,"Laboratory Equipment",0,0,0,0,29]
[30,345,"Power Operated Equipment",0,0,0,0,30]
[31,346,"Communication Equipment",0,0,0,0,31]
[32,347,"Miscellaneous Equipment",0,0,0,0,32]
[33,348,"Other Tangible Plant",0,0,0,0,33]
[34,null,"     Total Water Plant",{"$f":"SUM(D14:D40)","v":0},{"$f":"SUM(E14:E40)","v":0},{"$f":"SUM(F14:F40)","v":0},{"$f":"SUM(G14:G40)","v":0},34]
[35,null,null,null,null,null,null,35]
[36,null,null,null,null,null,null,36]
[37,null,null,null,null,null,null,37]
[38,null,null,null,null,null,null,38]
[39,null,null,null,null,null,null,39]
[40,null,null,null,null,null,null,40]
[41,null,null,null,null,null,null,41]
[42,null,null,null,null,null,null,42]
[43,null,null,null,null,null,null,43]
[44,null,null,null,null,null,null,44]
[45,null,null,null,null,null,null,45]
[46,null,null,null,null,null,null,46]
[47,null,null,null,null,null,null,47]
[48,null,null,null,null,null,null,48]
[49,null,null,null,null,null,null,49]
[50,null,null,null,null,null,null,50]
[51,null,null,null,null,null,null,51]
[52,null,null,null,null,null,null,52]
[53,null,null,null,null,null,null,53]
[54,null,null,null,null,null,null,54]
[55,null,null,null,null,null,null,55]

{"sheet":"W-2","index":15,"n_rows":50,"n_cols":11,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["W-2",null,null,null,null,null,null,null,null,null,"W-2"]
[null,"Name of Respondent",null,null,null,null,"This Report is:",null,"Date of Report","Year of Report"]
[null,{"$f":"ENTRY!D2","v":"Your Company Name"},null,null,null,null,{"$f":"'W-3'!D6","v":"(1) _X_ An Original"},null,"(Mo, Da, Yr)"]
[null,"  ",null,null,null,null,{"$f":"'W-3'!D7","v":"(2) ___ A Resubmission"},null,{"$f":"ENTRY!D4","v":"Date report compiled"},{"$f":"ENTRY!D3","v":"Fiscal Year End Date"}]
[1,"ANALYSIS OF ACCUMULATED DEPRECIATION BY PRIMARY ACCOUNT - WATER",null,null,null,null,null,null,null,null,1]
[2,null,null,null,null,null,null,null,null,null,2]
[3,null,null,"Average","Average","Depreciation","Accumulated",null,null,"Accumulated",3]
[4,"Account",null,"Service Life","Salvage Value","Rate","Depreciation Balance",null,null,"Depreciation Balance",4]
[5,"Number","Account","in Years","in Percent","Applied","Previous Year","Debits","Credits","End of Year",5]
[6,"(a)","(b)","(c)","(d)","(e)","(f)","(g)","(h)","(i)",6]
[7,null,null,null,null,null,null,null,null,null,7]
[8,304,"Structures & Improvements",0,0,0,0,0,0,{"$f":"G15-H15+I15","v":0},8]
[9,305,"Collecting & Impounding Reservoirs",0,0,0,0,0,0,0,9]
[10,306,"Lake, River & Other Intakes",0,0,0,0,0,0,0,10]
[11,307,"Wells & Springs",0,0,0,0,0,0,0,11]
[12,308,"Infiltration Galleries & Tunnels",0,0,0,0,0,0,0,12]
[13,309,"Supply Mains",0,0,0,0,0,0,0,13]
[14,310,"Power Generating Equipment",0,0,0,0,0,0,0,14]
[15,311,"Pumping Equipment",0,0,0,0,0,0,0,15]
[16,320,"Water Treatment Equipment",0,0,0,0,0,0,0,16]
[17,330,"Distribution Reservoirs & Standpipes",0,0,0,0,0,0,0,17]
[18,331,"Transmission & Distribution Mains",0,0,0,0,0,0,0,18]
[19,333,"Services",0,0,0,0,0,0,0,19]
[20,334,"Meter & Meter Installations",0,0,0,0,0,0,0,20]
[21,335,"Hydrants",0,0,0,0,0,0,0,21]
[22,339,"Other Plant & Miscellaneous Equipment",0,0,0,0,0,0,0,22]
[23,340,"Office Furniture & Equipment",0,0,0,0,0,0,0,23]
[24,341,"Transportation Equipment",0,0,0,0,0,0,{"$f":"G31-H31+I31","v":0},24]
[25,342,"Stores Equipment",0,0,0,0,0,0,0,25]
[26,343,"Tools, Shop & Garage Equipment",0,0,0,0,0,0,0,26]
[27,344,"Laboratory Equipment",0,0,0,0,0,0,0,27]
[28,345,"Power Operated Equipment",0,0,0,0,0,0,0,28]
[29,346,"Communication Equipment",0,0,0,0,0,0,0,29]
[30,347,"Miscellaneous Equipment",0,0,0,0,0,0,0,30]
[31,348,"Other Tangible Plant",0,0,0,0,0,0,0,31]
[32,null,"     Totals",null,null,null,{"$f":"SUM(G15:G38)","v":0},{"$f":"SUM(H15:H38)","v":0},{"$f":"SUM(I15:I38)","v":0},{"$f":"SUM(J15:J38)","v":0},32]
[33,null,null,null,null,null,null,null,null,null,33]
[34,null,null,null,null,null,null,null,null,null,34]
[35,null,null,null,null,null,null,null,null,null,35]
[36,null,"*State basis used for percetages used in schedule.",null,null,null,null,null,null,null,36]
[37,null,null,null,null,null,null,null,null,null,37]
[38,null,null,null,null,null,null,null,null,null,38]
[39,null,null,null,null,null,null,null,null,null,39]
[40,null,null,null,null,null,null,null,null,null,40]
[41,null,null,null,null,null,null,null,null,null,41]
[42,null,null,null,null,null,null,null,null,null,42]
[43,null,null,null,null,null,null,null,null,null,43]

{"sheet":"W-3","index":16,"n_rows":62,"n_cols":8,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,"",null,null,null,null,"W-3"]
[null,"Name of Respondent",null,"This Report is:",null,"Date of Report","Year of Report"]
[null,{"$f":"ENTRY!D2","v":"Your Company Name"},null,{"$f":"'W-4'!D6","v":"(1) _X_ An Original"},null,"(Mo, Da, Yr)"]
[null,"  ",null,{"$f":"'W-4'!D7","v":"(2) ___ A Resubmission"},null,{"$f":"ENTRY!D4","v":"Date report compiled"},{"$f":"ENTRY!D3","v":"Fiscal Year End Date"}]
[1,"WATER OPERATION & MAINTENANCE EXPENSE",null,null,null,null,null,1]
[2,null,null,null,null,null,null,2]
[3,null,null,null,null,null,null,3]
[4,"Acct",null,null,null,null,null,4]
[5,"No.","Description",null,null,null,"Amount",5]
[6,null,"(a)",null,null,null,"(b)",6]
[7,601,"Salaries & Wages - Employees",null,null,null,0,7]
[8,603,"Salaries & Wages - Officers, Directors & Stockholders",null,null,null,0,8]
[9,604,"Employee Pensions & Benefits",null,null,null,0,9]
[10,610,"Purchased Water",null,null,null,0,10]
[11,615,"Purchased Power",null,null,null,0,11]
[12,616,"Fuel for Power Production",null,null,null,0,12]
[13,618,"Chemicals",null,null,null,0,13]
[14,620,"Materials & Supplies",null,null,null,0,14]
[15,630,"Contractual Services",null,null,null,0,15]
[16,640,"Rents",null,null,null,0,16]
[17,650,"Transportation Expense",null,null,null,0,17]
[18,655,"Insurance Expense",null,null,null,0,18]
[19,665,"Regulatory Commission Expense",null,null,null,0,19]
[20,670,"Bad Debt Expense",null,null,null,0,20]
[21,672,"Miscellaneous Expenses",null,null,null,0,21]
[22,null,"     Total Water Operation & Maintenance Expense",null,null,null,{"$f":"SUM(G14:G28)","v":0},22]
[23,null,null,null,null,null,null,23]
[24,null,null,null,null,null,null,24]
[25,null,null,null,null,null,null,25]
[26,null,null,null,null,null,null,26]
[27,null,null,null,null,null,null,27]
[28,null,null,null,null,null,null,28]
[29,"WATER CUSTOMERS",null,null,null,null,null,29]
[30,null,null,null,null,null,null,30]
[31,null,null,"Customers",null,null,"Customers",31]
[32,"Description",null,"First of Year","Additions","Disconnections","End of Year",32]
[33,"(a)",null,"(b)","(c)","(d)","(e)",33]
[34,"Metered Customers:",null,null,null,null,null,34]
[35,null,"5/8 Inch",0,0,0,{"$f":"D42+E42-F42","v":0},35]
[36,null,"3/4 Inch",0,0,0,0,36]
[37,null,"1.0 Inch",0,0,0,0,37]
[38,null,"1.5 Inch",0,0,0,0,38]
[39,null,"2.0 Inch",0,0,0,0,39]
[40,null,"2.5 Inch",0,0,0,0,40]
[41,null,"3.0 Inch",0,0,0,0,41]
[42,null,"4.0 Inch",0,0,0,0,42]
[43,null,"6.0 Inch",0,0,0,0,43]
[44,null,"8.0 Inch",0,0,0,0,44]
[45,null,"Other (Please Specify)",0,0,0,0,45]
[46,null,"Other (Please Specify)",0,0,0,0,46]
[47,null,"Other (Please Specify)",0,0,0,0,47]
[48,"Unmetered Customers",null,0,0,0,0,48]
[49,"Total Customers",null,{"$f":"SUM(D42:D55)","v":0},{"$f":"SUM(E42:E55)","v":0},{"$f":"SUM(F42:F55)","v":0},{"$f":"SUM(G42:G55)","v":0},49]
[50,null,null,null,null,null,null,50]
[51,null,null,null,null,null,null,51]
[52,null,null,null,null,null,null,52]
[53,null,null,null,null,null,null,53]
[54,null,null,null,null,null,null,54]
[55,null,null,null,null,null,null,55]

{"sheet":"W-4","index":17,"n_rows":64,"n_cols":8,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["W-4"]
[null,"Name of Respondent",null,"This Report is:",null,"Date of Report","Year of Report"]
[null,{"$f":"ENTRY!D2","v":"Your Company Name"},null,{"$f":"'W-5'!D6","v":"(1) _X_ An Original"},null,"(Mo, Da, Yr)"]
[null,"  ",null,{"$f":"'W-5'!D7","v":"(2) ___ A Resubmission"},null,{"$f":"ENTRY!D4","v":"Date report compiled"},{"$f":"ENTRY!D3","v":"Fiscal Year End Date"}]
[1,"PUMPING AND PURCHASED WATER STATISTICS",null,null,null,null,null,1]
[2,null,null,null,null,null,null,2]
[3,null,null,null,null,null,null,3]
[4,null,null,"Water","Water","Total Water","Water Sold",4]
[5,null,null,"Purchased for","Pumped from","Pumped and","To",5]
[6,"Description (1)",null,"Resale","Wells","Purchased","Customers",6]
[7,"(a)",null,"(b)","(c)","(d)","(e)",7]
[8,null,null,"in thousands","in thousands","in millions",null,8]
[9,"January",null,0,0,0,0,9]
[10,"February",null,0,0,0,0,10]
[11,"March",null,0,0,0,0,11]
[12,"April",null,0,0,0,0,12]
[13,"May",null,0,0,0,0,13]
[14,"June",null,0,0,0,0,14]
[15,"July",null,0,0,0,0,15]
[16,"August",null,0,0,0,0,16]
[17,"September",null,0,0,0,0,17]
[18,"October",null,0,0,0,0,18]
[19,"November",null,0,0,0,0,19]
[20,"December",null,0,0,0,0,20]
[21,"     Total for the Year",null,{"$f":"SUM(D16:D27)","v":0},{"$f":"SUM(E16:E27)","v":0},{"$f":"SUM(F16:F27)","v":0},{"$f":"ENTRY!C224","v":0},21]
[22," ",null,null,null,null,null,22]
[23,null,null,null,null,null,null,23]
[24,"SALES FOR RESALE",null,null,null,null,null,24]
[25,"Indicate below the identity of any utilities or vendors purchasing water for resale.",null,null,null,null,null,25]
[26,null,null,null,null,null,null,26]
[27,null,null,null,null,null,null,27]
[28,null,null,null,null,null,null,28]
[29,null,null,null,null,null,null,29]
[30,null,null,null,null,null,null,30]
[31,null,null,null,null,null,null,31]
[32,null,null,null,null,null,null,32]
[33,null,null,null,null,null,null,33]
[34,null,null,null,null,null,null,34]
[35,null,null,null,null,null,null,35]
[36,null,null,null,null,null,null,36]
[37,null,null,null,null,null,null,37]
[38,null,null,null,null,null,null,38]
[39,null,null,null,null,null,null,39]
[40,null,null,null,null,null,null,40]
[41,null,null,null,null,null,null,41]
[42,null,null,null,null,null,null,42]
[43,null,null,null,null,null,null,43]
[44,null,null,null,null,null,null,44]
[45,null,null,null,null,null,null,45]
[46,null,null,null,null,null,null,46]
[47,null,null,null,null,null,null,47]
[48,null,null,null,null,null,null,48]
[49,null,null,null,null,null,null,49]
[50,null,null,null,null,null,null,50]
[51,null,null,null,null,null,null,51]
[52,null,null,null,null,null,null,52]
[53,null,null,null,null,null,null,53]
[54,null,null,null,null,null,null,54]
[55,null,null,null,null,null,null,55]
[]
[null,"(1) Please state measurement of units sold (i. e. gallons)."]

{"sheet":"W-5","index":18,"n_rows":53,"n_cols":8,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,"",null,null,null,null,"W-5"]
[null,"Name of Respondent",null,"This Report is:",null,"Date of Report","Year of Report"]
[null,{"$f":"ENTRY!D2","v":"Your Company Name"},null,{"$f":"'W-6'!D6","v":"(1) _X_ An Original"},null,"(Mo, Da, Yr)"]
[null,"  ",null,{"$f":"'W-6'!D7","v":"(2) ___ A Resubmission"},null,{"$f":"ENTRY!D4","v":"Date report compiled"},{"$f":"ENTRY!D3","v":"Fiscal Year End Date"}]
[1,"WELLS AND WELL PUMPS",null,null,null,null,null,1]
[2,null,null,null,null,null,null,2]
[3,null,null,null,null,null,null,3]
[4,"Description***",null,"Well #1","Well #2","Well #3","Well #4",4]
[5,"(a)",null,"(b)","(c)","(d)","(e)",5]
[6,null,null,null,null,null,null,6]
[7,"Year Constructed",null,null,null,null,null,7]
[8,"Type of Well Construction",null,null,null,null,null,8]
[9,"Type of Well Casing",null,null,null,null,null,9]
[10,"Depth of Well (Feet)",null,null,null,null,null,10]
[11,"Diameter of Well (Feet",null,null,null,null,null,11]
[12,"Pumping Capacity (GPM)",null,null,null,null,null,12]
[13,"Motor Size (HP)",null,null,null,null,null,13]
[14,"Yields of Well (GPD)",null,null,null,null,null,14]
[15,"Auxilary Power",null,null,null,null,null,15]
[16,null,null,null,null,null,null,16]
[17,"RESERVOIRS",null,null,null,null,null,17]
[18,null,null,null,null,null,null,18]
[19,null,null,null,null,null,null,19]
[20,"Description***",null,"Reservoir #1","Reservoir #2","Reservoir #3","Reservoir #4",20]
[21,"(a)",null,"(b)","(c)","(d)","(e)",21]
[22,null,null,null,null,null,null,22]
[23,"Construction (Steel, Concrete, Pneumatic)",null,null,null,null,null,23]
[24,"Capacity (Gallons)",null,null,null,null,null,24]
[25,"Ground or Elevated",null,null,null,null,null,25]
[26,null,null,null,null,null,null,26]
[27,"HIGH SERVICE PUMPING",null,null,null,null,null,27]
[28,null,null,null,null,null,null,28]
[29,null,null,null,null,null,null,29]
[30,"Motor Description***",null,"Motor #1","Motor #2","Motor #3","Motor #4",30]
[31,"(a)",null,"(b)","(c)","(d)","(e)",31]
[32,null,null,null,null,null,null,32]
[33,"Manufacturer",null,null,null,null,null,33]
[34,"Type",null,null,null,null,null,34]
[35,"Rated Horsepower",null,null,null,null,null,35]
[36,null,null,null,null,null,null,36]
[37,"Pump Description***",null,"Pump #1","Pump #2","Pump #3","Pump #4",37]
[38,"(a)",null,"(b)","(c)","(d)","(e)",38]
[39,null,null,null,null,null,null,39]
[40,"Manufacturer",null,null,null,null,null,40]
[41,"Type",null,null,null,null,null,41]
[42,"Capacity in Gallons per Minute",null,null,null,null,null,42]
[43,"Average Number of Hours Operated Per Day",null,null,null,null,null,43]
[44,"Auxilary Power",null,null,null,null,null,44]
[]
[null,"***If more space is needed to list equipment please attach additional sheets as necessary. "]

{"sheet":"W-6","index":19,"n_rows":62,"n_cols":8,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,null,null,null,"W-6"]
[null,"Name of Respondent",null,"This Report is:",null,"Date of Report","Year of Report"]
[null,{"$f":"ENTRY!D2","v":"Your Company Name"},null,"(1) _X_ An Original",null,"(Mo, Da, Yr)"]
[null,"  ",null,"(2) ___ A Resubmission",null,{"$f":"ENTRY!D4","v":"Date report compiled"},{"$f":"ENTRY!D3","v":"Fiscal Year End Date"}]
[1,null,null,null,null,null,null,1]
[2,"SOURCE OF SUPPLY",null,null,null,null,null,2]
[3,"List for each source of supply:",null,null,null,null,null,3]
[4,null,null,null,null,null,null,4]
[5,null,null,"Source","Source","Source","Source",5]
[6,"Description",null,"#1","#2","#3","#4",6]
[7,null,null,null,null,null,null,7]
[8,null,null,null,null,null,null,8]
[9,"Gallons per day of source",null,null,null,null,null,9]
[10,null,null,null,null,null,null,10]
[11,"Type of Source",null,null,null,null,null,11]
[12,null,null,null,null,null,null,12]
[13,null,null,null,null,null,null,13]
[14,"WATER TREATMENT FACILITIES",null,null,null,null,null,14]
[15,"List for each water treatment facility:",null,null,null,null,null,15]
[16,null,null,null,null,null,null,16]
[17,null,null,"Facility","Facility","Facility","Facility",17]
[18,"Description",null,"#1","#2","#3","#4",18]
[19,null,null,null,null,null,null,19]
[20,null,null,null,null,null,null,20]
[21,"Type",null,null,null,null,null,21]
[22,null,null,null,null,null,null,22]
[23,"Make",null,null,null,null,null,23]
[24,null,null,null,null,null,null,24]
[25,"Gallons per day capacity",null,null,null,null,null,25]
[26,null,null,null,null,null,null,26]
[27,"Method of Measurement",null,null,null,null,null,27]
[28,null,null,null,null,null,null,28]
[29,null,null,null,null,null,null,29]
[30,"OTHER WATER SYSTEM INFORMATION",null,null,null,null,null,30]
[31,"Furnish information below for each system not physically connected with another facility.",null,null,null,null,null,31]
[32,null,null,null,null,null,null,32]
[33,"Present Equivalent Residential Customer's * now being served",null,null,null,null,null,33]
[34,"Maximum Equivalent Residential Customer's * that the system can efficiently serve",null,null,null,null,null,34]
[35,"Estimated annual increase in Equivalent Residential Customers *",null,null,null,null,null,35]
[36,null,null,null,null,null,null,36]
[37,"*  Equivalent Residential Customer= (Total Gallons Sold / 365 days) / 350 Gallons Per Day",null,null,null,null,null,37]
[38,null,null,null,null,null,null,38]
[39,"List fire fighting facilities and capacities:",null,null,null,null,null,39]
[40,null,null,null,null,null,null,40]
[41,null,null,null,null,null,null,41]
[42,null,null,null,null,null,null,42]
[43,"List percent of certificated area where service connections are installed",null,null,null,null,null,43]
[44,null,null,null,null,null,null,44]
[45,null,null,null,null,null,null,45]
[46,null,null,null,null,null,null,46]
[47,"What are the current needs and plans for system upgrading and/or expansion",null,null,null,null,null,47]
[48,null,null,null,null,null,null,48]
[49,null,null,null,null,null,null,49]
[50,null,null,null,null,null,null,50]
[51,"State the name and address of any engineers that plans for system upgrading and/or expansion have been",null,null,null,null,null,51]
[52,"discussed with",null,null,null,null,null,52]
[53,null,null,null,null,null,null,53]
[54,null,null,null,null,null,null,54]
[55,null,null,null,null,null,null,55]

{"sheet":"RATEOFRETURN","index":20,"n_rows":63,"n_cols":8,"rows_kept":63,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,"",null,null,null,null,"SU-1"]
[null,"Name of Respondent",null,"This Report is:",null,"Date of Report","Year of Report"]
[null,{"$f":"ENTRY!D2","v":"Your Company Name"},null,{"$f":"'F-2'!F3","v":"(1) _X_ An Original"},null,"(Mo, Da, Yr)"]
[null,"  ",null,{"$f":"'F-2'!F4","v":"(2) ___ A Resubmission"},null,{"$f":"ENTRY!D4","v":"Date report compiled"},{"$f":"ENTRY!D3","v":"Fiscal Year End Date"}]
[1,"SUPPLEMENTAL FINANCIAL DATA TO THE ANNUAL REPORT",null,null,null,null,null,1]
[2,"Rate Base"]
[3,"Additions:",null,null,null,null,null,3]
[4,null,"Plant In Service",null,null,null,null,4]
[5,null,"Construction Work in Progress",null,null,null,null,5]
[6,null,"Property Held For Future Use",null,null,null,null,6]
[7,null,"Materials & Supplies",null,null,null,null,7]
[8,null,"Working Capital Allowance",null,null,null,null,8]
[9,null,"Other Additions - Common Plant Alloc from Parent Company",null,null,null,null,9]
[10,null,"Other Additions (Please Specify)",null,null,null,null,10]
[11,null,"     Total Additions to Rate Base",null,null,null,{"$f":"SUM(G11:G17)","v":0},11]
[12,null,null,null,null,null,null,12]
[13,null,null,null,null,null,null,13]
[14,"Deductions:",null,null,null,null,null,14]
[15,null,"Accumulated Depreciation",null,null,null,null,15]
[16,null,"Accumulated Deferred Income Taxes",null,null,null,null,16]
[17,null,"Pre 1971 Unamortized Investment Tax Credit",null,null,null,null,17]
[18,null,"Customer Deposits",null,null,null,null,18]
[19,null,"Contributions in Aid of Construction",null,null,null,null,19]
[20,null,"Other Deductions (Please Specify)",null,null,null,null,20]
[21,null,"Other Deductions (Please Specify)",null,null,null,null,21]
[22,null,"     Total Deductions to Rate Base",null,null,null,{"$f":"SUM(G22:G28)","v":0},22]
[23,null,null,null,null,null,null,23]
[24,null,null,null,null,null,null,24]
[25,"Rate Base",null,null,null,null,{"$f":"G18-G29","v":0},25]
[26,null,null,null,null,null,null,26]
[27,"Adjusted Net Operating Income",null,null,null,null,null,27]
[28,"Operating Revenues:",null,null,null,null,null,28]
[29,null,"Residential",null,null,null,null,29]
[30,null,"Commercial",null,null,null,null,30]
[31,null,"Industrial",null,null,null,null,31]
[32,null,"Public Authorities",null,null,null,null,32]
[33,null,"Multiple Family",null,null,null,null,33]
[34,null,"Fire Protection",null,null,null,null,34]
[35,null,"All Other",null,null,null,null,35]
[36,null,"     Total Operating Revenues",null,null,null,{"$f":"SUM(G36:G42)","v":0},36]
[37,null,null,null,null,null,null,37]
[38,"Operating Expenses:",null,null,null,null,null,38]
[39,null,"Operation",null,null,null,null,39]
[40,null,"Depreciation",null,null,null,null,40]
[41,null,"Amortization",null,null,null,null,41]
[42,null,"Taxes Other Than Income Taxes",null,null,null,null,42]
[43,null,"Income Taxes",null,null,null,null,43]
[44,null,"     Total Operating Expense",null,null,null,{"$f":"SUM(G46:G50)","v":0},44]
[45,null,null,null,null,null,null,45]
[46,"Net Operating Income",null,null,null,null,{"$f":"G43-G51","v":0},46]
[47,null,"Other (Please Specify)",null,null,null,null,47]
[48,null,"Other (Please Specify)",null,null,null,null,48]
[49,"Adjusted Net Operating Income",null,null,null,null,{"$f":"G53-G54+G55","v":0},49]
[50,null,null,null,null,null,null,50]
[51,"Rate of Return (Line 49 / Line 25)",null,null,null,null,{"$f":"IF(G32=0,0,G56/G32)","v":0},51]
[52,null,null,null,null,null,null,52]
[53,null,null,null,null,null,null,53]
[54,null,null,null,null,null,null,54]
[55,"All amounts should be calculated in a manner consistent with the last Rate Order issued by the",null,null,null,null,null,55]
[null,"Commission for this Company."]

{"sheet":"ENTRY","index":21,"n_rows":185,"n_cols":10,"rows_kept":185,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Company Name:","Your Company Name"]
[null,null,"Report Period:","Fiscal Year End Date"]
[null,null,"Report Date:","Date report compiled"]
[]
[]
[]
[]
[null,null,null,null,null,"Amount for",null,"Amount for"]
[null,null,null,null,null,"1st",null,"2nd"]
["INCOME STATEMENT:",null,null,null,null,"Reference",null,"Reference",null,"Difference"]
[]
[]
["1.  Line 20 on F3, Col. \"C\" agrees w/line 22on W3, Col. \"B\"",null,null,null,null,{"$f":"'F-3'!D27","v":0},null,{"$f":"'W-3'!G29","v":0},null,{"$f":"+F14-H14","v":0}]
[]
["2.  Line 20 on F3, Col. \"D\" agrees w/line 23on S3, Col. \"B\"",null,null,null,null,{"$f":"'F-3'!E27","v":0},null,{"$f":"'S-3'!G30","v":0},null,{"$f":"+F16-H16","v":0}]
[]
["3.  Line 21 on F3, Col. \"F\" agrees w/line 39 on F5, col. \"F\"",null,null,null,null,{"$f":"'F-3'!G28","v":0},null,{"$f":"'F-5'!G46","v":0},null,{"$f":"+F18-H18","v":0}]
[]
["4.  Line 21 on F3, col. \"C\" agrees w/line 32 on W2, col. \"H\"",null,null,null,null,{"$f":"'F-3'!D28","v":0},null,{"$f":"'W-2'!I39","v":0},null,{"$f":"+F20-H20","v":0}]
[]
["5.  Line 21 on F3, col. \"D\" agrees w'line 30 on S2, col. \"H\"",null,null,null,null,{"$f":"'F-3'!D28","v":0},null,{"$f":"'S-2'!I37","v":0},null,{"$f":"+F22-H22","v":0}]
[]
["7.  Line 25 on F3 col. \"F\" agrees w/lines 22-28 minus line 7 on F7, col. \"E\"",null,null,null,null,{"$f":"'F-3'!G32","v":0},null,{"$f":"SUM('F-7'!G29:G35)-'F-7'!G14","v":0},null,{"$f":"+F24-H24","v":0}]
[]
["8.  Line 26 on F3, col. \"F\" agrees w/line 10 on F7, col. \"E\"",null,null,null,null,{"$f":"'F-3'!G33","v":0},null,{"$f":"'F-7'!G17","v":0},null,{"$f":"+F26-H26","v":0}]
[]
["9.  Line 26 on F3, col. \"F\" agrees w/line 21 on F7, col. \"E\"",null,null,null,null,{"$f":"'F-3'!G33","v":0},null,{"$f":"'F-7'!G28","v":0},null,{"$f":"+F28-H28","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,"Amount for",null,"Amount for"]
[null,null,null,null,null,"1st",null,"2nd"]
["BALANCE SHEET:",null,null,null,null,"Reference",null,"Reference",null,"Difference"]
[]
[]
["1.  Line 10 on F4, col. \"C\" agrees w/line 16 on F5, col. \"F\".",null,null,null,null,{"$f":"'F-4'!F17","v":0},null,{"$f":"'F-5'!G23","v":0},null,{"$f":"+F38-H38","v":0}]
[]
["2.  Line 10 on F4, col. \"C\" agrees w/lines 34, W1, col. \"F\" & 32, S1, col. \"F\".",null,null,null,null,{"$f":"'F-4'!F17","v":0},null,{"$f":"SUM('S-1'!G39,'W-1'!G41)","v":0},null,{"$f":"+F40-H40","v":0}]
[]
["3.  Line 11 on F4, col. \"C\" agrees w/line 52 on F5, col. \"F\".",null,null,null,null,{"$f":"'F-4'!F18","v":0},null,{"$f":"'F-5'!G59","v":0},null,0]
[]
["4.  Line 11 on F4, col. \"C\" agrees w/lines 32, W2, col. I & 30, S2, col. I",null,null,null,null,{"$f":"'F-4'!F18","v":0},null,{"$f":"SUM('S-2'!J37,'W-2'!J39)","v":0},null,0]
[]
["5.  Line 27 on F4, col. \"C\" agrees w/line 10 on F6, col. \"B\".",null,null,null,null,{"$f":"'F-4'!F34","v":0},null,{"$f":"'F-6'!F17","v":0},null,0]
[]
["6.  Line 28 on F4, col. \"C\" agrees w/line 10 on F6, col. \"C\".",null,null,null,null,{"$f":"'F-4'!F35","v":0},null,{"$f":"'F-6'!G17","v":0},null,0]
[]
["7. Line 30 on F4, col. \"C\" agrees w/line 24 on F6, cols. \"B\" & \"C\".",null,null,null,null,{"$f":"'F-4'!F37","v":0},null,{"$f":"SUM('F-6'!F31:G31)","v":0},null,0]
[]
["8. Line 31 on F4, col. \"C\" agrees w/line 37 on F6, cols. \"B\" & \"C\".",null,null,null,null,{"$f":"'F-4'!F38","v":0},null,{"$f":"SUM('F-6'!F44:G44)","v":0},null,0]
[]
["9. Line 37 on F4, col. \"C\" agrees w/line 55 on F6, col. \"C\".",null,null,null,null,{"$f":"'F-4'!F44","v":0},null,{"$f":"'F-6'!G62","v":0},null,0]
[]
["10. Line 41 on F4, col. \"C\" agrees w/line 32 on F7, col. \"E\".",null,null,null,null,{"$f":"'F-4'!F48","v":0},null,{"$f":"'F-7'!G39","v":0},null,0]
[]
["11. Line 48 on F4, col. \"C\" agrees w/line 13 on F8, col. \"D\".",null,null,null,null,{"$f":"'F-4'!F55","v":0},null,{"$f":"'F-8'!G20","v":0},null,0]
[]
["12. Line 8 on F8, col. \"D\" agrees w/line 55 on F8, cols. \"C & D\".",null,null,null,null,{"$f":"'F-8'!G15","v":0},null,{"$f":"SUM('F-8'!F62:G62)","v":0},null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Rev signs-200 accts!"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"D86+D87+D88+D89","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Rev signs-400 accts!"]
[]
[]
[null,null,null,null,null,null,{"$f":"D121+D122+D123+D124","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"SUM(D125:D149)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"D150+D151+D152+D153+D154+D155+D156+D157+D158","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"D159+D160+D161+D162+D163+D164+D165+D166+D167+D168","v":0}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"D169+D170+D171+D173+D174","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"D175+D176+D177+D178+D179","v":0}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"D180+D181+D182+D183+D184+D185","v":0}]