Patriots Heat Map

[cstjohn17]

I developed a spreadsheet that uses a color coded map (red, yellow, green) to indicate where the roster needs help. The goal of the offseason is to move the reds to yellow and yellows to red. It is in a rough state, once it is a little more solid I will post the Excel file.

So about a month away from the draft I see the Patriots roster looking like this.

Rant - The attachments settings on the board are pretty rough. I have to scroll for an hour because of the gapped tooth photos people post as their signature. Then I try to post a simple .jpg and it re-sizes it to hell.

 

[NePatriots]

Love it... maybe add a blue or lighter green to make the difference between Brady/Moss and the 7's a little starker?

 

[cstjohn17]

Love it... maybe add a blue or lighter green to make the difference between Brady/Moss and the 7's a little starker?

I was thinking of some sort of animation for Brady and Moss but I am not that smart..

 

[Handel]

I developed a spreadsheet that uses a color coded map (red, yellow, green) to indicate where the roster needs help. The goal of the offseason is to move the reds to yellow and yellows to red. It is in a rough state, once it is a little more solid I will post the Excel file.

So about a month away from the draft I see the Patriots roster looking like this.

Rant - The attachments settings on the board are pretty rough. I have to scroll for an hour because of the gapped tooth photos people post as their signature. Then I try to post a simple .jpg and it re-sizes it to hell.

Thanks..

I invite you to discover Box.net. (online stockage with sharing possibilites))

 

[ctpatsfan77]

One minor thing--"Open" should not count as filling a roster position. /

 

[p8ryts]

Very interesting. Opens a lot of discussion areas. I wonder about grades for people such as Izzo and Alexander, is the value based on special teams or ability to back up the position. Great job. I would put Lonnie Paxton higher. I think he is vastly underrated. His snaps are unerringly accurate and almost never off target.

 

[BradyManny]

One minor thing--"Open" should not count as filling a roster position. /

Great spreadsheet. My one comment would be that, personally, I would have Meriweather penciled in at starting FS with a solid grade. He started the Super Bowl and played well down the stretch. I expect him to start and play really well next season.

 

[NePatriots]

Very interesting. Opens a lot of discussion areas. I wonder about grades for people such as Izzo and Alexander, is the value based on special teams or ability to back up the position. Great job. I would put Lonnie Paxton higher. I think he is vastly underrated. His snaps are unerringly accurate and almost never off target.

The fact that most casual fans don't know him speaks volumes about his worth.

 

[cstjohn17]

Great spreadsheet. My one comment would be that, personally, I would have Meriweather penciled in at starting FS with a solid grade. He started the Super Bowl and played well down the stretch. I expect him to start and play really well next season.

I will post the spreadsheet after I work out the kinks, then everyone can modify to their hearts content. As for Merriweather, I think he will be a solid pro but unless he improves those pieces of brick at the end of his arms he will never be a playmaker.

As for the Superbowl, I may have it wrong but I thought Sanders and Harrison started. Then Harrison got banged up for a stretch and Eugene Wilson stepped in (pretty sure they blitzed Wilson the first play he came in, but of course Wilson missed the tackle). In the final drive Meriweather missed an easy INT and then got caught up in traffic on a crucial 3rd and 12. But with Harrison getting up in years I could see a rotation at Safety.

I would like to see the Pats lock up Sanders before he becomes a free agent. He has gotten better each year, would be cheap, can play both safety spots and is young. He may never be an all pro but could be a steady solid player.

 

[cstjohn17]

Here is the post draft heatmap (Excel file within zip). Feel free to apply your rankings to the players to see if it changes anything.

Analysis - Very solid across the board at all starting positions, serious unknowns at the most backup positions. The team is a top contender for a title run but is not as dominant as the 2007 team.

Based on Miguel's roster page as of 5/10/08
http://www.patscap.com/patriotsroster.html

Known bugs
- the final two TEs (Stupar & DeVree) were placed in as the 3rd and 4th FBs because I ran out of room at TE (only 4 slots per position)

 

[PonyExpress]

Great job! This would make a good sticky, and you could keep updating it throughout the season.

Just a couple points... Not sure I would label Sanders or Hobbs, given his injury status, "above average" at this point. These are obviously minor quibbles, and the scores are totally subjective. As a concept it is useful and fun to look at.

 

[VJCPatriot]

Moss only gets a score of 9? He's the best WR in the NFL...
BTW I noticed that you only have 2 guys on our entire roster ranked as at least pro bowl rating when I think the Pats sent 8 guys to the pro bowl last year? LOL at Alexander slotted as starting ILB, that's Mayo's spot.

 

[DaBruinz]

Here is the post draft heatmap (Excel file within zip). Feel free to apply your rankings to the players to see if it changes anything.

Analysis - Very solid across the board at all starting positions, serious unknowns at the most backup positions. The team is a top contender for a title run but is not as dominant as the 2007 team.

Based on Miguel's roster page as of 5/10/08
http://www.patscap.com/patriotsroster.html

Known bugs
- the final two TEs (Stupar & DeVree) were placed in as the 3rd and 4th FBs because I ran out of room at TE (only 4 slots per position)

A few things. I think that you are unfairly harsh on guys like Hochstein and Yates. They are average players.

Also, since when is Mike Richardson a SS? He's a CB in every sense of the word.

Also, how is it that you mark Izzo as average when he sucks as a back-up LB and really is only a special teams maven, but then you kill Alexander, Woods, and Andrews for being special teams players?

Also, how is it that you have Hobson as below average? The guy was a very solid player for the Jets. To say that Crable is above him on the depth chart is being a tad presumtuous on your part. Also, its more likely that Hobson will be at ILB and not OLB for the Pats.

 

[cstjohn17]

A few things. I think that you are unfairly harsh on guys like Hochstein and Yates. They are average players.

Also, since when is Mike Richardson a SS? He's a CB in every sense of the word.

Also, how is it that you mark Izzo as average when he sucks as a back-up LB and really is only a special teams maven, but then you kill Alexander, Woods, and Andrews for being special teams players?

Also, how is it that you have Hobson as below average? The guy was a very solid player for the Jets. To say that Crable is above him on the depth chart is being a tad presumtuous on your part. Also, its more likely that Hobson will be at ILB and not OLB for the Pats.

Step 1 - Download file.
Step 2 - Update as you like.
Step 3 - Cram it up your obnoxious ass.

In any order you like.

 

[cstjohn17]

Great job! This would make a good sticky, and you could keep updating it throughout the season.

Just a couple points... Not sure I would label Sanders or Hobbs, given his injury status, "above average" at this point. These are obviously minor quibbles, and the scores are totally subjective. As a concept it is useful and fun to look at.

I have no plans to update the file, I am checking out until August. In general the roster is unlikely to change very much now that the draft is over. The file was posted as part of the public domain. Hopefully people use it and improve it, it is a pretty weak model at this point.

See you all at training camp.

 

[PatsWickedPissah]

Step 1 - Download file.
Step 2 - Update as you like.
Step 3 - Cram it up your obnoxious ass.

In any order you like.

Ones & zeros don't hurt craming up my ass!

Nya! Nya!

 

[DaBruinz]

Step 1 - Download file.
Step 2 - Update as you like.
Step 3 - Cram it up your obnoxious ass.

In any order you like.

WOW.. You are so intelligent.. I mean, you really showed me. YEAH.. NOT

If you don't like people putting up comments, don't post.

All I did was call into question your method for analysis which seemed to be all over the place and not consistent.

There was nothing obnoxious about my post. Sorry that you are such an ass that you thought so.

 

[BRiZ]

HC Belichick 10

QB Brady 10
RB LMoney 8
FB Evans 7
3RB Faulk 8
RWR Moss 10
LWR Jackson 8
SWR Welker 9
TE Watson 8
LT Light 7
LG Mankins 9
OC Koppen 8
RG Neal 7
RT Kazcur 6

OLB Thomas 8
RDE Seymour 10
NT Wilfork 9
LDE Warren 8
OLB Vrabel 7
ILB Mayo 9
ILB Bruschi 6
LCB Law 7
FS Meriweather 9
SS Harrison 10
RCB Hobbs 7
NCB Wheatley 8

P Drago 7
K Ghost 8
PR Welker 8
KR Slater 8

Word

 

[Ochmed Jones]

Also, how is it that you mark Izzo as average when he sucks as a back-up LB and really is only a special teams maven, but then you kill Alexander, Woods, and Andrews for being special teams players?

Looking at the tape of the Pats games, I think a case can be made that Izzo is slowing down and I'm not sure he still qualifies as a ST demon. (Still above average, just not a demon any more) He got blown up on a couple of returns that I don't think he would have been a couple of years ago.

 

[jct]

Great Tool.
Nice Job.
Team looks great...
My only thoughts on this is Vrabel higher and Heath Evans LOWER.