November 2020
M T W T F S S
« Mar    
 1
2345678
9101112131415
16171819202122
23242526272829
30  
Blogs

12/16 Computer Lab Activity: Sort the data below so that it has the highest point totals on top and the individuals that have not played at all (the ones with 7 of “U—” ) are at the bottom of the list.  Try to come up with your own idea on how to sort it.  If you get stuck, one way is to use the =COUNTIF function.

Standings. MWL1314: Extra
# Last First ID Rtng Rd1 Rd2 Rd3 Rd4 Rd5 Rd6 Rd7 Total
1 Logan Ronlov HSOLQ898 1097 W20 W95 W23 W17 W32 D37 W52 6.5
2 Jeremy Thomas WLLK 0 unr. W91 U— U— W12 W4 W14 W86 5.0
3 Christian Sevey WLLJ 0 unr. W8 L11 L24 W31 W14 W4 W5 5.0
4 Corwin Benedict PHEG 0 unr. W89 W18 W38 D16 L2 L3 W31 4.5
5 Sam Schuetz PHEIQ415 994 W94 W88 W18 L13 W38 U— L3 4.0
6 Nathan Faber PLHIV637 1049 W23 W13 W88 L7 D17 U— U— 3.5
7 Brendon Sevey WLLLQ756 960 W22 W68 U— W6 U— U— U— 3.0
8 Jordan Lyda PLHIT946 940 L3 W16 W26 W77 U— U— U— 3.0
9 Ike Sugitani PHEIW171 634 W77 L12 W31 L14 L16 L18 W33 3.0
10 Evan Clark WLLJQ655 506 W78 L22 W12 L11 W84 U— L30 3.0
11 Eric Gibbs PLHIR414 1018 L13 W3 U— W10 U— U— U— 2.0
12 Seth Bolton JNCKL592 739 L15 W9 L10 L2 U— W16 U— 2.0
13 Jordan Yarborough WLLMT628 675 W11 L6 U— W5 U— U— L26 2.0
14 David Peterson JNCJ unr. U— U— W15 W9 L3 L2 U— 2.0
15 Hunter Murphy PHEIU166 884 W12 D38 L14 U— U— U— U— 1.5
16 Shayna Cardin WLLMS005 454 U— L8 U— D4 W9 L12 U— 1.5
17 Victor Dossin FOXEQ972 unr. U— W52 L20 L1 D6 U— U— 1.5
18 Josh Swancutt JNCK unr. U— L4 L5 D19 U— W9 U— 1.5
19 Jamie Westmoreland CTGJ unr. U— U— W33 D18 U— U— L34 1.5
20 Torrey Gage-Tomlinson PLHIR043 1327 L1 U— W17 U— U— U— U— 1.0
21 Jack Woo McClain CMRFS743 1303 W48 U— U— U— U— U— U— 1.0
22 Lane Crabtree PLHHR213 1077 L7 W10 U— U— U— U— U— 1.0
23 Lowden Hansen WLLKP170 884 L6 W61 L1 U— U— U— U— 1.0
24 Justin Long CTGJT903 703 U— U— W3 U— U— U— U— 1.0
25 William Stearns MRHLT576 515 U— U— U— U— U— U— U— 1.0
26 Benjamin Bauml CTGKQ091 487 U— U— L8 U— U— U— W13 1.0
27 Cliff Noonan MRHLR288 453 U— U— U— U— U— U— U— 1.0
28 Trent Clack CRWLS382 400 U— U— U— U— U— U— U— 1.0
29 Elijah Castellon WLLKW293 400 U— U— U— U— U— U— U— 1.0
30 Ryan Brady SHDK unr. U— U— U— U— U— U— W10 1.0
31 Alexander Reimann CTGI unr. U— W91 L9 L3 U— U— L4 1.0
32 Gal Schlesinger SEUL unr. U— U— U— W88 L1 U— U— 1.0
33 Ben Bagley JNCJ unr. U— U— L19 U— U— W34 L9 1.0
34 Cade O’Connor SHDK unr. U— U— U— U— U— L33 W19 1.0
35 Garrett Harris JNCL unr. U— U— W82 U— U— U— U— 1.0
36 Rodrigo Martinez JNCJ 0 unr. W38 U— U— U— U— U— U— 1.0
37 Calem Englehardt WLLMN316 1134 U— U— U— U— U— D1 U— 0.5
38 Toby Hardan WLLJ 0 unr. L36 D15 L4 U— L5 U— U— 0.5
39 Erik Skalnes SEULQ859 1897 U— U— U— U— U— U— U— 0.0
40 Derek Wang SEUKR106 1489 U— U— U— U— U— U— U— 0.0
41 Henry Lancaster CTGMR664 1399 U— U— U— U— U— U— U— 0.0
42 Simon Venter SEUJQ764 1335 U— U— U— U— U— U— U— 0.0
43 Cody Webb WLLMN226 1318 U— U— U— U— U— U— U— 0.0
44 Johnny Wang ROMJQ528 1317 U— U— U— U— U— U— U— 0.0
45 Tommy Case ROMHW568 1291 U— U— U— U— U— U— U— 0.0
46 Gabe Bellavita CTGMQ822 1226 U— U— U— U— U— U— U— 0.0
47 Ben Larson PLHMQ660 1217 U— U— U— U— U— U— U— 0.0
48 Yu Yang Zhang WLLMU612 1213 L21 U— U— U— U— U— U— 0.0
49 Ben Kurtz SHDLT801 1183 U— U— U— U— U— U— U— 0.0
50 Isaiah Dobrusky-bliss SEUKR012 1172 U— U— U— U— U— U— U— 0.0
51 Owen Young-flynn WLLLN190 1151 U— U— U— U— U— U— U— 0.0
52 Jared Roe WLLMT963 1124 U— L17 U— U— U— U— L1 0.0
53 Ivan Jensen ROMIR493 1123 U— U— U— U— U— U— U— 0.0
54 Brior Hileman WLLMU173 1115 U— U— U— U— U— U— U— 0.0
55 Alex Leong PLHMR039 1083 U— U— U— U— U— U— U— 0.0
56 Sophia Dossin SEUJT916 1071 U— U— U— U— U— U— U— 0.0
57 Tristan Bredeweg SHDMQ451 1049 U— U— U— U— U— U— U— 0.0
58 Kevin Huh PLHLQ347 1031 U— U— U— U— U— U— U— 0.0
59 Gobind Ollek SHDLL886 1024 U— U— U— U— U— U— U— 0.0
60 Dalton Harris JNCMT665 1014 U— U— U— U— U— U— U— 0.0
61 Deepraj Pawar PLHMQ540 988 U— L23 U— U— U— U— U— 0.0
62 Emma Nabors MRHKL842 953 U— U— U— U— U— U— U— 0.0
63 Christopher Glesmann CTGJV754 949 U— U— U— U— U— U— U— 0.0
64 Wiley Peebles SHDKR005 887 U— U— U— U— U— U— U— 0.0
65 Gabe Shepard JNCML745 879 U— U— U— U— U— U— U— 0.0
66 Caleb Frasier CRWLQ621 868 U— U— U— U— U— U— U— 0.0
67 Isaiah Eads JNCLQ206 823 U— U— U— U— U— U— U— 0.0
68 Balreet Pawar PLHKQ983 816 U— L7 U— U— U— U— U— 0.0
69 Dan Gonzalez CRWMQ317 789 U— U— U— U— U— U— U— 0.0
70 Theodore Ansel JNCMU479 736 U— U— U— U— U— U— U— 0.0

Leave a Reply

Your email address will not be published. Required fields are marked *