Baseball Results: Master Player List & Dynamic Stats

Hello,

I am working a project to keep track of my own baseball statistics for this season. My goal is that every day I am going to paste the results for each player from the previous day's game to the bottom of my running results list and have that information update a master list of stats for each player. Here are the bumps I am running into in creating that master list and am looking at a way to solve them:

1. Multiple players with the same name (playing on different teams - thankfully there aren't any players with the same name on the same team currently).
2. Multiple results for the same players (for different day's games).
3. Different criteria for stats I am creating (average hits in last 30 games, average at bats in last 10 games, etc).
4. Not every player plays every day.

The first issue is pretty straight forward - I would just add a column and use the CONCATENATE formula to ensure players with the same name are treated separately. EDIT: Unique ID for each player created.

The other issues are where I'm running into my roadblock. How do I:

1. Create a master list of unique players that...
2. ...calculates statistics based on the most recent "n" games played by each individual player in my running results list?

It would be simple to do this if I were interested in only the most recent "n" days, but that wouldn't account for differing number of games played by each player within a given date range.

Per Ali's request, I have removed my original attachment and provided a clean copy in the below reply. Thanks!

Any suggestions? Thank you in advance!

Best regards,
Eric