CN105302781A - Method for fast BOM comparison - Google Patents
Method for fast BOM comparison Download PDFInfo
- Publication number
- CN105302781A CN105302781A CN201510796766.XA CN201510796766A CN105302781A CN 105302781 A CN105302781 A CN 105302781A CN 201510796766 A CN201510796766 A CN 201510796766A CN 105302781 A CN105302781 A CN 105302781A
- Authority
- CN
- China
- Prior art keywords
- bom
- comparison
- row
- original
- sub
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/12—Use of codes for handling textual entities
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Investigating Or Analysing Biological Materials (AREA)
Abstract
The invention discloses a method for fast BOM comparison. The method includes the following steps that S1, not less than one original BOM needing to be compared is acquired; S2, each row of data in the original BOM serve as a mother row, each mother row is decomposed into a plurality of sub-rows according to a plurality of elements contained a corresponding splitting object, a cell of the splitting object corresponding to each sub-row contains elements in the splitting object, and remaining cells in each sub-row and corresponding cells of the corresponding mother row are the same in content; S3, comparison BOMs composed of the sub-rows are acquired; S4, searching comparison of the comparison BOMs is performed according to a searching function and a logic function, and whether a difference exists or not is judged. According to the method for fast BOM comparison, the difference of two BOMs can be efficiently and fast compared, BOM accuracy is checked, it is guaranteed that accurate BOMs are made, and unnecessary loss of manufactured products caused by BOM errors are avoided. The method can be applied to production and manufacturing enterprises.
Description
Technical field
The present invention relates to BOM correlation technique field, particularly relate to a kind of method of quick comparison BOM.
Background technology
In manufacturing enterprise, BOM (BillofMaterial, Bill of Material (BOM)) file is the file of a very core.BOM is one and illustrates that product is made up of which parts, starting material, and these starting material, parts the file of the information such as quantity, attribute description.Understand in the narrow sense, BOM file is exactly a file all raw material of composition product being carried out simple decomposition according to raw-material physical arrangement according to certain division rule.
The activity of each department all will use Bill of Material (BOM), production division will produce product according to Bill of Material (BOM), storehouse will carry out issuance of materials according to Bill of Material (BOM), treasurer's department will assess the cost according to Bill of Material (BOM), sale and order typing department will by the configurations of Bill of Material (BOM) determination customization product, maintenance service department will understand to need what spare part by Bill of Material (BOM), according to Bill of Material (BOM), Quality Control Department will ensure that product is correctly produced, planning authorities will carry out the demand of planning material and ability according to Bill of Material (BOM), etc.Therefore, guarantee that the accuracy of BOM is very important.
Visible, the quality of accuracy to output product of the manufacturing BOM that developer provides plays conclusive effect.In the production of enterprise product, have and much cause product bad even needs of producing to scrap process because of BOM problem.Usually, in order to ensure the accuracy of BOM, we can spend a large amount of time and efforts stonings pair, and efficiency is low, and the accuracy of final BOM still cannot ensure.
Summary of the invention
Based on the technical matters that background technology exists, the present invention proposes a kind of method of quick comparison BOM.
The method of a kind of quick comparison BOM that the present invention proposes, comprises the following steps:
S1, acquisition needs carry out the original BOM being no less than portion contrasted, and comprise and be no less than the cell that can be used as fractionation object in original BOM at least one column unit lattice, split in object to comprise to be no less than an element;
S2, using each row of data in original BOM as mother's row, according to splitting the multiple elements comprised in object, mother's row is decomposed into multiple sub-line, each sub-line correspondence splits in the cell of object and comprises an element split in object, and in each sub-line, remaining cell is identical with cell content corresponding in corresponding mother's row;
S3, obtain the contrast BOM be made up of sub-line;
S4, basis searches function and logical function searches comparison to each contrast BOM, judges whether there are differences.
The method of comparison BOM fast as claimed in claim 1, is characterized in that, in step S1, obtain the original BOM that two parts of needs carry out contrasting.
Preferably, also comprise in step S1: original BOM is backed up.
Preferably, in step S4, logical function adopts IF form function.
Preferably, in step S4, search function and adopt VLOOKUP function.
Preferably, material corresponding for this preset parameter, by selecting one or more preset parameter, is then merged in a female row by the acquisition of original BOM.
The method of quick comparison BOM provided by the invention, utilizes the feature of BOM file, merges or decompose BOM, thus the details presenting BOM that can be more clear, bright and clear.Such as, certain starting material of a certain product are useful in the difference in functionality module of this product, and BOM file is distinguished by functional module, when needing this raw-material consumption obtaining this product, need the consumption searching each functional module, then integrate, this method length consuming time and easily makeing mistakes.Consider that these starting material unique no attribute in functional module BOM is locus, therefore can formulate a kind of division rule, locus is different, and these materials that material attribute description is identical merge, thus draw total consumption fast and accurately.Otherwise, use in which functional module if need to obtain certain starting material, then can formulate another kind of division rule and present fast.When needing to carry out Detail contrast to BOM, then can carry out refinement branch according to locus to BOM, then line by line the BOM after two parts of branches be contrasted according to function, with the difference between fast finding two parts of BOM.
The method of quick comparison BOM provided by the invention, can efficiently, the two parts of BOM differences of comparison fast, check BOM accuracy, and ensure produce BOM accurately, the product that the manufacturing is gone out can not suffer unnecessary loss because of BOM mistake.The method can be applied to be manufactured in enterprise.
Accompanying drawing explanation
Fig. 1 is the method flow diagram of a kind of quick comparison BOM that the present invention proposes;
Fig. 2 is that original BOM obtains schematic diagram;
Fig. 3 is contrast BOM acquisition schematic diagram;
Fig. 4 is the first original BOM schematic diagram in embodiment;
Fig. 5 is the contrast BOM schematic diagram that in embodiment, the first original BOM is corresponding;
Fig. 6 is the second original BOM schematic diagram in embodiment;
Fig. 7 is the contrast BOM schematic diagram that in embodiment, the second original BOM is corresponding;
Fig. 8 is that in embodiment, BOM contrasts schematic diagram.
Embodiment
With reference to Fig. 1, the method for a kind of quick comparison BOM that the present invention proposes, comprises the following steps:
S1, acquisition needs carry out the original BOM being no less than portion contrasted, and comprise and be no less than the cell that can be used as fractionation object in original BOM at least one column unit lattice, split in object to comprise to be no less than an element.With reference in Fig. 2 present embodiment, material corresponding for this preset parameter, by selecting one or more preset parameter, is then merged in a female row by the acquisition of original BOM.Such as in the BOM of PCBA, can merge the electronic component of same model, the different items by identical electronic element application are incorporated in a cell, thus obtain the original BOM shown in Fig. 3.In present embodiment, by cell span, can be polymerized identical material, thus carry out unifying process, reduce work difficulty, increase work efficiency.
S2, reference Fig. 3, using each row of data in original BOM as mother's row, according to splitting the multiple elements comprised in object, mother's row is decomposed into multiple sub-line, each sub-line correspondence splits in the cell of object and comprises an element split in object.
The contrast BOM be made up of sub-line shown in S3, acquisition Fig. 3.
S4, basis searches function and logical function searches comparison to each contrast BOM, judges whether there are differences.
For the BOM of a PCBA.In the present embodiment, need to contrast two parts of original BOM, the matrix form that two parts of original BOM are corresponding is respectively arr1 and arr2, in two parts of BOM, often row arr1 (i) and arr2 (i) comprise a kind of material, i representing matrix line number, hereafter represent columns with j, wherein arr1 (i, 1) and arr2 (i, 1) part number (Partnumber) is, arr1 (i, 2) and arr2 (i, 2) be parameter and describe (Description), arr1 (i, 3) and arr2 (i, 3) quantity is, arr1 (i, 4) and arr2 (i, 4) item (Reference) is.The BOM of PCBA, usual diverse location can adopt identical material, so can, using a kind of material as a row relax, be about to adopt the different item of identical material all to concentrate in a cell.So, in the present embodiment, by arr1 (i, 4) and arr2 (i, 4) as splitting object.
Concrete, as shown in Figure 4, in the present embodiment, comprise a kind of material in the first original BOM and BOM1, it is for five positions.So BOM1 only has a female row, after BOM1 branch, according to item, five sub-line can be obtained, as shown in Figure 6.Matrix form corresponding for the contrast BOM obtained after BOM1 branch is designated as brr1 (i, j), then:
arr1(1，1)＝brr1(1,1)＝brr1(2,1)＝brr1(3,1)＝brr1(4,1)＝brr1(5,1)
arr1(1，2)＝brr1(1,2)＝brr1(2,2)＝brr1(3,2)＝brr1(4,2)＝brr1(5,2)
arr1(1，3)＝brr1(1,3)＝brr1(2,3)＝brr1(3,3)＝brr1(4,3)＝brr1(5,3)
arr1(1，4)＝[brr1(1,4)brr1(2,4)brr1(3,4)brr1(4,4)brr1(5,4)]
In the BOM of PCBA, quantity equals item sum, and in the present embodiment, object is that whether the material in comparison two parts of BOM on identical item is variant, so for the contrast BOM after branch, do not process quantity.
In like manner, in the shown in Fig. 5 second original BOM and BOM2, comprise two kinds of materials, be common on five positions corresponding with BOM1.So BOM2 has two female row, after BOM2 branch, according to item, five sub-line can be obtained, as shown in Figure 7.Matrix form corresponding for the contrast BOM obtained after BOM2 branch is designated as brr2 (i, j), then:
arr2(1，1)＝brr2(1,1)＝brr2(2,1)＝brr2(3,1)＝brr2(4,1)
arr2(1，2)＝brr2(1,2)＝brr2(2,2)＝brr2(3,2)＝brr2(4,2)
arr2(1，3)＝brr2(1,3)＝brr2(2,3)＝brr2(3,3)＝brr2(4,3)
arr2(1，4)＝[brr2(1,4)brr2(2,4)brr2(3,4)brr2(4,4)]
Arr2 (2, j)=brr2 (5, j), j=1,2,3 or 4
Brr1 (i is obtained respectively by after the first original BOM and the second original BOM branch, j), brr2 (i, j), then to brr1 (i, j) contrast line by line with brr2 (i, j), can find, brr1 (5,1) variant with brr2 (5,1), thus can find that the material that the first original BOM and the second original BOM uses on item C7133 is variant.
In present embodiment, when specifically contrasting, can be as shown in Figure 8, brr1 (i, j) and brr2 (i, j) is attached in a form, contrasted by the column of IF form function to the parameter needing contrast, then pass through result corresponding to VLOOKUP function lookup.
The above; be only the present invention's preferably embodiment; but protection scope of the present invention is not limited thereto; anyly be familiar with those skilled in the art in the technical scope that the present invention discloses; be equal to according to technical scheme of the present invention and inventive concept thereof and replace or change, all should be encompassed within protection scope of the present invention.
Claims (6)
1. a method of quick comparison BOM, is characterized in that, comprise the following steps:
S1, acquisition needs carry out the original BOM being no less than portion contrasted, and comprise and be no less than the cell that can be used as fractionation object in original BOM at least one column unit lattice, split in object to comprise to be no less than an element;
S2, using each row of data in original BOM as mother's row, according to splitting the multiple elements comprised in object, mother's row is decomposed into multiple sub-line, each sub-line correspondence splits in the cell of object and comprises an element split in object, and in each sub-line, remaining cell is identical with cell content corresponding in corresponding mother's row;
S3, obtain the contrast BOM be made up of sub-line;
S4, basis searches function and logical function searches comparison to each contrast BOM, judges whether there are differences.
2. the method for comparison BOM fast as claimed in claim 1, is characterized in that, in step S1, obtain the original BOM that two parts of needs carry out contrasting.
3. the method for comparison BOM fast as claimed in claim 1, is characterized in that, also comprise in step S1: back up original BOM.
4. the method for comparison BOM fast as claimed in claim 1, is characterized in that, in step S4, logical function adopts IF form function.
5. the method for comparison BOM fast as claimed in claim 1, is characterized in that, in step S4, searches function and adopts VLOOKUP function.
6. the method for the quick comparison BOM as described in any one of claim 1 to 5, is characterized in that, material corresponding for this preset parameter, by selecting one or more preset parameter, is then merged in a female row by the acquisition of original BOM.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510796766.XA CN105302781A (en) | 2015-11-18 | 2015-11-18 | Method for fast BOM comparison |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510796766.XA CN105302781A (en) | 2015-11-18 | 2015-11-18 | Method for fast BOM comparison |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105302781A true CN105302781A (en) | 2016-02-03 |
Family
ID=55200060
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510796766.XA Pending CN105302781A (en) | 2015-11-18 | 2015-11-18 | Method for fast BOM comparison |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105302781A (en) |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106598763A (en) * | 2016-12-09 | 2017-04-26 | 四川长虹电器股份有限公司 | Method for testing BI report |
| CN107766314A (en) * | 2017-10-20 | 2018-03-06 | 网易（杭州）网络有限公司 | The data processing method and device of electrical form |
| CN109165889A (en) * | 2018-07-24 | 2019-01-08 | 赖勇清 | A kind of data model and method for building up of the material information in section |
| CN112508520A (en) * | 2020-12-08 | 2021-03-16 | 安徽巨一科技股份有限公司 | Method, system, device and storage medium for rapidly checking bill of material |
| CN112632953A (en) * | 2020-12-22 | 2021-04-09 | 云汉芯城（上海）互联网科技股份有限公司 | Method for quickly and accurately detecting that multiple uploaded bill of materials belong to same product |
| CN112767583A (en) * | 2020-12-24 | 2021-05-07 | 广州粤盾保安服务有限公司 | Access control management method and system |
| CN116739490A (en) * | 2023-08-15 | 2023-09-12 | 深圳硬之城信息技术有限公司 | BOM table checking and early warning method, device, equipment and storage medium |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1534524A (en) * | 2003-03-28 | 2004-10-06 | 鸿富锦精密工业（深圳）有限公司 | BOM table automatic comparison system and method |
| CN1734480A (en) * | 2004-08-14 | 2006-02-15 | 鸿富锦精密工业（深圳）有限公司 | Bill of Material (BOM) (BOM) diversity ratio is to system and method |
| KR20060033383A (en) * | 2004-10-15 | 2006-04-19 | 엘지전자 주식회사 | Making method for bill of material using visual basic |
| CN101261622A (en) * | 2008-05-12 | 2008-09-10 | 金蝶软件（中国）有限公司 | Data dividing method and apparatus |
| CN101408416A (en) * | 2008-11-24 | 2009-04-15 | 沈建华 | Method and system for checking SMT paster formula correctness |
| CN104268699A (en) * | 2014-09-28 | 2015-01-07 | 浪潮(北京)电子信息产业有限公司 | Method for automatic inspection of bill of material (BOM) |
-
2015
- 2015-11-18 CN CN201510796766.XA patent/CN105302781A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1534524A (en) * | 2003-03-28 | 2004-10-06 | 鸿富锦精密工业（深圳）有限公司 | BOM table automatic comparison system and method |
| CN1734480A (en) * | 2004-08-14 | 2006-02-15 | 鸿富锦精密工业（深圳）有限公司 | Bill of Material (BOM) (BOM) diversity ratio is to system and method |
| KR20060033383A (en) * | 2004-10-15 | 2006-04-19 | 엘지전자 주식회사 | Making method for bill of material using visual basic |
| CN101261622A (en) * | 2008-05-12 | 2008-09-10 | 金蝶软件（中国）有限公司 | Data dividing method and apparatus |
| CN101408416A (en) * | 2008-11-24 | 2009-04-15 | 沈建华 | Method and system for checking SMT paster formula correctness |
| CN104268699A (en) * | 2014-09-28 | 2015-01-07 | 浪潮(北京)电子信息产业有限公司 | Method for automatic inspection of bill of material (BOM) |
Non-Patent Citations (1)
| Title |
|---|
| 恒盛杰: "Excel公式、函数与图表经典108例", 《中国青年出版社》 * |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106598763A (en) * | 2016-12-09 | 2017-04-26 | 四川长虹电器股份有限公司 | Method for testing BI report |
| CN107766314A (en) * | 2017-10-20 | 2018-03-06 | 网易（杭州）网络有限公司 | The data processing method and device of electrical form |
| CN109165889A (en) * | 2018-07-24 | 2019-01-08 | 赖勇清 | A kind of data model and method for building up of the material information in section |
| CN109165889B (en) * | 2018-07-24 | 2022-01-14 | 赖勇清 | Data model of interval material information and establishing method |
| CN112508520A (en) * | 2020-12-08 | 2021-03-16 | 安徽巨一科技股份有限公司 | Method, system, device and storage medium for rapidly checking bill of material |
| CN112632953A (en) * | 2020-12-22 | 2021-04-09 | 云汉芯城（上海）互联网科技股份有限公司 | Method for quickly and accurately detecting that multiple uploaded bill of materials belong to same product |
| CN112767583A (en) * | 2020-12-24 | 2021-05-07 | 广州粤盾保安服务有限公司 | Access control management method and system |
| CN116739490A (en) * | 2023-08-15 | 2023-09-12 | 深圳硬之城信息技术有限公司 | BOM table checking and early warning method, device, equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105302781A (en) | Method for fast BOM comparison | |
| US9852121B2 (en) | Automatic relationship detection for spreadsheet data items | |
| US6557002B1 (en) | Data management system for storing structural element data management program | |
| Braglia et al. | A new value stream mapping approach for complex production systems | |
| US20150262124A1 (en) | Artificial intelligence system and method for processing multilevel bills of materials | |
| US8312366B2 (en) | Displaying multiple row and column header areas in a summary table | |
| US9009618B2 (en) | Three-dimensional visualization of status and progress of a process | |
| US10360238B1 (en) | Database systems and user interfaces for interactive data association, analysis, and presentation | |
| Detzner et al. | A digital twin for root cause analysis and product quality monitoring | |
| Chiarini | A comparison between time-driven activity-based costing and value stream accounting in a lean Six Sigma manufacturing case study | |
| CN106408435A (en) | Process compiling system and process compiling method | |
| CN113597664A (en) | Method, electronic device, storage medium and system for determining bad reason | |
| CN103514294A (en) | Method and system for monitoring data | |
| CN104133680A (en) | Fast building method of ERP form module | |
| Setiawan | Technology Innovation Roadmap To Industrial Development of Rubber-Raw Material In South Sumatera (Ergonomics SHIP Approach & Appropriate Technology Point of View) | |
| CN115623872A (en) | Data processing method, device, equipment and storage medium | |
| EP1624403A1 (en) | System for querying databases | |
| US20030233160A1 (en) | Method and device for product data processing | |
| Steenhuis et al. | High technology, performance and price: the case of additive manufacturing through desktop 3D printers | |
| Mitsching et al. | Design patterns for integrating variability in timed automata | |
| Wongthongchai et al. | The application of interpretive structural modeling technique (ISM) to study adopting model of green supply chain management | |
| US20230004138A1 (en) | Data processing method, device and system, and electronic device | |
| US11017008B2 (en) | Method and system for contextualizing process data | |
| Cohrs et al. | Time-efficient and accurate spatial localization of automotive function architectures with function-oriented 3D visualization | |
| US20150178357A1 (en) | Method and system for displaying MES records in a grid on an MES client screen |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20160203 |
|
| WD01 | Invention patent application deemed withdrawn after publication |