Multivariable combined calculation and collaborative decision-making method and system based on calculation template and medium

Abstract

The invention relates to a multivariable combined calculation and collaborative decision-making method and system based on a calculation template and a medium, and belongs to the technical field of engineering calculation of engineering machinery products, and the method comprises the steps: obtaining a calculation template which is compiled by a user according to a standard form and comprises an input parameter, an output parameter and a calculation rule; creating a customization template according to business requirements based on the calculation template, defining input parameters as fixed parameters and variable parameters by the customization template, and defining calculation parameters representing a mapping relationship among the input parameters, the output parameters and operation parameters of calculation rules; configuring a calculation task page based on the fixed parameter, the variable parameter and the output parameter defined by the customized template; and assigning the fixed parameters and the variable parameters in the calculation task page, calculating to obtain a calculation result of the output parameters, and determining a value scheme of the variable parameters and an output result of the current calculation task page according to the calculation result of the output parameters.

Description

Technical Field

[0001] This invention relates to a method, system, and medium for multivariate combination calculation and collaborative decision-making based on a calculation template, belonging to the field of engineering calculation technology for engineering machinery products. Background Technology

[0002] Currently, the construction machinery industry generally uses the primitive model of "manual calculation using Excel + manual recording of results." Designers directly manipulate calculation templates (such as Excel spreadsheets), manually input various parameters, and record the calculation results. When optimizing parameters, designers need to continuously adjust input variables, trigger formula calculations, and copy the results to the summary area. For exploratory analysis involving multiple variable combinations, engineers must manually traverse parameter combinations, achieving this through repeated input, calculation, and recording—a process that is extremely time-consuming and prone to untraceable errors.

[0003] Another approach is to use script-driven computation, writing dedicated computation scripts for specific computation templates. This method achieves a certain degree of automation, but the computation logic is highly coupled with the task script. Once the parameters of the computation formula change, the script needs to be modified, tested, and deployed again, resulting in high maintenance costs. Furthermore, it requires personnel with development capabilities to maintain, limiting flexible exploration during the design process. Summary of the Invention

[0004] The purpose of this invention is to provide a method, system, and medium for multivariate combination computation and collaborative decision-making based on computation templates. By defining the input parameters of the computation template, the same computation template can be reused by multiple tasks, the computation logic is decoupled from the task application scenario, the maintenance difficulty is low, and the task configuration is flexible.

[0005] In a first aspect, the present invention provides a multivariate combination calculation and collaborative decision-making method based on a computational template, comprising: Obtain the calculation template prepared by the user in a standard format, which includes input parameters, output parameters, and calculation rules; Based on the calculation template, a customized template is created according to business needs. The customized template defines the input parameters as fixed parameters and variable parameters, and defines the calculation parameters that represent the mapping relationship between the input parameters, output parameters and the operation parameters in the calculation rules. Configure the page parameters of the calculation task page based on the fixed parameters, variable parameters and output parameters defined in the customized template, and use the calculation parameters to map and bind the page parameters on the calculation task page to the operation parameters in the calculation rules one by one. Assign values ​​to the fixed and variable parameters on the calculation task page and calculate the results of the output parameters. Based on the calculation results of the output parameters, determine the value scheme of the variable parameters and the output results of the current calculation task page.

[0006] Optionally, the calculation template is a standard format table file, which can be parsed and read to obtain input parameters, output parameters, and calculation rules.

[0007] Optionally, a standard format table file can be displayed as a template editing interface, where the input parameters, output parameters, and calculation rules can all be edited and adjusted.

[0008] Optionally, the fixed parameters defined by the custom template support fixed single-value input, and the variable parameters defined by the custom template support any optional value input from a pre-defined set of optional values.

[0009] Optionally, the page parameters of the calculation task page can be configured in the graphical interface based on the fixed parameters, variable parameters, and output parameters defined in the customized template.

[0010] Optionally, the calculation results of the output parameters obtained after assigning values ​​to the fixed parameters and variable parameters in the calculation task page include: Assign values ​​to fixed parameters and variable parameters, and perform a validity check on the assigned values ​​of variable parameters; In response to a calculation signal, the system calculates the fixed and variable parameters after assignment according to the calculation rules of the calculation template corresponding to the current calculation task page to obtain the calculation result of the output parameter.

[0011] Optionally, the calculation results of the output parameters obtained by calculating the assigned fixed parameters and variable parameters according to the calculation rules of the corresponding calculation template include: Read all possible values ​​for each variable parameter; generate all possible assignment combinations for each variable parameter based on all possible values; The aforementioned assignment combination scheme is integrated with fixed parameters to obtain a parameter combination scheme capable of performing calculations; The calculation rules of the calculation template are used to perform batch calculations on all parameter combination schemes and obtain the calculation results corresponding to each parameter combination scheme.

[0012] Optionally, determining the value scheme for the variable parameters and the output results of the current calculation task page based on the calculation results of the output parameters includes: The parameter values ​​and corresponding output parameter calculation results of each parameter combination scheme are displayed in tabular form on the display terminal; The system acquires the user's operation instructions on the display terminal, determines the corresponding parameter combination scheme as the variable parameter value scheme based on the operation instructions, and uses the output parameter calculation result corresponding to the parameter combination scheme as the output result of the current calculation task page. The output result of the current calculation task page can be referenced by downstream calculation tasks and used as the input parameter assignment.

[0013] Secondly, the present invention provides a multivariate combination calculation and collaborative decision-making system based on a calculation template, comprising: The acquisition module is used to acquire a calculation template that includes input parameters, output parameters, and calculation rules; A creation module is used to create a customized template based on the calculation template according to business needs. The customized template defines the input parameters as fixed parameters and variable parameters, and defines the calculation parameters that represent the mapping relationship between the input parameters, output parameters and the operation parameters in the calculation rules. The configuration module is used to configure the calculation task page based on the fixed parameters, variable parameters and output parameters defined in the customized template, and to use the calculation parameters to map and bind the page parameters on the calculation task page to the operation parameters in the calculation rules one by one. The output module is used to assign values ​​to the fixed and variable parameters in the calculation task page, calculate the results of the output parameters, determine the value scheme of the variable parameters and the output results of the current calculation task page based on the calculation results of the output parameters.

[0014] Thirdly, the present invention provides a computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, implements the aforementioned multivariate combination calculation and collaborative decision-making method based on a computation template.

[0015] Compared with the prior art, the beneficial effects achieved by the present invention are as follows: This invention first obtains a calculation template compiled by the user in a standard format, which includes input parameters, output parameters, and calculation rules; Based on the aforementioned calculation template, a customized template is created according to business needs. The customized template defines input parameters as fixed parameters and variable parameters, and defines calculation parameters representing the mapping relationship between input parameters, output parameters, and the operational parameters of the calculation rules. This embodiment allows for the creation of customized templates based on the calculation template according to business needs, thereby decoupling the calculation logic and task application scenarios. The same technical template can be reused for multiple tasks, reducing maintenance difficulty and enabling flexible configuration of calculation tasks. Furthermore, this invention configures the page parameters of the calculation task page based on the fixed parameters, variable parameters, and output parameters defined in the customized template, and uses the calculation parameters to map and bind the page parameters on the calculation task page to the operational parameters of the calculation rules one by one. The calculation task page clearly displays the task-related parameter configurations, making it user-friendly for non-developers. Finally, the fixed parameters and variable parameters on the calculation task page are assigned values, and the calculation results of the output parameters are calculated. Based on the calculation results of the output parameters, the value scheme of the variable parameters and the output result of the current calculation task page are determined. Attached Figure Description

[0016] Figure 1The diagram shown is a flowchart of a multivariate combination calculation and collaborative decision-making method based on a calculation template provided by an embodiment of the present invention. Detailed Implementation

[0017] It should be noted that: The technical solution of the present invention will be described in detail below with reference to the accompanying drawings and specific embodiments. It should be understood that the embodiments of the present invention and the specific features in the embodiments are detailed descriptions of the technical solution of the present invention, rather than limitations thereof. In the absence of conflict, the embodiments of the present invention and the technical features in the embodiments can be combined with each other.

[0018] The term "and / or" simply describes the relationship between related objects, indicating that three relationships can exist. For example, A and / or B can represent: A alone, A and B simultaneously, or B alone. Additionally, the character " / " generally indicates that the preceding and following related objects have an "or" relationship.

[0019] This embodiment introduces a multivariate combination calculation and collaborative decision-making method based on a computational template, characterized by including: Step S1: Obtain a calculation template compiled by the user, including input parameters, output parameters, and calculation rules; the calculation template is a standard format table file, which can be parsed and read (as an example, POI, EasyExcel, and other existing technologies with the same function can be used to obtain input parameters, output parameters, and calculation rules (including calculation formulas, calculation units, or operation logic).

[0020] This embodiment is configured with a calculation template module for unified management of user-uploaded calculation templates. Step S1 includes: S11: Predefine the necessary structure for the calculation template, such as the basic information of "type, identifier, and unit" for each parameter, to achieve template standardization. For example, parameters include amplitude (type: input parameter, identifier: a, unit: mm), boom length (type: input parameter, identifier: b, unit: mm), multiplier (type: input parameter, identifier: c, unit: -), lifting capacity (type: input parameter, identifier: d, unit: kg), maximum lifting capacity (type: input parameter, identifier: e, unit: kg), maximum multiplier (type: input parameter, identifier: f, unit: -), and lifting weight (type: output parameter, identifier: re, unit: kg).

[0021] S12: Users need to create calculation templates for their actual business operations according to the agreed format and upload them to the calculation template module. The calculation template module provides a visual data display interface and supports operations such as "add, update, and view". All operations are completed through a graphical interface, which is user-friendly for non-developers. Users do not need to worry about the underlying storage and parsing logic, but only need to focus on defining the business calculation logic.

[0022] S13: Based on the standard format agreed upon in S11 and S12, after the calculation template is uploaded, the Excel file can be read using technologies such as POI and EasyExcel to parse the following content: all input parameters; all output parameters; calculation rules (calculation formulas, calculation units, or operational logic). This embodiment, by abstracting the calculation template, can be reused by multiple tasks, significantly reducing maintenance costs and greatly improving system flexibility.

[0023] Step S2: Based on the calculation template, create a customized template according to the requirements. The customized template defines the input parameters as fixed parameters and variable parameters, and defines the calculation parameters that represent the mapping relationship between the input parameters, output parameters and the operation parameters in the calculation rules. The customized template in this embodiment can be regarded as a dynamic calculation template. When defining a calculation template, the input and output parameters must be clearly defined. Based on the input and output parameters defined in the calculation template, the customized template supports the dynamic definition of parameter types and identifiers.

[0024] Specifically, the customized template can define input parameters as fixed parameters and variable parameters, and define computational parameters that represent the mapping relationship between input parameters, output parameters, and operational parameters in the calculation rules. For variable parameters requiring parameter optimization, multiple input values ​​are supported, but the final number of input and output parameters must remain consistent with the calculation template. Therefore, based on the same calculation template, this embodiment can create multiple customized templates according to different concerns (different concerns result in different defined variable parameters), defining different variable parameters to achieve multi-variable combination optimization, thereby improving the reusability of the calculation template.

[0025] Step S2 specifically includes: S21: Create a customized template based on business needs and define the parameter list required for subsequent calculation tasks.

[0026] S22: Customized templates need to define the following four types of parameters: fixed parameters (support single input values), variable parameters (used for combined solutions, support multiple input values), output parameters (calculation results, support result referencing mechanism), and calculation parameters (representing the mapping relationship between input parameters, output parameters and operation parameters in the calculation rules).

[0027] Step S3: Configure the calculation task page based on the fixed parameters, variable parameters and output parameters defined in the customized template, and use the calculation parameters to map and bind the page parameters on the calculation task page to the operation parameters in the calculation rules one by one; Step S3 specifically includes: Step S31: Create specific computation tasks based on the customized template in S2. A computation task is equivalent to a traditional optimization process implemented using Excel or scripts. In this embodiment, the computation task is encapsulated as a computation component, providing a visual interface for task configuration. Each computation task can contain multiple steps, and all configuration operations are completed through a graphical interface, making it user-friendly for non-developers and standardizing the process. The customized template in step S2 defines four types of parameters: fixed parameters, variable parameters, output parameters, and computation parameters. All parameter contents will be automatically loaded when configuring the computation task.

[0028] S32: For calculation parameters, it is necessary to additionally bind the calculation rules of the calculation template in step S1; the specific operation is as follows: after selecting a calculation template, the parameter list of the calculation template is automatically rendered, and the page parameters on the calculation task page are mapped and bound one by one with the operation parameters in the calculation rules, thereby realizing the dynamic injection of calculation rules.

[0029] Step S4: After assigning values ​​to the fixed parameters and variable parameters in the calculation task page, calculate the result of the output parameter.

[0030] Traditional parameter adjustments require manual execution one by one, failing to automatically generate multi-variable combinations and perform batch calculations, making them unsuitable for exploratory calculations involving multiple variables and schemes. This embodiment, to execute the calculation task and obtain output, requires assigning values ​​to fixed and variable parameters first. Fixed parameters support single-value input, while variable parameters support multiple-value input with automatic validity checks. After initialization, in response to a user's one-click triggering of the "Calculate" button, the calculation rules of the calculation template corresponding to the current calculation task page calculate the results of the assigned fixed and variable parameters to obtain the output parameters.

[0031] Step S4 specifically includes: Step S41: Read all possible values ​​for each variable parameter. Based on all possible values ​​for each variable parameter, generate all possible assignment combinations for the variable parameter. In this embodiment, the Cartesian product operation is used to automatically and exhaustively generate all possible assignment combinations. Each assignment combination represents a candidate solution to be calculated. Alternatively, orthogonal experimentation and related methods with similar functions can be used to replace the Cartesian product operation.

[0032] Step S42: Integrate the assigned value combination scheme with fixed parameters to obtain a parameter combination scheme capable of performing calculations. Utilize the calculation rules of the bound calculation template to perform batch calculations on all parameter combination schemes and obtain the calculation result corresponding to each parameter combination scheme. After the calculation of all parameter combination schemes is completed, all results are structured, organized, and encapsulated, and uniformly returned to the front-end interface. This provides a data foundation for users to perform unified viewing, multi-dimensional filtering, and in-depth comparative analysis. This embodiment generates all assigned value combination schemes through Cartesian product, realizing batch calculation of multi-parameter combination schemes and automating repetitive manual labor.

[0033] Step S5: Determine the value scheme of the variable parameters and the output results of the current calculation task page based on the calculation results of the output parameters.

[0034] This embodiment will visually display all parameter combinations and their calculation results in a structured table format on the calculation task page. Furthermore, this embodiment provides a series of advanced filtering and comparison functions to assist decision analysis. Firstly, it allows for focusing on variable parameters to quickly identify how changes affect the final result. Secondly, it provides difference visualization, visually distinguishing the output indicators of different solutions to make key differences immediately apparent. Thirdly, it offers compliance filtering, automatically detecting and filtering feasible solutions that meet preset constraints. These functions help users quickly locate the optimal solution or key solutions from a vast number of options, thereby achieving data-driven decision-making. Users can formally save the calculation results of the output parameters of the optimal solution selected in the decision as the output of the current calculation task. This output result can be directly referenced as input by other downstream calculation tasks, thus establishing a data chain between tasks and building an end-to-end collaborative design workflow.

[0035] Traditional solutions confine parameters and results to the designer's personal files, lacking transferability and traceability, thus creating "data silos." The result referencing mechanism in this embodiment constructs a collaborative link connecting multiple computing tasks, enabling automatic transfer of "upstream computing results → downstream input," forming a traceable parameter flow network.

[0036] Another specific embodiment provides a multivariate combination computation and collaborative decision-making system based on computational templates, which includes: The acquisition module is used to acquire a calculation template that includes input parameters, output parameters, and calculation rules; A creation module is used to create a customized template based on the calculation template according to business needs. The customized template defines the input parameters as fixed parameters and variable parameters, and defines the calculation parameters that represent the mapping relationship between the input parameters, output parameters and the operation parameters in the calculation rules. The configuration module is used to configure the calculation task page based on the fixed parameters, variable parameters and output parameters defined in the customized template, and to use the calculation parameters to map and bind the page parameters on the calculation task page to the operation parameters in the calculation rules one by one. The output module is used to assign values ​​to the fixed and variable parameters in the calculation task page, calculate the results of the output parameters, determine the value scheme of the variable parameters and the output results of the current calculation task page based on the calculation results of the output parameters.

[0037] In another specific embodiment, a computer-readable storage medium is provided on which a computer program is stored, which, when executed by a processor, implements the aforementioned multivariate combination calculation and collaborative decision-making method based on a computational template.

[0038] Those skilled in the art will understand that embodiments of the present invention can be provided as methods, systems, or computer program products. Therefore, the present invention can take the form of a completely hardware embodiment, a completely software embodiment, or an embodiment combining software and hardware aspects. Furthermore, the present invention can take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.

[0039] This invention is described with reference to flowchart illustrations and / or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each block of the flowchart illustrations and / or block diagrams, and combinations of blocks in the flowchart illustrations and / or block diagrams, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, special-purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, generate instructions for implementing the flowchart illustrations and / or block diagrams. Figure 1 One or more processes and / or boxes Figure 1 A device that provides the functions specified in one or more boxes.

[0040] These computer program instructions may also be stored in a computer-readable storage medium that can direct a computer or other programmable data processing device to function in a particular manner, such that the instructions stored in the computer-readable storage medium produce an article of manufacture including instruction means, which are implemented in a process Figure 1 One or more processes and / or boxes Figure 1 The function specified in one or more boxes.

[0041] These computer program instructions may also be loaded onto a computer or other programmable data processing equipment to cause a series of operational steps to be performed on the computer or other programmable equipment to produce a computer-implemented process, thereby providing instructions that execute on the computer or other programmable equipment for implementing the process. Figure 1 One or more processes and / or boxes Figure 1 The steps of the function specified in one or more boxes.

[0042] The embodiments of the present invention have been described above with reference to the accompanying drawings. However, the present invention is not limited to the specific embodiments described above. The specific embodiments described above are merely illustrative and not restrictive. Those skilled in the art can make many other forms under the guidance of the present invention without departing from the spirit and scope of the claims. All of these forms are within the protection scope of the present invention.

Claims

1. A multivariate combination calculation and collaborative decision-making method based on computational templates, characterized in that, include: Obtain the calculation template prepared by the user in a standard format, which includes input parameters, output parameters, and calculation rules; Based on the calculation template, a customized template is created according to business needs. The customized template defines the input parameters as fixed parameters and variable parameters, and defines the calculation parameters that represent the mapping relationship between the input parameters, output parameters and the operation parameters in the calculation rules. Configure the page parameters of the calculation task page based on the fixed parameters, variable parameters and output parameters defined in the customized template, and use the calculation parameters to map and bind the page parameters on the calculation task page to the operation parameters in the calculation rules one by one. Assign values ​​to the fixed and variable parameters on the calculation task page and calculate the results of the output parameters. Based on the calculation results of the output parameters, determine the value scheme of the variable parameters and the output results of the current calculation task page.

2. The multivariate combination calculation and collaborative decision-making method based on computational templates according to claim 1, characterized in that, The calculation template is a standard format table file, which can be parsed and read to obtain input parameters, output parameters, and calculation rules.

3. The multivariate combination calculation and collaborative decision-making method based on computational templates according to claim 2, characterized in that, Standard format table files can be displayed as template editing interfaces, where input parameters, output parameters, and calculation rules can all be edited and adjusted.

4. The multivariate combination calculation and collaborative decision-making method based on computational templates according to claim 1, characterized in that, The fixed parameters defined by the custom template support fixed single-value input, while the variable parameters defined by the custom template support any optional value input from a pre-defined set of optional values.

5. The multivariate combination calculation and collaborative decision-making method based on computational templates according to claim 1, characterized in that, The page parameters for configuring the calculation task page are completed in the graphical interface based on the fixed parameters, variable parameters, and output parameters defined in the customized template.

6. The multivariate combination calculation and collaborative decision-making method based on computational templates according to claim 1, characterized in that, The calculation results of the output parameters obtained after assigning values ​​to the fixed and variable parameters in the calculation task page include: Assign values ​​to fixed parameters and variable parameters, and perform a validity check on the assigned values ​​of variable parameters; In response to a calculation signal, the system calculates the fixed and variable parameters after assignment according to the calculation rules of the calculation template corresponding to the current calculation task page to obtain the calculation result of the output parameter.

7. The multivariate combination calculation and collaborative decision-making method based on computational templates according to claim 6, characterized in that, The calculation results of the fixed and variable parameters after assignment are obtained by calculating according to the calculation rules of the corresponding calculation template. These results include: Read all possible values ​​for each variable parameter; generate all possible assignment combinations for each variable parameter based on all possible values; The aforementioned assignment combination scheme is integrated with fixed parameters to obtain a parameter combination scheme capable of performing calculations; The calculation rules of the calculation template are used to perform batch calculations on all parameter combination schemes and obtain the calculation results corresponding to each parameter combination scheme.

8. The multivariate combination calculation and collaborative decision-making method based on computational templates according to claim 7, characterized in that, The value scheme for the variable parameters is determined based on the calculation results of the output parameters, and the output results of the current calculation task page include: The parameter values ​​and corresponding output parameter calculation results of each parameter combination scheme are displayed in tabular form on the display terminal; The system acquires the user's operation instructions on the display terminal, determines the corresponding parameter combination scheme as the variable parameter value scheme based on the operation instructions, and uses the output parameter calculation result corresponding to the parameter combination scheme as the output result of the current calculation task page. The output result of the current calculation task page can be referenced by downstream calculation tasks and used as the input parameter assignment.

9. A multivariate combination calculation and collaborative decision-making system based on computational templates, characterized in that, include: The acquisition module is used to acquire a calculation template that includes input parameters, output parameters, and calculation rules. A creation module is used to create a customized template based on the calculation template according to business needs. The customized template defines the input parameters as fixed parameters and variable parameters, and defines the calculation parameters that represent the mapping relationship between the input parameters, output parameters and the operation parameters in the calculation rules. The configuration module is used to configure the calculation task page based on the fixed parameters, variable parameters and output parameters defined in the customized template, and to use the calculation parameters to map and bind the page parameters on the calculation task page to the operation parameters in the calculation rules one by one. The output module is used to assign values ​​to the fixed and variable parameters in the calculation task page, calculate the results of the output parameters, determine the value scheme of the variable parameters and the output results of the current calculation task page based on the calculation results of the output parameters.

10. A computer-readable storage medium having a computer program stored thereon, characterized in that, When the computer program is executed by the processor, it implements the multivariate combination calculation and collaborative decision-making method based on the computation template as described in any one of claims 1-8.

Images