{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Summary","Gift List"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":10,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Summary","index":0,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,2,1],[0,2,2,3],[3,1,3,2]]}
[null,"holiday","GIFT TRACKER",null,"TOTAL BUDGET",500]
[null,null,null,null,"SPENT",{"$f":"IFERROR(SUMIFS(Gifts[COST],Gifts[PURCHASED],\"Yes\"),\"\")","v":283}]
[null,null,null,null,"REMAINING BUDGET",{"$f":"IFERROR(TotalBudget-F2,\"\")","v":217}]
[null,"Adjust budget if % of Planned Budget exceeds 100% (Yes/No)?",null,"Yes"]
[null,"RECIPIENT","PLANNED % OF BUDGET","REMAINING MONEY ALLOCATED","PLANNED # OF GIFTS","GIFTS REMAINING"]
[null,"Adam",0.3,{"$f":"IFERROR(IF(Adjust_Budget=\"Yes\",Allocated_Money_Remaining-SUMIFS(Gifts[COST],Gifts[RECIPIENT],Recipients[[#This Row],[RECIPIENT]]),(TotalBudget*Recipients[[#This Row],[PLANNED % OF BUDGET]])-SUMIFS(Gifts[COST],Gifts[RECIPIENT],Recipients[[#This Row],[RECIPIENT]])),\"\")","v":45},3,{"$f":"IFERROR(Recipients[[#This Row],[PLANNED '# OF GIFTS]]-COUNTIFS(Gifts[RECIPIENT],Recipients[[#This Row],[RECIPIENT]]), \"\")","v":1}]
[null,"Jenny",0.3,{"$f":"IFERROR(IF(Adjust_Budget=\"Yes\",Allocated_Money_Remaining-SUMIFS(Gifts[COST],Gifts[RECIPIENT],Recipients[[#This Row],[RECIPIENT]]),(TotalBudget*Recipients[[#This Row],[PLANNED % OF BUDGET]])-SUMIFS(Gifts[COST],Gifts[RECIPIENT],Recipients[[#This Row],[RECIPIENT]])),\"\")","v":54},3,{"$f":"IFERROR(Recipients[[#This Row],[PLANNED '# OF GIFTS]]-COUNTIFS(Gifts[RECIPIENT],Recipients[[#This Row],[RECIPIENT]]), \"\")","v":1}]
[null,"Brian",0.2,{"$f":"IFERROR(IF(Adjust_Budget=\"Yes\",Allocated_Money_Remaining-SUMIFS(Gifts[COST],Gifts[RECIPIENT],Recipients[[#This Row],[RECIPIENT]]),(TotalBudget*Recipients[[#This Row],[PLANNED % OF BUDGET]])-SUMIFS(Gifts[COST],Gifts[RECIPIENT],Recipients[[#This Row],[RECIPIENT]])),\"\")","v":11},2,{"$f":"IFERROR(Recipients[[#This Row],[PLANNED '# OF GIFTS]]-COUNTIFS(Gifts[RECIPIENT],Recipients[[#This Row],[RECIPIENT]]), \"\")","v":1}]
[null,"Suzanne",0.1,{"$f":"IFERROR(IF(Adjust_Budget=\"Yes\",Allocated_Money_Remaining-SUMIFS(Gifts[COST],Gifts[RECIPIENT],Recipients[[#This Row],[RECIPIENT]]),(TotalBudget*Recipients[[#This Row],[PLANNED % OF BUDGET]])-SUMIFS(Gifts[COST],Gifts[RECIPIENT],Recipients[[#This Row],[RECIPIENT]])),\"\")","v":-1},1,{"$f":"IFERROR(Recipients[[#This Row],[PLANNED '# OF GIFTS]]-COUNTIFS(Gifts[RECIPIENT],Recipients[[#This Row],[RECIPIENT]]), \"\")","v":0}]
[null,"Marty",0.1,{"$f":"IFERROR(IF(Adjust_Budget=\"Yes\",Allocated_Money_Remaining-SUMIFS(Gifts[COST],Gifts[RECIPIENT],Recipients[[#This Row],[RECIPIENT]]),(TotalBudget*Recipients[[#This Row],[PLANNED % OF BUDGET]])-SUMIFS(Gifts[COST],Gifts[RECIPIENT],Recipients[[#This Row],[RECIPIENT]])),\"\")","v":0},1,{"$f":"IFERROR(Recipients[[#This Row],[PLANNED '# OF GIFTS]]-COUNTIFS(Gifts[RECIPIENT],Recipients[[#This Row],[RECIPIENT]]), \"\")","v":0}]
[null,"Total",{"$f":"SUM(Recipients[PLANNED % OF BUDGET])","v":1},{"$f":"IFERROR(SUM(Recipients[REMAINING MONEY ALLOCATED]),\"\")","v":109},{"$f":"SUM(Recipients[PLANNED '# OF GIFTS])","v":10},{"$f":"SUM(Recipients[GIFTS REMAINING])","v":3}]

{"sheet":"Gift List","index":1,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,"holiday","GIFT LIST"]
[null,"RECIPIENT","GIFT","COST","PURCHASED","WRAPPED"]
[null,"Jenny","Doll House",36,"Yes","Yes"]
[null,"Brian","Bicycle",89,"Yes"]
[null,"Suzanne","Scrapbook Materials",51,"Yes","Yes"]
[null,"Adam","Toy Train",48]
[null,"Adam","Sweater",57,"Yes"]
[null,"Marty","Gift Card",50,"Yes","Yes"]
[null,"Jenny","Dress",60]