Week 10 Excel Data

To return to home page click here

The data provided on this page tries to utilize raw data available from a free major NFL stats provider.  I tried to look at the raw data before interjecting manual corrections obvious errors in the power rankings.  I am still trying to figure out how to add factors such as injuries and weather into the power rankings.  There is still a number of statistical problems with how the data is manipulated (I am not a statistician), and this is really a first attempt (2005) at handicapping NFL games based on using previous weeks stats.  While previous years trends and outside influences may also affect power rankings, I tried to focus on using the compiled seasonal statistics as the main factor in developing a power ranking system.  This is a matter of convenience because it is easy to obtain this seasonal statistical NFL data using free NFL stats sites (like Yahoo! sports) on the internet and cutting and pasting this data into a preformatted excel spreadsheet.

Initially,  tried to develop this system to look at the possibilities of beating a spread.  Spreads are not predictors of how the game will turn out.  Since all the bookmakers want is an even distribution of the money wagered, spread are a number where bookmakers feel an equal distribution of bets will occur (one side or the other).  If the spread, or line, changes, it is a usually a reflection of how people are betting the game (or if a major factor that influences the game (such as injury) occurs).  It is unlikely that the results/predictions generated on this site are reliable indicators in predicting ATS outcome due to the variety of errors and unknown variables involved before and during the game.  The result of NFL games ATS are dependent on a variety of factors that are not likely reflected in pure statistical data.  Ultimately, predicting NFL games ATS  is reflected in a 54% success rate.  

For a further discussion of how the Reisterstown predictions are made and compiled, click here

Please refer to previous weeks for more detail on how the excel charts are compiled.  From this point on I will not post the excel images due to time constraints.

This page does not condone gambling in any form, and all information on this page or subsequent pages is opinion and for educational use and discussion only.  The Author does not guarantee the accuracy or reliability of the data presented on this page or subsequent pages. Use this page at your own risk

I may be willing to sell the data on this page in  the raw excel data.  If you would like to purchase this spreadsheet (nflstats.xls in Microsoft Excel 2000 format)) to use and evaluate, please email the Author at nflstats@comcast.net for details, and perhaps we can work something out.  Once Again, this is the first iteration of this spreadsheet, and there are many statistical problems here to be worked out.  Since I am involved in a number of other projects as well, I may not answer your email requests right away, or may abandon this project entirely.......However, you can see what was started, and how you can create your own power ranking system as well using excel.

This is a relatively simple excel spreadsheet. You should be proficient in excel and know how to import data from outside sources (like yahoo! sports), by cutting and pasting the data to the spreadsheet.   Since this spreadsheet is always evolving, I could send you weekly updates for the season (up to week 16)  to what I am doing if you are willing to buy, and am comfortable with working with you.  The pictures above are the actual spreadsheet cut into sections for viewing.  Email suggestions to the Author as well.......

You should be proficient in excel and know how to import data from outside sources (like yahoo! sports), by cutting and pasting the data to the spreadsheet.  The pictures below are the actual spreadsheet cut into sections for viewing.

I am sorry that I  cannot provide details on how to cut and paste the data from outside sources and how I decided to use the formulas.  However, the formulas are there and you are free to change the formulas to your own preferences.  

There are some manual functions involved in using the spreadsheet, such as manually placing the games in the match up columns.  However, the data is manipulated by sorting the data into alphabetical form, then resorting it to power ranking forms.  There is also a graph of the teams rakings so you can tweak the power ranking numbers and watch how the ranking are affected.

Once again: The Author does not guarantee the accuracy or reliability of the Data on this page and/or spreadsheets provided for free or at cost.  You must take this data at your own risk, verify the data independently Any information provided on this page or spreadsheets provided by the author is for informational and educational use only.

This page is not affiliated with the NFL, Yahoo! sports, USA Today, Comcast, any sports book or gambling service.  All information on this page is opinion.