I have several years worth of sales data that is daily in nature and also broken down by the minute if needed. I want to copy and paste the data into the spreadsheet, and what I need the Excel to do is show me variables such as (examples only):
1. Sales on January 15th are up versus January 14th 82% of the time.
2. Sales at 1230 local time are down versus 1215 local time 60% of the time
3. Sales at 1230 local time are up versus 1215 local time sales 80% of the time on the date May 6th.
Those types of scenarios. I just need the worksheet to do a +/- calculation from the data point before, and then be able to pivot it to find trends based upon time of day, date, or both.
Thanks for your interest.
36 freelancers are bidding on average $477 for this job
Hi, I can help you with your requirement. I have closed more than 150 excel projects at various forums. Please provide more details to help you better. Regards Sawan
Hello. I'm practiced on excel program as well as treathing some statistical data programming. And now I have a lot time to do this job. So, feel free to cantact me.
I have good experience in excel, data mining and analysis. I work in investment research and Corporate finance area and I am sure I would meet your expectation.
Super Simple Software - As per our name we developed super and simple software to fulfil the user's requirement at user's cost. Our work maintain long relationship.