As a volunteer and all around fun open source web app project I have been working on enhancing the Leadville Trail 100 race series reporting capabilities. I competed in the Silver Rush 50 MTB last year and was quickly hooked by the compelling high altitude scenery. From the course to the competitors it was an all around blast. It shouldn’t have come as a surprise to me, but this project has been a blast too.

The current version of the Results Query Engine is looking rough around the edges, but it will be fun to plug some of the holes and round this into a fully functional tool. The following lists serve as feature enhancements and bug fix trackers.

Enhancements

  1. Clean up the entry form and give it a professional look.
  2. Add form inputs for racer names as jQuery using SelectCombo and JSON.
  3. Form selects on any give field will activate population of subsequent input fields (e.g., select race, then years are populated, user then selects year(s) and racers are populated).
  4. Form option to generate results as download-able file (i.e., Excel XML, Google Docs, etc.)
  5. Backend/Frontend to Upload new race results to DB directly, this will be tricky and might be a fantasy feature, but let’s dream big.
  6. Figure out a smoother layout in table rows for interval and delta times.
  7. Include interval distances as part of interval/delta calculated info.
  8. Enable reporting for all races not just the two MTB ones.
  9. Calculate split times against all other times to show virtual race place at the time of the split.
  10. Race result names could link to another report that would show that racers results for all previous races of that type (e.g. SR 50).
  11. Race result names could also have a pop up box on hover that would show abbreviated results for past races, maybe even all race types instead of the one currently being reported on. Screen space might be a problem here. Another possible fantasy feature.
  12. Race result racer home towns could link to a Google map or such.

Bugs/Problems

  1. Form validation for all inputs.
  2. Steamline code base using PHP PEAR HTML_QuickForm.
  3. Use javascript to set form values on results runs, this will keep the form from “blinking” on reloads.
  4. Change current race and year inputs to use better multi select - default multi is junk and a nightmare to end users.
  5. Racer name input box not working.
  6. Space the form submit buttons farther apart to increase ease of selection.
  7. Is the race data correct for SS type riders, let’s double check the database input program.
  8. Tighten up table columns by simplifying header names and using HTML breaks where possible.