How to Create a Baseball Spreadsheet in Excel
baseball image by Tomasz Plawski from Fotolia.com
It's been said that baseball statistics, like bikinis, don't cover everything, but they do cover the interesting parts of the sport.
Whether you're coaching or managing a little league team, or tracking the numbers for players in your fantasy baseball league, getting accurate statistics about the players you're watching can be important for a number of reasons. Handling your own statistics is something you can do on your own computer with Excel; every major baseball statistic--and there are more than 70 of them--can be entered in an Excel workbook.
Enter the following headers in row 1: column A: Pitcher's Name. In column B1: Date. In column C, Earned Runs. In Column D: Number of Innings Pitched. In column E: Earned Run Average.
- It's been said that baseball statistics, like bikinis, don't cover everything, but they do cover the interesting parts of the sport.
Enter the following formula in column E2: "=(C2*9)/D2". Once you've entered the requisite information in columns C and D, it will give you an Earned Run Average in column E for that particular pitcher on that particular day. Copy the formula in E2 down through the rest of column E -- in general, you'll want two to three rows per game on your schedule, to handle starting pitchers and relievers.
For each pitcher, enter the name, the date played, and the other information given by the headers in row 1.
Switch to Sheet 2 in Excel by clicking on the tab at the lower left hand corner of the Excel workbook.
Enter the following column headers on sheet 2. Player Name in column A, Date in column B, Number of Hits in Column C, Number of At-Bats in Column D. In Column E, enter the label Batting Average.
- Enter the following formula in column E2: "=(C2*9)/D2".
- Copy the formula in E2 down through the rest of column E -- in general, you'll want two to three rows per game on your schedule, to handle starting pitchers and relievers.
Enter the following formula in cell E2: "=C2/D2".
Copy and paste the formula in cell E2 down through the spreadsheet.
Enter the information for all of your players in columns A through D and update the sheet as you go through the season.
- The example gives Earned Run Average (ERA) and Batting Average (BA), the two most commonly used baseball statistics. There are literally hundreds of statistics that are used to measure pitching, batting averages, defensive stats (See References).
Ken Burnside has been writing freelance since 1990, contributing to publications as diverse as "Pyramid" and "Training & Simulations Journal." A Microsoft MVP in Excel, he holds a Bachelor of Arts in English from the University of Alaska. He won the Origins Award for Attack Vector: Tactical, a board game about space combat.