{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["SCH G-12 Uncoll 3 Yr Avg TGS","SCH G-12 Uncoll 3 Yr Avg CGSA","SCH G-12 Uncoll 3 Yr Avg RGSA","SCH G-12 Uncoll 3 Yr Avg WNSA"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":5,"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":"SCH G-12 Uncoll 3 Yr Avg TGS","index":0,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":false,"merged":[[30,1,30,4]]}
[]
["SCH G-12 UNCOLLECTIBLE EXPENSE"]
["For Periods ending December 2022-2024"]
[]
[]
["TEXAS GAS SERVICE AREA"]
[]
["UNCOLLECTIBLE EXPENSE"]
[]
["Line No","Period"," Base Revenue Write Offs (1)","Base Revenue ","Uncollectible Ratio for Base Revenues"]
[null,"(a)","(b)","(c)","(d)"]
[1,"Twelve Months Ended December 2022",{"$f":"+'SCH G-12 Uncoll 3 Yr Avg CGSA'!C12+'SCH G-12 Uncoll 3 Yr Avg RGSA'!C12+'SCH G-12 Uncoll 3 Yr Avg WNSA'!C12","v":2369667.8000000017},{"$f":"+'SCH G-12 Uncoll 3 Yr Avg CGSA'!D12+'SCH G-12 Uncoll 3 Yr Avg RGSA'!D12+'SCH G-12 Uncoll 3 Yr Avg WNSA'!D12","v":304741476.09000003},{"$f":"+C12/D12","v":7.7759937058917506E-3}]
[{"$f":"1+A12","v":2},"Twelve Months Ended December 2023",{"$f":"+'SCH G-12 Uncoll 3 Yr Avg CGSA'!C13+'SCH G-12 Uncoll 3 Yr Avg RGSA'!C13+'SCH G-12 Uncoll 3 Yr Avg WNSA'!C13","v":2512140.4000000004},{"$f":"+'SCH G-12 Uncoll 3 Yr Avg CGSA'!D13+'SCH G-12 Uncoll 3 Yr Avg RGSA'!D13+'SCH G-12 Uncoll 3 Yr Avg WNSA'!D13","v":332471197.36999989},{"$f":"+C13/D13","v":7.5559640049188822E-3}]
[{"$f":"1+A13","v":3},"Twelve Months Ended December 2024",{"$f":"+'SCH G-12 Uncoll 3 Yr Avg CGSA'!C14+'SCH G-12 Uncoll 3 Yr Avg RGSA'!C14+'SCH G-12 Uncoll 3 Yr Avg WNSA'!C14","v":2491471.0800000019},{"$f":"+'SCH G-12 Uncoll 3 Yr Avg CGSA'!D14+'SCH G-12 Uncoll 3 Yr Avg RGSA'!D14+'SCH G-12 Uncoll 3 Yr Avg WNSA'!D14","v":365446212.00999993},6.8176136408600301E-3]
[4]
[5,"Average",{"$f":"+AVERAGE(C12:C14)","v":2457759.7600000012},{"$f":"+AVERAGE(D12:D14)","v":334219628.48999995},{"$f":"ROUND(+C16/D16,6)","v":7.3540000000000003E-3}]
[6,null,null,null," "]
[7]
[8]
[9,"Estimated Bad Debts related to Gas Cost Revenue"]
[10]
[11,"Twelve Month Period","Gas Cost Bad Debt","COG Revenue","Uncollectible Ratio for COG Revenues"]
[12,"Twelve Months Ended December 2022",{"$f":"+'SCH G-12 Uncoll 3 Yr Avg CGSA'!C23+'SCH G-12 Uncoll 3 Yr Avg RGSA'!C23+'SCH G-12 Uncoll 3 Yr Avg WNSA'!C23","v":1198280.8099999998},{"$f":"+'SCH G-12 Uncoll 3 Yr Avg CGSA'!D23+'SCH G-12 Uncoll 3 Yr Avg RGSA'!D23+'SCH G-12 Uncoll 3 Yr Avg WNSA'!D23","v":310617282.31999999},{"$f":"+C23/D23","v":3.8577403068175806E-3}]
[13,"Twelve Months Ended December 2023",{"$f":"+'SCH G-12 Uncoll 3 Yr Avg CGSA'!C24+'SCH G-12 Uncoll 3 Yr Avg RGSA'!C24+'SCH G-12 Uncoll 3 Yr Avg WNSA'!C24","v":1376846.7600000002},{"$f":"+'SCH G-12 Uncoll 3 Yr Avg CGSA'!D24+'SCH G-12 Uncoll 3 Yr Avg RGSA'!D24+'SCH G-12 Uncoll 3 Yr Avg WNSA'!D24","v":258291065.01000005},{"$f":"+C24/D24","v":5.3306015829339432E-3}]
[14,"Twelve Months Ended December 2024",{"$f":"+'SCH G-12 Uncoll 3 Yr Avg CGSA'!C25+'SCH G-12 Uncoll 3 Yr Avg RGSA'!C25+'SCH G-12 Uncoll 3 Yr Avg WNSA'!C25","v":508612.03000000014},{"$f":"+'SCH G-12 Uncoll 3 Yr Avg CGSA'!D25+'SCH G-12 Uncoll 3 Yr Avg RGSA'!D25+'SCH G-12 Uncoll 3 Yr Avg WNSA'!D25","v":172912541.16},2.9414409538367123E-3]
[15]
[16,"Average",{"$f":"+AVERAGE(C23:C25)","v":1027913.2000000002},{"$f":"+AVERAGE(D23:D25)","v":247273629.49666667},{"$f":"ROUND(C27/D27,6)","v":4.1570000000000001E-3}]
[null,null," "]
[]
[]
[null,"Note 1: Actual bad debt write-offs relating to gas cost recovery revenue are to be recovered through the PGA. Therefore, uncollectible expense above is calculated based only on base revenue"]

{"sheet":"SCH G-12 Uncoll 3 Yr Avg CGSA","index":1,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":false,"merged":[[30,1,30,4]]}
[]
["SCH G-12 UNCOLLECTIBLE EXPENSE"]
["For Periods ending December 2022-2024"]
[]
[]
["CENTRAL-GULF SERVICE AREA"]
[]
["UNCOLLECTIBLE EXPENSE"]
[]
["Line No","Period"," Base Revenue Write Offs (1)","Base Revenue ","Uncollectible Ratio for Base Revenues"]
[null,"(a)","(b)","(c)","(d)"]
[1,"Twelve Months Ended December 2022",919846.17000000097,137791869.47,{"$f":"+C12/D12","v":6.675620074958556E-3}]
[{"$f":"1+A12","v":2},"Twelve Months Ended December 2023",907234.46000000462,148521157.49999994,{"$f":"+C13/D13","v":6.1084526627124148E-3}]
[{"$f":"1+A13","v":3},"Twelve Months Ended December 2024",1020574.5000000012,165095119.40999997,6.1817363447643145E-3]
[4]
[5,"Average",{"$f":"+AVERAGE(C12:C14)","v":949218.3766666688},{"$f":"+AVERAGE(D12:D14)","v":150469382.12666664},{"$f":"ROUND(+C16/D16,6)","v":6.3080000000000002E-3}]
[6,null,null,null," "]
[7]
[8]
[9,"Estimated Bad Debts related to Gas Cost Revenue"]
[10]
[11,"Twelve Month Period","Gas Cost Bad Debt","COG Revenue","Uncollectible Ratio for COG Revenues"]
[12,"Twelve Months Ended December 2022",453247.17999999982,125741758.26999998,{"$f":"+C23/D23","v":3.6045875788277212E-3}]
[13,"Twelve Months Ended December 2023",382307.77999999997,93904158.770000011,{"$f":"+C24/D24","v":4.0712550435214332E-3}]
[14,"Twelve Months Ended December 2024",224680.80000000002,71526562.329999983,3.1412218437592019E-3]
[15]
[16,"Average",{"$f":"+AVERAGE(C23:C25)","v":353411.91999999993},{"$f":"+AVERAGE(D23:D25)","v":97057493.123333335},{"$f":"ROUND(C27/D27,6)","v":3.6410000000000001E-3}]
[null,null," "]
[]
[]
[null,"Note 1: Actual bad debt write-offs relating to gas cost recovery revenue are to be recovered through the PGA. Therefore, uncollectible expense above is calculated based only on base revenue"]

{"sheet":"SCH G-12 Uncoll 3 Yr Avg RGSA","index":2,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":false,"merged":[[30,1,31,4]]}
[]
["SCH G-12 UNCOLLECTIBLE EXPENSE"]
["For Periods ending December 2022-2024"]
[]
[]
["RIO GRANDE VALLEY SERVICE AREA"]
[]
["UNCOLLECTIBLE EXPENSE"]
[]
["Line No","Period"," Base Revenue Write Offs (1)","Base Revenue ","Uncollectible Ratio for Base Revenues"]
[null,"(a)","(b)","(c)","(d)"]
[1,"Twelve Months Ended December 2022",438640.20999999985,36522657,{"$f":"+C12/D12","v":1.201008486321244E-2}]
[{"$f":"1+A12","v":2},"Twelve Months Ended December 2023",387450.79999999958,37712853.109999999,{"$f":"+C13/D13","v":1.0273706920817999E-2}]
[{"$f":"1+A13","v":3},"Twelve Months Ended December 2024",380467.16999999981,45374987.659999989,8.3849536852964937E-3]
[4]
[5,"Average",{"$f":"+AVERAGE(C12:C14)","v":402186.05999999976},{"$f":"+AVERAGE(D12:D14)","v":39870165.923333324},{"$f":"ROUND(+C16/D16,6)","v":1.0087E-2}]
[6,null,null,null," "]
[7]
[8]
[9,"Estimated Bad Debts related to Gas Cost Revenue"]
[10]
[11,"Twelve Month Period","Gas Cost Bad Debt","COG Revenue","Uncollectible Ratio for COG Revenues"]
[12,"Twelve Months Ended December 2022",96650.069999999978,24160950.549999997,{"$f":"+C23/D23","v":4.0002594186013922E-3}]
[13,"Twelve Months Ended December 2023",72466.429999999993,12220319.199999999,{"$f":"+C24/D24","v":5.9299948564355007E-3}]
[14,"Twelve Months Ended December 2024",24304.280000000002,7621464.9900000021,3.1889249680854331E-3]
[15]
[16,"Average",{"$f":"+AVERAGE(C23:C25)","v":64473.593333333323},{"$f":"+AVERAGE(D23:D25)","v":14667578.246666668},{"$f":"ROUND(C27/D27,6)","v":4.3959999999999997E-3}]
[null,null," "]
[]
[]
[null,"Note 1: Actual bad debt write-offs relating to gas cost recovery revenue are to be recovered through the PGA. Therefore, uncollectible expense above is calculated based only on base revenue"]

{"sheet":"SCH G-12 Uncoll 3 Yr Avg WNSA","index":3,"n_rows":32,"n_cols":5,"rows_kept":32,"cut":false,"hidden":false,"merged":[[31,1,31,6]]}
[]
["SCH G-12 UNCOLLECTIBLE EXPENSE"]
["For Periods ending December 2022-2024"]
[]
[]
["WEST NORTH SERVICE AREA"]
[]
["UNCOLLECTIBLE EXPENSE"]
[]
["Line No","Period"," Base Revenue Write Offs (1)","Base Revenue ","Uncollectible Ratio for Base Revenues"]
[null,"(a)","(b)","(c)","(d)"]
[1,"Twelve Months Ended December 2022",1011181.4200000006,130426949.62000006,{"$f":"+C12/D12","v":7.7528564682842437E-3}]
[{"$f":"1+A12","v":2},"Twelve Months Ended December 2023",1217455.1399999964,146237186.75999993,{"$f":"+C13/D13","v":8.3252089770986023E-3}]
[2,"Twelve Months Ended December 2024",1090429.4100000011,154976104.93999997,7.0361131506187233E-3]
[{"$f":"1+A14","v":3}]
[3,"Average",{"$f":"+AVERAGE(C12:C14)","v":1106355.3233333325},{"$f":"+AVERAGE(D12:D14)","v":143880080.43999997},{"$f":"ROUND(+C16/D16,6)","v":7.6889999999999997E-3}]
[{"$f":"1+A16","v":4},null,null,null," "]
[4]
[{"$f":"1+A18","v":5}]
[5,"Estimated Bad Debts related to Gas Cost Revenue"]
[{"$f":"1+A20","v":6}]
[6,"Twelve Month Period","Gas Cost Bad Debt","COG Revenue","Uncollectible Ratio for COG Revenues"]
[{"$f":"1+A22","v":7},"Twelve Months Ended December 2022",648383.56000000006,160714573.5,{"$f":"+C23/D23","v":4.0343793713268948E-3}]
[7,"Twelve Months Ended December 2023",922072.55000000016,152166587.04000002,{"$f":"+C24/D24","v":6.0596256243666356E-3}]
[{"$f":"1+A24","v":8},"Twelve Months Ended December 2024",259626.95000000016,93764513.840000004,2.7689254640943183E-3]
[8]
[{"$f":"1+A26","v":9},"Average",{"$f":"+AVERAGE(C23:C25)","v":610027.68666666688},{"$f":"+AVERAGE(D23:D25)","v":135548558.12666667},{"$f":"ROUND(C27/D27,6)","v":4.4999999999999997E-3}]
[null,null," "]
[]
[]
[]
[null,"Note 1: Actual bad debt write-offs relating to gas cost recovery revenue are to be recovered through the PGA. Therefore, uncollectible expense above is calculated based only on base revenue"]