Combining 2 Series for the Club Championship

Our season consists of two 10 race series. Each series allows 2
discards for each boat. We also award a club championship for the
best combined results from the 2 series. We interpret this as
meaning
who has the lowest total points when we add together the series
points
from series one and series two.

Is there a way to merge the results (series points) together from
each
of the series? I have found a way to merge the rank from the two
series together, but that would yield different results. Setting up
one large series with the results from both series would not maintain
our discard scheme nor would it maintain the way in that we score for
boats performing committee boat duty.

At this point we are publishing the championship scoring separately,
using an excel spreadsheet, but I'd like to find a better approach.

Any ideas?
Thanks,
Matt

Hi Matt, no way to automate this at present but I've noted the requirement.

Colin
www.sailwave.com

ยทยทยท

-----Original Message-----
From: sailwave@yahoogroups.com [mailto:sailwave@yahoogroups.com]On
Behalf Of mrgsail
Sent: 13 August 2005 19:38
To: sailwave@yahoogroups.com
Subject: [sailwave] Combining 2 Series for the Club Championship

Our season consists of two 10 race series. Each series allows 2
discards for each boat. We also award a club championship for the
best combined results from the 2 series. We interpret this as
meaning
who has the lowest total points when we add together the series
points
from series one and series two.

Is there a way to merge the results (series points) together from
each
of the series? I have found a way to merge the rank from the two
series together, but that would yield different results. Setting up
one large series with the results from both series would not maintain
our discard scheme nor would it maintain the way in that we score for
boats performing committee boat duty.

At this point we are publishing the championship scoring separately,
using an excel spreadsheet, but I'd like to find a better approach.

Any ideas?
Thanks,
Matt

-!- 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