I support our OPTIMIST class in processing the results of a 8 series ANNUAL RANKING . As the local fleet manager wasn´t concerned about the limitation of low points scoring, i.e., that DNC specially scores based on the final number of boats participating after all series sailed, he didn´t consider this limitation after 5 series sailed.
Based on this decision, the manager expects now to re-process all the 8 series, 41 regattas results, allocating DNC position points referenced to number of entries in each series.
As this may consume many hours to process manually, is there a workaround ?
For example, could I create DNC 1, DNC 2, DNC 3, … in SCORING CODES TAB, for each series, based on the number of total entries by class (VETERANS & ROOKIES) ?
And, if this works, how could I expedite the work of changing aprox 2460 regular DNC entries ?
My thinking and it might not work. Also Jon may have better idea.
NOTE - a competitor must be using the same sail# in each regatta. Also it is not recommended to edit a Sailwave BLW but in this case it may save a lot of manual work
Create a new overall results file.
Create scoring codes - say DNCR1, DNCR2, DNCR3 etc. - where you set the points manually to be the appropriate value for each individual regatta.
Merge in regatta 1 to overall series. Save file.
Open overall series file in a text editor (Notepad or Notepad++) and replace all ,DNC,
with ,DNCR1,
Save file.
Repeat for each individual regatta replacing DNC with DNCR# where ~ is the regatta number.
I hope that makes sense. If not send me the individual regatta files together with the value of DNC appropriate for each regatta.
An alternative is to use the copy & paste functionality in the latest versions of Sailwave.
Create the appropriate DNC scoring codes - say DNCR1, DNCR2 etc - for each regatta in the overall series file with the appropriated fixed points.
Click first race column header so the view is sorted on the race column
click in the first entry in the race column with a DNC
Double click the cell and change the scoring coded from DNC to appropriate newly created one appropriate for the race. Click OK.
Now use CTL+c to copy the value
Now click the next DNC in the race column and do CTL+v to paste
Repeat for all DNC in the race column.
when column completed, save file
Click next race column and repeat above steps.
I notice from the blw file you attached that you are using an old version of Sailwave
You should update to the latest purely to be Compliant with RRS2025
But the New version also has a Copy and Paste of scoring codes so this would mean making the changes could be done very, very quickly
Copy the code you want to use, and then while holding the control down, you can just press V- DownArrow repeatedlyly so you can change the whole race in a few seconds
Does that help, or am I missing something?
I assume this is a one-off - You could probably do the whole file in 10-15 mins max. Less time than it would take to write something special
If it is something you have to do regularly, then a small program to pass the .blw file could do it.
Jon provided you with a very good way to do this. However, there is another way using Excel to create a “Import results from a CSV file” method.
I’ve attached an Excel file that is set up for your results. It is straightforward, but you will have to make changes if you have more boats. It would not take much to make a dynamic sheet.
Export the sailor names and Race columns ( I normally use sail number as the key, but because you have duplicate sail numbers I used the helmName as the key)
Save the contents of the clipboard to a CSV file ( you don’t need to do this since I’ve imported your data into the spreadsheet already)
Configure the DNC1, DNC2 codes for all the series.
Re-enter the discard profile. You’ll find if you enter s/7 you will get the same discard profile as before.
Open the attached spreadsheet.
Import the saved CSV file into cell A1 ( you don’t need to do this since I’ve imported your data into the spreadsheet already)
Enter the series number in row 38
Save column A from Worksheet “Import_Codes” into a CSV file
Use the “Import race results” option with the above CSV to change the DNC codes.
