阅读说明：本技术 电气设计图的自动生成装置及方法 (Automatic generation device and method of electrical design drawing ) 是由 金贤 于 2019-03-22 设计创作，主要内容包括：本发明涉及电气设计图的自动生成装置及方法,其中,所述电气设计图的自动生成装置包括：信息输入部,通过电子表格应用程序接收电路设计所需的零件规格信息；图生成部,基于所述信息输入部接收的零件规格信息将电路设计进行图式化,并生成电路设计图；及画面输出部,通过画面输出在所述图生成部生成的电路设计图。据此,可提供自动生成PCL及输入/输出控制器设计图制作,进而基于与国际标准相对应的数据可进行标准设计的电气设计图的自动生成装置及方法的效果。(The invention relates to an automatic generation device and a method of an electrical design drawing, wherein the automatic generation device of the electrical design drawing comprises the following components: an information input part for receiving part specification information required for circuit design through an electronic form application program; a drawing generation unit that schematizes a circuit design based on the part specification information received by the information input unit and generates a circuit design drawing; and a screen output unit that outputs the circuit layout generated by the layout generation unit on a screen. Accordingly, it is possible to provide an effect of an automatic generation apparatus and method for automatically generating a PCL, creating an input/output controller design drawing, and generating an electrical design drawing which can be designed based on data corresponding to international standards.)

1. An apparatus for automatically generating an electrical design drawing, comprising:

an information input part for receiving part specification information required for circuit design through an electronic form application program;

a drawing generation unit that schematizes a circuit design based on the part specification information received by the information input unit and generates a circuit design drawing; and

and a screen output unit that outputs the circuit layout generated by the layout generation unit on a screen.

2. The apparatus according to claim 1,

the information input unit also receives manufacturer information through the spreadsheet application, extracts a part specification item corresponding to the selected manufacturer from a part database based on the received manufacturer information, and receives the part specification information for the extracted part specification item.

3. The apparatus according to claim 2,

the part database includes at least one information of a part classification, a part model name, a part description, a connection point type, and a connection point number of each manufacturer.

4. The apparatus according to claim 2,

the information input part provides different part address setting value input windows according to the manufacturers.

5. The apparatus for automatically generating an electrical layout of claim 1, further comprising:

and a bill of material generation unit that automatically generates a bill of material file based on the received part specification information and by the spreadsheet application.

6. An automatic generation method of an electrical design drawing is executed by an automatic generation device of the electrical design drawing, and comprises the following steps:

receiving part specification information required by circuit design through an electronic form application program;

patterning the circuit design based on the received part specification information and generating a circuit design diagram; and

and outputting the generated circuit design drawing through a special interface picture.

7. The method of automatically generating an electrical design drawing of claim 6,

before the step of receiving the part specification information, the method further comprises the following steps:

receiving, by the spreadsheet application, manufacturer information;

extracting a part specification item corresponding to the selected manufacturer from a part database according to the received manufacturer information,

wherein, in the step of receiving the part specification information, the part specification information is received for the extracted part specification item.

8. The method of automatically generating an electrical design drawing of claim 7,

the part database includes at least one information of a part classification, a part model name, a part description, a connection point type, and a connection point number of each manufacturer.

9. The method of automatically generating an electrical design drawing of claim 7,

in the step of receiving the part specification information, different part address setting value input windows are provided according to the manufacturer.

10. The method of automatically generating an electrical design drawing of claim 6, further comprising the steps of:

automatically generating a bill of material file based on the received part specification information and by the spreadsheet application.

Technical Field

The present invention relates to an apparatus and a method for automatically generating an electrical design drawing, and more particularly, to an apparatus and a method for automatically generating a PLC (Programmable Logic controller) and an input/output controller design drawing.

Background

ERP (Enterprise Resource Planning) refers to an Enterprise Resource management system or an Enterprise integrated system that integrates and manages the operation flows of production, logistics, finance, accounting, sales, purchasing, inventory, and the like in an Enterprise, and shares information generated in the Enterprise with each other to generate new information and help to make a decision quickly.

In general, ERP includes not only production (manufacturing) business but also purely management business such as finance and accounting, customer/product, supply chain, enterprise service, human resources, and business support functions.

The present invention relates to a system for comprehensively managing all product information from the definition of product change to design, development, manufacture, shipment, and customer service. Typically in connection with ERP. Recently, this concept has been extended to PLM (product life management).

Recently, as a ring for enhancing competitiveness, automated manufacturing systems are being actively introduced in many companies. Accordingly, the automation level becomes high, and the logistics flow or process control method of the production site becomes more and more complicated. In factory automation, a PLC (Programmable Logic Controller) is mostly used as a main Controller.

On the other hand, since most of the diagrams for designing the PLC are implicit diagrams, there is a risk that necessary information may be omitted. In addition, since the drawing is arbitrarily designed and drawn by a designer, it is difficult to maintain the standard.

Moreover, in the case of manual drawings at the designer's discretion, the graphic-based design may be difficult to capitalize on engineering data, and may cause communication problems between internal and external collaborating companies.

Since the designer performs the drawing work at will, there is a limitation in providing a low-quality drawing, and there is a problem in that it takes unnecessary time to repeatedly perform a similar simple design.

Further, the required files need to be made manually after designing the circuit. However, circuit design and document fabrication are performed individually and centrally by each designer, and thus there is a risk of human error.

In addition, production or ordering problems frequently occur due to inconsistencies between the drawings and the documents. There is also the problem of unnecessarily increasing part inventory, since it is difficult to determine the exact amount of proper inventory. Due to the manual work, there is a problem that the manpower resources of engineers are wasted.

Disclosure of Invention

Technical problem

The present invention is derived based on the above technical background, and an object of the present invention is to provide an apparatus and a method for automatically generating an electrical design drawing, which can improve a work flow by establishing a design standardization and automation environment based on data, and can improve engineering work efficiency.

In addition, the following automatic generation device and method of the electrical design diagram are provided: through the automatic workflow, the enterprise competitiveness can be ensured, the working time can be shortened, and the commercialization can be realized.

Technical scheme

The present invention for achieving the above object includes the following configurations.

That is, an automatic generation device of an electrical design drawing according to an embodiment of the present invention includes: an information input unit that receives part specification information required for circuit design by an electronic form (spreadsheet) application; a drawing generation unit that schematizes a circuit design based on the part specification information received by the information input unit and generates a circuit design drawing; and a screen output unit that outputs the circuit layout generated by the layout generation unit on a screen.

On the other hand, in an embodiment of the present invention, the automatic generation method of an electrical design drawing executed by the automatic generation apparatus of an electrical design drawing includes the steps of: receiving part specification information required by circuit design through an electronic form application program; patterning a circuit design based on the received part specification information and generating a circuit design drawing; and outputting the generated circuit design drawing through a special interface picture.

Effects of the invention

According to the present invention, the effect of the apparatus and method for automatically generating an electrical design drawing is derived, PCL is automatically generated, an input/output controller design drawing is created, and a standard design can be performed based on data corresponding to international standards.

In addition, it can informationize engineering know how and design data, reduce human error and shorten design time.

Further, the effect of shortening the working time of the engineer (worker) and improving operability and efficiency is derived.

Moreover, the effect of establishing a standard workflow with continuous stability, speed and efficiency of design and operation is derived.

Drawings

Fig. 1 is a diagram showing the structure of an automatic generation apparatus of an electrical layout according to an embodiment of the present invention;

FIG. 2 is a conceptual diagram of an apparatus for automatically generating an electrical layout of an embodiment of the present invention;

FIG. 3 is a flow chart of a method for automatic generation of an electrical layout according to an embodiment of the present invention;

FIGS. 4 and 5 are exemplary diagrams for explaining a part database structure of an embodiment of the present invention;

FIGS. 6a and 6b are exemplary diagrams of a graphical interface for inputting part data in accordance with one embodiment of the present invention;

FIG. 7 is an exemplary diagram for explaining a part specification item extraction process according to an embodiment of the present invention;

FIG. 8 is an exemplary diagram of a PLC I/O detailed input screen of an embodiment of the present invention;

FIG. 9 is an exemplary diagram of a part selection screen in a graphical interface for inputting part data in accordance with an embodiment of the present invention;

FIG. 10 is an exemplary diagram of a remote card designation screen in a graphical interface for inputting part data in accordance with an embodiment of the present invention;

fig. 11 to 13 are exemplary diagrams of a pop-up window inquiring whether or not the input data of the part data is output;

FIGS. 14a and 14b are exemplary views of an address input screen in a graphic interface for inputting part data according to an embodiment of the present invention;

fig. 15 is an exemplary diagram of a device tag input screen in the image interface for inputting part data of the embodiment of the present invention;

fig. 16 to 21 are exemplary diagrams of screens for outputting circuit design diagrams schematized by dedicated interface screens.

Reference numerals:

100: information input unit 110: graph generation unit

120: screen output unit 130: bill of material generation section

Detailed Description

The technical terms used in the present invention should be used only for describing specific embodiments, and are not intended to limit the present invention. In addition, for technical terms used in the present invention, unless specifically defined in the present invention, they should be interpreted as meanings that are conventionally understood by those having ordinary knowledge in the technical field to which the present invention belongs, and should not be interpreted as excessively generalized meanings or excessively narrow meanings.

Hereinafter, preferred embodiments of the present invention will be described in detail with reference to the accompanying drawings.

Fig. 1 is a diagram showing the structure of an automatic generation apparatus of an electrical layout according to an embodiment of the present invention;

in one embodiment, the automatic generation device of the electrical design drawing is developed into a separate window-type application program which can execute the automatic generation function of the electrical design drawing. At this time, the windowed application can be provided in the form of a file of an installation (setup) program. Furthermore, a manager for issuing and managing licenses can be separately provided.

As can be seen from fig. 1, the automatic generation apparatus of an electrical layout of an embodiment includes: an information input unit 100, a diagram generation unit 110, a screen output unit 120, and a bill of material generation unit 130.

The information input section 100 receives part specification information required for circuit design by a spreadsheet (spreadsheet) application.

The electronic forms are programs for inputting numerical or character data into a form and operating to process the data, and include not only simple calculations but also drawing functions and database functions for displaying the data in the form of a graph, and word processing functions.

In addition, as an application program capable of efficiently performing tasks such as numerical calculation, statistics, and charts, various simple calculations can be performed because information can be stored in cells where horizontal rows and vertical rows intersect and a calculator function is provided. It includes various functions such as a drawing function of drawing a diagram or a figure, a communication function, providing various functions, and the like, and thus can be effectively used.

For example, an Excel program is a representative spreadsheet that can automatically calculate, chart, create files, and the like. Therefore, the system is used in various fields such as payroll tables, result management tables, and inventory management tables. There are google spreadsheets, which can also be compiled with pc or cell phone. The method has the advantage that multiple persons share the prepared electronic form file and modify the electronic form file together in real time.

In one embodiment of the invention, as described above, a spreadsheet is interpreted to include all of the various applications that enter numbers or words into a worksheet and may perform the required calculations or management, charting, searching, etc.

The diagram generating section 110 schematizes the circuit design based on the part specification information received by the information input section and generates a circuit design diagram.

The screen output unit 120 outputs the circuit layout generated by the diagram generation unit 110 through a dedicated interface screen.

In one embodiment, the dedicated interface screen refers to a screen for driving an epan (electrical dedicated design tool) or a general cad (autocad).

According to an embodiment of the present invention, the information input part 100 also receives manufacturer information through the spreadsheet application.

Then, a part specification item corresponding to the manufacturer selected in the part database is extracted based on the received manufacturer information, and the part specification information is received for the extracted part specification item.

At this time, the parts database includes at least one information of the parts classification, the part model name, the part description, the connection point type, and the number of connection points by the manufacturer.

The information input unit 100 provides different component address setting value input windows for each manufacturer.

Then, the Bill of material generation section 130 automatically generates a Bill of material (BOM) file by the spreadsheet application based on the part specification information received by the information input section 100.

Accordingly, the following effects are obtained: the accurate quantity of proper inventory can be mastered, so that the problem of unnecessary increase of part inventory is solved, and the waste of human resources and human errors of engineers caused by manual work are reduced.

Fig. 2 is a conceptual diagram of an apparatus for automatically generating an electrical layout according to an embodiment of the present invention.

As shown in the drawing, an automatic generation apparatus 10 of an electrical design drawing of an embodiment of the present invention provides an interface with an EPLAN (electrical special design tool) or a general cad (autocad) based on a database in the form of a spreadsheet application program.

More specifically, the automatic generation apparatus of an electrical design drawing of an embodiment performs various processes required for collecting data and generating a drawing using existing Excel data. The completed data can then be linked with other programs in XML and Text formats.

That is, the automatic generation apparatus 10 of an electrical design drawing according to an embodiment of the present invention can generate data related to the use of the part data erp (pdm), execute a design based on a drawing, and realize a standard design based on data corresponding to international standards.

That is, the automatic generation apparatus 10 of an electrical design drawing according to an embodiment of the present invention can provide a text file format data import environment. In addition, the data may correspond to a module name and n transform texts. Furthermore, a user-selectable contour specification environment is provided.

A function of performing IEC (International Electrotechnical Commission)/NFPA (National Fire Protection Association) standard transformation may be further provided, and a function change library folder is automatically generated through a diagram. In addition, a function that can automatically combine a plurality of CAD drawings is added. The bulk transform function of the layers used in the graph may also be added.

Fig. 3 is a flowchart of a method for automatically generating an electrical layout according to an embodiment of the present invention.

First, the automatic generation method of an electrical design drawing, which is performed by the automatic generation apparatus of an electrical design drawing, receives manufacturer information through an electronic form application (S200).

At this time, the reception of the part specification information required for circuit design is performed based on the part database.

Then, a part specification item corresponding to the manufacturer selected in the part database is extracted according to the received manufacturer information (S210).

Fig. 4 and 5 are exemplary diagrams for explaining a structure of a parts database according to an embodiment of the present invention.

As shown in fig. 4, the database selection window needs to be distinguished according to the classification of the database (Data1, Data 2..) to achieve a fast search. Then, when the classification text of the database is changed, it is apparent that the text of the database selection window of the portion indicated by green in fig. 3 is also changed.

In addition, at this time, simple characteristic information of the part is also displayed when the part is selected.

In addition, as can be seen from fig. 5, the parts database includes at least one information of the parts classification, the part model name, the part description, the connection point type, and the number of connection points by the manufacturer.

At this time, lines corresponding to the number of connection points are added at the time of generating IO Point. Then, the IO type (DI, DO, etc.) is an identifier used to distinguish when an Address (Address) is specified. As an example, the DI address designation may be set to x000 and the DO address designation may be set to Y000.

Part specification information required for circuit design is received through the spreadsheet application (S220). At this time, the part specification information is received for different part specification items extracted according to manufacturers.

In addition, when receiving the part specification information, different part address setting value input windows are provided for each manufacturer.

FIG. 6a is an exemplary diagram of a graphical interface for inputting part data in accordance with one embodiment of the present invention;

FIG. 6b is an exemplary diagram of a graphical interface for inputting part data for another embodiment of the present invention. Fig. 7 is a diagram for explaining an example of the part specification item extracting process according to an embodiment of the present invention.

As can be seen from fig. 6a, the user can select his or her desired part manufacturer in the selection list 600.

In this way, as shown in fig. 7, the part specification information corresponding to the manufacturer selected by the user is extracted from the part database. That is, only the part data corresponding to the manufacturer selected from all the part databases is called when the manufacturer is selected. In this case, a part of the parts database may be added or an edit screen may be provided. In one embodiment, adding a database can be implemented by calling the database part from an Excel (Excel import) program and performing data editing in a state already displayed in the Excel program.

Further, as described with reference to fig. 6a, according to an embodiment of the present invention, the selection 610 of the remote PLC may be achieved through a graphical interface for inputting part data.

In addition, the selected part number and description 620 are displayed. The slot configuration of the primary PLC is now shown.

Moreover, a structural area 630 of the remote PLC may also be displayed. In this case, the remote configuration is different for each manufacturer, and thus different settings can be made according to the manufacturer. For example, if the manufacturer is Mitsubishi, LSISsms, then the single placement, if the manufacturer is Siemens, AB (Allen-Bradley: Allen-Bradley), then the same as the master PLC structure may be a slot type.

Further, the graphical interface for inputting part data further comprises: an Excel output button 640 for the selected parts list, an EPLAN output button 650 for outputting the selected parts list in Excel form, and a shift button 660 for shifting to a PLC I/O (input/output) detailed input screen.

Fig. 8 is an exemplary diagram of a PLC I/O detailed input screen according to an embodiment of the present invention.

As can be seen in FIG. 8, the function of saving the currently working part data values or calling out saved values may be performed. At this time, the I/O detailed information window data can be controlled up and down by mouse scrolling.

Fig. 9 is an exemplary diagram of a part selection screen in the image interface for inputting part data according to the embodiment of the present invention.

As shown in FIG. 9, for parts already stored in the parts database, the parts may be classified by type and may be distinguished by class entry to enable quick retrieval. If a desired category item is selected, a parts catalog 910 belonging to the category item will be displayed, and a detailed description 920 of the selected part may also be displayed.

Fig. 10 is an exemplary diagram of a remote card designation screen in a graphical interface for inputting part data according to an embodiment of the present invention.

In one embodiment, as shown in FIG. 10, a PLC remote card may also be designated. And if the PLC remote card is selected, outputting a selection picture of the corresponding part.

Fig. 11 to 13 are exemplary diagrams of a pop-up window for inquiring whether the part data input data is output or not.

In one embodiment, the graphical interface for inputting part data may display a pop-up message window to display important information, as shown in fig. 11-13. At this time, when the load is large, a status progress bar may be further included. Additionally, a tool tip with a menu description may also be displayed near key scrolling in a screen providing selectable menu categories.

Fig. 14a and 14b are exemplary views of an address input screen in a graphical interface for inputting part data according to an embodiment of the present invention.

In one embodiment of the present invention, when inputting the part specification information, different part address setting value input windows are provided according to manufacturers.

That is, as shown in fig. 14a and 14b, address setting value input windows of different formats for each manufacturer are automatically loaded and displayed. Specifically, in the case where the manufacturer is one of MITSUBISHI, AB, and LSIS, the input window set in the form of five digits of the maximum number of digits, that is, three-digit digital input (X000), three-digit digital output (Y000), two-digit analog input (AI00), and two-digit analog output (AO00) is displayed.

In contrast, in the case where the manufacturer is SIEMENS, the input window set in the form of five digits of the maximum number of digits, that is, the digital input of one digit (io.0), the digital output of one digit (qo.0), the analog input of one digit (eo.0), and the analog output of two digits (ao.0), is displayed.

On the other hand, in fig. 14a, the function of exporting/importing data by Excel according to macro button input can be improved.

In exporting data, a table with DT/NO/TYPE/MACRO/ADDRESS/Function _ Text/Device columns can be generated and exported using the Excel program.

When data is imported, automatic data loading is performed using Vlookup based on the Address (Address). At this point, the data columns may be different, and thus may be implemented to load data when the Address/Function/Device information matches.

Fig. 15 is an exemplary diagram of a device tag input screen in the image interface for inputting part data according to the embodiment of the present invention.

In one embodiment, an Excel I/O List including specification input values of a part is imported and then automatically processed, and a text for Vlookup or IF function processing is set. Specifically, as shown in fig. 15, the device tag input screen is divided into four areas, i.e., DI, DO, AI, and AO. Then, it can be realized that the area includes at most 20 lines in one area, and the part image in one line to include an input space of at most five letters.

The structure and design of the device tag input screen are merely examples, and various modifications are obvious.

Furthermore, the graphical interface for inputting part data according to an embodiment of the present invention may further provide a screen for displaying parts and I/O usage information. Specifically, a screen showing the detailed information of the PLC parts used, the total point of use (point) number, the number of uses of DI, DO, AI, and AO, and the number of spare parts may be output.

Schematization is realized based on the part specification information input through the image interface screen as described above, and a circuit design diagram is generated (S230).

First, the part specification information input through the image interface screen can be generated in the form of a text file.

Then, transformation is performed based on the generated text file form to implement schematization. Then, the generated circuit schematized circuit design is outputted through the dedicated interface screen (S240).

Fig. 16 to 21 are exemplary diagrams of screens for outputting circuit design diagrams schematized by dedicated interface screens.

Specifically, fig. 16 shows an IEC PLC sample showing a schematic circuit configuration of an input card including 1 main module (main block) and 8 sub modules (sub blocks) at maximum.

FIG. 17 is a sample IEC PLC showing in detail the main module of the input card; FIG. 18 is an IEC PLC sample showing in detail the submodules of the output card.

On the other hand, fig. 19 shows an IEC PLC sample showing a schematic circuit configuration of an output card including 1 main module and 8 sub-modules at maximum.

FIG. 20 is a sample IEC PLC showing in detail the master module of the output card; FIG. 21 is an IEC PLC sample showing in detail the submodules of the output card.

Thereafter, a Bill of material (BOM) file may be automatically generated based on the input part specification information through the spreadsheet application (S250).

A Bill of material (BOM) refers to a catalog, a chart, or a drawing that shows the relationship of a parent item and a part, and the usage amount, a unit, and the like, for all items. A parent is an item manufactured from more than one part, a part being an item that has undergone at least one process in order to be converted into a parent.

In one embodiment, the generated bill of materials can be used as a purchase list and can be generated by outputting a PLC parts catalog selected among the predetermined items.