OFFSEASON: Mega Draft

[Ryan Scott (Hoops Fan)]

Yeshiva posted a roster - no Bar Alluf, sadly.  There's rumor he might be eligible at some point during the season, but I'm not going to take the chance:

Drop: Bar Alluf, Yeshiva
Add: Daniel Tzion, Yeshiva

Drop: Ian Robertson, Randolph-Macon
Add: Adam Liberman, Yeshiva

Welp, one of those moves was good - unfortunately, Liberman isn't on Yeshiva's roster anymore and Robertson is looking pretty good for RMC.  Wish I could have that one back.

[FCGrizzliesGrad]

It's taking me longer than I'd hoped (at least if we do it again next year I won't be starting from scratch). I'm past the halfway mark. Haven't spent as much time on it as I'd like but I'm trying to carve out time when I can. I think I can get about 100 in an hour when I'm focused and in a rhythm. Looking like around 10% of players aren't listed on the roster.

My plan is to get it up and going, then I'll work through the missing players and worry about taking out the non-d3 games and such. My optimistic goal is to be through the list by Monday (no guarantees though).

[FCGrizzliesGrad]

I've managed to find out where a few players disappeared to...
Still D3

Haynes, Caleb	Berry
Coffy, Pierre	Emory
Perry, Mark	Neumann
Barnes, Kashaun	Ramapo
McCloskey, John	Rowan
Williams Jr., Keenan	Stockton

Non D3

Arthur, Jeremy	Franklin Pierce
Goetz, Adam	Kentucky Wesleyan
Alston, Elijah	Lander
Smith, Reed	Trevecca Nazarene
Levi, Spencer	UNC Pembroke

However I have a long list that seem to have just disappeared. Maybe they quit basketball, maybe they left school, maybe they went to a non NCAA school. If anyone has any information about any of these 85 players and if they might be playing at a D3 school this season, let me know.

Albion	Burks, Quay
Albright	Rowles, Fred
Alfred	Schmidt, Derek
Alvernia	Moultrie, Calil
Bard	Oyakhilome, Emmanuel
Belhaven	Brown, Isiah
Beloit	Shead, Nathan
Berea	Miller, Terique
Bethany (WV)	Truex, Chaice
Birmingham-So.	Rudak, Matty
Bowdoin	Cost, Caleb
Bowdoin	Edwards, Morgan
Brevard	Johnson, Jamarquis
Buffalo St.	Campbell, Sir.Quintin
Cairn	Nunnally, Antoine
Carthage	Thomas, Jordan
Castleton	Nelson, Jordan
Clark (MA)	McCormick, Luca
Colby	Lum, Walter
Dallas	Colvin, Darrius
Defiance	Graham, Kiewuan
DeSales	Dawson-Amoah, Kweku
Elms	Metelus, Greg
Finlandia	Robinette, Brandon
Gallaudet	Kelly, Preston
Goucher	Smith, Jacob
Greensboro	Maddox, Darus
Greenville	Bonney, Vari
Greenville	Grady, Sonti
Hanover	White, Nick
Hilbert	Alvarez, Antonio
Howard Payne	Hurd, De'Marcus
Illinois Col.	Hays, Brady
John Jay	Animashaun, Hakeem
Kenyon	Stern, Ben
Keystone	Bennett, JT
La Roche	Thomas, Trell
La Verne	Currie, Cole
Lancaster Bible	Majok, Christo
Lasell	Blair, Tim
Lebanon Valley	Stambaugh, Luke
Lehman	Akalonu, Clinton
Lewis & Clark	Bricker, Nico
Lewis & Clark	Vickers, Andrew
MacMurray	Cameron, Mike
Marietta	Williams, Avery
MCLA	Yearsley, Noah
McMurry	Stephenson, Luke
Methodist	Jackson, Dante
Newbury	Rivera, Miguel
Nichols	Dion, Tyler
NVU-Johnson	Irvin, Shakeel
Ohio Northern	Waugh, Brandon
Penn College	Young, Robert
Penn College	Bullock, James
Penn St.-Berks	Dimeo, David
Pfeiffer	Jones, Brendan
Pfeiffer	Sawyers, Marcus
Principia	Sellers, Payton
Purchase	Cann, Deshawn
Ramapo	Peterson, Patrick
Redlands	Baker, Trevor
Rhode Island Col.	Donaldson, Chris
RIT	Aguilera, Robert
Rivier	Givens, Tristian
Rutgers-Camden	Destin, Isaac
Rutgers-Camden	Harris, Anthony
Sage Colleges	Lenihan, Kevin
Salem St.	Santos, Alexander
Salve Regina	Bowman, Isaiah
Southern Va.	Prisbrey, Justin
Stevenson	Johnson, Jaylin
SUNY Canton	Williams, Adrian
Susquehanna	Walsh, Jacob
Texas-Tyler	Lane, Johnell
Transylvania	Gullett, Kyle
Webster	Crespo, Christian
Wells	DeJesus, Macho
Western Conn. St.	Rowe, Tyler
Western New Eng.	Day, EJ
Westminster (PA)	Kane-Johnson, Cameron
Wheelock	Rodriguez, Dejuan
Wis.-Superior	Milenkovic, Vid
Yeshiva	Liberman, Adam
York (NY)	Smart, Ryan

[WUPHF]

Crespo is at Hiram.

[Ryan Scott (Hoops Fan)]

Andrew Vickers, formerly of Lewis and Clark, plays for Whitman.

I think Tyler Dion plays for Worcester State.

[FCGrizzliesGrad]

Been a productive weekend. I've about got it finished. Still a few bugs to iron out (like the fact that importing several hundred tables at the same time seems to make the spreadsheet a bit angry). I have a plan, just have to play around with it until it's working as I hope.
I promise I'll have it up and going before next July

[FCGrizzliesGrad]

It's almost finished. Google sheets are still a bit buggy at times but it's as good as it will be. At least I have an idea of how to get this up much faster should we do this again next year. I'm just catching up on the month and a half of games that I have to fix manually and making a check on all the players I didn't have set up yet. Hoping to have everything caught up and fully running as a Christmas present.

Each of the 5 teams are in their own spreadsheet.
The first sheet is a summary. There's two sets of scores, the left one is the scores as they're being loaded in but can be off (sometimes a player doesn't load for a while, disappears entirely, or has a stat with a / denoting a conference high which messes up the calculation), while the right one is a full score as of whatever date is listed.
The next 4 sheets are where all the scores are. It's mostly automated but I have to remove the non-D3 games and fix the / ones. The score in column E is the total score for that player. Column F is where I just copy down the scores so there's a non-changing result. Column G is where all the calculations are done and where I do the fixes that need done.
The final sheet is a list of all the players that don't seem to be on a team this year. I will make a final pass through them at the end of the season

I believe my sheet is fully set up. I'll post the others as they're finished. Let me know if you see anything I've missed. My score as of 12/20 is 33,873. We shall see soon how that compares
FCGG
I found a few players I didn't have set yet.
Robert Young - Penn College Alvernia
Antonio Alvarez -  Hilbert Brockport
Hakeem Animashaun - John Jay Salem St

[FCGrizzliesGrad]

I've got NCF's ready. I have her current score at 29,631.

NCF

If there are any errors let me know.

[FCGrizzliesGrad]

ronk is up next. Far fewer missing players than the previous two rosters but still only a score of 32,920.

ronk
NCF
FCGG

[Smitty Oom]

This is so awesome, Grizz!!

[FCGrizzliesGrad]

4 out of 5 done. Scores should be update as of the 22nd for each. Ryan takes the provisional lead by having fewer missing players.

Ryan - 34,492
FCGG - 34,277
ronk - 32,941
NCF - 29,773

[FCGrizzliesGrad]

Just in time for Christmas... the final spreadsheet is ready.

Ryan - 34,492
FCGG - 34,277
Smitty - 33,158
ronk - 32,941
NCF - 29,773

[Ryan Scott (Hoops Fan)]

I'm winning?!!!!

That is totally unexpected.  A Christmas miracle!

[FCGrizzliesGrad]

End of 2018 standings. Ryan extends his lead while ronk moves up to 3rd.

Ryan - 38,756
FCGG - 37,846
ronk - 36,903
Smitty - 36,685
NCF - 33,156

[FCGrizzliesGrad]

Through 1/6. Ryan's lead has reached 4 digits.

Ryan - 44,758
FCGG - 43,714
Smitty - 42,930
ronk - 42,325
NCF - 38,381