Tag Archives: tip

HMS Hack – Column Names ….!!

Leave a reply

At your Club Events do you ever have a need to have your HMS Excel results show anything other than the standard columns??

  • maybe in a non-English speaking country, you need different column names
  • if you are running youth/female/age-group leagues as sub-groups of the event
  • you are expecting a lot of overseas visitors and it makes more sense to show Country codes than Club Names
  • in your country you need to show “Association Number” but not have it named “MYA Number”

It’s not something that comes up in the normal run of things at a Club, but in HMS Excel, it’s quite easy to make such changes. In the Example above from the IOM Worlds, you will see that the Race Committee decided to show 3 character country codes where “Club/City” normally resides. They also decided to use the column which defaults to MYA Number to record Age Categories – Under 25, Open, Master, Grand Master etc.

How?

When you set up the spreadsheet ready to load the entry list, you can simply click on the pale blue coloured column headers and change/over-write the column title to anything you want …and click “save”.

IOM Worlds : “Standard Redress” Hot Tip……!!

Leave a reply
Screenshot

A competitor holding a Standard Redress Award will, …not unreasonably,… at some time towards the end of the event check the results table and see what points improvement he/she received in the impacted race.

Remember that Standard Redress awarded points can keep changing as future results arrive.

In the excitement of the moment, if it looks like the redress has not been applied per the Race Committee decision there’s going to be questions !!!!

However, not everyone will remember (experience speaking!) that before the redress is calculated and applied at the defined time, there is one final test to be completed…… “Is the awarded Redress score better/worse than the competitor scored in race itself.” The idea is that as the redress is a result that floats.changes over time, it may come out worse than the competitor actually scored.

In this case, the Scorer should not apply the redress.

TIP : the Scorer’s issue can become how to quickly show any competitor that Standard Redress has been considered but NOT applied because it failed the “BETTER/WORSE than” test. Our suggestion is that if the existing race score is to be left unchanged, it is actually entered in to the system with RDGfix, but at the same value as before. That way, a querying competitor can just quickly glance at the score table and see that the full redress test was applied – and not ask for it to be calculated all over again!!