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