what do you think about this formulas?
BONUS: winner gets 100 points, draw gets 50 points, just same as before.
A: Won points from finished games
B: Lost points from finished games
T: Total number of games (finished or not doesn't matter)
SCORE = BONUS + {CubeRoot of [A * (A+B) * T]} / 5
or; if it isn't possible to use the first formula with excel, here is another option
SCORE = BONUS + {SquareRoot of [A* (A+B)]} / 5
So, even a match where A=0 and B=0 would give a bonus?
I understand your idea, but the formula may would look like this instead:
SCORE = (F/2P) * (BONUS + (CubeRoot of (W * F * 2P)))
or
SCORE = (F/2P) * (BONUS + (SquareRoot of (W * F)))
It's possible to calculate SquareRoots in Excel by using SQRT, but I don't know how to calculate CubeRoots in Excel.
But I believe an even better options may could be these:
SCORE = (F/2P) * (BONUS + (SquareRoot of (W * 2P))
or
SCORE = (F/2P) * (SquareRoot of (W * 2P))
These would work pretty fine.
However, I still belive that the formula SCORES = (F/2P) * (2P + W - L) would work fine and may even better?
Another option that are pretty similar, and also work fine, could be:
SCORES = (F/2P) * (BONUS + 2P + W - L)
All these - highlighted in bold - are pretty similar options.
what do you think about this formulas?
BONUS: winner gets 100 points, draw gets 50 points, just same as before.
A: Won points from finished games
B: Lost points from finished games
T: Total number of games (finished or not doesn't matter)
SCORE = BONUS + {CubeRoot of [A * (A+B) * T]} / 5
or; if it isn't possible to use the first formula with excel, here is another option
SCORE = BONUS + {SquareRoot of [A* (A+B)]} / 5