Is there a way to import a part of finish data for an average lap handicap race?
So: race number, indentity field(s), number of laps for each boat.
Then start and finish times added when availalble.
e.g. number of laps gathered from tracker data, accurate times from committee boat.
I guess having laps without the time goes against the instant data entry checking?
Or any other reccomendations for dealing with large fleet data?
Hi Paul,
Why not as first pass import from tracker finish times and then update them from CB finish sheet?
Start times can be added to file as soon as should be known before any tracker info.
Kind regards,
Huw
Hi Huw,
Thanks for the suggestion, we have to consider any option as 4 races with up to 130 competitors would be a big ask. We have relied on it being day 1 of a 2 day event so a late night to get results sorted, but this year there was no racing on Day 1.
regards,
Paul
Hi Paul,
Wrote his a couple of days ago just found it in the drafts as I hadn’t clicked send
You can always enter the Race number and Start time at anytime
you can enter laps and finish time as soon as they are available
130 boats with 4 races shouldn’t be a problem at all as long as the results come in are clear to read and they are sent in as soon as they finish you will be in the bar to meet the sailors as they arrive. Might have to pop back to enter any Jury decisions but can’t help with that 
Jon
Hi Jon,
Sorry I disagree, perhaps you misunderstood the issue. The SailWave is prepared beforehand.
But the results are a list of sail numbers as they lap so say a list 250-300 long of numbers having done unknown numbers of laps and a list of 130 boats with times as they finish.
So take the first boat to be finished, go through the list, count laps, add one for finish, enter time and laps; go to the next etc. gradually crossing out all the boats listed on the sheets. Then sort out missed/wrong numbers, OCS etc. check against the other 2 recorded sets of data. Run through looking for typos and silly results.
Sailwave guestimates laps well making it easier to know where to look on the list but if at all windy there may have been capsizes throwing lap count out.
It is not practical to count number of laps on the water with 3 starts and 130 boats.
I find this could take easily 1 1/2 times the length of each race to do accurately. So with 4 races…
The difference between average lap handicap racing and a straight fleet racing.
Or are we just silly slow?
regards
Paul
Hi Paul,
Sorry you just had a list of finish times with the number of laps
It does take longer if you don’t know how many laps they have done and have to work it out from a list of numbers
There is a Grandprix finish program for Sailwave but this is designed for Non-handicap racing - Whether you could use it to set the laps might be worth experimenting with
Jon
following on from this, it would normally be known that starts are at e.g. 3 minute intervals. Is it possible to set subsequent starts to +3 , +6 , +9 etc. and then only have to enter the first start time as real time when entering results?. Just trying to minimise errors.
Hi Paul,
Sorry that is not currently possible - I could consider adding it but I think it would probably cause more problems than it would solve because +3 could be + 3 seconds or 3 minutes then there is the question of +3 after which start as you can reorder the starts. There is also the complication of general recalls affecting the order of the starts at some events. I think the complications that it would create outweigh the small savings that you would get.
Are there other users who think it would be worthwhile?
Did you have a play with the Grand Prix finish program?
Regards
Jon
Hi Jon,
I’ve now had a quick look at SWGP (took a while to find). It is definitely going in the right direction.
The excel I’ve been experimenting with doesn’t check sail numbers as they are entered, I would need to change to vba to be that clever.
It also needs to be able to record sail numbers that don’t appear in the entry list to help with recovery from mis-reading and authorised sail number changes that haven’t (yet) reached the scorer. It think it also needs to be easily editable (corrections).
I’ll think about a fuller specification and discuss with other interested parties. I don’t think the user base is likely to be large. Competing with pen and paper here.
Hi Paul,
You can use SWGP to quickly enter all the boats as they pass the line and this will count the laps
You can easily make corrections in the SWGP when in Finish Order
If you right-click on the left column you can insert and delete if you miss one or enter an incorrect number
Of course, you can also make corrections in Sailwave at any time
After you have clicked on the Corrected you will see this
As this was designed for one design then it doesn’t need to upload the laps to Sailwave but I could easily add that for you
My normal method of entry is I receive the finishing sheets via WhatsApp and then save the jpg to a webfolder on pCloud I then use my iPad (with a pen) to read the sheet and I can markup the image with the pen if there are numbers which don’t exist or I have guessed (1223 written as 1123 as an example) These can then be corrected later and I can then erase the markings on the image once they are fixed.
Jon
