{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Monthly Budget Report","Monthly Expenses"],"not_rendered":{"charts":1,"images":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Monthly Budget Report","index":0,"n_rows":17,"n_cols":7,"rows_kept":17,"merged":[[0,1,0,8],[7,1,10,1],[7,5,10,5],[7,6,10,7],[12,1,16,1],[12,5,16,5],[12,6,16,7]]}
[null,"Budget Overview"]
[null,"Balance"]
[null,"Projected Balance","(Projected  minus expenses)",{"$nulls":3},{"$f":"D17-G13","v":{"v":1585,"d":"$1,585"}}]
[null,"Actual Balance ","(Actual  minus expenses)",{"$nulls":3},{"$f":"D11-G8","v":{"v":1740,"d":"$1,740"}}]
[null,"Difference","(Actual minus projected)",{"$nulls":3},{"$f":"G4-G3","v":{"v":155,"d":"$155"}}]
[]
[null,"Income",{"$nulls":3},"Expenses"]
[null,"ACTUAL","Income 1",{"v":5800,"d":"$5,800"},null,"ACTUAL",{"$f":"'Monthly Expenses'!D16","v":{"v":7860,"d":"$7,860"}}]
[null,null,"Income 2",{"v":2300,"d":"$2,300"}]
[null,null,"Extra income",{"v":1500,"d":"$1,500"}]
[null,null,"Total income",{"$f":"SUM(D8:D10)","v":{"v":9600,"d":"$9,600"}}]
[]
[null,"PROJECTED",{"$nulls":3},"PROJECTED",{"$f":"'Monthly Expenses'!C16","v":{"v":7915,"d":"$7,915"}}]
[null,null,"Income 1",{"v":6000,"d":"$6,000"}]
[null,null,"Income 2",{"v":1000,"d":"$1,000"}]
[null,null,"Extra income",{"v":2500,"d":"$2,500"}]
[null,null,"Total income",{"$f":"SUM(D14:D16)","v":{"v":9500,"d":"$9,500"}}]

{"sheet":"Monthly Expenses","index":1,"n_rows":16,"n_cols":5,"rows_kept":16,"merged":[[0,0,0,4],[1,2,1,4]]}
["Monthly Expenses"]
[null,null,"Values"]
[null,"Category","Projected Cost ","Actual Cost ","Difference "]
[null,"Children",{"v":140,"d":"$140"},{"v":140,"d":"$140"},{"$f":"C4-D4","v":{"v":0,"d":"$0"}}]
[null,"Entertainment",{"v":400,"d":"$400"},{"v":358,"d":"$358"},{"$f":"C5-D5","v":{"v":42,"d":"$42"}}]
[null,"Food",{"v":1100,"d":"$1,100"},{"v":1320,"d":"$1,320"},{"$f":"C6-D6","v":{"v":-220,"d":"-$220"}}]
[null,"Gifts and Charity",{"v":100,"d":"$100"},{"v":125,"d":"$125"},{"$f":"C7-D7","v":{"v":-25,"d":"-$25"}}]
[null,"Housing",{"v":2830,"d":"$2,830"},{"v":2702,"d":"$2,702"},{"$f":"C8-D8","v":{"v":128,"d":"$128"}}]
[null,"Insurance",{"v":900,"d":"$900"},{"v":900,"d":"$900"},{"$f":"C9-D9","v":{"v":0,"d":"$0"}}]
[null,"Loans",{"v":200,"d":"$200"},{"v":200,"d":"$200"},{"$f":"C10-D10","v":{"v":0,"d":"$0"}}]
[null,"Personal Care",{"v":150,"d":"$150"},{"v":140,"d":"$140"},{"$f":"C11-D11","v":{"v":10,"d":"$10"}}]
[null,"Pets",{"v":170,"d":"$170"},{"v":100,"d":"$100"},{"$f":"C12-D12","v":{"v":70,"d":"$70"}}]
[null,"Savings or Investments",{"v":200,"d":"$200"},{"v":200,"d":"$200"},{"$f":"C13-D13","v":{"v":0,"d":"$0"}}]
[null,"Taxes",{"v":300,"d":"$300"},{"v":300,"d":"$300"},{"$f":"C14-D14","v":{"v":0,"d":"$0"}}]
[null,"Transportation",{"v":1425,"d":"$1,425"},{"v":1375,"d":"$1,375"},{"$f":"C15-D15","v":{"v":50,"d":"$50"}}]
[null,"Grand Total",{"$f":"SUM(C4:C15)","v":{"v":7915,"d":"$7,915"}},{"$f":"SUM(D4:D15)","v":{"v":7860,"d":"$7,860"}},{"$f":"C16-D16","v":{"v":55,"d":"$55"}}]