Sailwave scoring system

Imported from Yahoo
1

Hej er der jer der har efterlyst et alternativt scoring system til sailwave

Så kunne jeg godt tænke mig at komme i kontakt med jer

Kh Finn E. 61280962 medlem af Åbenrå sejlklub

2

Hi Finn,

  I would like to be able to help you, but my Danish is

non-existent. If you could post in English I may be able to help
you.

  There are other scoring software applications and I have used

several over the years, but I have stuck with Sailwave.

Kind regards,

Huw

···

On 29/10/2017 09:59, Finn Ehmsen
[sailwave] wrote:

f.ehmsen@tdcadsl.dk

          Hej er der jer der har efterlyst et alternativt scoring

system til sailwave

          Så kunne jeg godt tænke mig at komme i kontakt med jer

          Kh Finn E. 61280962 medlem af Åbenrå sejlklub


Virus-free. www.avast.com

3

hello I thought I had sent this mail to it-support@kerteminde-sejlklub.dk
This was why that email in Danish.

but equally I’m looking for a scoring system that after a season make a new handicap number for each boat.

I have made a #program in Excel #. It works, but you should guess the new handicap so it takes some time. the prerequisite is that they both have a better handicap number must have at least participated in more than 12 out of 16 sailings. we sail with reverse respite ie all of them have different start times and they should reach goals simultaneously. When after a season it is expected that a boat will sail 9 seconds faster than last year, the adjustment will only be 9/3 = 3, because the handicap will not get the numbers to jump back and forth. This system takes into account the crew abilities and the nature of the boat as well as the wind Low in the evening (we sail from 6:30 pm to finish between 2 to 8 miles

with best regards Finn from Denmark

sorry have used google translat

···

On 29/10/2017 09:59, Finn Ehmsen [sailwave] wrote:

f.ehmsen@tdcadsl.dk

Hej er der jer der har efterlyst et alternativt scoring system til sailwave

Så kunne jeg godt tænke mig at komme i kontakt med jer

Kh Finn E. 61280962 medlem af Åbenrå sejlklub


Virus-free. www.avast.com

4

Hi Finn,

Thank you for your update.

  Sailwave has built-in functionality to use an external Microsoft

Excel spreadsheet to do rating/handicap adjustments. This
functionality was included to support the RYA NHC rating system
which is a progressive handicap system. Sailwave includes the
Excel spreadsheet template to do the calculations in what is
called external mode. It is possible to use a different
spreadsheet which has a different algorithm for calculating a
rating and I am aware of a few Sailwave users who have done this.

  As you have already created an Excel spreadsheet to do the rating

calculations using your algorithm then it should be possible to
use it with Sailwave once the appropriate changes are made to your
Excel spreadsheet, so Sailwave and your Excel spreadsheet can
exchange data automatically.

  I hope you find this information useful and Google translate to

Danish makes it understandable.

Kind regards,

Huw

···

On 29/10/2017 11:08, Finn Ehmsen
[sailwave] wrote:

f.ehmsen@tdcadsl.dk

hello I thought I had sent this mail to it-support@kerteminde-sejlklub.dk

This was why that email in Danish.

             but equally I'm looking for a scoring system

that after a season make a new handicap number for each
boat.

            I have made a #program in Excel #. It works, but

you should guess the new handicap so it takes some
time. the prerequisite is that they both have a better
handicap number must have at least participated in more
than 12 out of 16 sailings. we sail with reverse respite
ie all of them have different start times and they
should reach goals simultaneously. When after a season
it is expected that a boat will sail 9 seconds faster
than last year, the adjustment will only be 9/3 = 3,
because the handicap will not get the numbers to jump
back and forth. This system takes into account the crew
abilities and the nature of the boat as well as the wind
Low in the evening (we sail from 6:30 pm to finish
between 2 to 8 miles

with best regards Finn from Denmark

sorry have used google translat

                                Den 29. okt. 2017 kl.

11.15 skrev Huw Pearce huw.pearce@bcs.org.uk
[sailwave] sailwave@yahoogroups.com:

Hi Finn,

                        I would like to be

able to help you, but my Danish is
non-existent. If you could post in English I
may be able to help you.

                        There are other

scoring software applications and I have
used several over the years, but I have
stuck with Sailwave.

Kind regards,

Huw

                        On

29/10/2017 09:59, Finn Ehmsen [sailwave]
wrote:

f.ehmsen@tdcadsl.dk

                            Hej er der jer

der har efterlyst et alternativt scoring
system til sailwave

                            Så kunne jeg godt tænke mig at komme i

kontakt med jer

                            Kh Finn E. 61280962 medlem af Åbenrå

sejlklub


Virus-free. www.avast.com

5

Thanks I can read it and talk a bit but it is hard for me to Spell it. Where is the Button for Excel ?

Kind regards

Finn

···

Den 29. okt. 2017 kl. 12.21 skrev Huw Pearce huw.pearce@bcs.org.uk [sailwave] sailwave@yahoogroups.com:

Hi Finn,

Thank you for your update.

  Sailwave has built-in functionality to use an external Microsoft

Excel spreadsheet to do rating/handicap adjustments. This
functionality was included to support the RYA NHC rating system
which is a progressive handicap system. Sailwave includes the
Excel spreadsheet template to do the calculations in what is
called external mode. It is possible to use a different
spreadsheet which has a different algorithm for calculating a
rating and I am aware of a few Sailwave users who have done this.

  As you have already created an Excel spreadsheet to do the rating

calculations using your algorithm then it should be possible to
use it with Sailwave once the appropriate changes are made to your
Excel spreadsheet, so Sailwave and your Excel spreadsheet can
exchange data automatically.

  I hope you find this information useful and Google translate to

Danish makes it understandable.

Kind regards,

Huw

  On 29/10/2017 11:08, Finn Ehmsen

f.ehmsen@tdcadsl.dk [sailwave] wrote:

hello I thought I had sent this mail to it-support@kerteminde-sejlklub.dk

This was why that email in Danish.

             but equally I'm looking for a scoring system

that after a season make a new handicap number for each
boat.

            I have made a #program in Excel #. It works, but

you should guess the new handicap so it takes some
time. the prerequisite is that they both have a better
handicap number must have at least participated in more
than 12 out of 16 sailings. we sail with reverse respite
ie all of them have different start times and they
should reach goals simultaneously. When after a season
it is expected that a boat will sail 9 seconds faster
than last year, the adjustment will only be 9/3 = 3,
because the handicap will not get the numbers to jump
back and forth. This system takes into account the crew
abilities and the nature of the boat as well as the wind
Low in the evening (we sail from 6:30 pm to finish
between 2 to 8 miles

with best regards Finn from Denmark

sorry have used google translat

                                Den 29. okt. 2017 kl.

11.15 skrev Huw Pearce huw.pearce@bcs.org.uk
[sailwave] sailwave@yahoogroups.com:

Hi Finn,

                        I would like to be

able to help you, but my Danish is
non-existent. If you could post in English I
may be able to help you.

                        There are other

scoring software applications and I have
used several over the years, but I have
stuck with Sailwave.

Kind regards,

Huw

                        On

29/10/2017 09:59, Finn Ehmsen f.ehmsen@tdcadsl.dk [sailwave]
wrote:

                            Hej er der jer

der har efterlyst et alternativt scoring
system til sailwave

                            Så kunne jeg godt tænke mig at komme i

kontakt med jer

                            Kh Finn E. 61280962 medlem af Åbenrå

sejlklub


Virus-free. www.avast.com

6

Hi Finn,

  Understand about spelling; we learn to speak quite a bit before

we learn to spell. However, I am sure that your command of spoken
& written English is far better than mine of Danish.

  There is no Excel button the toolbar or in the menu options. To

use an external spreadsheet you have created you need to open
scoring options and select the Rating tab. Near the bottom of the
window is a check box alongside the word Excel, click the check
box and an entry box opens in which you can add your external
Excel template file name.

  You need to understand the format of Excel file and data

exchange. You need to look at the NHC Excel template file to
understand how you need to set-up your Excel template so the data
is exchanged correctly between Sailwave & Excel.

  I have never needed to use this functionality, just know it

exists. Jon the person who implemented the Sailwave Excel link
functionality will be able to help you more than I can. Jon has
been in Spain scoring the Techno Worlds and is travelling back
today/tomorrow. He might be busy Monday & Tuesday catching up
with real work matters, so could be day or so before he sees this
message thread.

Kind regards,

Huw

···

On 29/10/2017 13:12, Finn Ehmsen
[sailwave] wrote:

f.ehmsen@tdcadsl.dk

          Thanks I can read it and talk a bit  but it is hard for

me to Spell it. Where is the Button for Excel ?

          Kind regards

Finn

          Den 29. okt. 2017 kl. 12.21 skrev Huw Pearce huw.pearce@bcs.org.uk
          [sailwave] <sailwave@yahoogroups.com>:

Hi Finn,

Thank you for your update.

                Sailwave has built-in functionality to use an

external Microsoft Excel spreadsheet to do
rating/handicap adjustments. This functionality was
included to support the RYA NHC rating system which
is a progressive handicap system. Sailwave includes
the Excel spreadsheet template to do the
calculations in what is called external mode. It is
possible to use a different spreadsheet which has a
different algorithm for calculating a rating and I
am aware of a few Sailwave users who have done this.

                As you have already created an Excel spreadsheet to

do the rating calculations using your algorithm then
it should be possible to use it with Sailwave once
the appropriate changes are made to your Excel
spreadsheet, so Sailwave and your Excel spreadsheet
can exchange data automatically.

                I hope you find this information useful and Google

translate to Danish makes it understandable.

Kind regards,

Huw

                On 29/10/2017 11:08, Finn

Ehmsen [sailwave] wrote:

f.ehmsen@tdcadsl.dk

hello I thought I had sent this mail to it-support@kerteminde-sejlklub.dk

This was why that email in Danish.

                       but equally I'm looking for a scoring

system that after a season make a new handicap
number for each boat.

                      I have made a #program in Excel #. It

works, but you should guess the new handicap
so it takes some time. the prerequisite is
that they both have a better handicap number
must have at least participated in more than
12 out of 16 sailings. we sail with reverse
respite ie all of them have different start
times and they should reach goals
simultaneously. When after a season it is
expected that a boat will sail 9 seconds
faster than last year, the adjustment will
only be 9/3 = 3, because the handicap will not
get the numbers to jump back and forth. This
system takes into account the crew abilities
and the nature of the boat as well as the wind
Low in the evening (we sail from 6:30 pm to
finish between 2 to 8 miles

with best regards Finn from
Denmark

sorry have used google translat

                                                    Den 29.

okt. 2017 kl. 11.15 skrev Huw Pearce huw.pearce@bcs.org.uk
[sailwave] sailwave@yahoogroups.com:

Hi Finn,

                                  I would

like to be able to help you, but
my Danish is non-existent. If you
could post in English I may be
able to help you.

                                  There are

other scoring software
applications and I have used
several over the years, but I have
stuck with Sailwave.

                                  Kind

regards,

Huw

                                  On 29/10/2017

09:59, Finn Ehmsen [sailwave]
wrote:

f.ehmsen@tdcadsl.dk

                                      Hej

er der jer der har efterlyst
et alternativt scoring system
til sailwave

                                      Så kunne jeg godt tænke mig at

komme i kontakt med jer

                                      Kh Finn E. 61280962 medlem af

Åbenrå sejlklub


Virus-free. www.avast.com

7

Hi Hwu. Thank you very much for the answers I am very honored about

I can’t Get Excel to start ?

and another question I have:
is it possible to make a code that can give the value = number completed both + round top ((not completed both) / 2) +1
Kind regards Finn E.

···

On 29/10/2017 13:12, Finn Ehmsen
[sailwave] wrote:

f.ehmsen@tdcadsl.dk

          Thanks I can read it and talk a bit  but it is hard for

me to Spell it. Where is the Button for Excel ?

          Kind regards

Finn

          Den 29. okt. 2017 kl. 12.21 skrev Huw Pearce huw.pearce@bcs.org.uk
          [sailwave] <sailwave@yahoogroups.com>:

Hi Finn,

Thank you for your update.

                Sailwave has built-in functionality to use an

external Microsoft Excel spreadsheet to do
rating/handicap adjustments. This functionality was
included to support the RYA NHC rating system which
is a progressive handicap system. Sailwave includes
the Excel spreadsheet template to do the
calculations in what is called external mode. It is
possible to use a different spreadsheet which has a
different algorithm for calculating a rating and I
am aware of a few Sailwave users who have done this.

                As you have already created an Excel spreadsheet to

do the rating calculations using your algorithm then
it should be possible to use it with Sailwave once
the appropriate changes are made to your Excel
spreadsheet, so Sailwave and your Excel spreadsheet
can exchange data automatically.

                I hope you find this information useful and Google

translate to Danish makes it understandable.

Kind regards,

Huw

                On 29/10/2017 11:08, Finn

Ehmsen [sailwave] wrote:

f.ehmsen@tdcadsl.dk

hello I thought I had sent this mail to it-support@kerteminde-sejlklub.dk

This was why that email in Danish.

                       but equally I'm looking for a scoring

system that after a season make a new handicap
number for each boat.

                      I have made a #program in Excel #. It

works, but you should guess the new handicap
so it takes some time. the prerequisite is
that they both have a better handicap number
must have at least participated in more than
12 out of 16 sailings. we sail with reverse
respite ie all of them have different start
times and they should reach goals
simultaneously. When after a season it is
expected that a boat will sail 9 seconds
faster than last year, the adjustment will
only be 9/3 = 3, because the handicap will not
get the numbers to jump back and forth. This
system takes into account the crew abilities
and the nature of the boat as well as the wind
Low in the evening (we sail from 6:30 pm to
finish between 2 to 8 miles

with best regards Finn from
Denmark

sorry have used google translat

                                                    Den 29.

okt. 2017 kl. 11.15 skrev Huw Pearce huw.pearce@bcs.org.uk
[sailwave] sailwave@yahoogroups.com:

Hi Finn,

                                  I would

like to be able to help you, but
my Danish is non-existent. If you
could post in English I may be
able to help you.

                                  There are

other scoring software
applications and I have used
several over the years, but I have
stuck with Sailwave.

                                  Kind

regards,

Huw

                                  On 29/10/2017

09:59, Finn Ehmsen [sailwave]
wrote:

f.ehmsen@tdcadsl.dk

                                      Hej

er der jer der har efterlyst
et alternativt scoring system
til sailwave

                                      Så kunne jeg godt tænke mig at

komme i kontakt med jer

                                      Kh Finn E. 61280962 medlem af

Åbenrå sejlklub


Virus-free. www.avast.com

8

Hi Finn,

You best approach is to use the NHC example included with Sailwave then switch it to external mode and it will use excel to do the calculation. Once you have this working you can modify the template to do the calculations that you require.

Jon

···

Jon Eskdale

03333 443377

07530 112233

9

Hi Jon, I can not get Excel to start and I do not know what I’m doing wrong

udklip1.png

udklip2.png

Kh Finn E.

···

Den 30. okt. 2017 kl. 22.46 skrev Jon Eskdale jon@sailwave.com [sailwave] sailwave@yahoogroups.com:

Hi Finn,

You best approach is to use the NHC example included with Sailwave then switch it to external mode and it will use excel to do the calculation. Once you have this working you can modify the template to do the calculations that you require.

Jon

On Mon, 30 Oct 2017 at 21:38, Finn Ehmsen f.ehmsen@tdcadsl.dk [sailwave] sailwave@yahoogroups.com wrote:

Hi Hwu. Thank you very much for the answers I am very honored about

I can’t Get Excel to start ?

and another question I have:
is it possible to make a code that can give the value = number completed both + round top ((not completed both) / 2) +1
Kind regards Finn E.

Den 29. okt. 2017 kl. 15.13 skrev Huw Pearce huw.pearce@bcs.org.uk [sailwave] sailwave@yahoogroups.com:

Hi Finn,

  Understand about spelling; we learn to speak quite a bit before

we learn to spell. However, I am sure that your command of spoken
& written English is far better than mine of Danish.

  There is no Excel button the toolbar or in the menu options. To

use an external spreadsheet you have created you need to open
scoring options and select the Rating tab. Near the bottom of the
window is a check box alongside the word Excel, click the check
box and an entry box opens in which you can add your external
Excel template file name.

  You need to understand the format of Excel file and data

exchange. You need to look at the NHC Excel template file to
understand how you need to set-up your Excel template so the data
is exchanged correctly between Sailwave & Excel.

  I have never needed to use this functionality, just know it

exists. Jon the person who implemented the Sailwave Excel link
functionality will be able to help you more than I can. Jon has
been in Spain scoring the Techno Worlds and is travelling back
today/tomorrow. He might be busy Monday & Tuesday catching up
with real work matters, so could be day or so before he sees this
message thread.

Kind regards,

Huw

  On 29/10/2017 13:12, Finn Ehmsen

f.ehmsen@tdcadsl.dk [sailwave] wrote:

          Thanks I can read it and talk a bit  but it is hard for

me to Spell it. Where is the Button for Excel ?

          Kind regards

Finn

          Den 29. okt. 2017 kl. 12.21 skrev Huw Pearce huw.pearce@bcs.org.uk
          [sailwave] <sailwave@yahoogroups.com>:

Hi Finn,

Thank you for your update.

                Sailwave has built-in functionality to use an

external Microsoft Excel spreadsheet to do
rating/handicap adjustments. This functionality was
included to support the RYA NHC rating system which
is a progressive handicap system. Sailwave includes
the Excel spreadsheet template to do the
calculations in what is called external mode. It is
possible to use a different spreadsheet which has a
different algorithm for calculating a rating and I
am aware of a few Sailwave users who have done this.

                As you have already created an Excel spreadsheet to

do the rating calculations using your algorithm then
it should be possible to use it with Sailwave once
the appropriate changes are made to your Excel
spreadsheet, so Sailwave and your Excel spreadsheet
can exchange data automatically.

                I hope you find this information useful and Google

translate to Danish makes it understandable.

Kind regards,

Huw

                On 29/10/2017 11:08, Finn

Ehmsen f.ehmsen@tdcadsl.dk
[sailwave] wrote:

hello I thought I had sent this mail to it-support@kerteminde-sejlklub.dk

This was why that email in Danish.

                       but equally I'm looking for a scoring

system that after a season make a new handicap
number for each boat.

                      I have made a #program in Excel #. It

works, but you should guess the new handicap
so it takes some time. the prerequisite is
that they both have a better handicap number
must have at least participated in more than
12 out of 16 sailings. we sail with reverse
respite ie all of them have different start
times and they should reach goals
simultaneously. When after a season it is
expected that a boat will sail 9 seconds
faster than last year, the adjustment will
only be 9/3 = 3, because the handicap will not
get the numbers to jump back and forth. This
system takes into account the crew abilities
and the nature of the boat as well as the wind
Low in the evening (we sail from 6:30 pm to
finish between 2 to 8 miles

with best regards Finn from
Denmark

sorry have used google translat

                                                    Den 29.

okt. 2017 kl. 11.15 skrev Huw Pearce huw.pearce@bcs.org.uk
[sailwave] sailwave@yahoogroups.com:

Hi Finn,

                                  I would

like to be able to help you, but
my Danish is non-existent. If you
could post in English I may be
able to help you.

                                  There are

other scoring software
applications and I have used
several over the years, but I have
stuck with Sailwave.

                                  Kind

regards,

Huw

                                  On 29/10/2017

09:59, Finn Ehmsen f.ehmsen@tdcadsl.dk [sailwave]
wrote:

                                      Hej

er der jer der har efterlyst
et alternativt scoring system
til sailwave

                                      Så kunne jeg godt tænke mig at

komme i kontakt med jer

                                      Kh Finn E. 61280962 medlem af

Åbenrå sejlklub


Virus-free. www.avast.com

–

Jon Eskdale

03333 443377

07530 112233

10

Hi Finn,

Don’t tick the Excel link box for now.

Using the NHC sample supplied if you score the series you should see SWHelper very briefly be displayed. And the ratings will be calculated - changing for each race.

You can see the ratings for each race by pressing F6 then R.

Now you have NHC working select the External/Debug mode and score the series again. This time it will do it using Excel and you can step through each race one at a time and you will get an idea of how it works.

You can then develop your own template to do the calculations you want - but I would start by modifying the one that Sailwave uses

Regards

Jon

···

On 31 October 2017 at 19:14, Finn Ehmsen f.ehmsen@tdcadsl.dk [sailwave] sailwave@yahoogroups.com wrote:

Hi Jon, I can not get Excel to start and I do not know what I’m doing wrong

Kh Finn E.

Den 30. okt. 2017 kl. 22.46 skrev Jon Eskdale jon@sailwave.com [sailwave] sailwave@yahoogroups.com:

Hi Finn,

You best approach is to use the NHC example included with Sailwave then switch it to external mode and it will use excel to do the calculation. Once you have this working you can modify the template to do the calculations that you require.

Jon

On Mon, 30 Oct 2017 at 21:38, Finn Ehmsen f.ehmsen@tdcadsl.dk [sailwave] sailwave@yahoogroups.com wrote:

Hi Hwu. Thank you very much for the answers I am very honored about

I can’t Get Excel to start ?

and another question I have:
is it possible to make a code that can give the value = number completed both + round top ((not completed both) / 2) +1
Kind regards Finn E.

Den 29. okt. 2017 kl. 15.13 skrev Huw Pearce huw.pearce@bcs.org.uk [sailwave] sailwave@yahoogroups.com:

Hi Finn,

  Understand about spelling; we learn to speak quite a bit before

we learn to spell. However, I am sure that your command of spoken
& written English is far better than mine of Danish.

  There is no Excel button the toolbar or in the menu options. To

use an external spreadsheet you have created you need to open
scoring options and select the Rating tab. Near the bottom of the
window is a check box alongside the word Excel, click the check
box and an entry box opens in which you can add your external
Excel template file name.

  You need to understand the format of Excel file and data

exchange. You need to look at the NHC Excel template file to
understand how you need to set-up your Excel template so the data
is exchanged correctly between Sailwave & Excel.

  I have never needed to use this functionality, just know it

exists. Jon the person who implemented the Sailwave Excel link
functionality will be able to help you more than I can. Jon has
been in Spain scoring the Techno Worlds and is travelling back
today/tomorrow. He might be busy Monday & Tuesday catching up
with real work matters, so could be day or so before he sees this
message thread.

Kind regards,

Huw

  On 29/10/2017 13:12, Finn Ehmsen

f.ehmsen@tdcadsl.dk [sailwave] wrote:

          Thanks I can read it and talk a bit  but it is hard for

me to Spell it. Where is the Button for Excel ?

          Kind regards

Finn

          Den 29. okt. 2017 kl. 12.21 skrev Huw Pearce huw.pearce@bcs.org.uk
          [sailwave] <sailwave@yahoogroups.com>:

Hi Finn,

Thank you for your update.

                Sailwave has built-in functionality to use an

external Microsoft Excel spreadsheet to do
rating/handicap adjustments. This functionality was
included to support the RYA NHC rating system which
is a progressive handicap system. Sailwave includes
the Excel spreadsheet template to do the
calculations in what is called external mode. It is
possible to use a different spreadsheet which has a
different algorithm for calculating a rating and I
am aware of a few Sailwave users who have done this.

                As you have already created an Excel spreadsheet to

do the rating calculations using your algorithm then
it should be possible to use it with Sailwave once
the appropriate changes are made to your Excel
spreadsheet, so Sailwave and your Excel spreadsheet
can exchange data automatically.

                I hope you find this information useful and Google

translate to Danish makes it understandable.

Kind regards,

Huw

                On 29/10/2017 11:08, Finn

Ehmsen f.ehmsen@tdcadsl.dk
[sailwave] wrote:

hello I thought I had sent this mail to it-support@kerteminde-sejlklub.dk

This was why that email in Danish.

                       but equally I'm looking for a scoring

system that after a season make a new handicap
number for each boat.

                      I have made a #program in Excel #. It

works, but you should guess the new handicap
so it takes some time. the prerequisite is
that they both have a better handicap number
must have at least participated in more than
12 out of 16 sailings. we sail with reverse
respite ie all of them have different start
times and they should reach goals
simultaneously. When after a season it is
expected that a boat will sail 9 seconds
faster than last year, the adjustment will
only be 9/3 = 3, because the handicap will not
get the numbers to jump back and forth. This
system takes into account the crew abilities
and the nature of the boat as well as the wind
Low in the evening (we sail from 6:30 pm to
finish between 2 to 8 miles

with best regards Finn from
Denmark

sorry have used google translat

                                                    Den 29.

okt. 2017 kl. 11.15 skrev Huw Pearce huw.pearce@bcs.org.uk
[sailwave] sailwave@yahoogroups.com:

Hi Finn,

                                  I would

like to be able to help you, but
my Danish is non-existent. If you
could post in English I may be
able to help you.

                                  There are

other scoring software
applications and I have used
several over the years, but I have
stuck with Sailwave.

                                  Kind

regards,

Huw

                                  On 29/10/2017

09:59, Finn Ehmsen f.ehmsen@tdcadsl.dk [ sailwave]
wrote:

                                      Hej

er der jer der har efterlyst
et alternativt scoring system
til sailwave

                                      Så kunne jeg godt tænke mig at

komme i kontakt med jer

                                      Kh Finn E. 61280962 medlem af

Åbenrå sejlklub


Virus-free. www.avast.com

–

Jon Eskdale

03333 443377

07530 112233

Jon Eskdale
07530 112233

Skype “eskdale”

11

hi Jon i can not make it work! Excel starts well but here there are some errors and errors

with best regards Finn

----- Original meddelelse -----

···

Jon Eskdale

03333 443377

07530 112233

12

Hi Finn,

I’ve had a look at your file. The main problem seemed to be the default rating you were using had a comma in place of a full stop

0.961538462 was written as 0,961538462

If you change these ratings to use a full stop it does basically work

Did you get it working OK with the example supplied with Sailwave?

Let me know how you get on

Regards

Jon

···

On 13 November 2017 at 19:33, Finn Ehmsen f.ehmsen@tdcadsl.dk [sailwave] sailwave@yahoogroups.com wrote:

hi Jon i can not make it work! Excel starts well but here there are some errors and errors

with best regards Finn

----- Original meddelelse -----

Fra: Jon Eskdale jon@sailwave.com [sailwave] sailwave@yahoogroups.com
Til: sailwave@yahoogroups.com
Dato: Man, 30. okt 2017 22:46
Emne: Re: [sailwave] Sailwave scoring system

Hi Finn,

You best approach is to use the NHC example included with Sailwave then switch it to external mode and it will use excel to do the calculation. Once you have this working you can modify the template to do the calculations that you require.

Jon

On Mon, 30 Oct 2017 at 21:38, Finn Ehmsen f.ehmsen@tdcadsl.dk [sailwave] sailwave@yahoogroups.com wrote:

Hi Hwu. Thank you very much for the answers I am very honored about

I can’t Get Excel to start ?
and another question I have:
is it possible to make a code that can give the value = number completed both + round top ((not completed both) / 2) +1
Kind regards Finn E.

Den 29. okt. 2017 kl. 15.13 skrev Huw Pearce huw.pearce@bcs.org.uk [sailwave] sailwave@yahoogroups.com:

Hi Finn,

Understand about spelling; we learn to speak quite a bit before we learn to spell. However, I am sure that your command of spoken & written English is far better than mine of Danish.

There is no Excel button the toolbar or in the menu options. To use an external spreadsheet you have created you need to open scoring options and select the Rating tab. Near the bottom of the window is a check box alongside the word Excel, click the check box and an entry box opens in which you can add your external Excel template file name.

You need to understand the format of Excel file and data exchange. You need to look at the NHC Excel template file to understand how you need to set-up your Excel template so the data is exchanged correctly between Sailwave & Excel.

I have never needed to use this functionality, just know it exists. Jon the person who implemented the Sailwave Excel link functionality will be able to help you more than I can. Jon has been in Spain scoring the Techno Worlds and is travelling back today/tomorrow. He might be busy Monday & Tuesday catching up with real work matters, so could be day or so before he sees this message thread.

Kind regards,

Huw
On 29/10/2017 13:12, Finn Ehmsen f.ehmsen@tdcadsl.dk [sailwave] wrote:

Thanks I can read it and talk a bit but it is hard for me to Spell it. Where is the Button for Excel ?

Kind regards

Finn

Den 29. okt. 2017 kl. 12.21 skrev Huw Pearce huw.pearce@bcs.org.uk [sailwave] sailwave@yahoogroups.com:

Hi Finn,

Thank you for your update.

Sailwave has built-in functionality to use an external Microsoft Excel spreadsheet to do rating/handicap adjustments. This functionality was included to support the RYA NHC rating system which is a progressive handicap system. Sailwave includes the Excel spreadsheet template to do the calculations in what is called external mode. It is possible to use a different spreadsheet which has a different algorithm for calculating a rating and I am aware of a few Sailwave users who have done this.

As you have already created an Excel spreadsheet to do the rating calculations using your algorithm then it should be possible to use it with Sailwave once the appropriate changes are made to your Excel spreadsheet, so Sailwave and your Excel spreadsheet can exchange data automatically.

I hope you find this information useful and Google translate to Danish makes it understandable.

Kind regards,

Huw
On 29/10/2017 11:08, Finn Ehmsen f.ehmsen@tdcadsl.dk [sailwave] wrote:

hello I thought I had sent this mail to it-support@kerteminde-sejlklub.dk
This was why that email in Danish.

but equally I’m looking for a scoring system that after a season make a new handicap number for each boat.

I have made a #program in Excel #. It works, but you should guess the new handicap so it takes some time. the prerequisite is that they both have a better handicap number must have at least participated in more than 12 out of 16 sailings. we sail with reverse respite ie all of them have different start times and they should reach goals simultaneously. When after a season it is expected that a boat will sail 9 seconds faster than last year, the adjustment will only be 9/3 = 3, because the handicap will not get the numbers to jump back and forth. This system takes into account the crew abilities and the nature of the boat as well as the wind Low in the evening (we sail from 6:30 pm to finish between 2 to 8 miles

with best regards Finn from Denmark

sorry have used google translat

Den 29. okt. 2017 kl. 11.15 skrev Huw Pearce huw.pearce@bcs.org.uk [sailwave] sailwave@yahoogroups.com:

Hi Finn,

I would like to be able to help you, but my Danish is non-existent. If you could post in English I may be able to help you.

There are other scoring software applications and I have used several over the years, but I have stuck with Sailwave.

Kind regards,Huw
On 29/10/2017 09:59, Finn Ehmsen f.ehmsen@tdcadsl.dk [sailwave] wrote:

Hej er der jer der har efterlyst et alternativt scoring system til sailwave

Så kunne jeg godt tænke mig at komme i kontakt med jer

Kh Finn E. 61280962 medlem af Åbenrå sejlklub

alt
Virus-free. www.avast.com

–

Jon Eskdale

03333 443377

07530 112233

Jon Eskdale
07530 112233

Skype “eskdale”

13

Hello Jon
I still have problems, you can see some errors in Excel.
and handicap numbers are very strange going from 0.85 to 1231752 in the same race

Kind regards

Finn Ehmsen

----- Original meddelelse -----

···

On 13 November 2017 at 19:33, Finn Ehmsen f.ehmsen@tdcadsl.dk [sailwave] sailwave@yahoogroups.com wrote:

hi Jon i can not make it work! Excel starts well but here there are some errors and errors

with best regards Finn

----- Original meddelelse -----

Fra: Jon Eskdale jon@sailwave.com [sailwave] sailwave@yahoogroups.com
Til: sailwave@yahoogroups.com
Dato: Man, 30. okt 2017 22:46
Emne: Re: [sailwave] Sailwave scoring system

Hi Finn,

You best approach is to use the NHC example included with Sailwave then switch it to external mode and it will use excel to do the calculation. Once you have this working you can modify the template to do the calculations that you require.

Jon

On Mon, 30 Oct 2017 at 21:38, Finn Ehmsen f.ehmsen@tdcadsl.dk [sailwave] sailwave@yahoogroups.com wrote:

Hi Hwu. Thank you very much for the answers I am very honored about

I can’t Get Excel to start ?
and another question I have:
is it possible to make a code that can give the value = number completed both + round top ((not completed both) / 2) +1
Kind regards Finn E.

Den 29. okt. 2017 kl. 15.13 skrev Huw Pearce huw.pearce@bcs.org.uk [sailwave] sailwave@yahoogroups.com:

Hi Finn,

Understand about spelling; we learn to speak quite a bit before we learn to spell. However, I am sure that your command of spoken & written English is far better than mine of Danish.

There is no Excel button the toolbar or in the menu options. To use an external spreadsheet you have created you need to open scoring options and select the Rating tab. Near the bottom of the window is a check box alongside the word Excel, click the check box and an entry box opens in which you can add your external Excel template file name.

You need to understand the format of Excel file and data exchange. You need to look at the NHC Excel template file to understand how you need to set-up your Excel template so the data is exchanged correctly between Sailwave & Excel.

I have never needed to use this functionality, just know it exists. Jon the person who implemented the Sailwave Excel link functionality will be able to help you more than I can. Jon has been in Spain scoring the Techno Worlds and is travelling back today/tomorrow. He might be busy Monday & Tuesday catching up with real work matters, so could be day or so before he sees this message thread.

Kind regards,

Huw
On 29/10/2017 13:12, Finn Ehmsen f.ehmsen@tdcadsl.dk [sailwave] wrote:

Thanks I can read it and talk a bit but it is hard for me to Spell it. Where is the Button for Excel ?

Kind regards

Finn

Den 29. okt. 2017 kl. 12.21 skrev Huw Pearce huw.pearce@bcs.org.uk [sailwave] sailwave@yahoogroups.com:

Hi Finn,

Thank you for your update.

Sailwave has built-in functionality to use an external Microsoft Excel spreadsheet to do rating/handicap adjustments. This functionality was included to support the RYA NHC rating system which is a progressive handicap system. Sailwave includes the Excel spreadsheet template to do the calculations in what is called external mode. It is possible to use a different spreadsheet which has a different algorithm for calculating a rating and I am aware of a few Sailwave users who have done this.

As you have already created an Excel spreadsheet to do the rating calculations using your algorithm then it should be possible to use it with Sailwave once the appropriate changes are made to your Excel spreadsheet, so Sailwave and your Excel spreadsheet can exchange data automatically.

I hope you find this information useful and Google translate to Danish makes it understandable.

Kind regards,

Huw
On 29/10/2017 11:08, Finn Ehmsen f.ehmsen@tdcadsl.dk [sailwave] wrote:

hello I thought I had sent this mail to it-support@kerteminde-sejlklub.dk
This was why that email in Danish.

but equally I’m looking for a scoring system that after a season make a new handicap number for each boat.

I have made a #program in Excel #. It works, but you should guess the new handicap so it takes some time. the prerequisite is that they both have a better handicap number must have at least participated in more than 12 out of 16 sailings. we sail with reverse respite ie all of them have different start times and they should reach goals simultaneously. When after a season it is expected that a boat will sail 9 seconds faster than last year, the adjustment will only be 9/3 = 3, because the handicap will not get the numbers to jump back and forth. This system takes into account the crew abilities and the nature of the boat as well as the wind Low in the evening (we sail from 6:30 pm to finish between 2 to 8 miles

with best regards Finn from Denmark

sorry have used google translat

Den 29. okt. 2017 kl. 11.15 skrev Huw Pearce huw.pearce@bcs.org.uk [sailwave] sailwave@yahoogroups.com:

Hi Finn,

I would like to be able to help you, but my Danish is non-existent. If you could post in English I may be able to help you.

There are other scoring software applications and I have used several over the years, but I have stuck with Sailwave.

Kind regards,Huw
On 29/10/2017 09:59, Finn Ehmsen f.ehmsen@tdcadsl.dk [sailwave] wrote:

Hej er der jer der har efterlyst et alternativt scoring system til sailwave

Så kunne jeg godt tænke mig at komme i kontakt med jer

Kh Finn E. 61280962 medlem af Åbenrå sejlklub

alt
Virus-free. www.avast.com

–

Jon Eskdale

03333 443377

07530 112233

Jon Eskdale
07530 112233

Skype “eskdale”

14

Hi Finn - The problem is you have set the rating for all the boats for Race 1 to an invalid value

With Sailwave you can display the ratings by either using the Drop down and selecting ratings. Or a quick way is to press “F6” then “R”

I’ve removed the invalid ratings for Race 1 and there are then no errors

See attached blw file

Jon

···

On 19 November 2017 at 19:20, Finn Ehmsen f.ehmsen@tdcadsl.dk [sailwave] sailwave@yahoogroups.com wrote:

Hello Jon
I still have problems, you can see some errors in Excel.
and handicap numbers are very strange going from 0.85 to 1231752 in the same race

Kind regards

Finn Ehmsen

----- Original meddelelse -----

Fra: Jon Eskdale jon@sailwave.com [sailwave] sailwave@yahoogroups.com
Til: sailwave@yahoogroups.com sailwave@yahoogroups.com
Dato: Tir, 14. nov 2017 12:55
Emne: Re: [sailwave] Sailwave scoring system

Hi Finn,
I’ve had a look at your file. The main problem seemed to be the default rating you were using had a comma in place of a full stop

0.961538462 was written as 0,961538462

If you change these ratings to use a full stop it does basically work

Did you get it working OK with the example supplied with Sailwave?

Let me know how you get on

Regards

Jon

Jon Eskdale
07530 112233

Skype “eskdale”

Jon Eskdale
07530 112233

Skype “eskdale”

On 13 November 2017 at 19:33, Finn Ehmsen f.ehmsen@tdcadsl.dk [sailwave] sailwave@yahoogroups.com wrote:

hi Jon i can not make it work! Excel starts well but here there are some errors and errors

with best regards Finn

----- Original meddelelse -----

Fra: Jon Eskdale jon@sailwave.com [sailwave] sailwave@yahoogroups.com
Til: sailwave@yahoogroups.com
Dato: Man, 30. okt 2017 22:46
Emne: Re: [sailwave] Sailwave scoring system

Hi Finn,

You best approach is to use the NHC example included with Sailwave then switch it to external mode and it will use excel to do the calculation. Once you have this working you can modify the template to do the calculations that you require.

Jon

On Mon, 30 Oct 2017 at 21:38, Finn Ehmsen f.ehmsen@tdcadsl.dk [sailwave] sailwave@yahoogroups.com wrote:

Hi Hwu. Thank you very much for the answers I am very honored about

I can’t Get Excel to start ?
and another question I have:
is it possible to make a code that can give the value = number completed both + round top ((not completed both) / 2) +1
Kind regards Finn E.

Den 29. okt. 2017 kl. 15.13 skrev Huw Pearce huw.pearce@bcs.org.uk [sailwave] sailwave@yahoogroups.com:

Hi Finn,

Understand about spelling; we learn to speak quite a bit before we learn to spell. However, I am sure that your command of spoken & written English is far better than mine of Danish.

There is no Excel button the toolbar or in the menu options. To use an external spreadsheet you have created you need to open scoring options and select the Rating tab. Near the bottom of the window is a check box alongside the word Excel, click the check box and an entry box opens in which you can add your external Excel template file name.

You need to understand the format of Excel file and data exchange. You need to look at the NHC Excel template file to understand how you need to set-up your Excel template so the data is exchanged correctly between Sailwave & Excel.

I have never needed to use this functionality, just know it exists. Jon the person who implemented the Sailwave Excel link functionality will be able to help you more than I can. Jon has been in Spain scoring the Techno Worlds and is travelling back today/tomorrow. He might be busy Monday & Tuesday catching up with real work matters, so could be day or so before he sees this message thread.

Kind regards,

Huw
On 29/10/2017 13:12, Finn Ehmsen f.ehmsen@tdcadsl.dk [sailwave] wrote:

Thanks I can read it and talk a bit but it is hard for me to Spell it. Where is the Button for Excel ?

Kind regards

Finn

Den 29. okt. 2017 kl. 12.21 skrev Huw Pearce huw.pearce@bcs.org.uk [sailwave] sailwave@yahoogroups.com:

Hi Finn,

Thank you for your update.

Sailwave has built-in functionality to use an external Microsoft Excel spreadsheet to do rating/handicap adjustments. This functionality was included to support the RYA NHC rating system which is a progressive handicap system. Sailwave includes the Excel spreadsheet template to do the calculations in what is called external mode. It is possible to use a different spreadsheet which has a different algorithm for calculating a rating and I am aware of a few Sailwave users who have done this.

As you have already created an Excel spreadsheet to do the rating calculations using your algorithm then it should be possible to use it with Sailwave once the appropriate changes are made to your Excel spreadsheet, so Sailwave and your Excel spreadsheet can exchange data automatically.

I hope you find this information useful and Google translate to Danish makes it understandable.

Kind regards,

Huw
On 29/10/2017 11:08, Finn Ehmsen f.ehmsen@tdcadsl.dk [sailwave] wrote:

hello I thought I had sent this mail to it-support@kerteminde-sejlklub.dk
This was why that email in Danish.

but equally I’m looking for a scoring system that after a season make a new handicap number for each boat.

I have made a #program in Excel #. It works, but you should guess the new handicap so it takes some time. the prerequisite is that they both have a better handicap number must have at least participated in more than 12 out of 16 sailings. we sail with reverse respite ie all of them have different start times and they should reach goals simultaneously. When after a season it is expected that a boat will sail 9 seconds faster than last year, the adjustment will only be 9/3 = 3, because the handicap will not get the numbers to jump back and forth. This system takes into account the crew abilities and the nature of the boat as well as the wind Low in the evening (we sail from 6:30 pm to finish between 2 to 8 miles

with best regards Finn from Denmark

sorry have used google translat

Den 29. okt. 2017 kl. 11.15 skrev Huw Pearce huw.pearce@bcs.org.uk [sailwave] sailwave@yahoogroups.com:

Hi Finn,

I would like to be able to help you, but my Danish is non-existent. If you could post in English I may be able to help you.

There are other scoring software applications and I have used several over the years, but I have stuck with Sailwave.

Kind regards,Huw
On 29/10/2017 09:59, Finn Ehmsen f.ehmsen@tdcadsl.dk [sailwave] wrote:

Hej er der jer der har efterlyst et alternativt scoring system til sailwave

Så kunne jeg godt tænke mig at komme i kontakt med jer

Kh Finn E. 61280962 medlem af Åbenrå sejlklub

alt
Virus-free. www.avast.com

–

Jon Eskdale

03333 443377

07530 112233