{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["ACA SUMMARY","SS & GSO","Uncollectible ACA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"ACA SUMMARY","index":0,"n_rows":41,"n_cols":12,"rows_kept":41,"cut":false,"hidden":false,"merged":[[4,0,4,11],[0,0,0,11],[2,0,2,11],[3,0,3,11]]}
["COLUMBIA GAS OF KENTUCKY, INC."]
[]
["STATEMENT SHOWING COMPUTATION OF"]
["ACTUAL GAS COST ADJUSTMENT (ACA)"]
["BASED ON THE THREE MONTHS ENDED MAY 31, 2022"]
[]
[null,null,"Total","Standby","Net","Average"]
[null,null,"Sales","Service","Applicable","Expected",null,"Standby",null,"Total",null,"(OVER)/"]
["Line",null,"Volumes","Sales","Sales","Gas Cost","Gas Cost","Service","Gas Left On ","Gas Cost","Cost of Gas","UNDER"]
["No.","Month","Per Books","Volumes","Volumes","Rate","Recovery","Recovery","Recovery","Recovery","Purchased","RECOVERY"]
[null,null,"Mcf","Mcf","Mcf","$/Mcf","$","$",null,"$","$","$"]
[null,null,"(1)","(2)","(3)=(1)-(2)","(4) = (5/3)",-5,"(6)",-7,"(8)=(5)+(6)-(7)",-9,"(10)=(9)-(8)"]
[]
[1,"2022-03-01",{"$f":"987612+493379+26923+3488","v":1511402},{"$f":"'SS & GSO'!F15","v":526},{"$f":"C14-D14","v":1510876},{"$f":"ROUND(+G14/E14,4)","v":5.4244000000000003},8195531.8799999971,12288.330000000002,-2966.6200000000008,{"$f":"G14+H14-I14","v":8210786.8299999973},7455779.7400000002,{"$f":"K14-J14","v":-755007.08999999706}]
[2,{"$f":"+B14+31","v":"2022-04-01"},{"$f":"738594+399681+16947+1268","v":1156490},{"$f":"'SS & GSO'!F16","v":0},{"$f":"C15-D15","v":1156490},{"$f":"ROUND(+G15/E15,4)","v":5.4283000000000001},6277811.0999999996,9611.99,-3448.69,{"$f":"G15+H15-I15","v":6290871.7800000003},15830504.640000001,{"$f":"K15-J15","v":9539632.8599999994}]
[3,{"$f":"+B15+31","v":"2022-05-02"},{"$f":"301089+200784+13878+775","v":516526},{"$f":"'SS & GSO'!F17","v":210},{"$f":"C16-D16","v":516316},{"$f":"ROUND(+G16/E16,4)","v":5.4302999999999999},2803745.3600000003,10402.35,-1609.7799999999997,{"$f":"G16+H16-I16","v":2815757.49},11577196.129999999,{"$f":"K16-J16","v":8761438.6399999987}]
[]
[{"$f":"+A16+1","v":4},"TOTAL",{"$f":"SUM(C14:C16)","v":3184418},{"$f":"SUM(D14:D16)","v":736},{"$f":"SUM(E14:E16)","v":3183682},null,{"$f":"SUM(G14:G16)","v":17277088.339999996},32302.67,-8025.0900000000011,17317416.099999998,34863480.510000005,17546064.410000004]
[]
[{"$f":"+A18+1","v":5},"Off-System Sales",null,null,null,null,null,null,null,null,null,-239761.15]
[{"$f":"+A20+1","v":6},"Capacity Release",null,null,null,null,null,null,null,null,null,0]
[]
[{"$f":"A21+1","v":7},"TOTAL (OVER)/UNDER-RECOVERY",null,null,null,null,null,null,null,null,null,{"$f":"SUM(L18:L21)","v":17306303.260000005}]
[]
[{"$f":"+A23+1","v":8},"Demand Revenues Received",null,null,null,null,null,null,null,null,null,5334538.9226899995]
[{"$f":"+A25+1","v":9},"Demand Cost of Gas",null,null,null,null,null,null,null,null,null,3935855.3800000004]
[{"$f":"+A26+1","v":10},"Demand (Over)/Under Recovery",null,null,null,null,null,null,null,null,null,{"$f":"L26-L25","v":-1398683.5426899991}]
[{"$f":"+A27+1","v":11},"Expected Sales Volumes for the Twelve Months End August 31, 2023",null,null,null,null,null,null,null,null,null,{"$f":"(12547000/1.101)*(1-0.003)-3002","v":11358813.622161672}]
[]
[{"$f":"+A28+1","v":12},"DEMAND ACA TO EXPIRE UNIT 21 AUGUST (AUGUST 28, 2023)",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L27/L28,4)","v":-0.1231}]
[]
[{"$f":"+A30+1","v":13},"Commodity Revenues Received",null,null,null,null,null,null,null,null,null,11982877.186120002]
[{"$f":"+A32+1","v":14},"Commodity Cost of Gas",null,null,null,null,null,null,null,null,null,30687863.98]
[{"$f":"+A33+1","v":15},"Commodity (Over)/Under Recovery",null,null,null,null,null,null,null,null,null,{"$f":"L33-L32","v":18704986.793880001}]
[{"$f":"+A34+1","v":16},"Gas Cost Uncollectible ACA",null,null,null,null,null,null,null,null,null,{"$f":"'Uncollectible ACA'!F12","v":83988.99}]
[{"$f":"+A35+1","v":17},"Total Commodity (Over)/Under Recovery",null,null,null,null,null,null,null,null,null,{"$f":"L35+L34","v":18788975.783879999}]
[{"$f":"+A36+1","v":18},"Expected Sales Volumes for the Twelve Months End August 31, 2023",null,null,null,null,null,null,null,null,null,{"$f":"L28","v":11358813.622161672}]
[]
[{"$f":"+A37+1","v":19},"COMMODITY ACA TO EXPIRE UNIT 21 AUGUST (AUGUST 28, 2023)",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L36/L37,4)","v":1.6540999999999999}]
[]
[{"$f":"+A39+1","v":20},"TOTAL ACA TO EXPIRE UNIT 21 AUGUST (AUGUST 28, 2023)",null,null,null,null,null,null,null,null,null,{"$f":"L30+L39","v":1.5309999999999999}]

{"sheet":"SS & GSO","index":1,"n_rows":39,"n_cols":8,"rows_kept":39,"cut":false,"hidden":false,"merged":[[2,0,2,8],[3,0,3,8],[4,0,4,8],[5,0,5,8]]}
[]
[]
["STATEMENT SHOWING ACTUAL COST"]
["RECOVERY FROM CUSTOMERS TAKING STANDBY"]
["SERVICE UNDER RATE SCHEDULE IS AND GSO"]
[{"$f":"'ACA SUMMARY'!A5:L5","v":"BASED ON THE THREE MONTHS ENDED MAY 31, 2022"}]
[]
[null,null,null,null,null,null,"Average"]
[null,null,null,null,null,"SS","SS","SS"]
["LINE",null,null,null,null,"Commodity","Recovery","Commodity"]
["NO.","MONTH",null,null,null,"Volumes","Rate","Recovery"]
[null,null,null,null,null,"(1)","(2)","(3)"]
[null,null,null,null,null,"Mcf","$/Mcf","$"]
[]
[1,{"$f":"'ACA SUMMARY'!B14","v":"2022-03-01"},null,null,null,526,{"$f":"IF(F15=0,0,ROUND(H15/F15,4))","v":5.0880999999999998},2676.34]
[2,{"$f":"'ACA SUMMARY'!B15","v":"2022-04-01"},null,null,null,0,{"$f":"IF(F16=0,0,ROUND(H16/F16,4))","v":0},0]
[3,{"$f":"'ACA SUMMARY'!B16","v":"2022-05-02"},null,null,null,210,{"$f":"IF(F17=0,0,ROUND(H17/F17,4))","v":3.7635999999999998},790.36]
[]
[{"$f":"+A17+1","v":4},"Total SS Commodity Recovery",null,null,null," ",null,{"$f":"SUM(H15:H17)","v":3466.7000000000003}]
[]
[]
[]
[]
[null,null,null,null,null,null,"Average"]
[null,null,null,null,null,"SS","SS","SS"]
["LINE",null,null,null,null," Demand","Demand","Demand"]
["NO.","MONTH",null,null,null,"Volumes","Rate","Recovery"]
[null,null,null,null,null,"(1)","(2)","(3)"]
[null,null,null,null,null,"Mcf","$/Mcf","$"]
[]
[{"$f":"+A19+1","v":5},{"$f":"B15","v":"2022-03-01"},null,null,null,1040,{"$f":"IF(F31=0,0,ROUND(H31/F31,4))","v":9.2423000000000002},9611.99]
[{"$f":"+A31+1","v":6},{"$f":"B16","v":"2022-04-01"},null,null,null,1040,{"$f":"IF(F32=0,0,ROUND(H32/F32,4))","v":9.2423000000000002},9611.99]
[{"$f":"+A32+1","v":7},{"$f":"B17","v":"2022-05-02"},null,null,null,1040,{"$f":"IF(F33=0,0,ROUND(H33/F33,4))","v":9.2423000000000002},9611.99]
[]
[{"$f":"+A33+1","v":8},"Total SS Demand Recovery",null,null,null,null,null,{"$f":"SUM(H31:H33)","v":28835.97}]
[]
[]
[{"$f":"+A35+1","v":9},"TOTAL SS AND GSO RECOVERY",null,null,null,null,null,{"$f":"H19+H35","v":32302.670000000002}]
[null,null,null,null,null,null,null," "]

{"sheet":"Uncollectible ACA","index":2,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,0,1,4],[2,0,2,4],[3,0,3,4]]}
[]
["Columbia Gas of Kentucky, Inc."]
["Gas Cost Uncollectible Charge - Actual Cost Adjustment"]
[{"$f":"'ACA SUMMARY'!A5:L5","v":"BASED ON THE THREE MONTHS ENDED MAY 31, 2022"}]
["Line"]
["No.","Class",{"$f":"'ACA SUMMARY'!B14","v":"2022-03-01"},{"$f":"'ACA SUMMARY'!B15","v":"2022-04-01"},{"$f":"'ACA SUMMARY'!B16","v":"2022-05-02"},"Total"]
[]
[1,"Actual Cost",23786.399999999994,58695.25,52610.510000000009,{"$f":"SUM(C8:E8)","v":135092.16}]
[]
[2,"Actual Recovery",23944.629999999997,18857.120000000003,8301.42,{"$f":"SUM(C10:E10)","v":51103.17}]
[]
[{"$f":"A10+1","v":3},"(Over)/Under Activity",{"$f":"C8-C10","v":-158.2300000000032},{"$f":"D8-D10","v":39838.129999999997},{"$f":"E8-E10","v":44309.090000000011},{"$f":"F8-F10","v":83988.99}]