I would like to introduce to you my program ExcelBOMComparer – program for every steel designer and Tekla Structures user. This program compares two bill of materials from different revisions and marks result in excel files using yellow and red colours. It can save a lot of time.
What is the ExcelBOMComparer program for?
The Excel BOM Comparer is a tool designed to compare Bills of Materials (BOM) for steel structures contained in Excel worksheets. It automatically compares two BOMs from different project revisions, using item numbers (part positions) as the basis for comparison. This fully automated process can save a significant amount of time. The program searches for the element number from the newer list in the older list, and when a match is found, it compares the entire row from the newer list with the corresponding row in the older list. This comparison identifies whether an item has been modified, deleted, or added to the list.
The comparison results are saved to a new Excel sheet. Rows with changed elements are highlighted in yellow, and the changed values are marked in red. The old values are also copied to each changed row to verify the accuracy of the comparison. For each modified line, a comment is added to indicate what changes have occurred. The list of deleted items appears at the end of the sheet. The results are available within one minute!
Open Excel Comparer → Select two excel files → Compare → Check results
✅ Best for Steel structures Bill of Materials
✅ Compare two excel sheets you don’t need Tekla Structures
✅ Inteligent part comparing, not only excel values
✅ Improve your revisions
Monthly subscription
-
Customise your price
-
Select number of licenses
-
Excel BOM Comparer
Yearly subscription
save 16%-
Customise your price
-
Select number of licenses
-
Excel BOM Comparer
Download → Test for free 21 days → Buy license
Main window of the program:
Bellow is an example of compared table:
Example of comments:
Deleted positions:
Full size example
Please note that the program compares raw data from Excel tables. The program does not know what these data mean – it does not know that something is the name of the material, the name of the section’s cross section, the mass or the name of the element. Before starting the comparison, remove all data that you do not want to compare, otherwise the program may mark it as changed. You should also remove the comments after the previous compare operation, as the program may consider them to be old item data and mark them as changed values.
The item number is the key by which the program searches for data in the old sheet. This key must not be repeated on lists (Bills of Materials, Single-Item Lists, Assembly Lists, Shipping Item Lists, Drawing Lists, etc.). Before comparing lists, enter the column number of the table where the key is located. Incorrectly given column number causes incorrect comparison results.
The key can be the drawing number (if it is unique) then we can compare lists of drawings.
Video tutorial:
Download example excel files
Here are example excel bills of material after comparision with older version:
- Normal list – where part number is only once:
https://ddbim.com/downloads/ecprixuv/Compared_normal_list_parts.xlsx
https://ddbim.com/downloads/ecprixuv/Compared_normal_list_parts.pdf - Structural list – where parts are in assemblies – part numbers are more than once
https://ddbim.com/downloads/ecprixuv/Compared_assembly_structural_list.xlsx
https://ddbim.com/downloads/ecprixuv/Compared_assembly_structural_list.pdf
Monthly subscription
-
Customise your price
-
Select number of licenses
-
Excel BOM Comparer
Yearly subscription
save 16%-
Customise your price
-
Select number of licenses
-
Excel BOM Comparer