Interim Database

[Clay Dreslough]

I'm in the process of chugging stats to create an updated database. The attached file should accomplish the following things:

1) Incorporate your new roster lists (thanks again).
2) Display seasonal stats through 2001.
3) Fix the bug with players being shown on the wrong team in their scouting reports.

To install it, unzip and copy over your existing Universe.dat file.

I am already aware of several major problems, including:

1) No Games Played data. This also means some players (like Troy Brown) are under-rated (because I have to base ratings on yards per YEAR played, not yards per GAME).

2) No Offensive Linemen ratings.

3) No Predicted stats for Rookies.

4) Some other anomalies, like seriously reduced Field Goals.

In any case, let me know about general issues you find with this database (or more detail regarding the above issues), and I'll keep posting updates to this and the new EXE.

Thanks!

Clay

[oasage]

noticed that rod woodson is listed with the cowboys. he in fact is with the raiders this year. DARREN woodson is on the cowboys, and he is listed correctly.

[bblaney]

Ummh, well every team seems to have a payroll in the billions of dollars.

That might be a bit of a problem, but it looks good otherwise.

And everyone is a rookie also.

[MessiahRp]

I noticed the rookie thing too. Everyone is a rook in the .dat fix.

I take Cincinnati quite often. I was surprised to see Matt Schoebel as the starting TE on the new lists (I thought Sean Brewer was winning the job this year)... so I clicked on him.

Boy look at the cap impact this kid makes. For a $209,000 salary, his bonus must be f'n crazy.

I think the salary numbers need a bit of fixing...

[Clay Dreslough]

Attached a new database with revised salary numbers (GUESSED by the AI based on age and talent).

As you'll see from the Import Stats thread, the code will be able to import contract data, assuming we can track down the following info for every player:

- Contract length
- Average salary
- Signing bonus
- Years remaining in contract

I'm also looking for feedback regarding player projections. This database creates player projections based on career averages, but in many cases this creates inaccurate numbers. We also need to flesh out the ratings for Offensive Linemen.

Clay

[oasage]

http://www.theredzone.org/2001salaries/index.asp

i found this place and it lists 2001 salaries of every player. hope that helps.

[ryansiegrist]

A few things...first off, are we going to have a database work on the players like we did in baseball? Becasue i really think that would help. Just looking at the Broncos:
Terrell Davis is no longer on the team (retired)
Clinton Portis is going to be a huge part of the offense (But is nothing in FBM)
Same with Lelie
Ed Mccaffrey is said to be a horrible receiver by FBM. The scouts ask why he is still on the team.
Same with Rod Smith.

Maybe this will be corrected with career stats input, but i really think these teams need to be done by a person rather than just based on career stats.

Also, is there a Peak age and stuff like in Baseball Mogul? I think that would be a key addition! It is one of the best randomizing tools in baseball mogul. It also allows some rookies to develop real well and some not to.

[MessiahRp]

I hardly think any scouts are wondering why Ed McCaffrey or Rod Smith are with the Broncos, and better yet I think most if not all of the NFL clubs would love to have them on their teams. That's a ridiculous statement.

Rp

[MH4383]

Jeremy Shockey (rookie for the NYG) is mistakenly placed on the Jets. Could this be a mixup between the team code for giants and jets? Also his scouting report is woeful -- he is the next Tony Gonzalez and his ratings are awful.

[MH4383]

Originally posted by MH4383
Jeremy Shockey (rookie for the NYG) is mistakenly placed on the Jets. Could this be a mixup between the team code for giants and jets? Also his scouting report is woeful -- he is the next Tony Gonzalez and his ratings are awful.

In fact, all NYJ rookies have been swapped with all NYG rookies. I hope that was not my mistake ... I put NYG before NYJ (alphabetically). Surprisingly, the same thing doesn't happen with SEA and SF. This is despite the fact that in the team codes given by Clay, they were inexplicably swapped, as opposed to being in straight alphabetical order.

[AceRothstein]

[QUOTE]Originally posted by ryansiegrist
Just looking at the Broncos:
Terrell Davis is no longer on the team (retired)
Clinton Portis is going to be a huge part of the offense (But is nothing in FBM)
Same with Lelie

Davis has not officialy retired yet, he's just on the IR. http://espn.go.com/nfl/news/2002/0820/1420727.html

Portis **may be** a huge part of the offense. Olandis Gary still has the starting job although the rotation and Shanahan's systems will probably favor Portis once he learns them completely.

Lelie is not going to be a huge part of that offense (unless either Smith/McCaffrey/Sharpe get hurt). Shannhan runs mainly 2 back formations and Lelie isn't going to push Sharpe out of too many plays. He could be a nice 3rd down and long passing situation addition but won't be a huge part of that system this year.

[MH4383]

The only team codes (and thus rookies) 'swapped' were for NYJ/NYG -- I checked the rest of the teams rookies on the debug-version of fbm2003.
Hope that helps.

[ryansiegrist]

What i SHOULD have said about Lelie is that he is way underrated in FBM and on many teams would be getting a lot of playing time. Yes, there are Rod Smith and Mccaffrey ahead of him, but he should still be rated as one of the top rookies.

[Clay Dreslough]

Originally posted by MH4383


In fact, all NYJ rookies have been swapped with all NYG rookies. I hope that was not my mistake ... I put NYG before NYJ (alphabetically). Surprisingly, the same thing doesn't happen with SEA and SF. This is despite the fact that in the team codes given by Clay, they were inexplicably swapped, as opposed to being in straight alphabetical order.

I'll take a chunk of the blame. Should have put the teams alphabetically. I've fixed this in the stats, and should have a new DB with correct Games Played up tomorrow which will chip away at some of these ratings issues.

I've also added an option to use team abbreviations (e.g. NYG) instead of numbers for the player and stat files, to avoid further confusion along this line.

Clay

[MH4383]

Thanks, Clay .. it was partially my fault. It is easier to spot mistakes while preparing the excel file if one can easily see the team abbreviation anyway....
---
What about ratings for rookies? I suppose that will be the most hands-on? For general ratings, I suppose it would probably best to look at career averages, then three-year and finally last year averages.