Top 10 SmartSheet

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR
1	© SupremeCommander world Brisgard NL	Ranking World			Guild ranking			͏ S e t d a t e and p o i n t s ͏						Diff. points period	Diff. points all time	Set dates period	Set dates all time	Points per day	points per day all time	Percentage diff. period	Percentage diff. all time	Percentage per day period	Expected next points	Expected days untill next rank (period)	Expected days untill next rank (all time)	# fights			Medal growth			Fix up and motivational scheme. Note the number of times player has fixed up/ motivated, and the number of days you have counted. So if player "X" has done it twice in three days then the number is "2" and days are "3" wich translates to a 150% score. This sheet has a setup for five people that check this, but if you add more columns and alter the formula then more are possible.										Sub total number	Sub total days	Total
2	Averages >>>	6	6	0							761.940	16:00 hrs	839.029	9.883	21.946			4.217	6.643	10,15%	11,80%	0,56%		(based on current growth)	(based on all time growth)			0			0	Name		Name		Name		Name		Name		Sub total number	Sub total days	Total
3	Player name	New	Old	Diff	Old	New	Diff	Start date	Start points	Set date 1	Old	Set date 2	New	Diff (pnt)	Diff (pnt)	Days	Days	PPD	PPDA	Diff (%)	Diff (%)	% Per dag				Old	New	Diff.	Old	New	Diff	Number	days	Number	days	Number	days	Number	days	Number	days	Number	days

4	Big Moees	1	1	0			0	8-3-2013	919.077	15-3-2013	1.039.516	6-4-2013	1.140.030	100.514	220.953	22	29	4.569	7.619	9,67%	10,94%	0,44%	1.144.599	-	-			0			0											0	0	0
5	Zaaco	2	2	0			0	8-3-2013	700.665	15-3-2013	801.769	6-4-2013	878.968	77.199	178.303	22	29	3.509	6.148	9,63%	11,02%	0,44%	882.477	-	-			0			0											0	0	0
6	Myrddhyn	3	3	0			0	8-3-2013	655.965	15-3-2013	772.402	6-4-2013	861.938	89.536	205.973	22	29	4.070	7.103	11,59%	13,65%	0,53%	866.008	(30)	(18)			0			0											0	0	0
7	SupremeCommander	4	5	1			0	8-3-2013	609.272	15-3-2013	739.185	6-4-2013	842.317	103.132	233.045	22	29	4.688	8.036	13,95%	16,93%	0,63%	847.005	(32)	(21)			0			0											0	0	0
8	Nelma	5	9	4			0	8-3-2013	564.219	15-3-2013	696.948	6-4-2013	806.684	109.736	242.465	22	29	4.988	8.361	15,75%	19,45%	0,72%	811.672	(119)	(110)			0			0											0	0	0
9	mvharn	6	4	-2			0	8-3-2013	645.773	15-3-2013	740.976	6-4-2013	789.900	48.924	144.127	22	29	2.224	4.970	6,60%	7,58%	0,30%	792.124	-	-			0			0											0	0	0
10	Menty	8	7	-1			0	8-3-2013	616.765	15-3-2013	700.073	6-4-2013	780.931	80.858	164.166	22	29	3.675	5.661	11,55%	13,11%	0,52%	784.606	(6)	(13)			0			0											0	0	0
11	Caro	7	6	-1			0	8-3-2013	623.143	15-3-2013	707.660	6-4-2013	775.326	67.666	152.183	22	29	3.076	5.248	9,56%	10,86%	0,43%	778.402	-	-			0			0											0	0	0
12	pcsurgeon	9	8	-1			0	8-3-2013	609.338	15-3-2013	700.428	6-4-2013	768.995	68.567	145.852	22	29	3.117	5.029	9,79%	11,00%	0,44%	772.112	(155)	-			0			0											0	0	0
13	AAPJ	10	11	1			0	3-4-2013	720.447	3-4-2013	720.447	6-4-2013	745.205	24.758	24.758	3	3	8.253	8.253	3,44%	3,44%	1,15%	753.458	(5)	(7)			0			0											0	0	0
14				0			0							0	0	0	0							-	-			0			0											0	0	0
15				0			0							0	0	0	0							-	-			0			0											0	0	0
16				0			0							0	0	0	0							-	-			0			0											0	0	0
17				0			0							0	0	0	0							-	-			0			0											0	0	0
18				0			0							0	0	0	0							-	-			0			0											0	0	0
19				0			0							0	0	0	0							-	-			0			0											0	0	0
20				0			0							0	0	0	0							-	-			0			0											0	0	0
21				0			0							0	0	0	0							-	-			0			0											0	0	0
22				0			0							0	0	0	0							-	-			0			0											0	0	0
23				0			0							0	0	0	0							-	-			0			0											0	0	0
24				0			0							0	0	0	0							-	-			0			0											0	0	0
25				0			0							0	0	0	0							-	-			0			0											0	0	0
26				0			0							0	0	0	0							-	-			0			0											0	0	0
27				0			0							0	0	0	0							-	-			0			0											0	0	0
28				0			0							0	0	0	0							-	-			0			0											0	0	0
29				0			0							0	0	0	0							-	-			0			0											0	0	0
30				0			0							0	0	0	0							-	-			0			0											0	0	0
31				0			0							0	0	0	0							-	-			0			0											0	0	0
32				0			0							0	0	0	0							-	-			0			0											0	0	0
33				0			0							0	0	0	0							-	-			0			0											0	0	0
34				0			0							0	0	0	0							-	-			0			0											0	0	0
35				0			0							0	0	0	0							-	-			0			0											0	0	0
36				0			0							0	0	0	0							-	-			0			0											0	0	0
37				0			0							0	0	0	0							-	-			0			0											0	0	0
38				0			0							0	0	0	0							-	-			0			0											0	0	0
39				0			0							0	0	0	0							-	-			0			0											0	0	0
40				0			0							0	0	0	0							-	-			0			0											0	0	0
41				0			0							0	0	0	0							-	-			0			0											0	0	0
42				0			0							0	0	0	0							-	-			0			0											0	0	0
43				0			0							0	0	0	0							-	-			0			0											0	0	0
44				0			0							0	0	0	0							-	-			0			0											0	0	0
45				0			0							0	0	0	0							-	-			0			0											0	0	0
46				0			0							0	0	0	0							-	-			0			0											0	0	0
47				0			0							0	0	0	0							-	-			0			0											0	0	0
48				0			0							0	0	0	0							-	-			0			0											0	0	0
49				0			0							0	0	0	0							-	-			0			0											0	0	0
50				0			0							0	0	0	0							-	-			0			0											0	0	0
51				0			0							0	0	0	0							-	-			0			0											0	0	0
52				0			0							0	0	0	0							-	-			0			0											0	0	0
53				0			0							0	0	0	0							-	-			0			0											0	0	0
54				0			0							0	0	0	0							-	-			0			0											0	0	0
55				0			0							0	0	0	0							-	-			0			0											0	0	0
56				0			0							0	0	0	0							-	-			0			0											0	0	0
57				0			0							0	0	0	0							-	-			0			0											0	0	0
58				0			0							0	0	0	0							-	-			0			0											0	0	0
59				0			0							0	0	0	0							-	-			0			0											0	0	0
60				0			0							0	0	0	0							-	-			0			0											0	0	0
61				0			0							0	0	0	0							-	-			0			0											0	0	0
62				0			0							0	0	0	0							-	-			0			0											0	0	0
63				0			0							0	0	0	0							-	-			0			0											0	0	0
64				0			0							0	0	0	0							-	-			0			0											0	0	0
65				0			0							0	0	0	0							-	-			0			0											0	0	0
66				0			0							0	0	0	0							-	-			0			0											0	0	0
67				0			0							0	0	0	0							-	-			0			0											0	0	0
68				0			0							0	0	0	0							-	-			0			0											0	0	0
69				0			0							0	0	0	0							-	-			0			0											0	0	0
70				0			0							0	0	0	0							-	-			0			0											0	0	0
71				0			0							0	0	0	0							-	-			0			0											0	0	0
72				0			0							0	0	0	0							-	-			0			0											0	0	0
73				0			0							0	0	0	0							-	-			0			0											0	0	0
74				0			0							0	0	0	0							-	-			0			0											0	0	0
75				0			0							0	0	0	0							-	-			0			0											0	0	0
76				0			0							0	0	0	0							-	-			0			0											0	0	0
77				0			0							0	0	0	0							-	-			0			0											0	0	0
78				0			0							0	0	0	0							-	-			0			0											0	0	0
79				0			0							0	0	0	0							-	-			0			0											0	0	0
80				0			0							0	0	0	0							-	-			0			0											0	0	0
81				0			0							0	0	0	0							-	-			0			0											0	0	0
82				0			0							0	0	0	0							-	-			0			0											0	0	0