94.7 Speeds, Times & Indexes

[Guest Agteros]

So, after receiving an e-mail from the 94.7 Cycle Challenge with my time, various positions as well as index I started wondering about a few things, such as;

what speed is needed for a specific start group based on max index for the group

what index/start group my target time for next year will give.

Now of course this is all based on one road race, and some (hopefully) high school maths ...

 

The yellow blocks are groups where no max index was specified, and for those I show the index which will allow you to finish 6 hours after the last group starts.

 

edit: Colour not showing, these are groups +, TA/B, W, NN to OE

 

Hopefully somebody else finds it of at least SOME interest...

 

 

Group	Group Name	Lic	Sex	St Age	End Age	Maximum Index In Grp	Start Time	Proj Max Time	Avg Speed	Proj Max Finish
$94.7	Racing Elite and U23 Male	Y	M	19	29	12.77	05h30	02:21:45	40.08	07:51
#	Racing Tandems	N	B	12	99	25.93	05h35	02:46:56	34.04	08:21
!	Hand Cycle and Recumbent	Y	M	19	29	39.62	05h35	03:24:47	27.75	08:59
VA	Racing Vets 30 - 34 Male	Y	M	30	34	29.97	05h40	02:56:34	32.18	08:36
&	Racing Juniors Male	Y	M	17	18	13.70	05h45	02:23:17	39.66	08:08
VB	Racing Vets 35 - 39 Male	Y	M	35	39	22.41	05h50	02:39:22	35.65	08:29
VC	Racing Vets 40 - 44 Male	Y	M	40	44	23.26	05h55	02:41:08	35.26	08:36
VD	Racing Vets 45 - 49 Male	Y	M	45	49	24.39	06h00	02:43:32	34.74	08:43
VE	Racing Vets 50 - 54 Male	Y	M	50	54	29.63	06h05	02:55:43	32.34	09:00
VF	Racing Vets 55 plus Male	Y	M	55	99	29.89	06h10	02:56:22	32.22	09:06
%	Racing Elite and U23 Female	Y	F	19	29	28.72	06h15	02:53:28	32.75	09:08
WA	Racing Vets 30 - 39 Female	Y	F	30	39	19.94	06h20	02:34:27	36.79	08:54
WB	Racing Vets 40 - 49 Female	Y	F	40	49	21.94	06h20	02:38:24	35.87	08:58
WC	Racing Vets 50 Plus Female	Y	F	50	99	39.25	06h20	03:23:32	27.92	09:43
@	Racing Juniors Female	Y	F	17	18	27.36	06h25	02:50:13	33.38	09:15
*	Racing Juveniles Female	Y	F	12	16	28.62	06h25	02:53:14	32.80	09:18
+	Racing Juveniles Male	Y	M	12	16	77.27	06h25	09:04:00	10.44	15:29
A	Open Seeded	N	M	12	99	11.44	06h35	02:19:37	40.70	08:54
B	Open Seeded	N	M	12	99	14.10	06h39	02:23:57	39.47	09:02
C	Open Seeded	N	M	12	99	16.33	06h42	02:27:47	38.45	09:09
D	Open Seeded	N	B	12	99	18.49	06h45	02:31:42	37.46	09:16
E	Open Seeded	N	B	12	99	20.63	06h48	02:35:47	36.47	09:23
F	Open Seeded	N	B	12	99	22.51	06h51	02:39:34	35.61	09:30
G	Open Seeded	N	B	12	99	24.06	06h54	02:42:50	34.90	09:36
H	Open Seeded	N	B	12	99	25.40	06h57	02:45:45	34.28	09:42
I	Open Seeded	N	B	12	99	26.70	07h00	02:48:41	33.68	09:48
J	Open Seeded	N	B	12	99	27.99	07h03	02:51:43	33.09	09:54
K	Open Seeded	N	B	12	99	29.26	07h06	02:54:48	32.51	10:00
L	Open Seeded	N	B	12	99	30.47	07h09	02:57:50	31.95	10:06
M	Open Seeded & Sub Jun group	N	B	12	99	31.53	07h12	03:00:35	31.46	10:12
N	Open Seeded	N	B	12	99	32.57	07h15	03:03:23	30.99	10:18
P	Open Seeded	N	B	12	99	33.65	07h18	03:06:22	30.49	10:24
Q	Open Seeded	N	B	12	99	34.74	07h21	03:09:28	29.99	10:30
R	Open Seeded	N	B	12	99	35.70	07h24	03:12:18	29.55	10:36
S	Open Seeded	N	B	12	99	36.78	07h27	03:15:35	29.05	10:42
TA / B	Social Tandems	N	B	12	99	74.02	07h33	07:56:00	11.94	15:29
W	Corporate Bonds	N	B	12	99	73.86	07h36	07:53:00	12.01	15:29
X	Corporate Bonds	N	B	12	99	40.25	07h39	03:26:57	27.46	11:05
Y	Open Seeded	N	B	12	99	37.92	07h42	03:19:11	28.53	11:01
Z	Open Seeded	N	B	12	99	39.07	07h45	03:22:56	28.00	11:07
AA	Open Seeded	N	B	12	99	40.24	07h48	03:26:55	27.46	11:14
BB	Open Seeded	N	B	12	99	41.43	07h51	03:31:07	26.91	11:22
CC	Open Seeded	N	B	12	99	42.56	07h54	03:35:16	26.39	11:29
DD	Open Seeded	N	B	12	99	43.80	07h57	03:40:01	25.83	11:37
EE	Open Seeded	N	B	12	99	44.97	08h00	03:44:42	25.29	11:44
GG	Open Seeded	N	B	12	99	46.21	08h03	03:49:53	24.72	11:52
HH	Open Seeded	N	B	12	99	47.72	08h06	03:56:31	24.02	12:02
II	Open Seeded	N	B	12	99	49.16	08h09	04:03:13	23.36	12:12
JJ	Open Seededvvv	N	B	12	99	50.00	08h12	04:07:18	22.98	12:19
KK	Open Seeded	N	B	12	99	52.18	08h15	04:18:34	21.97	12:33
LL	Open Seeded	N	B	12	99	55.17	08h18	04:35:49	20.60	12:53
MM	Open Seeded with 50+10 group	N	B	12	99	59.29	08h21	05:03:44	18.71	13:24
NN	Open	N	B	12	99	70.84	08h25	07:04:00	13.40	15:29
PP	Open	N	B	12	99	70.56	08h29	07:00:00	13.53	15:29
QQ	Open	N	B	12	99	70.28	08h33	06:56:00	13.66	15:29
RR	Open	N	B	12	99	69.99	08h37	06:52:00	13.79	15:29
SS	Open	N	B	12	99	69.69	08h41	06:48:00	13.93	15:29
TT	Open	N	B	12	99	69.39	08h45	06:44:00	14.06	15:29
UU	Open	N	B	12	99	69.09	08h49	06:40:00	14.21	15:29
VV	Open	N	B	12	99	68.78	08h53	06:36:00	14.35	15:29
WW	Open	N	B	12	99	68.46	08h57	06:32:00	14.50	15:29
XX	Open	N	B	12	99	68.13	09h01	06:28:00	14.64	15:29
YY	Open	N	B	12	99	67.80	09h05	06:24:00	14.80	15:29
ZZ	Open	N	B	12	99	67.46	09h09	06:20:00	14.95	15:29
OA	Open	N	B	12	99	67.11	09h13	06:16:00	15.11	15:29
OB	Open	N	B	12	99	66.76	09h17	06:12:00	15.27	15:29
OC	Open	N	B	12	99	66.40	09h21	06:08:00	15.44	15:29
OD	Open	N	B	12	99	66.03	09h25	06:04:00	15.61	15:29
OE	Open	N	B	12	99	65.65	09h29	06:00:00	15.78	15:29

 

Agteros2008-12-11 11:35:33

[TiBones]

 Hey Agteros, interesting but please post as 71seperate threads. Info overload!????!!!???

Just kidding - don't understand a word. I just starts where they tell me to.

 

[Guest Agteros]

 

 Hey Agteros' date=' interesting but please post as 71seperate threads. Info overload!????!!!???

Just kidding - don't understand a word. I just starts where they tell me to.

[/quote']

 

Ok, lets take my past 94.7 and hopefully my next 94.7

I did a 3:12 from YY and received an index of 35.92 for my effort.

An index of 35.92 would have place me in group S (max index of 36.78)

 

Next year I'd like to do a 2:50.

 

A time of 2:50 should have placed me in group J for the past event. The index for group J was 27.99 (which is the index I should chase during the coming year). The average speed I should aim to maintain for a race is 33.09km/h (based on max index for group J)

 

Hopefully this will allow me to ride with a bunch of similair abilities, and not do a 94km obstacle time trial

 

[Mighty Spoke]

So the A group has a faster average speed and time than the Elites?

[Guest Agteros]

 

So the A group has a faster average speed and time than the Elites?

 

Based on the indexes provided, 11.44 vs 12.77... erm YES

 

[Thug]

Interesting.

 

Actual results for both "B" & "C" are slightly different than those projected.

 

"C's" winning time was 2:21 whereas "B's" was 2:24. The "C's" caught us "B's" at around the half way mark.

 

 

 

[Gumpole]

interesting, did you take every finisher in the group or streamline it a bit...

eg omit slowest 25% in each group who are sick/crash/multiple punctures/badly hungover etc....

 

I think this will give you a better idea of the speed that you should be riding at in a particular group

 

[Guest Agteros]

interesting' date=' did you take every finisher in the group or streamline it a bit...
eg omit slowest 25% in each group who are sick/crash/multiple punctures/badly hungover etc....

I think this will give you a better idea of the speed that you should be riding at in a particular group
[/quote']

 

I did the above as a guideline as to what/where to look at based on readily available information (Seeding indexes per start group). Kinda like taking you out from the dark into the dusk...

 

The above table is NOT meant to be used as a base to compare actual performances of the past event as the table is not based on actual results!

 

If I can get my hands on the complete dataset (race number, start group, finish time), the actual view of the past event will of course be a lot more insightful than the guestimations of required performance based on the published maximum indexes for each group...

 

So, can you get me the complete dataset?  I'd be rather happy to do all kinds of calcualations based on it.