Anyone have an Excel Spreadsheet Format for training?
https://docs.google.com/spreadsheet/ccc?key=0ArOSAbpEgDQQdGE4VzFGcDExQnBBQi1valBocV9FT3c
This may or may not be what you’re looking for, but hopefully it’s a start at least.
This is based off of Carmichael and Rutberg’s Time Crunched Triathlete so all of the paces and zones reflect that.
To use it, plug in values in the field test tab for the swim pace and bike / run heart rates. These values are used to calculate pace ranges on the “week” tabs. Duplicate the week tab and rename it to “Week #” and then enter that “#” into the yellow cell in H1. That allows it to pull data from the previous week for side by side comparison. The only cells that should be edited are yellow.
A couple things I never got around to adding were a reference to a specific field test to keep the pace ranges up to date, and functionality for the bike to use power data.
The link to the google doc spreadsheet is public but locked so it can’t be changed - I’m not sure if that’ll let you save it as an excel file or if I need to remove that lock. If you want to use it / build off it and you can’t save, let me know and I’ll try making it editable.
Did you make that? I made my own and it makes good use of charts and sumproducts to track weekly/monthly/annual totals for different activities, but this looks far more advanced. Would be interested in taking a look.
Yeah I started from scratch too. I needed more functionality than what was available in Excel so I learned (enough) VB & started using macros with buttons & the whole bit. I’ve added a bit more since that pic. It’s modular due to the weekly structure, & of course, there is an annual summary etc. PM me.