Make excel data work harder/better for small restaurant chain
- or -
Post a project like this3089
$
- Posted:
- Proposals: 20
- Remote
- #926387
- Awarded
Virtual PA, Admin, MS Excel, Streamlining, IF Statements, VLook Ups, Pivot Tables, graphs and charts, dashboards, MS Word Documents
Luton
Growth Hacker | Data Analytics | Operations Consultant | Excel | Business Plan | Marketing Research | Product Design
Bangalore
59968175079710757831069104106728410633041048227103497695956895618384685835495
Description
Experience Level: Entry
We run 3 restaurants (with 2 more on the way)
The restaurants fill in daily sales sheets individually that are currently saved on dropbox.
Id like the restaurants to enter simple information also for the number of hours the staff work. Could be drop down boxes for each name, and then a start and finish time, which then calculate the number of hours worked and adds them up centrally. Id want to see each staff allocated to a group
Waiting staff
Administrator
Kitchen
Pizza
Cleaning
Currently we manually take the information from the sales sheets to do any forecasting.
I would like the sales spreadsheets to work together, bringing all the information in one place, so that I can see all sales together, and compare, daily, weekly, monthly trends. Id like to see this information in simple charts also.
We have our own server that could host any centralised files or software.
I would be open to any other ideas that you may have. In fact. I would encourage it.
The restaurants fill in daily sales sheets individually that are currently saved on dropbox.
Id like the restaurants to enter simple information also for the number of hours the staff work. Could be drop down boxes for each name, and then a start and finish time, which then calculate the number of hours worked and adds them up centrally. Id want to see each staff allocated to a group
Waiting staff
Administrator
Kitchen
Pizza
Cleaning
Currently we manually take the information from the sales sheets to do any forecasting.
I would like the sales spreadsheets to work together, bringing all the information in one place, so that I can see all sales together, and compare, daily, weekly, monthly trends. Id like to see this information in simple charts also.
We have our own server that could host any centralised files or software.
I would be open to any other ideas that you may have. In fact. I would encourage it.
TOM N.
87% (6)Projects Completed
20
Freelancers worked with
20
Projects awarded
50%
Last project
20 Jun 2019
Lithuania
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies