Sunday, December 29, 2013

Printable 2014 NFL Playoff Bracket

The 2013-2014 NFL Playoffs are set to begin on Saturday, January 4 six days after the end of the crazy 2013 regular season. Two games will be played Saturday, January 4 and two games will be played Sunday, January 5. Second round games will be played Saturday and Sunday, January 11 and 12. Third round games will be played Sunday, January 19. The NFL Super Bowl will be played Sunday, Febuary 2nd.

2014 nfl playoff bracket

I've create a printable bracket for the 2014 NFL playoffs with helmets that you can download for free and use in your office pools. As a bonus, I've also included the complete 2013-2014 NFL Postseason Schedule within the bracket spreadsheet, including kickoff times and broadcast stations. Download the file below (hosted on box.com).







If you enjoy this spreadsheet, please use the share buttons to send to your family, friends, and coworkers. Also, be sure to check back after the playoffs are over and I’ll be posting my Superbowl squares spreadsheet.


Saturday, December 21, 2013

Top Excel Help Posts in 2013 and 2014 Goals

2013 is coming to a close so it’s that time of year to sit back and reflect about what transpired this past year and what is to come. I’m going to share my most popular Excel tips from the past year, my most popular Excel templates, and finally share what my goals and vision for next year is.

Top 5 Excel Tips from 2013

 
Listed below are the five most popular Excel tips I published on the Excel Help blog throughout 2013:
 
 

Top 5 Excel Templates from 2013

 
Listed below are the top 5 most popular free Excel templates and spreadsheets I created and made available to download in 2013:
 
 

Goals for 2014



I recently took a poll of my loyal followers by asking them what they would rather see more of on the blog: spreadsheet templates or tips/tricks/macros to improve spreadsheet creation efficiency? My most recent posts have primarily been spreadsheet templates I’ve made available to download for free, such as my newborn feeding schedule, college bowl prediction pool, etc. Something I’ve gotten away from lately is posting tips and macros to improve your Excel efficiency, like my earlier posts on how to create folders automatically, how to create hatching in Excel, etc.


The majority of my reader’s responses asked for more tips, tricks, and macros to improve Excel efficiency. I will still be creating and posting templates as I have been because I think a lot of people find them to be quite useful and you may pick up a few tips just by looking at them and examining the formulas I use. However, I promise to make a strong effort to post more tips and macros, especially for my email subscribers. In fact, I already have several rough drafts already written and am working on some new video tutorials. What would you like to see more of in 2014? Anything specific?


Have a great holiday season, thanks for your continued support, and see you in 2014!!!





Sunday, December 8, 2013

2013 College Bowl Pool Spreadsheet

The NCAA college football bowl season is here again 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 alma mater or hometown football team.




2013 College Bowl Pool Spreadsheet


Upgrades from last year’s college football bowl pool manager spreadsheet include:
  • New easy method to make each bowl game worth a different point value
  • New leaderboard tab and stats
  • New entry sheet to pass out to participants/co-workers
  • Manager copies and pastes participants picks into the bowl pool manager file (will be automated with a macro sometime soon)
  • Complete NCAA college football bowl schedule with game times and TV station
  • The bowl prediction sheets include the football helmet designs for every team, their win-loss record, and the logo for all 35 bowl games. I added the helmets so those players who aren't big college football fans can pick a winner based on their favorite helmet design!

The beauty of this football bowl manager is you will not have to change or modify any formulas yourself (unless you want to of course).  Instructions are included within the Excel file and shows you exactly how to manually add more players. But if you were wondering about the nuts and bolts, my spreadsheet uses the rank without ties formula:
=RANK(num, ref) + COUNTIF(range,num)-1

To download the college bowl pool spreadsheets 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!


2013 College Football Bowl Pool Manager.xls download (updated 12-9)
2013 College Football Bowl Prediction Entry Form.xls download (updated 12-9)


Please let me know if you have any questions, comments, find any bugs, or have any suggestions for improvement. If you like this spreadsheet then check out our NCAA Helmet Schedule spreadsheet. What team are you rooting for?

2015 College Football Bowl Prediction Pool