基于建筑物沉降变形数据处理的Visual Basic-Excel软件设计
|
摘要
建筑物沉降变形数据量比较大,只靠人工计算既费时又费力,如果用计算机进行数据处理将会大大缩短计算时间,利用Visual Basic(VB)软件导入EXCEL数据,对导入的数据进行数据处理,并对处理数据的结果用图表表示,设计过程需要解决三个方面的问题,首先读取Excel文件,把Excel工作表里面的数据放到控件ListView里面,按照Excel工作表里面数据的格式在相应ListView里面排列出来,使操作者方便校验。其次对沉降数据点进行一定的分析,计算其每段时间每个沉降点的沉降量以及累计沉降量,通过VB把计算出来的数值在TextBox控件里显示出来。三是计算出来的结果把每段时间沉降点的沉降量趋势图在VB的Picture控件里显示出来。
The amount of building settlement deformation data is relatively large. It is time-consuming and laborious to rely on manual calculation. If the computer uses data processing, the calculation time will be greatly shortened. The EXCEL data will be imported by VB software, and the imported data will be processed and processed.The results are represented by graphs. The design process needs to solve three problems. First, read the Excel file,put the data in the Excel worksheet into the control ListView, and arrange it in the corresponding ListView according to the format of the data in the Excel worksheet. Make the operator easy to verify. Secondly, the settlement data points are analyzed to calculate the settlement and cumulative settlement of each settlement point at each time. The calculated value is displayed in the TextBox control through VB. The third is the calculated result. The settlement trend graph of the settlement point at each time is displayed in the Picture Control of VB.
The amount of building settlement deformation data is relatively large. It is time-consuming and laborious to rely on manual calculation. If the computer uses data processing, the calculation time will be greatly shortened. The EXCEL data will be imported by VB software, and the imported data will be processed and processed.The results are represented by graphs. The design process needs to solve three problems. First, read the Excel file,put the data in the Excel worksheet into the control ListView, and arrange it in the corresponding ListView according to the format of the data in the Excel worksheet. Make the operator easy to verify. Secondly, the settlement data points are analyzed to calculate the settlement and cumulative settlement of each settlement point at each time. The calculated value is displayed in the TextBox control through VB. The third is the calculated result. The settlement trend graph of the settlement point at each time is displayed in the Picture Control of VB.
引文
[1]梅文胜,张正禄,黄全义.测量机器人在变形监测中的应用研究[J].大坝与安全,2005,(5):21-23.
[2]刘祖强,刘艳杰.清江库区丹水扯洪渠边坡变形监测与变形分析[J].地理空间信息,2007,(3):89-92.
[3]杨柳.变形监测技术的发展与应用[J].山西建筑,2008,(26):52-53.
[4]Martin Ross,Michel Parent,Rene Lefebvre.3D geologic framework models for regional hydmgeology and land use management:a case study from a Quaternary basin of Southwestern Quebec,Canada[J].Hydrogeology journal,2005,13(5):690-707.
[5]杜淑颖.基于大型数据集的聚类算法研究[J].软件,2016,37(01):132-135.
[6]陈晓燕,张鲲.数据库系统原理课程教学改革探索[J].软件,2018,39(3):102-105.
[7]白长清,刘敏.MongoDB在气象传感器数据处理中的应用[J].软件,2015,36(11):34-37.
[8]吴江,孙剑伟.一种基于云模型的数据预测算法[J].软件,2015,36(12):212-215.
[9]徐治.Visual C++调用MATLAB函数库的混合编程技术[J].软件,2015,36(2):55-58.
[10]卫建东.现代变形检测技术的发展现状与展望[J].测绘科学,2007(6):32-34.
[11]柳青,刘渝妍等编.Visual Basic程序设计教程[M].北京:高等教育出版社,2002.
[12]刘钢,杨崇礼等编著.Visual Basic 6.0程序设计实用教程[M].北京:中国民航出版社,2000.
[2]刘祖强,刘艳杰.清江库区丹水扯洪渠边坡变形监测与变形分析[J].地理空间信息,2007,(3):89-92.
[3]杨柳.变形监测技术的发展与应用[J].山西建筑,2008,(26):52-53.
[4]Martin Ross,Michel Parent,Rene Lefebvre.3D geologic framework models for regional hydmgeology and land use management:a case study from a Quaternary basin of Southwestern Quebec,Canada[J].Hydrogeology journal,2005,13(5):690-707.
[5]杜淑颖.基于大型数据集的聚类算法研究[J].软件,2016,37(01):132-135.
[6]陈晓燕,张鲲.数据库系统原理课程教学改革探索[J].软件,2018,39(3):102-105.
[7]白长清,刘敏.MongoDB在气象传感器数据处理中的应用[J].软件,2015,36(11):34-37.
[8]吴江,孙剑伟.一种基于云模型的数据预测算法[J].软件,2015,36(12):212-215.
[9]徐治.Visual C++调用MATLAB函数库的混合编程技术[J].软件,2015,36(2):55-58.
[10]卫建东.现代变形检测技术的发展现状与展望[J].测绘科学,2007(6):32-34.
[11]柳青,刘渝妍等编.Visual Basic程序设计教程[M].北京:高等教育出版社,2002.
[12]刘钢,杨崇礼等编著.Visual Basic 6.0程序设计实用教程[M].北京:中国民航出版社,2000.