David is correct. They would split the points and there would be no
tie breaker for points.
I know it may sound confusing, but even within each class the tie
breaker code you helped earlier was to determine who must go first in
the next event not to assign points. The points would be shared like
David said.

An example would be if 4 people get the same distance and their time
was the same say 1st through 4th tied and there were 5 entrants,

1st through fourth would each get 2.5 points (1+2+3+4)/4 and the 5th
person would get 1 point.

for a total of 15 points (1+2+3+4+5)

Please let me know if you would like more details.

Thank you very much.
-Gary



On Mar 20, 3:16 pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
I assume his logic is that they are sharing 1st and 2nd places. 6 pts for
1st, 5 pts for 2nd, so if the two tie, they each get 5.5 ?
--
David Biddulph

"T. Valko" wrote in message

...



I'm not following you on this. Take the 1st group as an example. If 1st
place is worth 6 pts then why do the first place finishers only get 5.5
pts?

Biff
wrote in message
roups.com...

One final question, I think.

All of the formulas given have worked perfectly
and I was hoping to modify them to figure out how to determine points
for
each class and then the overall points when grouping both classes
together.

I have made it work with individual classes (kind of ugly formulas
though)
but I am having trouble getting the points for the overalls as you can
see by the
results of row "H" in the list below.

I am wondering if you or anyone can create a formula for the class
points and
the overall points.

Points are just the nuber of entries in the class. So if there are 6
people.
First place gets 6 points and sixth place would have 1 point. If there
are
ties (this is the part I am stuggling most with) then the points are
split
between as many people as would be needed. You can see this in the
class points column(G).

A B C D E F G H
1 Group 1
2 Name Order Distance Time Place Points OA_Pos OA_Pts
3 Name1 1 100 1 1 5.5 1 13
4 Name2 3 100 2 3 4 3 1
5 Name3 4 100 3 4 3 4 1
6 Name4 5 100 4 5 2 5 1
7 Name5 2 100 5 6 1 6 1
8 Name6 6 100 1 1 5.5 1 2
9
10 Group 2
11 Name Order Distance Time Place Points OA_Pos OA_Pts
12 Name1 7 100 15 8 1 14 1
13 Name2 1 100 8 1 8 7 1
14 Name3 2 100 9 2 7 8 1
15 Name4 3 100 10 3 6 9 1
16 Name5 4 100 11 4 4.5 10 2
17 Name6 5 100 12 6 3 12 1
18 Name7 6 100 11 4 4.5 10 2
19 Name8 8 100 14 7 2 13 1

Thank you in advance.
-Gary- Hide quoted text -

- Show quoted text -