New Posts New Posts RSS Feed: Pursuit Race
  FAQ FAQ  Forum Search   Register Register  Login Login

Pursuit Race

 Post Reply Post Reply
Author
AlexM View Drop Down
Really should get out more
Really should get out more


Joined: 10 Jan 06
Online Status: Offline
Posts: 857
Post Options Post Options   Quote AlexM Quote  Post ReplyReply Direct Link To This Post Topic: Pursuit Race
    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

Back to Top
craiggo View Drop Down
Really should get out more
Really should get out more
Avatar

Joined: 01 Apr 04
Location: United Kingdom
Online Status: Offline
Posts: 1810
Post Options Post Options   Quote craiggo Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
AlexM View Drop Down
Really should get out more
Really should get out more


Joined: 10 Jan 06
Online Status: Offline
Posts: 857
Post Options Post Options   Quote AlexM Quote  Post ReplyReply Direct Link To This Post 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

Back to Top
chrisg View Drop Down
Really should get out more
Really should get out more
Avatar

Joined: 23 Mar 07
Location: United Kingdom
Online Status: Offline
Posts: 893
Post Options Post Options   Quote chrisg Quote  Post ReplyReply Direct Link To This Post 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

Back to Top
Matt Jackson View Drop Down
Really should get out more
Really should get out more
Avatar

Joined: 21 Sep 04
Location: Darlington
Online Status: Offline
Posts: 962
Post Options Post Options   Quote Matt Jackson Quote  Post ReplyReply Direct Link To This Post 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.

RS400 1289, Laser 203001
Back to Top
AlexM View Drop Down
Really should get out more
Really should get out more


Joined: 10 Jan 06
Online Status: Offline
Posts: 857
Post Options Post Options   Quote AlexM Quote  Post ReplyReply Direct Link To This Post 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

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
Change your personal settings, or read our privacy policy