Indicator Index Structure for Spreadsheet Data Classification
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional spreadsheet data presentation formats fail to accurately express indicator classification information, leading to non-standard, unreadable, and incomprehensible indicators, especially when dealing with multiple hierarchical and inclusion relations, which hinders data merging and exploration of implicit relationships.
Innovation Solution
A processing method that constructs an indicator index structure using databases to present indicator hierarchies and classifications, allowing users to select and visualize indicators, classification descriptions, and application scenarios, resulting in a standardized and hierarchical spreadsheet with clearer data presentation.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If indicators are directly combined using XY or YX presentation format, then data can be presented in a two-dimensional spreadsheet, but the indicator classification description information cannot be accurately expressed and the indicator names become nonstandard and long
Solution Approach 1:
The patent segments the indicator information into multiple components: indicator names, indicator classifications, and description information. Each component is stored separately in database tables (indicator table, classification table, description table) and can be independently managed and retrieved, allowing accurate expression of classification information without creating nonstandard long indicator names
Solution Approach 2:
The patent introduces an intermediary indicator index structure that acts as a mediator between the raw data and the final presentation. This index structure contains fields for indicator names, classifications, and descriptions, and serves as a bridge to organize and present the segmented information in a standardized manner
2Adaptability or versatility
If multiple levels of hierarchical relations and inclusion relations between indicators are involved, then comprehensive classification can be achieved, but data becomes hard to express or fails to be expressed
Solution Approach 1:
The patent implements nested doll principle through hierarchical classification levels in the database structure. The classification table contains level indicators (level1, level2, level3) that represent nested hierarchical levels, allowing multi-level classification relationships to be expressed systematically. Each level can contain sub-classifications, creating a nested structure that preserves comprehensive classification information
Solution Approach 2:
The patent adds dimensional structure to the data presentation by introducing hierarchical level dimensions. Instead of flat two-dimensional spreadsheets, the system creates multi-dimensional data structures with rows representing different hierarchical levels and columns representing different classification categories, enabling comprehensive hierarchical relationships to be expressed clearly
3Productivity
If nonstandard indicators are formed by direct combination, then data can be presented in spreadsheet format, but readability and comprehensibility deteriorate and large-scale combination operations are hindered
Solution Approach 1:
The patent changes the parameter structure from nonstandard combined indicator names to standardized parameters with separate fields for indicator names, classifications, and descriptions. This parameter transformation allows the system to maintain standardized, readable indicator names while enabling flexible combination operations through the structured database fields and index structure
Data Source
AI summary
The present disclosure provides a processing method for presenting an indicator hierarchy and classification of data in a spreadsheet. In this method, an indicator index structure S is constructed and a spreadsheet is used to present information based on user selections. The information includes an indicator and a hierarchy of the indicator, an indicator classification description and a hierarchy of the indicator classification description, an application scenario between an indicator and an indicator classification description, and other implicit attributes. This way, indicator descriptions can be neater and more readable. Data in a two-dimensional spreadsheet can be accurately presented and the spreadsheet is more comprehensible. In addition, indicators and indicator classification descriptions can be flexibly combined to present data in a more diversified, flexible, and personalized manner.