SRC-2 results for 2 fleets

   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?

Author	Message Share Topic Printable Version Delicious Digg Facebook Furl Google MySpace Newsvine reddit StumbleUpon Translate Twitter Windows Live Yahoo Bookmarks Topic Search Topic Options Post Reply Create New Topic
ClubRacer Send Private Message Find Member's Posts Far too distracted from work Joined: 26 Sep 15 Online Status: Offline Posts: 210	Post Options Post Reply Quote ClubRacer Report Post Quote Reply 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?

JimC Send Private Message Find Member's Posts Visit Member's Homepage Really should get out more Joined: 17 May 04 Location: United Kingdom Online Status: Offline Posts: 6661	Post Options Post Reply Quote JimC Report Post Quote Reply 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.

Kev M Send Private Message Find Member's Posts Far too distracted from work Joined: 05 Dec 11 Location: Landlocked Online Status: Offline Posts: 346	Post Options Post Reply Quote Kev M Report Post Quote Reply 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.

PeterG Send Private Message Find Member's Posts Really should get out more Joined: 12 Jan 08 Location: United Kingdom Online Status: Offline Posts: 822	Post Options Post Reply Quote PeterG Report Post Quote Reply 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 Ex Laser 189635 DY 59

ClubRacer Send Private Message Find Member's Posts Far too distracted from work Joined: 26 Sep 15 Online Status: Offline Posts: 210	Post Options Post Reply Quote ClubRacer Report Post Quote Reply 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

GML Send Private Message Find Member's Posts Groupie Joined: 24 Jul 11 Online Status: Offline Posts: 94	Post Options Post Reply Quote GML Report Post Quote Reply Posted: 02 Apr 17 at 8:40pm
	As JimC says, just upload the raw results into Sailwave and split the fleets there.

JimC Send Private Message Find Member's Posts Visit Member's Homepage Really should get out more Joined: 17 May 04 Location: United Kingdom Online Status: Offline Posts: 6661	Post Options Post Reply Quote JimC Report Post Quote Reply 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.