Calling all excel experts ...
I need some help!
We time sprinters, we care about the times. A lot. As well as power data which we don't always have, having a long term record of speeds and distances is very important to us.
What I'd like to be able to do :
select a rider (or very quickly create a new one)
select a discipline : eg entry + 100, standing start 1/4 lap etc
select a gear in inches
enter a total distance, and split distances if easy enough/practical
enter a time, or a series of times (splits) and have some way to tell it what the splits represent - eg distances, with the ability to do special cases, eg we sometimes do a standing lap, where we want the first 65m, the second 65m then the last 125m
See a chart of this time and splits vs previous times for this rider for the discipline
For the purposes of rapid data entry we'd want to be able to select a rider, then have most of the stuff set as a (quickly alterable!) default and then bang the times in so we can get data into a spreadsheet or some other sort of database very quickly. We're under a lot of time pressure when we do these. Doing them after the fact is unlikely to happen as there's just too much data do double-handle.
Does anyone who reads this have any suggestions? Can it be done in a spreadsheet or will we need something fancier?