• The Cycling News forum is looking to add some volunteer moderators with Red Rick's recent retirement. If you're interested in helping keep our discussions on track, send a direct message to @SHaines here on the forum, or use the Contact Us form to message the Community Team.

    In the meanwhile, please use the Report option if you see a post that doesn't fit within the forum rules.

    Thanks!

CQ ranking

Page 117 - Get up to date with the latest news, scores & standings from the Cycling News Community.
Skibby the bush kangaroo said:
Here's my attempt at the current optimum team. Think it would have costed 7498 using 33 riders and has so far yielded 23085 pts (based on the 11th Sept update on cqranking):

GILBERT Philippe
VOECKLER Thomas
WIGGINS Bradley
CUNEGO Damiano
LEIPHEIMER Levi
COBO ACEBO Juan Jose
MOLLEMA Bauke
KITTEL Marcel
PONZI Simone
PERAUD Jean-Christophe
MORENO FERNANDEZ Daniel
GERRANS Simon
POELS Wout
GALLOPIN Tony
HERMANS Ben
FROOME Chris
PINOT Thibaut
DEGENKOLB John
KIRYIENKA Vasil
BRUTT Pavel
VANDE VELDE Christian
TEN DAM Laurens
VANENDERT Jelle
LIGTHART Pim
SERGENT Jesse
KESSIAKOFF Fredrik
NIZZOLO Giacomo
SCHUMACHER Stefan
GUARDINI Andrea
DEGAND Thomas
CLARKE Simon
DOWSETT Alex
TABORRE Fabio

I may have got some help from integer programming software...

That's extremely close to what I have come up with except for a few riders. What's that program you're referring to?
 
Jul 31, 2010
77
0
0
Visit site
Timmy-loves-Rabo said:
that is odd, mine is done automatically..

looks like i might get a solif top 20 :cool:

--

riders who failed me

gesink (62%)
Terpstra (89%)
Maaskant (40%)
Boom (83%)
Slagter (69%)
Posthuma (70%)
Debusschere (77%)
Hoste (27%)
Anton (58%)
Pellozotti (0%)
Ricco (3%)

Boom won't fail us. If he can hold on in Britain I'm hoping I can hold onto a podium place in this game and then I'll join the list of people who podium once and then fade into mediocrity.
 
nobilis said:
I would also be interested, as I have some knowledge in R.
thanks

Here are the R commands I used. For it to work you need the lpSolve package to be installed. I used the csv files from cqranking from 31/12/2010 and 12/9/2011, they need to be in the working directory and called cq2010.csv and cq2011.csv. It had a problem finding Koning in 2010 and Rebellin was initially in the optimal list until I corrected his 2010 points to match the game guidelines:

library(lpSolve)
cq2010<-read.csv("cq2010.csv",header=TRUE) #end of 2010 csv from cqranking
cq2011<-read.csv("cq2011.csv",header=TRUE) #12 sep 2011 csv from cqranking
g<-match(cq2011$Name[1],cq2010$Name) #Match the top 1000 of 2011 with 2010
cq11 <- cq2011$CQ[1]
cq10 <- cq2010$CQ[g]
cq10[is.na(cq10)]<-0 #Assume zero points for 2010 if not found in list.
cq10[171]<-154 #Konig correction.
cq10[40]<-775 #Give Rebellin altered points

#Set up the integer programming problem
f.obj <- cq11
f.con <- rbind(rep(1,1000),rep(1,1000),cq10)
f.dir <- c("<=",">=","<=")
f.rhs <- c(33,25,7500) #Constraints on rider numbers and total 2010 cq points
fit1 <- lp("max",f.obj,f.con,f.dir,f.rhs,all.bin=TRUE)
cq2011$Name[which(fit1$solution==1)] #Riders corresponding to the solution
fit1$objval
sum(cq10[which(fit1$solution==1)])
cq2011$Name[which(fit1$solution==1 & cq10==0)]
 
Oct 18, 2009
999
0
0
Visit site
Hugo Koblet said:
Well I don't know what R is, but you're welcome to send me the commands anyway. Then I'll have a look at it :)

It's a collaborative statistical analysis software that you can download for free. For some type of analyses, you'll have to install specific libraries like the one Skibby used.
 
Oct 18, 2009
999
0
0
Visit site
Skibby the bush kangaroo said:
Here are the R commands I used. For it to work you need the lpSolve package to be installed. I used the csv files from cqranking from 31/12/2010 and 12/9/2011, they need to be in the working directory and called cq2010.csv and cq2011.csv. It had a problem finding Koning in 2010 and Rebellin was initially in the optimal list until I corrected his 2010 points to match the game guidelines:

library(lpSolve)
cq2010<-read.csv("cq2010.csv",header=TRUE) #end of 2010 csv from cqranking
cq2011<-read.csv("cq2011.csv",header=TRUE) #12 sep 2011 csv from cqranking
g<-match(cq2011$Name[1],cq2010$Name) #Match the top 1000 of 2011 with 2010
cq11 <- cq2011$CQ[1]
cq10 <- cq2010$CQ[g]
cq10[is.na(cq10)]<-0 #Assume zero points for 2010 if not found in list.
cq10[171]<-154 #Konig correction.
cq10[40]<-775 #Give Rebellin altered points

#Set up the integer programming problem
f.obj <- cq11
f.con <- rbind(rep(1,1000),rep(1,1000),cq10)
f.dir <- c("<=",">=","<=")
f.rhs <- c(33,25,7500) #Constraints on rider numbers and total 2010 cq points
fit1 <- lp("max",f.obj,f.con,f.dir,f.rhs,all.bin=TRUE)
cq2011$Name[which(fit1$solution==1)] #Riders corresponding to the solution
fit1$objval
sum(cq10[which(fit1$solution==1)])
cq2011$Name[which(fit1$solution==1 & cq10==0)]

thanks!
I'll try it once I receive my new laptop. My old one had a heart attack.
 
I'm starting to get a hang of all this excel stuff. Atleast I've made yet another cool feature in the spreadsheet, which allows you to easily see any team you like.

In the "Rankings" tab every team name now has a link to the teams tab, which means that if you click on a team name you'll be taken directly to that teams tab, where you can see which riders are in this team.

If you want to go back to the "Rankings" tab, simply click on the name of the team in the colomn A1.
 
May 25, 2010
3,371
0
0
Visit site
Unfortunately my excel knowledge is only rudimentary so unless I was going to do it manually (which would take forever and ever) I have no clue. :D
 
Hugo Koblet said:
I'm starting to get a hang of all this excel stuff. Atleast I've made yet another cool feature in the spreadsheet, which allows you to easily see any team you like.

In the "Rankings" tab every team name now has a link to the teams tab, which means that if you click on a team name you'll be taken directly to that teams tab, where you can see which riders are in this team.

If you want to go back to the "Rankings" tab, simply click on the name of the team in the colomn A1.

that's great - ive been meaning to ask for this as it will be really useful and add to the enjoyment of the game as it will be easier to assess the teams near to your team, and whether you might be able to overtake them (or if they're a threat to overtake you!).

Making progress on my 2012 team, but too many cheap deals! will be difficult to get up to 7000 and down to 33.

a potential addition for next year could be that Mr Smith wants to start a feeder/development team. if the main team budget is reduced by 500, perhaps that 500 goes into an u23 team of say 12-15 riders with that competition running alongside the main one. this helps to bring u23 races into the game more (which ive followed much closer this season looking for riders for next year). the way i see it, you could include u23s on bigger teams (ie not themselves on u23 teams), but they're likely to be more expensive and take up lots of your budget, and might be risky as they learn the pro ranks.

as for my tilt at the title - EBH's canadian virtual no-show and GT's boni sprint crash, means i will now be content with a strong top ten (kessiakoff could have secured me a podium, if he could have maintained his GC position). that is unless Rasmussen is suspended before seasons end, and a similar fate should befall say Cobo - (try changing the figures in the 2011 rankings for these 2 riders to 0 and see what the table looks like :))
 
Update 36

A pretty quiet week. Points for three 1.1 races and Tour of Britain have been handed out, and the teams with Lars Boom did pretty well - the five highest scoring teams all had Boom in it. Kwibus even moves into the top 10 thanks mainly to Boom, Bozic and Wegmann, while theyoungest moves out of the top 10.

ingsve is still leading with more than 1000 points and he can almost smell the victory now, although the Worlds might change a bit in the top 10.

The spreadsheet has now been updated with a "Rank this week" colomn as well as links from the "Rankings" tab to the teams tabs. Simply click the name of a team in the "Rankings" tab and you'll be taken to that teams tab. To return, click on the name of the team in the top left corner (in the A1 box).

Top 10:

1. (1) ingsve - 12779
2. (2) Waterloo Sunrise - 11772
3. (3) Handbrake - 11648
4. (4) mc_mountain - 11383
5. (7) kurtinsc - 11316
6. (5) Sneekes - 11269
7. (6) The Hitch - 11193
8. (8) Armchair Cyclist - 11094
9. (9) nvpacchi - 11018
10. (14) Kwibus - 10969

This weeks high scorers:

1. auto de fé - 346
2. EvansIsTheBest - 315
3. nobilis - 310
4. will10 - 298
5. Kwibus - 297

This weeks high jumpers:

1. EvansIstheBest +6
2. Kwibus +4
2. AntonioRossi +4
2. Moondance +4
5. Mellow Velo +3
5. Jakob747 +3
5. coppiman +3

Download:
http://www.megaupload.com/?d=TPMXWW1N
 
Oct 18, 2009
999
0
0
Visit site
Hugo Koblet said:
Update 36

A pretty quiet week. Points for three 1.1 races and Tour of Britain have been handed out, and the teams with Lars Boom did pretty well - the five highest scoring teams all had Boom in it. Kwibus even moves into the top 10 thanks mainly to Boom, Bozic and Wegmann, while theyoungest moves out of the top 10.

ingsve is still leading with more than 1000 points and he can almost smell the victory now, although the Worlds might change a bit in the top 10.

The spreadsheet has now been updated with a "Rank this week" colomn as well as links from the "Rankings" tab to the teams tabs. Simply click the name of a team in the "Rankings" tab and you'll be taken to that teams tab. To return, click on the name of the team in the top left corner (in the A1 box).

Top 10:

1. (1) ingsve - 12779
2. (2) Waterloo Sunrise - 11772
3. (3) Handbrake - 11648
4. (4) mc_mountain - 11383
5. (7) kurtinsc - 11316
6. (5) Sneekes - 11269
7. (6) The Hitch - 11193
8. (8) Armchair Cyclist - 11094
9. (9) nvpacchi - 11018
10. (14) Kwibus - 10969

This weeks high scorers:

1. auto de fé - 346
2. EvansIsTheBest - 315
3. nobilis - 310
4. will10 - 298
5. Kwibus - 297

This weeks high jumpers:

1. EvansIstheBest +6
2. Kwibus +4
2. AntonioRossi +4
2. Moondance +4
5. Mellow Velo +3
5. Jakob747 +3
5. coppiman +3

Download:
http://www.megaupload.com/?d=TPMXWW1N

thx for the update and all the new features! It's been a pretty good end of season for me.
Can I ask, if it's not bothering for you, to upload the spreadsheet on easy-share as well, because i can't access the megaupload site.
Thx
 

TRENDING THREADS