Advanced spreadsheet sorting

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: Data Entry, Data Processing, Excel

See more: what is sorting data, what is data sorting, table top range, sorting of data, data entry screens, data enters, csv spreadsheet, time stamp, spreadsheet 2, meal, kitchen set, grill, excel data sorting, excel advanced, date picker, create spreadsheet, cook, breakfast, advanced excel, automate report excel, spreadsheet csv, create sheets data sheet, workbook csv, excel inputs, sorting data

About the Employer:
( 0 reviews ) London, United Kingdom

Project ID: #2472336

23 freelancers are bidding on average £73 for this job


we are interested in working in your project. Please check your inbox.

£150 GBP in 5 days
(281 Reviews)

Hi, can we further discuss the project requirements. Thanks

£80 GBP in 4 days
(139 Reviews)

Hi, I can do anything you ask in excel. Please feel free to check my profile page. Demo version is ready for you in pmb.

£77 GBP in 2 days
(177 Reviews)

Hi... I would like to apply for the job.

£50 GBP in 1 day
(79 Reviews)

Ready For Your Project.

£150 GBP in 7 days
(24 Reviews)

Sir, I am a professional data entry worker & can complete as with your satisfaction, please see my private message for details.

£50 GBP in 2 days
(115 Reviews)

Hi. we are a team of excel macro experts and we are interested to help you. Please let us know your thoughts. Thank you !

£20 GBP in 3 days
(143 Reviews)

Hello. We are a Team of professionals in developing MS Access\Excel + VBA applications. We assume high quality work both in terms of technical background and time frame issues. Please check your PMB.

£100 GBP in 5 days
(21 Reviews)

Hi, I can do it. I'm programmer for years and very familiar with vba for office automation tasks. Best regards, Cuong NH

£45 GBP in 5 days
(23 Reviews)

We r excel macro expert and can finish ur job in few hours

£100 GBP in 1 day
(15 Reviews)

Expert MS Excel user with extensive experience of macros and data manipulation, I would be delighted to support you on this project.

£60 GBP in 3 days
(12 Reviews)

Please see my PM.

£25 GBP in 4 days
(4 Reviews)

Hello, Please consider my interest and see my PM message. Thank you. Regards, CValerian

£60 GBP in 3 days
(5 Reviews)

I can do this for you

£20 GBP in 2 days
(0 Reviews)

The task is clear. I'll do it quickly and efficiently.

£20 GBP in 3 days
(0 Reviews)

start now. start now. start now.

£150 GBP in 4 days
(0 Reviews)

I can satisfy you needs by completing the task accurately and in time. Many thanks.

£30 GBP in 3 days
(0 Reviews)

I am skilled in Ms-Excel, Ms-Word, Ms-PowerPoint, Ms-Access, Outlook, Ms-SQL, Oracle and have fast typing speed I am willing for some appropriate work; related to my skills. I hope I can done your project in best ti More

£20 GBP in 1 day
(0 Reviews)

This is an easy project. Rest assured that you will get quality output.

£44 GBP in 2 days
(0 Reviews)

hello sir i know i can do this and i want a chance to [url removed, login to view] u will provide me with one..

£20 GBP in 0 days
(0 Reviews)