{"product_id":"sleep-tracker-diary-spreadsheet","title":"Sleep Tracker and Sleep Diary Spreadsheet","description":"\u003cp\u003eThis sleep tracker is a sleep diary that does the arithmetic for you. It is for anyone who has been asked to log their nights for several weeks before an appointment, or who simply wants to know what is actually affecting their sleep.\u003c\/p\u003e\u003cp\u003eA paper diary records the nights but tells you nothing when you hand it back. This one turns the same entries into averages, comparisons and a single page you can take with you.\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\u003eWhat actually affects your sleep\u003c\/h2\u003e\u003cp\u003eEach night you tick up to six things, such as late screens, caffeine after two or a nap, and you can rename them. The Correlations tab compares your average sleep quality on the nights each one happened against the nights it did not, and ranks them by size. Eight weeks of ticking becomes one clear sentence about your sleep hygiene.\u003c\/p\u003e\u003ch2\u003eOne row a night\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eRoom for 300 nights, nine columns a night\u003c\/li\u003e\n\u003cli\u003eTime in bed against hours asleep, the two figures a sleep clinic usually asks for first\u003c\/li\u003e\n\u003cli\u003eHow many times you woke and how groggy you felt\u003c\/li\u003e\n\u003cli\u003eBad nights counted and colored\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eMedications, appointments and results\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eMedications:\u003c\/strong\u003e set a window on Setup and every medication or dose change gets an average for the period before it and the period after\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eAppointments:\u003c\/strong\u003e what was said, and what to ask next time\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eResults:\u003c\/strong\u003e lab results against the range your lab printed\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eReport:\u003c\/strong\u003e the last thirty nights against the thirty before, with the factors ranked, on one printed page\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eEleven connected tabs\u003c\/h2\u003e\u003cp\u003eStart Here, Setup, Daily Log, Nights, Correlations, Medications, Appointments, Results, Monthly, Report and Dashboard. The worked example covers 261 nights across a year, with melatonin from January, better sleep habits from March and a sleep restriction program from June. Average quality reaches 6.5 over the last thirty nights, and late screens cost 3.5 points of quality a night. A blank copy is ready for your own sleep log or insomnia log, and the Medications tab works as a simple medication log alongside it.\u003c\/p\u003e\u003cp\u003eThis is a spreadsheet, not a medical device. It does not diagnose anything and it is not a substitute for advice from your doctor.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook you make your own copy of, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros, no add-ins and no subscription\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\u003c\/li\u003e\n\u003cli\u003eA blank Excel workbook ready for your own entries\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, and the Start Here tab walks you through setup in a few minutes. The template is for personal and business use on your own devices, so please do not share or resell the files. 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 and Google Sheets?\u003c\/h3\u003e\u003cp\u003eYes. You download Excel workbooks for Excel 2016 or later on Windows and Mac, and the instruction guide has one-click links to make your own copy in Google Sheets with a free Google account.\u003c\/p\u003e\u003ch3\u003eCan I change the six things I tick each night?\u003c\/h3\u003e\u003cp\u003eYes. The six factors can be renamed, and the Correlations tab compares your average quality with and without each one.\u003c\/p\u003e\u003ch3\u003eCan I see whether a new medication helped?\u003c\/h3\u003e\u003cp\u003eYou set a window on Setup, and every medication or dose change gets an average for the period before and the period after. It records and compares, it does not give medical advice.\u003c\/p\u003e\u003ch3\u003eIs there something I can print for an appointment?\u003c\/h3\u003e\u003cp\u003eYes. The Report tab puts the last thirty nights against the thirty before, with the factors ranked, on a single page.\u003c\/p\u003e\u003ch3\u003eDoes it record time in bed as well as sleep?\u003c\/h3\u003e\u003cp\u003eYes. Each night has time in bed and hours asleep, plus how many times you woke and how groggy you felt.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597871120478,"sku":"OPX-198","price":22.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/sleep-tracker-diary-spreadsheet-01.jpg?v=1790833055","url":"https:\/\/opxviashop.com\/products\/sleep-tracker-diary-spreadsheet","provider":"OPXVIA","version":"1.0","type":"link"}