文章对使用Excel进行击实试验数据处理的方法作了详细介绍,并对所采用的插值多项式的性质进行了讨论。应用Excel的高阶多项式插值方法,可以得到精确的多项式插值趋势线,并可以直接在Excel图表坐标系中读出击实曲线对应的最大干密度和最佳含水量。该方法消除了手工绘图的误差,同时避免了程序设计的繁琐,有较高的工程应用价值。 This paper introduces the method of compaction test data processing using Excel, and discusses the properties of the interpolation polynomial used. Using Excel’s high-order polynomial interpolation method, accurate polynomial interpolation trendlines can be obtained, and the maximum dry density and the optimal water content corresponding to the compaction curve can be read out directly in the Excel chart coordinate system. The method eliminates the error of manual drawing and avoids the cumbersome programming and high engineering application value.