I am trying to set up a race of mixed fleet Dinghy’s ie Laser, and Topaz we started these races last year and i used Sailwave then with no problems, We are no starting the 2019 Spring series and i have just noticed that the correct 2019 PY value is not included within the Sailwave file, it appears to be using the 2018 PY rating.
I have checked that Sailwave is using the correct files, there are 2 excel files in the ratings folder being used, RYPA and Limited, i assume Sailwave searches both… and the rating within the excel sheets for 2019 has increased from 1142 to 1145, But Sailwave insists on using the 2018 PY, and i am not sure where it is getting it from
I thought i saw a thread some time back about some issues with the rating files for 2019 but cannot locate is now.
Apologies for slow response have been travelling all day but I
can’t reply using my phone.
You may have configured your global options to point to the
location of the previous ratings files which are the 2018 ones.
You are correct that Jon has changed / 'corrected' the location
of the ratings files with the latest version of Sailwave full
install v 2-28-1. Versions previous to this were looking for the
ratings files in a sub-directory of where the Sailwave executable
was installed, typically C:\Program Files (x86)\Sailwave. This
location was causing problems for some in that they could not
install new ratings files easily. Jon changed the location for
ratings files to C:\Users\Public\Public Documents\Sailwave\Ratings
to overcome this problem and also make the location consistent
with the other sub-directories. If you have done a recent full
install you should see two icons on your desktop, one for the
Sailwave executable and the other to open the Sailwave data
directory under which the ratings files folder now sits.
Can you let me know the full path to the folder where you have
Dinghy’s ie Laser, and Topaz we started these races last
year and i used Sailwave then with no problems, We are
no starting the 2019 Spring series and i have just
noticed that the correct 2019 PY value is not included
within the Sailwave file, it appears to be using the
2018 PY rating.
I have checked that Sailwave is using the correct
files, there are 2 excel files in the ratings folder
being used, RYPA and Limited, i assume Sailwave searches
both… and the rating within the excel sheets for
2019 has increased from 1142 to 1145, But Sailwave
insists on using the 2018 PY, and i am not sure where it
is getting it from
I thought i saw a thread some time back about some
issues with the rating files for 2019 but cannot locate
is now.
I use a dropbox folder for the Sailwave set up for the club so that we can use a common config with one results folder across different platforms, so the full path is
c:\users\ejw\dropbox\ghyc committee team folder\2019\sailing committee\racing\sailwave\sailwave\ratings\2019 py
And within that folder are two excel sheets.
And i have verified that the contents of those excel sheets do represent the 2019 RYA PY values.
You do exactly what I do in having a common location that all
PC’s share.
You mention the word Excel, are these the Excel files downloaded
from the RYA web site? If so Sailwave will not read them.
Sailwave needs the ratings files in a certain configuration and
also the files need to be in CSV format. The ratings files can be
download in the correct configuration and CSV format from the
Sailwave web site [].
Something else to try, if you do have CSV format files from the
Sailwave web site, is to open Scoring system and click on the
ratings tab, then check the ‘Auto set competitor rating’ check box
to update class ratings if using a previous series Sailwave file
as basis for the new series. Ratings are not automatically updated
as that could change the results of a previous series.
Hope this helps but if not get in touch. Will be tomorrow now
Couldn’t the problem simply be that Sailwave needs to be “Told” to re-read the new ratings file? This is the set of instructions I use when going to a new Rating file:
To get the series files updated to 2019 numbers the following should be done:
Back up the current files series files and the ratings file.
Save the attached (new 2019) ratings file in the Ratings folder in place of the old one.
Open the first Handicap race series for Spring 2018 and select Tools -> Unscore Series
Select Setup -> Scoring System and check the box: “Auto set competitor ratings” then and click OK.
Then click Rescore. The PY numbers should now be changed to the new numbers e.g. (Laser is now 1099).
Go back into Setup -> Scoring System and clear the box: “Auto set competitor ratings” then and click OK.
Save the series.
If I am teaching the proverbial grandmother … then I am sorry. But just in case this is the issue…
You do exactly what I do in having a common location that all PC’s share.
You mention the word Excel, are these the Excel files downloaded from the RYA web site? If so Sailwave will not read them.
Sailwave needs the ratings files in a certain configuration and also the files need to be in CSV format. The ratings files can be download in the correct configuration and CSV format from the Sailwave web site [https://www.sailwave.com/rating-files-library].
Something else to try, if you do have CSV format files from the Sailwave web site, is to open Scoring system and click on the ratings tab, then check the ‘Auto set competitor rating’ check box to update class ratings if using a previous series Sailwave file as basis for the new series. Ratings are not automatically updated as that could change the results of a previous series.
Hope this helps but if not get in touch. Will be tomorrow now before I reply as been long day and off to bed.
I use a dropbox folder for the Sailwave set up for the club so that we can use a common config with one results folder across different platforms, so the full path is
c:\users\ejw\dropbox\ghyc committee team folder\2019\sailing committee\racing\sailwave\sailwave\ratings\2019 py
And within that folder are two excel sheets.
And i have verified that the contents of those excel sheets do represent the 2019 RYA PY values.
The excel file was in the correct format (CSV) I made the changes you both suggested and i got some strange results at first, when most of the entered boats ended up with no PY, and some had the correct values.
I realised what i think happened last year in that one of the other members of the club and possibly myself had manually over written the PY for some of the entrants… still learning…
Once i re-entered the class again i had better results, however some of the classes in use at the club were not included on the Ratings files, so i added 3 classes to the “Limited” sheets, i assume that is OK. But i suppose a cleaner solution would have been to add a new sheet specifically for the club as i assume Sailwave checks all sheets within the folder?
Yes Sailwave will read all the CSV files in the ratings folder
that is being pointed to in Global options. You can see how many
ratings in total have been read in, by clicking Help on the menu
bar then selecting the log book option. There is a line starting “* Loading
ratings from* …” which tells you what folder is being used
for getting the ratings and then there is a line following
starting “Loaded …” which tells you the number of ratings
in total that have been read from the CSV files in the rating
folder on the previous line.
Adding ratings to existing ratings files is not a problem, you
just need to get the format of the line correct.
Having a file of club specific ratings may be a good idea.
However, note that if there is more than one class with the exact
same name of a class in two or more ratings file then you will
have two or more of that class show when you are selecting a class
to add for a competitor.
The excel file was in the correct format (CSV) I made
the changes you both suggested and i got some strange
results at first, when most of the entered boats ended up
with no PY, and some had the correct values.
I realised what i think happened last year in that one
of the other members of the club and possibly myself had
manually over written the PY for some of the
entrants… still learning…
Once i re-entered the class again i had better results,
however some of the classes in use at the club were not
included on the Ratings files, so i added 3 classes to the
“Limited” sheets, i assume that is OK. But i suppose a
cleaner solution would have been to add a new sheet
specifically for the club as i assume Sailwave checks all
sheets within the folder?
