We all have our Charlie Brown moments, but is there a more thankless job than manager of an amateur baseball or softball team? Yes, there is: scorekeeper of an amateur baseball or softball team. Those who step up deserve a big hand, and not just on the back but in the office, too. SBC's Softball-Baseball Team Calculator is a free Excel-based tool that makes it easy to keep track of individual, team, and league statistics and standings. It can generate box scores for individual games, track and rank batters in 19 categories, and calculate division standings on a game-by-game or overall basis. It can even help you design and generate a team Web site.
We downloaded and extracted SBC's zipped program file and opened its folder, which contained blank and sample Excel files as well as program macros and PDF-based documentation. We clicked the blank spreadsheet, which opened in Excel in a protected view. We clicked Enable Editing and received a popup notification about turning on the macros feature, which opened in a separate Excel page. The template itself handles many pages simultaneously and incorporates a huge selection of worksheet variables covering what looks like every conceivable ballgame situation in a single large table. Pages 1, 2, and 3 were maximized in the view, but we could call up a seemingly unlimited number of pages as needed from an overlapping selection on the left-hand side of the template. We had to reduce the template view to nearly 10 percent of total to take it all in. The entry fields, box scores, and abbreviations are standards that should be familiar to any coach, manager, or scorekeeper (sometimes you wonder). Tiny red triangles appear frequently; hovering the cursor over these opened enlarged entry fields, explanations, and other useful extra space. Otherwise, SBC saves, prints, and edits like any Excel spreadsheet template. The Sample Team template offers plenty of examples, but there's a large PDF-based Help file too.
Softball-Baseball Team Calculator lets hard-pressed officials focus on more important matters, like tracking down players who leave in the middle of games to make beer runs. Like we said, these folks need all the help they can get.