I am putting together a simple macro to capture data. The idea is to build a database that I can use for analysis.
My question is what is the best layout to make future analysis easier? For example, is it better to store each race in a separate database table or have it all in a single table, a table for each day, etc.
Also, is the layout below ok or is there a better way? (I intend to sort by date time to make it sequential).
![Image](%5Battachment=0%5DUntitled1.png%5B/attachment%5D)
Thanks