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

{"sheet":"Monthly Food Budget","index":0,"n_rows":10,"n_cols":8,"rows_kept":10,"merged":[[3,4,3,6],[5,1,5,3],[5,4,5,6],[7,1,7,2],[8,1,8,2],[9,1,9,2]]}
[{"$nulls":7}," "]
[]
[null,"Budget for the month of",null,null,{"$f":"\"Percentage of budget already spent:  \"&TEXT(E4,\"0%\")","v":"Percentage of budget already spent:  35%"}]
[null,{"$f":"TEXT(NOW(),\"mmmm\")","v":"May"},null,null,{"$f":"E6/B6","v":0.3508695652173913}]
[null,"Total food budget for the month",null,null,"Amount already spent"]
[null,{"$f":"SUM(D9:G9)","v":{"v":575,"d":"£575"}},null,null,{"$f":"SUM(D10:G10)","v":{"v":201.75,"d":"£202"}}]
[]
[{"$nulls":3},"Groceries","Eating Out","Snacks","Others"]
[null,"Monthly Budget",null,{"v":325,"d":"£325"},{"v":100,"d":"£100"},{"v":100,"d":"£100"},{"v":50,"d":"£50"}]
[null,"Actual Expenses",null,{"$f":"SUMIF(Table_ActualFoodExpenses[Category],'Monthly Food Budget'!D8,Table_ActualFoodExpenses[Cost])","v":{"v":175,"d":"£175"}},{"$f":"SUMIF(Table_ActualFoodExpenses[Category],'Monthly Food Budget'!E8,Table_ActualFoodExpenses[Cost])","v":{"v":0,"d":"£0"}},{"$f":"SUMIF(Table_ActualFoodExpenses[Category],'Monthly Food Budget'!F8,Table_ActualFoodExpenses[Cost])","v":{"v":16.75,"d":"£17"}},{"$f":"SUMIF(Table_ActualFoodExpenses[Category],'Monthly Food Budget'!G8,Table_ActualFoodExpenses[Cost])","v":{"v":10,"d":"£10"}}]

{"sheet":"Actual Expenses","index":1,"n_rows":6,"n_cols":6,"rows_kept":6}
[null,"Actual Food Expenses",{"$nulls":3}," "]
[null,"Date","Cost","Category","Remarks"]
[null,{"$f":"DATE(YEAR(NOW()),MONTH(NOW()),F3)","v":"2022-05-01"},{"v":175,"d":"£175.00"},"Groceries",null,1]
[null,"2022-05-05",{"v":4.75,"d":"£4.75"},"Snacks",null,5]
[null,"2022-05-07",{"v":12,"d":"£12.00"},"Snacks",null,7]
[null,"2022-05-08",{"v":10,"d":"£10.00"},"Others",null,8]