Race Management: Pursuit Race

Print Page | Close Window

Pursuit Race

Printed From: Yachts and Yachting Online
Category: General
Forum Name: Race Management
Forum Discription: For race officers and competiors to discuss the topic
URL: http://www.yachtsandyachting.com/forum/forum_posts.asp?TID=5241
Printed Date: 26 Jun 25 at 10:59am
Software Version: Web Wiz Forums 9.665y - http://www.webwizforums.com

Topic: Pursuit Race

Posted By: AlexM
Subject: Pursuit Race
Date Posted: 02 Mar 09 at 1:36pm

Just come up with a new spreadsheet to work out pursuit times, so before i start using it.... Is it right? it's rounded to the nearest 1/2 min for starts

the formulas

	A	B	C	D	E
1	Slowest Boat	PY	Length of Race	120	min
2	MIRROR	=VLOOKUP(A2,$A$6:$B$131,2,0)	Time of Start	14:00:00
3			Finish Time	=D2+(D1/1440)
4
5	Class	PY Number	Mins after first boat		Actual Start Time
6	MIRROR	1386	=CEILING($D$1-(B6/$B$2*$D$1),0.5)		=C6/(1440)+$D$2
7	TOPPER	1290	=CEILING($D$1-(B7/$B$2*$D$1),0.5)		=C7/(1440)+$D$2
8	LASER PICO	1264	=CEILING($D$1-(B8/$B$2*$D$1),0.5)		=C8/(1440)+$D$2
9	LASER PICO	1260	=CEILING($D$1-(B9/$B$2*$D$1),0.5)		=C9/(1440)+$D$2
10	LASER PICO RACE	1258	=CEILING($D$1-(B10/$B$2*$D$1),0.5)		=C10/(1440)+$D$2
11	TOPAZ UNO	1212	=CEILING($D$1-(B11/$B$2*$D$1),0.5)		=C11/(1440)+$D$2
12	TOPAZ UNO RACE	1207	=CEILING($D$1-(B12/$B$2*$D$1),0.5)		=C12/(1440)+$D$2

without

Slowest Boat	PY	Length of Race	120	min
MIRROR	1386	Time of Start	14:00:00
		Finish Time	16:00:00

Class	PY Number	Mins after first boat		Actual Start Time
MIRROR	1386	0.00		14:00:00
TOPPER	1290	8.50		14:08:30
LASER PICO	1264	11.00		14:11:00
LASER PICO	1260	11.00		14:11:00
LASER PICO RACE	1258	11.50		14:11:30
TOPAZ UNO	1212	15.50		14:15:30
TOPAZ UNO RACE	1207	15.50		14:15:30

Replies:

Posted By: craiggo
Date Posted: 02 Mar 09 at 4:29pm

Alex,

We normally run 90min pursuit races so my excel sheet is all based on 90mins races where a Topaz Uno would be 11mins behind a mirror. I have changed my spreadsheet to work off of 120mins and I get 15.05 mins for a Topaz Uno so would round to 15mins. I generally only round to 1min intervals otherwise there are to many sound signals!

PM me with your email address and I'll forward you my spreadsheet

Paul

Posted By: AlexM
Date Posted: 02 Mar 09 at 5:58pm

Hi Paul

Thanks for that, i get the same results as you

I've developed this spreadsheet hopefully to be full proof you only need to fill in the yellow boxs; slowest boat (select from drop down list), race length & race start time. it does the rest for you

Alex

-------------

Posted By: chrisg
Date Posted: 06 Mar 09 at 1:16pm

Alex,

Could i be cheeky and ask for a copy of your spreadsheet to have a look at it?

Chris

-------------

Posted By: Matt Jackson
Date Posted: 06 Mar 09 at 1:24pm

The rounding thing really annoys me as it means I usually get the same start as a Furball (we are just a little slower). The annoying thing is that unless it's honking you have to get a MASSIVE start and first beat to get in front and defend for the rest of the race!

Not a comment on your sheet... just had to get it off my chest.

-------------
Laser 203001, Harrier (H+) 36

Posted By: AlexM
Date Posted: 06 Mar 09 at 2:00pm

Chrisg - will send when i get home

Matt - i agree, this is why i rounded to 1/2min. might even do it for a 1/4min but might be hard work for the RO

On my spreadsheet it's going to give you 30sec head start in 1.5hr race

Slowest Boat	PY	Length of Race	90	min
TOPPER	1290	Time of Start	12:00:00
		Finish Time	13:30:00
Class	PY Number	Mins after first boat	Actual Start Time	Class
CONTENDER	993	21.00	12:21:00	CONTENDER
FIREBALL	982	21.50	12:21:30	FIREBALL

-------------