Quote:
Originally Posted by allenciox
I don't have a spreadsheet, as I did all the calculations using a software product (SAS). However, I do have the equation that you can put into any spreadsheet (I use it in the spreadsheet where I manage my team)... it assumes that CON is in column G, GAP in column H, POW in column I, and I in column J:
=(0.3*MAX(J27-50;0)+0.15*MAX(I27-50;0)+0.45*MAX(G27-50;0)+0.1*MAX(H27-50))-0.9*MAX(0;50-G27)-0.14*MAX(0;50-J27)-0.09*MAX(0;50-I27)-0.15*MAX(0;50-H27)
This gives a number: A player that had all 50s would have 0, one that had all values equal to 60 (or weighted average of 60) would result in a value of 10, a weighted average of 70 would be 20, etc.
Here is a copy of my ODS spreadsheet with my players (I have put some of the lefty/righty splits in here for platooning options). The column estOFF uses that equation above.
Code:
Batters H Val pred CON GAP POW EYE estOFF
Smoky Burgess 1954 L 86 5555 88 91 32 53.0 20.48
vR 91 96 32 56.0 23.23
vL 79 77 31 45.0 13.34
Roger Bresnahan peak R 76 475 56 67 16 81 10.64
vL 57 68 16 82 11.49
Daniel Murphy 2016 L 79 1500 80 88 70 29 17.36
vL 69 74 59 24 8.66
Phil Cavarreta 1945 L 72 251 80 82 26 63 18.44
vR 82 86 27 65 20.43
Hanley Ramirez 2009 R 87 2399 79 67 67 42 16.18
vR 79 65 63 39 14.96
Cecil Travis 1941 L 85 83 80 26 41 14.43
vR 86 84 27 43 16.55
Steve Sax 1986 R 67 200 82 74 24 47 14.04
vL 90 87 28 51 20.02
Red Rolfe 1939 L 79 999 70 76 45 57 13.25
vR 72 79 47 54 13.73
vL 61 69 38 67 10.87
Dick Groat 1960 R 78 1600 77 60 10 36 7.59
vR 75 57 11 34 6.20
vL 85 70 9 42 12.94
Edgar Renteria 2003 R 81 1519 78 71 41 49 13.75
vL 80 83 48 57 18.72
Augie Galan 1943 S 78 444 60 60 38 72 11.02
vR 62 63 40 73 12.70
vL 53 51 32 69 5.53
Curt Flood 1963 R 76 1200 72 76 20 35 7.70
vL 81 90 23 41 14.26
vR 70 72 19 33 6.03
Harry Walker 1947 L 76 800 85 82 7 53 15.98
vL 76 69 6 58 12.04
Babe Herman 1932 L 77 600 69 76 56 54 13.25
vL 60 74 52 45 6.50
|
Thank you for this! I was able to incorporate the formula into the master card list and found that perfect Babe Ruth is the king of kings! Now I will use the spreadsheet to find bargains.