On-Line Manual for 2007-2008

"SSV Captain's TennisSoft©"

Software (version = 2.71)

Introduction:

The SSV Captain’s TennisSoft©, formerly called SSV Captain’s Tennis Team Management System©, is a MicroSoft® Visual Basic® (version 6) program which uses MicroSoft® Excel-XP® Home Edition (some problems occur with Professional Edition) forms to display and print.

The Visual Basic® program is embedded in Macros within Excel®. Because of the functions used within the Visual Basic®, Windows-XP® and Excel-XP® are required. The program may run under earlier versions of Windows® and Excel®, but spurious errors will plague your activities and since some of the programmed functions are not supported, accuracy in calculations cannot be guaranteed.

When loading the SSV Captain’s TennisSoft© you may get an error message (each version of windows Excel gives you a different message) which basically tells you that the file contains macros, would you like to start with the macros enabled or disabled? Respond with “enabled”. You may get this message every time you load unless you change the security level from high to medium or low. To do this, process the following Excel® directions:

Change or verify the security level for macro virus protection:

Step1: In the Tools menu, point to Macro, and then click Security.

Step 2: Click the Security Level tab, and then click the option you want. Medium or Low allows macros to function, High will block all functions programmed into the macros.

What does the SSV Captain’s TennisSoft© do?

The SSV Captain’s TennisSoft© gives you, the captain, the ability to:

Have an electronic worksheet to make team pairings and coordinate with your opponent.
Print the complete weekly player assignment sheet for the bulletin board.
Print a Match Play Log (with player names, round and court assignments) for the competition.
Print all of the Score Sheets (with names, teams, court, and round assignments)
Easily enter and save statistics with one entry of scoring information.
Print formatted Individual Statistics (with consolidated performance and detail listings)
Print formatted Team Statistics for officer evaluation.
Plus team management tools:
View individual Position Play Analysis (Performance at 1^st, 2^nd, 3^rd, 4^th, and Mixed Positions).
View both Men and Women Teaming Play Analysis (Performance as paired with other teammates).

After the scores have been entered from the electronic Match Play Log, one mouse click is required to “move” the data into statistics, where you can easily display each individual’s scores and cumulative statistics with automatic win percentages at the first level and all play.

Installation:

How to put the SSV Captain’s TennisSoft© on your Personal Computer.

Receive the “SSV Captain’s TennisSoft©” file (SSV CTTMS 270.XLS attached to the E-Mail message from RSchuler@Cox.net).
Save the file to “My Documents”
Make a copy of this file with another name so that you have an original (virgin) copy to fall back on if everything goes wrong.

Look around and experiment:

The SSV Captain’s TennisSoft© comes with some bogus data entered to allow you to play around and see what it can do before you enter any real data.
Follow this manual with the bogus data, print some forms and reports, look at the statistics, and understand the results, but do NOT save the file with anything messed up. If something happens and stuff looks really messed up, just exit MS Excel without saving. When you re-enter the application it will be just like it was before you messed it up.

SetUp for your team:

When you feel comfortable with the application you must personalize your system and SAVE it. If you accidentally save a messed up application, just follow the previous directions to install the system (The computer will tell you that the file already exists and ask you if you would like to replace it, answer YES and you will be ready to start again.)
"SetUp" on the Team Form only works once, after the first time it turns itself off.
"SetUp" on the Competition Day Form only works once each week, it is reset after the each finalization.

The “Main Menu” Form:

The Main Menu Form is the “home” page of the system. Click on the bright green areas on the menu to GoTo or Accomplish tasks in the system. All bright Green areas with Hollow / Outlined Characters are Click-type ICONS, on all Forms.

The “Team” and “Competition Day” Forms:

Please do NOT use “CUT” or “MOVE” MS-Excel® functions within this software application. You may use and I highly recommend the use of “COPY” and “PASTE” to save your typing stamina and to ensure the spelling of home player’s names. Your teams’ player names are listed about one page down on your Competition Day Form. Be careful to spell your team members’ names correctly each time you type.
Please make all permanent additions to your team on the Team Form, do not remove any team members from the Team Form if they have played any matches, the names on the Team Form are used by all other forms in this software application. Temporary additions (move ups) are only made on the Competition Day Form (their play is not recorded on the year end reports delivered to EVSTL.

(Rich Schuler, Richard Schuler, and RichSchuler are three different individuals when extracted to statistics).

The Team Membership listed on the Team Form is the only place you should update since all other forms pull name information from this list. Make sure all names are spelled correctly before any finalization is accomplished.
The Competition Date is the date the competition will be played. It is needed for the Weekly Player Assignment sheet, the Match Play Log, and statistics.
The Start Time is the time the competition will be played, the Meet Time is the time the team needs to report to the courts. They are needed only for the Weekly Player Assignment sheet.
Home / Away should be self-explanatory. Please type “Home”, “HOME”, “Away”, or “AWAY” the program will not react well to any other words.
The Home Team is your team, namely: “Sunland Springs Village”. It is needed for the Weekly Player Assignment sheet, the Match Play Log, and the Score Sheets.
The Home Level is your team’s play level (1.5, 2.0, 2.5, 3.0, or 3.5). It is needed for the Weekly Player Assignment sheet, the Match Play Log, and statistics. Always enter the level as a two-digit / one-decimal point number.
The Home Color is your team’s color (if used). Anything you type in will show up on the Weekly Player Assignment sheet and the Match Play Log.
The Home Team Abbreviation is your team abbreviation, namely: “SSV”. It is needed for the Weekly Player Assignment sheet, the Match Play Log, and the Score Sheets.
The Home Team Captain’s name is needed for the Weekly Player Assignment sheet and the Match Play Log.
The Home Team Captain’s phone number is needed only for the Match Play Log.
The Home Team Co-Captain’s name is needed for the Weekly Player Assignment sheet and the Match Play Log.
The Opposing Team is your opposing team. It is needed for the Weekly Player Assignment sheet, the Match Play Log, and the Score Sheets.
The Opposing Level is the opposing team’s play level (1.5, 2.0, 2.5, 3.0, or 3.5). It is needed for the Match Play Log.
The Opposing Color is the opposing team’s color (if used). Anything you type in will show up on the Weekly Player Assignment sheet and the Match Play Log.
The Opposing Team Abbreviation is the opposing team abbreviation. It is needed for the Weekly Player Assignment sheet, the Match Play Log, the Score Sheets, and statistics.
The Opposing Team Captain’s name and phone number are needed for the Match Play Log. Most of the Captains and their phone numbers come up after you enter the Opposing Community, Level, Color and “Set-Up”. If you do not have this information, leave it blank.
The Opposing Team Co-Captain’s name and phone number are needed for the Match Play Log. If you do not have this information, leave it blank.
The Home Team Players should be “COPY”ed from the Team Roster to ensure on-going proper spelling. The roster can be found by pressing “Page Down” while displaying the Input Page.
The Position and Level define whether the match will be Men’s (#1, #2, #3, or #4), Women’s (#1, #2, #3, or #4), or Mixed Doubles.
- (“M” and “1” for Men’s #1, “M” and “2” for Men’s #2, “M” and “3” for Men’s #3, “M” and “4” for Men’s #4, “W” and “1” for Women’s #1, “W” and “2” for Women’s #2, “W” and “3” for Women’s #3, “W” and “4” for Women’s #4, “M” and “D” for Mixed Doubles)
- These fields are required for the Weekly Player Assignment sheet, the Match Play Log, and statistics. Be sure to type correctly. Only the matches with a “1” in the Level field will count for #1 statistics.
The Round, and Court fields are optional fields, if you know which round or on which court the match will be played, enter the number, if you are unsure, then leave it blank and the Match Play Log and Score Sheets will have an empty space on which to write at match time. These fields are only used in the Match Play Log and Score Sheets.
After match play, enter the Set Scores for each team (1^st Set, 2^nd Set, and Tie Breaker, if played) and the system will calculate the Team Score and Final Team Total. (Verify that your Match Play Log from the match is correct.)

PRINTING:

Weekly Player Assignments: (the announcement for the bulletin board)

When you have correctly entered the data required for the Weekly Player Assignments sheet and would like to print, just click the left mouse button on the ”Print Weekly Player Assignments” bright green box (Top Right on Competition Day Form).

Match Play Log:

When you have correctly entered the data required for the Match Play Log and would like to print, just click the left mouse button on the ”Print Match Play Log” bright green box (2nd Right on Competition Day Form).

Score Sheets:

When you have correctly entered the data required for the Score Sheets and would like to print, just click the left mouse button on the ”Print Score Sheets” bright green box (3rd Right on Competition Day Form). A Score Sheet will print for each match on the Competition Day Form.
If you want to print the Extra Large Score Sheets, you can reprint any one by "clicking" the "SSBig" tab and updating the Players' Names, Round, and Court in the GRAY fields, and then printing using the standard MicroSoft® Excel-XP® print function: printing page one, reinserting the printed page into the printer, and printing page two.

Team Statistics Report:

When you have viewed the Team Statistics Report and would like to print, just click the left mouse button on the ”Men” or “Women” bright green box (near the top of the Men’s or Women’s List on the Form).

Individual Statistics Report:

The Date column displays the date of competitions from the latest to the earliest dates.
The Home Player column displays the name of the home team player for which the statistics are generated. Notice the small, black down arrow in the gray box next to the “Home Player” column header. This little arrow is called a “FILTER” and when Left Clicked displays a list of Home Players, Left Click on a player to display only the statistics for that player. Left Clicking “(All)” in the Filter List will return it do displaying all of the statistics. Always reset the Filter List to "ALL" before exiting the program.
The Play Partner column displays the name of the Home Player’s partner for the match.
The Opponents columns display the team and names of the opponent players.
The Posn columns display the Position and Level of the match played. If the match was level one play (“M1” or “W1”) the Level will be highlighted and red with a green background.
The scores for each set are listed with the home team wins highlighted and red with a green background. The Games, Sets, and Matches each with total played, total won, and win percentages are also listed.
Near the top of the page, in the gray, is a small, white box labeled “Player Name”. When you have filtered your statistics to display an individual player, just “highlight” and “copy” the name from the list into the white box to display the calculated total statistics for that player, displayed to the Right, in the Blue area.

To print, just click the Bright Green “Print” box.

Player Evaluation Tools:

Individual Position Play Analysis
Men’s Teaming Play Analysis
- Paired-no 1^st Posn format and Paired-1^st Posn format
Women’s Teaming Play Analysis
- Paired-no 1^st Posn format and Paired-1^st Posn format

Individual Position Play Analysis:

This analysis tool displays how many times each player plays at each level (1^st, 2^nd, 3^rd, 4^th, and Mixed Doubles) and how many times he/she was victorious.
Use this tool to balance each player’s level performance.

Men’s and Women’s Teaming Play Analysis:

These analysis tools display how many times each player plays with each of the other players and how many times he/she was victorious.
Each tool is displayed in two formats: Paired with no 1^st Position and Paired with 1^st Position.
Paired with no 1^st Position lists the plays and wins for each pair of players regardless of whether they played in 1^st position on the team.
Paired with 1^st Position lists the plays and wins for each pair of players, differentiating who played in 1^st position. (the player listed first is in the 1^st position).