FW: Large number of races - discards

Imported from Yahoo
1

Hi Jon,

I am defining the discards as twenty 0s and then 1 to 75 but cannot add 76. As 0,0,0,0,0….0,1,2,3,4,……74,75

David

···

From: David@XOD-Itchenor [mailto:david@xod-itchenor.com]
Sent: 02 October 2018 12:39
To: ‘sailwave@yahoogroups.com’
Subject: Large number of races - discards

Hi

I have a season long series with currently 105 races sailed – more to sail. The best 20 races are counted and the rest discarded. I am only able to discard 75 results. That is a total of 95 races.

How can I increase the number of discards?

David

2

Hi David,

You need to use a formula

Use (s-20)*(s>20) this will give you the best 20

image.png

Jon


Mailtrack

Sender notified by

                [Mailtrack](https://mailtrack.io?utm_source=gmail&utm_medium=signature&utm_campaign=signaturevirality6&)
                03/10/18, 20:22:43
···

Jon Eskdale

03333 443377

07530 112233