How about:
Actual / Guess | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
1 | 15 | 13 | 12 | 11 | 10 | 9 | 8 | 7 | 6 | 5 |
2 | 13 | 15 | 14 | 13 | 12 | 11 | 10 | 9 | 8 | 7 |
3 | 12 | 13 | 15 | 14 | 13 | 12 | 11 | 10 | 9 | 8 |
4 | 11 | 12 | 13 | 15 | 14 | 13 | 12 | 11 | 10 | 9 |
5 | 10 | 11 | 12 | 13 | 15 | 14 | 13 | 12 | 11 | 10 |
6 | 9 | 10 | 11 | 12 | 13 | 15 | 14 | 13 | 12 | 11 |
7 | 8 | 9 | 10 | 11 | 12 | 13 | 15 | 14 | 13 | 12 |
8 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 15 | 14 | 13 |
9 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 15 | 14 |
10 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 15 |
11 | -- | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 |
12 | -- | -- | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
13 | -- | -- | -- | 5 | 6 | 7 | 8 | 9 | 10 | 11 |
14 | -- | -- | -- | -- | 5 | 6 | 7 | 8 | 9 | 10 |
15 | -- | -- | -- | -- | -- | 5 | 6 | 7 | 8 | 9 |
16 | -- | -- | -- | -- | -- | -- | 5 | 6 | 7 | 8 |
17 | -- | -- | -- | -- | -- | -- | -- | 5 | 6 | 7 |
18 | -- | -- | -- | -- | -- | -- | -- | -- | 5 | 6 |
19 | -- | -- | -- | -- | -- | -- | -- | -- | -- | 5 |
20 | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
Max score would be 150. You'd have to be within nine spots of the film's actual rank to earn points, so if your #1 pick falls outside the top ten to 11th, you'd get zero points; but if your #10 pick ends up 11th, you'd get 13 points. This also maintains a point bonus for guessing the actual rank exactly.
=MAX(14-ABS(actual-guess),0)*IF(ABS(actual-guess)>9,0,1)+IF(actual=guess,1,0)
pixote