Automatic Calculation of Age Group

Imported from Yahoo
1

Hi

Does anybody know how to get SailWave to calculate age group (eg U12, U14, U17 etc) from date of birth?

Is there a template for this?

Thanks for your help

Kieran Cranley

2

I can't think of an automatic way but you could use the export to clipboard and then paste the clipboard into an empty excel spreadsheet.
Then using excel to create the age groups save as a csv and import into sailwave.

If it is only a few a may be easier to do manually but if there is a lot then the above will work.

If this is something you do regularly and with quite a few let may know and I'll write you a quick utility to do it.

Jon

···

--- In sailwave@yahoogroups.com, Kierancranley <kierancranley@...> wrote:

Hi

Does anybody know how to get SailWave to calculate age group (eg U12, U14, U17 etc) from date of birth?
Is there a template for this?

Thanks for your help
Kieran Cranley

3

Sailwave is a good sailboat scoring programme - it can do lots of things regarding race scoring, with various scoring options, e.g. handicaps or race timing.

However, it is not a general purpose database programme. Age groups would typically go into one of the optional columns, which only take text entries.

This would have to be done in an external app, e.g. excel, then imported.

regards,
Malcolm Osborne
Sedgefield South Africa

···

On 2012/06/26 12:47, Kierancranley wrote:

Hi

Does anybody know how to get SailWave to calculate age group (eg U12, U14, U17 etc) from date of birth?
Is there a template for this?

Thanks for your help
Kieran Cranley

4

Malcolm

Many thanks for your help

Kieran

···

Sailwave is a good sailboat scoring
programme - it can do lots of things regarding race scoring, with
various scoring options, e.g. handicaps or race timing.

  However, it is not a general purpose database programme. Age

groups would typically go into one of the optional columns, which
only take text entries.

  This would have to be done in an external app, e.g. excel, then

imported.

  On 2012/06/26 12:47, Kierancranley wrote:

regards,
Malcolm Osborne
Sedgefield South Africa



          Hi

              Does anybody know how to get SailWave to calculate

age group (eg U12, U14, U17 etc) from date of birth?

Is there a template for this?

Thanks for your help

Kieran Cranley

5

Thanks Jon

We only need to do this about once a year, but we had the visiting fleet last weekend, and it was a right pain trying to work out whether each competitor was U12, U14 or U17 on the 1st January. If you could send me a utility for this so that we’re better prepared for next year, that would be great.

Many thanks

Kieran

···

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

From: JON jon@eskdale.org

To: sailwave sailwave@yahoogroups.com

Sent: Tue, Jun 26, 2012 4:21 pm

Subject: [sailwave] Re: Automatic Calculation of Age Group

I can’t think of an automatic way but you could use the export to clipboard and then paste the clipboard into an empty excel spreadsheet.

Then using excel to create the age groups save as a csv and import into sailwave.

If it is only a few a may be easier to do manually but if there is a lot then the above will work.

If this is something you do regularly and with quite a few let may know and I’ll write you a quick utility to do it.

Jon

— In sailwave@yahoogroups.com, Kierancranley <kierancranley@…> wrote:

Hi

Does anybody know how to get SailWave to calculate age group (eg U12, U14, U17 etc) from date of birth?

Is there a template for this?

Thanks for your help

Kieran Cranley

6

I haven’t tested this solution, but it seems like it should work.

  1.  Use the “Set Competitor Field” tool and set the Division to “U21” if the “Birthdate < 19910626”

Mark Townsend
Phone: 562-433-4366

Cell: 562-533-5909
Email: s_mark_townsend@hotmail.com

···

From: sailwave@yahoogroups.com [mailto:sailwave@yahoogroups.com] On Behalf Of Kierancranley
Sent: Tuesday, June 26, 2012 8:27 AM
To: sailwave@yahoogroups.com
Subject: Re: [sailwave] Re: Automatic Calculation of Age Group

Thanks Jon

We only need to do this about once a year, but we had the visiting fleet last weekend, and it was a right pain trying to work out whether each competitor was U12, U14 or U17 on the 1st January. If you could send me a utility for this so that we’re better prepared for next year, that would be great.

Many thanks

Kieran

-----Original Message-----
From: JON jon@eskdale.org
To: sailwave sailwave@yahoogroups.com
Sent: Tue, Jun 26, 2012 4:21 pm
Subject: [sailwave] Re: Automatic Calculation of Age Group

I can’t think of an automatic way but you could use the export to clipboard and then paste the clipboard into an empty excel spreadsheet.
Then using excel to create the age groups save as a csv and import into sailwave.

If it is only a few a may be easier to do manually but if there is a lot then the above will work.

If this is something you do regularly and with quite a few let may know and I’ll write you a quick utility to do it.

Jon

— In sailwave@yahoogroups.com, Kierancranley <kierancranley@…> wrote:

Hi

Does anybody know how to get SailWave to calculate age group (eg U12, U14, U17 etc) from date of birth?
Is there a template for this?

Thanks for your help
Kieran Cranley

7

If this could be incorporated into the main system it could be useful - not only for youth categories but also for the Master, Grand Master, Venerable Ancient Mariner categories that seem to flourish in some classes.

Gordon

···

On 26/06/2012 16:26, Kierancranley wrote:

Thanks Jon

We only need to do this about once a year, but we had the visiting fleet last weekend, and it was a right pain trying to work out whether each competitor was U12, U14 or U17 on the 1st January. If you could send me a utility for this so that we're better prepared for next year, that would be great.

Many thanks
Kieran

-----Original Message-----
From: JON <jon@eskdale.org>
To: sailwave <sailwave@yahoogroups.com>
Sent: Tue, Jun 26, 2012 4:21 pm
Subject: [sailwave] Re: Automatic Calculation of Age Group

I can't think of an automatic way but you could use the export to clipboard and then paste the clipboard into an empty excel spreadsheet.
Then using excel to create the age groups save as a csv and import into sailwave.

If it is only a few a may be easier to do manually but if there is a lot then the above will work.

If this is something you do regularly and with quite a few let may know and I'll write you a quick utility to do it.

Jon

--- In sailwave@yahoogroups.com <mailto:sailwave%40yahoogroups.com>, Kierancranley <kierancranley@...> wrote:
>
> Hi
>
> Does anybody know how to get SailWave to calculate age group (eg U12, U14, U17 etc) from date of birth?
> Is there a template for this?
>
> Thanks for your help
> Kieran Cranley
>

8

Hi: This may sound a bit simple minded but we work it out
beforehand. The Registrars are given a sheet with the age colour or
category and the associated range of DOBs. It is gospel never mind
what Coaches say! By the time I get the competitor list for entry
into Sailwave all I’m doing is entering Byte Red Fleet or whatever.
We’ve tried a one step data entry straight into SW but it is
difficult to catch mistakes ( more training required for
Registrars). Later I can sit in the relative peace and quiet of the
Committee boat and sort things out via a few phone calls to the
Club. Mind you the regatta is only about 130 boats unlike the vast
European regattas where any sort of automation would help. However,
the lookup paper actually works quickly for Registrars learn the
date ranges after a few minutes. We do the same thing for U18 and
U21s if we have them.
What we really need to automate is to have SW compare sail numbers
on boats with sail numbers on registration forms. I’m ever hopeful!
Donald

···

O:-)

  On 26/06/2012 12:26 PM, Kierancranley

wrote:

          Thanks Jon

              We only need to do this about once a year, but we

had the visiting fleet last weekend, and it was a
right pain trying to work out whether each competitor
was U12, U14 or U17 on the 1st January. If you could
send me a utility for this so that we’re better
prepared for next year, that would be great.

Many thanks

Kieran

                -----Original

Message-----

                From: JON To: sailwave Sent: Tue, Jun 26, 2012 4:21 pm

Subject: [sailwave] Re: Automatic Calculation of Age
Group

jon@eskdale.org
sailwave@yahoogroups.com

                          I can't think of an automatic way but

you could use the export to clipboard and
then paste the clipboard into an empty
excel spreadsheet.

                          Then using excel to create the age groups

save as a csv and import into sailwave.

                          If it is only a few a may be easier to do

manually but if there is a lot then the
above will work.

                          If this is something you do regularly and

with quite a few let may know and I’ll
write you a quick utility to do it.

                          Jon

                          --- In sailwave@yahoogroups.com                              ,

Kierancranley wrote:

Hi

Does anybody know how to get SailWave
to calculate age group (eg U12, U14, U17
etc) from date of birth?
Is there a template for this?

Thanks for your help
Kieran Cranley

<kierancranley@…>

9

Hi Mark
I've been trying this without success. What is the precise format of presumably Action - Set this value?
Cheers
Kieran

“U21” if the “Birthdate < 19910626”

···

-----Original Message-----
From: S Mark Townsend <s_mark_townsend@hotmail.com>
To: sailwave <sailwave@yahoogroups.com>
Sent: Tue, Jun 26, 2012 7:11 pm
Subject: RE: [sailwave] Re: Automatic Calculation of Age Group

I haven’t tested this solution, but it seems like it should work.

1) Use the “Set Competitor Field” tool and set the Division to “U21” if the “Birthdate < 19910626”

Mark Townsend
Phone: 562-433-4366
Cell: 562-533-5909
Email: s_mark_townsend@hotmail.com

From: sailwave@yahoogroups.com [mailto:sailwave@yahoogroups.com] On Behalf Of Kierancranley
Sent: Tuesday, June 26, 2012 8:27 AM
To: sailwave@yahoogroups.com
Subject: Re: [sailwave] Re: Automatic Calculation of Age Group

Thanks Jon

We only need to do this about once a year, but we had the visiting fleet last weekend, and it was a right pain trying to work out whether each competitor was U12, U14 or U17 on the 1st January. If you could send me a utility for this so that we're better prepared for next year, that would be great.

Many thanks

Kieran

-----Original Message-----
From: JON <jon@eskdale.org>
To: sailwave <sailwave@yahoogroups.com>
Sent: Tue, Jun 26, 2012 4:21 pm
Subject: [sailwave] Re: Automatic Calculation of Age Group

I can't think of an automatic way but you could use the export to clipboard and then paste the clipboard into an empty excel spreadsheet.
Then using excel to create the age groups save as a csv and import into sailwave.

If it is only a few a may be easier to do manually but if there is a lot then the above will work.

If this is something you do regularly and with quite a few let may know and I'll write you a quick utility to do it.

Jon

--- In sailwave@yahoogroups.com, Kierancranley <kierancranley@...> wrote:

Hi

Does anybody know how to get SailWave to calculate age group (eg U12, U14, U17 etc) from date of birth?
Is there a template for this?

Thanks for your help
Kieran Cranley

10

Kieran,

Have you selected the competitors that you want to apply the change

to? If not click the button ‘Select Competitors’ alongside the box
that initially says All competitors and this will give you the
option to select the competitors that you want to apply the change
to.

Note - it is important that the date in field containing DOB is in

format YYYYMMDD not any other date format otherwise you will not get
what you are expecting!

Kind regards,
Huw
···

On 27/06/2012 10:19, Kierancranley
wrote:

          Hi Mark

            I've been

trying this without success. What is the precise format
of presumably Action - Set this value?

Cheers

Kieran

                “U21”

if the “Birthdate < 19910626”

              -----Original

Message-----

              From: S Mark Townsend

To: sailwave Sent: Tue, Jun 26, 2012 7:11 pm
Subject: RE: [sailwave] Re: Automatic Calculation of
Age Group

s_mark_townsend@hotmail.com
sailwave@yahoogroups.com

                            I

haven’t tested this solution, but it
seems like it should work.

  1.                                  Use

the “Set Competitor Field” tool and set
the Division to “U21” if the “Birthdate
< 19910626”

** Mark
Townsend**

                                                              Phone:

562-433-4366

                              Cell:

562-533-5909

                              Email: s_mark_townsend@hotmail.com

From: sailwave@yahoogroups.com
[mailto:sailwave@yahoogroups.com ]
On Behalf Of Kierancranley
Sent: Tuesday, June 26, 2012
8:27 AM
To: sailwave@yahoogroups.com
Subject: Re: [sailwave] Re:
Automatic Calculation of Age Group

                                  Thanks

Jon

                                      We

only need to do this about
once a year, but we had the
visiting fleet last weekend,
and it was a right pain trying
to work out whether each
competitor was U12, U14 or U17
on the 1st January. If you
could send me a utility for
this so that we’re better
prepared for next year, that
would be great.

                                      Many

thanks

Kieran

                                        -----Original

Message-----

                                        From: JON <jon@eskdale.org>

                                        To: sailwave <sailwave@yahoogroups.com>

                                        Sent: Tue, Jun 26, 2012 4:21

pm

                                        Subject: [sailwave] Re:

Automatic Calculation of Age
Group

                                                  I can't think of an automatic way

but you could use
the export to
clipboard and then
paste the
clipboard into an
empty excel
spreadsheet.

                                                  Then using excel

to create the age
groups save as a
csv and import
into sailwave.

                                                  If it is only a

few a may be
easier to do
manually but if
there is a lot
then the above
will work.

                                                  If this is

something you do
regularly and with
quite a few let
may know and I’ll
write you a quick
utility to do it.

                                                  Jon

                                                  --- In sailwave@yahoogroups.com                                                      ,

Kierancranley <kierancranley@… >
wrote:

                                                  >

                                                  > Hi

                                                  >

                                                  >

                                                  > Does anybody

know how to get
SailWave to
calculate age
group (eg U12,
U14, U17 etc) from
date of birth?

                                                  > Is there a

template for this?

                                                  >

                                                  >

                                                  > Thanks for

your help

                                                  > Kieran

Cranley

                                                  >
11

Minor change but won’t you want “U21” where the birthdate is GREATER than 19910626 ?

···

On Wed, Jun 27, 2012 at 5:40 AM, Huw Pearce huw.pearce@bcs.org.uk wrote:

Kieran,

Have you selected the competitors that you want to apply the change

to? If not click the button ‘Select Competitors’ alongside the box
that initially says All competitors and this will give you the
option to select the competitors that you want to apply the change
to.

Note - it is important that the date in field containing DOB is in

format YYYYMMDD not any other date format otherwise you will not get
what you are expecting!

Kind regards,
Huw

  On 27/06/2012 10:19, Kierancranley > wrote:

          Hi Mark

            I've been

trying this without success. What is the precise format
of presumably Action - Set this value?

Cheers

Kieran

                “U21”

if the “Birthdate < 19910626”

              -----Original

Message-----

              From: S Mark Townsend

s_mark_townsend@hotmail.com

              To: sailwave <sailwave@yahoogroups.com>

              Sent: Tue, Jun 26, 2012 7:11 pm

              Subject: RE: [sailwave] Re: Automatic Calculation of

Age Group

                            I

haven’t tested this solution, but it
seems like it should work.

  1.                                  Use

the “Set Competitor Field” tool and set
the Division to “U21” if the “Birthdate
< 19910626”

** Mark
Townsend**

                                                              Phone:

562-433-4366

                              Cell:

562-533-5909

                              Email: s_mark_townsend@hotmail.com

From: sailwave@yahoogroups.com
[mailto:sailwave@yahoogroups.com ]
On Behalf Of Kierancranley
Sent: Tuesday, June 26, 2012
8:27 AM
To: sailwave@yahoogroups.com
Subject: Re: [sailwave] Re:
Automatic Calculation of Age Group

                                  Thanks

Jon

                                      We

only need to do this about
once a year, but we had the
visiting fleet last weekend,
and it was a right pain trying
to work out whether each
competitor was U12, U14 or U17
on the 1st January. If you
could send me a utility for
this so that we’re better
prepared for next year, that
would be great.

                                      Many

thanks

Kieran

                                        -----Original

Message-----

                                        From: JON <jon@eskdale.org>

                                        To: sailwave <sailwave@yahoogroups.com>

                                        Sent: Tue, Jun 26, 2012 4:21

pm

                                        Subject: [sailwave] Re:

Automatic Calculation of Age
Group

                                                  I can't think of an automatic way

but you could use
the export to
clipboard and then
paste the
clipboard into an
empty excel
spreadsheet.

                                                  Then using excel

to create the age
groups save as a
csv and import
into sailwave.

                                                  If it is only a

few a may be
easier to do
manually but if
there is a lot
then the above
will work.

                                                  If this is

something you do
regularly and with
quite a few let
may know and I’ll
write you a quick
utility to do it.

                                                  Jon



                                                  --- In sailwave@yahoogroups.com                                                      ,

Kierancranley <kierancranley@… >
wrote:

                                                  >

                                                  > Hi

                                                  >

                                                  >

                                                  > Does anybody

know how to get
SailWave to
calculate age
group (eg U12,
U14, U17 etc) from
date of birth?

                                                  > Is there a

template for this?

                                                  >

                                                  >

                                                  > Thanks for

your help

                                                  > Kieran

Cranley

                                                  >
12

Donald - I don’t disagree with you in that your method may be the easiest
However if you have a lot to check or calculate/modify this might be of interest. It is certainly an interesting exercise to see how it could be developed. It is using Excel and as such can be made to even have different age groups for different fleets which happens in reality!!

There is sample which you can download from this link have a play with it and see what you think

Download sample

Download the AgeTest.zip file and extract the 3 files
Open the AgeTest.blw file with Sailwave
Then run the SWPH program included
Select the template file from the file menu to be SWPHage.xls (from the zip file)
Then click the “To Excel” button and that is it.

You see a Spreadsheet with all the AgeGroups calculated

You can modify the template file SWPHage.xls with different AgeGroups
This is in the Config worksheet

The Dates of Birth are in the Sailwave file in the PrivateNotes field but could be other fields if you change the config worksheet. Or use the tool - Set competitor field within sailwave to copy them to the PrivateNotes field. before you click the “To Excel”

Let me Know what you think - is it useful?

Jon

···

— In sailwave@yahoogroups.com, Jamie Diamond <sailorjamie@…> wrote:

Minor change but won’t you want “U21” where the birthdate is GREATER than
19910626 ?

On Wed, Jun 27, 2012 at 5:40 AM, Huw Pearce huw.pearce@… wrote:

**

Kieran,

Have you selected the competitors that you want to apply the change to? If
not click the button ‘Select Competitors’ alongside the box that initially
says All competitors and this will give you the option to select the
competitors that you want to apply the change to.

Note - it is important that the date in field containing DOB is in format
YYYYMMDD not any other date format otherwise you will not get what you are
expecting!

Kind regards,
Huw

On 27/06/2012 10:19, Kierancranley wrote:

Hi Mark
I’ve been trying this without success. What is the precise format of
presumably Action - Set this value?
Cheers
Kieran

�U21� if the �Birthdate < 19910626�

-----Original Message-----
From: S Mark Townsend s_mark_townsend@…s_mark_townsend@…
To: sailwave sailwave@yahoogroups.com sailwave@yahoogroups.com
Sent: Tue, Jun 26, 2012 7:11 pm
Subject: RE: [sailwave] Re: Automatic Calculation of Age Group

I haven�t tested this solution, but it seems like it should work.

  1. Use the �Set Competitor Field� tool and set the Division to �U21�
    if the �Birthdate < 19910626�

Mark Townsend
Phone: 562-433-4366
Cell: 562-533-5909
Email: s_mark_townsend@…

From: sailwave@yahoogroups.com [mailto:sailwave@yahoogroups.comsailwave@yahoogroups.com?>]
*On Behalf Of *Kierancranley
Sent: Tuesday, June 26, 2012 8:27 AM
To: sailwave@yahoogroups.com
Subject: Re: [sailwave] Re: Automatic Calculation of Age Group

Thanks Jon

We only need to do this about once a year, but we had the visiting fleet
last weekend, and it was a right pain trying to work out whether each
competitor was U12, U14 or U17 on the 1st January. If you could send me a
utility for this so that we’re better prepared for next year, that would be
great.

Many thanks
Kieran

-----Original Message-----
From: JON jon@…
To: sailwave sailwave@yahoogroups.com
Sent: Tue, Jun 26, 2012 4:21 pm
Subject: [sailwave] Re: Automatic Calculation of Age Group

I can’t think of an automatic way but you could use the export to
clipboard and then paste the clipboard into an empty excel spreadsheet.
Then using excel to create the age groups save as a csv and import into
sailwave.

If it is only a few a may be easier to do manually but if there is a lot
then the above will work.

If this is something you do regularly and with quite a few let may know
and I’ll write you a quick utility to do it.

Jon

— In sailwave@yahoogroups.com, Kierancranley kierancranley@ wrote:

Hi

Does anybody know how to get SailWave to calculate age group (eg U12,
U14, U17 etc) from date of birth?
Is there a template for this?

Thanks for your help
Kieran Cranley

13

Did anyone try it?

Jon

···

--- In sailwave@yahoogroups.com, "JON" <jon@...> wrote:

Donald - I don't disagree with you in that your method may be the
easiest
However if you have a lot to check or calculate/modify this might be of
interest. It is certainly an interesting exercise to see how it could
be developed. It is using Excel and as such can be made to even have
different age groups for different fleets which happens in reality!!

There is sample which you can download from this link have a play with
it and see what you think

Download sample <https://sites.google.com/site/eskdalesite/download>

Download the AgeTest.zip file and extract the 3 files
Open the AgeTest.blw file with Sailwave
Then run the SWPH program included
Select the template file from the file menu to be SWPHage.xls (from the
zip file)
Then click the "To Excel" button and that is it.

You see a Spreadsheet with all the AgeGroups calculated

You can modify the template file SWPHage.xls with different AgeGroups
This is in the Config worksheet

The Dates of Birth are in the Sailwave file in the PrivateNotes field
but could be other fields if you change the config worksheet. Or use
the tool - Set competitor field within sailwave to copy them to the
PrivateNotes field. before you click the "To Excel"

Let me Know what you think - is it useful?

Jon