2011 March Madness Bracket is Here!

Looking for 2014 brackets? Check here.

Ok, people. Here they are -- this year's March Madness Bracket spreadsheets. Again, there's a Master sheet for the organizers of pools, as well as a Participant version, just for people to make their picks and send them to the organizer.

Master File

Participant File

Once you've downloaded the Master file and open it (make sure you've got Macros enabled), it'll prompt you to send me a "Lock Code". When you do, I'll send you back a "Key Code" to unlock the file for use. Before I send you this code, however, you'll need to pay the $2.00 price tag.

Incidentally, it took me a bit longer that I'd planned to get these out because I was caught a bit off-guard by the NCAA's use of the four play-in games. I'd ASSUMED (yes, I know what ASSUMING can do.) that each of the four play-in winners would be the 16 seed for each of the respective quarter brackets -- EAST, WEST, SOUTHWEST, and SOUTHEAST. This was not the case, though. Two of the play-in game winners will effectively be 16 seeds (EAST & SOUTHEAST), one an 11 seed (SOUTHWEST), and one a 12 seed (EAST). If you didn't catch that, yes the EAST quarter bracket has two play-ins, meaning that the WEST has none. Very odd, I thought.

As always, let me know if you've got questions.

Insiders, if you need a Key Code, let me know. It's part of your subscription.

Happy March Madness, everyone!

Later,

Excel_Geek

Wait until this evening to download this year's March Madness spreadsheet

In an effort to try to stem the many emails, instant messages, etc., that I'll get today as people are looking for this year's version of the ExcelGeek.com March Madness Spreadsheet, let me just say this:

After all of the tournament selections have been made, and the bracket has been laid out by the Selection Committee, I'll post the two spreadsheets -- one for individual participants and the other for pool organizers. That will be late this evening.

For those of you who've decided to pay the $2.00 in advance, you'll still have to wait for the files to be posted. I plan to email you, if you've paid in advance, when the files are available. Then, when you open the "master" spreadsheet (supposing you've got your macros properly enabled), you be given a "lock code". Send this to me via email (address you may already know, but if not, it's provided in the file), and I'll send you back the associated "key code" to give you access to the content of the file.

Now...back to updating those files...

Heat Charts are so easy in Excel 2007

Before you roll your eyes and say, "Welcome to life after 2003, Excel_Geek," let me just say, "I know, I know." The driver for this project was that I was analyzing my website traffic using my Google Analytics account. I noticed a few things.

One was that "heat chart" or "heat charts" seems to be a pretty popular search term for folks to find me. I've obviously done a couple of heat chart projects, but back when I was still using 2003, so in order to create them with more than four colors (the limit to Conditional Formatting in 2003), I had to do write some VBA code to accomplish it.

Another thing I noticed what the rhythmic up and down of my site traffic. There were a few major spikes -- March Madness season, college football bowl game season, and one recently when @MSExcel mentioned me in their Twitter feed. What I wanted to further analyze, though, was if there was any pattern to traffic patterns based on Day of Week and recency of blog posts.

I combined these two findings and decided to do a heat chart incorporating both Day of Week and recency to blog posts. Here's what the chart itself looks like:



Along the way I used some other favorite techniques along the way: indexing the data (so I'm not sharing my actual web stats...hey, that's my business), a trick to convert a list of dates into a list of days of the week, VLOOKUP using TRUE instead of FALSE (whatever for? right?), and using SUMPRODUCT to create COUNTIFS and SUMIFS functions that will be backward compatible to Excel 2003 and earlier. I highlighted the creation of the heat chart and these other techniques in the source file, which I'll be sharing with my Insiders Subscribers.

Later,

Excel_Geek

2011 March Madness Bracket is coming soon

Mark your calendars, folks. March 13th is Selection Sunday. In what has now become a five year tradition, I'll be releasing the ExcelGeek.com March Madness Bracket spreadsheet late that evening, once the picks are known.

In years past I've charged $3 for the "Master" version of the sheet -- the one for the organizer of your office pools, etc. I used the opportunity to showcase (read: show off) a system I've developed for locking down and protecting, then individually licensing access to my spreadsheets. I plan to keep it locked down (damn, right?), but I'm dropping the price for the Master Spreadsheet to $2. Once you pay via PayPal and send me the "Lock Code" given to you by the spreadsheet once you open it (and have your Macros enabled properly), I'll send you the "Key Code" to gain access.

Can't wait...

Excel_Geek

Updated: Parse Google Search Results for First URL

Those of you who've been following me for some time may know that I've done quite a few projects related to parsing Google search results for various data -- URLs, number of results, etc. Those of you using the code likely know that some time ago Google apparently made some changes to how they put together their site causing my stuff to stop working. Well, recently one of the requesters of one of these projects - one that returns the first non-paid URL returned - came back and had me update it to work with how Google's site currently displays search results.



This time I made it into a user-defined function. You simply enter the function...



=getFirstGoogleResultURL(A2), where the value of cell A2 is the search term.


It works pretty slick, but know that Google will not allow this sort of thing to be used on large volumes of searches. I'm pretty sure they'd much rather have you using their APIs for this sort of usage.

Excel_Geek Insiders subscribers, your copy of this file is on its way.

Later,

Excel_Geek

Introducing Gadi, My First ExcelGeek.com Contributor

Everyone,



I'd like to introduce you to Gadi Bizinyan.




Gadi is originally from Isreal, but is currently working in Bangkok, Thailand. Gadi's got a Bachelor's degree in Economics and Business Administration and really got into Excel as part of that curriculum. His self-described specialties in Excel are creating dynamic databases, manipulating data, analyzing statistically and graphically, and financial analysis.



Something you may be surprised to learn is that Gadi's been helping me for some time now. Some $50 Projects and some Private Projects have been his handywork. Remember, I've got a full-time "real job" as Director of Sales for Stanley Healthcare Solutions, so I cannot dedicate nearly as much time to this overgrown hobby as I'd like. Gadi's helping me to continue to help people in need and do some neat projects. Gadi's also going to begin contributing posts to the blog, too. Please welcome him and pretend you like his stuff as much as mine. ;-)



Welcome aboard, Gadi!

2010-11 College Football Bowl Pool Spreadsheet

Looking for the 2011-12 files? Go here.

Okay, folks. You've waited long enough. Here's this year's college football bowl pool sheet:



2010-11 Bowl Pool Summary Sheet



And here's the individual picks sheet you can pass around to those participating in your pool to copy-paste their picks back into the Summary sheet file (just remember, Copy --> Paste Special... --> Values is your friend):



2010-11 Bowl Pool Individual Picks Entry Sheet



As always, if you find any issues, please let me know. If you've got a cool idea for an enhancement, do the same.



Enjoy,



Excel_Geek