Prize Winners Table

Can anyone explain how the Prize Winners Table is calculated? I thought all I needed to do was score my series, then put the appropriate rules into the Prize Table boxes and I would automagically get the prizes for those particular categories. What tries to get published as a Prize Table doesn't match what I get when I score using those fields.

Hi Andy,

If you have a hunt back through the forum there are some post about this.

To overcome this I have written this Prize program for use with Sailwave which allows even more configuration and hopefully you will find it useful

Any problems with it just let me know and I’ll see what I can do

···


Jon Eskdale
07976 709777

Skype “eskdale”

Sorry, initially off topic but may come back to topic once i know whats wanted to work out how to score it.

We are looking for a rewards you for sailing system, aimed at juniors…

so something like:

Helm Double Handed both <16 yrs - 12 pts

Crew DoubleHander Helm >16yrs 8pts

Helm single hander < 16 years 10 pts…

Aim being to reward participation rather than results…

Anyone got such a system…?

Can you attach the example series. That’s how
it is supposed to work yes. Jan also is having some problems.
Maybe it’s brokwn in some contexts.

···

Cheers,

  Colin J

http://sailwave.com

          Can anyone explain how the Prize Winners Table is

calculated? I thought all I needed to do was score my
series, then put the appropriate rules into the Prize
Table boxes and I would automagically get the prizes for
those particular categories. What tries to get published
as a Prize Table doesn’t match what I get when I score
using those fields.

    No virus

found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.1913 / Virus Database: 2114/4882 - Release Date:
03/20/12

Hi Colin,

I can’t get the prize table to work either.

Prize table gives two toppers as first and second, followed by the mirrors.

It should read the mirrors first and second, then a 4.7 followed by the toppers.

Prize table is set up as Eligible Competitors = All Competitors and Num = 7.

Regards

Ian

Prizes

Category

Rank

Competitor

The Frozen Toe Slow Fleet Prize

1st

Slow - TOPPER 42006 Harry Kennedy

The Frozen Toe Slow Fleet Prize

2nd

Slow - TOPPER 43153 Jessica Carter - Hedgehog

The Frozen Toe Slow Fleet Prize

3rd

Slow - MIRROR 70583 Annabel Fisk & Milly Moss - Frisky Beak

The Frozen Toe Slow Fleet Prize

4th

Slow - MIRROR 70624 Grace Yeoman & Izzy Barker

The Frozen Toe Slow Fleet Prize

5th

Slow - TOPPER 45197 Ellie Barker

The Frozen Toe Slow Fleet Prize

6th

Slow - LASER 4.7 190803 Hannah Gibbs

The Frozen Toe Slow Fleet Prize

7th

Slow - TOPPER 36673 Jade Grace

Rank Class SailNo Helm Age J/V Lady Crew Club PY R1 R2 R3 R4 R5 R6 R7 R8 Total Nett

1st MIRROR 70624 Grace Yeoman J L Izzy Barker I.S.C. 1385 2.0 1.0 1.0 5.0 (38.0 DNC) (38.0 DNC) 3.0 1.0 89.0 13.0

2nd MIRROR 70583 Annabel Fisk J L Milly Moss I.S.C. 1385 (24.0 MGate) (38.0 DNC) 17.0 8.0 4.0 4.0 5.0 7.0 107.0 45.0

3rd LASER 4.7 190803 Hannah Gibbs J L Pagham Y.C. 1175 (17.0) 12.5 12.0 (15.0) 9.0 8.0 10.0 8.0 91.5 59.5

4th TOPPER 42006 Harry Kennedy J Hill Head S.C. 1297 15.0 19.0 (38.0 DNC) (38.0 DNC) 8.0 6.0 12.5 3.0 139.5 63.5

5th TOPPER 43153 Jessica Carter J L C.Y.C. 1297 11.0 15.0 13.0 12.0 6.0 12.0 (38.0 DNC) (38.0 DNC) 145.0 69.0

6th TOPPER 36673 Jade Grace J Pagham Y.C. 1297 (21.0) (20.0) 18.0 16.0 12.0 10.0 9.0 5.0 111.0 70.0

7th TOPPER 45197 Ellie Barker J L I.S.C. 1297 20.0 18.0 (38.0 DNC) (38.0 DNC) 7.0 9.0 7.0 10.0 147.0 71.0

···

From: sailwave@yahoogroups.com [mailto:sailwave@yahoogroups.com] On Behalf Of Colin Jenkins
Sent: 20 March 2012 20:18
To: sailwave@yahoogroups.com
Subject: Re: [sailwave] Prize Winners Table

Can you attach the example series. That’s how it is supposed to work yes. Jan also is having some problems. Maybe it’s brokwn in some contexts.

Cheers,
Colin J
http://sailwave.com

On 20/03/2012 16:22, Andy wrote:

Can anyone explain how the Prize Winners Table is calculated? I thought all I needed to do was score my series, then put the appropriate rules into the Prize Table boxes and I would automagically get the prizes for those particular categories. What tries to get published as a Prize Table doesn’t match what I get when I score using those fields.

No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.1913 / Virus Database: 2114/4882 - Release Date: 03/20/12


No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.1913 / Virus Database: 2114/4882 - Release Date: 03/20/12


No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.1913 / Virus Database: 2114/4882 - Release Date: 03/20/12

Okay, uploaded the .blw file from the series. It's called WesMex 2012 Optis.

If I score by fleet, I get the top "All Categories" and "Princapiantes" (Beginners). If I score by Division, I get top by Division, if I score by HelmSex, I get the top boys and girls.

However, if I just score by fleet, then put that same logic above into the Prize table, I don't get the same results.

Ian - can u attach your series - difficult to
know what’s happening without somehting to debug… ta.

···

Cheers,

  Colin J

http://sailwave.com

Hi Colin,

              I can’t get

the prize table to work either.

              Prize table

gives two toppers as first and second, followed by the
mirrors.

              It should read

the mirrors first and second, then a 4.7 followed by
the toppers.

              Prize table is

set up as Eligible Competitors = All Competitors and
Num = 7.

Regards

Ian

Prizes

Category

Rank

Competitor

                    The Frozen Toe Slow Fleet

Prize

1st

                    Slow - TOPPER 42006 Harry

Kennedy

                    The Frozen Toe Slow Fleet

Prize

2nd

                    Slow - TOPPER 43153 Jessica

Carter - Hedgehog

                    The Frozen Toe Slow Fleet

Prize

3rd

                    Slow - MIRROR 70583 Annabel

Fisk & Milly Moss - Frisky Beak

                    The Frozen Toe Slow Fleet

Prize

4th

                    Slow - MIRROR 70624 Grace

Yeoman & Izzy Barker

                    The Frozen Toe Slow Fleet

Prize

5th

                    Slow - TOPPER 45197 Ellie

Barker

                    The Frozen Toe Slow Fleet

Prize

6th

                    Slow - LASER 4.7 190803

Hannah Gibbs

                    The Frozen Toe Slow Fleet

Prize

7th

                    Slow - TOPPER 36673 Jade

Grace

              Rank     

Class SailNo Helm
Age J/V Lady Crew
Club PY R1
R2 R3 R4 R5
R6 R7 R8 Total
Nett

              1st         

MIRROR 70624 Grace Yeoman J
L Izzy Barker
I.S.C. 1385 2.0 1.0 1.0
5.0 (38.0 DNC) (38.0
DNC) 3.0 1.0 89.0
13.0

              2nd       

MIRROR 70583 Annabel Fisk J
L Milly Moss I.S.C.
1385 (24.0 MGate) (38.0 DNC)
17.0 8.0 4.0
4.0 5.0 7.0 107.0 45.0

              3rd        

LASER 4.7 190803 Hannah Gibbs J
L Pagham Y.C. 1175
(17.0) 12.5 12.0 (15.0) 9.0
8.0 10.0 8.0
91.5 59.5

              4th        

TOPPER 42006 Harry Kennedy J
Hill Head S.C. 1297
15.0 19.0 (38.0 DNC)
(38.0 DNC) 8.0 6.0
12.5 3.0 139.5 63.5

              5th        

TOPPER 43153 Jessica Carter J
L C.Y.C.
1297 11.0 15.0 13.0 12.0
6.0 12.0 (38.0 DNC)
(38.0 DNC) 145.0 69.0

              6th        

TOPPER 36673 Jade Grace J
Pagham Y.C. 1297
(21.0) (20.0) 18.0 16.0 12.0
10.0 9.0 5.0
111.0 70.0

              7th        

TOPPER 45197 Ellie Barker J
L I.S.C.
1297 20.0 18.0
(38.0 DNC) (38.0 DNC) 7.0
9.0 7.0 10.0 147.0
71.0

From:

                  [] Colin Jenkins

20 March 2012 20:18
Re: [sailwave] Prize Winners Table

                    Can you attach the example series.  That's

how it is supposed to work yes. Jan also is
having some problems. Maybe it’s brokwn in some
contexts.

Cheers,
Colin J
http://sailwave.com

                  On 20/03/2012 16:22, Andy

wrote:

                    Can anyone explain how the Prize Winners Table

is calculated? I thought all I needed to do was
score my series, then put the appropriate rules
into the Prize Table boxes and I would
automagically get the prizes for those
particular categories. What tries to get
published as a Prize Table doesn’t match what I
get when I score using those fields.

No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.1913 / Virus Database: 2114/4882 -
Release Date: 03/20/12


No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.1913 / Virus Database: 2114/4882 -
Release Date: 03/20/12


              No virus

found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.1913 / Virus Database: 2114/4882 -
Release Date: 03/20/12

    No virus

found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.1913 / Virus Database: 2114/4883 - Release Date:
03/20/12

sailwave@yahoogroups.commailto:sailwave@yahoogroups.com** On Behalf Of**
Sent:
**To:**sailwave@yahoogroups.com
Subject:

No Prizes in it…?

···

Cheers,

  Colin J

http://sailwave.com

          Okay, uploaded the .blw file from the series. It's called

WesMex 2012 Optis.

          If I score by fleet, I get the top "All Categories" and

“Princapiantes” (Beginners). If I score by Division, I get
top by Division, if I score by HelmSex, I get the top boys
and girls.

          However, if I just score by fleet, then put that same

logic above into the Prize table, I don’t get the same
results.

    No virus

found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.1913 / Virus Database: 2114/4883 - Release Date:
03/20/12

Hi Colin,

Attached is the series.

Regards

Ian

···

From: sailwave@yahoogroups.com [mailto:sailwave@yahoogroups.com] On Behalf Of Colin Jenkins
Sent: 21 March 2012 15:59
To: sailwave@yahoogroups.com
Subject: Re: [sailwave] Prize Winners Table

Ian - can u attach your series - difficult to know what’s happening without somehting to debug… ta.

Cheers,
Colin J
http://sailwave.com

On 20/03/2012 22:42, Ian Payne wrote:

Hi Colin,

I can’t get the prize table to work either.

Prize table gives two toppers as first and second, followed by the mirrors.

It should read the mirrors first and second, then a 4.7 followed by the toppers.

Prize table is set up as Eligible Competitors = All Competitors and Num = 7.

Regards

Ian

Prizes

Category

Rank

Competitor

The Frozen Toe Slow Fleet Prize

1st

Slow - TOPPER 42006 Harry Kennedy

The Frozen Toe Slow Fleet Prize

2nd

Slow - TOPPER 43153 Jessica Carter - Hedgehog

The Frozen Toe Slow Fleet Prize

3rd

Slow - MIRROR 70583 Annabel Fisk & Milly Moss - Frisky Beak

The Frozen Toe Slow Fleet Prize

4th

Slow - MIRROR 70624 Grace Yeoman & Izzy Barker

The Frozen Toe Slow Fleet Prize

5th

Slow - TOPPER 45197 Ellie Barker

The Frozen Toe Slow Fleet Prize

6th

Slow - LASER 4.7 190803 Hannah Gibbs

The Frozen Toe Slow Fleet Prize

7th

Slow - TOPPER 36673 Jade Grace

Rank Class SailNo Helm Age J/V Lady Crew Club PY R1 R2 R3 R4 R5 R6 R7 R8 Total Nett

1st MIRROR 70624 Grace Yeoman J L Izzy Barker I.S.C. 1385 2.0 1.0 1.0 5.0 (38.0 DNC) (38.0 DNC) 3.0 1.0 89.0 13.0

2nd MIRROR 70583 Annabel Fisk J L Milly Moss I.S.C. 1385 (24.0 MGate) (38.0 DNC) 17.0 8.0 4.0 4.0 5.0 7.0 107.0 45.0

3rd LASER 4.7 190803 Hannah Gibbs J L Pagham Y.C. 1175 (17.0) 12.5 12.0 (15.0) 9.0 8.0 10.0 8.0 91.5 59.5

4th TOPPER 42006 Harry Kennedy J Hill Head S.C. 1297 15.0 19.0 (38.0 DNC) (38.0 DNC) 8.0 6.0 12.5 3.0 139.5 63.5

5th TOPPER 43153 Jessica Carter J L C.Y.C. 1297 11.0 15.0 13.0 12.0 6.0 12.0 (38.0 DNC) (38.0 DNC) 145.0 69.0

6th TOPPER 36673 Jade Grace J Pagham Y.C. 1297 (21.0) (20.0) 18.0 16.0 12.0 10.0 9.0 5.0 111.0 70.0

7th TOPPER 45197 Ellie Barker J L I.S.C. 1297 20.0 18.0 (38.0 DNC) (38.0 DNC) 7.0 9.0 7.0 10.0 147.0 71.0

From: sailwave@yahoogroups.com [mailto:sailwave@yahoogroups.com] On Behalf Of Colin Jenkins
Sent: 20 March 2012 20:18
To: sailwave@yahoogroups.com
Subject: Re: [sailwave] Prize Winners Table

Can you attach the example series. That’s how it is supposed to work yes. Jan also is having some problems. Maybe it’s brokwn in some contexts.

Cheers,
Colin J
http://sailwave.com

On 20/03/2012 16:22, Andy wrote:

Can anyone explain how the Prize Winners Table is calculated? I thought all I needed to do was score my series, then put the appropriate rules into the Prize Table boxes and I would automagically get the prizes for those particular categories. What tries to get published as a Prize Table doesn’t match what I get when I score using those fields.

No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.1913 / Virus Database: 2114/4882 - Release Date: 03/20/12


No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.1913 / Virus Database: 2114/4882 - Release Date: 03/20/12


No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.1913 / Virus Database: 2114/4882 - Release Date: 03/20/12

No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.1913 / Virus Database: 2114/4883 - Release Date: 03/20/12


No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.1913 / Virus Database: 2114/4882 - Release Date: 03/20/12


No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.1913 / Virus Database: 2114/4884 - Release Date: 03/21/12

Sorry, I took the prizes out as they weren't working. The prizes we awarded were done manually and entered as a note on the final publish. I'll stick the prizes in as I think they should be, and upload again.

I can see a problem with the file from somebody
else. I’ll fix that first then we can see if it fixes everything.

···

Cheers,

  Colin J

http://sailwave.com

          Sorry, I took the prizes out as they weren't working. The

prizes we awarded were done manually and entered as a note
on the final publish. I’ll stick the prizes in as I think
they should be, and upload again.

    No virus

found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.1913 / Virus Database: 2114/4886 - Release Date:
03/22/12

COnfirm bug.

···

Cheers,

  Colin J

http://sailwave.com

Hi Colin,

              Attached is

the series.

Regards

Ian

From:

                  [] Colin Jenkins

21 March 2012 15:59
Re: [sailwave] Prize Winners Table

                    Ian - can u attach your series - difficult

to know what’s happening without somehting to
debug… ta.

Cheers,
Colin J
http://sailwave.com

                  On 20/03/2012 22:42, Ian Payne wrote:
                        Hi

Colin,

                        I

can’t get the prize table to work either.

                        Prize

table gives two toppers as first and second,
followed by the mirrors.

                        It

should read the mirrors first and second,
then a 4.7 followed by the toppers.

                        Prize

table is set up as Eligible Competitors =
All Competitors and Num = 7.

Regards

Ian

Prizes

Category

Rank

Competitor

                              The Frozen Toe Slow

Fleet Prize

1st

                              Slow - TOPPER 42006

Harry Kennedy

                              The Frozen Toe Slow

Fleet Prize

2nd

                              Slow - TOPPER 43153

Jessica Carter - Hedgehog

                              The Frozen Toe Slow

Fleet Prize

3rd

                              Slow - MIRROR 70583

Annabel Fisk & Milly Moss - Frisky
Beak

                              The Frozen Toe Slow

Fleet Prize

4th

                              Slow - MIRROR 70624

Grace Yeoman & Izzy Barker

                              The Frozen Toe Slow

Fleet Prize

5th

                              Slow - TOPPER 45197

Ellie Barker

                              The Frozen Toe Slow

Fleet Prize

6th

                              Slow - LASER 4.7

190803 Hannah Gibbs

                              The Frozen Toe Slow

Fleet Prize

7th

                              Slow - TOPPER 36673

Jade Grace

                        Rank
 Class                      SailNo  

Helm Age J/V Lady
Crew Club PY
R1 R2 R3
R4 R5 R6
R7 R8 Total
Nett

                        1st
     MIRROR               70624    Grace

Yeoman J L Izzy
Barker I.S.C. 1385 2.0
1.0 1.0 5.0
(38.0 DNC) (38.0
DNC) 3.0 1.0 89.0
13.0

                        2nd
   MIRROR               70583    Annabel

Fisk J L
Milly Moss I.S.C. 1385
(24.0 MGate) (38.0 DNC)
17.0 8.0 4.0 4.0
5.0 7.0 107.0
45.0

                        3rd
    LASER 4.7             190803 Hannah

Gibbs J L
Pagham Y.C. 1175 (17.0) 12.5
12.0 (15.0) 9.0
8.0 10.0 8.0
91.5 59.5

                        4th
    TOPPER                42006    Harry

Kennedy J Hill
Head S.C. 1297 15.0 19.0
(38.0 DNC) (38.0 DNC)
8.0 6.0 12.5
3.0 139.5 63.5

                        5th
    TOPPER                43153   

Jessica Carter J L
C.Y.C. 1297
11.0 15.0 13.0
12.0 6.0 12.0
(38.0 DNC) (38.0 DNC)
145.0 69.0

                        6th
    TOPPER                36673    Jade

Grace J
Pagham Y.C.
1297 (21.0) (20.0) 18.0
16.0 12.0 10.0
9.0 5.0 111.0
70.0

                        7th
    TOPPER                45197    Ellie

Barker J L
I.S.C.
1297 20.0 18.0 (38.0
DNC) (38.0 DNC) 7.0
9.0 7.0 10.0
147.0 71.0

From:
sailwave@yahoogroups.com
[mailto:sailwave@yahoogroups.com ]
On Behalf Of Colin Jenkins
Sent: 20 March 2012 20:18
To: sailwave@yahoogroups.com
Subject: Re: [sailwave] Prize
Winners Table

                            Can you attach the example series. 

That’s how it is supposed to work yes.
Jan also is having some problems. Maybe
it’s brokwn in some contexts.

Cheers,
Colin J
http://sailwave.com

                            On 20/03/2012 16:22,

Andy wrote:

                              Can anyone explain how the Prize

Winners Table is calculated? I thought
all I needed to do was score my
series, then put the appropriate rules
into the Prize Table boxes and I would
automagically get the prizes for those
particular categories. What tries to
get published as a Prize Table doesn’t
match what I get when I score using
those fields.

No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.1913 / Virus Database:
2114/4882 - Release Date: 03/20/12


                          No virus found in this

message.
Checked by AVG - www.avg.com
Version: 2012.0.1913 / Virus Database:
2114/4882 - Release Date: 03/20/12


No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.1913 / Virus Database:
2114/4882 - Release Date: 03/20/12

No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.1913 / Virus Database: 2114/4883 -
Release Date: 03/20/12


No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.1913 / Virus Database: 2114/4882 -
Release Date: 03/20/12


              No virus

found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.1913 / Virus Database: 2114/4884 -
Release Date: 03/21/12

    No virus

found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.1913 / Virus Database: 2114/4884 - Release Date:
03/21/12

sailwave@yahoogroups.commailto:sailwave@yahoogroups.com** On Behalf Of**
Sent:
**To:**sailwave@yahoogroups.com
Subject: