http://www.thecfl.us/forum/ |
|
| Target% & Other Kinda Cool Stuff http://www.thecfl.us/forum/viewtopic.php?t=9093 |
Page 1 of 1 |
| Author: | Ushikawa [ Thu Jan 18, 2018 7:46 pm ] |
| Post subject: | Target% & Other Kinda Cool Stuff |
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% |
|
| Author: | Ushikawa [ Thu Jan 18, 2018 7:48 pm ] |
| Post subject: | Re: Target% & Other Kinda Cool Stuff |
Player_record also has combine info for the other comparison we were talking about |
|
| Page 1 of 1 | All times are UTC-07:00 |
| Powered by phpBB® Forum Software © phpBB Limited https://www.phpbb.com/ |
|