Scoring by Division

Imported from Yahoo
1

We’re running a regatta next month with about 50 Hobie 16’s (one design) and we would like to use sailwave for doing the regatta results. I’ve set up a test regatta using about 30 boats, with divisions for Youth, Womens, Masters and Grand Masters. I’ve entered test results for 4 races using positions for finishes and thrown in the odd DNF, DNE & OCS. Scoring the overall series results and individual race results worked great and published well. Scoring by division also worked well and published well, EXCEPT FOR when publishing the individual races by division, (let’s say we have 10 women and are scoring by womens division) when I publish the individual race it shows the correct points score 1 to 10), the correct ranking (1 to 10), but for the place it shows the finish position in the whole fleet (i.e position is between 1 and 50) when I only want the finish place in that division (i.e. between 1 and 10). Is there a way to achieve this.

Thank you

Paul

2

Hi Paul,

When you click score series you have two options Score all competitors as one group and the other is Score groups of competitors separately. I assume you selected the first - If you select the second does this do what you want? If not if you could supply a sample file - I’m sure someone here will help you out.

If it is just for prizes you may like to look at the SWPrize program that will create a prize list for you

Jon

···

On 27 November 2014 at 04:02, pgdavis123456@yahoo.com.au [sailwave] sailwave@yahoogroups.com wrote:

We’re running a regatta next month with about 50 Hobie 16’s (one design) and we would like to use sailwave for doing the regatta results. I’ve set up a test regatta using about 30 boats, with divisions for Youth, Womens, Masters and Grand Masters. I’ve entered test results for 4 races using positions for finishes and thrown in the odd DNF, DNE & OCS. Scoring the overall series results and individual race results worked great and published well. Scoring by division also worked well and published well, EXCEPT FOR when publishing the individual races by division, (let’s say we have 10 women and are scoring by womens division) when I publish the individual race it shows the correct points score 1 to 10), the correct ranking (1 to 10), but for the place it shows the finish position in the whole fleet (i.e position is between 1 and 50) when I only want the finish place in that division (i.e. between 1 and 10). Is there a way to achieve this.

Thank you

Paul

Jon Eskdale
07976 709777

Skype “eskdale”

3

Hi Jon

Thanks for your prompt reply. I use both options for scoring. I score all competitors as one group for the overall regatta result, and it scores correctly and publishes correctly. I also use the Score groups of competitors separately, to score each division (i.e. Masters, Grand Masters, Women and Youth). When publishing using the option to score by division, it publishes the series scores correctly, however, when I publish individual races, instead of showing their place in the Masters field (i.e. 1-14) in the place column, it shows their place in the whole fleet (i.e. 1-33), which is not actually correct. I’m sue I’ll get a lot of queries as to how they can get 28th in a fleet of 14.

I’ve attached a htm file of the published results for the Masters fleet, which has 14 boats. The whole fleet has 33 boats. You can see the series results are correct, and it’s only when I publish individual races the place column is not correct. I would like the Place column for individual races to show their position within the Masters fleet (i.e. 1-14). If you want to mess with the data file, I’ve uploaded that as well.

Thank you

Paul

—In sailwave@yahoogroups.com, <jon@…> wrote :

Hi Paul,

When you click score series you have two options Score all competitors as one group and the other is Score groups of competitors separately. I assume you selected the first - If you select the second does this do what you want? If not if you could supply a sample file - I’m sure someone here will help you out.

If it is just for prizes you may like to look at the SWPrize program that will create a prize list for you

Jon

Jon Eskdale
07976 709777

Skype “eskdale”

···

On 27 November 2014 at 04:02, pgdavis123456@… [sailwave] sailwave@yahoogroups.com wrote:

We’re running a regatta next month with about 50 Hobie 16’s (one design) and we would like to use sailwave for doing the regatta results. I’ve set up a test regatta using about 30 boats, with divisions for Youth, Womens, Masters and Grand Masters. I’ve entered test results for 4 races using positions for finishes and thrown in the odd DNF, DNE & OCS. Scoring the overall series results and individual race results worked great and published well. Scoring by division also worked well and published well, EXCEPT FOR when publishing the individual races by division, (let’s say we have 10 women and are scoring by womens division) when I publish the individual race it shows the correct points score 1 to 10), the correct ranking (1 to 10), but for the place it shows the finish position in the whole fleet (i.e position is between 1 and 50) when I only want the finish place in that division (i.e. between 1 and 10). Is there a way to achieve this.

Thank you

Paul

4

So is anyone able to help with this problem?

5

Hi Paul,

If I understand correctly what you are looking for is results with only a subset of the competitors being included - for this the easiest way would probably be to mark all the over competitors as excluded and then score and publish

This can easily be done by using the Tools - Set competitor Field

Select all competitors that the Division <> Women and change the Exclude field to 1

Now score and publish

To include all the competitors again

Tools - Set Competitor Field - select all competitors and set the Exclude field to 0

Jon

···

On 1 December 2014 at 11:47, pgdavis123456@yahoo.com.au [sailwave] sailwave@yahoogroups.com wrote:

So is anyone able to help with this problem?

Jon Eskdale
07976 709777

Skype “eskdale”

6

Thanks for that Jon, and it almost worked.

I set the competitors to division <> women, and then Field to change is Exclude, and then Set this value = 1.

I then re-scored the series, and the worksheet shows all of the other divisions are excluded and women are scored correctly from 1st to 6th.

HOWEVER, when I publish the results, instead of the place showing from 1st to 6th, it shows the place in their original positions somewhere between 1 to 33. So have I missed something? The worksheet interface shows the correct results, but when I publish the results it doesn’t show the correct results. So the error appears when I publish the results.

I’m using Version 2.16.7.

Regards

Paul

7

Hi Paul,

The position is always going to be their position in the race.

If you don’t want this then you can use the tools rearrange recorded places - you don’t need to change any places just open and save, but it will remove the excluded and adjust the others appropriately.

Repeat for each race and you will then have what you want. Don’t forget to make a backup copy of the results before, as after you have done this you can’t go back to the full set.

The other possibility would be to create the starts as only including division = women. I think that would work but the first solution definitely does.

Jon

···

On 1 December 2014 at 15:02, pgdavis123456@yahoo.com.au [sailwave] sailwave@yahoogroups.com wrote:

Thanks for that Jon, and it almost worked.

I set the competitors to division <> women, and then Field to change is Exclude, and then Set this value = 1.

I then re-scored the series, and the worksheet shows all of the other divisions are excluded and women are scored correctly from 1st to 6th.

HOWEVER, when I publish the results, instead of the place showing from 1st to 6th, it shows the place in their original positions somewhere between 1 to 33. So have I missed something? The worksheet interface shows the correct results, but when I publish the results it doesn’t show the correct results. So the error appears when I publish the results.

I’m using Version 2.16.7.

Regards

Paul

Jon Eskdale
07976 709777

Skype “eskdale”

8

I did such a test on one of my result sets - publishes correctly (as you want), so its not Sailwave, but something in your setup?

regards,
Malcolm Osborne
Sedgefield South Africa

082 377 9217

···

On 2014/12/01 17:02, pgdavis123456@yahoo.com.au [sailwave] wrote:

Thanks for that Jon, and it almost worked.

I set the competitors to division <> women, and then Field to change is Exclude, and then Set this value = 1.
I then re-scored the series, and the worksheet shows all of the other divisions are excluded and women are scored correctly from 1st to 6th.
HOWEVER, when I publish the results, instead of the place showing from 1st to 6th, it shows the place in their original positions somewhere between 1 to 33. So have I missed something? The worksheet interface shows the correct results, but when I publish the results it doesn't show the correct results. So the error appears when I publish the results.
I'm using Version 2.16.7.
Regards
Paul

------------------------------------------------------------------------
<http://www.avast.com/>

This email has been checked for viruses by Avast antivirus software.
www.avast.com <http://www.avast.com/>

---
This email has been checked for viruses by Avast antivirus software.
http://www.avast.com

9

Thanks Malcolm and Jon.

I’ll start with Jon first. Taking into account that the person entering the results is a volunteer, we need to keep the procedure for entering and publishing the results simple. I consider myself extremely computer literate, and I wouldn’t dare to use such complicated procedures for doing results during a regatta where time is a serious constraint. So I’ll have to count those methods out.

Now on to Malcolm. It’s heartening to see that the software can publish the correct results for divisions, however I just need to confirm that we’re talking about the same thing. When I publish the results for the Series, it gives the correct results, probably because it’s using the score rather than the place. When I publish each race individually, if the total competitors is 33 and the Youth division competitors are 6, the place column should be 1 to 6, but when published it’s 1 to 33 (their finish position in the original fleet). Can you please double check that this is different to what you get.

Also a BIG/HUGE favour. Can you load my data file, which I attached earlier, and see if you can get that to work for you.

So now for the solution!!! I’m probably going to show a lot of ignorance here, but the results worksheet shows the correct place for each division (after scoring series by divisions). So all I should need to do is update the results.htm template to pick up that field rather than the field from scoring the fleet as a whole. I would imagine that Colin should be able to fix my problem quite quickly. Is there any way that Jon could point him in my direction.

Thanks

Paul

10

Hi Paul,

I don’t really understand why you even want to publish individual race tables for a one design class unless you want to show their overall position in the race. What are you gaining?

What is wrong with the series summary table - you can publish this as positions or points or publish it twice if you really want both

But if you do want to publish individual race tables for only one division then it will show their position in the division and in the race overall. Personally I think it is better as it is showing the position in the division and the position in the fleet.

If what I understand you want is the individual race tables to show the same for both the position in the division and the position in the race then they must be considered as the only ones in the race. Which either means excluding all the others or putting them in separate starts for the purpose of scoring.

If you do really want this and only want to do it once at the end the procedure I described previously would only take a few minutes at worst. Probably wouldn’t want to do it after every race but it is still feasible.

Give me a Skype call if it helps Skype name “eskdale” Lydney UK or call 0044 3333 443377 UK landline

Jon

···

Jon Eskdale
Sailwave

03333 443377

07976 709777

11

Are you trying to score the Women as a Division within larger fleet or a separate fleet. If the first place women finishes 3rd, do they receive 3 points or 1 point?

If the later, you should probably use aliases to score the Women as a separate fleet. Following are definitions of Fleet, Class, Division, Flights.

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. or flights, Blue, Yellow, Purple, etc. or Divisions, Men and Women.

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.

Mark Townsend
Phone: 562-433-4366

Cell: 562-533-5909
Email: s_mark_townsend@hotmail.com

···

From: sailwave@yahoogroups.com [mailto:sailwave@yahoogroups.com]
Sent: Tuesday, December 02, 2014 4:05 AM
To: sailwave@yahoogroups.com
Subject: [sailwave] Re: Scoring by Division

Thanks Malcolm and Jon.

I’ll start with Jon first. Taking into account that the person entering the results is a volunteer, we need to keep the procedure for entering and publishing the results simple. I consider myself extremely computer literate, and I wouldn’t dare to use such complicated procedures for doing results during a regatta where time is a serious constraint. So I’ll have to count those methods out.

Now on to Malcolm. It’s heartening to see that the software can publish the correct results for divisions, however I just need to confirm that we’re talking about the same thing. When I publish the results for the Series, it gives the correct results, probably because it’s using the score rather than the place. When I publish each race individually, if the total competitors is 33 and the Youth division competitors are 6, the place column should be 1 to 6, but when published it’s 1 to 33 (their finish position in the original fleet). Can you please double check that this is different to what you get.

Also a BIG/HUGE favour. Can you load my data file, which I attached earlier, and see if you can get that to work for you.

So now for the solution!!! I’m probably going to show a lot of ignorance here, but the results worksheet shows the correct place for each division (after scoring series by divisions). So all I should need to do is update the results.htm template to pick up that field rather than the field from scoring the fleet as a whole. I would imagine that Colin should be able to fix my problem quite quickly. Is there any way that Jon could point him in my direction.

Thanks

Paul

12

Paul,

I think there are a number of folks who want to help you but I for one
don't understand what it is you want to do. Your email doesn't include
any prior correspondence so your "problem" is somewhat of a mystery.

Sailwave can score a big group (MAIN) and then sort by a subgroup (SUB).
You then get results sorted by SUB rather than by MAIN but since you
scored by MAIN everything relating to scores is done with reference to
MAIN. That seems to be a problem for you but it is not clear what you
want instead. [You could get almost the same thing by sorting after
scoring. The one thing the "sort by" function under scoring does is to
renumber the places within each SUB group.]

For example, in a Laser fleet you might have separate SUBs for Masters
categories. You would score the entire fleet and publish. Then, you
could score again and sort by Masters category and publish again to a
separate page. That would leave you with the MAIN results on one page
and the SUB results on another page. Since you scored with respect to
MAIN your SUB results would reflect the same points as the MAIN although
the positions would be different. The SUB results don't look
particularly pretty but then that might be because that is not a
commonly used option. I don't remember seeing it used in any results
I've seen although I'm sure it is used regularly for specialized purposes.

Sailwave has another option called "Aliases" (that needs to be enabled
under the "User interface" in order to see it). That allows you to score
the same boat twice - once in MAIN and again is some other grouping
(OTHER). Using an "Alias" creates a shadow boat with identical finish
information but it can have different ratings etc. and will be scored in
the OTHER group. When scored, an "Alias" boat is scored with respect to
only the boats in OTHER and not all the boats in MAIN. A boat with an
"Alias" shows up twice in Sailwave, once in MAIN and once in OTHER. When
using "Aliases" you can have an "Alias" for fewer than all boats in
MAIN; in other words, some boats can be in MAIN only while others are in
both MAIN and OTHER (if you are using MAIN/SUB then EVERY boat in MAIN
must be in a SUB).

Using the Laser example, you could score MAIN and OTHER on the same page
(since they are separate groups). Boats in OTHER would get points only
with respect to the other boats in OTHER. A boat in 23rd place in MAIN
but which is 1st in OTHER gets a score of 1 point (whereas that boat
would get a score of 23 when sorted and displayed in SUB).

It is not clear from your message which of those two you are looking for
or even whether you might be looking for some third alternative.

[I've used MAIN, SUB and OTHER because you can use almost any field to
score by. In particular, you could use FLEET, CLASS and DIVISION at your
option. Those terms can mean different things in different countries so
I've avoided using them.]

Art

PS - It would be helpful to include ALL relevant prior correspondence in
your messages to the User Group so someone trying to come to your
assistance can get the full picture. For sure, you can edit out
irrelevant or repetitive stuff but at a minimum leave in enough so a
late reader can understand what the issues are.

···

On 12/2/2014 4:05 AM, pgdavis123456@yahoo.com.au [sailwave] wrote:

Thanks Malcolm and Jon. I'll start with Jon first. Taking into
account that the person entering the results is a volunteer, we need
to keep the procedure for entering and publishing the results simple.
I consider myself extremely computer literate, and I wouldn't dare to
use such complicated procedures for doing results during a regatta
where time is a serious constraint. So I'll have to count those
methods out. Now on to Malcolm. It's heartening to see that the
software can publish the correct results for divisions, however I
just need to confirm that we're talking about the same thing. When I
publish the results for the Series, it gives the correct results,
probably because it's using the score rather than the place. When I
publish each race individually, if the total competitors is 33 and
the Youth division competitors are 6, the place column should be 1 to
6, but when published it's 1 to 33 (their finish position in the
original fleet). Can you please double check that this is different
to what you get. Also a BIG/HUGE favour. Can you load my data file,
which I attached earlier, and see if you can get that to work for
you.

So now for the solution!!!! I'm probably going to show a lot of
ignorance here, but the results worksheet shows the correct place for
each division (after scoring series by divisions). So all I should
need to do is update the results.htm template to pick up that field
rather than the field from scoring the fleet as a whole. I would
imagine that Colin should be able to fix my problem quite quickly. Is
there any way that Jon could point him in my direction. Thanks Paul

13

Thanks everyone for your assistance with this problem. What I was trying to achieve was to score a division within the main group, which the software does easily and there are many ways to configure the software to do this. However, when publishing individual races, the “Place” column prints finishes with respect to their finish within the main fleet. So if the main fleet has 33 competitors, and the division (Youth) has only 6 competitors, I wanted the “Place” to be the place within that division (i.e. 1,2,3,4,5,DNF) NOT their place in the whole fleet (i.e. 2,8,15,25,26,DNF).

The software scores the positions correctly both for individual races and for series scores, and calculates the dropped races correctly.In fact it does everything correctly when scoring by divisions/fleet/anything, and what I’m after is just a “neatness” thing. If I publish results for a race scored by division containing a subset of 6 Youth boats, I don’t want the youth competitors to be asking how they could get a place of 15th, 25th or 26th in a division of only 6 boats.

I’ve had a lengthy discussion with Jon, and apparently because their finish positions are entered with respect to the whole fleet, the software remembers and uses this finish position for the divisions, so at this stage I cannot publish their finish “Place” with respect to their division only. As I said, it’s a “neatness” problem rather than a scoring problem, because the scored results are all calculated correctly.

As it’s using a database, the software could certainly calculate their new “Place” within the division so it shows 1,2,3,4,5,DNF, but at the moment no one has asked for that functionality. Personally, I think that like me, many people would use that option if it was available, but as it isn’t, they just make do. I’m hoping that Jon will add this function sometime in the near future.

Once again, thanks to everyone for your assistance.

Paul Davis

14

Hi Paul,

Just a small point Sailwave stores all the competitor and race data

in a text file similar in concept to XML or JSON not a database like
MS SQL Server, MySQL, SQLlite, Oracle.

It stores the the raw competitor and race data which is then

manipulated by the Sailwave application when publishing information.

There are a few people who have worked out the Sailwave.BLW file

structure and extract the information into a database. It has been
discussed at various times over the years to provide a
facility/mechanism to write the Sailwave data into a database.

It is possible when you know Sailwave data structure very well, to

automate reading from the Sailwave.BLW file manipulate the data in
some way and then write back the updated information. Jon has done
this with the RYA NHC rating calculation in external mode by passing
the data to Excel spreadsheet where a rating for the next race is
calculated and then written back to Sailwave.BLW file. Note - this
only works using Excel and under a Microsoft operating system
environment.

Kind regards,
Huw
···

On 03/12/2014 08:35,
[sailwave] wrote:

pgdavis123456@yahoo.com.au

          Thanks everyone for your assistance with this problem.

What I was trying to achieve was to score a division
within the main group, which the software does easily and
there are many ways to configure the software to do this.
However, when publishing individual races, the “Place”
column prints finishes with respect to their finish within
the main fleet. So if the main fleet has 33 competitors,
and the division (Youth) has only 6 competitors, I wanted
the “Place” to be the place within that division (i.e.
1,2,3,4,5,DNF) NOT
their place in the whole fleet (i.e. 2,8,15,25,26,DNF).

          The software scores the positions correctly both for

individual races and for series scores, and calculates the
dropped races correctly.In fact it does everything
correctly when scoring by divisions/fleet/anything, and
what I’m after is just a “neatness” thing. If I publish
resul ts for a race scored by division containing a subset
of 6 Youth boats, I don’t want the youth competitors to be
asking how they could get a place of 15th, 25th or 26th in
a division of only 6 boats.

          I've had a lengthy discussion with Jon, and apparently

because their finish positions are entered with respect to
the whole fleet, the software remembers and uses this
finish position for the divisions, so at this stage I
cannot publish their finish “Place” with respect to their
division only. As I said, it’s a “neatness” problem rather
than a scoring problem, because the scored results are all
calculated correctly.

          As it's using a database, the software could certainly

calculate their new “Place” within the division so it
shows 1,2,3,4,5,DNF, but at the moment no one has asked
for that functionality. Personally, I think that like me,
many people would use that option if it was availab le,
but as it isn’t, they just make do. I’m hoping that Jon
will add this function sometime in the near future.

Once again, thanks to everyone for your assistance.

Paul Davis


This email has been checked for
viruses by Avast antivirus software.
www.avast.com




This email has been checked for viruses by Avast antivirus software.

www.avast.com

15

Holy cow Huw. Thanks for that bit of information. Here’s me thinking it’s a database and easy to manipulate the data (and I’m in no way a database expert), so using the info you gave me I opened the .blw file with a text editor (notepad did the job) and was able to see the information contained in the blw file. I could even “decode” the info in the file and follow where and how it is stored.

I can see the reasoning behind keeping it simple and self contained (i.e. cost), but I’m also aware that using a database allows the software to do so much more. Of course, I can also see the problems associated with that, such as additional costs. Would I be prepared to pay a nominal annual fee to use the software, damn right I would. How much would I be willing to pay? Well, I’m a tight-arse, and I don’t like parting with my money. But I think that 50 UK pounds would be a very, very cheap annual subscription, and most users would not hesitate to pay this if the product was upgraded. Multiply that by the number of users and the software could even show a bit of profit.

My 2 cents worth.

Paul Davis

—In sailwave@yahoogroups.com, <huw.pearce@…> wrote :

Hi Paul,

Just a small point Sailwave stores all the competitor and race data
in a text file similar in concept to XML or JSON not a database like
MS SQL Server, MySQL, SQLlite, Oracle.

It stores the the raw competitor and race data which is then
manipulated by the Sailwave application when publishing information.

There are a few people who have worked out the Sailwave.BLW file
structure and extract the information into a database. It has been
discussed at various times over the years to provide a
facility/mechanism to write the Sailwave data into a database.

It is possible when you know Sailwave data structure very well, to
automate reading from the Sailwave.BLW file manipulate the data in
some way and then write back the updated information. Jon has done
this with the RYA NHC rating calculation in external mode by passing
the data to Excel spreadsheet where a rating for the next race is
calculated and then written back to Sailwave.BLW file. Note - this
only works using Excel and under a Microsoft operating system
environment.

Kind regards,

Huw

···

On 03/12/2014 08:35, pgdavis123456@… [sailwave] wrote:

Thanks everyone for your assistance with this problem.
What I was trying to achieve was to score a division
within the main group, which the software does easily and
there are many ways to configure the software to do this.
However, when publishing individual races, the “Place”
column prints finishes with respect to their finish within
the main fleet. So if the main fleet has 33 competitors,
and the division (Youth) has only 6 competitors, I wanted
the “Place” to be the place within that division (i.e.
1,2,3,4,5,DNF) NOT
their place in the whole fleet (i.e. 2,8,15,25,26,DNF).

The software scores the positions correctly both for
individual races and for series scores, and calculates the
dropped races correctly.In fact it does everything
correctly when scoring by divisions/fleet/anything, and
what I’m after is just a “neatness” thing. If I publish
resul ts for a race scored by division containing a subset
of 6 Youth boats, I don’t want the youth competitors to be
asking how they could get a place of 15th, 25th or 26th in
a division of only 6 boats.

I’ve had a lengthy discussion with Jon, and apparently
because their finish positions are entered with respect to
the whole fleet, the software remembers and uses this
finish position for the divisions, so at this stage I
cannot publish their finish “Place” with respect to their
division only. As I said, it’s a “neatness” problem rather
than a scoring problem, because the scored results are all
calculated correctly.

As it’s using a database, the software could certainly
calculate their new “Place” within the division so it
shows 1,2,3,4,5,DNF, but at the moment no one has asked
for that functionality. Personally, I think that like me,
many people would use that option if it was availab le,
but as it isn’t, they just make do. I’m hoping that Jon
will add this function sometime in the near future.

Once again, thanks to everyone for your assistance.

Paul Davis


This email has been checked for
viruses by Avast antivirus software.
www.avast.com




This email has been checked for viruses by Avast antivirus software.

www.avast.com

16

Hi Paul,

Pleased to have been illuminating ;-)

As there are people using Sailwave on Macs under OSX (using Paralles

or Wine) and on various Linux distributions (using WINE) choice of
database becomes a bit more complicated. However, when discussions
between Jon & I have occurred, the thoughts were around using
SQLlite which quoting from their website

  •                SQLite is a software library that

implements a**self-contained** ,serverless ,zero-configuration ,transactional SQL database engine.
SQLite is the* most
widely deployed* SQL database engine in the world.
The source code for SQLite is in the** public
domain**.*

There have been requests for a competitor 'database' so it would be

easy when creating a new series to populate Sailwave with the
competitors who were going to take part in that event. Although it
is possible and quite easy to create a master Sailwave.BLW file
containing all the likely competitors and make a copy for each
event. It is easy in Sailwave to mark all competitors excluded and
then when you enter a sail number using Sail Number Wizard the
competitors is ‘untagged’ as excluded.

Another way is use a spreadsheet or database to store all

competitors then select those entering the event and from those
create a CSV which can then be imported into Sailwave. The trick
with importing from a CSV file is the mapping of spreadsheet columns
to Sailwave fields/columns. But if Row 1columns are labelled with
the Sailwave field names the mapping is automatic and makes it very
easy.

All the best with your use of Sailwave.

Kind regards,

Huw
···

On 03/12/2014 13:25,
[sailwave] wrote:

pgdavis123456@yahoo.com.au

          Holy cow Huw. Thanks for that bit of information. Here's

me thinking it’s a database and easy to manipulate the
data (and I’m in no way a database expert), so using the
info you gave me I opened the .blw file with a text editor
(notepad did the job) and was able to see the information
contained in the blw file. I could even “decode” the info
in the file and follow where and how it is stored.

          I can see the reasoning behind keeping it simple and

self contained (i.e. cost), but I’m also aware that using
a database allows the software to do so much more. Of
course, I can also see the problems associated with that,
such as additional costs. Would I be prepared to pay a
nominal annual fee to use the software, damn right I
would. How much would I be willing to pay? Well, I’m a
tight-arse, and I don’t like parting with my money. But I
think that 50 UK pounds would be a very, very cheap annual
subscription, and most u sers would not hesitate to pay
this if the product was upgraded. Multiply that by the
number of users and the software could even show a bit of
profit.

My 2 cents worth.

Paul Davis

            ---In , wrote :


This email has been checked for
viruses by Avast antivirus software.
www.avast.com




This email has been checked for viruses by Avast antivirus software.

www.avast.com

sailwave@yahoogroups.com<huw.pearce@…>

Hi Paul,

              Just a small point Sailwave stores all the competitor

and race data
in a text file similar in concept to XML or JSON not a
database like
MS SQL Server, MySQL, SQLlite, Oracle.

              It stores the the raw competitor and race data which

is then
manipulated by the Sailwave application when
publishing information.

              There are a few people who have worked out the

Sailwave.BLW file
structure and extract the information into a database.
It has been
discussed at various times over the years to provide a
facility/mechanism to write the Sailwave data into a
database.

              It is possible when you know Sailwave data structure

very well, to
automate reading from the Sailwave.BLW file
manipulate the data in
some way and then write back the updated information.
Jon has done
this with the RYA NHC rating calculation in external
mode by passing
the data to Excel spreadsheet where a rating for the
next race is
calculated and then written back to Sailwave.BLW file.
Note - this
only works using Excel and under a Microsoft operating
system
environment.

              Kind regards,

              Huw

                On

03/12/2014 08:35,
pgdavis123456@…
[sailwave] wrote:

                        Thanks everyone for your assistance with

this problem.
What I was trying to achieve was to score a
division
within the main group, which the software
does easily and
there are many ways to configure the
software to do this.
However, when publishing individual races,
the “Place”
column prints finishes with respect to their
finish within
the main fleet. So if the main fleet has 33
competitors,
and the division (Youth) has only 6
competitors, I wanted
the “Place” to be the place within that
division (i.e.
1,2,3,4,5,DNF) NOT
their place in the whole fleet (i.e.
2,8,15,25,26,DNF).

                        The software scores the positions

correctly both for
individual races and for series scores, and
calculates the
dropped races correctly.In fact it does
everything
correctly when scoring by
divisions/fleet/anything, and
what I’m after is just a “neatness” thing.
If I publish
resul ts for a race scored by division
containing a subset
of 6 Youth boats, I don’t want the youth
competitors to be
asking how they could get a place of 15th,
25th or 26th in
a division of only 6 boats.

                        I've had a lengthy discussion with Jon,

and apparently
because their finish positions are entered
with respect to
the whole fleet, the software remembers and
uses this
finish position for the divisions, so at
this stage I
cannot publish their finish “Place” with
respect to their
division only. As I said, it’s a “neatness”
problem rather
than a scoring problem, because the scored
results are all
calculated correctly.

                        As it's using a database, the software

could certainly
calculate their new “Place” within the
division so it
shows 1,2,3,4,5,DNF, but at the moment no
one has asked
for that functionality. Personally, I think
that like me,
many people would use that option if it was
availab le,
but as it isn’t, they just make do. I’m
hoping that Jon
will add this function sometime in the near
future.

                        Once again, thanks to everyone for your

assistance.

Paul Davis


This email has been checked for
viruses by Avast antivirus software.
www.avast.com




This email has been checked for viruses
by Avast antivirus software.

                            [www.avast.com](http://www.avast.com/)