{"text_format":"1","workbook":"xlsx","n_sheets":14,"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","Module1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":247,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Module1","index":13,"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":12,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,0,0,10]]}
[{"$f":"IF(H9=1,\"BASE PERIOD WITH RIDERS\",\"BASE PERIOD WITHOUT RIDERS\")","v":"BASE PERIOD WITH RIDERS"}]
[]
["Input Areas in Grey"]
[null,"6 MOS ACTUAL/6MOS FORECASTED",null,"INCLUDES ALL RIDERS"]
[]
[null,"DUKE ENERGY KENTUCKY"]
[null,"CASE NO. 2025-00125"]
[null,"AUTOMATED RATE CASE FILING SYSTEM"]
[null,"FOR THE TWELVE MONTHS ENDED AUGUST 31, 2025",null,null,null,null,null,1]
[]
[null,"TYPE OF SERVICE:","(GAS SERVICE)"]
[null,"DATA: _X_ BASE PERIOD   ___FORECASTED PERIOD"]
[null,"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"]
[]
[null,"WITNESS:","B. L. Sailers"]
[null,null,null,null,null,"@AUG2024","@SEP2024","@OCT2024","@NOV2024","@DEC2024","@JAN2025","@FEB2025"]
[null,"CURRENT RATES:",null,"$ PER MCF",null,4.9409999999999998,5.1829999999999998,5.1829999999999998,5.1829999999999998,5.9029999999999996,5.9029999999999996,5.9029999999999996]
[null,"EXPECTED GAS COST(1):",{"$f":"L18","v":5.4569999999999999},"$ PER MCF","Average",null,null,null,null,null,null,{"$f":"AVERAGE(F17:L17)","v":5.4569999999999999}]
[]
[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,21,"$ per Month"]
[null,"     Delivery Rate",5.2473999999999998,7.3613,"$ per MCF"]
[]
[null,"Rate GS:","Current","Proposed"]
[null,"     Customer Charge",58,65,"$ per Month"]
[null,"     Delivery Rate",3.7443,5.9279999999999999,"$ per MCF"]
[]
[null,"Rate FT-L:","Current","Proposed"]
[null,"     Administrative Charge",430,430,"$ per Month"]
[null,"     Delivery Rate",2.1976,2.2770000000000001,"$ per MCF"]
[]
[null,"Rate IT:","Current","Proposed"]
[null,"     Administrative Charge",430,430,"$ per Month"]
[null,"     Commodity Charge",1.1300000000000001,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 AUGUST 31, 2025"}]
[{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[]
[{"$f":"DATA_TYPE","v":"DATA: _X_ BASE PERIOD   ___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":"6 MOS ACTUAL/6MOS 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":92668894},null,{"$f":"'Rate RS'!R39","v":109511001},null,{"$f":"G21-E21","v":16842107},null,{"$f":"IF(E21=0,\"0.00%\",ROUND(I21/E21,4))","v":0.1817}]
[3,null,"TOTAL RS",null,{"$f":"E21","v":92668894},null,{"$f":"G21","v":109511001},null,{"$f":"I21","v":16842107},null,{"$f":"IF(E22=0,\"0.00%\",ROUND(I22/E22,4))","v":0.1817}]
[]
[4,null,"GS COMMERCIAL",null,{"$f":"'Rate GS COM'!AN79","v":33215138},null,{"$f":"'Rate GS COM'!R38","v":40340749},null,{"$f":"G24-E24","v":7125611},null,{"$f":"IF(E24=0,\"0.00%\",ROUND(I24/E24,4))","v":0.2145}]
[5,null,"GS INDUSTRIAL",null,{"$f":"'Rate GS IND'!AN84","v":1796219},null,{"$f":"'Rate GS IND'!R38","v":2196754},null,{"$f":"G25-E25","v":400535},null,{"$f":"IF(E25=0,\"0.00%\",ROUND(I25/E25,4))","v":0.223}]
[6,null,"GS OTHER PUB AUTH",null,{"$f":"'Rate GS OPA'!AN81","v":2106137},null,{"$f":"'Rate GS OPA'!R38","v":2568469},null,{"$f":"G26-E26","v":462332},null,{"$f":"IF(E26=0,\"0.00%\",ROUND(I26/E26,4))","v":0.2195}]
[7,null,"TOTAL GS",null,{"$f":"SUM(E24:E26)","v":37117494},null,{"$f":"SUM(G24:G26)","v":45105972},null,{"$f":"SUM(I24:I26)","v":7988478},null,{"$f":"IF(E27=0,\"0.00%\",ROUND(I27/E27,4))","v":0.2152}]
[]
[8,null,"     TOTAL SALES SERVICE",null,{"$f":"E22+E27","v":129786388},null,{"$f":"G22+G27","v":154616973},null,{"$f":"I22+I27","v":24830585},null,{"$f":"IF(E29=0,\"0.00%\",ROUND(I29/E29,4))","v":0.1913}]
[]
[9,null,"TRANSPORTATION:"]
[]
[10,null,"FT-L",null,{"$f":"'Rate FT-LG'!AN73","v":6940463},null,{"$f":"'Rate FT-LG'!R35","v":7162567},null,{"$f":"G33-E33","v":222104},null,{"$f":"IF(E33=0,\"0.00%\",ROUND(I33/E33,4))","v":3.2000000000000001E-2}]
[11,null,"IT",null,{"$f":"'Rate IT'!AN74","v":1917197},null,{"$f":"'Rate IT'!R34","v":2009354},null,{"$f":"G34-E34","v":92157},null,{"$f":"IF(E34=0,\"0.00%\",ROUND(I34/E34,4))","v":4.8099999999999997E-2}]
[12,null,"     TOTAL TRANSPORTATION",null,{"$f":"SUM(E33:E34)","v":8857660},null,{"$f":"SUM(G33:G34)","v":9171921},null,{"$f":"SUM(I33:I34)","v":314261},null,{"$f":"IF(E35=0,\"0.00%\",ROUND(I35/E35,4))","v":3.5499999999999997E-2}]
[13,null,"TOTAL THROUGHPUT",null,{"$f":"E35+E29","v":138644048},null,{"$f":"G35+G29","v":163788894},null,{"$f":"I35+I29","v":25144846},null,{"$f":"IF(E36=0,\"0.00%\",ROUND(I36/E36,4))","v":0.18140000000000001}]
[14,null,"MISCELLANEOUS REVENUES:"]
[]
[15,null,"LATE PAYMENT CHARGES",null,{"$f":"'SCH M-2.2'!V37","v":402203},null,{"$f":"'SCH M-2.3'!R37","v":402203},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":14766},null,{"$f":"'SCH M-2.3'!R38","v":14766},null,0,null,"0.00%"]
[17,null,"RECONNECTION CHARGES",null,{"$f":"'SCH M-2.2'!V39","v":5957},null,{"$f":"'SCH M-2.3'!R39","v":7281},null,1324,null,0.2223]
[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":30845},null,{"$f":"'SCH M-2.3'!R41","v":36958},null,6113,null,0.19819999999999999]
[20,null,"SPECIAL CONTRACTS",null,{"$f":"'SCH M-2.2'!V42","v":908211},null,{"$f":"'SCH M-2.3'!R42","v":1257450},null,349239,null,0.38450000000000001]
[21,null,"REVENUE TRANSP OF GAS-INTERCO",null,{"$f":"'SCH M-2.2'!V43","v":1795608},null,{"$f":"'SCH M-2.3'!R43","v":1795608},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":17602},null,{"$f":"'SCH M-2.3'!R45","v":17602},null,0,null,"0.00%"]
[24,null,"   TOTAL MISCELLANEOUS",null,{"$f":"SUM(E39:E47)","v":3175192},null,{"$f":"SUM(G39:G47)","v":3531868},null,{"$f":"SUM(I39:I47)","v":356676},null,0.1123]
[]
[25,null,"TOTAL COMPANY REVENUE",null,{"$f":"E29++E35+E48","v":141819240},null,{"$f":"G29++G35+G48","v":167320762},null,{"$f":"I29++I35+I48","v":25501522},null,{"$f":"IF(I50=0,\"0.00%\",ROUND(I50/E50,4))","v":0.17979999999999999}]

{"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"}]
["BASE PERIOD REVENUES AT CURRENT AVERAGE RATES"]
[{"$f":"TIME_PERIOD","v":"FOR THE TWELVE MONTHS ENDED AUGUST 31, 2025"}]
[{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[{"$f":"DATA_TYPE","v":"DATA: _X_ BASE PERIOD   ___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":"6 MOS ACTUAL/6MOS 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"}]
["BASE PERIOD"]
[]
[null,null,null,null,null,null,null,null,null,"BASE 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,"BASE 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":1179108},null,{"$f":"'Rate RS'!Z81","v":6015057},null,{"$f":"'Rate RS'!AD81","v":59844728},null,{"$f":"IF(H19=0,\"-\",ROUND(J19/H19,4))","v":9.9491999999999994},null,{"$f":"IF(ABS(J19/$J$34*100)<0.005,\"-\",ROUND(J19/$J$34*100,2))-0.01","v":66.11},null,{"$f":"'Rate RS'!AL81","v":32824166},null,{"$f":"J19+P19","v":92668894},null,{"$f":"IF(ABS(R19/$R$34*100)<0.005,\"-\",ROUND(R19/$R$34*100,2))+0.01","v":65.350000000000009}]
[2,null,"GS","GENERAL SERVICE COMMERCIAL",null,{"$f":"'Rate GS COM'!X79","v":80294},null,{"$f":"'Rate GS COM'!Z79","v":3005703},null,{"$f":"'Rate GS COM'!AD79","v":16813017},null,{"$f":"IF(H20=0,\"-\",ROUND(J20/H20,4))","v":5.5937000000000001},null,{"$f":"IF(ABS(J20/$J$34*100)<0.005,\"-\",ROUND(J20/$J$34*100,2))","v":18.579999999999998},null,{"$f":"'Rate GS COM'!AL79","v":16402121},null,{"$f":"J20+P20","v":33215138},null,{"$f":"IF(ABS(R20/$R$34*100)<0.005,\"-\",ROUND(R20/$R$34*100,2))","v":23.42}]
[3,null,"GS","GENERAL SERVICE INDUSTRIAL",null,{"$f":"'Rate GS IND'!X84","v":1942},null,{"$f":"'Rate GS IND'!Z84","v":177195},null,{"$f":"'Rate GS IND'!AD84","v":829266},null,4.68,null,0.92,null,{"$f":"'Rate GS IND'!AL84","v":966953},null,1796219,null,1.27]
[4,null,"GS","GENERAL SERVICE OTHER PUB AUTH",null,{"$f":"'Rate GS OPA'!X81","v":3432},null,{"$f":"'Rate GS OPA'!Z81","v":200718},null,{"$f":"'Rate GS OPA'!AD81","v":1010819},null,5.0359999999999996,null,1.1200000000000001,null,{"$f":"'Rate GS OPA'!AL81","v":1095318},null,2106137,null,1.49]
[5,null,"FT-L","FIRM TRANSPORTATION-LARGE",null,{"$f":"'Rate FT-LG'!X73","v":1771},null,{"$f":"'Rate FT-LG'!Z73","v":2797277},null,{"$f":"'Rate FT-LG'!AD73","v":6937358},null,2.48,null,7.66,null,{"$f":"'Rate FT-LG'!AL73","v":3105},null,6940463,null,4.8899999999999997]
[6,null,"IT","INTERRUPTIBLE TRANSPORTATION",null,{"$f":"'Rate IT'!X74","v":226},null,{"$f":"'Rate IT'!Z74","v":1594408},null,{"$f":"'Rate IT'!AD74","v":1917197},null,{"$f":"IF(H24=0,\"-\",ROUND(J24/H24,4))","v":1.2024999999999999},null,2.12,null,{"$f":"'Rate IT'!AL74","v":0},null,{"$f":"J24+P24","v":1917197},null,1.35]
[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":402203},null,{"$f":"IF(H25=0,\"-\",ROUND(J25/H25,4))","v":"-"},null,0.44,null,{"$f":"'SCH M-2.2'!T37","v":0},null,402203,null,0.28000000000000003]
[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":14766},null,"-",null,0.02,null,{"$f":"'SCH M-2.2'!T38","v":0},null,14766,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":5957},null,"-",null,0.01,null,{"$f":"'SCH M-2.2'!T39","v":0},null,5957,null,"-"]
[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":2928},null,{"$f":"'SCH M-2.2'!L41","v":14867},null,5.0774999999999997,null,0.02,null,{"$f":"'SCH M-2.2'!T41","v":15978},null,30845,null,0.02]
[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":908211},null,"-",null,1,null,{"$f":"'SCH M-2.2'!T42","v":0},null,908211,null,0.64]
[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":1795608},null,"-",null,1.98,null,{"$f":"'SCH M-2.2'!T43","v":0},null,1795608,null,1.27]
[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":17602},null,"-",null,0.02,null,{"$f":"'SCH M-2.2'!T45","v":0},null,17602,null,0.01]
[16,null,"    TOTAL",null,null,{"$f":"SUM(F19:F33)","v":1266773},null,{"$f":"SUM(H19:H33)","v":13793286},null,{"$f":"SUM(J19:J33)","v":90511599},null,{"$f":"IF(H34=0,\"-\",ROUND(J34/H34,4))","v":6.5620000000000003},null,{"$f":"SUM(N19:N33)","v":100},null,{"$f":"SUM(P19:P33)","v":51307641},null,{"$f":"SUM(R19:R33)","v":141819240},null,{"$f":"SUM(T19:T33)","v":100}]
[]
[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 AUGUST 31, 2025"}]
[{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[{"$f":"DATA_TYPE","v":"DATA: _X_ BASE PERIOD   ___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":"6 MOS ACTUAL/6MOS 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":1179108},null,{"$f":"'Rate RS'!Z81","v":6015057},null,{"$f":"ROUND((L20/H20),4)","v":9.9491999999999994},null,{"$f":"'Rate RS'!AD81","v":59844728},null,{"$f":"ROUND((L20/L$21)*100,2)","v":100},null,{"$f":"'Rate RS'!AH81","v":16842107},null,{"$f":"IF(L20=0,\"0.0 \",ROUND((P20/L20)*100,1))","v":28.1},null,{"$f":"'Rate RS'!AL81","v":32824166},null,{"$f":"'Rate RS'!AN81","v":92668894},null,{"$f":"IF(V20=0,\"0.0 \",ROUND((P20/V20)*100,1))","v":18.2}]
[3,null,null,"  TOTAL RS",null,{"$f":"F20","v":1179108},null,{"$f":"H20","v":6015057},null,{"$f":"ROUND((L21/H21),4)","v":9.9491999999999994},null,{"$f":"L20","v":59844728},null,{"$f":"ROUND((L21/$L48)*100,2)","v":66.12},null,{"$f":"P20","v":16842107},null,{"$f":"IF(L21=0,\"0.0 \",ROUND((P21/L21)*100,1))","v":28.1},null,{"$f":"T20","v":32824166},null,{"$f":"V20","v":92668894},null,{"$f":"IF(V21=0,\"0.0 \",ROUND((P21/V21)*100,1))","v":18.2}]
[]
[4,null,"GS","COMMERCIAL",null,{"$f":"'Rate GS COM'!X79","v":80294},null,{"$f":"'Rate GS COM'!Z79","v":3005703},null,{"$f":"ROUND((L23/H23),4)","v":5.5937000000000001},null,{"$f":"'Rate GS COM'!AD79","v":16813017},null,{"$f":"ROUND((L23/$L26)*100,2)","v":90.14},null,{"$f":"'Rate GS COM'!AH79","v":7125611},null,{"$f":"IF(L23=0,\"0.0 \",ROUND((P23/L23)*100,1))","v":42.4},null,{"$f":"'Rate GS COM'!AL79","v":16402121},null,{"$f":"'Rate GS COM'!AN79","v":33215138},null,{"$f":"IF(V23=0,\"0.0 \",ROUND((P23/V23)*100,1))","v":21.5}]
[5,null,"GS","INDUSTRIAL",null,{"$f":"'Rate GS IND'!X84","v":1942},null,{"$f":"'Rate GS IND'!Z84","v":177195},null,{"$f":"ROUND((L24/H24),4)","v":4.68},null,{"$f":"'Rate GS IND'!AD84","v":829266},null,{"$f":"ROUND((L24/$L26)*100,2)","v":4.45},null,{"$f":"'Rate GS IND'!AH84","v":400535},null,{"$f":"IF(L24=0,\"0.0 \",ROUND((P24/L24)*100,1))","v":48.3},null,{"$f":"'Rate GS IND'!AL84","v":966953},null,{"$f":"'Rate GS IND'!AN84","v":1796219},null,{"$f":"IF(V24=0,\"0.0 \",ROUND((P24/V24)*100,1))","v":22.3}]
[6,null,"GS","OTH PUB AUTH",null,{"$f":"'Rate GS OPA'!X81","v":3432},null,{"$f":"'Rate GS OPA'!Z81","v":200718},null,{"$f":"ROUND((L25/H25),4)","v":5.0359999999999996},null,{"$f":"'Rate GS OPA'!AD81","v":1010819},null,{"$f":"ROUND((L25/$L26)*100,2)","v":5.42},null,{"$f":"'Rate GS OPA'!AH81","v":462332},null,{"$f":"IF(L25=0,\"0.0 \",ROUND((P25/L25)*100,1))","v":45.7},null,{"$f":"'Rate GS OPA'!AL81","v":1095318},null,{"$f":"'Rate GS OPA'!AN81","v":2106137},null,{"$f":"IF(V25=0,\"0.0 \",ROUND((P25/V25)*100,1))","v":22}]
[7,null,null,"   TOTAL GS",null,{"$f":"SUM(F23:F25)","v":85668},null,{"$f":"SUM(H23:H25)","v":3383616},null,{"$f":"ROUND((L26/H26),4)","v":5.5128000000000004},null,{"$f":"SUM(L23:L25)","v":18653102},null,{"$f":"ROUND((L26/$L48)*100,2)","v":20.61},null,{"$f":"SUM(P23:P25)","v":7988478},null,{"$f":"IF(L26=0,\"0.0 \",ROUND((P26/L26)*100,1))","v":42.8},null,{"$f":"SUM(T23:T25)","v":18464392},null,{"$f":"SUM(V23:V25)","v":37117494},null,{"$f":"IF(V26=0,\"0.0 \",ROUND((P26/V26)*100,1))","v":21.5}]
[]
[8,null,"  TOTAL SALES SERVICE",null,null,{"$f":"F21+F26","v":1264776},null,{"$f":"H21+H26","v":9398673},null,{"$f":"ROUND((L28/H28),4)","v":8.3520000000000003},null,{"$f":"L21+L26","v":78497830},null,{"$f":"100-N33-N46","v":86.73},null,{"$f":"P21+P26","v":24830585},null,{"$f":"IF(L28=0,\"0.0 \",ROUND((P28/L28)*100,1))","v":31.6},null,{"$f":"T21+T26","v":51288558},null,{"$f":"V21+V26","v":129786388},null,{"$f":"IF(V28=0,\"0.0 \",ROUND((P28/V28)*100,1))","v":19.100000000000001}]
[]
[9,null,"TRANSPORTATION SERVICE:"]
[10,null,"FT-L","FIRM TRANSP - LARGE",null,{"$f":"'Rate FT-LG'!X73","v":1771},null,{"$f":"'Rate FT-LG'!Z73","v":2797277},null,{"$f":"ROUND((L31/H31),4)","v":2.48},null,{"$f":"'Rate FT-LG'!AD73","v":6937358},null,{"$f":"ROUND((L31/L$33)*100,2)","v":78.349999999999994},null,{"$f":"'Rate FT-LG'!AH73","v":222104},null,{"$f":"IF(L31=0,\"0.0 \",ROUND((P31/L31)*100,1))","v":3.2},null,{"$f":"'Rate FT-LG'!AL73","v":3105},null,{"$f":"'Rate FT-LG'!AN73","v":6940463},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":1594408},null,{"$f":"ROUND((L32/H32),4)","v":1.2024999999999999},null,{"$f":"'Rate IT'!AD74","v":1917197},null,{"$f":"ROUND((L32/L$33)*100,2)","v":21.65},null,{"$f":"'Rate IT'!AH74","v":92157},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":1917197},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":1997},null,{"$f":"SUM(H31:H32)","v":4391685},null,{"$f":"ROUND((L33/H33),4)","v":2.0162},null,{"$f":"SUM(L31:L32)","v":8854555},null,{"$f":"ROUND((L33/L$48)*100,2)","v":9.7799999999999994},null,{"$f":"SUM(P31:P32)","v":314261},null,{"$f":"IF(L33=0,\"0.0 \",ROUND((P33/L33)*100,1))","v":3.5},null,{"$f":"SUM(T31:T32)","v":3105},null,{"$f":"SUM(V31:V32)","v":8857660},null,{"$f":"IF(V33=0,\"0.0 \",ROUND((P33/V33)*100,1))","v":3.5}]
[13,null,"TOTAL THROUGHPUT",null,null,{"$f":"F28+F33","v":1266773},null,{"$f":"H28+H33","v":13790358},null,{"$f":"ROUND((L34/H34),4)","v":6.3342999999999998},null,{"$f":"L28+L33","v":87352385},null,{"$f":"N28+N33","v":96.51},null,{"$f":"P28+P33","v":25144846},null,{"$f":"IF(L34=0,\"0.0 \",ROUND((P34/L34)*100,1))","v":28.8},null,{"$f":"T28+T33","v":51291663},null,{"$f":"V28+V33","v":138644048},null,{"$f":"IF(V34=0,\"0.0 \",ROUND((P34/V34)*100,1))","v":18.100000000000001}]
[]
[14,null,"MISCELLANEOUS REVENUES: "]
[15,null,"LATE PAYMENT CHARGES",null,null,0,null,0,null,null,null,402203,null,{"$f":"ROUND((L37/L$46)*100,2)","v":12.73},null,{"$f":"'SCH M-2.3'!L37-'SCH M-2.2'!L37","v":0},null,null,null,0,null,{"$f":"L37+T37","v":402203}]
[16,null,"BAD CHECK CHARGES",null,null,0,null,0,null,null,null,14766,null,0.47,null,{"$f":"'SCH M-2.3'!L38-'SCH M-2.2'!L38","v":0},null,null,null,0,null,{"$f":"L38+T38","v":14766}]
[17,null,"RECONNECTION CHARGES",null,null,0,null,0,null,null,null,5957,null,0.19,null,{"$f":"'SCH M-2.3'!L39-'SCH M-2.2'!L39","v":1324},null,null,null,0,null,5957]
[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,2928,null,null,null,{"$f":"ROUND(V41-(H41*EGC),0)","v":14867},null,{"$f":"ROUND((L41/L$46)*100,2)","v":0.47},null,{"$f":"'SCH M-2.3'!L41-'SCH M-2.2'!L41","v":6113},null,null,null,{"$f":"V41-L41","v":15978},null,30845]
[20,null,"SPECIAL CONTRACTS",null,null,0,null,0,null,null,null,908211,null,28.75,null,{"$f":"'SCH M-2.3'!L42-'SCH M-2.2'!L42","v":349239},null,null,null,0,null,908211]
[21,null,"REVENUE TRANSP OF GAS-INTERCO",null,null,0,null,0,null,null,null,1795608,null,56.84,null,{"$f":"'SCH M-2.3'!L43-'SCH M-2.2'!L43","v":0},null,null,null,0,null,1795608]
[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,17602,null,0.56000000000000005,null,{"$f":"'SCH M-2.3'!L45-'SCH M-2.2'!L45","v":0},null,null,null,0,null,17602]
[24,null,"  TOTAL MISC",null,null,{"$f":"SUM(F37:F45)","v":0},null,{"$f":"SUM(H37:H45)","v":2928},null,null,null,{"$f":"SUM(L37:L45)","v":3159214},null,{"$f":"ROUND((L46/L$48)*100,2)","v":3.49},null,{"$f":"SUM(P37:P45)","v":356676},null,{"$f":"IF(L46=0,\"0.0 \",ROUND((P46/L46)*100,1))","v":11.3},null,{"$f":"SUM(T37:T45)","v":15978},null,{"$f":"SUM(V37:V45)","v":3175192},null,{"$f":"IF(V46=0,\"0.0 \",ROUND((P46/V46)*100,1))","v":11.2}]
[]
[25,null,"    TOTAL COMPANY",null,null,{"$f":"F28+F33+F46","v":1266773},null,{"$f":"H28+H33+H46","v":13793286},null,{"$f":"ROUND((L48/H48),4)","v":6.5620000000000003},null,{"$f":"L28+L33+L46","v":90511599},null,100,null,{"$f":"P28+P33+P46","v":25501522},null,{"$f":"IF(L48=0,\"0.0 \",ROUND((P48/L48)*100,1))","v":28.2},null,{"$f":"T28+T33+T46","v":51307641},null,{"$f":"V28+V33+V46","v":141819240},null,{"$f":"IF(V48=0,\"0.0 \",ROUND((P48/V48)*100,1))","v":18}]
[]
[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 $5.457/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 AUGUST 31, 2025"}]
[{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[{"$f":"DATA_TYPE","v":"DATA: _X_ BASE PERIOD   ___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":"6 MOS ACTUAL/6MOS 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":1179108},null,{"$f":"'Rate RS'!H39","v":6015057},null,{"$f":"IF(F20=0,\"0.0 \",ROUND((L20/H20),4))","v":12.7491},null,{"$f":"'Rate RS'!L39","v":76686835},null,{"$f":"ROUND((L20/L$21)*100,2)","v":100},null,{"$f":"'Rate RS'!P39","v":32824166},null,{"$f":"'Rate RS'!R39","v":109511001}]
[3,null,null,"  TOTAL RS",null,{"$f":"F20","v":1179108},null,{"$f":"H20","v":6015057},null,{"$f":"IF(F21=0,\"0.0 \",ROUND((L21/H21),4))","v":12.7491},null,{"$f":"L20","v":76686835},null,{"$f":"ROUND((L21/L$48)*100,2)","v":66.099999999999994},null,{"$f":"P20","v":32824166},null,{"$f":"R20","v":109511001}]
[]
[4,null,"GS","COMMERCIAL",null,{"$f":"'Rate GS COM'!F38","v":80294},null,{"$f":"'Rate GS COM'!H38","v":3005703},null,{"$f":"IF(F23=0,\"0.0 \",ROUND((L23/H23),4))","v":7.9644000000000004},null,{"$f":"'Rate GS COM'!L38","v":23938628},null,{"$f":"ROUND((L23/L$26)*100,2)-0.01","v":89.839999999999989},null,{"$f":"'Rate GS COM'!P38","v":16402121},null,{"$f":"'Rate GS COM'!R38","v":40340749}]
[5,null,"GS","INDUSTRIAL",null,{"$f":"'Rate GS IND'!F38","v":1942},null,{"$f":"'Rate GS IND'!H38","v":177195},null,{"$f":"IF(F24=0,\"0.0 \",ROUND((L24/H24),4))","v":6.9404000000000003},null,{"$f":"'Rate GS IND'!L38","v":1229801},null,{"$f":"ROUND((L24/L$26)*100,2)","v":4.62},null,{"$f":"'Rate GS IND'!P38","v":966953},null,{"$f":"'Rate GS IND'!R38","v":2196754}]
[6,null,"GS","OTH PUB AUTH",null,{"$f":"'Rate GS OPA'!F38","v":3432},null,{"$f":"'Rate GS OPA'!H38","v":200718},null,{"$f":"IF(F25=0,\"0.0 \",ROUND((L25/H25),4))","v":7.3394000000000004},null,{"$f":"'Rate GS OPA'!L38","v":1473151},null,{"$f":"ROUND((L25/L$26)*100,2)","v":5.53},null,{"$f":"'Rate GS OPA'!P38","v":1095318},null,{"$f":"'Rate GS OPA'!R38","v":2568469}]
[7,null,null,"   TOTAL GS",null,{"$f":"SUM(F23:F25)","v":85668},null,{"$f":"SUM(H23:H25)","v":3383616},null,{"$f":"IF(F26=0,\"0.0 \",ROUND((L26/H26),4))","v":7.8737000000000004},null,{"$f":"SUM(L23:L25)","v":26641580},null,{"$f":"ROUND((L26/L$48)*100,2)","v":22.96},null,{"$f":"SUM(P23:P25)","v":18464392},null,{"$f":"SUM(R23:R25)","v":45105972}]
[]
[8,null,"  TOTAL SALES SERVICE",null,null,{"$f":"F21+F26","v":1264776},null,{"$f":"H21+H26","v":9398673},null,{"$f":"IF(F28=0,\"0.0 \",ROUND((L28/H28),4))","v":10.9939},null,{"$f":"L21+L26","v":103328415},null,{"$f":"ROUND((L28/L$48)*100,2)","v":89.07},null,{"$f":"P21+P26","v":51288558},null,{"$f":"R21+R26","v":154616973}]
[]
[9,null,"TRANSPORTATION SERVICE:"]
[10,null,"FT-L","FIRM TRANSP - LARGE",null,{"$f":"'Rate FT-LG'!F35","v":1771},null,{"$f":"'Rate FT-LG'!H35","v":2797277},null,{"$f":"IF(F31=0,\"0.0 \",ROUND((L31/H31),4))","v":2.5594000000000001},null,{"$f":"'Rate FT-LG'!L35","v":7159462},null,{"$f":"ROUND((L31/L$33)*100,2)","v":78.08},null,{"$f":"'Rate FT-LG'!P35","v":3105},null,{"$f":"'Rate FT-LG'!R35","v":7162567}]
[11,null,"IT","INTERRUPTIBLE TRANSP",null,{"$f":"'Rate IT'!F34","v":226},null,{"$f":"'Rate IT'!H34","v":1594408},null,{"$f":"IF(F32=0,\"0.0 \",ROUND((L32/H32),4))","v":1.2603},null,{"$f":"'Rate IT'!L34","v":2009354},null,{"$f":"ROUND((L32/L$33)*100,2)","v":21.92},null,{"$f":"'Rate IT'!P34","v":0},null,{"$f":"'Rate IT'!R34","v":2009354}]
[12,null,"  TOTAL TRANSP SERVICE",null,null,{"$f":"SUM(F31:F32)","v":1997},null,{"$f":"SUM(H31:H32)","v":4391685},null,{"$f":"IF(F33=0,\"0.0 \",ROUND((L33/H33),4))","v":2.0878000000000001},null,{"$f":"SUM(L31:L32)","v":9168816},null,{"$f":"ROUND((L33/L$48)*100,2)","v":7.9},null,{"$f":"SUM(P31:P32)","v":3105},null,{"$f":"SUM(R31:R32)","v":9171921}]
[13,null,"TOTAL THROUGHPUT",null,null,{"$f":"F28+F33","v":1266773},null,{"$f":"H28+H33","v":13790358},null,{"$f":"IF(F34=0,\"0.0 \",ROUND((L34/H34),4))","v":8.1577000000000002},null,{"$f":"L28+L33","v":112497231},null,{"$f":"N28+N33","v":96.97},null,{"$f":"P28+P33","v":51291663},null,{"$f":"R28+R33","v":163788894}]
[]
[14,null,"MISCELLANEOUS REVENUES: "]
[15,null,"LATE PAYMENT CHARGES",null,null,0,null,0,null,null,null,{"$f":"'SCH M-2.2'!L37","v":402203},null,{"$f":"ROUND((L37/L$46)*100,2)","v":11.44},null,0,null,{"$f":"L37+P37","v":402203}]
[16,null,"BAD CHECK CHARGES",null,null,0,null,0,null,null,null,{"$f":"'SCH M-2.2'!L38","v":14766},null,0.42,null,0,null,14766]
[17,null,"RECONNECTION CHARGES",null,null,0,null,0,null,null,null,{"$f":"ROUND('SCH M-2.2'!L39*1.2222,0)","v":7281},null,0.21,null,0,null,7281]
[18,null,"FIELD COLLECITON 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":2928},null,null,null,{"$f":"R41-P41","v":20980},null,0.6,null,{"$f":"'SCH M-2.2'!T41","v":15978},null,36958]
[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,1257450,null,35.76,null,0,null,1257450]
[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":1795608},null,51.07,null,0,null,1795608]
[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,{"$f":"ROUND((L44/L$46)*100,2)+0.01","v":0.01},null,0,null,0]
[23,null,"OTHER MISC",null,null,0,null,0,null,null,null,{"$f":"'SCH M-2.2'!L45","v":17602},null,0.5,null,0,null,17602]
[24,null,"  TOTAL MISC",null,null,{"$f":"SUM(F37:F45)","v":0},null,{"$f":"SUM(H37:H45)","v":2928},null,null,null,{"$f":"SUM(L37:L45)","v":3515890},null,{"$f":"ROUND((L46/L$48)*100,2)","v":3.03},null,{"$f":"SUM(P37:P45)","v":15978},null,{"$f":"SUM(R37:R45)","v":3531868}]
[]
[25,null,"    TOTAL COMPANY",null,null,{"$f":"F28+F33+F46","v":1266773},null,{"$f":"H28+H33+H46","v":13793286},null,{"$f":"IF(F48=0,\"0.0 \",ROUND((L48/H48),4))","v":8.4108000000000001},null,{"$f":"L28+L33+L46","v":116013121},null,100,null,{"$f":"P28+P33+P46","v":51307641},null,{"$f":"R28+R33+R46","v":167320762}]
[]
[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 $5.457/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 AUGUST 31, 2025"}]
[{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[{"$f":"DATA_TYPE","v":"DATA: _X_ BASE PERIOD   ___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":"6 MOS ACTUAL/6MOS 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,1179108,null,null,null,{"$f":"PRO_RS_CUST","v":21},null,{"$f":"ROUND(F24*J24,0)","v":24761268},null,{"$f":"ROUND((L24/$L$39)*100,1)","v":32.299999999999997},null,null,null,{"$f":"L24+P24","v":24761268}]
[]
[6,null,"COMMODITY CHARGE:"]
[7,null,"     ALL CONSUMPTION",null,null,null,null,6015057,null,{"$f":"PRO_RS_COM","v":7.3613},null,{"$f":"ROUND((H27*J27),0)","v":44278639},null,{"$f":"ROUND((L27/$L$39)*100,1)","v":57.7},null,{"$f":"ROUND(H27*EGC,0)","v":32824166},null,{"$f":"L27+P27","v":77102805}]
[]
[8,null,"RATE RS EXCLUDING RIDERS",null,null,{"$f":"F24","v":1179108},null,{"$f":"H27","v":6015057},null,null,null,{"$f":"SUM(L24:L27)","v":69039907},null,{"$f":"ROUND((L29/$L$39)*100,1)","v":90},null,{"$f":"SUM(P24:P27)","v":32824166},null,{"$f":"SUM(R24:R27)","v":101864073}]
[]
[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":353732},null,{"$f":"ROUND((L32/$L$39)*100,1)","v":0.5},null,null,null,{"$f":"L32+P32","v":353732}]
[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":75128},null,{"$f":"ROUND((L33/$L$39)*100,1)+0.1","v":0.2},null,null,null,{"$f":"L33+P33","v":75128}]
[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":7218068},null,{"$f":"ROUND((L35/$L$39)*100,1)","v":9.4},null,null,null,{"$f":"L35+P35","v":7218068}]
[]
[14,null,"TOTAL RIDERS",null,null,null,null,null,null,null,null,{"$f":"SUM(L32:L35)","v":7646928},null,{"$f":"ROUND((L37/$L$39)*100,1)","v":10},null,null,null,{"$f":"SUM(R32:R35)","v":7646928}]
[]
[15,null,"TOTAL RATE RS RESIDENTIAL INCLUDING RIDERS",null,null,{"$f":"F24","v":1179108},null,{"$f":"H27","v":6015057},null,null,null,{"$f":"L29+L37","v":76686835},null,{"$f":"SUM(N29+N37)","v":100},null,{"$f":"P29+P37","v":32824166},null,{"$f":"R29+R37","v":109511001}]
[]
[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 $5.457/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 AUGUST 31, 2025"}]
[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: _X_ BASE PERIOD   ___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":"6 MOS ACTUAL/6MOS 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":1179108},null,null,null,{"$f":"CUR_RS_CUST","v":17.5},null,{"$f":"ROUND(X66*AB66,0)","v":20634390},null,{"$f":"ROUND((AD66/$AD$81)*100,1)","v":34.5},null,{"$f":"L24-AD66","v":4126878},null,{"$f":"IF(AD66=0,\"0.0 \",ROUND((AH66/AD66)*100,1))","v":20},null,null,null,{"$f":"AD66+AL66","v":20634390},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":6015057},null,{"$f":"CUR_RS","v":5.2473999999999998},null,{"$f":"ROUND((Z69*AB69),0)","v":31563410},null,{"$f":"ROUND((AD69/$AD$81)*100,1)","v":52.7},null,{"$f":"L27-AD69","v":12715229},null,{"$f":"IF(AD69=0,\"0.0 \",ROUND((AH69/AD69)*100,1))","v":40.299999999999997},null,{"$f":"P27","v":32824166},null,{"$f":"AD69+AL69","v":64387576},null,{"$f":"IF(AN69=0,\"0.0 \",ROUND((AH69/AN69)*100,1))","v":19.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":1179108},null,{"$f":"Z69","v":6015057},null,null,null,{"$f":"SUM(AD66:AD69)","v":52197800},null,{"$f":"ROUND((AD71/$AD$81)*100,1)","v":87.2},null,{"$f":"SUM(AH66:AH69)","v":16842107},null,{"$f":"IF(AD71=0,\"0.0 \",ROUND((AH71/AD71)*100,1))","v":32.299999999999997},null,{"$f":"SUM(AL66:AL69)","v":32824166},null,{"$f":"SUM(AN66:AN69)","v":85021966},null,{"$f":"IF(AN71=0,\"0.0 \",ROUND((AH71/AN71)*100,1))","v":19.8}]
[]
[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":353732},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":353732},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":75128},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":75128},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":7218068},null,{"$f":"ROUND((AD77/$AD$81)*100,1)","v":12.1},null,{"$f":"L35-AD77","v":0},null,0,null,null,null,7218068,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":7646928},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":7646928},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":1179108},null,{"$f":"Z69","v":6015057},null,null,null,{"$f":"AD71+AD79","v":59844728},null,{"$f":"SUM(AF71+AF79)","v":100},null,{"$f":"AH71+AH79","v":16842107},null,{"$f":"IF(AD81=0,\"0.0 \",ROUND((AH81/AD81)*100,1))","v":28.1},null,{"$f":"P39","v":32824166},null,{"$f":"AN71+AN79","v":92668894},null,{"$f":"IF(AN81=0,\"0.0 \",ROUND((AH81/AN81)*100,1))","v":18.2}]
[]
[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 $5.457/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 AUGUST 31, 2025"}]
[{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[{"$f":"DATA_TYPE","v":"DATA: _X_ BASE PERIOD   ___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":"6 MOS ACTUAL/6MOS 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,80294,null,null,null,{"$f":"PRO_GS_CUST","v":65},null,{"$f":"ROUND(F24*J24,0)","v":5219110},null,{"$f":"ROUND((L24/$L$38)*100,1)","v":21.8},null,null,null,{"$f":"L24+P24","v":5219110}]
[]
[6,null,"COMMODITY CHARGE:"]
[7,null,"     ALL CONSUMPTION",null,null,null,null,3005703,null,{"$f":"PRO_GS","v":5.9279999999999999},null,{"$f":"ROUND((H27*J27),0)","v":17817807},null,{"$f":"ROUND((L27/$L$38)*100,1)","v":74.400000000000006},null,{"$f":"ROUND(H27*EGC,0)","v":16402121},null,{"$f":"L27+P27","v":34219928}]
[]
[8,null,"RATE GS COMMERCIAL EXCLUDING RIDERS",null,null,{"$f":"F24","v":80294},null,{"$f":"H27","v":3005703},null,null,null,{"$f":"SUM(L24:L27)","v":23036917},null,{"$f":"ROUND((L29/$L$38)*100,1)","v":96.2},null,{"$f":"SUM(P24:P27)","v":16402121},null,{"$f":"SUM(R24:R27)","v":39439038}]
[]
[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,0.3,null,{"$f":"ROUND(H29*J34,0)","v":901711},null,{"$f":"ROUND((L34/$L$38)*100,1)","v":3.8},null,null,null,{"$f":"L34+P34","v":901711}]
[]
[13,null,"TOTAL RIDERS",null,null,null,null,null,null,null,null,{"$f":"SUM(L31:L34)","v":901711},null,{"$f":"ROUND((L36/$L$38)*100,1)","v":3.8},null,null,null,{"$f":"SUM(R31:R34)","v":901711}]
[]
[14,null,"TOTAL RATE GS COMMERCIAL INCLUDING RIDERS",null,null,{"$f":"F24","v":80294},null,{"$f":"H27","v":3005703},null,null,null,{"$f":"L29+L36","v":23938628},null,{"$f":"N29+N36","v":100},null,{"$f":"P29+P36","v":16402121},null,{"$f":"R29+R36","v":40340749}]
[]
[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 $5.457/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 AUGUST 31, 2025"}]
[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: _X_ BASE PERIOD   ___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":"6 MOS ACTUAL/6MOS 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":80294},null,null,null,{"$f":"CUR_GS_CUST","v":58},null,{"$f":"ROUND(X65*AB65,0)","v":4657052},null,{"$f":"ROUND((AD65/$AD$79)*100,1)","v":27.7},null,{"$f":"L24-AD65","v":562058},null,{"$f":"IF(AD65=0,\"0.0 \",ROUND((AH65/AD65)*100,1))","v":12.1},null,null,null,{"$f":"AD65+AL65","v":4657052},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":3005703},null,{"$f":"CUR_GS","v":3.7443},null,{"$f":"ROUND((Z68*AB68),0)","v":11254254},null,{"$f":"ROUND((AD68/$AD$79)*100,1)","v":66.900000000000006},null,{"$f":"L27-AD68","v":6563553},null,{"$f":"IF(AD68=0,\"0.0 \",ROUND((AH68/AD68)*100,1))","v":58.3},null,{"$f":"P27","v":16402121},null,{"$f":"AD68+AL68","v":27656375},null,{"$f":"IF(AN68=0,\"0.0 \",ROUND((AH68/AN68)*100,1))","v":23.7}]
[]
[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":80294},null,{"$f":"Z68","v":3005703},null,null,null,{"$f":"SUM(AD65:AD68)","v":15911306},null,{"$f":"ROUND((AD70/$AD$79)*100,1)","v":94.6},null,{"$f":"SUM(AH65:AH68)","v":7125611},null,{"$f":"IF(AD70=0,\"0.0 \",ROUND((AH70/AD70)*100,1))","v":44.8},null,{"$f":"SUM(AL65:AL68)","v":16402121},null,{"$f":"SUM(AN65:AN68)","v":32313427},null,{"$f":"IF(AN70=0,\"0.0 \",ROUND((AH70/AN70)*100,1))","v":22.1}]
[]
[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":901711},null,{"$f":"ROUND((AD75/$AD$79)*100,1)","v":5.4},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":901711},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":901711},null,{"$f":"ROUND((AD77/$AD$79)*100,1)","v":5.4},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":901711},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":80294},null,{"$f":"Z68","v":3005703},null,null,null,{"$f":"AD70+AD77","v":16813017},null,{"$f":"AF77+AF70","v":100},null,{"$f":"AH70+AH77","v":7125611},null,{"$f":"IF(AD79=0,\"0.0 \",ROUND((AH79/AD79)*100,1))","v":42.4},null,{"$f":"P38","v":16402121},null,{"$f":"AN70+AN77","v":33215138},null,{"$f":"IF(AN79=0,\"0.0 \",ROUND((AH79/AN79)*100,1))","v":21.5}]
[]
[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 $5.457/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 AUGUST 31, 2025"}]
[{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[{"$f":"DATA_TYPE","v":"DATA: _X_ BASE PERIOD   ___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":"6 MOS ACTUAL/6MOS 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,1942,null,null,null,{"$f":"PRO_GS_CUST","v":65},null,{"$f":"ROUND(F24*J24,0)","v":126230},null,{"$f":"ROUND((L24/$L$38)*100,1)","v":10.3},null,null,null,{"$f":"L24+P24","v":126230}]
[]
[6,null,"COMMODITY CHARGE:"]
[7,null,"     ALL CONSUMPTION",null,null,null,null,177195,null,{"$f":"PRO_GS","v":5.9279999999999999},null,{"$f":"ROUND((H27*J27),0)","v":1050412},null,{"$f":"ROUND((L27/$L$38)*100,1)","v":85.4},null,{"$f":"ROUND(EGC*$H27,0)","v":966953},null,{"$f":"L27+P27","v":2017365}]
[]
[8,null,"RATE GS INDUSTRIAL EXCLUDING RIDERS",null,null,{"$f":"F24","v":1942},null,{"$f":"H27","v":177195},null,null,null,{"$f":"SUM(L24:L27)","v":1176642},null,{"$f":"ROUND((L29/$L$38)*100,1)","v":95.7},null,{"$f":"SUM(P24:P27)","v":966953},null,{"$f":"SUM(R24:R27)","v":2143595}]
[]
[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,0.3,null,{"$f":"ROUND(H29*J34,0)","v":53159},null,{"$f":"ROUND((L34/$L$38)*100,1)","v":4.3},null,null,null,{"$f":"L34+P34","v":53159}]
[]
[13,null,"TOTAL RIDERS",null,null,null,null,null,null,null,null,{"$f":"SUM(L31:L34)","v":53159},null,{"$f":"ROUND((L36/$L$38)*100,1)","v":4.3},null,null,null,{"$f":"SUM(R31:R34)","v":53159}]
[]
[14,null,"TOTAL RATE GS INDUSTRIAL INCLUDING RIDERS",null,null,{"$f":"F24","v":1942},null,{"$f":"H27","v":177195},null,null,null,{"$f":"L29+L36","v":1229801},null,{"$f":"N29+N36","v":100},null,{"$f":"P29+P36","v":966953},null,{"$f":"R29+R36","v":2196754}]
[]
[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 $5.457/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 AUGUST 31, 2025"}]
[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: _X_ BASE PERIOD   ___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":"6 MOS ACTUAL/6MOS 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":1942},null,null,null,{"$f":"CUR_GS_CUST","v":58},null,{"$f":"ROUND(X70*AB70,0)","v":112636},null,{"$f":"ROUND((AD70/$AD$84)*100,1)","v":13.6},null,{"$f":"L24-AD70","v":13594},null,{"$f":"IF(AD70=0,\"0.0 \",ROUND((AH70/AD70)*100,1))","v":12.1},null,null,null,{"$f":"AD70+AL70","v":112636},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":177195},null,{"$f":"CUR_GS","v":3.7443},null,{"$f":"ROUND((Z73*AB73),0)","v":663471},null,{"$f":"ROUND((AD73/$AD$84)*100,1)","v":80},null,{"$f":"L27-AD73","v":386941},null,{"$f":"IF(AD73=0,\"0.0 \",ROUND((AH73/AD73)*100,1))","v":58.3},null,{"$f":"P27","v":966953},null,{"$f":"AD73+AL73","v":1630424},null,{"$f":"IF(AN73=0,\"0.0 \",ROUND((AH73/AN73)*100,1))","v":23.7}]
[]
[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":1942},null,{"$f":"Z73","v":177195},null,null,null,{"$f":"SUM(AD70:AD73)","v":776107},null,{"$f":"ROUND((AD75/$AD$84)*100,1)","v":93.6},null,{"$f":"SUM(AH70:AH73)","v":400535},null,{"$f":"IF(AD75=0,\"0.0 \",ROUND((AH75/AD75)*100,1))","v":51.6},null,{"$f":"SUM(AL70:AL73)","v":966953},null,{"$f":"SUM(AN70:AN73)","v":1743060},null,{"$f":"IF(AN75=0,\"0.0 \",ROUND((AH75/AN75)*100,1))","v":23}]
[]
[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":53159},null,{"$f":"ROUND((AD80/$AD$84)*100,1)","v":6.4},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":53159},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":53159},null,{"$f":"ROUND((AD82/$AD$84)*100,1)","v":6.4},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":53159},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":1942},null,{"$f":"Z73","v":177195},null,null,null,{"$f":"AD75+AD82","v":829266},null,{"$f":"AF75+AF82","v":100},null,{"$f":"AH75+AH82","v":400535},null,{"$f":"IF(AD84=0,\"0.0 \",ROUND((AH84/AD84)*100,1))","v":48.3},null,{"$f":"P38","v":966953},null,{"$f":"AN75+AN82","v":1796219},null,{"$f":"IF(AN84=0,\"0.0 \",ROUND((AH84/AN84)*100,1))","v":22.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 $5.457/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 AUGUST 31, 2025"}]
[{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[{"$f":"DATA_TYPE","v":"DATA: _X_ BASE PERIOD   ___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":"6 MOS ACTUAL/6MOS 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,3432,null,null,null,{"$f":"PRO_GS_CUST","v":65},null,{"$f":"ROUND(F24*J24,0)","v":223080},null,{"$f":"ROUND((L24/$L$38)*100,1)","v":15.1},null,null,null,{"$f":"L24+P24","v":223080}]
[]
[6,null,"COMMODITY CHARGE:"]
[7,null,"     ALL CONSUMPTION",null,null,null,null,200718,null,{"$f":"PRO_GS","v":5.9279999999999999},null,{"$f":"ROUND((H27*J27),0)","v":1189856},null,{"$f":"ROUND((L27/$L$38)*100,1)","v":80.8},null,{"$f":"ROUND(EGC*$H27,0)","v":1095318},null,{"$f":"L27+P27","v":2285174}]
[]
[8,null,"RATE GS OPA EXCLUDING RIDERS",null,null,{"$f":"F24","v":3432},null,{"$f":"H27","v":200718},null,null,null,{"$f":"SUM(L24:L27)","v":1412936},null,{"$f":"ROUND((L29/$L$38)*100,1)","v":95.9},null,{"$f":"SUM(P24:P27)","v":1095318},null,{"$f":"SUM(R24:R27)","v":2508254}]
[]
[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,0.3,null,{"$f":"ROUND(H29*J34,0)","v":60215},null,{"$f":"ROUND((L34/$L$38)*100,1)","v":4.0999999999999996},null,null,null,{"$f":"L34+P34","v":60215}]
[]
[12,null,"TOTAL RIDERS",null,null,null,null,null,null,null,null,{"$f":"SUM(L31:L34)","v":60215},null,{"$f":"ROUND((L36/$L$38)*100,1)","v":4.0999999999999996},null,null,null,{"$f":"SUM(R31:R34)","v":60215}]
[]
[13,null,"TOTAL RATE GS OPA INCLUDING RIDERS",null,null,{"$f":"F24","v":3432},null,{"$f":"H27","v":200718},null,null,null,{"$f":"L29+L36","v":1473151},null,{"$f":"SUM(N29+N36)","v":100},null,{"$f":"P29+P36","v":1095318},null,{"$f":"R29+R36","v":2568469}]
[]
[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 $5.457/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 AUGUST 31, 2025"}]
[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: _X_ BASE PERIOD   ___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":"6 MOS ACTUAL/6MOS 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":3432},null,null,null,{"$f":"CUR_GS_CUST","v":58},null,{"$f":"ROUND(X67*AB67,0)","v":199056},null,{"$f":"ROUND((AD67/$AD$81)*100,1)","v":19.7},null,{"$f":"L24-AD67","v":24024},null,{"$f":"IF(AD67=0,\"0.0 \",ROUND((AH67/AD67)*100,1))","v":12.1},null,null,null,{"$f":"AD67+AL67","v":199056},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":200718},null,{"$f":"CUR_GS","v":3.7443},null,{"$f":"ROUND((Z70*AB70),0)","v":751548},null,{"$f":"ROUND((AD70/$AD$81)*100,1)","v":74.400000000000006},null,{"$f":"L27-AD70","v":438308},null,{"$f":"IF(AD70=0,\"0.0 \",ROUND((AH70/AD70)*100,1))","v":58.3},null,{"$f":"P27","v":1095318},null,{"$f":"AD70+AL70","v":1846866},null,{"$f":"IF(AN70=0,\"0.0 \",ROUND((AH70/AN70)*100,1))","v":23.7}]
[]
[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":3432},null,{"$f":"Z70","v":200718},null,null,null,{"$f":"SUM(AD67:AD70)","v":950604},null,{"$f":"ROUND((AD72/$AD$81)*100,1)","v":94},null,{"$f":"SUM(AH67:AH70)","v":462332},null,{"$f":"IF(AD72=0,\"0.0 \",ROUND((AH72/AD72)*100,1))","v":48.6},null,{"$f":"SUM(AL67:AL70)","v":1095318},null,{"$f":"SUM(AN67:AN70)","v":2045922},null,{"$f":"IF(AN72=0,\"0.0 \",ROUND((AH72/AN72)*100,1))","v":22.6}]
[]
[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":60215},null,{"$f":"ROUND((AD77/$AD$81)*100,1)","v":6},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":60215},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":12},null,"TOTAL RIDERS",null,null,null,null,null,null,null,{"$f":"SUM(AD74:AD77)","v":60215},null,{"$f":"ROUND((AD79/$AD$81)*100,1)","v":6},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":60215},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":13},null,"TOTAL RATE GS OPA INCLUDING RIDERS",null,{"$f":"X67","v":3432},null,{"$f":"Z70","v":200718},null,null,null,{"$f":"AD72+AD79","v":1010819},null,{"$f":"AF72+AF79","v":100},null,{"$f":"AH72+AH79","v":462332},null,{"$f":"IF(AD81=0,\"0.0 \",ROUND((AH81/AD81)*100,1))","v":45.7},null,{"$f":"P38","v":1095318},null,{"$f":"AN72+AN79","v":2106137},null,{"$f":"IF(AN81=0,\"0.0 \",ROUND((AH81/AN81)*100,1))","v":22}]
[]
[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 $5.457/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 AUGUST 31, 2025"}]
[{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[{"$f":"DATA_TYPE","v":"DATA: _X_ BASE PERIOD   ___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":"6 MOS ACTUAL/6MOS 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,1771,null,null,null,{"$f":"PRO_FTL_CUST","v":430},null,{"$f":"ROUND((F22*J22),0)","v":761530},null,{"$f":"ROUND((L22/L$35)*100,1)","v":10.6},null,null,null,{"$f":"L22+P22","v":761530}]
[]
[4,null,"TRANSPORTATION CHARGE:"]
[5,null,"ALL CONSUMPTION",null,null,null,null,2797277,null,{"$f":"PRO_FTL_COM","v":2.2770000000000001},null,{"$f":"ROUND((H25*J25),0)","v":6369400},null,{"$f":"ROUND((L25/L$35)*100,1)","v":89},null,null,null,{"$f":"L25+P25","v":6369400}]
[]
[6,null,"RATE FT-LARGE EXCLUDING RIDERS",null,null,{"$f":"F22","v":1771},null,{"$f":"H25","v":2797277},null,null,null,{"$f":"SUM(L22:L25)","v":7130930},null,{"$f":"SUM(N22:N25)","v":99.6},null,null,null,{"$f":"SUM(R22:R25)","v":7130930}]
[]
[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":28532},null,{"$f":"ROUND((L30/L$35)*100,1)","v":0.4},null,null,null,{"$f":"L30+P30","v":28532}]
[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":3105},null,{"$f":"L31+P31","v":3105}]
[]
[10,null,"TOTAL RIDERS",null,null,null,null,null,null,null,null,{"$f":"SUM(L30:L31)","v":28532},null,{"$f":"ROUND((L33/L$35)*100,1)","v":0.4},null,{"$f":"SUM(P30:P31)","v":3105},null,{"$f":"SUM(R30:R31)","v":31637}]
[]
[11,null,"TOTAL RATE FT - L INCLUDING RIDERS",null,null,{"$f":"F22","v":1771},null,{"$f":"H25","v":2797277},null,null,null,{"$f":"L27+L33","v":7159462},null,{"$f":"SUM(N27+N33)","v":100},null,{"$f":"P27+P33","v":3105},null,{"$f":"R27+R33","v":7162567}]
[]
[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 AUGUST 31, 2025"}]
[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: _X_ BASE PERIOD   ___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":"6 MOS ACTUAL/6MOS 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":1771},null,null,null,{"$f":"CUR_FTL_CUST","v":430},null,{"$f":"ROUND(X60*AB60,0)","v":761530},null,{"$f":"IF(AD$73=0,\"0.0 \",ROUND((AD60/AD$73)*100,1))","v":11},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":761530},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":2797277},null,{"$f":"CUR_FTL_COM","v":2.1976},null,{"$f":"ROUND(Z63*AB63,0)","v":6147296},null,{"$f":"IF(AD$73=0,\"0.0 \",ROUND((AD63/AD$73)*100,1))","v":88.6},null,{"$f":"L25-AD63","v":222104},null,{"$f":"IF(AD63=0,\"0.0 \",ROUND((AH63/AD63)*100,1))","v":3.6},null,null,null,{"$f":"AD63+AL63","v":6147296},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":1771},null,{"$f":"Z63","v":2797277},null,null,null,{"$f":"SUM(AD60:AD63)","v":6908826},null,{"$f":"SUM(AF60:AF63)","v":99.6},null,{"$f":"SUM(AH60:AH63)","v":222104},null,{"$f":"IF(AD65=0,\"0.0 \",ROUND((AH65/AD65)*100,1))","v":3.2},null,null,null,{"$f":"SUM(AN60:AN63)","v":6908826},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":28532},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":28532},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) ",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":3105},null,{"$f":"AD69+AL69","v":3105},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":28532},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(AL68:AL69)","v":3105},null,{"$f":"SUM(AN68:AN69)","v":31637},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 - L INCLUDING RIDERS",null,{"$f":"X60","v":1771},null,{"$f":"Z63","v":2797277},null,null,null,{"$f":"SUM(AD65+AD71)","v":6937358},null,{"$f":"SUM(AF65+AF71)","v":100},null,{"$f":"SUM(AH65+AH71)","v":222104},null,{"$f":"IF(AD73=0,\"0.0 \",ROUND((AH73/AD73)*100,1))","v":3.2},null,{"$f":"SUM(AL65+AL71)","v":3105},null,{"$f":"SUM(AN65+AN71)","v":6940463},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 AUGUST 31, 2025"}]
[{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[{"$f":"DATA_TYPE","v":"DATA: _X_ BASE PERIOD   ___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":"6 MOS ACTUAL/6MOS FORECASTED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"B. L. Sailers"}]
["PROPOSED ANNUALIZED"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"PROPOSED",null,"% OF REV TO",null,null,null,"PROPOSED"]
[null,null,null,null,null,null,null,null,null,null,null,"REVENUE LESS",null,"TOTAL LESS",null,null,null,"TOTAL"]
["LINE",null,"RATE","CLASS /",null,"CUSTOMER",null,null,null,"PROPOSED",null,"GAS COST",null,"GAS COST",null,"GAS COST",null,"REVENUE"]
[" NO.",null,"CODE","DESCRIPTION",null,"BILLS",null,"SALES",null,"RATES",null,"REVENUE",null,"REVENUE",null,"REVENUE",null,"(F + H)"]
[null,null,"(A)","(B)",null,"(C)",null,"(D)",null,"(E)",null,"(F)",null,"(G)",null,"(H)",null,"(I)"]
[]
[null,null,null,null,null,null,null,"(MCF)",null,"($/MCF)",null,"($)",null,"(%)",null,"($)",null,"($)"]
[1,null,"IT"]
[2,null,"INTERRUPTIBLE TRANSPORTATION"]
[]
[3,null,"ADMINISTRATIVE CHARGE",null,null,226,null,null,null,{"$f":"PRO_IT_CUST","v":430},null,{"$f":"ROUND((F22*J22),0)","v":97180},null,{"$f":"ROUND((L22/L$34)*100,1)","v":4.8},null,null,null,{"$f":"L22+P22","v":97180}]
[]
[4,null,"COMMODITY CHARGE:"]
[5,null,"    ALL CONSUMPTION",null,null,null,null,1594408,null,{"$f":"PRO_IT_COM","v":1.1878},null,{"$f":"ROUND((H25*(J25)),0)","v":1893838},null,{"$f":"ROUND((L25/L$34)*100,1)","v":94.3},null,null,null,{"$f":"L25+P25","v":1893838}]
[]
[6,null,"RATE IT EXCLUDING RIDERS",null,null,{"$f":"F22","v":226},null,{"$f":"H25","v":1594408},null,null,null,{"$f":"SUM(L22:L25)","v":1991018},null,{"$f":"SUM(N22:N25)","v":99.1},null,null,null,{"$f":"SUM(R22:R25)","v":1991018}]
[]
[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":18336},null,{"$f":"ROUND((L30/L$34)*100,1)","v":0.9},null,null,null,{"$f":"L30+P30","v":18336}]
[]
[9,null,"TOTAL RIDERS",null,null,null,null,null,null,null,null,{"$f":"SUM(L29:L30)","v":18336},null,{"$f":"ROUND((L32/L$34)*100,1)","v":0.9},null,null,null,{"$f":"SUM(R29:R30)","v":18336}]
[]
[10,null,"TOTAL RATE IT TRANSPORTATION",null,null,{"$f":"F27","v":226},null,{"$f":"H27","v":1594408},null,null,null,{"$f":"L27+L32","v":2009354},null,{"$f":"ROUND((L34/L$34)*100,1)","v":100},null,null,null,{"$f":"R27+R32","v":2009354}]
[]
[]
[]
[]
[]
[]
[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 AUGUST 31, 2025"}]
[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: _X_ BASE PERIOD   ___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":"6 MOS ACTUAL/6MOS 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":5.0999999999999996},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":1594408},null,{"$f":"CUR_IT_COM","v":1.1300000000000001},null,{"$f":"ROUND(Z65*AB65,0)","v":1801681},null,{"$f":"ROUND((AD65/AD$74)*100,1)-0.1","v":93.9},null,{"$f":"L25-AD65","v":92157},null,{"$f":"IF(AD65=0,\"0.0 \",ROUND((AH65/AD65)*100,1))","v":5.0999999999999996},null,null,null,{"$f":"AD65+AL65","v":1801681},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":1594408},null,null,null,{"$f":"SUM(AD62:AD65)","v":1898861},null,{"$f":"SUM(AF62:AF65)","v":99},null,{"$f":"L27-AD67","v":92157},null,{"$f":"IF(AD67=0,\"0.0 \",ROUND((AH67/AD67)*100,1))","v":4.9000000000000004},null,null,null,{"$f":"SUM(AN62:AN65)","v":1898861},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":18336},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":18336},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":18336},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":18336},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":1594408},null,null,null,{"$f":"AD67+AD72","v":1917197},null,{"$f":"ROUND((AD74/AD$74)*100,1)","v":100},null,{"$f":"AH67+AH72","v":92157},null,{"$f":"IF(AD74=0,\"0.0 \",ROUND((AH74/AD74)*100,1))","v":4.8},null,null,null,{"$f":"AN67+AN72","v":1917197},null,{"$f":"IF(AN74=0,\"0.0 \",ROUND((AH74/AN74)*100,1))","v":4.8}]

{"sheet":"SCH N","index":12,"n_rows":103,"n_cols":14,"rows_kept":103,"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: _X_ BASE PERIOD   ___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":"6 MOS ACTUAL/6MOS 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 (1)",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":5.46},{"$f":"F20+K20","v":29.720000000000002},{"$f":"G20+K20","v":35.33},{"$f":"ROUND((M20-L20)/L20,3)*100","v":18.899999999999999}]
[3,null,null,"Applicable",3,37.18,47.02,9.8400000000000034,26.5,null,16.37,{"$f":"F21+K21","v":53.55},{"$f":"G21+K21","v":63.39},{"$f":"ROUND((M21-L21)/L21,3)*100","v":18.399999999999999}]
[4,null,null,null,6,56.56,72.739999999999995,16.179999999999993,28.599999999999998,null,32.74,89.300000000000011,105.47999999999999,18.099999999999998]
[5,null,null,null,8,69.48,89.89,20.409999999999997,29.4,null,43.66,113.14,133.55000000000001,18]
[6,null,null,null,10,82.4,107.04,24.64,29.9,null,54.57,136.97,161.61000000000001,18]
[7,null,null,null,12,95.32,124.19,28.870000000000005,30.3,null,65.48,160.80000000000001,189.67000000000002,18]
[8,null,null,null,16,121.16,158.47999999999999,37.319999999999993,30.8,null,87.31,208.47,245.79,17.899999999999999]
[9,null,null,null,20,147,192.78,45.78,31.1,null,109.14,256.14,301.92,17.899999999999999]
[10,null,null,null,30,211.6,278.51,66.91,31.6,null,163.71,375.31,442.22,17.8]
[11,null,null,null,40,276.2,364.25,88.050000000000011,31.900000000000002,null,218.28,494.48,582.53,17.8]
[12,null,null,null,50,340.79,449.99,109.19999999999999,32,null,272.85000000000002,613.6400000000001,722.84,17.8]
[13,null,null,null,60,405.39,535.73,130.34000000000003,32.200000000000003,null,327.42,732.81,863.15000000000009,17.8]
[14,null,null,null,80,534.59,707.2,172.61,32.300000000000004,null,436.56,971.15000000000009,1143.76,17.8]
[15,null,null,null,100,663.79,878.68,214.89,32.4,null,545.70000000000005,1209.49,1424.38,17.8]
[]
[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":27.29},{"$f":"F36+K36","v":105.50999999999999},{"$f":"G36+K36","v":123.43},{"$f":"ROUND((M36-L36)/L36,3)*100","v":17}]
[18,null,null,null,10,98.44,127.28,28.840000000000003,29.299999999999997,null,54.57,153.01,181.85,18.8]
[19,null,null,null,20,138.88999999999999,189.56,50.670000000000016,36.5,null,109.14,248.02999999999997,298.7,20.399999999999999]
[20,null,null,null,40,219.77,314.12,94.35,42.9,null,218.28,438.05,532.4,21.5]
[21,null,null,null,50,260.22000000000003,376.4,116.17999999999995,44.6,null,272.85000000000002,533.07000000000005,649.25,21.8]
[22,null,null,null,100,462.43,687.8,225.36999999999995,48.699999999999996,null,545.70000000000005,1008.1300000000001,1233.5,22.400000000000002]
[23,null,null,null,300,1271.29,1933.4,662.11000000000013,52.1,null,1637.1,2908.39,3570.5,22.8]
[24,null,null,null,500,2080.15,3179,1098.8499999999999,52.800000000000004,null,2728.5,4808.6499999999996,5907.5,22.900000000000002]
[25,null,null,null,700,2889.01,4424.6000000000004,1535.5900000000001,53.2,null,3819.9,6708.91,8244.5,22.900000000000002]
[26,null,null,null,850,3495.66,5358.8,1863.1400000000003,53.300000000000004,null,4638.45,8134.11,9997.25,22.900000000000002]
[27,null,null,null,1000,4102.3,6293,2190.6999999999998,53.400000000000006,null,5457,9559.2999999999993,11750,22.900000000000002]
[28,null,null,null,2000,8146.6,12521,4374.3999999999996,53.7,null,10914,19060.599999999999,23435,22.900000000000002]
[29,null,null,null,3000,12190.9,18749,6558.1,53.800000000000004,null,16371,28561.9,35120,23]
[]
[]
[null,null,{"$f":"\"(1) REFLECTS AVERAGE EXPECTED GAS COST OF \"&TEXT(EGC,\"$0.000\")&\"/MCF.\"","v":"(1) REFLECTS AVERAGE EXPECTED GAS COST OF $5.457/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: _X_ BASE PERIOD   ___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":"6 MOS ACTUAL/6MOS 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 (1)",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,"(FT-L)","Not"]
[2,null,"FIRM","Applicable",1000,{"$f":"ROUND(E74*(CUR_FTL_COM+CUR_FTL_PMM),2)+CUR_FTL_CUST","v":2637.8},{"$f":"ROUND(E74*(PRO_FTL_COM+PRO_FTL_PMM),2)+PRO_FTL_CUST","v":2717.2},{"$f":"G74-F74","v":79.399999999999636},{"$f":"ROUND(H74/F74,3)*100","v":3},null,{"$f":"ROUND(E74*PRO_FTL_GCAT,2)","v":37},{"$f":"F74+K74","v":2674.8},{"$f":"G74+K74","v":2754.2},{"$f":"ROUND((M74-L74)/L74,3)*100","v":3}]
[3,null,"TRANSPORTATION",null,1500,3741.7,3860.8,{"$f":"G75-F75","v":119.10000000000036},{"$f":"ROUND(H75/F75,3)*100","v":3.2},null,55.5,{"$f":"F75+K75","v":3797.2},{"$f":"G75+K75","v":3916.3},{"$f":"ROUND((M75-L75)/L75,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(E90*(CUR_IT_COM+CUR_IT_PMM),2)+CUR_IT_CUST","v":2713},{"$f":"ROUND(E90*(PRO_IT_COM+PRO_IT_PMM),2)+PRO_IT_CUST","v":2828.6},{"$f":"G90-F90","v":115.59999999999991},{"$f":"ROUND(H90/F90,3)*100","v":4.3},null,0,{"$f":"F90+K90","v":2713},{"$f":"G90+K90","v":2828.6},{"$f":"ROUND((M90-L90)/L90,3)*100","v":4.3}]
[18,null,"TRANSPORTATION",null,5000,6137.5,6426.5,{"$f":"G91-F91","v":289},{"$f":"ROUND(H91/F91,3)*100","v":4.7},null,0,{"$f":"F91+K91","v":6137.5},{"$f":"G91+K91","v":6426.5},{"$f":"ROUND((M91-L91)/L91,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"}]