Controlled Chaos Posted August 14, 2009 Share Posted August 14, 2009 If any of you run a live draft. I have a pretty good spreadsheet to keep track of things. We usually have ours at a bar or something and I hook my lappy in to one of the tv's there. Everyone can see their picks. If interested I can email it to you. Quote Link to comment Share on other sites More sharing options...
Chisoxfn Posted August 14, 2009 Share Posted August 14, 2009 Ya, shoot that over. [email protected] Quote Link to comment Share on other sites More sharing options...
kapkomet Posted August 15, 2009 Share Posted August 15, 2009 [email protected]. Shoot it my way. Quote Link to comment Share on other sites More sharing options...
BigSqwert Posted August 15, 2009 Share Posted August 15, 2009 I tried creating one last year and it was so-so. A lot of guys didn't like that you had to scroll to see the entire board. I used the smallest possible font and formatted to fit as much into the screen at once but it still needed to be scrolled. We just ordered a draft board so it's too late to run with yours but I'd still like to see if you came up with a better idea. Can you shoot it over to me? Thanks! [email protected] Quote Link to comment Share on other sites More sharing options...
Controlled Chaos Posted August 17, 2009 Author Share Posted August 17, 2009 QUOTE (BigSqwert @ Aug 15, 2009 -> 10:54 AM) I tried creating one last year and it was so-so. A lot of guys didn't like that you had to scroll to see the entire board. I used the smallest possible font and formatted to fit as much into the screen at once but it still needed to be scrolled. We just ordered a draft board so it's too late to run with yours but I'd still like to see if you came up with a better idea. Can you shoot it over to me? Thanks! [email protected] Yeah, I don't think you will ever see an entire board on a spreadsheet...it would be too small. The thing I really want to know is who has picked which positions and I have that tracking at the top. I find that pretty valuable in determining if I can wait an extra rd before making a pick. You can see almost 3 rounds at a time on this and if a player is picked twice it will highlight both names...I wanted to make it scream IDIOT at that point, but figured it was overkill. Quote Link to comment Share on other sites More sharing options...
BigSqwert Posted August 17, 2009 Share Posted August 17, 2009 QUOTE (Controlled Chaos @ Aug 17, 2009 -> 09:04 AM) Yeah, I don't think you will ever see an entire board on a spreadsheet...it would be too small. The thing I really want to know is who has picked which positions and I have that tracking at the top. I find that pretty valuable in determining if I can wait an extra rd before making a pick. You can see almost 3 rounds at a time on this and if a player is picked twice it will highlight both names...I wanted to make it scream IDIOT at that point, but figured it was overkill. Looked it over just now. Nice job! Quote Link to comment Share on other sites More sharing options...
ChiSox_Sonix Posted August 17, 2009 Share Posted August 17, 2009 That's f***ing awesome. Thanks for sending it to me. I use excel a ton and consider myself extremely proficient but even I had a difficult time trying to follow all the formulas. Great job Quote Link to comment Share on other sites More sharing options...
kapkomet Posted August 17, 2009 Share Posted August 17, 2009 CC - did you send this to all in the thread who've requested it? Quote Link to comment Share on other sites More sharing options...
Controlled Chaos Posted August 17, 2009 Author Share Posted August 17, 2009 QUOTE (kapkomet @ Aug 17, 2009 -> 09:11 AM) CC - did you send this to all in the thread who've requested it? I believe so. I sent it to you this morning. oops one thing I noticed and it isn't a big deal, but I usually hide the row and column headers on the picks page. Tools - Options -View - Uncheck row and column headers. Also, if you go to view full screen you will see more. Quote Link to comment Share on other sites More sharing options...
kapkomet Posted August 17, 2009 Share Posted August 17, 2009 QUOTE (Controlled Chaos @ Aug 17, 2009 -> 09:28 AM) I believe so. I sent it to you this morning. oops one thing I noticed and it isn't a big deal, but I usually hide the row and column headers on the picks page. Tools - Options -View - Uncheck row and column headers. Also, if you go to view full screen you will see more. That's great! I just didn't give my email enough time to catch it coming in. Thank you for this! Quote Link to comment Share on other sites More sharing options...
Controlled Chaos Posted August 17, 2009 Author Share Posted August 17, 2009 QUOTE (ChiSox_Sonix @ Aug 17, 2009 -> 09:11 AM) That's f***ing awesome. Thanks for sending it to me. I use excel a ton and consider myself extremely proficient but even I had a difficult time trying to follow all the formulas. Great job Thanks. I can't take all the credit though. I tweaked somebody else's sheet I found online a few years ago. Quote Link to comment Share on other sites More sharing options...
AssHatSoxFan Posted August 17, 2009 Share Posted August 17, 2009 I'd like to check this out myself, it probably is more useful than one's I have made in the past [email protected] Quote Link to comment Share on other sites More sharing options...
Middle Buffalo Posted August 17, 2009 Share Posted August 17, 2009 QUOTE (Controlled Chaos @ Aug 17, 2009 -> 07:04 AM) The thing I really want to know is who has picked which positions and I have that tracking at the top. I find that pretty valuable in determining if I can wait an extra rd before making a pick. This is probably the most important thing that you should know during a draft. I'm in two leagues, and I'd bet that half of the guys in each league don't pay attention to the other teams' rosters. Knowing what the other teams need allows you to skip players that you're sure will be available when the draft comes around to your next pick. Quote Link to comment Share on other sites More sharing options...
Nixon Posted August 17, 2009 Share Posted August 17, 2009 hit me! alt0782 at gmail with the dot com. Quote Link to comment Share on other sites More sharing options...
BigSqwert Posted August 17, 2009 Share Posted August 17, 2009 QUOTE (Nixon @ Aug 17, 2009 -> 02:15 PM) hit me! alt0782 at gmail with the dot com. Oh so you're the one that took my first email address choice with gmail. Now I'm stuck with alt0783. Quote Link to comment Share on other sites More sharing options...
TheBlackSox8 Posted August 17, 2009 Share Posted August 17, 2009 have a couple drafts coming up, i'd like to see the goods your selling.... [email protected] Quote Link to comment Share on other sites More sharing options...
AssHatSoxFan Posted August 21, 2009 Share Posted August 21, 2009 OMG what am I going to do now that Favre and Vick are back in the NFL and aren't on the list?!!!?!? Quote Link to comment Share on other sites More sharing options...
Controlled Chaos Posted August 21, 2009 Author Share Posted August 21, 2009 QUOTE (AssHatSoxFan @ Aug 21, 2009 -> 07:48 AM) OMG what am I going to do now that Favre and Vick are back in the NFL and aren't on the list?!!!?!? You can be smart and NOT draft them!! If you do want to add them though, I have the players sheet protected, but there isn't a password on it. Just go to unprotect and add them in if you want. Quote Link to comment Share on other sites More sharing options...
ChiSox_Sonix Posted August 21, 2009 Share Posted August 21, 2009 QUOTE (Controlled Chaos @ Aug 21, 2009 -> 04:39 PM) You can be smart and NOT draft them!! If you do want to add them though, I have the players sheet protected, but there isn't a password on it. Just go to unprotect and add them in if you want. It actually wasn't protected in the one you sent me. It's a multi-step process if you want to add players though. You need to go into the main page with the selection and unfreeze the panes, unhide the rows above and add the players there too. Quote Link to comment Share on other sites More sharing options...
Controlled Chaos Posted August 10, 2010 Author Share Posted August 10, 2010 (edited) I have the updated sheet for 2010 and uploaded it here if anybody's interested. Fantasy Football Draft 2010.xls Edited August 10, 2010 by Controlled Chaos Quote Link to comment Share on other sites More sharing options...
Controlled Chaos Posted August 26, 2010 Author Share Posted August 26, 2010 QUOTE (Controlled Chaos @ Aug 10, 2010 -> 03:44 PM) I have the updated sheet for 2010 and uploaded it here if anybody's interested. Fantasy Football Draft 2010.xls Tilted Kilt had a good draft deal if anyone is interested. 10 bucks a person. Everyone gets 2 drinks and they bring out 3 appetizer samplers and 4 big nacho plates with all the different sauces to dip in. They let me hook my laptop up to their tv and of course the scenery wasn't too bad. All and all a good draft. FYI - I was at the Kilt in Woodridge. Quote Link to comment Share on other sites More sharing options...
knightni Posted August 26, 2010 Share Posted August 26, 2010 QUOTE (AssHatSoxFan @ Aug 21, 2009 -> 08:48 AM) OMG what am I going to do now that Favre and Vick are back in the NFL and aren't on the list?!!!?!? QUOTE (Controlled Chaos @ Aug 21, 2009 -> 04:39 PM) You can be smart and NOT draft them!! How'd that work out for you? Quote Link to comment Share on other sites More sharing options...
Controlled Chaos Posted August 26, 2010 Author Share Posted August 26, 2010 QUOTE (knightni @ Aug 26, 2010 -> 05:08 PM) How'd that work out for you? haha...I won last year, but yeah Favre ended up being solid. Quote Link to comment Share on other sites More sharing options...
Controlled Chaos Posted August 17, 2011 Author Share Posted August 17, 2011 If anyone is interested. The viewer won't load these because I didn't convert to google docs. Just choose download and open in excel. Fantasy Football Draft 2011 10 team 18 rd.xls - https://docs.google.com/leaf?id=0B3xUoNbpvK...Q3&hl=en_US Fantasy Football Draft 2011 10 team 16 rd.xls - https://docs.google.com/leaf?id=0B3xUoNbpvK...Rm&hl=en_US Fantasy Football Draft 2011 12 team 18 rd.xls - https://docs.google.com/leaf?id=0B3xUoNbpvK...Ay&hl=en_US Fantasy Football Draft 2011 12 team 16 rd.xls - https://docs.google.com/leaf?id=0B3xUoNbpvK...Vh&hl=en_US Quote Link to comment Share on other sites More sharing options...
Controlled Chaos Posted August 15, 2013 Author Share Posted August 15, 2013 Link to current Fantasy Draft spreadsheets. You won't be able to preview, so just download and open in excel. You'll have to enable editing because I have a macro in there for a timer at the top. There is a 10 team 16rd and a 12 team 16 rd. https://drive.google.com/folderview?id=0B3x...amp;usp=sharing Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.