What if I told you... that Roster Tools is BACK!

Collapse

Recommended Videos

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • PatsCards87
    Rookie
    • Apr 2015
    • 109

    #1

    What if I told you... that Roster Tools is BACK!

    LADIES AND GENTLEMEN...... ROSTER TOOLS HAS ARRIVED!!!!!


    Click here to get your copy now!

    I also highly recommend using this in conjunction with WTNY's pitch edits spreadsheet. It's quality work and combined will give you ultimate editing functionality. You can find that in his thread here:

    http://www.operationsports.com/forum...-read-faq.html

    Things you need to know about the RosterTools program:

    This is run on Microsoft Excel, guaranteed to work on 2010 and new versions.

    You HAVE to enable Macros and Enable Data Connections (Excel might call it "Active Content"). Excel will prompt you to activate/allow these things under the formula bar.

    There are buttons for sorting batter and pitcher names. You only need to click that 1 time after you have selected a new year.

    Ratings are weighted by sabermetrics to the game. A full season sim should yield very realistic results.

    Arm Strength, Arm Accuracy, and Reaction (as well as Catcher Blocking) are loosely based on FRAA. However, that stuff is incredibly hard to turn into a rating based off any stats, so they are ONLY an estimate. I would recommend adjusting accordingly for player you know have a good arm, or if the player is in the game, just stick with SCEA default ratings for those attributes.

    In order to get Blocking ratings, be sure to click the "Catcher?" checkbox. It will populate numbers for you. BE SURE TO UNCHECK IT AFTER YOU SELECT A NEW PLAYER THAT ISN'T A CATCHER!

    Do NOT edit or change ANYTHING that isn't on the Home tab. You don't need to click around and edit things, you WILL break it. Just stay on the Home tab.

    Scroll down to the bottom and you will see PITCHf/x information. It will tell you what pitches the pitcher you have selected really throws. How often they throw it. What speed they throw it at on average (so you can duplicate that speed in the game by adjusting velocity accordingly) and it gives movement.

    There is no formula I could really come up with to portray pitch movement. I recommend just sticking to SCEA default. If it is a created player, then use your judgement.

    PITCHf/x data reads in a plus shape +

    0 is in the middle, -15 is to the far left, 15 is on the far right, and same for the top and bottom.

    So a pitch that has a -9 VMov and a 3 Hmov means that the pitch drops 9 inches, and cuts inside 3 inches. That's an example of how much movement is involved. Use your judgement is all I can say.

    If anyone has a formula, I can update the file and reupload.

    PLEASE REPORT ANY AND ALL BUGS ASAP SO I CAN FIX AND REUPLOAD!

    I plan to keep this thing taken care of. Hope you all enjoy! A lot of work went into this.
    Last edited by PatsCards87; 06-01-2015, 10:55 AM.
    PSN: Grits_N_Gravy_23
  • Thomas7
    Rookie
    • Oct 2010
    • 232

    #2
    Re: What if I told you... that Roster Tools is BACK!

    Great to hear a LOT of HARD WORK I am SURE. With that said the gaming of stats have changed. You should contact Knights,Riding,Nomo, third degree, carew and some of these great Minds in operation sports, to see how it will correlate

    Comment

    • PatsCards87
      Rookie
      • Apr 2015
      • 109

      #3
      Re: What if I told you... that Roster Tools is BACK!

      Good idea, is there a way to ping these guys in this thread? We can compare formulas and put our heads together to come up with the best set.

      Beyond that, this tool is still very useful as it can instantly generate what ratings should be for a player by just selecting them from the list. Stats are pulled in real time.
      PSN: Grits_N_Gravy_23

      Comment

      • Thomas7
        Rookie
        • Oct 2010
        • 232

        #4
        Re: What if I told you... that Roster Tools is BACK!

        This is a great tool, once the word get around it is going to be a STAR. These guys are always posting in here. Ridings is doing the osfm rosters he is on the second post also knight. Willard is doing the revisited hybrid rosters.

        Comment

        • PatsCards87
          Rookie
          • Apr 2015
          • 109

          #5
          Re: What if I told you... that Roster Tools is BACK!

          Well hopefully they'll see it and reach out to me. I don't want to bug them about it, they may already have something they like using and don't want to mess with it.

          I know it's come in handy for me when paired with Dr Sublimes phenomenal CAPs. His faces are spot on, but not so much his ratings. But hey, small price to pay when he makes such great CAP faces.
          PSN: Grits_N_Gravy_23

          Comment

          • Thomas7
            Rookie
            • Oct 2010
            • 232

            #6
            Re: What if I told you... that Roster Tools is BACK!

            You got a point there. But for the REST of US This is going to be HUGE. THANK YOU MORE Then I Can SAY.

            Comment

            • PatsCards87
              Rookie
              • Apr 2015
              • 109

              #7
              Re: What if I told you... that Roster Tools is BACK!

              Thank you, that's why I took on this project. To help the community at large. The thing was a tremendous tool that has lay broken for 5 years, seemed high time to fix it and give it a facelift. Can't wait to release it for everyone.

              I'm going to also release my own roster.

              It is going to be a fantasy roster of current and historic players for all teams.

              The base roster is the OSFM Roster 40-Man that Millenium came out with.

              I then have imported the legendary players that are in-game.

              Then I have downloaded over 200 players from Dr Sublime.

              I'm awaiting some more players, and going to re-rate all Dr Sublimes creations with the new and improved Roster Tools.

              Once completed, you'll be able to load the bases up with Ryne Sandberg, Ernie Banks, and Andre Dawson, then hit the grand slam with Kris Bryant. Man that hurt to say as a Cardinal fan, but it is the best example of all the eras of players you will be able to find on one team.

              It's going to be a great fantasy roster set.
              PSN: Grits_N_Gravy_23

              Comment

              • BrianU
                MVP
                • Nov 2008
                • 1565

                #8
                Re: What if I told you... that Roster Tools is BACK!

                Very interesting. I'd love to take a look at it. Are the ratings it spits out on scale with the OSFM roster? Like if I put in Daniel Murphy would it give me more accurate ratings for him that would play well with everyone else in the roster or would it make him overpowered/underpowered?

                Comment

                • Willard76
                  MVP
                  • Mar 2012
                  • 2841

                  #9
                  Re: What if I told you... that Roster Tools is BACK!

                  Originally posted by PatsCards87
                  What if I told you that I have not only personally fixed Bahnzo's Roster Tools spreadsheet that has been broken since 2010, but also given it a facelift and now can provide ratings for pitchers and batters since 1900? I'm currently working out the possibility of adding pre-1900 ratings.

                  I think this can change the game for you roster creators. For those that remember Bahnzo's Roster Tools, you know how great of a resource it was.

                  If the community is interested, I can have it uploaded by Friday.

                  Chat with Waittilnextyear - I think he has narrowed down stats and ratings as close as anyone.

                  OSFM BLUE JAYS Creator

                  Soundpack Contributor

                  Associate Creator and Godfather of the OSFM Hybrid Roster

                  follow me on twitter @billybrent

                  Comment

                  • PatsCards87
                    Rookie
                    • Apr 2015
                    • 109

                    #10
                    Re: What if I told you... that Roster Tools is BACK!

                    Originally posted by BrianU
                    Very interesting. I'd love to take a look at it. Are the ratings it spits out on scale with the OSFM roster? Like if I put in Daniel Murphy would it give me more accurate ratings for him that would play well with everyone else in the roster or would it make him overpowered/underpowered?
                    Good question, the way the program works, is you have to select individual years for a player.

                    Note: You MUST have an internet connection for this program to work. It's highly advanced. It pulls stats in real-time based on your selection on the spreadsheet, from Baseball Prospectus. Without an internet connection, it will not work.

                    Anyway, so you need to first decide which statistical year you want to mirror in game. What I do is I look for a year that statistically looks average among a players other years.

                    Lets say I grab 2013 Daniel Murphy, this is what the program spits out at me. These are based on some very intricate and detailed formulas that allow split stat breakdowns so as to correctly differentiate a hitters performance vs left/right handed pitchers accordingly.

                    The only stats that are incredibly hard to determine are a players arm strength/accuracy as well as reaction time and blocking. I would need to take a look at another users spreadsheet to see what metrics they use to determine such a rating. There is the Put Out statistic, but once a player gains a reputation, people won't test their arm, so a low Put Out stat for a player doesn't equate to a bad arm.

                    Anyway, take a look at these stats and give me some feedback on how accurate you think they came out. Remember, this is 2013 Murphy.

                    <table border="0" cellpadding="0" cellspacing="0" width="247"><colgroup><col style="mso-width-source:userset;mso-width-alt:2779;width:57pt" width="76"> <col style="mso-width-source:userset;mso-width-alt:1609;width:33pt" width="44"> <col style="mso-width-source:userset;mso-width-alt:1828;width:38pt" width="50"> <col style="mso-width-source:userset;mso-width-alt:2816;width:58pt" width="77"> </colgroup><tbody><tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt;width:57pt" height="20" width="76">ConR</td> <td style="width:33pt" width="44">
                    </td> <td class="xl68" style="width:38pt" width="50">
                    </td> <td class="xl68" style="width:58pt" width="77">83</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl66" style="height:15.0pt" height="20">ConL</td> <td>
                    </td> <td class="xl68">
                    </td> <td class="xl68">71</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt" height="20">PowR</td> <td>
                    </td> <td class="xl68">
                    </td> <td class="xl68">56</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt" height="20">PowL</td> <td>
                    </td> <td class="xl68">
                    </td> <td class="xl68">17</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt" height="20">Bnt</td> <td>
                    </td> <td class="xl68">
                    </td> <td class="xl68">28</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt" height="20">DBnt</td> <td>
                    </td> <td class="xl68">
                    </td> <td class="xl68">28</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt" height="20">Vis</td> <td>
                    </td> <td class="xl68">
                    </td> <td class="xl68">80</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt" height="20">Disc</td> <td>
                    </td> <td class="xl68">
                    </td> <td class="xl68">30</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt" height="20">Clu</td> <td>
                    </td> <td class="xl68">
                    </td> <td class="xl68">59</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt" height="20">Dur</td> <td>
                    </td> <td class="xl68">
                    </td> <td class="xl68">98</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt" height="20">Spd</td> <td>
                    </td> <td class="xl68">
                    </td> <td class="xl68">67</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt" height="20">Arm</td> <td>
                    </td> <td class="xl68">
                    </td> <td class="xl68">-</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt" height="20">Acc</td> <td>
                    </td> <td class="xl68">
                    </td> <td class="xl68">-</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt" height="20">Rea</td> <td>
                    </td> <td class="xl68">
                    </td> <td class="xl68">-</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt" height="20">Fld</td> <td>
                    </td> <td class="xl68">
                    </td> <td class="xl68">50</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt" height="20">Blk</td> <td>
                    </td> <td class="xl68">
                    </td> <td class="xl68">-</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt" height="20">BRAbility</td> <td>
                    </td> <td class="xl68">
                    </td> <td class="xl68">61</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt" height="20">BRAgility</td> <td>
                    </td> <td class="xl68">
                    </td> <td class="xl68">44</td> </tr> </tbody></table>
                    Last edited by PatsCards87; 04-29-2015, 11:12 AM.
                    PSN: Grits_N_Gravy_23

                    Comment

                    • Thomas7
                      Rookie
                      • Oct 2010
                      • 232

                      #11
                      Re: What if I told you... that Roster Tools is BACK!

                      Can it do three years average? For example if you imput 2012 it does 12,13 and 14.

                      Comment

                      • PatsCards87
                        Rookie
                        • Apr 2015
                        • 109

                        #12
                        Re: What if I told you... that Roster Tools is BACK!

                        If everyone is ok with pushing the release date back, I can have this bad boy do anything I want it to do.
                        PSN: Grits_N_Gravy_23

                        Comment

                        • Ripner
                          Pro
                          • Mar 2011
                          • 636

                          #13
                          Re: What if I told you... that Roster Tools is BACK!

                          Originally posted by PatsCards87
                          If everyone is ok with pushing the release date back, I can have this bad boy do anything I want it to do.
                          I'd love to see this tool, I plan on making an all time great roster and this tool would hero internally as I'm really struggling with ratings.

                          Comment

                          • Ripner
                            Pro
                            • Mar 2011
                            • 636

                            #14
                            Re: What if I told you... that Roster Tools is BACK!

                            Originally posted by PatsCards87
                            If everyone is ok with pushing the release date back, I can have this bad boy do anything I want it to do.
                            I'd love to see the best tool possible and would not mind such a delay.

                            Comment

                            • PatsCards87
                              Rookie
                              • Apr 2015
                              • 109

                              #15
                              Re: What if I told you... that Roster Tools is BACK!

                              I spoke with WaitTilNextYear, and he has declined to compare spreadsheets and formulas, which is fine. He has his reasons, even if I don't agree. Those Cubs fans, I tell ya...

                              We'll move along. I'm going to incorporate more advanced metrics than has ever been used in a roster editor, and I think the community will unanimously recognize this file as being the be-all-end-all of ratings.

                              I would love input from the community on ways to improve it, somes things you'd like to see, and just any feedback. This will be released openly and publicly. Bahnzo started this, I just picked it up and fixed it. It's the People's Property, not one persons. If it increases the joy a person gets out of the game, then it served it's purpose.

                              This workbook does include ratings to give pitchers, and I'm currently working on expanding this to autonomously pull Pitch/fx data as well. Exciting things are on the horizon.
                              PSN: Grits_N_Gravy_23

                              Comment

                              Working...