CN109446495A - A method of realizing material table automatic arranging in electrical form - Google Patents
A method of realizing material table automatic arranging in electrical form Download PDFInfo
- Publication number
- CN109446495A CN109446495A CN201811278133.XA CN201811278133A CN109446495A CN 109446495 A CN109446495 A CN 109446495A CN 201811278133 A CN201811278133 A CN 201811278133A CN 109446495 A CN109446495 A CN 109446495A
- Authority
- CN
- China
- Prior art keywords
- electrical form
- automatic arranging
- macro
- summary table
- characteristic parameter
- 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.)
- Withdrawn
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)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The method that the invention discloses a kind of to realize material table automatic arranging in electrical form comprising the steps of: A, material library are arranged into a table, are formed a material summary table, are then extracted to the characteristic parameter of every material;B, original BOM is equally extracted the parameter for needing to distinguish;C, match according in characteristic parameter and material summary table with the macro each material in original BOM of VBA Programming with Pascal Language;D, macro the material that do not used in material summary table deletion by another after whole table circulation has executed these operations;E, the dosage of every material is counted.Up-front investment of the present invention is small, only need to sort out a material summary table, create several buttons and be linked to above-mentioned several sections of codes;Flexibility is high, for different demands, such as parameter number, only repair and simple adjustment done to table and code;Opposite Manual arranging, efficiency are greatly improved, and the possibility of error is minimum.
Description
Technical field
It is specifically a kind of that material table automatic arranging is realized in electrical form the present invention relates to technical field of data processing
Method.
Background technique
At present in field of electronic design, common material table (Bill Of Materials, BOM, once abbreviation BOM) is whole
There are two types of reason methods, and one is original BOM derived in Electronic Design software by classifying manually, needed for being organized into
Classification format;Another method is individually to develop a set of software systems, imports original BOM, exports required format.
It is more that the method for Manual arranging arranges the time for needing to expend every time, and is easy error;The individually side of exploitation software
Method early investment is very big, also fairly cumbersome if necessary to modify.
Summary of the invention
The method that the purpose of the present invention is to provide a kind of to realize material table automatic arranging in electrical form, on solving
State the problem of proposing in background technique.
To achieve the above object, the invention provides the following technical scheme:
A method of realizing material table automatic arranging in electrical form comprising the steps of:
A, material library is arranged into a table, is formed a material summary table, is then mentioned to the characteristic parameter of every material
It takes;
B, original BOM is equally extracted the parameter for needing to distinguish;
C, it is carried out with the macro each material in original BOM of VBA Programming with Pascal Language according in characteristic parameter and material summary table
Matching;
D, macro the material that do not used in material summary table deletion by another after whole table circulation has executed these operations;
E, the dosage of every material is counted.
As further technical solution of the present invention: the characteristic parameter includes resistance value, encapsulation and precision.
As further technical solution of the present invention: the step A and step B is real by the function that electrical form carries
It is existing.
As further technical solution of the present invention: for the matching result of step C, when all conditions all meet,
Automatically position number is filled up to the position reserved in material summary table, and this position number is marked in original BOM, be convenient for area
Point.
As further technical solution of the present invention: after the completion of step E is executed, since centre deletes some rows, sequence
Number needs are rearranged, and need to utilize the macro carry out Auto-writing of VBA programming again.
Compared with prior art, the beneficial effects of the present invention are: up-front investment of the present invention is small, a material need to only be sorted out
Summary table creates several buttons and is linked to above-mentioned several sections of codes;Flexibility is high, for different demands, such as parameter number, only
It repairs and simple adjustment is done to table and code;Opposite Manual arranging, efficiency are greatly improved, and the possibility of error is minimum.
Specific embodiment
The technical scheme in the embodiments of the invention will be clearly and completely described below, it is clear that described implementation
Example is only a part of the embodiment of the present invention, instead of all the embodiments.Based on the embodiments of the present invention, this field is common
Technical staff's every other embodiment obtained without making creative work belongs to the model that the present invention protects
It encloses.
Embodiment 1: a method of realizing material table automatic arranging in electrical form comprising the steps of:
A, material library is arranged into a table, forms a material summary table, then the characteristic parameter of every material is carried out
It extracts, such as resistance value, encapsulation, precision of resistance etc..
B, then original BOM is equally extracted the parameter for needing to distinguish.The letter that two steps can be carried by electrical form
Number is realized.
C, later with the macro each material in original BOM of VBA Programming with Pascal Language according to characteristic parameter and material summary table
In carry out match, when all conditions all meet, position number is filled up to automatically the position reserved in material summary table, and in original
This position number is marked in beginning BOM, convenient for distinguishing.
D, after whole table circulation, which has executed these, to be operated, macro the material that do not use in material summary table is deleted by another
It removes.
E, then go out the dosage (position number) of every material by algorithm programming count.
Using this method, up-front investment is small, only need to sort out a material summary table, create several buttons be linked to it is above-mentioned
Several sections of codes;Flexibility is high, for different demands, such as parameter number, only repair and simple adjustment done to table and code;
Opposite Manual arranging, efficiency are greatly improved, and the possibility of error is minimum.
Embodiment 2: on the basis of embodiment 1, after the completion of step E execution, since centre deletes some rows, serial number
It needs to rearrange, needs the macro carry out Auto-writing programmed again using VBA, can ensure the continuity of table and complete in this way
Whole property.
It is obvious to a person skilled in the art that invention is not limited to the details of the above exemplary embodiments, Er Qie
In the case where without departing substantially from spirit or essential attributes of the invention, the present invention can be realized in other specific forms.Therefore, no matter
From the point of view of which point, the present embodiments are to be considered as illustrative and not restrictive, and the scope of the present invention is by appended power
Benefit requires rather than above description limits, it is intended that all by what is fallen within the meaning and scope of the equivalent elements of the claims
Variation is included within the present invention.
In addition, it should be understood that although this specification is described in terms of embodiments, but not each embodiment is only wrapped
Containing an independent technical solution, this description of the specification is merely for the sake of clarity, and those skilled in the art should
It considers the specification as a whole, the technical solutions in the various embodiments may also be suitably combined, forms those skilled in the art
The other embodiments being understood that.
Claims (5)
1. a kind of method for realizing material table automatic arranging in electrical form, which is characterized in that comprise the steps of:
A, material library is arranged into a table, forms a material summary table, then the characteristic parameter of every material is carried out
It extracts;
B, original BOM is equally extracted the parameter for needing to distinguish;
C, it is carried out with the macro each material in original BOM of VBA Programming with Pascal Language according in characteristic parameter and material summary table
Matching;
D, macro the material that do not used in material summary table deletion by another after whole table circulation has executed these operations;
E, the dosage of every material is counted.
2. a kind of method for realizing material table automatic arranging in electrical form according to claim 1, which is characterized in that
The characteristic parameter includes resistance value, encapsulation and precision.
3. a kind of method for realizing material table automatic arranging in electrical form according to claim 1, which is characterized in that
The step A and step B is realized by the function that electrical form carries.
4. a kind of method for realizing material table automatic arranging in electrical form according to claim 1, which is characterized in that
For the matching result of step C, when all conditions all meet, position number is filled up to automatically the position reserved in material summary table
It sets, and this position number is marked in original BOM, convenient for distinguishing.
5. a kind of method for realizing material table automatic arranging in electrical form according to claim 1 to 4, special
Sign is, after the completion of step E is executed, since centre deletes some rows, serial number needs are rearranged, need to utilize again
The macro carry out Auto-writing of VBA programming.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811278133.XA CN109446495A (en) | 2018-10-30 | 2018-10-30 | A method of realizing material table automatic arranging in electrical form |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811278133.XA CN109446495A (en) | 2018-10-30 | 2018-10-30 | A method of realizing material table automatic arranging in electrical form |
Publications (1)
Publication Number | Publication Date |
---|---|
CN109446495A true CN109446495A (en) | 2019-03-08 |
Family
ID=65549097
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201811278133.XA Withdrawn CN109446495A (en) | 2018-10-30 | 2018-10-30 | A method of realizing material table automatic arranging in electrical form |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN109446495A (en) |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111985015A (en) * | 2020-08-17 | 2020-11-24 | 四川九立微波有限公司 | System and method for automatically generating BOM (Bill of Material) by using VBA (visual basic Access) function |
CN113467881A (en) * | 2021-09-01 | 2021-10-01 | 南方电网数字电网研究院有限公司 | Method and device for automatically adjusting chart style, computer equipment and storage medium |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
KR100646181B1 (en) * | 2005-07-27 | 2006-11-14 | (주)넥스데이타 | Visual bom building system for total materials management system |
CN103093038A (en) * | 2012-12-31 | 2013-05-08 | 深圳市九洲电器有限公司 | Updating method and updating device for bills of material (BOMs) |
CN107633353A (en) * | 2017-09-08 | 2018-01-26 | 南京国电南自电网自动化有限公司 | Material BOM tables based on EXCEL Table V BA close rule inspection method |
-
2018
- 2018-10-30 CN CN201811278133.XA patent/CN109446495A/en not_active Withdrawn
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
KR100646181B1 (en) * | 2005-07-27 | 2006-11-14 | (주)넥스데이타 | Visual bom building system for total materials management system |
CN103093038A (en) * | 2012-12-31 | 2013-05-08 | 深圳市九洲电器有限公司 | Updating method and updating device for bills of material (BOMs) |
CN107633353A (en) * | 2017-09-08 | 2018-01-26 | 南京国电南自电网自动化有限公司 | Material BOM tables based on EXCEL Table V BA close rule inspection method |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111985015A (en) * | 2020-08-17 | 2020-11-24 | 四川九立微波有限公司 | System and method for automatically generating BOM (Bill of Material) by using VBA (visual basic Access) function |
CN113467881A (en) * | 2021-09-01 | 2021-10-01 | 南方电网数字电网研究院有限公司 | Method and device for automatically adjusting chart style, computer equipment and storage medium |
CN113467881B (en) * | 2021-09-01 | 2021-11-16 | 南方电网数字电网研究院有限公司 | Method and device for automatically adjusting chart style, computer equipment and storage medium |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN109446495A (en) | A method of realizing material table automatic arranging in electrical form | |
CN106570260B (en) | Automatic generation method of electrical connection relation | |
CN106227946A (en) | A kind of PCB web plate manufacture method and system | |
CN106777723A (en) | A kind of method of automatic drawing principle figure | |
CN105701289B (en) | A kind of integrated solution of full-automatic wiring harness processing device | |
CN108733928B (en) | SCD file virtual circuit automatic checking method based on intermediate model file | |
CN110069892A (en) | A kind of FPGA pin assignment design method and device | |
CN102236734A (en) | Method for automatically forming patterns in design of power system of thermal power plant | |
CN104732041A (en) | Automatic virtual terminal generation method based on multiple SCD templates | |
CN103268362A (en) | Auxiliary design method of virtual terminals on basis of general template and key character matching | |
CN107688719A (en) | Towards the part automatic identification and localization of automatic sorting | |
CN107766466A (en) | Recognition methods, system, computer-readable recording medium and the equipment of data type | |
CN110728123A (en) | Report generation method, system and related equipment | |
CN109683881A (en) | A kind of code format method of adjustment and device | |
CN113094932A (en) | Method, device, equipment and storage medium for acquiring construction cost of power transformation project | |
CN104021002B (en) | A kind of PDM system standards part storage method | |
CN105550535B (en) | A kind of gene character string fast coding is the coding method of binary sequence | |
CN103810365A (en) | Automatic grading method based on hydroelectric simulation training system | |
CN106815392A (en) | A kind of producer's terminal block figure intelligent reading method | |
CN110147226A (en) | A kind of system according to Function Block Diagram automatically generating program, method and device | |
CN105488271B (en) | A kind of oil gas module shaped steel automatic matching method | |
CN106055684A (en) | SCD file comparison method of transformer substation | |
CN116611388A (en) | Method for automatically correcting size and spacing of via holes based on scripting language | |
CN106055793A (en) | Method for quickly unlocking view file | |
CN102073909A (en) | Implementation method for high-efficiency semiautomatic artificial intelligence (AI) software |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
WW01 | Invention patent application withdrawn after publication | ||
WW01 | Invention patent application withdrawn after publication |
Application publication date: 20190308 |