{"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":4,"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":21},"$ per Month"]
[null,"     Delivery Rate",5.2473999999999998,{"$f":"'Proposed Rates'!C20","v":7.3613},"$ 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.9279999999999999},"$ 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.2770000000000001},"$ 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.1878},"$ 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":119067782},null,{"$f":"G21-E21","v":17139137},null,{"$f":"IF(E21=0,\"0.00%\",ROUND(I21/E21,4))","v":0.1681}]
[3,null,"TOTAL RS",null,{"$f":"E21","v":101928645},null,{"$f":"G21","v":119067782},null,{"$f":"I21","v":17139137},null,{"$f":"IF(E22=0,\"0.00%\",ROUND(I22/E22,4))","v":0.1681}]
[]
[4,null,"GS COMMERCIAL",null,{"$f":"'Rate GS COM'!AN79","v":36273066},null,{"$f":"'Rate GS COM'!R38","v":43258329},null,{"$f":"G24-E24","v":6985263},null,{"$f":"IF(E24=0,\"0.00%\",ROUND(I24/E24,4))","v":0.19259999999999999}]
[5,null,"GS INDUSTRIAL",null,{"$f":"'Rate GS IND'!AN84","v":2328697},null,{"$f":"'Rate GS IND'!R38","v":2792224},null,{"$f":"G25-E25","v":463527},null,{"$f":"IF(E25=0,\"0.00%\",ROUND(I25/E25,4))","v":0.19900000000000001}]
[6,null,"GS OTHER PUB AUTH",null,{"$f":"'Rate GS OPA'!AN81","v":3042937},null,{"$f":"'Rate GS OPA'!R38","v":3644556},null,{"$f":"G26-E26","v":601619},null,{"$f":"IF(E26=0,\"0.00%\",ROUND(I26/E26,4))","v":0.19769999999999999}]
[7,null,"TOTAL GS",null,{"$f":"SUM(E24:E26)","v":41644700},null,{"$f":"SUM(G24:G26)","v":49695109},null,{"$f":"SUM(I24:I26)","v":8050409},null,{"$f":"IF(E27=0,\"0.00%\",ROUND(I27/E27,4))","v":0.1933}]
[]
[8,null,"     TOTAL SALES SERVICE",null,{"$f":"E22+E27","v":143573345},null,{"$f":"G22+G27","v":168762891},null,{"$f":"I22+I27","v":25189546},null,{"$f":"IF(E29=0,\"0.00%\",ROUND(I29/E29,4))","v":0.1754}]
[]
[9,null,"TRANSPORTATION:"]
[]
[10,null,"FT LARGE",null,{"$f":"'Rate FT-LG'!AN73","v":7378468},null,{"$f":"'Rate FT-LG'!R35","v":7616842},null,{"$f":"G33-E33","v":238374},null,{"$f":"IF(E33=0,\"0.00%\",ROUND(I33/E33,4))","v":3.2300000000000002E-2}]
[11,null,"IT",null,{"$f":"'Rate IT'!AN74","v":1986270},null,{"$f":"'Rate IT'!R34","v":2081925},null,{"$f":"G34-E34","v":95655},null,{"$f":"IF(E34=0,\"0.00%\",ROUND(I34/E34,4))","v":4.82E-2}]
[12,null,"     TOTAL TRANSPORTATION",null,{"$f":"SUM(E33:E34)","v":9364738},null,{"$f":"SUM(G33:G34)","v":9698767},null,{"$f":"SUM(I33:I34)","v":334029},null,{"$f":"IF(E35=0,\"0.00%\",ROUND(I35/E35,4))","v":3.5700000000000003E-2}]
[13,null,"TOTAL THROUGHPUT",null,{"$f":"E35+E29","v":152938083},null,{"$f":"G35+G29","v":178461658},null,{"$f":"I35+I29","v":25523575},null,{"$f":"IF(E36=0,\"0.00%\",ROUND(I36/E36,4))","v":0.16689999999999999}]
[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":59705},null,9875,null,0.19819999999999999]
[20,null,"SPECIAL CONTRACTS",null,{"$f":"'SCH M-2.2'!V42","v":677460},null,{"$f":"'SCH M-2.3'!R42","v":1529450},null,851990,null,1.2576000000000001]
[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":2001396},null,{"$f":"SUM(I39:I47)","v":863790},null,0.75929999999999997]
[]
[25,null,"TOTAL COMPANY REVENUE",null,{"$f":"E29+E35+E48","v":154075689},null,{"$f":"G29+G35+G48","v":180463054},null,{"$f":"I29+I35+I48","v":26387365},null,{"$f":"IF(I50=0,\"0.00%\",ROUND(I50/E50,4))","v":0.17130000000000001}]

{"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.53},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))+0.01","v":66.160000000000011}]
[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,{"$f":"IF(ABS(R20/$R$34*100)<0.005,\"-\",ROUND(R20/$R$34*100,2))+0.01","v":23.55}]
[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,{"$f":"IF(ABS(R21/$R$34*100)<0.005,\"-\",ROUND(R21/$R$34*100,2))","v":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":100},null,{"$f":"SUM(P19:P33)","v":63938075},null,{"$f":"SUM(R19:R33)","v":154075689},null,{"$f":"SUM(T19:T33)","v":100.00000000000004}]
[]
[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":17139137},null,{"$f":"IF(L20=0,\"0.0 \",ROUND((P20/L20)*100,1))","v":28.2},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":16.8}]
[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":17139137},null,{"$f":"IF(L21=0,\"0.0 \",ROUND((P21/L21)*100,1))","v":28.2},null,{"$f":"T20","v":41068317},null,{"$f":"V20","v":101928645},null,{"$f":"IF(V21=0,\"0.0 \",ROUND((P21/V21)*100,1))","v":16.8}]
[]
[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":6985263},null,{"$f":"IF(L23=0,\"0.0 \",ROUND((P23/L23)*100,1))","v":42.1},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":19.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":463527},null,{"$f":"IF(L24=0,\"0.0 \",ROUND((P24/L24)*100,1))","v":48.8},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":19.899999999999999}]
[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":601619},null,{"$f":"IF(L25=0,\"0.0 \",ROUND((P25/L25)*100,1))","v":47.3},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":19.8}]
[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":8050409},null,{"$f":"IF(L26=0,\"0.0 \",ROUND((P26/L26)*100,1))","v":42.8},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":19.3}]
[]
[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":25189546},null,{"$f":"IF(L28=0,\"0.0 \",ROUND((P28/L28)*100,1))","v":31.6},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":17.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":238374},null,{"$f":"IF(L31=0,\"0.0 \",ROUND((P31/L31)*100,1))","v":3.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":3.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":95655},null,{"$f":"IF(L32=0,\"0.0 \",ROUND((P32/L32)*100,1))","v":4.8},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":4.8}]
[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":334029},null,{"$f":"IF(L33=0,\"0.0 \",ROUND((P33/L33)*100,1))","v":3.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":3.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":25523575},null,{"$f":"IF(L34=0,\"0.0 \",ROUND((P34/L34)*100,1))","v":28.7},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":16.7}]
[]
[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":9875},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":851990},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":863790},null,{"$f":"IF(L46=0,\"0.0 \",ROUND((P46/L46)*100,1))","v":77.8},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":75.900000000000006}]
[]
[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":26387365},null,{"$f":"IF(L48=0,\"0.0 \",ROUND((P48/L48)*100,1))","v":29.3},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":17.100000000000001}]
[]
[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.7233},null,{"$f":"'Rate RS'!L39","v":77999465},null,{"$f":"ROUND((L20/L$21)*100,2)","v":100},null,{"$f":"'Rate RS'!P39","v":41068317},null,{"$f":"'Rate RS'!R39","v":119067782}]
[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.7233},null,{"$f":"L20","v":77999465},null,{"$f":"ROUND((L21/L$48)*100,2)","v":66.94},null,{"$f":"P20","v":41068317},null,{"$f":"R20","v":119067782}]
[]
[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":8.0176999999999996},null,{"$f":"'Rate GS COM'!L38","v":23567082},null,{"$f":"ROUND((L23/L$26)*100,2)","v":87.75},null,{"$f":"'Rate GS COM'!P38","v":19691247},null,{"$f":"'Rate GS COM'!R38","v":43258329}]
[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.8747999999999996},null,{"$f":"'Rate GS IND'!L38","v":1414186},null,{"$f":"ROUND((L24/L$26)*100,2)","v":5.27},null,{"$f":"'Rate GS IND'!P38","v":1378038},null,{"$f":"'Rate GS IND'!R38","v":2792224}]
[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":7.0955000000000004},null,{"$f":"'Rate GS OPA'!L38","v":1874640},null,{"$f":"ROUND((L25/L$26)*100,2)","v":6.98},null,{"$f":"'Rate GS OPA'!P38","v":1769916},null,{"$f":"'Rate GS OPA'!R38","v":3644556}]
[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.8773},null,{"$f":"SUM(L23:L25)","v":26855908},null,{"$f":"ROUND((L26/L$48)*100,2)","v":23.05},null,{"$f":"SUM(P23:P25)","v":22839201},null,{"$f":"SUM(R23:R25)","v":49695109}]
[]
[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.9915},null,{"$f":"L21+L26","v":104855373},null,{"$f":"ROUND((L28/L$48)*100,2)","v":89.99},null,{"$f":"P21+P26","v":63907518},null,{"$f":"R21+R26","v":168762891}]
[]
[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.536},null,{"$f":"'Rate FT-LG'!L35","v":7613510},null,{"$f":"ROUND((L31/L$33)*100,2)","v":78.53},null,{"$f":"'Rate FT-LG'!P35","v":3332},null,{"$f":"'Rate FT-LG'!R35","v":7616842}]
[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.258},null,{"$f":"'Rate IT'!L34","v":2081925},null,{"$f":"ROUND((L32/L$33)*100,2)","v":21.47},null,{"$f":"'Rate IT'!P34","v":0},null,{"$f":"'Rate IT'!R34","v":2081925}]
[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":2.0819000000000001},null,{"$f":"SUM(L31:L32)","v":9695435},null,{"$f":"ROUND((L33/L$48)*100,2)","v":8.32},null,{"$f":"SUM(P31:P32)","v":3332},null,{"$f":"SUM(R31:R32)","v":9698767}]
[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":8.0687999999999995},null,{"$f":"L28+L33","v":114550808},null,{"$f":"N28+N33","v":98.31},null,{"$f":"P28+P33","v":63910850},null,{"$f":"R28+R33","v":178461658}]
[]
[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.149999999999999},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":32480},null,1.65,null,{"$f":"'SCH M-2.2'!T41","v":27225},null,{"$f":"'Proposed Rates'!G30","v":59705}]
[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,1529450,null,77.47,null,0,null,1529450]
[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":1974171},null,{"$f":"ROUND((L46/L$48)*100,2)","v":1.69},null,{"$f":"SUM(P37:P45)","v":27225},null,{"$f":"SUM(R37:R45)","v":2001396}]
[]
[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":8.2055000000000007},null,{"$f":"L28+L33+L46","v":116524979},null,100,null,{"$f":"P28+P33+P46","v":63938075},null,{"$f":"R28+R33+R46","v":180463054}]
[]
[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":21},null,{"$f":"ROUND(F24*J24,0)","v":25080216},null,{"$f":"ROUND((L24/$L$39)*100,1)","v":32.200000000000003},null,null,null,{"$f":"L24+P24","v":25080216}]
[]
[6,null,"COMMODITY CHARGE:"]
[7,null,"     ALL CONSUMPTION",null,null,null,null,6130423,null,{"$f":"PRO_RS_COM","v":7.3613},null,{"$f":"ROUND((H27*J27),0)","v":45127883},null,{"$f":"ROUND((L27/$L$39)*100,1)","v":57.9},null,{"$f":"ROUND(H27*EGC,0)","v":41068317},null,{"$f":"L27+P27","v":86196200}]
[]
[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":70208099},null,{"$f":"ROUND((L29/$L$39)*100,1)","v":90},null,{"$f":"SUM(P24:P27)","v":41068317},null,{"$f":"SUM(R24:R27)","v":111276416}]
[]
[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.4},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},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":77999465},null,{"$f":"SUM(N29+N37)","v":100},null,{"$f":"P29+P37","v":41068317},null,{"$f":"R29+R37","v":119067782}]
[]
[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":4180036},null,{"$f":"IF(AD66=0,\"0.0 \",ROUND((AH66/AD66)*100,1))","v":20},null,null,null,{"$f":"AD66+AL66","v":20900180},null,{"$f":"IF(AN66=0,\"0.0 \",ROUND((AH66/AN66)*100,1))","v":20}]
[]
[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":12959101},null,{"$f":"IF(AD69=0,\"0.0 \",ROUND((AH69/AD69)*100,1))","v":40.299999999999997},null,{"$f":"P27","v":41068317},null,{"$f":"AD69+AL69","v":73237099},null,{"$f":"IF(AN69=0,\"0.0 \",ROUND((AH69/AN69)*100,1))","v":17.7}]
[]
[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":17139137},null,{"$f":"IF(AD71=0,\"0.0 \",ROUND((AH71/AD71)*100,1))","v":32.299999999999997},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":18.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,"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":17139137},null,{"$f":"IF(AD81=0,\"0.0 \",ROUND((AH81/AD81)*100,1))","v":28.2},null,{"$f":"P39","v":41068317},null,{"$f":"AN71+AN79","v":101928645},null,{"$f":"IF(AN81=0,\"0.0 \",ROUND((AH81/AN81)*100,1))","v":16.8}]
[]
[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":22.3},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.9279999999999999},null,{"$f":"ROUND((H27*J27),0)","v":17424686},null,{"$f":"ROUND((L27/$L$38)*100,1)","v":73.900000000000006},null,{"$f":"ROUND(H27*EGC,0)","v":19691247},null,{"$f":"L27+P27","v":37115933}]
[]
[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":22685266},null,{"$f":"ROUND((L29/$L$38)*100,1)","v":96.3},null,{"$f":"SUM(P24:P27)","v":19691247},null,{"$f":"SUM(R24:R27)","v":42376513}]
[]
[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.7},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.7},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":23567082},null,{"$f":"N29+N36","v":100},null,{"$f":"P29+P36","v":19691247},null,{"$f":"R29+R36","v":43258329}]
[]
[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":6418739},null,{"$f":"IF(AD68=0,\"0.0 \",ROUND((AH68/AD68)*100,1))","v":58.3},null,{"$f":"P27","v":19691247},null,{"$f":"AD68+AL68","v":30697194},null,{"$f":"IF(AN68=0,\"0.0 \",ROUND((AH68/AN68)*100,1))","v":20.9}]
[]
[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":6985263},null,{"$f":"IF(AD70=0,\"0.0 \",ROUND((AH70/AD70)*100,1))","v":44.5},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":19.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":6985263},null,{"$f":"IF(AD79=0,\"0.0 \",ROUND((AH79/AD79)*100,1))","v":42.1},null,{"$f":"P38","v":19691247},null,{"$f":"AN70+AN77","v":36273066},null,{"$f":"IF(AN79=0,\"0.0 \",ROUND((AH79/AN79)*100,1))","v":19.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.4},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.9279999999999999},null,{"$f":"ROUND((H27*J27),0)","v":1219419},null,{"$f":"ROUND((L27/$L$38)*100,1)","v":86.2},null,{"$f":"ROUND(EGC*$H27,0)","v":1378038},null,{"$f":"L27+P27","v":2597457}]
[]
[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":1352474},null,{"$f":"ROUND((L29/$L$38)*100,1)","v":95.6},null,{"$f":"SUM(P24:P27)","v":1378038},null,{"$f":"SUM(R24:R27)","v":2730512}]
[]
[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.4000000000000004},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.4000000000000004},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":1414186},null,{"$f":"N29+N36","v":100},null,{"$f":"P29+P36","v":1378038},null,{"$f":"R29+R36","v":2792224}]
[]
[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":449198},null,{"$f":"IF(AD73=0,\"0.0 \",ROUND((AH73/AD73)*100,1))","v":58.3},null,{"$f":"P27","v":1378038},null,{"$f":"AD73+AL73","v":2148259},null,{"$f":"IF(AN73=0,\"0.0 \",ROUND((AH73/AN73)*100,1))","v":20.9}]
[]
[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":463527},null,{"$f":"IF(AD75=0,\"0.0 \",ROUND((AH75/AD75)*100,1))","v":52.1},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":20.399999999999999}]
[]
[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":463527},null,{"$f":"IF(AD84=0,\"0.0 \",ROUND((AH84/AD84)*100,1))","v":48.8},null,{"$f":"P38","v":1378038},null,{"$f":"AN75+AN82","v":2328697},null,{"$f":"IF(AN84=0,\"0.0 \",ROUND((AH84/AN84)*100,1))","v":19.899999999999999}]
[]
[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.2},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.9279999999999999},null,{"$f":"ROUND((H27*J27),0)","v":1566189},null,{"$f":"ROUND((L27/$L$38)*100,1)","v":83.5},null,{"$f":"ROUND(EGC*$H27,0)","v":1769916},null,{"$f":"L27+P27","v":3336105}]
[]
[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":1795379},null,{"$f":"ROUND((L29/$L$38)*100,1)","v":95.8},null,{"$f":"SUM(P24:P27)","v":1769916},null,{"$f":"SUM(R24:R27)","v":3565295}]
[]
[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.2},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.2},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":1874640},null,{"$f":"SUM(N29+N36)","v":100},null,{"$f":"P29+P36","v":1769916},null,{"$f":"R29+R36","v":3644556}]
[]
[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":576937},null,{"$f":"IF(AD70=0,\"0.0 \",ROUND((AH70/AD70)*100,1))","v":58.3},null,{"$f":"P27","v":1769916},null,{"$f":"AD70+AL70","v":2759168},null,{"$f":"IF(AN70=0,\"0.0 \",ROUND((AH70/AN70)*100,1))","v":20.9}]
[]
[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":601619},null,{"$f":"IF(AD72=0,\"0.0 \",ROUND((AH72/AD72)*100,1))","v":50.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":20.3}]
[]
[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":601619},null,{"$f":"IF(AD81=0,\"0.0 \",ROUND((AH81/AD81)*100,1))","v":47.3},null,{"$f":"P38","v":1769916},null,{"$f":"AN72+AN79","v":3042937},null,{"$f":"IF(AN81=0,\"0.0 \",ROUND((AH81/AN81)*100,1))","v":19.8}]
[]
[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":9.8000000000000007},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.2770000000000001},null,{"$f":"ROUND((H25*J25),0)","v":6835978},null,{"$f":"ROUND((L25/L$35)*100,1)","v":89.8},null,null,null,{"$f":"L25+P25","v":6835978}]
[]
[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":7582888},null,{"$f":"SUM(N22:N25)","v":99.6},null,null,null,{"$f":"SUM(R22:R25)","v":7582888}]
[]
[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":7613510},null,{"$f":"SUM(N27+N33)","v":100},null,{"$f":"P33+P27","v":3332},null,{"$f":"R27+R33","v":7616842}]
[]
[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":238374},null,{"$f":"IF(AD63=0,\"0.0 \",ROUND((AH63/AD63)*100,1))","v":3.6},null,null,null,{"$f":"AD63+AL63","v":6597604},null,{"$f":"IF(AN63=0,\"0.0 \",ROUND((AH63/AN63)*100,1))","v":3.6}]
[]
[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":238374},null,{"$f":"IF(AD65=0,\"0.0 \",ROUND((AH65/AD65)*100,1))","v":3.2},null,null,null,{"$f":"SUM(AN60:AN63)","v":7344514},null,{"$f":"IF(AN65=0,\"0.0 \",ROUND((AH65/AN65)*100,1))","v":3.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":238374},null,{"$f":"IF(AD73=0,\"0.0 \",ROUND((AH73/AD73)*100,1))","v":3.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":3.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.7},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.1878},null,{"$f":"ROUND((H25*(J25)),0)","v":1965713},null,{"$f":"ROUND((L25/L$34)*100,1)","v":94.4},null,null,null,{"$f":"L25+P25","v":1965713}]
[]
[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":2062893},null,{"$f":"SUM(N22:N25)","v":99.100000000000009},null,null,null,{"$f":"SUM(R22:R25)","v":2062893}]
[]
[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":2081925},null,{"$f":"ROUND((L34/L$34)*100,1)","v":100},null,null,null,{"$f":"R27+R32","v":2081925}]
[]
[]
[]
[]
[]
[]
[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":95655},null,{"$f":"IF(AD65=0,\"0.0 \",ROUND((AH65/AD65)*100,1))","v":5.0999999999999996},null,null,null,{"$f":"AD65+AL65","v":1870058},null,{"$f":"IF(AN65=0,\"0.0 \",ROUND((AH65/AN65)*100,1))","v":5.0999999999999996}]
[]
[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":95655},null,{"$f":"IF(AD67=0,\"0.0 \",ROUND((AH67/AD67)*100,1))","v":4.9000000000000004},null,null,null,{"$f":"SUM(AN62:AN65)","v":1967238},null,{"$f":"IF(AN67=0,\"0.0 \",ROUND((AH67/AN67)*100,1))","v":4.9000000000000004}]
[]
[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":95655},null,{"$f":"IF(AD74=0,\"0.0 \",ROUND((AH74/AD74)*100,1))","v":4.8},null,null,null,{"$f":"AN67+AN72","v":1986270},null,{"$f":"IF(AN74=0,\"0.0 \",ROUND((AH74/AN74)*100,1))","v":4.8}]

{"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":29.87},{"$f":"G20-F20","v":5.6099999999999994},{"$f":"ROUND(H20/F20,3)*100","v":23.1},null,{"$f":"ROUND(E20*EGC,2)","v":6.7},{"$f":"F20+K20","v":30.96},{"$f":"G20+K20","v":36.57},{"$f":"ROUND((M20-L20)/L20,3)*100","v":18.099999999999998}]
[3,null,null,"Applicable",3,37.18,47.02,{"$f":"G21-F21","v":9.8400000000000034},26.5,null,{"$f":"ROUND(E21*EGC,2)","v":20.100000000000001},{"$f":"F21+K21","v":57.28},{"$f":"G21+K21","v":67.12},{"$f":"ROUND((M21-L21)/L21,3)*100","v":17.2}]
[4,null,null,null,6,56.56,72.739999999999995,16.179999999999993,28.599999999999998,null,40.19,{"$f":"F22+K22","v":96.75},112.92999999999999,16.7]
[5,null,null,null,8,69.48,89.89,20.409999999999997,29.4,null,53.59,{"$f":"F23+K23","v":123.07000000000001},143.48000000000002,16.600000000000001]
[6,null,null,null,10,82.4,107.04,24.64,29.9,null,66.989999999999995,{"$f":"F24+K24","v":149.38999999999999},174.03,16.5]
[7,null,null,null,12,95.32,124.19,28.870000000000005,30.3,null,80.39,{"$f":"F25+K25","v":175.70999999999998},204.57999999999998,16.400000000000002]
[8,null,null,null,16,121.16,158.47999999999999,37.319999999999993,30.8,null,107.19,228.35,265.66999999999996,16.3]
[9,null,null,null,20,147,192.78,45.78,31.1,null,133.97999999999999,280.98,326.76,16.3]
[10,null,null,null,30,211.6,278.51,66.91,31.6,null,200.97,412.57,479.48,16.2]
[11,null,null,null,40,276.2,364.25,88.050000000000011,31.900000000000002,null,267.95999999999998,544.16,632.21,16.2]
[12,null,null,null,50,340.79,449.99,109.19999999999999,32,null,334.96,675.75,784.95,16.2]
[13,null,null,null,60,405.39,535.73,130.34000000000003,32.200000000000003,null,401.95,807.33999999999992,937.68000000000006,16.100000000000001]
[14,null,null,null,80,534.59,707.2,172.61,32.300000000000004,null,535.92999999999995,1070.52,1243.1300000000001,16.100000000000001]
[15,null,null,null,100,663.79,878.68,214.89,32.4,null,669.91,1333.6999999999998,1548.59,16.100000000000001]
[]
[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":96.14},{"$f":"G36-F36","v":17.920000000000002},{"$f":"ROUND(H36/F36,3)*100","v":22.900000000000002},null,{"$f":"ROUND(E36*EGC,2)","v":33.5},{"$f":"F36+K36","v":111.72},{"$f":"G36+K36","v":129.63999999999999},{"$f":"ROUND((M36-L36)/L36,3)*100","v":16}]
[18,null,null,null,10,98.44,127.28,28.840000000000003,29.299999999999997,null,66.989999999999995,165.43,194.26999999999998,17.399999999999999]
[19,null,null,null,20,138.88999999999999,189.56,50.670000000000016,36.5,null,133.97999999999999,272.87,323.53999999999996,18.600000000000001]
[20,null,null,null,40,219.77,314.12,94.35,42.9,null,267.95999999999998,487.73,582.07999999999993,19.3]
[21,null,null,null,50,260.22000000000003,376.4,116.17999999999995,44.6,null,334.96,595.18000000000006,711.3599999999999,19.5]
[22,null,null,null,100,462.43,687.8,225.36999999999995,48.699999999999996,null,669.91,1132.3399999999999,1357.71,19.900000000000002]
[23,null,null,null,300,1271.29,1933.4,662.11000000000013,52.1,null,2009.73,3281.02,3943.13,20.200000000000003]
[24,null,null,null,500,2080.15,3179,1098.8499999999999,52.800000000000004,null,3349.55,5429.7000000000007,6528.55,20.200000000000003]
[25,null,null,null,700,2889.01,4424.6000000000004,1535.5900000000001,53.2,null,4689.37,7578.38,9113.9700000000012,20.3]
[26,null,null,null,850,3495.66,5358.8,1863.1400000000003,53.300000000000004,null,5694.24,9189.9,11053.04,20.3]
[27,null,null,null,1000,4102.3,6293,2190.6999999999998,53.400000000000006,null,6699.1,10801.400000000001,12992.1,20.3]
[28,null,null,null,2000,8146.6,12521,4374.3999999999996,53.7,null,13398.2,21544.800000000003,25919.200000000001,20.3]
[29,null,null,null,3000,12190.9,18749,6558.1,53.800000000000004,null,20097.3,32288.199999999997,38846.300000000003,20.3]
[]
[]
[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":2717.2},{"$f":"+G75-F75","v":79.399999999999636},{"$f":"ROUND(H75/F75,3)*100","v":3},null,{"$f":"ROUND(E75*PRO_FTL_GCAT,2)","v":37},{"$f":"F75+K75","v":2674.8},{"$f":"G75+K75","v":2754.2},{"$f":"ROUND((M75-L75)/L75,3)*100","v":3}]
[3,null,"TRANSPORTATION",null,1500,3741.7,3860.8,{"$f":"+G76-F76","v":119.10000000000036},3.2,null,55.5,{"$f":"F76+K76","v":3797.2},{"$f":"G76+K76","v":3916.3},{"$f":"ROUND((M76-L76)/L76,3)*100","v":3.1}]
[4,null,null,null,2000,4845.6000000000004,5004.3999999999996,158.79999999999927,3.3000000000000003,null,74,4919.6000000000004,5078.3999999999996,3.2]
[5,null,null,null,3000,7053.4,7291.6,238.20000000000073,3.4000000000000004,null,111,7164.4,7402.6,3.3000000000000003]
[6,null,null,null,5000,11469,11866,397,3.5000000000000004,null,185,11654,12051,3.4000000000000004]
[7,null,null,null,10000,22508,23302,794,3.5000000000000004,null,370,22878,23672,3.5000000000000004]
[8,null,null,null,20000,44586,46174,1588,3.5999999999999996,null,740,45326,46914,3.5000000000000004]
[9,null,null,null,30000,66664,69046,2382,3.5999999999999996,null,1110,67774,70156,3.5000000000000004]
[10,null,null,null,40000,88742,91918,3176,3.5999999999999996,null,1480,90222,93398,3.5000000000000004]
[11,null,null,null,50000,110820,114790,3970,3.5999999999999996,null,1850,112670,116640,3.5000000000000004]
[12,null,null,null,75000,166015,171970,5955,3.5999999999999996,null,2775,168790,174745,3.5000000000000004]
[13,null,null,null,100000,221210,229150,7940,3.5999999999999996,null,3700,224910,232850,3.5000000000000004]
[14,null,null,null,150000,331600,343510,11910,3.5999999999999996,null,5550,337150,349060,3.5000000000000004]
[15,null,null,null,200000,441990,457870,15880,3.5999999999999996,null,7400,449390,465270,3.5000000000000004]
[]
[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":2828.6},{"$f":"+G91-F91","v":115.59999999999991},{"$f":"ROUND(H91/F91,3)*100","v":4.3},null,0,{"$f":"F91+K91","v":2713},{"$f":"G91+K91","v":2828.6},{"$f":"ROUND((M91-L91)/L91,3)*100","v":4.3}]
[18,null,"TRANSPORTATION",null,5000,6137.5,6426.5,{"$f":"+G92-F92","v":289},{"$f":"ROUND(H92/F92,3)*100","v":4.7},null,0,{"$f":"F92+K92","v":6137.5},{"$f":"G92+K92","v":6426.5},{"$f":"ROUND((M92-L92)/L92,3)*100","v":4.7}]
[19,null,null,null,10000,11845,12423,578,4.9000000000000004,null,0,11845,12423,4.9000000000000004]
[20,null,null,null,15000,17552.5,18419.5,867,4.9000000000000004,null,0,17552.5,18419.5,4.9000000000000004]
[21,null,null,null,20000,23260,24416,1156,5,null,0,23260,24416,5]
[22,null,null,null,25000,28967.5,30412.5,1445,5,null,0,28967.5,30412.5,5]
[23,null,null,null,30000,34675,36409,1734,5,null,0,34675,36409,5]
[24,null,null,null,40000,46090,48402,2312,5,null,0,46090,48402,5]
[25,null,null,null,50000,57505,60395,2890,5,null,0,57505,60395,5]
[26,null,null,null,100000,114580,120360,5780,5,null,0,114580,120360,5]
[27,null,null,null,200000,228730,240290,11560,5.0999999999999996,null,0,228730,240290,5.0999999999999996]
[28,null,null,null,300000,342880,360220,17340,5.0999999999999996,null,0,342880,360220,5.0999999999999996]
[]
[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"},38885454,111276275.73442069,{"$f":"(I10-D10)/D10","v":0.18206386371567726},{"$f":"I10-D10","v":17138996.734420687},null,{"$f":"G10","v":"RS"},{"$f":"'Proposed Rates'!C21","v":140.26557931303978}]
[null,"GS",{"$f":"'Rate GS COM'!F24+'Rate GS IND'!F24+'Rate GS OPA'!F24","v":86505},40621911,null,null,{"$f":"B11","v":"GS"},6238413,48732165.653906517,{"$f":"(I11-(D11+D17))/(D11+D17)","v":0.19818243467636451},{"$f":"I11-D11-D17","v":8060424.6539065167},null,{"$f":"G11","v":"GS"},{"$f":"'Rate GS COM'!R29+'Rate GS IND'!R29+'Rate GS OPA'!R29-'Revenue Requirements'!I11","v":-59845.653906516731},"This is from ID"]
[]
[]
[null,"FT-Large",{"$f":"'Rate FT-LG'!F22","v":1737},7347846,null,null,"FT-Large",431286,8438150.1994425021,{"$f":"(I14-D14)/D14","v":0.14838419306045636},{"$f":"I14-D14","v":1090304.1994425021},null,"FT-Large",{"$f":"'Proposed Rates'!K23","v":59.800557497888803}]
[null,"IT",{"$f":"'Rate IT'!F22","v":226},1967238,null,null,"IT",104678,2063005.6937065511,4.8681295149113173E-2,95767.693706551101,null,"IT",{"$f":"'Proposed Rates'!O21","v":-112.69370655110106}]
[null,null,null,null,null,null,"Additional FT for Min use",null,{"$f":"-'Proposed Rates'!L19","v":0}]
[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":-59705},{"$f":"(-I17/D17)-1","v":0.19817379088902265},null,null,"Total",{"$f":"SUM(N10:N15)","v":-59758.281476256903},"Should = ID or very close"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I17","v":-59705},"ID"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N17-N18","v":-53.281476256903261},"Check Value"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"OTHER - less ID",null,1087776,null,null,"OTHER",null,{"$f":"+'SCH M-2.3'!R46","v":2001396},{"$f":"(I28-D28)/D28","v":0.83989718471450003}]
[null,"TOTAL",{"$f":"SUM(C10:C28)","v":1282764},{"$f":"SUM(D10:D28)","v":145211880},null,null,"TOTAL",{"$f":"SUM(H10:H28)","v":45659831},{"$f":"SUM(I10:I28)","v":172451288.28147626},{"$f":"(I29-D29)/D29","v":0.18758388281644903},{"$f":"I29-D29","v":27239408.281476259}]

{"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":38885454},null,null,"COSS - GS Customer Component",{"$f":"'Revenue Requirements'!H11+'Revenue Requirements'!H12+'Revenue Requirements'!H13","v":6238413},null,null,"COSS - FT-L Customer Component",{"$f":"'Revenue Requirements'!H14","v":431286},null,null,"COSS - IT Customer Component",{"$f":"'Revenue Requirements'!H15","v":104678}]
[null,"COSS Customer Charge",{"$f":"ROUND(C8/C7,2)","v":32.56},null,null,"COSS Customer Charge",{"$f":"ROUND(G8/G7,2)","v":72.12},null,null,"COSS Customer Charge",{"$f":"ROUND(K8/K7,2)","v":248.29},null,null,"COSS Customer Charge",{"$f":"ROUND(O8/O7,2)","v":463.18}]
[null,"Current Customer Charge",{"$f":"CUR_RS_CUST","v":17.5},null,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":15.060000000000002},null,null,"Gap",{"$f":"G9-G10","v":14.120000000000005},null,null,"Gap",{"$f":"K9-K10","v":-181.71},null,null,"Gap",{"$f":"O9-O10","v":33.180000000000007}]
[null,"Migration @ % of Justified",{"$f":"ROUND(C11*$C$29,2)","v":7.53},null,null,"Migration @ % of Justified",{"$f":"ROUND(G11*$C$29,2)","v":7.06},null,null,"Migration @ % of Justified",{"$f":"ROUND(K11*$C$29,2)","v":-90.86},null,null,"Migration @ % of Justified",{"$f":"ROUND(O11*$C$29,2)","v":16.59}]
[null,"Customer Charge at % Migration to COSS",{"$f":"C10+C12","v":25.03},null,null,"Customer Charge at % Migration to COSS",{"$f":"G10+G12","v":65.06},null,null,"Customer Charge at % Migration to COSS",{"$f":"K10+K12","v":339.14},null,null,"Customer Charge at % Migration to COSS",{"$f":"O10+O12","v":446.59}]
[null,"Proposed Customer Charge",21,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":25080216},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":111276275.73442069},null,null,"COSS - GS Revenue Requirement",{"$f":"SUM('Revenue Requirements'!I11:I13)","v":48732165.653906517},null,null,"COSS - FT-L Revenue Requirement",{"$f":"'Revenue Requirements'!I14","v":8438150.1994425021},null,null,"COSS - IT Revenue Requirement",{"$f":"'Revenue Requirements'!I15","v":2063005.6937065511}]
[null,"Less Proposed Customer Charge Revenues Less GCA",{"$f":"C17-C15-'Rate RS'!P29","v":45127742.734420687},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":20270139.653906517},null,null,"Less Proposed Customer Charge Revenues Less GCA/GCAT",{"$f":"K17-K15-'Rate FT-LG'!P25-'Rate FT-LG'!P31","v":7687908.1994425021},null,null,"Less Proposed Customer Charge Revenues Less GCA",{"$f":"O17-O15-'Rate IT'!P25","v":1965825.6937065511}]
[null,"Test Period MCF",{"$f":"'Rate RS'!H27","v":6130423},null,null,"Interdeptartmental",{"$f":"+G30","v":59705},null,null,"Change in Min Amazon",851990,null,null,"Test Period MCF",{"$f":"'Rate IT'!H25","v":1654919}]
[null,"Proposed Delivery Charge",{"$f":"ROUND(C18/C19,4)","v":7.3613},null,null,"GS Rev Requirement",{"$f":"+G18-G19","v":20210434.653906517},null,null,"FT-L Rev Requirement",{"$f":"+K18-K19","v":6835918.1994425021},null,null,"Proposed Energy Charge",{"$f":"ROUND(O18/O19,4)-0.0001","v":1.1878}]
[null,"Check to Revenue Requirements",{"$f":"'Rate RS'!R29-C17","v":140.26557931303978},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":-112.69370655110106}]
[null,null,null,null,null,"Proposed Energy Charge",{"$f":"ROUND(G20/G21,4)","v":5.9279999999999999},null,null,"Proposed Energy Charge",{"$f":"ROUND(K20/K21,4)","v":2.2770000000000001}]
[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":-140.65390651673079},null,null,"Check to Revenue Requirements",{"$f":"'Rate FT-LG'!R27-K20-K15","v":59.800557497888803}]
[]
[]
[]
[null,null,null,null,null,"Current Interdept Rev",{"$f":"+'SCH M-2.2'!V41","v":49830}]
[null,null,null,null,null,"GS Increase %",0.198182]
[null,"Migration Percentage",0.5,null,null,"Interdept Increase",{"$f":"ROUND(+G27*G28,0)","v":9875}]
[null,null,null,null,null,"Proposed Intdept Rev",{"$f":"+G27+G29","v":59705}]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"+'SCH M'!G50","v":180463054}]
[null,null,126681928]
[null,null,{"$f":"+C38-C39","v":53781126}]

{"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":65.03},{"$f":"E9-D9","v":14.280000000000001},{"$f":"ROUND(F9/D9,3)*100","v":28.1},{"$f":"ROUND(C9*EGC,2)","v":34.17},{"$f":"D9+H9","v":84.92},{"$f":"E9+H9","v":99.2},{"$f":"ROUND((J9-I9)/I9,3)","v":0.16800000000000001}]
["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":291.08},{"$f":"E10-D10","v":86.269999999999982},{"$f":"ROUND(F10/D10,3)*100","v":42.1},{"$f":"ROUND(C10*EGC,2)","v":243.18},{"$f":"D10+H10","v":447.99},{"$f":"E10+H10","v":534.26},{"$f":"ROUND((J10-I10)/I10,3)","v":0.193}]
["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":690.91},{"$f":"E11-D11","v":226.45999999999998},{"$f":"ROUND(F11/D11,3)*100","v":48.8},{"$f":"ROUND(C11*EGC,2)","v":673.26},{"$f":"D11+H11","v":1137.71},{"$f":"E11+H11","v":1364.17},0.19900000000000001]
["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":531.48},170.56,47.3,{"$f":"ROUND(C12*EGC,2)","v":501.76},{"$f":"D12+H12","v":862.68000000000006},{"$f":"E12+H12","v":1033.24},0.19800000000000001]
["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":4287.24},{"$f":"E13-D13","v":131.77000000000044},{"$f":"ROUND(F13/D13,3)*100","v":3.2},0,{"$f":"D13+H13","v":4155.4699999999993},{"$f":"E13+H13","v":4287.24},3.2000000000000001E-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":9212.11},{"$f":"E14-D14","v":423.25},{"$f":"ROUND(F14/D14,3)*100","v":4.8},0,8788.86,9212.11,4.8000000000000001E-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"]