Power Pros Forum

I could really use some help updating rosters. When editing a player that's not in the game, what's the best way to determine what abilities you should give him?

I don't feel like writing alot but I'll tell you stuff now and do the rest tmrw

ok for young rookie sluggers such as Garett jones, Colby rasmus, and jay Bruce then they should have D contact, B power and slugger
never give a young player A power until they prove that they can hit 30+ honeruns

for players like mccutchen and fowler, they deserve B run speed with good baserunning skills such as agr runner, baserunning 4 and etc

players that you're not sure about when it comes to fielding, just give them D's and C's. Same for speed but if they're a 1B or catcher then usually they deserve E
but outfielders should get D-B run speed

players that hit maybe 1-5 homeruns should have E power usually, never overrate a young player

for young players with power potential such as Sandoval should have 135-138 power so that they can get to B in 1-3 years. Also give them 3 trj and slugger

I'll continute this tommorow because I've had a ton of players that I've edited from a player and added to a team

I'm nearing completion of a master list that features updates (40-man rosters + prospects) for every team.

The trick was creating a universal grading method for each stat/ability. Some were easy. Some were not. In most cases, I exported stats from Fangraphs.com and applied standard deviations to convert the raw data to scale. Fielders for example:

- TRJ = GB/FB and LD ratios.
- CON = composite using AVG, BABIP, Swing%, Contact% and maybe one or two others.
- PWR = composite using ISO and HR per PA.
- SPD = Bill James 4-component speed score + scout grades on the 20-80 scale.
- ARM = Tango's scouting reports by the fans, ARM ratings, assists/chances and some other random stuff.
- FLD = RF/9, RngR, UZR 150, subtracted by speed%.
- ERES = ErrR.

Special Abilities were similar (Aggressive & Patient HTR = pitches per plate appearance + BB/9, Table Setter = AVG + OBP - AVG, etc).

Pitchers were easier. I created a simple scale for CTRL using BB/9 (I'll post it below this post) and stamina is mostly role-dependant, although I used IP/9 and P/IP for a bunch of starters. Pitch types come from PitchFX data and the quality of each pitch comes from the Pitch Value rankings, all of which are available at Fangraphs. Special Abilties for pitchers were also straight-forward (Dr. K = K/9, Groundball P = GB/ratio, Fastball Life = FB movement per Pitch FX + BABIP vs FB's, Spin = Pitch Value of breaking balls + BABIP vs, etc.)

I've been chipping away at this for a while now. I'll make it available to anyone who wants it when it's complete.

Conversion Chart: BB/9 to CTRL

BB/9 Ctrl
0.00 255
0.01 255
0.02 254
0.03 254
0.04 254
0.05 253
0.06 253
0.07 253
0.08 252
0.09 252
0.10 252
0.11 251
0.12 251
0.13 250
0.14 250
0.15 250
0.16 249
0.17 249
0.18 249
0.19 248
0.20 248
0.21 248
0.22 247
0.23 247
0.24 247
0.25 246
0.26 246
0.27 246
0.28 245
0.29 245
0.30 245
0.31 244
0.32 244
0.33 243
0.34 243
0.35 243
0.36 242
0.37 242
0.38 242
0.39 241
0.40 241
0.41 241
0.42 240
0.43 240
0.44 240
0.45 239
0.46 239
0.47 239
0.48 238
0.49 238
0.50 238
0.51 237
0.52 237
0.53 237
0.54 236
0.55 236
0.56 235
0.57 235
0.58 235
0.59 234
0.60 234
0.61 234
0.62 233
0.63 233
0.64 233
0.65 232
0.66 232
0.67 232
0.68 231
0.69 231
0.70 231
0.71 230
0.72 230
0.73 230
0.74 229
0.75 229
0.76 228
0.77 228
0.78 228
0.79 227
0.80 227
0.81 227
0.82 226
0.83 226
0.84 226
0.85 225
0.86 225
0.87 225
0.88 224
0.89 224
0.90 224
0.91 223
0.92 223
0.93 223
0.94 222
0.95 222
0.96 222
0.97 221
0.98 221
0.99 220
1.00 220
1.01 220
1.02 219
1.03 219
1.04 219
1.05 218
1.06 218
1.07 218
1.08 217
1.09 217
1.10 217
1.11 216
1.12 216
1.13 216
1.14 215
1.15 215
1.16 215
1.17 214
1.18 214
1.19 213
1.20 213
1.21 213
1.22 212
1.23 212
1.24 212
1.25 211
1.26 211
1.27 211
1.28 210
1.29 210
1.30 210
1.31 209
1.32 209
1.33 209
1.34 208
1.35 208
1.36 208
1.37 207
1.38 207
1.39 207
1.40 206
1.41 206
1.42 205
1.43 205
1.44 205
1.45 204
1.46 204
1.47 204
1.48 203
1.49 203
1.50 203
1.51 202
1.52 202
1.53 202
1.54 201
1.55 201
1.56 201
1.57 200
1.58 200
1.59 200
1.60 199
1.61 199
1.62 198
1.63 198
1.64 198
1.65 197
1.66 197
1.67 197
1.68 196
1.69 196
1.70 196
1.71 195
1.72 195
1.73 195
1.74 194
1.75 194
1.76 194
1.77 193
1.78 193
1.79 193
1.80 192
1.81 192
1.82 192
1.83 191
1.84 191
1.85 190
1.86 190
1.87 190
1.88 189
1.89 189
1.90 189
1.91 188
1.92 188
1.93 188
1.94 187
1.95 187
1.96 187
1.97 186
1.98 186
1.99 186
2.00 185
2.01 185
2.02 185
2.03 184
2.04 184
2.05 183
2.06 183
2.07 183
2.08 182
2.09 182
2.10 182
2.11 181
2.12 181
2.13 181
2.14 180
2.15 180
2.16 179
2.17 179
2.18 178
2.19 178
2.20 178
2.21 177
2.22 177
2.23 177
2.24 176
2.25 176
2.26 176
2.27 175
2.28 175
2.29 174
2.30 174
2.31 174
2.32 173
2.33 173
2.34 173
2.35 172
2.36 172
2.37 172
2.38 171
2.39 171
2.40 171
2.41 170
2.42 170
2.43 170
2.44 169
2.45 169
2.46 169
2.47 168
2.48 168
2.49 168
2.50 167
2.51 167
2.52 166
2.53 166
2.54 166
2.55 165
2.56 165
2.57 165
2.58 164
2.59 164
2.60 164
2.61 163
2.62 163
2.63 163
2.64 162
2.65 162
2.66 162
2.67 161
2.68 161
2.69 161
2.70 160
2.71 160
2.72 160
2.73 159
2.74 159
2.75 158
2.76 158
2.77 158
2.78 157
2.79 157
2.80 157
2.81 156
2.82 156
2.83 156
2.84 155
2.85 155
2.86 154
2.87 154
2.88 153
2.89 153
2.90 153
2.91 153
2.92 152
2.93 152
2.94 152
2.95 151
2.96 151
2.97 151
2.98 150
2.99 150
3.00 150
3.01 150
3.02 149
3.03 149
3.04 149
3.05 148
3.06 148
3.07 148
3.08 147
3.09 147
3.10 147
3.11 147
3.12 146
3.13 146
3.14 146
3.15 145
3.16 145
3.17 145
3.18 145
3.19 144
3.20 144
3.21 144
3.22 143
3.23 143
3.24 143
3.25 142
3.26 142
3.27 142
3.28 142
3.29 141
3.30 141
3.31 141
3.32 140
3.33 140
3.34 140
3.35 139
3.36 139
3.37 139
3.38 139
3.39 138
3.40 138
3.41 138
3.42 137
3.43 137
3.44 137
3.45 136
3.46 136
3.47 136
3.48 136
3.49 135
3.50 135
3.51 134
3.52 134
3.53 134
3.54 133
3.55 133
3.56 133
3.57 133
3.58 132
3.59 132
3.60 132
3.61 132
3.62 132
3.63 131
3.64 131
3.65 131
3.66 131
3.67 131
3.68 130
3.69 130
3.70 130
3.71 130
3.72 129
3.73 129
3.74 129
3.75 129
3.76 129
3.77 128
3.78 128
3.79 128
3.80 128
3.81 127
3.82 127
3.83 127
3.84 127
3.85 127
3.86 126
3.87 126
3.88 126
3.89 126
3.90 125
3.91 125
3.92 125
3.93 125
3.94 125
3.95 124
3.96 124
3.97 124
3.98 124
3.99 124
4.00 123
4.01 123
4.02 123
4.03 123
4.04 122
4.05 122
4.06 122
4.07 122
4.08 122
4.09 121
4.10 121
4.11 121
4.12 121
4.13 120
4.14 120
4.15 120
4.16 119
4.17 119
4.18 119
4.19 119
4.20 119
4.21 118
4.22 118
4.23 118
4.24 118
4.25 118
4.26 118
4.27 118
4.28 118
4.29 118
4.30 118
4.31 117
4.32 117
4.33 117
4.34 117
4.35 117
4.36 117
4.37 117
4.38 117
4.39 117
4.40 116
4.41 116
4.42 116
4.43 116
4.44 116
4.45 116
4.46 116
4.47 116
4.48 116
4.49 115
4.50 115
4.51 115
4.52 115
4.53 115
4.54 115
4.55 115
4.56 115
4.57 115
4.58 115
4.59 114
4.60 114
4.61 114
4.62 114
4.63 114
4.64 114
4.65 114
4.66 114
4.67 114
4.68 113
4.69 113
4.70 113
4.71 113
4.72 113
4.73 113
4.74 113
4.75 113
4.76 113
4.77 112
4.78 112
4.79 112
4.80 112
4.81 112
4.82 112
4.83 112
4.84 112
4.85 112
4.86 112
4.87 111
4.88 111
4.89 111
4.90 111
4.91 111
4.92 111
4.93 111
4.94 111
4.95 111
4.96 110
4.97 110
4.98 110
4.99 110
5.00 110
5.01 109
5.02 109
5.03 109
5.04 109
5.05 109
5.06 109
5.07 109
5.08 108
5.09 108
5.10 108
5.11 108
5.12 108
5.13 108
5.14 108
5.15 108
5.16 108
5.17 108
5.18 108
5.19 108
5.20 107
5.21 107
5.22 107
5.23 107
5.24 107
5.25 107
5.26 107
5.27 107
5.28 107
5.29 107
5.30 107
5.31 107
5.32 106
5.33 106
5.34 106
5.35 106
5.36 106
5.37 106
5.38 106
5.39 106
5.40 106
5.41 106
5.42 106
5.43 106
5.44 105
5.45 105
5.46 105
5.47 105
5.48 105
5.49 105
5.50 105
5.51 105
5.52 105
5.53 105
5.54 105
5.55 105
5.56 104
5.57 104
5.58 104
5.59 104
5.60 104
5.61 104
5.62 104
5.63 104
5.64 104
5.65 104
5.66 104
5.67 104
5.68 103
5.69 103
5.70 103
5.71 103
5.72 103
5.73 103
5.74 103
5.75 103
5.76 103
5.77 103
5.78 103
5.79 103
5.80 102
5.81 102
5.82 102
5.83 102
5.84 102
5.85 102
5.86 102
5.87 102
5.88 102
5.89 102
5.90 102
5.91 102
5.92 101
5.93 101
5.94 101
5.95 101
5.96 101
5.97 101
5.98 101
5.99 101
6.00 101
6.01 101
6.02 101
6.03 101
6.04 100
6.05 100
6.06 100
6.07 100
6.08 100
6.09 100
6.10 100
6.11 99
6.12 99
6.13 98
6.14 98
6.15 98
6.16 98
6.17 97
6.18 97
6.19 97
6.20 97
6.21 96
6.22 96
6.23 96
6.24 96
6.25 95
6.26 95
6.27 95
6.28 95
6.29 94
6.30 94
6.31 94
6.32 94
6.33 93
6.34 93
6.35 93
6.36 93
6.37 92
6.38 92
6.39 92
6.40 92
6.41 91
6.42 91
6.43 91
6.44 91
6.45 90
6.46 90
6.47 90
6.48 90
6.49 89
6.50 89
6.51 89
6.52 89
6.53 88
6.54 88
6.55 88
6.56 88
6.57 87
6.58 87
6.59 87
6.60 86
6.61 86
6.62 86
6.63 86
6.64 85
6.65 85
6.66 85
6.67 85
6.68 84
6.69 84
6.70 84
6.71 84
6.72 83
6.73 83
6.74 83
6.75 83
6.76 82
6.77 82
6.78 82
6.79 82
6.80 81
6.81 81
6.82 81
6.83 81
6.84 80
6.85 80
6.86 80
6.87 80
6.88 79
6.89 79
6.90 79
6.91 79
6.92 78
6.93 78
6.94 78
6.95 78
6.96 77
6.97 77
6.98 77
6.99 77
7.00 76
7.01 76
7.02 76
7.03 76
7.04 75
7.05 75
7.06 75
7.07 75
7.08 74
7.09 74
7.10 74
7.11 73
7.12 73
7.13 73
7.14 73
7.15 72
7.16 72
7.17 72
7.18 72
7.19 71
7.20 71
7.21 71
7.22 71
7.23 70
7.24 70
7.25 70
7.26 70
7.27 69
7.28 69
7.29 69
7.30 69
7.31 68
7.32 68
7.33 68
7.34 68
7.35 67
7.36 67
7.37 67
7.38 67
7.39 66
7.40 66
7.41 66
7.42 66
7.43 65
7.44 65
7.45 65
7.46 65
7.47 64
7.48 64
7.49 64
7.50 64
7.51 63
7.52 63
7.53 63
7.54 63
7.55 62
7.56 62
7.57 62
7.58 61
7.59 61
7.60 61
7.61 61
7.62 60
7.63 60
7.64 60
7.65 60
7.66 59
7.67 59
7.68 59
7.69 59
7.70 58
7.71 58
7.72 58
7.73 58
7.74 57
7.75 57
7.76 57
7.77 57
7.78 56
7.79 56
7.80 56
7.81 56
7.82 55
7.83 55
7.84 55
7.85 55
7.86 54
7.87 54
7.88 54
7.89 54
7.90 53
7.91 53
7.92 53
7.93 53
7.94 52
7.95 52
7.96 52
7.97 52
7.98 51
7.99 51
8.00 51
8.01 51
8.02 50
8.03 50
8.04 50
8.05 50
8.06 49
8.07 49
8.08 49
8.09 48
8.10 48
8.11 48
8.12 48
8.13 47
8.14 47
8.15 47
8.16 47
8.17 46
8.18 46
8.19 46
8.20 46
8.21 45
8.22 45
8.23 45
8.24 45
8.25 44
8.26 44
8.27 44
8.28 44
8.29 43
8.30 43
8.31 43
8.32 43
8.33 42
8.34 42
8.35 42
8.36 42
8.37 41
8.38 41
8.39 41
8.40 41
8.41 40
8.42 40
8.43 40
8.44 40
8.45 39
8.46 39
8.47 39
8.48 39
8.49 38
8.50 38
8.51 38
8.52 38
8.53 37
8.54 37
8.55 37
8.56 36
8.57 36
8.58 36
8.59 36
8.60 35
8.61 35
8.62 35
8.63 35
8.64 34
8.65 34
8.66 34
8.67 34
8.68 33
8.69 33
8.70 33
8.71 33
8.72 32
8.73 32
8.74 32
8.75 32
8.76 31
8.77 31
8.78 31
8.79 31
8.80 30
8.81 30
8.82 30
8.83 30
8.84 29
8.85 29
8.86 29
8.87 29
8.88 28
8.89 28
8.90 28
8.91 28
8.92 27
8.93 27
8.94 27
8.95 27
8.96 26
8.97 26
8.98 26
8.99 26
9.00 25
9.01 25
9.02 25
9.03 24
9.04 24
9.05 24
9.06 24
9.07 23
9.08 23
9.09 23
9.10 23
9.11 22
9.12 22
9.13 22
9.14 22
9.15 21
9.16 21
9.17 21
9.18 21
9.19 20
9.20 20
9.21 20
9.22 20
9.23 19
9.24 19
9.25 19
9.26 19
9.27 18
9.28 18
9.29 18
9.30 18
9.31 17
9.32 17
9.33 17
9.34 17
9.35 16
9.36 16
9.37 16
9.38 16
9.39 15
9.40 15
9.41 15
9.42 15
9.43 14
9.44 14
9.45 14
9.46 14
9.47 13
9.48 13
9.49 13
9.50 13
9.51 12
9.52 12
9.53 12
9.54 11
9.55 11
9.56 11
9.57 11
9.58 10
9.59 10
9.60 10
9.61 10
9.62 9
9.63 9
9.64 9
9.65 9
9.66 8
9.67 8
9.68 8
9.69 8
9.70 7
9.71 7
9.72 7
9.73 7
9.74 6
9.75 6
9.76 6
9.77 6
9.78 5
9.79 5
9.80 5
9.81 5
9.82 4
9.83 4
9.84 4
9.85 4
9.86 3
9.87 3
9.88 3
9.89 3
9.90 2
9.91 2
9.92 2
9.93 2
9.94 1
9.95 1
9.96 1
9.97 1
9.98 0
9.99 0

Would you happen to be going by this website: http://www.fangraphs.com/

That's the one. I used baseball-reference.com to get specific splits and minor league positional info, mlb.com to get uniform #'s and videos and a handful of other sites for scouting info, but 95-99% of the grade-A meat came from fangraphs.

For these stats, do you go by season stats or career stats?

I used a weighted 3-year average (more emphasis on recent numbers) but used a stright 3-year average for fielding since UZR and Range Runs fluctuate so much from season to season. I also applied the ROS (rest of season) projections at Fangraphs when it was obvious a player would regress to the mean.

How exactly are you doing the math with these stats to figure what a certain ability should be?

Are you familiar with standard deviations and z-scores?

No...

Standard deviations measure the dispersion of data and convert them into units of measurement. Z-scores indicate how many standard deviations an observation is above or below the mean: the standard deviation is the unit of measurement of the z-score.

For example, if you want to calculate player values for your fantasy baseball league, you have to normalize the data so all categories have equal value. Otherwise, you would just be guessing. Which has more value: 90 RBI or 94 R? 31 SB or 16 HR? A .285 AVG over 450 AB's or a .283 AVG over 500 AB's? And what's the difference in value between 147 K, 125 K and 57 K? In essence, you need to turn those apples and oranges and bananas and grapes into equal portions of fruit salad.

Excel makes calculating stdev easy provided you it’s properly executed. There are all sorts of on-line tutorials to teach you how - it's not hard.

That's starting to make sense. I understand the converting data to a unit of measurement which would be required for determining a player's abilities in PP, and making all categories have equal value makes sense, but I'm still not quite understanding how to do it. Can you please explain a little more or give me a link to somewhere that explains how to do it?

OK, let’s do one together.

1) Open a clean Excel spread sheet.

2) Click the following link (http://www.fangraphs.com/leaders.aspx?p ... 09&month=0), click ‘Export to Excel,’ click ‘Open,’ and copy/paste it to your clean Excel sheet.

3) Close the fangrpahs.com window, go back to your excel sheet and delete every column except: Name, RF/9, RngR and UZR/150. You might want to keep the other columns in the future, but let’s keep it clean and simple.

4) Insert two new columns after RF/9, RngR and UZR/150 and name them RF/9z and RF/9x, RngRz and RngRx, 150z and 150x.

So, your excel spread sheet should currently have columns A (Name) through J (150x) and rows 1 (Name) through 20 (Vernon Wells).

5) Highlight cell B21 (under the last RF/9 score), click the arrow next to the AutoSum button (the Sigma symbol), click ‘Average’ and hit Enter.

When you highlight the cell you should see: =AVERAGE(B2:B20). You can also enter the functions manually.

6) Now highlight cell B22 (under RF/9 average), click the arrow next to the AutoSum button, click ‘More Functions,’ find and click STDV, make sure the range is B2:B20, and then click Enter. I enter STDEV manually to avoid the mouse clicking

You should see this in the function window: =STDEV(B2:B20).

7) Copy/paste cells B21 and B22 under the other two columns of data, RngR and UZR/150. Now we have averages and stdevs for all three columns.

8] Highlight cell C2 and enter the following function in the fx window: =SUM(B2-$B$21)/$B$22. In other words, subtract Franklin Gutierrez’s RF/9 score from the RF/9 average, and then divide by the stdev. The $ symbol locks that specific part of the function so we can apply to the other players without having to re-enter the function. So highlight cell C2 again, hold/drag it down to cell C20 and click Enter. Now we have RF/9z scores for all of the players.

9) Highlight all of the data in rows 1 through 20 (not 21 and 22) and click: Data / Sort / Sort by RF/9z / Descending / OK. The players should now be ranked in descending order.

10) Highlight cell D2 and enter the following function in the fx window: =SUM(C2-$C$20). In other words, subtract Adam Jones’ RF/9z score from the lowest RF/9z score. Again, we used the $ symbol so we can subtract everyone’s RF/9z score from the lowest RF/9z score. So highlight cell D2, hold/drag it down to cell D20 and click Enter.

11) There is one last step before we move to RngR. Because we will be sorting again, our previous functions will get screwed up as things move out of order. The easiest way to avoid this is to copy our created data (C2 through D20), paste it to a message board window (seriously – a reply window right here at MLBPP or at fangraphs will do the trick), copy it from the message board window, and paste it back over the top on our excel sheet. Now our numbers are hard instead of the being reliant on the functions which created them.

12) Repeat steps 8 through 11 for RngR and UZR/150.

13) Add two more columns after 150x, and name them Score and FLD. Use 0 decimal places for the FLD column.

14) Highlight cell K2 (Score) and enter the following function: =AVERAGE(D2,G2,J2). Highlight cell K2 and hold/drag it down to K20. In other words, average the three x-scores for each player.

15) Highlight all of the data in rows 1 through 20 (not 21 and 22) and click: Data / Sort / Sort by Score / Descending / OK.

16) Now it’s time to turn these numbers into our FLD ratings. As you can see, Franklin Gutierrez is the highest rated defensive CF by a sizeable margin. He is currently one of the premier defenders in baseball, regardless of position, and probably deserves a 15 rating for his glove, range and reaction time. As the highest rated player, he is out benchmark.

NOTE: The highest rated player will usually be the benchmark when calculating this way. For roto baseball, the benchmark is actually the lowest ranked draftable player at each position, but we aren’t using dollars here, we are using a 15-point scale.

So . . . highlight cell L21 and enter: =SUM(15/K2). K2 is Franklin Gutierrez’s Score and the number 15 represents his FLD rating.

17) Highlight cell L2 and enter the following function: =SUM(K2*$L$21). Highlight cell L2 and hold/drag it down to L20. Bingo!

That’s how you do it. Now, in this example you’ll notice Vernon Wells has a FLD rating of 0. That’s because he was the worst in all three categories in our small sample of players. That won’t happen when you increase your sample to include more players.

The key is deciding who your benchmark is and what his rating should be. For example, maybe you believe Gutierrez has been so good, he is tipping the scales and everyone not named Gutierrez should have higher FLD ratings. No problem. Same process as step 17:

Highlight cell L21 and enter =SUM(14/K3). In other words, K3 is Carlos Gomez’s Score and the number 14 represents his FLD rating. Then in cell L3, enter: =SUM(K3*$L$21). Highlight cell L2 and hold/drag it down to L20. As you can see, most of the CF’s received a 1-point bump to their FLD ratings.

Again, because our sample size was small, guys like Shane Victorino and Jacoby Ellsbury got the shaft. They move up the scale once you increase the sample size to include all OF’s, so don’t use these as your actual ratings. You can go down the list and manually increase/decrease the ratings as you see fit, but with enough innings, this is a pretty accurate indicator of a player’s true defensive ability. Guys like Victorino and Ellsbury are deceiving. They appear to be excellent defenders due to their blazing speed, but their speed is often nullified by below average reaction time, misreads, and poor route running.

If you feel there guys are ranked too low, go ahead and do away with RF/9 and just use the other two. Also, pay attention to the Innings. A crappy 3B may have had a great 150 innings at SS but that doesn't make him a great SS. I suggest you break your players up into 2 or 3 groups based on innings played, and use more conservative ratings for players with fewer innings.

That’s about it. The step-by-step guide makes it appear hard and time consuming, but once you get the hang of it, you can hammer these out in just a few minutes.