GT4 WRS Weekly Leaderboard

[KLR142]

Darnit. Rob there to steal it away from me again. Oh well, judging by his splits and races of late, he's going to D1 soon...

 

[Tedehur]

Week 51 is in the box.

 

[Tedehur]

Lazy me.
Weeks 52 and 53 are updated too.
Week 54 will come later.

 

[Super T]

Yippee, I'm on the Div 2 leaderboard , (second last ).

I have no idea what it all means at the moment so I'll save the celebrations till I've checked out the thread explaining it all. Still, at least it feels a bit more official now. All I need now is my max drive to arrive and I can start putting in those really quick times.

 

[Tedehur]

The longer I wait, the less motivation I have to keep on updating this leaderboard. I've been doing it for almost 2 years now, and it has almost become a chore now.
Plus, I don't want to be the "almighty steward", posting the races and making the statistics.
I like to see the WRS as a common project, and if anyone has ideas and is willing to start some stats of his own, please step forward.
Steven, I'll try and catch up with the board later this week anyway.

 

[steven]

cyril, i love you.
tho i'd hate to be in your position.
let's try to find a way in which wrs is less dependent on your efforts.
anyhow.
cheers.

 

[Tyre King]

Damn!

I have to start remembering to submit!

Slipping down the leaderboard!

Neil

 

[shockwaveracing]

never mind i should read before i post...

 

[MisterWeary]

I have a board I have been keeping, it's slightly different but keeps me intrigueed with the whole "scoring" thing. It's a week or two out of date right now thanks to this almighty excursion-a-thon and it's also tailored fro me but I can adjust something like it if people are interested.

 

[MisterWeary]

Further to my previous post here is what my leaderboard would look like. It's updated completely at the moment and I've just resorted and recoloured the first worksheet in the above attached spreadsheet.

​

Some explanations are probably in order, basically the percentages you see in each row is a percentage indicating where you placed in that week. So if there were 23 competitors and you placed first, your percentage would be:

1 - (1/23) = 95.65%

If you placed 8th in that same week your percentage would be:

1 - (8/23) or 65.22%

My system ensures you could race once and get an indicator of where you'd place. I personally use it to get an idea of where I place in relation to the whole field not just my division.

I'm going to continue updating it every week for my own purposes anyway so if people would like me to post it here I'm happy to do that also.

 

[steven]

hi colby,
this must be lots of work. to be honest i think cyril's leaderboard is much more clear in that you know where you're at in comparison to the rest of your division and looking back at the past.
funny 'cos cyril also said that much fun in gtp is in admin-ing stuff rather than testing or racing.
never mind, you're also doing enough as it is with luxy's and all.
you might be a strong contender for taking over flatty's work when he resigns.
cheers, steven

 

[MisterWeary]

The longer I wait, the less motivation I have to keep on updating this leaderboard. I've been doing it for almost 2 years now, and it has almost become a chore now.
Plus, I don't want to be the "almighty steward", posting the races and making the statistics.
I like to see the WRS as a common project, and if anyone has ideas and is willing to start some stats of his own, please step forward.
Steven, I'll try and catch up with the board later this week anyway.

Maybe I'm flogging a dead horse here but I have refined and streamlined my WRS Results and Leaderboard method. So below you will find a detailed explanation of my results sheet. The sheet itself can be downloaded from here and you can see for yourself how it works if you like. (Note: It is a zipped Excel Spreadsheet and the spreadsheet contains macros that will NOT harm your computer)

Weeks 1 - 8 Results
Like Cyril's leaderboard, mine calculates a result based on 8 weeks of information. Here is a screen shot of one of the past 8 weeks results:

​

It is sorted by final time regardless of division and then the percentage in the final column reflects how you placed overall (see post 430 above for details on how this works).

Division 1 - 3 Rankings
This section is quite clear if you understand how the previous sheets function, here are screen shots of each division:

​

These are current up to Week 64. You can see it simply gets the average percentage for each week you raced and then I've ranked drivers according to that average.

The beauty of this system is that someone can race once and see exactly where they place in the WRS. It is also very simple to update. I simply transfer all results back one week (via a Macro) then I copy the current week's results in and then I update the results (via another Macro). It would take less then 5 minutes to completely update the results.

I know this system is not as comprehensive as Cyril's but it's simple, it works and it's the only alternative proposed since Cyril put the S.O.S out nearly a month ago so it gets my vote

 

[Laurence5905]

Maybe I'm flogging a dead horse here but I have refined and streamlined my WRS Results and Leaderboard method. So below you will find a detailed explanation of my results sheet. The sheet itself can be downloaded from here and you can see for yourself how it works if you like. (Note: It is a zipped Excel Spreadsheet and the spreadsheet contains macros that will NOT harm your computer)

Weeks 1 - 8 Results
Like Cyril's leaderboard, mine calculates a result based on 8 weeks of information. Here is a screen shot of one of the past 8 weeks results:

​

It is sorted by final time regardless of division and then the percentage in the final column reflects how you placed overall (see post 430 above for details on how this works).

Division 1 - 3 Rankings
This section is quite clear if you understand how the previous sheets function, here are screen shots of each division:

​

These are current up to Week 64. You can see it simply gets the average percentage for each week you raced and then I've ranked drivers according to that average.

The beauty of this system is that someone can race once and see exactly where they place in the WRS. It is also very simple to update. I simply transfer all results back one week (via a Macro) then I copy the current week's results in and then I update the results (via another Macro). It would take less then 5 minutes to completely update the results.

I know this system is not as comprehensive as Cyril's but it's simple, it works and it's the only alternative proposed since Cyril put the S.O.S out nearly a month ago so it gets my vote

Not to demean the work you've done -- looks like you've put QUITE a bit of time into it -- but the one thing this doesn't seem to take into account is the number of times someone has raced. They ought to get a 0.00% averaged into their score if they don't submit for a particular week -- if this is to be an all-inclusive overall standing in the WRS.

Specifically, look at CoolGeekz in the Division 2 spreadsheet. He's submitted once in the last 8 weeks, yet is in 2nd place overall! Doesn't seem fair to me -- I've submitted 6 times in the last 8 weeks, and although I didn't place as high in any of my submissions as he did in his one submission, he ought not to be in the top-3 of the leaderboard, because he didn't bother to show up... Sausages, on the other hand, has submitted EVERY week for the last 8, and therefore has shown the "dedication" if you will to lead the Division 2 leaderboard. He shouldn't be in 3rd place, he should be in 1st place.

So turning the non-submission weeks into zeroes would make his average 10.125% (near the bottom) which is where anyone should be if they're not submitting on a regular basis. (Kind of like the points system in NASCAR -- if you don't race, you don't get points added to your total, and you fall behind the other drivers who did race.)

Of course, since I'm missing two weeks in that chart, that would lower my average to 20.21% instead of 26.95%, but it would be a more accurate representation of my overall performance over the 8 weeks, since I missed two of those weeks.

Just something to think about. My system is pretty much an exact copy of yours, but takes into account the "dedication factor" of those who submit more consistently, and penalizes those who don't -- just my opinion, of course, but I think most folks would agree that's the way it should be.

 

[KLR142]

Yeah, and I'm in 7th. Come on Colby, you know I'm better than that! :-P

Lol, just giving you a hard time. It's definitely something a bit different, but I do agree with Laurence here, I also think that it needs to account somehow for how often you race. You can still see how the person ranked because you can just look at their percentage for that one week that they raced, but I think you should add up all the percentages for each person for that 8 week session, disregard two no shows or the two lowest percentage races(I like that feature), and then divide by six to get their average percentage and rank them that way. Wow, quite the run on sentence. If you don't understand what I'm saying, I don't blame you, still not recovered from last night quite yet...

 

[Tedehur]

I'm busy processing the huge replay checking work done by Colby and Kyle while I was away. I've done 2 weeks only (63 and 62), and both still have missing replays.
That doesn't motivate me to resume the leaderboard.
PMing people so that they post late replays, then correct replays when the first one was not the expected one takes time.
Correcting my spreadsheet to do the ranking again for the thread and correcting the leaderboard database takes an even greater amount of time.

BTW, I agree with Laurence's remark. Working out fair statistics is pretty hard, mainly because nobody is compelled to race week after week.
So indeed, someone racing only once and winning the race gets a terrific score.
That's why my calculation counted six results out of the last 8. People were allowed not to race, but not much.

Allow me to think about it a little bit more, and within 10 days I'll take a decision whether the leaderboard as it exists since August 2004 will survive or not.

 

[Dr_Watson]

why not just turn your current leaderboard over to someone else?
It looks clean, and its what everyone is used to.

you know, why reinvent the wheel when you can just pass the torch?

 

[MisterWeary]

Well, this is just my opinion...CoolGeekz may have raced once in the last 8 weeks but he proved in that race that he was faster than most. The one thing I don't like about Cyril's system (which it appears most people like) is that it rewards consistency. Moving up the rankings through consistency is like an encouragement award in my opinion. Andrew, Brad and myself would probably be the only ones battling for the top of Div 1 if it came down to consistency. Seeing myself placed above holl01 is just ridiculous, I could never beat him...ever?!?

I have kept my own results for quite some time now (since week 30) and my results help me get a good feel for my real position in the division. I started with averages around the 55% mark and I've slowly progressed to the 70% mark.

I'm happy to go with whatever people want, I could alter my current system to reward consistency if that's what people want or as Doc suggested, someone could take over Cyril's system.

 

[KLR142]

Well, if I tried I could've beat Coolgeeks... So, it sometimes(or almost always) comes down to how much time you spend on it. Also, just looking at one race may be confusing because it could be that person's strength(thus why they're racing it), and they might suck a bit more elsewhere.

 

[MisterWeary]

...just looking at one race may be confusing because it could be that person's strength(thus why they're racing it), and they might suck a bit more elsewhere.

That's a good point. Like I said, I'm happy to adjust my system or go with whatever but I feel some of the strain should be taken off Cyril.

 

[steven]

so here is my advice to cyril how to solve the lagging admin problems.

- for the past: assume (for this once) all submitted times are clean
- for the present: crunch the numbers to actualise the leaderboard
- for the future:
a = cyril adapts the submission system i suggested to him earlier (all replay checking is done by peers not him), and
b = colby continues updating his own 'percentage' system and publishes it alongside cyril's leaderboard

this way everybody can be happy. there will be both a system that does and that does not reward consistency. cyril's workload is diminished and we have our statistics.

 

[Casio]

Well, this is just my opinion...CoolGeekz may have raced once in the last 8 weeks but he proved in that race that he was faster than most. The one thing I don't like about Cyril's system (which it appears most people like) is that it rewards consistency. Moving up the rankings through consistency is like an encouragement award in my opinion. Andrew, Brad and myself would probably be the only ones battling for the top of Div 1 if it came down to consistency. Seeing myself placed above holl01 is just ridiculous, I could never beat him...ever?!?

Cyril's system rewards consistency. But that's good I think, because it gives people a reason to submit. I'm not saying your leaderboard is bad, but for example, I always have a WRS week I don't like, or I just don't have time for, and I just submit any time I can get in 30 minutes. Your system punishes my submission and I would have been better to not have submitted at all.

 

[MisterWeary]

Cyril's system rewards consistency. But that's good I think, because it gives people a reason to submit. I'm not saying your leaderboard is bad, but for example, I always have a WRS week I don't like, or I just don't have time for, and I just submit any time I can get in 30 minutes. Your system punishes my submission and I would have been better to not have submitted at all.

Another good point. Like I said, I'm happy to alter my system to accommodate the masses but an easy-to-update-system is in order I think 👍 I might alter mine to count the 6 best percentages of each racer and see what the results come out like

 

[Tedehur]

Rewarding consistency was the main idea behind my board, as you can see here is the original thread.

 

[steven]

Rewarding consistency was the main idea behind my board, as you can see here is the original thread.

ok now i understand: you don't want people to submit fast times, you just want people to submit, period
no actually i understand. if your goal is to maintain a lively race series, the most important thing is a big enough turnup week after week for many years.
but there is an argument to also admin a 'fastest' overview such as colby's. so let's have them both and everybody will be happy.

 

[MisterWeary]

Rewarding consistency was the main idea behind my board, as you can see here is the original thread.

Firstly...Famine's first post is hilarious in that thread

Secondly, I've updated my system to take the best 6 of 8 results and it looks like it works pretty much the same as yours Cyril except that mine allows for an anomalous week for a driver. So if a div 3 happens to win the whole comp they will be rewarded for that, whereas in your system they could only get the maximum Div 3 points.

What do people think of my new system? Here are screen shots of the updated results:

​

And also a link here to the spreadsheet if you wanna download it. (I forgot to zip it though so it's about 1mb...sorry)

 

[Super T]

What do people think of my new system? Here are screen shots of the updated results:

​

I like this one better. It put's me further in front of Neil.

Great work Colby.

I don't know how long you guys have been in the WRS now but to have the motivation to do things like this off your own backs shows superhuman dedication IMO. *tick* (Damn, need to spread some first.)

Only problem is, I'm going to have to download an Excel viewer now.

 

[Casio]

I really like that new one. Because I'm second

 

[shockwaveracing]

I really like that new one. Because I'm second

still chasing me though...

 

[Laurence5905]

What do people think of my new system? Here are screen shots of the updated results:

​

Definitely much better in my opinion... Rewards consistency, doesn't penalize someone for taking a week off every once in a while, and seems to be pretty accurate at placing both the good and the consistent drivers at the top.

 

[MisterWeary]

Well here's what my results would look like for Week 65:



Like I said, it's real easy to maintain 👍