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.
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.
Comment