{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["LSM-3 Redline ES FORM 1.10"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":31,"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":"LSM-3 Redline ES FORM 1.10","index":0,"n_rows":70,"n_cols":10,"rows_kept":70,"cut":false,"hidden":false,"merged":[]}
[null,"Redline Template Modifications"]
[null,null,null,null,null,null,null,null,"ES FORM 1.10"]
[]
[null,"DUKE ENERGY KENTUCKY, INC."]
[null,"ENVIRONMENTAL SURCHARGE REPORT"]
[]
[null,"Calculation of Current Month Environmental Surcharge Factors"]
[]
[null,"For the Expense Month of "]
[]
[]
[null,"Line",null,null,null,null,null,"Environmental"]
[null,"No.",null,"  E(m) = RORB + OE - EAS + Prior Period Adjustment + (Over)/Under Recovery",null,"Source",null,"Compliance Plans"]
[]
[null,{"$f":"MAX(B$14:B14)+1","v":1},null,"Environmental Compliance Rate Base (RB)",null,"ES Form 2.00",null,0]
[]
[null,{"$f":"MAX(B$14:B16)+1","v":2},null,"RB ÷ 12 months",null,"(1) ÷ 12",null,{"$f":"ROUND(H15/12,0)","v":0}]
[]
[null,{"$f":"MAX(B$14:B18)+1","v":3},null,"Pretax Rate of Return (ROR)",null,"ES Form 1.20"]
[]
[null,{"$f":"MAX(B$14:B20)+1","v":4},null,"Return on the Environmental Compliance Rate Base (RORB)",null,"(2) x (3)",null,{"$f":"ROUND(H17*H19,0)","v":0}]
[]
[null,{"$f":"MAX(B$14:B22)+1","v":5},null,"Environmental Operating Expenses (OE)",null,"ES Form 2.00","+",0]
[]
[null,{"$f":"MAX(B$14:B24)+1","v":6},null,"Less: Proceeds from Emission Allowance Sales (EAS)",null,"ES Form 2.00","-",0]
[]
[null,{"$f":"MAX(B$14:B26)+1","v":7},null,"  Sub-Total E(m)",null,"(4) + (5) - (6)",null,{"$f":"H21+H23-H25","v":0}]
[]
[null,{"$f":"MAX(B$14:B28)+1","v":8},null,"Jurisdictional Allocation Ratio for Expense Month",null,"Line 19",null,null,"(T)"]
[]
[null,{"$f":"MAX(B$14:B30)+1","v":9},null,"Jurisdictional E(m) ",null," (7) x (8)",null,{"$f":"ROUND(H27*H29,0)","v":0}]
[]
[null,{"$f":"MAX(B$14:B32)+1","v":10},null,"Prior Period Adjustment",null,"Note A","+",0]
[]
[null,{"$f":"MAX(B$14:B34)+1","v":11},null,"Adjustment for (Over)/Under Recovery",null,"ES Form 2.00","+"]
[]
[null,{"$f":"MAX(B$14:B36)+1","v":12},null,"Revenue Collected Through Base Rates",null,null,"-",null,"(N)"]
[]
[null,{"$f":"MAX(B$14:B38)+1","v":13},null,"  Total Adjusted Net Jurisdictional E(m)",null,"(9) + (10) + (11) - (12)",null,{"$f":"H31+H33+H35-H37","v":0},"(T)"]
[]
[null,{"$f":"MAX(B$14:B40)+1","v":14},null,"Jurisdictional E(m) to be Recovered in Rider PSM",null,"(7) - (9)",null,{"$f":"H27-H31","v":0}]
[]
[]
[null,"Calculation of Environmental Surcharge Billing Factors"]
[]
[null,null,null,null,null,null,null,"Residential","Non-Residential"]
[null,null,null,null,null,null,null,"(Total Revenue)","(Net Revenue)"]
[]
[null,{"$f":"MAX(B$14:B41)+1","v":15},null,"Revenues as a Percentage of 12-Month Average Total Revenues ",null,"ES Form 3.00",null,"%","%"]
[]
[null,{"$f":"MAX(B$14:B50)+1","v":16},null,"Adjusted Net Jurisdictional E(m) - Allocated ",null,"(13) x (15)",null,0,{"$f":"H39-H51","v":0},"(T)"]
[]
[null,{"$f":"MAX(B$14:B52)+1","v":17},null,"R(m) "]
[null,null,null,"Residential R(m) = Average Total Revenue (Total Revenue excluding ESM Revenue)",null,"ES Form 3.00",null,0]
[null,null,null,"Non-Residential R(m) = Average Net Revenue (Total Revenue excluding ESM Revenue, Base Fuel and FAC Revenue)",null,"ES Form 3.00",null,null,0]
[]
[null,{"$f":"MAX(B$14:B56)+1","v":18},null,"Adjusted Net Jurisdictional E(m) / R(m)",null,"(16) ÷ (17)",null,"%","%","(T)"]
[]
[]
[null,"Calculation of Jurisdictional Allocation Ratio - 12-Month Average"]
[]
[null,{"$f":"MAX(B$14:B61)+1","v":19},null,"Retail Revenue  ",null,"ES Form 3.00",null,0,"%"]
[]
[null,{"$f":"MAX(B$14:B63)+1","v":20},null,"Sales for Resale",null,"Company Records",null,0,"%"]
[]
[null,{"$f":"MAX(B$14:B65)+1","v":21},null,"Total Revenue  ",null,"(19) + (20)",null,{"$f":"H62+H64","v":0},"%","(T)"]
[]
[]
[]
[null,null,null,"Note:  (A) Amounts determined by the Commission during six-month and two-year reviews and corrections determined by the Company for prior period filings. ",null,null,null,null,null,"(T)"]