{"product_id":"christmas-gift-tracker-spreadsheet","title":"Christmas Gift Tracker Spreadsheet","description":"\u003cp\u003eThis Christmas gift tracker keeps every gift, card and Christmas expense in one file, counted down to 25 December. It is for whoever runs Christmas in the household and wants to know, in the second week of December, which gifts still have to be posted, what is left in the budget and when the turkey goes in.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003ePlease read:\u003c\/strong\u003e This is a tracker tool only, not financial, tax, legal, medical or any other professional advice or advisory service. It records and calculates what you enter; you are solely responsible for checking all figures, rates, dates and results and for every decision you make. By purchasing, downloading or using it, you accept these terms (your statutory consumer rights are not affected).\u003c\/p\u003e\u003ch2\u003eThe dashboard\u003c\/h2\u003e\u003cp\u003eThis Christmas planner puts Christmas on one printed page in pine green, cranberry and gold. Nothing on it is typed; it fills itself from the other tabs.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003ePick Everyone or one person, and the budget, spending, gifts and deadlines follow\u003c\/li\u003e\n\u003cli\u003eSix cards: days to Christmas Day, budget, spent, left to spend, gifts sorted and cards sent\u003c\/li\u003e\n\u003cli\u003eWhere every gift is, with all six statuses counted\u003c\/li\u003e\n\u003cli\u003eBudget per person, with any overspend shown in red and the amount written out\u003c\/li\u003e\n\u003cli\u003eWhere the Christmas money goes, the next deadlines with days left, and the cooking plan, this week's jobs and Secret Santa\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eA date on every gift\u003c\/h2\u003e\u003cp\u003eAs a holiday gift planner, it gives each gift the day it is needed by, not just Christmas Day. Posted, sent by courier, ordered online or handed over, each counts back from 25 December by its own number of days, or from the last posting day you enter. Days left turns amber inside a week, shows \"Late by 2 days\" once passed, and stops counting when the gift is given.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eSix honest statuses: Idea, Decided, Ordered, Arrived, Wrapped and Given\u003c\/li\u003e\n\u003cli\u003eLast year remembered: the People tab shows what each person got, and the gift list warns you before you repeat a gift\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eSecret Santa and the dinner\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eA fair Secret Santa draw for up to 30 names. Nobody draws themselves or a partner they cannot draw, the same draw number always gives the same result, and there is a slip to cut out for each person.\u003c\/li\u003e\n\u003cli\u003eThe Christmas Day dinner worked backward: enter the dinner time and each dish's cooking and resting minutes, and the timeline shows when everything goes in\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eTwelve connected tabs\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eGift List: 150 gifts with who, what, where from, budget, spent, status, delivery and tracking number\u003c\/li\u003e\n\u003cli\u003ePeople: 60 people with a budget each, sizes, likes, wish list and last year's gifts\u003c\/li\u003e\n\u003cli\u003eChristmas Budget: a plan for every area and a spending log, with over-plan flagged\u003c\/li\u003e\n\u003cli\u003eCards: 150 households with addresses, card or e-card, sent and received\u003c\/li\u003e\n\u003cli\u003eChristmas Day: guests and dietary needs, the menu, the cooking timeline and a shopping list\u003c\/li\u003e\n\u003cli\u003eDecember Plan, House and Hosting, and a December Calendar from late November to New Year, filled in for you\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eAfter 25 December the file moves on to next Christmas by itself, or you can type the year you want.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016 or newer, on Mac or Windows\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version has smaller tables (80 gifts, 40 people, 80 cards) so it stays quick in a browser, and it is a real workbook you take a copy of, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros and no add-ins. No Microsoft 365 subscription is required.\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eThe Excel workbook filled with a worked example: a household part-way through December with seventeen people, twenty-five gifts, forty cards and a Secret Santa of eight\u003c\/li\u003e\n\u003cli\u003eThe same workbook, blank and ready for yours\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, with one-click links to the Google Sheets versions (filled and blank)\u003c\/li\u003e\n\u003cli\u003eThe terms of use as a PDF\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eYour files are ready to download as soon as payment clears. Questions before or after you buy? Use our contact page and we will help.\u003c\/p\u003e\u003ch2\u003eFrequently asked questions\u003c\/h2\u003e\u003ch3\u003eDoes it work in Excel or Google Sheets?\u003c\/h3\u003e\u003cp\u003eBoth. The Excel workbook runs on Excel 2016 or newer on Mac or Windows, and the instruction guide has one-click links to the Google Sheets versions. The Sheets version has smaller tables so it stays quick in a browser.\u003c\/p\u003e\u003ch3\u003eHow does it know when a gift needs to be sent?\u003c\/h3\u003e\u003cp\u003eEach gift counts back from 25 December by its delivery method, or from the last posting day you enter. Days left turns amber inside a week and shows as late once it passes.\u003c\/p\u003e\u003ch3\u003eCan it run our Secret Santa?\u003c\/h3\u003e\u003cp\u003eYes. It draws up to 30 names fairly, so nobody gets themselves or a partner they should not draw, and it makes a slip to cut out for each person.\u003c\/p\u003e\u003ch3\u003eWill it stop me buying the same gift twice?\u003c\/h3\u003e\u003cp\u003eYes. Keep last year's gifts on the list and the gift list warns you if you put the same gift down for the same person again.\u003c\/p\u003e\u003ch3\u003eCan I use it again next year?\u003c\/h3\u003e\u003cp\u003eYes. After 25 December it moves on to next Christmas by itself, or you can type the year you want.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597866008670,"sku":"OPX-108","price":24.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/christmas-gift-tracker-spreadsheet-01.jpg?v=1790832545","url":"https:\/\/opxviashop.com\/products\/christmas-gift-tracker-spreadsheet","provider":"OPXVIA","version":"1.0","type":"link"}