应用Excel软件建立坐标系绘制粒度曲线的方法  

Method of Drawing Particle Size Curve by Creating Coordinate System in Excel

作　　者：张丽娜[1] 李静[1] 牛占[1] 

机构地区：[1]黄河水利委员会水文局,河南郑州450004

出　　处：《水利水文自动化》2009年第4期37-42,共6页Automation in Water Resources and Hydrology

摘　　要：结合泥沙粒度分析和粒度曲线绘制的一般要求,介绍了绘制粒度曲线的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.

关 键 词：EXCEL 泥沙 粒度曲线 级配曲线 粒度分析 半对数坐标 对数机率坐标 

分 类 号：TP31[自动化与计算机技术—计算机软件与理论] P333.4[自动化与计算机技术—计算机科学与技术]