Ahh the challenges of designing a database.
After much thinking and a quick review of the "Designing a database" book I used to study for my MCDBA, I have come to the realization that my entire suite of excel workbooks can be reduced to 2 tables and a few carefully crafted queries... Added bonuses,
1) new filters can be added as easily as dropping in a new query.
2) once complete, a few minor changes can be made to convert to any game
3) I can backtest by simply selecting certain date ranges
I have to refresh my memory on the use of Access forms to make it feel more like an app than a db. but at least I have a plan now.
look out MUSL ;-)