FOF Utility: Situational Quarterback Stats

[primelord]

Some of you might remember I started developing a utility to track situational stats in FOF2001. I abondoned that due to a lack of time and the fact that dealing with penalties was driving me nuts. However I picked the project back up recently and I think I have it all working for track QB siuational stats now. Here is an example of the output from my IHOF QB last season.

 Category                Att    Cmp    Pct    Yards   Avg   Lng  TD    Int   +20   +40   1stDwn  Sack  Yards   Rate

 --------------          -----  -----  -----  ------  ----  ---  ----  ----  ----  ----  ------  ----  -----   -----

 Total                   275    169    61.5   1584    5.76  54   6     11    10    4     83      18    108     67.9

 Home                    135    82     60.7   791     5.86  50   2     5     6     1     40      9     54      66.6

 Away                    140    87     62.1   793     5.66  54   4     6     4     3     43      9     54      69.1

 

 Grass                   241    149    61.8   1425    5.91  54   5     9     9     4     74      17    103     69.6

 Turf                    34     20     58.8   159     4.68  24   1     2     1     0     9       1     5       55.9

 Outdoor                 275    169    61.5   1584    5.76  54   6     11    10    4     83      18    108     67.9

 

 Fair                    245    153    62.4   1436    5.86  54   6     9     9     4     76      16    97      71.4

 Rain                    30     16     53.3   148     4.93  33   0     2     1     0     7       2     11      39.3

 Cold                    23     17     73.9   131     5.70  15   1     0     0     0     12      2     13      101.9

 Mild                    131    76     58.0   767     5.85  54   1     5     4     2     36      10    58      61.5

 Warm                    121    76     62.8   686     5.67  47   4     6     6     2     35      6     37      68.4

 

 First Quarter           52     31     59.6   246     4.73  16   1     3     0     0     12      4     24      53.8

 Second Quarter          62     39     62.9   356     5.74  47   2     1     3     1     22      9     55      82.5

 Third Quarter           71     53     74.6   456     6.42  54   0     2     1     1     27      2     13      79.3

 Fourth Quarter          90     46     51.1   526     5.84  50   3     5     6     2     22      3     16      57.0

 First Half              114    70     61.4   602     5.28  47   3     4     3     1     34      13    79      69.4

 Second Half             161    99     61.5   982     6.10  54   3     7     7     3     49      5     29      66.8

 

 First Down              64     42     65.6   433     6.77  46   2     2     4     1     13      5     32      82.4

 Second Down             104    56     53.8   567     5.45  54   2     8     4     3     26      6     35      44.0

 Third Down              104    69     66.3   557     5.36  33   2     1     2     0     43      7     41      82.1

 Fourth Down             3      2      66.7   27      9.00  18   0     0     0     0     1       0     0       95.1

 

 First & 3-7             2      2      100.0  9       4.50  6    2     0     0     0     0       0     0       125.0

 First & 8-10            57     36     63.2   396     6.95  46   0     2     4     1     13      5     32      69.0

 First & 11+             5      4      80.0   28      5.60  12   0     0     0     0     0       0     0       90.0

 Second & < 3            1      0      0.0    0       0.00  0    0     0     0     0     0       1     5       39.6

 Second & 3-7            37     19     51.4   250     6.76  50   1     4     3     2     16      2     10      42.5

 Second & 8-10           49     27     55.1   237     4.84  54   1     3     1     1     8       2     17      49.4

 Second & 11+            17     10     58.8   80      4.71  14   0     1     0     0     2       1     3       46.2

 Third & < 3             2      1      50.0   9       4.50  9    0     0     0     0     1       0     0       62.5

 Third & 3-7             59     40     67.8   315     5.34  33   1     0     1     0     33      3     14      86.5

 Third & 8-10            31     21     67.7   193     6.23  22   1     1     1     0     9       1     8       81.8

 Third & 11+             12     7      58.3   40      3.33  8    0     0     0     0     0       3     19      64.6

 Fourth & 8-10           2      1      50.0   9       4.50  9    0     0     0     0     0       0     0       62.5

 Fourth & 11+            1      1      100.0  18      18.0  18   0     0     0     0     1       0     0       118.8

 

 Category                Att    Cmp    Pct    Yards   Avg   Lng  TD    Int   +20   +40   1stDwn  Sack  Yards   Rate

 --------------          -----  -----  -----  ------  ----  ---  ----  ----  ----  ----  ------  ----  -----   -----

 AOC                     217    133    61.3   1244    5.73  54   5     9     8     3     65      14    85      67.4

 NAC                     58     36     62.1   340     5.86  50   1     2     2     1     18      4     23      69.6

 Northeast               68     44     64.7   381     5.60  32   2     1     1     0     24      5     31      83.0

 Southeast               24     18     75.0   121     5.04  12   1     1     0     0     6       2     9       82.1

 European                125    71     56.8   742     5.94  54   2     7     7     3     35      7     45      56.1

 Atlantic Coast          58     36     62.1   340     5.86  50   1     2     2     1     18      4     23      69.6

 

 Bordeaux                36     23     63.9   212     5.89  39   1     2     3     0     12      1     7       66.0

 Georgia                 24     18     75.0   121     5.04  12   1     1     0     0     6       2     9       82.1

 Gothenburg              32     17     53.1   188     5.88  54   0     2     1     1     8       2     11      44.8

 Maassluis               27     15     55.6   194     7.19  47   1     1     2     2     8       2     16      75.2

 Miami                   24     16     66.7   181     7.54  50   0     0     1     1     9       3     18      89.1

 North Plainfie          21     14     66.7   96      4.57  11   0     0     0     0     5       1     4       76.7

 Outer Banks             34     20     58.8   159     4.68  24   1     2     1     0     9       1     5       55.9

 Paris                   30     16     53.3   148     4.93  33   0     2     1     0     7       2     11      39.3

 Rochester               23     17     73.9   131     5.70  15   1     0     0     0     12      2     13      101.9

 Syracuse                24     13     54.2   154     6.42  32   1     1     1     0     7       2     14      70.5

I actually have two versions of this code. One that works with logs that were created before the expanded info was added and one that doesn't. The version that works with the expanded game logs will also track info such as how the QB performed against the blitz and in various formations etc. I am going to release both versions in case people want stats from their old game logs.

I still have some development to do, but I'd imagine I will be ready to release this by early next week at the latest. While I am still adding code are there any suggestions people would like to make? Per some suggestions at IHOF I am going to add tracking for bad passes, dropped balls, and hurries. I think I am also going to add the ability to output to an HTML table and to a csv file. Anything else people would like to see in a utility like this. Now is the time to ask.

[dacman]

**runs for kleenex**

[3ric]

He-he, only 53.1% completions vs Gothenburg. Excellent.

Seriously, this looks great! HTML output would be awesome.

[primelord]

dola,

I am also planning on making the utility eventually track RB and WR/TE stats as well, but that may be awhile down the road still.

[DaddyTorgo]

Wow. That would truly be amazing primelord. Brings a whole nother dimension to the game!

[jbmagic]

wow ..that so awesome


maybe color, to make it easier to read like every other line


i would love to see it for RB, TE/WR too, etc

[FBPro]

And he's too scared to play RayCo.

[gstelmack]

Originally Posted by primelord

I abondoned that due to a lack of time and the fact that dealing with penalties was driving me nuts.

Hehe, I'm pretty close to releasing a utility that converts game logs to CSV files that are easier to process and give you a way to see what plays your team is calling in what situations, and the penalties are my big obstacle right now, too...

[primelord]

Originally Posted by gstelmack

Hehe, I'm pretty close to releasing a utility that converts game logs to CSV files that are easier to process and give you a way to see what plays your team is calling in what situations, and the penalties are my big obstacle right now, too...

Yeah the penalties suck although I am 99.9% certain I have them all handled properly now. If you want some help working through them PM me and we can discuss how I implemented it.

[flere-imsaho]

Originally Posted by dacman

**runs for kleenex**

Totally. I think I just wet myself.

[wishbone]

Is there a way to show stats based on the type of pass coverage the defense used?

[NYFAN]

is this for fof2k4 too?

[Icy]

Awesome info to compare your QB perfomances when both put same overal numbers, bt some are better for some play style or vs some style opponent, really awesome tool. Thanks a lot Primelord.

[primelord]

Originally Posted by wishbone

Is there a way to show stats based on the type of pass coverage the defense used?

There will be in the version that supports the new game log formats.

[primelord]

Originally Posted by NYFAN

is this for fof2k4 too?

Heh I guess I should have made that clearer. This is only for FOF2k4. I had originally started on the concept for FOF2001, but never finished that. This was written to work with FOF2k4.

[Eaglesfan27]

Excellent news. Thanks for making this Primelord.

[NYFAN]

sweet, actually i didn't pay close attention and i saw "syracuse" and thought it was for tcy

[wishbone]

Originally Posted by primelord

There will be in the version that supports the new game log formats.

Awesome, this tool rocks and I haven't even used it yet.

[primelord]

Bump to see if anyone else had suggestions.

[gottimd]

Great work. Out of curiousity, on the Output it only shows 10 teams, will it show all teams? What happens if a team name changes, or location changes?

WooHoo, I'm a rookie now!

[Icy]

Well Primelord, just to give you some more work what about tracking passes sent to each receiver, drops, yards etc etc? that way we can know the best QB<->receiver relationship.

[primelord]

Originally Posted by gottimd

Great work. Out of curiousity, on the Output it only shows 10 teams, will it show all teams? What happens if a team name changes, or location changes?

WooHoo, I'm a rookie now!

The utility only shows the output for sitautions where a pass was attempted. My IHOF QB didn't finish the season so he only played against ten teams. There are some other situations not being displayed here such as HOt weather (80+), Dome stats, 4th and short situations etc. The utility tracks all of that, but if the QB didn't attempt a pass in those sitautions it doesn't bother displaying it.

A team name change would mess things up right now if you were trying to track the players stats over the course of multiple years. I am planning on working on a way to fix that. If a player changes teams that will also screw things up a bit. Right now when it reads the logs it looks for the combination of the player name number and team abbriviation. So if a player switches teams the utility will think he is a completely different player. Again I am working on that.

[primelord]

Originally Posted by Icy

Well Primelord, just to give you some more work what about tracking passes sent to each receiver, drops, yards etc etc? that way we can know the best QB<->receiver relationship.

That is something I have thought about. It might be a bit challenging in that right now the keys where the data is stored are static situations. With different receiver names I would need to add some dynamic keys. Something I can do, but I might wait until I get a working version of this out before I try to add that.

[primelord]

I am working on the HTML output for this utility, but I am not much of an HTML designer. Below is what I have, but I don't like it much. Anyone have any suggestions and some sample code to make this look better?

7 Parker

Category	Att	Cmp	Pct	Yards	Avg	Long	TD	Int	+20	+40	1st Down	Sack	Sck Yards	Rate
Total	275	169	61.5	1584	5.76	54	6	11	10	4	83	18	108	67.9
Home	135	82	60.7	791	5.86	50	2	5	6	1	40	9	54	66.6
Away	140	87	62.1	793	5.66	54	4	6	4	3	43	9	54	69.1

Category	Att	Cmp	Pct	Yards	Avg	Long	TD	Int	+20	+40	1st Down	Sack	Sck Yards	Rate
Grass	241	149	61.8	1425	5.91	54	5	9	9	4	74	17	103	69.6
Turf	34	20	58.8	159	4.68	24	1	2	1	0	9	1	5	55.9
Outdoor	275	169	61.5	1584	5.76	54	6	11	10	4	83	18	108	67.9

Category	Att	Cmp	Pct	Yards	Avg	Long	TD	Int	+20	+40	1st Down	Sack	Sck Yards	Rate
Fair	245	153	62.4	1436	5.86	54	6	9	9	4	76	16	97	71.4
Rain	30	16	53.3	148	4.93	33	0	2	1	0	7	2	11	39.3
Cold (21 - 40 F)	23	17	73.9	131	5.70	15	1	0	0	0	12	2	13	101.9
Mild (41 - 60 F)	131	76	58.0	767	5.85	54	1	5	4	2	36	10	58	61.5
Warm (61 - 80 F)	121	76	62.8	686	5.67	47	4	6	6	2	35	6	37	68.4

Category	Att	Cmp	Pct	Yards	Avg	Long	TD	Int	+20	+40	1st Down	Sack	Sck Yards	Rate
First Quarter	52	31	59.6	246	4.73	16	1	3	0	0	12	4	24	53.8
Second Quarter	62	39	62.9	356	5.74	47	2	1	3	1	22	9	55	82.5
Third Quarter	71	53	74.6	456	6.42	54	0	2	1	1	27	2	13	79.3
Fourth Quarter	90	46	51.1	526	5.84	50	3	5	6	2	22	3	16	57.0
First Half	114	70	61.4	602	5.28	47	3	4	3	1	34	13	79	69.4
Second Half	161	99	61.5	982	6.10	54	3	7	7	3	49	5	29	66.8

Category	Att	Cmp	Pct	Yards	Avg	Long	TD	Int	+20	+40	1st Down	Sack	Sck Yards	Rate
First Down	64	42	65.6	433	6.77	46	2	2	4	1	13	5	32	82.4
Second Down	104	56	53.8	567	5.45	54	2	8	4	3	26	6	35	44.0
Third Down	104	69	66.3	557	5.36	33	2	1	2	0	43	7	41	82.1
Fourth Down	3	2	66.7	27	9.00	18	0	0	0	0	1	0	0	95.1

Category	Att	Cmp	Pct	Yards	Avg	Long	TD	Int	+20	+40	1st Down	Sack	Sck Yards	Rate
First & 3-7	2	2	100.0	9	4.50	6	2	0	0	0	0	0	0	125.0
First & 8-10	57	36	63.2	396	6.95	46	0	2	4	1	13	5	32	69.0
First & 11+	5	4	80.0	28	5.60	12	0	0	0	0	0	0	0	90.0
Second & < 3	1	0	0.0	0	0.00	0	0	0	0	0	0	1	5	39.6
Second & 3-7	37	19	51.4	250	6.76	50	1	4	3	2	16	2	10	42.5
Second & 8-10	49	27	55.1	237	4.84	54	1	3	1	1	8	2	17	49.4
Second & 11+	17	10	58.8	80	4.71	14	0	1	0	0	2	1	3	46.2
Third & < 3	2	1	50.0	9	4.50	9	0	0	0	0	1	0	0	62.5
Third & 3-7	59	40	67.8	315	5.34	33	1	0	1	0	33	3	14	86.5
Third & 8-10	31	21	67.7	193	6.23	22	1	1	1	0	9	1	8	81.8
Third & 11+	12	7	58.3	40	3.33	8	0	0	0	0	0	3	19	64.6
Fourth & 8-10	2	1	50.0	9	4.50	9	0	0	0	0	0	0	0	62.5
Fourth & 11+	1	1	100.0	18	18.00	18	0	0	0	0	1	0	0	118.8

Category	Att	Cmp	Pct	Yards	Avg	Long	TD	Int	+20	+40	1st Down	Sack	Sck Yards	Rate
AOC	217	133	61.3	1244	5.73	54	5	9	8	3	65	14	85	67.4
NAC	58	36	62.1	340	5.86	50	1	2	2	1	18	4	23	69.6
Atlantic Coast	58	36	62.1	340	5.86	50	1	2	2	1	18	4	23	69.6
European	125	71	56.8	742	5.94	54	2	7	7	3	35	7	45	56.1
Northeast	68	44	64.7	381	5.60	32	2	1	1	0	24	5	31	83.0
Southeast	24	18	75.0	121	5.04	12	1	1	0	0	6	2	9	82.1

Category	Att	Cmp	Pct	Yards	Avg	Long	TD	Int	+20	+40	1st Down	Sack	Sck Yards	Rate
Bordeaux	36	23	63.9	212	5.89	39	1	2	3	0	12	1	7	66.0
Georgia	24	18	75.0	121	5.04	12	1	1	0	0	6	2	9	82.1
Gothenburg	32	17	53.1	188	5.88	54	0	2	1	1	8	2	11	44.8
Maassluis	27	15	55.6	194	7.19	47	1	1	2	2	8	2	16	75.2
Miami	24	16	66.7	181	7.54	50	0	0	1	1	9	3	18	89.1
North Plainfield	21	14	66.7	96	4.57	11	0	0	0	0	5	1	4	76.7
Outer Banks	34	20	58.8	159	4.68	24	1	2	1	0	9	1	5	55.9
Paris	30	16	53.3	148	4.93	33	0	2	1	0	7	2	11	39.3
Rochester	23	17	73.9	131	5.70	15	1	0	0	0	12	2	13	101.9
Syracuse	24	13	54.2	154	6.42	32	1	1	1	0	7	2	14	70.5

[FBPro]

OMG, that is just beautiful!!!!!!!!!!!!!!!!!!

[DaddyTorgo]

bump

how's this utility coming primelord? anything else you need from the community to make it a reality?

[flere-imsaho]

I dunno, I like that output the way it is. Utility looks to be coming along great, though.

[Ramzavail]

I want it

[primelord]

Originally Posted by flere-imsaho

I dunno, I like that output the way it is. Utility looks to be coming along great, though.

No that format sucks. Here is what the new format looks like.

http://www.fof-ihof.com/upload/primelord/Parker.html

The utility is more or less in a useable form, but it is pretty cumbersome to use at the moment. It requires setting up several configuration files and it is a bit of a pain. I had a couple of people here beta test it for me and from suggestions from that process I decided I really needed to put a GUI on it.

Also at the moment it has no way to determine whether the game files it is reading are Pre-Season, Regular Season, or Post-Season games. So the stats you get may not be what you expected. I actually know how to work around that now, but I have not finished that part of the code because I am working on the GUI.

So the short of it is the utility is coming, but I need to find a few more hours of free time to finish it up.

[chinaski]

looks amazing.... one suggestion... maybe throw in a alternating row color, like light grey then white etc..

cant wait to use the final!

[Ramzavail]

:drool:

[primelord]

Just an FYI. I am making progress on this:

[FBPro]

Originally Posted by primelord

Just an FYI. I am making progress on this:

Sweet...

[jbmagic]

nice


i cant for the other positions too...

you make great utilities for FOF

[NYFAN]

Any ETA?

[sovereignstar]

Easy now. It hasn't even been a week since he checked in last. He's also providing what seems like daily support for his other util.

[primelord]

I would suspect I have a week or so to go. The GUI is done now and I am just working on integrating it with the code I had for the command line version. I made quite a bit of progress on it yesterday. I only probably have a couple more hours of actual coding time left to do, but it is all about finding those couple of hours.

[weinstein7]

Primelord,

I know you haven't even finished the QB version, but based on a discussion over on the eNFL board, do you think it would be possible to adapt the code to track other positions' situational stats as well? For example, RB - length of runs, DL - tackles for loss, etc.

[primelord]

Originally Posted by weinstein7

Primelord,

I know you haven't even finished the QB version, but based on a discussion over on the eNFL board, do you think it would be possible to adapt the code to track other positions' situational stats as well? For example, RB - length of runs, DL - tackles for loss, etc.

Yes that will actually be the next thing I add in. To be honest I had to fight the urge yesterday to start re-writing the whole utility to supprt that now. Since the code is 90% done for QBs I want to get that workign and out first and then I am going to start working on getting it to support all offensive skill position stats and soem defensive stats too.

[weinstein7]

Outstanding.

[primelord]

Ok I am pretty close to being ready to release this.

Chad Madkin

I want to split up the defensive alignment stuff a bit more and then I have a few people I want to ask to test this a bit. Once that is done I will be ready to release it. Depending on people's schedules maybe even sometime this weekend.

[jbmagic]

looks great

just curious does homefield like Dome, grass, outdoors. etc really affect how players play in FOF?

same with different kind of weather temp?

if so that very interesting

[primelord]

Originally Posted by jbmagic

looks great

just curious does homefield like Dome, grass, outdoors. etc really affect how players play in FOF?

same with different kind of weather temp?

if so that very interesting

To be honest I am not sure. That is something that this utility may shed light on. FWIW from the testing I have done there does seem to be increase in productivity in Domes and in good weather, but I haven't run this on anywhere near enough different QBs to say that it has a definite effect.

[FBPro]

Whoa...

[primelord]

Originally Posted by primelord

To be honest I am not sure. That is something that this utility may shed light on. FWIW from the testing I have done there does seem to be increase in productivity in Domes and in good weather, but I haven't run this on anywhere near enough different QBs to say that it has a definite effect.

Ironically in the example that I linked to above the QB actually appears to play better on grass, outdoors, and in the rain.

[jbmagic]

Originally Posted by primelord

Ironically in the example that I linked to above the QB actually appears to play better on grass, outdoors, and in the rain.

yep because he play more games there...

but average wise pretty similar accept over 80 degrees weather he sucks on average

[Yossarian]

First time i've clicked on this.

Man ALIVE!

this is soo freakin cool.

[Icy]

Awesome, can't wait to get it to analize my online leages teams.

[DaddyTorgo]

i might need a few minutes alone with my computer and my right hand after clicking the "Chad Madkin" link there and seeing what this utility can do. It's that good. No kidding. I can see this being...revolutionary. Allowing people to get even more immersed.

[temley06]

Looks great, just one question, how did Madkin have 4 TDs in 3 attempts when it was first & < 3? Maybe it includes rushes?