|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Database for tracking bicycle race times
I've been asked to put together a database (access or something) to
keep track of an upcoming mountain bike race. The last time they used excel. I'd like to try and find something a little more elegant and easier for inputting racer numbers and keep track of their times and categories. Is there something out there already or do I need to create something from scratch? Ideally it would be something I could put in front of a volunteer and they could quickly bring up a racer's number and input their times. Also, it would nice if it could create cool looking results reports. TIA Matt 661.885.2699 |
Ads |
#2
|
|||
|
|||
Database for tracking bicycle race times
mraymus a écrit profondement:
| I've been asked to put together a database (access or something) to | keep track of an upcoming mountain bike race. The last time they | used excel. I'd like to try and find something a little more elegant | and easier for inputting racer numbers and keep track of their times | and categories. Is there something out there already or do I need | to create something from scratch? | | Ideally it would be something I could put in front of a volunteer and | they could quickly bring up a racer's number and input their times. | Also, it would nice if it could create cool looking results reports. | MySQL will do the trick just fine Matt But you will need to write a small user interface to get the data in and get it out more easily. It can be done from the command line but would be much too slow and error prone. It won't require much in the way of programming after you decide the structure of your data files. It could be done very easily using tcl/tk. See if you can find someone who could do it on a Windoze box -- Davey Crockett - Avoid the Gates of Hell. Use Linux |
#3
|
|||
|
|||
Database for tracking bicycle race times
On Feb 6, 12:19 pm, mraymus wrote:
I've been asked to put together a database (access or something) to keep track of an upcoming mountain bike race. The last time they used excel. I'd like to try and find something a little more elegant and easier for inputting racer numbers and keep track of their times and categories. Is there something out there already or do I need to create something from scratch? Ideally it would be something I could put in front of a volunteer and they could quickly bring up a racer's number and input their times. Also, it would nice if it could create cool looking results reports. TIA Matt 661.885.2699 The folks that run the Winter Park race series have a very efficient system using bar codes on the number plates. I think they use the same hand held scanners used by the ski lift attendants. They manually adjust the times since they can't scan you immediately as you cross the line. They have results up in PDF format the same day. http://www.epicsingletrack.com/Resul...e6/results.pdf Bret |
#4
|
|||
|
|||
Database for tracking bicycle race times
On Feb 6, 12:55 pm, Bret wrote:
On Feb 6, 12:19 pm, mraymus wrote: I've been asked to put together a database (access or something) to keep track of an upcoming mountain bike race. The last time they used excel. I'd like to try and find something a little more elegant and easier for inputting racer numbers and keep track of their times and categories. Is there something out there already or do I need to create something from scratch? Ideally it would be something I could put in front of a volunteer and they could quickly bring up a racer's number and input their times. Also, it would nice if it could create cool looking results reports. TIA Matt 661.885.2699 The folks that run the Winter Park race series have a very efficient system using bar codes on the number plates. I think they use the same hand held scanners used by the ski lift attendants. They manually adjust the times since they can't scan you immediately as you cross the line. They have results up in PDF format the same day. http://www.epicsingletrack.com/Resul...e6/results.pdf Bret Where do I get this system? |
#5
|
|||
|
|||
Database for tracking bicycle race times
On Feb 6, 7:54 pm, mraymus wrote:
On Feb 6, 12:55 pm, Bret wrote: On Feb 6, 12:19 pm, mraymus wrote: I've been asked to put together a database (access or something) to keep track of an upcoming mountain bike race. The last time they used excel. I'd like to try and find something a little more elegant and easier for inputting racer numbers and keep track of their times and categories. Is there something out there already or do I need to create something from scratch? Ideally it would be something I could put in front of a volunteer and they could quickly bring up a racer's number and input their times. Also, it would nice if it could create cool looking results reports. TIA Matt 661.885.2699 The folks that run the Winter Park race series have a very efficient system using bar codes on the number plates. I think they use the same hand held scanners used by the ski lift attendants. They manually adjust the times since they can't scan you immediately as you cross the line. They have results up in PDF format the same day. http://www.epicsingletrack.com/Resul...e6/results.pdf Bret Where do I get this system? that looks pretty generic. you need to find someone that knows something about databases, like MySQL. sounds like you want to set up the database and make a front end for your results person to use where they can just pull up a rider and enter their time. you will also need another interface for entering the rider's other details. there is most likely something you can find that will do the job, or be easily adapted. |
#6
|
|||
|
|||
Database for tracking bicycle race times
On Feb 6, 5:54 pm, mraymus wrote:
On Feb 6, 12:55 pm, Bret wrote: On Feb 6, 12:19 pm, mraymus wrote: I've been asked to put together a database (access or something) to keep track of an upcoming mountain bike race. The last time they used excel. I'd like to try and find something a little more elegant and easier for inputting racer numbers and keep track of their times and categories. Is there something out there already or do I need to create something from scratch? Ideally it would be something I could put in front of a volunteer and they could quickly bring up a racer's number and input their times. Also, it would nice if it could create cool looking results reports. TIA Matt 661.885.2699 The folks that run the Winter Park race series have a very efficient system using bar codes on the number plates. I think they use the same hand held scanners used by the ski lift attendants. They manually adjust the times since they can't scan you immediately as you cross the line. They have results up in PDF format the same day. http://www.epicsingletrack.com/Resul...e6/results.pdf Bret Where do I get this system? I don't know the details of their system. You could try contacting them through the contact information on their main page. They've been really helpful whenever I've contacted them. http://www.epicsingletrack.com/default.asp Bret |
#7
|
|||
|
|||
Database for tracking bicycle race times
On Feb 6, 8:19*pm, mraymus wrote:
I've been asked to put together a database (access or something) to keep track of an upcoming mountain bike race. * The last time they used excel. * I'd like to try and find something a little more elegant and easier for inputting racer numbers and keep track of their times and categories. * *Is there something out there already or do I need to create something from scratch? Ideally it would be something I could put in front of a volunteer and they could quickly bring up a racer's number and input their *times. Also, it would nice if it could create cool looking results reports. TIA Matt 661.885.2699 Do you want to do it for the fun of it, or is the end product the most important? You might look into a pro type timing system: http://www.championchipusa.com/timers.html I have no idea how much that costs, but it has been employed at all the larger events I've been in. It's fun to get a print out with split times, etc. As far a rolling your own, find somebody who is an Excel wiz. They can make entry boxes, graphs, and all sorts of snazzy stuff. |
#8
|
|||
|
|||
Database for tracking bicycle race times
|
#9
|
|||
|
|||
Database for tracking bicycle race times
www.raceforever.com Has an Access database for historical and rider management system, and a spreadsheet for on the day race results. Spreadsheet can be stand alone or linked to database, with results publised to the web. Spreadsheet is free, Access database is free to use for one year. Regards Peter McLennan |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Bicycle Website Database | roadbiker | General | 1 | November 30th 05 11:57 PM |
Bicycle Website Database | roadbiker | Techniques | 1 | November 30th 05 11:47 PM |
Vintage Bicycle Picture Database - 826 pix and counting | Menotomy | General | 0 | August 14th 03 01:29 PM |