Wanderarzt
New Member
- Joined
- Apr 2, 2018
- Messages
- 6
Dear all,
Please advise, is there any way to calculate the following task with excel?
In document https://docs.google.com/spreadsheets/d/18wuUFxV_0p2Cr0G8xA4O2e0qi_lW0K060vM6RnDnCzU/edit?usp=sharing,
There are 3 players.
We are playing pingpong games.
Each day we play two tournirs.
In each tournir there is one, who gets the first place at the end, the other one gets second place and other one gets third place.
When one has equal number of won games with the other player, the final winner will be that one, who has better scored/lost goals balance.
So I totally screwed up. Is there any way to calculate the number of won tournirs using these two criteria? (more games won + better scores balance)
Kindly see the example of table in the documents.
Thank you!
Please advise, is there any way to calculate the following task with excel?
In document https://docs.google.com/spreadsheets/d/18wuUFxV_0p2Cr0G8xA4O2e0qi_lW0K060vM6RnDnCzU/edit?usp=sharing,
There are 3 players.
We are playing pingpong games.
Each day we play two tournirs.
In each tournir there is one, who gets the first place at the end, the other one gets second place and other one gets third place.
When one has equal number of won games with the other player, the final winner will be that one, who has better scored/lost goals balance.
So I totally screwed up. Is there any way to calculate the number of won tournirs using these two criteria? (more games won + better scores balance)
Kindly see the example of table in the documents.
Thank you!
