Race Planner.xls

	A	B	C	D	E	F	G	H	I	J
1
2	Provided by Ray Griffiths - Remember things rarely run smoothly
3	Team racing event time calculator
4	(Enter variable in cells with blue background)
5
6					Entries	18
7
8	Variables:
9									Races	Hours
10	Flights of boats	2					Swiss League	can be stopped at any time
11
12	Starting sequence	4		(minutes)			Full round robin:		153	19.13
13							Finals			1.50
14	Race cycle (minutes)	15
15							Total time			20.63
16	will provide:
17							Two leagues then gold and silver
18	Races per hour	8					League 1		36	4.50
19							League 2		36	4.50
20	Time on water	22%		(round robin only)			Gold		36	4.50
21							Silver		36	4.50
22							Finals			1.50
23
24							Total time			19.50
25	Finals format
26	(Assume quarters and semis are each sailed together)						Three leagues then gold, silver and bronze
27				Hours			League 1		15	1.88
28							League 2		15	1.88
29	Quarter-finals	best of	0	0.00			League 3		15	1.88
30							Gold		15	1.88
31	Semi-finals	best of	3	0.75			Silver		15	1.88
32							Bronze		15	1.88
33	Finals	best of	3	0.75			Finals (3 Gold 1Bronze ?)			1.50
34
35	Total time			1.50			Total time			12.75
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100