Drawing method and system of low-voltage power distribution cabinet system diagram

Abstract

The invention relates to the technical field of electrical design, and discloses a low-voltage power distribution cabinet system diagram drawing method and system, and the method comprises the steps: obtaining a prefabricated file; engineering information is input into the prefabricated low-voltage power distribution cabinet loop information table, and an effective low-voltage power distribution cabinet loop information table is generated through automatic calculation; an EXCEL VBA program is operated in the effective low-voltage power distribution cabinet loop information table, and an effective low-voltage power distribution cabinet loop arrangement table is automatically generated; adjusting the original input data, adjusting the result of model selection matching calculation, and automatically generating an effective low-voltage power distribution cabinet system diagram table by using a cell formula; an EXCEL VBA program is operated in the effective low-voltage power distribution cabinet system graph table, and a low-voltage power distribution cabinet system graph book file is automatically generated; running a CAD VBA program to read a low-voltage power distribution cabinet system image-text file, and automatically drawing a low-voltage power distribution cabinet system diagram; according to the method, the working efficiency and the design quality are effectively improved, the practicability is effectively improved, and meanwhile good compatibility is achieved.

Description

Technical Field

[0001] This application relates to the technical field of electrical design, and specifically to a method and system for drawing a low-voltage power distribution cabinet system diagram. Background Art

[0002] The design of low-voltage substation is one of the cores of industrial and civil power distribution design. Among them, the low-voltage power distribution cabinet system diagram is an essential design content. This diagram consists of two parts. The first part is the system single-line diagram, which shows the main components of the distribution circuit and their interconnection relationships. The second part is the system diagram table, which indicates the low-voltage power distribution cabinet number, circuit name, load capacity, calculated current, model specifications of components such as switches, and cable model and specifications.

[0003] The conventional design process is to first perform load calculation to calculate the calculated current of each circuit, and then perform selection and matching calculation, that is, determine the model specifications of components such as switches and the model specifications of cables according to the calculated current. After the cable specifications are initially determined, voltage loss verification is also required, and whether to adjust the cable specifications is determined according to the verification results. Finally, the system single-line diagram and the system diagram table of the low-voltage power distribution cabinet system diagram are manually drawn in CAD software.

[0004] Due to the large number of low-voltage distribution circuits and the need to modify the low-voltage power distribution cabinet system diagram every time the design scheme is adjusted, the drawing of the low-voltage power distribution cabinet system diagram is a relatively cumbersome task.

[0005] With the rapid development of computer technology, many auxiliary tools and programs have emerged in the field of industrial and civil design engineering, but there are generally certain limitations:

[0006] 1. The existing design methods only have load calculation and automatic drawing functions, and the selection and matching need to be completed manually; the manual method takes a long time and is prone to errors and omissions. Especially when the input value is adjusted during the design process, all steps that require manual participation from input to output need to be checked and adjusted, and the workload and error rate may increase exponentially.

[0007] 2. The existing design methods use EXCEL templates to make tables for convenient data and system diagram style adjustment, but when drawing, two software, EXCEL and CAD, need to be controlled by a program at the same time, which has relatively strict requirements for the software installation consistency of users and developers and has poor compatibility. The poor compatibility of auxiliary tools and programs will limit the scope of application and cannot effectively play a role. Summary of the Invention

[0008] The purpose of this application is to provide a method and system for drawing a low-voltage power distribution cabinet system diagram that can effectively improve work efficiency and design quality, thereby effectively improving practicability, and at the same time having good compatibility.

[0009] To achieve the above object, the present invention adopts the following technical solutions:

[0010] A method for drawing a system diagram of a low-voltage power distribution cabinet of the present invention includes the following steps:

[0011] S1. Obtain an EXCEL template file, a block file constituting the finished low-voltage power distribution cabinet system diagram, and a CAD VBA program file for automatic drawing. The EXCEL template file includes a low-voltage power distribution cabinet loop information table, a prefabricated low-voltage power distribution cabinet system diagram table, and a prefabricated low-voltage power distribution cabinet loop arrangement table. Among them, both the prefabricated low-voltage power distribution cabinet system diagram table and the prefabricated low-voltage power distribution cabinet loop arrangement table contain EXCEL VBA programs;

[0012] S2. Input the power load information of each loop in the prefabricated low-voltage power distribution cabinet loop information table, and use cell formulas to automatically perform load calculation and selection matching calculation, and automatically generate a valid low-voltage power distribution cabinet loop information table;

[0013] S3. Run the EXCEL VBA program in the prefabricated low-voltage power distribution cabinet loop arrangement table to automatically generate a valid low-voltage power distribution cabinet loop arrangement table;

[0014] S4. According to the needs of the design work, adjust the original input data or the results of the selection matching calculation in the valid low-voltage power distribution cabinet loop information table, and check whether the input data is correct or whether the results of the automatic selection matching calculation meet the design requirements;

[0015] S5. The prefabricated low-voltage power distribution cabinet system diagram table automatically references the information in the valid low-voltage power distribution cabinet loop arrangement table and the adjusted valid low-voltage power distribution cabinet loop information table using cell formulas, and automatically generates a valid low-voltage power distribution cabinet system diagram table;

[0016] S6. Run the EXCEL VBA program in the valid low-voltage power distribution cabinet system diagram table to automatically generate a low-voltage power distribution cabinet system diagram text file;

[0017] S7. Load the block file and the low-voltage power distribution cabinet system diagram text file through the CAD VBA program file, and the CAD VBA program file automatically draws the low-voltage power distribution cabinet system diagram.

[0018] Further, the block file includes a single-line diagram legend of electrical components and a table wire frame.

[0019] Further, the loop power load information includes: bus section number, specialty, equipment number, equipment name, rated power, load level, phase sequence, power factor, demand factor, cable length;

[0020] The load calculation data includes: calculated power, calculated current, switch model specifications, current transformer model specifications, cable model, cable specifications, cable current-carrying capacity, and voltage loss.

[0021] Furthermore, the method for calculating the selection and matching of components and cables includes: using the load calculation data and spreadsheet cell formulas, and querying in the component and cable parameter tables by the look-up table method.

[0022] Furthermore, the method for automatically generating a valid low-voltage power distribution cabinet loop arrangement table by running the EXCEL VBA program in the prefabricated low-voltage power distribution cabinet loop arrangement table includes:

[0023] The EXCEL VBA program reads the information of each loop in the prefabricated low-voltage power distribution cabinet loop arrangement table, and automatically adds two rows for each loop in the prefabricated low-voltage power distribution cabinet loop arrangement table by the way of inserting rows. One row is the main loop row, and the other row is the standby loop row;

[0024] After all insertions are completed, then according to the volume modulus, all loop rows are automatically grouped, and one group is the loops included in a low-voltage power distribution cabinet; at the same time, the low-voltage power distribution cabinet and the loops are automatically numbered.

[0025] Furthermore, the method for adjusting the original input data or the result of the selection and matching calculation in the valid low-voltage power distribution cabinet loop information table according to the needs of the design work, and checking whether the input data is correct or whether the result of the automatic selection and matching calculation meets the design requirements includes:

[0026] According to the needs of the design work, modify the original input data, and obtain the calculation result after the data is updated in real time; or modify the result of the selection and matching calculation; if the matching relationship exceeds the allowable range, the table will give a prompt through the preset cell conditional formatting.

[0027] Furthermore, the information of the valid low-voltage power distribution cabinet system diagram table includes: the component block name in the system single-line diagram, the system table wireframe block name, the insertion base point coordinates of each block, the table text content, and the coordinates of the table text.

[0028] Furthermore, the method for automatically generating a low-voltage power distribution cabinet system diagram text file by running the EXCEL VBA program in the valid low-voltage power distribution cabinet system diagram table includes:

[0029] The EXCEL VBA program in the valid low-voltage power distribution cabinet system diagram table reads the information required for drawing the low-voltage power distribution cabinet system diagram from the valid low-voltage power distribution cabinet system diagram table;

[0030] Write to a newly created text file in a specific order. Each line of text contains all the parameters required for inserting a drawing block or writing a table text, and the parameters are separated by commas.

[0031] A drawing system for a low-voltage power distribution cabinet system diagram, characterized in that it is a system for implementing any one of the described methods for drawing a low-voltage power distribution cabinet system diagram.

[0032] Compared with the prior art, the beneficial effects of the present application are:

[0033] The present invention automatically performs load calculation, automatic selection matching calculation, and automatically generates a text file of the low-voltage power distribution cabinet system diagram through an EXCEL template file, and automatically draws through a CAD VBA program. All calculations and drawing work are completed automatically, and the manual input and adjustment of information are all completed on the EXCEL operation interface. The input method is flexible, and information such as calculation results and data matching can be seen in real time, greatly reducing the manual operation workload in the design work, improving work efficiency and design quality, and having high practicability; the present invention transfers data through a text file, does not require an EXCEL VBA program to call the CAD software, nor does it require a CAD VBA program to call the EXCEL software; users of the present invention can also adjust the system diagram style according to the design habits of the unit or individual, so it has good compatibility and openness; the present invention effectively improves work efficiency and design quality, thereby effectively improving practicability, and at the same time has good compatibility. Description of the Drawings

[0034] In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings required for the embodiments will be briefly introduced below. It should be understood that the following drawings only show some embodiments of the present application, and therefore should not be regarded as limiting the scope. For those of ordinary skill in the art, other related drawings can be obtained based on these drawings without creative efforts.

[0035] Figure 1 is a schematic diagram of the method flow of the present application;

[0036] Figure 2 is a schematic diagram of the effective low-voltage power distribution cabinet loop information table of the present application;

[0037] Figure 3 is a schematic diagram of the effective low-voltage power distribution cabinet loop arrangement table of the present application;

[0038] Figure 4 is a schematic diagram of the effective low-voltage power distribution cabinet loop information table after adjusting the loop cable specification data in the present application;

[0039] Figure 5It is a schematic diagram of the effective low-voltage power distribution cabinet system diagram of this application;

[0040] Figure 6 It is a schematic diagram of the content of the low-voltage power distribution cabinet system diagram text file of this application;

[0041] Figure 7 It is a schematic diagram of the operation interface for automatically drawing the low-voltage power distribution cabinet system diagram by running the CAD VBA program of this application;

[0042] Figure 8 It is a schematic diagram of the low-voltage power distribution cabinet system diagram of this application. Specific embodiments

[0043] The following specific examples are used to illustrate the embodiments of the present invention. Those skilled in the art can easily understand other advantages and effects of the present invention from the content disclosed in this specification. The present invention can also be implemented or applied through other different specific embodiments, and various details in this specification can also be modified or changed based on different viewpoints and applications without departing from the spirit of the present invention. It should be noted that, without conflict, the following embodiments and the features in the embodiments can be combined with each other.

[0044] It should be noted that the diagrams provided in the following embodiments only illustrate the basic concept of the present invention in a schematic manner. Therefore, only the layers related to the present invention are shown in the diagrams, rather than being drawn according to the number, shape, and size of the layers in actual implementation. The type, quantity, and ratio of each layer in actual implementation can be arbitrarily changed, and the layer layout type may also be more complex.

[0045] In the following description, a large number of details are discussed to provide a more thorough explanation of the embodiments of the present invention. However, it is obvious to those skilled in the art that the embodiments of the present invention can be implemented without these specific details.

[0046] Please refer to Figures 1 to 8 , a method for drawing a low-voltage power distribution cabinet system diagram, including the following steps:

[0047] S1. Obtain an EXCEL template file, a block file that makes up the finished low-voltage power distribution cabinet system diagram, and a CAD VBA program file for automatic drawing. The EXCEL template file includes a low-voltage power distribution cabinet circuit information table, a prefabricated low-voltage power distribution cabinet system diagram table, and a prefabricated low-voltage power distribution cabinet circuit arrangement table. Among them, both the prefabricated low-voltage power distribution cabinet system diagram table and the prefabricated low-voltage power distribution cabinet circuit arrangement table contain EXCEL VBA programs;

[0048] S2. Input the power load information of each circuit in the prefabricated low-voltage power distribution cabinet circuit information table, and use the cell formula to automatically perform load calculation and selection matching calculation, and automatically generate a valid low-voltage power distribution cabinet circuit information table;

[0049] S3. Run the EXCEL VBA program in the prefabricated low-voltage power distribution cabinet circuit arrangement table to automatically generate a valid low-voltage power distribution cabinet circuit arrangement table;

[0050] S4. According to the needs of the design work, adjust the original input data or the results of the selection matching calculation in the valid low-voltage power distribution cabinet circuit information table, and check whether the input data is correct or whether the results of the automatic selection matching calculation meet the design requirements;

[0051] S5. The prefabricated low-voltage power distribution cabinet system diagram table automatically references the information in the valid low-voltage power distribution cabinet circuit arrangement table and the adjusted valid low-voltage power distribution cabinet circuit information table by using the cell formula, and automatically generates a valid low-voltage power distribution cabinet system diagram table;

[0052] S6. Run the EXCEL VBA program in the valid low-voltage power distribution cabinet system diagram table to automatically generate a low-voltage power distribution cabinet system diagram text file;

[0053] S7. Load the block file and the low-voltage power distribution cabinet system diagram text file through the CAD VBA program file, and the CAD VBA program file automatically draws the low-voltage power distribution cabinet system diagram.

[0054] The present invention automatically performs load calculation, automatic selection matching calculation, and automatically generates a low-voltage power distribution cabinet system diagram text file through an EXCEL template file, and automatically draws through a CAD VBA program. All calculation and drawing work are automatically completed. The manual input and adjustment work of information are all completed in the EXCEL operation interface. The input method is flexible, and information such as calculation results and data matching can be seen in real time, greatly reducing the manual operation workload in the design work, improving work efficiency and design quality, and having high practicability; the present invention transmits data through text files, does not require the EXCEL VBA program to call the CAD software, nor does it require the CAD VBA program to call the EXCEL software; users of the present invention can also adjust the system diagram style according to the design habits of the unit or individual, so it has good compatibility and openness; the present invention effectively improves work efficiency and design quality, thereby effectively improving practicability, and at the same time has good compatibility.

[0055] The block file includes single-line diagram legends of electrical components and table wireframes.

[0056] The circuit power load information includes: bus section number, specialty, equipment number, equipment name, rated power, load grade, phase sequence, power factor, demand factor, cable length;

[0057] The load calculation data includes: calculated power, calculated current, switch model specification, current transformer model specification, cable model, cable specification, cable current-carrying capacity, voltage loss.

[0058] The method for the selection and matching calculation of components and cables includes: using the load calculation data and spreadsheet cell formulas, and querying in the component and cable parameter table by the look-up table method.

[0059] The component and cable parameter table is prefabricated in the EXCEL template file. For the effective low-voltage power distribution cabinet loop information table, please refer to Figure 2 .

[0060] The method for automatically generating the effective low-voltage power distribution cabinet loop arrangement table by running the EXCEL VBA program in the prefabricated low-voltage power distribution cabinet loop arrangement table includes:

[0061] The EXCEL VBA program reads the information of each loop in the prefabricated low-voltage power distribution cabinet loop arrangement table, and automatically adds two rows for each loop in the prefabricated low-voltage power distribution cabinet loop arrangement table by the way of inserting rows. One row is the main loop row, and the other row is the standby loop row;

[0062] After all insertions are completed, then according to the volume modulus, all loop rows are automatically grouped, and one group is the loops included in one low-voltage power distribution cabinet; at the same time, the low-voltage power distribution cabinet and the loops are automatically numbered.

[0063] For the effective low-voltage power distribution cabinet loop arrangement table, please refer to Figure 3

[0064] The method for adjusting the original input data or the result of the selection and matching calculation in the effective low-voltage power distribution cabinet loop information table according to the needs of the design work, and checking whether the input data is correct or whether the result of the automatic selection and matching calculation meets the design requirements includes:

[0065] According to the needs of the design work, modify the original input data, and obtain the updated calculation result in real time; for example, if the power load of a loop is modified, the results of the load calculation and the selection and matching calculation are updated in real time; if the cell background color turns yellow after the data is modified, it means that the matching relationship is incorrect; or modify the result of the selection and matching calculation; if the matching relationship exceeds the allowable range, the table will give a prompt through the preset cell conditional format. As Figure 4 shown, for the first loop of the low-voltage power distribution cabinet loop information table, considering the design reserve, change the cable cross-section from 70mm 2 to 95mm2 , still meets the matching requirements of cable current-carrying capacity and the rated current of the protection switch. However, for the second circuit, the cable cross-section is changed from 70 mm 2 to 50 mm 2 . It can be seen that the cable current-carrying capacity in the table is less than the rated current of the protection switch, not meeting the matching requirements. The background color of the cable specification cell in the second circuit turns yellow, indicating that the input information is incorrect and needs to be corrected.

[0066] The information of the effective low-voltage power distribution cabinet system diagram table includes: the component block name in the system single-line diagram, the system table wireframe block name, the insertion base point coordinates of each block, the table text content, and the coordinates of the table text. The character height of the table text, the width-to-height ratio of the table text, the line spacing of the table text, the alignment method of the table text, and the font name of the table text are preset in the prefabricated low-voltage power distribution cabinet system diagram table and do not need to be input or modified. The effective low-voltage power distribution cabinet system diagram table is as Figure 5 shown.

[0067] The method of automatically generating a low-voltage power distribution cabinet system diagram text file by running the EXCEL VBA program in the effective low-voltage power distribution cabinet system diagram table includes:

[0068] Reading the information required to draw the low-voltage power distribution cabinet system diagram from the effective low-voltage power distribution cabinet system diagram table through the EXCEL VBA program in the effective low-voltage power distribution cabinet system diagram table;

[0069] Writing into a newly created text file in a specific order. Each line of text contains all the parameters required to insert a block or write a table text, and the parameters are separated by commas.

[0070] For example, the second line of text in the generated low-voltage power distribution cabinet system diagram text file is "1, \"Switchgear number\", -7950, -150, 4200, 350, 0.75, 2, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0". The first data "1" separated by commas indicates that this line is a call to the write text operation. The second data "\"Switchgear number\"" is the text content. The third and fourth data are the X and Y coordinates of the text writing point. The fifth data "4200" is the width of the text box. The sixth data "350" is the height of the text. The seventh data "0.75" is the width-to-height ratio of the text. The eighth data "2" is the alignment method code of the text. The ninth data "1" is the font code of the text... After the CAD VBA program reads the text information of this line, it can write the text with the specified content at the specified coordinates and in the specified format. The content of the automatically generated low-voltage power distribution cabinet system diagram text file is as Figure 6 shown.

[0071] A drawing system for a low-voltage power distribution cabinet system diagram, characterized in that it is a system for implementing any of the above-mentioned drawing methods for a low-voltage power distribution cabinet system diagram.

[0072] The program interface is as Figure 7 shown. Select the storage paths of the text file and the block file in the computer, and click the "Drawing" button to automatically draw the low-voltage power distribution cabinet system diagram. The drawn low-voltage power distribution cabinet system diagram is as Figure 8 shown.

[0073] In the above embodiments, although the present invention has been described in conjunction with specific embodiments of the present invention, many substitutions, modifications, and variations of these embodiments will be apparent to those of ordinary skill in the art based on the foregoing description. The embodiments of the present invention are intended to cover all such substitutions, modifications, and variations that fall within the broad scope of the appended claims.

[0074] The above embodiments are only illustrative of the principles and effects of the present invention and are not intended to limit the present invention. Any person familiar with this technology can modify or change the above embodiments without departing from the spirit and scope of the present invention. Therefore, all equivalent modifications or changes made by those of ordinary skill in the art in the technical field without departing from the spirit and technical ideas disclosed by the present invention should still be covered by the claims of the present invention.

Claims

1. A method for drawing a low-voltage distribution cabinet system diagram, characterized in that: The following steps are involved: S1. Obtain an EXCEL template file, a block file constituting a finished low-voltage distribution cabinet system diagram, and a CAD VBA program file for automatic drawing. The EXCEL template file includes a low-voltage distribution cabinet circuit information table, a prefabricated low-voltage distribution cabinet system diagram table, and a prefabricated low-voltage distribution cabinet circuit arrangement table. The prefabricated low-voltage distribution cabinet system diagram table and the prefabricated low-voltage distribution cabinet circuit arrangement table both contain an EXCEL VBA program. S2. Input the power load information of each circuit in the prefabricated low-voltage distribution cabinet circuit information table, use the cell formula to automatically perform load calculation and selection matching calculation, and automatically generate an effective low-voltage distribution cabinet circuit information table; S3, run the EXCEL VBA program in the prefabricated low-voltage distribution cabinet circuit arrangement table to automatically generate an effective low-voltage distribution cabinet circuit arrangement table; S4. According to the needs of the design work, adjust the original input data or the results of the selection and matching calculation in the effective low-voltage distribution cabinet circuit information table, and check whether the input data is correct or whether the results of the automatic selection and matching calculation meet the design requirements; S5. The prefabricated low-voltage distribution cabinet system diagram table uses cell formulas to automatically reference the information in the effective low-voltage distribution cabinet circuit arrangement table and the adjusted effective low-voltage distribution cabinet circuit information table to automatically generate an effective low-voltage distribution cabinet system diagram table; S6. Run the EXCEL VBA program in the effective low-voltage distribution cabinet system diagram table to automatically generate a text file of the low-voltage distribution cabinet system diagram; S7. Load the block file and the low-voltage power distribution cabinet system diagram text file through the CAD VBA program file, and the CAD VBA program file automatically draws the low-voltage power distribution cabinet system diagram.

2. The method for drawing a low-voltage distribution cabinet system diagram according to claim 1, characterized in that: The block file includes a single-line diagram legend and a table wireframe of the electrical components.

3. The method for drawing a low-voltage distribution cabinet system diagram according to claim 1, characterized in that: The circuit power load information includes: bus section number, specialty, equipment number, equipment name, rated power, load level, phase sequence, power factor, required coefficient, and cable length; Load calculation data includes: calculated power, calculated current, switch model and specifications, current transformer model and specifications, cable model, cable specifications, cable current carrying capacity, and voltage loss.

4. The method for drawing a low-voltage distribution cabinet system diagram according to claim 3, characterized in that: Methods for selecting and matching components and cables include: using load calculation data and spreadsheet cell formulas, using a table lookup method, and searching in component and cable parameter tables.

5. The method for drawing a low-voltage distribution cabinet system diagram according to claim 1, characterized in that: The method of running the EXCEL VBA program in the prefabricated low-voltage distribution cabinet circuit arrangement table to automatically generate an effective low-voltage distribution cabinet circuit arrangement table includes: The information of each circuit in the circuit arrangement table of the prefabricated low-voltage distribution cabinet will be read through the EXCEL VBA program, and two rows will be automatically added to each circuit in the circuit arrangement table of the prefabricated low-voltage distribution cabinet by inserting rows, one row is the main circuit row, and the other row is the standby circuit row; After all the insertions are completed, all the circuit rows are automatically grouped according to the volume modulus. One group is the circuit contained in a low-voltage distribution cabinet. At the same time, the low-voltage distribution cabinets and circuits are automatically numbered.

6. The method for drawing a low-voltage distribution cabinet system diagram according to claim 1, characterized in that: According to the needs of the design work, the original input data or the results of the selection and matching calculation in the effective low-voltage distribution cabinet circuit information table are adjusted, and the methods for checking whether the input data is correct or whether the results of the automatic selection and matching calculation meet the design requirements include: Modify the original input data according to the needs of the design work and obtain the calculation results after the data is updated in real time; or modify the results of the selection matching calculation; if the matching relationship exceeds the allowable range, the table will prompt through the preset cell conditional format.

7. The method for drawing a low-voltage distribution cabinet system diagram according to claim 1, characterized in that: The information of the effective low-voltage distribution cabinet system diagram table includes: the component block name in the system single-line diagram, the system table wireframe block name, the insertion base point coordinates of each block, the table text content, and the coordinates of the table text.

8. The method for drawing a low-voltage distribution cabinet system diagram according to claim 1, characterized in that: The method of running the EXCEL VBA program in the effective low-voltage distribution cabinet system diagram table to automatically generate a low-voltage distribution cabinet system diagram text file includes: The information required for drawing the low-voltage distribution cabinet system diagram is read from the effective low-voltage distribution cabinet system diagram table through the EXCEL VBA program in the effective low-voltage distribution cabinet system diagram table; Write a new text file in a specific order. Each line of text contains all the parameters required to insert a block or write a table of text. The parameters are separated by commas.

9. A system for drawing a low-voltage distribution cabinet system diagram, characterized in that: A system for implementing a method for drawing a low-voltage distribution cabinet system diagram as described in any one of claims 1-8.

Images