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 > <mailto:patrick.blaney@phblaney.com> [sailwave] > <sailwave@yahoogroups.com <mailto: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 <mailto: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>
[mailto:sailwave@yahoogroups.com]
*Sent:* 20 March 2015 11:15
*To:* sailwave@yahoogroups.com <mailto: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 <tel:07976%20709777>
Skype "eskdale"
On 20 March 2015 at 08:24, Patrick Blaney patrick.blaney@gmail.com > <mailto:patrick.blaney@gmail.com> [sailwave] > <sailwave@yahoogroups.com <mailto: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 > <mailto:jon@sailwave.com> [sailwave] <sailwave@yahoogroups.com > <mailto: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 <tel:07976%20709777>
Skype "eskdale"
On 18 March 2015 at 04:20, ian.grant12@gmail.com > <mailto:ian.grant12@gmail.com> [sailwave] > <sailwave@yahoogroups.com > <mailto: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
<mailto:malcolmo@telkomsa.net> [sailwave]
*Sent: *Wednesday, 18 March 2015 03:09
*To: *sailwave@yahoogroups.com
<mailto:sailwave@yahoogroups.com>
*Reply To: *sailwave@yahoogroups.com
<mailto: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 > <mailto: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 <mailto:jon@sailwave.com> > [sailwave] <sailwave@yahoogroups.com > <mailto: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 <tel:07976%20709777>
Skype "eskdale"
On 17 March 2015 at 16:13, > ian.grant12@gmail.com > <mailto:ian.grant12@gmail.com> [sailwave] > <sailwave@yahoogroups.com > <mailto: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
------------------------------------------------------------------------
<http://www.avast.com/>
This email has been checked for viruses by Avast
antivirus software.
www.avast.com <http://www.avast.com/>
------------------------------------------------------------------------
<http://www.avast.com/>
This email has been checked for viruses by Avast
antivirus software.
www.avast.com <http://www.avast.com/>
------------------------------------------------------------------------
Avast logo <http://www.avast.com/>
This email has been checked for viruses by Avast antivirus software.
www.avast.com <http://www.avast.com/>
