AutoCAD Electrical General

Reply
Contributor
aseaborn
Posts: 13
Registered: ‎06-02-2011
Message 1 of 6 (355 Views)

Bill of Material Compare/Revision

355 Views, 5 Replies
06-08-2011 02:18 PM

Is there a way to capture BOM changes? For example, I build a project, create a BOM, export it to an Excel file, and send to purchasing. A week later, the customer changes something that causes me to add/delete components. Is there a tool to highlight the changes and capture them on my new BOM?

*Expert Elite*
dougmcalexander
Posts: 2,990
Registered: ‎10-18-2003
Message 2 of 6 (347 Views)

Re: Bill of Material Compare/Revision

06-08-2011 07:16 PM in reply to: aseaborn

There are programs like Beyond Compare which can compare the differences between files and folders.  You could export the original and the new BOM and check with Beyond Compare.  There is no built-in compare utility.  If you were to put your BOM on a drawing you don't need to merge the new and old.  You can update the existing BOM with the data from the new BOM.  This is an option when you select to Put On Drawing and the software sees that the BOM already exists on the drawing.  It will even update a multi-page BOM.  But again, the software doesn't highlight what what was changed.

Doug McAlexander
Independent Consultant/Instructor/Mentor specializing in AutoCAD Electrical, ecscad, and promis-e implementation

Web site: www.ECADConsultant.com
Phone: (770) 841-8009

Please Accept as Solution if I helped you. Kudos are also much appreciated.
Contributor
aseaborn
Posts: 13
Registered: ‎06-02-2011
Message 3 of 6 (344 Views)

Re: Bill of Material Compare/Revision

06-08-2011 09:04 PM in reply to: aseaborn

Thanks for the response. Due to our purchasing procedures, we will need the changes highlighted in some way. I will check out some 3rd party tools. Worst case, I can write a VB script to do it, but I did not want to re-invent the wheel. :smileyhappy:

 

Thanks again for the response!

 

 

Mentor
drathak
Posts: 347
Registered: ‎05-21-2008
Message 4 of 6 (267 Views)

Re: Bill of Material Compare/Revision

11-06-2012 01:47 PM in reply to: aseaborn

aseaborn wrote:

Is there a way to capture BOM changes? For example, I build a project, create a BOM, export it to an Excel file, and send to purchasing. A week later, the customer changes something that causes me to add/delete components. Is there a tool to highlight the changes and capture them on my new BOM?


How did you resolve this?  I need a similar solution except that I need to compare between revisions of a project.  I need to compare what is existing to the new changes being planned.  I need to detail material changes as well as wiring changes if at all possible.

--------------
Joe Weaver
Principal Associate Engineer
Nashville Electric Service
*Expert Elite*
Icemanau
Posts: 909
Registered: ‎06-01-2010
Message 5 of 6 (259 Views)

Re: Bill of Material Compare/Revision

11-06-2012 03:31 PM in reply to: drathak

For dwg revisions it depends on how the revision are made and your dwg control system.

 

For example, if the dwgs are updated outside your orginisation, you can Mark dwgs before sending them off and verify them when they are returned. The resulting report will list all the changes made to the dwg.

 

This can also be done when the changes are done in house.

 

Regards Brad

Icemanau (NNTP handle: Brad Coleman)


Contributor
aseaborn
Posts: 13
Registered: ‎06-02-2011
Message 6 of 6 (245 Views)

Re: Bill of Material Compare/Revision

11-07-2012 06:17 AM in reply to: aseaborn

I ended up writing a vbscript that took the excel file output of the BOM and compared the two and highlighted any differences. If your BOM has a standard format with a predetermined number of columns and order, then it is a pretty easy sscript to write.

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Announcements
Manufacturing Community
The Manufacturing Community provides additional access to tips, tutorials, blogs and networking with peers.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

New AutoCAD Electrical Category!

The AutoCAD Electrical forum has moved into it's very own category page, and can no longer be found within the Additional Product Forums.

Ask the Community