Runners get the blues too? What's this all about, you ask? Well, long ago before I became an Internet Junkie (in the 80's), I was an avid runner. I never reached anywhere near top level status (37:51 10k PR), but as with all my endeavors, I became obsessed with the sport. Along the way I developed a program in QuickBasic (I said it was a long time ago!). I named the program RunPro, and it attempted to project equivalent efforts for various distances based on user input of a specific distance and time. Eventually I developed an Excel spreadsheet to replace and greatly expand on the functionality of RunPro.
On this page you'll find all of my running programs/spreadsheets, and a whole bunch of links to other interesting training and racing information I've found on the web.
Jack Daniels' Training Tables - 06/02/06 (Excel 2002 Worksheet)
This Excel worksheet has become my pride and joy. In his 2nd Edition of "Daniels' Running Formula", Jack Daniels introduced the concept of assigning intensity points to workouts. Basically, the longer and/or faster the workout, the higher the intensity. Jack's tables present the info based on minutes run. Some time ago I set out to create an Excel spreadsheet to approximate intensity points from a mileage perspective. This utility provides a convenient means of comparing intensity levels of various workouts based on miles run, rather than minutes run. For general use, the worksheet provided default percent of Heart Rate values for 4 levels of runners - Novice, Intermediate, Advanced, and Elite. It also provides projected training and racing paces based on a race time input by the user. Since that first production, updates to the spreadsheet have run rampant, as I added more calculation tables than you can shake a stick at. Many of the added charts are related specifically to "Daniels Running Formula" and are so noted. While some are not directly related, they provide useful tools that enhance the overall Daniels experience.
Following are descriptions of the more significant updates as they are released.
Update: Revision 2.3 - 09/19/06
This added functionality really makes the Intensity Table worksheet more of an all-around tool for analyzing and planning training and racing strategies, based as closely as I could on on Jack Daniels' training guidelines. Therefore, I've changed the name of the file to DanielsTables2-3.xls
Update: Revision 2.6 - 10/04/06
Fixed a serious problem in Revision 2.3 with the drop down menu for selecting input race distance.
Update: Revision 2.7 - 10/29/06
Also, the Tempo Pace Calculation Table now calculates approximate distance to be run for threshold run of a given duration and pace. And a couple of utility calculators, including a freeform VDOT calculator for calculating VDOT from *any* race distance.
Update: Revision 2.8 - 01/12/07
Update: Revision 2.9 - 04/28/07
Update: Revision 2.9d - 01/20/08
Update: Revision 2.9e.0 - 05/11/08
Update: Revision 2.9f.00 - 07/22/08
Update: Revision 2.9g.00 - 01/20/10
Update: Revision 2.9h.00 - 11/13/10
Update: Revision 2.9i.00 - 01/21/11
Update: Revision 3.00.00 - 05/02/11
Runner's Projections v3.0
This is the predecessor to the DanielsTables sreadsheet above. It was written with QuicBasic and compiled for DOS. I have confirmed it runs in Win98, ME and XP. Users of other platforms will just have to try it.
I no longer use this program myself, and there will be no further updates. I'll maintain a download linke here primarily as a historical artifact. There is no mouse interface, strictly arrow key operation. The formulas used for these calculations are based on pace calculation information collected from several running books popular in the mid 80's. It does not take into consideration age, sex or weight. see the links below for several interesting calculators that make age/sex/weight graded calculations.
In addition to equivalent racing efforts, the program breaks out some rough guide lines outlining basic appropriate training levels given a specific racing performance. You can log your races in a simple text file that is easily edited by Windows Notepad. You can also get a nice race result print-out showing equivalent efforts for all distances.
Update - 02/14/06
To download, left click and save the following zip file to your PC. Read the short install.txt file for info on installing RunPro v3.0.
Riegel Predictor (Excel 2002 Worksheet)
This Excel workbook features a Riegel powered Race Predictor tool similar to RunPro. It also has some interesting additional features, including a worksheet for calculating your own Riegel exponent (Rx), allowing you to fine tune the Predictor to your personal race profile. There are several additonal worksheets modeling some other popular coaches' prediction models, as well as modeling actual world record times. This provides an interesting means of analyzing how well these models correlate with each other. This file was developed in Excel 2002. No guarantees it will work with earlier versions of Excel.
The above spreadsheets and programs brought to you by - ElectricBlues.com
Daniels' Running Formula
There are many fine running books available, and I've read several. This is the one I most often refer to. Daniels manages to present fairly detailed and scientific information in a way that's reasonably easy to comprehend, and he covers all aspect of training necessary to become the best runner you can be. The heart of Daniels' program is his VDOT method, relative V02max values from which all training and racing paces can be derived.
Buy Daniels' Running Formula at Amazon.com.
Oxygen Power: Performance Tables for Distance Runners - by Jack Daniels and Jimmy Gilbert
Those of you familiar with Jack Daniels' VDOT method of training and race projections may be interested in the following info. Jack first introduced his VDOT method in 1979, in a spiral bound book he co-authored with Jimmy Gilbert entitled "Oxygen Power". This book is comprised mostly of a series of tables listing performance VDOT values incremented by .1 (yes, one tenth!). The tables list VDOT data for a wide array of metric and mile distances. However, there are no listings for training paces, as there are in his newer publications. In the back of Oxygen Power is an appendix section discussing the philosophy, formulas, and procedures used to generate the VDOT tables. This book has been out of print for some time, however, a plastic bound copy can be obtained by sending a check for $20 to the following address:
Jack Tupper Daniels
Arthur Lydiard's Athletic Training - by Arthur Lydiard
This is a Lecture summary in book format in which Lydiard covers many aspects of his training methodology.
View the file in html:
or download the file in .pdf format:
Coaching Quotes and other Tidbits
Speedwork During Base Phase?
I asked Pro Coach Greg McMillan "what's the harm in doing speed work during the base phase?" Here's his reply:
"I'll fall back to Lydiard who learned that during aerobic base building it is not good to 'pull down the ph' as he stated it. The reason is that a large build up of lactic acid (lowering the ph in the cell) can destroy the aerobic enzymes - not what you want during this period of training. We also know from Lydiard that heavy anaerobic training cannot be sustained for long periods of time so it's better to only insert it at appropriate times."
Drink a Slim-Fast Shake after your Long Run
Also from Coach McMillan's website, this recovery tip:
"...researchers discovered that the enzyme, glycogen synthase, that turns carbohydrates from your food into glycogen for storage in your muscles is most active immediately after exercise. If you ingest carbohydrates soon after exercise, your muscles store two to three times as much glycogen than if you wait until you eat your post-workout meal, usually two to three hours later."
Get all the details at the following URL from McMillan's site:
An Interesting Twist on Marathon Training - By Greg McMillan
Follow the link below to an article that turns traditional marathon training upside down.
Jack Daniels on Stride Rate
In his book "Daniels' Running Formula" (2nd edition), Jack Daniels suggests a stride rate of around 180 steps per minute. Being 6'2", and (at the time) having a much slower turnover (155-160), I wondered if such a quick turnover applied to all runners, regardless of height. Here's his reply:
"As for stride rate, even the 6-6 guy (who plaed 9th in the Olympic marathon, and was a subject of mine for many years) turned over at 180. On the other hand, I assume that some people may not be built to go that quickly, but I have not come in contact with one who was a good runner. Maybe that is a factor that has allowed some to be better than others? It does make sense that a very slow turnover produces more air time and harder foot falls, and possibly more chance of injury, than the shuffling stride you find you are doing when turning over that quickly. Nothing applies to everyone as to proper mechanics and proper training. Jack"
Needless to say, after reading that I worked on improving my stride rate!
The Minimal Effective Training Program - By Herm (Me!)
Want to train, but your job/life/family keep you really busy? Wonder what would be the least amount of time you could put in that would still result in good training results? You can get in surprisingly good shape on a 4 times per week schedule, training only 30 minutes most days. In the article linked below I offer my own suggestions for a 4 day schedule, designed after much personal experience, observation of others' experiences, and after reading a good many articles and books.
SideNote: As an alternative to the plan offered above, which favors a predominance of easy running, seasoned runners seeking a more aggressive "few days per week" program can check out the FIRST system (Furman Institute of Running & Scientific Training), a 3x per week training schedule (plus crosstraining) modeled around 3 key workouts including an interval session, a tempo session, and a long run session. I have no personal experience with this program, so I can't comment on its effectiveness, but I would be concerned about injuries on a program that includes such a high ratio of fast running.
Effects of Excess Weight on Performance
Ever wonder how much a little extra baggage slows you down? There's a simple formula you can use to calculate a projected Daniels' VDOT fitness level based on a projected weight loss. Simply multiply your current weight by your current VDOT, then divide the result by your projected weight. For example, I currently weigh in at 195 lbs, and based on my most recent races at that weight my current VDOT is around 44. If I wanted to see what my projected VDOT would be if I were to lose 10 lbs, here's the formula...
As you can see, if I drop 10 lbs my VDOT would go up over two points! A 5k time at VDOT 44 is 22:14, while at VDOT 46 it's 21:24. That's a pretty significant improvement for simply losing 10 lbs. You can use one of the links provided farther down on this page to find your current VDOT and the projected races times of your weight adjusted VDOT. The formula works just as well with either pounds or kilograms.
This is only applicable for those with a little extra fat to lose. If so much weight is lost that muscle mass begins to diminish, race performances will suffer, not improve.
MAF - Dr. Philip Maffetone's Article on Aerobic Training
Want Speed? Slow Down!
Maffetone's 180 Formula (180-age, +/- an ajustment factor) for determining the ideal aerobic training heart rate results in very easy aerobic training paces, and lends support to the Hadd training method, covered in detail below. I believe strongly in the benefits of long bouts of purely aerobic training. Maffetone does caution that his recommended training pace will feel much too slow for many runners. Maffetone suggests it takes 3 months to build a good aerobic base.
My 180 Formula is 127 plus 5 points for 2 years or more of consistent training and racing. That's very close to the 135 bpm baseline recommended for me by Hadd. Interestingly, my typical training pace is currently 9 min/mile at a HR of 135bpm (73% of max), while my current 5k race pace is around 6:55-7:00. According to the MAF/5k comparison table near the bottom of Maffetone's article, a 9 min/mile relates to a 21:45/7:00 5k. Lines up pretty well, eh?
Hadd's Approach to Distance Training
A Base Training Plan with a Focus on Improving Lactate Threshold
[Download Hadd Article in Word Document] -
In an extremely long letsrun.com message thread from March 2003, Italian coach John Hadd (possibly an alias) explained his philosophies on endurance base training in painstaking detail. The underlying philosophy of Hadd's program that really grabbed my attention is the premise that not only is it OK to do lots of easy, gentle running, but in fact LOT's of EASY RUNNING IS A NECESSARY COMPONENT FOR ALL DISTANCE RUNNERS! This is not a new concept. Many, probably most coaches advocate training programs consisting of a majority of easy training miles. But Hadd's article is the one that got this concept to sink in for me.
The other major component of Hadd's program is Tempo Runs... long tempo runs of up to an hour at approximately marathon pace two to three times per week for many weeks..... between 12 and 20 weeks depending on the starting level of fitness.
As an injury rehab program, I began a modified version of Hadd's approach in July 2005 (way fewer miles and more easy/off days). Despite using a heavily watered down version, over the next four months I experienced significant improvements in my conditioning and some of the best, most enjoyable running since reviving my commitment to training two years ago. For me, accepting the notion that lots of easy running is not a waste of time, but rather a key ingredient of a successful training program, allowed me to train much more comfortably, while still feeling satisfied that I was doing beneficial training. All that easy running also allowed a chronic two year old knee issue to heal. I'm sold on Hadd's approach, and anxious to begin a more complete implementation, which I plan to do early Summer 2006.
Mr. Hadd, if you're out there and you run across this page, please drop me a line at
Training Update - 05/01/06
While those improvements aren't dramatic, it's important to note I was dealing with a 2 year old, persistent, nagging knee problem. Following a highly modified version of Hadd's principles (much reduced work load), I was able to recover from the knee issue AND improve my 5k and 10k race times.
For the May 2006 - April 2007 season, I embarked on a full fledged Hadd based training program. Still watered down from Hadd's program in terms of mileage (50-60mpw rather than 100+ mpw), I did follow his program as closely as possible in terms of workout types. For anyone interested, below is a link to my real-time, detailed account of this season as it unfolded.
Below are a couple of links to a an analysis and somewhat counter-view of Hadd's paper.
Links to Running Info
Racing Statistics (World Records, etc)
Online Performance Calculators
Runworks.com's VDOT Calculator
Another nice Daniels' VDOT Calculator by the folks at AttackPoint.org
Run-down.com's Performance Predictors
Santa Clarita Runners Race and Training Pace Calculator.
HillRunner.com's Treadmill Conversion Chart
Age and Weight Grading Calculators
RunCoach's Advanced Calculator
Flyer Handicap Calculator
Boston's Heartbreak Hill Striders Age Graded Calculator
Jack Daniels' discussion of Endurance Training Principles.
Larry Simpspn's detailed discussion of Jack Daniels' VDOT Formula. - (Very deep stuff).
Joe Friel's Quick Guide to Training with Heart Rate, Power, and Pace (PDF file)
Description of Joe Friel's Training Zones based on Anaerobic Threshold Heart Rate
Joe's discussion of his 7 Basic Training Assumptions. So simple, yet so profound.
Joe Friel's discussion on Crash Training, a method of improving performance through supercomensation
Aerobic, Anaerobic, Lactate Threshold
Masters Athelete Physiology and Performance (MAPP)
Another explanation of Anaerobic Threshold
Good 2009 Running Times article discussing the Balance between Aerobic & Anaerobic Training.
This Combined Zone & Critical Zone Training Regimes
Excel Worksheet showing a table of Aerobic/Anaerobic Breakdown of Events
Marathon Training Plans
Pfitzinger 55 mile / 18wk Marathon Plan.
Pfitzinger 70 mile / 18wk Marathon Plan.
Hal Higdon's Novice to Advanced Marathon Plans.
Other Neat Links and Info
Download link to Greg Maclin's very cool Training/Racing HR Spreadsheet.
Heart Rate Training Zone Calculator
FIRST Training Method