Hello,
I will assist you and create an excel model according with your needs.
I've reviewed attached files and your project description. My conclusion, in order to create the best model for you, is to make an excel data base with all data together, combined with automatic PIVOT reports and analysis.
With this model you will have:
- Fantastic reports sorted as you like (all possible combinations and criteria that you need)
- One click to update all reports (daily refresh) with 100% accuracy.
- Easy to use (user friendly with my instructions / comments)
- Data base will keep daily data (so you will have history if you need it for analysis)
I will need some time (up to one week) to set up a data base, so the downloaded files (raw data) can be easily and 100% accurately be added to data base on daily basis. (copy-paste)
My bid is 200GBP to create this model which will be fully custom built and unique. Please note that I'm open-minded to set up a fer price and win-win deal if you need something else simplified or more detailed.
I'm unemployed since last week and I will be fully engaged to complete this task.
Please check my profile for reference.
Thank you in advance, all the best,
Edis