SummerSeries_2013 - Google Drive


1	TVOC Summer Series 2013					Wed	Tue	Wed	Wed	Tue	Wed	Wed	Wed	Tue	Tue	Wed	Wed	Tue
2	Results	New: organisers score 50 points for their own race				Wittenham Clumps	Brill	Shotover	Whiteleaf	Hodgemoor	Cuttes- lowe Park	Park Wood Naphill	Bernwood	Langley Park	Youlbury	Chesham Bois	Haw Wood	Wendover		for sorting
3	A course			races	best 4	1-May	7-May	15-May	22-May	28-May	5-Jun	12-Jun	19-Jun	25-Jun	2-Jul	10-Jul	17-Jul	23-Jul	course	total

4	Jamie Parkinson	M21	OUOC	11	200	43	41	46	43		50	17	50	50	46	50	50		A	200
5	Alan Cherry	M21	OUOC	5	196	50	46	50	50		46								A	196
6	Ben Stevens	M21	OUOC	13	196	46	43	43	46	46	43	50	46	46	50	46	46	50	A	196
7	Tim Beale	M21	OUOC	5	175					43		43				43	41	46	A	175
8	Jon Marsden	M35	JOK	10	173	38		41		41	40	46	43	43	38	35	40		A	173
9	Mark Collis	M35	TVOC	9	166		38	30	36	38	50		40	38		33	32		A	166
10	Robin Bishop	M45	TVOC	12	166	34	38	35	35	40	37	38		50	34	36	31	0	A	166
11	Norbert Linke	M21	OUOC	8	162						38	37	38	41	39	39	37	43	A	162
12	Steve Long	M50	TVOC	5	159					37	0			40	41			41	A	159
13	Dave Kingham	M55	TVOC	4	156			36					41				39	40	A	156
14	Carl Bootland	M21	OUOC	7	155	36	39	26	39	34	41		36						A	155
15	Peter Riches	M60	TVOC	12	155	28	35		50	31	26	36	34	34	31	29	30	33	A	155
16	Mikhail Gryanevich	M55	TVOC	5	155				38				39	39			33	39	A	155
17	Piotr Czaban	M21	OUOC	9	154	37		37	41	33		39	37	33	35		36		A	154
18	Ian Buxton	M45	TVOC	7	150	33				39	36				36	37	34	38	A	150
19	Jim Prowting	M65	TVOC	6	149		39		37	36						31	37	35	A	149
20	Martin Ricketts	M60	TVOC	4	146	30										32	50	34	A	146
21	Jim Wilson	M55	TVOC	6	145	29	34	50			28		17		32				A	145
22	Anne Edwards	W21	TVOC	4	142	40		38			39				25				A	142
23	Ruth Holmes	W21	SN	3	131					50		41				40			A	131
24	Scott Collier	M21	KERNO	3	124	41		40							43				A	124
25	Heather Walton	W50	TVOC	5	123						25		33	35	27		28		A	123
26	Alex Vai	M21	OUOC	4	120		33	25			34				28				A	120
27	Bill Child	M50	TVOC	4	119	31		27			32				29				A	119
28	Ian Webb	M21	OUOC	3	119					35						41	43		A	119
29	Josh Milner	M20	OUOC	4	119								35			34	13	37	A	119
30	Roger Thetford	M50	TVOC	3	118	39	40	39											A	118
31	Matthew Hill	M40	TVOC	3	110	35	40				35								A	110
32	Marcin Krzysztofik	M21	TVOC	4	100			29			12				30		29		A	100
33	James Wilkinson	M21	OUOC	3	99	32	37				30								A	99
34	Blanka Collis	W21	TVOC	2	73						33				40				A	73
35	Carol Edwards	W50	TVOC	2	71						31	40							A	71
36	John Griffiths	M45	TVOC	2	62					50	12								A	62
37	Marie-Anne Fischer	W50	TVOC	2	54						27						27		A	54
38	Peter Hodkinson	M21	OUOC	1	50		50												A	50
39	Richard Sharp	M45	TVOC	1	50	50													A	50
40	Neville Baker	M60	TVOC	2	50						12						38		A	50
41	Matthew Jones	M21	SBOC	1	39											39			A	39
42	James Cunnane	M50	TVOC	1	37									37					A	37
43	Maria Dragowska	W18	OK! Sport	1	37										37				A	37
44	Suzy Robertson	W21	TVOC	1	36		36												A	36
45	Ian Bell	M45	SN	1	36									36					A	36
46	Volker Naulin	M45	IND	1	36													36	A	36
47	Alistair Graves	M21	OUOC	1	33			33											A	33
48	Steve Wilson	M45	Clyde	1	33										33				A	33
49	Luke Woodward		TVOC	1	32			32											A	32
50	Brad Sutherland		TVOC	1	32			32											A	32
51	Sue Jones	W45	TVOC	1	32					32									A	32
52	Vladimir Kuznetsov	M55	TVOC	1	31			31											A	31
53	Oliver Gondring	M21	OUOC	1	30											30			A	30
54	Ant Walker	M45	JOK	1	29						29								A	29
55	Mark Thompson	M55	TVOC	1	27	27													A	27
56	Stewart Scott & Simon Leech	M50	WHH	1	26										26				A	26
57	David Hirst	M21	IND	1	17							17							A	17
58	Gary Mills	M55	TVOC	1	17			17											A	17
59	Vlad Nebolsin	M35	TVOC	1	15					15									A	15
60	Marcus McEwan			1	13			13											A	13
61	Sarah Parrish		TVOC	1	13			13											A	13
62	Jesada Temaismithi	M21	OUOC	1	12						12								A	12
63	B course																		B	300
64	Mark Thompson	M55	TVOC	9	200		50	43	50	50		50	50	46		50		43	B	200
65	Jon Wheatcroft	M60	TVOC	6	196			46	50		50		21		46		50		B	196
66	Yvonne Hodson	W65	TVOC	12	184	38	46	18	43	46	46	43	43	41	43	46	38		B	184
67	Neil Fraser	M50	TVOC	4	180	45		39					46		50				B	180
68	Greg Birdseye	M65	TVOC	4	169								50		39	41		39	B	169
69	John Thompson	M75	TVOC	7	166	18	43	37		22					41	43	39		B	166
70	Roger Baker	M80	TVOC	6	164	41	41	41			41				40	20			B	164
71	Helen Miller	W21	IND	4	159										35	40	46	38	B	159
72	Madeleine Vickers	W21	OUOC	6	155	39	20								34	39	40	37	B	155
73	Vlad Nebolsin	M35	TVOC	5	141				40		43	20			38		18		B	141
74	Carol Edwards	W55	TVOC	3	120	50		50	20										B	120
75	John Spence	M80	TVOC	3	104	18	50	36											B	104
76	John Last	M75	TVOC	3	103	43	20				40								B	103
77	Steve Stone	M60	TVOC	2	96				46					50					B	96
78	Alison Smith	W45	TVOC	2	93									43	50				B	93
79	Heather Walton	W50	TVOC	2	92							46						46	B	92
80	Jim Wilson	M55	TVOC	2	84				41								43		B	84
81	Sue Jones	W45	TVOC	2	82												41	41	B	82
82	Dexter Drown	M14	TVOC	2	78	40		38											B	78
83	Linjia Chen	W20	OUOC	2	61					22	39								B	61
84	Brian Watkins	M80	TVOC	2	55	18											37		B	55
85	Andrew Southwood	M45	BKO	1	50													50	B	50
86	Phil Edmonds			1	40			40											B	40
87	Brian Palmer	M65	TVOC	1	40													40	B	40
88	Megan Haggerty	W35	IND	1	38						38								B	38
89	Peter Richardson		HRR	1	38			38											B	38
90	Vivienne Shaw			1	37	37													B	37
91	John Farren	M70	TVOC	1	37										37				B	37
92	Emma Collis	W1	TVOC	1	36										36				B	36
93	Geoff Geere	M85	TVOC	1	33										33				B	33
94	Paul Kilpin	M60	TVOC	1	21								21						B	21
95	Ali Kempson	W45	TVOC	1	18			18											B	18
96	Margaret Thompson	W75	TVOC	1	18			18											B	18
97	C course																		C	300
98	Andrew Chalmers	M75	TVOC	2	100				50							50			C	100
99	Linjia Chen	W20	OUOC	2	93				43				50						C	93
100	Seth Edmonds			1	50			50											C	50
101	Carys Sharp	W8	TVOC	1	50	50													C	50
102	Johan Griffiths	M14	TVOC	1	50					50									C	50
103	Peter Cobb	M45	IND	1	50							50							C	50
104	Chris Radband	M21	IND	1	50											50			C	50
105	Vlad Nebolsin	M35	TVOC	1	50													50	C	50
106	Liz Chalmers	W75	TVOC	1	46				46										C	46
107	Serena Griffiths	W12	TVOC	1	46					46									C	46
108	Michelle Janowiecki	W20	OUOC	1	41				41										C	41
109	(to keep totals correct, insert any new rows above here)																		D
110	Count / Total		103	328		31	22	37	21	22	33	16	20	17	33	25	29	22	E
111	Aaaa NewRunner			0	#NUM!														Z	#NUM!


1		Instructions to organisers
2
3	1	Insert points from your event in the relevant column.	Do not type the total points into column E, because this would overwrite the spreadsheet formula that calculates the totals.
4	2	If you have a completely new runner, use one of the Aaaa NewRunner rows at the bottom of the spreadsheet. Change name, insert age-class and club, and amend the course (column T) from Z to A or B or C.	Note that runners will be sorted into their courses later on; there is no need to to that manually on entering data!
5	3	If there are no more Aaaa NewRunner rows, copy and paste the last row at the bottom of the spreadsheet. (Use the icons on the 'Edit' tab, or else CTRL-C and CTRL-V.) This will ensure that the points formulae work properly for the new runner. Change the name, age-class and club, and amend the course to A or B or C.
6	4	Hover over the column heading for column T. You should see a small downward-pointing triangle. Click it, then from the resulting menu choose 'Sort Z -> A'. Runners will be sorted into descending order of points, but the courses will be jumbled together.	You can also do this by clicking on any cell in column T, then using 'Sort sheet by Column T, Z -> A' in the Tools menu
7	5	Repeat for column S, but now choosing > Sort A -> Z'. Runners are now in the desired order.
8	6	For all runners with two runs or more runs, check that their points total includes the points you've just input. (A previous user may have forgotten to copy the formulas or just worked out the total manually and typed it in.) If the total doesn't update, see 'Trouble-shooting' below.
9	7	The spreadsheet should auto-save.
10
11
12		Trouble-shooting
13		some runners with points don't appear or come below the 'Count / Total' line or are not sorted into the correct order	1. Ensure that you have set the course properly in column S 2. Ensure that the 'points total for sorting' in column T is set equal to column E (i.e. T4 should contain '=E4', etc)
14		If the published version of the sheet is different to the one that you're editing	Automatic publishing has probably been turned off. Click the 'Share' button tab at the top right of the spreadsheet, then select 'Publish as a web page' button, and make sure that 'Automatically republish when changes are made' is ticked.
15		Points totals don't update	Double-click on the cell in column E to check that it contains a formula to calculate the total of the best 4 results, rather than a typed number. If it doesn't, copy the formula from another row. (CTRL-C to copy, CTRL-V to paste). Or copy the information into an 'Aaaa NewRunner' template row.
16		If the published sheet, as linked from the Summer Series home page, is cut off in the middle of the current runners (and before the 'Count / total' row)	Extend the definition of the embedded name 'publishedRange' so that it goes down as far as the 'Count / total' row. (Formulas > Range names > Manage > select publishedRange > click on definition, e.g. A1:R110 > edit the 110 to include as many rows as are required > Save > Done)
17


1	If 2 people finish in a dead heat, give		scoring
2	them each the average of the points	1	50
3	for the two positions.	2	46
4		3	43
5	If someone does not complete their	4	41	sum is 45 from here down
6	course, give them half points (unless	5	40
7	they can be counted as completing	6	39
8	one of the other courses, in which	7	38
9	case they may score points on that.)	8	37
10		9	36
11		10	35
12		11	34
13		12	33
14		13	32
15		14	31
16		15	30
17		16	29
18		17	28
19		18	27
20		19	26
21		20	25
22		21	24
23		22	23
24		23	22
25		24	21
26		25	20
27		26	19
28		27	18
29		28	17
30		29	16
31		30	15
32		31	14
33		32	13
34		33	12
35		34	11