Ron,
I'm not sure you know what I mean. For example the first event had 48
players with only 16 getting points, but the bonus is calculated by mutipling
the number of players in the event (48) by 5 and multipling that number by
the percentage of bonus they finished. So a person finishing in second would
get 300 points and a 20% bonus ((48 x 5)x.20)
PLACE LAST FIRST MEMBER # PL PTS Bonus% Bonus POINTS

1st Schaller Jim 20200005277 16 450 0.3 3 453
2nd 2 300 0.2 2 302
3rd 3 180 0.12 1.2 181.2
4th 4 120 0.08 0.8 120.8
5th 5 105 0.07 0.7 105.7
6th 6 90 0.06 0.6 90.6
7th 7 75 0.05 0.5 75.5
8th 6 90 0.04 0.4 90.4
9th 9 15 0.01 0.1 15.1
10th 10 15 0.01 0.1 15.1
11th 12 15 0.01 0.1 15.1


"Ron Rosenfeld" wrote:

On Tue, 18 Oct 2005 12:46:05 -0700, "Cabo Wabo Jim"
wrote:

Ron,
That works great but same problem.

If the number of players for each event varies that varies the bonus point
structure for each event. I need to total up about 10 seperate events per
month into one scoring system and ranking.

Jim

Either I did not understand what you wrote, OR you are not using the function
as it was designed.

If, as I wrote, "each players 'place' is entered into the data table area" then
every player that played will be counted. Of course, only those that placed at
level 1-16 will have a score generated.

Perhaps if you post some real data that is not giving the correct results, it
would be helpful.
--ron