Do some Excel Work

I am making a bowling league excel sheet, I will have 10 - 15 teams. Each team will start of with a rating. - There may be no games on a particular day, or more than 1 game. - The same team will never have more than 1 game per day. The new rating after the game will be determined by the result of the game, and difference of rating between the games. Total points will always be the same i.e. If one team loses 20 points, another team will gain those 20 points. In the image attached, you will see that I go from a chart to a graph, I want to be able to do that. without manually calculating the rating. formula is has not been decided yet, based on my understanding of excel I believe we can change that later. For a filler I will use the following formula delta = Losers_starting_points - Winners_starting_points Points exchanged = f(delta) = 10+(0.1*delta), if tie f(delta)=(0.1*delta) I also want a dashboard to able to run ratings: - I want to be able to manage multiple leagues from this - between 2 opponents, - between certain time frames Please feel free to contact me. Thanks