In the case where 234 is the best, 120 is the worst, and all 11 in
between have the same value - then they should all have the same
weighted points (7.0) - because they all make up the same percentage of
the difference.
And I think this is how it should work now....
The Numerator is the value of that row less row 13 (last place).
The denominator is: Calculate the sum of 2nd-12th place - the 11 items
in the middle. Then Subtract 11*13th place value from that number.
The result of this division is the percent that the value of that row
contributes to the spread of the category.
Multiply this by 77 (the remaining value of weighted points to be
awarded (91-13-1=77)) and it mostly works.... values to close to last
place are less than 1 point. Take the 77 and replace with 66 and add 1
to each answer... that gets me close enough...
Bookmarks