基于.NET和EXCEL的沥青混合料动态模量主曲线的确定

Determination of Master Curve of Dynamic Modulus of Asphalt Mixture based on.NET and EXCEL

为了便于沥青混合料动态模量主曲线在自研沥青混凝土路面设计中的应用,在掌握其基本计算原理的基础上,以Visual Studio.Net为开发平台,Excel为数据存储仓库,同时结合Excel中的规划求解功能,研发了可根据相关试验数据即可自动求解沥青混合料动态模量主曲线的系统。测试运行结果显示:系统运行稳定,可根据技术人员输入的试验数据,准确地获得相关的求解结果,同时完成沥青混合料动态模量主曲线的绘制。此外,系统可对输入各单元格的数据的有效性进行检验,避免数据单元格输入文本信息的错误,因此可较大地提高系统的容错能力,也更进一步提高了系统的可靠性。

In order to facilitate application of dynamic modulus master curve of asphalt mixture in design of self-developed asphalt concrete pavement,on the basis of mastering its basic calculation principles,Visual Studio.Net has been used as the development platform,Excel has been used as data storage warehouse,at the same time,being combined with the programming function of Excel,a system which can automatically solve the dynamic modulus master curve of asphalt mixture according to the relevant test data has been developed.The test results have shown that the system runs stably,and the results can be obtained accurately according to the test data inputted by technicians and the main curve of dynamic modulus of asphalt mixture can be drawn at the same time.In addition,the system can check the validity of the input cells to avoid errors in entering text information in the data cells.Therefore,the fault tolerance capability of the system can be greatly improved and the reliability of the system can be further improved.