{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["BA Sept 2023","RA 2022-00127","PBRA 2022-00127","BA 2023-00028","ACA 2022-00127"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"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 2023","index":0,"n_rows":45,"n_cols":5,"rows_kept":45,"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 AUGUST"]
["(AUGUST 29, 2023 - AUGUST 27, 2024)"]
[]
["Line"]
["No.",null,"Description","Detail","Amount"]
[null,null,null,"$","$"]
[]
[1,null,"RECONCILIATION OF RATE REFUND ADJUSTMENT"]
[{"$f":"+A11+1","v":2},null,"Total adjustment to have been distributed to"]
[{"$f":"+A12+1","v":3},null,"     customers in Case No. 2022-00127",{"$f":"'RA 2022-00127'!F9","v":-5760689.3099999996}]
[{"$f":"+A13+1","v":4},null,"Less: actual amount distributed",{"$f":"'RA 2022-00127'!C29","v":-3634662.3272800003}]
[]
[{"$f":"+A14+1","v":5},null,"REMAINING AMOUNT",null,{"$f":"D13-D14","v":-2126026.9827199993}]
[]
[{"$f":"A16+1","v":6},null,"RECONCILIATION OF PREVIOUS PERFORMANCE BASED RATE ADJUSTMENT"]
[{"$f":"+A18+1","v":7},null,"Total adjustment to have been collected from"]
[{"$f":"+A19+1","v":8},null,"     customers in Case No. 2022-00127",{"$f":"'PBRA 2022-00127'!F9","v":3763655.45}]
[{"$f":"+A20+1","v":9},null,"Less: actual amount distributed",{"$f":"'PBRA 2022-00127'!C29","v":3457651.5228719995}]
[]
[{"$f":"+A21+1","v":10},null,"REMAINING AMOUNT",null,{"$f":"D20-D21","v":306003.92712800065}]
[]
[{"$f":"+A23+1","v":11},null,"RECONCILIATION OF A PREVIOUS BALANCING ADJUSTMENT "]
[{"$f":"+A25+1","v":12},null,"Total adjustment to have been collected from"]
[{"$f":"+A26+1","v":13},null,"     customers in Case No. 2023-00028",{"$f":"'BA 2023-00028'!C19","v":43126.659999999996}]
[{"$f":"+A27+1","v":14},null,"Less: actual amount collected",{"$f":"'BA 2023-00028'!C21","v":48271.869999999995}]
[]
[{"$f":"+A28+1","v":15},null,"REMAINING AMOUNT ",null,{"$f":"D27-D28","v":-5145.2099999999991}]
[]
[{"$f":"+A30+1","v":16},null,"RECONCILIATION OF PREVIOUS ACTUAL COST ADJUSTMENT "]
[{"$f":"+A32+1","v":17},null,"Total adjustment to have been collected from"]
[{"$f":"+A33+1","v":18},null,"     customers in Case No. 2022-00127",{"$f":"'ACA 2022-00127'!J10","v":-6150275.0399999982}]
[{"$f":"+A34+1","v":19},null,"Less: actual amount collected",{"$f":"'ACA 2022-00127'!D30","v":-5637193.5199999986}]
[]
[{"$f":"+A35+1","v":20},null,"REMAINING AMOUNT",null,{"$f":"+D34-D35","v":-513081.51999999955}]
[]
[{"$f":"+A37+1","v":21},null,"TOTAL BALANCING ADJUSTMENT AMOUNT",null,{"$f":"SUM(E11:E38)","v":-2338249.7855919981}]
[]
[{"$f":"+A39+1","v":22},null,"Divided by:  projected sales volumes for the three months"]
[{"$f":"+A41+1","v":23},null,"     ended November 30, 2023",null,2172151.2252497729]
[]
[]
[{"$f":"A42+1","v":24},null,"BALANCING ADJUSTMENT (BA) ",null,{"$f":"E39/E42","v":-1.0764673096474329}]

{"sheet":"RA 2022-00127","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."]
["Rate Refund Adjustment"]
["Supporting Data"]
[]
["Case No. 2022-00127"]
[]
["Expires Unit 21 May 30, 2023",null,null,"Surcharge","Surcharge","Surcharge"]
[null,null,"Volume","Rate","Amount","Balance"]
[null,null,null,null,null,-5760689.3099999996]
["2022-06-30",null,259141.20000000004,-0.34910000000000002,{"$f":"ROUND(C10*D10,2)","v":-90466.19},{"$f":"F9-E10","v":-5670223.1199999992}]
[{"$f":"A10+30","v":"2022-07-30"},null,198995,{"$f":"D10","v":-0.34910000000000002},{"$f":"+C11*D11","v":-69469.154500000004},{"$f":"F10-E11","v":-5600753.965499999}]
[{"$f":"A11+30","v":"2022-08-29"},null,216544.59999999998,-0.34910000000000002,{"$f":"+C12*D12","v":-75595.719859999997},-5525158.2456399994]
["2022-09-28",null,209783.90000000002,-0.34910000000000002,{"$f":"+C13*D13","v":-73235.559490000014},-5451922.6861499995]
["2022-10-28",null,383342.09999999992,-0.34910000000000002,{"$f":"+C14*D14","v":-133824.72710999998},-5318097.9590399992]
["2022-11-27",null,746971.79999999981,-0.34910000000000002,-260767.85537999996,-5057330.1036599996]
["2022-12-27",null,1663764.5,-0.34910000000000002,-580820.18695,-4476509.9167099996]
["2023-01-26",null,2154566.7999999998,-0.34910000000000002,-752159.26988000004,-3724350.6468299995]
["2023-02-25",null,1760669.8000000003,-0.34910000000000002,-614649.82718000014,-3109700.8196499995]
["2023-03-27",null,1276919.8,-0.34910000000000002,-445772.70218000002,-2663928.1174699995]
["2023-04-26",null,1017199.8,-0.34910000000000002,-355104.45018000004,-2308823.6672899993]
["2023-05-26",null,533474.4,-0.34910000000000002,-186235.91304000001,-2122587.7542499993]
["2023-06-25",null,-9851.6999999999534,-0.34910000000000002,3439.2284699999841,-2126026.9827199993]
[]
[null,null,null,null,{"$f":"SUM(E10:E22)","v":-3634662.3272800003}]
[]
["SUMMARY:"]
["SURCHARGE AMOUNT",null,{"$f":"F9","v":-5760689.3099999996}]
[]
["AMOUNT DISTRIBUTED",null,{"$f":"E24","v":-3634662.3272800003}]
[]
["TOTAL REMAINING TO BE"]
["DISTRIBUTED",null,{"$f":"C27-C29","v":-2126026.9827199993}]

{"sheet":"PBRA 2022-00127","index":2,"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. 2022-00127"]
[]
["Expires Unit 21 May 30, 2023",null,null,"Surcharge","Surcharge","Surcharge"]
[null,null,"Volume","Rate","Amount","Balance"]
[null,null,null,null,null,3763655.45]
["2022-06-30",null,258101.20000000004,0.33139999999999997,{"$f":"ROUND(C10*D10,2)","v":85534.74},{"$f":"F9-E10","v":3678120.71}]
[{"$f":"A10+30","v":"2022-07-30"},null,197955.00000000003,{"$f":"D10","v":0.33139999999999997},{"$f":"+C11*D11","v":65602.287000000011},{"$f":"F10-E11","v":3612518.423}]
[{"$f":"A11+30","v":"2022-08-29"},null,215508.59999999998,0.33139999999999997,{"$f":"+C12*D12","v":71419.550039999987},3541098.8729599998]
["2022-09-28",null,208747.90000000005,0.33139999999999997,{"$f":"+C13*D13","v":69179.054060000009},3471919.8188999998]
["2022-10-28",null,382438.09999999992,0.33139999999999997,{"$f":"+C14*D14","v":126739.98633999996},3345179.83256]
["2022-11-27",null,745987.99999999988,0.33139999999999997,247220.42319999993,3097959.4093599999]
["2022-12-27",null,1664204.0000000002,0.33139999999999997,551517.20559999999,2546442.2037599999]
["2023-01-26",null,2154594.5999999996,0.33139999999999997,714032.65043999976,1832409.5533200002]
["2023-02-25",null,1790403.1800000006,0.33139999999999997,593339.61385200021,1239069.9394680001]
["2023-03-27",null,1277363.2,0.33139999999999997,423318.16447999998,815751.77498800005]
["2023-04-26",null,1017951.7,0.33139999999999997,337349.19337999995,478402.5816080001]
["2023-05-26",null,530064.9,0.33139999999999997,175663.50785999998,302739.07374800008]
["2023-06-25",null,-9851.6999999999534,0.33139999999999997,-3264.8533799999841,306003.92712800007]
[]
[null,null,null,null,{"$f":"SUM(E10:E22)","v":3457651.5228719995}]
[]
["SUMMARY:"]
["SURCHARGE AMOUNT",null,{"$f":"F9","v":3763655.45}]
[]
["AMOUNT  COLLECTED",null,{"$f":"E24","v":3457651.5228719995}]
[]
["TOTAL REMAINING TO BE"]
["COLLECTED",null,{"$f":"C27-C29","v":306003.92712800065}]

{"sheet":"BA 2023-00028","index":3,"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. 2023-00028"]
[]
["Expires: June 30, 2023",null,null,"Surcharge","Surcharge","Surcharge"]
[null,null,"Volume","Rate","Amount","Balance"]
["Beginning Balance",null,null,null,null,43126.659999999996]
[{"$f":"'ACA 2022-00127'!A20","v":"2023-03-01"},null,1301357.3,1.6999999999999998E-2,{"$f":"ROUND(C10*D10,2)","v":22123.07},{"$f":"F9-E10","v":21003.589999999997}]
[{"$f":"'ACA 2022-00127'!A21","v":"2023-04-01"},null,1017951.7,{"$f":"D10","v":1.6999999999999998E-2},{"$f":"ROUND(C11*D11,2)","v":17305.18},{"$f":"F10-E11","v":3698.4099999999962}]
[{"$f":"'ACA 2022-00127'!A22","v":"2023-05-01"},null,530064.9,{"$f":"D11","v":1.6999999999999998E-2},{"$f":"ROUND(C12*D12,2)","v":9011.1},{"$f":"F11-E12","v":-5312.6900000000041}]
[{"$f":"'ACA 2022-00127'!A23","v":"2023-06-01"},null,-9851.6999999999534,{"$f":"D12","v":1.6999999999999998E-2},{"$f":"ROUND(C13*D13,2)","v":-167.48},{"$f":"F12-E13","v":-5145.2100000000046}]
[]
["TOTAL SURCHARGE COLLECTED",null,null,null,null," "]
[]
[]
["SUMMARY:"]
["SURCHARGE AMOUNT",null,{"$f":"+F9","v":43126.659999999996}]
[]
["AMOUNT COLLECTED",null,{"$f":"SUM(E10:E13)","v":48271.869999999995}]
[]
["REMAINING BALANCE",null,{"$f":"C19-C21","v":-5145.2099999999991}]

{"sheet":"ACA 2022-00127","index":4,"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 YR2022 QTR1"]
["Supporting Data"]
[]
[]
["Case No. 2022-00127"]
[null,null,"Tariff",null,null,null,"Choice"]
["Expires: June 30, 2023",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,-6150275.0399999982]
["2022-06-01",null,256845.00000000003,-0.54149999999999998,{"$f":"ROUND(C11*D11,2)","v":-139081.57},null,1256.2,-2.0400000000000001E-2,{"$f":"ROUND(G11*H11,2)","v":-25.63},{"$f":"J10-E11-I11","v":-6011167.839999998}]
["2022-07-01",null,196636.9,{"$f":"D11","v":-0.54149999999999998},{"$f":"ROUND(C12*D12,2)","v":-106478.88},null,1318.1000000000001,{"$f":"H11","v":-2.0400000000000001E-2},{"$f":"ROUND(G12*H12,2)","v":-26.89},{"$f":"J11-E12-I12","v":-5904662.0699999984}]
["2022-08-01",null,214713.69999999998,-0.54149999999999998,-116267.47,null,794.90000000000009,-2.0400000000000001E-2,-16.22,{"$f":"J12-E13-I13","v":-5788378.379999999}]
["2022-09-01",null,208081.2,-0.54149999999999998,-112675.97,null,666.69999999999993,-2.0400000000000001E-2,-13.6,{"$f":"J13-E14-I14","v":-5675688.8099999996}]
["2022-10-01",null,381520.29999999993,-0.54149999999999998,-206593.24,null,917.8,-2.0400000000000001E-2,-18.72,-5469076.8499999996]
["2022-11-01",null,744830.29999999981,-0.54149999999999998,-403325.61,null,1157.7,-2.0400000000000001E-2,-23.62,-5065727.6199999992]
["2022-12-01",null,1660498.3,-0.54149999999999998,-899159.83,null,3705.7,-2.0400000000000001E-2,-75.599999999999994,-4166492.189999999]
["2023-01-01",null,2151890.7999999998,-0.54149999999999998,-1165248.8700000001,null,2703.8,-2.0400000000000001E-2,-55.16,-3001188.1599999988]
["2023-02-01",null,1786810.58,-0.54149999999999998,-967557.93,null,3592.6000000000004,-2.0400000000000001E-2,-73.290000000000006,-2033556.9399999985]
["2023-03-01",null,1273392.7,-0.54149999999999998,-689542.15,null,3970.5,-2.0400000000000001E-2,-81,-1343933.7899999986]
["2023-04-01",null,1012474.3,-0.54149999999999998,-548254.82999999996,null,5477.4,-2.0400000000000001E-2,-111.74,-795567.21999999869]
["2023-05-01",null,529159.70000000007,-0.54149999999999998,-286539.98,null,905.19999999999982,-2.0400000000000001E-2,-18.47,-509008.76999999874]
["2023-06-01",null,-7430,-0.54149999999999998,4023.35,null,-2421.6999999999998,-2.0400000000000001E-2,49.4,-513081.51999999874]
[null,null," "]
[]
[]
["SUMMARY:"]
["REFUND AMOUNT",null,null,{"$f":"J10","v":-6150275.0399999982},null,null,null,null,null," "]
["LESS"]
["AMOUNT REFUNDED",null,null,{"$f":"SUM(E11:E23,I11:I23)","v":-5637193.5199999986}]
[]
[]
["TOTAL REMAINING REFUND",null,null,{"$f":"D28-D30","v":-513081.51999999955}]