Points for Ranking Spread
 

Assume contest list with varying contestants. Now however they fall
into their places, the ranks will be have 35 places total. There are
more contestants, but we are only concerned with the final 35.

To kind of flip it around:
Assume I made a list with predictions of what the top 35 places would
be. I am receiving points based on how accurate my predictions are
according to the actual results. If I made a prediction that
contestant #1 was going to make it to 7th place and he was actually
7th place, I would get awarded the most points possible, say 15. But
let's say contestant #1 didn't get 7th place. Assume he got 8th
place.
Then I would be 1 place off so my points would be 14 instead of 15. I
guess the scenario would be drawn into 3 or 4 columns as follows:


A1:A35 = Contestant Rankings (1 - 35)
B1:B35 = My predictions of contestant rankings
C1:C35 = The points awarded for each my guesses


How I would I go about making this scenario happen?

Points for Ranking Spread
 

For the third time !! Please do not multi-post - see answer elsewhere.

Pete

On Aug 28, 4:10 pm, Noob Jedi wrote:
Assume contest list with varying contestants. Now however they fall
into their places, the ranks will be have 35 places total. There are
more contestants, but we are only concerned with the final 35.

To kind of flip it around:
Assume I made a list with predictions of what the top 35 places would
be. I am receiving points based on how accurate my predictions are
according to the actual results. If I made a prediction that
contestant #1 was going to make it to 7th place and he was actually
7th place, I would get awarded the most points possible, say 15. But
let's say contestant #1 didn't get 7th place. Assume he got 8th
place.
Then I would be 1 place off so my points would be 14 instead of 15. I
guess the scenario would be drawn into 3 or 4 columns as follows:

A1:A35 = Contestant Rankings (1 - 35)
B1:B35 = My predictions of contestant rankings
C1:C35 = The points awarded for each my guesses

How I would I go about making this scenario happen?

Points for Ranking Spread
 

in c1 enter
=max(0,15-abs(A1-B1))

copy and paste down to C35

"Noob Jedi" wrote:

Assume contest list with varying contestants. Now however they fall
into their places, the ranks will be have 35 places total. There are
more contestants, but we are only concerned with the final 35.

To kind of flip it around:
Assume I made a list with predictions of what the top 35 places would
be. I am receiving points based on how accurate my predictions are
according to the actual results. If I made a prediction that
contestant #1 was going to make it to 7th place and he was actually
7th place, I would get awarded the most points possible, say 15. But
let's say contestant #1 didn't get 7th place. Assume he got 8th
place.
Then I would be 1 place off so my points would be 14 instead of 15. I
guess the scenario would be drawn into 3 or 4 columns as follows:


A1:A35 = Contestant Rankings (1 - 35)
B1:B35 = My predictions of contestant rankings
C1:C35 = The points awarded for each my guesses


How I would I go about making this scenario happen?