"Steve" wrote ...

Sadly not an application for a database due to
the analytics involved, though perhaps a combination if such a thing is
possible ?

Databases are optimized for data storage and retrieval but are
mediocre for analysis work. Excel is an excellent for analysis but is
mediocre when it comes to data storage and retrieval (limited rows per
table, poor data typing, lack of DRI constraints etc).

Using Excel and a 'proper' database product should yield the best of
both. The preferred data access tools for Excel are ADO in VBA code
and MS Query for GUI tools.

Jamie.

--