CN117494676A - Formula editing method and device, storage medium and electronic equipment - Google Patents

Formula editing method and device, storage medium and electronic equipment Download PDF

Info

Publication number
CN117494676A
CN117494676A CN202311623043.0A CN202311623043A CN117494676A CN 117494676 A CN117494676 A CN 117494676A CN 202311623043 A CN202311623043 A CN 202311623043A CN 117494676 A CN117494676 A CN 117494676A
Authority
CN
China
Prior art keywords
formula
editing
edited
tree
index
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
Application number
CN202311623043.0A
Other languages
Chinese (zh)
Inventor
张雨薇
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Bank of China Financial Technology Co Ltd
Original Assignee
Bank of China Financial Technology Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Bank of China Financial Technology Co Ltd filed Critical Bank of China Financial Technology Co Ltd
Priority to CN202311623043.0A priority Critical patent/CN117494676A/en
Publication of CN117494676A publication Critical patent/CN117494676A/en
Pending legal-status Critical Current

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/166—Editing, e.g. inserting or deleting

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Health & Medical Sciences (AREA)
  • Artificial Intelligence (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • Computational Linguistics (AREA)
  • General Health & Medical Sciences (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Stored Programmes (AREA)

Abstract

The application discloses a formula editing method, a device, a storage medium and electronic equipment, wherein the method comprises the following steps: initializing a formula tree to be edited in response to a formula tree editing request, wherein the formula tree to be edited comprises an item valuation formula formed by valuation indexes; analyzing the formula tree editing request to obtain index information in the formula tree editing request; and positioning an object to be edited on the formula tree to be edited based on the index information, and editing the object to be edited, wherein the object to be edited comprises at least one of an item valuation formula, a valuation index and an index value. The method and the device provided by the invention can be used for rapidly positioning the object to be edited, so that the editing efficiency is improved.

Description

Formula editing method and device, storage medium and electronic equipment
Technical Field
The present invention relates to the field of data processing technologies, and in particular, to a method and apparatus for editing a formula, a storage medium, and an electronic device.
Background
When a financial institution evaluates an item, an evaluation result is often obtained by constructing an evaluation formula in Excel and bringing evaluation indexes into the evaluation formula, but the evaluation indexes and the item evaluation formula may have variation, and when the evaluation indexes and the item evaluation formula need to be edited, the relation between the evaluation formulas and the relation between the evaluation indexes are difficult to directly observe, and the positioning and the editing of the evaluation indexes and the item evaluation formula are also difficult.
Therefore, how to quickly edit the estimation formula and the estimation index is a technical problem to be solved in the industry.
Disclosure of Invention
The application provides a formula editing method, a formula editing device, a storage medium and electronic equipment, which are used for solving the technical problem of how to rapidly edit an estimated value formula and an estimated value index in the prior art.
In a first aspect, the present application provides a formula editing method, including:
initializing a formula tree to be edited in response to a formula tree editing request, wherein the formula tree to be edited comprises an item estimation formula formed by estimation indexes;
analyzing the formula tree editing request to obtain index information in the formula tree editing request;
and positioning an object to be edited on the formula tree to be edited based on the index information, and editing the object to be edited, wherein the object to be edited comprises at least one of an item valuation formula, a valuation index and an index value.
In some embodiments, after the editing the object to be edited, the method further includes:
calculating an estimated value result of the current project based on the edited formula tree to be edited;
and updating the index information of each formula stored in advance based on the association relation between each formula in the edited formula tree to be edited.
In some embodiments, the calculating the estimation result of the current item based on the edited formula tree to be edited includes:
acquiring index values of various grades corresponding to various market scenes of the current project;
and inputting the index values of each level into an estimated model constructed by the formula tree to be edited, and obtaining estimated results corresponding to each market scene output by the estimated model.
In some embodiments, the tree of formulas to be edited is constructed based on the steps of:
receiving each item estimation formula input by a formula editing interface and the association relation between each item estimation formula;
and generating the formula tree to be edited and the index information based on the item estimation formula and the association relation.
In some embodiments, before the initializing the formula tree to be edited in response to the formula tree editing request, the method further includes:
defining each editing option on the formula editing interface based on the editing requirement of the formula tree to be edited;
the editing options comprise an editing formula, an editing index value and an editing association relation.
In some embodiments, the obtaining the index value of each level corresponding to each market scene of the current project includes:
acquiring index values of the various grades in a database;
and converting the data structure of the index value into a data structure compatible with the estimation model.
In a second aspect, the present application provides a formula editing apparatus, comprising:
the response module is used for initializing a formula tree to be edited in response to a formula tree editing request, wherein the formula tree to be edited comprises an item estimation formula formed by estimation indexes;
the acquisition module is used for analyzing the formula tree editing request to obtain index information in the formula tree editing request;
and the editing module is used for positioning an object to be edited on the formula tree to be edited based on the index information and editing the object to be edited, wherein the object to be edited comprises at least one of an item valuation formula, a valuation index and an index value.
In a third aspect, the present application provides a non-transitory computer readable storage medium having stored thereon a computer program which, when executed by a processor, implements the method described above.
In a fourth aspect, the present application provides an electronic device comprising a memory having a computer program stored therein and a processor arranged to implement the above-described method when the program is executed by the computer program.
In a fifth aspect, the invention also provides a computer program product comprising a computer program which, when executed by a processor, implements a method as described above.
According to the formula editing method, the device, the storage medium and the electronic equipment, through presenting the project estimation formulas formed by the estimation indexes in the mode of a formula tree, the relation between each estimation index and the relation between each project estimation formula can be intuitively seen, and a user can conveniently check and find corresponding editing objects; the object to be edited can be rapidly positioned on the formula tree to be edited through the index information in the formula tree editing request, so that the object to be edited is rapidly edited, the editing efficiency is improved, and the experience of a user is improved.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the application and together with the description, serve to explain the principles of the application.
In order to more clearly illustrate the technical solutions of the present application or the prior art, the following description will briefly introduce the drawings used in the embodiments or the description of the prior art, and it is obvious that, in the following description, the drawings are some embodiments of the present application, and other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a schematic flow chart of a formula editing method according to an embodiment of the present disclosure;
FIG. 2 is a second flow chart of a formula editing method according to the embodiment of the present application;
FIG. 3 is a schematic diagram of a formula editing apparatus according to an embodiment of the present disclosure;
FIG. 4 is a second schematic diagram of a formula editing apparatus according to the embodiment of the present disclosure;
fig. 5 is a schematic structural diagram of an electronic device according to an embodiment of the present application.
Detailed Description
In order to make the present application solution better understood by those skilled in the art, the following description will be made in detail and with reference to the accompanying drawings in the embodiments of the present application, it is apparent that the described embodiments are only some embodiments of the present application, not all embodiments. All other embodiments, which can be made by one of ordinary skill in the art based on the embodiments herein without making any inventive effort, shall fall within the scope of the present application.
It should be noted that the terms "first," "second," and the like herein are used for distinguishing between similar objects and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used may be interchanged where appropriate such that embodiments of the present application described herein may be implemented in sequences other than those illustrated or otherwise described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or modules is not necessarily limited to those steps or modules that are expressly listed or inherent to such process, method, article, or apparatus.
The formula editing method provided by the embodiment of the application is suitable for a terminal, and the terminal can be various electronic devices with a display screen and supporting web browsing, including but not limited to a server, a smart phone, a tablet computer, a laptop portable computer, a desktop computer and the like.
In the technical scheme of the application, the related processes of personal information collection, storage, use, processing, transmission, provision, disclosure and the like all accord with the regulations of related laws and regulations, necessary security measures are adopted, and the public order harmony is not violated.
Fig. 1 is a schematic flow chart of a formula editing method according to an embodiment of the present application, as shown in fig. 1, the method includes a step 110, a step 120, and a step 130. The method flow steps are only one possible implementation of the present application.
Step 110, initializing a formula tree to be edited in response to the formula tree editing request, wherein the formula tree to be edited comprises an item estimation formula formed by estimation indexes.
Specifically, the execution body of the formula editing method provided in the embodiment of the present application is a formula editing device, and the device may be a hardware device independently set in a terminal, or may be a software program running in the terminal. For example, when the terminal is a desktop computer, the formula editing apparatus may be embodied as an application such as editing software in the desktop computer.
The formula tree editing request is a request for editing the formula tree to be edited, which is sent to the formula editing device by the client.
The formula tree to be edited is an existing formula tree that needs to be edited or modified. Each node on the formula tree evaluates the formula for each item.
The item valuation formula is a calculation formula for evaluating the value of an item. The project estimation formula is composed of each estimation index.
The estimation index is a data item affecting the estimation result of the item, and may include, for example, a income amount prediction index for the next 10 years, a growth rate index or a correlation coefficient index involved in prediction, and the like.
If the formula tree is not created, the formula tree needs to be created according to each item estimation formula and the association relation among each item estimation formula. If the formula tree is created in advance, the formula tree is stored in a database.
Because the user with the formula tree editing authority can edit the formula tree, when the formula tree to be edited is needed to be edited, the formula tree to be edited needs to be initialized, and a proper starting state is provided for the formula tree to be edited so as to facilitate subsequent operation.
And 120, analyzing the formula tree editing request to obtain index information in the formula tree editing request.
Specifically, the formula tree editing may include editing of the valuation formula itself, such as adding the project valuation formula, deleting the project valuation formula and corresponding reference relationships, adding global unique indexes and index associations, and the like; editing of the valuation index, such as renaming valuation index, modifying valuation index unit, deleting valuation index, etc., can also be included; editing of the index values, such as modifying the valuation index values, which may be batch modifications, may also be included.
The formula tree edit request includes index information. The index information is a data structure established to improve the retrieval efficiency of formulas, indexes or index values. It records certain attributes or characteristics of the data object so that relevant data can be located and accessed quickly and efficiently at the time of the query. The data object may be a formula, an index, or an index value.
The formula tree editing request can be parsed to obtain index information.
And 130, positioning an object to be edited on the formula tree to be edited based on the index information, and editing the object to be edited, wherein the object to be edited comprises at least one of an item valuation formula, a valuation index and an index value.
Specifically, the editing object in the formula tree to be edited can be determined according to the index information, so that the position of the object to be edited in the formula tree to be edited is determined. The object to be edited may be at least one of an item estimation formula, an estimation index, and an index value.
If the formula tree editing request is to edit the item valuation formula or valuation index in the formula tree to be edited, locating the formula or index to be edited on the formula tree to be edited according to the index information, and editing the formula or index according to the editing requirement in the formula tree editing request.
If the formula tree editing request is to edit the index values in the formula tree to be edited, locating the index to be edited corresponding to the index value to be edited on the formula tree to be edited according to the index information, and then editing the numerical values of the index to be edited.
According to the formula editing method, the project estimation formulas formed by the estimation indexes are presented in the mode of the formula tree, so that the relation between the estimation indexes and the relation between the project estimation formulas can be intuitively seen, and a user can conveniently check and find corresponding editing objects; the object to be edited can be rapidly positioned on the formula tree to be edited through the index information in the formula tree editing request, so that the object to be edited is rapidly edited, the editing efficiency is improved, and the experience of a user is improved.
It should be noted that each embodiment of the present application may be freely combined, permuted, or executed separately, and does not need to rely on or rely on a fixed execution sequence.
In some embodiments, after step 130, further comprising:
calculating an estimated value result of the current project based on the edited formula tree to be edited;
and updating the index information of each formula stored in advance based on the association relation between each formula in the edited formula tree to be edited.
Calculating an estimated result of the current item based on the edited formula tree to be edited, wherein the estimated result comprises the following steps:
acquiring index values of various grades corresponding to various market scenes of a current project;
and inputting the index values of each level into an estimated model constructed by the formula tree to be edited, and obtaining estimated results corresponding to each market scene output by the estimated model.
Specifically, after editing an object to be edited in the formula tree to be edited, triggering an evaluation calculation program of the edited formula tree to be edited, and calculating step by step according to an item evaluation formula in the current formula tree to obtain an item evaluation result.
When the formula tree is constructed for the first time, index information related to the item valuation formula in the formula tree is stored for subsequent positioning inquiry. Therefore, after editing the object to be edited in the formula tree to be edited, the prestored index information is synchronously updated according to the association concern among the formulas in the latest formula tree.
In the embodiment of the application, an estimation model can be constructed according to the formula tree to be edited. The valuation model is a mathematical model used to evaluate the value of an item. It provides the user with an estimated value range or specific value of the item based on the tree of formulas to be edited.
Various market scenarios for the item currently requiring evaluation may be set. Market scenarios refer to a particular scenario presented by the interaction of economic, social, political, etc. factors in a particular market environment and period.
Because the supply and demand relationship, investor emotion, policy environment and other factors in the market can change under different economic environments, so that the price and value of the project are affected, different market scenes can correspond to different levels of index values. For example, when the market scene is better, the corresponding sales index value is higher.
And acquiring index values of various grades corresponding to various market scenes of the current project input by the client. And converts these index values into index data structures and index information required by the formula editing apparatus.
And inputting the index value of the corresponding grade of the current market scene into the estimation model to obtain an estimation result corresponding to the market scene output by the estimation model.
The switching options can be defined on the formula editing interface, when the market scene is replaced, the current market scene is switched through switching, and corresponding index values are switched, so that estimation results corresponding to all the market scenes are obtained. Different market scenarios may share the same estimation model.
When scene switching or index value switching is carried out, a re-estimation program is triggered after grammar, name and other tests are carried out, and the current project is re-estimated. And storing the corresponding updated information and the estimation result.
By comparing the differences between the estimation results corresponding to the market scenes, the relevant information of the current project can be provided for the user.
The different values of the index values of the estimated indexes can be input into the estimated model according to the editing requirement, so that the importance of the estimated indexes in project estimation can be judged according to the estimated result. And analyzing the change trend of the index, the difference of the items and the like according to the estimation results corresponding to the index values at different times.
The formula editing method provided by the embodiment of the application increases the functions of multiple market scenes, so that a user can evaluate and measure project estimation results in different market scenes.
In some embodiments, the formula tree to be edited is constructed based on the following steps:
receiving each item estimation formula input by a formula editing interface and the association relation between each item estimation formula;
and generating a formula tree to be edited and index information based on the item estimation formula and the association relation.
Specifically, the association relationship between the item estimation formula and the item estimation formula may be transmitted to the formula editing apparatus by the client, and upon receiving these information, the formula editing apparatus may automatically generate a formula tree to be edited and related index information, and store these data in the database.
According to the formula editing method, the hierarchical relation between the project valuation formulas and the hierarchical relation between valuation indexes can be conveniently checked by constructing the formula tree, and editing efficiency is improved.
In some embodiments, prior to step 110, further comprising:
defining each editing option on a formula editing interface based on the editing requirement of the formula tree to be edited;
the editing options comprise an editing formula, an editing index value and an editing association relation.
In particular, to facilitate interaction between the client and the formula editing device, a formula editing interface of the formula editing device may be defined at the client.
The formula editing interface directly affects whether the formula editing device is good and convenient. In consideration of convenience requirements of user use, various editing options can be defined on the formula editing interface, wherein the editing options comprise an editing formula, an editing index value and an editing association relation. Shortcut keys and shortcut operations of these editing options can be designed to promote the building speed and editing speed of the formula tree.
For example, the edit formula option may provide functions such as formula addition and formula deletion. Editing the index can provide the functions of index new creation, index modification, index renaming, index deletion and the like.
The formula editing interface can comprise a tree-shaped unfolded index selector, an input editing box, a multi-formula selecting block and corresponding confirmation and operation buttons. And the index selector expanded by the tree form is convenient for quickly checking the object to be edited after initializing the formula tree, and quickly selecting the object to be edited. The input edit box comprises the editing options.
The formula editing interface can comprise a market scene switching inlet, a multi-formula operation selector, a multi-year formula application selector, a formula input editing box and the like, and can be expanded and updated at any time according to actual conditions. The entrance of market scene switching not only enables a user to rapidly switch index values corresponding to market scenes, but also provides cloning and deleting functions of any index value, and the synchronous updating of the multi-scene formulas is kept.
The user can automatically input the item estimation formula through the formula editing interface, the formula editing device can detect the formula input by the user, the formula is added into global index information after final confirmation, and the index information is cancelled when the formula is deleted.
The formula editing device automatically screens the established index list for reference in the formula recording process, so that the global uniqueness of the estimated index is ensured.
According to the formula editing method, the quick editing options are defined on the formula editing interface, so that a user can conveniently input a formula and edit the formula, and the formula editing efficiency is improved.
In some embodiments, obtaining the index value of each level corresponding to each market scene of the current project includes:
acquiring index values of all levels in a database;
the data structure of the index values is converted into a data structure compatible with the estimation model.
Specifically, in the embodiment of the present application, the formula editing interface has more operation functions, and the index also has the cases of years, split years and multiple market scenes, so that the processing condition of the index is complex, and therefore, the effectiveness of each step needs to be ensured. For example, to ensure that the data structure of the input estimation model is adapted to the estimation model.
Each index value can be obtained from the database, and the data structure of the index value is converted into a data structure which can be identified by the formula editing device and the estimation model, and is stored
According to the formula editing method provided by the embodiment of the application, the efficiency of formula editing is improved by converting the data structure of the index value, and abnormal conditions caused by incompatibility of the data structure are prevented.
Fig. 2 is a second flowchart of a formula editing method according to an embodiment of the present application, as shown in fig. 2, where the method includes:
and step 1, initializing an estimation model and data in a formula tree forming the estimation model.
And step 2, determining an object to be edited according to the formula tree editing request.
And step 3, editing the object to be edited. Editing operations may include formula editing, formula addition, formula deletion, index creation, index modification, index renaming, index deletion, and scene operations, among others.
And step 4, updating and storing the corresponding index value, the item estimation formula and the index information.
And step 5, if the evaluation calculation is involved, initializing index values in the formula tree to perform the evaluation calculation, and generating index information to store.
And 6, saving the updated index information and index value by the user.
After the user completes editing, the project estimation results of all market scenes are recalculated and converted and saved, so that the updated data can be opened next time. The user can also exit at any time without going through the save step and ending the editing.
Step 1 is a preparation step of the whole formula editing method, and the basic data required by the subsequent steps are initialized, and if the basic data are not originally available, the initialization is not needed.
The formula editing method provided by the embodiment of the application can enable a user to view or edit different levels of the estimation model through the formula tree passing points, intuitively grasp the model condition and quickly edit the formula.
The following describes a formula editing apparatus provided in an embodiment of the present application, and the formula editing apparatus described below and the formula editing method described above may be referred to correspondingly to each other.
Fig. 3 is a schematic structural diagram of a formula editing apparatus according to an embodiment of the present application, and as shown in fig. 3, the apparatus includes a response module 310, an obtaining module 320, and an editing module 330.
The response module is used for initializing a formula tree to be edited in response to the formula tree editing request, wherein the formula tree to be edited comprises an item estimation formula formed by estimation indexes;
the acquisition module is used for analyzing the formula tree editing request to obtain index information in the formula tree editing request;
the editing module is used for positioning an object to be edited on the formula tree to be edited based on the index information, and editing the object to be edited, wherein the object to be edited comprises at least one of an item valuation formula, a valuation index and an index value.
Specifically, according to an embodiment of the present application, any of the response module, the acquisition module, and the editing module may be combined and implemented in one module, or any of the modules may be split into a plurality of modules.
Alternatively, at least some of the functionality of one or more of the modules may be combined with at least some of the functionality of other modules and implemented in one module.
According to embodiments of the present application, at least one of the response module, the acquisition module, and the editing module may be implemented at least in part as a hardware circuit, such as a Field Programmable Gate Array (FPGA), a Programmable Logic Array (PLA), a system on a chip, a system on a substrate, a system on a package, an Application Specific Integrated Circuit (ASIC), or in hardware or firmware, such as any other reasonable way of integrating or packaging the circuit, or in any one of or a suitable combination of three of software, hardware, and firmware.
Alternatively, at least one of the response module, the acquisition module and the editing module may be at least partially implemented as a computer program module, which when executed may perform the respective functions.
According to the formula editing device provided by the embodiment of the application, the project estimation formulas formed by the estimation indexes are presented in the mode of a formula tree, so that the relation between the estimation indexes and the relation between the project estimation formulas can be intuitively seen, and a user can conveniently check and search corresponding editing objects; the object to be edited can be rapidly positioned on the formula tree to be edited through the index information in the formula tree editing request, so that the object to be edited is rapidly edited, the editing efficiency is improved, and the experience of a user is improved.
In some embodiments, the formula editing apparatus further comprises an estimation module for:
calculating an estimated value result of the current project based on the edited formula tree to be edited;
and updating the index information of each formula stored in advance based on the association relation between each formula in the edited formula tree to be edited.
In some embodiments, the estimation module includes a scene sub-module for:
acquiring index values of various grades corresponding to various market scenes of a current project;
and inputting the index values of each level into an estimated model constructed by the formula tree to be edited, and obtaining estimated results corresponding to each market scene output by the estimated model.
In some embodiments, the formula editing apparatus further comprises a build module for:
receiving each item estimation formula input by a formula editing interface and the association relation between each item estimation formula;
and generating a formula tree to be edited and index information based on the item estimation formula and the association relation.
In some embodiments, the formula editing device further comprises an interface module for:
defining each editing option on a formula editing interface based on the editing requirement of the formula tree to be edited;
the editing options comprise an editing formula, an editing index value and an editing association relation.
In some embodiments, the scene sub-module is further to:
acquiring index values of all levels in a database;
the data structure of the index values is converted into a data structure compatible with the estimation model.
Fig. 4 is a second schematic structural diagram of the formula editing device provided in the embodiment of the present application, as shown in fig. 4, the device includes an initialization module, a user operation module, a data update module, a calculation module, and a storage module.
And the initialization module is used for initializing the data related to the formula editing.
The user operation module is used for providing a formula editing interface for index operation, formula operation, scene operation and the like for a user, continuously analyzing and sending data provided by the user to the data updating module in a grammar, and displaying the updated data.
And the data updating module is used for updating the index data, the index information, the scene data and the like in the corresponding scene according to the operation of the user operation module. The data updating module can circularly monitor the estimated result of the calculating module and update the stored estimated result according to the estimated result sent by the calculating module.
And the calculation module is used for carrying out evaluation calculation on the current item through the formula tree.
And the storage module is used for converting and storing the updated data back to the database.
It should be noted that, the formula editing device provided in this embodiment of the present application can implement all the method steps implemented in the foregoing method embodiment for formula editing, and can achieve the same technical effects, and specific details of the same parts and beneficial effects as those of the method embodiment in this embodiment are not described herein.
Fig. 5 is a schematic structural diagram of an electronic device provided in an embodiment of the present application, and as shown in fig. 5, the electronic device may include: processor (Processor) 510, communication interface (Communications Interface) 520, memory (Memory) 530, and communication bus (Communications Bus) 540, wherein Processor 510, communication interface 520, memory 530 complete communication with each other via communication bus 540. Processor 510 may invoke logic commands in memory 530 to perform the method described above, including:
initializing a formula tree to be edited in response to a formula tree editing request, wherein the formula tree to be edited comprises an item valuation formula formed by valuation indexes;
analyzing the formula tree editing request to obtain index information in the formula tree editing request;
and positioning an object to be edited on the formula tree to be edited based on the index information, and editing the object to be edited, wherein the object to be edited comprises at least one of an item valuation formula, a valuation index and an index value.
In addition, the logic commands in the memory described above may be implemented in the form of software functional modules and stored in a computer readable storage medium when sold or used as a stand alone product. Based on such understanding, the technical solution of the present application may be embodied essentially or in a part contributing to the prior art or in a part of the technical solution, in the form of a software product stored in a storage medium, comprising several commands for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the methods described in the embodiments of the present application. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a random access Memory (RAM, random Access Memory), a magnetic disk, or an optical disk, or other various media capable of storing program codes.
The processor in the electronic device provided by the embodiment of the present application may call the logic instruction in the memory to implement the above method, and the specific implementation manner of the processor is consistent with the implementation manner of the foregoing method, and may achieve the same beneficial effects, which are not described herein again.
The present application also provides a non-transitory computer readable storage medium having stored thereon a computer program which, when executed by a processor, is implemented to perform the methods provided by the above embodiments.
The specific embodiment is consistent with the foregoing method embodiment, and the same beneficial effects can be achieved, and will not be described herein.
Embodiments of the present application provide a computer program product comprising a computer program which, when executed by a processor, implements a method as described above.
The apparatus embodiments described above are merely illustrative, wherein the modules illustrated as separate components may or may not be physically separate, and the components shown as modules may or may not be physical, i.e., may be located in one place, or may be distributed over a plurality of network modules. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of this embodiment. Those of ordinary skill in the art will understand and implement the present invention without undue burden.
From the above description of the embodiments, it will be apparent to those skilled in the art that the embodiments may be implemented by means of software plus necessary general hardware platforms, or of course may be implemented by means of hardware. Based on this understanding, the foregoing technical solution may be embodied essentially or in a part contributing to the prior art in the form of a software product, which may be stored in a computer readable storage medium, such as ROM/RAM, a magnetic disk, an optical disk, etc., including several instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to execute the method described in the respective embodiments or some parts of the embodiments.
Finally, it should be noted that: the above embodiments are only for illustrating the technical solution of the present application, and are not limiting thereof; although the present application has been described in detail with reference to the foregoing embodiments, it should be understood by those of ordinary skill in the art that: the technical scheme described in the foregoing embodiments can be modified or some technical features thereof can be replaced by equivalents; such modifications and substitutions do not depart from the spirit and scope of the corresponding technical solutions.

Claims (10)

1. A method of formula editing comprising:
initializing a formula tree to be edited in response to a formula tree editing request, wherein the formula tree to be edited comprises an item estimation formula formed by estimation indexes;
analyzing the formula tree editing request to obtain index information in the formula tree editing request;
and positioning an object to be edited on the formula tree to be edited based on the index information, and editing the object to be edited, wherein the object to be edited comprises at least one of an item valuation formula, a valuation index and an index value.
2. The formula editing method according to claim 1, wherein after the editing of the object to be edited, further comprising:
calculating an estimated value result of the current project based on the edited formula tree to be edited;
and updating the index information of each formula stored in advance based on the association relation between each formula in the edited formula tree to be edited.
3. The formula editing method according to claim 2, wherein the calculating the estimation result of the current item based on the edited formula tree to be edited includes:
acquiring index values of various grades corresponding to various market scenes of the current project;
and inputting the index values of each level into an estimated model constructed by the formula tree to be edited, and obtaining estimated results corresponding to each market scene output by the estimated model.
4. The formula editing method according to claim 2, wherein the formula tree to be edited is constructed based on the steps of:
receiving each item estimation formula input by a formula editing interface and the association relation between each item estimation formula;
and generating the formula tree to be edited and the index information based on the item estimation formula and the association relation.
5. The formula editing method according to claim 4, wherein before initializing the formula tree to be edited in response to the formula tree editing request, further comprising:
defining each editing option on the formula editing interface based on the editing requirement of the formula tree to be edited;
the editing options comprise an editing formula, an editing index value and an editing association relation.
6. The formula editing method according to claim 3, wherein the obtaining the index values of the respective levels corresponding to the respective market scenes of the current item includes:
acquiring index values of the various grades in a database;
and converting the data structure of the index value into a data structure compatible with the estimation model.
7. A formula editing apparatus, comprising:
the response module is used for initializing a formula tree to be edited in response to a formula tree editing request, wherein the formula tree to be edited comprises an item estimation formula formed by estimation indexes;
the acquisition module is used for analyzing the formula tree editing request to obtain index information in the formula tree editing request;
and the editing module is used for positioning an object to be edited on the formula tree to be edited based on the index information and editing the object to be edited, wherein the object to be edited comprises at least one of an item valuation formula, a valuation index and an index value.
8. A non-transitory computer readable storage medium having stored thereon a computer program, wherein the computer program when executed by a processor implements the formula editing method according to any of claims 1 to 6.
9. An electronic device comprising a memory and a processor, wherein the memory has stored therein a computer program, the processor being arranged to execute the formula editing method of any of claims 1 to 6 by means of the computer program.
10. A computer program product comprising a computer program which, when executed by a processor, implements the formula editing method of any of claims 1 to 6.
CN202311623043.0A 2023-11-29 2023-11-29 Formula editing method and device, storage medium and electronic equipment Pending CN117494676A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202311623043.0A CN117494676A (en) 2023-11-29 2023-11-29 Formula editing method and device, storage medium and electronic equipment

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202311623043.0A CN117494676A (en) 2023-11-29 2023-11-29 Formula editing method and device, storage medium and electronic equipment

Publications (1)

Publication Number Publication Date
CN117494676A true CN117494676A (en) 2024-02-02

Family

ID=89672700

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202311623043.0A Pending CN117494676A (en) 2023-11-29 2023-11-29 Formula editing method and device, storage medium and electronic equipment

Country Status (1)

Country Link
CN (1) CN117494676A (en)

Similar Documents

Publication Publication Date Title
CN106844372B (en) Logistics information query method and device
WO2019019769A1 (en) Service function implementation method, device, computer apparatus and storage medium
CN106657192B (en) Method and equipment for presenting service calling information
KR20060044524A (en) Business application entity subscription synch operation management
CN107908442A (en) Resource loading method, device, terminal device and computer-readable recording medium based on spring
CN107103490B (en) Data processing method, network server and terminal
CN112667789A (en) User intention matching method and device, terminal equipment and storage medium
US11294917B2 (en) Data attribution using frequent pattern analysis
CN116225690A (en) Memory multidimensional database calculation load balancing method and system based on docker
CN117494676A (en) Formula editing method and device, storage medium and electronic equipment
CN112348403B (en) Wind control model construction method and device and electronic equipment
CN110309208A (en) The implementation method and device of data visualization
US20210304043A1 (en) Evaluating a recommender system for data processing
EP4053713A1 (en) Question and answer method and apparatus based on knowledge graph
CN113656127A (en) Page routing method, device, storage medium and processor
CN112287658A (en) Business data processing method and device, electronic equipment and medium
CN106802856A (en) The performance test methods of game application, server and game application client
CN109740056A (en) It is a kind of for provide a user customization financial information method and apparatus
CN115983220B (en) Report generation method and device and electronic equipment
CN116700701B (en) Code-free software development method and device and electronic equipment
CN112988291B (en) Page event management method and device, computer readable medium and electronic equipment
CN107967300A (en) Search method, device, equipment and the storage medium of organization names
CN114265985A (en) Automobile information interactive query method, device and equipment
CN116383145A (en) File management method, device, electronic equipment and computer readable storage medium
CN116737275A (en) Entry modification method and device, electronic equipment and storage medium

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