Parse Log File

[bekmonster]

Has anyone written, or even heard of, a script that parses the game created html log file into a spreadsheet or similar format? I'm trying to get information from the log file (i.e. down, distance, field location, play call, defense, etc) into a spreadsheet format for analysis. I'm willing to tackle it myself but figured I'd ask if there was anyone out there.

[corbes]

If you poke around in the reference threads, there was a third-party utility for FOF7 and earlier called Game Plan Analyzer, but it has not been updated for FOF8.

[Ushikawa]

Check here FOF 8 Utility Suite - Front Office Football Central (https://forums.operationsports.com/fofc/showthread.php?t=92067) there is a tool to pull data to use with MySQL (above my head personally) no one has automated to parsing of playcall data but there are some cool stats like 20+ yard passes given up, tackles for loss and others that you can access with soem pretty basic Excel skills

[tzach]

I have written my own code to do this and produce outputs like the one below (all plays from a given team in 1st or 2nd down, own 5 yd line, during a given season).

unfortunately it runs on proprietary software and is not documented, so I cannot make it easily available. I have plans of making a web interface so people could upload their log(s) to be parsed, but haven't had time to do that yet.

*******************1or2-own5************************************
1-10 (1Q: 04:02) 0 ydrun 131 Weak Run 24 Normal 131 vs 34 Eagle, Regular Personnel, Press-1 No Blitz ---
2-10 (1Q: 03:32) 2 ydrun 122 I Run 25 Normal 122 vs 34 Eagle, Regular Personnel, Cover-2 No Blitz --
1-10 (2Q: 03:36) 1 ydrun 221 Pro Run 2error Shotgun 221 vs 34 Eagle, Regular Personnel, Cover-1, Buzz No Blitz --
2-9 (2Q: 02:57) 1 ydrun 131 Weak Run 24 Normal 131 vs 34 Eagle, Regular Personnel, Press-1 No Blitz --
1-10 (2Q: 10:54) 26 ydpass 131 I Pass AYZU 1580 Normal 131 vs 34 Eagle, Regular Personnel, Cover-1, Buzz No Blitz ++++
1-10 (3Q: 04:36) 2 ydrun 230 Pro Run 22 Shotgun 230 vs 43 Over, Regular Personnel, Cover-1, Buzz No Blitz --
2-11 (3Q: 03:42) 2 ydrun 131 Weak Run 24 Normal 131 vs 43 Over, Regular Personnel, Cover-1, Buzz No Blitz --
1-10 (4Q: 13:00) 2 ydrun 122 I Run 25 Normal 122 vs 43 Over, Regular Personnel, Press-1 No Blitz --
1-10 (4Q: 06:46) 1 ydrun 221 Pro Run 2error Shotgun 221 vs 43 Over, Regular Personnel, Cover-1, Buzz No Blitz --
2-9 (4Q: 05:59) 2 ydrun 113t Strong Run 22 Normal 113 vs 43 Over, Nickel Personnel, Tampa-2 No Blitz --
1-10 (4Q: 11:00) 1 ydrun 131 Weak Run 24 Normal 131 vs 43 Over, Regular Personnel, Press-1 No Blitz --
2-9 (4Q: 10:35) 8 ydrun 122 I Run 25 Normal 122 vs 43 Over, Regular Personnel, Cover-3 Sky No Blitz ++
1-10 (1Q: 12:48) -3 ydrun 113 Pro Run 20 Normal 113 vs 43 Under, Nickel Personnel, Press-2 No Blitz ---
2-13 (1Q: 12:18) 1 ydrun 131 Weak Run 24 Normal 131 vs 43 Under, Regular Personnel, Man to Man, Buzz No Blitz ---

[Ushikawa]

that would be awesome, I am most interested in things like which holes/routes/coverages are working best or worst.