Points Tracking

  • Thread starter Thread starter snowsurfer
  • Start date Start date
S

snowsurfer

I am trying to create a spread sheet that tracks points for my son
racing finishes. The first problem I have run into is that you ca
only nest 7 IF statements
I have 6 Colums.
Race Date, Track Name, Class Raced, Number of Racers, Finish, Points

The important columns are Class Raced, Number of Racers, and Finish.
The Column I am trying to auto fill is of course Points.

Here is where it gets tricky. There are three classes. Novice, Inter
and Expert. First place for Novice is worth 25 points. However firs
place for Expert is 100. They give points all the way down to 8th plac
(hence the problem with 7 nested ifs)



So the first thing I am having it do is IF C3=Novice,

Then I start confusing myself

Attachment filename: race.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=54649
 
I forgot to add that the number of Riders adds to the point total.

So if you race novice and you get first place its worth 25 points. I
there were 8 people in your race your total would be 25+8=33.

I know this can be done, but I am stuck

Thank
 
You should make a data list with finish placement going down the rows, and
classes going across the columns.
Then fill in the array with the various points awarded for each finish in
each class.
You would then search this array with your formula to come up with the
awarded points.

Start your data list in column J.
Say that J1:M1 is filled with:
Finish, Novice, Intermediate, Expert.

J2:J9 is simply finish position - 1 to 8.

Fill in the rest of the array with the various points awarded.

Now, A1:F1 is as you described in your question:
Date, Track, Class, Num.of Racers, Finish, Points.

Enter this formula in F2:
=INDEX($K$1:$M$9,MATCH(E2,$J$1:$J$9,0),MATCH(C2,$K$1:$M$1,0))+D2

Drag down to copy as needed.

As you originally stated, I added one point for each participant, as entered
in column D.

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I forgot to add that the number of Riders adds to the point total.

So if you race novice and you get first place its worth 25 points. If
there were 8 people in your race your total would be 25+8=33.

I know this can be done, but I am stuck

Thanks
 
Thanks for the help. Un*&^%$# beleivable. I am amazed at what Exce
can do. There is occasionaly a double or triple point event, I coul
simply make another data list and reference that couldnt I
 
..
Describe more clearly, exactly what you mean .
How would it be identified, so that you could add the points to the total?
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------


Thanks for the help. Un*&^%$# beleivable. I am amazed at what Excel
can do. There is occasionaly a double or triple point event, I could
simply make another data list and reference that couldnt I?
 
Back
Top