Made my own ratings calculator - Operation Sports Forums

Recommended Videos

Collapse

Made my own ratings calculator

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • DeathMetal
    Rookie
    • Mar 2008
    • 168

    #1

    Made my own ratings calculator

    I made this with Excel 2003. It's something I've been working on on and off for months now.

    It has an automatic ratings calculator with a pull down list of players, just select the player you want and it will bring up his stats for 09, 10, and 11 and calculate his in game ratings. There is also a manual calculator where you can input the stats yourself, and you can enter up to three years if you want.

    This will show ratings for individual years, 3 years avg., and 3 years weighted to the latest year.

    This is only for position players and only covers contact (L, R), power (L,R), vision, discipline, and clutch.

    *Updated 4/9/2012
    Attached Files
    Last edited by DeathMetal; 04-09-2012, 06:30 PM.

  • spboden
    Rookie
    • Mar 2012
    • 296

    #2
    Re: Made my own ratings calculator

    Nice, seems pretty accurate, have you tried putting these in yet?

    Comment

    • DeathMetal
      Rookie
      • Mar 2008
      • 168

      #3
      Re: Made my own ratings calculator

      No, I haven't really tested these out for a significant amount of time in game yet. I have played like one game with two edited teams and it seemed to play well, but I haven't played through and entire season or anything like that. I did notice though that a lot of players are underrated in power and contact in Sony's roster.

      Comment

      • spboden
        Rookie
        • Mar 2012
        • 296

        #4
        Re: Made my own ratings calculator

        I use knights OSFM full minor roster....i think i will start to update players based off this and let you know. thanks

        Comment

        • Scott
          Your Go-to TV Expert
          • Jul 2002
          • 20028

          #5
          Re: Made my own ratings calculator

          Plan on adding anything for Durability and Fielding Ability?
          PSN-Shugarooo
          Steam-ScottM.816
          Twitch.tv/Shugarooo
          Want to follow my Franchises? Join my discord: https://discord.gg/nHbNCWmmGs

          Comment

          • Scott
            Your Go-to TV Expert
            • Jul 2002
            • 20028

            #6
            Re: Made my own ratings calculator

            Inputed some those ratings for Texas as well as the Top 15 Players on each team....
            Starters
            Kinsler - .256, 29 HR, 148 H, 88 RBI
            Andrus - .238, 4 HR, 136 H, 40 RBI
            Beltre - .269, 25 HR, 141 H, 77 RBI
            Hamilton - .309, 19 HR, 123 H, 65 RBI (missed a lot of time)
            Young - .258, 23 HR, 153 H, 91 RBI
            Cruz - .271, 41 HR, 140 H, 100 RBI
            Napoli - .268, 36 HR, 140 H, 104 RBI
            Murphy - .275, 20 HR, 130 H, 69 RBI
            Moreland - .258, 14 HR, 99 H, 47 RBI
            Bench
            Torrealba - .249, 5 HR, 57 H, 23 RBI
            Gonzalez - .200, 1 HR, 53 H, 14 RBI
            Borbon - .316, 3 HR, 95 H, 31 RBI
            Martin - .257, 2 HR, 58 H, 14 RBI

            BA Leader - Mauer - .330
            H Leader - Mauer - 209
            2B Leader - Ichiro - 55
            3B Leader - Crisp - 10
            HR Leader - Konerko - 43 (Gomes had 42, Cruz 41, Cabrera 39, Pena 39, Martinez 37, Longoria 36, Fielder 36
            RBI Leader - V-Mart - 120 (13 players had 100+, not bad)

            Playoff Stats
            Kinsler - .242, 5 HR, 16 H, 12 RBI
            Andrus - .127, 0 HR, 9 H, 2 RBI
            Beltre - .290, 4 HR, 20 H, 9 RBI
            Hamilton - .354, 6 HR, 23 H, 13 RBI
            Young - .109, 1 HR, 7 H, 1 RBI
            Cruz - .179, 2 HR, 10 H, 6 RBI
            Napoli - .262, 5 HR, 16 H, 10 RBI
            Murphy - .220, 1 HR, 13 H, 4 RBI
            Moreland - .292, 2 HR, 14 H, 8 RBI

            Rangers lost to Phillies in the WS, 4 games to 2.
            Last edited by Scott; 04-05-2012, 05:11 PM.
            PSN-Shugarooo
            Steam-ScottM.816
            Twitch.tv/Shugarooo
            Want to follow my Franchises? Join my discord: https://discord.gg/nHbNCWmmGs

            Comment

            • DeathMetal
              Rookie
              • Mar 2008
              • 168

              #7
              Re: Made my own ratings calculator

              Originally posted by Scott
              Plan on adding anything for Durability and Fielding Ability?
              I wasn't really planning on it but I might look into it. I would need to try to figure out what stats to use for each and how to calculate the ratings from them. It would just take a lot of work inputting the extra stats into the databases. There are a lot of players in there.

              Originally posted by Scott
              Inputed some those ratings for Texas as well as the Top 15 Players on each team....
              Starters
              Kinsler - .256, 29 HR, 148 H, 88 RBI
              Andrus - .238, 4 HR, 136 H, 40 RBI
              Beltre - .269, 25 HR, 141 H, 77 RBI
              Hamilton - .309, 19 HR, 123 H, 65 RBI (missed a lot of time)
              Young - .258, 23 HR, 153 H, 91 RBI
              Cruz - .271, 41 HR, 140 H, 100 RBI
              Napoli - .268, 36 HR, 140 H, 104 RBI
              Murphy - .275, 20 HR, 130 H, 69 RBI
              Moreland - .258, 14 HR, 99 H, 47 RBI
              Bench
              Torrealba - .249, 5 HR, 57 H, 23 RBI
              Gonzalez - .200, 1 HR, 53 H, 14 RBI
              Borbon - .316, 3 HR, 95 H, 31 RBI
              Martin - .257, 2 HR, 58 H, 14 RBI

              BA Leader - Mauer - .330
              H Leader - Mauer - 209
              2B Leader - Ichiro - 55
              3B Leader - Crisp - 10
              HR Leader - Konerko - 43 (Gomes had 42, Cruz 41, Cabrera 39, Pena 39, Martinez 37, Longoria 36, Fielder 36
              RBI Leader - V-Mart - 120 (13 players had 100+, not bad)

              Playoff Stats
              Kinsler - .242, 5 HR, 16 H, 12 RBI
              Andrus - .127, 0 HR, 9 H, 2 RBI
              Beltre - .290, 4 HR, 20 H, 9 RBI
              Hamilton - .354, 6 HR, 23 H, 13 RBI
              Young - .109, 1 HR, 7 H, 1 RBI
              Cruz - .179, 2 HR, 10 H, 6 RBI
              Napoli - .262, 5 HR, 16 H, 10 RBI
              Murphy - .220, 1 HR, 13 H, 4 RBI
              Moreland - .292, 2 HR, 14 H, 8 RBI

              Rangers lost to Phillies in the WS, 4 games to 2.
              What do you think about the results, do HR's seem too high? Also which ratings did you use, 3 year average or weighted or?
              Last edited by DeathMetal; 04-06-2012, 01:43 AM.

              Comment

              • thevaliantx
                Banned
                • Jul 2011
                • 369

                #8
                Re: Made my own ratings calculator

                Why won't SCEA release to the gaming community its formulas for ratings so that folks like you can create software to allow for easy rostering creation and editing?

                Comment

                • Scott
                  Your Go-to TV Expert
                  • Jul 2002
                  • 20028

                  #9
                  Re: Made my own ratings calculator

                  Originally posted by DeathMetal
                  I wasn't really planning on it but I might look into it. I would need to try to figure out what stats to use for each and how to calculate the ratings from them. It would just take a lot of work inputting the extra stats into the databases. There are a lot of players in there.


                  What do you think about the results, do HR's seem too high? Also which ratings did you use, 3 year average or weighted or?
                  I used the weighted 3 year avg. HR do seem a little high, figuring last year only 4 players had over 36 and in this year I had 8.
                  PSN-Shugarooo
                  Steam-ScottM.816
                  Twitch.tv/Shugarooo
                  Want to follow my Franchises? Join my discord: https://discord.gg/nHbNCWmmGs

                  Comment

                  • Scott
                    Your Go-to TV Expert
                    • Jul 2002
                    • 20028

                    #10
                    Re: Made my own ratings calculator

                    What would you suggest doing for players with only 1 or 2 years of experience or limited time?

                    I also noticed that Michael Young is missing his RH splits in 2009
                    Last edited by Scott; 04-06-2012, 01:08 PM.
                    PSN-Shugarooo
                    Steam-ScottM.816
                    Twitch.tv/Shugarooo
                    Want to follow my Franchises? Join my discord: https://discord.gg/nHbNCWmmGs

                    Comment

                    • DeathMetal
                      Rookie
                      • Mar 2008
                      • 168

                      #11
                      Re: Made my own ratings calculator

                      Originally posted by Scott
                      What would you suggest doing for players with only 1 or 2 years of experience or limited time?

                      I also noticed that Michael Young is missing his RH splits in 2009
                      My general rule has been that if they have over 100 AB's I use my calculators rating, otherwise I just leave what SOE has set for them. For contact and power, that is 100 AB's vs left or right not both together. And thanks, I'll look into the Young issue tonight when I get home from work.

                      Comment

                      • DeathMetal
                        Rookie
                        • Mar 2008
                        • 168

                        #12
                        Re: Made my own ratings calculator

                        Originally posted by Scott
                        I used the weighted 3 year avg. HR do seem a little high, figuring last year only 4 players had over 36 and in this year I had 8.
                        I could easily adjust the formulas to give lower ratings, but that would affect everybody, even guys like Bautista and Fielder.

                        Comment

                        • Scott
                          Your Go-to TV Expert
                          • Jul 2002
                          • 20028

                          #13
                          Re: Made my own ratings calculator

                          I also did just 1 season simulation, I'll try to do 2 more today.

                          For Durability & Fielding, i've just been using Kritter's formula.

                          I put Elvis Andrus #'s and heres what i got.

                          Durability - 99
                          Arm Str - 80
                          Arm Acc - 50
                          React - 53
                          Fielding - 92

                          Here's Torii Hunter, since he's one of the best fielders out there.
                          Durability - 97
                          Arm Str - 24
                          Arm Acc - 94
                          React - 52
                          Fielding - 99
                          Last edited by Scott; 04-06-2012, 03:41 PM.
                          PSN-Shugarooo
                          Steam-ScottM.816
                          Twitch.tv/Shugarooo
                          Want to follow my Franchises? Join my discord: https://discord.gg/nHbNCWmmGs

                          Comment

                          • Scott
                            Your Go-to TV Expert
                            • Jul 2002
                            • 20028

                            #14
                            Re: Made my own ratings calculator

                            Another Simulation....

                            Andrus - .250, 3 HR, 164 H, 48 RBI
                            Young - .287, 19 HR, 188 H, 85 RBI
                            Hamilton - .223, 28 HR, 124 H, 91 RBI
                            Napoli - .229, 42 HR, 146 H, 112 RBI
                            Beltre - .252, 33 HR, 136 H, 81 RBI
                            Cruz - .272, 31 HR, 143 H, 88 RBI
                            Kinsler - .280, 24 HR, 152 H, 68 RBI
                            Murphy - .304, 15 HR, 147 H, 59 RBI
                            Moreland - .285, 28 HR, 163 H, 86 RBI

                            League Leaders
                            Batting Avg - Gardner - .323
                            Hits - Fielder - 200
                            2B - Ichiro - 45
                            3B - Gardner - 14
                            HR - Gomes - 48 (BIG PROBLEM HERE)---15 players hit more than 36 HRs. Power definitely needs to be reduced.
                            RBIs - Gomes - 122 (18 with over 100+, so clutch may need to be decreased, maybe doing it by RC instead of RISP)

                            And Another....
                            Kinsler - .251, 21 HR, 141 H, 81 RBI
                            Andrus - .291, 3 HR, 194 H, 56 RBI
                            Hamilton - .275, 34 HR, 149 H, 91 RBI
                            Beltre - .263, 32 HR, 144 H, 99 RBI
                            Young - .277, 24 HR, 178 H, 95 RBI
                            Cruz - .261, 36 HR, 137 H, 90 RBI
                            Napoli - .331, 33 HR, 161 H, 93 RBI
                            Murphy - .282, 16 HR, 132 H, 61 RBI
                            Moreland - .240, 24 HR, 103 H, 71 RBI

                            League Leaders
                            BA - Napoli - .331
                            H - J. Weeks - 199
                            2B - Ellsbury - 58 (15 players had 40+ compared to 10 IRL)
                            3B - B. Upton - 12
                            HR - Fielder - 46 (Still had 20 players hit 36+, wasn't counting the NL before)
                            RBI - Fielder - 131 (Had 24 with 100+)
                            Last edited by Scott; 04-06-2012, 05:53 PM.
                            PSN-Shugarooo
                            Steam-ScottM.816
                            Twitch.tv/Shugarooo
                            Want to follow my Franchises? Join my discord: https://discord.gg/nHbNCWmmGs

                            Comment

                            • Thomas7
                              Rookie
                              • Oct 2010
                              • 232

                              #15
                              Re: Made my own ratings calculator

                              Outstanding, Remind me of Dylans ratings calculator(MVP). This may be the Invention everyone been waiting for. Get in touch with Bahnzo . Great job.

                              Comment

                              Working...