PingPong Score Tracker & Leaderboard (Google Sheet Template)

	A	B	C	D	E	F	G	H
2			PongUp!
3
4
5			🏓 Ping pong score tracker and leaderboard
6			🏓 Ping pong score tracker and leaderboard
7
8			We had been using this google sheet template to record 722 matches at 4mation technologies, before finally building out a proper app for this.
9			Check out https://getpongup.com if you're looking to upgrade to an app instead.
10
11			Instructions
12			1. To keep a copy of this	Go to "File" and then click "Make a copy" or "download"
13			2. To add a new player:	a. Duplicate the "Player Template" sheet and rename it to the player's name.
14				b. Within that sheet in column A, replace "AA" with the player's name
15				c. Add a row for the player in the "Players" sheet
16			3. To add a new match	Just add a new row in the "Matches" sheet
17
18			That's it, enjoy this sheet! Player and matches data prepopulated for reference purposes, feel free to clear them out.
19
20
21
22	Biggest winning streak	Tom S	24
23	Highest consecutive loss	Max	16
24	LEADERBOARD
25	Name	Number of Games	Number of Wins	Number of Loses	Win Rate	Consecutive Wins	Consecutive Loses	Elo Points
26	Tom S	124	94	30	75.81	24	3	1309.44
27	Frank	114	72	42	63.16	11	4	1232
28	Rob	54	34	20	62.96	10	6	1173.44
29	Gui	85	39	46	45.88	4	9	1139.52
30	Tejas	44	29	15	65.91	9	5	1119.04
31	Jacky	113	55	58	48.67	7	5	1054.4
32	Daniel	24	16	8	66.67	5	2	1046.08
33	Fahad	1	1	0	100	1	0	1012.16
34	Steve	8	3	5	37.5	2	3	1002.88
35	Ruben	0	0	0	0	0	0	1000
36	Bryan	0	0	0	0	0	0	1000
37	Andrew	0	0	0	0	0	0	1000
38	Max	240	110	130	45.83	12	16	977.6
39	Glenn B	3	0	3	0	0	3	971.52
40	Micheal	156	82	74	52.56	15	9	965.12
41	Simon	84	43	41	51.19	7	6	943.68
42	Manish	38	12	26	31.58	4	5	920.96
43	Andy	48	15	33	31.25	3	10	915.52
44	Tom H	9	1	8	11.11	1	8	894.08
45	Dennis	198	93	105	46.97	9	12	872.96
46	Kunal	10	1	9	10	1	6	866.56
47	Warren	29	4	25	13.79	3	10	816.32
48	Harlan	58	16	42	27.59	3	8	793.92
49
50
51
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
101