NCAA Football 14/Madden 19 Draft Class Conversion (PC)

Collapse

Recommended Videos

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • tdawg3782
    I hate you Norv
    • Nov 2003
    • 4803

    #1

    NCAA Football 14/Madden 19 Draft Class Conversion (PC)

    UPDATE 12/8/18
    Uploaded wrong file last time. Now attached is the Madden 19 draft classes. Not the csv files. My bad.


    3 more test draft classes attached with all positions added. Full ratings conversion is done along with draft projection.


    Premise

    To be able to take players going pro in NCAA 14 and convert that into a working draft class file for Madden 19 (PC) with all ratings adjusted and inline with a regular generated Madden draft class. This was one if my favorite features in years past with NCAA and Madden.

    My Plans

    Ultimate goal - I want to create a tool that others can use as well. Who wouldn't love to see the players they've been using in NCAA make it to the NFL. I don't know how automated I can make this so I'm not sure how feasible it is just yet.

    First goal - To be able to make the draft class file work. After that I can hopefully do something along the lines of CWSapp and Radierz with their fictional draft classes. But for the PC guys obviously. It wouldn't be as in depth with scouting reports and what not but it would give players some backstory. Off the top of my head you'd have yearly awards, all americans, all conference, season and career stats, college football backstory, top incoming recruits, top returning players, etc. So some fun stuff.

    Where I'm Currently At

    I've just begun really. I've had this idea for quite awhile. Just this past week StingRay was able to make MaddenAmp export/import draft class files to csv. That's my forte. I've been hard at work figuring out how to make this possible. Lots of things are the same (quite a few ratings) but lots are different as well. It's going to take quite a bit of work. I love automating things but to do that you have to put in all the work the first time.

    As far as how to adjust ratings I have a really good plan in place. Basically it involves their original NCAA rating, a random number formula, and a specific table to get the information from. The cool thing about this method (at least in theory because I've only completed a few attributes) is that with one click of a button every rating will change to a certain degree for the entire draft class. So you could make 10 draft class files with the same players and everyone will have them rated different. I think the rating part will be easy.

    Now to the harder stuff. How to transfer over age, body stuff, ethnicity, college's, mock draft position, dev trait, etc. Some of this stuff isn't in NCAA or the code is just different. I do have a plan for this (basically creating vlookup tables) but I'd have to find all the correct information in both games first. Time consuming stuff to say the least.

    Release Date

    TBD.

    At this point I don't know how long it will take. Then once I finish it's going to be about fixing bugs (because there is always bugs). But I'm hoping to have a working draft class out by the first week in Nov. Depending on family and work responsibilities. Once I get the Excel file done pumping out draft classes shouldn't be to hard. Other then figuring out a good format to give the backstory information. Hopefully after that I can release a working copy for everybody to use. Or at the very least for a little while I could have you email me your NCAA csv and I could create a draft class from it. That's a bit down the road though. Gotta stay focused on the task at hand first.

    Conclusion

    This has been a dream of mine since I heard Madden was coming to the PC. Hopefully some of you other guys are interested as well. Regardless this project is near and dear to me so I will get it done no matter what. Thanks for reading.

    Sent from my SM-G950U using Tapatalk
    Attached Files
    Last edited by tdawg3782; 12-08-2018, 08:01 PM.

  • tdawg3782
    I hate you Norv
    • Nov 2003
    • 4803

    #2
    Re: NCAA Football 14/Madden 19 Draft Class Conversion (PC)

    Quick Update

    I've written formulas for all attributes. I then imported my csv into a draft class and everything loaded up perfectly. I love when things work on the first try. However I will need to do some major tweaking with the some of the tables. Not a big deal. I had already planned on this. It was much more of a guess at the start. But with formulas in place it's as easy as changing a few numbers around. I am much further ahead then I though I'd be at this point.


    I've also have a really good idea on the body type conversion. I will have to see if it works right but I think it should. Feeling pretty good right now.

    Comment

    • navygoat1998
      Rookie
      • May 2008
      • 122

      #3
      Re: NCAA Football 14/Madden 19 Draft Class Conversion (PC)

      Originally posted by tdawg3782
      Quick Update

      I've written formulas for all attributes. I then imported my csv into a draft class and everything loaded up perfectly. I love when things work on the first try. However I will need to do some major tweaking with the some of the tables. Not a big deal. I had already planned on this. It was much more of a guess at the start. But with formulas in place it's as easy as changing a few numbers around. I am much further ahead then I though I'd be at this point.


      I've also have a really good idea on the body type conversion. I will have to see if it works right but I think it should. Feeling pretty good right now.
      Thank you!

      Comment

      • tdawg3782
        I hate you Norv
        • Nov 2003
        • 4803

        #4
        Re: NCAA Football 14/Madden 19 Draft Class Conversion (PC)

        Quick Update #2

        So I spent the majority of yesterday messing around with formulas to convert the NCAA 14 players attributes to the Madden 19 scale. I learned a lot so far.


        The Good
        So far I haven't had any loading issues or errors when using the imported draft classes. I've tweaked ones up at least 8 times and it has worked flawlessly every time.


        I know exactly how I want to handle the attribute conversion now. I have a firm plan and it seems to be working very well as far as basic adjustments and also putting in that touch of busts and gems.


        The Bad
        Really no so much bad but all the work I did yesterday has to be redone. My original idea was just not working. But putting in all that work gave me the new idea I have now. So I must rewrite all the formulas and they are much more intricate now. But it's for the better for sure.


        What's Next
        First I need to finish writing all the formulas for all attributes. That is the bulk of the work. It will take a bit. After that it's getting some of the easier things done such as colleges and draft position. After that will be traits (I will be using Imac's ideas here). Lastly it will be getting player size, race, and faces to work right. I'm not too concerned with equipment as of now because that seems like it would be a huge task.


        That's it. For those interested I will keep you updated.

        Comment

        • tdawg3782
          I hate you Norv
          • Nov 2003
          • 4803

          #5
          Re: NCAA Football 14/Madden 19 Draft Class Conversion (PC)

          Update #3

          All attribute formulas are done. Imported draft class looks really good for the most part. May need a few tweaks here and there but it would be small stuff. Draft bust/gem feature in formula looks like it should work quite well. Feel very good about it.


          Next step is to run some sims of multiple seasons in NCAA to make sure things stay pretty consistent with some outliers here and there. I will also start the task of getting traits, race, body, and colleges correct.

          Comment

          • navygoat1998
            Rookie
            • May 2008
            • 122

            #6
            Re: NCAA Football 14/Madden 19 Draft Class Conversion (PC)

            Originally posted by tdawg3782
            Update #3

            All attribute formulas are done. Imported draft class looks really good for the most part. May need a few tweaks here and there but it would be small stuff. Draft bust/gem feature in formula looks like it should work quite well. Feel very good about it.


            Next step is to run some sims of multiple seasons in NCAA to make sure things stay pretty consistent with some outliers here and there. I will also start the task of getting traits, race, body, and colleges correct.
            Thank you!

            Comment

            • tdawg3782
              I hate you Norv
              • Nov 2003
              • 4803

              #7
              Re: NCAA Football 14/Madden 19 Draft Class Conversion (PC)

              Update #4

              Colleges are done. Important traits are done (clutch and dev) to reflect correct percentages. Big Hitter on for players with >89 hit power. High motor is off.


              I put a modifier in the formula to make things more dynamic. It's working fantastic so far. Bryce Love came out as a 78 ovr on one import, an 85 ovr on another, and an 81 ovr on another. It's very fluid which is awesome and it's easily tuneable.


              Next up today is draft order, body stuff, and other traits. Hope to have most of this part finished soon.

              Comment

              • Hamhog
                Rookie
                • Dec 2013
                • 10

                #8
                Re: NCAA Football 14/Madden 19 Draft Class Conversion (PC)

                Originally posted by tdawg3782
                Update #4

                Colleges are done. Important traits are done (clutch and dev) to reflect correct percentages. Big Hitter on for players with >89 hit power. High motor is off.


                I put a modifier in the formula to make things more dynamic. It's working fantastic so far. Bryce Love came out as a 78 ovr on one import, an 85 ovr on another, and an 81 ovr on another. It's very fluid which is awesome and it's easily tuneable.


                Next up today is draft order, body stuff, and other traits. Hope to have most of this part finished soon.
                So will this be an editor for PC or some type of program, can't wait till this is done I'm so ready

                Comment

                • tdawg3782
                  I hate you Norv
                  • Nov 2003
                  • 4803

                  #9
                  Re: NCAA Football 14/Madden 19 Draft Class Conversion (PC)

                  Originally posted by Hamhog
                  So will this be an editor for PC or some type of program, can't wait till this is done I'm so ready
                  The draft classes that I will do you will be able to download like regular draft classes. Doing it yourself is a bit different. Its not a legit editor. But like an editor run through Excel. Still working out a lot of kinks right now. Not too complicated just time consuming.

                  I rewrote the entire conversion process. My original way just wasn't working right. But I'm happy to say that the rewrite is done and now I just need to tune some numbers which is quite easy. Most positions are solid with just a few of them off by a small margin.

                  Sent from my SM-G950U using Tapatalk

                  Comment

                  • Hamhog
                    Rookie
                    • Dec 2013
                    • 10

                    #10
                    Re: NCAA Football 14/Madden 19 Draft Class Conversion (PC)

                    Originally posted by tdawg3782
                    The draft classes that I will do you will be able to download like regular draft classes. Doing it yourself is a bit different. Its not a legit editor. But like an editor run through Excel. Still working out a lot of kinks right now. Not too complicated just time consuming.

                    I rewrote the entire conversion process. My original way just wasn't working right. But I'm happy to say that the rewrite is done and now I just need to tune some numbers which is quite easy. Most positions are solid with just a few of them off by a small margin.

                    Sent from my SM-G950U using Tapatalk


                    So will they be available to download offline ??

                    Comment

                    • Darth Aegis
                      Lord of Suffering
                      • Jul 2012
                      • 4169

                      #11
                      Re: NCAA Football 14/Madden 19 Draft Class Conversion (PC)

                      Honestly, cant wait for this!
                      OS needs a Thumbs DOWN button

                      Playing:

                      Comment

                      • tdawg3782
                        I hate you Norv
                        • Nov 2003
                        • 4803

                        #12
                        Re: NCAA Football 14/Madden 19 Draft Class Conversion (PC)

                        Originally posted by Hamhog
                        So will they be available to download offline ??
                        Probably.

                        Sent from my SM-G950U using Tapatalk

                        Comment

                        • tdawg3782
                          I hate you Norv
                          • Nov 2003
                          • 4803

                          #13
                          Re: NCAA Football 14/Madden 19 Draft Class Conversion (PC)

                          Update #5

                          So I seriously underestimated the amount of time this would take me. I am not at the point in being able to release a DC yet. At least not the way I want it done.


                          I am on version 4 already of the attribute conversion formulas. As far as the formulas go I think it's locked in. Shouldn't need to change them anymore at all. Now it's just a matter of tweaking some numbers around. I want this to be a seamless conversion. So here is what I'm actually doing for those wondering.


                          So the basic idea is to convert NCAA 14 attributes to Madden 19. This obviously proves to be a bit difficult considering NCAA is 5 years behind Madden. We also now have quite a few more attributes then we used to have meaning I need to find a different way to find this new rating instead of just using the NCAA number. Easier said then done. So what I'm in the process of doing is finding ranges (high, low, average) for incoming rookies in Madden (based off of Madden generic draft classes). I've done this for each relevant rating and at each position (I grouped OL, DE, LB, S, and K). So for example I have the range for every attribute that is important to QBs. I got the ranges from combining 5 separate draft classes to really get as much data as possible.


                          I am now doing the same thing with NCAA. I will sim 5 seasons and compile all players leaving at the end of each season. Then go and find the ranges for them. After all this data is gathered my formula will take the NCAA rating and convert it to the Madden generic draft class ratings scale (with a little bit of randomness involved to account for gems/busts).


                          I really want to do this right. I could have just settled on my first few versions but it wouldn't have been as good in the long run. So I apologize for getting hopes up originally. It's gonna take me some time still. But I'm feeling very confident on where it's at. I don't have too much guess work going on anymore. It's just a matter of plugging away.

                          Comment

                          • tdawg3782
                            I hate you Norv
                            • Nov 2003
                            • 4803

                            #14
                            Re: NCAA Football 14/Madden 19 Draft Class Conversion (PC)

                            Haven't commented here much lately. But I've been working really really hard trying to get this to work right. As much as I thought my formula for the rating conversion was set after going through some test runs I realized it just wasn't working correctly. However now I have found a way to make it work. For real this time lol.

                            Unfortunately I've had to rewrite every single formula again. these formulas are quite complicated and time-consuming as well. I actually had to create a formula to help me write my formulas if that makes sense. Anyways I have quarterbacks through tight ends done and the ratings are very solid. I'm working on o line now and once I finish I plan to release 3 test versions of these draft classes so you guys can see how it's working and also how my stud/gem randomizer works as well.you'll basically get three versions of the same draft class but the ratings will be slightly tweaked across the board.

                            I'm hoping to release these later today and then start working on defense after that. As far as creating a tool that everybody can use I'm definitely not there yet. For now it's just going to be me doing it and releasing draft classes. I'm still have a long ways to go but once I finish the rating conversion the rest of it should be pretty simple. The ratings were the toughest to get right but I'm happy to say that I think I've finally been able to do it and every rating that will be in Madden is based off of their rating in NCAA.

                            Sent from my SM-G950U using Tapatalk

                            Comment

                            • tdawg3782
                              I hate you Norv
                              • Nov 2003
                              • 4803

                              #15
                              Re: NCAA Football 14/Madden 19 Draft Class Conversion (PC)

                              Finally!!!!! Offense is done. QB thru OL. Ratings conversion is on point and working great. I will upload 3 versions of a draft class so you guys can see how the gem/stud/randomizer works. I can tweak an entire draft class with a simple refresh in excel. Really cool for people who man want to do multiple franchises and/or start over and not know how good players will be. It's still in context (good players will still be good) but Ovr can change by a decent margin.


                              What is done so far:
                              -Ratings conversions for QB thru OL
                              -Accurate Colleges
                              -Accurate hieght/weight
                              -Age based on what year player went pro with a bit of a random element involved as well
                              -Body sizes should be good


                              Things to do still:
                              -Ratings conversion for DE-K/P
                              -Correct ethnicity
                              -Draft Projections
                              -Jersey Numbers

                              -How to work in traits (thinking of maybe doing a traits based on ratings thing or maybe just a spread based on percentage)


                              That's mostly it. I've also streamlined some things that will make it much easier to release so you can do it yourself. It was a bit of a clustered mess before. Draft classes are posted in the OP. Remember it's only Offense so far. All defensive stuff hasn't been done yet.

                              Comment

                              Working...