Data group graph notation and apparatus thereof

A graphic representation and data group technology, applied to financial statement data, can solve problems such as difficult for readers to detect performance decline and fooling readers

Inactive Publication Date: 2009-04-15
CHII YING
View PDF0 Cites 17 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The case still follows that most managers nowadays generally use EXCEL or similar drawing tools for graphical representation. However, the graphical representation method made by EXCEL still has the situation that traditional statistical charts fool the viewers.
For example, if Figure 7a The sales performance...

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Data group graph notation and apparatus thereof
  • Data group graph notation and apparatus thereof
  • Data group graph notation and apparatus thereof

Examples

Experimental program
Comparison scheme
Effect test

no. 1 example

[0038] actual value notation

[0039] The first embodiment of the present invention is to take the actual value as the ordinate scale of the graph, and its data processing method please refer to image 3 illustrate. The process starts at ST410, and then, in step ST411, the maximum value and the minimum value are found in the input data items as the upper and lower limits. Then, in step ST412, subtract the maximum value from the minimum value, and then divide the result by the number of data you want to mark to obtain the wheelbase. For example, when the data is displayed on paper or a computer monitor, you can divide Take 10, on the contrary, if it is a display device such as a PDA and a mobile phone, it can be divided by 5 to obtain the appropriate wheelbase. In addition, in step ST413, if the user wants to keep the side width of the graph, the maximum value and the minimum value plus 0 to 1 times the wheelbase can be displayed or printed as data according to the desired si...

no. 2 example

[0052] standardized notation

[0053] For the data processing method of the standardized representation in this embodiment, please refer to Figure 4 illustrate. The flow starts at ST420, and then at step ST421, all the data in the data is read in, and then, at step ST422, the absolute value of each data is taken. Next, in step ST423 , the largest of the absolute values ​​is used as a normalization factor, and each data is divided by the normalization factor one by one, so that normalization is obtained, so all the data will be normalized. Next, in step ST424, a step of obtaining upper and lower limits is performed. Since there must be a +1 or -1 after standardization, if the reader wants to clearly see the trend and change of the data, he can specify +1 as the maximum value (upper limit) and the minimum value as the lower limit, or, Specify -1 as the minimum value (lower limit) and the maximum value as the upper limit. Of course, if the reader wants to see the distribution...

no. 3 example

[0064] Isometric representation

[0065] When two data groups are to be compared on the double vertical axis, because the traditional drawing method does not have a standard, the display scales of the two vertical axes for comparison are often inconsistent and mislead the reader's feelings. In this case , the data processing flow of the proportional representation method of the present invention can show its effect more. For the processing data flow of the proportional representation in this embodiment, please refer to Figure 5 illustrate. The process begins at ST430, and then finds out the maximum and minimum values ​​that do not need to be corrected in the two data groups as the upper and lower limits in ST431, and then performs calculations in ST432 to obtain the upper limit or lower limit of the vertical axis that needs to be corrected, and find the vertical axis on both sides. The wheelbase of the axle (ST433), the extra edge width (ST434), obtain the new upper and low...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention discloses a method for diagrammatizing data, comprising the following steps: data collection; summarization data: an integrated platform for supporting data processing is established according to the definition of the data so as to record basic data and all items of data completely; data selection: summarization data is specifically selected; data processing: the data is processed in order to find out maximum value and minimum value in the data; and diagram display data: drawing display is carried out by taking the maximum value and the minimum value in the data as an upper limit and a lower limit of a graph coordinate axis respectively.

Description

technical field [0001] The present invention relates to methods and apparatus for graphically displaying data, and more particularly, to indicating trends, anomalies, or significant changes in data, particularly financial statement data, such as general ledger data A method and device thereof. Background technique [0002] In the current relational database, data is managed in the form of rows and columns. There are only relationships between fields and elements, or between data cells and data cells, but lack of context and order. Analysis needs The integration of data must rely entirely on the human brain to make judgments. If you want to compare with last year or last month, you have to write SQL (Structured Query Language) to do it, which is not only troublesome, but also often delays the timeliness of decision-making. [0003] Therefore, OLAP (Online Analytical Processing) analysis tools have appeared on the market, which can effectively classify data according to dime...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06F17/30
Inventor 庄昌善庄晧渊
Owner CHII YING
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap