CN112836248A - Method and system for drawing electrical wiring diagram - Google Patents
Method and system for drawing electrical wiring diagram Download PDFInfo
- Publication number
- CN112836248A CN112836248A CN202110090698.0A CN202110090698A CN112836248A CN 112836248 A CN112836248 A CN 112836248A CN 202110090698 A CN202110090698 A CN 202110090698A CN 112836248 A CN112836248 A CN 112836248A
- Authority
- CN
- China
- Prior art keywords
- list
- terminal
- electrical wiring
- wiring diagram
- item
- 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
- 238000010586 diagram Methods 0.000 title claims abstract description 151
- 238000009429 electrical wiring Methods 0.000 title claims abstract description 118
- 238000000034 method Methods 0.000 title claims abstract description 101
- 230000006870 function Effects 0.000 claims description 14
- 238000004590 computer program Methods 0.000 claims description 10
- 230000006399 behavior Effects 0.000 claims description 3
- 238000009434 installation Methods 0.000 abstract description 5
- 230000000875 corresponding effect Effects 0.000 description 44
- 238000013461 design Methods 0.000 description 10
- 238000004891 communication Methods 0.000 description 5
- 238000012423 maintenance Methods 0.000 description 3
- 238000010276 construction Methods 0.000 description 2
- 230000001276 controlling effect Effects 0.000 description 2
- 238000010616 electrical installation Methods 0.000 description 2
- 238000002955 isolation Methods 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 230000002159 abnormal effect Effects 0.000 description 1
- 238000006243 chemical reaction Methods 0.000 description 1
- 230000002596 correlated effect Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000004870 electrical engineering Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000007774 longterm Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000009877 rendering Methods 0.000 description 1
- 102220042297 rs587780883 Human genes 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F30/00—Computer-aided design [CAD]
Landscapes
- Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Computer Hardware Design (AREA)
- Evolutionary Computation (AREA)
- Geometry (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Programmable Controllers (AREA)
- Design And Manufacture Of Integrated Circuits (AREA)
Abstract
The invention provides a method and a system for drawing an electrical wiring diagram, which comprise the following steps: determining a terminal number list of the target element according to the type of the target element to be drawn; determining a connecting element electrically connected with the target element, and determining a connecting element list according to the wiring relation between the target element and the connecting element; drawing a terminal number list and the connecting element list on the same electrical wiring diagram, wherein the electrical wiring diagram is an EXCEL spreadsheet; each item in the list of connection elements corresponds one-to-one to each terminal number in the list of terminal numbers. The invention adopts the mode of drawing the EXCEL spreadsheet to draw the electric wiring diagram, changes the expression form of the scattered and distributed component schematic diagram into the expression form of the centralized spreadsheet associated with the programming formula to display, leads the electric workers to more intuitively finish the wiring installation work, effectively improves the drawing efficiency of the electric drawing and reduces the amount of the electric drawing paper.
Description
Technical Field
The invention relates to the technical field of electrical engineering, in particular to a method and a system for drawing an electrical wiring diagram.
Background
At present, an electrical wiring diagram generally adopts an electrical traditional drawing method, namely, AutoCAD drawing software is used for drawing a two-dimensional structural diagram of an electrical element. Fig. 1 is a schematic diagram of a two-dimensional structure of an electrical component in the prior art, and as shown in fig. 1, a wiring number is marked at a corresponding contact point number of the component, and the same number is marked at a corresponding contact point number of the component connected with the component, which indicates that the two electrical components are connected, that is, two terminals with the same default number are electrically connected. If the input terminal L1 of the element M420 shown in fig. 1 is numbered 04501, and the number of a terminal of another connecting element is also numbered 04501, it is considered that the input terminal L1 of the element M420 and the terminal of the connecting element are connected.
Although the existing electrical wiring diagram drawn by adopting AutoCAD drawing software can make the appearance of the element close to the real object, the defects are shown in the following:
firstly, two components needing to be connected are possibly distributed in different drawings; secondly, because the same numbers are distributed on terminal strips, relay contacts or contactor contacts and other different types of component contacts of the electrical cabinet, the component contacts are searched in the actual wiring process, professional electrical knowledge and long-term working experience need to be relied on, and the working difficulty and the working time are increased invisibly; thirdly, the drawing workload is large, the used drawings are numerous, and the workload of drawing personnel is increased invisibly, so that the working efficiency is low.
Disclosure of Invention
Aiming at the problems in the prior art, the embodiment of the invention provides a method and a system for drawing an electrical wiring diagram.
The invention provides a drawing method of an electrical wiring diagram, which comprises the following steps: determining a terminal number list of the target element according to the type of the target element to be drawn; determining a connecting element electrically connected with the target element, and determining a connecting element list according to the wiring relation between the target element and the connecting element; drawing the terminal number list and the connecting element list on the same electrical wiring diagram, wherein the electrical wiring diagram is an EXCEL spreadsheet; each item in the connection element list corresponds to each terminal number in the terminal number list one to one.
According to the drawing method of an electrical wiring diagram provided by the present invention, after drawing the terminal number list and the connection element list on the same electrical wiring diagram, the drawing method further includes: acquiring cable number identifications for realizing electric connection between each wiring terminal of the target element and the connecting element, and determining a line number identification list of the target element; drawing the line number identification list in an EXCEL spreadsheet; in the EXCEL spreadsheet, each item in the line number identification list corresponds to each terminal number in the terminal number list one-to-one.
According to the drawing method of an electrical wiring diagram provided by the present invention, after drawing the terminal number list and the connection element list in the same electrical wiring diagram, the drawing method further includes: acquiring cable diameter requirements for realizing electric connection between each wiring terminal of the target element and the connecting element, and determining a cable diameter requirement list of the target element; drawing the line diameter requirement list in an EXCEL spreadsheet; in the EXCEL spreadsheet, each entry in the line diameter requirement list corresponds one-to-one to each terminal number in the terminal number list.
According to the drawing method of an electrical wiring diagram provided by the present invention, before drawing the terminal number list and the connection element list on the same electrical wiring diagram, the drawing method further includes: formulating an EXCEL spreadsheet template of each kind of element and creating a spreadsheet template library; the first behavior form title column of each EXCEL electronic form template comprises an element label item, an equipment terminal number item, a line diameter item and a connecting element item; a terminal number list of elements is pre-drawn in a column where an equipment terminal number item of the EXCEL spreadsheet template is located; pre-drawing a line number identification list of elements in a column where a line number item of the EXCEL electronic form template is located; pre-drawing a line diameter requirement list of elements in a column where a line diameter item of the EXCEL spreadsheet template is located; and the terminal number list, the line number identification list and the line diameter requirement list are in one-to-one correspondence.
According to a drawing method of an electrical wiring diagram provided by the present invention, drawing the terminal number list and the connection element list on the same electrical wiring diagram includes: calling an EXCEL electronic form template of a target element from a form template library according to the type of the target element; the form title bar of an EXCEL spreadsheet template further comprises at least one remark item; inputting the equipment number of the target element in the column where the remark item is located based on the EXCEL spreadsheet function, so as to draw the equipment number of the target element in the column where the element number item is located; the list of connected elements of the target element is drawn in the column of the EXCEL spreadsheet template where the connected element item resides.
According to the drawing method of the electrical wiring diagram provided by the invention, the drawing the connection element list of the target element in the column where the connection element item of the EXCEL spreadsheet template is located comprises the following steps: inputting the number of terminal rows and the number of terminal columns corresponding to the terminal row numbers in the connecting element list to a first preset position corresponding to the remark items and the terminal row numbers on the basis of an EXCEL spreadsheet function so as to draw the terminal row numbers in the columns where the connecting element items of the EXCEL spreadsheet template are located, wherein the first preset position is a position corresponding to the terminal row numbers; and inputting the custom address corresponding to the physical address of the output numerical quantity module in the connecting element list to a second preset position of the remark item on the basis of the EXCEL spreadsheet function so as to draw the physical address of the output numerical quantity module in a column of the connecting element item of the EXCEL spreadsheet template, wherein the second preset position is a position corresponding to the physical address of the output numerical quantity module.
According to the drawing method of the electrical wiring diagram provided by the invention, the drawing the connection element list of the target element in the column where the connection element item of the EXCEL spreadsheet template is located further comprises: in the column where the connection element item of the EXCEL spreadsheet template is located, a fixed connection item in the connection element list is preset.
The invention also provides a system for drawing an electrical wiring diagram, which comprises: the first reading unit is used for determining a terminal number list of a target element according to the type of the target element to be drawn; the second reading unit is used for determining a connecting element electrically connected with the target element and determining a connecting element list according to the wiring relation between the target element and the connecting element; the drawing unit is used for drawing the terminal number list and the connecting element list on the same electrical wiring diagram, and the electrical wiring diagram is an EXCEL spreadsheet; each item in the connection element list corresponds to each terminal number in the terminal number list one to one.
The invention also provides an electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the steps of the method for drawing an electrical wiring diagram as described in any one of the above when executing the program.
The present invention also provides a non-transitory computer readable storage medium having stored thereon a computer program which, when executed by a processor, carries out the steps of the method of drawing an electrical wiring diagram as described in any one of the above.
According to the method and the system for drawing the electrical wiring diagram, the electrical wiring diagram is drawn in the mode of drawing the EXCEL spreadsheet, the expression form of the scattered and distributed component schematic diagram is changed into the expression form of the centralized spreadsheet associated with the programming formula to be displayed, so that electrical workers can complete the wiring installation work more intuitively, the drawing efficiency of the electrical drawing is effectively improved, and the paper quantity of the electrical drawing is reduced.
Drawings
In order to more clearly illustrate the technical solutions of the present invention or the prior art, the drawings needed for the description of the embodiments or the prior art will be briefly described below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and those skilled in the art can also obtain other drawings according to the drawings without creative efforts.
FIG. 1 is a schematic two-dimensional structure of an electrical component of the prior art;
FIG. 2 is a flow chart diagram of a method of drawing an electrical wiring diagram provided by the present invention;
FIG. 3 is a schematic design diagram of a conventional terminal row in an electrical cabinet;
FIG. 4 is one of the electrical connections provided by the present invention;
FIG. 5 is a second schematic electrical connection provided by the present invention;
FIG. 6 is a third schematic diagram of the electrical wiring provided by the present invention;
FIG. 7 is a fourth schematic diagram of the electrical wiring provided by the present invention;
FIG. 8 is a fifth schematic diagram of the electrical wiring provided by the present invention;
FIG. 9 is a sixth schematic electrical connection provided by the present invention;
FIG. 10 is a seventh schematic electrical connection provided by the present invention;
FIG. 11 is an eighth schematic electrical connection provided by the present invention;
FIG. 12 is a ninth schematic electrical connection provided by the present invention;
FIG. 13 is a tenth of the electrical wiring schematic provided by the present invention;
FIG. 14 is a schematic structural view of a system for drawing electrical wiring diagrams provided by the present invention;
fig. 15 is a schematic structural diagram of an electronic device provided by the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention clearer, the technical solutions of the present invention will be clearly and completely described below with reference to the accompanying drawings, and it is obvious that the described embodiments are some, but not all embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
It should be noted that in the description of the embodiments of the present invention, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in a process, method, article, or apparatus that comprises the element. The terms "upper", "lower", and the like, indicate orientations or positional relationships based on the orientations or positional relationships shown in the drawings, and are only for convenience in describing the present invention and simplifying the description, but do not indicate or imply that the referred devices or elements must have a specific orientation, be constructed and operated in a specific orientation, and thus, should not be construed as limiting the present invention. Unless expressly stated or limited otherwise, the terms "mounted," "connected," and "connected" are intended to be inclusive and mean, for example, that they may be fixedly connected, detachably connected, or integrally connected; can be mechanically or electrically connected; they may be connected directly or indirectly through intervening media, or they may be interconnected between two elements. The specific meanings of the above terms in the present invention can be understood by those skilled in the art according to specific situations.
Methods and systems for drawing electrical wiring diagrams provided by embodiments of the present invention are described below in conjunction with fig. 1-15.
Fig. 2 is a schematic flow chart of a method for drawing an electrical wiring diagram provided by the present invention, as shown in fig. 2, including but not limited to the following steps:
step S1: determining a terminal number list of a target element according to the type of the target element to be drawn;
step S2: determining a connecting element electrically connected with the target element, and determining a connecting element list according to the wiring relation between the target element and the connecting element;
step S3: drawing the terminal number list and the connecting element list on the same electrical wiring diagram, wherein the electrical wiring diagram is an EXCEL spreadsheet; each item in the list of connecting elements corresponds one-to-one to each terminal number in the list of terminal numbers.
Fig. 3 is a schematic design diagram of a terminal row in a conventional electrical cabinet, and as shown in fig. 3, the upper columns "2X 80, 2X81, 2X82 and 2X 83" indicate the positions of the terminal row, for example, "2X 80" represents the terminal row 2, 80 th column. The lower ends "04504, 04505, 04506, PE" represent cable number designations (or called wire numbers).
Because the electrical wiring diagram drawn based on AutoCAD adopted in the prior art, two or more components needing to be connected are distributed in different drawings, or the same wire number is distributed on different types of component contacts such as a terminal strip, a relay contact, a contactor contact and the like of an electrical cabinet in a stray manner according to the connected object, so that the working difficulty is increased in the actual wiring process, and the efficiency of drawing construction is greatly influenced. In view of the above, the present invention provides a method for drawing an electrical wiring diagram, which uses an EXCEL spreadsheet to draw the terminal numbers of all terminals of each target element and the connection relationships of other elements connected to each terminal in the same EXCEL table, so as to realize the presentation form of a scattered and distributed element connection relationship related to the target element into a correlated and concentrated spreadsheet, thereby providing convenience for electrical personnel to realize line installation or fault handling according to the drawn electrical wiring diagram.
Alternatively, the target component may be any control component in an electrical cabinet, such as: the present invention is not limited to any particular one of the components of an air switch, a programmable Controller (CPU), an I/O module, a bus duct, a dc power supply, an intermediate relay, a contactor, a frequency converter, a connection terminal, a switch, a button, a touch screen interface module of a human-computer interface, and the like.
Furthermore, the method for drawing the electrical wiring diagram provided by the invention can be applied to drawing the wiring diagram under the condition of wiring in all complex electrical cabinet cabinets, such as a frequency converter controlled single-speed motor, a frequency converter controlled double-speed no-brake motor, a frequency converter controlled double-speed brake motor, a contactor controlled double-speed no-brake motor and the like.
Fig. 4 is one of schematic electrical connection diagrams provided by the present invention, and in order to clearly show a drawing method of the electrical connection diagram provided by the present invention, the present embodiment is described by taking fig. 4 as an example.
Determining a terminal number list of the target element according to the type of the target element to be drawn, wherein the step is as follows: and acquiring whether the type of the target element to be drawn is a frequency converter, a programmable controller or other elements, and determining all the terminal numbers of the target element according to different types of elements so as to create a corresponding terminal number list.
For example, in the electrical wiring diagram drawing process shown in fig. 4, in the case where the target component is determined to be a type of inverter, all the terminal numbers thereof are first determined in accordance with the configuration of the input-output terminals of the inverter, thereby creating a terminal number list of the inverter.
Further, according to the operation control design of the whole electrical system, under the condition that the frequency converter is used for realizing the control of the double-speed non-braking motor, all the connecting elements which need to be connected with the frequency converter and the wiring relation between each connecting element and the frequency converter are obtained. Specifically, it is necessary to collect connection terminals of other connection elements connected to respective input/output terminals of the frequency converter, thereby creating a connection element list.
Taking fig. 4 as an example, the list of terminal numbers of the determined frequency converter U2076 is: l1, L2, L3, U, V, W, LI1, LI2, LI3, COM and PE, in practical design, the connecting element connected to its terminals L1, L2, L3 is a breaker Q2076; the connection elements connected with its terminal U, V, W are terminal rows 2X1, 2X2 and 2X 3; the connecting elements connected with the terminals LI1, LI2 and LI3 are three wiring ports A6, A3 and A7 of the PLC module ET 200S; the connection element connected to its terminal COM is terminal row 3X 12; the connection element connected to its terminal PE is the terminal row 2X4, whereby a list of connection elements Q2076, 2X1, 2X2, 2X3, ET200S a6, ET200S A3, ET200S a7, 3X12, 2X4 corresponding to the list of terminal numbers of the inverter U2076 can be constructed. Wherein, each item in the connection element list is in one-to-one correspondence with each terminal number in the terminal number list.
Further, after the connection element list and the terminal number list are determined, the connection element list and the terminal number list may be drawn in the same EXCEL spreadsheet as an electrical wiring diagram of the frequency converter U2076.
In fig. 4, the terminal number list is drawn in the B column of the EXCEL spreadsheet and the corresponding connection element list is drawn in the E column of the EXCEL spreadsheet, which is only one drawing method of the present invention, but the drawing method is not the only drawing method of the present invention, and for example, the terminal number list may be drawn in any column of the EXCEL spreadsheet and the connection element list may be drawn in the corresponding other column; or the list of terminal numbers is drawn in any row of the EXCEL spreadsheet and the list of connected elements is drawn in its corresponding other row.
According to the method for drawing the electrical wiring diagram, the electrical wiring diagram is drawn by drawing the EXCEL spreadsheet, the expression form of the scattered and distributed component schematic diagram is changed into the expression form of the centralized spreadsheet associated with the programming formula to be displayed, so that electrical workers can complete wiring installation more intuitively, the drawing efficiency of the electrical drawing is effectively improved, and the quantity of electrical drawing paper is reduced.
Based on the content of the above-mentioned embodiment, as an alternative embodiment, after the terminal number list and the connection element list are drawn on the same electrical wiring diagram, the method further includes:
acquiring cable number identifications for realizing electric connection between each wiring terminal of the target element and the connecting element, and determining a line number identification list of the target element; drawing the line number identification list in the EXCEL spreadsheet; in the EXCEL spreadsheet, each item in the line number identification list corresponds to each terminal number in the terminal number list one-to-one.
The cable line number mark is also called a line number, and generally is a mark number which is formed by sleeving a line number pipe on a wiring position of an electric wire, and the line number not only can play a role in electrical installation and construction, but also provides correct guarantee for operation and maintenance personnel to carry out daily maintenance and abnormal accident treatment. Therefore, in the drawing method of the electrical wiring diagram provided by the invention, after the terminal number list of the target element and the connection element list are determined, the cable number identification for realizing the electrical connection between each item in the connection element list and each terminal number in the terminal number list is determined according to the wiring relation between the target element and the connection element, so as to construct the line number identification list.
Taking the electrical wiring diagram shown in fig. 4 as an example, after determining the terminal number list and the connection element list of the inverter U2076, the wire numbers of the three wires whose terminals L1, L2, L3 are connected with the breaker Q2076 are determined to be 207601 and 207603 respectively according to the corresponding relationship between the two; the wire numbers of three electric wires of which the terminals U, V, W are connected with the terminal rows 2X1, 2X2 and 2X3 are 207604 and 207606 respectively; the wire numbers of three wires of which the terminals LI1, LI2 and LI3 are connected with three wiring ports A6, A3 and A7 of the PLC module ET200S are 2076A3-2076A5 respectively; the wire number of the electric wire whose terminal COM is connected to the terminal row 3X12 is 24M; the wire whose terminal PE is connected to the terminal block 2X4 has a wire number PE. Further, all the line numbers are organized into a line number identification list according to the sequence corresponding to the arrangement sequence of the terminal numbers in the terminal number list. In the case where the terminal number list is drawn in the B column, the line number identification list may be drawn in the C column.
The drawing method of the electrical wiring diagram provided by the invention provides a method for drawing the electrical wiring relation of a target element, including drawing the line number of the connecting line and realizing the same EXCEL table, clearly and simply reflecting the actual wiring relation, and providing convenience for normal work of electrical installation personnel and operation and maintenance personnel.
Based on the content of the above-mentioned embodiment, as an alternative embodiment, after the terminal number list and the connection element list are drawn in the same electrical wiring diagram, the method further includes:
acquiring cable diameter requirements for realizing electric connection between each wiring terminal of the target element and the connecting element, and determining a cable diameter requirement list of the target element; drawing the line diameter requirement list in an EXCEL spreadsheet; in the EXCEL spreadsheet, each entry in the line diameter requirement list corresponds one-to-one to each terminal number in the terminal number list.
Because each different electrical component has different characteristics and different connection modes with other connection components, different wire diameters are required to realize the connection between the terminals. Generally, during normal operation, the larger the current passing through the wire used, the thicker the wire diameter of the wire required.
The drawing method of the electrical wiring diagram fully considers the design requirements for the wire diameter in the electrical wiring, determines the wire diameter requirement of the cable for realizing the electrical connection between each item in the connection element list and each terminal number in the terminal number list according to the wiring relation between the target element and the connection element after determining the terminal number list and the connection element list of the target element, so as to construct the wire diameter requirement list.
Taking the electrical wiring diagram shown in FIG. 4 as an example, after determining the terminal number list and the connection element list of the inverter U2076, the three wires whose terminals L1, L2, L3 are connected with the breaker Q2076 are all required to have the wire diameter of 1mm according to the corresponding relationship between the two2(ii) a Three wires of which the terminal U, V, W is connected with the terminal rows 2X1, 2X2 and 2X3 respectively have the wire diameter requirement of 1mm2(ii) a The wire diameter requirements of three wires of which the terminals LI1, LI2 and LI3 are connected with three wiring ports A6, A3 and A7 of the PLC module ET200S are respectively 0.4mm2(ii) a The wire diameter of the wire connecting the terminal COM and the terminal row 3X12 is required to be 0.5mm2(ii) a The wire number of the electric wire whose terminal PE is connected with the terminal row 2X4 is 1mm2. And further, constructing a wire diameter requirement list according to the sequence corresponding to the arrangement sequence of each terminal number in the terminal number list by using all the wire diameter requirements. In the case where the terminal number list is drawn in the B column, the wire diameter requirement list may be drawn in the D column.
The drawing method of the electrical wiring diagram provided by the invention provides a method for drawing the electrical wiring relation of the target element, including the drawing of the wire diameter requirement of the connecting wire and the realization mode of the same EXCEL table, clearly and simply reflecting the actual wire selection requirement, so as to fully ensure the safety of the related electrical system. .
Based on the content of the above embodiment, as an alternative embodiment, before the terminal number list and the connection element list are drawn on the same electrical wiring diagram, the method further includes: formulating an EXCEL spreadsheet template of each kind of element and creating a spreadsheet template library; the first behavior form title column of each EXCEL electronic form template comprises an element label item, an equipment terminal number item, a line diameter item and a connecting element item; a terminal number list of elements is pre-drawn in a column where an equipment terminal number item of the EXCEL spreadsheet template is located; pre-drawing a line number identification list of elements in a column where a line number item of the EXCEL electronic form template is located; pre-drawing a line diameter requirement list of elements in a column where a line diameter item of the EXCEL spreadsheet template is located; and the terminal number list, the line number identification list and the line diameter requirement list are in one-to-one correspondence.
Since the input/output terminals of different kinds of electrical components have their own characteristics, the lists of terminal numbers of common frequency converters are generally the same, that is, they can be expressed as: l1, L2, L3, U, V, W, LI1, LI2, LI3, COM and PE. In addition, the requirements for the line number designation method and the line diameter of the input/output port wiring are generally the same for the same type of electric component.
On the basis of fully considering the characteristics of the electrical elements, the drawing method of the electrical wiring diagram provided by the invention can create a table template library in advance. Wherein the form template library pre-compiles corresponding EXCEL spreadsheet templates from different types of electrical components.
When a drawing person needs to draw an electrical wiring diagram of a certain target element, only the equipment number of the target element needs to be input in the remark column, and the EXCEL spreadsheet template of the electrical element corresponding to the equipment number can be displayed on the drawing interface.
As shown in fig. 4, when the drafter inputs 2076 in the remarks column, the data related to the a-D columns is automatically retrieved, and the user only needs to determine the connection component list electrically connected to the inverter U2076 and draw the connection component list in the E-th column, so as to draw the electrical wiring diagram of the inverter U2076.
FIG. 5 is a second schematic diagram of the electrical wiring diagram provided by the present invention, and as shown in FIG. 5, the entire EXCEL spreadsheet template is composed of the following major components:
1) table title column: from A1-B1-C1-D1-E1-F1 of the table, an element number item, an equipment terminal number item, a line diameter item, and a connection element item are drawn in advance in this order, and in the case where the target element is a frequency converter, are drawn in this order: frequency converter element, frequency converter terminal number, line diameter, connecting element, remark.
2) The names and labels of the target elements are drawn in advance in a merging display mode at A2-A12 corresponding to the frequency converter elements: u2076.
3) The list of terminal numbers is located in the column where the equipment terminal number entry is located, and is particularly drawn in B2-B12.
4) The line number identification list is located in the column where the line number item is located, and is particularly drawn in C2-D12.
5) The line diameter requirement list is located in the column of the line diameter item, and is particularly drawn in E2-E12.
Further, after calling the EXCEL spreadsheet template, the user may determine a connection element list according to the electrical connection relationship between the actual target element and the connection element, and draw each item in the connection element list to the column of the connection element item shown in fig. 5, specifically to F2F 12, according to the corresponding relationship between each item in the connection element list and each terminal number in the terminal number list.
E2-E4 are contacts at the upper end of the frequency converter and are connected with contacts at the lower end of a breaker Q2076; E5-E7 are contacts at the lower end of the frequency converter, and the row positions of the connection terminals are 2X1, 2X2 and 2X3 respectively; E8-E10 are contacts at the lower end of the frequency converter and are respectively connected with A6, A3 and A7 physical addresses of an ET200S module; E11-E12 are contacts at the lower end of the frequency converter, and the connection terminal row positions are 3X12 and 2X4 respectively.
The method for drawing the electrical wiring diagram comprises the steps of compiling an EXCEL spreadsheet template corresponding to each type of electrical element in advance to construct an EXCEL spreadsheet template library; when the user actually designs, the corresponding template can be called out only according to the type of the target element to be drawn, so that the drawing efficiency of the wiring diagram can be effectively improved, and the probability of errors caused by manual filling is avoided.
Based on the content of the above-mentioned embodiment, as an alternative embodiment, the drawing the terminal number list and the connection element list on the same electrical wiring diagram includes: calling an EXCEL electronic form template of the target element from the form template library according to the type of the target element; the form title bar of the EXCEL spreadsheet template further comprises at least one remark item; inputting the device number of the target element in the column where the remark item is located based on an EXCEL spreadsheet function, so as to draw the device label of the target element in the column where the element label item is located; and drawing the connecting element list of the target element in the column of the connecting element item of the EXCEL spreadsheet template.
Taking the drawing of the electrical wiring diagram shown in fig. 5 as an example, the invention provides a method for calling an EXCEL spreadsheet template, namely calling a blank EXCEL spreadsheet from a drawing interface, wherein the form at least comprises a form title column, namely, a frequency converter element, a frequency converter terminal number, a line diameter, a connecting element and at least one remark item are pre-drawn in a line a1 (which may be any line or any column).
When the user inputs the device number 2076 of the target element in the column of the remark item, the system calls the EXCEL spreadsheet template of the electrical element corresponding to the device number 2076 by default, and this step can be understood as two steps, one is to call the EXCEL spreadsheet template of which the type is a frequency converter, and the other is to draw the device number of the target element in the column of the EXCEL spreadsheet template element number item, so as to display the device number on a drawing interface, so that the relevant person can continue to draw other contents in the template.
The device number of each electrical component may be preset according to the type of all electrical components installed in the whole electrical system and the number of each electrical component, such as setting the device number of the frequency converter to be U1-Uk (where K is the total number of all frequency converters in the system), setting the number of the circuit breaker to be Q1-Qn (where n is the total number of all circuit breakers in the system), setting the number of the relay to be K1-Km (where m is the total number of all relays in the system), and the like, and this embodiment is not particularly limited.
Optionally, the rendering of the other content mainly includes: the determined list of connected elements is drawn in the column of the EXCEL spreadsheet template in which the connected element item resides.
The method includes the steps that a self-defined address corresponding to an output digital quantity module physical address in a connection element list is input to a column corresponding to a remark item based on an EXCEL spreadsheet function, and the following implementation mode can be adopted to achieve the function of one-to-one correspondence from the self-defined parameter (input/output address) to the module physical address by embedding a related source program into the spreadsheet function in advance.
The function variable may contain different corresponding values of 8 points of the ET200S module, and one statement is suitable for the custom (input \ output) variation value of the 8 points. Therefore, the source program amount is only 1 line. The number of the user-defined (input/output) points is different for each item according to the difference of the total equipment number, so that the total amount of the source program is different.
The composition of the source program will be described below with reference to the chart contents of E8 shown in fig. 4.
The contents are as follows:
E8＝"ET200S-"&G8&IF(H8＝0,1,IF(H8＝1,5,IF(H8＝2,2,IF(H8＝3,6,IF(H8＝4,3,IF(H8＝5,7,IF(H8＝6,4,IF(H8＝7,8,9))))))))
the source code is divided into three parts:
a first part: the module name 'ET 200S-' is separated from the module address by a short bar.
A second part: the alphabet filled in the 'G8' cell, shown in fig. 4 is the letter 'a', which is one of the elements of the custom physical address (the letters can be set arbitrarily, and in the same electrical cabinet, the letters of the input/output module are all unique).
And a third part: nested statements of IF (hypothetical statements) functions. Nesting nine times in total.
Namely: if the parameter is '0', then write to '1';
if the parameter is '1', then write to '5';
if the parameter is '2', then write to '2';
if the parameter is '3', then write to '6'; (in FIG. 4, the last digit at E8 shows '6')
If the parameter is '4', then write to '3'; (in FIG. 4, the last digit at E9 shows '3')
If the parameter is '5', then write to '7'; (in FIG. 4, the last digit at E9 shows '7')
If the parameter is '6', then write to '4';
if the parameter is '7', then write to '8';
if the parameter is greater than 7, write to '9';
the first eight nested statements are designed to have one-to-one correspondence between input/output points (0 to 7) of the design and physical addresses on the ET200S module.
The ninth nested statement is an error statement. If the number '9' occurs once, it means that the ET200S module physical address does not exist.
In a spreadsheet. In essence, these codes have evolved from 1 line of source code.
The process includes:
E8＝"ET200S-"&G8&IF(H8＝0,1,IF(H8＝1,5,IF(H8＝2,2,IF(H8＝3,6,IF(H8＝4,3,IF(H8＝5,7,IF(H8＝6,4,IF(H8＝7,8,9))))))))
the method comprises the following steps:
E9＝"ET200S-"&G9&IF(H9＝0,1,IF(H9＝1,5,IF(H9＝2,2,IF(H9＝3,6,IF(H9＝4,3,IF(H9＝5,7,IF(H9＝6,4,IF(H9＝7,8,9))))))))
the procedure is as follows:
E10＝"ET200S-"&G10&IF(H10＝0,1,IF(H10＝1,5,IF(H10＝2,2,IF(H10＝3,6,IF(H10＝4,3,IF(H10＝5,7,IF(H10＝6,4,IF(H10＝7,8,9))))))))
in these three procedures, the differences exist:
'E8, G8, H8' appearing in the procedure. Procedure 'E9, G9, H9' occurring in the second; the procedure 'E10, G10, H10' as found in the third; the rest of the program statement is identical.
'E8, G8, H8', 'E9, G9, H9', 'E10, G10, H10', etc. represent different positions of the cells. Therefore, a device number corresponds to 3 program statements, first, because the electrical element 2076 has 3 output points. Secondly, the cell positions corresponding to the 3 output points are different, the program contents are not completely the same, and the rest of the program logic parts are completely the same.
As shown in fig. 4, if there are 3 custom addresses, 3 lines of source codes need to be copied, and the source codes are copied by dragging the black "+" sign at the lower right of the cell (see item 2 of the caption text in fig. 4). And copying the corresponding source code line number aiming at different custom points.
For example: the 'double-speed motor' in the 'frequency converter controlled double-speed no-brake motor' is that the motor has two speeds of low speed and high speed, the frequency converter needs 3 output points to control, and 3 self-defined addresses 'A3, A4 and A5' shown in figure 5 appear. If the frequency converter controls a single-speed motor, only the low speed is needed, but the high speed is not needed, and the frequency converter only needs 2 output points for control. Then only 2 custom addresses will appear, as shown in fig. 10.
According to the drawing method of the electrical wiring diagram, the drawing speed can be effectively improved and the error rate caused by manual conversion can be reduced through a software programming mode, and the program can be copied and pasted according to the software characteristics of the electronic form, and the corresponding row and column can be automatically matched without independent programming.
The method for drawing the electrical wiring diagram provided by the invention provides a method for quickly calling the EXCEL spreadsheet template, a user only needs to input the equipment label of the target element in the blank template to finish the calling of the corresponding template, the method is convenient and quick, special drawing skill requirements are met for a person who does not need drawing, and the method is suitable for the operation of any person.
Based on the content of the foregoing embodiment, as an optional embodiment, the drawing the connection element list of the target element in the column where the connection element item of the EXCEL spreadsheet template is located includes:
inputting the number of terminal rows and the number of terminal columns corresponding to the terminal row numbers in the connecting element list to a first preset position of the remark item corresponding to the terminal row number on the basis of an EXCEL spreadsheet function so as to draw the terminal row number in a column of the connecting element item of the EXCEL spreadsheet template, wherein the first preset position is a position corresponding to the terminal row number;
inputting a custom address corresponding to an output numerical quantity module physical address in the connecting element list to a second preset position of the remark item based on an EXCEL spreadsheet function to draw the output numerical quantity module physical address in a column of the EXCEL spreadsheet template where the connecting element item is located, the second preset position being a position corresponding to the output numerical quantity module physical address.
The invention provides an input method for quickly completing a connection element list.
From the contents of the above embodiments, it can be known that: according to the drawing method of the electrical wiring diagram, the user can call the corresponding EXCEL spreadsheet template by inputting the equipment label of the target element, the drawing of the related contents of the element label item, the equipment terminal number item, the line number item and the line diameter item is drawn in the template in advance, and related personnel only need to add the connection element list into the column where the connection element item is located. For the entire electrical system, if each of the connection element lists is entered manually into the column individually, the effort is enormous and error-prone.
In view of the above disadvantage, the present invention provides a drawing method, wherein a user can make a quick input method according to the characteristics and commonality of each item in the sequence of connection elements, taking the drawing of the electrical wiring diagram shown in fig. 5 as an example:
the whole EXCEL spreadsheet comprises two areas, wherein the first area is an automatic generation area and is used for displaying a current drawn electrical wiring diagram; the second area is an input area, wherein the input mode can be manual input.
As shown in fig. 5, the drawing staff only needs to input corresponding parameters in the second area, and the parameters are respectively as follows:
the input first parameter is the equipment number of the target element, and correspondingly, the equipment number of the target element is drawn in the column where the element number item is located;
the second parameter is input as number 2, which indicates the 2 nd line of the starting address of the connecting terminal; the third parameter is input as number 1, which indicates the 1 st column of the start address of the connection terminal. Accordingly, in the column where the connection element items are located, the terminal row numbers 2X1, 2X2, 2X3 (three numbers arranged in order from 2X 1) are drawn at positions corresponding to the positions where the second parameter and the third parameter are located (first preset positions).
The fourth and fifth parameters are input as a and 3, and the output point of the ET200S module for the custom address a is 3. Accordingly, the output digital quantity module physical address ET200S-A6 of the ET200S module is plotted at the position corresponding to the position of the fourth parameter and the position of the fifth parameter in the column where the connected element items are located.
Correspondingly, for the sixth parameter and the seven parameters which are input, the output digital quantity module physical address ET200S-A3 of the ET200S module is plotted; the output digital quantity module physical address ET200S-a7 of the ET200S module is plotted for the input eighth and ninth parameters.
It should be noted that the connection component list of each electrical component may be input in the above manner, and the difference is only that the drawing content in the first area is affected by the difference in the number of parameters and the braking and non-braking of the inverter-controlled motor device, the two-speed motor and the single-speed motor, and the like.
In addition, specific mention is made of: the design of electrical drawings considers the practical application on site, and generally designs the output address of one electrical device as a continuous number so as to avoid the inconvenience on wiring caused by the digital disconnection design.
However, the existence of the discontinuous output address is not excluded, and if the output address of certain electrical equipment is discontinuous in number and disconnected, the method for drawing the electrical wiring diagram provided by the invention only needs to modify the continuously drawn output point into an actual output point on the basis of the original drawing.
As shown in fig. 5, the custom address input ends corresponding to the three patch ports of the PLC module are A3, a4 and a5, respectively, and the three patch ports of the PLC module corresponding thereto are ET200S-a6, ET200S-A3 and ET200S-a7, respectively. However, in practice, the three outputs are not continuous, and therefore need to be modified.
Fig. 6 is a third schematic diagram of electrical connection provided by the present invention, and as shown in fig. 6, when the custom address input terminals corresponding to the three connection ports of the PLC module are modified to A3, a4 and a6, respectively, the three connection ports of the PLC module corresponding thereto are modified to ET200S-a6, ET200S-A3 and ET200S-a 4.
Therefore, the drawing method of the electrical wiring diagram provided by the invention can automatically draw the connection element list in the EXCEL spreadsheet template according to the characteristics of the connection element in the drawing process, namely, only a few numbers need to be input, and only relevant numbers need to be modified even if the actual wiring relation changes, thereby effectively improving the drawing efficiency and ensuring the accuracy of the drawing result.
Based on the content of the foregoing embodiment, as an optional embodiment, the drawing the connection element list of the target element in the column where the connection element item of the EXCEL spreadsheet template is located further includes: and presetting fixed connection items in the connection element list in the column where the connection element items of the EXCEL spreadsheet template are positioned.
In the process of drawing the connection element list on the EXCEL spreadsheet template, simple numbers are input for items such as terminal blocks, physical addresses of output digital quantity modules of PLC modules and the like to realize drawing, and for some electric elements with common electrical connection relations, the items are drawn in the template in advance, for example, fixed connection items such as "Q2076", "3X 12" or "2X 4" shown in fig. 5 can be preset in columns of the EXCEL spreadsheet template where the connection element items are located.
It should be noted that the fixed connection items such as "Q2076", "3X 12" or "2X 4" shown in fig. 5 are only distances for convenience of description, and are not intended to specifically limit the scope of the present invention.
As an alternative embodiment, the drawing method of the electrical wiring diagram provided by the invention can also be used for drawing the electrical wiring diagram of the isolation relay.
Fig. 7 is a fourth schematic diagram of the electrical connection provided by the present invention, as shown in fig. 7, wherein the electrical connection diagram of six electrical components in total, such as the isolation relays QMKM1 and QMKM2, and the relays QMKM7 and QMKM8, is drawn.
As an alternative embodiment, the drawing method of the electrical wiring diagram provided by the invention can also be used for drawing the electrical wiring diagram of the frequency converter control two-speed brake motor.
Fig. 8 is a fifth schematic diagram of the electrical connection provided by the present invention, as shown in fig. 8, in which the electrical connection diagram of six electrical components including the frequency converters U1221 and U1231, and the contactors Q1221 and Q1231 and the relays K1221 and K1231, which are used together to realize the motor control, are drawn.
As an alternative embodiment, the drawing method of the electrical connection diagram provided by the invention can also be used for drawing the electrical connection diagram of the frequency converter control two-speed non-braking motor.
Fig. 9 is a sixth schematic diagram of the electrical wiring provided by the present invention, as shown in fig. 9, an electrical wiring diagram between the frequency converters U2076 and U2096 is drawn together.
As an alternative embodiment, the drawing method of the electrical wiring diagram provided by the invention can also be used for drawing the electrical wiring diagram of the frequency converter control brake-free single motor.
Fig. 10 is a seventh schematic diagram of the electrical connection provided by the present invention, as shown in fig. 10, wherein an electrical connection diagram between the frequency converters U1013 and U1136 is shown.
As an alternative embodiment, the drawing method of the electrical connection diagram provided by the invention can also be used for drawing the electrical connection diagram of the frequency converter controlling the two-speed braking motor and sharing the same circuit breaker with the braking lifting platform.
Fig. 11 is an eighth schematic diagram of the electrical connection provided by the present invention, as shown in fig. 11, in which an electrical connection diagram of six electrical elements, including the frequency converters U1024 and U1038, and the contactors KM1033 and KM1037 and the relays K1033 and K1037, which together implement motor control, is drawn.
As an alternative embodiment, the drawing method of the electrical connection diagram provided by the invention can also be used for drawing the electrical connection diagram of the frequency converter for controlling the two-speed non-braking motor and sharing the same circuit breaker with the braking lifting platform.
Fig. 12 is a ninth schematic electrical connection diagram of the present invention, as shown in fig. 12, wherein the electrical connection diagram is drawn with six electrical components, i.e., the frequency converters U1214 and U1218, and the contactors KM1213 and KM1217 and the relays K1213 and K1217, which together implement motor control.
As an alternative embodiment, the drawing method of the electrical wiring diagram provided by the invention can also be used for drawing the electrical wiring diagram of a frequency converter control single-speed motor which shares the same circuit breaker with the brake lifting platform.
Fig. 13 is a tenth of the electrical connection diagram provided by the present invention, as shown in fig. 13, in which the electrical connection diagram of six electrical components, such as the frequency converters U1028 and U1128, and the contactors KM1027 and KM1127 and the relays K1027 and K1127, which are used for realizing motor control together with the frequency converters U1028 and U1128, are drawn.
According to the drawing method of the electrical wiring diagram, provided by the invention, on the basis of the light software of the EXCEL spreadsheet, the wiring method in the electrical cabinet realized by programming clearly shows the trend of the wiring path of each component in a chart form on the basis of the light software. For example: the module is connected with the frequency converter, the relay and the contactor, and then is connected with other equipment such as a terminal, so that the wiring drawing becomes clearer and more clearly understood, the wiring drawing is shallowly and easily understood, and the internal linear velocity of the electrical cabinet is improved. The method has high popularity and quick operation, gets rid of the drawing limitation of large professional software, and is a novel drawing application technology.
Fig. 14 is a schematic structural diagram of a system for drawing an electrical wiring diagram provided by the present invention, as shown in fig. 14, which mainly includes: a first reading unit 1, a second reading unit 2, and a drawing unit 3, wherein:
the first reading unit 1 is mainly used for determining a terminal number list of a target element according to the type of the target element to be drawn; the second reading unit 2 is mainly used for determining a connecting element electrically connected with the target element, and determining a connecting element list according to the wiring relation between the target element and the connecting element; the drawing unit 3 is mainly used for drawing the terminal number list and the connecting element list on the same electrical wiring diagram, wherein the electrical wiring diagram is an EXCEL spreadsheet; each item in the list of connecting elements corresponds one-to-one to each terminal number in the list of terminal numbers.
The system for drawing the electrical wiring diagram provided by the invention adopts a mode of drawing an EXCEL spreadsheet to draw the electrical wiring diagram, and changes the expression form of a scattered and distributed component schematic diagram into the expression form of a centralized spreadsheet associated with a programming formula to display, so that electrical workers can more intuitively finish the wiring installation work, the drawing efficiency of an electrical drawing is effectively improved, and the paper quantity of the electrical drawing is reduced.
It should be noted that, when being specifically executed, the system for drawing an electrical wiring diagram provided in the embodiment of the present invention may be implemented based on the method for drawing an electrical wiring diagram described in any of the above embodiments, and details of this embodiment are not described herein.
Fig. 15 is a schematic structural diagram of an electronic device provided in the present invention, and as shown in fig. 15, the electronic device may include: a processor (processor)510, a communication interface (communication interface)520, a memory (memory)530 and a communication bus 540, wherein the processor # 10, the communication interface 520 and the memory 530 communicate with each other via the communication bus 540. Processor 510 may invoke logic instructions in memory 530 to perform a method of electrical wiring diagram drawing, the method comprising: determining a terminal number list of the target element according to the type of the target element to be drawn; determining a connecting element electrically connected with the target element, and determining a connecting element list according to the wiring relation between the target element and the connecting element; drawing a terminal number list and the connecting element list on the same electrical wiring diagram, wherein the electrical wiring diagram is an EXCEL spreadsheet; each item in the list of connection elements corresponds one-to-one to each terminal number in the list of terminal numbers.
Furthermore, the logic instructions in the memory 530 may be implemented in the form of software functional units and stored in a computer readable storage medium when the software functional units are sold or used as independent products. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: various media capable of storing program codes, such as a usb disk, a removable hard disk, a Read-only memory (ROM), a Random Access Memory (RAM), a magnetic disk, or an optical disk.
In another aspect, the present invention also provides a computer program product comprising a computer program stored on a non-transitory computer-readable storage medium, the computer program comprising program instructions which, when executed by a computer, enable the computer to perform a method for drawing an electrical wiring diagram provided by the above methods, the method comprising: determining a terminal number list of the target element according to the type of the target element to be drawn; determining a connecting element electrically connected with the target element, and determining a connecting element list according to the wiring relation between the target element and the connecting element; drawing a terminal number list and the connecting element list on the same electrical wiring diagram, wherein the electrical wiring diagram is an EXCEL spreadsheet; each item in the list of connection elements corresponds one-to-one to each terminal number in the list of terminal numbers.
In yet another aspect, the present invention also provides a non-transitory computer-readable storage medium, on which a computer program is stored, the computer program being implemented by a processor to perform the method for drawing an electrical wiring diagram provided in the above embodiments, the method including: determining a terminal number list of the target element according to the type of the target element to be drawn; determining a connecting element electrically connected with the target element, and determining a connecting element list according to the wiring relation between the target element and the connecting element; drawing a terminal number list and the connecting element list on the same electrical wiring diagram, wherein the electrical wiring diagram is an EXCEL spreadsheet; each item in the list of connection elements corresponds one-to-one to each terminal number in the list of terminal numbers.
The above-described embodiments of the apparatus are merely illustrative, and the units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of the present embodiment. One of ordinary skill in the art can understand and implement it without inventive effort.
Through the above description of the embodiments, those skilled in the art will clearly understand that each embodiment can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware. With this understanding in mind, the above-described technical solutions may be embodied in the form of a software product, which can be stored in a computer-readable storage medium such as ROM/RAM, magnetic disk, optical disk, etc., and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to execute the methods described in the embodiments or some parts of the embodiments.
Finally, it should be noted that: the above examples are only intended to illustrate the technical solution of the present invention, but not to limit it; although the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions of the embodiments of the present invention.
Claims (10)
1. A method of drawing an electrical wiring diagram, comprising:
determining a terminal number list of a target element according to the type of the target element to be drawn;
determining a connecting element electrically connected with the target element, and determining a connecting element list according to the wiring relation between the target element and the connecting element;
drawing the terminal number list and the connecting element list on the same electrical wiring diagram, wherein the electrical wiring diagram is an EXCEL spreadsheet; each item in the list of connecting elements corresponds one-to-one to each terminal number in the list of terminal numbers.
2. The method of drawing an electrical wiring diagram of claim 1, further comprising, after drawing the list of terminal numbers and the list of connection elements on the same electrical wiring diagram:
acquiring cable number identifications for realizing electric connection between each wiring terminal of the target element and the connecting element, and determining a line number identification list of the target element;
drawing the line number identification list in the EXCEL spreadsheet;
in the EXCEL spreadsheet, each item in the line number identification list corresponds to each terminal number in the terminal number list one-to-one.
3. The method of drawing an electrical wiring diagram of claim 1, further comprising, after drawing the list of terminal numbers and the list of connection elements in the same electrical wiring diagram:
acquiring cable diameter requirements for realizing electric connection between each wiring terminal of the target element and the connecting element, and determining a cable diameter requirement list of the target element;
drawing the wire path requirement list in the EXCEL spreadsheet;
in the EXCEL spreadsheet, each entry in the line diameter requirement list corresponds one-to-one to each terminal number in the terminal number list.
4. The method of drawing an electrical wiring diagram of claim 1, further comprising, before drawing the list of terminal numbers and the list of connection elements on the same electrical wiring diagram:
formulating an EXCEL spreadsheet template of each kind of element and creating a spreadsheet template library;
a first behavior form title bar of each EXCEL spreadsheet template, the form title bar comprising an element label item, an equipment terminal number item, a line diameter item, a connection element item;
a terminal number list of elements is pre-drawn in a column where the equipment terminal number item of the EXCEL spreadsheet template is located;
pre-drawing a line number identification list of elements in a column where a line number item of the EXCEL spreadsheet template is located;
pre-drawing a line diameter requirement list of elements in a column where a line diameter item of the EXCEL spreadsheet template is located;
and the terminal number list, the line number identification list and the line diameter requirement list are in one-to-one correspondence.
5. The method of drawing an electrical wiring diagram of claim 4, wherein said drawing the list of terminal numbers and the list of connection elements to the same electrical wiring diagram comprises:
calling an EXCEL electronic form template of the target element from the form template library according to the type of the target element;
the form title bar of the EXCEL spreadsheet template further comprises at least one remark item;
inputting the device number of the target element in the column where the remark item is located based on an EXCEL spreadsheet function, so as to draw the device label of the target element in the column where the element label item is located;
and drawing the connecting element list of the target element in the column of the connecting element item of the EXCEL spreadsheet template.
6. The method for drawing an electrical wiring diagram according to claim 5, wherein the drawing the list of connection elements of the target element in the column of connection element items of the EXCEL spreadsheet template comprises:
inputting the number of terminal rows and the number of terminal columns corresponding to the terminal row numbers in the connecting element list to a first preset position of the remark item corresponding to the terminal row number on the basis of an EXCEL spreadsheet function so as to draw the terminal row number in a column of the connecting element item of the EXCEL spreadsheet template, wherein the first preset position is a position corresponding to the terminal row number;
inputting a custom address corresponding to an output numerical quantity module physical address in the connecting element list to a second preset position of the remark item based on an EXCEL spreadsheet function to draw the output numerical quantity module physical address in a column of the EXCEL spreadsheet template where the connecting element item is located, the second preset position being a position corresponding to the output numerical quantity module physical address.
7. The method of drawing an electrical wiring diagram of claim 5, wherein the drawing the list of connection elements of the target element in the column of connection element entries of the EXCEL spreadsheet template further comprises:
and presetting fixed connection items in the connection element list in the column where the connection element items of the EXCEL spreadsheet template are positioned.
8. A system for drawing an electrical wiring diagram, comprising:
the first reading unit is used for determining a terminal number list of a target element according to the type of the target element to be drawn;
the second reading unit is used for determining a connecting element electrically connected with the target element and determining a connecting element list according to the wiring relation between the target element and the connecting element;
the drawing unit is used for drawing the terminal number list and the connecting element list on the same electrical wiring diagram, and the electrical wiring diagram is an EXCEL spreadsheet; each item in the list of connecting elements corresponds one-to-one to each terminal number in the list of terminal numbers.
9. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor implements the method steps of drawing an electrical wiring diagram according to any one of claims 1 to 7 when executing the computer program.
10. A non-transitory computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the method steps of drawing an electrical wiring diagram according to any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110090698.0A CN112836248B (en) | 2021-01-22 | 2021-01-22 | Drawing method and system of electrical wiring diagram |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110090698.0A CN112836248B (en) | 2021-01-22 | 2021-01-22 | Drawing method and system of electrical wiring diagram |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112836248A true CN112836248A (en) | 2021-05-25 |
| CN112836248B CN112836248B (en) | 2024-05-28 |
Family
ID=75931092
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110090698.0A Active CN112836248B (en) | 2021-01-22 | 2021-01-22 | Drawing method and system of electrical wiring diagram |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112836248B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113592105A (en) * | 2021-07-01 | 2021-11-02 | 中船澄西船舶修造有限公司 | Drawing method and device of electrical system diagram |
| CN117911576A (en) * | 2024-03-20 | 2024-04-19 | 中国电建集团西北勘测设计研究院有限公司 | System and method for automatically generating terminal wiring diagrams among electrical cabinets in batch |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2002117090A (en) * | 2000-10-11 | 2002-04-19 | Komatsu Ltd | Method and system for preparing electric drawing |
| CN103514303A (en) * | 2013-10-29 | 2014-01-15 | 苏州利驰电子商务有限公司 | Method and system for recognizing electrical element wiring diagram |
| US8719758B1 (en) * | 2011-09-23 | 2014-05-06 | Custom Virtual Environments, Inc. | Methods and apparatus for automated wiring diagram generation |
| CN104007721A (en) * | 2014-05-08 | 2014-08-27 | 河北省电力勘测设计研究院 | Intelligent generation method of coal conveying program control wiring diagrams of heat-engine plants |
| CN104615794A (en) * | 2013-11-04 | 2015-05-13 | 苏州利驰电子商务有限公司 | Digital model construction method used in three-dimensional electrical wiring software |
| CN106570260A (en) * | 2016-11-03 | 2017-04-19 | 北京航天时代光电科技有限公司 | Electric connection relation automatic generation method |
| CN109558693A (en) * | 2018-12-25 | 2019-04-02 | 山东爱普电气设备有限公司 | Electrical primary main wiring diagram modular design method and system |
-
2021
- 2021-01-22 CN CN202110090698.0A patent/CN112836248B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2002117090A (en) * | 2000-10-11 | 2002-04-19 | Komatsu Ltd | Method and system for preparing electric drawing |
| US8719758B1 (en) * | 2011-09-23 | 2014-05-06 | Custom Virtual Environments, Inc. | Methods and apparatus for automated wiring diagram generation |
| CN103514303A (en) * | 2013-10-29 | 2014-01-15 | 苏州利驰电子商务有限公司 | Method and system for recognizing electrical element wiring diagram |
| CN104615794A (en) * | 2013-11-04 | 2015-05-13 | 苏州利驰电子商务有限公司 | Digital model construction method used in three-dimensional electrical wiring software |
| CN104007721A (en) * | 2014-05-08 | 2014-08-27 | 河北省电力勘测设计研究院 | Intelligent generation method of coal conveying program control wiring diagrams of heat-engine plants |
| CN106570260A (en) * | 2016-11-03 | 2017-04-19 | 北京航天时代光电科技有限公司 | Electric connection relation automatic generation method |
| CN109558693A (en) * | 2018-12-25 | 2019-04-02 | 山东爱普电气设备有限公司 | Electrical primary main wiring diagram modular design method and system |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113592105A (en) * | 2021-07-01 | 2021-11-02 | 中船澄西船舶修造有限公司 | Drawing method and device of electrical system diagram |
| CN113592105B (en) * | 2021-07-01 | 2023-12-26 | 中船澄西船舶修造有限公司 | Drawing method and device of electrical system diagram |
| CN117911576A (en) * | 2024-03-20 | 2024-04-19 | 中国电建集团西北勘测设计研究院有限公司 | System and method for automatically generating terminal wiring diagrams among electrical cabinets in batch |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112836248B (en) | 2024-05-28 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112836248A (en) | Method and system for drawing electrical wiring diagram | |
| CN106228338B (en) | A kind of distribution engineering intelligentized design integrated service system and application method | |
| CN103400007A (en) | Automatic generation method of secondary electrical schematic diagrams based on Auto CAD | |
| CN112613086B (en) | Electrical equipment assembling method and system | |
| CN109165781B (en) | Method and device for calculating single line diagram connection line path of electric power system and terminal equipment | |
| JP3505146B2 (en) | Small control device | |
| CN108319178B (en) | Frequency converter and method for automatically acquiring internal parameter information of product | |
| CN201113293Y (en) | Simulation disc for power transmission and distribution control | |
| CN105305619B (en) | A kind of three distant collocation methods and device based on power distribution automation | |
| CN109829612B (en) | Scheduling automation device information checking method and device | |
| CN202956653U (en) | Smart home remote control system | |
| CN111198908A (en) | Power grid asset graph display method and device, storage medium and terminal | |
| CN205184720U (en) | Tool management platform | |
| CN114282279A (en) | Automatic generation method and device for power supply diagram of industrial personal computer cabinet | |
| CN114818021A (en) | GIM model-based three-dimensional modeling digital handover method for secondary system equipment | |
| CN205827754U (en) | A kind of PLC experimental box supporting multiclass fieldbus | |
| CN220584676U (en) | Circuit board with interactive function | |
| CN111405022A (en) | Flexible networking communication platform for heterogeneous equipment | |
| CN111967115B (en) | Drawing method of power supply schematic diagram and computer equipment | |
| CN218161464U (en) | Electric control device of switch equipment | |
| CN112181520B (en) | Interface design method and configuration tool for energy equipment | |
| CN114116734B (en) | Intelligent data processing method and device for automation system and storage medium | |
| CN208953939U (en) | A kind of programmable PLC controller | |
| CN111564074A (en) | Power operation training method and system | |
| CN117272613A (en) | Electrical cabinet schematic diagram generation method, device, equipment and storage medium |
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 |