Need excel application
- or -
Post a project like this2820
$120
- Posted:
- Proposals: 7
- Remote
- #1202530
- Completed
Google Sheets Automation, Apps script, Excel VBA Expert, Qlikview, WordPress Hack Fix, Proofreading
Bangalore
Website Design, E-Commerce, Software Development & SEO, Internet Marketing Solutions
Nagpur
4864955167198054231050712108305812280501275210
Description
Experience Level: Intermediate
Estimated project duration: less than 1 week
General information for the business: Bakery in Singapore and China
Kind of development: New program from scratch
Description of requirements/functionality: eneral information for the business: Bakery based in Singapore and China
Kind of development: New program from scratch
Description of every module: Dashboard to view
1) Stock level of each product in our cold storage by the hour of the current day
2) Number of each products sold per day and per weekly period
3) View Reorder quantity of each product organised presently on a weekly period
Description of requirements/functionality: General information for the work scenario
Our bakers starts the days by removing bread dough from our fridge for baking. He/she will then write the quantity of each bread dough taken out according to the specify time by filling the hourly production spreadsheet. All movement of the dough are recorded manually by the 2 spreadsheets.In order to improved our efficiency and productivity, we would like the baker to input the information on the printed hard copy of the spreadsheets into the excel workbook at the end of the day. We would like to achieve the below objectives with information collected.
1) Baker should be able to know what is the current quantity of each product in the fridge by the hour.
2) He/she is able to view what products and he reorder from factory on a specify day or sort by week
3) Able to clearly identify which products are more popular with the consumers and which are not
4) He/she should be able to input the data into the worksheet with a simple and straight forward user forms. Note : Our bakers have very poor computer skills.
OS requirements: Windows
Extra notes: Extra notes: The dashboard must be full usable in Excel 2010.
After completion need instructions on how to translate the application into a foreign language. As the actual user will input in Chinese.
OS requirements: Windows
Extra notes: General information for the business: Bakery based in Singapore and China
Kind of development: New program from scratch
Description of every module: Dashboard to view
1) Stock level of each product in our cold storage by the hour of the current day
2) Number of each products sold per day and per weekly period
3) View Reorder quantity of each product organised presently on a weekly period
Description of requirements/functionality: General information for the work scenario
Our bakers starts the days by removing bread dough from our fridge for baking. He/she will then write the quantity of each bread dough taken out according to the specify time by filling the hourly production spreadsheet. All movement of the dough are recorded manually by the 2 spreadsheets.In order to improved our efficiency and productivity, we would like the baker to input the information on the printed hard copy of the spreadsheets into the excel workbook at the end of the day. We would like to achieve the below objectives with information collected.
1) Baker should be able to know what is the current quantity of each product in the fridge by the hour.
2) He/she is able to view what products and he reorder from factory on a specify day or sort by week
3) Able to clearly identify which products are more popular with the consumers and which are not
4) He/she should be able to input the data into the worksheet with a simple and straight forward user forms. Note : Our bakers have very poor computer skills.
OS requirements: Windows
Extra notes: Extra notes: The dashboard must be full usable in Excel 2010.
After completion need instructions on how to translate the application into a foreign language. As the actual user will input in Chinese.
Kind of development: New program from scratch
Description of requirements/functionality: eneral information for the business: Bakery based in Singapore and China
Kind of development: New program from scratch
Description of every module: Dashboard to view
1) Stock level of each product in our cold storage by the hour of the current day
2) Number of each products sold per day and per weekly period
3) View Reorder quantity of each product organised presently on a weekly period
Description of requirements/functionality: General information for the work scenario
Our bakers starts the days by removing bread dough from our fridge for baking. He/she will then write the quantity of each bread dough taken out according to the specify time by filling the hourly production spreadsheet. All movement of the dough are recorded manually by the 2 spreadsheets.In order to improved our efficiency and productivity, we would like the baker to input the information on the printed hard copy of the spreadsheets into the excel workbook at the end of the day. We would like to achieve the below objectives with information collected.
1) Baker should be able to know what is the current quantity of each product in the fridge by the hour.
2) He/she is able to view what products and he reorder from factory on a specify day or sort by week
3) Able to clearly identify which products are more popular with the consumers and which are not
4) He/she should be able to input the data into the worksheet with a simple and straight forward user forms. Note : Our bakers have very poor computer skills.
OS requirements: Windows
Extra notes: Extra notes: The dashboard must be full usable in Excel 2010.
After completion need instructions on how to translate the application into a foreign language. As the actual user will input in Chinese.
OS requirements: Windows
Extra notes: General information for the business: Bakery based in Singapore and China
Kind of development: New program from scratch
Description of every module: Dashboard to view
1) Stock level of each product in our cold storage by the hour of the current day
2) Number of each products sold per day and per weekly period
3) View Reorder quantity of each product organised presently on a weekly period
Description of requirements/functionality: General information for the work scenario
Our bakers starts the days by removing bread dough from our fridge for baking. He/she will then write the quantity of each bread dough taken out according to the specify time by filling the hourly production spreadsheet. All movement of the dough are recorded manually by the 2 spreadsheets.In order to improved our efficiency and productivity, we would like the baker to input the information on the printed hard copy of the spreadsheets into the excel workbook at the end of the day. We would like to achieve the below objectives with information collected.
1) Baker should be able to know what is the current quantity of each product in the fridge by the hour.
2) He/she is able to view what products and he reorder from factory on a specify day or sort by week
3) Able to clearly identify which products are more popular with the consumers and which are not
4) He/she should be able to input the data into the worksheet with a simple and straight forward user forms. Note : Our bakers have very poor computer skills.
OS requirements: Windows
Extra notes: Extra notes: The dashboard must be full usable in Excel 2010.
After completion need instructions on how to translate the application into a foreign language. As the actual user will input in Chinese.
Kai L.
100% (4)Projects Completed
4
Freelancers worked with
3
Projects awarded
57%
Last project
8 Jan 2018
Singapore
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