BOM excel progam

Виконано Опубліковано %project.relative_time Оплачується при отриманні
Виконано Оплачується при отриманні

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

AutoCAD Excel Visual Basic

ID Проекту: #19878551

Про проект

37 заявок(-ки) Дистанційний проект Остання активність 4 роки(ів) тому

Доручено:

adcdao

Hi, I'm a CAD programmer for over 25 years. I created many application for AutoCAD using Autolisp, VBA, VB .Net and ObjectARX (C++). Many applications I did use Excel for data importation/exportation. I'm also an ADN Більше

$295 USD за 14 дні(-в)
(6 відгуків(-и))
4.4

37 фрілансерів(-и) готові виконати цю роботу у середньому за $418

asin1987

Dear Employer, I perfectly understand the issue you are facing. So basically example of like row 2-4 have data for TAGs J1X which are coming in 3 rows. Now you want to add the data and present everything in one row. Більше

$555 USD за 10 дні(-в)
(216 відгуків(и))
7.9
schoudhary1553

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 Більше

$750 USD за 10 дні(-в)
(384 відгуків(и))
8.1
P0L

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.

$300 USD за 3 дні(-в)
(435 відгуків(и))
7.7
deepbluetech

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 Більше

$300 USD за 3 дні(-в)
(202 відгуків(и))
7.4
ksriniravi

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 Більше

$250 USD за 3 дні(-в)
(226 відгуків(и))
7.0
dvcontact

Hi, Would you like to see a quick demo of your project on developing program that will manipulate and transfer Excel files from AutoCAD to fit your factory BOM form completed before you award the project? You can consi Більше

$250 USD за 7 дні(-в)
(59 відгуків(и))
6.5
periyannas

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 Більше

$555 USD за 2 дні(-в)
(136 відгуків(и))
6.6
tuongeng4

Hi there! dear client ! Build Point cloud to Polygon object is happy for me i very interesting with your job , I ready to work for you now...... special is the project design structural with USA code.i will supply f Більше

$250 USD за 3 дні(-в)
(52 відгуків(и))
5.9
afenache

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

$300 USD за 3 дні(-в)
(23 відгуків(и))
5.7
arkitekFRIDAY

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 Більше

$500 USD за 4 дні(-в)
(40 відгуків(и))
5.7
nagybatonyi

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 Більше

$250 USD за 2 дні(-в)
(64 відгуків(и))
5.7
DebasisB

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.

$500 USD за 7 дні(-в)
(34 відгуків(и))
5.5
sorinacho88

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 Більше

$250 USD за 3 дні(-в)
(59 відгуків(и))
5.3
xinglong717

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 Більше

$500 USD за 7 дні(-в)
(11 відгуків(и))
4.2
ektasethi

Hi: I am a BI Expert. I enable any organisations' data breathe.....Automating Excels & easing the routine job is my passion.... I can automate your project in Tableau which will provide the outcome you are desir Більше

$500 USD за 3 дні(-в)
(1 відгук)
2.0
jovitamarkuckyt

Hi! My name is Jovita! I am experienced graduate Master student! I would be glad to work with you and enrich my portfolio!

$555 USD за 5 дні(-в)
(0 відгуків(и))
0.0
idealinnovation

I hope I can do this using a Python Script or by VBA for Excel. Whatever you prefer. I have expertise on both.

$250 USD за 7 дні(-в)
(0 відгуків(и))
0.0
prathutulsankar

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

$250 USD за 10 дні(-в)
(0 відгуків(и))
0.0
rk1249

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.

$555 USD за 10 дні(-в)
(0 відгуків(и))
0.0
ahmedtaha1016

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

$555 USD за 10 дні(-в)
(0 відгуків(и))
0.0