BigDave said:
Marc Levin said:
Where can I find them by TEAM?
Each league has it's own scoring rules for DSTs, so unless you're using FBG's scoring system, it's going to be hard to find.It only takes about 30-45 minutes to do in Excel, though, if you know what you're doing....
Go to
http://www.pro-football-reference.com/years/tmstats2006.htm
Find the Team Defense table.
Highlight it (click just to the left of "Denver" and drag to just the right of the last stat for the 49ers) and hit CTRL-C.
Open Wordpad or any other text editor go to Edit>Paste Special (Unformatted Text).
Change the two- or three- word team names (i.e. New York Giants, St. Louis) to one word names (NY-A or Giants, or StL or Rams, etc).
Go to Edit>Replace. Under "Find What:" enter a single space. Under "Replace with:" enter a single comma.
Every space should now be a comma.
File>Save as... name it something like DST.csv. Use the .csv extension.
Open Excel (or the free version, Open Office), and open your file. You'll now have that same handy webpage chart in Excel format.
Now, the fun part:
Use your league scoring system to multiply and divide the numbers in the appropriate columns.
You're going to have to come up with some formulas.
Unfortunately, there isn't one easy chart that has all the data you'll probably need. Also look on nfl.com/stats for the scoring tables for passing defense, rushing defense, scoring defense, turnovers, etc., you'll have to make some more tables and copy/paste some columns into your master spreadsheet.
So, when you get to the turnovers table, Arizona has 9 INTs and 11 Fumble Recoveries. Multiply the INT column by your scoring for INTs and the FUM column by your scoring for Fum Recs.
Add everything together into one big formula and there's your Defensive FPs scored.