Hi Colin
Finally had some time to do sailing admin work.
Sorry, I Can't get 1.83 to caluclate portsmouth wind adjusted results... right now I score overall using wind adjusted portmouth and I get elapsed = corrected and the PN column is never populated.
RE import from regatta registration csv file.
How about this:-
1. Make the class match ignore spaces and puncuation characters.
In excell... I don't know how to do this. Right now... I sort on the boat class.... check my ratings file in another window for the proper name... cut and paste the proper name individually in excell.
2. If 1. is not anoug allow the specification of aliases at the start of a
rating file; e.g. "alias acat aclass"
That might work. At the end of the day... you want the boat class to use the name you have in your ratings file and publish this name in the sailwave spreadsheet and the published results.. no matter what bastardization they came up with on the registration system.
see below for example.
3. Put back the manuap rating updater with a better review of those
competitors it failed to update - i.e. showis a list and allows you to edit
the competitor from there.
Yes... I think this is needed as a second pass through the registration information.
The last mistake you want is a ratings mistake... You never catch those until it's late in the scoring game. Errors in data entry frequently jump right out at you ... especially now that you can sort on the column.
3. is needed anyway because if a user is not using the auto-update thingy
in the scoring system, they will occasionally want to update everybody's
ratings manually.
Well.... I have not been able to see the auto update thingy working.
I can do this, or something like it, for the next version.
This link is an example of how people will describe their boat class when left to their own devices.
http://www.sailregattas.com/crac/RegattaModules/ViewRegattaEntries.aspx?RegID=69&tabid=96&mid=219
The attached csv file contains a complete list of each competitors registration information that I suck into the appropriate Sailwave fields if that matters. I have massaged the info a bit to standardize boat class... club and some other stuff.
I edit the csv file before the import into sailwave.
BTW
How are the PHRF and IRC fleets managing their ratings in Sailwave. Do they validate each one by hand... EG see a copy of the ratings certificate and then enter into scoring program (Ugh!) or do they have a database of boats listed by their unique sailnumber issued by the RSA and the matching rating.
EG.
345678 Schneider Benetau 38.5 PHRF rating 68
...
I saw a club using Race Score ( I think). One feature that seemed useful was a pop up screen with a list of Sailnumbers that had not been assigned a result for a race.
BTW Right now... the system automatiicaly assigns a DNF when you don't enter any finish info whats so ever. You have to manually scan the spreadsheet for entries that haven't been acounted for properly.
For many clubs... they score one race for their annual event and matching the score sheets to the computer is their biggest headache. Especially if they have sailors not reporting that they retired. (last event)
Finally thoughts
Mixed fleets will record finish position and elapsed times. So... they have a numbered score sheet and every boat that crosses the line is recorded as sailnumber... no time... Use number of entry line as finish position. or sailnumber plust time. and the finish position
You might want to have an automatic tally tagged to the sail number wizard entry tool so that for each race you could sort on the line number of the finish sheet if you wanted. Error checking would then run down screen and make sure it matches the paper and pencil finsih position.
Thanks
Mark
···
> -----Original Message-----
> From: sailwave@yahoogroups.com
> [mailto:sailwave@yahoogroups.com]On Behalf Of Mark Schneider
> Sent: 20 August 2005 01:55
> To: sailwave@yahoogroups.com
> Subject: [sailwave] Wind ratings loading into version 1.82
>
> Hi Colin
>
> Hope you had a good vacation.
>
> I still don't know what to tell you that I need here. (other
> then it's not
> working)
>
> My problem is that I collect on line registration data. People describe
> their boat class with several variations on a theme... eg. A Cat...
> Aclass... A Class A-Class
>
> ONLY one of which will match your record in your handicap database.
>
> What to do now... I am not sure.
>
> I use to load all the entries as is and then edit each
> individual entry and
> change the boat class to the proper one that was in the database
> manually.
> I can't do this now. Sailwave 1.82 will update the rating and
> fill in the
> rating lines on the entry form ONLY if the boat is not a match to the
> database and you are changing the boat class from an unlisted
> varient to
> one that is in the database... you suck in the rating info and
> see it in the
> proper boxes. .... IF the names match exactly... however you can't get
> sailwave to load the rating at all. This is the current problem
> after your
> last fix.
>
> Previously I would hit the update ratings button and see which
> boats did not
> match and then go fix them manually.
>
> This just seems silly to do this manually. So the next thing I
> do is sort
> the csv file and change the names in groups to what I have used
> in the PN.
> database so they will match... (but the bug in sailwave won't let
> me update
> the ratings with the matching name)
>
> It seems to me that their ought to be an easy way to do this. I
> have lots
> of information in the csv on line registration file... but it
> seems to take
> forever to set up a regatta this way.
>
> I can't make sense out of what to do here though.
> So I am just confused about the whole thing.
>
> Thanks
> Mark
>
> >From: "Colin Jenkins" <colin@sailwave.com>
> >Reply-To: sailwave@yahoogroups.com
> >To: <sailwave@yahoogroups.com>
> >Subject: RE: [sailwave] Wind ratings loading into version 1.8
> >Date: Fri, 19 Aug 2005 08:36:13 +0100
> >
> >Hi mark,
> >
> >1.82 should have sorted this out, if not can you get back to me please.
> >Thanks.
> >
> >Colin
> >www.sailwave.com
> >
> > > -----Original Message-----
> > > From: sailwave@yahoogroups.com
> > > [mailto:sailwave@yahoogroups.com]On Behalf Of Mark Schneider
> > > Sent: 28 July 2005 19:46
> > > To: sailwave@yahoogroups.com
> > > Subject: RE: [sailwave] Wind ratings loading into version 1.8
> > >
> > > >
> > > >the manual update rating tool was replaced with a tick box in
> > > each scoring
> > > >system that can be applied - see the rating tab of a scoring system -
> > > >ticking this box means that the competitor ratings (and wind
> rats) are
> > > >updated as the scoring system is applied. this now means that
> > > if you want
> > > >to compare and contract the results from 3 (say) rating systems,
> > > you create
> > > >3 sxoring systems, setting the rating system in each appropriately,
> >and
> > > >ticking the box that says 'update ratings'. Then apply the
> > > scoring system
> > > >and publish 3 times. 'update ratings' means update form the
> > > rating files.
> > >
> > > Hi colin
> > >
> > > I undersand the system, however, it is not updating the wind adjusted
> > > ratings for the USPN system
> > > My default is USPN with Wind adjusted ratings.
> > > I set the 4 wind ranges up in the series option box
> > >
> > > When I select a boat class for the rating. I get the DPN rating
> > > added to the
> > > box below but the wind speed box for ratings is left blank.
> > >
> > > i score a regatta and set each race's wind speed
> > > When I score a race, and ask for rating used... they are all the
> > > DPN rating.
> > > When i publish the results ... it uses the DPN rating for each
> >individual
> > > race.
> > >
> > > Thanks
> > > Mark
> > >
> > > >
> > > >colin
> > > >www.sailwave.com
> > > >
> > > > > -----Original Message-----
> > > > > From: sailwave@yahoogroups.com
> > > > > [mailto:sailwave@yahoogroups.com]On Behalf Of Mark Schneider
> > > > > Sent: 28 July 2005 00:57
> > > > > To: sailwave@yahoogroups.com
> > > > > Subject: [sailwave] Wind ratings loading into version 1.8
> > > > >
> > > > > Hi Colin
> > > > >
> > > > > In 1.80 how do i update the ratings?
> > > > > When I select a boat class, I grab the DPN from the file but the
> >wind
> > > > > ratings are not updated in the registration window. (I worry)
> > > > >
> > > > > I don't know if they will be used when I score a race.
> > > > >
> > > > > Thanks
> > > > > Mark
> > > > >
> > > > > >From: "Colin Jenkins" <colin@sailwave.com>
> > > > > >Reply-To: sailwave@yahoogroups.com
> > > > > >To: <sailwave@yahoogroups.com>
> > > > > >Subject: [sailwave] Sailwave version 1.80 is available.
> > > > > >Date: Mon, 25 Jul 2005 15:11:18 +0100
> > > > > >
> > > > >
> > > > > _________________________________________________________________
> > > > > Express yourself instantly with MSN Messenger! Download today -
> > > > > it's FREE!
> > > > > http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > > > -!- http://www.yachtsandyachting.com/ -!- http://www.sailing.org/
> > > > > -!- http://www.sailwave.com/ -!-
> > > > >
> > > > > Latest versions of sailwave can be downloaded from the
> > > 'files' section
> > > >at
> > > > > http://groups.yahoo.com/group/sailwave/
> > > > >
> > > > > Convert to daily digest of emails send blank email to:
> > > > > sailwave-digest@yahoogroups.com
> > > > > Yahoo! Groups Links
> > > > >
> > > > > --
> > > > > No virus found in this incoming message.
> > > > > Checked by AVG Anti-Virus.
> > > > > Version: 7.0.338 / Virus Database: 267.9.4/57 - Release Date:
> > > 22/07/2005
> > > > >
> > > >--
> > > >No virus found in this outgoing message.
> > > >Checked by AVG Anti-Virus.
> > > >Version: 7.0.338 / Virus Database: 267.9.4/57 - Release Date:
> >22/07/2005
> > > >
> > > >-!- http://www.yachtsandyachting.com/ -!- http://www.sailing.org/ -!-
> > > >http://www.sailwave.com/ -!-
> > > >
> > > >Latest versions of sailwave can be downloaded from the
> 'files' section
> >at
> > > >http://groups.yahoo.com/group/sailwave/
> > > >
> > > >Convert to daily digest of emails send blank email to:
> > > >sailwave-digest@yahoogroups.com
> > > >Yahoo! Groups Links
> > > >
> > >
> > > _________________________________________________________________
> > > Express yourself instantly with MSN Messenger! Download today -
> > > it's FREE!
> > > http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
> > >
> > > -!- http://www.yachtsandyachting.com/ -!- http://www.sailing.org/
> > > -!- http://www.sailwave.com/ -!-
> > >
> > > Latest versions of sailwave can be downloaded from the
> 'files' section
> >at
> > > http://groups.yahoo.com/group/sailwave/
> > >
> > > Convert to daily digest of emails send blank email to:
> > > sailwave-digest@yahoogroups.com
> > > Yahoo! Groups Links
> > >
> > > --
> > > No virus found in this incoming message.
> > > Checked by AVG Anti-Virus.
> > > Version: 7.0.338 / Virus Database: 267.9.4/57 - Release Date:
> 22/07/2005
> > >
> >--
> >Internal Virus Database is out-of-date.
> >Checked by AVG Anti-Virus.
> >Version: 7.0.338 / Virus Database: 267.9.4/57 - Release Date: 22/07/2005
> >
> >-!- http://www.yachtsandyachting.com/ -!- http://www.sailing.org/ -!-
> >http://www.sailwave.com/ -!-
> >
> >Latest versions of sailwave can be downloaded from the 'files' section at
> >http://groups.yahoo.com/group/sailwave/
> >
> >Convert to daily digest of emails send blank email to:
> >sailwave-digest@yahoogroups.com
> >Yahoo! Groups Links
> >
>
> _________________________________________________________________
> Express yourself instantly with MSN Messenger! Download today -
> it's FREE!
> http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
>
> -!- http://www.yachtsandyachting.com/ -!- http://www.sailing.org/
> -!- http://www.sailwave.com/ -!-
>
> Latest versions of sailwave can be downloaded from the 'files' section at
> http://groups.yahoo.com/group/sailwave/
>
> Convert to daily digest of emails send blank email to:
> sailwave-digest@yahoogroups.com
> Yahoo! Groups Links
>
> --
> Internal Virus Database is out-of-date.
> Checked by AVG Anti-Virus.
> Version: 7.0.338 / Virus Database: 267.9.4/57 - Release Date: 22/07/2005
>
--
Internal Virus Database is out-of-date.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.9.4/57 - Release Date: 22/07/2005-!- http://www.yachtsandyachting.com/ -!- http://www.sailing.org/ -!- http://www.sailwave.com/ -!-
Latest versions of sailwave can be downloaded from the 'files' section at
http://groups.yahoo.com/group/sailwave/Convert to daily digest of emails send blank email to:
sailwave-digest@yahoogroups.com
Yahoo! Groups Links
_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/