摘要
采用Excel+VBA编程对盐渍土数据进行自动化整理和评价,快速获得沿线各勘探点盐渍土类型、盐渍化程度、盐胀率、腐蚀性评价结果,并形成标准成果表,避免查表误判、花费时间长的缺点,提高盐渍土评价的准确性和工作效率。
Excel+VBA programming is used to automatically sort and evaluate the salty soil data,quickly obtain the evaluation results of salty soil type,salinization degree,salt expansion rate and corrosivity at various exploration points along the line,and form a standard result table so as to avoid the shortcomings of misjudgment and long time spent in checking the table and improve the accuracy and work efficiency of the evaluation of salty soil.
作者
王朋伟
赵天宇
梁烈
WANG Pengwei;ZHAO Tianyu;LIANG Lie(Gansu Province Transportation Planning,Survey&Design Institute Co.,Ltd.,Lanzhou 730030,China)
出处
《路基工程》
2021年第4期52-55,共4页
Subgrade Engineering
基金
甘肃省科技重大专项项目:甘肃省湿陷性黄土地区公路修筑成套技术研究(1302GKDA009)。
关键词
公路工程
VBA
盐渍土
快速评价
盐胀
腐蚀性
highway engineering
VBA
salty soil
rapid evaluation
salt expansion
corrosivity