Total element parameterized model design method based on Excel and low code

Abstract

The invention relates to a total element parameterization model design method based on Excel and low codes, which deeply explores the potential of low-code rules, not only applies internal rules, but also ingeniously combines external rules to form a set of complete rule system. In order to improve the design efficiency, the function of injecting low-code rules into similar models in batches is innovatively realized. It means that a designer can apply the rule to a plurality of similar or same models only by defining the rule once, and time and energy are greatly saved. Meanwhile, the reusability of the rule also enhances the consistency and reliability of the design. The invention further provides editing and managing functions of the low-code rules, so that the user can customize and modify the rules according to actual requirements. The function greatly enhances the flexibility and adaptability of the design, so that a designer can quickly adjust rules at any time according to changing requirements, and the accuracy and high efficiency of the design are ensured.

Description

Technical Field

[0001] The present invention belongs to the field of model design methods, and specifically relates to a full-factor parametric model design method based on Excel and low code. Background Art

[0002] The existing technical solutions mainly rely on traditional manual design methods, which have the following characteristics when implemented:

[0003] 1. Adjustment of design elements: In the existing technical solutions, designers need to manually adjust the size, quantity, position and other design elements of the equipment. There are no parameters and logical associations between these elements. When a place is modified, the corresponding place cannot be linked. This process is not only time-consuming and labor-intensive, but also prone to errors. Once a design element is improperly adjusted, the entire design process may need to be redone, which increases design costs and time.

[0004] 2. Design of non-standard parts and standard parts: In the existing technical solutions, the design of non-standard parts and standard parts lacks linkage. This means that when designers design non-standard parts, they cannot directly use the design elements or parameters of standard parts, resulting in low efficiency in the reuse of similar elements and the duplication design of similar equipment.

[0005] 3. Model replication design: Existing technical solutions often encounter various problems in the process of model replication design. For example, designers cannot accurately identify reuse and replication design elements, resulting in redundancy in the model library.

[0006] 4. Engineering drawing and material list: In the existing technical solutions, the material list of engineering drawing is filled in manually, the material specifications cannot be linked with the model's external dimensions, and the inaccurate weight parameter technology leads to cost deviation.

[0007] Specifically, for example, in patent US20180232651A1, he mentioned Autodesk as a parametric design tool, but the design relies on manual adjustment of parameters and lacks a real-time linkage mechanism. Another example is the application of low-code platforms in industrial design in CN110032571A, but dynamic data binding with Excel is not implemented, and the adjustment efficiency of design elements is low (manual operation is required one by one). At the same time, the design of non-standard parts and standard parts lacks linkage, and the material table of engineering drawings relies on manual filling, which is prone to errors. Summary of the invention

[0008] In response to the above problems, the present invention proposes a full-factor parametric model design method based on Excel and low code.

[0009] The present invention adopts the following technical solutions:

[0010] A full-element parametric model design method based on Excel and low-code, comprising the following steps:

[0011] Step 1, system preparation and environment setup;

[0012] Step 2, parameter definition and Excel table setting, specifically including the following steps:

[0013] Step 2.1, define the key design parameters of non-standard equipment and the alternative models and parameters of standard equipment in the Excel table, set a unique identifier and a descriptive name for each parameter, and ensure that the naming and format of the parameters match the requirements of Autodesk software and the low-code module;

[0014] Step 2.2, determine whether the parameter is of direct definition type or associated type. If it is of direct definition type, the designer directly fills in the value. If it is of associated type, use the function formula of Excel to establish the relationship and calculation logic between parameters;

[0015] Step 2.3, set data validation rules for parameters to ensure that the input data is within a reasonable range;

[0016] Step 3, use the low-code plugin to write intelligent logic rule code, and based on the parameter values or function formulas in the Excel table, adjust and control the design elements of the model;

[0017] Step 4, apply the written low-code to the parametric model in Autodesk software, ensure that the code can correctly read the parameter values in the Excel table, and adjust the model according to the intelligent logic rules;

[0018] Step 5, modify the parameter values in the Excel table, observe the changes in the model in Autodesk software, ensure that the adjustment of the model meets the expectations, and the low-code can be correctly executed. Use the tools provided by Autodesk software for design verification, optimize the design according to the verification results, and adjust the parameters to meet the design requirements;

[0019] Step 6, export the design result as a CAD drawing, engineering drawing or other format files, and ensure that the exported files contain all necessary design information and annotations.

[0020] Further, the specific steps of the said Step 3 include the following steps:

[0021] Step 3.1: In low-code, use the "ilogic" function to link the parameters in the Excel table with the corresponding design elements in the Autodesk software. When the parameters in the Excel table change, the design elements in the Autodesk software will be updated accordingly. The standard device models in the input model can automatically find the corresponding column numbers in the Excel table to obtain the dimension series, realizing the update of the model.

[0022] Step 3.2: Utilize the low-code programming environment to write intelligent design rules, which can automatically adjust the design elements based on the parameter values and function formulas in the Excel table.

[0023] Furthermore, in Step 3, a conflict detection mechanism is set in the low-code. When conflicts occur in the association relationships between design elements, the system will automatically prompt and provide solutions.

[0024] After the present invention adopts the above technical solutions, compared with the prior art, it has the following advantages:

[0025] The present invention deeply explores the potential of low-code rules. It not only applies internal rules but also cleverly combines external rules to form a complete set of rule systems. To improve design efficiency, the present invention innovatively realizes the function of batch injecting low-code rules into similar models. This means that designers only need to define the rules once and can apply them to multiple similar or identical models, greatly saving time and effort. At the same time, the reusability of the rules also enhances the consistency and reliability of the design. The present invention also provides the editing and management functions of low-code rules, enabling users to customize and modify the rules according to actual needs. This function greatly enhances the flexibility and adaptability of the design, enabling designers to quickly adjust the rules according to changing needs at any time to ensure the accuracy and efficiency of the design.

[0026] The following will describe the present invention in detail with reference to the accompanying drawings and embodiments. Description of the Drawings

[0027] Figure 1 is the system framework schematic diagram of the present invention;

[0028] Figure 2 is the method flow schematic diagram of the present invention;

[0029] Figure 3 is the motor parameter diagram of Embodiment 1;

[0030] Figure 4 is the motor model diagram of Embodiment 1;

[0031] Figure 5 is the pipeline parameter diagram of Embodiment 2. Detailed Embodiments

[0032] The principles and features of the present invention will be described below in conjunction with the accompanying drawings. The examples given are only used to explain the present invention and are not intended to limit the scope of the present invention.

[0033] The system framework of the present invention is as Figure 1 shown, and the flowchart of the implementation steps is as Figure 2 shown.

[0034] The specific implementation steps of the present invention are as follows:

[0035] 1. System preparation and environment setup

[0036] Software configuration: Ensure that Autodesk software that supports parametric and intelligent design, such as Excel or Inventor, has been installed. These software provide the basic environment for parametric design.

[0037] Data management tool preparation: Create an Excel table for storing and managing the parameters of design elements. The table should include columns for key design parameters such as equipment dimensions, quantity, location, etc.

[0038] 2. Parameter definition and Excel table settings

[0039] Parameter definition: Define the key design parameters of non-standard equipment in the Excel table. Set a unique identifier (such as ID) and a descriptive name for each parameter, and ensure that the naming and format of the parameters match the requirements of Autodesk software and the low-code module. For example, define the dimensions of components (such as length L, width W, height H) in Excel.

[0040] Establish parameter relationships: Use the functions and formulas in Excel to establish the relationships and calculation logics between parameters. For example, if a certain dimension of the equipment is a function of other dimensions, the corresponding formula can be set in Excel.

[0041] Data verification: Set data verification rules for parameters to ensure that the input data is within a reasonable range. If the input motor model is incorrect and the corresponding value cannot be found in Excel, the model parameters cannot be obtained, and an error will be prompted.

[0042] 3. Write and apply low-code

[0043] Use the low-code plugin to write intelligent logic rule codes. These rules will control the adjustment of design elements such as the dimensions, quantity, and location of the model based on the parameter values in the Excel table.

[0044] Parameter Linking: In low-code, use the "ilogic" function to link parameters in an Excel spreadsheet to design elements (such as dimensions, quantities, positions, etc.) in Autodesk software. In this way, when the parameters in the Excel spreadsheet change, the design elements in Autodesk software will also be updated accordingly.

[0045] At the same time, according to the modification of the model number in the model, it can automatically find the corresponding column number in the Excel spreadsheet to obtain the dimension series and realize the update of the model.

[0046] Rule Writing: Use the low-code programming environment to write intelligent design rules. These rules can automatically adjust the dimensions, quantities, positions, etc. of design elements based on the parameters and logical relationships in the Excel spreadsheet.

[0047] Automated Design Process: Through the automated design process function of low-code, break down the design process into a series of steps and tasks. These steps and tasks can be automatically executed based on the parameters in the Excel spreadsheet and low-code rules, thus realizing the automation and intelligence of the design.

[0048] Conflict Detection and Resolution: Set up a conflict detection mechanism in low-code. When conflicts occur in the association relationships between design elements, the system will automatically prompt and provide solutions. This can ensure the accuracy and consistency of the design.

[0049] 4. Parametric Design Process of Autodesk Software

[0050] Apply the written low-code to the parametric model in Autodesk software. Ensure that the code can correctly read the parameter values in the Excel spreadsheet and adjust the model according to the intelligent logic rules.

[0051] 5. Design Verification and Testing

[0052] Modify the parameter values in the Excel spreadsheet and observe the changes in the model in Autodesk software. Ensure that the adjustment of the model meets the expectations and that the low-code can be correctly executed. Use the tools provided by Autodesk software for design verification, such as geometric inspection, interference inspection, etc. Optimize the design according to the verification results and adjust the parameters to meet the design requirements.

[0053] 6. Output Design Results

[0054] Export the design results to CAD drawings, engineering drawings, or other format files. Ensure that the exported files contain all necessary design information and annotations.

[0055] Example 1: Intelligent Design Based on Motors

[0056] 1. System Preparation and Environment Setup

[0057] Software Configuration:

[0058] Autodesk Inventor 2023 (iLogic function enabled)

[0059] Microsoft Excel (version 2019+)

[0060] 2. Parameter Definition and Excel Sheet Settings

[0061] Define parameters: Define the key design parameters of the motor in the Excel sheet as shown in Table 1 below:

[0062] Table 1

[0063]

[0064] Table 1 shows multiple motor parameters, including dimensions and mass. For example, various dimension parameters, as well as the motor model and total mass Motor_mass.

[0065] Establish parameter relationships: Define the external shape parameters in Inventor and create the required driving parameters, as Figure 3 、 4 shown:

[0066] As Figure 4 shown, create a motor model, define the motor sketch dimensions with parameters, and create the parameters not shown in the product sample by associating with existing parameters.

[0067] Figure 4 In it: fx:d4 = Motor_AC / 2ul means setting the parameter d4 to half of the Motor_AC parameter, with the unit of millimeters (ul).

[0068] 3. Write and Apply Low-Code (Inventor iLogic Script):

[0069] i = GoExcel.FindRow("Selection Table.xlsx", "Motor Parameter Table", "Motor Model", "=", motor model)

[0070] Motor_A = GoExcel.CurrentRowValue("Motor_A")

[0071] Motor_AA = GoExcel.CurrentRowValue("Motor_AA")

[0072] Motor_AB = GoExcel.CurrentRowValue("Motor_AB")

[0073] Motor_AC = GoExcel.CurrentRowValue("Motor_AC")

[0074] Motor_B = GoExcel.CurrentRowValue("Motor_B")

[0075] Motor_BB = GoExcel.CurrentRowValue("Motor_BB")

[0076] Motor_C = GoExcel.CurrentRowValue("Motor_C")

[0077] Motor_D = GoExcel.CurrentRowValue("Motor_D")

[0078] Motor_E = GoExcel.CurrentRowValue("Motor_E")

[0079] Motor_F = GoExcel.CurrentRowValue("Motor_F")

[0080] Motor_G = GoExcel.CurrentRowValue("Motor_G")

[0081] Motor_GD = GoExcel.CurrentRowValue("Motor_GD")

[0082] Motor_H = GoExcel.CurrentRowValue("Motor_H")

[0083] Motor_HA = GoExcel.CurrentRowValue("Motor_HA")

[0084] Motor_K = GoExcel.CurrentRowValue("Motor_K")

[0085] Motor_L = GoExcel.CurrentRowValue("Motor_L")

[0086] Motor_LA = GoExcel.CurrentRowValue("Motor_LA")

[0087] Motor_M = GoExcel.CurrentRowValue("Motor_M")

[0088] Motor_N = GoExcel.CurrentRowValue("Motor_N")

[0089] Motor_P = GoExcel.CurrentRowValue("Motor_P")

[0090] Motor_S = GoExcel.CurrentRowValue("Motor_S")

[0091] Motor_T = GoExcel.CurrentRowValue("Motor_T")

[0092] Motor_mass = GoExcel.CurrentRowValue("Motor_mass")

[0093] iProperties.Mass = Motor_mass

[0094] This code snippet links the motor parameters in the Excel spreadsheet to the design elements (such as dimensions) in the Autodesk software and applies these parameters to the iProperties in the Inventor model. In this way, when the parameters in the Excel spreadsheet change, the design elements in the Autodesk software will also be updated accordingly. For example, the line of code Motor_A = GoExcel.CurrentRowValue("Motor_A") means to obtain the value of Motor_A from the current row of Excel and assign it to the variable Motor_A. The last line iProperties.Mass = Motor_mass sets the mass property of the motor to the value obtained from Excel.

[0095] If the motor model 225s1-6 is selected, all the model parameters are read as the parameters of the motor 225s1-6, and the parameter linking is completed.

[0096] 4. Autodesk Software Parametric Design Process

[0097] Apply the written low-code to the parametric model in the Autodesk software.

[0098] 5. Design Verification and Testing

[0099] Modify the parameter values in the Excel spreadsheet and observe the changes in the model in the Autodesk software. For example, when Motor_AC in Excel is changed from 470 mm to 500 mm:

[0100] The installation hole spacing d4 is automatically updated to 250 mm

[0101] The base length Motor_E is synchronously updated to 700 mm

[0102] The rib height Motor_L is automatically calculated to be 100 mm

[0103] At the same time, select the modified model in the figure (number) in the form, and the model is also automatically updated

[0104] Finally, export the design results as CAD drawings, engineering drawings, or files in other formats. Ensure that the exported files contain all necessary design information and annotations.

[0105] 6. Estimated Gain Effect:

[0106] Parameter-driven efficiency improvement: The time taken for the model to be automatically updated after modifying the main parameters is < 3 seconds

[0107] Design error rate reduction: 87% of input errors are intercepted through data validation rules

[0108] Standardization level improvement: The design time for the motor mount of the same model is shortened from 4 hours to 15 minutes

[0109] This embodiment fully realizes the full process connection from the Excel parameter table to the 3D model and then to the manufacturing data, verifying the effectiveness of the solution in the design of electromechanical equipment.

[0110] Embodiment 2: Here, taking a pipeline as an example, an intelligent design process based on the linkage between an Excel parametric table and low-code rules is demonstrated.

[0111] 1. System Preparation and Environment Setup

[0112] Software Configuration:

[0113] Autodesk Inventor 2023 (with the iLogic extension enabled)

[0114] Excel Parameter Table: "Pipe Orifice Table.xlsx" (including the following structure)

[0115] 2. Parameter Definition and Excel Spreadsheet Settings

[0116] Define parameters: Define the key design parameters of the motor in the Excel spreadsheet, as shown in Table 2 below:

[0117] Table 2

[0118]

[0119] The content of this table involves detailed information on the materials of nozzles, tanks, flanges, etc.

[0120] Establish parameter relationships: Define the shape parameters in Inventor and create the required driving parameters, such as Figure 5 as shown.

[0121] 3. Write and apply low-code (Inventor iLogic script):

[0122] i = GoExcel.FindRow("Pipe Orifice Table.xlsx", "Pipe Orifice Table", "Pipe Orifice Number", "=", nozzle number)

[0123] V1A nominal diameter = GoExcel.CurrentRowValue("Nominal Diameter")

[0124] Nozzle material = GoExcel.CurrentRowValue("Nozzle Material")

[0125] Wall thickness series = GoExcel.CurrentRowValue("Wall Thickness Series")

[0126] Nut material = GoExcel.CurrentRowValue("Nut Material")

[0127] Bolt material = GoExcel.CurrentRowValue("Bolt Material")

[0128] Washer material = GoExcel.CurrentRowValue("Washer Material")

[0129] Sealing ring material = GoExcel.CurrentRowValue("Sealing Ring Material")

[0130] This code snippet is used to read the design parameters of the pressure vessel nozzles from an Excel table and apply these parameters to the property settings of the 3D model in Autodesk Inventor. It realizes the automatic mapping from Excel parameters to 3D model properties, significantly improving the standardization level and efficiency of the pressure vessel nozzle design. The core functions include:

[0131] Excel data location: Locate the specific data row through the nozzle number

[0132] Parameter extraction: Read key parameters such as the material and dimensions of the nozzle

[0133] Model property injection: Write the parameters into the Inventor model properties

[0134] iProperties.Value("Project","Part Number") = Seal ring standard

[0135] iProperties.Material = Seal ring material

[0136] iProperties.Value("Project","Description") = "Gasket" & L1 nominal diameter

[0137] This code assigns values to iProperties through Inventor, specifically including three key settings: First, assign the "Part Number" property in the project classification to "Seal ring standard" to identify the standardized specifications of the seal (such as GB / T 3452.1 rubber O-ring for mechanical seals, etc.); second, directly specify the material property as "Seal ring material"; finally, in the "Description" field of the project description, combine the basic name "Gasket" with the resolved nominal diameter value of variable L1 through string concatenation (for example, generate "Gasket DN50"). This dynamic assignment method realizes the automatic marking of product specification parameters.

[0138] The whole set of operations reflects the parametric design thinking, ensuring the accuracy and standardized output of attribute information through programming means, and is applicable to the scenario of batch processing the attribute configuration of parts in the seal family table.

[0139] 4. Parametric design process of Autodesk software

[0140] Apply the written low-code to the parametric model in Autodesk software.

[0141] 5. Design verification and testing

[0142] Modify the parameter values in the Excel table and observe the changes in the model in Autodesk software.

[0143] For example: Modify the nominal diameter of the N5 nozzle in Excel from DN150 to DN200:

[0144] The outside diameter of the flange is automatically updated to 340 mm (according to ASME standard)

[0145] The number of bolt holes changes from 8 to 12

[0146] The gasket thickness changes from 3 mm to 4 mm

[0147] 6. Technical benefit analysis:

[0148] Improved design efficiency: After the parameter change from DN150 to DN200, the time taken for the model to update automatically is only 2.7 seconds. Reduced error rate: Five common design errors were intercepted through material compatibility checks

[0149] Improved standardization rate: The accuracy rate of calling standard parts such as flanges / bolts reaches 100%

[0150] This embodiment realizes the full-process intelligent design of pressure vessel nozzles from parameter definition to manufacturing data, and verifies the effectiveness of the solution in the design of process equipment. The key innovation lies in the deep integration of the ASME standard library and parametric rules, realizing an innovative mode of "standard-driven design".

[0151] According to the above operation process, the key operations for the coordinated design of non-standard parts and standard parts can also be given here:

[0152] 1. Integration of standard part library

[0153] Integrate the standard part library in Autodesk design software. These standard parts can be predefined models or parametric models. Ensure that each standard part in the standard part library has a unique identifier and related parameters.

[0154] 2. Coordinated design

[0155] Use low-code to write rules to achieve the coordinated design between non-standard parts and standard parts. For example, when a standard part is selected, the low-code can automatically adjust the size and position of the non-standard part to ensure their compatibility and fit.

[0156] From the above operations and embodiments, it can be seen that the dynamic association mechanism between low-code rules and Excel parameter tables can achieve the following functions:

[0157] 1. Full-element parametric design and real-time update

[0158] Define full-element parameters (such as equipment size, quantity, position, etc.) in Excel. Through the "Parameter Link" function of the low-code plugin, establish a two-way binding between Excel parameters and design elements (dimensions, geometric features) of Autodesk software (such as Inventor). When the Excel parameter value is modified, the low-code rule automatically triggers the update of the design elements to ensure that the model changes in real time (for example, after the processing air volume is modified, the filtration area and box size are automatically recalculated).

[0159] 2. Conflict detection and intelligent resolution

[0160] Through the conflict detection mechanism built into the low-code rules, logical contradictions between design parameters (such as size overrun, geometric interference) are identified. The system automatically prompts the conflict type (such as "insufficient wall thickness of the box body") and provides correction suggestions (such as adjusting materials or parameter formulas) to ensure design consistency.

[0161] 3. Optimize the design process

[0162] In the prior art, optimizing the design process generally includes steps such as automated design, design verification, and design optimization.

[0163] Improvements of the present invention: In the present invention, the design process optimization is further refined and optimized. The system realizes the automation and intelligence of the design process by introducing intelligent algorithms and machine learning technologies, improving the efficiency and accuracy of design. In addition, the system also provides a visualization display function for design verification and optimization results to help users better understand the design process and design results.

[0164] 4. Engineering drawing specification

[0165] In the prior art, engineering drawing specifications generally rely on the engineering drawing module and standardization library in the CAD system. These modules and libraries provide standardized engineering drawing symbols, annotations, formats, etc.

[0166] Improvements of the present invention: In the present invention, the engineering drawing specification is further refined and improved. The system formulates engineering drawing specifications for non-standard equipment, including the sizes and specifications of materials such as steel plates, steel pipes, and flanges. These specifications are linked in real time with the external dimensions of the model. In addition, the system also provides automation and intelligence functions for engineering drawing, such as automatic annotation and automatic layout, greatly improving the efficiency and accuracy of engineering drawing.

[0167] 5. Application of low-code rules

[0168] Innovations of the present invention: The present invention deeply explores the potential of low-code rules, not only applying internal rules but also cleverly combining external rules to form a complete rule system. To improve design efficiency, the present invention innovatively realizes the function of batch injecting low-code rules for similar models. This means that designers only need to define the rules once and can apply them to multiple similar or identical models, greatly saving time and effort. At the same time, the reusability of the rules also enhances the consistency and reliability of the design. The present invention also provides editing and management functions for low-code rules, enabling users to customize and modify rules according to actual needs. This function greatly enhances the flexibility and adaptability of the design, enabling designers to quickly adjust the rules according to changing needs at any time to ensure the accuracy and efficiency of the design.

[0169] Specific application:

[0170] 1) Adaptive design algorithm under multiple constraints

[0171] Through the integration of multidisciplinary knowledge and parameter constraints, the present invention encodes constraint conditions such as engineering specifications (such as material strength, environmental protection standards) and physical limitations (such as geometric tolerances) into low-code rules, and dynamically adjusts the parameter range through mathematical calculations (such as linear programming). When the parameters are not within the normal range, automatic prompts and corrections can be made. This step is one of the unique innovation points of the present invention.

[0172] Example: When the length of the box exceeds the material load-bearing limit, the system automatically prompts and corrects it to a safe value (such as adjusting from 6000mm to 5500mm).

[0173] 2) Multi-objective collaborative design

[0174] Under the condition of meeting multiple constraints such as cost, performance, and environmental protection, multi-objective optimization is realized through low-code rules (such as maximizing the processing efficiency while minimizing the material cost).

[0175] Example: By associating the unit price of materials with the equipment size through Excel formulas, a box design scheme with the optimal cost is dynamically generated.

[0176] Compared with the prior art, the proposed solution of the present application has the following technical advantages:

[0177] 1. Significantly improved design efficiency (the most important advantage)

[0178] Full-element parametric design: The proposed solution of the present application adopts the full-element parametric design technology, enabling design elements (such as dimensions, quantities, positions, etc.) to be updated in real time and automatically adjusted. This technical means greatly reduces the time and effort of designers to manually adjust design elements, thereby improving design efficiency.

[0179] Linked design: By realizing the linked design between non-standard parts and standard parts, as well as the reuse of similar elements and the replication design route of similar equipment, the proposed solution of the present application further improves design efficiency. When a certain design element changes, other related elements will be automatically updated, avoiding repeated design and calculation.

[0180] Advantage description: The improvement of design efficiency means that designers can complete more design tasks in a shorter time, thus creating more value for the enterprise. In addition, the improvement of design efficiency also helps to reduce design costs because it reduces repeated labor and human errors.

[0181] 2. Enhanced design accuracy

[0182] Optimized Design Process: The proposal of this application optimizes the design process by introducing intelligent algorithms and machine learning technologies. The system can automatically identify and optimize redundant parts in the design, improving the accuracy and reliability of the design.

[0183] Automation and Intelligence Means: By applying automation and intelligence means, such as adaptive design algorithms under multiple constraints and low-code rule applications, the proposal of this application reduces human errors and repetitive labor, further improving the accuracy of the design.

[0184] Advantage Explanation: The enhancement of design accuracy helps to ensure the correctness and reliability of the design results, thus reducing the error rate and rework rate during the production process. This can not only improve production efficiency but also reduce production costs and quality risks.

[0185] 3. Engineering Drawings are More Standardized

[0186] Formulation of Engineering Drawing Standard: The proposal of this application formulates the engineering drawing standard for the equipment, including the dimensions and specifications of materials such as steel plates, steel pipes, and flanges. This standard ensures the accuracy and readability of the engineering drawings.

[0187] Automated Drawing Function: The system also provides an automated drawing function, which can automatically generate engineering drawings that meet the standards, further improving the drawing efficiency and accuracy.

[0188] Advantage Explanation: The standardization of engineering drawing helps the production department accurately understand the design intention, thus reducing production difficulties and costs. At the same time, standardized engineering drawings can also improve production efficiency and quality because production personnel can more clearly understand the design requirements and production standards.

[0189] 4. Improvement in Intelligence Level

[0190] Low-Code Rule Application: The proposal of this application deeply explores and applies low-code rules, including internal rules and external rules. These rules are used to implement multi-entity modeling, generate components, and fix templates (built-in attribute rules). By injecting rules into similar models in batches, the system improves the design reusability and intelligence level.

[0191] Adaptive Design Algorithm under Multiple Constraints: By injecting multidisciplinary knowledge into low-code to form intelligent models, these models can learn the knowledge in the case library, write the limiting conditions into code snippets, thereby controlling the selection range of dimensions and improving the design quality. In addition, the system also realizes the mathematical calculation function, which can automatically give prompts and corrections when the parameters are not within the normal range.

[0192] Advantages: The improvement of the intelligent level makes the design process more efficient and accurate. With the support and optimization of intelligence, the system can automatically adjust design parameters, identify and optimize redundant parts in the design, thereby improving the overall quality and reliability of the design. In addition, the improvement of the intelligent level also helps to reduce design costs and time, as manual operations and human errors are reduced.

[0193] The above are examples of the best implementation modes of the present invention, and the parts not described in detail are all common general knowledge of those of ordinary skill in the art. The protection scope of the present invention is subject to the content of the claims, and any equivalent transformation based on the technical inspiration of the present invention is also within the protection scope of the present invention.

Claims

1. A full-element parametric model design method based on Excel and low-code, characterized in that, It includes the following steps: Step 1, System preparation and environment setup; Step 2, Parameter definition and Excel spreadsheet settings, specifically including the following steps: Step 2.1, Define the key design parameters of non-standard equipment and the alternative models and parameters of standard equipment in the Excel spreadsheet. Set a unique identifier and a descriptive name for each parameter, and ensure that the naming and format of the parameters match the requirements of Autodesk software and the low-code module; Step 2.2, Determine whether the parameter is of the direct definition type or the associated type. If it is of the direct definition type, the designer directly fills in the value. If it is of the associated type, use the function formula of Excel to establish the relationship and calculation logic between parameters; Step 2.3, Set data validation rules for the parameters to ensure that the input data is within a reasonable range; Step 3, Use the low-code plugin to write intelligent logic rule code, and based on the parameter values or function formulas in the Excel spreadsheet, adjust the design elements of the control model; Step 4, Apply the written low-code to the parametric model in Autodesk software, ensure that the code can correctly read the parameter values in the Excel spreadsheet, and adjust the model according to the intelligent logic rules; Step 5, Modify the parameter values in the Excel spreadsheet, observe the changes in the model in Autodesk software, ensure that the adjustment of the model meets the expectations, and the low-code can be correctly executed. Use the tools provided by Autodesk software for design verification, optimize the design according to the verification results, and adjust the parameters to meet the design requirements; Step 6, Export the design results to CAD drawings, engineering drawings or files in other formats, and ensure that the exported files contain all necessary design information and annotations.

2. The method for designing a full-element parametric model based on Excel and low-code according to claim 1, wherein The specific steps of Step 3 include the following steps: Step 3.1, In the low-code, use the "ilogic" function to link the parameters in the Excel spreadsheet with the corresponding design elements in Autodesk software, so that when the parameters in the Excel spreadsheet change, the design elements in Autodesk software will also be updated accordingly. The standard equipment model input into the model can automatically find the corresponding column number in the Excel spreadsheet to obtain the dimension series, realizing the update of the model; Step 3.2, Use the programming environment of the low-code to write intelligent design rules, and automatically adjust the design elements based on the parameter values and function formulas in the Excel spreadsheet.

3. The method for designing a full-element parametric model based on Excel and low-code according to claim 1, wherein In Step 3, a conflict detection mechanism is set in the low-code. When a conflict occurs in the association relationship between design elements, the system automatically prompts and provides solutions.

Images