We currently play a live chess league between national clubs of America, we have:
Team Canada, Team USA, Team Mexico, Team Nicaragua, Costa Rica Live Chess, Team Puerto Rico, Team Dominican Republic, Team Venezuela, Team Peru, Ecuador Live Chess, Team Colombia, Argentina Live Chess, Chile Live Chess and Team Brazil Live. Our league is called Live Chess Pan-American League (LCPAL).
The tournament format is a double robin hood system (all against all - twice), as in football, roundtrip. Per week each team plays 1 match, in total I have 7 matchs per week, for a duration of 8 1/2 months. Blitz mode 5/2, but next year we will add another time control (10/2 or 3/2, maybe).
So, to define the teams' places at the end of each week, we do it in the following order:
1.- Sum of points
2.- If there is a tie of points, we use the Tie Break SB (Sonneborn-Berger) allots each player the total score of the players he defeated, half the score of those he tie, and nothing for the games he lost.
3.- Difference of total points: Points won - points lost, in all its games.
Currently all calculations are made with excel formulas. This is an image of the weekly score (example):
My wish list would be:
1.- Put the id of the match (every week) and that the system generates the score of the teams.
2.- Do a recalculation of the points of each game, for the closed accounts.
3.- Generate the final report.
But, progress is made step by step, so any help in this process would be welcome.