Excel spreadsheet to keep team’s stats

Excel spreadsheet to keep team’s stats

stats I’ve been using this kicka** Excel spreadsheet that Brando originally created for several years now.  Well this year, he updated it so that it updates directly into Mike’s required spreadsheet that he wants us to send in.  It was great before.. now it’s even better. 

Stats are entered in game-by-game for each player and they are totaled on the master sheet.  I’ve entered in some bogus stats for a few of my players just you get a sense how it works. 

It’s pretty customizable if you need more (or less) players.  Give it a try.  Again, I’m giving Brando all the credit here.  He came up with it. 

Here is the spreadsheet.  Try it out.

Here is the Excel 2003 version.

11 Comments

  1. I love this spreadsheet! Thanks for making it available. I’m going to pass it on to our league and see if we can get everyone on board with it. This will help with doing replays as well. Thanks again!

    Walt Taylor
    OAPBA

    Walt Taylor
  2. HI Dom,
    The Team tab on this spreadsheet was all done by Mike Bunch. The only thing I did was added a bunch of tabs set up the stats columns and did a copy, paste special, paste link to the “Team” tab

  3. I’m going to give this spreadsheet a shot this year – I think it will be handy to be able to look at performances by game – I had previously built a spreadsheet that just added each series together…

    Rob
  4. Thanks for sharing! Excellent for game by game entry. I am doing this for my short season project and having one spreadsheet per team. Works great!

    Edward Meek
  5. Is there one of these spreadsheets around that will track career stats. I recall something like that back in the 90s (maybe Norwood?). I’d like to do “career stats” for the replays I’m working on.

    Matthew Runyon

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.