Thanks Jon, that’s great. I will download and have a look ASAP.
Chris
···
On 15 Jun 2012, at 00:23, JON jon@eskdale.org wrote:
OK
There is description of the progam and a download link here
SWPH Personal Handicap
Let the Group or myself know if you think it will be useful and if you would like me to develop it further. Comments will be welcome - Good or Bad
Note this is a program for allowing Sailwave to support nearly any personal handicap system you derive it is not a solution to the rules for calculating personal handicaps. But it does allow anyone with Excel knowledge to change the handicapping system.
As to the other programs on the site I have updated most of them recently but not uploaded them to the site yet will try and find some time soon. Scoring again this weekend.
Jon
— In sailwave@yahoogroups.com, Art Engel <artengel123@…> wrote:
That would be great. I’ve wanted to see this for a while now.
Art
On
6/14/2012 5:49 AM, JON wrote:
Hi Chris,
Just to let you know I haven’t forgotten you. I have spent a couple of hours yesterday and the day before tidying the program up and adding some comments. Just writing some documentation which I hope to finish tonight and will let you all have a copy to pull apart and give some suggestions if you would like it developed further.
Jon
Hi Art,
Currently it just fetches the Default handicap and the Handicap for the race you are working on. But there is no reason, if You or the Group think bringing in previous race handicaps would be useful, that I can not add that feature to another column so you can then use it within your calculations. If we decide to add this, what would be the best solution a) to bring in all previous race handicaps or b) to create an average of the previous races? It is ideas like this which I look forward to hearing. As for ECHO it doesn't use any previous race information unless the spec has changed from last year. This program is capable of handling ECHO handicaps as it was the original reason for developing it.
Jon
···
--- In sailwave@yahoogroups.com, Art Engel <artengel123@...> wrote:
Jon,
Thanks so much. I will take a look in detail but one quick query -
Obviously, I can change the PH for the next race based on the last race
(that is what we do now) using whatever formula we want. Can we go back
and use say the last 2 or 3 race results instead? That is something we
probably would want to try as it undoubtedly has the potential for being
fairer with handicaps going up and down less each race. I think ECHO
might use a concept something like that.
Art
On 6/14/2012 4:23 PM, JON wrote:
> OK
>
> There is description of the progam and a download link here
>
> SWPH Personal Handicap
> <https://sites.google.com/site/eskdalesite/home/swph>
>
> Let the Group or myself know if you think it will be useful and if you
> would like me to develop it further. Comments will be welcome - Good or
> Bad
>
> Note this is a program for allowing Sailwave to support nearly any
> personal handicap system you derive it is not a solution to the rules
> for calculating personal handicaps. But it does allow anyone with Excel
> knowledge to change the handicapping system.
>
> As to the other programs on the site I have updated most of them
> recently but not uploaded them to the site yet will try and find some
> time soon. Scoring again this weekend.
>
> Jon
>
>
> --- In sailwave@yahoogroups.com, Art Engel<artengel123@> wrote:
>>
>> That would be great. I've wanted to see this for a while now.
>>
>> Art
>>
>> On 6/14/2012 5:49 AM, JON wrote:
>>> Hi Chris,
>>>
>>> Just to let you know I haven't forgotten you. I have spent a couple
> of hours yesterday and the day before tidying the program up and adding
> some comments. Just writing some documentation which I hope to finish
> tonight and will let you all have a copy to pull apart and give some
> suggestions if you would like it developed further.
>>>
>>> Jon
>>>
>>
>
>
What is the ‘user guide’ referred to and where can I find it?
Rgds
George Morris
···
----- Original Message -----
From:
Ken Durward
To: sailwave@yahoogroups.com
Sent: Friday, June 15, 2012 2:34 AM
Subject: RE: [sailwave] Re: New to Sailwave in Australia
Hi Jon,
As you know I have been trialling your program with SW for a few months now and fine tuning for our needs.
I thank you for your help and must say this latest user guide is going to be a great help to anyone new to it.
We are only a small club with a mixed fleet and not a lot of races in each series.
I re-entered our last season (2011-20120) races and played around with the settings to see what happened.
The results were good so have now formally included PH results for our current Winter Series .
Thank you for your assistance.
Ken Durward
Clayton Bay Boat Club
South Australia
From:
sailwave@yahoogroups.com [mailto:sailwave@yahoogroups.com] ** On Behalf Of** JON
Sent: Friday, 15 June 2012 8:53 AM
To:
sailwave@yahoogroups.com
Subject: [sailwave] Re: New to Sailwave in Australia
OK
There is description of the progam and a download link here
SWPH Personal Handicap
Let the Group or myself know if you think it will be useful and if you would like me to develop it further. Comments will be welcome - Good or Bad
Note this is a program for allowing Sailwave to support nearly any personal handicap system you derive it is not a solution to the rules for calculating personal handicaps. But it does allow anyone with Excel knowledge to change the handicapping system.
As to the other programs on the site I have updated most of them recently but not uploaded them to the site yet will try and find some time soon. Scoring again this weekend.
Jon
— In sailwave@yahoogroups.com, Art Engel <artengel123@…> wrote:
That would be great. I’ve wanted to see this for a while now.
Art
On 6/14/2012 5:49 AM, JON wrote:
Hi Chris,
Just to let you know I haven’t forgotten you. I have spent a couple of hours yesterday and the day before tidying the program up and adding some comments. Just writing some documentation which I hope to finish tonight and will let you all have a copy to pull apart and give some suggestions if you would like it developed further.
Jon
Hi George,
Earlier in the thread (message 12318) there is a link to the user guide and within that there is a link to the download page
but here it is again
SWPH Personal Handicap
Let us know if you have any suggestions
Jon
···
— In sailwave@yahoogroups.com, “George Morris” <gmorris@…> wrote:
What is the ‘user guide’ referred to and where can I find it?
Rgds
George Morris
----- Original Message -----
From: Ken Durward
To: sailwave@yahoogroups.com
Sent: Friday, June 15, 2012 2:34 AM
Subject: RE: [sailwave] Re: New to Sailwave in Australia
Hi Jon,
As you know I have been trialling your program with SW for a few months now and fine tuning for our needs.
I thank you for your help and must say this latest “user guide” is going to be a great help to anyone new to it.
We are only a small club with a mixed fleet and not a lot of races in each series.
I re-entered our last season (2011-20120) races and played around with the settings to see what happened.
The results were good so have now formally included PH results for our current Winter Series .
Thank you for your assistance.
Ken Durward
Clayton Bay Boat Club
South Australia
From: sailwave@yahoogroups.com [mailto:sailwave@yahoogroups.com] On Behalf Of JON
Sent: Friday, 15 June 2012 8:53 AM
To: sailwave@yahoogroups.com
Subject: [sailwave] Re: New to Sailwave in Australia
OK
There is description of the progam and a download link here
SWPH Personal Handicap
Let the Group or myself know if you think it will be useful and if you would like me to develop it further. Comments will be welcome - Good or Bad
Note this is a program for allowing Sailwave to support nearly any personal handicap system you derive it is not a solution to the rules for calculating personal handicaps. But it does allow anyone with Excel knowledge to change the handicapping system.
As to the other programs on the site I have updated most of them recently but not uploaded them to the site yet will try and find some time soon. Scoring again this weekend.
Jon
— In sailwave@yahoogroups.com, Art Engel artengel123@ wrote:
That would be great. I’ve wanted to see this for a while now.
Art
On 6/14/2012 5:49 AM, JON wrote:
Hi Chris,
Just to let you know I haven’t forgotten you. I have spent a couple of hours yesterday and the day before tidying the program up and adding some comments. Just writing some documentation which I hope to finish tonight and will let you all have a copy to pull apart and give some suggestions if you would like it developed further.
Jon
Jon,
Ahhhhh…misunderstanding. I thought we were talking about a user guide to sailwave in general. Excel? Never touch it! Dreadful program!
Rgds
George ‘you can always use a pencil and paper if it’s easier’ Morris
···
----- Original Message -----
From:
JON
To: sailwave@yahoogroups.com
Sent: Friday, June 15, 2012 10:54 AM
Subject: [sailwave] Re: New to Sailwave in Australia
Hi George,
Earlier in the thread (message 12318) there is a link to the user guide and within that there is a link to the download page
but here it is again
SWPH Personal Handicap
Let us know if you have any suggestions
Jon
— In sailwave@yahoogroups.com , “George Morris” <gmorris@…> wrote:
What is the ‘user guide’ referred to and where can I find it?
Rgds
George Morris
----- Original Message -----
From: Ken Durward
To: sailwave@yahoogroups.com
Sent: Friday, June 15, 2012 2:34 AM
Subject: RE: [sailwave] Re: New to Sailwave in Australia
Hi Jon,
As you know I have been trialling your program with SW for a few months now and fine tuning for our needs.
I thank you for your help and must say this latest “user guide” is going to be a great help to anyone new to it.
We are only a small club with a mixed fleet and not a lot of races in each series.
I re-entered our last season (2011-20120) races and played around with the settings to see what happened.
The results were good so have now formally included PH results for our current Winter Series .
Thank you for your assistance.
Ken Durward
Clayton Bay Boat Club
South Australia
From: sailwave@yahoogroups.com [mailto:sailwave@yahoogroups.com] On Behalf Of JON
Sent: Friday, 15 June 2012 8:53 AM
To: sailwave@yahoogroups.com
Subject: [sailwave] Re: New to Sailwave in Australia
OK
There is description of the progam and a download link here
SWPH Personal Handicap
Let the Group or myself know if you think it will be useful and if you would like me to develop it further. Comments will be welcome - Good or Bad
Note this is a program for allowing Sailwave to support nearly any personal handicap system you derive it is not a solution to the rules for calculating personal handicaps. But it does allow anyone with Excel knowledge to change the handicapping system.
As to the other programs on the site I have updated most of them recently but not uploaded them to the site yet will try and find some time soon. Scoring again this weekend.
Jon
— In sailwave@yahoogroups.com, Art Engel artengel123@ wrote:
That would be great. I’ve wanted to see this for a while now.
Art
On 6/14/2012 5:49 AM, JON wrote:
Hi Chris,
Just to let you know I haven’t forgotten you. I have spent a couple of hours yesterday and the day before tidying the program up and adding some comments. Just writing some documentation which I hope to finish tonight and will let you all have a copy to pull apart and give some suggestions if you would like it developed further.
Jon
For a Sailwave guide, the best available is the ABYC version.
Look at [http://www.abyc.org/upload/Sailwave_ABYC_User_Guide.pdf](http://www.abyc.org/upload/Sailwave_ABYC_User_Guide.pdf)
···
regards,
Malcolm Osborne
Sedgefield South Africa
Jon,
Ahhhhh.....misunderstanding.
I thought we were talking about a user guide to sailwave
in general. Excel? Never touch it! Dreadful program!
Rgds
George 'you can always use
a pencil and paper if it’s easier’ Morris
----- Original Message
From:
JON
To: sailwave@yahoogroups.com
Sent: Friday, June
15, 2012 10:54 AM
Subject: [sailwave]
Re: New to Sailwave in Australia
Hi George,
Earlier in the thread (message 12318) there is a
link to the user guide and within that there is a link
to the download page
but here it is again
SWPH
Personal Handicap
Let us know if you have any suggestions
Jon
— In sailwave@yahoogroups.com ,
“George Morris” wrote:
What is the ‘user guide’ referred to and where
can I find it?
Rgds
George Morris
----- Original Message ----- > From: Ken Durward > To: > Sent: Friday, June 15, 2012 2:34 AM
Subject: RE: [sailwave] Re: New to Sailwave in
Australia
Hi Jon,
As you know I have been trialling your program
with SW for a few months now and fine tuning for our
needs.
I thank you for your help and must say this
latest “user guide” is going to be a great help to
anyone new to it.
We are only a small club with a mixed fleet and
not a lot of races in each series.
I re-entered our last season (2011-20120) races
and played around with the settings to see what
happened.
The results were good so have now formally
included PH results for our current Winter Series .
Thank you for your assistance.
Ken Durward
Clayton Bay Boat Club
South Australia
From: [] On Behalf Of JON
Sent: Friday, 15 June 2012 8:53 AM
To: > Subject: [sailwave] Re: New to Sailwave in
Australia
OK
There is description of the progam and a download
link here
SWPH Personal Handicap > > Let the Group or myself know if you think it will
be useful and if you would like me to develop it
further. Comments will be welcome - Good or Bad
Note this is a program for allowing Sailwave to
support nearly any personal handicap system you derive
it is not a solution to the rules for calculating
personal handicaps. But it does allow anyone with
Excel knowledge to change the handicapping system.
As to the other programs on the site I have
updated most of them recently but not uploaded them to
the site yet will try and find some time soon. Scoring
again this weekend.
Jon
— In , Art Engel
artengel123@ wrote:
That would be great. I’ve wanted to see this
for a while now.
Art
On 6/14/2012 5:49 AM, JON wrote:
Hi Chris,
Just to let you know I haven’t
forgotten you. I have spent a couple of hours
yesterday and the day before tidying the program up
and adding some comments. Just writing some
documentation which I hope to finish tonight and will
let you all have a copy to pull apart and give some
suggestions if you would like it developed further.
Jon
<gmorris@…>
sailwave@yahoogroups.com
sailwave@yahoogroups.commailto:sailwave@yahoogroups.com
sailwave@yahoogroups.com
sailwave@yahoogroups.com
Just the 86 pages - that should keep me out of the pub for a while!
Thanks v much
George Morris
···
----- Original Message -----
From:
Malcolm Osborne
To: sailwave@yahoogroups.com
Sent: Friday, June 15, 2012 5:48 PM
Subject: Re: [sailwave] Re: New to Sailwave in Australia
For a Sailwave guide, the best available is the ABYC version.
Look at http://www.abyc.org/upload/Sailwave_ABYC_User_Guide.pdf
regards,
Malcolm Osborne
Sedgefield South Africa
On 2012/06/15 12:40, George Morris wrote:
Jon,
Ahhhhh.....misunderstanding. I thought we were talking about a user guide to sailwave in general. Excel? Never touch it! Dreadful program!
Rgds
George 'you can always use a pencil and paper if it's easier' Morris
----- Original Message -----
From: JON
To: sailwave@yahoogroups.com
Sent: Friday, June 15, 2012 10:54 AM
Subject: [sailwave] Re: New to Sailwave in Australia
Hi George,
Earlier in the thread (message 12318) there is a link to the user guide and within that there is a link to the download page
but here it is again
SWPH Personal Handicap
Let us know if you have any suggestions
Jon
— In sailwave@yahoogroups.com, “George Morris” <gmorris@…> wrote:
What is the ‘user guide’ referred to and where can I find it?
Rgds
George Morris
----- Original Message -----
From: Ken Durward
To: sailwave@yahoogroups.com
Sent: Friday, June 15, 2012 2:34 AM
Subject: RE: [sailwave] Re: New to Sailwave in Australia
Hi Jon,
As you know I have been trialling your program with SW for a few months now and fine tuning for our needs.
I thank you for your help and must say this latest “user guide” is going to be a great help to anyone new to it.
We are only a small club with a mixed fleet and not a lot of races in each series.
I re-entered our last season (2011-20120) races and played around with the settings to see what happened.
The results were good so have now formally included PH results for our current Winter Series .
Thank you for your assistance.
Ken Durward
Clayton Bay Boat Club
South Australia
From: sailwave@yahoogroups.com [mailto:sailwave@yahoogroups.com ] On Behalf Of JON
Sent: Friday, 15 June 2012 8:53 AM
To: sailwave@yahoogroups.com
Subject: [sailwave] Re: New to Sailwave in Australia
OK
There is description of the progam and a download link here
SWPH Personal Handicap
Let the Group or myself know if you think it will be useful and if you would like me to develop it further. Comments will be welcome - Good or Bad
Note this is a program for allowing Sailwave to support nearly any personal handicap system you derive it is not a solution to the rules for calculating personal handicaps. But it does allow anyone with Excel knowledge to change the handicapping system.
As to the other programs on the site I have updated most of them recently but not uploaded them to the site yet will try and find some time soon. Scoring again this weekend.
Jon
— In sailwave@yahoogroups.com , Art Engel artengel123@ wrote:
That would be great. I’ve wanted to see this for a while now.
Art
On 6/14/2012 5:49 AM, JON wrote:
Hi Chris,
Just to let you know I haven’t forgotten you. I have spent a couple of hours yesterday and the day before tidying the program up and adding some comments. Just writing some documentation which I hope to finish tonight and will let you all have a copy to pull apart and give some suggestions if you would like it developed further.
Jon