{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Gift List"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Gift List","index":0,"n_rows":21,"n_cols":6,"rows_kept":21,"merged":[[1,0,3,3],[12,1,12,5]]}
[]
["holiday GIFT LIST",{"$nulls":3},"TOTAL BUDGET",{"v":500,"d":"$500.00"}]
[{"$nulls":4},"SPENT",{"$f":"TotalBudget-F4","v":{"v":391,"d":"$391.00"}}]
[{"$nulls":4},"REMAINING",{"$f":"SUM(Recipients[MONEY REMAINING])","v":{"v":109,"d":"$109.00"}}]
[]
[null,"FOR","PLANNED % OF BUDGET","MONEY REMAINING","PLANNED # OF GIFTS","GIFTS REMAINING"]
[null,"Adam",{"v":0.3,"d":"30%"},{"$f":"TotalBudget*Recipients[[#This Row],[PLANNED % OF BUDGET]]-SUMIFS(Gifts[COST],Gifts[FOR],Recipients[[#This Row],[FOR]])","v":{"v":45,"d":"$45.00"}},3,{"$f":"Recipients[[#This Row],[PLANNED '# OF GIFTS]]-COUNTIFS(Gifts[FOR],Recipients[[#This Row],[FOR]])","v":1}]
[null,"Jenny",{"v":0.3,"d":"30%"},{"$f":"TotalBudget*Recipients[[#This Row],[PLANNED % OF BUDGET]]-SUMIFS(Gifts[COST],Gifts[FOR],Recipients[[#This Row],[FOR]])","v":{"v":54,"d":"$54.00"}},3,{"$f":"Recipients[[#This Row],[PLANNED '# OF GIFTS]]-COUNTIFS(Gifts[FOR],Recipients[[#This Row],[FOR]])","v":1}]
[null,"Brian",{"v":0.2,"d":"20%"},{"$f":"TotalBudget*Recipients[[#This Row],[PLANNED % OF BUDGET]]-SUMIFS(Gifts[COST],Gifts[FOR],Recipients[[#This Row],[FOR]])","v":{"v":11,"d":"$11.00"}},2,{"$f":"Recipients[[#This Row],[PLANNED '# OF GIFTS]]-COUNTIFS(Gifts[FOR],Recipients[[#This Row],[FOR]])","v":1}]
[null,"Suzanne",{"v":0.1,"d":"10%"},{"$f":"TotalBudget*Recipients[[#This Row],[PLANNED % OF BUDGET]]-SUMIFS(Gifts[COST],Gifts[FOR],Recipients[[#This Row],[FOR]])","v":{"v":-1,"d":"-$1.00"}},1,{"$f":"Recipients[[#This Row],[PLANNED '# OF GIFTS]]-COUNTIFS(Gifts[FOR],Recipients[[#This Row],[FOR]])","v":0}]
[null,"Marty",{"v":0.1,"d":"10%"},{"$f":"TotalBudget*Recipients[[#This Row],[PLANNED % OF BUDGET]]-SUMIFS(Gifts[COST],Gifts[FOR],Recipients[[#This Row],[FOR]])","v":{"v":0,"d":"$0.00"}},1,{"$f":"Recipients[[#This Row],[PLANNED '# OF GIFTS]]-COUNTIFS(Gifts[FOR],Recipients[[#This Row],[FOR]])","v":0}]
[null,"Total",{"$f":"SUM(Recipients[PLANNED % OF BUDGET])","v":{"v":1,"d":"100%"}},{"$f":"SUM(Recipients[MONEY REMAINING])","v":{"v":109,"d":"$109.00"}},{"$f":"SUM(Recipients[PLANNED '# OF GIFTS])","v":10},{"$f":"SUM(Recipients[GIFTS REMAINING])","v":3}]
[]
[null,"FOR","GIFT","COST","PURCHASED","WRAPPED"]
[null,"Jenny","Doll 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","Sweater",{"v":57,"d":"$57.00"},"Yes"]
[null,"Marty","Gift Card",{"v":50,"d":"$50.00"},"Yes","Yes"]
[null,"Jenny","Dress",{"v":60,"d":"$60.00"}]