Page 1
Page 1
Started By
Message

How do you March Madness?

Posted on 3/11/15 at 1:30 pm
Posted by CubsFanBudMan
Member since Jul 2008
5067 posts
Posted on 3/11/15 at 1:30 pm
Has anyone created their own tournament scoring spreadsheet? I've been running the office pool for a few years. Since all of the regular fantasy sports sites are blocked at work, I created an Excel file to do the scoring as well as some reports that I modeled off of Turbo Tourney. Being that I use if formulas to do the scoring, it's important that all of the entries have the school names spelled perfectly. I usually send out an excel file with a blank bracket with boxes to mark the picks and the names will flow through. I then have to copy all of the completed brackets into my scoring file.

There are 2 things I'd like to improve on this year if possible. First, I'd like to be able to be able to use a google docs form for the pics. I just don't think there's a way to make question #3 dependent on the selections from questions #1 & #2.

Next, I'd like to set up a web query or some way for the excel file to pull in the scores. I was thinking of having a tab with the scores, then a vlookup to get them into the master bracket. Does anyone know of a website that is formatted in a way that would make this easy? Since all of the money goes into the pot, I'm looking for a free solution. That's why I don't just use Turbo Tourney.
Posted by LSUzealot
Napoleon and Magazine
Member since Sep 2003
57656 posts
Posted on 3/11/15 at 3:17 pm to
That sounds like one helluva excel project to have your bracket thrown in the garbage after day 2.
Posted by GeauxColonels
Tottenham Fan | LSU Fan
Member since Oct 2009
25604 posts
Posted on 3/11/15 at 8:15 pm to
I run a bracket and track it in Excel. I make everyone turn in hand filled brackets and I transpose those into my Excel spreadsheet for tracking and scoring.
Posted by CubsFanBudMan
Member since Jul 2008
5067 posts
Posted on 3/11/15 at 11:07 pm to
The first year I did it, it was a helluva project. This is the 3rd year, so now it's just little tweaks to improve things. One good thing about the project, it helped me showcase my excel skills across the company. Now I'm known as the excel guru.

I think I've found a good website to do a web query to get the scores. I'm testing it out with the SEC tourney, and day 1 worked good. I will have the web query auto-refresh every minute. The next step is figuring out how to have the excel file auto-save every few minutes. The plan is to leave the file open with auto-refresh/auto-save to my dropbox folder. Then give out the dropbox link to everyone to be able to view current standings. Last year I would manually enter the scores and save to dropbox, so if I didn't have access to the file for a while, then the standings wouldn't get updated right after a game ended.
first pageprev pagePage 1 of 1Next pagelast page
refresh

Back to top
logoFollow TigerDroppings for LSU Football News
Follow us on Twitter, Facebook and Instagram to get the latest updates on LSU Football and Recruiting.

FacebookTwitterInstagram