Draft/Pass - Assists
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACAD
1
2016-2017 NCAA Assists Leaders - Draft/Pass Case Study
2
Condition 1:If the player averages more than 7 assists per 40 minutes AND fewer than 3 turnovers per 40 minutes.
3
Condition 2:If the player maintains an Assist per 40 minutes to Turnover per 40 minutes (A/TP40M) ratio of greater than or equal to 2.5.
4
Using:Rank and IF/THEN functions
5
6
RKNameTeamGPMinutesAssistsAPGAP40MTOTOPG
TOP40M
A/TP40M
STATUS 1
Results - COND. 1
STATUS 2
Results - COND. 2
7
1Ball, LonzoUCLA3334.902547.708.82832.522.883.06DraftBall, LonzoDraftBall, Lonzo
8
2Luke, AustinBEL2830.701987.079.21853.043.962.33Pass Pass
9
3Garcia, EricWOF3333.702266.858.13601.822.163.77DraftGarcia, EricDraftGarcia, Eric
10
4Cartwright, KyronPROV3233.202156.728.09922.883.462.34Pass Pass
11
5Hollins, Tra-DeonOMA3233.002096.537.921193.724.511.76Pass Pass
12
6Adams, JaylenSBON3037.401956.506.951033.433.671.89Pass Pass
13
7Simmons, JaaronOHIO3136.002006.457.171233.974.411.63Pass Pass
14
8Cunningham, ChristenSAM3434.602166.357.34742.182.522.92DraftCunningham, ChristenDraftCunningham, Christen
15
9Neal, ErickUTA3331.602096.338.021153.484.411.82Pass Pass
16
10Evans, JawunOKST3129.001926.198.54862.773.832.23Pass Pass
17
11Smith, DennisNCST3234.801976.167.081083.383.881.82Pass Pass
18
12Evans, MoIPFW3131.701906.137.73963.103.911.98Pass Pass
19
13Adams, JalenCONN3235.501956.096.87993.093.491.97Pass Pass
20
14Morris, MonteISU3335.402006.066.85351.061.205.71Pass DraftMorris, Monte
21
15Chambers, SiyaniHARV2632.501576.047.43532.042.512.96DraftChambers, SiyaniDraftChambers, Siyani
22
16Fultz, MarkelleWASH2535.701485.926.63803.203.591.85Pass Pass
23
17Elmore. JOnMRSH3535.102075.916.741093.113.551.90Pass Pass
24
18Bracey, DaQuanLT3328.001935.858.35551.672.383.51DraftBracey, DaQuanDraftBracey, DaQuan
25
19Artis, DominicUTEP3236.501875.846.401003.133.421.87Pass Pass
26
20Naar, EmmettSMC3232.801845.757.01762.382.902.42DraftNaar, EmmettPass
27
21Rahon, JoeSMC3236.301825.696.27531.661.833.43Pass DraftRahon, Joe
28
21Cline, TJRICH3232.401825.697.02932.913.591.96Pass Pass
29
23Cole, PatrickNCCU3235.201815.666.431213.784.301.50Pass Pass
30
24Robinson, AlexTCU3432.701905.596.84862.533.092.21Pass Pass
31
25Davis, JordanUNCO2933.701625.596.631264.345.161.29Pass Pass
32
26Jordan, StevieRID2931.301615.557.091033.554.541.56Pass Pass
33
27Thomas, DonteARST3228.301775.537.82892.783.931.99Pass Pass
34
28McLaughlin, JordanUSC3333.901815.486.47732.212.612.48Pass Pass
35
29Farrell, MattND3434.301865.476.38842.472.882.21Pass Pass
36
30Ingram, DenzelUNCW3433.401855.446.52591.742.083.14Pass DraftIngram, Denzel
37
31Rivera, AngelSTET3031.001625.406.97521.732.243.12Pass DraftRivera, Angel
38
32Russell, DeWayneGCU2838.301515.395.63752.682.802.01Pass Pass
39
33Crawford, BryantWAKE3231.701725.386.78722.252.842.39Pass Pass
40
34Gillon, JohnSYR3230.101715.347.10662.062.742.59DraftGillon, JohnDraftGillon, John
41
35Graves, MarcusSAC3135.101655.326.07812.612.982.04Pass Pass
42
36Ross, KahronLEH3133.101645.296.39752.422.922.19Pass Pass
43
37Williams, TJNE3038.201585.275.511013.373.531.56Pass Pass
44
38Graf, DajuanNCCU3335.401735.245.92912.763.121.90Pass Pass
45
39McIntosh, BryantNW3434.101785.246.14882.593.042.02Pass Pass
46
39McGill, RickeyIONA3432.501785.246.44671.972.432.66Pass DraftMcGill, Rickey
47
41Hauser, MattSCU3135.501625.235.89511.651.853.18Pass DraftHauser, Matt
48
42Stark, JonathanMURR3336.601725.215.70952.883.151.81Pass Pass
49
43Powers, DeronHOF3233.201665.196.25842.633.161.98Pass Pass
50
44Rideau, LaquincyWEBB3329.101715.187.121123.394.671.53Pass Pass
51
45McCall, TahjereTNST2732.101395.156.42993.674.571.40Pass Pass
52
46Winston, CassiusMSU3320.501695.129.99742.244.382.28Pass Pass
53
47Woodhouse, LucasSTON3132.001585.106.37611.972.462.59Pass DraftWoodhouse, Lucas
54
48Mason III, FrankKU3236.201635.095.63802.502.762.04Pass Pass
55
49Powell, JavaughnNICH3132.601565.036.171153.714.551.36Pass Pass
56
50Lee, ParisILST3330.801665.036.53852.583.351.95Pass Pass
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
Loading...
Main menu