基于Excel-DNA技术的土的渗透变形一站式标准化分析计算
Standardized One-stop Analysis and Calculation of Soil Seepage Deformation based on Excel-DNA Technology
吕超 1孙旭良 1苗强 1吴曼菲1
作者信息
- 1. 广西桂禹工程咨询有限公司 南宁市 530023
- 折叠
摘要
在进行土的渗透变形判别及允许水力比降计算时,涉及各特征粒径、不均匀系数Cu、细颗粒含量P、临界水力比降、允许水力比降等参数,传统图解法一般通过绘制粒径概率累积曲线并从中读取百分位数,再利用公式进行计算,其过程相对繁琐.因此,该文利用Excel-DNA编写了 Excel加载项程序,实现了土的特征粒径自动查询、不均匀系数自动计算、渗透变形型式自动判别、允许水力比降自动计算等功能,与传统图解计算法相比,该方法精度高、速度快,极大地提高了工作效率.
Abstract
Soil seepage deformation discrimination and permissible hydraulic gradient calculation involve various calculations,including parameters such as characteristic particle sizes,non-uniform coefficient(Cu),fine particle content(P),critical hydraulic gradient and permissible hydraulic gradient,etc.Per-centile data in traditional graphical calculation method is commonly read through plotting granularity prob-ability accumulation curves,and then followed by formulaic calculations,which is relatively cumber-some.Therefore,this paper introduces an Excel add-in program developed using Excel-DNA that auto-mates query of characteristic particle sizes,calculation of non-uniform coefficient,identification of seep-age 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/不均匀系数Cu/渗透变形判别/允许水力比降Key words
characteristic particle size/Excel-DNA/non-uniform coefficient(Cu)/seepage deformation discrimination/permissible hydraulic gradient引用本文复制引用
出版年
2024
NETL
NSTL
万方数据