CN112883692B - Automatic generation method of PPT data report - Google Patents
Automatic generation method of PPT data report Download PDFInfo
- Publication number
- CN112883692B CN112883692B CN202011142971.1A CN202011142971A CN112883692B CN 112883692 B CN112883692 B CN 112883692B CN 202011142971 A CN202011142971 A CN 202011142971A CN 112883692 B CN112883692 B CN 112883692B
- Authority
- CN
- China
- Prior art keywords
- data
- file
- ppt
- template
- report
- 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
- 238000000034 method Methods 0.000 title claims abstract description 62
- 238000004422 calculation algorithm Methods 0.000 claims description 29
- 238000004458 analytical method Methods 0.000 claims description 18
- 238000005457 optimization Methods 0.000 claims description 18
- 238000012546 transfer Methods 0.000 claims description 15
- 238000012795 verification Methods 0.000 claims description 10
- 230000008569 process Effects 0.000 claims description 7
- 230000006870 function Effects 0.000 claims description 5
- 230000009466 transformation Effects 0.000 claims description 4
- 230000005540 biological transmission Effects 0.000 claims description 3
- 238000013467 fragmentation Methods 0.000 claims description 3
- 238000006062 fragmentation reaction Methods 0.000 claims description 3
- 239000000203 mixture Substances 0.000 claims description 3
- 230000011218 segmentation Effects 0.000 claims description 3
- 238000007711 solidification Methods 0.000 claims description 3
- 230000008023 solidification Effects 0.000 claims description 3
- 230000001131 transforming effect Effects 0.000 claims description 3
- 101710129069 Serine/threonine-protein phosphatase 5 Proteins 0.000 description 61
- 101710199542 Serine/threonine-protein phosphatase T Proteins 0.000 description 61
- 229920000470 poly(p-phenylene terephthalate) polymer Polymers 0.000 description 61
- 238000010586 diagram Methods 0.000 description 9
- 230000008859 change Effects 0.000 description 4
- 238000004364 calculation method Methods 0.000 description 3
- 238000004519 manufacturing process Methods 0.000 description 3
- 238000012545 processing Methods 0.000 description 3
- 238000003860 storage Methods 0.000 description 3
- 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
- 238000005516 engineering process Methods 0.000 description 2
- 238000001914 filtration Methods 0.000 description 2
- 238000002372 labelling Methods 0.000 description 2
- 238000012423 maintenance Methods 0.000 description 2
- 238000007726 management method Methods 0.000 description 2
- 230000001360 synchronised effect Effects 0.000 description 2
- 244000179970 Monarda didyma Species 0.000 description 1
- 235000010672 Monarda didyma Nutrition 0.000 description 1
- 241000590419 Polygonia interrogationis Species 0.000 description 1
- 238000010420 art technique Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000008901 benefit Effects 0.000 description 1
- 238000004140 cleaning Methods 0.000 description 1
- 238000010219 correlation analysis Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000013461 design 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
- 230000010354 integration Effects 0.000 description 1
- 238000011835 investigation Methods 0.000 description 1
- 238000013507 mapping Methods 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
- 230000035484 reaction time Effects 0.000 description 1
- 230000009467 reduction Effects 0.000 description 1
- 238000005070 sampling Methods 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 239000002699 waste material Substances 0.000 description 1
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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses an automatic generation method of a PPT data report, and belongs to the technical field of automation 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 as a universal PPT template style, wherein the universal PPT template style comprises a region corresponding to the information field and a region corresponding to the file resource field; step (3) data marking is carried out in the universal PPT template pattern, and the data marking is used for establishing a connection between the universal PPT template pattern and data to be displayed; setting parameters of a general PPT template pattern; and (5) reading the data report template, identifying the data mark of the data report template, automatically searching in a database, and then filling the data report template into a designated position.
Description
Technical Field
The invention belongs to the technical field of automation office, and particularly relates to an automatic generation method of a PPT data report.
Background
Office automation and paperless technology have been proposed for many years, and actually, the technology plays a role in improving efficiency in aspects of copying, obtaining and the like of data. The office software produces the change of the form of report obviously, but still in the mode, mainly operate before the computer. The integration, information synchronization, conversion and verification of a large amount of data are performed manually. Along with the demand of the times on mass data, the problem of manual error is also more prominent, the data conversion among all systems often introduces manual error, the version control is difficult, the mutual collaboration is difficult, the reaction time is slow, a large amount of manpower is wasted, the work is often more and more manpower participation is required when the office automation is advocated, the input cost is high, and the work efficiency is low. The so-called automation of the common microsoft OFFICE automation software is also mainly embodied in the optimization of the human-computer interface. For further automation of operations such as searching, copying, pasting and the like by replacing people by cross software, the services in various fields are quite different and cannot be uniformly provided.
Conventional automatic report generating systems not only require specialized software development, but also require business departments to change existing business modes and habits, learn the use of software, or convert existing data, 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 additional workload. In addition, the business is always changing, and special software needs to be changed continuously to adapt to the change of the business. For large and medium-sized group companies, a large amount of data of the same type needs to be analyzed every year, for example, the implementation degree, implementation effect and the like of the same project in different sub-companies need to be analyzed in a multi-dimensional manner. The group company usually needs to extract various statistical data of provinces from the report, and generate Office notification documents to issue the provinces through manual further arrangement so as to be managed in a centralized way. Specifically, in large project operation analysis automation, the generated Office notification document is generally loaded into an alarm mail or an alarm short message in the form of an attachment, so that the Office notification document is required to be manufactured, and one conventional manufacturing method is as follows: the method comprises the steps of firstly exporting data in each molecular company report to an Excel template document, manually making a graph in the Excel according to the exported data, manually writing a PPT report, and simultaneously inserting the graph and literal summary made in the Excel to generate the PPT report. However, the data can be obtained by first performing data collection, data cleaning and calculation according to the condition of the group branch structure level, the applicability is not high, and a large amount of manpower and material resources are finally required to be input for realizing.
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 form file, directly adopts the association of the icon and 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 a structural 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 as a universal PPT template style, wherein the universal PPT template style comprises a region corresponding to the information field and a region corresponding to the file resource field;
step (3) data marking is carried out in the universal PPT template pattern, and the data marking is used for establishing a connection between the universal PPT template pattern and data to be displayed;
setting parameters of a general PPT template pattern;
and (5) reading the data report template, identifying the data mark of the data report template, automatically searching in a database, and then filling the data report template into a designated position.
Optionally, in step (1), the data source is a non-table file.
Optionally, the structuring of the data sources in step (1) is described as transforming the fragmented data sources into a multi-dimensional data table using an optimization algorithm;
wherein the optimization algorithm is as follows:
wherein the method comprises the steps of
Where Mi is the data item corresponding to the fragmented data source,
where k=1, 2,3 … … N, N is the number of fragmentation of the data source;
the identification method of the fragmented data source comprises the following steps:
(1.1) background identification of fragmented data sources: the data is identified by adopting an optimal threshold segmentation algorithm, as follows:
wherein f (i, j) is the number of core keys in the information field, where m is a binarized threshold;
(1, 2) solidification identification of fragmented data sources: the Matheren algorithm is adopted to accurately identify the data, and the method is as follows:
wherein K is C Is a weighted average of the data, where K (i, j) is the background base number of the information field.
Optionally, in the automatic generation method of the PPT data report, the optimization algorithm of the data tag in the step (2) is a calculation algorithm based on a mixture of a BML tag algorithm and an HTML tag algorithm, and specifically includes the following steps:
wherein the method comprises the steps of
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 adoptsMarking;
wherein the loss amount is distim (i) = (x) i′ ，y i′ )|s (i，i′) ＜s min A definition is made of the number of possible dimensions,
wherein s is min Representing 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 and analyzing module, an obtaining module and a checking module,
wherein the analysis module analyzes the extensible markup language files with different structures into file formats matched with the files under the selected and read 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 carrying out accuracy verification on the extensible markup language files with different structures after the table structures are created according to the obtained quantitative data to obtain a verification result.
Optionally, in the method for automatically generating a PPT data report, the algorithm for automatically searching in the step (3) is as follows:
s.t.y i [ω·Φ(x 1 )+b≥1-ξ i ]，1≤i≤N，ξ i ≥0，
wherein y is i ∈{-1，1}，i＝1，2，…，N，
Where a relaxation variable ζ and a transformation from the input space Rn to the Hilbert space Hil are introduced.
Optionally, in the above method for automatically generating a PPT data report, the optimizing process in step (4) is to adjust the size, position and arrangement of the icons.
Optionally, the automatically searching in step (4) is performed according to the parameter data in the specified relevant client questionnaire.
Optionally, step (5) may read a plurality of template files in parallel.
Optionally, the method further comprises the step of (6) performing optimization treatment.
Optionally, the optimizing in the step (6) is to automatically change icon display according to the set format requirement.
Optionally, the optimizing process in the 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, the obtained target original data can be used for carrying out internal data marking according to the designed data report template, establishing the connection between the general PPT template pattern and the data to be displayed, reading the parameterized data report template to complete filling and optimizing processing of the data, finally reading the analysis result through a computer program, automatically generating the data reports, freeing up manpower, eliminating the middle artificial participation statistical step and concentrating on automatic analysis. Furthermore, the main difference of the present invention over the disclosed prior art is that no form file is needed, but rather the icon is directly employed in association with the PPT.
Drawings
FIG. 1 is a flow chart of a method for automatically generating PPT data report in the present invention;
FIG. 2 is a generic PPT template style with markup language in 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 actual operation in the present invention;
FIG. 5 is a schematic diagram of submitting an analysis task in accordance with the present invention;
FIG. 6 is a schematic view of a column type of the present invention;
FIG. 7 is another schematic illustration of a column type of the present invention;
FIG. 8 is a schematic representation of table types in the present invention;
FIG. 9 is another schematic representation of a table type in the present invention;
FIG. 10 is a schematic diagram of an upload tag template according to the present invention;
FIG. 11 is a diagram illustrating report output content parameter customization in accordance with the present invention;
FIG. 12 is a schematic diagram of a report task submitted in the present invention;
FIG. 13 is a diagram of a log alert according to the present invention;
FIG. 14 is a schematic diagram of report support in the present invention;
fig. 15 is another schematic diagram of report support in the present invention.
Detailed Description
The invention is further described below in connection with specific embodiments and the accompanying drawings.
Currently, for large and medium-sized group companies, for example, satisfaction investigation is performed for developers, data collection of client owners is performed first, online questionnaires (such as product quality, service experience, property and the like) need to be analyzed in multiple dimensions for different levels, projects and the like, forty companies need to prepare a PPT template, but the analysis dimensions are different repeatedly.
There are also some prior art techniques for automatically generating PPT documents from Excel charts. The parameters of Excel, the basic patterns and the graphics of the PPT are required to be defined in advance, and the one-to-one mapping relation between the data configured in the report and the parameter names in the PPT template is determined, so that when a user fills the data in the Excel, the data required to update and reference the graphics in the PPT template are exported from the acquired report to the copy of the Excel template, and the data referenced by the graphics in the PPT template are replaced.
As can be seen from the background, in this case, form templates need to be artificially created for different dimension questionnaires to correspond to different PPT analysis requirements. For example, different developers have different questionnaires and different question marks; each report corresponds to a different time period, a monthly report, a quarterly report, and a yearly report; the developer's data is stored in different places. Therefore, the existing PPT report manufacturing method has the problems of complexity, time and labor waste and the like. Along with the continuous increase of the number of reports and the diversity of data, the complexity and time consumption of the manual arrangement and the manufacture of the PPT report are increased in geometric situation, so that the efficiency of enterprise operation and maintenance management is reduced, and the management operation and maintenance cost of the enterprise is increased.
The application aims at reading analysis results through a computer program and automatically generating data reports, thereby freeing up manpower and concentrating on analysis.
Aiming at a plurality of problems existing in the prior art, the invention provides an automatic generation method of a PPT data report.
As shown in fig. 1, the automatic generation method of the PPT data report of the present embodiment includes:
step (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 a structural description of a data source, and the file resource field is position information of a file resource.
Optionally, in step (1), the data source is a non-table file.
Furthermore, the structuring of the data sources in step (1) is described as transforming the fragmented data sources into a multi-dimensional data table using an optimization algorithm;
wherein the optimization algorithm is as follows:
wherein the method comprises the steps of
Where Mi is the data item corresponding to the fragmented data source,
where k=1, 2,3 … … N, N is the number of fragmentation of the data source;
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: the data is identified by adopting an optimal threshold segmentation algorithm, as follows:
wherein f (i, j) is the number of core keys in the information field, where m is a binarized threshold;
(1.2) solidification identification of fragmented data sources: the Matheren algorithm is adopted to accurately identify the data, and the method is as follows:
wherein K is C An average value weighted by data, wherein K (i, j) is the background base number of the information field;
the processing is convenient for separating noise from data in the data source, and improves the recognition rate.
The automatic generation method of the PPT data report further comprises the following steps: step (2) designing a data reporting template and defining the data reporting template as a generic PPT template style (e.g., customer questionnaire data statistics PPT, financial reporting PPT, etc.) that includes an area corresponding to the information field and an area corresponding to the file resource field.
It should be noted that a general PPT template style may generate several tens of files for batch operations, for example, the same type of client organization structure, such as fifty city companies, shares a template, outputs fifty files one hundred pages at a time, and achieves the most efficient reuse.
The automatic generation method of the PPT data report further comprises the following steps: and (3) carrying out data marking (marking the chart of each position and the data required by the chart in the universal PPT template pattern) in the universal PPT template pattern, wherein the data marking is used for establishing the connection between the universal PPT template pattern and the data to be displayed.
It should be noted that the marking is not a direct replacement, but includes an automatic expansion process.
Whether or not to automatically expand depends on the definition of the tag, which is determined by the rules of the definition.
For example, the database may record as follows:
table 1 item record table
| Service division | Property division | Sanitary divider | ||
| Building name 1 | ||||
| Building name 2 | ||||
| Name of building n |
The marked floor name n can be automatically expanded in the longitudinal direction during the reading of the data as a parameter and variable. Lateral parameters, such as service score, property score, hygiene score … …, may define a tag according to the parameters of the questionnaire, and automatically expand in the database during reading of the results, such as traffic score, cell match score … ….
Therefore, compared with the prior art, one of the main differences of the method is that Excel is not needed, but a scalable database is directly adopted for recording, and the custom icon is associated with the PPT, so that 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 a connection between the universal PPT template pattern and data to be displayed.
In the above automatic generation method of PPT data report, the optimization algorithm of data marking in the step (3) is a calculation algorithm based on a mixture of a BML marking algorithm and an HTML marking algorithm, and specifically includes the following steps:
wherein the method comprises the steps of
In the automatic generation method of the PPT data report, 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 adoptsMarking;
wherein the loss amount adopts distim (i) = { (x) i′ ，y i′ )|s (i，i′) ＜s min A definition is made of the number of possible dimensions,
wherein s is min Representing the similarity of neighboring sample data.
In the automatic generation method of the PPT data report, the data to be displayed is an extensible markup language file based on a file transfer protocol directory;
also comprises an establishing and analyzing module, an obtaining module and a checking module,
wherein the analysis module analyzes the extensible markup language files with different structures into file formats matched with the files under the selected and read 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 carrying out accuracy verification on the extensible markup language files with different structures after the table structures are created according to the obtained quantitative data to obtain a verification result.
In addition, according to the scheme, the file under the file transfer protocol directory for placing the extensible markup language data file can be selected and read, the extensible markup language data file with different structures can be analyzed to be matched with the file format of the file under the file transfer protocol directory selected and read, the table structure can be created for the extensible markup language data file with different structures which is analyzed to be matched with the file format of the file under the file transfer protocol directory selected and read, quantitative data of the extensible markup language data file with different structures after the table structure is created can be obtained, and according to the obtained quantitative data, the accuracy check can be carried out on the extensible markup language data file with different structures after the table structure is created to obtain a check result, and the extensible markup language data file with different structures, the check result of which is checked by the accuracy check, can be imported into the file under the same file transfer protocol directory, so that the extensible markup language data file with different data structures can be placed into the file under the same file transfer protocol.
Furthermore, the above scheme can analyze the extensible markup language files with different structures simultaneously or respectively into the same or different file formats matched with the files under the file transfer protocol directory selected and read, which has the advantage of being convenient for placing the extensible markup language data files with different data structures into the files under the same file transfer protocol directory.
In addition, a brand new design of the markup language considers the following cases:
A. question numbers of questionnaires of different clients are different, and data storage is different;
B. when outputting xx city company report, outputting the belonged project under the company, and filtering the corresponding belonged project according to the mark;
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, marking the data as a row of items, and increasing a plurality of rows according to the number of actual items when outputting the data;
E. while supporting the output of tables and charts in PPT and using the same labels.
Markup language examples (as shown in table 2 and fig. 2):
TABLE 2 markup language
Other examples:
sample size of group A1: d: a1: t is a T;
satisfaction of all areas: d (2): a1: p-45;
satisfaction of bergamot corporation: d (3-Buddha): a1: p-45.
The automatic generation method of the PPT data report further comprises the following steps: and (4) setting parameters of a general PPT template pattern.
Optionally, the automatically searching in step (4) is performed according to the parameter data in the specified relevant client questionnaire.
As shown in fig. 3, parameters of a general PPT template style (parameters of specifying relevant client questionnaires, developer parameters, time period and the like) are set, the data report template is read, the data mark of the data report template is identified, automatic searching is carried out in a database, and then the data report template is filled into a specified position; the algorithm of the automatic searching in the step (3) is as follows:
s.t.y i [ω·Φ(x 1 )+b≥1-ξ i ]，1≤i≤N，ξ i ≥0，
wherein y is i ∈{-1，1}，i＝1，2，…，N，
Wherein a relaxation variable ζ and a transformation from an input space Rn to a Hilbert space Hil are introduced;
meanwhile, it should be noted that: (1) the searched data source can be a table or other types of files; (2) according to specified relevant client questionnaires, developer parameters, time period and other parameters, automatically searching data:
the automatic generation method of the PPT data report further comprises the following steps: and (5) reading the data report template, identifying the data mark of the data report template, automatically searching in a database, and then filling the data report template into a designated position.
Optionally, step (5) may read a plurality of template files in parallel. The method is provided with operations which are executed in parallel and are used for reading a plurality of template files so as to support multi-dimension and multi-index analysis results.
Optionally, the automatically searching in step (5) is performed according to the parameter data in the specified relevant client questionnaire.
It is characterized in that the method comprises the steps of,
the automatic searching algorithm in the step (5) is as follows:
s.t.y i [ω·Φ(x 1 )+b≥1-ξ i ]，1≤i≤N，ξ i ≥0，
wherein y is i ∈{-1，1}，i＝1，2，…，N，
Where a relaxation variable ζ and a transformation from the input space Rn to the Hilbert space Hil are introduced.
Meanwhile, the PPT data report is generated as follows:
1. analysis results
Entering a cloud system, submitting analysis tasks, as shown in fig. 5.
It is to be reminded that the parallel calculation of multiple dimensions and multiple indexes is supported, and various analysis results are calculated at the same time; personalized requirements such as weighting analysis, sorting analysis, correlation analysis and the like are supported; and supporting the calculation and division mode of the custom index expression.
2. Marking of report templates
Type 1 (table) is shown in fig. 6 and 7.
Type 2 (histogram) 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 such as multiple SORT (SORT) filtration (Filter); the tag supports multiple fetch types: p-45 (ratio of 4 to 5), P1 (ratio of 1), T (sample size); support a combination of dimensions/metrics and attributes; the chart and table content output in the PPT are supported.
3. Uploading report mark template
As shown in fig. 10, a cloud system is entered, a corresponding questionnaire is found, and a mark template is uploaded.
It is to be reminded that the same questionnaire supports multiple PPT templates.
4. Report output content parameter customization
As shown in fig. 11, various parameters in the PPT are supported for personalized configuration, such as: chart color rules, font colors, cell ground colors, etc.; the custom contrast reference cut unit is also supported and the output content format is set.
5. Submitting reporting tasks
As shown in fig. 12, a cloud system is entered, a corresponding questionnaire is found, and reporting tasks are submitted according to requirements.
It is to be reminded that the generation of data reports according to different levels is supported, the running of data reports with specified level names is supported, and the running of pages with specified PPT page numbers is supported.
6. Log reminder
As shown in fig. 13, the log is output for monitoring conveniently in the data report output process, and multiple PPTs are output simultaneously in the data report output process.
7. Report support
As shown in fig. 14 and 15, a plurality of PPT outputs of one template are supported, and various forms of graph and table combinations are supported.
The small sample scoring and labeling cell ground color, cell font color, histogram color and small sample displaying no score are only displayed as the contrast group scoring and labeling cell ground color.
The automatic generation method of the PPT data report further comprises the following steps:
and (6) performing optimization treatment.
And after the data is filled, performing optimization treatment 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, optimizing, according to the format requirement of the system, automatically changing the chart 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, so as to achieve the optimized result.
In practical application, after clicking operation, batch output PPT files can be obtained, and the quantity of the PPT files depends on the quantity of the same batch of files.
It should be noted that the automatic generation method according to the present invention may relate to a corresponding system (software) and may be stored in a computer readable storage medium if implemented in the form of a software functional unit and sold or used as a separate product. Based on such understanding, the technical solution of the present invention may be embodied in essence or a part contributing to the prior art or all or part of the technical solution in the form of a software product stored in a storage medium, including several instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) or a processor (processor) to execute all or part of the steps of the methods of 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-described division of the functional units and modules is illustrated, and in practical application, the above-described functional distribution may be performed by different functional units and modules according to needs, i.e. the internal structure of the apparatus is divided into different functional units or modules to perform all or part of the above-described functions.
Any reference to memory, storage, database, or other medium used in embodiments of the invention may include non-volatile and/or volatile memory. The nonvolatile memory can include Read Only Memory (ROM), programmable ROM (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 (SDRAM), double Data Rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous Link DRAM (SLDRAM), memory bus direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM), among others.
The invention and its embodiments have been described above by way of illustration and not limitation, and the invention is illustrated in the accompanying drawings and described in the drawings in which the actual structure is not limited thereto. Therefore, if one of ordinary skill in the art is informed by this disclosure, the structural mode and the embodiments similar to the technical scheme are not creatively designed without departing from the gist of the present invention.
Claims (7)
1. An automatic generation method for associating a data report with a PPT by using an icon, comprising the steps of:
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 a structural 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 as a universal PPT template style, wherein the universal PPT template style comprises a region corresponding to the information field and a region corresponding to the file resource field;
step (3) data marking is carried out in the universal PPT template pattern, wherein the data marking is used for establishing a connection between the universal PPT template pattern and data to be displayed, and the marking mode is not direct replacement, but comprises an automatic expansion process;
setting parameters of a general PPT template pattern;
step (5) reading the data report template, identifying the data mark of the data report template, automatically searching in a database, and then filling the data mark into a designated position;
the data source in the step (1) is a non-table file;
the structuring of the data source in step (1) is described as transforming the fragmented data source into a multi-dimensional data table using an optimization algorithm;
wherein the optimization algorithm is as follows:
wherein the method comprises the steps of
Wherein M is i For the data item corresponding to the fragmented data source,
where k=1, 2,3 … … N, N is the number of fragmentation of the data source;
the identification method of the fragmented data source comprises the following steps:
(1.1) background identification of fragmented data sources: the data is identified by adopting an optimal threshold segmentation algorithm, as follows:
wherein f (i, j) is the number of core keys in the information field, where m is a binarized threshold;
(1.2) solidification identification of fragmented data sources: the Matheren algorithm is adopted to accurately identify the data, and the method is as follows:
wherein K is c An average value weighted by data, wherein K (i, j) is the background base number of the information field;
the optimization algorithm of the data marking in the step (3) is a calculation algorithm based on a mixture of a BML marking algorithm and an HTML marking algorithm, and the optimization algorithm is specifically as follows:
wherein the method comprises the steps of
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 adoptsMarking;
wherein the loss amount is distim (i) = (x) i ′，y i 's (i, i') < smin is defined, where smin represents similarity of neighboring sample data;
the data to be displayed is an extensible markup language file based on a file transfer protocol directory; also comprises an establishing and analyzing module, an obtaining module and a checking module,
wherein the analysis module analyzes the extensible markup language files with different structures into file formats matched with the files under the selected and read 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 carrying out accuracy verification on extensible markup language files of different structures after the table structure is created according to the obtained quantitative data to obtain a verification result;
selecting and reading a file under a file transfer protocol directory for placing an extensible markup language data file, analyzing the extensible markup language data file with different structures, analyzing the file into a file format matched with the file under the selected and read file transfer protocol directory, creating a table structure for the extensible markup language data file with different structures analyzed into the file format matched with the file under the selected and read file transfer protocol directory, acquiring quantitative data of the extensible markup language data file with different structures after the table structure is created, and according to the acquired quantitative data, performing accuracy check on the extensible markup language data file with different structures after the table structure is created to obtain a check result, and importing the extensible markup language data file with different structures, of which the check result is checked by the accuracy check, into the file under the same file transfer protocol directory, so that the extensible markup language data file with different data structures can be placed into the file under the same file transfer protocol directory.
2. The method for automatically generating a report using icons and PPT associated data according to claim 1, wherein,
the automatic searching algorithm in the step (5) is as follows:
s.t.y i [ω·Φ(x 1 )+b≥1-ξ i ]，1≤i≤N,ξ i ≥0
wherein y is i ∈{-1，1}，i＝1，2，…，N，
Where a relaxation variable ζ and a transformation from the input space Rn to the Hilbert space Hil are introduced.
3. The method for automatically generating a report using icons and PPT associated data according to claim 1, wherein step (5) is capable of reading a plurality of template files in parallel.
4. The method of claim 1, wherein the step (5) of automatically searching is performed based on parameter data in a specified relevant client questionnaire.
5. The method for automatically generating a report using icons and PPT associated data according to claim 1, further comprising: and (6) performing optimization treatment.
6. The method for automatically generating a report using icon and PPT associated data according to claim 5, wherein said optimizing in step (6) is performed by automatically changing the icon display according to the set format requirement.
7. The method for automatically generating a report using icons and PPT associated data according to claim 6, wherein the optimization in step (6) is to adjust the size, position and arrangement of 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 CN112883692A (en) | 2021-06-01 |
| CN112883692B true 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) |
Families Citing this family (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113505183A (en) * | 2021-07-28 | 2021-10-15 | 中国工商银行股份有限公司 | Data visualization method and device |
| CN113553450B (en) * | 2021-08-03 | 2024-01-30 | 广东新学未科技有限公司 | Automatic generation method and device of PPT presentation, computing equipment and storage medium |
| CN113850059B (en) * | 2021-12-01 | 2022-03-22 | 北京一起教育科技有限责任公司 | Method and device for generating evaluation report and electronic equipment |
| CN116701347B (en) * | 2023-05-08 | 2023-12-05 | 北京三维天地科技股份有限公司 | Data modeling method and system based on category expansion |
| CN117056539B (en) * | 2023-10-13 | 2024-01-02 | 一网互通(北京)科技有限公司 | Method and device for generating pptx format file in real time and electronic equipment |
Citations (6)
| 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 |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 (6)
| 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 |
| CN110737636A (en) * | 2019-09-24 | 2020-01-31 | 厦门信息集团大数据运营有限公司 | data importing method, device and equipment |
Non-Patent Citations (1)
| Title |
|---|
| 一种VC驱动Office组件的报告自动生成方法;拜晓蒙等;科技风;20190520(2019年14期);全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112883692A (en) | 2021-06-01 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112883692B (en) | Automatic generation method of PPT data report | |
| CN111680029A (en) | Optimization management method based on data standard system label falling | |
| CN116433052B (en) | Intelligent bidding information acquisition data analysis and evaluation system | |
| CN111612379A (en) | Audit scheme automatic generation method and device | |
| CN110544023A (en) | Enterprise regional contribution data evaluation system and evaluation method thereof | |
| CN111581193A (en) | Data processing method, device, computer system and storage medium | |
| CN116384889A (en) | Intelligent analysis method for information big data based on natural language processing technology | |
| CN116595191A (en) | Construction method and device of interactive low-code knowledge graph | |
| CN111784385A (en) | Manufacturing industry-oriented client portrait construction method and device and computer storage medium | |
| CN103377403A (en) | Enterprise business module modeling method and enterprise business module modeling system | |
| CN117435489A (en) | Method and system for automatically analyzing software function points based on demand documents | |
| CN116956860A (en) | Financial statement generation method and system based on real-time data tracking | |
| CN116303641B (en) | Laboratory report management method supporting multi-data source visual configuration | |
| CN116227454A (en) | Universal automatic report generation method and system | |
| CN115829809A (en) | Carbon accounting method and device based on configuration, computer equipment and storage medium | |
| CN108228688B (en) | Template generation method, system and server based on XBRL | |
| US20220405235A1 (en) | System and method for reference dataset management | |
| DE102022125815A1 (en) | DATA RECOMMENDATIONS USING DISTRIBUTION TO DISTRIBUTE VALUE INDICATORS | |
| CN114331740A (en) | Industrial map big data analysis and scanning digitalized investment value management method | |
| US8374897B2 (en) | Apparatus and method for forecasting qualitative assessments | |
| EP1239375B1 (en) | Document conversion process | |
| Mustafee et al. | Analysis of M&S Literature Published in the Proceeding of the Winter Simulation Conference from 1981 to 2016 | |
| CN112380814B (en) | Domestic operating system-based automatic information manuscript combination and edition method | |
| CN113111920B (en) | Project data management system based on PLM and application method | |
| Saris et al. | CASIP: a complete automated system for information processing in family budget research |
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 | ||
| GR01 | Patent grant |