Method for generating electrical system diagram

Abstract

The invention discloses a method for generating an electrical system diagram. The method comprises the following steps: establishing a data table and a charting table based on an Excel program; arranging an electrical load information table according to the electrical equipment information, and filling in a load calculation table according to the electrical load information table; automatically calling, configuring and completing transformer parameters from the transformer parameter configuration table according to the transformer capacity and the compensation capacity through the composite nested function; establishing a feed cabinet table according to the number of the transformers, wherein the feed cabinet table comprises configuration of a reactive compensation cabinet, an active filter cabinet, a medium-voltage wire inlet cabinet and a contact cabinet; according to the equipment capacity and the installation power in the load calculation table, configuring outgoing line loop information through a composite nested function; and the CAD software automatically draws all transformer electrical system diagrams in the table by reading the drawing table. According to the method and the device, the problems of large calculation amount, non-uniform model selection, low efficiency and high error rate of a traditional CAD electrical system diagram in related technologies are solved.

Description

Technical Field

[0001] The present invention relates to the technical field of design drawings, and in particular to a method for generating an electrical system diagram. Background Art

[0002] In the field of industrial and civil electrical supply and distribution design, electrical system diagrams are drawings used to display electrical equipment, electrical lines and connection methods, providing important guidance for electrical engineering design. Accurate and clear electrical system diagrams help reduce errors and misunderstandings during construction and ensure the safe operation of electrical systems.

[0003] In the electrical system design process of traditional pure CAD software, engineers manually calculate and select electrical parameters, and then manually input the calculation results into the CAD software. After complex processing, they can draw the electrical distribution CAD system diagram.

[0004] However, in the design of complex industrial and civil electrical system diagrams, engineers need to spend a lot of time on electrical parameter calculations, drawing and data management, which is not only inefficient but also prone to errors.

[0005] The traditional pure CAD electrical system diagram drawing method has problems such as large amount of calculation, inconsistent selection, high time consumption, and easy errors and omissions.

[0006] Currently, no effective solution has been proposed for the above-mentioned problems existing in the related technologies. Summary of the invention

[0007] The main purpose of this application is to provide a method for generating an electrical system diagram, so as to at least solve the problems in the related art of traditional CAD electrical system diagrams, such as large amount of calculation, inconsistent selection, low efficiency and high error rate.

[0008] In order to achieve the above-mentioned purpose, according to one aspect of the present application, a method for generating an electrical system diagram is provided. The method includes: establishing a data table and a drawing table based on an Excel program, wherein the data table includes a power load information table, a load calculation table, a circuit breaker and cable configuration table, a transformer parameter configuration table and other parameter configuration tables, and the drawing table includes a transformer summary table and a feeder cabinet table; sorting the power load information table according to the power equipment information, and filling in the load calculation table according to the power load information table, wherein the power load information table includes the equipment name, power and voltage, and the load calculation table includes the load calculation result; automatically retrieving and configuring the transformer parameters from the transformer parameter configuration table according to the transformer capacity and compensation capacity through a composite nested function, wherein the transformer parameters are separately summarized in the transformer summary table, the transformer capacity and compensation capacity belong to the load calculation result, and the transformer parameters include the medium voltage incoming cable and the thermostat control cable, the transformer cabinet model, the rated voltage and transformation ratio, the short-circuit impedance, the cabinet size, the center point grounding cable, the low voltage copper plate specifications, the low voltage main incoming cabinet switch specifications and the switch setting value, and the transformer shell IP grade; establishing a feeder cabinet according to the number of transformers Table, the feeder cabinet table includes the configuration of reactive compensation cabinet, active filter cabinet, medium voltage incoming line cabinet, and contact cabinet, among which one transformer corresponds to one feeder cabinet table; according to the equipment capacity and installed power in the load calculation table, the outgoing line circuit information is configured through a composite nested function, among which one feeder cabinet corresponds to at least one circuit, and one circuit corresponds to a group of outgoing line circuit information. The outgoing line circuit information is in the feeder cabinet table, and the outgoing line circuit information includes circuit number, circuit purpose, phase sequence, transformer ratio, circuit breaker specifications and setting value, small room height, electrical fire monitoring, Whether it is a fire protection circuit, the number of cable cores, the feeder cable, the cabinet size, the circuit single-phase short-circuit calculation, the voltage drop calculation, the three-phase short-circuit current calculation and the switch instantaneous setting calculation; the feeder cabinet, reactive compensation cabinet and active filter cabinet are arranged in sequence according to the local power supply requirements or the layout of the substation, and the arrangement order is obtained through the drop-down menu numbers. Among them, the default arrangement order set by Excel through the function is low-voltage feeder cabinet → reactive compensation cabinet → active filter cabinet; CAD software automatically draws the electrical system diagram of all transformers in the table by reading the drawing table.

[0009] Optionally, after the transformer number to which the equipment belongs is named in the transformer master table, the transformer numbers in the transformer master table and the feeder cabinet table are automatically linked.

[0010] Optionally, the load calculation table automatically obtains the equipment name and installed power information in the electric load information table through a composite nested function; the load calculation table searches and fills in the required coefficient and power factor of the electrical equipment according to the electrical data manual; the load calculation table selects the transformer to which the equipment belongs through a drop-down menu, selects whether it is a fire load and the simultaneous coefficient, and obtains the transformer capacity and compensation capacity.

[0011] Optionally, the data table can be modified before drawing, and the corresponding data in the drawing table will be automatically modified synchronously.

[0012] Optionally, the parameters of the reactive compensation cabinet include the reactive compensation cabinet number, compensation capacity and compensation cabinet size; the parameters of the active filter cabinet include the active filter cabinet number, filter capacity and filter cabinet size; the parameters of the medium-voltage incoming cabinet include the selection of circuit breaker cabinet or load switch cabinet, medium-voltage incoming cabinet number, transformer ratio and medium-voltage incoming cabinet model; the parameters of the connecting cabinet include switch size and setting value, connecting busbar specifications and connecting cabinet size.

[0013] Optionally, after setting the amplification level of the circuit breaker, the cable specifications, short-circuit current, and voltage drop calculations are automatically calculated and matched simultaneously, where one circuit corresponds to one circuit breaker; when the circuit purpose is selected as backup, select the size of the backup switch. In addition to the default value, the backup switch size can also be manually selected through the drop-down menu.

[0014] Optionally, according to the type of load equipment, select the number of cable cores through the cable core number drop-down menu, and the cable specifications are automatically matched according to the number of cable cores, where the cable core numbers include 4+1, 3+2 and 3+1; select the busbar and cable of the feeder cable, and the feeder cable selects the amplification level according to the short-circuit current and voltage drop calculation. The feeder cable automatically matches the cable specifications according to the amplification level and automatically updates the short-circuit current and voltage drop calculation in conjunction.

[0015] Optionally, if the feeder cable load type is a fire load, the cable is automatically matched to a fire cable, and a sign indicating that the circuit is a fire load is marked in the drawing, and the circuit breaker is selected to be a non-tripping type for overload alarm.

[0016] Optionally, when arranging, after the positions of the medium voltage incoming line cabinet, transformer, and low voltage incoming line cabinet are fixed, the feeder cabinet, reactive power compensation cabinet, and active filter are sorted in the arrangement order, and the software draws in the arrangement order during the drawing process.

[0017] Optionally, attribute blocks of various components of the transformer and the feeder cabinet are written into CAD through a development program, the parameter configuration table data in Excel is assigned to the corresponding CAD attribute blocks, and the attribute blocks are arranged according to the arrangement order, wherein the CAD attribute blocks include medium-voltage incoming cabinet attribute blocks, transformer attribute blocks, low-voltage incoming cabinet attribute blocks, interconnection cabinet attribute blocks, reactive compensation cabinet attribute blocks, active filter cabinet attribute blocks and drawing frame attribute blocks.

[0018] Through this application, the following steps are adopted: based on the Excel program, a data table and a drawing table are established, wherein the data table includes a power load information table, a load calculation table, a circuit breaker and cable configuration table, a transformer parameter configuration table and other parameter configuration tables, and the drawing table includes a transformer general table and a feeder cabinet table; the power load information table is sorted according to the power equipment information, and the load calculation table is filled in according to the power load information table, wherein the power load information table includes the equipment name, power and voltage, and the load calculation table includes the load calculation result; through a composite nested function, the transformer parameter configuration table is selected according to the transformer capacity and the compensation The compensation capacity is automatically retrieved and configured to complete the transformer parameters. Among them, the transformer parameters are summarized in a separate table in the transformer master table. The transformer capacity and compensation capacity belong to the load calculation results. The transformer parameters include the medium-voltage incoming cable and the thermostat control cable, the transformer cabinet model, the rated voltage and transformation ratio, the short-circuit impedance, the cabinet size, the center point grounding cable, the low-voltage copper plate specifications, the low-voltage main incoming cabinet switch specifications and switch setting values, and the transformer shell IP level; according to the number of transformers, the feeder cabinet table is established. The feeder cabinet table includes the configuration of the reactive compensation cabinet, the active filter cabinet, the medium-voltage incoming cabinet, and the contact cabinet. Among them, one transformer corresponds to A feeder cabinet table; according to the equipment capacity and installed power in the load calculation table, the outgoing line circuit information is configured through a composite nested function, wherein one feeder cabinet corresponds to at least one circuit, and one circuit corresponds to a group of outgoing line circuit information. The outgoing line circuit information is in the feeder cabinet table, and the outgoing line circuit information includes circuit number, circuit purpose, phase sequence, transformer ratio, circuit breaker specifications and setting value, room height, electrical fire monitoring, whether it is a fire protection circuit, number of cable cores, feeder cable, cabinet size, circuit single-phase short-circuit calculation, voltage drop calculation, three-phase short-circuit current calculation and switch instantaneous setting calculation; for feeder cabinets, reactive compensation cabinets, active The filter cabinets are arranged according to the local power supply requirements or the arrangement of the substation, and the order of arrangement is obtained by arranging the numbers in the drop-down menu in order. Among them, the default order of arrangement set by Excel through the function is low-voltage feeder cabinet → reactive compensation cabinet → active filter cabinet; CAD software automatically draws the electrical system diagram of all transformers in the table by reading the drawing table, which solves the problems of large calculation amount, inconsistent selection, low efficiency and high error rate of traditional CAD electrical system diagrams in related technologies, thereby providing important technical support for electrical power supply and distribution design, greatly improving design efficiency, reducing errors and reducing costs. BRIEF DESCRIPTION OF THE DRAWINGS

[0019] In order to more clearly illustrate the specific implementation methods of the present invention or the technical solutions in the prior art, the drawings required for use in the specific implementation methods or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are some implementation methods of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.

[0020] Figure 1 is a flow chart of a method for generating an electrical system diagram according to an embodiment of the present application; Figure 2A It is a blank template for the first Excel electrical cabinet table; Figure 2B It is a blank template for the second Excel electrical cabinet table; Figure 3 It is an Excel template for electricity load information table; Figure 4 It is an Excel load calculation table; Figure 5 It is the Excel transformer summary table; Figure 6 It is the CAD interface of the C Sharp development software "AE Electrical" of the embodiment of the present invention; Fig. 7A is a schematic diagram of a system diagram of a first transformer T1 drawn in CAD according to an embodiment of the present invention; Figure 7B is a schematic diagram of a second transformer T1 system diagram drawn in CAD according to an embodiment of the present invention; Figure 8 yes Fig. 7A Enlarged image on the left; Fig. 9 yes Fig. 7A Enlarged image on the right; Fig. 10A yes Figure 7B The first enlarged view of Fig. 10B yes Figure 7B A second enlarged view of Fig. 10C yes Figure 7B The third enlarged view of . DETAILED DESCRIPTION

[0021] It should be noted that, in the absence of conflict, the embodiments and features in the embodiments of the present application can be combined with each other. The present application will be described in detail below with reference to the accompanying drawings and in combination with the embodiments.

[0022] In order to enable those skilled in the art to better understand the solution of the present application, the technical solution in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments are only part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field without creative work should fall within the scope of protection of the present application.

[0023] It should be noted that the terms "first", "second", etc. in the specification and claims of the present application and the above-mentioned drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequential order. It should be understood that the data used in this way can be interchanged where appropriate, so that the embodiments of the present application described here. In addition, the terms "including" and "having" and any of their variations are intended to cover non-exclusive inclusions, for example, a process, method, system, product or device comprising a series of steps or units is not necessarily limited to those steps or units clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or devices.

[0024] The technical solutions in the embodiments of the present invention will be described clearly and completely below in conjunction with the accompanying drawings in the embodiments of the present invention.

[0025] In this embodiment, a method for generating an electrical system diagram running on a mobile terminal, a computer terminal or a similar computing device is provided. It should be noted that the steps shown in the flowchart of the accompanying drawings can be executed in a computer system such as a set of computer executable instructions, and although a logical order is shown in the flowchart, in some cases, the steps shown or described can be executed in an order different from that shown here.

[0026] Figure 1 FIG. 1 is a flow chart of a method for generating an electrical system diagram according to an embodiment of the present application. Figure 1 As shown, the method comprises the following steps: Step S101, establishing a data table and a drawing table based on an Excel program, wherein the data table includes a power load information table, a load calculation table, a circuit breaker and cable configuration table, a transformer parameter configuration table and other parameter configuration tables, and the drawing table includes a transformer summary table and a feeder cabinet table; Specifically, all tables are stored in the Excel program. The present invention mainly arranges data tables, obtains drawing tables through the data tables, and then uses the drawing tables as CAD drawing information to draw the CAD electrical system diagram. Figure 2A as well as Figure 2B A blank template for a feeder panel table.

[0027] Step S102, sorting out the power load information table according to the power equipment information, and filling in the load calculation table according to the power load information table, wherein the power load information table includes the equipment name, power and voltage, and the load calculation table includes the load calculation result; Specifically, before drawing the electrical system diagram of the transformer, it is necessary to check the power load information corresponding to all devices. The power load can be obtained through the power load information table, and the appropriate transformer and feeder cabinet can be matched according to the power load, such as Figure 3 For the electricity load calculation table, such as Figure 4 A load calculation table is shown.

[0028] Step S103, automatically retrieving and configuring the transformer parameters from the transformer parameter configuration table according to the transformer capacity and compensation capacity through a composite nested function, wherein the transformer parameters are separately summarized in the transformer total table, the transformer capacity and compensation capacity belong to the load calculation results, and the transformer parameters include the medium voltage incoming cable and the thermostat control cable, the transformer cabinet model, the rated voltage and transformation ratio, the short-circuit impedance, the cabinet size, the center point grounding cable, the low voltage copper plate specifications, the low voltage main incoming cabinet switch specifications and the switch setting value, and the transformer housing IP grade; Specifically, Figure 5 As shown, according to the transformer load calculation results, fill in the "Transformer Number" and "Transformer Location" in the "Transformer General Table", and other parameter configurations are automatically generated. At the same time, create the corresponding transformer system diagram blank worksheet; In addition, a "left side" or "right side" drop-down selection menu is set for the transformer position. According to the floor plan, after selecting "left side" or "right side", the relative position of the transformer and the feeder cabinet can be automatically adjusted in conjunction.

[0029] Step S104, establishing a feeder cabinet table according to the number of transformers, the feeder cabinet table including the configuration of reactive power compensation cabinet, active filter cabinet, medium voltage incoming line cabinet, and contact cabinet, wherein one transformer corresponds to one feeder cabinet table; Specifically, in the transformer system diagram feeder table, select the transformer number through the drop-down menu, complete the configuration of the number and capacity of reactive compensation cabinets, as well as the parameters of active filter cabinets, medium voltage incoming cabinets, and contact cabinets; Step S105, according to the equipment capacity and installed power in the load calculation table, configure the outgoing line circuit information through a composite nested function, wherein one feeder cabinet corresponds to at least one circuit, one circuit corresponds to a group of outgoing line circuit information, and the outgoing line circuit information is in the feeder cabinet table, and the outgoing line circuit information includes circuit number, circuit purpose, phase sequence, transformer ratio, circuit breaker specifications and setting value, room height, electrical fire monitoring, whether it is a fire protection circuit, number of cable cores, feeder cable, cabinet size, circuit single-phase short-circuit calculation, voltage drop calculation, three-phase short-circuit current calculation and switch instantaneous setting calculation; Specifically, in the "loop usage" item of the feeder cabinet loop, the power equipment number of the corresponding transformer is extracted from the power load information table in step S102 through a composite nested function, and the feeder cabinet table will automatically generate all component parameter configurations of the loop. At the same time, according to the short-circuit current calculation result, the setting value of the circuit breaker is manually adjusted or the cable amplification level is selected through the drop-down menu to complete the short-circuit current and voltage drop verification.

[0030] In addition, the data source for loop information retrieval is the circuit breaker and cable configuration table, and the data source can be modified according to the actual project at the beginning of the project.

[0031] Step S106, arranging the feeder cabinet, reactive power compensation cabinet, and active filter cabinet according to the local power supply requirements or the substation, and arranging them in order through the numbers in the drop-down menu to obtain the arrangement order, wherein the default arrangement order set by the Excel function is low-voltage feeder cabinet→reactive power compensation cabinet→active filter cabinet; Specifically, fill in the serial number in the "Sort" column, and sort the low-voltage cabinet, reactive compensation cabinet, and active filter cabinet in order. So far, all the contents in Excel have been completed; Step S107, the CAD software automatically draws all transformer electrical system diagrams in the table by reading the drawing table; Specifically, according to the completed Excel table, open the CAD software and run the C sharp language development program, such as Figure 6 As shown, the electrical system diagram is automatically drawn. The final CAD system diagram is as follows Fig. 7A , Figure 8 as well as Fig. 9 shown.

[0032] The present invention provides an efficient and accurate method for automatically generating electrical system diagrams. The Excel function is combined with the VBA program to process complex calculations and selection in Excel, and then the electrical system diagram is generated with one click through the C sharp programming software. The automatic processing and drawing of electrical parameters are realized, which reduces human intervention and errors. Compared with the traditional pure CAD drawing method, the design efficiency and accuracy are significantly improved, and a large amount of human resources and time costs are saved.

[0033] In an optional embodiment, after the transformer number to which the equipment belongs is named in the transformer master table, the transformer numbers in the transformer master table and the feeder cabinet table are automatically linked.

[0034] Specifically, one transformer corresponds to one transformer number, and the transformer number exists in both the transformer master table and the feeder table. When the transformer parameters are modified, Excel will modify the transformer parameters in the transformer master table and the feeder cabinet table according to the transformer number, realizing automatic data linkage. This solves the technical problem of easy omission when modifying a data table and finding and modifying all relative data, achieving the technical effect of saving manpower and reducing error rate.

[0035] In an optional embodiment, the load calculation table automatically obtains the equipment name and installed power information in the electric load information table through a composite nested function; the load calculation table searches and fills in the required coefficient and power factor of the electrical equipment according to the electrical data manual; the load calculation table selects the transformer to which the equipment belongs through a drop-down menu, selects whether it is a fire load and the simultaneous coefficient, and obtains the transformer capacity and compensation capacity.

[0036] Specifically, the load calculation table automatically fills in the required information by looking up the electrical data manual, and calculates other information based on the required information to obtain the transformer capacity and compensation capacity. This step solves the technical problem of manual calculation of transformer load, which is time-consuming and labor-intensive, and achieves the technical effect of quickly obtaining the transformer capacity and compensation capacity. At the same time, the coefficient is obtained according to the electrical data manual.

[0037] In an optional embodiment, the data table is modified before drawing, and the corresponding data in the drawing table is automatically modified synchronously.

[0038] Specifically, the data source for automatically configuring parameter data is the transformer parameter configuration table. The table can modify the data synchronously, further achieving the technical effect of data linkage. There will be no omissions when modifying data, and other corresponding calculated data will also be automatically calculated, and a large amount of computing workload will not be increased due to modifying one data.

[0039] In an optional embodiment, the parameters of the reactive compensation cabinet include the reactive compensation cabinet number, compensation capacity and compensation cabinet size; the parameters of the active filter cabinet include the active filter cabinet number, filter capacity and filter cabinet size; the parameters of the medium-voltage incoming cabinet include the selection of the circuit breaker cabinet or the load switch cabinet, the medium-voltage incoming cabinet number, the transformer ratio and the medium-voltage incoming cabinet model; the parameters of the connecting cabinet include the switch size and setting value, the connecting busbar specifications and the connecting cabinet size.

[0040] In an optional embodiment, after setting the amplification level of the circuit breaker, the cable specifications, short-circuit current, and voltage drop calculations are automatically calculated and matched simultaneously, wherein one circuit corresponds to one circuit breaker; when the circuit is used for backup, the size of the backup switch is selected.

[0041] Specifically, when the amplification level of the circuit breaker is selected, the data related to the circuit breaker will be automatically calculated, which saves a lot of time and manpower for the staff. The circuit purpose can also be selected as "spare". Similarly, the size of the spare switch should also be selected. In fact, the size of the spare switch is the size of the circuit breaker.

[0042] In an optional embodiment, according to the type of load equipment, the number of cable cores is selected through the cable core number drop-down menu, and the cable specifications are automatically matched according to the number of cable cores, wherein the cable core numbers include 4+1, 3+2 and 3+1; the busbar and cable of the feeder cable are selected, and the feeder cable selects the amplification level according to the short-circuit current and voltage drop calculation, and the feeder cable automatically matches the cable specifications according to the amplification level and automatically updates the short-circuit current and voltage drop calculation in conjunction.

[0043] In an optional embodiment, if the feeder cable load type is a fire load, the cable is automatically matched as a fire cable, and a sign indicating that the circuit is a fire load is marked in the drawing, and the circuit breaker selects an overload alarm non-tripping type.

[0044] Specifically, when the fire load is selected, the feeder cable will be used for the fire circuit, Excel will automatically change the cable to the fire cable, and when drawing, the circuit corresponding to the fire load will be marked with the fire load symbol.

[0045] In an optional embodiment, when arranging, after the positions of the medium voltage incoming line cabinet, transformer, and low voltage incoming line cabinet are fixed, the feeder cabinet, reactive power compensation cabinet, and active filter are sorted in the arrangement order, and the software draws in the arrangement order during the drawing process.

[0046] Specifically, the drawing order can be customized, and you only need to fill in the serial number in the arrangement order of the table.

[0047] In an optional embodiment, attribute blocks of components of the transformer and the feeder cabinet are written into CAD through a development program, parameter configuration table data in Excel are assigned to corresponding CAD attribute blocks, and the attribute blocks are arranged according to the arrangement order, wherein the CAD attribute blocks include medium-voltage incoming cabinet attribute blocks, transformer attribute blocks, low-voltage incoming cabinet attribute blocks, interconnection cabinet attribute blocks, reactive compensation cabinet attribute blocks, active filter cabinet attribute blocks and drawing frame attribute blocks.

[0048] In addition, during the system diagram drawing process, the software will cut the system diagram in half from the middle, automatically match the frame size according to the length of the divided system diagram, automatically name the diagram according to the transformer programming, automatically fill in the project information, and automatically add 1 to the diagram number to generate the system diagram.

[0049] When drawing, you need to open the CAD interface of the development software "AE Electrical", such as Figure 6 Then click to draw the electrical system diagram. Figure 6 The low voltage cabinet in the system is the feeder cabinet. Fig. 7A as well as Figure 7B The completed electrical system diagram. Figure 8-Figure 9 for Fig. 7A An enlarged schematic diagram of Fig. 10A , Fig. 10B as well as Fig. 10C for Figure 7B An enlarged schematic diagram of .

[0050] The working principle and beneficial effects of the present invention are: The present invention discloses a method for generating an electrical system diagram. The invention includes: establishing a data table and a drawing table based on an Excel program, wherein the data table includes a power load information table, a load calculation table, a circuit breaker and cable configuration table, a transformer parameter configuration table and other parameter configuration tables, and the drawing table includes a transformer general table and a feeder cabinet table; arranging the power load information table according to the power equipment information, and filling in the load calculation table according to the power load information table, wherein the power load information table includes the equipment name, power and voltage, and the load calculation table includes the load calculation result; automatically retrieving and configuring the transformer parameters from the transformer parameter configuration table according to the transformer capacity and compensation capacity through a composite nested function, wherein the transformer parameters are separately summarized in the transformer general table, the transformer capacity and compensation capacity belong to the load calculation result, and the transformer parameters include the medium voltage incoming cable and the thermostat control cable, the transformer cabinet model, the rated voltage and transformation ratio, the short-circuit impedance, the cabinet size, the center point grounding cable, the low voltage copper plate specifications, the low voltage main incoming cabinet switch specifications and the switch setting value, and the transformer shell IP grade; establishing the feeder cabinet table according to the number of transformers, The feeder cabinet table includes the configuration of reactive compensation cabinet, active filter cabinet, medium voltage incoming cabinet, and contact cabinet, among which one transformer corresponds to one feeder cabinet table; according to the equipment capacity and installed power in the load calculation table, the outgoing line circuit information is configured through a composite nested function, among which one feeder cabinet corresponds to at least one circuit, and one circuit corresponds to a group of outgoing line circuit information. The outgoing line circuit information is in the feeder cabinet table. The outgoing line circuit information includes circuit number, circuit purpose, phase sequence, transformer ratio, circuit breaker specifications and setting value, room height, electrical fire monitoring, whether Fire protection circuit, number of cable cores, feeder cable, cabinet size, circuit single-phase short-circuit calculation, voltage drop calculation, three-phase short-circuit current calculation and switch instantaneous setting calculation; layout of feeder cabinet, reactive power compensation cabinet and active filter cabinet according to local power supply requirements or substation, and arrange them in sequence through the drop-down menu numbers to obtain the arrangement order, among which the default arrangement order set by Excel function is low-voltage feeder cabinet → reactive power compensation cabinet → active filter cabinet; CAD software automatically draws the electrical system diagram of all transformers in the table by reading the drawing table.

[0051] The traditional pure CAD electrical system diagram drawing method has the problems of large amount of calculation, inconsistent selection, time-consuming, easy to make mistakes, etc. The present invention realizes complex calculation and automatic selection in Excel, and then uses C sharp assembler software to generate low-voltage cabinet system diagram in CAD with one click.

[0052] This method is applicable to the field of civil and industrial electrical power supply and distribution design, and provides important technical support for electrical power supply and distribution design, which can greatly improve design efficiency, reduce errors and reduce costs.

[0053] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit it. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that they can still modify the technical solutions described in the aforementioned embodiments, or replace some or all of the technical features therein by equivalents. However, these modifications or replacements do not cause the essence of the corresponding technical solutions to deviate from the scope of the technical solutions of the embodiments of the present invention.

Claims

1. A method for generating an electrical system diagram, characterized in that: include: Establish data tables and drawing tables based on Excel program, wherein the data tables include power load information tables, load calculation tables, circuit breaker and cable configuration tables, transformer parameter configuration tables and other parameter configuration tables, and the drawing tables include transformer summary tables and feeder cabinet tables; Arrange the power load information table according to the power equipment information, and fill in the load calculation table according to the power load information table, wherein the power load information table includes the equipment name, power and voltage, and the load calculation table includes the load calculation result; The transformer parameters are automatically retrieved and configured from the transformer parameter configuration table according to the transformer capacity and compensation capacity through a composite nested function, wherein the transformer parameters are separately summarized in the transformer master table, the transformer capacity and compensation capacity belong to the load calculation result, and the transformer parameters include the medium voltage incoming cable and the thermostat control cable, the transformer cabinet model, the rated voltage and transformation ratio, the short-circuit impedance, the cabinet size, the center point grounding cable, the low voltage copper plate specifications, the low voltage main incoming cabinet switch specifications and switch setting values, and the transformer housing IP grade; The feeder cabinet table is established according to the number of the transformers, and the feeder cabinet table includes the configuration of the reactive power compensation cabinet, the active filter cabinet, the medium voltage incoming line cabinet, and the contact cabinet, wherein one transformer corresponds to one feeder cabinet table; According to the equipment capacity and installed power in the load calculation table, the outgoing line circuit information is configured through a composite nested function, wherein one feeder cabinet corresponds to at least one circuit, one circuit corresponds to a group of the outgoing line circuit information, and the outgoing line circuit information is in the feeder cabinet table, and the outgoing line circuit information includes circuit number, circuit purpose, phase sequence, transformer ratio, circuit breaker specifications and setting value, room height, electrical fire monitoring, whether it is a fire protection circuit, number of cable cores, feeder cable, cabinet size, circuit single-phase short-circuit calculation, voltage drop calculation, three-phase short-circuit current calculation and switch instantaneous setting calculation; The feeder cabinet, reactive power compensation cabinet, and active filter cabinet are arranged in sequence according to the local power supply requirements or the layout of the substation through the drop-down menu numbers to obtain the arrangement order, wherein the default arrangement order set by Excel through the function is low-voltage feeder cabinet → reactive power compensation cabinet → active filter cabinet; The CAD software automatically draws all the transformer electrical system diagrams in the table by reading the drawing table.

2. The method according to claim 1, characterized in that Create data tables and charts based on Excel, including: After the transformer number to which the equipment belongs is named in the transformer master list, the transformer numbers in the transformer master list and the feeder cabinet list are automatically linked.

3. The method according to claim 1, characterized in that Arrange the power load information table according to the power equipment information, and fill in the load calculation table according to the power load information table, including: The load calculation table automatically obtains the equipment name and installation power information in the electric load information table through a composite nested function; The load calculation table is based on the electrical data manual to find and fill in the required coefficient and power factor of the electrical equipment; In the load calculation table, select the transformer to which the equipment belongs through the drop-down menu, select whether it is a fire load and the simultaneous coefficient, and obtain the transformer capacity and compensation capacity.

4. The method according to claim 1, characterized in that Through composite nested functions, transformer parameters are automatically retrieved and configured from the transformer parameter configuration table according to the transformer capacity and compensation capacity, including: The data table is modified before drawing, and the corresponding data in the drawing table is automatically modified synchronously.

5. The method according to claim 1, characterized in that: The feeder cabinet table is established according to the number of transformers, and the feeder cabinet table includes the configuration of reactive power compensation cabinet, active filter cabinet, medium voltage incoming line cabinet, and contact cabinet, including: The parameters of the reactive power compensation cabinet include reactive power compensation cabinet number, compensation capacity and compensation cabinet size; The parameters of the active filter cabinet include the active filter cabinet number, filter capacity and filter cabinet size; The parameters of the medium voltage incoming line cabinet include the selection of the circuit breaker cabinet or load switch cabinet, the number of the medium voltage incoming line cabinet, the transformer ratio and the model of the medium voltage incoming line cabinet; The parameters of the interconnection cabinet include switch size and setting value, interconnection busbar specifications and interconnection cabinet dimensions.

6. The method according to claim 1, characterized in that According to the equipment capacity and installed power in the load calculation table, the outgoing line circuit information is configured through a composite nested function, including: After setting the amplification level of the circuit breaker, the cable specification, short-circuit current, and voltage drop calculation are automatically calculated and matched synchronously, wherein one circuit corresponds to one circuit breaker; When backup is selected for the circuit usage, the size of the backup switch is selected.

7. The method according to claim 1, characterized in that According to the equipment capacity and installed power in the load calculation table, the outgoing line circuit information is configured through a composite nested function, including: According to the load equipment type, select the number of cable cores through the cable core number drop-down menu, and the cable specifications are automatically matched according to the number of cable cores, wherein the number of cable cores includes 4+1, 3+2 and 3+1; The busbar and cable of the feeder cable are selected, and the feeder cable selects the amplification level according to the short-circuit current and voltage drop calculation. The feeder cable automatically matches the cable specification according to the amplification level and automatically updates the short-circuit current and voltage drop calculation in linkage.

8. The method according to claim 7, characterized in that According to the equipment capacity and installed power in the load calculation table, the outgoing line circuit information is configured through a composite nested function, including: If the feeder cable load type is a fire load, the cable is automatically matched as a fire cable, and the circuit is marked as a fire load in the drawing, and the circuit breaker is selected as an overload alarm non-tripping type.

9. The method according to claim 1, characterized in that: Arrange the feeder cabinet, reactive power compensation cabinet, and active filter cabinet according to the local power supply requirements or substation arrangement, and arrange them in order through the drop-down menu numbers to obtain the arrangement order, including: When arranging, after the positions of the medium voltage incoming line cabinet, transformer, and low voltage incoming line cabinet are fixed, the feeder cabinet, reactive power compensation cabinet, and active filter are sorted according to the arrangement order, and the software draws according to the arrangement order during the drawing process.

10. The method according to claim 1, characterized in that The CAD software automatically draws all transformer electrical system diagrams in the table by reading the drawing table, including: By developing a program, attribute blocks of various components of the transformer and the feeder cabinet are written into the CAD, the parameter configuration table data in Excel is assigned to the corresponding CAD attribute blocks, and the attribute blocks are arranged according to the arrangement order, wherein the CAD attribute blocks include medium-voltage incoming cabinet attribute blocks, transformer attribute blocks, low-voltage incoming cabinet attribute blocks, interconnection cabinet attribute blocks, reactive compensation cabinet attribute blocks, active filter cabinet attribute blocks and drawing frame attribute blocks.

Images