This paper introduces the application of Excel in geotechnical investigation index statistics. It will be applied to overcome these shortcomings of professional investigation software used for conducting layered statistics of physical and mechanical properties index of soil or rock. For example, the software operates inconveniently when a certain data does not participate in statistical calculations, besides, statistical results can not be obtained immediately; data will have to be recalculated if statistical results are unsuitable. If we import the layered data that generated by professional investigation software into Excel and adopt the Excel method to conduct layered statistical calculation for various index, the generated Excel template will be used repeatly. After being used actually, it is proved that the calculation process is transparent; results show synchronously and data is accurate, so the excel method could be applied in work.%为了克服在利用专业勘察软件进行岩土物理力学性质指标进行分层统计时,要让有的数据不参加统计计算时操作不便、统计结果不能立即显示,统计结果如不合适又得重头再来一遍的缺点,将专业勘察软件生成的分层数据导入Excel中,采用Excel方法进行各种指标分层统计计算,形成Excel模板后可多次重复使用,经实际使用,计算过程透明、结果同步显示、数据准确,可在工作中应用.
展开▼
