Jump to content

Power Play. Rankings Take Shape


Recommended Posts

Tell me what you think about this.. It is about the best one that I have seen so far.

Sorry if already posted.

Power play: Rankings take shape

November 3, 2008 3:42 PM

Posted by ESPN.com's Mike Sando

The pursuit of the most defensible NFL power rankings continues. BanJ2573 improved my initial submissions through Week 9 by eliminating two cases that could have exposed your NFC West host to the worst kind of ridicule: the avoidable kind.

We're not going to rank the Rams ahead of the Redskins just because St. Louis won at Washington this season. But we should rank teams in ways that minimize those head-scratching moments when voters seem to forget what happened on the field. And so I put together a new weapon to help us do just that heading into Week 10.

Here's how you can shape my rankings for this week and do your part to reduce Wayward Voter Syndrome:

Download this Excel file and take a look at the information in columns Y and Z.

Column Y features team rankings.

Column Z shows how many times a team has defeated higher-ranked teams.

Change the rankings in column Y as you see fit.

Re-sort column Y in ascending order (1 to 32) using the standard Excel pull-down menu atop the column.

The information in column Z, which reflects potential ranking errors, will change (with the adjusted total highlighted in red atop the column).

The lower the figure in that red box, the fewer conflicts.

We'll have to make adjustments based on what happens in the "Monday Night Football" game. I'll run the order that produced the fewest number of conflicts so far, courtesy of BanJ2573. And we'll probably make a few other logic-based adjustments (moving down Tampa Bay, for example). I do like having this file to check for potential embarrassing oversights, though.

The number to the right of each team name shows how many higher-ranked opponents the ranked team has defeated this season:

Tennessee Titans 0

New York Giants 0

Washington Redskins 0

Tampa Bay Buccaneers 0

Carolina Panthers 0

Philadelphia Eagles 0

Pittsburgh Steelers 0

Arizona Cardinals 0

Atlanta Falcons 0

Baltimore Ravens 0

Chicago Bears 1

New York Jets 1

Indianapolis Colts 1

Miami Dolphins 0

New England Patriots 1

Buffalo Bills 0

Green Bay Packers 1

Minnesota Vikings 1

Denver Broncos 1

Dallas Cowboys 3

New Orleans Saints 1

San Diego Chargers 2

Cleveland Browns 1

Jacksonville Jaguars 2

Houston Texans 1

Seattle Seahawks 0

San Francisco 49ers 1

St. Louis Rams 2

Cincinnati Bengals 1

Oakland Raiders 1

Kansas City Chiefs 1

Detroit Lions 0

Technical note: The file should update the number of conflicts as you change the rankings in column Y. If the information does not update, you can manually re-calculate by pressing the F9 button on a PC or command/plus sign/equal sign on a Mac. But make sure you re-sort the rankings in ascending order, 1 to 32, each time you change a ranking.

Power rankings, power play, help needed on rankings 10

Sort comments by: Most Recent | First Posted


Link to comment
Share on other sites

• Tim Graham on the AFC East

• James Walker on the AFC North

• Paul Kuharsky on the AFC South

• Bill Williamson on the AFC West

• Matt Mosley on the NFC East

• Kevin Seifert on the NFC North

• Pat Yasinskas on the NFC South

Mike Sando on the NFC West

hes just one guy.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...