土工基础

›› 2011, Vol. 25 ›› Issue (4): 69-72.

• 工程实录 • 上一篇    下一篇

土工试验报告的ExcelVBA统计分析

 刘大海    

  1. （深圳市地质局，广东深圳 518023）
  • 收稿日期:2010-08-16 出版日期:2011-08-20 发布日期:2011-11-23
  • 作者简介:刘大海，男，1957年生，高级工程师，水文地质工程地质专业。

The Statistical Analysis of Soil Test Report with Excel VBA

LIU  Da  hai    

  1. (Shenzhen Geology Bureau, Shenzhen 518023, China)
  • Received:2010-08-16 Online:2011-08-20 Published:2011-11-23

摘要： 土工试验指标分层统计分析是岩土工程勘察报告数据分析的基础，是提供地基承载力、桩基承载力、地基变形、基坑支护等岩土参数的主要依据。以Excel VBA为平台，编制独立于土工试验报告之外的统计分析模板，实现了分层数据的统计处理，其输出的Excel统计报表可直接作为勘察报告的工程文档。

关键词: 土工试验, 统计分析, 岩土参数, Excel VBA ,  ,  

Abstract: The stratified statistics of soil test indicators is the basis of data analysis in geotechnical engineering investigation, which is the main basis for providing geotechnical parameters such as bearing capacity of foundation and pile, ground deformation analysis and foundation pit supporting. Based on Excel soil test report and Excel VBA, template of statistical analysis is prepared and statistical processing of stratified data is realized. Its Excel table can be used directly as the project document of a survey report.