A parameterized design method of distribution transformer

Abstract

The application relates to the technical field of parameterized design of distribution transformers, and discloses a parameterized design method of a distribution transformer, which comprises the following steps: S1, constructing a multi-database collaborative data architecture; S2, establishing a parameterized design engine for communication between a three-dimensional CAD system and a plurality of work sheets; S3, starting the parameterized design engine, importing and reading an electromagnetic calculation sheet; S4, based on calculation result data and each logical work sheet, filling a plurality of parameter groups in an information output work sheet; S5, in the parameterized design engine, reading parameterized work sheets of each core component, obtaining parameter driving information, combining the parameter driving information and the information output work sheet, and performing parameterized driving of the three-dimensional CAD system on each core component; and S6, classifying and sorting product files generated by driving into three corresponding product folders. The application can automatically realize a complete link from electromagnetic calculation to three-dimensional model generation and engineering drawing output of the distribution transformer.

Description

Technical Field

[0001] This invention relates to the field of computer-aided design technology for distribution transformers, and more specifically to a parametric design method for distribution substation transformers. Background Technology

[0002] Distribution transformers are key power equipment that convert 10kV or 20kV medium-voltage electrical energy into 0.4kV low-voltage electrical energy. They are widely used in urban power distribution networks, industrial power supply systems, and new energy grid connection. The design of a distribution transformer involves multiple professional aspects, including electromagnetic calculations, core structure design, coil winding scheme, tank shell design, insulation coordination, and temperature rise verification. There are hundreds of design parameters, and complex nonlinear coupling relationships exist between these parameters.

[0003] Currently, the design of distribution transformers in the industry mainly adopts the following approach: First, designers input product specifications (e.g., capacity kVA, voltage level (e.g., volt-volts, kilovolt-kV), connection group designation (e.g., Yyn0, Yd11)) into dedicated electromagnetic calculation software (e.g., calculation spreadsheets created in Excel), and calculate core parameters such as core cross-section, number of coil turns, conductor specifications, and tank dimensions by manual adjustment or empirical formulas; then, based on the calculation results, they manually create 3D models of components such as the core, coils, and tank in a 3D CAD system (e.g., SolidWorks); finally, they manually draw engineering drawings and fill in the bill of materials and dimension markings.

[0004] The above traditional design process has the following main problems: (1) Long design cycle: Taking a conventional S22-M-630 / 10 type distribution transformer as an example, it usually takes 3 to 5 working days from receiving the design task to outputting a complete set of drawings. Among them, electromagnetic calculation and core parameter adjustment account for about 30% of the total time, three-dimensional modeling accounts for about 50% of the total time, and engineering drawing drawing and annotation account for about 20% of the total time. When faced with large-volume, multi-specification order demands, the design capacity bottleneck is particularly prominent; (2) There are many data transmission links and a high error rate: Each parameter in the electromagnetic calculation results (e.g., the center distance of the core column Mo, the window height Hw, the inner and outer diameter of the coil, the length, width and height of the oil tank, etc.) needs to be manually transcribed into the dimension parameters of the three-dimensional model. A transformer involves more than 100 parameters that need to be transmitted. Each parameter is at risk of inputting errors, omissions, and unit conversion errors during the transcription process; According to statistics, the design rework rate caused by parameter transmission errors under the traditional design method is about 8% to 12%; (3) Design standardization is difficult to guarantee: Different designers may use different iron chip level schemes, different clamping gap values, and different bushing selection configurations for transformers of the same specifications, resulting in product parts Poor versatility; for example, for the same 400kVA capacity iron core clamp, the positioning dimensions designed by different designers can vary by 5 to 10 mm, which seriously affects the standardization of production and manufacturing and the efficiency of material preparation; (4) Limited optimization capability: The optimization design of distribution transformers needs to weigh multiple dimensions such as material cost (including the amount of silicon steel sheets and copper wires), operating loss (including no-load loss and load loss), and manufacturing process complexity; under the traditional method, designers can usually only try 2 to 3 scheme combinations and cannot systematically search for the optimal solution in the global parameter space; (5) Difficulty in responding to design changes: When the customer demand, voltage level or connection method changes, designers need to start from electromagnetic calculation and go through the whole process again. The change cost is high and the cycle is long, making it difficult to adapt to the market's demand for rapid response.

[0005] To address the aforementioned issues, some improvements have been attempted within the industry. For example, some companies have utilized Excel's formula calculation function to create parameterized electromagnetic calculation tables, achieving semi-automation of the electromagnetic calculation process. Other research has proposed using the parameterization functions of 3D CAD systems (e.g., SolidWorks' equation and global variable functions) to create parameterized transformer component templates. However, these methods only address partial aspects of the design process and fail to automate the entire chain from electromagnetic calculation → core parameter configuration → 3D modeling → engineering drawing output. In particular, calculation steps in transformer design that require design rules, such as calculating the number of ferrite laminations, deriving clamp positioning dimensions, and matching the number of corrugated sheets with the tank size, lack configurable data management tools. This results in the need to modify program code with each product upgrade or standard change, leading to high maintenance costs and poor flexibility. Summary of the Invention

[0006] To address the aforementioned technical problems, the present invention aims to provide a parametric design method for distribution transformers, which solves the problems of long design cycles, error-prone data transmission, low standardization, and slow change response in existing distribution transformer designs, and automates the entire process of distribution transformer design from electromagnetic calculations to 3D model generation and engineering drawing output.

[0007] To address the aforementioned technical problems, the present invention proposes the following technical solution: This application relates to a parametric design method for distribution transformers, comprising the following steps: S1: Construct a multi-database collaborative data architecture; The multi-database collaborative data architecture uses multiple worksheets as carriers to store design parameters related to the core components of the distribution transformer in the parametric design as needed in each worksheet. Cross-table references are established between worksheets through the parameter names of the design parameters. The core components include the iron core, oil tank, and coil. S2: A parametric design engine that enables communication between a 3D CAD system and multiple worksheets; S3: Start the parametric design engine, import and read the electromagnetic calculation sheet; S4: Based on the calculation results data from the read electromagnetic calculation sheet and each logical worksheet, fill in multiple parameter groups in the information output worksheet; The worksheets include an information output worksheet and logical worksheets for each core component. The information output worksheet stores all design parameters in a wide table format, grouped by column. Multiple columns form a parameter group, and the parameter name and its corresponding parameter value are stored by column. The logical worksheets define the parameter calculation rules between the parameters of the corresponding core components. S5: In the parametric design engine, read the parametric worksheets of each core component, obtain the parameter driving information of a 3D CAD system file in the corresponding product tree for each row of the parametric worksheet, and combine the parameter driving information and the information output worksheet to execute the parametric driving of the 3D CAD system for each core component. S6: Categorize the finished product files generated by the driver into three corresponding finished product folders: core assembly folder, oil tank assembly folder, and coil assembly folder; Each assembly folder is used to store the corresponding core component assembly, its related parts, and engineering drawings.

[0008] In some embodiments of this application, S4 specifically includes: S41: Read the electromagnetic calculation sheet, obtain the parameter names and parameter values, and convert them into a key-value pair dictionary through key-value matching; S42: Initialize the parameter group in the information output worksheet; S43: Extract the parameter name and parameter value item by item from the key-value pair dictionary and fill them into the corresponding parameter group in the information output worksheet; S44: For parameters not covered in the electromagnetic calculation sheet, read fixed values ​​from the constant attribute area of ​​each logic worksheet and fill them into the corresponding parameter group. Also, traverse each logic worksheet, perform the design logic calculation item by item for each parameter calculation rule, calculate the corresponding parameter value, and fill it into the corresponding parameter group. S45: Save the output worksheet containing the information.

[0009] In some embodiments of this application, the specific process of initializing the parameter group in the S42 initialization information output worksheet includes: Create an array containing multiple DataTable references, the number of which is the same as the number of parameter groups in the output worksheet; For each DataTable, clear all existing data rows and pre-populate them with empty data rows.

[0010] In some embodiments of this application, the parametric driving of the 3D CAD system for the core components in S5 specifically involves: Read the row and column contents of the parameterized worksheet of the core component into the DataTable data structure dt; Iterate through dt line by line, and perform the following operation on each line: Extract file information from the current line. The file information includes file type, current file drawing number, and current file name. The file type includes part type, assembly type, and engineering drawing type. Build the physical path of the file; Open the corresponding file based on its physical path; Based on the type of file opened, the corresponding parametric drive is executed. Specifically: when the file type is a part, a parametric drive dataset is generated, including relevant information identifying the part file and dimensional values ​​that drive changes in the part. This dataset is used to drive the part file to perform parametric drive and generate a 3D model. When the file type is an assembly, a parametric drive dataset is generated, including relevant information identifying the assembly file and assembly-level parameters. This dataset is used to drive the assembly file to perform parametric drive and generate a 3D model. When the file type is a drawing, a parametric drive dataset is generated, including relevant information identifying the drawing file and drawing details. This dataset is used to drive the drawing file to perform parametric drive and output drawing details. After the corresponding parameterized driver is completed, save and close the corresponding file.

[0011] In some embodiments of this application, when the file type is a part type, the corresponding parameterized driver is executed, specifically as follows: Obtain the dimensional values ​​that drive the changes in the parts and write the dimensional values ​​into the 3D CAD system.

[0012] Extract the custom attributes of the part corresponding to the part file from the information output worksheet, and write the custom attributes into the model. If the material code of the part is specified in the information output worksheet, then switch the material of the part.

[0013] In some embodiments of this application, when the file type is an assembly type, the corresponding parameterized driver is executed, specifically as follows: Write the assembly-level parameters related to the overall dimensions of the assembly corresponding to the assembly file from the information output worksheet into the global variable table of the assembly file. The assembly is then rebuilt.

[0014] In some embodiments of this application, when the file type is an engineering drawing, the corresponding parameterized driver is executed, specifically as follows: Access design tables in engineering drawings via 3D CAD system API; Format the parameter groups related to the engineering drawing file in the information output worksheet into a DataTable data structure to obtain the engineering drawing details to be written into the engineering drawing; Write the row and column contents of the DataTable into the corresponding cells of the designed table one by one; Clean up invalid data in the engineering drawings.

[0015] In some embodiments of this application, the parametric design method for the distribution transformer further includes the following steps: The electromagnetic calculation sheet can be quickly imported and read by configuring the "Import Electromagnetic Calculation Sheet" button on the main interface of the parametric design engine. The parameterization process of iron cores can be quickly executed by configuring the batch parameterization button of the iron core on the main interface of the parameterized design engine. The parameterization process of fuel tanks can be quickly executed by configuring the batch parameterization button for fuel tanks on the main interface of the parameterized design engine. The parameterization process of coils can be quickly executed by configuring the batch parameterization button on the main interface of the parametric design engine.

[0016] In some embodiments of this application, the parametric design method for the distribution transformer further includes the following steps: The core assembly folder can be quickly opened by configuring a core finished product button on the main interface of the parametric design engine. The fuel tank assembly folder can be quickly opened by configuring a "Fuel Tank Finished Product" button on the main interface of the parametric design engine. The coil assembly folder can be quickly opened by configuring a coil finished product button on the main interface of the parametric design engine; In some embodiments of this application, multiple worksheets are stored in a project data table file in Excel format; After executing the parametric drive of the 3D CAD system in S5, a complete snapshot of the design parameters is stored in the project data table file; The parametric design method for the distribution transformer also includes the following steps: The project data table file can be quickly opened by configuring a button to open the project data table file on the main interface of the parametric design engine.

[0017] Compared with existing technologies, the parametric design method for distribution transformers proposed in this application has the following advantages and beneficial effects: (1) It realizes the full-process automation of electromagnetic calculation, three-dimensional model generation and drawing output, which significantly shortens the design cycle and improves design efficiency; (2) The entire process from electromagnetic calculation to 3D model generation and drawing output does not require manual transcription, eliminating the risk of data entry errors and omissions; (3) The design logic of the core components of the transformer is stored in the form of a worksheet. When the design standards or process specifications change, there is no need to modify the program source code. Only the logic worksheet needs to be adjusted to adapt, which greatly reduces maintenance costs. (4) The worksheet storing parameter data adopts a wide table format, which can flexibly expand the number of parameter groups and fields according to product categories, and has fast change response and strong scalability.

[0018] Other features and advantages of the present invention will become clearer after reading the detailed embodiments of the invention in conjunction with the accompanying drawings. Attached Figure Description

[0019] To more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the drawings used in the description of the embodiments of the present invention or the prior art will be briefly introduced below. Obviously, the drawings described below are some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0020] Figure 1 This is a flowchart of the parametric design method for distribution transformers proposed in this invention; Figure 2This is a schematic diagram of the column grouping structure of the information output worksheet involved in the parametric design method for distribution transformers proposed in this invention; Figure 3 for Figure 2 A schematic diagram of the internal structure of the first parameter group; Figure 4 This is a flowchart of multiple parameter groups in the information output worksheet of the parametric design method for distribution transformers proposed in this invention; Figure 5 This is a schematic diagram of the design logic calculation process in the parametric design method for distribution transformers proposed in this invention. Detailed Implementation

[0021] The technical solutions of the present invention will be clearly and completely described below with reference to the accompanying drawings of the embodiments of the present invention. Obviously, the described embodiments are only some embodiments of the present invention, and not all embodiments.

[0022] Based on the embodiments of this invention, all other embodiments obtained by those skilled in the art without inventive effort are within the scope of protection of this invention. In the description of this invention, it should be understood that the terms "center," "upper," "lower," "front," "rear," "left," "right," "vertical," "horizontal," "top," "bottom," "inner," and "outer," etc., indicating orientations or positional relationships, are based on the orientations or positional relationships shown in the accompanying drawings and are only for the convenience of describing this invention and simplifying the description, and are not intended to indicate or imply that the device or element referred to must have a specific orientation, or be constructed and operated in a specific orientation, and therefore should not be construed as a limitation of this invention.

[0023] In the description of this invention, it should be noted that, unless otherwise explicitly specified and limited, the terms "installation," "connection," and "joining" should be interpreted broadly. For example, they can refer to a fixed connection, a detachable connection, or an integral connection. Those skilled in the art can understand the specific meaning of the above terms in this invention based on the specific circumstances. In the description of the above embodiments, specific features, structures, materials, or characteristics can be combined in any suitable manner in one or more embodiments or examples.

[0024] The terms "first" and "second" are used for descriptive purposes only and should not be construed as indicating or implying relative importance or implicitly specifying the number of technical features indicated. Thus, a feature defined as "first" or "second" may explicitly or implicitly include one or more of that feature. In the description of this invention, unless otherwise stated, "a plurality of" means two or more.

[0025] To automate the entire process of distribution transformer calculations, from electromagnetic calculations to 3D model generation and engineering drawing output, see [link to relevant documentation]. Figure 1 This application relates to a parametric design method for distribution transformers (which will be described in detail below), which can solve the problems of long design cycle, error-prone data transmission, low standardization, difficulty in scheme optimization, and slow response to changes in the existing parametric design of distribution transformers.

[0026] In some embodiments of this application, the operating environment of the parametric design method for the distribution transformer is first described.

[0027] The parametric design method for this distribution transformer operates on a Windows operating system, using C# as the development language and a WinForms desktop application built on the .NET Framework 4.7.2 platform. It utilizes the Microsoft.Office.Interop.Excel component and the EPPlus library to implement Excel file read / write operations, and establishes a COM communication link between the .NET language and the 3D CAD system through a COM communication component library, enabling programmatic direct control and access to various functions within the 3D CAD system.

[0028] In some embodiments of this application, taking SolidWorks as an example when selecting a 3D CAD system, the COM communication component library can be selected from the SolidWorks.Interop.sldworks component library.

[0029] The following is a combination of Figure 1 This describes the specific implementation of the parametric design method for distribution transformers.

[0030] S1: Build a multi-database collaborative data architecture.

[0031] This multi-database collaborative data architecture uses a collection of worksheets as its carrier.

[0032] A worksheet set is a collection of multiple worksheets in a project data table file. These worksheets establish cross-table reference relationships through parameter names, forming a complete multi-database collaborative data architecture.

[0033] The location of the project data table file is described below.

[0034] In a computer system, a standardized project working directory structure needs to be established first. A root working directory folder is defined, and each time a new project is created, subfolders can be created using the naming convention of "Project Number_Project Abbreviation". Each subfolder contains a project data table file (in Excel format, for example, named "Project Data Table.xlsx"). This project data table file contains the input data, intermediate data, and output data for the entire parametric design process.

[0035] The various worksheets are described below.

[0036] (1) Product Information Worksheet The product information worksheet stores basic information (e.g., project number (e.g., P220044101), product model (e.g., S22-M), altitude, production base, etc.) and core parameters of the transformer obtained from the electromagnetic calculation sheet of the transformer (e.g., capacity kVA, connection group number, frequency, core cross-section, number of coil turns, conductor specifications, tank size, etc.).

[0037] The table uses a wide table format. The product information worksheet is organized into groups of 4 columns. Columns 1 to 4 store project attributes, columns 5 to 8 store core parameters, and so on.

[0038] (2) Attribute worksheet This attribute worksheet defines the structural mapping of various key attributes of the distribution transformer according to the core component hierarchy, including main attributes, core attributes, clamping attributes, etc., and provides a classification index for parameter combinations.

[0039] For example, a transformer can be classified into main attributes, core attributes, and clamping attributes. The main attributes include rated capacity (kVA), rated voltage (kV), and connection group number. The core attributes include silicon steel sheet type, stack thickness (mm), and air gap length (mm). The clamping attributes include clamping material, clamping force, and insulation distance.

[0040] (3) Information output worksheet The information output worksheet stores all design parameters in a wide table format, grouped by column. This is the core data structure of the entire design system. For example, the information output worksheet is divided into parameter groups of 4 columns. The first column of each parameter group stores the parameter name, the second column stores the parameter value, and the third and fourth columns store the remarks information.

[0041] In some embodiments of this application, Figure 2 An embodiment of an information output worksheet is shown, which can set 16 parameter groups, with 4 columns per parameter group, for a total of 64 columns.

[0042] Figure 2This diagram illustrates the column grouping structure of an information output worksheet. Figure 3 A schematic diagram of the internal structure of the first parameter group is shown.

[0043] See Figure 2 The first parameter group (columns 1-4) is the project attribute group. The parameter names in column 1 are arranged in different rows, such as project number, product model, etc. The parameter values ​​stored in column 2 are arranged in different rows, such as P220044101, S22-M, etc. Columns 3 and 4 store remarks information for future use (see...). Figure 3 ).

[0044] The second parameter group (columns 5-8) is the product information group. The parameter names in column 5 are categorized into four core parameters: storage capacity (kVA), connection group number, frequency, and total weight.

[0045] The third parameter group (columns 9-12) is the core information group. The parameter names in column 9 are stored according to different rows, including structural form, silicon steel sheet type, silicon steel sheet thickness, core column center distance Mo, window height Hw, core column diameter, core cross-sectional area, core weight, and other parameters.

[0046] The fourth parameter group (columns 13-16) is the high-voltage coil group. The parameter names in column 13 store parameters such as the number of turns of the high-voltage coil, wire specifications, inner and outer diameters of the coil, number of layers, and number of segments, according to different rows.

[0047] The fifth parameter group (columns 17-20) is the low-voltage coil group. The parameter names in column 17 store parameters such as the number of turns of the low-voltage coil, wire specifications, and inner and outer diameters of the coil, according to different rows.

[0048] The 6th parameter group (columns 21-24) is the iron chip group. The parameter names in column 21 store data such as the number of levels, chip width B, chip length L, thickness per unit (referring to the actual total stacking thickness of the iron chip group after stacking in a single finished transformer), and number of chips, according to different rows.

[0049] Parameter group 7 (columns 25-28) is for high-voltage leads; parameter group 8 (columns 29-32) is for low-voltage leads. Parameter group 9 (columns 33-36) is for core assembly. Column 33 stores assembly process parameters such as silicon steel sheet number, gap between insulating tube and core, number of low-voltage stages, number of steps, process hole diameter, and core structure type, categorized by row. Parameter group 10 (columns 37-40) is for tank assembly. Column 37 stores parameters such as tank length, tank width, tank height, X-array distance of mounting holes, Y-array distance of mounting holes, and tap changer model, categorized by row. Parameter group 11 (columns 41-44) is for corrugated sheets. Column 41 stores parameters such as the number of long-face corrugated fins, the number of wide-face corrugated fins, corrugated sheet height, and corrugated fin height, categorized by row. Parameter group 12 (columns 45-48) contains other parameters for the oil tank. Column 45 stores parameters such as high-pressure bushing model and positioning dimensions, low-pressure bushing model and positioning dimensions, tap changer model and positioning dimensions, and the name of the assembly to which it belongs (e.g., tank cover assembly), organized by different rows. Parameter groups 13-16 (columns 49-60) are the total variable groups, storing the output results of global and process variables.

[0050] Each parameter group in the information output worksheet has 25 preset data rows. The first 20 rows are used to store the actual parameters, and the last 5 rows are reserved for expansion. All rows are first cleared and pre-filled with empty data rows during initialization, and then filled row by row according to the data source.

[0051] (4) Global Variables Worksheet The global variables worksheet includes a global variables section and a procedure variables section.

[0052] The global variable area stores the design parameters that are ultimately passed to the 3D model.

[0053] In some embodiments of this application, global variables in the global variable area may include, for example, all dimensional parameters of the driving model such as product model S22-M, capacity kVA, connection group number, core column center distance Mo, window height Hw, core diameter, silicon steel sheet type, oil tank length, width and height, and coil inner and outer diameters.

[0054] In some embodiments of this application, the process variable area stores intermediate derivation / calculation process variables, such as core thickness (depending on the cascading rule), distance between the base and the lower clamp, etc. These process variables do not directly drive the model, but participate in subsequent logic calculations.

[0055] As mentioned above, the step-removal rule refers to the fact that when the core column adopts a circular inscribed stepped cross-section design, theoretically, the number of steps will increase synchronously as the core diameter increases. Step-removal means removing some small-sized steps that are narrow and difficult to process, while meeting the requirements of effective magnetic conductive area. This simplifies the stacking process and avoids the problems of excessive burrs and easy breakage when punching narrow and wide steps.

[0056] The determination of the number of stages depends on the stage removal rules of the iron core. For example, when "low-voltage stage removal number" = 3, it means that the last three stages at the low-voltage side position are removed, thus reducing the actual effective number of stages.

[0057] Each of the two variable areas has four independent columns: serial number, name, parameter value, and remarks. For example, the four columns are 1, product model, S22-M, and remarks.

[0058] (5) Logical worksheet For each core component of the transformer (including the core, coil, and tank), a logic worksheet is set up, and the logic worksheet defines the parameter calculation rules between parameters.

[0059] In some embodiments of this application, multiple logic worksheets are set for the transformer, including an iron chip logic worksheet, an iron core assembly logic worksheet, an oil tank assembly logic worksheet, and a coil assembly logic worksheet.

[0060] In some embodiments of this application, the iron chip logic worksheet defines the parameter calculation rules for the iron chip.

[0061] The table structure in the iron chip logic worksheet can include two parallel sets of columns, depending on actual needs: a left side column logic column group and a right core column logic column group. Each group can include, for example, the following: item number (level number), level number (level removal indicator, e.g., no level removal / level removal), chip width B (mm), chip length L (mm), thickness per unit, number of chips, etc.

[0062] The logical calculation of the iron chip logic worksheet is as follows: given the core diameter, the width B and length L of each iron chip are calculated according to the standard sheet width sequence of the corresponding thickness in the silicon steel sheet database, following a progressively decreasing rule.

[0063] It should be noted that the silicon steel sheet database stores the standard sheet width sequence corresponding to different silicon steel sheet models (different silicon steel sheet models correspond to different thickness specifications (e.g., 0.23mm, 0.27mm, 0.30mm)). For example, the standard sheet width sequence for a certain specification is: 230mm→210mm→195mm→175mm→155mm→135mm→115mm→95mm→80mm→65mm→55mm→45mm→40mm→35mm→30mm→25mm→20mm→15mm.

[0064] In some embodiments of this application, the core assembly logic worksheet defines the parameter calculation rules for each component of the core assembly (e.g., upper and lower clamps, support plates, corner plates, pull plates, and insulating components).

[0065] The structure of the core assembly logic worksheet can be configured to include two sub-areas as needed.

[0066] The left-hand area is the associated attribute area (columns 1-4), where each column stores the serial number, parameter name, parameter value, and remarks. The parameter values ​​can be output from the worksheet via formula reference information (e.g., capacity kVA, core column center distance Mo), and global variables related to core design can be found in the global variable worksheet.

[0067] The right-hand area is the constant attribute area (columns 5-8). Each column is used to store the serial number, parameter name, parameter value, and remarks. The parameter value is a fixed process experience value. For example, the parameter value of the gap between the insulating tube and the iron core is a fixed value of 5mm, and the parameter value of the clamp thickness is a fixed value of 10mm, etc.

[0068] In some embodiments of this application, the fuel tank assembly logic worksheet defines the parameter calculation rules for each component of the fuel tank assembly.

[0069] The structure of the fuel tank assembly logic worksheet is the same as that of the iron core assembly logic worksheet. It also contains two sub-areas. The left area is the associated attribute area, which can reference global variables related to fuel tank design in the global variable worksheet. The right area is the constant attribute area, which stores fixed process constants such as the bottom thickness of the tank being a fixed value of 6mm, the cover thickness of the tank being a fixed value of 6mm, and the wall thickness of the tank being a fixed value of 6mm.

[0070] In some embodiments of this application, the coil assembly logic worksheet defines the parameter calculation rules for each component of the coil assembly.

[0071] The coil assembly logic worksheet has the same structure as the iron core assembly logic worksheet and the oil tank assembly logic worksheet above. The left-hand associated attribute area can reference global variables related to coil design in the global variable worksheet, and the right-hand area is the constant attribute area, which stores fixed process values ​​such as interlayer insulation height.

[0072] (6) Parameterized worksheet Parameterized worksheets are set up for the core components of the transformer (including the core, coils, and tank).

[0073] In some embodiments of this application, parameterized worksheets are set for each core component in the transformer: core parameterized worksheet, tank parameterized worksheet, and coil parameterized worksheet.

[0074] In some embodiments of this application, the core parameterization worksheet is a parameterization-driven mapping table for all components under the core assembly. Each row records the parameter-driven information of a SolidWorks file in the corresponding core product tree. The header columns are as follows: serial number, parent item drawing number, parent item name, current file drawing number (file material number), current file name, file suffix (taking SolidWorks as an example, the corresponding file suffixes include .SLDPRT, .SLDASM, and .SLDDRW), file category (part / assembly / drawing), drawing suffix (.SLDDRW), and dimension name-dimensional expression column (there can be multiple columns, each column is a dimension-driven mapping).

[0075] For example, a single line of parameter-driven information for a SolidWorks file containing a ferrite chip is: Serial number 4, parent item drawing number "5T.Y09.640.2134.001", parent item name "ferrite core", current file drawing number "8T.Y10.640.7548.0001", current file name "ferrite chip", file extension ".SLDPRT", file category "parts", drawing extension ".SLDDRW".

[0076] In the Dimension Name - Dimension Expression column, use "D1@grass" Figure 1 Taking the format "=(center distance Mo) / 1000" as an example, this establishes a mapping between SolidWorks internal dimension variables and parameters in the global variable worksheet, indicating that the current sketch (sketching) will be mapped to the parameters in the global variable worksheet. Figure 1 The size of object D1 in the ) is driven to Mo / 1000.

[0077] In some embodiments of this application, there are also multiple columns of size name-size expression columns. For example, when multiple columns of size name-size expression columns exist, they may include "D2@grass". Figure 1 =(Window height Hw) / 1000”, D3@Grass Figure 1 =(width B) / 1000".

[0078] In some embodiments of this application, the structure of the tank parameter worksheet is consistent with that of the core parameterization worksheet, which is a parameterization drive mapping table for all components under the tank assembly (e.g., tank assembly, tank shell, lifting plate, tank cover, corrugated sheet, bushing mounting plate, tap changer mounting base, etc.).

[0079] For example, a row in the fuel tank parameters worksheet records the parameter-driven information of the SolidWorks file for the fuel tank assembly as follows: Serial number 1, parent drawing number "None", parent name "None", current file drawing number "5T.Y09.384.2142.001", current file name "Fuel Tank", file extension ".SLDASM", file category "Assembly", drawing extension ".SLDDRW".

[0080] The parameter driving information for the SolidWorks file containing the crane in the oil tank is recorded as follows: Serial number 2, parent item drawing number "5T.Y09.384.2142.001", parent item name "oil tank", current file drawing number "8T.Y09.473.010.014", current file name "crane", file extension ".SLDPRT", file category "parts", drawing extension ".SLDDRW".

[0081] In some embodiments of this application, the structure of the coil parameter worksheet is also consistent with that of the core parameterization worksheet, which is a parameterization drive mapping table for all components (e.g., low-voltage coil assembly, high-voltage coil assembly, tape, end insulation, support bar, pad, etc.) under the high and low voltage coil assembly.

[0082] (7) Standard database worksheet set The standard database worksheet set includes multiple standard database worksheets, including multiple standard component database tables for standard components in distribution transformers (e.g., channel steel, angle steel, high-voltage bushings, low-voltage bushings) and a gauge and sound level table.

[0083] For example, the channel steel database table stores the model, cross-sectional dimensions, and unit weight of channel steel of various specifications; the angle steel database table stores the model and dimensional parameters of angle steel of various specifications; the bushing database table stores the specifications and corresponding drawing numbers of high-pressure bushings and low-pressure bushings of various models; and the track gauge and sound level table stores the correspondence between track gauge and noise limits.

[0084] It should be noted that track gauge refers to the distance between the centers of the two wheels of the wheel assembly mounted on the bottom of the transformer. It is a key fitting dimension when the transformer is installed on the ground, and different capacity transformers correspond to different standard track gauges.

[0085] The purpose of creating all the above worksheets is to be able to store design parameters related to the design of distribution transformers as needed.

[0086] S2: A parametric design engine that enables communication between a 3D CAD system and multiple worksheets.

[0087] To automate the entire process from electromagnetic calculations to 3D model generation and drawing output, a parametric design engine needs to be established. As mentioned above, this parametric design engine is a WinForms desktop application built using C# and the .NET Framework 4.7.2 platform.

[0088] This parametric design engine utilizes the Microsoft.Office.Interop.Excel component and the EPPlus library to read and write Excel files. It also uses a COM communication component library to establish a COM communication link between the .NET language and the 3D CAD system, enabling communication between the 3D CAD system and multiple worksheets. This allows for programmatic control and access to various functions within the 3D CAD system from within the parametric design engine. S3: Start the parametric design engine, import and read the electromagnetic calculation sheet.

[0089] The electromagnetic calculation sheet (Excel format) contains the results of electromagnetic calculations performed using existing professional electromagnetic calculation software, including parameter names and their corresponding values. This electromagnetic calculation sheet was obtained before the parametric design of the transformer.

[0090] In some embodiments of this application, a parametric design engine is launched. The main interface of the parametric design engine includes multiple tabs (which are used to display multiple sets of related content in blocks within the same screen area, and the view can be quickly switched by clicking the tabs), corresponding to the display and editing areas of product information, core information, coil information, and oil tank information, respectively. Each tab has an embedded data table control for displaying and editing the data of the corresponding parameter group.

[0091] In addition, the main interface of the parametric design engine also includes a toolbar area that provides an "Import Electromagnetic Calculation Sheet" function button, making it convenient to import and read electromagnetic calculation sheets.

[0092] When a user clicks the "Import Electromagnetic Calculation Sheet" button, the import process is triggered, opening the electromagnetic calculation sheet and reading the rows and columns of the calculation results into a DataTable (e.g., named jisuanshu). Simultaneously, rows and columns of worksheets related to the ferroelectric chip parameters are also read into a DataTable (e.g., named guigangpian) for subsequent ferroelectric chip parameter queries.

[0093] S4: Based on the calculation results data from the read electromagnetic calculation sheet and each logical worksheet, populate the output worksheet with multiple parameter groups.

[0094] In some embodiments of this application, filling the corresponding parameter group includes three aspects: (1) filling the corresponding parameter group according to the calculation result data of the electromagnetic calculation sheet; (2) reading fixed values ​​according to the constant attribute area of ​​each logic worksheet and filling them into the corresponding parameter group; (3) performing design logic calculation according to each logic worksheet, calculating the corresponding parameter values, and filling them into the corresponding parameter group.

[0095] The following will describe the three aspects mentioned above.

[0096] In some embodiments of this application, see Figure 4 Based on the calculation results data from the electromagnetic calculation sheet, the corresponding parameter groups are filled in. The specific implementation can be described as including the following steps.

[0097] S41: Based on the calculation result data, obtain the parameter name and its corresponding parameter value, and convert them into a key-value pair dictionary through key-value matching.

[0098] In some embodiments of this application, based on the obtained jisuanshu data table, parameter names and parameter values ​​are read and converted into a key-value pair dictionary through key-value matching.

[0099] For example, the jisuanshu data table can be converted into a dictionary by calling the DataTableToDictionary function.<string, string> This function defines a dictionary structure where both keys and values ​​are strings. The first string indicates that all keys must be strings, and the second string indicates that all corresponding values ​​must be strings. The function's conversion logic is as follows: iterate through each row of the `jisuanshu` data table, read the parameter name string from the first column as the key, read the parameter value string from the second column as the value, add the key-value pair to the dictionary collection, and return it.

[0100] S42: Initialize the parameter groups in the output table.

[0101] In some embodiments of this application, in order to facilitate the establishment of a mapping relationship between the data in the electromagnetic calculation sheet and the data in the information output worksheet for subsequent use, after obtaining the above dictionary, the 16 parameter groups (e.g., 25 rows in total) of the information output worksheet can be initialized as described above.

[0102] In some embodiments of this application, the initialization operation is specifically as follows: (1) Create an array allTables containing 16 DataTable references: Global.ResourceData0 to Global.ResourceData15 in sequence; (2) For each DataTable, first clear all existing data rows and pre-fill with empty data rows to ensure that each parameter group has 25 rows available for filling. Specifically, for each DataTable, first execute Rows.Clear() to clear all existing data rows, then loop through the information output of the total number of rows in the worksheet (e.g., 25 times), call table.NewRow() to create empty data rows and add them using table.Rows.Add() to ensure that each parameter group has 25 rows available for filling.

[0103] S43: Extract the parameter name and parameter value from the dictionary item by item and populate the corresponding parameter group in the information output table.

[0104] In some embodiments of this application, after the initialization operation is completed, the parameter name and parameter value are extracted from the dictionary item by item according to the predefined parameter mapping rules, and filled into the corresponding parameter group in the DataTable, thereby realizing the filling of the corresponding parameter group in the information output table.

[0105] For example, in the first parameter group, namely the project attribute group (ResourceData0), rows 1 and 2 are filled with parameter names such as "Project Number" and "Product Model". Based on the corresponding parameter name in the name column, the corresponding parameter value is looked up in the dictionary and written into the corresponding value column of the parameter value.

[0106] The second parameter group, namely the product information group (ResourceData1), is filled with four parameter names: "Capacity kVA", "Connection Group Number", "Frequency", and "Total Weight" in rows 1 to 4, respectively. Based on the parameter name in the name column, the corresponding parameter value is looked up in the dictionary and written into the corresponding value column of the parameter value.

[0107] The third parameter group, namely the core information group (ResourceData2), is filled with the following parameter names in rows 1 to 7: "Structural Form", "Silicon Steel Sheet Type", "Core Center Distance Mo", "Window Height Hw", "Core Diameter", "Core Cross-sectional Area", and "Core Weight". Based on the parameter name in the name column, the corresponding parameter value is searched from the dictionary and written into the corresponding value column.

[0108] The high-voltage coil group (ResourceData3) and the low-voltage coil group (ResourceData4) are filled with indexes of parameters related to the coil, such as the number of turns, wire specifications, and inner and outer diameters of the coil.

[0109] The iron chip group (ResourceData5) has a multi-row structure, and the data such as the chip width B and chip length L of each level are filled in row by row according to the level of the iron chips. The corrugated chip group (ResourceData10) is filled with parameters such as the number of long-face corrugated fins, the number of wide-face corrugated fins, the height of the corrugated fins, and the height of the corrugated fins.

[0110] The other parameters group of the fuel tank (ResourceData11) is filled with the high-pressure bushing model "BJLW-24 / 50", high-pressure phase spacing 250mm, high-pressure bushing positioning Y direction 160mm, low-pressure bushing model "BF-1 / 1000", low-pressure phase spacing 120mm, low-pressure bushing positioning Y direction 175mm, tap changer type "cold pressure switch", tap changer positioning X direction 100mm, and the corresponding assembly name "tank cover assembly" is marked.

[0111] The remaining parameter groups are filled with indexes based on the dictionary in a similar way, which will not be elaborated here.

[0112] S44: For parameters not covered in the electromagnetic calculation sheet, read fixed values ​​from the constant attribute area of ​​each logic worksheet and fill them into the corresponding parameter group. Also, traverse each logic worksheet, perform the design logic calculation item by item for each parameter calculation rule, calculate the corresponding parameter value, and fill it into the corresponding parameter group. In some embodiments of this application, not all parameter groups in the information output worksheet can be obtained from the electromagnetic calculation sheet. Therefore, after the electromagnetic calculation sheet is imported and the basic parameters are filled in, for fixed parameters not covered in the electromagnetic calculation sheet, fixed values ​​can be read from the constant attribute area of ​​the corresponding logic worksheet and filled into the corresponding parameter group.

[0113] For example, some parameters in the 9th parameter group, namely the core assembly group (ResourceData8), are read from the constant attribute area of ​​the core assembly logic worksheet and written directly. For example, "Insulation tube to core gap" = 5mm, "Low voltage de-stage number" = 3, "Number of steps" = 5, "Process hole diameter" = 14, "Core structure type" = "D type" and other assembly parameters.

[0114] Some parameters filled in the fuel tank assembly group (ResourceData9) are read from the constant attribute area of ​​the fuel tank assembly logic worksheet and written directly, such as assembly parameters such as "tank wall thickness" = 6mm and "tank bottom thickness" = 6mm.

[0115] Some parameters filled in the high-voltage coil group (ResourceData3) and low-voltage coil group (ResourceData4) are read from the constant attribute area of ​​the coil assembly logic worksheet and written directly. For example, "interlayer insulation height" is an assembly parameter with a fixed process value.

[0116] In some embodiments of this application, after the basic and fixed parameters are filled in, some parameters (e.g., clamp positioning dimensions, detailed level data of iron chips, etc.) still need to be further derived and generated through design logic calculations.

[0117] In some embodiments of this application, each logic worksheet is traversed, and for each parameter calculation rule, a preset design logic calculation is performed item by item to calculate the corresponding parameter value and fill it into the corresponding parameter group.

[0118] See Figure 5 It shows a flowchart illustrating the design logic calculations performed when traversing each logic worksheet.

[0119] In some embodiments of this application, combined with Figure 5 The design logic calculation process of the iron chip logic is described as follows.

[0120] The input data for the logic calculation process of the iron chip comes from the core column diameter (or core cross-sectional area), silicon steel sheet type, and silicon steel sheet thickness in the core information group. Based on the silicon steel sheet type, the standard sheet width sequence corresponding to that silicon steel sheet type is retrieved from the silicon steel sheet database.

[0121] The design logic calculations for the iron core chip follow these steps: The width of the primary stage (level 1) is determined based on the core diameter, typically using the standard width range that is closest to and does not exceed the core diameter. After the primary stage width is determined, the next smaller range in the standard width sequence is selected as the secondary stage width, with each stage width decreasing from the previous one. The number of stages depends on the core removal rules. For example, when "low voltage removal number" = 3 in the core assembly logic worksheet, it means that the last 3 low voltage side positions are removed, reducing the actual effective number of stages.

[0122] The length L of each stage is calculated based on the window height Hw. For edge pillars, the length of each stage is a linear function of the window height Hw plus a certain manufacturing allowance; for core pillars, the length of each stage is also related to the stage number, usually taking the window height value for the middle stages and appropriately lengthening the end stages.

[0123] The thickness of each unit in each level is calculated based on the stacking factor of the silicon wafers and the thickness of the raw materials. Taking into account the inter-wafer insulation coating and stacking gaps, the stacking factor is typically set to 0.95~0.97, and the raw material thickness is determined by the silicon steel sheet type (e.g., a thickness specification of 0.23mm). Thickness per unit = stacking factor × target stacking thickness / number of levels, then the number of wafers required for each level is calculated.

[0124] The calculation results at each level are filled into the corresponding information output worksheet's iron chip group row by row. When the calculation results involve parameters in the global variable worksheet, the calculation results are also written to the corresponding position in the global variable worksheet.

[0125] In some embodiments of this application, combined with Figure 5 The logic calculation process for iron core assembly is described below.

[0126] As mentioned above, the core assembly logic worksheet defines the associated parameters (located in the associated attribute area) and constant parameters (located in the constant attribute area) of each component (upper and lower clamps, support plates, corner plates, pull plates, insulating components, etc.) in the core assembly.

[0127] For example, taking "high and low voltage clamping parts (channel steel)" as an example, its design logic calculation follows the following: calculate the total length L of the clamping parts based on the center distance Mo of the core column and the outer diameter of the coil; calculate the mating dimensions between the clamping parts and the core based on the core stack thickness and the clamping part jaw depth.

[0128] In practice, the process iterates through each row of the core assembly logic worksheet and performs design logic calculations for each parameter calculation rule: First, it reads the parameter name from the associated attribute area and searches for the current parameter value in the corresponding parameter group of the information output worksheet; second, it reads the fixed parameter value from the constant attribute area; third, it substitutes the found parameter value and the fixed parameter value into the predefined calculation formula; and fourth, it writes the calculation result to the corresponding position in the information output worksheet or to the global variable worksheet.

[0129] The calculation results at each level are filled into the core assembly group of the corresponding information output worksheet, row by row. When the calculation results involve parameters in the global variable worksheet, the calculation results are also written to the corresponding position in the global variable worksheet.

[0130] In some embodiments of this application, the calculation process for the tank assembly logic and the coil assembly logic is consistent with the structure of the core assembly logic, the only difference being the parameter groups and fixed parameter values ​​used.

[0131] For example, rows 1 to 3 of the fuel tank assembly group (ResourceData9) are filled with the fuel tank length, width, and height parameters. It should be noted that rows 4 ("Mounting Hole X-array Distance") and 5 ("Mounting Hole Y-array Distance") are not directly obtained from the electromagnetic calculation sheet, but are derived through a custom calculation function: the fuel tank length value is added to, for example, a 60mm margin, converted to an integer, and then the custom calculation function is called to calculate the optimal hole spacing that yields the minimum margin within a given space, and this value is then filled into the corresponding fuel tank assembly group.

[0132] This custom calculation function enables the design logic calculation rules to be automatically calculated in the form of functions, which reflects the functionality of the design logic worksheet.

[0133] The calculation results at each level are filled into the corresponding parameter group of the corresponding information output worksheet, row by row. When the calculation result involves parameters in the global variable worksheet, the calculation result will also be written to the corresponding position in the global variable worksheet.

[0134] It should be noted that, Figure 5 The direction of the dashed lines shown indicates that when performing design logic calculations, the corresponding parameters are also obtained from the information output worksheet and the global variable worksheet.

[0135] S45: Save the output worksheet.

[0136] After the data is filled, execute the command to delete blank rows in each DataTable for all 16 parameter groups to make subsequent data storage and retrieval more compact.

[0137] The populated DataTable is then bound to a data table control on the main interface of the parametric design engine for display.

[0138] At the same time, all current parameter data is saved back to the information output worksheet of the project data table file, thus obtaining the complete set of design parameters.

[0139] It should be noted that the SaveData function is called here. The SaveData function uses the EPPlus library (instead of the Interop.Excel COM component) to write data. The advantages are fast data writing speed, no dependence on the locally installed Excel program, and avoidance of COM resource leakage risk.

[0140] S5: In the parametric design engine, read each parametric worksheet, obtain the parameter driving information of a 3D CAD system file in the corresponding product tree for each row of records, combine the parameter driving information and the information output worksheet, and execute the parametric driving of the 3D CAD system.

[0141] After obtaining the complete design parameter set using the above method, the 3D models of the core, coils, and hydraulic cylinders of the distribution transformer are batch parametrically driven using a 3D CAD system (such as SolidWorks) API. The batch parametric driving process can be executed step by step in the order of core → tank → coil, with each step covering parts, assemblies, and engineering. Figure 3 Each level.

[0142] In some embodiments of this application, the toolbar area on the main interface of the parametric design engine also provides function buttons such as "Batch Parameterization of Iron Core", "Batch Parameterization of Oil Tank", and "Batch Parameterization of Coil" to facilitate the parameterization operation of transformer core components.

[0143] The parameterization process is triggered by the user clicking the corresponding "Batch Parameterization of Iron Core", "Batch Parameterization of Coil" and "Batch Parameterization of Oil Tank" function buttons.

[0144] In some embodiments of this application, the core parameterization driving process is described using core parameterization as an example.

[0145] When a user clicks the "Batch Parameterization of Iron Cores" function button on the main interface of the parametric design engine, the batch parameterization process for iron cores is triggered.

[0146] (1) Record the start time DateTime startTime=DateTime.Now for subsequent timing statistics. (2) Obtain the project path by concatenating the global variable, and then concatenate "project data table.xlsx" to get the complete path of the data file. For example, root working directory folder\subfolder\project data table.xlsx.

[0147] (3) Open the data file according to the complete path of the data file, read the row and column contents of the iron core parameterization worksheet into the DataTable data structure dt, and then close the data file to release resources.

[0148] As mentioned above, each row in the core parameterization worksheet records the parameter driving information for a SolidWorks file in the corresponding core product tree. That is, each row in dt corresponds to a file in the core product tree that needs to be driven.

[0149] Therefore, traverse dt row by row, performing the following steps for each row.

[0150] S51: Extract file information from the current line.

[0151] This file information includes the file type, the current file drawing number, and the current file name.

[0152] Get the file type from the "File Extension" column (.SLDPRT / .SLDASM / .SLDDRW), get the current file drawing number from the "Current File Drawing Number" column (e.g., 8T.Y10.640.7548.0001), and get the current file drawing number from the "Current File Name" column (e.g., Iron Chip).

[0153] The file type is determined by the file extension. If the file extension is ".SLDPRT", the file type is a part. If the file extension is ".SLDASM", the file type is an assembly. If the file extension is ".SLDDRW", the file type is a drawing.

[0154] S52: Construct the physical path of the file.

[0155] Based on the current file name (e.g., iron chip), recursively search for files with the same name in the corresponding finished product folder (e.g., iron core assembly folder) under the project subfolder (e.g., using the Directory.GetFiles method and accepting the three extensions ".SLDPRT", ".SLDASM", and ".SLDDRW"), and then construct the complete physical path of the file.

[0156] S53: Open the corresponding file based on the file's physical path.

[0157] In some embodiments of this application, the corresponding file is opened in silent mode based on the file's physical path.

[0158] This file can be a part file (.SLDPRT), an assembly file (.SLDASM), or a drawing file (.SLDDRW). The corresponding document type parameter should be a document type constant in the SolidWorks API, used to identify whether the file being opened or created is a part file, an assembly file, or a drawing file.

[0159] Silent mode suppresses dialog boxes and user interaction when opening files, ensuring the smooth flow of batch processing.

[0160] S54: Execute the corresponding parameterized driver based on the type of the opened file.

[0161] In some embodiments of this application, different file types have different parameterized driving datasets.

[0162] Based on these parametrically driven datasets, the secondary development interface of the 3D CAD system is used to drive the part files, assembly files and engineering drawing files corresponding to each core component to execute parametric driving, thereby completing the generation of 3D models and the output of engineering drawings.

[0163] In some embodiments of this application, when the file type is part, the following sub-steps are performed for the opened part file (.SLDPRT).

[0164] S541: Obtain the dimensional values ​​of the driving part and write the dimensional values ​​into the 3D CAD system.

[0165] (1) Read the dimension name and target value of each dimension variable in the part file from the dimension name-dimensional expression column of the current row (for example, you can reference the global variable in the global variable worksheet).

[0166] For example, for iron chip parts, the size name is "D1@grass". Figure 1 Its target value references the global variable "center distance Mo".

[0167] In some embodiments of this application, it is determined whether the target value is a direct numerical value or a variable reference. If the target value string begins with only numbers, it is a direct numerical value; otherwise, the parameter value corresponding to the parameter name is retrieved from the global variable worksheet.

[0168] (2) Assign dimensions to the dimension values ​​based on the target values.

[0169] SolidWorks uses the International System of Units (SI) internally. If the target value is in meters, no conversion is needed; the dimension value can be directly assigned from the target value. If the target value is in millimeters, the target value needs to be divided by 1000 to convert it into a dimension value.

[0170] For example, if the target value is "center distance Mo", since the unit of "center distance Mo" is millimeters, the dimension value is assigned as "center distance Mo / 1000".

[0171] (3) Write the dimension values ​​into the dimension object of the 3D CAD system.

[0172] In some embodiments of this application, the secondary development interface of the 3D CAD system is called to write the dimension values ​​into the model.

[0173] The specific implementation is as follows: First, obtain the dimension object (e.g., D1) from the 3D CAD system by dimension name, and then assign dimension attributes to the dimension object using dimension values.

[0174] S542: Retrieve custom attributes and write them into the model.

[0175] Extract the custom attributes (attribute name and attribute value pairs) that the part should have from the core assembly group or other relevant parameter groups in the information output worksheet. For example, the attribute name "current file drawing number" corresponds to the attribute value "8T.Y10.640.7548.0001", the attribute name "current file name" corresponds to the attribute value "iron chip", and the attribute name "material" corresponds to the attribute value taken from the material field in the information output worksheet (e.g., material name, material type).

[0176] In some embodiments of this application, the secondary development interface of the 3D CAD system is called to write custom attributes into the custom attributes of the part file and store them under the "default" configuration.

[0177] As described above, in some embodiments of this application, when the file type is a part file, the parameterized data driver set may include relevant information identifying the part file (e.g., file physical path, current file drawing number, current file name, attribute information) and dimensional values ​​that drive changes in the part.

[0178] In some embodiments of this application, when the material code of a part is specified in the information output worksheet, the secondary development interface of the 3D CAD system is called to switch the part material.

[0179] Specifically, the secondary development interface of the 3D CAD system internally calls the material library of the 3D CAD system, retrieves materials in the material library by material code, and applies them to the current part file to achieve the switching of part materials.

[0180] In some embodiments of this application, when the file type is an assembly type, the following sub-steps are performed for the opened assembly file (.SLDASM).

[0181] S541': Assembly-level parameter writing.

[0182] Obtain assembly-level parameters related to the overall dimensions of the assembly from the core assembly group in the information output worksheet (e.g., core structure type, stack thickness direction clearance, clamp spacing, constraint relationships and position references between all components in the assembly).

[0183] The assembly-level parameter is written to the global variable table of the assembly file through the global variable writing interface, making the assembly-level parameter an assembly-level global variable parameter.

[0184] S542': Perform a reconstruction operation on the assembly.

[0185] It is known that the part files corresponding to all components in the assembly have been parametrically driven using S541 and S542 as described above. Therefore, the assembly-level model reconstruction is performed using the 3D CAD system API, and the constraint relationships and position references of all components in the assembly are recalculated after the parameter update by using the assembly-level global variable parameters as described above.

[0186] The reconstruction operation ensured that the spatial positioning and parameter values ​​of each component in the assembly remained consistent.

[0187] As described above, in some embodiments of this application, when the file type is an assembly file, the parameterized driving dataset may include relevant information identifying the assembly file (e.g., file physical path, current file drawing number, current file name) and assembly-level parameters.

[0188] In some embodiments of this application, when the file type is drawing, the following sub-steps are performed for the opened drawing file (.SLDDRW).

[0189] S541'': Write the design table data in the engineering drawing.

[0190] (1) Access the design table (BOM) in the engineering drawing through the API of the 3D CAD system.

[0191] For example, the BOM anchor ID in the iron core engineering drawing is "Detail Item 318@Drawing 1" (Detail Item 318 represents the table name, and Drawing 1 represents the drawing name).

[0192] (2) Format the parameter group of the iron chip group in the information output worksheet into a DataTable data structure to obtain the engineering drawing details to be written into the engineering drawing.

[0193] (3) By calling the 2D CAD secondary development interface, the row and column contents of the DataTable are written into the corresponding cells of the BOM table in the engineering drawing, so as to realize the automatic generation of the engineering drawing details table.

[0194] S542'': Invalid data cleanup.

[0195] To avoid invalid annotations in engineering drawings due to parameter changes, redundant or invalid elements in the engineering drawings are cleaned up by calling the 2D CAD secondary development interface.

[0196] In some embodiments of this application, when a user needs to precisely drive the core engineering drawing at the dimensional level, in addition to automatically generating the engineering drawing details table, the secondary development interface of the 3D CAD system is also called. First, the dimension object of the 3D CAD system is obtained by the dimension name, and then the dimension object is assigned dimension attribute value using the corresponding dimension value, so as to batch update the dimension name-dimensional value pair to the corresponding annotation dimension in the engineering drawing.

[0197] In some embodiments of this application, when the file type is an engineering drawing file, the parameterized driving dataset may include relevant information identifying the file (e.g., file physical path, current file drawing number, current file name) and engineering drawing details.

[0198] S55: Save and close the file.

[0199] After each SolidWorks file is parameterized, the file is immediately saved and closed to release SolidWorks memory resources. A delay is added between saving and closing to ensure that the saving operation is indeed completed.

[0200] S56: Record the total time elapsed.

[0201] After processing all rows in DataTable dt, the program records the end time DateTime endTime = DateTime.Now, calculates the total time elapsed = endTime - startTime, and sends feedback to the user via a message box on the number of files processed and the total time taken, for example, "Running 12 files, taking 45 seconds".

[0202] This completes the batch parameterization drive process for iron cores.

[0203] In some embodiments of this application, the parameterization driving process for batch parameterization of oil tanks and batch parameterization of coils is completely consistent with the parameterization driving process for batch parameterization of iron cores, the only difference being the data source for generating the corresponding parameterization driving dataset.

[0204] The system performs batch parameterization of the fuel tank by reading parameter data from the fuel tank parameterization worksheet and the information output worksheet for the fuel tank assembly group. It also performs batch parameterization of the coils by reading parameter data from the coil parameterization worksheet and the information output worksheet for the high-voltage coil group and the low-voltage coil group.

[0205] The batch parameterization of iron cores, oil tanks, and coils are triggered by pressing different function buttons and can be executed independently or sequentially.

[0206] In some embodiments of this application, a batch processing mode for setting custom attributes is also provided.

[0207] For example, in the event handler function corresponding to "button23_Click", after the user selects multiple SolidWorks files, the system automatically parses the name of each file (separated by "_" underscores), uses the first part as the current file drawing number and the second part as the current file name, and automatically writes this information into the custom properties of each SolidWorks file. This function is suitable for scenarios where drawing number attributes need to be standardized in batches during the initial stage of 3D model creation.

[0208] In some embodiments of this application, after the parameterization driving process of the core, oil tank and coil core components is completed, a complete snapshot of the design parameters has been stored in the project data sheet file.

[0209] S6: According to the preset directory structure, classify the finished product files generated by the driver into three corresponding finished product folders under the project subfolder: core assembly folder, oil tank assembly folder, and coil assembly folder.

[0210] The core assembly folder is used to store core assemblies (.SLDASM), core chips (.SLDPRT), and their engineering drawings (.SLDDRW); the tank assembly folder is used to store tank assemblies and all parts and engineering drawings, including tank covers, tank walls, corrugated sheets, bushings, and lifting devices; the coil assembly folder is used to store high-voltage coil assemblies, low-voltage coil assemblies, and parts and engineering drawings such as end insulation, support bars, pads, and cloth tape.

[0211] In some embodiments of this application, the main interface of the parametric design engine provides three buttons for quickly opening finished product folders: "Finished Core", "Finished Oil Tank", and "Finished Coil". It also provides an "Open Project Data Sheet" button to open the project data sheet file for the current project with a single click.

[0212] In some embodiments of this application, a cyclic processing mode can be adopted for the parameterized design scheme of multiple distribution transformers.

[0213] Specifically, the user places multiple sets of electromagnetic calculation files into the same directory, reads each electromagnetic calculation file in a loop, and sequentially executes the entire process described above: import → logic calculation → parameter-driven processing. Each solution is output to an independent project subfolder, named according to the electromagnetic calculation file name or project number. Progress is provided in real-time via message boxes during processing.

[0214] The following is a parametric design process result, using an S22-M-630 / 10-NX1 type distribution transformer as an example.

[0215] The electromagnetic calculation sheet contains approximately 150 basic parameters, which are expanded to approximately 400 design parameters (including global and process variables) after parameter parsing and logical calculation. The core parameterization worksheet contains 12 rows of records (1 core assembly + 3 core sub-assemblies + 4 core chip parts + 4 engineering drawings), the fuel tank parameterization worksheet contains approximately 35 records (1 fuel tank assembly + approximately 25 parts + 9 engineering drawings), and the coil parameterization worksheet contains approximately 15 records. The entire process takes approximately 3-5 minutes (this time depends on computer performance and the response speed of the 3D CAD system), and the final output is a complete set of design data containing all 3D models and engineering drawings.

[0216] The parametric design method for distribution transformers involved in this application has the following advantages: (1) It realizes the full-process automated processing from electromagnetic calculation to three-dimensional model and drawing output, reducing the workload that would normally take 3 to 5 working days to tens of minutes, significantly shortening the design cycle and improving design efficiency; (2) The entire process of parameter data from electromagnetic calculation to model and drawing does not require manual transcription, eliminating the risk of data entry errors and omissions, reducing the rework rate caused by parameter data transmission from 8% to 12% to near zero, and fundamentally eliminating data transmission errors; (3) The design logic of the core components of the transformer is stored in the form of a worksheet. When the design standard or process specification changes, there is no need to modify the program source code. Only the corresponding logic worksheet needs to be adjusted to adapt, greatly reducing maintenance costs; (4) All schemes are implemented under a unified process, eliminating differences in human experience, ensuring the standardization and consistency of design output, and ensuring that the structural parameters and component selection of products of the same specifications remain consistent; (5) In parts, assemblies, and engineering Figure 3 There are parameter transfer links between each level. After the size of the bottom layer changes, the assembly and engineering drawing to which it belongs are automatically rebuilt and updated, realizing the linkage update of multi-level models; (6) Supports parallel batch generation of multiple schemes, which helps to select the optimal cost scheme and can use the lowest cost scheme as the final design output; (7) The worksheet for storing parameter data adopts a wide table format, which can flexibly expand the number of parameter groups and fields according to the product category, and has fast change response and strong scalability.

[0217] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, and not to limit them; although the present invention has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that modifications can still be made to the technical solutions described in the foregoing embodiments, or equivalent substitutions can be made to some of the technical features; and these modifications or substitutions do not cause the essence of the corresponding technical solutions to deviate from the spirit and scope of the technical solutions of the embodiments of the present invention.

Claims

1. A parametric design method for a distribution transformer, characterized in that, Includes the following steps: S1: Construct a multi-database collaborative data architecture; The multi-database collaborative data architecture uses multiple worksheets as carriers to store design parameters related to the core components of the distribution transformer in the parametric design as needed in each worksheet. Cross-table reference relationships are established between the worksheets through the parameter names of the design parameters. The core components of the transformer include the core, tank and coil. S2: A parametric design engine that enables communication between a 3D CAD system and multiple worksheets; S3: Start the parametric design engine, import and read the electromagnetic calculation sheet; S4: Based on the calculation results data and various logic worksheets read from the electromagnetic calculation sheet, populate the information output worksheet with multiple parameter groups; The worksheets include an information output worksheet and logical worksheets for each core component. The information output worksheet stores all design parameters in a wide table format, grouped by column. Multiple columns form a parameter group, and the parameter name and its corresponding parameter value are stored by column. The logical worksheets define the parameter calculation rules between the parameters of the corresponding core components. S5: In the parametric design engine, read the parametric worksheets of each core component, obtain the parameter driving information of a 3D CAD system file in the corresponding product tree for each row of the parametric worksheet, and combine the parameter driving information and the information output worksheet to execute the parametric driving of the 3D CAD system for each core component. S6: Categorize the finished product files generated by the driver into three corresponding finished product folders: core assembly folder, oil tank assembly folder, and coil assembly folder; Each assembly folder is used to store the corresponding core component assembly, its related parts, and engineering drawings.

2. The parametric design method for distribution transformers according to claim 1, characterized in that, S4 specifically includes: S41: Based on the calculation result data, obtain the parameter name and parameter value, and convert them into a key-value pair dictionary through key-value matching; S42: Initialize the parameter groups in the output worksheet; S43: Extract the parameter name and parameter value item by item from the key-value pair dictionary and fill them into the corresponding parameter group in the information output worksheet; S44: For parameters not covered in the electromagnetic calculation sheet, read fixed values ​​from the constant attribute area of ​​each logic worksheet and fill them into the corresponding parameter group. Also, traverse each logic worksheet, perform the design logic calculation item by item for each parameter calculation rule, calculate the corresponding parameter value, and fill it into the corresponding parameter group. S45: Save the output worksheet containing the information.

3. The parametric design method for distribution transformers according to claim 2, characterized in that, The specific process of initializing the parameter group in the output worksheet of S42 includes: Create an array containing multiple DataTable references, the number of which is the same as the number of parameter groups in the output worksheet; For each DataTable, clear all existing data rows and pre-populate them with empty data rows.

4. The parametric design method for distribution transformers according to claim 1, characterized in that, In S5, the parametric driving of the 3D CAD system for core components is specifically as follows: Read the row and column contents of the parameterized worksheet of the core component into the DataTable data structure dt; Iterate through dt line by line, and perform the following operation on each line: Extract file information from the current line. The file information includes file type, current file drawing number, and current file name. The file type includes part type, assembly type, and drawing type. Build the physical path of the file; Open the corresponding file based on its physical path; Based on the type of file opened, the corresponding parametric drive is executed. Specifically: when the file type is a part, a parametric drive dataset is generated, including relevant information identifying the part file and dimensional values ​​that drive changes in the part. This dataset is used to drive the part file to perform parametric drive and generate a 3D model. When the file type is an assembly, a parametric drive dataset is generated, including relevant information identifying the assembly file and assembly-level parameters. This dataset is used to drive the assembly file to perform parametric drive and generate a 3D model. When the file type is a drawing, a parametric drive dataset is generated, including relevant information identifying the drawing file and drawing details. This dataset is used to drive the drawing file to perform parametric drive and output drawing details. After the corresponding parameterized driver is completed, save and close the corresponding file.

5. The parametric design method for distribution transformers according to claim 4, characterized in that, When the file type is part type, the corresponding parameterized driver is executed, specifically: Obtain the dimensional values ​​of the driving parts and write them into the 3D CAD system; Extract the custom attributes of the part corresponding to the part file from the information output worksheet and write the custom attributes into the model. If the material code of the part is specified in the information output worksheet, switch the material of the part.

6. The parametric design method for distribution transformers according to claim 4 or 5, characterized in that, When the file type is an assembly, the corresponding parameterized driver is executed, specifically: Write the assembly-level parameters related to the overall dimensions of the assembly corresponding to the assembly file from the information output worksheet into the global variable table of the assembly file. Perform a reconstruction operation on the assembly.

7. The parametric design method for distribution transformers according to claim 6, characterized in that, When the file type is an engineering drawing, the corresponding parametric driver is executed, specifically: Access design tables in engineering drawings via 3D CAD system API; Format the parameter groups related to the engineering drawing file in the information output worksheet into a DataTable data structure to obtain the engineering drawing details to be written into the engineering drawing; Write the row and column contents of the DataTable into the corresponding cells of the designed table one by one; Clean up invalid data in the engineering drawings.

8. The parametric design method for distribution transformers according to claim 1, characterized in that, The parametric design method for the distribution transformer also includes the following steps: The electromagnetic calculation sheet can be quickly imported and read by configuring the "Import Electromagnetic Calculation Sheet" button on the main interface of the parametric design engine. The parameterization process of iron cores can be quickly executed by configuring the batch parameterization button of the iron core on the main interface of the parameterized design engine. The parameterization process of fuel tanks can be quickly executed by configuring the batch parameterization button for fuel tanks on the main interface of the parameterized design engine. The parameterization process of coils can be quickly executed by configuring the batch parameterization button on the main interface of the parametric design engine.

9. The parametric design method for distribution transformers according to claim 1, characterized in that, The parametric design method for the distribution transformer also includes the following steps: The core assembly folder can be quickly opened by configuring a core finished product button on the main interface of the parametric design engine. The fuel tank assembly folder can be quickly opened by configuring a "Fuel Tank Finished Product" button on the main interface of the parametric design engine. The coil assembly folder can be quickly opened by configuring the coil finished product button on the main interface of the parametric design engine.

10. The parametric design method for distribution transformers according to claim 1, characterized in that, Multiple worksheets are stored in a project data table file in Excel format; After executing the parametric drive of the 3D CAD system in S5, a complete snapshot of the design parameters is stored in the project data table file; The parametric design method for the distribution transformer also includes the following steps: The project data table file can be quickly opened by configuring a button to open the project data table file on the main interface of the parametric design engine.

Images