{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["BusExp","IndExp","Income","Scratch"],"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":"BusExp","index":0,"n_rows":17,"n_cols":18,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Business Income:",null,null,null,"Idx","Category","Amount","Allowable","Alt1","Alt2",null,"Other Debts"]
[null,null,null,null,null,77,"Materials Purchased",{"$f":"SUMIF(BusExpList[Category],BusExpTable[[#This Row],[Category]],BusExpList[Amount])","v":0},null,null,null,null,"Item","Amount","Allowable","Alt1","Alt2","Note"]
[null,"Expense","Amount","Category",null,78,"Inventory Purchased",{"$f":"SUMIF(BusExpList[Category],BusExpTable[[#This Row],[Category]],BusExpList[Amount])","v":0}]
[null,null,null,null,null,79,"Gross Wages & Salaries",{"$f":"SUMIF(BusExpList[Category],BusExpTable[[#This Row],[Category]],BusExpList[Amount])","v":0}]
[null,null,null,null,null,80,"Rent",{"$f":"SUMIF(BusExpList[Category],BusExpTable[[#This Row],[Category]],BusExpList[Amount])","v":0}]
[null,null,null,null,null,81,"Supplies",{"$f":"SUMIF(BusExpList[Category],BusExpTable[[#This Row],[Category]],BusExpList[Amount])","v":0}]
[null,null,null,null,null,82,"Utilities/Telephone",{"$f":"SUMIF(BusExpList[Category],BusExpTable[[#This Row],[Category]],BusExpList[Amount])","v":0}]
[null,null,null,null,null,83,"Vehicle Gasoline/Oil",{"$f":"SUMIF(BusExpList[Category],BusExpTable[[#This Row],[Category]],BusExpList[Amount])","v":0}]
[null,null,null,null,null,84,"Repairs & Maintenance",{"$f":"SUMIF(BusExpList[Category],BusExpTable[[#This Row],[Category]],BusExpList[Amount])","v":0}]
[null,null,null,null,null,85,"Insurance",{"$f":"SUMIF(BusExpList[Category],BusExpTable[[#This Row],[Category]],BusExpList[Amount])","v":0}]
[null,null,null,null,null,86,"Current Taxes",{"$f":"SUMIF(BusExpList[Category],BusExpTable[[#This Row],[Category]],BusExpList[Amount])","v":0}]
[null,null,null,null,null,87,"Other Secured Debts",{"$f":"SUM(OtherBusExp[Amount])","v":0},{"$f":"SUM(OtherBusExp[Allowable])","v":0},{"$f":"SUM(OtherBusExp[Alt1])","v":0},{"$f":"SUM(OtherBusExp[Alt2])","v":0}]
[null,null,null,null,null,88,"Total Bus. Expenses (add lines 35-48)",{"$f":"SUBTOTAL(109,H5:H15)","v":0},{"$f":"SUBTOTAL(109,I5:I15)","v":0},0,0]
[null,null,null,null,null,89,"Net difference (Line 34 minus 49)",{"$f":"$C$4-H16","v":0},{"$f":"$C$4-I16","v":0},0,0]

{"sheet":"IndExp","index":1,"n_rows":22,"n_cols":18,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,"Business Income:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Other Debts"]
[null,null,null,null,"IDX","Category","Amount","Allowable","Proposed","Column1","Column2",null,"Item","Amount","Allowable","Alt1","Alt2","Note"]
[null,null,null,null,35,"Food, Clothing and Misc.",{"$f":"SUMIF(IndExpList[Category],IndExpTable[[#This Row],[Category]],IndExpList[Amount])","v":0}]
["Expense","Amount","Category",null,36,"Housing and Utilities",{"$f":"SUMIF(IndExpList[Category],IndExpTable[[#This Row],[Category]],IndExpList[Amount])","v":0}]
[null,null,null,null,37,"Vehicle Ownership Costs",{"$f":"SUMIF(IndExpList[Category],IndExpTable[[#This Row],[Category]],IndExpList[Amount])","v":0}]
[null,null,null,null,38,"Vehicle Operating Costs",{"$f":"SUMIF(IndExpList[Category],IndExpTable[[#This Row],[Category]],IndExpList[Amount])","v":0}]
[null,null,null,null,39,"Public Transportation",{"$f":"SUMIF(IndExpList[Category],IndExpTable[[#This Row],[Category]],IndExpList[Amount])","v":0}]
[null,null,null,null,40,"Health Insurance",{"$f":"SUMIF(IndExpList[Category],IndExpTable[[#This Row],[Category]],IndExpList[Amount])","v":0}]
[null,null,null,null,41,"Out of Pocket Health Care Costs",{"$f":"SUMIF(IndExpList[Category],IndExpTable[[#This Row],[Category]],IndExpList[Amount])","v":0}]
[null,null,null,null,42,"Court Ordered Payment",{"$f":"SUMIF(IndExpList[Category],IndExpTable[[#This Row],[Category]],IndExpList[Amount])","v":0}]
[null,null,null,null,43,"Child/Dependent Care",{"$f":"SUMIF(IndExpList[Category],IndExpTable[[#This Row],[Category]],IndExpList[Amount])","v":0}]
[null,null,null,null,44,"Life Insurance",{"$f":"SUMIF(IndExpList[Category],IndExpTable[[#This Row],[Category]],IndExpList[Amount])","v":0}]
[null,null,null,null,45,"Current year taxes (Income/FICA)",{"$f":"SUMIF(IndExpList[Category],IndExpTable[[#This Row],[Category]],IndExpList[Amount])","v":0}]
[null,null,null,null,46,"Secured Debts (Attach list)",{"$f":"SUMIF(IndExpList[Category],IndExpTable[[#This Row],[Category]],IndExpList[Amount])","v":0}]
[null,null,null,null,47,"Delinquent State or Local Tax",{"$f":"SUMIF(IndExpList[Category],IndExpTable[[#This Row],[Category]],IndExpList[Amount])","v":0}]
[null,null,null,null,48,"Other Expenses (Attach list)",{"$f":"SUM(OtherBusExp9[Amount])","v":0},{"$f":"SUM(OtherBusExp9[Allowable])","v":0},{"$f":"SUM(OtherBusExp9[Alt1])","v":0},{"$f":"SUM(OtherBusExp9[Alt2])","v":0},{"$f":"SUM(OtherBusExp9[Note])","v":0}]
[null,null,null,null,49,"Total Living Expenses (add lines 35-48)",{"$f":"SUBTOTAL(109,G5:G18)","v":0},{"$f":"SUBTOTAL(109,H5:H18)","v":0},0,0,0]
[null,null,null,null,50,"Net difference (Line 34 minus 49)",{"$f":"G2-G19","v":0}]
[]
[null,null,null,null,null,"Total",{"$f":"SUM(G5:G20)","v":0}]

{"sheet":"Income","index":2,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,1,20,1],[21,1,41,1]]}
[null,"Individual","From Bank Statements",null,null,null,"From pay stubs",null,null,null,"From tax returns"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Business","From Bank Statements",null,null,null,"From P&L",null,null,null,"From tax returns"]
[null,null,"Period","Deposits"]

{"sheet":"Scratch","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}