Template Speaker Tracker

	B	C	D	E	F	G	H	I	J	L	N
1	This is filled with random data, click "Make a copy" to get an editable version of your own. Version 1.5 - Added rankings, tournament exclusions, hotfixes
2
3
4
5	Quick Stats:
6
7	Position	OG (DPM)		Motion Type	Feminism		Partner	Jill Bloggs
8	Av Speaks	83.57		Av Speaks	85.60		Av Speaks	83.22
9	Av Points	2.29		Av Points	3.00		Av Points	2.56
10										You can customise these two columns to change the options in the drop down box
11	Input all data into this table, using the drop down boxes. Add motion types/partner options in the columns over there ->
12
13	Date	Tournament	Partner	Room Points	Motion Type	Position	Speaker Points	Result	Main Feedback	Partner Options	Motion Options
14	5/12/17	Mars WUDC	John Smith	Round 1	Tech	CO (OW)	77	2		John Smith	IR
15	5/12/17	Mars WUDC	John Smith	0	Econ	OO (DLO)	84	3		Jill Bloggs	Econ
16	5/12/17	Mars WUDC	John Smith	1	Law/Crime	OG (DPM)	84	2		Joe Bloggs	ID Pol
17	5/12/17	Mars WUDC	John Smith	1	Art	CO (OW)	85	3			Politics
18	5/12/17	Mars WUDC	John Smith	2	Politics	CG (GW)	82	0			Science/Medicine
19	25/12/17	Mars WUDC	John Smith	0	Science/Medicine	OG (DPM)	82	2			Philosophy/Religion
20	25/12/17	Mars WUDC	John Smith	0	IR	OO (DLO)	84	3			Law/Crime
21	25/12/17	Mars WUDC	John Smith	1	Philosophy/Religion	CG (GW)	81	3			Tech
22	25/12/17	Mars WUDC	John Smith	2	Feminism	OO (DLO)	87	3			Education
23	10/11/17	Jupiter IV	John Smith	Round 1	Econ	CG (GW)	85	3			Art
24	10/11/17	Jupiter IV	John Smith	1	Tech	CO (OW)	84	3			Feminism
25	11/11/17	Jupiter IV	John Smith	2	Politics	OO (DLO)	84	3			Employment
26	11/11/17	Jupiter IV	John Smith	3	Econ	OG (DPM)	82	1			Sport
27	11/11/17	Jupiter IV	John Smith	2	ID Pol	CO (OW)	80	3			Conflict
28	27/11/17	Saturn Open	John Smith	Round 1	Law/Crime	CG (GW)	81	3			Housing
29	27/11/17	Saturn Open	John Smith	1	Politics	OO (DLO)	80	3			Media
30	27/11/17	Saturn Open	John Smith	2	IR	CO (OW)	84	3			Europe
31	28/11/17	Saturn Open	John Smith	3	Feminism	OG (DPM)	88	3
32	28/11/17	Saturn Open	John Smith	4	IR	CO (OW)	79	3
33	29/10/16	Venus EUDC	John Smith	Round 1	Feminism	OO (DLO)	83	3
34	29/10/16	Venus EUDC	John Smith	1	Law/Crime	CO (OW)	79	3
35	29/10/16	Venus EUDC	John Smith	2	IR	CG (GW)	80	1
36	29/10/16	Venus EUDC	John Smith	1	Econ	CO (OW)	84	3
37	30/10/16	Venus EUDC	John Smith	2	Politics	OG (DPM)	84	3
38	14/8/17	Mercury IV	Jill Bloggs	Round 1	Law/Crime	OG (DPM)	82	3
39	14/8/17	Mercury IV	Jill Bloggs	1	Econ	CO (OW)	80	3
40	14/8/17	Mercury IV	Jill Bloggs	2	Tech	OO (DLO)	82	3
41	15/8/17	Mercury IV	Jill Bloggs	3	Feminism	CG (GW)	85	3
42	15/8/17	Mercury IV	Jill Bloggs	4	IR	OO (DLO)	88	3
43	15/8/17	Mercury IV	Jill Bloggs	5	Education	OG (DPM)	83	2
44	16/8/17	Mercury IV	Jill Bloggs	5	Science/Medicine	CG (GW)	81	0
45	16/8/17	Mercury IV	Jill Bloggs	3	ID Pol	CO (OW)	82	3
46	16/8/17	Mercury IV	Jill Bloggs	4	Tech	CO (OW)	86	3
47	12/8/17	Uranus Open	Joe Bloggs	Round 1	ID Pol	CO (OW)	85	3
48	12/8/17	Uranus Open	Joe Bloggs	1	Housing	CG (GW)	88	3
49	12/8/17	Uranus Open	Joe Bloggs	2	Philosophy/Religion	CO (OW)	86	3
50	12/8/17	Uranus Open	Joe Bloggs	3	IR	OO (DLO)	84	0
51	13/8/17	Uranus Open	Joe Bloggs	1	Feminism	CO (OW)	85	3
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