TEST - Google Sheets

	A	B	C	D	E	F	G	H
1	Name	Round 1	Round 2	Round 3	Round 4	Round 5	Round 6	Total

2	Coventry Uni (1)	(1 v 10)	(8v.1)	(13v.1)	(1 v 3)	(5 v 1)	(1 v 9)
3	Sehajdeep	0	1	1	1	1	1	5
4	Baamadam	0	0	1	1	1	0	3
5	Kushit	0	1	0	0	0	0	1
6	Tyna	0	0	0	0	1	0	1
7	Kynoch Chess Club (2)	(2 v 8)	(2v.13)	(10v.2)	(7 v 2)	(2 v 12)	(2 v 14)
8	Oliver	1	1	0	0.5	0	1	3.5
9	Waleed	1	1	0	0	0	1	3
10	Stefan	1	1	0	1	0	1	4
11	Josh	1	1	0	0	0	1	3
12	Lichfield & Burton Chess Club (3)	(3 v 6)	(3v.9)	(16v.3)	(1 v 3)	(11 v 3)	(13 v 3)
13	Ben Nevett-Farman	0	1	1	0	1	1	4
14	David Pickering	0	0	1	0	1	0.5	2.5
15	Ben Crowley	0	0	1	1	0	1	3
16	Graeme Dayton	0	0	0	1	1	1	3
17	May The Fork Be With You (4)	(9 v 4)	(4v.5)	(15v.4)	(6 v 4)	(8 v 4)	(10 v 4)
18	Jonathan Fowler	1	1	0	1	1	0	4
19	Rhys Edwards	1	1	0	0	1	1	4
20	Deema Khunda	1	0	0	0	1	0	2
21	Phil Dean	0	1	0	0	0	0.5	1.5
22	Oxford Brookes (5)	(14 v 5)	(4v.5)	(5v.11)	(9 v 5)		(16 v 5)
23	Kwan Ho Tam	1	0	1	0.5	0	1	3.5
24	Nathan Bulabula	1	0	1	1	0	0.5	3.5
25	Marc Leong	0.5	1	0	0	1	0	2.5
26	Default	0.5 (d)	0(d)	0(d)	0 (d)	0(d)	0(d)	0
27	Reading University 'A' (6)	(3 v 6)	(6v.15)	(6v.9)	(6 v 4)	(6 v 10)	(6 v 7)
28	Maxim Dunn	1	0	1	0	0	1	3
29	Forbes Welford-Ranson	1	0.5	0.5	1	0	1	4
30	Zach Salvini	1	0		1	0	1	3
31	Ethan Rowe		0	1	1	1	1	4
32	James Connors	1		1				2
33	Reading University 'B' (7)	(13 v 7)	(7v.14)	(7v.12)	(7 v 2)	(7 v 15)	(6 v 7)
34	Tom Huxtable	0	0	0.5	0.5	0	0	1
35	Omar Balushi	1	1	0	1	0	0	3
36	Adam Fennell	0	1	0.5	0	0	0	1.5
37	Daniel Miller	1	1	1	1	0	0	4
38	Reading University 'C' (8)	(2 v 8)	(8v.1)	(14v.8)	(12 v 8)	(8 v 4)	(8 v 11)
39	Tom Mantell	0	0	0	0	0	1	1
40	Kyri Weeks	0	1	1	0	0	1	3
41	Will Eggleton	0	0	1	1	0	1	3
42	Jignesh Natarajan	0	1	1	0	1	1	4
43	Solihull Chess Club (9)	(9 v 4)	(3v.9)	(15v.4)	(9 v 5)	(9 v 13)	(1 v 9)
44	Mike Warden	0	0	0	0.5	0	0	0.5
45	Mike Johnson	0	1	0.5	0	1	1	3.5
46	George Mitchell	0	1	0	1	0	1	3
47	Wojciech Slupski	1	1	0	1	1	1	5
48	Sons of Anarchy (Sharks) (10)	(1 v 10)	(10v.12)	(10v.2)	(10 v 15)	(6 v 10)	(10 v 4)
49	Ameet Ghasi IM	1	1	1	1	1	1	6
50	James Moreby	1	1	1	0.5	1	0	4.5
51	Ben Purton	1	1	1	0	1	1	5
52	Greg Cannon	1	0	1	0	0	0.5	2.5
53	Stafford Chess Club (11)	(15 v 11)	(11v.16)	(5v.11)	(14 v 11)	(11 v 3)	(8 v 11)
54	P. Evans	0	0	0	1	0	0	1
55	Steve Luff	0	0	0	1	0	0	1
56	Thomas Chapman	0	0	1	1	1	0	3
57	Jack Smith	0	0	1	1	0	0	2
58	Staffordshire Juniors (12)	(16 v 12)	(10v.12)	(7v.12)	(12 v 8)	(2 v 12)	(15 v 12)
59	Dylan Cooper	1	0	0.5	1	1	0	3.5
60	Joe C.L	1	0	1	1	1	0	4
61	Julian Kitchen	1	0	0.5	0	1	0	2.5
62	Travis Hackett	1	1	0	1	1	0	4
63	Stratford-Upon-Avon School 'A' (13)	(13 v 7)	(2v.13)	(13v.1)	(13 v 16)	(9 v 13)	(13 v 3)
64	Sam Cotterill	1	0	0	1	1	0	3
65	Elijah	0	0	0	0	0	0.5	0.5
66	Jack	1	0	1	1	1	0	4
67	Tom	0	0	1	1	0	0	2
68	Stratford-Upon-Avon School 'B' (14)	(14 v 5)	(7v.14)	(14v.8)	(14 v 11)	(14 v 16)	(2 v 14)
69	Nail	0	1	1	0	0	0	2
70	Flav	0	0	0	0	0	0	0
71	William	0.5	0	0	0	0	0	0.5
72	Default	0.5	0	0	0	0	0	0.5
73	Warwick University (15)	(15 v 11)	(6v.15)	(15v.4)	(10 v 15)	(7 v 15)	(15 v 12)
74	Sam Chow	1	1	1	0	1	1	5
75	Oscar Pollock	1	0.5	1	0.5	1	1	5
76	Mikey Watson	1	1	1	1	1	1	6
77	Daniel Ruiz	1	1	1	1	1	1	6
78	Watlington Wanderers (16)	(12 v 16)	(11v.16)	(16v.3)	(13 v 16)	(14 v 16)	(16 v 5)
79	B. Woolf	0	1	0	0	1	0	2
80	M. Lambert	0	1	0	1	1	0.5	3.5
81	D. Wills	0	1	0	0	1	1	3
82	M. Turton	0	1	1	0	1	1	4
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100