Using Place instead of Rank in Custom Highpoint formula

Imported from Yahoo
1

Is it possible to use the place given instead of the calculated rank in the Custom HighPoint formula.

My challenge is that I have launched a liga where the boats of a specific boattype place in different races counts in a sort of liga for this boattype. My problem is that if the boat gets a 4th place and is the only one of this boat type in the race then the point should be calculated from the fourth place and not from the rank as number 1. Sailwave scoring gives it the rnak of 1 becaus i havent got any boats on 1st, 2nd and 3rd place.

My formula looks like this :

(ABS(1-INT(LOG10§))(100-10P)+10)(0.9+0.1r)

ABS(1-INT(LOG10§)) is a little trick to get the first part to count only for top 9 (Please introduce “IF” like in Excel).

100-10*P is the points given for the single race, and P should be 4 not 1 for a 4th place.

0.9+0.1*r is a bonus based on how many of the specific boat type that participates in the race.

···
2

I find an easier way to do my trick math by replacing

ABS(1-INT(LOG10§)) with (P<10) which gives 1 for values below 10 and 0 for values above. Sailwave rules the waves…

But I haven’t figured out how to solve my primary problem.

···

Mvh. Karsten Svenningsen

2014-05-19 20:50 GMT+02:00 karsten@svenningsenklanen.dk [sailwave] sailwave@yahoogroups.com:

Is it possible to use the place given instead of the calculated rank in the Custom HighPoint formula.

My challenge is that I have launched a liga where the boats of a specific boattype place in different races counts in a sort of liga for this boattype. My problem is that if the boat gets a 4th place and is the only one of this boat type in the race then the point should be calculated from the fourth place and not from the rank as number 1. Sailwave scoring gives it the rnak of 1 becaus i havent got any boats on 1st, 2nd and 3rd place.

My formula looks like this :

(ABS(1-INT(LOG10§))(100-10P)+10)(0.9+0.1r)

ABS(1-INT(LOG10§)) is a little trick to get the first part to count only for top 9 (Please introduce “IF” like in Excel).

100-10*P is the points given for the single race, and P should be 4 not 1 for a 4th place.

0.9+0.1*r is a bonus based on how many of the specific boat type that participates in the race.

3

Sailwave does in fact use Place but when sorting by group it
reranks/resorts the places. However as you guess, the original Place is
available, it would need adding as a variable. Jon has dominion over the
source code these days but I could point him at the relevant parts to
twiddle.

Cheers,
Colin J

http://sailwave.com

···

On Mon, May 19, 2014 at 9:05 PM, Karsten Svenningsen karsten@svenningsenklanen.dk [sailwave] <sailwave@yahoogroups.com> wrote:

I find an easier way to do my trick math by replacing

ABS(1-INT(LOG10(P))) with (P<10) which gives 1 for values below 10 and 0
for values above. Sailwave rules the waves....

But I haven't figured out how to solve my primary problem.

Mvh. Karsten Svenningsen

2014-05-19 20:50 GMT+02:00 karsten@svenningsenklanen.dk [sailwave] <
sailwave@yahoogroups.com>:

Is it possible to use the place given instead of the calculated rank in
the Custom HighPoint formula.

My challenge is that I have launched a liga where the boats of a specific
boattype place in different races counts in a sort of liga for this
boattype. My problem is that if the boat gets a 4th place and is the only
one of this boat type in the race then the point should be calculated from
the fourth place and not from the rank as number 1. Sailwave scoring gives
it the rnak of 1 becaus i havent got any boats on 1st, 2nd and 3rd place.

My formula looks like this :

(ABS(1-INT(LOG10(P)))*(100-10*P)+10)*(0.9+0.1*r)

ABS(1-INT(LOG10(P))) is a little trick to get the first part to count
only for top 9 (Please introduce "IF" like in Excel).

100-10*P is the points given for the single race, and P should be 4 not 1
for a 4th place.

0.9+0.1*r is a bonus based on how many of the specific boat type that
participates in the race.

4

It turns out, in the "global options->View’ Tab there is an option for Display ranks as 1st,2nd, 3rd etc instead of 1, 2, 3. So simply unticking that option fixed the Rank issue.

···

Sailwave does in fact use Place but when sorting by group it reranks/resorts the places. However as you guess, the original Place is available, it would need adding as a variable. Jon has dominion over the source code these days but I could point him at the relevant parts to twiddle.

Cheers,

Colin J

http://sailwave.com

On Mon, May 19, 2014 at 9:05 PM, Karsten Svenningsen karsten@svenningsenklanen.dk [sailwave] sailwave@yahoogroups.com wrote:

I find an easier way to do my trick math by replacing

ABS(1-INT(LOG10§)) with (P<10) which gives 1 for values below 10 and 0 for values above. Sailwave rules the waves…

But I haven’t figured out how to solve my primary problem.

Mvh. Karsten Svenningsen

2014-05-19 20:50 GMT+02:00 karsten@svenningsenklanen.dk [sailwave] sailwave@yahoogroups.com:

Is it possible to use the place given instead of the calculated rank in the Custom HighPoint formula.

My challenge is that I have launched a liga where the boats of a specific boattype place in different races counts in a sort of liga for this boattype. My problem is that if the boat gets a 4th place and is the only one of this boat type in the race then the point should be calculated from the fourth place and not from the rank as number 1. Sailwave scoring gives it the rnak of 1 becaus i havent got any boats on 1st, 2nd and 3rd place.

My formula looks like this :

(ABS(1-INT(LOG10§))(100-10P)+10)(0.9+0.1r)

ABS(1-INT(LOG10§)) is a little trick to get the first part to count only for top 9 (Please introduce “IF” like in Excel).

100-10*P is the points given for the single race, and P should be 4 not 1 for a 4th place.

0.9+0.1*r is a bonus based on how many of the specific boat type that participates in the race.

5

Hi and thanks for the response. It could be nice to have as a specific variable. I will look forward to a new version where it is implemented. Thanks in advance.

···

Mvh. Karsten Svenningsen

2014-05-20 12:58 GMT+02:00 Colin Jenkins colin@sailwave.com [sailwave] sailwave@yahoogroups.com:

Sailwave does in fact use Place but when sorting by group it reranks/resorts the places. However as you guess, the original Place is available, it would need adding as a variable. Jon has dominion over the source code these days but I could point him at the relevant parts to twiddle.

Cheers,

Colin J

http://sailwave.com

On Mon, May 19, 2014 at 9:05 PM, Karsten Svenningsen karsten@svenningsenklanen.dk [sailwave] sailwave@yahoogroups.com wrote:

I find an easier way to do my trick math by replacing

ABS(1-INT(LOG10§)) with (P<10) which gives 1 for values below 10 and 0 for values above. Sailwave rules the waves…

But I haven’t figured out how to solve my primary problem.

Mvh. Karsten Svenningsen

2014-05-19 20:50 GMT+02:00 karsten@svenningsenklanen.dk [sailwave] sailwave@yahoogroups.com:

Is it possible to use the place given instead of the calculated rank in the Custom HighPoint formula.

My challenge is that I have launched a liga where the boats of a specific boattype place in different races counts in a sort of liga for this boattype. My problem is that if the boat gets a 4th place and is the only one of this boat type in the race then the point should be calculated from the fourth place and not from the rank as number 1. Sailwave scoring gives it the rnak of 1 becaus i havent got any boats on 1st, 2nd and 3rd place.

My formula looks like this :

(ABS(1-INT(LOG10§))(100-10P)+10)(0.9+0.1r)

ABS(1-INT(LOG10§)) is a little trick to get the first part to count only for top 9 (Please introduce “IF” like in Excel).

100-10*P is the points given for the single race, and P should be 4 not 1 for a 4th place.

0.9+0.1*r is a bonus based on how many of the specific boat type that participates in the race.

6

OK - I modified the code such that there is another variable ‘q’ which passes the recorded position

But what happens with ties - what points are generated for these

Note there are “averaged ties” and “flat ties”

There is also the Test Expression to be updated which I haven’t done yet.

Jon

···

Jon Eskdale
Sailwave

03333 443377

07976 709777

On 20 May 2014 11:58, Colin Jenkins colin@sailwave.com [sailwave] sailwave@yahoogroups.com wrote:

Sailwave does in fact use Place but when sorting by group it reranks/resorts the places. However as you guess, the original Place is available, it would need adding as a variable. Jon has dominion over the source code these days but I could point him at the relevant parts to twiddle.

Cheers,

Colin J

http://sailwave.com

On Mon, May 19, 2014 at 9:05 PM, Karsten Svenningsen karsten@svenningsenklanen.dk [sailwave] sailwave@yahoogroups.com wrote:

I find an easier way to do my trick math by replacing

ABS(1-INT(LOG10§)) with (P<10) which gives 1 for values below 10 and 0 for values above. Sailwave rules the waves…

But I haven’t figured out how to solve my primary problem.

Mvh. Karsten Svenningsen

2014-05-19 20:50 GMT+02:00 karsten@svenningsenklanen.dk [sailwave] sailwave@yahoogroups.com:

Is it possible to use the place given instead of the calculated rank in the Custom HighPoint formula.

My challenge is that I have launched a liga where the boats of a specific boattype place in different races counts in a sort of liga for this boattype. My problem is that if the boat gets a 4th place and is the only one of this boat type in the race then the point should be calculated from the fourth place and not from the rank as number 1. Sailwave scoring gives it the rnak of 1 becaus i havent got any boats on 1st, 2nd and 3rd place.

My formula looks like this :

(ABS(1-INT(LOG10§))(100-10P)+10)(0.9+0.1r)

ABS(1-INT(LOG10§)) is a little trick to get the first part to count only for top 9 (Please introduce “IF” like in Excel).

100-10*P is the points given for the single race, and P should be 4 not 1 for a 4th place.

0.9+0.1*r is a bonus based on how many of the specific boat type that participates in the race.

7

Hi Karsten,

Have a try with this one - as I haven’t heard on the ties I’ve done the same as previously.

https://dl.dropboxusercontent.com/u/220425/SailwaveBeta/sailwave.exe

use the variable “q” for place - does it do what you need? - Let me know if it does and I’ll finish it off

Jon

···

Jon Eskdale
Sailwave

03333 443377

07976 709777

On 20 May 2014 13:40, Karsten Svenningsen karsten@svenningsenklanen.dk [sailwave] sailwave@yahoogroups.com wrote:

Hi and thanks for the response. It could be nice to have as a specific variable. I will look forward to a new version where it is implemented. Thanks in advance.

Mvh. Karsten Svenningsen

2014-05-20 12:58 GMT+02:00 Colin Jenkins colin@sailwave.com [sailwave] sailwave@yahoogroups.com:

Sailwave does in fact use Place but when sorting by group it reranks/resorts the places. However as you guess, the original Place is available, it would need adding as a variable. Jon has dominion over the source code these days but I could point him at the relevant parts to twiddle.

Cheers,

Colin J

http://sailwave.com

On Mon, May 19, 2014 at 9:05 PM, Karsten Svenningsen karsten@svenningsenklanen.dk [sailwave] sailwave@yahoogroups.com wrote:

I find an easier way to do my trick math by replacing

ABS(1-INT(LOG10§)) with (P<10) which gives 1 for values below 10 and 0 for values above. Sailwave rules the waves…

But I haven’t figured out how to solve my primary problem.

Mvh. Karsten Svenningsen

2014-05-19 20:50 GMT+02:00 karsten@svenningsenklanen.dk [sailwave] sailwave@yahoogroups.com:

Is it possible to use the place given instead of the calculated rank in the Custom HighPoint formula.

My challenge is that I have launched a liga where the boats of a specific boattype place in different races counts in a sort of liga for this boattype. My problem is that if the boat gets a 4th place and is the only one of this boat type in the race then the point should be calculated from the fourth place and not from the rank as number 1. Sailwave scoring gives it the rnak of 1 becaus i havent got any boats on 1st, 2nd and 3rd place.

My formula looks like this :

(ABS(1-INT(LOG10§))(100-10P)+10)(0.9+0.1r)

ABS(1-INT(LOG10§)) is a little trick to get the first part to count only for top 9 (Please introduce “IF” like in Excel).

100-10*P is the points given for the single race, and P should be 4 not 1 for a 4th place.

0.9+0.1*r is a bonus based on how many of the specific boat type that participates in the race.

8

Hi Jon

It works just as I dreamt off. So please include this feature in future versions of sailwave.

I have tested with the following fomula: ((q<11)(100-10q)+10)(0.9+0.1r)

regarding ties, it is not that important. I think it could be broken by maxpoint like lowpoint is broken on most 1. places 2nd place etc.

···

Mvh. Karsten Svenningsen

2014-05-21 10:28 GMT+02:00 Jon Eskdale jon@sailwave.com [sailwave] sailwave@yahoogroups.com:

Hi Karsten,

Have a try with this one - as I haven’t heard on the ties I’ve done the same as previously.

https://dl.dropboxusercontent.com/u/220425/SailwaveBeta/sailwave.exe

use the variable “q” for place - does it do what you need? - Let me know if it does and I’ll finish it off

Jon

Jon Eskdale
Sailwave

03333 443377

07976 709777

On 20 May 2014 13:40, Karsten Svenningsen karsten@svenningsenklanen.dk [sailwave] sailwave@yahoogroups.com wrote:

Hi and thanks for the response. It could be nice to have as a specific variable. I will look forward to a new version where it is implemented. Thanks in advance.

Mvh. Karsten Svenningsen

2014-05-20 12:58 GMT+02:00 Colin Jenkins colin@sailwave.com [sailwave] sailwave@yahoogroups.com:

Sailwave does in fact use Place but when sorting by group it reranks/resorts the places. However as you guess, the original Place is available, it would need adding as a variable. Jon has dominion over the source code these days but I could point him at the relevant parts to twiddle.

Cheers,

Colin J

http://sailwave.com

On Mon, May 19, 2014 at 9:05 PM, Karsten Svenningsen karsten@svenningsenklanen.dk [sailwave] sailwave@yahoogroups.com wrote:

I find an easier way to do my trick math by replacing

ABS(1-INT(LOG10§)) with (P<10) which gives 1 for values below 10 and 0 for values above. Sailwave rules the waves…

But I haven’t figured out how to solve my primary problem.

Mvh. Karsten Svenningsen

2014-05-19 20:50 GMT+02:00 karsten@svenningsenklanen.dk [sailwave] sailwave@yahoogroups.com:

Is it possible to use the place given instead of the calculated rank in the Custom HighPoint formula.

My challenge is that I have launched a liga where the boats of a specific boattype place in different races counts in a sort of liga for this boattype. My problem is that if the boat gets a 4th place and is the only one of this boat type in the race then the point should be calculated from the fourth place and not from the rank as number 1. Sailwave scoring gives it the rnak of 1 becaus i havent got any boats on 1st, 2nd and 3rd place.

My formula looks like this :

(ABS(1-INT(LOG10§))(100-10P)+10)(0.9+0.1r)

ABS(1-INT(LOG10§)) is a little trick to get the first part to count only for top 9 (Please introduce “IF” like in Excel).

100-10*P is the points given for the single race, and P should be 4 not 1 for a 4th place.

0.9+0.1*r is a bonus based on how many of the specific boat type that participates in the race.

9

OK - I’ve updated the app to 2.16.1 available here https://dl.dropboxusercontent.com/u/220425/sailwavebeta/sailwave.exe this now has the tool tips updated and the support for “q” in the test expression

Jon

···

Jon Eskdale
07976 709777

Skype “eskdale”

On 21 May 2014 21:45, Karsten Svenningsen karsten@svenningsenklanen.dk [sailwave] sailwave@yahoogroups.com wrote:

Hi Jon

It works just as I dreamt off. So please include this feature in future versions of sailwave.

I have tested with the following fomula: ((q<11)(100-10q)+10)(0.9+0.1r)

regarding ties, it is not that important. I think it could be broken by maxpoint like lowpoint is broken on most 1. places 2nd place etc.

Mvh. Karsten Svenningsen

2014-05-21 10:28 GMT+02:00 Jon Eskdale jon@sailwave.com [sailwave] sailwave@yahoogroups.com:

Hi Karsten,

Have a try with this one - as I haven’t heard on the ties I’ve done the same as previously.

https://dl.dropboxusercontent.com/u/220425/SailwaveBeta/sailwave.exe

use the variable “q” for place - does it do what you need? - Let me know if it does and I’ll finish it off

Jon

Jon Eskdale
Sailwave

03333 443377

07976 709777

On 20 May 2014 13:40, Karsten Svenningsen karsten@svenningsenklanen.dk [sailwave] sailwave@yahoogroups.com wrote:

Hi and thanks for the response. It could be nice to have as a specific variable. I will look forward to a new version where it is implemented. Thanks in advance.

Mvh. Karsten Svenningsen

2014-05-20 12:58 GMT+02:00 Colin Jenkins colin@sailwave.com [sailwave] sailwave@yahoogroups.com:

Sailwave does in fact use Place but when sorting by group it reranks/resorts the places. However as you guess, the original Place is available, it would need adding as a variable. Jon has dominion over the source code these days but I could point him at the relevant parts to twiddle.

Cheers,

Colin J

http://sailwave.com

On Mon, May 19, 2014 at 9:05 PM, Karsten Svenningsen karsten@svenningsenklanen.dk [sailwave] sailwave@yahoogroups.com wrote:

I find an easier way to do my trick math by replacing

ABS(1-INT(LOG10§)) with (P<10) which gives 1 for values below 10 and 0 for values above. Sailwave rules the waves…

But I haven’t figured out how to solve my primary problem.

Mvh. Karsten Svenningsen

2014-05-19 20:50 GMT+02:00 karsten@svenningsenklanen.dk [sailwave] sailwave@yahoogroups.com:

Is it possible to use the place given instead of the calculated rank in the Custom HighPoint formula.

My challenge is that I have launched a liga where the boats of a specific boattype place in different races counts in a sort of liga for this boattype. My problem is that if the boat gets a 4th place and is the only one of this boat type in the race then the point should be calculated from the fourth place and not from the rank as number 1. Sailwave scoring gives it the rnak of 1 becaus i havent got any boats on 1st, 2nd and 3rd place.

My formula looks like this :

(ABS(1-INT(LOG10§))(100-10P)+10)(0.9+0.1r)

ABS(1-INT(LOG10§)) is a little trick to get the first part to count only for top 9 (Please introduce “IF” like in Excel).

100-10*P is the points given for the single race, and P should be 4 not 1 for a 4th place.

0.9+0.1*r is a bonus based on how many of the specific boat type that participates in the race.

10

Hi Jon
You are encreddible. It works perfect. Thankyou.

BTW I have noteced thad the recently opened list the file menu only changes for no. 1. The other 9 are the same. It’s like they are not shifting down. It’s a minor thing so don’t hurry.

···

Mvh. Karsten Svenningsen

2014-05-22 0:09 GMT+02:00 Jon Eskdale jon@sailwave.com [sailwave] sailwave@yahoogroups.com:

OK - I’ve updated the app to 2.16.1 available here https://dl.dropboxusercontent.com/u/220425/sailwavebeta/sailwave.exe this now has the tool tips updated and the support for “q” in the test expression

Jon

Jon Eskdale
07976 709777

Skype “eskdale”

On 21 May 2014 21:45, Karsten Svenningsen karsten@svenningsenklanen.dk [sailwave] sailwave@yahoogroups.com wrote:

Hi Jon

It works just as I dreamt off. So please include this feature in future versions of sailwave.

I have tested with the following fomula: ((q<11)(100-10q)+10)(0.9+0.1r)

regarding ties, it is not that important. I think it could be broken by maxpoint like lowpoint is broken on most 1. places 2nd place etc.

Mvh. Karsten Svenningsen

2014-05-21 10:28 GMT+02:00 Jon Eskdale jon@sailwave.com [sailwave] sailwave@yahoogroups.com:

Hi Karsten,

Have a try with this one - as I haven’t heard on the ties I’ve done the same as previously.

https://dl.dropboxusercontent.com/u/220425/SailwaveBeta/sailwave.exe

use the variable “q” for place - does it do what you need? - Let me know if it does and I’ll finish it off

Jon

Jon Eskdale
Sailwave

03333 443377

07976 709777

On 20 May 2014 13:40, Karsten Svenningsen karsten@svenningsenklanen.dk [sailwave] sailwave@yahoogroups.com wrote:

Hi and thanks for the response. It could be nice to have as a specific variable. I will look forward to a new version where it is implemented. Thanks in advance.

Mvh. Karsten Svenningsen

2014-05-20 12:58 GMT+02:00 Colin Jenkins colin@sailwave.com [sailwave] sailwave@yahoogroups.com:

Sailwave does in fact use Place but when sorting by group it reranks/resorts the places. However as you guess, the original Place is available, it would need adding as a variable. Jon has dominion over the source code these days but I could point him at the relevant parts to twiddle.

Cheers,

Colin J

http://sailwave.com

On Mon, May 19, 2014 at 9:05 PM, Karsten Svenningsen karsten@svenningsenklanen.dk [sailwave] sailwave@yahoogroups.com wrote:

I find an easier way to do my trick math by replacing

ABS(1-INT(LOG10§)) with (P<10) which gives 1 for values below 10 and 0 for values above. Sailwave rules the waves…

But I haven’t figured out how to solve my primary problem.

Mvh. Karsten Svenningsen

2014-05-19 20:50 GMT+02:00 karsten@svenningsenklanen.dk [sailwave] sailwave@yahoogroups.com:

Is it possible to use the place given instead of the calculated rank in the Custom HighPoint formula.

My challenge is that I have launched a liga where the boats of a specific boattype place in different races counts in a sort of liga for this boattype. My problem is that if the boat gets a 4th place and is the only one of this boat type in the race then the point should be calculated from the fourth place and not from the rank as number 1. Sailwave scoring gives it the rnak of 1 becaus i havent got any boats on 1st, 2nd and 3rd place.

My formula looks like this :

(ABS(1-INT(LOG10§))(100-10P)+10)(0.9+0.1r)

ABS(1-INT(LOG10§)) is a little trick to get the first part to count only for top 9 (Please introduce “IF” like in Excel).

100-10*P is the points given for the single race, and P should be 4 not 1 for a 4th place.

0.9+0.1*r is a bonus based on how many of the specific boat type that participates in the race.

11

Hi Karsten,

Thanks for reminding me about the recently opened list - It does sometimes work and I had noticed it myself but keep forgetting to look into it. I guess its always been that way. Anyway you prompted me to fix it, so 2.16.2 available at https://dl.dropboxusercontent.com/u/220425/SailwaveBeta/sailwave.exe has it fixed (I hope)

Jon

···

Jon Eskdale
07976 709777

Skype “eskdale”

On 22 May 2014 07:17, Karsten Svenningsen karsten@svenningsenklanen.dk [sailwave] sailwave@yahoogroups.com wrote:

Hi Jon
You are encreddible. It works perfect. Thankyou.

BTW I have noteced thad the recently opened list the file menu only changes for no. 1. The other 9 are the same. It’s like they are not shifting down. It’s a minor thing so don’t hurry.

Mvh. Karsten Svenningsen

2014-05-22 0:09 GMT+02:00 Jon Eskdale jon@sailwave.com [sailwave] sailwave@yahoogroups.com:

OK - I’ve updated the app to 2.16.1 available here https://dl.dropboxusercontent.com/u/220425/sailwavebeta/sailwave.exe this now has the tool tips updated and the support for “q” in the test expression

Jon

Jon Eskdale
07976 709777

Skype “eskdale”

On 21 May 2014 21:45, Karsten Svenningsen karsten@svenningsenklanen.dk [sailwave] sailwave@yahoogroups.com wrote:

Hi Jon

It works just as I dreamt off. So please include this feature in future versions of sailwave.

I have tested with the following fomula: ((q<11)(100-10q)+10)(0.9+0.1r)

regarding ties, it is not that important. I think it could be broken by maxpoint like lowpoint is broken on most 1. places 2nd place etc.

Mvh. Karsten Svenningsen

2014-05-21 10:28 GMT+02:00 Jon Eskdale jon@sailwave.com [sailwave] sailwave@yahoogroups.com:

Hi Karsten,

Have a try with this one - as I haven’t heard on the ties I’ve done the same as previously.

https://dl.dropboxusercontent.com/u/220425/SailwaveBeta/sailwave.exe

use the variable “q” for place - does it do what you need? - Let me know if it does and I’ll finish it off

Jon

Jon Eskdale
Sailwave

03333 443377

07976 709777

On 20 May 2014 13:40, Karsten Svenningsen karsten@svenningsenklanen.dk [sailwave] sailwave@yahoogroups.com wrote:

Hi and thanks for the response. It could be nice to have as a specific variable. I will look forward to a new version where it is implemented. Thanks in advance.

Mvh. Karsten Svenningsen

2014-05-20 12:58 GMT+02:00 Colin Jenkins colin@sailwave.com [sailwave] sailwave@yahoogroups.com:

Sailwave does in fact use Place but when sorting by group it reranks/resorts the places. However as you guess, the original Place is available, it would need adding as a variable. Jon has dominion over the source code these days but I could point him at the relevant parts to twiddle.

Cheers,

Colin J

http://sailwave.com

On Mon, May 19, 2014 at 9:05 PM, Karsten Svenningsen karsten@svenningsenklanen.dk [sailwave] sailwave@yahoogroups.com wrote:

I find an easier way to do my trick math by replacing

ABS(1-INT(LOG10§)) with (P<10) which gives 1 for values below 10 and 0 for values above. Sailwave rules the waves…

But I haven’t figured out how to solve my primary problem.

Mvh. Karsten Svenningsen

2014-05-19 20:50 GMT+02:00 karsten@svenningsenklanen.dk [sailwave] sailwave@yahoogroups.com:

Is it possible to use the place given instead of the calculated rank in the Custom HighPoint formula.

My challenge is that I have launched a liga where the boats of a specific boattype place in different races counts in a sort of liga for this boattype. My problem is that if the boat gets a 4th place and is the only one of this boat type in the race then the point should be calculated from the fourth place and not from the rank as number 1. Sailwave scoring gives it the rnak of 1 becaus i havent got any boats on 1st, 2nd and 3rd place.

My formula looks like this :

(ABS(1-INT(LOG10§))(100-10P)+10)(0.9+0.1r)

ABS(1-INT(LOG10§)) is a little trick to get the first part to count only for top 9 (Please introduce “IF” like in Excel).

100-10*P is the points given for the single race, and P should be 4 not 1 for a 4th place.

0.9+0.1*r is a bonus based on how many of the specific boat type that participates in the race.

12

Hi Jon

It’s true that it hasn’t worked the last one or two year I think. But now it updates perfecly under Both under File Menu, Open Recent Series (Series and Folders). Thanks again for your quick response.

···

Mvh. Karsten Svenningsen

2014-05-22 13:59 GMT+02:00 Jon Eskdale jon@sailwave.com [sailwave] sailwave@yahoogroups.com:

Hi Karsten,

Thanks for reminding me about the recently opened list - It does sometimes work and I had noticed it myself but keep forgetting to look into it. I guess its always been that way. Anyway you prompted me to fix it, so 2.16.2 available at https://dl.dropboxusercontent.com/u/220425/SailwaveBeta/sailwave.exe has it fixed (I hope)

Jon

Jon Eskdale
07976 709777

Skype “eskdale”

On 22 May 2014 07:17, Karsten Svenningsen karsten@svenningsenklanen.dk [sailwave] sailwave@yahoogroups.com wrote:

Hi Jon
You are encreddible. It works perfect. Thankyou.

BTW I have noteced thad the recently opened list the file menu only changes for no. 1. The other 9 are the same. It’s like they are not shifting down. It’s a minor thing so don’t hurry.

Mvh. Karsten Svenningsen

2014-05-22 0:09 GMT+02:00 Jon Eskdale jon@sailwave.com [sailwave] sailwave@yahoogroups.com:

OK - I’ve updated the app to 2.16.1 available here https://dl.dropboxusercontent.com/u/220425/sailwavebeta/sailwave.exe this now has the tool tips updated and the support for “q” in the test expression

Jon

Jon Eskdale
07976 709777

Skype “eskdale”

On 21 May 2014 21:45, Karsten Svenningsen karsten@svenningsenklanen.dk [sailwave] sailwave@yahoogroups.com wrote:

Hi Jon

It works just as I dreamt off. So please include this feature in future versions of sailwave.

I have tested with the following fomula: ((q<11)(100-10q)+10)(0.9+0.1r)

regarding ties, it is not that important. I think it could be broken by maxpoint like lowpoint is broken on most 1. places 2nd place etc.

Mvh. Karsten Svenningsen

2014-05-21 10:28 GMT+02:00 Jon Eskdale jon@sailwave.com [sailwave] sailwave@yahoogroups.com:

Hi Karsten,

Have a try with this one - as I haven’t heard on the ties I’ve done the same as previously.

https://dl.dropboxusercontent.com/u/220425/SailwaveBeta/sailwave.exe

use the variable “q” for place - does it do what you need? - Let me know if it does and I’ll finish it off

Jon

Jon Eskdale
Sailwave

03333 443377

07976 709777

On 20 May 2014 13:40, Karsten Svenningsen karsten@svenningsenklanen.dk [sailwave] sailwave@yahoogroups.com wrote:

Hi and thanks for the response. It could be nice to have as a specific variable. I will look forward to a new version where it is implemented. Thanks in advance.

Mvh. Karsten Svenningsen

2014-05-20 12:58 GMT+02:00 Colin Jenkins colin@sailwave.com [sailwave] sailwave@yahoogroups.com:

Sailwave does in fact use Place but when sorting by group it reranks/resorts the places. However as you guess, the original Place is available, it would need adding as a variable. Jon has dominion over the source code these days but I could point him at the relevant parts to twiddle.

Cheers,

Colin J

http://sailwave.com

On Mon, May 19, 2014 at 9:05 PM, Karsten Svenningsen karsten@svenningsenklanen.dk [sailwave] sailwave@yahoogroups.com wrote:

I find an easier way to do my trick math by replacing

ABS(1-INT(LOG10§)) with (P<10) which gives 1 for values below 10 and 0 for values above. Sailwave rules the waves…

But I haven’t figured out how to solve my primary problem.

Mvh. Karsten Svenningsen

2014-05-19 20:50 GMT+02:00 karsten@svenningsenklanen.dk [sailwave] sailwave@yahoogroups.com:

Is it possible to use the place given instead of the calculated rank in the Custom HighPoint formula.

My challenge is that I have launched a liga where the boats of a specific boattype place in different races counts in a sort of liga for this boattype. My problem is that if the boat gets a 4th place and is the only one of this boat type in the race then the point should be calculated from the fourth place and not from the rank as number 1. Sailwave scoring gives it the rnak of 1 becaus i havent got any boats on 1st, 2nd and 3rd place.

My formula looks like this :

(ABS(1-INT(LOG10§))(100-10P)+10)(0.9+0.1r)

ABS(1-INT(LOG10§)) is a little trick to get the first part to count only for top 9 (Please introduce “IF” like in Excel).

100-10*P is the points given for the single race, and P should be 4 not 1 for a 4th place.

0.9+0.1*r is a bonus based on how many of the specific boat type that participates in the race.