摘要
计算粒度参数较常用的图解法一般要通过手工绘制粒度概率累积曲线,从中读取百分位数,不利于计算大量样品。作者利用Excel函数将正态概率坐标转化为线性坐标,再进行线性插值,通过Excel VBA直接调用Excel内置的丰富函数,编写了粒度参数计算程序。该程序可不通过作图,直接利用图解法的原理批量计算粒度参数。与手工绘图计算相比,该方法精度较高,极大地提高了工作效率。
Accumulative curves have to be drawn artificially to calculate percentiles in grain size distributions by using the graphic technique.The artificial drawing is not of great beneficial to the calculation of a large number of samples.The authors transform the normal distribution coordinate into the linear coordinate using Excel function and suggest a mathematical method to do linear interpolation.With the Excel VBA which can directly call Excel＇s internal abundant function,the programing of calculating grain size parameters is compiled.With this programing,the graphic technique can be used to calculate grain size parameters without any kinds of graphic drawing.Compared with the manual calculation,the method has high precision and greatly improves the efficiency.
出处
《成都理工大学学报（自然科学版）》
CAS
CSCD
北大核心
2010年第6期650-653,共4页
Journal of Chengdu University of Technology: Science & Technology Edition
关键词
粒度参数
图解法
EXCEL
VBA
概率曲线
grain size parameter
graphical calculation
Excel VBA
probability plot
