46 cyclists - how to pick?

[wheelnut]

Any tips how to pick form 46 cyclists I have?

I need to reduce to 25 of course to help with training, wages etc but hard to choose which ones :-)

Stay with all GB team (75% are Uk cyclists)
Stay with youngsters and build for future?
Stay with older for results/money

Any tips or tools to do this would be appreciated...

Cyclist FL HI MO DO SP TT ST BA XP LS HE WE AG
T. Duquenne 3 8 10 1 9 8 11 16 13 2 188 74 35
T. Chocron 4 10 7 6 7 8 10 10 8 2 176 57 33
A. Agoff 4 11 6 4 7 9 5 11 7 0 182 79 29
C. Blijleven 4 5 13 1 5 7 10 14 14 1 202 93 34
I. Frens 5 8 7 6 7 8 9 8 9 0 178 70 30
R. Bretto 4 9 7 3 8 8 5 14 9 2 192 87 32
L. Rauch 7 5 9 1 3 10 9 12 11 1 168 64 34
F. Buckless 5 7 6 5 7 8 17 18 19 15 174 54 36
A. Sidley 5 8 5 3 7 7 13 18 10 3 178 60 37
Q. Castoldi 8 8 7 2 5 2 14 15 11 0 195 87 35
C. Lefebre 14 2 3 2 10 7 2 4 5 3 172 66 34
B. Dilgard 0 7 2 6 5 9 3 7 6 1 198 93 28
N. Boeken 2 2 7 4 2 7 10 3 3 0 181 77 23
D. Ofsak 0 3 6 5 0 7 6 3 3 0 178 77 21
J. Romijn 0 0 8 1 8 5 3 8 7 3 164 57 29
R. Ososki 1 2 7 3 0 7 2 3 3 4 191 72 22
M. Mehserle 1 0 7 5 2 6 9 2 3 2 162 56 21
K. Florea 2 0 7 6 1 5 9 2 3 0 165 60 23
D. Edis 1 1 7 3 5 4 1 7 4 2 166 57 22
M. Hanno 7 0 4 4 12 1 8 11 10 1 177 72 30
J. Linzie 5 0 5 7 2 4 10 2 1 0 180 72 23
F. Legore 7 2 4 1 4 3 7 6 2 3 166 60 24
K. Kunter 3 1 7 4 3 1 4 11 3 1 161 56 23
S. Hoefel 4 4 2 3 2 5 8 10 1 2 187 86 23
B. Delaremore 2 2 7 3 2 1 10 19 1 3 165 55 26
B. Vincenzetti 3 0 9 1 2 0 7 13 4 3 165 65 24
R. Constancio 0 2 8 0 3 1 9 5 1 0 168 67 22
K. Baggesen 6 1 6 1 2 1 10 13 2 0 169 52 23
H. Notis 8 4 2 0 2 3 9 9 2 0 181 74 25
N. Fourre 5 1 4 2 2 3 11 12 3 0 190 78 23
D. Chubicks 1 4 5 1 2 1 4 6 1 1 210 109 19
A. Girelli 9 1 3 2 1 2 12 13 4 0 188 78 25
I. Oblow 3 1 6 2 1 1 10 19 3 2 210 97 24
T. Laflore 4 0 7 3 0 0 7 3 2 1 208 100 19
A. Altmark 3 1 5 2 2 1 12 10 0 0 191 91 22
A. Greist 0 1 5 0 1 3 1 3 1 1 187 75 20
B. Cantoral 1 4 3 3 0 1 10 2 2 0 160 53 20
D. Rasbery 3 4 1 0 0 4 1 4 1 1 203 96 22
F. Van Brempt 7 2 0 8 1 0 12 12 2 1 186 84 22
J. Curella 4 3 2 1 0 2 1 4 1 1 210 91 20
G. Encino 2 4 2 2 1 1 0 10 0 0 172 57 22
H. Cashour 3 3 2 2 1 1 7 9 8 2 200 94 28
J. Nichell 2 2 0 3 0 4 6 0 1 2 194 83 19
S. Sahin 1 2 2 0 4 1 0 2 0 2 164 62 19
A. Scammahorn 2 1 1 3 2 2 15 0 3 3 188 79 20
G. Boelke 0 2 0 3 2 1 5 0 2 0 177 67 19

[evild]

If i were you i would go for a youngster team and start selling all your 30+ cyclists. They're not good enough to keep, they wont provide you much money.

[berdios]

I do something like a skill and potential ratio. I put them all in an Excel sheet and then I calculate the sum of there current skills (Flat, Hill, Mountain, Downhill, Sprint, Time trail) and you give all the youngsters 2 extra for every year blow like 35, and keep the best.

But this is a very static you, best is you check there progress in training individual and then see then ones who train faster en keep them.

I think there even is some kind of pre-made Excel, somewhere on the forum, where you can copy your riders in to calculate stuff like this.

[Poekie]

Don't forget to look at salary too. Overpaid riders should go.

[dustin]

Riders you never think about for a race, the riders with a less race days. Only if they are not for the future.

[wheelnut]

thx guys...I add all the skills and divide by the age to give a potential number. The older cyclists still come at the top however.

wages is a good shout...maybe points vs wages to see who gives the best return?

[DeRodeLantaarn]

I agree with above.
I put my riders also in a excel sheet.
So it is easy to see which riders aren't worth to keep.

But I would keep Buckless because of his LS 15.
He will drop down points but his LS is perfect for the major tours to my opinion.
I haven't checked his salary:)

[rarau]

After what skill you show them here?

Please put after age to see them better.
And also put them after mountain.

So 2 tables

For me is almost impossible to see them like are now posted

[berdios]

May 26, 2017 17:02:44 GMT 1 wheelnut said:

thx guys...I add all the skills and divide by the age to give a potential number. The older cyclists still come at the top however.

wages is a good shout...maybe points vs wages to see who gives the best return?

But a Youngster can gain skill, like 2 pops a season. If you calculate that in your formula you get different results

[eboese]

Any way you can put this in an Excel, Wheelnut? Happy to have a look at your team and give my opinion, but the current format is not making it very easy to do

[wheelnut]

happy to send you the xls..I have the team in excel already :-)

[wheelnut]

PS 46 cyclists are now only 35!

I have 5 on the edge of 21 so once not qualifying as U21 next season will pick only the best one or two....I have a few 19 year olds to carry on with for u21 races.

[berdios]

Nice job, for some reason I also have a hard time selling or fireing my "virtual" riders.