Transformer parameterization design method, device and equipment

Abstract

The invention relates to the technical field of transformers, in particular to a transformer parameterization design method, device and equipment, and the method comprises the following steps: solidifying a transformer design standard and specification in an Excel worksheet, and defining a control parameter through a set compiling grammar; the control parameters comprise a real number type, an integer type, a character string type and a Boolean type; one writing grammar is set for each parameter type; exporting control parameters in the Excel worksheet as an XML (Extensible Markup Language) file; creating a notebook file in automatic design software, and importing the control parameters in the XML file; based on the imported control parameters, parametric modeling is carried out in automatic design software, and a three-dimensional model of the transformer is generated; and automatically generating a two-dimensional engineering drawing of the transformer according to the three-dimensional model. Standardization of links such as design, manufacturing, installation and operation of the transformer is effectively ensured, and therefore performance and reliability of the transformer are greatly improved.

Description

Technical Field

[0001] The present application relates to the technical field of transformers, and in particular to a method, device and equipment for parameterized design of transformers. Background Art

[0002] Traditional transformer design methods often rely on the designer's experience and manual drawing. Traditional manual CAD drawing methods require designers to spend a considerable amount of time creating and modifying drawings, resulting in low efficiency and difficulty meeting the modern manufacturing industry's demand for rapid response to market changes. During the manual drawing process, human factors such as negligence and fatigue can easily lead to design errors, which in turn affect product quality and performance. Design errors or unreasonable design parameters often require correction during the production phase, resulting in product rework and increased production costs and delivery times.

[0003] In traditional transformer design, the designer's personal experience often plays a dominant role. While this reliance on experience offers a certain degree of flexibility, it also leads to a variety and uncertainty in design solutions. Differences in experience, skills, and knowledge often lead to different design solutions, significantly reducing the degree of standardization and compliance in transformer design.

[0004] Furthermore, variations in transformer material selection and component sizes further exacerbate design uncertainty. Due to the lack of unified standards and specifications for material selection, different designers may choose materials with varying performance, price, and lead times. This not only increases the difficulty of cost control but also impacts the transformer's overall performance and reliability. Regarding component size, due to the diversity of design options, the same transformer model may have a variety of component sizes. This not only increases manufacturing complexity but also reduces equipment interchangeability and ease of maintenance. Summary of the Invention

[0005] To improve the standardization and conformity of transformer design, this paper proposes establishing unified design standards and specifications, integrating them into parametric design. These unified standards and specifications effectively ensure standardization across all aspects of transformer design, manufacturing, installation, and operation, significantly improving transformer performance and reliability. Furthermore, the application of parametric design can make design more efficient and accurate, reduce design costs, and improve design quality.

[0006] In a first aspect, the technical solution of the present invention provides a transformer parameterized design method, comprising the following steps: Solidify the transformer design standards and specifications in an Excel worksheet and define control parameters using a predefined syntax. The control parameters include four types: real number, integer, string, and Boolean. Each parameter type has a specific syntax. Export the control parameters in the Excel worksheet as an XML file; Create a notepad file in the automation design software and import the control parameters in the XML file; Based on the imported control parameters, parametric modeling is performed in the automated design software to generate a three-dimensional model of the transformer; A two-dimensional engineering drawing of the transformer is automatically generated based on the three-dimensional model.

[0007] This method achieves standardization and parameterization of the design basis by solidifying design standards and specifications in Excel worksheets and defining various types of control parameters. This avoids the diversity and uncertainty of design solutions caused by traditional reliance on personal experience, and improves the standardization and regulation of design. Exporting control parameters as XML files and importing them into automated design software enables effective data transfer and utilization between different software, making the design process smoother. Parametric modeling and automatic generation of 2D engineering drawings based on imported parameters improve design efficiency, reduce the time and errors associated with manual drawing, lower design costs, and improve design quality, enabling rapid response to market changes.

[0008] As a further limitation of the technical solution of the present invention, the steps of solidifying the transformer design standards and specifications in an Excel worksheet and defining the control parameters through a set writing syntax include: Solidify design standards and specifications into Excel worksheets to obtain control parameters for automatic parametric design input; The control parameters are written in an Excel worksheet according to the set writing syntax, so that the values ​​of the control parameters are dynamically linked with the transformer calculation sheet, design standards and specifications to generate an Excel file; when the transformer model changes, the control parameters are automatically updated.

[0009] Dynamically linking control parameters with transformer calculations, design standards, and specifications allows automatic updating of control parameters when the transformer model changes. This ensures the accuracy and timeliness of design parameters, avoids design issues caused by untimely or erroneous manual parameter modifications, and further improves design reliability and accuracy.

[0010] As a further limitation of the technical solution of the present invention, the Excel file includes a control parameter sheet page, a structural principle sheet page defining the core type and lamination rules, a transformer calculation parameter sheet page storing electrical parameters, a product information sheet page recording identification information, and a material selection sheet page; The control parameters include transformer model, core lamination parameters, and silicon steel sheet brand.

[0011] The Excel file contains multiple sheets with clear division of labor. The Control Parameters sheet centrally manages various key parameters; the Structural Principles sheet defines core types and lamination rules, providing a foundation for core structural design; the Transformer Calculation Parameters sheet stores electrical parameters to ensure accurate electrical performance design; the Product Information sheet records identification information for easy product management and traceability; and the Material Selection sheet specifies material selection.

[0012] Clarify the specific content of the control parameters, including transformer model, core lamination parameters, silicon steel sheet brand, etc. These parameters directly affect the performance and cost of the transformer. Their precise definition and management will help optimize design, control costs and ensure product quality.

[0013] As a further limitation of the technical solution of the present invention, the step of exporting the control parameters in the Excel worksheet to an XML file includes: Create a Notepad file named Total Parameter Table, copy the contents of the Control Parameter Sheet page in the Excel file to Total Parameter Table.txt, and change the suffix txt to XML to form the Total Parameter Table.XML file.

[0014] An XML file is generated by creating a Notepad file, copying the content, and modifying the suffix. This method is simple and efficient, reduces the difficulty of data conversion, and ensures that the control parameters in the Excel worksheet can be accurately converted into a format that can be recognized by the automated design software.

[0015] As a further limitation of the technical solution of the present invention, the step of creating a notepad file in the automated design software and importing the control parameters in the XML file includes: Create a core parameter .lay notepad file in the automated design software, and import the parameter name, type, value, and description information of the total parameter table .XML into the corresponding parameters in the core parameter .lay.

[0016] The specific method for creating a specific Notepad file and importing XML file parameters in the automation design software is clarified to standardize the parameter import process. This ensures that the automation design software can accurately obtain the name, type, value, and description of the control parameter, providing accurate data support for subsequent parametric modeling.

[0017] As a further limitation of the technical solution of the present invention, the step of performing parametric modeling in the automated design software based on the imported control parameters to generate a three-dimensional model of the transformer includes the following steps: Create a part file in the automation design software and declare a notebook file to reference the control parameters; According to the structural selection conditions in the control parameters, a three-phase three-column or three-phase five-column core structure 3D model is automatically generated.

[0018] Creating a part file and declaring and referencing the control parameters in the Notebook file effectively applies these parameters to the design model. Automatically generating 3D models of different core structures based on the structural selection criteria in the control parameters improves modeling automation. This eliminates the need for designers to manually draw models of different structures, reducing workload while ensuring model accuracy and consistency.

[0019] As a further limitation of the technical solution of the present invention, the structure selection condition is a Boolean parameter, and a three-phase five-pillar core structure or a three-phase three-pillar core structure is generated according to the parameter value; the Boolean parameter is whether it is a three-phase five-pillar structure. Using Boolean parameters as structure selection criteria is simple and intuitive. Using the "three-phase, five-leg" parameter value, you can quickly and accurately determine whether to generate a three-phase, five-leg or three-phase, three-leg core structure, making the design process more intelligent and improving design efficiency and flexibility.

[0020] As a further limitation of the technical solution of the present invention, automatically generating a two-dimensional engineering drawing of the transformer based on the three-dimensional model includes: Define drawing parameters in the 3D model, including drawing number, product model, material name and core structure; In a two-dimensional engineering drawing, the drawing parameters are referenced through text expressions to achieve automatic filling of drawing information.

[0021] Define drawing parameters within the 3D model, integrating key information into the model for unified management and modification. In 2D drawings, reference these parameters through text expressions for automatic filling, eliminating errors that can occur when manually entering drawing information. This improves drawing efficiency and accuracy, ensuring consistency between drawing information and the 3D model.

[0022] In a second aspect, the technical solution of the present invention further provides a transformer parametric design device, comprising a parameter definition module, a parameter conversion module, a parameter import module, a modeling module and a drawing module; The parameter definition module is used to solidify the transformer design standards and specifications in an Excel worksheet and define control parameters through a set writing syntax; the control parameters include four types: real number, integer, string, and Boolean; each parameter type has a writing syntax; Parameter conversion module, used to export the control parameters in the Excel worksheet into an XML file; A parameter import module is used to create a notepad file in the automation design software and import the control parameters in the XML file; Modeling module, used to perform parametric modeling in the automated design software based on the imported control parameters to generate a three-dimensional model of the transformer; A drawing module is used to automatically generate a two-dimensional engineering drawing of the transformer based on the three-dimensional model.

[0023] This device implements modular management of the transformer parametric design process by setting up modules with different functions. Each module has a clear division of labor. The parameter definition module is responsible for design standards and parameter specifications; the parameter conversion module handles data format conversion; the parameter import module enables data transfer between software; the modeling module constructs 3D models; and the drawing module generates 2D drawings. This modular design ensures a clear logic throughout the design process, making it easy to maintain and expand. Different modules can be independently optimized and upgraded, improving the stability and scalability of the design system and enhancing overall design efficiency and quality.

[0024] As a further limitation of the technical solution of the present invention, the parameter definition module includes a control parameter acquisition submodule and a parameter definition submodule; The control parameter acquisition submodule is used to solidify the design standards and specifications in the Excel worksheet and obtain the control parameters for automatic parametric design input; The parameter definition submodule is used to write the control parameters in an Excel worksheet according to the set writing syntax, so that the control parameter values ​​are dynamically linked with the transformer calculation book, design standards and specifications to generate an Excel file; when the transformer model changes, the control parameters are automatically updated.

[0025] As a further limitation of the technical solution of the present invention, the Excel file includes a control parameter sheet page, a structural principle sheet page defining the core type and lamination rules, a transformer calculation parameter sheet page storing electrical parameters, a product information sheet page recording identification information, and a material selection sheet page; The control parameters include transformer model, core lamination parameters, and silicon steel sheet brand.

[0026] As a further limitation of the technical solution of the present invention, the parameter conversion module is specifically used to create a notepad file named as the total parameter table, copy the content of the control parameter Sheet page in the Excel file to the total parameter table.txt, and modify the suffix txt to XML, thereby forming a total parameter table.XML file.

[0027] As a further limitation of the technical solution of the present invention, the parameter import module is specifically used to create a core parameter .lay notepad file in the automated design software, and import the parameter name, type, value, and description information of the total parameter table .XML into the corresponding parameters of the core parameter .lay.

[0028] As a further limitation of the technical solution of the present invention, the modeling module includes a declaration submodule and a three-dimensional model generation submodule; Declare submodule, used to create part files in automated design software and declare notepad files to reference control parameters; The three-dimensional model generation submodule is used to automatically generate a three-dimensional model of a three-phase three-column or three-phase five-column core structure according to the structure selection conditions in the control parameters.

[0029] As a further limitation of the technical solution of the present invention, the structure selection condition is a Boolean parameter, and a three-phase five-pillar core structure or a three-phase three-pillar core structure is generated according to the parameter value; the Boolean parameter is whether it is a three-phase five-pillar structure. As a further limitation of the technical solution of the present invention, the drawing module includes a parameter definition submodule and a drawing generation submodule; The parameter definition submodule is used to define drawing parameters in the 3D model, including drawing number, product model, material name and core structure; The drawing generation submodule is used to reference the drawing parameters through text expressions in the two-dimensional engineering drawing to achieve automatic filling of drawing information.

[0030] In a third aspect, the technical solution of the present invention also provides an electronic device, comprising: at least one processor; and a memory communicatively connected to the at least one processor; the memory stores computer program instructions that can be executed by the at least one processor, and the computer program instructions are executed by the at least one processor so that the at least one processor can execute the transformer parameterized design method as described in the first aspect.

[0031] As can be seen from the above technical solutions, this application has the following advantages: through unified design standards and specifications, it can effectively ensure the standardization of all aspects of transformer design, manufacturing, installation, and operation, thereby greatly improving the performance and reliability of the transformer. At the same time, the application of parametric design can make the design work more efficient and accurate, reduce design costs, and improve design quality. BRIEF DESCRIPTION OF THE DRAWINGS

[0032] In order to more clearly illustrate the technical solution of the present application, the following is a brief introduction to the drawings required for the description. Obviously, the drawings described below are only some embodiments of the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without any creative work.

[0033] Figure 1 A flowchart of a method provided in an embodiment of the present invention.

[0034] Figure 2 This is a sketch of a three-phase three-column iron yoke.

[0035] Figure 3 This is a solid diagram of a three-phase three-column iron yoke.

[0036] Figure 4 This is a sketch of a three-phase three-column core-column piece.

[0037] Figure 5 This is a solid diagram of a three-phase three-column iron yoke.

[0038] Figure 6 This is a sketch of a three-phase five-column core column.

[0039] Figure 7 This is a physical diagram of a three-phase three-column core-column piece.

[0040] Figure 8 The following is a sketch of a three-phase five-column iron yoke sheet 1.

[0041] Figure 9 This is a solid diagram of a three-phase five-column iron yoke plate 1.

[0042] Figure 10 Sketch drawing of three-phase five-column iron yoke piece 2.

[0043] Figure 11 This is a solid diagram of a three-phase five-column iron yoke sheet 2.

[0044] Figure 12 This is a rough sketch of a three-phase five-column yoke.

[0045] Figure 13 This is a solid diagram of a three-phase five-column side yoke.

[0046] Figure 14A block diagram of a device provided in an embodiment of the present invention. DETAILED DESCRIPTION

[0047] In order to improve the standardization and normativeness of transformer design, this application proposes to formulate unified design standards and specifications and solidify them into innovative ideas in parametric design. Through unified design standards and specifications, the standardization of transformers in various links such as design, manufacturing, installation and operation can be effectively ensured, thereby greatly improving the performance and reliability of transformers. At the same time, the application of parametric design can make design work more efficient and accurate, reduce design costs, and improve design quality. In order to make the application purpose, features, and advantages of this application more obvious and easy to understand, the technical solutions protected by this application will be clearly and completely described using specific embodiments and drawings. Obviously, the embodiments described below are only part of the embodiments of this application, not all of the embodiments. Based on the embodiments in this application, all other embodiments obtained by ordinary technicians in this field without making creative work are within the scope of protection of this application.

[0048] like Figure 1 As shown, an embodiment of the present invention provides a transformer parameter design method, comprising the following steps: S1. Solidify the transformer design standards and specifications in an Excel worksheet and define control parameters using a set writing syntax; the control parameters include four types: real number, integer, string, and Boolean; and each parameter type is assigned a writing syntax; This step specifically includes: S11. Solidify the design standards and specifications in an Excel worksheet to obtain the control parameters for automatic parametric design input; S12. Write the control parameters in an Excel worksheet according to the set writing syntax, so that the values ​​of the control parameters are dynamically linked with the transformer calculation sheet, design standards and specifications to generate an Excel file; when the transformer model changes, the control parameters are automatically updated.

[0049] It should be noted that the Excel file contains a control parameter sheet, a structural principle sheet that defines the core type and lamination rules, a transformer calculation parameter sheet that stores electrical parameters, a product information sheet that records identification information, and a material selection sheet. The control parameters include transformer model, core lamination parameters, and silicon steel sheet brand.

[0050] In the embodiment of the present invention, the control parameter writing syntax is as follows: Version Introduction: <xml version="1.0" encoding="UTF-8"> Program header: <creoparamset> Middle of the program: parameter definition module End of program:< / creoparamset> The "parameter definition module" in the middle of the program is a module that defines the name, type, value, and description of parameters. There are four parameter types: real number, integer, string, and boolean. This application proposes the code syntax for these four types: The control parameters are defined through the following preset writing syntax: Real number type: <real Name="参数名称" Value="数值" Description="说明" / > ; The code syntax for the real number type is as follows: Parameter module header: <parameter name="参数名"> Parameter module middle: <value> Numerical< / value> <description> illustrate< / description> Parameter module tail:< / parameter> Integer type: <integer Name="参数名称" Value="数值" Description="说明" / > ; The code syntax for the integer type is as follows:<00已翻译至59行,共63行Parameter module header: <Parameter Namo = "Parameter name" In the middle of the parameter module: <datatype> Integer< / datatype> <value> Numerical< / value> <description> illustrate< / description> Parameter module tail: String type: <string Name="参数名称" Value="数值" Description="说明" / > ; The code syntax for the string type is as follows: Parameter module header: <Parameter Name = "Parameter name" In the middle of the parameter module: <datatype> String< / datatype> <value> Numerical< / value> <description> illustrate< / description> Parameter module tail: Boolean type: <boolean Name="参数名称" Value="数值" Description="说明" / > .

[0051] The code syntax for the boolean type is as follows: Parameter module header: <parameter name="参数名"> Parameter module middle: <datatype> Boolean< / datatype> <value> Numerical< / value> <description> illustrate< / description> Parameter module tail:< / parameter> Write the control parameters into the corresponding cells of the Excel worksheet according to the preset writing syntax. Use the formula and function functions of Excel to establish a dynamic link between the values of the control parameters and the transformer calculation book, design standards, and specifications. For example, when the transformer model changes, the relevant control parameters are automatically updated through the VLOOKUP function.

[0052] Create a control parameter sheet page in Excel to centrally manage key control parameters such as transformer model, core lamination parameters, and silicon steel sheet brand. Create a structural principle sheet page that defines the core type and lamination rules, and record in detail the core type (such as three-phase three-column, three-phase five-column) and lamination rules (such as lamination method, lamination thickness, etc.). Create a transformer calculation single parameter sheet page to store electrical parameters, including winding resistance, reactance, no-load loss and other parameters. Create a product information sheet page to record identification information, including product number, production date, customer information, etc. Create a material selection sheet page to list the various materials used in the transformer (such as silicon steel sheets, insulation materials, etc.) and their models and specifications.

[0053] S2. Export the control parameters in the Excel worksheet as an XML file; this step specifically includes: creating a Notepad file named Total Parameter Table, copying the contents of the Control Parameter Sheet page in the Excel file to Total Parameter Table.txt, and changing the suffix txt to XML, thus forming a Total Parameter Table.XML file.

[0054] S3. Create a notepad file in the automated design software and import the control parameters in the XML file; this step specifically includes: creating a core parameter .lay notepad file in the automated design software, and importing the parameter name, type, value, and description information of the total parameter table .XML into the corresponding parameters of the core parameter .lay.

[0055] S4. Based on the imported control parameters, parametric modeling is performed in the automated design software to generate a three-dimensional model of the transformer; S5. Automatically generate a two-dimensional engineering drawing of the transformer based on the three-dimensional model.

[0056] In this embodiment of the present invention, a table is constructed in an Excel worksheet based on common transformer industry design standards (such as GB1094) and internal company specifications. For real number parameters (such as the transformer's turns ratio), the syntax is set to directly enter the numeric value, accurate to several decimal places. Integer parameters (such as the number of winding turns) are entered directly as integers; string parameters (such as the transformer model) are entered as corresponding strings; and Boolean parameters (such as whether a special cooling method is used) are represented by "TRUE" or "FALSE." Excel's data export function is used to save the control parameters in XML format. When exporting, ensure that the XML file is clearly structured and accurately displays the parameter name, type, and value. Open the automated design software (Creo Parametric 3D design software (hereinafter referred to as Creo)) and create a Notepad file. Using the software's import function, import the control parameters from the XML file into the corresponding parameter locations in the Notepad file. Create a new part file in the automated design software. Based on the imported control parameters, perform parametric modeling using the software's modeling tools. For example, the core shape and size are determined based on the core lamination parameters, and the winding structure is determined based on the number of turns. After the 3D model is constructed, the automated design software's drawing generation function automatically generates 2D engineering drawings of the transformer by selecting the appropriate view and scale.

[0057] In some embodiments, the step of performing parametric modeling in automated design software based on the imported control parameters to generate a three-dimensional model of the transformer includes the following steps: Create a part file in the automation design software and declare a notebook file to reference the control parameters; According to the structural selection conditions in the control parameters, a three-phase three-column or three-phase five-column core structure 3D model is automatically generated.

[0058] The structure selection condition is a Boolean parameter, and a three-phase five-pillar iron core structure or a three-phase three-pillar iron core structure is generated according to the parameter value; the Boolean parameter is whether it is a three-phase five-pillar structure. In some embodiments, automatically generating a two-dimensional engineering drawing of the transformer based on the three-dimensional model includes: Define drawing parameters in the 3D model, including drawing number, product model, material name and core structure; In a two-dimensional engineering drawing, the drawing parameters are referenced through text expressions to achieve automatic filling of drawing information.

[0059] This paper proposes a parametric transformer design method that utilizes Creo Parametric 3D design software (hereinafter referred to as Creo) in conjunction with Excel worksheets to automatically design 3D transformer models and 2D engineering drawings. This simple and easy-to-understand application allows designers to automatically create parametric drawings without any secondary development.

[0060] First, solidify the design standards and specifications in Excel to derive the "control parameters" for automated parametric design input. These "control parameters" are written in Excel using the syntax and formulas specified in this application to facilitate parametric drive. The "control parameters" in Excel are then entered into an XML file.

[0061] Secondly, create a notepad in Creo and import the control parameters in the XML file.

[0062] Finally, Creo was used for parametric modeling and two-dimensional engineering drawings.

[0063] (1) First, solidify the design standards and specifications in Excel. The created Excel file is named "Transformer Design Calculation Table.XLSX". This application does not elaborate on this step.

[0064] (2) Define the "control" parameters in the "Transformer Design Calculation Sheet.XLSX" and link their values ​​to the transformer calculation sheet, design standards, and specifications. When the transformer model changes, the values ​​of the "control parameters" will also be automatically updated. The details are as follows: <xml version="1.0" encoding="UTF-8"> <creoparamset> <parameter name="是否三相五柱式"> <datatype> Boolean< / datatype> <value> no< / value> The Excel formula is: =CONCATENATE(" <value> ",Structural principle!B1, "< / value> ") <description> core< / description> < / parameter> <parameter name="HW"> <datatype> Integer< / datatype> <value> 500< / value> The Excel formula is: =CONCATENATE(" <value> ", Transformer calculation single parameter! B1, "< / value> ") <description> core< / description> < / parameter> <parameter name="MO"> <datatype> Integer< / datatype> <value> 485< / value> <description> core< / description> < / parameter> <parameter name="MI"> <datatype> Integer< / datatype> <value> 365< / value> The Excel formula is: =CONCATENATE(" <value> ", Transformer calculation single parameter! B3, "< / value> ") <description> core< / description> < / parameter> <parameter name="变压器型号"> <datatype> String< / datatype> <value> S11-3150 / 35< / value> The Excel formula is: =CONCATENATE(" <value> ",Product Information!B1,"< / value> "> <description> Shared< / description> < / parameter> <parameter name="叠厚1"> <value> 45.5< / value> The Excel formula is: =CONCATENATE(" <value> ", Transformer calculation single parameter! B5,"< / value> ") <description> core< / description> < / parameter> <parameter name="图号"> <datatype> String< / datatype> <value> 560321< / value> The Excel formula is: =CONCATENATE(" <value> ",Product Information!B2, "< / value> ") <description> Shared< / description> < / parameter> <parameter namo="片宽1"> <datatype> Integer< / datatype> <value> 245< / value> The Excel formula is =CONCATENATE{" <value> ", Transformer calculation single parameter! B4, "< / value> ") <description> core< / description> < / parameter> <parameter name="硅钢片牌号"> <datatype> String< / datatype> <value> 30Q120< / value> The Excel formula is: =CONCATENATE(" <value> ",Material selection!B1, "< / value> ") <description> core< / description> < / parameter> < / creoparamset> What needs to be explained in the above code is that <value>< / value> Formulas are required for parameter assignment rows, but not for other items. "Structural Principles!", "Transformer Calculation Parameters!", "Product Information!", and "Material Modeling!" are Sheet pages in the Excel file. "Structural Principles!" B1 represents cell B1 on the "Structural Principles" sheet page, which contains information about the design principle, including whether the core is a three-phase, five-column type. The same applies to other cells. (3) Create a new Notepad file and name it "Total Parameter Table". Copy the contents of the "Control Parameters" sheet in Excel to "Total Parameter Table.txt". After saving, change the suffix "txt" to "XML". This will create a "Total Parameter Table.XML" file.

[0065] (4) Use Creo software to create a "core parameter.lay" notepad file, and import the parameter name, type, value, and description information of the "total parameter table.XML" into the parameter.

[0066] (5) Create a new part "iron core.prt". The design steps are as follows: 1) Declare the "Core Parameters" notepad in the part to reference the parameters in "Core Parameters.lay" in "Core Sheet.prt".

[0067] 2) Three-phase three-column structure design (a) Three-phase three-column iron yoke design Use the "TOP" surface as the reference surface, create a sketch, name it "Three-phase three-column iron yoke - sketch", and draw the iron yoke graphics as follows Figure 2 As shown, write the following relationship in "Relationship": / *Three-phase three-column iron yoke D5=M0 D7=sheet width 1 D4=sheet width 1 D6=HW D3=45 Use the sketch "Three-phase three-column iron yoke piece-sketch" to extrude it into a solid and name it "Three-phase three-column iron yoke piece-solid". Figure 3 As shown, write the relational expression in "Relation": D19=Stack 1 (b) Three-phase three-column core-column design Use the "TOP" surface as the reference surface, create a sketch, and use the projection method to create a "three-phase three-column core column piece - sketch" sketch. Figure 4 shown.

[0068] Use the sketch of "Three-phase three-column core column piece - sketch" to extrude it into a solid and name it "Three-phase three-column iron yoke piece - solid". Figure 5 Depth is extruded to the selected surface.

[0069] 3) Three-phase five-column structure design (a) Three-phase five-pillar core-pillar design Use the "TOP" surface as the reference surface, create a sketch, name it "Three-phase five-column core column piece - sketch", and draw the core column piece graphics as shown below Figure 6 As shown, write the following relationship in "Relationship": / *Three-phase five-pillar core piece D9=HW D10 = slice width 1 D12=M0 D8=45 Use the sketch of "Three-phase five-column core column piece-sketch" to extrude it into a solid and name it "Three-phase three-column core column piece-solid". Figure 7 As shown. In "Relationship", write the relational expression: D28=Stack 1 (b) Design of three-phase five-column iron yoke 1 Use the "TOP" surface as the reference surface, create a sketch, use projection for some parts, and mark the dimensions for others, and create a "Three-phase five-column iron yoke 1-Sketch" sketch. Figure 8 As shown, write the following relationship in "Relationship": / *Three-phase five-pillar core piece IF 1 / 2-CEIL(1 / 2)<>0 / * Ensure the yoke width is an integer multiple of 5 D14=CEIL((sheet width 1*0.57-sheet width 1*0.5) / 2.5)*2.5 ELSE D14=CEIL((sheet width 1*0.57-sheet width 1*0.5) / 5)*5 ENDIF D13=M1 Use the sketch "Three-phase five-column iron yoke piece 1-sketch" to extrude it into a solid and name it "Three-phase five-column iron yoke piece 1-solid". Figure 9 As shown, the depth is extruded to the selected surface.

[0070] (c) Design of three-phase five-column iron yoke 2 Use the "TOP" surface as the reference surface to create a sketch. Use projection for some parts and constraint drawing for others. Create the "Three-phase five-column iron yoke 2-sketch" sketch as shown below: Figure 10 shown.

[0071] Use the sketch "Three-phase five-column iron yoke piece 2-sketch" to extrude it into a solid and name it "Three-phase five-column iron yoke piece 2-solid". Figure 11 As shown, the depth is extruded to the selected surface.

[0072] d) Three-phase five-column side yoke design Use the "TOP" surface as the reference surface, create a sketch, and name it "Three-phase five-column side yoke-sketch". Figure 12 shown.

[0073] Use the sketch "Three-phase five-column side yoke-sketch" to extrude it into a solid and name it "Three-phase five-column side yoke-solid". Figure 13 Depth is extruded to the selected surface.

[0074] 4) Core structure selection and design This application uses two structures as examples. When the parameter "Is it three-phase five-leg" is equal to "YES", the core structure is three-phase five-leg. When it is equal to "NO", the core structure is three-phase three-leg. The operation is as follows: Using the built-in "Program" in Creo, edit the design and open "Core Lamination.pls." Find the corresponding program segments for "Three-Phase Three-Pole Iron Yoke - Sketch," "Three-Phase Three-Pole Iron Yoke - Solid," "Three-Phase Three-Pole Core Lamination - Sketch," and "Three-Phase Three-Pole Core Lamination - Solid." Add the following select statement: IF is it three-phase five-column type == NO / *Realize the design of three-phase three-column structure of core sheet "Three-phase three-column iron yoke - sketch" program segment "Three-phase three-column iron yoke-entity" program segment "Three-phase three-column core column - sketch" level "Three-phase three-column core column piece-entity" program segment END IF Find the program segments corresponding to "Three-phase five-pillar core-pillar piece - sketch", "Three-phase five-pillar core-pillar piece - entity", "Three-phase five-pillar iron yoke piece 1 - sketch", "Three-phase five-pillar iron yoke piece 1 - entity", "Three-phase five-pillar iron yoke piece 2 - sketch", "Three-phase five-pillar iron yoke piece 2 - entity", "Three-phase five-pillar side yoke - sketch", and "Three-phase five-pillar side yoke - entity". Add the selection statement as follows: IF is it three-phase five-leg structure == YES / *Realize the design of three-phase five-leg structure of core sheet "Three-phase five-column core column - sketch" program segment "Three-phase five-column core column piece-entity" program segment "Three-phase five-column iron yoke 1-sketch" program segment "Three-phase five-column iron yoke 1-entity" program segment "Three-phase five-column iron yoke 2-sketch" program segment "Three-phase five-column iron yoke 2-entity" program segment "Three-phase five-column side yoke-sketch" program segment "Three-phase five-column side yoke-solid" program segment END IF 5) Modify the parameter values ​​in "CoreParameters.lay" or modify "Transformer Design Calculation Spreadsheet.XLSX" and import it into "CoreParameters.lay" according to the previous steps to change the "Control Parameters" values. Refresh the "CoreLayer.prt" part to complete the parametric modification of the 3D model.

[0075] (6) Create a new drawing "iron core sheet.drw" and design the engineering drawing. The design steps are as follows: 1) In the relationship of "iron core sheet.prt", write the model drawing parameters and their values: Drawing number = "5SDEE.640." + drawing number + ".1" / * Drawing number assignment Product model = transformer model / * product model assignment Material name = silicon steel sheet brand / * core material name assignment If is it a three-phase five-column type == YES Core structure = "three-phase five-column" else Core structure = "three-phase three-column" endif Write the text expressions in the corresponding positions in the engineering drawing: (1): &Core structure; (2): &Product model; (3): &Material name; (4): &Drawing number. The generated engineering drawing is as follows. When the parameter is set to three-phase three-column, the output engineering drawing is a three-phase three-column core drawing. When the parameter is set to three-phase five-column, the output engineering drawing is a three-phase five-column core drawing.

[0076] like Figure 14 As shown, an embodiment of the present invention further provides a transformer parametric design device, including a parameter definition module, a parameter conversion module, a parameter import module, a modeling module and a drawing module; The parameter definition module is used to solidify the transformer design standards and specifications in an Excel worksheet and define control parameters through a set writing syntax; the control parameters include four types: real number, integer, string, and Boolean; each parameter type has a writing syntax; Parameter conversion module, used to export the control parameters in the Excel worksheet into an XML file; A parameter import module is used to create a notepad file in the automation design software and import the control parameters in the XML file; Modeling module, used to perform parametric modeling in the automated design software based on the imported control parameters to generate a three-dimensional model of the transformer; A drawing module is used to automatically generate a two-dimensional engineering drawing of the transformer based on the three-dimensional model.

[0077] In some embodiments, the parameter definition module includes a control parameter acquisition submodule and a parameter definition submodule; The control parameter acquisition submodule is used to solidify the design standards and specifications in the Excel worksheet and obtain the control parameters for automatic parametric design input; The parameter definition submodule is used to write the control parameters in an Excel worksheet according to the set writing syntax, so that the control parameter values ​​are dynamically linked with the transformer calculation book, design standards and specifications to generate an Excel file; when the transformer model changes, the control parameters are automatically updated.

[0078] In some embodiments, the Excel file includes a control parameter sheet, a structural principle sheet defining the core type and lamination rules, a transformer calculation parameter sheet storing electrical parameters, a product information sheet recording identification information, and a material selection sheet. The control parameters include transformer model, core lamination parameters, and silicon steel sheet brand.

[0079] In some embodiments, the parameter conversion module is specifically used to create a notepad file named total parameter table, copy the content of the control parameter Sheet page in the Excel file to total parameter table.txt, and modify the suffix txt to XML, thereby forming a total parameter table.XML file.

[0080] In some embodiments, the parameter import module is specifically used to create a core parameter .lay notepad file in the automated design software, and import the parameter name, type, value, and description information of the total parameter table .XML into the corresponding parameters of the core parameter .lay.

[0081] In some embodiments, the modeling module includes a declaration submodule and a three-dimensional model generation submodule; Declare submodule, used to create part files in automated design software and declare notepad files to reference control parameters; The three-dimensional model generation submodule is used to automatically generate a three-dimensional model of a three-phase three-column or three-phase five-column core structure according to the structure selection conditions in the control parameters.

[0082] The structure selection condition is a Boolean parameter, and a three-phase five-pillar iron core structure or a three-phase three-pillar iron core structure is generated according to the parameter value; the Boolean parameter is whether it is a three-phase five-pillar structure. In some embodiments, the drawing module includes a parameter definition submodule and a drawing generation submodule; The parameter definition submodule is used to define drawing parameters in the 3D model, including drawing number, product model, material name and core structure; The drawing generation submodule is used to reference the drawing parameters through text expressions in the two-dimensional engineering drawing to achieve automatic filling of drawing information.

[0083] An embodiment of the present invention further provides an electronic device comprising: a processor, a communication interface, a memory, and a communication bus, wherein the processor, the communication interface, and the memory communicate with each other via the communication bus. The communication bus can be used to transmit information between the electronic device and the sensor. The processor can call logic instructions in the memory to execute the following method: S1. Solidify the transformer design standards and specifications in an Excel worksheet, and define control parameters using a set writing syntax; the control parameters include four types: real number, integer, string, and Boolean; a writing syntax is set for each parameter type; S2. Export the control parameters in the Excel worksheet as an XML file; S3. Create a notepad file in the automated design software and import the control parameters in the XML file; S4. Based on the imported control parameters, perform parametric modeling in the automated design software to generate a three-dimensional model of the transformer; S5. Automatically generate a two-dimensional engineering drawing of the transformer based on the three-dimensional model.

[0084] In addition, the logic instructions in the above-mentioned memory can be implemented in the form of software functional units and can be stored in a computer-readable storage medium when sold or used as an independent product.

[0085] An embodiment of the present invention provides a non-transitory computer-readable storage medium, which stores computer instructions, and the computer instructions enable a computer to execute the method provided by the above method embodiment, for example, including: S1, solidifying the transformer design standards and specifications in an Excel worksheet, and defining control parameters through a set writing syntax; the control parameters include four types: real number type, integer type, string type and Boolean type; a writing syntax is set for each parameter type; S2, exporting the control parameters in the Excel worksheet as an XML file; S3, creating a notepad file in the automated design software, and importing the control parameters in the XML file; S4, based on the imported control parameters, performing parametric modeling in the automated design software to generate a three-dimensional model of the transformer; S5, automatically generating a two-dimensional engineering drawing of the transformer based on the three-dimensional model.

[0086] It should be understood that the size of the serial numbers of the steps in the above embodiments does not mean the order of execution. The execution order of each process should be determined by its function and internal logic, and should not constitute any limitation on the implementation process of the embodiments of the present invention.

[0087] The above description of the disclosed embodiments is intended to enable one skilled in the art to implement or use the present invention. Various modifications to these embodiments will be readily apparent to one skilled in the art, and the general principles defined herein may be implemented in other embodiments without departing from the spirit or scope of the present invention. Therefore, the present invention is not limited to the embodiments shown herein but is intended to conform to the widest scope consistent with the principles and novel features disclosed herein.< / xml> < / xml>

Claims

1. A transformer parameter design method, characterized in that: The steps include: Solidify the transformer design standards and specifications in an Excel worksheet, and define control parameters through a set writing syntax; the control parameters include four types: real number, integer, string, and Boolean; each parameter type is defined with a writing syntax; Export the control parameters in the Excel worksheet as an XML file; Create a notepad file in the automation design software and import the control parameters in the XML file; Based on the imported control parameters, parametric modeling is performed in the automated design software to generate a three-dimensional model of the transformer; A two-dimensional engineering drawing of the transformer is automatically generated based on the three-dimensional model.

2. The transformer parameter design method according to claim 1, characterized in that: The steps for solidifying transformer design standards and specifications in an Excel worksheet and defining control parameters using a predefined syntax include: Solidify design standards and specifications into Excel worksheets to obtain control parameters for automatic parametric design input; The control parameters are written in an Excel worksheet according to the set writing syntax, so that the values ​​of the control parameters are dynamically linked with the transformer calculation sheet, design standards and specifications to generate an Excel file; when the transformer model changes, the control parameters are automatically updated.

3. The transformer parameter design method according to claim 2, characterized in that: The Excel file contains a control parameter sheet, a structural principle sheet that defines the core type and lamination rules, a transformer calculation parameter sheet that stores electrical parameters, a product information sheet that records identification information, and a material selection sheet. The control parameters include transformer model, core lamination parameters, and silicon steel sheet brand.

4. The transformer parameter design method according to claim 3, characterized in that: The steps to export the control parameters in the Excel worksheet to an XML file include: Create a Notepad file named Total Parameter Table, copy the contents of the Control Parameter Sheet page in the Excel file to Total Parameter Table.txt, and change the suffix txt to XML to form the Total Parameter Table.XML file.

5. The transformer parameter design method according to claim 4, characterized in that: The steps of creating a notepad file in the automation design software and importing the control parameters in the XML file include: Create a core parameter .lay notepad file in the automated design software, and import the parameter name, type, value, and description information of the total parameter table .XML into the corresponding parameters in the core parameter .lay.

6. The transformer parameter design method according to claim 5, characterized in that: Based on the imported control parameters, parametric modeling is performed in the automated design software to generate a three-dimensional model of the transformer. The parametric modeling includes the following steps: Create a part file in the automation design software and declare a notebook file to reference the control parameters; According to the structural selection conditions in the control parameters, a three-phase three-column or three-phase five-column core structure 3D model is automatically generated.

7. The transformer parameter design method according to claim 6, characterized in that: The structure selection condition is a Boolean parameter, and a three-phase five-pillar iron core structure or a three-phase three-pillar iron core structure is generated according to the parameter value; the Boolean parameter is whether it is a three-phase five-pillar structure.

8. The transformer parameter design method according to claim 7, characterized in that: Automatically generating a two-dimensional engineering drawing of the transformer based on the three-dimensional model includes: Define drawing parameters in the 3D model, including drawing number, product model, material name and core structure; In a two-dimensional engineering drawing, the drawing parameters are referenced through text expressions to achieve automatic filling of drawing information.

9. A transformer parameter design device, characterized in that: It includes parameter definition module, parameter conversion module, parameter import module, modeling module and drawing module; The parameter definition module is used to solidify the transformer design standards and specifications in an Excel worksheet and define control parameters through a set writing syntax; the control parameters include four types: real number, integer, string, and Boolean; each parameter type has a writing syntax; Parameter conversion module, used to export the control parameters in the Excel worksheet into an XML file; A parameter import module is used to create a notepad file in the automation design software and import the control parameters in the XML file; Modeling module, used to perform parametric modeling in the automated design software based on the imported control parameters to generate a three-dimensional model of the transformer; A drawing module is used to automatically generate a two-dimensional engineering drawing of the transformer based on the three-dimensional model.

10. An electronic device, characterized in that: The electronic device includes: at least one processor; and a memory communicatively connected to the at least one processor; the memory stores computer program instructions executable by the at least one processor, and the computer program instructions are executed by the at least one processor to enable the at least one processor to perform the transformer parameterized design method according to any one of claims 1 to 8.

Images