I have a simple excel spread sheet that we use to score our league:
All players have provided the following information:
Name, Phone #, Email
To set up the match, two players will enter the following information on the screen
Player 1: Name - Player ID - Player Handicap (.1 -4.0)
Player 2: Name - Player ID - Player Handicap(.1-4.0)
From that information, the spread sheet automatically calculates
Total Handicap (Player 1 Handicap + Player 2 Handicap)
Number of games to be played based on the total handicap
Difference between player handicaps ABS (Player 1 Handicap - Player 2 Handicap)
The Players will then enter the following data:
Games won for each player
Balls Earned for each player
Number of turns taken for each player
Number of defensive shots taken by each player
* There are two other items that we track but that do not have an impact on scoring.
TR (Table Run) and BR (Break and Run)
Based on those 4 items, we generate the following data
Win points - which is calculated by number of games won vs number of games played.
Skill points - which is calculated by the balls per turn / player handicap
Handicap Points - which is calculated by games won * handicap difference
The player with the highest total wins the match.
For now, we simply want this on a web page to test.
When the match is done, the player hits submit and the results are emailed to each player and the league operator.
Phase 2 will be to have the scores automatically update the online scoring database.
This will be a separate project.
Phase 3 will be to create and app for both android and ios.