It is currently Sat Feb 24, 2018 4:54 am


All times are UTC - 7 hours




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: Target% & Other Kinda Cool Stuff
PostPosted: Thu Jan 18, 2018 7:46 pm 

Joined: Wed Nov 05, 2014 11:40 am
Posts: 308
This came up during the Staff Draft and figured I woudl share:

- Download GStelmack's suite https://forums.operationsports.com/fofc ... hp?t=92316

- Use the Interrogator to generate the following files: player_season_extra_[year], game_information_extra, and drive_results
***the only one I give a damn about is player_season_extra_[year]
they shoudl be at C:\Users\[USERNAME]\AppData\Local\Solecismic Software\Front Office Football Eight\leaguedata\00856001

- I personally only look at my own team, so the next step is to get rid of all the rows that aren't my squad, the easiest way is column O of team_information
OR
Just filter to just your team_ID and copy to another book

Cool so check out this dope shit here. By game it compiles double-coverage stuff, tackles and run for a loss, targets (not sure how it calculates this) and 20+ yard plays.
I also delete weeks -4 to 0 which are preseason as well as any other weeks I don't want to evaluate (i.e. when playing backups)

You likely will want to do a VLOOKUP to the player_information file to get last name and position. And then do some pivot tables, here are some examples:
Row Labels TKL for LOSS RUN PLAYS asst TKL for LOSS plays--- plays+++ OVR--- TckLoss%
Bouchette 9 142 1 29 330 8.10% 6.70%
Brophy 6 204 0 56 503 10.00% 2.90%
Chepaitis 7 159 1 29 305 8.70% 4.70%
Hasselbeck 0 0 0 0 0
Konrad 5 213 0 47 489 8.80% 2.30%
McWilliams 12 434 2 93 968 8.80% 3.00%
Grand Total 39 1152 4 254 2595 8.90% 3.60%

Row Labels Sum of HasKeyCoverage Sum of ThrownAt Sum of ReceptionsOf20YardsPlusGivenUp Sum of DefensivePassPlays Sum of DefensiveRunPlays Sum of MinusPlays Sum of PenaltiesCommitted %Key %Target/Key 20+/Target OVR---
Dubord 19 18 2 141 82 18 0 13.5% 94.7% 11.1% 8.1%
Finley 45 35 5 396 192 53 4 11.4% 77.8% 14.3% 9.0%
Lindsay 63 48 11 556 334 66 2 11.3% 76.2% 22.9% 7.4%
Serra 29 25 2 268 170 25 1 10.8% 86.2% 8.0% 5.7%
Grand Total 156 126 20 1361 778 162 7 11.5% 80.8% 15.9% 7.6%

_________________
------------------
Fargo Sodbusters


Top
Offline Profile  
 
 Post subject: Re: Target% & Other Kinda Cool Stuff
PostPosted: Thu Jan 18, 2018 7:48 pm 

Joined: Wed Nov 05, 2014 11:40 am
Posts: 308
Player_record also has combine info for the other comparison we were talking about

_________________
------------------
Fargo Sodbusters


Top
Offline Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ]  Moderators: Taco, JJ Smitty

All times are UTC - 7 hours


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
Theme created StylerBB.net