Compiling Rider Scores

by drheaton   May 28, 2012  

Hello,

I'm looking for some help. I want to compile rider scores for the Giro only (I know I can check total scores per rider). I've copied and pasted each set of scores from the stages page into tabs of an excel workbook but can't think of an easy way to compile these onto one worksheet in a:

Name | Team | Stage 1 Score | Stage 2 Score | etc etc | Total

kind of format so I can see who scored how much and when.

I know it's geeky, but I want to try and work out over the three weeks which would have been the best picks when and, for my purist team, who averages more points, sprinters, climbers or breakaways over the three weeks.

Any suggestions?

17 user comments

Oldest firstNewest firstBest rated

You know its really sunny outside right? Wink

chrisdstripes's picture

posted by chrisdstripes [1648 posts]
28th May 2012 - 11:57

0 Likes

Yes, but I'm stuck at my desk at work Sad

I need something to keep me occupied for the rest of day... unless my boss reads this in which case I work really really hard and deserve a raise.

posted by drheaton [3429 posts]
28th May 2012 - 12:01

1 Like

Just as you've laid it out

Name | Team | Stage 1 Score | Stage 2 Score | etc etc | Total

So Name in column A, Team in B, then stages from C-whatever

Then for the total just do a formula which adds all stages together?

Gkam84's picture

posted by Gkam84 [9038 posts]
28th May 2012 - 12:07

0 Likes

Problem is I've only got the riders from each stage page and they're in separate tabs.

So under the stage 1 tab I have

Name | Team | Score

just for the riders scoring on stage 1.

Need to find a way for excel to lookup scores against the members name (which is the id) across 21 different tabs.

I could copy and paste a full list of riders into one tab to start it off I guess but at the minute only the riders who were active at the end of the race are on the riders page, so people like Guardini/Pozzatto are not on there.

posted by drheaton [3429 posts]
28th May 2012 - 12:11

1 Like

So are you working on Giro points or fantasy points?

If its the fantasy, i have a bit of time on my hands, so could sort out riders and stage points for you?

For instane

Name
Taylor Phinney

Team
BMC

Stage 1 45
Stage 2 18
Stage 3 26

Then in Excel it would look like

Phinney - BMC - 45 - 18- 26 Total =

So you could just make a list of riders and then add the scores in manually for each day?

Gkam84's picture

posted by Gkam84 [9038 posts]
28th May 2012 - 12:42

1 Like

Look up the 'indirect' worksheet function in help.

phy2sll's picture

posted by phy2sll [26 posts]
28th May 2012 - 13:06

5 Likes

or you could just ask, and i'll lob an extra column on the riders page Big Grin

Dave Atkinson's picture

posted by Dave Atkinson [7501 posts]
28th May 2012 - 13:19

1 Like

*sigh* I guess you could do that Dave but what will I do for the rest of the afternoon now? Crying

That'd be great if you could Dave, although I think the riders page at the minute only shows active riders so those who dropped out are missing.

EDIT: I was looking at a few other things as well, like how quick the points drop off was for the TT guys from stage 1 through to 3/4/5 and what type of DS was the best value, sprinters/climbers/breakaway. It's all for the purist side really as the normal game is more fluid but for purists playing the averages would probably work well.

posted by drheaton [3429 posts]
28th May 2012 - 13:46

0 Likes

yeah, not much i can do about the riders who didn't make it to the end. but then, you wouldn't want to pick them anyway Smile

perhaps you could dedicate your afternoon to just the abandons? Big Grin

Dave Atkinson's picture

posted by Dave Atkinson [7501 posts]
28th May 2012 - 13:46

1 Like

(i already added the score column btw)

Dave Atkinson's picture

posted by Dave Atkinson [7501 posts]
28th May 2012 - 13:47

1 Like

You might have wanted to pick them, Guardini for instance would have been pretty good value as a purist for his points Thinking

And thank you Smile

posted by drheaton [3429 posts]
28th May 2012 - 13:51

0 Likes

For everyone's information, the best possible purist team in budget was:

Rodriguez
Hesjedal
Basso
Henao
Pozzovivo
Tiralongo
Golas
Rubiano
Amador

coming in at an impressive 2039 points, basically, if you're a purist, stack up on climbers and breakaway people. Cav was the best sprinter but took the team overbudget and was only 70 or so points better than Basso, Kristoff was the best DS sprinter coming in around 80 points below the best climber DS (Pozzovivo).

posted by drheaton [3429 posts]
28th May 2012 - 14:11

0 Likes

dave_atkinson wrote:
... i already added the score column btw...

How do I get to see what you posted? Is it the graph you get called 'Scores by Stage' when you click on a Rider name?...

Vive Le Road.cc Fantasy Cycling Game!

posted by enrique [1795 posts]
29th May 2012 - 13:39

1 Like

http://fantasy.road.cc/riders

It's the last column, you'll have to go to the Giro comp as the Dauphine doesn't have any points yet but it's the same place, just click on the Riders tab at the top of the fantasy page.

posted by drheaton [3429 posts]
29th May 2012 - 13:45

0 Likes

Dave, what happened to the scores on the http://fantasy.road.cc/riders page? Your wonderful fix doesn't seem to work anymore for any race other than the TdS and CdD?

posted by drheaton [3429 posts]
22nd June 2012 - 12:09

1 Like

oooops.

all riders who scored should now be in the historical lists

Dave Atkinson's picture

posted by Dave Atkinson [7501 posts]
22nd June 2012 - 12:53

1 Like

Thank you!

posted by drheaton [3429 posts]
22nd June 2012 - 13:03

1 Like