Suljettu

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?

Taidot: Tietokantaohjelmointi, Excel, Excel Macros, Excel VBA

Näytä lisää: 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

Tietoa työnantajasta:
( 0 arvostelua ) Zurich, Switzerland

Projektin tunnus: #19994167

40 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

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 Lisää

$196 USD 3 päivässä
(104 arvostelua)
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 10 päivässä
(67 arvostelua)
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 Lisää

$78 USD 2 päivässä
(102 arvostelua)
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 Lisää

$50 USD 3 päivässä
(32 arvostelua)
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 Lisää

$30 USD 1 päivässä
(48 arvostelua)
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 Lisää

$28 USD 1 päivässä
(26 arvostelua)
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 Lisää

$90 USD 7 päivässä
(19 arvostelua)
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. Lisää

$60 USD 10 päivässä
(8 arvostelua)
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 Lisää

$25 USD 1 päivässä
(2 arvostelua)
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 Lisää

$30 USD 2 päivässä
(2 arvostelua)
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 Lisää

$200 USD 7 päivässä
(1 arvostelu)
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 3 päivässä
(2 arvostelua)
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 Lisää

$20 USD 7 päivässä
(3 arvostelua)
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 2 päivässä
(6 arvostelua)
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 1 päivässä
(0 arvostelua)
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 Lisää

$55 USD 1 päivässä
(0 arvostelua)
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 Lisää

$30 USD 4 päivässä
(0 arvostelua)
0.0
Protati

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

$55 USD 7 päivässä
(0 arvostelua)
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 Lisää

$25 USD 4 päivässä
(0 arvostelua)
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 4 päivässä
(0 arvostelua)
0.0