{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["INPUT","PRINT","SCH M","SCH M-2.1","SCH M-2.2","SCH M-2.3","Rate RS","Rate GS COM","Rate GS IND","Rate GS OPA","Rate FT-LG","Rate IT","SCH N","Revenue Requirements","Proposed Rates","Avg Incr","Module1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":244,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Module1","index":16,"reason":"part_missing"}],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"INPUT","index":0,"n_rows":49,"n_cols":9,"rows_kept":49,"cut":false,"hidden":false,"merged":[[0,0,0,10]]}
[{"$f":"IF(H9=1,\"TEST PERIOD WITH RIDERS\",\"TEST PERIOD WITHOUT RIDERS\")","v":"TEST PERIOD WITH RIDERS"}]
[]
["Input Areas in Grey"]
[null,"12 MONTHS FORECASTED",null,{"$f":"IF(H9=1,\"INCLUDES ALL RIDERS\",\"\")","v":"INCLUDES ALL RIDERS"}]
[]
[null,"DUKE ENERGY KENTUCKY"]
[null,"CASE NO. 2021-00190"]
[null,"AUTOMATED RATE CASE FILING SYSTEM"]
[null,"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2022",null,null,null,null,null,1]
[]
[null,"TYPE OF SERVICE:","(GAS SERVICE)"]
[null,"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"]
[null,"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"]
[]
[null,"WITNESS:","J.L. Kern"]
[]
[null,"CURRENT RATES:"]
[null,"EXPECTED GAS COST:",4.0620000000000003]
[]
[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":0.45817000000000002},{"$f":"IF($H$9=1,H23,0)","v":0.45817000000000002},"$ per MCF",null,0.45817000000000002,0.45817000000000002,"$ per MCF"]
[null,"     Rate GS",{"$f":"IF($H$9=1,G24,0)","v":0},0,"$ per MCF",null,0,0,"$ per MCF"]
[]
[]
[]
[null,"Rider GCAT:","Current","Proposed",null,null,"Current","Proposed"]
[null,"     Rate FT-L",{"$f":"IF($H$9=1,G29,0)","v":-5.8000000000000003E-2},{"$f":"IF($H$9=1,H29,0)","v":-5.8000000000000003E-2},"$ per MCF",null,-5.8000000000000003E-2,-5.8000000000000003E-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",16.5,{"$f":"'Proposed Rates'!C14","v":19},"$ per Month"]
[null,"     Delivery Rate",4.6920000000000002,{"$f":"'Proposed Rates'!C20","v":5.5330000000000004},"$ per MCF"]
[]
[null,"Rate GS:","Current","Proposed"]
[null,"     Customer Charge",50,{"$f":"'Proposed Rates'!G14","v":58},"$ per Month"]
[null,"     Delivery Rate",2.9243000000000001,{"$f":"'Proposed Rates'!G22","v":4.2149000000000001},"$ per MCF"]
[]
[null,"Rate FT-L:","Current","Proposed"]
[null,"     Administrative Charge",430,{"$f":"'Proposed Rates'!K14","v":430},"$ per Month"]
[null,"     Delivery Rate",1.821,{"$f":"'Proposed Rates'!K22","v":2.3523999999999998},"$ per MCF"]
[]
[null,"Rate IT:","Current","Proposed"]
[null,"     Administrative Charge",430,{"$f":"'Proposed Rates'!O14","v":430},"$ per Month"]
[null,"     Commodity Charge",0.99819999999999998,{"$f":"'Proposed Rates'!O20","v":1.2626999999999999},"$ 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. 2021-00190"}]
["REVENUES AT PRESENT AND PROPOSED RATES"]
[{"$f":"TIME_PERIOD","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2022"}]
[{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[]
[{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,"SCHEDULE M"]
[{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,"PAGE  1  OF  1"]
["WORK PAPER REFERENCE NO(S).:",null,null,null,null,null,null,null,null,null,"WITNESS:"]
[{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"J.L. Kern"}]
[{"$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'!AN79","v":78691507},null,{"$f":"'Rate RS'!R38","v":86967381},null,{"$f":"G21-E21","v":8275874},null,{"$f":"IF(E21=0,\"0.00%\",ROUND(I21/E21,4))","v":0.1052}]
[3,null,"TOTAL RS",null,{"$f":"E21","v":78691507},null,{"$f":"G21","v":86967381},null,{"$f":"I21","v":8275874},null,{"$f":"IF(E22=0,\"0.00%\",ROUND(I22/E22,4))","v":0.1052}]
[]
[4,null,"GS COMMERCIAL",null,{"$f":"'Rate GS COM'!AN77","v":23890508},null,{"$f":"'Rate GS COM'!R37","v":28206657},null,{"$f":"G24-E24","v":4316149},null,{"$f":"IF(E24=0,\"0.00%\",ROUND(I24/E24,4))","v":0.1807}]
[5,null,"GS INDUSTRIAL",null,{"$f":"'Rate GS IND'!AN82","v":2459804},null,{"$f":"'Rate GS IND'!R37","v":2910650},null,{"$f":"G25-E25","v":450846},null,{"$f":"IF(E25=0,\"0.00%\",ROUND(I25/E25,4))","v":0.18329999999999999}]
[6,null,"GS OTHER PUB AUTH",null,{"$f":"'Rate GS OPA'!AN79","v":2147642},null,{"$f":"'Rate GS OPA'!R37","v":2541240},null,{"$f":"G26-E26","v":393598},null,{"$f":"IF(E26=0,\"0.00%\",ROUND(I26/E26,4))","v":0.18329999999999999}]
[7,null,"TOTAL GS",null,{"$f":"SUM(E24:E26)","v":28497954},null,{"$f":"SUM(G24:G26)","v":33658547},null,{"$f":"SUM(I24:I26)","v":5160593},null,{"$f":"IF(E27=0,\"0.00%\",ROUND(I27/E27,4))","v":0.18110000000000001}]
[]
[8,null,"     TOTAL SALES SERVICE",null,{"$f":"E22+E27","v":107189461},null,{"$f":"G22+G27","v":120625928},null,{"$f":"I22+I27","v":13436467},null,{"$f":"IF(E29=0,\"0.00%\",ROUND(I29/E29,4))","v":0.12540000000000001}]
[]
[9,null,"TRANSPORTATION:"]
[]
[10,null,"FT LARGE",null,{"$f":"'Rate FT-LG'!AN71","v":5444212},null,{"$f":"'Rate FT-LG'!R34","v":6898220},null,{"$f":"G33-E33","v":1454008},null,{"$f":"IF(E33=0,\"0.00%\",ROUND(I33/E33,4))","v":0.2671}]
[11,null,"IT",null,{"$f":"'Rate IT'!AN74","v":1782710},null,{"$f":"'Rate IT'!R34","v":2225007},null,{"$f":"G34-E34","v":442297},null,{"$f":"IF(E34=0,\"0.00%\",ROUND(I34/E34,4))","v":0.24809999999999999}]
[12,null,"     TOTAL TRANSPORTATION",null,{"$f":"SUM(E33:E34)","v":7226922},null,{"$f":"SUM(G33:G34)","v":9123227},null,{"$f":"SUM(I33:I34)","v":1896305},null,{"$f":"IF(E35=0,\"0.00%\",ROUND(I35/E35,4))","v":0.26240000000000002}]
[13,null,"TOTAL THROUGHPUT",null,{"$f":"E35+E29","v":114416383},null,{"$f":"G35+G29","v":129749155},null,{"$f":"I35+I29","v":15332772},null,{"$f":"IF(E36=0,\"0.00%\",ROUND(I36/E36,4))","v":0.13400000000000001}]
[14,null,"MISCELLANEOUS REVENUES:"]
[]
[15,null,"LATE PAYMENT CHARGES",null,{"$f":"'SCH M-2.2'!V37","v":0},null,{"$f":"'SCH M-2.3'!R37","v":0},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":27420},null,{"$f":"'SCH M-2.3'!R38","v":27420},null,0,null,"0.00%"]
[17,null,"RECONNECTION CHARGES",null,{"$f":"'SCH M-2.2'!V39","v":23364},null,{"$f":"'SCH M-2.3'!R39","v":28037},null,4673,null,0.2]
[18,null,"FIELD COLLECTION CHARGES",null,{"$f":"'SCH M-2.2'!V40","v":684},null,{"$f":"'SCH M-2.3'!R40","v":684},null,0,null,"0.00%"]
[19,null,"INTERDEPARTMENTAL",null,{"$f":"'SCH M-2.2'!V41","v":27765},null,{"$f":"'SCH M-2.3'!R41","v":32824.910029330524},null,5059.9100293305237,null,0.1822]
[20,null,"MINIMUM USE CONTRACT",null,{"$f":"'SCH M-2.2'!V42","v":258228},null,{"$f":"'SCH M-2.3'!R42","v":143553.67440000005},null,-114674.32559999995,null,-0.44409999999999999]
[21,null,"REVENUE TRANSP OF GAS-INTERCO",null,{"$f":"'SCH M-2.2'!V43","v":0},null,{"$f":"'SCH M-2.3'!R43","v":0},null,0,null,"0.00%"]
[22,null,"PROVISION FOR RATE REFUNDS",null,{"$f":"'SCH M-2.2'!V44","v":0},null,{"$f":"'SCH M-2.3'!R44","v":0},null,{"$f":"G46-E46","v":0},null,{"$f":"IF(I46=0,\"0.00%\",ROUND(I46/E46,4))","v":"0.00%"}]
[23,null,"OTHER MISC",null,{"$f":"'SCH M-2.2'!V45","v":528},null,{"$f":"'SCH M-2.3'!R45","v":528},null,0,null,"0.00%"]
[24,null,"   TOTAL MISCELLANEOUS",null,{"$f":"SUM(E39:E47)","v":337989},null,{"$f":"SUM(G39:G47)","v":233047.58442933057},null,{"$f":"SUM(I39:I47)","v":-104941.41557066943},null,-0.3105]
[]
[25,null,"TOTAL COMPANY REVENUE",null,{"$f":"E29++E35+E48","v":114754372},null,{"$f":"G29++G35+G48","v":129982202.58442932},null,{"$f":"I29++I35+I48","v":15227830.584429331},null,{"$f":"IF(I50=0,\"0.00%\",ROUND(I50/E50,4))","v":0.13270000000000001}]

{"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. 2021-00190"}]
["TEST PERIOD REVENUES AT CURRENT AVERAGE RATES"]
[{"$f":"TIME_PERIOD","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2022"}]
[{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE M-2.1"]
[{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PAGE  1  OF  1"]
["WORK PAPER REFERENCE NO(S).:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,{"$f":"INPUT!D4","v":"INCLUDES ALL RIDERS"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"J.L. Kern"}]
["TEST PERIOD"]
[]
[null,null,null,null,null,null,null,null,null,"TEST PERIOD",null,null,null,"% OF REV"]
[null,null,null,null,null,null,null,null,null,"REVENUE LESS",null,"CURRENT",null,"TO TOTAL",null,null,null,"TEST PERIOD"]
["LINE",null,"RATE","CLASS /",null,"CUSTOMER",null,null,null,"GAS COST",null,"AVERAGE",null,"EXCLUSIVE OF ",null,"GAS COST",null,"REVENUE",null,"% OF REV"]
[" NO.",null,"CODE","DESCRIPTION",null,"BILLS",null,"SALES",null,"REVENUE",null,"RATE",null,"GAS COST",null,"REVENUE",null,"TOTAL",null,"TO TOTAL"]
[null,null,"(A)","(B)",null,"(C)",null,"(D)",null,"(E)",null,"(F=E/D)",null,"(G)",null,"(H)",null,"(I)",null,"(J)"]
[]
[null,null,null,null,null,null,null,"(MCF)",null,"($)",null,"($/MCF)",null,"(%)",null,"($)",null,"($)",null,"(%)"]
[1,null,"RS","RESIDENTIAL SERVICE",null,{"$f":"'Rate RS'!X79","v":1130041},null,{"$f":"'Rate RS'!Z79","v":6481298},null,{"$f":"'Rate RS'!AD79","v":52364475},null,{"$f":"IF(H19=0,\"-\",ROUND(J19/H19,4))","v":8.0792999999999999},null,{"$f":"IF(ABS(J19/$J$34*100)<0.005,\"-\",ROUND(J19/$J$34*100,2))-0.01","v":70.47},null,{"$f":"'Rate RS'!AL79","v":26327032},null,{"$f":"J19+P19","v":78691507},null,{"$f":"IF(ABS(R19/$R$34*100)<0.005,\"-\",ROUND(R19/$R$34*100,2))","v":68.569999999999993}]
[2,null,"GS","GENERAL SERVICE COMMERCIAL",null,{"$f":"'Rate GS COM'!X77","v":78612},null,{"$f":"'Rate GS COM'!Z77","v":2857007},null,{"$f":"'Rate GS COM'!AD77","v":12285346},null,{"$f":"IF(H20=0,\"-\",ROUND(J20/H20,4))","v":4.3000999999999996},null,{"$f":"IF(ABS(J20/$J$34*100)<0.005,\"-\",ROUND(J20/$J$34*100,2))","v":16.54},null,{"$f":"'Rate GS COM'!AL77","v":11605162},null,{"$f":"J20+P20","v":23890508},null,20.82]
[3,null,"GS","GENERAL SERVICE INDUSTRIAL",null,{"$f":"'Rate GS IND'!X82","v":2879},null,{"$f":"'Rate GS IND'!Z82","v":331485},null,{"$f":"'Rate GS IND'!AD82","v":1113312},null,3.3586,null,1.5,null,{"$f":"'Rate GS IND'!AL82","v":1346492},null,2459804,null,2.14]
[4,null,"GS","GENERAL SERVICE OTHER PUB AUTH",null,{"$f":"'Rate GS OPA'!X79","v":2541},null,{"$f":"'Rate GS OPA'!Z79","v":289222},null,{"$f":"'Rate GS OPA'!AD79","v":972822},null,3.3635999999999999,null,1.31,null,{"$f":"'Rate GS OPA'!AL79","v":1174820},null,2147642,null,1.87]
[5,null,"FT-L","FIRM TRANSPORTATION-LARGE",null,{"$f":"'Rate FT-LG'!X71","v":1092},null,{"$f":"'Rate FT-LG'!Z71","v":2736182},null,{"$f":"'Rate FT-LG'!AD71","v":5452147},null,1.9925999999999999,null,7.34,null,{"$f":"'Rate FT-LG'!AL71","v":-7935},null,5444212,null,4.74]
[6,null,"IT","INTERRUPTIBLE TRANSPORTATION",null,{"$f":"'Rate IT'!X74","v":264},null,{"$f":"'Rate IT'!Z74","v":1672200},null,{"$f":"'Rate IT'!AD74","v":1782710},null,{"$f":"IF(H24=0,\"-\",ROUND(J24/H24,4))","v":1.0661},null,2.4,null,{"$f":"'Rate IT'!AL74","v":0},null,{"$f":"J24+P24","v":1782710},null,1.55]
[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":0},null,{"$f":"IF(H25=0,\"-\",ROUND(J25/H25,4))","v":"-"},null,"-",null,{"$f":"'SCH M-2.2'!T37","v":0},null,0,null,"-"]
[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":27420},null,"-",null,0.04,null,{"$f":"'SCH M-2.2'!T38","v":0},null,27420,null,0.02]
[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":23364},null,"-",null,0.03,null,{"$f":"'SCH M-2.2'!T39","v":0},null,23364,null,0.02]
[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":684},null,"-",null,"-",null,{"$f":"'SCH M-2.2'!T40","v":0},null,684,null,"-"]
[11,null,null,"INTERDEPARTMENTAL",null,{"$f":"'SCH M-2.2'!F41","v":0},null,{"$f":"'SCH M-2.2'!H41","v":4158},null,{"$f":"'SCH M-2.2'!L41","v":10875},null,2.6154000000000002,null,0.01,null,{"$f":"'SCH M-2.2'!T41","v":16890},null,27765,null,0.02]
[12,null,null,"MINIMUM USE CONTRACT",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":258228},null,"-",null,0.35,null,{"$f":"'SCH M-2.2'!T42","v":0},null,258228,null,0.23]
[13,null,null,"REVENUE TRANSP OF GAS-INTERCO",null,{"$f":"'SCH M-2.2'!F43","v":0},null,{"$f":"'SCH M-2.2'!H43","v":0},null,{"$f":"'SCH M-2.2'!L43","v":0},null,"-",null,"-",null,{"$f":"'SCH M-2.2'!T43","v":0},null,0,null,"-"]
[14,null,null,"PROVISION FOR RATE REFUNDS",null,{"$f":"'SCH M-2.2'!F44","v":0},null,{"$f":"'SCH M-2.2'!H44","v":0},null,{"$f":"'SCH M-2.2'!L44","v":0},null,{"$f":"IF(H32=0,\"-\",ROUND(J32/H32,4))","v":"-"},null,"-",null,{"$f":"'SCH M-2.2'!T44","v":0},null,{"$f":"J32+P32","v":0},null,"-"]
[15,null,null,"OTHER MISCELLANEOUS",null,{"$f":"'SCH M-2.2'!F45","v":0},null,{"$f":"'SCH M-2.2'!H45","v":0},null,{"$f":"'SCH M-2.2'!L45","v":528},null,"-",null,"-",null,{"$f":"'SCH M-2.2'!T45","v":0},null,528,null,"-"]
[16,null,"    TOTAL",null,null,{"$f":"SUM(F19:F33)","v":1215429},null,{"$f":"SUM(H19:H33)","v":14371552},null,{"$f":"SUM(J19:J33)","v":74291911},null,{"$f":"IF(H34=0,\"-\",ROUND(J34/H34,4))","v":5.1694000000000004},null,{"$f":"SUM(N19:N33)","v":99.990000000000009},null,{"$f":"SUM(P19:P33)","v":40462461},null,{"$f":"SUM(R19:R33)","v":114754372},null,{"$f":"SUM(T19:T33)","v":99.979999999999976}]
[]
[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. 2021-00190"}]
["ANNUALIZED REVENUES AT PROPOSED VS. MOST CURRENT RATES"]
[{"$f":"TIME_PERIOD","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2022"}]
[{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE M-2.2"]
[{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PAGE  1  OF  7"]
["WORK PAPER REFERENCE NO(S).:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,{"$f":"INPUT!D4","v":"INCLUDES ALL RIDERS"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"J.L. Kern"}]
["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'!X79","v":1130041},null,{"$f":"'Rate RS'!Z79","v":6481298},null,{"$f":"ROUND((L20/H20),4)","v":8.0792999999999999},null,{"$f":"'Rate RS'!AD79","v":52364475},null,{"$f":"ROUND((L20/L$21)*100,2)","v":100},null,{"$f":"'Rate RS'!AH79","v":8275874},null,{"$f":"IF(L20=0,\"0.0 \",ROUND((P20/L20)*100,1))","v":15.8},null,{"$f":"'Rate RS'!AL79","v":26327032},null,{"$f":"'Rate RS'!AN79","v":78691507},null,{"$f":"IF(V20=0,\"0.0 \",ROUND((P20/V20)*100,1))","v":10.5}]
[3,null,null,"  TOTAL RS",null,{"$f":"F20","v":1130041},null,{"$f":"H20","v":6481298},null,{"$f":"ROUND((L21/H21),4)","v":8.0792999999999999},null,{"$f":"L20","v":52364475},null,{"$f":"ROUND((L21/$L48)*100,2)+0.01","v":70.490000000000009},null,{"$f":"P20","v":8275874},null,{"$f":"IF(L21=0,\"0.0 \",ROUND((P21/L21)*100,1))","v":15.8},null,{"$f":"T20","v":26327032},null,{"$f":"V20","v":78691507},null,{"$f":"IF(V21=0,\"0.0 \",ROUND((P21/V21)*100,1))","v":10.5}]
[]
[4,null,"GS","COMMERCIAL",null,{"$f":"'Rate GS COM'!X77","v":78612},null,{"$f":"'Rate GS COM'!Z77","v":2857007},null,{"$f":"ROUND((L23/H23),4)","v":4.3000999999999996},null,{"$f":"'Rate GS COM'!AD77","v":12285346},null,{"$f":"ROUND((L23/$L26)*100,2)","v":85.48},null,{"$f":"'Rate GS COM'!AH77","v":4316149},null,{"$f":"IF(L23=0,\"0.0 \",ROUND((P23/L23)*100,1))","v":35.1},null,{"$f":"'Rate GS COM'!AL77","v":11605162},null,{"$f":"'Rate GS COM'!AN77","v":23890508},null,{"$f":"IF(V23=0,\"0.0 \",ROUND((P23/V23)*100,1))","v":18.100000000000001}]
[5,null,"GS","INDUSTRIAL",null,{"$f":"'Rate GS IND'!X82","v":2879},null,{"$f":"'Rate GS IND'!Z82","v":331485},null,{"$f":"ROUND((L24/H24),4)","v":3.3586},null,{"$f":"'Rate GS IND'!AD82","v":1113312},null,{"$f":"ROUND((L24/$L26)*100,2)","v":7.75},null,{"$f":"'Rate GS IND'!AH82","v":450846},null,{"$f":"IF(L24=0,\"0.0 \",ROUND((P24/L24)*100,1))","v":40.5},null,{"$f":"'Rate GS IND'!AL82","v":1346492},null,{"$f":"'Rate GS IND'!AN82","v":2459804},null,{"$f":"IF(V24=0,\"0.0 \",ROUND((P24/V24)*100,1))","v":18.3}]
[6,null,"GS","OTH PUB AUTH",null,{"$f":"'Rate GS OPA'!X79","v":2541},null,{"$f":"'Rate GS OPA'!Z79","v":289222},null,{"$f":"ROUND((L25/H25),4)","v":3.3635999999999999},null,{"$f":"'Rate GS OPA'!AD79","v":972822},null,{"$f":"ROUND((L25/$L26)*100,2)","v":6.77},null,{"$f":"'Rate GS OPA'!AH79","v":393598},null,{"$f":"IF(L25=0,\"0.0 \",ROUND((P25/L25)*100,1))","v":40.5},null,{"$f":"'Rate GS OPA'!AL79","v":1174820},null,{"$f":"'Rate GS OPA'!AN79","v":2147642},null,{"$f":"IF(V25=0,\"0.0 \",ROUND((P25/V25)*100,1))","v":18.3}]
[7,null,null,"   TOTAL GS",null,{"$f":"SUM(F23:F25)","v":84032},null,{"$f":"SUM(H23:H25)","v":3477714},null,{"$f":"ROUND((L26/H26),4)","v":4.1325000000000003},null,{"$f":"SUM(L23:L25)","v":14371480},null,{"$f":"ROUND((L26/$L48)*100,2)","v":19.34},null,{"$f":"SUM(P23:P25)","v":5160593},null,{"$f":"IF(L26=0,\"0.0 \",ROUND((P26/L26)*100,1))","v":35.9},null,{"$f":"SUM(T23:T25)","v":14126474},null,{"$f":"SUM(V23:V25)","v":28497954},null,{"$f":"IF(V26=0,\"0.0 \",ROUND((P26/V26)*100,1))","v":18.100000000000001}]
[]
[8,null,"  TOTAL SALES SERVICE",null,null,{"$f":"F21+F26","v":1214073},null,{"$f":"H21+H26","v":9959012},null,{"$f":"ROUND((L28/H28),4)","v":6.7011000000000003},null,{"$f":"L21+L26","v":66735955},null,{"$f":"100-N33-N46","v":89.83},null,{"$f":"P21+P26","v":13436467},null,{"$f":"IF(L28=0,\"0.0 \",ROUND((P28/L28)*100,1))","v":20.100000000000001},null,{"$f":"T21+T26","v":40453506},null,{"$f":"V21+V26","v":107189461},null,{"$f":"IF(V28=0,\"0.0 \",ROUND((P28/V28)*100,1))","v":12.5}]
[]
[9,null,"TRANSPORTATION SERVICE:"]
[10,null,"FT-L","FIRM TRANSP - LARGE",null,{"$f":"'Rate FT-LG'!X71","v":1092},null,{"$f":"'Rate FT-LG'!Z71","v":2736182},null,{"$f":"ROUND((L31/H31),4)","v":1.9925999999999999},null,{"$f":"'Rate FT-LG'!AD71","v":5452147},null,{"$f":"ROUND((L31/L$33)*100,2)","v":75.36},null,{"$f":"'Rate FT-LG'!AH71","v":1454008},null,{"$f":"IF(L31=0,\"0.0 \",ROUND((P31/L31)*100,1))","v":26.7},null,{"$f":"'Rate FT-LG'!AL71","v":-7935},null,{"$f":"'Rate FT-LG'!AN71","v":5444212},null,{"$f":"IF(V31=0,\"0.0 \",ROUND((P31/V31)*100,1))","v":26.7}]
[11,null,"IT","INTERRUPTIBLE TRANSP",null,{"$f":"'Rate IT'!X74","v":264},null,{"$f":"'Rate IT'!Z74","v":1672200},null,{"$f":"ROUND((L32/H32),4)","v":1.0661},null,{"$f":"'Rate IT'!AD74","v":1782710},null,{"$f":"ROUND((L32/L$33)*100,2)","v":24.64},null,{"$f":"'Rate IT'!AH74","v":442297},null,{"$f":"IF(L32=0,\"0.0 \",ROUND((P32/L32)*100,1))","v":24.8},null,{"$f":"'Rate IT'!AL74","v":0},null,{"$f":"'Rate IT'!AN74","v":1782710},null,{"$f":"IF(V32=0,\"0.0 \",ROUND((P32/V32)*100,1))","v":24.8}]
[12,null,"  TOTAL TRANSP SERVICE",null,null,{"$f":"SUM(F31:F32)","v":1356},null,{"$f":"SUM(H31:H32)","v":4408382},null,{"$f":"ROUND((L33/H33),4)","v":1.6412},null,{"$f":"SUM(L31:L32)","v":7234857},null,{"$f":"ROUND((L33/L$48)*100,2)","v":9.74},null,{"$f":"SUM(P31:P32)","v":1896305},null,{"$f":"IF(L33=0,\"0.0 \",ROUND((P33/L33)*100,1))","v":26.2},null,{"$f":"SUM(T31:T32)","v":-7935},null,{"$f":"SUM(V31:V32)","v":7226922},null,{"$f":"IF(V33=0,\"0.0 \",ROUND((P33/V33)*100,1))","v":26.2}]
[13,null,"TOTAL THROUGHPUT",null,null,{"$f":"F28+F33","v":1215429},null,{"$f":"H28+H33","v":14367394},null,{"$f":"ROUND((L34/H34),4)","v":5.1485000000000003},null,{"$f":"L28+L33","v":73970812},null,{"$f":"N28+N33","v":99.57},null,{"$f":"P28+P33","v":15332772},null,{"$f":"IF(L34=0,\"0.0 \",ROUND((P34/L34)*100,1))","v":20.7},null,{"$f":"T28+T33","v":40445571},null,{"$f":"V28+V33","v":114416383},null,{"$f":"IF(V34=0,\"0.0 \",ROUND((P34/V34)*100,1))","v":13.4}]
[]
[14,null,"MISCELLANEOUS REVENUES: "]
[15,null,"LATE PAYMENT CHARGES",null,null,0,null,0,null,null,null,0,null,{"$f":"ROUND((L37/L$46)*100,2)","v":0},null,{"$f":"'SCH M-2.3'!L37-'SCH M-2.2'!L37","v":0},null,null,null,0,null,{"$f":"L37+T37","v":0}]
[16,null,"BAD CHECK CHARGES",null,null,0,null,0,null,null,null,27420,null,8.5399999999999991,null,{"$f":"'SCH M-2.3'!L38-'SCH M-2.2'!L38","v":0},null,null,null,0,null,27420]
[17,null,"RECONNECTION CHARGES",null,null,0,null,0,null,null,null,23364,null,7.28,null,{"$f":"'SCH M-2.3'!L39-'SCH M-2.2'!L39","v":4673},null,null,null,0,null,23364]
[18,null,"FIELD COLLECTION CHARGES",null,null,0,null,0,null,null,null,684,null,0.21,null,{"$f":"'SCH M-2.3'!L40-'SCH M-2.2'!L40","v":0},null,null,null,0,null,684]
[19,null,"INTERDEPARTMENTAL",null,null,0,null,4158,null,null,null,{"$f":"ROUND(V41-(H41*EGC),0)","v":10875},null,{"$f":"ROUND((L41/L$46)*100,2)","v":3.39},null,{"$f":"'SCH M-2.3'!L41-'SCH M-2.2'!L41","v":5059.9100293305237},null,null,null,{"$f":"V41-L41","v":16890},null,27765]
[20,null,"MINIMUM USE CONTRACT",null,null,0,null,0,null,null,null,258228,null,80.42,null,{"$f":"'SCH M-2.3'!L42-'SCH M-2.2'!L42","v":-114674.32559999995},null,null,null,0,null,258228]
[21,null,"REVENUE TRANSP OF GAS-INTERCO",null,null,0,null,0,null,null,null,0,null,0,null,{"$f":"'SCH M-2.3'!L43-'SCH M-2.2'!L43","v":0},null,null,null,0,null,0]
[22,null,"PROVISION FOR RATE REFUNDS",null,null,0,null,0,null,null,null,0,null,0,null,{"$f":"'SCH M-2.3'!L44-'SCH M-2.2'!L44","v":0},null,null,null,0,null,{"$f":"L44+T44","v":0}]
[23,null,"OTHER MISC",null,null,0,null,0,null,null,null,528,null,0.16,null,{"$f":"'SCH M-2.3'!L45-'SCH M-2.2'!L45","v":0},null,null,null,0,null,528]
[24,null,"  TOTAL MISC",null,null,{"$f":"SUM(F37:F45)","v":0},null,{"$f":"SUM(H37:H45)","v":4158},null,null,null,{"$f":"SUM(L37:L45)","v":321099},null,{"$f":"ROUND((L46/L$48)*100,2)","v":0.43},null,{"$f":"SUM(P37:P45)","v":-104941.41557066943},null,{"$f":"IF(L46=0,\"0.0 \",ROUND((P46/L46)*100,1))","v":-32.700000000000003},null,{"$f":"SUM(T37:T45)","v":16890},null,{"$f":"SUM(V37:V45)","v":337989},null,{"$f":"IF(V46=0,\"0.0 \",ROUND((P46/V46)*100,1))","v":-31}]
[]
[25,null,"    TOTAL COMPANY",null,null,{"$f":"F28+F33+F46","v":1215429},null,{"$f":"H28+H33+H46","v":14371552},null,{"$f":"ROUND((L48/H48),4)","v":5.1694000000000004},null,{"$f":"L28+L33+L46","v":74291911},null,100,null,{"$f":"P28+P33+P46","v":15227830.584429331},null,{"$f":"IF(L48=0,\"0.0 \",ROUND((P48/L48)*100,1))","v":20.5},null,{"$f":"T28+T33+T46","v":40462461},null,{"$f":"V28+V33+V46","v":114754372},null,{"$f":"IF(V48=0,\"0.0 \",ROUND((P48/V48)*100,1))","v":13.3}]
[]
[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 $4.062/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. 2021-00190"}]
["ANNUALIZED REVENUES AT PROPOSED VS. MOST CURRENT RATES"]
[{"$f":"TIME_PERIOD","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2022"}]
[{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE M-2.3"]
[{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PAGE  1  OF  7"]
["WORK PAPER REFERENCE NO(S).: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,{"$f":"INPUT!D4","v":"INCLUDES ALL RIDERS"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"J.L. Kern"}]
["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'!F38","v":1130041},null,{"$f":"'Rate RS'!H38","v":6481298},null,{"$f":"IF(F20=0,\"0.0 \",ROUND((L20/H20),4))","v":9.3561999999999994},null,{"$f":"'Rate RS'!L38","v":60640349},null,{"$f":"ROUND((L20/L$21)*100,2)","v":100},null,{"$f":"'Rate RS'!P38","v":26327032},null,{"$f":"'Rate RS'!R38","v":86967381}]
[3,null,null,"  TOTAL RS",null,{"$f":"F20","v":1130041},null,{"$f":"H20","v":6481298},null,{"$f":"IF(F21=0,\"0.0 \",ROUND((L21/H21),4))","v":9.3561999999999994},null,{"$f":"L20","v":60640349},null,{"$f":"ROUND((L21/L$48)*100,2)","v":67.739999999999995},null,{"$f":"P20","v":26327032},null,{"$f":"R20","v":86967381}]
[]
[4,null,"GS","COMMERCIAL",null,{"$f":"'Rate GS COM'!F37","v":78612},null,{"$f":"'Rate GS COM'!H37","v":2857007},null,{"$f":"IF(F23=0,\"0.0 \",ROUND((L23/H23),4))","v":5.8108000000000004},null,{"$f":"'Rate GS COM'!L37","v":16601495},null,{"$f":"ROUND((L23/L$26)*100,2)","v":85},null,{"$f":"'Rate GS COM'!P37","v":11605162},null,{"$f":"'Rate GS COM'!R37","v":28206657}]
[5,null,"GS","INDUSTRIAL",null,{"$f":"'Rate GS IND'!F37","v":2879},null,{"$f":"'Rate GS IND'!H37","v":331485},null,{"$f":"IF(F24=0,\"0.0 \",ROUND((L24/H24),4))","v":4.7186000000000003},null,{"$f":"'Rate GS IND'!L37","v":1564158},null,{"$f":"ROUND((L24/L$26)*100,2)","v":8.01},null,{"$f":"'Rate GS IND'!P37","v":1346492},null,{"$f":"'Rate GS IND'!R37","v":2910650}]
[6,null,"GS","OTH PUB AUTH",null,{"$f":"'Rate GS OPA'!F37","v":2541},null,{"$f":"'Rate GS OPA'!H37","v":289222},null,{"$f":"IF(F25=0,\"0.0 \",ROUND((L25/H25),4))","v":4.7244999999999999},null,{"$f":"'Rate GS OPA'!L37","v":1366420},null,{"$f":"ROUND((L25/L$26)*100,2)","v":7},null,{"$f":"'Rate GS OPA'!P37","v":1174820},null,{"$f":"'Rate GS OPA'!R37","v":2541240}]
[7,null,null,"   TOTAL GS",null,{"$f":"SUM(F23:F25)","v":84032},null,{"$f":"SUM(H23:H25)","v":3477714},null,{"$f":"IF(F26=0,\"0.0 \",ROUND((L26/H26),4))","v":5.6163999999999996},null,{"$f":"SUM(L23:L25)","v":19532073},null,{"$f":"ROUND((L26/L$48)*100,2)","v":21.82},null,{"$f":"SUM(P23:P25)","v":14126474},null,{"$f":"SUM(R23:R25)","v":33658547}]
[]
[8,null,"  TOTAL SALES SERVICE",null,null,{"$f":"F21+F26","v":1214073},null,{"$f":"H21+H26","v":9959012},null,{"$f":"IF(F28=0,\"0.0 \",ROUND((L28/H28),4))","v":8.0502000000000002},null,{"$f":"L21+L26","v":80172422},null,{"$f":"ROUND((L28/L$48)*100,2)","v":89.56},null,{"$f":"P21+P26","v":40453506},null,{"$f":"R21+R26","v":120625928}]
[]
[9,null,"TRANSPORTATION SERVICE:"]
[10,null,"FT-L","FIRM TRANSP - LARGE",null,{"$f":"'Rate FT-LG'!F34","v":1092},null,{"$f":"'Rate FT-LG'!H34","v":2736182},null,{"$f":"IF(F31=0,\"0.0 \",ROUND((L31/H31),4))","v":2.524},null,{"$f":"'Rate FT-LG'!L34","v":6906155},null,{"$f":"ROUND((L31/L$33)*100,2)","v":75.63},null,{"$f":"'Rate FT-LG'!P34","v":-7935},null,{"$f":"'Rate FT-LG'!R34","v":6898220}]
[11,null,"IT","INTERRUPTIBLE TRANSP",null,{"$f":"'Rate IT'!F34","v":264},null,{"$f":"'Rate IT'!H34","v":1672200},null,{"$f":"IF(F32=0,\"0.0 \",ROUND((L32/H32),4))","v":1.3306},null,{"$f":"'Rate IT'!L34","v":2225007},null,{"$f":"ROUND((L32/L$33)*100,2)","v":24.37},null,{"$f":"'Rate IT'!P34","v":0},null,{"$f":"'Rate IT'!R34","v":2225007}]
[12,null,"  TOTAL TRANSP SERVICE",null,null,{"$f":"SUM(F31:F32)","v":1356},null,{"$f":"SUM(H31:H32)","v":4408382},null,{"$f":"IF(F33=0,\"0.0 \",ROUND((L33/H33),4))","v":2.0712999999999999},null,{"$f":"SUM(L31:L32)","v":9131162},null,{"$f":"ROUND((L33/L$48)*100,2)","v":10.199999999999999},null,{"$f":"SUM(P31:P32)","v":-7935},null,{"$f":"SUM(R31:R32)","v":9123227}]
[13,null,"TOTAL THROUGHPUT",null,null,{"$f":"F28+F33","v":1215429},null,{"$f":"H28+H33","v":14367394},null,{"$f":"IF(F34=0,\"0.0 \",ROUND((L34/H34),4))","v":6.2157},null,{"$f":"L28+L33","v":89303584},null,{"$f":"N28+N33","v":99.76},null,{"$f":"P28+P33","v":40445571},null,{"$f":"R28+R33","v":129749155}]
[]
[14,null,"MISCELLANEOUS REVENUES: "]
[15,null,"LATE PAYMENT CHARGES",null,null,0,null,0,null,null,null,0,null,{"$f":"ROUND((L37/L$46)*100,2)","v":0},null,0,null,{"$f":"L37+P37","v":0}]
[16,null,"BAD CHECK CHARGES",null,null,0,null,0,null,null,null,{"$f":"'SCH M-2.2'!L38","v":27420},null,12.69,null,0,null,27420]
[17,null,"RECONNECTION CHARGES",null,null,0,null,0,null,null,null,{"$f":"'SCH M-2.2'!L39+4673","v":28037},null,12.97,null,0,null,28037]
[18,null,"FIELD COLLECTION CHARGES",null,null,0,null,0,null,null,null,{"$f":"'SCH M-2.2'!L40","v":684},null,0.32,null,0,null,684]
[19,null,"INTERDEPARTMENTAL",null,null,{"$f":"'SCH M-2.2'!F41","v":0},null,{"$f":"'SCH M-2.2'!H41","v":4158},null,null,null,{"$f":"R41-P41","v":15934.910029330524},null,7.37,null,{"$f":"'SCH M-2.2'!T41","v":16890},null,{"$f":"'Proposed Rates'!G30","v":32824.910029330524}]
[20,null,"MINIMUM USE CONTRACT",null,null,{"$f":"'SCH M-2.2'!F42","v":0},null,{"$f":"'SCH M-2.2'!H42","v":0},null,null,null,{"$f":"'Proposed Rates'!K31","v":143553.67440000005},null,66.41,null,0,null,143553.67440000005]
[21,null,"REVENUE TRANSP OF GAS-INTERCO",null,null,0,null,{"$f":"'SCH M-2.2'!H43","v":0},null,null,null,{"$f":"'SCH M-2.2'!L43","v":0},null,0,null,0,null,0]
[22,null,"PROVISION FOR RATE REFUNDS",null,null,0,null,{"$f":"'SCH M-2.2'!H44","v":0},null,null,null,{"$f":"'SCH M-2.2'!L44","v":0},null,0,null,0,null,0]
[23,null,"OTHER MISC",null,null,0,null,0,null,null,null,{"$f":"'SCH M-2.2'!L45","v":528},null,0.24,null,0,null,528]
[24,null,"  TOTAL MISC",null,null,{"$f":"SUM(F37:F45)","v":0},null,{"$f":"SUM(H37:H45)","v":4158},null,null,null,{"$f":"SUM(L37:L45)","v":216157.58442933057},null,{"$f":"ROUND((L46/L$48)*100,2)","v":0.24},null,{"$f":"SUM(P37:P45)","v":16890},null,{"$f":"SUM(R37:R45)","v":233047.58442933057}]
[]
[25,null,"    TOTAL COMPANY",null,null,{"$f":"F28+F33+F46","v":1215429},null,{"$f":"H28+H33+H46","v":14371552},null,{"$f":"IF(F48=0,\"0.0 \",ROUND((L48/H48),4))","v":6.2290000000000001},null,{"$f":"L28+L33+L46","v":89519741.584429324},null,100,null,{"$f":"P28+P33+P46","v":40462461},null,{"$f":"R28+R33+R46","v":129982202.58442932}]
[]
[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 $4.062/MCF."}]

{"sheet":"Rate RS","index":6,"n_rows":83,"n_cols":42,"rows_kept":83,"cut":false,"hidden":false,"merged":[]}
[{"$f":"COMPANY","v":"DUKE ENERGY KENTUCKY"}]
[{"$f":"CASE","v":"CASE NO. 2021-00190"}]
["ANNUALIZED REVENUES AT PROPOSED VS. MOST CURRENT RATES"]
[{"$f":"TIME_PERIOD","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2022"}]
[{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE M-2.3"]
[{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PAGE  2  OF  7"]
["WORK PAPER REFERENCE NO(S).:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"J.L. Kern"}]
["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,1130041,null,null,null,{"$f":"PRO_RS_CUST","v":19},null,{"$f":"ROUND(F24*J24,0)","v":21470779},null,{"$f":"ROUND((L24/$L$38)*100,1)","v":35.4},null,null,null,{"$f":"L24+P24","v":21470779}]
[]
[6,null,"COMMODITY CHARGE:"]
[7,null,"     ALL CONSUMPTION",null,null,null,null,6481298,2.64,{"$f":"PRO_RS_COM","v":5.5330000000000004},null,{"$f":"ROUND((H27*J27),0)","v":35861022},null,{"$f":"ROUND((L27/$L$38)*100,1)","v":59.1},null,{"$f":"ROUND(H27*EGC,0)","v":26327032},null,{"$f":"L27+P27","v":62188054}]
[]
[8,null,"RATE RS EXCLUDING RIDERS",null,null,{"$f":"F24","v":1130041},null,{"$f":"H27","v":6481298},null,null,null,{"$f":"SUM(L24:L27)","v":57331801},null,{"$f":"ROUND((L29/$L$38)*100,1)","v":94.5},null,{"$f":"SUM(P24:P27)","v":26327032},null,{"$f":"SUM(R24:R27)","v":83658833}]
[]
[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":339012},null,{"$f":"ROUND((L32/$L$38)*100,1)","v":0.6},null,null,null,{"$f":"L32+P32","v":339012}]
[11,null,"DEMAND SIDE MANAGEMENT RATE (DSMR)",null,null,null,null,null,null,{"$f":"PRO_RS_DSM","v":0.45817000000000002},null,{"$f":"ROUND(H27*J33,0)","v":2969536},null,{"$f":"ROUND((L33/$L$38)*100,1)","v":4.9000000000000004},null,null,null,{"$f":"L33+P33","v":2969536}]
[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$38)*100,1)","v":0},null,null,null,{"$f":"L34+P34","v":0}]
[]
[13,null,"TOTAL RIDERS",null,null,null,null,null,null,null,null,{"$f":"SUM(L32:L34)","v":3308548},null,{"$f":"ROUND((L36/$L$38)*100,1)","v":5.5},null,null,null,{"$f":"SUM(R32:R34)","v":3308548}]
[]
[14,null,"TOTAL RATE RS RESIDENTIAL INCLUDING RIDERS",null,null,{"$f":"F24","v":1130041},null,{"$f":"H27","v":6481298},null,null,null,{"$f":"L29+L36","v":60640349},null,{"$f":"SUM(N29+N36)","v":100},null,{"$f":"P29+P36","v":26327032},null,{"$f":"R29+R36","v":86967381}]
[]
[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 $4.062/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. 2021-00190"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANNUALIZED TEST YEAR REVENUES AT PROPOSED VS. MOST CURRENT RATES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TIME_PERIOD","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2022"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE M-2.2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R7","v":"PAGE  2  OF  7"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WORK PAPER REFERENCE NO(S).:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"J.L. Kern"}]
[null,null,null,null,null,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":1130041},null,null,null,{"$f":"CUR_RS_CUST","v":16.5},null,{"$f":"ROUND(X65*AB65,0)","v":18645677},null,{"$f":"ROUND((AD65/$AD$79)*100,1)","v":35.6},null,{"$f":"L24-AD65","v":2825102},null,{"$f":"IF(AD65=0,\"0.0 \",ROUND((AH65/AD65)*100,1))","v":15.2},null,null,null,{"$f":"AD65+AL65","v":18645677},null,{"$f":"IF(AN65=0,\"0.0 \",ROUND((AH65/AN65)*100,1))","v":15.2}]
[]
[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":6481298},null,{"$f":"CUR_RS","v":4.6920000000000002},null,{"$f":"ROUND((Z68*AB68),0)","v":30410250},null,{"$f":"ROUND((AD68/$AD$79)*100,1)","v":58.1},null,{"$f":"L27-AD68","v":5450772},null,{"$f":"IF(AD68=0,\"0.0 \",ROUND((AH68/AD68)*100,1))","v":17.899999999999999},null,{"$f":"P27","v":26327032},null,{"$f":"AD68+AL68","v":56737282},null,{"$f":"IF(AN68=0,\"0.0 \",ROUND((AH68/AN68)*100,1))","v":9.6}]
[]
[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":"X65","v":1130041},null,{"$f":"Z68","v":6481298},null,null,null,{"$f":"SUM(AD65:AD68)","v":49055927},null,{"$f":"ROUND((AD70/$AD$79)*100,1)","v":93.7},null,{"$f":"SUM(AH65:AH68)","v":8275874},null,{"$f":"IF(AD70=0,\"0.0 \",ROUND((AH70/AD70)*100,1))","v":16.899999999999999},null,{"$f":"SUM(AL65:AL68)","v":26327032},null,{"$f":"SUM(AN65:AN68)","v":75382959},null,{"$f":"IF(AN70=0,\"0.0 \",ROUND((AH70/AN70)*100,1))","v":11}]
[]
[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(X65*CUR_RS_HEA,0)","v":339012},null,{"$f":"ROUND((AD73/$AD$79)*100,1)","v":0.6},null,{"$f":"L32-AD73","v":0},null,{"$f":"IF(AD73=0,\"0.0 \",ROUND((AH73/AD73)*100,1))","v":0},null,null,null,{"$f":"AD73+AL73","v":339012},null,{"$f":"IF(AN73=0,\"0.0 \",ROUND((AH73/AN73)*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":0.45817000000000002},null,{"$f":"ROUND(Z68*AB74,0)","v":2969536},null,{"$f":"ROUND((AD74/$AD$79)*100,1)","v":5.7},null,{"$f":"L33-AD74","v":0},null,{"$f":"IF(AD74=0,\"0.0 \",ROUND((AH74/AD74)*100,1))","v":0},null,null,null,{"$f":"AD74+AL74","v":2969536},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,{"$f":"A34","v":12},null,"WEATHER NORMALIZATION ADJUSTMENT (WNA)",null,null,null,null,null,0,null,{"$f":"ROUND(Z70*AB75,0)","v":0},null,{"$f":"ROUND((AD75/$AD$79)*100,1)","v":0},null,{"$f":"L34-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":"A36","v":13},null,"TOTAL RIDERS",null,null,null,null,null,null,null,{"$f":"SUM(AD73:AD75)","v":3308548},null,{"$f":"ROUND((AD77/$AD$79)*100,1)","v":6.3},null,{"$f":"SUM(AH73:AH75)","v":0},null,{"$f":"IF(AD77=0,\"0.0 \",ROUND((AH77/AD77)*100,1))","v":0},null,null,null,{"$f":"SUM(AN73:AN75)","v":3308548},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 RS RESIDENTIAL INCLUDING RIDERS",null,{"$f":"X65","v":1130041},null,{"$f":"Z68","v":6481298},null,null,null,{"$f":"AD70+AD77","v":52364475},null,{"$f":"SUM(AF70+AF77)","v":100},null,{"$f":"AH70+AH77","v":8275874},null,{"$f":"IF(AD79=0,\"0.0 \",ROUND((AH79/AD79)*100,1))","v":15.8},null,{"$f":"P38","v":26327032},null,{"$f":"AN70+AN77","v":78691507},null,{"$f":"IF(AN79=0,\"0.0 \",ROUND((AH79/AN79)*100,1))","v":10.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 $4.062/MCF."}]

{"sheet":"Rate GS COM","index":7,"n_rows":210,"n_cols":42,"rows_kept":210,"cut":false,"hidden":false,"merged":[]}
[{"$f":"COMPANY","v":"DUKE ENERGY KENTUCKY"}]
[{"$f":"CASE","v":"CASE NO. 2021-00190"}]
["ANNUALIZED REVENUES AT PROPOSED VS. MOST CURRENT RATES"]
[{"$f":"TIME_PERIOD","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2022"}]
[{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE M-2.3"]
[{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PAGE  3  OF  7"]
["WORK PAPER REFERENCE NO(S).:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"J.L. Kern"}]
["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,78612,null,null,null,{"$f":"PRO_GS_CUST","v":58},null,{"$f":"ROUND(F24*J24,0)","v":4559496},null,{"$f":"ROUND((L24/$L$37)*100,1)","v":27.5},null,null,null,{"$f":"L24+P24","v":4559496}]
[]
[6,null,"COMMODITY CHARGE:"]
[7,null,"     ALL CONSUMPTION",null,null,null,null,2857007,null,{"$f":"PRO_GS","v":4.2149000000000001},null,{"$f":"ROUND((H27*J27),0)","v":12041999},null,{"$f":"ROUND((L27/$L$37)*100,1)","v":72.5},null,{"$f":"ROUND(H27*EGC,0)","v":11605162},null,{"$f":"L27+P27","v":23647161}]
[]
[8,null,"RATE GS COMMERCIAL EXCLUDING RIDERS",null,null,{"$f":"F24","v":78612},null,{"$f":"H27","v":2857007},null,null,null,{"$f":"SUM(L24:L27)","v":16601495},null,{"$f":"ROUND((L29/$L$37)*100,1)","v":100},null,{"$f":"SUM(P24:P27)","v":11605162},null,{"$f":"SUM(R24:R27)","v":28206657}]
[]
[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$37)*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$37)*100,1)","v":0},null,null,null,{"$f":"L33+P33","v":0}]
[]
[12,null,"TOTAL RIDERS",null,null,null,null,null,null,null,null,{"$f":"SUM(L31:L33)","v":0},null,{"$f":"ROUND((L35/$L$37)*100,1)","v":0},null,null,null,{"$f":"SUM(R31:R33)","v":0}]
[]
[13,null,"TOTAL RATE GS COMMERCIAL INCLUDING RIDERS",null,null,{"$f":"F24","v":78612},null,{"$f":"H27","v":2857007},null,null,null,{"$f":"L29+L35","v":16601495},null,{"$f":"N29+N35","v":100},null,{"$f":"P29+P35","v":11605162},null,{"$f":"R29+R35","v":28206657}]
[]
[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 $4.062/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. 2021-00190"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANNUALIZED TEST YEAR REVENUES AT PROPOSED VS. MOST CURRENT RATES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TIME_PERIOD","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2022"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE M-2.2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R7","v":"PAGE  3  OF  7"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WORK PAPER REFERENCE NO(S).:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"J.L. Kern"}]
[null,null,null,null,null,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":78612},null,null,null,{"$f":"CUR_GS_CUST","v":50},null,{"$f":"ROUND(X64*AB64,0)","v":3930600},null,{"$f":"ROUND((AD64/$AD$77)*100,1)","v":32},null,{"$f":"L24-AD64","v":628896},null,{"$f":"IF(AD64=0,\"0.0 \",ROUND((AH64/AD64)*100,1))","v":16},null,null,null,{"$f":"AD64+AL64","v":3930600},null,{"$f":"IF(AN64=0,\"0.0 \",ROUND((AH64/AN64)*100,1))","v":16}]
[]
[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":2857007},null,{"$f":"CUR_GS","v":2.9243000000000001},null,{"$f":"ROUND((Z67*AB67),0)","v":8354746},null,{"$f":"ROUND((AD67/$AD$77)*100,1)","v":68},null,{"$f":"L27-AD67","v":3687253},null,{"$f":"IF(AD67=0,\"0.0 \",ROUND((AH67/AD67)*100,1))","v":44.1},null,{"$f":"P27","v":11605162},null,{"$f":"AD67+AL67","v":19959908},null,{"$f":"IF(AN67=0,\"0.0 \",ROUND((AH67/AN67)*100,1))","v":18.5}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,"RATE GS COMMERCIAL EXCLUDING RIDERS",null,{"$f":"X64","v":78612},null,{"$f":"Z67","v":2857007},null,null,null,{"$f":"SUM(AD64:AD67)","v":12285346},null,{"$f":"ROUND((AD69/$AD$77)*100,1)","v":100},null,{"$f":"SUM(AH64:AH67)","v":4316149},null,{"$f":"IF(AD69=0,\"0.0 \",ROUND((AH69/AD69)*100,1))","v":35.1},null,{"$f":"SUM(AL64:AL67)","v":11605162},null,{"$f":"SUM(AN64:AN67)","v":23890508},null,{"$f":"IF(AN69=0,\"0.0 \",ROUND((AH69/AN69)*100,1))","v":18.100000000000001}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,null,"RIDERS:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,{"$f":"C32","v":"DEMAND SIDE MANAGEMENT RATE (DSMR)"},null,null,null,null,null,{"$f":"CUR_GS_DSM","v":0},null,{"$f":"ROUND(Z67*AB72,0)","v":0},null,{"$f":"ROUND((AD72/$AD$77)*100,1)","v":0},null,{"$f":"L32-AD72","v":0},null,{"$f":"IF(AD72=0,\"0.0 \",ROUND((AH72/AD72)*100,1))","v":"0.0 "},null,null,null,{"$f":"AD72+AL72","v":0},null,{"$f":"IF(AN72=0,\"0.0 \",ROUND((AH72/AN72)*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(Z69*AB73,0)","v":0},null,{"$f":"ROUND((AD73/$AD$77)*100,1)","v":0},null,{"$f":"L33-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":"A35","v":12},null,"TOTAL RIDERS",null,null,null,null,null,null,null,{"$f":"SUM(AD71:AD73)","v":0},null,{"$f":"ROUND((AD75/$AD$77)*100,1)","v":0},null,{"$f":"SUM(AH71:AH73)","v":0},null,{"$f":"IF(AD75=0,\"0.0 \",ROUND((AH75/AD75)*100,1))","v":"0.0 "},null,null,null,{"$f":"SUM(AN71:AN73)","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":"A37","v":13},null,"TOTAL RATE GS COMMERCIAL INCLUDING RIDERS",null,{"$f":"X64","v":78612},null,{"$f":"Z67","v":2857007},null,null,null,{"$f":"AD69+AD75","v":12285346},null,{"$f":"AF69+AF75","v":100},null,{"$f":"AH69+AH75","v":4316149},null,{"$f":"IF(AD77=0,\"0.0 \",ROUND((AH77/AD77)*100,1))","v":35.1},null,{"$f":"P37","v":11605162},null,{"$f":"AN69+AN75","v":23890508},null,{"$f":"IF(AN77=0,\"0.0 \",ROUND((AH77/AN77)*100,1))","v":18.100000000000001}]
[]
[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 $4.062/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":86,"n_cols":42,"rows_kept":86,"cut":false,"hidden":false,"merged":[]}
[{"$f":"COMPANY","v":"DUKE ENERGY KENTUCKY"}]
[{"$f":"CASE","v":"CASE NO. 2021-00190"}]
["ANNUALIZED REVENUES AT PROPOSED VS. MOST CURRENT RATES"]
[{"$f":"TIME_PERIOD","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2022"}]
[{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE M-2.3"]
[{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PAGE  4  OF  7"]
["WORK PAPER REFERENCE NO(S).:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"J.L. Kern"}]
["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,2879,null,null,null,{"$f":"PRO_GS_CUST","v":58},null,{"$f":"ROUND(F24*J24,0)","v":166982},null,{"$f":"ROUND((L24/$L$37)*100,1)","v":10.7},null,null,null,{"$f":"L24+P24","v":166982}]
[]
[6,null,"COMMODITY CHARGE:"]
[7,null,"     ALL CONSUMPTION",null,null,null,null,331485,null,{"$f":"PRO_GS","v":4.2149000000000001},null,{"$f":"ROUND((H27*J27),0)","v":1397176},null,{"$f":"ROUND((L27/$L$37)*100,1)","v":89.3},null,{"$f":"ROUND(EGC*$H27,0)","v":1346492},null,{"$f":"L27+P27","v":2743668}]
[]
[8,null,"RATE GS INDUSTRIAL EXCLUDING RIDERS",null,null,{"$f":"F24","v":2879},null,{"$f":"H27","v":331485},null,null,null,{"$f":"SUM(L24:L27)","v":1564158},null,{"$f":"ROUND((L29/$L$37)*100,1)","v":100},null,{"$f":"SUM(P24:P27)","v":1346492},null,{"$f":"SUM(R24:R27)","v":2910650}]
[]
[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$37)*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$37)*100,1)","v":0},null,null,null,{"$f":"L33+P33","v":0}]
[]
[12,null,"TOTAL RIDERS",null,null,null,null,null,null,null,null,{"$f":"SUM(L31:L33)","v":0},null,{"$f":"ROUND((L35/$L$37)*100,1)","v":0},null,null,null,{"$f":"SUM(R31:R33)","v":0}]
[]
[13,null,"TOTAL RATE GS INDUSTRIAL INCLUDING RIDERS",null,null,{"$f":"F24","v":2879},null,{"$f":"H27","v":331485},null,null,null,{"$f":"L29+L35","v":1564158},null,{"$f":"N29+N35","v":100},null,{"$f":"P29+P35","v":1346492},null,{"$f":"R29+R35","v":2910650}]
[]
[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 $4.062/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. 2021-00190"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANNUALIZED TEST YEAR REVENUES AT PROPOSED VS. MOST CURRENT RATES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TIME_PERIOD","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2022"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE M-2.2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R7","v":"PAGE  4  OF  7"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WORK PAPER REFERENCE NO(S).:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"J.L. Kern"}]
[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":2879},null,null,null,{"$f":"CUR_GS_CUST","v":50},null,{"$f":"ROUND(X69*AB69,0)","v":143950},null,{"$f":"ROUND((AD69/$AD$82)*100,1)","v":12.9},null,{"$f":"L24-AD69","v":23032},null,{"$f":"IF(AD69=0,\"0.0 \",ROUND((AH69/AD69)*100,1))","v":16},null,null,null,{"$f":"AD69+AL69","v":143950},null,{"$f":"IF(AN69=0,\"0.0 \",ROUND((AH69/AN69)*100,1))","v":16}]
[]
[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":331485},null,{"$f":"CUR_GS","v":2.9243000000000001},null,{"$f":"ROUND((Z72*AB72),0)","v":969362},null,{"$f":"ROUND((AD72/$AD$82)*100,1)","v":87.1},null,{"$f":"L27-AD72","v":427814},null,{"$f":"IF(AD72=0,\"0.0 \",ROUND((AH72/AD72)*100,1))","v":44.1},null,{"$f":"P27","v":1346492},null,{"$f":"AD72+AL72","v":2315854},null,{"$f":"IF(AN72=0,\"0.0 \",ROUND((AH72/AN72)*100,1))","v":18.5}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,"RATE GS INDUSTRIAL EXCLUDING RIDERS",null,{"$f":"X69","v":2879},null,{"$f":"Z72","v":331485},null,null,null,{"$f":"SUM(AD69:AD72)","v":1113312},null,{"$f":"ROUND((AD74/$AD$82)*100,1)","v":100},null,{"$f":"SUM(AH69:AH72)","v":450846},null,{"$f":"IF(AD74=0,\"0.0 \",ROUND((AH74/AD74)*100,1))","v":40.5},null,{"$f":"SUM(AL69:AL72)","v":1346492},null,{"$f":"SUM(AN69:AN72)","v":2459804},null,{"$f":"IF(AN74=0,\"0.0 \",ROUND((AH74/AN74)*100,1))","v":18.3}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,null,"RIDERS:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,{"$f":"C37","v":"TOTAL RATE GS INDUSTRIAL INCLUDING RIDERS"},null,null,null,null,null,{"$f":"CUR_GS_DSM","v":0},null,{"$f":"ROUND(Z72*AB77,0)","v":0},null,{"$f":"ROUND((AD77/$AD$82)*100,1)","v":0},null,{"$f":"L32-AD77","v":0},null,{"$f":"IF(AD77=0,\"0.0 \",ROUND((AH77/AD77)*100,1))","v":"0.0 "},null,null,null,{"$f":"AD77+AL77","v":0},null,{"$f":"IF(AN77=0,\"0.0 \",ROUND((AH77/AN77)*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(Z74*AB78,0)","v":0},null,{"$f":"ROUND((AD78/$AD$82)*100,1)","v":0},null,{"$f":"L33-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":"A35","v":12},null,"TOTAL RIDERS",null,null,null,null,null,null,null,{"$f":"SUM(AD76:AD78)","v":0},null,{"$f":"ROUND((AD80/$AD$82)*100,1)","v":0},null,{"$f":"SUM(AH76:AH78)","v":0},null,{"$f":"IF(AD80=0,\"0.0 \",ROUND((AH80/AD80)*100,1))","v":"0.0 "},null,null,null,{"$f":"SUM(AN76:AN78)","v":0},null,{"$f":"IF(AN80=0,\"0.0 \",ROUND((AH80/AN80)*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":"A37","v":13},null,"TOTAL RATE GS INDUSTRIAL INCLUDING RIDERS",null,{"$f":"X69","v":2879},null,{"$f":"Z72","v":331485},null,null,null,{"$f":"AD74+AD80","v":1113312},null,{"$f":"AF74+AF80","v":100},null,{"$f":"AH74+AH80","v":450846},null,{"$f":"IF(AD82=0,\"0.0 \",ROUND((AH82/AD82)*100,1))","v":40.5},null,{"$f":"P37","v":1346492},null,{"$f":"AN74+AN80","v":2459804},null,{"$f":"IF(AN82=0,\"0.0 \",ROUND((AH82/AN82)*100,1))","v":18.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 $4.062/MCF."}]

{"sheet":"Rate GS OPA","index":9,"n_rows":83,"n_cols":42,"rows_kept":83,"cut":false,"hidden":false,"merged":[]}
[{"$f":"COMPANY","v":"DUKE ENERGY KENTUCKY"}]
[{"$f":"CASE","v":"CASE NO. 2021-00190"}]
["ANNUALIZED REVENUES AT PROPOSED VS. MOST CURRENT RATES"]
[{"$f":"TIME_PERIOD","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2022"}]
[{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE M-2.3"]
[{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PAGE  5  OF  7"]
["WORK PAPER REFERENCE NO(S).:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"J.L. Kern"}]
["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,{"$f":"2529+12","v":2541},null,null,null,{"$f":"PRO_GS_CUST","v":58},null,{"$f":"ROUND(F24*J24,0)","v":147378},null,{"$f":"ROUND((L24/$L$37)*100,1)","v":10.8},null,null,null,{"$f":"L24+P24","v":147378}]
[]
[6,null,"COMMODITY CHARGE:"]
[7,null,"     ALL CONSUMPTION",null,null,null,null,{"$f":"289161+61","v":289222},null,{"$f":"PRO_GS","v":4.2149000000000001},null,{"$f":"ROUND((H27*J27),0)","v":1219042},null,{"$f":"ROUND((L27/$L$37)*100,1)","v":89.2},null,{"$f":"ROUND(EGC*$H27,0)","v":1174820},null,{"$f":"L27+P27","v":2393862}]
[]
[8,null,"RATE GS OPA EXCLUDING RIDERS",null,null,{"$f":"F24","v":2541},null,{"$f":"H27","v":289222},null,null,null,{"$f":"SUM(L24:L27)","v":1366420},null,{"$f":"ROUND((L29/$L$37)*100,1)","v":100},null,{"$f":"SUM(P24:P27)","v":1174820},null,{"$f":"SUM(R24:R27)","v":2541240}]
[]
[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$37)*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$37)*100,1)","v":0},null,null,null,{"$f":"L33+P33","v":0}]
[]
[12,null,"TOTAL RIDERS",null,null,null,null,null,null,null,null,{"$f":"SUM(L31:L33)","v":0},null,{"$f":"ROUND((L35/$L$37)*100,1)","v":0},null,null,null,{"$f":"SUM(R31:R33)","v":0}]
[]
[13,null,"TOTAL RATE GS OPA INCLUDING RIDERS",null,null,{"$f":"F24","v":2541},null,{"$f":"H27","v":289222},null,null,null,{"$f":"L29+L35","v":1366420},null,{"$f":"SUM(N29+N35)","v":100},null,{"$f":"P29+P35","v":1174820},null,{"$f":"R29+R35","v":2541240}]
[]
[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 $4.062/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. 2021-00190"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANNUALIZED TEST YEAR REVENUES AT PROPOSED VS. MOST CURRENT RATES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TIME_PERIOD","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2022"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE M-2.2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R7","v":"PAGE  5  OF  7"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WORK PAPER REFERENCE NO(S).:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"J.L. Kern"}]
[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":2541},null,null,null,{"$f":"CUR_GS_CUST","v":50},null,{"$f":"ROUND(X66*AB66,0)","v":127050},null,{"$f":"ROUND((AD66/$AD$79)*100,1)","v":13.1},null,{"$f":"L24-AD66","v":20328},null,{"$f":"IF(AD66=0,\"0.0 \",ROUND((AH66/AD66)*100,1))","v":16},null,null,null,{"$f":"AD66+AL66","v":127050},null,{"$f":"IF(AN66=0,\"0.0 \",ROUND((AH66/AN66)*100,1))","v":16}]
[]
[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":289222},null,{"$f":"CUR_GS","v":2.9243000000000001},null,{"$f":"ROUND((Z69*AB69),0)","v":845772},null,{"$f":"ROUND((AD69/$AD$79)*100,1)","v":86.9},null,{"$f":"L27-AD69","v":373270},null,{"$f":"IF(AD69=0,\"0.0 \",ROUND((AH69/AD69)*100,1))","v":44.1},null,{"$f":"P27","v":1174820},null,{"$f":"AD69+AL69","v":2020592},null,{"$f":"IF(AN69=0,\"0.0 \",ROUND((AH69/AN69)*100,1))","v":18.5}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,"RATE GS OPA EXCLUDING RIDERS",null,{"$f":"X66","v":2541},null,{"$f":"Z69","v":289222},null,null,null,{"$f":"SUM(AD66:AD69)","v":972822},null,{"$f":"ROUND((AD71/$AD$79)*100,1)","v":100},null,{"$f":"SUM(AH66:AH69)","v":393598},null,{"$f":"IF(AD71=0,\"0.0 \",ROUND((AH71/AD71)*100,1))","v":40.5},null,{"$f":"SUM(AL66:AL69)","v":1174820},null,{"$f":"SUM(AN66:AN69)","v":2147642},null,{"$f":"IF(AN71=0,\"0.0 \",ROUND((AH71/AN71)*100,1))","v":18.3}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,null,"RIDERS:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,"DEMAND SIDE MANAGEMENT RATE (DSMR)",null,null,null,null,null,{"$f":"CUR_GS_DSM","v":0},null,{"$f":"ROUND(Z69*AB74,0)","v":0},null,{"$f":"ROUND((AD74/$AD$79)*100,1)","v":0},null,{"$f":"L32-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,{"$f":"A33","v":11},null,"WEATHER NORMALIZATION ADJUSTMENT (WNA)",null,null,null,null,null,0,null,{"$f":"ROUND(Z71*AB75,0)","v":0},null,{"$f":"ROUND((AD75/$AD$79)*100,1)","v":0},null,{"$f":"L33-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":"A35","v":12},null,"TOTAL RIDERS",null,null,null,null,null,null,null,{"$f":"SUM(AD73:AD75)","v":0},null,{"$f":"ROUND((AD77/$AD$79)*100,1)","v":0},null,{"$f":"SUM(AH73:AH75)","v":0},null,{"$f":"IF(AD77=0,\"0.0 \",ROUND((AH77/AD77)*100,1))","v":"0.0 "},null,null,null,{"$f":"SUM(AN73:AN75)","v":0},null,{"$f":"IF(AN77=0,\"0.0 \",ROUND((AH77/AN77)*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":"A37","v":13},null,"TOTAL RATE GS OPA INCLUDING RIDERS",null,{"$f":"X66","v":2541},null,{"$f":"Z69","v":289222},null,null,null,{"$f":"AD71+AD77","v":972822},null,{"$f":"AF71+AF77","v":100},null,{"$f":"AH71+AH77","v":393598},null,{"$f":"IF(AD79=0,\"0.0 \",ROUND((AH79/AD79)*100,1))","v":40.5},null,{"$f":"P37","v":1174820},null,{"$f":"AN71+AN77","v":2147642},null,{"$f":"IF(AN79=0,\"0.0 \",ROUND((AH79/AN79)*100,1))","v":18.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 $4.062/MCF."}]

{"sheet":"Rate FT-LG","index":10,"n_rows":75,"n_cols":42,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
[{"$f":"COMPANY","v":"DUKE ENERGY KENTUCKY"}]
[{"$f":"CASE","v":"CASE NO. 2021-00190"}]
["ANNUALIZED REVENUES AT PROPOSED VS. MOST CURRENT RATES"]
[{"$f":"TIME_PERIOD","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2022"}]
[{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE M-2.3"]
[{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PAGE  6  OF  7"]
["WORK PAPER REFERENCE NO(S).:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"J.L. Kern"}]
["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,1092,null,null,null,{"$f":"PRO_FTL_CUST","v":430},null,{"$f":"ROUND((F22*J22),0)","v":469560},null,{"$f":"ROUND((L22/L$34)*100,1)","v":6.8},null,null,null,{"$f":"L22+P22","v":469560}]
[]
[4,null,"TRANSPORTATION CHARGE:"]
[5,null,"ALL CONSUMPTION",null,null,null,null,2736182,null,{"$f":"PRO_FTL_COM","v":2.3523999999999998},null,{"$f":"ROUND((H25*J25),0)","v":6436595},null,{"$f":"ROUND((L25/L$34)*100,1)","v":93.2},null,null,null,{"$f":"L25+P25","v":6436595}]
[]
[6,null,"RATE FT-LARGE EXCLUDING RIDERS",null,null,{"$f":"F22","v":1092},null,{"$f":"H25","v":2736182},null,null,null,{"$f":"SUM(L22:L25)","v":6906155},null,{"$f":"SUM(N22:N25)","v":100},null,null,null,{"$f":"SUM(R22:R25)","v":6906155}]
[]
[7,null,"RIDERS:"]
[8,null,"GAS COST ADJUSTMENT TRANSITION (GCAT) (2)",null,null,null,null,null,null,{"$f":"PRO_FTL_GCAT","v":-5.8000000000000003E-2},null,null,null,{"$f":"ROUND((L30/L$34)*100,1)","v":0},null,{"$f":"ROUND(H25*R37*J30,0)","v":-7935},null,{"$f":"L30+P30","v":-7935}]
[]
[9,null,"TOTAL RIDERS",null,null,null,null,null,null,null,null,{"$f":"SUM(L30:L30)","v":0},null,{"$f":"ROUND((L32/L$34)*100,1)","v":0},null,{"$f":"P30","v":-7935},null,{"$f":"SUM(R30:R30)","v":-7935}]
[]
[10,null,"TOTAL RATE FT - LARGE INCLUDING RIDERS",null,null,{"$f":"F22","v":1092},null,{"$f":"H25","v":2736182},null,null,null,{"$f":"L27+L32","v":6906155},null,{"$f":"SUM(N27+N32)","v":100},null,{"$f":"P32+P27","v":-7935},null,{"$f":"R27+R32","v":6898220}]
[]
[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.05]
[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. 2021-00190"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANNUALIZED TEST YEAR REVENUES AT PROPOSED VS. MOST CURRENT RATES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TIME_PERIOD","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2022"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE M-2.2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R7","v":"PAGE  6  OF  7"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WORK PAPER REFERENCE NO(S).:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"J.L. Kern"}]
[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":1092},null,null,null,{"$f":"CUR_FTL_CUST","v":430},null,{"$f":"ROUND(X59*AB59,0)","v":469560},null,{"$f":"IF(AD$71=0,\"0.0 \",ROUND((AD59/AD$71)*100,1))","v":8.6},null,{"$f":"L22-AD59","v":0},null,{"$f":"IF(AD59=0,\"0.0 \",ROUND((AH59/AD59)*100,1))","v":0},null,null,null,{"$f":"AD59+AL59","v":469560},null,{"$f":"IF(AN59=0,\"0.0 \",ROUND((AH59/AN59)*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":2736182},null,{"$f":"CUR_FTL_COM","v":1.821},null,{"$f":"ROUND(Z62*AB62,0)","v":4982587},null,{"$f":"IF(AD$71=0,\"0.0 \",ROUND((AD62/AD$71)*100,1))","v":91.4},null,{"$f":"L25-AD62","v":1454008},null,{"$f":"IF(AD62=0,\"0.0 \",ROUND((AH62/AD62)*100,1))","v":29.2},null,null,null,{"$f":"AD62+AL62","v":4982587},null,{"$f":"IF(AN62=0,\"0.0 \",ROUND((AH62/AN62)*100,1))","v":29.2}]
[]
[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":"X59","v":1092},null,{"$f":"Z62","v":2736182},null,null,null,{"$f":"SUM(AD59:AD62)","v":5452147},null,{"$f":"SUM(AF59:AF62)","v":100},null,{"$f":"SUM(AH59:AH62)","v":1454008},null,{"$f":"IF(AD64=0,\"0.0 \",ROUND((AH64/AD64)*100,1))","v":26.7},null,null,null,{"$f":"SUM(AN59:AN62)","v":5452147},null,{"$f":"IF(AN64=0,\"0.0 \",ROUND((AH64/AN64)*100,1))","v":26.7}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,null,"RIDERS:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,"GAS COST ADJUSTMENT TRANSITION (GCAT)(2)",null,null,null,null,null,{"$f":"CUR_FTL_GCAT","v":-5.8000000000000003E-2},null,null,null,{"$f":"IF(AD$71=0,\"0.0 \",ROUND((AD67/AD$71)*100,1))","v":0},null,{"$f":"L30-AD67","v":0},null,{"$f":"IF(AD67=0,\"0.0 \",ROUND((AH67/AD67)*100,1))","v":"0.0 "},null,{"$f":"ROUND(Z62*R37*AB67,0)","v":-7935},null,{"$f":"AD67+AL67","v":-7935},null,{"$f":"IF(AN67=0,\"0.0 \",ROUND((AH67/AN67)*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(AD67:AD67)","v":0},null,{"$f":"SUM(AF67:AF67)","v":0},null,{"$f":"SUM(AH67:AH67)","v":0},null,{"$f":"IF(AD69=0,\"0.0 \",ROUND((AH69/AD69)*100,1))","v":"0.0 "},null,{"$f":"SUM(AL67:AL67)","v":-7935},null,{"$f":"SUM(AN67:AN67)","v":-7935},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 RATE FT - LARGE INCLUDING RIDERS",null,{"$f":"X59","v":1092},null,{"$f":"Z62","v":2736182},null,null,null,{"$f":"SUM(AD64+AD69)","v":5452147},null,{"$f":"SUM(AF64+AF69)","v":100},null,{"$f":"SUM(AH64+AH69)","v":1454008},null,{"$f":"IF(AD71=0,\"0.0 \",ROUND((AH71/AD71)*100,1))","v":26.7},null,{"$f":"SUM(AL64+AL69)","v":-7935},null,{"$f":"SUM(AN64+AN69)","v":5444212},null,{"$f":"IF(AN71=0,\"0.0 \",ROUND((AH71/AN71)*100,1))","v":26.7}]
[]
[]
[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(R37,\"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 5%"}]

{"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. 2021-00190"}]
["ANNUALIZED REVENUES AT PROPOSED VS. MOST CURRENT RATES"]
[{"$f":"TIME_PERIOD","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2022"}]
[{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE M-2.3"]
[{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PAGE  7  OF  7"]
["WORK PAPER REFERENCE NO(S).:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"J.L. Kern"}]
["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,264,null,null,null,{"$f":"PRO_IT_CUST","v":430},null,{"$f":"ROUND((F22*J22),0)","v":113520},null,{"$f":"ROUND((L22/L$34)*100,1)","v":5.0999999999999996},null,null,null,{"$f":"L22+P22","v":113520}]
[]
[4,null,"COMMODITY CHARGE:"]
[5,null,"    ALL CONSUMPTION",null,null,null,null,1672200,null,{"$f":"PRO_IT_COM","v":1.2626999999999999},null,{"$f":"ROUND((H25*(J25)),0)","v":2111487},null,{"$f":"ROUND((L25/L$34)*100,1)","v":94.9},null,null,null,{"$f":"L25+P25","v":2111487}]
[]
[6,null,"RATE IT EXCLUDING RIDERS",null,null,{"$f":"F22","v":264},null,{"$f":"H25","v":1672200},null,null,null,{"$f":"SUM(L22:L25)","v":2225007},null,{"$f":"SUM(N22:N25)","v":100},null,null,null,{"$f":"SUM(R22:R25)","v":2225007}]
[]
[7,null,"RIDERS:"]
[8,null,"   N/A",null,null,null,null,null,null,0,null,{"$f":"ROUND(H25*J30,0)","v":0},null,{"$f":"ROUND((L30/L$34)*100,1)","v":0},null,null,null,{"$f":"L30+P30","v":0}]
[]
[9,null,"TOTAL RIDERS",null,null,null,null,null,null,null,null,{"$f":"SUM(L29:L30)","v":0},null,{"$f":"ROUND((L32/L$34)*100,1)","v":0},null,null,null,{"$f":"SUM(R29:R30)","v":0}]
[]
[10,null,"TOTAL RATE IT TRANSPORTATION",null,null,{"$f":"F27","v":264},null,{"$f":"H27","v":1672200},null,null,null,{"$f":"L27+L32","v":2225007},null,{"$f":"ROUND((L34/L$34)*100,1)","v":100},null,null,null,{"$f":"R27+R32","v":2225007}]
[]
[]
[]
[]
[]
[]
[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. 2021-00190"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANNUALIZED TEST YEAR REVENUES AT PROPOSED VS. MOST CURRENT RATES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TIME_PERIOD","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2022"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE M-2.2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R7","v":"PAGE  7  OF  7"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WORK PAPER REFERENCE NO(S).:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"J.L. Kern"}]
[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":264},null,null,null,{"$f":"CUR_IT_CUST","v":430},null,{"$f":"ROUND(X62*AB62,0)","v":113520},null,{"$f":"ROUND((AD62/AD$74)*100,1)","v":6.4},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":113520},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":1672200},null,{"$f":"CUR_IT_COM","v":0.99819999999999998},null,{"$f":"ROUND(Z65*AB65,0)","v":1669190},null,{"$f":"ROUND((AD65/AD$74)*100,1)","v":93.6},null,{"$f":"L25-AD65","v":442297},null,{"$f":"IF(AD65=0,\"0.0 \",ROUND((AH65/AD65)*100,1))","v":26.5},null,null,null,{"$f":"AD65+AL65","v":1669190},null,{"$f":"IF(AN65=0,\"0.0 \",ROUND((AH65/AN65)*100,1))","v":26.5}]
[]
[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":264},null,{"$f":"Z65","v":1672200},null,null,null,{"$f":"SUM(AD62:AD65)","v":1782710},null,{"$f":"SUM(AF62:AF65)","v":100},null,{"$f":"L27-AD67","v":442297},null,{"$f":"IF(AD67=0,\"0.0 \",ROUND((AH67/AD67)*100,1))","v":24.8},null,null,null,{"$f":"SUM(AN62:AN65)","v":1782710},null,{"$f":"IF(AN67=0,\"0.0 \",ROUND((AH67/AN67)*100,1))","v":24.8}]
[]
[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,"   N/A",null,null,null,null,null,0,null,{"$f":"ROUND(Z65*AB70,0)","v":0},null,{"$f":"ROUND((AD70/AD$74)*100,1)","v":0},null,{"$f":"L30-AD70","v":0},null,{"$f":"IF(AD70=0,\"0.0 \",ROUND((AH70/AD70)*100,1))","v":"0.0 "},null,null,null,{"$f":"AD70+AL70","v":0},null,{"$f":"IF(AN70=0,\"0.0 \",ROUND((AH70/AN70)*100,1))","v":"0.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":0},null,{"$f":"ROUND((AD72/AD$74)*100,1)","v":0},null,{"$f":"L32-AD72","v":0},null,{"$f":"IF(AD72=0,\"0.0 \",ROUND((AH72/AD72)*100,1))","v":"0.0 "},null,null,null,{"$f":"SUM(AN69:AN70)","v":0},null,{"$f":"IF(AN72=0,\"0.0 \",ROUND((AH72/AN72)*100,1))","v":"0.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":264},null,{"$f":"Z67","v":1672200},null,null,null,{"$f":"AD67+AD72","v":1782710},null,{"$f":"ROUND((AD74/AD$74)*100,1)","v":100},null,{"$f":"AH67+AH72","v":442297},null,{"$f":"IF(AD74=0,\"0.0 \",ROUND((AH74/AD74)*100,1))","v":24.8},null,null,null,{"$f":"AN67+AN72","v":1782710},null,{"$f":"IF(AN74=0,\"0.0 \",ROUND((AH74/AN74)*100,1))","v":24.8}]

{"sheet":"SCH N","index":12,"n_rows":104,"n_cols":14,"rows_kept":104,"cut":false,"hidden":false,"merged":[[0,0,0,13],[3,0,3,13],[4,0,4,13]]}
[{"$f":"COMPANY","v":"DUKE ENERGY KENTUCKY"}]
[{"$f":"CASE","v":"CASE NO. 2021-00190"}]
["EFFECTS OF PROPOSED RESIDENTIAL AND GENERAL SERVICE RATES"]
["TYPICAL BILL COMPARISON"]
[{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[]
[{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE N"]
[{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,"PAGE 1 OF 2"]
["WORK PAPER REFERENCE NO(S).: ",null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"J.L. Kern"}]
[]
[]
[null,null,null,null,null," BILL DATA INCLUDING RIDERS LESS COST of GAS",null,null,null,null,null,"TOTAL","TOTAL"]
[null,null,null,"LEVEL","LEVEL",null,null,"DOLLAR","PERCENT",null,null,"CURRENT","PROPOSED","PERCENT"]
[null,null,null,"of","of","CURRENT","PROPOSED","INCREASE","INCREASE",null,"GAS","BILL","BILL","INCREASE"]
["LINE",null,"RATE","DEMAND","USE","BILL","BILL","(D - C)","(E / C)",null,"COST (1)","(C + G)","(D + G)","(I-H) /H"]
[" NO.",null,"CODE","(A)","(B)","(C)","(D)","(E)","(F)",null,"(G)","(H)","(I)","(L)"]
[null,null,null,null,"(MCF)","($)","($)","($)","(%)",null,"($)","($)","($)","(%)"]
[1,null,"(RS)"]
[2,null,"RESIDENTIAL","Not",1,{"$f":"ROUND(E20*(CUR_RS+CUR_RS_DSM)+CUR_RS_CUST+CUR_RS_HEA,2)","v":21.95},{"$f":"ROUND(E20*(PRO_RS_COM+PRO_RS_DSM)+PRO_RS_CUST+PRO_RS_HEA,2)","v":25.29},{"$f":"G20-F20","v":3.34},{"$f":"ROUND(H20/F20,3)*100","v":15.2},null,{"$f":"ROUND(E20*EGC,2)","v":4.0599999999999996},{"$f":"F20+K20","v":26.009999999999998},{"$f":"G20+K20","v":29.349999999999998},{"$f":"ROUND((M20-L20)/L20,3)*100","v":12.8}]
[3,null,null,"Applicable",3,32.25,37.270000000000003,5.0200000000000031,15.6,null,12.19,{"$f":"F21+K21","v":44.44},{"$f":"G21+K21","v":49.46},{"$f":"ROUND((M21-L21)/L21,3)*100","v":11.3}]
[4,null,null,null,6,47.7,55.25,7.5499999999999972,15.8,null,24.37,72.070000000000007,79.62,10.5]
[5,null,null,null,8,58,67.23,9.230000000000004,15.9,null,32.5,90.5,99.73,10.199999999999999]
[6,null,null,null,10,68.3,79.209999999999994,10.909999999999997,16,null,40.619999999999997,108.91999999999999,119.82999999999998,10]
[7,null,null,null,12,78.599999999999994,91.19,12.590000000000003,16,null,48.74,127.34,139.93,9.9]
[8,null,null,null,16,99.2,115.16,15.959999999999994,16.100000000000001,null,64.989999999999995,164.19,180.14999999999998,9.7000000000000011]
[9,null,null,null,20,119.8,139.12,19.320000000000007,16.100000000000001,null,81.239999999999995,201.04,220.36,9.6]
[10,null,null,null,30,171.31,199.04,27.72999999999999,16.2,null,121.86,293.17,320.89999999999998,9.5]
[11,null,null,null,40,222.81,258.95,36.139999999999986,16.2,null,162.47999999999999,385.28999999999996,421.42999999999995,9.4]
[12,null,null,null,50,274.31,318.86,44.550000000000011,16.2,null,203.1,477.40999999999997,521.96,9.3000000000000007]
[13,null,null,null,60,325.81,378.77,52.95999999999998,16.3,null,243.72,569.53,622.49,9.3000000000000007]
[14,null,null,null,80,428.81,498.59,69.779999999999973,16.3,null,324.95999999999998,753.77,823.55,9.3000000000000007]
[15,null,null,null,100,531.82000000000005,618.41999999999996,86.599999999999909,16.3,null,406.2,938.02,1024.6199999999999,9.1999999999999993]
[]
[16,null,"(GS)"]
[17,null,"NON-RESIDENTIAL",null,5,{"$f":"ROUND(E36*(CUR_GS)+CUR_GS_CUST,2)","v":64.62},{"$f":"ROUND(E36*(+PRO_GS)+PRO_GS_CUST,2)","v":79.069999999999993},{"$f":"G36-F36","v":14.449999999999989},{"$f":"ROUND(H36/F36,3)*100","v":22.400000000000002},null,{"$f":"ROUND(E36*EGC,2)","v":20.309999999999999},{"$f":"F36+K36","v":84.93},{"$f":"G36+K36","v":99.38},{"$f":"ROUND((M36-L36)/L36,3)*100","v":17}]
[18,null,null,null,10,79.239999999999995,100.15,20.910000000000011,26.400000000000002,null,40.619999999999997,119.85999999999999,140.77000000000001,17.399999999999999]
[19,null,null,null,20,108.49,142.30000000000001,33.810000000000016,31.2,null,81.239999999999995,189.73,223.54000000000002,17.8]
[20,null,null,null,40,166.97,226.6,59.629999999999995,35.699999999999996,null,162.47999999999999,329.45,389.08,18.099999999999998]
[21,null,null,null,50,196.22,268.75,72.53,37,null,203.1,399.32,471.85,18.2]
[22,null,null,null,100,342.43,479.49,137.06,40,null,406.2,748.63,885.69,18.3]
[23,null,null,null,300,927.29,1322.47,395.18000000000006,42.6,null,1218.5999999999999,2145.89,2541.0699999999997,18.399999999999999]
[24,null,null,null,500,1512.15,2165.4499999999998,653.29999999999973,43.2,null,2031,3543.15,4196.45,18.399999999999999]
[25,null,null,null,700,2097.0100000000002,3008.43,911.41999999999962,43.5,null,2843.4,4940.41,5851.83,18.399999999999999]
[26,null,null,null,850,2535.66,3640.67,1105.0100000000002,43.6,null,3452.7,5988.36,7093.37,18.5]
[27,null,null,null,1000,2974.3,4272.8999999999996,1298.5999999999995,43.7,null,4062,7036.3,8334.9,18.5]
[28,null,null,null,2000,5898.6,8487.7999999999993,2589.1999999999989,43.9,null,8124,14022.6,16611.8,18.5]
[29,null,null,null,3000,8822.9,12702.7,3879.8000000000011,44,null,12186,21008.9,24888.7,18.5]
[]
[]
[null,null,{"$f":"\"(1) REFLECTS AVERAGE EXPECTED GAS COST OF \"&TEXT(EGC,\"$0.000\")&\"/MCF.\"","v":"(1) REFLECTS AVERAGE EXPECTED GAS COST OF $4.062/MCF."}]
[]
[]
[{"$f":"COMPANY","v":"DUKE ENERGY KENTUCKY"}]
[{"$f":"CASE","v":"CASE NO. 2021-00190"}]
["EFFECTS OF PROPOSED FIRM TRANSPORTATION-LARGE RATES"]
["AND INTERRUPTIBLE TRANSPORTATION RATES ON TYPICAL CUSTOMER BILLS"]
[{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[]
[{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE N"]
[{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,null,"PAGE 2 OF 2"]
["WORK PAPER REFERENCE NO(S).: ",null,null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"J.L. Kern"}]
[]
[]
[null,null,null,null,null," BILL DATA INCLUDING RIDERS LESS COST of GAS",null,null,null,null,null,"TOTAL","TOTAL"]
[null,null,null,"LEVEL","LEVEL",null,null,"DOLLAR","PERCENT",null,null,"CURRENT","PROPOSED","PERCENT"]
[null,null,null,"of","of","CURRENT","PROPOSED","INCREASE","INCREASE",null,"GAS","BILL","BILL","INCREASE"]
["LINE",null,"RATE","DEMAND","USE","BILL","BILL","(D - C)","(E / C)",null,"COST (1)","(C + G)","(D + G)","(I-H) /H"]
[" NO.",null,"CODE","(A)","(B)","(C)","(D)","(E)","(F)",null,"(G)","(H)","(I)","(L)"]
[null,null,null,null,"(MCF)","($)","($)","($)","(%)",null,"($)","($)","($)","(%)"]
[null,null,null,null,"(MCF)","($)","($)","($)","(%)",null,"($)","($)","($)","(%)"]
[]
[1,null,"(FT-L)","Not"]
[2,null,"FIRM","Applicable",1000,{"$f":"ROUND(E75*(CUR_FTL_COM),2)+CUR_FTL_CUST","v":2251},{"$f":"ROUND(E75*(PRO_FTL_COM),2)+PRO_FTL_CUST","v":2782.4},{"$f":"+G75-F75","v":531.40000000000009},{"$f":"ROUND(H75/F75,3)*100","v":23.599999999999998},null,{"$f":"ROUND(E75*PRO_FTL_GCAT,2)","v":-58},{"$f":"F75+K75","v":2193},{"$f":"G75+K75","v":2724.4},{"$f":"ROUND((M75-L75)/L75,3)*100","v":24.2}]
[3,null,"TRANSPORTATION",null,1500,3161.5,3958.6,{"$f":"+G76-F76","v":797.09999999999991},25.2,null,-87,{"$f":"F76+K76","v":3074.5},{"$f":"G76+K76","v":3871.6},{"$f":"ROUND((M76-L76)/L76,3)*100","v":25.900000000000002}]
[4,null,null,null,2000,4072,5134.8,1062.8000000000002,26.1,null,-116,3956,5018.8,26.900000000000002]
[5,null,null,null,3000,5893,7487.2,1594.1999999999998,27.1,null,-174,5719,7313.2,27.900000000000002]
[6,null,null,null,5000,9535,12192,2657,27.900000000000002,null,-290,9245,11902,28.7]
[7,null,null,null,10000,18640,23954,5314,28.499999999999996,null,-580,18060,23374,29.4]
[8,null,null,null,20000,36850,47478,10628,28.799999999999997,null,-1160,35690,46318,29.799999999999997]
[9,null,null,null,30000,55060,71002,15942,28.999999999999996,null,-1740,53320,69262,29.9]
[10,null,null,null,40000,73270,94526,21256,28.999999999999996,null,-2320,70950,92206,30]
[11,null,null,null,50000,91480,118050,26570,28.999999999999996,null,-2900,88580,115150,30]
[12,null,null,null,75000,137005,176860,39855,29.099999999999998,null,-4350,132655,172510,30]
[13,null,null,null,100000,182530,235670,53140,29.099999999999998,null,-5800,176730,229870,30.099999999999998]
[14,null,null,null,150000,273580,353290,79710,29.099999999999998,null,-8700,264880,344590,30.099999999999998]
[15,null,null,null,200000,364630,470910,106280,29.099999999999998,null,-11600,353030,459310,30.099999999999998]
[]
[16,null,"(IT)","Not"]
[17,null,"INTERRUPTIBLE","Applicable",2000,{"$f":"ROUND(E91*(CUR_IT_COM),2)+CUR_IT_CUST","v":2426.4},{"$f":"ROUND(E91*(PRO_IT_COM),2)+PRO_IT_CUST","v":2955.4},{"$f":"+G91-F91","v":529},{"$f":"ROUND(H91/F91,3)*100","v":21.8},null,0,{"$f":"F91+K91","v":2426.4},{"$f":"G91+K91","v":2955.4},{"$f":"ROUND((M91-L91)/L91,3)*100","v":21.8}]
[18,null,"TRANSPORTATION",null,5000,5421,6743.5,{"$f":"+G92-F92","v":1322.5},{"$f":"ROUND(H92/F92,3)*100","v":24.4},null,0,{"$f":"F92+K92","v":5421},{"$f":"G92+K92","v":6743.5},{"$f":"ROUND((M92-L92)/L92,3)*100","v":24.4}]
[19,null,null,null,10000,10412,13057,2645,25.4,null,0,10412,13057,25.4]
[20,null,null,null,15000,15403,19370.5,3967.5,25.8,null,0,15403,19370.5,25.8]
[21,null,null,null,20000,20394,25684,5290,25.900000000000002,null,0,20394,25684,25.900000000000002]
[22,null,null,null,25000,25385,31997.5,6612.5,26,null,0,25385,31997.5,26]
[23,null,null,null,30000,30376,38311,7935,26.1,null,0,30376,38311,26.1]
[24,null,null,null,40000,40358,50938,10580,26.200000000000003,null,0,40358,50938,26.200000000000003]
[25,null,null,null,50000,50340,63565,13225,26.3,null,0,50340,63565,26.3]
[26,null,null,null,100000,100250,126700,26450,26.400000000000002,null,0,100250,126700,26.400000000000002]
[27,null,null,null,200000,200070,252970,52900,26.400000000000002,null,0,200070,252970,26.400000000000002]
[28,null,null,null,300000,299890,379240,79350,26.5,null,0,299890,379240,26.5]
[]
[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.058)/MCF"}]

{"sheet":"Revenue Requirements","index":13,"n_rows":29,"n_cols":14,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["REVENUE REQUIREMENTS FROM COST OF SERVICE STUDY"]
[]
[null,{"$f":"COMPANY","v":"DUKE ENERGY KENTUCKY"},null,null,null,null,{"$f":"B3","v":"DUKE ENERGY KENTUCKY"}]
[null,{"$f":"CASE","v":"CASE NO. 2021-00190"},null,null,null,null,{"$f":"B4","v":"CASE NO. 2021-00190"},null,null,null,null,null,"Comparison of Schedule M Calculated Proposed Revenues"]
[null,"SCHEDULE M - CURRENT RATE REVENUES",null,null,null,null,"COST OF SERVICE STUDY",null,null,null,null,null,"Less COS Revenue Requirement"]
[null,"No Riders - With Fuel",null,null,null,null,"Proposed Revenue Requirements",null,null,null,null,null,{"$f":"B4","v":"CASE NO. 2021-00190"}]
[null,null,null,null,null,null,{"$f":"B4","v":"CASE NO. 2021-00190"}]
[]
[null,null,"Customer Bills","Current Rate Revenues - No Riders - Including Fuel",null,null,"Rate","Customer Component RRs","COS - no riders - includes fuel and FAC","% Change","Increase",null,"Rate","+ value is high & - value is low"]
[null,"RS",{"$f":"'Rate RS'!X65","v":1130041},{"$f":"'Rate RS'!AN79-'Rate RS'!AN73-'Rate RS'!AN74","v":75382959},null,null,{"$f":"B10","v":"RS"},28611566,83658696,{"$f":"(I10-D10)/D10","v":0.10978259688638649},{"$f":"I10-D10","v":8275737},null,{"$f":"G10","v":"RS"},{"$f":"'Proposed Rates'!C21","v":137}]
[null,"GS",{"$f":"'Rate GS COM'!F24+'Rate GS IND'!F24+'Rate GS OPA'!F24","v":84032},{"$f":"'Rate GS COM'!AN77+'Rate GS IND'!AN82+'Rate GS OPA'!AN79","v":28497954},null,null,{"$f":"B11","v":"GS"},4095886,33691438,{"$f":"(I11-D11)/D11","v":0.18224059172809387},{"$f":"I11-D11","v":5193484},null,{"$f":"G11","v":"GS"},{"$f":"'Rate GS COM'!R29+'Rate GS IND'!R29+'Rate GS OPA'!R29-'Revenue Requirements'!I11","v":-32891}]
[]
[]
[null,"FT-Large",{"$f":"'Rate FT-LG'!F22","v":1092},{"$f":"'Rate FT-LG'!AN71","v":5444212},null,null,"FT-Large",132688,6791839,0.24753389471240284,1347627,null,"FT-Large",{"$f":"'Proposed Rates'!K23","v":-358.32559999995283}]
[null,"IT",{"$f":"'Rate IT'!F22","v":264},{"$f":"'Rate IT'!AN74","v":1782710},null,null,"IT",85499,2225050,0.24812785029533688,442340,null,"IT",{"$f":"'Proposed Rates'!O21","v":-43}]
[null,null,null,null,null,null,"Additional FT for Min use",null,{"$f":"-'Proposed Rates'!K33","v":114674.32559999995}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(N10:N15)","v":-33155.325599999953}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"OTHER",null,{"$f":"'SCH M-2.2'!V46","v":337989},null,null,"OTHER",null,{"$f":"+'SCH M-2.3'!R46","v":233047.58442933057},{"$f":"(I28-D28)/D28","v":-0.3104876654881355}]
[null,"TOTAL",{"$f":"SUM(C10:C28)","v":1215429},{"$f":"SUM(D10:D28)","v":111445824},null,null,"TOTAL",{"$f":"SUM(H10:H28)","v":32925639},{"$f":"SUM(I10:I28)","v":126714744.91002932},{"$f":"(I29-D29)/D29","v":0.13700756441111084},{"$f":"I29-D29","v":15268920.910029322}]

{"sheet":"Proposed Rates","index":14,"n_rows":40,"n_cols":15,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["PROPOSED RATE CALCULATIONS"]
[null,{"$f":"COMPANY","v":"DUKE ENERGY KENTUCKY"},null,null,null,{"$f":"COMPANY","v":"DUKE ENERGY KENTUCKY"},null,null,null,{"$f":"COMPANY","v":"DUKE ENERGY KENTUCKY"},null,null,null,{"$f":"COMPANY","v":"DUKE ENERGY KENTUCKY"}]
[null,{"$f":"CASE","v":"CASE NO. 2021-00190"},null,null,null,{"$f":"CASE","v":"CASE NO. 2021-00190"},null,null,null,{"$f":"CASE","v":"CASE NO. 2021-00190"},null,null,null,{"$f":"CASE","v":"CASE NO. 2021-00190"}]
[null,"PROPOSED RATE CALCULATION",null,null,null,"PROPOSED RATE CALCULATION",null,null,null,"PROPOSED RATE CALCULATION",null,null,null,"PROPOSED RATE CALCULATION"]
[null,"Rate:  RS",null,null,null,"Rate:  GS",null,null,null,"Rate:  FT-Large",null,null,null,"Rate:  IT"]
[null,null,"Test Period",null,null,null,"Test Period",null,null,null,"Test Period"]
[null,"Customer Bills",{"$f":"'Rate RS'!F24","v":1130041},null,null,"Customer Bills",{"$f":"'Rate GS COM'!F24+'Rate GS IND'!F24+'Rate GS OPA'!F24","v":84032},null,null,"Customer Bills",{"$f":"'Rate FT-LG'!F22","v":1092},null,null,"Customer Bills",{"$f":"'Rate IT'!F22","v":264}]
[null,"COSS - RS Customer Component",{"$f":"'Revenue Requirements'!H10","v":28611566},null,null,"COSS - GS Customer Component",{"$f":"'Revenue Requirements'!H11+'Revenue Requirements'!H12+'Revenue Requirements'!H13","v":4095886},null,null,"COSS - FT-L Customer Component",{"$f":"'Revenue Requirements'!H14","v":132688},null,null,"COSS - IT Customer Component",{"$f":"'Revenue Requirements'!H15","v":85499}]
[null,"COSS Customer Charge",{"$f":"ROUND(C8/C7,2)","v":25.32},null,null,"COSS Customer Charge",{"$f":"ROUND(G8/G7,2)","v":48.74},null,null,"COSS Customer Charge",{"$f":"ROUND(K8/K7,2)","v":121.51},null,null,"COSS Customer Charge",{"$f":"ROUND(O8/O7,2)","v":323.86}]
[null,"Current Customer Charge",{"$f":"CUR_RS_CUST","v":16.5},null,null,"Current Customer Charge",{"$f":"CUR_GS_CUST","v":50},null,null,"Current Customer Charge",{"$f":"CUR_FTL_CUST","v":430},null,null,"Current Customer Charge",{"$f":"CUR_IT_CUST","v":430}]
[null,"Gap",{"$f":"C9-C10","v":8.82},null,null,"Gap",{"$f":"G9-G10","v":-1.259999999999998},null,null,"Gap",{"$f":"K9-K10","v":-308.49},null,null,"Gap",{"$f":"O9-O10","v":-106.13999999999999}]
[null,"Migration @ % of Justified",{"$f":"ROUND(C11*$C$29,2)","v":3.53},null,null,"Migration @ % of Justified",{"$f":"ROUND(G11*$C$29,2)","v":-0.5},null,null,"Migration @ % of Justified",{"$f":"ROUND(K11*$C$29,2)","v":-123.4},null,null,"Migration @ % of Justified",{"$f":"ROUND(O11*$C$29,2)","v":-42.46}]
[null,"Customer Charge at % Migration to COSS",{"$f":"C10+C12","v":20.03},null,null,"Customer Charge at % Migration to COSS",{"$f":"G10+G12","v":49.5},null,null,"Customer Charge at % Migration to COSS",{"$f":"K10+K12","v":306.60000000000002},null,null,"Customer Charge at % Migration to COSS",{"$f":"O10+O12","v":387.54}]
[null,"Proposed Customer Charge",19,null,null,"Proposed Customer Charge",58,null,null,"Proposed Customer Charge",430,null,null,"Proposed Customer Charge",430]
[null,"Proposed Customer Charge Revenues",{"$f":"'Rate RS'!R24","v":21470779},null,null,"Proposed Customer Charge Revenues",{"$f":"'Rate GS COM'!R24+'Rate GS IND'!R24+'Rate GS OPA'!R24","v":4873856},null,null,"Proposed Customer Charge Revenues",{"$f":"'Rate FT-LG'!R22","v":469560},null,null,"Proposed Customer Charge Revenues",{"$f":"'Rate IT'!R22","v":113520}]
[]
[null,"COSS - RS Revenue Requirement",{"$f":"'Revenue Requirements'!I10","v":83658696},null,null,"COSS - GS Revenue Requirement",{"$f":"SUM('Revenue Requirements'!I11:I13)","v":33691438},null,null,"COSS - FT-L Revenue Requirement",{"$f":"'Revenue Requirements'!I14","v":6791839},null,null,"COSS - IT Revenue Requirement",{"$f":"'Revenue Requirements'!I15","v":2225050}]
[null,"Less Proposed Customer Charge Revenues Less GCA",{"$f":"C17-C15-'Rate RS'!P29","v":35860885},null,null,"Less Proposed Customer Charge Revenues Less GCA",{"$f":"G17-G15-'Rate GS COM'!P27-'Rate GS IND'!P27-'Rate GS OPA'!P27","v":14691108},null,null,"Less Proposed Customer Charge Revenues Less GCA/GCAT",{"$f":"K17-K15-'Rate FT-LG'!P25","v":6322279},null,null,"Less Proposed Customer Charge Revenues Less GCA",{"$f":"O17-O15-'Rate IT'!P25","v":2111530}]
[null,"Test Period MCF",{"$f":"'Rate RS'!H27","v":6481298},null,null,"Less Interdeptartmental",{"$f":"+G30","v":32824.910029330524},null,null,"Change in Min Amazon",{"$f":"+K33","v":-114674.32559999995},null,null,"Test Period MCF",{"$f":"'Rate IT'!H25","v":1672200}]
[null,"Proposed Delivery Charge",{"$f":"ROUND(C18/C19,4)","v":5.5330000000000004},null,null,"GS Rev Requirement",{"$f":"+G18-G19","v":14658283.089970669},null,null,"FT-L Rev Requirement",{"$f":"+K18-K19","v":6436953.3256000001},null,null,"Proposed Energy Charge",{"$f":"ROUND(O18/O19,4)","v":1.2626999999999999}]
[null,"Check to Revenue Requirements",{"$f":"'Rate RS'!R29-C17","v":137},null,null,"Test Period MCF",{"$f":"'Rate GS COM'!H27+'Rate GS IND'!H27+'Rate GS OPA'!H27","v":3477714},null,null,"Test Period MCF",{"$f":"'Rate FT-LG'!H25","v":2736182},null,null,"Check to Revenue Requirements",{"$f":"'Rate IT'!R27-O17","v":-43}]
[null,null,null,null,null,"Proposed Energy Charge",{"$f":"ROUND(G20/G21,4)","v":4.2149000000000001},null,null,"Proposed Energy Charge",{"$f":"ROUND(K20/K21,4)-0.0001","v":2.3523999999999998}]
[null,null,null,null,null,"Check to Revenue Requirements",{"$f":"'Rate GS COM'!R29+'Rate GS IND'!R29+'Rate GS OPA'!R29-G17+G30","v":-66.089970669476315},null,null,"Check to Revenue Requirements",{"$f":"'Rate FT-LG'!R27-K17+K33","v":-358.32559999995283}]
[]
[]
[]
[null,null,null,null,null,"Current Interdept Rev",{"$f":"+'SCH M-2.2'!V41","v":27765},null,"Amazon Annual Delivery Component",null,655877]
[null,null,null,null,null,"GS Increase %",{"$f":"+'Revenue Requirements'!J11","v":0.18224059172809387},null,"Annual Usage Required",null,{"$f":"+(K27-(12*K14))/K35","v":276618.34721986059}]
[null,"Migration Percentage",0.4,null,null,"Interdept Increase",{"$f":"+G27*G28","v":5059.9100293305264},null,"Estimated Annual Usage",null,215594]
[null,null,null,null,null,"Proposed Intdept Rev",{"$f":"+G27+G29","v":32824.910029330524},null,"Projected Shortfall",null,{"$f":"+K28-K29","v":61024.347219860589}]
[null,null,null,null,null,null,null,null,"New Minumum Usage Revenue",null,{"$f":"+K30*K35","v":143553.67440000005}]
[null,null,null,null,null,null,null,null,"Original Min Usage Revenue",null,{"$f":"+'SCH M-2.2'!L42","v":258228}]
[null,null,null,null,null,null,null,null,"Change in Min Usage Revenue",null,{"$f":"+K31-K32","v":-114674.32559999995}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND((K18-K27+12*K14+K32)/(K21-K29),4)-0.0001","v":2.3523999999999998}]
[]
[]
[null,null,{"$f":"+'SCH M'!G50","v":129982202.58442932}]
[null,null,126681928]
[null,null,{"$f":"+C38-C39","v":3300274.5844293237}]

{"sheet":"Avg Incr","index":15,"n_rows":24,"n_cols":11,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null," BILL DATA INCLUDING RIDERS LESS COST of GAS",null,null,null,null,"TOTAL","TOTAL"]
[null,null,null,null,null,"DOLLAR","PERCENT",null,"CURRENT","PROPOSED","PERCENT"]
[null,"Average","Average","CURRENT","PROPOSED","INCREASE","INCREASE","GAS","BILL","BILL","INCREASE"]
["RATE","USE","USE","BILL","BILL","(D - C)","(E / C)","COST (1)","(C + G)","(D + G)","(I-H) /H"]
["CODE","(B)","(B)","(C)","(D)","(E)","(F)","(G)","(H)","(I)","(L)"]
[null,"(CCF)","(MCF)","($)","($)","($)","(%)","($)","($)","($)","(%)"]
[]
["RS",{"$f":"+C9*10","v":57},{"$f":"ROUND(+'Rate RS'!H27/'Rate RS'!F24,1)","v":5.7},{"$f":"ROUND(C9*(CUR_RS+CUR_RS_DSM)+CUR_RS_CUST+CUR_RS_HEA,2)","v":46.16},{"$f":"ROUND(C9*(PRO_RS_COM+PRO_RS_DSM)+PRO_RS_CUST+PRO_RS_HEA,2)","v":53.45},{"$f":"E9-D9","v":7.2900000000000063},{"$f":"ROUND(F9/D9,3)*100","v":15.8},{"$f":"ROUND(C9*EGC,2)","v":23.15},{"$f":"D9+H9","v":69.31},{"$f":"E9+H9","v":76.599999999999994},{"$f":"ROUND((J9-I9)/I9,3)","v":0.105}]
["GS-Comm",{"$f":"+C10*10","v":363},{"$f":"ROUND('Rate GS COM'!H27/'Rate GS COM'!F24,1)","v":36.299999999999997},{"$f":"ROUND(C10*(CUR_GS)+CUR_GS_CUST,2)","v":156.15},{"$f":"ROUND(C10*(+PRO_GS)+PRO_GS_CUST,2)","v":211},{"$f":"E10-D10","v":54.849999999999994},{"$f":"ROUND(F10/D10,3)*100","v":35.099999999999994},{"$f":"ROUND(C10*EGC,2)","v":147.44999999999999},{"$f":"D10+H10","v":303.60000000000002},{"$f":"E10+H10","v":358.45},{"$f":"ROUND((J10-I10)/I10,3)","v":0.18099999999999999}]
["GS-Ind",1151,{"$f":"ROUND('Rate GS IND'!H27/'Rate GS IND'!F24,1)","v":115.1},{"$f":"ROUND(C11*(CUR_GS)+CUR_GS_CUST,2)","v":386.59},{"$f":"ROUND(C11*(+PRO_GS)+PRO_GS_CUST,2)","v":543.13},{"$f":"E11-D11","v":156.54000000000002},{"$f":"ROUND(F11/D11,3)*100","v":40.5},{"$f":"ROUND(C11*EGC,2)","v":467.54},{"$f":"D11+H11","v":854.13},{"$f":"E11+H11","v":1010.6700000000001},0.183]
["GS-OPA",1138,{"$f":"ROUND('Rate GS OPA'!H27/'Rate GS OPA'!F24,1)","v":113.8},382.79,537.66,154.86999999999995,40.5,{"$f":"ROUND(C12*EGC,2)","v":462.26},{"$f":"D12+H12","v":845.05},{"$f":"E12+H12","v":999.92},0.183]
["FT-L",25057,{"$f":"ROUND('Rate FT-LG'!H25/'Rate FT-LG'!F22,1)","v":2505.6999999999998},{"$f":"ROUND(C13*(CUR_FTL_COM+CUR_FTL_GCAT),2)+CUR_FTL_CUST","v":4847.55},{"$f":"ROUND(C13*(PRO_FTL_COM+PRO_FTL_GCAT),2)+PRO_FTL_CUST","v":6179.08},{"$f":"E13-D13","v":1331.5299999999997},{"$f":"ROUND(F13/D13,3)*100","v":27.500000000000004},0,{"$f":"D13+H13","v":4847.55},{"$f":"E13+H13","v":6179.08},0.27500000000000002]
["IT",63341,{"$f":"ROUND('Rate IT'!H25/'Rate IT'!F22,1)","v":6334.1},{"$f":"ROUND(C14*(CUR_IT_COM),2)+CUR_IT_CUST","v":6752.7},{"$f":"ROUND(C14*(PRO_IT_COM),2)+PRO_IT_CUST","v":8428.07},{"$f":"E14-D14","v":1675.37},{"$f":"ROUND(F14/D14,3)*100","v":24.8},0,6752.7,8428.07,0.248]
[]
["IMBS",{"$f":"+B13+B14","v":88398},{"$f":"+C13+C14","v":8839.7999999999993},{"$f":"ROUND(C16*B23,2)","v":969.73},{"$f":"ROUND(C16*B24,2)","v":1207.52},{"$f":"E16-D16","v":237.78999999999996},{"$f":"ROUND(F16/D16,3)*100","v":24.5},0,{"$f":"D16+H16","v":969.73},{"$f":"E16+H16","v":1207.52},{"$f":"ROUND((J16-I16)/I16,3)","v":0.245}]
[]
[]
[]
[]
[]
["IMBS"]
["Current Rate",0.10970000000000001,"/mcf"]
["Proposed Rate",0.1366,"/mcf"]