Saturday, December 03, 2011

2011-12 College Football Bowl Pool Spreadsheet

It seems like the first time in a few years (not sure if this is true, but it feels like it) that I don't have to modify the spreadsheets to add another game. "Just" 35 bowls again this year.

The Humanitarian Bowl has been replaced by the Famous Idaho Potato Bowl. The Texas Bowl is now called the Meineke Car Care of Texas Bowl. The old Meineke Car Care Bowl has been replaced by the Belk Bowl. Yeah...Belk. I had to look it up too. "Charlotte, N.C.-based Belk, Inc. (www.belk.com) is the nation’s largest privately owned mainline department store company with 305 Belk stores located in 16 Southern states. The company was founded in 1888 by William Henry Belk in Monroe, N.C., and is in the third generation of Belk family leadership. The belk.com Web site offers a wide assortment of fashion apparel, shoes and accessories for the entire family along with top name cosmetics, a wedding registry and a large selection of quality merchandise for the home." Okay. Anyway...the reason I even bring any of this up is that while I know that the sponsors of these bowl games spend a lot of money to get their brands out there, where convenient, I'm just going to leave the sponsor name off in the spreadsheet -- e.g. i'll just put "Music City Bowl" instead of "Franklin American Mortgage Music City Bowl". In cases where the sponsor name IS the bowl name (e.g. "Champs Sports Bowl"), I'll obviously just use that. The new "Famous Idaho Potato Bowl" i'll just call the "Potato Bowl" in the whole "Orange Bowl", "Cotton Bowl", etc., tradition.

Now that that's out of the way, here are the files:

Click here for the "Master" file used by the pool organizer. This is the one with the fancy charts and group scoring summary, etc.

Click here for the "Individual Picks" file used by each person participating in the pool. This is the one the pool organizer typically would email out to his or her participants to have them fill out to make it easier for him or her to copy paste their picks into the "Master" file.

Enjoy, everyone!

Excel_Geek

20 comments:

Will said...

is there a way to donate a couple bucks for the effort?

Anonymous said...

Thank you so much for putting this together every year. I can honestly say that it is perfect. Thanks!

Ronald Durbin said...

Thanks so much for putting this together. It is perfect! Have used it last three years and will always come back as long as you keep doing it.

Excel_Geek said...

Will, if anyone wants to donate for the effort, you can always send money to my Payal account, which uses my email: ehunzeker {at} g m a i l [dot] com. I'd also like to say that doing so, while very nice and appreciated, is totally unnecessary. This really is a labor of love for me each year.

Excel_Geek said...

Hey! How come nobody told me i had the title to the post wrong!? It was "2010-11 College Football..." instead of "2011-12...". I've got it fix now. @_0

Anonymous said...

Many thanks for doing this again. This is the 3rd year I've used your spreadsheet and it is always lots of fun. Cheers!

jmorein said...

I am looking to get the spreadsheet expanded to include more participants. Since I don't make any money off of our pool and don't really want to spend $50 of my own to get it done. I was wondering if anyone else was interested in doing the same? We could possible share the cost between a few people. If you are interested let the Excel-Geek know. They will contact me. Thanks!

Anonymous said...

Thank you so much for putting this together! This is the best spreadsheet I have ever seen. I do have one question is there an easy way to add more participants and the spreadsheet still function? Thanks!

Anonymous said...

Yes, I agree with J Morein. I may have more than 40 players interested and would be willing to share the cost to add additional players to the 4 worksheets.

Excel_Geek said...

Agrees-with-JMorein, just contact me at ehunzeker (at) gmail /dot/ c o m and I can make that happen.

Anonymous said...

How would I or could I adjust your summary spreadsheet for a 20 game bowl pool instead of 35 games? Thanks!

R1 said...

Is there to make this weighted from only 1 to 10 points on each game but if you lose those points wagered get subtracted from your total?

Excel_Geek said...

And so it begins...this is what happens every year, and every year i feel like the grumpy old Excel_Geek because I cannot possibly make every variant of a bowl pool that every other person wants. The short answer is that Excel can probably do what you're envisioning, and you're welcome to try to modify the sheet how you see fit. The sheets are protected, but not password protected. Simply unprotect them and start banging away at it. You might learn something.

Unknown said...

Hey, thanks for this! My wife's stepdad has run a bowl pool for years, and has always done everything by hand. Now, he doesn't have to! You have done a GREAT job on this.

keith addis said...

Hi,
I was having trouble pasting the picks from the bowl entry from into the master file. Can anyone help with the proper way to do this. Would be so much easier. Thanks.

zcubed said...

I am not using confidence points and all games are worth 1 point. How do I change the maximum points possible to provide a better graph?

Excel_Geek said...

Injure column A on the picks page and change all the numbers to 1s.

Excel_Geek said...

Unhide column A...

Anonymous said...

I added all the info to the master sheet i needed to and tried to save and it says that some things might be changed etc etc. what file type do i save this in? Thanks again Excel Geek this is amazing!

Excel_Geek said...

I'll assume you have Excel 2007 or 2010. Save it as either .xls ('97 compatible) or .xlsx (2007+ non-macro-enabled). That warning is nothing to worry about.