Thank you for pointing that out, however. I did change it and this
is what I got, it narrowed but it is still 29 seconds off. Somehow
the elapsed times are not calculating the same.
Start time was 18:04.33 both boats.
Boat Name PHRH Rating TCF Finish Time ELPS HH:MM:SS
ELPS min/24hr time_min_sec Corrected
Mach II 174 0.897790055 19:09:57 1:05:24 0.045416667
65.400 58.715
Razmataz 282 0.78125 19:20:05 1:15:32 0.052453704
75.533 59.010
excel elapsed time
18:04:33 19:09:57 =1:05:24
18:04:33 19:20:05 =1:15:32
in sailwave elapsed time
18:04:33 19:09:57 =1:05:24
18:04:33 19:20:05 =1:14:32
I am not surprised the results in sailwave and Excel are
different, they
show different elapsed times to start with, despite Start time
given as
18.00.00 the second example suggests it was 18.05.00, and the
first example
it was either 18.05.33 or 18.04.33 dependant on which boat you are
considering, or did they start a minute apart? A simple
mathmatical error,
or maybe finget trouble in entering elapsed times? Use the same
elapsed time
in both methods, and I suspect they will give the same answer
Regards
John.
From: "ttarb2408" <ttarbell@...>
To: <sailwave@yahoogroups.com>
Sent: Wednesday, June 21, 2006 8:43 PM
Subject: [sailwave] TOT scoring
>I have an issue with Time on Time PHRF. I have an instance where
I
> use sailwave and the results score the boat 2nd by 29 seconds
and in
> a straight excel(provided by PRO) spreadsheet they are first.
June
> first of the B fleet.
>
> http://www.sailpsa.org/images/stories/Racing%20Results%
> 202006/tuesday2006.htm
>
> Start 18:00
> 1 B_Division_1 Razmataz 1248 282 19:20:05 1:14:32 0:58:14
1
> 2 B_Division_1 Mach II 120 174 19:09:57 1:05:24 0:58:43
2
>
> This is from the excel TCF=650/(550+PHRH Rating)
>
> Boat Name PHRH Rating TCF Finish Time ELPS HH:MM:SS
> ELPS min/24hr time_min_sec Corrected Corrected
> Mach II 174 0.897790055 19:09:57 1:04:57 0.045104167
> 64.950 58.311 58.311
> Razmataz 282 0.78125 19:20:05 1:15:05 0.052141204
> 75.083 58.659 58.659
>
> I have left in the sailwave defalts
>
> I could send you the spread sheet if that would be helpful.
>
>
>
>
>
>
>
> -!- http://www.yachtsandyachting.com/ -!-
http://www.sailing.org/ -!-
> http://www.sailwave.com/ -!-
>
> Latest versions of sailwave can be downloaded from the 'files'
section at
···
--- In sailwave@yahoogroups.com, "John Selby" <john@...> wrote:
----- Original Message -----
> http://groups.yahoo.com/group/sailwave/
>
> On-Line Sailwave help...
> http://sailwave.com/help/HTML/
>
> Convert to daily digest of emails send blank email to:
> sailwave-digest@yahoogroups.com
> Yahoo! Groups Links
>
>
>
>
>
>
>