Standardized One-stop Analysis and Calculation of Soil Seepage Deformation based on Excel-DNA Technology
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.
NETL
NSTL
万方数据
