GT4 WRS Weekly Leaderboard

  • Thread starter Tedehur
  • 708 comments
  • 51,772 views
as a true consistant but bad wrs participant i like the old hall of fame better than colby's spreadsheets - as said earlier. if more wrs mates feel the old board should be alive i might just volunteer to maintain that one myself.
will there be a vote on this issue?
 
It's not up to us. The old method was an online system Cyril created. But it's a question worth asking...

@Cyril: Is your leaderboard system something another person would be able to continue updating?
 
I think it's great we have racers willing to volunteer their time to the different aspects of WRS 👍 However we seem to be getting ahead of ourselves. The leaderboard is one aspect that still has no resolution, there seems to be an assumption that Cyril's leaderboard will continue which is a bit hasty. So deciding on who will update the leaderboard is a moot point until we have a system.

Until this is determined I will keep providing my leaderboard (which you can download from here)

If people have a keen interest in being in charge of a leaderboard then like Cyril did many moons ago, you should begin creating one yourself in either Excel, Access or any other method you think would be a good way to summarise results. It can work the same way as Cyril's or completely different, it doesn't matter.

The WRS as it stands today is the result of a little initiative by a lot of people. It's evolution is likely to continue being that way. So if you have a real desire to help out then explore some of the ways you might be able to do that. Feel free to discuss them in here or in the Pit Stop thread or wherever else it's appropriate but a little initiative goes a long way 👍
 
to metar: great, if it'd happen we could team up.

to colb: you're perfectly right about being ahead of things. it's just that i thought that if it were the case it will be continued, hands/time would be no issue.

to cyril: if the techno stuff would be a problem, i could just mirror the current standings, update from 70 to now, and continue it as a simple notepad or xl file.
 
My old board is written in PHP and uses a MySQL database.
It is not usable 'as is' since there are a few functions that I didn't develop and still do with PHP Myadmin.
If someone has an ISP who supports PHP + MySQL, I can send him the database and existing scripts.
Or else to make the existing board usable by someone else I would need to write some more PHP scripts.
 
Okay I've been thinking about the leaderboard and there is a problem. Cyril's leaderboard has the results for weeks 1 - 70 and if people like the idea of keeping tallies of all races then all that data needs to be included in our new system.

Now re-doing data entry is for chumps so I have a question for you Cyril...is there any chance of having the info from your mysql database exported into a format we can manipulate? I can read in ".txt", ".xls" or ".mdb" but I don't even know if it's possible to export the data from mysql.
 
I can export from MySQL whatever you need.
Since I know Excel much better than SQL, I'll rather export the database to CSV files and send you an Excel spreadsheet.
 
cyril and colby: if that conversion is done, metar and i would be gladly willing to maintain it on a weekly basis. then we would need to decide

- how to neatly transfer it from excel to gtp every week

- where to publish it
* maybe at the bottom of the weekly results overview

- when to take weekly results into the leaderboard
* right after results become final i guess

- where to put the data so that metar and i could both access it
* shared google spreadsheet for instance

chris could be our coach in the techno stuff we might encounter, but i know metar is quite handy in matters like these.
 
Flat-out
I can export from MySQL whatever you need.
Since I know Excel much better than SQL, I'll rather export the database to CSV files and send you an Excel spreadsheet.
Click to expand...

CSV would be fine...if you could email me that or post it in here that'd be tops 👍
 
Well...like I said, until an alternative is found, I will keep posting my leaderboard: Weeks 71 - 78

​

Even if you don't understand the system, the rank order is the main thing to observe anyway 👍
 
Colby how does your leader board work, how do you get the pecentage for each drive on any given week?
Cheers Mike
 
The percentage is worked out like this:
  • (1 - ((your overall position) / (total number of racers))) * 100
So if you came 12th overall one week when 29 racers submitted times then your percentage would be:
  • (1 - (12/29)) * 100 = 58.62%
When I was mucking around with a system I thought this was the fairest way to see how someone performed.

I then simply take the average of the best 6 of those results over the past 8 weeks 👍
 
MisterWeary
The percentage is worked out like this:
  • (1 - ((your overall position) / (total number of racers))) * 100
So if you came 12th overall one week when 29 racers submitted times then your percentage would be:

When I was mucking around with a system I thought this was the fairest way to see how someone performed.

I then simply take the average of the best 6 of those results over the past 8 weeks 👍
Click to expand...

I tried a similar system myself, but with the change of adding placing-per-division: An average between the total placing and the divisional placing. Like this:
Racer X is in D2, and came 12th out of 29. In his division, it was 4th out of 10. Therefore:
  • (1 - ((12/29)(4/10))/2) * 100 = [Can't do it right now]

I don't really see an advantage of my system over yours, but I'm still thinking of a way to integrate a system that also rewards the number of submission. Steven also thought of an F1-style leaderboard (10-6-4-3-2-1), but this would be even worse, both for slow "always there" guys, AND for the casual racer.
 
colby, could you tell us what the status is of the 'old' leaderboard and whether or not we can maintain that one alongside yours? you discussed this with cyril, chris helped out on the techno stuff and metar and me volunteered to spend some time maintaining it on a weekly basis, if my memory is correct.
thanks!
 
Well in all honesty I don't see the point in spending ages creating a new system when the benefits over what I'm currently doing are small. I've attached the spreadsheet of information and if you or anyone else want to try to create a leaderboard system out of it then by all means go ahead. Like I've mentioned before, if you want a new system then you gotta do something about it :) 👍
 

Attachments

  • OldLeaderboard.zip
    44.9 KB · Views: 20
Because MINICOOPER has only raced twice during weeks 73 - 80 and you raced every week 👍
 
Sweet, I moved up a spot. 👍

Probably on consistency alone...All I've gotta do now is improve my finishing positions. [ego]Get back in your little box it ain't never gonna happen.[/ego].

:D

Darren.
 
You must log in or register to reply here.

Similar threads

Vaxen
  • Sticky
GTP_WRS Week 37: Results (Official)
Replies
10
Views
2K
shoenboggie
shoenboggie
P
ARL Fantasy League
Replies
28
Views
3K
Whitey093
Whitey093
Vaxen
GTP_WRS Week 26: Results (Official)
Replies
8
Views
1K
tmtk
tmtk
Vaxen
GTP_WRS Week 29: Results (Official)
Replies
4
Views
680
tmtk
tmtk
Vaxen
GTP_WRS Week 34: Results (Official)
Replies
4
Views
1K
benjoi84
benjoi84

Latest Posts

Back