Aussiebear
03-21-2008, 08:25 PM
I've been fooling around with a phantom competition where 5 teams play a weekly competition. I have designed a table which shows the draw, and allows for the results to be entered into it. What I'm now chasing is a method that I can apply to make the Competition Points table 'live".
By "live" I mean that as you enter in each weeks results the table updates itself by adjusting the ranking of each team based initially on the points gained and then by the differential of the points scored for the team and the points scored against the team.
That is to say , that if two or more teams are locked on the same number of competition points, their ranking is then adjusted by examing their total points scored for and the total points scored against for the season.
This project is not urgent in any way, more of just fooling around with Excel.
By "live" I mean that as you enter in each weeks results the table updates itself by adjusting the ranking of each team based initially on the points gained and then by the differential of the points scored for the team and the points scored against the team.
That is to say , that if two or more teams are locked on the same number of competition points, their ranking is then adjusted by examing their total points scored for and the total points scored against for the season.
This project is not urgent in any way, more of just fooling around with Excel.