Gareth,
You've gotten two responses saying "try aliases" but I'm 99%s sure that
won't work because aliases only change which boats are compared to each
other and the calculation of points. You want to change the number and
identity of races to be counted, which aliases won't impact.
Let me describe what I think you want (after looking at your attached
results):
STARTER'S GUN
Count all races, no discards. (9 races and 9 scores, 0 discards, in your
example)
PERPETUAL CHALLENGE CUP [SOD]
For each boat for each day select the best race result from that day.
The entire day (i.e., best race from that day) counts as a single race.
[5 days and so 5 scores, 1 discard, in your example]
Playing with aliases and discards won't give you the ability to pick the
best score from a day and use only that score for the series (actually,
Sailwave might be able to do that using qualifying and final but only
for two days, which won't help you). The best way is going to be to do
the picking manually or automate it in Excel. Sailwave could do that
just as well as most other systems. Here is some methodology using only
Sailwave:
A. Do a regular series of all races in a single Sailwave file. That will
be your master.
B. After each day's racing, copy the BLW file to a new name and delete
all races except for the ones for that day.
C. In DAY file, modify the discards profile so all races are discarded
except the best for that day.
D. In DAY file, export the final scores, which should simply be the best
score of the best race of the day.
E. In NEW file, import the results from step D as a score for a single
race. You'll be able to add boats that didn't sail yet and do other
stuff. The "results" you import will be places rather than points but
since you seem to be using the Low Point System where points = places
that shouldn't be a problem except you'll probably need to mess around
with points for scoring codes such as DSQ, DNC, etc.
F. Now, you can publish the Perpetual Challenge Cup results from the NEW
file, which will count each day as a single race.
Personally, I prefer automation so I'd be inclined to use Sailwave for
step A only and then export and import to Excel and automate all the
rest in Excel using VBA (Visual Basic Application) macros in Excel.
You'd need someone experienced in Excel but that could make the process
somewhat simpler and faster. I believe there is a Sailwave facility to
export directly to Excel - part of a function to export results to
Excel, recalculate ratings and then import the new ratings. You might be
able to use just the export part. Sailwave can make entering results
easy so although you could "simplify" matters by doing all the scoring
in Excel that would mean you'd lose the nice Sail Number entry functions.
At my club we use Sailwave for some regattas but for our summer-long
series it cannot do the scoring we use so rather than sacrifice our
scoring we use a custom program for the race scoring and then Excel for
the series scoring. The race scores need to be exported and then
imported to Excel but after that it is clicking buttons to score and
create webpages.
If you want more info on Excel feel free to contact me directly. I could
provide a copy of our spreadsheet although it won't do you much good
unless you have a club member who is experienced with Excel macro
programming (for example, naming and uploading of files to our website
is also automated).
Art
···
On 9/11/2016 7:30 AM, Gareth Craig garethmcraig@gmail.com [sailwave] wrote:
Good Afternoon,
I've been combing through the FAQs and excellent ABYC Sailwave Users Guide
without success trying to work out if Sailwave is capable of meeting one
very peculiar requirement for our club regatta - namely can one series of
races be divided into different subsets for generating results.
We have a week long regatta every August with up to four races a day for a
mix of junior and senior one-design classes. Most of the classes are fairly
straight forward (one trophy for gold fleet, one trophy for silver fleet),
but the Shannon One Design (SOD) fleet do things a little differently where
"the championship" is a series within a series counting one race a day
(with one discard if 5 sailed) while "the Starters Gun" counts all races
(with no discards).
I can see how to set up prizes pulling out selective groups of competitors
(using either fleets or columns), but is it possible to do the same for
races?
I've attached a jpg of the main two SOD results sheets from this year (top
= all races, no discards | bottom = championship races, with discard), and
if you can't quite understand my explanation the full notice of race is at
https://files.acrobat.com/a/preview/c2458488-8bc8-413b-b2d1-0c6ba6f8bb3a
The club have been using a custom DOS-based programme for the last 25
years, but the one laptop left which will run it is close to the end (it
won't work on anything newer than Windows XP), as is the dotmatrix printer
it's hardcoded to output to!
Regards,
Gareth
120 Silchester Park, Glenageary, Co Dublin
+353-(0)87-2986286