{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["BA Sept 2022","PBRA 2021-00184","BA 2022-00026 ","ACA 2021-00184"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"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":"BA Sept 2022","index":0,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,0,4],[2,0,2,4],[3,0,3,4],[4,0,4,4]]}
["COLUMBIA GAS OF KENTUCKY, INC."]
[]
["CALCULATION OF BALANCING ADJUSTMENT"]
["TO BE EFFECTIVE UNIT 1 SEPTEMBER THROUGH UNIT 21 NOVEMBER"]
["(AUGUST 29, 2022 - NOVEMBER 28, 2022)"]
["Line"]
["No.",null,"Description","Detail","Amount"]
[null,null,null,"$","$"]
[]
[1,null,"RECONCILIATION OF PREVIOUS PERFORMANCE BASED RATE ADJUSTMENT"]
[{"$f":"+A10+1","v":2},null,"Total adjustment to have been collected from"]
[{"$f":"+A11+1","v":3},null,"     customers in Case No. 2021-00184",{"$f":"'PBRA 2021-00184'!F9","v":1749098.54}]
[{"$f":"+A12+1","v":4},null,"Less: actual amount distributed",{"$f":"'PBRA 2021-00184'!C29","v":1721372.2130249999}]
[]
[{"$f":"+A13+1","v":5},null,"REMAINING AMOUNT",null,{"$f":"D12-D13","v":27726.326975000091}]
[]
[{"$f":"+A15+1","v":6},null,"RECONCILIATION OF A PREVIOUS BALANCING ADJUSTMENT "]
[{"$f":"+A17+1","v":7},null,"Total adjustment to have been collected from"]
[{"$f":"+A18+1","v":8},null,"     customers in Case No. 2022-00026",{"$f":"'BA 2022-00026 '!C19","v":720.6400000000001}]
[{"$f":"+A19+1","v":9},null,"Less: actual amount collected",{"$f":"'BA 2022-00026 '!C21","v":945.91}]
[]
[{"$f":"+A20+1","v":10},null,"REMAINING AMOUNT ",null,{"$f":"D19-D20","v":-225.26999999999987}]
[]
[{"$f":"+A22+1","v":11},null,"RECONCILIATION OF PREVIOUS ACTUAL COST ADJUSTMENT "]
[{"$f":"+A24+1","v":12},null,"Total adjustment to have been distributed to"]
[{"$f":"+A25+1","v":13},null,"     customers in Case No. 2021-000184",{"$f":"'ACA 2021-00184'!J10","v":-1768327.3200000033}]
[{"$f":"+A26+1","v":14},null,"Less: actual amount distributed",{"$f":"'ACA 2021-00184'!D30","v":-1718651.1300000001}]
[]
[{"$f":"+A27+1","v":15},null,"REMAINING AMOUNT",null,{"$f":"+D26-D27","v":-49676.190000003204}]
[]
[{"$f":"+A29+1","v":16},null,"TOTAL BALANCING ADJUSTMENT AMOUNT",null,{"$f":"SUM(E9:E30)","v":-22175.133025003113}]
[]
[{"$f":"+A31+1","v":17},null,"Divided by:  projected sales volumes for the three months"]
[{"$f":"+A33+1","v":18},null,"     ended November 30, 2022",null,1908442.2007266122]
[]
[{"$f":"+A34+1","v":19}]
[{"$f":"+A36+1","v":20},null,"BALANCING ADJUSTMENT (BA) ",null,{"$f":"E31/E34","v":-1.1619494169936217E-2}]

{"sheet":"PBRA 2021-00184","index":1,"n_rows":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[2,0,2,5]]}
["Columbia Gas of Kentucky, Inc."]
["PBR Incentive Adjustment"]
["Supporting Data"]
[]
["Case No. 2021-00184"]
[]
["Expires May 31, 2022",null,null,"Surcharge","Surcharge","Surcharge"]
[null,null,"Volume","Rate","Amount","Balance"]
[null,null,null,null,null,1749098.54]
["2021-06-30",null,298812.2,0.1555,{"$f":"ROUND(C10*D10,2)","v":46465.3},{"$f":"F9-E10","v":1702633.24}]
["2021-07-30",null,216994.39999999997,{"$f":"D10","v":0.1555},{"$f":"+C11*D11","v":33742.629199999996},{"$f":"F10-E11","v":1668890.6107999999}]
["2021-08-29",null,201718.99999999997,0.1555,{"$f":"+C12*D12","v":31367.304499999995},1637523.3062999998]
["2021-09-28",null,208289.3,0.1555,{"$f":"+C13*D13","v":32388.986149999997},1605134.3201499998]
["2021-10-28",null,249615.80000000005,0.1555,{"$f":"+C14*D14","v":38815.256900000008},1566319.0632499999]
["2021-11-27",null,691474.2,0.1555,107524.23809999999,1458794.8251499999]
["2021-12-27",null,1563568.3999999997,0.1555,243134.88619999995,1215659.9389499999]
["2022-01-26",null,1895123.0999999996,0.1555,294691.64204999997,920968.29689999996]
["2022-02-25",null,2600917.5000000005,0.1555,404442.67125000007,516525.62564999989]
["2022-03-27",null,1505655.15,0.1555,234129.375825,282396.24982499989]
["2022-04-26",null,1131489.3999999999,0.1555,175946.6017,106449.64812499989]
["2022-05-26",null,504504.20000000019,0.1555,78450.403100000025,27999.245024999866]
["2022-06-25",null,1755.0999999999767,0.1555,272.91804999999636,27726.326974999869]
[]
[null,null,null,null,{"$f":"SUM(E10:E22)","v":1721372.2130249999}]
[]
["SUMMARY:"]
["SURCHARGE AMOUNT",null,{"$f":"F9","v":1749098.54}]
[]
["AMOUNT  COLLECTED",null,{"$f":"E24","v":1721372.2130249999}]
[]
["TOTAL REMAINING TO BE"]
["COLLECTED",null,{"$f":"C27-C29","v":27726.326975000091}]

{"sheet":"BA 2022-00026 ","index":2,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[2,0,2,5]]}
["Columbia Gas of Kentucky, Inc."]
["Balancing Adjustment"]
["Supporting Data"]
[]
["Case No. 2022-00026"]
[]
["Expires: May 31, 2022",null,null,"Surcharge","Surcharge","Surcharge"]
[null,null,"Volume","Rate","Amount","Balance"]
["Beginning Balance",null,null,null,null,720.6400000000001]
["2022-03-01",null,1515253.85,2.9999999999999997E-4,{"$f":"ROUND(C10*D10,2)","v":454.58},{"$f":"F9-E10","v":266.06000000000012}]
["2022-04-01",null,1131489.3999999999,{"$f":"D10","v":2.9999999999999997E-4},{"$f":"ROUND(C11*D11,2)","v":339.45},{"$f":"F10-E11","v":-73.389999999999873}]
["2022-05-01",null,504504.20000000019,{"$f":"D11","v":2.9999999999999997E-4},{"$f":"ROUND(C12*D12,2)","v":151.35},{"$f":"F11-E12","v":-224.73999999999987}]
["2022-06-01",null,1755.0999999999767,{"$f":"D12","v":2.9999999999999997E-4},{"$f":"ROUND(C13*D13,2)","v":0.53},{"$f":"F12-E13","v":-225.26999999999987}]
[]
["TOTAL SURCHARGE COLLECTED",null,null,null,null," "]
[]
[]
["SUMMARY:"]
["SURCHARGE AMOUNT",null,{"$f":"+F9","v":720.6400000000001}]
[]
["AMOUNT COLLECTED",null,{"$f":"SUM(E10:E13)","v":945.91}]
[]
["REMAINING BALANCE",null,{"$f":"C19-C21","v":-225.26999999999987}]

{"sheet":"ACA 2021-00184","index":3,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,0,0,9],[6,2,6,4],[6,6,6,8],[2,0,2,9],[1,0,1,9]]}
["Columbia Gas of Kentucky, Inc."]
["Actual Cost Adjustment YR2021 QTR1"]
["Supporting Data"]
[]
[]
["Case No. 2021-00184"]
[null,null,"Tariff",null,null,null,"Choice"]
["Expires: June 30, 2022",null,null,"Refund","Refund",null,null,"Refund","Refund","Refund"]
[null,null,"Volume","Rate","Amount",null,"Volume","Rate","Amount","Balance"]
[null,null,null,null,null,null,null,null,null,-1768327.3200000033]
["2021-06-01",null,296607.8,-0.15709999999999999,{"$f":"ROUND(C11*D11,2)","v":-46597.09},null,2204.4,0.33889999999999998,{"$f":"ROUND(G11*H11,2)","v":747.07},{"$f":"J10-E11-I11","v":-1722477.3000000033}]
["2021-07-01",null,212696.39999999997,{"$f":"D11","v":-0.15709999999999999},{"$f":"ROUND(C12*D12,2)","v":-33414.6},null,4298,{"$f":"H11","v":0.33889999999999998},{"$f":"ROUND(G12*H12,2)","v":1456.59},{"$f":"J11-E12-I12","v":-1690519.2900000033}]
["2021-08-01",null,199442.39999999994,-0.15709999999999999,-31332.400000000001,null,2276.6,0.33889999999999998,771.54,{"$f":"J12-E13-I13","v":-1659958.4300000034}]
["2021-09-01",null,205719.00000000003,-0.15709999999999999,-32318.45,null,2570.2999999999997,0.33889999999999998,871.07,{"$f":"J13-E14-I14","v":-1628511.0500000035}]
["2021-10-01",null,247470.2,-0.15709999999999999,-38877.57,null,2145.5999999999995,0.33889999999999998,727.14,-1590360.6200000034]
["2021-11-01",null,688940.8,-0.15709999999999999,-108232.6,null,2533.4,0.33889999999999998,858.57,-1482986.5900000033]
["2021-12-01",null,1558833.2999999998,-0.15709999999999999,-244892.71,null,4735.1000000000004,0.33889999999999998,1604.73,-1239698.6100000034]
["2022-01-01",null,1890710.4,-0.15709999999999999,-297030.59999999998,null,4412.6999999999989,0.33889999999999998,1495.46,-944163.47000000335]
["2022-02-01",null,2594836.0999999996,-0.15709999999999999,-407648.75,null,6081.4000000000005,0.33889999999999998,2060.9899999999998,-538575.71000000334]
["2022-03-01",null,1501357.7000000002,-0.15709999999999999,-235863.29,null,4297.45,0.33889999999999998,1456.41,-304168.83000000328]
["2022-04-01",null,1128387.3999999997,-0.15709999999999999,-177269.66,null,3102.0000000000005,0.33889999999999998,1051.27,-127950.44000000328]
["2022-05-01",null,501989.70000000019,-0.15709999999999999,-78862.58,null,2514.5,0.33889999999999998,852.16,-49940.020000003278]
["2022-06-01",null,1731.0999999999767,-0.15709999999999999,-271.95999999999998,null,24,0.33889999999999998,8.1300000000000008,-49676.190000003277]
[null,null," "]
[]
[]
["SUMMARY:"]
["REFUND AMOUNT",null,null,{"$f":"J10","v":-1768327.3200000033},null,null,null,null,null," "]
["LESS"]
["AMOUNT REFUNDED",null,null,{"$f":"SUM(E11:E23,I11:I23)","v":-1718651.1300000001}]
[]
[]
["TOTAL REMAINING REFUND",null,null,{"$f":"D28-D30","v":-49676.190000003204}]