Baseball On base, slugging and OPS Calculator
Bring advanced statistics to your baseball program at a very affordable cost. This calculator keeps game and season totals for your individual players and team, and will keep up to 40 games in a season. Reuse this program from year to year, with nothing more to buy, ever. Use it at all levels of your program. You can use it with any device that runs Excel, and it updates in real time. Coaches, parents, or managers can keep up to the second statistics during the game.
For programs looking to get into sabermetrics measures for their players, this is a very affordable, easy and accurate way to get started. Support is also available for anyone who purchases this system via email at firstname.lastname@example.org
Look for this and other sports products from me at Advanced Financial and Sports Statistical Solutions
Instructions for Baseball OPS Calculator
1. Under Game 1 tab, enter player numbers starting in G3, just to the right of the red player codes. If you want to keep season statistics, each player will need to be in the same position for each game.
2. For each at bat during the game, starting in boxes A2 through D2, enter the player code, whether or not they reached base (either a 0 or a 1), the slugging percentage for the at bat (0 for non hit, 1 for single, 2 for double, 3 for triple, 4 for home run). Then enter an r for a right handed pitcher or a l for a left handed pitcher.
3. Skip (enter nothing at all) for an at bat where a batter reaches on an error.
4. After you enter the information, all of the relevant columns will automatically update from H3 to AB23 on both the game and season pages.
5. Change the name of each game page on spreadsheet to name opponent or date of game.
6. You can save or open this file as an xlsx file if you use Microsoft Excel, and all data will update correctly.
7. You can use this for up to 40 games in a season, and may use for multiple seasons. There is nothing more to buy ever.
Explanation of Statistics
1. OB%- On base percentage- number of times on base divided by number of plate appearances, with reached on error not counting
2. Slugging%- Number of bases achieved through hits divided by at bats
3. OPS- On base percentage plus slugging percentage
4. Spread- The difference between your performance versus right or left handed pitching. A positive number indicates you are better against right handed pitching, a negative number is better against left handed pitching. The more distance from zero, the bigger the difference between your right or left handed performance.