Can this be done? (Excel help...)

[roninmedia]

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]

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.

If it's not too much of a trouble, do you mind elaborating on the "simple modifier" and/or sharing your entire spreadsheet format? Does it automatically update itself witch cumulative stats?

[The Loveable Losers]

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?

You're right on the 4 teams...it's just teams at that rank - 1 multiplied by 0.5. So one team is (1 - 1) * 0.5 = 0. Two teams is (2 - 1) * 0.5 = 0.5. Five teams is (5 - 1) * 0.5 = 2 and so on.

The 13 - x step is not necessary if you take the approach that you took.

[roninmedia]

=((COUNT(B2:B13)+1-RANK(B2;B2:B13;0)-RANK(B2;B2:B13;1))/2)+RANK(B2;B2:B13;1)

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.

[J35J]

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........


Jason

[Big Pimpin]

Yeah I was doing something with arrays first before I just abandoned it and went with the count function and then some nested if statements to adjust for how many teams were tied... Not too difficult once I thought about it for a minute...

And you're right about the rankings, you can do it worst to best and then subtract .5 or 1 or whatever, or do it best to worst, add the .5 or 1 or whatever, and then do 13-whatever. Either way works but it's a useless step...

[gostanford07]

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........


Jason

Oh, I know, I'm definitely aware. I'm just extremely bored during the day and I need something to do lol.

[gostanford07]

=((COUNT(B2:B13)+1-RANK(B2;B2:B13;0)-RANK(B2;B2:B13;1))/2)+RANK(B2;B2:B13;1)

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.

For some reason, when I plug this in, it does not work. When I click 'Ok' on the error message, it highlights that first green value... any ideas? Where did I mess up?