Unfortunately, neither of these approaches appear to do what I want.
I want to use the highpoint scores by division to determine the overall winner. These approaches will rescore all the boats together as one division (“Overall”), and won’t use the accumulated highpoint scores in the individual divisions. The divisions I have are multihulls, monohulls, and one designs, that are scored using different rating systems (Portsmouth, PHRF, Place), and may even use different courses.
However, I wasn’t aware of the ability to export CSVs, so I may just create my own output, unless there are other ideas.
Regards,
Tom
···
Hi Tom,
Presuming you score by Division already.
I do this with elapsed times. I think it should work with Scored Points
- Export series to Windows clipboard, tab delimited. Currently visible
race cell value is exported (Scored Points)
2. Paste into Excel, twice
3. Change the Division for the second copy to ‘Overall’ or whatever you
want to call it.
4. Export to CSV
5. Use import series from CSV file into a new Sailwave file.
Hallo Tom,
I use aliases. Activate “aliases” in user defined settings, copy every boat/competitor, change division to “overall” and define an alias to the
original competitor. Then You can use standard publishing templates …
All works automatic! No copying to clipboard or excel needed!
Chears
Christof
On Sun, Feb 19, 2012 at 6:10 AM, eagleshore eagleshore@gmail.com wrote:
**
I am scoring multiple divisions in a series separately using CHIPS
highpoint scoring, but would like to publish an overall series
ranking/winner by total points accumulated by boat. I can sort the
competitors by total points to see the series ranking, but I can’t find any
way to publish this overall result.
Is there a way to “fake” the program to publish the result, or provide a
way to get in the program? Right now, all I can do is do a screen copy.
Thanks.
Tom Tomlinson
Mayfield Yacht Club
Hi Tom,
Yes I see.
Then I agree that export would work. But I think you’ll find using Export Series Summary To Clipboard but using TAB delimited, and then paste that into Excel will be easier than CSV. If you use CSV you’ll need to save it in a file and then open that in Excel.
regards
Rob
···
On Mon, Feb 20, 2012 at 3:49 AM, Harold Tomlinson eagleshore@gmail.com wrote:
Unfortunately, neither of these approaches appear to do what I want.
I want to use the highpoint scores by division to determine the overall winner. These approaches will rescore all the boats together as one division (“Overall”), and won’t use the accumulated highpoint scores in the individual divisions. The divisions I have are multihulls, monohulls, and one designs, that are scored using different rating systems (Portsmouth, PHRF, Place), and may even use different courses.
However, I wasn’t aware of the ability to export CSVs, so I may just create my own output, unless there are other ideas.
Regards,
Tom
Hi Tom,
Presuming you score by Division already.
I do this with elapsed times. I think it should work with Scored Points
- Export series to Windows clipboard, tab delimited. Currently visible
race cell value is exported (Scored Points)
2. Paste into Excel, twice
3. Change the Division for the second copy to ‘Overall’ or whatever you
want to call it.
4. Export to CSV
5. Use import series from CSV file into a new Sailwave file.
Hallo Tom,
I use aliases. Activate “aliases” in user defined settings, copy every boat/competitor, change division to “overall” and define an alias to the
original competitor. Then You can use standard publishing templates …
All works automatic! No copying to clipboard or excel needed!
Chears
Christof
On Sun, Feb 19, 2012 at 6:10 AM, eagleshore eagleshore@gmail.com wrote:
**
I am scoring multiple divisions in a series separately using CHIPS
highpoint scoring, but would like to publish an overall series
ranking/winner by total points accumulated by boat. I can sort the
competitors by total points to see the series ranking, but I can’t find any
way to publish this overall result.
Is there a way to “fake” the program to publish the result, or provide a
way to get in the program? Right now, all I can do is do a screen copy.
Thanks.
Tom Tomlinson
Mayfield Yacht Club
I think I want to do exactly the same thing and thought I could but maybe I cannot (I've been getting ready for 2013 so we can practice-score during 2012). My structure and terminology (to avoid confusion) are: boats race in a class (or fleet if you prefer that name) against the boats in that class; classes are part of a division; the multiple divisions make up the series. At the end of the series, each boat will have a "class" series score, meaning how she did in all the races in her class. All the series class scores for boats in the same division will then be compared (no races rescored!!) against the all the boats in the division and we will determine Overall Division winners.
When I look at the responses you got, the second one (from Rob Goodridge) gives an answer with a possible approach (although I think he misunderstood what you were trying to do). I believe Rob is saying that you can export to CSV and *only* what is shown on the screen will export. So, from your file that scores by class you could export just the points scored. Unfortunately, there appears to be no way to import that data back into Sailwave. The "Import series from CSV file" does *almost* what you want but can only import places or elapsed times. What you want to import is the points as the "score" for a race but you cannot import scores. It will either treat the imported score as a place or elapsed time, depending on which option you choose.
Of course, you can take the exported data and put it into Excel but then your series results would look very different from the Sailwave results output for individual races.
In playing with this I found a somewhat unrelated problem (or if you prefer Microsoft-speak, a "feature"). If I export with the default configuration for codes "points[space]code" I get something like "nn.n DNF" for example. When I reimport that as a CSV it treats the whole thing as a new code rather than a score followed by a code. I can "fix" it by showing only codes before exporting (using Global Options) but then the score is lost, which might be pretty significant with redress and penalties.
Art
···
On 2/19/2012 8:49 AM, Harold Tomlinson wrote:
Unfortunately, neither of these approaches appear to do what I want.
I want to use the highpoint scores *by division* to determine the overall
winner. These approaches will rescore all the boats together as one
division ("Overall"), and won't use the accumulated highpoint scores in the
individual divisions. The divisions I have are multihulls, monohulls, and
one designs, that are scored using different rating systems (Portsmouth,
PHRF, Place), and may even use different courses.
However, I wasn't aware of the ability to export CSVs, so I may just create
my own output, unless there are other ideas.
Regards,
Tom
-------------------------------------------------------------------------------------
Hi Tom,
Presuming you score by Division already.
I do this with elapsed times. I think it should work with Scored Points
1. Export series to Windows clipboard, tab delimited. Currently visible
race cell value is exported (Scored Points)
2. Paste into Excel, twice
3. Change the Division for the second copy to 'Overall' or whatever you
want to call it.
4. Export to CSV
5. Use import series from CSV file into a new Sailwave file.
-------------------------------------------------------------------------------------
Hallo Tom,
I use aliases. Activate "aliases" in user defined settings, copy every
boat/competitor, change division to "overall" and define an alias to the
original competitor. Then You can use standard publishing templates ...
All works automatic! No copying to clipboard or excel needed!
Chears
Christof
On Sun, Feb 19, 2012 at 6:10 AM, eagleshore<eagleshore@gmail.com> wrote:
**
I am scoring multiple divisions in a series separately using CHIPS
highpoint scoring, but would like to publish an overall series
ranking/winner by total points accumulated by boat. I can sort the
competitors by total points to see the series ranking, but I can't find
any
way to publish this overall result.
Is there a way to "fake" the program to publish the result, or provide a
way to get in the program? Right now, all I can do is do a screen copy.
Thanks.
Tom Tomlinson
Mayfield Yacht Club
Hi Art,
I think back into SailWave is not curerntly possible.
If Excel is OK, wouldn’t just using the Nett points and sorting by that and Division give you the result you want. Individual races are irrelevant? Or do you actually want a race by race breakdown?
It’s a little work, but the Excel output could be formatted like SailWave.
regards
Rob
···
On Mon, Feb 20, 2012 at 9:44 AM, Art Engel artengel123@earthlink.net wrote:
I think I want to do exactly the same thing and thought I could but
maybe I cannot (I’ve been getting ready for 2013 so we can
practice-score during 2012). My structure and terminology (to avoid
confusion) are: boats race in a class (or fleet if you prefer that name)
against the boats in that class; classes are part of a division; the
multiple divisions make up the series. At the end of the series, each
boat will have a “class” series score, meaning how she did in all the
races in her class. All the series class scores for boats in the same
division will then be compared (no races rescored!!) against the all the
boats in the division and we will determine Overall Division winners.
When I look at the responses you got, the second one (from Rob
Goodridge) gives an answer with a possible approach (although I think he
misunderstood what you were trying to do). I believe Rob is saying that
you can export to CSV and only what is shown on the screen will
export. So, from your file that scores by class you could export just
the points scored. Unfortunately, there appears to be no way to import
that data back into Sailwave. The “Import series from CSV file” does
almost what you want but can only import places or elapsed times. What
you want to import is the points as the “score” for a race but you
cannot import scores. It will either treat the imported score as a place
or elapsed time, depending on which option you choose.
Of course, you can take the exported data and put it into Excel but then
your series results would look very different from the Sailwave results
output for individual races.
In playing with this I found a somewhat unrelated problem (or if you
prefer Microsoft-speak, a “feature”). If I export with the default
configuration for codes “points[space]code” I get something like “nn.n
DNF” for example. When I reimport that as a CSV it treats the whole
thing as a new code rather than a score followed by a code. I can “fix”
it by showing only codes before exporting (using Global Options) but
then the score is lost, which might be pretty significant with redress
and penalties.
Art
On 2/19/2012 8:49 AM, Harold Tomlinson wrote:
Unfortunately, neither of these approaches appear to do what I want.
I want to use the highpoint scores by division to determine the overall
winner. These approaches will rescore all the boats together as one
division (“Overall”), and won’t use the accumulated highpoint scores in the
individual divisions. The divisions I have are multihulls, monohulls, and
one designs, that are scored using different rating systems (Portsmouth,
PHRF, Place), and may even use different courses.
However, I wasn’t aware of the ability to export CSVs, so I may just create
my own output, unless there are other ideas.
Regards,
Tom
Hi Tom,
Presuming you score by Division already.
I do this with elapsed times. I think it should work with Scored Points
- Export series to Windows clipboard, tab delimited. Currently visible
race cell value is exported (Scored Points)
- Paste into Excel, twice
- Change the Division for the second copy to ‘Overall’ or whatever you
want to call it.
- Export to CSV
- Use import series from CSV file into a new Sailwave file.
Hallo Tom,
I use aliases. Activate “aliases” in user defined settings, copy every
boat/competitor, change division to “overall” and define an alias to the
original competitor. Then You can use standard publishing templates …
All works automatic! No copying to clipboard or excel needed!
Chears
Christof
On Sun, Feb 19, 2012 at 6:10 AM, eagleshoreeagleshore@gmail.com wrote:
**
I am scoring multiple divisions in a series separately using CHIPS
highpoint scoring, but would like to publish an overall series
ranking/winner by total points accumulated by boat. I can sort the
competitors by total points to see the series ranking, but I can’t find
any
way to publish this overall result.
Is there a way to “fake” the program to publish the result, or provide a
way to get in the program? Right now, all I can do is do a screen copy.
Thanks.
Tom Tomlinson
Mayfield Yacht Club
Yes, I think I can figure out a forced solution.
I can export the columns I want for series results - probably boat name, helm name, class, fleet etc. plus all the race columns and the Total and Nett (that way competitors can check the math is correct (important!)). Then I would have to re-sort by Nett and insert a column with the places.
This method has two drawbacks - 1) it is a manual process, which leaves an opportunity for errors to creep in plus will take more time and effort; and, 2) I doubt I could get Excel to do the same formatting as Sailwave (plus the html code generated by Excel is truly awful). It also wouldn't handle ties but those are rare at the end of a long series.
What I think might be great (but maybe not used enough to be worth Colin's time to code) would be the ability to score races separate from scoring the series and the ability to score the series based on different fields. Then we could score and publish each race week by week. To get series results we could do "series score by class" to get series class results and do "series score by division" to get series overall results. No points would change but the places would change as a boat might be 4th in class but 20th in division with the same points.
Art
···
On 2/19/2012 3:16 PM, Rob Goodridge wrote:
Hi Art,
I think back into SailWave is not curerntly possible.
If Excel is OK, wouldn't just using the Nett points and sorting by that and
Division give you the result you want. Individual races are irrelevant? Or
do you actually want a race by race breakdown?
It's a little work, but the Excel output could be formatted like SailWave.
regards
Rob