Download
1 / 16
160 likes | 297 Views
SALT LAKE COUNTY SOFTBALL TRAINING Section VII Stats. Training. County Policy, Procedures & Forms Time Sheets & Vouchers Preparation for your league At the field Terminology and Scoring in the Book Finishing up the night Stats Finishing the League Review. Ways Stats Can Be Done.
E N D
SALT LAKE COUNTY SOFTBALL TRAINING Section VII Stats
Training • County Policy, Procedures & Forms • Time Sheets & Vouchers • Preparation for your league • At the field • Terminology and Scoring in the Book • Finishing up the night • Stats • Finishing the League • Review
Ways Stats Can Be Done • Stats can be done by hand • Stats can be done using a computer • The program that is in this presentation is an Excel program part of Microsoft Office
Naming your file • After opening the original stat file • Click on file • Save As • Chose a location on your computer where you will remember where it is • Name the file as follows • Night of Week – Location • For Example "Monday LHM 1“ • Also acceptable are abbreviation such as • Mon V 1 • Mon SS East
Starting the League • Go to the tab titled leading Hitter Data • Fill in the boxes in the Yellow Section
Naming the Tabs for Each Team • Go to the tab titled Team (1) • In Cell A1 where it says "Night of Week - Location- Season - Type of League - Classification" • Type over the word the information it is asking for • For Example "Monday LHM 1 Summer Men's Upper Rec" • Stay on this same tab to enter teams Name • On the tab double click and type in the teams name • Then go to the top of the page and type the teams name in the cell it is asking for the name. • You will type over Team #1 Name • Repeat these instruction for all teams in your league • Now all teams in your league has their own tab in the work book
Entering the names for each player • Go to the Team Tab • Type the players name on the line to the left of PA • If your League is a Coed league in column B list the sex "M" of "F" • If you need more spaces for players then you can unhide. There is room for 35 players however only 20 are showing • Hide all columns that you will not be using • This just makes the sheet look better
Delete all tabs you do not need for your league • You do this by right clicking on the tab and delete • This just makes the file look better
Entering the data during the season • If a team is adding the player • Unhide the rows you need • On line 2 of each teams tab type Yes if the game was a forfeit • On line 3 of each teams tab list who the opponent was for that day • On line 4 of each teams tab type the date in the cell (ex; 5-7 will show May 7) • On each teams tab find the players name and enter the following • PA (plate appearances) • AB (at bats) • H (hits)
Figuring the minimum Plate Appearances (PA) Required • Go to the tab titled leading Hitter Data • Fill in the boxes in the Green Section • This is done by adding the numbers of games played that night to the total already there • The red section will calculate the Min. PA
Filling Out the Leaders page • On the Leader Hitter Link page sort the following • Ave (largest to smallest) • Player (A to Z) • After sorting then filter on the column PA • Filter by using the line "is greater than or equal to" your minimum PA for that week • After sorting highlight the top 30 Coed or top 60 Non Coed that includes the following columns • (player, team, PA, AB, H, and ave)
Filling out the leading hitters list • The following cells are formulas and do not need anything done. • Type in the date of your last game (Example for May 7 use 5/7) • After you have copied from previous slide • right click, paste special , and the values
Stat program in Excel • These instruction are also located in the Stat program for you to reference back to as needed
What do you do when your stats are completed • Your stats are then e-mailed to the SLCO personal that will upload the file into Quick Scores. • For the 2014 season that will be Bob Herlin e-mail address is bobmisc@hotmail.com • E-mail are due by 2:00 PM each Sunday. You may send them sooner if you like.
