I used the formula:andyd1010 wrote: ↑Wed Feb 19, 2020 11:36 pm Nice job with the rollout, acroamor! This is a fantastic top 15.
What was the formula used? In my prediction, the only thing I got wrong was overestimating my favorite (cellophane), but looking at the results here, I feel like it does deserve the rank I guessed! Four #1s and two #2s! 10 top-5s compared to three for Juice, which only had one top-3 vote. I know it can be justified because Juice got four more votes, but it seems like the top end is a little undervalued here.
=IF(N2>0,100*TAN(10.5/90)/(TAN((10+(N2/2))/90))," ")
Which I grabbed from an older spreadsheet on the forum. I really like how it curves. For an idea of how it spreads, this is what points get assigned to the top 20:
100
95.41204408
91.22114226
87.37766178
83.83991106
80.57261255
77.54571501
74.73346016
72.11364254
69.66701742
67.37682319
65.22839342
63.20883939
61.30678867
59.51216852
57.81602533
56.21037344
54.68806776
53.24269597
51.86848699
I could see the argument that it undervalues the top end, if someone felt that two #20s shouldn't be worth more than one #1, but I felt like it was a good balance, particularly when we had such a large sample size of people submitting lists.