{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Roommate budget"],"not_rendered":{"charts":1,"images":2,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Roommate budget","index":0,"n_rows":21,"n_cols":5,"rows_kept":21,"merged":[[0,1,0,4]]}
[null,"HOUSEHOLD EXPENSE BUDGET"]
[]
[null,"Sara",{"$f":"SUMIFS(Expenses[AMOUNT],Expenses[WHO PAYS?],B3)","v":{"v":360,"d":"$360"}}]
[null,"Nadia",{"$f":"SUMIFS(Expenses[AMOUNT],Expenses[WHO PAYS?],B4)","v":{"v":500,"d":"$500"}}]
[null,"Vanessa",{"$f":"SUMIFS(Expenses[AMOUNT],Expenses[WHO PAYS?],B5)","v":{"v":200,"d":"$200"}}]
[null,"Zekey",{"$f":"SUMIFS(Expenses[AMOUNT],Expenses[WHO PAYS?],B6)","v":{"v":330,"d":"$330"}}]
[]
[null,"TOTAL EXPENSES",{"$f":"SUM(C3:C6)","v":{"v":1390,"d":"$1,390.00"}},{"$f":"IF(C8<>TotalExpenses,\"Total not balanced. Check spelling of roommate names in the table and to the left of the chart. Budget is limited to 4 roommates.\",\"\")","v":""}]
[]
[]
[null,"EXPENSE","AMOUNT","WHO PAYS?","NOTES"]
[null,"rent",{"v":360,"d":"$360.00"},"Sara"]
[null,"rent",{"v":350,"d":"$350.00"},"Nadia"]
[null,"electricity",{"v":200,"d":"$200.00"},"Vanessa"]
[null,"groceries",{"v":200,"d":"$200.00"},"Zekey"]
[null,"house phone",{"v":25,"d":"$25.00"},"Zekey"]
[null,"internet service",{"v":30,"d":"$30.00"},"Zekey"]
[null,"cable/satellite",{"v":45,"d":"$45.00"},"Zekey"]
[null,"sewer/water",{"v":20,"d":"$20.00"},"Zekey"]
[null,"propane/natural gas",{"v":150,"d":"$150.00"},"Nadia"]
[null,"trash removal",{"v":10,"d":"$10.00"},"Zekey"]