2014 NCAA Tournament Player Pick Em - DRAFT

• Azubuike24

  

  Haha, I'm really distracted today. Kendall Williams, New Mexico.
• Terry_Tate

  

  Cory Jefferson, Baylor
• Laley23

  

  Wizurhd takes Hield Oklahoma
• Terry_Tate

  

  Laley23;1592149 wrote:Wizurhd takes Hield Oklahoma

  Wizurhd is on it, was debating between him and Jefferson.
• Laley23

  

  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

  

  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

  

  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

  

  OK, I think I got everything updated.
• wildcats20

  

  I'm good to go as soon as Niles picks...
• Laley23

  

  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

  

  2 hours is almost up.
• SportsAndLady

  

  Niles is LVP so far
• wildcats20

  

  So how are we doing this?
• wildcats20

  

  I mean we're pushing 3 hours now...
• Mulva

  

  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

  

  That seems fair.
• wildcats20

  

  He shouldn't be allowed to swap.
• Mulva

  

  Why? As long as it's with somebody who hasn't been taken, it doesn't impact anything.
• wildcats20

  

  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.
• birddog23

  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

  

  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

  

  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

  

  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

  

  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

  

  Last year it was we gave someone a player and that was it.
  
  I remember it happening a couple times.