You have chosen to sponsor your bid up to a maximum amount of .
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.