View Full Version : StelmackSoft FOF2k7 Utility Suite
gstelmack
11-12-2006, 03:57 PM
Version 1.7.0 of my FOF2k7 Utility Suite (http://www.gstelmack.com/UtilitySuite/index.htm) is out! This consists of:
Resource Patcher: There are a variety of pieces of the FOF UI that people would like to change. Various artists out there have created replacement bitmaps for some of these elements. This utility will accept "packages" of these replacement resources and allow you to patch the FOF exe with them in a user-friendly manner (the old method involved manual use of ResHacker). This also makes it easy to re-patch the FOF exe whenever the game gets patched. There are two packages included with work from Icy and Cuervo72 of Front Office Football Central (http://fof.sportplanet.gamespy.com/). These can be used as sample packages for those who wish to create their own for use in this utility.
Extractor: This utility can interrogate certain windows in the FOF UI and extract data from them that is not otherwise readily available for printing. At the moment, this is just the Staff and Scout lists, plus some draft pool data. More player roster data will come later. To use this utility, you need to:
Launch Extractor
Launch Front Office Football 2007 and load your game.
Open the "View Staff" window.
Select the Scout or Staff list.
Double-click the first entry in the list to open that Staff Member or Scout's report window that shows all their details.
Or Open the Draft Preview and double-click the first entry in the list to open that draftee's player report window.
Make sure the Extractor window does not overlap the report window. Make sure nothing else is covering the report window. Rearrange windows as necessary.
Click the "Extract" button in Extractor.This will take a while, as the utility works by grabbing a screenshot of the report window, analyzing it pixel-by-pixel to determine what's on it, and then clicking the "Next" button to move to the next Scout or Staff Member. So be patient and make sure you don't cover up the report window while you wait.
Draft Analyzer: Once you have run Extractor on a draft class, this utility is used to view and manipulate the results. At the moment it is just displaying the draft class and adding in combine score coloring to show good or bad combine scores. Light green means a combine score is 1.5 standard deviations above the average for that position group or higher, dark green is 1 standard deviation better, dark blue is 1 standard deviation lower, and light blue is 1.5 standard deviations lower. More functionality is coming.
Interrogator: This is a utility for exploring the FOF2k7 game databases. This is a work in progress, with more tables to be added later. So far you can view:
Base Game Data: current year, salary cap, etc
Global City Data: names, locations, etc. Game updates not available yet.
Injury Names
Teams: nicknames, city, cap loss info, etc.
Draft Order: current year draft order, plus traded picks in future years.
Transactions: raw data, still needs some interpretation based on transaction type, and may not be grabbing all transactions available just yet.In addition to viewing this data, you may export it all to CSV files in a location of your choosing. Eventually I hope to directly export to an Access database as well.
City Editor:Used to edit the list of cities used for a game. Note that this data is global to FOF, so if you want to use different lists for different games, you need to set up batch files to copy the customized citydata.fdt to the game install directory and frfoot.fcy to the universe directory. Citydata.fdt is only important when first starting a game (as it gets copied into the save file and updated as needed), while frfoot.fcy is where the city names and abbreviations will come from for the game. Note that the utility includes a button that lets you make ".org" backups of these files. This is intended to be used the first time you run the City Editor to make clean copies of the default game files that you can restore if you mess something up. The utility will also always back up the existing files to ".bak" extensions whenever you save your changes, but if you've made edits before, you are backing up the edited versions.
USE AT YOUR OWN RISK! This type of editing is not supported by Solecismic. If you just want to change city names, use the editor built in to the game. This utility is considered advanced usage and is primarily targeted at multiplayer league commissioners who want a customized universe. Don't send in a support request to Solecismic if you have crashing issues or problems with your cities after running this utility. If you don't know what you are doing, you can hose your game and force a reinstall.
Maddenator:This will take an FOF roster exported through Extractor and update a custom Madden Roster with players on appropriate teams. To run this:
Create the teams you are interested in in Madden. The city name from FOF must be used for the location, and the nickname from FOF must be used for the nickname / team name.
Save that Madden roster.
Run Extractor on your league. Open the roster window, but don't open any players, to get Extractor to grab all teams. Make sure you do not have the "Process Free Agents" button checked in Extractor, because you don't need them.
Run Maddenator. Tell it which Madden Roster to use, and which Extractor file to use. It will replace players on the Madden Roster with players from Extractor for that team. It works in descending order of overall by position, so if you have 70 guys on an FOF roster only the top 53 or 55 or whatever Madden created guys will end up in Madden.
You may need to adjust the depth chart in Madden.This has had limited testing so far, and only on Madden 07, so consider this beta. I'm also not completely happy with the skill mappings, but then I probably never will be. This is mostly for screenshots for multiplayer leagues, although the occasional scrimmage is a lot of fun. Note that this will write a log file to <MYDOCUMENTS>\StelmackSoft\UtilitySuite, which lists players it had trouble with. This may be useful for trouble-shooting teams that don't have any players making the transition, as it will let you know what the team name looked like in Extractor which may prompt edits in Madden.
Extender:This utility is essentially a GUI reporting tool for FOF which includes reports not in the actual game. Reports will continually be added to this utility as useful ones are discovered.More to come.
Note that Resource Patcher is set up to allow others to provide packages for it (a package consists of a resource DLL and an XML file describing the available patches in it), so please feel free to create and distribute these as you wish.
Extractor won't work on Player cards yet, that needs a bunch of work, but it's my next stop.
And like before, I'm using the RSS feed (http://www.gstelmack.com/rss.xml) to help distribute news of updates. I'll try and post here as well, but this thread can get crowded, so the RSS feed is the best way to keep up-to-date with new releases.
NOTE: All output goes to ( My Documents ) \ StelmackSoft \ UtilitySuite
groovy. i appreciate this
Sweed
11-12-2006, 05:05 PM
Wow, thanks for this great utility. Very easy to use and makes the game look so much better.
Awesome stuff as always Greg, really appreciated.
yabanci
11-12-2006, 06:12 PM
Haven't tried it yet, but it's certainly much appreciated. Looking forward to the rest. Thanks.
famatu
11-12-2006, 06:16 PM
Could someone use this to make me a "color blind" version of the game? When you look at the eekly scores, the game your team is involved in is in red. I can't see it :( It used to be in blue a few versions ago and it was great. Does anyone know how to make this change?
FBPro
11-12-2006, 06:59 PM
I'm using it and my very first DE still has the old color but all other's have Icy's position update.
Subby
11-12-2006, 07:28 PM
I had ben putting off doing the in-game updates, but this makes it so easy that it's almost comical.
Thanks Greg!
wade moore
11-12-2006, 07:57 PM
Awesome!
I no longer have to fear change!
gstelmack
11-12-2006, 07:59 PM
Could someone use this to make me a "color blind" version of the game? When you look at the eekly scores, the game your team is involved in is in red. I can't see it :( It used to be in blue a few versions ago and it was great. Does anyone know how to make this change?
Those colors are set through code, not through the resources, so no. Jim would have to make these colors an option somewhere for you to customize them (which might not be a bad idea, since he has lots of other color options). I'd drop him a line; it's easy for game developers to forget red/green colorblindness.
NoMyths
11-12-2006, 11:23 PM
Great stuff, Greg.
Wow! This utility is a must have. Very nice!
cubboyroy1826
11-13-2006, 12:18 AM
Okay i installed it now when i open the program it gives me Icy and Cuervo to add. What the heck would i be adding if i check the two boxes?
Emiliano
11-13-2006, 01:38 AM
Very nice! Thank you Greg.
SunDevil
11-13-2006, 06:36 AM
Okay i installed it now when i open the program it gives me Icy and Cuervo to add. What the heck would i be adding if i check the two boxes?
Cuervo's Misc FOF Stuff
http://www.operationsports.com/fofc/showthread.php?t=53766
Icy's logo sets for FOF2007
http://www.operationsports.com/fofc/showthread.php?t=53712
It worked really well to patch the new exe, took a few seconds to have again the custom graphs in 6.0a.
Thanks a lot for this great work Greg.
SunDevil
11-15-2006, 06:23 PM
Icy updated his position icons. Do you have to update the IcyResouces.dll in order for the new changes to take effect?
http://www.operationsports.com/fofc/showthread.php?t=53712&page=3
gstelmack
11-15-2006, 07:45 PM
Icy updated his position icons. Do you have to update the IcyResouces.dll in order for the new changes to take effect?
http://www.operationsports.com/fofc/showthread.php?t=53712&page=3
I can update it for my next release (I'm up to my eyeballs getting Extractor going, so it may be a bit). I also missed out on Cuervo's button graphic tweaks, so I need to include those.
gstelmack
11-15-2006, 08:48 PM
All right, you talked me into it. That, and the Extractor Scout and Staff pieces required no modifications to work with 2k7 (all the player roster stuff will require significant modification so will be a while). So, I give you v1.1:
Extractor now available. The Staff and Scout windows are currently the only ones supported; player rosters to come later.
Updated Cuervo resource package with his new bitmap resources.
Updated Icy resource package with his fixed Bright Positions bitmap.
Ben E Lou
11-15-2006, 09:00 PM
Download spreadsheet updated with v1.1.
SunDevil
11-15-2006, 09:46 PM
Thanks
wade moore
11-16-2006, 11:26 AM
Greg...
Any chance of getting this piece - http://www.operationsports.com/fofc/showthread.php?t=54327 from Icy added to this tool?
gstelmack
11-16-2006, 11:32 AM
As I said in that thread, he added that right after I released this update. When I get a chance, I will add that.
wade moore
11-16-2006, 11:51 AM
As I said in that thread, he added that right after I released this update. When I get a chance, I will add that.
Yeah, I didn't mean today or anything ;)...
AlexB
11-16-2006, 02:00 PM
As soon as you could would be cool :) I simply can't work out which colour is which :(
gstelmack
11-16-2006, 06:43 PM
Yeah, I didn't mean today or anything ;)...
Tough. I did it. 1.1.1 is now up with all 3 of Icy's options for Player Position Experience.
:D
RedKingGold
11-16-2006, 06:53 PM
Tough. I did it. 1.1.1 is now up with all 3 of Icy's options for Player Position Experience.
:D
Where is it? I don't see it on your website?
wade moore
11-16-2006, 06:59 PM
Tough. I did it. 1.1.1 is now up with all 3 of Icy's options for Player Position Experience.
:D
How dare you go against my wishes! :p
Sweed
11-16-2006, 07:02 PM
gstelmack,
When you upgrade the utility can we install over the old one or do we need to uninstall first?
SunDevil
11-16-2006, 07:02 PM
Yep, do not see it on your website, but thanks for the update.
gstelmack
11-16-2006, 07:19 PM
Uploaded to wrong folder on web site, sorry. It's in the correct place now.
AlexB
11-17-2006, 02:18 PM
Many thanks Greg, I can now play this game :)
Antmeister
11-25-2006, 07:57 PM
Unbelievable tool. Thank you gstelmack for providing this for us.
By mistake i used your tool. How do I go back to my default settings?
Toddzilla
11-26-2006, 07:23 PM
By mistake i used your tool. How do I go back to my default settings?Format C:
JeffW
11-26-2006, 07:56 PM
Is this compatible with the newest patch? I tried patching the graphics with Icy's changes unsuccessfully.
gstelmack
11-26-2006, 08:02 PM
By mistake i used your tool. How do I go back to my default settings?
The "Make ORG backup" button is inteneded for this. Every time you update FOF, you can use this to save off a known good exe to "FrFoot2007.org".
If you didn't use that, the utility automatically makes a copy of "FrFoot2007.exe" as "FrFoot2007.bak". But if you patch the exe with my utility more than once, the bak file will be the prior patched version, not a shipped FOF. In that case, you'll need to reinstall.
gstelmack
11-26-2006, 08:05 PM
Is this compatible with the newest patch? I tried patching the graphics with Icy's changes unsuccessfully.
It worked for me here. Any errors in the status window?
JeffW
11-26-2006, 08:12 PM
It worked for me here. Any errors in the status window?
NM, I figured it out...I'm just autistic sometimes lol. :D
cuervo72
12-11-2006, 06:38 PM
Just now finally using this (finally got the game)...very, very nice GS!
PSUColonel
12-11-2006, 07:00 PM
what exactly does this utility do?
I'm under the impression that it essentially automates what you'd usually have to do in reshacker.
gstelmack
12-11-2006, 08:47 PM
That is true of Resource Patcher (BTW, this is set up for others to create their own packages and distribute aside from my utility).
Extractor's primary use is to dump staff information from the game for easier browsing of potential scouts or coaches to make a better informed decision about who to hire. At the moment, this requires using Excel or something similar (it spits out a CSV file). When I finally finish figuring out the new data file formats, I may be able to bring back the staff views in Extender, but for the moment this is the easiest way to browse all the staff members in the game.
I'm working on a 2k7 version of Interrogator (which takes various parts of the binary files and spits out CSV tables of the game data) and a City Editor.
kingfc22
12-11-2006, 09:06 PM
I'm working on a 2k7 version of Interrogator (which takes various parts of the binary files and spits out CSV tables of the game data) and a City Editor.
Woot! Thank you so much.
cuervo72
12-11-2006, 09:34 PM
I'll second that w00t!
I'm working on a 2k7 version of Interrogator (which takes various parts of the binary files and spits out CSV tables of the game data) and a City Editor.
Wow! I can't wait for these to be completed. :)
gstelmack
12-14-2006, 09:18 PM
Added Interrogator utility to view and dump some of the game data tables. Work is under way to figure out more of this data.
Added City Editor utility to edit the frfoot.fcy and citydata.fdt data files to allow a user to customize the list of cities used in the game. This includes everything from the name and abbreviation (the cities.fdt / frfoot.fcy files) to the weather, economic data, and location (the citydata.fdt). USE AT YOUR OWN RISK! And don't bug Solecismic if you have city problems after using this.
Ben E Lou
12-15-2006, 04:11 AM
Thanks, Greg!
Note to all: I've updated the download spreadsheet with this version.
DougWyatt
12-17-2006, 11:08 PM
When I finally finish figuring out the new data file formats, I may be able to bring back the staff views in Extender,
This was an awesome addition !! Fingers crossed :)
gstelmack
12-29-2006, 09:29 PM
City Editor no longer sorts cities if no city names changed.
Added "Copy Economics" to City Eidtor to allow a commissioner to set up their economics for each city however they'd like and make all cities the same.
Added a bunch more tables to Interrogator, including some global data such as hometowns and positions, along with some saved-game data such as transactions and some team bits. Work is ongoing in this area. A big thanks to Celeval for major assistance in working out the binary formats.The Interrogator bits get us through the player names, so it's back to the game logs for now.
kingfc22
12-29-2006, 09:39 PM
Thanks for all the work Greg and Celeval.
marcmoustache
01-10-2007, 08:35 AM
Stupid questions Greg
1. do you have any idea whether the playerindexes transfer between 2k4 and 2007?
2. are you looking at the Solevision data at all?
Cheers
Marc.
gstelmack
01-10-2007, 11:46 AM
Stupid questions Greg
1. do you have any idea whether the playerindexes transfer between 2k4 and 2007?
No clue, and if they did it's probably by accident instead of design. This didn't matter to me, so I haven't checked. You could spot check pretty easily.
2. are you looking at the Solevision data at all?
That is being actively worked on. Getting the historical player data was a necessary first step, as that is where player names, positions, etc come from in the solevision data. As I've stated a couple of times, my goal is to be able to create a database of every play from every game of every season in a league, allowing all kinds of statistical gathering from it.
marcmoustache
01-11-2007, 03:23 AM
Thanks Greg, especially for the quick response. You're right I can do a rec between the 2k4 indexes and change accordingly.
If it helps as feedback, the most useful outputs from the old Interrogator for me were:
- Player1Recs and Player2Recs (especially the salary & bonus info which isn't in the game's html)
- transactions
actually that's all I use from it, I get the other stuff from the boxscores. I can generate all the other stuff on injuries, etc from the player recs outputs.
So what I'm really saying ;) is please could you add the equivalent of the playerrecs outputs to the new Interrogator.
Cheers
Marc.
gstelmack
01-11-2007, 09:06 AM
One of the playerrecs output is there (the historical one). The one for the active players is on the list (and we know where it is), but it's behind running WOOF and figuring out the game log format (which lots of people are interested in). But it is #3 on the list.
cuervo72
01-11-2007, 09:30 AM
The playergame info was quite useful as well. In FOFL, we also use transactions, scouts, staff, staffhistory, playergame, schedule, gameresults. We use a lot. But we're still in 2k4 for now, so we're doing good. As usual, the more info the better, but knowing your other responsibilities not something we from the FOFL will actively bug about.
marcmoustache
01-11-2007, 11:06 AM
One of the playerrecs output is there (the historical one). The one for the active players is on the list (and we know where it is), but it's behind running WOOF and figuring out the game log format (which lots of people are interested in). But it is #3 on the list.
Thanks, I had an old version (I set up the rss feed but it must not have worked?).
How unfair that you're ignoring us over your private, invitation only league ;)
If you could bump the playerrecs then it would save me, and I'm the one that's important here, a lot of rejigging to generate player lists from the game's html.
marcmoustache
01-11-2007, 11:07 AM
The playergame info was quite useful as well. In FOFL, we also use transactions, scouts, staff, staffhistory, playergame, schedule, gameresults. We use a lot. But we're still in 2k4 for now, so we're doing good. As usual, the more info the better, but knowing your other responsibilities not something we from the FOFL will actively bug about.
Unfortunately we're looking to convert in a couple of weeks so if it's not out then I'll have to do the work myself...
gstelmack
01-11-2007, 01:02 PM
How unfair that you're ignoring us over your private, invitation only league ;)
Not ignoring, just not getting as much time as I might otherwise.
marcmoustache
01-11-2007, 01:14 PM
Not ignoring, just not getting as much time as I might otherwise.
Sorry should have had [tongue in cheek] around it ;)
gstelmack
01-14-2007, 12:30 PM
You have Celeval to thank for most of this, as he handed me most of the data format for these records (I added one or two fields that matched 2k4 fields and then integrated into the suite).
Interrogator now has the "Game Active Players" table, which includes contract data, personality data, and some other useful tidbits.
Ben E Lou
01-14-2007, 01:23 PM
You have Celeval to thank for most of this, as he handed me most of the data format for these records (I added one or two fields that matched 2k4 fields and then integrated into the suite).
Interrogator now has the "Game Active Players" table, which includes contract data, personality data, and some other useful tidbits.
Updated in download spreadsheet to 1.3.0
I downloaded version 1.3.
But for my league GamePlayer Active and Historical are both blank i.e. I get nothing when I go to these options:confused: .
twothree
01-14-2007, 06:33 PM
I downloaded version 1.3.
But for my league GamePlayer Active and Historical are both blank i.e. I get nothing when I go to these options:confused: .
Did you select a saved game from the top drop down menu selector?
Did you select a saved game from the top drop down menu selector?
Yes, I did.
twothree
01-14-2007, 08:06 PM
Do you have version 2.0 of the .NET runtime installed?
Do you have version 2.0 of the .NET runtime installed?
Yes, version 2.0
I tried Interrogator and got this error:
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.IO.EndOfStreamException: Unable to read beyond the end of the stream.
at System.IO.__Error.EndOfFile()
at System.IO.BinaryReader.ReadChar()
at DataReader.BinaryHelper.ExtractString(BinaryReader inFile, Int16 length, String header)
at DataReader.LeagueData.LoadLeagueFile(String fileName)
at DataReader.LeagueData..ctor(String pathPrefix)
at Interrogator.MainForm.comboBoxSavedGame_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.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
Interrogator
Assembly Version: 1.3.0.0
Win32 Version: 1.3.0.0
CodeBase: file:///C:/Program%20Files/StelmackSoft/FOF2k7%20Utility%20Suite/Interrogator.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
DataReader
Assembly Version: 1.3.0.0
Win32 Version: 1.3.0.0
CodeBase: file:///C:/Program%20Files/StelmackSoft/FOF2k7%20Utility%20Suite/DataReader.DLL
----------------------------------------
WindowsUtilities
Assembly Version: 1.3.0.0
Win32 Version: 1.3.0.0
CodeBase: file:///C:/Program%20Files/StelmackSoft/FOF2k7%20Utility%20Suite/WindowsUtilities.DLL
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.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.
gstelmack
01-15-2007, 08:00 AM
Can you zip up your league files (all of the LEAGUENAME*.* files) and send them to me?
Note that I only play multiplayer, so none of this has been tested against singleplayer careers (and is unlikely to for quite some time).
Can you zip up your league files (all of the LEAGUENAME*.* files) and send them to me?
Note that I only play multiplayer, so none of this has been tested against singleplayer careers (and is unlikely to for quite some time).
I sent it to you at the webmaster address.
I'm not sure if that's the correct one.
Thanks.
I sent it to you at the webmaster address.
I'm not sure if that's the correct one.
Thanks.
It's a gigantic zipped file and it's taking forever to be sent to you.
It might not make it.:eek:
gstelmack
01-15-2007, 07:02 PM
It's a gigantic zipped file and it's taking forever to be sent to you.
It might not make it.:eek:
How gigantic? A couple of MB is no problem. If it's 40+, then we could be in trouble. Do you have any place to upload it? You can also try chopping out all of the individual year files (LEAGUEFILE*.YYYY), as they aren't going to be causing this problem and are likely what is bloating it.
I just sent the zipped file without the year files.
gstelmack
01-16-2007, 08:19 PM
Reply sent. The league read fine here, so I'm hypothesizing that you tried to run Interrogator while FOF was open, and Interrogator failed to open the files because someone else had them open. I probably need better error handling for when it fails to open a file.
marcmoustache
01-17-2007, 04:00 AM
Greg/Celeval,
Great job much appreciated. Quick question, Game Player Historical and Game Player Active look like the old player2recs and player1recs - is this roughly correct?
Why have you call them historical and active when they seem to have the same players in them? Of course this could be because I'm running it on a game where all players are active as no-one has retired yet. Going forward are they likely to diverge?
Cheers
Marc.
gstelmack
01-17-2007, 08:46 AM
Greg/Celeval,
Great job much appreciated. Quick question, Game Player Historical and Game Player Active look like the old player2recs and player1recs - is this roughly correct?
Why have you call them historical and active when they seem to have the same players in them? Of course this could be because I'm running it on a game where all players are active as no-one has retired yet. Going forward are they likely to diverge?
Cheers
Marc.
Yes.
Because one has all the active players, and the other has all the active players plus anyone who retired having played at least one game.
Yes.
marcmoustache
01-17-2007, 09:39 AM
Yes.
Because one has all the active players, and the other has all the active players plus anyone who retired having played at least one game.
Yes.
Bingo, looking again I see this as the historical one has non-game related stuff (names, drafted by/round, bowl rings, etc.) while the active one has active data like current team, shirt number, injury, etc.
So really you've given me my xmas presetn by creating player1recs and player2recs and transactions for FOF2k7 which is what I used from the 2k4 Interrogator.
You are very nice chaps!!
Thank ye kindly.
Marc.
Subby
01-17-2007, 10:43 AM
Big thanks to Greg and Celeval! This will make conversion a bit easier on leagues that have lots of customized goodies (like FOFL).
gstelmack
01-17-2007, 10:11 PM
Replaced "Positions" table with "Mappings" table in Interrogator with more mappings of integer fields to equivalent strings.
Extractor can now be run on the draft pool and will extract most draftee data. Interviewees are not yet handled correctly (individual skills not collected, and under/overrated not tracked), but most everything else is. Note that "0" for a combine score means no workout was performed.
marcmoustache
01-18-2007, 03:10 AM
Again, you are a star! :)
Mike D
01-18-2007, 04:17 AM
Thank you! Thank you!
gstelmack
01-19-2007, 08:22 PM
Added PosGroup, Interviewed, and Impressions fields to Extractor output. Interviewed players from the draft class are now fully supported.
Mike D
01-20-2007, 03:25 AM
BTW,
With the refresh of screens now taking longer in FOF2k7, this process takes quite a bit longer. So folks beware. The end results are still worth it, however.
gottimd
01-20-2007, 08:32 AM
I cannot wait til the NAFL switches to 2k7 with all of this new data available. I am still using 2k4 Extractor and haven't even downloaded this version, but from the descriptions/details gstelmack keeps updating, the amount of stuff to use in this will be great.
marcmoustache
01-21-2007, 07:13 AM
I cannot wait til the NAFL switches to 2k7 with all of this new data available. I am still using 2k4 Extractor and haven't even downloaded this version, but from the descriptions/details gstelmack keeps updating, the amount of stuff to use in this will be great.
The 2k4 extractor tables are generally replicated with the prospect of the new gamelog data coming - very nice!
Ben E Lou
01-21-2007, 08:27 AM
Added PosGroup, Interviewed, and Impressions fields to Extractor output. Interviewed players from the draft class are now fully supported.
Do you think that a new version of Draft Analyzer will be released any time soon?
gstelmack
01-21-2007, 11:06 AM
Do you think that a new version of Draft Analyzer will be released any time soon?
Maybe. The issue is that without the grade, I either need to generate my own grade, or you won't be able to do any overall sorting. I'm not sure how useful it would be without that. Have to think about it.
Plus, I have to think about doing the .NET draft utility for MP leagues like WOOF, and getting back to the game log data. So much to do, so little time.
Ben E Lou
01-21-2007, 11:10 AM
Maybe. The issue is that without the grade, I either need to generate my own grade, or you won't be able to do any overall sorting. I'm not sure how useful it would be without that. Have to think about it.My primary reaction is that it would be VERY useful without it. My observation in IHOF has been that people are using the bars and combine scores, not the adjusted ratings.
Plus, I have to think about doing the .NET draft utility for MP leagues like WOOF, and getting back to the game log data. So much to do, so little time.Why re-invent the wheel? VPI has been very generous in letting leagues use his draft utility.
Subby
01-21-2007, 11:29 PM
My primary reaction is that it would be VERY useful without it. My observation in IHOF has been that people are using the bars and combine scores, not the adjusted ratings.
yes! this is true in fofl, too...
gstelmack
01-22-2007, 08:46 AM
Why re-invent the wheel? VPI has been very generous in letting leagues use his draft utility.
I have no experience with it. If it does the following, then there is no need:
Show me player data including combine scores, highlighting the good / bad combine scores, and allow me to sort all those players so that the top guy on my list gets taken.
Or in other words, I want an Analyzer interface to set up my draft lists. All the other online league draft utilities I've seen (which do not include VPI's) have left me lacking and made me go to the game to decide who I wanted on my list, then go to the utility and laboriously organize the list. I want to get enough info to do all my draft work in the utility itself.
Of course, it'll be a long time before I get to something like this and make it functional...
Ben E Lou
01-22-2007, 08:51 AM
I have no experience with it. If it does the following, then there is no need:
Show me player data including combine scores, highlighting the good / bad combine scores, and allow me to sort all those players so that the top guy on my list gets taken.
Or in other words, I want an Analyzer interface to set up my draft lists. All the other online league draft utilities I've seen (which do not include VPI's) have left me lacking and made me go to the game to decide who I wanted on my list, then go to the utility and laboriously organize the list. I want to get enough info to do all my draft work in the utility itself.
Of course, it'll be a long time before I get to something like this and make it functional...No, Todd's is great, but it doesn't do all of that. It does tremendously speed up the draft, though.
gottimd
01-22-2007, 09:23 AM
It would be an added plus if somehow the two utilities could link up. When a player is drafted in the current MP league Draft utility, it takes their name off or automatically highlights them red in the analyzer. Sometimes I step away from the draft for a day or two, and I come back and there have been numerous picks that I have to sift through and mark as drafted.
Its not that big of a deal but it would be an added plus if it was possible at all. Unless I have gone completely off topic, and if I did, just disregard this post.
gottimd
01-22-2007, 09:23 AM
It would be an added plus if somehow the two utilities could link up. When a player is drafted in the current MP league Draft utility, it takes their name off or automatically highlights them red in the analyzer. Sometimes I step away from the draft for a day or two, and I come back and there have been numerous picks that I have to sift through and mark as drafted.
Its not that big of a deal but it would be an added plus if it was possible at all. Unless I have gone completely off topic, and if I did, just disregard this post.
gstelmack
01-22-2007, 09:45 AM
It would be an added plus if somehow the two utilities could link up. When a player is drafted in the current MP league Draft utility, it takes their name off or automatically highlights them red in the analyzer. Sometimes I step away from the draft for a day or two, and I come back and there have been numerous picks that I have to sift through and mark as drafted.
That's what the lower-right text box is for. You copy the list of drafted players out of the FOF draft window, paste it in there, and then click the "Mark" button and they all get marked drafted. And a commish can even export the draftees separately and you can then import that list. The commish can do this no matter what draft utility is being run; it's just an extra step after entering all the picks.
marcmoustache
01-23-2007, 03:42 PM
Greg the problem is that the leagues that use the draft utils run the draft outside of the game (usually mid way through the first FA period) and then once FA is over the commish goes through the whole draft and picks each player taken in the util. At least that's what I assume they do as they'll not be at the draft in the game when the draft is run.
This means you don't get the game's draft list export thing to use in Analyzer.
Really all that needs to be done is expand the draft util to take in the various extra bits of data in the extractor. Not volunteering though ;)
gstelmack
01-23-2007, 03:43 PM
Greg the problem is that the leagues that use the draft utils run the draft outside of the game (usually mid way through the first FA period) and then once FA is over the commish goes through the whole draft and picks each player taken in the util. At least that's what I assume they do as they'll not be at the draft in the game when the draft is run.
This means you don't get the game's draft list export thing to use in Analyzer.
Really all that needs to be done is expand the draft util to take in the various extra bits of data in the extractor. Not volunteering though ;)
I am aware of this particular issue. I was just proposing alternatives that may or may not work for the current circumstances. Rest assured I am thinking on the issue, though.
marcmoustache
01-24-2007, 04:18 AM
ok, tomorrow I'll tell you about taking coals to newcastle ;)
gottimd
01-24-2007, 01:11 PM
I get this error and I tried to run when FOF wasn't open
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.IO.EndOfStreamException: Unable to read beyond the end of the stream.
at System.IO.__Error.EndOfFile()
at System.IO.BinaryReader.ReadChar()
at DataReader.BinaryHelper.ExtractString(BinaryReader inFile, Int16 length, String header)
at DataReader.LeagueData.LoadLeagueFile(String fileName)
at DataReader.LeagueData..ctor(String pathPrefix)
at Interrogator.MainForm.comboBoxSavedGame_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.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
Interrogator
Assembly Version: 1.3.2.0
Win32 Version: 1.3.2.0
CodeBase: file:///C:/Program%20Files/StelmackSoft/FOF2k7%20Utility%20Suite/Interrogator.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
DataReader
Assembly Version: 1.3.2.0
Win32 Version: 1.3.2.0
CodeBase: file:///C:/Program%20Files/StelmackSoft/FOF2k7%20Utility%20Suite/DataReader.DLL
----------------------------------------
WindowsUtilities
Assembly Version: 1.3.2.0
Win32 Version: 1.3.2.0
CodeBase: file:///C:/Program%20Files/StelmackSoft/FOF2k7%20Utility%20Suite/WindowsUtilities.DLL
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.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.
gstelmack
01-25-2007, 07:33 AM
That's the same error GMO got. Unfortunately his ran fine for me. I'll try yours gottimd, and if it crashes I can fix it, but if not I'm not sure what I'll do (other than send you the CSV output).
gottimd
01-25-2007, 07:41 AM
i thought maybe it had something to do with the stage I'm in. But my hypothesis failed. I tried right before the end season, training camp, and regular season and all came up with the same error.
Could it possibly be the default files? I haven't changed anything, like team names, etc. Basically the FOF2k7 I am running is "right out of the box". I loaded it up, simmed a few seasons, and ran the interrogator and the error came up. I saw GMO's error message, but didn't really see a resolution other than the question on if he ran it with the game open or not. But I tried both situations and neither worked.
gstelmack
01-25-2007, 08:08 AM
i thought maybe it had something to do with the stage I'm in. But my hypothesis failed. I tried right before the end season, training camp, and regular season and all came up with the same error.
Could it possibly be the default files? I haven't changed anything, like team names, etc. Basically the FOF2k7 I am running is "right out of the box". I loaded it up, simmed a few seasons, and ran the interrogator and the error came up. I saw GMO's error message, but didn't really see a resolution other than the question on if he ran it with the game open or not. But I tried both situations and neither worked.
Possibly, if I'm not loading the fcy or fni files correctly. Can you try editing one team city name and one team nickname (you can even change them immediately back so they are identical) and see if it works? If that fixes it, I can go to default cities here and try to fix the issue.
gottimd
01-25-2007, 08:43 AM
Possibly, if I'm not loading the fcy or fni files correctly. Can you try editing one team city name and one team nickname (you can even change them immediately back so they are identical) and see if it works? If that fixes it, I can go to default cities here and try to fix the issue.
Woudln't changing one not work still? I would have to change them all. Like right now, mine still has New Orleans Delta Rays. The only problem though is that isn't there people in the IHOF or another fictional league that have different names than the standard NFL names, that this tool is working for them?
marcmoustache
01-25-2007, 09:23 AM
I know Todd doesn't use this in the IHOF. Not sure about others.
gstelmack
01-25-2007, 09:28 AM
Okay, I've found the issue gottimd is having. The problem is that there is apparently a difference between single player careers and multiplayer careers in the save format. My focus right now is on features for multiplayer careers, so it may be a while before I fix Interrogator for single player careers.
I'm not sure if this matches GMO's problem or not, as GMO's league ran fine for me.
marcmoustache
01-25-2007, 10:48 AM
Okay, I've found the issue gottimd is having. The problem is that there is apparently a difference between single player careers and multiplayer careers in the save format. My focus right now is on features for multiplayer careers, so it may be a while before I fix Interrogator for single player careers.
I'm not sure if this matches GMO's problem or not, as GMO's league ran fine for me.
Right this makes sense to me too. I had the problem with a SP game but fine with MP.
gottimd
01-25-2007, 10:59 AM
Yup, it works with MP.
marcmoustache
01-30-2007, 07:06 AM
just to confirm for those looking to use this having used the 2k4 version pre-conversion to 2k7, then the playerids in the old playerrecs tables are consistent with the playerids in the new players tables.
maybe no surprise but good nonetheless
marcmoustache
02-05-2007, 05:28 AM
Greg, minor point, for the interrogator player active report, there's a field for injury length but no column for injury type. I imagine we can get this from the transactions report but it used to be in the playerrecs report.
Cheers
Marc.
gstelmack
02-05-2007, 08:41 AM
Greg, minor point, for the interrogator player active report, there's a field for injury length but no column for injury type. I imagine we can get this from the transactions report but it used to be in the playerrecs report.
Cheers
Marc.
I'll have to dig in closer, but I believe that both are encoded in that one field. Either that, or the injury type is somewhere else in the file.
marcmoustache
02-05-2007, 11:07 AM
Thanks Greg. Also for those using the Interrogator for pre and post conversion, word of warning - in the new transactions report the playerindex needs to be linked to the new game player historical Index field, not the PlayerID field. It seems to me that there is a 2007 player index, the Index field, and a 2004 player index, the playerID field.
Admittedly this is a neat way to deal with pre and post conversion data, but it caused me a bit of a headache today when trying to link the wrong fields!!
Marc.
marcmoustache
02-20-2007, 06:14 AM
Greg,
Question on Extrator on the draft pool - am I right that it doesn't extract the grade or adjusted grade? I can't find it on the csv output.
Cheers
Marc.
gstelmack
02-20-2007, 08:07 AM
Nope, because it's not available on the Player Report window. It grabs pretty much everything off that window of interest. I put a suggestion in a while ago to get that added.
marcmoustache
02-20-2007, 09:25 AM
Nope, because it's not available on the Player Report window. It grabs pretty much everything off that window of interest. I put a suggestion in a while ago to get that added.
Cheers, should have realised that. How's the solevision output going?
gstelmack
02-20-2007, 10:57 AM
Cheers, should have realised that. How's the solevision output going?
It's not. Between WOOF and family, I haven't had any spare time to work on it over the last few weeks. I may post source code soon in case anyone wants to help out.
I should just put the UtilitySuite up on SourceForge or something...
Scruff
02-20-2007, 11:40 AM
Can this utility be used to edit the salary cap in a .fdt file you are using to start a league? If not, is there something else that can accomplish this task? I tried to poke around with this tool a little before I left for work today, but wasn't able to figure out a way to do this. Thanks for any help!
gstelmack
02-20-2007, 11:42 AM
Nope. This just extracts the data, it doesn't edit it (well, except for the city editor one).
Not sure if you can change the cap after the start, because the game also stores cap used and cap free for teams, so you may also need to adjust the cap free.
Scruff
02-20-2007, 12:02 PM
Yeah, ideally I would be able to adjust it in the .fdt file that is imported to the game before I start the world. Then it would just start with that cap automatically. I draft from scratch, so everything should be reset anyway. But I do agree it would have to be adjusted before the .fdt file is imported.
Scruff
02-20-2007, 12:13 PM
And there isn't any way to back the .fdt into an editable .csv file and then reconvert it to .fdt, is there?
gstelmack
03-18-2007, 12:59 PM
Draft Analyzer is back! Very basic functionality right now, just displaying the draft class and coloring combine numbers. Essentially just enough to decide who to interview. More functionality coming, but I'm interested in feedback on the basic data loop of Extractor to Analyzer.
Minor UI tweaks for Interrogator.
Handle "No Workout" for position drill in Extractor.
Correct attribute extraction for draft classes in Extractor.Draft Analyzer still has a ways to go, but as I said above by highlighting combine numbers it is very useful for determining who to interview, and since my office league is at that stage right now I'm releasing this in its current state. I am intending to work on the Mark Drafted bits, then sorting, etc. Screenshot for those unfamiliar with Draft Analyzer:
http://www.gstelmack.com/UtilitySuite/DraftAnalyzer.png
QuikSand
03-18-2007, 01:05 PM
*salivates*
Mike D
03-18-2007, 01:23 PM
Thank you!
WelshWizard
03-18-2007, 01:37 PM
I think i am going to cry. Awesome stuff.
Mike D
03-18-2007, 03:55 PM
I just ran it against the most recent GEFL draft list. It looks even better than before! Missing all the cool features (for now), but the biggest component is back in action. Again, thanks so much. By far, this is my favorite utility (even better than Change Tracker).
Ben E Lou
03-18-2007, 04:02 PM
{Does the "I Heart Greg" dance.}
Ben E Lou
03-18-2007, 04:03 PM
Oh....I've updated the version of this that I'm hosting as well.
kingfc22
03-18-2007, 05:53 PM
SWEET!!!!
RedKingGold
03-18-2007, 06:06 PM
Nice job, Greg!
I was going through Draft Analyzer withdrawal in the most recent GEFL Draft.
Subby
03-18-2007, 06:26 PM
Oh great now the my enormous advantage over the rest of ihof is gone.
THANKS GREG!
RedKingGold
03-18-2007, 07:16 PM
Oh great now the my enormous advantage over the rest of ihof is gone.
THANKS GREG!
Which one is it? The or my?
JetsIn06
03-18-2007, 08:21 PM
I don't know if I'm missing something....but after extracting the draft data, I went to the draft analyzer....clicked on load exported data, and then dont know where to go? How do I save that data I just extracted?
Thanks
gstelmack
03-18-2007, 08:41 PM
The data you extracted is written to the Utilities folder (where you installed the Utilities) as "FOFRoster.txt".
And yes, I'm a hypocrite since I'm not saving this off to My Documents (yet).
Subby
03-18-2007, 09:55 PM
Which one is it? The or my?
both - that's how big it they is
WelshWizard
03-18-2007, 10:13 PM
The data you extracted is written to the Utilities folder (where you installed the Utilities) as "FOFRoster.txt".
And yes, I'm a hypocrite since I'm not saving this off to My Documents (yet).
I have that, but how do you save it from there. In other words if someone is in multiple leagues and drafts going on around the same time. How can i save each one and give it its own name. I do not get the option to save anything when i open up the file at the top. It just lets me load extractor output. Is there a way to save it once you have it populated?
gstelmack
03-19-2007, 09:00 AM
Save / Load is not implemented yet. But just rename that FOFRoster.csv (sorry, screwed up the extension earlier) to something else (I use LEAGUENAME YEAR.csv, e.g. "WOOF 2006.csv") to manage multiple leagues. Draft Analyzer will let you load any file as long as it has the same format and layout as the Extractor files.
WelshWizard
03-19-2007, 07:53 PM
Excellent, Thanks very much.
primelord
03-19-2007, 09:03 PM
By far, this is my favorite utility (even better than Change Tracker).
How dare you!
Mike D
03-21-2007, 04:50 PM
How dare you!
Hey, he's got more pretty colors in his utility. :)
gstelmack
03-24-2007, 12:15 PM
Draft Analyzer now lets you right-click on the draft list to either "mark" players for future reference, or to note that they have been drafted. "Marked" players will have a yellow background, "Drafted" players will have a red background.
Draft Analyzer has a text box that lets you paste a list of draftees from the FOF draft progress window and then mark that those players have been drafted in the draft list.
Draft Analyzer can now export and import lists of drafted players. This is intended for multiplayer leagues to help everyone follow along.This provides the minimum functionality to help you manage and follow along with a draft. I'm going to shelve this for a bit to get back to Interrogator for some features we want for WOOF. I hope to return to this to add sorting and maybe some other stuff, but it will be a bit.
gottimd
04-02-2007, 07:10 AM
Has the interrogator been updated for 2k7 or is there something wrong with my league files? It gives me this error message and crashes:
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.OverflowException: Arithmetic operation resulted in an overflow.
at DataReader.LeagueData.LoadLeagueFile(String fileName)
at DataReader.LeagueData..ctor(String pathPrefix)
at Interrogator.MainForm.comboBoxSavedGame_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.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
Interrogator
Assembly Version: 1.4.1.0
Win32 Version: 1.4.1.0
CodeBase: file:///C:/Program%20Files/StelmackSoft/FOF2k7%20Utility%20Suite/Interrogator.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
DataReader
Assembly Version: 1.4.1.0
Win32 Version: 1.4.1.0
CodeBase: file:///C:/Program%20Files/StelmackSoft/FOF2k7%20Utility%20Suite/DataReader.DLL
----------------------------------------
WindowsUtilities
Assembly Version: 1.4.1.0
Win32 Version: 1.4.1.0
CodeBase: file:///C:/Program%20Files/StelmackSoft/FOF2k7%20Utility%20Suite/WindowsUtilities.DLL
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.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.
gstelmack
04-02-2007, 09:25 AM
??? This is a 2k7-only utility suite, so yes it has been updated.
The only known issue with Interrogator is single-player careers: it won't work on them. There is a file difference I haven't bothered to try and track down. I have not had any issues with multiplayer careers yet.
gottimd
04-02-2007, 10:09 AM
We just converted to 2k7, and I am running the interrogator on the MP file and it is coming up with that error.
gstelmack
04-02-2007, 10:27 AM
Then when I get a chance I'll have to download the NAFL files and see what's happening.
You guys aren't the league with the messed-up player that I dealt with before, are you? Something about the guy's draft year being screwed up or something similar? I remember one league had a bad player in it from their original file and that screwed up Interrogator in 2k4, too.
gottimd
04-02-2007, 10:31 AM
Yes we were. I think it was a Jon Jansen had either a birthdate or draftdate of 19999.
ShaneTheMaster
04-02-2007, 07:48 PM
Good stuff, as always, Greg!
kingfc22
04-02-2007, 09:20 PM
Draft Analyzer now lets you right-click on the draft list to either "mark" players for future reference, or to note that they have been drafted. "Marked" players will have a yellow background, "Drafted" players will have a red background.
Draft Analyzer has a text box that lets you paste a list of draftees from the FOF draft progress window and then mark that those players have been drafted in the draft list.
Draft Analyzer can now export and import lists of drafted players. This is intended for multiplayer leagues to help everyone follow along.This provides the minimum functionality to help you manage and follow along with a draft. I'm going to shelve this for a bit to get back to Interrogator for some features we want for WOOF. I hope to return to this to add sorting and maybe some other stuff, but it will be a bit.
SWEET!!! Going to save me so much time for the WAFL draft.
gstelmack
04-21-2007, 02:05 PM
Interrogator's Historical Player Records now include "Player of the Week Mentions" (column is "PoWMentions") and "Player of the Week Wins" (column is "PoWWins").
Renamed the following tables by dropping the "Game " prefix:
Game Draft -> Draft
Game Transactions -> Transactions
Game Player Historical -> Player Historical
Game Player Active -> Player Active
Game Draft -> Draft
Game Draft -> Draft
Added the following tables:
Seasons: Data on the player/commish's team for each season.
Franchise Performances: Data on how each franchise did during each season, including economics and win/loss totals.
Game Results: Data on each game played during each season, including who was involved, attendance, the final score, and key leaders.
NOTE: This was spot-checked across a couple of leagues, but as always pay close attention to your data and let me know if anything looks wrong. Those of you sucking this data into league web sites, if anything is difficult to use please let me know. I know some fields need translation work, but I probably won't get to that until I've finished parsing the FJU file and the season stats data files.
cuervo72
04-22-2007, 12:30 PM
w00t! Hopefully no more updating game results by hand for me. :)
(site actually driven by the old schedule table rather than game results, but the information was for the most part duplicated, and I am sure I can arrange the info as I need for both)
Thanks gs!
gstelmack
04-22-2007, 12:51 PM
(site actually driven by the old schedule table rather than game results, but the information was for the most part duplicated, and I am sure I can arrange the info as I need for both)
Just as an FYI, for WOOF I know where the current city data, team schedule, and player game-by-game stats are located. The trouble is there is a block between them and the new tables I put out in this release that I haven't decoded yet (and that block is variable among leagues). Decoding that is next on the Interrogator list.
marcmoustache
04-23-2007, 12:55 AM
Great work again Greg. Like the new format of the game results table.
If I had one request it would be that the "PLayer Active" table has injurylength but doesn't list the injury code like the old playerrecs table did.
Cheers
Marc.
gstelmack
04-23-2007, 08:07 AM
If I had one request it would be that the "PLayer Active" table has injurylength but doesn't list the injury code like the old playerrecs table did.
That's because I haven't found the actual injury yet. I did just discover that transaction "28" in the transaction log is an injury, so that may help me track down the actual injury location.
Right now the focus is on filling out the rest of the file format, then I'll get back to some of the unknown fields I've got to flesh out some of the tables. Well, the short-term focus is actually on some Draft Analyzer tweaks to prep for the WOOF draft, then back to the file format, then on to the unknown fields...
marcmoustache
04-23-2007, 10:09 AM
That's because I haven't found the actual injury yet. I did just discover that transaction "28" in the transaction log is an injury, so that may help me track down the actual injury location.
Right now the focus is on filling out the rest of the file format, then I'll get back to some of the unknown fields I've got to flesh out some of the tables. Well, the short-term focus is actually on some Draft Analyzer tweaks to prep for the WOOF draft, then back to the file format, then on to the unknown fields...
Gotcha, not a demand, just a gentle push :) If I can help let me know, doubt it, but let me know.
cuervo72
04-23-2007, 10:10 AM
Just as an FYI, for WOOF I know where the current city data, team schedule, and player game-by-game stats are located. The trouble is there is a block between them and the new tables I put out in this release that I haven't decoded yet (and that block is variable among leagues). Decoding that is next on the Interrogator list.
That's interesting. Wonder what causes that (would it be something that grows as the league ages, for instance). And fwiw, I'm happy with anything I can get. :)
Ohh...and the injury information being in the transaction table is interesting too. I'll have to look at that some. Makes sense that that is how Jim would log it though.
marcmoustache
04-23-2007, 10:22 AM
That's interesting. Wonder what causes that (would it be something that grows as the league ages, for instance). And fwiw, I'm happy with anything I can get. :)
Ohh...and the injury information being in the transaction table is interesting too. I'll have to look at that some. Makes sense that that is how Jim would log it though.
Does this show up "in-game" in the league transactions log or just the player card?
Yes, take what you can get. :D
gstelmack
04-23-2007, 11:43 AM
Does this show up "in-game" in the league transactions log or just the player card?
Just the player card. Those "28" entries were bugging me for a while (because they don't show up in the transaction log) until I figured this out this weekend looking at something else.
marcmoustache
04-23-2007, 03:12 PM
Just the player card. Those "28" entries were bugging me for a while (because they don't show up in the transaction log) until I figured this out this weekend looking at something else.
Ok, makes sense.
gstelmack
04-29-2007, 07:50 AM
Interrogator's Mappings file now shows transaction type 28 as "Injury".
Draft Analyzer now lets you set what round you think a player should be taken in. This includes a "Don't draft" option and an "Undrafted FA" option to help you track guys to try and get after the draft.
Added some hotkeys to Draft Analyzer:
1-7: Set draft round to 1-7
X: Don't draft this guy ever
F: Keep an eye on this guy in the FA period
+: Move the guy up within his round
-: Move the guy down within his round
M: Mark this player to keep an eye out for
D: Note that this player has been drafted
Arrow keys: Move up and down the draft listIt is hoped that with these two changes, "Marking" will be used as it is coming up on your pick, while the rounds can be used to keep track of who is worth drafting. Note that depending on how far up or down the draft board a guy moves, it can take a few seconds to adjust the draft order, so be patient.
Clicking a column header in Draft Analyzer will now sort based on that column. If you click again, it will reverse the sort.I'm now back to Interrogator for a bit while this change gets absorbed. As always, feedback on how well this works / is the UI okay welcomed.
marcmoustache
04-30-2007, 02:45 AM
Answered this myself. Seems that the injuries do how up in the transactions log. The salary column hsa the weeks injured and the years column has the injury type.
Thanks as always Greg, just to be clear, does this mean that injuries will show up in the transactions log?
Interrogator's Mappings file now shows transaction type 28 as "Injury".
As always, feedback on how well this works / is the UI okay welcomed.
gstelmack
04-30-2007, 08:03 AM
Answered this myself. Seems that the injuries do how up in the transactions log. The salary column hsa the weeks injured and the years column has the injury type.
Thanks for figuring that out. Once I finish with the data (and I made another good breakthrough yesterday, including finding most of the stadium data which is something I've hunted for since I started Interrogator years ago), I need to go back through and figure out some of these mappings, which will include breaking down the transactions into something easier to interpret (which will probably mean adding columns, and leaving ones that don't apply to that transaction set to 0 or -1 or something similar).
cuervo72
04-30-2007, 09:48 AM
Ohh, helpful tidbit marc. It's bugged me that Jim puts different types of data in the same fields (coach vs player, which can be difficult to determine, and trades). Calls for that much more logic on the back end.
(hmm, coach information.... ;) )
marcmoustache
04-30-2007, 11:02 AM
Ohh, helpful tidbit marc. It's bugged me that Jim puts different types of data in the same fields (coach vs player, which can be difficult to determine, and trades). Calls for that much more logic on the back end.
(hmm, coach information.... ;) )
Yes, a bit of a pain and why my transactions reports looked a bit funny until I worked the mappings out!!
I always thought it was "titbit", you say tomato...
Wasabiak
04-30-2007, 09:32 PM
"Clicking a column header in Draft Analyzer will now sort based on that column. If you click again, it will reverse the sort. "
I love you.
Ben E Lou
05-03-2007, 07:17 AM
Latest version updated in stickied download folder.
gstelmack
05-04-2007, 08:24 AM
NOTE: WOOF just transitioned to a new season, and now Interrogator is all whacked. This does not appear to be a 6.0e issue, but rather something in the layout differs once starting the new season. This may or may not be related to the issue with single-player games.
I'll see if I can fix it, or if it corrects once Staff Hiring I runs (in which case it may be easier to fix, as I can do the diffs).
VPI97
05-04-2007, 08:50 AM
NOTE: WOOF just transitioned to a new season, and now Interrogator is all whacked. This does not appear to be a 6.0e issue, but rather something in the layout differs once starting the new season. This may or may not be related to the issue with single-player games.
I'll see if I can fix it, or if it corrects once Staff Hiring I runs (in which case it may be easier to fix, as I can do the diffs).
FYI, I had the same problem with IHOF, but it seems to clear up once the draft class is revealed.
marcmoustache
05-05-2007, 02:18 AM
NOTE: WOOF just transitioned to a new season, and now Interrogator is all whacked. This does not appear to be a 6.0e issue, but rather something in the layout differs once starting the new season. This may or may not be related to the issue with single-player games.
I'll see if I can fix it, or if it corrects once Staff Hiring I runs (in which case it may be easier to fix, as I can do the diffs).
Bugger, this would be bad.
marcmoustache
05-05-2007, 10:35 AM
what changes Greg? Or is that a stupid question and if you knew then you'd be able to fix it :confused:
gstelmack
05-05-2007, 12:20 PM
I'm pretty sure the answer is we were handling e-mails incorrectly, so it breaks whenever there are two e-mails available (and this may or may not be the single-player issue). I've got a fix, hope to get a new one out soon (along with some new data).
gstelmack
05-05-2007, 02:02 PM
Added "WantsTeam" to Interrogator's City Table, removed "HasTeam" (unreliable). When a game is loaded, the City Table is reloaded with the game's data.
Added "Team Schedule" table with information on each team's schedule for the current season.
Added "Draft Order" table with a list of which team has which pick in the current draft. This does all the necessary translations from the "Draft" table and is set up to work with the online drafting utilities to stop making the commish do a bunch of hand-editing. If anyone needs customized tables like this for importing into their league websites, let me know. I'm working on one for the draft class as well.
Interrogator should now work when there is more than one e-mail available (notably at the start of a new season for an MP league).Note that I also know how to grab the player game-by-game stats, but I'm not sure I'll have time to get them in before I go on vacation in a week, and I need to concentrate on the WOOF offseason. Expect those by early June, though.
Cuckoo
05-05-2007, 07:01 PM
[LIST]
Added "Draft Order" table with a list of which team has which pick in the current draft. This does all the necessary translations from the "Draft" table and is set up to work with the online drafting utilities to stop making the commish do a bunch of hand-editing. If anyone needs customized tables like this for importing into their league websites, let me know. I'm working on one for the draft class as well.
Fantastic!
marcmoustache
05-06-2007, 01:14 AM
Added "WantsTeam" to Interrogator's City Table, removed "HasTeam" (unreliable). When a game is loaded, the City Table is reloaded with the game's data.
Added "Team Schedule" table with information on each team's schedule for the current season.
Nice, the schedule will be very handy!
Interrogator should now work when there is more than one e-mail available (notably at the start of a new season for an MP league).
You're definately my hero Greg :)
Note that I also know how to grab the player game-by-game stats, but I'm not sure I'll have time to get them in before I go on vacation in a week, and I need to concentrate on the WOOF offseason. Expect those by early June, though.
Well done, I've got my boxscore processing singing but this may be quicker and easier!
Greg, quick question: In the new Team Schedule table, what does the value 999 indicate?
marcmoustache
05-06-2007, 09:52 AM
Greg, quick question: In the new Team Schedule table, what does the value 999 indicate?
It means the team doesn't play that week. Also the weeks start at 1 for exhibition 1, so regular season week 1 is week 6, playoffs are 23 onwards.
So at the start of the season you should see most teams with 999 in week 1, a 999 row during the season to reflect the bye-week and weeks 23-26 set at 999 as these are the playoff weeks.
Marc.
That makes sense, although I would suggest putting the actual value in the "Week" column and leaving 999 in the others. I was hoping to make the primary key of this table "TeamIndex" + "Week", but with the multiple "999" values in the Week column I can't do this. There doesn't seem to be a good combination for a primary key here. Does that make sense?
marcmoustache
05-06-2007, 09:56 AM
just a quick question, anyone worked out the weather mappings?
gstelmack
05-06-2007, 10:32 AM
That makes sense, although I would suggest putting the actual value in the "Week" column and leaving 999 in the others. I was hoping to make the primary key of this table "TeamIndex" + "Week", but with the multiple "999" values in the Week column I can't do this. There doesn't seem to be a good combination for a primary key here. Does that make sense?
You can ignore the 999 rows, or I can just drop them completely from the output (which is what I think I used to do).
Thanks, Greg. It would be a little easier for me if they were dropped completely from the output. Then I wouldn't have to do anything special when converting from the csv file to a sql file.
Shard77
05-06-2007, 12:46 PM
Greg,
Does the draft order table only update with traded picks once the season ends? Our league is currently in week 6 of the regular season and I just exported the draft order table as a test. The table is defaulting to the teams that originally owned the draft picks, not the teams that acquired them via trade. Will this update after the season is over?
Thanks for your help.
gstelmack
05-06-2007, 03:34 PM
Greg,
Does the draft order table only update with traded picks once the season ends? Our league is currently in week 6 of the regular season and I just exported the draft order table as a test. The table is defaulting to the teams that originally owned the draft picks, not the teams that acquired them via trade. Will this update after the season is over?
Thanks for your help.
I believe so. If you look at just Draft.csv, you can probably see how things will work out when you get to next season, as that is where the trades are tracked.
Draft Order.csv was just thrown in to get draft order for the current season for the draft utilities.
gottimd
05-07-2007, 02:16 PM
So in the NAFL, we have been tracking every single transaction for every player since the dawn of mankind (ok, just the beginning of the league). I have a csv file of all of the old transactions by week for the 2004-2011 and I am trying to "convert" them to look the same way the interrogator does so I can upload them and have the complete history all in one place instead of having a 2004-2011 utility and a 2012+ utility.
So far the problem I am having is coding of the Stages in the offseason/preseason. What I have so far is:
<TABLE style="WIDTH: 169pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=225 border=0 x:str><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 121pt; mso-width-source: userset; mso-width-alt: 5888" width=161><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 48pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right width=64 height=17 x:num>999</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 121pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=161>Off Season</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>1001</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Staff Hiring Week 1</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>1002</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Staff Hiring Week 2</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>1003</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Staff Hiring Week 3</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>400</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>501</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>502</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>503</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>504</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>505</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>506</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>507</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>508</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>509</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>510</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>600</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>700</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>1301</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>1302</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>1303</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>1200</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>1</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Preseason Week 1</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>2</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Preseason Week 2</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>3</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Preseason Week 3</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>4</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Preseason Week 4</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>5</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Preseason Week 5</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>6</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 1</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>7</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 2</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>8</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 3</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>9</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 4</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>10</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 5</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>11</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 6</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>12</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 7</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>13</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 8</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>14</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 9</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>15</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 10</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>16</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 11</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>17</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 12</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>18</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 13</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>19</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 14</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>20</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 15</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>21</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 16</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>22</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 17</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>23</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Wild Card Round</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>24</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Divisional Playoff</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>25</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Conference Championship</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>26</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">NAFL Bowl</TD></TR></TBODY></TABLE>
I assume I am missing Free Agency Stages, Draft, Training camp but I can't tell which is which. Any help, I know someone probably has a quick answer.
Edit: What is strange is that is seems like there are players missing. No one important, most likely they are the ones who were draft eligible, might have played one game after being picked up out of FA and then released and retired a season later. They don't seem to show up in the "Player Historical Tables".
cuervo72
05-08-2007, 12:32 PM
just a quick question, anyone worked out the weather mappings?
Yes, this seems to be problematic for me as well. I had been manually updating entries for FOFL games (luckily, the old interrogator pulled the *exact* schedule from 2k4 if you continued to the next season...from there I just ran update statements), including temp and precip. The last digit in the interrogator output for weather seems to match the last digit of temp, but beyond that, no idea.
(I'm trying to figure out a way to import the info but not blow away the previous temps...more difficult as I appended the year as an end column, and just did an import/replace existing straight up on all columns).
cuervo72
05-08-2007, 01:55 PM
Well, at least in the case of fair weather with no wind, this field appears to be temp + 10. Things get screwier with wind/precipitation (and at least in FOFL, there have been no instances of precipritation w/o wind).
gstelmack
05-08-2007, 02:09 PM
Well, at least in the case of fair weather with no wind, this field appears to be temp + 10. Things get screwier with wind/precipitation (and at least in FOFL, there have been no instances of precipritation w/o wind).
This should be a good math puzzle (that I just haven't had time to look at yet). How about posting a few numbers along with the real FOF weather in a thread and we can all figure it out?
(I'm away from any data that would let me do that myself at the moment).
cuervo72
05-08-2007, 02:25 PM
Actually, I might have it (or am really close).
It's something like this:
snow = 23400
rain = 7800
wind = 120x
temp = temp + 10
Or something screwy like that...for example:
8824 = 7800 + (8 * 120) + (54 + 10)
In this case, you can subtract 7800 from the number, so we know there is rain. From that, you can subtract 120*8, so you have an 8 mph wind. After subtracting those two, you are left with 64, which is the temperature + 10. Maybe the +10 is there to account for temperatures in the negative range (has there ever been -10 or -11 I wonder?).
Here's another: 24283
24283 = 23400 + (7 * 120) + (33 + 10)
In other words, snow, 7mph winds, 33 degrees.
I've not checked this for all of the FOFL dates, but I think it looks pretty good (wow, just checked for 10617, and yes indeed there were 23 mph winds!). The only precip options I've seen are the 7800 and 23400 factors, there may be another in there (storm) which we've just not had (there is a gap in the numbers between 10617 and 24283, so there's room I suppose).
gstelmack
05-08-2007, 02:37 PM
Think of it slightly differently, as masks:
Temp = (Weather % 120) - 10
Wind = (Weather / 120) % 64 (what's the fastest anyone has seen?)
Precip = Weather / 7800
Or to build it up:
Weather = (Temp + 10) + (Wind*120) + (Precip*7800)
You get 120 temperature values, 64 wind values, and then the precip flags.
cuervo72
05-08-2007, 02:44 PM
Pretty much it, yes. I did fail to recognize that 23400 = 3 * 7800. :)
Though for the temp at least, don't you need to get the precip out of the way first?
gstelmack
05-08-2007, 03:14 PM
Pretty much it, yes. I did fail to recognize that 23400 = 3 * 7800. :)
Though for the temp at least, don't you need to get the precip out of the way first?
% 120 = Modulo 120 = Remainder after you divide by 120 = get rid of everything else ;)
cuervo72
05-08-2007, 03:21 PM
Gah. Me of all people should have realized that. So I know what the mod is, just not how to use it efficiently. :D Well, either way I have perl parsing it fine (which I'm assuming I won't need to do before long).
Ben E Lou
05-08-2007, 03:52 PM
Suggestion For Analyzer:
Something similar to the "Edit Weights" function in the old version, where we could weight the different combine scores for the different positions, so we can have a numerical rating for every player.
gstelmack
05-08-2007, 03:52 PM
(which I'm assuming I won't need to do before long).
Correct. When I get a chance, I'll break these out in Interrogator.
Only delay will be the fact that I'm off for Florida for 2 weeks starting this weekend, so no progress then.
gstelmack
05-08-2007, 03:57 PM
Suggestion For Analyzer:
Something similar to the "Edit Weights" function in the old version, where we could weight the different combine scores for the different positions, so we can have a numerical rating for every player.
This has been on my list, but the lack of a bureau rating has hindered my enthusiasm. I will probably get to it, however.
cuervo72
05-08-2007, 03:57 PM
BTW - did some transaction digging, and transaction 29 looks to be "Renovation vote failed", and 27 is "Send to Summer League". 31 I believe is "Franchise move failed".
marcmoustache
05-08-2007, 04:00 PM
gottimd, I've got this and will get it over to you.
So in the NAFL, we have been tracking every single transaction for every player since the dawn of mankind (ok, just the beginning of the league). I have a csv file of all of the old transactions by week for the 2004-2011 and I am trying to "convert" them to look the same way the interrogator does so I can upload them and have the complete history all in one place instead of having a 2004-2011 utility and a 2012+ utility.
So far the problem I am having is coding of the Stages in the offseason/preseason. What I have so far is:
<TABLE style="WIDTH: 169pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=225 border=0 x:str><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 121pt; mso-width-source: userset; mso-width-alt: 5888" width=161><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 48pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right width=64 height=17 x:num>999</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 121pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=161>Off Season</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>1001</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Staff Hiring Week 1</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>1002</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Staff Hiring Week 2</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>1003</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Staff Hiring Week 3</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>400</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>501</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>502</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>503</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>504</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>505</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>506</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>507</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>508</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>509</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>510</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>600</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>700</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>1301</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>1302</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>1303</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>1200</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>1</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Preseason Week 1</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>2</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Preseason Week 2</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>3</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Preseason Week 3</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>4</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Preseason Week 4</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>5</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Preseason Week 5</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>6</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 1</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>7</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 2</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>8</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 3</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>9</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 4</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>10</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 5</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>11</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 6</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>12</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 7</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>13</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 8</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>14</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 9</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>15</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 10</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>16</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 11</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>17</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 12</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>18</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 13</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>19</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 14</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>20</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 15</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>21</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 16</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>22</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 17</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>23</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Wild Card Round</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>24</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Divisional Playoff</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>25</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Conference Championship</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>26</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">NAFL Bowl</TD></TR></TBODY></TABLE>
I assume I am missing Free Agency Stages, Draft, Training camp but I can't tell which is which. Any help, I know someone probably has a quick answer.
Edit: What is strange is that is seems like there are players missing. No one important, most likely they are the ones who were draft eligible, might have played one game after being picked up out of FA and then released and retired a season later. They don't seem to show up in the "Player Historical Tables".
gottimd
05-08-2007, 04:34 PM
marc, I think I got them.
<TABLE style="WIDTH: 169pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=225 border=0 x:str><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 121pt; mso-width-source: userset; mso-width-alt: 5888" width=161><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 48pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right width=64 height=17 x:num>999</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 121pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=161>Off Season</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>1001</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Staff Hiring Week 1</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>1002</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Staff Hiring Week 2</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>1003</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Staff Hiring Week 3</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>400</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Pre-Free Agency</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>501</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Free Agency Week 1</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>502</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Free Agency Week 2</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>503</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Free Agency Week 3</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>504</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Free Agency Week 4</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>505</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Free Agency Week 5</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>506</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Free Agency Week 6</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>507</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Free Agency Week 7</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>508</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Free Agency Week 8</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>509</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Free Agency Week 9</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>510</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Free Agency Week 10</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>600</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Draft</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>700</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Pre Late-Free Agency</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>1301</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Late Free Agency Week 1</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>1302</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Late Free Agency Week 1</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>1303</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Late Free Agency Week 1</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>1200</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Training Camp</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>1</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Preseason Week 1</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>2</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Preseason Week 2</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>3</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Preseason Week 3</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>4</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Preseason Week 4</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>5</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Preseason Week 5</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>6</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 1</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>7</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 2</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>8</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 3</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>9</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 4</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>10</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 5</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>11</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 6</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>12</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 7</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>13</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 8</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>14</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 9</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>15</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 10</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>16</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 11</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>17</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 12</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>18</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 13</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>19</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 14</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>20</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 15</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>21</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 16</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>22</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 17</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>23</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Wild Card Round</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>24</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Divisional Playoff</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>25</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Conference Championship</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>26</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">NAFL Bowl</TD></TR></TBODY></TABLE>
gstelmack
05-08-2007, 08:37 PM
Thanks for the extra info guys. Should have checked here earlier, but I'll get those into the lookup tables for the next release.
gstelmack
05-08-2007, 08:38 PM
Interrogator no longer writes Team Schedule weeks that have "999" for the week and are thus unscheduled.
Interrogator breaks out "Weather" into "Temperature", "Precip", and "Wind" columns.
Draft Analyzer no longer fills in "Round 1" for everyone when importing Extractor output.That last one drove me nuts when starting to do my draft list for my office league today...
Interrogator no longer writes Team Schedule weeks that have "999" for the week and are thus unscheduled.
Thank you!
marcmoustache
05-09-2007, 12:39 AM
ok, they should have been in the trans_lookup table i sent you?
marc, I think I got them.
<TABLE style="WIDTH: 169pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=225 border=0 x:str><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 121pt; mso-width-source: userset; mso-width-alt: 5888" width=161><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 48pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right width=64 height=17 x:num>999</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 121pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=161>Off Season</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>1001</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Staff Hiring Week 1</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>1002</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Staff Hiring Week 2</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>1003</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Staff Hiring Week 3</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>400</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Pre-Free Agency</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>501</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Free Agency Week 1</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>502</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Free Agency Week 2</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>503</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Free Agency Week 3</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>504</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Free Agency Week 4</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>505</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Free Agency Week 5</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>506</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Free Agency Week 6</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>507</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Free Agency Week 7</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>508</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Free Agency Week 8</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>509</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Free Agency Week 9</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>510</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Free Agency Week 10</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>600</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Draft</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>700</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Pre Late-Free Agency</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>1301</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Late Free Agency Week 1</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>1302</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Late Free Agency Week 1</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>1303</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Late Free Agency Week 1</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>1200</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Training Camp</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>1</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Preseason Week 1</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>2</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Preseason Week 2</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>3</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Preseason Week 3</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>4</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Preseason Week 4</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>5</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Preseason Week 5</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>6</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 1</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>7</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 2</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>8</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 3</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>9</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 4</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>10</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 5</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>11</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 6</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>12</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 7</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>13</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 8</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>14</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 9</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>15</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 10</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>16</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 11</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>17</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 12</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>18</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 13</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>19</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 14</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>20</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 15</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>21</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 16</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>22</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Regular Season Week 17</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>23</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Wild Card Round</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>24</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Divisional Playoff</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>25</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Conference Championship</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>26</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">NAFL Bowl</TD></TR></TBODY></TABLE>
gottimd
05-10-2007, 08:58 AM
Is the Draft.csv file picking up the correct order in the future years? To me, it looks like it is only showing 7 picks for everyone however, future picks have been traded.
gottimd
05-11-2007, 08:26 AM
Are career stats and/or current season stats available in the coding anywhere?
gstelmack
05-26-2007, 01:00 PM
Yes, a bit of a pain and why my transactions reports looked a bit funny until I worked the mappings out!!
What transaction mappings have you worked out? It would save me some work if you've already figured some of them out. I intend to expand the column list in transactions to decompress and make them make more sense.
Unless it is easier for all of you for me to leave them be, in which case I'll rename them and stop the salary translation if needed.
marcmoustache
05-27-2007, 11:26 AM
[quote=marcmoustache;1454681]Yes, a bit of a pain and why my transactions reports looked a bit funny until I worked the mappings out!!/quote]
What transaction mappings have you worked out? It would save me some work if you've already figured some of them out. I intend to expand the column list in transactions to decompress and make them make more sense.
Unless it is easier for all of you for me to leave them be, in which case I'll rename them and stop the salary translation if needed.
Not sure now, looking back, the only odd ones were 29 and 30 which are the stadium ones I think and the team2 column is 1 for accepted and 0 for rejected.
The injury one (28) is a bit tricky and I've worked out that the years column is the injury type, but I can't seem to see the corrlation to the weeks, however, when you see an injury on the player card I don't think it says how many weeks it was. In the end I've written a little code to parse in the html injury file and capture injuries that way.
I'd be happier if you left it as is, otherwise I've got some re-coding to do, but that's just me!
gstelmack
05-28-2007, 08:32 AM
Interrogator now converts all quote characters to apostrophe characters in fields on CSV write. This is mostly to fix bad characters entered manually into player name fields.
Interrogator's mappings file now has a complete list of transactions (I believe).
Interrogator's Transactions table now includes the year as the last column, and includes all seasons played in 2k7.
Interrogator now has a PlayerGameStats table with stats for each game a player played in. This includes all past seasons that you have stats for.Upcoming plans include:
Draft Analyzer combine weights for a single combine score.
Draft Analyzer to parse game HTML for bureau ratings.
Spit out a few more bits in Interrogator (I'm pretty sure I've found stadium information, for example).
Add an option to Interrogator to ignore seasons prior to a specified one. If you're in 2018, no reason to be dumping out game stats from 2008 or something unless you've lost that old data...
Greg, I just tried version 1.4.6 and I get the following error. This happens when I pick my saved game (the CFL) from the list. Interestingly if I pick the one for the WOOF I don't get an error. If you need any other information just let me know.
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.IO.EndOfStreamException: Unable to read beyond the end of the stream.
at System.IO.__Error.EndOfFile()
at System.IO.BinaryReader.FillBuffer(Int32 numBytes)
at System.IO.BinaryReader.ReadInt16()
at DataReader.BinaryHelper.ReadInt16(BinaryReader inFile, String name)
at DataReader.LeagueData.LoadSeasonFile(String fileName, Int32 curSeasonIndex)
at DataReader.LeagueData.LoadSeasonData(String pathPrefix)
at DataReader.LeagueData..ctor(String pathPrefix, UniverseData universeData)
at Interrogator.MainForm.comboBoxSavedGame_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.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
Interrogator
Assembly Version: 1.4.6.0
Win32 Version: 1.4.6.0
CodeBase: file:///C:/Program%20Files/StelmackSoft/FOF2k7%20Utility%20Suite/Interrogator.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
DataReader
Assembly Version: 1.4.6.0
Win32 Version: 1.4.6.0
CodeBase: file:///C:/Program%20Files/StelmackSoft/FOF2k7%20Utility%20Suite/DataReader.DLL
----------------------------------------
WindowsUtilities
Assembly Version: 1.4.6.0
Win32 Version: 1.4.6.0
CodeBase: file:///C:/Program%20Files/StelmackSoft/FOF2k7%20Utility%20Suite/WindowsUtilities.DLL
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
CodeBase: file:///C:/Windows/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.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.
gottimd
05-28-2007, 06:56 PM
Me too...for the NAFL. Prior version worked fine, but I am getting the same message Taco is getting.
gstelmack
05-28-2007, 07:47 PM
I'll have to grab files for one of these leagues and see where it is dropping out. My guess is going to be that these are converted leagues, and the old 2k4 seasons don't have the transaction data at the end or something similar.
gstelmack
05-28-2007, 08:19 PM
Fix a crash in Interrogator when run on converted 2k4 leagues, or those missing some season stats files.
Sorry about that folks. I'd tell you what the problem was, but then Jim would laugh at me...
marcmoustache
05-29-2007, 01:09 AM
Thanks Greg, great work again. For the record the transactions log doesn't go back to pre-conversion transactions, although I don't think that's what you meant by "past seasons" anyway.
gottimd
05-29-2007, 07:26 AM
Great Work yet again, pretty much goes without saying!
Quick question, not sure if it was covered earlier in the thread, but there is a "Generate Access DB" button that is greyed out. Is this for future versions or am I missing something where I can activate this option?
Player Game Stats, at least for leagues with a lot of history, don't fit on the CSV file (larger than 65K lines). NAFL is in 2012, started in 2004, and when I open this CSV file, it gives me an error message which looks to be because the lines of data exceed the allowable excel lines in a sheet.
EDIT: Just to clarify, its not an error in the Extractor itself, but when opening that CSV file, Microsoft gives me an error, but the CSV file still opens up.
marcmoustache
05-29-2007, 08:48 AM
Yep, you'll only get the first 3.5 seasons to open in excel.
gstelmack
05-29-2007, 10:36 AM
On the "Generate Access DB" button: that's a possible future feature. Not sure yet if I'll do it, what the interest is, etc. Everyone seems to be just importing the CSVs.
On the number of lines in the game stats: That's one reason I asked about separate files vs one large one. There are roughly 24,500 records per season in that CSV. Once I do the "only generate CSV for recent seasons" feature, that will help.
marcmoustache
05-29-2007, 12:25 PM
On the "Generate Access DB" button: that's a possible future feature. Not sure yet if I'll do it, what the interest is, etc. Everyone seems to be just importing the CSVs.
On the number of lines in the game stats: That's one reason I asked about separate files vs one large one. There are roughly 24,500 records per season in that CSV. Once I do the "only generate CSV for recent seasons" feature, that will help.
Not a huge problem as ultimately I would have thought most would put into databases.
cuervo72
05-29-2007, 02:05 PM
Ohhh, player stats! I have me some work to do. Thanks Greg!
lordscarlet
05-29-2007, 03:55 PM
Ohhh, player stats! I have me some work to do. Thanks Greg!
Don't we all. :)
marcmoustache
05-30-2007, 03:16 AM
Greg, having looked at this now you've done it, separate years would be better as we can save on upload time and mbs (my host has a limit) by having separate years and just uploading the historic stuff once and then the new stuff from the current year each time. Of course this could be achieved with the current multiple seasons dump by uploading the big file once, then having a local d/b that identifies the new lines and only uploads them, much like you can do with the transactions dump.
So actually I'm ok, but others may need it to be split.
I've already written code to pull out the new lines, so I'm okay as well, but that may make more sense for others. Actually, what would be really neat is if Interrogator had an option to only output the new/changed lines from the last time it ran. Perhaps by just pointing it to a directory with the previous output.
gstelmack
05-30-2007, 08:32 AM
I've already written code to pull out the new lines, so I'm okay as well, but that may make more sense for others. Actually, what would be really neat is if Interrogator had an option to only output the new/changed lines from the last time it ran. Perhaps by just pointing it to a directory with the previous output.
My plan was to give you the ability specify a season and have Interrogator not spit out any records from prior to that season. This would include team schedules, players that retired and are either not HOF or are HOF prior to that year, player stats, transactions, etc.
The Diff option is interesting, but I'm not sure how long it would take (both to code, and to run). I'll have to think about that, as it would strip everything down to the bare minimum for uploading, but still take a while to read everything in (if I skip years, I can completely eliminate reading the stats files that take a while now).
marcmoustache
05-30-2007, 09:01 AM
My plan was to give you the ability specify a season and have Interrogator not spit out any records from prior to that season. This would include team schedules, players that retired and are either not HOF or are HOF prior to that year, player stats, transactions, etc.
The Diff option is interesting, but I'm not sure how long it would take (both to code, and to run). I'll have to think about that, as it would strip everything down to the bare minimum for uploading, but still take a while to read everything in (if I skip years, I can completely eliminate reading the stats files that take a while now).
Looking at it now the stats are the only stuff that really appears to be large and be unnecessary to repeat each time.
cuervo72
05-31-2007, 09:01 AM
I liked the breaking up of stats year-by-year. A "just current" should work too though.
cuervo72
05-31-2007, 10:15 AM
Of course, I can't get it to actually load the league file on my arcane box right now. It just churns and churns...
marcmoustache
05-31-2007, 10:51 AM
Of course, I can't get it to actually load the league file on my arcane box right now. It just churns and churns...
Can you not do it locally through the sql prompt and then export bit by bit and upload the new bit by bit files to the webserver?
cuervo72
05-31-2007, 11:18 AM
No...I mean interrogator hangs when I try to specify my league file. My guess is it is choking on the game files. It is a very memory-challenged box.
How about a command-line interface for the Interrogator to make automation of exporting and uploading through batch files easier?
gstelmack
06-02-2007, 08:14 AM
How about a command-line interface for the Interrogator to make automation of exporting and uploading through batch files easier?
Not a bad idea. I shall investigate...
gstelmack
06-03-2007, 12:45 PM
I'm getting this out quick without much so no one accuses me of being unfair in the WOOF draft, and I intend to use this some.
Draft Analzyer now has a "Combine Sum" column that is just the sum of all the combine standard deviations. I'll be adding weighted averages later, but I need something like this right now for 2 drafts I'm in.
Ben E Lou
06-03-2007, 12:50 PM
I'm getting this out quick without much so no one accuses me of being unfair in the WOOF draft, and I intend to use this some.
Draft Analzyer now has a "Combine Sum" column that is just the sum of all the combine standard deviations. I'll be adding weighted averages later, but I need something like this right now for 2 drafts I'm in.
Is it based on the standard deviations from the current draft, or a collection of drafts. I ask because if it's the latter, I suspect that some of the data has changed with 6.0e.
gstelmack
06-03-2007, 02:09 PM
Is it based on the standard deviations from the current draft, or a collection of drafts. I ask because if it's the latter, I suspect that some of the data has changed with 6.0e.
The latter. And I was just noticing the same thing, as in WOOF it seems like all the TEs have nice 40 times.
Have to get Tium to run a bunch of drafts for us again ;)
Ben E Lou
06-03-2007, 02:13 PM
Have to get Tium to run a bunch of drafts for us again ;)
I have six 6.0e-generated drafts saved in Extractor in .draft format (including WOOF). If I get those to you, would it help?
gstelmack
06-03-2007, 03:09 PM
I have six 6.0e-generated drafts saved in Extractor in .draft format (including WOOF). If I get those to you, would it help?
In .draft, not the original CSVs? Not sure .draft will help (I'd have to export back out). draftpreview.html from the game-generated HTML is ideal.
cuervo72
06-05-2007, 10:45 AM
Greg - any chance of grabbing drive info at some point? And would that be in there for all years do you think, or just those in 2k7? I'm thinking of trying to piece together box scores (finally) for the non-2k7 seasons.
Also, a bit of info on the player game format. The first unknown - unknown13 or something like that? That looks like the "opppoints" you had from the last version, which was the opposing team id. This is pretty useful for say, grabbing pass yardage against your team for example (sum(passyards) where oppteam = yourteam).
gstelmack
06-05-2007, 11:00 AM
Greg - any chance of grabbing drive info at some point? And would that be in there for all years do you think, or just those in 2k7? I'm thinking of trying to piece together box scores (finally) for the non-2k7 seasons.
All of this is waiting on Celeval for the Solevision format. I have a lot of things I'd like to do with that data. I could be busy for months on just that.
Also, a bit of info on the player game format. The first unknown - unknown13 or something like that? That looks like the "opppoints" you had from the last version, which was the opposing team id. This is pretty useful for say, grabbing pass yardage against your team for example (sum(passyards) where oppteam = yourteam).
Cool, thanks, I'll tweak that column name.
gstelmack
06-05-2007, 09:07 PM
Draft Analyzer's combine data has been adjusted to match new ranges from the 6.0e patch.
Interrogator's Team Schedule table now has a "Year" column tacked onto the end.
Interrogator now has a checkbox to control season imports. Check the box and enter a season below it to have Interrogator only process that season and beyond in your league file. Leave the box unchecked to grab everything.A bit of a rush job with the need to get the updated combine data out ASAP, so it doesn't have all I had hoped to do.
marcmoustache
06-06-2007, 03:36 AM
Draft Analyzer's combine data has been adjusted to match new ranges from the 6.0e patch.
Interrogator's Team Schedule table now has a "Year" column tacked onto the end.
Interrogator now has a checkbox to control season imports. Check the box and enter a season below it to have Interrogator only process that season and beyond in your league file. Leave the box unchecked to grab everything.A bit of a rush job with the need to get the updated combine data out ASAP, so it doesn't have all I had hoped to do.
Nice job on those Greg.
Agreed - very nice job!
One suggestion - default the settings for the "Process from season" checkbox and editbox to what were used last time, just like the output directory is remembered now.
gstelmack
06-06-2007, 07:23 AM
Agreed - very nice job!
One suggestion - default the settings for the "Process from season" checkbox and editbox to what were used last time, just like the output directory is remembered now.
I actually need to work on the options as a whole, including that one.
Right now I'm using .NET's built-in Settings class. Problem is, every time I release a new version, it blows away the old one with a new file that has the defaults in it. That's why you need to reset the output folder every time you get a new version.
I need to get time to create my own Options class that either uses an INI file in the AppData area, or the registry. I just have had too much to do on base-level functionality to do this.
gstelmack
06-06-2007, 01:59 PM
This is what happens when your daughter stays home sick from school and she takes a nice long nap ;)
Draft Analyzer now has a "Show StdDevs" menu item that changes the combine display from raw scores to standard deviation values.
Draft Analyzer now colors combine scores with a standard deviation between 0 and -1 with a light gray background.
Draft Analyzer now has an "Edit Weights" menu item that lets you adjust the combine weights per position used to calculate the "Comb" column. This also lets you edit the relative position importance weights used to calculate adjusted bureau ratings, but that won't do much until I'm importing bureau ratings from the draftpreview.html file...
Interrogator's PlayerGameResults table now identifies the old "Unknown_1" column as "OpposingTeamID". It is still in the same place with the same values, it's just the heading that has been updated.A small note on this: The Draft Weights are stored in:
<My Documents>\StelmackSoft\UtilitySuite
I will be slowly adding to that area. I need to start saving off all the other options in a file there, plus will make that the save location for Extractor runs. That stuff will come later but is high on my list.
Interrogator now has a checkbox to control season imports. Check the box and enter a season below it to have Interrogator only process that season and beyond in your league file. Leave the box unchecked to grab everything.
Does this go backwards in time from the entered season? I put in '1979' to get only the latest HFL season, but got seasons 1970-1978 in the game stats csv. Was this intended?
cuervo72
06-11-2007, 02:06 PM
Question about the transactions output. Specifically, the player index. This is the *first* player id in the Player Historical.csv (index), not the PlayerID right? I ask because how I'm carrying this over in FOFL is a bit tricky.
Basically, I still key off of PlayerID, and I keep ALL the players that have ever been captured in the respective player tables. I do this largely because I tried to back track and get all the pre conversion transactions in there, and that playerid was all I had (I try to keep all players, even those who haven't played, around for draft/transaction/combine reasons).
Now...this index. This is reordered every year? And if so, wouldn't this result in players who never actually played being wiped from the historical file causing a change in the index (thus making this index not reliable as a key)?
gstelmack
06-11-2007, 03:03 PM
Question about the transactions output. Specifically, the player index. This is the *first* player id in the Player Historical.csv (index), not the PlayerID right? I ask because how I'm carrying this over in FOFL is a bit tricky.
I haven't looked closely at the Transactions, and was specifically asked to leave them alone for now, so I don't know. But if I need to convert that to a PlayerID for certain transactions, I can.
gstelmack
06-11-2007, 03:05 PM
Does this go backwards in time from the entered season? I put in '1979' to get only the latest HFL season, but got seasons 1970-1978 in the game stats csv. Was this intended?
It *should* filter out most everything from prior to 1979 (I haven't figured out how to get rid of players who retired before that year just yet). That's what it's doing here, so I'm not sure what's going on on your end. Try clearing out the CSVs and regenerating and see what you get. You did check the box as well as enter the year, correct? If you don't check the box, it ignores what's in the text field.
cuervo72
06-11-2007, 03:20 PM
I haven't looked closely at the Transactions, and was specifically asked to leave them alone for now, so I don't know. But if I need to convert that to a PlayerID for certain transactions, I can.
Well...I do have a perl script that is doing that. :) Basically I put all the playerid's in a hashed array, then parse the transaction file and output a "processed transaction" file. I also reorder things and split some stage information.
That's tricky too though, as like you say, you only want to do that for certain transactions - those involving players (as opposed to coaches, scouts, picks, or even just teams). How the data is stuffed in there is funny that way (for pick trades, the year is in the position field for instance).
marcmoustache
06-12-2007, 12:48 AM
cuervo - the id in the transactions log is the "index" in the player historical table, the playerindex from 2k4 is the "playerid" int he same table. I just link the transactions by the index (i.e. 2k7 playerid) to my old table using the playerid and my player pages using the playerid.
Not making much sense but I don't htink you need to do anything fancy, just store both value and link accordingly in yuor queries, no?
beeznik
06-12-2007, 05:38 AM
Great job. One question though. What does the color white stand for in the draft analyzer. I know there are supposed to be greens(Above average) and blues(below average), but I am seeing whites as well. Are those average?
Thanks
gstelmack
06-12-2007, 08:03 AM
Great job. One question though. What does the color white stand for in the draft analyzer. I know there are supposed to be greens(Above average) and blues(below average), but I am seeing whites as well. Are those average?
Thanks
Light Blue = 1.5 or more standard deviations below average
Dark Blue = 1.0 - 1.5 standard deviations below average
Gray = 0.0 - 1.0 standard deviations below average
White = 0.0 - 1.0 standard deviations above average
Dark Green = 1.0 - 1.5 standard deviations above average
Light Green = 1.5 or more standard deviations above average
And if you ever forget, just check the "Standard Deviations" menu item and you'll see the raw numbers under the colors.
cuervo72
06-12-2007, 09:07 AM
cuervo - the id in the transactions log is the "index" in the player historical table, the playerindex from 2k4 is the "playerid" int he same table. I just link the transactions by the index (i.e. 2k7 playerid) to my old table using the playerid and my player pages using the playerid.
Not making much sense but I don't htink you need to do anything fancy, just store both value and link accordingly in yuor queries, no?
The problem though is for players who retire w/o playing and then mess up the log though, at least it appears to be a problem in my mind (maybe I'm missing something).
Take this guy.
http://www.thefofl.com/players/player.php?player=12170
He was in the draft pool, had a transaction (in the Transactions.csv file anyway) on him, and was released. He didn't play, and then he retired. I have him in the historical table with a player id of 12170 (like his player page) and a "gs index" of 5398. His transactions are keyed off of his player id.
Well, because he didn't play, he no longer shows up in the Player Historical.csv . So he's no longer gs 5398. However, that number was reassigned - to this guy:
http://www.thefofl.com/players/player.php?player=12735
If I were to key off of the gs index, and put the transactions from 2014 and 2015 into the db as is, this second player would have four transactions...one of them from 2014. This would be a bit of a problem.
Even as it is, I swap out the gs index for the "absolute" index based off the link in Player Historical. In the case of Kennedy Mathis though, he'd turn up blank, and that line wouldn't end up being inserted. Actually...no, now that's not even right. The line from 2014 with a player index of 5398 is actually an injury line, and in THAT case it appears to be using the real player index (here (http://www.thefofl.com/players/player.php?player=5398), and I'm not even sure how I got the injury there under the correct player). So in this case, you're not even dealing with the same index.
(this player is better: http://www.thefofl.com/players/player.php?player=11624 . gs id 4852, which has been reassigned to this guy: http://www.thefofl.com/players/player.php?player=12181 . Actually, the id of 4852 isn't found in Transactions.csv at all, so it looks like the transactions for the first guy were completely wiped, and the second guy doesn't have any yet. It could be argued that you may not want old records for guys who never played, but if you want to be complete, you *do* want them. And even if you don't, you'd then want to be completely rewriting the transactions table each time you import - to clear those old records you put in last season out - and you probably don't want to do that either)
gstelmack
06-12-2007, 10:18 AM
I have a theory that if a guy disappears from the historical table, his transactions disappear from the historical transactions. Have not looked close enough to confirm, but you could check and see if these transactions you are looking at still show when you re-run Interrogator on everything.
cuervo72
06-12-2007, 12:40 PM
I have a theory that if a guy disappears from the historical table, his transactions disappear from the historical transactions. Have not looked close enough to confirm, but you could check and see if these transactions you are looking at still show when you re-run Interrogator on everything.
I think you're right, they do disappear. The problem is that if say you are in 2015 and the player has now disappeared, his transactions would still appear in the database if you entered them in 2014. At least, that's a problem for me, having to keep transactions from 2k4 around. Whenever I add tx, I only add the new ones since the last update. I suppose you could just do a rewrite each time on the transactions if you use the transaction index as a key (actually, if you use that transaction id you pretty much have to overwrite the data). I myself had my key as an autofill from starting in 2k4.
I actually *don't* like having players and transactions disappear, though I understand why Jim did that. It brought up problems for me in the past though, specifically for spitting out the draft. I would use the draft info from the Player Historical (draft team, year, round, pick) to construct the draft recap pages. But I noticed that some guys, especially in the lower rounds, were missing from the list...because they no longer were in the historical database (I'd constructed the db from a current file at the time, say 2008, and some guys from 2004-2007 had been purged. I actually went back and ran interrogator off of each end of year file to attempt to capture all of these guys).
gstelmack
06-12-2007, 01:28 PM
Back in 2k4 I did the conversion from index -> playerID for certain transactions. As I said above, I can look into doing that again.
cuervo72
06-12-2007, 01:40 PM
I'd only bother with that if it's a problem for others. For me, I'll probably parse the file anyway (to retrofit to 2k4) and can make that conversion. I did want to point it out generally though.
marcmoustache
06-12-2007, 04:06 PM
I haven't actually done it the way I described above, I've got a 2k4 trans table and a 2k7 trans table. So I don't worry about making it all work. The 2k4 table links by the playerid (i.e. 2k4 index) and the 2k7 table links index in trans to index in player historical. I think that's the difference, you're trying to get the 2k7 transactions into your 2k4 table whereas I've kept them separate and can use either key.
Howevr, if you are saying that in the future if a player disappears from the d/b then his index value in player historical will be re-assigned to another player, then I do have a problem, but surely this makes no sense unless Jim has written it to maintain the playerid value and have the index value reassigned periodically depending on how many players there are in the player table and just incremented.
Actually scratch that, if it was this way then the game's player pages would get out of whack.
Is there a way to have the playerid value in the trans table instead of the index value (or both)?
vBulletin v3.6.0, Copyright ©2000-2013, Jelsoft Enterprises Ltd.