Jump to content
  • Welcome!

    Register and log in easily with Twitter or Google accounts!

    Or simply create a new Huddle account. 

    Members receive fewer ads , access our dark theme, and the ability to join the discussion!

     

How I calculate the Panthers offseason needs... and proof I have no life...


Recommended Posts

I mentioned my "spreadsheets" in another thread, and figured it'd be cool to share some of my formulas for predicting the Panthers' offseason movement...

I've been doing this since around 2007 in some form, and each year I try to refine the formulas I use... Yes, I am a nerdy Panthers fan, but it helps me anticipate things and keeps the team on my mind when they aren't doing much else...

Keep in mind that this is all opinion, and actual outcomes may not resemble my predictions (especially considering my ultimate failure on the Peppers situation)... But, at least in the draft the past few years, I have been pretty spot on for our positional needs...

Let's get to it...

The first step I take is listing the current roster in groups by position, the player's age, and assign them a numerical "rating" generally between 5 and 10. A player given a 5 is considered "unexperienced" or "rookie," while a 10 would mean that the player is in the top 3 at their position in the entire NFL. I don't really fine tune these ratings enough to have crazy decimal points or anything, and if a player is between a pair of numbers, they get a .5 (EX. Someone is a solid 6, but not yet a 7, they get a 6.5)...

After the players are listed, I make note of players I don't think will make the opening day roster, as well as players who are currently tendered RFAs. The players I don't think will make the final cut or will be signed by another team as RFas are not factored in in any of the formulas that follow...

For each position, I average the ratings of the players I suspect will be on the final roster this upcoming season. Again, this average excludes players I don't think will make or be on the final roster.

Once I have the entire roster listed, and the players' age and each position's average rating, it is time to move on to the next section of the sheet.

I assign to each position something I call the "Depth Index." This number is a simple look at how deep we are at each position. If we have one starter and one backup for the position, it is given a value of 1. For each additional backup, I assign a .1. For instance, we currently have four RBs on the roster, all of which I feel will make the final cut at this point. This position has a Depth Index of 1.2, as we have the starter, the backup, and two additional backups.

Some positions have more than one starter required in certain circumstances or formations. WR is an example, as I count 3 WRs as the requirement for starters. DT is similar in that I require 3.

In the case of a position which only has enough depth to fulfill the need for a starter, I identify this position as having a "hole." This position then carries a Depth Index of .75 which represents a glaring need in depth.

Once I have the Depth Index for each position, I multiply that number times the average rating, times .1. This gives me a column which I have a percentage labeled "Quality." This column represents overall quality of the position on the roster from both a talent and depth standpoint.

When the Quality percentage is obtained, I move to the next section...

In this next section, I again list each position in its own column. There are then columns for Median Age (this is just for comparison's sake, it has no bearing on any formulas), Importance, Quality, Importance x Quality, Importance - (Importance x Quality), and then Needs Attention... Sound confusing? It isn't really...

First off, you assign a position Importance based on how important the position is in our overall sceme. 18 is the most important, while 1 is the least. Each has one number and each number is used only once.

On my latest rankings, I have applied the following Importance ratings:

RB - 18

OT - 17

MLB -16

DE - 15

G - 14

OLB - 13

QB - 12

WR - 11

DT - 10

C - 9

FS - 8

CB - 7

TE - 6

SS - 5

FB - 4

K - 3

P - 2

LS - 1

I then multiply those numbers by the Quality colum (this is the Quality percentage from the previous section... The result goes into the Importance x Quality column...

Then, you go back and subtract the number in the Importance x Quality column from the Importance column... The result goes into the Importance - (Importance x Quality) column...

Once you have those numbers in Importance - (Importance x Quality), you assign them a number from 1 - 18, 1 being the highest number and 18 being the lowest... This assignment goes in the Needs Attention column...

After you have the Needs Attention numbers, you can consider this to be the Panthers' biggest needs, in order, this offseason...

In the following post in this thread, I will give you the hard numbers I entered in for each player and position, and the results I came up with at this point in the offseason...

Link to comment
Share on other sites

Attached are screenshots from my sheets that I have described.

To explain the different numbers in the Pos. Avg. columns...

Where you see a player's name in orange, that means I do not expect that player to make the final roster. I did however count them in an overall average of the position, but the numbers I used in my formulas are the ones above them... which represent averages for the players not in orange...

In the case of CB, the number beside Marshall is the average of the unit if he stays with us and we don't lose him to someone else (thus gaining a 2nd round pick)... For the later sheets, I did not include him as I feel we will let him walk (if someone makes him an offer)... For CB, I used the number beside C.J. Wilson, which is the average for him, Munnerlyn, and Gamble...

post-509-133194773612_thumb.jpg

post-509-133194773615_thumb.jpg

post-509-133194773618_thumb.jpg

post-509-13319477362_thumb.jpg

post-509-133194773622_thumb.jpg

Link to comment
Share on other sites

Wow, I'm impressed.

The only thing I didn't see in your formulas was anything to do with draft status and contracts for current players. The reason I mention this is because it has seemed that in the past the Panthers do try to hold onto their draft picks and will give them time (the length of their contract) to prove themselves. And of course I mentiont he contracts because contracts do come into play from time to time in the NFL. Although, I currently don't see that being an issue anywhere on the Panther's roster. I only mention it for future calculations.

Link to comment
Share on other sites

With the release of Hoover, FB moves up a few notches, mainly because of depth...

OLB

WR

DE

QB

MLB

G

DT

CB

FS

FB

SS

C

OT

RB

TE

K

LS

P

Also, for informational purposes, I am counting only 41 people currently on the Panthers' roster that are capable of making the final roster... That is at least 12 people we need to sign/draft for those of you that are keeping up with it... There are 13 others on the roster right now, bringing the team's total to 54...

Link to comment
Share on other sites

I seriously don't get how MLB is listed that high. I don't think you can find a 4-3 team in the entire league with a better depth chart than Beason/Connor.

OLB too, we have our starters already, all we need is depth. It's a need but I don't see how it's #1.

Link to comment
Share on other sites

I seriously don't get how MLB is listed that high. I don't think you can find a 4-3 team in the entire league with a better depth chart than Beason/Connor.

OLB too, we have our starters already, all we need is depth. It's a need but I don't see how it's #1.

I think he is going by if Connor is moved to SLB...we then have no one but beason at MLB. Depth...

Link to comment
Share on other sites

I think he is going by if Connor is moved to SLB...we then have no one but beason at MLB. Depth...

OLB: Thomas Davis, James Anderson

MLB: Jon Beason, Dan Connor

That is 4 guys for a rotation of 3 starting spots... Remember our DT situation last year? Imagine if for some reason we lost Davis and Beason for a several game stretch...

We have the following backups who are mainly special teamers, and which may not even make the final cut (depending on if we sign any FA LBs or draft some):

Quinton Culberson, Mortty Ivy, Jordan Senn, Brett Warren

I am NOT comfortable with any of those guys being our starting LB in any position for an extended amount of time...

We almost have to sign at least one LB free agent, and even if we do, drafting one very early on is a highly likely event...

Link to comment
Share on other sites

BUMP!

After Wright, Petitti, and Hudson, our needs remain relatively unchanged... with CB sliding down the list a little...

OLB

WR

DE

QB

MLB

G

DT

FS

FB

CB

SS

C

RB

OT

TE

K

LS

P

We now have 44 people I expect to make the final cut, with 13 others I don't expect to see...

That leaves room for 9 more players... We currently have 5 draft picks with an expected award of at least 2 compensatory picks, so that is 7 rookies... I expect to acquire another 2nd for Marshall eventually, and possibly trade next year's first for another 2nd... That'd be 9 rookies to fill the 9 more players...

Gosh, I get more excited this time of the year than I do at Xmas...

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.


  • PMH4OWPW7JD2TDGWZKTOYL2T3E.jpg

  • Topics

  • Posts

    • It's a decent vid with compelling reasons for his opinion. But, my thing is is that you simply can't draft McMillan thinking he is a surefire WR1. There are questions. His 40---rightly or wrongly---will play a part. I'd think that his splits (which will speak more to his game translating to the pros in my mind) are more important.  As much as you're trying to sell us that McMillan is a don't-overthink-it-type-of-player, I wouldn't say that's the case. Workouts will play a part in all of this.  At this point, I like the thought of Tetairoa. That's as much as I can give you right now.
    • If Canales has helped Bryce a “poo ton” and this is what we have then what’s the fuging point? And the offense wasn’t humming with Dalton in there either, except against the raiders who’ll likely be firing their coach after this season.  XL is probably the fourth best looking receiving option on the team right now behind thielen, Coker, and sanders. I don’t think anyone would disagree with that. Who cares about total receiving yards when everyone else has missed time and there’s like 180 yards of receiving a game to go around   and lmao they were “believing” shut the fug up. They lost and for the most part those games were all the defense shutting down the other team. The chiefs turned around and gave up an actual impressive stat line to Aiden O’Connell and I not even the most delusional raiders fans think that means anything. Bryce did nothing against the eagles, the Bucs are a mash unit, and any one of us could have done that Bryce did against the giants and saints.  And as far as who they’d get, they didn’t have any trouble hiring the guy you’re tripping over yourself to defend. They also could have hired Dan Quinn, who’s actually succeeding with a young qb.  And people are acting like the risk of getting paid for not working for five years is a negative. Canales is going to spend the next half a decade getting paid to watch porn in his Bible camp office.
    • the Dallas game definitely quelled the hype. his biggest issue will always be his size, and that shows when he gets sacked. he's simply not big or strong enough to protect the ball. even in the KC game, he fumbled it on a basic sack and thank god icky landed on it. INT's are going to happen, most fans don't understand that tipped balls and wrong routes account for most interceptions. but the wet-bar-of-soap type fumbles upon contact are a huge reg flag. the common theme with players like Darnold and Mayfield who previously played for us and are now excelling makes me want to practice patience more when it comes to the QB position. I think Bryce bought himself another season, perhaps with more weapons. I do like the idea of adding a QB whether that's a FA or mid round rookie. if the same mistakes occur next season and we see no further growth or most importantly, wins, then it will be time to move on. just a quick reminder though, football is not an individual sport. QB is just one position, albeit the most important. 
×
×
  • Create New...