The MYA Heat Management System (HMS) is the race management system normally used in the UK to allow many boats to compete in an event by using a number of heats. It is a progressive development of the Peter Stollery EORS (Equal Opportunity Racing System).

HMS has been adopted by the RSD for world class events.

The file HMS 2007 Scoring(v2.2t4)blank.xls, which can be extracted from the zip file HMS2007(v2.2t4).zip (downloadable from this site - see link above) is an Excel workbook specifically tailored to score HMS.

Originally developed by Mike Kemp in Lotus 123 for EORS, it was updated and modified by John Walter to Excel 97 and HMS and since modified, enhanced and kept up to date for HMS by Henry Farley and Herman van Beek.

It does just about everything needed to score an event of up to 84 boats, in 5 heats and 41 races.

It will also handle single heat events where, unlike HMS, Race 1 is treated like every other race.

Version 2.2 of the HMS Scoring software incorporates some changes to avoid some of the errors users have made while using the previous versions and makes it clear that it will only work with MS Excel 97 to 2007.

A single button on the Score Sheet now reveals various options among which it is easier to change the promotion schedule from 4 to 6, or vice versa.
Redress in the form of Average for the Event is now available automatically.

BASICS OF USE.

Open the file with Excel 97 (see below) or later. Immediately Save As with a name of your choice e.g. MyEvent.

Move to the Score Sheet and enter the details of the event (Event, date, Host)

On the Score Sheet enter Skippers names, their Sail Nos. and other details in the columns provided.

For each Race move to the Race Results sheet and enter Sail Nos. for each Heat in the finishing order.

After any Race you can go to the Score Sheet and click on the Program Options button.

This will give you the choice of printing either the Summary Sheet or a complete set of results in colour from the Score Sheet

The link above downloads a zip file HMS2007(v2.2t4).zip containing the Excel Workbook and a PDF document of instructions.

PLEASE READ THE FULL INSTRUCTIONS!!!

HMS 2007 Scoring(v2.2t4)scoring.xls is the Excel Workbook saved as a Read Only file.
It is compatible with all versions of Excel from 97 to 2007 but no other spreadsheets.

HMS 2007 Scoring Instructions 22 is the PDF file.