CN107798459A - Parameter values computational methods, device, storage medium and computer equipment - Google Patents
Parameter values computational methods, device, storage medium and computer equipment Download PDFInfo
- Publication number
- CN107798459A CN107798459A CN201710626231.7A CN201710626231A CN107798459A CN 107798459 A CN107798459 A CN 107798459A CN 201710626231 A CN201710626231 A CN 201710626231A CN 107798459 A CN107798459 A CN 107798459A
- Authority
- CN
- China
- Prior art keywords
- parameter
- template file
- calculated
- name
- basic
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0631—Resource planning, allocation, distributing or scheduling for enterprises or organisations
- G06Q10/06315—Needs-based resource requirements planning or analysis
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/04—Trading; Exchange, e.g. stocks, commodities, derivatives or currency exchange
Landscapes
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Engineering & Computer Science (AREA)
- Economics (AREA)
- Strategic Management (AREA)
- General Business, Economics & Management (AREA)
- Marketing (AREA)
- Development Economics (AREA)
- Entrepreneurship & Innovation (AREA)
- Physics & Mathematics (AREA)
- Finance (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Accounting & Taxation (AREA)
- Educational Administration (AREA)
- Technology Law (AREA)
- Game Theory and Decision Science (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Stored Programmes (AREA)
Abstract
The present invention relates to a kind of parameter values computational methods, device, storage medium and computer equipment, methods described includes:The selection instruction to pending business item is received, described choose in instruction carries corresponding project label;Corresponding with project label template file is obtained, the parameter name of the parameter name of parameter to be calculated, calculation formula and basic parameter is included in the template file;The parameter values of the basic parameter are obtained according to the parameter name of the basic parameter;At the relative position that position in the parameter values write-in template file with the parameter name of the basic parameter in the template file is associated;According to the calculation formula and parameter values, the parameter values with the parameter to be calculated are calculated in template file.Above-mentioned parameter numerical computation method, device, storage medium and computer equipment can improve the computational efficiency for the parameter values that calculating parameter is treated in business item.
Description
Technical field
The present invention relates to technical field of information processing, is situated between more particularly to a kind of parameter values computational methods, device, storage
Matter and computer equipment.
Background technology
For financial product, such as insurance, fund etc., the huge number of product, the ginseng such as the income of different products, remuneration
The calculation of number numerical value also has certain difference.It is difficult to form a set of general calculation formula to calculate the receipts of these products
The calculative parameter values such as benefit, administration fee.
Therefore, the computational methods of traditional parameter values, both for every kind of product, a set of computing system is correspondingly arranged,
So that it is used alone.The computing system being correspondingly arranged is selected according to corresponding product, institute is calculated according to the computing system
The parameter values that need to be calculated.And when product category is more, and identical product is different in the period of, the calculation of its parameter values
Also can be varied from, therefore, the computing system of required setting is also more, and workload is also huge, less efficient.
The content of the invention
Based on this, it is necessary to for above-mentioned technical problem, there is provided a kind of to improve parameter to be calculated in business item
Parameter values computational methods, device, storage medium and the computer equipment of the computational efficiency of parameter values.
A kind of parameter values computational methods, methods described include:Receive the selection instruction to pending business item, institute
State in selection instruction and carry corresponding project label;Obtain template file corresponding with the project label, the template file
In include the parameter name of the parameter name of parameter to be calculated, calculation formula and basic parameter;According to the basic parameter
Parameter name obtains the parameter values of the basic parameter;By the parameter values write in the template file with it is described basic
At the relative position of position association of the parameter name of parameter in the template file;According to the calculation formula and parameter number
Value, calculates the parameter values with the parameter to be calculated in template file.
In one of the embodiments, calculated described according to the calculation formula and parameter values in template file
Go out with after the parameter values of the parameter to be calculated, in addition to:According to the parameter name of the basic parameter, parameter values with
And parameter name, the parameter values of parameter to be calculated generate the plan confirmation of the business item.
In one of the embodiments, before acquisition template file corresponding with the project label, in addition to:
Receive and the parameter read-in of template file is instructed, the parameter read-in instruction includes the parameter name, to be calculated of basic parameter
The parameter name of the parameter name and parameter to be calculated of the parameter name of parameter and the basic parameter is arranged on template text
Positional information in part;By the write-in of the parameter name of the parameter name of the basic parameter and parameter to be calculated and the item target
Correspondence position in the template file of sensible association;The calculating for obtaining the to be calculated parameter associated with the project label is public
Formula;The calculation formula is write in the template file.
In one of the embodiments, it is described to write the calculation formula in the template file, including:By the meter
Calculate formula and be converted to the recognizable calculation formula of the template file;Calculation formula after conversion is write in the template file
Correspondence position.
In one of the embodiments, the template file is Excel template file, and the relative position is corresponding basic
The adjacent position of position of the parameter name of parameter in the template file.
A kind of parameter values computing device, described device include:Command reception module is chosen, for receiving to pending
The selection instruction of business item, described choose in instruction carry corresponding project label;Template file acquisition module, for obtaining
Template file corresponding with the project label, parameter name, the calculation formula of parameter to be calculated are included in the template file
And the parameter name of basic parameter;Parameter values writing module, for obtaining institute according to the parameter name of the basic parameter
State the parameter values of basic parameter;The parameter values are write into the parameter name in the template file with the basic parameter
At the relative position of position association in the template file;Parameter values computing module, for according to the calculation formula
And parameter values, the parameter values with the parameter to be calculated are calculated in template file.
In one of the embodiments, described device also includes:Plan confirmation generation module, for according to described basic
The parameter name of parameter, the parameter name of parameter values and parameter to be calculated, parameter values generate the meter of the business item
Draw confirmation.
In one of the embodiments, described device also includes:Template file setup module, for receiving to template file
Parameter read-in instruction, parameter read-in instruction includes parameter name, the parameter name of parameter to be calculated of basic parameter
And the parameter name of the basic parameter and the parameter name of parameter to be calculated are arranged on the positional information in template file;
The parameter name of the parameter name of the basic parameter and parameter to be calculated is write to the template associated with the project label
Correspondence position in file;Obtain the calculation formula of the to be calculated parameter associated with the project label;Public affairs are calculated by described
Formula is write in the template file.
A kind of computer-readable recording medium, is stored thereon with computer instruction, and the instruction is realized when being executed by processor
The step of parameter values computational methods in above-mentioned each embodiment.
A kind of computer equipment, including memory, processor and storage can be run on a memory and on a processor
Computer program, the step of the parameter values computational methods in above-mentioned each embodiment is realized during the computing device described program
Suddenly
The parameter values computational methods that the present embodiment provides, instructed by the selection received to pending business item,
Choose in instruction and carry corresponding project label;Template file corresponding with project label is obtained, is included in template file and waits to count
Calculate the parameter name of the parameter name of parameter, calculation formula and basic parameter;Obtained according to the parameter name of the basic parameter
The parameter values of basic parameter;By the parameter name in parameter values write-in template file with basic parameter in template file
At the relative position of position association;Further according to calculation formula and parameter values, calculated in template file and parameter to be calculated
Parameter values.Due to being provided with corresponding template file for every kind of business item, corresponding be somebody's turn to do is contained in the template file
The parameter name of the parameter name of calculating parameter, calculation formula and basic parameter, so as to obtain the ginseng of basic parameter
After number numerical value, then the parameter number of the parameter to be calculated can be calculated in template file according to the calculation formula of parameter to be calculated
Value, realizes the calculating to parameter to be calculated corresponding to selected business item, it also avoid independent for every kind of business item
A set of computing system is set, reduces the workload of system design, also improves the calculating for the parameter values for treating calculating parameter
Efficiency.
Brief description of the drawings
Fig. 1 is the applied environment figure of parameter values computational methods in one embodiment;
Fig. 2 is the flow chart of parameter values computational methods in one embodiment;
The flow chart for the step of Fig. 3 is the setting to template file in one embodiment;
Fig. 4 is the schematic diagram at the setting interface of template file in one embodiment;
Fig. 5 is the schematic diagram of the partial parameters of template file in one embodiment;
Fig. 6 is the structured flowchart of parameter values computing device in one embodiment;
Fig. 7 is the structured flowchart of parameter values computing device in another embodiment;
Fig. 8 is the structured flowchart of parameter values computing device in another embodiment;
Fig. 9 is the cut-away view of terminal in one embodiment.
Embodiment
In order to make the purpose , technical scheme and advantage of the present invention be clearer, it is right below in conjunction with drawings and Examples
The present invention is further elaborated.It should be appreciated that specific embodiment described herein is only to explain the present invention, not
For limiting the present invention.
The parameter values computational methods that the embodiment of the present invention is provided can be applied in environment as shown in Figure 1.With reference to figure 1
Shown, for terminal 110 with server 120 by network connection, terminal 110 includes but is not limited to mobile phone, handheld device, flat board electricity
Brain, personal digital assistant or wearable device etc. any one.Terminal can receive the selection instruction to pending business item, choosing
Corresponding project label is carried in instruction fetch;Template file corresponding with project label is obtained, is included in template file to be calculated
The parameter name of the parameter name of parameter, calculation formula and basic parameter.Wherein, the template file can be local from terminal 110
Obtain, can also be to be obtained from server 120.Terminal 110 obtains basic ginseng yet further still according to the parameter name of basic parameter
Several parameter values;By the parameter name in parameter values write-in template file with the basic parameter of basic parameter in template file
In position association relative position at;According to calculation formula and parameter values, calculated in template file and ginseng to be calculated
Several parameter values, it is achieved thereby that the calculating to parameter values.
In one embodiment, as shown in Figure 2, there is provided a kind of computational methods of parameter values computational methods, this method
It can be applied in terminal as shown in Figure 1, specifically comprise the following steps:
Step S202, the selection instruction to pending business item is received, chooses in instruction and carries corresponding item target
Know.
In the present embodiment, terminal can show the selection interface of pending business item, and detect user to therein one
The selection operation of individual or multiple pending business items and trigger selection instruction.Wherein, the business item is to need to carry out
The various financial products that parameter values calculate, or multiple financial products it is combined into investment combination.For example, the business
Project can be the arbitrary financial products such as certain draft, stock, futures, bond, insurance.Project label is corresponding for unique mark
Business item, it can be made up of spcial characters such as the letter of presetting digit capacity, numeral or underscores.
In one embodiment, the logging request of user can be received in terminal, in the logging request carry login account with
And the log-on message such as login password, after checking logins successfully, the industry associated with the login account can be obtained from server
Business project, and acquired pending business item is shown on interface is chosen so that each user can its institute of alignment processing
Responsible business item.Specifically, the item argument title of each business item, bullets, project mandator etc. can be shown
Brief information.
Step S204, template file corresponding with project label is obtained, the parameter of parameter to be calculated is included in template file
The parameter name of title, calculation formula and basic parameter.
In the present embodiment, multiple template file can be prestored, and there is provided each project label and one of mould
The corresponding relation of plate file, so as to be template file corresponding to the setting of each business item.The template file is for writing certain
A kind of or the calculating factor of multi-traffic project and the general file of calculating parameter numerical value.Specifically, a template file can
Corresponding to a specific business item, multiple similar business items are also corresponded to so that multiple similar projects share
Same template file.In one embodiment, template file can be an Excel file, by the mould for setting Excel types
Plate file, the convenience that parameter values calculating is carried out in template file can be improved.
Wherein, basic parameter is that the parameter values in business item are existing parameter, including the parameter of time class, interest rate
The parameter of class and the parameter of fund class etc..For example include for a certain fund or the business item of futures class, its basic parameter
Meter puies forward section starting date, meter carries section deadline, end of term Net asset value, has counted and puies forward fixed administration fee, the administration fee upper limit, accrued carries
It is total etc. that performance based compensation, the end of term should calculate the amount of money.Parameter to be calculated refers to need the ginseng for calculating parameter values in business item
Number.Calculation formula is each for characterizing for the calculation formula for the parameter values for calculating parameter to be calculated, the calculation formula
Logical relation between parameter to be calculated and one or more basic parameters, pass through the calculation formula and the parameter number of basic parameter
Value, the parameter values of corresponding parameter to be calculated can be calculated.
It should be understood that the quantity of the basic parameter and parameter to be calculated may include it is multiple, in different business items
Basic parameter and parameter to be calculated are not necessarily identical, and corresponding calculation formula is also not necessarily identical.Identical parameter may be at certain
It is basic parameter in one business item, but is then parameter to be calculated in another business item.
By template file corresponding to being set for each item business item, corresponding traffic item is provided with the template file
The title of purpose basic parameter, the title and calculation formula of parameter to be calculated.So that according to the template file i.e. achievable pair
The calculating of the parameter values of the parameter to be calculated of corresponding service project, without a set of come independent design for every kind of business item
The computing system of parameter values.
Step S206, the parameter values of basic parameter are obtained according to the parameter name of basic parameter.
In the present embodiment, terminal can directly receive the parameter values of user's input, identify basic corresponding to the parameter values
The parameter name of parameter, and then the parameter values are arranged to the parameter values of the basic parameter.Or terminal can also be according to this
Project label, according to the parameter name of the basic parameter in the business item of selection, from the project information of corresponding business item
Inquire the parameter values of corresponding basic parameter.
Step S208, parameter values are write into the position in template file with the parameter name of basic parameter in template file
Put at the relative position of association.
In the present embodiment, the position of the parameter name and parameter values of each parameter in template file is pre-set
Incidence relation.Specifically, the incidence relation between the position can be relative position relation, i.e., the parameter values of each parameter are in mould
Position in plate file, it is fixed relative to position of the parameter name of the parameter in template file.In one embodiment
In, terminal can receive parameter values write instruction, according to the parameter values write instruction, obtain the parameter name of each basic parameter
Claim the positional information being in the template file, and according to the incidence relation, calculate corresponding parameter values in template text
Relative position in part, and write the relative position.By the incidence relation between this position, parameter name is being determined
Behind position, it may be determined that corresponding position of the parameter values in template file, i.e., above-mentioned relative position.
In one embodiment, the relative position is position of the parameter name of corresponding basic parameter in template file
Adjacent position.Wherein, adjacent position can be parameter name position all around in any position, specifically, can be
In template file, the position of the first cell on the right side of parameter name position.
Step S210, according to calculation formula and parameter values, the parameter with parameter to be calculated is calculated in template file
Numerical value.
In the present embodiment, terminal can call the logical operation function of template file itself, wherein involved basic of identification
Parameter and computation rule, the parameter values of corresponding basic parameter are obtained, and utilize the self-contained calculating work(of the template file
Can, according to corresponding computation rule, the parameter values of corresponding parameter to be calculated are calculated, the parameter values are write into template text
In part, the calculating to parameter values is realized.
In one embodiment, when the template file is Excel file, the method that can call Apache POI will be counted
Cell of the formula write-in containing formula is calculated, sheet pages allowed where the template file performs the calculation formula, calculate business number
According to.Wherein, POI is the open source code function storehouse of Apache Software Foundation, and POI provides API to java applet to Microsoft
The function that Office forms archives are read and write.
The parameter values computational methods that the present embodiment provides, instructed by the selection received to pending business item,
Choose in instruction and carry corresponding project label;Template file corresponding with project label is obtained, is included in template file and waits to count
Calculate the parameter name of the parameter name of parameter, calculation formula and basic parameter;Obtain the parameter values of basic parameter;By parameter
At the relative position of position association in numerical value write-in template file with corresponding parameter name in template file;Further according to calculating
Formula and parameter values, the parameter values with parameter to be calculated are calculated in template file.Due to being set for every kind of business item
Put corresponding template file, contained in the template file corresponding to the parameter name of the calculating parameter, calculation formula and
The parameter name of basic parameter, then can be according to the meter of parameter to be calculated so as to after the parameter values of basic parameter are obtained
The parameter values that formula calculates the parameter to be calculated in template file are calculated, are realized to being treated corresponding to selected business item
The calculating of calculating parameter, it also avoid being independently arranged a set of computing system for every kind of business item, reduce system design
Workload, also improve the computational efficiency for the parameter values for treating calculating parameter.
In one embodiment, after step S210, in addition to:According to the parameter name of basic parameter, parameter values
And parameter name, the plan confirmation of parameter values generation business item of parameter to be calculated.
In the present embodiment, plan confirmation is for relevant peoples such as the business personnels, keeper or client to business item
Member carries out the file of the brief information displaying of business item, and the brief information includes the parameter information of corresponding business item.Terminal
In can prestore it is corresponding plan confirmation template file, and further be provided with every kind of business item calculate confirmation
Needed for the parameter information that loads, the parameter information includes the parameter name of one or more above-mentioned basic parameters, parameter number
The parameter name and parameter values of value and parameter to be calculated.Specifically, the confirmation can be pdf document.
In one embodiment, terminal can also receive is instructed to the generation for planning confirmation, and next life is instructed according to the generation
Into the plan confirmation.Terminal can provide the generation interface of plan confirmation, by detecting the life acted on the generation interface
Into generation plan confirmations such as the operating of virtual key, the voice of default plan confirmation generation or default generation gestures
Generation instruction.And instructed according to the generation, the parameter information needed for corresponding business item is read, should by the write-in of each parameter information
Plan the corresponding position in confirmation, generation includes the plan confirmation of required parameter information.Specifically, can be directed to every kind of
Each parameter of business item, sets whether the parameter needs the write-in of write-in plan confirmation to mark.Terminal is detectable corresponding
Each parameter of business item marks with the presence or absence of the write-in for needing to write plan confirmation, will detect the presence of write-in mark
Parameter parameter name and parameter values write the plan confirmation.
In the present embodiment, by further generating plan confirmation, the information management to business item can further improve
Convenience.
In one embodiment, step S204 includes:The project category belonging to the project label is identified, is obtained and affiliated
Template file corresponding to project category.
In the present embodiment, project category has also further been preset, project category may include multiple, draft described above, stock
The financial product of several big types such as ticket, futures, bond, insurance, each type of financial product can be further subdivided into a variety of industry
Business project.The classification for the business item of a template file that the project category is that what is be divided share.Project category can basis
The project label is made a distinction, and the project category belonging to the project is may recognize that by the project label, and then according to default
The corresponding relation of project category and template file, obtain the template file of the required business item for carrying out parameter values calculating.
In one embodiment, the above method is before step S204, in addition to the step of setting to template file.Such as
Shown in Fig. 3, the step includes:
Step S302, receives the parameter read-in instruction to template file, and parameter read-in instructs the ginseng for including basic parameter
Several title, the parameter name of parameter to be calculated and the parameter names of basic parameter and the parameter name of parameter to be calculated are set
Positional information in template file.
In the present embodiment, terminal can further provide for the setting interface of template file, and receive each ginseng of user's input
Several parameter informations, when detecting the operation of the parameter read-in virtual key acted on the interface, generation parameter read-in refers to
Order, the parameter information of each parameter inputted in parameter read-in instruction comprising user.Specifically, the parameter information includes base
The parameter of the parameter name of this parameter, the parameter name of the parameter name of parameter to be calculated and basic parameter and parameter to be calculated
Title is arranged on the positional information in template file.Wherein, positional information is written into template file including the parameter name
Cell where row and column.
For example, as shown in figure 4, the schematic diagram at the setting interface for the template file in one embodiment.The interface
In provide the parameter name for containing multiple basic parameters and parameter to be calculated, different parameters is applicable to one or more
The business item of type so that the convenience of template file making can be improved.Terminal can receive each parameter of user's input
The positional information for the cell that title is in template file, it can such as receive the residing row and column of user's input.Further, also
Offer whether be necessary option to parameter listed by interface, when user selection for be when, then receive to this " it is determined that " button
Clicking operation after, the corresponding parameter name is write in template file to be created, the list on the position of place row and column
In first lattice.
Step S304, the parameter name of the parameter name of basic parameter and parameter to be calculated is write related to project label
Correspondence position in the template file of connection.
Specifically, the correspondence position is the cell of set place row and column, can be by the parameter name of the basic parameter
Claim and the parameter name of parameter to be calculated is write in template file, in the cell of set corresponding row and column.
As shown in figure 5, the schematic diagram for the partial parameters of template file in one embodiment.It can detect to Fig. 4 institutes
Show " it is determined that " after the clicking operation of button, trigger parameter write instruction.It is and to be written entrained by during the parameter read-in is instructed
In the parameter name write-in template file entered." meter puies forward section starting date " is such as write in corresponding position, " meter proposes section cut-off
Day ", " end of term Net asset value ", " counted and proposed fixed administration fee ", " meter carries performance based compensation ", " end of term should calculate the amount of money and add up to ".
Step S306, obtain the calculation formula of the to be calculated parameter associated with project label;Calculation formula is write into mould
In plate file.
Specifically, the calculation formula that the calculation formula can be edited by user, can also be the project letter of corresponding business item
Calculation formula included in breath.When the calculation formula edited for user, terminal can also receive user and treat calculating parameter
The edit operation of calculation formula, and parse the calculation formula set by user.When for the calculation formula included in project information
When, terminal can inquire about the information with the presence or absence of calculation formula in project information, if in the presence of directly can obtaining in project information
Comprising the parameter to be calculated calculation formula.Terminal can further identify the parameter of the calculation formula, and the parameter is to treat
Calculating parameter, and the correspondence position being further loaded onto the calculation formula in template file.The correspondence position can be with waiting to count
The relative position of the parameter name position of parameter is calculated, such as writes on the adjacent position of the parameter name position.
In one embodiment, the cell of calculation formula and/or corresponding parameter place to be calculated will can be had been written to
Position mark is set, it is parameter to be calculated that the mark, which is used to identify corresponding parameter,.Specifically, the mark can be color mark
Note, as by the default color of unit case marking where the parameter name or parameter values of the parameter to be calculated identified, make
Basic parameter and parameter to be calculated can intuitively be distinguished according to the color marked by obtaining.
In one embodiment, calculation formula write-in template file is included:Calculation formula is converted into template file
Recognizable calculation formula;By the correspondence position in the calculation formula write-in template file after conversion.
In the present embodiment, terminal can be parsed further to acquired calculation formula, whether detect the calculation formula
The calculation formula that can recognize that for template file, if it is not, then according to computation rule defined in template file to acquired calculating
Formula is converted, and to change into the recognizable calculation formula of the template file, the calculation formula after conversion is write into template text
In part.
For example, the template file is Excel file, and calculating parameter is with parameter name in acquired calculation formula
Come what is identified, or it is what is identified for representing the parameter character of the parameter name, then may recognize that in the calculation formula
After parameter represented by the parameter character or parameter name of parameter to be calculated and/or basic parameter, the ginseng for the parameter is calculated
Positional information set by number numerical value, and the parameter character or parameter name are substituted with the positional information, and the calculating is public
Calculating logic represented by formula is converted into the calculating logic that Excel file can identify, should by the calculation formula write-in after conversion
In cell where the parameter values of parameter to be calculated corresponding to calculation formula so that reading calculating in the Excel
After the numerical value of basic parameter involved by formula, the parameter values of parameter to be calculated are directly calculated according to the calculating logic.
A certain business item is such as directed to, the calculation formula that the original performance based compensation of parameter to be calculated be present:Original performance based compensation
Ratio is put forward based on=(end of term Net asset value-fund disengaging is by benchmark net value of capital invested) * performance based compensations;Or it isIts
In, parameter character A, B, C and p represent original performance based compensation, end of term Net asset value, fund disengaging by benchmark net value of capital invested respectively
And performance based compensation meter puies forward ratio.Then server can get parms respectively original performance based compensation, end of term Net asset value, fund disengaging
Position of the parameter values of ratio in the cell of template file, such as Fig. 4 are carried based on benchmark net value of capital invested and performance based compensation
It is shown, and the calculation formula can be converted into "=(D5-F5) * D10 ", and the parameter values institute of the original performance based compensation of write parameters
Opening position, it is achieved thereby that by after conversion calculation formula write-in template file in so that getting the above-mentioned end of term
After Net asset value, fund disengaging put forward the parameter values of ratio based on benchmark net value of capital invested and performance based compensation, directly using this
The computing function of Excel file itself, calculate the parameter values of the original performance based compensation of parameter.
In one embodiment, it can detect whether the configured template file associated with the project label be present,
If so, then writing the parameter information in already present template file, otherwise, a new template file can be created, and establish
The incidence relation of the template file and project label, the parameter information is write in created template file.
In the present embodiment, by above-mentioned step, the convenience of template file making can be improved, and then can improve to industry
The convenience that the parameter values of the parameter to be calculated of business project calculate.
In one embodiment, as shown in Figure 6, there is provided a kind of parameter values computing device, the device include:
Command reception module 602 is chosen, for receiving the selection instruction to pending business item, chooses in instruction and takes
With corresponding project label.
Template file acquisition module 604, for obtaining template file corresponding with project label, include and treat in template file
The parameter name of the parameter name of calculating parameter, calculation formula and basic parameter.
Parameter values writing module 606, for obtaining the parameter values of basic parameter according to the parameter name of basic parameter;
The relative position that position in parameter values write-in template file with the parameter name of basic parameter in template file is associated
Place.
Parameter values computing module 608, for according to calculation formula and parameter values, calculating and treating in template file
The parameter values of calculating parameter.
In one embodiment, as shown in Figure 7, there is provided another parameter values computing device, the device also include:
Plan confirmation generation module 610, for the parameter name according to basic parameter, parameter values and ginseng to be calculated
The plan confirmation of several parameter name, parameter values generation business item.
In one embodiment, as shown in Figure 8, there is provided another parameter values computing device, the device also include:
Template file setup module 601, the parameter read-in for receiving to template file instruct, and are wrapped in parameter read-in instruction
Include parameter name, the parameter name of parameter to be calculated and the parameter name of basic parameter of basic parameter and parameter to be calculated
Parameter name is arranged on the positional information in template file;By the parameter name of the parameter name of basic parameter and parameter to be calculated
Claim the correspondence position write in the template file associated with project label;Obtain the to be calculated parameter associated with project label
Calculation formula;Calculation formula is write in template file.
In one embodiment, template file setup module 601 is additionally operable to calculation formula being converted to template file and can known
Other calculation formula;By the correspondence position in the calculation formula write-in template file after conversion.
In one embodiment, template file is Excel template file, and relative position is the parameter name of corresponding basic parameter
Claim the adjacent position of the position in template file.
Modules in above-mentioned parameter numerical computations device can come real fully or partially through software, hardware and combinations thereof
It is existing.Above-mentioned each module can in the form of hardware be embedded in or independently of in the processor in terminal, can also store in a software form
In memory in terminal, operation corresponding to above modules is performed in order to which processor calls.The processor can be
CPU (CPU), microprocessor, single-chip microcomputer etc..
In one embodiment, there is provided a kind of computer-readable recording medium, be stored thereon with computer instruction, this refers to
The step of order realizes a kind of parameter values computational methods that the various embodiments described above are provided when being executed by processor.
Specifically, following steps are realized when the instruction is executed by processor:Receive the selection to pending business item
Instruction, choose in instruction and carry corresponding project label;Template file corresponding with project label is obtained, is included in template file
The parameter name of the parameter name of parameter to be calculated, calculation formula and basic parameter;Obtained according to the parameter name of basic parameter
Take the parameter values of basic parameter;By the parameter name in parameter values write-in template file with basic parameter in template file
Position association relative position at;According to calculation formula and parameter values, calculated in template file and parameter to be calculated
Parameter values.
In one embodiment, according to calculation formula and parameter values, calculated in template file and ginseng to be calculated
After several parameter values, the instruction also realizes following steps when being executed by processor:According to the parameter name of basic parameter, ginseng
The plan confirmation of the parameter name of number numerical value and parameter to be calculated, parameter values generation business item.
In one embodiment, before template file corresponding with project label is obtained, the instruction is executed by processor
When also realize following steps:Receive and the parameter read-in of template file is instructed, parameter read-in instructs the ginseng for including basic parameter
Several title, the parameter name of parameter to be calculated and the parameter names of basic parameter and the parameter name of parameter to be calculated are set
Positional information in template file;By the write-in of the parameter name of the parameter name of basic parameter and parameter to be calculated and item target
Correspondence position in the template file of sensible association;Obtain the calculation formula of the to be calculated parameter associated with project label;Will
In calculation formula write-in template file.
In one embodiment, that is realized when the instruction is executed by processor writes calculation formula in template file
Step, including:Calculation formula is converted into the recognizable calculation formula of template file;Calculation formula after conversion is write into template
Correspondence position in file.
In one embodiment, template file is Excel template file, and relative position is the parameter name of corresponding basic parameter
Claim the adjacent position of the position in template file.
In one embodiment, there is provided a kind of computer equipment, including memory, processor and storage are on a memory
And the computer program that can be run on a processor, the seed ginseng that the various embodiments described above are provided is realized during computing device program
The step of number numerical computation method.
Specifically, the computer equipment can be above-mentioned terminal.As shown in figure 9, the inside for terminal in one embodiment
Structural representation.The terminal includes but is not limited to desktop computer, mobile phone, tablet personal computer or portable notebook etc..The terminal includes
Processor, memory, network interface and the display screen connected by system bus.Wherein, the processor is used to provide calculating
And control ability, support the operation of whole terminal.Memory may include magnetic disc, CD, read-only memory (Read-Only
Memory, ROM) etc. non-volatile memory medium, or random access memory (Random-Access-Memory, RAM) etc., use
In data storage, instruction code etc..At least one computer executable instructions are stored on memory, the computer executable instructions
It can be executed by processor, to realize the parameter values computational methods provided in each embodiment of the application.Network interface can be
Ethernet card or wireless network card etc., for carrying out network service with server or other terminals.Display screen can be touch-screen, than
Such as it is capacitance plate or electrical screen, the clicking operation of the control of the touch screen display can be acted on by reception, generation is corresponding
Instruction.
In one embodiment, memory includes non-volatile memory medium and built-in storage.Non-volatile memory medium
It is stored with operating system, database and computer executable instructions.It is stored with the database for each implementation more than realizing
A kind of data for parameter values computational methods correlation that example is provided, for example corresponding template file, user's login can be stored with
Project information of data and business item etc..The computer executable instructions can performed by processor, for realize with
A kind of parameter values computational methods that upper each embodiment is provided.Built-in storage in terminal is in non-volatile memory medium
Operating system, database and computer executable instructions the running environment of cache is provided.Those skilled in the art can be with
Understand, the block diagram of the structure, the only part-structure related to application scheme that are shown in Fig. 9, do not form to the application
The restriction for the terminal that scheme is applied thereon, specific terminal can include than more or less parts shown in figure, or
Person combines some parts, or is arranged with different parts.
In one embodiment, following steps are realized during the computing device program:Receive to pending business item
Selection instruction, choose instruction in carry corresponding project label;Obtain template file corresponding with project label, template file
In include the parameter name of the parameter name of parameter to be calculated, calculation formula and basic parameter;According to the parameter of basic parameter
The parameter values of name acquiring basic parameter;By the parameter name in parameter values write-in template file with basic parameter in template
At the relative position of position association in file;According to calculation formula and parameter values, calculate and wait to count in template file
Calculate the parameter values of parameter.
In one embodiment, according to calculation formula and parameter values, calculated in template file and ginseng to be calculated
Following steps are also realized after several parameter values, during the computing device program:According to the parameter name of basic parameter, parameter
The plan confirmation of the parameter name of numerical value and parameter to be calculated, parameter values generation business item.
In one embodiment, before corresponding with project label template file is obtained, during the computing device program
Also realize following steps:Receive and the parameter read-in of template file is instructed, parameter read-in instructs the parameter for including basic parameter
The parameter name of title, the parameter name of the parameter name of parameter to be calculated and basic parameter and parameter to be calculated is arranged on
Positional information in template file;By the write-in of the parameter name of the parameter name of basic parameter and parameter to be calculated and project label
Correspondence position in associated template file;Obtain the calculation formula of the to be calculated parameter associated with project label;Will meter
Calculate in formula write-in template file.
In one embodiment, the step for writing calculation formula in template file realized during the computing device program
Suddenly, including:Calculation formula is converted into the recognizable calculation formula of template file;By the calculation formula write-in template text after conversion
Correspondence position in part.
In one embodiment, template file is Excel template file, and relative position is the parameter name of corresponding basic parameter
Claim the adjacent position of the position in template file.
One of ordinary skill in the art will appreciate that realize all or part of flow in above-described embodiment method, being can be with
The hardware of correlation is instructed to complete by computer program, described program can be stored in a non-volatile computer and can be read
In storage medium, the program is upon execution, it may include such as the flow of the embodiment of above-mentioned each method.Wherein, described storage is situated between
Matter can be magnetic disc, CD, read-only memory (Read-Only Memory, ROM) etc..
Each technical characteristic of embodiment described above can be combined arbitrarily, to make description succinct, not to above-mentioned reality
Apply all possible combination of each technical characteristic in example to be all described, as long as however, the combination of these technical characteristics is not deposited
In contradiction, the scope that this specification is recorded all is considered to be.
Embodiment described above only expresses the several embodiments of the present invention, and its description is more specific and detailed, but simultaneously
Can not therefore it be construed as limiting the scope of the patent.It should be pointed out that come for one of ordinary skill in the art
Say, without departing from the inventive concept of the premise, various modifications and improvements can be made, these belong to the protection of the present invention
Scope.Therefore, the protection domain of patent of the present invention should be determined by the appended claims.
Claims (10)
1. a kind of parameter values computational methods, it is characterised in that methods described includes:
The selection instruction to pending business item is received, described choose in instruction carries corresponding project label;
Obtain corresponding with project label template file, included in the template file parameter to be calculated parameter name,
The parameter name of calculation formula and basic parameter;
The parameter values of the basic parameter are obtained according to the parameter name of the basic parameter;
By the parameter name in the parameter values write-in template file with the basic parameter in the template file
Position association relative position at;
According to the calculation formula and parameter values, the parameter values with the parameter to be calculated are calculated in template file.
2. according to the method for claim 1, it is characterised in that described according to the calculation formula and parameter values,
Calculated in template file with after the parameter values of the parameter to be calculated, in addition to:
According to the parameter name of the basic parameter, the parameter name of parameter values and parameter to be calculated, parameter values generation
The plan confirmation of the business item.
3. according to the method for claim 1, it is characterised in that obtain template text corresponding with the project label described
Before part, in addition to:
Receive and the parameter read-in of template file is instructed, the parameter read-in instruction includes the parameter name of basic parameter, treated
The parameter name of the parameter name and parameter to be calculated of the parameter name of calculating parameter and the basic parameter is arranged on mould
Positional information in plate file;
The parameter name of the parameter name of the basic parameter and parameter to be calculated is write associated with the project label
Correspondence position in template file;
Obtain the calculation formula of the to be calculated parameter associated with the project label;
The calculation formula is write in the template file.
4. according to the method for claim 3, it is characterised in that described that the calculation formula is write into the template file
In, including:
The calculation formula is converted into the recognizable calculation formula of the template file;
The correspondence position that calculation formula after conversion is write in the template file.
5. according to the method for claim 1, it is characterised in that the template file is Excel template file, the association
Position is the adjacent position of position of the parameter name of corresponding basic parameter in the template file.
6. a kind of parameter values computing device, it is characterised in that described device includes:
Command reception module is chosen, for receiving the selection instruction to pending business item, described choose in instruction carries
Corresponding project label;
Template file acquisition module, for obtaining template file corresponding with the project label, included in the template file
The parameter name of the parameter name of parameter to be calculated, calculation formula and basic parameter;
Parameter values writing module, for obtaining the parameter number of the basic parameter according to the parameter name of the basic parameter
Value;By the parameter name in the parameter values write-in template file with the basic parameter in the template file
At the relative position of position association;
Parameter values computing module, for according to the calculation formula and parameter values, calculated in template file with it is described
The parameter values of parameter to be calculated.
7. device according to claim 6, it is characterised in that described device also includes:
Plan confirmation generation module, for the parameter name according to the basic parameter, parameter values and parameter to be calculated
Parameter name, parameter values generate the plan confirmation of the business item.
8. device according to claim 6, it is characterised in that described device also includes:
Template file setup module, the parameter read-in for receiving to template file instruct, and the parameter read-in instruction includes
The parameter name of basic parameter, the parameter name of the parameter name of parameter to be calculated and the basic parameter and parameter to be calculated
Parameter name be arranged on positional information in template file;By the parameter name of the basic parameter and parameter to be calculated
The correspondence position that parameter name is write in the template file associated with the project label;Obtain related to the project label
The calculation formula of the parameter to be calculated of connection;The calculation formula is write in the template file.
9. a kind of computer-readable recording medium, is stored thereon with computer instruction, it is characterised in that the instruction is held by processor
The step of method any one of claim 1 to 5 is realized during row.
10. a kind of computer equipment, including memory, processor and storage are on a memory and the meter that can run on a processor
Calculation machine program, it is characterised in that method any one of claim 1 to 6 is realized during the computing device described program
The step of.
Priority Applications (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710626231.7A CN107798459A (en) | 2017-07-27 | 2017-07-27 | Parameter values computational methods, device, storage medium and computer equipment |
PCT/CN2018/088564 WO2019019789A1 (en) | 2017-07-27 | 2018-05-27 | Parameter value calculation method and apparatus, storage medium and computer device |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710626231.7A CN107798459A (en) | 2017-07-27 | 2017-07-27 | Parameter values computational methods, device, storage medium and computer equipment |
Publications (1)
Publication Number | Publication Date |
---|---|
CN107798459A true CN107798459A (en) | 2018-03-13 |
Family
ID=61531117
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201710626231.7A Pending CN107798459A (en) | 2017-07-27 | 2017-07-27 | Parameter values computational methods, device, storage medium and computer equipment |
Country Status (2)
Country | Link |
---|---|
CN (1) | CN107798459A (en) |
WO (1) | WO2019019789A1 (en) |
Cited By (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN108573453A (en) * | 2018-03-30 | 2018-09-25 | 平安科技(深圳)有限公司 | Configuration method, device, computer equipment and the storage medium of insurance products computation model |
WO2019019789A1 (en) * | 2017-07-27 | 2019-01-31 | 平安科技(深圳)有限公司 | Parameter value calculation method and apparatus, storage medium and computer device |
CN109343882A (en) * | 2018-10-12 | 2019-02-15 | 上海庆科信息技术有限公司 | A kind of equipment performance index update method and system |
CN109976828A (en) * | 2019-03-12 | 2019-07-05 | 北京奇艺世纪科技有限公司 | A kind of method and device of configuration file |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20100107095A1 (en) * | 2008-10-24 | 2010-04-29 | Microsoft Corporation | Template-based calculator application |
CN104317477A (en) * | 2014-09-26 | 2015-01-28 | 广州金山移动科技有限公司 | Formula self-defining method and method employing self-defined formula |
CN106874250A (en) * | 2017-02-15 | 2017-06-20 | 中车株洲电机有限公司 | A kind of automatic operation method and system based on word domains |
Family Cites Families (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107798459A (en) * | 2017-07-27 | 2018-03-13 | 平安科技(深圳)有限公司 | Parameter values computational methods, device, storage medium and computer equipment |
-
2017
- 2017-07-27 CN CN201710626231.7A patent/CN107798459A/en active Pending
-
2018
- 2018-05-27 WO PCT/CN2018/088564 patent/WO2019019789A1/en active Application Filing
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20100107095A1 (en) * | 2008-10-24 | 2010-04-29 | Microsoft Corporation | Template-based calculator application |
CN104317477A (en) * | 2014-09-26 | 2015-01-28 | 广州金山移动科技有限公司 | Formula self-defining method and method employing self-defined formula |
CN106874250A (en) * | 2017-02-15 | 2017-06-20 | 中车株洲电机有限公司 | A kind of automatic operation method and system based on word domains |
Cited By (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2019019789A1 (en) * | 2017-07-27 | 2019-01-31 | 平安科技(深圳)有限公司 | Parameter value calculation method and apparatus, storage medium and computer device |
CN108573453A (en) * | 2018-03-30 | 2018-09-25 | 平安科技(深圳)有限公司 | Configuration method, device, computer equipment and the storage medium of insurance products computation model |
CN109343882A (en) * | 2018-10-12 | 2019-02-15 | 上海庆科信息技术有限公司 | A kind of equipment performance index update method and system |
CN109976828A (en) * | 2019-03-12 | 2019-07-05 | 北京奇艺世纪科技有限公司 | A kind of method and device of configuration file |
CN109976828B (en) * | 2019-03-12 | 2022-04-22 | 北京奇艺世纪科技有限公司 | Method and device for configuring file |
Also Published As
Publication number | Publication date |
---|---|
WO2019019789A1 (en) | 2019-01-31 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US8731973B2 (en) | Overlaying images in automated insurance policy form generation | |
CN107798459A (en) | Parameter values computational methods, device, storage medium and computer equipment | |
US20140114822A1 (en) | Method and system for creating tax configuration templates | |
CN101652748A (en) | Service program generation technology | |
JP2000215263A (en) | Accounting system/method processing transaction data, and storage medium storing program for the same | |
WO2001061587A1 (en) | Financial processing system and method | |
US9766843B2 (en) | Document output processing | |
CN110457364B (en) | User information view generation method and device | |
CN113076731A (en) | Report file generation method and device, computer equipment and storage medium | |
CN103646049A (en) | Method and system for automatically generating data report | |
CA2737734A1 (en) | Overlaying images in automated insurance policy form generation | |
CN107808334A (en) | A kind of method that accounting voucher is automatically generated from business paper | |
Adkins | Money: A feminist issue | |
CN106056418A (en) | Invoice submission method, device and system | |
WO2021013057A1 (en) | Data management method and apparatus, and device and computer-readable storage medium | |
CN108733374A (en) | Application program homepage development approach and terminal device | |
US8687210B2 (en) | Document data access | |
JP2005216097A (en) | System and method for providing transaction account information | |
Chintrakarn et al. | Using demographic identification to estimate the effects of board size on corporate performance | |
CN111916164B (en) | Method and device for realizing center-started investigation system in clinical research | |
CN113051883B (en) | Credential generation method, apparatus, computer device, and storage medium | |
CN114265842A (en) | Audit data processing method, device, equipment and storage medium based on ERP system | |
CN116976840B (en) | Multi-person collaborative engineering quantity calculation book auditing method and system | |
KR101167417B1 (en) | The system which manages a customer security | |
JP2017091171A (en) | Output control system and output control method |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180313 |
|
RJ01 | Rejection of invention patent application after publication |