Hi everyone, I want to share my real overall calculator for Madden 21, the tool does the following:
Requirements
Knime link:
My workflow:
https://drive.google.com/file/d/1C9D...5KPBtDmHBdH36/view?usp=sharing
Madden Save Editor (all credit to bep713):
Instructions:
I made a video with all the steps below:
1. Install Knime software (Link in description)
2. Enter your email and accept privacy policies
3. Enter the amount of RAM you want Knime to use (leave default)
4. Choose the path for Knime files (Any you want)
5. Go back to your browser and download my file (Link in description)
6. Import the file you just downloaded, click on "File" then "Import Knime Workflow", select the file and then "Finish"
7. Open the "Overall 21" workflow on the left side by double click on it
8. Open "Madden Save Editor", click on "Open a franchise file", search for your franchise file (Documents/Madden NFL 21/Saves)
9. Click on "Open the table editor", click on the bar with "OverallPercentage" text, a drop-down menu will appear and a "Search" bar, search for "Player", select table "4227 Player"
10. On the top toolbar, select "File" and then choose "Export", place the file on the desktop and rename it "Roster_Export" (don´t change the name or location as Knime will search in that place with that name)
11. Close the exported file and “Madden Save Editor”
12. Return to Knime, validate that “Roster_Export” node by double click on it, it must show that is using the “Roster_Export.xls” file you exported
13. Double click on the “Team Data” node
14. Change the “User Team Selection” value by double click on the node, change the numeric value in the text box, you must choose the number value of the team (Cardinals = 6, “Team Index” table has all teams ids)
15. Change your offensive and defensive schemes by double click on the “User Scheme Selection” node, click on each filter and change the value from the dropbox as shown
16. Close the “Team Data” page and go to the “Overall 21” page, double click on “Real Overall Calculation” node
17. Scroll to the left and double click on the “Player Stats” node, there is where attribute thresholds for each archetype are defined, you can change this table to your liking, the current values are the Madden base roster averages
18. It will calculate “1” or “0” if the speed, strength, acceleration, agility, change of direction, injury, and stamina thresholds are met, depending on the archetype threshold you choose
19. Close the “Real Overall Calculation” node and return to the “Overall 21” page, run the workflow by clicking the “Execute all executable nodes” button on the toolbar (green with two triangles)
20. If everything is right, all nodes will turn their indicators to green
21. Now we will install an extension to run the Knime reports, go to “File” and “Install Knime Extensions”, then search for “Reports” and choose “Knime Report Designer”, wait for it to install and restart Knime as asked
22. Now you can run the report by click on the “Opens the report…” button on the top toolbar
23. Then run the report by clicking on the “View Report” on the top toolbar
24. The reports will be launched in your browser, it shows (name in green) your current team players and the ones available (name in yellow) sorted by average overall rating, which´s calculated by the average of a player archetype
25. You can navigate through positions with the buttons on the right upper corner
26. Phy R is the sum of SPD, STR, ACC, AGI, COD, and End R is the sum of INJ and STA
27. "VAR" column is the variance between player archetypes, the bigger number, the bigger difference between them
28. This page shows the highest overall rating player, number of players, dev trait, and mean rating of each position in your team (not including practice squad)
29. Below shows the mean rating per group positions, in order to plan your team weekly training
30. The last report is Draft, which shows age, archetype, and their Phy R and End R, sorting by the most athlete players (not necessarily highest overall).
31. You can export it to excel as shown
32. To re-run, let´s say for example that I signed Suggs from the free agents, as I see he´s available
33. Go to the game and sign him, save
34. You must export again your franchise player table
35. Close the “Madden Save Editor” and the Excel file
36. Go back to Knime and click on the “Roster _Export” node, select “Reset”, run again by clicking the “Execute al executable node” in the top toolbar
37. Run the reports by clicking on the “Opens reports…” button on the top toolbar, then by clicking the “View Report” button on the top toolbar
38. Now you can see Suggs is in green, once it´s on your team
- Player´s real overall rating is calculated using the mean between the position archetypes (Average Rating column)
- Calculated the player´s variance between its archetypes, the lower the amount, less difference between its archetypes (VAR column)
- Calculates a threshold indicator (SPD, STR, AGI, ACC, COD, INJ, STA, THP) for attributes like speed, for example, if the threshold is 90 for WR´s, a player with "93" speed will have an SPD value of "1", a "88" WR will have SPD value of "0"
- An indicator to see which players are available as free agents or trade (AVA column)
- A table with the maximum overall rating, age, mean overall rating, dev trait, and number of players per position in your team, in order to see which positions need an upgrade
- A table with the mean overall rating of each training position, in order to plan weekly training accordingly to your weakest group
Requirements
Knime link:
My workflow:
https://drive.google.com/file/d/1C9D...5KPBtDmHBdH36/view?usp=sharing
Madden Save Editor (all credit to bep713):
Instructions:
I made a video with all the steps below:
1. Install Knime software (Link in description)
2. Enter your email and accept privacy policies
3. Enter the amount of RAM you want Knime to use (leave default)
4. Choose the path for Knime files (Any you want)
5. Go back to your browser and download my file (Link in description)
6. Import the file you just downloaded, click on "File" then "Import Knime Workflow", select the file and then "Finish"
7. Open the "Overall 21" workflow on the left side by double click on it
8. Open "Madden Save Editor", click on "Open a franchise file", search for your franchise file (Documents/Madden NFL 21/Saves)
9. Click on "Open the table editor", click on the bar with "OverallPercentage" text, a drop-down menu will appear and a "Search" bar, search for "Player", select table "4227 Player"
10. On the top toolbar, select "File" and then choose "Export", place the file on the desktop and rename it "Roster_Export" (don´t change the name or location as Knime will search in that place with that name)
11. Close the exported file and “Madden Save Editor”
12. Return to Knime, validate that “Roster_Export” node by double click on it, it must show that is using the “Roster_Export.xls” file you exported
13. Double click on the “Team Data” node
14. Change the “User Team Selection” value by double click on the node, change the numeric value in the text box, you must choose the number value of the team (Cardinals = 6, “Team Index” table has all teams ids)
15. Change your offensive and defensive schemes by double click on the “User Scheme Selection” node, click on each filter and change the value from the dropbox as shown
16. Close the “Team Data” page and go to the “Overall 21” page, double click on “Real Overall Calculation” node
17. Scroll to the left and double click on the “Player Stats” node, there is where attribute thresholds for each archetype are defined, you can change this table to your liking, the current values are the Madden base roster averages
18. It will calculate “1” or “0” if the speed, strength, acceleration, agility, change of direction, injury, and stamina thresholds are met, depending on the archetype threshold you choose
19. Close the “Real Overall Calculation” node and return to the “Overall 21” page, run the workflow by clicking the “Execute all executable nodes” button on the toolbar (green with two triangles)
20. If everything is right, all nodes will turn their indicators to green
21. Now we will install an extension to run the Knime reports, go to “File” and “Install Knime Extensions”, then search for “Reports” and choose “Knime Report Designer”, wait for it to install and restart Knime as asked
22. Now you can run the report by click on the “Opens the report…” button on the top toolbar
23. Then run the report by clicking on the “View Report” on the top toolbar
24. The reports will be launched in your browser, it shows (name in green) your current team players and the ones available (name in yellow) sorted by average overall rating, which´s calculated by the average of a player archetype
25. You can navigate through positions with the buttons on the right upper corner
26. Phy R is the sum of SPD, STR, ACC, AGI, COD, and End R is the sum of INJ and STA
27. "VAR" column is the variance between player archetypes, the bigger number, the bigger difference between them
28. This page shows the highest overall rating player, number of players, dev trait, and mean rating of each position in your team (not including practice squad)
29. Below shows the mean rating per group positions, in order to plan your team weekly training
30. The last report is Draft, which shows age, archetype, and their Phy R and End R, sorting by the most athlete players (not necessarily highest overall).
31. You can export it to excel as shown
32. To re-run, let´s say for example that I signed Suggs from the free agents, as I see he´s available
33. Go to the game and sign him, save
34. You must export again your franchise player table
35. Close the “Madden Save Editor” and the Excel file
36. Go back to Knime and click on the “Roster _Export” node, select “Reset”, run again by clicking the “Execute al executable node” in the top toolbar
37. Run the reports by clicking on the “Opens reports…” button on the top toolbar, then by clicking the “View Report” button on the top toolbar
38. Now you can see Suggs is in green, once it´s on your team