- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
re: How do you March Madness?
Posted on 3/11/15 at 3:17 pm to CubsFanBudMan
Posted on 3/11/15 at 3:17 pm to CubsFanBudMan
That sounds like one helluva excel project to have your bracket thrown in the garbage after day 2.
Posted on 3/11/15 at 11:07 pm to LSUzealot
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.
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.
Popular
Back to top
Follow TigerDroppings for LSU Football News