CN108121841A - A kind of method of Fast Labeling PCBA installing devices - Google Patents
A kind of method of Fast Labeling PCBA installing devices Download PDFInfo
- Publication number
- CN108121841A CN108121841A CN201611075570.2A CN201611075570A CN108121841A CN 108121841 A CN108121841 A CN 108121841A CN 201611075570 A CN201611075570 A CN 201611075570A CN 108121841 A CN108121841 A CN 108121841A
- Authority
- CN
- China
- Prior art keywords
- list
- top layer
- position number
- installation
- layer
- 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.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F30/00—Computer-aided design [CAD]
Abstract
The present invention relates to electronic device labelling techniques, and it discloses a kind of Fast Labeling PCBA installing device methods, solve the problems, such as that labeling effciency existing for mark mode is low in traditional technology, easily malfunction.This method comprises the following steps：A. all device coordinates of artwork paper are exported from eda software, and an Excel file is merged into product inventory；B. embedded VBA modules carry out Conjoint Analysis to product inventory and device coordinate in the Excel file, analysis result are imported in new Excel file；C. the top layer and bottom device distribution map in former design drawing are exported from eda software；D. VBA modules are embedded in after top layer and bottom device distribution map is opened and are run；E. after importing the new Excel file, each device position generation respective markers in distribution map.
Description
Technical field
The present invention relates to electronic device labelling techniques, specifically design a kind of Fast Labeling PCBA (assembling printed circuit board (PCB)) peaces
The method for filling device.
Background technology
The assembly ware mark of electronic product assembling PCBA, produces and is checked applied to electronic assemblies, in order to
Whether quick recognition means assemble and position and model among operation instruction file, to mounting, inserting production line and and check work
Sequence provides intuitively means, meets production easily demand.
Electronic product production firm production scene at present, most situations be all only provide full device position distribution map,
Product device inventory and mounting coordinates are also searched even if tag device by manual type, mostly among operation instruction file
Quickly, accurate marker installing device is the urgent demand of a reality.
In addition, also having part manufacturer in the prior art using color mark device position, the device markings of same model are
Same color, corresponding to be also labeled as same color in the same material of product inventory, there are following defects for which：
1. color can there are many kinds of, but when material variety is very big, difference will become smaller between color, and color is close to be
It is not easy very much what is differentiated, eventually results in that user is tired in being confirmed whether it is same material repeatedly, and probability of making a mistake increases.
2. device model confirms whether certain position number mounts a certain material model and need to pass through color mark in product inventory
It is directed in product inventory and searches, lack intuitive, influence user's efficiency.
3. manually search position number marks model simultaneously, inefficiency, when material and thousands of kinds of quantity, artificial mistake is general
Rate can also multiple increase.
The content of the invention
The technical problems to be solved by the invention are：It proposes a kind of method of Fast Labeling PCBA installing devices, solves to pass
In system technology labeling effciency existing for mark mode it is low, easily error the problem of.
The embodiment of the present invention provides a kind of method of Fast Labeling PCBA installing devices, comprises the following steps：
A. all device coordinates of artwork paper are exported from eda software, and an Excel file is merged into product inventory；
B. embedded VBA modules carry out Conjoint Analysis to product inventory and device coordinate in the Excel file, will analyze
As a result import in new Excel file；
C. the top layer and bottom device distribution map in former design drawing are exported from eda software；
D. VBA modules are embedded in after top layer and bottom device distribution map is opened and are run；
E. after importing the new Excel file, each device position generation respective markers in distribution map.
Optimize as further, in step a, export all device coordinates of artwork paper include from eda software：Target is printed
The position number of all devices and its corresponding X-Y coordinate, device rotation angle, mounting surface on plate.
As further optimization, in step a, it is described an Excel file is merged into product inventory method be：
Derived all device coordinates are imported into another list that an Excel file is belonged to product inventory
In.
As further optimization, the product inventory includes material model, material level number of the same race.
Optimize as further, in step b, the analysis result includes bottom installation list, the non-installation list of bottom, top
Layer installation list, the non-installation list of top layer.
As further optimization, step b is specifically included：
B1. material level number in product inventory is split, separates single position number；
B2. identical bits number are searched in device coordinate list according to position number：
If the position number finds identical bits number in top layer, then position number and corresponding material model, X-Y coordinate, rotation are copied
Gyration, mounting surface are appended to top surface installation list；
If the position number is in bottom and finds identical bits number, position number and corresponding material model, X-Y coordinate, rotation are copied
Gyration, mounting surface are appended to bottom surface installation list；
List and bottom surface installation form finding identical bits number are installed in top surface respectively in position number in b3 extraction coordinate lists：
If the position number in top layer, and top layer install list in do not find identical bits number, then copy position number, X-Y coordinate,
Mounting surface is appended to the non-installation list of top surface；
If the position number does not find identical bits number in bottom in top layer installs list, then position number, X-Y coordinate are copied
Mounting surface is appended to the non-installation list in bottom surface；
B4. a new Excel file is generated, then moves bottom installation list, the non-installation list of bottom, top layer installation table
Single, the non-installation list of top layer is into new Excel file.
Optimize as further, in step c, top layer and bottom device point in the former design drawing of eda software export
The output format of Butut is CAD forms.
Optimize as further, in step d, pass through CAD software and open embedded VBA moulds after top layer and bottom device distribution map
Block is simultaneously run.
Optimize as further, in step e, the respective markers include：Top layer installing device position layer, model layer, top
The non-installing device position layer of floor, bottom installing device position layer, model layer, the non-installing device position layer of bottom.
As further optimization, step e is specifically included：
E1. it is loaded into new Excel file；
E2. read top layer installation list, according to the corresponding X-Y coordinate in position number and rotation angle value, by corresponding position number and
Model is inserted respectively into newly-generated top layer installation position layer and top layer model layer, installs all positions number in list until top layer and inserts
Enter to finish；
E3. the non-installation list of top layer is read, according to the corresponding X-Y coordinate in position number, corresponding position number is inserted into newly-generated
The non-mounting layer of top layer, until all position number insertions finish in the non-installation list of top layer；
E4. bottom installation list is read, according to the corresponding X-Y coordinate in position number and rotation angle value, by corresponding position number and type
Number newly-generated bottom installation position floor and bottom model floor are inserted respectively into, until bottom installs all positions number insertions in list
It finishes；
E5. the non-installation list of bottom is read, according to the corresponding X-Y coordinate in position number, corresponding position number is inserted into newly-generated
The non-mounting layer of bottom, until all position number insertions finish in the non-installation list of bottom.
The beneficial effects of the invention are as follows：
1) can be tied to the product-based bom flow file of electronic product and device coordinate file Conjoint Analysis, and according to analysis
Fruit, output need to install top, bottom position number, model excel tables of data, and it is single can will to be also not required to the information generations such as installation top bottom position number
Only list, and this tables of data is imported in cad, generation installation top, bottom position number and model floor also have non-installation top, bottom position layer,
Analysis result simple, intuitive, data analysis output input high efficient and reliable；Work that can be effectively by improving research and development, engineering staff is imitated
Rate and reduction manpower and software use cost.
2) due to having artificial participation before removing the operation of VBA programs in the process, other are less manual intervention, and error probability is significantly
Decline.
3) visual result is exported, since installation position number and non-installation position number are in different layers, device model is also independent one layer,
Switch equivalent layer can arbitrarily show as needed, and in same device same position, easily telling very much device is for device position number and model
No installation and the model of installation, can accomplish to correspond, without inquiring about product-based bom flow again with actual printed board, you can
Confirm relevant mount message.Be conducive to engineers and technicians and production scene veneer examiner utilizes this output result and list
Plate correspondence proving directly perceived one by one.
Description of the drawings
Fig. 1 is the method flow diagram of the Fast Labeling PCBA installing devices in the embodiment of the present invention；
Fig. 2 is that VBA modules carry out Conjoint Analysis flow chart to product inventory and device coordinate；
Fig. 3 is the flow chart that VBA modules generate respective markers according to the Excel tables of importing.
Specific embodiment
Originally a kind of method of Fast Labeling PCBA installing devices is directed to, is solved in traditional technology existing for mark mode
Labeling effciency is low, easily error the problem of.The present invention core concept be：It is right using product-based bom flow and device coordinate
Its Conjoint Analysis；Using embedded VBA programs, quickly to inventory and coordinate analysis, and analysis result is exported；Output result includes
The non-installing device list of top layer installing device list, top layer, bottom installing device list, the non-installing device list of top layer；It utilizes
Embedded VBA programs, quickly introduce excel lists into CAD diagram；The excel lists of output are imported in CAD device distribution maps,
Generation top layer installing device position layer, model layer, the non-installing device position layer of top layer, bottom installing device position layer, model layer,
The non-installing device position layer of bottom.
As shown in Figure 1, the method for the Fast Labeling PCBA installing devices in the present embodiment comprises the following steps：
A. all device coordinates of artwork paper are exported from eda software, and an Excel file is merged into product inventory；
B. embedded VBA modules carry out Conjoint Analysis to product inventory and device coordinate in the Excel file, will analyze
As a result import in new Excel file；
C. the top layer and bottom device distribution map in former design drawing are exported from eda software；
D. VBA modules are embedded in after top layer and bottom device distribution map is opened and are run；
E. after importing the new Excel file, each device position generation respective markers in distribution map.
In specific implementation, in step A, export all device coordinates of artwork paper include from eda software：Target printed board
The upper position number of all devices and its corresponding X-Y coordinate, device rotation angle, mounting surface；Product inventory include material model,
Material level number of the same race；Product inventory, which is conducted into, after all device coordinates of artwork paper are exported belongs to an Excel file
Another list-coordinate list in, i.e. product inventory and coordinate list belongs to same Excel, but is independent list.
In step B, the analysis result includes bottom installation list, the non-installation list of bottom, top layer installation list, top layer
Non- installation list.Specific analytic process is as shown in Figure 2:
B1. material level number in product inventory is split, separates single position number；
B2. identical bits number are searched in device coordinate list according to position number：
If the position number finds identical bits number in top layer, then position number and corresponding material model, X-Y coordinate, rotation are copied
Gyration, mounting surface are appended to top surface installation list；
If the position number is in bottom and finds identical bits number, position number and corresponding material model, X-Y coordinate, rotation are copied
Gyration, mounting surface are appended to bottom surface installation list；
B3. extract the position number in coordinate list and list and bottom surface installation form finding identical bits number are installed in top surface respectively：
If the position number in top layer, and top layer install list in do not find identical bits number, then copy position number, X-Y coordinate,
Mounting surface is appended to the non-installation list of top surface；
If the position number does not find identical bits number in bottom in bottom installs list, then position number, X-Y coordinate are copied
Mounting surface is appended to the non-installation list in bottom surface face；
B4. a new Excel file is generated, then moves bottom installation list, the non-installation list of bottom, top layer installation table
For single, the non-installation list of top layer into new Excel file, Excel that can be new to this reassigns title.
In step C, the output format of top layer and bottom device distribution map in the former design drawing of eda software export is
CAD forms.In step D, by embedded VBA modules after CAD software opening top layer and bottom device distribution map and run.
In step E, the respective markers include：Top layer installing device position layer, model layer, the non-installing device position number of top layer
Layer, bottom installing device position layer, model layer, the non-installing device position layer of bottom；Specifically each device position in distribution map
The flow for putting generation respective markers is as shown in Figure 3：
E1. it is loaded into new Excel file；
E2. read top layer installation list, according to the corresponding X-Y coordinate in position number and rotation angle value, by corresponding position number and
Model is inserted respectively into newly-generated top layer installation position layer and top layer model layer, installs all positions number in list until top layer and inserts
Enter to finish；
E3. the non-installation list of top layer is read, according to the corresponding X-Y coordinate in position number, corresponding position number is inserted into newly-generated
The non-mounting layer of top layer, until all position number insertions finish in the non-installation list of top layer；
E4. bottom installation list is read, according to the corresponding X-Y coordinate in position number and rotation angle value, by corresponding position number and type
Number newly-generated bottom installation position floor and bottom model floor are inserted respectively into, until bottom installs all positions number insertions in list
It finishes；
E5. the non-installation list of bottom is read, according to the corresponding X-Y coordinate in position number, corresponding position number is inserted into newly-generated
The non-mounting layer of bottom, until all position number insertions finish in the non-installation list of bottom.
Claims (10)
- A kind of 1. method of Fast Labeling PCBA installing devices, which is characterized in that comprise the following steps：A. all device coordinates of artwork paper are exported from eda software, and an Excel file is merged into product-based bom flow；B. embedded VBA modules carry out Conjoint Analysis to product-based bom flow and device coordinate in the Excel file, will analyze As a result import in new Excel file；C. the top layer and bottom device distribution map in former design drawing are exported from eda software；D. VBA modules are embedded in after top layer and bottom device distribution map is opened and are run；E. after importing the new Excel file, each device position generation respective markers in distribution map.
- 2. the method as described in claim 1, which is characterized in that in step a, all devices of artwork paper are exported from eda software Coordinate includes：The position number of all devices and corresponding X-Y coordinate, device rotation angle, mounting surface in target printed board.
- 3. the method as described in claim 1, which is characterized in that described to merge into one with product-based bom flow in step a The method of Excel file is：Derived all device coordinates are imported into another list that an Excel file is belonged to product-based bom flow In.
- 4. the method as described in claim 1, which is characterized in that the product inventory includes material model, material level number of the same race.
- 5. the method as described in claim 1, which is characterized in that in step b, the analysis result include bottom installation list, The non-installation list of bottom, top layer installation list, the non-installation list of top layer.
- 6. method as claimed in claim 5, which is characterized in that step b is specifically included：B1. material level number in product inventory is split, separates single position number；B2. identical bits number are searched in device coordinate list according to position number：If the position number finds identical bits number in top layer, then position number and corresponding material model, X-Y coordinate, the anglec of rotation are copied Degree, mounting surface are appended to top surface installation list；If the position number is in bottom and finds identical bits number, position number and corresponding material model, X-Y coordinate, the anglec of rotation are copied Degree, mounting surface are appended to bottom surface installation list；B3. extract the position number in coordinate list and list and bottom surface installation form finding identical bits number are installed in top surface respectively：If the position number does not find identical bits number in top surface in top layer installs list, then position number, X-Y coordinate, installation are copied Face is appended to the non-installation list of top surface；If the position number does not find identical bits number in bottom in bottom installs list, then position number, X-Y coordinate installation are copied Face is appended to the non-installation list in bottom surface face；B4. generate a new Excel file, then move the non-installation list of bottom installation list, bottom, top layer installation list, The non-installation list of top layer is into new Excel file.
- 7. the method as described in claim 1, which is characterized in that in step c, in the former design drawing of eda software export The output format of top layer and bottom device distribution map is CAD forms.
- 8. the method as described in claim 1, which is characterized in that in step d, top layer and bottom device are opened by CAD software VBA modules are embedded in after distribution map and are run.
- 9. the method as described in claim 1, which is characterized in that in step e, the respective markers include：Top layer installing device Position layer, model layer, the non-installing device position layer of top layer, bottom installing device position layer, model layer, the non-installing device position of bottom Number floor.
- 10. method as claimed in claim 9, which is characterized in that step e is specifically included：E1. it is loaded into new Excel file；E2. top layer installation list is read, according to the corresponding X-Y coordinate in position number and rotation angle value, by corresponding position number and model Newly-generated top layer installation position layer and top layer model layer are inserted respectively into, all positions number in list are installed until top layer and have been inserted into Finish；E3. the non-installation list of top layer is read, according to the corresponding X-Y coordinate in position number, corresponding position number is inserted into newly-generated top layer Non- mounting layer, until all position number insertions finish in the non-installation list of top layer；E4. bottom installation list is read, according to the corresponding X-Y coordinate in position number and rotation angle value, by corresponding position number and model point Newly-generated bottom installation position layer and bottom model layer are not inserted into, and all positions number in list are installed until bottom and have been inserted into Finish；E5. the non-installation list of bottom is read, according to the corresponding X-Y coordinate in position number, corresponding position number is inserted into newly-generated bottom Non- mounting layer, until all position number insertions finish in the non-installation list of bottom.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611075570.2A CN108121841B (en) | 2016-11-29 | 2016-11-29 | Method for quickly marking PCBA (printed circuit board assembly) mounting device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611075570.2A CN108121841B (en) | 2016-11-29 | 2016-11-29 | Method for quickly marking PCBA (printed circuit board assembly) mounting device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN108121841A true CN108121841A (en) | 2018-06-05 |
| CN108121841B CN108121841B (en) | 2022-04-05 |
Family
ID=62225888
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201611075570.2A Active CN108121841B (en) | 2016-11-29 | 2016-11-29 | Method for quickly marking PCBA (printed circuit board assembly) mounting device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108121841B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108984868A (en) * | 2018-06-28 | 2018-12-11 | 郑州云海信息技术有限公司 | The integration method and device of a kind of board internet data |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR20070097231A (en) * | 2006-03-29 | 2007-10-04 | 이근호 | Automatic design method with ms excel |
| CN101329664A (en) * | 2007-06-19 | 2008-12-24 | 神讯电脑(昆山)有限公司 | Method for conversing material inventory list |
| CN102880738A (en) * | 2012-07-31 | 2013-01-16 | 青岛海信电器股份有限公司 | Method for tabulating checking information table for materials on printing plate |
| CN105389425A (en) * | 2015-10-23 | 2016-03-09 | 上海卓易科技股份有限公司 | Method for rapidly collating electronic component list |
| CN105740561A (en) * | 2016-02-03 | 2016-07-06 | 上海卓易科技股份有限公司 | Inspection method and system of bill of materials |
-
2016
- 2016-11-29 CN CN201611075570.2A patent/CN108121841B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR20070097231A (en) * | 2006-03-29 | 2007-10-04 | 이근호 | Automatic design method with ms excel |
| CN101329664A (en) * | 2007-06-19 | 2008-12-24 | 神讯电脑(昆山)有限公司 | Method for conversing material inventory list |
| CN102880738A (en) * | 2012-07-31 | 2013-01-16 | 青岛海信电器股份有限公司 | Method for tabulating checking information table for materials on printing plate |
| CN105389425A (en) * | 2015-10-23 | 2016-03-09 | 上海卓易科技股份有限公司 | Method for rapidly collating electronic component list |
| CN105740561A (en) * | 2016-02-03 | 2016-07-06 | 上海卓易科技股份有限公司 | Inspection method and system of bill of materials |
Non-Patent Citations (3)
| Title |
|---|
| HAIRULLIZA MOHAMAD JUDI 等: "Visualising Automatic Product Inspection of PCB Units", 《2009 INTERNATIONAL CONFERENCE ON ELECTRICAL ENGINEERING AND INFORMATICS》 * |
| 何霄峰等: "Excel VBA在提高项目物料清单处理效率中的应用", 《机械工程师》 * |
| 董义: "ACM贴片机自动贴片系统研究", 《电子工艺技术》 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108984868A (en) * | 2018-06-28 | 2018-12-11 | 郑州云海信息技术有限公司 | The integration method and device of a kind of board internet data |
| WO2020000952A1 (en) * | 2018-06-28 | 2020-01-02 | 郑州云海信息技术有限公司 | Pcb internetwork data integrating method and device |
| CN108984868B (en) * | 2018-06-28 | 2020-08-04 | 苏州浪潮智能科技有限公司 | Method and device for integrating board card internet data |
Also Published As
| Publication number | Publication date |
|---|---|
| CN108121841B (en) | 2022-04-05 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN100541502C (en) | A kind of PCB analogue system and its implementation with error detection function | |
| JP2019532377A (en) | Printed circuit board metal mask manufacturing method and printed circuit board metal mask manufacturing system | |
| CN104461519B (en) | A kind of flow chart dynamic generation and the method for control of authority | |
| CN105183966B (en) | Instrument floor plan fast drawing method based on database | |
| CN102231146A (en) | Automatic extraction and normalization storage method of manufacturing data of heterogeneous electronic design automation (EDA) design | |
| CN102855337A (en) | Automated wiring inspection system and automated wiring inspection method | |
| CN105447246A (en) | Method and system for generating electrical principle diagram through one key | |
| CN112765916B (en) | Method for generating simulation parameter netlist after integrated circuit | |
| CN104053306A (en) | PCB device bit number design and wrongly marked position inspection method | |
| CN105354138A (en) | Method for determining specific control attribute of mobile phone page | |
| CN108121841A (en) | A kind of method of Fast Labeling PCBA installing devices | |
| CN104217273A (en) | Characteristic management method for spacecraft three-dimensional digital model | |
| CN200969157Y (en) | Automatic scoring device for circuit examination | |
| CN102663161B (en) | Radio-frequency integrated-circuit triangular mesh generation method | |
| CN105224719A (en) | A kind of method realizing same page part and sort out fast | |
| CN101908081A (en) | Circuit auxiliary design method and system | |
| CN111310403A (en) | PCB pad intelligent modification technology | |
| CN103441988B (en) | Across GIS platform data migration method | |
| CN102236068A (en) | Method and device for testing chip | |
| CN103377050A (en) | SMT (surface mounted technology) machine program coordinate transformation method | |
| CN101639867A (en) | Wiring method for circuit layout and method for recording network cable names of circuit layout | |
| CN101131709B (en) | Distributed circuit layout character face processing method and system thereof | |
| CN103365377B (en) | Cabinet upright column, back board, groove bit identification system and method | |
| CN108733931A (en) | Circuit design and processing technology output method and device | |
| CN102339341A (en) | Method for automatically controlling extraction precision of parasitic parameters during physical layout simulation |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |