{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Expenses","Income"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":"Expenses","index":0,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,null,"Index","Category","Amount","Allowable","Proposed"]
[null,null,null,null,null,35,"Food, Clothing and Misc.",{"$f":"SUMIF(Table1[Category],Table2[[#This Row],[Category]],Table1[Amount])","v":1000},1677,1677]
[null,"Expense","Amount","Category",null,36,"Housing and Utilities",{"$f":"SUMIF(Table1[Category],Table2[[#This Row],[Category]],Table1[Amount])","v":3186},2125,2125]
[null,"Child Support",600,"Court Ordered Payment",null,37,"Vehicle Ownership Costs",{"$f":"SUMIF(Table1[Category],Table2[[#This Row],[Category]],Table1[Amount])","v":880},1238,880]
[null,"Mortgage",2576,"Housing and Utilities",null,38,"Vehicle Operating Costs",{"$f":"SUMIF(Table1[Category],Table2[[#This Row],[Category]],Table1[Amount])","v":590},478,478]
[null,"Life Ins",127,"Life Insurance",null,39,"Public Transportation",{"$f":"SUMIF(Table1[Category],Table2[[#This Row],[Category]],Table1[Amount])","v":0}]
[null,"Health Ins",410,"Health Insurance",null,40,"Health Insurance",{"$f":"SUMIF(Table1[Category],Table2[[#This Row],[Category]],Table1[Amount])","v":410},null,410]
[null,"Wage taxes",1205,"Current year taxes (Income/FICA)",null,41,"Out of Pocket Health Care Costs",{"$f":"SUMIF(Table1[Category],Table2[[#This Row],[Category]],Table1[Amount])","v":100},249,249]
[null,"FICA",642,"Current year taxes (Income/FICA)",null,42,"Court Ordered Payment",{"$f":"SUMIF(Table1[Category],Table2[[#This Row],[Category]],Table1[Amount])","v":600},null,600]
[null,"Tax Prep",25,"Other Expenses (Attach list)",null,43,"Child/Dependent Care",{"$f":"SUMIF(Table1[Category],Table2[[#This Row],[Category]],Table1[Amount])","v":0}]
[null,"Food",1000,"Food, Clothing and Misc.",null,44,"Life Insurance",{"$f":"SUMIF(Table1[Category],Table2[[#This Row],[Category]],Table1[Amount])","v":127},null,127]
[null,"Electric, etc",360,"Housing and Utilities",null,45,"Current year taxes (Income/FICA)",{"$f":"SUMIF(Table1[Category],Table2[[#This Row],[Category]],Table1[Amount])","v":1847},null,1847]
[null,"Tel, Cell, Internet",250,"Housing and Utilities",null,46,"Secured Debts (Attach list)",{"$f":"SUMIF(Table1[Category],Table2[[#This Row],[Category]],Table1[Amount])","v":0}]
[null,"Veh 1 Pmt",330,"Vehicle Ownership Costs",null,47,"Delinquent State or Local Tax",{"$f":"SUMIF(Table1[Category],Table2[[#This Row],[Category]],Table1[Amount])","v":0}]
[null,"Veh 2 Pmt",550,"Vehicle Ownership Costs",null,48,"Other Expenses (Attach list)",{"$f":"SUMIF(Table1[Category],Table2[[#This Row],[Category]],Table1[Amount])","v":25},null,25]
[null,"Veh Operating",590,"Vehicle Operating Costs",null,49,"Total Living Expenses (add lines 35-48)",{"$f":"SUMIF(Table1[Category],Table2[[#This Row],[Category]],Table1[Amount])","v":0}]
[null,"OOP Healthcare",100,"Out of Pocket Health Care Costs",null,50,"Net difference (Line 34 minus 49)",{"$f":"SUMIF(Table1[Category],Table2[[#This Row],[Category]],Table1[Amount])","v":0}]
[]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H5:H20)","v":8765},null,{"$f":"SUM(J5:J20)","v":8418}]

{"sheet":"Income","index":1,"n_rows":37,"n_cols":18,"rows_kept":37,"cut":false,"hidden":false,"merged":[[5,4,6,5],[5,7,6,8],[2,10,3,10],[5,10,6,10],[27,13,27,14]]}
["From Bank Statements",null,null,null,null,null,null,null,null,null,"From pay stubs"]
[null,null,null,null,null,null,null,null,null,null,null,null,"YTD","Daily","Weekly","Bi-weekly","Monthly","Annual"]
[null,"Average:",{"$f":"AVERAGE(F8:F10)","v":6988.2366666666667},null,null,null,null,null,null,null,"Averra as of 11/29/2024","Gross Pay",49527,148.72999999999999,1041.1099999999999,2082.2199999999998,4523.8599999999997,54286.35]
[null,null,null,null,null,null,null,null,null,null,null,"W-4 WH",5253,15.77,110.42,220.85,479.82,5757.79]
["Interstate"]
["Date","Payer","Amount","Month","Total per Month",null,null,"Average pay per spouse, monthly",null,null,"Titan as of 02/17/2024","Gross Pay",8165,173.72,1216.06,2432.13,5284.09,63409.04]
["2024-08-23","Titan",2058.4,{"$f":"MONTH(A7)","v":8},null,null,null,null,null,null,null,"W-4 WH",1120,23.83,166.81,333.62,724.82,8697.8700000000008]
["2024-08-23","Averra",2264.84,{"$f":"MONTH(A8)","v":8},9,{"$f":"SUMIF($D$7:$D$20,E8,$C$7:$C$20)","v":8949.4399999999987},null,"Titan",{"$f":"SUMIF($B$9:$B$20,H8,$C$9:C20)/3","v":3187.2099999999996},null,null,"Dental",114,2.4300000000000002,16.98,33.96,73.78,885.32]
["2024-09-06","Titan",3390.35,9,10,6004.9,null,"Averra",{"$f":"SUMIF($B$9:$B$20,H9,$C$9:C21)/3","v":3801.0266666666671},null,null,"Life",196,4.17,29.19,58.38,126.84,1522.13]
["2024-09-06","Averra",2299.4499999999998,9,11,6010.37,null,"Total Income",{"$f":"SUM(I8:I9)","v":6988.2366666666667},null,null,"Health",519,11.04,77.3,154.6,335.88,4030.53]
["2024-09-20","Titan",1233.74,9]
["2024-09-20","Averra",2025.9,9,null,null,null,null,null,null,null,"Total:",null,{"$f":"SUM(N3,N6)","v":322.45},2257.17,4514.3500000000004,9807.9500000000007,117695.39]
["2024-10-04","Titan",1243.06,10,null,null,null,null,null,null,null,"W-4 WH",null,39.599999999999994,277.23,554.47,1204.6400000000001,14455.66]
["2024-10-04","Averra",1659.84,10,null,null,null,null,null,null,null,"Med Ins",null,{"$f":"SUM(N8,N10)","v":13.469999999999999},{"$f":"SUM(O8,O10)","v":94.28},188.56,409.65999999999997,4915.8500000000004]
["2024-10-18","Titan",1216.58,10,null,null,null,null,null,null,null,"Life Ins",null,{"$f":"N9","v":4.17},{"$f":"O9","v":29.19},58.38,126.84,1522.13]
["2024-10-18","Averra",1885.42,10]
["2024-11-01","Titan",1248.5899999999999,11]
["2024-11-01","Averra",1747.01,11]
["2024-11-15","Titan",1229.31,11]
["2024-11-15","Averra",1785.46,11]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Avera Bank",{"$f":"I9","v":3801.0266666666671},null,"WH"]
[null,null,null,null,null,null,null,null,null,null,"Avera Stub",{"$f":"Q3","v":4523.8599999999997},null,{"$f":"Q4/Q3","v":0.10606429023002481},{"$f":"L30*N29","v":441.48659777269859}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(L28:L29)","v":4162.4433333333336}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Titan, Bank",{"$f":"I8","v":3187.2099999999996}]
[null,null,null,null,null,null,null,null,null,null,"Titan, Stub",{"$f":"Q6","v":5284.09},null,{"$f":"Q7/Q6","v":0.13717026015832434},{"$f":"L35*N34","v":581.00521243960645}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(L33:L34)","v":4235.6499999999996}]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L30,L35)","v":8398.0933333333342}]