Jump to content
Sign in to follow this  
bruddog

Team matchup sheet for new players

Recommended Posts

Ok I refined a few things to include all OL HP vs all front 5 defender HP and user DL. Feel free to make your own custom changes to the grades.  This should account for many of the subtler parts of matchups but maybe not all of them. 

 

image.thumb.png.62ff1e99a23c54fc928db33c3e5f14ed.png

 

 

 

Share this post


Link to post
Share on other sites
26 minutes ago, bruddog said:

Ok I refined a few things to include all OL HP vs all front 5 defender HP and user DL. Feel free to make your own custom changes to the grades.  This should account for many of the subtler parts of matchups but maybe not all of them. 

 

image.thumb.png.62ff1e99a23c54fc928db33c3e5f14ed.png

 

 

team_tiers_OG.xlsx

 

 

Keep going! Add some WR vs DB calcs!

Share this post


Link to post
Share on other sites

is something like this 

 in the sheets?

 

for example, for a given team take the qb PC and the best wr REC and show the int and completion stuff,  that knobbe asks about, for the given defense.

 

syntax error>?  anyways, something that will show the "safe" (or "unsafe") combinations

Edited by buck

Share this post


Link to post
Share on other sites

Some stuff looked wrong again. Google sheet updated

 

1. Downgrade QB run values by 1

2. Increased value of JJ pick mismatch by 1

3. Doubled DL popcorn value if on interior (RE,NT,LE)

4. Added special condtional for best/only DB at bottom CB/DB4 (this applied to DET, MIN, CIN,WAS,NE...SD has seale and SF has LOTT...torn on WAS as Green only has 44int. 

5. Added extra special conditional for CIN vs DET to remove the penalty since fulcher can pop everyone. 

 

team_tiers_OG_3.xlsx

Share this post


Link to post
Share on other sites

I like it, dude.  It seems like the team rankings that conclude in "TOTAL" are consistent with how I "perceive" the rankings to be (gut feelings, experience, etc).  

 

But, where do some of the cells like "44 PC or lower" come into play?  is this just a logical 1, like a switch, used for something else?

Share this post


Link to post
Share on other sites
1 hour ago, buck said:

I like it, dude.  It seems like the team rankings that conclude in "TOTAL" are consistent with how I "perceive" the rankings to be (gut feelings, experience, etc).  

 

But, where do some of the cells like "44 PC or lower" come into play?  is this just a logical 1, like a switch, used for something else?

I edited my first post  to explain most of the sheet. Its used in a threshold check to see if one team can jump intercept another and vice verse. 

 

+1 for a 3 notch difference 

*2 for a 4 or more notch difference

 

So like was vs min both teams get a +2 (44 pc vs 69 int) and thus they cancel out and the bonus is not applied to either team. 

Share this post


Link to post
Share on other sites
On 9/11/2017 at 2:15 PM, bruddog said:

This a matchup spreadsheet that attempts to provide a rating and matchup analysis for any two teams chose

 

EXCEL SHEET:  team_tiers_OG_3.xlsx

Google Sheets: https://docs.google.com/spreadsheets/d/1w0sntWyYUWOZ0xVncnGATONP57lnqFUZuIhDgYoh2Z8/edit#gid=626874606 

 

OFFENSE

 

QB RUN = Rating given based on QB's max speed. Fast QB's are tough to stop without a LB to help spy. They can often grind out first downs as you are forced to choose between going after the QB or leaving a man open. 

 

RUN = Rating given based on RB's max speed. Special exception given to Okoye's 94HP which makes him as dangerous as 63MS player vs weak HP secondaries.  

 

PASS = Rating given to teams passing game QB + WRS

***************************************************************************************************************************************************************************************************

DEFENSE

 

F5Pop = Bonus pts given if the DL HP vs Ol HP differential is enough for the DL to break through the OL instantly making running and passing tougher.  Double points if it comes from the interior.

 

LB = Grade given to entire unit based on all ratings but HP 

 

DB = Grade given to entire unit based on all ratings but HP 

***************************************************************************************************************************************************************************************************

SPECIAL

 

JJ Mismatch = If one team has a player whose int rating is at least 3 skill notches (example 69 int vs 50 pc)  they will have a 50% chance of jumping to intercept the pass if they are in the right place. If its 4 notches or greater they will have a 100% chance of jumping to intercept the pass if they are in the right place. 1 bonus pt given for a 3 notch difference. 2 Bonus pts given for a 4 or more notch difference. 

 

94 HP Blocker = Putting a 94 HP blocker at TE vs a 44HP or less bottom LB  (50 HP differential) can help greatly as on one of the best runs in the game(Run 3 R&S sweep down) the LB will get popped giving you an extra blocker in the way allowing you to get some extra yards. 1 pt given for this mismatch.

 

***************************************************************************************************************************************************************************************************

OTHER

 

LB4 = Having a good player at this position helps defeat a number of runs fairly easily by diving right after the snap at the RB or by grappling the blocker immediately and then outtapping the RB. 1 pt given for a good player here.

 

RCB/FS = These are good positions to have for stopping run plays and not being in the way of power running plays to the bottom. 1 pt given for a good player here. The can also provide coverage vs the best WR's as the best WR is often put at the top of the screen. 

 

DL use = This has a number of conditional checks but if a team has no LBs and/or they are playing a bad QB selecting a DL can be useful to help maximize your coverage. Especially if you know a pass is coming (aka shotgun). Especially useful vs the redgun and weak QB's if you have no LB's to use. 

 

DB vs run = in somewhat opposite fashion a penalty is given if your best DB is at bottom CB or SS or if your only good player is at CB as a good run game can really neutralize the effectiveness of using that player by running all of their runs to the bottom. Penalty ranges from -1 to -2 depending on the strength of the run game of the team faced. Special exception in CIN vs DET matchup with Fulcher being able to popcorn everyone on DET. 

 

KR = 1 pt given to the return game of PIT and 2 to NO since they can put a 94HP returner there. 

***************************************************************************************************************************************************************************************************

 

OFF= Off total score

DEF= DEF total score

OTH = other total score

SP= special total score.

***************************************************************************************************************************************************************************************************

SPECIAL INFORMATION

 

Coverage catch tables of best qb and best wr vs (19int lb,best db and worst Db have been provided so you can see how much of a mismatch you are at there). These percentages only apply

when the WR doesn't jump or dive and there is only one defender covering.  *****A defender may appear to be in coverage but if the game doesn't determine him to be in on the play when the pass is 1/4 of the way he will have no effect on the outcome of the pass*****

 

OL vs front 5 HP matchup 

 

***************************************************************************************************************************************************************************************************

image.thumb.png.c8c2319696c5163a97451cbd3138789f.png

 

just quoting this for the page 2.  Great breakdown Bru

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

×