Method and system for automatically drawing bus based on EXCEL and CAD

Abstract

The invention belongs to the field of automatic bus drawing, and discloses an EXCEL and CAD-based automatic bus drawing method and system, and the method comprises the following steps: building a bus specification table and a measurement data table in an EXCEL table; establishing a database in an EXCEL table, wherein the database comprises coordinate point information of each position of a bus diagram framework, coordinate point information of each position of a bus diagram lap joint hole and coordinate point information of each position of a bus diagram switch cabinet; compiling a CAD drawing output command in an EXCEL table based on the database, and constructing an EXCEL automatic drawing bus template; the CAD drawing output command comprises a bus diagram framework, positions of lap joint holes of the bus diagram, sizes of the lap joint holes, hole distance marks, and names and sizes of switch cabinets of the bus diagram; pasting a CAD drawing output command in the EXCEL table into a CAD command bar, and automatically drawing a bus; a bus is modified or adjusted, a measurement data table is modified in EXCEL, a CAD drawing output command area is automatically updated, the whole graph does not need to be manually drawn again, and the drawing duration can be shortened by more than 50%.

Description

Technical Field

[0001] The present invention belongs to the technical field of automatic busbar drawing, and relates to a method and system for automatically drawing busbars based on EXCEL and CAD. Background Art

[0002] Whether in the backbone transmission network of ultra-high voltage, the urban distribution system of medium and low voltage, or the self-provided power facilities within various factories and enterprises, the busbar plays an indispensable role. In the power distribution devices at all voltage levels, it constantly converges the electric energy from different power sources and, according to the real-time power demand and load conditions, distributes the electric energy to each branch in an orderly manner to ensure that each electrical equipment can obtain stable and reliable power supply.

[0003] The busbar is a core component of the electrical main wiring diagram, connecting various electrical equipment such as generators, transformers, and switchgear to ensure the stable transmission of electric energy. The design and drawing of the busbar are directly related to the operation efficiency, reliability, and safety of the power system. In traditional electrical engineering design, the drawing of the busbar often relies on manual drawing, which requires engineers to draw the outline of the busbar point by point, consuming time and effort and being difficult to meet the fast-paced requirements of modern electrical engineering design. In addition, it is easily affected by human factors such as measurement errors and drawing skills, resulting in deviations between the drawn busbar and the actual design. Once the manually drawn busbar drawing is completed, it is difficult to modify and maintain, which is not conducive to subsequent design changes and project implementation. Summary of the Invention

[0004] Aiming at the deficiencies of the existing technology, the present invention aims to provide a method and system for automatically drawing busbars based on EXCEL and CAD, generating a batch of CAD drawing commands in EXCEL and importing the CAD drawing commands into CAD to automatically draw and generate busbar drawings.

[0005] To achieve the above object, the present invention adopts the following technical solutions: The present invention provides a method for automatically drawing busbars based on EXCEL and CAD, including the following steps: establishing a busbar specification table and a measurement data table in the EXCEL table; establishing a database in the EXCEL table, where the database includes the coordinate point information of each position of the busbar diagram frame, the coordinate point information of each position of the busbar diagram lap hole, and the coordinate point information of each position of the busbar diagram switchgear; compiling CAD drawing output commands in the EXCEL table based on the database to construct an EXCEL automatic drawing busbar template; the CAD drawing output commands include the busbar diagram frame, the positions of each lap hole of the busbar diagram, the size of the lap hole, the hole pitch marking, the names and sizes of each switchgear of the busbar diagram; pasting the CAD drawing output commands in the EXCEL table into the CAD command bar to automatically draw the busbar.

[0006] Furthermore, the automatic drawing includes automatically drawing a busbar diagram, automatically marking the dimensions of the busbar diagram, and automatically outputting the name and dimensions of the switchgear cabinet.

[0007] Furthermore, the length of the busbar is determined by accumulating the cabinet width, and the specification of the busbar is determined according to the system diagram.

[0008] Furthermore, the steps for compiling the coordinate point information of each position of the busbar diagram frame in the EXCEL table include: editing the coordinate point information; positioning the coordinate points for drawing the overall busbar graph.

[0009] Furthermore, the steps for compiling the coordinate point information of each position of the busbar diagram lap joint hole in the EXCEL table include: automatically judging the size, quantity, and position of the main busbar opening radius according to the lap joint width dimensions of different main busbars and branch busbars.

[0010] Furthermore, when the lap joint width of the branch busbar is greater than or equal to 120 mm, the opening radius of the main busbar is 10.5 mm; when the lap joint width of the branch busbar is less than or equal to 30 mm, the opening radius of the main busbar is 6.5 mm.

[0011] Furthermore, when the lap joint width of the branch busbar is greater than 30 and less than 120 mm, the opening radius of the main busbar is 8.5 mm.

[0012] Furthermore, when the lap joint width of the branch busbar is greater than or equal to 80 mm, the number of openings of the main busbar is 4; when the lap joint width of the branch busbar is less than 80 mm, the number of openings of the main busbar is 2.

[0013] Furthermore, each position of the switchgear cabinet in the busbar diagram is determined by the switchgear cabinet size coordinates.

[0014] The present invention also provides an automatic busbar drawing system based on EXCEL and CAD, including: a building module: used to build a busbar specification table and a measurement data table in the EXCEL table; a data module: used to build a database in the EXCEL table, and the database includes the coordinate point information of each position of the busbar diagram frame, the coordinate point information of each position of the busbar diagram lap joint hole, and the coordinate point information of each position of the switchgear cabinet in the busbar diagram; a compiling module: used to compile CAD drawing output commands in the EXCEL table based on the database to build an EXCEL automatic drawing busbar template; the CAD drawing output commands include the busbar diagram frame, the positions of each lap joint hole in the busbar diagram, the size of the lap joint hole, the hole pitch marking, the names and dimensions of each switchgear cabinet in the busbar diagram; a drawing module: used to paste the CAD drawing output commands in the EXCEL table into the CAD command bar for automatically drawing the busbar.

[0015] Compared with the prior art, the present invention has the following beneficial technical effects: The present invention relates to a method for automatically drawing busbars based on EXCEL and CAD. By combining EXCEL and CAD software, the drawing of busbar diagrams can be completed quickly and accurately, greatly reducing the time and workload of manual drawing. The drawing time can be shortened by more than 50%. The coordinate point information and drawing parameters in EXCEL can precisely control the shape and size of the busbar diagram, avoiding errors that may occur in manual drawing and improving the accuracy and quality of the design.

[0016] For the method of automatically drawing busbars based on EXCEL and CAD in the present invention, if it is necessary to modify or adjust the busbars, only the measurement data table needs to be modified in EXCEL, and the CAD drawing output command area will be automatically updated. Then, just run the automatic drawing instruction again without manually redrawing the entire graph, which improves the flexibility and maintainability of the design.

[0017] For the method of automatically drawing busbars based on EXCEL and CAD in the present invention, through the database established in EXCEL, it can handle busbars of different contracts and various specifications, realizing the automatic drawing of busbar diagrams. Technical personnel without professional busbar diagram design capabilities can also quickly generate busbar diagrams that meet the requirements through simple data input, promoting the popularization of knowledge and teamwork. Brief Description of the Drawings

[0018] Figure 1 It is a flowchart of the method for automatically drawing busbars based on EXCEL and CAD in the present invention; Figure 2 It is an example diagram of inputting measured busbar data into an EXCEL table in an embodiment of the present invention; Figure 3 It is an example diagram of editing the database in an embodiment of the present invention; Figure 4 It is an example diagram of the edited database in an embodiment of the present invention; Figure 5 It is an example diagram of the CAD output command for compiling the busbar diagram framework in EXCEL in an embodiment of the present invention; Figure 6 It is an example diagram of the CAD output command for marking the dimensions and spacings of the overlapping holes of the busbar diagram in EXCEL in an embodiment of the present invention; Figure 7 It is an example diagram of the CAD output command for compiling the dimensions of each part of the switchgear of the busbar diagram in EXCEL in an embodiment of the present invention; Figure 8 It is an example diagram of automatically drawing busbars based on EXCEL and CAD in an embodiment of the present invention. Detailed Embodiment

[0019] To enable those skilled in the art to better understand the solution of the present invention, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only a part of the embodiments of the present invention, rather than all of the embodiments. All other embodiments obtained by those of ordinary skill in the art based on the embodiments of the present invention without making creative efforts shall fall within the scope of protection of the present invention.

[0020] When drawing traditional busbars, first, according to the power system design drawings, the length, shape, and connection requirements of the required busbars are accurately measured to provide a basis for subsequent busbar processing. Then, a metal material with good electrical conductivity, such as copper or aluminum, is selected for straightening and marking the busbars to ensure that the busbars are straight and meet the design requirements.

[0021] Subsequently, the busbars are processed by punching, bending, etc. to form the required shape and size. During the processing, the firmness and reliability of the busbar connections need to be strictly controlled to ensure smooth current transmission. At the same time, the connection surfaces of the busbars are embossed to increase the contact area and improve the current transmission efficiency.

[0022] Finally, the busbars are surface-treated, such as painting or tin-plating, to improve their corrosion resistance and aesthetics. When installing the busbars, the phase sequence arrangement rules of the power system need to be followed to ensure the order and efficiency of power transmission. The entire drawing process needs to strictly comply with the safety operation procedures to ensure the safety of personnel and equipment.

[0023] Busbar bending: The busbars are bent into the required shape to adapt to the internal layout and space limitations of the switchgear. Through the bending process, it is ensured that the busbars are correctly installed inside the switchgear and meet the electrical performance requirements.

[0024] A method for automatically drawing busbars based on EXCEL and CAD in this application can quickly and accurately complete the drawing of busbar diagrams by combining EXCEL and CAD software. The coordinate point information and drawing parameters in EXCEL can precisely control the shape and size of the busbar diagrams, avoiding errors that may occur in manual drawing and improving the accuracy and quality of the design. If the busbar diagram needs to be modified or adjusted, only the measurement data table in EXCEL needs to be modified, and the CAD drawing output command area will be automatically updated, and then the automatic drawing instruction is run again. On the one hand, it reduces the additional costs such as rework and maintenance caused by design mistakes, avoids the unnecessary waste of manpower, material resources, and financial resources, and effectively controls the project budget; on the other hand, it lays a solid foundation for subsequent power system upgrades, maintenance, and repairs. Technicians can quickly locate problems and implement precise measures based on accurate drawings, improving the operation and maintenance efficiency and extending the service life of the power system.

[0025] Embodiment 1 The present invention provides a method for automatically drawing busbars based on EXCEL and CAD, as Figure 1 shown, which includes establishing a busbar specification table and a measurement data table in the EXCEL spreadsheet; establishing a database in the EXCEL spreadsheet, where the database includes the coordinate point information of each position of the busbar diagram frame, the coordinate point information of each position of the busbar diagram lap holes, and the coordinate point information of each position of the busbar diagram switchgear; compiling CAD drawing output commands in the EXCEL spreadsheet based on the database to construct an EXCEL automatic drawing busbar template; the CAD drawing output commands include the busbar diagram frame, the positions of each lap hole in the busbar diagram, the size of the lap holes, the hole pitch marking, the names and dimensions of each switchgear in the busbar diagram; pasting the CAD drawing output commands in the EXCEL spreadsheet into the CAD command bar to automatically draw the busbars.

[0026] Draw the busbar drawing data on-site and form it into tabular form to form a busbar specification table and a measurement data table. In the busbar design, it is necessary to determine the busbar specification and the busbar length. The busbar specification mainly depends on the system diagram to ensure that the busbar can withstand the maximum current in the system and leave enough safety margin to prevent safety hazards such as heating and even fire caused by overload. The busbar length is calculated by accumulating the widths of the switchgear to ensure that the busbar can correctly connect each device and meet the current transmission requirements, as Figure 2 shown. The shape of the busbar is rectangular, the specification of the busbar is the size of the cross-section of the busbar, that is, the width × height of the rectangle, and the length of the busbar is the length of the rectangle.

[0027] Establish a database in the EXCEL spreadsheet, where the database includes the coordinate point information of each position of the busbar diagram frame, the coordinate point information of each position of the busbar diagram lap holes, and the coordinate point information of each position of the busbar diagram switchgear.

[0028] Specifically: First, compile the coordinate point information of each position of the busbar diagram frame in the EXCEL spreadsheet. First, locate the coordinate points for drawing the overall busbar diagram, and determine the graphic size information of the busbar through the coordinate points. For example: Let =W3+E3:E27; =X4+B2, and control the output graphic size through the coordinate points.

[0029] After that, compile the coordinate point information of each position of the busbar diagram lap holes in the EXCEL spreadsheet, and automatically judge the size, quantity, and position of the opening radius of the main busbar according to the lap width dimensions of the main busbar and the branch busbar.

[0030] For example, in EXCEL, compile Let =IF(L3>=120,"10.5",IF(L3<=30,"6.5","8.5")); =IF(L3>=80,"4","2"), as Figure 3 and as Figure 4As shown in the figure. L3 is the row width of ABC branch corresponding to the cabinet number AA101, that is, the branch busbar lap width. If the branch busbar lap width is greater than or equal to 120mm, the main busbar hole opening radius is 10.5mm; if the branch busbar lap width is less than or equal to 30mm, the main busbar hole opening radius is 6.5mm; if the branch busbar lap width is greater than 30 and less than 120mm, the main busbar hole opening radius is 8.5mm. To sum up, the main busbar hole opening radius changes with the branch busbar lap width. The larger the branch busbar lap width, the larger the main busbar hole opening radius, so as to adapt to different electrical load and mechanical strength requirements.

[0031] Secondly, the number of main busbar holes is also determined by the branch busbar width. If the branch busbar width is greater than or equal to 80mm, the number of main busbar holes is 4, which can meet the transmission requirements of larger current and ensure the efficient operation of the power system. If the branch busbar width is less than 80mm, the number of main busbar holes is 2, which optimizes the structural layout of the busbar system while meeting the basic electrical connections.

[0032] Let = W3 + F3 - (L3 / 8 * (AC3 - 2)); = X3 + B2 / 2 - B2 / 4. Through this key variable of the branch busbar lap width, the spatial position coordinates of the holes are accurately calculated. It provides a solid data foundation for accurately drawing the busbar diagram in CAD drawing software, ensuring that the position of each lap hole is accurate and error-free, and avoiding electrical connection failures or mechanical installation problems caused by position deviations.

[0033] After that, compile the information of the position coordinates of each switch in the busbar diagram in the EXCEL table. For example, let = W3 + E3:E27; = E3 / 2 & "," & AM3 + 35. Based on the size coordinates of the switch cabinet, determine the position of the switch cabinet. Based on the size data such as the length, width, and height of the switch cabinet, convert it into intuitive coordinate points, so that the switch cabinet can be accurately positioned in the construction of the two-dimensional or three-dimensional busbar diagram, facilitating the visual design, analysis, and optimization of the entire busbar system, and ensuring the high efficiency, accuracy, and reliability of the entire process of the power system from design to installation.

[0034] Compile the CAD drawing output command in the EXCEL table based on the database to build an EXCEL automatic drawing busbar template; the CAD drawing output command includes the busbar diagram frame, the position of each lap hole in the busbar diagram, the size of the lap hole, the hole pitch marking, the name and size of each switch cabinet in the busbar diagram.

[0035] Specifically, compile the CAD output command in EXCEL. For example, let = "PL" & "" & W3 & "," & X3, as Figure 5 shown. Among them, PL is the command to draw a polyline in CAD.

[0036] Prepare CAD output commands for the positions of the lap holes in the busbar diagram in EXCEL. For example, let = "C" & " " & Z3 & "," & AA3 & " " & AB3. Through the database information, prepare the CAD output command columns for the busbar opening dimensions, positions, and quantities in the EXCEL table, as Figure 5 shown.

[0037] By referring to the data in the database, CAD commands for drawing each lap hole can be accurately generated. At the same time, based on the data in the database, the CAD output command columns for the busbar opening dimensions, positions, and quantities can be further prepared in the Excel table. For example, according to different specifications and design requirements of the busbar, different opening quantities and position information will be stored in the database, and Excel can generate corresponding commands based on this information to ensure the accurate drawing of each lap hole in the busbar diagram.

[0038] Prepare CAD output commands for the dimensions and spacing markings of the lap holes in the busbar diagram in EXCEL. For example, the formula for preparing the output command column in EXCEL is = "-text j mc " & AI3 & " " & 30 & " 0 " & AB3 * 2 & ""; = "-text j mc " & AJ3 & " " & 30 & " 0 " & AK3 & "", as Figure 6 shown and as Figure 7 shown. Through the database information, prepare the CAD output command columns for the busbar hole dimension markings and hole spacing dimension markings in the EXCEL table. Figure 6 This is an example diagram of the CAD output commands for the dimensions and spacing markings of the lap holes in the busbar diagram prepared in EXCEL. Figure 7 This is an example diagram of the CAD output commands for the dimensions of each part of the switchgear in the busbar diagram prepared in EXCEL.

[0039] Among them, -text is the command for adding text markings in CAD, j mc is the alignment method of the text as centered alignment, 30 is the text height, and AI3, AB3, AJ3, AK3 are the data in the database.

[0040] Prepare CAD output commands for the names and dimensions of each part of the busbar diagram and switchgear in the EXCEL table. The formula for preparing the output command is = "PL" & " " & AL3 & "," & AM3; = "-text j mc " & AN9 & " " & 50 & " 0 " & D3 & "". Through the database information, prepare the CAD output command columns for the switchgear name and width dimension markings in the EXCEL table.

[0041] Among them, AN9 is the position coordinate of the marked text, 50 is the text height, and D3 is the cabinet number name in the database.

[0042] Paste the CAD output commands for each column in the automatic drawing area of EXCEL into the CAD command bar to automatically draw the busbar diagram, automatically dimension the busbar diagram, and automatically output the switchgear name.

[0043] Specifically, CAD automatically draws the framework and lap holes of the busbar diagram according to the output commands in EXCEL, and at the same time automatically dimensions the busbar diagram, including lap hole dimensions, spacing, and the name and width dimensions of the switchgear, etc., reducing possible errors in the manual drawing process and greatly improving the efficiency and accuracy of busbar diagram drawing.

[0044] Open the CAD software and paste each output command bar into the CAD command bar in sequence, so that CAD automatically draws the busbar diagram according to the instructions in EXCEL and dimensions the information, as Figure 8 shown.

[0045] Through the combination of EXCEL and CAD software, the drawing of the busbar diagram can be completed quickly and accurately, greatly improving the drawing efficiency and quality. It not only saves time and workload, but also improves the precision and accuracy of the design.

[0046] In summary, through the combination of EXCEL and CAD software, the drawing of the busbar diagram can be completed quickly and accurately, greatly reducing the time and workload of manual drawing. The coordinate point information and drawing parameters in EXCEL can precisely control the shape and size of the busbar diagram, avoiding possible errors in manual drawing and improving the precision and quality of the design. If modifications or adjustments need to be made to the busbar diagram, simply modify the measurement data table in EXCEL, and the CAD drawing output command area will be automatically updated without having to redraw the entire graph manually. For new users, learning to use EXCEL and CAD software to draw busbar diagrams is relatively simple, reducing the learning cost and entry threshold. Compared with manual drawing, this application avoids the influence of human measurement errors and drawing skills. Through precise coordinate point information and parametric settings, the consistency between the busbar diagram and the actual design can be ensured, thereby improving accuracy.

[0047] EXCEL: An office software used for daily office work, business analysis, and data processing, presenting data in the form of spreadsheets. Cells are formed by the intersection of rows and columns, and various types of data, such as numbers, text, dates, etc., are entered into the cells. Then these data are processed, analyzed, and visually displayed to help users manage and utilize data more efficiently and provide strong support for decision-making.

[0048] CAD: 2D drawing and 3D modeling software. In terms of 2D drawing, it can accurately draw a variety of basic graphics, edit the graphics, perform dimensioning and positioning, and also has perfect layer management and printing output functions. In terms of 3D modeling, it can create basic entities and perform Boolean operations, create and edit surfaces in various ways, add material textures, perform rendering settings and make simple animations, and is widely used in many engineering design fields such as architecture, machinery, and electronics.

[0049] Embodiment 2 A busbar system automatically drawn based on EXCEL and CAD provided by the present invention includes a building module, a data module, a compiling module, and a drawing module.

[0050] Building module: used to establish a busbar specification table and a measurement data table in the EXCEL spreadsheet; Data module: used to establish a database in the EXCEL spreadsheet, and the database includes the coordinate point information of each position of the busbar diagram frame, the coordinate point information of each position of the busbar diagram lap hole, and the coordinate point information of each position of the busbar diagram switchgear cabinet; Compiling module: used to compile CAD drawing output commands in the EXCEL spreadsheet based on the database to construct an EXCEL automatic drawing busbar template; the CAD drawing output commands include the busbar diagram frame, the positions of each lap hole of the busbar diagram, the size of the lap hole, the hole pitch marking, the names and dimensions of each switchgear cabinet of the busbar diagram; Drawing module: used to paste the CAD drawing output commands in the EXCEL spreadsheet into the CAD command bar for automatic drawing of the busbar.

[0051] In summary, all the data required for drawing the busbar diagram, such as coordinates, lengths, angles, etc., are entered in EXCEL. These data constitute the database for drawing the busbar diagram; using the data processing ability of EXCEL, the data is integrated and edited to generate output commands that can be recognized by CAD. The output commands can be directly used for the drawing operation of CAD, thereby reducing the workload of manual input. The generated output commands are copied and pasted into the CAD software in batches. The CAD software will automatically draw the busbar diagram according to the output commands without manual intervention, thus improving the drawing efficiency and accuracy. The entire process not only simplifies the drawing process of the busbar diagram but also reduces the risk of human errors. Due to the seamless connection between the EXCEL spreadsheet and the CAD software, the transfer and processing of data are more efficient and accurate.

[0052] The busbar system automatically drawn based on EXCEL and CAD provided by the present invention can implement the method steps consistent with the above method, so it will not be elaborated here.

[0053] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention and are not intended to limit it. Although the present invention has been described in detail with reference to the above embodiments, those of ordinary skill in the art should understand that: modifications or equivalent substitutions can still be made to the specific embodiments of the present invention, and any modifications or equivalent substitutions that do not depart from the spirit and scope of the present invention should be covered by the protection scope of the claims of the present invention.

Claims

1. A method for automatically drawing busbars based on EXCEL and CAD, characterized in that: The following steps are involved: Create busbar specification tables and measurement data tables in EXCEL tables; Establish a database in an EXCEL table, wherein the database includes coordinate point information of each position of the busbar diagram frame, coordinate point information of each position of the busbar diagram overlap hole, and coordinate point information of each position of the busbar diagram switch cabinet; Based on the database, a CAD drawing output command is compiled in an EXCEL table to construct an EXCEL automatic drawing busbar template; the CAD drawing output command includes the busbar drawing frame, the location of each lap hole in the busbar drawing, the size of the lap hole, the hole spacing mark, and the name and size of each switch cabinet in the busbar drawing; Paste the CAD drawing output command in the EXCEL table into the CAD command bar to automatically draw the busbar.

2. The method for automatically drawing busbars based on EXCEL and CAD according to claim 1, characterized in that: The automatic drawing includes automatically drawing the busbar diagram, automatically marking the busbar diagram dimensions, and automatically outputting the switch cabinet name and dimensions.

3. The method for automatically drawing busbars based on EXCEL and CAD according to claim 1, characterized in that: The length of the busbar is determined by accumulating the cabinet width, and the specifications of the busbar are determined according to the system diagram.

4. The method for automatically drawing busbars based on EXCEL and CAD according to claim 3 is characterized in that: The step of compiling the coordinate information of each position of the busbar diagram framework in an EXCEL table includes the following steps: Edit coordinate point information; Locate the coordinate points for drawing the overall graphics of the busbar.

5. The method for automatically drawing busbars based on EXCEL and CAD according to claim 4 is characterized in that: The following steps are included to compile the coordinate point information of each position of the busbar overlap hole in the EXCEL table: According to the overlap width of the main busbar and branch busbar, the radius, quantity and position of the main busbar opening are automatically determined.

6. The method for automatically drawing busbars based on EXCEL and CAD according to claim 5, characterized in that: The overlap width of the branch busbar is greater than or equal to 120mm, and the opening radius of the main busbar is 10.5mm; The overlap width of the branch busbar is less than or equal to 30 mm, and the opening radius of the main busbar is 6.5 mm.

7. The method for automatically drawing busbars based on EXCEL and CAD according to claim 6, characterized in that: The overlap width of the branch busbar is greater than 30 and less than 120 mm, and the opening radius of the main busbar is 8.5 mm.

8. The method for automatically drawing busbars based on EXCEL and CAD according to claim 5, characterized in that: The overlap width of the branch busbar is greater than or equal to 80 mm, and the number of main busbar openings is 4; The overlap width of the branch busbar is less than 80 mm, and the number of openings of the main busbar is 2.

9. The method for automatically drawing busbars based on EXCEL and CAD according to claim 1, characterized in that: Each position of the switch cabinet in the busbar diagram is determined by the switch cabinet size coordinates.

10. A busbar automatic drawing system based on EXCEL and CAD, comprising: Establishment module: used to establish busbar specification table and measurement data table in EXCEL table; Data module: used to establish a database in an EXCEL table, the database includes the coordinate point information of each position of the busbar diagram frame, the coordinate point information of each position of the busbar diagram overlap hole, and the coordinate point information of each position of the busbar diagram switch cabinet; Compilation module: used to compile CAD drawing output commands in an EXCEL table based on a database, and to construct an EXCEL automatic drawing busbar template; the CAD drawing output commands include the busbar drawing framework, the positions of each lap hole in the busbar drawing, the size of the lap hole, the hole spacing marking, and the name and size of each switch cabinet in the busbar drawing; Drawing module: used to paste the CAD drawing output commands in the EXCEL table into the CAD command bar to automatically draw the busbar.

Images