nats quick and dirty.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	N	O
1	PPG rank	Player	Status	Team	GP	aPPG	A	B	C	D	E	QD		Key
2	1	Matt Jackson		Chicago A	7	87.9	137.9	426.4	426.4	0.637	1	0.637	aPPG	Player points per game adjusted to 11 games played
3	2	Tracy Mirkin	UG	Florida A	7	85	122.1	327.9	426.4	0.696	0.591	0.412	A	Team tossup points per game
4	4	Clark Smith		Ohio State A	7	55.7	120.7	352.1	426.4	0.462	0.682	0.315	B	Team points per game
5	9	Natan Holtzman		Stanford A	7	47.9	123.6	377.9	426.4	0.387	0.785	0.304	C	Maximum team points per game
6	8	Arya Karthik	D2	Georgia Tech A	7	49.3	111.4	347.1	426.4	0.442	0.663	0.293	D	Player tu PPG / team tu PPG (aPPG / A)
7	7	Chris Ray		Ohio State A	7	50	120.7	352.1	426.4	0.414	0.682	0.282	E	Team PPG^2 / Max team PPG^2 (B^2 / C^2)
8	11	Tim Morrison		Stanford A	7	44.3	123.6	377.9	426.4	0.358	0.785	0.281	QD	Quick and dirty stat (D * E * F)
9	5	Matthew Lehmann		WUSTL A	7	54.3	102.2	305	426.4	0.531	0.512	0.272
10	10	Hari Parameswaran	UG	Georgia Tech A	7	45.7	111.4	347.1	426.4	0.41	0.663	0.272
11	6	Amogh Kulkarni	D2	Chicago B	7	50.7	109.3	302.1	426.4	0.464	0.502	0.233
12	3	Caleb Kendrick		Maryland A	7	60.7	98.6	251.4	426.4	0.616	0.348	0.214
13	24	Michal Gerasimiuk	UG	Yale A	7	34.3	115.7	332.9	426.4	0.296	0.61	0.181
14	14	Jason Hong	UG	Brown A	7	42.1	93.6	262.1	426.4	0.45	0.378	0.17
15	64	Adam Fine		Chicago A	7	22.9	137.9	426.4	426.4	0.166	1	0.166
16	34	Daniel Ma	UG	Yale A	7	30.7	115.7	332.9	426.4	0.265	0.61	0.162
17	32	Raymond Wang	D2	Cornell A	7	30.7	108.6	320	426.4	0.283	0.563	0.159
18	16	Vincent Du		North Carolina A	7	42.1	92.1	250.7	426.4	0.457	0.346	0.158
19	26	Charles Hang		WUSTL A	6.5	30.7	102.2	305	426.4	0.301	0.512	0.154
20	19	Arjun Nageswaran	D2	Harvard A	7	37.9	95	250.7	426.4	0.399	0.346	0.138
21	43	Jonathan Tran		Cornell A	7	26.4	108.6	320	426.4	0.243	0.563	0.137
22	52	Arthur Delot-Vilain	D2	Yale A	7	25.7	115.7	332.9	426.4	0.222	0.61	0.135
23	47	Nathan Zhang	D2	Cornell A	7	25.7	108.6	320	426.4	0.237	0.563	0.133
24	48	Geoffrey Chen	UG	Cornell A	7	25.7	108.6	320	426.4	0.237	0.563	0.133
25	57	Daniel Sheinberg	UG	Yale A	7	25	115.7	332.9	426.4	0.216	0.61	0.132
26	22	Ricky Li		MIT A	7	35	97.1	250	426.4	0.36	0.344	0.124
27	45	John Marvin		Chicago B	7	26.4	109.3	302.1	426.4	0.242	0.502	0.121
28	53	Vivek Sasse	UG	Chicago B	7	25.7	109.3	302.1	426.4	0.235	0.502	0.118
29	93	Eric Wolfsberg		Stanford A	7	17.9	123.6	377.9	426.4	0.145	0.785	0.114
30	31	Joel Miles	D2	Minnesota A	7	31.4	80	225.7	426.4	0.393	0.28	0.11
31	20	Ashish Subramanian	UG	Duke A	7	35.7	82.9	212.9	426.4	0.431	0.249	0.107
32	15	Grace Liu		MIT A	5	30	97.1	250	426.4	0.309	0.344	0.106
33	29	Eve Fleisig		UC Berkeley A	7	32.1	78.6	217.1	426.4	0.409	0.259	0.106
34	17	Mitch McCullar	UG	Illinois A	7	39.3	66.5	179.3	426.4	0.591	0.177	0.105
35	107	Claire Jones		Chicago A	7	14.3	137.9	426.4	426.4	0.104	1	0.104
36	54	Walter Zhang	UG	Brown A	7	25	93.6	262.1	426.4	0.267	0.378	0.101
37	13	Alex Schmidt	UG	Penn State A	7	43.6	64.3	161.4	426.4	0.678	0.143	0.097
38	42	Ethan Ashbrook	UG	Minnesota A	7	27.1	80	225.7	426.4	0.339	0.28	0.095
39	30	Jacob Egol	UG	Duke A	7	31.4	82.9	212.9	426.4	0.379	0.249	0.095
40	122	Ned Tagtmeier	D2	Chicago A	7	12.9	137.9	426.4	426.4	0.093	1	0.093
41	12	Halle Friedman		NYU A	7	43.6	62.9	154.3	426.4	0.693	0.131	0.091
42	49	Stevie Miller	D2	Maryland A	7	25.7	98.6	251.4	426.4	0.261	0.348	0.091
43	67	Anson Berns	UG	Brown A	7	22.1	93.6	262.1	426.4	0.237	0.378	0.089
44	63	Vittal Bhat	UG	North Carolina A	7	23.6	92.1	250.7	426.4	0.256	0.346	0.088
45	58	Cole Timmerwilke		Harvard A	7	24.3	95	250.7	426.4	0.256	0.346	0.088
46	18	Tegan Kapadia	D2	Georgia Tech B	7	37.9	62.9	161.4	426.4	0.602	0.143	0.086
47	120	Andrew Zeng	D2	Stanford A	7	13.6	123.6	377.9	426.4	0.11	0.785	0.086
48	44	Christopher Sims		Northwestern A	7	26.4	71.4	202.9	426.4	0.37	0.226	0.084
49	95	Leah Honsinger		Florida A	7	17.1	122.1	327.9	426.4	0.14	0.591	0.083
50	116	Alex Li		Georgia Tech A	7	13.6	111.4	347.1	426.4	0.122	0.663	0.081
51	68	Mazin Omer	UG	Harvard A	7	22.1	95	250.7	426.4	0.233	0.346	0.081
52	27	Robert Condron	UG	Chicago C	7	32.9	72.9	180	426.4	0.451	0.178	0.08
53	35	Justin Hawkins		Indiana A	7	30	70.7	183.6	426.4	0.424	0.185	0.079
54	21	Conor Thompson		Iowa State A	7	35.7	63.6	157.9	426.4	0.562	0.137	0.077
55	23	Todd Maslyk		Michigan A	7	34.3	60	155.7	426.4	0.571	0.133	0.076
56	65	Swapnil Garg		UC Berkeley A	7	22.9	78.6	217.1	426.4	0.291	0.259	0.075
57	40	Richard Niu	D2	Cornell B	7	27.9	75.7	188.6	426.4	0.368	0.196	0.072
58	25	Vedul Palavajjhala	D2	WUSTL B	7	33.6	65	156.4	426.4	0.517	0.135	0.069
59	109	Leo Law		Florida A	7	14.3	122.1	327.9	426.4	0.117	0.591	0.069
60	46	Noah Sheidlower	UG	Columbia A	7	25.7	67.1	178.6	426.4	0.383	0.175	0.067
61	61	Justin Wytmar	D2	Illinois A	7	23.6	66.5	179.3	426.4	0.355	0.177	0.063
62	38	Alex Pijanowski		Purdue A	7	28.6	70	167.1	426.4	0.408	0.154	0.063
63	33	Kevin Fan	UG	McGill A	7	30.7	60.7	149.3	426.4	0.506	0.123	0.062
64	56	Aum Mundhe	D2	Rutgers A	7	25	69.3	176.4	426.4	0.361	0.171	0.062
65	84	Andrew Salij		Northwestern A	7	19.3	71.4	202.9	426.4	0.27	0.226	0.061
66	59	Brad MacLaine		Texas A	7	24.3	68.6	175.7	426.4	0.354	0.17	0.06
67	37	Anuttam Ramji	D2	UC Berkeley B	6	25	76.4	180.7	426.4	0.327	0.18	0.059
68	62	Karan Gurazada	D2	Texas A	7	23.6	68.6	175.7	426.4	0.344	0.17	0.058
69	105	Jim Fan		North Carolina A	7	15	92.1	250.7	426.4	0.163	0.346	0.056
70	101	Steven Liu	UG	MIT A	7	15.7	97.1	250	426.4	0.162	0.344	0.056
71	76	Ian Chow		Toronto A	6	17.9	77.1	205.7	426.4	0.231	0.233	0.054
72	70	Henry Cafaro	UG	Chicago C	7	21.4	72.9	180	426.4	0.294	0.178	0.052
73	77	John John Groger	UG	Columbia A	7	20	67.1	178.6	426.4	0.298	0.175	0.052
74	55	Tanis Nielsen	UG	Claremont A	7	25	70	162.9	426.4	0.357	0.146	0.052
75	60	Sky Li		Toronto A	5	17.1	77.1	205.7	426.4	0.222	0.233	0.052
76	80	Wenying Wu	UG	Toronto A	6	17.1	77.1	205.7	426.4	0.222	0.233	0.052
77	41	Jonathan Lau	D2	Johns Hopkins A	7	27.1	63.6	147.9	426.4	0.427	0.12	0.051
78	50	Lexi Terman	UG	Rutgers B	7	25.7	62.1	149.3	426.4	0.414	0.123	0.051
79	51	Collin Ace	UG	Rutgers B	7	25.7	62.1	149.3	426.4	0.414	0.123	0.051
80	72	Karsten Rynearson	D2	Yale B	7	21.4	52.9	150	426.4	0.405	0.124	0.05
81	89	Alex Akridge		Indiana A	7	18.6	70.7	183.6	426.4	0.263	0.185	0.049
82	161	Roxanne Tang	UG	Ohio State A	7	8.6	120.7	352.1	426.4	0.071	0.682	0.048
83	66	Andrew Hanna	UG	Vanderbilt A	7	22.9	51.4	140	426.4	0.444	0.108	0.048
84	85	Aiden Dartley	D2	Rutgers A	7	19.3	69.3	176.4	426.4	0.278	0.171	0.048
85	39	Isak Jatoi	UG	South Carolina A	7	28.6	60.7	135	426.4	0.471	0.1	0.047
86	74	Albert Zhang	UG	Columbia B	7	20.7	64.3	162.9	426.4	0.322	0.146	0.047
87	79	Matthew Siff	D2	Yale B	7	20	52.9	150	426.4	0.378	0.124	0.047
88	134	Paul Lee		WUSTL A	5.5	9.3	102.2	305	426.4	0.091	0.512	0.047
89	78	Forrest Weintraub	UG	Columbia B	7	20	64.3	162.9	426.4	0.311	0.146	0.045
90	112	Nikhil Chellam		Northwestern A	7	14.3	71.4	202.9	426.4	0.2	0.226	0.045
91	121	Shahar Schwartz	UG	UC Berkeley A	7	13.6	78.6	217.1	426.4	0.173	0.259	0.045
92	138	Jonathan Shauf	UG	North Carolina A	7	11.4	92.1	250.7	426.4	0.124	0.346	0.043
93	83	James Stevenson	UG	Michigan A	7	19.3	60	155.7	426.4	0.321	0.133	0.043
94	128	Shardul Rao	D2	Minnesota A	7	12.1	80	225.7	426.4	0.152	0.28	0.043
95	86	Alana Dickey	UG	Virginia A	7	19.3	58.6	150	426.4	0.329	0.124	0.041
96	100	Rosa Xia	D2	Cornell B	7	15.7	75.7	188.6	426.4	0.207	0.196	0.041
97	81	Vinu Harihar		UC Berkeley B	6	17.1	76.4	180.7	426.4	0.224	0.18	0.04
98	75	Seth Ebner		Johns Hopkins A	7	20.7	63.6	147.9	426.4	0.326	0.12	0.039
99	96	S. A. Shenoy	UG	Georgia Tech B	7	17.1	62.9	161.4	426.4	0.273	0.143	0.039
100	124	Justin Duffy		Harvard A	6	10.7	95	250.7	426.4	0.113	0.346	0.039