Jack,
Yes it was on Sailwave.
Entering the first start time as 00:05:00 etc sounds like it would work fine. However, if your club wants to post
Start Time and Finish Time then it’s a problem.
Anyway, to answer your questions about the spread
sheet.
The spread sheet contains header information about the
race and detail information about each yacht. The race manager prints out
on his computer; someone could print it for him/her, and uses it for recording
information about the races. The race manager then enters this
information into the same spread sheet and emails it to me. I could enter
this information but then the race manager has to find a way to get the sheet
to me, in our club not all members keep their boat in the same place, large
lake with some keeping their boats in front of their house, some rent buoy or
slip spaces elsewhere, etc so not everyone meets after the races. We use
Sailwave to calculate the results and publish to web site the next morning so
members can go to the web site to get the results.
The header information contains entry spaces at the
top for entering the information about the races for the day; race date, series
id, race number, wind direction and wind speeds; then by fleet information
about course, distance, start times and time adjustment.
The detail information have pre-filled columns
containing Fleet Id, Sail#, Yacht Name, Yacht Type, Owner, PHRF with blank
columns for recording place, finish time (HH, MM, SS), (The place column is for
entering DNS, DNF info). There is blank space at the bottom for
write-ins, which we call guests.
When I receive the email, I press the Export Button
which runs the visual basic code to export into a CSV file which extracts race
number, fleet id, yacht class, sail number, helm, code (DNS, DNF, or blank if
yacht raced), start time and calculated finish time. The file is then
imported into Sailwave using the “import race results
function”. So, all I have to do is press the export button, go to
Sailwave and take the import function. We use Time On Distance so I have
to edit the race to enter distance, course, and wind information (wish this
info could be imported but not that big a deal) and then press “score
series”.
Don’t know if this makes any sense but it works
really well for our club and divides the labor up between the race manager and
scorer. The race manager barely knows how to use a computer but the
spread sheet is so easy to use he has no trouble doing this.
Wow that was a lot for a simple task, hope it makes
sense.
Sample pic of Spread Sheet
Bob
-----Original
Message-----
[mailto:sailwave@yahoogroups.com] On Behalf
Of Jack Kamer
···
From: sailwave@yahoogroups.com
Sent: Saturday, May 13, 2006 12:25 PM
To: sailwave@yahoogroups.com
Subject: Re: [sailwave] Re:
Elapsed time question
Bob, I’m not sure if this
was in an e-mail on sailwave or not. But in addition to starting with GPS
(atomic time) one of
our really experienced members told me that a simple way to account for
multiple starts without a lot of gyrations is
to simply enter the first start time as 00:05:00, second start 00:10:00, third 00:15:00, or whatever time between starts.
Then you simply record stopwatch elapsed time as finish time and SailWave does
the rest. This works like a champ.
Regarding your Excel sheet… Is the race manager responsible for entering all
the info you mentioned into the spreadsheet?
Does he have a computer at registration and starts it then? Just how does
it all happen?
I’d like to consider your kind offer, if I can make it work for us.
Thanks, Jack
uppa_hair wrote:
Jack,
Read your question on elapsed time and the response’s. Our club does
the same as yours so I wrote an Excel spread sheet that the Race Manager
use’s. He prints out the spread sheet and records the elapsed time.
After the race he enters the elapsed time for each yacht and emails to
me. The spread sheet contains the start times for each fleet (currently
3 but could be expanded) and a adjustment time for each fleet. I wrote
some Visual Basic code in the spread sheet to calculate out the actual
finish time and export to Sailwave the race number, fleet, yacht class,
sail number, helm, start time and finish time. It works great for us
although I do agree about other comments in recording GPS time, it hard
to get people to change. I have no problem sharing this with you if you
think it would be helpfull.
Bob Johnson