Simple spreadsheet with batch codes, roast dates/quantities & stock-take functions
- or -
Post a project like this2324
£8/hr(approx. $10/hr)
- Posted:
- Proposals: 11
- Remote
- #1800723
- Awarded
Excel and VBA expert. Professional OCR. PDF to Excel Conversion. Data management, Translations English Russian
Hua Hin
Microsoft Certified Power BI Data Analyst & Advance Excel Specialist¦Professional Power BI consultant ¦ (ACCA)- Chartered Certified Accountant ¦ Accounting- Reconciliations ¦DAX ¦Data Models ¦
Doha
1371827354952082703155611104630122469014064161544006190808019335051935914
Description
Experience Level: Entry
General information for the business: We sell wholesale and retail coffee beans
Industry: Food and Beverage
Description of excel work: Initially happy with excel, but could be something integrated onto new website launching next week.
I have a large spreadsheet at present which has a number of sheets for a number of different functions. I would need a new spreadsheet creating, which allows me to track the stock take of the green coffee beans I import, followed by the roasted beans delivered to me (minus 10-15% for chaff). I want this to track through to 'batch no. or code', meaning that the Roast Date of each batch is systematically correlated to batch number and thus each 1KG bag can be tracked back to a given batch for safety reasons. The stock-take would naturally signal to me when I need to order more green or roasted beans (at a given threshold). I want to manually input as LESS as possible.
Design and target audience: Use of my logo and brand would be good (Dark red, white, navy)
Extra notes:
Industry: Food and Beverage
Description of excel work: Initially happy with excel, but could be something integrated onto new website launching next week.
I have a large spreadsheet at present which has a number of sheets for a number of different functions. I would need a new spreadsheet creating, which allows me to track the stock take of the green coffee beans I import, followed by the roasted beans delivered to me (minus 10-15% for chaff). I want this to track through to 'batch no. or code', meaning that the Roast Date of each batch is systematically correlated to batch number and thus each 1KG bag can be tracked back to a given batch for safety reasons. The stock-take would naturally signal to me when I need to order more green or roasted beans (at a given threshold). I want to manually input as LESS as possible.
Design and target audience: Use of my logo and brand would be good (Dark red, white, navy)
Extra notes:
Nik S.
100% (3)Projects Completed
1
Freelancers worked with
1
Projects awarded
100%
Last project
3 Jan 2018
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi,
Do you have some excel files I could take a look at to give me some ideas on how I could help?
Thanks
546057
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