地质结构面分组的聚类方法及EXCEL实现

Clustering algorithm of geological structural plane in groups and its realization of EXCEL

对地质结构面几何特性统计分析的主要方法进行了比较,提出了一种聚类算法,依托EXCEL及其VBA功能,提出了一个可高效解决结构面统计分析工作的计算模板,并通过地下洞室设计实例做了说明。

Main statistical analytic methods are compared concerning geometric property of geological structural plane, and a clustering algorithm is brought up on the basis of EXCEL and its VBA function. A calculating formwork is advanced to deal with structural plane, with a high efficient analytic method, and design examples of underground cavern are illustrated.