Excel / Access Database - Quantity Calculation Macro
€30-250 EUR
货到付款
-Urgent- Let us know if you are available today
I need a VBA Macro code to create a Quantity calculation function for our Bill Of Material.
The problem is rather simple, we have list of Components in a hierarchized structure, the structure is expressed with a Level column formatted like 1.1.2 or 1.2.12 etc.
We need the ability to calculate the total quantity of each child of the structure based on it’s level and parent quantity.
This means we need a CumulQty column for the level 1.x, but also a column for the CumulQty for the Level 1.x.x and 1.x.x.x
The solution can be done in Excel (VBA) , through Power Pivot or through Access.
Regardless, we need a CumulQty Column for each level to be created in our structure.
BOM example :
Level Flat Level VER_ID Qty
1 1 Vpr-1000541 1
1.2 2 Vpr-1002497 1
1.2.1 3 Vpr-1003139 4
1.2.1.1 4 Vpr-1002486 1
1.2.1.1.1 5 Vpr-1002710 1
1.2.1.1.1.1 6 Vst-1024854 1
1.2.1.1.1.2 7 Vst-1024861 2
1.2.1.1.2 8 Vpr-1001423 2
1.2.1.1.2.1 9 Vst-1024865 2
1.2.1.1.2.2 10 Vst-1026864 2
1.2.1.1.2.3 11 Vst-1039814 2
1.2.1.1.2.4 12 Vst-1024852 2
1.2.1.2 13 Vpr-1002883 1
1.2.1.2.1 14 Vpr-1002976 1
1.2.1.2.1.1 15 Vpr-1002068 2
1.2.1.2.1.1.1 16 Vst-1026866 4
1.2.1.2.1.1.2 17 Vst-1024834 4
1.2.1.2.1.1.3 18 Vst-1024877 4
1.2.1.2.1.1.4 19 Vst-1024580 1
1.2.1.2.1.2 20 Vst-1024834 4
1.2.1.2.1.3 21 Vpr-1000826 2
1.2.1.2.1.3.1 22 Vst-1024834 4
1.2.1.2.1.3.2 23 Vst-1024822 1
1.2.1.2.1.3.3 24 Vst-1026866 4
1.2.1.2.1.3.4 25 Vst-1024877 4
Best regards,
Nicolas B
项目ID: #37739605
关于项目
有31名威客正在参与此工作的竞标,均价€148/小时
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are look 更多
"""""""""""""""""""ADVANCE EXCEL EXPERT/EXCEL ACCESS DATBASE/QUANTITY CALCULATION MACRO"""""""""""""""""""""""" ""Sir, EXCEL is my specialty and I can perform any complex task in EXCEL. I am an EXCEL VBA and CODING, AU 更多
Hello, Excel expert here. I can perfectly assist you with this and can start on an immediate basis. I am an experienced Excel professional with years of experience in all the tools of Excel including Visual Basic, Auto 更多
Hi there, I am an Excel Macro expert and i think i can handle the task with a prompt response. All of the clients i have worked for have been more than satisfied and i am preety sure that you will be satisfied. The 更多
Hello, I would love to help you on your project. I am a Microsoft Expert and Data Analyst. I have built many SharePoint Sites. I can create a custom database for you. Have a look at my profile. I have a whole lot 更多
Hello, Greetings of the day! I have a vast experience of working in Advanced Excel and I have completed many projects based on Advanced Excel. I have read your requirements and I can complete your project within time 更多
Hello Nicolas B, I am available today and ready to assist you with creating a VBA Macro code to generate the Quantity calculation function for your Bill Of Material. I understand the hierarchical structure of your Com 更多
Hi there, I'm an expert developer with 10+ years of experience and have rich experience in writing vba macro. I'm so interested to work with you in this project, I can handle this task with macro in efficient manner. W 更多
As an expert in Excel and VBA/Macro programming, I am thrilled to offer you my services for your urgent project. Over my 9-year-long professional career, I have perfected my skills; I now possess an impressive knowledg 更多
Dear Sir, I have carefully reviewed your instructions and I am confident that I can complete this project efficiently. I would appreciate the opportunity to work on this project, and I assure you that I will deliver h 更多
I can complete this macro in few hours, I have reviewed your project and I am ready to start right away. I will be responsive and provide you expected result within deadline.
Being an experienced programmer, specializing in data analytics and processing with Excel VBA, I am well-equipped to tackle and complete the task in a timely manner. Having a deep understanding of macros and formula fu 更多
Greetings, Having carefully reviewed your project description, I am confident in my ability to execute this project to perfection. I possess a broad spectrum of skills, knowledge, and experience in this specific fiel 更多
I will do this project better way because I'm expert data entry data processing and web search and it's related work so I want to give me this project Thanks
I am do this work ferpectly so give me this and I am best man for this project so you give me this . And I am sure you satisfy of my work
As a seasoned data analyst, I am well-acquainted with working on complex Excel macros and Power Pivot solutions that streamline large quantities of information. Your project to create a quantity calculation function fo 更多
Hello, My name is Harsh. I am writing to you for the position of data entry expert that you are looking for an urgent basis. Data entry job is my passion and I have 1+ years of experiences in this field that makes me 更多