TC - TGM1 Leaderboard - Google Sheets

	A	B	C	D	E	F	G	H	I	K	L
1	To update: 1) Update cells as required, 2) Sort Time A-Z, 3) Sort Level Z-> A, 4) Sort Grade Points Z->A, 5) Paste column G into thread with rich text editor off, 6) Manually re-insert line for Gm as required									Grade Lookup Table
2	Name	Grade	Grade Points	Level	Time	Date	Video Link	Leaderboard text	Rank	Grade	Grade Points
3	K	Gm	19	999	09:11:41	3/1/2014	https://www.youtube.com/watch?v=Gxl7fN0Xf4c	1 \| K \| Gm \| 999 \| 09:11:41 \| [URL='https://www.youtube.com/watch?v=Gxl7fN0Xf4c']video[/URL]	1	9	1
4	KevinDDR	Gm	19	999	09:19:35	7/4/2016	https://www.youtube.com/watch?v=enkE5xrsJaE	2 \| KevinDDR \| Gm \| 999 \| 09:19:35 \| [URL='https://www.youtube.com/watch?v=enkE5xrsJaE']video[/URL]	2	8	2
5	MaryHadALittle	Gm	19	999	09:25:06	18/03/2016	https://www.youtube.com/watch?v=_pTou3-5lTI	3 \| MaryHadALittle \| Gm \| 999 \| 09:25:06 \| [URL='https://www.youtube.com/watch?v=_pTou3-5lTI']video[/URL]	3	7	3
6	cyberguile	Gm	19	999	09:28:11	22/03/2015		4 \| cyberguile \| Gm \| 999 \| 09:28:11 \|	4	6	4
7	Qlex	Gm	19	999	09:35:30	17/01/2014		5 \| Qlex \| Gm \| 999 \| 09:35:30 \|	5	5	5
8	aperturegrillz	Gm	19	999	09:36:13	18/7/2017	https://youtu.be/-TytutqXFa8	6 \| aperturegrillz \| Gm \| 999 \| 09:36:13 \| [URL='https://youtu.be/-TytutqXFa8']video[/URL]	6	4	6
9	Amnesia	Gm	19	999	09:40:21	29/02/2012	http://www.youtube.com/watch?v=-f3ZAAmtjBs&feature=youtu.be	7 \| Amnesia \| Gm \| 999 \| 09:40:21 \| [URL='http://www.youtube.com/watch?v=-f3ZAAmtjBs&feature=youtu.be']video[/URL]	7	3	7
10	Jil	Gm	19	999	09:41:93	25/03/2016		8 \| Jil \| Gm \| 999 \| 09:41:93 \|	8	2	8
11	Edo	Gm	19	999	09:43:25	22/12/2011		9 \| Edo \| Gm \| 999 \| 09:43:25 \|	9	1	9
12	Kitaru	Gm	19	999	09:46:81	17/09/2014		10 \| Kitaru \| Gm \| 999 \| 09:46:81 \|	10	S1	10
13	rednefed	Gm	19	999	09:47:45	6/6/2014		11 \| rednefed \| Gm \| 999 \| 09:47:45 \|	11	S2	11
14	ei	Gm	19	999	09:48:10	9/4/2012	https://www.twitch.tv/videos/279308713	12 \| ei \| Gm \| 999 \| 09:48:10 \| [URL='https://www.twitch.tv/videos/279308713']video[/URL]	12	S3	12
15	eskatre	Gm	19	999	09:54:80		https://www.youtube.com/watch?v=xnhnXJfrEKQ	13 \| eskatre \| Gm \| 999 \| 09:54:80 \| [URL='https://www.youtube.com/watch?v=xnhnXJfrEKQ']video[/URL]	13	S4	13
16	DeHackEd	Gm	19	999	09:57:15	17/05/2014	http://www.youtube.com/watch?v=rPk_g7rlnek	14 \| DeHackEd \| Gm \| 999 \| 09:57:15 \| [URL='http://www.youtube.com/watch?v=rPk_g7rlnek']video[/URL]	14	S5	14
17	colour_thief	Gm	19	999	09:57:50	20/05/2009		15 \| colour_thief \| Gm \| 999 \| 09:57:50 \|	15	S6	15
18	FeV	Gm	19	999	09:57:58	13/03/2016	http://www.twitch.tv/videos/126832298	16 \| FeV \| Gm \| 999 \| 09:57:58 \| [URL='http://www.twitch.tv/videos/126832298']video[/URL]	16	S7	16
19	cleure	Gm	19	999	10:09:36	25/05/2015	https://www.youtube.com/watch?v=0VIHPIaNldQ	17 \| cleure \| Gm \| 999 \| 10:09:36 \| [URL='https://www.youtube.com/watch?v=0VIHPIaNldQ']video[/URL]	17	S8	17
20	Kai	Gm	19	999	10:16:56			18 \| Kai \| Gm \| 999 \| 10:16:56 \|	18	S9	18
21	mfm005	Gm	19	999	10:17:45	18/05/2014		19 \| mfm005 \| Gm \| 999 \| 10:17:45 \|	19	Gm	19
22	Oliver	Gm	19	999	10:20:03	02/07/2018		20 \| Oliver \| Gm \| 999 \| 10:20:03 \|	20
23	PiePusher11	Gm	19	999	10:26:78			21 \| PiePusher11 \| Gm \| 999 \| 10:26:78 \|	21
24	JBroms	Gm	19	999	10:27:76	25/12/16	https://www.youtube.com/watch?v=2t-9HP0DR1g	22 \| JBroms \| Gm \| 999 \| 10:27:76 \| [URL='https://www.youtube.com/watch?v=2t-9HP0DR1g']video[/URL]	22
25	EnchantressOfNumbers	Gm	19	999	10:29:08	29/02/2016	https://youtu.be/lDHPOhscMuY	23 \| EnchantressOfNumbers \| Gm \| 999 \| 10:29:08 \| [URL='https://youtu.be/lDHPOhscMuY']video[/URL]	23
26	GyRo	Gm	19	999	10:31:85	25/01/2016	https://youtu.be/kpIXtFKPI4o	24 \| GyRo \| Gm \| 999 \| 10:31:85 \| [URL='https://youtu.be/kpIXtFKPI4o']video[/URL]	24
27	Ai	Gm	19	999	10:34:68	7/5/2011		25 \| Ai \| Gm \| 999 \| 10:34:68 \|	25
28	kukrapoc_bazza	Gm	19	999	10:38:15	30/03/2008		26 \| kukrapoc_bazza \| Gm \| 999 \| 10:38:15 \|	26
29	COL	Gm	19	999	10:42:10	5/7/2013		27 \| COL \| Gm \| 999 \| 10:42:10 \|	27
30	mycophobia	Gm	19	999	10:42:50	4/11/2009	https://www.youtube.com/watch?v=eHAynj7HjfI	28 \| mycophobia \| Gm \| 999 \| 10:42:50 \| [URL='https://www.youtube.com/watch?v=eHAynj7HjfI']video[/URL]	28
31	Anerag	Gm	19	999	10:44:05			29 \| Anerag \| Gm \| 999 \| 10:44:05 \|	29
32	zzymyn	Gm	19	999	10:46:56	28/12/2015		30 \| zzymyn \| Gm \| 999 \| 10:46:56 \|	30
33	Icefox	Gm	19	999	10:47:00	10/3/2016		31 \| Icefox \| Gm \| 999 \| 10:47:00 \|	31
34	PARTY MAN X	Gm	19	999	10:47:45	12/3/2016	https://youtu.be/_JV3FllOeV4	32 \| PARTY MAN X \| Gm \| 999 \| 10:47:45 \| [URL='https://youtu.be/_JV3FllOeV4']video[/URL]	32
35	d4nin3u	Gm	19	999	10:49:41			33 \| d4nin3u \| Gm \| 999 \| 10:49:41 \|	33
36	Key	Gm	19	999	10:53:63	25/02/2012		34 \| Key \| Gm \| 999 \| 10:53:63 \|	34
37	Jayce	Gm	19	999	10:53:90	1/12/2016		35 \| Jayce \| Gm \| 999 \| 10:53:90 \|	35
38	Rosti LFC	Gm	19	999	10:54:10	10/6/2011		36 \| Rosti LFC \| Gm \| 999 \| 10:54:10 \|	36
39	sjoecool1991	Gm	19	999	10:56:20	4/10/2010		37 \| sjoecool1991 \| Gm \| 999 \| 10:56:20 \|	37
40	mat	Gm	19	999	10:58:06	28/09/2007		38 \| mat \| Gm \| 999 \| 10:58:06 \|	38
41	DDRKirby(ISQ)	Gm	19	999	10:58:15	31/07/2011		39 \| DDRKirby(ISQ) \| Gm \| 999 \| 10:58:15 \|	39
42	an ass	Gm	19	999	10:59:36	14/03/2010		40 \| an ass \| Gm \| 999 \| 10:59:36 \|	40
43	clincher	Gm	19	999	10:59:96	3/4/2015		41 \| clincher \| Gm \| 999 \| 10:59:96 \|	41
44	SoliDeoGloriaAA	Gm	19	999	11:02:91	25/05/2011		42 \| SoliDeoGloriaAA \| Gm \| 999 \| 11:02:91 \|	42
45	Master Fushigi	Gm	19	999	11:04:68			43 \| Master Fushigi \| Gm \| 999 \| 11:04:68 \|	43
46	WakiMiko	Gm	19	999	11:05:46	17/03/2016		44 \| WakiMiko \| Gm \| 999 \| 11:05:46 \|	44
47	Samael	Gm	19	999	11:08:50	11/8/2015		45 \| Samael \| Gm \| 999 \| 11:08:50 \|	45
48	Shion	Gm	19	999	11:10:03			46 \| Shion \| Gm \| 999 \| 11:10:03 \|	46
49	FreakyByte	Gm	19	999	11:10:40	7/11/2015		47 \| FreakyByte \| Gm \| 999 \| 11:10:40 \|	47
50	Ex_Mosquito	Gm	19	999	11:18:36	10/4/2015		48 \| Ex_Mosquito \| Gm \| 999 \| 11:18:36 \|	48
51	LOst	Gm	19	999	11:25:61	22/03/2010		49 \| LOst \| Gm \| 999 \| 11:25:61 \|	49
52	Zircean	Gm	19	999	11:28:23	27/12/2010		50 \| Zircean \| Gm \| 999 \| 11:28:23 \|	50
53	DIGITAL	Gm	19	999	11:30:46			51 \| DIGITAL \| Gm \| 999 \| 11:30:46 \|	51
54	AnnaMaus	Gm	19	999	11:30:66	20/01/2016	https://www.youtube.com/watch?v=hgHCYfO6KGY	52 \| AnnaMaus \| Gm \| 999 \| 11:30:66 \| [URL='https://www.youtube.com/watch?v=hgHCYfO6KGY']video[/URL]	52
55	TheFellowJasper	Gm	19	999	11:32:08	30/10/2015		53 \| TheFellowJasper \| Gm \| 999 \| 11:32:08 \|	53
56	Free	Gm	19	999	11:34:45	14/04/2010		54 \| Free \| Gm \| 999 \| 11:34:45 \|	54
57	Baxter	Gm	19	999	11:35:65	5/5/2008		55 \| Baxter \| Gm \| 999 \| 11:35:65 \|	55
58	Frusxfaranto	Gm	19	999	11:36:11	27/03/2016		56 \| Frusxfaranto \| Gm \| 999 \| 11:36:11 \|	56
59	iKantu	Gm	19	999	11:36:23			57 \| iKantu \| Gm \| 999 \| 11:36:23 \|	57
60	xyrnq	Gm	19	999	11:36:45	26/09/2015		58 \| xyrnq \| Gm \| 999 \| 11:36:45 \|	58
61	Muf	Gm	19	999	11:41:23	13/06/2010		59 \| Muf \| Gm \| 999 \| 11:41:23 \|	59
62	nicofromtokyo	Gm	19	999	11:42:75	1/8/2014		60 \| nicofromtokyo \| Gm \| 999 \| 11:42:75 \|	60
63	Stqrm	Gm	19	999	11:45:80			61 \| Stqrm \| Gm \| 999 \| 11:45:80 \|	61
64	Supernaze7	Gm	19	999	11:46:71	7/4/2014		62 \| Supernaze7 \| Gm \| 999 \| 11:46:71 \|	62
65	CrazedRevenG	Gm	19	999	11:46:81	28/10/2010		63 \| CrazedRevenG \| Gm \| 999 \| 11:46:81 \|	63
66	goofer	Gm	19	999	11:46:81	17/09/2014		64 \| goofer \| Gm \| 999 \| 11:46:81 \|	64
67	awake	Gm	19	999	11:47:33	6/10/2010		65 \| awake \| Gm \| 999 \| 11:47:33 \|	65
68	nightmareci	Gm	19	999	11:47:35	16/05/2009		66 \| nightmareci \| Gm \| 999 \| 11:47:35 \|	66
69	etherstorm	Gm	19	999	11:50:16			67 \| etherstorm \| Gm \| 999 \| 11:50:16 \|	67
70	Goplat	Gm	19	999	11:50:28	10/4/2010		68 \| Goplat \| Gm \| 999 \| 11:50:28 \|	68
71	girdot	Gm	19	999	11:50:51	6/12/2015		69 \| girdot \| Gm \| 999 \| 11:50:51 \|	69
72	tet2brik	Gm	19	999	11:50:76	3/9/2013		70 \| tet2brik \| Gm \| 999 \| 11:50:76 \|	70
73	deepdorp	Gm	19	999	11:56:10	15/05/2012		71 \| deepdorp \| Gm \| 999 \| 11:56:10 \|	71
74	Redlof_b	Gm	19	999	11:57:70	24/11/2015		72 \| Redlof_b \| Gm \| 999 \| 11:57:70 \|	72
75	tada	Gm	19	999	11:58:15	23/05/2009		73 \| tada \| Gm \| 999 \| 11:58:15 \|	73
76	m.kevin	Gm	19	999	11:58:91			74 \| m.kevin \| Gm \| 999 \| 11:58:91 \|	74
77	Vesly	Gm	19	999	11:59:91	6/10/2010		75 \| Vesly \| Gm \| 999 \| 11:59:91 \|	75
78	Taratang	Gm	19	999	12:00:95	16/10/2007		76 \| Taratang \| Gm \| 999 \| 12:00:95 \|	76
79	Deeem2031	Gm	19	999	12:01:48	4/4/2010		77 \| Deeem2031 \| Gm \| 999 \| 12:01:48 \|	77
80	marq	Gm	19	999	12:01:63	6/3/2016		78 \| marq \| Gm \| 999 \| 12:01:63 \|	78
81	zid	Gm	19	999	12:03:20			79 \| zid \| Gm \| 999 \| 12:03:20 \|	79
82	Billmaan	Gm	19	999	12:07:23	6/5/2008		80 \| Billmaan \| Gm \| 999 \| 12:07:23 \|	80
83	PetitPrince	Gm	19	999	12:07:50	17/12/2012		81 \| PetitPrince \| Gm \| 999 \| 12:07:50 \|	81
84	Budster	Gm	19	999	12:09:08	19/06/2010		82 \| Budster \| Gm \| 999 \| 12:09:08 \|	82
85	Novomancy	Gm	19	999	12:09:28			83 \| Novomancy \| Gm \| 999 \| 12:09:28 \|	83
86	Ephraim225	Gm	19	999	12:09:33	21/08/2015		84 \| Ephraim225 \| Gm \| 999 \| 12:09:33 \|	84
87	CPN	Gm	19	999	12:10:25	18/01/2016		85 \| CPN \| Gm \| 999 \| 12:10:25 \|	85
88	switchpalacecorner	Gm	19	999	12:11:96		https://www.youtube.com/watch?v=EJPZ6jTHdT8	86 \| switchpalacecorner \| Gm \| 999 \| 12:11:96 \| [URL='https://www.youtube.com/watch?v=EJPZ6jTHdT8']video[/URL]	86
89	mikehaggar	Gm	19	999	12:18:06	16/09/2010		87 \| mikehaggar \| Gm \| 999 \| 12:18:06 \|	87
90	squidlarkin	Gm	19	999	12:18:86			88 \| squidlarkin \| Gm \| 999 \| 12:18:86 \|	88
91	Caithness	Gm	19	999	12:19:06	17/01/2015		89 \| Caithness \| Gm \| 999 \| 12:19:06 \|	89
92	Xkeeper	Gm	19	999	12:20:31	24/04/2009		90 \| Xkeeper \| Gm \| 999 \| 12:20:31 \|	90
93	Kasumi	Gm	19	999	12:22:48	26/03/2011		91 \| Kasumi \| Gm \| 999 \| 12:22:48 \|	91
94	Malth	Gm	19	999	12:22:76	3/1/2016		92 \| Malth \| Gm \| 999 \| 12:22:76 \|	92
95	TGGC	Gm	19	999	12:23:63	9/2/2016		93 \| TGGC \| Gm \| 999 \| 12:23:63 \|	93
96	Boing	Gm	19	999	12:29:15			94 \| Boing \| Gm \| 999 \| 12:29:15 \|	94
97	tweak	Gm	19	999	12:31:05			95 \| tweak \| Gm \| 999 \| 12:31:05 \|	95
98	Lion	Gm	19	999	12:31:43	6/2/2008		96 \| Lion \| Gm \| 999 \| 12:31:43 \|	96
99	gila	Gm	19	999	12:31:76	1/3/2009		97 \| gila \| Gm \| 999 \| 12:31:76 \|	97
100	Crashdown	Gm	19	999	12:33:08	4/6/2015		98 \| Crashdown \| Gm \| 999 \| 12:33:08 \|	98