I am trying to set up sailwave for our club in Australia.
I understand most of settings.
Having trouble getting a Personal Handicap.
Does any one have a file set up with VYC yardstick and a Personal hadicap that I can use as a template to change?
I have tried to use alias but can't get the custom handicap to work.
Im struggling to understand how to do a personal handicap in sailwave too. Please could someone explain in simple steps. I have aliases sorted now and sort of understand BCR, but how do I get sailwave to apply different handicaps to all of the next races? What’s the best way to do a personal handicap, is it to average a BCR over “x” number of previous races? Can sailwave do this?
Chris
···
On 11 Jun 2012, at 00:21, darylstone355 darylstone355@yahoo.com.au wrote:
I am trying to set up sailwave for our club in Australia.
I understand most of settings.
Having trouble getting a Personal Handicap.
Does any one have a file set up with VYC yardstick and a Personal hadicap that I can use as a template to change?
I have tried to use alias but can’t get the custom handicap to work.
Im struggling to understand how to do a personal handicap in sailwave too. Please could someone explain in simple steps. I have aliases sorted now and sort of understand BCR, but how do I get sailwave to apply different handicaps to all of the next races?
Double click the relevant race result cell (typically this would be for the next race to be sailed) for the competitor in question, click the Rating Tab, then change the handicap (rating) to what you want, ticking the ‘Use until next race rating is specified box’ if you want that handicap to apply until you next change it.
What’s the best way to do a personal handicap, is it to average a BCR over “x” number of previous races?
How long have you got… IMHO no system (especially automatic ones) are perfect (just like any handicap racing, in fact)!
Lancing SC uses something like a golf handicap which is relatively fixed for the season. These are only changed when I, as handicapper, think that a handicap is ‘wrong’ based on analysing the normalised - to the mean - BCRs after each race. If someone keeps doing well or badly (that is, an outlier on the normalised BCR vs place graph) then I review their handicap.
Obviously not perfect, but as our Wednesday Evening PH series is (supposedly) a bit light hearted then I don’t get too many serious grumbles. I also calculate PY based results for those that are bothered (but only PH results get prizes).
Can sailwave do this?
AFAIK ‘no’: just calculates the BCRs
HTH
Mike,
Thanks, typing in the new handicap seems a straightforward but long winded way of giving a different handicap for each race. I was trying to do something clever with the “assign personal handicap” function found under the tools menu. Anyone used this successfully?
Chris
···
On 11 Jun 2012, at 14:15, Mike mike.croker@phonecoop.coop wrote:
— In sailwave@yahoogroups.com, Chris Gandy <chrisgandy@…> wrote:
Im struggling to understand how to do a personal handicap in sailwave too. Please could someone explain in simple steps. I have aliases sorted now and sort of understand BCR, but how do I get sailwave to apply different handicaps to all of the next races?
Double click the relevant race result cell (typically this would be for the next race to be sailed) for the competitor in question, click the Rating Tab, then change the handicap (rating) to what you want, ticking the ‘Use until next race rating is specified box’ if you want that handicap to apply until you next change it.
What’s the best way to do a personal handicap, is it to average a BCR over “x” number of previous races?
How long have you got… IMHO no system (especially automatic ones) are perfect (just like any handicap
racing, in fact)!
Lancing SC uses something like a golf handicap which is relatively fixed for the season. These are only changed when I, as handicapper, think that a handicap is ‘wrong’ based on analysing the normalised - to the mean - BCRs after each race. If someone keeps doing well or badly (that is, an outlier on the normalised BCR vs place graph) then I review their handicap.
Obviously not perfect, but as our Wednesday Evening PH series is (supposedly) a bit light hearted then I don’t get too many serious grumbles. I also calculate PY based results for those that are bothered (but only PH results get prizes).
Can sailwave do this?
AFAIK ‘no’: just calculates the BCRs
HTH
Mike
Lancing SC
Hi Daryl,
Welcome to Sailwave.
It is fairly easy to create a ratings file for use with Sailwave, it is basically a CSV file and the format is documented in the Sailwave Help pages. If you have difficulty I will create a VYC ratings file for you.
Jon Eskdale, another user of Sailwave here in the UK, has written a utility that will read data from a Sailwave .BLW file into Excel do various calculations and write the modified data back into the Sailwave .BLW file. He did this initially for the ECHO rating system as used in Ireland, but I think he has a version that will calculate Personal Handicaps.
I expect Jon will reply himself, but it may be a short while as he may be busy back at work after we were scoring at 2012 Skandia Sail for Gold Regatta here in the UK last week.
Kind regards,
Huw
···
--- In sailwave@yahoogroups.com, "darylstone355" <darylstone355@...> wrote:
I am trying to set up sailwave for our club in Australia.
I understand most of settings.
Having trouble getting a Personal Handicap.
Does any one have a file set up with VYC yardstick and a Personal hadicap that I can use as a template to change?
I have tried to use alias but can't get the custom handicap to work.
Hi
I too have tried to get Sailwave to work
on Personal handicaps and have found a solution but it currently involves using
another Excel based program to modify the handicap after each race.
I have set up a new race file using the
“set-up” / User interface then activating the box beside
”Competitor Aliasing”.
This will open a tab on the Helm Set up
page. (this Alias tap will not appear until you activate it as above!
Then I have input each competitor and
assigned them to a “Fleet” which I have called STD as this will
have the Elapsed times from the Handicap Race.
All the non handicap performances will be
put into this fleet.
I then used the “New Like”
button to duplicate this competitor BUT assigned them to another fleet which I
called “PH” (personal handicap). Then opening the Alias tap
on the “Edit Competitor” option and using the drop down menu select
the corresponding helm in the STD fleet. This sets up the Alias as being
in the PH fleet.
When you have done that, you must ensure
that there is a column called “Fleet” so you can see what you are
doing.
Once you have done this you MUST only
imput the elapsed times for each race into STD (non Alias) fleet helms.
(best to sort the Fleet column so they are all together. You will see
that every time you put the times into the STD the Alias in PH fleet gets the
same time.
Sailwave will now score the 2 fleets
separately IF you activate the “Score Series” button and THEN
activate the lower button “Score groups of competitors separately –
scoring system is applied to each group” . Using the drop down box
in the “Grouping Field” and choose “Fleets” because you
have differentiated your normal and alias competitors by using fleet STD and
PH.
Complete the Score Series action to
confirm that it works although at this stage both fleets will get the same
time.#
I used PY to obtain the “Corrected
Time”.
This is when I have to use my offline
excel spreadsheet except for the start of the series. What we have done
is to give each helm a percentage rating. !00% being the “average”
helm and 90% being a very good helm and similarly 110% or even 120% for a
novice. We then multiply the boat PY by the handicap percentage to come
up with a “Rating” for that race. Eg. Solo PY is 1150
but a good sailor with a Personal Handicap of 90% will be given a rating of
1035
Now you can enter this new Rating if you
go to the race result of the PH fleet helm and right click and choose “Edit
result” then choose Rating from the 3 tabs offered at the top.
Then in the bottom box entitled “Race
Rating” put in the new personal handicap rating. Eg for our Solo
sailor it will be 1035 then tick the “use until next race rating specified”
box.
If you do this for all your competitors in
the PH fleet and press Score Series with the Grouping Field specified and you
will have, on, the same page / screen a set of results for normal handicap
racing (STD Fleet) and a set of results reflecting the personal handicap you
have given them (PH Fleet).
We give good sailors very difficult to win
handicaps and poorer sailors easier to win scores. The premise is that the good
sailors will win the std trophies and the novices will win the PH
trophies. (in practice this does not always happen!)
Regards
Brian
Tel +44 (0)1344-761642
Mobile +44 (0)7711-796125
···
From:
sailwave@yahoogroups.com [mailto:sailwave@yahoogroups.com] On Behalf Of darylstone355
Sent: 11 June 2012 00:21
To: sailwave@yahoogroups.com
Subject: [sailwave] New to
Sailwave in Australia
I am trying to set up sailwave for our club in Australia.
I understand most of settings.
Having trouble getting a Personal Handicap.
Does any one have a file set up with VYC yardstick and a Personal hadicap that
I can use as a template to change?
I have tried to use alias but can’t get the custom handicap to work.
Brian,
Thanks for the details. I am sort of doing similar to you, except I don’t have the spreadsheet part.
So this is what I have done:
Up to creating the aliases for the personal handicap series is the same as you have done.
However, then I have entered the original handicap in the first race rating box. I have ticked use this until next rating specified.
I then went to the tool menu and used assign personal handicaps. In this box there are various options, and I used the select competitors to specify the personal handicap fleet. In the expression box I have then used prevbcr*0.9 . The original expression did not work and kept coming up with an error. In my mind this then populates the race ratings with the BCR from the previous race. Now I’, not entirely sure how this is calculated in sailwave but I’m assuming it is the rating required to have everyone finish equal in the previous race. The 0.9 was in the original expression. Is it a good idea to maintain this? The prevbcr is supposed to ignore dnf’s and dnc’s so anyone that doesn’t take part in race 1, should maintain the original handicap until whichever race it is that they joined in with the series.
I then applied the expression to all races except race 1 as this is the basis for all the original BCR’s.
I then rescored using the score competitors in groups button.
Seem to end up with a slightly muddled order so it must do something. I just need to find out more about the BCR expression and how it is worked out. So not sure if it is a valid personal handicap system, but seems to mean that sailwave does it all. Would anyone have a personal handicap equation that they use that they wouldn’t mind sharing. Do any clubs calculate personal handicaps based on actual race result timings or are they all based on guesswork?
Hope that helps someone. A bit more work to do yet….
Chris
···
From: sailwave@yahoogroups.com [mailto:sailwave@yahoogroups.com] On Behalf Of Brian Welham
Sent: 11 June 2012 19:03
To: sailwave@yahoogroups.com
Subject: [sailwave] Personal Handicaps
Hi
I too have tried to get Sailwave to work on Personal handicaps and have found a solution but it currently involves using another Excel based program to modify the handicap after each race.
I have set up a new race file using the “set-up” / User interface then activating the box beside ”Competitor Aliasing”.
This will open a tab on the Helm Set up page. (this Alias tap will not appear until you activate it as above!
Then I have input each competitor and assigned them to a “Fleet” which I have called STD as this will have the Elapsed times from the Handicap Race.
All the non handicap performances will be put into this fleet.
I then used the “New Like” button to duplicate this competitor BUT assigned them to another fleet which I called “PH” (personal handicap). Then opening the Alias tap on the “Edit Competitor” option and using the drop down menu select the corresponding helm in the STD fleet. This sets up the Alias as being in the PH fleet.
When you have done that, you must ensure that there is a column called “Fleet” so you can see what you are doing.
Once you have done this you MUST only imput the elapsed times for each race into STD (non Alias) fleet helms. (best to sort the Fleet column so they are all together. You will see that every time you put the times into the STD the Alias in PH fleet gets the same time.
Sailwave will now score the 2 fleets separately IF you activate the “Score Series” button and THEN activate the lower button “Score groups of competitors separately – scoring system is applied to each group” . Using the drop down box in the “Grouping Field” and choose “Fleets” because you have differentiated your normal and alias competitors by using fleet STD and PH.
Complete the Score Series action to confirm that it works although at this stage both fleets will get the same time.#
I used PY to obtain the “Corrected Time”.
This is when I have to use my offline excel spreadsheet except for the start of the series. What we have done is to give each helm a percentage rating. !00% being the “average” helm and 90% being a very good helm and similarly 110% or even 120% for a novice. We then multiply the boat PY by the handicap percentage to come up with a “Rating” for that race. Eg. Solo PY is 1150 but a good sailor with a Personal Handicap of 90% will be given a rating of 1035
Now you can enter this new Rating if you go to the race result of the PH fleet helm and right click and choose “Edit result” then choose Rating from the 3 tabs offered at the top.
Then in the bottom box entitled “Race Rating” put in the new personal handicap rating. Eg for our Solo sailor it will be 1035 then tick the “use until next race rating specified” box.
If you do this for all your competitors in the PH fleet and press Score Series with the Grouping Field specified and you will have, on, the same page / screen a set of results for normal handicap racing (STD Fleet) and a set of results reflecting the personal handicap you have given them (PH Fleet).
We give good sailors very difficult to win handicaps and poorer sailors easier to win scores. The premise is that the good sailors will win the std trophies and the novices will win the PH trophies. (in practice this does not always happen!)
Regards
Brian
Tel +44 (0)1344-761642
Mobile +44 (0)7711-796125
From: sailwave@yahoogroups.com [mailto:sailwave@yahoogroups.com] On Behalf Of darylstone355
Sent: 11 June 2012 00:21
To: sailwave@yahoogroups.com
Subject: [sailwave] New to Sailwave in Australia
I am trying to set up sailwave for our club in Australia.
I understand most of settings.
Having trouble getting a Personal Handicap.
Does any one have a file set up with VYC yardstick and a Personal hadicap that I can use as a template to change?
I have tried to use alias but can’t get the custom handicap to work.
I have been scoring a series using personal handicaps allocated to specific races. Would someone remind me how permanent these handicaps are? If a boat has been scored in three successive races using handicaps of 1000, 1005 and 1010 using the facility on the tools menu and I inadvertently press the rescore button, does this affect previous races or are the handicaps for those races ‘saved’ in some way? And how can I view the handicaps viewed for previous races?
Rgds
George Morris
I have been scoring a series using personal handicaps allocated to specific races. Would someone remind me how permanent these handicaps are?
AFAIK, ‘permanent’ unless you change something (e.g. un-tick ‘use this until the next race rating is specified’ box)
If a boat has been scored in three successive races using handicaps of 1000, 1005 and 1010 using the facility on the tools menu
What facility - the ‘Assign Personal Handicaps’ one? Not clear to me how this works…
and I inadvertently press the rescore button, does this affect previous races or are the handicaps for those races ‘saved’ in some way?
I’ve not used the ‘Assign Personal Handicaps’ tool but, again AFAIK, each race result ‘cell’ contains the info used to calculate the result for that competitor in the race in question, and you can only change the contents of that cell by changing something that affects the cell contents, such as the tick box mentioned above: the change(s) taking place when you rescore. Best idea is to construct a mini-series and play…
And how can I view the handicaps viewed for previous races?
Used for previous races? Double click the relevant results cell and click the Ratings tab.
HTH
Hi,
As Huw mentioned I have written a utility originally to allow the ECHO personal handicap system with Sailwave. However it is not dedicated to Echo as it could be adapted to any Personal Handicap system.
Fundamentally it is very simple.
Sailwave has the ability to have each race calculated using a different handicap. The bit it doesn't have (because there are currently no hard and fast rules on calculating personal handicaps) is to adjust this for the next race based on your rules.
So my solution is
At the click of a button my app it will read all the details of the specified race from sailwave into an excel spreadsheet (Some people may find this alone very useful). The spreadsheet is preloaded with the formula you wish to use for your personal handicap system (you do this part based on how you want your handicap calculated) and excel calculates the revised personal handicap.
At the click of a second button you write the new handicaps back into the next race for Sailwave.
That bit is simple.
The problem is typically you only want to apply this to boats that racing under the personal handicap system.
I currently have two versions of this app:-
one that selects only the boats that have the word "ECHO" in their class/fleet and the other which works on all boats.
I'm open to suggestions as to how people would like me to develop this further which I very willing to do if anyone has any requirements. Please let me know.
I'll try tonight to put together a simplified version that anyone interested can play with.
Jon
···
--- In sailwave@yahoogroups.com, "huwp2001" <huw.pearce@...> wrote:
Hi Daryl,
Welcome to Sailwave.
It is fairly easy to create a ratings file for use with Sailwave, it is basically a CSV file and the format is documented in the Sailwave Help pages. If you have difficulty I will create a VYC ratings file for you.
Jon Eskdale, another user of Sailwave here in the UK, has written a utility that will read data from a Sailwave .BLW file into Excel do various calculations and write the modified data back into the Sailwave .BLW file. He did this initially for the ECHO rating system as used in Ireland, but I think he has a version that will calculate Personal Handicaps.
I expect Jon will reply himself, but it may be a short while as he may be busy back at work after we were scoring at 2012 Skandia Sail for Gold Regatta here in the UK last week.
Kind regards,
Huw
--- In sailwave@yahoogroups.com, "darylstone355" <darylstone355@> wrote:
>
> I am trying to set up sailwave for our club in Australia.
> I understand most of settings.
> Having trouble getting a Personal Handicap.
> Does any one have a file set up with VYC yardstick and a Personal hadicap that I can use as a template to change?
> I have tried to use alias but can't get the custom handicap to work.
>
Jon,
I would be interested in looking at your spreadsheet if at all possible.
You say sailwave doesn’t have the ability to apply the handicap to the next race but is that not what assign personal handicaps under tool menu does?
Or is this option within sailwave too restricted in types of formula it can use?
Chris
···
On 12 Jun 2012, at 11:01, JON jon@eskdale.org wrote:
Hi,
As Huw mentioned I have written a utility originally to allow the ECHO personal handicap system with Sailwave. However it is not dedicated to Echo as it could be adapted to any Personal Handicap system.
Fundamentally it is very simple.
Sailwave has the ability to have each race calculated using a different handicap. The bit it doesn’t have (because there are currently no hard and fast rules on calculating personal handicaps) is to adjust this for the next race based on your rules.
So my solution is
At the click of a button my app it will read all the details of the specified race from sailwave into an excel spreadsheet (Some people may find this alone very useful). The spreadsheet is preloaded with the formula you wish to use for your personal handicap system (you do this part based on how you want your handicap calculated) and excel calculates the revised personal handicap.
At the click of a second button you write the new handicaps back into the next race for Sailwave.That bit is simple.
The problem is typically you only want to apply this to boats that racing under the personal handicap system.
I currently have two versions of this app:-
one that selects only the boats that have the word “ECHO” in their class/fleet and the other which works on all boats.I’m open to suggestions as to how people would like me to develop this further which I very willing to do if anyone has any requirements. Please let me know.
I’ll try tonight to put together a simplified version that anyone interested can play with.
Jon
— In sailwave@yahoogroups.com, “huwp2001” <huw.pearce@…> wrote:
Hi Daryl,
Welcome to Sailwave.
It is fairly easy to create a ratings file for use with Sailwave, it is basically a CSV file and the format is documented in the Sailwave Help pages. If you have difficulty I will create a VYC ratings file for you.
Jon Eskdale, another user of Sailwave here in the UK, has written a utility that will read data from a Sailwave .BLW file into Excel do various calculations and write the modified data back into the Sailwave .BLW file. He did this initially for the ECHO rating system as used in Ireland, but I think he has a version that will calculate Personal Handicaps.
I expect Jon will reply himself, but it may be a short while as he may be busy back at work after we were scoring at 2012 Skandia Sail for Gold Regatta here in the UK last week.
Kind regards,
Huw
— In sailwave@yahoogroups.com, “darylstone355” <darylstone355@> wrote:
I am trying to set up sailwave for our club in Australia.
I understand most of settings.
Having trouble getting a Personal Handicap.
Does any one have a file set up with VYC yardstick and a Personal hadicap that I can use as a template to change?
I have tried to use alias but can’t get the custom handicap to work.
This is a message for Colin really, but wondered if anyone else has the same problem....
I've been working on the personal handicap stuff on an ongoing series and last night we went past 10 races. The assign personal handicap box to individual races only appears to work up to 10 races. Is this correct? Is this the same for everyone else?
Chris
···
--- In sailwave@yahoogroups.com, Chris Gandy <chrisgandy@...> wrote:
Jon,
I would be interested in looking at your spreadsheet if at all possible.
You say sailwave doesn't have the ability to apply the handicap to the next race but is that not what assign personal handicaps under tool menu does?
Or is this option within sailwave too restricted in types of formula it can use?Chris
On 12 Jun 2012, at 11:01, JON <jon@...> wrote:
> Hi,
>
> As Huw mentioned I have written a utility originally to allow the ECHO personal handicap system with Sailwave. However it is not dedicated to Echo as it could be adapted to any Personal Handicap system.
>
> Fundamentally it is very simple.
>
> Sailwave has the ability to have each race calculated using a different handicap. The bit it doesn't have (because there are currently no hard and fast rules on calculating personal handicaps) is to adjust this for the next race based on your rules.
>
> So my solution is
>
> At the click of a button my app it will read all the details of the specified race from sailwave into an excel spreadsheet (Some people may find this alone very useful). The spreadsheet is preloaded with the formula you wish to use for your personal handicap system (you do this part based on how you want your handicap calculated) and excel calculates the revised personal handicap.
> At the click of a second button you write the new handicaps back into the next race for Sailwave.
>
> That bit is simple.
>
> The problem is typically you only want to apply this to boats that racing under the personal handicap system.
> I currently have two versions of this app:-
> one that selects only the boats that have the word "ECHO" in their class/fleet and the other which works on all boats.
>
> I'm open to suggestions as to how people would like me to develop this further which I very willing to do if anyone has any requirements. Please let me know.
>
> I'll try tonight to put together a simplified version that anyone interested can play with.
>
> Jon
>
> --- In sailwave@yahoogroups.com, "huwp2001" <huw.pearce@> wrote:
> >
> > Hi Daryl,
> >
> > Welcome to Sailwave.
> >
> > It is fairly easy to create a ratings file for use with Sailwave, it is basically a CSV file and the format is documented in the Sailwave Help pages. If you have difficulty I will create a VYC ratings file for you.
> >
> > Jon Eskdale, another user of Sailwave here in the UK, has written a utility that will read data from a Sailwave .BLW file into Excel do various calculations and write the modified data back into the Sailwave .BLW file. He did this initially for the ECHO rating system as used in Ireland, but I think he has a version that will calculate Personal Handicaps.
> >
> > I expect Jon will reply himself, but it may be a short while as he may be busy back at work after we were scoring at 2012 Skandia Sail for Gold Regatta here in the UK last week.
> >
> > Kind regards,
> >
> > Huw
> >
> > --- In sailwave@yahoogroups.com, "darylstone355" <darylstone355@> wrote:
> > >
> > > I am trying to set up sailwave for our club in Australia.
> > > I understand most of settings.
> > > Having trouble getting a Personal Handicap.
> > > Does any one have a file set up with VYC yardstick and a Personal hadicap that I can use as a template to change?
> > > I have tried to use alias but can't get the custom handicap to work.
> > >
> >
>
>
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
···
--- In sailwave@yahoogroups.com, Chris Gandy <chrisgandy@...> wrote:
Jon,
I would be interested in looking at your spreadsheet if at all possible.
You say sailwave doesn't have the ability to apply the handicap to the next race but is that not what assign personal handicaps under tool menu does?
Or is this option within sailwave too restricted in types of formula it can use?Chris
On 12 Jun 2012, at 11:01, JON <jon@...> wrote:
> Hi,
>
> As Huw mentioned I have written a utility originally to allow the ECHO personal handicap system with Sailwave. However it is not dedicated to Echo as it could be adapted to any Personal Handicap system.
>
> Fundamentally it is very simple.
>
> Sailwave has the ability to have each race calculated using a different handicap. The bit it doesn't have (because there are currently no hard and fast rules on calculating personal handicaps) is to adjust this for the next race based on your rules.
>
> So my solution is
>
> At the click of a button my app it will read all the details of the specified race from sailwave into an excel spreadsheet (Some people may find this alone very useful). The spreadsheet is preloaded with the formula you wish to use for your personal handicap system (you do this part based on how you want your handicap calculated) and excel calculates the revised personal handicap.
> At the click of a second button you write the new handicaps back into the next race for Sailwave.
>
> That bit is simple.
>
> The problem is typically you only want to apply this to boats that racing under the personal handicap system.
> I currently have two versions of this app:-
> one that selects only the boats that have the word "ECHO" in their class/fleet and the other which works on all boats.
>
> I'm open to suggestions as to how people would like me to develop this further which I very willing to do if anyone has any requirements. Please let me know.
>
> I'll try tonight to put together a simplified version that anyone interested can play with.
>
> Jon
>
> --- In sailwave@yahoogroups.com, "huwp2001" <huw.pearce@> wrote:
> >
> > Hi Daryl,
> >
> > Welcome to Sailwave.
> >
> > It is fairly easy to create a ratings file for use with Sailwave, it is basically a CSV file and the format is documented in the Sailwave Help pages. If you have difficulty I will create a VYC ratings file for you.
> >
> > Jon Eskdale, another user of Sailwave here in the UK, has written a utility that will read data from a Sailwave .BLW file into Excel do various calculations and write the modified data back into the Sailwave .BLW file. He did this initially for the ECHO rating system as used in Ireland, but I think he has a version that will calculate Personal Handicaps.
> >
> > I expect Jon will reply himself, but it may be a short while as he may be busy back at work after we were scoring at 2012 Skandia Sail for Gold Regatta here in the UK last week.
> >
> > Kind regards,
> >
> > Huw
> >
> > --- In sailwave@yahoogroups.com, "darylstone355" <darylstone355@> wrote:
> > >
> > > I am trying to set up sailwave for our club in Australia.
> > > I understand most of settings.
> > > Having trouble getting a Personal Handicap.
> > > Does any one have a file set up with VYC yardstick and a Personal hadicap that I can use as a template to change?
> > > I have tried to use alias but can't get the custom handicap to work.
> > >
> >
>
>
Love to see a copy
Mike Butterfield
···
From: JON
Sent: Thursday, June 14, 2012 1:49 PM
Subject: [sailwave] Re: New to Sailwave in Australia
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
— In mailto:sailwave%40yahoogroups.com, Chris Gandy <chrisgandy@…> wrote:
Jon,
I would be interested in looking at your spreadsheet if at all possible.
You say sailwave doesn’t have the ability to apply the handicap to the next race but is that not what assign personal handicaps under tool menu does?
Or is this option within sailwave too restricted in types of formula it can use?Chris
On 12 Jun 2012, at 11:01, JON <jon@…> wrote:
Hi,
As Huw mentioned I have written a utility originally to allow the ECHO personal handicap system with Sailwave. However it is not dedicated to Echo as it could be adapted to any Personal Handicap system.
Fundamentally it is very simple.
Sailwave has the ability to have each race calculated using a different handicap. The bit it doesn’t have (because there are currently no hard and fast rules on calculating personal handicaps) is to adjust this for the next race based on your rules.
So my solution is
At the click of a button my app it will read all the details of the specified race from sailwave into an excel spreadsheet (Some people may find this alone very useful). The spreadsheet is preloaded with the formula you wish to use for your personal handicap system (you do this part based on how you want your handicap calculated) and excel calculates the revised personal handicap.
At the click of a second button you write the new handicaps back into the next race for Sailwave.That bit is simple.
The problem is typically you only want to apply this to boats that racing under the personal handicap system.
I currently have two versions of this app:-
one that selects only the boats that have the word “ECHO” in their class/fleet and the other which works on all boats.I’m open to suggestions as to how people would like me to develop this further which I very willing to do if anyone has any requirements. Please let me know.
I’ll try tonight to put together a simplified version that anyone interested can play with.
Jon
— In mailto:sailwave%40yahoogroups.com, “huwp2001” <huw.pearce@> wrote:
Hi Daryl,
Welcome to Sailwave.
It is fairly easy to create a ratings file for use with Sailwave, it is basically a CSV file and the format is documented in the Sailwave Help pages. If you have difficulty I will create a VYC ratings file for you.
Jon Eskdale, another user of Sailwave here in the UK, has written a utility that will read data from a Sailwave .BLW file into Excel do various calculations and write the modified data back into the Sailwave .BLW file. He did this initially for the ECHO rating system as used in Ireland, but I think he has a version that will calculate Personal Handicaps.
I expect Jon will reply himself, but it may be a short while as he may be busy back at work after we were scoring at 2012 Skandia Sail for Gold Regatta here in the UK last week.
Kind regards,
Huw
— In mailto:sailwave%40yahoogroups.com, “darylstone355” <darylstone355@> wrote:
I am trying to set up sailwave for our club in Australia.
I understand most of settings.
Having trouble getting a Personal Handicap.
Does any one have a file set up with VYC yardstick and a Personal hadicap that I can use as a template to change?
I have tried to use alias but can’t get the custom handicap to work.
Yep, look forward to it. Thanks Jon.
Chris Gandy
···
On 14 Jun 2012, at 14:28, Patricia Butterfield pmbutterfield@msn.com wrote:
Love to see a copy
Mike Butterfield
From: JON
Sent: Thursday, June 14, 2012 1:49 PM
Subject: [sailwave] Re: New to Sailwave in Australia
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
— In mailto:sailwave%40yahoogroups.com, Chris Gandy <chrisgandy@…> wrote:
Jon,
I would be interested in looking at your spreadsheet if at all possible.
You say sailwave doesn’t have the ability to apply the handicap to the next race but is that not what assign personal handicaps under tool menu does?
Or is this option within sailwave too restricted in types of formula it can use?Chris
On 12 Jun 2012, at 11:01, JON <jon@…> wrote:
Hi,
As Huw mentioned I have written a utility originally to allow the ECHO personal handicap system with Sailwave. However it is not dedicated to Echo as it could be adapted to any Personal Handicap system.
Fundamentally it is very simple.
Sailwave has the ability to have each race calculated using a different handicap. The bit it doesn’t have (because there are currently no hard and fast rules on calculating personal handicaps) is to adjust this for the next race based on your rules.
So my solution is
At the click of a button my app it will read all the details of the specified race from sailwave into an excel spreadsheet (Some people may find this alone very useful). The spreadsheet is preloaded with the formula you wish to use for your personal handicap system (you do this part based on how you want your handicap calculated) and excel calculates the revised personal handicap.
At the click of a second button you write the new handicaps back into the next race for Sailwave.That bit is simple.
The problem is typically you only want to apply this to boats that racing under the personal handicap system.
I currently have two versions of this app:-
one that selects only the boats that have the word “ECHO” in their class/fleet and the other which works on all boats.I’m open to suggestions as to how people would like me to develop this further which I very willing to do if anyone has any requirements. Please let me know.
I’ll try tonight to put together a simplified version that anyone interested can play with.
Jon
— In mailto:sailwave%40yahoogroups.com, “huwp2001” <huw.pearce@> wrote:
Hi Daryl,
Welcome to Sailwave.
It is fairly easy to create a ratings file for use with Sailwave, it is basically a CSV file and the format is documented in the Sailwave Help pages. If you have difficulty I will create a VYC ratings file for you.
Jon Eskdale, another user of Sailwave here in the UK, has written a utility that will read data from a Sailwave .BLW file into Excel do various calculations and write the modified data back into the Sailwave .BLW file. He did this initially for the ECHO rating system as used in Ireland, but I think he has a version that will calculate Personal Handicaps.
I expect Jon will reply himself, but it may be a short while as he may be busy back at work after we were scoring at 2012 Skandia Sail for Gold Regatta here in the UK last week.
Kind regards,
Huw
— In mailto:sailwave%40yahoogroups.com, “darylstone355” <darylstone355@> wrote:
I am trying to set up sailwave for our club in Australia.
I understand most of settings.
Having trouble getting a Personal Handicap.
Does any one have a file set up with VYC yardstick and a Personal hadicap that I can use as a template to change?
I have tried to use alias but can’t get the custom handicap to work.
Me too please!
Stewart Berry
···
--- In sailwave@yahoogroups.com, Patricia Butterfield <pmbutterfield@...> wrote:
Love to see a copy
Mike Butterfield
From: JON
Sent: Thursday, June 14, 2012 1:49 PM
To: sailwave@yahoogroups.com
Subject: [sailwave] Re: New to Sailwave in AustraliaHi 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
--- In mailto:sailwave%40yahoogroups.com, Chris Gandy <chrisgandy@> wrote:
>
> Jon,
>
> I would be interested in looking at your spreadsheet if at all possible.
>
> You say sailwave doesn't have the ability to apply the handicap to the next race but is that not what assign personal handicaps under tool menu does?
> Or is this option within sailwave too restricted in types of formula it can use?
>
> Chris
>
> On 12 Jun 2012, at 11:01, JON <jon@> wrote:
>
> > Hi,
> >
> > As Huw mentioned I have written a utility originally to allow the ECHO personal handicap system with Sailwave. However it is not dedicated to Echo as it could be adapted to any Personal Handicap system.
> >
> > Fundamentally it is very simple.
> >
> > Sailwave has the ability to have each race calculated using a different handicap. The bit it doesn't have (because there are currently no hard and fast rules on calculating personal handicaps) is to adjust this for the next race based on your rules.
> >
> > So my solution is
> >
> > At the click of a button my app it will read all the details of the specified race from sailwave into an excel spreadsheet (Some people may find this alone very useful). The spreadsheet is preloaded with the formula you wish to use for your personal handicap system (you do this part based on how you want your handicap calculated) and excel calculates the revised personal handicap.
> > At the click of a second button you write the new handicaps back into the next race for Sailwave.
> >
> > That bit is simple.
> >
> > The problem is typically you only want to apply this to boats that racing under the personal handicap system.
> > I currently have two versions of this app:-
> > one that selects only the boats that have the word "ECHO" in their class/fleet and the other which works on all boats.
> >
> > I'm open to suggestions as to how people would like me to develop this further which I very willing to do if anyone has any requirements. Please let me know.
> >
> > I'll try tonight to put together a simplified version that anyone interested can play with.
> >
> > Jon
> >
> > --- In mailto:sailwave%40yahoogroups.com, "huwp2001" <huw.pearce@> wrote:
> > >
> > > Hi Daryl,
> > >
> > > Welcome to Sailwave.
> > >
> > > It is fairly easy to create a ratings file for use with Sailwave, it is basically a CSV file and the format is documented in the Sailwave Help pages. If you have difficulty I will create a VYC ratings file for you.
> > >
> > > Jon Eskdale, another user of Sailwave here in the UK, has written a utility that will read data from a Sailwave .BLW file into Excel do various calculations and write the modified data back into the Sailwave .BLW file. He did this initially for the ECHO rating system as used in Ireland, but I think he has a version that will calculate Personal Handicaps.
> > >
> > > I expect Jon will reply himself, but it may be a short while as he may be busy back at work after we were scoring at 2012 Skandia Sail for Gold Regatta here in the UK last week.
> > >
> > > Kind regards,
> > >
> > > Huw
> > >
> > > --- In mailto:sailwave%40yahoogroups.com, "darylstone355" <darylstone355@> wrote:
> > > >
> > > > I am trying to set up sailwave for our club in Australia.
> > > > I understand most of settings.
> > > > Having trouble getting a Personal Handicap.
> > > > Does any one have a file set up with VYC yardstick and a Personal hadicap that I can use as a template to change?
> > > > I have tried to use alias but can't get the custom handicap to work.
> > > >
> > >
> >
> >
>
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
OK
There is description of the progam and a download link here
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,
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
BadNote 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 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
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