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
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