How to build a pitching schedule in Excel
1. Click on the Team Reports tab and select your team on the left.
2. Click the View/Print Game Scores button below your team icon.
3. On the report, click File, then Disk, then name the file you are saving.
4. Open Excel. From the Data tab, select the From Text option. Use the file dialog to select the file you saved from the game.
5. Accept the defaults (Next, Next, Finish) on the resulting dialog and start the copy at $A$1 (the top left cell).
6. Erase line 1. Delete line 2. Resize column C (it’s too wide) and double the width of columns D and F.
7. Insert blank lines wherever there is an off day (i.e., if the schedule goes 8/1, 8/2, 8/4, 8/5,… insert a line for 8/3). Type the word off in column D for every inserted line (this will make data entry much easier).
8. On line 1, enter Name in column F, Starts in column G, Used in column H and Remaining in column I.
9. Starting at F2, enter the names of your starting pitchers in column F and the number of allowed starts in column G.
10. In column H2, enter the following: =COUNTIF($D$2:$D$200,F2)
11. Copy cell H2 to all the cells below it on rows that have pitcher names.
12. In column I2, enter the following: =G2-H2
13. Copy cell I2 to all the cells below it on rows that have pitcher names.
14. Position on the cell in column E in the row below the last pitcher you have listed. Use the Freeze Panes option on the View tab to keep your pitchers table visible wherever you scroll in the spreadsheet.