BOM excel progam

Completato Pubblicato 4 anni fa Pagato alla consegna
Completato Pagato alla consegna

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

Rif. progetto: #19878551

Info sul progetto

37 proposte Progetto a distanza Attivo 4 anni fa

Assegnato a:

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 Altro

$295 USD in 14 giorni
(6 valutazioni)
4.4

37 freelance hanno fatto un'offerta media di $418 per questo lavoro

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. Altro

$555 USD in 10 giorni
(216 valutazioni)
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 Altro

$750 USD in 10 giorni
(384 valutazioni)
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 in 3 giorni
(435 valutazioni)
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 Altro

$300 USD in 3 giorni
(202 valutazioni)
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 Altro

$250 USD in 3 giorni
(226 valutazioni)
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 Altro

$250 USD in 7 giorni
(59 valutazioni)
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 Altro

$555 USD in 2 giorni
(136 valutazioni)
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 Altro

$250 USD in 3 giorni
(52 valutazioni)
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 in 3 giorni
(23 valutazioni)
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 Altro

$500 USD in 4 giorni
(40 valutazioni)
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 Altro

$250 USD in 2 giorni
(64 valutazioni)
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 in 7 giorni
(34 valutazioni)
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 Altro

$250 USD in 3 giorni
(59 valutazioni)
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 Altro

$500 USD in 7 giorni
(11 valutazioni)
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 Altro

$500 USD in 3 giorni
(1 Recensione)
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 in 5 giorni
(0 valutazioni)
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 in 7 giorni
(0 valutazioni)
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 in 10 giorni
(0 valutazioni)
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 in 10 giorni
(0 valutazioni)
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 in 10 giorni
(0 valutazioni)
0.0