BSC RACE RESULTS    
PRO: Rick Scarborough                
RC1 Joe Sprigg              
RC2 Birch Bowdre              
RC3 Robin Vance              
RC4 Martin Caderas              
              RACE ONE   RACE TWO   RACE THREE   RACE FOUR   RACE FIVE
Date: 5/15/2010     Wind Speed=>   4.1 to 12.0   4.1 to 12.0   4.1 to 12.0   Unknown   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 Jim Sisson FSCT 2605 3 1   0:21:55 0:24:15 1   0:18:10 0:20:06 1   0:30:29 0:33:43 1                
2 Michael Papp SN 29961 11 2   0:26:00 0:28:06 4   0:20:35 0:22:15 3   0:31:35 0:34:09 4                
3 Robert Blythe J-22   12 3   0:22:28 0:27:10 3   0:19:39 0:23:46 7   0:27:57 0:33:48 2                
4 Mike Neilson SN   13 4   0:27:57 0:30:13 5   0:21:15 0:22:58 5   0:31:29 0:34:02 3                
5 Jack Rogers SNT23   14 5   0:21:29 0:25:27 2   0:19:32 0:23:09 6   0:30:18 0:35:54 6                
6 Vincent Priola J-22   15 6   0:27:06 0:32:46 8   0:17:25 0:21:04 2   0:29:03 0:35:08 5                
7 Christopher Bucher FSCT   21 7   0:27:56 0:30:54 6   0:20:42 0:22:54 4   0:42:50 0:47:23 11                
8 Bo Smith J-22   23 8   0:26:20 0:31:51 7   0:21:53 0:26:28 9   0:32:35 0:39:24 7                
9 Tim Pack FSCT   27 9   0:31:50 0:35:13 9   0:24:11 0:26:45 10   0:38:03 0:42:05 8                
10 Leslie Anderson LASE   28 10   0:33:21 0:36:08 10   0:24:20 0:26:22 8   0:42:26 0:45:58 10                
11 Laura Graham SN   31 11   0:34:40 0:37:29 11   0:26:01 0:28:08 11   0:39:05 0:42:15 9                
                                                   
                                                   
                                                   
                                                   
                                                   
                                                   
                                                   
                                                   
                                                   
                                                   
                                                   
                                                   
                                                   
                                                   
                                                   
                                                   
                                                   
                                                   
                                                   
  Number Of Racers                          
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.