基于Excel VBA监测网沉降基准点稳定性检验  

Stability Inspection of Settlement Reference Points Based on Excel VBA Monitoring Network

作　　者：蔡婷 CAI Ting(Shanghai Civil Defense Foundation Survey Institute Co.,Ltd.,Shanghai 200237,China)

机构地区：[1]上海市民防地基勘察院有限公司,上海200237

出　　处：《价值工程》2023年第18期136-138,共3页Value Engineering

摘　　要：本文对基于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.

关 键 词：Excel VBA 监测网 秩亏自由网平差 F检验 沉降基准点稳定性检验 

分 类 号：TU433[建筑科学—岩土工程]