|
leeman67 -> RE: USFL league file ready (5/29/2008 3:19:34 AM)
|
I'll do that Rhino. Thanks. Regarding how to convert, I first export the original Madden roster file to a .csv file using Nza's editor. I also export a base MaxFB league file (with the team names already embedded) to a .csv file using JDHalfrack's DB editor. Next step, I re-save the Madden .csv file to an Excel file and begin eliminating columns I don't need. I basically narrow it down just to those same columns that are also in the MaxFB database file. Speed = speed, agility = agility, and so forth. I will also need to add some blank columns for categories that do not exist in the Madden file, such as Pocket Passer, Coverage, Avoid block, etc. I take the average of RunBlock and PassBlock to create one column for Block. I use the skill ranges in the main MaxFB database as a guide and use various formulas to bring the ratings more in line with MaxFB. There is no exact science here, as I think we're all still figuring out the various skill ratings in MaxFB and how they work with the playbooks, etc. One example is the Coverage rating. I basically get an average of Speed and Agility and then combine that with Intelligence to get another average. The rest use similar logic. Believe me, I'm WAY open to suggestions on how best to do this. Once this is all done, and I'm happy with my ratings and the data in each column, I then copy and paste these into the MaxFB league database .csv file. I delete any extra lines, or if there are too many, fill blanks with zeros in most of the cells. Then I re-save THIS new file to an Excel file, and then re-save BACK to a .csv file (this step is VERY important). Lastly, I use JD's DB editor again to import this new .csv file back into the original league database, and then save it. I can then load it into MaxFb. The depth charts all need re-ordered and actives/inactives adjusted. Do not try to play any games if you do not have enough active players (45) because the CPU will automatically load you up with about 40+ free agents before the game begins. And believe, that is no fun to fix. Hope this helps. :) Lee
|
|
|
|