ESPNSTI
.
Since it seems that not everyone can be there for each race every week, or things like disconnects can happen, I think it makes sense to not count all the races.
For example, don't count the points of the lowest finished race.
I think using a percentage would be better than picking a set number of races to discount.
A percentage isn't affected by how many races there are, and if only a few races have been done, it won't distort the results as much.
I've played around with it a bit, here's what it would look like if 30% of the total number of races (rounded down) don't count. (30% is just a random number I picked):
HTML:
http://espnsti.in2hosting.org/LFS/Stats/LeagueTotals.htm
http://espnsti.in2hosting.org/LFS/Stats/LeagueResults.htm
Excel format (if you change the Discount Percent cell (in green), it will recalculate) :
http://espnsti.in2hosting.org/LFS/Stats/LFS_League_Points.xls
As you can see it hurts me and MXM the most.
Any ideas on what percentage to pick, or other ideas for a system?
For example, don't count the points of the lowest finished race.
I think using a percentage would be better than picking a set number of races to discount.
A percentage isn't affected by how many races there are, and if only a few races have been done, it won't distort the results as much.
I've played around with it a bit, here's what it would look like if 30% of the total number of races (rounded down) don't count. (30% is just a random number I picked):
HTML:
http://espnsti.in2hosting.org/LFS/Stats/LeagueTotals.htm
http://espnsti.in2hosting.org/LFS/Stats/LeagueResults.htm
Excel format (if you change the Discount Percent cell (in green), it will recalculate) :
http://espnsti.in2hosting.org/LFS/Stats/LFS_League_Points.xls
As you can see it hurts me and MXM the most.
Any ideas on what percentage to pick, or other ideas for a system?