individual comparative effort google sheet
03/11/2020 1:09:50 AM
Coach
SUBSCRIBER
Joined: Aug 2017
Posts: 42
I have spent several month working on an individual comparative effort google sheet that I can use for 5 different paces, 400, 800, 1600, 3200 and 5K (each has their own table) and that gives comparative efforts for the Half Mar 10K 5k 3200 3000 2000 1600 1000 800 600 500 400 300 200 150 100 50. The separate table also gives the splits for 50 100 150 200 300 400 600 800 1000 1200 1400 1600 1800 2000. I made this to fit my needs. I have an individualized plan for everyone of one my athletes. This allows me to help take that individualization even further You might ask what the difference between this and the comparative effort calculators available on the internet...several things. I can duplicate one of these for every athlete I have (each athlete I have has their own protected sheet they keep theirs in) and use their goal pace (or PR) depending on how you train your athletes and they have every training pace and split at their fingertips Once their GP or PR is met simply make them a new one. My kids write their splits for the workout on medical tape and put it somewhere on their body that they can see. I have a 400, 800, 1600, 3200, and 5K to meet all my training needs, each with their own . I change the time for the 400 and just the 400 chart changes If I have a kid who is a 3200 meter person then I use just the 3200 one. If I have a kid that runs the 800, 1600, and 3200, I have one for every event..if we are doing @800 meter pace stuff...then I use whatever distance has the fastest 800. I use Goal Pace and if their paces are realistic they match up pretty good. Please take a look at the restricted one. Nothing on it changes. If you are interested in purchasing one, Email me at coachcraghead@gmail.com. I am asking $10 for them. It should be noted the formula I used for this is one devised by Pete Riegel in the late 70s. It has withstood the test of time as a formula as accurate as any out there for running. In the early 80s, Riegel refined it for other sports for an article entitled “Athletic Records and Human Endurance” published in America Scientist. Here is a locked version of it. Please feel free and have a look [url=https://docs.google.com/spreadsheets/d/1_0gXTtIWCKrJZn5tLEvW8xqX_q2cxjfzneq1QLx7Ij4/edit?usp=sharing][url=https://docs.google.com/spreadsheets/d/1_0gXTtIWCKrJZn5tLEvW8xqX_q2cxjfzneq1QLx7Ij4/edit?usp=sharing]https://docs.google.com/spreadsheets/d/1_0gXTtIWCKrJZn5tLEvW8xqX_q2cxjfzneq1QLx7Ij4/edit?usp=sharing[/url][/url]
I have spent several month working on an individual comparative effort google sheet that I can use for 5 different paces, 400, 800, 1600, 3200 and 5K (each has their own table) and that gives comparative efforts for the Half Mar 10K 5k 3200 3000 2000 1600 1000 800 600 500 400 300 200 150 100 50. The separate table also gives the splits for 50 100 150 200 300 400 600 800 1000 1200 1400 1600 1800 2000. I made this to fit my needs. I have an individualized plan for everyone of one my athletes. This allows me to help take that individualization even further

You might ask what the difference between this and the comparative effort calculators available on the internet...several things. I can duplicate one of these for every athlete I have (each athlete I have has their own protected sheet they keep theirs in) and use their goal pace (or PR) depending on how you train your athletes and they have every training pace and split at their fingertips Once their GP or PR is met simply make them a new one. My kids write their splits for the workout on medical tape and put it somewhere on their body that they can see.

I have a 400, 800, 1600, 3200, and 5K to meet all my training needs, each with their own . I change the time for the 400 and just the 400 chart changes If I have a kid who is a 3200 meter person then I use just the 3200 one. If I have a kid that runs the 800, 1600, and 3200, I have one for every event..if we are doing @800 meter pace stuff...then I use whatever distance has the fastest 800. I use Goal Pace and if their paces are realistic they match up pretty good.

Please take a look at the restricted one. Nothing on it changes. If you are interested in purchasing one, Email me at coachcraghead@gmail.com. I am asking $10 for them.

It should be noted the formula I used for this is one devised by Pete Riegel in the late 70s. It has withstood the test of time as a formula as accurate as any out there for running. In the early 80s, Riegel refined it for other sports for an article entitled "Athletic Records and Human Endurance" published in America Scientist.

Here is a locked version of it. Please feel free and have a look

03/11/2020 8:19:01 AM
Power User
Joined: Nov 2005
Posts: 2044
@ncxctrackcoach awesome coach. I am a novice with this stuff. Is there anyway to copy this so we can have an editable sheet?
@ncxctrackcoach awesome coach. I am a novice with this stuff. Is there anyway to copy this so we can have an editable sheet?
03/11/2020 1:24:37 PM
Coach
SUBSCRIBER
Joined: May 2008
Posts: 223
@bantazmo Looks like proprietary formulas to make the math happen, that's why he's asking to sell access. I like it and am working on something similar and very clearly I have a lot left to do to make it look this good! There are a lot of hours poured into this.
@bantazmo

Looks like proprietary formulas to make the math happen, that's why he's asking to sell access. I like it and am working on something similar and very clearly I have a lot left to do to make it look this good! There are a lot of hours poured into this.
03/11/2020 1:47:49 PM
Coach
Joined: Dec 1969
Posts: 836
[quote=coachterry]@bantazmo Looks like proprietary formulas to make the math happen, that's why he's asking to sell access. I like it and am working on something similar and very clearly I have a lot left to do to make it look this good! There are a lot of hours poured into this. [/quote]Actually the formulas are not proprietary. He mentioned that he used Pete Riegel's formula of T2 = T1*(D2/D1)^1.06. I believe that he is trying to sell the pre made spreadsheet since he took the time to put all of the info into cells and format it. I personally think the exponent should be adjusted for most people. I think the 1.06 is quite aggressive. I think for most high schoolers a 1.09-1.15 exponent would yield more reasonable times. Of course there are exceptions and some mega slow twitch types might use 1.06 and some very fast twitch types might go over 1.2.
coachterry wrote:
@bantazmo

Looks like proprietary formulas to make the math happen, that's why he's asking to sell access. I like it and am working on something similar and very clearly I have a lot left to do to make it look this good! There are a lot of hours poured into this.
Actually the formulas are not proprietary.

He mentioned that he used Pete Riegel's formula of T2 = T1*(D2/D1)^1.06.

I believe that he is trying to sell the pre made spreadsheet since he took the time to put all of the info into cells and format it.

I personally think the exponent should be adjusted for most people. I think the 1.06 is quite aggressive. I think for most high schoolers a 1.09-1.15 exponent would yield more reasonable times. Of course there are exceptions and some mega slow twitch types might use 1.06 and some very fast twitch types might go over 1.2.
03/11/2020 2:03:08 PM
Coach
SUBSCRIBER
Joined: Aug 2017
Posts: 42
yes there is a lot of work that went into this. That's why I am asking a small fee. [url=https://www.paypal.me/ChadCraghead]https://www.paypal.me/ChadCraghead[/url]
yes there is a lot of work that went into this. That's why I am asking a small fee.

https://www.paypal.me/ChadCraghead
03/12/2020 4:14:16 PM
Coach
SUBSCRIBER
Joined: Dec 1969
Posts: 1034
@ncxctrackcoach I just sent payment. Jake Holt holtj@eastnewton.org
@ncxctrackcoach
I just sent payment.
Jake Holt
holtj@eastnewton.org

You must be logged in to comment.

Click Here to Log In.