Stability Inspection of Settlement Reference Points Based on Excel VBA Monitoring Network
蔡婷CAI Ting
(上海市民防地基勘察院有限公司,上海200237)
( Shanghai Civil Defense Foundation Survey Institute Co.,Ltd.,Shanghai 200237,China)
摘要:本文对基于Excel VBA监测网沉降基准点稳定性检验方法进行分析,分析Excel VBA 程序验证监测网沉降基准点稳定性的方法。介绍了Excel VBA和F检验原理，结合对某小区建筑物沉降观测的监测网沉降基准点稳定性案例，研究计算验证了ExcelVBA程序在监测网沉降基准点稳定性可行,进而满足相关行业的发展需求。
Abstract:'This article analynes the stability testing method for setlement reference points of monitoring networks based on Excel VBA,and analyzes the method for verifying the stability of setlement reference points of monitoring networks using Excel VBA programs. Thispaper introduces the principles of Excel VBA and F-test, combined with the case of the stability of the setlement reference point of themonitoring network for the settlement observation of buildlings in a community, studies and calculates to verify that the stability of ExcelVBA program in the setlement reference point of the monitoring network is feasible， thus meeting the development needs of relaltedindustries.
关键词:Excel VBA;监测网;秩亏自由网平差;F检验;沉降基准点稳定性检验
Key words: Excel VBA; monitoring network; rank deficient freenet adjustment; F -test; stability inspection of settlement referencepoints
|
