Advanced spreadsheet sorting

AWARDED
Bids
29
Avg Bid (GBP)
£80
Project Budget (GBP)
£20 - £250

Project Description:
We have a workbook with two sheets.
Sheet #1 contains a table & Sheet #2 picks up a csv from the C:\ drive that is refreshed each time it is opened.
The CSV grabs information from a database and is updated each night.

The data comes from a restaurant.
The restaurant has 8 screens in the kitchen which help automate orders. Each of these screens belong to a particular station in the kitchen ie. Grill, Bar, Pizza etc.
The CSV data contains information on what transactions came on which screens, the time it took to cook (in seconds) and the actual time stamp.

Time Stamp Kitchen Screen Time Transaction
2012-09-04 23:38:42.440 Main Bar 1286 0 36659
2012-09-04 23:01:25.330 Cutlery 3745 0 36659
2012-09-04 23:01:25.330 Desserts 271 0 36659


What we need is to basically create a report - in excel.
The data needs to be arranged by

a. Meal Period (using time stamps) and to actually display that meal period. For example, breakfast would be between 4am to 11:59am, lunch will be 12:00pm to 6:00pm etc.
b. The individual kitchen screens.
The above will mean we will have 8 rows of kitchen screens for breakfast, followed by another 8 rows of kitchen screens for lunch etc.

For each of the above, the average "cook time" will need to be calculated based on the data, along with the amount of transactions.

Here are the steps to the report -
1 User enters a date or date range in the top cells (maybe a date picker?)
2 The fields below will be populated with data for that specified date.
3 IF the user inputs a range, then the fields below will be cloned below the previous set and the data will be put into there for each day.

Skills required:
Data Entry, Data Processing, Excel
Additional Files: QSR+Report+Requests.xlsm SpeedofService.csv
Hire deset
Project posted by:
deset United Kingdom
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


£ 150
in 5 days
Hire greggfletcher
£ 200
in 2 days
£ 77
in 2 days
Hire bouslimi1979
£ 80
in 4 days
£ 100
in 5 days
£ 50
in 2 days
£ 45
in 5 days
Hire Pichart
£ 40
in 2 days
£ 150
in 7 days
Hire FLtowhid
£ 25
in 4 days