CN112668939A - Enterprise performance automatic evaluation method and system based on excelVBA technology - Google Patents
Enterprise performance automatic evaluation method and system based on excelVBA technology Download PDFInfo
- Publication number
- CN112668939A CN112668939A CN202110063870.3A CN202110063870A CN112668939A CN 112668939 A CN112668939 A CN 112668939A CN 202110063870 A CN202110063870 A CN 202110063870A CN 112668939 A CN112668939 A CN 112668939A
- Authority
- CN
- China
- Prior art keywords
- data
- index
- excel
- module
- performance evaluation
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- User Interface Of Digital Computer (AREA)
Abstract
The invention provides an automatic evaluation method for enterprise performance based on an Excel VBA technology, which comprises the following steps: establishing a performance evaluation index system; reading the original data stored in the Excel documents into an Excel document of a performance evaluation index system through a data reading module; processing the value of each index by a min-max standardization method through a data processing module, and carrying out information aggregation through an evidence reasoning method to obtain the value of a total index, namely an enterprise performance evaluation result; the read and calculated data is inspected and abnormal values are marked out to prompt the attention of a user through a data inspection and marking module; and displaying the evaluation result and the change trend of each index month/quarter/year in a sheet page of the total index and each index through a graphical expression and visualization module.
Description
Technical Field
The invention relates to the technical field of computer application, in particular to an automatic evaluation method and system for enterprise performance based on an excelVBA technology.
Background
The management data of a plurality of enterprises are stored, processed and displayed in the form of Excel documents, and various data and forms are often incompatible due to different sources, different expression forms and different purposes, so that a large amount of repeated data extraction and processing work exists in performance evaluation work. The traditional method is manually operated, data needs to be extracted from different Excel documents respectively, and the problems of low efficiency and high error rate exist. The VBA is used as an Excel built-in programming language with strong functions, a user is allowed to insert control buttons, custom functions and commands into the Excel, the problems of extraction and processing of a large amount of data can be solved well through special design, and then automatic evaluation of enterprise performance is achieved. But currently, the function development based on the VBA technology is relatively lacked.
Disclosure of Invention
According to the technical problem that functional development based on the VBA technology is lacked, the automatic evaluation method and system for enterprise performance based on the excelVBA technology are provided. The invention mainly utilizes an automatic evaluation method for enterprise performance based on Excel VBA technology, which is characterized by comprising the following steps:
step 1: establishing a performance evaluation index system; storing an Excel document containing the designated naming rule of the original data in a designated folder according to the requirement;
step 2: reading the original data stored in the Excel documents into an Excel document of a performance evaluation index system through a data reading module;
and step 3: processing the value of each index by a min-max standardization method through a data processing module, and carrying out information aggregation through an evidence reasoning method to obtain the value of a total index, namely an enterprise performance evaluation result;
and 4, step 4: the read and calculated data is inspected and abnormal values are marked out to prompt the attention of a user through a data inspection and marking module;
and 5: through a graphic expression and visualization module, the evaluation result and the change trend of each index month by month/quarter/year are displayed in the form of a line graph in the general indexes and the sheet page of each index; and when the graph is generated, the graphic expression and visualization module can be quitted after the pop-up dialog box prompts that visualization is finished.
Further, the step 2 further comprises the following steps:
step 2.1: in the Excel document of the performance evaluation index system, creating a sheet page for each index in the performance evaluation index system, and naming according to the index name;
step 2.2: designing a cell range for index data storage in each sheet page, and marking row names and column names;
step 2.3: sequentially reading the original data of each index, and writing the original data into the corresponding cell position of the Excel document of the corresponding performance evaluation index system;
step 2.4: if the Excel document name cannot be read, popping up a dialog box to prompt that the data of the current index is not read successfully, and quitting the data reading module; the user can re-enter the step 2.3 after modifying or supplementing the Excel document corresponding to the index according to the prompt;
step 2.5: and if the data reading of all the indexes is finished, popping up a dialog box to prompt that the data reading is finished, and quitting the data reading module.
Still further, the step 3 further comprises the following steps:
step 3.1: creating a sheet page for the total index in the Excel document of the performance evaluation index system;
step 3.2: designing a total index, each index weight and a cell range for storing index calculation results in the sheet page, and labeling row and column names;
step 3.3: clicking an evaluation calculation button, operating a background VBA program, calculating data of each index according to a specific formula, writing a calculation result into a corresponding position of a total index sheet page, and reserving the calculation formula in a cell;
step 3.4: after the calculation of all indexes is completed, carrying out information aggregation according to the weight of each index and the calculation result to obtain the calculation result of the total index, namely the performance evaluation result of the enterprise, and writing the calculation result into the corresponding cell position;
step 3.5: and popping up a dialog box to prompt that the evaluation calculation is finished, and quitting the data processing module.
Further, the step 4 further comprises the following steps:
step 4.1: traversing each data to be inspected;
step 4.2: the data range can be set manually according to the inspection standard, or the data range can be set according to the confidence level of the historical data, and if the inspected data exceeds the set data range, the cells of the abnormal value are marked as a specific color; otherwise, it is marked as colorless;
step 4.3: for the calculated data, if the current value is not the final result, for example, a value which needs to be accurately calculated after the next event occurs, marking the corresponding cell as a specific color;
step 4.4: and when all the data to be inspected are traversed, popping up a dialog box to prompt that the inspection is finished, and exiting the data inspection and marking module after clicking a 'confirm' button.
Furthermore, the invention also comprises an automatic enterprise performance evaluation system based on the Excel VBA technology, which is characterized in that: the method comprises the following steps: the system comprises a data reading module, a data processing module, a data checking and marking module and a graphic expression and visualization module for expressing an evaluation result in a graph form;
the data reading module reads original data stored in a plurality of Excel documents into the Excel documents of the enterprise performance evaluation system; the data reading module further comprises: data counted by event or data counted by event classification;
the data processing module is used for performing standardized calculation and information aggregation on the read data;
the data checking and marking module is responsible for checking the read and calculated data, and according to historical data statistical results or a manually preset range, the abnormal value cells with confidence degrees lower than 90% or exceeding the manually set range are marked as specific colors to prompt a user to pay attention; cells that are not the final calculation result are labeled with a particular color to alert the user.
Compared with the prior art, the invention has the following advantages:
(1) the method can realize the information reading of the appointed time interval or event through a simple interaction mode, can realize the rapid and accurate reading of the corresponding data from a plurality of Excel documents and the writing of the corresponding data into the Excel documents of the performance evaluation of the enterprise, completes the reading and the writing of the data within the second level, has stable performance, can replace the traditional manual entry one by one, reduces the repetitive work, and can effectively improve the efficiency and the accuracy of the data entry;
(2) the method can set the interval range of data inspection through an interactive mode, realize the automatic inspection and marking of the input data and the calculated data, save the time of inspecting the data by a user and greatly improve the inspection efficiency;
(3) the method can realize the automation of graphic expression and visualization of the evaluation result, and has the advantages of convenience, intuition and the like;
(4) the method is used for the enterprise performance evaluation system, can be well compatible with the data storage form of the enterprise, is simple to operate, is easy to master and is convenient to popularize.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings needed to be used in the description of the embodiments or the prior art will be briefly introduced below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to these drawings without creative efforts.
FIG. 1 is a schematic flow diagram of the process of the present invention;
FIG. 2 is a schematic diagram of the system of the present invention;
FIG. 3 is a schematic diagram of a file storage format of the system of the present invention;
FIG. 4 is a schematic diagram of a data storage form of index 1 according to the present invention;
FIG. 5 is a schematic diagram of a main interface of the system of the present invention;
FIG. 6 is a diagram of an unsuccessful data read notification system according to the present invention;
FIG. 7 is a diagram of a data read success prompt message for the system of the present invention;
FIG. 8 is a diagram of a prompt for completion of evaluation calculations for the system of the present invention;
FIG. 9 is a diagram of data inspection completion prompts for the system of the present invention;
FIG. 10 is a visual completion cue map of the system of the present invention;
FIG. 11 is a comparison example graph of the full set of evaluation results in the visualization of the system of the present invention;
FIG. 12 is an exemplary graph of single set of evaluation results in a visualization of the system of the present invention.
Detailed Description
In order to make the technical solutions of the present invention better understood, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
It should be noted that the terms "first," "second," and the like in the description and claims of the present invention and in the drawings described above are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used is interchangeable under appropriate circumstances such that the embodiments of the invention described herein are capable of operation in sequences other than those illustrated or described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
As shown in fig. 1 to 12, the invention provides an automatic evaluation method for enterprise performance based on an Excel VBA technology, which is characterized by comprising the following steps:
step 1: establishing a performance evaluation index system; storing an Excel document containing the designated naming rule of the original data in a designated folder according to the requirement; taking the index "traffic Volume" as an example, the requirement here means that an Excel document containing the transportation Volume data of the ship A counted by month or voyage is named as shifting _ Volume _ A.xlsx and is stored under the folder "traffic Volume"; the index may be the traffic volume of the month or the current voyage, or may be an average value of consecutive 3 months or voyages of the traffic volume, and needs to be determined according to an evaluation index designed in the performance evaluation index system. As shown in fig. 3, the index is a plurality of indexes for evaluating performance, for example, index 1 and index 2.
Step 2: reading the original data stored in the Excel documents into an Excel document of a performance evaluation index system through a data reading module; the adopted data reading algorithm is realized through VBA language, firstly, the path of an Excel document of a performance evaluation index system is identified, and the path of the read Excel document is set according to the name of a folder of each index; further positioning a target document according to the information in the Excel document name; and finally, opening the document, determining the position of the read cell through information in the traversal table, writing the data of the cell to be read into the corresponding position of the Excel document in the performance evaluation index system, and closing the read Excel document.
And step 3: processing the value of each index by a min-max standardization method through a data processing module, and carrying out information aggregation through an evidence reasoning method to obtain the value of a total index, namely an enterprise performance evaluation result; in the present application, the calculation process is implemented by VBA programming, and the calculation formula is retained in the cell; other data normalization methods such as z-score can also be used for data normalization; the information aggregation may also adopt other information aggregation methods such as a weighted sum method.
And 4, step 4: the read and calculated data is inspected and abnormal values are marked out to prompt the attention of a user through a data inspection and marking module; the data inspection is mainly based on the concept of a confidence interval in statistics, through statistics of historical data, the significance level is defaulted to 0.1, namely the confidence interval with the confidence degree of 90% is used as the basis of the data inspection, and data abnormality is marked when the confidence interval exceeds the range. Wherein the significance level or confidence interval boundary may also be set via the interactive interface.
And 5: through a graphical representation and visualization module, the evaluation results and the change trend of each index month/quarter/year are displayed in the form of line graphs such as fig. 11 and 12 in the general indexes and the sheet page of each index; and when the graph is generated, the graphic expression and visualization module can be quitted after the pop-up dialog box prompts that visualization is finished.
As a preferred embodiment, in the present application, the step 2 further includes the steps of:
step 2.1: in the Excel document of the performance evaluation index system, creating a sheet page for each index in the performance evaluation index system, and naming according to the index name;
step 2.2: designing a cell range for index data storage in each sheet page, and marking row names and column names;
step 2.3: sequentially reading the original data of each index, and writing the original data into the corresponding cell position of the Excel document of the corresponding performance evaluation index system;
step 2.4: if the Excel document name cannot be read, popping up a dialog box to prompt that the data of the current index is not read successfully, and quitting the data reading module; the user can re-enter the step 2.3 after modifying or supplementing the Excel document corresponding to the index according to the prompt;
step 2.5: and if the data reading of all the indexes is finished, popping up a dialog box to prompt that the data reading is finished, and quitting the data reading module.
Preferably, the step 3 further comprises the following steps:
step 3.1: creating a sheet page for the total index in the Excel document of the performance evaluation index system;
step 3.2: designing a total index, each index weight and a cell range for storing index calculation results in the sheet page, and labeling row and column names;
step 3.3: clicking an evaluation calculation button, operating a background VBA program, calculating data of each index according to a specific formula, writing a calculation result into a corresponding position of a total index sheet page, and reserving the calculation formula in a cell;
step 3.4: after the calculation of all indexes is completed, carrying out information aggregation according to the weight of each index and the calculation result to obtain the calculation result of the total index, namely the performance evaluation result of the enterprise, and writing the calculation result into the corresponding cell position;
step 3.5: and popping up a dialog box to prompt that the evaluation calculation is finished, and quitting the data processing module.
As a preferred embodiment, the step 4 further comprises the following steps:
step 4.1: traversing each data to be inspected;
step 4.2: the data range can be set manually according to the inspection standard, or the data range can be set according to the confidence level of the historical data, and if the inspected data exceeds the set data range, the cells of the abnormal value are marked as a specific color; otherwise, it is marked as colorless;
step 4.3: for the calculated data, if the current value is not the final result, for example, a value which needs to be accurately calculated after the next event occurs, marking the corresponding cell as a specific color;
step 4.4: and when all the data to be inspected are traversed, popping up a dialog box to prompt that the inspection is finished, and exiting the data inspection and marking module after clicking a 'confirm' button.
As a preferred embodiment, the present application further includes an automatic enterprise performance evaluation system based on the Excel VBA technology, including: the system comprises a data reading module, a data processing module, a data checking and marking module and a graphic expression and visualization module for expressing an evaluation result in a graph form;
the data reading module reads original data stored in a plurality of Excel documents into the Excel documents of the enterprise performance evaluation system; the data reading module further comprises: data counted by event or data counted by event classification;
the data processing module is used for performing standardized calculation and information aggregation on the read data;
the data checking and marking module is responsible for checking the read and calculated data, and according to historical data statistical results or a manually preset range, the abnormal value cells with confidence degrees lower than 90% or exceeding the manually set range are marked as specific colors to prompt a user to pay attention; cells that are not the final calculation result are labeled with a particular color to alert the user.
The above-mentioned serial numbers of the embodiments of the present invention are merely for description and do not represent the merits of the embodiments.
In the above embodiments of the present invention, the descriptions of the respective embodiments have respective emphasis, and for parts that are not described in detail in a certain embodiment, reference may be made to related descriptions of other embodiments.
In the embodiments provided in the present application, it should be understood that the disclosed technology can be implemented in other ways. The above-described embodiments of the apparatus are merely illustrative, and for example, the division of the unit may be a logical function division, and there may be another division manner in actual implementation.
Finally, it should be noted that: the above embodiments are only used to illustrate the technical solution of the present invention, and not to limit the same; while the invention has been described in detail and with reference to the foregoing embodiments, it will be understood by those skilled in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some or all of the technical features may be equivalently replaced; and the modifications or the substitutions do not make the essence of the corresponding technical solutions depart from the scope of the technical solutions of the embodiments of the present invention.
Claims (5)
1. An automatic evaluation method for enterprise performance based on Excel VBA technology is characterized by comprising the following steps:
step 1: establishing a performance evaluation index system; storing an Excel document containing the designated naming rule of the original data in a designated folder according to the requirement;
step 2: reading the original data stored in the Excel documents into an Excel document of a performance evaluation index system through a data reading module;
and step 3: processing the value of each index by a min-max standardization method through a data processing module, and carrying out information aggregation through an evidence reasoning method to obtain the value of a total index, namely an enterprise performance evaluation result;
and 4, step 4: the read and calculated data is inspected and abnormal values are marked out to prompt the attention of a user through a data inspection and marking module;
and 5: through a graphic expression and visualization module, the evaluation result and the change trend of each index month by month/quarter/year are displayed in the form of a line graph in the general indexes and the sheet page of each index; and when the graph is generated, the graphic expression and visualization module can be quitted after the pop-up dialog box prompts that visualization is finished.
2. The method for automatically evaluating the performance of an enterprise based on the Excel VBA technology as claimed in claim 1, wherein the step 2 further comprises the following steps:
step 2.1: in the Excel document of the performance evaluation index system, creating a sheet page for each index in the performance evaluation index system, and naming according to the index name;
step 2.2: designing a cell range for index data storage in each sheet page, and marking row names and column names;
step 2.3: sequentially reading the original data of each index, and writing the original data into the corresponding cell position of the Excel document of the corresponding performance evaluation index system;
step 2.4: if the Excel document name cannot be read, popping up a dialog box to prompt that the data of the current index is not read successfully, and quitting the data reading module; the user can re-enter the step 2.3 after modifying or supplementing the Excel document corresponding to the index according to the prompt;
step 2.5: and if the data reading of all the indexes is finished, popping up a dialog box to prompt that the data reading is finished, and quitting the data reading module.
3. The method for automatically evaluating the performance of an enterprise based on the Excel VBA technology as claimed in claim 1, wherein the step 3 further comprises the following steps:
step 3.1: creating a sheet page for the total index in the Excel document of the performance evaluation index system;
step 3.2: designing a total index, each index weight and a cell range for storing index calculation results in the sheet page, and labeling row and column names;
step 3.3: clicking an evaluation calculation button, operating a background VBA program, calculating data of each index according to a specific formula, writing a calculation result into a corresponding position of a total index sheet page, and reserving the calculation formula in a cell;
step 3.4: after the calculation of all indexes is completed, carrying out information aggregation according to the weight of each index and the calculation result to obtain the calculation result of the total index, namely the performance evaluation result of the enterprise, and writing the calculation result into the corresponding cell position;
step 3.5: and popping up a dialog box to prompt that the evaluation calculation is finished, and quitting the data processing module.
4. The method for automatically evaluating the performance of an enterprise based on the Excel VBA technology as claimed in claim 1, wherein the step 4 further comprises the following steps:
step 4.1: traversing each data to be inspected;
step 4.2: the data range can be set manually according to the inspection standard, or the data range can be set according to the confidence level of the historical data, and if the inspected data exceeds the set data range, the cells of the abnormal value are marked as a specific color; otherwise, it is marked as colorless;
step 4.3: for the calculated data, if the current value is not the final result, for example, a value which needs to be accurately calculated after the next event occurs, marking the corresponding cell as a specific color;
step 4.4: and when all the data to be inspected are traversed, popping up a dialog box to prompt that the inspection is finished, and exiting the data inspection and marking module after clicking a 'confirm' button.
5. An automatic evaluation system for enterprise performance based on Excel VBA technology, which applies the method of claims 1-4, is characterized in that:
the method comprises the following steps: the system comprises a data reading module, a data processing module, a data checking and marking module and a graphic expression and visualization module for expressing an evaluation result in a graph form;
the data reading module reads original data stored in a plurality of Excel documents into the Excel documents of the enterprise performance evaluation system; the data reading module further comprises: data counted by event or data counted by event classification;
the data processing module is used for performing standardized calculation and information aggregation on the read data;
the data checking and marking module is responsible for checking the read and calculated data, and according to historical data statistical results or a manually preset range, the abnormal value cells with confidence degrees lower than 90% or exceeding the manually set range are marked as specific colors to prompt a user to pay attention; cells that are not the final calculation result are labeled with a particular color to alert the user.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110063870.3A CN112668939A (en) | 2021-01-18 | 2021-01-18 | Enterprise performance automatic evaluation method and system based on excelVBA technology |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110063870.3A CN112668939A (en) | 2021-01-18 | 2021-01-18 | Enterprise performance automatic evaluation method and system based on excelVBA technology |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112668939A true CN112668939A (en) | 2021-04-16 |
Family
ID=75415501
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110063870.3A Pending CN112668939A (en) | 2021-01-18 | 2021-01-18 | Enterprise performance automatic evaluation method and system based on excelVBA technology |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112668939A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114169793A (en) * | 2021-12-15 | 2022-03-11 | 国家工业信息安全发展研究中心 | Industrial Internet platform application evaluation method and evaluation system thereof |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7006992B1 (en) * | 2000-04-06 | 2006-02-28 | Union State Bank | Risk assessment and management system |
| CN101377831A (en) * | 2007-08-31 | 2009-03-04 | 中芯国际集成电路制造(上海)有限公司 | System and method for processing performance |
| CN101706892A (en) * | 2009-11-17 | 2010-05-12 | 深圳市监察局 | Electronic monitoring method and system of performance evaluation |
| CN102567536A (en) * | 2011-12-31 | 2012-07-11 | 南京柏梭信息科技有限公司 | Key performance target analyzing method based on data statistics |
| CN104391832A (en) * | 2014-11-18 | 2015-03-04 | 浪潮电子信息产业股份有限公司 | Method for combining data in multiple EXCEL data sheets by using VBA (Visual Basic for Applications) |
| US20200004811A1 (en) * | 2018-06-29 | 2020-01-02 | Microsoft Technology Licensing, Llc | Rendering lambda functions in spreadsheet applications |
| CN110781252A (en) * | 2019-11-05 | 2020-02-11 | 安徽数据堂科技有限公司 | Intelligent data analysis visualization method based on big data |
-
2021
- 2021-01-18 CN CN202110063870.3A patent/CN112668939A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7006992B1 (en) * | 2000-04-06 | 2006-02-28 | Union State Bank | Risk assessment and management system |
| CN101377831A (en) * | 2007-08-31 | 2009-03-04 | 中芯国际集成电路制造(上海)有限公司 | System and method for processing performance |
| CN101706892A (en) * | 2009-11-17 | 2010-05-12 | 深圳市监察局 | Electronic monitoring method and system of performance evaluation |
| CN102567536A (en) * | 2011-12-31 | 2012-07-11 | 南京柏梭信息科技有限公司 | Key performance target analyzing method based on data statistics |
| CN104391832A (en) * | 2014-11-18 | 2015-03-04 | 浪潮电子信息产业股份有限公司 | Method for combining data in multiple EXCEL data sheets by using VBA (Visual Basic for Applications) |
| US20200004811A1 (en) * | 2018-06-29 | 2020-01-02 | Microsoft Technology Licensing, Llc | Rendering lambda functions in spreadsheet applications |
| CN110781252A (en) * | 2019-11-05 | 2020-02-11 | 安徽数据堂科技有限公司 | Intelligent data analysis visualization method based on big data |
Non-Patent Citations (1)
| Title |
|---|
| 袁虹;: "科研工作绩效评估方法研究", 太原科技, no. 01, pages 53 - 54 * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114169793A (en) * | 2021-12-15 | 2022-03-11 | 国家工业信息安全发展研究中心 | Industrial Internet platform application evaluation method and evaluation system thereof |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7565270B2 (en) | Quality analysis method and program | |
| CN110738027B (en) | Computer-implemented method, apparatus, and storage medium for generating spreadsheet formulas | |
| WO1996027837A1 (en) | Apparatus for applying if-then-else rules to relational database | |
| CN111027294A (en) | Table summarizing method, device and system | |
| Sousa et al. | Enterprise transformation: The serasa experian case | |
| US9678628B2 (en) | Method for generating control-code by a control-code-diagram | |
| CN111079387A (en) | Automatic questionnaire generation method and device, computer equipment and storage medium | |
| CN110532269B (en) | Cross-country accounting criterion conversion method based on machine learning financial statement | |
| US9311289B1 (en) | Spreadsheet document tab conditional formatting | |
| CN113763502B (en) | Chart generation method, device, equipment and storage medium | |
| CN112668939A (en) | Enterprise performance automatic evaluation method and system based on excelVBA technology | |
| CN112487072B (en) | Method, device, system and medium for standardizing parameter structure of electronic component | |
| Tichy et al. | Juice | |
| US20100313106A1 (en) | Converting diagrams between formats | |
| CN115293682A (en) | Abnormal logistics order monitoring method and related device | |
| CN111783211B (en) | Automatic generation method and generation system for laminated plan of completion monomer building | |
| CN114326642A (en) | Interface matching method, device, equipment and medium for nuclear power DCS (distributed control System) | |
| TWI509430B (en) | Automatically generate patent bibliographic data analysis report method and system | |
| Lambert-Torres et al. | An Intelligent System for Wrong Data Detection and Correction for Demand Forecasting Purpose | |
| CN111191447B (en) | Equipment defect classification method, device and equipment | |
| CN110362452B (en) | Batch operation and maintenance method and system | |
| CN116070607A (en) | Power grid planning data verification method, system, electronic equipment and storage medium | |
| CN115935940A (en) | Automatic generation method and system for judicial complex documents, electronic equipment and storage medium | |
| CN116976807A (en) | Bill processing method and device | |
| CN116342239A (en) | Modeling method for public customer control relationship by bank |
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 |