Multiple AND rules to select competitors

Sailwave Users,

I am trying to set up a prize table for a regatta and need to be able to have three criteria met to select a competitor.

E.g. To be eligible for this prize you must be in the “OPEN fleet” you must be “Female” and you must be from our state “QLD” (there are other prizes for interstate competitors)

In the Eligible competitors editor, I can only create “(Fleet=Open AND State=QLD) OR M/F=F”

How do I create “(Fleet=Open AND State=QLD AND M/F=F)”

Regards,

Matthew Johnson
Discover Sailing Centre Principal - Humpybong Yacht Club

Humpybong YC logo
cid:image007.jpg@01CF5109.5B7455A0

This document should be read only by those persons to whom it is addressed. If you have received this message it was obviously addressed to you and therefore you can read it, even if we didn’t
mean to send it to you. However, if the content of this email makes no sense whatsoever, then you probably were not the intended recipient, or you are a mindless cretin; either way, you should immediately delete yourself and destroy your computer. Once you
have taken this action please contact us. Ok, only kidding. In the event that the originator did not send this email to you, please return it to us along with a picture of your mother’s cat dressed as santa’s little helper and we will refund you exactly half
of what you paid for chocolate milk you bought when you went to woolies yesterday. Now get back to work. Any views or opinions presented in this e-mail are solely those of the author and do not necessarily represent those of the organisation on who’s letter
head it may or may not appear. The recipient should check this e-mail and any attachments for the presence of viruses including cold, flu and ebola. The world accepts no liability for any damage caused by any virus or bacteria transmitted by this e-mail.

P

Please consider the environment before printing this e-mail

Hi Matthew,

  The prize functionality built in to Sailwave does not have

capability to use more than two selection criteria. Sorry. However
there are a couple of possible solutions you might like to
investigate.

  1. Download and use the external prize utility [ Sailwave
    Prize List
    ] that Jon Eskdale developed, which allows up
    to 3 selection criteria. It can be download via the link at
    , which lists a number
    of utilities that Jon has developed.
  2.     Make use of unused field/column in Sailwave to hold
    

concatenated selection criteria, probably easiest to do in a
spreadsheet before importing the competitors. However, you can
use the ‘Set competitor’ field functionality available via link
on Tools menu to put information into a competitor field. For
example use the Team field to have concatenated data such as
“QLD - F”. Then you selection criteria would be “Fleet = Open
AND Team = QLD - F” for Queensland state.
I hope you find useful. I am happy to set-up a file for you if
you send me the data and prize criteria.

Kind regards,

Huw

···

https://sites.google.com/site/eskdalesite/
On 30/12/2019 01:42, Matthew Johnson
[sailwave] wrote:

matthew@powearchitects.com

Sailwave Users,

            I am trying to set up a prize table

for a regatta and need to be able to have three criteria
met to select a competitor.

            E.g. To be eligible for this prize

you must be in the �OPEN fleet� you must be �Female� and
you must be from our state �QLD� (there are other prizes
for interstate competitors)

            In the Eligible competitors editor, I

can only create �(Fleet=Open AND State=QLD) OR M/F=F�

            How do I create �(Fleet=Open AND

State=QLD AND M/F=F)�

Regards,

** Matthew
Johnson**

              Discover Sailing Centre Principal - Humpybong Yacht

Club

��������
�����

              This document

should be read only by those persons to whom it is
addressed. If you have received this message it was
obviously addressed to you and therefore you can read
it, even if we didn�t mean to send it to you. However,
if the content of this email makes no sense
whatsoever, then you probably were not the intended
recipient, or you are a mindless cretin; either way,
you should immediately delete yourself and destroy
your computer. Once you have taken this action please
contact us. Ok, only kidding. In the event that the
originator did not send this email to you, please
return it to us along with a picture of your mother�s
cat dressed as santa�s little helper and we will
refund you exactly half of what you paid for chocolate
milk you bought when you went to woolies yesterday.
Now get back to work. Any views or opinions presented
in this e-mail are solely those of the author and do
not necessarily represent those of the organisation on
who�s letter head it may or may not appear. The
recipient should check this e-mail and any attachments
for the presence of viruses including cold, flu and
ebola. The world accepts no liability for any damage
caused by any virus or bacteria transmitted by this
e-mail.

P

                              Please

consider the environment before printing this e-mail

Hi Matthew

You have two alternatives

Either use an otherwise unused field to set a flag for the two e.g. female and your state

And then select this in the prize criteria

Or

I would use the sailwave prize program which allows selection of 3 criteria

Download from here

https://www.dropbox.com/s/opfx4ifzferh9rk/SWPrize.EXE?dl=1

For documentation please see

https://sites.google.com/site/eskdalesite/home/swprize

Let me know if you need more help

Jon

···

Jon Eskdale

03333 443377

07530 112233