三次样条函数法处理颗粒分析试验数据曲线  

Cubic spline function method is used to deal with the experimental data curve of particle analysis

作　　者：王维[1] WANG Wei(Hebei Institute of Investigation&Design of Water Conservancy&Hydropwer Group Limited,Tianjin 300220,China)

机构地区：[1]河北省水利水电勘测设计研究院集团有限公司,天津300220

出　　处：《水科学与工程技术》2025年第1期78-80,共3页Water Sciences and Engineering Technology

摘　　要：颗粒分析试验是土工试验中的基本项目,其结果是进行地基土分类和概略判断土的工程性质及选料之用的重要指标。在水利工程项目中,几乎所有土样均需做颗粒分析试验。尽管目前大多数试验室的试验过程还脱离不了人工操作,但数据处理基本实现了自动化,提高了生产效率和数据的准确性。由于在某些场合下受到商用软件限制,在数据处理和图形绘制方面不能满足要求。因此,通过实例详细描述了借助Excel的强大图表功能和丰富的内置函数,采用三次样条函数插值法进行了数据处理和曲线拟合。Particle analysis test is a basic item in geotechnical test.Its result is an important index to classify foundation soil and judge soil engineering properties and material selection.In the hydraulic engineering project,almost all soil samples are subjected to particle analysis tests.Although most of the laboratory test process can not be separated from the manual operation,but the data processing has basically realized the microcomputer automation,which greatly improves the production efficiency and the accuracy of data.Due to the restriction of commercial software in some cases,it can not meet the requirements in data processing and graphics rendering.Therefore,this paper describes in detail the use of Excel powerful chart functions and rich built-in functions,the use of cubic spline function interpolation data processing and curve fitting.

关 键 词：颗粒分析 EXCEL 函数 多项式 系数 

分 类 号：TU41[建筑科学—岩土工程]