To be clear, I didn’t do anything smart in my take on the spreadsheet. I picked the weight of 2x for no special reason, but was then amused to discover that this choice was mathemically equivalent to taking the average of the All score and the 1000+ karma score:
Sadj:=(Sall−S1000)/2+S1000=(Sall+S1000)/2
Other than that, I only computed the rank difference of the various scoring rules, e.g. Rank_1000 minus Rank_All.
Regarding your new spreadsheet, it’s too individualized for me to understand much. But I did notice that cell Q2 in the Graphs sheet uses a formula of “=(O2/R$1)*8000” while all subsequent cells multiply by 10000 instead. Maybe that’s a tiny spreadsheet error?
To be clear, I didn’t do anything smart in my take on the spreadsheet. I picked the weight of 2x for no special reason, but was then amused to discover that this choice was mathemically equivalent to taking the average of the All score and the 1000+ karma score:
Sadj:=(Sall−S1000)/2+S1000=(Sall+S1000)/2
Other than that, I only computed the rank difference of the various scoring rules, e.g. Rank_1000 minus Rank_All.
Regarding your new spreadsheet, it’s too individualized for me to understand much. But I did notice that cell Q2 in the Graphs sheet uses a formula of “=(O2/R$1)*8000” while all subsequent cells multiply by 10000 instead. Maybe that’s a tiny spreadsheet error?