I wanted to share my Week 1 NFL Spreadsheets that I utilize to Handicap. Of course these stats are comprised of last season's data, but will change throughout the season. These spreadsheets would take hours to create manually. Fortunately, I have written some coding to automate this data. I do this on a weekly basis throughout the season as it is a very important part of my handicapping. I can output these sheets as PDF, JPG, Excel files, etc... I hope you guys can utilize this data.
|
OFFENSIVE STATS |
TEAM |
RuYPA |
RuFum |
QB% |
QBYPA |
INT |
Sacks |
3rdDown |
PtsPG |
Arizona |
3.6 |
7 |
63.2 |
7.5 |
22 |
41 |
35.2 |
23.7 |
Atlanta |
3.9 |
1 |
67.5 |
6.9 |
17 |
44 |
43 |
22.1 |
Baltimore |
3.1 |
2 |
58.6 |
6.3 |
23 |
48 |
36.4 |
20 |
Buffalo |
4.2 |
12 |
57.3 |
6.5 |
15 |
48 |
34 |
21.2 |
Carolina |
4.2 |
3 |
61.7 |
7.1 |
13 |
43 |
43.8 |
22.9 |
Chicago |
4.5 |
4 |
64.4 |
7.7 |
13 |
30 |
42.1 |
27.8 |
Cincinnati |
3.6 |
7 |
62 |
7.4 |
20 |
29 |
40.9 |
26.9 |
Cleveland |
4 |
2 |
55.7 |
6.4 |
20 |
49 |
35 |
19.3 |
Dallas |
4.5 |
5 |
64 |
7.2 |
12 |
35 |
35 |
27.4 |
Denver |
4.1 |
10 |
68.3 |
8.3 |
10 |
20 |
46.3 |
37.9 |
Detroit |
4 |
19 |
58.5 |
7.3 |
19 |
23 |
43 |
24.7 |
Green Bay |
4.7 |
7 |
64.2 |
8 |
16 |
45 |
41.2 |
26.1 |
Houston |
4.2 |
5 |
58.6 |
6.6 |
22 |
42 |
35.9 |
17.3 |
Indianapolis |
4.3 |
3 |
60.1 |
6.8 |
10 |
32 |
37.6 |
24.4 |
Jacksonville |
3.3 |
5 |
59 |
6.3 |
21 |
50 |
31.1 |
15.4 |
Kansas City |
4.7 |
8 |
61 |
6.5 |
8 |
41 |
34.7 |
26.9 |
Miami |
4.1 |
5 |
60.1 |
6.7 |
19 |
58 |
35 |
19.8 |
Minnesota |
4.9 |
9 |
59.5 |
6.7 |
19 |
44 |
36.4 |
24.4 |
New England |
4.4 |
10 |
60.5 |
6.9 |
11 |
40 |
37.6 |
27.8 |
New Orleans |
3.8 |
1 |
68.5 |
7.9 |
12 |
37 |
43.9 |
25.9 |
NY Giants |
3.5 |
12 |
57.3 |
6.8 |
29 |
40 |
32.7 |
18.4 |
NY Jets |
4.4 |
7 |
55.4 |
6.8 |
22 |
47 |
39 |
18.1 |
Oakland |
4.6 |
7 |
57.4 |
7 |
20 |
44 |
35 |
20.1 |
Philadelphia |
5.1 |
5 |
61 |
8.7 |
9 |
46 |
39 |
27.6 |
Pittsburgh |
3.5 |
6 |
64.3 |
7.3 |
14 |
43 |
38 |
23.7 |
San Diego |
4 |
5 |
69.5 |
8.2 |
11 |
30 |
49 |
24.8 |
San Francisco |
4.4 |
7 |
58.5 |
7.7 |
8 |
39 |
36.5 |
25.4 |
Seattle |
4.3 |
6 |
63.6 |
8.4 |
9 |
44 |
37.3 |
26.1 |
St. Louis |
4.1 |
6 |
59.5 |
6.6 |
11 |
36 |
34.4 |
21.8 |
Tampa Bay |
3.8 |
6 |
56.6 |
6.2 |
12 |
47 |
31.2 |
18 |
Tennessee |
4.1 |
8 |
61.5 |
7 |
16 |
37 |
41.4 |
22.6 |
Washington |
4.8 |
11 |
58.1 |
6.6 |
19 |
43 |
40.4 |
20.9 |
|
OFFENSIVE RANKINGS |
TEAM |
RuYPA Rk |
RuFum Rk |
QB% Rk |
QBYPA Rk |
INT Rk |
Sacks Rk |
3rdDown Rk |
PtsPG Rk |
Arizona |
27 |
7 |
10 |
9 |
14 |
11 |
22 |
13 |
Atlanta |
24 |
1 |
4 |
18 |
10 |
14 |
5 |
16 |
Baltimore |
31 |
2 |
22 |
30 |
15 |
18 |
20 |
21 |
Buffalo |
14 |
12 |
29 |
27 |
8 |
18 |
29 |
18 |
Carolina |
16 |
3 |
12 |
14 |
6 |
13 |
4 |
14 |
Chicago |
7 |
4 |
5 |
8 |
6 |
4 |
7 |
2 |
Cincinnati |
27 |
7 |
11 |
10 |
12 |
3 |
10 |
6 |
Cleveland |
23 |
2 |
31 |
28 |
12 |
19 |
24 |
23 |
Dallas |
8 |
5 |
8 |
13 |
5 |
6 |
25 |
5 |
Denver |
20 |
10 |
3 |
3 |
3 |
1 |
2 |
1 |
Detroit |
22 |
13 |
24 |
12 |
11 |
2 |
6 |
11 |
Green Bay |
4 |
7 |
7 |
5 |
9 |
15 |
9 |
7 |
Houston |
15 |
5 |
23 |
25 |
14 |
12 |
21 |
27 |
Indianapolis |
13 |
3 |
17 |
21 |
3 |
5 |
15 |
12 |
Jacksonville |
30 |
5 |
21 |
29 |
13 |
20 |
32 |
28 |
Kansas City |
5 |
8 |
15 |
26 |
1 |
11 |
27 |
6 |
Miami |
17 |
5 |
18 |
22 |
11 |
21 |
23 |
22 |
Minnesota |
2 |
9 |
19 |
23 |
11 |
14 |
19 |
12 |
New England |
9 |
10 |
16 |
17 |
4 |
10 |
16 |
3 |
New Orleans |
26 |
1 |
2 |
6 |
5 |
8 |
3 |
8 |
NY Giants |
29 |
12 |
28 |
19 |
16 |
10 |
30 |
24 |
NY Jets |
10 |
7 |
32 |
20 |
14 |
17 |
13 |
25 |
Oakland |
6 |
7 |
27 |
15 |
12 |
14 |
26 |
20 |
Philadelphia |
1 |
5 |
14 |
1 |
2 |
16 |
12 |
4 |
Pittsburgh |
28 |
6 |
6 |
11 |
7 |
13 |
14 |
13 |
San Diego |
21 |
5 |
1 |
4 |
4 |
4 |
1 |
10 |
San Francisco |
11 |
7 |
25 |
7 |
1 |
9 |
18 |
9 |
Seattle |
12 |
6 |
9 |
2 |
2 |
14 |
17 |
7 |
St. Louis |
18 |
6 |
20 |
24 |
4 |
7 |
28 |
17 |
Tampa Bay |
25 |
6 |
30 |
31 |
5 |
17 |
31 |
26 |
Tennessee |
19 |
8 |
13 |
16 |
9 |
8 |
8 |
15 |
Washington |
3 |
11 |
26 |
24 |
11 |
13 |
11 |
19 |
|
DEFENSIVE STATS |
TEAM |
RuYPA |
Fumbles |
QB% |
QBYPA |
INT |
Sacks |
3rdDown |
PtsPG |
Arizona |
3.7 |
11 |
58.7 |
6.5 |
20 |
47 |
35.3 |
20.3 |
Atlanta |
4.8 |
13 |
66.1 |
8 |
10 |
32 |
45.9 |
27.7 |
Baltimore |
3.8 |
14 |
56.9 |
7.1 |
16 |
40 |
33.5 |
22 |
Buffalo |
4.4 |
12 |
55.3 |
6.5 |
23 |
57 |
37.1 |
24.3 |
Carolina |
4 |
11 |
66.6 |
6.8 |
20 |
60 |
35.8 |
15.1 |
Chicago |
5.3 |
21 |
62.1 |
7.7 |
19 |
31 |
41.5 |
29.9 |
Cincinnati |
4 |
13 |
59 |
5.9 |
20 |
43 |
32.9 |
19.1 |
Cleveland |
3.9 |
9 |
60 |
6.2 |
14 |
40 |
44.7 |
25.4 |
Dallas |
4.7 |
13 |
64.7 |
7.8 |
15 |
34 |
43.3 |
27 |
Denver |
3.9 |
18 |
58.2 |
7.1 |
17 |
41 |
38.1 |
24.9 |
Detroit |
4.2 |
14 |
59.1 |
7.3 |
15 |
33 |
30.3 |
23.5 |
Green Bay |
4.6 |
19 |
61.6 |
7.8 |
11 |
44 |
38.2 |
26.8 |
Houston |
4.3 |
12 |
59.3 |
6.8 |
7 |
32 |
34.6 |
26.8 |
Indianapolis |
4.5 |
23 |
60.4 |
7.4 |
15 |
42 |
37.6 |
21 |
Jacksonville |
4.2 |
16 |
64.2 |
7.6 |
11 |
31 |
42.5 |
28.1 |
Kansas City |
4.5 |
14 |
56.4 |
7.2 |
21 |
47 |
34.1 |
19.1 |
Miami |
4.1 |
12 |
59.3 |
6.9 |
18 |
42 |
38.2 |
20.9 |
Minnesota |
4 |
13 |
64.7 |
7.5 |
12 |
41 |
44.2 |
30 |
New England |
4.5 |
11 |
57 |
7 |
17 |
48 |
42.2 |
21.1 |
New Orleans |
4.6 |
16 |
60 |
6.8 |
12 |
49 |
34.7 |
19 |
NY Giants |
3.8 |
17 |
60.1 |
6.3 |
17 |
34 |
40.1 |
23.9 |
NY Jets |
3.4 |
11 |
58.9 |
7.1 |
13 |
41 |
36.8 |
24.2 |
Oakland |
3.9 |
21 |
68.1 |
7.9 |
9 |
38 |
43.1 |
28.3 |
Philadelphia |
3.8 |
15 |
60.9 |
7.3 |
19 |
37 |
40.3 |
23.9 |
Pittsburgh |
4.3 |
19 |
57.8 |
6.6 |
10 |
34 |
39.6 |
23.1 |
San Diego |
4.6 |
13 |
66.4 |
8 |
11 |
35 |
38.9 |
21.8 |
San Francisco |
3.9 |
13 |
59 |
6.5 |
18 |
38 |
34.1 |
17 |
Seattle |
3.9 |
20 |
59 |
5.8 |
28 |
44 |
35.2 |
14.4 |
St. Louis |
3.7 |
24 |
68.1 |
8.1 |
14 |
53 |
38.8 |
22.8 |
Tampa Bay |
4 |
17 |
64.4 |
7.4 |
21 |
35 |
39.2 |
24.3 |
Tennessee |
4 |
16 |
63.1 |
7 |
13 |
36 |
34.3 |
23.8 |
Washington |
4 |
12 |
65.6 |
8 |
16 |
36 |
34 |
29.9 |
|
DEFENSIVE RANKINGS |
TEAM |
RuYPA Rk |
Fumbles Rk |
QB% Rk |
QBYPA Rk |
INT Rk |
Sacks Rk |
3rdDown Rk |
PtsPG Rk |
Arizona |
2 |
13 |
7 |
5 |
4 |
6 |
11 |
6 |
Atlanta |
31 |
11 |
28 |
29 |
14 |
18 |
31 |
25 |
Baltimore |
5 |
10 |
3 |
16 |
8 |
11 |
3 |
11 |
Buffalo |
23 |
12 |
1 |
7 |
2 |
2 |
14 |
19 |
Carolina |
12 |
13 |
30 |
11 |
4 |
1 |
12 |
2 |
Chicago |
32 |
3 |
21 |
25 |
5 |
19 |
24 |
28 |
Cincinnati |
15 |
11 |
9 |
2 |
4 |
8 |
2 |
5 |
Cleveland |
8 |
14 |
16 |
3 |
10 |
11 |
30 |
22 |
Dallas |
30 |
11 |
26 |
26 |
9 |
16 |
28 |
24 |
Denver |
10 |
6 |
6 |
15 |
7 |
10 |
16 |
21 |
Detroit |
20 |
10 |
12 |
20 |
9 |
17 |
1 |
14 |
Green Bay |
29 |
5 |
20 |
27 |
13 |
7 |
17 |
23 |
Houston |
22 |
12 |
13 |
10 |
16 |
18 |
8 |
23 |
Indianapolis |
25 |
2 |
18 |
21 |
9 |
9 |
15 |
8 |
Jacksonville |
19 |
8 |
23 |
24 |
13 |
19 |
26 |
26 |
Kansas City |
26 |
10 |
2 |
18 |
3 |
6 |
5 |
5 |
Miami |
18 |
12 |
14 |
12 |
6 |
9 |
17 |
7 |
Minnesota |
13 |
11 |
25 |
23 |
12 |
10 |
29 |
29 |
New England |
24 |
13 |
4 |
13 |
7 |
5 |
25 |
9 |
New Orleans |
28 |
8 |
15 |
9 |
12 |
4 |
9 |
4 |
NY Giants |
6 |
7 |
17 |
4 |
7 |
16 |
22 |
17 |
NY Jets |
1 |
13 |
8 |
17 |
11 |
10 |
13 |
18 |
Oakland |
11 |
3 |
31 |
28 |
15 |
12 |
27 |
27 |
Philadelphia |
4 |
9 |
19 |
19 |
5 |
13 |
23 |
16 |
Pittsburgh |
21 |
5 |
5 |
8 |
14 |
16 |
21 |
13 |
San Diego |
27 |
11 |
29 |
30 |
13 |
15 |
19 |
10 |
San Francisco |
9 |
11 |
11 |
6 |
6 |
12 |
6 |
3 |
Seattle |
7 |
4 |
10 |
1 |
1 |
7 |
10 |
1 |
St. Louis |
3 |
1 |
32 |
32 |
10 |
3 |
18 |
12 |
Tampa Bay |
16 |
7 |
24 |
22 |
3 |
15 |
20 |
20 |
Tennessee |
17 |
8 |
22 |
14 |
11 |
14 |
7 |
15 |
Washington |
14 |
12 |
27 |
31 |
8 |
14 |
4 |
28 |