Hello All,
I am trying to make something that auto calculates the standings from game results. From what I have found online I have been able to do. The problem is I can't figure out how to do a formula for getting the games back (GB). What I have been able to find is a formula for just wins and loses but that doesn't necessarily work here because I have ties as well. Below is the table and I have manually entered what the games back should be. As you can see, the teams aren't going to be in order.
Team GP W L T % GB
Team 1 9 8 0 1 0.944 0
Team 2 9 4 5 0 0.444 4.5
Team 3 9 6 2 1 0.722 2
Team 4 9 5 4 0 0.555 3.5
Team 5 9 5 3 1 0.611 2.5
Team 6 9 8 0 1 0.944 0
Team 7 9 8 1 0 0.888 0.5
I have found formulas using MAX but I am not sure how to use that.
The formula for games back is GB == ((difference in wins) + (difference in losses)) / 2
Ties are supposed to count as 1/2 win, 1/2 loss.
Thank you in advance, I appreciate your time. (sorry the chart is sloppy, I attached the sheet in case it's easier for you)
Bookmarks