Bang For Your Buck

At Pat's request, I have added a tab in the league spreadsheet displaying each owner's "bang for his buck" -- how many auction dollars we spent per one Player Rater point (as of 6/6). There are about a dozen reasons to be cautious with this dad, but in general it gives us a decent look at who spent their money efficiently at the draft and who has collected some major busts. 

There are three sets of "rankings" that follow. The first shows us dollars spent at the draft per current player rater point. The second shows us the same data, but only for players still with their original owners. (For example, Ols was the 7th-most efficient team based on draft picks only, but the first when considering only his drafted players he still owns.) This set isn't worth much, of course, because if you just recently dropped a terrible player, the awful ratio you owned all season doesn't count against you. The third set shows us the numbers for only the top eight most expensive players purchased by each team at the auction, which I think is probably what Pat wants to see most, considering his high-dollar busts so far. 

After those three sets of rankings, you will see three additional images: the players with the highest ratio of PR value to auction price; the players with the lowest ratio of PR value to auction price, the $10+ players with the highest ratio of PR value to auction price; and the $10+ players with the lowest ratio of PR value to auction price. 

One last note: injuries and negative (or zero) PR values mess all of this up. For example, Maloof drafted (and still owns) Daniel Murphy, who has been on the disabled list all season, for $17. Mil drafted (and still owns) Archie Bradley, who has a 0.00 PR value, for $4. They're right next to one another on the value list for different reasons, but obviously Archie Bradley has been far more valuable to Mil than Daniel Murphy has been for Maloof. Also, players with negative PR values have negative ratios, so $15 Luis Castillo with a -0.09 PR value has a "worse" ratio than $24 Madison Bumgarner with a -1.75 PR value. I'm not a goddamn actuary and I don't care enough to fix it, so just know this: they're all bad down there. 

Anyway, all of this stuff is in the league spreadsheet. I ask that you please not sort any of it unless you know what you're doing in Google Sheets. Thanks. 

Dollars spent at the draft per current player rater point 

1.png

Dollars spent at the draft per current player rater point (only counting players still on their original teams) 

2.png

Dollars spent at the draft per current player rater point (only counting the eight most expensive players drafted by each team) 

3.png

Most valuable players drafted 

4.png

"Least valuable" players drafted (bottom to top) 

6.png

Most valuable players drafted ($10+) 

5.png
Rim