CAJ | 학술논문

依据变形监测的基本原理制作成的分析表格，只要在表内的指定单元格内粘贴经过平差易软件处理后的观测数据就自动生成处理分析的结果，使得数据更为严谨，特别有优势。本文着重对变形监测、Excel表格特点进行阐述，并运用VBA进行设计，将其应用到变形测量数据自动化处理方面。
의거변형감측적기본원리제작성적분석표격，지요재표내적지정단원격내점첩경과평차역연건처리후적관측수거취자동생성처리분석적결과，사득수거경위엄근，특별유우세。본문착중대변형감측、Excel표격특점진행천술，병운용VBA진행설계，장기응용도변형측량수거자동화처리방면。
The analysis table is made according to the basic principle of deformation monitoring. The processing result can be generated automatically only by pasting the observed data processed by adjustment software into the specified cell, making the data more strict. This article mainly expounds deformation monitoring and the characteristics of Excel spreadsheets, and uses VBA for the design and applies it to deformation measurement data automatic processing.