Excel for tracking race results

K

kwk

I am looking for Excel template for basic functions needed in posting results
of a race. Basic phases:
1) Register racers
2) Post Results: enter racer's finish times
3) Buttons/macros to calculate a rank (simply numbering of first place,
second place, etc) based on different grouping of fields from Registration


1a) Registration: Category,Gender,Class,Age,Last Name,First Name,Bib #,
Street Address, City, State, Zip Code

2a) Post results: Bib #, Time

3a) Analyze: Rank by grouping like Category & Gender & Class; by Gender
only; etc.

Some error checking:
* Call out Bib numbers entered during Results that are not Registered
* Call out duplicate Bib #s detected during Post results

Version Control for file saving to be back to go back in case total mess
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top