Power Rankings Auto Update From Web In Excel Spreadsheet

[dljjackson]

I made a NBA power rating spreadsheet which uses each team's ranking in specific statistical categories from teamrankings.com. I'm wondering is it possible for me to somehow program my spreadsheet to automatically update the rankings from the web instead of me having to manually enter them whenever I want to update my power ratings. Below is a copy of my spreadsheet, not sure how to attach it

[TABLE="width: 1773"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Team[/TD]
[TD]3 Pointers Made/Gm[/TD]
[TD]Field Goal %[/TD]
[TD]Opp. 3 Pointers Made/Gm[/TD]
[TD]Turnover Margin[/TD]
[TD]Offensive Rebounding[/TD]
[TD]Free Throw Attempts/Game[/TD]
[TD]Opp. Free Throw Attempts/Gm[/TD]
[TD]Points Per Game Difference[/TD]
[TD]Assists Per Game[/TD]
[TD]Opp. Field Goal %[/TD]
[TD]D.I.Z. Score[/TD]
[/TR]
[TR]
[TD]Los Angeles Clippers[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]105[/TD]
[/TR]
[TR]
[TD]Oklahoma City Thunder[/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]104[/TD]
[/TR]
[TR]
[TD]Indiana Pacers[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]103[/TD]
[/TR]
[TR]
[TD]Golden State Warriors[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]29[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]103[/TD]
[/TR]
[TR]
[TD]Miami Heat[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]102[/TD]
[/TR]
[TR]
[TD]Houston Rockets[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]102[/TD]
[/TR]
[TR]
[TD]San Antonio Spurs[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]102[/TD]
[/TR]
[TR]
[TD]Portland Trailblazers[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD]Phoenix Suns[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]29[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD]Toronto Raptors[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD]Dallas Mavericks[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]99[/TD]
[/TR]
[TR]
[TD]Washington Wizards[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]99[/TD]
[/TR]
[TR]
[TD]Chicago Bulls[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]99[/TD]
[/TR]
[TR]
[TD]Atlanta Hawks[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]29[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]98[/TD]
[/TR]
[TR]
[TD]New Orleans Pelicans[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]98[/TD]
[/TR]
[TR]
[TD]Memphis Grizzlies[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]98[/TD]
[/TR]
[TR]
[TD]Denver Nuggets[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]98[/TD]
[/TR]
[TR]
[TD]Minnesota Timberwolves[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]98[/TD]
[/TR]
[TR]
[TD]Charlotte Hornets[/TD]
[TD="align: right"]29[/TD]
[TD="align: right"]29[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]96[/TD]
[/TR]
[TR]
[TD]Detroit Pistons[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]96[/TD]
[/TR]
[TR]
[TD]Cleveland Cavaliers[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]96[/TD]
[/TR]
[TR]
[TD]Boston Celtics[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]95[/TD]
[/TR]
[TR]
[TD]Orlando Magic[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]94[/TD]
[/TR]
[TR]
[TD]Sacramento Kings[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]93[/TD]
[/TR]
[TR]
[TD]Milwaukee Bucks[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]93[/TD]
[/TR]
[TR]
[TD]New York Knicks[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]29[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]93[/TD]
[/TR]
[TR]
[TD]Los Angeles Lakers[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]92[/TD]
[/TR]
[TR]
[TD]Brooklyn Nets[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]91[/TD]
[/TR]
[TR]
[TD]Utah Jazz[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]29[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]90[/TD]
[/TR]
[TR]
[TD]Philadelphia 76ers[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]29[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]87[/TD]
[/TR]
</tbody>[/TABLE]

 

[ukmikeb]

Hi

Welcome to MrExcel Forum.

It should be possible to automate the collection of the statistics but the number of webpages to access to arrive at your final sheet would seem to be quite high.

For instance the Turnover Margin figure doesn't seem to be available in the menus (links to specific stats) is it a calculated field?

If you could itemise the source of the column headings it should be possible to create the automated routine.

 

[dljjackson]

Sorry, I don't use teamrankings for my NBA power rankings but I do for my NFL power rankings which does use quite a few different sources and may be much tougher than this task. Luckily, all the stats needed for my NBA power rankings can be found under team statistics at 2014-2015 NBA Stats and League Leaders - National Basketball Association - ESPN.

 

[dljjackson]

My NFL power rankings:
[TABLE="width: 1763"]
<colgroup><col><col><col><col><col><col><col><col><col span="2"><col><col></colgroup><tbody>[TR]
[TD]Team[/TD]
[TD]Yards Per Pass[/TD]
[TD]Avg. Time of Poss.[/TD]
[TD]Def. Yards Per Pass[/TD]
[TD]Avg. Starting Field Position[/TD]
[TD]Offensive Red Zone Efficiency[/TD]
[TD]Def. Red Zone Efficiency[/TD]
[TD]Penalty Yards Per Game[/TD]
[TD]Points Per Game Difference[/TD]
[TD]Turnover Margin Per Game[/TD]
[TD]Big Play %[/TD]
[TD]D.I.Z. Score[/TD]
[/TR]
[TR]
[TD]Green Bay Packers[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]28[/TD]
[/TR]
[TR]
[TD]Kansas City Chiefs[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]27[/TD]
[/TR]
[TR]
[TD]Denver Broncos[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]29[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]26[/TD]
[/TR]
[TR]
[TD]Detroit Lions[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]25[/TD]
[/TR]
[TR]
[TD]Seattle Seahawks[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]24[/TD]
[/TR]
[TR]
[TD]Cleveland Browns[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]23[/TD]
[/TR]
[TR]
[TD]Philadelphia Eagles[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]23[/TD]
[/TR]
[TR]
[TD]Indianapolis Colts[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]23[/TD]
[/TR]
[TR]
[TD]San Francisco 49ers[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]29[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]23[/TD]
[/TR]
[TR]
[TD]New England Patriots[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]23[/TD]
[/TR]
[TR]
[TD]Miami Dolphins[/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]23[/TD]
[/TR]
[TR]
[TD]Arizona Cardinals[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]22[/TD]
[/TR]
[TR]
[TD]Baltimore Ravens[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]22[/TD]
[/TR]
[TR]
[TD]Houston Texans[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]21[/TD]
[/TR]
[TR]
[TD]San Diego Chargers[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]21[/TD]
[/TR]
[TR]
[TD]Dallas Cowboys[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]21[/TD]
[/TR]
[TR]
[TD]New Orleans Saints[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]21[/TD]
[/TR]
[TR]
[TD]Cincinnati Bengals[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]20[/TD]
[/TR]
[TR]
[TD]Buffalo Bills[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]20[/TD]
[/TR]
[TR]
[TD]New York Giants[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]19[/TD]
[/TR]
[TR]
[TD]Pittsburgh Steelers[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]18[/TD]
[/TR]
[TR]
[TD]Washington Redskins[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]29[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]18[/TD]
[/TR]
[TR]
[TD]Chicago Bears[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]17[/TD]
[/TR]
[TR]
[TD]Atlanta Falcons[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]16[/TD]
[/TR]
[TR]
[TD]Minnesota Vikings[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]16[/TD]
[/TR]
[TR]
[TD]Carolina Panthers[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]15[/TD]
[/TR]
[TR]
[TD]St. Louis Rams[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]29[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]15[/TD]
[/TR]
[TR]
[TD]Tennessee Titans[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]29[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]14[/TD]
[/TR]
[TR]
[TD]Oakland Raiders[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]14[/TD]
[/TR]
[TR]
[TD]New York Jets[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]29[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD]Jacksonville Jaguars[/TD]
[TD="align: right"]29[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]29[/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD]Tampa Bay Buccaneers[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]29[/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]12[/TD]
[/TR]
</tbody>[/TABLE]

All of the stats besides "big play %" and "average starting field position" can be found on Team Rankings -- NFL Football Stats on TeamRankings.com .

Big play % can be found at Team Big Play Statistics: 2013 NFL Season

Average starting field position can be found at FOOTBALL OUTSIDERS: Innovative Statistics, Intelligent Analysis | 2014 DRIVE STATS -- it is labelled NET Los/Dr

 

[ukmikeb]

Hi

I've had a closer look at the TeamRankings website and it appears that it uses javascript, such that the data within the web pages can't be accessed through the HTML commands.

I mentioned a way of copying the whole of the webpage text to another user in this thread :-
http://www.mrexcel.com/forum/excel-...wser-displays-not-source-html-into-sheet.html
possibly you could adapt that to your need.

hth