I was wondering if there is a best practice for rank calculations in case of same ranks. The given use case is a soccer scoring table, where teams may end up with the same score and ranks are assigned by a second criteria which could be the number of goals.
You can calculate a new score from score and # of goals like: SCORE + GOALS / 1000
Like
TEAM, SCORE, GOALS, NEWSCORE
A, 80, 63, 80.063
B, 80, 70, 80.070
C, 77, 100, 77.100
Team B ranks highests.
If you've got multiple Criteria, you could extend this easily. You only need to define the maximum value range for each criteria, then map the results of each criteria into distinct value ranges, like
