CN112883692A - Automatic generation method of PPT data report - Google Patents
Automatic generation method of PPT data report Download PDFInfo
- Publication number
- CN112883692A CN112883692A CN202011142971.1A CN202011142971A CN112883692A CN 112883692 A CN112883692 A CN 112883692A CN 202011142971 A CN202011142971 A CN 202011142971A CN 112883692 A CN112883692 A CN 112883692A
- Authority
- CN
- China
- Prior art keywords
- data
- ppt
- file
- template
- universal
- 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
- 238000000034 method Methods 0.000 title claims abstract description 53
- 238000004422 calculation algorithm Methods 0.000 claims description 29
- 238000004458 analytical method Methods 0.000 claims description 22
- 238000005457 optimization Methods 0.000 claims description 19
- 230000005540 biological transmission Effects 0.000 claims description 9
- 238000012545 processing Methods 0.000 claims description 7
- 230000011218 segmentation Effects 0.000 claims description 7
- 230000006870 function Effects 0.000 claims description 6
- 238000012795 verification Methods 0.000 claims description 6
- 230000008859 change Effects 0.000 claims description 5
- 238000012546 transfer Methods 0.000 claims description 4
- 230000009466 transformation Effects 0.000 claims description 4
- 238000006062 fragmentation reaction Methods 0.000 claims description 3
- 239000000203 mixture Substances 0.000 claims description 3
- 238000010845 search algorithm Methods 0.000 claims description 2
- 101710129069 Serine/threonine-protein phosphatase 5 Proteins 0.000 description 62
- 101710199542 Serine/threonine-protein phosphatase T Proteins 0.000 description 62
- 229920000470 poly(p-phenylene terephthalate) polymer Polymers 0.000 description 62
- 238000010586 diagram Methods 0.000 description 10
- 238000001914 filtration Methods 0.000 description 3
- 238000007726 management method Methods 0.000 description 3
- 230000008569 process Effects 0.000 description 3
- 238000003860 storage Methods 0.000 description 3
- 230000009286 beneficial effect Effects 0.000 description 2
- 238000006243 chemical reaction Methods 0.000 description 2
- 239000003086 colorant Substances 0.000 description 2
- 238000004590 computer program Methods 0.000 description 2
- 238000013480 data collection Methods 0.000 description 2
- 238000013461 design Methods 0.000 description 2
- 238000012423 maintenance Methods 0.000 description 2
- 238000012163 sequencing technique Methods 0.000 description 2
- 230000001360 synchronised effect Effects 0.000 description 2
- 238000013459 approach Methods 0.000 description 1
- 238000010420 art technique Methods 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 238000004140 cleaning Methods 0.000 description 1
- 239000012141 concentrate Substances 0.000 description 1
- 238000010219 correlation analysis Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 230000018109 developmental process Effects 0.000 description 1
- 238000009826 distribution Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000008676 import Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 238000011835 investigation Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000013507 mapping Methods 0.000 description 1
- 239000003550 marker Substances 0.000 description 1
- 239000000463 material Substances 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
- 230000008520 organization Effects 0.000 description 1
- 238000002360 preparation method Methods 0.000 description 1
- 230000035484 reaction time Effects 0.000 description 1
- 230000009467 reduction Effects 0.000 description 1
- 238000005070 sampling Methods 0.000 description 1
- 238000000926 separation method Methods 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 239000002699 waste material Substances 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
Abstract
The invention discloses an automatic generation method of a PPT data report, and belongs to the technical field of automatic office. The method comprises the following steps: the method comprises the following steps of (1) obtaining a target original data record of a use scene, wherein the target original data record comprises an information field and a file resource field; designing a data report template, and defining the data report template into a universal PPT template pattern, wherein the universal PPT template pattern comprises a region corresponding to the information field and a region corresponding to the file resource field; step (3) carrying out data marking in the universal PPT template pattern, wherein the data marking is used for establishing the relation between the universal PPT template pattern and the data to be displayed; setting parameters of a universal PPT template pattern; and (5) reading the data report template, identifying the data marks of the data report template, automatically searching in a database, and then filling in the appointed position.
Description
Technical Field
The invention belongs to the technical field of automatic office work, and particularly relates to an automatic generation method of a PPT data report.
Background
Office automation and paperless operation are provided for many years, and actually, the efficiency improvement only in the aspects of copying and obtaining data is really realized. The change of the form of the report made by office software is obvious, but the mode is still mainly the operation of people in front of the computer. Large data integration, information synchronization, conversion, collation or manual operation. With the demand of the times on mass data, the problem of manual errors is more prominent, manual errors are often introduced in data conversion among systems, version control is difficult, mutual cooperation is difficult, reaction time is slow, a large amount of manpower is wasted, work often calls for office automation and needs more manpower to participate, input cost is high, and work efficiency is low. The so-called automation of the common microsoft OFFICE automation software is mainly embodied in the optimization of a human-computer interface. For further automation of operations of cross-software replacement of people for searching, copying, pasting and the like, services in various fields are different and cannot be provided uniformly.
Conventional automatic report generation systems require not only specialized software development, but also business segments to change existing business models and habits, to learn about the use of software, or to convert existing data, to input the existing data into the system, and then generate reports. Thus, the influence on the existing service is large, and the introduction of the system brings extra workload. In addition, the service is always changed continuously, and the special software needs to be changed continuously to adapt to the change of the service. For medium and large group companies, a large amount of data of the same type need to be analyzed every year, for example, the implementation degree and implementation effect of the same project on different subsidiaries need to be analyzed in multiple dimensions. Group companies usually need to extract various statistical data of provinces from reports, and generate Office announcement documents to issue the provinces through manual further arrangement so as to facilitate centralized management. Specifically, the automation of large project operation analysis is usually to load the generated Office notification document into the alert mail or alert short message in the form of an attachment, so the Office notification document is required to be made, and the existing commonly used making method is as follows: exporting data in reports of all molecular companies to an Excel template document, manually making a graph in the Excel according to the exported data, manually compiling a PPT report, and simultaneously inserting the graph and the textual summary made in the Excel to generate the PPT report. However, these data can be obtained only by performing data collection, data cleaning, and calculation according to the situation of the group branch structure hierarchy, and the applicability is not high, and finally, a large amount of manpower and material resources are required to be invested to implement the data.
Disclosure of Invention
Aiming at the problems in the prior art, the invention provides an automatic generation method of the PPT data report, which does not need a table file, but directly adopts the icon to be associated with the PPT, and provides a feasible theoretical and practical technical guarantee for the automatic generation of the data report.
In order to solve the problems, the technical scheme provided by the invention is as follows:
the method comprises the steps of (1) obtaining a target original data record of a use scene, wherein the target original data record comprises an information field and a file resource field, the information field is structured description of a data source, and the file resource field is position information of a file resource;
designing a data report template, and defining the data report template into a universal PPT template pattern, wherein the universal PPT template pattern comprises a region corresponding to the information field and a region corresponding to the file resource field;
step (3) carrying out data marking in the universal PPT template pattern, wherein the data marking is used for establishing the relation between the universal PPT template pattern and the data to be displayed;
setting parameters of a universal PPT template pattern;
and (5) reading the data report template, identifying the data marks of the data report template, automatically searching in a database, and then filling in the appointed position.
Optionally, the data source in step (1) is a non-table file.
Optionally, the structuring of the data source in step (1) is described as transferring the fragmented data source into a multidimensional data table by using an optimization algorithm;
wherein the optimization algorithm is as follows:
wherein
Where Mi is the data item corresponding to the fragmented data source,
wherein k is 1,2,3 … … N, N is the number of data source fragmentations;
the identification method of the fragmented data source comprises the following steps:
(1.1) background identification of fragmented data sources: and (3) adopting an optimal threshold segmentation algorithm to identify data, wherein the optimal threshold segmentation algorithm comprises the following steps:
(1,2) solidified identification of fragmented data sources: and (3) carrying out accurate identification on data by adopting a Matheron algorithm as follows:
wherein KCWeighted average of the data, where K (i, j) is the background base number of the information field.
Optionally, in the above automatic generation method for a PPT data report, the data tag optimization algorithm in step (2) is a calculation algorithm based on a mixture of a BML tag algorithm and an HTML tag algorithm, and specifically the following steps are performed:
wherein
The data mark adopts an automatic expansion method of feature selection, and a neighbor sample data mark is constructed; the function formula adopted is as follows:
wherein the classification interval adopts
Marking is carried out;
wherein the loss amount is dissim (i) ═ xi′，yi′)|s(i，i′)＜sminThe definition is carried out, and the definition is carried out,
wherein s isminRepresenting the similarity of adjacent sample data;
the data to be displayed is an extensible markup language file based on a file transfer protocol directory;
also comprises an establishing analysis module, an obtaining module and a checking module,
wherein the analysis module analyzes the extensible markup language files with different structures into a file format matched with the selected and read file under the file transmission protocol directory,
the acquisition module is used for acquiring quantitative data of extensible markup language files with different structures after the table structures are created;
the verification module is used for verifying the accuracy of the extensible markup language files with different structures after the table structures are created according to the obtained quantitative data to obtain verification results.
Optionally, in the above method for automatically generating a PPT data report, the algorithm for automatically searching in step (3) is as follows:
s.t.yi[ω·Φ(x1)+b≥1-ξi]，1≤i≤N，ξi≥0，
wherein y isi∈{-1，1}，i＝1，2，…，N，
Where the relaxation variable ξ and the transformation from the input space Rn into the Hilbert space Hil are introduced.
Optionally, in the above automatic generation method of the PPT data report, the optimization processing in step (4) is to adjust the size, position, and arrangement of the icons.
Optionally, the automatic search in step (4) is performed according to parameter data in a specific relevant customer questionnaire.
Optionally, step (5) may read a plurality of template files in parallel.
Optionally, the method further includes performing an optimization process in step (6).
Optionally, the step of optimizing processing in step (6) is to automatically change icon display according to the set format requirement.
Optionally, the optimization processing in step (6) is to adjust the size, position and arrangement of the icons.
Compared with the prior art, the invention has the beneficial effects that:
according to the automatic generation method provided by the invention, internal data marking can be carried out according to a designed data report template by acquiring target original data, wherein the target original data record comprises an information field and a file resource field, the relation between the general PPT template pattern and the data to be displayed is established, the parameterized data report template is read to complete filling and optimization processing of the data, finally, the analysis result is read through a computer program, the data reports are automatically generated, manpower is released, the steps of manually participating in statistics in the middle are eliminated, and automatic analysis is focused. Furthermore, the present invention differs from the prior art disclosed mainly in that no form file is required, but icons are directly used in association with PPTs.
Drawings
FIG. 1 is a flow chart of a method for automatic generation of PPT data reports in accordance with the present invention;
FIG. 2 is a diagram of a generic PPT template style with markup language according to the present invention;
FIG. 3 is a schematic diagram of a template file according to the present invention;
FIG. 4 is a schematic diagram of an example of the practice of the present invention;
FIG. 5 is a schematic diagram of the submission of analysis tasks in accordance with the present invention;
FIG. 6 is a schematic diagram of a column type in the present invention;
FIG. 7 is another schematic diagram of the column type of the present invention;
FIG. 8 is a schematic representation of the table types in the present invention;
FIG. 9 is another illustration of table types in the present invention;
FIG. 10 is a schematic diagram of uploading a marking template in the present invention;
FIG. 11 is a schematic diagram of reporting output content parameter customization in accordance with the present invention;
FIG. 12 is a schematic diagram of a submit report task in accordance with the present invention;
FIG. 13 is a schematic diagram of a journal reminder in accordance with the present invention;
FIG. 14 is a schematic illustration of reporting support in the present invention;
FIG. 15 is another illustration of reporting support in the present invention.
Detailed Description
The invention is further described with reference to specific embodiments and the accompanying drawings.
At present, for medium and large group companies, for example, to perform satisfaction investigation on developers, data collection of client owners is firstly performed, on-line questionnaires (including product quality, service experience, property, and the like) need to perform multidimensional analysis on different levels, projects, and the like, forty companies need to prepare a PPT template, but there are differences between the analysis dimensions and repetition.
There are also some prior art techniques for automatically generating PPT documents from Excel charts. Parameters of Excel are required to be defined in advance, basic styles and graphs of PPT are required to be determined, and one-to-one mapping relation between data configured in the report and parameter names in the PPT template is required, so that when a user fills data in the Excel, the data, which are required to be updated and quoted by the graphs in the PPT template, are led out from the acquired report to the Excel template copy, and the data quoted by the graphs in the PPT template are replaced.
As will be understood from the introduction of the background art, in this case, form templates are manually made for questionnaires with different dimensions to correspond to different requirements of PPT analysis. For example, different developers have different questionnaires and different question numbers; each report corresponds to a different time period, monthly report, quarterly report, annual report; the developer's data is stored in different places. Therefore, the existing PPT report making method has the problems of complexity, time and labor waste and the like. With the continuous increase of the number of reports and the diversity of data, the complexity and the time consumption of manual arrangement and manufacture of PPT reports are increased in a geometric situation, the efficiency of enterprise operation and maintenance management is reduced, and the management operation and maintenance cost of enterprises is increased.
The application aims to read the analysis results through a computer program and automatically generate the data reports, liberate manpower and concentrate on analysis.
Aiming at the problems in the prior art, the invention provides an automatic generation method of a PPT data report.
As shown in fig. 1, the method for automatically generating a PPT data report of this embodiment includes:
the method comprises the following steps of (1) obtaining a target original data record of a use scene, wherein the target original data record comprises an information field and a file resource field, the information field is structured description of a data source, and the file resource field is position information of a file resource.
Optionally, the data source in step (1) is a non-table file.
In addition, the structuring of the data source in the step (1) is described as transferring the fragmented data source into a multidimensional data table by using an optimization algorithm;
wherein the optimization algorithm is as follows:
wherein
Where Mi is the data item corresponding to the fragmented data source,
wherein k is 1,2,3 … … N, N is the number of data source fragmentations;
the optimization method can effectively realize the noise reduction processing of the data.
Further, the identification method of the fragmented data source is as follows:
(1.1) background identification of fragmented data sources: and (3) adopting an optimal threshold segmentation algorithm to identify data, wherein the optimal threshold segmentation algorithm comprises the following steps:
(1.2) solidified identification of fragmented data sources: and (3) carrying out accurate identification on data by adopting a Matheron algorithm as follows:
wherein KCAn average weighted for the data, where K (i, j) is the background basis number of information fields;
the processing facilitates the separation of the noise in the data source from the data, and improves the recognition rate.
The automatic generation method of the PPT data report further comprises the following steps: step (2) designs a data report template and defines the data report template as a generic PPT template pattern (e.g., a customer questionnaire data statistics PPT, a financial reporting PPT, etc.) that includes regions corresponding to the information fields and regions corresponding to the file resource fields.
It should be noted that a common PPT template style can generate dozens of documents for batch operation, for example, the same type of customer organization structure, such as fifty city companies, share one template, and output fifty documents of one hundred pages at a time, thereby achieving the most efficient reuse.
The automatic generation method of the PPT data report further comprises the following steps: and (3) marking data in the universal PPT template pattern (marking a chart at each position and data required by the chart in the universal PPT template pattern), wherein the data mark is used for establishing the relation between the universal PPT template pattern and the data to be displayed.
It should be noted that the tagging approach is not a direct replacement, but rather involves a process of auto-expansion.
Whether to automatically expand depends on the definition of the tag, which is determined by the defined rules.
For example, the database may record the following:
table 1 item record table
| Service points | Property division | Sanitation | ||
| Building name | ||||
| 1 | ||||
| |
||||
| Building name n |
The marked floor name n as a parameter and variable can be automatically expanded in the longitudinal direction during the reading of the data. Lateral parameters, such as service score, property score, and hygiene score … …, may be marked according to parameters of questionnaires, and automatically expanded in the database during reading the results, such as traffic score and cell matching score … ….
Therefore, compared with the prior art which is disclosed, the method has the main difference that the Excel is not needed, the extensible database is directly adopted for recording, and the custom icon is associated with the PPT, so that the automatic PPT generation is completed.
The automatic generation method of the PPT data report further comprises the following steps: and (3) carrying out data marking in the universal PPT template pattern, wherein the data marking is used for establishing the relation between the universal PPT template pattern and the data to be displayed.
In the above method for automatically generating a PPT data report, the optimization algorithm of data tagging in step (3) is a calculation algorithm based on a mixture of a BML tagging algorithm and an HTML tagging algorithm, and specifically includes the following steps:
wherein
In the automatic generation method of the PPT data report, the data markers adopt an automatic expansion method of feature selection, and a neighbor sample data marker is constructed; the function formula adopted is as follows:
wherein the classification interval adopts
Marking is carried out;
wherein the loss amount is dissim (i) ═ xi′，yi′)|s(i，i′)＜sminThe definition is carried out, and the definition is carried out,
wherein s isminRepresenting the similarity of nearby sample data.
In the above method for automatically generating a PPT data report, the data to be displayed is an xml file based on a file transfer protocol directory;
also comprises an establishing analysis module, an obtaining module and a checking module,
wherein the analysis module analyzes the extensible markup language files with different structures into a file format matched with the selected and read file under the file transmission protocol directory,
the acquisition module is used for acquiring quantitative data of extensible markup language files with different structures after the table structures are created;
the verification module is used for verifying the accuracy of the extensible markup language files with different structures after the table structures are created according to the obtained quantitative data to obtain verification results.
In addition, the above solution can select and read the file under the file transmission protocol directory for placing the xml data file, and can parse the xml data file with different structure to the file format matching the file under the selected and read file transmission protocol directory, and can create the table structure for the xml data file with different structure which is parsed to the file format matching the file under the selected and read file transmission protocol directory, and can obtain the quantitative data of the xml data file with different structure after creating the table structure, and can perform the accuracy check on the xml data file with different structure after creating the table structure according to the obtained quantitative data to obtain the check result, and can import the xml data file with different structure whose check result passes the accuracy check into the same file transmission protocol directory In the file under the conference directory, the extensible markup language data files with different data structures can be placed into the file under the same file transfer protocol directory.
Furthermore, the above scheme can analyze the extensible markup language files with different structures simultaneously or respectively into the same or different file formats matching the selected and read file under the file transmission protocol directory, which is beneficial to placing the extensible markup language data files with different data structures into the file under the same file transmission protocol directory.
In addition, the newly designed markup language considers the following cases:
A. the question numbers of different customer questionnaires are different, and the data storage is different;
B. when outputting the report of xx city company, outputting the items under the company, and filtering the corresponding items according to the marks;
C. the output of data with different attributes is supported, and the analysis requirement is supported;
D. supporting automatic expansion of data corresponding to the corresponding marks, wherein the marks are one line of items, and increasing a plurality of lines according to the number of actual items when data are output;
E. and simultaneously, the output of tables and graphs in the PPT is supported, and the same marks are adopted.
Markup language examples (as shown in table 2 and fig. 2):
TABLE 2 markup language
Other examples are:
sample size for panel a1: d, A1, T;
satisfaction of all areas: d (2) A1: P-45;
satisfaction of the Foshan company: d (3-Foshan company): A1: P-45.
The automatic generation method of the PPT data report further comprises the following steps: and (4) setting parameters of the universal PPT template pattern.
Optionally, the automatic search in step (4) is performed according to parameter data in a specific relevant customer questionnaire.
As shown in fig. 3, parameters of a common PPT template pattern (parameters specifying relevant customer questionnaires, developer parameters, time periods, etc.) are set, the data report template is read, data markers thereof are identified and automatically searched in a database, and then the data report template is filled to a specified position; the algorithm for automatic search in the step (3) is as follows:
s.t.yi[ω·Φ(x1)+b≥1-ξi]，1≤i≤N，ξi≥0，
wherein y isi∈{-1，1}，i＝1，2，…，N，
Wherein a relaxation variable ξ and a transformation from the input space Rn into the Hilbert space Hil are introduced;
meanwhile, it is noted that: the data source searched can be a table or other types of files; automatically searching data according to specified parameters such as relevant client questionnaires, developer parameters, time periods and the like:
the automatic generation method of the PPT data report further comprises the following steps: and (5) reading the data report template, identifying the data marks of the data report template, automatically searching in a database, and then filling in the appointed position.
Optionally, step (5) may read a plurality of template files in parallel. The method is provided with parallel execution operation for reading a plurality of template files so as to support multi-dimensional and multi-index analysis results.
Optionally, the automatic search in step (5) is performed according to parameter data in a specific relevant customer questionnaire.
It is characterized in that the preparation method is characterized in that,
the automatic search algorithm in the step (5) is as follows:
s.t.yi[ω·Φ(x1)+b≥1-ξi]，1≤i≤N，ξi≥0，
wherein y isi∈{-1，1}，i＝1，2，…，N，
Where the relaxation variable ξ and the transformation from the input space Rn into the Hilbert space Hil are introduced.
Meanwhile, the PPT data report is generated as follows:
first, analysis result
And entering a cloud-path system and submitting an analysis task, as shown in figure 5.
It needs to be reminded that the parallel computation of multiple dimensions and multiple indexes is supported, and various analysis results are computed at the same time; personalized requirements such as weighted analysis, sequencing analysis and correlation analysis are supported; and the scoring mode of the user-defined index expression is supported.
Second, report template marking
Type 1 (table) is shown in fig. 6 and 7.
Type 2 (bar graph) is shown in fig. 8 and 9; it should be noted that D (1-6) represents different organizational structure levels, and if there are multiple organizational structure units, the program will automatically expand; support functions of various Sequencing (SORT) Filtering (FILTER), and the like; the tag supports multiple fetch types: p-45 (ratio of 4, 5), P1 (ratio of 1), T (sample size); support a combination of dimensions/indices and attributes; and the output of the chart and table contents in the PPT is supported.
Third, upload the report mark template
As shown in fig. 10, the system enters the cloud system, finds the corresponding questionnaire, and uploads the markup template.
It is reminded that the same questionnaire supports multiple PPT templates.
Fourth, report the output content parameter is self-defined
As shown in fig. 11, various parameters in the personalized configuration PPT are supported, such as: chart color rules, font colors, cell ground colors, etc.; and the user-defined comparison reference segmentation unit is also supported, and the output content format is set.
Fifthly, submitting report task
As shown in fig. 12, the system enters the cloud system, finds a corresponding questionnaire, and submits a report task according to the requirement.
It is reminded that the data report generation according to different levels, the data report running the designated level name and the page running the designated PPT page number are supported.
Sixth, log reminding
As shown in fig. 13, a log is output during data report output to facilitate monitoring, and multiple PPTs are output simultaneously while multiple threads are supported during data report output.
Seventh, report support
As shown in fig. 14 and 15, multiple PPT outputs are supported by one template, and various graphs and table combinations are supported.
And the small sample score is labeled with the background color of the cell, the font color of the cell, the color of the histogram and the small sample score are not displayed, and only the small sample score is represented as the background color of the-and-contrast group labeled cell.
The automatic generation method of the PPT data report further comprises the following steps:
and (6) carrying out optimization treatment.
And after the data are filled, optimizing until the set requirements are met. The optimization process is to adjust the size, position and arrangement of the icons. Specifically, after the data filling is completed, the optimization is performed, and according to the format requirement of the system, the graph display, the table position, the warning color (if the data sampling amount is less than the threshold value, the automatic color configuration, the background color configuration) and the like are automatically changed to achieve the optimized result.
In practical application, after clicking and running, PPT files output in batches can be obtained, and the quantity of the PPT files depends on the quantity of the PPT files in the same batch.
It should be noted that the automatic generation method according to the present invention may relate to a corresponding system (software), and if the system is implemented in the form of a software functional unit and sold or used as a stand-alone product, the system may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention may be substantially or partially implemented in the form of a software product stored in a storage medium and including instructions for causing a computer device (which may be a personal computer, a server, a network device, or the like) or a processor (processor) to execute all or part of the steps of the method according to the embodiments of the present invention.
It will be apparent to those skilled in the art that, for convenience and brevity of description, only the above-mentioned division of the functional units and modules is illustrated, and in practical applications, the above-mentioned function distribution may be performed by different functional units and modules according to needs, that is, the internal structure of the apparatus is divided into different functional units or modules to perform all or part of the above-mentioned functions.
Any reference to memory, storage, database, or other medium used in embodiments provided herein may include non-volatile and/or volatile memory. Non-volatile memory can include read-only memory (ROM), Programmable R OM (PROM), Electrically Programmable ROM (EPROM), Electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), Dynamic RAM (DRAM), synchronous DRAM (S DRAM), Double Data Rate SDRAM (DDRSDRAM), Enhanced SDRAM (ESDRAM), synchronous link (S ynchlink) DRAM (SLDRAM), Rambus Direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM).
The present invention and its embodiments have been described above schematically, without limitation, and what is shown in the drawings is only one of the embodiments of the present invention, and the actual structure is not limited thereto. Therefore, if the person skilled in the art receives the teaching, without departing from the spirit of the invention, the person skilled in the art shall not inventively design the similar structural modes and embodiments to the technical solution, but shall fall within the scope of the invention.
Claims (10)
1. A method for automatically generating PPT data reports, comprising:
the method comprises the steps of (1) obtaining a target original data record of a use scene, wherein the target original data record comprises an information field and a file resource field, the information field is structured description of a data source, and the file resource field is position information of a file resource;
designing a data report template, and defining the data report template into a universal PPT template pattern, wherein the universal PPT template pattern comprises a region corresponding to the information field and a region corresponding to the file resource field;
step (3) carrying out data marking in the universal PPT template pattern, wherein the data marking is used for establishing the relation between the universal PPT template pattern and the data to be displayed;
setting parameters of a universal PPT template pattern;
and (5) reading the data report template, identifying the data marks of the data report template, automatically searching in a database, and then filling in the appointed position.
2. The method of automatically generating PPT data reports of claim 1,
and (2) the data source in the step (1) is a non-table file.
3. The method of automatically generating PPT data reports of claim 1,
the structuring of the data source in the step (1) is described as transferring the fragmented data source into a multidimensional data table by utilizing an optimization algorithm;
wherein the optimization algorithm is as follows:
wherein
Where Mi is the data item corresponding to the fragmented data source,
wherein k is 1,2,3 … … N, N is the number of data source fragmentations;
the identification method of the fragmented data source comprises the following steps:
(1.1) background identification of fragmented data sources: and (3) adopting an optimal threshold segmentation algorithm to identify data, wherein the optimal threshold segmentation algorithm comprises the following steps:
(1.2) solidified identification of fragmented data sources: and (3) carrying out accurate identification on data by adopting a Matheron algorithm as follows:
wherein KCWeighted average of data, where K (i, j) is informationThe background base number of fields.
4. The method of automatically generating PPT data reports of claim 1,
the optimization algorithm of the data marking in the step (3) is a calculation algorithm based on the mixture of a BML marking algorithm and an HTML marking algorithm, and specifically comprises the following steps:
wherein
The data mark adopts an automatic expansion method of feature selection, and a neighbor sample data mark is constructed;
the function formula adopted is as follows:
wherein the classification interval adopts
Marking is carried out;
wherein the loss amount is dissim (i) ═ xi′，yi′)|s(i，i′)＜sminThe definition is carried out, and the definition is carried out,
wherein s isminRepresenting the similarity of adjacent sample data;
the data to be displayed is an extensible markup language file based on a file transfer protocol directory;
also comprises an establishing analysis module, an obtaining module and a checking module,
wherein the analysis module analyzes the extensible markup language files with different structures into a file format matched with the selected and read file under the file transmission protocol directory,
the acquisition module is used for acquiring quantitative data of extensible markup language files with different structures after the table structures are created;
the verification module is used for verifying the accuracy of the extensible markup language files with different structures after the table structures are created according to the obtained quantitative data to obtain verification results.
5. The method of automatically generating PPT data reports of claim 1,
the automatic search algorithm in the step (5) is as follows:
wherein y isi∈{-1，1}，i＝1，2，…，N，
Where the relaxation variable ξ and the transformation from the input space Rn into the Hilbert space Hil are introduced.
6. The method of automatically generating PPT data reports of claim 1,
and (5) reading a plurality of template files in parallel.
7. The method of automatically generating PPT data reports of claim 1,
and (5) automatically searching according to the parameter data in the appointed relevant customer questionnaire.
8. The method of automatically generating PPT data reports as recited in claim 1, further comprising:
and (6) carrying out optimization treatment.
9. The method of automatically generating PPT data reports of claim 8,
and (5) the step of optimizing processing in the step (6) is to automatically change icon display according to the set format requirement.
10. The method of automatically generating PPT data reports of claim 8,
and (4) optimizing in the step (6) to adjust the size, the position and the arrangement of the icons.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011142971.1A CN112883692B (en) | 2020-10-23 | 2020-10-23 | Automatic generation method of PPT data report |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011142971.1A CN112883692B (en) | 2020-10-23 | 2020-10-23 | Automatic generation method of PPT data report |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112883692A true CN112883692A (en) | 2021-06-01 |
| CN112883692B CN112883692B (en) | 2024-04-09 |
Family
ID=76042949
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011142971.1A Active CN112883692B (en) | 2020-10-23 | 2020-10-23 | Automatic generation method of PPT data report |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112883692B (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113553450A (en) * | 2021-08-03 | 2021-10-26 | 广东新学未科技有限公司 | Automatic PPT presentation generation method and device, computing equipment and storage medium |
| CN113850059A (en) * | 2021-12-01 | 2021-12-28 | 北京一起教育科技有限责任公司 | Method and device for generating evaluation report and electronic equipment |
| CN116701347A (en) * | 2023-05-08 | 2023-09-05 | 北京三维天地科技股份有限公司 | Data modeling method and system based on category expansion |
| CN117056539A (en) * | 2023-10-13 | 2023-11-14 | 一网互通(北京)科技有限公司 | Method and device for generating pptx format file in real time and electronic equipment |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101751461A (en) * | 2009-12-30 | 2010-06-23 | 中兴通讯股份有限公司 | Document conversion method and device |
| US7840600B1 (en) * | 2006-12-29 | 2010-11-23 | Izenda, LLC | Systems and methods for interactively creating, customizing, and executing reports over the internet |
| CN107491426A (en) * | 2016-10-25 | 2017-12-19 | 宝沃汽车（中国）有限公司 | The automatic generation method and system of PPT reports |
| CN107783949A (en) * | 2016-08-24 | 2018-03-09 | 北京神州泰岳软件股份有限公司 | A kind for the treatment of method and apparatus of PPT documents |
| CN110737636A (en) * | 2019-09-24 | 2020-01-31 | 厦门信息集团大数据运营有限公司 | data importing method, device and equipment |
| CN111476012A (en) * | 2019-01-24 | 2020-07-31 | 上海邦维文化传播有限公司 | Intelligent PPT analysis report generation method in image-text release |
| US20200293528A1 (en) * | 2019-03-11 | 2020-09-17 | Examination Management Services, Inc. | Systems and methods for automatically generating structured output documents based on structural rules |
-
2020
- 2020-10-23 CN CN202011142971.1A patent/CN112883692B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7840600B1 (en) * | 2006-12-29 | 2010-11-23 | Izenda, LLC | Systems and methods for interactively creating, customizing, and executing reports over the internet |
| CN101751461A (en) * | 2009-12-30 | 2010-06-23 | 中兴通讯股份有限公司 | Document conversion method and device |
| CN107783949A (en) * | 2016-08-24 | 2018-03-09 | 北京神州泰岳软件股份有限公司 | A kind for the treatment of method and apparatus of PPT documents |
| CN107491426A (en) * | 2016-10-25 | 2017-12-19 | 宝沃汽车（中国）有限公司 | The automatic generation method and system of PPT reports |
| CN111476012A (en) * | 2019-01-24 | 2020-07-31 | 上海邦维文化传播有限公司 | Intelligent PPT analysis report generation method in image-text release |
| US20200293528A1 (en) * | 2019-03-11 | 2020-09-17 | Examination Management Services, Inc. | Systems and methods for automatically generating structured output documents based on structural rules |
| CN110737636A (en) * | 2019-09-24 | 2020-01-31 | 厦门信息集团大数据运营有限公司 | data importing method, device and equipment |
Non-Patent Citations (1)
| Title |
|---|
| 拜晓蒙等: "一种VC驱动Office组件的报告自动生成方法", 科技风, no. 2019, 20 May 2019 (2019-05-20) * |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113553450A (en) * | 2021-08-03 | 2021-10-26 | 广东新学未科技有限公司 | Automatic PPT presentation generation method and device, computing equipment and storage medium |
| CN113553450B (en) * | 2021-08-03 | 2024-01-30 | 广东新学未科技有限公司 | Automatic generation method and device of PPT presentation, computing equipment and storage medium |
| CN113850059A (en) * | 2021-12-01 | 2021-12-28 | 北京一起教育科技有限责任公司 | Method and device for generating evaluation report and electronic equipment |
| CN113850059B (en) * | 2021-12-01 | 2022-03-22 | 北京一起教育科技有限责任公司 | Method and device for generating evaluation report and electronic equipment |
| CN116701347A (en) * | 2023-05-08 | 2023-09-05 | 北京三维天地科技股份有限公司 | Data modeling method and system based on category expansion |
| CN116701347B (en) * | 2023-05-08 | 2023-12-05 | 北京三维天地科技股份有限公司 | Data modeling method and system based on category expansion |
| CN117056539A (en) * | 2023-10-13 | 2023-11-14 | 一网互通(北京)科技有限公司 | Method and device for generating pptx format file in real time and electronic equipment |
| CN117056539B (en) * | 2023-10-13 | 2024-01-02 | 一网互通(北京)科技有限公司 | Method and device for generating pptx format file in real time and electronic equipment |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112883692B (en) | 2024-04-09 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112883692B (en) | Automatic generation method of PPT data report | |
| CN110825882B (en) | Knowledge graph-based information system management method | |
| US8201085B2 (en) | Method and system for validating references | |
| DE102012221251A1 (en) | Semantic and contextual search of knowledge stores | |
| CN111680029A (en) | Optimization management method based on data standard system label falling | |
| CN115293131B (en) | Data matching method, device, equipment and storage medium | |
| CN116522891B (en) | Intelligent generation method and system for long engineering design report | |
| US20060004701A1 (en) | System and method for adaptive decision making analysis and assessment | |
| CN116757808A (en) | Automatic bidding document generation method and system based on big data | |
| Skačkauskienė | Research on management theory: A development review and bibliometric analysis | |
| CN116303641B (en) | Laboratory report management method supporting multi-data source visual configuration | |
| CN116010439A (en) | Visual Chinese SQL system and query construction method | |
| CN116595191A (en) | Construction method and device of interactive low-code knowledge graph | |
| Vardigan et al. | Creating Rich, Structured metadata: lessons learned in the metadata portal project | |
| CN112966486A (en) | Intelligent engineering quantity list generation method and device, terminal and storage medium | |
| CN114118098A (en) | Contract review method, equipment and storage medium based on element extraction | |
| Oswari et al. | Extensible business report language (XBRL) implementation of financial reporting standard in Indonesian banking industry | |
| CN107609155B (en) | Construction method of data asset model based on XBRL standard | |
| EP1239375B1 (en) | Document conversion process | |
| CN117009422B (en) | Method for realizing data import by convenience business personnel | |
| CN113111920B (en) | Project data management system based on PLM and application method | |
| CN114817171B (en) | Buried point data quality control method | |
| CN117407519A (en) | Brief report generation method and device | |
| Romero | Automated BCF Data Extraction For BIM QC Communication | |
| Minggao et al. | Research on the Application of LLM in Power Finance Middle Platform |
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 | ||
| GR01 | Patent grant |