EXCEL DATABASE EXPERTS - DATABASE ADVICE NEEDED - BEST SOLUTION TO EXISTING SET UP

Job ID: 34412194

Budget: £10 – £11 GBP

I am after an Excel Database Expert required.

I analyse horse races every day and use a spreadsheet that contains 125k rows of data from the past 12 months. I update this every day.

What I need is an excel database expert to have a quick look at my set up and give me advice.

I have a spreadsheet that has several tabs - 1) Database 2) stats analysis taken from database, 3) Daily updates and 4) Daily calculations (taken from database) - these calculations are either from the last 12 months or from the last 14 days

Ideally, I'd like to have various CSV files with historical data - e.g one for 2022 one for 2021, 2020 and calculate formula for the last 12 months (or a specifc 12 months time period of my chosing)

What I need from you is advice on the best database set up to use so I can continue to use my current .
calculations

I have Excel365.

I would prefer this to be on excel, perhaps access, but am open to ideas. I don't want to spend more money on the database set up, so ideally excel, csvs etc, unless you have a superb alternative that won't cost extra.

I won't send the excel spreadsheet, but am more than happy to have zoom etc to go through in detail.

Thank you for showin interest. Any questions, get in touch.
Related categories: Excel SQL Microsoft Access MySQL Database Programming