Using Sailwave with times in minutes and decimal minutes

Imported from Yahoo
1

Is it possible to use Sailwave for handicapping and scoring using times based upon an elapsed time in minutes and decimal minutes rather than minutes and seconds and using a PY number for handicapping? If so, can anyone provide me with some pointers as to how this could be done?

Regards

Peter Baldwin

Cheshire UK

2

Peter,
I had asked the same question quite some time ago and Colin replied that Sailwave does not support it and since it looked I was the only one requesting this method, I did not pursue this further. See my email below.

Willi.

···

From: sailwave@yahoogroups.com [mailto:sailwave@yahoogroups.com] On Behalf Of Colin Jenkins
Sent: Monday, May 15, 2006 2:32 AM
To: sailwave@yahoogroups.com
Subject: RE: [sailwave] Can elapsed times be entered in hours, min and 100ths of minutes into SW 1.92?

Hi Willi,

We use a stopwatch that has a memory for up to 50 finishing times
which helps greatly in taking times when multiple boats finish
together but unfortunately, the time is NOT in hours, min, sec but in
hours, min and 100’s of a min. Is there a way to enter this format
into Sailwave 1.92.
Thanks,
Willi.
LMVYC<<

I’m afraid not; is this common do (or anybody else) you know…?

Regards,
Colin
www.sailwave.com

From: sailwave@yahoogroups.com [mailto:sailwave@yahoogroups.com] On Behalf Of Peter Baldwin
Sent: Monday, January 23, 2012 12:17 PM
To: sailwave@yahoogroups.com
Subject: [sailwave] Using Sailwave with times in minutes and decimal minutes

Is it possible to use Sailwave for handicapping and scoring using times based upon an elapsed time in minutes and decimal minutes rather than minutes and seconds and using a PY number for handicapping? If so, can anyone provide me with some pointers as to how this could be done?

Regards

Peter Baldwin

Cheshire UK

3

Metrication of time… I love it! Tell me this watch doesn’t have a Euro Flag on it!

The only solution I can think of would be to import it from excel. So enter the decimal mins in excel with sail no in a column…

If the decimal time is in cell B2 then you would get the “imperial” time by entering the formula: =TIME(0,B2,0)

But a lot of phaff… just buy a new watch!

Calum

···

On Mon, 23 Jan 2012 20:17:09 +0000 (GMT), Peter Baldwin wrote:

Is it possible to use Sailwave for handicapping and scoring using times based upon an elapsed time in minutes and decimal minutes rather than minutes and seconds and using a PY number for handicapping? If so, can anyone provide me with some pointers as to how this could be done?

Regards

Peter Baldwin

Cheshire UK

4

If the time given is elapsed time, that excel formula doesn’t seem
to function correctly - with B2 = 55.6, gives a value 12:55am!

I think you would need a rather more complicated formula:
=INT(B2)&":"&ROUND((B2-INT(B2))*60,0)

This gives the correct result - 55:36

Providing you setup  SW correctly ( scoring system = RYA), it works

very well for handicapping.

··· 
regards,
Malcolm Osborne
Sedgefield South Africa

    Metrication of time... I love it!  Tell me this watch doesn't

have a Euro Flag on it!

    The only solution I can think of would be to import it from

excel. So enter the decimal mins in excel with sail no in a
column…

    If the decimal time is in cell B2 then you would get the

“imperial” time by entering the formula: =TIME(0,B2,0)

But a lot of phaff… just buy a new watch!

Calum

On Mon, 23 Jan 2012 20:17:09 +0000 (GMT), Peter Baldwin wrote:

              Is it possible to use Sailwave for handicapping and

scoring using times based upon an elapsed time in
minutes and decimal minutes rather than minutes and
seconds and using a PY number for handicapping? If
so, can anyone provide me with some pointers as to how
this could be done?

Regards

Peter Baldwin

Cheshire UK

5

Ah - I confess I tested in OpenOffice. If you expand the formatting to show 12:55:36 AM does it not show? Is it simply putting 12 instead of 00?

The formula using INT given may cause some issues when the value is a single digit especially for Seconds…

··· 
regards,
Malcolm Osborne
Sedgefield South Africa

Metrication of time… I love it! Tell me this watch doesn’t have a Euro Flag on it!

The only solution I can think of would be to import it from excel. So enter the decimal mins in excel with sail no in a column…

If the decimal time is in cell B2 then you would get the “imperial” time by entering the formula: =TIME(0,B2,0)

But a lot of phaff… just buy a new watch!

Calum

On Mon, 23 Jan 2012 20:17:09 +0000 (GMT), Peter Baldwin wrote:

Is it possible to use Sailwave for handicapping and scoring using times based upon an elapsed time in minutes and decimal minutes rather than minutes and seconds and using a PY number for handicapping? If so, can anyone provide me with some pointers as to how this could be done?

Regards

Peter Baldwin

Cheshire UK

6

Using Office 2010, formatting the cell to be mm:ss, it displays as
55:00

I think my formula would be correct for real elapsed times (in

minutes). For a time of 38.1 =38:6, I presume SW would interprete
that correctly, as opposed to 38:06 (not 38:60)?

··· 
regards,
Malcolm Osborne
Sedgefield South Africa

    Ah - I confess I tested in OpenOffice.  If you expand the

formatting to show 12:55:36 AM does it not show? Is it simply
putting 12 instead of 00?

    The formula using INT given may cause some issues when  the

value is a single digit especially for Seconds…

On Tue, 24 Jan 2012 22:48:54 +0200, Malcolm Osborne wrote:

            If the time given is elapsed time, that excel formula

doesn’t seem to function correctly - with B2 = 55.6,
gives a value 12:55am!

            I think you would need a rather more complicated

formula:
=INT(B2)&":"&ROUND((B2-INT(B2))*60,0)

            This gives the correct result - 55:36

            Providing you setup  SW correctly ( scoring system =

RYA), it works very well for handicapping.

On 2012/01/24 22:15, Calum Polwart wrote:

regards,
Malcolm Osborne
Sedgefield South Africa

              Metrication of time... I love it!  Tell me this watch

doesn’t have a Euro Flag on it!

              The only solution I can think of would be to import

it from excel. So enter the decimal mins in excel
with sail no in a column…

              If the decimal time is in cell B2 then you would get

the “imperial” time by entering the formula:
=TIME(0,B2,0)

But a lot of phaff… just buy a new watch!

Calum

              On Mon, 23 Jan 2012 20:17:09 +0000 (GMT), Peter

Baldwin wrote:

                        Is it possible to use Sailwave for

handicapping and scoring using times based
upon an elapsed time in minutes and decimal
minutes rather than minutes and seconds and
using a PY number for handicapping? If so,
can anyone provide me with some pointers as
to how this could be done?

Regards

Peter Baldwin

Cheshire UK