SALT LAKE COUNTY
This presentation is the property of its rightful owner.
Sponsored Links
1 / 16

SALT LAKE COUNTY SOFTBALL TRAINING Section VII Stats PowerPoint PPT Presentation


  • 73 Views
  • Uploaded on
  • Presentation posted in: General

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.

Download Presentation

SALT LAKE COUNTY SOFTBALL TRAINING Section VII Stats

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Salt lake county softball training section vii stats

SALT LAKE COUNTY

SOFTBALL TRAINING

Section VII

Stats


Training

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

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

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

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

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

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

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

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

    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

    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

    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

    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

    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 [email protected]

    • E-mail are due by 2:00 PM each Sunday. You may send them sooner if you like.


    Doing your stats long hand

    Doing your stats Long Hand


    Doing your standings long hand

    Doing your standings Long Hand


  • Login