{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["INPUT","PRINT","SCH M","SCH M-2.1","SCH M-2.2","SCH M-2.3","Rate RS","Rate GS COM","Rate GS IND","Rate GS OPA","Rate FT-LG","Rate IT","SCH N","Revenue Requirements","Proposed Rates","Avg Incr","Module1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":114,"comments":6,"pivot_tables":0},"unopened":[{"sheet":"Module1","index":16,"reason":"part_missing"}],"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":"INPUT","index":0,"n_rows":53,"n_cols":9,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,0,0,10]]}
[{"$f":"IF(H9=1,\"TEST PERIOD WITH RIDERS\",\"TEST PERIOD WITHOUT RIDERS\")","v":"TEST PERIOD WITH RIDERS"}]
[]
["Input Areas in Grey - Current Rates as of April 2025"]
[null,"12 MONTHS FORECASTED",null,{"$f":"IF(H9=1,\"INCLUDES ALL RIDERS\",\"\")","v":"INCLUDES ALL RIDERS"}]
[]
[null,"DUKE ENERGY KENTUCKY"]
[null,"CASE NO. 2025-00125"]
[null,"AUTOMATED RATE CASE FILING SYSTEM"]
[null,"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2026",null,null,null,null,null,1]
[]
[null,"TYPE OF SERVICE:","(GAS SERVICE)"]
[null,"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"]
[null,"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"]
[]
[null,"WITNESS:","B. L. Sailers"]
[]
[null,"CURRENT RATES:"]
[null,"EXPECTED GAS COST:",6.6990999999999996,null,"$ per MCF"]
[]
[null,null,"Do not enter riders below.  Enter them over here!"]
[null,"Rider DSMR:","Current","Proposed",null,"--------->","Current","Proposed"]
[null,"     Rate RS  (HEA)",{"$f":"IF($H$9=1,G22,0)","v":0.3},{"$f":"IF($H$9=1,H22,0)","v":0.3},"Monthly",null,0.3,0.3,"Monthly "]
[null,"     Rate RS",{"$f":"IF($H$9=1,G23,0)","v":1.2489999999999999E-2},{"$f":"IF($H$9=1,H23,0)","v":1.2489999999999999E-2},"$ per MCF",null,1.2489999999999999E-2,1.2489999999999999E-2,"$ per MCF"]
[null,"     Rate GS",{"$f":"IF($H$9=1,G24,0)","v":0},{"$f":"IF($H$9=1,H24,0)","v":0},"$ per MCF",null,0,0,"$ per MCF"]
[]
[null,"Rider PMM:","Current","Proposed",null,null,"Current","Proposed"]
[null,"     Rate RS",{"$f":"IF($H$9=1,G27,0)","v":1.2},1.2,"$ per MCF",null,1.2,1.2,"$ per MCF"]
[null,"     Rate GS",0.3,0.3,"$ per MCF",null,0.3,0.3,"$ per MCF"]
[null,"     Rate FT-L",1.0200000000000001E-2,1.0200000000000001E-2,"$ per MCF",null,1.0200000000000001E-2,1.0200000000000001E-2,"$ per MCF"]
[null,"     Rate IT",1.15E-2,1.15E-2,"$ per MCF",null,1.15E-2,1.15E-2,"$ per MCF"]
[]
[null,"Rider GCAT:","Current","Proposed"]
[null,"     Rate FT-L",3.6999999999999998E-2,3.6999999999999998E-2,"$ per MCF"]
[]
[null,"Interdepartmental Rates","Current","Proposed"]
[null,"Customer Charge ",null,null,"$ per MCF","Not used"]
[]
[]
[null,"Rate RS:","Current","Proposed"]
[null,"     Customer Charge",17.5,{"$f":"'Proposed Rates'!C14","v":20},"$ per Month"]
[null,"     Delivery Rate",5.2473999999999998,{"$f":"'Proposed Rates'!C20","v":7.0423999999999998},"$ per MCF"]
[]
[null,"Rate GS:","Current","Proposed"]
[null,"     Customer Charge",58,{"$f":"'Proposed Rates'!G14","v":65},"$ per Month"]
[null,"     Delivery Rate",3.7443,{"$f":"'Proposed Rates'!G22","v":5.5681000000000003},"$ per MCF"]
[]
[null,"Rate FT-L:","Current","Proposed"]
[null,"     Administrative Charge",430,{"$f":"'Proposed Rates'!K14","v":430},"$ per Month"]
[null,"     Delivery Rate",2.1976,{"$f":"'Proposed Rates'!K22","v":2.1688000000000001},"$ per MCF"]
[]
[null,"Rate IT:","Current","Proposed"]
[null,"     Administrative Charge",430,{"$f":"'Proposed Rates'!O14","v":430},"$ per Month"]
[null,"     Commodity Charge",1.1300000000000001,{"$f":"'Proposed Rates'!O20","v":1.1497999999999999},"$ per MCF"]

{"sheet":"PRINT","index":1,"n_rows":6,"n_cols":12,"rows_kept":6,"cut":false,"hidden":false,"merged":[[5,11,5,17]]}
[null," "]
[]
[]
[]
[]
[null,"SCHEDULE M-2.2 (CURRENT RATES)",null,null,null,null,null,null,null,null,null,"SCHEDULE M-2.3 (PROPOSED RATES)"]

{"sheet":"SCH M","index":2,"n_rows":50,"n_cols":11,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[{"$f":"COMPANY","v":"DUKE ENERGY KENTUCKY"}]
[{"$f":"CASE","v":"CASE NO. 2025-00125"}]
["REVENUES AT PRESENT AND PROPOSED RATES"]
[{"$f":"TIME_PERIOD","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2026"}]
[{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[]
[{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,"SCHEDULE M"]
[{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,"PAGE  1  OF  1"]
["WORK PAPER REFERENCE NO(S).:",null,null,null,null,null,null,null,null,null,"WITNESS:"]
[{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"B. L. Sailers"}]
[{"$f":"INPUT!D4","v":"INCLUDES ALL RIDERS"}]
[]
[]
[null,null,null,null,"REVENUE AT",null,"REVENUE AT",null,"REVENUE",null,"% OF"]
["LINE",null,"RATE",null,"PRESENT",null,"PROPOSED",null,"CHANGE",null,"REVENUE"]
[" NO.",null,"CLASSIFICATION",null,"RATES",null,"RATES",null,"(AMOUNT)",null,"CHANGE"]
[null,null,"(A)",null,"(B)",null,"(C)",null,"(D=C-B)",null,"(E=D / B)"]
[null,null,null,null,"($)",null,"($)",null,"($)"]
[1,null,"SALES SERVICE:"]
[]
[2,null,"RS RESIDENTIAL ",null,{"$f":"'Rate RS'!AN81","v":101928645},null,{"$f":"'Rate RS'!R39","v":115918494},null,{"$f":"G21-E21","v":13989849},null,{"$f":"IF(E21=0,\"0.00%\",ROUND(I21/E21,4))","v":0.13730000000000001}]
[3,null,"TOTAL RS",null,{"$f":"E21","v":101928645},null,{"$f":"G21","v":115918494},null,{"$f":"I21","v":13989849},null,{"$f":"IF(E22=0,\"0.00%\",ROUND(I22/E22,4))","v":0.13730000000000001}]
[]
[4,null,"GS COMMERCIAL",null,{"$f":"'Rate GS COM'!AN79","v":36273066},null,{"$f":"'Rate GS COM'!R38","v":42200444},null,{"$f":"G24-E24","v":5927378},null,{"$f":"IF(E24=0,\"0.00%\",ROUND(I24/E24,4))","v":0.16339999999999999}]
[5,null,"GS INDUSTRIAL",null,{"$f":"'Rate GS IND'!AN84","v":2328697},null,{"$f":"'Rate GS IND'!R38","v":2718191},null,{"$f":"G25-E25","v":389494},null,{"$f":"IF(E25=0,\"0.00%\",ROUND(I25/E25,4))","v":0.1673}]
[6,null,"GS OTHER PUB AUTH",null,{"$f":"'Rate GS OPA'!AN81","v":3042937},null,{"$f":"'Rate GS OPA'!R38","v":3549470},null,{"$f":"G26-E26","v":506533},null,{"$f":"IF(E26=0,\"0.00%\",ROUND(I26/E26,4))","v":0.16650000000000001}]
[7,null,"TOTAL GS",null,{"$f":"SUM(E24:E26)","v":41644700},null,{"$f":"SUM(G24:G26)","v":48468105},null,{"$f":"SUM(I24:I26)","v":6823405},null,{"$f":"IF(E27=0,\"0.00%\",ROUND(I27/E27,4))","v":0.1638}]
[]
[8,null,"     TOTAL SALES SERVICE",null,{"$f":"E22+E27","v":143573345},null,{"$f":"G22+G27","v":164386599},null,{"$f":"I22+I27","v":20813254},null,{"$f":"IF(E29=0,\"0.00%\",ROUND(I29/E29,4))","v":0.14499999999999999}]
[]
[9,null,"TRANSPORTATION:"]
[]
[10,null,"FT LARGE",null,{"$f":"'Rate FT-LG'!AN73","v":7378468},null,{"$f":"'Rate FT-LG'!R35","v":7292005},null,{"$f":"G33-E33","v":-86463},null,{"$f":"IF(E33=0,\"0.00%\",ROUND(I33/E33,4))","v":-1.17E-2}]
[11,null,"IT",null,{"$f":"'Rate IT'!AN74","v":1986270},null,{"$f":"'Rate IT'!R34","v":2019038},null,{"$f":"G34-E34","v":32768},null,{"$f":"IF(E34=0,\"0.00%\",ROUND(I34/E34,4))","v":1.6500000000000001E-2}]
[12,null,"     TOTAL TRANSPORTATION",null,{"$f":"SUM(E33:E34)","v":9364738},null,{"$f":"SUM(G33:G34)","v":9311043},null,{"$f":"SUM(I33:I34)","v":-53695},null,{"$f":"IF(E35=0,\"0.00%\",ROUND(I35/E35,4))","v":-5.7000000000000002E-3}]
[13,null,"TOTAL THROUGHPUT",null,{"$f":"E35+E29","v":152938083},null,{"$f":"G35+G29","v":173697642},null,{"$f":"I35+I29","v":20759559},null,{"$f":"IF(E36=0,\"0.00%\",ROUND(I36/E36,4))","v":0.13569999999999999}]
[14,null,"MISCELLANEOUS REVENUES:"]
[]
[15,null,"LATE PAYMENT CHARGES",null,{"$f":"'SCH M-2.2'!V37","v":358320},null,{"$f":"'SCH M-2.3'!R37","v":358320},null,{"$f":"G39-E39","v":0},null,{"$f":"IF(I39=0,\"0.00%\",ROUND(I39/E39,4))","v":"0.00%"}]
[16,null,"BAD CHECK CHARGES",null,{"$f":"'SCH M-2.2'!V38","v":21480},null,{"$f":"'SCH M-2.3'!R38","v":21480},null,0,null,"0.00%"]
[17,null,"RECONNECTION CHARGES",null,{"$f":"'SCH M-2.2'!V39","v":8664},null,{"$f":"'SCH M-2.3'!R39","v":10589},null,1925,null,0.22220000000000001]
[18,null,"FIELD COLLECTION CHARGES",null,{"$f":"'SCH M-2.2'!V40","v":0},null,{"$f":"'SCH M-2.3'!R40","v":0},null,0,null,"0.00%"]
[19,null,"INTERDEPARTMENTAL",null,{"$f":"'SCH M-2.2'!V41","v":49830},null,{"$f":"'SCH M-2.3'!R41","v":58200},null,8370,null,0.16800000000000001]
[20,null,"SPECIAL CONTRACTS",null,{"$f":"'SCH M-2.2'!V42","v":677460},null,{"$f":"'SCH M-2.3'!R42","v":1532059},null,854599,null,1.2615000000000001]
[21,null,"REVENUE TRANSP OF GAS-INTERCO",null,{"$f":"'SCH M-2.2'!V43","v":0},null,{"$f":"'SCH M-2.3'!R43","v":0},null,0,null,"0.00%"]
[22,null,"PROVISION FOR RATE REFUNDS",null,{"$f":"'SCH M-2.2'!V44","v":0},null,{"$f":"'SCH M-2.3'!R44","v":0},null,{"$f":"G46-E46","v":0},null,{"$f":"IF(I46=0,\"0.00%\",ROUND(I46/E46,4))","v":"0.00%"}]
[23,null,"OTHER MISC",null,{"$f":"'SCH M-2.2'!V45","v":21852},null,{"$f":"'SCH M-2.3'!R45","v":21852},null,0,null,"0.00%"]
[24,null,"   TOTAL MISCELLANEOUS",null,{"$f":"SUM(E39:E47)","v":1137606},null,{"$f":"SUM(G39:G47)","v":2002500},null,{"$f":"SUM(I39:I47)","v":864894},null,0.76029999999999998]
[]
[25,null,"TOTAL COMPANY REVENUE",null,{"$f":"E29+E35+E48","v":154075689},null,{"$f":"G29+G35+G48","v":175700142},null,{"$f":"I29+I35+I48","v":21624453},null,{"$f":"IF(I50=0,\"0.00%\",ROUND(I50/E50,4))","v":0.14030000000000001}]

{"sheet":"SCH M-2.1","index":3,"n_rows":36,"n_cols":20,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[{"$f":"COMPANY","v":"DUKE ENERGY KENTUCKY"}]
[{"$f":"CASE","v":"CASE NO. 2025-00125"}]
["TEST PERIOD REVENUES AT CURRENT AVERAGE RATES"]
[{"$f":"TIME_PERIOD","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2026"}]
[{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE M-2.1"]
[{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PAGE  1  OF  1"]
["WORK PAPER REFERENCE NO(S).:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,{"$f":"INPUT!D4","v":"INCLUDES ALL RIDERS"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"B. L. Sailers"}]
["TEST PERIOD"]
[]
[null,null,null,null,null,null,null,null,null,"TEST PERIOD",null,null,null,"% OF REV"]
[null,null,null,null,null,null,null,null,null,"REVENUE LESS",null,"CURRENT",null,"TO TOTAL",null,null,null,"TEST PERIOD"]
["LINE",null,"RATE","CLASS /",null,"CUSTOMER",null,null,null,"GAS COST",null,"AVERAGE",null,"EXCLUSIVE OF ",null,"GAS COST",null,"REVENUE",null,"% OF REV"]
[" NO.",null,"CODE","DESCRIPTION",null,"BILLS",null,"SALES",null,"REVENUE",null,"RATE",null,"GAS COST",null,"REVENUE",null,"TOTAL",null,"TO TOTAL"]
[null,null,"(A)","(B)",null,"(C)",null,"(D)",null,"(E)",null,"(F=E/D)",null,"(G)",null,"(H)",null,"(I)",null,"(J)"]
[]
[null,null,null,null,null,null,null,"(MCF)",null,"($)",null,"($/MCF)",null,"(%)",null,"($)",null,"($)",null,"(%)"]
[1,null,"RS","RESIDENTIAL SERVICE",null,{"$f":"'Rate RS'!X81","v":1194296},null,{"$f":"'Rate RS'!Z81","v":6130423},null,{"$f":"'Rate RS'!AD81","v":60860328},null,{"$f":"IF(H19=0,\"-\",ROUND(J19/H19,4))","v":9.9276},null,{"$f":"IF(ABS(J19/$J$34*100)<0.005,\"-\",ROUND(J19/$J$34*100,2))-0.01","v":67.509999999999991},null,{"$f":"'Rate RS'!AL81","v":41068317},null,{"$f":"J19+P19","v":101928645},null,{"$f":"IF(ABS(R19/$R$34*100)<0.005,\"-\",ROUND(R19/$R$34*100,2))","v":66.150000000000006}]
[2,null,"GS","GENERAL SERVICE COMMERCIAL",null,{"$f":"'Rate GS COM'!X79","v":80932},null,{"$f":"'Rate GS COM'!Z79","v":2939387},null,{"$f":"'Rate GS COM'!AD79","v":16581819},null,{"$f":"IF(H20=0,\"-\",ROUND(J20/H20,4))","v":5.6413000000000002},null,{"$f":"IF(ABS(J20/$J$34*100)<0.005,\"-\",ROUND(J20/$J$34*100,2))","v":18.399999999999999},null,{"$f":"'Rate GS COM'!AL79","v":19691247},null,{"$f":"J20+P20","v":36273066},null,23.54]
[3,null,"GS","GENERAL SERVICE INDUSTRIAL",null,{"$f":"'Rate GS IND'!X84","v":2047},null,{"$f":"'Rate GS IND'!Z84","v":205705},null,{"$f":"'Rate GS IND'!AD84","v":950659},null,4.6215000000000002,null,1.05,null,{"$f":"'Rate GS IND'!AL84","v":1378038},null,2328697,null,1.51]
[4,null,"GS","GENERAL SERVICE OTHER PUB AUTH",null,{"$f":"'Rate GS OPA'!X81","v":3526},null,{"$f":"'Rate GS OPA'!Z81","v":264202},null,{"$f":"'Rate GS OPA'!AD81","v":1273021},null,4.8183999999999996,null,1.41,null,{"$f":"'Rate GS OPA'!AL81","v":1769916},null,3042937,null,1.97]
[5,null,"FT-L","FIRM TRANSPORTATION-LARGE",null,{"$f":"'Rate FT-LG'!X73","v":1737},null,{"$f":"'Rate FT-LG'!Z73","v":3002186},null,{"$f":"'Rate FT-LG'!AD73","v":7375136},null,2.4565999999999999,null,8.18,null,{"$f":"'Rate FT-LG'!AL73","v":3332},null,7378468,null,4.79]
[6,null,"IT","INTERRUPTIBLE TRANSPORTATION",null,{"$f":"'Rate IT'!X74","v":226},null,{"$f":"'Rate IT'!Z74","v":1654919},null,{"$f":"'Rate IT'!AD74","v":1986270},null,{"$f":"IF(H24=0,\"-\",ROUND(J24/H24,4))","v":1.2001999999999999},null,2.2000000000000002,null,{"$f":"'Rate IT'!AL74","v":0},null,{"$f":"J24+P24","v":1986270},null,1.29]
[7,null,null,"LATE PAYMENT CHARGES",null,{"$f":"'SCH M-2.2'!F37","v":0},null,{"$f":"'SCH M-2.2'!H37","v":0},null,{"$f":"'SCH M-2.2'!L37","v":358320},null,{"$f":"IF(H25=0,\"-\",ROUND(J25/H25,4))","v":"-"},null,0.4,null,{"$f":"'SCH M-2.2'!T37","v":0},null,358320,null,0.23]
[8,null,null,"BAD CHECK CHARGES",null,{"$f":"'SCH M-2.2'!F38","v":0},null,{"$f":"'SCH M-2.2'!H38","v":0},null,{"$f":"'SCH M-2.2'!L38","v":21480},null,"-",null,0.02,null,{"$f":"'SCH M-2.2'!T38","v":0},null,21480,null,0.01]
[9,null,null,"RECONNECTION CHARGES",null,{"$f":"'SCH M-2.2'!F39","v":0},null,{"$f":"'SCH M-2.2'!H39","v":0},null,{"$f":"'SCH M-2.2'!L39","v":8664},null,"-",null,0.01,null,{"$f":"'SCH M-2.2'!T39","v":0},null,8664,null,0.01]
[10,null,null,"FIELD COLLECTION CHARGES",null,{"$f":"'SCH M-2.2'!F40","v":0},null,{"$f":"'SCH M-2.2'!H40","v":0},null,{"$f":"'SCH M-2.2'!L40","v":0},null,"-",null,"-",null,{"$f":"'SCH M-2.2'!T40","v":0},null,0,null,"-"]
[11,null,null,"INTERDEPARTMENTAL",null,{"$f":"'SCH M-2.2'!F41","v":0},null,{"$f":"'SCH M-2.2'!H41","v":4064},null,{"$f":"'SCH M-2.2'!L41","v":22605},null,5.5622999999999996,null,0.03,null,{"$f":"'SCH M-2.2'!T41","v":27225},null,49830,null,0.03]
[12,null,null,"SPECIAL CONTRACTS",null,{"$f":"'SCH M-2.2'!F42","v":0},null,{"$f":"'SCH M-2.2'!H42","v":0},null,{"$f":"'SCH M-2.2'!L42","v":677460},null,"-",null,0.75,null,{"$f":"'SCH M-2.2'!T42","v":0},null,677460,null,0.44]
[13,null,null,"REVENUE TRANSP OF GAS-INTERCO",null,{"$f":"'SCH M-2.2'!F43","v":0},null,{"$f":"'SCH M-2.2'!H43","v":0},null,{"$f":"'SCH M-2.2'!L43","v":0},null,"-",null,"-",null,{"$f":"'SCH M-2.2'!T43","v":0},null,0,null,"-"]
[14,null,null,"PROVISION FOR RATE REFUNDS",null,{"$f":"'SCH M-2.2'!F44","v":0},null,{"$f":"'SCH M-2.2'!H44","v":0},null,{"$f":"'SCH M-2.2'!L44","v":0},null,{"$f":"IF(H32=0,\"-\",ROUND(J32/H32,4))","v":"-"},null,"-",null,{"$f":"'SCH M-2.2'!T44","v":0},null,{"$f":"J32+P32","v":0},null,"-"]
[15,null,null,"OTHER MISCELLANEOUS",null,{"$f":"'SCH M-2.2'!F45","v":0},null,{"$f":"'SCH M-2.2'!H45","v":0},null,{"$f":"'SCH M-2.2'!L45","v":21852},null,"-",null,0.02,null,{"$f":"'SCH M-2.2'!T45","v":0},null,21852,null,0.01]
[16,null,"    TOTAL",null,null,{"$f":"SUM(F19:F33)","v":1282764},null,{"$f":"SUM(H19:H33)","v":14200886},null,{"$f":"SUM(J19:J33)","v":90137614},null,{"$f":"IF(H34=0,\"-\",ROUND(J34/H34,4))","v":6.3472999999999997},null,{"$f":"SUM(N19:N33)","v":99.97999999999999},null,{"$f":"SUM(P19:P33)","v":63938075},null,{"$f":"SUM(R19:R33)","v":154075689},null,{"$f":"SUM(T19:T33)","v":99.980000000000032}]
[]
[null,null,"NOTE: DETAIL CONTAINED ON SCHEDULES M-2.2 AND M-2.3."]

{"sheet":"SCH M-2.2","index":4,"n_rows":52,"n_cols":24,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[{"$f":"COMPANY","v":"DUKE ENERGY KENTUCKY"}]
[{"$f":"CASE","v":"CASE NO. 2025-00125"}]
["ANNUALIZED REVENUES AT PROPOSED VS. MOST CURRENT RATES"]
[{"$f":"TIME_PERIOD","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2026"}]
[{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE M-2.2"]
[{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PAGE  1  OF  7"]
["WORK PAPER REFERENCE NO(S).:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,{"$f":"INPUT!D4","v":"INCLUDES ALL RIDERS"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"B. L. Sailers"}]
["CURRENT ANNUALIZED"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"CURRENT",null,"% OF REV TO",null,"REVENUE",null,"% INCR IN",null,null,null,"CURRENT",null,"TOTAL"]
[null,null,null,null,null,null,null,null,null,"MOST",null,"REVENUE LESS",null,"TOTAL LESS",null,"INCR LESS",null,"REV LESS ",null,null,null,"TOTAL",null,"REVENUE"]
["LINE",null,"RATE","CLASS /",null,"CUSTOMER",null,null,null,"CURRENT",null,"GAS COST",null,"GAS COST",null,"GAS COST REV",null,"GAS COST REV",null,"GAS COST",null,"REVENUE",null,"% INCREASE"]
[" NO.",null,"CODE","DESCRIPTION",null,"BILLS(1)",null,"SALES(2)",null,"RATES",null,"REVENUE(4)",null,"REVENUE",null,"(F - K)",null,"(M / K)",null,"REVENUE(3)",null,"(K + H)",null,"(M / K1)"]
[null,null,"(A)","(B)",null,"(C)",null,"(D)",null,"(J)",null,"(K)",null,"(L)",null,"(M)",null,"(N)",null,"(H)",null,"(K1)",null,"(O)"]
[]
[null,null,null,null,null,null,null,"(MCF)",null,"($/MCF)",null,"($)",null,"(%)",null,"($)",null,"(%)",null,"($)",null,"($)",null,"(%)"]
[1,null,"SALES SERVICE:"]
[2,null,"RS","RESIDENTIAL",null,{"$f":"'Rate RS'!X81","v":1194296},null,{"$f":"'Rate RS'!Z81","v":6130423},null,{"$f":"ROUND((L20/H20),4)","v":9.9276},null,{"$f":"'Rate RS'!AD81","v":60860328},null,{"$f":"ROUND((L20/L$21)*100,2)","v":100},null,{"$f":"'Rate RS'!AH81","v":13989849},null,{"$f":"IF(L20=0,\"0.0 \",ROUND((P20/L20)*100,1))","v":23},null,{"$f":"'Rate RS'!AL81","v":41068317},null,{"$f":"'Rate RS'!AN81","v":101928645},null,{"$f":"IF(V20=0,\"0.0 \",ROUND((P20/V20)*100,1))","v":13.7}]
[3,null,null,"  TOTAL RS",null,{"$f":"F20","v":1194296},null,{"$f":"H20","v":6130423},null,{"$f":"ROUND((L21/H21),4)","v":9.9276},null,{"$f":"L20","v":60860328},null,{"$f":"ROUND((L21/$L48)*100,2)+0.01","v":67.53},null,{"$f":"P20","v":13989849},null,{"$f":"IF(L21=0,\"0.0 \",ROUND((P21/L21)*100,1))","v":23},null,{"$f":"T20","v":41068317},null,{"$f":"V20","v":101928645},null,{"$f":"IF(V21=0,\"0.0 \",ROUND((P21/V21)*100,1))","v":13.7}]
[]
[4,null,"GS","COMMERCIAL",null,{"$f":"'Rate GS COM'!X79","v":80932},null,{"$f":"'Rate GS COM'!Z79","v":2939387},null,{"$f":"ROUND((L23/H23),4)","v":5.6413000000000002},null,{"$f":"'Rate GS COM'!AD79","v":16581819},null,{"$f":"ROUND((L23/$L26)*100,2)","v":88.18},null,{"$f":"'Rate GS COM'!AH79","v":5927378},null,{"$f":"IF(L23=0,\"0.0 \",ROUND((P23/L23)*100,1))","v":35.700000000000003},null,{"$f":"'Rate GS COM'!AL79","v":19691247},null,{"$f":"'Rate GS COM'!AN79","v":36273066},null,{"$f":"IF(V23=0,\"0.0 \",ROUND((P23/V23)*100,1))","v":16.3}]
[5,null,"GS","INDUSTRIAL",null,{"$f":"'Rate GS IND'!X84","v":2047},null,{"$f":"'Rate GS IND'!Z84","v":205705},null,{"$f":"ROUND((L24/H24),4)","v":4.6215000000000002},null,{"$f":"'Rate GS IND'!AD84","v":950659},null,{"$f":"ROUND((L24/$L26)*100,2)","v":5.0599999999999996},null,{"$f":"'Rate GS IND'!AH84","v":389494},null,{"$f":"IF(L24=0,\"0.0 \",ROUND((P24/L24)*100,1))","v":41},null,{"$f":"'Rate GS IND'!AL84","v":1378038},null,{"$f":"'Rate GS IND'!AN84","v":2328697},null,{"$f":"IF(V24=0,\"0.0 \",ROUND((P24/V24)*100,1))","v":16.7}]
[6,null,"GS","OTH PUB AUTH",null,{"$f":"'Rate GS OPA'!X81","v":3526},null,{"$f":"'Rate GS OPA'!Z81","v":264202},null,{"$f":"ROUND((L25/H25),4)","v":4.8183999999999996},null,{"$f":"'Rate GS OPA'!AD81","v":1273021},null,{"$f":"ROUND((L25/$L26)*100,2)","v":6.77},null,{"$f":"'Rate GS OPA'!AH81","v":506533},null,{"$f":"IF(L25=0,\"0.0 \",ROUND((P25/L25)*100,1))","v":39.799999999999997},null,{"$f":"'Rate GS OPA'!AL81","v":1769916},null,{"$f":"'Rate GS OPA'!AN81","v":3042937},null,{"$f":"IF(V25=0,\"0.0 \",ROUND((P25/V25)*100,1))","v":16.600000000000001}]
[7,null,null,"   TOTAL GS",null,{"$f":"SUM(F23:F25)","v":86505},null,{"$f":"SUM(H23:H25)","v":3409294},null,{"$f":"ROUND((L26/H26),4)","v":5.516},null,{"$f":"SUM(L23:L25)","v":18805499},null,{"$f":"ROUND((L26/$L48)*100,2)","v":20.86},null,{"$f":"SUM(P23:P25)","v":6823405},null,{"$f":"IF(L26=0,\"0.0 \",ROUND((P26/L26)*100,1))","v":36.299999999999997},null,{"$f":"SUM(T23:T25)","v":22839201},null,{"$f":"SUM(V23:V25)","v":41644700},null,{"$f":"IF(V26=0,\"0.0 \",ROUND((P26/V26)*100,1))","v":16.399999999999999}]
[]
[8,null,"  TOTAL SALES SERVICE",null,null,{"$f":"F21+F26","v":1280801},null,{"$f":"H21+H26","v":9539717},null,{"$f":"ROUND((L28/H28),4)","v":8.3510000000000009},null,{"$f":"L21+L26","v":79665827},null,{"$f":"100-N33-N46","v":88.38},null,{"$f":"P21+P26","v":20813254},null,{"$f":"IF(L28=0,\"0.0 \",ROUND((P28/L28)*100,1))","v":26.1},null,{"$f":"T21+T26","v":63907518},null,{"$f":"V21+V26","v":143573345},null,{"$f":"IF(V28=0,\"0.0 \",ROUND((P28/V28)*100,1))","v":14.5}]
[]
[9,null,"TRANSPORTATION SERVICE:"]
[10,null,"FT-L","FIRM TRANSP - LARGE",null,{"$f":"'Rate FT-LG'!X73","v":1737},null,{"$f":"'Rate FT-LG'!Z73","v":3002186},null,{"$f":"ROUND((L31/H31),4)","v":2.4565999999999999},null,{"$f":"'Rate FT-LG'!AD73","v":7375136},null,{"$f":"ROUND((L31/L$33)*100,2)","v":78.78},null,{"$f":"'Rate FT-LG'!AH73","v":-86463},null,{"$f":"IF(L31=0,\"0.0 \",ROUND((P31/L31)*100,1))","v":-1.2},null,{"$f":"'Rate FT-LG'!AL73","v":3332},null,{"$f":"'Rate FT-LG'!AN73","v":7378468},null,{"$f":"IF(V31=0,\"0.0 \",ROUND((P31/V31)*100,1))","v":-1.2}]
[11,null,"IT","INTERRUPTIBLE TRANSP",null,{"$f":"'Rate IT'!X74","v":226},null,{"$f":"'Rate IT'!Z74","v":1654919},null,{"$f":"ROUND((L32/H32),4)","v":1.2001999999999999},null,{"$f":"'Rate IT'!AD74","v":1986270},null,{"$f":"ROUND((L32/L$33)*100,2)","v":21.22},null,{"$f":"'Rate IT'!AH74","v":32768},null,{"$f":"IF(L32=0,\"0.0 \",ROUND((P32/L32)*100,1))","v":1.6},null,{"$f":"'Rate IT'!AL74","v":0},null,{"$f":"'Rate IT'!AN74","v":1986270},null,{"$f":"IF(V32=0,\"0.0 \",ROUND((P32/V32)*100,1))","v":1.6}]
[12,null,"  TOTAL TRANSP SERVICE",null,null,{"$f":"SUM(F31:F32)","v":1963},null,{"$f":"SUM(H31:H32)","v":4657105},null,{"$f":"ROUND((L33/H33),4)","v":2.0101},null,{"$f":"SUM(L31:L32)","v":9361406},null,{"$f":"ROUND((L33/L$48)*100,2)","v":10.39},null,{"$f":"SUM(P31:P32)","v":-53695},null,{"$f":"IF(L33=0,\"0.0 \",ROUND((P33/L33)*100,1))","v":-0.6},null,{"$f":"SUM(T31:T32)","v":3332},null,{"$f":"SUM(V31:V32)","v":9364738},null,{"$f":"IF(V33=0,\"0.0 \",ROUND((P33/V33)*100,1))","v":-0.6}]
[13,null,"TOTAL THROUGHPUT",null,null,{"$f":"F28+F33","v":1282764},null,{"$f":"H28+H33","v":14196822},null,{"$f":"ROUND((L34/H34),4)","v":6.2709000000000001},null,{"$f":"L28+L33","v":89027233},null,{"$f":"N28+N33","v":98.77},null,{"$f":"P28+P33","v":20759559},null,{"$f":"IF(L34=0,\"0.0 \",ROUND((P34/L34)*100,1))","v":23.3},null,{"$f":"T28+T33","v":63910850},null,{"$f":"V28+V33","v":152938083},null,{"$f":"IF(V34=0,\"0.0 \",ROUND((P34/V34)*100,1))","v":13.6}]
[]
[14,null,"MISCELLANEOUS REVENUES: "]
[15,null,"LATE PAYMENT CHARGES",null,null,0,null,0,null,null,null,358320,null,{"$f":"ROUND((L37/L$46)*100,2)","v":32.270000000000003},null,{"$f":"'SCH M-2.3'!L37-'SCH M-2.2'!L37","v":0},null,null,null,0,null,{"$f":"L37+T37","v":358320}]
[16,null,"BAD CHECK CHARGES",null,null,0,null,0,null,null,null,21480,null,1.93,null,{"$f":"'SCH M-2.3'!L38-'SCH M-2.2'!L38","v":0},null,null,null,0,null,{"$f":"L38+T38","v":21480}]
[17,null,"RECONNECTION CHARGES",null,null,0,null,0,null,null,null,8664,null,0.78,null,{"$f":"'SCH M-2.3'!L39-'SCH M-2.2'!L39","v":1925},null,null,null,0,null,8664]
[18,null,"FIELD COLLECTION CHARGES",null,null,0,null,0,null,null,null,0,null,0,null,{"$f":"'SCH M-2.3'!L40-'SCH M-2.2'!L40","v":0},null,null,null,0,null,0]
[19,null,"INTERDEPARTMENTAL",null,null,0,null,4064,null,null,null,{"$f":"ROUND(V41-(H41*EGC),0)","v":22605},null,{"$f":"ROUND((L41/L$46)*100,2)","v":2.04},null,{"$f":"'SCH M-2.3'!L41-'SCH M-2.2'!L41","v":8370},null,null,null,{"$f":"V41-L41","v":27225},null,49830]
[20,null,"SPECIAL CONTRACTS",null,null,0,null,0,null,null,null,677460,null,61.01,null,{"$f":"'SCH M-2.3'!L42-'SCH M-2.2'!L42","v":854599},null,null,null,0,null,677460]
[21,null,"REVENUE TRANSP OF GAS-INTERCO",null,null,0,null,0,null,null,null,0,null,0,null,{"$f":"'SCH M-2.3'!L43-'SCH M-2.2'!L43","v":0},null,null,null,0,null,0]
[22,null,"PROVISION FOR RATE REFUNDS",null,null,0,null,0,null,null,null,0,null,0,null,{"$f":"'SCH M-2.3'!L44-'SCH M-2.2'!L44","v":0},null,null,null,0,null,{"$f":"L44+T44","v":0}]
[23,null,"OTHER MISC",null,null,0,null,0,null,null,null,21852,null,1.97,null,{"$f":"'SCH M-2.3'!L45-'SCH M-2.2'!L45","v":0},null,null,null,0,null,21852]
[24,null,"  TOTAL MISC",null,null,{"$f":"SUM(F37:F45)","v":0},null,{"$f":"SUM(H37:H45)","v":4064},null,null,null,{"$f":"SUM(L37:L45)","v":1110381},null,{"$f":"ROUND((L46/L$48)*100,2)","v":1.23},null,{"$f":"SUM(P37:P45)","v":864894},null,{"$f":"IF(L46=0,\"0.0 \",ROUND((P46/L46)*100,1))","v":77.900000000000006},null,{"$f":"SUM(T37:T45)","v":27225},null,{"$f":"SUM(V37:V45)","v":1137606},null,{"$f":"IF(V46=0,\"0.0 \",ROUND((P46/V46)*100,1))","v":76}]
[]
[25,null,"    TOTAL COMPANY",null,null,{"$f":"F28+F33+F46","v":1282764},null,{"$f":"H28+H33+H46","v":14200886},null,{"$f":"ROUND((L48/H48),4)","v":6.3472999999999997},null,{"$f":"L28+L33+L46","v":90137614},null,100,null,{"$f":"P28+P33+P46","v":21624453},null,{"$f":"IF(L48=0,\"0.0 \",ROUND((P48/L48)*100,1))","v":24},null,{"$f":"T28+T33+T46","v":63938075},null,{"$f":"V28+V33+V46","v":154075689},null,{"$f":"IF(V48=0,\"0.0 \",ROUND((P48/V48)*100,1))","v":14}]
[]
[null,null,"(1) DETAIL CONTAINED ON SCHEDULES M-2.2, PAGES 2 THROUGH 7."]
[null,null,"(2) REFLECTS NORMALIZED VOLUMES."]
[null,null,{"$f":"\"(3) REFLECTS AVERAGE EXPECTED GAS COST OF \"&TEXT(EGC,\"$0.000\")&\"/MCF.\"","v":"(3) REFLECTS AVERAGE EXPECTED GAS COST OF $6.699/MCF."}]

{"sheet":"SCH M-2.3","index":5,"n_rows":52,"n_cols":18,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[{"$f":"COMPANY","v":"DUKE ENERGY KENTUCKY"}]
[{"$f":"CASE","v":"CASE NO. 2025-00125"}]
["ANNUALIZED REVENUES AT PROPOSED VS. MOST CURRENT RATES"]
[{"$f":"TIME_PERIOD","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2026"}]
[{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE M-2.3"]
[{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PAGE  1  OF  7"]
["WORK PAPER REFERENCE NO(S).: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,{"$f":"INPUT!D4","v":"INCLUDES ALL RIDERS"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"B. L. Sailers"}]
["PROPOSED ANNUALIZED"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"PROPOSED",null,"% OF REV TO",null,null,null,"PROPOSED"]
[null,null,null,null,null,null,null,null,null,null,null,"REVENUE LESS",null,"TOTAL LESS",null,null,null,"TOTAL"]
["LINE",null,"RATE","CLASS /",null,"CUSTOMER",null,null,null,"PROPOSED",null,"GAS COST",null,"GAS COST",null,"GAS COST",null,"REVENUE"]
[" NO.",null,"CODE","DESCRIPTION",null,"BILLS(1)",null,"SALES(2)",null,"RATES",null,"REVENUE(4)",null,"REVENUE",null,"REVENUE(3)",null,"(F + H)"]
[null,null,"(A)","(B)",null,"(C)",null,"(D)",null,"(E)",null,"(F)",null,"(G)",null,"(H)",null,"(I)"]
[]
[null,null,null,null,null,null,null,"(MCF)",null,"($/MCF)",null,"($)",null,"(%)",null,"($)",null,"($)"]
[1,null,"SALES SERVICE:"]
[2,null,"RS","RESIDENTIAL",null,{"$f":"'Rate RS'!F39","v":1194296},null,{"$f":"'Rate RS'!H39","v":6130423},null,{"$f":"IF(F20=0,\"0.0 \",ROUND((L20/H20),4))","v":12.2096},null,{"$f":"'Rate RS'!L39","v":74850177},null,{"$f":"ROUND((L20/L$21)*100,2)","v":100},null,{"$f":"'Rate RS'!P39","v":41068317},null,{"$f":"'Rate RS'!R39","v":115918494}]
[3,null,null,"  TOTAL RS",null,{"$f":"F20","v":1194296},null,{"$f":"H20","v":6130423},null,{"$f":"IF(F21=0,\"0.0 \",ROUND((L21/H21),4))","v":12.2096},null,{"$f":"L20","v":74850177},null,{"$f":"ROUND((L21/L$48)*100,2)","v":66.97},null,{"$f":"P20","v":41068317},null,{"$f":"R20","v":115918494}]
[]
[4,null,"GS","COMMERCIAL",null,{"$f":"'Rate GS COM'!F38","v":80932},null,{"$f":"'Rate GS COM'!H38","v":2939387},null,{"$f":"IF(F23=0,\"0.0 \",ROUND((L23/H23),4))","v":7.6577999999999999},null,{"$f":"'Rate GS COM'!L38","v":22509197},null,{"$f":"ROUND((L23/L$26)*100,2)","v":87.83},null,{"$f":"'Rate GS COM'!P38","v":19691247},null,{"$f":"'Rate GS COM'!R38","v":42200444}]
[5,null,"GS","INDUSTRIAL",null,{"$f":"'Rate GS IND'!F38","v":2047},null,{"$f":"'Rate GS IND'!H38","v":205705},null,{"$f":"IF(F24=0,\"0.0 \",ROUND((L24/H24),4))","v":6.5148999999999999},null,{"$f":"'Rate GS IND'!L38","v":1340153},null,{"$f":"ROUND((L24/L$26)*100,2)","v":5.23},null,{"$f":"'Rate GS IND'!P38","v":1378038},null,{"$f":"'Rate GS IND'!R38","v":2718191}]
[6,null,"GS","OTH PUB AUTH",null,{"$f":"'Rate GS OPA'!F38","v":3526},null,{"$f":"'Rate GS OPA'!H38","v":264202},null,{"$f":"IF(F25=0,\"0.0 \",ROUND((L25/H25),4))","v":6.7355999999999998},null,{"$f":"'Rate GS OPA'!L38","v":1779554},null,{"$f":"ROUND((L25/L$26)*100,2)","v":6.94},null,{"$f":"'Rate GS OPA'!P38","v":1769916},null,{"$f":"'Rate GS OPA'!R38","v":3549470}]
[7,null,null,"   TOTAL GS",null,{"$f":"SUM(F23:F25)","v":86505},null,{"$f":"SUM(H23:H25)","v":3409294},null,{"$f":"IF(F26=0,\"0.0 \",ROUND((L26/H26),4))","v":7.5174000000000003},null,{"$f":"SUM(L23:L25)","v":25628904},null,{"$f":"ROUND((L26/L$48)*100,2)","v":22.93},null,{"$f":"SUM(P23:P25)","v":22839201},null,{"$f":"SUM(R23:R25)","v":48468105}]
[]
[8,null,"  TOTAL SALES SERVICE",null,null,{"$f":"F21+F26","v":1280801},null,{"$f":"H21+H26","v":9539717},null,{"$f":"IF(F28=0,\"0.0 \",ROUND((L28/H28),4))","v":10.5327},null,{"$f":"L21+L26","v":100479081},null,{"$f":"ROUND((L28/L$48)*100,2)","v":89.9},null,{"$f":"P21+P26","v":63907518},null,{"$f":"R21+R26","v":164386599}]
[]
[9,null,"TRANSPORTATION SERVICE:"]
[10,null,"FT-L","FIRM TRANSP - LARGE",null,{"$f":"'Rate FT-LG'!F35","v":1737},null,{"$f":"'Rate FT-LG'!H35","v":3002186},null,{"$f":"IF(F31=0,\"0.0 \",ROUND((L31/H31),4))","v":2.4278},null,{"$f":"'Rate FT-LG'!L35","v":7288673},null,{"$f":"ROUND((L31/L$33)*100,2)","v":78.31},null,{"$f":"'Rate FT-LG'!P35","v":3332},null,{"$f":"'Rate FT-LG'!R35","v":7292005}]
[11,null,"IT","INTERRUPTIBLE TRANSP",null,{"$f":"'Rate IT'!F34","v":226},null,{"$f":"'Rate IT'!H34","v":1654919},null,{"$f":"IF(F32=0,\"0.0 \",ROUND((L32/H32),4))","v":1.22},null,{"$f":"'Rate IT'!L34","v":2019038},null,{"$f":"ROUND((L32/L$33)*100,2)","v":21.69},null,{"$f":"'Rate IT'!P34","v":0},null,{"$f":"'Rate IT'!R34","v":2019038}]
[12,null,"  TOTAL TRANSP SERVICE",null,null,{"$f":"SUM(F31:F32)","v":1963},null,{"$f":"SUM(H31:H32)","v":4657105},null,{"$f":"IF(F33=0,\"0.0 \",ROUND((L33/H33),4))","v":1.9985999999999999},null,{"$f":"SUM(L31:L32)","v":9307711},null,{"$f":"ROUND((L33/L$48)*100,2)","v":8.33},null,{"$f":"SUM(P31:P32)","v":3332},null,{"$f":"SUM(R31:R32)","v":9311043}]
[13,null,"TOTAL THROUGHPUT",null,null,{"$f":"F28+F33","v":1282764},null,{"$f":"H28+H33","v":14196822},null,{"$f":"IF(F34=0,\"0.0 \",ROUND((L34/H34),4))","v":7.7332000000000001},null,{"$f":"L28+L33","v":109786792},null,{"$f":"N28+N33","v":98.23},null,{"$f":"P28+P33","v":63910850},null,{"$f":"R28+R33","v":173697642}]
[]
[14,null,"MISCELLANEOUS REVENUES: "]
[15,null,"LATE PAYMENT CHARGES",null,null,0,null,0,null,null,null,{"$f":"'SCH M-2.2'!L37","v":358320},null,{"$f":"ROUND((L37/L$46)*100,2)","v":18.14},null,0,null,{"$f":"L37+P37","v":358320}]
[16,null,"BAD CHECK CHARGES",null,null,0,null,0,null,null,null,{"$f":"'SCH M-2.2'!L38","v":21480},null,1.0900000000000001,null,0,null,21480]
[17,null,"RECONNECTION CHARGES",null,null,0,null,0,null,null,null,{"$f":"ROUND('SCH M-2.2'!L39*1.2222,0)","v":10589},null,0.54,null,0,null,10589]
[18,null,"FIELD COLLECTION CHARGES",null,null,0,null,0,null,null,null,{"$f":"'SCH M-2.2'!L40","v":0},null,0,null,0,null,0]
[19,null,"INTERDEPARTMENTAL",null,null,{"$f":"'SCH M-2.2'!F41","v":0},null,{"$f":"'SCH M-2.2'!H41","v":4064},null,null,null,{"$f":"R41-P41","v":30975},null,1.57,null,{"$f":"'SCH M-2.2'!T41","v":27225},null,{"$f":"'Proposed Rates'!G30","v":58200}]
[20,null,"SPECIAL CONTRACTS",null,null,{"$f":"'SCH M-2.2'!F42","v":0},null,{"$f":"'SCH M-2.2'!H42","v":0},null,null,null,1532059,null,77.56,null,0,null,1532059]
[21,null,"REVENUE TRANSP OF GAS-INTERCO",null,null,0,null,{"$f":"'SCH M-2.2'!H43","v":0},null,null,null,{"$f":"'SCH M-2.2'!L43","v":0},null,0,null,0,null,0]
[22,null,"PROVISION FOR RATE REFUNDS",null,null,0,null,{"$f":"'SCH M-2.2'!H44","v":0},null,null,null,{"$f":"'SCH M-2.2'!L44","v":0},null,0,null,0,null,0]
[23,null,"OTHER MISC",null,null,0,null,0,null,null,null,{"$f":"'SCH M-2.2'!L45","v":21852},null,1.1100000000000001,null,0,null,21852]
[24,null,"  TOTAL MISC",null,null,{"$f":"SUM(F37:F45)","v":0},null,{"$f":"SUM(H37:H45)","v":4064},null,null,null,{"$f":"SUM(L37:L45)","v":1975275},null,{"$f":"ROUND((L46/L$48)*100,2)","v":1.77},null,{"$f":"SUM(P37:P45)","v":27225},null,{"$f":"SUM(R37:R45)","v":2002500}]
[]
[25,null,"    TOTAL COMPANY",null,null,{"$f":"F28+F33+F46","v":1282764},null,{"$f":"H28+H33+H46","v":14200886},null,{"$f":"IF(F48=0,\"0.0 \",ROUND((L48/H48),4))","v":7.8700999999999999},null,{"$f":"L28+L33+L46","v":111762067},null,100,null,{"$f":"P28+P33+P46","v":63938075},null,{"$f":"R28+R33+R46","v":175700142}]
[]
[null,null,"(1) DETAIL CONTAINED ON SCHEDULES M-2.3, PAGES 2 THROUGH 7."]
[null,null,"(2) REFLECTS NORMALIZED VOLUMES."]
[null,null,{"$f":"\"(3) REFLECTS AVERAGE EXPECTED GAS COST OF \"&TEXT(EGC,\"$0.000\")&\"/MCF.\"","v":"(3) REFLECTS AVERAGE EXPECTED GAS COST OF $6.699/MCF."}]

{"sheet":"Rate RS","index":6,"n_rows":85,"n_cols":42,"rows_kept":85,"cut":false,"hidden":false,"merged":[]}
[{"$f":"COMPANY","v":"DUKE ENERGY KENTUCKY"}]
[{"$f":"CASE","v":"CASE NO. 2025-00125"}]
["ANNUALIZED REVENUES AT PROPOSED VS. MOST CURRENT RATES"]
[{"$f":"TIME_PERIOD","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2026"}]
[{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE M-2.3"]
[{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PAGE  2  OF  7"]
["WORK PAPER REFERENCE NO(S).:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"B. L. Sailers"}]
["PROPOSED ANNUALIZED"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"PROPOSED",null,"% OF REV TO",null,null,null,"PROPOSED"]
[null,null,null,null,null,null,null,null,null,null,null,"REVENUE LESS",null,"TOTAL LESS",null,null,null,"TOTAL"]
["LINE",null,"RATE","CLASS /",null,"CUSTOMER",null,null,null,"PROPOSED",null,"GAS COST",null,"GAS COST",null,"GAS COST",null,"REVENUE"]
[" NO.",null,"CODE","DESCRIPTION",null,"BILLS(1)",null,"SALES(2)",null,"RATES",null,"REVENUE",null,"REVENUE",null,"REVENUE(3)",null,"(F + H)"]
[null,null,"(A)","(B)",null,"(C)",null,"(D)",null,"(E)",null,"(F)",null,"(G)",null,"(H)",null,"(I)"]
[]
[null,null,null,null,null,null,null,"(MCF)",null,"($/MCF)",null,"($)",null,"(%)",null,"($)",null,"($)"]
[1,null,"RS","RESIDENTIAL"]
[]
[2,null,"CUSTOMER CHARGE:"]
[3,null,"RESIDENTIAL"]
[4,null,"     TOTAL MONTHLY BILLS  x   :"]
[5,null,"     CUSTOMER CHARGE PER  MONTH",null,null,{"$f":"1193286+(202*5)","v":1194296},null,null,null,{"$f":"PRO_RS_CUST","v":20},null,{"$f":"ROUND(F24*J24,0)","v":23885920},null,{"$f":"ROUND((L24/$L$39)*100,1)","v":31.9},null,null,null,{"$f":"L24+P24","v":23885920}]
[]
[6,null,"COMMODITY CHARGE:"]
[7,null,"     ALL CONSUMPTION",null,null,null,null,6130423,null,{"$f":"PRO_RS_COM","v":7.0423999999999998},null,{"$f":"ROUND((H27*J27),0)","v":43172891},null,{"$f":"ROUND((L27/$L$39)*100,1)","v":57.7},null,{"$f":"ROUND(H27*EGC,0)","v":41068317},null,{"$f":"L27+P27","v":84241208}]
[]
[8,null,"RATE RS EXCLUDING RIDERS",null,null,{"$f":"F24","v":1194296},null,{"$f":"H27","v":6130423},null,null,null,{"$f":"SUM(L24:L27)","v":67058811},null,{"$f":"ROUND((L29/$L$39)*100,1)","v":89.6},null,{"$f":"SUM(P24:P27)","v":41068317},null,{"$f":"SUM(R24:R27)","v":108127128}]
[]
[9,null,"RIDERS:"]
[10,null,"HOME ENERGY ASSISTANCE PROGRAM (HEA)",null,null,null,null,null,null,{"$f":"PRO_RS_HEA","v":0.3},null,{"$f":"ROUND(F24*PRO_RS_HEA,0)","v":358289},null,{"$f":"ROUND((L32/$L$39)*100,1)","v":0.5},null,null,null,{"$f":"L32+P32","v":358289}]
[11,null,"DEMAND SIDE MANAGEMENT RATE (DSMR)",null,null,null,null,null,null,{"$f":"PRO_RS_DSM","v":1.2489999999999999E-2},null,{"$f":"ROUND(H27*J33,0)","v":76569},null,{"$f":"ROUND((L33/$L$39)*100,1)","v":0.1},null,null,null,{"$f":"L33+P33","v":76569}]
[12,null,"WEATHER NORMALIZATION ADJUSTMENT (WNA)",null,null,null,null,null,null,0,null,{"$f":"ROUND(H29*J34,0)","v":0},null,{"$f":"ROUND((L34/$L$39)*100,1)","v":0},null,null,null,{"$f":"L34+P34","v":0}]
[13,null,"PIPELINE MODERNIZATION MECHANISM (PMM)",null,null,null,null,null,null,{"$f":"PRO_RS_PMM","v":1.2},null,{"$f":"ROUND(H29*J35,0)","v":7356508},null,{"$f":"ROUND((L35/$L$39)*100,1)","v":9.8000000000000007},null,null,null,{"$f":"L35+P35","v":7356508}]
[]
[14,null,"TOTAL RIDERS",null,null,null,null,null,null,null,null,{"$f":"SUM(L32:L35)","v":7791366},null,{"$f":"ROUND((L37/$L$39)*100,1)","v":10.4},null,null,null,{"$f":"SUM(R32:R35)","v":7791366}]
[]
[15,null,"TOTAL RATE RS RESIDENTIAL INCLUDING RIDERS",null,null,{"$f":"F24","v":1194296},null,{"$f":"H27","v":6130423},null,null,null,{"$f":"L29+L37","v":74850177},null,{"$f":"SUM(N29+N37)","v":100},null,{"$f":"P29+P37","v":41068317},null,{"$f":"R29+R37","v":115918494}]
[]
[null,null,"(1) BILLS THAT TERMINATE IN RESPECTIVE RATE STEPS."]
[null,null,"(2) REFLECTS NORMALIZED VOLUMES."]
[null,null,{"$f":"\"(3) REFLECTS AVERAGE EXPECTED GAS COST OF \"&TEXT(EGC,\"$0.000\")&\"/MCF.\"","v":"(3) REFLECTS AVERAGE EXPECTED GAS COST OF $6.699/MCF."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COMPANY","v":"DUKE ENERGY KENTUCKY"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CASE","v":"CASE NO. 2025-00125"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANNUALIZED TEST YEAR REVENUES AT PROPOSED VS. MOST CURRENT RATES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TIME_PERIOD","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2026"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE M-2.2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R7","v":"PAGE  2  OF  7"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WORK PAPER REFERENCE NO(S).:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"B. L. Sailers"}]
[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,"  CURRENT ANNUALIZED"]
[]
[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,"CURRENT",null,"% OF REV TO",null,"REVENUE",null,"% INCR IN",null,null,null,"CURRENT",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,null,"MOST",null,"REVENUE LESS",null,"TOTAL LESS",null,"INCR LESS",null,"REV LESS ",null,null,null,"TOTAL",null,"REVENUE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LINE",null,"RATE","CLASS /","CUSTOMER",null,null,null,"CURRENT",null,"GAS COST",null,"GAS COST",null,"GAS COST REV",null,"GAS COST REV",null,"GAS COST",null,"REVENUE",null,"% INCREASE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," NO.",null,"CODE","DESCRIPTION","BILLS(1)",null,"SALES(2)",null,"RATES",null,"REVENUE",null,"REVENUE",null,"(F - K)",null,"(M / K)",null,"REVENUE(3)",null,"(K + H)",null,"(M / K1)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(A)","(B)","(C)",null,"(D)",null,"(J)",null,"(K)",null,"(L)",null,"(M)",null,"(N)",null,"(H)",null,"(K1)",null,"(O)"]
[]
[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,"(MCF)",null,"($/MCF)",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,1,null,"RS","RESIDENTIAL"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,"CUSTOMER CHARGE:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,"RESIDENTIAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,"     TOTAL MONTHLY BILLS  x  :"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,"     CUSTOMER CHARGE PER  MONTH",null,{"$f":"F24","v":1194296},null,null,null,{"$f":"CUR_RS_CUST","v":17.5},null,{"$f":"ROUND(X66*AB66,0)","v":20900180},null,{"$f":"ROUND((AD66/$AD$81)*100,1)","v":34.299999999999997},null,{"$f":"L24-AD66","v":2985740},null,{"$f":"IF(AD66=0,\"0.0 \",ROUND((AH66/AD66)*100,1))","v":14.3},null,null,null,{"$f":"AD66+AL66","v":20900180},null,{"$f":"IF(AN66=0,\"0.0 \",ROUND((AH66/AN66)*100,1))","v":14.3}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,"COMMODITY CHARGE:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,null,"     ALL CONSUMPTION",null,null,null,{"$f":"H27","v":6130423},null,{"$f":"CUR_RS","v":5.2473999999999998},null,{"$f":"ROUND((Z69*AB69),0)","v":32168782},null,{"$f":"ROUND((AD69/$AD$81)*100,1)","v":52.9},null,{"$f":"L27-AD69","v":11004109},null,{"$f":"IF(AD69=0,\"0.0 \",ROUND((AH69/AD69)*100,1))","v":34.200000000000003},null,{"$f":"P27","v":41068317},null,{"$f":"AD69+AL69","v":73237099},null,{"$f":"IF(AN69=0,\"0.0 \",ROUND((AH69/AN69)*100,1))","v":15}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,"RATE RS EXCLUDING RIDERS",null,{"$f":"X66","v":1194296},null,{"$f":"Z69","v":6130423},null,null,null,{"$f":"SUM(AD66:AD69)","v":53068962},null,{"$f":"ROUND((AD71/$AD$81)*100,1)","v":87.2},null,{"$f":"SUM(AH66:AH69)","v":13989849},null,{"$f":"IF(AD71=0,\"0.0 \",ROUND((AH71/AD71)*100,1))","v":26.4},null,{"$f":"SUM(AL66:AL69)","v":41068317},null,{"$f":"SUM(AN66:AN69)","v":94137279},null,{"$f":"IF(AN71=0,\"0.0 \",ROUND((AH71/AN71)*100,1))","v":14.9}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,null,"RIDERS:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,"HOME ENERGY ASSISTANCE PROGRAM (HEA)",null,null,null,null,null,{"$f":"CUR_RS_HEA","v":0.3},null,{"$f":"ROUND(X66*CUR_RS_HEA,0)","v":358289},null,{"$f":"ROUND((AD74/$AD$81)*100,1)","v":0.6},null,{"$f":"L32-AD74","v":0},null,{"$f":"IF(AD74=0,\"0.0 \",ROUND((AH74/AD74)*100,1))","v":0},null,null,null,{"$f":"AD74+AL74","v":358289},null,{"$f":"IF(AN74=0,\"0.0 \",ROUND((AH74/AN74)*100,1))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,null,"DEMAND SIDE MANAGEMENT RATE (DSMR)",null,null,null,null,null,{"$f":"CUR_RS_DSM","v":1.2489999999999999E-2},null,{"$f":"ROUND(Z69*AB75,0)","v":76569},null,{"$f":"ROUND((AD75/$AD$81)*100,1)","v":0.1},null,{"$f":"L33-AD75","v":0},null,{"$f":"IF(AD75=0,\"0.0 \",ROUND((AH75/AD75)*100,1))","v":0},null,null,null,{"$f":"AD75+AL75","v":76569},null,{"$f":"IF(AN75=0,\"0.0 \",ROUND((AH75/AN75)*100,1))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A34","v":12},null,"WEATHER NORMALIZATION ADJUSTMENT (WNA)",null,null,null,null,null,0,null,{"$f":"ROUND(Z71*AB76,0)","v":0},null,{"$f":"ROUND((AD76/$AD$81)*100,1)","v":0},null,{"$f":"L34-AD76","v":0},null,{"$f":"IF(AD76=0,\"0.0 \",ROUND((AH76/AD76)*100,1))","v":"0.0 "},null,null,null,{"$f":"AD76+AL76","v":0},null,{"$f":"IF(AN76=0,\"0.0 \",ROUND((AH76/AN76)*100,1))","v":"0.0 "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,null,"PIPELINE MODERNIZATION MECHANISM (PMM)",null,null,null,null,null,{"$f":"CUR_RS_PMM","v":1.2},null,{"$f":"ROUND(Z71*AB77,0)","v":7356508},null,{"$f":"ROUND((AD77/$AD$81)*100,1)","v":12.1},null,{"$f":"L35-AD77","v":0},null,0,null,null,null,7356508,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A37","v":14},null,"TOTAL RIDERS",null,null,null,null,null,null,null,{"$f":"SUM(AD74:AD77)","v":7791366},null,{"$f":"ROUND((AD79/$AD$81)*100,1)","v":12.8},null,{"$f":"SUM(AH74:AH77)","v":0},null,{"$f":"IF(AD79=0,\"0.0 \",ROUND((AH79/AD79)*100,1))","v":0},null,null,null,{"$f":"SUM(AN74:AN77)","v":7791366},null,{"$f":"IF(AN79=0,\"0.0 \",ROUND((AH79/AN79)*100,1))","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A39","v":15},null,"TOTAL RATE RS RESIDENTIAL INCLUDING RIDERS",null,{"$f":"X66","v":1194296},null,{"$f":"Z69","v":6130423},null,null,null,{"$f":"AD71+AD79","v":60860328},null,{"$f":"SUM(AF71+AF79)","v":100},null,{"$f":"AH71+AH79","v":13989849},null,{"$f":"IF(AD81=0,\"0.0 \",ROUND((AH81/AD81)*100,1))","v":23},null,{"$f":"P39","v":41068317},null,{"$f":"AN71+AN79","v":101928645},null,{"$f":"IF(AN81=0,\"0.0 \",ROUND((AH81/AN81)*100,1))","v":13.7}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(1) BILLS THAT TERMINATE IN RESPECTIVE RATE STEPS."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(2) REFLECTS NORMALIZED VOLUMES."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"(3) REFLECTS AVERAGE EXPECTED GAS COST OF \"&TEXT(EGC,\"$0.000\")&\"/MCF.\"","v":"(3) REFLECTS AVERAGE EXPECTED GAS COST OF $6.699/MCF."}]

{"sheet":"Rate GS COM","index":7,"n_rows":212,"n_cols":42,"rows_kept":212,"cut":false,"hidden":false,"merged":[]}
[{"$f":"COMPANY","v":"DUKE ENERGY KENTUCKY"}]
[{"$f":"CASE","v":"CASE NO. 2025-00125"}]
["ANNUALIZED REVENUES AT PROPOSED VS. MOST CURRENT RATES"]
[{"$f":"TIME_PERIOD","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2026"}]
[{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE M-2.3"]
[{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PAGE  3  OF  7"]
["WORK PAPER REFERENCE NO(S).:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"B. L. Sailers"}]
["PROPOSED ANNUALIZED"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"PROPOSED",null,"% OF REV TO",null,null,null,"PROPOSED"]
[null,null,null,null,null,null,null,null,null,null,null,"REVENUE LESS",null,"TOTAL LESS",null,null,null,"TOTAL"]
["LINE",null,"RATE","CLASS /",null,"CUSTOMER",null,null,null,"PROPOSED",null,"GAS COST",null,"GAS COST",null,"GAS COST",null,"REVENUE"]
[" NO.",null,"CODE","DESCRIPTION",null,"BILLS(1)",null,"SALES(2)",null,"RATES",null,"REVENUE",null,"REVENUE",null,"REVENUE(3)",null,"(F + H)"]
[null,null,"(A)","(B)",null,"(C)",null,"(D)",null,"(E)",null,"(F)",null,"(G)",null,"(H)",null,"(I)"]
[]
[null,null,null,null,null,null,null,"(MCF)",null,"($/MCF)",null,"($)",null,"(%)",null,"($)",null,"($)"]
[1,null,"GS","COMMERCIAL"]
[]
[2,null,"CUSTOMER CHARGE:"]
[3,null,"NON-RESIDENTIAL"]
[4,null,"    TOTAL MONTHLY BILLS x  :"]
[5,null,"     CUSTOMER CHARGE PER MONTH",null,null,80932,null,null,null,{"$f":"PRO_GS_CUST","v":65},null,{"$f":"ROUND(F24*J24,0)","v":5260580},null,{"$f":"ROUND((L24/$L$38)*100,1)","v":23.4},null,null,null,{"$f":"L24+P24","v":5260580}]
[]
[6,null,"COMMODITY CHARGE:"]
[7,null,"     ALL CONSUMPTION",null,null,null,null,2939387,null,{"$f":"PRO_GS","v":5.5681000000000003},null,{"$f":"ROUND((H27*J27),0)","v":16366801},null,{"$f":"ROUND((L27/$L$38)*100,1)","v":72.7},null,{"$f":"ROUND(H27*EGC,0)","v":19691247},null,{"$f":"L27+P27","v":36058048}]
[]
[8,null,"RATE GS COMMERCIAL EXCLUDING RIDERS",null,null,{"$f":"F24","v":80932},null,{"$f":"H27","v":2939387},null,null,null,{"$f":"SUM(L24:L27)","v":21627381},null,{"$f":"ROUND((L29/$L$38)*100,1)","v":96.1},null,{"$f":"SUM(P24:P27)","v":19691247},null,{"$f":"SUM(R24:R27)","v":41318628}]
[]
[9,null,"RIDERS:"]
[10,null,"DEMAND SIDE MANAGEMENT RATE (DSMR)",null,null,null,null,null,null,{"$f":"PRO_GS_DSM","v":0},null,{"$f":"ROUND(H27*J32,0)","v":0},null,{"$f":"ROUND((L32/$L$38)*100,1)","v":0},null,null,null,{"$f":"L32+P32","v":0}]
[11,null,"WEATHER NORMALIZATION ADJUSTMENT (WNA)",null,null,null,null,null,null,0,null,{"$f":"ROUND(H29*J33,0)","v":0},null,{"$f":"ROUND((L33/$L$38)*100,1)","v":0},null,null,null,{"$f":"L33+P33","v":0}]
[12,null,"PIPELINE MODERNIZATION MECHANISM (PMM)",null,null,null,null,null,null,{"$f":"PRO_GS_PMM","v":0.3},null,{"$f":"ROUND(H29*J34,0)","v":881816},null,{"$f":"ROUND((L34/$L$38)*100,1)","v":3.9},null,null,null,{"$f":"L34+P34","v":881816}]
[]
[13,null,"TOTAL RIDERS",null,null,null,null,null,null,null,null,{"$f":"SUM(L31:L34)","v":881816},null,{"$f":"ROUND((L36/$L$38)*100,1)","v":3.9},null,null,null,{"$f":"SUM(R31:R34)","v":881816}]
[]
[14,null,"TOTAL RATE GS COMMERCIAL INCLUDING RIDERS",null,null,{"$f":"F24","v":80932},null,{"$f":"H27","v":2939387},null,null,null,{"$f":"L29+L36","v":22509197},null,{"$f":"N29+N36","v":100},null,{"$f":"P29+P36","v":19691247},null,{"$f":"R29+R36","v":42200444}]
[]
[null,null,"(1) BILLS THAT TERMINATE IN RESPECTIVE RATE STEPS."]
[null,null,"(2) REFLECTS NORMALIZED VOLUMES."]
[null,null,{"$f":"\"(3) REFLECTS AVERAGE EXPECTED GAS COST OF \"&TEXT(EGC,\"$0.000\")&\"/MCF.\"","v":"(3) REFLECTS AVERAGE EXPECTED GAS COST OF $6.699/MCF."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COMPANY","v":"DUKE ENERGY KENTUCKY"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CASE","v":"CASE NO. 2025-00125"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANNUALIZED TEST YEAR REVENUES AT PROPOSED VS. MOST CURRENT RATES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TIME_PERIOD","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2026"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE M-2.2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R7","v":"PAGE  3  OF  7"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WORK PAPER REFERENCE NO(S).:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"B. L. Sailers"}]
[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,"  CURRENT ANNUALIZED"]
[]
[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,"CURRENT",null,"% OF REV TO",null,"REVENUE",null,"% INCR IN",null,null,null,"CURRENT",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,null,"MOST",null,"REVENUE LESS",null,"TOTAL LESS",null,"INCR LESS",null,"REV LESS ",null,null,null,"TOTAL",null,"REVENUE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LINE",null,"RATE","CLASS /","CUSTOMER",null,null,null,"CURRENT",null,"GAS COST",null,"GAS COST",null,"GAS COST REV",null,"GAS COST REV",null,"GAS COST",null,"REVENUE",null,"% INCREASE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," NO.",null,"CODE","DESCRIPTION","BILLS(1)",null,"SALES(2)",null,"RATES",null,"REVENUE",null,"REVENUE",null,"(F - K)",null,"(M / K)",null,"REVENUE(3)",null,"(K + H)",null,"(M / K1)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(A)","(B)","(C)",null,"(D)",null,"(J)",null,"(K)",null,"(L)",null,"(M)",null,"(N)",null,"(H)",null,"(K1)",null,"(O)"]
[]
[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,"(MCF)",null,"($/MCF)",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,1,null,"GS","COMMERCIAL"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,"CUSTOMER CHARGE:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,"NON-RESIDENTIAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,"     TOTAL MONTHLY BILLS x  :"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,"     CUSTOMER CHARGE PER MONTH",null,{"$f":"F24","v":80932},null,null,null,{"$f":"CUR_GS_CUST","v":58},null,{"$f":"ROUND(X65*AB65,0)","v":4694056},null,{"$f":"ROUND((AD65/$AD$79)*100,1)","v":28.3},null,{"$f":"L24-AD65","v":566524},null,{"$f":"IF(AD65=0,\"0.0 \",ROUND((AH65/AD65)*100,1))","v":12.1},null,null,null,{"$f":"AD65+AL65","v":4694056},null,{"$f":"IF(AN65=0,\"0.0 \",ROUND((AH65/AN65)*100,1))","v":12.1}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,"COMMODITY CHARGE:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,null,"     ALL CONSUMPTION",null,null,null,{"$f":"H27","v":2939387},null,{"$f":"CUR_GS","v":3.7443},null,{"$f":"ROUND((Z68*AB68),0)","v":11005947},null,{"$f":"ROUND((AD68/$AD$79)*100,1)","v":66.400000000000006},null,{"$f":"L27-AD68","v":5360854},null,{"$f":"IF(AD68=0,\"0.0 \",ROUND((AH68/AD68)*100,1))","v":48.7},null,{"$f":"P27","v":19691247},null,{"$f":"AD68+AL68","v":30697194},null,{"$f":"IF(AN68=0,\"0.0 \",ROUND((AH68/AN68)*100,1))","v":17.5}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,"RATE GS COMMERCIAL EXCLUDING RIDERS",null,{"$f":"X65","v":80932},null,{"$f":"Z68","v":2939387},null,null,null,{"$f":"SUM(AD65:AD68)","v":15700003},null,{"$f":"ROUND((AD70/$AD$79)*100,1)","v":94.7},null,{"$f":"SUM(AH65:AH68)","v":5927378},null,{"$f":"IF(AD70=0,\"0.0 \",ROUND((AH70/AD70)*100,1))","v":37.799999999999997},null,{"$f":"SUM(AL65:AL68)","v":19691247},null,{"$f":"SUM(AN65:AN68)","v":35391250},null,{"$f":"IF(AN70=0,\"0.0 \",ROUND((AH70/AN70)*100,1))","v":16.7}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,null,"RIDERS:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,{"$f":"C32","v":"DEMAND SIDE MANAGEMENT RATE (DSMR)"},null,null,null,null,null,{"$f":"CUR_GS_DSM","v":0},null,{"$f":"ROUND(Z68*AB73,0)","v":0},null,{"$f":"ROUND((AD73/$AD$79)*100,1)","v":0},null,{"$f":"L32-AD73","v":0},null,{"$f":"IF(AD73=0,\"0.0 \",ROUND((AH73/AD73)*100,1))","v":"0.0 "},null,null,null,{"$f":"AD73+AL73","v":0},null,{"$f":"IF(AN73=0,\"0.0 \",ROUND((AH73/AN73)*100,1))","v":"0.0 "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A33","v":11},null,"WEATHER NORMALIZATION ADJUSTMENT (WNA)",null,null,null,null,null,0,null,{"$f":"ROUND(Z70*AB74,0)","v":0},null,{"$f":"ROUND((AD74/$AD$79)*100,1)","v":0},null,{"$f":"L33-AD74","v":0},null,{"$f":"IF(AD74=0,\"0.0 \",ROUND((AH74/AD74)*100,1))","v":"0.0 "},null,null,null,{"$f":"AD74+AL74","v":0},null,{"$f":"IF(AN74=0,\"0.0 \",ROUND((AH74/AN74)*100,1))","v":"0.0 "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,null,{"$f":"C34","v":"PIPELINE MODERNIZATION MECHANISM (PMM)"},null,null,null,null,null,{"$f":"CUR_GS_PMM","v":0.3},null,{"$f":"ROUND(Z70*AB75,0)","v":881816},null,{"$f":"ROUND((AD75/$AD$79)*100,1)","v":5.3},null,{"$f":"L34-AD75","v":0},null,{"$f":"IF(AD75=0,\"0.0 \",ROUND((AH75/AD75)*100,1))","v":0},null,null,null,{"$f":"AD75+AL75","v":881816},null,{"$f":"IF(AN75=0,\"0.0 \",ROUND((AH75/AN75)*100,1))","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A36","v":13},null,"TOTAL RIDERS",null,null,null,null,null,null,null,{"$f":"SUM(AD72:AD75)","v":881816},null,{"$f":"ROUND((AD77/$AD$79)*100,1)","v":5.3},null,{"$f":"SUM(AH72:AH75)","v":0},null,{"$f":"IF(AD77=0,\"0.0 \",ROUND((AH77/AD77)*100,1))","v":0},null,null,null,{"$f":"SUM(AN72:AN75)","v":881816},null,{"$f":"IF(AN77=0,\"0.0 \",ROUND((AH77/AN77)*100,1))","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A38","v":14},null,"TOTAL RATE GS COMMERCIAL INCLUDING RIDERS",null,{"$f":"X65","v":80932},null,{"$f":"Z68","v":2939387},null,null,null,{"$f":"AD70+AD77","v":16581819},null,{"$f":"AF70+AF77","v":100},null,{"$f":"AH70+AH77","v":5927378},null,{"$f":"IF(AD79=0,\"0.0 \",ROUND((AH79/AD79)*100,1))","v":35.700000000000003},null,{"$f":"P38","v":19691247},null,{"$f":"AN70+AN77","v":36273066},null,{"$f":"IF(AN79=0,\"0.0 \",ROUND((AH79/AN79)*100,1))","v":16.3}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(1) BILLS THAT TERMINATE IN RESPECTIVE RATE STEPS."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(2) REFLECTS NORMALIZED VOLUMES."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"(3) REFLECTS AVERAGE EXPECTED GAS COST OF \"&TEXT(EGC,\"$0.000\")&\"/MCF.\"","v":"(3) REFLECTS AVERAGE EXPECTED GAS COST OF $6.699/MCF."}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,"***  MENU  ***"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ROUTINE",null,null,null,null,null,"ENTER"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PRINT SCHEDULES E-4 and E-4.1",null,null,null,null,null,null,"ALT A"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PRINT SCHEDULE E-5",null,null,null,null,null,null,"ALT B"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SAVE FILE"," (NOTE: MUST USE WHEN SAVING FILE)",null,null,null,null,null,"ALT S"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GO TO MENU",null,null,null,null,null,null,"ALT M"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RANGE NAME INDEX",null,null,null,null,null,null,"ALT I"]

{"sheet":"Rate GS IND","index":8,"n_rows":88,"n_cols":42,"rows_kept":88,"cut":false,"hidden":false,"merged":[]}
[{"$f":"COMPANY","v":"DUKE ENERGY KENTUCKY"}]
[{"$f":"CASE","v":"CASE NO. 2025-00125"}]
["ANNUALIZED REVENUES AT PROPOSED VS. MOST CURRENT RATES"]
[{"$f":"TIME_PERIOD","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2026"}]
[{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE M-2.3"]
[{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PAGE  4  OF  7"]
["WORK PAPER REFERENCE NO(S).:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"B. L. Sailers"}]
["PROPOSED ANNUALIZED"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"PROPOSED",null,"% OF REV TO",null,null,null,"PROPOSED"]
[null,null,null,null,null,null,null,null,null,null,null,"REVENUE LESS",null,"TOTAL LESS",null,null,null,"TOTAL"]
["LINE",null,"RATE","CLASS /",null,"CUSTOMER",null,null,null,"PROPOSED",null,"GAS COST",null,"GAS COST",null,"GAS COST",null,"REVENUE"]
[" NO.",null,"CODE","DESCRIPTION",null,"BILLS(1)",null,"SALES(2)",null,"RATES",null,"REVENUE",null,"REVENUE",null,"REVENUE(3)",null,"(F + H)"]
[null,null,"(A)","(B)",null,"(C)",null,"(D)",null,"(E)",null,"(F)",null,"(G)",null,"(H)",null,"(I)"]
[]
[null,null,null,null,null,null,null,"(MCF)",null,"($/MCF)",null,"($)",null,"(%)",null,"($)",null,"($)"]
[1,null,"GS","INDUSTRIAL"]
[]
[2,null,"CUSTOMER CHARGE:"]
[3,null,"NON-RESIDENTIAL"]
[4,null,"    TOTAL MONTHLY BILLS x  :"]
[5,null,"     CUSTOMER CHARGE PER MONTH",null,null,2047,null,null,null,{"$f":"PRO_GS_CUST","v":65},null,{"$f":"ROUND(F24*J24,0)","v":133055},null,{"$f":"ROUND((L24/$L$38)*100,1)","v":9.9},null,null,null,{"$f":"L24+P24","v":133055}]
[]
[6,null,"COMMODITY CHARGE:"]
[7,null,"     ALL CONSUMPTION",null,null,null,null,205705,null,{"$f":"PRO_GS","v":5.5681000000000003},null,{"$f":"ROUND((H27*J27),0)","v":1145386},null,{"$f":"ROUND((L27/$L$38)*100,1)","v":85.5},null,{"$f":"ROUND(EGC*$H27,0)","v":1378038},null,{"$f":"L27+P27","v":2523424}]
[]
[8,null,"RATE GS INDUSTRIAL EXCLUDING RIDERS",null,null,{"$f":"F24","v":2047},null,{"$f":"H27","v":205705},null,null,null,{"$f":"SUM(L24:L27)","v":1278441},null,{"$f":"ROUND((L29/$L$38)*100,1)","v":95.4},null,{"$f":"SUM(P24:P27)","v":1378038},null,{"$f":"SUM(R24:R27)","v":2656479}]
[]
[9,null,"RIDERS:"]
[10,null,"DEMAND SIDE MANAGEMENT RATE (DSMR)",null,null,null,null,null,null,{"$f":"PRO_GS_DSM","v":0},null,{"$f":"ROUND(H27*J32,0)","v":0},null,{"$f":"ROUND((L32/$L$38)*100,1)","v":0},null,null,null,{"$f":"L32+P32","v":0}]
[11,null,"WEATHER NORMALIZATION ADJUSTMENT (WNA)",null,null,null,null,null,null,0,null,{"$f":"ROUND(H29*J33,0)","v":0},null,{"$f":"ROUND((L33/$L$38)*100,1)","v":0},null,null,null,{"$f":"L33+P33","v":0}]
[12,null,"PIPELINE MODERNIZATION MECHANISM (PMM)",null,null,null,null,null,null,{"$f":"PRO_GS_PMM","v":0.3},null,{"$f":"ROUND(H29*J34,0)","v":61712},null,{"$f":"ROUND((L34/$L$38)*100,1)","v":4.5999999999999996},null,null,null,{"$f":"L34+P34","v":61712}]
[]
[13,null,"TOTAL RIDERS",null,null,null,null,null,null,null,null,{"$f":"SUM(L31:L34)","v":61712},null,{"$f":"ROUND((L36/$L$38)*100,1)","v":4.5999999999999996},null,null,null,{"$f":"SUM(R31:R34)","v":61712}]
[]
[14,null,"TOTAL RATE GS INDUSTRIAL INCLUDING RIDERS",null,null,{"$f":"F24","v":2047},null,{"$f":"H27","v":205705},null,null,null,{"$f":"L29+L36","v":1340153},null,{"$f":"N29+N36","v":100},null,{"$f":"P29+P36","v":1378038},null,{"$f":"R29+R36","v":2718191}]
[]
[null,null,"(1) BILLS THAT TERMINATE IN RESPECTIVE RATE STEPS."]
[null,null,"(2) REFLECTS NORMALIZED VOLUMES."]
[null,null,{"$f":"\"(3) REFLECTS AVERAGE EXPECTED GAS COST OF \"&TEXT(EGC,\"$0.000\")&\"/MCF.\"","v":"(3) REFLECTS AVERAGE EXPECTED GAS COST OF $6.699/MCF."}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COMPANY","v":"DUKE ENERGY KENTUCKY"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CASE","v":"CASE NO. 2025-00125"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANNUALIZED TEST YEAR REVENUES AT PROPOSED VS. MOST CURRENT RATES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TIME_PERIOD","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2026"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE M-2.2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R7","v":"PAGE  4  OF  7"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WORK PAPER REFERENCE NO(S).:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"B. L. Sailers"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CURRENT ANNUALIZED"]
[]
[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,"CURRENT",null,"% OF REV TO",null,"REVENUE",null,"% INCR IN",null,null,null,"CURRENT",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,null,"MOST",null,"REVENUE LESS",null,"TOTAL LESS",null,"INCR LESS",null,"REV LESS ",null,null,null,"TOTAL",null,"REVENUE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LINE",null,"RATE","CLASS /","CUSTOMER",null,null,null,"CURRENT",null,"GAS COST",null,"GAS COST",null,"GAS COST REV",null,"GAS COST REV",null,"GAS COST",null,"REVENUE",null,"% INCREASE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," NO.",null,"CODE","DESCRIPTION","BILLS(1)",null,"SALES(2)",null,"RATES",null,"REVENUE",null,"REVENUE",null,"(F - K)",null,"(M / K)",null,"REVENUE(3)",null,"(K + H)",null,"(M / K1)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(A)","(B)","(C)",null,"(D)",null,"(J)",null,"(K)",null,"(L)",null,"(M)",null,"(N)",null,"(H)",null,"(K1)",null,"(O)"]
[]
[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,"(MCF)",null,"($/MCF)",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,1,null,"GS","INDUSTRIAL"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,"CUSTOMER CHARGE:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,"NON-RESIDENTIAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,"     TOTAL MONTHLY BILLS x  :"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,"     CUSTOMER CHARGE PER MONTH",null,{"$f":"F24","v":2047},null,null,null,{"$f":"CUR_GS_CUST","v":58},null,{"$f":"ROUND(X70*AB70,0)","v":118726},null,{"$f":"ROUND((AD70/$AD$84)*100,1)","v":12.5},null,{"$f":"L24-AD70","v":14329},null,{"$f":"IF(AD70=0,\"0.0 \",ROUND((AH70/AD70)*100,1))","v":12.1},null,null,null,{"$f":"AD70+AL70","v":118726},null,{"$f":"IF(AN70=0,\"0.0 \",ROUND((AH70/AN70)*100,1))","v":12.1}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,"COMMODITY CHARGE:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,null,"     ALL CONSUMPTION",null,null,null,{"$f":"H27","v":205705},null,{"$f":"CUR_GS","v":3.7443},null,{"$f":"ROUND((Z73*AB73),0)","v":770221},null,{"$f":"ROUND((AD73/$AD$84)*100,1)","v":81},null,{"$f":"L27-AD73","v":375165},null,{"$f":"IF(AD73=0,\"0.0 \",ROUND((AH73/AD73)*100,1))","v":48.7},null,{"$f":"P27","v":1378038},null,{"$f":"AD73+AL73","v":2148259},null,{"$f":"IF(AN73=0,\"0.0 \",ROUND((AH73/AN73)*100,1))","v":17.5}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,"RATE GS INDUSTRIAL EXCLUDING RIDERS",null,{"$f":"X70","v":2047},null,{"$f":"Z73","v":205705},null,null,null,{"$f":"SUM(AD70:AD73)","v":888947},null,{"$f":"ROUND((AD75/$AD$84)*100,1)","v":93.5},null,{"$f":"SUM(AH70:AH73)","v":389494},null,{"$f":"IF(AD75=0,\"0.0 \",ROUND((AH75/AD75)*100,1))","v":43.8},null,{"$f":"SUM(AL70:AL73)","v":1378038},null,{"$f":"SUM(AN70:AN73)","v":2266985},null,{"$f":"IF(AN75=0,\"0.0 \",ROUND((AH75/AN75)*100,1))","v":17.2}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,null,"RIDERS:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,{"$f":"C38","v":"TOTAL RATE GS INDUSTRIAL INCLUDING RIDERS"},null,null,null,null,null,{"$f":"CUR_GS_DSM","v":0},null,{"$f":"ROUND(Z73*AB78,0)","v":0},null,{"$f":"ROUND((AD78/$AD$84)*100,1)","v":0},null,{"$f":"L32-AD78","v":0},null,{"$f":"IF(AD78=0,\"0.0 \",ROUND((AH78/AD78)*100,1))","v":"0.0 "},null,null,null,{"$f":"AD78+AL78","v":0},null,{"$f":"IF(AN78=0,\"0.0 \",ROUND((AH78/AN78)*100,1))","v":"0.0 "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A33","v":11},null,"WEATHER NORMALIZATION ADJUSTMENT (WNA)",null,null,null,null,null,0,null,{"$f":"ROUND(Z75*AB79,0)","v":0},null,{"$f":"ROUND((AD79/$AD$84)*100,1)","v":0},null,{"$f":"L33-AD79","v":0},null,{"$f":"IF(AD79=0,\"0.0 \",ROUND((AH79/AD79)*100,1))","v":"0.0 "},null,null,null,{"$f":"AD79+AL79","v":0},null,{"$f":"IF(AN79=0,\"0.0 \",ROUND((AH79/AN79)*100,1))","v":"0.0 "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,null,"PIPELINE MODERNIZATION MECHANISM (PMM)",null,null,null,null,null,{"$f":"CUR_GS_PMM","v":0.3},null,{"$f":"ROUND(Z75*AB80,0)","v":61712},null,{"$f":"ROUND((AD80/$AD$84)*100,1)","v":6.5},null,{"$f":"L34-AD80","v":0},null,{"$f":"IF(AD80=0,\"0.0 \",ROUND((AH80/AD80)*100,1))","v":0},null,null,null,{"$f":"AD80+AL80","v":61712},null,{"$f":"IF(AN80=0,\"0.0 \",ROUND((AH80/AN80)*100,1))","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A36","v":13},null,"TOTAL RIDERS",null,null,null,null,null,null,null,{"$f":"SUM(AD77:AD80)","v":61712},null,{"$f":"ROUND((AD82/$AD$84)*100,1)","v":6.5},null,{"$f":"SUM(AH77:AH80)","v":0},null,{"$f":"IF(AD82=0,\"0.0 \",ROUND((AH82/AD82)*100,1))","v":0},null,null,null,{"$f":"SUM(AN77:AN80)","v":61712},null,{"$f":"IF(AN82=0,\"0.0 \",ROUND((AH82/AN82)*100,1))","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A38","v":14},null,"TOTAL RATE GS INDUSTRIAL INCLUDING RIDERS",null,{"$f":"X70","v":2047},null,{"$f":"Z73","v":205705},null,null,null,{"$f":"AD75+AD82","v":950659},null,{"$f":"AF75+AF82","v":100},null,{"$f":"AH75+AH82","v":389494},null,{"$f":"IF(AD84=0,\"0.0 \",ROUND((AH84/AD84)*100,1))","v":41},null,{"$f":"P38","v":1378038},null,{"$f":"AN75+AN82","v":2328697},null,{"$f":"IF(AN84=0,\"0.0 \",ROUND((AH84/AN84)*100,1))","v":16.7}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(1) BILLS THAT TERMINATE IN RESPECTIVE RATE STEPS."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(2) REFLECTS NORMALIZED VOLUMES."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"(3) REFLECTS AVERAGE EXPECTED GAS COST OF \"&TEXT(EGC,\"$0.000\")&\"/MCF.\"","v":"(3) REFLECTS AVERAGE EXPECTED GAS COST OF $6.699/MCF."}]

{"sheet":"Rate GS OPA","index":9,"n_rows":85,"n_cols":42,"rows_kept":85,"cut":false,"hidden":false,"merged":[]}
[{"$f":"COMPANY","v":"DUKE ENERGY KENTUCKY"}]
[{"$f":"CASE","v":"CASE NO. 2025-00125"}]
["ANNUALIZED REVENUES AT PROPOSED VS. MOST CURRENT RATES"]
[{"$f":"TIME_PERIOD","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2026"}]
[{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE M-2.3"]
[{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PAGE  5  OF  7"]
["WORK PAPER REFERENCE NO(S).:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"B. L. Sailers"}]
["PROPOSED ANNUALIZED"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"PROPOSED",null,"% OF REV TO",null,null,null,"PROPOSED"]
[null,null,null,null,null,null,null,null,null,null,null,"REVENUE LESS",null,"TOTAL LESS",null,null,null,"TOTAL"]
["LINE",null,"RATE","CLASS /",null,"CUSTOMER",null,null,null,"PROPOSED",null,"GAS COST",null,"GAS COST",null,"GAS COST",null,"REVENUE"]
[" NO.",null,"CODE","DESCRIPTION",null,"BILLS(1)",null,"SALES(2)",null,"RATES",null,"REVENUE",null,"REVENUE",null,"REVENUE(3)",null,"(F + H)"]
[null,null,"(A)","(B)",null,"(C)",null,"(D)",null,"(E)",null,"(F)",null,"(G)",null,"(H)",null,"(I)"]
[]
[null,null,null,null,null,null,null,"(MCF)",null,"($/MCF)",null,"($)",null,"(%)",null,"($)",null,"($)"]
[1,null,"GS","OTHER PUBLIC AUTHORITIES"]
[]
[2,null,"CUSTOMER CHARGE:"]
[3,null,"NON-RESIDENTIAL"]
[4,null,"    TOTAL MONTHLY BILLS x  :"]
[5,null,"     CUSTOMER CHARGE PER MONTH",null,null,3526,null,null,null,{"$f":"PRO_GS_CUST","v":65},null,{"$f":"ROUND(F24*J24,0)","v":229190},null,{"$f":"ROUND((L24/$L$38)*100,1)","v":12.9},null,null,null,{"$f":"L24+P24","v":229190}]
[]
[6,null,"COMMODITY CHARGE:"]
[7,null,"     ALL CONSUMPTION",null,null,null,null,264202,null,{"$f":"PRO_GS","v":5.5681000000000003},null,{"$f":"ROUND((H27*J27),0)","v":1471103},null,{"$f":"ROUND((L27/$L$38)*100,1)","v":82.7},null,{"$f":"ROUND(EGC*$H27,0)","v":1769916},null,{"$f":"L27+P27","v":3241019}]
[]
[8,null,"RATE GS OPA EXCLUDING RIDERS",null,null,{"$f":"F24","v":3526},null,{"$f":"H27","v":264202},null,null,null,{"$f":"SUM(L24:L27)","v":1700293},null,{"$f":"ROUND((L29/$L$38)*100,1)","v":95.5},null,{"$f":"SUM(P24:P27)","v":1769916},null,{"$f":"SUM(R24:R27)","v":3470209}]
[]
[9,null,"RIDERS:"]
[10,null,"DEMAND SIDE MANAGEMENT RATE (DSMR)",null,null,null,null,null,null,{"$f":"PRO_GS_DSM","v":0},null,{"$f":"ROUND(H27*J32,0)","v":0},null,{"$f":"ROUND((L32/$L$38)*100,1)","v":0},null,null,null,{"$f":"L32+P32","v":0}]
[11,null,"WEATHER NORMALIZATION ADJUSTMENT (WNA)",null,null,null,null,null,null,0,null,{"$f":"ROUND(H29*J33,0)","v":0},null,{"$f":"ROUND((L33/$L$38)*100,1)","v":0},null,null,null,{"$f":"L33+P33","v":0}]
[12,null,"PIPELINE MODERNIZATION MECHANISM (PMM)",null,null,null,null,null,null,{"$f":"PRO_GS_PMM","v":0.3},null,{"$f":"ROUND(H29*J34,0)","v":79261},null,{"$f":"ROUND((L34/$L$38)*100,1)","v":4.5},null,null,null,{"$f":"L34+P34","v":79261}]
[]
[13,null,"TOTAL RIDERS",null,null,null,null,null,null,null,null,{"$f":"SUM(L31:L34)","v":79261},null,{"$f":"ROUND((L36/$L$38)*100,1)","v":4.5},null,null,null,{"$f":"SUM(R31:R34)","v":79261}]
[]
[14,null,"TOTAL RATE GS OPA INCLUDING RIDERS",null,null,{"$f":"F24","v":3526},null,{"$f":"H27","v":264202},null,null,null,{"$f":"L29+L36","v":1779554},null,{"$f":"SUM(N29+N36)","v":100},null,{"$f":"P29+P36","v":1769916},null,{"$f":"R29+R36","v":3549470}]
[]
[null,null,"(1) BILLS THAT TERMINATE IN RESPECTIVE RATE STEPS."]
[null,null,"(2) REFLECTS NORMALIZED VOLUMES."]
[null,null,{"$f":"\"(3) REFLECTS AVERAGE EXPECTED GAS COST OF \"&TEXT(EGC,\"$0.000\")&\"/MCF.\"","v":"(3) REFLECTS AVERAGE EXPECTED GAS COST OF $6.699/MCF."}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COMPANY","v":"DUKE ENERGY KENTUCKY"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CASE","v":"CASE NO. 2025-00125"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANNUALIZED TEST YEAR REVENUES AT PROPOSED VS. MOST CURRENT RATES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TIME_PERIOD","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2026"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE M-2.2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R7","v":"PAGE  5  OF  7"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WORK PAPER REFERENCE NO(S).:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"B. L. Sailers"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CURRENT ANNUALIZED"]
[]
[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,"CURRENT",null,"% OF REV TO",null,"REVENUE",null,"% INCR IN",null,null,null,"CURRENT",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,null,"MOST",null,"REVENUE LESS",null,"TOTAL LESS",null,"INCR LESS",null,"REV LESS ",null,null,null,"TOTAL",null,"REVENUE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LINE",null,"RATE","CLASS /","CUSTOMER",null,null,null,"CURRENT",null,"GAS COST",null,"GAS COST",null,"GAS COST REV",null,"GAS COST REV",null,"GAS COST",null,"REVENUE",null,"% INCREASE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," NO.",null,"CODE","DESCRIPTION","BILLS(1)",null,"SALES(2)",null,"RATES",null,"REVENUE",null,"REVENUE",null,"(F - K)",null,"(M / K)",null,"REVENUE(3)",null,"(K + H)",null,"(M / K1)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(A)","(B)","(C)",null,"(D)",null,"(J)",null,"(K)",null,"(L)",null,"(M)",null,"(N)",null,"(H)",null,"(K1)",null,"(O)"]
[]
[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,"(MCF)",null,"($/MCF)",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,1,null,"GS","OTHER PUBLIC AUTHORITIES"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,"CUSTOMER CHARGE:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,"NON-RESIDENTIAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,"     TOTAL MONTHLY BILLS  x :"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,"     CUSTOMER CHARGE PER MONTH",null,{"$f":"F24","v":3526},null,null,null,{"$f":"CUR_GS_CUST","v":58},null,{"$f":"ROUND(X67*AB67,0)","v":204508},null,{"$f":"ROUND((AD67/$AD$81)*100,1)","v":16.100000000000001},null,{"$f":"L24-AD67","v":24682},null,{"$f":"IF(AD67=0,\"0.0 \",ROUND((AH67/AD67)*100,1))","v":12.1},null,null,null,{"$f":"AD67+AL67","v":204508},null,{"$f":"IF(AN67=0,\"0.0 \",ROUND((AH67/AN67)*100,1))","v":12.1}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,"COMMODITY CHARGE:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,null,"     ALL CONSUMPTION",null,null,null,{"$f":"H27","v":264202},null,{"$f":"CUR_GS","v":3.7443},null,{"$f":"ROUND((Z70*AB70),0)","v":989252},null,{"$f":"ROUND((AD70/$AD$81)*100,1)","v":77.7},null,{"$f":"L27-AD70","v":481851},null,{"$f":"IF(AD70=0,\"0.0 \",ROUND((AH70/AD70)*100,1))","v":48.7},null,{"$f":"P27","v":1769916},null,{"$f":"AD70+AL70","v":2759168},null,{"$f":"IF(AN70=0,\"0.0 \",ROUND((AH70/AN70)*100,1))","v":17.5}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,"RATE GS OPA EXCLUDING RIDERS",null,{"$f":"X67","v":3526},null,{"$f":"Z70","v":264202},null,null,null,{"$f":"SUM(AD67:AD70)","v":1193760},null,{"$f":"ROUND((AD72/$AD$81)*100,1)","v":93.8},null,{"$f":"SUM(AH67:AH70)","v":506533},null,{"$f":"IF(AD72=0,\"0.0 \",ROUND((AH72/AD72)*100,1))","v":42.4},null,{"$f":"SUM(AL67:AL70)","v":1769916},null,{"$f":"SUM(AN67:AN70)","v":2963676},null,{"$f":"IF(AN72=0,\"0.0 \",ROUND((AH72/AN72)*100,1))","v":17.100000000000001}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,null,"RIDERS:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,"DEMAND SIDE MANAGEMENT RATE (DSMR)",null,null,null,null,null,{"$f":"CUR_GS_DSM","v":0},null,{"$f":"ROUND(Z70*AB75,0)","v":0},null,{"$f":"ROUND((AD75/$AD$81)*100,1)","v":0},null,{"$f":"L32-AD75","v":0},null,{"$f":"IF(AD75=0,\"0.0 \",ROUND((AH75/AD75)*100,1))","v":"0.0 "},null,null,null,{"$f":"AD75+AL75","v":0},null,{"$f":"IF(AN75=0,\"0.0 \",ROUND((AH75/AN75)*100,1))","v":"0.0 "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A33","v":11},null,"WEATHER NORMALIZATION ADJUSTMENT (WNA)",null,null,null,null,null,0,null,{"$f":"ROUND(Z72*AB76,0)","v":0},null,{"$f":"ROUND((AD76/$AD$81)*100,1)","v":0},null,{"$f":"L33-AD76","v":0},null,{"$f":"IF(AD76=0,\"0.0 \",ROUND((AH76/AD76)*100,1))","v":"0.0 "},null,null,null,{"$f":"AD76+AL76","v":0},null,{"$f":"IF(AN76=0,\"0.0 \",ROUND((AH76/AN76)*100,1))","v":"0.0 "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,null,"PIPELINE MODERNIZATION MECHANISM (PMM)",null,null,null,null,null,{"$f":"CUR_GS_PMM","v":0.3},null,{"$f":"ROUND(Z72*AB77,0)","v":79261},null,{"$f":"ROUND((AD77/$AD$81)*100,1)","v":6.2},null,{"$f":"L34-AD77","v":0},null,{"$f":"IF(AD77=0,\"0.0 \",ROUND((AH77/AD77)*100,1))","v":0},null,null,null,{"$f":"AD77+AL77","v":79261},null,{"$f":"IF(AN77=0,\"0.0 \",ROUND((AH77/AN77)*100,1))","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A36","v":13},null,"TOTAL RIDERS",null,null,null,null,null,null,null,{"$f":"SUM(AD74:AD77)","v":79261},null,{"$f":"ROUND((AD79/$AD$81)*100,1)","v":6.2},null,{"$f":"SUM(AH74:AH77)","v":0},null,{"$f":"IF(AD79=0,\"0.0 \",ROUND((AH79/AD79)*100,1))","v":0},null,null,null,{"$f":"SUM(AN74:AN77)","v":79261},null,{"$f":"IF(AN79=0,\"0.0 \",ROUND((AH79/AN79)*100,1))","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A38","v":14},null,"TOTAL RATE GS OPA INCLUDING RIDERS",null,{"$f":"X67","v":3526},null,{"$f":"Z70","v":264202},null,null,null,{"$f":"AD72+AD79","v":1273021},null,{"$f":"AF72+AF79","v":100},null,{"$f":"AH72+AH79","v":506533},null,{"$f":"IF(AD81=0,\"0.0 \",ROUND((AH81/AD81)*100,1))","v":39.799999999999997},null,{"$f":"P38","v":1769916},null,{"$f":"AN72+AN79","v":3042937},null,{"$f":"IF(AN81=0,\"0.0 \",ROUND((AH81/AN81)*100,1))","v":16.600000000000001}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(1) BILLS THAT TERMINATE IN RESPECTIVE RATE STEPS."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(2) REFLECTS NORMALIZED VOLUMES."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"(3) REFLECTS AVERAGE EXPECTED GAS COST OF \"&TEXT(EGC,\"$0.000\")&\"/MCF.\"","v":"(3) REFLECTS AVERAGE EXPECTED GAS COST OF $6.699/MCF."}]

{"sheet":"Rate FT-LG","index":10,"n_rows":77,"n_cols":42,"rows_kept":77,"cut":false,"hidden":false,"merged":[]}
[{"$f":"COMPANY","v":"DUKE ENERGY KENTUCKY"}]
[{"$f":"CASE","v":"CASE NO. 2025-00125"}]
["ANNUALIZED REVENUES AT PROPOSED VS. MOST CURRENT RATES"]
[{"$f":"TIME_PERIOD","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2026"}]
[{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE M-2.3"]
[{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PAGE  6  OF  7"]
["WORK PAPER REFERENCE NO(S).:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"B. L. Sailers"}]
["PROPOSED ANNUALIZED"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"PROPOSED",null,"% OF REV TO",null,null,null,"PROPOSED"]
[null,null,null,null,null,null,null,null,null,null,null,"REVENUE LESS",null,"TOTAL LESS",null,null,null,"TOTAL"]
["LINE",null,"RATE","CLASS /",null,"CUSTOMER",null,null,null,"PROPOSED",null,"GAS COST",null,"GAS COST",null,"GAS COST",null,"REVENUE"]
[" NO.",null,"CODE","DESCRIPTION",null,"BILLS",null,"SALES(1)",null,"RATES",null,"REVENUE",null,"REVENUE",null,"REVENUE",null,"(F + H)"]
[null,null,"(A)","(B)",null,"(C)",null,"(D)",null,"(E)",null,"(F)",null,"(G)",null,"(H)",null,"(I)"]
[]
[null,null,null,null,null,null,null,"(MCF)",null,"($/MCF)",null,"($)",null,"(%)",null,"($)",null,"($)"]
[1,null,"FT - L"]
[2,null,"FIRM TRANSPORTATION - LARGE"]
[]
[3,null,"ADMINISTRATIVE CHARGE",null,null,1737,null,null,null,{"$f":"PRO_FTL_CUST","v":430},null,{"$f":"ROUND((F22*J22),0)","v":746910},null,{"$f":"ROUND((L22/L$35)*100,1)","v":10.199999999999999},null,null,null,{"$f":"L22+P22","v":746910}]
[]
[4,null,"TRANSPORTATION CHARGE:"]
[5,null,"ALL CONSUMPTION",null,null,null,null,3002186,null,{"$f":"PRO_FTL_COM","v":2.1688000000000001},null,{"$f":"ROUND((H25*J25),0)","v":6511141},null,{"$f":"ROUND((L25/L$35)*100,1)","v":89.3},null,null,null,{"$f":"L25+P25","v":6511141}]
[]
[6,null,"RATE FT-LARGE EXCLUDING RIDERS",null,null,{"$f":"F22","v":1737},null,{"$f":"H25","v":3002186},null,null,null,{"$f":"SUM(L22:L25)","v":7258051},null,{"$f":"SUM(N22:N25)","v":99.5},null,null,null,{"$f":"SUM(R22:R25)","v":7258051}]
[]
[7,null,"RIDERS:"]
[8,null,"PIPELINE MODERNIZATION MECHANISM (PMM)",null,null,null,null,null,null,{"$f":"PRO_FTL_PMM","v":1.0200000000000001E-2},null,{"$f":"ROUND(H25*J30,0)","v":30622},null,{"$f":"ROUND((L30/L$35)*100,1)","v":0.4},null,null,null,{"$f":"L30+P30","v":30622}]
[9,null,"GAS COST ADJUSTMENT TRANSITION (GCAT) (2)",null,null,null,null,null,null,{"$f":"PRO_FTL_GCAT","v":3.6999999999999998E-2},null,null,null,{"$f":"ROUND((L31/L$35)*100,1)","v":0},null,{"$f":"ROUND(H25*R38*J31,0)","v":3332},null,{"$f":"L31+P31","v":3332}]
[]
[10,null,"TOTAL RIDERS",null,null,null,null,null,null,null,null,{"$f":"SUM(L30:L31)","v":30622},null,{"$f":"ROUND((L33/L$35)*100,1)","v":0.4},null,{"$f":"P31","v":3332},null,{"$f":"SUM(R30:R31)","v":33954}]
[]
[11,null,"TOTAL RATE FT - LARGE INCLUDING RIDERS",null,null,{"$f":"F22","v":1737},null,{"$f":"H25","v":3002186},null,null,null,{"$f":"L27+L33","v":7288673},null,{"$f":"SUM(N27+N33)","v":99.9},null,{"$f":"P33+P27","v":3332},null,{"$f":"R27+R33","v":7292005}]
[]
[null,null,"(1) REFLECTS NORMALIZED VOLUMES."]
[null,null,"(2) GCAT only applies to FT-L customers during the first 12 months after they switch from sales service.  Usage for this rider estimated at ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COMPANY","v":"DUKE ENERGY KENTUCKY"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CASE","v":"CASE NO. 2025-00125"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANNUALIZED TEST YEAR REVENUES AT PROPOSED VS. MOST CURRENT RATES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TIME_PERIOD","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2026"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE M-2.2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R7","v":"PAGE  6  OF  7"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WORK PAPER REFERENCE NO(S).:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"B. L. Sailers"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CURRENT ANNUALIZED"]
[]
[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,"CURRENT",null,"% OF REV TO",null,"REVENUE",null,"% INCR IN",null,null,null,"CURRENT",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,null,"MOST",null,"REVENUE LESS",null,"TOTAL LESS",null,"INCR LESS",null,"REV LESS ",null,null,null,"TOTAL",null,"REVENUE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LINE",null,"RATE","CLASS /","CUSTOMER",null,null,null,"CURRENT",null,"GAS COST",null,"GAS COST",null,"GAS COST REV",null,"GAS COST REV",null,"GAS COST",null,"REVENUE",null,"% INCREASE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," NO.",null,"CODE","DESCRIPTION","BILLS",null,"SALES(1)",null,"RATES",null,"REVENUE",null,"REVENUE",null,"(F - K)",null,"(M / K)",null,"REVENUE",null,"(K + H)",null,"(M / K1)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(A)","(B)","(C)",null,"(D)",null,"(J)",null,"(K)",null,"(L)",null,"(M)",null,"(N)",null,"(H)",null,"(K1)",null,"(O)"]
[]
[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,"(MCF)",null,"($/MCF)",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,1,null,"FT - L"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,"FIRM TRANSPORTATION - LARGE"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,"ADMINISTRATIVE CHARGE",null,{"$f":"F22","v":1737},null,null,null,{"$f":"CUR_FTL_CUST","v":430},null,{"$f":"ROUND(X60*AB60,0)","v":746910},null,{"$f":"IF(AD$73=0,\"0.0 \",ROUND((AD60/AD$73)*100,1))","v":10.1},null,{"$f":"L22-AD60","v":0},null,{"$f":"IF(AD60=0,\"0.0 \",ROUND((AH60/AD60)*100,1))","v":0},null,null,null,{"$f":"AD60+AL60","v":746910},null,{"$f":"IF(AN60=0,\"0.0 \",ROUND((AH60/AN60)*100,1))","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,"TRANSPORTATION CHARGE:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,"ALL CONSUMPTION",null,null,null,{"$f":"H25","v":3002186},null,{"$f":"CUR_FTL_COM","v":2.1976},null,{"$f":"ROUND(Z63*AB63,0)","v":6597604},null,{"$f":"IF(AD$73=0,\"0.0 \",ROUND((AD63/AD$73)*100,1))","v":89.5},null,{"$f":"L25-AD63","v":-86463},null,{"$f":"IF(AD63=0,\"0.0 \",ROUND((AH63/AD63)*100,1))","v":-1.3},null,null,null,{"$f":"AD63+AL63","v":6597604},null,{"$f":"IF(AN63=0,\"0.0 \",ROUND((AH63/AN63)*100,1))","v":-1.3}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,"RATE FT-LARGE EXCLUDING RIDERS",null,{"$f":"X60","v":1737},null,{"$f":"Z63","v":3002186},null,null,null,{"$f":"SUM(AD60:AD63)","v":7344514},null,{"$f":"SUM(AF60:AF63)","v":99.6},null,{"$f":"SUM(AH60:AH63)","v":-86463},null,{"$f":"IF(AD65=0,\"0.0 \",ROUND((AH65/AD65)*100,1))","v":-1.2},null,null,null,{"$f":"SUM(AN60:AN63)","v":7344514},null,{"$f":"IF(AN65=0,\"0.0 \",ROUND((AH65/AN65)*100,1))","v":-1.2}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,null,"RIDERS:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,"PIPELINE MODERNIZATION MECHANISM (PMM)",null,null,null,null,null,{"$f":"CUR_FTL_PMM","v":1.0200000000000001E-2},null,{"$f":"ROUND(Z63*AB68,0)","v":30622},null,{"$f":"IF(AD$73=0,\"0.0 \",ROUND((AD68/AD$73)*100,1))","v":0.4},null,{"$f":"L30-AD68","v":0},null,{"$f":"IF(AD68=0,\"0.0 \",ROUND((AH68/AD68)*100,1))","v":0},null,null,null,{"$f":"AD68+AL68","v":30622},null,{"$f":"IF(AN68=0,\"0.0 \",ROUND((AH68/AN68)*100,1))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,null,"GAS COST ADJUSTMENT TRANSITION (GCAT)(2)",null,null,null,null,null,{"$f":"CUR_FTL_GCAT","v":3.6999999999999998E-2},null,null,null,{"$f":"IF(AD$73=0,\"0.0 \",ROUND((AD69/AD$73)*100,1))","v":0},null,{"$f":"L31-AD69","v":0},null,{"$f":"IF(AD69=0,\"0.0 \",ROUND((AH69/AD69)*100,1))","v":"0.0 "},null,{"$f":"ROUND(Z63*R38*AB69,0)","v":3332},null,{"$f":"AD69+AL69","v":3332},null,{"$f":"IF(AN69=0,\"0.0 \",ROUND((AH69/AN69)*100,1))","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,"TOTAL RIDERS",null,null,null,null,null,null,null,{"$f":"SUM(AD68:AD69)","v":30622},null,{"$f":"SUM(AF68:AF69)","v":0.4},null,{"$f":"SUM(AH68:AH69)","v":0},null,{"$f":"IF(AD71=0,\"0.0 \",ROUND((AH71/AD71)*100,1))","v":0},null,{"$f":"SUM(AL69:AL69)","v":3332},null,{"$f":"SUM(AN68:AN69)","v":33954},null,{"$f":"IF(AN71=0,\"0.0 \",ROUND((AH71/AN71)*100,1))","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,null,"TOTAL RATE FT - LARGE INCLUDING RIDERS",null,{"$f":"X60","v":1737},null,{"$f":"Z63","v":3002186},null,null,null,{"$f":"SUM(AD65+AD71)","v":7375136},null,{"$f":"SUM(AF65+AF71)","v":100},null,{"$f":"SUM(AH65+AH71)","v":-86463},null,{"$f":"IF(AD73=0,\"0.0 \",ROUND((AH73/AD73)*100,1))","v":-1.2},null,{"$f":"SUM(AL65+AL71)","v":3332},null,{"$f":"SUM(AN65+AN71)","v":7378468},null,{"$f":"IF(AN73=0,\"0.0 \",ROUND((AH73/AN73)*100,1))","v":-1.2}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(1) REFLECTS NORMALIZED VOLUMES."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"(2) GCAT only applies to FT-L customers during the first 12 months after they switch from sales service.  Usage for this rider estimated at \"&TEXT(R38,\"0%\")","v":"(2) GCAT only applies to FT-L customers during the first 12 months after they switch from sales service.  Usage for this rider estimated at 3%"}]

{"sheet":"Rate IT","index":11,"n_rows":74,"n_cols":42,"rows_kept":74,"cut":false,"hidden":false,"merged":[]}
[{"$f":"COMPANY","v":"DUKE ENERGY KENTUCKY"}]
[{"$f":"CASE","v":"CASE NO. 2025-00125"}]
["ANNUALIZED REVENUES AT PROPOSED VS. MOST CURRENT RATES"]
[{"$f":"TIME_PERIOD","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2026"}]
[{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE M-2.3"]
[{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PAGE  7  OF  7"]
["WORK PAPER REFERENCE NO(S).:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"B. L. Sailers"}]
["PROPOSED ANNUALIZED"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"PROPOSED",null,"% OF REV TO",null,null,null,"PROPOSED"]
[null,null,null,null,null,null,null,null,null,null,null,"REVENUE LESS",null,"TOTAL LESS",null,null,null,"TOTAL"]
["LINE",null,"RATE","CLASS /",null,"CUSTOMER",null,null,null,"PROPOSED",null,"GAS COST",null,"GAS COST",null,"GAS COST",null,"REVENUE"]
[" NO.",null,"CODE","DESCRIPTION",null,"BILLS",null,"SALES",null,"RATES",null,"REVENUE",null,"REVENUE",null,"REVENUE",null,"(F + H)"]
[null,null,"(A)","(B)",null,"(C)",null,"(D)",null,"(E)",null,"(F)",null,"(G)",null,"(H)",null,"(I)"]
[]
[null,null,null,null,null,null,null,"(MCF)",null,"($/MCF)",null,"($)",null,"(%)",null,"($)",null,"($)"]
[1,null,"IT"]
[2,null,"INTERRUPTIBLE TRANSPORTATION"]
[]
[3,null,"ADMINISTRATIVE CHARGE",null,null,226,null,null,null,{"$f":"PRO_IT_CUST","v":430},null,{"$f":"ROUND((F22*J22),0)","v":97180},null,{"$f":"ROUND((L22/L$34)*100,1)","v":4.8},null,null,null,{"$f":"L22+P22","v":97180}]
[]
[4,null,"COMMODITY CHARGE:"]
[5,null,"    ALL CONSUMPTION",null,null,null,null,1654919,null,{"$f":"PRO_IT_COM","v":1.1497999999999999},null,{"$f":"ROUND((H25*(J25)),0)","v":1902826},null,{"$f":"ROUND((L25/L$34)*100,1)","v":94.2},null,null,null,{"$f":"L25+P25","v":1902826}]
[]
[6,null,"RATE IT EXCLUDING RIDERS",null,null,{"$f":"F22","v":226},null,{"$f":"H25","v":1654919},null,null,null,{"$f":"SUM(L22:L25)","v":2000006},null,{"$f":"SUM(N22:N25)","v":99},null,null,null,{"$f":"SUM(R22:R25)","v":2000006}]
[]
[7,null,"RIDERS:"]
[8,null,"PIPELINE MODERNIZATION MECHANISM (PMM)",null,null,null,null,null,null,{"$f":"PRO_IT_PMM","v":1.15E-2},null,{"$f":"ROUND(H25*J30,0)","v":19032},null,{"$f":"ROUND((L30/L$34)*100,1)","v":0.9},null,null,null,{"$f":"L30+P30","v":19032}]
[]
[9,null,"TOTAL RIDERS",null,null,null,null,null,null,null,null,{"$f":"SUM(L29:L30)","v":19032},null,{"$f":"ROUND((L32/L$34)*100,1)","v":0.9},null,null,null,{"$f":"SUM(R29:R30)","v":19032}]
[]
[10,null,"TOTAL RATE IT TRANSPORTATION",null,null,{"$f":"F27","v":226},null,{"$f":"H27","v":1654919},null,null,null,{"$f":"L27+L32","v":2019038},null,{"$f":"ROUND((L34/L$34)*100,1)","v":100},null,null,null,{"$f":"R27+R32","v":2019038}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COMPANY","v":"DUKE ENERGY KENTUCKY"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CASE","v":"CASE NO. 2025-00125"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANNUALIZED TEST YEAR REVENUES AT PROPOSED VS. MOST CURRENT RATES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TIME_PERIOD","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2026"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE M-2.2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R7","v":"PAGE  7  OF  7"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WORK PAPER REFERENCE NO(S).:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"B. L. Sailers"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CURRENT ANNUALIZED"]
[]
[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,"CURRENT",null,"% OF REV TO",null,"REVENUE",null,"% INCR IN",null,null,null,"CURRENT",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,null,"MOST",null,"REVENUE LESS",null,"TOTAL LESS",null,"INCR LESS",null,"REV LESS ",null,null,null,"TOTAL",null,"REVENUE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LINE",null,"RATE","CLASS /","CUSTOMER",null,null,null,"CURRENT",null,"GAS COST",null,"GAS COST",null,"GAS COST REV",null,"GAS COST REV",null,"GAS COST",null,"REVENUE",null,"% INCREASE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," NO.",null,"CODE","DESCRIPTION","BILLS",null,"SALES",null,"RATES",null,"REVENUE(3)",null,"REVENUE",null,"(F - K)",null,"(M / K)",null,"REVENUE",null,"(K + H)",null,"(M / K1)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(A)","(B)","(C)",null,"(D)",null,"(J)",null,"(K)",null,"(L)",null,"(M)",null,"(N)",null,"(H)",null,"(K1)",null,"(O)"]
[]
[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,"(MCF)",null,"($/MCF)",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,1,null,"RATE IT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,"INTERRUPTIBLE TRANSPORTATION"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,"ADMINISTRATIVE CHARGE",null,{"$f":"F22","v":226},null,null,null,{"$f":"CUR_IT_CUST","v":430},null,{"$f":"ROUND(X62*AB62,0)","v":97180},null,{"$f":"ROUND((AD62/AD$74)*100,1)","v":4.9000000000000004},null,{"$f":"L22-AD62","v":0},null,{"$f":"IF(AD62=0,\"0.0 \",ROUND((AH62/AD62)*100,1))","v":0},null,null,null,{"$f":"AD62+AL62","v":97180},null,{"$f":"IF(AN62=0,\"0.0 \",ROUND((AH62/AN62)*100,1))","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,"COMMODITY CHARGE:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,"    ALL CONSUMPTION",null,null,null,{"$f":"H25","v":1654919},null,{"$f":"CUR_IT_COM","v":1.1300000000000001},null,{"$f":"ROUND(Z65*AB65,0)","v":1870058},null,{"$f":"ROUND((AD65/AD$74)*100,1)","v":94.1},null,{"$f":"L25-AD65","v":32768},null,{"$f":"IF(AD65=0,\"0.0 \",ROUND((AH65/AD65)*100,1))","v":1.8},null,null,null,{"$f":"AD65+AL65","v":1870058},null,{"$f":"IF(AN65=0,\"0.0 \",ROUND((AH65/AN65)*100,1))","v":1.8}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,"RATE IT EXCLUDING RIDERS",null,{"$f":"X62","v":226},null,{"$f":"Z65","v":1654919},null,null,null,{"$f":"SUM(AD62:AD65)","v":1967238},null,{"$f":"SUM(AF62:AF65)","v":99},null,{"$f":"L27-AD67","v":32768},null,{"$f":"IF(AD67=0,\"0.0 \",ROUND((AH67/AD67)*100,1))","v":1.7},null,null,null,{"$f":"SUM(AN62:AN65)","v":1967238},null,{"$f":"IF(AN67=0,\"0.0 \",ROUND((AH67/AN67)*100,1))","v":1.7}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,null,"RIDERS:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,"PIPELINE MODERNIZATION MECHANISM (PMM)",null,null,null,null,null,{"$f":"CUR_IT_PMM","v":1.15E-2},null,{"$f":"ROUND(Z65*AB70,0)","v":19032},null,{"$f":"ROUND((AD70/AD$74)*100,1)","v":1},null,{"$f":"L30-AD70","v":0},null,{"$f":"IF(AD70=0,\"0.0 \",ROUND((AH70/AD70)*100,1))","v":0},null,null,null,{"$f":"AD70+AL70","v":19032},null,{"$f":"IF(AN70=0,\"0.0 \",ROUND((AH70/AN70)*100,1))","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,null,"TOTAL RIDERS",null,null,null,null,null,null,null,{"$f":"SUM(AD69:AD70)","v":19032},null,{"$f":"ROUND((AD72/AD$74)*100,1)","v":1},null,{"$f":"L32-AD72","v":0},null,{"$f":"IF(AD72=0,\"0.0 \",ROUND((AH72/AD72)*100,1))","v":0},null,null,null,{"$f":"SUM(AN69:AN70)","v":19032},null,{"$f":"IF(AN72=0,\"0.0 \",ROUND((AH72/AN72)*100,1))","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,"TOTAL RATE IT TRANSPORTATION",null,{"$f":"X67","v":226},null,{"$f":"Z67","v":1654919},null,null,null,{"$f":"AD67+AD72","v":1986270},null,{"$f":"ROUND((AD74/AD$74)*100,1)","v":100},null,{"$f":"AH67+AH72","v":32768},null,{"$f":"IF(AD74=0,\"0.0 \",ROUND((AH74/AD74)*100,1))","v":1.6},null,null,null,{"$f":"AN67+AN72","v":1986270},null,{"$f":"IF(AN74=0,\"0.0 \",ROUND((AH74/AN74)*100,1))","v":1.6}]

{"sheet":"SCH N","index":12,"n_rows":104,"n_cols":14,"rows_kept":104,"cut":false,"hidden":false,"merged":[[0,0,0,13],[3,0,3,13],[4,0,4,13]]}
[{"$f":"COMPANY","v":"DUKE ENERGY KENTUCKY"}]
[{"$f":"CASE","v":"CASE NO. 2025-00125"}]
["EFFECTS OF PROPOSED RESIDENTIAL AND GENERAL SERVICE RATES"]
["TYPICAL BILL COMPARISON"]
[{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[]
[{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE N"]
[{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,"PAGE 1 OF 2"]
["WORK PAPER REFERENCE NO(S).: ",null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"B. L. Sailers"}]
[]
[]
[null,null,null,null,null," BILL DATA INCLUDING RIDERS LESS COST of GAS",null,null,null,null,null,"TOTAL","TOTAL"]
[null,null,null,"LEVEL","LEVEL",null,null,"DOLLAR","PERCENT",null,null,"CURRENT","PROPOSED","PERCENT"]
[null,null,null,"of","of","CURRENT","PROPOSED","INCREASE","INCREASE",null,"GAS","BILL","BILL","INCREASE"]
["LINE",null,"RATE","DEMAND","USE","BILL","BILL","(D - C)","(E / C)",null,"COST (1)","(C + G)","(D + G)","(I-H) /H"]
[" NO.",null,"CODE","(A)","(B)","(C)","(D)","(E)","(F)",null,"(G)","(H)","(I)","(L)"]
[null,null,null,null,"(MCF)","($)","($)","($)","(%)",null,"($)","($)","($)","(%)"]
[1,null,"(RS)"]
[2,null,"RESIDENTIAL","Not",1,{"$f":"ROUND(E20*(CUR_RS+CUR_RS_DSM+CUR_RS_PMM)+CUR_RS_CUST+CUR_RS_HEA,2)","v":24.26},{"$f":"ROUND(E20*(PRO_RS_COM+PRO_RS_DSM+PRO_RS_PMM)+PRO_RS_CUST+PRO_RS_HEA,2)","v":28.55},{"$f":"G20-F20","v":4.2899999999999991},{"$f":"ROUND(H20/F20,3)*100","v":17.7},null,{"$f":"ROUND(E20*EGC,2)","v":6.7},{"$f":"F20+K20","v":30.96},{"$f":"G20+K20","v":35.25},{"$f":"ROUND((M20-L20)/L20,3)*100","v":13.900000000000002}]
[3,null,null,"Applicable",3,37.18,45.06,{"$f":"G21-F21","v":7.8800000000000026},21.2,null,{"$f":"ROUND(E21*EGC,2)","v":20.100000000000001},{"$f":"F21+K21","v":57.28},{"$f":"G21+K21","v":65.16},{"$f":"ROUND((M21-L21)/L21,3)*100","v":13.8}]
[4,null,null,null,6,56.56,69.83,13.269999999999996,23.5,null,40.19,{"$f":"F22+K22","v":96.75},110.02,13.700000000000001]
[5,null,null,null,8,69.48,86.34,16.86,24.3,null,53.59,{"$f":"F23+K23","v":123.07000000000001},139.93,13.700000000000001]
[6,null,null,null,10,82.4,102.85,20.449999999999989,24.8,null,66.989999999999995,{"$f":"F24+K24","v":149.38999999999999},169.83999999999997,13.700000000000001]
[7,null,null,null,12,95.32,119.36,24.040000000000006,25.2,null,80.39,{"$f":"F25+K25","v":175.70999999999998},199.75,13.700000000000001]
[8,null,null,null,16,121.16,152.38,31.22,25.8,null,107.19,228.35,259.57,13.700000000000001]
[9,null,null,null,20,147,185.4,38.400000000000006,26.1,null,133.97999999999999,280.98,319.38,13.700000000000001]
[10,null,null,null,30,211.6,267.95,56.349999999999994,26.6,null,200.97,412.57,468.91999999999996,13.700000000000001]
[11,null,null,null,40,276.2,350.5,74.300000000000011,26.900000000000002,null,267.95999999999998,544.16,618.46,13.700000000000001]
[12,null,null,null,50,340.79,433.04,92.25,27.1,null,334.96,675.75,768,13.700000000000001]
[13,null,null,null,60,405.39,515.59,110.20000000000005,27.200000000000003,null,401.95,807.33999999999992,917.54,13.600000000000001]
[14,null,null,null,80,534.59,680.69,146.10000000000002,27.3,null,535.92999999999995,1070.52,1216.6199999999999,13.600000000000001]
[15,null,null,null,100,663.79,845.79,182,27.400000000000002,null,669.91,1333.6999999999998,1515.6999999999998,13.600000000000001]
[]
[16,null,"(GS)"]
[17,null,"NON-RESIDENTIAL",null,5,{"$f":"ROUND(E36*(CUR_GS+CUR_GS_PMM)+CUR_GS_CUST,2)","v":78.22},{"$f":"ROUND(E36*(+PRO_GS+PRO_GS_PMM)+PRO_GS_CUST,2)","v":94.34},{"$f":"G36-F36","v":16.120000000000005},{"$f":"ROUND(H36/F36,3)*100","v":20.599999999999998},null,{"$f":"ROUND(E36*EGC,2)","v":33.5},{"$f":"F36+K36","v":111.72},{"$f":"G36+K36","v":127.84},{"$f":"ROUND((M36-L36)/L36,3)*100","v":14.399999999999999}]
[18,null,null,null,10,98.44,123.68,25.240000000000009,25.6,null,66.989999999999995,165.43,190.67000000000002,15.299999999999999]
[19,null,null,null,20,138.88999999999999,182.36,43.470000000000027,31.3,null,133.97999999999999,272.87,316.34000000000003,15.9]
[20,null,null,null,40,219.77,299.72000000000003,79.950000000000017,36.4,null,267.95999999999998,487.73,567.68000000000006,16.400000000000002]
[21,null,null,null,50,260.22000000000003,358.41,98.19,37.700000000000003,null,334.96,595.18000000000006,693.37,16.5]
[22,null,null,null,100,462.43,651.80999999999995,189.37999999999994,41,null,669.91,1132.3399999999999,1321.7199999999998,16.7]
[23,null,null,null,300,1271.29,1825.43,554.1400000000001,43.6,null,2009.73,3281.02,3835.16,16.900000000000002]
[24,null,null,null,500,2080.15,2999.05,918.90000000000009,44.2,null,3349.55,5429.7000000000007,6348.6,16.900000000000002]
[25,null,null,null,700,2889.01,4172.67,1283.6599999999999,44.4,null,4689.37,7578.38,8862.0400000000009,16.900000000000002]
[26,null,null,null,850,3495.66,5052.8900000000003,1557.2300000000005,44.5,null,5694.24,9189.9,10747.130000000001,16.900000000000002]
[27,null,null,null,1000,4102.3,5933.1,1830.8000000000002,44.6,null,6699.1,10801.400000000001,12632.2,16.900000000000002]
[28,null,null,null,2000,8146.6,11801.2,3654.6000000000004,44.9,null,13398.2,21544.800000000003,25199.4,17]
[29,null,null,null,3000,12190.9,17669.3,5478.4,44.9,null,20097.3,32288.199999999997,37766.6,17]
[]
[]
[null,null,{"$f":"\"(1) REFLECTS AVERAGE EXPECTED GAS COST OF \"&TEXT(EGC,\"$0.000\")&\"/MCF.\"","v":"(1) REFLECTS AVERAGE EXPECTED GAS COST OF $6.699/MCF."}]
[]
[]
[{"$f":"COMPANY","v":"DUKE ENERGY KENTUCKY"}]
[{"$f":"CASE","v":"CASE NO. 2025-00125"}]
["EFFECTS OF PROPOSED FIRM TRANSPORTATION-LARGE RATES"]
["AND INTERRUPTIBLE TRANSPORTATION RATES ON TYPICAL CUSTOMER BILLS"]
[{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[]
[{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE N"]
[{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,null,"PAGE 2 OF 2"]
["WORK PAPER REFERENCE NO(S).: ",null,null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"B. L. Sailers"}]
[]
[]
[null,null,null,null,null," BILL DATA INCLUDING RIDERS LESS COST of GAS",null,null,null,null,null,"TOTAL","TOTAL"]
[null,null,null,"LEVEL","LEVEL",null,null,"DOLLAR","PERCENT",null,null,"CURRENT","PROPOSED","PERCENT"]
[null,null,null,"of","of","CURRENT","PROPOSED","INCREASE","INCREASE",null,"GAS","BILL","BILL","INCREASE"]
["LINE",null,"RATE","DEMAND","USE","BILL","BILL","(D - C)","(E / C)",null,"COST (1)","(C + G)","(D + G)","(I-H) /H"]
[" NO.",null,"CODE","(A)","(B)","(C)","(D)","(E)","(F)",null,"(G)","(H)","(I)","(L)"]
[null,null,null,null,"(MCF)","($)","($)","($)","(%)",null,"($)","($)","($)","(%)"]
[null,null,null,null,"(MCF)","($)","($)","($)","(%)",null,"($)","($)","($)","(%)"]
[]
[1,null,"(FT-L)","Not"]
[2,null,"FIRM","Applicable",1000,{"$f":"ROUND(E75*(CUR_FTL_COM+CUR_FTL_PMM),2)+CUR_FTL_CUST","v":2637.8},{"$f":"ROUND(E75*(PRO_FTL_COM+PRO_FTL_PMM),2)+PRO_FTL_CUST","v":2609},{"$f":"+G75-F75","v":-28.800000000000182},{"$f":"ROUND(H75/F75,3)*100","v":-1.0999999999999999},null,{"$f":"ROUND(E75*PRO_FTL_GCAT,2)","v":37},{"$f":"F75+K75","v":2674.8},{"$f":"G75+K75","v":2646},{"$f":"ROUND((M75-L75)/L75,3)*100","v":-1.0999999999999999}]
[3,null,"TRANSPORTATION",null,1500,3741.7,3698.5,{"$f":"+G76-F76","v":-43.199999999999818},-1.2,null,55.5,{"$f":"F76+K76","v":3797.2},{"$f":"G76+K76","v":3754},{"$f":"ROUND((M76-L76)/L76,3)*100","v":-1.0999999999999999}]
[4,null,null,null,2000,4845.6000000000004,4788,-57.600000000000364,-1.2,null,74,4919.6000000000004,4862,-1.2]
[5,null,null,null,3000,7053.4,6967,-86.399999999999636,-1.2,null,111,7164.4,7078,-1.2]
[6,null,null,null,5000,11469,11325,-144,-1.3,null,185,11654,11510,-1.2]
[7,null,null,null,10000,22508,22220,-288,-1.3,null,370,22878,22590,-1.3]
[8,null,null,null,20000,44586,44010,-576,-1.3,null,740,45326,44750,-1.3]
[9,null,null,null,30000,66664,65800,-864,-1.3,null,1110,67774,66910,-1.3]
[10,null,null,null,40000,88742,87590,-1152,-1.3,null,1480,90222,89070,-1.3]
[11,null,null,null,50000,110820,109380,-1440,-1.3,null,1850,112670,111230,-1.3]
[12,null,null,null,75000,166015,163855,-2160,-1.3,null,2775,168790,166630,-1.3]
[13,null,null,null,100000,221210,218330,-2880,-1.3,null,3700,224910,222030,-1.3]
[14,null,null,null,150000,331600,327280,-4320,-1.3,null,5550,337150,332830,-1.3]
[15,null,null,null,200000,441990,436230,-5760,-1.3,null,7400,449390,443630,-1.3]
[]
[16,null,"(IT)","Not"]
[17,null,"INTERRUPTIBLE","Applicable",2000,{"$f":"ROUND(E91*(CUR_IT_COM+CUR_IT_PMM),2)+CUR_IT_CUST","v":2713},{"$f":"ROUND(E91*(PRO_IT_COM+PRO_IT_PMM),2)+PRO_IT_CUST","v":2752.6},{"$f":"+G91-F91","v":39.599999999999909},{"$f":"ROUND(H91/F91,3)*100","v":1.5},null,0,{"$f":"F91+K91","v":2713},{"$f":"G91+K91","v":2752.6},{"$f":"ROUND((M91-L91)/L91,3)*100","v":1.5}]
[18,null,"TRANSPORTATION",null,5000,6137.5,6236.5,{"$f":"+G92-F92","v":99},{"$f":"ROUND(H92/F92,3)*100","v":1.6},null,0,{"$f":"F92+K92","v":6137.5},{"$f":"G92+K92","v":6236.5},{"$f":"ROUND((M92-L92)/L92,3)*100","v":1.6}]
[19,null,null,null,10000,11845,12043,198,1.7000000000000002,null,0,11845,12043,1.7000000000000002]
[20,null,null,null,15000,17552.5,17849.5,297,1.7000000000000002,null,0,17552.5,17849.5,1.7000000000000002]
[21,null,null,null,20000,23260,23656,396,1.7000000000000002,null,0,23260,23656,1.7000000000000002]
[22,null,null,null,25000,28967.5,29462.5,495,1.7000000000000002,null,0,28967.5,29462.5,1.7000000000000002]
[23,null,null,null,30000,34675,35269,594,1.7000000000000002,null,0,34675,35269,1.7000000000000002]
[24,null,null,null,40000,46090,46882,792,1.7000000000000002,null,0,46090,46882,1.7000000000000002]
[25,null,null,null,50000,57505,58495,990,1.7000000000000002,null,0,57505,58495,1.7000000000000002]
[26,null,null,null,100000,114580,116560,1980,1.7000000000000002,null,0,114580,116560,1.7000000000000002]
[27,null,null,null,200000,228730,232690,3960,1.7000000000000002,null,0,228730,232690,1.7000000000000002]
[28,null,null,null,300000,342880,348820,5940,1.7000000000000002,null,0,342880,348820,1.7000000000000002]
[]
[null,null,{"$f":"\"(1) INCLUDES CURRENT RIDER GCAT OF \"&TEXT(CUR_FTL_GCAT,\"$0.000_);($0.000)\")&\"/MCF\"","v":"(1) INCLUDES CURRENT RIDER GCAT OF $0.037 /MCF"}]

{"sheet":"Revenue Requirements","index":13,"n_rows":29,"n_cols":15,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["REVENUE REQUIREMENTS FROM COST OF SERVICE STUDY"]
[]
[null,{"$f":"COMPANY","v":"DUKE ENERGY KENTUCKY"},null,null,null,null,{"$f":"B3","v":"DUKE ENERGY KENTUCKY"}]
[null,{"$f":"CASE","v":"CASE NO. 2025-00125"},null,null,null,null,{"$f":"B4","v":"CASE NO. 2025-00125"},null,null,null,null,null,"Comparison of Schedule M Calculated Proposed Revenues"]
[null,"SCHEDULE M - CURRENT RATE REVENUES",null,null,null,null,"COST OF SERVICE STUDY",null,null,null,null,null,"Less COS Revenue Requirement"]
[null,"No Riders - With Fuel",null,null,null,null,"Proposed Revenue Requirements",null,null,null,null,null,{"$f":"B4","v":"CASE NO. 2025-00125"}]
[null,null,null,null,null,null,{"$f":"B4","v":"CASE NO. 2025-00125"}]
[]
[null,null,"Customer Bills","Current Rate Revenues - No Riders - Including Fuel",null,null,"Rate","Customer Component RRs","COS - no riders - includes fuel and FAC","% Change","Increase",null,"Rate","+ value is high & - value is low"]
[null,"RS",{"$f":"'Rate RS'!X66","v":1194296},94137279,null,null,{"$f":"B10","v":"RS"},37108280,108126909,{"$f":"(I10-D10)/D10","v":0.14860882052900637},{"$f":"I10-D10","v":13989630},null,{"$f":"G10","v":"RS"},{"$f":"'Proposed Rates'!C21","v":219}]
[null,"GS",{"$f":"'Rate GS COM'!F24+'Rate GS IND'!F24+'Rate GS OPA'!F24","v":86505},40621911,null,null,{"$f":"B11","v":"GS"},5962220,47503533,{"$f":"(I11-(D11+D17))/(D11+D17)","v":0.167973925679749},{"$f":"I11-D11-D17","v":6831792},null,{"$f":"G11","v":"GS"},{"$f":"'Rate GS COM'!R29+'Rate GS IND'!R29+'Rate GS OPA'!R29-'Revenue Requirements'!I11","v":-58217},"This is from ID; Have to track that through the process since it's in other revenues"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Don't eliminate twice"]
[]
[null,"FT-Large",{"$f":"'Rate FT-LG'!F22","v":1737},7347846,null,null,"FT-Large",422061,8115946,{"$f":"(I14-D14)/D14","v":0.10453403623320358},{"$f":"I14-D14","v":768100},null,"FT-Large",{"$f":"'Proposed Rates'!K23","v":36}]
[null,"IT",{"$f":"'Rate IT'!F22","v":226},1967238,null,null,"IT",101909,2000226,1.6768687876098368E-2,32988,null,"IT",{"$f":"'Proposed Rates'!O21","v":-220}]
[null,null,null,null,null,null,"Additional FT for Min use",null,{"$f":"-'Proposed Rates'!L19","v":-854599}]
[null,"ID",null,{"$f":"'SCH M-2.2'!V41","v":49830},null,null,"Remove ID since in GS and Other",null,{"$f":"-'SCH M-2.3'!R41","v":-58200},{"$f":"(-I17/D17)-1","v":0.16797110174593621},null,null,"Total",{"$f":"SUM(N10:N15)","v":-58182},"Should = ID or very close"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I17","v":-58200},"ID"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N17-N18","v":18},"Check Value"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"OTHER - less ID",null,1087776,null,null,"OTHER",null,{"$f":"+'SCH M-2.3'!R46","v":2002500},{"$f":"(I28-D28)/D28","v":0.84091209954990731}]
[null,"TOTAL",{"$f":"SUM(C10:C28)","v":1282764},{"$f":"SUM(D10:D28)","v":145211880},null,null,"TOTAL",{"$f":"SUM(H10:H28)","v":43594470},{"$f":"SUM(I10:I28)","v":166836315},{"$f":"(I29-D29)/D29","v":0.14891643163080046},{"$f":"I29-D29","v":21624435}]

{"sheet":"Proposed Rates","index":14,"n_rows":40,"n_cols":15,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["PROPOSED RATE CALCULATIONS"]
[null,{"$f":"COMPANY","v":"DUKE ENERGY KENTUCKY"},null,null,null,{"$f":"COMPANY","v":"DUKE ENERGY KENTUCKY"},null,null,null,{"$f":"COMPANY","v":"DUKE ENERGY KENTUCKY"},null,null,null,{"$f":"COMPANY","v":"DUKE ENERGY KENTUCKY"}]
[null,{"$f":"CASE","v":"CASE NO. 2025-00125"},null,null,null,{"$f":"CASE","v":"CASE NO. 2025-00125"},null,null,null,{"$f":"CASE","v":"CASE NO. 2025-00125"},null,null,null,{"$f":"CASE","v":"CASE NO. 2025-00125"}]
[null,"PROPOSED RATE CALCULATION",null,null,null,"PROPOSED RATE CALCULATION",null,null,null,"PROPOSED RATE CALCULATION",null,null,null,"PROPOSED RATE CALCULATION"]
[null,"Rate:  RS",null,null,null,"Rate:  GS",null,null,null,"Rate:  FT-Large",null,null,null,"Rate:  IT"]
[null,null,"Test Period",null,null,null,"Test Period",null,null,null,"Test Period"]
[null,"Customer Bills",{"$f":"'Rate RS'!F24","v":1194296},null,null,"Customer Bills",{"$f":"'Rate GS COM'!F24+'Rate GS IND'!F24+'Rate GS OPA'!F24","v":86505},null,null,"Customer Bills",{"$f":"'Rate FT-LG'!F22","v":1737},null,null,"Customer Bills",{"$f":"'Rate IT'!F22","v":226}]
[null,"COSS - RS Customer Component",{"$f":"'Revenue Requirements'!H10","v":37108280},null,null,"COSS - GS Customer Component",{"$f":"'Revenue Requirements'!H11+'Revenue Requirements'!H12+'Revenue Requirements'!H13","v":5962220},null,null,"COSS - FT-L Customer Component",{"$f":"'Revenue Requirements'!H14","v":422061},null,null,"COSS - IT Customer Component",{"$f":"'Revenue Requirements'!H15","v":101909}]
[null,"COSS Customer Charge",{"$f":"ROUND(C8/C7,2)","v":31.07},null,null,"COSS Customer Charge",{"$f":"ROUND(G8/G7,2)","v":68.92},null,null,"COSS Customer Charge",{"$f":"ROUND(K8/K7,2)","v":242.98},null,null,"COSS Customer Charge",{"$f":"ROUND(O8/O7,2)","v":450.92}]
[null,"Current Customer Charge",{"$f":"CUR_RS_CUST","v":17.5},{"$f":"C10*(1+'Revenue Requirements'!J10)","v":20.100654359257611},null,"Current Customer Charge",{"$f":"CUR_GS_CUST","v":58},null,null,"Current Customer Charge",{"$f":"CUR_FTL_CUST","v":430},null,null,"Current Customer Charge",{"$f":"CUR_IT_CUST","v":430}]
[null,"Gap",{"$f":"C9-C10","v":13.57},null,null,"Gap",{"$f":"G9-G10","v":10.920000000000002},null,null,"Gap",{"$f":"K9-K10","v":-187.02},null,null,"Gap",{"$f":"O9-O10","v":20.920000000000016}]
[null,"Migration @ % of Justified",{"$f":"ROUND(C11*$C$29,2)","v":6.79},null,null,"Migration @ % of Justified",{"$f":"ROUND(G11*$C$29,2)","v":5.46},null,null,"Migration @ % of Justified",{"$f":"ROUND(K11*$C$29,2)","v":-93.51},null,null,"Migration @ % of Justified",{"$f":"ROUND(O11*$C$29,2)","v":10.46}]
[null,"Customer Charge at % Migration to COSS",{"$f":"C10+C12","v":24.29},null,null,"Customer Charge at % Migration to COSS",{"$f":"G10+G12","v":63.46},null,null,"Customer Charge at % Migration to COSS",{"$f":"K10+K12","v":336.49},null,null,"Customer Charge at % Migration to COSS",{"$f":"O10+O12","v":440.46}]
[null,"Proposed Customer Charge",20,null,null,"Proposed Customer Charge",65,null,null,"Proposed Customer Charge",430,null,null,"Proposed Customer Charge",430]
[null,"Proposed Customer Charge Revenues",{"$f":"'Rate RS'!R24","v":23885920},null,null,"Proposed Customer Charge Revenues",{"$f":"'Rate GS COM'!R24+'Rate GS IND'!R24+'Rate GS OPA'!R24","v":5622825},null,null,"Proposed Customer Charge Revenues",{"$f":"'Rate FT-LG'!R22","v":746910},null,null,"Proposed Customer Charge Revenues",{"$f":"'Rate IT'!R22","v":97180}]
[]
[null,"COSS - RS Revenue Requirement",{"$f":"'Revenue Requirements'!I10","v":108126909},null,null,"COSS - GS Revenue Requirement",{"$f":"SUM('Revenue Requirements'!I11:I13)","v":47503533},null,null,"COSS - FT-L Revenue Requirement",{"$f":"'Revenue Requirements'!I14","v":8115946},null,null,"COSS - IT Revenue Requirement",{"$f":"'Revenue Requirements'!I15","v":2000226}]
[null,"Less Proposed Customer Charge Revenues Less GCA",{"$f":"C17-C15-'Rate RS'!P29","v":43172672},null,null,"Less Proposed Customer Charge Revenues Less GCA",{"$f":"G17-G15-'Rate GS COM'!P27-'Rate GS IND'!P27-'Rate GS OPA'!P27","v":19041507},null,null,"Less Proposed Customer Charge Revenues Less GCA/GCAT",{"$f":"K17-K15-'Rate FT-LG'!P25-'Rate FT-LG'!P31","v":7365704},null,null,"Less Proposed Customer Charge Revenues Less GCA",{"$f":"O17-O15-'Rate IT'!P25","v":1903046}]
[null,"Test Period MCF",{"$f":"'Rate RS'!H27","v":6130423},null,null,"Interdeptartmental",{"$f":"+G30","v":58200},null,null,"Change in Min Amazon",{"$f":"L19","v":854599},{"$f":"1532059-'SCH M-2.2'!V42","v":854599},null,"Test Period MCF",{"$f":"'Rate IT'!H25","v":1654919}]
[null,"Proposed Delivery Charge",{"$f":"ROUND(C18/C19,4)+0","v":7.0423999999999998},null,null,"GS Rev Requirement",{"$f":"+G18-G19","v":18983307},null,null,"FT-L Rev Requirement",{"$f":"+K18-K19","v":6511105},null,null,"Proposed Energy Charge",{"$f":"ROUND(O18/O19,4)-0.0001","v":1.1497999999999999}]
[null,"Check to Revenue Requirements",{"$f":"'Rate RS'!R29-C17","v":219},null,null,"Test Period MCF",{"$f":"'Rate GS COM'!H27+'Rate GS IND'!H27+'Rate GS OPA'!H27","v":3409294},null,null,"Test Period MCF",{"$f":"'Rate FT-LG'!H25","v":3002186},null,null,"Check to Revenue Requirements",{"$f":"'Rate IT'!R27-O17","v":-220}]
[null,null,null,null,null,"Proposed Energy Charge",{"$f":"ROUND(G20/G21,4)-0","v":5.5681000000000003},null,null,"Proposed Energy Charge",{"$f":"ROUND(K20/K21,4)-0","v":2.1688000000000001}]
[null,null,null,null,null,"Check to Revenue Requirements",{"$f":"'Rate GS COM'!R29+'Rate GS IND'!R29+'Rate GS OPA'!R29-G17+G30","v":-17},null,null,"Check to Revenue Requirements",{"$f":"'Rate FT-LG'!R27-K20-K15","v":36}]
[]
[]
[]
[null,null,null,null,null,"Current Interdept Rev",{"$f":"+'SCH M-2.2'!V41","v":49830}]
[null,null,null,null,null,"GS Increase %",0.16797000000000001]
[null,"Migration Percentage",0.5,null,null,"Interdept Increase",{"$f":"ROUND(+G27*G28,0)","v":8370}]
[null,null,null,null,null,"Proposed Intdept Rev",{"$f":"+G27+G29","v":58200}]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"+'SCH M'!G50","v":175700142}]
[null,null,126681928]
[null,null,{"$f":"+C38-C39","v":49018214}]

{"sheet":"Avg Incr","index":15,"n_rows":24,"n_cols":11,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null," BILL DATA INCLUDING RIDERS LESS COST of GAS",null,null,null,null,"TOTAL","TOTAL"]
[null,null,null,null,null,"DOLLAR","PERCENT",null,"CURRENT","PROPOSED","PERCENT"]
[null,"Average","Average","CURRENT","PROPOSED","INCREASE","INCREASE","GAS","BILL","BILL","INCREASE"]
["RATE","USE","USE","BILL","BILL","(D - C)","(E / C)","COST (1)","(C + G)","(D + G)","(I-H) /H"]
["CODE","(B)","(B)","(C)","(D)","(E)","(F)","(G)","(H)","(I)","(L)"]
[null,"(CCF)","(MCF)","($)","($)","($)","(%)","($)","($)","($)","(%)"]
[]
["RS",{"$f":"+C9*10","v":51},{"$f":"ROUND(+'Rate RS'!H27/'Rate RS'!F24,1)","v":5.0999999999999996},{"$f":"ROUND(C9*(CUR_RS+CUR_RS_DSM+CUR_RS_PMM)+CUR_RS_CUST+CUR_RS_HEA,2)","v":50.75},{"$f":"ROUND(C9*(PRO_RS_COM+PRO_RS_DSM+PRO_RS_PMM)+PRO_RS_CUST+PRO_RS_HEA,2)","v":62.4},{"$f":"E9-D9","v":11.649999999999999},{"$f":"ROUND(F9/D9,3)*100","v":23},{"$f":"ROUND(C9*EGC,2)","v":34.17},{"$f":"D9+H9","v":84.92},{"$f":"E9+H9","v":96.57},{"$f":"ROUND((J9-I9)/I9,3)","v":0.13700000000000001}]
["GS-Comm",{"$f":"+C10*10","v":363},{"$f":"ROUND('Rate GS COM'!H27/'Rate GS COM'!F24,1)","v":36.299999999999997},{"$f":"ROUND(C10*(CUR_GS+CUR_GS_PMM)+CUR_GS_CUST,2)","v":204.81},{"$f":"ROUND(C10*(+PRO_GS+PRO_GS_PMM)+PRO_GS_CUST,2)","v":278.01},{"$f":"E10-D10","v":73.199999999999989},{"$f":"ROUND(F10/D10,3)*100","v":35.699999999999996},{"$f":"ROUND(C10*EGC,2)","v":243.18},{"$f":"D10+H10","v":447.99},{"$f":"E10+H10","v":521.19000000000005},{"$f":"ROUND((J10-I10)/I10,3)","v":0.16300000000000001}]
["GS-Ind",1005,{"$f":"ROUND('Rate GS IND'!H27/'Rate GS IND'!F24,1)","v":100.5},{"$f":"ROUND(C11*(CUR_GS+CUR_GS_PMM)+CUR_GS_CUST,2)","v":464.45},{"$f":"ROUND(C11*(+PRO_GS+PRO_GS_PMM)+PRO_GS_CUST,2)","v":654.74},{"$f":"E11-D11","v":190.29000000000002},{"$f":"ROUND(F11/D11,3)*100","v":41},{"$f":"ROUND(C11*EGC,2)","v":673.26},{"$f":"D11+H11","v":1137.71},{"$f":"E11+H11","v":1328},0.16700000000000001]
["GS-OPA",749,{"$f":"ROUND('Rate GS OPA'!H27/'Rate GS OPA'!F24,1)","v":74.900000000000006},{"$f":"ROUND(C12*(CUR_GS+CUR_GS_PMM)+CUR_GS_CUST,2)","v":360.92},{"$f":"ROUND(C12*(+PRO_GS+PRO_GS_PMM)+PRO_GS_CUST,2)","v":504.52},143.59999999999997,39.800000000000004,{"$f":"ROUND(C12*EGC,2)","v":501.76},{"$f":"D12+H12","v":862.68000000000006},{"$f":"E12+H12","v":1006.28},0.16600000000000001]
["FT-L",16596,{"$f":"ROUND('Rate FT-LG'!H25/('Rate FT-LG'!F22+72),1)","v":1659.6},{"$f":"ROUND(C13*(CUR_FTL_COM+CUR_FTL_GCAT+CUR_FTL_PMM),2)+CUR_FTL_CUST","v":4155.4699999999993},{"$f":"ROUND(C13*(PRO_FTL_COM+PRO_FTL_GCAT+PRO_FTL_PMM),2)+PRO_FTL_CUST","v":4107.67},{"$f":"E13-D13","v":-47.799999999999272},{"$f":"ROUND(F13/D13,3)*100","v":-1.2},0,{"$f":"D13+H13","v":4155.4699999999993},{"$f":"E13+H13","v":4107.67},-1.2E-2]
["IT",73227,{"$f":"ROUND('Rate IT'!H25/'Rate IT'!F22,1)","v":7322.7},{"$f":"ROUND(C14*(CUR_IT_COM+CUR_IT_PMM),2)+CUR_IT_CUST","v":8788.86},{"$f":"ROUND(C14*(PRO_IT_COM+PRO_IT_PMM),2)+PRO_IT_CUST","v":8933.85},{"$f":"E14-D14","v":144.98999999999978},{"$f":"ROUND(F14/D14,3)*100","v":1.6},0,8788.86,8933.85,1.6E-2]
[]
["IMBS",{"$f":"+B13+B14","v":89823},{"$f":"+C13+C14","v":8982.2999999999993},{"$f":"ROUND(C16*B23,2)","v":1226.98},{"$f":"ROUND(C16*B24,2)","v":3516.57},{"$f":"E16-D16","v":2289.59},{"$f":"ROUND(F16/D16,3)*100","v":186.60000000000002},0,{"$f":"D16+H16","v":1226.98},{"$f":"E16+H16","v":3516.57},{"$f":"ROUND((J16-I16)/I16,3)","v":1.8660000000000001}]
[]
[]
[]
[]
[]
["IMBS"]
["Current Rate",0.1366,"/mcf"]
["Proposed Rate",0.39150000000000001,"/mcf"]