Stats Program Help

Introduction
Names/Addresses Database
Building a New League
Recording the Stats
Entering Players Stats Coming Back from Somewhere Else
Save the Main League & Nightly Files
Open both Main & Nightly Files together
Load a different Weekly file
Automatic Entry of Penalties for Infractions
Sorting the Completed Stats Files
Swap Sorted Team Positions Within a Division
Checking your Completed Stats for Errors
Editing Existing Stats Files
Force a Year to Date Balance
Reset a Players Numbers to 0
View the Players Stats File
View a Single Team's Players
View All Team Names with Player Names
View Team Player Names with Addresses
Change a Team Player Name
Remove a Player from a Team
Swap 2 Players Locations Within a Team
Swap 2 Players Between Teams
View Captains List

Introduction

Create a folder on your "C" drive entitled darts. C:\darts    This is where all of your data that this program creates will be saved.

To Minimize or Maximize the program view click on the Program Listing located in the Task Bar on the bottom of your monitor screen.

To Close the program click on the Sad Face at the left of the screen or click on File/Exit.  Note: if there is unsaved data the program won't let you exit until you have saved this data.  If you truly want to exit without saving the unsaved data follow the prompts to save the data but when you reach the screen that requests the name of the file to save simply click on Cancel and this will tell the program that there is no unsaved data.  You can now exit the program.

This program was written for a screen resolution of 1024 x 768.  For best results set your monitor to that resolution.

This program was written to accommodate a maximum of 40 teams.  5 Divisions of 8 teams.

This program relies heavily on Player Numbers to perform the various name entry and sorting routines therefore the use of the Name/Address Database is essential.

There are 2 types of data files saved for each week's stats.  The 1st file is the cumulative Main League file which contains the running totals for the teams and players for the season.  The 2nd file is the weekly file which includes only what the teams and players did this week.  There is a new Weekly file started each week.  The totals from this Weekly file are added to the totals in the Main League file so that the players Stats Totals are updated from week to week.

This program loads a "Comparison" file which is last season's stats and uses this file to compare each player's current ability with last season's.

When the current date of play and week number are updated it randomly picks a Mystery Out between 2 and 60.

Use the big white box in the upper center of the screen to view instructions and queries and use the Main Data Entry Box just below it to enter and change your data.

Name/Address Database

Open the Name/Address window and enter the names and address data.  (If the name you are entering is for a company, place the company's name in the Last Name text box so that it will be sorted correctly.)

As you add names into this database each person's file number becomes his "Number" that is used in entering his name into the Stats program.  When you enter names into the Stats program using the Player Number method the program searches for his number and adds the name & 01 Average into the proper locations.  This method of entry eliminates misspelling of names at the time the League is being formed.

When a new name is added into the list an 01 average if 40 is assigned unless you manually enter an 01 average.

If you are going to enter the Player Average here you should know that average for a Low Ability player is around 30 and the average for a High Ability player is around 70.  The formula for determining a players 01 average is:
In an 01 game, if the beginning balance of a players turn is 140 or more the turn counts toward the player's 01 average. If the beginning balance of a players turn is 139 or less the turn does not count toward the player's 01 average because with the beginning balance of 170 or less for a players turn, each player who takes a turn should be trying for the OUT SHOT to end the game and not trying for a high score (Refer to your Out Chart).  The "Nightly" Average is equal to the total number of points scored during the match divided by the number of turns in the match as outlined above.  As the season progresses each night's points and turns are added to the previous points and turns and figured with the total points divided by the total turns to give a "To Date" average.

Click on the Save menu item and Save the name.

You can search for a name by entering the name in the text boxes when you first access the Names/Addresses window press the Enter button on your computer.  You can alternatively search for different parameters by using the Search menu item.  These Search functions are not case sensitive.

If you wish to change any Name/Address information for a person simply bring up the person's Name/Address file and type in your changes into the correct text box then click on the Save menu item.

When you click on the "Convert" menu item the Database is saved as Text Files to be loaded into a Word Processor, formatted to your desire then printed.  Each letter of the alphabet is saved into it's own Text File and can be printed on an 8 1/2 x 11 inch sheet.  These name lists can be found at C:\darts\Names A.txt , C:\darts\Names B.txt and so on.  You should make a notebook with all your names and addresses listed for future reference.  This is very handy when entering names into a Tournament using the Database method (Preferred Method).  In your word processor click on File/Page Setup and set the left and right margins to .5 inches.  This will aid in the printing.

Build a League by entering the Team Names

1-Enter Names

Click on File/League/Make up New League.

Enter the Name of the new League, Name of the Season, Qty of Teams, Qty of Divisions and the number of teams in each division.

Enter the Team Names into their respective slots.

Save the new League naming it something like the Season of Play or any unique name you desire.  This Main League file will have a .yer extension and is the main year-to-date file for the League

Before you print a Test Schedule you must alter the "Date" files so that the proper dates for your Season appear on the Schedule.  The files to alter (Using a word processor) are C:\Darts\SCHDL-A.sch and C:\Darts\SCHDL-B.sch.  Do not alter the spacing of the dates just overwrite the existing dates with your new ones.  If you do alter the spacing you can always reload these files and change them if your schedule does not print and align correctly.

When you get the new League built it is advisable to print a schedule and check to see that there not more teams at home on any given night than there are boards to play on.  You can move the team names around to provide various advantages such as a team at home at least every other week.  It will take several schedule printings to refine the team placements within each division so that it is a smooth running League.

2-Build Teams

When you are finished entering Team Names into the new League and you have your Schedule printing the way you want it it is time to enter the Player Names into the Teams.

In the same File/League/Make Up New League window that you used to construct the new League Click on "Team Players" and select whether you wish to enter all the names or just the names for 1 team.  Follow the prompts in the Pop Up window and enter the Player Numbers of the players for each team.  As you enter these Player Numbers you'll see that the name of the player appears in the boxes on the right side of the screen.  If you selected Naming All of the Teams you see that the prompts for the next team up appear as each team is completed.  If you selected Naming 1 Team you'll first be prompted for the League Team # then the player numbers.

After you have entered all the Player Names save the League.

This League is now ready to load into the Main Stats page after you exit this League Building routine.

Recording the Stats

The League Stats are entered from the score sheets as a 2 part problem.  The Main League Stats file is a Year-to-Date file that is an accumulation of the weekly numbers as they are entered each week.  The Weekly files are the data that is entered for each individual week.

1-At the beginning of each New Week load the Main League File and the Comparison file only

When you start each new week you must load the Main League file into the program.  Click on File/Load/Main League Stats.  Select the correct Stats file to load and click OK.  The next screen that pops up requests the name of the "Comparison" File to load.  This file is made up at the end of the previous season and is last season's stats.  It is used by this Stats program to compare each player's current ability with last season's.  When the Main League file is saved this Comparison file name is also saved so that the name is automatically entered into the File Name to Load box and all you have to do is click OK.  Initially, though you must select the correct Comparison file to load.  This loads only the Year to Date Main League Stats file and Comparison file and does not load any Daily files. 

2-Update the Date of Play and Week Number

Click on "Update" or the calendar icon just below.  Enter the new date of play in mm/dd/yy format.  This date you enter here will be the name of the Daily file that will be saved for this date of play.  Next enter the number of the week in the season.  When you have entered these items a random "Mystery Out" will be generated for this week's play.  This "Mystery Out" will be saved with the Daily numbers.

3-Start Entering the Stats

Start by spreading out the 1st set of score sheets, pages 1 thru 4.  Scan the sheets to verify that all of the games have winners and that all of the In Shots are circled.  Count the number of games played for each player on each team.  Write this number next the 1st entry of the name on the score sheets.  When you have all of the games per name counted make sure that they add up to 30 games per team for the 1st & 2nd Divisions or 24 games per team for the 3rd Division and on.  If they don't add up properly it's likely there is an error in your count.  Be aware of teams using the Dummy Rule 12-B for the night.  These teams' game totals should be 3 less because the Dummy probably played in 3 games.

4-Enter the Team Points

Click on Enter/Enter Team Points.  Click on the Team that you wish to enter points for or enter the League Team number.  Enter the Home Team's points scored for the night 1st.  After you have entered the points for the Home team the prompt in the center says to enter a "+" to enter another team's points (Visiting Team) or enter  "A" to advance to the Player Stats.  The program keeps tract of the points you enter for the 2 teams and if they don't total 33 points for the 1st/2nd Division or 27 points for Division 3 & on it notifies you of the discrepancy.  You now have the option of re-entering the points of the team that is wrong.

After you have entered the points for the 2 teams you are prompted to enter "A" to advance to the 1st player of the active team you just entered the points for.

Spread out your Stats Strips directly under the 1st player's name for all of the games he played.  These strips kind of block out the other names and scores and underline and highlight the player you're working on.  

Enter the Total Games played for the night.  Touch the "Enter" key again and the program advances to the Single Games played for the night.  

Enter the Single Games played for the night and touch the "Enter" key again and the program advances to the Cricket Games played for the night.  

Enter the Cricket Games played for the night and touch the "Enter" key again and the program advances to the Cricket Outs for the night.

Note: If a player played in a winning Singles Cricket game he gets 1 point for the win.  If a player played in a winning Multi Player Cricket game he gets .5 points for the win.  So - if he won 1 Singles Cricket game and played in 1 winning Multi Player game he would be credited 1.5 points.  

Enter the number of Cricket Outs for the night and touch the "Enter" key again and the program advances to the 01 Games played for the night.  After you have entered your Cricket Outs remove the Stats Strips from the Cricket Games.  This leaves only the 01 games with strips under them.  It's easier to add the amounts in the 01 games with only the 01 game strips left.

Enter the 01 Games played for the night and touch the "Enter" key again and the program advances to the 01 Outs for the night.  

Enter the 01 Outs for the night and touch the "Enter" key again and the program advances to the Mystery Out pop up.  

If the player hit the Mystery Out enter "yes" and  the Mystery Out list will be adjusted accordingly to show that this player hit the Mystery Out.  If he did not hit the Mystery Out simply touch the "Enter" key and the program will advance to the Hi In pop up.

Check the Hi Ins for the night and see if any of them are higher than the Hi In shown on the pop up.  If a Hi In tonight is higher than that on the pop up enter the new Hi In.  If not simply touch the "Enter" key to advance to the Hi Out pop up.  

Check the high Outs for the night and if any of them are higher than the one shown in the pop up enter the new amount.  If not simply touch the "Enter" key to advance to the Shots/Scores section

Before you start adding the scores made for the night check again to see that the "In Shots" in the DI/DO games are circled.  The reason for this is that the "IN" shots do not count in the players averages so you do not add in the values for the "In Shots".  If they are circled it's easier to see that they are "In Shots" and should be ignored.

Another thing to check again is that the players scores with a beginning balance of 139 or less are not counted.  If the team did not quit scoring when the beginning balance reached 139 or less or they didn't move a space to the right you must draw a very visible line so that you know where in each game to quit adding in the shots.

Start with the upper leftmost 01 game and start entering the points scored per turn for each game.  When you have reached the end of the last 01 game played touch the "Enter" key again and re-add your points from back to front.  If the 2 times of adding the scores don't match you will be prompted to re-add the scores.  Note: This program forces you to have 2 consecutive runs of addition that match before advancing to the "Final Screen"

As you enter shots of 100 or greater the "Great Shots" list is updated automatically.  If you enter 180 the "Perfect Shots" list is updated automatically

When you reach the "Final Screen" it shows the values you have just entered for this player.

While you are on this "Final Screen" you have several options.

If a player had a Hi In or Hi Out of 100 or greater or shot a 9-MARK enter "S" and you will be taken to a screen that requests which item to do.  Follow the prompts.

You'll automatically be returned to the "Final Screen"

From the "Final Screen" enter "N" to advance to the next player on the team and start all over again.

Entering Player Stats coming back from somewhere else

If you break out of the routine described in the items just above and need to come back and resume entering stats click on Enter/Enter New Player Stats and click on the team or enter the League team number then enter the position number on the team.  It will take you to the beginning of the stats routine for this player.

Saving the Main League and Nightly files

There are 2 types of data files saved for each week's stats.  The 1st file is the cumulative Main League file which contains the running totals for the teams and players for the season.  The 2nd file is the Weekly file which includes only what the teams and players did this week.  There is a new Weekly file started each week.  The totals from this Weekly file are added to the totals in the Main League file so that the players Stats Totals are updated from week to week.

Periodically as you are doing the stats you should save both the Main League and the Weekly files.

Click on the little "Save" icon and follow the prompts and save your Main League and Weekly files.

If you wish to save each file individually click on File/Save and select which file to save.

Open the Main League and Weekly files together

When you come back to enter more stats after you have started the week you may click on the "Open" icon and follow the prompts to load the Main League file, the Comparison file and the existing Weekly file.

Do not use this feature if you are starting a new week.  You don't want to load in a Weekly file at this time because one has not been created yet for this week.  In this case use the File/Load/Main League Stats and select which Main League file to open.

Load a different Weekly File

An example of why you might need to do this is when a team didn't get their score sheets for last week in until after you started entering stats for this week.

Before you load in a previous Weekly file make sure you save the current Weekly file because loading in a previous Weekly file overwrites the loaded file.

Click on File/Load/Daily Stats Numbers and follow the prompts to load in the new Nightly file.

After you've finished working on these stats save the Weekly file then re-load the current Weekly file.

Automatic Entry of Penalties for Infractions

Penalties are automatically flagged for too few Games per Night Rule 10-E, too many Games per Night Rule 10-B, too many Singles Games Rule 10-C.

If an infraction occurs while you are entering these values a pop up appears announcing the infraction and asks whether you wish to enter a penalty for it.  If you wish to enter the penalty then follow the prompts.  If the offending team won the illegal game the point value is credited to the opposing team. Follow the prompts requesting the League Team Number of the team to credit with the points. Ref: Rule 11

Checking your completed stats entries for errors & omissions

After you have entered all of the stats for the week you should verify them by using View/Daily Numbers/Check Daily Numbers for Errors function.  This will check for missing team points and that the correct amount of games were played for each team.  If the program sees a discrepancy a pop up will appear describing the error.  You can now verify the error and edit the stats accordingly.  When you have corrected your error run this check again.

Sorting the Completed Stats Files

After you have entered all of the stats for the week and verified them by using View/Daily Numbers/Check Daily Numbers for Errors function and are satisfied that you have done the weeks work successfully, save your files again then click on Sort/Standings.  The program automatically sorts all of the stats and makes text files for the following items that you can load into any word processor or publishing program to print the stats to mail or use in updating the web site.

All of these files are located in the C:\Darts folder.

Mystery Out: a-MstOut.txt
Members/League Average: a-2MEMBR.txt
Division 1 Standings: a-3Div1.txt
Division 2 Standings: a-3Div2.txt
Division 3 Standings: a-3Div3.txt
Division 4 Standings: a-3Div4.txt
High Ins/Outs to date: HiInOut.txt
High Qty of Outs to date: OUTQTY.txt
Great Shots: a-9GTSHT.txt
Perfect Shots: PERFECT.txt
Penalty Statements: 8PNLTY.txt
Division 1 Players Stats: SNGLDIV1.txt
Division 2 Players Stats: SNGLDIV2.txt
Division 3 Players Stats: SNGLDIV3.txt
Division 4 Players Stats: SNGLDIV4.txt

Swap Sorted Team Positions Within a Division

About the only reason you would need to use this function is if there is a tie within a division and the 1st team in the tie position moved ahead of the 2nd team in the tie position compared to last week's standings.  A team cannot pass another team going into a tie.

Click on Edit/Swap Sorted Team Positions Within a Division.  Follow the prompts requesting the Division number, the position number of the 1st team to swap then the position number of the 2nd team to swap.  When you do this the program swaps their positions within the division and resaves the Division's standings file.  Note: If you perform another SORT of the stats after you perform this swap you'll need to re-do the swap routine because the sort routine will place the teams back into their original positions.

Editing Existing Stats Files

If you have made an error or omission while doing the stats and you need to revise your numbers then click on Edit/Revise Nightly Numbers/?? and make your corrections.  Follow the prompts asking for the League Team number then the player on the team.

Using the Edit/ feature you can edit the Great Shots, Perfect Shots and Penalty Statements.  Follow the prompts and make your changes or additions.

Force a Year to Date Balance

If somehow you totally screw up and have made errors that you cannot correct this function allows you to go in and change the Main League's Year to Date balances.  You can be reasonably comfortable that you will never have to use this function but if you do it's available.

Click on Edit/Force a Year to Date Balance and follow the prompts requesting the League team number and the player on the team.  Make your entry then resave the Main League stats file.

Reset a Player's Numbers to 0

An example of this use is: If there are 6 players named on a team and 1 of the players must drop off and another player takes his place you will need to zero the Year to Date and Nightly numbers for the position on the team because the new player will be coming in with zero scores.

Click on Edit/Reset a Player's Numbers to 0 and follow the prompts requesting the League Team number and the position number on the team.

View the Player's Stats

Click on View/Current Stats to view the current Year to Date Main League data.

View a Single Team's Players

Click on Teams/View a Single Team's Players then click on the team or enter the League number of the team and the players on that team will be displayed in their respective players boxes.

View All Team Names with Player Names

Click on Teams/View All Team Names with Player Names.  This is handy when you're looking to see which team a player plays on.

View Team Player Names with Addresses

Click on Teams/View Team Names with Addresses.  In addition to displaying the names and addresses on the screen the program also generates and saves to disk a text file which can be loaded into a word processor, formatted to your desire and printed.  This file can be found at C:\darts\TeamPlayerNameAddress.txt

Change a Team Player Name

If you need to change the name of a player on a team click on Teams/Change a Team Player Name.  Select the team then select the position number on the team.  Enter the Main Name/Address Database number of the new player in the Player Number box and press Enter.  The new name will appear in place of the old name.

Remove a Player from a Team

Make sure you have the latest Weekly File loaded also.  If you need to remove a player and his stats from a team click on Teams/Remove a player from a Team.  Follow the prompts requesting the League Team Number and the position number on the team.  The Player and his stats will be removed and the players below him will be moved up to fill his slot.  

Swap 2 Players Locations Within a Team

Make sure you have the latest Weekly File loaded also.  To swap 2 players locations within a team click on Teams/Swap 2 Players Locations Within a Team and follow the prompts requesting the League Team number and the 2 player positions to swap.  The players names and numbers will be swapped.

Swap 2 Players Between Teams

Make sure you have the latest Weekly File loaded also.  To swap 2 players Between Teams click on Teams/Swap 2 Players Between Teams and follow the prompts requesting the 1st League team number then the player position on that team followed the the request for the 2nd League team number then the player position on that team.  The players names and numbers will by swapped.

View Captains List

To view a list of Captains and their phone numbers and Email addresses click on Teams/View Captains List.  In addition to displaying the list on the screen a text file of the list will be created and saved to disk.  This text file can be loaded into a word processor, formatted to your desire and printed.  It can be found at C:\darts\CaptainsList.txt