New Posts New Posts RSS Feed: SRC-2 results for 2 fleets
  FAQ FAQ  Forum Search   Register Register  Login Login

SRC-2 results for 2 fleets

 Post Reply Post Reply
Author
ClubRacer View Drop Down
Groupie
Groupie


Joined: 26 Sep 15
Online Status: Offline
Posts: 61
Post Options Post Options   Quote ClubRacer Quote  Post ReplyReply Direct Link To This Post Topic: SRC-2 results for 2 fleets
    Posted: 31 Mar 17 at 4:17pm
Anyone found an effective way of splitting the results in the CSV file once downloaded straight from the box?

The scenario goes like this;

2 starts are run from the box

Finshing the boats the 2 fleets are mixed

all boats finished download the file from the box over to computer

Open the CSV file and all boats from START2 need to be reduced in elapsed time by 5 minutes. This could be done by hand but would be time consuming, to the point i could have written the times down using a stopwatch in the first place ( this is made worse when a general recall is made)

Once the results are all corrected you've then got the issue of putting them into sailwave for each fleet. Currently im deleting all competitors from start 2, SAVE AS the file then upload to sailwave, Repeat this but deleting all competitors from start 1 instead. Again time consuming 



There has to be an easier work around for this?
Back to Top
JimC View Drop Down
Really should get out more
Really should get out more
Avatar

Joined: 17 May 04
Location: United Kingdom
Online Status: Online
Posts: 5459
Post Options Post Options   Quote JimC Quote  Post ReplyReply Direct Link To This Post Posted: 31 Mar 17 at 6:40pm
Not familar with exactly what you are doing or using, but have you tried importing the whole lot into Sailwave en masse, then creating two starts in Sailwave and altering the start times there? If you can import the elapsed times as being finish times, then you could set the first race as starting at midnight and the second as 00:05:00.
Back to Top
Kev M View Drop Down
Far too distracted from work
Far too distracted from work


Joined: 05 Dec 11
Location: Landlocked
Online Status: Offline
Posts: 346
Post Options Post Options   Quote Kev M Quote  Post ReplyReply Direct Link To This Post Posted: 02 Apr 17 at 8:55am
If you're using a csv file can't you just open it in excel, write an =SUM function to subtract the five minutes, drag this down the rows of results and then Copy and Paste As Values over the original numbers?
Successfully confusing ambition with ability since 1980.
Back to Top
PeterG View Drop Down
Really should get out more
Really should get out more


Joined: 12 Jan 08
Location: United Kingdom
Online Status: Offline
Posts: 573
Post Options Post Options   Quote PeterG Quote  Post ReplyReply Direct Link To This Post Posted: 02 Apr 17 at 9:13am
Assuming the CSV file has a column with START1 or START2 in it you could just do a sort, or filter, on that column to separate the two sections. Then cut and paste one of the sections to a different file. If you still need to adjust the start time Kev's answer above sorts that out.

Disclaimer, I've never used SRC-2 so I'm making assumptions about how it outputs data.
Peter
Ex Cont 707
Laser 189635
DY 59
Back to Top
ClubRacer View Drop Down
Groupie
Groupie


Joined: 26 Sep 15
Online Status: Offline
Posts: 61
Post Options Post Options   Quote ClubRacer Quote  Post ReplyReply Direct Link To This Post Posted: 02 Apr 17 at 7:59pm
thats what the csv file looks like,



writing a sum is only good if all cells in that column need the time reduced or they're grouped together

im currently already deleting the ones that aren't needed for the designated finish and reversing it for the 2nd one 


Edited by ClubRacer - 02 Apr 17 at 8:06pm
Back to Top
GML View Drop Down
Groupie
Groupie


Joined: 24 Jul 11
Online Status: Offline
Posts: 70
Post Options Post Options   Quote GML Quote  Post ReplyReply Direct Link To This Post Posted: 02 Apr 17 at 8:40pm
As JimC says, just upload the raw results into Sailwave and split the fleets there.
Back to Top
JimC View Drop Down
Really should get out more
Really should get out more
Avatar

Joined: 17 May 04
Location: United Kingdom
Online Status: Online
Posts: 5459
Post Options Post Options   Quote JimC Quote  Post ReplyReply Direct Link To This Post Posted: 02 Apr 17 at 9:12pm
Yep, I just checked it works with data like yours.
Import the elapsed times as being finish times (right click on the field during the import process lets you do this). The edit race and put in two starts, one for 12:00:00 and one for 12:05:00. If you don't have a field you can use to set the start from then you'll have to put one in. Then Sailwave should do everything else.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Bulletin Board Software by Web Wiz Forums® version 9.665y
Copyright ©2001-2010 Web Wiz