CN111159988A - Model processing method and device, computer equipment and storage medium - Google Patents
Model processing method and device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN111159988A CN111159988A CN201911423727.XA CN201911423727A CN111159988A CN 111159988 A CN111159988 A CN 111159988A CN 201911423727 A CN201911423727 A CN 201911423727A CN 111159988 A CN111159988 A CN 111159988A
- Authority
- CN
- China
- Prior art keywords
- model
- calculation
- server
- measuring
- target
- 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.)
- Granted
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2457—Query processing with adaptation to user needs
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2462—Approximate or statistical queries
Landscapes
- Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Computational Linguistics (AREA)
- Probability & Statistics with Applications (AREA)
- Fuzzy Systems (AREA)
- Mathematical Physics (AREA)
- Software Systems (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a model processing method, a model processing device, computer equipment and a storage medium. The method is applied to the electronic form application plug-in, and comprises the following steps: receiving a calculation formula of measurement and calculation logic of a target measurement and calculation model input by a user; uploading a calculation formula to a server so as to generate a target measurement and calculation model at the server; if uploading success information fed back by the server is received, determining that the target measurement and calculation model is uploaded successfully; and if the target measuring and calculating model is uploaded successfully, accessing the target measuring and calculating model for measuring and calculating. The calculation formula edited by the user can be uploaded to the server, so that the server does not need to perform code recognition, the calculation formula can be quickly applied to the test model, the updating period is greatly reduced, and the operation and maintenance cost is reduced.
Description
Technical Field
The present invention relates to data processing technologies, and in particular, to a model processing method and apparatus, a computer device, and a storage medium.
Background
With the development and popularization of enterprise informatization, large and medium-sized enterprises such as real estate enterprises and the like begin to establish an investment measuring and calculating system, and the whole process management before, during and after investment is realized in the enterprise investment process. In the system development process, most enterprises adopt a program coding or storage process to realize model calculation logic, when the system is designed and developed, the whole measurement and calculation model needs to be comprehensively sorted and analyzed, and in the process, service personnel need to consume a large amount of time and cost to enable technical personnel to know services and use codes to realize the services.
Due to the complex computational logic of the measurement and calculation model, a large amount of coding is required in the development process for realization of the measurement and calculation model. Meanwhile, different investment measurement models are adopted by enterprises in different stages, calculation logics need to be designed and developed respectively according to the models, and the investment measurement models are influenced by factors such as finance and policy, so that system codes are changed frequently along with changes of business or calculation logics.
Disclosure of Invention
The invention provides a model processing method, a model processing device, computer equipment and a storage medium, which are used for reducing the operation and maintenance cost of a calculation model.
In a first aspect, an embodiment of the present invention provides a model processing method applied to a spreadsheet application plug-in, including:
receiving a calculation formula of measurement and calculation logic of a target measurement and calculation model input by a user;
uploading a calculation formula to a server so as to generate a target measurement and calculation model at the server;
if uploading success information fed back by the server is received, determining that the target measurement and calculation model is uploaded successfully;
and if the target measuring and calculating model is uploaded successfully, accessing the target measuring and calculating model for measuring and calculating.
In a second aspect, an embodiment of the present invention further provides a model processing apparatus, which is applied to a spreadsheet application plug-in, and includes:
the input module is used for receiving a calculation formula of measurement and calculation logic of a target measurement and calculation model input by a user;
the measuring and calculating logic uploading module is used for uploading a calculation formula to the server so as to generate a target measuring and calculating model at the server;
the network communication module is used for determining that the target measuring and calculating model is successfully uploaded if uploading success information fed back by the server is received;
and the model access module is used for accessing the target measuring and calculating model for measuring and calculating if the target measuring and calculating model is uploaded successfully.
In a third aspect, an embodiment of the present invention further provides a computer device, which includes a memory, a processor, and a computer program stored in the memory and executable on the processor, where the processor, when executing the program, implements the model processing method shown in the embodiment of the present application.
In a fourth aspect, the present invention further provides a storage medium containing computer-executable instructions, which when executed by a computer processor, are used to perform the model processing method as shown in the embodiments of the present application.
The model processing scheme provided by the embodiment of the invention receives a calculation formula of measurement and calculation logic of a target measurement and calculation model input by a user; uploading a calculation formula to a server so as to generate a target measurement and calculation model at the server; if uploading success information fed back by the server is received, determining that the target measurement and calculation model is uploaded successfully; and if the target measuring and calculating model is uploaded successfully, accessing the target measuring and calculating model for measuring and calculating. Compared with the existing method that the code of the test logic is uploaded to the server, so that the server needs a large amount of cost for identifying and correcting the test logic code, the embodiment of the invention can upload the calculation formula edited by the user to the server, so that the server does not need to identify the code, the calculation formula can be quickly applied to the test model, the update period is greatly reduced, and the operation and maintenance cost is reduced.
Drawings
FIG. 1 is a flow chart of a model processing method according to a first embodiment of the present invention;
FIG. 2 is a flowchart of a model processing method according to a second embodiment of the present invention;
FIG. 3 is a schematic structural diagram of a model processing apparatus according to a third embodiment of the present invention;
fig. 4 is a schematic structural diagram of a computer device in the fourth embodiment of the present invention.
Detailed Description
The present invention will be described in further detail with reference to the accompanying drawings and examples. It is to be understood that the specific embodiments described herein are merely illustrative of the invention and are not limiting of the invention. It should be further noted that, for the convenience of description, only some of the structures related to the present invention are shown in the drawings, not all of the structures.
Example one
Fig. 1 is a flowchart of a model processing method according to an embodiment of the present invention, where the embodiment is applicable to a case where spreadsheet application performs model calculation, the method may be executed by a terminal, and the terminal may be a personal computer, and the method specifically includes the following steps:
and step 110, receiving a calculation formula of the measuring and calculating logic of the target measuring and calculating model input by a user.
The spreadsheet application may be an Excel application or a WPS application. When the measuring and calculating model is established, after a user opens the spreadsheet application, a plug-in is loaded in the spreadsheet application. The plug-in is used to perform the method shown in the present application. After loading the plug-in, the user edits the measurement and calculation logic of the target measurement and calculation model, wherein the measurement and calculation logic consists of a calculation formula. The calculation model can be used for calculating the cost of real estate investment and the like, the spreadsheet comprises a plurality of cells, a table data processing formula can be established for the current cell, and the table data processing formula can represent the numerical calculation relationship between the current cell and data in other cells. And forming measuring and calculating logic by setting a processing formula of the data in the plurality of cells. The plug-in may provide the user with an interface for marking cells, such as cell labels, and the user may enter the calculation formula for the cell by editing the interface.
Illustratively, a form data processing formula input by a user through a spreadsheet application is received; and generating a calculation formula of the measuring and calculating logic according to the table data processing formula.
The user can not only generate the calculation formula of the measuring and calculating logic through the plug-in, but also establish a table data processing formula in the spreadsheet application. After a user clicks on a cell, a form data processing formula is entered in the edit box of the cell of the spreadsheet application. And counting the table data processing formulas input in different cells, establishing a logical relationship among the formulas, and generating a calculation formula of the measuring and calculating logic. The method and the device can realize that the plug-in obtains the table data processing formula input by the user in the interface provided by the spreadsheet application in the background, provide the native interface operation for the user and simplify the user operation.
Illustratively, the calculation formula is uploaded to the server according to the identification of the target measurement and calculation model. When a user establishes the measuring and calculating model for the first time, the plug-in requests the user to input the identification of the target measuring and calculating model, and the duplicate checking is carried out in the server. Only non-repeating identities are allowed to be retained. The server can store various measurement and calculation models, and in order to accurately and uniquely mark the target measurement and calculation model, when the calculation formula is uploaded to the server, the identification of the target measurement and calculation model edited by the user is associated with the calculation formula.
And 120, uploading a calculation formula to the server so as to generate a target measurement model in the server.
And after receiving the calculation formula, the server generates a target measurement and calculation model according to the calculation formula. A calculation formula is used to describe a calculation step, and a plurality of calculation formulas can be used to represent a calculation model. And the server verifies the calculation formula in the uploading process, and if the verification is successful, an uploading success message is returned to the terminal. And if the verification is unsuccessful, returning an uploading failure message to the terminal. The checking content comprises calculation formula grammar checking, logic checking and the like.
Optionally, the online target measurement and calculation model is verified, the plug-in reads the identifier of the measurement and calculation model, the target measurement and calculation model is uploaded successfully, that is, the determination of the calculation logic of the target measurement and calculation system is determined, after the target measurement and calculation model is uploaded, a user can use the uploaded measurement and calculation logic to perform measurement and calculation, the measurement and calculation logic is automatically loaded into a server cache when a measurement and calculation task is created, and the problem that the calculation logic is difficult to maintain after being implemented in a hard coding mode is solved.
The user can pre-install the client addin plug-in, the spreadsheet application plug-in can read the uploaded measuring and calculating model, a new measuring and calculating version is created for the existing measuring and calculating model, the measuring and calculating model and the measuring and calculating logic are opened and displayed at the client after being successfully loaded in the cache of the server, and the client displays the latest data of the server through the data acquisition module.
Further, the user logs in the plug-in at the client, requests the server to cache and create/load the investment measurement model in the plug-in, the server caches and loads the investment measurement model successfully, and returns a plug-in loading result, and the target measurement model is downloaded and displayed at the client through the plug-in.
And step 130, if uploading success information fed back by the server is received, determining that the target measuring and calculating model is uploaded successfully.
And judging whether uploading success information is received or not by a plug-in loaded in the spreadsheet application in the terminal, if so, outputting the uploading success information to a user, and determining that the target measurement and calculation model is uploaded successfully.
And 140, accessing the target measuring and calculating model for measuring and calculating if the target measuring and calculating model is uploaded successfully.
The data processing method provided by the embodiment of the invention is that the server executes model calculation of the target measuring and calculating model, and the plug-in the terminal is only used for data display and data import. When the target measuring and calculating model is uploaded in the server, the plug-in can access the target measuring and calculating model in the server to measure and calculate.
The model processing method provided by the embodiment of the invention receives a calculation formula of measurement and calculation logic of a target measurement and calculation model input by a user; uploading a calculation formula to a server so as to generate a target measurement and calculation model at the server; if uploading success information fed back by the server is received, determining that the target measurement and calculation model is uploaded successfully; and if the target measuring and calculating model is uploaded successfully, accessing the target measuring and calculating model for measuring and calculating. Compared with the existing method that the code of the test logic is uploaded to the server, so that the server needs a large amount of cost for identifying and correcting the test logic code, the embodiment of the invention can upload the calculation formula edited by the user to the server, so that the server does not need to identify the code, the calculation formula can be quickly applied to the test model, the update period is greatly reduced, and the operation and maintenance cost is reduced.
Example two
Fig. 2 is a schematic flow chart of a model processing method according to a second embodiment of the present invention, which is used to further describe the above embodiment, and includes:
step 210, receiving a calculation formula of the measurement logic of the target measurement model input by the user.
And step 220, uploading a calculation formula to the server so as to generate a target measurement and calculation model in the server.
And step 230, if the uploading success information fed back by the server is received, determining that the target measuring and calculating model is uploaded successfully.
Step 240, sending a request for loading the target measurement and calculation model to the server, so that the server can load the target measurement and calculation model.
The plug-in sends a request to the server to load the target calculation model. And after receiving the request, the server loads the target measuring and calculating model and waits for the plug-in to send the data file.
Illustratively, acquiring a measuring and calculating model list, wherein the measuring and calculating model list comprises the measuring and calculating model information which is uploaded in a server; acquiring a target measuring and calculating model selected by a user from a measuring and calculating model list; and sending a request for loading the target measuring and calculating model to a server.
A plurality of measurement models exist in the server, and at this time, the plug-in needs to obtain a measurement model list currently existing in the server. The measurement model list can be updated locally by the terminal according to a certain time interval, and can also be acquired from a server. And the plug-in outputs the measuring and calculating model list, and a user selects a target measuring and calculating model from the measuring and calculating model list. And the user can accurately select the target measuring and calculating model in the server.
Step 250, loading a data input interface of the target measuring and calculating model in the electronic form application.
And step 260, monitoring the data files input by the user in the data input interface.
And the user logs in the plug-in the spreadsheet application, the data file is filled in the spreadsheet application through the plug-in, and the data file is uploaded to the server side by the plug-in.
After the user logs in, the plug-in monitors the editing operation of the user in the spreadsheet application, the content edited by the user is written into the data file, and the data file generated by monitoring is uploaded and updated to the server measuring and calculating model.
And 270, sending the data files to a server so that the target measurement and calculation model loaded by the server can calculate the data files uploaded by one or more users to obtain measurement and calculation results.
The method can be understood that the target measuring and calculating model is loaded and opened in the server cache, the combination of the measuring and calculating filled data is realized in the target measuring and calculating model which is correspondingly updated to the server cache through the data uploaded by the spreadsheet application, the computation logic in the model is loaded in the investment measuring and calculating model in the cache, and the measuring and calculating result is output through high-speed computation according to the combined filled data.
And step 280, outputting a measuring and calculating result.
Further, after obtaining the measurement result in step 270, the method further includes: and storing the measurement and calculation result to a persistent storage medium at the network side.
The persistent storage medium may be MongoDB. The measuring and calculating results in the server cache can show output results at the client through the plug-in, and meanwhile, the cache calculating results push data to the MongoDB through the data persistence module. By using the persistent storage medium, nonvolatile storage and output of results can be realized, and data reliability is improved.
The model processing method provided by the embodiment of the invention can use the plug-in the spreadsheet application to control the server to load the target measurement and calculation model, the plug-in receives the data file which is input by a user and is used for transmitting the target measurement and calculation model, the data file is sent to the server, the target test model loaded in the server carries out model calculation, the plug-in receives the measurement and calculation result fed back by the server and outputs the measurement and calculation result in the spreadsheet application, the plug-in the terminal carries out the input of the data file and the receiving and the output of the measurement and calculation result, and the server carries out the loading and the model calculation of the measurement and calculation model, thereby realizing a rapid and easy-to-use measurement and calculation model calling mode and improving the.
The model processing method provided by the embodiment of the invention is based on an Excel (WPS Excel or microsoft Excel, hereinafter referred to as Excel) to realize a measuring and calculating system. The measuring and calculating system comprises a server side, a spreadsheet application (also called a client side) and background management of the client side; the service end and the client end realize the business logic calculation of investment measurement and calculation based on Excel, the current mode of realizing the business logic calculation through program codes and a storage process is replaced, and the Excel plug-in method can reduce a large amount of codes and database development workload. The development of codes and databases is increasingly difficult along with the improvement of service complexity, but the Excel plug-in method is basically not influenced by the service complexity and follows the principle of 'service logic passing model verification', and then the Excel plug-in can be used for building a measuring and calculating system; meanwhile, background management provides a management entry of the investment model, when the business or the computational logic changes, the Excel investment model computational formula can be adjusted to update and iterate quickly, the problem that maintenance of program codes and a storage process is difficult due to frequent adjustment of the business or the computational logic is solved, a user can complete 'system business updating' by updating the investment measuring and calculating model through the background management after adjusting the business or the computational logic, operation and maintenance non-professional technicians can maintain and update the system, the updating convenience of the system is improved, the updating stability of the system is enhanced, and the later-period operation and maintenance cost is reduced.
EXAMPLE III
Fig. 3 is a schematic structural diagram of a model processing apparatus according to a third embodiment of the present invention, where the apparatus is applied to a spreadsheet application plug-in, and includes: an input module 31, a measurement and calculation logic uploading module 32, a network communication module 33 and a model access module 34, wherein:
the input module 31 is used for receiving a calculation formula of the measurement logic of the target measurement model input by a user;
the calculation logic uploading module 32 is used for uploading a calculation formula to the server so as to generate a target calculation model at the server;
the network communication module 33 is configured to determine that the target measurement and calculation model is successfully uploaded if the uploading success information fed back by the server is received;
and the model access module 34 is used for accessing the target measuring and calculating model for measuring and calculating if the target measuring and calculating model is uploaded successfully.
Further, the input module 31 is configured to:
receiving a form data processing formula input by a user through an electronic form application;
and generating a calculation formula of the measuring and calculating logic according to the table data processing formula.
Further, the network communication module 33 is configured to:
and uploading a calculation formula to a server according to the identification of the target measurement and calculation model.
Further, the model access module 34 is configured to:
sending a request for loading the target measuring and calculating model to a server so that the server can load the target measuring and calculating model;
loading a data input interface of the target measurement and calculation model in the spreadsheet application;
monitoring a data file input by a user in a data input interface;
sending the data file to a server so that a target measurement and calculation model loaded by the server can calculate the data file uploaded by one or more users to obtain measurement and calculation results;
and outputting a measuring and calculating result.
Further, the model access module 34 is configured to:
after the measurement result is obtained, the method further comprises the following steps: and storing the measurement and calculation result to a persistent storage medium at the network side.
Further, the model access module 34 is configured to:
sending a request for loading a target measurement model to a server, comprising:
acquiring a measuring and calculating model list, wherein the measuring and calculating model list comprises the measuring and calculating model information which is uploaded in a server;
acquiring a target measuring and calculating model selected by a user from a measuring and calculating model list;
and sending a request for loading the target measuring and calculating model to a server.
In the model processing apparatus provided in the embodiment of the present invention, the input module 31 receives a calculation formula of a measurement logic of a target measurement model input by a user; the calculation logic uploading module 32 uploads the calculation formula to the server so as to generate a target calculation model at the server; the network communication module 33 is configured to determine that the target measurement and calculation model is successfully uploaded if receiving upload success information fed back by the server; the model access module 34 is configured to access the target calculation model for calculation if the target calculation model is uploaded successfully. Compared with the existing method that the code of the test logic is uploaded to the server, so that the server needs a large amount of cost for identifying and correcting the test logic code, the embodiment of the invention can upload the calculation formula edited by the user to the server, so that the server does not need to identify the code, the calculation formula can be quickly applied to the test model, the update period is greatly reduced, and the operation and maintenance cost is reduced.
The model processing device provided by the embodiment of the invention can execute the model processing method provided by any embodiment of the invention, and has corresponding functional modules and beneficial effects of the execution method.
Example four
Fig. 4 is a schematic structural diagram of a computer apparatus according to a fourth embodiment of the present invention, as shown in fig. 4, the computer apparatus includes a processor 40, a memory 41, an input device 42, and an output device 43; the number of processors 40 in the computer device may be one or more, and one processor 40 is taken as an example in fig. 4; the processor 40, the memory 41, the input device 42 and the output device 43 in the computer apparatus may be connected by a bus or other means, and the connection by the bus is exemplified in fig. 4.
The memory 41 is a computer-readable storage medium, and can be used for storing software programs, computer-executable programs, and modules, such as program instructions/modules (e.g., the input module 31, the calculation logic uploading module 32, the network communication module 33, and the model accessing module 34) corresponding to the model processing method in the embodiment of the present invention. The processor 40 executes various functional applications of the computer device and data processing, i.e., implements the above-described model processing method, by executing software programs, instructions, and modules stored in the memory 41.
The memory 41 may mainly include a storage program area and a storage data area, wherein the storage program area may store an operating system, an application program required for at least one function; the storage data area may store data created according to the use of the terminal, and the like. Further, the memory 41 may include high speed random access memory, and may also include non-volatile memory, such as at least one magnetic disk storage device, flash memory device, or other non-volatile solid state storage device. In some examples, memory 41 may further include memory located remotely from processor 40, which may be connected to a computer device over a network. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof.
The input device 42 is operable to receive input numeric or character information and to generate key signal inputs relating to user settings and function controls of the computer apparatus. The output device 43 may include a display device such as a display screen.
EXAMPLE five
An embodiment of the present invention further provides a storage medium containing computer-executable instructions, which when executed by a computer processor, perform a model processing method, the method including:
receiving a calculation formula of measurement and calculation logic of a target measurement and calculation model input by a user;
uploading a calculation formula to a server so as to generate a target measurement and calculation model at the server;
if uploading success information fed back by the server is received, determining that the target measurement and calculation model is uploaded successfully;
and if the target measuring and calculating model is uploaded successfully, accessing the target measuring and calculating model for measuring and calculating.
Further, the calculation formula of the calculation logic of the target calculation model, which receives the input of the user, comprises:
receiving a form data processing formula input by a user through an electronic form application;
and generating a calculation formula of the measuring and calculating logic according to the table data processing formula.
Further, uploading a calculation formula to a server, including:
and uploading a calculation formula to a server according to the identification of the target measurement and calculation model.
Further, accessing a target calculation model for calculation comprises:
sending a request for loading the target measuring and calculating model to a server so that the server can load the target measuring and calculating model;
loading a data input interface of the target measurement and calculation model in the spreadsheet application;
monitoring a data file input by a user in a data input interface;
sending the data file to a server so that a target measurement and calculation model loaded by the server can calculate the data file uploaded by one or more users to obtain measurement and calculation results;
and outputting a measuring and calculating result.
Further, after obtaining the measurement result, the method further includes: and storing the measurement and calculation result to a persistent storage medium at the network side.
Further, sending a request for loading the target measurement model to a server, including:
acquiring a measuring and calculating model list, wherein the measuring and calculating model list comprises the measuring and calculating model information which is uploaded in a server;
acquiring a target measuring and calculating model selected by a user from a measuring and calculating model list;
and sending a request for loading the target measuring and calculating model to a server.
Of course, the storage medium provided by the embodiment of the present invention contains computer-executable instructions, and the computer-executable instructions are not limited to the above method operations, and may also perform related operations in the model processing method provided by any embodiment of the present invention.
From the above description of the embodiments, it is obvious for those skilled in the art that the present invention can be implemented by software and necessary general hardware, and certainly, can also be implemented by hardware, but the former is a better embodiment in many cases. Based on such understanding, the technical solutions of the present invention may be embodied in the form of a software product, which may be stored in a computer-readable storage medium, such as a floppy disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a FLASH Memory (FLASH), a hard disk or an optical disk of a computer, and includes several instructions for enabling a computer device (which may be a personal computer, a server, or a network device) to execute the methods according to the embodiments of the present invention.
It should be noted that, in the embodiment of the above search apparatus, each included unit and module are merely divided according to functional logic, but are not limited to the above division as long as the corresponding functions can be implemented; in addition, specific names of the functional units are only for convenience of distinguishing from each other, and are not used for limiting the protection scope of the present invention.
It is to be noted that the foregoing is only illustrative of the preferred embodiments of the present invention and the technical principles employed. It will be understood by those skilled in the art that the present invention is not limited to the particular embodiments illustrated herein, but is capable of various obvious changes, rearrangements and substitutions as will now become apparent to those skilled in the art without departing from the scope of the invention. Therefore, although the present invention has been described in greater detail by the above embodiments, the present invention is not limited to the above embodiments, and may include other equivalent embodiments without departing from the spirit of the present invention, and the scope of the present invention is determined by the scope of the appended claims.
Claims (10)
1. A model processing method, applied to a spreadsheet application plug-in, comprising:
receiving a calculation formula of measurement and calculation logic of a target measurement and calculation model input by a user;
uploading the calculation formula to a server so as to generate a target measurement and calculation model at the server;
if uploading success information fed back by the server is received, determining that the target measurement and calculation model is uploaded successfully;
and if the target measuring and calculating model is uploaded successfully, accessing the target measuring and calculating model for measuring and calculating.
2. The model processing method of claim 1, wherein the calculation formula of the estimation logic of the target estimation model receiving the user input comprises:
receiving a form data processing formula input by a user through an electronic form application;
and generating a calculation formula of the measuring and calculating logic according to the table data processing formula.
3. The model processing method of claim 1, wherein said uploading said calculation formula to a server comprises:
and uploading the calculation formula to a server according to the identification of the target measurement and calculation model.
4. The model processing method of claim 1, wherein said accessing the target calculation model for calculation comprises:
sending a request for loading a target measurement and calculation model to a server so that the server can load the target measurement and calculation model;
loading a data input interface of the target measurement and calculation model in a spreadsheet application;
monitoring data files input by a user in the data input interface;
sending the data file to the server so that the target measurement and calculation model loaded by the server can calculate the data file uploaded by one or more users to obtain measurement and calculation results;
and outputting the measuring and calculating result.
5. The model processing method of claim 4, after obtaining the measurement results, further comprising: and storing the measuring and calculating result to a persistent storage medium at the network side.
6. The model processing method of claim 4, wherein sending a request to a server to load a target calculation model comprises:
acquiring a measuring and calculating model list, wherein the measuring and calculating model list comprises the measuring and calculating model information which is uploaded in a server;
acquiring a target measuring and calculating model selected from the measuring and calculating model list by a user;
and sending a request for loading the target measuring and calculating model to the server.
7. A model processing apparatus, applied to a spreadsheet application plug-in, comprising:
the input module is used for receiving a calculation formula of measurement and calculation logic of a target measurement and calculation model input by a user;
the calculation logic uploading module is used for uploading the calculation formula to a server so as to generate a target calculation model at the server;
the network communication module is used for determining that the target measuring and calculating model is uploaded successfully if uploading success information fed back by the server is received;
and the model access module is used for accessing the target measuring and calculating model for measuring and calculating if the target measuring and calculating model is uploaded successfully.
8. The model processing apparatus of claim 7, wherein the model access module is to:
sending a request for loading a target measurement and calculation model to a server so that the server can load the target measurement and calculation model;
loading a data input interface of the target measurement and calculation model in a spreadsheet application;
monitoring data files input by a user in the data input interface;
sending the data file to the server so that the target measurement and calculation model loaded by the server can calculate the data file uploaded by one or more users to obtain measurement and calculation results;
and outputting the measuring and calculating result.
9. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor implements the model processing method according to any one of claims 1 to 6 when executing the program.
10. A storage medium containing computer-executable instructions for performing the model processing method of any one of claims 1-6 when executed by a computer processor.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911423727.XA CN111159988B (en) | 2019-12-31 | 2019-12-31 | Model processing method, device, computer equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911423727.XA CN111159988B (en) | 2019-12-31 | 2019-12-31 | Model processing method, device, computer equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111159988A true CN111159988A (en) | 2020-05-15 |
| CN111159988B CN111159988B (en) | 2023-09-08 |
Family
ID=70560613
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911423727.XA Active CN111159988B (en) | 2019-12-31 | 2019-12-31 | Model processing method, device, computer equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111159988B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114257592A (en) * | 2021-12-20 | 2022-03-29 | 东莞盟大集团有限公司 | Terminal application integration method, device, server and medium based on Internet of things |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20130104020A1 (en) * | 2011-10-25 | 2013-04-25 | Microsoft Corporation | Drag and Drop Always Sum Formulas |
| CN104040535A (en) * | 2012-01-09 | 2014-09-10 | 微软公司 | Custom browser-side spreadsheet functions |
| CN104081384A (en) * | 2012-01-26 | 2014-10-01 | 微软公司 | System and method for providing calculation web services for online documents |
| US20160055140A1 (en) * | 2014-08-25 | 2016-02-25 | Purple Robot Software, Inc. | Peer to peer spreadsheet processing |
| CN109582681A (en) * | 2018-10-26 | 2019-04-05 | 平安科技（深圳）有限公司 | Business data processing method, device, computer equipment and storage medium |
| CN109840206A (en) * | 2018-12-26 | 2019-06-04 | 深圳壹账通智能科技有限公司 | Data test method, apparatus, terminal and storage medium |
| CN110325961A (en) * | 2016-12-03 | 2019-10-11 | 托马斯·斯塔胡拉 | Software application exploitation based on electrical form |
-
2019
- 2019-12-31 CN CN201911423727.XA patent/CN111159988B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20130104020A1 (en) * | 2011-10-25 | 2013-04-25 | Microsoft Corporation | Drag and Drop Always Sum Formulas |
| CN104040535A (en) * | 2012-01-09 | 2014-09-10 | 微软公司 | Custom browser-side spreadsheet functions |
| CN104081384A (en) * | 2012-01-26 | 2014-10-01 | 微软公司 | System and method for providing calculation web services for online documents |
| US20160055140A1 (en) * | 2014-08-25 | 2016-02-25 | Purple Robot Software, Inc. | Peer to peer spreadsheet processing |
| CN110325961A (en) * | 2016-12-03 | 2019-10-11 | 托马斯·斯塔胡拉 | Software application exploitation based on electrical form |
| CN109582681A (en) * | 2018-10-26 | 2019-04-05 | 平安科技（深圳）有限公司 | Business data processing method, device, computer equipment and storage medium |
| CN109840206A (en) * | 2018-12-26 | 2019-06-04 | 深圳壹账通智能科技有限公司 | Data test method, apparatus, terminal and storage medium |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114257592A (en) * | 2021-12-20 | 2022-03-29 | 东莞盟大集团有限公司 | Terminal application integration method, device, server and medium based on Internet of things |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111159988B (en) | 2023-09-08 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107341098B (en) | Software performance testing method, platform, equipment and storage medium | |
| CN110221982B (en) | Performance test method, device and equipment of business system and readable storage medium | |
| CN109543891B (en) | Method and apparatus for establishing capacity prediction model, and computer-readable storage medium | |
| CN111782635B (en) | Data processing method and device, storage medium and electronic device | |
| CN111104214B (en) | Workflow application method and device | |
| US20120226484A1 (en) | Calculation simulation system and method thereof | |
| CN112835808A (en) | Interface testing method and device, computer equipment and storage medium | |
| CN111489100A (en) | Order creating method, device, equipment and medium based on big data | |
| CN111078424A (en) | Information interaction method and device, computer equipment and storage medium | |
| CN113821254A (en) | Interface data processing method, device, storage medium and equipment | |
| CN111159988B (en) | Model processing method, device, computer equipment and storage medium | |
| CN110688305B (en) | Test environment synchronization method, device, medium and electronic equipment | |
| CN111290961A (en) | Interface test management method and device and terminal equipment | |
| CN111506305A (en) | Tool kit generation method and device, computer equipment and readable storage medium | |
| CN116303320A (en) | Real-time task management method, device, equipment and medium based on log file | |
| CN115860877A (en) | Product marketing method, device, equipment and medium | |
| CN113515447B (en) | Automatic testing method and device for system | |
| CN113626409B (en) | Test data processing method, device, equipment and storage medium | |
| CN111045983A (en) | Nuclear power station electronic file management method and device, terminal equipment and medium | |
| US20200097870A1 (en) | Work task commitment manager | |
| CN112561690B (en) | Method, system, equipment and storage medium for testing credit card staged service interface | |
| CN111882294B (en) | Method and device for flow approval | |
| CN116737535A (en) | Interface test method, device, computer equipment and storage medium | |
| CN109871310B (en) | Version quality testing method and device | |
| CN116319716A (en) | Information processing method, no-service system, electronic device, 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 | ||
| CB02 | Change of applicant information | ||
| CB02 | Change of applicant information |
Address after: 100193, No. 5, building 16, east 10, East Hospital, No. 502 Wang Dong Road, Beijing, Haidian District Applicant after: Softcom power information technology (Group) Co.,Ltd. Address before: 100193, No. 5, building 16, east 10, East Hospital, No. 502 Wang Dong Road, Beijing, Haidian District Applicant before: ISOFTSTONE INFORMATION TECHNOLOGY (Group) Co.,Ltd. |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant |