{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Schedule 1","Schedule 2","Schedule 3","Schedule 4","Schedule 5"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":11,"comments":4,"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":"Schedule 1","index":0,"n_rows":53,"n_cols":30,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
[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 1"]
["DUKE ENERGY KENTUCKY"]
["CALCULATION OF RIDER PSM CREDIT FOR MARCH 20XX - MAY 20XX BILLING"]
[]
[]
["Line",null,null,null,"Billing Month"]
["No.",null,"Description",null,"Jan-XX","00:00:00","Feb-XX","00:00:00","Mar-XX",null,"Apr-XX","00:00:00","May-XX","00:00:00","Jun-XX",null,"Jul-XX","00:00:00","Aug-XX","00:00:00","Sep-XX",null,"Oct-XX","00:00:00","Nov-XX"," ","Dec-XX",null,null,"Total"]
[]
[1,null,"Off-System Sales Margin Allocated to Customers"]
[null,null,"(Schedule 2, Line 16)",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,"(+)",{"$f":"'Schedule 2'!AC28","v":0}]
[]
[2,null,"Non-Fuel Related RTO Costs and Credits",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,"(+)",{"$f":"'Schedule 3'!AE24","v":0}]
[null,null,"(Schedule 3, Line 13)"]
[]
[3,null,"Net Proceeds on Capacity Transactions",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,"(+)",{"$f":"'Schedule 4'!AD22","v":0}]
[null,null,"(Schedule 4, Line 11)"]
[]
[4,null,"Net Proceeds from the Sale of Renewable Energy Credits",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,"(+)",0]
[]
[5,null,"Total ",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,{"$f":"SUM(AD10:AD18)","v":0}]
[]
[6,null,"Percentage Allocated to Customers (90% of net margin)",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,0.9]
[]
[7,null,"Total Allocated to Customers (Line 5 x Line 6)",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,"(+)",{"$f":"AD20*AD22","v":0}]
[]
[8,null,"Remaining PSM Credit due to (from) Customers at 12/31/XX"]
[null,null,"(Schedule 5, Line 10)",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,"(+)",{"$f":"'Schedule 5'!F26","v":0}]
[]
[9,null,"Total Amount of Credits due to (from) Customers",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,"(+)",{"$f":"AD24+AD27","v":0}]
[]
[10,null,"Actual Amount Credited to Customers",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,"(-)",{"$f":"SUM(E31:AC31)","v":0}]
[]
[11,null,"Net Refund due to (from) Customers",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,{"$f":"AD29-AD31","v":0}]
[]
[12,null,"Sales (kWh) from FAC Filing for the current quarter"]
[null,null,"     (FAC Schedule 3, Line C)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,null,"÷",0]
[]
[{"$f":"A35+1","v":13},null,"Profit Sharing Mechanism Credit Rate ($/kWh) (a)",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,{"$f":"IF(AD38=0,0,ROUND(AD33/AD36,2))","v":0}]
[]
["Note:"]
["(a)",null,"Rider PSM credits, reductions to bills, are shown as positive numbers without parentheses.  "]
[null,null,"Rider PSM charges, increases to bills, are shown in parentheses."]
[]
[]
[null,null,"Effective Date for Billing:"]
[]
[]
[]
[null,null,"Submitted by:"]
[]
[null,null,"Title:"]
[]
[null,null,"Date Submitted:"]

{"sheet":"Schedule 2","index":1,"n_rows":34,"n_cols":29,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[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 2"]
[{"$f":"'Schedule 1'!A2","v":"DUKE ENERGY KENTUCKY"}]
["OFF-SYSTEM SALES SCHEDULE"]
["PERIOD:    YEAR TO DATE - DECEMBER 31, 20XX"]
[]
[]
["Line"]
["No.",null,"Description",null,"Jan-XX","00:00:00","Feb-XX","00:00:00","Mar-XX",null,"Apr-XX","00:00:00","May-XX","00:00:00","Jun-XX",null,"Jul-XX","00:00:00","Aug-XX","00:00:00","Sep-XX",null,"Oct-XX","00:00:00","Nov-XX"," ","Dec-XX",null,"Total"]
[{"$f":"MAX(A7:A$7)+1","v":1},null,"Off-System Sales Revenue"]
[{"$f":"MAX(A$7:A9)+1","v":2},null,"Asset Energy","(+)",0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUM(E10:Z10)","v":0}]
[{"$f":"MAX(A$7:A10)+1","v":3},null,"Non-Asset Energy","(+)",0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"MAX(A$7:A11)+1","v":4},null,"Bilateral Sales","(+)",0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"MAX(A$7:A12)+1","v":5},null,"Hedges","(+)",0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[]
[{"$f":"A13+1","v":6},null,"  Sub-Total Revenues",null,{"$f":"SUM(E10:E14)","v":0},null,{"$f":"SUM(G10:G14)","v":0},null,{"$f":"SUM(I10:I14)","v":0},null,{"$f":"SUM(K10:K14)","v":0},null,{"$f":"SUM(M10:M14)","v":0},null,{"$f":"SUM(O10:O14)","v":0},null,{"$f":"SUM(Q10:Q14)","v":0},null,{"$f":"SUM(S10:S14)","v":0},null,{"$f":"SUM(U10:U14)","v":0},null,{"$f":"SUM(W10:W14)","v":0},null,{"$f":"SUM(Y10:Y14)","v":0},null,{"$f":"SUM(AA10:AA14)","v":0},null,{"$f":"SUM(E15:Z15)","v":0}]
[]
[{"$f":"MAX(A$7:A16)+1","v":7},null,"Variable Costs Allocable to Off-System Sales"]
[{"$f":"MAX(A$7:A17)+1","v":8},null,"Bilateral Purchases","(+)",0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUM(E18:Z18)","v":0}]
[{"$f":"MAX(A$7:A18)+1","v":9},null,"Non-Native Fuel Cost (a)","(+)",0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"MAX(A$7:A19)+1","v":10},null,"Variable O&M Cost","(+)",0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"MAX(A$7:A20)+1","v":11},null,"SO2 Cost","(+)",0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"MAX(A$7:A21)+1","v":12},null,"NOx Cost","(+)",0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"MAX(A$7:A22)+1","v":13},null,"Fuel Related PJM Costs and Credits(a)","(+)",0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[{"$f":"MAX(A$7:A23)+1","v":14},null,"(Gain)/Loss on Sale of Fuel","(+)",0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[]
[{"$f":"MAX(A$7:A25)+1","v":15},null,"  Sub-Total Expenses",null,{"$f":"SUM(E16:E24)","v":0},null,{"$f":"SUM(G16:G24)","v":0},null,{"$f":"SUM(I16:I24)","v":0},null,{"$f":"SUM(K16:K24)","v":0},null,{"$f":"SUM(M16:M24)","v":0},null,{"$f":"SUM(O16:O24)","v":0},null,{"$f":"SUM(Q16:Q24)","v":0},null,{"$f":"SUM(S16:S24)","v":0},null,{"$f":"SUM(U16:U24)","v":0},null,{"$f":"SUM(W16:W24)","v":0},null,{"$f":"SUM(Y16:Y24)","v":0},null,{"$f":"SUM(AA16:AA24)","v":0},null,{"$f":"SUM(E26:Z26)","v":0}]
[]
[{"$f":"MAX(A$7:A27)+1","v":16},null,"Off-System Sales Margin (Line 6 - Line 15)",null,{"$f":"E15-E26","v":0},null,{"$f":"G15-G26","v":0},null,{"$f":"I15-I26","v":0},null,{"$f":"K15-K26","v":0},null,{"$f":"M15-M26","v":0},null,{"$f":"O15-O26","v":0},null,{"$f":"Q15-Q26","v":0},null,{"$f":"S15-S26","v":0},null,{"$f":"U15-U26","v":0},null,{"$f":"W15-W26","v":0},null,{"$f":"Y15-Y26","v":0},null,{"$f":"AA15-AA26","v":0},null,{"$f":"SUM(E28:Z28)","v":0}]
[]
[]
[]
[]
[null,null,"Note:"]
[null,null,"(a) Line 9 + Line 13, ties to Duke Energy Kentucky's FAC Filing, Schedule 2, Schedule 4 or Schedule 6, Line C."]

{"sheet":"Schedule 3","index":2,"n_rows":24,"n_cols":31,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[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 3"]
[{"$f":"'Schedule 1'!A2","v":"DUKE ENERGY KENTUCKY"}]
["NON-FUEL RELATED RTO CHARGES AND CREDITS"]
[{"$f":"'Schedule 2'!A4","v":"PERIOD:    YEAR TO DATE - DECEMBER 31, 20XX"}]
[]
[]
[]
["Line"]
["No.",null,"Description",null,"PJM BLI",null,{"$f":"'Schedule 2'!E8","v":"Jan-XX"},null,{"$f":"'Schedule 2'!G8","v":"Feb-XX"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'Schedule 2'!I8","v":"Mar-XX"},null,"Apr-XX","00:00:00","May-XX","00:00:00","Jun-XX",null,"Jul-XX","00:00:00","Aug-XX","00:00:00","Sep-XX",null,"Oct-XX",null,"Nov-XX"," ","Dec-XX",null,{"$f":"'Schedule 2'!AC8","v":"Total"}]
[]
[1,null,"Day-Ahead Economic Load Response",null,"1240 / 2240",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,{"$f":"SUM(G11:AD11)","v":0}]
[{"$f":"A11+1","v":2},null,"Real-Time Economic Load Response",null,"1241 / 2241",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,0]
[{"$f":"A12+1","v":3},null,"Day-Ahead Load Response Charge Alloc",null,1242,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,0]
[4,null,"Real-Time Load Response Charge Alloc",null,1243,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,0]
[5,null,"Pre-Emergency and Emergency Load Response",null,"1245 / 2245",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,0]
[6,null,"PJM Reactive Supply",null,"1330 / 2330",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,0]
[7,null,"Non-Syncchronized Reserve",null,"1362 / 2362 / 1472",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,0]
[8,null,"Day-Ahead Scheduling Reserve",null,"1365 / 2365 / 1475",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,0]
[9,null,"Day-Ahead Operating Reserve for Load Response",null,"1371 / 2371",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,0]
[10,null,"Balancing Operating Reserve for Load Response",null,"1376 / 2376",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,0]
[11,null,"Blackstart",null,"1380 / 2380",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,0]
[12,null,"Other",null,null,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,0]
[]
[{"$f":"A22+1","v":13},null,"Total",null,null,null,{"$f":"SUM(G17:G21)","v":0},null,{"$f":"SUM(I17:I21)","v":0},null,{"$f":"SUM(K17:K21)","v":0},null,{"$f":"SUM(M17:M21)","v":0},null,{"$f":"SUM(O17:O21)","v":0},null,{"$f":"SUM(Q17:Q21)","v":0},null,{"$f":"SUM(S17:S21)","v":0},null,{"$f":"SUM(U17:U21)","v":0},null,{"$f":"SUM(W17:W21)","v":0},null,{"$f":"SUM(Y17:Y21)","v":0},null,{"$f":"SUM(AA17:AA21)","v":0},null,{"$f":"SUM(AC17:AC21)","v":0},null,{"$f":"SUM(AE17:AE21)","v":0}]

{"sheet":"Schedule 4","index":3,"n_rows":22,"n_cols":30,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[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 4"]
[{"$f":"'Schedule 1'!A2","v":"DUKE ENERGY KENTUCKY"}]
["CAPACITY TRANSACTIONS"]
[{"$f":"'Schedule 2'!A4","v":"PERIOD:    YEAR TO DATE - DECEMBER 31, 20XX"}]
[]
[]
[]
["Line"]
["No.",null,"Description","PJM BLI",null,{"$f":"'Schedule 2'!E8","v":"Jan-XX"},null,{"$f":"'Schedule 2'!G8","v":"Feb-XX"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'Schedule 2'!I8","v":"Mar-XX"},null,"Apr-XX","00:00:00","May-XX","00:00:00","Jun-XX",null,"Jul-XX","00:00:00","Aug-XX","00:00:00","Sep-XX",null,"Oct-XX",null,"Nov-XX",null,"Dec-XX",null,{"$f":"'Schedule 2'!AC8","v":"Total"}]
[1,null,"Capacity Sales Revenues"]
[2,null,"Revenue Received for Capacity Sales",2600,"(+)",0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUM(F11:AC11)","v":0}]
[3,null,"Bilateral Sales ",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,{"$f":"SUM(F12:J12)","v":0}]
[4,null,"Capacity Performance Credits",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,{"$f":"SUM(F13:J13)","v":0}]
[5,null,"  Sub-Total Revenues",null,null,{"$f":"SUM(F11:F13)","v":0},null,{"$f":"SUM(H11:H13)","v":0},null,{"$f":"SUM(J11:J13)","v":0},null,{"$f":"SUM(L11:L13)","v":0},null,{"$f":"SUM(N11:N13)","v":0},null,{"$f":"SUM(P11:P13)","v":0},null,{"$f":"SUM(R11:R13)","v":0},null,{"$f":"SUM(T11:T13)","v":0},null,{"$f":"SUM(V11:V13)","v":0},null,{"$f":"SUM(X11:X13)","v":0},null,{"$f":"SUM(Z11:Z13)","v":0},null,{"$f":"SUM(AB11:AB13)","v":0},null,{"$f":"SUM(AD11:AD13)","v":0}]
[]
[6,null,"Capacity Purchase Expenses"]
[7,null,"Cost of Replacement Capacity",1600,"(+)",0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUM(F17:AC17)","v":0}]
[8,null,"Bilateral Purchases",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,{"$f":"SUM(F18:AC18)","v":0}]
[9,null,"Capacity Performance Assessments",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,0]
[10,null,"  Sub-Total Expenses",null,null,{"$f":"SUM(F17:F19)","v":0},null,{"$f":"SUM(H17:H19)","v":0},null,{"$f":"SUM(J17:J19)","v":0},null,{"$f":"SUM(L17:L19)","v":0},null,{"$f":"SUM(N17:N19)","v":0},null,{"$f":"SUM(P17:P19)","v":0},null,{"$f":"SUM(R17:R19)","v":0},null,{"$f":"SUM(T17:T19)","v":0},null,{"$f":"SUM(V17:V19)","v":0},null,{"$f":"SUM(X17:X19)","v":0},null,{"$f":"SUM(Z17:Z19)","v":0},null,{"$f":"SUM(AB17:AB19)","v":0},null,{"$f":"SUM(AD17:AD19)","v":0}]
[]
[11,null,"Net Capacity Revenue (Expense) (Line 5 - Line 10)",null,null,{"$f":"F11-F17","v":0},null,{"$f":"H11-H17","v":0},null,{"$f":"J11-J17","v":0},null,{"$f":"L11-L17","v":0},null,{"$f":"N11-N17","v":0},null,{"$f":"P11-P17","v":0},null,{"$f":"R11-R17","v":0},null,{"$f":"T11-T17","v":0},null,{"$f":"V11-V17","v":0},null,{"$f":"X11-X17","v":0},null,{"$f":"Z11-Z17","v":0},null,{"$f":"AB11-AB17","v":0},null,{"$f":"AD11-AD17","v":0}]

{"sheet":"Schedule 5","index":4,"n_rows":26,"n_cols":8,"rows_kept":26,"cut":false,"hidden":false,"merged":[[3,0,3,5]]}
[null,null,null,null,null,null,null,"Schedule 5"]
[{"$f":"'Schedule 1'!A2","v":"DUKE ENERGY KENTUCKY"}]
["RECONCILIATION OF PRIOR PERIOD"]
["PERIOD:    YEAR TO DATE - DECEMBER 31, 20XX"]
["Line"]
["No.",null,"Description",null,null,"Total"]
[]
[1,null,"Off-System Sales Margin Allocated to Customers",null,"(+)",0]
[]
[2,null,"Non-Fuel Related PJM Costs and Credits",null,"(+)",0]
[]
[3,null,"Net Margins on Capacity Transactions Allocated to Customers",null,"(+)",0]
[]
[4,null,"Net Proceeds on the Sale of Solar RECs",null,"(+)",0]
[]
[5,null,"  Sub-Total ",null,null,{"$f":"+F8+F10+F12+F14","v":0}]
[]
[6,null,"Percentage Allocated to Customers (90% of net margin)",null,null,0.9]
[]
[7,null,"Total Allocated to Customers (Line 5 x Line 6)",null,"(+)",{"$f":"F16*F18","v":0}]
[]
[8,null,"Prior Period Over (Under) Recovery",null,"(+)",0]
[]
[9,null,"Actual Amount Credited to Customers 20XX",null,"(-)",0]
[]
[10,null,"  Remaining PSM Credit Due to (From) Customer at 12/31/XX",null,null,{"$f":"F20+F22-F24","v":0}]