Hi, I am trying to set up a progressive handicap system using the external excel file. I have found the NHC file in the sailwave examples folder, but I can’t work out how to get Sailwave to populate the file. I think it can see the file because when I run the scoring it comes up with a box with Sailwave Helper in the corner with the series name and fleets etc. But is uses the VYC ratings for the results rather than a NHC type rating.
For information, we are sailing dinghy fleets (Mirrors, Sabres, Open class), with two starts, one for Mirrors and Sabres etc and one for Open class. We are using VYC for the mixed fleets. However we also want to have progressive handicaps so the beginners can get recognised for their improvement.
Tony
Deviot Sailing Club, Tasmania
First thing to do is test with the sample NHC file (NHC2014.blw) in the examples folder
Click rescore and make sure it all works - Press F6 then R and it will display the ratings used for each race.
This is using a built in method to calculate the NHC ratings and not the Excel Spreadsheet
Now go to Scoring system and the Rating system tab
Now click the rescore button
Now you should see Excel open up with the first race details and the Sailwave helper window which allows you to manually step through the races or just click the “Update all” button
This template works with TCF ratings and if the rating convert is switched on (see the Config sheet in the template) Sailwave will convert PY ratings to the equivalent TCF before populating the sheet and convert the results back to PY when it is returned to Sailwave
There is a tick box Excel Link which when ticked allows you to specify your own template file rather than use the standard supplied with Sailwave.
You will probably want to create Aliases so you can score with both straight ratings and a personal handicap system
One issue was there were no starts defined for the Alias fleets so I’ve added those and the errors then disappeared
I did notice (if you press F6 R) when you display the ratings that there were some overrides of ratings for the straight handicap races - I guess you created these while you were experimenting and didn’t delete them so I have removed those for you
I also notice in Race 3 45272 had a time of 2 hrs better than the other competitors which made the Ratings jump a very unusually large amount so I made them a bit slower - I appreciate they were only random times you had entered.
The more in the fleet the better it can adjust them as it has to determine what is normal
Thanks for that. I didn’t realise that I had to enter starts for the alias fleets. I’m not sure how those ratings got in there, and I couldn’t work out how to delete them! Yes the times were a bit random. I’m chasing up some real numbers to work on, but once I get the structures right the rest shouldn’t be too hard.
Tony
Hi Tony
To delete over-ride ratings Highlight the cell with the rating you wish to remove and press Enter then select the ratings tab and delete the rating value using Backspace - press enter. Sailwave will now remember you are editing ratings so to delete others
Use the arrow keys to move to the required cell. Press Enter - Backspace - Enter and you have deleted that cell - repeat this line as necessary
In practice this is very quick move the cell then Enter-Backspace-Enter as necessary
In our club we have a similar request from our Squib fleet. They wanted a one design result as well as a progressive handicap result. My solution was to set up two fleets (Squibs One Design and Squibs Progressive). Each boat was in both fleets and I used aliasing to link them together. For both fleets I set an initial handicap at the start of the season for each boat of 1.000. For the Squibs One Design fleet the rating system was a standard TCF. For the Squibs Progressive I used the swecho.xls template to progressively adjust the handicaps. The only thing that was a bit weird was asking the race office to take times for a one design fleet and I entered a finish time for each boat rather than a place. Each week the progressive handicap adjusted so as the season went on very different boats were winning in the progressive fleet than won in the one design fleet. It worked really well for us.
I’m not getting any errors, but am getting some strange behavior. The calculations work for the most part, but then for numerous racers, after a certain point their rating changes to 0 for all subsequent races. It works for the same racer at earlier points, but then seems to stop even though elapsed times have been entered.
Is there a limit to the number of races and competitors? I have 40 racers in a series of 85 races.
I am new to this forum thing and sorry if I posted in the wrong place. Can you help me and point me in the direction to find the information out.
We run a series of keeler races during the summer, 50 boats 10 race series all with handicaps. The club uses and external provider to provide new handicaps before each race ( each race each boat has a revised handicap) Is there a way I can upload the race data, handicaps for that race ? I am not keen to go through 50 boats manually on each race and input their new handicaps. If you could point me in the direction to find a help article would be appreciated. Ian
Hi Malcolm,
Good point. Jjust need to marry up the externally provided new ratings and the finish data before importing.
Probably be even better if an Excel template was created that produced the new ratings that the external source is providing. Then it would all be done as part of scoring the series
