More than 40 boats for NHC Progressive Handicap

Progressive Handicap
1

Hi all, this year we have had over 40 combinations of boats and helms sailing meaning the Sailwave supplied excel spreadsheet (SWNHC3.xls) couldn’t cope when I came to calculate the progressive NHC handicaps :frowning: .
If you run into the same problem you need to edit SWNHC3.xls (probably found in C:\Program Files (x86)\Sailwave\Templates on a Windows installation).
Add sufficient new rows, above row 48, of the Main tab, I would suggest a ‘copy and insert’ to be sure you have the necessary formulae in your new rows, and then amend the SheetSize value on the Config tab to match the total number of rows you now have on the Main tab.
I hope this may save you a bit of time searching for files should you experience the same issue :grinning_face:

2

Hi

There is a topic on this that I wrote some years ago. But I guess it’s gone a little far back now to find easily. But out of curiosity is there any reason you are not using the built in NHC

Regards

Jon