Saturday, December 29, 2012

Best Excel Posts from 2012

As the year is about to end it's time to look back and reflect on our most popular posts from 2012, listed below, in order:

  1. Printable 2012 NFL Playoff Bracket
  2. Printable 2012 Superbowl Squares Spreadsheet
  3. 2011-2012 NHL Stanley Cup Playoff Printable Bracket
  4. Downloadable 2012 NCAA Tournament Bracket
  5. Career Advice: Make a Website
After trying a couple of different options, including ShareCash and Google Docs, I've finally settled on using www.box.com to host my Excel spreadsheets and templates to allow you to easily download them with no extra hassles.  Listed below are the top downloaded spreadsheets from the past year:

  1. 2012 NFL Helmet Schedule 8.20.12.xls
  2. 2012 NCAA Helmet Schedule.xls
  3. Expense Report Template.xls
  4. Golf Scorescard Templete.xls
  5. Give Yourself a Raise.pdf
As you can see, the sports templates are proving to be very popular and we've got some good ones on deck for 2013! Also, my project management template (that includes a free gantt chart) proved to be very popular but you'll have to signup for our email newsletter to recieve it.

Looking ahead, we plan to bring you even more and better Excel spreadsheets templates in 2013. Do you have any suggestions for the site? What do you like or don’t like? Any features you want to see more or less of?

Thanks for reading Excel spreadsheets help this past year, I really appreciate it. This blog wouldn't exsist without you! Have a happy new year and I'll see you in 2013.

-Nick

Wednesday, December 5, 2012

NCAA Football Bowl Schedule and Pool 2012

2012 ncaa bowl college football predictions pool
The NCAA college football bowl season is finally here which means it’s time to make your picks and predictions about who you think will win each game. One of the best times of the holiday season (other than giving and receiving gifts) is gathering around the TV and rooting for your favorite football team in a BCS bowl game. Make the occasion even more fun and competitive by trying to predict the NCAA football bowl games.

Use my spreadsheet template to create a college bowl pool with your friends or coworkers. Simply download the Excel file linked to below and follow the instructions included within the spreadsheet. The NCAA bowl pool also doubles as a printable college football bowl schedule. The spreadsheet is all set up and ready to go - simply make your picks and then watch the game to see who the winner is. It automatically keeps track of several different stats like how many games each person gets correct, what percentage of games you’ve picker correctly, and more!

How it Works

Altogether you do not have to enter or change any formulas or complicated functions to use the spreadsheet, I will briefly explain how it works in case you want to create your own from scratch or modify mine:

The college bowl spreadsheet uses drop down lists to allow the user to select a winning team. The number of games picked correctly is added using Excel’s SUMProduct function. Conditional formatting is used to color code correct picks from incorrect picks.

college bowl schedule 2012


Download the NCAA College Football Bowl Schedule and Pool

To download the spreadsheet simply click the link below which will take you to the box.com, where the file is hosted. Next, click on the “Download” link in the upper right hand corner. That’s it!

Download: NCAA Football Bowl Schedule 2012.xls (hosted on www.box.com)

Update 12/12/12: I uploaded a new version of the spreadsheet with a macro that automatically adds the correct number of columns and stats for the total number of players. To run the macro go to the Master Pool sheet and run the "AddPlayers" macro (by going to View>Macros>View Macros>AddPlayers>Run). After hitting run, enter total number of players into pop-up input box. Click OK then complete the rest of the template as usual.

Also, I’ve created a Google doc to start an Excel Spreadsheets Help NCAA bowl pool. To join, download the spreadsheet, make your predictions, then copy and paste your picks into my Google doc here:
https://docs.google.com/spreadsheet/ccc?key=0Av7RTFdlK3AmdFBwcHBINi1jUi1jdm1ZWTFtbWNuQkE

Final Thoughts

I’m sad to see my Buckeyes sitting on the sidelines this year (should have taken a bowl ban last year) although I’m hoping my Toledo Rockets can cap off the year with a good win. I’m a Big Ten and MAC guy so I’ll be pulling for each conference team but I have to admit I have almost no hope or confidence for any of them winning a single match up. What are your NCAA bowl predictions? What are your bowl picks? Leave a comment below and let me know! Like our Facebook page to receive notification when we post our NFL playoffs bracket and other sport templates.

-Nick
Go Rockets!