Jon,
Still having some difficulty with expanding my spreadsheet beyond 40 boats.
I have (temporarily) solved the problem by taking out those boats which didn’t compete in a given series, so the net result is still below 40 boats, and I can run my results that way.
What I am doing is I am taking the last series as the “template” for the new series, to preserve the NHC Ratings, but if I add the new boats, I get back to having more than 40, so I’m always deleting the ones which didn’t race (but which will appear in the next series) and adding the new ones and making sure I don’t go over the 40 limit.
I have followed your instructions regarding resetting the NHC excel template and changed my global settings to direct the rating file to SWNHC3.xls, see attached snip 7 and 8.
Perhaps I need to start a brand new series from scratch to get the new (50 boat limit) template, as copying an old series and using that as the basis for the next one seems to default back to the “old” (40 boat) template attached to that results file??
Patrick
···
From: sailwave@yahoogroups.com [mailto:sailwave@yahoogroups.com]
Sent: 23 March 2015 17:49
To: sailwave@yahoogroups.com
Subject: Re: FW: [sailwave] Re: NHC question
OK from the attachment the sheet size is set to 40
So either you didn’t edit the config sheet and set that to 50 (see earlier instructions) or it is not reading the correct template file in which case your configuration is wrong somewhere. Have you restarted Sailwave since you changed the locations? That may fix it.
If you need to diagnose where it is reading the template file from you can run Debugview (available free of charge from Microsoft https://technet.microsoft.com/en-us/library/bb896647.aspx ) Run this before you score and it will contain within its printout where it got the template from but you should be able to get it working without this.
Jon
Jon Eskdale
07976 709777
Skype “eskdale”
On 23 March 2015 at 17:01, Patrick Blaney patrick.blaney@phblaney.com [sailwave] sailwave@yahoogroups.com wrote:
Jon, I have edited it, but the excel spreadsheet that comes up when I run the series gives the attached error report.
Patrick
From: sailwave@yahoogroups.com [mailto:sailwave@yahoogroups.com]
Sent: 23 March 2015 16:53
To: sailwave@yahoogroups.com
Subject: Re: FW: [sailwave] Re: NHC question
Hi Patrick,
OK that looks good - so now you can edit it - Correct?
or have you already edited it ? What is not working?
Jon
Jon Eskdale
07976 709777
Skype “eskdale”
On 23 March 2015 at 16:42, Patrick Blaney patrick.blaney@phblaney.com [sailwave] sailwave@yahoogroups.com wrote:
Jon,
I know that I am being stupid but I still can’t make it work.
Snip 4 and 5 show what happens and the file extensions involved.
Patrick
From: sailwave@yahoogroups.com [mailto:sailwave@yahoogroups.com]
Sent: 23 March 2015 15:59
To: sailwave@yahoogroups.com
Subject: Re: FW: [sailwave] Re: NHC question
Hi Patrick,
You need to move it to the location shown in my previous post, and make sure that your global options are pointing to that location also.
With the new versions of windows (Since XP) you can’t edit files in the Program files folders and sub-directories without admin permissions or if you can it generates a phantom version of the file.
Any problems let me know.
Jon
Jon Eskdale
07976 709777
Skype “eskdale”
On 23 March 2015 at 15:48, Patrick Blaney patrick.blaney@phblaney.com [sailwave] sailwave@yahoogroups.com wrote:
Oops I forgot the other attachments, now included
From: Patrick Blaney
Sent: 23 March 2015 15:14
To: ‘sailwave@yahoogroups.com’
Subject: RE: [sailwave] Re: NHC question
Jon,
I am having difficulty in adding the additional cells on to the excel worksheet SWNHC3.xls
Firstly, the file was not in its default location, and I’m not sure why (I don’t recall setting any other default location – but maybe I did inadvertently?)
See Snip 1 for details
Then when I make the changes as you suggest I can’t save the file except in a different location and with a different name? I don’t appear to have administrator privileges.
See Snip 2 and 3 for details.
I may be just sufficiently unaware of the way to change these things that this, normal, step is beyond my excel abilities??
Grateful for any further help?
Thanks
Patrick
From: sailwave@yahoogroups.com [mailto:sailwave@yahoogroups.com]
Sent: 20 March 2015 11:15
To: sailwave@yahoogroups.com
Subject: Re: [sailwave] Re: NHC question
Hi Patrick
Not a big problem
First some background info
Sailwave is using a template SWNHC3.xls to specify the rules for the calculation This template by default is in Public Documents - Sailwave - Templates folder (C:\Users\Public\Documents\Sailwave\Templates) although you can change the folder in Sailwave - Setup - Global Options - Folders
First make a backup copy of this file then open it in Excel
Now lets assume you want to add another 10 lines
Click on the 9 of row 9 and while holding the button down move the mouse to 18 so that you have highlighted 10 rows as below
![Inline images 1]()
Now right click and select Copy
Now right click on the 19 and select Insert Copied Cells - see below
![Inline images 4]()
You have now inserted 10 more rows we just need to tell Sailwave that this template now has 10 more rows available. To do this click on the Config worksheet and change the SheetSize value from 40 to 50
![Inline images 3]()
Switch back to the Main sheet and select cell A4 (This is just a blank cell where the selection will appear when it runs) now save the modified sheet (must be SWNHC3.xls) and you are ready to go
The size of the sheet you use would depend upon you fleet size. It will work fine up to 200 boats but as you increase the size the spreadsheet gets larger and hence slower. Although the rows you copied look empty at first glance the cells do contain formulae.
Any problems please come back to me
Jon
Jon Eskdale
07976 709777
Skype “eskdale”
On 20 March 2015 at 08:24, Patrick Blaney patrick.blaney@gmail.com [sailwave] sailwave@yahoogroups.com wrote:
Jon and Sailwave experts
I have encountered a problem with NHC in external mode.
My list of competitors has finally crossed the line from 40 to 41, and I am getting an error message telling me to use a larger template?
I have no idea how to do this, I assume this is with the excel spreadsheet that comes with Sailwave helper, but that spreadsheet is blank.
I attach a screen grab of same??
What should I do?
Patrick
On 18 March 2015 at 14:21, Jon Eskdale jon@sailwave.com [sailwave] sailwave@yahoogroups.com wrote:
Hi Ian,
Just in case you didn’t see my earlier post - The problem you have is that you are using PY ratings - These are currently only supported in external mode
Jon
Jon Eskdale
07976 709777
Skype “eskdale”
On 18 March 2015 at 04:20, ian.grant12@gmail.com [sailwave] sailwave@yahoogroups.com wrote:
Hi Malcolm,
Thanks for sharing your insights.
For new entrants to a series who do not have an NHC rating from previous races, I have used PY as the default initial rating.
Given your observation I’ll use external mode.
Thanks,
Ian
Sent from my BlackBerry 10 smartphone.
From: Malcolm Osborne malcolmo@telkomsa.net [sailwave]
Sent: Wednesday, 18 March 2015 03:09
To: sailwave@yahoogroups.com
Reply To: sailwave@yahoogroups.com
Subject: Re: [sailwave] Re: NHC question
I had a similar query recently - Jon provided the answer - using Portsmouth ratings isn’t quite correct for NHC and the internal mode doesn’t cater for this. The external mode gives the correct figures (coverts correctly back to Portsmouth)
regards,
Malcolm Osborne
Sedgefield South Africa
On 2015/03/17 19:03, Ian Grant ian.grant12@gmail.com [sailwave] wrote:
Hi Jon,
Here is an example blw file which gives different race ratings in NHC external and internal modes. I have also included screen shots of the race ratings so you can see what I’m seeing…
I have also noticed that when I select “custom external” mode a message appears saying SWNHC4 is not found in the template directory.
I am using the latest version of SW downloaded from the web site last week.
Glad to have your insights–many thanks for your patience.
Kind regards,
Ian Grant.
On 17 March 2015 at 20:21, Jon Eskdale jon@sailwave.com [sailwave] sailwave@yahoogroups.com wrote:
Hi - Ian there should be no difference - if there is then there is something wrong. With the external mode you can see all the calculations.
If you could send me a blw that has different results then I will investigate and tell you why. May be if you could tell which is the first race that is different then it would give you a clue.
May be it is it the use of some scoring code?
Jon
Jon Eskdale
07976 709777
Skype “eskdale”
On 17 March 2015 at 16:13, ian.grant12@gmail.com [sailwave] sailwave@yahoogroups.com wrote:
I also have found NHC Internal Mode gives slightly different race ratings and corrected times than NHC External/custom mode. Curious why --and which mode is correct?
Ian Grant
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
Hi Patrick,
There is definitely no need to start a new series you can change the template at any time - It should be easy and straight forward
You seem to have the templates in the correct place now (where they can be edited)
If you open the template with Excel C:\Users\Public\Documents\Sailwave\Templates\SWNHC3.xls
Does this have the modified version with the 50 in place of 40? - As this is the template that Sailwave is using it should then work.
If you still have a problem give me a telephone call
Jon
···
On Wed, 25 Mar 2015 at 09:37 Patrick Blaney patrick.blaney@phblaney.com [sailwave] sailwave@yahoogroups.com wrote:
Jon,
Still having some difficulty with expanding my spreadsheet beyond 40 boats.
I have (temporarily) solved the problem by taking out those boats which didn’t compete in a given series, so the net result is still below 40 boats, and I can run my results that way.
What I am doing is I am taking the last series as the “template” for the new series, to preserve the NHC Ratings, but if I add the new boats, I get back to having more than 40, so I’m always deleting the ones which didn’t race (but which will appear in the next series) and adding the new ones and making sure I don’t go over the 40 limit.
I have followed your instructions regarding resetting the NHC excel template and changed my global settings to direct the rating file to SWNHC3.xls, see attached snip 7 and 8.
Perhaps I need to start a brand new series from scratch to get the new (50 boat limit) template, as copying an old series and using that as the basis for the next one seems to default back to the “old” (40 boat) template attached to that results file??
Patrick
From: sailwave@yahoogroups.com [mailto:sailwave@yahoogroups.com]
Sent: 23 March 2015 17:49
To: sailwave@yahoogroups.com
Subject: Re: FW: [sailwave] Re: NHC question
OK from the attachment the sheet size is set to 40
So either you didn’t edit the config sheet and set that to 50 (see earlier instructions) or it is not reading the correct template file in which case your configuration is wrong somewhere. Have you restarted Sailwave since you changed the locations? That may fix it.
If you need to diagnose where it is reading the template file from you can run Debugview (available free of charge from Microsoft https://technet.microsoft.com/en-us/library/bb896647.aspx ) Run this before you score and it will contain within its printout where it got the template from but you should be able to get it working without this.
Jon
Jon Eskdale
07976 709777
Skype “eskdale”
On 23 March 2015 at 17:01, Patrick Blaney patrick.blaney@phblaney.com [sailwave] sailwave@yahoogroups.com wrote:
Jon, I have edited it, but the excel spreadsheet that comes up when I run the series gives the attached error report.
Patrick
From: sailwave@yahoogroups.com [mailto:sailwave@yahoogroups.com]
Sent: 23 March 2015 16:53
To: sailwave@yahoogroups.com
Subject: Re: FW: [sailwave] Re: NHC question
Hi Patrick,
OK that looks good - so now you can edit it - Correct?
or have you already edited it ? What is not working?
Jon
Jon Eskdale
07976 709777
Skype “eskdale”
On 23 March 2015 at 16:42, Patrick Blaney patrick.blaney@phblaney.com [sailwave] sailwave@yahoogroups.com wrote:
Jon,
I know that I am being stupid but I still can’t make it work.
Snip 4 and 5 show what happens and the file extensions involved.
Patrick
From: sailwave@yahoogroups.com [mailto:sailwave@yahoogroups.com]
Sent: 23 March 2015 15:59
To: sailwave@yahoogroups.com
Subject: Re: FW: [sailwave] Re: NHC question
Hi Patrick,
You need to move it to the location shown in my previous post, and make sure that your global options are pointing to that location also.
With the new versions of windows (Since XP) you can’t edit files in the Program files folders and sub-directories without admin permissions or if you can it generates a phantom version of the file.
Any problems let me know.
Jon
Jon Eskdale
07976 709777
Skype “eskdale”
On 23 March 2015 at 15:48, Patrick Blaney patrick.blaney@phblaney.com [sailwave] sailwave@yahoogroups.com wrote:
Oops I forgot the other attachments, now included
From: Patrick Blaney
Sent: 23 March 2015 15:14
To: ‘sailwave@yahoogroups.com’
Subject: RE: [sailwave] Re: NHC question
Jon,
I am having difficulty in adding the additional cells on to the excel worksheet SWNHC3.xls
Firstly, the file was not in its default location, and I’m not sure why (I don’t recall setting any other default location – but maybe I did inadvertently?)
See Snip 1 for details
Then when I make the changes as you suggest I can’t save the file except in a different location and with a different name? I don’t appear to have administrator privileges.
See Snip 2 and 3 for details.
I may be just sufficiently unaware of the way to change these things that this, normal, step is beyond my excel abilities??
Grateful for any further help?
Thanks
Patrick
From: sailwave@yahoogroups.com [mailto:sailwave@yahoogroups.com]
Sent: 20 March 2015 11:15
To: sailwave@yahoogroups.com
Subject: Re: [sailwave] Re: NHC question
Hi Patrick
Not a big problem
First some background info
Sailwave is using a template SWNHC3.xls to specify the rules for the calculation This template by default is in Public Documents - Sailwave - Templates folder (C:\Users\Public\Documents\Sailwave\Templates) although you can change the folder in Sailwave - Setup - Global Options - Folders
First make a backup copy of this file then open it in Excel
Now lets assume you want to add another 10 lines
Click on the 9 of row 9 and while holding the button down move the mouse to 18 so that you have highlighted 10 rows as below
![Inline images 1]()
Now right click and select Copy
Now right click on the 19 and select Insert Copied Cells - see below
![Inline images 4]()
You have now inserted 10 more rows we just need to tell Sailwave that this template now has 10 more rows available. To do this click on the Config worksheet and change the SheetSize value from 40 to 50
![Inline images 3]()
Switch back to the Main sheet and select cell A4 (This is just a blank cell where the selection will appear when it runs) now save the modified sheet (must be SWNHC3.xls) and you are ready to go
The size of the sheet you use would depend upon you fleet size. It will work fine up to 200 boats but as you increase the size the spreadsheet gets larger and hence slower. Although the rows you copied look empty at first glance the cells do contain formulae.
Any problems please come back to me
Jon
Jon Eskdale
07976 709777
Skype “eskdale”
On 20 March 2015 at 08:24, Patrick Blaney patrick.blaney@gmail.com [sailwave] sailwave@yahoogroups.com wrote:
Jon and Sailwave experts
I have encountered a problem with NHC in external mode.
My list of competitors has finally crossed the line from 40 to 41, and I am getting an error message telling me to use a larger template?
I have no idea how to do this, I assume this is with the excel spreadsheet that comes with Sailwave helper, but that spreadsheet is blank.
I attach a screen grab of same??
What should I do?
Patrick
On 18 March 2015 at 14:21, Jon Eskdale jon@sailwave.com [sailwave] sailwave@yahoogroups.com wrote:
Hi Ian,
Just in case you didn’t see my earlier post - The problem you have is that you are using PY ratings - These are currently only supported in external mode
Jon
Jon Eskdale
07976 709777
Skype “eskdale”
On 18 March 2015 at 04:20, ian.grant12@gmail.com [sailwave] sailwave@yahoogroups.com wrote:
Hi Malcolm,
Thanks for sharing your insights.
For new entrants to a series who do not have an NHC rating from previous races, I have used PY as the default initial rating.
Given your observation I’ll use external mode.
Thanks,
Ian
Sent from my BlackBerry 10 smartphone.
From: Malcolm Osborne malcolmo@telkomsa.net [sailwave]
Sent: Wednesday, 18 March 2015 03:09
To: sailwave@yahoogroups.com
Reply To: sailwave@yahoogroups.com
Subject: Re: [sailwave] Re: NHC question
I had a similar query recently - Jon provided the answer - using Portsmouth ratings isn’t quite correct for NHC and the internal mode doesn’t cater for this. The external mode gives the correct figures (coverts correctly back to Portsmouth)
regards,
Malcolm Osborne
Sedgefield South Africa
On 2015/03/17 19:03, Ian Grant ian.grant12@gmail.com [sailwave] wrote:
Hi Jon,
Here is an example blw file which gives different race ratings in NHC external and internal modes. I have also included screen shots of the race ratings so you can see what I’m seeing…
I have also noticed that when I select “custom external” mode a message appears saying SWNHC4 is not found in the template directory.
I am using the latest version of SW downloaded from the web site last week.
Glad to have your insights–many thanks for your patience.
Kind regards,
Ian Grant.
On 17 March 2015 at 20:21, Jon Eskdale jon@sailwave.com [sailwave] sailwave@yahoogroups.com wrote:
Hi - Ian there should be no difference - if there is then there is something wrong. With the external mode you can see all the calculations.
If you could send me a blw that has different results then I will investigate and tell you why. May be if you could tell which is the first race that is different then it would give you a clue.
May be it is it the use of some scoring code?
Jon
Jon Eskdale
07976 709777
Skype “eskdale”
On 17 March 2015 at 16:13, ian.grant12@gmail.com [sailwave] sailwave@yahoogroups.com wrote:
I also have found NHC Internal Mode gives slightly different race ratings and corrected times than NHC External/custom mode. Curious why --and which mode is correct?
Ian Grant
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
Jon,
Still having no luck, so I put in your link and searched for it with the following result, see snip 9.
I can call you at 2.30ish if that is OKI for you? The day job interfering with my need to solve this riddle with Sailwave!
Patrick
···
From: sailwave@yahoogroups.com [mailto:sailwave@yahoogroups.com]
Sent: 25 March 2015 09:51
To: sailwave@yahoogroups.com
Subject: Re: FW: [sailwave] Re: NHC question
Hi Patrick,
There is definitely no need to start a new series you can change the template at any time - It should be easy and straight forward
You seem to have the templates in the correct place now (where they can be edited)
If you open the template with Excel C:\Users\Public\Documents\Sailwave\Templates\SWNHC3.xls
Does this have the modified version with the 50 in place of 40? - As this is the template that Sailwave is using it should then work.
If you still have a problem give me a telephone call
Jon
On Wed, 25 Mar 2015 at 09:37 Patrick Blaney patrick.blaney@phblaney.com [sailwave] sailwave@yahoogroups.com wrote:
Jon,
Still having some difficulty with expanding my spreadsheet beyond 40 boats.
I have (temporarily) solved the problem by taking out those boats which didn’t compete in a given series, so the net result is still below 40 boats, and I can run my results that way.
What I am doing is I am taking the last series as the “template” for the new series, to preserve the NHC Ratings, but if I add the new boats, I get back to having more than 40, so I’m always deleting the ones which didn’t race (but which will appear in the next series) and adding the new ones and making sure I don’t go over the 40 limit.
I have followed your instructions regarding resetting the NHC excel template and changed my global settings to direct the rating file to SWNHC3.xls, see attached snip 7 and 8.
Perhaps I need to start a brand new series from scratch to get the new (50 boat limit) template, as copying an old series and using that as the basis for the next one seems to default back to the “old” (40 boat) template attached to that results file??
Patrick
From: sailwave@yahoogroups.com [mailto:sailwave@yahoogroups.com]
Sent: 23 March 2015 17:49
To: sailwave@yahoogroups.com
Subject: Re: FW: [sailwave] Re: NHC question
OK from the attachment the sheet size is set to 40
So either you didn’t edit the config sheet and set that to 50 (see earlier instructions) or it is not reading the correct template file in which case your configuration is wrong somewhere. Have you restarted Sailwave since you changed the locations? That may fix it.
If you need to diagnose where it is reading the template file from you can run Debugview (available free of charge from Microsoft https://technet.microsoft.com/en-us/library/bb896647.aspx ) Run this before you score and it will contain within its printout where it got the template from but you should be able to get it working without this.
Jon
Jon Eskdale
07976 709777
Skype “eskdale”
On 23 March 2015 at 17:01, Patrick Blaney patrick.blaney@phblaney.com [sailwave] sailwave@yahoogroups.com wrote:
Jon, I have edited it, but the excel spreadsheet that comes up when I run the series gives the attached error report.
Patrick
From: sailwave@yahoogroups.com [mailto:sailwave@yahoogroups.com]
Sent: 23 March 2015 16:53
To: sailwave@yahoogroups.com
Subject: Re: FW: [sailwave] Re: NHC question
Hi Patrick,
OK that looks good - so now you can edit it - Correct?
or have you already edited it ? What is not working?
Jon
Jon Eskdale
07976 709777
Skype “eskdale”
On 23 March 2015 at 16:42, Patrick Blaney patrick.blaney@phblaney.com [sailwave] sailwave@yahoogroups.com wrote:
Jon,
I know that I am being stupid but I still can’t make it work.
Snip 4 and 5 show what happens and the file extensions involved.
Patrick
From: sailwave@yahoogroups.com [mailto:sailwave@yahoogroups.com]
Sent: 23 March 2015 15:59
To: sailwave@yahoogroups.com
Subject: Re: FW: [sailwave] Re: NHC question
Hi Patrick,
You need to move it to the location shown in my previous post, and make sure that your global options are pointing to that location also.
With the new versions of windows (Since XP) you can’t edit files in the Program files folders and sub-directories without admin permissions or if you can it generates a phantom version of the file.
Any problems let me know.
Jon
Jon Eskdale
07976 709777
Skype “eskdale”
On 23 March 2015 at 15:48, Patrick Blaney patrick.blaney@phblaney.com [sailwave] sailwave@yahoogroups.com wrote:
Oops I forgot the other attachments, now included
From: Patrick Blaney
Sent: 23 March 2015 15:14
To: ‘sailwave@yahoogroups.com’
Subject: RE: [sailwave] Re: NHC question
Jon,
I am having difficulty in adding the additional cells on to the excel worksheet SWNHC3.xls
Firstly, the file was not in its default location, and I’m not sure why (I don’t recall setting any other default location – but maybe I did inadvertently?)
See Snip 1 for details
Then when I make the changes as you suggest I can’t save the file except in a different location and with a different name? I don’t appear to have administrator privileges.
See Snip 2 and 3 for details.
I may be just sufficiently unaware of the way to change these things that this, normal, step is beyond my excel abilities??
Grateful for any further help?
Thanks
Patrick
From: sailwave@yahoogroups.com [mailto:sailwave@yahoogroups.com]
Sent: 20 March 2015 11:15
To: sailwave@yahoogroups.com
Subject: Re: [sailwave] Re: NHC question
Hi Patrick
Not a big problem
First some background info
Sailwave is using a template SWNHC3.xls to specify the rules for the calculation This template by default is in Public Documents - Sailwave - Templates folder (C:\Users\Public\Documents\Sailwave\Templates) although you can change the folder in Sailwave - Setup - Global Options - Folders
First make a backup copy of this file then open it in Excel
Now lets assume you want to add another 10 lines
Click on the 9 of row 9 and while holding the button down move the mouse to 18 so that you have highlighted 10 rows as below
![Inline images 1]()
Now right click and select Copy
Now right click on the 19 and select Insert Copied Cells - see below
![Inline images 4]()
You have now inserted 10 more rows we just need to tell Sailwave that this template now has 10 more rows available. To do this click on the Config worksheet and change the SheetSize value from 40 to 50
![Inline images 3]()
Switch back to the Main sheet and select cell A4 (This is just a blank cell where the selection will appear when it runs) now save the modified sheet (must be SWNHC3.xls) and you are ready to go
The size of the sheet you use would depend upon you fleet size. It will work fine up to 200 boats but as you increase the size the spreadsheet gets larger and hence slower. Although the rows you copied look empty at first glance the cells do contain formulae.
Any problems please come back to me
Jon
Jon Eskdale
07976 709777
Skype “eskdale”
On 20 March 2015 at 08:24, Patrick Blaney patrick.blaney@gmail.com [sailwave] sailwave@yahoogroups.com wrote:
Jon and Sailwave experts
I have encountered a problem with NHC in external mode.
My list of competitors has finally crossed the line from 40 to 41, and I am getting an error message telling me to use a larger template?
I have no idea how to do this, I assume this is with the excel spreadsheet that comes with Sailwave helper, but that spreadsheet is blank.
I attach a screen grab of same??
What should I do?
Patrick
On 18 March 2015 at 14:21, Jon Eskdale jon@sailwave.com [sailwave] sailwave@yahoogroups.com wrote:
Hi Ian,
Just in case you didn’t see my earlier post - The problem you have is that you are using PY ratings - These are currently only supported in external mode
Jon
Jon Eskdale
07976 709777
Skype “eskdale”
On 18 March 2015 at 04:20, ian.grant12@gmail.com [sailwave] sailwave@yahoogroups.com wrote:
Hi Malcolm,
Thanks for sharing your insights.
For new entrants to a series who do not have an NHC rating from previous races, I have used PY as the default initial rating.
Given your observation I’ll use external mode.
Thanks,
Ian
Sent from my BlackBerry 10 smartphone.
From: Malcolm Osborne malcolmo@telkomsa.net [sailwave]
Sent: Wednesday, 18 March 2015 03:09
To: sailwave@yahoogroups.com
Reply To: sailwave@yahoogroups.com
Subject: Re: [sailwave] Re: NHC question
I had a similar query recently - Jon provided the answer - using Portsmouth ratings isn’t quite correct for NHC and the internal mode doesn’t cater for this. The external mode gives the correct figures (coverts correctly back to Portsmouth)
regards,
Malcolm Osborne
Sedgefield South Africa
On 2015/03/17 19:03, Ian Grant ian.grant12@gmail.com [sailwave] wrote:
Hi Jon,
Here is an example blw file which gives different race ratings in NHC external and internal modes. I have also included screen shots of the race ratings so you can see what I’m seeing…
I have also noticed that when I select “custom external” mode a message appears saying SWNHC4 is not found in the template directory.
I am using the latest version of SW downloaded from the web site last week.
Glad to have your insights–many thanks for your patience.
Kind regards,
Ian Grant.
On 17 March 2015 at 20:21, Jon Eskdale jon@sailwave.com [sailwave] sailwave@yahoogroups.com wrote:
Hi - Ian there should be no difference - if there is then there is something wrong. With the external mode you can see all the calculations.
If you could send me a blw that has different results then I will investigate and tell you why. May be if you could tell which is the first race that is different then it would give you a clue.
May be it is it the use of some scoring code?
Jon
Jon Eskdale
07976 709777
Skype “eskdale”
On 17 March 2015 at 16:13, ian.grant12@gmail.com [sailwave] sailwave@yahoogroups.com wrote:
I also have found NHC Internal Mode gives slightly different race ratings and corrected times than NHC External/custom mode. Curious why --and which mode is correct?
Ian Grant
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
Hi 2:30 would be fine 03333 443377 or via Skype username “Eskdale”
Jon
···
On 25 March 2015 at 13:21, Patrick Blaney patrick.blaney@phblaney.com [sailwave] sailwave@yahoogroups.com wrote:
Jon,
Still having no luck, so I put in your link and searched for it with the following result, see snip 9.
I can call you at 2.30ish if that is OKI for you? The day job interfering with my need to solve this riddle with Sailwave!
Patrick
From: sailwave@yahoogroups.com [mailto:sailwave@yahoogroups.com]
Sent: 25 March 2015 09:51
To: sailwave@yahoogroups.com
Subject: Re: FW: [sailwave] Re: NHC question
Hi Patrick,
There is definitely no need to start a new series you can change the template at any time - It should be easy and straight forward
You seem to have the templates in the correct place now (where they can be edited)
If you open the template with Excel C:\Users\Public\Documents\Sailwave\Templates\SWNHC3.xls
Does this have the modified version with the 50 in place of 40? - As this is the template that Sailwave is using it should then work.
If you still have a problem give me a telephone call
Jon
On Wed, 25 Mar 2015 at 09:37 Patrick Blaney patrick.blaney@phblaney.com [sailwave] sailwave@yahoogroups.com wrote:
Jon,
Still having some difficulty with expanding my spreadsheet beyond 40 boats.
I have (temporarily) solved the problem by taking out those boats which didn’t compete in a given series, so the net result is still below 40 boats, and I can run my results that way.
What I am doing is I am taking the last series as the “template” for the new series, to preserve the NHC Ratings, but if I add the new boats, I get back to having more than 40, so I’m always deleting the ones which didn’t race (but which will appear in the next series) and adding the new ones and making sure I don’t go over the 40 limit.
I have followed your instructions regarding resetting the NHC excel template and changed my global settings to direct the rating file to SWNHC3.xls, see attached snip 7 and 8.
Perhaps I need to start a brand new series from scratch to get the new (50 boat limit) template, as copying an old series and using that as the basis for the next one seems to default back to the “old” (40 boat) template attached to that results file??
Patrick
From: sailwave@yahoogroups.com [mailto:sailwave@yahoogroups.com]
Sent: 23 March 2015 17:49
To: sailwave@yahoogroups.com
Subject: Re: FW: [sailwave] Re: NHC question
OK from the attachment the sheet size is set to 40
So either you didn’t edit the config sheet and set that to 50 (see earlier instructions) or it is not reading the correct template file in which case your configuration is wrong somewhere. Have you restarted Sailwave since you changed the locations? That may fix it.
If you need to diagnose where it is reading the template file from you can run Debugview (available free of charge from Microsoft https://technet.microsoft.com/en-us/library/bb896647.aspx ) Run this before you score and it will contain within its printout where it got the template from but you should be able to get it working without this.
Jon
Jon Eskdale
07976 709777
Skype “eskdale”
On 23 March 2015 at 17:01, Patrick Blaney patrick.blaney@phblaney.com [sailwave] sailwave@yahoogroups.com wrote:
Jon, I have edited it, but the excel spreadsheet that comes up when I run the series gives the attached error report.
Patrick
From: sailwave@yahoogroups.com [mailto:sailwave@yahoogroups.com]
Sent: 23 March 2015 16:53
To: sailwave@yahoogroups.com
Subject: Re: FW: [sailwave] Re: NHC question
Hi Patrick,
OK that looks good - so now you can edit it - Correct?
or have you already edited it ? What is not working?
Jon
Jon Eskdale
07976 709777
Skype “eskdale”
On 23 March 2015 at 16:42, Patrick Blaney patrick.blaney@phblaney.com [sailwave] sailwave@yahoogroups.com wrote:
Jon,
I know that I am being stupid but I still can’t make it work.
Snip 4 and 5 show what happens and the file extensions involved.
Patrick
From: sailwave@yahoogroups.com [mailto:sailwave@yahoogroups.com]
Sent: 23 March 2015 15:59
To: sailwave@yahoogroups.com
Subject: Re: FW: [sailwave] Re: NHC question
Hi Patrick,
You need to move it to the location shown in my previous post, and make sure that your global options are pointing to that location also.
With the new versions of windows (Since XP) you can’t edit files in the Program files folders and sub-directories without admin permissions or if you can it generates a phantom version of the file.
Any problems let me know.
Jon
Jon Eskdale
07976 709777
Skype “eskdale”
On 23 March 2015 at 15:48, Patrick Blaney patrick.blaney@phblaney.com [sailwave] sailwave@yahoogroups.com wrote:
Oops I forgot the other attachments, now included
From: Patrick Blaney
Sent: 23 March 2015 15:14
To: ‘sailwave@yahoogroups.com’
Subject: RE: [sailwave] Re: NHC question
Jon,
I am having difficulty in adding the additional cells on to the excel worksheet SWNHC3.xls
Firstly, the file was not in its default location, and I’m not sure why (I don’t recall setting any other default location – but maybe I did inadvertently?)
See Snip 1 for details
Then when I make the changes as you suggest I can’t save the file except in a different location and with a different name? I don’t appear to have administrator privileges.
See Snip 2 and 3 for details.
I may be just sufficiently unaware of the way to change these things that this, normal, step is beyond my excel abilities??
Grateful for any further help?
Thanks
Patrick
From: sailwave@yahoogroups.com [mailto:sailwave@yahoogroups.com]
Sent: 20 March 2015 11:15
To: sailwave@yahoogroups.com
Subject: Re: [sailwave] Re: NHC question
Hi Patrick
Not a big problem
First some background info
Sailwave is using a template SWNHC3.xls to specify the rules for the calculation This template by default is in Public Documents - Sailwave - Templates folder (C:\Users\Public\Documents\Sailwave\Templates) although you can change the folder in Sailwave - Setup - Global Options - Folders
First make a backup copy of this file then open it in Excel
Now lets assume you want to add another 10 lines
Click on the 9 of row 9 and while holding the button down move the mouse to 18 so that you have highlighted 10 rows as below
Now right click and select Copy
Now right click on the 19 and select Insert Copied Cells - see below
You have now inserted 10 more rows we just need to tell Sailwave that this template now has 10 more rows available. To do this click on the Config worksheet and change the SheetSize value from 40 to 50
Switch back to the Main sheet and select cell A4 (This is just a blank cell where the selection will appear when it runs) now save the modified sheet (must be SWNHC3.xls) and you are ready to go
The size of the sheet you use would depend upon you fleet size. It will work fine up to 200 boats but as you increase the size the spreadsheet gets larger and hence slower. Although the rows you copied look empty at first glance the cells do contain formulae.
Any problems please come back to me
Jon
Jon Eskdale
07976 709777
Skype “eskdale”
On 20 March 2015 at 08:24, Patrick Blaney patrick.blaney@gmail.com [sailwave] sailwave@yahoogroups.com wrote:
Jon and Sailwave experts
I have encountered a problem with NHC in external mode.
My list of competitors has finally crossed the line from 40 to 41, and I am getting an error message telling me to use a larger template?
I have no idea how to do this, I assume this is with the excel spreadsheet that comes with Sailwave helper, but that spreadsheet is blank.
I attach a screen grab of same??
What should I do?
Patrick
On 18 March 2015 at 14:21, Jon Eskdale jon@sailwave.com [sailwave] sailwave@yahoogroups.com wrote:
Hi Ian,
Just in case you didn’t see my earlier post - The problem you have is that you are using PY ratings - These are currently only supported in external mode
Jon
Jon Eskdale
07976 709777
Skype “eskdale”
On 18 March 2015 at 04:20, ian.grant12@gmail.com [sailwave] sailwave@yahoogroups.com wrote:
Hi Malcolm,
Thanks for sharing your insights.
For new entrants to a series who do not have an NHC rating from previous races, I have used PY as the default initial rating.
Given your observation I’ll use external mode.
Thanks,
Ian
Sent from my BlackBerry 10 smartphone.
From: Malcolm Osborne malcolmo@telkomsa.net [sailwave]
Sent: Wednesday, 18 March 2015 03:09
To: sailwave@yahoogroups.com
Reply To: sailwave@yahoogroups.com
Subject: Re: [sailwave] Re: NHC question
I had a similar query recently - Jon provided the answer - using Portsmouth ratings isn’t quite correct for NHC and the internal mode doesn’t cater for this. The external mode gives the correct figures (coverts correctly back to Portsmouth)
regards,
Malcolm Osborne
Sedgefield South Africa
On 2015/03/17 19:03, Ian Grant ian.grant12@gmail.com [sailwave] wrote:
Hi Jon,
Here is an example blw file which gives different race ratings in NHC external and internal modes. I have also included screen shots of the race ratings so you can see what I’m seeing…
I have also noticed that when I select “custom external” mode a message appears saying SWNHC4 is not found in the template directory.
I am using the latest version of SW downloaded from the web site last week.
Glad to have your insights–many thanks for your patience.
Kind regards,
Ian Grant.
On 17 March 2015 at 20:21, Jon Eskdale jon@sailwave.com [sailwave] sailwave@yahoogroups.com wrote:
Hi - Ian there should be no difference - if there is then there is something wrong. With the external mode you can see all the calculations.
If you could send me a blw that has different results then I will investigate and tell you why. May be if you could tell which is the first race that is different then it would give you a clue.
May be it is it the use of some scoring code?
Jon
Jon Eskdale
07976 709777
Skype “eskdale”
On 17 March 2015 at 16:13, ian.grant12@gmail.com [sailwave] sailwave@yahoogroups.com wrote:
I also have found NHC Internal Mode gives slightly different race ratings and corrected times than NHC External/custom mode. Curious why --and which mode is correct?
Ian Grant
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
Jon Eskdale
07976 709777
Skype “eskdale”
Hi - Just a quick post for anyone following this thread - The problem has been resolved the issue was when Patrick edited the SWNHC3.xls file it was saved as SWNHC3.xls.xlsx and as windows was configured to hide the extensions of known file types the xlsx was not visible it simply appeared as SWNHC3.xls. So when Sailwave looked in the custom Template directory for SWNHC3.xls it couldn’t find one of that name (because what was there was actually SWNHC3.xls.xlsx) so it defaulted to the one in Program files\Templates which was the original version.
Jon
···
On 25 March 2015 at 14:06, Jon Eskdale jon@sailwave.com [sailwave] sailwave@yahoogroups.com wrote:
Hi 2:30 would be fine 03333 443377 or via Skype username “Eskdale”
Jon
Jon Eskdale
07976 709777
Skype “eskdale”
Jon Eskdale
07976 709777
Skype “eskdale”
On 25 March 2015 at 13:21, Patrick Blaney patrick.blaney@phblaney.com [sailwave] sailwave@yahoogroups.com wrote:
Jon,
Still having no luck, so I put in your link and searched for it with the following result, see snip 9.
I can call you at 2.30ish if that is OKI for you? The day job interfering with my need to solve this riddle with Sailwave!
Patrick
From: sailwave@yahoogroups.com [mailto:sailwave@yahoogroups.com]
Sent: 25 March 2015 09:51
To: sailwave@yahoogroups.com
Subject: Re: FW: [sailwave] Re: NHC question
Hi Patrick,
There is definitely no need to start a new series you can change the template at any time - It should be easy and straight forward
You seem to have the templates in the correct place now (where they can be edited)
If you open the template with Excel C:\Users\Public\Documents\Sailwave\Templates\SWNHC3.xls
Does this have the modified version with the 50 in place of 40? - As this is the template that Sailwave is using it should then work.
If you still have a problem give me a telephone call
Jon
On Wed, 25 Mar 2015 at 09:37 Patrick Blaney patrick.blaney@phblaney.com [sailwave] sailwave@yahoogroups.com wrote:
Jon,
Still having some difficulty with expanding my spreadsheet beyond 40 boats.
I have (temporarily) solved the problem by taking out those boats which didn’t compete in a given series, so the net result is still below 40 boats, and I can run my results that way.
What I am doing is I am taking the last series as the “template” for the new series, to preserve the NHC Ratings, but if I add the new boats, I get back to having more than 40, so I’m always deleting the ones which didn’t race (but which will appear in the next series) and adding the new ones and making sure I don’t go over the 40 limit.
I have followed your instructions regarding resetting the NHC excel template and changed my global settings to direct the rating file to SWNHC3.xls, see attached snip 7 and 8.
Perhaps I need to start a brand new series from scratch to get the new (50 boat limit) template, as copying an old series and using that as the basis for the next one seems to default back to the “old” (40 boat) template attached to that results file??
Patrick
From: sailwave@yahoogroups.com [mailto:sailwave@yahoogroups.com]
Sent: 23 March 2015 17:49
To: sailwave@yahoogroups.com
Subject: Re: FW: [sailwave] Re: NHC question
OK from the attachment the sheet size is set to 40
So either you didn’t edit the config sheet and set that to 50 (see earlier instructions) or it is not reading the correct template file in which case your configuration is wrong somewhere. Have you restarted Sailwave since you changed the locations? That may fix it.
If you need to diagnose where it is reading the template file from you can run Debugview (available free of charge from Microsoft https://technet.microsoft.com/en-us/library/bb896647.aspx ) Run this before you score and it will contain within its printout where it got the template from but you should be able to get it working without this.
Jon
Jon Eskdale
07976 709777
Skype “eskdale”
On 23 March 2015 at 17:01, Patrick Blaney patrick.blaney@phblaney.com [sailwave] sailwave@yahoogroups.com wrote:
Jon, I have edited it, but the excel spreadsheet that comes up when I run the series gives the attached error report.
Patrick
From: sailwave@yahoogroups.com [mailto:sailwave@yahoogroups.com]
Sent: 23 March 2015 16:53
To: sailwave@yahoogroups.com
Subject: Re: FW: [sailwave] Re: NHC question
Hi Patrick,
OK that looks good - so now you can edit it - Correct?
or have you already edited it ? What is not working?
Jon
Jon Eskdale
07976 709777
Skype “eskdale”
On 23 March 2015 at 16:42, Patrick Blaney patrick.blaney@phblaney.com [sailwave] sailwave@yahoogroups.com wrote:
Jon,
I know that I am being stupid but I still can’t make it work.
Snip 4 and 5 show what happens and the file extensions involved.
Patrick
From: sailwave@yahoogroups.com [mailto:sailwave@yahoogroups.com]
Sent: 23 March 2015 15:59
To: sailwave@yahoogroups.com
Subject: Re: FW: [sailwave] Re: NHC question
Hi Patrick,
You need to move it to the location shown in my previous post, and make sure that your global options are pointing to that location also.
With the new versions of windows (Since XP) you can’t edit files in the Program files folders and sub-directories without admin permissions or if you can it generates a phantom version of the file.
Any problems let me know.
Jon
Jon Eskdale
07976 709777
Skype “eskdale”
On 23 March 2015 at 15:48, Patrick Blaney patrick.blaney@phblaney.com [sailwave] sailwave@yahoogroups.com wrote:
Oops I forgot the other attachments, now included
From: Patrick Blaney
Sent: 23 March 2015 15:14
To: ‘sailwave@yahoogroups.com’
Subject: RE: [sailwave] Re: NHC question
Jon,
I am having difficulty in adding the additional cells on to the excel worksheet SWNHC3.xls
Firstly, the file was not in its default location, and I’m not sure why (I don’t recall setting any other default location – but maybe I did inadvertently?)
See Snip 1 for details
Then when I make the changes as you suggest I can’t save the file except in a different location and with a different name? I don’t appear to have administrator privileges.
See Snip 2 and 3 for details.
I may be just sufficiently unaware of the way to change these things that this, normal, step is beyond my excel abilities??
Grateful for any further help?
Thanks
Patrick
From: sailwave@yahoogroups.com [mailto:sailwave@yahoogroups.com]
Sent: 20 March 2015 11:15
To: sailwave@yahoogroups.com
Subject: Re: [sailwave] Re: NHC question
Hi Patrick
Not a big problem
First some background info
Sailwave is using a template SWNHC3.xls to specify the rules for the calculation This template by default is in Public Documents - Sailwave - Templates folder (C:\Users\Public\Documents\Sailwave\Templates) although you can change the folder in Sailwave - Setup - Global Options - Folders
First make a backup copy of this file then open it in Excel
Now lets assume you want to add another 10 lines
Click on the 9 of row 9 and while holding the button down move the mouse to 18 so that you have highlighted 10 rows as below
Now right click and select Copy
Now right click on the 19 and select Insert Copied Cells - see below
You have now inserted 10 more rows we just need to tell Sailwave that this template now has 10 more rows available. To do this click on the Config worksheet and change the SheetSize value from 40 to 50
Switch back to the Main sheet and select cell A4 (This is just a blank cell where the selection will appear when it runs) now save the modified sheet (must be SWNHC3.xls) and you are ready to go
The size of the sheet you use would depend upon you fleet size. It will work fine up to 200 boats but as you increase the size the spreadsheet gets larger and hence slower. Although the rows you copied look empty at first glance the cells do contain formulae.
Any problems please come back to me
Jon
Jon Eskdale
07976 709777
Skype “eskdale”
On 20 March 2015 at 08:24, Patrick Blaney patrick.blaney@gmail.com [sailwave] sailwave@yahoogroups.com wrote:
Jon and Sailwave experts
I have encountered a problem with NHC in external mode.
My list of competitors has finally crossed the line from 40 to 41, and I am getting an error message telling me to use a larger template?
I have no idea how to do this, I assume this is with the excel spreadsheet that comes with Sailwave helper, but that spreadsheet is blank.
I attach a screen grab of same??
What should I do?
Patrick
On 18 March 2015 at 14:21, Jon Eskdale jon@sailwave.com [sailwave] sailwave@yahoogroups.com wrote:
Hi Ian,
Just in case you didn’t see my earlier post - The problem you have is that you are using PY ratings - These are currently only supported in external mode
Jon
Jon Eskdale
07976 709777
Skype “eskdale”
On 18 March 2015 at 04:20, ian.grant12@gmail.com [sailwave] sailwave@yahoogroups.com wrote:
Hi Malcolm,
Thanks for sharing your insights.
For new entrants to a series who do not have an NHC rating from previous races, I have used PY as the default initial rating.
Given your observation I’ll use external mode.
Thanks,
Ian
Sent from my BlackBerry 10 smartphone.
From: Malcolm Osborne malcolmo@telkomsa.net [sailwave]
Sent: Wednesday, 18 March 2015 03:09
To: sailwave@yahoogroups.com
Reply To: sailwave@yahoogroups.com
Subject: Re: [sailwave] Re: NHC question
I had a similar query recently - Jon provided the answer - using Portsmouth ratings isn’t quite correct for NHC and the internal mode doesn’t cater for this. The external mode gives the correct figures (coverts correctly back to Portsmouth)
regards,
Malcolm Osborne
Sedgefield South Africa
On 2015/03/17 19:03, Ian Grant ian.grant12@gmail.com [sailwave] wrote:
Hi Jon,
Here is an example blw file which gives different race ratings in NHC external and internal modes. I have also included screen shots of the race ratings so you can see what I’m seeing…
I have also noticed that when I select “custom external” mode a message appears saying SWNHC4 is not found in the template directory.
I am using the latest version of SW downloaded from the web site last week.
Glad to have your insights–many thanks for your patience.
Kind regards,
Ian Grant.
On 17 March 2015 at 20:21, Jon Eskdale jon@sailwave.com [sailwave] sailwave@yahoogroups.com wrote:
Hi - Ian there should be no difference - if there is then there is something wrong. With the external mode you can see all the calculations.
If you could send me a blw that has different results then I will investigate and tell you why. May be if you could tell which is the first race that is different then it would give you a clue.
May be it is it the use of some scoring code?
Jon
Jon Eskdale
07976 709777
Skype “eskdale”
On 17 March 2015 at 16:13, ian.grant12@gmail.com [sailwave] sailwave@yahoogroups.com wrote:
I also have found NHC Internal Mode gives slightly different race ratings and corrected times than NHC External/custom mode. Curious why --and which mode is correct?
Ian Grant
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
Jon,
I’m trying to set up a personal handicap series dual scored with our normal Wednesday evening series. I think I have done it correctly (having looked back through some of the recent threads). I’m going to try a series using NHC mode set to external.
We have only had one race so far and when I click score series I don’t see the Excel helper dialogue box. Will this appear once we have another race? I was hoping I’d be able to calculate the next race ratings in advance and advertise them on our website. Is that possible?
The series file is getting slightly complicated as we need to score three ways, firstly as fleets, then all combined on PY, and then we wanted to do the personal handicap series based on the combined series scores. So I have set each competitor up in fleets, and also in another box (I used bow number) have given a PY type - eg RYA or PERSONAL. I have set competitor aliasing on, and set up the aliases. I have set the scoring system to be standard PY type for anything with bow number PY, and set to NHC external for anything with bow number of PERSONAL. I then score series and nothing seems to happen. I’m hoping that’s a good sign but the next race ratings haven’t been populated for the personal handicap series entries which i was hoping they would be.
If I sent the .blw file would you possibly be able to have a look and confirm whether I have gone about setting it all up in the correct way? There may be a box I haven’t ticked.
Many thanks in advance.
Chris Gandy
Draycote Water
Hi Chris,
Yes please send me the blw file as its much easier for me to check it with the file in front of me.
The Helper window should appear even if you only have one race. If it is in internal mode then it will only flash up very quickly although if you set it to external then it will stay there.
As for displaying the updated rating. If you are using the latest version then the new handicap can be displayed along with the results so yes this it will do exactly what you want
I’ll have a look at your file but for the current versions of NHC the fleets that you are using must be in the fleet column. I’m currently working on 2.18 which has some additional configuration in this area but that is not ready for release as yet
Jon
···
On 2 April 2015 at 08:02, Christopher Gandy chrisgandy@me.com [sailwave] sailwave@yahoogroups.com wrote:
Jon,
I’m trying to set up a personal handicap series dual scored with our normal Wednesday evening series. I think I have done it correctly (having looked back through some of the recent threads). I’m going to try a series using NHC mode set to external.
We have only had one race so far and when I click score series I don’t see the Excel helper dialogue box. Will this appear once we have another race? I was hoping I’d be able to calculate the next race ratings in advance and advertise them on our website. Is that possible?
The series file is getting slightly complicated as we need to score three ways, firstly as fleets, then all combined on PY, and then we wanted to do the personal handicap series based on the combined series scores. So I have set each competitor up in fleets, and also in another box (I used bow number) have given a PY type - eg RYA or PERSONAL. I have set competitor aliasing on, and set up the aliases. I have set the scoring system to be standard PY type for anything with bow number PY, and set to NHC external for anything with bow number of PERSONAL. I then score series and nothing seems to happen. I’m hoping that’s a good sign but the next race ratings haven’t been populated for the personal handicap series entries which i was hoping they would be.
If I sent the .blw file would you possibly be able to have a look and confirm whether I have gone about setting it all up in the correct way? There may be a box I haven’t ticked.
Many thanks in advance.
Chris Gandy
Draycote Water
Jon Eskdale
07976 709777
Skype “eskdale”
This is a repost with the missing images as the earlier forum doesn’t support the images
and this should be useful for users searching on NHC sheet size or number of competitors
Hi Patrick
Not a big problem
First some background info
Sailwave is using a template SWNHC3.xls to specify the rules for the calculation This template by default is in Public Documents - Sailwave - Templates folder (C:\Users\Public\Documents\Sailwave\Templates) although you can change the folder in Sailwave - Setup - Global Options - Folders
First make a backup copy of this file then open it in Excel
Now lets assume you want to add another 10 lines
Click on the 9 of row 9 and while holding the button down move the mouse to 18 so that you have highlighted 10 rows as below
Now right click and select Copy
Now right click on the 19 and select Insert Copied Cells - see below
You have now inserted 10 more rows we just need to tell Sailwave that this template now has 10 more rows available. To do this click on the Config worksheet and change the SheetSize value from 40 to 50
Switch back to the Main sheet and select cell A4 (This is just a blank cell where the selection will appear when it runs) now save the modified sheet (must be SWNHC3.xls) and you are ready to go
The size of the sheet you use would depend upon you fleet size. It will work fine up to 200 boats but as you increase the size the spreadsheet gets larger and hence slower. Although the rows you copied look empty at first glance the cells do contain formulae.
