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 ;-)