Raw finish data to boat place

I have a question that may have been addressed, but I don’t see anything turn up in the search results.

I am scoring a regatta with multiple laps and different classes in the same start. For example, I have Blue boats, Red boats and White boats all racing at the same time, but not against each other. I get raw data from the finish line that looks like this…

Sail No

27

98

20

84

127

2000

453

27

20

98

2000

etc etc. in the order they came across the finish line. If the sail # is listed 4 times on the list, they did 4 laps. likewise with 3 laps etc. If #27 is above #20, that means that #27 did their 4th lap faster than #20. We do not time the boats, so there is no elapsed time info.

I will have some boats do 1 lap and some do 5 or more.

Sailwave recognizes what boat is in which class and scores them correctly, but I have to determine the final finishing order manually. I have to manually scan down the results and count how many times #27 crossed the finish. I do this for all boats, then compare the finishing order - meaning that if multiple boats did 5 laps, then which ones finished the 5th lap first based on the order on the list. Clear as mud? This manual process is prone to error as one missed lap is the difference between 1st and mid pack. How are other clubs dealing with this manual process? We’d like to eliminate it. Maybe sailwave can do this, but if so, I don’t know how to get sailwave to do this.

Once I get the final finish order, I use sail # wizard to enter them. Sailwave does the rest and all is good. It is that intermediate manual step between raw finish data and final boat placement that is the problem. Can anyone offer suggestions on how to eliminate this manual step? I have thought of writing an excel macro to do this for me, but why reinvent the proverbial wheel?

thanks,

Keith

Seems a unique issue, but one easily managed in Excel (without macros). I’ve freqently had to do something similar with otger types of data

I would paste the data into col A. In col B put a countif formula that counts the number of times the value in A appears in the rows adjacent and above. In col C put a similar formula that counts how mamy times the value in A appears in the rows adjacent and below. In col D put an if formula that returns the value in C if the value in B is 1, blank otherwise. Finally apply a filter for non blank values in D. This column now shows the lap counts for the sail numbers in A.

Those formulas can be written with absolute and relative references so they only need to be entered on one row and filled down to the others.

No macros, which many people find obscure, and easy to use.

Ian

···

On 14 May 2014 20:54, “bruno-nospam@usa.net [sailwave]” sailwave@yahoogroups.com wrote:

I have a question that may have been addressed, but I don’t see anything turn up in the search results.

I am scoring a regatta with multiple laps and different classes in the same start. For example, I have Blue boats, Red boats and White boats all racing at the same time, but not against each other. I get raw data from the finish line that looks like this…

Sail No

27

98

20

84

127

2000

453

27

20

98

2000

etc etc. in the order they came across the finish line. If the sail # is listed 4 times on the list, they did 4 laps. likewise with 3 laps etc. If #27 is above #20, that means that #27 did their 4th lap faster than #20. We do not time the boats, so there is no elapsed time info.

I will have some boats do 1 lap and some do 5 or more.

Sailwave recognizes what boat is in which class and scores them correctly, but I have to determine the final finishing order manually. I have to manually scan down the results and count how many times #27 crossed the finish. I do this for all boats, then compare the finishing order - meaning that if multiple boats did 5 laps, then which ones finished the 5th lap first based on the order on the list. Clear as mud? This manual process is prone to error as one missed lap is the difference between 1st and mid pack. How are other clubs dealing with this manual process? We’d like to eliminate it. Maybe sailwave can do this, but if so, I don’t know how to get sailwave to do this.

Once I get the final finish order, I use sail # wizard to enter them. Sailwave does the rest and all is good. It is that intermediate manual step between raw finish data and final boat placement that is the problem. Can anyone offer suggestions on how to eliminate this manual step? I have thought of writing an excel macro to do this for me, but why reinvent the proverbial wheel?

thanks,

Keith

Oops. Final step is to filter on lap count. Start with the max laps then the sail nos are in order for entry to SW. Then the next lower lap count etc.

You could do this automatically using another formula but not right off the top of my head!

Ian

···

On 14 May 2014 20:54, “bruno-nospam@usa.net [sailwave]” sailwave@yahoogroups.com wrote:

I have a question that may have been addressed, but I don’t see anything turn up in the search results.

I am scoring a regatta with multiple laps and different classes in the same start. For example, I have Blue boats, Red boats and White boats all racing at the same time, but not against each other. I get raw data from the finish line that looks like this…

Sail No

27

98

20

84

127

2000

453

27

20

98

2000

etc etc. in the order they came across the finish line. If the sail # is listed 4 times on the list, they did 4 laps. likewise with 3 laps etc. If #27 is above #20, that means that #27 did their 4th lap faster than #20. We do not time the boats, so there is no elapsed time info.

I will have some boats do 1 lap and some do 5 or more.

Sailwave recognizes what boat is in which class and scores them correctly, but I have to determine the final finishing order manually. I have to manually scan down the results and count how many times #27 crossed the finish. I do this for all boats, then compare the finishing order - meaning that if multiple boats did 5 laps, then which ones finished the 5th lap first based on the order on the list. Clear as mud? This manual process is prone to error as one missed lap is the difference between 1st and mid pack. How are other clubs dealing with this manual process? We’d like to eliminate it. Maybe sailwave can do this, but if so, I don’t know how to get sailwave to do this.

Once I get the final finish order, I use sail # wizard to enter them. Sailwave does the rest and all is good. It is that intermediate manual step between raw finish data and final boat placement that is the problem. Can anyone offer suggestions on how to eliminate this manual step? I have thought of writing an excel macro to do this for me, but why reinvent the proverbial wheel?

thanks,

Keith

Hi Keith,

Have a look at this - I think it does exactly what you want.

https://sites.google.com/site/eskdalesite/home/sailwave-multi-lap-finishing-grand-prix

I haven’t tested it with the latest versions of Sailwave but if it doesn’t work I’ll soon fix it for you. I will be using it myself in a few weeks time so I need to check it out. Bit busy this week but next week should have some time

Jon

···

Jon Eskdale
07976 709777

Skype “eskdale”

On 14 May 2014 22:42, Ian Savell iansavell@gmail.com [sailwave] sailwave@yahoogroups.com wrote:

Seems a unique issue, but one easily managed in Excel (without macros). I’ve freqently had to do something similar with otger types of data

I would paste the data into col A. In col B put a countif formula that counts the number of times the value in A appears in the rows adjacent and above. In col C put a similar formula that counts how mamy times the value in A appears in the rows adjacent and below. In col D put an if formula that returns the value in C if the value in B is 1, blank otherwise. Finally apply a filter for non blank values in D. This column now shows the lap counts for the sail numbers in A.

Those formulas can be written with absolute and relative references so they only need to be entered on one row and filled down to the others.

No macros, which many people find obscure, and easy to use.

Ian

On 14 May 2014 20:54, “bruno-nospam@usa.net [sailwave]” sailwave@yahoogroups.com wrote:

I have a question that may have been addressed, but I don’t see anything turn up in the search results.

I am scoring a regatta with multiple laps and different classes in the same start. For example, I have Blue boats, Red boats and White boats all racing at the same time, but not against each other. I get raw data from the finish line that looks like this…

Sail No

27

98

20

84

127

2000

453

27

20

98

2000

etc etc. in the order they came across the finish line. If the sail # is listed 4 times on the list, they did 4 laps. likewise with 3 laps etc. If #27 is above #20, that means that #27 did their 4th lap faster than #20. We do not time the boats, so there is no elapsed time info.

I will have some boats do 1 lap and some do 5 or more.

Sailwave recognizes what boat is in which class and scores them correctly, but I have to determine the final finishing order manually. I have to manually scan down the results and count how many times #27 crossed the finish. I do this for all boats, then compare the finishing order - meaning that if multiple boats did 5 laps, then which ones finished the 5th lap first based on the order on the list. Clear as mud? This manual process is prone to error as one missed lap is the difference between 1st and mid pack. How are other clubs dealing with this manual process? We’d like to eliminate it. Maybe sailwave can do this, but if so, I don’t know how to get sailwave to do this.

Once I get the final finish order, I use sail # wizard to enter them. Sailwave does the rest and all is good. It is that intermediate manual step between raw finish data and final boat placement that is the problem. Can anyone offer suggestions on how to eliminate this manual step? I have thought of writing an excel macro to do this for me, but why reinvent the proverbial wheel?

thanks,

Keith

Jon,

Thanks for the reply. I had a chance to try out the Grand Prix/ Multi-lap addon and I was unable to make it work. The sail number wizard initially worked, but then stopped pulling info from the sailwave file. I have no idea why. It also didn’t seem to pull all the competitors from the .blw file even though the competitor count was accurate. I had 22 competitors and only 11 of them showed up in the front page grid.

Even without this bug, I would be unable to use it based on how it’s set up, or based on how I have sailwave set up. I have 5 starts for each race and each start can have multiple classes. We sail one start at a time and a competitor can enter 2 classes and therefore be in 2 different starts. Sailwave’s sail number wizard allowed that and showed me the sail numbers along with the class. If US 234 was in 2 classes, it would show me US 234 class A, and US 234 Class B. The add on only showed me US234 twice with no classes, so I would not know which class I was entering results for.

Do you know if anyone has used this successfully? Were you able to get it working?

I don’t mean to sound ungrateful because sailwave has been a big help to us and cut down a lot of time. It’s just that based on how we run races, there is still that manual component that takes a lot of time and is prone to human error.

thanks for the help,

Keith

Hi Keith,

I think the first problem is that you are probably misusing the Class and Fleet fields - quite a common mistake. From the ABYC Sailwave manual

It is important to understand some basic concepts that are used in Sailwave. If you don’t understand the terminology it is easy to get confused.

Fleet – A group of boats that will sail and be scored together, they can be a one design class, or different boats using a handicap or rating system. Portsmouth, PHRF, or IRC would be a fleet made up of several different classes of boats using a handicap or rating system. Conversely Naples Sabots, or Optimists may be broken up into several different fleets, A’s, B’s, C’s etc.

Class – The type of boat all carrying the same class insignia per Rule G1.1(a). Examples are Farr 40, 49er, Snipe, Cal 20, Naples Sabot, Optimist, etc.

Division – Generally used to further divides fleets. For example, Olympic 470 Men and Women often sail in a combined fleet, and are scored combined, with the division indicating Men and Women.

Flights – A flight is a competitor attribute that can change on a per race basis. It is most commonly used in very large regattas where the fleet size precludes a single mass start. The fleet is divided into flights in accordance with Appendix LE Addendum C qualifying series. Laser Class, Formula 18 Catamaran, International Optimist Class Association (IODA) and International Naples Sabot Association (INSA) events use variations of this method for their large championships.

From this you can see that you need to have the A and B in the Fleet field not the Class Field - If you really want you can have fleets called Class A and Class B but that is a bit confusing. If you are using the class field for what is the Fleet you can use the Menu - Tools - Set competitor field to copy them all to the Fleet field.

This should then display all the competitors and also show you which fleet they are in when you enter the competitor sail no allowing you to choose.

When you say it stopped showing SailNos did you have the ignore competitors with results box ticked?

I used it on Saturday and it works except it currently doesn’t support the Alternative sailno as that was added to Sailwave after this was written. But yes it does work and has been used for many events.

If you are still having difficulties send me you blw (Sailwave file) and I’ll have a look

Jon

···

Jon Eskdale
07976 709777

Skype “eskdale”

On 28 May 2014 05:10, bruno-nospam@usa.net [sailwave] sailwave@yahoogroups.com wrote:

Jon,

Thanks for the reply. I had a chance to try out the Grand Prix/ Multi-lap addon and I was unable to make it work. The sail number wizard initially worked, but then stopped pulling info from the sailwave file. I have no idea why. It also didn’t seem to pull all the competitors from the .blw file even though the competitor count was accurate. I had 22 competitors and only 11 of them showed up in the front page grid.

Even without this bug, I would be unable to use it based on how it’s set up, or based on how I have sailwave set up. I have 5 starts for each race and each start can have multiple classes. We sail one start at a time and a competitor can enter 2 classes and therefore be in 2 different starts. Sailwave’s sail number wizard allowed that and showed me the sail numbers along with the class. If US 234 was in 2 classes, it would show me US 234 class A, and US 234 Class B. The add on only showed me US234 twice with no classes, so I would not know which class I was entering results for.

Do you know if anyone has used this successfully? Were you able to get it working?

I don’t mean to sound ungrateful because sailwave has been a big help to us and cut down a lot of time. It’s just that based on how we run races, there is still that manual component that takes a lot of time and is prone to human error.

thanks for the help,

Keith

Thanks for the help, Jon. I feel like a complete dope. I cannot seem to figure this out and at this point, I don’t know if it’s a bug or something I’ve done.

I have installed Grand Prix finish for sailwave from your link. It came in the file SWAddons.zip.

I open it and followed the directions on your site which seem pretty self explanatory, but there are competitors that are not showing up in the sail # wizard. I simplified it to 4 competitors. SWGP picks up 3 of them. I do not have the option of clicking the ‘Ignore competitors with results’ because that line is just not in my window. Neither is the Position, Code, 1 or BFD options. They are Just not in the window on my screen. Do I have the correct version?

Sorry to be a pest, but it’s pretty important I get this figured out. I have the world championship of dirtboats coming up and I would like to save time by using this.

I did change the fleet to match what you said, and that fixed the one issue I was having above.

Thanks,

Keith

Hi Keith,

I’m not sure which version it is that you are using, below is a link to the currently latest version of SWGP (v1.2)

https://sites.google.com/site/eskdalesite/download/SWGP.zip?attredirects=0&d=1

As I think I said before it doesn’t currently support the alternative sail number as it was written before that was added to Sailwave. If you think it would be useful to you I’ll see if I can add it easily.

I did use it myself a few weeks ago and for what I was doing it worked OK.

If you still have some competitors missing with this version if you could send me your blw file I’ll have a look.

As for controls missing from your window - What OS are you running, what resolution are you viewing at and what is the native resolution of your screen?

Jon

···

Jon Eskdale
07976 709777

Skype “eskdale”

On 24 June 2014 04:23, bruno-nospam@usa.net [sailwave] sailwave@yahoogroups.com wrote:

Thanks for the help, Jon. I feel like a complete dope. I cannot seem to figure this out and at this point, I don’t know if it’s a bug or something I’ve done.

I have installed Grand Prix finish for sailwave from your link. It came in the file SWAddons.zip.

I open it and followed the directions on your site which seem pretty self explanatory, but there are competitors that are not showing up in the sail # wizard. I simplified it to 4 competitors. SWGP picks up 3 of them. I do not have the option of clicking the ‘Ignore competitors with results’ because that line is just not in my window. Neither is the Position, Code, 1 or BFD options. They are Just not in the window on my screen. Do I have the correct version?

Sorry to be a pest, but it’s pretty important I get this figured out. I have the world championship of dirtboats coming up and I would like to save time by using this.

I did change the fleet to match what you said, and that fixed the one issue I was having above.

Thanks,

Keith

Jon,

Great Success! The version that came in the addon.zip file must have been an older one. The version I got through the latest link you provided worked perfectly. I can see all the items I am supposed to now. I tested it on 4 different races and it all checked out. Thanks for sticking with me and working this one through. This helps me a lot.

Will this feature ever be integrated directly into sailwave? This method of scoring is exactly what I needed.

Thanks again,

Keith