Ralph,
No problem, send me your email and I will
send it to you directly, that way it will not get sent to everyone in the user
group who don’t want it and have a slow internet connection.
Will send you the spread sheet so that
when you view the VB code you can refer back to the spread sheet to see how it
works. You will get a security warning in Excel about macros if your
security level is set to Medium or higher. You can either select disable
macros and just view the VB code or if you want to run the code you can either
lower security settings temporarily or you can elect install the certificate and
trust the publisher, which is me. If you need instructions on how to do
this, let me know and will send it in a word document.
Robert
-----Original
Message-----
[mailto:sailwave@yahoogroups.com] On Behalf
Of Ralph Tingle
···
From: sailwave@yahoogroups.com
Sent: Sunday, May 14, 2006 3:13 AM
To: sailwave@yahoogroups.com
Subject: RE: [sailwave] Re:
Elapsed time question
Hi Robert
Like the idea
of creating a csv file, automatically
Any chance of a copy of
your code please?
Save me having to use
some of the old grey cells!
Regards
Ralph
-----Original Message-----
From: Robert Johnson
[mailto:rrjohnson@wi.rr.com]
Sent: 13 May 2006 22:22
To: sailwave@yahoogroups.com
Subject: RE: [sailwave] Re:
Elapsed time question
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-----
From: sailwave@yahoogroups.com
[mailto:sailwave@yahoogroups.com] On Behalf
Of Jack Kamer
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 ofour really experienced members told me that a simple way to account for
multiple starts without a lot of gyrations isto 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