Scientific and technological achievement data acquisition and analysis system

Abstract

The invention discloses a scientific and technological achievement data acquisition and analysis system, and belongs to the technical field of data analysis, the system comprises a category input box, a data input box, a screening minimum data input box and a screening maximum data input box, and the screening minimum data input box, the screening maximum data input box, the category input box and the data input box are manual input boxes; only one category input box and one data input box are defaulted, the category input boxes and the data input boxes are automatically added downwards by filling the category input boxes and the data input boxes, the situation that selection and filling are inconvenient due to too many spaces is avoided, meanwhile, additional operation for table adding is also avoided, gaps are adaptively displayed through a bar chart, and the efficiency is improved. And by adopting a bar chart, a single data scale chart and a broken line chart fusion mode, three forms can be watched by one eye, so that repeated comparison due to rummaging is avoided, and the image watching analysis efficiency is improved.

Description

Technical Field

[0001] The present invention belongs to the technical field of data analysis, and in particular relates to a scientific and technological achievement data collection and analysis system. Background Art

[0002] Data analysis refers to the use of appropriate statistical analysis methods to analyze a large amount of collected data, summarize, understand and digest them, in order to maximize the development of data functions and give full play to the role of data. Data analysis is the process of detailed study and summary of data in order to extract useful information and form conclusions. In order to reduce the difficulty of analysis, existing data analysis systems process it into commonly used bar charts, proportion charts or line charts, which are convenient for users to observe the range and proportion of changes.

[0003] Since the existing bar charts, proportional charts and line charts are highly independent, it is difficult to integrate them with each other after they are generated according to conventional mapping standards. They can be displayed simultaneously when the screen is large, but it is necessary to focus on a certain chart. When the screen is small, they need to be flipped back and forth for analysis, which makes it troublesome to use conventional data analysis systems to generate and analyze scientific and technological achievement data.

[0004] To this end, we proposed a scientific and technological achievement data collection and analysis system to solve the above problems. Summary of the invention

[0005] The purpose of the present invention is to solve the problem that it is troublesome to use conventional data analysis systems to generate and analyze scientific and technological achievement data, and to propose a scientific and technological achievement data collection and analysis system.

[0006] In order to achieve the above object, the present invention adopts the following technical solutions:

[0007] The scientific and technological achievement data collection and analysis system includes a category input box, a data input box, a minimum screening data input box and a maximum screening data input box, wherein the minimum screening data input box, the maximum screening data input box, the category input box and the data input box are manual input boxes;

[0008] Automatic expansion column: By default, there is only one category input box and data input box. After the corresponding category input box and data input box are entered, a blank category input box and data input box will be added below;

[0009] Generate analysis chart: after inputting two columns of data into the input box, a bar chart and a single data ratio chart are generated. The bar chart is flush with the corresponding data input box, the single data ratio chart is flush with the corresponding bar chart, and the single data ratio charts are connected to form a line chart;

[0010] Analysis chart display: Compare the data in the first column of data input box with the data in the other data input boxes in turn and select the maximum value, and then do the same in the second column of data input box to select the maximum value; leave a space of three times the diameter of the single data ratio chart on the side of the data input box facing away from the category input box as the maximum value bar display range, and divide the remaining values ​​by the maximum value to obtain their display lengths, and paste the single data ratio chart on the end of the bar chart facing away from the data input box;

[0011] Filter data: When there is a value in the minimum data input box and the maximum data input box is empty, the default is to filter and display the data input boxes above it and the corresponding category input boxes and charts. When there is a value in the maximum data input box and the minimum data input box is empty, the default is to display the data input boxes below it and the corresponding category input boxes and charts. When there are values ​​in both the minimum data input box and the maximum data input box, the data input boxes and the corresponding category input boxes and charts between them are displayed. By filling in the category input box and the data input box, the category input box and data input box are automatically added downward to avoid too many spaces that are inconvenient to select and fill in, and also avoid additional operations to add tables. The bar chart is used to adaptively display the gaps to maximize the use of free space. The bar chart, single data ratio chart and line chart are fused to enable you to see all three tables at a glance, avoiding searching and comparing back and forth, and improving the efficiency of chart analysis.

[0012] Preferably, a minimum value attribute selection button is provided on the side of the minimum filter data input box facing away from the maximum filter data input box. When the minimum value attribute selection button is pressed, the filter range includes the value filled in the minimum filter data input box. When the minimum value attribute selection button is left blank, the filter range does not include the value filled in the minimum filter data input box. By clicking the minimum value attribute selection button, the user can quickly select whether the minimum filter data input box is included or not included, which is convenient for the user to set the minimum value.

[0013] Preferably, a maximum selection button is provided on one side of the maximum data input box facing the minimum data input box. When the maximum selection button is selected, the filter interval includes the value in the maximum data input box. When the maximum selection button is left blank, the filter value does not include the value in the maximum data input box. By clicking the maximum selection button, the maximum value inclusion relationship of the filter interval can be set quickly and conveniently.

[0014] Preferably, a filter switch is provided on the upper side of the minimum data filter input box and the maximum data filter input box. After the filter switch is turned on, the minimum data filter input box and the maximum data filter input box filter range are applied, and after the filter switch is turned off, the minimum data filter input box and the maximum data filter input box filter range are turned off. By clicking to quickly close or open the minimum data filter input box and the maximum data filter input box filter function, repeated filling and deletion operations are avoided, thereby improving the convenience of filtering.

[0015] Preferably, a vertical slider is also included. When the arrangement height of the category input box and the data input box exceeds the display area, the vertical slider is activated to display the height of the category input box and the data input box as the ratio of the vertical slider button to the total height of the vertical slider. The vertical slider is slid to control the display area of ​​the category input box and the data input box. By dragging the vertical slider, the user can browse the data and icons conveniently.

[0016] Preferably, it also includes a horizontal slider, when the horizontal slider is pulled in the direction of the vertical slider, the logical blank length of the side of the data input box facing away from the category input box is increased, the end of the longest bar graph facing away from the data input box is enlarged and displayed, and the slider of the horizontal slider is reduced to the end facing away from the category input box. By sliding the horizontal slider, the difference between the ends of the bar graph is enlarged, which facilitates the observation of data with small change differences.

[0017] In summary, the technical effects and advantages of the present invention are as follows:

[0018] 1. By filling in the category input box and the data input box, the category input box and the data input box are automatically added downwards to avoid too many spaces that are inconvenient to select and fill in. At the same time, it also avoids additional operations to add tables. The bar chart is used to adaptively display the gaps to maximize the use of idle space. The bar chart, single data ratio chart and line chart are combined to see all three tables at a glance, avoiding searching back and forth for comparison, which improves the efficiency of image analysis.

[0019] 2. By clicking the minimum value attribute selection button, you can quickly select the included or not included relationship in the filter minimum data input box, making it convenient for users to set the minimum value.

[0020] 3. Click the Maximum Selection button to quickly and easily set the maximum value inclusion relationship of the filtering interval.

[0021] 4. By clicking quickly, you can close or open the minimum data input box and the maximum data input box filtering function to avoid repeated filling and deletion operations, thus improving the convenience of filtering.

[0022] 5. Enlarge the difference at the end of the bar chart by sliding the horizontal slider, making it easier to observe data with small change differences. BRIEF DESCRIPTION OF THE DRAWINGS

[0023] Figure 1 It is a schematic diagram of the overall structure of the present invention.

[0024] In the figure: 1. Filter switch; 2. Minimum value attribute selection button; 3. Filter minimum data input box; 4. Maximum value selection button; 5. Filter maximum data input box; 6. Category input box; 7. Data input box; 8. Bar chart; 9. Single data ratio chart; 10. Line chart; 11. Horizontal slider; 12. Vertical slider. DETAILED DESCRIPTION

[0025] The technical solutions in the embodiments of the invention will be described clearly and completely below in conjunction with the drawings in the embodiments of the invention. Obviously, the described embodiments are only part of the embodiments of the invention, rather than all of the embodiments.

[0026] Reference Figure 1 , the scientific and technological achievement data collection and analysis system includes a category input box 6, a data input box 7, a minimum data screening input box 3 and a maximum data screening input box 5, the minimum data screening input box 3, the maximum data screening input box 5, the category input box 6 and the data input box 7 are manual input boxes;

[0027] Automatic expansion column: By default, there is only one category input box 6 and data input box 7. After the content is entered in the corresponding category input box 6 and data input box 7, a blank category input box 6 and data input box 7 will be added downwards;

[0028] Generate analysis chart: after inputting two columns of data into input box 7, a bar chart 8 and a single data ratio chart 9 are generated, the bar chart 8 is flush with the corresponding data input box 7, the single data ratio chart 9 is flush with the corresponding bar chart 8, and the single data ratio charts 9 are connected to form a line chart 10;

[0029] Analysis chart display: the data in the first column data input box 7 are compared with the data in the other data input boxes 7 in turn, and the maximum value is selected. Then the data in the second column data input box 7 is carried out in the same way to select the maximum value; a space of three times the diameter of the single data ratio chart 9 is left on the side of the data input box 7 facing away from the category input box 6 as the maximum value bar display range, and the remaining values ​​are divided by the maximum value to obtain their display lengths. The single data ratio chart 9 is attached to the end of the bar chart 8 facing away from the data input box 7;

[0030] Filter data: When there is a value in the minimum data input box 3 and the maximum data input box 5 is empty, the default is to filter and display the data input box 7 and the corresponding category input box 6 and the chart above it. When there is a value in the maximum data input box 5 and the minimum data input box 3 is empty, the default is to display the data input box 7 and the corresponding category input box 6 and the chart below it. When there are values ​​in both the minimum data input box 3 and the maximum data input box 5, the data input box 7 and the corresponding category input box 6 and the chart between them are displayed.

[0031] Reference Figure 1, a minimum value attribute selection button 2 is provided on the side of the minimum filter data input box 3 facing away from the maximum filter data input box 5. When the minimum value attribute selection button 2 is pressed, the filter range includes the value filled in the minimum filter data input box 3. When the minimum value attribute selection button 2 is left blank, the filter range does not include the value filled in the minimum filter data input box 3. By clicking the minimum value attribute selection button 2, you can quickly select whether the minimum filter data input box 3 is included or not included.

[0032] Reference Figure 1 , a maximum selection button 4 is provided on one side of the maximum data input box 5 facing the minimum data input box 3. When the maximum selection button 4 is selected, the filter interval includes the value in the maximum data input box 5. When the maximum selection button 4 is left blank, the filter value does not include the value in the maximum data input box 5. Click the maximum selection button 4 to quickly set the maximum value inclusion relationship of the filter interval.

[0033] Reference Figure 1 , there is a filter switch 1 on the upper side of the filter minimum data input box 3 and the filter maximum data input box 5. After turning on the filter switch 1, the filter range of the filter minimum data input box 3 and the filter maximum data input box 5 is applied. After turning off the filter switch 1, the filter range of the filter minimum data input box 3 and the filter maximum data input box 5 is turned off. Click to quickly turn off or on the filter function of the filter minimum data input box 3 and the filter maximum data input box 5.

[0034] Reference Figure 1 , and also includes a vertical slider 12. When the arrangement height of the category input box 6 and the data input box 7 exceeds the display area, the vertical slider 12 is activated. The height of the category input box 6 and the data input box 7 can be displayed as the ratio of the vertical slider 12 button to the total height of the vertical slider 12. Sliding the vertical slider 12 controls the display area of ​​the category input box 6 and the data input box 7.

[0035] Reference Figure 1 , and further includes a horizontal slider 11. When the horizontal slider 11 is pulled toward the vertical slider 12, the logical blank length of the side of the data input box 7 facing away from the category input box 6 is increased, and the end of the longest bar graph 8 facing away from the data input box 7 is enlarged and displayed, and the slider of the horizontal slider 11 is reduced to be close to the end facing away from the category input box 6. The end difference of the bar graph 8 is enlarged by sliding the horizontal slider 11.

[0036] Working principle: By filling in the category input box 6 and the data input box 7, the category input box 6 and the data input box 7 are automatically added downwards to avoid too many spaces that are inconvenient to select and fill in, and to avoid extra operations to add tables. The bar chart 8 is used to adaptively display the gaps, and the bar chart 8, the single data ratio chart 9 and the line chart 10 are integrated to display three tables at the same time to avoid searching back and forth for comparison.

[0037] The above description is only a preferred specific implementation manner of the invention, but the protection scope of the invention is not limited thereto. Any technician familiar with the technical field can make equivalent substitutions or changes within the technical scope disclosed by the invention according to the technical scheme and inventive concept of the invention, which should be covered by the protection scope of the invention.

[0038] The description briefly mentions the application direction of the invention for the prior art known to those skilled in the art and without making changes, which is combined with the invention to form a complete technology; the description avoids over-popularizing the technology familiar to those skilled in the art to assist them in quickly understanding the main content of the invention.

Claims

1. The scientific and technological achievements data collection and analysis system is characterized by: It includes a category input box (6), a data input box (7), a minimum filter data input box (3) and a maximum filter data input box (5), wherein the minimum filter data input box (3), the maximum filter data input box (5), the category input box (6) and the data input box (7) are manual input boxes; Automatic expansion column: By default, there is only one category input box (6) and data input box (7). After the corresponding category input box (6) and data input box (7) are filled with content, a blank category input box (6) and data input box (7) will be added below; Generate an analysis chart: after inputting data into two columns of data input boxes (7), a bar chart (8) and a single data ratio chart (9) are generated, the bar chart (8) is aligned with the corresponding data input box (7), the single data ratio chart (9) is aligned with the corresponding bar chart (8), and the single data ratio charts (9) are connected to form a line chart (10); Analysis chart display: the data in the first column data input box (7) are compared with the data in the remaining data input boxes (7) in turn, and the maximum value is selected. Then the same is done from the second column data input box (7) to select the maximum value; a space of three times the diameter of the single data ratio chart (9) is left on the side of the data input box (7) facing away from the category input box (6) as the maximum value bar display range, and the remaining values ​​are divided by the maximum value to obtain their display lengths. The single data ratio chart (9) is attached to the end of the bar chart (8) facing away from the data input box (7); Filter data: When there is a value in the Filter Minimum Data input box (3) and the Filter Maximum Data input box (5) is empty, the default is to filter and display the data input boxes (7) above it and the corresponding category input boxes (6) and charts. When there is a value in the Filter Maximum Data input box (5) and the Filter Minimum Data input box (3) is empty, the default is to display the data input boxes (7) below it and the corresponding category input boxes (6) and charts. When there are values ​​in both the Filter Minimum Data input box (3) and the Filter Maximum Data input box (5), the data input boxes (7) between them and the corresponding category input boxes (6) and charts are displayed.

2. The scientific and technological achievement data collection and analysis system according to claim 1, characterized in that: A minimum value attribute selection button (2) is provided on the side of the minimum filtering data input box (3) facing away from the maximum filtering data input box (5); when the minimum value attribute selection button (2) is pressed, the filtering range includes the value filled in the minimum filtering data input box (3); when the minimum value attribute selection button (2) is left blank, the filtering range does not include the value filled in the minimum filtering data input box (3).

3. The scientific and technological achievement data collection and analysis system according to claim 1 is characterized in that: The maximum value selection button (4) is provided on one side of the maximum data input box (5) facing the minimum data input box (3). When the maximum value selection button (4) is selected, the filter range includes the value in the maximum data input box (5). When the maximum value selection button (4) is left blank, the filter value does not include the value in the maximum data input box (5).

4. The scientific and technological achievement data collection and analysis system according to claim 1 is characterized in that: A filter switch (1) is provided on the upper side of the minimum filter data input box (3) and the maximum filter data input box (5); when the filter switch (1) is turned on, the minimum filter data input box (3) and the maximum filter data input box (5) filter range are applied; when the filter switch (1) is turned off, the minimum filter data input box (3) and the maximum filter data input box (5) filter range are closed.

5. The scientific and technological achievement data collection and analysis system according to claim 1 is characterized in that: The invention also comprises a vertical slide bar (12). When the arrangement height of the category input box (6) and the data input box (7) exceeds the display area, the vertical slide bar (12) is activated, and the height of the category input box (6) and the data input box (7) can be displayed as the ratio of the slider of the vertical slide bar (12) to the total height of the vertical slide bar (12). The vertical slide bar (12) is slid to control the display area of ​​the category input box (6) and the data input box (7).

6. The scientific and technological achievement data collection and analysis system according to claim 5 is characterized in that: The invention also comprises a horizontal slide bar (11). When the horizontal slide bar (11) is pulled in the direction of the vertical slide bar (12), the length of the logical blank space on the side of the data input box (7) facing away from the category input box (6) is increased, the end of the longest bar graph (8) facing away from the data input box (7) is enlarged and displayed, and the slider of the horizontal slide bar (11) is reduced to be close to the end facing away from the category input box (6).

Images