The 2012 CQ Ranking Manager Game

[Ruudz0r]

Hmm I had my team finalized (not handed in yet), but now again I have 3 riders who I want to be in who arent in yet, I hate myself!

 

[Kvinto]

of course Menchov can be a good pick, especially with the Tour 2012 route but tbh i don't see the obviousness in such a pick (though it is likely to pay out) and i won't change my team to include him

 

[jsem94]

I've lost faith in Menchov

 

[AussieGoddess]

Any Excell wizard out there that knows how I can count how many times a name occours over various sheets?

Would be fun to publish a list that shows how many times all riders have been picked when we start the new season. So far I have been doing it manually but that's just with like 4 teams - it takes quite some work when there are 100 teams

Not an expert - but I can work a spreadsheet ok.

The only ways I can think of doing that involves a little bit of stuffing around. I can explain a little, but if it doesnt work easily, once I have sent in my team I am hppy if you want to email me your spreadsheet and I will do it for you.

To do yourself
- create new worksheet on front
- if your sheet names are just "sheet 1' "sheet 2" etc, then leave them as that.
- on your summary sheet, list in column B all riders on cq
- assuming you then have seperate sheets with everyones teams, with the names in cells A1:A33 ... your formula will be
=SUMPRODUCT(COUNTIF(INDIRECT("'Sheet"&ROW(INDIRECT("1:30"))&"'!A1:A33"),b1)) Where 1:30 is assuming you have 30 teams with the worksheets named Sheet1 Sheet2 ... to Sheet30.
- If you copy this formula down the list of riders, it will count the number of times each rider has been used. You can then sort (using autofilters is easiest) to see the highest numbers etc.
- when new teams are added, just change the sheet range (and copy down the column to all riders) to include new teams in the count

- If the worksheets are named the team names (or any other name), you will need to list the sheet names in a column in your summary sheet in column A, and name the range Tabnames, then your formula would be
=SUMPRODUCT(COUNTIF(INDIRECT("'"&TabNames&"'!A1:A33"),b1))


other than that - Countif would work, but would involve you nesting a countif for each sheet/team (still create summary sheet with each riders name in column b (assuming you named sheets by username)
eg =COUNTIF(AussieGoddess!$A$1:$A$32,Summary!A6)+COUNTIF(Boomcie!$A$1:$A$31,Summary!A6)+COUNTIF(TimmyLovesRabo!$A$1:$A$35,Summary!A6) (assumes 3 teams and summary sheet, with rider names in column a)

It is simpler for you to use, but take longer to set up. If you do this, make sure you use absolute cell references for the range so that you can copy down the formula to all riders ....and then again just sort by the number of times.

 

[Kwibus]

Oh feck.

I thought I had finished my list 3 weeks ago. Just didn't submit it, because I wanted to wait for hald December atleast. Now that I thought about it again I figured I submit it..

I open my list and see that my total points is 7468..
*loading cqranking.com again*

 

[Ferminal]

I open my list and see that my total points is 7468..
*loading cqranking.com again*

Meh, I think most teams will be a fair way short. You look through your list and it's hard to find ones better for the extra 20-30 points.

 

[Tuarts]

Not an expert - but I can work a spreadsheet ok.

The only ways I can think of doing that involves a little bit of stuffing around. I can explain a little, but if it doesnt work easily, once I have sent in my team I am hppy if you want to email me your spreadsheet and I will do it for you.

To do yourself
- create new worksheet on front
- if your sheet names are just "sheet 1' "sheet 2" etc, then leave them as that.
- on your summary sheet, list in column B all riders on cq
- assuming you then have seperate sheets with everyones teams, with the names in cells A1:A33 ... your formula will be
=SUMPRODUCT(COUNTIF(INDIRECT("'Sheet"&ROW(INDIRECT("1:30"))&"'!A1:A33"),b1)) Where 1:30 is assuming you have 30 teams with the worksheets named Sheet1 Sheet2 ... to Sheet30.
- If you copy this formula down the list of riders, it will count the number of times each rider has been used. You can then sort (using autofilters is easiest) to see the highest numbers etc.
- when new teams are added, just change the sheet range (and copy down the column to all riders) to include new teams in the count

- If the worksheets are named the team names (or any other name), you will need to list the sheet names in a column in your summary sheet in column A, and name the range Tabnames, then your formula would be
=SUMPRODUCT(COUNTIF(INDIRECT("'"&TabNames&"'!A1:A33"),b1))


other than that - Countif would work, but would involve you nesting a countif for each sheet/team (still create summary sheet with each riders name in column b (assuming you named sheets by username)
eg =COUNTIF(AussieGoddess!$A$1:$A$32,Summary!A6)+COUNTIF(Boomcie!$A$1:$A$31,Summary!A6)+COUNTIF(TimmyLovesRabo!$A$1:$A$35,Summary!A6) (assumes 3 teams and summary sheet, with rider names in column a)

It is simpler for you to use, but take longer to set up. If you do this, make sure you use absolute cell references for the range so that you can copy down the formula to all riders ....and then again just sort by the number of times.

You lost me at hello...

(I'm glad I'm not Hugo ;D)

 

[Kwibus]

Meh, I think most teams will be a fair way short. You look through your list and it's hard to find ones better for the extra 20-30 points.

Indeed. I looked for a while and in the end I replaced a rider I had a lot of doubts about with another riders I have even more doubts about, but could potentially bring in a lot more points.. I think.
Ended up with 7490 points.
I'm far from confident about my team. Last year I had quite a few riders of which I was sure they would bring in lots of points.
Somehow I don't think I will repeat a top10 position next year.

You never know though!

 

[Kwibus]

You lost me at hello...

(I'm glad I'm not Hugo ;D)

He never said hello

 

[Hugo Koblet]

I managed to somehow count the riders. I have no idea how though

A total of 317 different riders have been picked, including 149 who have just been picked once. That's a lot I think.

 

[greenedge]

That is 168 riders who have been picked more than once. Good job on using that excel thing to calculate.

I have compiled a 6pg list of riders ( size 12 font ) and am now starting to narrow them down.

 

[skidmark]

I think I've got my team; I've got one really expensive guy and one guy I want to switch up (maybe)... so my choices are to hedge my bets and get 2 sort of expensive guys (replacing the expensive guy and the guy I am not sure of), or replace the guy I'm not sure of straight up... only thing is that I'm already 40 points under and if I replace him with someone else, I'll be almost 100 points under, which makes me think I should spend more... but I've grown kind of attached to the other guys...

I guess at the end of the day, the best team is the best team, regardless of whether you're right at 7500. But still. I'm gonna sit on it for a week or so, wait to see if 2 guys I'm interested in find a team, wait to see about some parcours and invites to races...

Hey Hugo, you ever thought of doing an email address for this? Or could you ask the mods to give you more inbox space? Or designate a 'secondary' who's already entered that people can send their teams to if your inbox is full? I just don't see how I can send it in before a few days to go, I'm just a worrier like that, and I imagine others might be too. It'll probably work out anyway, unless we have like 200 entrants, can't imagine you getting more than 50 in a few hours.

Can't wait to turn my pre-season anxiety to during-season obsessive checking of race results.

 

[Ferminal]

I managed to somehow count the riders. I have no idea how though

A total of 317 different riders have been picked, including 149 who have just been picked once. That's a lot I think.

You got the same stats from this year? Will be interesting to see if it's different when 30 of us aren't stitched up.

 

[Eric8-A]

I was able to pick up some minor points from Kiel Reijnen because of the Tour of Rwanda

 

[Timmy-loves-Rabo]

I'm curious to how many exceed 1000.

My most expensive is like 700.

 

[The Hitch]

The problem with Menchov is that I would see it as a great success if he repeated his 2010 season. Podium at a small race podium at a big race and podium at the biggest race.

Pretty good for Menchov. Yet he only got 800 points.

I'm curious to how many exceed 1000.

My most expensive is like 700.

Couldn't resist Poels

 

[Timmy-loves-Rabo]

Indeed, I originally had Boom but I made some changes to accomodate for poels. I have feeling he is gonna have a big year.

 

[The Hitch]

Indeed, I originally had Boom but I made some changes to accomodate for poels. I have feeling he is gonna have a big year.

I do remember you tipped him on that day he came 2nd to Purito in Valdepenas Jaen, even though he was an unfavoured pick, and from then on he seemed to show some epic stuff at the Vuelta, so it makes sense for you to continue backing him.

 

[Eric8-A]

I was gonna choose Boom for this year but instead chose George Hincapie

 

[Timmy-loves-Rabo]

I do remember you tipped him on that day he came 2nd to Purito in Valdepenas Jaen, even though he was an unfavoured pick, and from then on he seemed to show some epic stuff at the Vuelta, so it makes sense for you to continue backing him.

that was a poels type finish. I still think he could do very well in fw or the ardennes in general.
I'm a big fan of his. I tipped him for most of the year, I think he'll be the best dutch rider next year. But we'll see. He isn't cheap so it aint risk free

 

[Kwibus]

Indeed, I originally had Boom but I made some changes to accomodate for poels. I have feeling he is gonna have a big year.

Poels is a tough call though. Last year he made a great breakthrough which started in Tirreno were Gilbert beat him with 1cm at an hilltop finish and he continued to impress in the mountains/hills. Allthough he wasn't very consistant.
Normally he will be doing better this year, but somehow I'm not 100% sure about it. He could very well have an anonymous year. Let's hope not!

 

[Kwibus]

that was a poels type finish. I still think he could do very well in fw or the ardennes in general.
I'm a big fan of his. I tipped him for most of the year, I think he'll be the best dutch rider next year. But we'll see. He isn't cheap so it aint risk free

I'm also a great fan of him, but I really hope he changes his mindset towards GC's. He wants to ride a good GC, while imo he's just like Daniel Martin.
Not the most consistant rider, but a great mountain/hilly stage hunter with a nice punch. Also great contenders for 1 day races.

 

[Ruudz0r]

I think Poels will develop further this year to bad he wants to do the TDF as a grand tour though. Think AGR and LBL will still be 1 year to early for him this year but I expect a good showing in FW. Further he will probably have a good showing in TA, some french races and the Italian races in August/Sept/Oct especially Emilia.

 

[Hugo Koblet]

Hey Hugo, you ever thought of doing an email address for this? Or could you ask the mods to give you more inbox space? Or designate a 'secondary' who's already entered that people can send their teams to if your inbox is full? I just don't see how I can send it in before a few days to go, I'm just a worrier like that, and I imagine others might be too. It'll probably work out anyway, unless we have like 200 entrants, can't imagine you getting more than 50 in a few hours.

Actually I don't think it will be a problem. I would have to receive 50 PM's overnight, which probably won't happen.
Anyway, if someone sends me a PM and my inbox is full, you can send your team to stnlaugust@gmail.com, but I prefer receiving the teams here, so please only use the mail address if my inbox is full

 

[Tuarts]

He never said hello

She. It was just a joke/pun *******ising a famous phrase.