Q _F Flight assignment when all flights did not sail the same number of races

General
1

Sorry if this is already answered or I am “blind”:

First day of qualification series. There are three flights: Yellow, Blue, Red. First day the Yellow and Blue finished 3 races, Red finishes 2 (R3 RED abandoned). By SI, only completed races count for the flight assignment for the day 2. The R3-Q3, Flight Red has to be finished first next day.

I entered all the results, including the partial R3-Q3, the scoring is done on all 3 races, giving DNC to the Red flight. I cannot use this as the sorting base for the flight assignment, it is against the SI.

It there a straight way to exclude, without deleting it, the R3 from the scoring when making the flight assignment?

Thanks, Walter

2

I have in mind one method, very error prone, so to be avoided if possible:

  1. Make all starts in R3 as “Discard me first”
  2. Change the discard profile to 0,0,1,…..
  3. Score and assign the flights for the races R4-Q4, R5-Q5, R6-Q6
  4. return to the original discard profile 0,0,0,1,1…..
  5. Uncheck all starts from “Discard me first”

Next day enter the last R3 Flight and score, than continue….

If you forget 4 and/or 5, the disaster is here, so that is there a better method?

3

Hi Walter,

Sorry to hear you have difficult situation. Short answer to your

It there a straight way to exclude, without deleting it, the R3 from the scoring when making the flight assignment?

is no, sorry.

The way you have outlined is one way of doing it, which is as you said subject to possible forgetfulness. But it is the only way to maintain the results already entered.

Another way is to delete the results for R3, do the flight re-assignment and then re-enter the results for R3. You could get the results already entered into a spreadsheet from which you could then import them. This would save you a lot of possible typing.

If you need more information on getting existing results into a spreadsheet then get in touch.
Kind regards,
Huw

4

Thank you very much. Fortunately, I have not yet a difficult situation, I am preparing to a pretty complicated event (Q+F+M) next week. Due to special discard profile defined by SI, I cannot separate Q and F races in different Sailwave files… So I am just simulating, searching for worst case scenarios :-).

I find the “Sail Num Wizard” very good for data entry, much better than XLS or compatibles.

I tried the Export Series Summary to Win Clipboard, deleted all unnecessary columns and rows in CSV, then adapted the CSV to the format (SailNo;RaceNo;Place;Code). The Import passed very well.

So this is surely a good way to do it. Just a little slower, but it is better and it is in line with the Race Management Guidelines and SI.

Is there another way to export only the “excluded” race to Spreadsheet (LibreOffice) before deleting it?

Best regards, Walter

5

Hi Walter,

Good for you doing such good preparatory work. I am aware of a couple of classes that have a discard profile that requires all scoring to be in one Sailwave file.

You can select which columns you want in the export to clipboard process, but you will need at least Nat and SailNo together with the race columns. You will then have to delete the R1 & R2 columns from the spreadsheet just as you have done already. Just a couple of columns to delete instead of a lot more.

Out of interest what is the event and what is the Medal Race format?
Kind regards,
Huw

6

Hi Walter

I did start answering earlier but Huw had already answered but one question is this a one design class or a handicap based event.

One trick you can do if it is one design is move the results for the race that is a problem to a competitor field such as bow number and then use the clear results for that race - do your flight assignment and move the results back afterwards
Let me know if you have any questions
Jon