This is the Entry sheet of TeamStatPro. Information here is acquired from the Info sheet. Data entered here gets transferred to the Earnings sheet and the Individuals sheet.

The top area (the Yellow, Red and Blue areas) are TOTALLY AUTOMATIC and dynamic in nature. This area updates itself every time data is entered, changed or updated. This area also remains fixed to the top of your monitor and never scrolls off the screen. The names at the top come from the Info sheet. This is the main area of the program and the only area where you need to enter your score and/or the scores of your team mates.

The area below the "Total Funds Due" line scrolls up and down. The area to the right of  Date column scrolls left and right. The light yellow area is where you enter your scores, points and dues exceptions. You need only enter your individual games and points to generate all available statistics. Starting with version 4.0 you're able to track team member's dues. ALL ELSE IS AUTOMATIC, DYNAMIC and 100% accurate.

Click anywhere on the graphic below or hover over an area below for more information.

This is automatically calculated for you and never scrolls off the screen. Click for details. Enter the number of games this player has paid for substitutions. Click for more information. Enter Total Funds due for bowlers in arrears. Click for more information. Enter individual game/scores here under the bowlers name. Enter individual points here (if used) under the bowlers name. Enter Team points here. Enter individual game/scores here under the bowlers name. These areas are entered for you automatically. These areas are entered for you automatically.

TeamStatPro Data Entry
This area is totally automatic and never scrolls off the screen. Everything above and including the "Individual Points" line is dynamic in nature and changes with every game entered below. Nothing to do here other than view the instant feedback and results. A real pleasure to use and everything you ever need to know is in front of you at all times. This give you instant answers to you and your team mates questions. (back)

 

Data Entry for your HandHeld
Below is a screenshot of the DataEntry.xls sheet (TeamStatPro HandHeld) that gets loaded into your Hand Held Computer and gets syncronized with your PC. This is the same file that runs on both your Desktop and your HandHeld. We support all devices that can read and write MS Excel spreadsheets.

 

Games Credit
This area is totally automatic and never scrolls off the screen. TeamStatPro separates games bowled by substitutions from games bowled by roster team members. TeamStatPro assumes that substitutions do not share in the year end prize fund. Therefore, Roster bowlers are responsible to pay for substitutions and/or for being absent. (back)

 

Total Funds due
Enter the total amount this bowler is in arrears. This is where you track the dues owing for your team and is visible at all times. Do not enter negative values here. If a bowler owes $20.00 then just enter a 20 here. Do nothing here for bowlers present who have paid and for bowlers absent who are accounted for and/or expected to be absent. Keep increasing this value, if required, until he/she has paid up all funds owing.

Zero this value when arrears have been paid. If at the end of the season, someone is in arrears, TeamStatPro will automatically reduce his/her prize fund by this same amount. (back)

Click anywhere on the graphic below or hover over an area below for more information.

Below is what you'll see on the far right side of the spread sheet. All TEAM statistics appear here. Notice the "CLEAR ALL DATA" button (see below for more information) and the "ENTER WEEKLY COMMENTS BELOW" where you're able to enter any type of text that may apply on a weekly basis. Nice to have, if you have a short memory like me. :o)

Clear All Data

The BUTTON shown here is what you use to CLEAR ALL DATA in TeamStatPro version 4. This is no longer requires for version 5. Make sure you know what your doing here because this CAN NOT be undone (see the Warning message above the button). You will be asked to confirm this action and if you click OK, all data (the scores you entered here) will be cleared in preparation for a new season. 

If you wish to keep a record of old data or data from previous years just choose "File" --> "Save As" and choose a new filename. You may also Print this sheet, at any time, if you wish.

After making a backup of your data, you may CLEAR ALL DATA and you'll be ready to begin a new year/season.

NOTE! CLEAR ALL DATA will NOT clear data you entered into the Info sheet, so have no fear when using this button. You won't ever have to "re-enter" any data. We're thinking of you.  :o)

Back to Top

Last Page

 

Web site designed and maintained by Excellent Designs and Associates - www.excellent-designs.com
Copyright © 1995-2009 by Ed DeBlock. All rights reserved.
 

These areas are entered for you automatically. Clear All Data. Click for more information. Enter any and all comments, week by week, you wish to record and save.