摘要
本文对基于Excel VBA监测网沉降基准点稳定性检验方法进行分析,分析Excel VBA程序验证监测网沉降基准点稳定性的方法。介绍了Excel VBA和F检验原理,结合对某小区建筑物沉降观测的监测网沉降基准点稳定性案例,研究计算验证了Excel VBA程序在监测网沉降基准点稳定性可行,进而满足相关行业的发展需求。
This article analyzes the stability testing method for settlement reference points of monitoring networks based on Excel VBA,and analyzes the method for verifying the stability of settlement reference points of monitoring networks using Excel VBA programs.This paper introduces the principles of Excel VBA and F-test,combined with the case of the stability of the settlement reference point of the monitoring network for the settlement observation of buildings in a community,studies and calculates to verify that the stability of Excel VBA program in the settlement reference point of the monitoring network is feasible,thus meeting the development needs of related industries.
作者
蔡婷
CAI Ting(Shanghai Civil Defense Foundation Survey Institute Co.,Ltd.,Shanghai 200237,China)
出处
《价值工程》
2023年第18期136-138,共3页
Value Engineering
关键词
Excel
VBA
监测网
秩亏自由网平差
F检验
沉降基准点稳定性检验
Excel VBA
monitoring network
rank deficient freenet adjustment
F-test
stability inspection of settlement reference points
