ATG ratings file

Moderator: Palmtana

  • Author
  • Message
Offline

Backfire

  • Posts: 208
  • Joined: Sun May 17, 2020 7:20 pm

Re: ATG ratings file

PostSun Sep 03, 2023 1:45 am

I appreciate this! Not only am I not able to create it myself, but it looks like a lot of fun to explore.
Offline

Main Line Expos

  • Posts: 633
  • Joined: Sat Apr 18, 2020 3:36 pm

Re: ATG ratings file

PostMon Sep 04, 2023 3:26 pm

Very kind of you Max
Offline

roniwas

  • Posts: 61
  • Joined: Sun Jan 10, 2021 11:13 pm

Re: ATG ratings file

PostTue Sep 05, 2023 8:55 am

Max...thanks for all your effort. It's great to have all this info in one place.
Offline

sjudd

  • Posts: 113
  • Joined: Tue Mar 08, 2016 5:01 pm

Re: ATG ratings file

PostWed Sep 06, 2023 6:00 pm

Solid gold! Thanks Max and barr.
Offline

chuckwonup

  • Posts: 136
  • Joined: Fri Aug 24, 2012 5:16 pm

Re: ATG ratings file

PostFri Sep 08, 2023 8:14 am

Thank you Max. Sharing this kind of information for us all makes a community and it is appreciated. I think of myself as a numbers guy and this is like holding the holy grail in your hands. Will keep me up circling around over and over with a scotch.
Offline

Hack Wilson

  • Posts: 1132
  • Joined: Thu Aug 23, 2012 6:16 pm

Re: ATG ratings file

PostFri Sep 08, 2023 8:48 am

Thank you, Max!

How does one use the Excel sheet to rank players based on OPS, RC/27, BR (Batting Runs), and NERP? And against lefties and righties, specifically? Or, am I blind as a squirrel and not seeing it in the Excel sheet? (Not an Excel expert, fyi.)
Offline

Toady

  • Posts: 31
  • Joined: Tue Apr 04, 2023 10:20 am

Re: ATG ratings file

PostFri Sep 08, 2023 2:44 pm

Hack Wilson wrote:Thank you, Max!

How does one use the Excel sheet to rank players based on OPS, RC/27, BR (Batting Runs), and NERP? And against lefties and righties, specifically? Or, am I blind as a squirrel and not seeing it in the Excel sheet? (Not an Excel expert, fyi.)


Hack
I do not use NERP and some of the other things, but this can get you started on OPS. Think of Excel as just a slightly more advanced calculator combined with Algebra. Once you save Max's data file into Excel, do the following:

* Go to Row 1 Column AL and type in OBP vs LH
* Go to Row 2 - Ruth 1923. Go out to Column AL (that would be Cell AL2). Type in that cell: =(SUM(J2:O2))/108
* That should pop up 0.691666, which is his OBP vs LHP
* You can reformat that number by going to the top 'ribbon' and selecting Format - Format Cells - Number - Decimal Places - 3 That should show 0.692. If you want to get fancier, you can go to the Ribbon and under Alignment click the item that is second from the left. That will center 0.692 in the middle of the cell.
* Then go to Cell AM1 and type SLG vs LHP
* In Cell AM2 type: =(J2+(K2*2)+(L2*3)+(M2*4))/(108-N2-O2)
* That should show a result of 1.079 (again, you may want to format it to three digits)
* In Cell AN2 type: =(AL2+AM2)/2
* That is his OPS vs LHP

* For RHP, you can use the same formulas but adjust the columns that have the data. In other words, the singles vs LHP is column J. For RHP it would be column Q. So instead of J2 use Q2, etc.
* So Columns AL, AM and AN are for LHP, and Columns AO, AP and AQ are for RHP

* Once you get Ruth 23 done, highlight Cells AL2 through AQ2 and click ctrl-c. Move down to Cells AL3 through AQ3 and click ctrl-v. Suddenly, Bonds 2001 is done.
* You can do the ctrl-c (which means copy) ctrl-v (paste) thing and then select all columns down to the end and suddenly everybody is done.

* Finally, go out to the far left and highlight the row #2 and move the cursor down to the last batter, highlighting all data. On the Ribbon, select Data - Sort - Select By Column AN and Order - Largest to Smallest
* Now you have all the data sorted by best OPS vs LHP

Hints:
* Until you become more familiar with Excel, you might want to make copies of the workbook at steps along the way. That way you do not have to start over if something messes up (and it will)
* After you originally download Max's data, go to Format - Move or Copy Sheet - Create a Copy and Move to End. Then you have the same data on two separate sheets. You can use one vs LHP and the other vs RHP. You can name the two sheets by clicking the little tab in the lower left and naming each individual sheet.

The other items you inquired about would be the same process just with different formulas.

Hope it helps. I sense a fun, number-filled, weekend for you!

Toady
Offline

Hack Wilson

  • Posts: 1132
  • Joined: Thu Aug 23, 2012 6:16 pm

Re: ATG ratings file

PostFri Sep 08, 2023 6:30 pm

Excellent help, thank you very much, Toady! :D
Offline

DonSutton

  • Posts: 68
  • Joined: Fri Mar 03, 2023 12:53 pm

Re: ATG ratings file

PostFri Sep 08, 2023 9:03 pm

Does anyone have an excel sheet that one can use to track MLB standings? I.E. add the wins and losses each day and it will update the winning pct and games behind?

thanks
Offline

tombar3

  • Posts: 136
  • Joined: Mon Nov 03, 2014 2:33 pm

Re: ATG ratings file

PostSat Sep 09, 2023 3:34 am

OK, I used Max's spreadsheet and calculated 1923 Ruth's OBP vs LHP which was 0.692 using Toady's post on how to do it. However, when I checked on DD using the card reader 1923 Ruth's OBP vs LHP it was 0.740 with no ballpark effects. Why is there a difference? Then I checked on DD Player Pool with Zero Park Effects for 1923 Ruth's OBP vs LHP which was 0.692. Does anyone know why is the DD card reader number is different at 0.740?
PreviousNext

Return to Strat-O-Matic Baseball: All-Time Greats

Who is online

Users browsing this forum: No registered users and 21 guests