WO2019019789A1 - Parameter value calculation method and apparatus, storage medium and computer device - Google Patents

Abstract

A parameter numerical calculation method includes: receiving a selection instruction of a business item to be processed, the selection instruction carrying a corresponding item identifier; acquiring a template file corresponding to the item identifier, where the template file includes a parameter to be calculated a parameter name, a calculation formula, and a parameter name of the basic parameter; obtaining a parameter value of the basic parameter according to the parameter name of the basic parameter; and writing the parameter value into the template file and the parameter name of the basic parameter The associated location of the location association in the template file; and calculating the parameter value of the parameter to be calculated in the template file according to the calculation formula and the parameter value.

Description

Parameter numerical calculation method, device, storage medium and computer equipment

Cross-reference to related applications

This application claims the priority of the Chinese Patent Application entitled "Parameter Value Calculation Method, Apparatus, Storage Medium, and Computer Equipment", filed on July 27, 2017, with the application number of 2017106262317, the entire contents of which are incorporated by reference. Combined in this application.

Technical field

The application relates to a parameter numerical calculation method, device, storage medium and computer device.

Background technique

For financial products, such as insurance, funds, etc., there are many types of products, and the calculation methods of the values such as returns and rewards of different products also have certain differences. It is difficult to form a common calculation formula to calculate the value of the parameters that need to be calculated, such as the revenue and management fees of these products.

Therefore, the traditional method of calculating the parameter values is for each product, and a set of calculation system is provided for its individual use. According to the corresponding product, the corresponding setting calculation system is selected, and the parameter value of the required calculation is calculated according to the calculation system. However, the inventors realized that the more the product types and the calculation of the parameter values of the same product at different times, the more the calculation system required, the more the workload is. Less efficient.

Summary of the invention

According to various embodiments disclosed herein, a parameter numerical value calculation method, apparatus, storage medium, and computer apparatus are provided.

A parameter numerical calculation method includes: receiving a selection instruction of a business item to be processed, the selection instruction carrying a corresponding item identifier; acquiring a template file corresponding to the item identifier, where the template file includes a parameter to be calculated a parameter name, a calculation formula, and a parameter name of the basic parameter; obtaining a parameter value of the basic parameter according to the parameter name of the basic parameter; and writing the parameter value into the template file and the parameter name of the basic parameter The associated location of the location association in the template file; and calculating the parameter value of the parameter to be calculated in the template file according to the calculation formula and the parameter value.

A parameter value calculation device includes: a selection instruction receiving module, configured to receive a selection instruction of a business item to be processed, the selection instruction carrying a corresponding item identifier; and a template file obtaining module, configured to acquire the item identifier Corresponding template file, the template file includes a parameter name of the parameter to be calculated, a calculation formula, and a parameter name of the basic parameter; the parameter value writing module is configured to acquire the parameter of the basic parameter according to the parameter name of the basic parameter a value; writing the parameter value to an associated position in the template file associated with a location of the parameter name of the basic parameter in the template file; and a parameter numerical calculation module for using the calculation formula and The parameter value is used to calculate the parameter value of the parameter to be calculated in the template file.

A computer device comprising a memory and one or more processors having stored therein computer readable instructions, the computer readable instructions being executable by the processor to cause the one or more processors to be implemented The steps of the parameter numerical calculation method provided in any one of the embodiments of the present application.

One or more non-volatile storage media storing computer readable instructions, when executed by one or more processors, causing one or more processors to implement the parameters provided in any one embodiment of the present application The steps of the numerical calculation method.

Details of one or more embodiments of the present application are set forth in the accompanying drawings and description below. Other features and advantages of the present invention will be apparent from the description, drawings and claims.

DRAWINGS

In order to more clearly illustrate the technical solutions in the embodiments of the present application, the drawings to be used in the embodiments will be briefly described below. Obviously, the drawings in the following description are only some embodiments of the present application, Those skilled in the art can also obtain other drawings based on these drawings without any creative work.

1 is an application environment diagram of a method for calculating a parameter value in one or more embodiments;

2 is a flow chart of a method for calculating a parameter value in one or more embodiments;

3 is a flow chart showing the steps of setting a template file in one or more embodiments;

4 is a schematic diagram of a setting interface of a template file in one or more embodiments;

Figure 5 is a schematic illustration of some of the parameters of a template file in one or more embodiments;

Figure 6 is a block diagram of a parameter value calculation device in one or more embodiments;

Figure 7 is a block diagram of a parameter value calculation device in another embodiment;

Figure 8 is a block diagram of a parameter value calculation device in still another embodiment;

9 is a block diagram of a terminal in one or more embodiments.

Detailed ways

In order to make the technical solutions and advantages of the present application more clear, the present application will be further described in detail below with reference to the accompanying drawings and embodiments. It is understood that the specific embodiments described herein are merely illustrative of the application and are not intended to be limiting.

The parameter numerical calculation method provided by the embodiment of the present application can be applied to the environment as shown in FIG. 1. Referring to FIG. 1, the terminal 110 and the server 120 are connected through a network, and the terminal 110 includes, but is not limited to, a mobile phone, a handheld game console, a tablet computer, a personal digital assistant, or a wearable device. The terminal may receive a selection instruction of the business item to be processed, and the selection instruction carries a corresponding item identifier; and obtains a template file corresponding to the item identifier, where the template file includes a parameter name, a calculation formula, and a parameter name of the basic parameter. The template file can be obtained locally from the terminal 110 and can also be obtained from the server 120. The terminal 110 further obtains the parameter value of the basic parameter according to the parameter name of the basic parameter; and writes the parameter value into the associated position in the template file associated with the position of the parameter name of the basic parameter of the basic parameter in the template file; according to the calculation formula and The parameter value is used to calculate the parameter value of the parameter to be calculated in the template file, thereby realizing the calculation of the parameter value.

In one embodiment, as shown in FIG. 2, a calculation method of a parameter numerical value calculation method is provided, which can be applied to the terminal shown in FIG. 1 , and specifically includes the following steps:

Step S202, receiving a selection instruction of the business item to be processed, and the selection instruction carries a corresponding item identifier.

In this embodiment, the terminal may display a selection interface of the business item to be processed, and detect a selection instruction triggered by the user to select one or more of the to-be-processed business items. The business project is a portfolio of various financial products or a combination of financial products that require parameter numerical calculation. For example, the business project can be any financial product such as a bill of exchange, stocks, futures, bonds, insurance, and the like. The item identifier is used to uniquely identify the corresponding business item, and can be composed of special characters such as letters, numbers or underscores of the preset number of digits.

In one embodiment, the terminal may receive a login request of the user, where the login request carries login information such as a login account and a login password. After the login is successful, the service item associated with the login account may be obtained from the server. And displaying the acquired business items to be processed on the selection interface, so that each user can correspondingly handle the business items that he is responsible for. Specifically, brief information such as a project parameter name, a project number, and a project custodian of each business item can be displayed.

Step S204: Obtain a template file corresponding to the item identifier, where the template file includes a parameter name, a calculation formula, and a parameter name of the basic parameter.

In this embodiment, a plurality of template files may be pre-stored, and a correspondence relationship between each item identifier and one of the template files may be set, thereby setting a corresponding template file for each business item. The template file is a general-purpose file for writing calculation factors for a certain type or classes of business items and calculating parameter values. Specifically, a template file may correspond to a specific business item, and may also correspond to a plurality of similar business items, so that multiple similar items share the same template file. In one embodiment, the template file can be an Excel file, and the convenience of parameter numerical calculation in the template file can be improved by setting an Excel type template file.

The basic parameter is that the parameter value in the business item is an existing parameter, including the time class parameter, the interest rate class parameter, and the capital class parameter. For example, for a fund or futures business, the basic parameters include the starting date of the accrual interval, the closing date of the accrual interval, the net asset value at the end of the period, the fixed management fee, the management fee cap, and the accrued performance remuneration. At the end of the period, the total amount should be calculated. The parameter to be calculated refers to the parameter in the business project that needs to calculate the parameter value. The calculation formula is a calculation formula for calculating the parameter value of the parameter to be calculated, and the calculation formula is used to characterize the logical relationship between each parameter to be calculated and one or more basic parameters, and the parameters of the calculation formula and the basic parameter are adopted. The value can be used to calculate the parameter value corresponding to the parameter to be calculated.

It can be understood that the basic parameter and the number of parameters to be calculated may include multiple, and the basic parameters and the parameters to be calculated in different business items are not necessarily the same, and the corresponding calculation formulas are not necessarily the same. The same parameter may be a basic parameter in one business project, but a parameter to be calculated in another business project.

By setting a corresponding template file for each item of the business item, the template file sets the name of the basic parameter of the corresponding business item, the name of the parameter to be calculated, and the calculation formula. According to the template file, the calculation of the parameter values of the parameters to be calculated of the corresponding business item can be realized without separately designing a calculation system of parameter values for each business item.

Step S206: Acquire a parameter value of the basic parameter according to the parameter name of the basic parameter.

In this embodiment, the terminal directly receives the parameter value input by the user, identifies the parameter name of the basic parameter corresponding to the parameter value, and further sets the parameter value as the parameter value of the basic parameter. Alternatively, the terminal may further query, according to the item identifier, the parameter value of the corresponding basic parameter from the item information of the corresponding business item according to the parameter name of the basic parameter in the selected business item.

Step S208, the parameter value is written into the template file at the associated position associated with the position of the parameter name of the basic parameter in the template file.

In this embodiment, the relationship between the parameter name of each parameter and the position of the parameter value in the template file is set in advance. Specifically, the relationship between the locations may be a relative positional relationship, that is, the location of the parameter value of each parameter in the template file, and the location of the parameter name in the template file relative to the parameter is fixed. In one embodiment, the terminal may receive the parameter value writing instruction, and according to the parameter value writing instruction, obtain the position information of the parameter name of each basic parameter in the template file, and calculate the corresponding according to the association relationship. The parameter value is the associated position in the template file and is written to the associated location. Through the relationship between the positions, after the position of the parameter name is determined, the position of the corresponding parameter value in the template file, that is, the above-mentioned associated position, can be determined.

In one of the embodiments, the associated location is an adjacent location of the location of the parameter name corresponding to the base parameter in the template file. The adjacent position may be any one of the front, rear, left, and right positions of the position where the parameter name is located. Specifically, it may be the position of the first cell in the template file to the right of the position where the parameter name is located.

Step S210, calculating a parameter value of the parameter to be calculated in the template file according to the calculation formula and the parameter value.

In this embodiment, the terminal may invoke the logical operation function of the template file itself, identify the basic parameters involved in the calculation, and obtain the parameter values of the corresponding basic parameters, and use the calculation function carried by the template file according to the corresponding calculation. The rule calculates the parameter value corresponding to the parameter to be calculated, and writes the parameter value into the template file, thereby realizing the calculation of the parameter value.

In one embodiment, when the template file is an Excel file, the Apache POI method may be invoked, the calculation formula is written into the cell containing the formula, and the sheet page where the template file is located executes the calculation formula to calculate the business. data. Among them, POI is the open source library of Apache Software Foundation. POI provides API to Java program to read and write Microsoft Office format files.

The parameter numerical value calculation method provided by the embodiment receives the corresponding item identifier by receiving the selection instruction of the business item to be processed, and obtains a template file corresponding to the item identifier, where the template file includes the parameter name of the parameter to be calculated, Calculate the formula and the parameter name of the basic parameter; obtain the parameter value of the basic parameter; write the parameter value to the associated position of the template file associated with the position of the corresponding parameter name in the template file; and then according to the calculation formula and the parameter value, in the template The parameter values of the parameters to be calculated are calculated in the file. Since the corresponding template file is set for each business item, the template file includes the parameter name, the calculation formula and the parameter name of the basic parameter corresponding to the calculation parameter, so that after the parameter value of the basic parameter is obtained, The parameter value of the parameter to be calculated can be calculated in the template file according to the calculation formula of the parameter to be calculated, the calculation of the parameter to be calculated corresponding to the selected business item is realized, and a set of independent setting for each business item is also avoided. The calculation system reduces the workload of the system design and also improves the calculation efficiency of the parameter values of the parameters to be calculated.

In one embodiment, after step S210, the method further includes: generating a plan confirmation letter of the business item according to the parameter name of the basic parameter, the parameter value, and the parameter name and the parameter value of the parameter to be calculated.

In this embodiment, the plan confirmation letter is a file for displaying brief information of a business item to a salesperson, an administrator, or a customer of a business item, and the brief information includes parameter information of the corresponding business item. A template file corresponding to the plan confirmation function may be pre-stored in the terminal, and parameter information that needs to be loaded in the calculation confirmation function for each business item is further set, and the parameter information includes parameter names of one or more of the above basic parameters, The parameter value and the parameter name and parameter value of the parameter to be calculated. Specifically, the confirmation letter can be a PDF file.

In one of the embodiments, the terminal may further receive a generation instruction for the plan confirmation letter, and generate the plan confirmation letter according to the generation instruction. The terminal may provide a generation interface of the plan confirmation letter, and generate a generation confirmation instruction generating instruction by detecting an operation of generating a virtual key on the generation interface, a voice generated by a preset plan confirmation function, or a preset generation gesture. And according to the generation instruction, reading the parameter information required for the corresponding business item, writing each parameter information to the corresponding position in the plan confirmation letter, and generating a plan confirmation letter including the required parameter information. Specifically, it is possible to set whether the parameter needs to be written to the write flag of the plan confirmation for each parameter of each business item. The terminal may detect whether each parameter of the corresponding business item has a write flag that needs to be written into the plan confirmation function, and write the parameter name and parameter value that the presence of the write mark is detected into the plan confirmation letter.

In the present embodiment, by further generating the plan confirmation letter, the convenience of information management for the business item can be further improved.

In one embodiment, step S204 includes: identifying an item category to which the item identifier belongs, and acquiring a template file corresponding to the belonging item category.

In this embodiment, the item category is further preset, and the item category may include multiple types, such as the above-mentioned bills of exchange, stocks, futures, bonds, insurance, and the like, and each type of financial product may be further subdivided. Into a variety of business projects. The item category is the category of the business item that is divided to share a template file. The project category can be distinguished according to the project identifier. The project identifier can identify the project category to which the project belongs, and then obtain the business item for which the parameter numerical calculation is required according to the corresponding relationship between the preset project category and the template file. Template file.

In one embodiment, as shown in FIG. 3, the foregoing method further includes: before step S204:

Step S302: Receive a parameter write instruction to the template file, where the parameter name including the parameter name of the basic parameter, the parameter name of the parameter to be calculated, and the parameter name of the basic parameter and the parameter name of the parameter to be calculated are set in the template file. Location information.

In this embodiment, the terminal may further provide a setting interface of the template file, and receive parameter information of each parameter input by the user, and generate a parameter writing instruction when detecting an operation of writing a virtual button to a parameter acting on the interface. The parameter write command contains parameter information of each parameter input by the user. Specifically, the parameter information includes a parameter name of the basic parameter, a parameter name of the parameter to be calculated, and a parameter name of the basic parameter and a position name of the parameter name of the parameter to be calculated set in the template file. The location information includes the row and column where the parameter name is written to the cell in the template file.

For example, as shown in FIG. 4, it is a schematic diagram of a setting interface of a template file in one embodiment. The interface provides parameter names including a plurality of basic parameters and parameters to be calculated, and different parameters can be applied to one or several types of business items, so that the convenience of template file creation can be improved. The terminal can receive location information of each parameter input by the user in the template file, such as the row and column in which the user input can be received. Further, an option for whether the parameters listed in the interface is necessary is also provided. When the user selects Yes, after receiving the click operation on the “OK” button, the corresponding parameter name is written into the template to be created. In the file, in the cell where the row and column are located.

Step S304, the parameter name of the basic parameter and the parameter name of the parameter to be calculated are written into the corresponding position in the template file associated with the item identification.

Specifically, the corresponding location, that is, the cell of the row and column that is set, can write the parameter name of the basic parameter and the parameter name of the parameter to be calculated into the template file, and set the corresponding row and column of the cell. .

As shown in FIG. 5, it is a schematic diagram of some parameters of a template file in one embodiment. The parameter write command can be triggered after detecting a click operation on the "OK" button shown in FIG. The name of the parameter to be written carried in the parameter write instruction is written into the template file. For example, at the corresponding position, write the “starting date of the accrual interval”, “the end date of the accrual interval”, “the net asset value at the end of the period”, “the fixed management fee has been accrued”, “the remuneration for the accrued performance”, and “the end of the period should be calculated”. Total amount".

Step S306: Acquire a calculation formula of the parameter to be calculated associated with the item identifier; write the calculation formula into the template file.

Specifically, the calculation formula may be a calculation formula edited by the user, and may also be a calculation formula included in the item information of the corresponding business item. When the calculation formula is edited for the user, the terminal may also receive an editing operation of the calculation formula of the user to calculate the parameter, and parse the calculation formula set by the user. When the calculation formula is included in the project information, the terminal may query whether there is information of the calculation formula in the project information, and if yes, directly obtain the calculation formula of the parameter to be calculated included in the project information. The terminal may further identify a parameter of the calculation formula, where the parameter is a parameter to be calculated, and further load the calculation formula to a corresponding position in the template file. The corresponding position may be an associated position of the position of the parameter name of the parameter to be calculated, such as at an adjacent position where the parameter name is located.

In one of the embodiments, the location of the cell in which the calculation formula is written and/or the corresponding parameter to be calculated may be set, and the marker is used to identify the corresponding parameter as the parameter to be calculated. Specifically, the mark may be a color mark, such as a parameter name of the identified parameter to be calculated or a preset color of the cell mark in which the parameter value is located, so that the basic parameter and the to-be-calculated can be visually distinguished according to the marked color. parameter.

In one embodiment, writing the calculation formula into the template file includes: converting the calculation formula into a calculation formula recognizable by the template file; and writing the converted calculation formula to a corresponding position in the template file.

In this embodiment, the terminal may further parse the obtained calculation formula to detect whether the calculation formula is a calculation formula recognizable by the template file, and if not, perform the calculation formula obtained according to the calculation rule defined by the template file. The conversion is converted into a recognizable calculation formula of the template file, and the converted calculation formula is written into the template file.

For example, the template file is an Excel file, and the calculation parameter in the obtained calculation formula is identified by a parameter name, or is identified by a parameter character for indicating the name of the parameter, and the calculation formula can be identified. After the parameter to be calculated and/or the parameter character of the basic parameter or the parameter represented by the parameter name, calculate the position information set for the parameter value of the parameter, and replace the parameter character or parameter name with the position information, and The calculation logic represented by the calculation formula is converted into calculation logic that can be recognized by the Excel file, and the converted calculation formula is written into the cell in which the parameter value of the parameter to be calculated corresponding to the calculation formula is located, so that the Excel is in the Excel After reading the value of the basic parameter involved in the calculation formula, the parameter value of the parameter to be calculated is directly calculated according to the calculation logic.

For example, for a certain business project, there is a calculation formula for the original performance remuneration of the parameters to be calculated: the original performance remuneration = (the net asset value at the end of the period - the net value of the capital in and out according to the benchmark investment) * the proportion of the performance remuneration; or, in which, the parameter character A, B, C, and p represent the original performance remuneration, the net asset value at the end of the period, the capital inflow and out, the net investment value based on the benchmark, and the proportion of performance remuneration. Then, the server can separately obtain the position of the parameter original performance remuneration, the net asset value at the end of the period, the capital inflow and out of the base investment value, and the performance remuneration ratio in the cell of the template file, as shown in FIG. 4, and the calculation can be performed. The formula is converted into "=(D5-F5)*D10", and is written at the position where the parameter value of the original performance reward of the parameter is located, thereby realizing that the converted calculation formula is written into the template file, so that the above-mentioned After the end of the net asset value, the capital in and out according to the benchmark investment net value and the performance of the proportion of the proportion of the parameter value, you can directly use the Excel file's own calculation function to calculate the parameter value of the original performance reward parameter.

In one embodiment, it may be detected whether there is a template file associated with the item identifier that has been set, and if so, the parameter information is written into the existing template file; otherwise, a new template file may be created. And establishing an association relationship between the template file and the project identifier, and writing the parameter information into the created template file.

In this embodiment, by the above steps, the convenience of template file creation can be improved, and the convenience of parameter value calculation of the parameters to be calculated of the business item can be improved.

It should be understood that although the various steps in the flowcharts of FIGS. 2-3 are sequentially displayed as indicated by the arrows, these steps are not necessarily performed in the order indicated by the arrows. Except as expressly set forth herein, there is no strict ordering of the execution of these steps, which can be performed in other sequences. Moreover, at least some of the steps in Figures 2-3 may include a plurality of sub-steps or stages, which are not necessarily performed at the same time, but may be performed at different times, these sub-steps or stages The order of execution is not necessarily performed sequentially, but may be performed alternately or alternately with at least a portion of other steps or sub-steps or stages of other steps.

In one embodiment, as shown in FIG. 6, a parameter value calculation device is provided, including:

The instruction receiving module 602 is configured to receive a selection instruction of the business item to be processed, and the selection instruction carries a corresponding item identifier;

The template file obtaining module 604 is configured to obtain a template file corresponding to the item identifier, where the template file includes a parameter name, a calculation formula, and a parameter name of the basic parameter.

The parameter value writing module 606 is configured to obtain the parameter value of the basic parameter according to the parameter name of the basic parameter; and write the parameter value into the associated position in the template file associated with the position of the parameter name of the basic parameter in the template file;

The parameter value calculation module 608 is configured to calculate a parameter value of the parameter to be calculated in the template file according to the calculation formula and the parameter value.

In one embodiment, as shown in FIG. 7, another parameter value calculation device is provided, including:

The plan confirmation function generating module 610 is configured to generate a plan confirmation letter of the business item according to the parameter name of the basic parameter, the parameter value, and the parameter name and the parameter value of the parameter to be calculated.

In one embodiment, as shown in FIG. 8, another parameter value calculation device is provided, including:

The template file setting module 601 is configured to receive a parameter write instruction to the template file, where the parameter write command includes a parameter name of the basic parameter, a parameter name of the parameter to be calculated, and a parameter name of the basic parameter and a parameter name of the parameter to be calculated are Setting position information in the template file; writing the parameter name of the basic parameter and the parameter name of the parameter to be calculated into the corresponding position in the template file associated with the item identification; obtaining a calculation formula of the parameter to be calculated associated with the item identification ; and write the calculation formula into the template file.

In one embodiment, the template file setting module 601 is further configured to convert the calculation formula into a calculation formula recognizable by the template file; and write the converted calculation formula to a corresponding position in the template file.

In one embodiment, the template file is an Excel template file, and the associated location is an adjacent location of the location of the parameter name corresponding to the basic parameter in the template file.

Each of the above-described parameter numerical value calculation devices may be implemented in whole or in part by software, hardware, and combinations thereof. The above modules may be embedded in the hardware in the terminal or in the memory in the terminal, or may be stored in the memory in the terminal in a software form, so that the processor calls the execution of the operations corresponding to the above modules. The processor can be a central processing unit (CPU), a microprocessor, a microcontroller, or the like.

A computer apparatus comprising a memory and one or more processors having stored therein computer readable instructions that, when executed by a processor, implement the steps of a parameter numerical calculation method provided in any one of the embodiments of the present application.

Specifically, the computer device can be the terminal described above. As shown in FIG. 9, it is a schematic diagram of the internal structure of the terminal in one embodiment. The terminal includes a processor, a memory, a network interface, and a display connected through a system bus. The processor is used to provide computing and control capabilities to support the operation of the entire terminal. The memory includes a non-volatile storage medium and an internal memory. Non-volatile storage media stores operating systems, databases, and computer readable instructions. The database stores data related to a parameter numerical calculation method provided by the above various embodiments, for example, a corresponding template file, user login data, and project information of a business item may be stored. The computer readable instructions are executable by a processor for implementing a parameter value calculation method provided by the various embodiments above. The internal memory in the terminal provides a cached operating environment for operating systems, databases, and computer readable instructions in a non-volatile storage medium. The network interface can be an Ethernet card or a wireless network card, etc., for network communication with a server or other terminal. The display screen can be a touch screen, such as a capacitive screen or an electronic screen, and a corresponding command can be generated by receiving a click operation of a control applied to the touch screen.

It will be understood by those skilled in the art that the structure shown in FIG. 9 is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation on the terminal to which the solution of the present application is applied. The specific terminal may include a ratio. More or fewer components are shown in the figures, or some components are combined, or have different component arrangements.

One or more non-volatile storage media storing computer readable instructions, when executed by one or more processors, causing one or more processors to implement the parameters provided in any one embodiment of the present application The steps of the numerical calculation method.

It will be understood by those skilled in the art that all or part of the processes in the above embodiments may be implemented by computer readable instructions, which may be stored in a non-volatile manner. The computer readable storage medium, when executed by the processor, implements the flow of an embodiment of the methods described above. The storage medium may be a magnetic disk, an optical disk, a read-only memory (ROM), or the like.

The technical features of the above-described embodiments may be arbitrarily combined. For the sake of brevity of description, all possible combinations of the technical features in the above embodiments are not described. However, as long as there is no contradiction between the combinations of these technical features, All should be considered as the scope of this manual.

The above-mentioned embodiments are merely illustrative of several embodiments of the present application, and the description thereof is more specific and detailed, but is not to be construed as limiting the scope of the invention. It should be noted that a number of variations and modifications may be made by those skilled in the art without departing from the spirit and scope of the present application. Therefore, the scope of the invention should be determined by the appended claims.

Claims (20)

A parameter numerical calculation method, comprising: Receiving a selection instruction of the business item to be processed, where the selection instruction carries a corresponding item identifier; Obtaining a template file corresponding to the item identifier, where the template file includes a parameter name of the parameter to be calculated, a calculation formula, and a parameter name of the basic parameter; Obtaining a parameter value of the basic parameter according to the parameter name of the basic parameter; Writing the parameter value to an associated location in the template file associated with a location of the parameter name of the base parameter in the template file; and According to the calculation formula and the parameter value, the parameter value of the parameter to be calculated is calculated in the template file. The method according to claim 1, wherein after calculating the parameter value of the parameter to be calculated in the template file according to the calculation formula and the parameter value, the method further comprises: Generating a plan confirmation letter of the business item according to the parameter name of the basic parameter, the parameter value, and the parameter name and parameter value of the parameter to be calculated. The method according to claim 1, wherein before the obtaining the template file corresponding to the item identifier, the method further comprises: Receiving a parameter write instruction to the template file, wherein the parameter write command includes a parameter name of the basic parameter, a parameter name of the parameter to be calculated, and a parameter name of the basic parameter and a parameter name of the parameter to be calculated are set in the template file. Location information in ; Writing a parameter name of the basic parameter and a parameter name of the parameter to be calculated into a corresponding position in a template file associated with the item identifier; Obtaining a calculation formula of the parameter to be calculated associated with the item identifier; and The calculation formula is written into the template file. The method according to claim 3, wherein the writing the calculation formula into the template file comprises: Converting the calculation formula to a formula recognizable by the template file; and The converted calculation formula is written to the corresponding position in the template file. The method according to claim 1, wherein the template file is an Excel template file, and the associated location is an adjacent position of a location of the parameter name corresponding to the basic parameter in the template file. A parameter numerical calculation device includes: The instruction receiving module is configured to receive a selection instruction of the business item to be processed, where the selection instruction carries a corresponding item identifier; a template file obtaining module, configured to acquire a template file corresponding to the item identifier, where the template file includes a parameter name of the parameter to be calculated, a calculation formula, and a parameter name of the basic parameter; a parameter value writing module, configured to acquire a parameter value of the basic parameter according to a parameter name of the basic parameter; and writing the parameter value into the template file and a parameter name of the basic parameter in the template file The associated location in the location association; and The parameter value calculation module is configured to calculate a parameter value of the parameter to be calculated in the template file according to the calculation formula and the parameter value. The device according to claim 6, further comprising: The plan confirmation function generating module is configured to generate a plan confirmation letter of the business item according to the parameter name of the basic parameter, the parameter value, and the parameter name and the parameter value of the parameter to be calculated. The device according to claim 6, further comprising: a template file setting module, configured to receive a parameter write instruction to the template file, where the parameter write instruction includes a parameter name of the basic parameter, a parameter name of the parameter to be calculated, and a parameter name of the basic parameter and a parameter to be calculated The parameter name is set to location information in the template file; the parameter name of the basic parameter and the parameter name of the parameter to be calculated are written into a corresponding position in the template file associated with the item identifier; obtaining the item identifier a calculation formula of the associated parameter to be calculated; and writing the calculation formula into the template file. The apparatus according to claim 8, wherein the template file setting module is further configured to convert the calculation formula into a calculation formula recognizable by the template file; and write the converted calculation formula to a corresponding position in the template file. The apparatus according to claim 6, wherein the template file is an Excel template file, and the associated position is an adjacent position of the position of the parameter name corresponding to the basic parameter in the template file. A computer device comprising a memory and one or more processors having stored therein computer readable instructions, the computer readable instructions being executed by the one or more processors to cause the one or more The processors perform the following steps: Receiving a selection instruction of the business item to be processed, where the selection instruction carries a corresponding item identifier; Obtaining a template file corresponding to the item identifier, where the template file includes a parameter name of the parameter to be calculated, a calculation formula, and a parameter name of the basic parameter; Obtaining a parameter value of the basic parameter according to the parameter name of the basic parameter; Writing the parameter value to an associated location in the template file associated with a location of the parameter name of the base parameter in the template file; and According to the calculation formula and the parameter value, the parameter value of the parameter to be calculated is calculated in the template file. The computer apparatus according to claim 11, wherein said processor further performs the following steps when said computer readable instructions are executed: Generating a plan confirmation letter of the business item according to the parameter name of the basic parameter, the parameter value, and the parameter name and parameter value of the parameter to be calculated. The computer apparatus according to claim 11, wherein said processor further performs the following steps when said computer readable instructions are executed: Receiving a parameter write instruction to the template file, wherein the parameter write command includes a parameter name of the basic parameter, a parameter name of the parameter to be calculated, and a parameter name of the basic parameter and a parameter name of the parameter to be calculated are set in the template file. Location information in ; Writing a parameter name of the basic parameter and a parameter name of the parameter to be calculated into a corresponding position in a template file associated with the item identifier; Obtaining a calculation formula of the parameter to be calculated associated with the item identifier; and The calculation formula is written into the template file. The computer device according to claim 13, wherein the writing the calculation formula into the template file comprises: Converting the calculation formula to a formula recognizable by the template file; and The converted calculation formula is written to the corresponding position in the template file. The computer device according to claim 11, wherein the template file is an Excel template file, and the associated location is an adjacent position of a location of the parameter name corresponding to the basic parameter in the template file. One or more non-transitory computer readable storage mediums storing computer readable instructions, when executed by one or more processors, cause the one or more processors to perform the following steps: Receiving a selection instruction of the business item to be processed, where the selection instruction carries a corresponding item identifier; Obtaining a template file corresponding to the item identifier, where the template file includes a parameter name of the parameter to be calculated, a calculation formula, and a parameter name of the basic parameter; Obtaining a parameter value of the basic parameter according to the parameter name of the basic parameter; Writing the parameter value to an associated location in the template file associated with a location of the parameter name of the base parameter in the template file; and According to the calculation formula and the parameter value, the parameter value of the parameter to be calculated is calculated in the template file. The storage medium of claim 16 wherein said computer readable instructions are further executed by said processor to perform the following steps: Generating a plan confirmation letter of the business item according to the parameter name of the basic parameter, the parameter value, and the parameter name and parameter value of the parameter to be calculated. The storage medium of claim 16 wherein said computer readable instructions are further executed by said processor to perform the following steps: Receiving a parameter write instruction to the template file, wherein the parameter write command includes a parameter name of the basic parameter, a parameter name of the parameter to be calculated, and a parameter name of the basic parameter and a parameter name of the parameter to be calculated are set in the template file. Location information in ; Writing a parameter name of the basic parameter and a parameter name of the parameter to be calculated into a corresponding position in a template file associated with the item identifier; Obtaining a calculation formula of the parameter to be calculated associated with the item identifier; and The calculation formula is written into the template file. The storage medium according to claim 18, wherein the writing the calculation formula to the template file comprises: Converting the calculation formula to a formula recognizable by the template file; and The converted calculation formula is written to the corresponding position in the template file. The storage medium according to claim 19, wherein the template file is an Excel template file, and the associated location is an adjacent position of a location of the parameter name corresponding to the basic parameter in the template file.

Images