用Excel求解沥青混合料矿料级配的方法

Method of Asphalt Mineral Aggregate Mix Design by Excel

针对传统沥青混合料矿料级配设计方法中人工计算效率低、易出错的问题,提出利用电子表格强大的"规划求解"、矩阵运算、绘图处理功能,进行矿料级配设计计算和级配图的绘制,并给出了应用方法和技巧。通过实际工程应用,表明利用Excel计算可以方便地得出各种集料的最佳用料比例,并极大地提高设计效率。

Aiming at the problem of low efficiency and mistakes occurred easily during the traditional asphalt aggregate mix designing, this paper introduces asphalt aggregate calculation and grading drawing using ＂Programming Solution＂, matrix calculation, drawing function of Excel and puts the method into project construction. The result suggests that optimal ratio of mineral aggregate can be found and greatly improve the efficiency.