Closed

Programm a smart excel inventory file

Hello Freelancers,

Our company furnishes and rents out apartments. Therefore we need to create standardized xls "buying lists" listing all the items we need to order per apartment.

We are looking for talented freelancers to program us a smart buying list. your job is to program an xls which can do the following:

- item category (bedroom, kitchen, living room, bathroom, corridor, balcony, other)

- item name

- product name (from shop)

- item number

- supplier

- link

- number of items needed

- price per item

- cost of delivery

- total cost

- delivery time

The xls has to be setup in a way, that depending on the apartment size, number of beds and number of people able to life in the apartment the number of items in the list adjust them selves.

i.e. i want to be able to change the number of beds, rooms and people and automatically the number of forks/knives, chairs, linens etc. will adjust. adding the items is not your job - an designer will choose - but you have to exactly be able to say what happens where and what has to be added.

further requirements:

- budget

- spending

- overspending/saving

- aprox. setup time per item

- total setup time per apt

- manpower needed (8 hours per worker)

- check if link is valid and available

**Post the reference "xlsCH" in your offer so we know you read the text**

sorting:

- sort by price

- sort by quantity

- sort by delivery time

- sort by manpower

- sort by supplier

- sort by category

etc.

ready for work?

Skills: Database Programming, Excel, Excel Macros, Excel VBA

See more: excel creat file makro cell name, using excel parse file, excel inventory count project plan, can import excel invoice file quickbooks, quickbooks excel import file, dat inventory file, need someone excel attached file, save excel onix file, visual basic excel inventory, excel inventory adjust code visual basic, example excel inventory file, inventory file excel, upload amazon inventory file excel

About the Employer:
( 0 reviews ) Zurich, Switzerland

Project ID: #19994167

40 freelancers are bidding on average $62 for this job

zekovicm

xlsCH Hi there,I am Excel expert from Bosnia & Herzegovina. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within the agreed More

$196 USD in 3 days
(104 Reviews)
7.1
vw7209238vw

What you are looking for cannnot be done for less than 200 usd. Other way you will get only part of the work or a low quality result. Please contact. Read comments from my clients as a reference.

$235 USD in 10 days
(67 Reviews)
6.0
sourabhg98

xlsCh Hey there! This is Sourabh Gupta from New Delhi. I am an advanced Excel VBA programmer currently at the post of Forum Expert at www.excelforum.com. I read the description of your project, you need a quite comp More

$78 USD in 2 days
(102 Reviews)
5.4
urielbaray

Hi! Thank you for taking the time to read my proposal, My name is Uriel Baray I am a VBA Excel Expert with several years of experience on the field, if you are so kind to take a look to my portfolio, I have some sampl More

$50 USD in 3 days
(32 Reviews)
5.1
daniyal3214

I can definitely help you with developing such an Excel based tool. I am a professional Data analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel including VBA an More

$30 USD in 1 day
(48 Reviews)
5.4
bhupendrayadav

I am postgraduate (MBA) with more than 5 years of experience in financial modeling, advanced excel, VBA automation and data processing. I have successfully completed similar projects, please have a look at my portfolio More

$28 USD in 1 day
(26 Reviews)
4.5
jsb1156

"xlsCH" 1. Experienced project professional, US based, MBA, EXCEL and MS Project expert; strong financial planning and estimating background, experienced with complex formulas, LOOKUPS, PIVOTS, and charts towards the More

$90 USD in 7 days
(19 Reviews)
4.0
GabrielBarreiro1

xlsCH Dear, I am interested in participating in your project. I think I can develop the workbook they need based on the IF formula. If for a room you need x elements, when you add one more the elements multiply. More

$60 USD in 10 days
(8 Reviews)
3.7
okzhang321

VERY EASY FOR ME Hi, Nice to meet you. Please see product I made recently using VBA and C# excel management I can show my product right now. I have a lots of experiences in Excel, Access and VBA programming Plea More

$25 USD in 1 day
(2 Reviews)
3.0
sardaaditya28

Hi there, with an experience of over 5 years in excel , I can develop a more finished and automated version of what you are asking here....I have made more complicated models and this and I have a very good feeling th More

$30 USD in 2 days
(2 Reviews)
2.7
emilianoreyes70

Hello! Looks very challenginng, it can be done by building a higth detailed list and parameters that affect each item. It can take more then a week to do it and test it. In case you have anything done, please share th More

$200 USD in 7 days
(1 Review)
2.4
umairabdillah12

Hi Sir, I am interested in the work you offer, just recruit me for this job. I have more than 10 years experience in using the excel formula. thanks regards

$30 USD in 3 days
(2 Reviews)
2.8
ninestar801

Hi, Hope you are doing well! I would like to work on your project. I have excellent skills in skills with more than 6 Years experience. I'm sure that I will complete with high quality in the shortest time. I am always More

$20 USD in 7 days
(3 Reviews)
1.9
razvancotofana

Hi there xlsCH, I am well experienced in excel and VBA and I recently completed a similar project for another client. I would like to help you if I can. Please share your project details over chat. BR, Razvan

$20 USD in 2 days
(6 Reviews)
2.1
nicoleguan3

XlsCH Hello, I’m a full time Excel programmer that help comp he’s with Excel issues and projects. Please let me of if interested. Thanks.

$35 USD in 1 day
(0 Reviews)
0.0
jinridong19713

Hi, Sir. I have many experience on Excel macro vba. I'm a honest and hardworking developer. If you hire me, I will finish this work quickly as full time with good quality. I can give you longtime support for app ma More

$55 USD in 1 day
(0 Reviews)
0.0
anilakpunar

Dear authorized, I am industrial engineer. I want to work on your job. If you look at my profile, I worked as a system consultant. I did to consultanty enterprises for SAP Business One Program. I have some experienc More

$30 USD in 4 days
(0 Reviews)
0.0
Protati

I have designed different simulation models and smart excel files which have significantly reduced time spent on specific tasks.

$55 USD in 7 days
(0 Reviews)
0.0
avinisharjs

Hi. I would be interested in handling this project. Expertise: I have good quality experience in Excel VBA. I have successfully completed many projects that deals with technical and commercial data. I am pretty much More

$25 USD in 4 days
(0 Reviews)
0.0
nomie101

Feel free to ask to see what i have previously done.I am very confident that i will be able to deliver exactly what you want!

$25 USD in 4 days
(0 Reviews)
0.0