Tag Archives: afleet

IOM Worlds : Parallel Scoring 5 – Standard Redress Processing……!

Leave a reply

The photo above shows you our Scoring Team’s Process Crib Sheets. Note … taped to the desk (cleaners came every night), and angled in to the HMS Scorer position. We did a lot of preparation on “process” and we shall write about the importance of that in another article. There are three process sheets here:-

  • end of heat backups
  • end of race backups
  • end of race results publishing

There is of course one missing.

Standard Redress processing.

It’s missing because none of the Team, including me, understood in advance quite how important the work around Standard Redress was going to be. It’s massive.

It’s best tackled not at the end of the penultimate day… but in every race as you go through the Championship.

Most of us had never seen fully Umpired racing before. Interesting experience.

When the Umpires deliberate, a possible outcome is that an aggrieved party – knocked to the back of the fleet perhaps – can be awarded a “Standard Redress”. It is widely acknowledged by the Umpires that the HMS Excel scoring system does not have support for Standard Redress. This type of redress includes future score averages in races after the redress was awarded. It will be a manual calculation for the Scorers to complete after the last race of the penultimate day (look up on google or IOMWorlds2026 Jury Notice 1 for the Worlds). Redress awards given on the final day can use the standard HMS Excel button for “RDGave”. HMS Excel calculates redress awards looking backwards only – not into the future.

In UK, where use of HMS Excel is the norm, as there is no tool for Standard Redress we have a tendency not to use it. At the IOM Nationals we processed one. I’d not seen one before.

To be honest, it’s a very manual and error prone calculation. Get your calculator out and try one.

At the Worlds, after three days the Umpires had awarded three standard redresses. Concerned about what this would mean for workload at the end of the penultimate day:-

  • racing ends around 1830
  • scoring completes and winds down about 1900
  • 1-2 hours of standard redresses to calculate, check, check again and then apply to HMS Excel
  • drive home (1-2 hours)
  • eat main meal of the day
  • go to bed
  • get up at 5am and do it all over again

… so I emailed the Umpires to “alert them to Scorer’s concerns as to the viability” of averaging one Standard Redress per day.

In the next two days of racing the Umpires awarded another 7 Standard Redresses. So we had 11 in total, two of them with one competitor. I had brought my Casio calculator and a ruler just in case….

Essentially for 12% of the fleet, you pop them into a boutique scoring system of their own. We had to separately hand calculate special scores based on ALL heats to date, check the rounding to 0.05, remembering which scores to exclude. (a competitor with two awards is a trap!) Then you have to apply the WORSE/BETTER score test to each Redress … then decide whether to apply to or not …. then load the answers into HMS.

Then ….publish race results to competitors so they knew exactly where they stood going in for the final day.

If you’ve read this far, you’ll understand the Scorer’s alarm.

So what did we do??

In flight, we designed, built, tested and used our own Standard Redress tool in Excel on our fourth laptop. We kept it up to date as Umpire decisions arrived, and race by race. At this award rate, no alternative really.

https://drsailing.org/wp-content/uploads/2026/06/sailing-iom-worlds-standard-redress-tool-final-at-calculatin-at-1820hrs-22-may-2026-1.xlsx

You can download our Standard Redress tool here on this link.

You are welcome to use it. If you discover an error, honestly… don’t tell me.

Points to note:-

  • every skipper with an award is tracked through the entire regatta, race by race
  • when you get an award in race N, you have to dig out all the scores in Race(1-(N-1))
  • watch out for the result exclusions
  • a skipper can have more than one award (see CRO33) and you have to cope with that
  • rounding needs to be watched
  • BETTER/WORSE Test needs to be applied

There’s a lot of calculating in there and you will see for each competitor, we ran the BETTER/WORSE test manually.

Before you load these Redresses into HMS, you need to audit them carefully. There would be hell to pay if one of them was wrong – Race Team protested etc. So how to do that audit?? The Casio Calculator??

You will note in the spreadsheet that each awarded competitor was audited (checked) by AFleet. AFleet happily has a Standard Redress button and we used it to check the answers our new tool was producing. You will see them there coloured black. Only when everything agreed, did we release the calculations for processing. Did AFleet find an error in the spreadsheet?? Yes – one. It might otherwise have snuck through undetected. But we found it.

Thank heavens for Parallel Scoring, eh??

Funny side-story :

This was a feverish work session and the whole team was ultra-focussed on their own contribution. Intense, it was. We hammered through all the processing and safely got the correct double checked answers keyed back into HMS Excel. Then I said to the Afleet scorer, “OK that’s done. Let’s do the same on the AFleet results now.” My colleague looked at me blankly and replied, “No … I finished all that ages ago….”

It built a little tension into the Umpire-Scorer relationship, I can tell you. In a very kind gesture, the Umpires presented us with gin and fruit cake. They were OK guys after all !!!

IOM Worlds : Scoring is Easy – What Could Possibly Go Wrong….??!!

Leave a reply

Scoring is easy right? What could possibly go wrong?

Actually scoring really is easy when everything is running smoothly. The challenge for any Club is to know how to handle scoring affairs when something jumps off the rails. As it probably will.

Let’s set aside the morning during the Nationals that my car sunroof spontaneously exploded while driving and showered me with glass. Thankfully not on the highway at speed. However, at a Championship that you might run, just know how your team will cope with a member not arriving for any reason.

The Systems:-

We have mature, proven scoring platforms out there. At the Worlds, we had great (new) hardware in duplicate and triplicate.

This website contains other material about protecting your Club reputation from conventional hardware glitches. There will probably be some. Did we get one of those? Yes, we did.

We had Windows 10 and 11 systems in use. Our PRO had advised that his Windows10 system (goes out of support in 2026?) was very robust. Consequently we had our additional Windows10 system running on nice Dell hardware – nice until in the middle of scoring a heat, the battery gave out. Honestly, we had to run to find screwdrivers small enough from the K7 van. It was “back off” time for the Dell. The Team did a great job of sorting that out while HMS Excel scoring continued on the HP. In an hour, it was back on the air.

The team was far more concerned about software issues, and luckily our team had a Microsoft professional on board. We needed him!!

First off – let me say that I have used HMS Excel at every regatta and championship I have ever scored (3 years, including 3 Nationals and now the Worlds). I adore the product. I love the thing. It comes from an era which is probably the last time that I felt that I understood what was going on in the technology. I’m from the “life is a spreadsheet” generation.

Designed and written by some very gifted and talented people (Henry Farley et al), it’s really very clever and does the job. Used all across the UK, and in plenty of Clubs worldwide. It’s reasonable for us all to think it has been used so many times, is so stable, that it’s the way to go.

We have to remember though that when you press the button in our Excel spreadsheet, over 90% of the machine instructions that get executed are outside the spreadsheet. The executed instructions are mainly in Excel 365 and Windows 11. On our system, the operating system and Excel are updated by microsoft every 20 days or so. It’s actually a very dynamic environment – constantly changing. Not stable at all.

Good advice from the PRO was to have Windows 10, but that goes out of support soon. So we did what seemed natural – and had both. One laptop for each.

The general direction with Microsoft is that going forward if your application was not distributed through the MS App Store (read “fees and costs”), it could be unsafe. They don’t like VB macros or Active X code. HMS has loads of that. It’s what makes it special.

These days, if you buy a new family laptop with Windows 11 Home edition (we have an HP), it comes with Safe-Mode (“S-Mode”) already enabled. You need to switch it off to run HMS. It’s a one way process and no going back. You’ll think twice before doing it. Probably when we all see windows/12 come along, it’ll be even tighter. They don’t like VB and ActiveX. We reckon no family wants to do that switch off process with their household laptop. The general drift will have to be toward dedicated HMS laptops as the years wander by. No problem – but someone needs to think about that trajectory and how the sport best caters for it. Not impossible at all.

Graham Bantock has advised me a couple of times that if you get an HMS software problem, the first thing you notice is that people will tell you that it doesn’t happen on their system. Never a truer word. So how did we get on??

1/ Going back to 2025, we have had a few “white screen” moments on Windows/11. Everything locks up. To get passed it at first, we did complete system re-boots (2-3 minute delay?) which seemed to fix it. We now suspect that simply forcing Excel365 to quit and then restarting the spreadsheet is enough. At the Worlds, we built this close/reopen of Excel into our backup process (suggested originally by Andrew Crocker) at each heat completion. The problem didn’t come back.

2/ MS Cloud Failure :

At our Dress Rehearsal, the IOM Nationals, we had our first big challenge for our HMS Excel setup. We were running on Windows/11 and suddenly we couldn’t communicate. No email. Then we realised that MS OneDrive (MS Cloud) had gone down. It stayed down for 20 hours. Naturally, we thought it was something we had done, but after 20 hours it just popped back online again. . A minor impact was that our third level of data backup ceased working. …OK – no big deal…. The huge thing for us was that we were sending results to the event webmaster via email. So we could not get results to him. It seems that on Windows/11 and Excel/365, the Outlook mail server needs One Drive running as it seems to keep its contact folders (or something) in there. No Cloud, so email stops.

After two hours our Microsoft expert found the circumventions. (a) the problem did not occur on our hot standby laptop with its Windows/10 system – see PRO advice! (b) it was still possible to use the mail service via its own dedicated email website portal. Still – it was a fight to figure this out and STAY SCORING for a couple of hours.

3/ Visual Basic Error 1004

This was our big one. Life threatening stuff. My medications were at home!!

We had a wave of after-the-event Umpire decisions arrive to apply to the scores already in the system. Nothing complex and we had sixteen heats already inside HMS. How many results is that? It’s about 350 boat scores. We made the umpires’ alterations – nothing we haven’t done before many times and suddenly we got “Visual Basic Error 1004″… telling us to log in to VB. Multiple attempts to get past this point kept locking up with Error 1004 – but with varying messages.

If it had happened later in the regatta, maybe after five days, it would have been a “game over” moment.

HMS Excel, or any system, doesn’t get used often at the maximum 84 boats level. With this combination of Windows/11 and Excel365 we could quite possibly have been the first. Anyway – we were stuck at sixteen heats and simply nothing would go in. Properly stuck.

(As a team with four software guys in it, we had a feeling as to what the Error 104 was getting at. For sure, our theory will not turn out to be what it was, but we shall write about it later on this website.)

In a somewhat religious moment, I spotted Graham B right outside the Scoring Room door. Graham’s amazing and very, very calm… and a World authority on HMS. Honestly – It was like being knocked down by an ambulance.

Graham listened carefully to our problem description then simply said, “You need to speak to Lester”. We called Lester straight away. God surely does exist as Lester answered immediately.

Lester’s advice was that when Error 1004 starts, it never, ever, goes away. You have two choices – step back through the backups until you find one that works (takes time), or… bite the bullet and go right back to an empty spreadsheet and start all over again. Enter the Umpire decisions in the normal in the normal flow and not after the event. Enter those 350 results from the beginning.

That’s what we did. The Commodore stepped in to help me reload the entire regatta to date. The team carried on scoring into the Parallel System. It took around two hours to diagnose, re-enter and check – then catch up with real time.

Frankly – I thought I was going to die. Stress is hardly a good word.

That’s what we had a parallel system for, of course. We could switch across at any time and keep going. In the heat of the moment, we knew how all that was going to work. However, we had not thought out an approval process to permit the scorers to dump one of the scoring platforms and keep going on the other. Interesting.

At this moment, we still had around 4-5 days of Championship to go. So what did we do??

1/ We booted up all three Windows Laptops, full time.

2/ From this point on, we ran two full HMS Excel systems in parallel, plus the Afleet system. We named our laptops “HMS Primary” and “HMS Secondary” and carried out our documented process flow as normal. The team were fantastic.

3/ We permanently had our third Windows laptop switched on as our “lab rat”. If we had any late umpire decisions, or anything of that ilk, we separately tested each of them singly on the lab rat before applying them to the main systems. When we eventually came to apply all the (eleven) standard redress awards on the penultimate day, they were all tested one by one on the lab rat before applying to the two main systems. Takes time – but we survived. Processing the Standard Redress awards, checkingand testing them took at least two hours. There were complaints that we were slow getting results out. I could have murdered anybody who came in and tried that on me.

We did our Standard Redress modelling on a separate MacAir system.

Now : as you know we have been all out, all year, to be extremely even handed in our support and appreciation of the two fabulous scoring systems we elected to use at this Championship. All you HMS Excel fans will be wondering if our team could now list ALL of the problems we had scoring this 84 boat, 6 day event on our AFleet tablets. So here they are, listed chronologically:-

.

.

.

.

.,

.

IOM Worlds : Parallel Scoring – 1 …Why Even Bother..??!!

Leave a reply

At your Club, are you heading towards hosting a large Championship soon?

Obviously when you’re headed towards hosting a Worlds as we were, you start thinking about the BIG questions a year or two ahead. You’ll know already that Datchet tried to always have at least two ways to do any single job at the Worlds. Does this approach apply to Scoring?? … Hell, YES !

What are the really big questions to consider in Scoring? Well, for a start you have 84 people about to arrive who have spent a lot of money to come and race with you for a week. At the end of the week, or at the end of the Championship, regardless of the week they had, they ALL want to see their name on that Results Listing.

Yes – On that last day, 84 “experts” will all gaze at the beautiful printout that you have pinned to the Official Notice Board. They expect two things –

  • it’ll look smart and professional and their name was correctly spelled
  • It will have precisely ZERO errors on it. If they find an error at that point, especially in their own score, your name will be MUD. The subject of clean results, as it happens, is a whole new thing if you Parallel Score.

Reputation Protection – The Big Issue:-

Selfishly, for your Club you should be thinking of protecting the Club’s Reputation. It takes years to build up a reputation to be considered anywhere near “capable”. As we all know from 2025, you can destroy Club reputation in a flash. Reputation takes years to build and just minutes to destroy. If Scoring were the perceived failure point, it’ll take less than a few minutes to destroy. It’ll be talked about (with sniggers) in Club bars across the world for years.

Within Scoring, everyone will tell you “it’ll never go wrong”. …. “one in a thousand chance…” etc.

Don’t you believe it. What would you do to protect your Club Reputation?

In considering Parallel Scoring, we would consider it :-

  • for a 30 Boat Event? …. Probably, No
  • For a 45-55 Boat event? … Well maybe
  • For a 55-84 boat event?… Yes, for sure.

A simple way to think about it? If the scorer or scoring system fell over on the Penultimate Day, could the Championship recover by some other means – even paper scoring?? If you have already entered a couple of thousand boat results, just think what it means.

In 2024, we made the decision to score our various upcoming Championships into two separate scoring systems at once. We called the technique, “Parallel Scoring”.

Not simply having hot standby laptops and USB sticks…. but two systems at once.

Does this mean double the work? NO.

Are there surprising benefits? YES!!

Which two scoring systems? Everyone wants to know. Regardless of if you’re racing to HMS Rules or SHRS Rules, you should first think of what volunteer skills and platforms you can access locally. Start there.

At our Club we had people with knowledge of three scoring systems for heat based racing – the MYA’s HMS Excel, HMS on AFleet and HMS on Andrew Crocker’s brilliant Fleetboard. These are three really good scoring systems. We were spoilt for choice. We shall write more on the website later about why we chose what did …and probably it will not be for the reasons you expect. …Start with the volunteers you can get and the scoring skills that they have.

Consider the technology skills you might need too – I was keen to have a team member who is a Microsoft Professional for a living. How fantastic that turned out to be.

When you choose both your scoring systems, remember that if the two systems do not run on entirely separate technologies…. there is really no point.

When you later read our analysis of the things that can/did go wrong, you’ll fully appreciate the depth of the issue and separate tech.

We felt it natural to choose HMS Excel as our primary system and then Afleet as our Parallel System.

We decided with the PRO that unless we had a catastrophic situation, official results would simply always be from our primary platform – HMS Excel 2022.