Hi Guys, not a Sailwave question but a general scoring software question.
My Camera Club has 16 competitions per season. The results are, eventually, put on to an excel spreadsheet.
This is very clunky and very slow.
People are scored 1 - 10 for their photographs with the majority getting between 6 and 10. People aren’t scored as in a race, ie the winner gets 10 points, 2nd 9 etc, it’s your night’s score added to your running total and calculated to your best 9 competitions.
What I/we are looking for is a generalised scoring system that has to be unbelievably simple to use and can produce html results. I have tried to get them to use Sailwave but to no avail.
Does anyone have any idea if anything like this is available?
thanks… Simon
SUG Meister
…
Simon Smith
SimonLSmith@gmail.com
I think you are probably best with Excel and some customized macros.
The problem with using Excel for sailboat races is that you have way too many exceptions - DNS, DNC, DNF, BFD, DSQ, RDG, tie-breaking, etc. All of those things make it very complicated. Add in the handicap corrections and the programming task requires a lot of sophistication - the kind of sophistication that few people have and even fewer want to do on their own for just one club.
What you want to do is quite simple. Excel allows you to sum a list of 16 scores easily. It also allows you to sum the largest 9 easily as well. There are macros on the internet that can generate html files and other macros that will automatically upload files via FTP.
I've done this myself and it takes some Excel macro programming expertise but there are hundreds of websites out there with sample code and plenty of places where you could probably get help writing the VBA code.
With that said, you would think there would be simple scoring programs out there. I haven't searched myself but if there aren't any it is probably because the Excel macro route is so easy and widely available that it is probably used instead.
Art
···
On 5/25/2012 6:39 AM, Simon L. Smith wrote:
Hi Guys, not a Sailwave question but a general scoring software question.
My Camera Club has 16 competitions per season. The results are, eventually,
put on to an excel spreadsheet.
This is very clunky and very slow.
People are scored 1 - 10 for their photographs with the majority getting
between 6 and 10. People aren't scored as in a race, ie the winner gets 10
points, 2nd 9 etc, it's your night's score added to your running total and
calculated to your best 9 competitions.
What I/we are looking for is a generalised scoring system that has to be
unbelievably simple to use and can produce html results. I have tried to
get them to use Sailwave but to no avail.
Does anyone have any idea if anything like this is available?
thanks... Simon
SUG Meister
....
Simon Smith
SimonLSmith@gmail.com