A Method of Data Granulation and Indicators Standardization of Spreadsheet

In this paper, a method of data granulation and indicators standardization is proposed, which is mainly used to solve the problems of two-dimensional spreadsheet data granulation and indicators standardization. By defining the classification and hierarchical of indicators, extracting the implicit relationship, and classifying and layering the indicators for storage, the problems of granulation, standardization and making implicit relationship explicit of two-dimensional spreadsheet data are solved at one time. It provides a feasible storage scheme for multi-source and large-scale data operation.