Jade Race Results

The Jade Race Results program is a Visual Basic application coupled to a normalised Microsoft Access database. The database file location is specified in the Options form and by default is the Data folder under the installation root directory (normally C:/Program Files/Race Results). The Options form may be used to specify a different location, for example on a network drive.

The program creates report output files in XML format which are then transformed by XSLT into XHTML or whatever. The transform files are in the reports folder, the location of which is specified in the Options form and may be changed. By default this is the Reports folder under the installation root directory. With knowledge of XSLT, the transform files may be edited to produce different output formats.

The report output files are put in folders created for each year under the reports folder. The file names are structured mmdd_hhmm_et.xxx (example: 0118_1000_2R.htm)

mmdd = Scheduled date for race - month & day (numeric)
hhmm = Start time for the first class alphabetically - hours & minutes (only for report types B, R, S)

e = Entrants included:
0 - Series entrants
1 - Subseries entrants
2 - All entrants

t = Type of report:
R - Individual race results
S - Overall race results
B - Both of the above
A - Entry list by sail number
C - Class sheets
E - Entry list by handicap

xxx = File extension (htm or xsl)

For many years the author worked as an IT professional for major international organisations. He actively sails the X-332 'Pyxis' and is a Royal Yachting Association qualified race officer with extensive race management experience. He was Rear Commodore Sailing of the Royal Southampton Yacht Club for three years and is a current member of the Cowes Week Sailing Committee as well as a Deputy Principal Race Officer for Cowes Week, an annual regatta attracting close to 1000 entries.