I need an Excel Expert

Job ID: 34065308

Budget: $30 – $250 USD

I need a Dashboard for looking at Employee Performance.

I have a team of 12 people that ship orders for dozens of small ecommerce companies.
To understand our performance, It would be helpful to have an excel sheet that captures data from the time study sheets attached below. Each individual keeps track of how long it takes them to "pick" a cart (per company) and how long it takes them to “pack it”.
It would be great if we could capture this data to see daily, weekly and monthly totals per person, but also the daily, weekly, and monthly averages as a team per company.

We would need a tab for importing this data manually and another tab where we can see the results with drop down options to view totals per person (daily, weekly and monthly) and another area where we could see averages per company (daily, weekly and monthly). Some sort of visual graph would also be helpful.

I am interested in a quote to know how much something like this would cost and how long it would take. Thank you!
Related categories: PHP Visual Basic Data Processing Data Entry Excel