Advanced spreadsheet sorting
£20-250 GBP
Płatność przy odbiorze
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.
Numer ID Projektu: #2472336
O projekcie
23 freelancerów złożyło ofertę za £73 w tym projekcie
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.
Sir, I am a professional data entry worker & can complete as with your satisfaction, please see my private message for details.
Hi. we are a team of excel macro experts and we are interested to help you. Please let us know your thoughts. Thank you !
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.
Hi, I can do it. I'm programmer for years and very familiar with vba for office automation tasks. Best regards, Cuong NH
Expert MS Excel user with extensive experience of macros and data manipulation, I would be delighted to support you on this project.
hello sir i will do your work without any demands and complain otherwise i wont charge anything from you .i beleive in your satisfaction.
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 Więcej
