An Iconic Fantasy Baseball Community
Moderator: Baseball Moderators
red_foot wrote:I do this is my league. Excel is definitely up to the task. Maybe you did not know that the CBS interface IS Excel, it just looks prettier. Excel is a very sophisticated program and I have never known someone who understands all the different possibilities that it is capable of. What I do know is that there is very little that it cannot do. It's biggest limitations are with compiling huge amounts of data. For that, you should use an actual database. The biggest limitation to Excel is the person using it.
Big Pimpin wrote:The crappy thing is that ties don't count as 3.5 for instance, but as 3. I'll figure out a workaround...
The Loveable Losers wrote:Big Pimpin wrote:The crappy thing is that ties don't count as 3.5 for instance, but as 3. I'll figure out a workaround...
Do a count for each rank (I'd have to look at Excel to figure it out but I'm sure there's a way to count how many of the same rank you have) and deduct 0.5 from the total score for each of that rank above 1.
For instance, let's say we've got team A in sole first place, team B and C tied for second, team D in sole 4th and team E, F and G tied for 5th in a 12 team.
A is ranked 1st = 13 - 1 = 12 points
B/C tied for 2nd = 13 - 2 - 0.5 (two teams same rank) = 10.5 points
D is ranked 4th = 13 - 4 = 9 points
E/F/G tied for 5th = 13 - 5 - 1 (three teams same rank) = 7 points
Users browsing this forum: No registered users and 8 guests