Extrapolating advanced baseball data from Excel spreadsheet

Hi all,

It's been a while since I've posted. But, with the whole pandemic thing going on, I've decided to take the time to learn more about using Excel to extract and extrapolate data. I'm a huge baseball fan and grew up playing the Strat-O-Matic board game. So, I decided to do a historical replay of MLB in the 80s using that. I have tons of spreadsheets full of game data for the St. Louis Cardinals that I kept by hand, starting in 1980 and ending in 1989. Now, I want to expand the knowledge database by extrapolating new data such as batting average with runners in scoring position, BA with 2 outs and two strikes, etc. I have attached one of the spreadsheets showing one batter's performance for 1989 on one sheet and the situational data I want to extrapolate on the second sheet. Is there a macro or program available that could help me do this?

Thanks in advance.

Stacy