[FF]: 2014 Season Long Fantasy FIRST

[MARS_James]

Springside random:

3974
2234
204
2016
1712
1218
4342
2539
4575
203
486
1495
357
5181
365
11
2495
3929
4637
56
316
1168
321
2180
423
304
222
433
293
484
5080
4454
225

EDIT:
I NEED lists from
Awesome blossom
Sour Patch Nerds
Prestige Tacos
Deus X
LtownThrowdown
Team Spark (I have the doc but it does not appear to go as far as we are now)
Rush27 (I have your link but the list is blank)

[Koko Ed]

December 5 St. Louis, Eastern Washington
December 6 Tech Valley, Mount Vernon
December 7 Wisconsin, Clifton
December 8 Boilermaker, West Michigan
December 9 Montreal, Waterloo
December 10 Arizona, Wilsonville
December 11 Los Angeles, Rhode Island
December 12 Virginia, Shorewood
December 13 Hawaii, Seneca
December 14 Greater Pittsburgh, Northeastern
December 15 FLR, Long Island
December 16 Washington DC, Livona
December 17 North Bay, Traverse City
December 18 North Star, 10000 Lakes
December 19 Peachtree, St. Joseph
December 20 Queen City, Auburn
December 21 Oklahoma, Central Washington
December 22 Smoky Mountains, Hartford
December 23 SVR, Bridgewater-Raritan
December 24 Israel, Troy
December 26 South Florida, Bedford
December 27 Colorado, Pine Tree
December 28 Bayou, Southington
December 29 Chesepeake, Oregon State University
December 30 NYC, Buckeye
January 1 Lone Star, Sacramento
January 2 Western Canadian, (Great Lakes Bay Region)
January 3 Windsor Essex, (Waterford)
January 4 Las Vegas

[BrennanB]

Originally Posted by EricH

My apologies for having to suspend the San Diego draft tonight, and thanks for your patience with getting the draft going again.


As some consolation, the setup portion of the draft-running program is now uploaded to CD-Media. Be sure to enable your macros and load your lists--and I expect you guys to try and break it a bit.

http://www.chiefdelphi.com/media/papers/2881

Hey... I just realized we have a problem... After downloading Eric's excel doc, the when you load the lists and such the exact same draft order is made every single time... I thought I would investigate due to over 25% of our drafts, us having a first pick. (Though not everyone uses Eric's doc) The doc works perfectly otherwise though...

Drafts affected are:

Springside 1

Springside 2

Hub City 1

Hub City 2

Northern Lights 1

Northern Lights 2

North Carolina 1

North Carolina 2

How shall we fix this? Just use the old way of randomising for now... but it doesn't seem particularly fair that we (Breakfast Company) are continually getting first picks like that, while RUSH always gets last picks :/ Though it's good that this was caught early.

[Akash Rastogi]

Wow surprised nobody caught that till now.

Definitely use old method for now

[Koko Ed]

3862
1182
2978
5326
4187
1178
1658
4404
4154
4931
2665
1288
3330
4028
3284
2408
4600
2838
3885
5176
4246
1329
4329
3792
4356
1501
1444
1706
2783
4330
4156
4500
3397
1985
4331
5147
3868
2902
4232
4256
5060

[BrendanB]

Who is doing the Eastern Washington draft? Trying to figure out who to send our list to.

Thanks!

[BrennanB]

I can do it I suppose.

[BrennanB]

East Washington Randoms:

4652
2148
2557
4082
4120
4726
3876
3575
4495
4513
2944
4980
4125
4015
1983
3586
4014
3711
1595
3693
3220
2923
5111
4608
360
2926
3789
2149
2147
3995
4061
3831

I have lists from:

Team Flippin' The Greatest
Team 3
The Breakfast Company
Team Hindsight
PureMichigan
The Fighting Calculators
LTown Throwdown
Team Spark
Automated Scoring
Peach Alliance
Curiosity

[EricH]

Originally Posted by BrennanB

Hey... I just realized we have a problem... After downloading Eric's excel doc, the when you load the lists and such the exact same draft order is made every single time... I thought I would investigate due to over 25% of our drafts, us having a first pick. (Though not everyone uses Eric's doc) The doc works perfectly otherwise though...

I'll check on that. It should give a different order every time. Unless... I'll check that too. (I think I know what's goin' down.)

[BrennanB]

Originally Posted by EricH

I'll check on that. It should give a different order every time. Unless... I'll check that too. (I think I know what's goin' down.)

The random function works, it's just that the first time you press generate right after downloading the doc, it always comes out with the same random list.

[Koko Ed]

Originally Posted by Koko Ed

LTownThrowdown has missed the last three draft.
If they manage to miss tomorrow night's draft they will receive a warning PM from the commissioner (me).

Got LTown Throwdown's list so that crisis is adverted but I now have two other team (both who are leading both of my drafts) who if they do not participate tonight will be sailing into dangerous waters.

[JosephC]

Originally Posted by Koko Ed

Got LTown Throwdown's list so that crisis is adverted but I now have two other team (both who are leading both of my drafts) who if they do not participate tonight will be sailing into dangerous waters.

Deus X has missed pretty much all my recent drafts as well.

[Koko Ed]

Originally Posted by JosephC

Dues X has missed pretty much all my recent drafts as well.

He's gonna need a talking to really soon as well as the boys on Team Awesome Blossom.

[EricH]

Originally Posted by BrennanB

Hey... I just realized we have a problem... After downloading Eric's excel doc, the when you load the lists and such the exact same draft order is made every single time... I thought I would investigate due to over 25% of our drafts, us having a first pick. (Though not everyone uses Eric's doc) The doc works perfectly otherwise though...

Originally Posted by EricH

I'll check on that. It should give a different order every time. Unless... I'll check that too. (I think I know what's goin' down.)

Awright, I ran some testing. And I have a solution (the problem wasn't quite what I thought). But first, the testing method:

I ran the generator 10 times without closing Excel or clearing data. 7 different players got first pick, possibly 8. The first two were Breakfast Company.

Then I ran the generator 10 times, clearing the draft between runs. (Actually 11 times, but I think I forgot to clear once.) 8 different players got 1st pick.

Then I closed and opened Excel to generate drafts. I was going to do 10, but after 5, the pattern was clear. Breakfast Company, BTW.

Then I tried clearing the draft before closing. Didn't help.

But, there is a simple fix. I've used it before when manually generating drafts on occasion (Ed, if you remember a couple years back when Hallry kept getting 1st picks... I did use this once or twice... and I've used it against myself, too).

If you use my spreadsheet to generate drafts, you need to generate the draft 2-3 times--or roll a die and generate that many times. I think Excel's starting random number is 14, which happens to be Breakfast Company's position in the list. Guess what, they get a lot of 1st picks.

I will be thinking of a fix over the weekend, maybe sooner. It'll probably involve tripping the random number generator some random number of times before starting to use its numbers. I'll announce when it's fixed and published. I'll probably do a little bit of development--I found something by accident that could make my life MUCH simpler, and should be a quick add (famous last words, right, programmers? ) before the release, maybe make life a little easier.

[Koko Ed]

Originally Posted by Koko Ed

Got LTown Throwdown's list so that crisis is adverted but I now have two other team (both who are leading both of my drafts) who if they do not participate tonight will be sailing into dangerous waters.

Looks like TeamRush is also heading into rough waters as their lists are blank after I already told them once to fix the problem.
You guys are really testing my patience.