Can this be done? (Excel help...) - Fantasy Baseball Cafe 2014

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

Moderator: Baseball Moderators

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.
roninmedia
Major League Manager

Posts: 1647
Joined: 16 Jul 2003
Home Cafe: Baseball

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.

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?
gostanford07
Minor League Mentor

Posts: 546
Joined: 23 Feb 2005
Home Cafe: Baseball
Location: 707... The home of Jonny Gomes and Jason Lane

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?

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.
The Loveable Losers
Hall of Fame Hero

Posts: 7290
Joined: 30 Mar 2005
Home Cafe: Baseball
Location: Cubs Win!!! Cubs Win!!!

=((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.
roninmedia
Major League Manager

Posts: 1647
Joined: 16 Jul 2003
Home Cafe: Baseball

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
J35J
Hall of Fame Hero

Posts: 10464
(Past Year: 620)
Joined: 26 Jan 2004
Home Cafe: Baseball

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...
Big Pimpin
Mod in Retirement

Posts: 13710
(Past Year: 5)
Joined: 20 Apr 2005
Home Cafe: Baseball
Location: Building a metric. And being ignorable and stupid.

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

Jason

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

Posts: 546
Joined: 23 Feb 2005
Home Cafe: Baseball
Location: 707... The home of Jonny Gomes and Jason Lane

roninmedia wrote:=((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?
gostanford07
Minor League Mentor

Posts: 546
Joined: 23 Feb 2005
Home Cafe: Baseball
Location: 707... The home of Jonny Gomes and Jason Lane

Previous

### Who is online

Users browsing this forum: footballisbetter.com, Izenhart, Millhouse, MSNbot Media, NikkiSixx and 11 guests

Forums Articles & Tips Sleepers Rankings Leagues

Today's Games
Wednesday, Apr. 16
(All times are EST, weather icons show forecast for game time)

 • Atlanta at Atlanta(12:35 pm)
 • NY Yankees at NY Yankees(12:35 pm)
 • Chi Cubs at Chi Cubs(1:05 pm)
 • Detroit at Detroit(1:10 pm)
 • Cleveland at Cleveland(3:40 pm)
 • Washington at Miami(7:05 pm)
 • Seattle at Texas(7:05 pm)
 • Kansas City at Houston(7:08 pm)
 • Toronto at Minnesota(7:10 pm)
 • Boston at Chi White Sox(8:05 pm)
 • LA Angels at LA Angels(8:10 pm)
 • Oakland at Oakland(8:10 pm)
 • San Diego at San Diego(8:10 pm)