An Iconic Fantasy Baseball Community
Moderator: Baseball Moderators
roninmedia wrote:I have a spreadsheet format I did for my league that does everything needed for roto, including doing the appropriate averages if teams tie.
You just use rank with a simple modifier to account for ties.
gostanford07 wrote:Interesting, but why do you subtract .5 for two teams and 1 for 3? Am I to assume that if 4 teams were tied i would subtract 1.5?
Also, is it necessary to do the 13-x step?
J35J wrote:Just a question. Every now and then I will see how my league is doing via roto scoring but it really makes no sense in doing this because drafting and playing the game in H2H leagues is quite a bit different than roto so just because you may or may not be doing well in a roto format means nothing because they are 2 different games! Its actually quite misleading........
Replace the red values with the data range you want to be ranked.
Replace the green values with the cell whose value you want to be ranked.
For the blue value, 1 is to rank the highest value to be the best.
For the blue value, 0 is to rank the highest value to be the worst.
Users browsing this forum: No registered users and 5 guests