It is currently Thu Mar 28, 2024 11:47 am

All times are UTC-07:00




Post new topic  Reply to topic  [ 2 posts ] 
Author Message
PostPosted: Thu Jan 18, 2018 7:46 pm 
Offline
User avatar

Joined: Wed Nov 05, 2014 11:40 am
Posts: 850
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
GM since 2041
17 Division Titles
3-1 Bowls (2056, 2061, 2064, 2065)


Top
   
PostPosted: Thu Jan 18, 2018 7:48 pm 
Offline
User avatar

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

_________________
------------------
Fargo Sodbusters
GM since 2041
17 Division Titles
3-1 Bowls (2056, 2061, 2064, 2065)


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic  [ 2 posts ] 

All times are UTC-07:00


Who is online

Users browsing this forum: Ahrefs [Bot], Semrush [Bot] and 16 guests


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

Jump to:  
Powered by phpBB® Forum Software © phpBB Limited