I need to make a school chess club management system via SeaTable.
The basic tables would include:
1.Players
2. Attendance
3. Games (for generating a club ranking ladder)
4. Schools
5. Events (for Calendar View)
What I would like to find out:
- Is there a way that students/players without SeaTable accounts would be able to access the “app” interface in order to:
a) enter or correct their own player details (without viewing other player information)
b) enter game results (perhaps via a form)
c) is there a way of using script or formulas to perform a basic elo rating calculation in order to assign club elo ratings.
d) to display a ranked view on the basis of (c) that is visible to all players.
Description of ELO from chess blog:
“After each match, the Elo rating of player A is updated according to the following formula R’a = Ra + K* (Sa — Ea ), where R’a represents the new, updated, Elo rating of the player after the match, Ra represents the Elo rating that the player had before the match, Ea denotes the expected outcome of the match and SA is the actual outcome of the match. Variable K denotes a scaling factor that determines how much influence each particular match can have on the overall Elo rating of the player. There are several ways to derive this value. In practice, the factor K has a different value in different levels of competition, for example in different leagues of the competition. A good starting value is K = 32 with which you can start to experiment.”
