{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["AR TOC","AR1","AR2","AR2-2","AR3","AR4","AR5","AR6-2","AR6","Drop down lists"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":13,"defined_names":477,"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":34,"n_cols":4,"rows_kept":34,"cut":false,"hidden":false,"merged":[[12,0,12,1],[28,0,31,4],[33,0,34,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/20"}]
[]
[]
["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"}]
["AR 6",{"$f":"'AR6'!AR_Page12","v":"UTILITY SHUTOFFS / DISCONNECTS"},{"$f":"'AR6'!D34","v":"Page 7"},{"$f":"'AR6'!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/20"]
[]
[]
[]
[]
[]
["ELECTRIC"]
[]
["To"]
[]
["Arizona Corporation Commission"]
[]
[]
[]
["Due on April 15th"]
["Email: Util-Compliance@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":"2021-02-09"},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/20"}]
[]
["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/20"}]
[]
[]
["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/20"}]
[]
["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/20"}]
[]
[]
[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/20"}]
[]
["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/20"}]
[]
[]
[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-2","index":7,"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/20"}]
[]
[]
["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":{"$error":"#REF!"}}]
[null,null,null,null,null,null,{"$f":"#REF!+1","v":{"$error":"#REF!"}}]

{"sheet":"AR6","index":8,"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 6"]
["ELECTRIC UTILITIY ANNUAL REPORT",null,null,null,{"$f":"\"Annual Report Page \"&D35","v":"Annual Report Page 7"}]
[{"$f":"A7","v":"UTILITY SHUTOFFS / DISCONNECTS"}]
[{"$f":"IF('AR1'!B19=\"\",\"\",'AR1'!B19)","v":"12/31/20"}]
[]
[]
["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 7"}]
[null,null,null,{"$f":"'AR5'!I66+1","v":7}]

{"sheet":"Drop down lists","index":9,"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","PO Box 670",null,"Benson",85602,"AZ","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","PO Box 63170",null,"Deming",88030,"NM","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","71 E. Hwy 56",null,"Beryl","884714-5197","UT","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","PO Box 440",null,"Duncan",85534,"AZ","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","PO Box 465",null,"Loa",84747,"UT","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","PO Drawer B",null,"Pima",85543,"AZ","tashby@gce.coop",null,"Repair Equipment"]
["Hydrants",null,null,null,"4\" Meter",null,null,null,"Hawaii",null,"Pima",null,"Mohave Electric Cooperative, Inc.","E-01750A","PO Box 22530",null,"Bullhead City","86439-2530","AZ","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","350 N. Haskill Ave.",null,"Willcox",85643,"AZ","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","PO Box 930",null,"Marana","85653-0930","AZ","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"]