BSC RACE RESULTS

PRO:

Chris Killion

RC1

Sally Morris

RC2

David Glasgow

RC3

Gill Gilmore

RC4

RACE ONE

RACE TWO

RACE THREE

RACE FOUR

RACE FIVE

Date:

6/6/2010

Wind Speed=>

4.1 to 12.0

4.1 to 12.0

4.1 to 12.0

4.1 to 12.0

Unknown

Total

Pts

Lapse Time

Corrected

Lapse Time

Corrected

Lapse Time

Corrected

Lapse Time

Corrected

Lapse Time

Corrected

Skipper

Boat Type

Sail #

Pts

Rank

(h:mm:ss)

Time

Pts

(h:mm:ss)

Time

Pts

(h:mm:ss)

Time

Pts

(h:mm:ss)

Time

Pts

(h:mm:ss)

Time

Pts

1

Loy Vaughan

TH

4007

10

1

0:14:23

0:17:20

6

0:12:22

0:14:54

2

83

0:15:52

0:19:07

1

0:11:50

0:14:15

1

0:00:00

1

Michael Papp

SN

28400

10

1

0:11:23

0:12:18

1

0:14:48

0:16:00

3

92.5

0:19:11

0:20:44

4

0:14:22

0:15:32

2

0:00:00

3

Graham Vaughan

LASE

1

20

3

0:12:10

0:13:11

3

0:16:34

0:17:57

7

92.3

0:21:21

0:23:08

7

0:14:48

0:16:02

3

0:00:00

4

Richard Scarborough

BCN

5258

23

4

DNS

13

0:12:57

0:14:53

1

87

0:18:24

0:21:09

5

0:14:35

0:16:46

4

0:00:00

5

Tim Pack

FSCT

5090

24

5

0:11:52

0:13:08

2

0:17:16

0:19:06

8

90.4

0:24:02

0:26:35

9

0:15:42

0:17:22

5

0:00:00

6

Trent Richardson

J-22

926

28

6

DNS

13

0:13:38

0:16:29

4

82.7

0:17:00

0:20:33

3

0:14:59

0:18:07

8

0:00:00

7

Jack Rogers

SNT23

83

34

7

DNS

13

0:14:55

0:17:40

6

84.4

0:16:57

0:20:05

2

DNS

13

0:00:00

8

Danny Waters

SN

27332

35

8

0:19:31

0:21:06

7

0:18:10

0:19:38

9

92.5

0:25:26

0:27:30

10

0:18:32

0:20:02

9

0:00:00

9

Van Rodgers

FSCT

316

36

9

0:12:31

0:13:51

4

DNS

13

90.4

0:19:23

0:21:27

6

DNS

13

0:00:00

10

Mike Schuster

TH

3034

37

10

DNS

13

0:16:45

0:20:11

10

83

0:19:47

0:23:50

8

0:14:34

0:17:33

6

0:00:00

11

Timothy Bucher

FSCT

316

38

11

DNS

13

0:15:57

0:17:39

5

90.4

DNS

13

0:16:02

0:17:44

7

0:00:00

12

Joe Sprigg

FSCT

125

42

12

0:14:38

0:16:11

5

0:20:04

0:22:12

11

90.4

DNS

13

DNS

13

0:00:00

Number Of Racers

7

11

10

9

INSTRUCTIONS

Enter data in yellow fields only

Boat Type must be entered using the list box.  If the boat is not in the list, it must be added to the portsmouth table

The Wind Speed range for each race must also be selected from the list box

A skipper for each boat must be listed.  Corrected times will not calculate if skipper is blank.

Sail number is optional.  Use the Boat/Skipper cross reference to verify information.

Enter race date.  Use date of first race for two-day regattas

Enter total lapse time using the format shown at the top of the column.  If no time is available, enter appropriate code i.e. DNF

Acceptable codes are limited to DNS, DNF,OCS,DNC and DSQ

The corrected time is calculated using the Portsmouth factor from the table using Boat Type and Wind Speed.

The Portsmouth factor can be checked by expanding the column to the left of the Lapse Time

The IF statements included in the formulas are used primarily to eliminate the Errors when no data is available.

The IF Statements check if the Skipper is present and a Wind Speed selected to determine if the calculations should be executed.