New Skill System - complete results - How good are you?

Hello all,

after the long discussion and a lot of changings I proudly present the release candidate for the new Skill System!
Its in the OO Calc SpreadSheet (see macro)

I will post the current top 10 along with the complete table unregularly. you can find a lot of game and player statistics too (including charts). Just check out the file.
OK here is the top10 ranking for SkillShown up to Jun4th 2010 at 14:07

Pos...[SkillShown]..Name
01.....[89]..donclaude
02.....[85]..janosik
03.....[76]..alevezzo86
04.....[74]..Bloodmaster
05.....[71]..Gordon
06.....[71]..rexis
07.....[65]..Leahcim
08.....[65]..janosikj
09.....[65]..JStaxton
10.....[58]..MOens

Nice Job everyone! Keep it up!


Greetings
JStaxton

Hello all,

it has been a while since an update. So here it is.
Unfortunately there was a data loss! All game data between Jun4th and Jun10th, I really am sry for that!

But nevertheless the good thing is, that the rankings provided by the NewSkillSystem are relative, so it is possible that your rank didnt change by dataloss or inactivity.

In addition to the current top10 ranking I want to give some stats as well:
[b]TotalGames = 749[/b] (games in NewSkillSystems database)
[b]AveragePlayersPerGame = 2.92[/b]
[b]TotalScoreSum = 126384.52[/b] (Total Score of all players)
[b]TotalDeltaAbsSum = 2199.82[/b] (This is the Skill value that was transferred between players while ranking with the NewSkillSystem algorithm)


[b]Pos...[SkillShown]..Name[/b]
01.....[99]..donclaude
02.....[85]..janosik
03.....[76]..alevezzo86
04.....[75]..Bloodmaster
05.....[72]..Gordon
06.....[71]..rexis
07.....[71]..Chuck
08.....[68]..JStaxton
09.....[65]..Leahcim
10.....[65]..janosikj

Donclaude is pushig it to the magic limit of 100! Is there anyone to stop him?
Well done Chuck as well, and welcome back in the top10!


Have fun everyone
JStaxton

Nice thing this skill system!
But with 99 from 100 points it isnt really possible to get more points
STRIKE! :-o

Hello donclaude & others

it is possible to get more then 100skill !! (Note: its [b]no[/b] percentage value or sth.)

Remember: Its all relative. If donclaude has 100skill, this means he is twice "as good as" a player with a skill of 50. There is no theoretical limit for the skill value, but it gets harder to higher you get to keep it.

greetings
JStaxton

Hello everyone!,

Long time no see but I followed the action! Here is the new update for the life time NewSkillSystem ranking!

In addition to the current top20 ranking I want to give some stats as well:
[b]TotalGames = 881[/b] (games in NewSkillSystems database)
[b]AveragePlayersPerGame = 2.76[/b]
[b]TotalScoreSum = 142877.88[/b] (Total Score of all players)
[b]TotalDeltaAbsSum = 2344.53[/b] (This is the Skill value change for all players while ranking with the NewSkillSystem algorithm)
[b]TotalPlayers = 224[/b]
[b]AverageGameCount = 10.85[/b] (how many games a player played so far)
[b]AverageSkill = 50[/b]
[b]AverageSkillShown = 23.69[/b] (showing that many players only played 1 or 2 games so far, resulting in a low SkillShown value)


Remember: The SkillShown value is relative! a value of "100" means you are twice as good as a player with "50". There is no maximum skill. Try to break the 100 and we will introduce an official record.

[b]Pos...[SkillShown]..Name[/b]
01.....[96]..donclaude
02.....[85]..janosik
03.....[76]..alevezzo86
04.....[75]..Bloodmaster
05.....[72]..Gordon
06.....[71]..rexis
07.....[68]..JStaxton
08.....[65]..MOens
08.....[65]..Leahcim
08.....[65]..janosikj
08.....[65]..Chuck
12.....[64]..jossssKuratko
12.....[64]..Muhator
14.....[61]..Ploki
15.....[60]..Imbaa
16.....[56]..dwarf
17.....[55]..Merrels
18.....[54]..UA TRANS
18.....[54]..lakefisher
20.....[52]..Voider

Donclaude could not hold the fantastic 99! He dropped to only 96 :) Maybe he is not that unreachable after all? Will be exciting to see if there is anyone to challenge him.
For the sake of unaccuracy in the math of the algorithm I rounded the skill values and put the players with identical values on the same rank.


Have fun everyone
JStaxton

ps.: Feel free to give me some comments about the algorithm, the ranking or the NewSkillSystem in general!

Hi there Ottd addicts,

slowly but sure the heat is up! I hear some rumour that the NewSkillSystem is nearing website integration. Until we celebrate that step, here is the updated NewSkillSystem Ranking sheet.

I added new cool diagrams, check them out.
And I added new "jobs" for everyone. Depending on how much skill and score you have, you are assigned a job title. Take a look at the ranking.

Here's current top20 ranking and the server stats:
[b]Server_TotalGameCount= 916 [/b](games in NewSkillSystems database)
[b]Server_AverageGamePlayerCount= 2.76[/b]
[b]Server_TotalGameScoreSum= 150423[/b] (Total Score of all players)
[b]Server_TotalGameSkillDeltaAbsSum= 2425[/b] (+80 from last time! wow, lets see who has them)
[b]Server_TotalPlayerCount= 237[/b](showing that we have lots of new players this month! yeah)
[b]Server_AveragePlayerGameCount= 10.65 [/b](how many games a player played so far)
[b]Server_AveragePlayerSkill= 50[/b]
[b]Server_AveragePlayerSkillShown= 22.98 [/b]

Remember: The SkillShown value is relative! a value of "100" means you are twice as good as a player with "50". There is no maximum skill.

!!!BREAKING NEWS!!!
"donclaude" breaks the 100skill barrier! Either his opponents got worse or he even got better! WOW! Keep it up!
There have been lots of changes in the ranking behind the first places. Newcomers are pushing hard to get to the top.

[b]Pos...[SkillShown]..Name...(job)[/b]
01.....[103]..donclaude...(virtuosic middle manager) (record 2010Aug27th - 103)
02.....[85]..janosik...(successful junior manager)
03.....[76]..alevezzo86...(efficient middle manager)
04.....[75]..Bloodmaster...(efficient junior manager)
05.....[72]..Gordon...(efficient junior manager)
06.....[71]..rexis...(efficient senior manager)
07.....[70]..JStaxton...(efficient junior manager)
08.....[65]..Leahcim...(talented senior manager)
08.....[65]..janosikj...(talented specialist)
08.....[65]..MOens...(talented junior manager)
11.....[64]..Muhator...(talented specialist)
11.....[64]..jossssKuratko...(talented junior manager)
13.....[63]..Chuck...(talented CEO)
14.....[62]..Ploki...(talented junior manager)
15.....[60]..Imbaa...(solid junior manager)
16.....[59]..Merrels...(solid junior manager)
17.....[56]..dwarf...(solid specialist)
18.....[55]..UA TRANS...(solid senior manager)
18.....[54]..lakefisher...(solid specialist)
20.....[52]..Voider...(solid foreman)


Have fun everyone
JStaxton

ps.: Give me your feedback!

Hi again, everyone!

I had an afterthought on the last post I made here...
So NewSkillSystem is nearing perfection and the traditional score no longer needs to represent goal accomplishments AND the skill a player has. So I changed the definition of the score to the following simple formula:

[b]Score = Goal_Accomplishment * 100[/b]
(no matter how long it did take you!)

Along with that change I updated the system with the latest game results, of course. There were some "job" changes due to the change of the definition, just check out if you climbed the carreer ladder one step or two.

My next post will be a seperate one with an explanation of the NewSkillSystem (How do I get my skill?) As many players have asked for that.


PLUS: I added new diagrams again!! hourly statistic, monthly statistic, more player stats and reworked existing one to be clearer and esier to understand!
Have fun browsing the sheets
JStaxton

Hello all,

its been a while! I kept being busy at work, but followed the action as much as I could.
Guess what: I updated the "all-time" skill ranking table.

Here is the NewSkillSystem spreadsheet up to Dec 1st:
Please keep in mind, that the Score definition has changed (see last post)

Special note: Our player "Chuck" officially is a "openttd"-aholic. He played over 700 games so far and is way ahead in terms of score. But what is his true skill? He managed to climb up to the all-time 6th place! Well done Chuck!
Check out your skill in the posted spreadsheet.


Have fun everyone!
JStaxton

Hello again,

after Ed fixed that annoying "game did not count" bug things are speeding up... We even got more games in less time into the NewSkillSystem.
I reprogrammed the whole system in a way that its much faster now (ca. 100 times faster skill calculation).
Also the "Calc History" function is very fast now. Try checking out the history of "Chuck" (over 700 games) and look at the sweet diagrams.


Now when I look onto the stats there is one player that I have to mention: its "martinho9000" he climbed into the Top10! Good Job!
OK then here it is: the latest NewSkillSystem spreadsheet until 12:27PM the 16th of December 2010!

Have fun all!

Any chance of getting this as an XLS file?

Sure,

But I had to delete all tabs but the games and players tab! Its just too big as xls file...
Macros wont work.
Besides that the listing will be complete :)

Why dont you try OpenOffice?
Or LibreOffice?

Greetings
JStaxton

Hi Jstaxton and Ed,

Thanks for all the work you're putting into this!

I am looking for a way to figure out how the decimal number in the skill column on the leaderboard is produced.

Can someone point me in the right direction?

Hello Rubinho,

right now the NewSkillSystem integration into the leaderboard is not properly functioning! Its in beta testing phase!
If you want the complete results and your skill, please download the spreadsheet I'm providing in this thread.

There you 'll find your skill along with lots of other cool info.
Pls be patient with the new leaderboard.


Greetings JStaxton

OK guys,

As predicted the game density is high. I guess due to the fixed bug and the more spare time of our players.
Good for the NewSkillSystem!

Now here is the latest ranking!
ATTENTION:
I changed the SkillShown definition: In order to take the inactivity of a player into account the SkillShown calculation is now based on inactivity time of a player in addition to the number of games he played so far. This way the SkillShown value slowly drops, if a player is very long inactive! If a player comes back after all, then all the negative effect due to inactivity will be lifted and he gets his last known Skill back!

The limits for inactivity are:
After 30 days of inactivity the SkillShown starts to drop (are therefore the players rank!)
After additional 150 days the Player is called "retired". He has no SkillShown any more!!
So after about half a year the players SkillShown value and therefore his ranking is lost!

So here it is...


Have fun and give me your feedback!
JStaxton

and before anyone asks,

here is the Excel file!
I deleted all data except the players tab (ranking and players charts)

JStaxton