New Prizes Format

Imported from Yahoo
1

I knew I should have read the version history before upgrading! Any thoughts on 2.02 Build 5 how to manage multiple prizes that don't map easily to fields. I have 14 non-standard prizes in a regatta starting this weekend, which were previously done by just selecting eligible competitors manually. Now it has to be done by formula. Prizes include First Lady Helm, First Lady Crew, First under 21, First over 65, First average age over 50, First new competitor, First visitor, first blood related helm/crew, etc., etc.

With only two "AND" expressions, and three "OR" expressions, and no ability to add 14 columns for prize eligibility, it's looking a bit tricky.

Thanks, Ian.

2

Sounds familiar - just like some SIs I prepared the other day!

Gordon

bowringi wrote:

···

I knew I should have read the version history before upgrading!
Any thoughts on 2.02 Build 5 how to manage multiple prizes that don’t
map easily to fields. I have 14 non-standard prizes in a regatta
starting this weekend, which were previously done by just selecting
eligible competitors manually. Now it has to be done by formula. Prizes
include First Lady Helm, First Lady Crew, First under 21, First over
65, First average age over 50, First new competitor, First visitor,
first blood related helm/crew, etc., etc.

With only two “AND” expressions, and three “OR” expressions, and no
ability to add 14 columns for prize eligibility, it’s looking a bit
tricky.

Thanks, Ian.

3

Hi Ian,

The only difference between build 4 and build 5 is the prize thing so
that’s always an option while we work out how to proceed.

Sailwave has Age fields so they can be used. And Sex fields. I
handled visitor by using an expression of the form “Club <>
MyYachtClub”, where MyYachyClub was “Mumbles” in my case.

The expression editor could have a ‘these competitors’ option in
addition to the expression…

Use build 4 for now - I’ll think about it. An obvious generic
solution is to use a field to list the prizes that a competitor is
eligible for e.g. “Visitor,FCrew,Over65” then in prize ecxpressions use
“field contains 'prizeName” - e.g. “Division contains FCrew”. But I’m
not sure if the expression editor has contains in it - easily added.
Could prob do that today if it would be useful.

I suppose the advantage of the select method was that somebody that
hhas all this knowledge in their head can just select away without
having to define it all in Sailave.

Anybody else got any ideas…?

I think it was the right way to go.

Colin J

Sailwave

bowringi wrote:

···

http://www.yachtsandyachting.com/http://www.sailing.org/http://www.sailwave.com/http://www.abyc.org/upload/Sailwave_ABYC_User_Guide_2009-08-21.pdfsailwave-digest@yahoogroups.comsailwave-unsubscribe@yahoogroups.comhttp://groups.yahoo.com/group/sailwave/http://groups.yahoo.com/group/sailwave/joinsailwave-digest@yahoogroups.comsailwave-fullfeatured@yahoogroups.comsailwave-unsubscribe@yahoogroups.comhttp://docs.yahoo.com/info/terms/

4

ps: build 4 is here

cj
bowringi wrote:

···

http://www.sailwave.com/binary/sw202b4.exe


I knew I should have read the version history before upgrading! Any thoughts on 2.02 Build 5 how to manage multiple prizes that don't map easily to fields. I have 14 non-standard prizes in a regatta starting this weekend, which were previously done by just selecting eligible competitors manually. Now it has to be done by formula. Prizes include First Lady Helm, First Lady Crew, First under 21, First over 65, First average age over 50, First new competitor, First visitor, first blood related helm/crew, etc., etc.
With only two "AND" expressions, and three "OR" expressions, and no ability to add 14 columns for prize eligibility, it's looking a bit tricky.
Thanks, Ian.
------------------------------------
-!- -!- -!- -!- On-Line Sailwave help...http://sailwave.com/help/HTML ~ Mark Thompson's Sailwave User Manual is available from ~ Convert to daily digest of emails send blank email to ~ To unsubscribe from the SUG please send blank email to Yahoo! Groups Links
<*> To visit your group on the web, go to:
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
(Yahoo! ID required)
<*> To change settings via email:
<*> To unsubscribe from this group, send an email to:
<*> Your use of Yahoo! Groups is subject to:

http://www.yachtsandyachting.com/http://www.sailing.org/http://www.sailwave.com/http://www.abyc.org/upload/Sailwave_ABYC_User_Guide_2009-08-21.pdfsailwave-digest@yahoogroups.comsailwave-unsubscribe@yahoogroups.comhttp://groups.yahoo.com/group/sailwave/http://groups.yahoo.com/group/sailwave/joinsailwave-digest@yahoogroups.comsailwave-fullfeatured@yahoogroups.comsailwave-unsubscribe@yahoogroups.comhttp://docs.yahoo.com/info/terms/

5

I havent looked yet but it sounds like the right way to proceed.
Last year for the toppers i ended up writing a separate application to extract
the results for the different trophies so people could see who was in each one and
where they stood etc. Then they could also complain and we could easily update
the data to reflect the different search criteria.

So this sound like it is heading in the right direction to me.

Trying to manually select the right things from 300 entries over
& over again as it was corrected wasn’t something i wanted to do.

I thing the adding field contains would be a good solution as an
additional expression, maybe does not contain might also be useful to avoid
having to add something to every competitor in some cases. Ie adding something
like 4.2 for the sailors with 4.2 topper rigs would allow does not contain to
select those with full figs without having to add a value for the other 280
competitors at the nationals.

John

From:
sailwave@yahoogroups.com [mailto:sailwave@yahoogroups.com] On Behalf Of Colin
Jenkins

···

Sent: 18 June 2010 08:56
To: sailwave@yahoogroups.com
Subject: Re: [sailwave] New Prizes Format

Hi Ian,

The only difference between build 4 and build 5 is the prize thing so that’s
always an option while we work out how to proceed.

Sailwave has Age fields so they can be used. And Sex fields. I
handled visitor by using an expression of the form “Club <>
MyYachtClub”, where MyYachyClub was “Mumbles” in my case.

The expression editor could have a ‘these competitors’ option in addition to
the expression…

Use build 4 for now - I’ll think about it. An obvious generic
solution is to use a field to list the prizes that a competitor is eligible for
e.g. “Visitor,FCrew,Over65” then in prize ecxpressions use
“field contains 'prizeName” - e.g. “Division contains
FCrew”. But I’m not sure if the expression editor has contains in it

  • easily added. Could prob do that today if it would be useful.

I suppose the advantage of the select method was that somebody that hhas all
this knowledge in their head can just select away without having to define it
all in Sailave.

Anybody else got any ideas…?

I think it was the right way to go.

Colin J

Sailwave

bowringi wrote:

I knew I should have read the version history before upgrading!  Any thoughts on 2.02 Build 5 how to manage multiple prizes that don't map easily to fields.  I have 14 non-standard prizes in a regatta starting this weekend, which were previously done by just selecting eligible competitors manually.  Now it has to be done by formula.  Prizes include First Lady Helm, First Lady Crew, First under 21, First over 65, First average age over 50, First new competitor, First visitor, first blood related helm/crew, etc., etc.


With only two "AND" expressions, and three "OR" expressions, and no ability to add 14 columns for prize eligibility, it's looking a bit tricky.


Thanks, Ian.




------------------------------------


-!- [http://www.yachtsandyachting.com/](http://www.yachtsandyachting.com/) -!- [http://www.sailing.org/](http://www.sailing.org/) -!- [http://www.sailwave.com/](http://www.sailwave.com/) -!- On-Line Sailwave help...http://sailwave.com/help/HTML ~ Mark Thompson's Sailwave User Manual is available from  [http://www.abyc.org/upload/Sailwave_ABYC_User_Guide_2009-08-21.pdf](http://www.abyc.org/upload/Sailwave_ABYC_User_Guide_2009-08-21.pdf) ~ Convert to daily digest of emails send blank email to sailwave-digest@yahoogroups.com ~ To unsubscribe from the SUG please send blank email to sailwave-unsubscribe@yahoogroups.com Yahoo! Groups Links


<*> To visit your group on the web, go to:

http://groups.yahoo.com/group/sailwave/

<*> Your email settings:

Individual Email | Traditional


<*> To change settings online go to:

http://groups.yahoo.com/group/sailwave/join

(Yahoo! ID required)


<*> To change settings via email:

sailwave-digest@yahoogroups.com

sailwave-fullfeatured@yahoogroups.com


<*> To unsubscribe from this group, send an email to:

sailwave-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:

[http://docs.yahoo.com/info/terms/](http://docs.yahoo.com/info/terms/)
6

I havent looked yet
but it sounds like the right way to proceed.
Last year for the toppers i ended up writing a separate application to
extract
the results for the different trophies so people could see who was in
each one and
where they stood etc. Then they could also complain and we could easily
update
the data to reflect the different search criteria.

So this sound like
it is heading in the right direction to me.

Trying to manually
select the right things from 300 entries over
& over again as it was corrected wasn’t something i wanted to do.

I thing the adding
field contains would be a good solution as an
additional expression, maybe does not contain might also be useful to
avoid
having to add something to every competitor in some cases. Ie adding
something
like 4.2 for the sailors with 4.2 topper rigs would allow does not
contain to
select those with full figs without having to add a value for the other
280
competitors at the nationals.

John

···

From:
sailwave@yahoogroups.com [mailto:sailwave@yahoogroups. com]
On Behalf Of Colin
Jenkins
Sent: 18 June 2010 08:56
To: sailwave@yahoogroups.com
Subject: Re: [sailwave] New Prizes Format

Hi Ian,

The only difference between build 4 and build 5 is the prize thing so
that’s
always an option while we work out how to proceed.

Sailwave has Age fields so they can be used. And Sex fields. I
handled visitor by using an expression of the form “Club <>
MyYachtClub”, where MyYachyClub was “Mumbles” in my case.

The expression editor could have a ‘these competitors’ option in
addition to
the expression…

Use build 4 for now - I’ll think about it. An obvious generic
solution is to use a field to list the prizes that a competitor is
eligible for
e.g. “Visitor,FCrew,Over65” then in prize ecxpressions use
“field contains 'prizeName” - e.g. “Division contains
FCrew”. But I’m not sure if the expression editor has contains in it

  • easily added. Could prob do that today if it would be useful.

I suppose the advantage of the select method was that somebody that
hhas all
this knowledge in their head can just select away without having to
define it
all in Sailave.

Anybody else got any ideas…?

I think it was the right way to go.

Colin J

Sailwave

bowringi wrote:

I knew I should have read the version history before upgrading!  Any thoughts on 2.02 Build 5 how to manage multiple prizes that don't map easily to fields.  I have 14 non-standard prizes in a regatta starting this weekend, which were previously done by just selecting eligible competitors manually.  Now it has to be done by formula.  Prizes include First Lady Helm, First Lady Crew, First under 21, First over 65, First average age over 50, First new competitor, First visitor, first blood related helm/crew, etc., etc.

 

With only two "AND" expressions, and three "OR" expressions, and no ability to add 14 columns for prize eligibility, it's looking a bit tricky.

 

Thanks, Ian.

 

 

 

------------------------------------

 

-!- [http://www.yachtsandyachting.com/](http://www.yachtsandyachting.com/) -!- [http://www.sailing.org/](http://www.sailing.org/) -!- [http://www.sailwave.com/](http://www.sailwave.com/) -!- On-Line Sailwave help...http://sailwave.com/help/HTML ~ Mark Thompson's Sailwave User Manual is available from  [http://www.abyc.org/upload/Sailwave_ABYC_User_Guide_2009-08-21.pdf](http://www.abyc.org/upload/Sailwave_ABYC_User_Guide_2009-08-21.pdf) ~ Convert to daily digest of emails send blank email to sailwave-digest@yahoogroups.com ~ To unsubscribe from the SUG please send blank email to sailwave-unsubscribe@yahoogroups.com Yahoo! Groups Links

 

<*> To visit your group on the web, go to:

[http://groups.yahoo.com/group/sailwave/](http://groups.yahoo.com/group/sailwave/)

 

<*> Your email settings:

Individual Email | Traditional

 

<*> To change settings online go to:

[http://groups.yahoo.com/group/sailwave/join](http://groups.yahoo.com/group/sailwave/join)

(Yahoo! ID required)

 

<*> To change settings via email:

sailwave-digest@yahoogroups.com

sailwave-fullfeatured@yahoogroups.com

 

<*> To unsubscribe from this group, send an email to:

sailwave-unsubscribe@yahoogroups.com

 

<*> Your use of Yahoo! Groups is subject to:

[http://docs.yahoo.com/info/terms/](http://docs.yahoo.com/info/terms/)
7

I havent looked yet
but it sounds like the right way to proceed.
Last year for the toppers i ended up writing a separate application to
extract
the results for the different trophies so people could see who was in
each one and
where they stood etc. Then they could also complain and we could easily
update
the data to reflect the different search criteria.

So this sound like
it is heading in the right direction to me.

Trying to manually
select the right things from 300 entries over
& over again as it was corrected wasn’t something i wanted to do.

I thing the adding
field contains would be a good solution as an
additional expression, maybe does not contain might also be useful to
avoid
having to add something to every competitor in some cases. Ie adding
something
like 4.2 for the sailors with 4.2 topper rigs would allow does not
contain to
select those with full figs without having to add a value for the other
280
competitors at the nationals.

John

···

From:
sailwave@yahoogroups.com [mailto:sailwave@yahoogroups. com]
On Behalf Of Colin
Jenkins
Sent: 18 June 2010 08:56
To: sailwave@yahoogroups.com
Subject: Re: [sailwave] New Prizes Format

Hi Ian,

The only difference between build 4 and build 5 is the prize thing so
that’s
always an option while we work out how to proceed.

Sailwave has Age fields so they can be used. And Sex fields. I
handled visitor by using an expression of the form “Club <>
MyYachtClub”, where MyYachyClub was “Mumbles” in my case.

The expression editor could have a ‘these competitors’ option in
addition to
the expression…

Use build 4 for now - I’ll think about it. An obvious generic
solution is to use a field to list the prizes that a competitor is
eligible for
e.g. “Visitor,FCrew,Over65” then in prize ecxpressions use
“field contains 'prizeName” - e.g. “Division contains
FCrew”. But I’m not sure if the expression editor has contains in it

  • easily added. Could prob do that today if it would be useful.

I suppose the advantage of the select method was that somebody that
hhas all
this knowledge in their head can just select away without having to
define it
all in Sailave.

Anybody else got any ideas…?

I think it was the right way to go.

Colin J

Sailwave

bowringi wrote:

I knew I should have read the version history before upgrading!  Any thoughts on 2.02 Build 5 how to manage multiple prizes that don't map easily to fields.  I have 14 non-standard prizes in a regatta starting this weekend, which were previously done by just selecting eligible competitors manually.  Now it has to be done by formula.  Prizes include First Lady Helm, First Lady Crew, First under 21, First over 65, First average age over 50, First new competitor, First visitor, first blood related helm/crew, etc., etc.

 

With only two "AND" expressions, and three "OR" expressions, and no ability to add 14 columns for prize eligibility, it's looking a bit tricky.

 

Thanks, Ian.

 

 

 

------------------------------------

 

-!- [http://www.yachtsandyachting.com/](http://www.yachtsandyachting.com/) -!- [http://www.sailing.org/](http://www.sailing.org/) -!- [http://www.sailwave.com/](http://www.sailwave.com/) -!- On-Line Sailwave help...http://sailwave.com/help/HTML ~ Mark Thompson's Sailwave User Manual is available from  [http://www.abyc.org/upload/Sailwave_ABYC_User_Guide_2009-08-21.pdf](http://www.abyc.org/upload/Sailwave_ABYC_User_Guide_2009-08-21.pdf) ~ Convert to daily digest of emails send blank email to sailwave-digest@yahoogroups.com ~ To unsubscribe from the SUG please send blank email to sailwave-unsubscribe@yahoogroups.com Yahoo! Groups Links

 

<*> To visit your group on the web, go to:

[http://groups.yahoo.com/group/sailwave/](http://groups.yahoo.com/group/sailwave/)

 

<*> Your email settings:

Individual Email | Traditional

 

<*> To change settings online go to:

[http://groups.yahoo.com/group/sailwave/join](http://groups.yahoo.com/group/sailwave/join)

(Yahoo! ID required)

 

<*> To change settings via email:

sailwave-digest@yahoogroups.com

sailwave-fullfeatured@yahoogroups.com

 

<*> To unsubscribe from this group, send an email to:

sailwave-unsubscribe@yahoogroups.com

 

<*> Your use of Yahoo! Groups is subject to:

[http://docs.yahoo.com/info/terms/](http://docs.yahoo.com/info/terms/)
8

I
havent looked yet but it sounds like the right way to proceed.
Last year for the toppers i ended up writing a separate application to
extract
the results for the different trophies so people could see who was in
each one and
where they stood etc. Then they could also complain and we could easily
update
the data to reflect the different search criteria.

So
this sound like it is heading in the right direction to me.

Trying
to manually select the right things from 300 entries over
& over again as it was corrected wasn’t something i wanted to do.

I
thing the adding field contains would be a good solution as an
additional expression, maybe does not contain might also be useful to
avoid
having to add something to every competitor in some cases. Ie adding
something
like 4.2 for the sailors with 4.2 topper rigs would allow does not
contain to
select those with full figs without having to add a value for the other
280
competitors at the nationals.

John

···

From:
sailwave@yahoogroups.com [mailto:sailwave@yahoogroups.com] On
Behalf Of Colin
Jenkins
Sent: 18 June 2010 08:56
To: sailwave@yahoogroups.com
Subject: Re: [sailwave] New Prizes Format

Hi Ian,

The only difference between build 4 and build 5 is the prize thing so
that’s
always an option while we work out how to proceed.

Sailwave has Age fields so they can be used. And Sex fields. I
handled visitor by using an expression of the form “Club <>
MyYachtClub”, where MyYachyClub was “Mumbles” in my case.

The expression editor could have a ‘these competitors’ option in
addition to
the expression…

Use build 4 for now - I’ll think about it. An obvious generic
solution is to use a field to list the prizes that a competitor is
eligible for
e.g. “Visitor,FCrew,Over65” then in prize ecxpressions use
“field contains 'prizeName” - e.g. “Division contains
FCrew”. But I’m not sure if the expression editor has contains in it

  • easily added. Could prob do that today if it would be useful.

I suppose the advantage of the select method was that somebody that
hhas all
this knowledge in their head can just select away without having to
define it
all in Sailave.

Anybody else got any ideas…?

I think it was the right way to go.

Colin J

Sailwave

bowringi wrote:

I knew I should have read the version history before upgrading!  Any thoughts on 2.02 Build 5 how to manage multiple prizes that don't map easily to fields.  I have 14 non-standard prizes in a regatta starting this weekend, which were previously done by just selecting eligible competitors manually.  Now it has to be done by formula.  Prizes include First Lady Helm, First Lady Crew, First under 21, First over 65, First average age over 50, First new competitor, First visitor, first blood related helm/crew, etc., etc.


With only two "AND" expressions, and three "OR" expressions, and no ability to add 14 columns for prize eligibility, it's looking a bit tricky.


Thanks, Ian.




------------------------------------


-!- [http://www.yachtsandyachting.com/](http://www.yachtsandyachting.com/) -!- [http://www.sailing.org/](http://www.sailing.org/) -!- [http://www.sailwave.com/](http://www.sailwave.com/) -!- On-Line Sailwave help...http://sailwave.com/help/HTML ~ Mark Thompson's Sailwave User Manual is available from  [http://www.abyc.org/upload/Sailwave_ABYC_User_Guide_2009-08-21.pdf](http://www.abyc.org/upload/Sailwave_ABYC_User_Guide_2009-08-21.pdf) ~ Convert to daily digest of emails send blank email to sailwave-digest@yahoogroups.com ~ To unsubscribe from the SUG please send blank email to sailwave-unsubscribe@yahoogroups.com Yahoo! Groups Links


<*> To visit your group on the web, go to:

http://groups.yahoo.com/group/sailwave/

<*> Your email settings:

Individual Email | Traditional


<*> To change settings online go to:

http://groups.yahoo.com/group/sailwave/join

(Yahoo! ID required)


<*> To change settings via email:

sailwave-digest@yahoogroups.com

sailwave-fullfeatured@yahoogroups.com


<*> To unsubscribe from this group, send an email to:

sailwave-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:

[http://docs.yahoo.com/info/terms/](http://docs.yahoo.com/info/terms/)
9

I havent looked yet
but it sounds like the right way to proceed.
Last year for the toppers i ended up writing a separate application to
extract
the results for the different trophies so people could see who was in
each one and
where they stood etc. Then they could also complain and we could easily
update
the data to reflect the different search criteria.

So this sound like
it is heading in the right direction to me.

Trying to manually
select the right things from 300 entries over
& over again as it was corrected wasn’t something i wanted to do.

I thing the adding
field contains would be a good solution as an
additional expression, maybe does not contain might also be useful to
avoid
having to add something to every competitor in some cases. Ie adding
something
like 4.2 for the sailors with 4.2 topper rigs would allow does not
contain to
select those with full figs without having to add a value for the other
280
competitors at the nationals.

John

···

From:
sailwave@yahoogroups.com [mailto:sailwave@yahoogroups. com]
On Behalf Of Colin
Jenkins
Sent: 18 June 2010 08:56
To: sailwave@yahoogroups.com
Subject: Re: [sailwave] New Prizes Format

  Hi Ian,

The only difference between build 4 and build 5 is the prize thing so
that’s
always an option while we work out how to proceed.

Sailwave has Age fields so they can be used. And Sex fields. I
handled visitor by using an expression of the form “Club <>
MyYachtClub”, where MyYachyClub was “Mumbles” in my case.

The expression editor could have a ‘these competitors’ option in
addition to
the expression…

Use build 4 for now - I’ll think about it. An obvious generic
solution is to use a field to list the prizes that a competitor is
eligible for
e.g. “Visitor,FCrew,Over65” then in prize ecxpressions use
“field contains 'prizeName” - e.g. “Division contains
FCrew”. But I’m not sure if the expression editor has contains in it

  • easily added. Could prob do that today if it would be useful.

I suppose the advantage of the select method was that somebody that
hhas all
this knowledge in their head can just select away without having to
define it
all in Sailave.

Anybody else got any ideas…?

I think it was the right way to go.

Colin J

Sailwave

bowringi wrote:

I knew I should have read the version history before upgrading!  Any thoughts on 2.02 Build 5 how to manage multiple prizes that don't map easily to fields.  I have 14 non-standard prizes in a regatta starting this weekend, which were previously done by just selecting eligible competitors manually.  Now it has to be done by formula.  Prizes include First Lady Helm, First Lady Crew, First under 21, First over 65, First average age over 50, First new competitor, First visitor, first blood related helm/crew, etc., etc.

 

With only two "AND" expressions, and three "OR" expressions, and no ability to add 14 columns for prize eligibility, it's looking a bit tricky.

 

Thanks, Ian.

 

 

 

------------------------------------

 

-!- [http://www.yachtsandyachting.com/](http://www.yachtsandyachting.com/) -!- [http://www.sailing.org/](http://www.sailing.org/) -!- [http://www.sailwave.com/](http://www.sailwave.com/) -!- On-Line Sailwave help...http://sailwave.com/help/HTML ~ Mark Thompson's Sailwave User Manual is available from  [http://www.abyc.org/upload/Sailwave_ABYC_User_Guide_2009-08-21.pdf](http://www.abyc.org/upload/Sailwave_ABYC_User_Guide_2009-08-21.pdf) ~ Convert to daily digest of emails send blank email to sailwave-digest@yahoogroups.com ~ To unsubscribe from the SUG please send blank email to sailwave-unsubscribe@yahoogroups.com Yahoo! Groups Links

 

<*> To visit your group on the web, go to:

[http://groups.yahoo.com/group/sailwave/](http://groups.yahoo.com/group/sailwave/)

 

<*> Your email settings:

Individual Email | Traditional

 

<*> To change settings online go to:

[http://groups.yahoo.com/group/sailwave/join](http://groups.yahoo.com/group/sailwave/join)

(Yahoo! ID required)

 

<*> To change settings via email:

sailwave-digest@yahoogroups.com

sailwave-fullfeatured@yahoogroups.com

 

<*> To unsubscribe from this group, send an email to:

sailwave-unsubscribe@yahoogroups.com

 

<*> Your use of Yahoo! Groups is subject to:

[http://docs.yahoo.com/info/terms/](http://docs.yahoo.com/info/terms/)
10

Hi Colin,

‘field contains’ would be a perfect solution. I could list all of a competitors eligible prizes into the ‘notes’ field or similar. As you say, not in build 5, but if you add it, I’ll certainly use it! Not urgent as the prizes don’t get handed out until next week, and I can also roll back to build 4 (thanks for the link).

Another one for thought (no action needed as manual calculation is not difficult) is in Team Rankings, where teams self-nominate. Current build caters for teams arranged by club, nationality, fleet or class. Current regatta allows three boats to declare as a team for an additional team prize, based on aggregate results.

Thanks indeed,

Ian.

···

----- Original Message -----

From:
Colin Jenkins

To: sailwave@yahoogroups.com

Sent: Friday, June 18, 2010 8:56 AM

Subject: Re: [sailwave] New Prizes Format

Hi Ian,

The only difference between build 4 and build 5 is the prize thing so that’s always an option while we work out how to proceed.

Sailwave has Age fields so they can be used. And Sex fields. I handled visitor by using an expression of the form “Club <> MyYachtClub” , where MyYachyClub was “Mumbles” in my case.

The expression editor could have a ‘these competitors’ option in addition to the expression…

Use build 4 for now - I’ll think about it. An obvious generic solution is to use a field to list the prizes that a competitor is eligible for e.g. “Visitor,FCrew, Over65” then in prize ecxpressions use “field contains 'prizeName” - e.g. “Division contains FCrew”. But I’m not sure if the expression editor has contains in it - easily added. Could prob do that today if it would be useful.

I suppose the advantage of the select method was that somebody that hhas all this knowledge in their head can just select away without having to define it all in Sailave.

Anybody else got any ideas…?

I think it was the right way to go.

Colin J
Sailwave

bowringi wrote:


I knew I should have read the version history before upgrading! Any thoughts on 2.02 Build 5 how to manage multiple prizes that don't map easily to fields. I have 14 non-standard prizes in a regatta starting this weekend, which were previously done by just selecting eligible competitors manually. Now it has to be done by formula. Prizes include First Lady Helm, First Lady Crew, First under 21, First over 65, First average age over 50, First new competitor, First visitor, first blood related helm/crew, etc., etc.
With only two "AND" expressions, and three "OR" expressions, and no ability to add 14 columns for prize eligibility, it's looking a bit tricky.
Thanks, Ian.
------------------------------
------
-!- [http://www.yachtsandyachting.com/](http://www.yachtsandyachting.com/) -!- [http://www.sailing.org/](http://www.sailing.org/) -!- [http://www.sailwave.com/](http://www.sailwave.com/) -!- On-Line Sailwave help...http://sailwave.com/help/HTML ~ Mark Thompson's Sailwave User Manual is available from [http://www.abyc.org/upload/Sailwave_ABYC_User_Guide_2009-08-21.pdf](http://www.abyc.org/upload/Sailwave_ABYC_User_Guide_2009-08-21.pdf) ~ Convert to daily digest of emails send blank email to sailwave-digest@yahoogroups.com ~ To unsubscribe from the SUG please send blank email to sailwave-unsubscribe@yahoogroups.com Yahoo! Groups Links
<*> To visit your group on the web, go to:
[http://groups.yahoo.com/group/sailwave/](http://groups.yahoo.com/group/sailwave/)

<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
[http://groups.yahoo.com/group/sailwave/join](http://groups.yahoo.com/group/sailwave/join)
    (Yahoo! ID required)
<*> To change settings via email:
sailwave-digest@yahoogroups.com
    sailwave-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
sailwave-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
[http://docs.yahoo.com/info/terms/](http://docs.yahoo.com/info/terms/)
11

Create some additional fields “Lady Helm”, “Lady Crew”, etc. and use a formula “Lady Helm” = YES.

OR

Alternatively you could use aliases to setup subfleets for each of the different categories; “Lady Helm”, “Lady Crew”, etc. See the results posted for Lido 14’s, Lido 14 A, Lido 14 B, Lido 14 Women, Lido 14 Junior. There is only one fleet and one start, but we score the A, B, Women and Junior as subfleets using aliases.

http://www.abyc.org/event.cfm?id=376

http://www.abyc.org/upload/2010_Lido_14_Twilights_June.htm

Mark Townsend
s_mark_townsend@hotmail.com

···

From: gordon

Sent: Friday, June 18, 2010 12:32 AM

To: sailwave@yahoogroups.com

Subject: Re: [sailwave] New Prizes Format

Sounds familiar - just like some SIs I prepared the other day!

Gordon

bowringi wrote:

I knew I should have read the version history before upgrading! Any thoughts on 2.02 Build 5 how to manage multiple prizes that don’t map easily to fields. I have 14 non-standard prizes in a regatta starting this weekend, which were previously done by just selecting eligible competitors manually. Now it has to be done by formula. Prizes include First Lady Helm, First Lady Crew, First under 21, First over 65, First average age over 50, First new competitor, First visitor, first blood related helm/crew, etc., etc.

With only two “AND” expressions, and three “OR” expressions, and no ability to add 14 columns for prize eligibility, it’s looking a bit tricky.

Thanks, Ian.

12

Mark,

Interesting suggestions. I have to admit to being a recent convert to Sailwave, and have figured many key functions, but creating additional fields isn’t one I’ve found. I can see how to edit the 27 default fields, but could you perhaps point me towards how to create new ones? Many thanks,

Ian.

···

----- Original Message -----

From:
S. Mark Townsend

To: sailwave@yahoogroups.com

Sent: Friday, June 18, 2010 2:41 PM

Subject: Re: [sailwave] New Prizes Format

Create some additional fields “Lady Helm”, “Lady Crew”, etc. and use a formula “Lady Helm” = YES.

OR

Alternatively you could use aliases to setup subfleets for each of the different categories; “Lady Helm”, “Lady Crew”, etc. See the results posted for Lido 14’s, Lido 14 A, Lido 14 B, Lido 14 Women, Lido 14 Junior. There is only one fleet and one start, but we score the A, B, Women and Junior as subfleets using aliases.

http://www.abyc.org/event.cfm?id=376

http://www.abyc.org/upload/2010_Lido_14_Twilights_June.htm

Mark Townsend
s_mark_townsend@hotmail.com

bowringi wrote:

I knew I should have read the version history before upgrading! Any thoughts on 2.02 Build 5 how to manage multiple prizes that don't map easily to fields. I have 14 non-standard prizes in a regatta starting this weekend, which were previously done by just selecting eligible competitors manually. Now it has to be done by formula. Prizes include First Lady Helm, First Lady Crew, First under 21, First over 65, First average age over 50, First new competitor, First visitor, first blood related helm/crew, etc., etc.

With only two "AND" expressions, and three "OR" expressions, and no ability to add 14 columns for prize eligibility, it's looking a bit tricky.

Thanks, Ian.

13

If you click on the User Interface tab and select Extra Competitor columns you will have a lot more columns. You can rename one of the columns for the specific use.

Mark Townsend
s_mark_townsend@hotmail.com

···

From: Ian Bowring

Sent: Friday, June 18, 2010 11:24 AM

To: sailwave@yahoogroups.com

Subject: Re: [sailwave] New Prizes Format

Mark,

Interesting suggestions. I have to admit to being a recent convert to Sailwave, and have figured many key functions, but creating additional fields isn’t one I’ve found. I can see how to edit the 27 default fields, but could you perhaps point me towards how to create new ones? Many thanks,

Ian.

----- Original Message -----

From: S. Mark Townsend

To: sailwave@yahoogroups.com

Sent: Friday, June 18, 2010 2:41 PM

Subject: Re: [sailwave] New Prizes Format

Create some additional fields “Lady Helm”, “Lady Crew”, etc. and use a formula “Lady Helm” = YES.

OR

Alternatively you could use aliases to setup subfleets for each of the different categories; “Lady Helm”, “Lady Crew”, etc. See the results posted for Lido 14’s, Lido 14 A, Lido 14 B, Lido 14 Women, Lido 14 Junior. There is only one fleet and one start, but we score the A, B, Women and Junior as subfleets using aliases.

http://www.abyc.org/event.cfm?id=376

http://www.abyc.org/upload/2010_Lido_14_Twilights_June.htm

Mark Townsend
s_mark_townsend@hotmail.com

bowringi wrote:

I knew I should have read the version history before upgrading! Any thoughts on 2.02 Build 5 how to manage multiple prizes that don't map easily to fields. I have 14 non-standard prizes in a regatta starting this weekend, which were previously done by just selecting eligible competitors manually. Now it has to be done by formula. Prizes include First Lady Helm, First Lady Crew, First under 21, First over 65, First average age over 50, First new competitor, First visitor, first blood related helm/crew, etc., etc.

With only two "AND" expressions, and three "OR" expressions, and no ability to add 14 columns for prize eligibility, it's looking a bit tricky.

Thanks, Ian.