Author |
Topic: 2007 Team Draft Picks (Read 2551 times) |
|
Tony_O
Guest

Back to top
|
Hey Jeff, when you have a chance can you post the 2007 draft picks for each of the teams after last years trades? I know you keep track, so I figured it would be less work to just have you post what you think is right and let the owners correct it if there is a problem! Thanks Tony
|
|
Logged |
|
|
|
Fantasy Field General
Fmr. CBFLer Champ - '06
    
# 169
 How 'bout them Cowboys!!!
Posts: 976
Back to top
|
 |
Re: 2007 Team Draft Picks
« Reply #6 on: Jul 16th, 2007, 4:52pm » |
Quote Modify
|
Thanks Philly. One small change. Ray got my #8 and #9 so I should have 1,1,1,2,3,4,5,6,7
|
|
Logged |
|
|
|
UFF Primetime Prophet
    
# 29
 Pay, I said pay attention, son.

Posts: 5675
Back to top
|
 |
Re: 2007 Team Draft Picks
« Reply #8 on: Aug 6th, 2007, 4:04pm » |
Quote Modify
|
UPDATED 8/6/07 *Jim (The Dogs) - 12 ProtSpots - Picks: 1, 3-Tony, 4, 4-Ken, 5, 6, 6-Ray, 7, 8-Jeff *Keith (Hudson Hawks) - 12 ProtSpots - Picks: 1, 2, 3, 4, 5, 6, 7, 8, 9 *Todd (Telegoals) - 12 ProtSpots - Picks: 1, 2, 3, 4, 6, 7, 8, 9, 9-Jeff *Jeff (Amish) - 12 ProtSpots - Picks: 1, 1-Tony, 2, 2-Ray, 3-Jim, 3, 4, 4-Tony, 5-Todd *Gene (Fat Chick) - 12 ProtSpots - Picks: 1, 1-Rob, 1-Ray, 2, 3, 4, 5, 6, 7 Ken (Clowns) - 12 ProtSpots - Picks: 1, 2-Jim, 5-Jeff, 5, 6, 7, 7-Tony, 8, 9 Rob (Norsemen) - 11 ProtSpots - Picks: 2, 3, 3-Ray, 3-Cheryl, 4, 4-Ray, 5, 6, 7, 8 Tony (Phenoms) - 12 ProtSpots - Picks: 2-Ken, 2, 3-Ken, 5, 6-Jeff, 6, 7-Jeff, 8, 9 Cheryl (Silver & Gold) - 12 ProtSpots - Picks: 1, 2, 4, 5, 6, 7, 8, 9, 9-Rob Ray (Chiapets) - 13 ProtSpots - Picks: 5, 7, 8-Jim, 8-Gene, 8, 9-Jim, 9-Gene, 9
|
| « Last Edit: Aug 9th, 2007, 3:05pm by Philly » |
Logged |
|
|
|
UFF Primetime Prophet
    
# 29
 Pay, I said pay attention, son.

Posts: 5675
Back to top
|
 |
Re: 2007 Team Draft Picks
« Reply #15 on: Aug 14th, 2007, 1:32pm » |
Quote Modify
|
on Aug 14th, 2007, 1:27pm, Chumpzilla wrote: I thought the random number function generates the numbers differently each time you execute the "process" (no ascending or descending)? Therefore being random? |
| Yes, it does. What I did was type Jim's name into the first 5 cells in Column A, Keith's in the next 4, and so forth until Gene had the final cell. Then in Column B I entered =RAND() in the cells next to the names. Then I copied those cells and used Paste Values to maintain the numbers in Column C. I then deleted Column B and sorted Ascending by the new Column B. (Just for kicks, I sorted Descending too.) Either way, Jim didn't get the top pick (although he didn't fall to the bottom of the lottery this time).
|
|
Logged |
|
|
|
UFF Primetime Prophet
    
# 29
 Pay, I said pay attention, son.

Posts: 5675
Back to top
|
 |
Re: 2007 Team Draft Picks
« Reply #18 on: Aug 14th, 2007, 1:39pm » |
Quote Modify
|
on Aug 14th, 2007, 1:35pm, Philly wrote:If you just try to sort the =RAND() values, you'll never get them in order because it produces a new random number every time the cell is "touched." So I ran it one time and then copied the results and used Paste Values (to keep the number and not insert the formula) into the adjacent column. I'm sure if I ran it again, I'd get quite different results. |
| OK... just for kicks, I ran it again and got new results. High to Low: Jeff, Keith, Jim, Todd, Gene Low to High: Gene, Todd, Keith, Jim, Jeff (Still doesn't much care for Jim's claim to the 1.01 pick.)
|
|
Logged |
|
|
|
Red Zone Master
    
# 179

oh Lord, deliver us from the fury of the Norsemen!

Posts: 1045
Back to top
|
 |
Re: 2007 Team Draft Picks
« Reply #19 on: Aug 14th, 2007, 2:51pm » |
Quote Modify
|
on Aug 14th, 2007, 1:39pm, Philly wrote: OK... just for kicks, I ran it again and got new results. High to Low: Jeff, Keith, Jim, Todd, Gene Low to High: Gene, Todd, Keith, Jim, Jeff (Still doesn't much care for Jim's claim to the 1.01 pick.) |
| I'm sorry....but dat's funny roht der, Aye-unt care who yerahr.
|
|
Logged |
3 straight underperforming seasons, one nitwit head coach, 2 problem child WRs, 1 collosal trade bungle....but a wild boat party with booze and hookers!!!????? Priceless.
|
|
|
Red Zone Master
    
# 203
 "I Love The Gridiron"
Posts: 1104
Back to top
|
 |
Re: 2007 Team Draft Picks
« Reply #20 on: Aug 14th, 2007, 8:03pm » |
Quote Modify
|
on Aug 14th, 2007, 1:39pm, Philly wrote: OK... just for kicks, I ran it again and got new results. High to Low: Jeff, Keith, Jim, Todd, Gene Low to High: Gene, Todd, Keith, Jim, Jeff (Still doesn't much care for Jim's claim to the 1.01 pick.) |
|
|
|
Logged |
|
|
|
Tony_O
Guest

Back to top
|
 |
Re: 2007 Team Draft Picks
« Reply #23 on: Aug 19th, 2007, 4:42pm » |
Quote Modify
Remove
|
on Aug 6th, 2007, 4:04pm, Philly wrote:UPDATED 8/19/07 *Jim (The Dogs) - 12 ProtSpots - Picks: 1, 3-Tony, 4, 4-Ken, 5, 6, 6-Ray, 7, 8-Jeff *Keith (Hudson Hawks) - 12 ProtSpots - Picks: 1, 2, 3, 4, 5, 6, 7, 8, 9 Todd (Telegoals) - 13 ProtSpots - Picks: 1, 2, 3, 6, 7, 8, 9, 9-Jeff *Jeff (Amish) - 12 ProtSpots - Picks: 1, 1-Tony, 2, 2-Ray, 3-Jim, 3, 4, 4-Tony, 5-Todd *Gene (Fat Chick) - 12 ProtSpots - Picks: 1, 1-Rob, 1-Ray, 2, 3, 4, 5, 6, 7 Ken (Clowns) - 12 ProtSpots - Picks: 1, 2-Jim, 5-Jeff, 5, 6, 7, 7-Tony, 8, 9 Rob (Norsemen) - 11 ProtSpots - Picks: 2, 3, 3-Ray, 3-Cheryl, 4, 4-Ray, 5, 6, 7, 8 Tony (Phenoms) - 11 ProtSpots - Picks: 2-Ken, 2, 3-Ken, 4-Todd, 5, 6-Jeff, 6, 7-Jeff, 8, 9 Cheryl (Silver & Gold) - 12 ProtSpots - Picks: 1, 2, 4, 5, 6, 7, 8, 9, 9-Rob Ray (Chiapets) - 13 ProtSpots - Picks: 5, 7, 8-Jim, 8-Gene, 8, 9-Jim, 9-Gene, 9 |
| Just updated this to reflect trade!
|
| « Last Edit: Aug 19th, 2007, 4:44pm by Tony_O » |
Logged |
|
|
|
|