Fantasy Football Draft Board Tracking

Posted Mon, Aug 31 2009 13:41 by Nate Oliver

People use Excel for a lot of different things, accounting, engineering, statistical work, etc... Yesterday, a friend asked for help with formatting projected player stats to manage her fantasy draft. I'm attaching the file, there is no VBA.

This file isn't extremely refined, as I only spent a few minutes on it. But what it allows you to do is scratch players off the main board, and then quickly scan who remains, by position. And of course you can add Worksheets to compile your draft, add comments, etc.. The projections aren't mine, they come from:

http://www.fftoolbox.com/index.cfm

So, obviously feel free to disagree with them. Go into the Overall Worksheet, change the Drafted Column (I), there's a drop-down. Notice the formatting flow to other Worksheets.

You might notice my SumProduct() function appears to be working harder than it should. When I received the data, the trailing spaces in the players names on the main board did not always match the individual Worksheets, and it was easier for me to approach that problem as such versus cleansing the data.

So, perhaps this will help you manage your FF draft. And as huge football fan, enjoy the season! Oh, and go Vikings!!

Comments

# re: Fantasy Football Draft Board Tracking

Monday, August 31, 2009 8:18 PM by Jeff

Cool post Nate!   Go football season!   I like the new blog layout too.   Very aesthetic.  

Trimming spaces can be a real pain but necessary part of living in a word of strings.   In C# I almost always do "string.Trim().toUpper()" before comparing.

# re: Fantasy Football Draft Board Tracking

Tuesday, September 01, 2009 2:11 PM by Nate Oliver

Good point, Jeff - Sharepoint guru. I'll force the case, too, if I suspect there could be an issue. In this case, the casing looked alright, so I didn't add that extra overhead.

What Jeff is saying is that String comparison can be tricky, partial matches don't work - one needs to be the exact same as the other, which sometimes requires a bit of trickery.

This is where the human eye beats the computer by a long shot - we can see they're the same. A computer needs to see them as the exact same.

# re: Fantasy Football Draft Board Tracking

Thursday, September 03, 2009 9:24 AM by Mike M.

Funny...I pulled in data from the same website for my own draft, but since I wasn't planning on taking a laptop, I didn't create the fancy spreadsheet.  If I would have seen this before 6:00 last night, I would have taken my laptop.  I hate trying to find someone's name to cross off on paper.

Here's to saving the file and hoping I remember that I have it this time next year.

Thanks, Nate.

# re: Fantasy Football Draft Board Tracking

Thursday, September 03, 2009 12:26 PM by Nate Oliver

You're welcome.

I'll probably put a new one, next year, earlier - updated players, projections, etc... That shouldn't take too long, actually.

Did anyone in your draft have a laptop? Could psych out the competition!

# re: Fantasy Football Draft Board Tracking

Friday, September 04, 2009 11:21 AM by Mike M.

Nope...no laptops.  In this day and age, you'd think someone (read: the Commissioner) could find somewhere with at least Wi-Fi.

# re: Fantasy Football Draft Board Tracking

Friday, September 04, 2009 12:06 PM by Nate Oliver

It's funny you should mention WiFi.

I was thinking if I really ramp this thing up, and show people how to set up a secure, virtual WAN, with oh, say Groove:

technet.microsoft.com/.../cc261835.aspx

Where multiple people could securely modify the Workbook at the same time, from anywhere...

That might be useful in some very non-trivial circumstances.

# re: Fantasy Football Draft Board Tracking

Monday, September 07, 2009 10:01 AM by poker rakeback

Once my fantasy draft got out of the 5th or 6th round last night it became difficult for people to keep track of who was picked.  I think coming up with more tools to eliminate some of the hassle with the draft and scoring will be a great asset.

Leave a Comment

(required) 
(required) 
(optional)
(required)