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

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

作　　者：马定乐 刘锋 李善强 许新权 MA Dinge;LIU Feng;LI Shanqiang;XU Xinquan(Gongdong Provincial Transportation Industrial Investment Co.,Ltd.,Guangzhou Guangdong 510623,China;Guangdong Hualu Transport Technology Co.,Ltd.,Guangzhou Guangdong 510420,China;Research and Development Center on Road Transport Safety and Emergency Support Technology&Equipment,Ministry of Transportation,PRC,Guangzhou Guangdong 510420,China;Guangdong Jiaoke Technology R&D Co.,Ltd.,Guangzhou Guangdong 510550,China)

机构地区：[1]广东交通实业投资有限公司,广东广州510623 [2]广东华路交通科技有限公司,广东广州510420 [3]公路交通安全与应急保障技术及装备交通运输行业研发中心,广东广州510420 [4]广东交科技术研发有限公司,广东广州510550

出　　处：《广东公路交通》2024年第2期7-13,共7页Guangdong Highway Communications

基　　金：广东省基础与应用基础研究基金(2022A1515011326);广东省交通集团有限公司科技项目(JT2022YB12)。

摘　　要：为了便于沥青混合料动态模量主曲线在自研沥青混凝土路面设计中的应用,在掌握其基本计算原理的基础上,以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.

关 键 词：道路工程 沥青混合料动态模量主曲线 规划求解 数据有效性 

分 类 号：U416.217[交通运输工程—道路与铁道工程]