基于 Excel 自动绘制地震安全性评价报告的钻孔综合柱状图

摘要

钻孔综合柱状图是地震安全性评价报告中必备的一种图件。本文介绍在Excel中自动生成钻孔综合柱状图的方法，实现在Excel中设计柱状图框架，并利用Excel vba编程自动生成岩土柱状及剪切波速曲线。该方法运用一键式成图，简单易用，已在实践中得到较好的应用。%Drilling synthesis column is the necessary map of seismic safety evaluation report .The method of automatic generation of drilling synthesis column in Excel is introduced .The design of column frame and automatic generation of lithologic column and shear wave velocity curve by VBA programming are implemented in the excel .This method which uses one‐touch drafting is easy to oper‐ate .And the method has been well used in practice .