{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Cash flow","Monthly income","Monthly expenses","Chart data"],"not_rendered":{"charts":1,"images":2,"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"Cash flow","index":0,"n_rows":11,"n_cols":5,"rows_kept":11}
[]
[null,"Torres Family | February 2023"]
[null,"HOUSEHOLD BUDGET"]
[]
[null,"Cash flow analysis"]
[]
[]
[null,"Household budget","Projected","Actual","Variance"]
[null,"Total income",{"$f":"Income[[#Totals],[Projected]]","v":{"v":5700,"d":"$5,700"}},{"$f":"Income[[#Totals],[Actual]]","v":{"v":6000,"d":"$6,000"}},{"$f":"CashFlow[[#This Row],[Actual]]-CashFlow[[#This Row],[Projected]]","v":{"v":300,"d":"$300"}}]
[null,"Total expense",{"$f":"Expenses[[#Totals],[Projected]]","v":{"v":3603,"d":"$3,603"}},{"$f":"Expenses[[#Totals],[Actual]]","v":{"v":3655,"d":"$3,655"}},{"$f":"CashFlow[[#This Row],[Projected]]-CashFlow[[#This Row],[Actual]]","v":{"v":-52,"d":"($52)"}}]
[null,"Total cash",{"$f":"C9-C10","v":{"v":2097,"d":"$2,097"}},{"$f":"D9-D10","v":{"v":2345,"d":"$2,345"}},{"$f":"SUBTOTAL(109,CashFlow[Variance])","v":{"v":248,"d":"$248"}}]

{"sheet":"Monthly income","index":1,"n_rows":9,"n_cols":6,"rows_kept":9,"merged":[[1,1,1,3],[2,1,2,3]]}
[{"$nulls":5}," "]
[null,"Torres Family | February 2023"]
[null,"MONTHLY INCOME"]
[]
[null," Monthry income","Projected","Actual","Variance"]
[null,"Income 1",{"v":4000,"d":"$4,000.00"},{"v":4000,"d":"$4,000.00"},{"$f":"Income[[#This Row],[Actual]]-Income[[#This Row],[Projected]]","v":{"v":0,"d":"$0.00"}}]
[null,"Income 2",{"v":1400,"d":"$1,400.00"},{"v":1500,"d":"$1,500.00"},{"$f":"Income[[#This Row],[Actual]]-Income[[#This Row],[Projected]]","v":{"v":100,"d":"$100.00"}}]
[null,"Other income",{"v":300,"d":"$300.00"},{"v":500,"d":"$500.00"},{"$f":"Income[[#This Row],[Actual]]-Income[[#This Row],[Projected]]","v":{"v":200,"d":"$200.00"}}]
[null,"Total income",{"$f":"SUBTOTAL(109,Income[Projected])","v":{"v":5700,"d":"$5,700.00"}},{"$f":"SUBTOTAL(109,Income[Actual])","v":{"v":6000,"d":"$6,000.00"}},{"$f":"SUBTOTAL(109,Income[Variance])","v":{"v":300,"d":"$300.00"}}]

{"sheet":"Monthly expenses","index":2,"n_rows":26,"n_cols":6,"rows_kept":26,"merged":[[1,1,1,3],[2,1,2,3]]}
[{"$nulls":5}," "]
[null,"Torres Family | February 2023"]
[null,"MONTHLY EXPENSES"]
[]
[null," Monthry expenses","Projected","Actual","Variance"]
[null,"Housing",{"v":1500,"d":"$1,500.00"},{"v":1500,"d":"$1,500.00"},{"$f":"Expenses[[#This Row],[Projected]]-Expenses[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
[null,"Groceries",{"v":250,"d":"$250.00"},{"v":280,"d":"$280.00"},{"$f":"Expenses[[#This Row],[Projected]]-Expenses[[#This Row],[Actual]]","v":{"v":-30,"d":"($30.00)"}}]
[null,"Telephone",{"v":38,"d":"$38.00"},{"v":38,"d":"$38.00"},{"$f":"Expenses[[#This Row],[Projected]]-Expenses[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
[null,"Electric / gas",{"v":65,"d":"$65.00"},{"v":78,"d":"$78.00"},{"$f":"Expenses[[#This Row],[Projected]]-Expenses[[#This Row],[Actual]]","v":{"v":-13,"d":"($13.00)"}}]
[null,"Water / sewer / trash",{"v":25,"d":"$25.00"},{"v":21,"d":"$21.00"},{"$f":"Expenses[[#This Row],[Projected]]-Expenses[[#This Row],[Actual]]","v":{"v":4,"d":"$4.00"}}]
[null,"Cable TV",{"v":75,"d":"$75.00"},{"v":83,"d":"$83.00"},{"$f":"Expenses[[#This Row],[Projected]]-Expenses[[#This Row],[Actual]]","v":{"v":-8,"d":"($8.00)"}}]
[null,"Internet",{"v":60,"d":"$60.00"},{"v":60,"d":"$60.00"},{"$f":"Expenses[[#This Row],[Projected]]-Expenses[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
[null,"Maintenance / repairs",{"v":0,"d":"$0.00"},{"v":60,"d":"$60.00"},{"$f":"Expenses[[#This Row],[Projected]]-Expenses[[#This Row],[Actual]]","v":{"v":-60,"d":"($60.00)"}}]
[null,"Childcare",{"v":180,"d":"$180.00"},{"v":150,"d":"$150.00"},{"$f":"Expenses[[#This Row],[Projected]]-Expenses[[#This Row],[Actual]]","v":{"v":30,"d":"$30.00"}}]
[null,"Tuition",{"v":250,"d":"$250.00"},{"v":250,"d":"$250.00"},{"$f":"Expenses[[#This Row],[Projected]]-Expenses[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
[null,"Pets",{"v":75,"d":"$75.00"},{"v":80,"d":"$80.00"},{"$f":"Expenses[[#This Row],[Projected]]-Expenses[[#This Row],[Actual]]","v":{"v":-5,"d":"($5.00)"}}]
[null,"Transportation",{"v":280,"d":"$280.00"},{"v":260,"d":"$260.00"},{"$f":"Expenses[[#This Row],[Projected]]-Expenses[[#This Row],[Actual]]","v":{"v":20,"d":"$20.00"}}]
[null,"Personal care",{"v":75,"d":"$75.00"},{"v":65,"d":"$65.00"},{"$f":"Expenses[[#This Row],[Projected]]-Expenses[[#This Row],[Actual]]","v":{"v":10,"d":"$10.00"}}]
[null,"Insurance",{"v":255,"d":"$255.00"},{"v":255,"d":"$255.00"},{"$f":"Expenses[[#This Row],[Projected]]-Expenses[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
[null,"Credit cards",{"v":100,"d":"$100.00"},{"v":100,"d":"$100.00"},{"$f":"Expenses[[#This Row],[Projected]]-Expenses[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
[null,"Loans",{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"Expenses[[#This Row],[Projected]]-Expenses[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
[null,"Taxes",{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"Expenses[[#This Row],[Projected]]-Expenses[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
[null,"Gifts / Charity",{"v":150,"d":"$150.00"},{"v":150,"d":"$150.00"},{"$f":"Expenses[[#This Row],[Projected]]-Expenses[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
[null,"Savings",{"v":225,"d":"$225.00"},{"v":225,"d":"$225.00"},{"$f":"Expenses[[#This Row],[Projected]]-Expenses[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
[null,"Other",{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"Expenses[[#This Row],[Projected]]-Expenses[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Expenses[Projected])","v":{"v":3603,"d":"$3,603.00"}},{"$f":"SUBTOTAL(109,Expenses[Actual])","v":{"v":3655,"d":"$3,655.00"}},{"$f":"SUBTOTAL(109,Expenses[Variance])","v":{"v":-52,"d":"($52.00)"}}]

{"sheet":"Chart data","index":3,"n_rows":7,"n_cols":4,"rows_kept":7,"hidden":true}
[]
[null,"Chart data"]
[]
[null,null,"Projected","Actual"]
[null,"Monthly income",{"$f":"Income[[#Totals],[Projected]]","v":5700},{"$f":"Income[[#Totals],[Actual]]","v":6000}]
[null,"Monthly expenses",{"$f":"Expenses[[#Totals],[Projected]]","v":3603},{"$f":"Expenses[[#Totals],[Actual]]","v":3655}]
[null,"Cash flow",{"$f":"CashFlow[[#Totals],[Projected]]","v":2097},{"$f":"CashFlow[[#Totals],[Actual]]","v":2345}]