Hello all. As some of you will be aware I have just finished writing a
program in excel that keeps track of competitors in dirt bike racers in cross
country events. Teams consist of 2 riders and the both riders have the same
rider number. The program records the time the rider number is typed in as
they finish each lap. The next stage is to implement electronic tag reading
and each rider will have an ID tag that gets scanned at the end of each lap.
This has led to a few complications I would like to overcome in the planning
stage before I start changing the code. Firstly what I have now is shown
below. Rider names and number is input before the race. No of laps is a
formula. The times at the end of lap 1, 2, etc are input using a user form
where the user types the rider number and the code records the time when the
rider number was entered and saves it against the appropriate team. PL stands
for the teams place at the end of that lap.


Rider Names Rider No. No Laps LAP PL LAP PL 1 2
John Smith / Bob Brown 100 2 00:00:07 1 00:00:13 2
An example of the program output that the riders get to see is shown here

http://www.narrabridirtbikeclub.com/..._5_Results.pdf

My problem is there are no rules as to the order the two riders in each team
ride their laps (one rider can even do all the laps for the team if they so
desire). My simplified version assumes they alternate laps as this is what
most do and I have no way of identifying indivdual riders anyway. With the
tag id's I will know which rider did which lap.

Can anyone think of a simple way to keep track of each idividuals lap times
so that I can calculate each riders average, max and min lap time. The tag
numbers are not consecutive numbers and basically random 6 digit numbers.

I would like to indicate which rider did what laps so I thought I would put
one riders lap in red font and the other left in black. Could this be used to
calculate values across each row.

Sorry for the long post and I hope I have given enough info so you can
follow what I want. My hassle is I need to keep times together as a team as
well as having sub groups of each riders times for separate calculations
without making things too complex.

Thanks

If you're tracking the rider's tag number in a column, couldn't you simply
use Data -- Filter -- AutoFilter to view an individual rider's times?

In any case, you're probably going to have to track that tag number in a
column and it will be better to use for identifying riders than colors would.
Working with colors really doesn't come close to being practical until Excel
2007. It can be done in earlier versions, but usually requires VBA coding to
deal with it. Even conditional formatting in earlier versions only provided
4 options (basic + 3 conditionals).

"NDBC" wrote:

Hello all. As some of you will be aware I have just finished writing a
program in excel that keeps track of competitors in dirt bike racers in cross
country events. Teams consist of 2 riders and the both riders have the same
rider number. The program records the time the rider number is typed in as
they finish each lap. The next stage is to implement electronic tag reading
and each rider will have an ID tag that gets scanned at the end of each lap.
This has led to a few complications I would like to overcome in the planning
stage before I start changing the code. Firstly what I have now is shown
below. Rider names and number is input before the race. No of laps is a
formula. The times at the end of lap 1, 2, etc are input using a user form
where the user types the rider number and the code records the time when the
rider number was entered and saves it against the appropriate team. PL stands
for the teams place at the end of that lap.


Rider Names Rider No. No Laps LAP PL LAP PL 1 2
John Smith / Bob Brown 100 2 00:00:07 1 00:00:13 2
An example of the program output that the riders get to see is shown here

http://www.narrabridirtbikeclub.com/..._5_Results.pdf

My problem is there are no rules as to the order the two riders in each team
ride their laps (one rider can even do all the laps for the team if they so
desire). My simplified version assumes they alternate laps as this is what
most do and I have no way of identifying indivdual riders anyway. With the
tag id's I will know which rider did which lap.

Can anyone think of a simple way to keep track of each idividuals lap times
so that I can calculate each riders average, max and min lap time. The tag
numbers are not consecutive numbers and basically random 6 digit numbers.

I would like to indicate which rider did what laps so I thought I would put
one riders lap in red font and the other left in black. Could this be used to
calculate values across each row.

Sorry for the long post and I hope I have given enough info so you can
follow what I want. My hassle is I need to keep times together as a team as
well as having sub groups of each riders times for separate calculations
without making things too complex.

Thanks