2014 NCAA Tournament Player Pick Em - DRAFT

College Sports 549 replies 9,035 views
Azubuike24's avatar
Azubuike24
Posts: 15,933
Mar 17, 2014 4:16pm
Haha, I'm really distracted today. Kendall Williams, New Mexico.
Terry_Tate's avatar
Terry_Tate
Posts: 7,606
Mar 17, 2014 4:22pm
Cory Jefferson, Baylor
Laley23's avatar
Laley23
Posts: 29,506
Mar 17, 2014 4:33pm
Wizurhd takes Hield Oklahoma
Terry_Tate's avatar
Terry_Tate
Posts: 7,606
Mar 17, 2014 4:34pm
Laley23;1592149 wrote:Wizurhd takes Hield Oklahoma
Wizurhd is on it, was debating between him and Jefferson.
Laley23's avatar
Laley23
Posts: 29,506
Mar 17, 2014 4:35pm
Terry_Tate;1592150 wrote:Wizurhd is on it, was debating between him and Jefferson.
Crazy part is, he sent a list of about 20 guys this morning. He has 1 left, and for the msot part they have gone in order lol
Laley23's avatar
Laley23
Posts: 29,506
Mar 17, 2014 4:37pm
At 5:00, I am out of here and its sleeting down here in Carolina, so my commute home will probably be close to an hour. So I wont be back on till 6:30ish
Laley23's avatar
Laley23
Posts: 29,506
Mar 17, 2014 4:52pm
BTW, I have created a master spreadsheet that I THINK I have finished with formulas.

I can share it with whoever is interested, and you can edit the info.

The only cells that should need any input are (Player, Team, Seed, Opp. Seed, In/Out, Points). All the other cells should calculate from those changes being made.

Other cells include:

projected total
current total
current player total
projected team total
seed avg.
pt agv.
players remaining
Current leader
projected winner
current 2nd, projected 2nd
current high game
current high player total
projected high player total


PM me an email you want me to share it with and I will do so. Please only edit the cells I said needed editing, and please only for your team. This can be a great way to see what everyone else is doing...just dont fuck with other people teams lol.


I do have a master copy in case someone edits all the formulas. But they took a good 8 hrs to finish...
wildcats20's avatar
wildcats20
Posts: 27,794
Mar 17, 2014 4:55pm
OK, I think I got everything updated.
wildcats20's avatar
wildcats20
Posts: 27,794
Mar 17, 2014 5:27pm
I'm good to go as soon as Niles picks...
Laley23's avatar
Laley23
Posts: 29,506
Mar 17, 2014 5:55pm
Also, on the spreadsheet, the projections wont be correct initially until I fix the formula to match the individual seeds. Also, some of the others wont work until the cells start to fill up, but I checked almost every possibility and they should work after Thursday is complete or everyone has some points entered.
Mulva's avatar
Mulva
Posts: 13,650
Mar 17, 2014 6:16pm
2 hours is almost up.
SportsAndLady's avatar
SportsAndLady
Posts: 35,632
Mar 17, 2014 6:17pm
Niles is LVP so far
wildcats20's avatar
wildcats20
Posts: 27,794
Mar 17, 2014 6:54pm
So how are we doing this?
wildcats20's avatar
wildcats20
Posts: 27,794
Mar 17, 2014 6:56pm
I mean we're pushing 3 hours now...
Mulva's avatar
Mulva
Posts: 13,650
Mar 17, 2014 7:02pm
Well he's up again right away.

I say give him someone for now, then make your picks, and he's back on the clock. He can swap whoever we give him, but obviously the guys you take will no longer be available for him.
Laley23's avatar
Laley23
Posts: 29,506
Mar 17, 2014 7:04pm
That seems fair.
wildcats20's avatar
wildcats20
Posts: 27,794
Mar 17, 2014 7:04pm
He shouldn't be allowed to swap.
Mulva's avatar
Mulva
Posts: 13,650
Mar 17, 2014 7:06pm
Why? As long as it's with somebody who hasn't been taken, it doesn't impact anything.
wildcats20's avatar
wildcats20
Posts: 27,794
Mar 17, 2014 7:13pm
Then why even have the time limit?

I mean I just think it's dumb to allow someone to pick whoever the want after they have missed their turn.
B
birddog23
Posts: 1,086
Mar 17, 2014 7:16pm
wildcats20;1592184 wrote:Then why even have the time limit?

I mean I just think it's dumb to allow someone to pick whoever the want after they have missed their turn.
So the rest of us can continue with the draft. It's after their pick anyway when or if they want to swap
Laley23's avatar
Laley23
Posts: 29,506
Mar 17, 2014 7:16pm
It does technically matter if we give them someone who the next person wants, and they subsequently cant draft them, but then he swaps and that person is available again.

If we give him someone, thats who he should get.
Laley23's avatar
Laley23
Posts: 29,506
Mar 17, 2014 7:17pm
Ok, Im going out to get some food, have turtles text me if it becomes my turn and ill try to make a pick.

Ill also try to iron out those formulas that are fucked. PC at work and MAC at home...some reason it alters stuff differently.
Mulva's avatar
Mulva
Posts: 13,650
Mar 17, 2014 7:17pm
wildcats20;1592184 wrote:Then why even have the time limit?

I mean I just think it's dumb to allow someone to pick whoever the want after they have missed their turn.
He doesn't get to pick whoever he wants. The 2 guys you take will be off the board.

Or we could just skip him entirely. NFL draft style. He can pick whenever he gets back, but until then the draft rolls on.
SportsAndLady's avatar
SportsAndLady
Posts: 35,632
Mar 17, 2014 7:20pm
Laley23;1592186 wrote:It does technically matter if we give them someone who the next person wants, and they subsequently cant draft them, but then he swaps and that person is available again.

If we give him someone, thats who he should get.
This would be a problem. I say skip him and he can select two players when he gets back. You know the responsibilities of the draft when you sign up for this.
wildcats20's avatar
wildcats20
Posts: 27,794
Mar 17, 2014 7:21pm
Last year it was we gave someone a player and that was it.

I remember it happening a couple times.