It's an Excel based workbook that eliminates XP progression and substitutes a potential based progression system.
Why would I want that?
Because progression by XP is a horrible system.
But wait, aren't you the XP Slider guy?
I am but just because I spend a stupid amount of time on getting XP sliders correct doesn't mean I like the system. I do that because we never had a choice before so I did the best I could to give us a good experience with what we had.
Why this tool then?
I've wanted for years to create my own progression system. With Madden coming to PC last year I was hopeful someone would eventually be able to crack the CFM code. Well thanks to bep713 we now have that ability.
-Complete overhaul of Madden 20 progression system. XP is gone and replaced with a controlled random potential system.
-Players will be eligible to progress from their rookie year until they finish their 4th year. After that they have hit their max potential.
-8 progression steps (2 per year at week 8 and week 16).
-Each progression step is a random percentage of potential earned. For example, if player A is 70 Ovr and his potential is 85 Ovr that is 15 points of progression. He will earn those 15 points during the 8 progression steps, but he gets the points at random intervals. So, it could be 2/2/2/2/2/2/2/1 or it could be 8/0/1/1/0/0/5/0. It’s always randomly distributed. This is how we create those out of no where players who one year did nothing and the next put up 1500 yds rushing.
-Dev Trait is a big factor. Players with a higher trait have a much better chance of being a good player with less downside. It scales down the lower it goes. But don’t sleep on normal Dev guys because they can become stars as well.
-Dev trait regression. If a X Factor player drops below 80 Ovr his Dev Trait goes to Superstar. Below 75 Star. Below 70 Normal. This balances Dev Trait percentages for the league and just makes more sense.
-30 years of CFM available to play.
-Every CFM will be different. What your friend has happen won’t happen to you even if using the exact same rosters and draft classes. Endless outcomes and replay ability. Storylines. Players taking over positions from aging vets. Makes your CFM become so much more dynamic. That 6th rd QB that you got just because. He hit a potential of 92. But you have your QB of the future already. What do you do?
-Everything in this tool is what I like to call controlled randomness. While random numbers are being pulled, they are following sets of rules, thresholds, and percentages. So, it’s not just a crap shoot. It all makes sense.
-League distribution stays consistent meaning team averaged overalls at the start will be the same 10, 20, and 30 years down the line. So much work was put into getting this part right (much thanks to Maximus Geey and PD on the Discord and the stupid number of sims the did for me). Nobody wants a league of all studs or all garbage players. We worked hard to keep everything in line, and I feel like we nailed it.
Plans for Next Version
-First and foremost, I plan to put in a conversion macro. This way when I do release updates to the tool you do not have to start your CFM over. That would just plan suck. So, you’ll easily be able to transfer over from the old version to the new one.
-A way to take advantage of the morale system. We know players who get above 60 in morale get a +1 Ovr boost and I believe above 80 is a +2 Ovr boost (I could be wrong on the exact number, but you get the idea). This could be a non-permanent way to give guys who have already reached their potential get a little boost. Maybe based on Awards or Pro Bowls.
-Dev Trait progression. Still not an easy way to implement but am trying to find ways around it.
Thanks,
Troy H. (TDawg3782)
Quick Instructions
****VERY IMPORTANT****
-You must zero out all XP Sliders before starting your CFM otherwise it defeats the entire purpose of this tool.
-You must have Excel or a program like that that can handle macros. Everything was written on the latest version of Excel.
-You must not do the 1st progression until after you have loaded you draft class into your CFM for the year. This mean Week 4 at the earliest.
****VERY IMPORTANT****
****DEV NOTE****
-I personally progress at Week 8 and Week 16. You may do what you like but this is how I’ve tested it and how I know it works best. If 1st progression is after Week 3 and the 2nd is before Week 17 everybody on a roster should be upgraded twice for the year. If done differently then that risk is yours.
-ALWAYS MAKE A BACKUP OF YOUR CFM BEFORE EDITING!!!!!
****DEV NOTE****
1. Save CFM at Week 8. Exit out of CFM.
2. Open Franchise Editor. (https://github.com/bep713/madden-fra...ditor/releases)
3. Open your Week 8 saved CFM.
4. Go to table editor, type in 133 and hit enter to get to the player table.
5. File, export, save (i.e. S01 Wk8 1st).
6. Open my progression workbook file.
7. Be sure to enable macros in excel.
8. Click on “Year 1” tab.
9. Click the "Year 1 – 1st Progression" button.
10. Select the file you just exported from the Franchise Editor.
11. All info will be loaded into the "Year 1" tab, Skill Points 1st column and Dev Trait update will be copied and pasted back to your exported excel file, saved, and closed.
12. Go back to Franchise Editor, file, import, and select your exported file.
13. It will take a bit to import. When it’s done save file.
14. Go back to Madden and load Week 8 save.
15. Sim to Week 9 and all players will have progressed (except your players unless you have that on auto).
16. Repeat steps 1-8 at Week 16 of your CFM.
17. This time click the “Year 1 – 2nd Progression” button.
18. Select the file you just exported from the Franchise Editor.
19. Skill Points 2nd column will be copied and pasted back to your exported excel file, saved, and closed.
20. Repeat steps 12-13.
21. Go back to Madden and load Week 16 save.
22. Sim to Week 17 and all players will have progressed (except your players unless you have that on auto).
That’s it.
v2.0
Spoiler
-Regression mod added to tool. Every player above 4 years’ experience and above 79 ovr (no more progression) gets a regression rate. The rates are 25%, 50%, 75%, 100%. The higher the better. That is the percentage of skill points lost that gets added back on. All players below 80 ovr get a 0% (or default regression rate). Players with less than 4 years’ experience are the same except we look at their potential ovr and not actual ovr. Players have a 59% chance of getting a 25% regression rate, a 20% chance of getting a 50% regression rate, a 15% chance of getting a 75% regression rate, and a 5% chance of getting a 100% regression rate. Nothing gets added back to a player until they start to regress.
-Conversion macro added for the 1st year only. This means that if you’ve started your franchise and haven’t reached offseason yet then you can convert the old tool over to the new tool.
Plans for Next Version
-Make the conversion macro go further than Year 1. This way when I do release updates to the tool you do not have to start your CFM over. That would just plan suck. So, you’ll easily be able to transfer over from the old version to the new one.
-A way to take advantage of the morale system. We know players who get above 60 in morale get a +1 Ovr boost and I believe above 80 is a +2 Ovr boost (I could be wrong on the exact number, but you get the idea). This could be a non-permanent way to give guys who have already reached their potential get a little boost. Maybe based on Awards or Pro Bowls.
-Dev Trait progression. Still not an easy way to implement but am trying to find ways around it.
-Something total random that just comes to me. That is what happened with the regression mod. I had no intention of doing anything on regression but then an idea hit and I went running with it.
Thanks,
Troy H. (TDawg3782)
Quick Instructions
****VERY IMPORTANT****
-You must zero out all XP Sliders before starting your CFM otherwise it defeats the entire purpose of this tool.
-You must have Excel or a program like that that can handle macros. Everything was written on the latest version of Excel.
-You must not do the 1st progression until after you have loaded you draft class into your CFM for the year. This mean Week 4 at the earliest.
-Do not change the filename of the tool. The name is hard coded and will cause an error if the filename has been changed.
****DEV NOTE****
-You should run your progressions at Week 8 and Week 16. You should run your regression at 1st week of offseason. That is when the tool is set up to run. If done differently than that risk is yours.
-ALWAYS MAKE A BACKUP OF YOUR CFM BEFORE EDITING!!!!!
****1ST AND 2ND PROGRESSION AND REGRESSION STEP BY STEP****
1. Save your Franchise at Week 8. Exit out of CFM.
2. Open Franchise Editor. (https://github.com/bep713/madden-fra...ditor/releases)
3. Open your Week 8 saved Franchise file.
4. Go to table editor, type in 133 and hit enter to get to the player table.
5. File, export, save (i.e. S01 Wk8 1st). The exported file will automatically open. Close before going to next step.
6. Open my progression tool.
7. Be sure to enable macros in excel.
8. Click on “Year 1” tab.
9. Click the "Year 1 – 1st Progression" button.
10. Select the file you just exported from the Franchise Editor.
11. All info will be loaded into the "Year 1" tab, Skill Points 1st column and Dev Trait update will be copied and pasted back to your exported excel file, saved, and closed. Save my progression tool and close.
12. Go back to Franchise Editor, file, import, and select your exported file.
13. It will take a bit to import. When it’s done save file.
14. Go back to Madden and load Week 8 save.
15. Sim to Week 9 and all players will have progressed (except your players unless you have that on auto).
16. Repeat steps 1-8 at Week 16 of your Franchise.
17. This time click the “Year 1 – 2nd Progression” button.
18. Select the file you just exported from the Franchise Editor.
19. Skill Points 2nd column will be copied and pasted back to your exported excel file, saved, and closed. Save my progression tool and close.
20. Repeat steps 12-13.
21. Go back to Madden and load Week 16 save.
22. Sim to Week 17 and all players will have progressed (except your players unless you have that on auto).
23. Repeat steps 1-8 at 1st week of offseason.
24. This time click the “Year 1 – Regression Fix” button.
25. Select the file you just exported from the Franchise Editor.
26. Regression skill points will be copied and pasted back to your exported excel file, saved, and closed. Save my progression tool and close.
27. Go back to Madden and load 1st week offseason save.
28. CPU players will not auto progress until week 1 of preseason but all skill points have been added back to regressed players based on regression rate. You can manually add them to your players at any time if you want.
****CONVERSION STEP BY STEP****
1. Rename v1.0 of my tool (the older one).
2. Open v2.0 of my tool (the new one).
3. Click the “Year 1 – Conversion Mod” button.
4. Select the v1.0 progression tool.
5. Year 1 will be copied over from old tool to new tool. Save and close v2.0 of my tool.
6. All done. Have fun.
V3.0
Spoiler
-Massive update. The tool has been completely rewritten from the ground up. This will allow for future additions to by implemented much more easily and conversions to be more seamless.
-True dynamic progression has been added. Players progress from 1-6 years. Each payer will progress to their potential at different lengths. Some will only take 1 year to hit potential and others as much as 6 years. And everything in between.
-Dev Trait upgrade bonus. When a player earns a dev upgrade in game, he will get a skill point bonus of 1-4 points.
-Players no longer lose unused skill points. Before any practice squad player or FA when didn’t use earned skill points would have them overwritten. No longer. All unused skill points are added back on.
-Completely rewrote all potential, regression, and years to reach potential formulas to better emulate proper NFL league distribution of talent.
-Add a 1st and 2nd Progression Report. Running each these macros will generate an Excel file that will show all players who progression during that period. All sorted by team, position, and new Ovr. Much easier to see who progressed at a glance then looking in game.
-The tool is much smaller and more user friendly. Should work very fast on all PCs.
Plans for Next Version
-Right now, I am content. I am thinking of maybe implementing a Team Ovr chart based on my own formula (that I haven’t come up with yet) but I’m in no rush. Just an idea.
-Another idea I have (while not directly related to this tool) is a scouting system to replace what is in game. Still have letter grades for key attributes but build in a decent margin of error. Or even allow you to pick how accurate it is. Kind of simulating how good you scouts are. Then generating a report with all information. I don’t know who would use it but I think it could be cool. I could make it have the option to make it super difficult or easy. It’s your franchise. Play it how you want to. Maybe even generate some sort of scouting reports.
-Other then that I think I’m good other then some fine tuning to the tool if I see something that needs adjusting.
Thanks,
Troy H. (TDawg3782)
Quick Instructions
****VERY IMPORTANT****
-You must zero out all XP Sliders before starting your CFM otherwise it defeats the entire purpose of this tool.
-You must have Excel or a program like that that can handle macros. Everything was written on the latest version of Excel.
-Do not change the filename of the tool. The name is hard coded and will cause an error if the filename has been changed.
****DEV NOTE****
-You should run your progressions at Week 8 and Week 16. You should run your regression at 1st week of offseason. That is when the tool is set up to run. If done differently than that risk is yours.
-Link to video tutorial of v3.0 will be created shortly (hopefully lol):
-ALWAYS MAKE A BACKUP OF YOUR CFM BEFORE EDITING!!!!!
****YEAR 1 – WEEK 8 AND WEEK 16 PROGRESSION AND OFFSEASON RESIGN STAGE REGRESSION****
****STEP BY STEP****
1. Save your Franchise at Week 8. Exit out of CFM.
2. Open Franchise Editor. (https://github.com/bep713/madden-fra...ditor/releases)
3. Open your Week 8 saved Franchise file.
4. Go to table editor, type in 141 and hit enter to get to the player table.
5. File, export, save (i.e. S01 Wk8 1st). The exported file will automatically open. Close before going to next step.
6. Open v3.0 of my progression tool.
7. Be sure to enable macros in excel.
8. Click on “1st” tab (it should come up automatically).
9. Click the "Year 1 – Week 8 Progression" button.
10. Select the file you just exported from the Franchise Editor.
11. All info will be loaded in behind the scenes, Skill Points and Dev Trait update will be copied and pasted back to your exported excel file, saved, and closed. Save my progression tool and close.
12. The tool creates a new copy of you exported file. It takes whatever you named it and adds a “_Import.xlsx” at the end (without the quotes). For example, if you named the file you exported from the Franchise Editor “test.xlsx” my tool renames it “test.xlsx_Import.xlsx” (again without quotes) after it copies relevant information and saves it. Go back to Franchise Editor, file, import the file with “_Import.xlsx” (without quotes) at the end, and select your exported file.
13. It will take a bit to import. When it’s done save file.
14. Go back to Madden and load Week 8 save.
15. Sim to Week 9 and all players will have progressed (except your players unless you have that on auto).
16. Repeat steps 1-8 at Week 16 of your Franchise.
17. This time click the “Year 1 – Week 16 Progression” button.
18. Select the file you just exported from the Franchise Editor.
19. All info will be loaded in behind the scenes, Skill Points will be copied and pasted back to your exported excel file, saved, and closed. Save my progression tool and close.
20. Repeat steps 12-13.
21. Go back to Madden and load Week 16 save.
22. Sim to Week 17 and all players will have progressed (except your players unless you have that on auto).
23. Repeat steps 1-8 at 1st week of offseason.
24. This time click the “Year 1 – Offseason Resign Stage Regression” button.
25. Select the file you just exported from the Franchise Editor.
26. Regression skill points and dev trait upgrade bonus will be copied and pasted back to your exported excel file, saved, and closed. Save my progression tool and close.
27. Repeat steps 12-13.
28. Go back to Madden and load 1st week offseason save.
29. CPU players will not auto progress until week 1 of preseason but all skill points have been added back to regressed players based on regression rate and dev upgrade players have earned bonus skill points. You can manually add them to your players at any time if you want.
****YEAR 2-30 – WEEK 8 AND WEEK 16 PROGRESSION AND OFFSEASON RESIGN STAGE REGRESSION****
****STEP BY STEP****
1. Save your Franchise at Week 8. Exit out of CFM.
2. Open Franchise Editor. (https://github.com/bep713/madden-fra...ditor/releases)
3. Open your Week 8 saved Franchise file.
4. Go to table editor, type in 141 and hit enter to get to the player table.
5. File, export, save (i.e. S01 Wk8 1st). The exported file will automatically open. Close before going to next step.
6. Open v3.0 of my progression tool.
7. Click on “1st” tab (it should come up automatically).
8. Click the "Year 2-30 – Week 8 Progression" button.
9. Select the file you just exported from the Franchise Editor.
10. All info will be loaded in behind the scenes, Skill Points and Dev Trait update will be copied and pasted back to your exported excel file, saved, and closed. Save my progression tool and close.
11. The tool creates a new copy of you exported file. It takes whatever you named it and adds a “_Import.xlsx” at the end (without the quotes). For example, if you named the file you exported from the Franchise Editor “test.xlsx” my tool renames it “test.xlsx_Import.xlsx” (again without quotes) after it copies relevant information and saves it. Go back to Franchise Editor, file, import the file with “_Import.xlsx” (without quotes) at the end, and select your exported file.
12. It will take a bit to import. When it’s done save file.
13. Go back to Madden and load Week 8 save.
14. Sim to Week 9 and all players will have progressed (except your players unless you have that on auto).
15. Repeat steps 1-8 at Week 16 of your Franchise.
16. This time click the “Year 2-30 – Week 16 Progression” button.
17. Select the file you just exported from the Franchise Editor.
18. All info will be loaded in behind the scenes, Skill Points will be copied and pasted back to your exported excel file, saved, and closed. Save my progression tool and close.
19. Repeat steps 12-13.
20. Go back to Madden and load Week 16 save.
21. Sim to Week 17 and all players will have progressed (except your players unless you have that on auto).
22. Repeat steps 1-8 at 1st week of offseason.
23. This time click the “Year 2-30 – Offseason Resign Stage Regression” button.
24. Select the file you just exported from the Franchise Editor.
25. Regression skill points and dev trait upgrade bonus will be copied and pasted back to your exported excel file, saved, and closed. Save my progression tool and close.
26. Repeat steps 12-13.
27. Go back to Madden and load 1st week offseason save.
28. CPU players will not auto progress until week 1 of preseason but all skill points have been added back to regressed players based on regression rate and dev upgrade players have earned bonus skill points. You can manually add them to your players at any time if you want.
****REVERT YEAR 2-30 WEEK 8 PROGRESSION****
****STEP BY STEP****
1. What this button does is revert your “Year 2-30 – Week 8 Progression” to how it was before you hit “Year 2-30 – Week 8 Progression”. This is useful because since I don’t have tabs for every year anymore if you make a mistake you can’t just reload. Your previous info will be lost and you’re screwed. So, if you make a mistake (wrong file or whatever it may be) you click this button as basically an undo. Then continue as you normally would at that stage. This is only for the Week 8 progression in years 2-30. If you mess up on a week 16 or regression stage, you can just reimport the file and be fine.
****CLEAR ALL FRESH START ****
****STEP BY STEP****
1. Simply click this button to clear the entire tool to start over.
****1ST PROGRESSION REPORT ****
****STEP BY STEP****
1. Make sure you have already clicked the "Year 1 – Week 8 Progression" button.
2. Click on “1st Progression Report Tab”.
3. Click on the “1st Progression Report” button.
4. It will generate a file called “1st Progression Report.xlsx” and put it in the same folder as your exported files from the Franchise Editor.
5. Open “1st Progression Report.xlsx” file. It’s sorted by Team, Position, and New Ovr. However, you can filter it however you want. I would move or rename this file to something else because every time you run this macro it creates a file with the same name. New Ovr isn’t the actual Ovr in game yet. But will be when the players progress.
****2ND PROGRESSION REPORT ****
****STEP BY STEP****
1. Make sure you have already clicked the "Year 1 – Week 16 Progression" button.
2. Click on “2nd Progression Report Tab”.
3. Click on the “2nd Progression Report” button.
4. It will generate a file called “2nd Progression Report.xlsx” and put it in the same folder as your exported files from the Franchise Editor.
5. Open “2nd Progression Report.xlsx” file. It’s sorted by Team, Position, and New Ovr. However, you can filter it however you want. I would move or rename this file to something else because every time you run this macro it creates a file with the same name. New Ovr isn’t the actual Ovr in game yet. But will be when the players progress.
v4.0
-Potential tier system has been rewritten to better emulate how players progress based even more on Dev Trait. This will allow for less Normal Dev players to be overloading the top tier (90+). But they can still get there.
-Practice Squad players will get a potential rolled but they do not earn their points until they are signed to a roster. If they don’t get signed to a roster, they lose the points for that year.
-Free Agents will not get a potential rolled until signed to a roster. If signed they will get their potential at the next progression/regression stage. This eliminates players sitting in free agency with massive amounts of skill points and asking for a lot of money.
-Regression system has been redone to allow for separate QB and HB regression tiers. Other positions are still grouped together. This will allow for a more realistic regression rate for those positions.
-Reworked at what Ovr players get their Dev Trait downgraded.
-Reworked the Dev Trait upgrade so veterans will get a boost (depending on current Ovr) even if the are already at their potential. Allows for a veteran to have a resurgence.
-Added an Offseason report. Will show progression like the other progression reports but will also show player regression and Dev Trait upgrades.
-v3.0 to v4.0 Conversion macro added so you can continue you franchise without restarting.
-Optimized the import back into your franchise in the franchise editor. It should take no more than 5 seconds.
Plans for Next Version
-Right now, I am content. I am thinking of maybe implementing a Team Ovr chart based on my own formula (that I haven’t come up with yet) but I’m in no rush. Just an idea.
-Other than that I think I’m good other than some fine tuning to the tool if I see something that needs adjusting.
Thanks,
Troy H. (TDawg3782)
Quick Instructions
****VERY IMPORTANT****
-You must zero out all XP Sliders before starting your CFM otherwise it defeats the entire purpose of this tool.
-You must have Excel or a program like that that can handle macros. Everything was written on the latest version of Excel.
-Do not change the filename of the tool. The name is hard coded and will cause an error if the filename has been changed.
****DEV NOTE****
-You must run your 1ST progression any time after Week 3 and your 2nd progression any time before Week 17. You must run your regression at 1st week of offseason. That is when the tool is set up to run. If done differently than that risk is yours.
-Link to video tutorial of v4.0 will be created shortly (hopefully lol):
-ALWAYS MAKE A BACKUP OF YOUR CFM BEFORE EDITING!!!!!
****YEAR 1 – 1ST AND 2ND PROGRESSION AND OFFSEASON RESIGN STAGE REGRESSION****
****STEP BY STEP****
1. Save your Franchise at week you choose to do your progression. Exit out of CFM.
2. Open Franchise Editor. (https://github.com/bep713/madden-fra...ditor/releases)
3. Open your saved Franchise file.
4. Go to table editor, type in 143 (this changes sometimes but it’s usually always between 133-146) and hit enter to get to the player table.
5. File, export, save (i.e. S01 Wk8 1st). The exported file will automatically open. Close before going to next step.
6. Open v4.0 of my progression tool.
7. Be sure to enable macros in excel.
8. Click on “1st” tab (it should come up automatically).
9. Click the "Year 1 – 1st Progression" button.
10. Select the file you just exported from the Franchise Editor.
11. All info will be loaded in behind the scenes, Skill Points and Dev Trait update will be copied and pasted back to your exported excel file, saved, and closed. Save my progression tool and close.
12. The tool creates a new copy of you exported file. It takes whatever you named it and adds a “_Import.xlsx” at the end (without the quotes). For example, if you named the file you exported from the Franchise Editor “test.xlsx” my tool renames it “test.xlsx_Import.xlsx” (again without quotes) after it copies relevant information and saves it. Go back to Franchise Editor, file, import the file with “_Import.xlsx” (without quotes) at the end, and select your exported file.
13. Import has been optimized. Should take no more than 5 seconds. When it’s done save file.
14. Go back to Madden and load your save.
15. Sim to next week and all players will have progressed unless on a bye week. They will progress the next week. (except your players unless you have that on auto).
16. Repeat steps 1-8 at your next chosen week of your Franchise.
17. This time click the “Year 1 – 2nd Progression” button.
18. Select the file you just exported from the Franchise Editor.
19. All info will be loaded in behind the scenes, Skill Points will be copied and pasted back to your exported excel file, saved, and closed. Save my progression tool and close.
20. Repeat steps 12-13.
21. Go back to Madden and load your save.
22. Sim to next week and all players will have progressed unless on a bye week. They will progress the next week. (except your players unless you have that on auto).
23. Repeat steps 1-8 at 1st week of offseason.
24. This time click the “Year 1 – Offseason Resign Stage Regression” button.
25. Select the file you just exported from the Franchise Editor.
26. Regression skill points and dev trait upgrade bonus will be copied and pasted back to your exported excel file, saved, and closed. Save my progression tool and close.
27. Repeat steps 12-13.
28. Go back to Madden and load 1st week offseason save.
29. CPU players will not auto progress until week 1 of preseason but all skill points have been added back to regressed players based on regression rate and dev upgrade players have earned bonus skill points. You can manually add them to your players at any time if you want.
****YEAR 2-30 – 1ST AND 2ND PROGRESSION AND OFFSEASON RESIGN STAGE REGRESSION****
****STEP BY STEP****
1. Save your Franchise at week you choose to do your progression. Exit out of CFM.
2. Open Franchise Editor. (https://github.com/bep713/madden-fra...ditor/releases)
3. Open your saved Franchise file.
4. Go to table editor, type in 143 (this changes sometimes but it’s usually always between 133-146) and hit enter to get to the player table.
5. File, export, save (i.e. S01 Wk8 1st). The exported file will automatically open. Close before going to next step.
6. Open v4.0 of my progression tool.
7. Click on “1st” tab (it should come up automatically).
8. Click the "Year 2-30 – 1st Progression" button.
9. Select the file you just exported from the Franchise Editor.
10. All info will be loaded in behind the scenes, Skill Points and Dev Trait update will be copied and pasted back to your exported excel file, saved, and closed. Save my progression tool and close.
11. The tool creates a new copy of you exported file. It takes whatever you named it and adds a “_Import.xlsx” at the end (without the quotes). For example, if you named the file you exported from the Franchise Editor “test.xlsx” my tool renames it “test.xlsx_Import.xlsx” (again without quotes) after it copies relevant information and saves it. Go back to Franchise Editor, file, import the file with “_Import.xlsx” (without quotes) at the end, and select your exported file.
12. Import has been optimized. Should take no more than 5 seconds. When it’s done save file.
13. Go back to Madden and load your save.
14. Sim to next week and all players will have progressed unless on a bye week. They will progress the next week. (except your players unless you have that on auto).
15. Repeat steps 1-7 at your next chosen week of your Franchise.
16. This time click the “Year 2-30 – 2nd Progression” button.
17. Select the file you just exported from the Franchise Editor.
18. All info will be loaded in behind the scenes, Skill Points will be copied and pasted back to your exported excel file, saved, and closed. Save my progression tool and close.
19. Repeat steps 12-13.
20. Go back to Madden and load your save.
21. Sim to next week and all players will have progressed unless on a bye week. They will progress the next week. (except your players unless you have that on auto).
22. Repeat steps 1-7 at 1st week of offseason.
23. This time click the “Year 2-30 – Offseason Resign Stage Regression” button.
24. Select the file you just exported from the Franchise Editor.
25. Regression skill points and dev trait upgrade bonus will be copied and pasted back to your exported excel file, saved, and closed. Save my progression tool and close.
26. Repeat steps 11-12.
27. Go back to Madden and load 1st week offseason save.
28. CPU players will not auto progress until week 1 of preseason but all skill points have been added back to regressed players based on regression rate and dev upgrade players have earned bonus skill points. You can manually add them to your players at any time if you want.
****REVERT ANY PROGRESSION/REGRESSION STAGE****
****STEP BY STEP****
1. What this button does is revert your Progression Tool to how it was before you hit one of the progression/regression buttons. This is useful because since I don’t have tabs for every year anymore if you make a mistake you can’t just reload. Your previous info will be lost, and you’re screwed. So, if you make a mistake (wrong file or whatever it may be) you click this button as basically an undo. Then continue as you normally would at that stage.
****CLEAR ALL FRESH START ****
****STEP BY STEP****
1. Simply click this button to clear the entire tool to start over.
****V3.0 TO V4.0 CONVERSION ****
****STEP BY STEP****
1. Save your Franchise at week you choose to do your 1st progression. Exit out of CFM.
2. Open Franchise Editor. (https://github.com/bep713/madden-fra...ditor/releases)
3. Open your saved Franchise file.
4. Go to table editor, type in 143 (this changes sometimes but it’s usually always between 133-146) and hit enter to get to the player table.
5. File, export, save (i.e. S01 Wk8 1st). The exported file will automatically open. Close before going to next step.
6. Open v4.0 of my progression tool.
7. Click on “1st” tab (it should come up automatically).
8. Click the "v3.0 to v4.0 Conversion" button.
9. Select v3.0 of the Progression Tool (please rename tool before doing this step to avoid any conflict).
10. Select the file you just exported from the Franchise Editor.
11. The tool creates a new copy of you exported file. It takes whatever you named it and adds a “_Import.xlsx” at the end (without the quotes). For example, if you named the file you exported from the Franchise Editor “test.xlsx” my tool renames it “test.xlsx_Import.xlsx” (again without quotes) after it copies relevant information and saves it. Go back to Franchise Editor, file, import the file with “_Import.xlsx” (without quotes) at the end, and select your exported file.
12. Import has been optimized. Should take no more than 5 seconds. When it’s done save file.
13. Go back to Madden and load your save.
14. Sim to next week and all players will have progressed unless on a bye week. They will progress the next week. (except your players unless you have that on auto).
15. At next week of your choosing continue with “Year 2-30 – 2nd Progression” as normal.
****1ST PROGRESSION REPORT ****
****STEP BY STEP****
1. Make sure you have already clicked the "Year 1 or Year 2-30 – 1st Progression" button.
2. Click on “1st Progression Report Tab”.
3. Click on the “1st Progression Report” button.
4. It will generate a file called “1st Progression Report.xlsx” and put it in the same folder as your exported files from the Franchise Editor.
5. Open “1st Progression Report.xlsx” file. It’s sorted by Team, Position, and New Ovr. However, you can filter it however you want. I would move or rename this file to something else because every time you run this macro it creates a file with the same name. New Ovr isn’t the actual Ovr in game yet. But will be when the players progress.
****2ND PROGRESSION REPORT ****
****STEP BY STEP****
1. Make sure you have already clicked the "Year 1 or Year 2-30 – 2nd Progression" button.
2. Click on “2nd Progression Report Tab”.
3. Click on the “2nd Progression Report” button.
4. It will generate a file called “2nd Progression Report.xlsx” and put it in the same folder as your exported files from the Franchise Editor.
5. Open “2nd Progression Report.xlsx” file. It’s sorted by Team, Position, and New Ovr. However, you can filter it however you want. I would move or rename this file to something else because every time you run this macro it creates a file with the same name. New Ovr isn’t the actual Ovr in game yet. But will be when the players progress.
****OFFSEASON REPORT ****
****STEP BY STEP****
1. Make sure you have already clicked the "Year 1 or Year 2-30 – Offseason Resign Stage Regression" button.
2. Click on “Offseason Report Tab”.
3. Click on the “Offseason Report” button.
4. It will generate a file called “Offseason Report.xlsx” and put it in the same folder as your exported files from the Franchise Editor.
5. Open “Offseason.xlsx” file. It’s sorted by Team, Position, and New Ovr. However, you can filter it however you want. I would move or rename this file to something else because every time you run this macro it creates a file with the same name. New Ovr isn’t the actual Ovr in game yet. But will be when the players progress.
Just a FYI, like Sabo's mod, most of the discussion will be happening on the discord channel. Just way easier to get thoughts across. I will try to update this when I can but to get the latest hit up the channel.
I just wanted to say to anyone who sees this and is on the fence about using it just do it you will be thankful you did. I was hesitant on using it because it seemed like a pain to use and I feared the randomness would devalue draft picks because star dev and higher weren't guaranteed to develop. First it is super easy to use and only takes about 3 minutes twice per season. I have also found that draft picks are actually more valuable because later round picks can actually turn out to be studs.For example one of my late 1st round picks was a 68 ovr Star dev and never developed however I had a 5th round 67 ovr normal dev corner that gained 18 points in one season and became a starter. This mod does for franchise what Sabo's mod does for gameplay. Big thanks to Tdawg and everyone that helped out on this project.
08-23-2019, 10:48 PM
