{"text_format":"1","workbook":"xlsx","n_sheets":18,"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","SCH N Rider PMM","Revenue Requirements","Proposed Rates","Avg Incr","Module1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":249,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Module1","index":17,"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 WITHOUT RIDERS"}]
[]
["Input Areas in Grey"]
[null,"12 MONTHS FORECASTED",null,{"$f":"IF(H9=1,\"INCLUDES ALL RIDERS\",\"\")","v":""}]
[]
[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,2]
[]
[null,"TYPE OF SERVICE:","(GAS SERVICE)"]
[null,"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"]
[null,"TYPE OF FILING: ___ ORIGINAL   ___UPDATED  _X_ 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},{"$f":"IF($H$9=1,H22,0)","v":0},"Monthly",null,0.3,0.3,"Monthly "]
[null,"     Rate RS",{"$f":"IF($H$9=1,G23,0)","v":0},{"$f":"IF($H$9=1,H23,0)","v":0},"$ 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":0},{"$f":"IF($H$9=1,H29,0)","v":0},"$ 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":17.5},"$ per Month"]
[null,"     Delivery Rate",4.6920000000000002,{"$f":"'Proposed Rates'!C20","v":5.4438000000000004},"$ 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":3.5676000000000001},"$ 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.0377000000000001},"$ 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.0815999999999999},"$ 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: ___ ORIGINAL   ___UPDATED  _X_ 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":""}]
[]
[]
[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":75382959},null,{"$f":"'Rate RS'!R38","v":81385640},null,{"$f":"G21-E21","v":6002681},null,{"$f":"IF(E21=0,\"0.00%\",ROUND(I21/E21,4))","v":7.9600000000000004E-2}]
[3,null,"TOTAL RS",null,{"$f":"E21","v":75382959},null,{"$f":"G21","v":81385640},null,{"$f":"I21","v":6002681},null,{"$f":"IF(E22=0,\"0.00%\",ROUND(I22/E22,4))","v":7.9600000000000004E-2}]
[]
[4,null,"GS COMMERCIAL",null,{"$f":"'Rate GS COM'!AN77","v":23890508},null,{"$f":"'Rate GS COM'!R37","v":26357316},null,{"$f":"G24-E24","v":2466808},null,{"$f":"IF(E24=0,\"0.00%\",ROUND(I24/E24,4))","v":0.1033}]
[5,null,"GS INDUSTRIAL",null,{"$f":"'Rate GS IND'!AN82","v":2459804},null,{"$f":"'Rate GS IND'!R37","v":2696080},null,{"$f":"G25-E25","v":236276},null,{"$f":"IF(E25=0,\"0.00%\",ROUND(I25/E25,4))","v":9.6100000000000005E-2}]
[6,null,"GS OTHER PUB AUTH",null,{"$f":"'Rate GS OPA'!AN79","v":2147642},null,{"$f":"'Rate GS OPA'!R37","v":2354026},null,{"$f":"G26-E26","v":206384},null,{"$f":"IF(E26=0,\"0.00%\",ROUND(I26/E26,4))","v":9.6100000000000005E-2}]
[7,null,"TOTAL GS",null,{"$f":"SUM(E24:E26)","v":28497954},null,{"$f":"SUM(G24:G26)","v":31407422},null,{"$f":"SUM(I24:I26)","v":2909468},null,{"$f":"IF(E27=0,\"0.00%\",ROUND(I27/E27,4))","v":0.1021}]
[]
[8,null,"     TOTAL SALES SERVICE",null,{"$f":"E22+E27","v":103880913},null,{"$f":"G22+G27","v":112793062},null,{"$f":"I22+I27","v":8912149},null,{"$f":"IF(E29=0,\"0.00%\",ROUND(I29/E29,4))","v":8.5800000000000001E-2}]
[]
[9,null,"TRANSPORTATION:"]
[]
[10,null,"FT LARGE",null,{"$f":"'Rate FT-LG'!AN73","v":5697047},null,{"$f":"'Rate FT-LG'!R34","v":6045078},null,{"$f":"G33-E33","v":348031},null,{"$f":"IF(E33=0,\"0.00%\",ROUND(I33/E33,4))","v":6.1100000000000002E-2}]
[11,null,"IT",null,{"$f":"'Rate IT'!AN74","v":1782710},null,{"$f":"'Rate IT'!R34","v":1922172},null,{"$f":"G34-E34","v":139462},null,{"$f":"IF(E34=0,\"0.00%\",ROUND(I34/E34,4))","v":7.8200000000000006E-2}]
[12,null,"     TOTAL TRANSPORTATION",null,{"$f":"SUM(E33:E34)","v":7479757},null,{"$f":"SUM(G33:G34)","v":7967250},null,{"$f":"SUM(I33:I34)","v":487493},null,{"$f":"IF(E35=0,\"0.00%\",ROUND(I35/E35,4))","v":6.5199999999999994E-2}]
[13,null,"TOTAL THROUGHPUT",null,{"$f":"E35+E29","v":111360670},null,{"$f":"G35+G29","v":120760312},null,{"$f":"I35+I29","v":9399642},null,{"$f":"IF(E36=0,\"0.00%\",ROUND(I36/E36,4))","v":8.4400000000000003E-2}]
[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":30629.367042981401},null,2864.367042981401,null,0.1032]
[20,null,"MINIMUM USE CONTRACT",null,{"$f":"'SCH M-2.2'!V42","v":258228},null,{"$f":"'SCH M-2.3'!R42","v":211422.66560000004},null,-46805.334399999963,null,-0.18129999999999999]
[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":298721.03264298144},null,{"$f":"SUM(I39:I47)","v":-39267.967357018562},null,-0.1162]
[]
[25,null,"TOTAL COMPANY REVENUE",null,{"$f":"E29++E35+E48","v":111698659},null,{"$f":"G29++G35+G48","v":121059033.03264298},null,{"$f":"I29++I35+I48","v":9360374.032642981},null,{"$f":"IF(I50=0,\"0.00%\",ROUND(I50/E50,4))","v":8.3799999999999999E-2}]

{"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: ___ ORIGINAL   ___UPDATED  _X_ 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":""},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":49055927},null,{"$f":"IF(H19=0,\"-\",ROUND(J19/H19,4))","v":7.5688000000000004},null,{"$f":"IF(ABS(J19/$J$34*100)<0.005,\"-\",ROUND(J19/$J$34*100,2))-0.01","v":69.099999999999994},null,{"$f":"'Rate RS'!AL79","v":26327032},null,{"$f":"J19+P19","v":75382959},null,{"$f":"IF(ABS(R19/$R$34*100)<0.005,\"-\",ROUND(R19/$R$34*100,2))","v":67.64}]
[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":17.309999999999999},null,{"$f":"'Rate GS COM'!AL77","v":11605162},null,{"$f":"J20+P20","v":23890508},null,21.44]
[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.57,null,{"$f":"'Rate GS IND'!AL82","v":1346492},null,2459804,null,2.21]
[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.37,null,{"$f":"'Rate GS OPA'!AL79","v":1174820},null,2147642,null,1.93]
[5,null,"FT-L","FIRM TRANSPORTATION-LARGE",null,{"$f":"'Rate FT-LG'!X73","v":1092},null,{"$f":"'Rate FT-LG'!Z73","v":2736182},null,{"$f":"'Rate FT-LG'!AD73","v":5452147},null,1.9925999999999999,null,7.68,null,{"$f":"'Rate FT-LG'!AL73","v":0},null,5452147,null,4.8899999999999997]
[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.5099999999999998,null,{"$f":"'Rate IT'!AL74","v":0},null,{"$f":"J24+P24","v":1782710},null,1.6]
[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.02,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.36,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":70983363},null,{"$f":"IF(H34=0,\"-\",ROUND(J34/H34,4))","v":4.9391999999999996},null,{"$f":"SUM(N19:N33)","v":99.990000000000009},null,{"$f":"SUM(P19:P33)","v":40470396},null,{"$f":"SUM(R19:R33)","v":111453759},null,{"$f":"SUM(T19:T33)","v":99.999999999999986}]
[]
[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: ___ ORIGINAL   ___UPDATED  _X_ 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":""},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":7.5688000000000004},null,{"$f":"'Rate RS'!AD79","v":49055927},null,{"$f":"ROUND((L20/L$21)*100,2)","v":100},null,{"$f":"'Rate RS'!AH79","v":6002681},null,{"$f":"IF(L20=0,\"0.0 \",ROUND((P20/L20)*100,1))","v":12.2},null,{"$f":"'Rate RS'!AL79","v":26327032},null,{"$f":"'Rate RS'!AN79","v":75382959},null,{"$f":"IF(V20=0,\"0.0 \",ROUND((P20/V20)*100,1))","v":8}]
[3,null,null,"  TOTAL RS",null,{"$f":"F20","v":1130041},null,{"$f":"H20","v":6481298},null,{"$f":"ROUND((L21/H21),4)","v":7.5688000000000004},null,{"$f":"L20","v":49055927},null,{"$f":"ROUND((L21/$L48)*100,2)+0.01","v":69.12},null,{"$f":"P20","v":6002681},null,{"$f":"IF(L21=0,\"0.0 \",ROUND((P21/L21)*100,1))","v":12.2},null,{"$f":"T20","v":26327032},null,{"$f":"V20","v":75382959},null,{"$f":"IF(V21=0,\"0.0 \",ROUND((P21/V21)*100,1))","v":8}]
[]
[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":2466808},null,{"$f":"IF(L23=0,\"0.0 \",ROUND((P23/L23)*100,1))","v":20.100000000000001},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":10.3}]
[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":236276},null,{"$f":"IF(L24=0,\"0.0 \",ROUND((P24/L24)*100,1))","v":21.2},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":9.6}]
[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":206384},null,{"$f":"IF(L25=0,\"0.0 \",ROUND((P25/L25)*100,1))","v":21.2},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":9.6}]
[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":20.25},null,{"$f":"SUM(P23:P25)","v":2909468},null,{"$f":"IF(L26=0,\"0.0 \",ROUND((P26/L26)*100,1))","v":20.2},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":10.199999999999999}]
[]
[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.3688000000000002},null,{"$f":"L21+L26","v":63427407},null,{"$f":"100-N33-N46","v":89.36},null,{"$f":"P21+P26","v":8912149},null,{"$f":"IF(L28=0,\"0.0 \",ROUND((P28/L28)*100,1))","v":14.1},null,{"$f":"T21+T26","v":40453506},null,{"$f":"V21+V26","v":103880913},null,{"$f":"IF(V28=0,\"0.0 \",ROUND((P28/V28)*100,1))","v":8.6}]
[]
[9,null,"TRANSPORTATION SERVICE:"]
[10,null,"FT-L","FIRM TRANSP - LARGE",null,{"$f":"'Rate FT-LG'!X73","v":1092},null,{"$f":"'Rate FT-LG'!Z73","v":2736182},null,{"$f":"ROUND((L31/H31),4)","v":1.9925999999999999},null,{"$f":"'Rate FT-LG'!AD73","v":5452147},null,{"$f":"ROUND((L31/L$33)*100,2)","v":75.36},null,{"$f":"'Rate FT-LG'!AH73","v":592931},null,{"$f":"IF(L31=0,\"0.0 \",ROUND((P31/L31)*100,1))","v":10.9},null,{"$f":"'Rate FT-LG'!AL73","v":0},null,{"$f":"'Rate FT-LG'!AN73","v":5697047},null,{"$f":"IF(V31=0,\"0.0 \",ROUND((P31/V31)*100,1))","v":10.4}]
[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":139462},null,{"$f":"IF(L32=0,\"0.0 \",ROUND((P32/L32)*100,1))","v":7.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":7.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":10.19},null,{"$f":"SUM(P31:P32)","v":732393},null,{"$f":"IF(L33=0,\"0.0 \",ROUND((P33/L33)*100,1))","v":10.1},null,{"$f":"SUM(T31:T32)","v":0},null,{"$f":"SUM(V31:V32)","v":7479757},null,{"$f":"IF(V33=0,\"0.0 \",ROUND((P33/V33)*100,1))","v":9.8000000000000007}]
[13,null,"TOTAL THROUGHPUT",null,null,{"$f":"F28+F33","v":1215429},null,{"$f":"H28+H33","v":14367394},null,{"$f":"ROUND((L34/H34),4)","v":4.9181999999999997},null,{"$f":"L28+L33","v":70662264},null,{"$f":"N28+N33","v":99.55},null,{"$f":"P28+P33","v":9644542},null,{"$f":"IF(L34=0,\"0.0 \",ROUND((P34/L34)*100,1))","v":13.6},null,{"$f":"T28+T33","v":40453506},null,{"$f":"V28+V33","v":111360670},null,{"$f":"IF(V34=0,\"0.0 \",ROUND((P34/V34)*100,1))","v":8.6999999999999993}]
[]
[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":2864.367042981401},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":-46805.334399999963},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.45},null,{"$f":"SUM(P37:P45)","v":-39267.967357018562},null,{"$f":"IF(L46=0,\"0.0 \",ROUND((P46/L46)*100,1))","v":-12.2},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":-11.6}]
[]
[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":4.9391999999999996},null,{"$f":"L28+L33+L46","v":70983363},null,100,null,{"$f":"P28+P33+P46","v":9605274.032642981},null,{"$f":"IF(L48=0,\"0.0 \",ROUND((P48/L48)*100,1))","v":13.5},null,{"$f":"T28+T33+T46","v":40470396},null,{"$f":"V28+V33+V46","v":111698659},null,{"$f":"IF(V48=0,\"0.0 \",ROUND((P48/V48)*100,1))","v":8.6}]
[]
[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: ___ ORIGINAL   ___UPDATED  _X_ 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":""},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":8.4949999999999992},null,{"$f":"'Rate RS'!L38","v":55058608},null,{"$f":"ROUND((L20/L$21)*100,2)","v":100},null,{"$f":"'Rate RS'!P38","v":26327032},null,{"$f":"'Rate RS'!R38","v":81385640}]
[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":8.4949999999999992},null,{"$f":"L20","v":55058608},null,{"$f":"ROUND((L21/L$48)*100,2)","v":68.319999999999993},null,{"$f":"P20","v":26327032},null,{"$f":"R20","v":81385640}]
[]
[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.1635},null,{"$f":"'Rate GS COM'!L37","v":14752154},null,{"$f":"ROUND((L23/L$26)*100,2)","v":85.37},null,{"$f":"'Rate GS COM'!P37","v":11605162},null,{"$f":"'Rate GS COM'!R37","v":26357316}]
[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.0712999999999999},null,{"$f":"'Rate GS IND'!L37","v":1349588},null,{"$f":"ROUND((L24/L$26)*100,2)","v":7.81},null,{"$f":"'Rate GS IND'!P37","v":1346492},null,{"$f":"'Rate GS IND'!R37","v":2696080}]
[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.0772000000000004},null,{"$f":"'Rate GS OPA'!L37","v":1179206},null,{"$f":"ROUND((L25/L$26)*100,2)","v":6.82},null,{"$f":"'Rate GS OPA'!P37","v":1174820},null,{"$f":"'Rate GS OPA'!R37","v":2354026}]
[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":4.9691000000000001},null,{"$f":"SUM(L23:L25)","v":17280948},null,{"$f":"ROUND((L26/L$48)*100,2)","v":21.44},null,{"$f":"SUM(P23:P25)","v":14126474},null,{"$f":"SUM(R23:R25)","v":31407422}]
[]
[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":7.2637},null,{"$f":"L21+L26","v":72339556},null,{"$f":"ROUND((L28/L$48)*100,2)","v":89.76},null,{"$f":"P21+P26","v":40453506},null,{"$f":"R21+R26","v":112793062}]
[]
[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.2092999999999998},null,{"$f":"'Rate FT-LG'!L34","v":6045078},null,{"$f":"ROUND((L31/L$33)*100,2)","v":75.87},null,{"$f":"'Rate FT-LG'!P34","v":0},null,{"$f":"'Rate FT-LG'!R34","v":6045078}]
[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.1495},null,{"$f":"'Rate IT'!L34","v":1922172},null,{"$f":"ROUND((L32/L$33)*100,2)","v":24.13},null,{"$f":"'Rate IT'!P34","v":0},null,{"$f":"'Rate IT'!R34","v":1922172}]
[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":1.8072999999999999},null,{"$f":"SUM(L31:L32)","v":7967250},null,{"$f":"ROUND((L33/L$48)*100,2)","v":9.89},null,{"$f":"SUM(P31:P32)","v":0},null,{"$f":"SUM(R31:R32)","v":7967250}]
[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":5.5895000000000001},null,{"$f":"L28+L33","v":80306806},null,{"$f":"N28+N33","v":99.65},null,{"$f":"P28+P33","v":40453506},null,{"$f":"R28+R33","v":120760312}]
[]
[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,9.73,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,9.9499999999999993,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.24,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":13739.367042981401},null,4.88,null,{"$f":"'SCH M-2.2'!T41","v":16890},null,{"$f":"'Proposed Rates'!G30","v":30629.367042981401}]
[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":211422.66560000004},null,75.02,null,0,null,211422.66560000004]
[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.19,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":281831.03264298144},null,{"$f":"ROUND((L46/L$48)*100,2)","v":0.35},null,{"$f":"SUM(P37:P45)","v":16890},null,{"$f":"SUM(R37:R45)","v":298721.03264298144}]
[]
[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":5.6074999999999999},null,{"$f":"L28+L33+L46","v":80588637.032642975},null,100,null,{"$f":"P28+P33+P46","v":40470396},null,{"$f":"R28+R33+R46","v":121059033.03264298}]
[]
[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: ___ ORIGINAL   ___UPDATED  _X_ 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":17.5},null,{"$f":"ROUND(F24*J24,0)","v":19775718},null,{"$f":"ROUND((L24/$L$38)*100,1)","v":35.9},null,null,null,{"$f":"L24+P24","v":19775718}]
[]
[6,null,"COMMODITY CHARGE:"]
[7,null,"     ALL CONSUMPTION",null,null,null,null,6481298,2.64,{"$f":"PRO_RS_COM","v":5.4438000000000004},null,{"$f":"ROUND((H27*J27),0)","v":35282890},null,{"$f":"ROUND((L27/$L$38)*100,1)","v":64.099999999999994},null,{"$f":"ROUND(H27*EGC,0)","v":26327032},null,{"$f":"L27+P27","v":61609922}]
[]
[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":55058608},null,{"$f":"ROUND((L29/$L$38)*100,1)","v":100},null,{"$f":"SUM(P24:P27)","v":26327032},null,{"$f":"SUM(R24:R27)","v":81385640}]
[]
[9,null,"RIDERS:"]
[10,null,"HOME ENERGY ASSISTANCE PROGRAM (HEA)",null,null,null,null,null,null,{"$f":"PRO_RS_HEA","v":0},null,{"$f":"ROUND(F24*PRO_RS_HEA,0)","v":0},null,{"$f":"ROUND((L32/$L$38)*100,1)","v":0},null,null,null,{"$f":"L32+P32","v":0}]
[11,null,"DEMAND SIDE MANAGEMENT RATE (DSMR)",null,null,null,null,null,null,{"$f":"PRO_RS_DSM","v":0},null,{"$f":"ROUND(H27*J33,0)","v":0},null,{"$f":"ROUND((L33/$L$38)*100,1)","v":0},null,null,null,{"$f":"L33+P33","v":0}]
[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":0},null,{"$f":"ROUND((L36/$L$38)*100,1)","v":0},null,null,null,{"$f":"SUM(R32:R34)","v":0}]
[]
[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":55058608},null,{"$f":"SUM(N29+N36)","v":100},null,{"$f":"P29+P36","v":26327032},null,{"$f":"R29+R36","v":81385640}]
[]
[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: ___ ORIGINAL   ___UPDATED  _X_ 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":38},null,{"$f":"L24-AD65","v":1130041},null,{"$f":"IF(AD65=0,\"0.0 \",ROUND((AH65/AD65)*100,1))","v":6.1},null,null,null,{"$f":"AD65+AL65","v":18645677},null,{"$f":"IF(AN65=0,\"0.0 \",ROUND((AH65/AN65)*100,1))","v":6.1}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,"COMMODITY CHARGE:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,null,"     ALL CONSUMPTION",null,null,null,{"$f":"H27","v":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":62},null,{"$f":"L27-AD68","v":4872640},null,{"$f":"IF(AD68=0,\"0.0 \",ROUND((AH68/AD68)*100,1))","v":16},null,{"$f":"P27","v":26327032},null,{"$f":"AD68+AL68","v":56737282},null,{"$f":"IF(AN68=0,\"0.0 \",ROUND((AH68/AN68)*100,1))","v":8.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":100},null,{"$f":"SUM(AH65:AH68)","v":6002681},null,{"$f":"IF(AD70=0,\"0.0 \",ROUND((AH70/AD70)*100,1))","v":12.2},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":8}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,null,"RIDERS:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,"HOME ENERGY ASSISTANCE PROGRAM (HEA)",null,null,null,null,null,{"$f":"CUR_RS_HEA","v":0},null,{"$f":"ROUND(X65*CUR_RS_HEA,0)","v":0},null,{"$f":"ROUND((AD73/$AD$79)*100,1)","v":0},null,{"$f":"L32-AD73","v":0},null,{"$f":"IF(AD73=0,\"0.0 \",ROUND((AH73/AD73)*100,1))","v":"0.0 "},null,null,null,{"$f":"AD73+AL73","v":0},null,{"$f":"IF(AN73=0,\"0.0 \",ROUND((AH73/AN73)*100,1))","v":"0.0 "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,null,"DEMAND SIDE MANAGEMENT RATE (DSMR)",null,null,null,null,null,{"$f":"CUR_RS_DSM","v":0},null,{"$f":"ROUND(Z68*AB74,0)","v":0},null,{"$f":"ROUND((AD74/$AD$79)*100,1)","v":0},null,{"$f":"L33-AD74","v":0},null,{"$f":"IF(AD74=0,\"0.0 \",ROUND((AH74/AD74)*100,1))","v":"0.0 "},null,null,null,{"$f":"AD74+AL74","v":0},null,{"$f":"IF(AN74=0,\"0.0 \",ROUND((AH74/AN74)*100,1))","v":"0.0 "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$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":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":"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":49055927},null,{"$f":"SUM(AF70+AF77)","v":100},null,{"$f":"AH70+AH77","v":6002681},null,{"$f":"IF(AD79=0,\"0.0 \",ROUND((AH79/AD79)*100,1))","v":12.2},null,{"$f":"P38","v":26327032},null,{"$f":"AN70+AN77","v":75382959},null,{"$f":"IF(AN79=0,\"0.0 \",ROUND((AH79/AN79)*100,1))","v":8}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(1) BILLS THAT TERMINATE IN RESPECTIVE RATE STEPS."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(2) REFLECTS NORMALIZED VOLUMES."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"(3) REFLECTS AVERAGE EXPECTED GAS COST OF \"&TEXT(EGC,\"$0.000\")&\"/MCF.\"","v":"(3) REFLECTS AVERAGE EXPECTED GAS COST OF $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: ___ ORIGINAL   ___UPDATED  _X_ 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":30.9},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":3.5676000000000001},null,{"$f":"ROUND((H27*J27),0)","v":10192658},null,{"$f":"ROUND((L27/$L$37)*100,1)","v":69.099999999999994},null,{"$f":"ROUND(H27*EGC,0)","v":11605162},null,{"$f":"L27+P27","v":21797820}]
[]
[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":14752154},null,{"$f":"ROUND((L29/$L$37)*100,1)","v":100},null,{"$f":"SUM(P24:P27)","v":11605162},null,{"$f":"SUM(R24:R27)","v":26357316}]
[]
[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":14752154},null,{"$f":"N29+N35","v":100},null,{"$f":"P29+P35","v":11605162},null,{"$f":"R29+R35","v":26357316}]
[]
[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: ___ ORIGINAL   ___UPDATED  _X_ 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":1837912},null,{"$f":"IF(AD67=0,\"0.0 \",ROUND((AH67/AD67)*100,1))","v":22},null,{"$f":"P27","v":11605162},null,{"$f":"AD67+AL67","v":19959908},null,{"$f":"IF(AN67=0,\"0.0 \",ROUND((AH67/AN67)*100,1))","v":9.1999999999999993}]
[]
[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":2466808},null,{"$f":"IF(AD69=0,\"0.0 \",ROUND((AH69/AD69)*100,1))","v":20.100000000000001},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":10.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":"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":2466808},null,{"$f":"IF(AD77=0,\"0.0 \",ROUND((AH77/AD77)*100,1))","v":20.100000000000001},null,{"$f":"P37","v":11605162},null,{"$f":"AN69+AN75","v":23890508},null,{"$f":"IF(AN77=0,\"0.0 \",ROUND((AH77/AN77)*100,1))","v":10.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."}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,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: ___ ORIGINAL   ___UPDATED  _X_ 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":12.4},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":3.5676000000000001},null,{"$f":"ROUND((H27*J27),0)","v":1182606},null,{"$f":"ROUND((L27/$L$37)*100,1)","v":87.6},null,{"$f":"ROUND(EGC*$H27,0)","v":1346492},null,{"$f":"L27+P27","v":2529098}]
[]
[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":1349588},null,{"$f":"ROUND((L29/$L$37)*100,1)","v":100},null,{"$f":"SUM(P24:P27)","v":1346492},null,{"$f":"SUM(R24:R27)","v":2696080}]
[]
[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":1349588},null,{"$f":"N29+N35","v":100},null,{"$f":"P29+P35","v":1346492},null,{"$f":"R29+R35","v":2696080}]
[]
[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: ___ ORIGINAL   ___UPDATED  _X_ 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":213244},null,{"$f":"IF(AD72=0,\"0.0 \",ROUND((AH72/AD72)*100,1))","v":22},null,{"$f":"P27","v":1346492},null,{"$f":"AD72+AL72","v":2315854},null,{"$f":"IF(AN72=0,\"0.0 \",ROUND((AH72/AN72)*100,1))","v":9.1999999999999993}]
[]
[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":236276},null,{"$f":"IF(AD74=0,\"0.0 \",ROUND((AH74/AD74)*100,1))","v":21.2},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":9.6}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,null,"RIDERS:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,{"$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":236276},null,{"$f":"IF(AD82=0,\"0.0 \",ROUND((AH82/AD82)*100,1))","v":21.2},null,{"$f":"P37","v":1346492},null,{"$f":"AN74+AN80","v":2459804},null,{"$f":"IF(AN82=0,\"0.0 \",ROUND((AH82/AN82)*100,1))","v":9.6}]
[]
[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: ___ ORIGINAL   ___UPDATED  _X_ 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":12.5},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":3.5676000000000001},null,{"$f":"ROUND((H27*J27),0)","v":1031828},null,{"$f":"ROUND((L27/$L$37)*100,1)","v":87.5},null,{"$f":"ROUND(EGC*$H27,0)","v":1174820},null,{"$f":"L27+P27","v":2206648}]
[]
[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":1179206},null,{"$f":"ROUND((L29/$L$37)*100,1)","v":100},null,{"$f":"SUM(P24:P27)","v":1174820},null,{"$f":"SUM(R24:R27)","v":2354026}]
[]
[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":1179206},null,{"$f":"SUM(N29+N35)","v":100},null,{"$f":"P29+P35","v":1174820},null,{"$f":"R29+R35","v":2354026}]
[]
[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: ___ ORIGINAL   ___UPDATED  _X_ 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":186056},null,{"$f":"IF(AD69=0,\"0.0 \",ROUND((AH69/AD69)*100,1))","v":22},null,{"$f":"P27","v":1174820},null,{"$f":"AD69+AL69","v":2020592},null,{"$f":"IF(AN69=0,\"0.0 \",ROUND((AH69/AN69)*100,1))","v":9.1999999999999993}]
[]
[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":206384},null,{"$f":"IF(AD71=0,\"0.0 \",ROUND((AH71/AD71)*100,1))","v":21.2},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":9.6}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,null,"RIDERS:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,"DEMAND SIDE MANAGEMENT RATE (DSMR)",null,null,null,null,null,{"$f":"CUR_GS_DSM","v":0},null,{"$f":"ROUND(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":206384},null,{"$f":"IF(AD79=0,\"0.0 \",ROUND((AH79/AD79)*100,1))","v":21.2},null,{"$f":"P37","v":1174820},null,{"$f":"AN71+AN77","v":2147642},null,{"$f":"IF(AN79=0,\"0.0 \",ROUND((AH79/AN79)*100,1))","v":9.6}]
[]
[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":77,"n_cols":42,"rows_kept":77,"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: ___ ORIGINAL   ___UPDATED  _X_ 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":7.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.0377000000000001},null,{"$f":"ROUND((H25*J25),0)","v":5575518},null,{"$f":"ROUND((L25/L$34)*100,1)","v":92.2},null,null,null,{"$f":"L25+P25","v":5575518}]
[]
[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":6045078},null,{"$f":"SUM(N22:N25)","v":100},null,null,null,{"$f":"SUM(R22:R25)","v":6045078}]
[]
[7,null,"RIDERS:"]
[8,null,"GAS COST ADJUSTMENT TRANSITION (GCAT) (2)",null,null,null,null,null,null,{"$f":"PRO_FTL_GCAT","v":0},null,null,null,{"$f":"ROUND((L30/L$34)*100,1)","v":0},null,{"$f":"ROUND(H25*R37*J30,0)","v":0},null,{"$f":"L30+P30","v":0}]
[]
[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":0},null,{"$f":"SUM(R30:R30)","v":0}]
[]
[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":6045078},null,{"$f":"SUM(N27+N32)","v":100},null,{"$f":"P32+P27","v":0},null,{"$f":"R27+R32","v":6045078}]
[]
[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: ___ ORIGINAL   ___UPDATED  _X_ 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$73=0,\"0.0 \",ROUND((AD59/AD$73)*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$73=0,\"0.0 \",ROUND((AD62/AD$73)*100,1))","v":91.4},null,{"$f":"L25-AD62","v":592931},null,{"$f":"IF(AD62=0,\"0.0 \",ROUND((AH62/AD62)*100,1))","v":11.9},null,null,null,{"$f":"AD62+AL62","v":4982587},null,{"$f":"IF(AN62=0,\"0.0 \",ROUND((AH62/AN62)*100,1))","v":11.9}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,"Adjustment to Revenue per Settlement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,244900]
[]
[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":592931},null,{"$f":"IF(AD66=0,\"0.0 \",ROUND((AH66/AD66)*100,1))","v":10.9},null,null,null,{"$f":"SUM(AN59:AN62)+AN64","v":5697047},null,{"$f":"IF(AN66=0,\"0.0 \",ROUND((AH66/AN66)*100,1))","v":10.4}]
[]
[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":0},null,null,null,{"$f":"IF(AD$73=0,\"0.0 \",ROUND((AD69/AD$73)*100,1))","v":0},null,{"$f":"L30-AD69","v":0},null,{"$f":"IF(AD69=0,\"0.0 \",ROUND((AH69/AD69)*100,1))","v":"0.0 "},null,{"$f":"ROUND(Z62*R37*AB69,0)","v":0},null,{"$f":"AD69+AL69","v":0},null,{"$f":"IF(AN69=0,\"0.0 \",ROUND((AH69/AN69)*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:AD69)","v":0},null,{"$f":"SUM(AF69:AF69)","v":0},null,{"$f":"SUM(AH69:AH69)","v":0},null,{"$f":"IF(AD71=0,\"0.0 \",ROUND((AH71/AD71)*100,1))","v":"0.0 "},null,{"$f":"SUM(AL69:AL69)","v":0},null,{"$f":"SUM(AN69:AN69)","v":0},null,{"$f":"IF(AN71=0,\"0.0 \",ROUND((AH71/AN71)*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 FT - LARGE INCLUDING RIDERS",null,{"$f":"X59","v":1092},null,{"$f":"Z62","v":2736182},null,null,null,{"$f":"SUM(AD66+AD71)","v":5452147},null,{"$f":"SUM(AF66+AF71)","v":100},null,{"$f":"SUM(AH66+AH71)","v":592931},null,{"$f":"IF(AD73=0,\"0.0 \",ROUND((AH73/AD73)*100,1))","v":10.9},null,{"$f":"SUM(AL66+AL71)","v":0},null,{"$f":"SUM(AN66+AN71)","v":5697047},null,{"$f":"IF(AN73=0,\"0.0 \",ROUND((AH73/AN73)*100,1))","v":10.4}]
[]
[]
[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: ___ ORIGINAL   ___UPDATED  _X_ 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.9},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.0815999999999999},null,{"$f":"ROUND((H25*(J25)),0)","v":1808652},null,{"$f":"ROUND((L25/L$34)*100,1)","v":94.1},null,null,null,{"$f":"L25+P25","v":1808652}]
[]
[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":1922172},null,{"$f":"SUM(N22:N25)","v":100},null,null,null,{"$f":"SUM(R22:R25)","v":1922172}]
[]
[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":1922172},null,{"$f":"ROUND((L34/L$34)*100,1)","v":100},null,null,null,{"$f":"R27+R32","v":1922172}]
[]
[]
[]
[]
[]
[]
[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: ___ ORIGINAL   ___UPDATED  _X_ 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":139462},null,{"$f":"IF(AD65=0,\"0.0 \",ROUND((AH65/AD65)*100,1))","v":8.4},null,null,null,{"$f":"AD65+AL65","v":1669190},null,{"$f":"IF(AN65=0,\"0.0 \",ROUND((AH65/AN65)*100,1))","v":8.4}]
[]
[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":139462},null,{"$f":"IF(AD67=0,\"0.0 \",ROUND((AH67/AD67)*100,1))","v":7.8},null,null,null,{"$f":"SUM(AN62:AN65)","v":1782710},null,{"$f":"IF(AN67=0,\"0.0 \",ROUND((AH67/AN67)*100,1))","v":7.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":139462},null,{"$f":"IF(AD74=0,\"0.0 \",ROUND((AH74/AD74)*100,1))","v":7.8},null,null,null,{"$f":"AN67+AN72","v":1782710},null,{"$f":"IF(AN74=0,\"0.0 \",ROUND((AH74/AN74)*100,1))","v":7.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: ___ ORIGINAL   ___UPDATED  _X_ 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.19},{"$f":"ROUND(E20*(PRO_RS_COM+PRO_RS_DSM)+PRO_RS_CUST+PRO_RS_HEA,2)","v":22.94},{"$f":"G20-F20","v":1.75},{"$f":"ROUND(H20/F20,3)*100","v":8.3000000000000007},null,{"$f":"ROUND(E20*EGC,2)","v":4.0599999999999996},{"$f":"F20+K20","v":25.25},{"$f":"G20+K20","v":27},{"$f":"ROUND((M20-L20)/L20,3)*100","v":6.9}]
[3,null,null,"Applicable",3,30.58,33.83,3.25,10.6,null,12.19,{"$f":"F21+K21","v":42.769999999999996},{"$f":"G21+K21","v":46.019999999999996},{"$f":"ROUND((M21-L21)/L21,3)*100","v":7.6}]
[4,null,null,null,6,44.65,50.16,5.509999999999998,12.3,null,24.37,69.02,74.53,8]
[5,null,null,null,8,54.04,61.05,7.009999999999998,13,null,32.5,86.539999999999992,93.55,8.1]
[6,null,null,null,10,63.42,71.94,8.519999999999996,13.4,null,40.619999999999997,104.03999999999999,112.56,8.2000000000000011]
[7,null,null,null,12,72.8,82.83,10.030000000000001,13.8,null,48.74,121.53999999999999,131.57,8.3000000000000007]
[8,null,null,null,16,91.57,104.6,13.030000000000001,14.2,null,64.989999999999995,156.56,169.58999999999997,8.3000000000000007]
[9,null,null,null,20,110.34,126.38,16.039999999999992,14.499999999999998,null,81.239999999999995,191.57999999999998,207.62,8.4]
[10,null,null,null,30,157.26,180.81,23.550000000000011,15,null,121.86,279.12,302.67,8.4]
[11,null,null,null,40,204.18,235.25,31.069999999999993,15.2,null,162.47999999999999,366.65999999999997,397.73,8.5]
[12,null,null,null,50,251.1,289.69,38.590000000000003,15.4,null,203.1,454.2,492.78999999999996,8.5]
[13,null,null,null,60,298.02,344.13,46.110000000000014,15.5,null,243.72,541.74,587.85,8.5]
[14,null,null,null,80,391.86,453,61.139999999999986,15.6,null,324.95999999999998,716.81999999999994,777.96,8.5]
[15,null,null,null,100,485.7,561.88,76.180000000000007,15.7,null,406.2,891.9,968.07999999999993,8.5]
[]
[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":75.84},{"$f":"G36-F36","v":11.219999999999999},{"$f":"ROUND(H36/F36,3)*100","v":17.399999999999999},null,{"$f":"ROUND(E36*EGC,2)","v":20.309999999999999},{"$f":"F36+K36","v":84.93},{"$f":"G36+K36","v":96.15},{"$f":"ROUND((M36-L36)/L36,3)*100","v":13.200000000000001}]
[18,null,null,null,10,79.239999999999995,93.68,14.440000000000012,18.2,null,40.619999999999997,119.85999999999999,134.30000000000001,12]
[19,null,null,null,20,108.49,129.35,20.86,19.2,null,81.239999999999995,189.73,210.58999999999997,11]
[20,null,null,null,40,166.97,200.7,33.72999999999999,20.200000000000003,null,162.47999999999999,329.45,363.17999999999995,10.199999999999999]
[21,null,null,null,50,196.22,236.38,40.159999999999997,20.5,null,203.1,399.32,439.48,10.100000000000001]
[22,null,null,null,100,342.43,414.76,72.329999999999984,21.099999999999998,null,406.2,748.63,820.96,9.7000000000000011]
[23,null,null,null,300,927.29,1128.28,200.99,21.7,null,1218.5999999999999,2145.89,2346.88,9.4]
[24,null,null,null,500,1512.15,1841.8,329.64999999999986,21.8,null,2031,3543.15,3872.8,9.3000000000000007]
[25,null,null,null,700,2097.0100000000002,2555.3200000000002,458.30999999999995,21.9,null,2843.4,4940.41,5398.72,9.3000000000000007]
[26,null,null,null,850,2535.66,3090.46,554.80000000000018,21.9,null,3452.7,5988.36,6543.16,9.3000000000000007]
[27,null,null,null,1000,2974.3,3625.6,651.29999999999973,21.9,null,4062,7036.3,7687.6,9.3000000000000007]
[28,null,null,null,2000,5898.6,7193.2,1294.5999999999995,21.9,null,8124,14022.6,15317.2,9.1999999999999993]
[29,null,null,null,3000,8822.9,10760.8,1937.8999999999996,22,null,12186,21008.9,22946.799999999999,9.1999999999999993]
[]
[]
[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: ___ ORIGINAL   ___UPDATED  _X_ 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":2467.6999999999998},{"$f":"+G75-F75","v":216.69999999999982},{"$f":"ROUND(H75/F75,3)*100","v":9.6},null,{"$f":"ROUND(E75*PRO_FTL_GCAT,2)","v":0},{"$f":"F75+K75","v":2251},{"$f":"G75+K75","v":2467.6999999999998},{"$f":"ROUND((M75-L75)/L75,3)*100","v":9.6}]
[3,null,"TRANSPORTATION",null,1500,3161.5,3486.55,{"$f":"+G76-F76","v":325.05000000000018},10.299999999999999,null,0,{"$f":"F76+K76","v":3161.5},{"$f":"G76+K76","v":3486.55},{"$f":"ROUND((M76-L76)/L76,3)*100","v":10.299999999999999}]
[4,null,null,null,2000,4072,4505.3999999999996,433.39999999999964,10.6,null,0,4072,4505.3999999999996,10.6]
[5,null,null,null,3000,5893,6543.1,650.10000000000036,11,null,0,5893,6543.1,11]
[6,null,null,null,5000,9535,10618.5,1083.5,11.4,null,0,9535,10618.5,11.4]
[7,null,null,null,10000,18640,20807,2167,11.600000000000001,null,0,18640,20807,11.600000000000001]
[8,null,null,null,20000,36850,41184,4334,11.799999999999999,null,0,36850,41184,11.799999999999999]
[9,null,null,null,30000,55060,61561,6501,11.799999999999999,null,0,55060,61561,11.799999999999999]
[10,null,null,null,40000,73270,81938,8668,11.799999999999999,null,0,73270,81938,11.799999999999999]
[11,null,null,null,50000,91480,102315,10835,11.799999999999999,null,0,91480,102315,11.799999999999999]
[12,null,null,null,75000,137005,153257.5,16252.5,11.899999999999999,null,0,137005,153257.5,11.899999999999999]
[13,null,null,null,100000,182530,204200,21670,11.899999999999999,null,0,182530,204200,11.899999999999999]
[14,null,null,null,150000,273580,306085,32505,11.899999999999999,null,0,273580,306085,11.899999999999999]
[15,null,null,null,200000,364630,407970,43340,11.899999999999999,null,0,364630,407970,11.899999999999999]
[]
[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":2593.1999999999998},{"$f":"+G91-F91","v":166.79999999999973},{"$f":"ROUND(H91/F91,3)*100","v":6.9},null,0,{"$f":"F91+K91","v":2426.4},{"$f":"G91+K91","v":2593.1999999999998},{"$f":"ROUND((M91-L91)/L91,3)*100","v":6.9}]
[18,null,"TRANSPORTATION",null,5000,5421,5838,{"$f":"+G92-F92","v":417},{"$f":"ROUND(H92/F92,3)*100","v":7.7},null,0,{"$f":"F92+K92","v":5421},{"$f":"G92+K92","v":5838},{"$f":"ROUND((M92-L92)/L92,3)*100","v":7.7}]
[19,null,null,null,10000,10412,11246,834,8,null,0,10412,11246,8]
[20,null,null,null,15000,15403,16654,1251,8.1,null,0,15403,16654,8.1]
[21,null,null,null,20000,20394,22062,1668,8.2000000000000011,null,0,20394,22062,8.2000000000000011]
[22,null,null,null,25000,25385,27470,2085,8.2000000000000011,null,0,25385,27470,8.2000000000000011]
[23,null,null,null,30000,30376,32878,2502,8.2000000000000011,null,0,30376,32878,8.2000000000000011]
[24,null,null,null,40000,40358,43694,3336,8.3000000000000007,null,0,40358,43694,8.3000000000000007]
[25,null,null,null,50000,50340,54510,4170,8.3000000000000007,null,0,50340,54510,8.3000000000000007]
[26,null,null,null,100000,100250,108590,8340,8.3000000000000007,null,0,100250,108590,8.3000000000000007]
[27,null,null,null,200000,200070,216750,16680,8.3000000000000007,null,0,200070,216750,8.3000000000000007]
[28,null,null,null,300000,299890,324910,25020,8.3000000000000007,null,0,299890,324910,8.3000000000000007]
[]
[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.000 /MCF"}]

{"sheet":"SCH N Rider PMM","index":13,"n_rows":104,"n_cols":21,"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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$","Units","Rider"]
["EFFECTS OF PROPOSED RIDER PMM (2023 Filing)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RS",0.67400000000000004,{"$f":"+Q3*$R$7","v":3109505.0660000001},{"$f":"+'Rate RS'!F24","v":1130041},{"$f":"ROUND(+R3/S3,2)","v":2.75},"/bill"]
["TYPICAL BILL COMPARISON",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GS",0.26040000000000002,{"$f":"+Q4*$R$7","v":1201357.7436000002},{"$f":"+'Rate GS COM'!F24+'Rate GS IND'!F24+'Rate GS OPA'!F24","v":84032},{"$f":"ROUND(+R4/S4,2)","v":14.3},"/bill"]
[{"$f":"SERV_TYPE","v":"(GAS SERVICE)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FT",4.9700000000000001E-2,{"$f":"+Q5*$R$7","v":229291.39730000001},{"$f":"+'Rate FT-LG'!Z62","v":2736182},{"$f":"ROUND(+R5/S5,5)","v":8.3799999999999999E-2},"/mcf"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IT",1.5900000000000001E-2,{"$f":"+Q6*$R$7","v":73354.79310000001},{"$f":"+'Rate IT'!H25","v":1672200},{"$f":"ROUND(+R6/S6,5)","v":4.3869999999999999E-2},"/mcf"]
[{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE N",null,null,null,null,4613509]
[{"$f":"FILING_TYPE","v":"TYPE OF FILING: ___ ORIGINAL   ___UPDATED  _X_ 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":"+'SCH N'!G20","v":22.94},{"$f":"+F20+$T$3","v":25.69},{"$f":"G20-F20","v":2.75},{"$f":"ROUND(H20/F20,3)*100","v":12},null,{"$f":"ROUND(E20*EGC,2)","v":4.0599999999999996},{"$f":"F20+K20","v":27},{"$f":"G20+K20","v":29.75},{"$f":"ROUND((M20-L20)/L20,3)*100","v":10.199999999999999}]
[3,null,null,"Applicable",3,{"$f":"+'SCH N'!G21","v":33.83},36.58,2.75,8.1,null,12.19,{"$f":"F21+K21","v":46.019999999999996},{"$f":"G21+K21","v":48.769999999999996},{"$f":"ROUND((M21-L21)/L21,3)*100","v":6}]
[4,null,null,null,6,{"$f":"+'SCH N'!G22","v":50.16},52.91,2.75,5.5,null,24.37,74.53,77.28,3.6999999999999997]
[5,null,null,null,8,{"$f":"+'SCH N'!G23","v":61.05},63.8,2.75,4.5,null,32.5,93.55,96.3,2.9000000000000004]
[6,null,null,null,10,{"$f":"+'SCH N'!G24","v":71.94},74.69,2.75,3.8,null,40.619999999999997,112.56,115.31,2.4]
[7,null,null,null,12,{"$f":"+'SCH N'!G25","v":82.83},85.58,2.75,3.3000000000000003,null,48.74,131.57,134.32,2.1]
[8,null,null,null,16,{"$f":"+'SCH N'!G26","v":104.6},107.35,2.75,2.6,null,64.989999999999995,169.58999999999997,172.33999999999997,1.6]
[9,null,null,null,20,{"$f":"+'SCH N'!G27","v":126.38},129.13,2.75,2.1999999999999997,null,81.239999999999995,207.62,210.37,1.3]
[10,null,null,null,30,{"$f":"+'SCH N'!G28","v":180.81},183.56,2.75,1.5,null,121.86,302.67,305.42,0.89999999999999991]
[11,null,null,null,40,{"$f":"+'SCH N'!G29","v":235.25},238,2.75,1.2,null,162.47999999999999,397.73,400.48,0.70000000000000007]
[12,null,null,null,50,{"$f":"+'SCH N'!G30","v":289.69},292.44,2.75,0.89999999999999991,null,203.1,492.78999999999996,495.53999999999996,0.6]
[13,null,null,null,60,{"$f":"+'SCH N'!G31","v":344.13},346.88,2.75,0.8,null,243.72,587.85,590.6,0.5]
[14,null,null,null,80,{"$f":"+'SCH N'!G32","v":453},455.75,2.75,0.6,null,324.95999999999998,777.96,780.71,0.4]
[15,null,null,null,100,{"$f":"+'SCH N'!G33","v":561.88},564.63,2.75,0.5,null,406.2,968.07999999999993,970.82999999999993,0.3]
[]
[16,null,"(GS)"]
[17,null,"NON-RESIDENTIAL",null,5,{"$f":"+'SCH N'!G36","v":75.84},{"$f":"+F36+$T$4","v":90.14},{"$f":"G36-F36","v":14.299999999999997},{"$f":"ROUND(H36/F36,3)*100","v":18.899999999999999},null,{"$f":"ROUND(E36*EGC,2)","v":20.309999999999999},{"$f":"F36+K36","v":96.15},{"$f":"G36+K36","v":110.45},{"$f":"ROUND((M36-L36)/L36,3)*100","v":14.899999999999999}]
[18,null,null,null,10,{"$f":"+'SCH N'!G37","v":93.68},107.98,14.299999999999997,15.299999999999999,null,40.619999999999997,134.30000000000001,148.6,10.6]
[19,null,null,null,20,{"$f":"+'SCH N'!G38","v":129.35},143.65,14.300000000000011,11.1,null,81.239999999999995,210.58999999999997,224.89,6.8000000000000007]
[20,null,null,null,40,{"$f":"+'SCH N'!G39","v":200.7},215,14.300000000000011,7.1,null,162.47999999999999,363.17999999999995,377.48,3.9]
[21,null,null,null,50,{"$f":"+'SCH N'!G40","v":236.38},250.68,14.300000000000011,6,null,203.1,439.48,453.78,3.3000000000000003]
[22,null,null,null,100,{"$f":"+'SCH N'!G41","v":414.76},429.06,14.300000000000011,3.4000000000000004,null,406.2,820.96,835.26,1.7000000000000002]
[23,null,null,null,300,{"$f":"+'SCH N'!G42","v":1128.28},1142.58,14.299999999999955,1.3,null,1218.5999999999999,2346.88,2361.1799999999998,0.6]
[24,null,null,null,500,{"$f":"+'SCH N'!G43","v":1841.8},1856.1,14.299999999999955,0.8,null,2031,3872.8,3887.1,0.4]
[25,null,null,null,700,{"$f":"+'SCH N'!G44","v":2555.3200000000002},2569.6200000000003,14.300000000000182,0.6,null,2843.4,5398.72,5413.02,0.3]
[26,null,null,null,850,{"$f":"+'SCH N'!G45","v":3090.46},3104.76,14.300000000000182,0.5,null,3452.7,6543.16,6557.46,0.2]
[27,null,null,null,1000,{"$f":"+'SCH N'!G46","v":3625.6},3639.9,14.300000000000182,0.4,null,4062,7687.6,7701.9,0.2]
[28,null,null,null,2000,{"$f":"+'SCH N'!G47","v":7193.2},7207.5,14.300000000000182,0.2,null,8124,15317.2,15331.5,0.1]
[29,null,null,null,3000,{"$f":"+'SCH N'!G48","v":10760.8},10775.099999999999,14.299999999999272,0.1,null,12186,22946.799999999999,22961.1,0.1]
[]
[]
[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"}]
[{"$f":"+A3","v":"EFFECTS OF PROPOSED RIDER PMM (2023 Filing)"}]
["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,null,"SCHEDULE N"]
[{"$f":"FILING_TYPE","v":"TYPE OF FILING: ___ ORIGINAL   ___UPDATED  _X_ 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":"+'SCH N'!G75","v":2467.6999999999998},{"$f":"+F75+(E75*$T$5)","v":2551.5},{"$f":"+G75-F75","v":83.800000000000182},{"$f":"ROUND(H75/F75,3)*100","v":3.4000000000000004},null,{"$f":"ROUND(E75*PRO_FTL_GCAT,2)","v":0},{"$f":"F75+K75","v":2467.6999999999998},{"$f":"G75+K75","v":2551.5},{"$f":"ROUND((M75-L75)/L75,3)*100","v":3.4000000000000004}]
[3,null,"TRANSPORTATION",null,1500,{"$f":"+'SCH N'!G76","v":3486.55},3612.25,{"$f":"+G76-F76","v":125.69999999999982},3.5999999999999996,null,0,3486.55,3612.25,3.5999999999999996]
[4,null,null,null,2000,{"$f":"+'SCH N'!G77","v":4505.3999999999996},4673,167.60000000000036,3.6999999999999997,null,0,4505.3999999999996,4673,3.6999999999999997]
[5,null,null,null,3000,{"$f":"+'SCH N'!G78","v":6543.1},6794.5,251.39999999999964,3.8,null,0,6543.1,6794.5,3.8]
[6,null,null,null,5000,{"$f":"+'SCH N'!G79","v":10618.5},11037.5,419,3.9,null,0,10618.5,11037.5,3.9]
[7,null,null,null,10000,{"$f":"+'SCH N'!G80","v":20807},21645,838,4,null,0,20807,21645,4]
[8,null,null,null,20000,{"$f":"+'SCH N'!G81","v":41184},42860,1676,4.1000000000000005,null,0,41184,42860,4.1000000000000005]
[9,null,null,null,30000,{"$f":"+'SCH N'!G82","v":61561},64075,2514,4.1000000000000005,null,0,61561,64075,4.1000000000000005]
[10,null,null,null,40000,{"$f":"+'SCH N'!G83","v":81938},85290,3352,4.1000000000000005,null,0,81938,85290,4.1000000000000005]
[11,null,null,null,50000,{"$f":"+'SCH N'!G84","v":102315},106505,4190,4.1000000000000005,null,0,102315,106505,4.1000000000000005]
[12,null,null,null,75000,{"$f":"+'SCH N'!G85","v":153257.5},159542.5,6285,4.1000000000000005,null,0,153257.5,159542.5,4.1000000000000005]
[13,null,null,null,100000,{"$f":"+'SCH N'!G86","v":204200},212580,8380,4.1000000000000005,null,0,204200,212580,4.1000000000000005]
[14,null,null,null,150000,{"$f":"+'SCH N'!G87","v":306085},318655,12570,4.1000000000000005,null,0,306085,318655,4.1000000000000005]
[15,null,null,null,200000,{"$f":"+'SCH N'!G88","v":407970},424730,16760,4.1000000000000005,null,0,407970,424730,4.1000000000000005]
[]
[16,null,"(IT)","Not"]
[17,null,"INTERRUPTIBLE","Applicable",2000,{"$f":"+'SCH N'!G91","v":2593.1999999999998},{"$f":"+F91+(E91*$T$6)","v":2680.9399999999996},{"$f":"+G91-F91","v":87.739999999999782},{"$f":"ROUND(H91/F91,3)*100","v":3.4000000000000004},null,0,{"$f":"F91+K91","v":2593.1999999999998},{"$f":"G91+K91","v":2680.9399999999996},{"$f":"ROUND((M91-L91)/L91,3)*100","v":3.4000000000000004}]
[18,null,"TRANSPORTATION",null,5000,{"$f":"+'SCH N'!G92","v":5838},6057.35,219.35000000000036,3.8,null,0,5838,6057.35,3.8]
[19,null,null,null,10000,{"$f":"+'SCH N'!G93","v":11246},11684.7,438.70000000000073,3.9,null,0,11246,11684.7,3.9]
[20,null,null,null,15000,{"$f":"+'SCH N'!G94","v":16654},17312.05,658.04999999999927,4,null,0,16654,17312.05,4]
[21,null,null,null,20000,{"$f":"+'SCH N'!G95","v":22062},22939.4,877.40000000000146,4,null,0,22062,22939.4,4]
[22,null,null,null,25000,{"$f":"+'SCH N'!G96","v":27470},28566.75,1096.75,4,null,0,27470,28566.75,4]
[23,null,null,null,30000,{"$f":"+'SCH N'!G97","v":32878},34194.1,1316.0999999999985,4,null,0,32878,34194.1,4]
[24,null,null,null,40000,{"$f":"+'SCH N'!G98","v":43694},45448.800000000003,1754.8000000000029,4,null,0,43694,45448.800000000003,4]
[25,null,null,null,50000,{"$f":"+'SCH N'!G99","v":54510},56703.5,2193.5,4,null,0,54510,56703.5,4]
[26,null,null,null,100000,{"$f":"+'SCH N'!G100","v":108590},112977,4387,4,null,0,108590,112977,4]
[27,null,null,null,200000,{"$f":"+'SCH N'!G101","v":216750},225524,8774,4,null,0,216750,225524,4]
[28,null,null,null,300000,{"$f":"+'SCH N'!G102","v":324910},338071,13161,4.1000000000000005,null,0,324910,338071,4.1000000000000005]
[]
[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.000 /MCF"}]

{"sheet":"Revenue Requirements","index":14,"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"},35525915,81385905,{"$f":"(I10-D10)/D10","v":7.9632666051222531E-2},{"$f":"I10-D10","v":6002946},null,{"$f":"G10","v":"RS"},{"$f":"'Proposed Rates'!C21","v":-265}]
[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"},5082039,31437936,{"$f":"(I11-D11)/D11","v":0.10316466929520625},{"$f":"I11-D11","v":2939982},null,{"$f":"G11","v":"GS"},{"$f":"'Rate GS COM'!R29+'Rate GS IND'!R29+'Rate GS OPA'!R29-'Revenue Requirements'!I11","v":-30514}]
[]
[]
[null,"FT-Large",{"$f":"'Rate FT-LG'!F22","v":1092},{"$f":"'Rate FT-LG'!AN73","v":5697047},null,null,"FT-Large",353802,5998190,5.285949018851345E-2,301143,null,"FT-Large",{"$f":"'Proposed Rates'!K23","v":82.665600000036648}]
[null,"IT",{"$f":"'Rate IT'!F22","v":264},{"$f":"'Rate IT'!AN74","v":1782710},null,null,"IT",155286,1922104,7.8192190541366793E-2,139394,null,"IT",{"$f":"'Proposed Rates'!O21","v":68}]
[null,null,null,null,null,null,"Additional FT for Min use",null,{"$f":"-'Proposed Rates'!K33","v":46805.334399999963}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(N10:N15)","v":-30628.334399999963}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"OTHER",null,{"$f":"'SCH M-2.2'!V46","v":337989},null,null,"OTHER",null,{"$f":"+'SCH M-2.3'!R46","v":298721.03264298144},{"$f":"(I28-D28)/D28","v":-0.11618119926097759}]
[null,"TOTAL",{"$f":"SUM(C10:C28)","v":1215429},{"$f":"SUM(D10:D28)","v":111698659},null,null,"TOTAL",{"$f":"SUM(H10:H28)","v":41117042},{"$f":"SUM(I10:I28)","v":121089661.36704297},{"$f":"(I29-D29)/D29","v":8.4074441458092827E-2},{"$f":"I29-D29","v":9391002.3670429736}]

{"sheet":"Proposed Rates","index":15,"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":35525915},null,null,"COSS - GS Customer Component",{"$f":"'Revenue Requirements'!H11+'Revenue Requirements'!H12+'Revenue Requirements'!H13","v":5082039},null,null,"COSS - FT-L Customer Component",{"$f":"'Revenue Requirements'!H14","v":353802},null,null,"COSS - IT Customer Component",{"$f":"'Revenue Requirements'!H15","v":155286}]
[null,"COSS Customer Charge",{"$f":"ROUND(C8/C7,2)","v":31.44},null,null,"COSS Customer Charge",{"$f":"ROUND(G8/G7,2)","v":60.48},null,null,"COSS Customer Charge",{"$f":"ROUND(K8/K7,2)","v":323.99},null,null,"COSS Customer Charge",{"$f":"ROUND(O8/O7,2)","v":588.20000000000005}]
[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":14.940000000000001},null,null,"Gap",{"$f":"G9-G10","v":10.479999999999997},null,null,"Gap",{"$f":"K9-K10","v":-106.00999999999999},null,null,"Gap",{"$f":"O9-O10","v":158.20000000000005}]
[null,"Migration @ % of Justified",{"$f":"ROUND(C11*$C$29,2)","v":5.98},null,null,"Migration @ % of Justified",{"$f":"ROUND(G11*$C$29,2)","v":4.1900000000000004},null,null,"Migration @ % of Justified",{"$f":"ROUND(K11*$C$29,2)","v":-42.4},null,null,"Migration @ % of Justified",{"$f":"ROUND(O11*$C$29,2)","v":63.28}]
[null,"Customer Charge at % Migration to COSS",{"$f":"C10+C12","v":22.48},null,null,"Customer Charge at % Migration to COSS",{"$f":"G10+G12","v":54.19},null,null,"Customer Charge at % Migration to COSS",{"$f":"K10+K12","v":387.6},null,null,"Customer Charge at % Migration to COSS",{"$f":"O10+O12","v":493.28}]
[null,"Proposed Customer Charge",17.5,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":19775718},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":81385905},null,null,"COSS - GS Revenue Requirement",{"$f":"SUM('Revenue Requirements'!I11:I13)","v":31437936},null,null,"COSS - FT-L Revenue Requirement",{"$f":"'Revenue Requirements'!I14","v":5998190},null,null,"COSS - IT Revenue Requirement",{"$f":"'Revenue Requirements'!I15","v":1922104}]
[null,"Less Proposed Customer Charge Revenues Less GCA",{"$f":"C17-C15-'Rate RS'!P29","v":35283155},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":12437606},null,null,"Less Proposed Customer Charge Revenues Less GCA/GCAT",{"$f":"K17-K15-'Rate FT-LG'!P25","v":5528630},null,null,"Less Proposed Customer Charge Revenues Less GCA",{"$f":"O17-O15-'Rate IT'!P25","v":1808584}]
[null,"Test Period MCF",{"$f":"'Rate RS'!H27","v":6481298},null,null,"Less Interdeptartmental",{"$f":"+G30","v":30629.367042981401},null,null,"Change in Min Amazon",{"$f":"+K33","v":-46805.334399999963},null,null,"Test Period MCF",{"$f":"'Rate IT'!H25","v":1672200}]
[null,"Proposed Delivery Charge",{"$f":"ROUND(C18/C19,4)","v":5.4438000000000004},null,null,"GS Rev Requirement",{"$f":"+G18-G19","v":12406976.632957019},null,null,"FT-L Rev Requirement",{"$f":"+K18-K19","v":5575435.3344000001},null,null,"Proposed Energy Charge",{"$f":"ROUND(O18/O19,4)","v":1.0815999999999999}]
[null,"Check to Revenue Requirements",{"$f":"'Rate RS'!R29-C17","v":-265},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":68}]
[null,null,null,null,null,"Proposed Energy Charge",{"$f":"ROUND(G20/G21,4)","v":3.5676000000000001},null,null,"Proposed Energy Charge",{"$f":"ROUND(K20/K21,4)","v":2.0377000000000001}]
[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":115.36704298140103},null,null,"Check to Revenue Requirements",{"$f":"'Rate FT-LG'!R27-K17+K33","v":82.665600000036648}]
[]
[]
[]
[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.10316466929520625},null,"Annual Usage Required",null,{"$f":"+(K27-(12*K14))/K35","v":319354.63290145271}]
[null,"Migration Percentage",0.4,null,null,"Interdept Increase",{"$f":"+G27*G28","v":2864.3670429814015},null,"Estimated Annual Usage",null,215594]
[null,null,null,null,null,"Proposed Intdept Rev",{"$f":"+G27+G29","v":30629.367042981401},null,"Projected Shortfall",null,{"$f":"+K28-K29","v":103760.63290145271}]
[null,null,null,null,null,null,null,null,"New Minumum Usage Revenue",null,{"$f":"+K30*K35","v":211422.66560000004}]
[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":-46805.334399999963}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND((K18-K27+12*K14+K32)/(K21-K29),4)-0.0001","v":2.0375999999999999}]
[]
[]
[null,null,{"$f":"+'SCH M'!G50","v":121059033.03264298}]
[null,null,126681928]
[null,null,{"$f":"+C38-C39","v":-5622894.9673570246}]

{"sheet":"Avg Incr","index":16,"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":43.24},{"$f":"ROUND(C9*(PRO_RS_COM+PRO_RS_DSM)+PRO_RS_CUST+PRO_RS_HEA,2)","v":48.53},{"$f":"E9-D9","v":5.2899999999999991},{"$f":"ROUND(F9/D9,3)*100","v":12.2},{"$f":"ROUND(C9*EGC,2)","v":23.15},{"$f":"D9+H9","v":66.39},{"$f":"E9+H9","v":71.680000000000007},{"$f":"ROUND((J9-I9)/I9,3)","v":0.08}]
["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":187.5},{"$f":"E10-D10","v":31.349999999999994},{"$f":"ROUND(F10/D10,3)*100","v":20.100000000000001},{"$f":"ROUND(C10*EGC,2)","v":147.44999999999999},{"$f":"D10+H10","v":303.60000000000002},{"$f":"E10+H10","v":334.95},{"$f":"ROUND((J10-I10)/I10,3)","v":0.10299999999999999}]
["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":468.63},{"$f":"E11-D11","v":82.04000000000002},{"$f":"ROUND(F11/D11,3)*100","v":21.2},{"$f":"ROUND(C11*EGC,2)","v":467.54},{"$f":"D11+H11","v":854.13},{"$f":"E11+H11","v":936.17000000000007},9.6000000000000002E-2]
["GS-OPA",1138,{"$f":"ROUND('Rate GS OPA'!H27/'Rate GS OPA'!F24,1)","v":113.8},382.79,463.99,81.199999999999989,21.2,{"$f":"ROUND(C12*EGC,2)","v":462.26},{"$f":"D12+H12","v":845.05},{"$f":"E12+H12","v":926.25},9.6000000000000002E-2]
["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":4992.88},{"$f":"ROUND(C13*(PRO_FTL_COM+PRO_FTL_GCAT),2)+PRO_FTL_CUST","v":5535.86},{"$f":"E13-D13","v":542.97999999999956},{"$f":"ROUND(F13/D13,3)*100","v":10.9},0,{"$f":"D13+H13","v":4992.88},{"$f":"E13+H13","v":5535.86},0.109]
["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":7280.96},{"$f":"E14-D14","v":528.26000000000022},{"$f":"ROUND(F14/D14,3)*100","v":7.8},0,6752.7,7280.96,7.8E-2]
[]
["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"]