{"product_id":"year-at-a-glance-planner","title":"Year at a Glance Planner Spreadsheet","description":"\u003cp\u003eThis year at a glance planner puts the whole year on one page, with the days that do not exist greyed out and every weekend already shaded. It is for families, teachers and anyone who needs birthdays, holidays, term dates and deadlines in view against each other.\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\u003eThirty-one rows, twelve columns, one page\u003c\/h2\u003e\u003cp\u003eThe Year at a Glance tab is a 12 month planner laid out as 31 rows by 12 months. Birthdays, holidays, term dates and deadlines all go in one place where you can see them against everything else, which makes it a birthday calendar and an academic planner at the same time.\u003c\/p\u003e\u003ch2\u003eIt knows which days exist\u003c\/h2\u003e\u003cp\u003e30 February and 31 April are greyed out, month by month, worked out from the year cell. A year view that leaves them blank and editable is wrong for four months of every year. This one is not.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eDays that do not exist greyed out, per month\u003c\/li\u003e\n\u003cli\u003eWeekends already shaded, and they move when the year changes\u003c\/li\u003e\n\u003cli\u003eOne year cell drives all of it, including leap years\u003c\/li\u003e\n\u003cli\u003eUsed days counted at the foot of each month, so a month that is filling up is visible before it is full\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eGoals and tasks beside it\u003c\/h2\u003e\u003cp\u003eA year view is for the things that are not this week, so the yearly planner has a place for the bigger plans too.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eGoals with progress\u003c\/li\u003e\n\u003cli\u003e250 tasks\u003c\/li\u003e\n\u003cli\u003eA dashboard reading all of it\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eThe six connected tabs are Start Here, Setup, Year at a Glance, Goals, Tasks and Dashboard, so this annual planner keeps the long view and the to-do list together. The Start Here tab walks you through setup in a few minutes.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016 or later, on Windows or Mac\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version 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, so it behaves the same on Excel 2016, 2019, 2021 and Microsoft 365 and in LibreOffice. No Microsoft 365 subscription is required.\u003c\/li\u003e\n\u003cli\u003eNo subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eTwo Excel files: this year with the shading already right, and a blank one ready for yours\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, which has 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. The file is for your personal use, so please do not share or resell it. 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 files run on Excel 2016 or later on Windows or Mac, and the instruction guide has one-click links to make your own copy of the Google Sheets versions.\u003c\/p\u003e\u003ch3\u003eDoes it work for any year?\u003c\/h3\u003e\u003cp\u003eYes. One year cell drives the page. Change it and the weekends, the greyed-out days and leap years all follow.\u003c\/p\u003e\u003ch3\u003eWhy are some days greyed out?\u003c\/h3\u003e\u003cp\u003eDays that do not exist in that month, such as 30 February and 31 April, are greyed so nothing gets written on a date that is not real.\u003c\/p\u003e\u003ch3\u003eCan I see how busy a month is?\u003c\/h3\u003e\u003cp\u003eYes. Used days are counted at the foot of each month.\u003c\/p\u003e\u003ch3\u003eCan I use it for a school year?\u003c\/h3\u003e\u003cp\u003eYou can enter term dates, holidays and deadlines on the grid, and Goals and Tasks tabs sit beside it.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597866205278,"sku":"OPX-112","price":20.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/year-at-a-glance-planner-01.jpg?v=1790832567","url":"https:\/\/opxviashop.com\/products\/year-at-a-glance-planner","provider":"OPXVIA","version":"1.0","type":"link"}