| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
1 | Player A Current Elo | 1050 | You can adjust these green values to suit your scenario | player indices | 1 | |||
2 | Player B Current Elo | 1750 | 2 | |||||
3 | Side A win count | 50 | ||||||
4 | Side B win count | 1 | Elo K Factor | |||||
5 | winner | 2 | 32 | |||||
6 | ||||||||
7 | Players | Current Elo | Expected Win | Player Based Elo | ||||
8 | Player A | 1050 | 1.7% | 1049 | ||||
9 | Player B | 1750 | 98.3% | 1751 | ||||
10 | ||||||||
11 | Arenas | Wins | Expected Win | |||||
12 | Side A | 50 | 98.0% | |||||
13 | Side B | 1 | 2.0% | |||||
14 | ||||||||
15 | Combined Expected Score | Expected Player Win | Expected Arena Win | Combined Expected Win | ||||
16 | Player A + Arena | 1.7% | 98.0% | 47.1% | ||||
17 | Player B + Arena | 98.3% | 2.0% | 52.9% | ||||
18 | ||||||||
19 | Players And Arenas Outcome | Current Elo | Combined Expected Win | New Final Elo | ||||
20 | Player A + Arena | 1050 | 47.1% | 1034.94 | ||||
21 | Player B + Arena | 1750 | 52.9% | 1765.06 | ||||
22 | ||||||||
23 | ||||||||
24 | ||||||||
25 | how to calculate elo | http://en.wikipedia.org/wiki/Elo_rating_system#Mathematical_details | ||||||
26 | how to combine probabilities: | http://www.paulgraham.com/naivebayes.html | ||||||
27 | multiple elo calc (not used in this excel) | http://elo.divergentinformatics.com/ | ||||||