摘要
结合泥沙粒度分析和粒度曲线绘制的一般要求,介绍了绘制粒度曲线的2种常用坐标系。针对过去绘制粒度曲线用手工作业,效率不高,质量检查费时繁琐;程序绘制粒度曲线,通用性受限,总结出在Excel上建立坐标系绘制粒度曲线的方法。详细介绍了采用Excel软件的半对数坐标系绘制粒度曲线和设计对数机率坐标系绘制粒度曲线的思路和步骤,以给相关人员绘制粒度曲线提供参考。
According to general requirements for sediment particle size analysis and curve drawing, two ordinary coordinate systems used in drawing particle size curve are presented. Because drawing by manual work suffers disadvantages of low efficiency, time-consuming ＆ tedious quality inspection procedures and limited generality, a new drawing method of creating coordinate systems in Excel was founded. The author makes an detailed analysis on thinkings and procedures for drawing by semi-logarithm coordinate systems and logarithm probability coordinate systems in Excel, in the hope of offering some reference for concerning personnel in drawing particle size cure.
出处
《水利水文自动化》
2009年第4期37-42,共6页
Automation in Water Resources and Hydrology
关键词
EXCEL
泥沙
粒度曲线
级配曲线
粒度分析
半对数坐标
对数机率坐标
Excel
sediment
particle size curve
grading curve
particle size analysis
semi-logarithm coordinates
logarithm probability coordinates
