Madden 16 Excel Workbook Roster/Depth Chart Tool

[tdawg3782]

So I've been working on an Excel tool to use with Madden 16. Basically I wanted to have a workbook where you could input your players (by position), their main attributes, let you give a certain weight to each attribute, and have an Ovr produced based off of that. Essentially what Madden does with player schemes but tailored specifically to what you want out of each position. What I think I've come up with is pretty solid.

Now this is not for the average guy who just wants to play. This is for the guy who really gets invested in his CFM and wants to play for seasons. It does take a decent amount of time to input all this info at the start but future season (unless you have a complete overhaul) shouldn't be to bad.

So here's an example of how it looks at the bottom. There is a quick how to on the QB tab. In the top line you have a "Grade Weight". This is where you would put weight on each attribute equaling up to 100%. This is what really makes it yours. You can be very specific and do it however you want. Next add your players in with all necessary attributes. My formulas will calculate your players based on your weights and the give you an Ovr off of a scale I created. The Ovr is from 40-99. Now this isn't your Madden Ovr. If a player happens to be above 90 then they are freaking superstars and if a players is under 58 the are pretty damn bad. You will most likely never have a player reach 99 or 40. These are extremes to say the least. It would be like if the Madden Ovr scale went from 0-115.

Anyways that's it. If there are any questions let me know. I plan on doing something with drafting as well I'm just not sure how I want to organize it yet. Oh and all sheets are protected so none of the formulas get messed up on accident. It only allows you to enter weights, players, attributes, and sorting. However if you would like to unprotect the sheets there is no password required. Just click unprotect.

Side note. The first three tabs in this workbook are for something else I was doing and have nothing to do with this so you can just ignore them. When I started this project I didn't realize I would make it as big as I did so I didn't start a new workbook and didn't feel like moving all tabs to a new one.

[shadowkaga]

For the Dev tab, do we put 0/1/2/3 or Slow/Normal/Fast/Star or does it matter?

[tdawg3782]

Quote: Originally Posted by shadowkaga

For the Dev tab, do we put 0/1/2/3 or Slow/Normal/Fast/Star or does it matter?

It doesn't matter. It's just for reference. I've put it in the formula before but it was more a guess then anything else so I figure just seeing what your guys are will let you know if you want to promote them on the depth chart even if their Ovr is lower.

Sent from my Galaxy s4 so deal with the short hand
twitch broadcast name: tdawg3782

[adembroski]

In case anyone cares, here's my salary cap tracker I made way, way back for Head Coach...

http://www.mediafire.com/download/3r...ility+v1.2.xls

[preaceps]

Is there a way to get a more generic version. IE I like having jump and catch in for the Safeties, but don't really care about power and finesse moves as I rarely blitz my safeties. I can zero out a column if I don't need it but everything is locked. So if I want to tweak FS tabs I want all that are there but add some more. Can you do up one generic tab that has all the stats so we can copy paste and tweak the % as we need for each position?

Also you have hit power as HIT, and in game its POW. Obviously its not a big deal but its locked and some peoples OCD goes nuts with that

[tdawg3782]

Quote: Originally Posted by preaceps

Is there a way to get a more generic version. IE I like having jump and catch in for the Safeties, but don't really care about power and finesse moves as I rarely blitz my safeties. I can zero out a column if I don't need it but everything is locked. So if I want to tweak FS tabs I want all that are there but add some more. Can you do up one generic tab that has all the stats so we can copy paste and tweak the % as we need for each position? Also you have hit power as HIT, and in game its POW. Obviously its not a big deal but its locked and some peoples OCD goes nuts with that

Just unprotect the sheet. There is no password needed. You can then change the column name to whatever you like.

[garyraymond23]

Absolutely fantastic idea, I just can't open the file for some reason lol

[tdawg3782]

Quote: Originally Posted by garyraymond23

Absolutely fantastic idea, I just can't open the file for some reason lol

Did you unzip it first?

Sent from my Galaxy s4 so deal with the short hand
twitch broadcast name: tdawg3782