{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Start","Gift Budget and Tracker","Data"],"not_rendered":{"charts":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Start","index":0,"n_rows":7,"n_cols":2,"rows_kept":7}
[null,"About The Template"]
[null,"Use this template to log your gift purchases and track them against budget."]
[null,"Enter in table the names of family and friends, gift items, budgeted and spent amounts, and notes, and select occasion and event month."]
[null,"Monthly Overview Chart is auto updated."]
[null,"Note: "]
[null,"Additional instructions have been provided in column A in GIFT BUDGET AND TRACKER worksheet. This text has been intentionally hidden. To remove text, select column A, then select DELETE. To unhide text, select column A, then change the font colour."]
[null,"To learn more about table, press SHIFT and then F10 within a table, select the TABLE option, and then select ALTERNATIVE TEXT."]

{"sheet":"Gift Budget and Tracker","index":1,"n_rows":10,"n_cols":13,"rows_kept":10,"merged":[[0,1,0,4],[0,5,0,12],[1,1,1,2],[2,1,2,12],[3,1,3,3]]}
["Create a personal Gift Budget and Tracker in this worksheet. Title of the worksheet is in cell at right and tip in cell F1. Helpful instructions on how to use this worksheet are in cells in this column.","Gift Budget and Tracker",{"$nulls":3},"Fill in as much as you can at the beginning of each new year. Enter names of family and friends, select gift occasion, select month of event, and type in how much you want to spend. Each person may appear multiple times within the table for each different occasion (birthday, holiday, shower, etc.)."]
["Monthly Overview label is in cell at right and tip in cell D2.","Monthly Overview",null,"Use the graph to look at the upcoming months in order to plan ahead. Log your purchases to track them against your budget."]
["Column chart for budgeted amounts with line chart overlay for amount spent is in cell at right.","Column chart for budgeted amounts with line chart overlay for amount spent is in this cell."]
["Gift Budget and Tracker label is in cell at right.","Gift Budget and Tracker"]
["Enter details in Budget Tracker table starting in cell at right.","Who","Occasion","Month","Amount\nbudgeted","Amount\nspent","Gift","Link to gift","In store/\nOnline","Purchased?","Wrapped?","Delivered?","Notes"]
[null,"Name 1","Birthdays","June",{"v":50,"d":"£50"},{"v":30,"d":"£30"},"Shoes","Seller","Online","Yes","No","No","16/6, film tickets"]
[null,"Name 2","Anniversaries","April",{"v":20,"d":"£20"},{"v":20,"d":"£20"},"A cat","Seller","In store","No","No","No","He mentioned he likes dogs"]
[null,"Name 3","Holidays","July",{"v":50,"d":"£50"},{"v":70,"d":"£70"},"Headphones","Seller","Online","No","No","No","Dorm stuff"]
[null,"Name 4","Birthdays","January",{"v":20,"d":"£20"},{"v":30,"d":"£30"},"Game","Seller","In store","Yes","Yes","Yes"]
[null,"Name 5","Weddings","June",{"v":100,"d":"£100"},{"v":150,"d":"£150"},"Crystal vase","Seller","In store","Yes","Yes","No"]

{"sheet":"Data","index":2,"n_rows":13,"n_cols":8,"rows_kept":13,"hidden":true}
["Occasions",null,"Date","Date","Amount Budgeted\nBirthdays","Amount Budgeted\nHolidays","Amount Budgeted\nOther","Amount Spent"]
["Birthdays",null,"January","Jan",{"$f":"SUMIFS(BudgetTracker[Amount\nbudgeted],BudgetTracker[Month],\"January\",BudgetTracker[Occasion],\"Birthdays\")","v":{"v":20,"d":"£20"}},{"$f":"SUMIFS(BudgetTracker[Amount\nbudgeted],BudgetTracker[Month],\"January\",BudgetTracker[Occasion],\"Holidays\")","v":{"v":0,"d":"£0"}},{"$f":"SUMIFS(BudgetTracker[Amount\nbudgeted],BudgetTracker[Month],\"January\",BudgetTracker[Occasion],\"<>Holidays\",BudgetTracker[Occasion],\"<>Birthdays\")","v":{"v":0,"d":"£0"}},{"$f":"SUMIFS(BudgetTracker[Amount\nspent],BudgetTracker[Month],\"January\")","v":{"v":30,"d":"£30"}}]
["Holidays",null,"February","Feb",{"$f":"SUMIFS(BudgetTracker[Amount\nbudgeted],BudgetTracker[Month],\"February\",BudgetTracker[Occasion],\"Birthdays\")","v":{"v":0,"d":"£0"}},{"$f":"SUMIFS(BudgetTracker[Amount\nbudgeted],BudgetTracker[Month],\"February\",BudgetTracker[Occasion],\"Holidays\")","v":{"v":0,"d":"£0"}},{"$f":"SUMIFS(BudgetTracker[Amount\nbudgeted],BudgetTracker[Month],\"February\",BudgetTracker[Occasion],\"<>Holidays\",BudgetTracker[Occasion],\"<>Birthdays\")","v":{"v":0,"d":"£0"}},{"$f":"SUMIFS(BudgetTracker[Amount\nspent],BudgetTracker[Month],\"February\")","v":{"v":0,"d":"£0"}}]
["Anniversaries",null,"March","Mar",{"$f":"SUMIFS(BudgetTracker[Amount\nbudgeted],BudgetTracker[Month],\"March\",BudgetTracker[Occasion],\"Birthdays\")","v":{"v":0,"d":"£0"}},{"$f":"SUMIFS(BudgetTracker[Amount\nbudgeted],BudgetTracker[Month],\"March\",BudgetTracker[Occasion],\"Holidays\")","v":{"v":0,"d":"£0"}},{"$f":"SUMIFS(BudgetTracker[Amount\nbudgeted],BudgetTracker[Month],\"March\",BudgetTracker[Occasion],\"<>Holidays\",BudgetTracker[Occasion],\"<>Birthdays\")","v":{"v":0,"d":"£0"}},{"$f":"SUMIFS(BudgetTracker[Amount\nspent],BudgetTracker[Month],\"March\")","v":{"v":0,"d":"£0"}}]
["Weddings",null,"April","Apr",{"$f":"SUMIFS(BudgetTracker[Amount\nbudgeted],BudgetTracker[Month],\"April\",BudgetTracker[Occasion],\"Birthdays\")","v":{"v":0,"d":"£0"}},{"$f":"SUMIFS(BudgetTracker[Amount\nbudgeted],BudgetTracker[Month],\"April\",BudgetTracker[Occasion],\"Holidays\")","v":{"v":0,"d":"£0"}},{"$f":"SUMIFS(BudgetTracker[Amount\nbudgeted],BudgetTracker[Month],\"April\",BudgetTracker[Occasion],\"<>Holidays\",BudgetTracker[Occasion],\"<>Birthdays\")","v":{"v":20,"d":"£20"}},{"$f":"SUMIFS(BudgetTracker[Amount\nspent],BudgetTracker[Month],\"April\")","v":{"v":20,"d":"£20"}}]
["Bridal Showers",null,"May","May",{"$f":"SUMIFS(BudgetTracker[Amount\nbudgeted],BudgetTracker[Month],\"May\",BudgetTracker[Occasion],\"Birthdays\")","v":{"v":0,"d":"£0"}},{"$f":"SUMIFS(BudgetTracker[Amount\nbudgeted],BudgetTracker[Month],\"May\",BudgetTracker[Occasion],\"Holidays\")","v":{"v":0,"d":"£0"}},{"$f":"SUMIFS(BudgetTracker[Amount\nbudgeted],BudgetTracker[Month],\"May\",BudgetTracker[Occasion],\"<>Holidays\",BudgetTracker[Occasion],\"<>Birthdays\")","v":{"v":0,"d":"£0"}},{"$f":"SUMIFS(BudgetTracker[Amount\nspent],BudgetTracker[Month],\"May\")","v":{"v":0,"d":"£0"}}]
["Baby Showers",null,"June","Jun",{"$f":"SUMIFS(BudgetTracker[Amount\nbudgeted],BudgetTracker[Month],\"June\",BudgetTracker[Occasion],\"Birthdays\")","v":{"v":50,"d":"£50"}},{"$f":"SUMIFS(BudgetTracker[Amount\nbudgeted],BudgetTracker[Month],\"June\",BudgetTracker[Occasion],\"Holidays\")","v":{"v":0,"d":"£0"}},{"$f":"SUMIFS(BudgetTracker[Amount\nbudgeted],BudgetTracker[Month],\"June\",BudgetTracker[Occasion],\"<>Holidays\",BudgetTracker[Occasion],\"<>Birthdays\")","v":{"v":100,"d":"£100"}},{"$f":"SUMIFS(BudgetTracker[Amount\nspent],BudgetTracker[Month],\"June\")","v":{"v":180,"d":"£180"}}]
["Graduations",null,"July","Jul",{"$f":"SUMIFS(BudgetTracker[Amount\nbudgeted],BudgetTracker[Month],\"July\",BudgetTracker[Occasion],\"Birthdays\")","v":{"v":0,"d":"£0"}},{"$f":"SUMIFS(BudgetTracker[Amount\nbudgeted],BudgetTracker[Month],\"July\",BudgetTracker[Occasion],\"Holidays\")","v":{"v":50,"d":"£50"}},{"$f":"SUMIFS(BudgetTracker[Amount\nbudgeted],BudgetTracker[Month],\"July\",BudgetTracker[Occasion],\"<>Holidays\",BudgetTracker[Occasion],\"<>Birthdays\")","v":{"v":0,"d":"£0"}},{"$f":"SUMIFS(BudgetTracker[Amount\nspent],BudgetTracker[Month],\"July\")","v":{"v":70,"d":"£70"}}]
["Other",null,"August","Aug",{"$f":"SUMIFS(BudgetTracker[Amount\nbudgeted],BudgetTracker[Month],\"August\",BudgetTracker[Occasion],\"Birthdays\")","v":{"v":0,"d":"£0"}},{"$f":"SUMIFS(BudgetTracker[Amount\nbudgeted],BudgetTracker[Month],\"August\",BudgetTracker[Occasion],\"Holidays\")","v":{"v":0,"d":"£0"}},{"$f":"SUMIFS(BudgetTracker[Amount\nbudgeted],BudgetTracker[Month],\"August\",BudgetTracker[Occasion],\"<>Holidays\",BudgetTracker[Occasion],\"<>Birthdays\")","v":{"v":0,"d":"£0"}},{"$f":"SUMIFS(BudgetTracker[Amount\nspent],BudgetTracker[Month],\"August\")","v":{"v":0,"d":"£0"}}]
[null,null,"September","Sep",{"$f":"SUMIFS(BudgetTracker[Amount\nbudgeted],BudgetTracker[Month],\"September\",BudgetTracker[Occasion],\"Birthdays\")","v":{"v":0,"d":"£0"}},{"$f":"SUMIFS(BudgetTracker[Amount\nbudgeted],BudgetTracker[Month],\"September\",BudgetTracker[Occasion],\"Holidays\")","v":{"v":0,"d":"£0"}},{"$f":"SUMIFS(BudgetTracker[Amount\nbudgeted],BudgetTracker[Month],\"September\",BudgetTracker[Occasion],\"<>Holidays\",BudgetTracker[Occasion],\"<>Birthdays\")","v":{"v":0,"d":"£0"}},{"$f":"SUMIFS(BudgetTracker[Amount\nspent],BudgetTracker[Month],\"September\")","v":{"v":0,"d":"£0"}}]
[null,null,"October","Oct",{"$f":"SUMIFS(BudgetTracker[Amount\nbudgeted],BudgetTracker[Month],\"October\",BudgetTracker[Occasion],\"Birthdays\")","v":{"v":0,"d":"£0"}},{"$f":"SUMIFS(BudgetTracker[Amount\nbudgeted],BudgetTracker[Month],\"October\",BudgetTracker[Occasion],\"Holidays\")","v":{"v":0,"d":"£0"}},{"$f":"SUMIFS(BudgetTracker[Amount\nbudgeted],BudgetTracker[Month],\"October\",BudgetTracker[Occasion],\"<>Holidays\",BudgetTracker[Occasion],\"<>Birthdays\")","v":{"v":0,"d":"£0"}},{"$f":"SUMIFS(BudgetTracker[Amount\nspent],BudgetTracker[Month],\"October\")","v":{"v":0,"d":"£0"}}]
[null,null,"November","Nov",{"$f":"SUMIFS(BudgetTracker[Amount\nbudgeted],BudgetTracker[Month],\"November\",BudgetTracker[Occasion],\"Birthdays\")","v":{"v":0,"d":"£0"}},{"$f":"SUMIFS(BudgetTracker[Amount\nbudgeted],BudgetTracker[Month],\"November\",BudgetTracker[Occasion],\"Holidays\")","v":{"v":0,"d":"£0"}},{"$f":"SUMIFS(BudgetTracker[Amount\nbudgeted],BudgetTracker[Month],\"November\",BudgetTracker[Occasion],\"<>Holidays\",BudgetTracker[Occasion],\"<>Birthdays\")","v":{"v":0,"d":"£0"}},{"$f":"SUMIFS(BudgetTracker[Amount\nspent],BudgetTracker[Month],\"November\")","v":{"v":0,"d":"£0"}}]
[null,null,"December","Dec",{"$f":"SUMIFS(BudgetTracker[Amount\nbudgeted],BudgetTracker[Month],\"December\",BudgetTracker[Occasion],\"Birthdays\")","v":{"v":0,"d":"£0"}},{"$f":"SUMIFS(BudgetTracker[Amount\nbudgeted],BudgetTracker[Month],\"December\",BudgetTracker[Occasion],\"Holidays\")","v":{"v":0,"d":"£0"}},{"$f":"SUMIFS(BudgetTracker[Amount\nbudgeted],BudgetTracker[Month],\"December\",BudgetTracker[Occasion],\"<>Holidays\",BudgetTracker[Occasion],\"<>Birthdays\")","v":{"v":0,"d":"£0"}},{"$f":"SUMIFS(BudgetTracker[Amount\nspent],BudgetTracker[Month],\"December\")","v":{"v":0,"d":"£0"}}]