I thought this would be the best place to post this, as it would find its way to all the right people.
View attachment 93831
Don't think anyone's ever put anything like this together before. You should all have a copy.
SIHR is the source.
Unknowns are blank. In the case of unknown assists, points still reflect the number of known goals.
Also, if anyone knows how to insert points rankings into each tournament, let me know.
...who's good with spreadsheets? There has to be a way to easily do this as opposed to manually.
Here's what I did: I inserted a new column between C and D. I called cell D1 "1" to represent 1st place in 1920. Then in D2 I entered:
=IF(K2<K1, D1+1, IF(K2>K1, 1, D1))
and then I filled it all the way down. meaning:
- if the player has the same point total as the player above him, give him the same ranking.
- if he has less, give him the next ranking.
- If he has more, then he must be the scoring leader of the next tournament, so call him "1".
...which almost worked. But this results in ties not being accounted for in the players following the ties. For example, you'd want it to spit out:
1, 2, 3, 4, 5, 5, 7, 8, 9, 10, 10, 10, 13...
but it spits out:
1, 2, 3, 4, 5, 5, 6, 7, 8, 9, 9, 9, 10...
If you're next after a two-way tie for 5th, you should be listed as 7th, not 6th. I just need a clever way to make the spreadsheet do that. Someone who's clever with spreadsheets should be able to get this.
EDIT: maybe by counting the number of players with the same year, same tournament and a greater number of points, then plus one? I think that's possible but I'm not an expert with the COUNT function.