AutoCAD Electrical Forum
Welcome to Autodesk’s AutoCAD Electrical Forums. Share your knowledge, ask questions, and explore popular AutoCAD Electrical topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Bill of Material Compare/Revision

5 REPLIES 5
Reply
Message 1 of 6
aseaborn
542 Views, 5 Replies

Bill of Material Compare/Revision

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?

5 REPLIES 5
Message 2 of 6
dougmcalexander
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


Design Engineer/Consultant/Instructor/Mentor specializing in AutoCAD Electrical training and implementation support

Phone and Web-based Support Plans Available

Phone: (770) 841-8009

www.linkedin.com/in/doug-mcalexander-1a77623




Please Accept as Solution if I helped you. Likes are also much appreciated.
Message 3 of 6
aseaborn
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. Smiley Happy

 

Thanks again for the response!

 

 

Message 4 of 6
drathak
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
Principle Associate Engineer - Nashville Electric Service
P&C Committee Chair – SDS Industry Consortium
Message 5 of 6
Icemanau
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
AutoCAD Electrical User and IT Hardware Support

Message 6 of 6
aseaborn
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.

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report

”Boost