GamePlanAnalyzer7

[gstelmack]

GamePlanAnalyzer (http://www.gstelmack.com/GamePlanAnalyzer/publish.htm)

Another revived utility. This one will let you specify a league, optionally a team, and optionally a starting season (to limit to recent seasons to match recent rosters and games), and it will create a bunch of HTML table reports about various aspects of gameplanning. It will report run/pass yards, averages, and success (based on the Football Outsiders definition of successful plays) for a variety of game situations.

It can help you tweak your gameplan to call things your team tends to be successful at, and try to plan your defense to stop what your opponent is good at or runs a lot.

[sjshaw]

Good to have you back, big guy.

[Bako]

If this version is downloaded, does it over write the 2007 GP Analyzer?

By the way, thanks for your time and effort.

[flounder]

Awesome Greg. Thanks!

[gstelmack]

I don't *think* any of this overwrites the old utilities, although they do share some of the same data directories - Documents/StelmackSoft/UtilitySuite. So settings, DraftAnalyzer weights, etc could conflict.

If anyone is trying to run both, I can look into separating that, and probably should have to begin with.

[MizzouCowboy]

Simply amazing! Thanks for everything you do.

[RipMurdock]

Sorry, but I'm having trouble with setting up and running the GPA. Can anyone help?

I'm using Win7. I run the setup.exe and I get the message that "the application cannot be started," plus this message:

PLATFORM VERSION INFO
Windows : 6.1.7601.65536 (Win32NT)
Common Language Runtime : 4.0.30319.18444
System.Deployment.dll : 4.0.30319.18408 built by: FX451RTMGREL
clr.dll : 4.0.30319.18444 built by: FX451RTMGDR
dfdll.dll : 4.0.30319.18408 built by: FX451RTMGREL
dfshim.dll : 4.0.41209.0 (Main.041209-0000)

SOURCES
Deployment url : http://www.gstelmack.com/GamePlanAnalyzer/GamePlanAnalyzer.application
Server : Apache/2.2.22 (Unix) mod_ssl/2.2.22 OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635

IDENTITIES
Deployment Identity : GamePlanAnalyzer.application, Version=0.9.0.4, Culture=neutral, PublicKeyToken=54fad763b311e63f, processorArchitecture=msil

APPLICATION SUMMARY
* Installable application.

ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed later in the log.
* Activation of http://www.gstelmack.com/GamePlanAnalyzer/GamePlanAnalyzer.application resulted in exception. Following failure messages were detected:
+ Activation failed.
+ The system cannot find the file specified. (Exception from HRESULT: 0x80070002)

COMPONENT STORE TRANSACTION FAILURE SUMMARY
No transaction error was detected.

WARNINGS
There were no warnings during this operation.

OPERATION PROGRESS STATUS
* [3/23/2014 9:41:56 AM] : Activation of http://www.gstelmack.com/GamePlanAnalyzer/GamePlanAnalyzer.application has started.
* [3/23/2014 9:41:56 AM] : Processing of deployment manifest has successfully completed.

ERROR DETAILS
Following errors were detected during this operation.
* [3/23/2014 9:41:56 AM] System.Deployment.Application.DeploymentException (Activation)
- Activation failed.
- Source: System.Deployment
- Stack trace:
at System.Deployment.Application.ComponentStore.ActivateApplication(DefinitionAppId appId, String activationParameter, Boolean useActivationParameter)
at System.Deployment.Application.SubscriptionStore.ActivateApplication(DefinitionAppId appId, String activationParameter, Boolean useActivationParameter)
at System.Deployment.Application.ApplicationActivator.Activate(DefinitionAppId appId, AssemblyManifest appManifest, String activationParameter, Boolean useActivationParameter)
at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut, String textualSubId, String deploymentProviderUrlFromExtension, BrowserSettings browserSettings, String& errorPageUrl)
at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)
--- Inner Exception ---
System.IO.FileNotFoundException
- The system cannot find the file specified. (Exception from HRESULT: 0x80070002)
- Source: System.Deployment
- Stack trace:
at System.Deployment.Application.NativeMethods.CorLaunchApplication(UInt32 hostType, String applicationFullName, Int32 manifestPathsCount, String[] manifestPaths, Int32 activationDataCount, String[] activationData, PROCESS_INFORMATION processInformation)
at System.Deployment.Application.ComponentStore.ActivateApplication(DefinitionAppId appId, String activationParameter, Boolean useActivationParameter)

COMPONENT STORE TRANSACTION DETAILS
* Transaction at [3/23/2014 9:41:56 AM]
+ System.Deployment.Internal.Isolation.StoreOperationSetDeploymentMetadata
- Status: Set
- HRESULT: 0x0
+ System.Deployment.Internal.Isolation.StoreTransactionOperationType (27)
- HRESULT: 0x0

[gstelmack]

I always love Microsoft exception reports, how they can say "FileNotFoundException" but not tell you what file.

I do know all this stuff is using .NET 4.0, so you need to make sure that is installed. I thought that the setup installer from the site would walk you through that as needed. You can try installing the .NET 4.0 runtime on your own first (http://www.microsoft.com/en-us/download/details.aspx?id=17851) and see if that fixes it.

[Andreh]

Thank you! Thats one app I was missing badly! Now time to learn to use it :)

[RipMurdock]

I always love Microsoft exception reports, how they can say "FileNotFoundException" but not tell you what file.

I do know all this stuff is using .NET 4.0, so you need to make sure that is installed. I thought that the setup installer from the site would walk you through that as needed. You can try installing the .NET 4.0 runtime on your own first (http://www.microsoft.com/en-us/download/details.aspx?id=17851) and see if that fixes it.

Thank you. I tried downloading .NET 4.0 but the setup said I had the same or higher version.

[gstelmack]

There are some suggestions you could try at:

c# - ClickOnce deployment "Activation failed" FileNotFoundException - Stack Overflow (http://stackoverflow.com/questions/9727778/clickonce-deployment-activation-failed-filenotfoundexception)

[RipMurdock]

There are some suggestions you could try at:

c# - ClickOnce deployment "Activation failed" FileNotFoundException - Stack Overflow (http://stackoverflow.com/questions/9727778/clickonce-deployment-activation-failed-filenotfoundexception)

You were on target. I uninstalled and reinstalled .NET 4 and cleared the cache. There were a bunch of twists and turns, but I finally got GPA to work. Thank you.

[Vaevictis_386]

This is wonderful, excellent stuff!

[Bako]

Downloaded, but I'm getting an error message. Here are the details:

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.IO.FileNotFoundException: Could not find file 'C:\Users\Nick\AppData\Roaming\Solecismic Software\Front Office Football Seven\leaguedata\onaindia\team_information.csv'.
File name: 'C:\Users\Nick\AppData\Roaming\Solecismic Software\Front Office Football Seven\leaguedata\onaindia\team_information.csv'
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
at System.IO.StreamReader..ctor(String path, Encoding encoding, Boolean detectEncodingFromByteOrderMarks, Int32 bufferSize, Boolean checkHost)
at System.IO.StreamReader..ctor(String path, Encoding encoding, Boolean detectEncodingFromByteOrderMarks, Int32 bufferSize)
at System.IO.StreamReader..ctor(String path, Boolean detectEncodingFromByteOrderMarks)
at DataReader.LeagueData.LoadTeamInformation()
at DataReader.LeagueData..ctor(String pathPrefix, UniverseData universeData, Int32 startingSeason, FileReadDelegate readCallback, Boolean loadGameList)
at GamePlanAnalyzer.GamePlanAnalyzerForm.comboBoxLeagues_SelectedIndexChanged(Object sender, EventArgs e)
at System.Windows.Forms.ComboBox.OnSelectedIndexChanged(EventArgs e)
at System.Windows.Forms.ComboBox.WmReflectCommand(Message& m)
at System.Windows.Forms.ComboBox.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.18444 built by: FX451RTMGDR
CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v4.0.30319/mscorlib.dll
----------------------------------------
System
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
GamePlanAnalyzer
Assembly Version: 2.0.8.0
Win32 Version: 2.0.8.0
CodeBase: file:///C:/Users/Nick/AppData/Local/Apps/2.0/TBJPWVMR.ALC/742TX2LA.5R9/game..tion_54fad763b311e63f_0000.0009_fb64405e65b8fe82/GamePlanAnalyzer.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
DataReader
Assembly Version: 2.0.8.0
Win32 Version: 2.0.8.0
CodeBase: file:///C:/Users/Nick/AppData/Local/Apps/2.0/TBJPWVMR.ALC/742TX2LA.5R9/game..tion_54fad763b311e63f_0000.0009_fb64405e65b8fe82/DataReader.DLL
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

[Bako]

I have no idea what any of that means...

[Ben E Lou]

I suspect that this is the key:

"Could not find file 'C:\Users\Nick\AppData\Roaming\Solecismic Software\Front Office Football Seven\leaguedata\onaindia\team_information.csv'."

You need to do a data export to get that file.

[Bako]

Thanks for the quick response.

How would I go about doing that?

[Ben E Lou]

Just hit the "Export Data" button in the game.

[gstelmack]

Yeah, it needs the team information stuff so you can pick which team to show. If there is any real need or desire, I could make that optional, but then you'd get like "Team 1" as a choice.

[Bako]

Did the trick. Thanks for the assistance guys.

[Firefly]

Mine crashes when trying to run my MP league, apparently when reading the team_information.csv file. Any ideas what the deal might be?

[gstelmack]

That's the issue we just answered.

[Firefly]

But my files are there... Do I maybe need to point the utility to the right folders?

After taking a further look, the thing that seems odd is that the utility shows me two leagues: SP - cflfiles and MP - cflfiles. MP - cflfiles crashes with the team info file, and SP - cflfiles comes up with all zeros. The weird thing is that there's no SP league called cflfiles in my PC.

[Firefly]

Just to be clear, while trying out the utility with an SP league I came across the missing file error, but that's not the same problem I have with my MP league. With the MP league the utility just crashes, no error msg given. I opened the team_information file to see if there was anything weird (I believe this is the culprit because when the utility crashes I can see a msg in the utility saying "Reading file team_information.csv"), but nothing jumps out at me.

[Dawgfan19]

Perhaps my issue is somewhat related to Firefly, but my error occurs for only one league. No issues for 4 other leagues. The GP Analyzer crashes with no message. However, the Windows Event Viewer is reporting this .NetRuntime error (Event ID 1026).


Any ideas? BTW, I have used the Export Data option for the league in question.

Application: GamePlanAnalyzer.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.FormatException
Stack:
at System.Number.StringToNumber(System.String, System.Globalization.NumberStyles, NumberBuffer ByRef, System.Globalization.NumberFormatInfo, Boolean)
at System.Number.ParseInt32(System.String, System.Globalization.NumberStyles, System.Globalization.NumberFormatInfo)
at System.Int16.Parse(System.String, System.Globalization.NumberStyles, System.Globalization.NumberFormatInfo)
at DataReader.LeagueData.LoadGameList()
at GamePlanAnalyzer.GamePlanAnalyzerForm.UpdateThreadTask()
at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object)
at System.Threading.ThreadHelper.ThreadStart()

[Firefly]

You wouldn't happen to run the sims for that one league, would you dawgfan?

[gstelmack]

The Format exception means one of the columns that I think is a number has non-numeric data in it.

[Firefly]

My error report is exactly the same as dawgfan's, but others in the league report they can use the program without issues. I'm attaching my team_information file if you could maybe look at it? It looks ok to me.

Application: GamePlanAnalyzer.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.FormatException
Stack:
at System.Number.StringToNumber(System.String, System.Globalization.NumberStyles, NumberBuffer ByRef, System.Globalization.NumberFormatInfo, Boolean)
etc,etc

[Dawgfan19]

You wouldn't happen to run the sims for that one league, would you dawgfan?Yes, I sim that league. I'll look at the data per Greg's suggestion.

[Firefly]

I ask because I sim this league, too. I suspect somehow this has something to do with it.

[Ben E Lou]

No idea if it's related, but one thing just popped into my head. In leagues that were converted from FOF2K4 to FOF2K7, there were inconsistencies that had to do with city affiliations. It was something that you didn't notice at all from the front end of FOF, but when using some of the Stelmack tools (Extender comes to mind immediately,) the inconsistency caused issues. I don't remember the details because very long ago I changed city affiliations for all of the leagues that were affected, so that I could use Extender. I'm not having this issue with the FOF2K4-->FOF2K7--->FOF7 league that I sim. Seems like a long shot, but just throwing it out there.

[Firefly]

What I don't understand is why others in the league have no issues. I even tried it in another machine and no luck.

[Firefly]

In the oddest development yet, I borrowed another player's Export files -one who has GP Analyzer up and working ... and it still crashed. How can that be?

I keep thinking back to city affiliations, but I don't see anything strange there.

[Ben E Lou]

Hmmmmm...could it be something with permissions then? Running as administrator?

[gstelmack]

I don't know if it has to do with the whole "comma" vs "period" thing for numbers, but there are no floating point values in the files being read for that to crop up here.

[Firefly]

No, it's not running as administrator... in fact, I turned that whole darn thing off. I couldn't stand it. Tried it anyway, just in case, but no.

As I understand it, the utility only uses the files in that folder, correct? Or is there any other information being pulled from somewhere? If not, maybe there is a conflict with the old utility somehow? Or I need to run the utility from somewhere in particular?

It makes no sense for the utility to work in one machine and crash in another if the info pulled is the same.

(Surely a different issue, but I'm always suspicious of simultaneous issues: when I run "create html" the game always crashes. I have to run it twice, the first time without creating box scores, the second with box scores, in order to get it work.)

[Hammer]

"Could not find file 'C:\Users\Nick\AppData\Roaming\Solecismic Software\Front Office Football Seven\leaguedata\onaindia\team_information.csv'."

Has the cause of this been nailed down? Seeing this message for my MP league.

[Firefly]

"Could not find file 'C:\Users\Nick\AppData\Roaming\Solecismic Software\Front Office Football Seven\leaguedata\onaindia\team_information.csv'."

Has the cause of this been nailed down? Seeing this message for my MP league.


That one has been addressed. You need to click "export data" before running Analyzer.

[Hammer]

Okay thanks.

[Firefly]

Aston did it! he solved the problem. He discovered that having extra files in the league folder will cause the utility to crash. I did have some zip files I uploaded to the league in there (something that only commishes would tend to do, hence the connection!), I removed them and the utility worked.

So the whole team_information file thing was just misdirection . I assumed that was the problem since the utility crashed with the message "reading team_information.csv" frozen in there, but as Aston explained, after clicking "analyze" the utility would only be reading the weekly files.

You're a genius, Aston! You took that problem and made it your b****! Thanks for taking the time to look into it.

[Dawgfan19]

Thanks Aston!!! That work for me as well.

[gstelmack]

Hmm, now I'm curious, as I only open specific files.

[gstelmack]

string[] gameFiles = System.IO.Directory.GetFiles(mSavedGamePath,mLeagueID+"*.*");
foreach (string curFile in gameFiles)
{
// game ID is 8, week is 1 or 2, 1 for the extension, 4 for the year. No other files follow this pattern/length.
string fileName = System.IO.Path.GetFileName(curFile);
if (fileName.Length >= (8 + 1 + 1 + 4))
{
string yearString = System.IO.Path.GetExtension(fileName);
short year = Int16.Parse(yearString.Substring(1)); // eliminate the period
string weekString = System.IO.Path.GetFileNameWithoutExtension(fileName).Substring(8);
short week = Int16.Parse(weekString);


Yup, when I go looking for individual weekly game files, I must be picking up some of these other files you guys have in there with the league ID, but they are breaking the parser. I can likely make this safer by using TryParse instead, and skipping the file if the parse fails. I'll look into it.

[Dawgfan19]

Hmm, now I'm curious, as I only open specific files.

Greg, is it possible you are not considering the file extension to determine which files to open? I had temporarily stopping simming in the eNFL. And as a regular GM, the game does not save your game plan if the .fpn file in the league folder. Thus, I had renamed the file as .xxxfpn. After deleting that file, the analyzer worked.

[gstelmack]

Yes, that's what the code shows. Everything else is {leagueid}.{3charextension}, or 12 characters. Weekly files are {leagueid}{week}.{year}. So I look for {leagueid}*.*, and pull everything longer than 14 characters and assume it fits {leagueid}{week}.{year}. I wasn't expecting anything that FOF did not put in there.

I can be much safer in this, checking to make sure the extension is numeric, for example. I'll look into it.

[gstelmack]

Update pushed, should install next time you launch. You may still have trouble if you use an all-numeric extension for created files in there, avoid that and it should skip them.

[Firefly]

Makes sense, my zip files were named cflfiles blah blah logos.zip and cflfiles statfiles.zip, where cflfiles is the ID of the league

[corbes]

Thanks for this Greg, and a bump in light of recent threads about how to gameplan for opponents...

[Caligari]

Just a comment (on this awesome, and for me invaluable, tool): I'd love the Pick Team list to be alphabetized. I'm always struggling to find some team or other.

Also, Team Offense lists Runs By Direction, but the same isn't shown for Defense. I'd be interested to see those stats (for my own team and my opponents').

Regardless of these details, it it worth giving a hearty thumbs up for this utility again! Thanks!

[NoxMortem]

Thank you so much for this tool...

[NoxMortem]

What is the DrpB statistic?

[Firefly]

Drop backs

[NoxMortem]

Did I got it right that I want the success rate to be low on my team defense statistics? If I get it correctly that means that the offensive play was unsucessful?

[Firefly]

Exactly

[Ushikawa]

Big fan of this tool...mostly for detecting which formations my squad runs best and coverage/blitz effectiveness.

It still works fine for my other leagues but for 1 it quit working giving me the rror below. Seems like it doesn't like file 20139.2022 that is to say week 4. I am scared to see what happens if I delete it from my universe. Any other ideas? Can't analyze for other teams in the league either so I am pretty sure it is something with this file.


Problem signature:
Problem Event Name: CLR20r3
Problem Signature 01: gameplananalyzer.exe
Problem Signature 02: 2.0.8.0
Problem Signature 03: 53d53b52
Problem Signature 04: DataReader
Problem Signature 05: 2.0.8.0
Problem Signature 06: 53d0eeef
Problem Signature 07: 2f
Problem Signature 08: 0
Problem Signature 09: System.IndexOutOfRangeException
OS Version: 6.1.7601.2.1.0.768.3
Locale ID: 1033
Additional Information 1: f132
Additional Information 2: f132640cae807e491b507bbfb2deeeef
Additional Information 3: aaf6
Additional Information 4: aaf699c42c8b1e51aeab26abd981b6dd

[aston217]

The effect of deleting it from the universe means those stats won't show up in GPA and you won't be able to see box logs from that week. Shouldn't be anything other than that. But at least keep a backup of the file, if you do.

[Dawgfan19]

Big fan of this tool...mostly for detecting which formations my squad runs best and coverage/blitz effectiveness.

It still works fine for my other leagues but for 1 it quit working giving me the rror below. Seems like it doesn't like file 20139.2022 that is to say week 4. I am scared to see what happens if I delete it from my universe. Any other ideas? Can't analyze for other teams in the league either so I am pretty sure it is something with this file.


Problem signature:
Problem Event Name: CLR20r3
Problem Signature 01: gameplananalyzer.exe
Problem Signature 02: 2.0.8.0
Problem Signature 03: 53d53b52
Problem Signature 04: DataReader
Problem Signature 05: 2.0.8.0
Problem Signature 06: 53d0eeef
Problem Signature 07: 2f
Problem Signature 08: 0
Problem Signature 09: System.IndexOutOfRangeException
OS Version: 6.1.7601.2.1.0.768.3
Locale ID: 1033
Additional Information 1: f132
Additional Information 2: f132640cae807e491b507bbfb2deeeef
Additional Information 3: aaf6
Additional Information 4: aaf699c42c8b1e51aeab26abd981b6dd

Perhaps non-FOF files in the league folder? May be a different issue since Greg posted a fix. But read post #40 in this thread.

[Ushikawa]

The effect of deleting it from the universe means those stats won't show up in GPA and you won't be able to see box logs from that week. Shouldn't be anything other than that. But at least keep a backup of the file, if you do.

Thanks I ended up just taking it out of the universe with no serious effects.

[garion333]

Thanks I ended up just taking it out of the universe with no serious effects.

OOCT

Take that, Universe!