Your Own Custom Roster

[jlech1805]

UPDATED 01/25/2014

I have good news for PS3 owners.

I can create a custom roster for you, but have also included all the tools for you to do so yourself.

For XBOX owners we'd need some help as i don't have an xbox, but we can still use this guide to create the base file. Maybe Cage would be will to help as its a simple load into the database once completed.


You can edit coach ratings, playbook selection, play call type, coach position philosophy, all player ratings and potential.

You can import players from the past (1985-2013) over 20K database of former players.

Of course you can move players or coaches to different teams.

I've already have done the hard work for you and set it up in a relatively easy to read/edit spreadsheet.

The green / purple tabs are where you can make edits.

All columns that are black with white text should not be edited. They are either a formula or a cell that cant be changed for the upload to work.

Feel free to ask any questions about the spreadsheet if you have any issues.

Just fill out the spreadsheet and send to me or post in the thread and I'll do my best to create it for you.

Links:

Video Step by Step:

https://www.youtube.com/watch?v=xivNHB6RNFY
https://www.youtube.com/watch?v=TCTieDdfSTE
https://www.youtube.com/watch?v=m7yPuGQmAb4
https://www.youtube.com/watch?v=4E3SN2f_nhk

Word Step by Step:
https://www.dropbox.com/s/lnrko67cwe...0by%20Step.doc


XML CONFIG:
https://www.dropbox.com/s/lhyf0184vt...sthcconfig.xml

Excel Files:
PlayerDB CSV (all historic rosters) - Copy and paste into Play Database Tab cell A5
https://www.dropbox.com/s/h36qhokx16...layer%20db.csv


Roster Guide (without Player DB small / easier to d/l if not using historic rosters)
https://www.dropbox.com/s/e9ww89ew15...r%20Guide.xlsm

Roster Guide (with player DB included)
https://www.dropbox.com/s/00zyrsa6pp...r%20Guide.xlsm

[lanceb]

I was curious if you could add all of the HOF players that you have unlocked or can unlocked, and put them all into Free agency, this way it could be a frenzy just to sign who you want.

[jlech1805]

Yeah this is pretty easy.

Column D in the players tab set all players you want to be a FA as 1009.

Then set their salaries to 0. Columns: GG-GM, GP-GV.

*Note any player that has the team id as 1008 i cant use so don't change them.

Make any other edits you wish, save, zip, and post.

[lanceb]

So u can't add anyone with a code if 1008 into the game

[jlech1805]

Basically yes, but there is an easy work around.

If you filter on column D for 1008, the first 13 Player IDs are fine to use. You can switch these players to any team and it wont cause an error. You'll see Butkus, but he is from an older version of this roster where I "made" him, what i really did was replace a player.

Only the Player Id for these HOFs cause an error.

So you can use their ratings in another players slot.

Say you wanted to add Gayle Sayers.

Find an RB to replace (Jeff Demps ID 14167) use their ID and Sayer's ratings.

Let me know if that makes sense i feel like when i explain it it sounds more complicated that in really is.

The same rule applies for HOF Coaches with the difference being the Team ID is 1023 and 1007.

[lanceb]

What do you do with this spreadsheet so you are able to uploaded to the game?

[jlech1805]

There are 2 programs you need to be able to edit the rosters. (Bruteforce, EA Editor)

These can be found when looking in the madden roster forums.

The editor can import/export using csv files.

These CSV files don't translate the four letter table codes into a field name: example in my spreadsheet you'll see these in row 4 in the player tab.

PFNA = Play First Name

Additionally, the export files aren't sorted in a logical sense. Awareness is in the 135th column where awareness potential is in the 215th.

So basically my spreadsheet translates and re-orders the export into a more logical flow.

[lanceb]

Aight, so when i am done editing your spreadsheet. How would i go about trying to upload this into Head Coach 09. Can you give me a step, by step way of trying to do this myself. I am trying to learn how to do this, so in the future i can help with things like this.