Warrior General Games

A Gold Ladder Ranking using the ELO System.

Spreadsheet problem will fix after tonights game

How does that work?

Originally posted by PING72
How does that work?

not following either

Looks like a week-by-week ELO system. It's used in things like chess and competitive gaming; it rewards more points for beating a team that has higher points in relation to you. So it basically incorporates W-L combined with strength of schedule, though not perfectly (teams that play the CPUs early will get more points than those that play them late, for example.) Strength of victory is also not a factor.

Click the week tabs on the bottom and you'll see the points scored/lost each week.

I don't follow the math either, but very cool Mike!

Originally posted by awsalick
Click the week tabs on the bottom and you'll see the points scored/lost each week.

Thanks, I missed those...makes it a lot more clear.

Originally posted by awsalick
Looks like a week-by-week ELO system. It's used in things like chess and competitive gaming; it rewards more points for beating a team that has higher points in relation to you. So it basically incorporates W-L combined with strength of schedule, though not perfectly (teams that play the CPUs early will get more points than those that play them late, for example.) Strength of victory is also not a factor.

Click the week tabs on the bottom and you'll see the points scored/lost each week.

This ^^..

Now to start the ladder all teams begin with 1000 pts. Theoretically this ladder can continue on and on for season after season. Any new teams to enter Gold every season still begin with 1000 pts and the process continues. This would solve the question of "WHO is the Best of All Time".

Is anyone amazing in excel formula/ micro writing lets work on this to make it much easier than harvesting and processing the data the long way.

I like it.....run it again Mike...how do you do that

I've got excel formulas down, how does it work and I'll take a look at it...

Week 5 Posted

Originally posted by DirtyMike
Originally posted by awsalick

Looks like a week-by-week ELO system. It's used in things like chess and competitive gaming; it rewards more points for beating a team that has higher points in relation to you. So it basically incorporates W-L combined with strength of schedule, though not perfectly (teams that play the CPUs early will get more points than those that play them late, for example.) Strength of victory is also not a factor.

Click the week tabs on the bottom and you'll see the points scored/lost each week.

This ^^..

Now to start the ladder all teams begin with 1000 pts. Theoretically this ladder can continue on and on for season after season. Any new teams to enter Gold every season still begin with 1000 pts and the process continues. This would solve the question of "WHO is the Best of All Time".

Is anyone amazing in excel formula/ micro writing lets work on this to make it much easier than harvesting and processing the data the long way.

Im not bad with excel although im not sure exactly what you want but im familar with the formula writing process... if you want to foward me the spreadsheet and let me know what you want done to it i can give it a whirl.

think there is an error there

SHY Town beat Atlantic City Surf in week 2.

we lost 60 points, they gained 60 points.


Shy Town are 4-1 , yet only have gained 50 points from the 4-1 record.

Originally posted by 68guns
think there is an error there

SHY Town beat Atlantic City Surf in week 2.

we lost 60 points, they gained 60 points.


Shy Town are 4-1 , yet only have gained 50 points from the 4-1 record.

Corrections made and carried forward.