NFL Playoff Schedule 2013: Template

Showing posts with label Template. Show all posts

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.

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?

Sunday, November 24, 2013

Newborn Feeding Schedule Spreadsheet Template

I am happy to announce I am now a proud father! I'm never been so tired yet so happy in my entire life! While at the hospital we had to keep a Newborn Feeding and Diaper Log. As soon as we got home and the baby was napping I decided to recreate the log as a usable spreadsheet and have made it available to all you other new parents for free. Use the log to keep track of feeding and diaper changing times; whether it was breastfeeding or bottle; if it was just urine or stool plus any other notes and observations. Keeping track of your baby's feeding and changing schedule is a great way to make sure they are growing and thriving as they should be. Take the log to your doctor's office during checkups and you won't have to rack your brain to remember any of these details.

Newborn Feeding Schedule Spreadsheet Template

Newborn Feeding Schedule Template.xls download

I suggest printing it off and keeping a copy next to the changing table or rocking chair like I have. I just can’t wrap my head around how something so small creates so much poop! Thank goodness I signed up for Amazon Mom and setup a weekly diaper delivery at a discounted rate. Download my newborn checklist for new parents and other spreadsheets related to health, babies, parenting, and more.

Monday, September 23, 2013

How to Combine Excel Files

There have been countless times during my day job when I’ve had to combine multiple Excel files into one. I used to do it the old fashioned way of copy and paste but after doing this tedious and time consuming task I decided to write a VBA macro to help me out. I’ve now made the template available for you to use for free. This version of the combine Excel workbooks macro allows you to choose the directory of the Excel files to copy without having to change the code in the Visual Basic Editor. The steps to use the Combine Workbooks tool are as follows:

Place the Excel workbooks you want to combine into a single folder that contains no other files
Go to View>Macros
Select "Combine Workbooks" then click Run
Select the File where the spreadsheets you want to combine are located
Save the newly created file

Instructions are provided with the spreadsheet

Please note that this code will not work on protected sheets and it will automatically skip any blank worksheets in any of the workbooks saved in the folder. See how it works for yourself by watching my short demo video below:

Download the Combine Excel Files spreadsheet that contains the VBA code to copy all the worksheets from all the workbooks in a folder into the active workbook using this link:

Combine Files.xlsm download

Thursday, July 25, 2013

2013 NFL Helmet Schedule Spreadsheet

It’s time to get your NFL 2013 schedule. The new football season is nearly upon us after a murderous off-season. It’s finally time to get back to playing ball! This NFL 2013 schedule in Excel includes indicators for all special Monday, Wednesday, Thursday, and Saturday games. If you’re looking for a picture for every football helmet in the NFL you can find them all in this spreadsheet. Each helmet is in fact a hyperlink, not to an outside website but to a “Place in This Document.” It uses Cell References so if you click a team’s helmet it will take you to that team’s schedule in the spreadsheet.

The 2013 NFL helmet schedule spreadsheet can be incorporated into fantasy football leagues. And if you love fantasy football, you should check out the Fantasy Football Commissioner from CBS Sports. Feel free to modify the spreadsheet as you see fit but please share the result with us so everyone can see what cool things you come up with! Download for free here:

2013 NFL Helmet Schedule Spreadsheet.xls download

I can't wait to see how all the storylines play out this year. Will Peyton Manning finally get a second Super Bowl ring? How will the New England Patriots fare after this crazy offseason? Will this be the year for my Cleveland Browns? I doubt it but you never know what will happen.

Update: Now you can get the 2013 NCAA helmet schedule spreadsheet here.

Sunday, March 17, 2013

Downloadable 2013 NCAA Tournament Bracket

The downloadable 2013 NCAA Tournament Brackets are here! It's finally time to download and print your 2013 March Madness Brackets. I’ve made my own tournament brackets for almost every other major sporting event (see them all in the downloads page) but I’ve never attempted to make my own March Madness brackets. Why? Because for the last several years I've used David Tyler's spreadsheets, which I consider to be the best NCAA Excel brackets out there and are nearly flawless in my opinion. They're free to download too!

David has created two separate files: the actual tournament brackets where you predict the winners of each game and a separate bracket manager for office pools. You must use his brackets in order to use the pool manager (and make sure macros are enabled).

Download the 2013 NCAA Tournament Bracket.
Download the 2013 March Madness Pool Manager

Instructions are included with the spreadsheets. To learn more about how the brackets are created read our interviews with David from 2010 and 2011. Also, be sure to visit David’s website, When the Whistle Blows.

My Buckeyes won the Big Ten Tournament and are one of the hottest teams in the nation right now. Who do you have winning the big dance? Let us know in the comments below!

If you would like to you can join my basketball pool on Yahoo's Tourney Pick'em.

Thursday, March 7, 2013

Printable Big Ten Tournament Bracket 2013

I’ve never done this before but being a big fan of the Big Ten I’ve decided to create a printable Big Ten Tournament Bracket this year. The men’s basketball tournament begins on Thursday, March 14th in the heart of Big 10 country at the United Center in Chicago, Illinois. The cool thing about this editable Excel bracket is it includes the complete Big Ten basketball tournament schedule including all of the game times and television channels. Currently, I only have seedings listed. I will list the actual teams once they are known and then update the spreadsheet on Sunday.

Download the all in one bracket and Big Ten Tourney schedule here.

I can’t wait until the Big Ten Tournament starts! There are so many questions to answer: Will Michigan have an early exit? Is Indiana fading? What Minnesota team will show up? Can Iowa or Illinois spring an upset? How far can Ohio State go? With the way each of the top five teams have dropped random games they should have won this year I’d argue there is no clear favorite to win the Big Ten Basketball Championship. What do you think? I’d love for you to share your thoughts on the Big 10 tournament!

Check back soon for the 2013 March Madness brackets and download our new Excel Spreadsheets Help Android app!