Page 1 of 2

Racing software

PostPosted: February 22nd, 2010, 1:05 pm
by Dreadnought
The racing results software I have written now copes with handicaps using the SCHRS as well as Portsmouth Yardstick if required.

I have re-entered the results for the 2009 regatta races and they seem to come out in roughly the same order as before.

http://www.shanklinsailingclub.com/race ... ries_id=87
http://www.shanklinsailingclub.com/race ... ries_id=86

Re: Racing software

PostPosted: February 23rd, 2010, 7:59 am
by ChrisR
Keith has come up with a valid point regarding the SCHRS.
See your emails.

Re: Racing software

PostPosted: February 28th, 2010, 7:47 pm
by Dreadnought
I think I have more or less finished the software for racing results. Anybody with access to the admin section can now add, edit and delete series and do the same for sailors in the database.

The big test will come in three weeks time but I am quietly confident it is going to work.

If any other sailing clubs are interested in the software please give me a call on 01983 721264.

Re: Racing software

PostPosted: February 28th, 2010, 11:06 pm
by ChrisR
Lets wait untill we start then we can celibrate.
Realy need a handicap race to prove things.

Re: Racing software

PostPosted: March 1st, 2010, 10:11 am
by Dreadnought
ChrisR wrote:Lets wait untill we start then we can celibrate.
Realy need a handicap race to prove things.


That's not the attitude that won us an empire.

Re: Racing software

PostPosted: March 1st, 2010, 6:18 pm
by ChrisR
That's where I am going wrong, I would just like to win a rece, sod the empire, we will leave that race to Keith

Re: Racing software

PostPosted: March 22nd, 2010, 9:34 pm
by Dreadnought
I have updated the race series page so it shows the latest races: http://www.shanklinsailingclub.com/series.php (as long as we remember to put a date on).

There is also a new RSS feed for the racing results: http://www.shanklinsailingclub.com/race-results.xml .

Re: Racing software

PostPosted: March 22nd, 2010, 11:06 pm
by ChrisR
Where did the junior cup come from?

Re: Racing software

PostPosted: March 23rd, 2010, 9:41 am
by Dreadnought
ChrisR wrote:Where did the junior cup come from?


Last year.

However there is a bug in the RSS feed - it is currently showing series results, not race results.

Re: Racing software

PostPosted: March 23rd, 2010, 9:58 am
by Dreadnought
Bug fixed.

Re: Racing software

PostPosted: March 23rd, 2010, 11:42 am
by Dreadnought
ChrisR wrote:Where did the junior cup come from?

To avoid confusion the web page will now only show races in the current year.

Re: Racing software

PostPosted: September 13th, 2010, 5:51 pm
by Dreadnought
In expectation of a squeaky tight finish in the Tuesday Afternoon Series I have updated the racing results software to count back the best two discards and order results accordingly.

Positions will be defined by number of points after all discards, number of points after one less discard, number of points after 2 less discards.

If that doesn't separate Geoff and Keith then they will have to have a "who can piss the highest" competition to decide the winner.

Re: Racing software

PostPosted: September 14th, 2010, 8:43 am
by ChrisR
How wonderful technology is, I received notification of this post by Twitter, Geoff probably thinks it comes from a bird, Erling would be dumbfounded which will probably give Keith a chance as he knows more than the rest about computers. :twisted:

Re: Racing software

PostPosted: September 14th, 2010, 9:45 am
by Dreadnought
He's got a computer on board?

Re: Racing software

PostPosted: October 3rd, 2010, 6:37 pm
by Dreadnought
I have added a statistics facility to the race results software. Just click in your name in the race pages and you can see some details such as number of wins and average points.

Re: Racing software

PostPosted: October 3rd, 2010, 7:09 pm
by ChrisR
forum_admin wrote:I have added a statistics facility to the race results software. Just click in your name in the race pages and you can see some details such as number of wins and average points.

Getting very technical now

Re: Racing software

PostPosted: October 4th, 2010, 11:05 am
by Dreadnought
Discarded points are now scored through in a different colour to the number. I did this because it wasn't clear whether 4s were discarded or not.

Re: Racing software

PostPosted: October 4th, 2010, 8:24 pm
by Dreadnought
Added some graphs of the last 30 races for each helmsman. Just click on the names in the results pages.

Re: Racing software

PostPosted: November 14th, 2010, 11:42 pm
by Dreadnought
I have added all of the 2008 racing results to the database.

Re: Racing software

PostPosted: November 15th, 2010, 8:06 am
by ChrisR
What happened to 2009 & 2010

Re: Racing software

PostPosted: November 15th, 2010, 10:39 am
by Dreadnought
ChrisR wrote:What happened to 2009 & 2010


They were there anyway.

Re: Racing software

PostPosted: November 15th, 2010, 11:43 am
by Dreadnought
Those of you that subscribe to the RSS feeds may have noticed all the results being resent to you. This is because I have renamed all the files to be more friendly.

http://www.shanklinsailingclub.com/race ... ries_id=25
can now be viewed at
http://www.shanklinsailingclub.com/race ... Series.php

Re: Racing software

PostPosted: November 15th, 2010, 2:03 pm
by Dreadnought
As Shanklin Sailing Club is not very competitive, I thought I would add something to the site to give people more incentive.

I have made a table of average scores for the last two years' results. This is slightly different from the averages on individuals' pages as this shows races started instead of completed.

As soon as the first results of 2011 go on the site it will show 2010 and 2011.

http://www.shanklinsailingclub.com/whoishot.php

Re: Racing software

PostPosted: November 16th, 2010, 10:25 pm
by ChrisR
Why not call it WhoIsHot instead of points average.

Re: Racing software

PostPosted: November 16th, 2010, 10:33 pm
by Dreadnought
ChrisR wrote:Why not call it WhoIsHot instead of points average.


Do you think Geoff is hot then? :D

Re: Racing software

PostPosted: November 21st, 2010, 10:59 pm
by Dreadnought
I have made a page ranking helmsmen by number of firsts, seconds and thirds.

http://www.shanklinsailingclub.com/medalstable.php

Re: Racing software

PostPosted: November 23rd, 2010, 9:48 am
by Dreadnought
2007 racing results are now on the database so you can see the medals table and average points for that year.

Re: Racing software

PostPosted: November 23rd, 2010, 12:30 pm
by Dreadnought
Now that Chris is on a three day week, perhaps he might like to volunteer to add 2006 to the database.

Re: Racing software

PostPosted: December 2nd, 2010, 9:29 am
by Dreadnought
Big up Chris for putting the 2006 results on the web site. :D

Re: Racing software

PostPosted: December 2nd, 2010, 9:39 am
by ChrisR
Not all up yet

Re: Racing software

PostPosted: December 2nd, 2010, 11:47 pm
by Dreadnought
Now that there are five years' of statistics on the site, I have added a second graph to the helmsman pages showing averages over the five years.

The garish colours are generated randomly.

Re: Racing software

PostPosted: December 4th, 2010, 9:33 am
by Dreadnought
I have added a third graph to the helmsmen's pages showing firsts, seconds and thirds over the five years we have results for.

Re: Racing software

PostPosted: December 4th, 2010, 11:17 am
by ChrisR
Point me in the direction of the helmsman page

Re: Racing software

PostPosted: December 4th, 2010, 12:21 pm
by Dreadnought
If you go to any results page that contains names, you can click on the names to see more details.

For instance the points page has a list of all the regular sailors: http://www.shanklinsailingclub.com/whoishot.php

http://www.shanklinsailingclub.com/helm ... s_Read.php

Re: Racing software

PostPosted: December 4th, 2010, 5:45 pm
by ChrisR
Can this software be run from disk/exe file?????

Re: Racing software

PostPosted: December 4th, 2010, 5:56 pm
by Dreadnought
No, it's all in the cloud. But that means that it will work on any internet enabled device, not just a Windows PC.

ChrisR wrote:Can this software be run from disk/exe file?????

Re: Racing software

PostPosted: December 9th, 2010, 11:34 pm
by ChrisR
How would other would be interested parties e.g.:Clubs be able to access/purchase the scoring system.

Re: Racing software

PostPosted: December 9th, 2010, 11:40 pm
by Dreadnought
ChrisR wrote:How would other would be interested parties e.g.:Clubs be able to access/purchase the scoring system.



They would call 01983 721264 and ask for Liam.

Re: Racing software

PostPosted: December 10th, 2010, 2:30 pm
by ian bolton
Well , I can now see clearly how bad things have got. I think I will take up a new hobby. May be Knitting or something sumilar !

Re: Racing software

PostPosted: February 6th, 2011, 11:53 am
by Dreadnought
If my understanding of the Pro Am series is correct then the the software is now ready for it.

Re: Racing software

PostPosted: February 6th, 2011, 2:00 pm
by Dreadnought
The software is also ready for the Southern Championships. I have kept it completely separate from our own results so it will not effect the medals table and averages.

Re: Racing software

PostPosted: February 6th, 2011, 9:50 pm
by 195E
I think it is a very accurate and wonderful tool. :twisted:

Re: Racing software

PostPosted: April 18th, 2011, 10:16 am
by Dreadnought
Some of the more eagle-eyed amongst you will have noticed the Pursuit results for 2011 were upset by Keith and John getting average points and not having a total to average. This bug has now been fixed and Sean has now returned to the top of the table.

http://www.shanklinsailingclub.com/race ... Series.php

Re: Racing software

PostPosted: September 4th, 2011, 4:40 pm
by Dreadnought
Tie breaks

I have tweaked the racing software to deal with tie breaks.

Race series are now decided by the following criteria.

Lowest number of series points after discards are removed.
Number of firsts.
Number of seconds.
Number of thirds.
Lowest number of series points counting the best discard.
Lowest number of series points counting the two best discards.
Lowest number of series points counting all discarded points.
Position in last race in series.

Firsts, seconds, thirds and last result are regardless of whether they are discarded or not.

Hope that is OK with the VC.

The changes only show if I update a series.

Two changes that occur due to this system are Mark Pritchard is third in the Bang and Go Back series rather than joint third with myself, and Simon Giles no longer shares the 2010 Ventnor Race with Erling Holmberg but wins outright.

Re: Racing software

PostPosted: September 5th, 2011, 6:40 pm
by Dreadnought
I have tweaked it further so best result in series is now counted after number of thirds.

Re: Racing software

PostPosted: September 6th, 2011, 6:09 pm
by mckenna789
It is an amazing effort - thank you very much Liam.

Re: Racing software

PostPosted: September 26th, 2011, 10:33 am
by Dreadnought
Points averages for Picos and Sprint 15 races are now split for the two classes.

http://www.shanklinsailingclub.com/whoi ... ?year=2011

Re: Racing software

PostPosted: December 20th, 2012, 10:09 am
by Dreadnought
Our racing results software is now being used by Brading Haven Yacht Club

http://results.bhyc.org.uk/

Re: Racing software

PostPosted: December 20th, 2012, 11:50 am
by Erling H
Do the sailing club get commission?

Re: Racing software

PostPosted: December 20th, 2012, 12:10 pm
by Dreadnought
Erling H wrote:Do the sailing club get commission?


The club get commission fully commensurate with the amount of help they gave with the coding.