Ranking Spread Points
 

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

I would I go about making this scenario happen?

Ranking Spread Points
 

I've just answered this in another group - please do not multi-post.

Pete

On Aug 28, 1:58 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

I would I go about making this scenario happen?