Sarasota Bay Yachting Association BOTY 2006 - 2007						COUNT THE BEST 4 OF THESE 8
Division Name Goes Here						Labor Day		BYC Kick-Off		Crow's Nest		SYC Invitational		Cherry Pie		Shark's Tooth		Sarasota Bay Cup		KW Rendezvous
	Boat Name	Best 4 TOTAL	Regattas	Owner / Skipper	Club	BOTY PTS.	POSITION	BOTY PTS.	POSITION	BOTY PTS.	POSITION	BOTY PTS.	POSITION	BOTY PTS.	POSITION	BOTY PTS.	POSITION	BOTY PTS.	POSITION	BOTY PTS.	POSITION			BOTY Points used to add the 4 highest (best) finishes
							5		3		4		5											1	2	3	4	5	6	7	8
1	Boat Three	5.733	4			1.400	3	1.333	2	1.500	2	1.500	2.5											1.400	1.333	1.500	1.500	0.000	0.000	0.000	0.000
2	Boat One	5.467	4			1.800	1	1.667	1	1.000	4	1.000	5											1.800	1.667	1.000	1.000	0.000	0.000	0.000	0.000
3	Boat Four	5.450	4			1.200	4	1.000	3	1.750	1	1.500	2.5											1.200	1.000	1.750	1.500	0.000	0.000	0.000	0.000
4	Boat Two	4.050	3			1.600	2			1.250	3	1.200	4											1.600	0.000	1.250	1.200	0.000	0.000	0.000	0.000
5	Boat Five	2.800	2			1.000	5					1.800	1											1.000	0.000	0.000	1.800	0.000	0.000	0.000	0.000
																								0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000
	Excel Spreadsheet Used for BOTY Scoring
	The Excel Workbook contains multiple spreadsheets – a separate one for each Division – Spinnaker, Non-Spinnaker, True Cruising, Multi-Hull and Race Cruiser. The format of the spreadsheets is the same for all of them (see sample above) and is as follows:
	1)      On the left, there are three columns to enter the Boat Name, Owner/Skipper, and the Club.
	2)      A column “Best 4 Total” contains a calculated value that is the sum of the boat’s best four finishes (i.e., the four highest values in the “BOTY Points” of all the regattas.)
	3)      The column ”Regattas” is a calculated value showing the number of regattas in which the boat competed (“participated”).  This is used solely to determine the boats that qualify for the series; i.e., participate in 50% (rounded up) of the regattas raced.
	4)      Each spreadsheet also contains two columns for each regatta of the season series.  One column (Position) is for entering the finishing position for each boat in the regatta.  The second column contains the BOTY Points, and is a calculated value using the formula explained above.  It is a value that is greater than or equal to 1.000 and less than 2.000.
	NOTE: The “Best 4 Total” never uses more than 4 scores, even if “Races” is more than 4.
	Entering Regatta Information into the Scoring Spreadsheets
	After entering the Boat Name, and if available, the Skipper/Owner and Club, the only other information to be entered is in the “Position” field.
	1)      For each regatta, in the Position column, enter the total number of boats in the division in the cell immediately under the “Position” heading.  In the sample above, these values are in the green cells and are 5, 3, 4, and 5.
	2)      Next, for each boat in the regatta, enter its finishing position in the Position column.
	3)      If two (or more) boats are tied for the final regatta standings (for example, only one race and both boats have the same corrected time), they share the points for the tied positions.  In the sample above, see the two pink cells.  They are tied for second/third place. Adding 2 + 3 and dividing by 2, each boat gets 2.5 for its position.  The two boats they beat are in positions 4 and 5.
	Notes:
	·         When all boats finish the race, the last place boat always gets 1.000 for BOTY Points.  Since they didn’t beat any boats, they just get their participation point.
	·         Since all participating boats are to get a full participation point, then any boat that is DNF, DNS, DNC, or is disqualified, should have a value equal to the number of boats in the division entered as its Position.  This gives the same result (1.000) as if they were in last place in a division where all boats finished.