Tag Archives: Excel

2015 NFL Draft Results, FREE Excel Spreadsheet

Download the FREE Excel spreadsheet of the NFL draft results: NFL Draft Results 2015

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 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.

2015 NFL Combine Results, FREE Excel Spreadsheet

Find this season’s fastest and strongest rookies.  You might even find some winning fantasy football sleepers.

Download the Excel spreadsheet for FREE!  Click nfl-combine-results-2015.

You can sample the embedded Excel spreadsheet directly below.

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 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.

2014 NFL Draft Order, FREE Excel Spreadsheet

“The 2014 NFL Draft returns to prime-time, with the first round taking place Thursday, May 8, followed by the second and third rounds on Friday, May 9. Rounds 4-7 will be held Saturday, May 10.”

Download the FREE Excel spreadsheet of the NFL draft order: NFL Draft Order 2014

Or, sample the below embedded spreadsheet:

Watch it live on NFL Network.

Click here to visit NFL.com’s round-by-round draft tracker.  It’s updated automatically.

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.

2014 NFL Combine Results, FREE Excel Spreadsheet

Find this season’s fastest and strongest rookies.  You might even find some winning fantasy football sleepers.

Download the Excel spreadsheet for FREE!  Click NFL Combine Results 2014.

You can sample the embedded Excel spreadsheet directly below.

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.

86% make playoffs with Fantasy Football Draftomatic 2013

I conducted an informal survey of Fantasy Football Draftomatic 2013 customers, asking the following questions:

  1. How many leagues were you in?
  2. How many of your teams got into the playoffs?
  3. How many of your teams won a championship?

About 11% of customers responded, totaling 36 fantasy football teams.

The results:

  • 86% of the teams made the playoffs
  • 28% of the teams won their championships

Fantasy Football, NFL, Draft, Draftomatic, 2013, Excel

We came so close to my goal of increasing the percentage of teams that make the playoffs to 90%.  Yes, I want at least 9 out of 10 Draftomatic teams to make the playoffs.  That would be so cool!

One way was to compliment the Fantasy Football Draftomatic, by addressing the weekly challenges of whom to start.  Drafting a strong team is probably the most important task during the season.  Starting your highest scoring players is a close 2nd.

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.

2013 NFL Combine Results Excel Spreadsheet

Find this season’s fastest and strongest rookies.  You might even find some winning fantasy football sleepers.

Simply, sort and filter the embedded Excel spreadsheet directly below.


You can also download the Excel spreadsheet for FREE!

NFL 2013 Combine Results Excel Spreadsheet

Click image to download Excel spreadsheet.

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.

Draftomatic Spreadsheet Projections Strong

Draftomatic spreadsheet customers achieved a 76% success rate of getting into the playoffs, last season (2012).  Customizing player rankings to customers’ own leagues proved to be powerful.  Yet, Value Based Drafting (VBD) still relies on accurate statistical projections.

Fortunately, the Draftomatic’s projections are strong.

R Squared Scatter Chart QB TD NFL Fantasy Football  2012 Value Based Drafting Projected Actual

The slope (m) of 1.0229 shows a near perfect one-to-one determination between Projected and Actual Passing TDs.  The 0.825 coefficient of determination (R2) indicates a statistically strong relationship.

Okay, that’s enough geek-speak!

Translation: The above chart shows that the Draftomatic’s Passing TD projections were approximately 82% accurate overall.

I have to admit that’s pretty darn impressive. We did not merely predict win or lose. We predicted the precise number of touchdowns each quarterback will throw during the regular season.  In fantasy football, whoever is best at predicting the future will win.

It gets even better with QB Passing Yards.

R Squared Scatter Chart QB Yards NFL Fantasty Football Value Based Drafting Projected Actual

Our Projected Passing Yards are closer to a one-to-one relationship with Actual Passing Yards (m is closer to exactly 1); and the overall accuracy is slightly better (R2 is higher).

Value Based Drafting is inherently at risk of GIGO (Garbage In, Garbage Out). However, the Draftomatic’s strong projections will help keep the garbage away from your player rankings.

Get an email notification, when the Draftomatic 2013 spreadsheet gets released. Just click the “Follow” button on the right-hand sidebar.

Good luck and have a great season!