Advanced spreadsheet sorting

This project received 24 bids from talented freelancers with an average bid price of £74 GBP.

Get free quotes for a project like this
Project Budget
£20 - £250 GBP
Total Bids
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:[url removed, login to view] Main Bar 1286 0 36659

2012-09-04 23:01:[url removed, login to view] Cutlery 3745 0 36659

2012-09-04 23:01:[url removed, login to view] 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

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online