Data handling in Excel -- 2
Budget: $30 – $250 USD
Hi,
Problem:
As you can see from the attached file, Every day, we get new data crawled from six different websites. The crawled data from each site is saved in a different excel-file every day. The data is sorted into different columns (see attached file).
Solution:
We would like to find an easy way to sort this data, each site separately, and make it (1) easy to see the changes in data e.g. how much the quantity differs, or the change in position, on a day-to-day basis. (2). Your solution must make it easy to add new data entries every day. (3) The data then needs to be summarised and visualised graphically, so we can see patterns over time.
We are using Mac. So your solution must be compatible running on an OS operating system and excel.
Problem:
As you can see from the attached file, Every day, we get new data crawled from six different websites. The crawled data from each site is saved in a different excel-file every day. The data is sorted into different columns (see attached file).
Solution:
We would like to find an easy way to sort this data, each site separately, and make it (1) easy to see the changes in data e.g. how much the quantity differs, or the change in position, on a day-to-day basis. (2). Your solution must make it easy to add new data entries every day. (3) The data then needs to be summarised and visualised graphically, so we can see patterns over time.
We are using Mac. So your solution must be compatible running on an OS operating system and excel.