I've got an Excel spreadsheet that tracks each team's season. I'd like to eliminate as much manual entry as possible, so I want to generate a Team Game Results report that includes team total primary batting statistics for each game. When I try to customize that report, it appears I do not have access to a field with that information. Anyone have any ideas?
BTW, I'm really enjoying replaying the 1974 season. This is the first time I have played out every game instead of just one team's games. I always manage the home team. I enter the R/H/E for each team and it auto-calculates (1) whether it is a win or a loss, (2) the team's W/L record and percentage, (3) the teams total and average RS and RA along with the per game margin. I enter the opponents and starters about a month ahead. I enter the pitcher decisions and a headline after each game is completed. I have to review the standings after each completed day and manually enter each team's rank and GBL.
Here's a picture of the spreadsheet for one of my teams:

