{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Exhibit CLK-1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":99,"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":"Exhibit CLK-1","index":0,"n_rows":28,"n_cols":11,"rows_kept":28,"cut":false,"hidden":false,"merged":[[22,9,23,9],[2,0,2,11],[3,0,3,11],[4,0,4,11],[6,0,6,11],[7,0,7,11]]}
[]
[]
["TEXAS GAS SERVICE COMPANY"]
[]
["TWELVE MONTHS ENDED DECEMBER 31, 2024"]
[]
["PREPAID PENSION ASSET"]
["($ in 000s)"]
[]
[]
[]
[null,null,"Corporate",null,null,"TGS Direct","Total TGS","Pension","TGS","Cumulative","TGS"]
["Line",null,"Prepaid",null,"Corporate","Prepaid","Prepaid","Earnings","Expense","TGS Expense","Expense"]
["No.","Year","Pension Asset","Distrigas %","Allocation","Pension Asset","Asset Balance","Rate","Reduction","Reduction","Reduction"]
[null,"(a)","(b)","(c)","(d) = b * c","(e)","(f) = d + e","(g)","(h) = f * g","(i)","(j)"]
[10,2018,63872.699000000001,0.2472,{"$f":"+C16*D16","v":15789.3311928},36753.286999999997,{"$f":"+F16+E16","v":52542.618192800001},7.2499999999999995E-2,{"$f":"+H16*G16","v":3809.3398189779996},{"$f":"+I16+26599.566","v":30408.905818977997},{"$f":"+I16*$I$25","v":3809.3398189779996}]
[11,2019,76979.308000000005,0.254,19552.744232000001,33163.627999999997,52716.372231999994,7.1999999999999995E-2,3795.5788007039991,{"$f":"+I17+J16","v":34204.484619682},3795.5788007039991]
[12,2020,72824.572,0.25629999999999997,18664.937803599998,28937.706999999999,47602.644803599993,7.1999999999999995E-2,3427.3904258591992,37631.875045541201,3427.3904258591992]
[13,2021,68548.217000000004,0.26805600000000002,18374.760856152003,24965.925999999999,43340.686856152002,7.1499999999999994E-2,3098.859110214868,40730.734155756072,3098.859110214868]
[16,2022,67843.245999999999,0.28070000000000001,19043.5991522,23527.498,42571.097152200004,6.4000000000000001E-2,2724.5502177408002,43455.28437349687,2724.5502177408002]
[17,2023,69404.600999999995,0.28573800000000005,19831.531880538001,24096.037,43927.568880538005,6.7500000000000004E-2,2965.1108994363153,46420.395272933187,2965.1108994363153]
[18,2024,69597.335000000006,0.29630000000000001,{"$f":"+C22*D22","v":20621.690360500001},24106.934000000001,{"$f":"+F22+E22","v":44728.624360500005},6.7000000000000004E-2,{"$f":"+H22*G22","v":2996.8178321535006},{"$f":"+I22+J21","v":49417.213105086688},{"$f":"+I22*$I$25","v":2996.8178321535006}]
[19,null,null,null,null,null,null,null,"Allocation","TGS"]
[20,null,null,null,null,null,null,"TGS Total","to service area"]
[21,null,null,null,null,"Prepaid Pension Asset",null,{"$f":"+G22","v":44728.624360500005},1,{"$f":"+H25*I25","v":44728.624360500005}]
[22]
[23]
[24]