{"product_id":"step-tracker-walking-log","title":"Step Tracker and Walking Log Spreadsheet","description":"\u003cp\u003eThis step tracker is for anyone with a step count on their wrist or phone who wants to see the whole year, not just today. Copy three numbers a day into the log, and the workbook colors every day against your goal, counts your streaks and shows when you really walk.\u003c\/p\u003e\u003cp\u003eA watch is good at telling you about today. This file shows the pattern: the longest streak you managed, your best months and the quiet day of the week.\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\u003eNothing on the dashboard is typed. Pick Whole year or any month and the whole page follows.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eAverage steps:\u003c\/strong\u003e steps a day against your goal, with your best day\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eEvery day of the year:\u003c\/strong\u003e a calendar of every day, colored against your daily goal\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eDay by day:\u003c\/strong\u003e the month picked, or the last 31 days, against the goal line\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eThe biggest days:\u003c\/strong\u003e your five biggest days, with the note you left\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eGoal days and average\u003c\/strong\u003e for each month, and how the days went: on goal, close, short or never logged\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eDistance:\u003c\/strong\u003e distance walked each month, a daily average, and the running total for the year\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eActive minutes\u003c\/strong\u003e a day, month by month, against your goal\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat sets it apart\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eA year on one screen:\u003c\/strong\u003e the Step Calendar is twelve months by thirty-one days, green on goal, amber within a quarter of it, red further off, and gray for days a month does not have\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eThe streak, counted:\u003c\/strong\u003e a run of goal days is counted as you log, and missing a day or missing logging it starts it again. Your current and longest streak both sit on the dashboard\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eWeeks and months:\u003c\/strong\u003e every week from Monday with average steps, goal days, active minutes, distance and the change on the week before, and every month with days logged, average, goal days, hit rate, best day and longest run\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eWhen you walk:\u003c\/strong\u003e average steps by day of the week, charted\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eSix connected tabs\u003c\/h2\u003e\u003cp\u003eStart Here, Setup, Activity Log, Step Calendar, Weekly and Dashboard. It works with any watch, phone or pedometer, because you copy three numbers a day into the walking log: steps, active minutes and distance. Set your own goal, whether that is 8,000 or 10000 steps. The worked example covers nine months of one person's daily steps, 259 days logged with a goal of 8,000, a week in bed in February and a 29-day streak on a walking holiday in July. It makes a clear pedometer log and streak tracker from day one.\u003c\/p\u003e\u003ch2\u003eLight and dark editions\u003c\/h2\u003e\u003cp\u003eEvery download includes a light edition and a dark edition. Every tab is restyled, not just the dashboard, and both use the same formulas. Each comes filled with a worked example and blank, in Excel and in Google Sheets.\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\u003eLight edition: the Excel workbook filled with a worked example, and a blank one\u003c\/li\u003e\n\u003cli\u003eDark edition: the same two files in the dark design\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, which has one-click links to the Google Sheets versions (light and dark, 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 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\u003eDoes it sync with my watch or phone?\u003c\/h3\u003e\u003cp\u003eNo. It works with any watch, phone or pedometer because you copy three numbers a day into the Activity Log.\u003c\/p\u003e\u003ch3\u003eCan I set my own step goal?\u003c\/h3\u003e\u003cp\u003eYes. You set the daily goal, and every day on the Step Calendar is colored against it.\u003c\/p\u003e\u003ch3\u003eHow are streaks counted?\u003c\/h3\u003e\u003cp\u003eA run of days on goal is counted as you log. Missing a day, or missing logging it, starts the streak again, and both the current and longest streaks are shown.\u003c\/p\u003e\u003ch3\u003eWhat is the difference between the light and dark editions?\u003c\/h3\u003e\u003cp\u003eOnly the look. Both have the same tabs and formulas, and both are included in every download.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597872234590,"sku":"OPX-217","price":12.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/step-tracker-walking-log-01.jpg?v=1790833164","url":"https:\/\/opxviashop.com\/products\/step-tracker-walking-log","provider":"OPXVIA","version":"1.0","type":"link"}