Kapalı

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

Beceriler: Excel, Android, Visual Basic, Veri İşleme, Veri Girişi

Daha fazlasını gör: 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

İşveren Hakkında:
( 2 değerlendirme ) London, United Kingdom

Proje NO: #21889905

Bu iş için 22 freelancer ortalamada £27 teklif veriyor

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 Daha Fazla

£100 GBP in 2 gün içinde
(342 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(258 Değerlendirme)
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 Daha Fazla

£50 GBP in 2 gün içinde
(386 Değerlendirme)
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] Daha Fazla

£30 GBP in 2 gün içinde
(122 Değerlendirme)
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 Daha Fazla

£50 GBP in 3 gün içinde
(10 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(34 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(20 Değerlendirme)
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 Daha Fazla

£30 GBP in 2 gün içinde
(9 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(2 Değerlendirme)
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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(4 Değerlendirme)
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 Daha Fazla

£20 GBP in 7 gün içinde
(2 Değerlendirme)
1.2
davidkurnia18

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(0 Değerlendirme)
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 in 7 gün içinde
(0 Değerlendirme)
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 Daha Fazla

£10 GBP in 2 gün içinde
(0 Değerlendirme)
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 Daha Fazla

£10 GBP in 3 gün içinde
(0 Değerlendirme)
0.0
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(0 Değerlendirme)
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 in 3 gün içinde
(0 Değerlendirme)
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 in 6 gün içinde
(0 Değerlendirme)
0.0
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(0 Değerlendirme)
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) Daha Fazla

£15 GBP in 2 gün içinde
(0 Değerlendirme)
0.0