Wednesday, January 23, 2019

Data Development: the Spreadsheet

As I move toward the start of the writing process in roughly one week for the spring issue (Vol. 15, No. 1) of the American Association Almanac, I'm wrapping up the work on the eight principal databases I've been constructing since the end of November. They concern the leading triples hitters for each team of the original American Association from 1902 to 1962. Each spreadsheet is designed to make automatic calculations for the percentages I'm most interested easier to perform. My intention in posting this blog was to post an example of one whole file. At this point I'm not sure I'll be able to do that, however, I will offer a sample at the very least. Each spreadsheet covers the career record for each team's top triple hitters. This could include those who led over time or who was among the team's top three producers during a given season. No less than 110 players are listed in any one team's spreadsheet. The totals for each player are derived and sorted so each category can be ranked for the leading players. What is especially valuable is the data for multi-team players; a multi-team player, also known as a split-season player, spent his time with more than one team. In this record the data has been gleaned from the box scores in order to produce the record for just the team he's listed with as being a leading producer. The time it takes to perform such an exercise can be excessive; while at other times it can take only an hour or two. Regardless, the records for the American Association's leading triples hitters has never been published. It serves the baseball research community as a testament to thorough and creative research while offering fans of regional baseball history a fundamental look a the leading players from a bygone era.

Sample 1: The Indianapolis Indians, page 1

While this blogsite does not permit me to publish whole files, anyone who is interested in obtaining a copy of a particular data file can write me with their request. Send an email to
with your request. Thank you!

The American Association Playoffs, 1942-1946

This issue of the American Association Almanac (Vol. 14, No. 2) was published in October 2018. Its primary focus is game-by-game descriptions of the American Association postseason which took place on two levels: a four-team playoff followed by a match-up between the winners of those series. Having originated with the Fall 2017 issue covering the seasons 1932-1941, this series will culminate with the playoffs of the 1962 season. The American Association Almanac is published twice annually and distributed to paid subscribers; more info below.

Vital Statistics for Vol. 14, No. 2:

Format: 5.5 x 8.5" paper; staple bound
Type: New Times Roman, 12 pt.
Number of Words: 31,897
Number of Pages: 56
Content inside back cover: Yes
Graphics: Multiple
Tables: 1
Organization: Chronological; each season includes two sections, one for game accounts and one entitled "New and Noteworthy" in which a statistical presentation is provided
Availability: By Subscription ($24/yr; $42 two yrs; or as single issue $15 ppd)
Publication Date: Sept. 27, 2018

Copies Available.

Front Cover

 Table of Contents

Sample Page 15

Sample Pages 28-29

Photo Sample

Pitcher Tom Sunkel celebrating his no-hitter with manager
Ray Blades (L) and catcher George Savino (R).

Subscription Information

Subscribing to the American Association Almanac is easy! Send a check payable to:

Rex Hamann
14201 Crosstown Blvd. NW
Andover, MN   55304-3311

You can also pay using Paypal.
Simply direct the payment to this email address:


1 year (two issues) - $24.00

2 years (four issues) - $42.00

Institutions (one year) -  $60.00

Lifetime Subscription (min. 10 years): $200.00

Please direct all questions, inquiries or comments to:

Rex Hamann, editor and publisher
14201 Crosstown Blvd. NW
Andover, MN   55304-3311

or by email at

Copies of Vol. 14, No. 2 are available and make a great gift.

The content of the Almanac is produced entirely by Rex Hamann

There are no advertisements in the Almanac, with rare exception

Back issues are available as a complete set (terms to be discussed) or individually

Typical publication dates are April 1 and October 1

posted January 23, 2019