ATG ratings file

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

Very kind of you Max

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

Solid gold! Thanks Max and barr.

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.

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.)

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

Excellent help, thank you very much, Toady!

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

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?