Home | Training Log | Guestbook
WTC Photos
thinnmann@yahoo.com

Excel Training Log ~ Forever Beta2

This version of the training log can be used for any year. Just set it up on the Settings worksheet and the dates automatically fill themselves in.

This is the Settings Worksheet:

Click to enlarge

Updated January 18, 2010, 22:00 Eastern US time.

Google

The Daily Log Features:

fields for two running workouts per day

worksheet for cycling & swimming

comments about your workouts

shoe and bicycle mileage tracking

worksheet for race results and personal records

monthly percentage of barefoot running

calorie data tracking & graphing

heart rate data tracking & graphing

hours sleep tracking & graphing

keeps track of distance and time

worksheet for planning your dietary carb/fat grams in training ratios

worksheet for planning your workouts

intuitive and easy to use and read

user customizable

Get the Training log by clicking here!

Download Here :)

or

 

Excel Training Log for older versions of Excel
(works on 5.0, 95, 97-2003)

Dear Log Users ~ This is important:

PLEASE SEND ME YOUR EMAIL ADDRESS. 

This log is "Forever Beta".  It will work for any year from now on.  I will notify you if any errors crop up this year.

If you find errors, please tell me via email!

If you like the log, or have suggestions, I would love to hear from you!

Please let me know how it helps you keep focused, motivated, reach your goals.

Good luck with your training!

THANKS!

The Log Automatically Calculates:

average pace for each run, bike ride or swim

weekly, monthly, and yearly totals

a graph of weekly mileage
cumulative shoe & bicycle mileage

 

Download Help: 

You must have Excel or a compatible office program to use this log.

Click on any the download link and save the file to your computer in a place you can find it - your desktop or documents folder, for example.

ZIP FILES - you will have to unzip them to your computer to use them.

If you don't have Excel, use OpenOffice.  It is free - get it here.

If you have ideas for customizing this log, or find any errors, please let me know - !

READ ME ~ FROM THE DIRECTONS FOR USING THIS TRAINING LOG

The main focus of this log is for tracking your daily running mileage for one or two workouts daily. It has evolved into a comprehensive training log that includes the ability to track and analyze data for cycling, swimming, calories, weight, heart rate, training plans, races, shoes and bikes.

The log tracks your data for workout times and calculates your pace per mile. It will accrue your weekly, monthly, and yearly total distance. It will create a chart for your weekly running mileage. It will track the number of mileage you have on up to six pairs of shoes and six bikes. If you have a little Excel knowledge, most functions are fairly self-explanatory. If you measure your distances in kilometers, just enter them and all the formulas will work just fine; pace per kilo will result instead of per mile, for example.

Enter as much or as little information as you like, using the tabs below to access the worksheets. Some explanation is written on the worksheets and some is revealed through mouseover comments. There is currently sample data entered on some worksheets for illustration, which you should delete or over-write. Some content is locked to prevent accidental overwriting of critical formulas, but there is no password to unprotect.