Pool League Project: Post 1 Introduction

Overview

Our pool league generally plays once a week (we miss some weeks for holidays and events).  To this point there have been 9 “seasons”, only the past two or three of which I have been a part.  However, we have the records going back to the beginning.

My intent is to go back to the first session and enter the information into a database, make it easy to enter new information (probably through excel), and then report off of this information both at the relational level and as an analysis services cube.

Pool League Description

In the league, we have had between four and five teams per session with four players per team per match.  It should be noted that players have been known to switch teams between sessions, and to fill in for other players if their team has a “bye” week.  Furthermore, teams can have more than four players in a single session, but only four (or less) will be active in a particular week.

During each match, two teams will play each other with each person competing in 8 games; two games against each of the four opponents.  It is not unheard of for players to have to “double up” if the team does not have all four players so it is possible for one person to play double the normal amount.  Sometimes, although very infrequently, two players will play twice per team.  If a player would have to play all four matches the game is a forfeit.

The league is played as a “handicap” league where the average number of victories per eight games of each player is used to determine the results of which team “should” win and the other team is given a number which is equal to the difference between the two in an effort to help even things out.   If a player has not played at least two games, they have no handicap and the other team is able to remove one of their players handicaps (to this point, it has always been the top handicap).  During each game of the match it is tracked who broke, who won, and whether or not the nine ball was sunk on the break (an automatic win).  At the end of the match, the games won are totaled, along with the handicap, and a winner is decided.  If there is a tie, the team with no handicap wins.  If there was no handicap, the team that won the most rounds (sets of games between opponents) wins.  If the rounds were all ties, or if each team won one round and tied the other two, the game is a tie.

The players handicaps are held in an excel spreadsheet where we keep track of the total number of games played and the total number of victories.  The spreadsheet does not currently have the details to get to these aggregate numbers.

Example

Example: “The Fuglies” beating the mighty “Trololo”.

Example Match Score Sheet: “The Fuglies” beat the mighty “Trololo”.

As you can see, the handicaps meant that this game should have been an even game (15 to 15).  However, as there are 32 games per match, both teams were slated to win less than one half of the games (15 vs 16).  So, even if we both met their handicaps, someone would go over and win (32 – 30 = 2 games over handicaps).  This shows that, in essence, the handicaps are just used to get a relative measure of the skill of each team.  No nines were sunk on the break (would put an asterisk next to the 1 in the sheet if that were the case).

Advertisements
This entry was posted in Data Warehousing, SQL and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s