Your Federal Quarterly Tax Payments are due April 15th Get Help Now >>

Softball Stats Spreadsheet by sex19776

VIEWS: 1,150 PAGES: 2

Softball Stats Spreadsheet document sample

More Info
									Sent: Tuesday, January 26, 2010 11:25
Subject: Line-up Spread Sheet

All,
Here is the spread sheet I have been using for the last 4 years.
Feel free to pass it along.

Some info:
Player Names
This field is the primary filler.
As you can see I added the number in parenthesis before the player name…cause I was tired of asking “What
This name and number carries over to the batting order and populates the “player pool”

Batting Order
Uses a drop down list.
As the girl is selected she is removed from that list.

Team Name
Duh

Minimum innings:
I added this because game time needs to be fair.
This number can be changed. If the girls does not meet the “minimum inning” it turns her inning played RED.

Now to the good stuff
Positioning.
For each inning, the girl selected will be removed from that innings player pool.
This will give you a birds eye view of who is sitting and where they are playing and making sure the rule “no one
until all others sit out once”.

The Name Lookup.
Also uses a drop down list. It will highlight in Bold Blue where ever that name shows up.

Remember you have to be realistic. If you play 4 don’t schedule 7. I schedule 5 for a contingency plan.
(injury/illness) If it goes to 6 then I start inning 1 again.

Side note. If using Excel 2007 don’t save it as .xlsx it gets quirky. Save as .xls

I also have a Team Stats Sheet that keeps the stats per game and totals overall on the main sheet. Made for 15
games. Let me know if anyone is interested. Its still a work in progress….

Casey Butler
12U Manager (Thunder)
CGFP Saftey Cooridinator
                                                                                                                                        File Name: 747c536d-a867-4dc1-8780-6b286428e44a.xls




                                                                                 Team Name
                     Innings
                      Played                     Batting                Name
Player Names                                     Order                 Lookup             Game Date:             Sunday, September 13, 2009                  3     Minimum Innings Played
  (00) Nicky           1                   1
    (1) Sara           1                   2
  (5) Bianca           0                   3
  (8) Ariana           0                   4
   (9) Kacey           0                   5                                                       Team                      1     2     3         4     5   6        7     8   9      Final
  (10) Hope            0                   6
                                                                                   Away
  (11) Mack            1                   7
    (12) Lexi          1                   8
                                                                                  Home
 (13) Marissa          1                   9
  (17) Tricia          1                  10                    Notes:
    (34) Gia           1                  11
   (37) Kyla           1                  12
  (88) Keely           1                  13



                     Innings
        Position                  1                 2              3                 4                 5                     6                     7                  8                9
     Pitcher ( 1 )           (12) Lexi
    Catcher ( 2 )          (13) Marissa
   1st Base ( 3 )           (88) Keely
  2nd Base ( 4 )            (17) Tricia
   3rd Base ( 5 )             (34) Gia
  Shortstop ( 6 )           (00) Nicky
  Left Field ( 7 )          (11) Mack
Center Field ( 8 )           (37) Kyla
 Right Field ( 9 )            (1) Sara
                                                (00) Nicky     (00) Nicky        (00) Nicky        (00) Nicky            (00) Nicky            (00) Nicky         (00) Nicky       (00) Nicky
                                                  (1) Sara       (1) Sara          (1) Sara          (1) Sara              (1) Sara              (1) Sara           (1) Sara         (1) Sara
                            (5) Bianca          (5) Bianca     (5) Bianca        (5) Bianca        (5) Bianca            (5) Bianca            (5) Bianca         (5) Bianca       (5) Bianca
                            (8) Ariana          (8) Ariana     (8) Ariana        (8) Ariana        (8) Ariana            (8) Ariana            (8) Ariana         (8) Ariana       (8) Ariana
                            (9) Kacey            (9) Kacey      (9) Kacey         (9) Kacey         (9) Kacey             (9) Kacey             (9) Kacey          (9) Kacey        (9) Kacey
  Player




                            (10) Hope           (10) Hope      (10) Hope         (10) Hope         (10) Hope             (10) Hope             (10) Hope          (10) Hope        (10) Hope
   Pool




                                                (11) Mack      (11) Mack         (11) Mack         (11) Mack             (11) Mack             (11) Mack          (11) Mack        (11) Mack
                                                  (12) Lexi      (12) Lexi         (12) Lexi         (12) Lexi             (12) Lexi             (12) Lexi          (12) Lexi        (12) Lexi
                                               (13) Marissa   (13) Marissa      (13) Marissa      (13) Marissa          (13) Marissa          (13) Marissa       (13) Marissa     (13) Marissa
                                                (17) Tricia    (17) Tricia       (17) Tricia       (17) Tricia           (17) Tricia           (17) Tricia        (17) Tricia      (17) Tricia
                                                  (34) Gia       (34) Gia          (34) Gia          (34) Gia              (34) Gia              (34) Gia           (34) Gia         (34) Gia
                                                 (37) Kyla      (37) Kyla         (37) Kyla         (37) Kyla             (37) Kyla             (37) Kyla          (37) Kyla        (37) Kyla
                                                (88) Keely     (88) Keely        (88) Keely        (88) Keely            (88) Keely            (88) Keely         (88) Keely       (88) Keely




  Sheet Name: Game 1                                                                                                                                         Date: 11/14/2010 Time: 6:10 PM

								
To top