Đã Đóng

Build me an Excel macro for restaurant inventory

Looking for an excel /Android app to be created for ordering food perishables in a fast food restaurant.

Process flow as follows:

Input:

1. Enter 'date': ddmmyy (max 7 dates)

2. Enter number of persons:

3. Enter number of staff:

4. Select 'time of day' for each date from droplist: breakfast, lunch, tea, dinner, snacks

5. Select any 4 'recipes' from droplist for each time of day:

Prepopulated list of recipes

Output:

Calculate and show report

Vlookup: 'ingredients' and 'quantities' for each recipe, for 1 person

Vlookup: max 3 'supplier names' for each ingredient

Report

Sheet 1: aggregate Ingredient-wise total

(quantity) x (number of persons + staff) for all dates selected. Show all 3 supplier names for each ingredient.

Sheet 2: Recipes selected by date, time of day, for number of persons

Kĩ năng: Excel, Android, Visual Basic, Xử lí dữ liệu, Nhập liệu

Xem nhiều hơn: excel spreadsheet restaurant inventory, build sorting macro excel, excel macro build chart, build excel macro find replace, build replace macro excel, excel macro inventory system, macro warehouse inventory excel, excel macro stock inventory, warehouse inventory system excel macro, excel macro update inventory prices, excel macro based inventory control system, build excel macro

Về Bên Thuê:
( 2 nhận xét ) London, United Kingdom

ID dự án: #21889905

22 freelancer đang chào giá trung bình £27 cho công việc này

schoudhary1553

Hello Sir, I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without cha Thêm

£100 GBP trong 2 ngày
(342 Nhận xét)
8.0
datakillers

Hi Sarajit I have good Microsoft Excel skills with years of experience as well as I have complete number of projects for Excel to manage data and sorting. You can check my profile feedback section and you will know wha Thêm

£20 GBP trong 1 ngày
(258 Nhận xét)
7.1
prameswara

Hello Sir Im excel VBA macro and formula Expert :) i can do your app restaurant in excel Sir via VBA macro. please ping me if you interested with me and we can discuss more for make sure everything before start Thank Thêm

£50 GBP trong 2 ngày
(386 Nhận xét)
7.2
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] Thêm

£30 GBP trong 2 ngày
(122 Nhận xét)
5.9
dfexcel

Hi, I have carefully reviewed the meticulously drafted details on the job post and understood all of your requirements (they are quite a few of them). Having successfully developed and deployed several such Apps workin Thêm

£50 GBP trong 3 ngày
(10 Nhận xét)
5.3
bhupendrayadav

I can develop a food perishable items ordering system on excel/google spreadsheets/web applications, let discuss this in detail in chat or over a quick call. Please find below a brief introduction of myself. I am post Thêm

£70 GBP trong 1 ngày
(34 Nhận xét)
5.2
indrapandu

Hi, I can create a macro for your fast food restaurant. I can create form for the input and populate the output as requirements. Let's have a chat for detail discussion. I may have some questions for the requirements o Thêm

£20 GBP trong 1 ngày
(20 Nhận xét)
4.1
SamerHany

Hi there, I have over 6 years of experience in spreadsheet automation and scripting (Excel/VBA, Google sheets/GAS). I create fully automated dashboards, financial calculators, recipe calculators, user forms, automate Thêm

£30 GBP trong 2 ngày
(9 Nhận xét)
3.8
Saimi786

i can do it easily and i have also an alternate for you. come we will discuss. Hello Thanks for your posting. I am a senior developer so i can do it very easily if you want.I’ve read your job description carefully and Thêm

£19 GBP trong 1 ngày
(2 Nhận xét)
2.0
Amrsamra

it`s an easy project and can be finished in less than the determined time please contact me to discuss the other details. Thank you.

£15 GBP trong 1 ngày
(4 Nhận xét)
1.6
Weilong0901

How are you I am a full stack web and mobile app developer and have 6 years experience. I read your project description carefully and I understand what you want. I have worked Android apps using Excel(CSV format) o Thêm

£20 GBP trong 7 ngày
(2 Nhận xét)
1.2
davidkurnia18

saya orang yang berpengalaman dalam administrasi Relevant Skills and Experience excel, word, power point

£20 GBP trong 1 ngày
(0 Nhận xét)
0.0
Raghinide

Hi, I just saw your job task. I am interested to do. I am well known with excel and word. Can you give a chance to prove myself. Thank you

£15 GBP trong 7 ngày
(0 Nhận xét)
0.0
ryanraposo

Hi! With considerable experience pushing the limits of Excel's VBA/macro functionality, I can deliver your ordering interface with confidence. It will be easy to use, nice to look at, and reliable. Your reports will be Thêm

£10 GBP trong 2 ngày
(0 Nhận xét)
0.0
izafif

Hello, I am interested with your job offer. I am a Professional Data Entry with a high desire to enhance quality of work. I have faith that with my skills and experience for 3 years in this field will ease your compan Thêm

£10 GBP trong 3 ngày
(0 Nhận xét)
0.0
£18 GBP trong 1 ngày
(0 Nhận xét)
0.0
JOuverson

I work in the restaurant industry as well and think this would be easy to make for you. Go ahead and contact me and we can work out some of the details. Thanks and have a good day.

£20 GBP trong 3 ngày
(0 Nhận xét)
0.0
justmirzaasif

I am professional in MS excel, word, SAP, ERP, ORACLE, SPREED SHEET, PIVOT SHEET, ETC also experience in supply chain management, I have completed different project in excel, word etc. Regards Asif Mirza

£15 GBP trong 6 ngày
(0 Nhận xét)
0.0
£18 GBP trong 1 ngày
(0 Nhận xét)
0.0
kunaalhinduja

I am a data analyst in a bank who works with Excel(with VBA) and access on daily basis and I can deliver this to you quickly! Relevant Skills and Experience I am a data analyst in a bank who works with Excel(with VBA) Thêm

£15 GBP trong 2 ngày
(0 Nhận xét)
0.0