{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["AR TOC","AR1","AR2","AR2-2","AR3","AR4","AR5","AR6","AR6-2","AR7","AR8","AR9","AR10","Drop down lists"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":13,"defined_names":481,"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":"AR TOC","index":0,"n_rows":38,"n_cols":5,"rows_kept":38,"cut":false,"hidden":false,"merged":[[12,0,12,1],[32,0,35,4],[37,0,38,4]]}
[{"$f":"'AR1'!$B$12","v":0}]
["Annual Report"]
["Table of Contents"]
[]
[]
[]
[null,"TABLE OF CONTENTS"]
[]
["Company Name:",{"$f":"IF('AR1'!B12=\"\",\"\",'AR1'!B12)","v":""}]
["Test Year:",{"$f":"IF('AR1'!B19=\"\",\"\",'AR1'!B19)","v":"12/31/19"}]
[]
[]
["Table of contents:",null,"Page No.","Complete"]
["AR 1","COVER PAGE 1","Page 1",{"$f":"'AR1'!N44","v":"Incomplete"}]
["AR 2","COVER PAGE 2",{"$f":"'AR2'!J50","v":"Page 2"},{"$f":"'AR2'!S50","v":"Incomplete"}]
["AR 2-2",{"$f":"Supp_Info","v":"Important changes during the year"},{"$f":"'AR2-2'!M42","v":"Page 3"},{"$f":"'AR2-2'!T19","v":"Incomplete"}]
["AR 3",{"$f":"'AR3'!A3","v":"AUTHORIZED SERVICES AND STATISTICAL INFORMATION"},{"$f":"'AR3'!D53","v":"Page 4"},{"$f":"'AR3'!J44","v":"Incomplete"}]
["AR 4",{"$f":"'AR4'!A6","v":"VERIFICATION AND SWORN STATEMENT (INTRASTATE REVENUE ONLY)"},{"$f":"'AR4'!I64","v":"Page 5"},{"$f":"'AR4'!M42","v":"Incomplete"}]
["AR 5",{"$f":"AR_Page13","v":"VERIFICATION AND SWORN STATEMENT (RESIDENTIAL REVENUE)"},{"$f":"'AR5'!I65","v":"Page 6"},{"$f":"'AR5'!P47","v":"Incomplete"},{"$f":"IF('AR8'!E8=\"Does not balance\",\"Does not balance\",IF('AR8'!E9=\"Does not balance\",\"Does not balance\",\"\"))","v":""}]
["AR 6",{"$f":"AR7_Page_7","v":"UTILITY PLANT IN SERVICE (ELECTRIC)"},{"$f":"'AR6'!H100","v":"Page 7"},{"$f":"'AR6'!Q96","v":"Incomplete"}]
["AR 7",{"$f":"'AR7'!A7","v":"DEPRECIATION EXPENSE FOR THE CURRENT YEAR (ELECTRIC)"},{"$f":"'AR7'!J100","v":"Page 8"},{"$f":"'AR7'!P97","v":"Incomplete"}]
["AR 8",{"$f":"AR9_ASSETS","v":"BALANCE SHEET ASSETS"},{"$f":"'AR8'!D60","v":"Page 9"},{"$f":"'AR8'!J71","v":"Incomplete"}]
["AR 9",{"$f":"'AR9'!A7","v":"ELECTRIC COMPARATIVE INCOME STATEMENT"},{"$f":"'AR9'!D92","v":"Page 11"},{"$f":"'AR9'!N87","v":"Incomplete"}]
["AR 10",{"$f":"'AR10'!AR_Page12","v":"UTILITY SHUTOFFS / DISCONNECTS"},{"$f":"'AR10'!D34","v":"Page 12"},{"$f":"'AR10'!J24","v":"Incomplete"}]
[]
[]
[]
[]
[]
[]
[]
[]
["General Instructions:  For each schedule, fill out the Grey Cells with the relevent information.  Input 0 or none if there is nothing recorded in that account or there is no applicable information to report.  This table of contents is intended to assist with the completeness of the Annual Report, and will not become part of the Annual Report that will be published on the Commission's website."]
[]
[]
[]
[]
["Note 1: the Pages highlighted in grey require input to properly complete the annual report.  The other pages are linked and therefore automatically populate."]

{"sheet":"AR1","index":1,"n_rows":48,"n_cols":14,"rows_kept":48,"cut":false,"hidden":false,"merged":[[17,1,17,2],[12,0,15,0],[7,0,7,8],[9,0,9,8],[11,1,11,8],[14,1,14,3],[13,1,13,8],[12,1,12,8],[41,5,41,7],[34,0,34,8],[35,0,35,8],[36,0,36,8],[37,0,37,8],[24,0,24,8],[26,0,26,8],[28,0,28,8],[32,0,32,8],[33,0,33,8]]}
[null,null,null,null,null,null,null,null,null,"AR 1"]
[null,null,null,null,null,null,null,null,null,{"$f":"\"Annual Report Page \"&I48","v":"Annual Report Page 1"}]
[]
[]
[]
[]
[]
["ANNUAL REPORT",null,null,null,null,null,null,null,null,null,"Table of Contents"]
[]
["Of"]
[null,null,null,null,null,null,null,null,null,null,null,"Email address:"]
["Company Name: ",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B12=\"\",\"\",VLOOKUP(B12, 'Drop down lists'!$M$2:$T$255, 8, FALSE))","v":""},{"$f":"IF(B12<>\"\",\"Complete\",\"Incomplete\")","v":"Incomplete"}]
["Mailing Address:",{"$f":"IF(B12=\"\",\"\",VLOOKUP(B12, 'Drop down lists'!$M$2:$T$255, 3, FALSE))","v":""}]
[null,{"$f":"IF(B12=\"\",\"\",VLOOKUP(B12, 'Drop down lists'!$M$2:$T$255, 4, FALSE))","v":""}]
[null,{"$f":"IF(B12=\"\",\"\",VLOOKUP(B12, 'Drop down lists'!$M$2:$T$255, 5, FALSE))","v":""},null,null,{"$f":"IF(B12=\"\",\"\",VLOOKUP(B12, 'Drop down lists'!$M$2:$T$255, 7, FALSE))","v":""}]
[null,{"$f":"IF(B12=\"\",\"\",VLOOKUP(B12, 'Drop down lists'!$M$2:$T$255, 6, FALSE))","v":""}]
[]
["Docket No.:",{"$f":"IF(B12=\"\",\"\",VLOOKUP(B12, 'Drop down lists'!$M$2:$T$255, 2, FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B18=0,\"Incomplete\",\"Complete\")","v":"Complete"},{"$f":"IF(M12=\"Incomplete\",\"Incomplete\",IF(M18=\"Incomplete\",\"Incomplete\",IF(M19=\"Incomplete\",\"Incomplete\",\"Complete\")))","v":"Incomplete"}]
["For the Year Ended:","12/31/19"]
[]
[]
[]
[]
[]
["ELECTRIC"]
[]
["To"]
[]
["Arizona Corporation Commission"]
[]
[]
[]
["Due on April 15th"]
["Email: rdelafuente@azcc.gov, mail or deliver the completed Annual Report to:"]
["Arizona Corporation Commission"]
["Compliance Section - Utilities Division"]
["1200 West Washington Street"]
["Phoenix, Arizona 85007"]
[]
[]
[]
[null,null,null,null,"Application Type:","Original Filing",null,null,null,null,null,null,{"$f":"IF(F42=0,\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,null,null,null,"Application Date:",{"$f":"TODAY()","v":"2020-01-23"},null,null,null,null,null,null,null,{"$f":"IF(M42=\"Incomplete\",\"Incomplete\",IF(M43=\"Incomplete\",\"Incomplete\",\"Complete\"))","v":"Complete"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N18=\"Incomplete\",\"Incomplete\",IF(N43=\"Incomplete\",\"Incomplete\",\"Complete\"))","v":"Incomplete"}]
[]
[]
[]
[null,null,null,null,null,null,null,null,1]

{"sheet":"AR2","index":2,"n_rows":51,"n_cols":19,"rows_kept":51,"cut":false,"hidden":false,"merged":[[33,1,33,4],[34,1,34,9],[35,1,35,3],[35,6,35,7],[36,1,36,6],[9,1,9,3],[9,6,9,7],[0,0,0,9],[1,0,1,9],[2,0,2,9],[5,0,5,2],[8,1,8,9],[7,1,7,9],[48,1,48,4],[25,1,25,4],[26,1,26,9],[27,1,27,3],[27,6,27,7],[28,1,28,6],[46,1,46,4],[38,0,38,9],[39,1,39,4],[41,1,41,4],[42,1,42,9],[43,1,43,3],[40,1,40,4],[30,0,30,9],[31,1,31,4],[32,1,32,4],[43,6,43,7],[44,1,44,6],[10,7,10,8],[11,1,11,6],[16,1,16,4],[10,1,10,3],[23,1,23,4],[14,0,14,9],[15,1,15,4],[17,1,17,4],[18,1,18,9],[19,1,19,3],[19,6,19,7],[20,1,20,6],[22,0,22,9],[24,1,24,4]]}
["ARIZONA CORPORATION COMMISSION ",null,null,null,null,null,null,null,null,null,"AR 2"]
["ELECTRIC UTILITIY ANNUAL REPORT",null,null,null,null,null,null,null,null,null,{"$f":"\"Annual Report Page \"&J51","v":"Annual Report Page 2"}]
["COMPANY INFORMATION"]
[]
[]
["For the Calendar Year Ended:",null,null,{"$f":"IF('AR1'!B19=\"\",\"\",'AR1'!B19)","v":"12/31/19"}]
[]
["Company/Business Name: "]
["Mailing Address: ",null,null,null,null,null,null,null,null,null,null,"Table of Contents",null,null,{"$f":"IF(B9=0,\"Incomplete\",\"Complete\")","v":"Incomplete"}]
["City:",null,null,null,null,"State:",null,null,"Zip Code:",null,null,null,null,null,{"$f":"IF(B10=0,\"Incomplete\",\"Complete\")","v":"Incomplete"},{"$f":"IF(G10=0,\"Incomplete\",\"Complete\")","v":"Incomplete"},{"$f":"IF(J10=0,\"Incomplete\",\"Complete\")","v":"Incomplete"},{"$f":"IF(O10=\"Incomplete\",\"Incomplete\",IF(P10=\"Incomplete\",\"Incomplete\",IF(Q10=\"Incomplete\",\"Incomplete\",\"Complete\")))","v":"Incomplete"}]
["Telephone Number:",null,null,null,null,null,"Fax Number:",null,null,null,null,null,null,null,{"$f":"IF(B11=0,\"Incomplete\",\"Complete\")","v":"Incomplete"}]
["Email:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O9=\"Incomplete\",\"Incomplete\",IF(R10=\"Incomplete\",\"Incomplete\",IF(#REF!=\"Incomplete\",\"Incomplete\",IF(O11=\"Incomplete\",\"Incomplete\",\"Complete\"))))","v":"Incomplete"}]
[]
[]
["Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B16=0,\"Incomplete\",\"Complete\")","v":"Incomplete"}]
["Title:"]
["Telephone No. :",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B18=0,\"Incomplete\",\"Complete\")","v":"Incomplete"}]
["Address:",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B19=0,\"Incomplete\",\"Complete\")","v":"Incomplete"}]
["City:",null,null,null,null,"State:",null,null,"Zip Code:",null,null,null,null,null,{"$f":"IF(B20=0,\"Incomplete\",\"Complete\")","v":"Incomplete"},{"$f":"IF(G20=0,\"Incomplete\",\"Complete\")","v":"Incomplete"},{"$f":"IF(J20=0,\"Incomplete\",\"Complete\")","v":"Incomplete"},{"$f":"IF(O20=\"Incomplete\",\"Incomplete\",IF(P20=\"Incomplete\",\"Incomplete\",IF(Q20=\"Incomplete\",\"Incomplete\",\"Complete\")))","v":"Incomplete"}]
["Email:",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B21=0,\"Incomplete\",\"Complete\")","v":"Incomplete"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O16=\"Incomplete\",\"Incomplete\",IF(O18=\"Incomplete\",\"Incomplete\",IF(O19=\"Incomplete\",\"Incomplete\",IF(R20=\"Incomplete\",\"Incomplete\",IF(O21=\"Incomplete\",\"Incomplete\",\"Complete\")))))","v":"Incomplete"}]
[]
["Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B24=0,\"Incomplete\",\"Complete\")","v":"Incomplete"}]
["Title:"]
["Telephone No. :",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B26=0,\"Incomplete\",\"Complete\")","v":"Incomplete"}]
["Address:",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B27=0,\"Incomplete\",\"Complete\")","v":"Incomplete"}]
["City:",null,null,null,null,"State:",null,null,"Zip Code:",null,null,null,null,null,{"$f":"IF(B28=0,\"Incomplete\",\"Complete\")","v":"Incomplete"},{"$f":"IF(G28=0,\"Incomplete\",\"Complete\")","v":"Incomplete"},{"$f":"IF(J28=0,\"Incomplete\",\"Complete\")","v":"Incomplete"},"Incomplete"]
["Email:",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B29=0,\"Incomplete\",\"Complete\")","v":"Incomplete"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O24=\"Incomplete\",\"Incomplete\",IF(O26=\"Incomplete\",\"Incomplete\",IF(O27=\"Incomplete\",\"Incomplete\",IF(R28=\"Incomplete\",\"Incomplete\",IF(O29=\"Incomplete\",\"Incomplete\",\"Complete\")))))","v":"Incomplete"}]
[]
["Name:"]
["Title:"]
["Telephone No. :"]
["Address:"]
["City:",null,null,null,null,"State:",null,null,"Zip Code:"]
["Email:"]
[]
[]
["Name:"]
["Title:"]
["Telephone No. :"]
["Address:"]
["City:",null,null,null,null,"State:",null,null,"Zip Code:"]
["Email:"]
[]
["Ownership:",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B47=0,\"Incomplete\",\"Complete\")","v":"Incomplete"}]
[]
["Counties Served:",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B49=0,\"Incomplete\",\"Complete\")","v":"Incomplete"},null,null,null,{"$f":"IF(O47=\"Incomplete\",\"Incomplete\",IF(O49=\"Incomplete\",\"Incomplete\",\"Complete\"))","v":"Incomplete"}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"Page \"&J51","v":"Page 2"},null,null,null,null,null,null,null,null,{"$f":"IF(S13=\"Incomplete\",\"Incomplete\",IF(S22=\"Incomplete\",\"Incomplete\",IF(S30=\"Incomplete\",\"Incomplete\",IF(S49=\"Incomplete\",\"Incomplete\",\"Complete\"))))","v":"Incomplete"}]
[null,null,null,null,null,null,null,null,null,{"$f":"'AR1'!I48+1","v":2}]

{"sheet":"AR2-2","index":3,"n_rows":43,"n_cols":20,"rows_kept":43,"cut":false,"hidden":false,"merged":[[9,1,13,12],[17,1,17,12],[18,1,18,12],[19,1,23,12],[0,0,0,12],[1,0,1,12],[2,0,2,12],[4,0,4,12],[6,1,7,12],[8,1,8,12]]}
["ARIZONA CORPORATION COMMISSION ",null,null,null,null,null,null,null,null,null,null,null,null,"AR 2"]
["ELECTRIC UTILITIY ANNUAL REPORT",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Annual Report Page \"&M71","v":"Annual Report Page "}]
[{"$f":"'AR1'!B12","v":0}]
[]
["Important changes during the year"]
[]
[null,"For those companies not subject to the affiliated interest rules, has there been a change in ownership or direct control during the year?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A7=0,\"Incomplete\",\"Complete\")","v":"Incomplete"},{"$f":"IF(B10=0,\"Incomplete\",\"Complete\")","v":"Incomplete"}]
[]
[null,"If yes, please provide specific details in the box below."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Has the company been notified by any other regulatory authorities during the year, that they are out of compliance?"]
[null,"If yes, please provide specific details in the box below.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A18=0,\"Incomplete\",\"Complete\")","v":"Incomplete"},{"$f":"IF(B20=0,\"Incomplete\",\"Complete\")","v":"Incomplete"},{"$f":"IF(S7=0,\"Incomplete\",IF(S19=\"Incomplete\",\"Incomplete\",\"Complete\"))","v":"Incomplete"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Page \"&M43","v":"Page 3"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'AR2'!J51+1","v":3}]

{"sheet":"AR3","index":4,"n_rows":54,"n_cols":10,"rows_kept":54,"cut":false,"hidden":false,"merged":[[35,0,35,2],[25,0,25,2],[24,0,24,2],[6,0,6,3]]}
[{"$f":"'AR1'!$B$12","v":0},null,null,null,"AR 3"]
["ELECTRIC UTILITY ANNUAL REPORT",null,null,null,{"$f":"\"Annual Report Page \"&D54","v":"Annual Report Page 4"}]
["AUTHORIZED SERVICES AND STATISTICAL INFORMATION"]
[{"$f":"IF('AR1'!B19=\"\",\"\",'AR1'!B19)","v":"12/31/19"}]
[]
[]
["SERVICES AUTHORIZED TO PROVIDE",null,null,null,"Table of Contents"]
[]
[null,"Electric",null,null,null,{"$f":"IF(A9<>\"\",\"Complete\",\"Incomplete\")","v":"Incomplete"}]
[null,"     Investor Owned Electric",null,null,null,{"$f":"IF(A10<>\"\",\"Complete\",\"Incomplete\")","v":"Incomplete"}]
[null,"     Rural Electric Cooperative",null,null,null,"Incomplete"]
[null,"     Utility Distributed Company",null,null,null,"Incomplete"]
[null,"     Electric Service Provider",null,null,null,"Incomplete"]
[null,"          Transmission Service Provider",null,null,null,"Incomplete"]
[null,"          Meter Service Provider",null,null,null,"Incomplete",{"$f":"IF(F9=\"Incomplete\",\"Incomplete\",IF(F10=\"Incomplete\",\"Incomplete\",IF(F11=\"Incomplete\",\"Incomplete\",IF(F12=\"Incomplete\",\"Incomplete\",IF(F13=\"Incomplete\",\"Incomplete\",IF(F13=\"Incomplete\",\"Incomplete\",IF(F14=\"Incomplete\",\"Incomplete\",IF(F15=\"Incomplete\",\"Incomplete\",\"Complete\"))))))))","v":"Incomplete"}]
[null,"          Meter Reading Service Provider",null,null,null,"Incomplete"]
[null,"          Billing and Collection",null,null,null,"Incomplete"]
[null,"          Ancillary Services",null,null,null,"Incomplete"]
[null,"          Generation Provider",null,null,null,"Incomplete"]
[null,"          Aggregator/Broker",null,null,null,"Incomplete"]
[]
[null,"Other (Specify)",null,null,null,"Incomplete",{"$f":"IF(F16=\"Incomplete\",\"Incomplete\",IF(F17=\"Incomplete\",\"Incomplete\",IF(F18=\"Incomplete\",\"Incomplete\",IF(F19=\"Incomplete\",\"Incomplete\",IF(F20=\"Incomplete\",\"Incomplete\",IF(F20=\"Incomplete\",\"Incomplete\",IF(F22=\"Incomplete\",\"Incomplete\",\"Complete\")))))))","v":"Incomplete"}]
[]
[]
["STATISTICAL INFORMATION"]
["Retail Information"]
[null,"Number of Arizona Customers","Number of kWh Sold in Arizona"]
["Residential",null,null,null,null,{"$f":"IF(B28<>\"\",\"Complete\",\"Incomplete\")","v":"Incomplete"},{"$f":"IF(C28<>\"\",\"Complete\",\"Incomplete\")","v":"Incomplete"}]
["Commercial",null,null,null,null,{"$f":"IF(B29<>\"\",\"Complete\",\"Incomplete\")","v":"Incomplete"},{"$f":"IF(C29<>\"\",\"Complete\",\"Incomplete\")","v":"Incomplete"}]
["Industrial",null,null,null,null,"Incomplete","Incomplete"]
["Public Street and Highway Lighting",null,null,null,null,"Incomplete","Incomplete"]
["Irrigation",null,null,null,null,"Incomplete","Incomplete",{"$f":"IF(F28=\"Incomplete\",\"Incomplete\",IF(F29=\"Incomplete\",\"Incomplete\",IF(F30=\"Incomplete\",\"Incomplete\",IF(F30=\"Incomplete\",\"Incomplete\",IF(F31=\"Incomplete\",\"Incomplete\",IF(F32=\"Incomplete\",\"Incomplete\",\"Complete\"))))))","v":"Incomplete"},{"$f":"IF(G28=\"Incomplete\",\"Incomplete\",IF(G29=\"Incomplete\",\"Incomplete\",IF(G30=\"Incomplete\",\"Incomplete\",IF(G30=\"Incomplete\",\"Incomplete\",IF(G31=\"Incomplete\",\"Incomplete\",IF(G32=\"Incomplete\",\"Incomplete\",\"Complete\"))))))","v":"Incomplete"},{"$f":"IF(G15=\"Incomplete\",\"Incomplete\",IF(G22=\"Incomplete\",\"Incomplete\",IF(H32=\"Incomplete\",\"Incomplete\",IF(I32=\"Incomplete\",\"Incomplete\",\"Complete\"))))","v":"Incomplete"}]
["Total Retail",{"$f":"SUM(B28:B32)","v":0},{"$f":"SUM(C28:C32)","v":0}]
[]
[]
["Wholesale Information"]
[null,"Number of Customers","Number of kWh Sold"]
["Resale",null,null,null,null,"Incomplete","Incomplete"]
["Short-term Sales (duration of less than one-year)",null,null,null,null,"Incomplete","Incomplete"]
["Total Wholesale",{"$f":"B38+B39","v":0},{"$f":"C38+C39","v":0}]
[]
[]
[null,"Total Sold",{"$f":"C33+C40","v":0}]
[null,"Maximum Peak Load",null,null,null,null,"Incomplete",null,{"$f":"IF(F38=\"Incomplete\",\"Incomplete\",IF(G38=\"Incomplete\",\"Incomplete\",IF(F39=\"Incomplete\",\"Incomplete\",IF(F39=\"Incomplete\",\"Incomplete\",IF(G39=\"Incomplete\",\"Incomplete\",IF(G44=\"Incomplete\",\"Incomplete\",\"Complete\"))))))","v":"Incomplete"},{"$f":"IF(J32=\"Incomplete\",\"Incomplete\",IF(I44=\"Incomplete\",\"Incomplete\",\"Complete\"))","v":"Incomplete"}]
[null,"Distribution System Losses"]
[null,"Distribution Losses"]
[null,"Transmission Losses"]
[null,"System Average Interruption Duration Index (SAIDI)"]
[null,"Distribution System Losses"]
[null,"Customer Average Interruption Duration Index (CAIDI)"]
[null,"System Average Interruption Frequency Index (SAIFI)"]
[]
[null,null,null,{"$f":"\"Page \"&D54","v":"Page 4"}]
[null,null,null,{"$f":"'AR2-2'!M43+1","v":4}]

{"sheet":"AR4","index":5,"n_rows":67,"n_cols":13,"rows_kept":67,"cut":false,"hidden":false,"merged":[[47,11,47,12],[13,1,14,8],[20,1,24,8],[31,1,33,8],[38,4,38,5],[37,3,37,7],[39,4,39,6],[40,6,40,7],[41,4,41,5],[17,1,17,2],[47,5,47,8],[5,0,5,8],[66,0,66,8],[11,3,11,6],[40,4,40,5],[44,5,44,8],[45,5,45,8],[51,7,51,8],[52,7,52,8],[60,5,60,8],[61,5,61,8],[51,3,51,6],[50,3,50,8],[7,2,7,3],[8,2,8,3],[9,4,9,6],[10,4,10,6],[53,4,53,5],[53,7,53,8],[54,7,54,8],[56,3,56,5],[48,5,48,8]]}
[{"$f":"'AR1'!$B$12","v":0},null,null,null,null,null,null,null,null,"AR 4"]
["ELECTRIC UTILITIY ANNUAL REPORT",null,null,null,null,null,null,null,null,{"$f":"\"Annual Report Page \"&I65","v":"Annual Report Page 5"}]
[{"$f":"A6","v":"VERIFICATION AND SWORN STATEMENT (INTRASTATE REVENUE ONLY)"}]
[{"$f":"IF('AR1'!B19=\"\",\"\",'AR1'!B19)","v":"12/31/19"}]
[]
["VERIFICATION AND SWORN STATEMENT (INTRASTATE REVENUE ONLY)"]
["Verification:"]
[null,"State of ",null,null,"I, the undersigned of the "]
[null,null,"(state name)",null,null,null,null,null,null,null,"Table of Contents"]
[null,"County of (county name):"]
[null,"Name (owner or official) title:"]
[null,"Company name:",null,{"$f":"A1","v":0}]
[]
[null,"DO SAY THAT THIS ANNUAL UTILITY PROPERTY TAX AND SALES TAX REPORT TO THE ARIZONA CORPORATION COMMISSION."]
[]
[]
[]
[null,"FOR THE YEAR ENDING:",null,{"$f":"'AR1'!B19","v":"12/31/19"}]
[]
[]
[null,"HAS BEEN PREPARED UNDER MY DIRECTION, FROM THE ORIGINAL BOOKS, PAPERS AND RECORDS OF SAID UTILITY; THAT I HAVE CAREFULLY EXAMINED THE SAME, AND DECLARE THE SAME TO BE A COMPLETE AND CORRECT STATEMENT OF BUSINESS AND AFFAIRS OF SAID UTILITY FOR THE PERIOD COVERED BY THIS REPORT IN RESPECT TO EACH AND EVERY MATTER AND THING SET FORTH, TO THE BEST OF MY KNOWLEDGE, INFORMATION AND BELIEF."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Sworn Statement:","IN ACCORDANCE WITH THE REQUIREMENTS OF TITLE 40, ARTICLE 8, SECTION 40-401, ARIZONA REVISED STATUTES, IT IS HEREIN REPORTED THAT THE GROSS OPERATING REVENUE OF SAID UTILITY DERIVED FROM ARIZONA INTRASTATE UTILITY OPERATIONS DURING THE CALENDAR YEAR WAS:"]
[]
[]
[]
[]
[]
[null,null,null,"Arizona Intrastate Gross Operating Revenues Only ($)"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E39<>\"\",\"Complete\",\"Incomplete\")","v":"Incomplete"}]
[null,null,null,null,"(The amount in the box above includes"]
[null,null,null,null,null,null,"in sales taxes ",null,null,null,null,{"$f":"IF(E41<>\"\",\"Complete\",\"Incomplete\")","v":"Incomplete"}]
[null,null,null,null,"billed or collected)",null,null,null,null,null,null,null,{"$f":"IF(L39=\"Incomplete\",\"Incomplete\",IF(L41=\"Incomplete\",\"Incomplete\",\"Complete\"))","v":"Incomplete"}]
[]
[]
[]
[null,null,null,null,null,"signature of owner/official"]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"AR_Phone","v":{"$error":"#REF!"}}]
[null,null,null,null,null,"telephone no."]
[]
[null,null,null,"SUBSCRIBED AND SWORN TO BEFORE ME A NOTARY PUBLIC"]
[null,null,null,"IN AND FOR THE COUNTY "]
[null,null,null,null,null,null,null,"(county name)"]
[null,null,null,"THIS",null,null,"DAY OF"]
[null,null,null,null,null,null,null,"(month) and (year)"]
[]
[null,null,null,"MY COMMISSION EXPIRES"]
[null,null,null,null,null,null,"(date)"]
[]
[]
[]
[null,null,null,null,null,"(signature of notary public)"]
[]
[null,null,null,null,null,null,null,null,{"$f":"\"Page \"&I65","v":"Page 5"}]
[null,null,null,null,null,null,null,null,{"$f":"'AR3'!D54+1","v":5}]
[]
["Note:  Print this form out, sign on the signature line and have the notary complete and sign prior to submission."]

{"sheet":"AR5","index":6,"n_rows":68,"n_cols":16,"rows_kept":68,"cut":false,"hidden":false,"merged":[[51,7,51,8],[54,7,54,8],[7,4,7,6],[37,4,37,6],[67,0,68,8],[61,4,61,8],[60,4,60,8],[42,5,42,8],[56,3,56,5],[7,2,7,3],[8,2,8,3],[10,4,10,6],[53,4,53,5],[53,7,53,8],[11,4,11,6],[12,3,12,6],[45,5,45,8],[5,0,5,8],[49,3,49,8],[50,3,50,5],[11,1,11,3],[10,1,10,3],[22,1,26,8],[29,1,32,8],[38,4,38,5],[43,5,43,8],[46,5,46,8],[50,7,50,8],[12,1,12,2],[36,4,36,5],[15,1,16,8],[19,1,19,2]]}
[{"$f":"'AR1'!$B$12","v":0},null,null,null,null,null,null,null,null,"AR 5"]
["ELECTRIC UTILITIY ANNUAL REPORT",null,null,null,null,null,null,null,null,{"$f":"\"Annual Report Page \"&I66","v":"Annual Report Page 6"}]
[{"$f":"A6","v":"VERIFICATION AND SWORN STATEMENT (RESIDENTIAL REVENUE)"}]
[{"$f":"IF('AR1'!B19=\"\",\"\",'AR1'!B19)","v":"12/31/19"}]
[]
["VERIFICATION AND SWORN STATEMENT (RESIDENTIAL REVENUE)"]
["Verification:"]
[null,"State of ",null,null,"I, the undersigned of the ",null,null,null,null,null,null,null,null,{"$f":"IF(C8<>\"\",\"Complete\",\"Incomplete\")","v":"Incomplete"}]
[null,null,"(state name)",null,null,null,null,null,null,null,"Table of Contents"]
[]
[null,"County of (county name):",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E11<>\"\",\"Complete\",\"Incomplete\")","v":"Incomplete"}]
[null,"Name (owner or official) title:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E12<>\"\",\"Complete\",\"Incomplete\")","v":"Incomplete"}]
[null,"Company name:",null,{"$f":"A1","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N8=\"Incomplete\",\"Incomplete\",IF(N11=\"Incomplete\",\"Incomplete\",IF(N12=\"Incomplete\",\"Incomplete\",\"Complete\")))","v":"Incomplete"}]
[]
[]
[null,"DO SAY THAT THIS ANNUAL UTILITY PROPERTY TAX AND SALES TAX REPORT TO THE ARIZONA CORPORATION COMMISSION."]
[]
[]
[]
[null,"FOR THE YEAR ENDING: ",null,{"$f":"'AR1'!B19","v":"12/31/19"}]
[]
[]
[null,"HAS BEEN PREPARED UNDER MY DIRECTION, FROM THE ORIGINAL BOOKS, PAPERS AND RECORDS OF SAID UTILITY; THAT I HAVE CAREFULLY EXAMINED THE SAME, AND DECLARE THE SAME TO BE A COMPLETE AND CORRECT STATEMENT OF BUSINESS AND AFFAIRS OF SAID UTILITY FOR THE PERIOD COVERED BY THIS REPORT IN RESPECT TO EACH AND EVERY MATTER AND THING SET FORTH, TO THE BEST OF MY KNOWLEDGE, INFORMATION AND BELIEF."]
[]
[]
[]
[]
[]
[]
["Sworn Statement:","IN ACCORDANCE WITH THE REQUIREMENTS OF TITLE 40, ARTICLE 8, SECTION 40-401, ARIZONA REVISED STATUTES, IT IS HEREIN REPORTED THAT THE GROSS OPERATING REVENUE OF SAID UTILITY DERIVED FROM ARIZONA INTRASTATE UTILITY OPERATIONS RECEIVED FROM RESIDENTIAL CUSTOMERS DURING THE CALENDAR YEAR WAS:"]
[]
[]
[]
[]
[]
[null,null,"Arizona Intrastate Gross Operating Revenues Only ($)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E37<>\"\",\"Complete\",\"Incomplete\")","v":"Incomplete"}]
[null,null,null,null,"(The amount in the box above includes"]
[null,null,null,null,null,null,"in sales taxes ",null,null,null,null,null,null,{"$f":"IF(E39<>\"\",\"Complete\",\"Incomplete\")","v":"Incomplete"}]
[null,null,null,null,"billed or collected)"]
[]
[]
[]
[null,null,null,null,null,"signature of owner/official"]
[]
[null,null,null,null,null,{"$f":"AR5_Phone","v":0}]
[null,null,null,null,null,"telephone no.",null,null,null,null,null,null,null,null,{"$f":"IF(N37=\"Incomplete\",\"Incomplete\",IF(N39=\"Incomplete\",\"Incomplete\",IF(#REF!=\"Incomplete\",\"Incomplete\",\"Complete\")))","v":"Incomplete"},{"$f":"IF(O13=\"Incomplete\",\"Incomplete\",IF(O47=\"Incomplete\",\"Incomplete\",\"Complete\"))","v":"Incomplete"}]
[]
[]
[null,null,null,"SUBSCRIBED AND SWORN TO BEFORE ME A NOTARY PUBLIC"]
[null,null,null,"IN AND FOR THE COUNTY "]
[null,null,null,null,null,null,null,"(county name)"]
[]
[null,null,null,"THIS",null,null,"DAY OF"]
[null,null,null,null,null,null,null,"(month) and (year)"]
[]
[null,null,null,"MY COMMISSION EXPIRES"]
[null,null,null,null,null,null,"(date)"]
[]
[]
[]
[null,null,null,null,"(signature of notary public)"]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"\"Page \"&I66","v":"Page 6"}]
[null,null,null,null,null,null,null,null,{"$f":"'AR4'!I65+1","v":6}]
[]
["Note:  Be sure to complete the information in the Grey highlighted cells.  Then print this form out, sign on the signature line and have the notary complete and sign prior to submission."]

{"sheet":"AR6","index":7,"n_rows":105,"n_cols":17,"rows_kept":105,"cut":false,"hidden":false,"merged":[[104,0,104,7],[5,0,5,7],[7,0,7,7],[11,0,11,7],[20,0,20,7],[82,0,82,7],[28,0,28,7],[37,0,37,7],[47,0,47,7],[58,0,58,7],[74,0,74,7]]}
[{"$f":"'AR1'!$B$12","v":0},null,null,null,null,null,null,null,"AR 6"]
["ELECTRIC UTILITIY ANNUAL REPORT",null,null,null,null,null,null,null,{"$f":"\"Annual Report Page \"&H101","v":"Annual Report Page 7"}]
[{"$f":"AR7_Page_7","v":"UTILITY PLANT IN SERVICE (ELECTRIC)"}]
[{"$f":"IF('AR1'!B19=\"\",\"\",'AR1'!B19)","v":"12/31/19"}]
[]
["UTILITY PLANT IN SERVICE (ELECTRIC)"]
["Account No.","Description","Beginning Year Original Cost","Current Year Additions","Current Year Retirements","Adjusted Original Cost","Accumulated Depreciation","OCLD (OC less AD)",null,"Table of Contents"]
["Intangible Plant"]
[301,"Organization",null,null,null,{"$f":"C9+D9-E9","v":0},null,{"$f":"F9-G9","v":0},null,null,null,{"$f":"IF(C9<>\"\",\"Complete\",\"Incomplete\")","v":"Incomplete"},{"$f":"IF(D9<>\"\",\"Complete\",\"Incomplete\")","v":"Incomplete"},{"$f":"IF(E9<>\"\",\"Complete\",\"Incomplete\")","v":"Incomplete"},{"$f":"IF(G9<>\"\",\"Complete\",\"Incomplete\")","v":"Incomplete"},{"$f":"IF(L9=\"Incomplete\",\"Incomplete\",IF(M9=\"Incomplete\",\"Incomplete\",IF(N9=\"Incomplete\",\"Incomplete\",IF(O9=\"Incomplete\",\"Incomplete\",\"Complete\"))))","v":"Incomplete"}]
[302,"Franchises and consents",null,null,null,{"$f":"C10+D10-E10","v":0},null,{"$f":"F10-G10","v":0},null,null,null,{"$f":"IF(C10<>\"\",\"Complete\",\"Incomplete\")","v":"Incomplete"},"Incomplete",{"$f":"IF(E10<>\"\",\"Complete\",\"Incomplete\")","v":"Incomplete"},{"$f":"IF(G10<>\"\",\"Complete\",\"Incomplete\")","v":"Incomplete"},{"$f":"IF(L10=\"Incomplete\",\"Incomplete\",IF(M10=\"Incomplete\",\"Incomplete\",IF(N10=\"Incomplete\",\"Incomplete\",IF(O10=\"Incomplete\",\"Incomplete\",\"Complete\"))))","v":"Incomplete"}]
[303,"Miscellaneous intangible plant",null,null,null,{"$f":"C11+D11-E11","v":0},null,{"$f":"F11-G11","v":0},null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete",{"$f":"IF(P9=\"Incomplete\",\"Incomplete\",IF(P10=\"Incomplete\",\"Incomplete\",IF(P11=\"Incomplete\",\"Incomplete\",\"Complete\")))","v":"Incomplete"}]
["Steam Production"]
[310,"Land and land rights",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[311,"Structures and improvements",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[312,"Boiler plant equipment",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[313,"Engines and engine-driven generators",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[314,"Turbogenerator units",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[315,"Accessorry electric equipment",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[316,"Miscellaneous power plant equipment",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[317,"Asset retirement costs",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete",{"$f":"IF(P13=\"Incomplete\",\"Incomplete\",IF(P14=\"Incomplete\",\"Incomplete\",IF(P15=\"Incomplete\",\"Incomplete\",IF(P16=\"Incomplete\",\"Incomplete\",IF(P17=\"Incomplete\",\"Incomplete\",IF(P18=\"Incomplete\",\"Incomplete\",IF(P19=\"Incomplete\",\"Incomplete\",IF(P20=\"Incomplete\",\"Incomplete\",\"Complete\"))))))))","v":"Incomplete"}]
["Nuclear Production"]
[320,"Land and land rights",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[321,"Structures and improvements",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[322,"Reactor plant equipment",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[323,"Turbogenerator units",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[324,"Accessorry electric equipment",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[325,"Miscellaneous power plant equipment",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[326,"Asset retirement costs",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete",{"$f":"IF(P22=\"Incomplete\",\"Incomplete\",IF(P23=\"Incomplete\",\"Incomplete\",IF(P24=\"Incomplete\",\"Incomplete\",IF(P25=\"Incomplete\",\"Incomplete\",IF(P26=\"Incomplete\",\"Incomplete\",IF(P27=\"Incomplete\",\"Incomplete\",IF(P28=\"Incomplete\",\"Incomplete\",\"Complete\")))))))","v":"Incomplete"}]
["Hydraulic Production"]
[330,"Land and land rights",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[331,"Structures and improvements",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[332,"Reservoirs, dams and waterways",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[333,"Water wheels, turbines and generators",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[334,"Accessorry electric equipment",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[335,"Miscellaneous power plant equipment",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[336,"Roads, railroads and bridges",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[337,"Asset retirement costs",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete",{"$f":"IF(P30=\"Incomplete\",\"Incomplete\",IF(P31=\"Incomplete\",\"Incomplete\",IF(P32=\"Incomplete\",\"Incomplete\",IF(P33=\"Incomplete\",\"Incomplete\",IF(P34=\"Incomplete\",\"Incomplete\",IF(P35=\"Incomplete\",\"Incomplete\",IF(P36=\"Incomplete\",\"Incomplete\",IF(P37=\"Incomplete\",\"Incomplete\",\"Complete\"))))))))","v":"Incomplete"}]
["Other Production"]
[340,"Land and land rights",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[341,"Structures and improvements",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[342,"Fuel holders, producers, and accessories",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[343,"Prime movers",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[344,"Generators",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[345,"Accessorry electric equipment",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[346,"Miscellaneous power plant equipment",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[347,"Asset retirement costs",null,null,null,0,null,0,null,null,null,{"$f":"IF(C46<>\"\",\"Complete\",\"Incomplete\")","v":"Incomplete"},{"$f":"IF(D46<>\"\",\"Complete\",\"Incomplete\")","v":"Incomplete"},{"$f":"IF(E46<>\"\",\"Complete\",\"Incomplete\")","v":"Incomplete"},{"$f":"IF(G46<>\"\",\"Complete\",\"Incomplete\")","v":"Incomplete"},{"$f":"IF(L46=\"Incomplete\",\"Incomplete\",IF(M46=\"Incomplete\",\"Incomplete\",IF(N46=\"Incomplete\",\"Incomplete\",IF(O46=\"Incomplete\",\"Incomplete\",\"Complete\"))))","v":"Incomplete"}]
[348,"Energy Storage Equipment-Production",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete",{"$f":"IF(P39=\"Incomplete\",\"Incomplete\",IF(P40=\"Incomplete\",\"Incomplete\",IF(P41=\"Incomplete\",\"Incomplete\",IF(P42=\"Incomplete\",\"Incomplete\",IF(P43=\"Incomplete\",\"Incomplete\",IF(P44=\"Incomplete\",\"Incomplete\",IF(P45=\"Incomplete\",\"Incomplete\",IF(P46=\"Incomplete\",\"Incomplete\",IF(P47=\"Incomplete\",\"Incomplete\",\"Complete\")))))))))","v":"Incomplete"}]
["Transmission Plant"]
[350,"Land and land rights",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[352,"Structures and improvements",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[353,"Station equipment",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[354,"Towers and fixtures",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[355,"Poles and fixtures",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[356,"Overhead conductors and devices",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[357,"Underground conduit",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[358,"Underground conductors and devices",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[359,"Road and trails",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[359.1,"Asset retirement costs for transmission plant",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete",{"$f":"IF(P49=\"Incomplete\",\"Incomplete\",IF(P50=\"Incomplete\",\"Incomplete\",IF(P51=\"Incomplete\",\"Incomplete\",IF(P52=\"Incomplete\",\"Incomplete\",IF(P53=\"Incomplete\",\"Incomplete\",IF(P54=\"Incomplete\",\"Incomplete\",IF(P55=\"Incomplete\",\"Incomplete\",IF(P56=\"Incomplete\",\"Incomplete\",IF(P57=\"Incomplete\",\"Incomplete\",IF(P58=\"Incomplete\",\"Incomplete\",\"Complete\"))))))))))","v":"Incomplete"}]
["Distribution Plant"]
[360,"Land and land rights",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[361,"Structures and improvements",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[362,"Station equipment",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[363,"Storage battery equipment",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[364,"Poles, towers and fixtures",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[365,"Overhead conductors and devices",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[366,"Underground conduit",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete",{"$f":"IF(P60=\"Incomplete\",\"Incomplete\",IF(P61=\"Incomplete\",\"Incomplete\",IF(P62=\"Incomplete\",\"Incomplete\",IF(P63=\"Incomplete\",\"Incomplete\",IF(P64=\"Incomplete\",\"Incomplete\",IF(P65=\"Incomplete\",\"Incomplete\",IF(P66=\"Incomplete\",\"Incomplete\",\"Complete\")))))))","v":"Incomplete"}]
[367,"Underground conductors and devices",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[368,"Line transformers",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[369,"Services",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[370,"Meters",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[371,"Installations on customers' premises",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[372,"Leased property on customers' premises",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[373,"Street lighting and signal systems",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[374,"Asset retirement costs for distribution plant",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete",{"$f":"IF(P67=\"Incomplete\",\"Incomplete\",IF(P68=\"Incomplete\",\"Incomplete\",IF(P69=\"Incomplete\",\"Incomplete\",IF(P70=\"Incomplete\",\"Incomplete\",IF(P71=\"Incomplete\",\"Incomplete\",IF(P72=\"Incomplete\",\"Incomplete\",IF(P73=\"Incomplete\",\"Incomplete\",IF(P74=\"Incomplete\",\"Incomplete\",\"Complete\"))))))))","v":"Incomplete"}]
["Regional Transmission and Market Operation Plant"]
[380,"Land and land rights",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[381,"Structures and improvements",null,null,null,{"$f":"C77+D77-E77","v":0},null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[382,"Computer hardware",null,null,null,{"$f":"C78+D78-E78","v":0},null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[383,"Computer software",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[384,"Communications equipment",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[385,"Miscellaneous regional transmission and market operation plant",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[386,"Asset retirement costs for regional transmission and market operation plant",null,null,null,0,null,{"$f":"F82-G82","v":0},null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete",{"$f":"IF(P76=\"Incomplete\",\"Incomplete\",IF(P77=\"Incomplete\",\"Incomplete\",IF(P78=\"Incomplete\",\"Incomplete\",IF(P79=\"Incomplete\",\"Incomplete\",IF(P80=\"Incomplete\",\"Incomplete\",IF(P81=\"Incomplete\",\"Incomplete\",IF(P82=\"Incomplete\",\"Incomplete\",\"Complete\")))))))","v":"Incomplete"}]
["General Plant"]
[389,"Land and land rights",null,null,null,{"$f":"C84+D84-E84","v":0},null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[390,"Structures and improvements",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[391,"Office furniture and equipment",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[392,"Transportation equipment",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete",{"$f":"IF(P84=\"Incomplete\",\"Incomplete\",IF(P85=\"Incomplete\",\"Incomplete\",IF(P86=\"Incomplete\",\"Incomplete\",IF(P87=\"Incomplete\",\"Incomplete\",\"Complete\"))))","v":"Incomplete"}]
[393,"Stores equipment",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[394,"Tools, shop and garage equipment",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[395,"Laboratory equipment",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[396,"Power operated equipment",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[397,"Communications equipment",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[398,"Miscellaneous equipment",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[399,"Other tangible property",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete"]
[399.1,"Asset retirement costs for general plant",null,null,null,0,null,0,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete","Incomplete",{"$f":"IF(P88=\"Incomplete\",\"Incomplete\",IF(P89=\"Incomplete\",\"Incomplete\",IF(P90=\"Incomplete\",\"Incomplete\",IF(P91=\"Incomplete\",\"Incomplete\",IF(P92=\"Incomplete\",\"Incomplete\",IF(P93=\"Incomplete\",\"Incomplete\",IF(P94=\"Incomplete\",\"Incomplete\",IF(P95=\"Incomplete\",\"Incomplete\",\"Complete\"))))))))","v":"Incomplete"}]
[null,"Totals ",{"$f":"SUM(C9:C95)","v":0},0,0,0,0,0,null,null,null,null,null,null,null,null,{"$f":"IF(Q11=\"Incomplete\",\"Incomplete\",IF(Q20=\"Incomplete\",\"Incomplete\",IF(Q28=\"Incomplete\",\"Incomplete\",IF(Q37=\"Incomplete\",\"Incomplete\",IF(Q47=\"Incomplete\",\"Incomplete\",IF(Q58=\"Incomplete\",\"Incomplete\",IF(Q66=\"Incomplete\",\"Incomplete\",IF(Q74=\"Incomplete\",\"Incomplete\",IF(Q82=\"Incomplete\",\"Incomplete\",IF(Q87=\"Incomplete\",\"Incomplete\",IF(Q95=\"Incomplete\",\"Incomplete\",\"Complete\")))))))))))","v":"Incomplete"}]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"\"Page \"&H101","v":"Page 7"}]
[null,null,null,null,null,null,null,{"$f":"'AR5'!I66+1","v":7}]
[]
[]
[]
["Instructions: Fill out the Grey Cells with the relevant information.  Input 0 or none if there is nothing recorded in that account or there is no applicable information to report."]

{"sheet":"AR6-2","index":8,"n_rows":55,"n_cols":7,"rows_kept":55,"cut":false,"hidden":true,"merged":[[6,0,6,6],[48,0,51,6]]}
[{"$f":"'AR1'!$B$12","v":0}]
["Annual Report"]
[{"$f":"A7","v":"Full time equivalent employees"}]
[{"$f":"IF('AR1'!B19=\"\",\"\",'AR1'!B19)","v":"12/31/19"}]
[]
[]
["Full time equivalent employees"]
[]
[null,null,"Direct Company","Outside service","Total"]
[null,"President",null,null,{"$f":"C10+D10","v":0}]
[null,"Vice-president",null,null,{"$f":"C11+D11","v":0}]
[null,"Manager",null,null,0]
[null,"Engineering Staff",null,null,0]
[null,"System Operator(s)",null,null,0]
[null,"Meter reader",null,null,0]
[null,"Customer Service",null,null,0]
[null,"Accounting",null,null,0]
[null,"Business Office",null,null,0]
[null,"Rates Department",null,null,0]
[null,"Administrative Staff",null,null,0]
[null,"Other",null,null,0]
[null,"Total",{"$f":"SUM(C10:C21)","v":0},{"$f":"SUM(D10:D21)","v":0},{"$f":"SUM(E10:E21)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Instructions: Fill out the Grey Cells with the relevant information.  Input 0 or none if there is nothing recorded in that account or there is no applicable information to report.  A full-time employee is based on 2080 total hours per year.  Please calculate partial employees using 2080 hours."]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"\"Page \"&G55","v":"Page 12"}]
[null,null,null,null,null,null,{"$f":"'AR9'!D93+1","v":12}]

{"sheet":"AR7","index":9,"n_rows":104,"n_cols":16,"rows_kept":104,"cut":false,"hidden":false,"merged":[[103,0,103,9],[48,0,48,9],[59,0,59,9],[75,0,75,9],[83,0,83,9],[38,0,38,9],[6,0,6,9],[8,0,8,9],[12,0,12,9],[21,0,21,9],[29,0,29,9]]}
[{"$f":"'AR1'!$B$12","v":0},null,null,null,null,null,null,null,null,null,"AR7"]
["ELECTRIC UTILITIY ANNUAL REPORT",null,null,null,null,null,null,null,null,null,{"$f":"\"Annual Report Page \"&J101","v":"Annual Report Page 8"}]
[{"$f":"A7","v":"DEPRECIATION EXPENSE FOR THE CURRENT YEAR (ELECTRIC)"}]
[{"$f":"IF('AR1'!B19=\"\",\"\",'AR1'!B19)","v":"12/31/19"}]
[]
[]
["DEPRECIATION EXPENSE FOR THE CURRENT YEAR (ELECTRIC)"]
["Account No.","Description","Beginning Year Original Cost","Current Year Additions","Current Year Retirements","Adjusted Original Cost","Fully Depreciated/Non-depreciable Plant","Depreciable Plant","Depreciation Percentages","Depreciation Expense",null,"Table of Contents"]
["Intangible Plant"]
[{"$f":"'AR6'!A9","v":301},{"$f":"'AR6'!B9","v":"Organization"},{"$f":"'AR6'!C9","v":0},{"$f":"'AR6'!D9","v":0},{"$f":"'AR6'!E9","v":0},{"$f":"'AR6'!F9","v":0},null,{"$f":"F10-G10","v":0},null,{"$f":"((C10-G10)*I10)+((D10*I10)*0.5)-((E10*I10)*0.5)","v":0},null,null,{"$f":"IF(G10<>\"\",\"Complete\",\"Incomplete\")","v":"Incomplete"},{"$f":"IF(I10<>\"\",\"Complete\",\"Incomplete\")","v":"Incomplete"},{"$f":"IF(M10=\"Incomplete\",\"Incomplete\",IF(N10=\"Incomplete\",\"Incomplete\",\"Complete\"))","v":"Incomplete"}]
[{"$f":"'AR6'!A10","v":302},{"$f":"'AR6'!B10","v":"Franchises and consents"},{"$f":"'AR6'!C10","v":0},{"$f":"'AR6'!D10","v":0},{"$f":"'AR6'!E10","v":0},{"$f":"'AR6'!F10","v":0},null,{"$f":"F11-G11","v":0},null,{"$f":"((C11-G11)*I11)+((D11*I11)*0.5)-((E11*I11)*0.5)","v":0},null,null,{"$f":"IF(G11<>\"\",\"Complete\",\"Incomplete\")","v":"Incomplete"},{"$f":"IF(I11<>\"\",\"Complete\",\"Incomplete\")","v":"Incomplete"},{"$f":"IF(M11=\"Incomplete\",\"Incomplete\",IF(N11=\"Incomplete\",\"Incomplete\",\"Complete\"))","v":"Incomplete"}]
[{"$f":"'AR6'!A11","v":303},{"$f":"'AR6'!B11","v":"Miscellaneous intangible plant"},{"$f":"'AR6'!C11","v":0},{"$f":"'AR6'!D11","v":0},{"$f":"'AR6'!E11","v":0},{"$f":"'AR6'!F11","v":0},null,{"$f":"F12-G12","v":0},null,{"$f":"((C12-G12)*I12)+((D12*I12)*0.5)-((E12*I12)*0.5)","v":0},null,null,{"$f":"IF(G12<>\"\",\"Complete\",\"Incomplete\")","v":"Incomplete"},{"$f":"IF(I12<>\"\",\"Complete\",\"Incomplete\")","v":"Incomplete"},"Incomplete",{"$f":"IF(O10=\"Incomplete\",\"Incomplete\",IF(O11=\"Incomplete\",\"Incomplete\",IF(O12=\"Incomplete\",\"Incomplete\",\"Complete\")))","v":"Incomplete"}]
["Steam Production"]
[{"$f":"'AR6'!A13","v":310},{"$f":"'AR6'!B13","v":"Land and land rights"},{"$f":"'AR6'!C13","v":0},{"$f":"'AR6'!D13","v":0},{"$f":"'AR6'!E13","v":0},{"$f":"'AR6'!F13","v":0},null,0,null,0,null,null,{"$f":"IF(G14<>\"\",\"Complete\",\"Incomplete\")","v":"Incomplete"},{"$f":"IF(I14<>\"\",\"Complete\",\"Incomplete\")","v":"Incomplete"},"Incomplete"]
[{"$f":"'AR6'!A14","v":311},{"$f":"'AR6'!B14","v":"Structures and improvements"},{"$f":"'AR6'!C14","v":0},{"$f":"'AR6'!D14","v":0},{"$f":"'AR6'!E14","v":0},{"$f":"'AR6'!F14","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A15","v":312},{"$f":"'AR6'!B15","v":"Boiler plant equipment"},{"$f":"'AR6'!C15","v":0},{"$f":"'AR6'!D15","v":0},{"$f":"'AR6'!E15","v":0},{"$f":"'AR6'!F15","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A16","v":313},{"$f":"'AR6'!B16","v":"Engines and engine-driven generators"},{"$f":"'AR6'!C16","v":0},{"$f":"'AR6'!D16","v":0},{"$f":"'AR6'!E16","v":0},{"$f":"'AR6'!F16","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A17","v":314},{"$f":"'AR6'!B17","v":"Turbogenerator units"},{"$f":"'AR6'!C17","v":0},{"$f":"'AR6'!D17","v":0},{"$f":"'AR6'!E17","v":0},{"$f":"'AR6'!F17","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A18","v":315},{"$f":"'AR6'!B18","v":"Accessorry electric equipment"},{"$f":"'AR6'!C18","v":0},{"$f":"'AR6'!D18","v":0},{"$f":"'AR6'!E18","v":0},{"$f":"'AR6'!F18","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A19","v":316},{"$f":"'AR6'!B19","v":"Miscellaneous power plant equipment"},{"$f":"'AR6'!C19","v":0},{"$f":"'AR6'!D19","v":0},{"$f":"'AR6'!E19","v":0},{"$f":"'AR6'!F19","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A20","v":317},{"$f":"'AR6'!B20","v":"Asset retirement costs"},{"$f":"'AR6'!C20","v":0},{"$f":"'AR6'!D20","v":0},{"$f":"'AR6'!E20","v":0},{"$f":"'AR6'!F20","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete",{"$f":"IF(O14=\"Incomplete\",\"Incomplete\",IF(O15=\"Incomplete\",\"Incomplete\",IF(O16=\"Incomplete\",\"Incomplete\",IF(O17=\"Incomplete\",\"Incomplete\",IF(O18=\"Incomplete\",\"Incomplete\",IF(O19=\"Incomplete\",\"Incomplete\",IF(O20=\"Incomplete\",\"Incomplete\",IF(O21=\"Incomplete\",\"Incomplete\",\"Complete\"))))))))","v":"Incomplete"}]
["Nuclear Production"]
[{"$f":"'AR6'!A22","v":320},{"$f":"'AR6'!B22","v":"Land and land rights"},{"$f":"'AR6'!C22","v":0},{"$f":"'AR6'!D22","v":0},{"$f":"'AR6'!E22","v":0},{"$f":"'AR6'!F22","v":0},null,0,null,0,null,null,{"$f":"IF(G23<>\"\",\"Complete\",\"Incomplete\")","v":"Incomplete"},{"$f":"IF(I23<>\"\",\"Complete\",\"Incomplete\")","v":"Incomplete"},"Incomplete"]
[{"$f":"'AR6'!A23","v":321},{"$f":"'AR6'!B23","v":"Structures and improvements"},{"$f":"'AR6'!C23","v":0},{"$f":"'AR6'!D23","v":0},{"$f":"'AR6'!E23","v":0},{"$f":"'AR6'!F23","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A24","v":322},{"$f":"'AR6'!B24","v":"Reactor plant equipment"},{"$f":"'AR6'!C24","v":0},{"$f":"'AR6'!D24","v":0},{"$f":"'AR6'!E24","v":0},{"$f":"'AR6'!F24","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A25","v":323},{"$f":"'AR6'!B25","v":"Turbogenerator units"},{"$f":"'AR6'!C25","v":0},{"$f":"'AR6'!D25","v":0},{"$f":"'AR6'!E25","v":0},{"$f":"'AR6'!F25","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A26","v":324},{"$f":"'AR6'!B26","v":"Accessorry electric equipment"},{"$f":"'AR6'!C26","v":0},{"$f":"'AR6'!D26","v":0},{"$f":"'AR6'!E26","v":0},{"$f":"'AR6'!F26","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A27","v":325},{"$f":"'AR6'!B27","v":"Miscellaneous power plant equipment"},{"$f":"'AR6'!C27","v":0},{"$f":"'AR6'!D27","v":0},{"$f":"'AR6'!E27","v":0},{"$f":"'AR6'!F27","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A28","v":326},{"$f":"'AR6'!B28","v":"Asset retirement costs"},{"$f":"'AR6'!C28","v":0},{"$f":"'AR6'!D28","v":0},{"$f":"'AR6'!E28","v":0},{"$f":"'AR6'!F28","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete",{"$f":"IF(O23=\"Incomplete\",\"Incomplete\",IF(O24=\"Incomplete\",\"Incomplete\",IF(O25=\"Incomplete\",\"Incomplete\",IF(O26=\"Incomplete\",\"Incomplete\",IF(O27=\"Incomplete\",\"Incomplete\",IF(O28=\"Incomplete\",\"Incomplete\",IF(O29=\"Incomplete\",\"Incomplete\",\"Complete\")))))))","v":"Incomplete"}]
["Hydraulic Production"]
[{"$f":"'AR6'!A30","v":330},{"$f":"'AR6'!B30","v":"Land and land rights"},{"$f":"'AR6'!C30","v":0},{"$f":"'AR6'!D30","v":0},{"$f":"'AR6'!E30","v":0},{"$f":"'AR6'!F30","v":0},null,0,null,0,null,null,{"$f":"IF(G31<>\"\",\"Complete\",\"Incomplete\")","v":"Incomplete"},{"$f":"IF(I31<>\"\",\"Complete\",\"Incomplete\")","v":"Incomplete"},"Incomplete"]
[{"$f":"'AR6'!A31","v":331},{"$f":"'AR6'!B31","v":"Structures and improvements"},{"$f":"'AR6'!C31","v":0},{"$f":"'AR6'!D31","v":0},{"$f":"'AR6'!E31","v":0},{"$f":"'AR6'!F31","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A32","v":332},{"$f":"'AR6'!B32","v":"Reservoirs, dams and waterways"},{"$f":"'AR6'!C32","v":0},{"$f":"'AR6'!D32","v":0},{"$f":"'AR6'!E32","v":0},{"$f":"'AR6'!F32","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A33","v":333},{"$f":"'AR6'!B33","v":"Water wheels, turbines and generators"},{"$f":"'AR6'!C33","v":0},{"$f":"'AR6'!D33","v":0},{"$f":"'AR6'!E33","v":0},{"$f":"'AR6'!F33","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A34","v":334},{"$f":"'AR6'!B34","v":"Accessorry electric equipment"},{"$f":"'AR6'!C34","v":0},{"$f":"'AR6'!D34","v":0},{"$f":"'AR6'!E34","v":0},{"$f":"'AR6'!F34","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A35","v":335},{"$f":"'AR6'!B35","v":"Miscellaneous power plant equipment"},{"$f":"'AR6'!C35","v":0},{"$f":"'AR6'!D35","v":0},{"$f":"'AR6'!E35","v":0},{"$f":"'AR6'!F35","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A36","v":336},{"$f":"'AR6'!B36","v":"Roads, railroads and bridges"},{"$f":"'AR6'!C36","v":0},{"$f":"'AR6'!D36","v":0},{"$f":"'AR6'!E36","v":0},{"$f":"'AR6'!F36","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A37","v":337},{"$f":"'AR6'!B37","v":"Asset retirement costs"},{"$f":"'AR6'!C37","v":0},{"$f":"'AR6'!D37","v":0},{"$f":"'AR6'!E37","v":0},{"$f":"'AR6'!F37","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete",{"$f":"IF(O31=\"Incomplete\",\"Incomplete\",IF(O32=\"Incomplete\",\"Incomplete\",IF(O33=\"Incomplete\",\"Incomplete\",IF(O34=\"Incomplete\",\"Incomplete\",IF(O35=\"Incomplete\",\"Incomplete\",IF(O36=\"Incomplete\",\"Incomplete\",IF(O37=\"Incomplete\",\"Incomplete\",IF(O38=\"Incomplete\",\"Incomplete\",\"Complete\"))))))))","v":"Incomplete"}]
["Other Production"]
[{"$f":"'AR6'!A39","v":340},{"$f":"'AR6'!B39","v":"Land and land rights"},{"$f":"'AR6'!C39","v":0},{"$f":"'AR6'!D39","v":0},{"$f":"'AR6'!E39","v":0},{"$f":"'AR6'!F39","v":0},null,0,null,0,null,null,{"$f":"IF(G40<>\"\",\"Complete\",\"Incomplete\")","v":"Incomplete"},{"$f":"IF(I40<>\"\",\"Complete\",\"Incomplete\")","v":"Incomplete"},{"$f":"IF(M40=\"Incomplete\",\"Incomplete\",IF(N40=\"Incomplete\",\"Incomplete\",\"Complete\"))","v":"Incomplete"}]
[{"$f":"'AR6'!A40","v":341},{"$f":"'AR6'!B40","v":"Structures and improvements"},{"$f":"'AR6'!C40","v":0},{"$f":"'AR6'!D40","v":0},{"$f":"'AR6'!E40","v":0},{"$f":"'AR6'!F40","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A41","v":342},{"$f":"'AR6'!B41","v":"Fuel holders, producers, and accessories"},{"$f":"'AR6'!C41","v":0},{"$f":"'AR6'!D41","v":0},{"$f":"'AR6'!E41","v":0},{"$f":"'AR6'!F41","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A42","v":343},{"$f":"'AR6'!B42","v":"Prime movers"},{"$f":"'AR6'!C42","v":0},{"$f":"'AR6'!D42","v":0},{"$f":"'AR6'!E42","v":0},{"$f":"'AR6'!F42","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A43","v":344},{"$f":"'AR6'!B43","v":"Generators"},{"$f":"'AR6'!C43","v":0},{"$f":"'AR6'!D43","v":0},{"$f":"'AR6'!E43","v":0},{"$f":"'AR6'!F43","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A44","v":345},{"$f":"'AR6'!B44","v":"Accessorry electric equipment"},{"$f":"'AR6'!C44","v":0},{"$f":"'AR6'!D44","v":0},{"$f":"'AR6'!E44","v":0},{"$f":"'AR6'!F44","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A45","v":346},{"$f":"'AR6'!B45","v":"Miscellaneous power plant equipment"},{"$f":"'AR6'!C45","v":0},{"$f":"'AR6'!D45","v":0},{"$f":"'AR6'!E45","v":0},{"$f":"'AR6'!F45","v":0},null,0,null,{"$f":"((C46-G46)*I46)+((D46*I46)*0.5)-((E46*I46)*0.5)","v":0},null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A46","v":347},{"$f":"'AR6'!B46","v":"Asset retirement costs"},{"$f":"'AR6'!C46","v":0},{"$f":"'AR6'!D46","v":0},{"$f":"'AR6'!E46","v":0},{"$f":"'AR6'!F46","v":0},null,0,null,{"$f":"((C47-G47)*I47)+((D47*I47)*0.5)-((E47*I47)*0.5)","v":0},null,null,{"$f":"IF(G47<>\"\",\"Complete\",\"Incomplete\")","v":"Incomplete"},{"$f":"IF(I47<>\"\",\"Complete\",\"Incomplete\")","v":"Incomplete"},{"$f":"IF(M47=\"Incomplete\",\"Incomplete\",IF(N47=\"Incomplete\",\"Incomplete\",\"Complete\"))","v":"Incomplete"}]
[{"$f":"'AR6'!A47","v":348},{"$f":"'AR6'!B47","v":"Energy Storage Equipment-Production"},{"$f":"'AR6'!C47","v":0},{"$f":"'AR6'!D47","v":0},{"$f":"'AR6'!E47","v":0},{"$f":"'AR6'!F47","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete",{"$f":"IF(O40=\"Incomplete\",\"Incomplete\",IF(O41=\"Incomplete\",\"Incomplete\",IF(O42=\"Incomplete\",\"Incomplete\",IF(O43=\"Incomplete\",\"Incomplete\",IF(O44=\"Incomplete\",\"Incomplete\",IF(O45=\"Incomplete\",\"Incomplete\",IF(O46=\"Incomplete\",\"Incomplete\",IF(O47=\"Incomplete\",\"Incomplete\",IF(O48=\"Incomplete\",\"Incomplete\",\"Complete\")))))))))","v":"Incomplete"}]
["Transmission Plant"]
[{"$f":"'AR6'!A49","v":350},{"$f":"'AR6'!B49","v":"Land and land rights"},{"$f":"'AR6'!C49","v":0},{"$f":"'AR6'!D49","v":0},{"$f":"'AR6'!E49","v":0},{"$f":"'AR6'!F49","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A50","v":352},{"$f":"'AR6'!B50","v":"Structures and improvements"},{"$f":"'AR6'!C50","v":0},{"$f":"'AR6'!D50","v":0},{"$f":"'AR6'!E50","v":0},{"$f":"'AR6'!F50","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A51","v":353},{"$f":"'AR6'!B51","v":"Station equipment"},{"$f":"'AR6'!C51","v":0},{"$f":"'AR6'!D51","v":0},{"$f":"'AR6'!E51","v":0},{"$f":"'AR6'!F51","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A52","v":354},{"$f":"'AR6'!B52","v":"Towers and fixtures"},{"$f":"'AR6'!C52","v":0},{"$f":"'AR6'!D52","v":0},{"$f":"'AR6'!E52","v":0},{"$f":"'AR6'!F52","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A53","v":355},{"$f":"'AR6'!B53","v":"Poles and fixtures"},{"$f":"'AR6'!C53","v":0},{"$f":"'AR6'!D53","v":0},{"$f":"'AR6'!E53","v":0},{"$f":"'AR6'!F53","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A54","v":356},{"$f":"'AR6'!B54","v":"Overhead conductors and devices"},{"$f":"'AR6'!C54","v":0},{"$f":"'AR6'!D54","v":0},{"$f":"'AR6'!E54","v":0},{"$f":"'AR6'!F54","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A55","v":357},{"$f":"'AR6'!B55","v":"Underground conduit"},{"$f":"'AR6'!C55","v":0},{"$f":"'AR6'!D55","v":0},{"$f":"'AR6'!E55","v":0},{"$f":"'AR6'!F55","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A56","v":358},{"$f":"'AR6'!B56","v":"Underground conductors and devices"},{"$f":"'AR6'!C56","v":0},{"$f":"'AR6'!D56","v":0},{"$f":"'AR6'!E56","v":0},{"$f":"'AR6'!F56","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A57","v":359},{"$f":"'AR6'!B57","v":"Road and trails"},{"$f":"'AR6'!C57","v":0},{"$f":"'AR6'!D57","v":0},{"$f":"'AR6'!E57","v":0},{"$f":"'AR6'!F57","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A58","v":359.1},{"$f":"'AR6'!B58","v":"Asset retirement costs for transmission plant"},{"$f":"'AR6'!C58","v":0},{"$f":"'AR6'!D58","v":0},{"$f":"'AR6'!E58","v":0},{"$f":"'AR6'!F58","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete",{"$f":"IF(O50=\"Incomplete\",\"Incomplete\",IF(O51=\"Incomplete\",\"Incomplete\",IF(O52=\"Incomplete\",\"Incomplete\",IF(O53=\"Incomplete\",\"Incomplete\",IF(O54=\"Incomplete\",\"Incomplete\",IF(O55=\"Incomplete\",\"Incomplete\",IF(O56=\"Incomplete\",\"Incomplete\",IF(O57=\"Incomplete\",\"Incomplete\",IF(O58=\"Incomplete\",\"Incomplete\",IF(O59=\"Incomplete\",\"Incomplete\",\"Complete\"))))))))))","v":"Incomplete"}]
["Distribution Plant"]
[{"$f":"'AR6'!A60","v":360},{"$f":"'AR6'!B60","v":"Land and land rights"},{"$f":"'AR6'!C60","v":0},{"$f":"'AR6'!D60","v":0},{"$f":"'AR6'!E60","v":0},{"$f":"'AR6'!F60","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A61","v":361},{"$f":"'AR6'!B61","v":"Structures and improvements"},{"$f":"'AR6'!C61","v":0},{"$f":"'AR6'!D61","v":0},{"$f":"'AR6'!E61","v":0},{"$f":"'AR6'!F61","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A62","v":362},{"$f":"'AR6'!B62","v":"Station equipment"},{"$f":"'AR6'!C62","v":0},{"$f":"'AR6'!D62","v":0},{"$f":"'AR6'!E62","v":0},{"$f":"'AR6'!F62","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A63","v":363},{"$f":"'AR6'!B63","v":"Storage battery equipment"},{"$f":"'AR6'!C63","v":0},{"$f":"'AR6'!D63","v":0},{"$f":"'AR6'!E63","v":0},{"$f":"'AR6'!F63","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A64","v":364},{"$f":"'AR6'!B64","v":"Poles, towers and fixtures"},{"$f":"'AR6'!C64","v":0},{"$f":"'AR6'!D64","v":0},{"$f":"'AR6'!E64","v":0},{"$f":"'AR6'!F64","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A65","v":365},{"$f":"'AR6'!B65","v":"Overhead conductors and devices"},{"$f":"'AR6'!C65","v":0},{"$f":"'AR6'!D65","v":0},{"$f":"'AR6'!E65","v":0},{"$f":"'AR6'!F65","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A66","v":366},{"$f":"'AR6'!B66","v":"Underground conduit"},{"$f":"'AR6'!C66","v":0},{"$f":"'AR6'!D66","v":0},{"$f":"'AR6'!E66","v":0},{"$f":"'AR6'!F66","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete",{"$f":"IF(O61=\"Incomplete\",\"Incomplete\",IF(O62=\"Incomplete\",\"Incomplete\",IF(O63=\"Incomplete\",\"Incomplete\",IF(O64=\"Incomplete\",\"Incomplete\",IF(O65=\"Incomplete\",\"Incomplete\",IF(O66=\"Incomplete\",\"Incomplete\",IF(O67=\"Incomplete\",\"Incomplete\",\"Complete\")))))))","v":"Incomplete"}]
[{"$f":"'AR6'!A67","v":367},{"$f":"'AR6'!B67","v":"Underground conductors and devices"},{"$f":"'AR6'!C67","v":0},{"$f":"'AR6'!D67","v":0},{"$f":"'AR6'!E67","v":0},{"$f":"'AR6'!F67","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A68","v":368},{"$f":"'AR6'!B68","v":"Line transformers"},{"$f":"'AR6'!C68","v":0},{"$f":"'AR6'!D68","v":0},{"$f":"'AR6'!E68","v":0},{"$f":"'AR6'!F68","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A69","v":369},{"$f":"'AR6'!B69","v":"Services"},{"$f":"'AR6'!C69","v":0},{"$f":"'AR6'!D69","v":0},{"$f":"'AR6'!E69","v":0},{"$f":"'AR6'!F69","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A70","v":370},{"$f":"'AR6'!B70","v":"Meters"},{"$f":"'AR6'!C70","v":0},{"$f":"'AR6'!D70","v":0},{"$f":"'AR6'!E70","v":0},{"$f":"'AR6'!F70","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A71","v":371},{"$f":"'AR6'!B71","v":"Installations on customers' premises"},{"$f":"'AR6'!C71","v":0},{"$f":"'AR6'!D71","v":0},{"$f":"'AR6'!E71","v":0},{"$f":"'AR6'!F71","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A72","v":372},{"$f":"'AR6'!B72","v":"Leased property on customers' premises"},{"$f":"'AR6'!C72","v":0},{"$f":"'AR6'!D72","v":0},{"$f":"'AR6'!E72","v":0},{"$f":"'AR6'!F72","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A73","v":373},{"$f":"'AR6'!B73","v":"Street lighting and signal systems"},{"$f":"'AR6'!C73","v":0},{"$f":"'AR6'!D73","v":0},{"$f":"'AR6'!E73","v":0},{"$f":"'AR6'!F73","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A74","v":374},{"$f":"'AR6'!B74","v":"Asset retirement costs for distribution plant"},{"$f":"'AR6'!C74","v":0},{"$f":"'AR6'!D74","v":0},{"$f":"'AR6'!E74","v":0},{"$f":"'AR6'!F74","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete",{"$f":"IF(O68=\"Incomplete\",\"Incomplete\",IF(O69=\"Incomplete\",\"Incomplete\",IF(O70=\"Incomplete\",\"Incomplete\",IF(O71=\"Incomplete\",\"Incomplete\",IF(O72=\"Incomplete\",\"Incomplete\",IF(O73=\"Incomplete\",\"Incomplete\",IF(O74=\"Incomplete\",\"Incomplete\",IF(O75=\"Incomplete\",\"Incomplete\",\"Complete\"))))))))","v":"Incomplete"}]
["Regional Transmission and Market Operation Plant"]
[{"$f":"'AR6'!A76","v":380},{"$f":"'AR6'!B76","v":"Land and land rights"},{"$f":"'AR6'!C76","v":0},{"$f":"'AR6'!D76","v":0},{"$f":"'AR6'!E76","v":0},{"$f":"'AR6'!F76","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A77","v":381},{"$f":"'AR6'!B77","v":"Structures and improvements"},{"$f":"'AR6'!C77","v":0},{"$f":"'AR6'!D77","v":0},{"$f":"'AR6'!E77","v":0},{"$f":"'AR6'!F77","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A78","v":382},{"$f":"'AR6'!B78","v":"Computer hardware"},{"$f":"'AR6'!C78","v":0},{"$f":"'AR6'!D78","v":0},{"$f":"'AR6'!E78","v":0},{"$f":"'AR6'!F78","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A79","v":383},{"$f":"'AR6'!B79","v":"Computer software"},{"$f":"'AR6'!C79","v":0},{"$f":"'AR6'!D79","v":0},{"$f":"'AR6'!E79","v":0},{"$f":"'AR6'!F79","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A80","v":384},{"$f":"'AR6'!B80","v":"Communications equipment"},{"$f":"'AR6'!C80","v":0},{"$f":"'AR6'!D80","v":0},{"$f":"'AR6'!E80","v":0},{"$f":"'AR6'!F80","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A81","v":385},{"$f":"'AR6'!B81","v":"Miscellaneous regional transmission and market operation plant"},{"$f":"'AR6'!C81","v":0},{"$f":"'AR6'!D81","v":0},{"$f":"'AR6'!E81","v":0},{"$f":"'AR6'!F81","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A82","v":386},{"$f":"'AR6'!B82","v":"Asset retirement costs for regional transmission and market operation plant"},{"$f":"'AR6'!C82","v":0},{"$f":"'AR6'!D82","v":0},{"$f":"'AR6'!E82","v":0},{"$f":"'AR6'!F82","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete",{"$f":"IF(O77=\"Incomplete\",\"Incomplete\",IF(O78=\"Incomplete\",\"Incomplete\",IF(O79=\"Incomplete\",\"Incomplete\",IF(O80=\"Incomplete\",\"Incomplete\",IF(O81=\"Incomplete\",\"Incomplete\",IF(O82=\"Incomplete\",\"Incomplete\",IF(O83=\"Incomplete\",\"Incomplete\",\"Complete\")))))))","v":"Incomplete"}]
["General Plant"]
[{"$f":"'AR6'!A84","v":389},{"$f":"'AR6'!B84","v":"Land and land rights"},{"$f":"'AR6'!C84","v":0},{"$f":"'AR6'!D84","v":0},{"$f":"'AR6'!E84","v":0},{"$f":"'AR6'!F84","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A85","v":390},{"$f":"'AR6'!B85","v":"Structures and improvements"},{"$f":"'AR6'!C85","v":0},{"$f":"'AR6'!D85","v":0},{"$f":"'AR6'!E85","v":0},{"$f":"'AR6'!F85","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A86","v":391},{"$f":"'AR6'!B86","v":"Office furniture and equipment"},{"$f":"'AR6'!C86","v":0},{"$f":"'AR6'!D86","v":0},{"$f":"'AR6'!E86","v":0},{"$f":"'AR6'!F86","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A87","v":392},{"$f":"'AR6'!B87","v":"Transportation equipment"},{"$f":"'AR6'!C87","v":0},{"$f":"'AR6'!D87","v":0},{"$f":"'AR6'!E87","v":0},{"$f":"'AR6'!F87","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete",{"$f":"IF(O85=\"Incomplete\",\"Incomplete\",IF(O86=\"Incomplete\",\"Incomplete\",IF(O87=\"Incomplete\",\"Incomplete\",IF(O88=\"Incomplete\",\"Incomplete\",\"Complete\"))))","v":"Incomplete"}]
[{"$f":"'AR6'!A88","v":393},{"$f":"'AR6'!B88","v":"Stores equipment"},{"$f":"'AR6'!C88","v":0},{"$f":"'AR6'!D88","v":0},{"$f":"'AR6'!E88","v":0},{"$f":"'AR6'!F88","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A89","v":394},{"$f":"'AR6'!B89","v":"Tools, shop and garage equipment"},{"$f":"'AR6'!C89","v":0},{"$f":"'AR6'!D89","v":0},{"$f":"'AR6'!E89","v":0},{"$f":"'AR6'!F89","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A90","v":395},{"$f":"'AR6'!B90","v":"Laboratory equipment"},{"$f":"'AR6'!C90","v":0},{"$f":"'AR6'!D90","v":0},{"$f":"'AR6'!E90","v":0},{"$f":"'AR6'!F90","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A91","v":396},{"$f":"'AR6'!B91","v":"Power operated equipment"},{"$f":"'AR6'!C91","v":0},{"$f":"'AR6'!D91","v":0},{"$f":"'AR6'!E91","v":0},{"$f":"'AR6'!F91","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A92","v":397},{"$f":"'AR6'!B92","v":"Communications equipment"},{"$f":"'AR6'!C92","v":0},{"$f":"'AR6'!D92","v":0},{"$f":"'AR6'!E92","v":0},{"$f":"'AR6'!F92","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A93","v":398},{"$f":"'AR6'!B93","v":"Miscellaneous equipment"},{"$f":"'AR6'!C93","v":0},{"$f":"'AR6'!D93","v":0},{"$f":"'AR6'!E93","v":0},{"$f":"'AR6'!F93","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A94","v":399},{"$f":"'AR6'!B94","v":"Other tangible property"},{"$f":"'AR6'!C94","v":0},{"$f":"'AR6'!D94","v":0},{"$f":"'AR6'!E94","v":0},{"$f":"'AR6'!F94","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete"]
[{"$f":"'AR6'!A95","v":399.1},{"$f":"'AR6'!B95","v":"Asset retirement costs for general plant"},{"$f":"'AR6'!C95","v":0},{"$f":"'AR6'!D95","v":0},{"$f":"'AR6'!E95","v":0},{"$f":"'AR6'!F95","v":0},null,0,null,0,null,null,"Incomplete","Incomplete","Incomplete",{"$f":"IF(O89=\"Incomplete\",\"Incomplete\",IF(O90=\"Incomplete\",\"Incomplete\",IF(O91=\"Incomplete\",\"Incomplete\",IF(O92=\"Incomplete\",\"Incomplete\",IF(O93=\"Incomplete\",\"Incomplete\",IF(O94=\"Incomplete\",\"Incomplete\",IF(O95=\"Incomplete\",\"Incomplete\",IF(O96=\"Incomplete\",\"Incomplete\",\"Complete\"))))))))","v":"Incomplete"}]
[null,"Depreciation expense",{"$f":"SUM(C10:C96)","v":0},{"$f":"SUM(D10:D96)","v":0},{"$f":"SUM(E10:E96)","v":0},0,{"$f":"SUM(G10:G96)","v":0},0,null,{"$f":"SUM(J10:J96)","v":0},{"$f":"IF(J97>0,J97/H97,\"\")","v":""},null,null,null,null,{"$f":"IF(P12=\"Incomplete\",\"Incomplete\",IF(P21=\"Incomplete\",\"Incomplete\",IF(P29=\"Incomplete\",\"Incomplete\",IF(P38=\"Incomplete\",\"Incomplete\",IF(P48=\"Incomplete\",\"Incomplete\",IF(P59=\"Incomplete\",\"Incomplete\",IF(P67=\"Incomplete\",\"Incomplete\",IF(P75=\"Incomplete\",\"Incomplete\",IF(P83=\"Incomplete\",\"Incomplete\",IF(P88=\"Incomplete\",\"Incomplete\",IF(P96=\"Incomplete\",\"Incomplete\",\"Complete\")))))))))))","v":"Incomplete"}]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"\"Page \"&J101","v":"Page 8"}]
[null,null,null,null,null,null,null,null,null,{"$f":"'AR6'!H101+1","v":8}]
[]
[]
["Instructions: Fill out the Grey Cells with the relevant information.  Input 0 or none if there is nothing recorded in that account or there is no applicable information to report."]

{"sheet":"AR8","index":10,"n_rows":71,"n_cols":10,"rows_kept":71,"cut":false,"hidden":false,"merged":[[6,0,6,3],[6,5,6,8],[65,5,66,8],[65,0,66,3],[56,5,57,8]]}
[{"$f":"'AR1'!$B$12","v":0},null,null,null,"AR8",{"$f":"A1","v":0},null,null,null,{"$f":"E1","v":"AR8"}]
["ELECTRIC UTILITIY ANNUAL REPORT",null,null,null,{"$f":"\"Annual Report Page \"&D61","v":"Annual Report Page 9"},{"$f":"A2","v":"ELECTRIC UTILITIY ANNUAL REPORT"},null,null,null,{"$f":"\"Annual Report Page \"&I61","v":"Annual Report Page 10"}]
[{"$f":"A7","v":"BALANCE SHEET ASSETS"},null,null,null,null,{"$f":"F7","v":"BALANCE SHEET LIABILITIES AND OWNERS EQUITY"}]
[{"$f":"IF('AR1'!B19=\"\",\"\",'AR1'!B19)","v":"12/31/19"},null,null,null,null,{"$f":"A4","v":"12/31/19"}]
[]
[]
["BALANCE SHEET ASSETS",null,null,null,"Table of Contents","BALANCE SHEET LIABILITIES AND OWNERS EQUITY"]
["Assets and Other Debits",null,{"$f":"\"Balance at Beginning of Year \" &\"(\"&YEAR('AR1'!B19)&\")\"","v":"Balance at Beginning of Year (2019)"},{"$f":"\"Balance at End of Year \" &\"(\"&YEAR('AR1'!B19)&\")\"","v":"Balance at End of Year (2019)"},{"$f":"IF(C62<-5,\"Does not balance\",IF(C62>5,\"Does not balance\",\"\"))","v":""},"Liabilities and Other Credits",null,{"$f":"C8","v":"Balance at Beginning of Year (2019)"},{"$f":"D8","v":"Balance at End of Year (2019)"}]
["Utility Plant",null,null,null,{"$f":"IF(D62<-5,\"Does not balance\",IF(D62>5,\"Does not balance\",\"\"))","v":""},"Current Liabilities"]
["Plant in service",null,{"$f":"'AR6'!C96","v":0},{"$f":"'AR6'!F96","v":0},null,"Accounts payable"]
["Accumulated depreciation and amortization",null,null,{"$f":"-'AR6'!G96","v":0},null,"Customer/Member deposits"]
["Construction work in progress",null,null,null,null,"Current maturities of Long-Term Debt"]
["Palo Verde sale leaseback (net of accumulated amortization)",null,null,null,null,"Accrued expenses"]
["Nuclear fuel (net of accumulate amortization)",null,null,null,null,"Accrued taxes"]
["Total Utility Plant",null,{"$f":"SUM(C10:C14)","v":0},{"$f":"SUM(D10:D14)","v":0},null,"Accrued interest"]
[null,null,null,null,null,"Notes payable to associated companies"]
["Other Property and Investments",null,null,null,null,"Short-term borrowing"]
["Non-utility property (net)",null,null,null,null,"Common dividends payable"]
["Investments in associated companies/organizations",null,null,null,null,"Other regulatory liabilities"]
["Investments in subsidiary companies/organizations",null,null,null,null,"Liabilities for asset retirement"]
["Nuclear decommissioning trust",null,null,null,null,"Other current liabilities"]
["Other investments",null,null,null,null,"Total Current Liabilities",null,{"$f":"SUM(H10:H21)","v":0},{"$f":"SUM(I10:I21)","v":0}]
["Total Other Property and Investments",null,{"$f":"SUM(C18:C22)","v":0},{"$f":"SUM(D18:D22)","v":0}]
[null,null,null,null,null,"Long Term Debt"]
["Current and Accrued Assets",null,null,null,null,"Long-Term Debt"]
["Cash and cash equivalents"]
["Customer and other receivables",null,null,null,null,"Deferred Credits"]
["Accounts receivable",null,null,null,null,"Deferred income tax"]
["Allowance for doubful accounts",null,null,null,null,"Regulatory liabilities"]
["Materials and supplies (at average cost)",null,null,null,null,"Accumulated deferred investment tax credits"]
["Notes receivable (related party due within one year)",null,null,null,null,"Liabilities for assest retirements"]
["Fossil fuel (at average cost)",null,null,null,null,"Liabilities for pension benefits"]
["Regulatory assets",null,null,null,null,"Customer advances"]
["Deferred debits",null,null,null,null,"Coal mine reclamation"]
["Other current assets",null,null,null,null,"Deferred revenues"]
["Total Fixed Assets",null,{"$f":"SUM(C26:C35)","v":0},{"$f":"SUM(D26:D35)","v":0},null,"Construction advances"]
["Total Assets and Other Debits",null,{"$f":"C15+C23+C36","v":0},{"$f":"D23+D36","v":0},null,"Deferred investment tax credit"]
[null,null,null,null,null,"Unrecognized tax benefits"]
[null,null,null,null,null,"Other deferred credits"]
[null,null,null,null,null,"Total Deferred Credits",null,{"$f":"SUM(H28:H39)","v":0},{"$f":"SUM(I28:I39)","v":0}]
[null,null,null,null,null,"Total Liabilites",null,{"$f":"H22+H25+H40","v":0},{"$f":"I40+I25+I22","v":0}]
[]
[null,null,null,null,null,"Capital Accounts"]
[null,null,null,null,null,"Common stock"]
[null,null,null,null,null,"Additional paid-in capital"]
[null,null,null,null,null,"Retained earnings"]
[null,null,null,null,null,"Memberships"]
[null,null,null,null,null,"Patronage capital"]
[null,null,null,null,null,"Accumulated other comprehensive"]
[null,null,null,null,null,"Total Capital",null,{"$f":"SUM(H44:H49)","v":0},{"$f":"SUM(I44:I49)","v":0}]
[null,null,null,null,null,"Total Liabilities and Capital",null,{"$f":"H50+H41","v":0},{"$f":"I50+I41","v":0}]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Note: Total liabilities and Capital must match total assets for the beginning and end of the year!  "]
[]
[]
[null,null,null,{"$f":"\"Page \"&D61","v":"Page 9"},null,null,null,null,{"$f":"\"Page \"&I61","v":"Page 10"}]
[null,null,null,{"$f":"'AR7'!J101+1","v":9},null,null,null,null,{"$f":"D61+1","v":10}]
[null,"Variances",{"$f":"C37-H51","v":0},{"$f":"D37-I51","v":0}]
[]
[]
[]
["Instructions: Fill out the Grey Cells with the relevant information.  Input 0 or none if there is nothing recorded in that account or there is no applicable information to report.",null,null,null,null,"Instructions: Fill out the Grey Cells with the relevant information.  Input 0 or none if there is nothing recorded in that account or there is no applicable information to report."]
[]
[]
[]
[null,null,{"$f":"IF(C37=0,\"Incomplete\",\"Complete\")","v":"Incomplete"},{"$f":"IF(D37=0,\"Incomplete\",\"Complete\")","v":"Incomplete"},null,null,null,{"$f":"IF(H51=0,\"Incomplete\",\"Complete\")","v":"Incomplete"},{"$f":"IF(I51=0,\"Incomplete\",\"Complete\")","v":"Incomplete"}]
[null,null,null,{"$f":"IF(C70=\"Incomplete\",\"Incomplete\",IF(D70=\"Incomplete\",\"Incomplete\",\"Complete\"))","v":"Incomplete"},null,null,null,null,{"$f":"IF(H70=\"Incomplete\",\"Incomplete\",IF(I70=\"Incomplete\",\"Incomplete\",\"Complete\"))","v":"Incomplete"},{"$f":"IF(D71=\"Incomplete\",\"Incomplete\",IF(I71=\"Incomplete\",\"Incomplete\",\"Complete\"))","v":"Incomplete"}]

{"sheet":"AR9","index":11,"n_rows":93,"n_cols":14,"rows_kept":93,"cut":false,"hidden":false,"merged":[[6,0,6,3],[88,0,89,3],[21,0,21,3],[38,0,38,3],[53,0,53,3]]}
[{"$f":"'AR1'!$B$12","v":0},null,null,null,"AR 9"]
["ELECTRIC UTILITIY ANNUAL REPORT",null,null,null,{"$f":"\"Annual Report Page \"&D93","v":"Annual Report Page 11"}]
[{"$f":"A7","v":"ELECTRIC COMPARATIVE INCOME STATEMENT"}]
[{"$f":"IF('AR1'!B19=\"\",\"\",'AR1'!B19)","v":"12/31/19"}]
[]
[]
["ELECTRIC COMPARATIVE INCOME STATEMENT"]
["Account No.","Calendar Year",{"$f":"\"Last Year                            \"&\" 01/01/\"&YEAR('AR1'!B19)-1&\" - 12/31/\"&YEAR('AR1'!B19)-1","v":"Last Year                             01/01/2018 - 12/31/2018"},{"$f":"\"Current Year                            \"&\" 01/01/\"&YEAR('AR1'!B19)&\" - 12/31/\"&YEAR('AR1'!B19)","v":"Current Year                             01/01/2019 - 12/31/2019"},"Table of Contents"]
[null,"Operating Revenue"]
[440,"Residential sales",null,null,null,null,null,{"$f":"ISBLANK(C10)","v":true},true,{"$f":"IF(H10=TRUE,\"Incomplete\",\"Complete\")","v":"Incomplete"},{"$f":"IF(I10=TRUE,\"Incomplete\",\"Complete\")","v":"Incomplete"},{"$f":"IF(J10=\"Incomplete\",\"Incomplete\",IF(K10=\"Incomplete\",\"Incomplete\",\"Complete\"))","v":"Incomplete"}]
[442,"Commercial and industrial sales",null,null,null,null,null,true,true,{"$f":"IF(H11=TRUE,\"Incomplete\",\"Complete\")","v":"Incomplete"},"Incomplete",{"$f":"IF(J11=\"Incomplete\",\"Incomplete\",IF(K11=\"Incomplete\",\"Incomplete\",\"Complete\"))","v":"Incomplete"}]
[444,"Public street and highway lighting",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete"]
[445,"Other sales to public authorities",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete"]
[446,"Sales to railroads and railways",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete"]
[447,"Sales for resale",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete"]
[448,"Interdepartmental sales",null,null,null,null,null,{"$f":"ISBLANK(C16)","v":true},{"$f":"ISBLANK(D16)","v":true},{"$f":"IF(H16=TRUE,\"Incomplete\",\"Complete\")","v":"Incomplete"},{"$f":"IF(I16=TRUE,\"Incomplete\",\"Complete\")","v":"Incomplete"},{"$f":"IF(J16=\"Incomplete\",\"Incomplete\",IF(K16=\"Incomplete\",\"Incomplete\",\"Complete\"))","v":"Incomplete"}]
[449,"Othe sales",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete",{"$f":"IF(L10=\"Incomplete\",\"Incomplete\",IF(L11=\"Incomplete\",\"Incomplete\",IF(L12=\"Incomplete\",\"Incomplete\",IF(L13=\"Incomplete\",\"Incomplete\",IF(L14=\"Incomplete\",\"Incomplete\",IF(L15=\"Incomplete\",\"Incomplete\",IF(L16=\"Incomplete\",\"Incomplete\",IF(L17=\"Incomplete\",\"Incomplete\",\"Complete\"))))))))","v":"Incomplete"}]
[449.1,"Provision for rate refunds",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete"]
[null,"Total Revenues",{"$f":"SUM(C10:C18)","v":0},{"$f":"SUM(D10:D18)","v":0}]
[]
[null,"Operating Expenses"]
["Steam Power Generation"]
[500,"Operation supervision and engineering",null,null,null,null,null,{"$f":"ISBLANK(C23)","v":true},{"$f":"ISBLANK(D23)","v":true},"Incomplete","Incomplete","Incomplete"]
[501,"Fuel",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete"]
[502,"Steam expenses",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete"]
[503,"Steam from other sources",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete"]
[504,"Steam transferred-Credit",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete"]
[505,"Electric expenses",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete"]
[506,"Miscellaneous steam power expense",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete"]
[507,"Rents",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete",{"$f":"IF(L18=\"Incomplete\",\"Incomplete\",IF(L23=\"Incomplete\",\"Incomplete\",IF(L24=\"Incomplete\",\"Incomplete\",IF(L25=\"Incomplete\",\"Incomplete\",IF(L26=\"Incomplete\",\"Incomplete\",IF(L27=\"Incomplete\",\"Incomplete\",IF(L28=\"Incomplete\",\"Incomplete\",IF(L29=\"Incomplete\",\"Incomplete\",IF(L30=\"Incomplete\",\"Incomplete\",\"Complete\")))))))))","v":"Incomplete"}]
[508,"Operation supplies and expenses",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete"]
[509,"Allowances",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete"]
[510,"Maintenance supervision and engineering",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete"]
[511,"Maintenance of structures",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete"]
[512,"Maintenance of boiler plant",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete"]
[513,"Maintenance of electric plant",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete"]
[514,"Maintenance of miscellaneous steam plant",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete"]
[515,"Maintenance of steam production plant",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete",{"$f":"IF(L31=\"Incomplete\",\"Incomplete\",IF(L32=\"Incomplete\",\"Incomplete\",IF(L33=\"Incomplete\",\"Incomplete\",IF(L34=\"Incomplete\",\"Incomplete\",IF(L35=\"Incomplete\",\"Incomplete\",IF(L36=\"Incomplete\",\"Incomplete\",IF(L37=\"Incomplete\",\"Incomplete\",IF(L38=\"Incomplete\",\"Incomplete\",\"Complete\"))))))))","v":"Incomplete"}]
["Nuclear Power Generation"]
[517,"Operation supervision and engineering",null,null,null,null,null,{"$f":"ISBLANK(C40)","v":true},true,"Incomplete","Incomplete","Incomplete"]
[518,"Nuclear fuel expense",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete"]
[519,"Coolants and water",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete"]
[520,"Steam expenses",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete"]
[521,"Steam from other sources",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete"]
[522,"Steam transferred-Credit",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete"]
[523,"Electric expenses",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete"]
[524,"Miscellaneous nuclear power expense",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete"]
[525,"Rents",null,null,null,null,null,{"$f":"ISBLANK(C48)","v":true},{"$f":"ISBLANK(D48)","v":true},{"$f":"IF(H48=TRUE,\"Incomplete\",\"Complete\")","v":"Incomplete"},{"$f":"IF(I48=TRUE,\"Incomplete\",\"Complete\")","v":"Incomplete"},{"$f":"IF(J48=\"Incomplete\",\"Incomplete\",IF(K48=\"Incomplete\",\"Incomplete\",\"Complete\"))","v":"Incomplete"},{"$f":"IF(L40=\"Incomplete\",\"Incomplete\",IF(L41=\"Incomplete\",\"Incomplete\",M17IF(L42=\"Incomplete\",\"Incomplete\",IF(L43=\"Incomplete\",\"Incomplete\",IF(L44=\"Incomplete\",\"Incomplete\",IF(L45=\"Incomplete\",\"Incomplete\",IF(L46=\"Incomplete\",\"Incomplete\",IF(L47=\"Incomplete\",\"Incomplete\",IF(L48=\"Incomplete\",\"Incomplete\",\"Complete\")))))))))","v":"Incomplete"}]
[528,"Maintenance supervision and engineering",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete"]
[529,"Maintenance of structures",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete"]
[530,"Maintenance of reactor plant equipment",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete"]
[531,"Maintenance of electric plant",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete"]
[532,"Maintenance of miscellaneous nuclear plant",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete"]
["Nuclear Power Generation"]
[632,"Contractual Services - Accounting",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete"]
[633,"Contractual Services - Legal",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete"]
[634,"Contractual Services - Management Fees",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete",{"$f":"IF(L49=\"Incomplete\",\"Incomplete\",IF(L50=\"Incomplete\",\"Incomplete\",IF(L51=\"Incomplete\",\"Incomplete\",IF(L52=\"Incomplete\",\"Incomplete\",IF(L53=\"Incomplete\",\"Incomplete\",IF(L55=\"Incomplete\",\"Incomplete\",IF(L56=\"Incomplete\",\"Incomplete\",IF(L57=\"Incomplete\",\"Incomplete\",\"Complete\"))))))))","v":"Incomplete"}]
[635,"Contractual Services - Water Testing",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete"]
[636,"Contractual Services - Other",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete"]
[640,"Rents",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete"]
[641,"Rental of Building/Real Property",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete"]
[642,"Rental of Equipment",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete"]
[650,"Transportation Expenses",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete"]
[657,"Insurance - General Liability",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete"]
[657.1,"Insurance - Health and Life",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete",{"$f":"IF(L58=\"Incomplete\",\"Incomplete\",IF(L59=\"Incomplete\",\"Incomplete\",IF(L60=\"Incomplete\",\"Incomplete\",IF(L61=\"Incomplete\",\"Incomplete\",IF(L62=\"Incomplete\",\"Incomplete\",IF(L63=\"Incomplete\",\"Incomplete\",IF(L64=\"Incomplete\",\"Incomplete\",IF(L65=\"Incomplete\",\"Incomplete\",\"Complete\"))))))))","v":"Incomplete"}]
[665,"Regulatory Commission Expense - Rate",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete"]
[670,"Bad Debt Expense",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete"]
[675,"Miscellaneous Expense",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete"]
[403,"Depreciation Expense ",null,{"$f":"'AR7'!J97","v":0},null,null,null,true,null,"Incomplete","Complete","Incomplete"]
[408,"Taxes Other Than Income",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete"]
[408.11,"Property Taxes",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete"]
[409,"Income Taxes",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete"]
[427.1,"Customer Security Deposit Interest",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete",{"$f":"IF(L66=\"Incomplete\",\"Incomplete\",IF(L67=\"Incomplete\",\"Incomplete\",IF(L68=\"Incomplete\",\"Incomplete\",IF(L69=\"Incomplete\",\"Incomplete\",IF(L70=\"Incomplete\",\"Incomplete\",IF(L71=\"Incomplete\",\"Incomplete\",IF(L72=\"Incomplete\",\"Incomplete\",IF(L73=\"Incomplete\",\"Incomplete\",\"Complete\"))))))))","v":"Incomplete"}]
[null,"Total Operating Expenses",{"$f":"SUM(C23:C73)","v":0},{"$f":"SUM(D23:D73)","v":0}]
[]
[null,"Operating Income / (Loss)",{"$f":"C19-C74","v":0},{"$f":"D19-D74","v":0}]
[]
[null,"Other Income / (Expense) "]
[419,"Interest and Dividend Income",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete"]
[421,"Non-Utility Income",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete"]
[426,"Miscellaneous Non-Utility (Expense)",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete"]
[427,"Interest (Expense)",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete"]
[null,"Total Other Income / (Expense)",{"$f":"SUM(C79:C82)","v":0},{"$f":"SUM(D79:D82)","v":0}]
[]
[null,"Net Income / (Loss) ",{"$f":"C76+C83","v":0},{"$f":"D76+D83","v":0}]
[]
[null,"Total number of employees",null,null,null,null,null,true,true,"Incomplete","Incomplete","Incomplete",{"$f":"IF(L79=\"Incomplete\",\"Incomplete\",IF(L80=\"Incomplete\",\"Incomplete\",IF(L81=\"Incomplete\",\"Incomplete\",IF(L82=\"Incomplete\",\"Incomplete\",IF(L87=\"Incomplete\",\"Incomplete\",\"Complete\")))))","v":"Incomplete"},{"$f":"IF(M17=\"Incomplete\",\"Incomplete\",IF(M30=\"Incomplete\",\"Incomplete\",IF(M38=\"Incomplete\",\"Incomplete\",IF(M48=\"Incomplete\",\"Incomplete\",IF(M57=\"Incomplete\",\"Incomplete\",IF(M65=\"Incomplete\",\"Incomplete\",IF(M73=\"Incomplete\",\"Incomplete\",IF(M87=\"Incomplete\",\"Incomplete\",\"Complete\"))))))))","v":"Incomplete"}]
[]
["Instructions: Fill out the Grey Cells with the relevant information.  Input 0 or none if there is nothing recorded in that account or there is no applicable information to report."]
[]
[]
[null,null,null,{"$f":"\"Page \"&D93","v":"Page 11"}]
[null,null,null,{"$f":"'AR8'!I61+1","v":11}]

{"sheet":"AR10","index":12,"n_rows":35,"n_cols":10,"rows_kept":35,"cut":false,"hidden":false,"merged":[[6,0,6,3],[22,1,26,3],[29,0,30,3]]}
[{"$f":"'AR1'!$B$12","v":0},null,null,null,"AR 10"]
["ELECTRIC UTILITIY ANNUAL REPORT",null,null,null,{"$f":"\"Annual Report Page \"&D35","v":"Annual Report Page 12"}]
[{"$f":"A7","v":"UTILITY SHUTOFFS / DISCONNECTS"}]
[{"$f":"IF('AR1'!B19=\"\",\"\",'AR1'!B19)","v":"12/31/19"}]
[]
[]
["UTILITY SHUTOFFS / DISCONNECTS"]
["Month","Termination without Notice R14-2-211.B","Termination with Notice R14-2-211.C","Other"]
["January",null,null,null,null,{"$f":"IF(B9<>\"\",\"Complete\",\"Incomplete\")","v":"Incomplete"},"Incomplete","Incomplete",{"$f":"IF(F9=\"Incomplete\",\"Incomplete\",IF(G9=\"Incomplete\",\"Incomplete\",IF(H9=\"Incomplete\",\"Incomplete\",\"Complete\")))","v":"Incomplete"}]
["February",null,null,null,null,"Incomplete","Incomplete","Incomplete",{"$f":"IF(F10=\"Incomplete\",\"Incomplete\",IF(G10=\"Incomplete\",\"Incomplete\",IF(H10=\"Incomplete\",\"Incomplete\",\"Complete\")))","v":"Incomplete"}]
["March",null,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete"]
["April",null,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete"]
["May",null,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete"]
["June",null,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete",{"$f":"IF(I9=\"Incomplete\",\"Incomplete\",IF(I10=\"Incomplete\",\"Incomplete\",IF(I11=\"Incomplete\",\"Incomplete\",IF(I12=\"Incomplete\",\"Incomplete\",IF(I12=\"Incomplete\",\"Incomplete\",IF(I13=\"Incomplete\",\"Incomplete\",IF(I14=\"Incomplete\",\"Incomplete\",\"Complete\")))))))","v":"Incomplete"}]
["July",null,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete"]
["August",null,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete"]
["September",null,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete"]
["October",null,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete"]
["November",null,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete"]
["December",null,null,null,null,"Incomplete","Incomplete","Incomplete","Incomplete",{"$f":"IF(I15=\"Incomplete\",\"Incomplete\",IF(I16=\"Incomplete\",\"Incomplete\",IF(I17=\"Incomplete\",\"Incomplete\",IF(I18=\"Incomplete\",\"Incomplete\",IF(I18=\"Incomplete\",\"Incomplete\",IF(I19=\"Incomplete\",\"Incomplete\",IF(I20=\"Incomplete\",\"Incomplete\",\"Complete\")))))))","v":"Incomplete"}]
["Total",{"$f":"SUM(B9:B20)","v":0},{"$f":"SUM(C9:C20)","v":0},0]
[]
["Other (description):",null,null,null,null,null,null,null,null,{"$f":"IF(B23<>\"\",\"Complete\",\"Incomplete\")","v":"Incomplete"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J14=\"Incomplete\",\"Incomplete\",IF(J20=\"Incomplete\",\"Incomplete\",IF(J23=\"Incomplete\",\"Incomplete\",\"Complete\")))","v":"Incomplete"}]
[]
[]
[]
[]
[]
["Instructions: Fill out the Grey Cells with the relevent information.  Input 0 or none if there is nothing recorded in that account or there is no applicable information to report."]
[]
[]
[]
[null,null,null,{"$f":"\"Page \"&D35","v":"Page 12"}]
[null,null,null,{"$f":"'AR9'!D93+1","v":12}]

{"sheet":"Drop down lists","index":13,"n_rows":50,"n_cols":22,"rows_kept":50,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,"Alabama",null,"Apache",null,"Company Name - DBA","Docket No","Address","Address2","City","Zip","State","Email Address",null,"ERRF"]
[null,null,null,null,null,null,null,null,"Alaska",null,"Cochise",null,"Ajo Improvement - Electric","E-01025A","PO Drawer 9",null,"Ajo",85321,"AZ","htaylor@fmi.com; dmedina@fmi.com",null,"Source Wells"]
[null,null,"Yes",null,null,null,"One",null,"Arizona",null,"Coconino",null,"Arizona Electric Power Cooperative","E-01773A",null,null,null,null,null,"jking@ssw.coop",null,"Treatment Systems"]
["All",null,"No",null,"Select Meter Size",null,"Two",null,"Arkansas",null,"Gila",null,"Arizona Public Service Company","E-01345A","PO Box 53999","Station 9708","Phoenix","85072-3999","AZ","Kerri.Carnes@aps.com",null,"Storage Tanks"]
["Residential",null,"N/A",null,"5/8\" x 3/4\" Meter",null,"Three",null,"California",null,"Graham",null,"Calpine Energy Solutions, LLC",null,"401 W. A St., Ste. 500",null,"San Diego",92101,"CA",null,null,"Booster Pumps"]
["Commercial",null,null,null,"3/4\"Meter",null,null,null,"Colorado",null,"Greenlee",null,"Columbus Electric","E-01851A",null,null,null,null,null,"chrism@col-coop.com",null,"Pressure Tanks"]
["Industrial",null,null,null,"1\" Meter",null,null,null,"Connecticut",null,"La Paz",null,"Dixie-Escalante Rural ","E-02044A",null,null,null,null,null,"ladell@dixiepower.com",null,"Customer Meters"]
["Bulk",null,null,null,"1-1/2\" Meter",null,null,null,"Delaware",null,"Maricopa",null,"Duncan Valley Electric","E-01073A",null,null,null,null,null,"stevel@dvec.org;kimberly@dvec.org",null,"Master Meters"]
["Stand-pipe",null,"MW",null,"2\" Meter",null,null,null,"Florida",null,"Mohave",null,"Garkane Energy","E-01891A",null,null,null,null,null,"marcus.lewis@garkane.com",null,"Main and Service Lines"]
["Fire",null,"KW",null,"3\" Meter",null,null,null,"Georgia",null,"Navajo",null,"Graham County Electric","E-01749A",null,null,null,null,null,"tashby@gce.coop",null,"Repair Equipment"]
["Hydrants",null,null,null,"4\" Meter",null,null,null,"Hawaii",null,"Pima",null,"Mohave Electric ","E-01750A",null,null,null,null,null,"pmink@mohaveelectric.com;mcolby@mohaveelectric.com",null,"Electrical Components"]
["Other",null,null,null,"6\" Meter",null,null,null,"Idaho",null,"Pinal",null,"Morenci Water & Electric Co. - Electric","E-01049A","PO Box 68",null,"Morenci",85540,"AZ","htaylor@fmi.com; dmedina@fmi.com"]
["N/A",null,null,null,"8\" Meter",null,null,null,"Illinois",null,"Santa Cruz",null,"Navopache Electric","E-01787A","1878 W. White Mountain Blvd.",null,"Lakeside",85929,"AZ","ggouker@navopache.org"]
[null,null,null,null,"10\" Meter",null,null,null,"Indiana",null,"Yavapai",null,"Nobel Americas Energy Solutions, LLC","E-03964A",null,null,null,null,null,"GBass@NobleSolutions.com"]
[null,null,null,null,"Fire",null,null,null,"Iowa",null,"Yuma",null,"Sulpher Springs Valley Electric","E-01575A",null,null,null,null,null,"chuber@ssvec.com;jgross@ssvec.com"]
[null,null,null,null,"Hydrant",null,null,null,"Kansas",null,"Multiple counties",null,"TEP","E-01933A","Attn:  Melissa Morales","PO Box 711, Mailstop HQE910","Tucson",85702,"AZ","JoSmith@uns.com;mmorales@tep.com"]
[null,null,null,null,"N/A",null,null,null,"Kentucky",null,"Statewide",null,"Trico Electric ","E-01461A",null,null,null,null,null,"bfickett@trico.coop;kathyw@trico.coop"]
[null,null,null,null,null,null,null,null,"Louisiana",null,null,null,"UNS Electric","E-04204A","Attn:  Melissa Morales","PO Box 711, Mailstop HQE910","Tucson",85702,"AZ","JoSmith@uns.com;mmorales@tep.com"]
[null,null,null,null,null,null,null,null,"Maine"]
["Sole Proprietorship (S)",null,null,null,null,null,null,null,"Maryland"]
["Partnership (P)",null,null,null,null,null,null,null,"Massachusetts"]
["Bankruptcy (B)",null,null,null,null,null,null,null,"Michigan"]
["Receivership ( R )",null,null,null,null,null,null,null,"Minnesota"]
["C Corporation ( C ) (Other than Association/Co-op)",null,null,null,null,null,null,null,"Mississippi"]
["Subchapter S Corporation (Z)",null,null,null,null,null,null,null,"Missouri"]
["Association/Co-op (A)",null,null,null,null,null,null,null,"Montana"]
["Other",null,null,null,null,null,null,null,"Nebraska"]
[null,null,null,null,null,null,null,null,"Nevada"]
[null,null,null,null,null,null,null,null,"New Hampshire"]
[null,null,null,null,null,null,null,null,"New Jersey"]
[null,null,null,null,null,null,null,null,"New Mexico"]
[null,null,null,null,null,null,null,null,"New York"]
["Original Filing",null,null,null,null,null,null,null,"North Carolina"]
["Original Filing - Rate Case Included",null,null,null,null,null,null,null,"North Dakota"]
["Corrected Filing",null,null,null,null,null,null,null,"Ohio"]
["Corrected Filing - Rate Case Included",null,null,null,null,null,null,null,"Oklahoma"]
[null,null,null,null,null,null,null,null,"Oregon"]
[null,null,null,null,null,null,null,null,"Pennsylvania"]
[null,null,null,null,null,null,null,null,"Rhode Island"]
[null,null,null,null,null,null,null,null,"South Carolina"]
["Regulatory Contact",null,null,null,null,null,null,null,"South Dakota"]
["Management Contact",null,null,null,null,null,null,null,"Tennessee"]
["Regulatory and Management Contact",null,null,null,null,null,null,null,"Texas"]
["On-Site Manager",null,null,null,null,null,null,null,"Utah"]
["Regulatory and On-Site Manager Contact",null,null,null,null,null,null,null,"Vermont"]
["Statutory Agent",null,null,null,null,null,null,null,"Virginia"]
["Attorney",null,null,null,null,null,null,null,"Washington"]
["Statutory Agent and Attorney",null,null,null,null,null,null,null,"West Virginia"]
["NA",null,null,null,null,null,null,null,"Wisconsin"]
[null,null,null,null,null,null,null,null,"Wyoming"]