{"product_id":"blood-sugar-log-spreadsheet","title":"Blood Sugar Tracker Spreadsheet","description":"\u003cp\u003eThis blood sugar log sorts your readings by when they were taken, because a waking reading and an after-dinner reading are two different conversations. It is for people with type 1 diabetes, type 2 diabetes or prediabetes who want their numbers organized for the next review.\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\u003eFour things per reading\u003c\/h2\u003e\u003cp\u003eEach reading needs only the date, which part of the day, whether it was before or after a meal, and the number. Everything else in this glucose log is arithmetic on that tab, which has room for 1,400 readings.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eLow, in range or high, worked out on every row against your own target and colored\u003c\/li\u003e\n\u003cli\u003eYour target typed once on Setup, in your own unit\u003c\/li\u003e\n\u003cli\u003eAfter-meal readings judged against a different ceiling, as they should be\u003c\/li\u003e\n\u003cli\u003eNothing is converted: mmol\/L or mg\/dL, stored exactly as you were given it\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003ePatterns by time of day and day of week\u003c\/h2\u003e\u003cp\u003eThe Patterns tab splits your readings across six times of day and seven days of the week, each with its own average, its own count in range and its own share. That split is where the pattern shows. A single monthly average is where it hides.\u003c\/p\u003e\u003ch2\u003eWhat a dose change did\u003c\/h2\u003e\u003cp\u003eOn the Medications tab, a dose change is a new row rather than an edit, for example metformin 500mg from January and 1000mg from April. Each row compares the thirty days before the change with the thirty days after, which is the question a review appointment asks. With fewer than ten days logged before a change, it says so instead of guessing. Refill dates are calculated from the interval, so it also works as a medication tracker.\u003c\/p\u003e\u003ch2\u003eResults, appointments and the report\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eResults: every HbA1c with the lab's range beside it and the change since the last one\u003c\/li\u003e\n\u003cli\u003eAppointments: what the nurse said, kept, with the date to come back\u003c\/li\u003e\n\u003cli\u003eMonthly: readings, average and share in range, twelve rows\u003c\/li\u003e\n\u003cli\u003eReport: one printable page to take to the review\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eThe ten connected tabs are Start Here, Setup, Readings, Patterns, Medications, Appointments, Results, Monthly, Report and Dashboard, so the file works as a glucose tracker and a diabetes planner in one. It is a logbook that does arithmetic on the numbers you type. It does not set your target range, does not know your history and cannot tell you whether a reading matters.\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, 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: nine months of example readings, 1,135 of them through a dose change in April, and a blank one for your own\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. 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 the Google Sheets versions for a free Google account.\u003c\/p\u003e\u003ch3\u003eDoes it work in mmol\/L and mg\/dL?\u003c\/h3\u003e\u003cp\u003eYes. You use whichever unit you were given and nothing is converted. Your target is typed once on Setup in that unit.\u003c\/p\u003e\u003ch3\u003eCan it show whether a dose change helped?\u003c\/h3\u003e\u003cp\u003eEach dose change is its own row, with your readings for the thirty days before compared with the thirty days after. With fewer than ten days logged before the change, it says so.\u003c\/p\u003e\u003ch3\u003eCan I track HbA1c results?\u003c\/h3\u003e\u003cp\u003eYes. The Results tab records every HbA1c with the lab's range beside it and the change since the last one.\u003c\/p\u003e\u003ch3\u003eDoes it tell me what my target range should be?\u003c\/h3\u003e\u003cp\u003eNo. It is a logbook that does arithmetic on the numbers you type. Your target range comes from whoever looks after your care.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597865320542,"sku":"OPX-095","price":22.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/blood-sugar-log-spreadsheet-01.jpg?v=1790832472","url":"https:\/\/opxviashop.com\/products\/blood-sugar-log-spreadsheet","provider":"OPXVIA","version":"1.0","type":"link"}