{"text_format":"1","workbook":"xlsx","n_sheets":59,"sheets":["Macros","I-A","I-A-1","II-B","II-B-1 Plant","II-B-2 General Plant","II-B-3 Comm. Equip.","II-B-4 CWIP","II-B-5 Depreciation","II-B-6 Plant Future","II-B-7 Accum. Provisions","II-B-8 M&S","II-B-9 CWCapital","II-B-10 Prepayments","II-B-11 Rate Base Other","II-B-12 Reg. Assets","II-C-2.1","II-C-2.2","II-C-2.2a","II-C-2.3","II-C-2.3a","II-C-2.4","II-C-2.4a","II-C-2.5","II-C-2.7","II-C-2.8","II-C-2.9","II-D-1 O&M","II-D-2 A&G","II-D-3 Payroll","II-D-4 Exclusions","II-E-1 Dep. Exp.","II-E-2 Taxes Other","II-E-3 FIT","II-E-3-Attach","II-E-3.9","II-E-3.15","II-E-3.16","II-E-4 Other Expenses","II-E-4.6 Monthly Rate Case Exp","II-E-5 Other Revenues","II-F Alloc_Data","II-F Alloc_Factor","II-G","II-I-1","III-A-1 Wholesale TCOS","IV-J-1-Revenue Summary","Rate Design Summary","Residential","Secondary- Small","Secondary-Large","Primary","Transmission","Nuclear Decom Fee","CTC","SCTC","TC","SBF Fee","TCOS Calculation"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":53,"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":"Macros","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"I-A","index":1,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"PUBLIC UTILITY COMMISSION OF TEXAS"]
[null,"UTILITY COMPANY NAME"]
[null,"I-A COST OF SERVICE SUMMARY"]
[null,"TEST YEAR ENDING XX/XX/2XXX"]
[null,"DOCKET XXXXX"]
[]
[]
[]
["Line","Description","Reference","Amount","Adjustment","Amount"]
["No.",null,"Schedule","at","to ","at"]
[null,null,null,"Existing Rates","Existing Rates","Proposed Rates"]
[]
[1,"Transmission and Distribution Cost of Service","1-A-1",0,0,{"$f":"+D15+E15","v":0}]
[2]
[3,"System Benefit Fee",null,0,0,{"$f":"+D17+E17","v":0}]
[4]
[5,"Nuclear Decommissioning",null,0,0,{"$f":"+D19+E19","v":0}]
[6,"TCRF",null,0,0,{"$f":"+D20+E20","v":0}]
[7,"System Restoration Costs ADIT Credit",null,0,0,0]
[8,"Unbundled Cost of Service Credit",null,0,0,0]
[9,"TC1",null,0,0,0]
[10,"TC2",null,0,0,0]
[11,"Rider A",null,0,0,0]
[12,"Rider B",null,0,0,0]
[13]
[14]
[15]
[16,"TOTAL NON-BYPASSABLE DELIVERY CHARGE",null,{"$f":"SUM(D15:D26)","v":0},{"$f":"SUM(E15:E26)","v":0},{"$f":"SUM(F15:F26)","v":0}]

{"sheet":"I-A-1","index":2,"n_rows":63,"n_cols":13,"rows_kept":63,"cut":false,"hidden":false,"merged":[]}
[]
[null,"PUBLIC UTILITY COMMISSION OF TEXAS"]
[null,"XXXXXX COMPANY"]
[null,"I-A-1 SUMMARY OF TEXAS RETAIL"]
[null,"TEST YEAR ENDING X/XX/XXXX"]
[null,"DOCKET XXXXX"]
[]
[null,null,null,1,2,3,4,5,6,7,8,9]
[null,null,null,"Test Year",null,"Company","Transmission","Distribution","Metering","Billing","T&D Customer",null,"Check"]
[null,"Description","Reference","Total","Company","Total","Function","Function","Function","Function","Service","Total"]
[null,null,"Schedule","Electric","Adjustments","Request","(TRAN)","(DIST)","(MET)","(TBILL)","(TDCS)","TX-Retail"]
[]
[]
[null,"Operating and Maintenance Expenses"]
[null,"Depreciation & Amortization Expenses"]
[null,"Taxes Other Than Federal Income Tax"]
[null,"Federal Income Tax"]
[]
[null,"Return on  Rate Base"]
[]
[null,"TOTAL COST OF SERVICE"]
[]
[null,"Decommissioning Expense"]
[]
[null,"Other Non-Bypassable Charges"]
[]
[null,"Minus:  Other Revenues"]
[]
[null,"TOTAL ADJUSTED REVENUE REQUIREMENT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}}]

{"sheet":"II-B","index":3,"n_rows":36,"n_cols":13,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[null,"PUBLIC UTILITY COMMISSION OF TEXAS"]
[null,"XXXXXX COMPANY"]
[null,"II-B SUMMARY OF RATE BASE"]
[null,"TEST YEAR ENDING X/XX/XXXX"]
[null,"DOCKET XXXXX"]
[]
[null,null,null,1,2,3,4,5,6,7,8,9]
[null,null,null,"Test Year",null,"Company"]
[null,null,"Reference","Total","Company","Total","TRAN","DIST","MET","TBILL","TDCS","Total","Check"]
[null,"Description","Schedule","Electric","Adjustments","Request",null,null,null,null,null,"TX-Retail"]
[]
[]
[null,"Original Cost of Plant"]
[null,"General Plant"]
[null,"Total Plant"]
[null,"Minus:  Accumulated Depreciation"]
[]
[null,"Net Plant In Service"]
[]
[null,"Other Rate Base Items:"]
[null,"CWIP"]
[null,"Cash Working Capital"]
[null,"Prepayments"]
[null,"Materials & Supplies"]
[null,"Plant Held for Future Use"]
[null,"ADIT  & FAS 109 Accts."]
[null,"Customer Deposits"]
[null,"Reserve For Insurance"]
[null,"Subtotal"]
[]
[null,"TOTAL RATE BASE"]
[]
[null,"Rate of Return"]
[]
[null,"RETURN ON RATE BASE"]

{"sheet":"II-B-1 Plant","index":4,"n_rows":52,"n_cols":180,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[]
[null,"PUBLIC UTILITY COMMISSION OF TEXAS"]
[null,"XXXXXX COMPANY"]
[null,"II-B-1 RATE BASE ACCOUNTS - PLANT"]
[null,"TEST YEAR ENDING X/XX/XXXX"]
[null,"DOCKET XXXXX"]
[]
[null," ",null,null,1,2,3,4,5,6,7,8,9,10,11,12,13]
[null,null,null,null,null,null,null,"Company"]
[null,"Account","Description","Reference","Total ","Non-Regulated or","Known","Total","FF","Functionalization","Allocation to","TRAN","DIST","MET","TBILL","TDCS","Total"]
[null,"Number",null,"Schedule","Company"," Non-Electric","Change","Electric","#","Factor","Texas",null,null,null,null,null,null,"CHECK"]
[null,null,null,null,null,null,null,null,null,"Name"]
[]
[null,"Intangible Plant-Gross",null,"II-B-1"]
[null,"A301","Organization"]
[null,"A302","Franchise & Consents"]
[null,"A303","Miscellaneous Intangible Plant"]
[null,null,"Subtotal"]
[]
[null,"Transmission Plant-Gross",null,"II-B-1"]
[null,"A349","Land Owned in Fee"]
[null,"A350","Land and Land Rights"]
[null,"A352","Structures and Improvements"]
[null,"A353","Station Equipment"]
[null,"A354","Towers and Fixtures"]
[null,"A355","Poles and Fixtures"]
[null,"A356","O.H. Conductors & Devices"]
[null,"A357","Undergound Conduit"]
[null,"A358","Underground Conductors"]
[null,"A359","Roads and Trails"]
[null,null,"Subtotal"]
[]
[null,"Distribution Plant-Gross",null,"II-B-1"]
[null,"A360","Land and Land Rights"]
[null,"A361","Structures and Improvements"]
[null,"A362","Station Equipment"]
[null,"A363","Storage Battery Equipment"]
[null,"A364P","Poles,Towers & Fixtures-Primary"]
[null,"A365P","O.H. Conductors & Devices-Primary"]
[null,"A366P","Underground Conduits-Primary"]
[null,"A367P","U.G. Conductors & Devices-Primary"]
[null,"A368P","Line Transformers-Primary"]
[null,"A369","Services"]
[null,"A370","Meters"]
[null,"A371","Install. on Customer Prem."]
[null,"A372","Leased Prop. on Cust. Premises"]
[null,"A373","Street Lights"]
[null,"A374","Land Owned in Fee"]
[null,null,"Subtotal"]
[]
[null,"TOTAL INT, TRAN, DIST PLANT-GROSS",null,"II-B-1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+#REF!+#REF!+AC31+AC49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+AD31+AD49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+AE31+AE49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+AF31+AF49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+AG31+AG49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+AH31+AH49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+AI31+AI49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+AJ31+AJ49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+AK31+AK49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+AL31+AL49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+AM31+AM49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+AN31+AN49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+AO31+AO49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+AP31+AP49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+AQ31+AQ49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+AR31+AR49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+AS31+AS49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+AT31+AT49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+AU31+AU49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+AV31+AV49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+AW31+AW49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+AX31+AX49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+AY31+AY49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+AZ31+AZ49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+BA31+BA49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+BB31+BB49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+BC31+BC49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+BD31+BD49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+BE31+BE49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+BF31+BF49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+BG31+BG49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+BH31+BH49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+BI31+BI49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+BJ31+BJ49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+BK31+BK49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+BL31+BL49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+BM31+BM49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+BN31+BN49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+BO31+BO49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+BP31+BP49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+BQ31+BQ49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+BR31+BR49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+BS31+BS49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+BT31+BT49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+BU31+BU49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+BV31+BV49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+BW31+BW49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+BX31+BX49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+BY31+BY49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+BZ31+BZ49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+CA31+CA49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+CB31+CB49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+CC31+CC49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+CD31+CD49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+CE31+CE49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+CF31+CF49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+CG31+CG49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+CH31+CH49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+CI31+CI49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+CJ31+CJ49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+CK31+CK49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+CL31+CL49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+CM31+CM49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+CN31+CN49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+CO31+CO49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+CP31+CP49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+CQ31+CQ49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+CR31+CR49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+CS31+CS49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+CT31+CT49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+CU31+CU49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+CV31+CV49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+CW31+CW49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+CX31+CX49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+CY31+CY49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+CZ31+CZ49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+DA31+DA49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+DB31+DB49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+DC31+DC49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+DD31+DD49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+DE31+DE49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+DF31+DF49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+DG31+DG49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+DH31+DH49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+DI31+DI49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+DJ31+DJ49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+DK31+DK49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+DL31+DL49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+DM31+DM49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+DN31+DN49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+DO31+DO49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+DP31+DP49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+DQ31+DQ49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+DR31+DR49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+DS31+DS49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+DT31+DT49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+DU31+DU49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+DV31+DV49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+DW31+DW49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+DX31+DX49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+DY31+DY49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+DZ31+DZ49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+EA31+EA49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+EB31+EB49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+EC31+EC49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+ED31+ED49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+EE31+EE49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+EF31+EF49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+EG31+EG49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+EH31+EH49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+EI31+EI49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+EJ31+EJ49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+EK31+EK49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+EL31+EL49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+EM31+EM49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+EN31+EN49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+EO31+EO49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+EP31+EP49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+EQ31+EQ49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+ER31+ER49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+ES31+ES49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+ET31+ET49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+EU31+EU49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+EV31+EV49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+EW31+EW49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+EX31+EX49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+EY31+EY49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+EZ31+EZ49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+FA31+FA49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+FB31+FB49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+FC31+FC49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+FD31+FD49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+FE31+FE49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+FF31+FF49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+FG31+FG49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+FH31+FH49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+FI31+FI49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+FJ31+FJ49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+FK31+FK49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+FL31+FL49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+FM31+FM49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+FN31+FN49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+FO31+FO49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+FP31+FP49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+FQ31+FQ49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+FR31+FR49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+FS31+FS49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+FT31+FT49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+FU31+FU49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+FV31+FV49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+FW31+FW49","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+FX31+FX49","v":{"$error":"#REF!"}}]
[null,"TOTAL TRAN, DIST PLANT-GROSS",null,"II-B-1"]

{"sheet":"II-B-2 General Plant","index":5,"n_rows":31,"n_cols":18,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[null,"PUBLIC UTILITY COMMISSION OF TEXAS"]
[null,"XXXXXX COMPANY"]
[null,"II-B-2 RATE BASE ACCOUNTS - GENERAL PLANT"]
[null,"TEST YEAR ENDING X/XX/XXXX"]
[null,"DOCKET XXXXX"]
[]
[null," ",null,null,1,2,3,4,5,6,7,8,9,10,11,12,13]
[null,null,null,null,null,null,null,"Company"]
[null,"Account","Description","Reference","Total ","Non-Regulated or","Known","Total","FF","Functionalization","Allocation to","TRAN","DIST","MET","TBILL","TDCS","Total"]
[null,"Number",null,"Schedule","Company"," Non-Electric","Change","Electric","#","Factor","Texas",null,null,null,null,null,null,"CHECK"]
[null,null,null,null,null,null,null,null,null,"Name"]
[]
[null,"General Plant-Gross",null,"II-B-2"]
[null,"A388","Land Owned in Fee"]
[null,"A389","Land and Land Rights"]
[null,"A390","Structures and Improvements"]
[null,"A391","Office Furniture & Equip."]
[null,"A392","Transportation Equipment"]
[null,"A393","Store Equipment "]
[null,"A394","Tools, Shop & Garage Equip."]
[null,"A395","Laboratory Equipment"]
[null,"A396","Power Operated Equipment"]
[null,null,"Subtotal"]
[]
[null,"A398","Misc. Equipment"]
[]
[]
[null,null,"Subtotal"]
[]
[null,"TOTAL GENERAL PLANT GROSS",null,"II-B-2"]

{"sheet":"II-B-3 Comm. Equip.","index":6,"n_rows":23,"n_cols":18,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[null,"PUBLIC UTILITY COMMISSION OF TEXAS"]
[null,"XXXXXX COMPANY"]
[null,"II-B-3 RATE BASE ACCOUNTS - COMMUNICATION EQUIP."]
[null,"TEST YEAR ENDING X/XX/XXXX"]
[null,"DOCKET XXXXX"]
[]
[null," ",null,null,1,2,3,4,5,6,7,8,9,10,11,12,13]
[null,null,null,null,null,null,null,"Company"]
[null,"Account","Description","Reference","Total ","Non-Regulated or","Known","Total","FF","Functionalization","Allocation to","TRAN","DIST","MET","TBILL","TDCS","Total"]
[null,"Number",null,"Schedule","Company"," Non-Electric","Change","Electric","#","Factor","Texas",null,null,null,null,null,null,"CHECK"]
[null,null,null,null,null,null,null,null,null,"Name"]
[]
[null,"A397","Total Communication Equipment","II-B-3"]
[null,null,"Subtotal"]
[]
[null,"TOTAL COMMUNICATION EQUIPMENT"]
[]
[null,"TOTAL GENERAL PLANT GROSS INCLUDE. COMM. EQUIP.",null,"II-B-2-3"]
[]
[null,"TOTAL PLANT IN SERVICE-GROSS (INCL. INTANGIBLES)",null,"II-B-1-3"]
[]
[null,"TOTAL PLANT IN SERVICE-GROSS (EXCL. INTANGIBLES)",null,"II-B-1-3"]

{"sheet":"II-B-4 CWIP","index":7,"n_rows":18,"n_cols":18,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,"PUBLIC UTILITY COMMISSION OF TEXAS"]
[null,"XXXXXX COMPANY"]
[null,"II-B-4 RATE BASE ACCOUNTS - CWIP"]
[null,"TEST YEAR ENDING X/XX/XXXX"]
[null,"DOCKET XXXXX"]
[]
[null," ",null,null,1,2,3,4,5,6,7,8,9,10,11,12,13]
[null,null,null,null,null,null,null,"Company"]
[null,"Account","Description","Reference","Total ","Non-Regulated or","Known","Total","FF","Functionalization","Allocation to","TRAN","DIST","MET","TBILL","TDCS","Total"]
[null,"Number",null,"Schedule","Company"," Non-Electric","Change","Electric","#","Factor","Texas",null,null,null,null,null,null,"CHECK"]
[null,null,null,null,null,null,null,null,null,"Name"]
[]
[null,null,"Construction Work in Progress"]
[null,"A107","CWIP"]
[null,null,"Subtotal"]
[]
[null,"TOTAL CWIP",null,"II-B-4"]

{"sheet":"II-B-5 Depreciation","index":8,"n_rows":83,"n_cols":18,"rows_kept":83,"cut":false,"hidden":false,"merged":[]}
[]
[null,"PUBLIC UTILITY COMMISSION OF TEXAS"]
[null,"XXXXXX COMPANY"]
[null,"II-B-5 RATE BASE ACCOUNTS DEPRECIATION - PLANT"]
[null,"TEST YEAR ENDING X/XX/XXXX"]
[null,"DOCKET XXXXX"]
[]
[null," ",null,null,1,2,3,4,5,6,7,8,9,10,11,12,13]
[null,null,null,null,null,null,null,"Company"]
[null,"Account","Description","Reference","Total ","Non-Regulated or","Known","Total","FF","Functionalization","Allocation to","TRAN","DIST","MET","TBILL","TDCS","Total"]
[null,"Number",null,"Schedule","Company"," Non-Electric","Change","Electric","#","Factor","Texas",null,null,null,null,null,null,"CHECK"]
[null,null,null,null,null,null,null,null,null,"Name"]
[]
[null,"Intangible Plant"]
[null,"Accumulated Depreciation",null,"II-B-5"]
[null,"A301","Organization"]
[null,"A302","Franchise & Consents"]
[null,"A303","Miscellaneous Intangible Plant"]
[null,null,"Subtotal"]
[]
[null,"Transmission Plant"]
[null,"Accumulated Depreciation",null,"II-B-5"]
[null,"A349","Land Owned in Fee"]
[null,"A350","Land and Land Rights"]
[null,"A352","Structures and Improvements"]
[null,"A353","Station Equipment"]
[null,"A354","Towers and Fixtures"]
[null,"A355","Poles and Fixtures"]
[null,"A356","O.H. Conductors & Devices"]
[null,"A357","Undergound Conduit"]
[null,"A358","Underground Conductors"]
[null,"A359","Roads and Trails"]
[null,null,"Subtotal"]
[]
[null,"Distribution Plant"]
[null,"Accumulated Depreciation",null,"II-B-5"]
[null,"A360","Land and Land Rights"]
[null,"A361","Structures and Improvements"]
[null,"A362","Station Equipment"]
[null,"A363","Storage Battery Equipment"]
[null,"A364P","Poles,Towers & Fixtures-Primary"]
[null,"A365P","O.H. Conductors & Devices-Primary"]
[null,"A366P","Underground Conduits-Primary"]
[null,"A367P","U.G. Conductors & Devices-Primary"]
[null,"A368P","Line Transformers-Primary"]
[null,"A369","Services"]
[null,"A370","Meters"]
[null,"A371","Install. on Customer Prem."]
[null,"A372","Leased Prop. on Cust. Premises"]
[null,"A373","Street Lights"]
[null,null,"Subtotal"]
[]
[null,"TOTAL INT, TRAN, DIST PLANT-ACCUM DEP.",null,"II-B-5"]
[null,"TOTAL TRAN, DIST PLANT-ACCUM DEP.",null,"II-B-5"]
[]
[null,"TOTAL INT, TRAN, DIST PLANT-NET",null,"II-B-1 - II-B-5"]
[null,"TOTAL TRAN, DIST PLANT-NET",null,"II-B-1 - II-B-5"]
[]
[null,"General Plant",null,"II-B-5"]
[null,"Accumulated Depreciation"]
[null,"A388","Land Owned in Fee"]
[null,"A389","Land and Land Rights"]
[null,"A390","Structures and Improvements"]
[null,"A391","Office Furniture & Equip."]
[null,"A392","Transportation Equipment"]
[null,"A393","Store Equipment "]
[null,"A394","Tools, Shop & Garage Equip."]
[null,"A395","Laboratory Equipment"]
[null,"A396","Power Operated Equipment"]
[null,null,"Subtotal"]
[]
[null,"A397","Communication Equipment"]
[null,"A398","Misc. Equipment"]
[null,"A399","Lignite Reserve Depletable"]
[null,"A399","Other Tangible-Deprc."]
[null,null,"Subtotal"]
[]
[null,"TOTAL ACCUM. DEP. FOR GENERAL PLANT",null,"II-B-5"]
[null,"TOTAL GENERAL PLANT-NET",null,"II-B-2 - II-B-5"]
[]
[null,"TOTAL PLANT IN SERVICE NET (INCL. INTANGIBLES)",null,"II-B-1-3 - II-B-5"]
[]
[null,"TOTAL PLANT IN SERVICE NET (EXCL. INTANGIBLES)",null,"II-B-1-3 - II-B-5"]

{"sheet":"II-B-6 Plant Future","index":9,"n_rows":19,"n_cols":18,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,"PUBLIC UTILITY COMMISSION OF TEXAS"]
[null,"XXXXXX COMPANY"]
[null,"II-B-6 RATE BASE ACC. - PLANT HELD FOR FUTURE USE"]
[null,"TEST YEAR ENDING X/XX/XXXX"]
[null,"DOCKET XXXXX"]
[]
[null," ",null,null,1,2,3,4,5,6,7,8,9,10,11,12,13]
[null,null,null,null,null,null,null,"Company"]
[null,"Account","Description","Reference","Total ","Non-Regulated or","Known","Total","FF","Functionalization","Allocation to","TRAN","DIST","MET","TBILL","TDCS","Total"]
[null,"Number",null,"Schedule","Company"," Non-Electric","Change","Electric","#","Factor","Texas",null,null,null,null,null,null,"CHECK"]
[null,null,null,null,null,null,null,null,null,"Name"]
[]
[null,"Other Rate Base Items"]
[]
[null,"A105","Plant Held for Future Use","II-B-6"]
[null,null,"Subtotal"]
[]
[null,"TOTAL PLANT HELD FOR FUTURE USE",null,"II-B-6"]

{"sheet":"II-B-7 Accum. Provisions","index":10,"n_rows":22,"n_cols":18,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[null,"PUBLIC UTILITY COMMISSION OF TEXAS"]
[null,"XXXXXX COMPANY"]
[null,"II-B-7 RATE BASE ACCOUNTS - ACCUM. PROVISIONS"]
[null,"TEST YEAR ENDING X/XX/XXXX"]
[null,"DOCKET XXXXX"]
[]
[null," ",null,null,1,2,3,4,5,6,7,8,9,10,11,12,13]
[null,null,null,null,null,null,null,"Company"]
[null,"Account","Description","Reference","Total ","Non-Regulated or","Known","Total","FF","Functionalization","Allocation to","TRAN","DIST","MET","TBILL","TDCS","Total"]
[null,"Number",null,"Schedule","Company"," Non-Electric","Change","Electric","#","Factor","Texas",null,null,null,null,null,null,"CHECK"]
[null,null,null,null,null,null,null,null,null,"Name"]
[]
[null,"Other Rate Base Items"]
[]
[null,"A.CD","Customer Deposits","II-B-7"]
[null,null,"Unclaimed customer deposits","II-B-7"]
[null,null,"Subtotal"]
[]
[null,"Accumulated Deferred Income Taxes",null,"II-B-7"]
[]
[null,"TOTAL ACCUMULATED PROVISIONS",null,"II-B-7"]

{"sheet":"II-B-8 M&S","index":11,"n_rows":21,"n_cols":18,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,"PUBLIC UTILITY COMMISSION OF TEXAS"]
[null,"XXXXXX COMPANY"]
[null,"II-B-8 RATE BASE ACC. - MATERIALS & SUPPLIES"]
[null,"TEST YEAR ENDING X/XX/XXXX"]
[null,"DOCKET XXXXX"]
[]
[null," ",null,null,1,2,3,4,5,6,7,8,9,10,11,12,13]
[null,null,null,null,null,null,null,"Company"]
[null,"Account","Description","Reference","Total ","Non-Regulated or","Known","Total","FF","Functionalization","Allocation to","TRAN","DIST","MET","TBILL","TDCS","Total"]
[null,"Number",null,"Schedule","Company"," Non-Electric","Change","Electric","#","Factor","Texas",null,null,null,null,null,null,"CHECK"]
[null,null,null,null,null,null,null,null,null,"Name"]
[]
[null,"Other Rate Base Items"]
[null,"Working Capital                                                                       (MONTHLY)"]
[null,null,"Materials and Supplies"]
[null,154,"Material and Supplies","II-B-8"]
[null,163,"Undistributed M&S Expenses"]
[null,null,"Subtotal"]
[]
[null,"TOTAL MATERIALS & SUPPLIES",null,"II-B-8"]

{"sheet":"II-B-9 CWCapital","index":12,"n_rows":21,"n_cols":18,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,"PUBLIC UTILITY COMMISSION OF TEXAS"]
[null,"XXXXXX COMPANY"]
[null,"II-B-9 RATE BASE ACCOUNTS - CASH WORKING CAPITAL"]
[null,"TEST YEAR ENDING X/XX/XXXX"]
[null,"DOCKET XXXXX"]
[]
[null," ",null,null,1,2,3,4,5,6,7,8,9,10,11,12,13]
[null,null,null,null,null,null,null,"Company"]
[null,"Account","Description","Reference","Total ","Non-Regulated or","Known","Total","FF","Functionalization","Allocation to","TRAN","DIST","MET","TBILL","TDCS","Total"]
[null,"Number",null,"Schedule","Company"," Non-Electric","Change","Electric","#","Factor","Texas",null,null,null,null,null,null,"CHECK"]
[null,null,null,null,null,null,null,null,null,"Name"]
[]
[null,"Other Rate Base Items"]
[null,"Working Capital",null,"II-B-9"]
[null,null,"Cash Working Capital"]
[null,null,"Subtotal"]
[]
[null,"TOTAL CASH WORKING CAPITAL",null,"II-B-9"]
[]
[null,"TOTAL WORKING CAPITAL",null,"II-B-8-9"]

{"sheet":"II-B-10 Prepayments","index":13,"n_rows":26,"n_cols":18,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[null,"PUBLIC UTILITY COMMISSION OF TEXAS"]
[null,"XXXXXX COMPANY"]
[null,"II-B-10 RATE BASE ACCOUNTS - PREPAYMENTS"]
[null,"TEST YEAR ENDING X/XX/XXXX"]
[null,"DOCKET XXXXX"]
[]
[null," ",null,null,1,2,3,4,5,6,7,8,9,10,11,12,13]
[null,null,null,null,null,null,null,"Company"]
[null,"Account","Description","Reference","Total ","Non-Regulated or","Known","Total","FF","Functionalization","Allocation to","TRAN","DIST","MET","TBILL","TDCS","Total"]
[null,"Number",null,"Schedule","Company"," Non-Electric","Change","Electric","#","Factor","Texas",null,null,null,null,null,null,"CHECK"]
[null,null,null,null,null,null,null,null,null,"Name"]
[]
[null,"Other Rate Base Items"]
[null,"Working Capital","(MONTHLY)"]
[null,165,"Prepayments","II-B-10"]
[null,null,"Local Gross Receipts & Sales Tax"]
[null,null,"Property"]
[null,null,"Sales Tax Collections"]
[null,null,"Francise tax"]
[null,null,"Dues"]
[null,null,"Subtotal"]
[]
[null,"TOTAL PREPAYMENTS",null,"II-B-10"]
[]
[null,"WORKING CAPITAL TOTAL",null,"II-B-8-10"]

{"sheet":"II-B-11 Rate Base Other","index":14,"n_rows":22,"n_cols":18,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[null,"PUBLIC UTILITY COMMISSION OF TEXAS"]
[null,"XXXXXX COMPANY"]
[null,"II-B-11 RATE BASE ACCOUNTS - OTHER"]
[null,"TEST YEAR ENDING X/XX/XXXX"]
[null,"DOCKET XXXXX"]
[]
[null," ",null,null,1,2,3,4,5,6,7,8,9,10,11,12,13]
[null,null,null,null,null,null,null,"Company"]
[null,"Account","Description","Reference","Total ","Non-Regulated or","Known","Total","FF","Functionalization","Allocation to","TRAN","DIST","MET","TBILL","TDCS","Total"]
[null,"Number",null,"Schedule","Company"," Non-Electric","Change","Electric","#","Factor","Texas",null,null,null,null,null,null,"CHECK"]
[null,null,null,null,null,null,null,null,null,"Name"]
[]
[null,"Other Rate Base Items"]
[]
[]
[]
[]
[]
[]
[]
[null,"TOTAL OTHER RATE BASE ITEMS",null,"II-B-11"]

{"sheet":"II-B-12 Reg. Assets","index":15,"n_rows":30,"n_cols":18,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[null,"PUBLIC UTILITY COMMISSION OF TEXAS"]
[null,"XXXXXX COMPANY"]
[null,"II-B-12 RATE BASE ACCOUNTS - REGULATORY ASSETS"]
[null,"TEST YEAR ENDING X/XX/XXXX"]
[null,"DOCKET XXXXX"]
[]
[null," ",null,null,1,2,3,4,5,6,7,8,9,10,11,12,13]
[null,null,null,null,null,null,null,"Company"]
[null,"Account","Description","Reference","Total ","Non-Regulated or","Known","Total","FF","Functionalization","Allocation to","TRAN","DIST","MET","TBILL","TDCS","Total"]
[null,"Number",null,"Schedule","Company"," Non-Electric","Change","Electric","#","Factor","Texas",null,null,null,null,null,null,"CHECK"]
[null,null,null,null,null,null,null,null,null,"Name"]
[]
[null,"Other Rate Base Items"]
[null,"Regulatory Assets/(liabilities) in Rate Base",null,"II-B-12"]
[null,null,"Regulatory Asset A"]
[null,null,"Regulatory Asset B"]
[null,null,"Regulatory Asset C"]
[null,null,"Regulatory Asset D"]
[null,null,"Subtotal"]
[]
[null,"TOTAL REGULATORY ASSETS",null,"II-B-12"]
[]
[null,"TOTAL OTHER RATE BASE ITEMS",null,"II-B-6-12"]
[]
[null,"TOTAL RATE BASE",null,"II-B-1-12"]
[]
[null,"Rate of Return",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"RETURN ON RATE BASE"]

{"sheet":"II-C-2.1","index":16,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[[4,1,4,9],[5,1,5,9]]}
[null,null,null,null,null,null,null,null,null,"Schedule II-C-2.1"]
[]
[]
[]
[null,"Weighted Average Cost of Capital"]
[null,"[Test Year-End Date]"]
[]
[]
[]
[null,null,null,"(a)",null,"(b)",null,"(c)",null,"(d)"]
[null,null,null,null,null,"Percent of",null,null,null,"Weighted"]
[null,null,null,"Balance",null,"Total",null,"Cost",null,"  Cost"]
[]
[null,"Common Equity",null,0,null,{"$f":"IF(ISERR(D14/$A$20),0,D14/$A$20)","v":0},null,0,null,{"$f":"ROUND(+F14*H14,4)","v":0}]
[null,"Preferred Stock",null,0,null,{"$f":"IF(ISERR(D15/$A$20),0,D15/$A$20)","v":0},null,0,null,{"$f":"ROUND(+F15*H15,4)","v":0}]
[null,"Preferred Trust Securities",null,0,null,{"$f":"IF(ISERR(D16/$A$20),0,D16/$A$20)","v":0},null,0,null,{"$f":"ROUND(+F16*H16,4)","v":0}]
[null,"Long-Term Debt",null,0,null,{"$f":"IF(ISERR(D17/$A$20),0,D17/$A$20)","v":0},null,0,null,{"$f":"ROUND(+F17*H17,4)","v":0}]
[null,"Short-Term Debt",null,0,null,{"$f":"IF(ISERR(D18/$A$20),0,D18/$A$20)","v":0},null,0,null,{"$f":"ROUND(+F18*H18,4)","v":0}]
[]
[null,"    Total",null,{"$f":"SUM(D14:D18)","v":0},null,{"$f":"SUM(F14:F18)","v":0},null,null,null,{"$f":"SUM(J14:J18)","v":0}]

{"sheet":"II-C-2.2","index":17,"n_rows":70,"n_cols":31,"rows_kept":70,"cut":false,"hidden":false,"merged":[[2,0,2,30]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule II-C-2.2"]
[]
["Weighted Average Cost of Preferred Stock"]
[" "]
[]
[]
[null,null,"(a)",null,"(b)",null,"(c)",null,"(d)",null,"(e)",null,"(f)",null,"(g)",null,"(h)",null,"(i)",null,"(j)",null,"(k)",null,"(l)",null,"(m)",null,"(n)",null,"(o)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Underwriting",null,"Gain or",null,null,null,"Net",null,null,null,null,null,"Issue"]
[null,null,null,null,null,null,"Mandatory",null,null,null,null,null,"Premium",null,"Fees and",null,"(Loss) on",null,"Original",null,"Proceeds",null,"Par Value",null,"Current",null,"As % of",null,"Cost",null,"Weighted"]
[null,null,null,null,"Issuance",null,"Redemption",null,"Dividend",null,"Par Value",null,"or",null,"Issuance",null,"Redeemed",null,"Net",null,"As % of",null,"Currently",null,"Net",null,"Total Net",null,"of",null,"Average"]
["Line",null,"Description",null,"Date",null,"(Y/N)",null,"Rate",null,"at Issuance",null,"(Discount)",null,"Expenses",null,"Stock",null,"Proceeds",null,"Par",null,"Outstanding",null,"Proceeds",null,"Proceeds",null,"Money",null,"Cost"]
[]
[1,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,{"$f":"K13+M13-O13+Q13","v":0},null,{"$f":"IF(ISERR(S13/K13),0,S13/K13)","v":0},null,0,null,{"$f":"U13*W13","v":0},null,{"$f":"IF(ISERR(Y13/$Y$64),0,Y13/$Y$64)","v":0},null,0,null,{"$f":"AA13*AC13","v":0}]
[{"$f":"A13+1","v":2},null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[3,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[4,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[5,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[6,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[7,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[8,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[9,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[10,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[11,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[12,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[13,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[14,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[15,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[16,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[17,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[18,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[19,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[20,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[21,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[22,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[23,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[24,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[25,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[26,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[27,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[28,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[29,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[30,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[31,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[32,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[33,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[34,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[35,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[36,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[37,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[38,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[39,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[40,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[41,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[42,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[43,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[44,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[45,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[46,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[47,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[48,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[49,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[50,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,null,null,null,{"$f":"SUM(W13:W62)","v":0},null,{"$f":"SUM(Y13:Y62)","v":0},null,{"$f":"SUM(AA13:AA62)","v":0},null,null,null,{"$f":"SUM(AE13:AE62)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Plus:",null,"Unamortized Premium (Discount)",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Less:",null,"Unamortized Fees and Issuance Expenses",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Plus:",null,"Unamort. Gains (Losses) on Redeemed Stock",null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Net Balance of Preferred Stock",null,null,null,null,null,{"$f":"W64+W66-W67+W68","v":0}]

{"sheet":"II-C-2.2a","index":18,"n_rows":47,"n_cols":10,"rows_kept":47,"cut":false,"hidden":false,"merged":[[1,0,1,9]]}
[null,null,null,null,null,null,null,null,null,"Schedule II-C-2.2a"]
["         Adjusted Cost of Preferred Stock"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["LINE"]
[1,null,"Balance of Unamortized Gains (Losses) on"]
[{"$f":"A16+1","v":2},null,"    Redeemed Stock (Sched.II-C-2.2)"]
[3,"-","Balance Related to Gains (Losses) Identified "]
[4,null,"    in Col.(h) of Schedule II-C-2.2"]
[5]
[6,null,"Net Balance of Unamortized Gains (Losses) Not"]
[7,null,"    Accounted for in Col.(h) of Schedule II-C-2.2"]
[8]
[9]
[10,null,"Annual Amortization of Gains (Losses) on"]
[11,null,"    Redeemed Stock"]
[12,"-","Annual Amortization Related to Gains (Losses)"]
[13,null,"    Identified in Col.(h) of Schedule II-C-2.2"]
[14]
[15,null,"Net Annual Amortization of Gains (Losses) Not"]
[16,null,"    Accounted for in Col.(h) of Schedule II-C-2.2"]
[17]
[18]
[19,null,"Net Balance of Preferred Stock (Sched.II-C-2.2)"]
[20,"-","Net Balance of Unamortized Gains (Losses) from Line 6"]
[21]
[22,null,"Preferred Stock Balance Excluding Net Gains (Losses)"]
[23]
[24,"x","Weighted Average Cost of Preferred Stock (Sched.II-C-2.2)"]
[25]
[26,null,"Annual Preferred Stock Requirement"]
[27]
[28,"-","Net Amortization of Gains (Losses) from Line 15"]
[29]
[30,null,"Adjusted Annual Preferred Stock Requirement"]
[31]
[32,null,"Adjusted Cost of Preferred Stock (Line 30/Line 19)"]

{"sheet":"II-C-2.3","index":19,"n_rows":59,"n_cols":31,"rows_kept":59,"cut":false,"hidden":false,"merged":[[1,0,1,30]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule II-C-2.3"]
["Weighted Average Cost of Preferred Trust Securities"]
[" "]
[]
[]
[null,null,"(a)",null,"(b)",null,"(c)",null,"(d)",null,"(e)",null,"(f)",null,"(g)",null,"(h)",null,"(i)",null,"(j)",null,"(k)",null,"(l)",null,"(m)",null,"(n)",null,"(o)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Underwriting",null,"Gain or",null,null,null,"Net",null,null,null,null,null,"Issue",null,"Cost"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Premium",null,"Fees and",null,"(Loss) on",null,"Original",null,"Proceeds",null,"Par Value",null,"Current",null,"As % of",null,"of",null,"Weighted"]
[null,null,null,null,"Issuance",null,"Maturity",null,"Interest",null,"Par Value",null,"or",null,"Issuance",null,"Redeemed",null,"Net",null,"As % of",null,"Currently",null,"Net",null,"Total Net",null,"Money",null,"Average"]
["Line",null,"Description",null,"Date",null,"Date",null,"Rate",null,"at Issuance",null,"(Discount)",null,"Expenses",null,"Stock",null,"Proceeds",null,"Par",null,"Outstanding",null,"Proceeds",null,"Proceeds",null,"(see note)",null,"Cost"]
[]
[1,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,{"$f":"K12+M12-O12+Q12","v":0},null,{"$f":"IF(ISERR(S12/K12),0,S12/K12)","v":0},null,0,null,{"$f":"U12*W12","v":0},null,{"$f":"IF(ISERR(Y12/$Y$53),0,Y12/$Y$53)","v":0},null,0,null,{"$f":"AA12*AC12","v":0}]
[{"$f":"A12+1","v":2},null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[3,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[4,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[5,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[6,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[7,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[8,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[9,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[10,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[11,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[12,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[13,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[14,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[15,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[16,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[17,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[18,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[19,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[20,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[21,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[22,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[23,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[24,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[25,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[26,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[27,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[28,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[29,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[30,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[31,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[32,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[33,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[34,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[35,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[36,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[37,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[38,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[39,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[40,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,null,null,null,{"$f":"SUM(W12:W51)","v":0},null,{"$f":"SUM(Y12:Y51)","v":0},null,{"$f":"SUM(AA12:AA51)","v":0},null,null,null,{"$f":"SUM(AE12:AE51)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Plus:",null,"Unamortized Premium (Discount)",null,null,null,null,null,0]
["Note:  The cost (column n) of Preferred Trust Securities should be reported on a pre-tax basis; that is, do NOT",null,null,null,null,null,null,null,null,null,null,null,null,null,"Less:",null,"Unamortized Fees and Issuance Expenses",null,null,null,null,null,0]
["          multiply  the cost by [1- tax rate] when completing this schedule. ",null,null,null,null,null,null,null,null,null,null,null,null,null,"Plus:",null,"Unamort. Gains (Losses) on Redeemed Securities",null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Net Balance of Preferred Trust Securities",null,null,null,null,null,{"$f":"W53+W55-W56+W57","v":0}]

{"sheet":"II-C-2.3a","index":20,"n_rows":47,"n_cols":10,"rows_kept":47,"cut":false,"hidden":false,"merged":[[1,0,1,9]]}
[null,null,null,null,null,null,null,null,null,"Schedule II-C-2.3a"]
["         Adjusted Cost of Preferred Trust Securities"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["LINE"]
[1,null,"Balance of Unamortized Gains (Losses) on"]
[{"$f":"A16+1","v":2},null,"    Redeemed Securities (Sched.II-C-2.3)"]
[3,"-","Balance Related to Gains (Losses) Identified "]
[4,null,"    in Col.(h) of Schedule II-C-2.3"]
[5]
[6,null,"Net Balance of Unamortized Gains (Losses) Not"]
[7,null,"    Accounted for in Col.(h) of Schedule II-C-2.3"]
[8]
[9]
[10,null,"Annual Amortization of Gains (Losses) on"]
[11,null,"    Redeemed Securities"]
[12,"-","Annual Amortization Related to Gains (Losses)"]
[13,null,"    Identified in Col.(h) of Schedule II-C-2.3"]
[14]
[15,null,"Net Annual Amortization of Gains (Losses) Not"]
[16,null,"    Accounted for in Col.(h) of Schedule II-C-2.3"]
[17]
[18]
[19,null,"Net Balance of Preferred Trust Securities (Sched.II-C-2.3)"]
[20,"-","Net Balance of Unamortized Gains (Losses) from Line 6"]
[21]
[22,null,"Preferred Trust Securities Balance Excluding Net Gains (Losses)"]
[23]
[24,"x","Weighted Average Cost of Preferred Trust Securities (Sched.II-C-2.3)"]
[25]
[26,null,"Annual Preferred Trust Securities Requirement"]
[27]
[28,"-","Net Amortization of Gains (Losses) from Line 15"]
[29]
[30,null,"Adjusted Annual Preferred Trust Securities Requirement"]
[31]
[32,null,"Adjusted Cost of Preferred Trust Securities (Line 30/Line 19)"]

{"sheet":"II-C-2.4","index":21,"n_rows":68,"n_cols":31,"rows_kept":68,"cut":false,"hidden":false,"merged":[[1,0,1,30]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule II-C-2.4"]
["     Weighted Average Cost of Long-Term Debt"]
[]
[" "]
[null,null,"(a)",null,"(b)",null,"(c)",null,"(d)",null,"(e)",null,"(f)",null,"(g)",null,"(h)",null,"(i)",null,"(j)",null,"(k)",null,"(l)",null,"(m)",null,"(n)",null,"(o)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Underwriting",null,"Gain or",null,null,null,"Net",null,null,null,null,null,"Issue"]
[null,null,null,null,null,null,null,null,null,null,"Principal",null,"Premium",null,"Fees and",null,"(Loss) on",null,"Original",null,"Proceeds",null,"Principal",null,"Current",null,"As % of",null,null,null,"Weighted"]
[null,null,null,null,"Issuance",null,"Maturity",null,"Interest",null,"Amount",null,"or",null,"Issuance",null,"Reacquired",null,"Net",null,"As % of",null,"Currently",null,"Net",null,"Total Net",null,"Cost",null,"Average"]
["Line",null,"Description",null,"Date",null,"Date",null,"Rate",null,"at Issuance",null,"(Discount)",null,"Expenses",null,"Debt",null,"Proceeds",null,"Par",null,"Outstanding",null,"Proceeds",null,"Proceeds",null,"of Debt",null,"Cost"]
[]
[1,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,{"$f":"K11+M11-O11+Q11","v":0},null,{"$f":"IF(ISERR(S11/K11),0,S11/K11)","v":0},null,0,null,{"$f":"U11*W11","v":0},null,{"$f":"IF(ISERR(Y11/$Y$62),0,Y11/$Y$62)","v":0},null,0,null,{"$f":"AA11*AC11","v":0}]
[{"$f":"A11+1","v":2},null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[3,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[4,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[5,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[6,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[7,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[8,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[9,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[10,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[11,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[12,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[13,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[14,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[15,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[16,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[17,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[18,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[19,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[20,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[21,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[22,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[23,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[24,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[25,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[26,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[27,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[28,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[29,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[30,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[31,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[32,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[33,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[34,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[35,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[36,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[37,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[38,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[39,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[40,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[41,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[42,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[43,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[44,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[45,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[46,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[47,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[48,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[49,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[50,null,"XX",null,"XX/XX/XX",null,"X",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,null,null,null,{"$f":"SUM(W11:W60)","v":0},null,{"$f":"SUM(Y11:Y60)","v":0},null,{"$f":"SUM(AA11:AA60)","v":0},null,null,null,{"$f":"SUM(AE11:AE60)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Plus:",null,"Unamortized Premium (Discount)",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Less:",null,"Unamortized Fees and Issuance Expenses",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Plus:",null,"Unamortized Gains (Losses) on Reacq. Debt",null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Net Balance of Debt",null,null,null,null,null,{"$f":"W62+W64-W65+W66","v":0}]

{"sheet":"II-C-2.4a","index":22,"n_rows":46,"n_cols":11,"rows_kept":46,"cut":false,"hidden":false,"merged":[[1,0,1,10]]}
[null,null,null,null,null,null,null,null,null,null,"Schedule II-C-2.4a"]
["     Adjusted Cost of Long-Term Debt"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["LINE"]
[1,null,"Balance of Unamortized Gains (Losses) on"]
[{"$f":"A15+1","v":2},null,"    Reacquired Debt (Sched.II-C-2.4)"]
[3,"-","Balance Related to Gains (Losses) Identified "]
[4,null,"    in Col.(h) of Schedule II-C-2.4"]
[5]
[6,null,"Net Balance of Unamortized Gains (Losses) Not"]
[7,null,"    Accounted for in Col.(h) of Schedule II-C-2.4"]
[8]
[9]
[10,null,"Annual Amortization of Gains (Losses) on"]
[11,null,"    Reacquired Debt"]
[12,"-","Annual Amortization Related to Gains (Losses)"]
[13,null,"    Identified in Col.(h) of Schedule II-C-2.4"]
[14]
[15,null,"Net Annual Amortization of Gains (Losses) Not"]
[16,null,"    Accounted for in Col.(h) of Schedule II-C-2.4"]
[17]
[18]
[19,null,"Net Balance of Debt (Sched.II-C-2.4)"]
[20,"-","Net Balance of Unamortized Gains (Losses) from Line 6"]
[21]
[22,null,"Debt Balance Excluding Net Gains (Losses)"]
[23]
[24,"x","Weighted Average Cost of Debt (Sched.II-C-2.4)"]
[25]
[26,null,"Annual Debt Requirement"]
[27]
[28,"-","Net Amortization of Gains (Losses) from Line 15"]
[29]
[30,null,"Adjusted Annual Debt Requirement"]
[31]
[32,null,"Adjusted Cost of Debt (Line 30/Line 19)"]

{"sheet":"II-C-2.5","index":23,"n_rows":19,"n_cols":17,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,0,1,16],[2,0,2,16],[3,0,3,16]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule II-C-2.5"]
["Weighted Average Cost of "]
["   Short-Term Debt"]
["[Test Year-End Date]"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"             End of Monitoring Period"]
[null,null,null,null,null,null,null,null,null,null,"12 Months Ended _________, [Test Year]"]
[]
[null,null,null,null,null,null,null,null,null,null,"(a)",null,"(b)",null,"(c)",null,"(d)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Balance",null,null,null,"Weighted"]
[null,null,null,null,"Balance at end of",null,"Balance at end of",null,"Balance at end of",null,"Balance",null,"As a %",null,"Average",null,"Average"]
[null,null,null,null,"[Year]",null,"[Year]",null,"[Year]",null,"Outstanding",null,"of Total",null,"Cost",null,"Cost"]
[]
[null,"Commercial Paper",null,null,0,null,0,null,0,null,0,null,{"$f":"IF(ISERR(+K15/$K$19),0,K15/$K$19)","v":0},null,0,null,{"$f":"M15*O15","v":0}]
[null,"Bank Loans",null,null,0,null,0,null,0,null,0,null,{"$f":"IF(ISERR(+K16/$K$19),0,K16/$K$19)","v":0},null,0,null,{"$f":"M16*O16","v":0}]
[null,"Other",null,null,0,null,0,null,0,null,0,null,{"$f":"IF(ISERR(+K17/$K$19),0,K17/$K$19)","v":0},null,0,null,{"$f":"M17*O17","v":0}]
[]
[null,"Total Notes Payable",null,null,{"$f":"SUM(E15:E17)","v":0},null,{"$f":"SUM(G15:G17)","v":0},null,{"$f":"SUM(I15:I17)","v":0},null,{"$f":"SUM(K15:K17)","v":0},null,{"$f":"SUM(M15:M17)","v":0},null,null,null,{"$f":"SUM(Q15:Q17)","v":0}]

{"sheet":"II-C-2.7","index":24,"n_rows":36,"n_cols":7,"rows_kept":36,"cut":false,"hidden":false,"merged":[[1,0,1,6],[2,0,2,6]]}
[null,null,null,null,null,null,"SCHEDULE II-C-2.7"]
["COMPANY NAME"]
["CAPITAL REQUIREMENTS AND ACQUISITION PLAN"]
[]
[]
[null,null,"Most Recent","-","ESTIMATED","-","-"]
["CAPITAL REQUIREMENTS",null,"Fiscal Year","Year 1","Year 2","Year 3","Year 4"]
[]
[]
[]
["Transmission"]
[]
["Distribution"]
[]
["General"]
[]
[]
["Other (Specify)"]
[]
[]
[null,null,"________","________","________","________","________"]
["TOTAL CAPITAL REQUIREMENTS"]
[]
[]
["SOURCES OF CAPITAL"]
[]
["Internal *"]
[]
["External:"]
["   Long-Term Debt"]
["   Preferred Stock"]
["   Common Stock"]
[]
["   Other (Specify)"]
[null,null,"________","________","________","________","________"]
["TOTAL CAPITAL SOURCES"]

{"sheet":"II-C-2.8","index":25,"n_rows":39,"n_cols":15,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule II-C-2.8"]
[]
[null,null,null,null,"Historical Financial Statistics"]
[null,null,null,null,"     (Total Company Basis)"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Monitoring"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Period"]
["Line",null,"Fiscal Year:",null,"[Year-4]",null,"[Year-3]",null,"[Year-2]",null,"[Year-1]",null,null,null,"Year"]
[]
[]
[1,null,"Total Debt as a Percent ",null,0,null,0,null,0,null,0,null,null,null,0]
[2,null,"  of Total Capital"]
[3]
[4,null,"CWIP as a Percent of Net Plant",null,0,null,0,null,0,null,0,null,null,null,0]
[5]
[6,null,"Construction Expenditures as a ",null,0,null,0,null,0,null,0,null,null,null,0]
[7,null,"  Percent of Total Capital"]
[8]
[9,null,"Pre-Tax Interest Coverage",null,0,null,0,null,0,null,0,null,null,null,0]
[10]
[11,null,"Funds From Operations / Total Debt",null,0,null,0,null,0,null,0,null,null,null,0]
[12]
[13]
[14,null,"Fixed Charge Coverage",null,0,null,0,null,0,null,0,null,null,null,0]
[15]
[16,null,"Fixed Charge Coverage (Including",null,0,null,0,null,0,null,0,null,null,null,0]
[17,null,"  Distributions on Pref Trust Securities)"]
[18]
[19,null,"Funds From Operations Interest Coverage",null,0,null,0,null,0,null,0,null,null,null,0]
[20]
[21,null,"Net Cash Flow / Capital Outlays",null,0,null,0,null,0,null,0,null,null,null,0]
[22]
[{"$f":"A34+1","v":23}]
[{"$f":"A35+1","v":24},null,"Cash Coverage of Common Dividends",null,0,null,0,null,0,null,0,null,null,null,0]
[{"$f":"A36+1","v":25}]
[{"$f":"A37+1","v":26}]
[{"$f":"A38+1","v":27},null,"Return on Average Common Equity",null,0,null,0,null,0,null,0,null,null,null,0]

{"sheet":"II-C-2.9","index":26,"n_rows":34,"n_cols":25,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,22,0,24],[2,0,2,24],[3,0,3,24],[34,14,34,16],[1,17,1,19]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE II-C-2.9"]
[]
["  COMPANY NAME"]
["GROWTH IN EARNINGS, DIVIDENDS, AND BOOK VALUE"]
[]
[]
[]
["(A)","(B)",null,"(C)",null,"(D)",null,"(E)",null,"(F)","(G)","(H)","(I)","(J)","(K)","(L)","(M)","(N)","(O)","(P)","(Q)","(R)","(S)","(T)","(U)"]
["","BEGINNING",null,"NET INCOME",null,null,null,"ADDTL.",null,"ENDING","AVERAGE",null,"PERCENT ",null,null,null,null,null,null,null,null,"MARKET",null,"NET INCOME"]
[null,"COMMON",null,"FOR",null,"COMMON",null,"EQUITY",null,"COMMON","COMMON",null,"EARNINGS","IMPLIED","WTD. AVG.","WTD. AVG.","YEAR END",null,null,null,"YEAR END","TO","NON-RECURRING","FOR COMMON","DESCRIPTION OF"]
["YEAR","EQUITY","+","COMMON","-","DIVIDENDS","+","(NET)","=","EQUITY","EQUITY","ROE","RETAINED","GROWTH","SHARES","SHARES","SHARES","EPS","DPS","BVPS","MARKET","BOOK","GAINS/(LOSSES)","(ADJUSTED)","NON-RECURRING"]
[null,null,null,null,null,null,null,"F-(B+C-D)",null,null,"(B+F) / 2","C/G","(C-D) / C","H x I","(FOR EPS)","(FOR DPS)","(FOR BVPS)","C/K","D/L","F/M","PRICE","Q/P","(NET OF TAX)","C-S","ITEM"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]

{"sheet":"II-D-1 O&M","index":27,"n_rows":118,"n_cols":18,"rows_kept":118,"cut":false,"hidden":false,"merged":[]}
[]
[null,"PUBLIC UTILITY COMMISSION OF TEXAS"]
[null,"XXXXXX COMPANY"]
[null,"II-D-1 OPERATIONS AND MAINTENANCE EXPENSE"]
[null,"TEST YEAR ENDING X/XX/XXXX"]
[null,"DOCKET XXXXX"]
[]
[null," ",null,null,1,2,3,4,5,6,7,8,9,10,11,12,13]
[null,null,null,null,null,null,null,"Company"]
[null,"Account","Description","Reference","Total ","Non-Regulated or","Known","Total","FF","Functionalization","Allocation to","TRAN","DIST","MET","TBILL","TDCS","Total"]
[null,"Number",null,"Schedule","Company"," Non-Electric","Change","Electric","#","Factor","Texas",null,null,null,null,null,null,"CHECK"]
[null,null,null,null,null,null,null,null,null,"Name"]
[]
[null,"Transmission Expense"]
[]
[null,null,"Operation","II-D-1"]
[null,"A560","Operation Super. & Engin."]
[null,"A561","Load Dispatching "]
[null,"A562","Station Equipment ?? "]
[null,"A563","Overhead Line Expense "]
[null,"A564","Underground Line Expense "]
[null,"A565","Wheeling Expense 23.67 Payments "]
[null,"A565.1","Wheeling Expense "]
[null,"A566","Misc. Transmission Expense "]
[null,"A567","Rents "]
[]
[null,"DISTB","Distb Exp.. A582, A591-A594"]
[null,null,"Subtotal"]
[]
[null,null,"Maintenance","II-D-1"]
[null,"A568","Maintenance Super. & Engin. "]
[null,"A569","Maint. of Structures"]
[null,"A570","Maint. of Station Equipment"]
[null,"A571","Maint. of Overhead Lines"]
[null,"A572","Maint. of Underground Lines"]
[null,"A573","Maint. of Misc. Trans.Plant"]
[null,null,"Others"]
[null,null,"Subtotal"]
[]
[null,"TOTAL TRANSMISSION EXPENSE",null,"II-D-1"]
[]
[null,"Distribution Expense"]
[null,null,"Operation"]
[null,"A581","Load Dispatching ","II-D-1"]
[null,"A582","Station Expense "]
[null,"A583P","Overhead Line Expense -Primary "]
[null,"A584","Underground Line Expense "]
[null,"A585","Street Lights "]
[null,"A586","Meter Expenses "]
[null,"A587","Customer Installation Expense "]
[null,"A 588","Misc Distribution Expenses"]
[null,"A589","Rents "]
[null,null,"Subtotal 581-589"]
[]
[null,"A580","Operation Super. & Engin."]
[null,"A580","Operation Super. & Engin."]
[null,"A588","Misc. Distribution Expenses"]
[null,"A588","Misc. Distribution Expenses"]
[null,null," Subtotal 580 & 588"]
[]
[null,"Distribution-Operation-Total"]
[]
[null,null,"Maintenance","II-D-1"]
[null,"A591","Maint. of Structures"]
[null,"A592","Maint. of Station Equipment"]
[null,"A593P","Maint. of Overhead Lines-Primary"]
[null,"A594P","Maint. of Underground Lines-Primary"]
[null,"A595","Maint. of Line Transformers"]
[null,"A596","Maint. of Street Lights"]
[null,"A597","Maint. of Meters"]
[null,"A598","Maint. of Misc. Dist. Plant.(371&372)"]
[null,null,"Subtotal 591-598"]
[]
[null,"A590","Maintenance Super.& Engin."]
[null,"A590","Maintenance Super.& Engin."]
[null,"A598.2","Maint. of Misc. Dist. Plant.-OTHER"]
[null,null,"Subtotal 590&598.2"]
[]
[null,"TOTAL DISTRIBUTION EXPENSE",null,"II-D-1"]
[]
[null,null,"Customer Accounting Expenses","II-D-1"]
[null,"A902","Meter Reading Expense"]
[null,"A903","Customer Records  & Collection"]
[null,"A903.E","Collection"]
[null,null,"Subtotal 902-903"]
[]
[null,"A901","Supervision"]
[null,"A904","Uncollectible Accounts"]
[null,"A905","Misc. Customer Account Exp."]
[null,null,"Subtotal Customer Accounting"]
[]
[null,null,"Cust. Service & Information Expense","II-D-1"]
[null,"A906.C","Customer Svc. & Infor."]
[null,"A908.C","Customer Assistance"]
[null,"A909.C","Inform. & Instruct. Adv. Exp."]
[null,null,"Subtotal 906-909"]
[]
[null,"A907","Supervision"]
[null,"A910","Misc. Cust. Service & Inform."]
[null,null,"Subtotal 907&910"]
[]
[null,"TOTAL-CUSTOMER SERVICE & INFO.",null,"II-D-1"]
[]
[null,null,"Sales Expense","II-D-1"]
[null,"A912","Demonstrating & Selling Exp."]
[null,"A913","Advertising Exp."]
[null,"A916","Misc Sales Exp"]
[null,"A917","Sales Expense"]
[null,null,"Subtotal 912-917"]
[]
[null,"A911","Supervision"]
[null,"A916","Misc. Sales Exp."]
[]
[null,null,"Subtotal -Sales"]
[]
[null,"TOTAL SALES EXPENSE",null,"II-D-1"]
[]
[null,"TOTAL O&M EXPENSE",null,"II-D-1"]

{"sheet":"II-D-2 A&G","index":28,"n_rows":32,"n_cols":18,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[null,"PUBLIC UTILITY COMMISSION OF TEXAS"]
[null,"XXXXXX COMPANY"]
[null,"II-D-2 ADMINISRATIVE & GENERAL EXPENSE"]
[null,"TEST YEAR ENDING X/XX/XXXX"]
[null,"DOCKET XXXXX"]
[]
[null," ",null,null,1,2,3,4,5,6,7,8,9,10,11,12,13]
[null,null,null,null,null,null,null,"Company"]
[null,"Account","Description","Reference","Total ","Non-Regulated or","Known","Total","FF","Functionalization","Allocation to","TRAN","DIST","MET","TBILL","TDCS","Total"]
[null,"Number",null,"Schedule","Company"," Non-Electric","Change","Electric","#","Factor","Texas",null,null,null,null,null,null,"CHECK"]
[null,null,null,null,null,null,null,null,null,"Name"]
[]
[null,"Adminstrative & General Expenses",null,"II-D-2"]
[null,"A920","Admin. & General Salaries"]
[null,"A921","Office Supplies"]
[null,"A922","Admin Expense Transferred"]
[null,"A923","Outside Services"]
[null,"A924","Property Insurance Exp."]
[null,"A925","Injuries & Damages"]
[null,"A926","Pensions & Benefits"]
[null,"A928","Regulatory Commission"]
[null,"A930.1","Misc. General Expense "]
[null,"A930.2","Mics General Expense"]
[null,"A931","Rents"]
[null,"A935","Maint. of General Plant"]
[]
[null,"TOTAL A&G EXPENSE",null,"II-D-2"]
[]
[null,"TOTAL O&M & A&G EXPENSE",null,"II-D-1-2"]
[]
[null,"TOTAL O&M EXP. EXCL. FUEL & PUR. POWER",null,"II-D-1-2"]

{"sheet":"II-D-3 Payroll","index":29,"n_rows":126,"n_cols":18,"rows_kept":126,"cut":false,"hidden":false,"merged":[]}
[]
[null,"PUBLIC UTILITY COMMISSION OF TEXAS"]
[null,"XXXXXX COMPANY"]
[null,"II-D-3 PAYROLL EXPENSES"]
[null,"TEST YEAR ENDING X/XX/XXXX"]
[null,"DOCKET XXXXX"]
[]
[null," ",null,null,1,2,3,4,5,6,7,8,9,10,11,12,13]
[null,null,null,null,null,null,null,"Company"]
[null,"Account","Description","Reference","Total ","Non-Regulated or","Known","Total","FF","Functionalization","Allocation to","TRAN","DIST","MET","TBILL","TDCS","Total","CHECK"]
[null,"Number",null,"Schedule","Company"," Non-Electric","Change","Electric","#","Factor","Texas"]
[null,null,null,null,null,null,null,null,null,"Name"]
[]
[null,"Transmission Expense"]
[null,null,"Operation","II-D-3"]
[null,"A560","Operation Super. & Engin."]
[null,"A561","Load Dispatching"]
[null,"A562","Station Equipment"]
[null,"A563","Overhead Line Expense"]
[null,"A564","Underground Line Expense"]
[null,"A565.1","Wheeling Expense"]
[null,"A565.2","Wheeling Expense"]
[null,"A566","Misc. Transmission Expense"]
[null,"A567","Rents"]
[null,"A567R","Inter Fuel Credit"]
[null,null,"Transmission Equalization Payments"]
[null,null,"Subtotal"]
[]
[null,null,"Maintenance","II-D-3"]
[null,"A568","Maintenance Super. & Engin."]
[null,"A569","Maint. of Structures"]
[null,"A570","Maint. of Station Equipment"]
[null,"A571","Maint. of Overhead Lines"]
[null,"A572","Maint. of Underground Lines"]
[null,"A573","Maint. of Misc. Trans.Plant"]
[null,null,"Others"]
[null,null,"Subtotal"]
[]
[null,"TOTAL TRANSMISSION EXPENSE"]
[]
[null,"Distribution Expense"]
[null,null,"Operation","II-D-3"]
[null,"A581","Load Dispatching"]
[null,"A582","Station Expense"]
[null,"A583","Overhead Line Expense "]
[null,"A584","Underground Line Expense"]
[null,"A585","Street Light & Signal Systems"]
[null,"A586","Meter Expenses"]
[null,"A587","Customer Installation Expense"]
[null,"A588","Misc. Distribution Expenses"]
[null,"A589","Rents"]
[null,null,"Subtotal 581-589"]
[]
[]
[null,"A580","Operation Super. & Engin."]
[null,"A588","Misc. Distribution Expenses"]
[null,null,"Subtotal 580 & 588"]
[]
[null,null,"Distribution-Operation-Total","II-D-3"]
[]
[null,null,"Maintenance","II-D-3"]
[null,"A591","Maint. of Structures"]
[null,"A592","Maint. of Station Equipment"]
[null,"A593","Maint. of Overhead Lines"]
[null,"A594","Maint. of Underground Lines"]
[null,"A595","Maint. of Line Transformers"]
[null,"A596","Maint. of Street Lights"]
[null,"A597","Maint. of Meters"]
[null,"A598.1","Maint. of Misc. Dist. Plant.(371&372)"]
[null,null,"Subtotal 591-598.1"]
[]
[null,"A590","Maintenance Super.& Engin."]
[null,null,"Subtotal 590&598.2"]
[]
[null,null,"Distribution-Maintenance-Total","II-D-3"]
[]
[null,"TOTAL DISTRIBUTION EXPENSE",null,"II-D-3"]
[]
[null,"Cust. Acct., Serv. ,Info. & Sales Expenses",null,"II-D-3"]
[]
[null,null,"Customer Accounting Expenses","II-D-3"]
[null,"A902","Meter Reading Expense"]
[null,"A903.R","Customer Records & Collection"]
[null,null,"Subtotal 902-903"]
[]
[null,"A901","Supervision"]
[null,"A904","Uncollectible Accounts"]
[null,"A905","Misc. Customer Account Exp."]
[null,null,"Subtotal Customer Accounting"]
[]
[null,null,"Cust. Service & Info. Expense","II-D-3"]
[null,"A906.C","Customer Svc. & Infor."]
[null,"A906.E","Customer Svc. & Infor."]
[null,"A908.E","Customer Assistance"]
[null,"A909.C","Inform. & Instruct. Adv. Exp."]
[null,null,"Subtotal 906-909"]
[]
[null,"A907","Supervision"]
[null,"A910","Misc. Cust. Service & Inform."]
[null,null,"Subtotal 907&910"]
[]
[null,null,"Subtotal -Cust. Service & Information"]
[]
[null,null,"Sales Expense","II-D-3"]
[null,"A912","Demonstrating & Selling Exp."]
[null,"A913","Advertising Exp."]
[null,"A917","Sales Expense"]
[null,null,"Subtotal 912-917"]
[]
[null,"A911","Supervision"]
[null,"A916","Misc. Sales Exp."]
[null,null,"Subtotal -Sales"]
[]
[null,"TOT. CUST. ACCT., SERV., INFO., & SALES EXP."]
[]
[null,"TOTAL PAYROLL EXCLUDING A& G",null,"II-D-3"]
[]
[null,"Adminstrative & General Expenses"]
[null,"A920","Admin. & General Salaries"]
[null,"A921","Office Supplies"]
[null,"A925","Injuries & Damages"]
[null,"A930","Misc. General Expense"]
[]
[null,"TOTAL A&G EXPENSE"]
[]
[null,"TOTAL PAYROLL EXPENSE",null,"II-D-3"]

{"sheet":"II-D-4 Exclusions","index":30,"n_rows":20,"n_cols":18,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[null,"PUBLIC UTILITY COMMISSION OF TEXAS"]
[null,"XXXXXX COMPANY"]
[null,"II-D-4 SUMMARY OF EXCLUSIONS FROM REPORTING PERIOD"]
[null,"TEST YEAR ENDING X/XX/XXXX"]
[null,"DOCKET XXXXX"]
[]
[null," ",null,null,1,2,3,4,5,6,7,8,9,10,11,12,13]
[null,null,null,null,null,null,null,"Company"]
[null,"Account","Description","Reference","Total ","Non-Regulated or","Known","Total","FF","Functionalization","Allocation to","TRAN","DIST","MET","TBILL","TDCS","Total"]
[null,"Number",null,"Schedule","Company"," Non-Electric","Change","Electric","#","Factor","Texas",null,null,null,null,null,null,"CHECK"]
[null,null,null,null,null,null,null,null,null,"Name"]
[]
[null,null,"Legislative Advocacy","II-D-4"]
[null,null,"Penalties and Fines","II-D-4"]
[null,null,"Other Exclusions","II-D-4"]
[null,null,"Social/Recreational/Religious","II-D-4"]
[null,null,"Political","II-D-4"]
[]
[null,"TOTAL EXCLUSIONS FROM REPORTING PERIOD",null,"II-D-4"]

{"sheet":"II-E-1 Dep. Exp.","index":31,"n_rows":68,"n_cols":18,"rows_kept":68,"cut":false,"hidden":false,"merged":[]}
[]
[null,"PUBLIC UTILITY COMMISSION OF TEXAS"]
[null,"XXXXXX COMPANY"]
[null,"II-E-1 DEPRECIATION & AMORTIZATION EXPENSE"]
[null,"TEST YEAR ENDING X/XX/XXXX"]
[null,"DOCKET XXXXX"]
[]
[null," ",null,null,1,2,3,4,5,6,7,8,9,10,11,12,13]
[null,null,null,null,null,null,null,"Company"]
[null,"Account","Description","Reference","Total ","Non-Regulated or","Known","Total","FF","Functionalization","Allocation to","TRAN","DIST","MET","TBILL","TDCS","Total"]
[null,"Number",null,"Schedule","Company"," Non-Electric","Change","Electric","#","Factor","Texas",null,null,null,null,null,null,"CHECK"]
[null,null,null,null,null,null,null,null,null,"Name"]
[]
[null,"Depreciation and Amortization Expense",null,"II-E-1"]
[]
[null,"Intangible Plant",null,"II-E-1"]
[null,"A301","Organization"]
[null,"A302","Franchise and Consents"]
[null,"A303","Miscellaneous Intangible Plant"]
[null,null,"Subtotal"]
[]
[null,"Transmission Plant",null,"II-E-1"]
[null,"A350","Land and Land Rights"]
[null,"A352","Structures and Improvements"]
[null,"A353","Station Equipment"]
[null,"A354","Towers and Fixtures"]
[null,"A355","Poles and Fixtures"]
[null,"A356","O.H. Conductors & Devices"]
[null,"A357","Undergound Conduit"]
[null,"A358","Underground Conductors"]
[null,"A359","Roads and Trails"]
[null,null,"Others"]
[null,null,"Subtotal"]
[]
[null,"Distribution",null,"II-E-1"]
[null,"A360","Land and Land Rights"]
[null,"A361","Structures and Improvements"]
[null,"A362","Station Equipment"]
[null,"A363","Storage Battery Equipment"]
[null,"A364","Poles,Towers & Fixtures"]
[null,"A365","O.H. Conductors & Devices"]
[null,"A366","Underground Conduits"]
[null,"A367","U.G. Conductors & Devices"]
[null,"A368","Line Transformers"]
[null,"A369","Services"]
[null,"A370","Meters"]
[null,"A371","Install. on Customer Prem."]
[null,"A372","Leased Prop. on Cust. Premises"]
[null,"A373","Street Lights"]
[null,null,"Subtotal"]
[]
[null,"General Plant",null,"II-E-1"]
[]
[null,"A389.1","Land and Land Rights"]
[null,"A390","Structures and Improvements"]
[null,"A391","A391 Office Furniture"]
[null,"A392","Transportation equipment"]
[null,"A393","Store Equipment"]
[null,"A394","Tools, Shop & Garage Equip"]
[null,"A395","Lab Equip"]
[null,"A396","Power Operated Equipment"]
[null,"A397","Communication equi"]
[null,"A398","Misc Equip"]
[null,"A399","Other Intangible Prop - Depr"]
[null,"A399","Other Intangible Prop - Depletable"]
[null,null,"Subtotal"]
[]
[null,"TOTAL DEPRECIATION & AMORTIZATION",null,"II-E-1"]

{"sheet":"II-E-2 Taxes Other","index":32,"n_rows":38,"n_cols":18,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[]
[null,"PUBLIC UTILITY COMMISSION OF TEXAS"]
[null,"XXXXXX COMPANY"]
[null,"II-E-2 TAXES OTHER THAN FEDERAL INCOME TAXES"]
[null,"TEST YEAR ENDING X/XX/XXXX"]
[null,"DOCKET XXXXX"]
[]
[null," ",null,null,1,2,3,4,5,6,7,8,9,10,11,12,13]
[null,null,null,null,null,null,null,"Company"]
[null,"Account","Description","Reference","Total ","Non-Regulated or","Known","Total","FF","Functionalization","Allocation to","TRAN","DIST","MET","TBILL","TDCS","Total"]
[null,"Number",null,"Schedule","Company"," Non-Electric","Change","Electric","#","Factor","Texas",null,null,null,null,null,null,"CHECK"]
[null,null,null,null,null,null,null,null,null,"Name"]
[]
[null,"Taxes Other than Income Taxes",null,"II-E-2"]
[]
[null,"Payroll-Related",null,"II-E-2"]
[null,null,"Direct Assigned"]
[null,null,"FICA"]
[null,null,"FUTA"]
[null,null,"Total Federal"]
[]
[null,"Property Related",null,"II-E-2"]
[null,null,"Transmission"]
[null,null,"Distribution"]
[null,null,"Total Property"]
[]
[null,null,"Unemployment"]
[null,null,"Franchise"]
[null,null,"Total Non-Revenue Related"]
[]
[null,"Revenue Related",null,"II-E-2"]
[null,null,"Public Utility Commission"]
[null,null,"State Gross Receipts"]
[null,null,"Occupational Street Rental"]
[null,null,"Environmental"]
[null,null,"Total Revenue Related"]
[]
[null,"TOTAL TAXES OTHER THAN INCOME TAXES",null,"II-E-2"]

{"sheet":"II-E-3 FIT","index":33,"n_rows":52,"n_cols":18,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[]
[null,"PUBLIC UTILITY COMMISSION OF TEXAS"]
[null,"XXXXXX COMPANY"]
[null,"II-E-3 FEDERAL INCOME TAXES"]
[null,"TEST YEAR ENDING X/XX/XXXX"]
[null,"DOCKET XXXXX"]
[]
[null," ",null,null,1,2,3,4,5,6,7,8,9,10,11,12,13]
[null,null,null,null,null,null,null,"Company"]
[null,"Account","Description","Reference","Total ","Non-Regulated or","Known","Total","FF","Functionalization","Allocation to","TRAN","DIST","MET","TBILL","TDCS","Total"]
[null,"Number",null,"Schedule","Company"," Non-Electric","Change","Electric","#","Factor","Texas",null,null,null,null,null,null,"CHECK"]
[null,null,null,null,null,null,null,null,null,"Name"]
[]
[null,"Federal Income Taxes",null,"II-E-3"]
[]
[null,null,"Return on Rate Base"]
[]
[null,null,"Deductions:"]
[null,null,"Synchronized Interest"]
[null,null,"  ITC Amortization"]
[null,null,"Amortization of Protected Excess DFIT"]
[null,null,"Amoritization of Non-protected excess DFIT"]
[null,null,"Protected Excess Reserve Adjustment"]
[null,null,"Amoritization of reserved non ratable net excess"]
[null,null,"Depletion"]
[null,null,"Other"]
[null,null,"Subtotal"]
[]
[null,null,"Additions:"]
[null,null,"Depreciation adjustment"]
[null,null,"Meals and Entertainment"]
[null,null,"prior year adjustments"]
[null,null,"provision for contingencies"]
[]
[null,null,"Taxable Component of Return"]
[null,null,"Tax Factor"]
[]
[null,null,"Federal Income Taxes Before Adjust."]
[]
[null,null,"Tax Credits"]
[null,null,"ITC Amortization"]
[null,null,"Amort of protected excess DFIT"]
[null,null,"Amoritiz. Of excess deferred taxes"]
[null,null,"protected excess revenue"]
[null,null,"amort of reserved non-ratable net excess"]
[]
[null,null,"ADD:"]
[null,null,"prior year adjustments"]
[null,null,"provision for contingencies"]
[null,null,"Subtotal"]
[]
[null,"TOTAL FEDERAL INCOME TAXES",null,"II-E-3"]

{"sheet":"II-E-3-Attach","index":34,"n_rows":48,"n_cols":3,"rows_kept":48,"cut":false,"hidden":false,"merged":[[5,0,5,2],[6,0,6,2]]}
[]
[]
[null,null,"Schedule II-E-3"]
[]
[]
["FEDERAL INCOME TAXES"]
["TAX METHOD 1"]
[]
[]
[null,"Test Period","Total Requested"]
["Return","$","$"]
[]
["Deduct:"]
[]
["      Interest","$","$"]
["      Amortization of ITC","$","$"]
["      Amortizaton of DFIT (Excess)","$","$"]
["      Preferred Divident Exclusion","$","$"]
["      Other (Specify)"]
["                   Deduct 1","$","$"]
["                   Deduct 2","$","$"]
["                   Deduct 3","$","$"]
["                   Deduct 4","$","$"]
[]
[]
["Add:"]
[]
["       Additional Depreciation","$","$"]
["       Business Meals Not Deductible","$","$"]
["       Other (Specify)"]
["                    Addition 1","$","$"]
["                    Addition 2","$","$"]
["                    Addition 3","$","$"]
["                    Addition 4","$","$"]
[]
[]
["Taxable Component of Return","$","$"]
["Tax Factor (1/.65)(.35)",0.53846152999999997,0.53846152999999997]
[]
[]
["Total Federal Income Taxes Before"]
["       Adjustments","$","$"]
[]
["Amortization of ITC","$","$"]
["Amortization of DFIT (Excess)","$","$"]
["Other","$","$"]
[]
["Total Federal Income Taxes","$","$"]

{"sheet":"II-E-3.9","index":35,"n_rows":36,"n_cols":4,"rows_kept":36,"cut":false,"hidden":false,"merged":[[5,0,5,7]]}
[]
[null,null,null,"Schedule II-E-3.9"]
[]
[]
[]
["ANALYSIS OF INVESTMENT TAX CREDITS"]
[]
[]
["Investment Tax Credits earned in test period","$"]
[]
["Pro Forma Adjustments (if any)"]
[]
["Gross Investment Tax Credits*",null,"$"]
[]
["Less"]
[]
["Amortization of Investment Tax Credits","$"]
[]
["Pro Forma Adjustments (if any)"]
[]
["Total Amortization",null,"(B)"]
[]
["Investment Tax Credit Adjustment*",null,"$"]
[]
["Test:"]
[]
["Stripped Book Depreciation Rate requested","%"]
[]
["Amortization of Investment Tax Credits (B) ="]
["   Gross Amortizable Base (exclude QPEs)","%"]
[]
[]
[]
[]
["NOTE:     Attach workpapers supporting computations if not included in rate filing package."]
["    *          Should agree with amount shown on Analysis of Federal Income Taxes."]

{"sheet":"II-E-3.15","index":36,"n_rows":57,"n_cols":4,"rows_kept":57,"cut":false,"hidden":false,"merged":[[3,0,3,4],[4,0,4,4]]}
[null,null,null,"Schedule II-E-3.15"]
[]
[]
["ANALYSIS OF FEDERAL INCOME TAXES"]
["TAX METHOD 2"]
[]
[null,"Test Period",null,"Total Requested"]
[]
["Total Revenue Requirement","$",null,"$"]
["Less Cost of Service items:"]
["        Fuel Expense"]
["        Other O & M Expense"]
["        Depreciation and Amortization"]
["        Taxes Other Than Income"]
["        Interest on Customers' Deposits"]
["Less Deductions not included in Cost of Service:"]
["        Interest Expense on Debt (including amount capitalized)"]
["        Additional Tax Depreciation*"]
["        Capitalized Taxes"]
["        Other deductions (specify)"]
[]
["Deduct 1______________________________________"]
["Deduct 2______________________________________"]
["Deduct 3______________________________________"]
["Deduct 4______________________________________"]
[]
["Add Taxable Income not included in Cost of Service (specify)"]
[]
["Addition 1______________________________________"]
["Addition 2______________________________________"]
[]
["Taxable Income "]
["Tax Rate"]
["Federal Income Taxes before credits"]
["Less:"]
["        Investment Tac Credits (Gross)"]
["        Other______________________________________"]
["Current Federal Income Taxes","$",null,"$"]
[]
["Deferred Federal Income Taxes:"]
["         Credits  $___________________________________"]
["         Debits     ___________________________________"]
[]
["Total Deferred Federal Income Taxes**","$",null,"$"]
[]
["Investment Tax Credit Adjustments","$",null,"$"]
[]
["Total Requested Federal Income Taxes","$",null,"$"]
[]
[]
[]
[]
["NOTE:             Workpapers supporting all figures not found elsewhere in rate filing package should "]
["                        accompany this analysis."]
[]
["*           Excess of Tax Depreciation over Depreciation Claimed in Cost of Service"]
["**          Must agree with Deferred Tax Analysis"]

{"sheet":"II-E-3.16","index":37,"n_rows":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[[3,0,3,5],[7,2,7,3],[7,4,7,5]]}
[]
[null,null,null,null,"Schedule II-E-3.16"]
[]
["ANALYSIS OF DEFERRED FEDERAL INCOME TAXES"]
[]
[]
[]
[null,null,"Test Period Amount Booked",null,"Amount Requested"]
["    Item Deferred",null,"Basis","(x) Tax Rate % ","Basis**","X 35%"]
[]
["Depreciation",null,"$","$"]
[]
["Taxes Capitalized"]
[]
["Interest Capitalized"]
[]
["Other (Specify)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total Deferred*",null,"    XXXXXXX","$","   XXXXXXX","$"]
[]
[]
[]
["NOTE: Attach workpapers supporting computations if figures are not included in the rate filing package."]
[]
[]
["*  For test period amount, net of accounts 410.1 & 411.1; aor amount requested, net of amounts shown"]
["   on Analysis of Federal Income Taxes"]
[]
["** From amounts included in Analysis of Federal Income Taxes"]

{"sheet":"II-E-4 Other Expenses","index":38,"n_rows":23,"n_cols":18,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[null,"PUBLIC UTILITY COMMISSION OF TEXAS"]
[null,"XXXXXX COMPANY"]
[null,"II-E-4 OTHER EXPENSES"]
[null,"TEST YEAR ENDING X/XX/XXXX"]
[null,"DOCKET XXXXX"]
[]
[null," ",null,null,1,2,3,4,5,6,7,8,9,10,11,12,13]
[null,null,null,null,null,null,null,"Company"]
[null,"Account","Description","Reference","Total ","Non-Regulated or","Known","Total","FF","Functionalization","Allocation to","TRAN","DIST","MET","TBILL","TDCS","Total"]
[null,"Number",null,"Schedule","Company"," Non-Electric","Change","Electric","#","Factor","Texas",null,null,null,null,null,null,"CHECK"]
[null,null,null,null,null,null,null,null,null,"Name"]
[]
[null,"  Misc.Other Expenses"]
[]
[null,"Misc.Items"]
[null,431,"Interest On Customer Deposits","II-E-4"]
[null,403,"Decomissioning Expense"]
[null,null,"Subtotal"]
[]
[null,"TOTAL OTHER EXPENSES EXCLUDING FIT",null,"II-E-1-2+4"]
[]
[null,"TOTAL OTHER EXPENSES INCLUDING FIT",null,"II-E-1-4"]

{"sheet":"II-E-4.6 Monthly Rate Case Exp","index":39,"n_rows":88,"n_cols":16,"rows_kept":88,"cut":false,"hidden":false,"merged":[]}
["Utility Company"]
["Schedule II-E-4.6 Monthly Rate Case Expenses for the Current Proceeding"]
["Docket No. XXXXX"]
["Jan XXXX - Dec XXXX"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Incurred",null,null,"Remaining","Total Expenses"]
[null,null,null,null,null,null,null,null,null,null,"Expenses Paid","But Not","Total Expenses","Filed","Estimated","% of"]
[null,null,"Jan XXXX","Feb XXXX","Mar XXXX","Apr XXXX","May XXXX","June XXXX","July XXXX","Aug XXXX","To Date","Paid","To Date","Estimate","Expenses","Estimate"]
["Consultants"]
["ABC Company"]
["Depreciation Study"]
["     Professional Fees",null,0,0,0,0,0,0,0,0,0,0,{"$f":"+K12+L12","v":0},0,{"$f":"+N12-M12","v":0}]
["     Expenses",null,0,0,0,0,0,0,0,0,0,0,{"$f":"+K13+L13","v":0},0,{"$f":"+N13-M13","v":0}]
["     Total Charges",null,{"$f":"SUM(C12:C13)","v":0},{"$f":"SUM(D12:D13)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"+M14/N14","v":{"$error":"#DIV/0!"}}]
[]
["DEF Company"]
["Cost of Equity"]
["     Professional Fees",null,0,0,0,0,0,0,0,0,0,0,{"$f":"+K18+L18","v":0},0,{"$f":"+N18-M18","v":0}]
["     Expenses",null,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+N19-M19","v":0}]
["     Total Charges",null,{"$f":"SUM(C18:C19)","v":0},{"$f":"SUM(D18:D19)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"+M20/N20","v":{"$error":"#DIV/0!"}}]
[]
["GHI Company"]
["Benchmarking Study"]
["     Professional Fees",null,0,0,0,0,0,0,0,0,0,0,{"$f":"+K24+L24","v":0},0,{"$f":"+N24-M24","v":0}]
["     Expenses",null,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+N25-M25","v":0}]
["     Total Charges",null,{"$f":"SUM(C24:C25)","v":0},{"$f":"SUM(D24:D25)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"+M26/N26","v":{"$error":"#DIV/0!"}}]
[]
["JKL Company"]
["Labor Cost Study"]
["     Professional Fees",null,0,0,0,0,0,0,0,0,0,0,{"$f":"+K30+L30","v":0},0,{"$f":"+N30-M30","v":0}]
["     Expenses",null,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+N31-M31","v":0}]
["     Total Charges",null,{"$f":"SUM(C30:C31)","v":0},{"$f":"SUM(D30:D31)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"+M32/N32","v":{"$error":"#DIV/0!"}}]
[]
["Total Consultants",null,{"$f":"+C14+C20+C26+C32","v":0},{"$f":"+D14+D20+D26+D32","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"+M34/N34","v":{"$error":"#DIV/0!"}}]
[]
["Legal Counsel"]
["MNO Law Firm"]
["Regulatory Counsel"]
["     Professional Fees",null,0,0,0,0,0,0,0,0,0,0,{"$f":"+K39+L39","v":0},0,{"$f":"+N39-M39","v":0}]
["     Expenses",null,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+N40-M40","v":0}]
["     Total Charges",null,{"$f":"SUM(C39:C40)","v":0},{"$f":"SUM(D39:D40)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"+M41/N41","v":{"$error":"#DIV/0!"}}]
[]
["PQR PC"]
["Regulatory Counsel"]
["     Professional Fees",null,0,0,0,0,0,0,0,0,0,0,{"$f":"+K45+L45","v":0},0,{"$f":"+N45-M45","v":0}]
["     Expenses",null,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+N46-M46","v":0}]
["     Total Charges",null,{"$f":"SUM(C45:C46)","v":0},{"$f":"SUM(D45:D46)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"+M47/N47","v":{"$error":"#DIV/0!"}}]
[]
["Total Legal Counsel",null,{"$f":"+C41+C47","v":0},{"$f":"+D41+D47","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"+M49/N49","v":{"$error":"#DIV/0!"}}]
[]
["Cities"]
["City of STU"]
["Cities Expenses"]
["     Professional Fees",null,0,0,0,0,0,0,0,0,0,0,{"$f":"+K54+L54","v":0},0,{"$f":"+N54-M54","v":0}]
["     Expenses",null,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+N55-M55","v":0}]
["     Total Charges",null,{"$f":"SUM(C54:C55)","v":0},{"$f":"SUM(D54:D55)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(N54:N55)","v":0},0,{"$f":"+M56/N56","v":{"$error":"#DIV/0!"}}]
[]
["City of VWX"]
["Cities Expenses"]
["     Professional Fees",null,0,0,0,0,0,0,0,0,0,0,{"$f":"+K60+L60","v":0},0,{"$f":"+N60-M60","v":0}]
["     Expenses",null,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+N61-M61","v":0}]
["     Total Charges",null,{"$f":"SUM(C60:C61)","v":0},{"$f":"SUM(D60:D61)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(N60:N61)","v":0},0,{"$f":"+M62/N62","v":{"$error":"#DIV/0!"}}]
[]
["Total Cities",null,{"$f":"+C56+C62","v":0},{"$f":"+D56+D62","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"+M64/N64","v":{"$error":"#DIV/0!"}}]
[]
[]
["Miscellaneous Expenses"]
["Employee and Other Expenses"]
["     Airfare",null,0,0,0,0,0,0,0,0,0,0,{"$f":"+K69+L69","v":0},0,{"$f":"+N69-M69","v":0}]
["     Airfare- Service Fees",null,0,0,0,0,0,0,0,0,0,0,{"$f":"+K70+L70","v":0},0,0]
["     Car Rental",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["     Car Rental- Gas",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["     Equipment Rental",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["     Hotel",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["     Postage",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["     Meals",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["     Notice",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["     Office Supplies",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["     Overtime Payroll",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["     Parking",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["     Personal Car Mileage",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["     Printing",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["     Taxi/Bus/Other",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["     Telephone",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["     Temporary Employee",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Miscellaneous",null,{"$f":"SUM(C69:C85)","v":0},{"$f":"SUM(D69:D85)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(N69:N85)","v":0},0,{"$f":"+M86/N86","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL RATE CASE EXPENSES",null,{"$f":"+C34+C49+C64+C86","v":0},{"$f":"+D34+D49+D64+D86","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"+M88/N88","v":{"$error":"#DIV/0!"}}]

{"sheet":"II-E-5 Other Revenues","index":40,"n_rows":23,"n_cols":18,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[null,"PUBLIC UTILITY COMMISSION OF TEXAS"]
[null,"XXXXXX COMPANY"]
[null,"II-E-5 OTHER REVENUE ITEMS"]
[null,"TEST YEAR ENDING X/XX/XXXX"]
[null,"DOCKET XXXXX"]
[]
[null," ",null,null,1,2,3,4,5,6,7,8,9,10,11,12,13]
[null,null,null,null,null,null,null,"Company"]
[null,"Account","Description","Reference","Total ","Non-Regulated or","Known","Total","FF","Functionalization","Allocation to","TRAN","DIST","MET","TBILL","TDCS","Total"]
[null,"Number",null,"Schedule","Company"," Non-Electric","Change","Electric","#","Factor","Texas",null,null,null,null,null,null,"CHECK"]
[null,null,null,null,null,null,null,null,null,"Name"]
[]
[null,"Other Revenues:",null,"II-E-5"]
[null,"Non-Electric Revenue"]
[null,"A454","Rent from Property"]
[null,"A450","Forfeited Discount"]
[null,"A451","Misc. Service Revenue"]
[null,"A453","Water & Water Power"]
[null,"A456"," Other"]
[null,null,"Subtotal"]
[]
[null,"TOTAL OTHER REVENUES",null,"II-E-5"]

{"sheet":"II-F Alloc_Data","index":41,"n_rows":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,"PUBLIC UTILITY COMMISSION OF TEXAS"]
[null,"XXXXXX COMPANY"]
[null,"II-F FUNCTIONAL ALLOCATION FACTORS-DATA"]
[null,"TEST YEAR ENDING X/XX/XXXX"]
[null,"DOCKET XXXXX"]
[]
[null,null,null,null,1,2,3,4,5,6]
[]
[null,"FF","Description","FF Label","TRAN","DIST","MET","TBILL","ABILL","TDCS","TOTAL"]
[null,"#"]
[]
[]
[null,null,"Functional Allocation Data"]
[]
[null,1,"Direct Assigned","DA",null,null,null,null,null,null,{"$f":"SUM(E16:J16)","v":0}]
[null,2,"Transmission","TRAN",1,null,null,null,null,null,1]
[null,3,"Distribution","DIST",null,1,null,null,null,null,1]
[null,4,"Metering","MET",null,null,1,null,null,null,1]
[null,5,"T-Billing","TD-Bill",null,null,null,1,null,null,1]
[null,6,"TDCS","TDCS",null,null,null,null,null,1,{"$f":"SUM(E21:J21)","v":1}]

{"sheet":"II-F Alloc_Factor","index":42,"n_rows":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,"PUBLIC UTILITY COMMISSION OF TEXAS"]
[null,"XXXXXX COMPANY"]
[null,"II-F FUNCTIONAL ALLOCATION FACTORS"]
[null,"TEST YEAR ENDING X/XX/XXXX"]
[null,"DOCKET XXXXX"]
[]
[null,null,null,null,1,2,3,4,5,6]
[]
[null,"FF","Description","FF Label","TRAN","DIST","MET","TBILL","ABILL","TDCS","TOTAL"]
[null,"#"]
[]
[]
[null,null,"Functional Allocation Factors"]
[null,null,null,null,1,2,3,4,5,6,7]
[null,1,"Direct Assigned","DA"]
[null,2,"Transmission","TRAN",{"$f":"+'II-F Alloc_Data'!E17/'II-F Alloc_Data'!$K17","v":1},{"$f":"+'II-F Alloc_Data'!F17/'II-F Alloc_Data'!$K17","v":0},{"$f":"+'II-F Alloc_Data'!G17/'II-F Alloc_Data'!$K17","v":0},{"$f":"+'II-F Alloc_Data'!H17/'II-F Alloc_Data'!$K17","v":0},{"$f":"+'II-F Alloc_Data'!I17/'II-F Alloc_Data'!$K17","v":0},{"$f":"+'II-F Alloc_Data'!J17/'II-F Alloc_Data'!$K17","v":0},{"$f":"SUM(E17:J17)","v":1}]
[null,3,"Distribution","DIST",{"$f":"+'II-F Alloc_Data'!E18/'II-F Alloc_Data'!$K18","v":0},{"$f":"+'II-F Alloc_Data'!F18/'II-F Alloc_Data'!$K18","v":1},{"$f":"+'II-F Alloc_Data'!G18/'II-F Alloc_Data'!$K18","v":0},{"$f":"+'II-F Alloc_Data'!H18/'II-F Alloc_Data'!$K18","v":0},{"$f":"+'II-F Alloc_Data'!I18/'II-F Alloc_Data'!$K18","v":0},{"$f":"+'II-F Alloc_Data'!J18/'II-F Alloc_Data'!$K18","v":0},1]
[null,4,"Metering","MET",{"$f":"+'II-F Alloc_Data'!E19/'II-F Alloc_Data'!$K19","v":0},{"$f":"+'II-F Alloc_Data'!F19/'II-F Alloc_Data'!$K19","v":0},{"$f":"+'II-F Alloc_Data'!G19/'II-F Alloc_Data'!$K19","v":1},{"$f":"+'II-F Alloc_Data'!H19/'II-F Alloc_Data'!$K19","v":0},{"$f":"+'II-F Alloc_Data'!I19/'II-F Alloc_Data'!$K19","v":0},{"$f":"+'II-F Alloc_Data'!J19/'II-F Alloc_Data'!$K19","v":0},1]
[null,5,"T-Billing","TD-Bill",{"$f":"+'II-F Alloc_Data'!E20/'II-F Alloc_Data'!$K20","v":0},{"$f":"+'II-F Alloc_Data'!F20/'II-F Alloc_Data'!$K20","v":0},{"$f":"+'II-F Alloc_Data'!G20/'II-F Alloc_Data'!$K20","v":0},{"$f":"+'II-F Alloc_Data'!H20/'II-F Alloc_Data'!$K20","v":1},{"$f":"+'II-F Alloc_Data'!I20/'II-F Alloc_Data'!$K20","v":0},{"$f":"+'II-F Alloc_Data'!J20/'II-F Alloc_Data'!$K20","v":0},1]
[null,6,"TDCS","TDCS",{"$f":"+'II-F Alloc_Data'!E21/'II-F Alloc_Data'!$K21","v":0},{"$f":"+'II-F Alloc_Data'!F21/'II-F Alloc_Data'!$K21","v":0},{"$f":"+'II-F Alloc_Data'!G21/'II-F Alloc_Data'!$K21","v":0},{"$f":"+'II-F Alloc_Data'!H21/'II-F Alloc_Data'!$K21","v":0},{"$f":"+'II-F Alloc_Data'!I21/'II-F Alloc_Data'!$K21","v":0},{"$f":"+'II-F Alloc_Data'!J21/'II-F Alloc_Data'!$K21","v":1},1]

{"sheet":"II-G","index":43,"n_rows":116,"n_cols":14,"rows_kept":116,"cut":false,"hidden":false,"merged":[[2,0,2,13],[60,0,60,13]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule II-G"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 1 of 2"]
["STATUS OF NUCLEAR DECOMMISSIONING FUNDS"]
[null,"Part A:  Trust Activity"]
[]
[null,null,null,"       Unit 1",null,null,null,"       Unit 2",null,null,null,"       Unit 3"]
[]
[null,"TOTAL COMPANY",null,"Qualified",null,"Non-Qualified",null,"Qualified",null,"Non-Qualified",null,"Qualified",null,"Non-Qualified"]
[]
[null,"Beginning Balance",null,0,null,0,null,0,null,0,null,0,null,0]
[null,"Earnings",null,0,null,0,null,0,null,0,null,0,null,0]
[null,"Total Deposits",null,0,null,0,null,0,null,0,null,0,null,0]
[]
[null,"Ending Balance",null,{"$f":"SUM(D10:D12)","v":0},null,{"$f":"SUM(F10:F12)","v":0},null,{"$f":"SUM(H10:H12)","v":0},null,{"$f":"SUM(J10:J12)","v":0},null,{"$f":"SUM(L10:L12)","v":0},null,{"$f":"SUM(N10:N12)","v":0}]
[]
[null,"TEXAS JURISDICTION"]
[]
[null,"Beginning Balance",null,0,null,0,null,0,null,0,null,0,null,0]
[null,"Earnings",null,0,null,0,null,0,null,0,null,0,null,0]
[null,"Total Deposits",null,0,null,0,null,0,null,0,null,0,null,0]
[]
[null,"Ending Balance",null,{"$f":"SUM(D18:D20)","v":0},null,{"$f":"SUM(F18:F20)","v":0},null,{"$f":"SUM(H18:H20)","v":0},null,{"$f":"SUM(J18:J20)","v":0},null,{"$f":"SUM(L18:L20)","v":0},null,{"$f":"SUM(N18:N20)","v":0}]
[]
[]
[]
[null,"Part B:  Trust Investments"]
[]
[null,null,null,"       Unit 1",null,null,null,"       Unit 2",null,null,null,"       Unit 3"]
[]
[null,null,null,"        Percent of Ending Balance",null,null,null,"        Percent of Ending Balance",null,null,null,"        Percent of Ending Balance"]
[null,"Asset Type (Specify)",null,"Qualified",null,"Non-Qualified",null,"Qualified",null,"Non-Qualified",null,"Qualified",null,"Non-Qualified"]
[]
[null,"Text",null,0,null,0,null,0,null,0,null,0,null,0]
[null,"Text",null,0,null,0,null,0,null,0,null,0,null,0]
[null,"Text",null,0,null,0,null,0,null,0,null,0,null,0]
[null,"Text",null,0,null,0,null,0,null,0,null,0,null,0]
[null,"Text",null,0,null,0,null,0,null,0,null,0,null,0]
[null,"Text",null,0,null,0,null,0,null,0,null,0,null,0]
[null,"Text",null,0,null,0,null,0,null,0,null,0,null,0]
[null,"Text",null,0,null,0,null,0,null,0,null,0,null,0]
[null,"Text",null,0,null,0,null,0,null,0,null,0,null,0]
[null,"Text",null,0,null,0,null,0,null,0,null,0,null,0]
[null,"Text",null,0,null,0,null,0,null,0,null,0,null,0]
[]
[null,null,null,{"$f":"SUM(D33:D43)","v":0},null,{"$f":"SUM(F33:F43)","v":0},null,{"$f":"SUM(H33:H43)","v":0},null,{"$f":"SUM(J33:J43)","v":0},null,{"$f":"SUM(L33:L43)","v":0},null,{"$f":"SUM(N33:N43)","v":0}]
[]
[]
[null,"Part C:  Other Information"]
[]
[null,null,null,"       Unit 1",null,null,null,"       Unit 2",null,null,null,"       Unit 3"]
[]
[null,"Name of Trustee(s):",null,"Text",null,null,null,"Text",null,null,null,"Text"]
[null,null,null,"Text",null,null,null,"Text",null,null,null,"Text"]
[null,null,null,"Text",null,null,null,"Text",null,null,null,"Text"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule IIG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 2 of 2"]
["STATUS OF NUCLEAR DECOMMISSIONING FUNDS"]
[]
[null,"Last Decommissioning Cost "]
[null,"Estimate:"]
[]
[null,"    Date:",null,"Text",null,null,null,"Text",null,null,null,"Text"]
[null,"    Amount ($000s):",null,0,null,null,null,0,null,null,null,0]
[]
[]
[null,"Currently Allowed Decommissioning Expense:"]
[null,null,null,null,null,null,null,"Allowed Total",null,"Allowed"]
[null,"Jurisdiction",null,"Effective date",null,"Docket No.",null,"Company Amount",null,"Jurisdictional Amount"]
[]
[null,"Text",null,"Text",null,"Text",null,0,null,0]
[null,"Text",null,"Text",null,"Text",null,0,null,0]
[null,"Text",null,"Text",null,"Text",null,0,null,0]
[null,"Text",null,"Text",null,"Text",null,0,null,0]
[null,"Text",null,"Text",null,"Text",null,0,null,0]
[]
[]
[null,"Part D:  Deposit Schedule"]
[]
[null,null,null,"       Unit 1",null,null,null,"       Unit 2",null,null,null,"       Unit 3"]
[]
[null,null,null,"               Amount of Deposit",null,null,null,"               Amount of Deposit",null,null,null,"               Amount of Deposit"]
[null,"Date of Deposit",null,"Qualified",null,"Non-Qualified",null,"Qualified",null,"Non-Qualified",null,"Qualified",null,"Non-Qualified"]
[]
[null,"Text",null,0,null,0,null,0,null,0,null,0,null,0]
[null,"Text",null,0,null,0,null,0,null,0,null,0,null,0]
[null,"Text",null,0,null,0,null,0,null,0,null,0,null,0]
[null,"Text",null,0,null,0,null,0,null,0,null,0,null,0]
[null,"Text",null,0,null,0,null,0,null,0,null,0,null,0]
[null,"Text",null,0,null,0,null,0,null,0,null,0,null,0]
[null,"Text",null,0,null,0,null,0,null,0,null,0,null,0]
[null,"Text",null,0,null,0,null,0,null,0,null,0,null,0]
[null,"Text",null,0,null,0,null,0,null,0,null,0,null,0]
[null,"Text",null,0,null,0,null,0,null,0,null,0,null,0]
[null,"Text",null,0,null,0,null,0,null,0,null,0,null,0]
[null,"Text",null,0,null,0,null,0,null,0,null,0,null,0]
[]
[null,"Total",null,{"$f":"SUM(D88:D99)","v":0},null,{"$f":"SUM(F88:F99)","v":0},null,{"$f":"SUM(H88:H99)","v":0},null,{"$f":"SUM(J88:J99)","v":0},null,{"$f":"SUM(L88:L99)","v":0},null,{"$f":"SUM(N88:N99)","v":0}]
[]
[]
[null,"Part E:  Reported Annual Rate of Return",null,null,null,null,null,"Since Inception--",null,"Since Inception--"]
[null,null,null,"Reporting Period",null,"Reporting Period",null,"Total ROR",null,"Net ROR"]
[null,"Fund",null,"Annual Total ROR",null,"Annual Net ROR",null,"(Annualized)",null,"(Annualized)"]
[]
[null,"Unit 1 Qualified",null,0,null,0,null,0,null,0]
[null,"Unit 1 Unqualified",null,0,null,0,null,0,null,0]
[null,"Unit 2 Qualified",null,0,null,0,null,0,null,0]
[null,"Unit 2 Unqualified",null,0,null,0,null,0,null,0]
[null,"Unit 3 Qualified",null,0,null,0,null,0,null,0]
[null,"Unit 3 Unqualified",null,0,null,0,null,0,null,0]
[null,"Spent Fuel *",null,0,null,0,null,0,null,0]
[]
[null,"*  Complete line 94 if funding for Spent Fuel is accounted for separately."]

{"sheet":"II-I-1","index":44,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"PUBLIC UTILITY COMMISSION OF TEXAS"]
[null,"XXXXXX COMPANY"]
[null,"II-I-1 CLASS REVENUE REQUIREMENT ANALYSIS"]
[null,"TEST YEAR ENDING X/XX/XXXX"]
[null,"DOCKET XXXXX"]
[]
[null,null,1,3,4,5,6,7,8,9]
[null,null,"Test Year"]
[null,"Description","Revenue","Residential","Secondary","Secondary","Primary","Transmission","Lighting","Total"]
[null,null,"Requirement",null,"=< 10 kW","> 10 kW",null,null,null,"TX-Retail"]
[null,null,"Total"]
[]
[null,"Transmission"]
[null,"Distribution"]
[null,"Metering"]
[null,"Billing"]
[null,"A-Billing"]
[null,"T&D Customer Service"]
[]
[null,"Total Adjusted Revenue Requirement"]

{"sheet":"III-A-1 Wholesale TCOS","index":45,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[null,"PUBLIC UTILITY COMMISSION OF TEXAS"]
[null,"XXXXXX COMPANY"]
[null,"III-A-1 SUMMARY OF WHOLESALE TCOS"]
[null,"TEST YEAR ENDING X/XX/XXXX"]
[null,"DOCKET XXXXX"]
[]
[null,null,null,1,2,3]
[null,null,null,"Company","Transmission",null,"Check"]
[null,"Description","Reference","Total","Function","Total"]
[null,null,"Schedule","Electric","(TRAN)","TX-Retail"]
[]
[]
[null,"Operating and Maintenance Expenses"]
[null,"Depreciation & Amortization Expenses"]
[null,"Taxes Other Than Federal Income Tax"]
[null,"Federal Income Tax"]
[]
[null,"Return on  Invested Capital"]
[]
[null,"TOTAL TRANSMISSION COST OF SERVICE"]
[]
[null,"Minus:  Other Revenues"]
[]
[null,"TOTAL ADJUSTED REVENUE REQUIREMENT"]
[]
[null,"ERCOT 4-CP MW"]
[]
[null,"Wholesale Transmission Rate $/MW"]

{"sheet":"IV-J-1-Revenue Summary","index":46,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"PUBLIC UTILITY COMMISSION OF TEXAS"]
[null,null,"XXXXXX COMPANY"]
[null,null,"IV-J-1 REVENUE SUMMARY"]
[null,null,"TEST YEAR ENDING X/XX/XXXX"]
[null,null,"DOCKET XXXXX"]
[]
[null,null,null,1,null,2,3,4,5,6,7,8]
[null,null,null,"Test Year",null,"Retail Charges"]
[null,"Line","Description","Revenue",null,"Paid By","Residential","Secondary","Secondary","Primary","Transmission","Lighting"]
[null,"No.",null,"Requirement",null,"Ratepayers",null,"≤ 10 kW","> 10 kW"]
[]
[]
[null,1,"Transmission (TRAN)",null,null,"N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[null,{"$f":"B15+1","v":2}]
[null,{"$f":"B16+1","v":3},"Distribution (DIST) (excluding Acct 565)"]
[null,4]
[null,5,"Metering (MET)"]
[null,6]
[null,7,"Customer"]
[null,8,"Billing (TBILL)"]
[null,9,"T&D Customer Service (TDCS)"]
[null,10]
[null,11,"DIST + MET + TBILL + TDCS"]
[null,12]
[null,13,"Total Pertaining to This Rate Case     (1+11)"]
[null,14]
[null,15,"Revenue Charges Approved in Other Dockets"]
[null,16,"Advanced Metering Cost Recovery Factor (AMCRF)"]
[null,17,"Energy Efficiency Cost Recovery Factor (EECRF)"]
[null,18,"Rate Case Expense Surcharge (RCE)"]
[null,19,"Rate Case Expense Surcharge 2 (RCE 2)"]
[null,20,"Transmission Cost Recovery Factor (TCRF)"]
[null,21,"Transition Charge (TC1)"]
[null,22,"Transition Charge 2 (TC2)"]
[null,23,"Subtotal"]
[null,24]
[null,25,"Total Revenue Charges     (11+23)"]
[null,26]
[null,27,"Non-Revenue Charges Approved In Other Dockets"]
[null,28,"Nuclear Decommissioning Charge (NDC)"]
[null,29,"Subtotal"]
[null,30]
[null,31,"Total Charges     (25+29)"]

{"sheet":"Rate Design Summary","index":47,"n_rows":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":false,"merged":[[6,2,6,4],[7,3,7,4],[8,3,8,4],[9,3,9,4]]}
[null,"Public Utility Commission of Texas"]
[null,"Docket No.  XXXXX"]
[null,"Test Year Ended December 31, XXXX"]
[]
[null,"Table1 - Rate Design:"]
[]
[null,"CLASS","RATE CHARGES"]
[]
[null,null,"CHARGES","RECOMMENDATION"]
[]
[null,"RESIDENTIAL","CUSTOMER CHARGE",null,"per customer"]
[null,null,"METERING CHARGE",null,"per customer"]
[null,null,"TRANSMISSION SERVICE CHARGE",null,"per"]
[null,null,"DISTRIBUTION SERVICE CHARGE",null,"per"]
[null,"SECONDARY =<10 kW ","CUSTOMER CHARGE",null,"per customer"]
[null,"(Small)","METERING CHARGE",null,"per customer"]
[null,null,"TRANSMISSION SERVICE CHARGE",null,"per"]
[null,null,"DISTRIBUTION SERVICE CHARGE",null,"per"]
[null,"SECONDARY >10kW","CUSTOMER CHARGE",null,"per customer"]
[null,"(Large)","METERING CHARGE",null,"per customer"]
[null,null,"TRANSMISSION SERVICE CHARGE"]
[null,null,"NON-IDR CUSTOMERS",null,"per"]
[null,null,"IDR CUSTOMERS",null,"per"]
[null,null,"DISTRIBUTION SERVICE CHARGE",null,"per"]
[null,"PRIMARY","CUSTOMER CHARGE",null,"per customer"]
[null,null,"METERING CHARGE",null,"per customer"]
[null,null,"TRANSMISSION SERVICE CHARGE",null,"per"]
[null,null,"NON-IDR CUSTOMERS"]
[null,null,"IDR CUSTOMER"]
[null,null,"DISTRIBUTION SERVICE CHARGE",null,"per"]
[null,"TRANSMISSION","CUSTOMER CHARGE",null,"per customer"]
[null,null,"METERING CHARGE",null,"per customer"]
[null,null,"TRANSMISSION SERVICE CHARGE",null,"per"]
[null,null,"DISTRIBUTION SERVICE CHARGE",null,"per"]

{"sheet":"Residential","index":48,"n_rows":42,"n_cols":11,"rows_kept":42,"cut":false,"hidden":false,"merged":[[15,3,15,4]]}
[null,"PROOF OF REVENUE STATEMENT"]
[null,"FOR THE YEAR ENDING DECEMBER 31, XXXX"]
[]
[null,"RESIDENTIAL SERVICE"]
[]
[]
[]
[null,null,null,"ESTIMATED"]
[null,null,null,"BILLING "]
[null,"CLASS BILLING STATISTICS",null,"UNITS"]
[null,"Number of Annual Bills",null,12]
[null,"Annual kWh",null,1]
[null,"Annual Billing kW",null,1]
[]
[null,null,null,"CALCULATION OF UNIT CHARGES USING ESTIMATED BILLING UNITS"]
[null,null,null,"POINT OF DELIVERY",null,null,"FACILITIES CHARGE",null,null,"FACILITIES CHARGE"]
[null,null,null,"(POD) CHARGE",null,null,"(PER KWH)",null,null,"(PER KW)"]
[null,"FUNCTION",null,"$","$/Bill/Month",null,"$","$/kWh",null,"$","$/kW"]
[null,"1.  Transmission (TRAN)",null,0,0,null,0,0,null,0,{"$f":"IF(J19=0,J19,ROUND(J19/G$13,4))","v":0}]
[null,"2.  Distribution (DIST)",null,0,0,null,null,{"$f":"IF(G20=0,G20,ROUND(G20/D$12,5))","v":0},null,0,0]
[null,"3.  Transmission & Distribution Utility"]
[null,"      Metering System Services (MET)",null,null,{"$f":"IF(D22=0,D22,ROUND(D22/D$11,2))","v":0},null,0,0,null,0,0]
[null,"4.  Transmission & Distribution Utility"]
[null,"      Billing System Services (TD-BILL)",null,null,{"$f":"IF(D24=0,D24,ROUND(D24/D$11,2))","v":0},null,0,0]
[null,"5.  Additional Billing Services (A-BILL)",null,0,0,null,0,0,null,0,0]
[null,"6.  Transmission & Distribution Utility"]
[null,"      Customer Service (TDCS)",null,null,{"$f":"IF(D27=0,D27,ROUND(D27/D$11,2))","v":0},null,0,0]
[null,"                         TOTAL",null,{"$f":"IF(SUM(D19:D27)<1,D19,SUM(D19:D27))","v":0},{"$f":"SUM(E19:E27)","v":0},null,{"$f":"IF(SUM(G19:G27)<1,G19,SUM(G19:G27))","v":0},{"$f":"SUM(H19:H27)","v":0},null,{"$f":"IF(SUM(J19:J27)<1,J19,SUM(J19:J27))","v":0},{"$f":"IF(SUM(K19:K27)<1,K19,SUM(K19:K27))","v":0}]
[]
[null,null,null,"FUNCTION",null,null,"PROPOSED CHARGES"]
[null,null,null,"SUMMARY",null,null,null,"UNIT",null,"TOTAL"]
[null,"FUNCTION",null,"$",null,null,"DESCRIPTION","CHARGE",null,"REVENUE"]
[null,"1.  Transmission (TRAN)",null,0]
[null,"2.  Distribution (DIST)",null,{"$f":"D20+G20+J20","v":0},null,null,"POD CHARGE",{"$f":"+E28","v":0},null,{"$f":"ROUND(+H34*D11,0)","v":0}]
[null,"3.  Transmission & Distribution Utility",null,null,null,null,"FACILITIES CHARGE",{"$f":"+H28","v":0},"*",{"$f":"ROUND(+H35*D12,0)","v":0}]
[null,"      Metering System Services (MET)",null,{"$f":"D22+G22+J22","v":0},null,null,"  TOTAL",null,null,{"$f":"SUM(J34:J35)","v":0}]
[null,"4.  Transmission & Distribution Utility"]
[null,"      Billing System Services (TD-BILL)",null,{"$f":"D24+G24+J24","v":0},null,null," *Unit Charge is per kWh"]
[null,"5.  Additional Billing Services (A-BILL)",null,0]
[null,"6.  Transmission & Distribution Utility"]
[null,"      Customer Service (TDCS)",null,{"$f":"D27+G27+J27","v":0}]
[null,"                         TOTAL",null,{"$f":"SUM(D33:D41)","v":0}]

{"sheet":"Secondary- Small","index":49,"n_rows":42,"n_cols":11,"rows_kept":42,"cut":false,"hidden":false,"merged":[[15,3,15,4]]}
[null,"PROOF OF REVENUE STATEMENT"]
[null,"FOR THE YEAR ENDING DECEMBER 31, XXXX"]
[]
[null,"SECONDARY (SMALL)"]
[]
[]
[]
[null,null,null,"ESTIMATED"]
[null,null,null,"BILLING "]
[null,"CLASS BILLING STATISTICS",null,"UNITS"]
[null,"Number of Annual Bills",null,12]
[null,"Annual kWh",null,1]
[null,"Annual Billing kW",null,1]
[]
[null,null,null,"CALCULATION OF UNIT CHARGES USING ESTIMATED BILLING UNITS"]
[null,null,null,"POINT OF DELIVERY",null,null,"FACILITIES CHARGE",null,null,"FACILITIES CHARGE"]
[null,null,null,"(POD) CHARGE",null,null,"(PER KWH)",null,null,"(PER KW)"]
[null,"FUNCTION",null,"$","$/Bill/Month",null,"$","$/kWh",null,"$","$/kW"]
[null,"1.  Transmission (TRAN)",null,0,0,null,0,0,null,0,0]
[null,"2.  Distribution (DIST)",null,0,0,null,null,{"$f":"IF(G20=0,G20,ROUND(G20/D$12,5))","v":0},null,0,0]
[null,"3.  Transmission & Distribution Utility"]
[null,"      Metering System Services (MET)",null,null,{"$f":"IF(D22=0,D22,ROUND(D22/D$11,2))","v":0},null,0,0,null,0,0]
[null,"4.  Transmission & Distribution Utility"]
[null,"      Billing System Services (TD-BILL)",null,null,{"$f":"IF(D24=0,D24,ROUND(D24/D$11,2))","v":0},null,0,0]
[null,"5.  Additional Billing Services (A-BILL)",null,0,0,null,0,0,null,0,0]
[null,"6.  Transmission & Distribution Utility"]
[null,"      Customer Service (TDCS)",null,null,{"$f":"IF(D27=0,D27,ROUND(D27/D$11,2))","v":0},null,0,0]
[null,"                         TOTAL",null,{"$f":"IF(SUM(D19:D27)<1,D19,SUM(D19:D27))","v":0},{"$f":"SUM(E19:E27)","v":0},null,{"$f":"IF(SUM(G19:G27)<1,G19,SUM(G19:G27))","v":0},{"$f":"SUM(H19:H27)","v":0},null,{"$f":"IF(SUM(J19:J27)<1,J19,SUM(J19:J27))","v":0},{"$f":"IF(SUM(K19:K27)<1,K19,SUM(K19:K27))","v":0}]
[]
[null,null,null,"FUNCTION",null,null,"PROPOSED CHARGES"]
[null,null,null,"SUMMARY",null,null,null,"UNIT",null,"TOTAL"]
[null,"FUNCTION",null,"$",null,null,"DESCRIPTION","CHARGE",null,"REVENUE"]
[null,"1.  Transmission (TRAN)",null,0]
[null,"2.  Distribution (DIST)",null,{"$f":"+G20","v":0},null,null,"POD CHARGE",{"$f":"+E28","v":0},null,{"$f":"ROUND(+H34*D11,0)","v":0}]
[null,"3.  Transmission & Distribution Utility",null,null,null,null,"FACILITIES CHARGE",{"$f":"+H28","v":0},"*",{"$f":"ROUND(+H35*D12,0)","v":0}]
[null,"      Metering System Services (MET)",null,{"$f":"+D22","v":0},null,null,"  TOTAL",null,null,{"$f":"SUM(J34:J35)","v":0}]
[null,"4.  Transmission & Distribution Utility"]
[null,"      Billing System Services (TD-BILL)",null,{"$f":"+D24","v":0},null,null," *Unit Charge is per kWh"]
[null,"5.  Additional Billing Services (A-BILL)",null,0]
[null,"6.  Transmission & Distribution Utility"]
[null,"      Customer Service (TDCS)",null,{"$f":"+D27","v":0}]
[null,"                         TOTAL",null,{"$f":"SUM(D33:D41)","v":0}]

{"sheet":"Secondary-Large","index":50,"n_rows":42,"n_cols":11,"rows_kept":42,"cut":false,"hidden":false,"merged":[[15,3,15,4]]}
[null,"PROOF OF REVENUE STATEMENT"]
[null,"FOR THE YEAR ENDING DECEMBER 31, XXXX"]
[]
[null,"SECONDARY (LARGE)"]
[]
[]
[]
[null,null,null,"ESTIMATED"]
[null,null,null,"BILLING "]
[null,"CLASS BILLING STATISTICS",null,"UNITS"]
[null,"Number of Annual Bills",null,12]
[null,"Annual kWh",null,1]
[null,"Annual Billing kW",null,1]
[]
[null,null,null,"CALCULATION OF UNIT CHARGES USING ESTIMATED BILLING UNITS"]
[null,null,null,"POINT OF DELIVERY",null,null,"FACILITIES CHARGE",null,null,"FACILITIES CHARGE"]
[null,null,null,"(POD) CHARGE",null,null,"(PER KWH)",null,null,"(PER KW)"]
[null,"FUNCTION",null,"$","$/Bill/Month",null,"$","$/kWh",null,"$","$/kW"]
[null,"1.  Transmission (TRAN)",null,0,0,null,0,0,null,0,0]
[null,"2.  Distribution (DIST)",null,0,0,null,0,{"$f":"IF(G20=0,G20,ROUND(G20/D$12,5))","v":0},null,null,{"$f":"ROUND(+J20/D13,5)","v":0}]
[null,"3.  Transmission & Distribution Utility"]
[null,"      Metering System Services (MET)",null,null,{"$f":"IF(D22=0,D22,ROUND(D22/D$11,2))","v":0},null,0,0,null,0,0]
[null,"4.  Transmission & Distribution Utility"]
[null,"      Billing System Services (TD-BILL)",null,null,{"$f":"IF(D24=0,D24,ROUND(D24/D$11,2))","v":0},null,0,0]
[null,"5.  Additional Billing Services (A-BILL)",null,0,0,null,0,0,null,0,0]
[null,"6.  Transmission & Distribution Utility"]
[null,"      Customer Service (TDCS)",null,null,{"$f":"IF(D27=0,D27,ROUND(D27/D$11,2))","v":0},null,0,0,null,0,0]
[null,"                         TOTAL",null,{"$f":"IF(SUM(D19:D27)<1,D19,SUM(D19:D27))","v":0},{"$f":"SUM(E19:E27)","v":0},null,0,{"$f":"SUM(H19:H27)","v":0},null,{"$f":"IF(SUM(J19:J27)<1,J19,SUM(J19:J27))","v":0},{"$f":"IF(SUM(K19:K27)<1,K19,SUM(K19:K27))","v":0}]
[]
[null,null,null,"FUNCTION",null,null,"PROPOSED CHARGES"]
[null,null,null,"SUMMARY",null,null,null,"UNIT",null,"TOTAL"]
[null,"FUNCTION",null,"$",null,null,"DESCRIPTION","CHARGE",null,"REVENUE"]
[null,"1.  Transmission (TRAN)",null,0]
[null,"2.  Distribution (DIST)",null,{"$f":"+J20","v":0},null,null,"POD CHARGE",{"$f":"+E28","v":0},null,{"$f":"ROUND(+H34*D11,0)","v":0}]
[null,"3.  Transmission & Distribution Utility",null,null,null,null,"FACILITIES CHARGE",{"$f":"+K28","v":0},"*",{"$f":"ROUND(+H35*D13,0)","v":0}]
[null,"      Metering System Services (MET)",null,{"$f":"+D22","v":0},null,null,"  TOTAL",null,null,{"$f":"SUM(J34:J35)","v":0}]
[null,"4.  Transmission & Distribution Utility"]
[null,"      Billing System Services (TD-BILL)",null,{"$f":"+D24","v":0},null,null," *Unit Charge is per kW"]
[null,"5.  Additional Billing Services (A-BILL)",null,0]
[null,"6.  Transmission & Distribution Utility"]
[null,"      Customer Service (TDCS)",null,{"$f":"+D27","v":0}]
[null,"                         TOTAL",null,{"$f":"SUM(D33:D41)","v":0}]

{"sheet":"Primary","index":51,"n_rows":42,"n_cols":11,"rows_kept":42,"cut":false,"hidden":false,"merged":[[15,3,15,4]]}
[null,"PROOF OF REVENUE STATEMENT"]
[null,"FOR THE YEAR ENDING DECEMBER 31, XXXX"]
[]
[null,"PRIMARY"]
[]
[]
[]
[null,null,null,"ESTIMATED"]
[null,null,null,"BILLING "]
[null,"CLASS BILLING STATISTICS",null,"UNITS"]
[null,"Number of Annual Bills",null,12]
[null,"Annual kWh",null,1]
[null,"Annual Billing kW",null,1]
[]
[null,null,null,"CALCULATION OF UNIT CHARGES USING ESTIMATED BILLING UNITS"]
[null,null,null,"POINT OF DELIVERY",null,null,"FACILITIES CHARGE",null,null,"FACILITIES CHARGE"]
[null,null,null,"(POD) CHARGE",null,null,"(PER KWH)",null,null,"(PER KW)"]
[null,"FUNCTION",null,"$","$/Bill/Month",null,"$","$/kWh",null,"$","$/kW"]
[null,"1.  Transmission (TRAN)",null,0,0,null,0,0,null,0,0]
[null,"2.  Distribution (DIST)",null,0,0,null,null,{"$f":"IF(G20=0,G20,ROUND(G20/D$12,5))","v":0},null,0,0]
[null,"3.  Transmission & Distribution Utility"]
[null,"      Metering System Services (MET)",null,null,{"$f":"IF(D22=0,D22,ROUND(D22/D$11,2))","v":0},null,0,0,null,0,0]
[null,"4.  Transmission & Distribution Utility"]
[null,"      Billing System Services (TD-BILL)",null,null,{"$f":"IF(D24=0,D24,ROUND(D24/D$11,2))","v":0},null,0,0]
[null,"5.  Additional Billing Services (A-BILL)",null,0,0,null,0,0,null,0,0]
[null,"6.  Transmission & Distribution Utility"]
[null,"      Customer Service (TDCS)",null,null,{"$f":"IF(D27=0,D27,ROUND(D27/D$11,2))","v":0},null,0,0,null,0,0]
[null,"                         TOTAL",null,{"$f":"IF(SUM(D19:D27)<1,D19,SUM(D19:D27))","v":0},{"$f":"SUM(E19:E27)","v":0},null,{"$f":"+G20","v":0},{"$f":"+G28/D12","v":0},null,{"$f":"IF(SUM(J19:J27)<1,J19,SUM(J19:J27))","v":0},0]
[]
[null,null,null,"FUNCTION",null,null,"PROPOSED CHARGES"]
[null,null,null,"SUMMARY",null,null,null,"UNIT",null,"TOTAL"]
[null,"FUNCTION",null,"$",null,null,"DESCRIPTION","CHARGE",null,"REVENUE"]
[null,"1.  Transmission (TRAN)",null,0]
[null,"2.  Distribution (DIST)",null,{"$f":"+G20","v":0},null,null,"POD CHARGE",{"$f":"+E28","v":0},null,{"$f":"ROUND(+H34*D11,0)","v":0}]
[null,"3.  Transmission & Distribution Utility",null,null,null,null,"FACILITIES CHARGE",{"$f":"+H28","v":0},"*",{"$f":"ROUND(+H35*D12,0)","v":0}]
[null,"      Metering System Services (MET)",null,{"$f":"+D22","v":0},null,null,"  TOTAL",null,null,{"$f":"SUM(J34:J35)","v":0}]
[null,"4.  Transmission & Distribution Utility"]
[null,"      Billing System Services (TD-BILL)",null,{"$f":"+D24","v":0},null,null," *Unit Charge is per kWh"]
[null,"5.  Additional Billing Services (A-BILL)",null,0]
[null,"6.  Transmission & Distribution Utility"]
[null,"      Customer Service (TDCS)",null,{"$f":"+D27","v":0}]
[null,"                         TOTAL",null,{"$f":"SUM(D33:D41)","v":0}]

{"sheet":"Transmission","index":52,"n_rows":42,"n_cols":11,"rows_kept":42,"cut":false,"hidden":false,"merged":[[15,3,15,4]]}
[null,"PROOF OF REVENUE STATEMENT"]
[null,"FOR THE YEAR ENDING DECEMBER 31, XXXX"]
[]
[null,"TRANSMISSION VOLTAGE SERVICE"]
[]
[]
[]
[null,null,null,"ESTIMATED"]
[null,null,null,"BILLING "]
[null,"CLASS BILLING STATISTICS",null,"UNITS"]
[null,"Number of Annual Bills",null,12]
[null,"Annual kWh",null,1]
[null,"Annual Billing kW",null,1]
[]
[null,null,null,"CALCULATION OF UNIT CHARGES USING ESTIMATED BILLING UNITS"]
[null,null,null,"POINT OF DELIVERY",null,null,"FACILITIES CHARGE",null,null,"FACILITIES CHARGE"]
[null,null,null,"(POD) CHARGE",null,null,"(PER KWH)",null,null,"(PER KW)"]
[null,"FUNCTION",null,"$","$/Bill/Month",null,"$","$/kWh",null,"$","$/kW"]
[null,"1.  Transmission (TRAN)",null,0,0,null,0,0,null,0,0]
[null,"2.  Distribution (DIST)",null,0,0,null,0,{"$f":"IF(G20=0,G20,ROUND(G20/D$12,5))","v":0},null,null,{"$f":"ROUND(+J20/D13,5)","v":0}]
[null,"3.  Transmission & Distribution Utility"]
[null,"      Metering System Services (MET)",null,null,{"$f":"IF(D22=0,D22,ROUND(D22/D$11,2))","v":0},null,0,0,null,0,0]
[null,"4.  Transmission & Distribution Utility"]
[null,"      Billing System Services (TD-BILL)",null,null,{"$f":"IF(D24=0,D24,ROUND(D24/D$11,2))","v":0},null,0,0]
[null,"5.  Additional Billing Services (A-BILL)",null,0,0,null,0,0,null,0,0]
[null,"6.  Transmission & Distribution Utility"]
[null,"      Customer Service (TDCS)",null,null,{"$f":"IF(D27=0,D27,ROUND(D27/D$11,2))","v":0},null,0,0]
[null,"                         TOTAL",null,{"$f":"IF(SUM(D19:D27)<1,D19,SUM(D19:D27))","v":0},{"$f":"SUM(E19:E27)","v":0},null,{"$f":"IF(SUM(G19:G27)<1,G19,SUM(G19:G27))","v":0},{"$f":"SUM(H19:H27)","v":0},null,{"$f":"IF(SUM(J19:J27)<1,J19,SUM(J19:J27))","v":0},{"$f":"IF(SUM(K19:K27)<1,K20,SUM(K19:K27))","v":0}]
[]
[null,null,null,"FUNCTION",null,null,"PROPOSED CHARGES"]
[null,null,null,"SUMMARY",null,null,null,"UNIT",null,"TOTAL"]
[null,"FUNCTION",null,"$",null,null,"DESCRIPTION","CHARGE",null,"REVENUE"]
[null,"1.  Transmission (TRAN)",null,0]
[null,"2.  Distribution (DIST)",null,{"$f":"+J20","v":0},null,null,"POD CHARGE",{"$f":"+E28","v":0},null,{"$f":"ROUND(+H34*D11,0)","v":0}]
[null,"3.  Transmission & Distribution Utility",null,null,null,null,"FACILITIES CHARGE",{"$f":"+K28","v":0},"*",{"$f":"ROUND(+H35*D13,0)","v":0}]
[null,"      Metering System Services (MET)",null,{"$f":"+D22","v":0},null,null,"  TOTAL",null,null,{"$f":"SUM(J34:J35)","v":0}]
[null,"4.  Transmission & Distribution Utility"]
[null,"      Billing System Services (TD-BILL)",null,{"$f":"+D24","v":0},null,null," *Unit Charge is per kW"]
[null,"5.  Additional Billing Services (A-BILL)",null,0]
[null,"6.  Transmission & Distribution Utility"]
[null,"      Customer Service (TDCS)",null,{"$f":"+D27","v":0}]
[null,"                         TOTAL",null,{"$f":"SUM(D33:D41)","v":0}]

{"sheet":"Nuclear Decom Fee","index":53,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[null,"PROOF OF REVENUE STATEMENT"]
[null,"FOR THE YEAR ENDING DECEMBER 31, XXXX"]
[]
[null,"NUCLEAR DECOMMISSIONING FEE"]
[]
[]
[null,null,null,"Estimated"]
[null,null,null,"Billing Units",null,null,null,"Charge"]
[null,"Class",null,"kW",null,"kWh",null,"$/kW or $/kWh",null,"$"]
[]
[null,"Residential"]
[]
[null,"Secondary"]
[null,"    =<10 kW"]
[null,"      >10 kW"]
[]
[null,"Primary"]
[]
[null,"Transmission Voltage"]
[null,"Outdoor Lighting"]
[]
[null,"     TOTAL"]
[]
[]
[]
[null,"**The $XXXXXXXX was allocated to the classes based on the following order:"]
[]
[null,"Residential ",null,0]
[null," Secondary - Small",null,0]
[null," Secondary - Large",null,0]
[null," Primary",null,0]
[null,"Transmission Voltage Service",null,0]
[null,"Outdoor Lighting",null,0]
[null,"  Total",null,{"$f":"SUM(D28:D33)","v":0}]

{"sheet":"CTC","index":54,"n_rows":38,"n_cols":10,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[null,"PROOF OF REVENUE STATEMENT"]
[null,"FOR THE YEAR ENDING DECEMBER 31, XXXX"]
[]
[]
[null,"COMPETITION TRANSITION CHARGE - RIDER CTC"]
[]
[null,null,null,"Estimated"]
[null,null,null,"Billing Units",null,null,null,"Charge"]
[null,"Class",null,"kW",null,"kWh",null,"$/kW or $/kWh",null,"$"]
[]
[null,"Residential"]
[]
[null," Secondary"]
[null,"    =<10 kW"]
[null,"      >10 kW"]
[]
[null," Primary"]
[]
[null,"Lighting Service"]
[null,"Transmission Voltage"]
[null,"Instantaneous Interruptible"]
[null,"Noticed Interruptible"]
[]
[null,"     TOTAL"]
[]
[]
[]
[null,"**The $0 was allocated to the classes based on the following order:"]
[]
[]
[null,"Residential ",null,0]
[null,"Secondary",null,0]
[null,"Primary",null,0]
[null,"Transmission Voltage Service",null,0]
[null,"Lighting Service",null,0]
[null,"Instantaneous Interruptible",null,0]
[null,"Noticed Interruptible",null,0]
[null,"  Total",null,{"$f":"SUM(D31:D37)","v":0}]

{"sheet":"SCTC","index":55,"n_rows":37,"n_cols":10,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[null,"PROOF OF REVENUE STATEMENT"]
[null,"FOR THE YEAR ENDING DECEMBER 31, XXXX"]
[]
[null,"STRANDED COST TRANSITION CHARGE - RIDER SCTC"]
[]
[]
[null,null,null,"Estimated"]
[null,null,null,"Billing Units",null,null,null,"Charge"]
[null,"Class",null,"kW",null,"kWh",null,"$/kW or $/kWh",null,"$"]
[]
[null,"Residential"]
[]
[null,"Secondary"]
[null,"    =<10 kW"]
[null,"      >10 kW"]
[]
[null,"Primary"]
[]
[null,"Lighting Service"]
[null,"Transmission Voltage"]
[null,"Instantaneous Interruptible"]
[null,"Noticed Interruptible"]
[]
[null,"     TOTAL"]
[]
[]
[]
[null,"**The $0 was allocated to the classes based on the following order:"]
[]
[null,"Residential ",null,0]
[null,"Secondary",null,0]
[null,"Primary",null,0]
[null,"Transmission Voltage Service",null,0]
[null,"Lighting Service",null,0]
[null,"Instantaneous Interruptible",null,0]
[null,"Noticed Interruptible",null,0]
[null,"  Total",null,{"$f":"SUM(D30:D36)","v":0}]

{"sheet":"TC","index":56,"n_rows":36,"n_cols":10,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[null,"PROOF OF REVENUE STATEMENT"]
[null,"FOR THE YEAR ENDING DECEMBER 31, XXXX"]
[]
[null,"TRANSITION CHARGE (TC)"]
[]
[null,null,null,"Estimated"]
[null,null,null,"Billing Units",null,null,null,"Charge"]
[null,"Class",null,"kW",null,"kWh",null,"$/kW or $/kWh",null,"$"]
[]
[null,"Residential"]
[]
[null,"Secondary"]
[null,"    =<10 kW"]
[null,"      >10 kW"]
[]
[null,"Primary"]
[]
[null,"Lighting Service"]
[null,"Transmission Voltage"]
[null,"Instantaneous Interruptible"]
[null,"Noticed Interruptible"]
[]
[null,"     TOTAL"]
[]
[]
[]
[null,"**The $0 was allocated to the classes based on the following order:"]
[]
[null,"Residential ",null,0]
[null,"Secondary",null,0]
[null,"Primary",null,0]
[null,"Transmission Voltage Service",null,0]
[null,"Lighting Service",null,0]
[null,"Instantaneous Interruptible",null,0]
[null,"Noticed Interruptible",null,0]
[null,"  Total",null,{"$f":"SUM(D29:D35)","v":0}]

{"sheet":"SBF Fee","index":57,"n_rows":20,"n_cols":16,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[null,"PROOF OF REVENUE STATEMENT"]
[null,"FOR THE YEAR ENDING DECEMBER 31, XXXX"]
[]
[null,"SYSTEM BENEFIT FUND - RIDER SBF"]
[]
[null,6.4999999999999997E-4,"Per kWh"]
[]
[]
[]
[null,null,null,"ESTIMATED",null,"SYSTEM BENEFIT",null,"LOSS",null,"KWH"]
[null,"RATE CLASS",null,"KWH",null,"FUND AMOUNT",null,"FACTOR",null,"@ SOURCE",null,"PERCENTAGE",null,"ALLOCATION",null,"SBF/kWh"]
[]
[null,"Residential"]
[null,"Secondary (Small)"]
[null,"Secondary (Large)"]
[null,"Primary"]
[null,"Transmission"]
[null,"Lighting Service"]
[]
[null,"     TOTAL"]

{"sheet":"TCOS Calculation","index":58,"n_rows":90,"n_cols":8,"rows_kept":90,"cut":false,"hidden":false,"merged":[]}
[null,"TRANSMISSION SERVICE CHARGE (OR TCRF IF ALL TRANSMISSION EXPENSE RECOVERY IS THROUGH TCRF)"]
[null,"TRANSMISSION CALCULATIONS*"]
[null,"FOR THE TEST YEAR ENDING DECEMBER 31, XXXX"]
[]
[null,null,"Utility's",null,"Class"]
[null,"Rate Class","Transmission","4CP Allocator","Transmission","Billing Determinant","Type","Per Unit Charge"]
[null,null,"Expense",null,"Expense",null,"(KW, kWh)"]
[]
[null,"Residential",{"$f":"$H$85","v":0},null,{"$f":"+D9*C9","v":0},null,null,{"$f":"E9/F9","v":{"$error":"#DIV/0!"}}]
[null,"Secondary Small",0,null,0,null,null,{"$error":"#DIV/0!"}]
[null,"Secondary Large - Non-IDR",0,null,0,null,null,{"$error":"#DIV/0!"}]
[null,"Secondary Large - IDR",0,null,0,null,null,{"$error":"#DIV/0!"}]
[null,"Primary Small",0,null,0,null,null,{"$error":"#DIV/0!"}]
[null,"Primary Large - Non-IDR",0,null,0,null,null,{"$error":"#DIV/0!"}]
[null,"Primary Large - IDR",0,null,0,null,null,{"$error":"#DIV/0!"}]
[null,"Primary Large - Substation",0,null,0,null,null,{"$error":"#DIV/0!"}]
[null,"Transmission",0,null,0,null,null,{"$error":"#DIV/0!"}]
[null,"Lighting",0,null,0,null,null,"N/A"]
[]
[null,"* This sheet is only used for ERCOT Utilities"]
[]
[]
[]
[]
[]
[]
[null,"Share of ERCOT TCOS Calculation Worksheet","(a)"]
[null,"UTILITY's 4CP kW",null,"20XX 4CP kW"]
[null,null,null,null,"(b)",null,"(c)","(d) = (a)*(c)"]
[null,null,null,null,null,null,"Current"]
[null,null,null,null,"From",null,"Approved","Utility's"]
[null,"Transmission Owners/Load Entities",null,null,"Docket No.",null,"Access Fee ($/KW)","Transmission Expense"]
[null,"AEP Texas Central","AEP-TCC",null,null,null,null,{"$f":"$C$28*G33","v":0}]
[null,"AEP Texas North","AEP-TNC",null,null,null,null,{"$f":"$C$28*G34","v":0}]
[null,"Austin Energy","AENX",null,null,null,null,0]
[null,"Bandera Electric Coop","BAND",null,null,null,null,0]
[null,"Brazos Electric Coop","BEPC",null,null,null,null,0]
[null,"Brownsville Public Utilities Board","BPUB",null,null,null,null,0]
[null,"Bryan Texas Utilities","BRYN",null,null,null,null,0]
[null,"Centerpoint Energy","CNP",null,null,null,null,0]
[null,"Cherokee County Electric Coop","CCECA",null,null,null,null,0]
[null,"College Station, City of","COCS",null,null,null,null,0]
[null,"Cross Texas Transmission, LLC","CTT",null,null,null,null,0]
[null,"Deep East Texas Electric Coop","DETEC",null,null,null,null,0]
[null,"Denton Municipal Electric","DMEX",null,null,null,null,0]
[null,"East Texas Electric Coop","ETEC",null,null,null,null,0]
[null,"Electric Transmission Texas","ETT",null,null,null,null,0]
[null,"Fannin Electric Coop","FANN",null,null,null,null,0]
[null,"Farmers Electric Coop","FECX",null,null,null,null,0]
[null,"Floresville Electric Power System","FEPS",null,null,null,null,0]
[null,"Garland Power and Light","GARL",null,null,null,null,0]
[null,"Golden Spread Electric Coop","GSEC",null,null,null,null,0]
[null,"Grayson County Electric Coop","GCEC",null,null,null,null,0]
[null,"Greenville Electric Utility System","GEUS",null,null,null,null,0]
[null,"Houston County Electric Coop","HCEC",null,null,null,null,0]
[null,"Lamar County Electric Coop","LCEC",null,null,null,null,0]
[null,"Lone Star Transmission","LST",null,null,null,null,0]
[null,"Lower Colorado River Authority","LCRA",null,null,null,null,0]
[null,"Lyntegar Electric Coop","LYEC",null,null,null,null,0]
[null,"Oncor Electric Delivery Company LLC","ONC",null,null,null,null,0]
[null,"Rayburn Country","RCEC",null,null,null,null,0]
[null,"Rio Grande Electric Coop","RGEC",null,null,null,null,0]
[null,"San Antonio City Public Service","SA-CPSB",null,null,null,null,0]
[null,"San Bernard Electric Coop","SBEC",null,null,null,null,0]
[null,"San Miguel Electric Coop","SMEC",null,null,null,null,0]
[null,"Sharyland Utilities","SHRY",null,null,null,null,0]
[null,"South Texas Electric Coop","STEC",null,null,null,null,0]
[null,"Southwest Texas Electric Coop","SWTE",null,null,null,null,0]
[null,"Taylor Electric Coop","TECX",null,null,null,null,0]
[null,"Texas Municipal Power Agency","TMPA",null,null,null,null,0]
[null,"Texas-New Mexico Power Company","TNMP",null,null,null,null,0]
[null,"Trinity Valley Electric Coop","TVEC",null,null,null,null,0]
[null,"Wind Energy Transmission Texas, LLC","WETT",null,null,null,null,0]
[null,"Wood County Electric Coop","WCEC",null,null,null,null,0]
[null,"Subtotal",null,null,null,null,{"$f":"SUM(G33:G74)","v":0},{"$f":"SUM(H33:H74)","v":0}]
[]
[null,"Riders"]
[null,"Centerpoint Energy - Rider IPC","CNP Rider",null,null,null,null,{"$f":"$C$28*G78","v":0}]
[null,"Cross Texas - Rate Case Exp Rider","CTT Rider",null,null,null,null,{"$f":"$C$28*G79","v":0}]
[null,"Lone Star Trans - Rate Case Exp Rider","LST Rider",null,null,null,null,{"$f":"$C$28*G80","v":0}]
[null,"Lyntegar Electric Coop - Rate Case Exp Rider","LYEC Rider",null,null,null,null,{"$f":"$C$28*G81","v":0}]
[null,"Wind Energy Trans - Rate Case Exp Rider","WETT Rider",null,null,null,null,{"$f":"$C$28*G82","v":0}]
[null,"Subtotal",null,null,null,null,{"$f":"SUM(G78:G82)","v":0},{"$f":"SUM(H78:H82)","v":0}]
[]
[null,"TOTAL",null,null,null,null,{"$f":"G75+G83","v":0},{"$f":"H75+H83","v":0}]
[null,"Total ERCOT Postage Stamp Rate $/KW",null,{"$f":"+G85","v":0}]
[]
[null,"Share of ERCOT TCOS (Payments)","Utility's 4CP multiplied by ERCOT Postage Stamp Rate",null,null,null,{"$f":"+C28*G85","v":0}]
[]
[null,"Transmission Expense not included in TRAN Function and included in DIST Function Account 565",null,null,null,null,null,{"$f":"H85","v":0}]