{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Summary","Present list"],"not_rendered":{"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"Summary","index":0,"n_rows":11,"n_cols":6,"rows_kept":11,"merged":[[0,1,2,1],[0,2,2,3],[3,1,3,2]]}
[null,"christmas","PRESENT TRACKER",null,"TOTAL BUDGET",{"v":500,"d":"£500.00"}]
[{"$nulls":4},"SPENT",{"$f":"IFERROR(SUMIFS(Presents[COST],Presents[PURCHASED],\"Yes\"),\"\")","v":{"v":283,"d":"£283.00"}}]
[{"$nulls":4},"REMAINING BUDGET",{"$f":"IFERROR(TotalBudget-F2,\"\")","v":{"v":217,"d":"£217.00"}}]
[null,"Adjust budget if % of Planned budget exceeds 100% (Yes/No)?",null,"Yes"]
[null,"RECIPIENT","PLANNED % OF BUDGET","REMAINING MONEY ALLOCATED","PLANNED NO. OF PRESENTS","PRESENTS \nREMAINING"]
[null,"Adam",{"v":0.3,"d":"30%"},{"$f":"IFERROR(IF(Adjust_Budget=\"Yes\",Allocated_Money_Remaining-SUMIFS(Presents[COST],Presents[RECIPIENT],Recipients[[#This Row],[RECIPIENT]]),(TotalBudget*Recipients[[#This Row],[PLANNED % OF BUDGET]])-SUMIFS(Presents[COST],Presents[RECIPIENT],Recipients[[#This Row],[RECIPIENT]])),\"\")","v":{"v":45,"d":"£45.00"}},3,{"$f":"IFERROR(Recipients[[#This Row],[PLANNED NO. OF PRESENTS]]-COUNTIFS(Presents[RECIPIENT],Recipients[[#This Row],[RECIPIENT]]), \"\")","v":1}]
[null,"Jenny",{"v":0.3,"d":"30%"},{"$f":"IFERROR(IF(Adjust_Budget=\"Yes\",Allocated_Money_Remaining-SUMIFS(Presents[COST],Presents[RECIPIENT],Recipients[[#This Row],[RECIPIENT]]),(TotalBudget*Recipients[[#This Row],[PLANNED % OF BUDGET]])-SUMIFS(Presents[COST],Presents[RECIPIENT],Recipients[[#This Row],[RECIPIENT]])),\"\")","v":{"v":54,"d":"£54.00"}},3,{"$f":"IFERROR(Recipients[[#This Row],[PLANNED NO. OF PRESENTS]]-COUNTIFS(Presents[RECIPIENT],Recipients[[#This Row],[RECIPIENT]]), \"\")","v":1}]
[null,"Brian",{"v":0.2,"d":"20%"},{"$f":"IFERROR(IF(Adjust_Budget=\"Yes\",Allocated_Money_Remaining-SUMIFS(Presents[COST],Presents[RECIPIENT],Recipients[[#This Row],[RECIPIENT]]),(TotalBudget*Recipients[[#This Row],[PLANNED % OF BUDGET]])-SUMIFS(Presents[COST],Presents[RECIPIENT],Recipients[[#This Row],[RECIPIENT]])),\"\")","v":{"v":11,"d":"£11.00"}},2,{"$f":"IFERROR(Recipients[[#This Row],[PLANNED NO. OF PRESENTS]]-COUNTIFS(Presents[RECIPIENT],Recipients[[#This Row],[RECIPIENT]]), \"\")","v":1}]
[null,"Suzanne",{"v":0.1,"d":"10%"},{"$f":"IFERROR(IF(Adjust_Budget=\"Yes\",Allocated_Money_Remaining-SUMIFS(Presents[COST],Presents[RECIPIENT],Recipients[[#This Row],[RECIPIENT]]),(TotalBudget*Recipients[[#This Row],[PLANNED % OF BUDGET]])-SUMIFS(Presents[COST],Presents[RECIPIENT],Recipients[[#This Row],[RECIPIENT]])),\"\")","v":{"v":-1,"d":"-£1.00"}},1,{"$f":"IFERROR(Recipients[[#This Row],[PLANNED NO. OF PRESENTS]]-COUNTIFS(Presents[RECIPIENT],Recipients[[#This Row],[RECIPIENT]]), \"\")","v":0}]
[null,"Martin",{"v":0.1,"d":"10%"},{"$f":"IFERROR(IF(Adjust_Budget=\"Yes\",Allocated_Money_Remaining-SUMIFS(Presents[COST],Presents[RECIPIENT],Recipients[[#This Row],[RECIPIENT]]),(TotalBudget*Recipients[[#This Row],[PLANNED % OF BUDGET]])-SUMIFS(Presents[COST],Presents[RECIPIENT],Recipients[[#This Row],[RECIPIENT]])),\"\")","v":{"v":0,"d":"£0.00"}},1,{"$f":"IFERROR(Recipients[[#This Row],[PLANNED NO. OF PRESENTS]]-COUNTIFS(Presents[RECIPIENT],Recipients[[#This Row],[RECIPIENT]]), \"\")","v":0}]
[null,"Total",{"$f":"SUM(Recipients[PLANNED % OF BUDGET])","v":{"v":1,"d":"100%"}},{"$f":"IFERROR(SUM(Recipients[REMAINING MONEY ALLOCATED]),\"\")","v":{"v":109,"d":"£109.00"}},{"$f":"SUM(Recipients[PLANNED NO. OF PRESENTS])","v":10},{"$f":"SUM(Recipients[PRESENTS \nREMAINING])","v":3}]

{"sheet":"Present list","index":1,"n_rows":9,"n_cols":6,"rows_kept":9}
[null,"christmas","PRESENT LIST"]
[null,"RECIPIENT","PRESENT","COST","PURCHASED","WRAPPED"]
[null,"Jenny","Doll’s house",{"v":36,"d":"£36.00"},"Yes","Yes"]
[null,"Brian","Bicycle",{"v":89,"d":"£89.00"},"Yes"]
[null,"Suzanne","Scrapbook materials",{"v":51,"d":"£51.00"},"Yes","Yes"]
[null,"Adam","Toy train",{"v":48,"d":"£48.00"}]
[null,"Adam","Jumper",{"v":57,"d":"£57.00"},"Yes"]
[null,"Martin","Gift card",{"v":50,"d":"£50.00"},"Yes","Yes"]
[null,"Jenny","Dress",{"v":60,"d":"£60.00"}]