Sunday, September 29, 2013

2013 MLB Playoff Bracket

October is here which means it’s time for the 2013 MLB playoffs to begin! The major league baseball regular season concludes on Sunday, Sept. 29 unless there are any necessary regular-season tie breaker games (Rays versus Rangers). The MLB playoffs are set to begin on Tuesday, October 1st. The Division Series returns to a 2-2-1 format this fall. Game 1 of the World Series is scheduled to be played on Wednesday, Oct. 23, in the ballpark of the American League champions.
 
2013 mlb playoff bracket


My 2013 MLB playoff bracket includes the schedule and TV coverage lineup. As an Ohio guy I'll be rooting for the Reds and Indians, though I am happy for Pirates fans to see their tea finally make it to the playoffs. Who do you have winning your 2013 MLB playoff bracket?

Tuesday, September 24, 2013

Downloadable 2013-2014 NHL Schedule in Excel

The 2013 NHL season is about to begin and to help get you excited for it I’ve made an NHL schedule spreadsheet available to download for free. The spreadsheet contains the logo of every NHL team and is similar format to my NCAA football helmet spreadsheet and NFL helmet schedule (but I didn’t put logos for every game due to the sheer number of games compared to the football seasons).


2013-2014 NHL Schedule.xls download

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:

combine excel files macro
 
  1. Place the Excel workbooks you want to combine into a single folder that contains no other files
  2. Go to View>Macros
  3. Select "Combine Workbooks" then click Run
  4. Select the File where the spreadsheets you want to combine are located
  5. 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

Tuesday, September 10, 2013

Download a Wordpress Website Creation Checklist Spreadsheet

In the past two years I’ve created eight websites for various hobbies and niches I am interested in and that I felt were underserved in the online world. I use Wordpress as my content management system because it allows you to quickly create a website with no HTML or other coding experience. The steps to setup a new website are pretty much the same so I put together a Wordpress website creation checklist to help me remember to do everything. I’ve made this checklist into an Excel template which you can download for free by clicking the link below.
 
wordpress website creation checklist
 
Two skills I encourage everyone to learn that I’ve found invaluable in my career is how to program VBA macros and how to build a simple website. In fact, in one of my most recent projects these skills were used hand-in-hand. I built the majority of the Observation Wheel database with an Excel spreadsheet and a few custom macros. Every row in my sheet contained all the information for a single observation wheel. I then had the macro export the data to Microsoft Word in the HTML format I needed for the site. I then simply copied and pasted that text into Wordpress and published it. I created pages for over eighty dfferent observation wheels almost instantly!
 
There are countless positive benefits for learning how to make a website. I’ve included a link to all the resources I use within the template and I've tried to include as many tips as I could think of. I begin with registering a domain name and take you all the way through setting up an email list. Download my Wordpress website creation checklist below and please feel free to ask me any questions you may have!