Handy spreadsheet to keep APBA baseball stats

image Over at the Illowa APBA League’s web site, I uploaded an Excel spreadsheet which can be used to keep team’s stats throughout a season.

I debated whether there would be interest in it over here at the APBA Blog.  Walt Taylor however, thinks it will be very useful for his team at OAPBA.  So I’ll link to it in case anyone else is interested in a useful way to keep stats for a league team or a replay.

Some info about the spreadsheet

First, I claim no credit for creating this.  It’s a collaborative effort.  A lot of the work goes John Brandeberry, a manager in the IAL.  The master sheet was created by our commish, Mike Bunch.

I’ve used various forms of this spreadsheet to keep stats for my Twin City Thunderchickens for some five or six years, now.  This is the latest iteration.  I love it.  It is both efficient and customizable.  It has a worksheet for each player and pitcher.  On each player worksheet, stats are entered game-by-game.  Updated season totals are reflected on the master sheet.

For those leagues who impose limits on games, at-bats and innings for players, this spreadsheet has an added feature which is quite handy.  On the master sheet (labeled TEAM NAME), there is a place to put real life stats of your players.  Then for the rest of the season, your “limits left” (including players’ AB/G and IP/G) will be automatically updated for you.  As Walt notes, this would be handy for replays too.

I’ve entered in a few games of stats for a couple players and a pitchers so you get a feel how the whole thing works.

No doubt, you might want to make changes to it.  The spreadsheet it certainly customizable for your league’s (or replay’s) stat categories.

You can download the Excel spreadsheet from the IAL website.

I hope some of you find this useful.

Thomas Nelshoppen

I am an IT consultant by day and an APBA media mogul by night. My passions are baseball (specifically Illini baseball), photography and of course, APBA. I have been fortunate to be part of the basic game Illowa APBA League since 1980 as well as the BBW Boys of Summer APBA League since 2014. I am slogging through a 1966 NL replay and hope to finish before I die.

4 Comments:

  1. I love the spreadsheet as it would make things so much easier, but I love the pencil and paper aspect of keeping stats, it has always been one of my favorite things about APBA baseball!!!!

    • Nothing like sitting in the yard on a warm spring/summer day enjoying a nice cold beverage and doing my stats by hand……….its my escape from the crazy world.

      DOM IN NY

  2. There was once an APBA spreadsheet available in which all carded players were listed by team and alphabetically. Each position player had the result of the dice roll, plus special symbols.

    The pitchers were each rated according to grade and all other symbols.

    I am returning to APBA bone rolling for the first time in nearly 10 years, and I am wondering if anyone knows if it is still available.

    I am at , and sure would like to hear from someone about this

    Thanks

  3. William Michael McQuinn

    Does anyone need their league stats calculated? There are many options I provide….and i love doing them! Please respond here, thanks, Mike

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.