SpreadSheetWarriors

Player Power Rankings with OPR

Written by @RoscoeMyrickTID

For methodology scroll past the Player Power Rankings Graphic.

Welcome to Spreadsheet Warriors.  This is an attempt to be a semi-objective player power rankings. Each week, one of us will watch every moment of the game and assign grades for penetration and possession.  The scale is [-2] [0] [2].  Scores of -2 or 2, are reserved for definite and obvious actions.  Example: Asprilla’s shot against Dallas at home is without a doubt, universally obvious, thus would rate 2.  Grades of 1 and -1 are reserved for more contextually dubious actions.  0 is even.

Penetration: defined as any direct and significant advancement into enemy territory.  0 being even in this scale, points are not rewarded for maintenance passes.

Possession: defined as losing or maintaining possession in extraordinary circumstances.  0 being even in this scale, points are not rewarded for simply having the ball.

Actions around the ball are divided into three categories: Attack, Defense, and Possession.

Attack: Finishing, Attacking Pass, Attacking Run, Crossing, Distribution.

Defense: Clearance, Defensive Positioning, One on One Defending, Fouls, Aerial Wins.

Possession: Unforced Turnover, Keeping Possession Under Duress, Touch.

IMPACT SCORE & EFFICIENCY SCORE

Impact: The total of negative and positive actions.

Efficiency: The total of negative and positive actions divided by total # of actions.  Perfect = 1.

VS. SAN JOSE

Player Impact ScoreEfficiency Score+ Attacking- Attacking+ Defense-Defense+Possession- Possession
Jermaine Taylor2.17106500
Jack McInerney61600000
Ned Grabavoy41300000
Nat Borchers12.672013201
Fanendo Adi12.603320111
Diego Chara9.60506211
Alvas Powell8.332211531
Diego Valeri9.261660166
Lucas Melano2.20410122
Darlington Nagbe5.19666045
Dairon Asprilla-1-.14131011
Zarek Valentin-7-.47133701

2016

Player Impact ScoreEfficiency Score+ Attacking- Attacking+ Defense-Defense+Possession- Possession
Fanendo Adi22.608430194
Diego Valeri22.513070177
Diego Chara21.6811014411
Alvas Powell16.39522264-7
Lucas Melano13.56904152
Nat Borchers12.342018702
Liam Ridgewell10.770012200
Jack McInerney61600000
Darlington Nagbe6.29776246
Jermaine Taylor6.314112601
Ned Grabavoy41301000
Zarek Valetin-7-.47133701
Dairon Asprilla-9-.25493717

Game Scores

GameImpact ScoreEfficiency Score+ Attacking- Attacking+ Defense-Defense+Possession- Possession
Match 2 Vs. San Jose61.37502449232819
Match 1 vs. Columbus61.44401150151319
Match 3 vs. Real Salt Lake39.25603423121513
Match 4 vs. Orlando City-32-.17393921361936
Match 5 vs. LA Galaxy20.13292045321416
Match 6 vs. Dallas-4-.01674341562437
Match 7 vs. San Jose42.18662955482022
Match 8 vs. New England32.14402363432429
To Top