{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Home","Old BOM","New BOM","BlankPage","DevFrame","WelcomePage"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":169,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Home","index":0,"n_rows":74,"n_cols":8,"rows_kept":74,"cut":false,"hidden":false,"merged":[[53,4,53,5],[50,4,50,5],[46,4,46,5],[5,4,5,5],[34,4,35,4]]}
["DevFrame settings",null,"H",null,null,null,null,"HL"]
["HiddenStatus","VISIBLE",null,null,null,"ENGINEXCEL"]
["ProtectSheet",true,null,null,null,"Email: alessandro@enginexcel.com"]
["HeadingsVisibility",false,null,null,null,"Website: www.enginexcel.com"]
["GridlineVisibility",false]
[null,null,null,null,"BOM COMPARISON"]
["Protection settings"]
["DrawingObjects",true]
["Contents",true]
["Scenarios",true,null,null,"Introduction"]
["UserInterfaceOnly",true,null,null,"This spreadsheet allows to automatically compare two BOMs and show the differences. "]
["AllowFormattingCells",false]
["AllowFormattingColumns",false,null,null,"Features"]
["AllowFormattingRows",false,null,null,"- BOM selection"]
["AllowInsertingColumns",false,null,null,"      - BOM can be selected from different locations/spreadsheets"]
["AllowInsertingRows",false,null,null,"      - No BOM size constraints"]
["AllowInsertingHyperlinks",false,null,null,"      - Automatic verification of BOMs congruence"]
["AllowDeletingColumns",false,null,null,"- Duplicates analysis"]
["AllowDeletingRows",false,null,null,"      - Duplicate components are automatically added"]
["AllowSorting",false,null,null,"      - If preferred, the user has the option to be notified if there are duplicate parts"]
["AllowFiltering",false,null,null,"- BOM comparison"]
["AllowUsingPivotTables",false,null,null,"      - Automated BOM comparison"]
["EnableSelection",true,null,null,"      - Selection of results display order: alphabetical, old BOM order, new BOM order"]
[null,null,null,null,"- Display results"]
["Other settings",null,null,null,"      - Result automatically formatted"]
["MarkProtectedCellsStatus",false,null,null,"      - Results can be filtered"]
["RowColumnDimensionStatus",false,null,null,"- Add-in for Excel available"]
[]
[null,null,null,null,"Instructions"]
[null,null,null,null,"Operation","How to"]
[null,null,null,null,"How to start the BOM comparison tool","Click on \"Run BOM comparison\" button in the \"Old bom\" page or in the \"New bom\" page (they will both open the same page)."]
[null,null,null,null,"How to start the BOM comparison tool (add-in version)","Click on the \"BOM comparison\" button in the EnginExcel add-in bar."]
[null,null,null,null,"How to select the old BOM","Open the BOM comparison tool.\nClick on the button under \"Select the OLD bom range (including titles):\".\nSelect the cells where the old BOM is. The titles must be included in the selection and must occupy the first row.\nDo not select empty cells or the entire columns."]
[null,null,null,null,"How to select the new BOM","Open the BOM comparison tool.\nClick on the button under \"Select the NEW bom range (including titles):\".\nSelect the cells where the new BOM is. The titles must be included in the selection and must occupy the first row.\nDo not select empty cells or the entire columns."]
[null,null,null,null,"How to launch a comparison","Open the BOM comparison tool.\nSelect the old and the new BOMs.\nClick on \"Next -->\".\nFrom the dropdown menu select the unique identifier column (the column that contains the part number, which must be unique for each part)."]
[null,null,null,null,null,"From the dropdown menu select the quantity column.\nClick on \"OK\"."]
[null,null,null,null,"How to define the order in which results will be displayed","Open the BOM comparison tool.\nClick on \"Options\" button.\nSelect one of the options in the area marked \"Results order?\""]
[null,null,null,null,null,"ALPHABETICAL ORDER: results are ordered alphabetically by the unique identifier column. This option is the quickest to compute."]
[null,null,null,null,"What the results order options mean","OLD BOM ORDER: results are ordered following the order of the OLD bom. This is preferred if you want to refer to the OLD bom to manually transcribe the results."]
[null,null,null,null,null,"NEW BOM ORDER: results are ordered following the order of the NEW bom. This is preferred if you want to refer to the NEW bom to manually transcribe the results."]
[null,null,null,null,"How to define if duplicate parts (parts that appear more than once in the BOM) will be automatically joined.","Open the BOM comparison tool.\nClick on \"Options\" button.\nSelect one of the options in the area marked \"Automatically combine duplicate parts?\"."]
[null,null,null,null,null,"This option allows to define if you desire to automatically combine parts that appear more than once in the BOM."]
[null,null,null,null,"What \"Automatically combine duplicate parts?\" means","YES: parts that appear more than once in the BOM are combined. This means that the duplicate parts will be shown only once, and the quantity shown will be the sum of all the quantities of the parts that have been recombined."]
[null,null,null,null,null,"NO: if a part appears more than once, a message is shown to the user and the duplicate parts highlighted. The user can manually remove the duplicate parts."]
[]
[null,null,null,null,"Terms of use"]
[null,null,null,null,"EnginExcel standard terms of use apply to this spreadsheet. For more info see: "]
[null,null,null,null,"http://enginexcel.com/terms-of-use"]
[]
[null,null,null,null,"Disclaimer"]
[null,null,null,null,"Although the author has attempted to find and correct any bugs in the spreadsheet, the author is not responsible for any damage or losses of any kind caused by the use or misuse of the spreadsheet.\nThe author is under no obligation to provide support, service, corrections, or upgrades to the spreadsheet.\nFor more information, please send an email to the author (see contacts on top of the page)."]
[]
[null,null,null,null,"Compatibility"]
[null,null,null,null,"The compatibility of this spreadsheet has been verified on:"]
[null,null,null,null," - Microsoft Excel 2007"]
[null,null,null,null," - Microsoft Excel 2010"]
[null,null,null,null," - Microsoft Excel 2013"]
[null,null,null,null," - Microsoft Excel 365"]
[]
[null,null,null,null,"Version history"]
[null,null,null,null,"1.0   -   22/06/2018","First release"]
[null,null,null,null,"1.1   -   29/01/2019","Removed bug when comparing numbers with more than 8 digits."]
[null,null,null,null,"1.2   -  13/08/2019","Fixed issue when comparing part numbers with numbers only."]
[null,null,null,null,"1.3   -  30/06/2020","Fixed issue when part numbers are preceded by zeros."]
[null,null,null,null,"1.4   -  31/07/2020","Fixed issue when quantities are saved as text."]
[null,null,null,null,"1.5   -  14/03/2021","Handled exception when worksheet sources have the same file name. \nHandled exception when user selects the whole column."]
[null,null,null,null,"1.6   -  16/06/2021","Handled exception when using alphabetical order comparison and no part numbers are matching."]
[null,null,null,null,"1.7   -  02/09/2025","Corrected issue with RefEdit"]
[]
[null,null,null,null,"Copyright"]
[null,null,null,null,"EnginExcel, All rights reserved"]
[]
[]
[null,null,"HL"]

{"sheet":"Old BOM","index":1,"n_rows":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,8,3,13]]}
["DevFrame settings",null,"H"]
["HiddenStatus","VISIBLE",null,null,null,null,null,null,"OLD BOM"]
["ProtectSheet",true]
["HeadingsVisibility",false]
["GridlineVisibility",true]
[null,null,null,null,"Part No","Description","Qty","Material"]
["Protection settings",null,null,null,"AAA.01","Motor",1,"Stainless steel"]
["DrawingObjects",false,null,null,"AAA.02","Gearbox",1,"Aluminium"]
["Contents",true,null,null,"AAA.03","Nut",15,"Stainless steel"]
["Scenarios",true,null,null,"AAA.04","Shaft 1",2,"Stainless steel"]
["UserInterfaceOnly",true,null,null,"AAA.06","Body",1,"Aluminium"]
["AllowFormattingCells",true,null,null,"AAA.07","Holder",1,"Stainless steel"]
["AllowFormattingColumns",true,null,null,"AAA.08","Wheel",4,"Stainless steel"]
["AllowFormattingRows",true,null,null,"AAA.09","Spring",40,"Stainless steel"]
["AllowInsertingColumns",false,null,null,"AAA.10","Shaft 3",3,"Stainless steel"]
["AllowInsertingRows",false,null,null,"AAA.11","Beam",1,"Stainless steel"]
["AllowInsertingHyperlinks",false,null,null,"AAA.12","Screw",22,"Stainless steel"]
["AllowDeletingColumns",false,null,null,"AAA.13","Screwing tool",1,"Aluminium"]
["AllowDeletingRows",false,null,null,"AAA.14","Bearing",6,"Ptfe"]
["AllowSorting",true,null,null,"AAA.15","Linear bearing",2,"Stainless steel"]
["AllowFiltering",true,null,null,"AAA.16","Ring",3,"Stainless steel"]
["AllowUsingPivotTables",false,null,null,"AAA.17","Eye bolt",1,"Stainless steel"]
["EnableSelection",true,null,null,"AAA.18","Washer",22,"Stainless steel"]
[null,null,null,null,"AAA.19","Cam",1,"Steel"]
["Other settings"]
["MarkProtectedCellsStatus",true]
["RowColumnDimensionStatus",true]
[]
[]
[]
["TableStart"]
["TableStartRow",{"$f":"ROW(TableStart)","v":6}]
["TableStartColumn",{"$f":"COLUMN(TableStart)","v":5}]

{"sheet":"New BOM","index":2,"n_rows":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,8,3,13]]}
["DevFrame settings",null,"H"]
["HiddenStatus","VISIBLE",null,null,null,null,null,null,"NEW BOM"]
["ProtectSheet",true]
["HeadingsVisibility",false]
["GridlineVisibility",true]
[null,null,null,null,"Part No","Description","Qty","Material"]
["Protection settings",null,null,null,"AAA.01","Motor",1,"Stainless steel"]
["DrawingObjects",false,null,null,"AAA.03","Nuts",15,"Stainless steel"]
["Contents",true,null,null,"AAA.04","Shaft 1",3,"Stainless steel"]
["Scenarios",true,null,null,"AAA.05","Shaft 2",2,"Stainless steel"]
["UserInterfaceOnly",true,null,null,"AAA.06","Body",1,"Aluminium"]
["AllowFormattingCells",true,null,null,"AAA.07","Holder",2,"Aluminium"]
["AllowFormattingColumns",true,null,null,"AAA.08","Wheel",4,"Ptfe"]
["AllowFormattingRows",true,null,null,"AAA.09","Spring",35,"Aluminium"]
["AllowInsertingColumns",false,null,null,"AAA.10","Shaft 4",4,"Stainless steel"]
["AllowInsertingRows",false,null,null,"AAA.11","Beam",1,"Stainless steel"]
["AllowInsertingHyperlinks",false,null,null,"AAA.12","Screw",22,"Stainless steel"]
["AllowDeletingColumns",false,null,null,"AAA.13","Screwing tool",1,"Aluminium"]
["AllowDeletingRows",false,null,null,"AAA.14","Bearing",6,"Ptfe"]
["AllowSorting",true,null,null,"AAA.15","Linear bearing",3,"Stainless steel"]
["AllowFiltering",true,null,null,"AAA.16","Ring",3,"Stainless steel"]
["AllowUsingPivotTables",false,null,null,"AAA.17","Eye bolt",1,"Stainless steel"]
["EnableSelection",true,null,null,"AAA.18","Washer",22,"Stainless steel"]
[null,null,null,null,"AAA.19","Cam",2,"Steel"]
["Other settings"]
["MarkProtectedCellsStatus",true]
["RowColumnDimensionStatus",true]
[]
[]
[]
["TableStart"]
["TableStartRow",{"$f":"ROW(TableStart)","v":6}]
["TableStartColumn",{"$f":"COLUMN(TableStart)","v":5}]

{"sheet":"BlankPage","index":3,"n_rows":33,"n_cols":17,"rows_kept":33,"cut":false,"hidden":true,"merged":[[1,8,3,13]]}
["DevFrame settings",null,"H",null,null,null,null,null,null,null,null,null,null,null,null,null,"HL"]
["HiddenStatus","VERY HIDDEN",null,null,null,null,null,null,"OLD BOM"]
["ProtectSheet",false]
["HeadingsVisibility",false]
["GridlineVisibility",false]
[]
["Protection settings"]
["DrawingObjects",true]
["Contents",true]
["Scenarios",true]
["UserInterfaceOnly",false]
["AllowFormattingCells",false]
["AllowFormattingColumns",false]
["AllowFormattingRows",false]
["AllowInsertingColumns",false]
["AllowInsertingRows",false]
["AllowInsertingHyperlinks",false]
["AllowDeletingColumns",false]
["AllowDeletingRows",false]
["AllowSorting",false]
["AllowFiltering",false]
["AllowUsingPivotTables",false]
["EnableSelection",false]
[]
["Other settings"]
["MarkProtectedCellsStatus",true]
["RowColumnDimensionStatus",false]
[]
[]
[]
["TableStart"]
["TableStartRow",{"$f":"ROW(TableStart)","v":6},"HL"]
["TableStartColumn",{"$f":"COLUMN(TableStart)","v":5}]

{"sheet":"DevFrame","index":4,"n_rows":38,"n_cols":6,"rows_kept":38,"cut":false,"hidden":true,"merged":[]}
["DevFrame settings",null,"H"]
["HiddenStatus","VERY HIDDEN",null,"HiddenStatuses","TrueFalse"]
["ProtectSheet",false,null,"VISIBLE",true]
["HeadingsVisibility",true,null,"HIDDEN",false]
["GridlineVisibility",true,null,"VERY HIDDEN"]
[]
["Protection settings",null,null,"ProgrammingMode","Password","DevFramePassword"]
["DrawingObjects",true,null,false,"Password","EnginExce1"]
["Contents",true]
["Scenarios",true,null,"AllowAddSheet"]
["UserInterfaceOnly",false,null,true]
["AllowFormattingCells",false]
["AllowFormattingColumns",false]
["AllowFormattingRows",false]
["AllowInsertingColumns",false,null,null,"DEVELOPMENT FRAME"]
["AllowInsertingRows",false,null,"Features:"]
["AllowInsertingHyperlinks",false,null,"- Define visibility status of each sheet"]
["AllowDeletingColumns",false,null,"- Define which cells to protect"]
["AllowDeletingRows",false,null,"- Protect sheet with password"]
["AllowSorting",false,null,"- Define if to show the headings of each page"]
["AllowFiltering",false,null,"- Define if to show the gridline in each page"]
["AllowUsingPivotTables",false,null,"- Dev frame is protected by separate password"]
["EnableSelection",false,null,"- Define which rows and columns to hide"]
[null,null,null,"      - Rows and columns with \"H\" are hidden"]
["Other settings",null,null,"      - From the last \"H\", all the following rows (or columns) are hidden"]
["MarkProtectedCellsStatus",true]
["RowColumnDimensionStatus",false,null,"Activation:"]
[null,null,null,"- Activate development frame: CTRL + r"]
[null,null,null,"- Protect a selected cell: CTRL + p"]
[null,null,null,"- Unprotect a selected cell: CTRL + o"]
[]
[null,null,null,"Version control:"]
[null,null,null,"Version","Release date","Changed features"]
[null,null,null,"1.0","2017-01-08","First issue"]
[null,null,null,"1.1","2017-01-18","Updated SubErrorHandler (writes log file"]
[null,null,null,"1.2","2017-02-10","Added EnableSelection option"]
[null,null,null,"1.4","2017-03-10","Added UserInterfaceOnly renewal at workbook open"]
[null,null,null,"1.5","2017-05-21","Added TableStart variable and HL row-hiding parameter"]

{"sheet":"WelcomePage","index":5,"n_rows":51,"n_cols":17,"rows_kept":51,"cut":false,"hidden":true,"merged":[[5,4,5,9],[12,4,12,9],[22,4,22,9]]}
["DevFrame settings",null,"H",null,null,null,null,null,null,null,null,null,null,null,null,null,"HL"]
["HiddenStatus","VERY HIDDEN"]
["ProtectSheet",false]
["HeadingsVisibility",false]
["GridlineVisibility",false]
[null,null,null,null,"COUNTERS"]
["Protection settings"]
["DrawingObjects",true,null,null,"OpenedTimes",0]
["Contents",true,null,null,"NotShowAgain",false]
["Scenarios",true,null,null,"ProtectedView",false]
["UserInterfaceOnly",true]
["AllowFormattingCells",false]
["AllowFormattingColumns",false,null,null,"MESSAGES RELATED TO SPREADSHEET"]
["AllowFormattingRows",false]
["AllowInsertingColumns",false,null,null,"SpreadsheetName"]
["AllowInsertingRows",false,null,null,"BOM comparison"]
["AllowInsertingHyperlinks",false]
["AllowDeletingColumns",false,null,null,"VideoLink"]
["AllowDeletingRows",false,null,null,"https://youtu.be/-4HIo7ERw8s"]
["AllowSorting",false]
["AllowFiltering",false]
["AllowUsingPivotTables",false]
["EnableSelection",false,null,null,"MESSAGES VALID FOR ALL SPREADSHEETS"]
[]
["Other settings",null,null,null,"WelcomeText"]
["MarkProtectedCellsStatus",false,null,null,"Thanks for downloading EnginExcel free material."]
["RowColumnDimensionStatus",false,null,null,{"$f":"\"A quick introductory video on \"  & SpreadsheetName &  \" main functionalities is linked below.\"","v":"A quick introductory video on BOM comparison main functionalities is linked below."}]
[]
[null,null,null,null,"ButtonText"]
[null,null,null,null,"Introductory video"]
["TableStart"]
["TableStartRow",{"$f":"ROW(TableStart)","v":{"$error":"#NAME?"}},"HL",null,"FreeMaterialText"]
["TableStartColumn",{"$f":"COLUMN(TableStart)","v":{"$error":"#NAME?"}},null,null,"If you like this spreadsheet please consider subscribing to EnginExcel free material newsletter. You will receive an email when a new free spreadsheet is released."]
[]
[null,null,null,null,"ButtonText2"]
[null,null,null,null,"Open subscription page"]
[]
[null,null,null,null,"FreeMaterialLink"]
[null,null,null,null,"http://enginexcel.com/newsletter"]
[]
[null,null,null,null,"ReminderText1"]
[null,null,null,null,"If you are enjoying this spreadsheet please consider subscribing to EnginExcel newsletter. You will receive an email when a new free spreadsheet is released."]
[]
[null,null,null,null,"ReminderText2"]
[null,null,null,null,"EnginExcel provides consultancy to develop customised spreadsheets for Mechanical Engineers and Project Managers using Microsoft Excel and Visual Basic for Applications (VBA)."]
[]
[null,null,null,null,"ButtonText3"]
[null,null,null,null,"See how I can help you"]
[]
[null,null,null,null,"ServicesLink"]
[null,null,null,null,"http://enginexcel.com/what-i-do"]