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

{"sheet":"INPUT","index":0,"n_rows":64,"n_cols":12,"rows_kept":64,"cut":false,"hidden":false,"merged":[[0,0,0,10]]}
["TEST PERIOD WITH RIDERS"]
["Updated MAY 2018"]
["Input Areas in Grey"]
[null,"12 MONTHS FORECASTED",null,"INCLUDES ALL RIDERS"]
[]
[null,"DUKE ENERGY KENTUCKY"]
[null,"CASE NO. 2018- 00261"]
[null,"AUTOMATED RATE CASE FILING SYSTEM"]
[null,"FOR THE TWELVE MONTHS ENDED MARCH 31, 2020"]
[]
[null,"TYPE OF SERVICE:","(GAS SERVICE)"]
[null,"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"]
[null,"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"]
[]
[null,"CURRENT RATES:",null,null,null,"@DEC2017","@JAN2018","@FEB2018","@MAR2018","@APR2018","@MAY2018","@JUN2018"]
[null,"GAS COST ADJUSTMENT(2):",{"$f":"L16","v":3.9990000000000001},"$ PER MCF",null,4.2430000000000003,4.032,4.0209999999999999,3.9769999999999999,3.9060000000000001,3.8420000000000001,3.9990000000000001]
[null,"EXPECTED GAS COST(1):",{"$f":"L17","v":4.0143000000000004},"$ PER MCF","AVG ANNUALIZED",null,null,null,null,null,null,4.0143000000000004]
[null,"WITNESS:","B. L. Sailers"]
[]
[null,"(1) Based upon Normalized Volumes for Test Period"]
[null,"(2)  GCA @ June 2018:"]
[null,"     EGC",3.7589999999999999,"@JUNE 2018","UPDATED MONTHLY"]
[null,"     RA",-1.7000000000000001E-2,"@JUNE 2018"]
[null,"     AA",0.23200000000000001,"@JUNE 2018"]
[null,"     BA",2.5000000000000001E-2,"@JUNE 2018"]
[null,"Total GCA",{"$f":"SUM(C22:C25)","v":3.9990000000000001},null,"UPDATED MONTHLY"]
[]
[null,"Rider DSMR:","Current","Proposed"]
[null,"     Rate RS  (HEA)",0.1,0.1,"MONTHLY CHARGE Thru December 2020"]
[null,"     Rate RS",-0.39792,{"$f":"C30","v":-0.39792},"$ per MCF","RATE EFFECTIVE February 14, 2018"]
[null,"     Rate GS",0,{"$f":"C31","v":0},"$ per MCF"]
[]
[]
[]
[null,"Rider GCAT:","Current","Proposed"]
[null,"     Rate FT-L",0,0,"$ per MCF","JUN 2018 - AUG 2018 updated quarterly"]
[]
[null,"Interdepartmental Rates","Current","Proposed"]
[null,"Customer Charge ",null,null,"$ per MCF","Not used"]
[]
[]
[null,"Rider ASRP:","Current","Proposed"]
[null,"     Rate RS",1.8,0,"$ per Month","Beginning January 2018, updated annually"]
[null,"     Rate GS",1.78,0,"$ per Month"]
[null,"     Rate DGS",4.4999999999999997E-3,0,"$ per MCF"]
[null,"     Rate FT-L",4.4999999999999997E-3,0,"$ per MCF"]
[null,"     Rate IT",3.8999999999999998E-3,0,"$ per MCF"]
[null,"     Rate SSIT",3.8999999999999998E-3,0,"$ per MCF"]
[]
[null,"Rate RS:","Current","Proposed"]
[null,"     Customer Charge",16,{"$f":"'Proposed Rates'!C14","v":17.5},"$ per Month"]
[null,"     Delivery Rate",3.7212999999999998,{"$f":"'Proposed Rates'!C20","v":4.8677000000000001},"$ per MCF"]
[]
[null,"Rate GS:","Current","Proposed"]
[null,"     Customer Charge",47.5,{"$f":"'Proposed Rates'!G14","v":50},"$ per Month"]
[null,"     Delivery Rate",2.0529999999999999,{"$f":"'Proposed Rates'!G20","v":2.8077000000000001},"$ per MCF"]
[]
[null,"Rate FT-L:","Current","Proposed"]
[null,"     Administrative Charge",430,{"$f":"'Proposed Rates'!K14","v":430},"$ per Month"]
[null,"     Delivery Rate",1.7369000000000001,{"$f":"'Proposed Rates'!K20","v":2.3319000000000001},"$ per MCF"]
[]
[null,"Rate IT:","Current","Proposed"]
[null,"     Administrative Charge",430,{"$f":"'Proposed Rates'!O14","v":430},"$ per Month"]
[null,"     Commodity Charge",0.94930000000000003,{"$f":"'Proposed Rates'!O20","v":1.0368999999999999},"$ 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. 2018- 00261"}]
["REVENUES AT PRESENT AND PROPOSED RATES"]
[{"$f":"TIME_PERIOD","v":"FOR THE TWELVE MONTHS ENDED MARCH 31, 2020"}]
[{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[]
[{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,"SCHEDULE M"]
[{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,"PAGE  1  OF  1"]
["WORK PAPER REFERENCE NO(S).:",null,null,null,null,null,null,null,null,null,"WITNESS:"]
[{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"B. L. Sailers"}]
[{"$f":"INPUT!D4","v":"INCLUDES ALL RIDERS"}]
[]
[]
[null,null,null,null,"REVENUE AT",null,"REVENUE AT",null,"REVENUE",null,"% OF"]
["LINE",null,"RATE",null,"PRESENT",null,"PROPOSED",null,"CHANGE",null,"REVENUE"]
[" NO.",null,"CLASSIFICATION",null,"RATES",null,"RATES",null,"(AMOUNT)",null,"CHANGE"]
[null,null,"(A)",null,"(B)",null,"(C)",null,"(D=C-B)",null,"(E=D / B)"]
[null,null,null,null,"($)",null,"($)",null,"($)"]
[1,null,"SALES SERVICE:"]
[]
[2,null,"RS RESIDENTIAL ",null,{"$f":"'Rate RS'!AN83","v":63279833},null,{"$f":"'Rate RS'!R40","v":69728261},null,{"$f":"G21-E21","v":6448428},null,{"$f":"IF(E21=0,\"0.00%\",ROUND(I21/E21,4))","v":0.1019}]
[3,null,"TOTAL RS",null,{"$f":"E21","v":63279833},null,{"$f":"G21","v":69728261},null,{"$f":"I21","v":6448428},null,{"$f":"IF(E22=0,\"0.00%\",ROUND(I22/E22,4))","v":0.1019}]
[]
[4,null,"GS COMMERCIAL",null,{"$f":"'Rate GS COM'!AN81","v":19817285},null,{"$f":"'Rate GS COM'!R39","v":21858999},null,{"$f":"G24-E24","v":2041714},null,{"$f":"IF(E24=0,\"0.00%\",ROUND(I24/E24,4))","v":0.10299999999999999}]
[5,null,"GS INDUSTRIAL",null,{"$f":"'Rate GS IND'!AN86","v":1165718},null,{"$f":"'Rate GS IND'!R39","v":1297124},null,{"$f":"G25-E25","v":131406},null,{"$f":"IF(E25=0,\"0.00%\",ROUND(I25/E25,4))","v":0.11269999999999999}]
[6,null,"GS OTHER PUB AUTH",null,{"$f":"'Rate GS OPA'!AN83","v":2215244},null,{"$f":"'Rate GS OPA'!R39","v":2466546},null,{"$f":"G26-E26","v":251302},null,{"$f":"IF(E26=0,\"0.00%\",ROUND(I26/E26,4))","v":0.1134}]
[7,null,"TOTAL GS",null,{"$f":"SUM(E24:E26)","v":23198247},null,{"$f":"SUM(G24:G26)","v":25622669},null,{"$f":"SUM(I24:I26)","v":2424422},null,{"$f":"IF(E27=0,\"0.00%\",ROUND(I27/E27,4))","v":0.1045}]
[]
[8,null,"     TOTAL SALES SERVICE",null,{"$f":"E22+E27","v":86478080},null,{"$f":"G22+G27","v":95350930},null,{"$f":"I22+I27","v":8872850},null,{"$f":"IF(E29=0,\"0.00%\",ROUND(I29/E29,4))","v":0.1026}]
[]
[9,null,"TRANSPORTATION:"]
[]
[10,null,"FT LARGE",null,{"$f":"'Rate FT-LG'!AN75","v":5042683},null,{"$f":"'Rate FT-LG'!R36","v":6588156},null,{"$f":"G33-E33","v":1545473},null,{"$f":"IF(E33=0,\"0.00%\",ROUND(I33/E33,4))","v":0.30649999999999999}]
[11,null,"IT",null,{"$f":"'Rate IT'!AN76","v":1524248},null,{"$f":"'Rate IT'!R35","v":1648124},null,{"$f":"G34-E34","v":123876},null,{"$f":"IF(E34=0,\"0.00%\",ROUND(I34/E34,4))","v":8.1299999999999997E-2}]
[12,null,"     TOTAL TRANSPORTATION",null,{"$f":"SUM(E33:E34)","v":6566931},null,{"$f":"SUM(G33:G34)","v":8236280},null,{"$f":"SUM(I33:I34)","v":1669349},null,{"$f":"IF(E35=0,\"0.00%\",ROUND(I35/E35,4))","v":0.25419999999999998}]
[13,null,"TOTAL THROUGHPUT",null,{"$f":"E35+E29","v":93045011},null,{"$f":"G35+G29","v":103587210},null,{"$f":"I35+I29","v":10542199},null,{"$f":"IF(E36=0,\"0.00%\",ROUND(I36/E36,4))","v":0.1133}]
[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":28032},null,{"$f":"'SCH M-2.3'!R38","v":28032},null,0,null,"0.00%"]
[17,null,"RECONNECTION CHARGES",null,{"$f":"'SCH M-2.2'!V39","v":22068},null,{"$f":"'SCH M-2.3'!R39","v":22068},null,0,null,"0.00%"]
[18,null,"RENTS",null,{"$f":"'SCH M-2.2'!V40","v":14496},null,{"$f":"'SCH M-2.3'!R40","v":14496},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":27765},null,0,null,"0.00%"]
[20,null,"SPECIAL CONTRACTS",null,{"$f":"'SCH M-2.2'!V42","v":0},null,{"$f":"'SCH M-2.3'!R42","v":0},null,0,null,"0.00%"]
[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":1896},null,{"$f":"'SCH M-2.3'!R45","v":1896},null,0,null,"0.00%"]
[24,null,"   TOTAL MISCELLANEOUS",null,{"$f":"SUM(E39:E47)","v":94257},null,{"$f":"SUM(G39:G47)","v":94257},null,{"$f":"SUM(I39:I47)","v":0},null,"0.00%"]
[]
[25,null,"TOTAL COMPANY REVENUE",null,{"$f":"E29++E35+E48","v":93139268},null,{"$f":"G29++G35+G48","v":103681467},null,{"$f":"I29++I35+I48","v":10542199},null,{"$f":"IF(I50=0,\"0.00%\",ROUND(I50/E50,4))","v":0.1132}]

{"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. 2018- 00261"}]
["TEST PERIOD REVENUES AT CURRENT AVERAGE RATES"]
[{"$f":"TIME_PERIOD","v":"FOR THE TWELVE MONTHS ENDED MARCH 31, 2020"}]
[{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE M-2.1"]
[{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PAGE  1  OF  1"]
["WORK PAPER REFERENCE NO(S).:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,{"$f":"INPUT!D4","v":"INCLUDES ALL RIDERS"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"B. L. Sailers"}]
["TEST PERIOD"]
[]
[null,null,null,null,null,null,null,null,null,"TEST PERIOD",null,null,null,"% OF REV"]
[null,null,null,null,null,null,null,null,null,"REVENUE LESS",null,"CURRENT",null,"TO TOTAL",null,null,null,"TEST PERIOD"]
["LINE",null,"RATE","CLASS /",null,"CUSTOMER",null,null,null,"GAS COST",null,"AVERAGE",null,"EXCLUSIVE OF ",null,"GAS COST",null,"REVENUE",null,"% OF REV"]
[" NO.",null,"CODE","DESCRIPTION",null,"BILLS",null,"SALES",null,"REVENUE",null,"RATE",null,"GAS COST",null,"REVENUE",null,"TOTAL",null,"TO TOTAL"]
[null,null,"(A)","(B)",null,"(C)",null,"(D)",null,"(E)",null,"(F=E/D)",null,"(G)",null,"(H)",null,"(I)",null,"(J)"]
[]
[null,null,null,null,null,null,null,"(MCF)",null,"($)",null,"($/MCF)",null,"(%)",null,"($)",null,"($)",null,"(%)"]
[1,null,"RS","RESIDENTIAL SERVICE",null,{"$f":"'Rate RS'!X83","v":1110274},null,{"$f":"'Rate RS'!Z83","v":5915484},null,{"$f":"'Rate RS'!AD83","v":39533306},null,{"$f":"IF(H19=0,\"-\",ROUND(J19/H19,4))","v":6.6829999999999998},null,{"$f":"IF(ABS(J19/$J$34*100)<0.005,\"-\",ROUND(J19/$J$34*100,2))-0.01","v":69.58},null,{"$f":"'Rate RS'!AL83","v":23746527},null,{"$f":"J19+P19","v":63279833},null,{"$f":"IF(ABS(R19/$R$34*100)<0.005,\"-\",ROUND(R19/$R$34*100,2))","v":67.94}]
[2,null,"GS","GENERAL SERVICE COMMERCIAL",null,{"$f":"'Rate GS COM'!X81","v":78250},null,{"$f":"'Rate GS COM'!Z81","v":2630680},null,{"$f":"'Rate GS COM'!AD81","v":9256946},null,{"$f":"IF(H20=0,\"-\",ROUND(J20/H20,4))","v":3.5188000000000001},null,{"$f":"IF(ABS(J20/$J$34*100)<0.005,\"-\",ROUND(J20/$J$34*100,2))","v":16.3},null,{"$f":"'Rate GS COM'!AL81","v":10560339},null,{"$f":"J20+P20","v":19817285},null,21.28]
[3,null,"GS","GENERAL SERVICE INDUSTRIAL",null,{"$f":"'Rate GS IND'!X86","v":2513},null,{"$f":"'Rate GS IND'!Z86","v":171720},null,{"$f":"'Rate GS IND'!AD86","v":476382},null,2.7742,null,0.84,null,{"$f":"'Rate GS IND'!AL86","v":689336},null,1165718,null,1.25]
[4,null,"GS","GENERAL SERVICE OTHER PUB AUTH",null,{"$f":"'Rate GS OPA'!X83","v":4482},null,{"$f":"'Rate GS OPA'!Z83","v":328708},null,{"$f":"'Rate GS OPA'!AD83","v":895711},null,2.7248999999999999,null,1.58,null,{"$f":"'Rate GS OPA'!AL83","v":1319533},null,2215244,null,2.38]
[5,null,"FT-L","FIRM TRANSPORTATION-LARGE",null,{"$f":"'Rate FT-LG'!X75","v":1128},null,{"$f":"'Rate FT-LG'!Z75","v":2617229},null,{"$f":"'Rate FT-LG'!AD75","v":5042683},null,1.9267000000000001,null,8.8800000000000008,null,{"$f":"'Rate FT-LG'!AL75","v":0},null,5042683,null,5.41]
[6,null,"IT","INTERRUPTIBLE TRANSPORTATION",null,{"$f":"'Rate IT'!X76","v":264},null,{"$f":"'Rate IT'!Z76","v":1479992},null,{"$f":"'Rate IT'!AD76","v":1524248},null,{"$f":"IF(H24=0,\"-\",ROUND(J24/H24,4))","v":1.0299},null,2.68,null,{"$f":"'Rate IT'!AL76","v":0},null,{"$f":"J24+P24","v":1524248},null,1.64]
[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":28032},null,"-",null,0.05,null,{"$f":"'SCH M-2.2'!T38","v":0},null,28032,null,0.03]
[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":22068},null,"-",null,0.04,null,{"$f":"'SCH M-2.2'!T39","v":0},null,22068,null,0.02]
[10,null,null,"RENTS ",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":14496},null,"-",null,0.03,null,{"$f":"'SCH M-2.2'!T40","v":0},null,14496,null,0.02]
[11,null,null,"INTERDEPARTMENTAL",null,{"$f":"'SCH M-2.2'!F41","v":0},null,{"$f":"'SCH M-2.2'!H41","v":4542},null,{"$f":"'SCH M-2.2'!L41","v":9326},null,2.0533000000000001,null,0.02,null,{"$f":"'SCH M-2.2'!T41","v":18439},null,27765,null,0.03]
[12,null,null,"SPECIAL CONTRACTS",null,{"$f":"'SCH M-2.2'!F42","v":0},null,{"$f":"'SCH M-2.2'!H42","v":0},null,{"$f":"'SCH M-2.2'!L42","v":0},null,"-",null,"-",null,{"$f":"'SCH M-2.2'!T42","v":0},null,0,null,"-"]
[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":1896},null,"-",null,"-",null,{"$f":"'SCH M-2.2'!T45","v":0},null,1896,null,"-"]
[16,null,"    TOTAL",null,null,{"$f":"SUM(F19:F33)","v":1196911},null,{"$f":"SUM(H19:H33)","v":13148355},null,{"$f":"SUM(J19:J33)","v":56805094},null,{"$f":"IF(H34=0,\"-\",ROUND(J34/H34,4))","v":4.3202999999999996},null,{"$f":"SUM(N19:N33)","v":100},null,{"$f":"SUM(P19:P33)","v":36334174},null,{"$f":"SUM(R19:R33)","v":93139268},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. 2018- 00261"}]
["ANNUALIZED REVENUES AT PROPOSED VS. MOST CURRENT RATES"]
[{"$f":"TIME_PERIOD","v":"FOR THE TWELVE MONTHS ENDED MARCH 31, 2020"}]
[{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE M-2.2"]
[{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PAGE  1  OF  7"]
["WORK PAPER REFERENCE NO(S).:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,{"$f":"INPUT!D4","v":"INCLUDES ALL RIDERS"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"B. L. Sailers"}]
["CURRENT ANNUALIZED"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"CURRENT",null,"% OF REV TO",null,"REVENUE",null,"% INCR IN",null,null,null,"CURRENT",null,"TOTAL"]
[null,null,null,null,null,null,null,null,null,"MOST",null,"REVENUE LESS",null,"TOTAL LESS",null,"INCR LESS",null,"REV LESS ",null,null,null,"TOTAL",null,"REVENUE"]
["LINE",null,"RATE","CLASS /",null,"CUSTOMER",null,null,null,"CURRENT",null,"GAS COST",null,"GAS COST",null,"GAS COST REV",null,"GAS COST REV",null,"GAS COST",null,"REVENUE",null,"% INCREASE"]
[" NO.",null,"CODE","DESCRIPTION",null,"BILLS(1)",null,"SALES(2)",null,"RATES",null,"REVENUE(4)",null,"REVENUE",null,"(F - K)",null,"(M / K)",null,"REVENUE(3)",null,"(K + H)",null,"(M / K1)"]
[null,null,"(A)","(B)",null,"(C)",null,"(D)",null,"(J)",null,"(K)",null,"(L)",null,"(M)",null,"(N)",null,"(H)",null,"(K1)",null,"(O)"]
[]
[null,null,null,null,null,null,null,"(MCF)",null,"($/MCF)",null,"($)",null,"(%)",null,"($)",null,"(%)",null,"($)",null,"($)",null,"(%)"]
[1,null,"SALES SERVICE:"]
[2,null,"RS","RESIDENTIAL",null,{"$f":"'Rate RS'!X83","v":1110274},null,{"$f":"'Rate RS'!Z83","v":5915484},null,{"$f":"ROUND((L20/H20),4)","v":6.6829999999999998},null,{"$f":"'Rate RS'!AD83","v":39533306},null,{"$f":"ROUND((L20/L$21)*100,2)","v":100},null,{"$f":"'Rate RS'!AH83","v":6448428},null,{"$f":"IF(L20=0,\"0.0 \",ROUND((P20/L20)*100,1))","v":16.3},null,{"$f":"'Rate RS'!AL83","v":23746527},null,{"$f":"'Rate RS'!AN83","v":63279833},null,{"$f":"IF(V20=0,\"0.0 \",ROUND((P20/V20)*100,1))","v":10.199999999999999}]
[3,null,null,"  TOTAL RS",null,{"$f":"F20","v":1110274},null,{"$f":"H20","v":5915484},null,{"$f":"ROUND((L21/H21),4)","v":6.6829999999999998},null,{"$f":"L20","v":39533306},null,{"$f":"ROUND((L21/$L48)*100,2)+0.01","v":69.600000000000009},null,{"$f":"P20","v":6448428},null,{"$f":"IF(L21=0,\"0.0 \",ROUND((P21/L21)*100,1))","v":16.3},null,{"$f":"T20","v":23746527},null,{"$f":"V20","v":63279833},null,{"$f":"IF(V21=0,\"0.0 \",ROUND((P21/V21)*100,1))","v":10.199999999999999}]
[]
[4,null,"GS","COMMERCIAL",null,{"$f":"'Rate GS COM'!X81","v":78250},null,{"$f":"'Rate GS COM'!Z81","v":2630680},null,{"$f":"ROUND((L23/H23),4)","v":3.5188000000000001},null,{"$f":"'Rate GS COM'!AD81","v":9256946},null,{"$f":"ROUND((L23/$L26)*100,2)","v":87.09},null,{"$f":"'Rate GS COM'!AH81","v":2041714},null,{"$f":"IF(L23=0,\"0.0 \",ROUND((P23/L23)*100,1))","v":22.1},null,{"$f":"'Rate GS COM'!AL81","v":10560339},null,{"$f":"'Rate GS COM'!AN81","v":19817285},null,{"$f":"IF(V23=0,\"0.0 \",ROUND((P23/V23)*100,1))","v":10.3}]
[5,null,"GS","INDUSTRIAL",null,{"$f":"'Rate GS IND'!X86","v":2513},null,{"$f":"'Rate GS IND'!Z86","v":171720},null,{"$f":"ROUND((L24/H24),4)","v":2.7742},null,{"$f":"'Rate GS IND'!AD86","v":476382},null,{"$f":"ROUND((L24/$L26)*100,2)","v":4.4800000000000004},null,{"$f":"'Rate GS IND'!AH86","v":131406},null,{"$f":"IF(L24=0,\"0.0 \",ROUND((P24/L24)*100,1))","v":27.6},null,{"$f":"'Rate GS IND'!AL86","v":689336},null,{"$f":"'Rate GS IND'!AN86","v":1165718},null,{"$f":"IF(V24=0,\"0.0 \",ROUND((P24/V24)*100,1))","v":11.3}]
[6,null,"GS","OTH PUB AUTH",null,{"$f":"'Rate GS OPA'!X83","v":4482},null,{"$f":"'Rate GS OPA'!Z83","v":328708},null,{"$f":"ROUND((L25/H25),4)","v":2.7248999999999999},null,{"$f":"'Rate GS OPA'!AD83","v":895711},null,{"$f":"ROUND((L25/$L26)*100,2)","v":8.43},null,{"$f":"'Rate GS OPA'!AH83","v":251302},null,{"$f":"IF(L25=0,\"0.0 \",ROUND((P25/L25)*100,1))","v":28.1},null,{"$f":"'Rate GS OPA'!AL83","v":1319533},null,{"$f":"'Rate GS OPA'!AN83","v":2215244},null,{"$f":"IF(V25=0,\"0.0 \",ROUND((P25/V25)*100,1))","v":11.3}]
[7,null,null,"   TOTAL GS",null,{"$f":"SUM(F23:F25)","v":85245},null,{"$f":"SUM(H23:H25)","v":3131108},null,{"$f":"ROUND((L26/H26),4)","v":3.3946999999999998},null,{"$f":"SUM(L23:L25)","v":10629039},null,{"$f":"ROUND((L26/$L48)*100,2)","v":18.71},null,{"$f":"SUM(P23:P25)","v":2424422},null,{"$f":"IF(L26=0,\"0.0 \",ROUND((P26/L26)*100,1))","v":22.8},null,{"$f":"SUM(T23:T25)","v":12569208},null,{"$f":"SUM(V23:V25)","v":23198247},null,{"$f":"IF(V26=0,\"0.0 \",ROUND((P26/V26)*100,1))","v":10.5}]
[]
[8,null,"  TOTAL SALES SERVICE",null,null,{"$f":"F21+F26","v":1195519},null,{"$f":"H21+H26","v":9046592},null,{"$f":"ROUND((L28/H28),4)","v":5.5449000000000002},null,{"$f":"L21+L26","v":50162345},null,{"$f":"100-N33-N46","v":88.31},null,{"$f":"P21+P26","v":8872850},null,{"$f":"IF(L28=0,\"0.0 \",ROUND((P28/L28)*100,1))","v":17.7},null,{"$f":"T21+T26","v":36315735},null,{"$f":"V21+V26","v":86478080},null,{"$f":"IF(V28=0,\"0.0 \",ROUND((P28/V28)*100,1))","v":10.3}]
[]
[9,null,"TRANSPORTATION SERVICE:"]
[10,null,"FT-L","FIRM TRANSP - LARGE",null,{"$f":"'Rate FT-LG'!X75","v":1128},null,{"$f":"'Rate FT-LG'!Z75","v":2617229},null,{"$f":"ROUND((L31/H31),4)","v":1.9267000000000001},null,{"$f":"'Rate FT-LG'!AD75","v":5042683},null,{"$f":"ROUND((L31/L$33)*100,2)","v":76.790000000000006},null,{"$f":"'Rate FT-LG'!AH75","v":1545473},null,{"$f":"IF(L31=0,\"0.0 \",ROUND((P31/L31)*100,1))","v":30.6},null,{"$f":"'Rate FT-LG'!AL75","v":0},null,{"$f":"'Rate FT-LG'!AN75","v":5042683},null,{"$f":"IF(V31=0,\"0.0 \",ROUND((P31/V31)*100,1))","v":30.6}]
[11,null,"IT","INTERRUPTIBLE TRANSP",null,{"$f":"'Rate IT'!X76","v":264},null,{"$f":"'Rate IT'!Z76","v":1479992},null,{"$f":"ROUND((L32/H32),4)","v":1.0299},null,{"$f":"'Rate IT'!AD76","v":1524248},null,{"$f":"ROUND((L32/L$33)*100,2)","v":23.21},null,{"$f":"'Rate IT'!AH76","v":123876},null,{"$f":"IF(L32=0,\"0.0 \",ROUND((P32/L32)*100,1))","v":8.1},null,{"$f":"'Rate IT'!AL76","v":0},null,{"$f":"'Rate IT'!AN76","v":1524248},null,{"$f":"IF(V32=0,\"0.0 \",ROUND((P32/V32)*100,1))","v":8.1}]
[12,null,"  TOTAL TRANSP SERVICE",null,null,{"$f":"SUM(F31:F32)","v":1392},null,{"$f":"SUM(H31:H32)","v":4097221},null,{"$f":"ROUND((L33/H33),4)","v":1.6028},null,{"$f":"SUM(L31:L32)","v":6566931},null,{"$f":"ROUND((L33/L$48)*100,2)","v":11.56},null,{"$f":"SUM(P31:P32)","v":1669349},null,{"$f":"IF(L33=0,\"0.0 \",ROUND((P33/L33)*100,1))","v":25.4},null,{"$f":"SUM(T31:T32)","v":0},null,{"$f":"SUM(V31:V32)","v":6566931},null,{"$f":"IF(V33=0,\"0.0 \",ROUND((P33/V33)*100,1))","v":25.4}]
[13,null,"TOTAL THROUGHPUT",null,null,{"$f":"F28+F33","v":1196911},null,{"$f":"H28+H33","v":13143813},null,{"$f":"ROUND((L34/H34),4)","v":4.3159999999999998},null,{"$f":"L28+L33","v":56729276},null,{"$f":"N28+N33","v":99.87},null,{"$f":"P28+P33","v":10542199},null,{"$f":"IF(L34=0,\"0.0 \",ROUND((P34/L34)*100,1))","v":18.600000000000001},null,{"$f":"T28+T33","v":36315735},null,{"$f":"V28+V33","v":93045011},null,{"$f":"IF(V34=0,\"0.0 \",ROUND((P34/V34)*100,1))","v":11.3}]
[]
[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,28032,null,36.97,null,{"$f":"'SCH M-2.3'!L38-'SCH M-2.2'!L38","v":0},null,null,null,0,null,28032]
[17,null,"RECONNECTION CHARGES",null,null,0,null,0,null,null,null,22068,null,29.11,null,{"$f":"'SCH M-2.3'!L39-'SCH M-2.2'!L39","v":0},null,null,null,0,null,22068]
[18,null,"RENTS",null,null,0,null,0,null,null,null,14496,null,19.12,null,{"$f":"'SCH M-2.3'!L40-'SCH M-2.2'!L40","v":0},null,null,null,0,null,14496]
[19,null,"INTERDEPARTMENTAL",null,null,0,null,4542,null,null,null,{"$f":"ROUND(V41-(H41*EGC),0)-206","v":9326},null,{"$f":"ROUND((L41/L$46)*100,2)","v":12.3},null,{"$f":"'SCH M-2.3'!L41-'SCH M-2.2'!L41","v":0},null,null,null,{"$f":"V41-L41","v":18439},null,27765]
[20,null,"SPECIAL CONTRACTS",null,null,0,null,0,null,null,null,0,null,0,null,{"$f":"'SCH M-2.3'!L42-'SCH M-2.2'!L42","v":0},null,null,null,0,null,0]
[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,{"$f":"924+972","v":1896},null,2.5,null,{"$f":"'SCH M-2.3'!L45-'SCH M-2.2'!L45","v":0},null,null,null,0,null,1896]
[24,null,"  TOTAL MISC",null,null,{"$f":"SUM(F37:F45)","v":0},null,{"$f":"SUM(H37:H45)","v":4542},null,null,null,{"$f":"SUM(L37:L45)","v":75818},null,{"$f":"ROUND((L46/L$48)*100,2)","v":0.13},null,{"$f":"SUM(P37:P45)","v":0},null,{"$f":"IF(L46=0,\"0.0 \",ROUND((P46/L46)*100,1))","v":0},null,{"$f":"SUM(T37:T45)","v":18439},null,{"$f":"SUM(V37:V45)","v":94257},null,{"$f":"IF(V46=0,\"0.0 \",ROUND((P46/V46)*100,1))","v":0}]
[]
[25,null,"    TOTAL COMPANY",null,null,{"$f":"F28+F33+F46","v":1196911},null,{"$f":"H28+H33+H46","v":13148355},null,{"$f":"ROUND((L48/H48),4)","v":4.3202999999999996},null,{"$f":"L28+L33+L46","v":56805094},null,100,null,{"$f":"P28+P33+P46","v":10542199},null,{"$f":"IF(L48=0,\"0.0 \",ROUND((P48/L48)*100,1))","v":18.600000000000001},null,{"$f":"T28+T33+T46","v":36334174},null,{"$f":"V28+V33+V46","v":93139268},null,{"$f":"IF(V48=0,\"0.0 \",ROUND((P48/V48)*100,1))","v":11.3}]
[]
[null,null,"(1) DETAIL CONTAINED ON SCHEDULES M-2.2, PAGES 2 THROUGH 7."]
[null,null,"(2) REFLECTS NORMALIZED VOLUMES."]
[null,null,{"$f":"\"(3) REFLECTS AVERAGE EXPECTED GAS COST OF \"&TEXT(EGC,\"$0.000\")&\"/MCF.\"","v":"(3) REFLECTS AVERAGE EXPECTED GAS COST OF $4.014/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. 2018- 00261"}]
["ANNUALIZED REVENUES AT PROPOSED VS. MOST CURRENT RATES"]
[{"$f":"TIME_PERIOD","v":"FOR THE TWELVE MONTHS ENDED MARCH 31, 2020"}]
[{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE M-2.3"]
[{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PAGE  1  OF  7"]
["WORK PAPER REFERENCE NO(S).: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,{"$f":"INPUT!D4","v":"INCLUDES ALL RIDERS"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"B. L. Sailers"}]
["PROPOSED ANNUALIZED"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"PROPOSED",null,"% OF REV TO",null,null,null,"PROPOSED"]
[null,null,null,null,null,null,null,null,null,null,null,"REVENUE LESS",null,"TOTAL LESS",null,null,null,"TOTAL"]
["LINE",null,"RATE","CLASS /",null,"CUSTOMER",null,null,null,"PROPOSED",null,"GAS COST",null,"GAS COST",null,"GAS COST",null,"REVENUE"]
[" NO.",null,"CODE","DESCRIPTION",null,"BILLS(1)",null,"SALES(2)",null,"RATES",null,"REVENUE(4)",null,"REVENUE",null,"REVENUE(3)",null,"(F + H)"]
[null,null,"(A)","(B)",null,"(C)",null,"(D)",null,"(E)",null,"(F)",null,"(G)",null,"(H)",null,"(I)"]
[]
[null,null,null,null,null,null,null,"(MCF)",null,"($/MCF)",null,"($)",null,"(%)",null,"($)",null,"($)"]
[1,null,"SALES SERVICE:"]
[2,null,"RS","RESIDENTIAL",null,{"$f":"'Rate RS'!F40","v":1110274},null,{"$f":"'Rate RS'!H40","v":5915484},null,{"$f":"IF(F20=0,\"0.0 \",ROUND((L20/H20),4))","v":7.7731000000000003},null,{"$f":"'Rate RS'!L40","v":45981734},null,{"$f":"ROUND((L20/L$21)*100,2)","v":100},null,{"$f":"'Rate RS'!P40","v":23746527},null,{"$f":"'Rate RS'!R40","v":69728261}]
[3,null,null,"  TOTAL RS",null,{"$f":"F20","v":1110274},null,{"$f":"H20","v":5915484},null,{"$f":"IF(F21=0,\"0.0 \",ROUND((L21/H21),4))","v":7.7731000000000003},null,{"$f":"L20","v":45981734},null,{"$f":"ROUND((L21/L$48)*100,2)","v":68.28},null,{"$f":"P20","v":23746527},null,{"$f":"R20","v":69728261}]
[]
[4,null,"GS","COMMERCIAL",null,{"$f":"'Rate GS COM'!F39","v":78250},null,{"$f":"'Rate GS COM'!H39","v":2630680},null,{"$f":"IF(F23=0,\"0.0 \",ROUND((L23/H23),4))","v":4.2949999999999999},null,{"$f":"'Rate GS COM'!L39","v":11298660},null,{"$f":"ROUND((L23/L$26)*100,2)","v":86.56},null,{"$f":"'Rate GS COM'!P39","v":10560339},null,{"$f":"'Rate GS COM'!R39","v":21858999}]
[5,null,"GS","INDUSTRIAL",null,{"$f":"'Rate GS IND'!F39","v":2513},null,{"$f":"'Rate GS IND'!H39","v":171720},null,{"$f":"IF(F24=0,\"0.0 \",ROUND((L24/H24),4))","v":3.5394000000000001},null,{"$f":"'Rate GS IND'!L39","v":607788},null,{"$f":"ROUND((L24/L$26)*100,2)","v":4.66},null,{"$f":"'Rate GS IND'!P39","v":689336},null,{"$f":"'Rate GS IND'!R39","v":1297124}]
[6,null,"GS","OTH PUB AUTH",null,{"$f":"'Rate GS OPA'!F39","v":4482},null,{"$f":"'Rate GS OPA'!H39","v":328708},null,{"$f":"IF(F25=0,\"0.0 \",ROUND((L25/H25),4))","v":3.4895},null,{"$f":"'Rate GS OPA'!L39","v":1147013},null,{"$f":"ROUND((L25/L$26)*100,2)","v":8.7899999999999991},null,{"$f":"'Rate GS OPA'!P39","v":1319533},null,{"$f":"'Rate GS OPA'!R39","v":2466546}]
[7,null,null,"   TOTAL GS",null,{"$f":"SUM(F23:F25)","v":85245},null,{"$f":"SUM(H23:H25)","v":3131108},null,{"$f":"IF(F26=0,\"0.0 \",ROUND((L26/H26),4))","v":4.1689999999999996},null,{"$f":"SUM(L23:L25)","v":13053461},null,{"$f":"ROUND((L26/L$48)*100,2)","v":19.38},null,{"$f":"SUM(P23:P25)","v":12569208},null,{"$f":"SUM(R23:R25)","v":25622669}]
[]
[8,null,"  TOTAL SALES SERVICE",null,null,{"$f":"F21+F26","v":1195519},null,{"$f":"H21+H26","v":9046592},null,{"$f":"IF(F28=0,\"0.0 \",ROUND((L28/H28),4))","v":6.5256999999999996},null,{"$f":"L21+L26","v":59035195},null,{"$f":"ROUND((L28/L$48)*100,2)","v":87.66},null,{"$f":"P21+P26","v":36315735},null,{"$f":"R21+R26","v":95350930}]
[]
[9,null,"TRANSPORTATION SERVICE:"]
[10,null,"FT-L","FIRM TRANSP - LARGE",null,{"$f":"'Rate FT-LG'!F36","v":1128},null,{"$f":"'Rate FT-LG'!H36","v":2617229},null,{"$f":"IF(F31=0,\"0.0 \",ROUND((L31/H31),4))","v":2.5171999999999999},null,{"$f":"'Rate FT-LG'!L36","v":6588156},null,{"$f":"ROUND((L31/L$33)*100,2)","v":79.989999999999995},null,{"$f":"'Rate FT-LG'!P36","v":0},null,{"$f":"'Rate FT-LG'!R36","v":6588156}]
[11,null,"IT","INTERRUPTIBLE TRANSP",null,{"$f":"'Rate IT'!F35","v":264},null,{"$f":"'Rate IT'!H35","v":1479992},null,{"$f":"IF(F32=0,\"0.0 \",ROUND((L32/H32),4))","v":1.1135999999999999},null,{"$f":"'Rate IT'!L35","v":1648124},null,{"$f":"ROUND((L32/L$33)*100,2)","v":20.010000000000002},null,{"$f":"'Rate IT'!P35","v":0},null,{"$f":"'Rate IT'!R35","v":1648124}]
[12,null,"  TOTAL TRANSP SERVICE",null,null,{"$f":"SUM(F31:F32)","v":1392},null,{"$f":"SUM(H31:H32)","v":4097221},null,{"$f":"IF(F33=0,\"0.0 \",ROUND((L33/H33),4))","v":2.0102000000000002},null,{"$f":"SUM(L31:L32)","v":8236280},null,{"$f":"ROUND((L33/L$48)*100,2)","v":12.23},null,{"$f":"SUM(P31:P32)","v":0},null,{"$f":"SUM(R31:R32)","v":8236280}]
[13,null,"TOTAL THROUGHPUT",null,null,{"$f":"F28+F33","v":1196911},null,{"$f":"H28+H33","v":13143813},null,{"$f":"IF(F34=0,\"0.0 \",ROUND((L34/H34),4))","v":5.1181000000000001},null,{"$f":"L28+L33","v":67271475},null,{"$f":"N28+N33","v":99.89},null,{"$f":"P28+P33","v":36315735},null,{"$f":"R28+R33","v":103587210}]
[]
[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":28032},null,36.97,null,0,null,28032]
[17,null,"RECONNECTION CHARGES",null,null,0,null,0,null,null,null,{"$f":"'SCH M-2.2'!L39","v":22068},null,29.11,null,0,null,22068]
[18,null,"RENTS",null,null,0,null,0,null,null,null,{"$f":"'SCH M-2.2'!L40","v":14496},null,19.12,null,0,null,14496]
[19,null,"INTERDEPARTMENTAL",null,null,{"$f":"'SCH M-2.2'!F41","v":0},null,{"$f":"'SCH M-2.2'!H41","v":4542},null,null,null,{"$f":"'SCH M-2.2'!L41","v":9326},null,12.3,null,{"$f":"'SCH M-2.2'!T41","v":18439},null,{"$f":"'SCH M-2.2'!V41","v":27765}]
[20,null,"SPECIAL CONTRACTS",null,null,{"$f":"'SCH M-2.2'!F42","v":0},null,{"$f":"'SCH M-2.2'!H42","v":0},null,null,null,{"$f":"'SCH M-2.2'!L42","v":0},null,0,null,0,null,0]
[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":1896},null,2.5,null,0,null,1896]
[24,null,"  TOTAL MISC",null,null,{"$f":"SUM(F37:F45)","v":0},null,{"$f":"SUM(H37:H45)","v":4542},null,null,null,{"$f":"SUM(L37:L45)","v":75818},null,{"$f":"ROUND((L46/L$48)*100,2)","v":0.11},null,{"$f":"SUM(P37:P45)","v":18439},null,{"$f":"SUM(R37:R45)","v":94257}]
[]
[25,null,"    TOTAL COMPANY",null,null,{"$f":"F28+F33+F46","v":1196911},null,{"$f":"H28+H33+H46","v":13148355},null,{"$f":"IF(F48=0,\"0.0 \",ROUND((L48/H48),4))","v":5.1220999999999997},null,{"$f":"L28+L33+L46","v":67347293},null,100,null,{"$f":"P28+P33+P46","v":36334174},null,{"$f":"R28+R33+R46","v":103681467}]
[]
[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.014/MCF."}]

{"sheet":"Rate RS","index":6,"n_rows":87,"n_cols":42,"rows_kept":87,"cut":false,"hidden":false,"merged":[]}
[{"$f":"COMPANY","v":"DUKE ENERGY KENTUCKY"}]
[{"$f":"CASE","v":"CASE NO. 2018- 00261"}]
["ANNUALIZED REVENUES AT PROPOSED VS. MOST CURRENT RATES"]
[{"$f":"TIME_PERIOD","v":"FOR THE TWELVE MONTHS ENDED MARCH 31, 2020"}]
[{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE M-2.3"]
[{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PAGE  2  OF  7"]
["WORK PAPER REFERENCE NO(S).:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"B. L. Sailers"}]
["PROPOSED ANNUALIZED"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"PROPOSED",null,"% OF REV TO",null,null,null,"PROPOSED"]
[null,null,null,null,null,null,null,null,null,null,null,"REVENUE LESS",null,"TOTAL LESS",null,null,null,"TOTAL"]
["LINE",null,"RATE","CLASS /",null,"CUSTOMER",null,null,null,"PROPOSED",null,"GAS COST",null,"GAS COST",null,"GAS COST",null,"REVENUE"]
[" NO.",null,"CODE","DESCRIPTION",null,"BILLS(1)",null,"SALES(2)",null,"RATES",null,"REVENUE",null,"REVENUE",null,"REVENUE(3)",null,"(F + H)"]
[null,null,"(A)","(B)",null,"(C)",null,"(D)",null,"(E)",null,"(F)",null,"(G)",null,"(H)",null,"(I)"]
[]
[null,null,null,null,null,null,null,"(MCF)",null,"($/MCF)",null,"($)",null,"(%)",null,"($)",null,"($)"]
[1,null,"RS","RESIDENTIAL"]
[]
[2,null,"CUSTOMER CHARGE:"]
[3,null,"RESIDENTIAL"]
[4,null,"     TOTAL MONTHLY BILLS  x   :"]
[5,null,"     CUSTOMER CHARGE PER  MONTH",null,null,1110274,null,null,null,{"$f":"PRO_RS_CUST","v":17.5},null,{"$f":"ROUND(F24*J24,0)","v":19429795},null,{"$f":"ROUND((L24/$L$40)*100,1)","v":42.3},null,null,null,{"$f":"L24+P24","v":19429795}]
[]
[6,null,"COMMODITY CHARGE:"]
[7,null,"     ALL CONSUMPTION",null,null,null,null,5915484,2.64,{"$f":"PRO_RS_COM","v":4.8677000000000001},null,{"$f":"ROUND((H27*J27),0)","v":28794801},null,{"$f":"ROUND((L27/$L$40)*100,1)","v":62.6},null,{"$f":"ROUND(H27*EGC,0)","v":23746527},null,{"$f":"L27+P27","v":52541328}]
[]
[8,null,"RATE RS EXCLUDING RIDERS",null,null,{"$f":"F24","v":1110274},null,{"$f":"H27","v":5915484},null,null,null,{"$f":"SUM(L24:L27)","v":48224596},null,{"$f":"ROUND((L29/$L$40)*100,1)","v":104.9},null,{"$f":"SUM(P24:P27)","v":23746527},null,{"$f":"SUM(R24:R27)","v":71971123}]
[]
[9,null,"RIDERS:"]
[10,null,"HOME ENERGY ASSISTANCE PROGRAM (HEA)",null,null,null,null,null,null,{"$f":"PRO_RS_HEA","v":0.1},null,{"$f":"ROUND(F24*PRO_RS_HEA,0)","v":111027},null,{"$f":"ROUND((L32/$L$40)*100,1)","v":0.2},null,null,null,{"$f":"L32+P32","v":111027}]
[11,null,"DEMAND SIDE MANAGEMENT RATE (DSMR)",null,null,null,null,null,null,{"$f":"PRO_RS_DSM","v":-0.39792},null,{"$f":"ROUND(H27*J33,0)","v":-2353889},null,{"$f":"ROUND((L33/$L$40)*100,1)","v":-5.0999999999999996},null,null,null,{"$f":"L33+P33","v":-2353889}]
[]
[12,null,"WEATHER NORMALIZATION ADJUSTMENT (WNA)",null,null,null,null,null,null,0,null,{"$f":"ROUND(H29*J35,0)","v":0},null,{"$f":"ROUND((L35/$L$40)*100,1)","v":0},null,null,null,{"$f":"L35+P35","v":0}]
[13,null,"ACCELERATED SERVICE REPLACEMENT PROGRAM (ASRP)",null,null,null,null,null,null,{"$f":"PRO_ASRP_RS","v":0},null,{"$f":"ROUND(F24*J36,0)","v":0},null,{"$f":"ROUND((L36/$L$40)*100,1)","v":0},null,null,null,{"$f":"L36+P36","v":0}]
[]
[14,null,"TOTAL RIDERS",null,null,null,null,null,null,null,null,{"$f":"SUM(L32:L36)","v":-2242862},null,{"$f":"ROUND((L38/$L$40)*100,1)","v":-4.9000000000000004},null,null,null,{"$f":"SUM(R32:R36)","v":-2242862}]
[]
[15,null,"TOTAL RATE RS RESIDENTIAL INCLUDING RIDERS",null,null,{"$f":"F24","v":1110274},null,{"$f":"H27","v":5915484},null,null,null,{"$f":"L29+L38","v":45981734},null,{"$f":"SUM(N29+N38)","v":100},null,{"$f":"P29+P38","v":23746527},null,{"$f":"R29+R38","v":69728261}]
[]
[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.014/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. 2018- 00261"}]
[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 MARCH 31, 2020"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE M-2.2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R7","v":"PAGE  2  OF  7"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WORK PAPER REFERENCE NO(S).:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"B. L. Sailers"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  CURRENT ANNUALIZED"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CURRENT",null,"% OF REV TO",null,"REVENUE",null,"% INCR IN",null,null,null,"CURRENT",null,"TOTAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MOST",null,"REVENUE LESS",null,"TOTAL LESS",null,"INCR LESS",null,"REV LESS ",null,null,null,"TOTAL",null,"REVENUE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LINE",null,"RATE","CLASS /","CUSTOMER",null,null,null,"CURRENT",null,"GAS COST",null,"GAS COST",null,"GAS COST REV",null,"GAS COST REV",null,"GAS COST",null,"REVENUE",null,"% INCREASE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," NO.",null,"CODE","DESCRIPTION","BILLS(1)",null,"SALES(2)",null,"RATES",null,"REVENUE",null,"REVENUE",null,"(F - K)",null,"(M / K)",null,"REVENUE(3)",null,"(K + H)",null,"(M / K1)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(A)","(B)","(C)",null,"(D)",null,"(J)",null,"(K)",null,"(L)",null,"(M)",null,"(N)",null,"(H)",null,"(K1)",null,"(O)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(MCF)",null,"($/MCF)",null,"($)",null,"(%)",null,"($)",null,"(%)",null,"($)",null,"($)",null,"(%)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,"RS","RESIDENTIAL"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,"CUSTOMER CHARGE:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,"RESIDENTIAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,"     TOTAL MONTHLY BILLS  x  :"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,"     CUSTOMER CHARGE PER  MONTH",null,{"$f":"F24","v":1110274},null,null,null,{"$f":"CUR_RS_CUST","v":16},null,{"$f":"ROUND(X67*AB67,0)","v":17764384},null,{"$f":"ROUND((AD67/$AD$83)*100,1)","v":44.9},null,{"$f":"L24-AD67","v":1665411},null,{"$f":"IF(AD67=0,\"0.0 \",ROUND((AH67/AD67)*100,1))","v":9.4},null,null,null,{"$f":"AD67+AL67","v":17764384},null,{"$f":"IF(AN67=0,\"0.0 \",ROUND((AH67/AN67)*100,1))","v":9.4}]
[]
[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":5915484},null,{"$f":"CUR_RS","v":3.7212999999999998},null,{"$f":"ROUND((Z70*AB70),0)","v":22013291},null,{"$f":"ROUND((AD70/$AD$83)*100,1)","v":55.7},null,{"$f":"L27-AD70","v":6781510},null,{"$f":"IF(AD70=0,\"0.0 \",ROUND((AH70/AD70)*100,1))","v":30.8},null,{"$f":"P27","v":23746527},null,{"$f":"AD70+AL70","v":45759818},null,{"$f":"IF(AN70=0,\"0.0 \",ROUND((AH70/AN70)*100,1))","v":14.8}]
[]
[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":"X67","v":1110274},null,{"$f":"Z70","v":5915484},null,null,null,{"$f":"SUM(AD67:AD70)","v":39777675},null,{"$f":"ROUND((AD72/$AD$83)*100,1)","v":100.6},null,{"$f":"SUM(AH67:AH70)","v":8446921},null,{"$f":"IF(AD72=0,\"0.0 \",ROUND((AH72/AD72)*100,1))","v":21.2},null,{"$f":"SUM(AL67:AL70)","v":23746527},null,{"$f":"SUM(AN67:AN70)","v":63524202},null,{"$f":"IF(AN72=0,\"0.0 \",ROUND((AH72/AN72)*100,1))","v":13.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,"HOME ENERGY ASSISTANCE PROGRAM (HEA)",null,null,null,null,null,{"$f":"CUR_RS_HEA","v":0.1},null,{"$f":"ROUND(X67*CUR_RS_HEA,0)","v":111027},null,{"$f":"ROUND((AD75/$AD$83)*100,1)","v":0.3},null,{"$f":"L32-AD75","v":0},null,{"$f":"IF(AD75=0,\"0.0 \",ROUND((AH75/AD75)*100,1))","v":0},null,null,null,{"$f":"AD75+AL75","v":111027},null,{"$f":"IF(AN75=0,\"0.0 \",ROUND((AH75/AN75)*100,1))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,null,"DEMAND SIDE MANAGEMENT RATE (DSMR)",null,null,null,null,null,{"$f":"CUR_RS_DSM","v":-0.39792},null,{"$f":"ROUND(Z70*AB76,0)","v":-2353889},null,{"$f":"ROUND((AD76/$AD$83)*100,1)","v":-6},null,{"$f":"L33-AD76","v":0},null,{"$f":"IF(AD76=0,\"0.0 \",ROUND((AH76/AD76)*100,1))","v":0},null,null,null,{"$f":"AD76+AL76","v":-2353889},null,{"$f":"IF(AN76=0,\"0.0 \",ROUND((AH76/AN76)*100,1))","v":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,"WEATHER NORMALIZATION ADJUSTMENT (WNA)",null,null,null,null,null,0,null,{"$f":"ROUND(Z72*AB78,0)","v":0},null,{"$f":"ROUND((AD78/$AD$83)*100,1)","v":0},null,{"$f":"L35-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":"A36","v":13},null,"ACCELERATED SERVICE REPLACEMENT PROGRAM (ASRP)",null,null,null,null,null,{"$f":"CUR_ASRP_RS","v":1.8},null,{"$f":"ROUND(X67*AB79,0)","v":1998493},null,5.0999999999999996,null,{"$f":"L36-AD79","v":-1998493},null,-100,null,null,null,1998493,null,-100]
[]
[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 RIDERS",null,null,null,null,null,null,null,{"$f":"SUM(AD75:AD79)","v":-244369},null,{"$f":"ROUND((AD81/$AD$83)*100,1)","v":-0.6},null,{"$f":"SUM(AH75:AH79)","v":-1998493},null,{"$f":"IF(AD81=0,\"0.0 \",ROUND((AH81/AD81)*100,1))","v":817.8},null,null,null,{"$f":"SUM(AN75:AN79)","v":-244369},null,{"$f":"IF(AN81=0,\"0.0 \",ROUND((AH81/AN81)*100,1))","v":817.8}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A40","v":15},null,"TOTAL RATE RS RESIDENTIAL INCLUDING RIDERS",null,{"$f":"X67","v":1110274},null,{"$f":"Z70","v":5915484},null,null,null,{"$f":"AD72+AD81","v":39533306},null,{"$f":"SUM(AF72+AF81)","v":100},null,{"$f":"AH72+AH81","v":6448428},null,{"$f":"IF(AD83=0,\"0.0 \",ROUND((AH83/AD83)*100,1))","v":16.3},null,{"$f":"P40","v":23746527},null,{"$f":"AN72+AN81","v":63279833},null,{"$f":"IF(AN83=0,\"0.0 \",ROUND((AH83/AN83)*100,1))","v":10.199999999999999}]
[]
[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.014/MCF."}]

{"sheet":"Rate GS COM","index":7,"n_rows":214,"n_cols":42,"rows_kept":214,"cut":false,"hidden":false,"merged":[]}
[{"$f":"COMPANY","v":"DUKE ENERGY KENTUCKY"}]
[{"$f":"CASE","v":"CASE NO. 2018- 00261"}]
["ANNUALIZED REVENUES AT PROPOSED VS. MOST CURRENT RATES"]
[{"$f":"TIME_PERIOD","v":"FOR THE TWELVE MONTHS ENDED MARCH 31, 2020"}]
[{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE M-2.3"]
[{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PAGE  3  OF  7"]
["WORK PAPER REFERENCE NO(S).:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"B. L. Sailers"}]
["PROPOSED ANNUALIZED"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"PROPOSED",null,"% OF REV TO",null,null,null,"PROPOSED"]
[null,null,null,null,null,null,null,null,null,null,null,"REVENUE LESS",null,"TOTAL LESS",null,null,null,"TOTAL"]
["LINE",null,"RATE","CLASS /",null,"CUSTOMER",null,null,null,"PROPOSED",null,"GAS COST",null,"GAS COST",null,"GAS COST",null,"REVENUE"]
[" NO.",null,"CODE","DESCRIPTION",null,"BILLS(1)",null,"SALES(2)",null,"RATES",null,"REVENUE",null,"REVENUE",null,"REVENUE(3)",null,"(F + H)"]
[null,null,"(A)","(B)",null,"(C)",null,"(D)",null,"(E)",null,"(F)",null,"(G)",null,"(H)",null,"(I)"]
[]
[null,null,null,null,null,null,null,"(MCF)",null,"($/MCF)",null,"($)",null,"(%)",null,"($)",null,"($)"]
[1,null,"GS","COMMERCIAL"]
[]
[2,null,"CUSTOMER CHARGE:"]
[3,null,"NON-RESIDENTIAL"]
[4,null,"    TOTAL MONTHLY BILLS x  :"]
[5,null,"     CUSTOMER CHARGE PER MONTH",null,null,78250,null,null,null,{"$f":"PRO_GS_CUST","v":50},null,{"$f":"ROUND(F24*J24,0)","v":3912500},null,{"$f":"ROUND((L24/$L$39)*100,1)","v":34.6},null,null,null,{"$f":"L24+P24","v":3912500}]
[]
[6,null,"COMMODITY CHARGE:"]
[7,null,"     ALL CONSUMPTION",null,null,null,null,2630680,null,{"$f":"PRO_GS","v":2.8077000000000001},null,{"$f":"ROUND((H27*J27),0)","v":7386160},null,{"$f":"ROUND((L27/$L$39)*100,1)","v":65.400000000000006},null,{"$f":"ROUND(H27*EGC,0)","v":10560339},null,{"$f":"L27+P27","v":17946499}]
[]
[8,null,"RATE GS COMMERCIAL EXCLUDING RIDERS",null,null,{"$f":"F24","v":78250},null,{"$f":"H27","v":2630680},null,null,null,{"$f":"SUM(L24:L27)","v":11298660},null,{"$f":"ROUND((L29/$L$39)*100,1)","v":100},null,{"$f":"SUM(P24:P27)","v":10560339},null,{"$f":"SUM(R24:R27)","v":21858999}]
[]
[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$39)*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*J34,0)","v":0},null,{"$f":"ROUND((L34/$L$39)*100,1)","v":0},null,null,null,{"$f":"L34+P34","v":0}]
[12,null,"ACCELERATED SERVICE REPLACEMENT PROGRAM (ASRP)",null,null,null,null,null,null,{"$f":"PRO_ASRP_GS","v":0},null,{"$f":"ROUND(F24*J35,0)","v":0},null,{"$f":"ROUND((L35/$L$39)*100,1)","v":0},null,null,null,{"$f":"L35+P35","v":0}]
[]
[13,null,"TOTAL RIDERS",null,null,null,null,null,null,null,null,{"$f":"SUM(L31:L35)","v":0},null,{"$f":"ROUND((L37/$L$39)*100,1)","v":0},null,null,null,{"$f":"SUM(R31:R35)","v":0}]
[]
[14,null,"TOTAL RATE GS COMMERCIAL INCLUDING RIDERS",null,null,{"$f":"F24","v":78250},null,{"$f":"H27","v":2630680},null,null,null,{"$f":"L29+L37","v":11298660},null,{"$f":"N29+N37","v":100},null,{"$f":"P29+P37","v":10560339},null,{"$f":"R29+R37","v":21858999}]
[]
[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.014/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. 2018- 00261"}]
[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 MARCH 31, 2020"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE M-2.2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R7","v":"PAGE  3  OF  7"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WORK PAPER REFERENCE NO(S).:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"B. L. Sailers"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  CURRENT ANNUALIZED"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CURRENT",null,"% OF REV TO",null,"REVENUE",null,"% INCR IN",null,null,null,"CURRENT",null,"TOTAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MOST",null,"REVENUE LESS",null,"TOTAL LESS",null,"INCR LESS",null,"REV LESS ",null,null,null,"TOTAL",null,"REVENUE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LINE",null,"RATE","CLASS /","CUSTOMER",null,null,null,"CURRENT",null,"GAS COST",null,"GAS COST",null,"GAS COST REV",null,"GAS COST REV",null,"GAS COST",null,"REVENUE",null,"% INCREASE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," NO.",null,"CODE","DESCRIPTION","BILLS(1)",null,"SALES(2)",null,"RATES",null,"REVENUE",null,"REVENUE",null,"(F - K)",null,"(M / K)",null,"REVENUE(3)",null,"(K + H)",null,"(M / K1)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(A)","(B)","(C)",null,"(D)",null,"(J)",null,"(K)",null,"(L)",null,"(M)",null,"(N)",null,"(H)",null,"(K1)",null,"(O)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(MCF)",null,"($/MCF)",null,"($)",null,"(%)",null,"($)",null,"(%)",null,"($)",null,"($)",null,"(%)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,"GS","COMMERCIAL"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,"CUSTOMER CHARGE:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,"NON-RESIDENTIAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,"     TOTAL MONTHLY BILLS x  :"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,"     CUSTOMER CHARGE PER MONTH",null,{"$f":"F24","v":78250},null,null,null,47.5,null,{"$f":"ROUND(X66*AB66,0)","v":3716875},null,{"$f":"ROUND((AD66/$AD$81)*100,1)","v":40.200000000000003},null,{"$f":"L24-AD66","v":195625},null,{"$f":"IF(AD66=0,\"0.0 \",ROUND((AH66/AD66)*100,1))","v":5.3},null,null,null,{"$f":"AD66+AL66","v":3716875},null,{"$f":"IF(AN66=0,\"0.0 \",ROUND((AH66/AN66)*100,1))","v":5.3}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,"COMMODITY CHARGE:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,null,"     ALL CONSUMPTION",null,null,null,{"$f":"H27","v":2630680},null,2.0529999999999999,null,{"$f":"ROUND((Z69*AB69),0)","v":5400786},null,{"$f":"ROUND((AD69/$AD$81)*100,1)","v":58.3},null,{"$f":"L27-AD69","v":1985374},null,{"$f":"IF(AD69=0,\"0.0 \",ROUND((AH69/AD69)*100,1))","v":36.799999999999997},null,{"$f":"P27","v":10560339},null,{"$f":"AD69+AL69","v":15961125},null,{"$f":"IF(AN69=0,\"0.0 \",ROUND((AH69/AN69)*100,1))","v":12.4}]
[]
[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":"X66","v":78250},null,{"$f":"Z69","v":2630680},null,null,null,{"$f":"SUM(AD66:AD69)","v":9117661},null,{"$f":"ROUND((AD71/$AD$81)*100,1)","v":98.5},null,{"$f":"SUM(AH66:AH69)","v":2180999},null,{"$f":"IF(AD71=0,\"0.0 \",ROUND((AH71/AD71)*100,1))","v":23.9},null,{"$f":"SUM(AL66:AL69)","v":10560339},null,{"$f":"SUM(AN66:AN69)","v":19678000},null,{"$f":"IF(AN71=0,\"0.0 \",ROUND((AH71/AN71)*100,1))","v":11.1}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,null,"RIDERS:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,{"$f":"C32","v":"DEMAND SIDE MANAGEMENT RATE (DSMR)"},null,null,null,null,null,{"$f":"CUR_GS_DSM","v":0},null,{"$f":"ROUND(Z69*AB74,0)","v":0},null,{"$f":"ROUND((AD74/$AD$81)*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":"A34","v":11},null,"WEATHER NORMALIZATION ADJUSTMENT (WNA)",null,null,null,null,null,0,null,{"$f":"ROUND(Z71*AB76,0)","v":0},null,{"$f":"ROUND((AD76/$AD$81)*100,1)","v":0},null,{"$f":"L34-AD76","v":0},null,{"$f":"IF(AD76=0,\"0.0 \",ROUND((AH76/AD76)*100,1))","v":"0.0 "},null,null,null,{"$f":"AD76+AL76","v":0},null,{"$f":"IF(AN76=0,\"0.0 \",ROUND((AH76/AN76)*100,1))","v":"0.0 "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A35","v":12},null,{"$f":"C35","v":"ACCELERATED SERVICE REPLACEMENT PROGRAM (ASRP)"},null,null,null,null,null,{"$f":"CUR_ASRP_GS","v":1.78},null,{"$f":"ROUND(X66*AB77,0)","v":139285},null,{"$f":"ROUND((AD77/$AD$81)*100,1)","v":1.5},null,{"$f":"L35-AD77","v":-139285},null,{"$f":"IF(AD77=0,\"0.0 \",ROUND((AH77/AD77)*100,1))","v":-100},null,null,null,{"$f":"AD77+AL77","v":139285},null,{"$f":"IF(AN77=0,\"0.0 \",ROUND((AH77/AN77)*100,1))","v":-100}]
[]
[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 RIDERS",null,null,null,null,null,null,null,{"$f":"SUM(AD73:AD77)","v":139285},null,{"$f":"ROUND((AD79/$AD$81)*100,1)","v":1.5},null,{"$f":"SUM(AH73:AH77)","v":-139285},null,{"$f":"IF(AD79=0,\"0.0 \",ROUND((AH79/AD79)*100,1))","v":-100},null,null,null,{"$f":"SUM(AN73:AN77)","v":139285},null,{"$f":"IF(AN79=0,\"0.0 \",ROUND((AH79/AN79)*100,1))","v":-100}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A39","v":14},null,"TOTAL RATE GS COMMERCIAL INCLUDING RIDERS",null,{"$f":"X66","v":78250},null,{"$f":"Z69","v":2630680},null,null,null,{"$f":"AD71+AD79","v":9256946},null,{"$f":"AF71+AF79","v":100},null,{"$f":"AH71+AH79","v":2041714},null,{"$f":"IF(AD81=0,\"0.0 \",ROUND((AH81/AD81)*100,1))","v":22.1},null,{"$f":"P39","v":10560339},null,{"$f":"AN71+AN79","v":19817285},null,{"$f":"IF(AN81=0,\"0.0 \",ROUND((AH81/AN81)*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.014/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":90,"n_cols":42,"rows_kept":90,"cut":false,"hidden":false,"merged":[]}
[{"$f":"COMPANY","v":"DUKE ENERGY KENTUCKY"}]
[{"$f":"CASE","v":"CASE NO. 2018- 00261"}]
["ANNUALIZED REVENUES AT PROPOSED VS. MOST CURRENT RATES"]
[{"$f":"TIME_PERIOD","v":"FOR THE TWELVE MONTHS ENDED MARCH 31, 2020"}]
[{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE M-2.3"]
[{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PAGE  4  OF  7"]
["WORK PAPER REFERENCE NO(S).:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"B. L. Sailers"}]
["PROPOSED ANNUALIZED"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"PROPOSED",null,"% OF REV TO",null,null,null,"PROPOSED"]
[null,null,null,null,null,null,null,null,null,null,null,"REVENUE LESS",null,"TOTAL LESS",null,null,null,"TOTAL"]
["LINE",null,"RATE","CLASS /",null,"CUSTOMER",null,null,null,"PROPOSED",null,"GAS COST",null,"GAS COST",null,"GAS COST",null,"REVENUE"]
[" NO.",null,"CODE","DESCRIPTION",null,"BILLS(1)",null,"SALES(2)",null,"RATES",null,"REVENUE",null,"REVENUE",null,"REVENUE(3)",null,"(F + H)"]
[null,null,"(A)","(B)",null,"(C)",null,"(D)",null,"(E)",null,"(F)",null,"(G)",null,"(H)",null,"(I)"]
[]
[null,null,null,null,null,null,null,"(MCF)",null,"($/MCF)",null,"($)",null,"(%)",null,"($)",null,"($)"]
[1,null,"GS","INDUSTRIAL"]
[]
[2,null,"CUSTOMER CHARGE:"]
[3,null,"NON-RESIDENTIAL"]
[4,null,"    TOTAL MONTHLY BILLS x  :"]
[5,null,"     CUSTOMER CHARGE PER MONTH",null,null,2513,null,null,null,{"$f":"PRO_GS_CUST","v":50},null,{"$f":"ROUND(F24*J24,0)","v":125650},null,{"$f":"ROUND((L24/$L$39)*100,1)","v":20.7},null,null,null,{"$f":"L24+P24","v":125650}]
[]
[6,null,"COMMODITY CHARGE:"]
[7,null,"     ALL CONSUMPTION",null,null,null,null,171720,null,{"$f":"PRO_GS","v":2.8077000000000001},null,{"$f":"ROUND((H27*J27),0)","v":482138},null,{"$f":"ROUND((L27/$L$39)*100,1)","v":79.3},null,{"$f":"ROUND(EGC*$H27,0)","v":689336},null,{"$f":"L27+P27","v":1171474}]
[]
[8,null,"RATE GS INDUSTRIAL EXCLUDING RIDERS",null,null,{"$f":"F24","v":2513},null,{"$f":"H27","v":171720},null,null,null,{"$f":"SUM(L24:L27)","v":607788},null,{"$f":"ROUND((L29/$L$39)*100,1)","v":100},null,{"$f":"SUM(P24:P27)","v":689336},null,{"$f":"SUM(R24:R27)","v":1297124}]
[]
[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$39)*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*J34,0)","v":0},null,{"$f":"ROUND((L34/$L$39)*100,1)","v":0},null,null,null,{"$f":"L34+P34","v":0}]
[12,null,"ACCELERATED SERVICE REPLACEMENT PROGRAM (ASRP)",null,null,null,null,null,null,{"$f":"PRO_ASRP_GS","v":0},null,{"$f":"ROUND(F24*J35,0)","v":0},null,{"$f":"ROUND((L35/$L$39)*100,1)","v":0},null,null,null,{"$f":"L35+P35","v":0}]
[]
[13,null,"TOTAL RIDERS",null,null,null,null,null,null,null,null,{"$f":"SUM(L31:L35)","v":0},null,{"$f":"ROUND((L37/$L$39)*100,1)","v":0},null,null,null,{"$f":"SUM(R31:R35)","v":0}]
[]
[14,null,"TOTAL RATE GS INDUSTRIAL INCLUDING RIDERS",null,null,{"$f":"F24","v":2513},null,{"$f":"H27","v":171720},null,null,null,{"$f":"L29+L37","v":607788},null,{"$f":"N29+N37","v":100},null,{"$f":"P29+P37","v":689336},null,{"$f":"R29+R37","v":1297124}]
[]
[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.014/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. 2018- 00261"}]
[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 MARCH 31, 2020"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE M-2.2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R7","v":"PAGE  4  OF  7"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WORK PAPER REFERENCE NO(S).:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"B. L. Sailers"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CURRENT ANNUALIZED"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CURRENT",null,"% OF REV TO",null,"REVENUE",null,"% INCR IN",null,null,null,"CURRENT",null,"TOTAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MOST",null,"REVENUE LESS",null,"TOTAL LESS",null,"INCR LESS",null,"REV LESS ",null,null,null,"TOTAL",null,"REVENUE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LINE",null,"RATE","CLASS /","CUSTOMER",null,null,null,"CURRENT",null,"GAS COST",null,"GAS COST",null,"GAS COST REV",null,"GAS COST REV",null,"GAS COST",null,"REVENUE",null,"% INCREASE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," NO.",null,"CODE","DESCRIPTION","BILLS(1)",null,"SALES(2)",null,"RATES",null,"REVENUE",null,"REVENUE",null,"(F - K)",null,"(M / K)",null,"REVENUE(3)",null,"(K + H)",null,"(M / K1)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(A)","(B)","(C)",null,"(D)",null,"(J)",null,"(K)",null,"(L)",null,"(M)",null,"(N)",null,"(H)",null,"(K1)",null,"(O)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(MCF)",null,"($/MCF)",null,"($)",null,"(%)",null,"($)",null,"(%)",null,"($)",null,"($)",null,"(%)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,"GS","INDUSTRIAL"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,"CUSTOMER CHARGE:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,"NON-RESIDENTIAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,"     TOTAL MONTHLY BILLS x  :"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,"     CUSTOMER CHARGE PER MONTH",null,{"$f":"F24","v":2513},null,null,null,{"$f":"CUR_GS_CUST","v":47.5},null,{"$f":"ROUND(X71*AB71,0)","v":119368},null,{"$f":"ROUND((AD71/$AD$86)*100,1)","v":25.1},null,{"$f":"L24-AD71","v":6282},null,{"$f":"IF(AD71=0,\"0.0 \",ROUND((AH71/AD71)*100,1))","v":5.3},null,null,null,{"$f":"AD71+AL71","v":119368},null,{"$f":"IF(AN71=0,\"0.0 \",ROUND((AH71/AN71)*100,1))","v":5.3}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,"COMMODITY CHARGE:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,null,"     ALL CONSUMPTION",null,null,null,{"$f":"H27","v":171720},null,{"$f":"CUR_GS","v":2.0529999999999999},null,{"$f":"ROUND((Z74*AB74),0)","v":352541},null,{"$f":"ROUND((AD74/$AD$86)*100,1)","v":74},null,{"$f":"L27-AD74","v":129597},null,{"$f":"IF(AD74=0,\"0.0 \",ROUND((AH74/AD74)*100,1))","v":36.799999999999997},null,{"$f":"P27","v":689336},null,{"$f":"AD74+AL74","v":1041877},null,{"$f":"IF(AN74=0,\"0.0 \",ROUND((AH74/AN74)*100,1))","v":12.4}]
[]
[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":"X71","v":2513},null,{"$f":"Z74","v":171720},null,null,null,{"$f":"SUM(AD71:AD74)","v":471909},null,{"$f":"ROUND((AD76/$AD$86)*100,1)","v":99.1},null,{"$f":"SUM(AH71:AH74)","v":135879},null,{"$f":"IF(AD76=0,\"0.0 \",ROUND((AH76/AD76)*100,1))","v":28.8},null,{"$f":"SUM(AL71:AL74)","v":689336},null,{"$f":"SUM(AN71:AN74)","v":1161245},null,{"$f":"IF(AN76=0,\"0.0 \",ROUND((AH76/AN76)*100,1))","v":11.7}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,null,"RIDERS:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,{"$f":"C39","v":"TOTAL RATE GS INDUSTRIAL INCLUDING RIDERS"},null,null,null,null,null,{"$f":"CUR_GS_DSM","v":0},null,{"$f":"ROUND(Z74*AB79,0)","v":0},null,{"$f":"ROUND((AD79/$AD$86)*100,1)","v":0},null,{"$f":"L32-AD79","v":0},null,{"$f":"IF(AD79=0,\"0.0 \",ROUND((AH79/AD79)*100,1))","v":"0.0 "},null,null,null,{"$f":"AD79+AL79","v":0},null,{"$f":"IF(AN79=0,\"0.0 \",ROUND((AH79/AN79)*100,1))","v":"0.0 "}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A34","v":11},null,"WEATHER NORMALIZATION ADJUSTMENT (WNA)",null,null,null,null,null,0,null,{"$f":"ROUND(Z76*AB81,0)","v":0},null,{"$f":"ROUND((AD81/$AD$86)*100,1)","v":0},null,{"$f":"L34-AD81","v":0},null,{"$f":"IF(AD81=0,\"0.0 \",ROUND((AH81/AD81)*100,1))","v":"0.0 "},null,null,null,{"$f":"AD81+AL81","v":0},null,{"$f":"IF(AN81=0,\"0.0 \",ROUND((AH81/AN81)*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,{"$f":"C35","v":"ACCELERATED SERVICE REPLACEMENT PROGRAM (ASRP)"},null,null,null,null,null,{"$f":"CUR_ASRP_GS","v":1.78},null,{"$f":"ROUND(X71*AB82,0)","v":4473},null,{"$f":"ROUND((AD82/$AD$86)*100,1)","v":0.9},null,{"$f":"L35-AD82","v":-4473},null,{"$f":"IF(AD82=0,\"0.0 \",ROUND((AH82/AD82)*100,1))","v":-100},null,null,null,{"$f":"AD82+AL82","v":4473},null,{"$f":"IF(AN82=0,\"0.0 \",ROUND((AH82/AN82)*100,1))","v":-100}]
[]
[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 RIDERS",null,null,null,null,null,null,null,{"$f":"SUM(AD78:AD82)","v":4473},null,{"$f":"ROUND((AD84/$AD$86)*100,1)","v":0.9},null,{"$f":"SUM(AH78:AH82)","v":-4473},null,{"$f":"IF(AD84=0,\"0.0 \",ROUND((AH84/AD84)*100,1))","v":-100},null,null,null,{"$f":"SUM(AN78:AN82)","v":4473},null,{"$f":"IF(AN84=0,\"0.0 \",ROUND((AH84/AN84)*100,1))","v":-100}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A39","v":14},null,"TOTAL RATE GS INDUSTRIAL INCLUDING RIDERS",null,{"$f":"X71","v":2513},null,{"$f":"Z74","v":171720},null,null,null,{"$f":"AD76+AD84","v":476382},null,{"$f":"AF76+AF84","v":100},null,{"$f":"AH76+AH84","v":131406},null,{"$f":"IF(AD86=0,\"0.0 \",ROUND((AH86/AD86)*100,1))","v":27.6},null,{"$f":"P39","v":689336},null,{"$f":"AN76+AN84","v":1165718},null,{"$f":"IF(AN86=0,\"0.0 \",ROUND((AH86/AN86)*100,1))","v":11.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.014/MCF."}]

{"sheet":"Rate GS OPA","index":9,"n_rows":87,"n_cols":42,"rows_kept":87,"cut":false,"hidden":false,"merged":[]}
[{"$f":"COMPANY","v":"DUKE ENERGY KENTUCKY"}]
[{"$f":"CASE","v":"CASE NO. 2018- 00261"}]
["ANNUALIZED REVENUES AT PROPOSED VS. MOST CURRENT RATES"]
[{"$f":"TIME_PERIOD","v":"FOR THE TWELVE MONTHS ENDED MARCH 31, 2020"}]
[{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE M-2.3"]
[{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PAGE  5  OF  7"]
["WORK PAPER REFERENCE NO(S).:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"B. L. Sailers"}]
["PROPOSED ANNUALIZED"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"PROPOSED",null,"% OF REV TO",null,null,null,"PROPOSED"]
[null,null,null,null,null,null,null,null,null,null,null,"REVENUE LESS",null,"TOTAL LESS",null,null,null,"TOTAL"]
["LINE",null,"RATE","CLASS /",null,"CUSTOMER",null,null,null,"PROPOSED",null,"GAS COST",null,"GAS COST",null,"GAS COST",null,"REVENUE"]
[" NO.",null,"CODE","DESCRIPTION",null,"BILLS(1)",null,"SALES(2)",null,"RATES",null,"REVENUE",null,"REVENUE",null,"REVENUE(3)",null,"(F + H)"]
[null,null,"(A)","(B)",null,"(C)",null,"(D)",null,"(E)",null,"(F)",null,"(G)",null,"(H)",null,"(I)"]
[]
[null,null,null,null,null,null,null,"(MCF)",null,"($/MCF)",null,"($)",null,"(%)",null,"($)",null,"($)"]
[1,null,"GS","OTHER PUBLIC AUTHORITIES"]
[]
[2,null,"CUSTOMER CHARGE:"]
[3,null,"NON-RESIDENTIAL"]
[4,null,"    TOTAL MONTHLY BILLS x  :"]
[5,null,"     CUSTOMER CHARGE PER MONTH",null,null,4482,null,null,null,{"$f":"PRO_GS_CUST","v":50},null,{"$f":"ROUND(F24*J24,0)","v":224100},null,{"$f":"ROUND((L24/$L$39)*100,1)","v":19.5},null,null,null,{"$f":"L24+P24","v":224100}]
[]
[6,null,"COMMODITY CHARGE:"]
[7,null,"     ALL CONSUMPTION",null,null,null,null,328708,null,{"$f":"PRO_GS","v":2.8077000000000001},null,{"$f":"ROUND((H27*J27),0)","v":922913},null,{"$f":"ROUND((L27/$L$39)*100,1)","v":80.5},null,{"$f":"ROUND(EGC*$H27,0)","v":1319533},null,{"$f":"L27+P27","v":2242446}]
[]
[8,null,"RATE GS OPA EXCLUDING RIDERS",null,null,{"$f":"F24","v":4482},null,{"$f":"H27","v":328708},null,null,null,{"$f":"SUM(L24:L27)","v":1147013},null,{"$f":"ROUND((L29/$L$39)*100,1)","v":100},null,{"$f":"SUM(P24:P27)","v":1319533},null,{"$f":"SUM(R24:R27)","v":2466546}]
[]
[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$39)*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*J34,0)","v":0},null,{"$f":"ROUND((L34/$L$39)*100,1)","v":0},null,null,null,{"$f":"L34+P34","v":0}]
[12,null,"ACCELERATED SERVICE REPLACEMENT PROGRAM (ASRP)",null,null,null,null,null,null,{"$f":"PRO_ASRP_GS","v":0},null,{"$f":"ROUND(F24*J35,0)","v":0},null,{"$f":"ROUND((L35/$L$39)*100,1)","v":0},null,null,null,{"$f":"L35+P35","v":0}]
[]
[13,null,"TOTAL RIDERS",null,null,null,null,null,null,null,null,{"$f":"SUM(L31:L35)","v":0},null,{"$f":"ROUND((L37/$L$39)*100,1)","v":0},null,null,null,{"$f":"SUM(R31:R35)","v":0}]
[]
[14,null,"TOTAL RATE GS OPA INCLUDING RIDERS",null,null,{"$f":"F24","v":4482},null,{"$f":"H27","v":328708},null,null,null,{"$f":"L29+L37","v":1147013},null,{"$f":"SUM(N29+N37)","v":100},null,{"$f":"P29+P37","v":1319533},null,{"$f":"R29+R37","v":2466546}]
[]
[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.014/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. 2018- 00261"}]
[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 MARCH 31, 2020"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE M-2.2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R7","v":"PAGE  5  OF  7"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WORK PAPER REFERENCE NO(S).:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"B. L. Sailers"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CURRENT ANNUALIZED"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CURRENT",null,"% OF REV TO",null,"REVENUE",null,"% INCR IN",null,null,null,"CURRENT",null,"TOTAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MOST",null,"REVENUE LESS",null,"TOTAL LESS",null,"INCR LESS",null,"REV LESS ",null,null,null,"TOTAL",null,"REVENUE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LINE",null,"RATE","CLASS /","CUSTOMER",null,null,null,"CURRENT",null,"GAS COST",null,"GAS COST",null,"GAS COST REV",null,"GAS COST REV",null,"GAS COST",null,"REVENUE",null,"% INCREASE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," NO.",null,"CODE","DESCRIPTION","BILLS(1)",null,"SALES(2)",null,"RATES",null,"REVENUE",null,"REVENUE",null,"(F - K)",null,"(M / K)",null,"REVENUE(3)",null,"(K + H)",null,"(M / K1)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(A)","(B)","(C)",null,"(D)",null,"(J)",null,"(K)",null,"(L)",null,"(M)",null,"(N)",null,"(H)",null,"(K1)",null,"(O)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(MCF)",null,"($/MCF)",null,"($)",null,"(%)",null,"($)",null,"(%)",null,"($)",null,"($)",null,"(%)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,"GS","OTHER PUBLIC AUTHORITIES"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,"CUSTOMER CHARGE:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,"NON-RESIDENTIAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,"     TOTAL MONTHLY BILLS  x :"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,"     CUSTOMER CHARGE PER MONTH",null,{"$f":"F24","v":4482},null,null,null,{"$f":"CUR_GS_CUST","v":47.5},null,{"$f":"ROUND(X68*AB68,0)","v":212895},null,{"$f":"ROUND((AD68/$AD$83)*100,1)","v":23.8},null,{"$f":"L24-AD68","v":11205},null,{"$f":"IF(AD68=0,\"0.0 \",ROUND((AH68/AD68)*100,1))","v":5.3},null,null,null,{"$f":"AD68+AL68","v":212895},null,{"$f":"IF(AN68=0,\"0.0 \",ROUND((AH68/AN68)*100,1))","v":5.3}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,"COMMODITY CHARGE:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,null,"     ALL CONSUMPTION",null,null,null,{"$f":"H27","v":328708},null,{"$f":"CUR_GS","v":2.0529999999999999},null,{"$f":"ROUND((Z71*AB71),0)","v":674838},null,{"$f":"ROUND((AD71/$AD$83)*100,1)","v":75.3},null,{"$f":"L27-AD71","v":248075},null,{"$f":"IF(AD71=0,\"0.0 \",ROUND((AH71/AD71)*100,1))","v":36.799999999999997},null,{"$f":"P27","v":1319533},null,{"$f":"AD71+AL71","v":1994371},null,{"$f":"IF(AN71=0,\"0.0 \",ROUND((AH71/AN71)*100,1))","v":12.4}]
[]
[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":"X68","v":4482},null,{"$f":"Z71","v":328708},null,null,null,{"$f":"SUM(AD68:AD71)","v":887733},null,{"$f":"ROUND((AD73/$AD$83)*100,1)","v":99.1},null,{"$f":"SUM(AH68:AH71)","v":259280},null,{"$f":"IF(AD73=0,\"0.0 \",ROUND((AH73/AD73)*100,1))","v":29.2},null,{"$f":"SUM(AL68:AL71)","v":1319533},null,{"$f":"SUM(AN68:AN71)","v":2207266},null,{"$f":"IF(AN73=0,\"0.0 \",ROUND((AH73/AN73)*100,1))","v":11.7}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,null,"RIDERS:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,"DEMAND SIDE MANAGEMENT RATE (DSMR)",null,null,null,null,null,{"$f":"CUR_GS_DSM","v":0},null,{"$f":"ROUND(Z71*AB76,0)","v":0},null,{"$f":"ROUND((AD76/$AD$83)*100,1)","v":0},null,{"$f":"L32-AD76","v":0},null,{"$f":"IF(AD76=0,\"0.0 \",ROUND((AH76/AD76)*100,1))","v":"0.0 "},null,null,null,{"$f":"AD76+AL76","v":0},null,{"$f":"IF(AN76=0,\"0.0 \",ROUND((AH76/AN76)*100,1))","v":"0.0 "}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A34","v":11},null,"WEATHER NORMALIZATION ADJUSTMENT (WNA)",null,null,null,null,null,0,null,{"$f":"ROUND(Z73*AB78,0)","v":0},null,{"$f":"ROUND((AD78/$AD$83)*100,1)","v":0},null,{"$f":"L34-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,{"$f":"C35","v":"ACCELERATED SERVICE REPLACEMENT PROGRAM (ASRP)"},null,null,null,null,null,{"$f":"CUR_ASRP_GS","v":1.78},null,{"$f":"ROUND(X68*AB79,0)","v":7978},null,{"$f":"ROUND((AD79/$AD$83)*100,1)","v":0.9},null,{"$f":"L35-AD79","v":-7978},null,{"$f":"IF(AD79=0,\"0.0 \",ROUND((AH79/AD79)*100,1))","v":-100},null,null,null,{"$f":"AD79+AL79","v":7978},null,{"$f":"IF(AN79=0,\"0.0 \",ROUND((AH79/AN79)*100,1))","v":-100}]
[]
[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 RIDERS",null,null,null,null,null,null,null,{"$f":"SUM(AD75:AD79)","v":7978},null,{"$f":"ROUND((AD81/$AD$83)*100,1)","v":0.9},null,{"$f":"SUM(AH75:AH79)","v":-7978},null,{"$f":"IF(AD81=0,\"0.0 \",ROUND((AH81/AD81)*100,1))","v":-100},null,null,null,{"$f":"SUM(AN75:AN79)","v":7978},null,{"$f":"IF(AN81=0,\"0.0 \",ROUND((AH81/AN81)*100,1))","v":-100}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A39","v":14},null,"TOTAL RATE GS OPA INCLUDING RIDERS",null,{"$f":"X68","v":4482},null,{"$f":"Z71","v":328708},null,null,null,{"$f":"AD73+AD81","v":895711},null,{"$f":"AF73+AF81","v":100},null,{"$f":"AH73+AH81","v":251302},null,{"$f":"IF(AD83=0,\"0.0 \",ROUND((AH83/AD83)*100,1))","v":28.1},null,{"$f":"P39","v":1319533},null,{"$f":"AN73+AN81","v":2215244},null,{"$f":"IF(AN83=0,\"0.0 \",ROUND((AH83/AN83)*100,1))","v":11.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.014/MCF."}]

{"sheet":"Rate FT-LG","index":10,"n_rows":78,"n_cols":42,"rows_kept":78,"cut":false,"hidden":false,"merged":[]}
[{"$f":"COMPANY","v":"DUKE ENERGY KENTUCKY"}]
[{"$f":"CASE","v":"CASE NO. 2018- 00261"}]
["ANNUALIZED REVENUES AT PROPOSED VS. MOST CURRENT RATES"]
[{"$f":"TIME_PERIOD","v":"FOR THE TWELVE MONTHS ENDED MARCH 31, 2020"}]
[{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE M-2.3"]
[{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PAGE  6  OF  7"]
["WORK PAPER REFERENCE NO(S).:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"B. L. Sailers"}]
["PROPOSED ANNUALIZED"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"PROPOSED",null,"% OF REV TO",null,null,null,"PROPOSED"]
[null,null,null,null,null,null,null,null,null,null,null,"REVENUE LESS",null,"TOTAL LESS",null,null,null,"TOTAL"]
["LINE",null,"RATE","CLASS /",null,"CUSTOMER",null,null,null,"PROPOSED",null,"GAS COST",null,"GAS COST",null,"GAS COST",null,"REVENUE"]
[" NO.",null,"CODE","DESCRIPTION",null,"BILLS",null,"SALES(1)",null,"RATES",null,"REVENUE",null,"REVENUE",null,"REVENUE",null,"(F + H)"]
[null,null,"(A)","(B)",null,"(C)",null,"(D)",null,"(E)",null,"(F)",null,"(G)",null,"(H)",null,"(I)"]
[]
[null,null,null,null,null,null,null,"(MCF)",null,"($/MCF)",null,"($)",null,"(%)",null,"($)",null,"($)"]
[1,null,"FT - L"]
[2,null,"FIRM TRANSPORTATION - LARGE"]
[]
[3,null,"ADMINISTRATIVE CHARGE",null,null,1128,null,null,null,{"$f":"PRO_FTL_CUST","v":430},null,{"$f":"ROUND((F22*J22),0)","v":485040},null,{"$f":"ROUND((L22/L$36)*100,1)","v":7.4},null,null,null,{"$f":"L22+P22","v":485040}]
[]
[4,null,"TRANSPORTATION CHARGE:"]
[5,null,"ALL CONSUMPTION",null,null,null,null,2617229,null,{"$f":"PRO_FTL_COM","v":2.3319000000000001},null,{"$f":"ROUND((H25*J25),0)","v":6103116},null,{"$f":"ROUND((L25/L$36)*100,1)","v":92.6},null,null,null,{"$f":"L25+P25","v":6103116}]
[]
[6,null,"RATE FT-LARGE EXCLUDING RIDERS",null,null,{"$f":"F22","v":1128},null,{"$f":"H25","v":2617229},null,null,null,{"$f":"SUM(L22:L25)","v":6588156},null,{"$f":"SUM(N22:N25)","v":100},null,null,null,{"$f":"SUM(R22:R25)","v":6588156}]
[]
[7,null,"RIDERS:"]
[8,null,"ACCELERATED SERVICE REPLACEMENT PROGRAM (ASRP)",null,null,null,null,null,null,{"$f":"PRO_ASRP_FTL","v":0},null,{"$f":"ROUND(H25*J30,0)","v":0},null,{"$f":"ROUND((L30/L$36)*100,1)","v":0},null,null,null,{"$f":"L30+P30","v":0}]
[]
[9,null,"GAS COST ADJUSTMENT TRANSITION (GCAT)",null,null,null,null,null,null,{"$f":"PRO_FTL_GCAT","v":0},null,{"$f":"ROUND(H25*J32,0)","v":0},null,{"$f":"ROUND((L32/L$36)*100,1)","v":0},null,null,null,{"$f":"L32+P32","v":0}]
[]
[10,null,"TOTAL RIDERS",null,null,null,null,null,null,null,null,{"$f":"SUM(L30:L32)","v":0},null,{"$f":"ROUND((L34/L$36)*100,1)","v":0},null,null,null,{"$f":"SUM(R30:R32)","v":0}]
[]
[11,null,"TOTAL RATE FT - LARGE INCLUDING RIDERS",null,null,{"$f":"F22","v":1128},null,{"$f":"H25","v":2617229},null,null,null,{"$f":"L27+L34","v":6588156},null,{"$f":"SUM(N27+N34)","v":100},null,null,null,{"$f":"R27+R34","v":6588156}]
[]
[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,{"$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. 2018- 00261"}]
[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 MARCH 31, 2020"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE M-2.2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R7","v":"PAGE  6  OF  7"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WORK PAPER REFERENCE NO(S).:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"B. L. Sailers"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CURRENT ANNUALIZED"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CURRENT",null,"% OF REV TO",null,"REVENUE",null,"% INCR IN",null,null,null,"CURRENT",null,"TOTAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MOST",null,"REVENUE LESS",null,"TOTAL LESS",null,"INCR LESS",null,"REV LESS ",null,null,null,"TOTAL",null,"REVENUE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LINE",null,"RATE","CLASS /","CUSTOMER",null,null,null,"CURRENT",null,"GAS COST",null,"GAS COST",null,"GAS COST REV",null,"GAS COST REV",null,"GAS COST",null,"REVENUE",null,"% INCREASE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," NO.",null,"CODE","DESCRIPTION","BILLS",null,"SALES(1)",null,"RATES",null,"REVENUE",null,"REVENUE",null,"(F - K)",null,"(M / K)",null,"REVENUE",null,"(K + H)",null,"(M / K1)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(A)","(B)","(C)",null,"(D)",null,"(J)",null,"(K)",null,"(L)",null,"(M)",null,"(N)",null,"(H)",null,"(K1)",null,"(O)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(MCF)",null,"($/MCF)",null,"($)",null,"(%)",null,"($)",null,"(%)",null,"($)",null,"($)",null,"(%)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,"FT - L"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,"FIRM TRANSPORTATION - LARGE"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,"ADMINISTRATIVE CHARGE",null,{"$f":"F22","v":1128},null,null,null,430,null,{"$f":"ROUND(X61*AB61,0)","v":485040},null,{"$f":"IF(AD$75=0,\"0.0 \",ROUND((AD61/AD$75)*100,1))","v":9.6},null,{"$f":"L22-AD61","v":0},null,{"$f":"IF(AD61=0,\"0.0 \",ROUND((AH61/AD61)*100,1))","v":0},null,null,null,{"$f":"AD61+AL61","v":485040},null,{"$f":"IF(AN61=0,\"0.0 \",ROUND((AH61/AN61)*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":2617229},null,1.7369000000000001,null,{"$f":"ROUND(Z64*AB64,0)","v":4545865},null,{"$f":"IF(AD$75=0,\"0.0 \",ROUND((AD64/AD$75)*100,1))+0.1","v":90.199999999999989},null,{"$f":"L25-AD64","v":1557251},null,{"$f":"IF(AD64=0,\"0.0 \",ROUND((AH64/AD64)*100,1))","v":34.299999999999997},null,null,null,{"$f":"AD64+AL64","v":4545865},null,{"$f":"IF(AN64=0,\"0.0 \",ROUND((AH64/AN64)*100,1))","v":34.299999999999997}]
[]
[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":"X61","v":1128},null,{"$f":"Z64","v":2617229},null,null,null,{"$f":"SUM(AD61:AD64)","v":5030905},null,{"$f":"SUM(AF61:AF64)","v":99.799999999999983},null,{"$f":"SUM(AH61:AH64)","v":1557251},null,{"$f":"IF(AD66=0,\"0.0 \",ROUND((AH66/AD66)*100,1))","v":31},null,null,null,{"$f":"SUM(AN61:AN64)","v":5030905},null,{"$f":"IF(AN66=0,\"0.0 \",ROUND((AH66/AN66)*100,1))","v":31}]
[]
[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,{"$f":"C30","v":"ACCELERATED SERVICE REPLACEMENT PROGRAM (ASRP)"},null,null,null,null,null,{"$f":"CUR_ASRP_FTL","v":4.4999999999999997E-3},null,{"$f":"ROUND(Z64*AB69,0)","v":11778},null,{"$f":"IF(AD$75=0,\"0.0 \",ROUND((AD69/AD$75)*100,1))","v":0.2},null,{"$f":"L30-AD69","v":-11778},null,{"$f":"IF(AD69=0,\"0.0 \",ROUND((AH69/AD69)*100,1))","v":-100},null,null,null,{"$f":"AD69+AL69","v":11778},null,{"$f":"IF(AN69=0,\"0.0 \",ROUND((AH69/AN69)*100,1))","v":-100}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,null,"GAS COST ADJUSTMENT TRANSITION (GCAT) ",null,null,null,null,null,{"$f":"CUR_FTL_GCAT","v":0},null,{"$f":"ROUND(Z64*AB71,0)","v":0},null,{"$f":"IF(AD$75=0,\"0.0 \",ROUND((AD71/AD$75)*100,1))","v":0},null,{"$f":"L32-AD71","v":0},null,{"$f":"IF(AD71=0,\"0.0 \",ROUND((AH71/AD71)*100,1))","v":"0.0 "},null,null,null,{"$f":"AD71+AL71","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 RIDERS",null,null,null,null,null,null,null,{"$f":"SUM(AD69:AD71)","v":11778},null,{"$f":"SUM(AF69:AF71)","v":0.2},null,{"$f":"SUM(AH69:AH71)","v":-11778},null,{"$f":"IF(AD73=0,\"0.0 \",ROUND((AH73/AD73)*100,1))","v":-100},null,null,null,{"$f":"SUM(AN69:AN71)","v":11778},null,{"$f":"IF(AN73=0,\"0.0 \",ROUND((AH73/AN73)*100,1))","v":-100}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,null,"TOTAL RATE FT - LARGE INCLUDING RIDERS",null,{"$f":"X61","v":1128},null,{"$f":"Z64","v":2617229},null,null,null,{"$f":"SUM(AD66+AD73)","v":5042683},null,{"$f":"SUM(AF66+AF73)","v":99.999999999999986},null,{"$f":"SUM(AH66+AH73)","v":1545473},null,{"$f":"IF(AD75=0,\"0.0 \",ROUND((AH75/AD75)*100,1))","v":30.6},null,null,null,{"$f":"SUM(AN66+AN73)","v":5042683},null,{"$f":"IF(AN75=0,\"0.0 \",ROUND((AH75/AN75)*100,1))","v":30.6}]
[]
[]
[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."]

{"sheet":"Rate IT","index":11,"n_rows":76,"n_cols":42,"rows_kept":76,"cut":false,"hidden":false,"merged":[]}
[{"$f":"COMPANY","v":"DUKE ENERGY KENTUCKY"}]
[{"$f":"CASE","v":"CASE NO. 2018- 00261"}]
["ANNUALIZED REVENUES AT PROPOSED VS. MOST CURRENT RATES"]
[{"$f":"TIME_PERIOD","v":"FOR THE TWELVE MONTHS ENDED MARCH 31, 2020"}]
[{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE M-2.3"]
[{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PAGE  7  OF  7"]
["WORK PAPER REFERENCE NO(S).:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"B. L. Sailers"}]
["PROPOSED ANNUALIZED"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"PROPOSED",null,"% OF REV TO",null,null,null,"PROPOSED"]
[null,null,null,null,null,null,null,null,null,null,null,"REVENUE LESS",null,"TOTAL LESS",null,null,null,"TOTAL"]
["LINE",null,"RATE","CLASS /",null,"CUSTOMER",null,null,null,"PROPOSED",null,"GAS COST",null,"GAS COST",null,"GAS COST",null,"REVENUE"]
[" NO.",null,"CODE","DESCRIPTION",null,"BILLS",null,"SALES",null,"RATES",null,"REVENUE",null,"REVENUE",null,"REVENUE",null,"(F + H)"]
[null,null,"(A)","(B)",null,"(C)",null,"(D)",null,"(E)",null,"(F)",null,"(G)",null,"(H)",null,"(I)"]
[]
[null,null,null,null,null,null,null,"(MCF)",null,"($/MCF)",null,"($)",null,"(%)",null,"($)",null,"($)"]
[1,null,"IT"]
[2,null,"INTERRUPTIBLE TRANSPORTATION"]
[]
[3,null,"ADMINISTRATIVE CHARGE",null,null,264,null,null,null,{"$f":"PRO_IT_CUST","v":430},null,{"$f":"ROUND((F22*J22),0)","v":113520},null,{"$f":"ROUND((L22/L$35)*100,1)","v":6.9},null,null,null,{"$f":"L22+P22","v":113520}]
[]
[4,null,"COMMODITY CHARGE:"]
[5,null,"    ALL CONSUMPTION",null,null,null,null,1479992,null,{"$f":"PRO_IT_COM","v":1.0368999999999999},null,{"$f":"ROUND((H25*(J25)),0)","v":1534604},null,{"$f":"ROUND((L25/L$35)*100,1)","v":93.1},null,null,null,{"$f":"L25+P25","v":1534604}]
[]
[6,null,"RATE IT EXCLUDING RIDERS",null,null,{"$f":"F22","v":264},null,{"$f":"H25","v":1479992},null,null,null,{"$f":"SUM(L22:L25)","v":1648124},null,{"$f":"SUM(N22:N25)","v":100},null,null,null,{"$f":"SUM(R22:R25)","v":1648124}]
[]
[7,null,"RIDERS:"]
[]
[8,null,"ACCELERATED SERVICE REPLACEMENT PROGRAM (ASRP)",null,null,null,null,null,null,{"$f":"PRO_ASRP_IT","v":0},null,{"$f":"ROUND(H25*J31,0)","v":0},null,{"$f":"ROUND((L31/L$35)*100,1)","v":0},null,null,null,{"$f":"L31+P31","v":0}]
[]
[9,null,"TOTAL RIDERS",null,null,null,null,null,null,null,null,{"$f":"SUM(L29:L31)","v":0},null,{"$f":"ROUND((L33/L$35)*100,1)","v":0},null,null,null,{"$f":"SUM(R29:R31)","v":0}]
[]
[10,null,"TOTAL RATE IT TRANSPORTATION",null,null,{"$f":"F27","v":264},null,{"$f":"H27","v":1479992},null,null,null,{"$f":"L27+L33","v":1648124},null,{"$f":"ROUND((L35/L$35)*100,1)","v":100},null,null,null,{"$f":"R27+R33","v":1648124}]
[]
[]
[]
[]
[]
[]
[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. 2018- 00261"}]
[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 MARCH 31, 2020"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE M-2.2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R7","v":"PAGE  7  OF  7"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WORK PAPER REFERENCE NO(S).:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"B. L. Sailers"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CURRENT ANNUALIZED"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CURRENT",null,"% OF REV TO",null,"REVENUE",null,"% INCR IN",null,null,null,"CURRENT",null,"TOTAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MOST",null,"REVENUE LESS",null,"TOTAL LESS",null,"INCR LESS",null,"REV LESS ",null,null,null,"TOTAL",null,"REVENUE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LINE",null,"RATE","CLASS /","CUSTOMER",null,null,null,"CURRENT",null,"GAS COST",null,"GAS COST",null,"GAS COST REV",null,"GAS COST REV",null,"GAS COST",null,"REVENUE",null,"% INCREASE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," NO.",null,"CODE","DESCRIPTION","BILLS",null,"SALES",null,"RATES",null,"REVENUE(3)",null,"REVENUE",null,"(F - K)",null,"(M / K)",null,"REVENUE",null,"(K + H)",null,"(M / K1)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(A)","(B)","(C)",null,"(D)",null,"(J)",null,"(K)",null,"(L)",null,"(M)",null,"(N)",null,"(H)",null,"(K1)",null,"(O)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(MCF)",null,"($/MCF)",null,"($)",null,"(%)",null,"($)",null,"(%)",null,"($)",null,"($)",null,"(%)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,"RATE IT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,"INTERRUPTIBLE TRANSPORTATION"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,"ADMINISTRATIVE CHARGE",null,{"$f":"F22","v":264},null,null,null,430,null,{"$f":"ROUND(X63*AB63,0)","v":113520},null,{"$f":"ROUND((AD63/AD$76)*100,1)","v":7.4},null,{"$f":"L22-AD63","v":0},null,{"$f":"IF(AD63=0,\"0.0 \",ROUND((AH63/AD63)*100,1))","v":0},null,null,null,{"$f":"AD63+AL63","v":113520},null,{"$f":"IF(AN63=0,\"0.0 \",ROUND((AH63/AN63)*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":1479992},null,0.94930000000000003,null,{"$f":"ROUND(Z66*AB66,0)","v":1404956},null,{"$f":"ROUND((AD66/AD$76)*100,1)","v":92.2},null,{"$f":"L25-AD66","v":129648},null,{"$f":"IF(AD66=0,\"0.0 \",ROUND((AH66/AD66)*100,1))","v":9.1999999999999993},null,null,null,{"$f":"AD66+AL66","v":1404956},null,{"$f":"IF(AN66=0,\"0.0 \",ROUND((AH66/AN66)*100,1))","v":9.1999999999999993}]
[]
[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":"X63","v":264},null,{"$f":"Z66","v":1479992},null,null,null,{"$f":"SUM(AD63:AD66)","v":1518476},null,{"$f":"SUM(AF63:AF66)","v":99.600000000000009},null,{"$f":"L27-AD68","v":129648},null,{"$f":"IF(AD68=0,\"0.0 \",ROUND((AH68/AD68)*100,1))","v":8.5},null,null,null,{"$f":"SUM(AN63:AN66)","v":1518476},null,{"$f":"IF(AN68=0,\"0.0 \",ROUND((AH68/AN68)*100,1))","v":8.5}]
[]
[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,"ACCELERATED SERVICE REPLACEMENT PROGRAM (ASRP)",null,null,null,null,null,{"$f":"CUR_ASRP_IT","v":3.8999999999999998E-3},null,{"$f":"ROUND(Z66*AB72,0)","v":5772},null,{"$f":"ROUND((AD72/AD$76)*100,1)","v":0.4},null,{"$f":"L31-AD72","v":-5772},null,{"$f":"IF(AD72=0,\"0.0 \",ROUND((AH72/AD72)*100,1))","v":-100},null,null,null,{"$f":"AD72+AL72","v":5772},null,{"$f":"IF(AN72=0,\"0.0 \",ROUND((AH72/AN72)*100,1))","v":-100}]
[]
[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(AD70:AD72)","v":5772},null,{"$f":"ROUND((AD74/AD$76)*100,1)","v":0.4},null,{"$f":"L33-AD74","v":-5772},null,{"$f":"IF(AD74=0,\"0.0 \",ROUND((AH74/AD74)*100,1))","v":-100},null,null,null,{"$f":"SUM(AN70:AN72)","v":5772},null,{"$f":"IF(AN74=0,\"0.0 \",ROUND((AH74/AN74)*100,1))","v":-100}]
[]
[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":"X68","v":264},null,{"$f":"Z68","v":1479992},null,null,null,{"$f":"AD68+AD74","v":1524248},null,{"$f":"ROUND((AD76/AD$76)*100,1)","v":100},null,{"$f":"AH68+AH74","v":123876},null,{"$f":"IF(AD76=0,\"0.0 \",ROUND((AH76/AD76)*100,1))","v":8.1},null,null,null,{"$f":"AN68+AN74","v":1524248},null,{"$f":"IF(AN76=0,\"0.0 \",ROUND((AH76/AN76)*100,1))","v":8.1}]

{"sheet":"SCH N","index":12,"n_rows":106,"n_cols":17,"rows_kept":106,"cut":false,"hidden":false,"merged":[[65,10,65,13],[65,5,65,8],[0,0,0,13],[3,0,3,13],[4,0,4,13]]}
[{"$f":"COMPANY","v":"DUKE ENERGY KENTUCKY"}]
[{"$f":"CASE","v":"CASE NO. 2018- 00261"}]
["EFFECTS OF PROPOSED RESIDENTIAL AND GENERAL SERVICE RATES"]
["TYPICAL BILL COMPARISON"]
[{"$f":"SERV_TYPE","v":"(GAS SERVICE)"}]
[]
[{"$f":"DATA_TYPE","v":"DATA: ___ BASE PERIOD   _X_FORECASTED PERIOD"},null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE N"]
[{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,"PAGE 1 OF 2"]
["WORK PAPER REFERENCE NO(S).: ",null,null,null,null,null,null,null,null,null,null,null,"WITNESS:"]
[{"$f":"TIME","v":"12 MONTHS FORECASTED"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"WIT","v":"B. L. Sailers"}]
[]
[]
[null,null,null,null,null," BILL DATA INCLUDING RIDERS LESS COST of GAS (1)(2)",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 (3)","(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+CUR_ASRP_RS,2)","v":21.22},{"$f":"ROUND(E20*(PRO_RS_COM+PRO_RS_DSM)+PRO_RS_CUST+PRO_RS_HEA+PRO_ASRP_RS,2)","v":22.07},{"$f":"G20-F20","v":0.85000000000000142},{"$f":"ROUND(H20/F20,3)*100","v":4},null,{"$f":"ROUND(E20*EGC,2)","v":4.01},{"$f":"F20+K20","v":25.229999999999997},{"$f":"G20+K20","v":26.08},{"$f":"ROUND((M20-L20)/L20,3)*100","v":3.4000000000000004}]
[3,null,null,"Applicable",3,27.87,{"$f":"ROUND(E21*(PRO_RS_COM+PRO_RS_DSM)+PRO_RS_CUST+PRO_RS_HEA+PRO_ASRP_RS,2)","v":31.01},3.1400000000000006,11.3,null,12.04,{"$f":"F21+K21","v":39.909999999999997},{"$f":"G21+K21","v":43.05},{"$f":"ROUND((M21-L21)/L21,3)*100","v":7.9}]
[4,null,null,null,6,37.840000000000003,44.42,6.5799999999999983,17.399999999999999,null,24.09,61.930000000000007,68.510000000000005,10.6]
[5,null,null,null,8,44.49,53.36,8.8699999999999974,19.900000000000002,null,32.11,76.599999999999994,85.47,11.600000000000001]
[6,null,null,null,10,51.13,62.3,11.169999999999995,21.8,null,40.14,91.27000000000001,102.44,12.2]
[7,null,null,null,12,57.78,71.239999999999995,13.459999999999994,23.3,null,48.17,105.95,119.41,12.7]
[8,null,null,null,16,71.069999999999993,89.12,18.050000000000011,25.4,null,64.23,135.30000000000001,153.35000000000002,13.3]
[9,null,null,null,20,84.37,107,22.629999999999995,26.8,null,80.290000000000006,164.66000000000003,187.29000000000002,13.700000000000001]
[10,null,null,null,30,117.6,151.69,34.090000000000003,28.999999999999996,null,120.43,238.03,272.12,14.299999999999999]
[11,null,null,null,40,150.84,196.39,45.549999999999983,30.2,null,160.57,311.40999999999997,356.96,14.6]
[12,null,null,null,50,184.07,241.09,57.02000000000001,31,null,200.72,384.78999999999996,441.81,14.799999999999999]
[13,null,null,null,60,217.3,285.79000000000002,68.490000000000009,31.5,null,240.86,458.16,526.65000000000009,14.899999999999999]
[14,null,null,null,80,283.77,375.18,91.410000000000025,32.200000000000003,null,321.14,604.91,696.31999999999994,15.1]
[15,null,null,null,100,350.24,464.58,114.33999999999997,32.6,null,401.43,751.67000000000007,866.01,15.2]
[]
[16,null,"(GS)"]
[17,null,"NON-RESIDENTIAL",null,5,{"$f":"ROUND(E36*(CUR_GS)+CUR_GS_CUST+CUR_ASRP_GS,2)","v":59.55},{"$f":"ROUND(E36*(+PRO_GS)+PRO_GS_CUST+PRO_ASRP_GS,2)","v":64.040000000000006},{"$f":"G36-F36","v":4.4900000000000091},{"$f":"ROUND(H36/F36,3)*100","v":7.5},null,{"$f":"ROUND(E36*EGC,2)","v":20.07},{"$f":"F36+K36","v":79.62},{"$f":"G36+K36","v":84.110000000000014},{"$f":"ROUND((M36-L36)/L36,3)*100","v":5.6000000000000005}]
[18,null,null,null,10,69.81,78.08,8.269999999999996,11.799999999999999,null,40.14,109.95,118.22,7.5]
[19,null,null,null,20,90.34,106.15,15.810000000000002,17.5,null,80.290000000000006,170.63,186.44,9.3000000000000007]
[20,null,null,null,40,131.4,162.31,30.909999999999997,23.5,null,160.57,291.97000000000003,322.88,10.6]
[21,null,null,null,50,151.93,190.39,38.45999999999998,25.3,null,200.72,352.65,391.11,10.9]
[22,null,null,null,100,254.58,330.77,76.189999999999969,29.9,null,401.43,656.01,732.2,11.600000000000001]
[23,null,null,null,300,665.18,892.31,227.13,34.1,null,1204.29,1869.4699999999998,2096.6,12.1]
[24,null,null,null,500,1075.78,1453.85,378.06999999999994,35.099999999999994,null,2007.15,3082.9300000000003,3461,12.3]
[25,null,null,null,700,1486.38,2015.39,529.01,35.6,null,2810.01,4296.3900000000003,4825.4000000000005,12.3]
[26,null,null,null,850,1794.33,2436.5500000000002,642.22000000000025,35.799999999999997,null,3412.16,5206.49,5848.71,12.3]
[27,null,null,null,1000,2102.2800000000002,2857.7,755.41999999999962,35.9,null,4014.3,6116.58,6872,12.4]
[28,null,null,null,2000,4155.28,5665.4,1510.12,36.299999999999997,null,8028.6,12183.880000000001,13694,12.4]
[29,null,null,null,3000,6208.28,8473.1,2264.8200000000006,36.5,null,12042.9,18251.18,20516,12.4]
[null,null,{"$f":"\"(1) INCLUDES RIDER DSM OF \"&TEXT(CUR_RS_DSM,\"$0.00000_);($0.00000)\")&\" /MCF AND HEA \"&TEXT(CUR_RS_HEA,\"$0.00\")&\" AND ASRP OF \"&TEXT(CUR_ASRP_RS,\"$0.00\")&\"  IN RATE RS.\"","v":"(1) INCLUDES RIDER DSM OF ($0.39792) /MCF AND HEA $0.10 AND ASRP OF $1.80  IN RATE RS."}]
[null,null,{"$f":"\"(2) INCLUDES RIDER DSM OF \"&TEXT(CUR_GS_DSM,\"$0.00000_);($0.00000)\")&\" /MCF AND ASRP OF \"&TEXT(CUR_ASRP_GS,\"$0.00\")&\"  IN RATE GS.\"","v":"(2) INCLUDES RIDER DSM OF $0.00000  /MCF AND ASRP OF $1.78  IN RATE GS."}]
[null,null,{"$f":"\"(3) REFLECTS AVERAGE EXPECTED GAS COST OF \"&TEXT(EGC,\"$0.000\")&\"/MCF.\"","v":"(3) REFLECTS AVERAGE EXPECTED GAS COST OF $4.014/MCF."}]
[]
[]
[{"$f":"COMPANY","v":"DUKE ENERGY KENTUCKY"}]
[{"$f":"CASE","v":"CASE NO. 2018- 00261"}]
["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,null,null,"SCHEDULE N"]
[{"$f":"FILING_TYPE","v":"TYPE OF FILING: _X_ ORIGINAL   ___UPDATED  ___ REVISED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PAGE 2 OF 2"]
["WORK PAPER REFERENCE NO(S).: ",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,{"$f":"WIT","v":"B. L. Sailers"}]
[]
[]
[null,null,null,null,null,"MONTHLY CUSTOMER CHARGE",null,null,null,null,"TRANSPORTATION COMMODITY CHARGE (1)(2)(3)"]
[null,null,null,null,null,null,null,"DOLLAR","PERCENT",null,null,null,"DOLLAR","PERCENT","TOTAL","TOTAL","PERCENT"]
[null,null,null,"LEVEL","MONTHLY","CURRENT","PROPOSED","INCREASE","INCREASE",null,"CURRENT","PROPOSED","INCREASE","INCREASE","CURRENT","PROPOSED","INCREASE"]
[null,null,null,"of","TRANSP","MONTHLY","MONTHLY","(DECREASE)","(DECREASE)",null,"COMMODITY","COMMODITY","(DECREASE)","(DECREASE)","BILL","BILL","(DECREASE)"]
["LINE",null,"RATE","DEMAND","VOLUME","CUST CHARGE","CUST CHARGE","(D - C)","(E / C)",null,"CHARGE","CHARGE","(H - G)","(I / G)","(C + G)","(D + H)","(L-K) / K"]
[" NO.",null,"CODE","(A)","(B)","(C)","(D)","(E)","(F)",null,"(G)","(H)","(I)","(J)","(K)","(L)","(M)"]
[null,null,null,null,"(MCF)","($)","($)","($)","(%)",null,"($)","($)","($)","(%)","($)","($)","(%)"]
[]
[1,null,"(FT-L)","Not"]
[2,null,"FIRM","Applicable",1000,{"$f":"CUR_FTL_CUST","v":430},{"$f":"+PRO_FTL_CUST","v":430},{"$f":"G75-F75","v":0},{"$f":"IF(F75=0,\"0.0 \",ROUND(H75/F75,3)*100)","v":0},null,{"$f":"ROUND(E75*(CUR_ASRP_FTL+CUR_FTL_COM+CUR_FTL_GCAT),2)","v":1741.4},{"$f":"ROUND(E75*(PRO_ASRP_FTL+PRO_FTL_COM+PRO_FTL_GCAT),2)","v":2331.9},{"$f":"L75-K75","v":590.5},{"$f":"ROUND(M75/K75,3)*100","v":33.900000000000006},{"$f":"F75+K75","v":2171.4},{"$f":"G75+L75","v":2761.9},{"$f":"IF(P75=0,\"0.0 \",ROUND((P75-O75)/O75,3)*100)","v":27.200000000000003}]
[3,null,"TRANSPORTATION",null,1500,{"$f":"F75","v":430},{"$f":"G75","v":430},0,0,null,2612.1,3497.85,885.75,33.900000000000006,{"$f":"F76+K76","v":3042.1},{"$f":"G76+L76","v":3927.85},29.099999999999998]
[4,null,null,null,2000,{"$f":"F75","v":430},{"$f":"G75","v":430},0,0,null,3482.8,4663.8,1181,33.900000000000006,{"$f":"F77+K77","v":3912.8},{"$f":"G77+L77","v":5093.8},30.2]
[5,null,null,null,3000,{"$f":"F75","v":430},{"$f":"G75","v":430},0,0,null,5224.2,6995.7,1771.5,33.900000000000006,5654.2,7425.7,31.3]
[6,null,null,null,5000,{"$f":"F75","v":430},{"$f":"G75","v":430},0,0,null,8707,11659.5,2952.5,33.900000000000006,9137,12089.5,32.300000000000004]
[7,null,null,null,10000,{"$f":"F75","v":430},{"$f":"G75","v":430},0,0,null,17414,23319,5905,33.900000000000006,17844,23749,33.1]
[8,null,null,null,20000,{"$f":"F75","v":430},{"$f":"G75","v":430},0,0,null,34828,46638,11810,33.900000000000006,35258,47068,33.5]
[9,null,null,null,30000,{"$f":"F75","v":430},{"$f":"G75","v":430},0,0,null,52242,69957,17715,33.900000000000006,52672,70387,33.6]
[10,null,null,null,40000,{"$f":"F75","v":430},{"$f":"G75","v":430},0,0,null,69656,93276,23620,33.900000000000006,70086,93706,33.700000000000003]
[11,null,null,null,50000,{"$f":"F75","v":430},{"$f":"G75","v":430},0,0,null,87070,116595,29525,33.900000000000006,87500,117025,33.700000000000003]
[12,null,null,null,75000,{"$f":"F75","v":430},{"$f":"G75","v":430},0,0,null,130605,174892.5,44287.5,33.900000000000006,131035,175322.5,33.800000000000004]
[13,null,null,null,100000,{"$f":"F75","v":430},{"$f":"G75","v":430},0,0,null,174140,233190,59050,33.900000000000006,174570,233620,33.800000000000004]
[14,null,null,null,150000,{"$f":"F75","v":430},{"$f":"G75","v":430},0,0,null,261210,349785,88575,33.900000000000006,261640,350215,33.900000000000006]
[15,null,null,null,200000,{"$f":"F75","v":430},{"$f":"G75","v":430},0,0,null,348280,466380,118100,33.900000000000006,348710,466810,33.900000000000006]
[]
[16,null,"(IT)","Not"]
[17,null,"INTERRUPTIBLE","Applicable",2000,{"$f":"CUR_IT_CUST","v":430},{"$f":"+PRO_IT_CUST","v":430},{"$f":"G91-F91","v":0},{"$f":"IF(F91=0,\"0.0 \",ROUND(H91/F91,3)*100)","v":0},null,{"$f":"ROUND(E91*(CUR_ASRP_IT+CUR_IT_COM),2)","v":1906.4},{"$f":"ROUND(E91*(PRO_ASRP_IT+PRO_IT_COM),2)","v":2073.8000000000002},{"$f":"L91-K91","v":167.40000000000009},{"$f":"ROUND(M91/K91,3)*100","v":8.7999999999999989},{"$f":"F91+K91","v":2336.4},{"$f":"G91+L91","v":2503.8000000000002},{"$f":"ROUND((P91-O91)/O91,3)*100","v":7.1999999999999993}]
[18,null,"TRANSPORTATION",null,5000,{"$f":"F91","v":430},{"$f":"G91","v":430},0,{"$f":"IF(F92=0,\"0.0 \",ROUND(H92/F92,3)*100)","v":0},null,4766,5184.5,418.5,8.7999999999999989,{"$f":"F92+K92","v":5196},{"$f":"G92+L92","v":5614.5},8.1]
[19,null,null,null,10000,{"$f":"F91","v":430},{"$f":"G91","v":430},0,0,null,9532,10369,837,8.7999999999999989,9962,10799,8.4]
[20,null,null,null,15000,{"$f":"F91","v":430},{"$f":"G91","v":430},0,0,null,14298,15553.5,1255.5,8.7999999999999989,14728,15983.5,8.5]
[21,null,null,null,20000,{"$f":"F91","v":430},{"$f":"G91","v":430},0,0,null,19064,20738,1674,8.7999999999999989,19494,21168,8.6]
[22,null,null,null,25000,{"$f":"F91","v":430},{"$f":"G91","v":430},0,0,null,23830,25922.5,2092.5,8.7999999999999989,24260,26352.5,8.6]
[23,null,null,null,30000,{"$f":"F91","v":430},{"$f":"G91","v":430},0,0,null,28596,31107,2511,8.7999999999999989,29026,31537,8.6999999999999993]
[24,null,null,null,40000,{"$f":"F91","v":430},{"$f":"G91","v":430},0,0,null,38128,41476,3348,8.7999999999999989,38558,41906,8.6999999999999993]
[25,null,null,null,50000,{"$f":"F91","v":430},{"$f":"G91","v":430},0,0,null,47660,51845,4185,8.7999999999999989,48090,52275,8.6999999999999993]
[26,null,null,null,100000,{"$f":"F91","v":430},{"$f":"G91","v":430},0,0,null,95320,103690,8370,8.7999999999999989,95750,104120,8.6999999999999993]
[27,null,null,null,200000,{"$f":"F91","v":430},{"$f":"G91","v":430},0,0,null,190640,207380,16740,8.7999999999999989,191070,207810,8.7999999999999989]
[28,null,null,null,300000,{"$f":"F91","v":430},{"$f":"G91","v":430},0,0,null,285960,311070,25110,8.7999999999999989,286390,311500,8.7999999999999989]
[]
[null,null,{"$f":"\"(1) INCLUDES CURRENT RIDER GCAT OF \"&TEXT(CUR_FTL_GCAT,\"$0.000_);($0.000)\")&\"/MCF  AND PROPOSED RIDER CGAT OF  \"&TEXT(PRO_FTL_GCAT,\"$0.000_);($0.000)\")     &\"/MCF IN RATE FT-L.\"","v":"(1) INCLUDES CURRENT RIDER GCAT OF $0.000 /MCF  AND PROPOSED RIDER CGAT OF  $0.000 /MCF IN RATE FT-L."}]
[null,null,{"$f":"\"(2) INCLUDES CURRENT RIDER ASRP OF \"&TEXT(CUR_ASRP_FTL,\"$0.0000_);($0.0000)\")&\"/MCF  AND PROPOSED RIDER ASRP OF  \"&TEXT(PRO_ASRP_FTL,\"$0.0000_);($0.0000)\")     &\"/MCF IN RATE FT-L.\"","v":"(2) INCLUDES CURRENT RIDER ASRP OF $0.0045 /MCF  AND PROPOSED RIDER ASRP OF  $0.0000 /MCF IN RATE FT-L."}]
[null,null,{"$f":"\"(3) INCLUDES CURRENT RIDER ASRP OF \"&TEXT(CUR_ASRP_IT,\"$0.0000_);($0.0000)\")&\"/MCF  AND PROPOSED RIDER ASRP OF  \"&TEXT(PRO_ASRP_IT,\"$0.0000_);($0.0000)\")     &\"/MCF IN RATE IT.\"","v":"(3) INCLUDES CURRENT RIDER ASRP OF $0.0039 /MCF  AND PROPOSED RIDER ASRP OF  $0.0000 /MCF IN RATE IT."}]

{"sheet":"Revenue Requirements","index":13,"n_rows":29,"n_cols":14,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["REVENUE REQUIREMENTS FROM COST OF SERVICE STUDY"]
[]
[null,{"$f":"COMPANY","v":"DUKE ENERGY KENTUCKY"},null,null,null,null,{"$f":"B3","v":"DUKE ENERGY KENTUCKY"}]
[null,{"$f":"CASE","v":"CASE NO. 2018- 00261"},null,null,null,null,{"$f":"B4","v":"CASE NO. 2018- 00261"},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. 2018- 00261"}]
[null,null,null,null,null,null,{"$f":"B4","v":"CASE NO. 2018- 00261"}]
[]
[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'!X67","v":1110274},{"$f":"'Rate RS'!AN83-'Rate RS'!AN75-'Rate RS'!AN76","v":65522695},null,null,{"$f":"B10","v":"RS"},27323239,71971144,{"$f":"(I10-D10)/D10","v":9.8415503208468452E-2},{"$f":"I10-D10","v":6448449},null,{"$f":"G10","v":"RS"},{"$f":"'Proposed Rates'!C21","v":-21}]
[null,"GS",{"$f":"'Rate GS COM'!F24+'Rate GS IND'!F24+'Rate GS OPA'!F24","v":85245},{"$f":"'Rate GS COM'!AN81+'Rate GS IND'!AN86+'Rate GS OPA'!AN83","v":23198247},null,null,{"$f":"B11","v":"GS"},4349513,25622644,{"$f":"(I11-D11)/D11","v":0.10450776733259198},{"$f":"I11-D11","v":2424397},null,{"$f":"G11","v":"GS"},{"$f":"'Rate GS COM'!R29+'Rate GS IND'!R29+'Rate GS OPA'!R29-'Revenue Requirements'!I11","v":25}]
[]
[]
[null,"FT-Large",{"$f":"'Rate FT-LG'!F22","v":1128},{"$f":"'Rate FT-LG'!AN75","v":5042683},null,null,"FT-Large",234315,6588125,0.30647216967634094,1545442,null,"FT-Large",{"$f":"'Proposed Rates'!K21","v":31}]
[null,"IT",{"$f":"'Rate IT'!F22","v":264},{"$f":"'Rate IT'!AN76","v":1524248},null,null,"IT",130843,1648179,8.1306322855598301E-2,123931,null,"IT",{"$f":"'Proposed Rates'!O21","v":-55}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(N10:N15)","v":-20}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"SUM",{"$f":"SUM(N10:N23)","v":-40}]
[]
[]
[null,"OTHER",null,{"$f":"'SCH M-2.2'!V46","v":94257},null,null,"OTHER",null,{"$f":"D28","v":94257},{"$f":"(I28-D28)/D28","v":0}]
[null,"TOTAL",{"$f":"SUM(C10:C28)","v":1196911},{"$f":"SUM(D10:D28)","v":95382130},null,null,"TOTAL",{"$f":"SUM(H10:H28)","v":32037910},{"$f":"SUM(I10:I28)","v":105924349},{"$f":"(I29-D29)/D29","v":0.11052614362879085},{"$f":"I29-D29","v":10542219}]

{"sheet":"Proposed Rates","index":14,"n_rows":29,"n_cols":15,"rows_kept":29,"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. 2018- 00261"},null,null,null,{"$f":"CASE","v":"CASE NO. 2018- 00261"},null,null,null,{"$f":"CASE","v":"CASE NO. 2018- 00261"},null,null,null,{"$f":"CASE","v":"CASE NO. 2018- 00261"}]
[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":1110274},null,null,"Customer Bills",{"$f":"'Rate GS COM'!F24+'Rate GS IND'!F24+'Rate GS OPA'!F24","v":85245},null,null,"Customer Bills",{"$f":"'Rate FT-LG'!F22","v":1128},null,null,"Customer Bills",{"$f":"'Rate IT'!F22","v":264}]
[null,"COSS - RS Customer Component",{"$f":"'Revenue Requirements'!H10","v":27323239},null,null,"COSS - GS Customer Component",{"$f":"'Revenue Requirements'!H11+'Revenue Requirements'!H12+'Revenue Requirements'!H13","v":4349513},null,null,"COSS - FT-L Customer Component",{"$f":"'Revenue Requirements'!H14","v":234315},null,null,"COSS - IT Customer Component",{"$f":"'Revenue Requirements'!H15","v":130843}]
[null,"COSS Customer Charge",{"$f":"ROUND(C8/C7,2)","v":24.61},null,null,"COSS Customer Charge",{"$f":"ROUND(G8/G7,2)","v":51.02},null,null,"COSS Customer Charge",{"$f":"ROUND(K8/K7,2)","v":207.73},null,null,"COSS Customer Charge",{"$f":"ROUND(O8/O7,2)","v":495.62}]
[null,"Current Customer Charge",{"$f":"CUR_RS_CUST","v":16},null,null,"Current Customer Charge",{"$f":"CUR_GS_CUST","v":47.5},null,null,"Current Customer Charge",{"$f":"CUR_FTL_CUST","v":430},null,null,"Current Customer Charge",{"$f":"CUR_IT_CUST","v":430}]
[null,"Gap",{"$f":"C9-C10","v":8.61},null,null,"Gap",{"$f":"G9-G10","v":3.5200000000000031},null,null,"Gap",{"$f":"K9-K10","v":-222.27},null,null,"Gap",{"$f":"O9-O10","v":65.62}]
[null,"Migration @ % of Justified",{"$f":"ROUND(C11*$C$29,2)","v":4.3099999999999996},null,null,"Migration @ % of Justified",{"$f":"ROUND(G11*$C$29,2)","v":1.76},null,null,"Migration @ % of Justified",{"$f":"ROUND(K11*$C$29,2)","v":-111.14},null,null,"Migration @ % of Justified",{"$f":"ROUND(O11*$C$29,2)","v":32.81}]
[null,"Customer Charge at % Migration to COSS",{"$f":"C10+C12","v":20.309999999999999},null,null,"Customer Charge at % Migration to COSS",{"$f":"G10+G12","v":49.26},null,null,"Customer Charge at % Migration to COSS",{"$f":"K10+K12","v":318.86},null,null,"Customer Charge at % Migration to COSS",{"$f":"O10+O12","v":462.81}]
[null,"Proposed Customer Charge",17.5,null,null,"Proposed Customer Charge",50,null,null,"Proposed Customer Charge",430,null,null,"Proposed Customer Charge",430]
[null,"Proposed Customer Charge Revenues",{"$f":"'Rate RS'!R24","v":19429795},null,null,"Proposed Customer Charge Revenues",{"$f":"'Rate GS COM'!R24+'Rate GS IND'!R24+'Rate GS OPA'!R24","v":4262250},null,null,"Proposed Customer Charge Revenues",{"$f":"'Rate FT-LG'!R22","v":485040},null,null,"Proposed Customer Charge Revenues",{"$f":"'Rate IT'!R22","v":113520}]
[]
[null,"COSS - RS Revenue Requirement",{"$f":"'Revenue Requirements'!I10","v":71971144},null,null,"COSS - GS Revenue Requirement",{"$f":"SUM('Revenue Requirements'!I11:I13)","v":25622644},null,null,"COSS - FT-L Revenue Requirement",{"$f":"'Revenue Requirements'!I14","v":6588125},null,null,"COSS - IT Revenue Requirement",{"$f":"'Revenue Requirements'!I15","v":1648179}]
[null,"Less Proposed Customer Charge Revenues Less GCA",{"$f":"C17-C15-'Rate RS'!P29","v":28794822},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":8791186},null,null,"Less Proposed Customer Charge Revenues Less GCA/GCAT",{"$f":"K17-K15-'Rate FT-LG'!P25-'Rate FT-LG'!R32","v":6103085},null,null,"Less Proposed Customer Charge Revenues Less GCA",{"$f":"O17-O15-'Rate IT'!P25","v":1534659}]
[null,"Test Period MCF",{"$f":"'Rate RS'!H27","v":5915484},null,null,"Test Period MCF",{"$f":"'Rate GS COM'!H27+'Rate GS IND'!H27+'Rate GS OPA'!H27","v":3131108},null,null,"Test Period MCF",{"$f":"'Rate FT-LG'!H25","v":2617229},null,null,"Test Period MCF",{"$f":"'Rate IT'!H25","v":1479992}]
[null,"Proposed Delivery Charge",{"$f":"ROUND(C18/C19,4)+0","v":4.8677000000000001},null,null,"Proposed Energy Charge",{"$f":"ROUND(G18/G19,4)+0","v":2.8077000000000001},null,null,"Proposed Energy Charge",{"$f":"ROUND(K18/K19,4)-0","v":2.3319000000000001},null,null,"Proposed Energy Charge",{"$f":"ROUND(O18/O19,4)-0","v":1.0368999999999999}]
[null,"Check to Revenue Requirements",{"$f":"'Rate RS'!R29-C17","v":-21},null,null,"Check to Revenue Requirements",{"$f":"'Rate GS COM'!R29+'Rate GS IND'!R29+'Rate GS OPA'!R29-G17","v":25},null,null,"Check to Revenue Requirements",{"$f":"'Rate FT-LG'!R36-K17","v":31},null,null,"Check to Revenue Requirements",{"$f":"'Rate IT'!R27-O17","v":-55}]
[]
[]
[]
[]
[]
[]
[]
[null,"Migration Percentage",0.5]

{"sheet":"ABI","index":15,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
["Average Bill Increase Amounts for Newspaper Notice"]
[null,null,null,null,null,"Revenue Increases"]
[null,"Average Bill Increase",null,"Average MCF",null,"COSS","Sch M","Sch M %","COSS % Increase"]
["Tariff Description","$","%"]
[{"$f":"'Revenue Requirements'!B10","v":"RS"},5.78,10.199999999999999,{"$f":"ROUND('Rate RS'!H27/'Rate RS'!F24,1)","v":5.3}]
[{"$f":"'Revenue Requirements'!B11","v":"GS"},28.41,10.4,{"$f":"ROUND(('Rate GS COM'!H27+'Rate GS OPA'!H27+'Rate GS IND'!H27)/('Rate GS COM'!F24+'Rate GS OPA'!F24+'Rate GS IND'!F24),1)","v":36.700000000000003},null,{"$f":"'Revenue Requirements'!K11","v":2424397}]
["GS - Commercial",26.08,10.3,{"$f":"ROUND(('Rate GS COM'!H27)/('Rate GS COM'!F24),1)","v":33.6},null,{"$f":"F6-F8-F9","v":2041693},{"$f":"'Rate GS COM'!AH81","v":2041714},{"$f":"G7/SUM($G$7:$G$9)","v":0.8421446431355597},{"$f":"F7/'Rate GS COM'!AN81","v":0.1030258685788694}]
["GS - OPA",56.04,11.3,{"$f":"ROUND(('Rate GS OPA'!H27)/('Rate GS OPA'!F24),1)","v":73.3},null,{"$f":"ROUND(H8*$F$6,0)","v":251299},{"$f":"'Rate GS OPA'!AH83","v":251302},{"$f":"G8/SUM($G$7:$G$9)","v":0.10365439680055701},{"$f":"F8/'Rate GS OPA'!AN83","v":0.11344077672707838}]
["GS - Industrial",52.27,11.3,{"$f":"ROUND(('Rate GS IND'!H27)/('Rate GS IND'!F24),1)","v":68.3},null,{"$f":"ROUND(H9*$F$6,0)","v":131405},{"$f":"'Rate GS IND'!AH86","v":131406},5.4200960063883266E-2,{"$f":"F9/'Rate GS IND'!AN86","v":0.11272451827972117}]
[{"$f":"'Revenue Requirements'!B14","v":"FT-Large"},1370.07,30.6,{"$f":"ROUND('Rate FT-LG'!H25/'Rate FT-LG'!F22,1)","v":2320.1999999999998}]
[{"$f":"'Revenue Requirements'!B15","v":"IT"},469.22,8.1,{"$f":"ROUND('Rate IT'!H25/'Rate IT'!F22,1)","v":5606}]