CN111159988B - Model processing method, device, computer equipment and storage medium - Google Patents
Model processing method, device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN111159988B CN111159988B CN201911423727.XA CN201911423727A CN111159988B CN 111159988 B CN111159988 B CN 111159988B CN 201911423727 A CN201911423727 A CN 201911423727A CN 111159988 B CN111159988 B CN 111159988B
- Authority
- CN
- China
- Prior art keywords
- model
- calculating
- measuring
- server
- 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.)
- Active
Links
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 application discloses a model processing method, a model processing device, computer equipment and a storage medium. The method is applied to a spreadsheet application plug-in and comprises the following steps: receiving a calculation formula of calculation logic of a target calculation model input by a user; uploading a calculation formula to a server so as to generate a target measuring and calculating model at the server; if uploading success information fed back by the server is received, determining that the uploading of the target measuring and calculating model is successful; if the uploading of the target measuring and calculating model is successful, the target measuring and calculating model is accessed 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 recognize codes, the calculation formula can be rapidly applied to the test model, the update period is greatly reduced, and the operation and maintenance cost is reduced.
Description
Technical Field
Embodiments of the present application relate to data processing technologies, and in particular, to a method and apparatus for processing a model, a computer device, and a storage medium.
Background
With the informatization development and popularization of enterprises, large and medium-sized enterprises such as real estate enterprises and the like start to establish an investment measuring and calculating system, and overall process management before, during and after investment is realized in the enterprise investment process. In the system development process, enterprises mostly adopt the form of program codes or storage processes to realize model calculation logic, and when the system is designed and developed, the whole measuring and calculating model needs to be subjected to comprehensive carding analysis, and the process needs business personnel to consume a great deal of time and cost to enable the technicians to know the business and realize the business by using codes.
Because of the complex computational logic of the measuring and calculating model, technicians need a large amount of codes to realize in the development process. Meanwhile, different investment measuring and calculating models are adopted at different stages of enterprises, calculation logics are required to be respectively designed and developed according to the models, the investment measuring and calculating models are influenced by finance, policies and other factors, so that system codes are changed frequently along with service or calculation logic changes, but because the manual identification period of the codes is long, the system updating cannot respond to service requirements in time, and the operation and maintenance cost of the system is high.
Disclosure of Invention
The application provides a model processing method, a model processing device, computer equipment and a storage medium, so as to reduce the operation and maintenance cost of a computing model.
In a first aspect, an embodiment of the present application provides a model processing method, which is applied to an electronic form application plug-in, including:
receiving a calculation formula of calculation logic of a target calculation model input by a user;
uploading a calculation formula to a server so as to generate a target measuring and calculating model at the server;
if uploading success information fed back by the server is received, determining that the uploading of the target measuring and calculating model is successful;
if the uploading of the target measuring and calculating model is successful, the target measuring and calculating model is accessed for measuring and calculating.
In a second aspect, an embodiment of the present application further provides a model processing device, which is applied to a spreadsheet application plug-in, including:
the input module is used for receiving a calculation formula of calculation logic of the target calculation model input by a user;
the calculation logic uploading module 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 is used for determining that the uploading of the target measuring and calculating model is successful if uploading success information fed back by the server is received;
the model access module is used for accessing the target measuring and calculating model to measure and calculate if the uploading of the target measuring and calculating model is successful.
In a third aspect, an embodiment of the present application further provides a computer device, including a memory, a processor, and a computer program stored in the memory and capable of running on the processor, where the processor executes the program to implement a model processing method as shown in the embodiment of the present application.
In a fourth aspect, embodiments of the present application also provide a storage medium containing computer-executable instructions, which when executed by a computer processor, are used to perform a model processing method as shown in the embodiments of the present application.
According to the model processing scheme provided by the embodiment of the application, a calculation formula of calculation logic of a target calculation model input by a user is received; uploading a calculation formula to a server so as to generate a target measuring and calculating model at the server; if uploading success information fed back by the server is received, determining that the uploading of the target measuring and calculating model is successful; if the uploading of the target measuring and calculating model is successful, the target measuring and calculating model is accessed for measuring and calculating. Compared with the current uploading of the code of the test logic to the server, which causes that the server needs a large amount of cost for identifying and checking the code of the test logic, the embodiment of the application 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 rapidly applied to the test model, the updating period is greatly reduced, and the operation and maintenance cost is reduced.
Drawings
FIG. 1 is a flow chart of a model processing method in a first embodiment of the application;
FIG. 2 is a flow chart of a model processing method in a second embodiment of the application;
FIG. 3 is a schematic view showing a structure of a model processing apparatus in a third embodiment of the present application;
fig. 4 is a schematic structural diagram of a computer device in a fourth embodiment of the present application.
Detailed Description
The application is described in further detail below with reference to the drawings and examples. It is to be understood that the specific embodiments described herein are merely illustrative of the application and are not limiting thereof. It should be further noted that, for convenience of description, only some, but not all of the structures related to the present application are shown in the drawings.
Example 1
Fig. 1 is a flowchart of a model processing method provided in an embodiment of the present application, where the embodiment is applicable to a case where a spreadsheet application performs model calculation, the method may be performed by a terminal, and the terminal may be a personal computer, and the method specifically includes the following steps:
step 110, receiving a calculation formula of calculation logic of the target calculation model input by a user.
The spreadsheet application may be an Excel application or a WPS application. And when the measuring and calculating model is built, after the user opens the electronic form application, loading the plug-in the electronic form application. The plug-in is used to perform the method of the present application. After loading the plug-in, the user edits the measurement logic of the target measurement model, wherein the measurement logic consists of a calculation formula. The measuring and calculating model can be used for measuring and calculating the cost of real estate investment and the like, the electronic form comprises a plurality of cells, a form data processing formula can be established for the current cell, and the form data processing formula can represent the numerical calculation relation of the current cell and data in other cells. And forming a measuring and calculating logic by setting a processing formula of the data in the cells. The plug-in can provide an interface for marking the cells such as cell labels for the user, and the user inputs the calculation formulas of the cells through the editing interface.
Illustratively, receiving a form data processing formula entered by a user through a spreadsheet application; and generating a calculation formula of the measuring and calculating logic according to the table data processing formula.
The user can not only generate a calculation formula of the measuring and calculating logic through the plug-in, but also establish a table data processing formula in the electronic table application. After clicking a cell, the user enters a table data processing formula in the edit box of the cell of the spreadsheet application. And counting the table data processing formulas input in different cells, establishing logic relations 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 form data processing formula input by the user in the interface provided by the electronic form 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 measuring and calculating model. When a user builds a 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 server is used for checking the weight. Only non-duplicate identifications are allowed to remain. The server can store various measuring and calculating models, and in order to accurately and uniquely mark the target measuring and calculating model, the identification of the target measuring and calculating model edited by a user is associated with the calculating formula when the calculating formula is uploaded to the server.
Step 120, uploading the calculation formula to a server so as to generate a target measuring and calculating model at the server.
And after receiving the calculation formula, the server generates a target measuring and calculating model according to the calculation formula. The calculation formula is used to describe a calculation step, and a plurality of calculation formulas can be used to represent a calculation model. And in the uploading process, the server checks the calculation formula, and if the check 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 plug-in reads the identification of the measuring and calculating model after the on-line target measuring and calculating model passes verification, namely the target measuring and calculating model is successfully uploaded, namely the calculation logic of the target measuring and calculating system is determined, after the target measuring and calculating model is uploaded, a user can use the uploaded measuring and calculating model measuring and calculating logic to calculate, the measuring and calculating logic is automatically loaded into a server cache when a measuring and calculating task is created, and the problem that the calculation logic is difficult to maintain after the hard coding mode is adopted is solved.
The user can pre-install the client-side add-in plug-in, the electronic form 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-side after being successfully loaded in the server-side cache, and the client-side displays the latest data of the server-side through the data acquisition module.
Furthermore, the user logs in the plugin at the client, requests the server cache to create/load the investment measuring and calculating model in the plugin, the server cache is successfully loaded, the plugin loading result is returned, and the target measuring and calculating model is downloaded and displayed at the client through the plugin.
And 130, if the uploading success information fed back by the server is received, determining that the uploading of the target measuring and calculating model is successful.
And judging whether uploading success information is received by a plug-in loaded in the electronic form application in the terminal, and if so, outputting the uploading success information to a user and determining that the uploading of the target measuring and calculating model is successful.
And 140, if the uploading of the target measuring and calculating model is successful, accessing the target measuring and calculating model for measuring and calculating.
The data processing mode provided by the embodiment of the application is that a server executes model calculation of a target measuring and calculating model, and plug-ins in the terminal are 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 for measuring and calculating.
According to the model processing method provided by the embodiment of the application, a calculation formula of calculation logic of a target calculation model input by a user is received; uploading a calculation formula to a server so as to generate a target measuring and calculating model at the server; if uploading success information fed back by the server is received, determining that the uploading of the target measuring and calculating model is successful; if the uploading of the target measuring and calculating model is successful, the target measuring and calculating model is accessed for measuring and calculating. Compared with the current uploading of the code of the test logic to the server, which causes that the server needs a large amount of cost for identifying and checking the code of the test logic, the embodiment of the application 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 rapidly applied to the test model, the updating period is greatly reduced, and the operation and maintenance cost is reduced.
Example two
Fig. 2 is a flow chart of a model processing method according to a second embodiment of the present application, which is a further explanation of the above embodiment, and includes:
step 210, receiving a calculation formula of calculation logic of a target calculation model input by a user.
Step 220, uploading the calculation formula to a server so as to generate a target measuring and calculating model at the server.
And 230, if the uploading success information fed back by the server is received, determining that the uploading of the target measuring and calculating model is successful.
Step 240, sending a request for loading the target measurement model to the server so that the server loads the target measurement model.
And performing calculation by using the target calculation model in the server, and sending a request for loading the target calculation model to the server by the plug-in unit. 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, a calculation model list is obtained, wherein the calculation model list comprises calculation model information uploaded in a server; acquiring a target measuring model selected by a user from a measuring model list; and sending a request for loading the target measuring and calculating model to a server.
A plurality of measuring and calculating models exist in the server, and the plug-in needs to acquire a measuring and calculating model list existing in the server at the moment. The calculation model list can be updated locally by the terminal according to a certain time interval, and can also be obtained from a server. The plug-in outputs the measuring model list, and a user selects a target measuring model from the measuring 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.
Step 260, monitor the data file entered by the user in the data input interface.
The user logs in the plug-in the electronic form application, the data file is filled in the electronic form application through the plug-in, and the plug-in uploads the data file to the server side.
After the plug-in logs in, the editing operation of the user in the electronic form application is monitored, the content edited by the user is written into the data file, and uploading and updating of the data file generated by monitoring to the server measuring and calculating model are realized.
Step 270, the data file is sent to the server, so that the target measuring and calculating model loaded by the server calculates the data file uploaded by one or more users, and a measuring and calculating result is obtained.
It can be understood that the target measuring and calculating model is loaded and opened in the server cache, the data uploaded through the electronic form application is correspondingly updated in the target measuring and calculating model of the server cache, the combination of measuring and calculating filling data is realized, the investment measuring and calculating model in the cache is loaded with the calculation logic in the model, and the measuring and calculating result is calculated and output at high speed according to the combined filling data.
And 280, outputting a measuring and calculating result.
Further, after the measurement result is obtained in step 270, the method further includes: storing the measurement result to a persistent storage medium at the network side.
The persistent storage medium may be MongoDB. The measurement and calculation result in the server cache can display the output result on the client through the plug-in unit, and meanwhile, the cache calculation result pushes data to the MongoDB through the data persistence module. By using a persistent storage medium, nonvolatile storage output results can be realized, and data reliability can be improved.
The model processing method provided by the embodiment of the application can use the plug-in the electronic form application, control the server to load the target measuring and calculating model, the plug-in receives the data file input by the user and used for being transmitted into the target measuring and calculating model, the plug-in receives the measuring and calculating result fed back by the server and outputs the measuring and calculating result in the electronic form application, the plug-in the terminal inputs the data file and receives and outputs the measuring and calculating result, the server loads the measuring and calculating model and calculates the model, a quick and easy-to-use measuring and calculating model calling mode is realized, and the measuring and calculating efficiency is improved.
The model processing method provided by the embodiment of the application realizes a measuring and calculating system based on Excel (WPS Excel or Microsoft Excel, hereinafter collectively referred to as Excel). The measuring and calculating system comprises a server side, a spreadsheet application (also called client side) and background management of the client side; the service end and the client end realize business logic calculation of investment calculation based on Excel, replace the current mode of realizing business logic calculation through program codes and a storage process, and the Excel plug-in method can reduce a large amount of code and database development workload. The development of codes and databases is more difficult along with the improvement of service complexity, but the Excel plug-in method is basically not influenced by the service complexity, and a measuring and calculating system can be built by using the Excel plug-in according to the principle of 'service logic through model verification'; meanwhile, background management provides a management entrance of an investment model, and when business or calculation logic changes, an Excel investment model calculation formula can be adjusted to update iteration rapidly, so that the problem that program codes and storage processes are difficult to maintain due to frequent adjustment of business or calculation logic is solved, a user can complete system business update by updating an investment measuring and calculating model through background management after adjusting the business or calculation logic, operation and maintenance non-professional technicians can maintain an updating system, system update convenience is improved, system update stability is enhanced, and later operation and maintenance cost is reduced.
Example III
Fig. 3 is a schematic structural diagram of a model processing device according to a third embodiment of the present application, where the device is applied to a spreadsheet application plug-in, and includes: an input module 31, a measurement logic upload module 32, a network communication module 33, and a model access module 34, wherein:
an input module 31 for receiving a calculation formula of calculation logic of the target calculation model input by a user;
a calculation logic uploading module 32, configured to upload a calculation formula to a server, so as to generate a target calculation model at the server;
the network communication module 33 is configured to determine that the uploading of the target measurement model is successful if the uploading success information fed back by the server is received;
the model accessing module 34 is configured to access the target measurement model for measurement if the uploading of the target measurement model is successful.
Further, the input module 31 is configured to:
receiving a form data processing formula input by a user through a spreadsheet 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 measuring and calculating 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 loads the target measuring and calculating model;
loading a data input interface of a target measuring and calculating model in the electronic form application;
monitoring a data file input by a user in a data input interface;
the data files are sent to a server, so that a target measuring and calculating model loaded by the server calculates the data files uploaded by one or more users, and measuring and calculating results are obtained;
and outputting a measuring and calculating result.
Further, the model access module 34 is configured to:
after obtaining the measurement result, the method further comprises the following steps: storing the measurement result to a persistent storage medium at the network side.
Further, the model access module 34 is configured to:
sending a request for loading the target measurement model to a server, including:
obtaining a calculation model list, wherein the calculation model list comprises calculation model information uploaded in a server;
acquiring a target measuring model selected by a user from a measuring model list;
and sending a request for loading the target measuring and calculating model to a server.
In the model processing device provided by the embodiment of the application, the input module 31 receives a calculation formula of calculation logic of a target calculation 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 uploading of the target measurement model is successful if the uploading success information fed back by the server is received; the model accessing module 34 is configured to access the target measurement model for measurement if the uploading of the target measurement model is successful. Compared with the current uploading of the code of the test logic to the server, which causes that the server needs a large amount of cost for identifying and checking the code of the test logic, the embodiment of the application 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 rapidly applied to the test model, the updating period is greatly reduced, and the operation and maintenance cost is reduced.
The model processing device provided by the embodiment of the application can execute the model processing method provided by any embodiment of the application, and has the corresponding functional modules and beneficial effects of the execution method.
Example IV
Fig. 4 is a schematic structural diagram of a computer device according to a fourth embodiment of the present application, and as shown in fig. 4, the computer device 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, one processor 40 being taken as an example in fig. 4; the processor 40, the memory 41, the input means 42 and the output means 43 in the computer device may be connected by a bus or by other means, in fig. 4 by way of example.
The memory 41 is a computer readable storage medium, and may be used to store software programs, computer executable programs, and modules, such as program instructions/modules (e.g., the input module 31, the measurement 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 application. The processor 40 executes various functional applications of the computer device and data processing, i.e., implements the above-described model processing method, by running 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, at least one application program required for functions; the storage data area may store data created according to the use of the terminal, etc. In addition, 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 comprise memory located remotely from processor 40, which may be connected to the computer device via 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 means 42 may be used to receive entered numeric or character information and to generate key signal inputs related to user settings and function control of the computer device. The output means 43 may comprise a display device such as a display screen.
Example five
A fifth embodiment of the present application also provides a storage medium containing computer-executable instructions, which when executed by a computer processor, are for performing a model processing method, the method comprising:
receiving a calculation formula of calculation logic of a target calculation model input by a user;
uploading a calculation formula to a server so as to generate a target measuring and calculating model at the server;
if uploading success information fed back by the server is received, determining that the uploading of the target measuring and calculating model is successful;
if the uploading of the target measuring and calculating model is successful, the target measuring and calculating model is accessed for measuring and calculating.
Further, a calculation formula of the calculation logic of the target calculation model, which receives the input of the user, includes:
receiving a form data processing formula input by a user through a spreadsheet application;
and generating a calculation formula of the measuring and calculating logic according to the table data processing formula.
Further, uploading the calculation formula to the server includes:
and uploading a calculation formula to a server according to the identification of the target measuring and calculating model.
Further, accessing the target measurement model for measurement, including:
sending a request for loading the target measuring and calculating model to a server so that the server loads the target measuring and calculating model;
loading a data input interface of a target measuring and calculating model in the electronic form application;
monitoring a data file input by a user in a data input interface;
the data files are sent to a server, so that a target measuring and calculating model loaded by the server calculates the data files uploaded by one or more users, and measuring and calculating results are obtained;
and outputting a measuring and calculating result.
Further, after obtaining the measurement result, the method further includes: storing the measurement result to a persistent storage medium at the network side.
Further, sending a request for loading the target measurement model to the server, including:
obtaining a calculation model list, wherein the calculation model list comprises calculation model information uploaded in a server;
acquiring a target measuring model selected by a user from a measuring model list;
and sending a request for loading the target measuring and calculating model to a server.
Of course, the storage medium containing the computer executable instructions provided in the embodiments of the present application is not limited to the above method operations, and may also perform the related operations in the model processing method provided in any embodiment of the present application.
From the above description of embodiments, it will be clear to a person skilled in the art that the present application may be implemented by means of software and necessary general purpose hardware, but of course also by means of hardware, although in many cases the former is a preferred embodiment. Based on such understanding, the technical solution of the present application 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 a floppy disk, a Read-Only Memory (ROM), a random access Memory (Random Access Memory, RAM), a FLASH Memory (FLASH), a hard disk or an optical disk of a computer, etc., including several instructions for causing a computer device (which may be a personal computer, a server, a network device, etc.) to execute the method of the embodiments of the present application.
It should be noted that, in the above-mentioned embodiments of the search apparatus, each unit and module included are only divided according to the functional logic, but not limited to the above-mentioned division, as long as the corresponding functions can be implemented; in addition, the specific names of the functional units are also only for distinguishing from each other, and are not used to limit the protection scope of the present application.
Note that the above is only a preferred embodiment of the present application and the technical principle applied. It will be understood by those skilled in the art that the present application is not limited to the particular embodiments described 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 application. Therefore, while the application has been described in connection with the above embodiments, the application is not limited to the embodiments, but may be embodied in many other equivalent forms without departing from the spirit or scope of the application, which is set forth in the following claims.
Claims (8)
1. A model processing method, applied to a spreadsheet application plug-in, comprising:
receiving a calculation formula of calculation logic of a target calculation model input by a user;
uploading the calculation formula to a server so as to generate a target measuring and calculating model at the server;
if uploading success information fed back by the server is received, determining that the uploading of the target measuring and calculating model is successful;
if the uploading of the target measuring and calculating model is successful, accessing the target measuring and calculating model for measuring and calculating;
the accessing the target measuring model for measuring and calculating comprises the following steps:
sending a request for loading a target measuring and calculating model to a server so that the server loads the target measuring and calculating model;
loading a data input interface of the target measuring and calculating model in a spreadsheet application;
monitoring a data file input by a user in the data input interface;
the data files are sent to the server, so that the target measuring and calculating model loaded by the server calculates the data files uploaded by one or more users, and measuring and calculating results are obtained;
and outputting the measuring and calculating result.
2. The model processing method according to claim 1, wherein the calculation formula of the calculation logic of the target calculation model receiving the user input includes:
receiving a form data processing formula input by a user through a spreadsheet application;
and generating a calculation formula of the measuring and calculating logic according to the table data processing formula.
3. The method of claim 1, wherein uploading the calculation formula to a server comprises:
and uploading the calculation formula to a server according to the identification of the target measuring and calculating model.
4. The model processing method according to claim 1, further comprising, after obtaining the measurement result: and storing the measuring and calculating result to a persistent storage medium of the network.
5. The model processing method according to claim 1, wherein the sending a request for loading the target measurement model to the server includes:
obtaining a calculation model list, wherein the calculation model list comprises calculation model information uploaded in a server;
acquiring a target measuring model selected by a user from the measuring model list;
and sending a request for loading the target measuring and calculating model to the server.
6. A model processing apparatus for use with a spreadsheet application plug-in, comprising:
the input module is used for receiving a calculation formula of calculation logic of the target 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 uploading of the target measuring and calculating model is successful if uploading success information fed back by the server is received;
the model access module is used for accessing the target measuring and calculating model to measure and calculate if the uploading of the target measuring and calculating model is successful;
the model access module is used for:
sending a request for loading a target measuring and calculating model to a server so that the server loads the target measuring and calculating model;
loading a data input interface of the target measuring and calculating model in a spreadsheet application;
monitoring a data file input by a user in the data input interface;
the data files are sent to the server, so that the target measuring and calculating model loaded by the server calculates the data files uploaded by one or more users, and measuring and calculating results are obtained;
and outputting the measuring and calculating result.
7. 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 of claims 1-5 when executing the program.
8. A storage medium containing computer executable instructions for performing the model processing method of any of claims 1-5 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 CN111159988A (en) | 2020-05-15 |
| CN111159988B true 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) |
Families Citing this family (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 (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
| 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 |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US9588953B2 (en) * | 2011-10-25 | 2017-03-07 | Microsoft Technology Licensing, Llc | Drag and drop always sum formulas |
| US10013412B2 (en) * | 2014-08-25 | 2018-07-03 | Purple Robot Software, Inc. | Peer to peer spreadsheet processing |
-
2019
- 2019-12-31 CN CN201911423727.XA patent/CN111159988B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
| 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 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111159988A (en) | 2020-05-15 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107341098B (en) | Software performance testing method, platform, equipment and 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 | |
| CN111522728A (en) | Method for generating automatic test case, electronic device and readable storage medium | |
| CN111367530B (en) | Code auditing method, terminal and server based on custom auditing rules | |
| CN110502538B (en) | Method, system, equipment and storage medium for portrait tag generation logic mapping | |
| CN105868956A (en) | Data processing method and device | |
| CN112835808A (en) | Interface testing method and device, computer equipment and storage medium | |
| CN113377372A (en) | Business rule analysis method and device, computer equipment and storage medium | |
| CN113722370A (en) | Data management method, device, equipment and medium based on index analysis | |
| CN115658452A (en) | Buried point checking method, buried point checking device, readable storage medium and electronic equipment | |
| CN111159988B (en) | Model processing method, device, computer equipment and storage medium | |
| CN109087107B (en) | Real-time monitoring method and system based on distributed memory database and electronic equipment | |
| CN114118985A (en) | Resource information management method, system, medium, and computer device | |
| CN112528206A (en) | Webpage log collection method and device, electronic equipment and storage medium | |
| CN116303320A (en) | Real-time task management method, device, equipment and medium based on log file | |
| CN115834195A (en) | Log anomaly detection method, device, system and medium | |
| CN107067137A (en) | A kind of power marketing metering class's routine work management control method and system | |
| CN113282504A (en) | Incremental code coverage rate detection method and service development method and device | |
| CN114826879B (en) | Log transmission method, device and system | |
| CN112561690B (en) | Method, system, equipment and storage medium for testing credit card staged service interface | |
| CN111651429B (en) | Big data scheduling parameter management method, device and distributed platform | |
| CN116319716A (en) | Information processing method, no-service system, electronic device, and storage medium | |
| CN117151604A (en) | Residence network management method and electronic equipment | |
| CN113918817A (en) | Push model construction method and device, computer 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 | ||
| 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. |
|
| CB02 | Change of applicant information | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |