2016 Tracking
-
No new posts
Moderators: k9car363, alicefoeller | Reply |
2016-01-03 12:48 AM |
282 | Subject: 2016 Tracking Hey all, This spreadsheet is a variation on what I've been doing for the last couple years and I think I finally have it perfected (for my needs). While tracking my workout today it occurred to me that others might like it as well (and I know I would have liked it when I first started tracking my workouts 3 years ago).
It is a google docs spreadsheet so you will need to have a Google account to use it (well you could save a copy as an Excel file, but I Really like the fact that I can input my workouts in less than 15 seconds from my phone, tablet or PC and have it show up on the others for review later, and using Excel would ruin that).
It looks like it is blank but it is not. It will automatically calculate your daily, weekly and YTD pace (running & swimming), daily, weekly, and YTD speed (biking & other), Daily, weekly and YTD percentage elevation gain and loss, weekly and yearly Cadence and Heart Rate (properly weighted per km that you report those stats), Days until your next race, amount over/under your target weight, etc, etc.
I think it is all completely self explanatory except for perhaps the "Days 'til Race" column: for that one simply enter a 0 in that column on the date of any and all of your races and it will automatically show you how many days you have until those races.
If even one person likes/uses this then great, if not no harm done. So here it is: https://docs.google.com/spreadsheets/d/1DATSz91o5w4e5ZxRNBHTTsF2Po2sF9Li2V1zoiMBmek/edit?usp=sharing Note: It is view only, so simply select File>Make a Copy (While You Are Signed Into Your Google Account). Note two: It is Metric so if you prefer Imperial you can easily change the headers and formulas (or ask me and I can easily do it, but I'm not going to bother if no one wants it). |
| ||||
|
| |||
|
| |||
|