I hope this is the right place.
I'm trying to create a simple model to evaluate Overwatch teams. The equation I want to use divides map win by total maps in a given game then multiplies that by a difficulty rating i give the game. It looks like this:
(1/(N2/(N2+O2))*Q2)
N2=map wins
O2=map losses
Q2=difficulty
The issue I'm having is when a team doesn't win a game in the series so the equation ends up trying to divide 0 by the total games. Excel gives an error from this. The fix i came up with adds 1 game win to every series. That equation looks like this:
(1/((N2+1)/(N2+O2))*Q2)
I'm not happy with this though it seems that teams with a zero win series are punished to heavily. I'm not a math expert at all so just kind of winging it. Thanks for reading I hope it made sense.
I'm trying to create a simple model to evaluate Overwatch teams. The equation I want to use divides map win by total maps in a given game then multiplies that by a difficulty rating i give the game. It looks like this:
(1/(N2/(N2+O2))*Q2)
N2=map wins
O2=map losses
Q2=difficulty
The issue I'm having is when a team doesn't win a game in the series so the equation ends up trying to divide 0 by the total games. Excel gives an error from this. The fix i came up with adds 1 game win to every series. That equation looks like this:
(1/((N2+1)/(N2+O2))*Q2)
I'm not happy with this though it seems that teams with a zero win series are punished to heavily. I'm not a math expert at all so just kind of winging it. Thanks for reading I hope it made sense.