Okay, I'm not a total illiterate when it comes to Excel, and have used it to
put together some basic spreadsheets for my business, but I started mucking
around with a results sheet for my triathlon club when I realised what I
really need to do is WAY beyond my meagre skills and capabilities. I just
thought I'd drop a line here and ask if this is something that Excel can
even do, or if it would be more in the realms of Access or even a
custom-written program.

This is what we need.

Every month when we race, we simply need to input each competitor's name and
time into a sheet (yep, I can do that)

There are Five Grades:

A-Grade Men
A-Grade Women
B-Grade Men
B-Grade Women
C-Grade Juniors

Members are awarded each points for their finishing time.
a.. Competitor A wins the grade with a time of 50mins - 1000pts
a.. Competitor B placed 2nd in 55 min - 90.9% of winning time - 909pts
a.. Competitor C placed 3rd in 60 min - 83.3% of winning time 833pts

We need to have each competitor's time and points put onto a cumulative
pointsheet which would read off each month's sheet. Not every racer
competes each month

We would then need the spreadsheet to rank the competitors by cumulative
points in the various grades, which would obviously be updated each race

At the end of the year, we would then need the spreadsheet to take each
competitor's top five points from the seven races of the season, and add
them up - ranking them again by highest to lowest in the five grades.

Each competitor needs to marshal a race, so if they don't their points are
still accummulated but they don't recieve a Qualification. If we could only
have the members who qualified first as a group in each grade, followed by
the members who didn't marshall even if their scores are higher than the
members who did. I don't know - would a radio button do here?


So how about it? Is this even within the realms of Excel or do I need to
see if a kind-hearted programmer can do something?


James Musgrave
Triathlon-Nerd