{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["WTR-Cover","WTR-Form A","WTR-Form B","WTR-Form C","WTR-Form D","WTR-Form E","WTR-Form F","WTR-Form G","WTR-Form H","WTR-Form I"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":18,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"WTR-Cover","index":0,"n_rows":36,"n_cols":2,"rows_kept":36,"cut":false,"hidden":false,"merged":[[34,1,34,9],[35,1,35,9],[33,1,33,9],[3,1,3,9],[1,1,1,9],[6,1,6,9],[7,1,7,9],[2,1,2,9],[4,1,4,9],[31,1,31,9]]}
[]
[null,"Public Utilities Commission of Nevada"]
[null,"Simplified Rate Change Application"]
[null,"For an Increase in WATER Rates"]
[null,"Class A or B Water Utility"]
[]
[]
[null,"(Please enter legal name of utility above)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Using Simplified Procedures Pursuant to NRS 704.095 and NAC 704.570 to 704.628"]
[]
[null,"Public Utilities Commission of Nevada"]
[null,"Class A or B Water Utility"]
[null,{"$f":"IF(B7=0,\"\",B7)","v":""}]

{"sheet":"WTR-Form A","index":1,"n_rows":105,"n_cols":9,"rows_kept":105,"cut":false,"hidden":false,"merged":[[110,1,110,8],[108,1,108,8],[107,1,107,8],[105,1,105,8],[106,1,106,8],[109,1,109,8],[66,1,66,4],[64,1,64,4],[36,6,36,9],[0,0,0,9],[2,0,2,9],[43,1,43,4],[40,1,40,4],[41,1,41,4],[30,1,30,4],[32,1,32,4],[34,1,34,4],[7,0,7,9],[10,1,10,4],[42,1,42,4],[1,0,1,9],[12,1,12,4],[18,1,18,2],[20,1,20,2],[16,1,16,4],[20,6,20,7],[99,1,99,2],[88,6,88,7],[82,1,82,4],[84,1,84,4],[68,6,68,7],[76,1,76,2],[72,1,72,4],[74,1,74,4],[68,1,68,2],[62,1,62,4],[32,6,32,9],[34,6,34,9],[101,6,101,7],[101,1,101,2],[95,1,95,4],[97,1,97,4],[78,1,78,2],[78,6,78,7],[88,1,88,2],[86,1,86,2],[46,1,46,2],[24,1,24,4],[26,1,26,2],[58,6,58,7],[58,1,58,2],[30,6,30,9],[56,1,56,2],[36,1,36,4],[52,1,52,4],[54,1,54,4]]}
["Public Utilities Commission of Nevada"]
["Class A or B Water Utility"]
[{"$f":"IF(B11=0,\"\",B11)","v":""}]
[null,null,null,null,null,"Test Year Ending: "]
[null,null,null,null,null,"Certification Period Ending:"]
[]
[]
["COMPANY INFORMATION"]
["                                                                                                                                          "]
["1)","Applicant:"]
[]
["                                                                                                                                          ","(Legal Name)",null,null,null,null,"(CPC No.)"]
[]
[null,"(Utility Name - If different from above.)"]
["                                                                                                                                          "]
["2)","Business Address:"]
[]
["                                                                                                                                          ","(Physical Address)"]
[]
["                                                                                                                                          ","(City or Town)",null,null,null,null,"(State)",null,"(Zip Code)"]
[]
["                                                                                                                                          ","(Business Phone)",null,null,null,null,"(Emergency Phone)"]
[]
["3)","Mailing Address:"]
[]
["                                                                                                                                          ","(Address)"]
[]
["                                                                                                                                          ","(City or Town)",null,null,null,null,"(State)",null,"(Zip Code)"]
["                                                                                                                                          "]
["4)","Corporate Information:"]
[]
[null,"(President)",null,null,null,null,"(State of Incorporation)"]
[]
[null,"(Vice President)",null,null,null,null,"(Year of Incorporation)"]
[]
[null,"(Secretary)",null,null,null,null,"(Other)"]
[]
[null,"(Treasurer)",null,null,null,null,"(Other)"]
["                                                                                                                                          "]
["5)","List shareholders holding 2% or more of outstanding stock:     %     "]
[]
[]
[]
[]
[]
["6)","Type of federal income tax return filed:"]
[]
[]
[]
[]
[]
["7)","President and General/Operations Manager:"]
[]
[null,"(Name)"]
[]
[null,"(Address)"]
[]
[null,"(City or Town)",null,null,null,null,"(State)",null,"(Zip Code)"]
[]
[null,"(Business Phone)",null,null,null,null,"(Emergency Phone)"]
[]
["8)","Customer Service (Complaints, Billings, etc.):"]
[]
[null,"(Name)"]
[]
[null,"(Address)"]
[]
[null,"(City or Town)",null,null,null,null,"(State)",null,"(Zip Code)"]
[]
[null,"(Business Phone)",null,null,null,null,"(Emergency Phone)"]
[]
["9)","Operations/Engineering:"]
[]
[null,"(Name)"]
[]
[null,"(Address)"]
[]
[null,"(City or Town)",null,null,null,null,"(State)",null,"(Zip Code)"]
[]
[null,"(Business Phone)",null,null,null,null,"(Emergency Phone)"]
[]
["10)","Emergency Service:"]
[]
[null,"(Name)"]
[]
[null,"(Address)"]
[]
[null,"(City or Town)",null,null,null,null,"(State)",null,"(Zip Code)"]
[]
[null,"(Business Phone)",null,null,null,null,"(Emergency Phone)"]
[]
[]
[]
[]
["11)","Accounting/Rate Application:"]
[]
[null,"(Name)"]
[]
[null,"(Address)"]
[]
[null,"(City or Town)",null,null,null,null,"(State)",null,"(Zip Code)"]
[]
[null,"(Business Phone)",null,null,null,null,"(Emergency Phone)"]
["                                                                                                                                          "]
["12)","Reasons for rate increase:"]

{"sheet":"WTR-Form B","index":2,"n_rows":124,"n_cols":11,"rows_kept":124,"cut":false,"hidden":false,"merged":[[41,3,41,8],[85,3,85,8],[121,3,121,8],[6,0,6,10],[0,0,0,10],[2,0,2,10],[1,0,1,10]]}
["Public Utilities Commission of Nevada"]
["Class A or B Water Utility"]
[{"$f":"IF('WTR-Cover'!B7=0,\"\",'WTR-Cover'!B7)","v":""}]
[null,null,null,null,"Test Year Ending:",null,{"$f":"IF('WTR-Form A'!G4=0,\"\",'WTR-Form A'!G4)","v":""}]
[null,null,null,null,"Certification Period Ending:",null,{"$f":"IF('WTR-Form A'!G5=0,\"\",'WTR-Form A'!G5)","v":""}]
[]
["TARIFF RATE SCHEDULES -EXISTING AND PROPOSED WATER RATES"]
[null,null,null,null,null,null,"Existing",null,"Proposed",null,"Proposed"]
["Line",null,null,null,null,null,"Tariff",null,"Increase",null,"Tariff"]
["No.",null,"Type",null,"Size",null,"Rate (1)",null,"(% Calculated)",null,"Rate (2)"]
[null,null,"(a)",null,"(b)",null,"(c)",null,"(d)",null,"(e)"]
[]
[1,"Unmetered Rates (monthly): *"]
[{"$f":"+A13+1","v":2},null,"Residential",null,"All",null,null,null,{"$f":"IF(G14=0,\"\",(K14-G14)/G14)","v":""}]
[{"$f":"+A14+1","v":3},null,"Commercial",null,"All",null,null,null,""]
[{"$f":"+A15+1","v":4},null,"Irrigation",null,"All",null,null,null,""]
[{"$f":"+A16+1","v":5},null,"Public Authorities",null,"All",null,null,null,""]
[{"$f":"+A17+1","v":6},null,null,null,null,null,null,null,""]
[{"$f":"+A18+1","v":7},null,null,null,null,null,null,null,""]
[8,null,null,null,null,null,null,null,""]
[9]
[10,"Metered Rates (monthly): *"]
[11,null,"Residential",null,null,null,null,null,{"$f":"IF(G23=0,\"\",(K23-G23)/G23)","v":""}]
[12,null,"Basic/Fixed Service Charge",null,"1/2\"",null,null,null,""]
[13,null,"     \"        \"",null,"5/8\"",null,null,null,""]
[14,null,"     \"        \"",null,"3/4\"",null,null,null,""]
[15,null,"     \"        \"",null,"1\"",null,null,null,""]
[16,null,"     \"        \"",null,"1 ½\"",null,null,null,""]
[17,null,null,null,null,null,null,null,""]
[18,null,"Commodity Rate (3)",null,"1/2\"",null,null,null,{"$f":"IF(G30=0,\"\",(K30-G30)/G30)","v":""}]
[19,null,"     \"        \"",null,"5/8\"",null,null,null,""]
[20,null,"     \"        \"",null,"3/4\"",null,null,null,""]
[21,null,"     \"        \"",null,"1\"",null,null,null,""]
[22,null,"     \"        \"",null,"1 ½\"",null,null,null,""]
[23,null,null,null,null,null,null,null,""]
[24,null,null,null,null,null,null,null,""]
[25,null,null,null,null,null,null,null,""]
[26]
[27,"Notes:"]
[28,"(1)","Rates currently in effect.",null,null,null,null,null,{"$f":"IF(G40=0,\"\",(K40-G40)/G40)","v":""}]
[29,"(2)","Rates the Utility is proposing if granted by the Commission in this Simplified Rate Change Application."]
[30,"(3)","Specify the unit of measure :"]
[31,"*","Insert additional rows and explanations as necessary. Please contact Commission Staff at the number"]
[32,null,"listed in the Instructions section of this application for assistance."]
[]
[]
[{"$f":"A44+1","v":33},"Commercial/Industrial/"]
[34,"Public Authority:  *",null,null,null,null,null,null,{"$f":"IF(G48=0,\"\",(K48-G48)/G48)","v":""}]
[35,null,"Basic/Fixed Service Charge",null,"1/2\"",null,null,null,""]
[36,null,"     \"        \"",null,"5/8\"",null,null,null,""]
[37,null,"     \"        \"",null,"3/4\"",null,null,null,""]
[38,null,"     \"        \"",null,"1\"",null,null,null,""]
[39,null,"     \"        \"",null,"1 ½\"",null,null,null,""]
[40,null,"     \"        \"",null,"2\"",null,null,null,""]
[41,null,"     \"        \"",null,"3\"",null,null,null,""]
[42,null,"     \"        \"",null,"4\"",null,null,null,""]
[43,null,"     \"        \"",null,"6\"",null,null,null,""]
[44]
[45,null,"Commodity Rate (3)",null,"1/2\"",null,null,null,""]
[46,null,"     \"        \"",null,"5/8\"",null,null,null,""]
[47,null,"     \"        \"",null,"3/4\"",null,null,null,""]
[48,null,"     \"        \"",null,"1\"",null,null,null,""]
[49,null,"     \"        \"",null,"1 ½\"",null,null,null,""]
[50,null,"     \"        \"",null,"2\"",null,null,null,""]
[51,null,"     \"        \"",null,"3\"",null,null,null,""]
[52,null,"     \"        \"",null,"4\"",null,null,null,""]
[53,null,"     \"        \"",null,"6\"",null,null,null,""]
[54,null,null,null,null,null,null,null,{"$f":"IF(G68=0,\"\",(K68-G68)/G68)","v":""}]
[55,null,null,null,null,null,null,null,{"$f":"IF(G69=0,\"\",(K69-G69)/G69)","v":""}]
[56,null,null,null,null,null,null,null,""]
[57]
[58,"Irrigation: *",null,null,null,null,null,null,{"$f":"IF(G72=0,\"\",(K72-G72)/G72)","v":""}]
[59,null,"Basic/Fixed Service Charge",null,"1/2\"",null,null,null,""]
[60,null,"     \"        \"",null,"5/8\"",null,null,null,""]
[61,null,"     \"        \"",null,"3/4\"",null,null,null,""]
[62,null,"     \"        \"",null,"1\"",null,null,null,""]
[63,null,"     \"        \"",null,"1 ½\"",null,null,null,""]
[64,null,"     \"        \"",null,"2\"",null,null,null,""]
[65,null,"     \"        \"",null,"3\"",null,null,null,""]
[66,null,"     \"        \"",null,"4\"",null,null,null,""]
[67,null,"     \"        \"",null,"6\"",null,null,null,""]
[68]
[69,"Notes:"]
[70,"(1)","Rates currently in effect.",null,null,null,null,null,{"$f":"IF(G84=0,\"\",(K84-G84)/G84)","v":""}]
[71,"(2)","Rates the Utility is proposing if granted by the Commission in this Simplified Rate Change Application."]
[72,"(3)","Specify the unit of measure :",{"$f":"IF(D42=0,\"\",D42)","v":""}]
[73,"*","Insert additional rows and explanations as necessary. Please contact Commission Staff at the number"]
[74,null,"listed in the Instructions section of this application for assistance."]
[null,null,null,null,null,null,null,null,{"$f":"IF(G89=0,\"\",(K89-G89)/G89)","v":""}]
[null,null,null,null,null,null,null,null,""]
[{"$f":"A88+1","v":75},"Irrigation: *",null,null,null,null,null,null,""]
[{"$f":"A91+1","v":76},null,"Commodity Rate (3)",null,"1/2\"",null,null,null,""]
[{"$f":"A92+1","v":77},null,"     \"        \"",null,"5/8\"",null,null,null,""]
[{"$f":"A93+1","v":78},null,"     \"        \"",null,"3/4\"",null,null,null,""]
[79,null,"     \"        \"",null,"1\"",null,null,null,""]
[80,null,"     \"        \"",null,"1 ½\"",null,null,null,""]
[81,null,"     \"        \"",null,"2\"",null,null,null,""]
[82,null,"     \"        \"",null,"3\"",null,null,null,""]
[83,null,"     \"        \"",null,"4\"",null,null,null,""]
[84,null,"     \"        \"",null,"6\"",null,null,null,""]
[85,null,null,null,null,null,null,null,""]
[{"$f":"A101+1","v":86},null,null,null,null,null,null,null,""]
[87,null,null,null,null,null,null,null,""]
[88]
[89,"Public/Private Fire Protection: *"]
[90,null,"Flat Rate",null,null,null,null,null,{"$f":"IF(G106=0,\"\",(K106-G106)/G106)","v":""}]
[91,null,"Metered:"]
[92,null,null,null,"inch",null,null,null,""]
[93,null,null,null,"inch",null,null,null,""]
[94]
[95,"Miscellaneous Rates: *"]
[96,null,"Returned Check Fee",null,null,null,null,null,""]
[97,null,"Application Fee",null,null,null,null,null,""]
[98,null,"Service Reconnect Fee",null,null,null,null,null,""]
[99,null,null,null,null,null,null,null,""]
[100,null,null,null,null,null,null,null,""]
[101,null,null,null,null,null,null,null,""]
[102]
[103,"Notes:"]
[104,"(1)","Rates currently in effect."]
[105,"(2)","Rates the Utility is proposing if granted by the Commission in this Simplified Rate Change Application."]
[106,"(3)","Specify the unit of measure :",{"$f":"IF(D42=0,\"\",D42)","v":""}]
[107,"*","Insert additional rows and explanations as necessary. Please contact Commission Staff at the number"]
[108,null,"listed in the Instructions section of this application for assistance."]

{"sheet":"WTR-Form C","index":3,"n_rows":81,"n_cols":17,"rows_kept":81,"cut":false,"hidden":false,"merged":[[2,0,2,13],[0,0,0,13],[1,0,1,13],[9,1,9,2]]}
["Public Utilities Commission of Nevada"]
["Class A or B Water Utility"]
[{"$f":"IF('WTR-Cover'!B7=0,\"\",'WTR-Cover'!B7)","v":""}]
[null,null,null,null,null,"Test Year Ending:",null,{"$f":"IF('WTR-Form A'!G4=0,\"\",'WTR-Form A'!G4)","v":""}]
[null,null,null,null,null,"Certification Period Ending:",null,{"$f":"IF('WTR-Form A'!G5=0,\"\",'WTR-Form A'!G5)","v":""}]
[]
["INCOME STATEMENT"]
[null,null,null,"NARUC",null,"Recorded",null,"Adjustments",null,"Adjusted",null,"Additional",null,"Total"]
["Line",null,null,"Account",null,"Test Year",null,"to Test Year",null,"Test Year",null,"Revenue",null,"Revenue"]
["No.","Description",null,"Numbers",null,"Balance",null,"Balances ",null,"Balance",null,"Required ",null,"Requirement"]
[null,null,"(a)","(b)",null,"(c)",null,"(d)",null,"(e)",null,"(f)",null,"(g)"]
[]
[1,"Operating Revenue: (From Form F)"]
[{"$f":"+A13+1","v":2},null,"Unmetered - Residential",460.1,null,{"$f":"'WTR-Form F'!F15","v":0},null,null,null,{"$f":"+F14+H14","v":0},null,null,null,{"$f":"J14+L14","v":0}]
[{"$f":"+A14+1","v":3},null,"Unmetered - Commercial",460.2,null,{"$f":"'WTR-Form F'!F16","v":0},null,null,null,{"$f":"+F15+H15","v":0},null,null,null,{"$f":"J15+L15","v":0}]
[4,null,"Unmetered - Industrial",460.3,null,{"$f":"'WTR-Form F'!F17","v":0},null,null,null,0,null,null,null,0]
[5,null,"Unmetered - Public Authority",460.4,null,{"$f":"'WTR-Form F'!F18","v":0},null,null,null,0,null,null,null,0]
[6,null,"Unmetered - Multi Family Dwellings",460.5,null,{"$f":"'WTR-Form F'!F19","v":0},null,null,null,{"$f":"+F18+H18","v":0},null,null,null,0]
[7,null,"Unmetered - Other",460.6,null,{"$f":"SUM('WTR-Form F'!F20:F21)","v":0},null,null,null,{"$f":"+F19+H19","v":0},null,null,null,{"$f":"J19+L19","v":0}]
[8,null,"Metered - Residential",461.1,null,{"$f":"'WTR-Form F'!F25","v":0},null,null,null,0,null,null,null,0]
[9,null,"Metered - Commercial",461.2,null,{"$f":"'WTR-Form F'!F26","v":0},null,null,null,0,null,null,null,0]
[10,null,"Metered - Industrial",461.3,null,{"$f":"'WTR-Form F'!F27","v":0},null,null,null,0,null,null,null,0]
[11,null,"Metered - Public Authority",461.4,null,{"$f":"'WTR-Form F'!F28","v":0},null,null,null,0,null,null,null,0]
[12,null,"Metered - Multi. Family Dwellings",461.5,null,{"$f":"'WTR-Form F'!F29","v":0},null,null,null,0,null,null,null,0]
[13,null,"Fire Protection ",462,null,{"$f":"'WTR-Form F'!F35","v":0},null,null,null,0,null,null,null,0]
[14,null,"Other Sales to Public Authorities",464,null,{"$f":"'WTR-Form F'!F36","v":0},null,null,null,0,null,null,null,0]
[15,null,"Irrigation ",465,null,{"$f":"'WTR-Form F'!F37","v":0},null,null,null,0,null,null,null,0]
[16,null,"Sales for Resale",466,null,{"$f":"'WTR-Form F'!F38","v":0},null,null,null,0,null,null,null,0]
[17,null,"Interdepartmental ",467,null,{"$f":"'WTR-Form F'!F39","v":0},null,null,null,0,null,null,null,0]
[18,null,"Guaranteed ",469,null,{"$f":"'WTR-Form F'!F40","v":0},null,null,null,0,null,null,null,0]
[19,null,"Forfeited Discounts",470,null,{"$f":"'WTR-Form F'!F41","v":0},null,null,null,0,null,null,null,0]
[20,null,"Miscellaneous Service Revenues",471,null,{"$f":"'WTR-Form F'!F42","v":0},null,null,null,0,null,null,null,0]
[21,null,"Rents from Water Property ",472,null,{"$f":"'WTR-Form F'!F43","v":0},null,null,null,0,null,null,null,0]
[22,null,"Other Water ",474,null,{"$f":"'WTR-Form F'!F44+SUM('WTR-Form F'!F45:F46)+'WTR-Form F'!F30+'WTR-Form F'!F31","v":0},null,null,null,{"$f":"+F34+H34","v":0},null,null,null,0]
[23,null,"Total Operating Revenue",null,null,{"$f":"SUM(F14:F34)","v":0},null,{"$f":"SUM(H14:H34)","v":0},null,{"$f":"SUM(J14:J34)","v":0},null,{"$f":"SUM(L14:L34)","v":0},null,{"$f":"SUM(N14:N34)","v":0}]
[24,"Operating Expenses:"]
[25,null,"Salaries & Wages - Employees",601,null,null,null,null,null,{"$f":"+F37+H37","v":0},null,null,null,{"$f":"+J37+L37","v":0}]
[26,null,"Salaries & Wages - Officers, Dir.",603,null,null,null,null,null,{"$f":"+F38+H38","v":0},null,null,null,{"$f":"+J38+L38","v":0}]
[27,null,"Employee Pensions & Benefits",604,null,null,null,null,null,0,null,null,null,0]
[28,null,"Purchased Water",610,null,null,null,null,null,0,null,null,null,0]
[29,null,"Purchased Power",615,null,null,null,null,null,0,null,null,null,0]
[30,null,"Fuel for Power Production",616,null,null,null,null,null,0,null,null,null,0]
[31,null,"Chemicals",618,null,null,null,null,null,0,null,null,null,0]
[32,null,"Materials & Supplies",620,null,null,null,null,null,0,null,null,null,0]
[33,null,"Contractual Services - Engineering",631,null,null,null,null,null,0,null,null,null,0]
[34,null,"Contractual Services - Accounting",632,null,null,null,null,null,0,null,null,null,0]
[35,null,"Contractual Services - Legal",633,null,null,null,null,null,0,null,null,null,0]
[36,null,"Contractual Services - Management",634,null,null,null,null,null,0,null,null,null,0]
[37,null,"Contractual Services - Testing",635,null,null,null,null,null,0,null,null,null,0]
[38,null,"Contractual Services - Other",636,null,null,null,null,null,0,null,null,null,0]
[39,null,"Rents Building/Property",641,null,null,null,null,null,0,null,null,null,0]
[40,null,"Rents Equipment",642,null,null,null,null,null,0,null,null,null,0]
[41,null,"Transportation",650,null,null,null,null,null,0,null,null,null,0]
[42,null,"Insurance - Vehicle",656,null,null,null,null,null,0,null,null,null,0]
[43,null,"Insurance - Gen Liability",657,null,null,null,null,null,0,null,null,null,0]
[44,null,"Insurance - Workman's Comp.",658,null,null,null,null,null,0,null,null,null,0]
[45,null,"Insurance - Other",659,null,null,null,null,null,0,null,null,null,0]
[46,null,"Advertising",660,null,null,null,null,null,0,null,null,null,0]
[47,null,"Regulatory Commiss Exp. - Amort.",666,null,null,null,null,null,0,null,null,null,0]
[48,null,"Regulatory Commiss Exp. - Other",667,null,null,null,null,null,0,null,null,null,0]
[49,null,"Bad Debt ",670,null,null,null,null,null,0,null,null,null,0]
[50,null,"Miscellaneous ",675,null,null,null,null,null,0,null,null,null,0]
[51,null,"Depreciation",403,null,null,null,null,null,0,null,null,null,0]
[52,null,"Amort. Of Utility Plant Acq. Adj.",406,null,null,null,null,null,0,null,null,null,0]
[53,null,"Amortization",407,null,null,null,null,null,0,null,null,null,0]
[54,null,"Taxes Other Than Income",408,null,null,null,null,null,0,null,null,null,0]
[55,null,"Income Taxes",409,null,null,null,null,null,0,null,null,null,0]
[56,null,"Deferred Income Taxes - Debit",410,null,null,null,null,null,0,null,null,null,0]
[57,null,"Deferred Income Taxes - Credit",411,null,null,null,null,null,0,null,null,null,0]
[58,null,"Investment Tax Credit",412,null,null,null,null,null,0,null,null,null,0]
[59,null,"Gains/Losses - Disp. of Util. Property",414,null,null,null,null,null,0,null,null,null,0,"**","Adjustments  in Col (f)"]
[60,null,"Total Operating Expenses",null,null,{"$f":"SUM(F37:F71)","v":0},null,{"$f":"SUM(H37:H71)","v":0},null,{"$f":"SUM(J37:J71)","v":0},null,{"$f":"SUM(L37:L71)","v":0},null,{"$f":"SUM(N37:N71)","v":0},null,"need to be",{"$f":"(+N73-J73)-(L35-L72)","v":0}]
[61,null,"Net Operating Income",null,null,{"$f":"+F35-F72","v":0},null,{"$f":"+H35-H72","v":0},null,{"$f":"+J35-J72","v":0},null,{"$f":"IF(ROUND(L35-L72,0)=ROUND(N73-J73,0),N73-J73,\"   Error\")","v":0},null,{"$f":"ROUND(N76*N77,0)","v":0},null,"in the Revenue section"]
[62,null,null,null,null,null,null,null,null,null,null,"*",null,"**",null,"to make sheet balance."]
[63,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check total",{"$f":"+N35-N72","v":0}]
[{"$f":"+A75+1","v":64},null,"Rate Base [Form D, Line 23]",null,null,{"$f":"+'WTR-Form D'!F35","v":0},null,{"$f":"+'WTR-Form D'!H35","v":0},null,{"$f":"+F76+H76","v":0},null,0,null,{"$f":"+J76+L76","v":0}]
[65,null,"Rate of Return",null,null,{"$f":"IF(F76=0,\"\",(F73/F76))","v":""},null,null,null,{"$f":"IF(J76=0,\"\",(J73/J76))","v":""},null,null,null,{"$f":"+'WTR-Form E'!L40","v":0}]
[66,null,null,null,null,null,null,null,null,null,null,null,null,"[Form E, Line 28]"]
[67,"Notes:"]
[{"$f":"+A79+1","v":68},"*","Total of column MUST equal this figure."]
[{"$f":"+A80+1","v":69},"**","Allowed Net Income (Rate of Return times Rate Base)"]

{"sheet":"WTR-Form D","index":4,"n_rows":84,"n_cols":10,"rows_kept":84,"cut":false,"hidden":false,"merged":[[2,0,2,9],[0,0,0,9],[1,0,1,9]]}
["Public Utilities Commission of Nevada"]
["Class A or B Water Utility"]
[{"$f":"IF('WTR-Cover'!B7=0,\"\",'WTR-Cover'!B7)","v":""}]
[null,null,null,"Test Year Ending:",null,{"$f":"IF('WTR-Form A'!G4=0,\"\",'WTR-Form A'!G4)","v":""}]
[null,null,null,"Certification Period Ending:",null,{"$f":"IF('WTR-Form A'!G5=0,\"\",'WTR-Form A'!G5)","v":""}]
[]
["RATE BASE"]
[null,null,null,"NARUC",null,"Recorded",null,"Adjustments",null,"Adjusted"]
["Line",null,null,"Account",null,"Test Year",null,"to Test Year",null,"Test Year"]
["No.",null,"Description","Numbers",null,"Balance",null,"Balances",null,"Balance"]
[null,null,"(a)","(b)",null,"(c)",null,"(d)",null,"(e)"]
[]
[1,"Plant in Service:"]
[{"$f":"+A13+1","v":2},null,"Utility Plant in Service [Line 61 (c)] ",101,null,{"$f":"+F79","v":0},null,null,null,{"$f":"SUM(+F14+H14)","v":0}]
[{"$f":"+A14+1","v":3},null,"Accum. Depreciation  [Line 61 (d)]",108,null,{"$f":"-H79","v":0},null,null,null,{"$f":"SUM(+F15+H15)","v":0}]
[4,null,"Net Utility Plant in Service",null,null,{"$f":"SUM(F14:F15)","v":0},null,{"$f":"SUM(H14:H15)","v":0},null,{"$f":"SUM(J14:J15)","v":0}]
[5,null,"Add: (1)"]
[6,null,"Materials & Supplies",151,null,null,null,null,null,{"$f":"+F18+H18","v":0}]
[7,null,"Prepayments",162,null,null,null,null,null,0]
[8,null,"Misc. Deferred Debits",186,null,null,null,null,null,0]
[9,null,"Accum. Deferred Income Taxes",190,null,null,null,null,null,0]
[10,null,"Cash Working Capital",null,null,null,null,null,null,0]
[11,null,null,null,null,null,null,null,null,0]
[12,null,null,null,null,null,null,null,null,0]
[13,null,"Sub-Total",null,null,{"$f":"SUM(F18:F24)","v":0},null,{"$f":"SUM(H18:H24)","v":0},null,{"$f":"SUM(J18:J24)","v":0}]
[14,null,"Less: (1)"]
[15,null,"Taxes Other Than Income",236.11,null,null,null,null,null,{"$f":"+F27+H27","v":0}]
[16,null,"Advances for Construction",252,null,null,null,null,null,0]
[17,null,"Contribution in Aid of Construction (2)",271,null,{"$f":"J79","v":0},null,null,null,0]
[18,null,"Less:  Accum. Amortization of CIAC (3)",272,null,null,null,null,null,0]
[19,null,"Accum. Deferred Income Taxes",281,null,null,null,null,null,0]
[20,null,null,null,null,null,null,null,null,0]
[21,null,null,null,null,null,null,null,null,0]
[22,null,"Sub-Total",null,null,{"$f":"SUM(F27:F33)","v":0},{"$f":"SUM(G28:G33)","v":0},{"$f":"SUM(H27:H33)","v":0},{"$f":"SUM(I28:I33)","v":0},{"$f":"SUM(J27:J33)","v":0}]
[23,null,"Net Rate Base",null,null,{"$f":"+F16+F25-F34","v":0},null,{"$f":"+H16+H25-H34","v":0},null,{"$f":"+J16+J25-J34","v":0}]
[24]
[25,"Note(s):"]
[26,"(1)","Insert additional rows and explanations as necessary. Please contact Commission Staff at"]
[27,null,"the number listed in the Instructions section of this application for assistance."]
[28,"(2)","From Contribution in Aid of Construction (CIAC) detail on [Form D, Line 61 (e)]."]
[29,"(3)","Enter CIAC accumulated amortization as a negative number"]
[]
[null,null,null,"NARUC",null,"Acct. 101",null,"Acct. 108",null,"Acc. 271"]
["Line",null,null,"Account",null,"Plant in ",null,"Accumulated ",null,"CIAC (2)"]
["No.",null,"Description","Numbers",null,"Service",null,"Depreciation"]
[null,null,"(a)","(b)",null,"(c)",null,"(d)",null,"(e)"]
[]
[{"$f":"A41+1","v":30},"WATER Utility Plant (1)"]
[{"$f":"A48+1","v":31},null,"Organization",301]
[{"$f":"A49+1","v":32},null,"Franchises",302]
[33,null,"Land & Land Rights",303]
[34,null,"Structures and Improvements",304]
[35,null,"Collecting and Impounding Reservoirs",305]
[36,null,"Intake Lines",306]
[37,null,"Wells & Springs",307]
[38,null,"Infiltration Galleries and Tunnels",308]
[39,null,"Supply Mains",309]
[40,null,"Power Generation Equipment",310]
[41,null,"Pumping Equipment",311]
[42,null,"Water Treatment",320]
[43,null,"Reservoirs & Standpipes",330]
[44,null,"Transmission & Distribution Mains",331]
[45,null,"Services",333]
[46,null,"Meters & Meter Installations",334]
[47,null,"Hydrants",335]
[48,null,"Backflow Devices",336]
[49,null,"Other Plant and Misc. Equipment",339]
[50,null,"Office Furniture & Equipment",340]
[51,null,"Transportation Equipment",341]
[52,null,"Stores Equipment",342]
[53,null,"Tools, Shop & Garage Equipment",343]
[54,null,"Laboratory Equipment",344]
[55,null,"Power Operated Equipment",345]
[56,null,"Communication Equipment",346]
[57,null,"Miscellaneous Equipment",347]
[58,null,"Other Tangible Plant",348]
[59]
[60]
[61,null,"Total Utility Plant",null,null,{"$f":"SUM(F49:F78)","v":0},null,{"$f":"SUM(H49:H78)","v":0},null,{"$f":"SUM(J49:J78)","v":0}]
[62,null,null,null,null,"to Line 2 (c)",null,"to Line 3 (c)",null,"to Line 17 (c)"]
[63,"Note(s):"]
[64,"(1)","Insert additional rows and explanations as necessary. Please contact Commission Staff at"]
[65,null,"the number listed in the Instructions section of this application for assistance."]
[66,"(2)","CIAC = Contribution in Aid of Construction (gross, prior to amortization)"]

{"sheet":"WTR-Form E","index":5,"n_rows":44,"n_cols":12,"rows_kept":44,"cut":false,"hidden":false,"merged":[[2,0,2,11],[0,0,0,11],[1,0,1,11]]}
["Public Utilities Commission of Nevada"]
["Class A or B Water Utility"]
[{"$f":"IF('WTR-Cover'!B7=0,\"\",'WTR-Cover'!B7)","v":""}]
[null,null,null,"Test Year Ending:",null,{"$f":"IF('WTR-Form A'!G4=0,\"\",'WTR-Form A'!G4)","v":""}]
[null,null,null,"Certification Period Ending:",null,{"$f":"IF('WTR-Form A'!G5=0,\"\",'WTR-Form A'!G5)","v":""}]
[]
["WEIGHTED COST OF CAPITAL"]
[null,null,null,"NARUC",null,"Recorded",null,null,null,"Interest",null,"Weighted"]
["Line",null,null,"Account",null,"Test Year",null,"Weight",null,"Rate",null,"Cost"]
["No.",null,"Description","Numbers",null,"Balance",null,"(% of Total)",null,"( % )",null,"( % )"]
[null,null,"(a)","(b)",null,"(c)",null,"(d)",null,"(e)",null,"(f)"]
[]
[1,null,"DEBT: *"]
[{"$f":"+A13+1","v":2},null,"Long Term Debt",224,null,null,null,{"$f":"IF(F14=0,\"\",F14/$F40)","v":""},null,null,null,{"$f":"IF(F14=0,\" \",ROUND(+H14*J14,4))","v":" "}]
[{"$f":"+A14+1","v":3},null,null,null,null,null,null,{"$f":"IF(F15=0,\"\",F15/$F40)","v":""},null,null,null,{"$f":"IF(F15=0,\" \",ROUND(+H15*J15,4))","v":" "}]
[4,null,null,null,null,null,null,{"$f":"IF(F16=0,\"\",F16/$F40)","v":""},null,null,null," "]
[5,null,null,null,null,null,null,{"$f":"IF(F17=0,\"\",F17/$F40)","v":""},null,null,null," "]
[6,null,null,null,null,null,null,{"$f":"IF(F18=0,\"\",F18/$F40)","v":""},null,null,null," "]
[7,null,"Notes Payable",232,null,null,null,{"$f":"IF(F19=0,\"\",F19/$F40)","v":""},null,null,null," "]
[8,null,null,null,null,null,null,{"$f":"IF(F20=0,\"\",F20/$F40)","v":""},null,null,null," "]
[9,null,null,null,null,null,null,{"$f":"IF(F21=0,\"\",F21/$F40)","v":""},null,null,null," "]
[10,null,null,null,null,null,null,{"$f":"IF(F22=0,\"\",F22/$F40)","v":""},null,null,null," "]
[11,null,null,null,null,null,null,{"$f":"IF(F23=0,\"\",F23/$F40)","v":""},null,null,null," "]
[12,null,"Customer Deposits",235,null,null,null,{"$f":"IF(F24=0,\"\",F24/$F40)","v":""},null,null,null," "]
[13,null,"Total Debt",null,null,{"$f":"SUM(F14:F24)","v":0},null,{"$f":"SUM(H14:H24)","v":0},null,null,null,{"$f":"SUM(L14:L24)","v":0}]
[14,null,"EQUITY: *"]
[15,null,"Common Stock",201,null,null,null,{"$f":"IF(F27=0,\" \",+F27/$F$40)","v":" "}]
[16,null,"Preferred Stock",204,null,null,null,{"$f":"IF(F28=0,\" \",+F28/$F$40)","v":" "}]
[17,null,"Premium on Capital Stock",207,null,null,null," "]
[18,null,"Other Paid in Capital",211,null,null,null," "]
[19,null,"Discount on Capital Stock",212,null,null,null," "]
[20,null,"Capital Stock Expense",213,null,null,null," "]
[21,null,"Retained Earnings (corporations only)",215,null,null,null," "]
[22,null,"Reacquired Capital Stock",216,null,null,null," "]
[23,null,"Proprietary Capital (non-corporations)",218,null,null,null," "]
[24,null,null,null,null,null,null," "]
[25,null,null,null,null,null,null," "]
[26,null,null,null,null,null,null," "]
[27,null,"Total Equity",null,null,{"$f":"SUM(F27:F38)","v":0},null,{"$f":"SUM(H27:H38)","v":0},null,null,null,{"$f":"ROUND(+H39*J39,4)","v":0}]
[28,null,"Total Weighted Cost of Capital",null,null,{"$f":"+F25+F39","v":0},null,{"$f":"+H25+H39","v":0},null,null,null,{"$f":"ROUND(L25+L39,4)","v":0}]
[29,null,null,null,null,null,null,null,null,null,null,"[Form C, Line 65 (g)]"]
[30,"Notes:"]
[31,"*","Insert additional rows as necessary. For assistance, please contact Commission Staff at the number listed"]
[32,null,"in the Instructions section of this application."]

{"sheet":"WTR-Form F","index":6,"n_rows":51,"n_cols":10,"rows_kept":51,"cut":false,"hidden":false,"merged":[[2,0,2,9],[0,0,0,9],[1,0,1,9]]}
["Public Utilities Commission of Nevada"]
["Class A or B Water Utility"]
[{"$f":"IF('WTR-Cover'!B7=0,\"\",'WTR-Cover'!B7)","v":""}]
[null,null,null,"Test Year Ending:",null,{"$f":"IF('WTR-Form A'!G4=0,\"\",'WTR-Form A'!G4)","v":""}]
[null,null,null,"Certification Period Ending:",null,{"$f":"IF('WTR-Form A'!G5=0,\"\",'WTR-Form A'!G5)","v":""}]
[]
["STATEMENT OF SERVICES"]
[null,null,null,"NARUC",null,null,null,"No. of ",null,"No. of "]
["Line",null,null,"Account",null,"Revenues",null,"Customers",null,"Gallons"]
["No.",null,"Description","Numbers",null,null,null,"(End of Year)",null,"(in 000's)"]
[null,null,"(a)",null,null,"(b)",null,"(c)",null,"(b)"]
[]
[1,null,"WATER SALES"]
[{"$f":"1+A13","v":2},null,"Unmetered (Flat Rate) *",null,null,"To Form C"]
[{"$f":"1+A14","v":3},null,"Residential",460.1]
[4,null,"Commercial",460.2]
[5,null,"Industrial",460.3]
[6,null,"Public Authorities",460.4]
[7,null,"Multiple Family Dwellings",460.5]
[8]
[9]
[10,null,"Subtotal - Unmetered",null,null,{"$f":"SUM(F15:F21)","v":0},null,{"$f":"SUM(H15:H21)","v":0},null,{"$f":"SUM(J15:J21)","v":0}]
[11]
[12,null,"Metered *"]
[13,null,"Residential",461.1]
[14,null,"Commercial",461.2]
[15,null,"Industrial",461.3]
[16,null,"Public Authorities",461.4]
[17,null,"Multiple Family Dwellings",461.5]
[18]
[19]
[20,null,"Subtotal - Metered",null,null,{"$f":"SUM(F25:F31)","v":0},null,{"$f":"SUM(H25:H31)","v":0},null,{"$f":"SUM(J25:J31)","v":0}]
[21]
[22,null,"OTHER WATER SALES *"]
[23,null,"Fire Protection",462]
[24,null,"Other Sales to Public Authorities",464]
[25,null,"Irrigation Customers",465]
[26,null,"Sales for Resale",466]
[27,null,"Interdepartmental ",467]
[28,null,"Guaranteed Revenues",469]
[29,null,"Forfeited Discounts",470]
[30,null,"Miscellaneous Service Revenues",471]
[31,null,"Rents from Water Property ",472]
[32,null,"Other Water Revenues",474]
[33]
[34]
[35,null,"Subtotal",null,null,{"$f":"SUM(F35:F46)","v":0},{"$f":"SUM(G35:G46)","v":0},{"$f":"SUM(H35:H46)","v":0},null,{"$f":"SUM(J35:J46)","v":0}]
[36,null,"TOTALS",null,null,{"$f":"+F22+F32+F47","v":0},{"$f":"+G22+G32+G47","v":0},{"$f":"+H22+H32+H47","v":0},null,{"$f":"+J22+J32+J47","v":0}]
[37,"Notes:"]
[38,"*","Insert additional rows as necessary. For assistance, please contact Commission Staff at"]
[39,null,"the number listed in the Instructions section of this application."]

{"sheet":"WTR-Form G","index":7,"n_rows":49,"n_cols":8,"rows_kept":49,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"CUSTOMER NOTICE"]
[]
[]
[null,"Notice is hereby given to customers of ",null,{"$f":"IF('WTR-Cover'!B7=0,\"\",'WTR-Cover'!B7)","v":""}]
[null,"of the Utility's request for approval from the Public Utilities Commission of Nevada"]
[null,"(\"Commission\") to increase  WATER rates.  Tabulated below are the principle rates presently in"]
[null,"effect compared to the requested new rates. "]
[]
[null,"The present rates have been in effect since       ",null,null,"."]
[null,"The requested new rates would increase revenues to the Utility                    ",null,null,null,{"$f":"IF('WTR-Form C'!F35=0,\"\",((('WTR-Form C'!N35-'WTR-Form C'!J35))/'WTR-Form C'!J35))","v":""},"over the"]
[null,"present rates. (Applicant may wish to add any explanation for the requested increase.)"]
[]
[null,null,null,"Existing",null,"Proposed",null,"% Inc./Dec."]
[null,null,null,null,null,null,null,{"$f":"IF(D15=0,\"\",((F15-D15)/D15)*1)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(D16=0,\"\",((F16-D16)/D16)*1)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(D17=0,\"\",((F17-D17)/D17)*1)","v":""}]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[]
[]
[null,"No public utility shall raise any rates or alter any charge, classification, contract or rules so as to"]
[null,"result in any increase in a rate except upon a showing before the Commission that such increase"]
[null,"is justified.  Customers may wish to bring to the Commission's attention any problem concerning"]
[null,"service, billing procedures or other factors concerning the adequacy of service provided."]
[]
[null,"In order to protect the public's interest, the Commission's Staff will investigate consumer"]
[null,"complaints.  Customers wishing to communicate directly with the Commission should write no"]
[null,"later than 20 days from the date of the postmark on the envelope in which this notice is sent or"]
[null,"from the date upon which it is distributed if not mailed.  "]
[]
[null,"Written comments should be directed the Commission Secretary at:"]
[]
[null,"Public Utilities Commission of Nevada"]
[null,"1150 E. William Street"]
[null,"Carson City, NV 89701"]
[]
[null,"Customers wishing to phone the Commission with their concerns may call the Commission's"]
[null,"Consumer Division in Carson City at (775) 684-6100 or the Las Vegas office at (702) 486-2600."]
[]
[]
[null,"Sincerely,"]
[]
[null,"(Company officer and title)"]

{"sheet":"WTR-Form H","index":8,"n_rows":37,"n_cols":11,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,1,1,11],[17,6,17,8],[17,10,17,12],[24,8,24,11],[27,8,27,11],[35,3,35,7],[21,2,21,10],[18,2,18,11],[7,4,7,7],[9,4,9,7],[16,3,16,6],[33,3,33,4],[33,6,33,7]]}
[]
[null,"VERIFICATION"]
[]
[]
[]
[]
[]
[null,null,"State of "]
[]
[null,null,"County of"]
[]
[]
[]
[]
[]
[]
[null,null,"I, ",null,null,null,null,"being first duly sworn, under penalty of perjury"]
[null,null,"depose and say:  That I am the ",null,null,null,null,null,null,"(title) for",{"$f":"'WTR-Form G'!D5","v":""}]
[null,null,{"$f":"CONCATENATE('WTR-Cover'!B7,\"; that I have read the foregoing application and know\")","v":"; that I have read the foregoing application and know"}]
[null,null,"the contents thereof; that the same is true of my own knowledge, except to those matters therein"]
[null,null,"stated on information and belief, and as to those matters I believe them to be true."]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"(Signature)"]
[]
[]
[null,null,null,null,null,null,null,null,"(Title)"]
[]
[]
[null,null,"SUBSCRIBED and SWORN to by me"]
[]
[null,null,"this ",null,null,"  ,day of "]
[]
[]
[null,null,null,"Notary Public"]

{"sheet":"WTR-Form I","index":9,"n_rows":43,"n_cols":7,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,1,0,8],[11,3,11,5],[7,1,7,2],[9,1,9,2],[1,1,1,8],[2,1,2,8],[3,1,3,8],[7,3,7,5],[9,3,9,5],[29,6,29,8],[39,2,39,3],[41,1,41,5],[33,6,33,8],[35,6,35,8]]}
[]
[null,"AFFIDAVIT OF PROOF OF SERVICE"]
[null,"AND"]
[null,"POSTING OF APPLICATION"]
[]
[]
[]
[null,"State of",null,null,null,null,")"]
[]
[null,"County of ",null,null,null,null,")"]
[]
[null,null,"I, ",null,null,null,",being duly sworn, under penalty of "]
[null,null,null,"perjury depose and say the following:"]
[]
[null,"1)","Upon the filing of this application for an increase in rates with the Public Utility Commission of"]
[null,null,"Nevada (\"Commission\"), the Utility has made available a complete copy in such form and place as"]
[null,null,"is readily accessible and available for inspection by its customers;"]
[]
[null,"2)","Upon the filing of this application for an increase in rates with the Commission, the Utility has"]
[null,null,"served a copy of the application on each county, municipality and general improvement district"]
[null,null,"whose citizens would be affected by the proposed change in rates.  A copy has also been served"]
[null,null,"upon the Nevada Attorney General Bureau of Consumer Protection - Utility Consumer's Advocate;"]
[]
[null,"3)","Within 10 days of filing this application for an increase in rates with the Commission, the Utility has"]
[null,null,"made available in plain type and posted at its place of business a notice stating that the application"]
[null,null,"has been filed with the Commission.  Said notice describes the purpose of the application and"]
[null,null,"indicates that the complete application is available for public inspection on the premise."]
[]
[null,"4)","Within 30 days after filing this application with the Commission, I or my representative under my"]
[null,null,"direction, has notified each and every customer of",null,null,null,{"$f":"IF('WTR-Cover'!B7=0,\"\",'WTR-Cover'!B7)","v":""}]
[null,null,"by U.S. Mail at their address on file, of the filing of this application to seek an increase in rates."]
[]
[]
[]
[null,null,null,null,null,null,"(Name)"]
[]
[null,null,null,null,null,null,"(Title)"]
[]
[null,"SUBSCRIBED and SWORN to before me"]
[null,"this",null,null,"day of "]
[]
[]
[null,"Notary Public"]