Madden Trade Calculator - v4.0

[Old Man Nathy]

Hi all,

I've made some updates to the Trade Calculator Tool some of you may already be using in your leagues to make it work better for Madden 19.

DOWNLOAD FROM HERE

New for v4.0

• Updated dev traits for Madden 19.
• Made future picks more valuable (we can value them more highly than real GMs as we're not about to get sacked, and a year can pass in a few days as to 365!)
• Removed the depth chart position criteria for players, and replaced it with Madden position ranking (so that players who are amongst the best at their position are highly valued regardless of OVR, and positions with loads of high OVR players aren't overvalued)
• Fixed bug that caused low value players to have a negative player value.
• Lots of other minor tweaks to the lookup values based on another 6 months' experience with version 3.1 since it was release.

Who is it for?

• Online CFM Commissioners and Trade Committees who want an objective way to ensure trades are fair.
• Players who want to make sure they aren't getting ripped off as part of a deal.
• Offline CFM players who want to avoid cheesing the CPU to keep things challenging.
• People who need to make quick decisions in the draft to decide if they want to trade down or up.

How we use the calculator in my league:
In my 32 man Online CFM, the Trade Committee uses the calculator as a baseline for deals. This helps keep things consistent across different deals, and ensure teams make relatively even trades, preventing rosters from being ransacked in case people leave the league. We will deviate from the calculator in exceptional circumstances, such as a generational prospect being available in the draft, an elite player who the team no longer wants, etc. etc. But the calculator is a really useful guideline for all trade activity.

How Does It Work?
You input data for your side of the trade and the other team's side, and the tool calculates the value of each draft pick and player and compares each side of the deal. It then tells you whether the trade is biased either way, or if it is a fair trade. It also works for future draft choices as well as the current year's.

Where Does The Draft Pick Value Data Come From?
The Jimmy Johnson Draft Pick Value Matrix is a pretty famous way of calculating the value of draft choices, but more recent research suggests it overvalues early picks and undervalues middle and late round choices. This is particularly true on Madden where draft choices are a lot more predictable than in real life. For this reason, I've used the values presented here for offline leagues, and a set of values somewhere in between this set and the Jimmy Johnson set for online leagues. The reason being that in online leagues with more than about 20 people, all the good players are gone by about the middle of round 3 in the draft, making middle and late round picks less valuable.

Where Does The Player Value Data Come From?
So this is where things start getting a bit more subjective. I've based the value of a player around several key factors, namely their Overall Rating; Age; Position; Years Remaining on their contract; cap space they are currently taking up for their team; rank at their position according to Madden; and Dev Trait. New for version 3 is Speed, though this is only relevant for Play leagues, not sim-only. I could have included lots more factors here, but these are - to me at least - the things that should impact a player's worth in Madden. I'll talk through how the approximate values for players are calculated below:

OVR: Gives the core value of a player before any other modifiers are applied. Works on the obvious assumption that the higher a player's OVR, the more they're worth in a trade. The rough bandings (in terms of how these raw OVR value attributes align to draft picks) are 96+ players are worth more than a 1st rounder; 90-95 OVR players are worth approximately a 1st rounder; 86-89 players are worth approximately a 2nd rounder; 82-85 players a 3rd rounder; and so on and so forth.

Age: Age is an important consideration in a player's value in Madden due to the hard cut-off of 28 when players start to regress. Therefore young players who are either still developing quickly or at their peak before the precipitous decline begins are worth considerably more.

Position: It goes without saying that some positions are more valuable in both the real life NFL and Madden. A 85 rated QB is worth a hell of a lot more to a Franchise than a 85 rated Fullback. For this reason, the approximate value of a player is modified based on his position.

Years Remaining on Contract: The main purpose of including this is the massive drop-off in trade value experienced in real-life by players in the final year of their contract.

Cap Hit: This is one you might disagree with, as I've considered a large cap hit to be a knock against a player's trade value. This is so that players on their rookie deals get valued slightly more highly. I considered including guaranteed money on the current contract year as one of the criteria, as the player's previous team will have to eat this as dead cap space (which will affect how they think about the value received for a trade), but decided not to. Let me know if you think this should be added though.

Player Rank at Position: Madden provides info about a player's rank at their position if you press R1/RB on their player card screen. Top players within their position get a boost, while guys who are outside the top 32 get penalised.

Development Trait: Superstar/Star dev players accumulate XP more quickly and progress slower than their Normal/Quick dev counterparts.

Speed (play leagues only: New for version 3, Speed will also affect the value of a player in play leagues (where it is the most important stat of all).

All in all, you'll find that the tool values elite players higher than the default Madden trade logic, but will value mediocre players far less than Madden. If you follow the tool's assessment, you will get much more realistic trade value for average players (as opposed to ludicrous offers like 2nd round picks for 78 OVR, 29 year old DTs, for example).

You can of course tweak the values in the lookup sheet of the tool itself if there is anything you strongly disagree with.

Compatibility:
You'll need a spreadsheet application (Excel, Sheets, whatever). It will work on Excel version 2007 or newer, but uses some functions that make it incompatible with Excel 2003.

Previous Versions:
https://forums.operationsports.com/f...d.php?t=914756

Hope this tool is of use to some of you!

[tdawg3782]

Amazing as always OMN.

[Old Man Nathy]

Thanks man

[WeWereGiants]

Been looking for this, thanks OP. In my 49ers franchise I traded Jimmie Ward and Arik Armstead to the Raiders for their 1st round pick (5th overall) and it made me think "Now where the hell was that draft calculator..."

[Old Man Nathy]

Errr yeah I doubt the calc would like that lol

[hardcor2]

Does anyone else have issues with the trade value for draft picks? It says #NAME? I'm using Open Office if that makes a difference.

[xraven2288x]

I have recently downloaded the madden trade tool and it calculates the players but picks something is off because it wont calculate value. Any help is appreciated. [email protected]

[xraven2288x]

im in excel in office 365 and it worked I was using apache but this works for me now