dwevans' CFM Trade Calculator

This is a discussion on dwevans' CFM Trade Calculator within the Madden NFL Football forums.

Go Back   Operation Sports Forums > Football > Madden NFL Football
eFootball 2022 Review
FIFA 22 Review
Hot Wheels: Unleashed Review
Poll: What's more important to you, when the time comes to purchase a game? (Click to vote)
Thread Tools
Old 01-04-2018, 07:57 AM   #1
OVR: 4
Join Date: Apr 2006
dwevans' CFM Trade Calculator

I can offer a couple of tools that you might find useful in all your leagues.

The first is a trade calculator that I have created over the last year or so. Its pretty good at maintaining realism amongst trades and balancing this with the limited life of a CFM and other factors. Its fairly self explanatory but any questions ask me here and I can help clarify the logic and add to the FAQs.

It is already in use in several European CFMs but feel like many others would benefit.

*** Version 2.5 Updated 7.2.2018 ***​

- 'Seasons Passed' changed to 'Drafts Left' so that it can work with all leagues regardless of start date or speed of progression with minimal adjustment.

Link Here

Attachment 145781

*** Version 2.4 Updated 29.12.2017 ***

- Added a Final Season CFM Button to base valuation mostly on OVR and much less on age/contract length/DEV in final CFM seasons.
- Added a Week 8 logic for the trade deadline (The Fraser Rule) to allow slightly more wiggle room on trades in Week 8 as teams reevaluate their priorities/needs halfway through the season.
- Raised the floor of valuation for Elite QBs - they maintain higher value into their later years.
- Removed an error where the floor of low rated young players was too slightly too high if they had a high contract length.
- Added a logic where top 5 picks in the draft need to have their value matched or overpaid for. A similar logic was also added for superstar young players.

*** Version 2.2 Updated 7.11.2017 ***

- Rookie button added - Increases the value for rookies slightly given they are eligible for specific rewards/longer contracts.
- "How to" guide added
- FAQs added (more to come)

Attached Files
File Type: zip Trade Value Sheet Final 2.5 Locked.xlsx.zip (432.2 KB, 48 views)

Last edited by dwevans; 02-07-2018 at 11:54 AM.
dwevans is offline  
Reply With Quote
Advertisements - Register to remove
Old 01-04-2018, 11:48 AM   #2
Let's Go Brandon!
Milticket's Arena
OVR: 5
Join Date: Jul 2012
Posts: 4,050
Re: dwevans' CFM Trade Calculator

Wow, umm this is great. Along with the position one. People in this community really do amazing things! Awesome job!
Madden 22 - Modded (PC)
Madden 22 Next Gen (XSX)
Ori & The Blind Forest (XSX)
Metro Exodus (PS5)

"Players make the NFL money, not the coaches. It's not a 2-way street, follow the bread crumbs."
Milticket is offline  
Reply With Quote
Old 01-04-2018, 04:39 PM   #3
OVR: 4
Join Date: Apr 2006
Re: dwevans' CFM Trade Calculator

Thanks man. Any feedback, questions or suggestions are welcome!
dwevans is offline  
Reply With Quote
Old 02-07-2018, 10:47 AM   #4
OVR: 4
Join Date: Apr 2006
Re: dwevans' CFM Trade Calculator

Calculator Updated
dwevans is offline  
Reply With Quote

« Previous Thread | Next Thread »

« Operation Sports Forums > Football > Madden NFL Football »

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT -4. The time now is 09:25 AM.

Top -