# How to Create a Baseball Spreadsheet in Excel

Written by ken burnside
• Share
• Tweet
• Share
• Pin
• Email

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.

Skill level:
Moderately Easy

### Things you need

• Excel 1995 or later
• Baseball statistics reference

## Earned Run Average

1. 1

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.

2. 2

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.

3. 3

For each pitcher, enter the name, the date played, and the other information given by the headers in row 1.

## Batting Average

1. 1

Switch to Sheet 2 in Excel by clicking on the tab at the lower left hand corner of the Excel workbook.

2. 2

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.

3. 3

Enter the following formula in cell E2: "=C2/D2".

4. 4

Copy and paste the formula in cell E2 down through the spreadsheet.

5. 5

Enter the information for all of your players in columns A through D and update the sheet as you go through the season.

#### Tips and warnings

• 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).

### Don't Miss

#### References

• All types
• Articles
• Slideshows
• Videos
##### Sort:
• Most relevant
• Most popular
• Most recent

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.