I searched but I did not see this topic covered before so if it has I apologize.
In the series I am trying to score we have a percentage throwout. 80% of the total number of races to count. No problem. The problem is that they added to that the percentage would be rounded to the nearest whole number (down if .49 or less, up if .50 or higher). I haven't been able to figure out how to do that part. At least not with an expression. I can do all the math outside Sailwave and then put it in as a comma separated list but I'd prefer to stick with an expression if possible.
The Reference section on the website http://www.sailwave.com/discard-profile gives details on how the expressions works for the discard profile. In practice Sailwave rounds down, so the expression would be either (s0.8)+0.5 or (r0.8)+0.5 depending on whether you go on the number of races sailed (s) or total number of races in the series ®. Just enter the formula shown in the box for the discard profile.
I searched but I did not see this topic covered before so if it has I apologize.
In the series I am trying to score we have a percentage throwout. 80% of the total number of races to count. No problem. The problem is that they added to that the percentage would be rounded to the nearest whole number (down if .49 or less, up if .50 or higher). I haven’t been able to figure out how to do that part. At least not with an expression. I can do all the math outside Sailwave and then put it in as a comma separated list but I’d prefer to stick with an expression if possible.
I searched but I did not see this topic covered before so if it has I apologize.
In the series I am trying to score we have a percentage throwout. 80% of the total number of races to count. No problem. The problem is that they added to that the percentage would be rounded to the nearest whole number (down if .49 or less, up if .50 or higher). I haven’t been able to figure out how to do that part. At least not with an expression. I can do all the math outside Sailwave and then put it in as a comma separated list but I’d prefer to stick with an expression if possible.
Hi Jonathan - you are correct except I think he wanted 80% to count not 80% discard so your formula is then (s*0.2)+0.5 which should give the same result as mine - hopefully that is what he wants
The Reference section on the website http://www.sailwave.com/discard-profile gives details on how the expressions works for the discard profile. In practice Sailwave rounds down, so the expression would be either (s0.8)+0.5 or (r0.8)+0.5 depending on whether you go on the number of races sailed (s) or total number of races in the series ®. Just enter the formula shown in the box for the discard profile.
I searched but I did not see this topic covered before so if it has I apologize.
In the series I am trying to score we have a percentage throwout. 80% of the total number of races to count. No problem. The problem is that they added to that the percentage would be rounded to the nearest whole number (down if .49 or less, up if .50 or higher). I haven’t been able to figure out how to do that part. At least not with an expression. I can do all the math outside Sailwave and then put it in as a comma separated list but I’d prefer to stick with an expression if possible.
The Reference section on the website http://www.sailwave.com/discard-profile gives details on how the expressions works for the discard profile. In practice Sailwave rounds down, so the expression would be either (s0.8)+0.5 or (r0.8)+0.5 depending on whether you go on the number of races sailed (s) or total number of races in the series ®. Just enter the formula shown in the box for the discard profile.
I searched but I did not see this topic covered before so if it has I apologize.
In the series I am trying to score we have a percentage throwout. 80% of the total number of races to count. No problem. The problem is that they added to that the percentage would be rounded to the nearest whole number (down if .49 or less, up if .50 or higher). I haven’t been able to figure out how to do that part. At least not with an expression. I can do all the math outside Sailwave and then put it in as a comma separated list but I’d prefer to stick with an expression if possible.
On Tue, Jun 25, 2013 at 4:24 PM, Jonathan Edwards < > jonathan.p.edwards@...> wrote:
> **
>
>
> The Reference section on the website
> http://www.sailwave.com/discard-profile gives details on how the
> expressions works for the discard profile. In practice Sailwave rounds
> down, so the expression would be either (s*0.8)+0.5 or (r*0.8)+0.5
> depending on whether you go on the number of races sailed (s) or total
> number of races in the series (r). Just enter the formula shown in the box
> for the discard profile.
>
> *From:* Main <mainsail111@...>
> *To:* sailwave@yahoogroups.com
> *Sent:* Tuesday, 25 June 2013, 15:11
> *Subject:* [sailwave] Rounding the number of throwouts
> **
>
> I searched but I did not see this topic covered before so if it has I
> apologize.
>
> In the series I am trying to score we have a percentage throwout. 80% of
> the total number of races to count. No problem. The problem is that they
> added to that the percentage would be rounded to the nearest whole number
> (down if .49 or less, up if .50 or higher). I haven't been able to figure
> out how to do that part. At least not with an expression. I can do all the
> math outside Sailwave and then put it in as a comma separated list but I'd
> prefer to stick with an expression if possible.
>
> ****
>
>
>