merging daily results into a season series

Imported from Yahoo
1

Hi,
Our frostbite series has 13-16 days of racing each winter. Each day
there are a variable number of racers that show up to race. The
season standings are calculated using the average score for the races
that each racer sctually competes in (A racer is not scored DNC for
races that he/she does not compete in). My plan is to score each day
separately, but I can't figure out how to merge the daily results
into a season file that will do what I want. Any ideas?
Thanks,
Scott Walker

2

I do it by taking a copy of the series file, deleting all the
existing races, then entering results for the day's racing. Then I
save it, with a new name of course. Now I can merge that day's races
and results into the two other series files that use those results.

The only PITA is that after merging in the new results, I have to
edit those merged Race properties again - the information on the race
itself is not carried over in the merge.

Chip

Hi,
Our frostbite series has 13-16 days of racing each winter. Each

day

there are a variable number of racers that show up to race. The
season standings are calculated using the average score for the

races

that each racer sctually competes in (A racer is not scored DNC for
races that he/she does not compete in). My plan is to score each

day

···

--- In sailwave@yahoogroups.com, "wsw40416" <wsw40416@y...> wrote:

separately, but I can't figure out how to merge the daily results
into a season file that will do what I want. Any ideas?
Thanks,
Scott Walker

3

I'm having trouble making the "merge" work. What are the steps for doing this?
Thanks!
Scott

I do it by taking a copy of the series file, deleting all the
existing races, then entering results for the day's racing. Then I
save it, with a new name of course. Now I can merge that day's races
and results into the two other series files that use those results.

The only PITA is that after merging in the new results, I have to
edit those merged Race properties again - the information on the race
itself is not carried over in the merge.

Chip

Hi,
Our frostbite series has 13-16 days of racing each winter. Each

day

there are a variable number of racers that show up to race. The
season standings are calculated using the average score for the

races

that each racer sctually competes in (A racer is not scored DNC for
races that he/she does not compete in). My plan is to score each

day

separately, but I can't figure out how to merge the daily results
into a season file that will do what I want. Any ideas?
Thanks,
Scott Walker

-!- http://www.fastmail.fm/ -!- http://www.spampal.org/ -!- http://www.sailwave.com/ -!-

Convert to daily digest of emails send blank email to:
sailwave-digest@yahoogroups.com

Yahoo! Groups SponsorADVERTISEMENT

···

Chip Stratton <cstrat@swbell.net> wrote:
--- In sailwave@yahoogroups.com, "wsw40416" <wsw40416@y...> wrote:

---------------------------------
Yahoo! Groups Links

   To visit your group on the web, go to:

  
   To unsubscribe from this group, send an email to:
sailwave-unsubscribe@yahoogroups.com
  
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

---------------------------------
Do you Yahoo!?
Check out the new Yahoo! Front Page. www.yahoo.com

[Non-text portions of this message have been removed]

4

Makes sense... I'm having trouble just doing the initial merge,
though. What are the steps for doing this?
Scott

I do it by taking a copy of the series file, deleting all the
existing races, then entering results for the day's racing. Then I
save it, with a new name of course. Now I can merge that day's

races

and results into the two other series files that use those results.

The only PITA is that after merging in the new results, I have to
edit those merged Race properties again - the information on the

race

itself is not carried over in the merge.

Chip

>
>
> Hi,
> Our frostbite series has 13-16 days of racing each winter. Each
day
> there are a variable number of racers that show up to race. The
> season standings are calculated using the average score for the
races
> that each racer sctually competes in (A racer is not scored DNC

for

···

--- In sailwave@yahoogroups.com, "Chip Stratton" <cstrat@s...> wrote:

--- In sailwave@yahoogroups.com, "wsw40416" <wsw40416@y...> wrote:
> races that he/she does not compete in). My plan is to score each
day
> separately, but I can't figure out how to merge the daily results
> into a season file that will do what I want. Any ideas?
> Thanks,
> Scott Walker

5

wsw40416 wrote:

Hi,
Our frostbite series has 13-16 days of racing each winter. Each day there are a variable number of racers that show up to race. The season standings are calculated using the average score for the races that each racer sctually competes in (A racer is not scored DNC for races that he/she does not compete in). My plan is to score each day separately, but I can't figure out how to merge the daily results into a season file that will do what I want. Any ideas?
Thanks,
Scott Walker

In the summary series do you want to see a column for each race of each day or a column per day?

Regards,
Colin J
www.sailwave.com

6

Hi Colin,
I would like a column for each race of each day in the summary series.
Thanks,
Scott Walker

wsw40416 wrote:

Hi,
Our frostbite series has 13-16 days of racing each winter. Each day
there are a variable number of racers that show up to race. The
season standings are calculated using the average score for the races
that each racer sctually competes in (A racer is not scored DNC for
races that he/she does not compete in). My plan is to score each day
separately, but I can't figure out how to merge the daily results
into a season file that will do what I want. Any ideas?
Thanks,
Scott Walker

In the summary series do you want to see a column for each race of each
day or a column per day?

Regards,
Colin J
www.sailwave.com

-!- http://www.fastmail.fm/ -!- http://www.spampal.org/ -!- http://www.sailwave.com/ -!-

Convert to daily digest of emails send blank email to:
sailwave-digest@yahoogroups.com

Yahoo! Groups SponsorADVERTISEMENT

···

Colin Jenkins <colin@sailwave.com> wrote:

---------------------------------
Yahoo! Groups Links

   To visit your group on the web, go to:

  
   To unsubscribe from this group, send an email to:
sailwave-unsubscribe@yahoogroups.com
  
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

---------------------------------
Do you Yahoo!?
Check out the new Yahoo! Front Page. www.yahoo.com

[Non-text portions of this message have been removed]

7

I may have missed the point (very likely) but why can't you just have
one series and score DNC as Average of (Sum of all races) and Overall
Series points as Average of non-discarded races (and set discards to 0
obviously)? This seems to work ok on 1.58beta.

Patrick Gaunt

Colin Jenkins <colin@s...> wrote:
wsw40416 wrote:
> Hi,
> Our frostbite series has 13-16 days of racing each winter. Each

day

> there are a variable number of racers that show up to race. The
> season standings are calculated using the average score for the

races

> that each racer sctually competes in (A racer is not scored DNC

for

> races that he/she does not compete in). My plan is to score each

day

> separately, but I can't figure out how to merge the daily results
> into a season file that will do what I want. Any ideas?
> Thanks,
> Scott Walker
>

In the summary series do you want to see a column for each race of

each

day or a column per day?

Regards,
Colin J
www.sailwave.com

-!- http://www.fastmail.fm/ -!- http://www.spampal.org/ -!-

http://www.sailwave.com/ -!-

Convert to daily digest of emails send blank email to:
sailwave-digest@yahoogroups.com

Yahoo! Groups SponsorADVERTISEMENT

---------------------------------
Yahoo! Groups Links

   To visit your group on the web, go to:
http://groups.yahoo.com/group/sailwave/
  
   To unsubscribe from this group, send an email to:
sailwave-unsubscribe@yahoogroups.com
  
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of

Service.

···

---------------------------------
Do you Yahoo!?
Check out the new Yahoo! Front Page. www.yahoo.com

[Non-text portions of this message have been removed]

8

Hi Scott,

Currently the way to have a summary series is to create a series for each short event and then after scoring them merge them into a further series summary file. There is a merge option to create a race using the final points of the merged series. You can then choose a series scoring method of average point for the summary series. This is an approximation of an average of all the races, which as Patrick pointed out can be done in a single series, but you then loose day results.

Regards,
Colin J
www.sailwave.com

s w wrote:

···

Hi Colin,
I would like a column for each race of each day in the summary series.
Thanks,
Scott Walker

Colin Jenkins <colin@sailwave.com> wrote:
wsw40416 wrote:

Hi,
Our frostbite series has 13-16 days of racing each winter. Each day there are a variable number of racers that show up to race. The season standings are calculated using the average score for the races that each racer sctually competes in (A racer is not scored DNC for races that he/she does not compete in). My plan is to score each day separately, but I can't figure out how to merge the daily results into a season file that will do what I want. Any ideas?
Thanks,
Scott Walker

In the summary series do you want to see a column for each race of each day or a column per day?

Regards,
Colin J
www.sailwave.com

-!- http://www.fastmail.fm/ -!- http://www.spampal.org/ -!- http://www.sailwave.com/ -!-

Convert to daily digest of emails send blank email to:
sailwave-digest@yahoogroups.com

Yahoo! Groups SponsorADVERTISEMENT

---------------------------------
Yahoo! Groups Links

   To visit your group on the web, go to:
http://groups.yahoo.com/group/sailwave/
     To unsubscribe from this group, send an email to:
sailwave-unsubscribe@yahoogroups.com
     Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

---------------------------------
Do you Yahoo!?
Check out the new Yahoo! Front Page. www.yahoo.com

[Non-text portions of this message have been removed]

-!- http://www.fastmail.fm/ -!- http://www.spampal.org/ -!- http://www.sailwave.com/ -!-

Convert to daily digest of emails send blank email to:
sailwave-digest@yahoogroups.com Yahoo! Groups Links

9

Hi Patrick,

Yes I agree, that would work, but at the loss of the day results.

Regards,
Colin J
www.sailwave.com

patrickgaunt wrote:

···

I may have missed the point (very likely) but why can't you just have
one series and score DNC as Average of (Sum of all races) and Overall
Series points as Average of non-discarded races (and set discards to 0
obviously)? This seems to work ok on 1.58beta.

Patrick Gaunt

Colin Jenkins <colin@s...> wrote:
wsw40416 wrote:

Hi,
Our frostbite series has 13-16 days of racing each winter. Each

day

there are a variable number of racers that show up to race. The season standings are calculated using the average score for the

races

that each racer sctually competes in (A racer is not scored DNC

for

races that he/she does not compete in). My plan is to score each

day

separately, but I can't figure out how to merge the daily results into a season file that will do what I want. Any ideas?
Thanks,
Scott Walker

In the summary series do you want to see a column for each race of

each

day or a column per day?

Regards,
Colin J
www.sailwave.com

-!- http://www.fastmail.fm/ -!- http://www.spampal.org/ -!-

http://www.sailwave.com/ -!-

Convert to daily digest of emails send blank email to:
sailwave-digest@yahoogroups.com

Yahoo! Groups SponsorADVERTISEMENT

---------------------------------
Yahoo! Groups Links

  To visit your group on the web, go to:
http://groups.yahoo.com/group/sailwave/
   To unsubscribe from this group, send an email to:
sailwave-unsubscribe@yahoogroups.com
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of

Service.

---------------------------------
Do you Yahoo!?
Check out the new Yahoo! Front Page. www.yahoo.com

[Non-text portions of this message have been removed]

-!- http://www.fastmail.fm/ -!- http://www.spampal.org/ -!- http://www.sailwave.com/ -!-

Convert to daily digest of emails send blank email to:
sailwave-digest@yahoogroups.com Yahoo! Groups Links