Käynnissä

Create an Excel query or formular to dynamically build BOM List based on two input spreadsheets

We got two spreadsheets :

1. Article base data with article price (=compontents)

2. BOM list of assembly, showing what compontents in what amount are assembled

BOM = Bill of material

Please read carefully the attached PDF file that explains everything in detail.

Later on I will upload the XLS-File with the current data.

We need a dynamic query that automatically generates the BOM-List based on the two mentioned lists.

Taidot: Excel

Näytä lisää: erstellen eines online stores, web based input excel access, build excel vba functions, showing image based input php, web based game using php build town, excel query data secure website, list based companies, changing image based input, input salaries time sheets excel spreadsheets, copy spreadsheets websites copy excel, mashup map locations based input, list cities county zip codes usa excel file, change image based input, dhtml populate state list based country selected, build excel pivot table, build excel pread sheets, getafreelancercom web data extraction softwares scripts, flash games converter softwares, database softwares, softwares taurusweb, softwares needed develop net application, bluetooth softwares, softwares increase youtube videos, search crack softwares, yellow pages softwares

About the Employer:
( 7 reviews ) Osnabrück, Germany

Projektin tunnus: #13106700

Myönnetty käyttäjälle:

ksriniravi

Greetings! Having worked in Electronics Manufacturing, I have extensively dealt with BOM - I understand your requirement to come up with a Master BOM with costs exploding Sub Assemblies. I can write a Macro to meet Lisää

30 $ USD 1 päivässä
(44 arvostelua)
5.2

8 freelanceria on tarjonnut keskimäärin 35 $ tähän työhön

sandroshubladze

not clear yet, if you need PPT presentation made automatically from excel or pdf or what bu anyways, I can do whatever you need there So, If interested, contact me P.S. PDF is reviewd

50 $ USD 1 päivässä
(35 arvostelua)
5.3
sourabhg98

Hello, Talking to the point, I read the PDF instructions, your work will be done in an hour. Best Sourabh

25 $ USD 1 päivässä
(19 arvostelua)
3.9
jas16183

I will need one working day for the given work once awarded, I have great deal of experience in data management of analysis

30 $ USD 1 päivässä
(0 arvostelua)
0.0
Ultraserenejoe

I have automated projects on excel using Visual Basic and dealt with similar problem statements. I can develop a macro that takes the first two spreadsheets as input and create the output third sheet with the required Lisää

25 $ USD 1 päivässä
(0 arvostelua)
0.0
vkavitha

hello, Myself kavitha working as a senior data analyst with 6 years of experience. i went through ur pdf, removing duplicates and getting data can be done easily with coniditiining formatting or remove duplicates and Lisää

32 $ USD 1 päivässä
(0 arvostelua)
0.0
mrunalkuanr

A proposal has not yet been provided

32 $ USD 1 päivässä
(0 arvostelua)
0.0
Engmichaelnady

A proposal has not yet been provided

25 $ USD 1 päivässä
(0 arvostelua)
0.0
fb57e1f6608abfb

Hi, I have ~4+ years of experience of creating and operating low to very high complexity of Excel/VBA/SQL,SAS, Powerpoint based tools/processes, reports. I can assure you of high quality and on-time deliverable Lisää

55 $ USD 1 päivässä
(0 arvostelua)
0.0