Bill Moore wrote:I have the spreadsheet that calculates the workouts. There are notes from Chris Galley, so if we can find him, we should be able to find the original spreadsheet, since I may have made changes to it.
I created a spreadsheet to create level 4 workouts that anyone is welcome to try:
http://www.eudemonia.co.uk/wplevel4.xls
First put your 2K time in the cell at the bottom left. Then choose a level 4 sequence from the left hand column and it shows SPM, pace, and duration for each segment. It calculates the intended distance that should be covered for that sequence, and also a cumulative distance for the session thus far. Delete any redundant rows, but use "File/Save as ..." so that the original file is kept. The bottom left cell then shows the total number of strokes for the whole training session.
The file includes Mike's subsequent odd-number SPM sequences.
Two caveats (there may be more):
1. The spreadsheet contains code (that I have written myself, so I know it is safe) and so the file will generate a macro warning when opened. I am confident that there is no danger in it, but you will have to choose yourself.
2. I have worked out the pace for each segment using a formula
[
2Kpace*((152-(SPM*2))/96)], rather than a lookup table, so the suggested pace may vary from Mike's tables by a second (because I have retained the decimal component rather than rounding to an integer). However, the formula was derived from the extended L4 tables published on machars.net, and sourced from Mike himself (allegedly).
Hope MC isn't upset or offended by this, but if he is I shall withdraw it immediately.
Cheers
Dave