Hi to ALL !
Our sailing federation organizes an annual cup, with 4 series, in 4 normal weekends. Each series may have up to 6 races, if wind conditions help. Total number of regattas may reach 24 races.
After the second series is finished, both Sailwave blw files are merged, almost without any manual adjustment. And so on, after the third and the fourth series.
Unfortunately, there is always issues to be adjusted.
After merging files, I order the results by Helmname.
Some duplicated entries occur with the same first name of helmname remain.
See merged file attached, see entry “Marcos Eduardo Cozza Val” and “Marcos Val”
My questions aiming to reduce of repetitions occurrences :
- ways of record creation in every single Sailwave that minimize the occurrence of duplicated entries after a merge.
- which field is more suitable to be the “primary key” regarding merge? ?sailnumber? ?boatname? ?helmname?
- the “tick fields” option that appears in “Merge series” window refers to the 2 above merge options ou just for the latter merge option
- Is there more to be adjusted to simplify the merged series with 4 series, up to 24 regattas with 30 to fifty sailors.
- in few words, what are the differences between the 3 merge alternatives; advantages, suitability, etc…
Tahnks again.
Nice holidays to everyone !
Sumula Copa FEVESP 2024 Olimp&Pan 2 series merged.blw (81.3 KB)