Personal tools
You are here: Home Members carl Carl's Blog Archive 2010 May 10 Calling all excel experts ...
Document Actions

Calling all excel experts ...

by Carl Brewer last modified 2010-05-11 02:56

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?

SQL

Posted by Carl Brewer at 2010-05-11 02:57
I've decided that an SQL database is going to be a better choice than a spreadsheet. Potentially we have years of data and the complexity is best served by using a real database.

Powered by Plone CMS, the Open Source Content Management System

This site conforms to the following standards: