Tag Archives: free download

NFL 2015 Schedule, FREE Excel Spreadsheet

I turned the NFL 2015 schedule into a normalized Excel table.  So now, you can sort, filter, and PivotTable it!

Click this link to download the FREE Excel spreadsheet: NFL 2015 Schedule

Or, sample the below embedded spreadsheet:

Follow my blog by clicking the “Follow” button on the right-hand sidebar, to get email updates automatically. This is not a super active blog. So, don’t worry about me cluttering up your email inbox. (I hate that too.)

You can also follow me on Twitter @ExcelFootball.

Advertisements

NFL 2014 Schedule, FREE Excel Spreadsheet

Update: Click here for NFL 2015 Schedule.

I turned the NFL 2014 schedule into a normalized Excel table.  So now, you can sort, filter, and PivotTable it!

Click this link to download the FREE Excel spreadsheet: NFL 2014 Schedule

Or, sample the below embedded spreadsheet:

Follow my blog by clicking the “Follow” button on the right-hand sidebar, to get email updates automatically. This is not a super active blog. So, don’t worry about me cluttering up your email inbox. (I hate that too.)

You can also follow me on Twitter @ExcelFootball.

NFL 2013 Schedule in MS Excel Spreadsheet

Update: Click here for the 2014 NFL schedule.

I turned the NFL 2013 schedule into an Excel spreadsheet.  Now,  you can sort and filter it.


Or, download the spreadsheet for FREE!

NFL 2013 Schedule MS Excel Spreadsheet

Click image to download.

FREE E-Book: Excel 2003 for Fantasy Football

In celebration of the 2012 NFL draft, I’m giving away my first e-book for absolutely FREE!

This promotion will last during the entire NFL draft, April 26-28, 2012.

Offer expires April 28, 2012.

excel fantasy football book draft cheat sheet NFL pivottable vlookup statistics stats

Get your FREE e-book!

Offer expires April 28, 2012.

BONUS Secret Weapons + More FREE Downloads

Draft Tracker Template Fantasy Football Excel Spreadsheet Gain access to Secret Weapons as a BONUS! Plus, more FREE downloads!

Simply enter the very last word inside the book, Excel for Fantasy Football, as the password.

Unlock these Secret Weapons:

Draft Day is coming. Don’t delay!

fantasy football cheat sheet Excel spreadsheet pivottable vlookup rank tier raw data stats statisticsfantasy football cheat sheet Excel spreadsheet pivottable vlookup rank tier raw data stats statisticsExcel Fantasy Football Book iBook iBookstore iTunes iPad Cheat Sheet NFL

Protected: Draft Tracker Template (Click SECRET WEAPONS for password details)

This content is password protected. To view it please enter your password below:

Step 1 – Consume Mass Quantities (Import Fantasy Football Stats)

<–Intro      Step 2–>

The Coneheads from Saturday Night Live (1977) would “consume mass quantities,” by gulping entire six-packs and bags of chips. With the Excel spreadsheet, we can consume mass quantities of fantasy football stats, and properly digest this data into useful information for the big draft.

I only gather data of the last three seasons. Older data loses its value. Use less than three seasons of data, and we might as well pick players based on last season’s performance.

Since I’m in Yahoo! leagues, I found the Yahoo! statistics page. It has all of the basic elements needed to begin building our Excel spreadsheet (Yards, TD’s, Fumbles, etc.).

First, filter the online data by Position, View by, Year and Timeframe. Always set the Players filter to “All Players”, if given the option.

excel fantasy football spreadsheet stats nfl draft cheat sheet

Figure 1-1

Import the raw data directly from the webpage by clicking the Data tab, then the From Web command in the Get External Data group, as follows:

excel fantasy football spreadsheet nfl draft cheat sheet

Figure 1-2

Copy the URL from your browser (above), and Paste it into the Address field (below), and click Go.

excel fantasy football spreadsheet nfl draft cheat sheet

Figure 1-3

Then, select only the statistics table by clicking its yellow arrow. The yellow arrow changes into a green check mark. Now, click Import.

excel fantasy football spreadsheet nfl draft cheat sheet

Figure 1-4

Your imported data should look like this on your Excel spreadsheet.

excel fantasy football spreadsheet nfl draft cheat sheet

Figure 1-5

You can now repeat this step another 51 times (3 seasons x 17 weeks = 51 times), for each position. Yikes! Or, just get a FREE copy of my NFL stats. I have already done this tedious task for you. This is my least favorite part of the process, too.

Next, change the Games column header from “G” to “Week”, and add a column for the “Season” (e.g. 2011). There’s a nice blank column that’s ready for you in column D. So, just type “Season” into D2. Enter and auto-fill the Week and Season for each player. This step is key to creating PivotTables by Week and Season in later steps.

excel fantasy football spreadsheet nfl draft cheat sheet

Figure 1-6

I like to categorize each data column, in order to avoid confusion between rushing yards and receiving yards, etc. Simply, add detail to the column headers, such as “Rushing_Yds” and “Receiving_Yds” as follows:

excel fantasy football spreadsheet nfl draft cheat sheet

Figure 1-7

Now, we can clean up the data set by Deleting the empty columns, and Row 1. Let’s also change the tab’s title from “Sheet1” to “RB Raw Data” by double-clicking it.

From:

excel fantasy football spreadsheet nfl draft cheat sheet

Figure 1-8

To:

excel fantasy football spreadsheet nfl draft cheat sheet

Figure 1-9

Did you really gather and scrub the entire data set yourself? You data-stud, you!

Note: Remember to TRIM away the extra spaces from players’ names. Also, account for duplicate names, like Adrian Peterson (MIN) and Adrian Peterson (CHI). Or, you can just use my free data set. I’ve already scrubbed it for you.

<–Intro      Step 2–>

fantasy football cheat sheet Excel spreadsheet pivottable vlookup rank tier raw data stats statisticsfantasy football cheat sheet Excel spreadsheet pivottable vlookup rank tier raw data stats statisticsExcel Fantasy Football Book iBook iBookstore iTunes iPad Cheat Sheet NFL