I think you’re probably right (but want to think more about) the results printing the “Voting Results” post being more of a weighted average. Prior to reading your comment, I was thinking I might might 1000+ karma votes as 3x the “All” votes (whereas you had 2x). But, in this case 3x still results in “Microcovid” winning the “weighted average”, so the result is kinda the same.
FYI here’s my personal spreadsheet where I’ve been futzing around with various display options. It includes my own methodology for weighting the results and combining them, which I think is different from yours although I didn’t delve too deeply into your spreadsheet architecture.
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?
I think you’re probably right (but want to think more about) the results printing the “Voting Results” post being more of a weighted average. Prior to reading your comment, I was thinking I might might 1000+ karma votes as 3x the “All” votes (whereas you had 2x). But, in this case 3x still results in “Microcovid” winning the “weighted average”, so the result is kinda the same.
FYI here’s my personal spreadsheet where I’ve been futzing around with various display options. It includes my own methodology for weighting the results and combining them, which I think is different from yours although I didn’t delve too deeply into your spreadsheet architecture.
https://docs.google.com/spreadsheets/d/1L05yz0Y7ST4klK2riBKExBL1AbxGn8VnE-HL-zxdyiA/edit#gid=1406116027
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?