BOM excel progam

Ολοκληρωμένο Αναρτήθηκε Πριν 4 χρόνια Πληρώθηκε κατά την παράδοση
Ολοκληρωμένο Πληρώθηκε κατά την παράδοση

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

Ταυτότητα Εργασίας: #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 freelancers κάνουν προσφορές κατά μέσο όρο $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