score help
Purpose
Importing Data
Reports
Mathematical Elimination
Steps to Running a Pool
Purpose
The purpose of this program is to enable the running of an NCAA basketball pool with minimal effort by the pool organizer and maximum enjoyment for the players. This program works in conjunction with another program, hoopness entry (Macintosh, Windows, or web-based), to enable each player to make pool selections by pointing and clicking on the teams that the player thinks will win. This eliminates data entry for the pool organizer. The data files from that program are imported into the score program which keeps score throughout the tournament. There are numerous reports and calculations that provide interesting information before and during the tournament.


Importing Data
Each player in the pool creates his/her own entry with the Entry program. That program creates files with the players choices stored in them. Those files are copied into the same directory as the score program. In the SCORE program, the data is imported into the PLAYER.DAT file when you choose "Import Player Data" from the "File" Menu.
Reports
There are several ways to view the player data. All are available under the Display menu:
Status - This is the main and most useful report in the program. It shows the current and possible scores of all players, along with a summary of their selections, their current place in the pool, and whether they have been mathematically eliminated. This report can be printed to a text file, HTML file, or tab-delimited file for electronic distribution (posting on a server, attaching to E-Mail, or even incorporating into an E-Mail message), by choosing "Print to File" from the File menu when it is the currently displayed report.

Choice Listing -The Choice Listing shows in one report what all the selections of all players were. This should be printed and displayed before the first games are played in case there is any dispute later on. The report shows the champion that the player picked on the far left, with the runner up the next team to the right. Next to the right come the other two teams in the final four and so on. This means that the left 16 teams are the teams the player picked to be in the "sweet 16" and the 16 on the right are the teams the player picked to win in the first round, but lose in the second. Any teams that the player picked to lose in the first round are not shown. This format allows one print line to show the complete selections of each player. An abbreviated version of this format (with the left 8 teams) is used on other reports.

Duplicates - This report shows whether or not any two entries are identical.

Choice Distribution - This report shows how many players picked each team to be champion. It further breaks this down by showing how far each team was picked to go. Run this report after all entries are in to show who are the favorites. This report can be printed to a text file, HTML file, or tab-delimited file for electronic distribution (posting on a server, attaching to E-Mail, or even incorporating into an E-Mail message), by choosing "Print to File" from the File menu when it is the currently displayed report.

Possibilities - This report can only be run after results for round two have been entered and a Mathematical Elimination has been run. It will show for the total number of possibilities (for example 32768 just after round two), in how many of those possibilities each entry can finish first or have an entry that receives a prize. Because of possible ties, the sum of the winning possibilities for all players will not necessarily equal the total possibilities. This report can be printed to a text file, HTML file, or tab-delimited file for electronic distribution (posting on a server, attaching to E-Mail, or even incorporating into an E-Mail message), by choosing "Print to File" from the File menu when it is the currently displayed report.

Final Four - This report shows who will win and place under each of the eight possibilities after the final four teams have been determined. This makes the final weekend of the tournament very interesting. This report can be printed to a text file, HTML file, or tab-delimited file for electronic distribution (posting on a server, attaching to E-Mail, or even incorporating into an E-Mail message), by choosing "Print to File" from the File menu when it is the currently displayed report.

Unpaid/Paid - This report shows who has paid their entry fee and who has not. With entries coming in on diskette and via E-mail, the score program helps you keep an accounting of who has paid the fee. Alternatively you can choose not to enter a player until the money has been received.

Player Information - This report shows the players name, along with what they entered in the player information field on the entry form. Set the label for this field (E-Mail Address, or Phone Number, for example) in Pool Parameters.

Results - This is more of a data entry screen than a report. In exactly the same point-and-click manner as the ENTRY program, this screen lets you record who has won games in the tournament. Then the status report will be updated with the current score for all players. If you have set the option to have the tie-breaker be the points score in the final game, then when you will be prompted for this point total when you click on the team that has won. If you need to change the total, then either click on the winning team again (in the final round), or click on the point total displayed above the winner.

Individual Possibilities - This report (which can not be run until round three is complete) shows what is the best case situation for a particular player. First "Mark" the player by typing-in all or part of his/her name under the Mark Player menu item in the Player menu.


Mathematical Elimination
After round two is complete you can run this function to mark on the status report an asterisk for those players who no longer have any chance of winning. Depending on the speed of your computer, this may take a while, especially just after round two. Be prepared for some questions, because very often a person with a high possible score will be eliminated and a person with a lower possible score will still be alive. This is possible because even if the player with the higher possible score attains that score, he may be behind enough other entries to be out of the running. Trust me, this program uses a "brute-force" approach of trying every possibility and the algorithm has been verified over 20 years of use with pool ranging up to 1000 players. If you don't want the questions, dont use the option, but it does make it more interesting for those not eliminated.
Steps to Running a Pool
  1. In the SCORE program choose Start New Pool. This will either remove last year's data or the test data that came with the program. (If you want to save that data, copy the PLAYER.DAT file and/or the entry files in the \IMPORTED sub-directory to another location BEFORE you do this.) Choose Results from the Display menu. Then choose Clear Result Data from the Edit menu. This is either last year's game results or those from the testing you may have been doing.
  2. Watch one of the NCAA selection programs to get a list of the brackets. Make sure you know which regional winners play each other in the final four before you start entering teams.
  3. Start the Score program and select Enter Team Names from the Edit menu. Make sure you enter teams in the correct order. The dialog box shows you the sequential number (teams next to each other play each other in the first round) and also seed number within the region. Each year the finalists from different regions play each other in the final four. In this program, region 1 plays regions 2 and region 3 plays region 4 in the first two games of the final four.
    NOTE: instead of steps 2 and 3, you can download the seedings from hoopness.com.
  4. While still in the Score program, select Edit Pool Parameters from the Edit menu. In here set the entry fee, the point values per round, and the text information to be on the entry form in the entry program. Here you can also enter the names of the regions. The point values per round that seem to work best are 1,2,3,5,8,13. This gives sufficient weight to picking the winner, while still requiring skill in picking the early rounds.
  5. Make sure the entry program is in the same directory as the score program you are running and choose Update Entry from the Edit menu. This will transfer the team and pool parameter data to the entry application. Then distribute the entry program to your pool players (or make it available to them somehow, such as on a public file server). If you are allowing entry via the web, also choose Create HTML Entry Page from the edit menu. This will create an HTML page that can be used in conjunction with a CGI script to accept entries. (See the webreadme.txt file in the webentry directory distributed with the program for more information.)
  6. If you will be receiving files via E-mail, make sure your players understand to just return the entry data files (with extension .NC2) and not the entry application file. This will just clog your E-mail network.
  7. Once files are returned, put them into the same directory as the SCORE program and start the SCORE program. Then choose Import Player Data from the File menu.
  8. Once all files are in, run and print the Choice Listing Report, The Duplicates Report, and the Choice Distribution report. You may want to output this data to a text file for electronic distribution to remote players (use Print to File from the File menu).
  9. Once game results start coming in, enter them on the Results screen, and the Status report will automatically be updated.
  10. To get status information to local players, print and display the Status report. To get information to remote players, choose Print to File from the File menu and either put the file in a public directory on a server, or E-mail to the remote players.
  11. Once round two is over, choose Mathematical Elimination from the Function menu to show which entries can no longer win. Also, run the Possibilities report, to see some statistics on the number of possibilities that each player has to win a prize. . Continue to run both of these after each day of games.
  12. Once the final four has been determined, run and print the Final Four report. To get information to remote players, choose Print to File from the File menu and either put the file in a public directory on a server, or E-mail to the remote players.