{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Monthly budget report","Monthly expenses","Expenses categories","Expenses summary"],"not_rendered":{"charts":1,"images":2,"defined_names":5,"pivot_tables":2},"read":"whole","date_system":"1900"}

{"sheet":"Monthly budget report","index":0,"n_rows":16,"n_cols":11,"rows_kept":16,"merged":[[2,2,2,5]]}
[{"$nulls":10}," "]
[]
[null,null,"Budget\nOverview"]
[]
[null,null,"Overview"]
[{"$nulls":3},"Projected","Actual","Difference"]
[null,null,"Balance",{"$f":"D9-D8","v":{"v":1585,"d":"$ 1,585"}},{"$f":"E9-E8","v":{"v":1740,"d":"$ 1,740"}},{"$f":"E7-D7","v":{"v":155,"d":"$ 155"}}]
[null,null,"Expenses",{"$f":"SUM(TBL_MonthlyExpenses[Projected cost])","v":{"v":7915,"d":"$ 7,915"}},{"$f":"SUM(TBL_MonthlyExpenses[Actual cost])","v":{"v":7860,"d":"$ 7,860"}},{"$f":"E8-D8","v":{"v":-55,"d":"-$ 55"}}]
[null,null,"Total income",{"$f":"SUM(D14:D16)","v":{"v":9500,"d":"$ 9,500"}},{"$f":"SUM(E14:E16)","v":{"v":9600,"d":"$ 9,600"}},{"$f":"E9-D9","v":{"v":100,"d":"$ 100"}},null,"Actual expenses"]
[]
[]
[null,null,"Income summary"]
[{"$nulls":3},"Projected","Actual","Difference"]
[null,null,"Income 1",{"v":6000,"d":"$ 6,000"},{"v":5800,"d":"$ 5,800"},{"$f":"E14-D14","v":{"v":-200,"d":"-$ 200"}}]
[null,null,"Income 2",{"v":1000,"d":"$ 1,000"},{"v":2300,"d":"$ 2,300"},{"$f":"E15-D15","v":{"v":1300,"d":"$ 1,300"}}]
[null,null,"Extra income",{"v":2500,"d":"$ 2,500"},{"v":1500,"d":"$ 1,500"},{"$f":"E16-D16","v":{"v":-1000,"d":"-$ 1,000"}}]

{"sheet":"Monthly expenses","index":1,"n_rows":63,"n_cols":7,"rows_kept":63,"merged":[[1,2,1,4]]}
[]
[null,null,"Monthly expenses"]
[]
[null,null,"Description","Category","Projected cost","Actual cost","Difference"]
[null,null,"Extracurricular activities","Children",{"v":40,"d":"$40.00"},{"v":40,"d":"$40.00"},{"$f":"'Monthly expenses'!$E5-'Monthly expenses'!$F5","v":0}]
[null,null,"Medical","Children",null,null,{"$f":"'Monthly expenses'!$E6-'Monthly expenses'!$F6","v":0}]
[null,null,"School supplies","Children",null,null,{"$f":"'Monthly expenses'!$E7-'Monthly expenses'!$F7","v":0}]
[null,null,"School tuition","Children",{"v":100,"d":"$100.00"},{"v":100,"d":"$100.00"},{"$f":"'Monthly expenses'!$E8-'Monthly expenses'!$F8","v":0}]
[null,null,"Concerts","Entertainment",{"v":50,"d":"$50.00"},{"v":40,"d":"$40.00"},{"$f":"'Monthly expenses'!$E9-'Monthly expenses'!$F9","v":{"v":10,"d":"$10.00"}}]
[null,null,"Live theater","Entertainment",{"v":200,"d":"$200.00"},{"v":150,"d":"$150.00"},{"$f":"'Monthly expenses'!$E10-'Monthly expenses'!$F10","v":{"v":50,"d":"$50.00"}}]
[null,null,"Movies","Entertainment",{"v":50,"d":"$50.00"},{"v":28,"d":"$28.00"},{"$f":"'Monthly expenses'!$E11-'Monthly expenses'!$F11","v":{"v":22,"d":"$22.00"}}]
[null,null,"Music (CDs, downloads, etc.)","Entertainment",{"v":50,"d":"$50.00"},{"v":30,"d":"$30.00"},{"$f":"'Monthly expenses'!$E12-'Monthly expenses'!$F12","v":{"v":20,"d":"$20.00"}}]
[null,null,"Sporting events","Entertainment",0,{"v":40,"d":"$40.00"},{"$f":"'Monthly expenses'!$E13-'Monthly expenses'!$F13","v":{"v":-40,"d":"$(40.00)"}}]
[null,null,"Video (purchase)","Entertainment",{"v":20,"d":"$20.00"},{"v":50,"d":"$50.00"},{"$f":"'Monthly expenses'!$E14-'Monthly expenses'!$F14","v":{"v":-30,"d":"$(30.00)"}}]
[null,null,"Video (rental)","Entertainment",{"v":30,"d":"$30.00"},{"v":20,"d":"$20.00"},{"$f":"'Monthly expenses'!$E15-'Monthly expenses'!$F15","v":{"v":10,"d":"$10.00"}}]
[null,null,"Dining out","Food",{"v":1000,"d":"$1,000.00"},{"v":1200,"d":"$1,200.00"},{"$f":"'Monthly expenses'!$E16-'Monthly expenses'!$F16","v":{"v":-200,"d":"$(200.00)"}}]
[null,null,"Groceries","Food",{"v":100,"d":"$100.00"},{"v":120,"d":"$120.00"},{"$f":"'Monthly expenses'!$E17-'Monthly expenses'!$F17","v":{"v":-20,"d":"$(20.00)"}}]
[null,null,"Charity 1","Gifts and charity",{"v":75,"d":"$75.00"},{"v":100,"d":"$100.00"},{"$f":"'Monthly expenses'!$E18-'Monthly expenses'!$F18","v":{"v":-25,"d":"$(25.00)"}}]
[null,null,"Charity 2","Gifts and charity",{"v":25,"d":"$25.00"},{"v":25,"d":"$25.00"},{"$f":"'Monthly expenses'!$E19-'Monthly expenses'!$F19","v":0}]
[null,null,"Gift 1","Gifts and charity",null,null,{"$f":"'Monthly expenses'!$E20-'Monthly expenses'!$F20","v":0}]
[null,null,"Gift 2","Gifts and charity",null,null,{"$f":"'Monthly expenses'!$E21-'Monthly expenses'!$F21","v":0}]
[null,null,"Cable/satellite","Housing",{"v":100,"d":"$100.00"},{"v":100,"d":"$100.00"},{"$f":"'Monthly expenses'!$E22-'Monthly expenses'!$F22","v":0}]
[null,null,"Electric","Housing",{"v":45,"d":"$45.00"},{"v":50,"d":"$50.00"},{"$f":"'Monthly expenses'!$E23-'Monthly expenses'!$F23","v":{"v":-5,"d":"$(5.00)"}}]
[null,null,"Gas","Housing",{"v":300,"d":"$300.00"},{"v":400,"d":"$400.00"},{"$f":"'Monthly expenses'!$E24-'Monthly expenses'!$F24","v":{"v":-100,"d":"$(100.00)"}}]
[null,null,"House cleaning service","Housing",{"v":200,"d":"$200.00"},null,{"$f":"'Monthly expenses'!$E25-'Monthly expenses'!$F25","v":{"v":200,"d":"$200.00"}}]
[null,null,"Maintenance","Housing",{"v":200,"d":"$200.00"},{"v":150,"d":"$150.00"},{"$f":"'Monthly expenses'!$E26-'Monthly expenses'!$F26","v":{"v":50,"d":"$50.00"}}]
[null,null,"Mortgage/rent","Housing",{"v":1700,"d":"$1,700.00"},{"v":1700,"d":"$1,700.00"},{"$f":"'Monthly expenses'!$E27-'Monthly expenses'!$F27","v":0}]
[null,null,"Natural gas/oil","Housing",null,null,{"$f":"'Monthly expenses'!$E28-'Monthly expenses'!$F28","v":0}]
[null,null,"Internet Service","Housing",{"v":100,"d":"$100.00"},{"v":100,"d":"$100.00"},{"$f":"'Monthly expenses'!$E29-'Monthly expenses'!$F29","v":0}]
[null,null,"Phone (cell)","Housing",{"v":60,"d":"$60.00"},{"v":60,"d":"$60.00"},{"$f":"'Monthly expenses'!$E30-'Monthly expenses'!$F30","v":0}]
[null,null,"Phone (home)","Housing",{"v":35,"d":"$35.00"},{"v":39,"d":"$39.00"},{"$f":"'Monthly expenses'!$E31-'Monthly expenses'!$F31","v":{"v":-4,"d":"$(4.00)"}}]
[null,null,"Supplies","Housing",{"v":40,"d":"$40.00"},{"v":55,"d":"$55.00"},{"$f":"'Monthly expenses'!$E32-'Monthly expenses'!$F32","v":{"v":-15,"d":"$(15.00)"}}]
[null,null,"Waste removal and recycle","Housing",{"v":25,"d":"$25.00"},{"v":22,"d":"$22.00"},{"$f":"'Monthly expenses'!$E33-'Monthly expenses'!$F33","v":{"v":3,"d":"$3.00"}}]
[null,null,"Water and sewer","Housing",{"v":25,"d":"$25.00"},{"v":26,"d":"$26.00"},{"$f":"'Monthly expenses'!$E34-'Monthly expenses'!$F34","v":{"v":-1,"d":"$(1.00)"}}]
[null,null,"Health","Insurance",{"v":400,"d":"$400.00"},{"v":400,"d":"$400.00"},{"$f":"'Monthly expenses'!$E35-'Monthly expenses'!$F35","v":0}]
[null,null,"Home","Insurance",{"v":400,"d":"$400.00"},{"v":400,"d":"$400.00"},{"$f":"'Monthly expenses'!$E36-'Monthly expenses'!$F36","v":0}]
[null,null,"Life","Insurance",{"v":100,"d":"$100.00"},{"v":100,"d":"$100.00"},{"$f":"'Monthly expenses'!$E37-'Monthly expenses'!$F37","v":0}]
[null,null,"Credit Card 1","Loans",{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},{"$f":"'Monthly expenses'!$E38-'Monthly expenses'!$F38","v":0}]
[null,null,"Credit Card 2","Loans",null,null,{"$f":"'Monthly expenses'!$E39-'Monthly expenses'!$F39","v":0}]
[null,null,"Credit Card 3","Loans",null,null,{"$f":"'Monthly expenses'!$E40-'Monthly expenses'!$F40","v":0}]
[null,null,"Personal","Loans",null,null,{"$f":"'Monthly expenses'!$E41-'Monthly expenses'!$F41","v":0}]
[null,null,"Student","Loans",null,null,{"$f":"'Monthly expenses'!$E42-'Monthly expenses'!$F42","v":0}]
[null,null,"Clothing","Personal care",{"v":150,"d":"$150.00"},{"v":140,"d":"$140.00"},{"$f":"'Monthly expenses'!$E43-'Monthly expenses'!$F43","v":{"v":10,"d":"$10.00"}}]
[null,null,"Dry cleaning","Personal care",null,null,{"$f":"'Monthly expenses'!$E44-'Monthly expenses'!$F44","v":0}]
[null,null,"Hair/nails","Personal care",null,null,{"$f":"'Monthly expenses'!$E45-'Monthly expenses'!$F45","v":0}]
[null,null,"Health club","Personal care",null,null,{"$f":"'Monthly expenses'!$E46-'Monthly expenses'!$F46","v":0}]
[null,null,"Medical","Personal care",null,null,{"$f":"'Monthly expenses'!$E47-'Monthly expenses'!$F47","v":0}]
[null,null,"Food","Pets",{"v":150,"d":"$150.00"},{"v":75,"d":"$75.00"},{"$f":"'Monthly expenses'!$E48-'Monthly expenses'!$F48","v":{"v":75,"d":"$75.00"}}]
[null,null,"Grooming","Pets",{"v":20,"d":"$20.00"},{"v":25,"d":"$25.00"},{"$f":"'Monthly expenses'!$E49-'Monthly expenses'!$F49","v":{"v":-5,"d":"$(5.00)"}}]
[null,null,"Medical","Pets",null,null,{"$f":"'Monthly expenses'!$E50-'Monthly expenses'!$F50","v":0}]
[null,null,"Toys","Pets",null,null,{"$f":"'Monthly expenses'!$E51-'Monthly expenses'!$F51","v":0}]
[null,null,"Investment account","Savings",{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},{"$f":"'Monthly expenses'!$E52-'Monthly expenses'!$F52","v":0}]
[null,null,"Retirement account","Savings",null,null,{"$f":"'Monthly expenses'!$E53-'Monthly expenses'!$F53","v":0}]
[null,null,"Federal","Taxes",{"v":300,"d":"$300.00"},{"v":300,"d":"$300.00"},{"$f":"'Monthly expenses'!$E54-'Monthly expenses'!$F54","v":0}]
[null,null,"Local","Taxes",null,null,{"$f":"'Monthly expenses'!$E55-'Monthly expenses'!$F55","v":0}]
[null,null,"State","Taxes",null,null,{"$f":"'Monthly expenses'!$E56-'Monthly expenses'!$F56","v":0}]
[null,null,"Bus/rideshare fare","Transportation",{"v":100,"d":"$100.00"},{"v":150,"d":"$150.00"},{"$f":"'Monthly expenses'!$E57-'Monthly expenses'!$F57","v":{"v":-50,"d":"$(50.00)"}}]
[null,null,"Fuel","Transportation",{"v":450,"d":"$450.00"},{"v":400,"d":"$400.00"},{"$f":"'Monthly expenses'!$E58-'Monthly expenses'!$F58","v":{"v":50,"d":"$50.00"}}]
[null,null,"Insurance","Transportation",{"v":300,"d":"$300.00"},{"v":300,"d":"$300.00"},{"$f":"'Monthly expenses'!$E59-'Monthly expenses'!$F59","v":0}]
[null,null,"Licensing ","Transportation",{"v":25,"d":"$25.00"},{"v":25,"d":"$25.00"},{"$f":"'Monthly expenses'!$E60-'Monthly expenses'!$F60","v":0}]
[null,null,"Maintenance","Transportation",{"v":100,"d":"$100.00"},{"v":50,"d":"$50.00"},{"$f":"'Monthly expenses'!$E61-'Monthly expenses'!$F61","v":{"v":50,"d":"$50.00"}}]
[null,null,"Parking fees","Transportation",null,null,{"$f":"'Monthly expenses'!$E62-'Monthly expenses'!$F62","v":0}]
[null,null,"Vehicle payment","Transportation",{"v":450,"d":"$450.00"},{"v":450,"d":"$450.00"},{"$f":"'Monthly expenses'!$E63-'Monthly expenses'!$F63","v":0}]

{"sheet":"Expenses categories","index":2,"n_rows":17,"n_cols":9,"rows_kept":17}
[{"$nulls":8}," "]
[null,null,"Expense categories"]
[]
[null,null,"Categories","Blank Column"]
[null,null,"Children"]
[null,null,"Entertainment"]
[null,null,"Food"]
[null,null,"Gifts and charity"]
[null,null,"Housing"]
[null,null,"Insurance"]
[null,null,"Loans"]
[null,null,"Personal care"]
[null,null,"Pets"]
[null,null,"Savings"]
[null,null,"Taxes"]
[null,null,"Transportation"]
[null,null,"Total"]

{"sheet":"Expenses summary","index":3,"n_rows":42,"n_cols":15,"rows_kept":42}
[{"$nulls":7}," "]
[null,null,"Expenses summary"]
[]
[null,null,"Expenses","Projected Cost","Actual Cost","Difference "]
[null,null,"Housing",{"v":2830,"d":"$2,830.00"},{"v":2702,"d":"$2,702.00"},{"v":128,"d":"$128.00"}]
[null,null,"Cable/satellite",{"v":100,"d":"$100.00"},{"v":100,"d":"$100.00"},0]
[null,null,"Electric",{"v":45,"d":"$45.00"},{"v":50,"d":"$50.00"},{"v":-5,"d":"$(5.00)"}]
[null,null,"Gas",{"v":300,"d":"$300.00"},{"v":400,"d":"$400.00"},{"v":-100,"d":"$(100.00)"}]
[null,null,"House cleaning service",{"v":200,"d":"$200.00"},null,{"v":200,"d":"$200.00"}]
[null,null,"Internet Service",{"v":100,"d":"$100.00"},{"v":100,"d":"$100.00"},0]
[null,null,"Maintenance",{"v":200,"d":"$200.00"},{"v":150,"d":"$150.00"},{"v":50,"d":"$50.00"}]
[null,null,"Mortgage/rent",{"v":1700,"d":"$1,700.00"},{"v":1700,"d":"$1,700.00"},0]
[null,null,"Natural gas/oil",null,null,0]
[null,null,"Phone (cell)",{"v":60,"d":"$60.00"},{"v":60,"d":"$60.00"},0]
[null,null,"Phone (home)",{"v":35,"d":"$35.00"},{"v":39,"d":"$39.00"},{"v":-4,"d":"$(4.00)"}]
[null,null,"Supplies",{"v":40,"d":"$40.00"},{"v":55,"d":"$55.00"},{"v":-15,"d":"$(15.00)"}]
[null,null,"Waste removal and recycle",{"v":25,"d":"$25.00"},{"v":22,"d":"$22.00"},{"v":3,"d":"$3.00"}]
[null,null,"Water and sewer",{"v":25,"d":"$25.00"},{"v":26,"d":"$26.00"},{"v":-1,"d":"$(1.00)"}]
[null,null,"Transportation",{"v":1425,"d":"$1,425.00"},{"v":1375,"d":"$1,375.00"},{"v":50,"d":"$50.00"}]
[null,null,"Bus/rideshare fare",{"v":100,"d":"$100.00"},{"v":150,"d":"$150.00"},{"v":-50,"d":"$(50.00)"}]
[null,null,"Fuel",{"v":450,"d":"$450.00"},{"v":400,"d":"$400.00"},{"v":50,"d":"$50.00"}]
[null,null,"Insurance",{"v":300,"d":"$300.00"},{"v":300,"d":"$300.00"},0]
[null,null,"Licensing",{"v":25,"d":"$25.00"},{"v":25,"d":"$25.00"},0]
[null,null,"Maintenance",{"v":100,"d":"$100.00"},{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"}]
[null,null,"Parking fees",null,null,0]
[null,null,"Vehicle payment",{"v":450,"d":"$450.00"},{"v":450,"d":"$450.00"},0]
[null,null,"Food",{"v":1100,"d":"$1,100.00"},{"v":1320,"d":"$1,320.00"},{"v":-220,"d":"$(220.00)"}]
[null,null,"Dining out",{"v":1000,"d":"$1,000.00"},{"v":1200,"d":"$1,200.00"},{"v":-200,"d":"$(200.00)"}]
[null,null,"Groceries",{"v":100,"d":"$100.00"},{"v":120,"d":"$120.00"},{"v":-20,"d":"$(20.00)"}]
[null,null,"Insurance",{"v":900,"d":"$900.00"},{"v":900,"d":"$900.00"},0]
[null,null,"Health",{"v":400,"d":"$400.00"},{"v":400,"d":"$400.00"},0]
[null,null,"Home",{"v":400,"d":"$400.00"},{"v":400,"d":"$400.00"},0]
[null,null,"Life",{"v":100,"d":"$100.00"},{"v":100,"d":"$100.00"},0]
[null,null,"Entertainment",{"v":400,"d":"$400.00"},{"v":358,"d":"$358.00"},{"v":42,"d":"$42.00"}]
[null,null,"Taxes",{"v":300,"d":"$300.00"},{"v":300,"d":"$300.00"},0]
[null,null,"Savings",{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},0]
[null,null,"Loans",{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},0]
[null,null,"Children",{"v":140,"d":"$140.00"},{"v":140,"d":"$140.00"},0,{"$nulls":8}," "]
[null,null,"Personal care",{"v":150,"d":"$150.00"},{"v":140,"d":"$140.00"},{"v":10,"d":"$10.00"}]
[null,null,"Gifts and charity",{"v":100,"d":"$100.00"},{"v":125,"d":"$125.00"},{"v":-25,"d":"$(25.00)"}]
[null,null,"Pets",{"v":170,"d":"$170.00"},{"v":100,"d":"$100.00"},{"v":70,"d":"$70.00"}]
[null,null,"Grand Total",{"v":7915,"d":"$7,915.00"},{"v":7860,"d":"$7,860.00"},{"v":55,"d":"$55.00"}]