基于Excel-DNA技术的土的渗透变形一站式标准化分析计算  

Standardized One-stop Analysis and Calculation of Soil Seepage Deformation based on Excel DNA Technology

作　　者：吕超 孙旭良 苗强 吴曼菲 Lv Chao;Sun Xuliang;Miao Qiang;Wu Manfei(Guangxi Guiyu Engineering Consulting Co.,Ltd.)

机构地区：[1]广西桂禹工程咨询有限公司,南宁市530023

出　　处：《勘察科学技术》2024年第6期36-40,共5页Site Investigation Science and Technology

摘　　要：在进行土的渗透变形判别及允许水力比降计算时,涉及各特征粒径、不均匀系数C_(u)、细颗粒含量P、临界水力比降、允许水力比降等参数,传统图解法一般通过绘制粒径概率累积曲线并从中读取百分位数,再利用公式进行计算,其过程相对繁琐。因此,该文利用Excel-DNA编写了Excel加载项程序,实现了土的特征粒径自动查询、不均匀系数自动计算、渗透变形型式自动判别、允许水力比降自动计算等功能,与传统图解计算法相比,该方法精度高、速度快,极大地提高了工作效率。Soil seepage deformation discrimination and permissible hydraulic gradient calculation involve various calculations,including parameters such as characteristic particle sizes,non-uniform coefficient(C_(u)),fine particle content(P),critical hydraulic gradient and permissible hydraulic gradient,etc.Percentile data in traditional graphical calculation method is commonly read through plotting granularity probability accumulation curves,and then followed by formulaic calculations,which is relatively cumbersome.Therefore,this paper introduces an Excel add-in program developed using Excel DNA that automates query of characteristic particle sizes,calculation of non-uniform coefficient,identification of seepage deformation pattern,calculation of permissible hydraulic gradient and other functions.Compared to the traditional graphical calculation method,this method offers higher precision and faster processing,which greatly improves the working efficiency.

关 键 词：特征粒径 Excel DNA 不均匀系数C_(u) 渗透变形判别 允许水力比降 

分 类 号：TP3[自动化与计算机技术—计算机科学与技术]