Volleyball Stat Sheets – Excel Workbook for Volleyball Coaches 22


The Volleyball Stat Sheets Program

by Jayme DeHart
I’m a volleyball coach who’s also a bit of an excel nerd, and when I say, “a bit,” I actually mean, “a huge” excel nerd. It was only a matter of time before I decided to make my own stat program to track the progress of my teams. I wasn’t a fan of the cumulative stat sheets out there, and let’s face it, some of them are really expensive. So I set out to create a Volleyball Stat Sheets Program that I could use, modify, and allows me to spend more time coaching, and less time entering numbers.

volleyball stat sheets
5 Set Matches buy
3 Set Matches buy



The Volleyball Stat Sheet (Excel Workbook) is for those of you who take stats by hand, but input them into your computer later on. Inputting is super easy, and will save you a lot of time. Then the Stat Sheet will automatically update each set of match stats into the Season Summary page, where you can track team and individual progress.


 
 

Keep Stats on:
*Hitting
*Serving
*Passing
*Assists
*Blocks
*Unforced Errors
*Playing Time
*Game Scores
*Average Points scored by each team



The stat sheet will record individual performances, along with tracking team performances based on each match and totally the entire season. If you’d like to purchase the Stat Sheet, you can buy here.
Or, you can watch the tutorial below, it will give you a good idea of how the workbook performs.




5 Set Matches buy
3 Set Matchesbuy



In case you need printable volleyball stat sheets to go along with this stat program, here is a free one. It’s very simple, you record on the sheet and go home and enter your data into your score sheet!
Simple Stat Sheet

Also Available

Printable Volleyball Score Sheets:
volleyball score sheets

 

3 Free Rotation sheets

Scan0017

Subscribe to get 3 free rotation sheets (printable) and other worthwhile coaching resources.

Powered by ConvertKit

Leave a comment

Your email address will not be published. Required fields are marked *

22 thoughts on “Volleyball Stat Sheets – Excel Workbook for Volleyball Coaches

  • Mike Elliott

    Will your 3 set version work for Club volleyball where some matches are 2 sets not best of? I used something last season but can’t find it anymore and they allowed that which is frankly huge.

    • admin Post author

      Should work just fine. I’ll have a look at it tonight when I get in my office and let you know for sure. It wouldn’t calculate a winner, or win loss percentage. I could probably modify it to do win/loss and record sets, not matches if that was something you’re interested in.

  • Jacob Belser

    Hi Jayme. This workbook looks awesome! I’m a relatively new coach looking for a cohesive way to keep stats this coming boys season. Tryouts end today, and I’ll have to make cuts, oh boy. So, I’m definitely interested in purchasing your 3-set workbook. I just had a couple questions first:
    Is it relatively easy to add extra players beyond the 13 that the video shows?
    What’s considered an unforced error re: serve receive? I noticed that your video showed a score of 0 as an UFE. Would you consider both a shanked pass and a pass over the net as 0’s, or as a 0 and a 1, respectively? Is a passing error due to a fantastic serve really unforced?
    Probably most difficult, I’m wondering if you know whether this workbook can be converted into an editable google sheets file. I’d like to have the stats available to be shared and edited through google, and I believe that’s only possible by converting to google sheets. If I leave it in excel I could share it, but then would have to have team managers download, edit on a computer with excel, and reupload, overwriting the original document. I understand that this may be asking a lot, and if it would take fiddling to make it possible, I’d be happy to pay more to get it to work.
    I was happy to come across your website when looking for help in this area. It’s fantastic to see someone who not only loves volleyball and wants to grow the sport, but also has an amazing online presence. Keep it up!

    • Jayme Post author

      Hello! I’m glad you came across my website, and I hope I can help you out. Let me address your questions. First, it is really easy to add additional players after #13. I can add more and create a slightly more customized workbook for you, or I can email you instructions on how to do it. (Actually, maybe we can do both! I’ll fix it before you buy, and then you can add more if you ever need to.)
      As for an unforced error in serve receive. You’ll be able to determine that on your own. At the college level, I’m almost positive that a traditional ace, a shanked pass and an overpass are all zeros. With my teams, I give them a zero if they shank the ball or get aced outright. (Basically it’s a zero if the ball does not stay in play.) If they overpass, I give them a 1 because the ball stayed in play, just on the wrong side of the net. 🙂 With my younger teams, I sometimes just count a zero if they don’t go for the ball. It’s really up to you what you want to track, and how. If you would like me to remove the zeros from the total unforced errors, that would be a pretty easy adjustment. Think about what you’d like and we can make it happen.
      As for an editable google sheets file, I’m going to have to look into that. I think it can probably be done, but I’m not as experience in google sheets. I don’t think the formulas transfer over from excel very well, so I may need to go through each cell and re-input formulas. I will look into this today and I’ll get back to you with my answer as soon as I can.
      Thanks! I’ll get back to you soon.

      • Jacob Belser

        Wow. Thank you thank you! I’m excited to hear if your excel nerd-dom will transfer easily to Google. I guess true neediness is usually won through interest-motivated effort, so I have confidence! I’m very interested in learning more myself, so I’d love any instructions you’re able to provide. I’ll be thinking about the passing statistics, but I think I may decide to be generous to my players (and our own summary page) and reserve the score of 0 for a full shank or non-effort. Ttys.
        PS, if this convo is spamming your page I can cut down on replies

        • admin Post author

          I figured out a solution for Google Docs. I’ll email you to go over a bit more information. Oh, and no, your comments aren’t spammy at all. Websites love comments. 🙂

  • Aimee Ladd

    Hi,
    I am I frosh coach at the local high school. I am interested in your stat sheets, but our program does not use the 3-2-1-0 system. As a collective program we keep stats as if the ball is playable or not. An overpass is considered not playable. How would you suggest adjusting the spreadsheet.

    Aimee

    • admin Post author

      Hello, thank you for your interest. This should be a simple adjustment. I would give a player a 1 if the ball was playable and a 0 if it was not. I wouldn’t make any changes but instead, simply ignore the 3, 2 and % perfect columns.

  • t.murphy

    Hi there, I bought your stat sheets but upon looking right off hand the zero passes aren’t adding up correctly on the summary sheet for girl #3. I haven’t had a chance to look at the others yet, but is this an easy fix?

    • admin Post author

      Thank you for bringing this to my attention. I have emailed you, but for anyone else who needs a fix to this problem, here is what you can do:
      On the Summary page, cell N3 needs to have the following formula:
      =SUM(‘Match 1:Final’!O3)

      You can copy and past that into every cell for each player.

      I am happy to fix the program for anyone who wants me to. Email me at jayme@straightfromdehart.com and I will get it taken care of for you.

      • Mike

        I think they are all that way I noticed player one is wrong as well. I also found out that under the hitting columns player 13 will not allow you to enter data into any of thi cells.

        • admin Post author

          Yes, there was a version that went out which didn’t add up zeros correctly. Use the formula, =Sum(‘Match 1:Final:’!O3) for girl 1’s zeros, and then copy and paste that formula into all the other zero rows.

          As to the hitting columns, I’m not sure why it wouldn’t allow you to enter data unless the sheet is protected. Email me your stat sheet and I can take a look at what is going on. Hopefully you were able to get it sorted out though.

          Thank you,
          Jayme

  • Jan

    I have some matches that are best of 3 sets and some matches that are best of 5. Do I need to purchase both or can the 5 set be adapted for 3 sets?

    • admin Post author

      Hello,
      The only thing I can think of is that you’re entering a 5 match set, in a 3 match workbook? If you can email me the workbook, I will take a look and make sure that no formulas got changed.
      Jayme

  • Sam Villa

    Hi, i purchased the stats sheet. I have 13 players and it is not letting me edit my 13th player. Is there a solution for this problem, could you please help me?

  • Jordan

    Hi Jayme,
    I’m needing to add a few more players to my roster. I have already bought the spreadsheet and was hoping you can just give me instructions on how to do it.

    Thanks!