Calculation of Average points

Our Sailing Instructions are written with the following scoring for OOD:

"If a skipper assists in running a race then his placement for that race in the series will be the average of his points for all the other races in that series, after throw-outs, round to the nearest whole number (e.g. 4.5=5). "

We need to retain 1 decimal place for other averages (RDG or tied places).

Is there a way of implementing this calculation of OOD in Sailwave?

Go to the “scoring codes” section of the Scoring System tab and add a new classification OOD and set it up with an RDGa definition. Make sure you have the 1 in the box in the race scoring page that is on the right side which will give you the . It should work fine. I set up a SWF (Sailed Without Finishing) code for boats that did not finish 30 minutes after other boats had finished and defined it as a DNF but with 2 points worse than the score of the last boat that did finish. It works fine. See if this won’t work for you.

Bob Winter

···

On Sep 27, 2013, at 6:34 PM, wilkinson.gordon@gmail.com wrote:

Our Sailing Instructions are written with the following scoring for OOD:

"If a skipper assists in running a race then his placement for that race in the series will be the average of his points for all the other races in that series, after throw-outs, round to the nearest whole number (e.g. 4.5=5). "

We need to retain 1 decimal place for other averages (RDG or tied places).

Is there a way of implementing this calculation of OOD in Sailwave?

The proposed solution doesn't work in 2.8.5.

It takes the race scores, comes up with an average rounded to the number
of decimal places specified and then adds 1. What the original poster
wants is the race average rounded to the nearest whole number instead of
rounded to the nearest tenth (or whatever is specified as precision for
the scoring system).

The way Sailwave works, you specify the number of decimal places for
race scores. Typically, this would be NO decimal places for the default
low point system as all places are whole numbers. BUT, Sailwave uses the
same precision for both race scores AND tied points (and maybe redress).
This isn't what the rulebook provides (it says to add the points
together and divide by two with the result that when two boats tie an
additional decimal place is virtually always required for the tied
boats). However, you can work around this by increasing the race scores
to one decimal place (not necessary for the Low Point System) and then
tied points will be rounded to one decimal place (resulting in one
additional decimal place more than the Low Point System uses). This
isn't really what the rulebook wants when three boats are tied but is
undoubtedly good enough as three-boat ties are rare and the difference
will rarely, if ever, be important.

You can specify a formula for race scores and use ROUND in your formula.
However, you cannot specify a formula for determining the scores
associated with the scoring codes. If you could, this would be an easy
way to get what the original poster wants.

Probably the best way to implement your SIs is to use the average with
one decimal place until the last race and then put in the correct number
by hand. This will rarely make a difference in the series results but
might require a note of explanation as until the last race the points
shown will be "wrong" by a very small amount. You can put the note into
your "results.htm" template and it will automatically show on every page.

Art

···

On 9/27/2013 5:53 PM, Winter Robert wrote:

Go to the "scoring codes" section of the Scoring System tab and add a new classification OOD and set it up with an RDGa definition. Make sure you have the 1 in the box in the race scoring page that is on the right side which will give you the . It should work fine. I set up a SWF (Sailed Without Finishing) code for boats that did not finish 30 minutes after other boats had finished and defined it as a DNF but with 2 points worse than the score of the last boat that did finish. It works fine. See if this won't work for you.

Bob Winter
On Sep 27, 2013, at 6:34 PM, <wilkinson.gordon@gmail.com> wrote:

Our Sailing Instructions are written with the following scoring for OOD:

"If a skipper assists in running a race then his placement for that race in the series will be the average of his points for all the other races in that series, after throw-outs, round to the nearest whole number (e.g. 4.5=5). "

We need to retain 1 decimal place for other averages (RDG or tied places).

Is there a way of implementing this calculation of OOD in Sailwave?

Thanks for the suggestion.

RDGa is calculated as Average of (sum of points for all races) + N points

The calculation is done using the number of decimal places set on the Race Scoring tab. With a 1 set there, all calculations are done to 1 decimal place.

What we need to do to satisfy our Sailing Instruction is to do this calculation to 0 decimal place (round to the nearest integer) for the OOD score, but still do 1 decimal place for other calculations such as tied places.

Go to the “scoring codes” section of the Scoring System tab and add a new classification OOD and set it up with an RDGa definition. Make sure you have the 1 in the box in the race scoring page that is on the right side which will give you the . It should work fine. I set up a SWF (Sailed Without Finishing) code for boats that did not finish 30 minutes after other boats had finished and defined it as a DNF but with 2 points worse than the score of the last boat that did finish. It works fine. See if this won’t work for you.

Bob Winter

···

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

On Sep 27, 2013, at 6:34 PM, <wilkinson.gordon@…> wrote:

Our Sailing Instructions are written with the following scoring for OOD:

"If a skipper assists in running a race then his placement for that race in the series will be the average of his points for all the other races in that series, after throw-outs, round to the nearest whole number (e.g. 4.5=5). "

We need to retain 1 decimal place for other averages (RDG or tied places).

Is there a way of implementing this calculation of OOD in Sailwave?

Art - thank you for confirming my suspicion that:there is no way of doing what we want using the available methods in Sailwave. The workaround you suggest would work, but requires the scorekeeper to go back and review all the races and change the code and the scores at the end of a series. Not a very good solution as it requires time and is subject to error.

Is there any possibility that a user defined formula could be made a feature of Sailwave? Or that additional formulas that do integer rounding for Average scores be added to the list of available formulae?

Thanks for the suggestion.

RDGa is calculated as Average of (sum of points for all races) + N points

The calculation is done using the number of decimal places set on the Race Scoring tab. With a 1 set there, all calculations are done to 1 decimal place.

What we need to do to satisfy our Sailing Instruction is to do this calculation to 0 decimal place (round to the nearest integer) for the OOD score, but still do 1 decimal place for other calculations such as tied places.

Go to the “scoring codes” section of the Scoring System tab and add a new classification OOD and set it up with an RDGa definition. Make sure you have the 1 in the box in the race scoring page that is on the right side which will give you the . It should work fine. I set up a SWF (Sailed Without Finishing) code for boats that did not finish 30 minutes after other boats had finished and defined it as a DNF but with 2 points worse than the score of the last boat that did finish. It works fine. See if this won’t work for you.

Bob Winter

···

—In sailwave@yahoogroups.com, <wilkinson.gordon@…> wrote:
—In sailwave@yahoogroups.com, <winteronlg@…> wrote:

On Sep 27, 2013, at 6:34 PM, <wilkinson.gordon@…> wrote:

Our Sailing Instructions are written with the following scoring for OOD:

"If a skipper assists in running a race then his placement for that race in the series will be the average of his points for all the other races in that series, after throw-outs, round to the nearest whole number (e.g. 4.5=5). "

We need to retain 1 decimal place for other averages (RDG or tied places).

Is there a way of implementing this calculation of OOD in Sailwave?

You can use "round" in a custom formula now. See here:

http://www.sailwave.com/expression

So, all that would be needed is to allow the use of custom formulae for
scoring codes as well as for scoring systems. As a practical matter, one
is probably never going to be able to think of all the various ways that
someone might want to score so having the ability to use a custom
formula makes some sense.

Art

···

On 9/27/2013 7:19 PM, wilkinson.gordon@gmail.com wrote:

Art - thank you for confirming my suspicion that:there is no way of doing what
we want using the available methods in Sailwave. The workaround you suggest
would work, but requires the scorekeeper to go back and review all the races and
change the code and the scores at the end of a series. Not a very good solution
as it requires time and is subject to error.

Is there any possibility that a user defined formula could be made a feature of
Sailwave? Or that additional formulas that do integer rounding for Average
scores be added to the list of available formulae?

---In sailwave@yahoogroups.com, <wilkinson.gordon@...> wrote:

Thanks for the suggestion.

RDGa is calculated as Average of (sum of points for all races) + N points

The calculation is done using the number of decimal places set on the Race
Scoring tab. With a 1 set there, all calculations are done to 1 decimal place.

What we need to do to satisfy our Sailing Instruction is to do this calculation
to 0 decimal place (round to the nearest integer) for the OOD score, but still
do 1 decimal place for other calculations such as tied places.

---In sailwave@yahoogroups.com, <winteronlg@...> wrote:

Go to the "scoring codes" section of the Scoring System tab and add a new
classification OOD and set it up with an RDGa definition. Make sure you have the
1 in the box in the race scoring page that is on the right side which will give
you the . It should work fine. I set up a SWF (Sailed Without Finishing) code
for boats that did not finish 30 minutes after other boats had finished and
defined it as a DNF but with 2 points worse than the score of the last boat that
did finish. It works fine. See if this won't work for you.

Bob Winter
On Sep 27, 2013, at 6:34 PM, <wilkinson.gordon@… > <mailto:wilkinson.gordon@…>> wrote:

        Our Sailing Instructions are written with the following scoring for OOD:

        "If a skipper assists in running a race then his placement for that
        race in the series will be the average of his points for all the other
        races in that series, after throw-outs, round to the nearest whole
        number (e.g. 4.5=5). "

        We need to retain 1 decimal place for other averages (RDG or tied places).

        Is there a way of implementing this calculation of OOD in Sailwave?

Agreed. So how does one make a suggestion that this be included in a future release?

You can use “round” in a custom formula now. See here:

http://www.sailwave.com/expression

So, all that would be needed is to allow the use of custom formulae for

scoring codes as well as for scoring systems. As a practical matter, one

is probably never going to be able to think of all the various ways that

someone might want to score so having the ability to use a custom

formula makes some sense.

Art

···

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

On 9/27/2013 7:19 PM, wilkinson.gordon@… wrote:

Art - thank you for confirming my suspicion that:there is no way of doing what

we want using the available methods in Sailwave. The workaround you suggest

would work, but requires the scorekeeper to go back and review all the races and

change the code and the scores at the end of a series. Not a very good solution

as it requires time and is subject to error.

Is there any possibility that a user defined formula could be made a feature of

Sailwave? Or that additional formulas that do integer rounding for Average

scores be added to the list of available formulae?

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

Thanks for the suggestion.

RDGa is calculated as Average of (sum of points for all races) + N points

The calculation is done using the number of decimal places set on the Race

Scoring tab. With a 1 set there, all calculations are done to 1 decimal place.

What we need to do to satisfy our Sailing Instruction is to do this calculation

to 0 decimal place (round to the nearest integer) for the OOD score, but still

do 1 decimal place for other calculations such as tied places.

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

Go to the “scoring codes” section of the Scoring System tab and add a new

classification OOD and set it up with an RDGa definition. Make sure you have the

1 in the box in the race scoring page that is on the right side which will give

you the . It should work fine. I set up a SWF (Sailed Without Finishing) code

for boats that did not finish 30 minutes after other boats had finished and

defined it as a DNF but with 2 points worse than the score of the last boat that

did finish. It works fine. See if this won’t work for you.

Bob Winter

On Sep 27, 2013, at 6:34 PM, <wilkinson.gordon@… > > > mailto:wilkinson.gordon@...> wrote:

Our Sailing Instructions are written with the following scoring for OOD:

"If a skipper assists in running a race then his placement for that

race in the series will be the average of his points for all the other

races in that series, after throw-outs, round to the nearest whole

number (e.g. 4.5=5). "

We need to retain 1 decimal place for other averages (RDG or tied places).

Is there a way of implementing this calculation of OOD in Sailwave?