{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Expenses","Income","Sheet1"],"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":20,"n_cols":14,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"#1","From 2023 1040 - Line 23 Other/SE tax"]
[null,null,null,null,null,"Index","Category","Amount","Allowable","Proposed",null,null,"#2","Ttl tax liability (2023) less SE Tax"]
[null,null,null,null,null,35,"Food, Clothing and Misc.",{"$f":"SUMIF(Table1[Category],Table2[[#This Row],[Category]],Table1[Amount])","v":1600},2027]
[null,"Expense","Amount","Category","Column1",36,"Housing and Utilities",{"$f":"SUMIF(Table1[Category],Table2[[#This Row],[Category]],Table1[Amount])","v":3630},2980]
[null,"Food",1600,"Food, Clothing and Misc.",null,37,"Vehicle Ownership Costs",{"$f":"SUMIF(Table1[Category],Table2[[#This Row],[Category]],Table1[Amount])","v":1190},619]
[null,"Rent",2100,"Housing and Utilities",null,38,"Vehicle Operating Costs",{"$f":"SUMIF(Table1[Category],Table2[[#This Row],[Category]],Table1[Amount])","v":1400},260]
[null,"Elect/Gas, etc.",650,"Housing and Utilities",null,39,"Public Transportation",{"$f":"SUMIF(Table1[Category],Table2[[#This Row],[Category]],Table1[Amount])","v":0}]
[null,"Tel/Cable/Internet",880,"Housing and Utilities",null,40,"Health Insurance",{"$f":"SUMIF(Table1[Category],Table2[[#This Row],[Category]],Table1[Amount])","v":800},800]
[null,"Child Support",1350,"Court Ordered Payment",null,41,"Out of Pocket Health Care Costs",{"$f":"SUMIF(Table1[Category],Table2[[#This Row],[Category]],Table1[Amount])","v":600},332]
[null,"Vehicle Pmts",1190,"Vehicle Ownership Costs",null,42,"Court Ordered Payment",{"$f":"SUMIF(Table1[Category],Table2[[#This Row],[Category]],Table1[Amount])","v":1350},1350]
[null,"Veh Operations",1400,"Vehicle Operating Costs",null,43,"Child/Dependent Care",{"$f":"SUMIF(Table1[Category],Table2[[#This Row],[Category]],Table1[Amount])","v":0}]
[null,"Health Ins",800,"Health Insurance",null,44,"Life Insurance",{"$f":"SUMIF(Table1[Category],Table2[[#This Row],[Category]],Table1[Amount])","v":0}]
[null,"OOP Healthcare",600,"Out of Pocket Health Care Costs",null,45,"Current year taxes (Income/FICA)",{"$f":"SUMIF(Table1[Category],Table2[[#This Row],[Category]],Table1[Amount])","v":5073},5073]
[null,"FICA",2470,"Current year taxes (Income/FICA)","#1",46,"Secured Debts (Attach list)",{"$f":"SUMIF(Table1[Category],Table2[[#This Row],[Category]],Table1[Amount])","v":0}]
[null,"Income Tax",2603,"Current year taxes (Income/FICA)","#2",47,"Delinquent State or Local Tax",{"$f":"SUMIF(Table1[Category],Table2[[#This Row],[Category]],Table1[Amount])","v":0}]
[null,null,null,null,null,48,"Other Expenses (Attach list)",{"$f":"SUMIF(Table1[Category],Table2[[#This Row],[Category]],Table1[Amount])","v":0}]
[null,null,null,null,null,49,"Total Living Expenses (add lines 35-48)",{"$f":"SUBTOTAL(109,H5:H18)","v":15643},{"$f":"SUBTOTAL(109,I5:I18)","v":13441}]
[null,null,null,null,null,50,"Net difference (Line 34 minus 49)",{"$f":"SUMIF(Table1[Category],Table2[[#This Row],[Category]],Table1[Amount])","v":0}]

{"sheet":"Income","index":1,"n_rows":41,"n_cols":11,"rows_kept":41,"cut":false,"hidden":false,"merged":[[21,11,21,13]]}
["From Bank Statements",null,null,null,null,null,null,null,null,null,"From pay stubs"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["From Tax Returns",null,null,null,null,null,null,null,null,null,"From Other"]
["Year","Total Inc.","Monthly"]
[2023,365179,{"$f":"B24/12","v":30431.583333333332}]
[2022,352235,{"$f":"B25/12","v":29352.916666666668}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Average:",{"$f":"AVERAGE(B24:B40)","v":358707},{"$f":"AVERAGE(C24:C40)","v":29892.25}]

{"sheet":"Sheet1","index":2,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Monthly income ",29892.25]