BOM excel progam
$250-750 USD
Оплачується при отриманні
We are engineers who use AutoCAD. We need a post process program that will manipulate and transfer excel files from AutoCAD's native BOM to fit our factory BOM form. The AutoCAD output is not in the column order we want to appear in the BOM and is not sorted on TAGS, which is the component description. Additionally, the numbers shown for QTY are not actually numbers but General text so can't be manipulated like numbers.
The BOM file is what we use for assembly. To match the BOM the columns in the AutoCAD output have to be extracted, formatted as necessary, sorted in order and suborder (ie A - Z and A1, A2, A3 - An) and some special character tags (A's X's) and their associated data placed in different parts of the spreadsheet. Not all columns of the BOM will be populated. The method should comprise either a macro or VBA program that can operate on an output of at least 200 entries. Excel format is required. Alternately, we would also consider a AutoCAD Lisp program running inside AutoCAD as a post process script. I've attached examples of the AutoCAD output and what we are looking for.
Cheers
ID Проекту: #19878551
Про проект
37 фрілансерів(-и) готові виконати цю роботу у середньому за $418
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl Більше
Hello, I’m an Excel VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
Hi, Had a look at the AutoCAD csv file and the desired Excel output template. Have a few queries regarding the Designation column, which I shall clarify if we go ahead with the project. I can handle the project and Більше
Greetings! Thanks for detailed Project Description. I have reviewed both the attachments and understand the conversion requirements. I can write a macro to convert the data in CSV to BOM Template format. Being a full Більше
Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered over hundred excel vba projects in the last one year. Willing to take up your project. As you can see, My bid is for VBA Більше
Hi, I can create a VBA script to import the AutoCAD csv file and transform data in needed format with one click on a button. Best regards, Florin Enache
Good Day ! I am an Architect by Profession. I have a 15 years of experience in Design and Construction Industry. I am excellent in AutoCAD Software and Space Planning that is my strongest skills to help you out acco Більше
Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I plan to complete the project via writing an Excel macro co Більше
Hi there, I am interested in the project. I have reviewed the files and I am sure I can provide you the exact solution you are looking for. I can write vba code to build the required files from Autocad output file.
Hello, I have taken a look at the files and instructions and I am happy to create a macro for you that will convert the output from AutoCAD to your required format with a click o a button. I have strong attentio Більше
Hi. How are you? I read your description carefully and am very interesting in your project. I can start right now and can help you. If you hire me,i will do my best for your job and you can get the best results. Lookin Більше
Hi! My name is Jovita! I am experienced graduate Master student! I would be glad to work with you and enrich my portfolio!
I hope I can do this using a Python Script or by VBA for Excel. Whatever you prefer. I have expertise on both.
I am mechanical design engineer hving experience in reputed multinational firm. I have handled so many such projects. Hoping for some positive feedback from you
I went through the attached files and it seems one with the picture is your BOM form and the csv is your output. So we would need a macro to rearrange columns. I would build that for you and provide you with samples.
good evening .. i understand what do you want ... if we agreement for price , you can receive your work after agreement about 3 days only nice to meet you