{"product_id":"workout-planner-dashboard-spreadsheet","title":"Workout Planner Dashboard Spreadsheet","description":"\u003cp\u003eThis workout tracker turns sets, reps and weight into weekly volume, personal records and a consistency grid without any sums of your own. It is for people doing strength training who want a training log that shows progress, in Excel or Google Sheets.\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. It fills itself from your logs, and the month picker switches the whole page between the full year and any single month.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eWorkouts done: sessions logged, the change on last month and a twelve-month strip\u003c\/li\u003e\n\u003cli\u003eWeekly volume, sets times reps times weight, with the chosen month highlighted\u003c\/li\u003e\n\u003cli\u003eA consistency grid with one square a day, shaded by sets, so gaps and streaks stand out\u003c\/li\u003e\n\u003cli\u003ePersonal records: your six heaviest lifts with first weight, best weight and the gain, plus a count of new records\u003c\/li\u003e\n\u003cli\u003eBody weight trend from your start weight, week by week, with waist and goal\u003c\/li\u003e\n\u003cli\u003eTraining split by muscle group, so you can see what you are skipping\u003c\/li\u003e\n\u003cli\u003eTop lifts by month on your three biggest lifts, and plan against done for each week\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eOne row per exercise\u003c\/h2\u003e\u003cp\u003eVolume is calculated on every line and totalled for the year, and your best lift per exercise is read straight off the log. As a gym planner and progress tracker, it also handles weigh-ins, food and habits in the same file.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eWorkouts:\u003c\/strong\u003e 600 rows, one per exercise, with volume worked out\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eExercises:\u003c\/strong\u003e your own list, which drives the workout drop-down\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eWeigh-Ins:\u003c\/strong\u003e 120 rows, seven measurements, change calculated per week\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eFood Log and Foods:\u003c\/strong\u003e 1,200 rows; type a quantity and the macros are looked up from your own list\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eHabits:\u003c\/strong\u003e a month of ticks, with no streak to break\u003c\/li\u003e\n\u003cli\u003e\u003cstrong\u003eDashboard, Setup and Start Here\u003c\/strong\u003e\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eLight and dark editions\u003c\/h2\u003e\u003cp\u003eEvery download includes a light edition and a dark mode 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\u003eA logbook, not medical advice\u003c\/h2\u003e\u003cp\u003eThe file does arithmetic on numbers you enter. It does not set targets for you and cannot tell you whether a target is right for you. For that, ask a doctor or a registered dietitian.\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. No Microsoft 365 subscription required.\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. No Google account is needed for the Excel files.\u003c\/li\u003e\n\u003cli\u003eNo add-ins, no macros 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 files are for personal use on your own devices; please do not share or resell them. 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 the Google Sheets versions, which need a free Google account.\u003c\/p\u003e\u003ch3\u003eHow is training volume calculated?\u003c\/h3\u003e\u003cp\u003eVolume is sets times reps times weight, worked out on every exercise row and totalled by week and for the year.\u003c\/p\u003e\u003ch3\u003eCan I add my own exercises?\u003c\/h3\u003e\u003cp\u003eYes. The Exercises tab is your own list, and it drives the drop-down on the Workouts tab.\u003c\/p\u003e\u003ch3\u003eHow does it find personal records?\u003c\/h3\u003e\u003cp\u003eIt reads your best weight per exercise from the log, and counts a new record every time a lift beats all your earlier entries.\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":67597862568030,"sku":"OPX-045","price":13.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/workout-planner-dashboard-spreadsheet-01.jpg?v=1790832182","url":"https:\/\/opxviashop.com\/products\/workout-planner-dashboard-spreadsheet","provider":"OPXVIA","version":"1.0","type":"link"}