{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Sheet1","Budget overview","Budget summary","Monthly expenses","Additional data"],"not_rendered":{"charts":1,"defined_names":7,"pivot_tables":2},"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":12,"n_cols":3,"rows_kept":12,"hidden":true}
["Calculated Field"]
["Solve Order","Field","Formula"]
[]
["Calculated Item"]
["Solve Order","Item","Formula"]
[]
[]
["Note:","When a cell is updated by more than one formula,"]
[null,"the value is set by the formula with the last solve order."]
[]
[null,"To change the solve order for multiple calculated items or fields,"]
[null,"on the Options tab, in the Calculations group, click Fields, Items, & Sets, and then click Solve Order."]

{"sheet":"Budget overview","index":1,"n_rows":16,"n_cols":8,"rows_kept":16,"merged":[[0,1,0,6],[1,1,1,2],[3,1,3,2],[4,1,4,2],[5,1,5,2]]}
[null,"BUDGET OVERVIEW",{"$nulls":5}," "]
[null,"Balance"]
[]
[null,"Projected balance",null,{"$f":"Projected_Income-Projected_Expenses","v":{"v":1585,"d":"$1,585"}},null,"Projected minus expenses"]
[null,"Actual balance ",null,{"$f":"Actual_Income-Actual_Expenses","v":{"v":1740,"d":"$1,740"}},null,"Actual minus expenses"]
[null,"Difference",null,{"$f":"D5-D4","v":{"v":155,"d":"$155"}},null,"Actual minus projected"]
[]
[null,"Income",{"$nulls":3},"Expenses"]
[]
[null,null,"Projected","Actual",null,"Projected","Actual"]
[null,"Income 1",{"v":6000,"d":"$6,000"},{"v":5800,"d":"$5,800"},null,{"$f":"SUM(Monthly_Expenses_Table[Projected cost])","v":{"v":7915,"d":"$7,915"}},{"$f":"SUM(Monthly_Expenses_Table[Actual cost])","v":{"v":7860,"d":"$7,860"}}]
[null,"Income 2",{"v":1000,"d":"$1,000"},{"v":2300,"d":"$2,300"}]
[null,"Extra income",{"v":2500,"d":"$2,500"},{"v":1500,"d":"$1,500"}]
[null,"Total income",{"$f":"SUM(C11:C13)","v":{"v":9500,"d":"$9,500"}},{"$f":"SUM(D11:D13)","v":{"v":9600,"d":"$9,600"}}]
[]
[null,"Actual expenses breakdown"]

{"sheet":"Budget summary","index":2,"n_rows":45,"n_cols":7,"rows_kept":45,"merged":[[0,1,0,4]]}
[null,"BUDGET SUMMARY",{"$nulls":4}," "]
[]
[null,"Categories","Projected Cost ","Actual Cost ","Difference "]
[null,"Children",{"v":140,"d":"$140"},{"v":140,"d":"$140"},{"v":0,"d":"$0"}]
[null,"Extracurricular activities",{"v":40,"d":"$40"},{"v":40,"d":"$40"},{"v":0,"d":"$0"}]
[null,"Medical",null,null,{"v":0,"d":"$0"}]
[null,"School supplies",null,null,{"v":0,"d":"$0"}]
[null,"School tuition",{"v":100,"d":"$100"},{"v":100,"d":"$100"},{"v":0,"d":"$0"}]
[]
[null,"Entertainment",{"v":400,"d":"$400"},{"v":358,"d":"$358"},{"v":42,"d":"$42"}]
[null,"Concerts",{"v":50,"d":"$50"},{"v":40,"d":"$40"},{"v":10,"d":"$10"}]
[null,"Live theater",{"v":200,"d":"$200"},{"v":150,"d":"$150"},{"v":50,"d":"$50"}]
[null,"Movies",{"v":50,"d":"$50"},{"v":28,"d":"$28"},{"v":22,"d":"$22"}]
[null,"Music (CDs, downloads, etc.)",{"v":50,"d":"$50"},{"v":30,"d":"$30"},{"v":20,"d":"$20"}]
[null,"Sporting events",{"v":0,"d":"$0"},{"v":40,"d":"$40"},{"v":-40,"d":"($40)"}]
[null,"Video/DVD (purchase)",{"v":20,"d":"$20"},{"v":50,"d":"$50"},{"v":-30,"d":"($30)"}]
[null,"Video/DVD (rental)",{"v":30,"d":"$30"},{"v":20,"d":"$20"},{"v":10,"d":"$10"}]
[]
[null,"Food",{"v":1100,"d":"$1,100"},{"v":1320,"d":"$1,320"},{"v":-220,"d":"($220)"}]
[]
[null,"Gifts and charity",{"v":100,"d":"$100"},{"v":125,"d":"$125"},{"v":-25,"d":"($25)"}]
[null,"Charity 1",{"v":75,"d":"$75"},{"v":100,"d":"$100"},{"v":-25,"d":"($25)"}]
[null,"Charity 2",{"v":25,"d":"$25"},{"v":25,"d":"$25"},{"v":0,"d":"$0"}]
[null,"Gift 1",null,null,{"v":0,"d":"$0"}]
[null,"Gift 2",null,null,{"v":0,"d":"$0"}]
[]
[null,"Housing",{"v":2830,"d":"$2,830"},{"v":2702,"d":"$2,702"},{"v":-72,"d":"($72)"}]
[]
[null,"Insurance",{"v":900,"d":"$900"},{"v":900,"d":"$900"},{"v":0,"d":"$0"}]
[]
[null,"Loans",{"v":200,"d":"$200"},{"v":200,"d":"$200"},{"v":0,"d":"$0"}]
[]
[null,"Personal care",{"v":150,"d":"$150"},{"v":140,"d":"$140"},{"v":10,"d":"$10"}]
[]
[null,"Pets",{"v":170,"d":"$170"},{"v":100,"d":"$100"},{"v":70,"d":"$70"}]
[]
[null,"Taxes",{"v":300,"d":"$300"},{"v":300,"d":"$300"},{"v":0,"d":"$0"}]
[]
[null,"Transportation",{"v":1425,"d":"$1,425"},{"v":1375,"d":"$1,375"},{"v":50,"d":"$50"}]
[]
[null,"Savings",{"v":200,"d":"$200"},{"v":200,"d":"$200"},{"v":0,"d":"$0"}]
[null,"Investment account",{"v":200,"d":"$200"},{"v":200,"d":"$200"},{"v":0,"d":"$0"}]
[null,"Retirement account",null,null,{"v":0,"d":"$0"}]
[]
[null,"Grand Total",{"v":7915,"d":"$7,915"},{"v":7860,"d":"$7,860"},{"v":-145,"d":"($145)"}]

{"sheet":"Monthly expenses","index":3,"n_rows":61,"n_cols":8,"rows_kept":61}
[null,"MONTHLY EXPENSES",{"$nulls":5}," "]
[null,"Description","Category","Projected cost","Actual cost","Difference","Actual cost overview"]
[null,"Extracurricular activities","Children",{"v":40,"d":"$40"},{"v":40,"d":"$40"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":{"v":0,"d":"$0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":40}]
[null,"Medical","Children",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":0}]
[null,"School supplies","Children",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":0}]
[null,"School tuition","Children",{"v":100,"d":"$100"},{"v":100,"d":"$100"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":{"v":0,"d":"$0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":100}]
[null,"Concerts","Entertainment",{"v":50,"d":"$50"},{"v":40,"d":"$40"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":{"v":10,"d":"$10"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":40}]
[null,"Live theater","Entertainment",{"v":200,"d":"$200"},{"v":150,"d":"$150"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":{"v":50,"d":"$50"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":150}]
[null,"Movies","Entertainment",{"v":50,"d":"$50"},{"v":28,"d":"$28"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":{"v":22,"d":"$22"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":28}]
[null,"Music (CDs, downloads, etc.)","Entertainment",{"v":50,"d":"$50"},{"v":30,"d":"$30"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":{"v":20,"d":"$20"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":30}]
[null,"Sporting events","Entertainment",{"v":0,"d":"$0"},{"v":40,"d":"$40"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":{"v":-40,"d":"($40)"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":40}]
[null,"Video/DVD (purchase)","Entertainment",{"v":20,"d":"$20"},{"v":50,"d":"$50"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":{"v":-30,"d":"($30)"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":50}]
[null,"Video/DVD (rental)","Entertainment",{"v":30,"d":"$30"},{"v":20,"d":"$20"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":{"v":10,"d":"$10"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":20}]
[null,"Dining out","Food",{"v":1000,"d":"$1,000"},{"v":1200,"d":"$1,200"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":{"v":-200,"d":"($200)"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":1200}]
[null,"Groceries","Food",{"v":100,"d":"$100"},{"v":120,"d":"$120"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":{"v":-20,"d":"($20)"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":120}]
[null,"Charity 1","Gifts and charity",{"v":75,"d":"$75"},{"v":100,"d":"$100"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":{"v":-25,"d":"($25)"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":100}]
[null,"Charity 2","Gifts and charity",{"v":25,"d":"$25"},{"v":25,"d":"$25"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":{"v":0,"d":"$0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":25}]
[null,"Gift 1","Gifts and charity",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":0}]
[null,"Gift 2","Gifts and charity",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":0}]
[null,"Cable/satellite","Housing",{"v":100,"d":"$100"},{"v":100,"d":"$100"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":{"v":0,"d":"$0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":100}]
[null,"Electric","Housing",{"v":45,"d":"$45"},{"v":50,"d":"$50"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":{"v":-5,"d":"($5)"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":50}]
[null,"Gas","Housing",{"v":300,"d":"$300"},{"v":400,"d":"$400"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":{"v":-100,"d":"($100)"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":400}]
[null,"House cleaning service","Housing",{"v":200,"d":"$200"},null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":0}]
[null,"Maintenance","Housing",{"v":200,"d":"$200"},{"v":150,"d":"$150"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":{"v":50,"d":"$50"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":150}]
[null,"Mortgage or rent","Housing",{"v":1700,"d":"$1,700"},{"v":1700,"d":"$1,700"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":{"v":0,"d":"$0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":1700}]
[null,"Natural gas/oil","Housing",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":0}]
[null,"Internet service","Housing",{"v":100,"d":"$100"},{"v":100,"d":"$100"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":{"v":0,"d":"$0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":100}]
[null,"Cell phone","Housing",{"v":60,"d":"$60"},{"v":60,"d":"$60"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":{"v":0,"d":"$0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":60}]
[null,"Home phone","Housing",{"v":35,"d":"$35"},{"v":39,"d":"$39"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":{"v":-4,"d":"($4)"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":39}]
[null,"Supplies","Housing",{"v":40,"d":"$40"},{"v":55,"d":"$55"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":{"v":-15,"d":"($15)"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":55}]
[null,"Waste removal and recycle","Housing",{"v":25,"d":"$25"},{"v":22,"d":"$22"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":{"v":3,"d":"$3"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":22}]
[null,"Water and sewer","Housing",{"v":25,"d":"$25"},{"v":26,"d":"$26"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":{"v":-1,"d":"($1)"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":26}]
[null,"Health","Insurance",{"v":400,"d":"$400"},{"v":400,"d":"$400"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":{"v":0,"d":"$0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":400}]
[null,"Home","Insurance",{"v":400,"d":"$400"},{"v":400,"d":"$400"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":{"v":0,"d":"$0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":400}]
[null,"Life","Insurance",{"v":100,"d":"$100"},{"v":100,"d":"$100"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":{"v":0,"d":"$0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":100}]
[null,"Credit card 1","Loans",{"v":200,"d":"$200"},{"v":200,"d":"$200"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":{"v":0,"d":"$0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":200}]
[null,"Credit card 2","Loans",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":0}]
[null,"Credit card 3","Loans",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":0}]
[null,"Personal","Loans",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":0}]
[null,"Student","Loans",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":0}]
[null,"Clothing","Personal care",{"v":150,"d":"$150"},{"v":140,"d":"$140"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":{"v":10,"d":"$10"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":140}]
[null,"Dry cleaning","Personal care",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":0}]
[null,"Hair/nails","Personal care",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":0}]
[null,"Health club","Personal care",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":0}]
[null,"Medical","Personal care",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":0}]
[null,"Food","Pets",{"v":150,"d":"$150"},{"v":75,"d":"$75"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":{"v":75,"d":"$75"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":75}]
[null,"Grooming","Pets",{"v":20,"d":"$20"},{"v":25,"d":"$25"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":{"v":-5,"d":"($5)"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":25}]
[null,"Medical","Pets",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":0}]
[null,"Toys","Pets",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":0}]
[null,"Investment account","Savings",{"v":200,"d":"$200"},{"v":200,"d":"$200"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":{"v":0,"d":"$0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":200}]
[null,"Retirement account","Savings",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":0}]
[null,"Federal","Taxes",{"v":300,"d":"$300"},{"v":300,"d":"$300"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":{"v":0,"d":"$0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":300}]
[null,"Local","Taxes",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":0}]
[null,"State","Taxes",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":0}]
[null,"Bus or rideshare","Transportation",{"v":100,"d":"$100"},{"v":150,"d":"$150"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":{"v":-50,"d":"($50)"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":150}]
[null,"Fuel","Transportation",{"v":450,"d":"$450"},{"v":400,"d":"$400"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":{"v":50,"d":"$50"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":400}]
[null,"Insurance","Transportation",{"v":300,"d":"$300"},{"v":300,"d":"$300"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":{"v":0,"d":"$0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":300}]
[null,"Licensing ","Transportation",{"v":25,"d":"$25"},{"v":25,"d":"$25"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":{"v":0,"d":"$0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":25}]
[null,"Maintenance","Transportation",{"v":100,"d":"$100"},{"v":50,"d":"$50"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":{"v":50,"d":"$50"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":50}]
[null,"Parking fees","Transportation",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":0}]
[null,"Vehicle payment","Transportation",{"v":450,"d":"$450"},{"v":450,"d":"$450"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected cost]]-Monthly_Expenses_Table[[#This Row],[Actual cost]])","v":{"v":0,"d":"$0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual cost]]","v":450}]

{"sheet":"Additional data","index":4,"n_rows":17,"n_cols":9,"rows_kept":17}
[null,"ADDITIONAL DATA",{"$nulls":3}," "]
[null,"PivotTable for budget chart",null,null,"Category list"]
[]
[null,"Categories","Cost",null,"To add a category, type below",{"$nulls":3},"`"]
[null,"Pets",{"v":100,"d":"$100"},null,"Children"]
[null,"Gifts and charity",{"v":125,"d":"$125"},null,"Entertainment"]
[null,"Children",{"v":140,"d":"$140"},null,"Food"]
[null,"Personal care",{"v":140,"d":"$140"},null,"Gifts and charity"]
[null,"Savings",{"v":200,"d":"$200"},null,"Housing"]
[null,"Loans",{"v":200,"d":"$200"},null,"Insurance"]
[null,"Taxes",{"v":300,"d":"$300"},null,"Loans"]
[null,"Entertainment",{"v":358,"d":"$358"},null,"Personal care"]
[null,"Insurance",{"v":900,"d":"$900"},null,"Pets"]
[null,"Food",{"v":1320,"d":"$1,320"},null,"Savings"]
[null,"Transportation",{"v":1375,"d":"$1,375"},null,"Taxes"]
[null,"Housing",{"v":2702,"d":"$2,702"},null,"Transportation"]
[null,"Grand Total",{"v":7860,"d":"$7,860"}]