Last year I wrote a program that will generate Sparkline charts from a Sailwave file. To accomplish this I received a lot of assistance and encouragement from Jon and Huw.
The program has many features such as highlighting sailors based on a criteria, a bar graph of the number of boats entered in each race, highlighting the top boats, custom highlighting, dynamic labeling, custom labeling, etc.
The way the program works is that it prompts you for the Sailwave file and it will then open the file and read the contents. For every race, starting with the last race, it rescores the results, collects the ranks and points of the boats, deletes the race and repeats this. After the first race it will close the Sailwave file without saving it.
It will detect if the series is part of a qualifying / final series and prompts you for the Sailwave file that contains the qualifying part. This is because the scoring set up is changed when a series moves from the qualifying to the final series.
Hi SUG Members,
Yesterday I sent Peter a Sailwave file because it was taking a long time to process.
Peter investigated and I had excluded competitors in the file which had not been thought of. So a quick delete of the excluded competitors and everything is fine.
An updated version to filter out excluded competitors may come.
I have been making this chart manually using a spreadsheet and it is tedious. I too found myself waiting for a response for several minutes before reading about the need to delete the excluded entries.
A couple items I am seeing in my use… I am running this under Crossover on a Mac, so whooo knows what that does. But I have not found a way to change the title of the Sparkline chart, no matter what I enter into item “4”. It seems locked to use only the event title. Nor can I change the line labels from sail no. to the boat name (%boat%) in item “27”.
Note, my Sailwave files embed some html codes in the event title (%event%) since I publish results to a website, so finding a way to filter those <…> codes out of the event title would be good, or being able to change the title in item 4.
Both the Title and Line label change for me, but you have to press the enter key after changing the data for each of them. I need to find a solution that when the focus changes from the text box that the text is accepted without pressing the enter key.
Stripping the HTML code from the Title string is a bit easier.
Yes… hitting the enter/return key after changing the title does result in the typed in text taking effect as expected. Also, success with changing %sailno% to %boat%.
I sent Peter my BLW file to test his approach to ignoring the excluded competitors and stripping out embedded HTML format codes within <…> characters. In my case, using Peter’s recent test code, It started to process the BLW file, but then the program returned some error messages, which I copied to Peter.
I e-mailed you a screen capture movie and some answers to the questions. Let me know if you did not get it. This forum does not let me upload the movie file.
For Mac users, this program works with Sailwave using Crossover to interpret the Windows instructions. I installed the program into the same “bottle” as Sailwave. However, for me, the program sometimes hangs up after reading the .BLW file and at the point it is just beginning to backup through results, eliminating the “last” race to successively recalculate the rankings. But don’t despair if the program hangs up here and returns a few error messages. Quit the program and restart it using another .BLW file, or restart Crossover, or even try restarting the computer. Then go back to the file you are trying to process. Usually, one of these work-arounds will result in the program completing normally and generating the sparkline graph and then you can try it on the file you are interested in. The reason(s) for the seemingly random hang-up are not yet known. But, even with this minor issue, it is much faster than trying to create this graph using a spreadsheet.