《基于Excel沉降数据处理》.docVIP

基于Excel沉降数据处理 共 NUMPAGES 32页，第 PAGE 2页 共 NUMPAGES 31页，第 PAGE 21页 基于Excel沉降数据处理 摘要：在路基沉降及建筑物沉降的观测工作中，为掌握路基和建筑物沉降规律和趋势、控制和安排施工进度，就必须按要求进行长期沉降及稳定观测，随之即来的便是大量的观测数据。为了对实习获得的沉降观测数据用Excel软件进行处理，将沉降观测外业数据输入Excel表格，用Excel内置的函数计算功能计算出观测数据的平差值以及沉降随时间的变化值。接着对表格中出现的异常数据进行分析和处理，最后通过Excel强大的图表功能绘出沉降观测曲线图，对Excel在沉降观测上的工作性能进行完整的描述。 关键词：Excel，沉降数据，建筑物，表格 The settlement data processing based on Excel Abstract：Subgrade settlement and building settlement observations in order to master the roadbed and buildings, settlement patterns and trends, control and arrange the construction schedule, must be required to carry out the observation of long-term settlement and stability, along with that is, to the large number of observationsthe data. With Excel software internship settlement observation data processing and settlement observation of field data input Excel spreadsheet, Excel built-in function to calculate the calculated level difference of the observational data, and settlement change in value over time. Went on to appear in the form of abnormal data analysis and processing, the final settlement observation curve drawn through Excels powerful charting capabilities, a complete description of the performance of Excel on the settlement observation. Key Words：Excel, Settlement Data,building,Form 目录 TOC \o 1-3 \h \z \u HYPERLINK \l _Toc327128783 1 绪论 PAGEREF _Toc327128783 \h 2 HYPERLINK \l _Toc327128784 2 沉降观测的介绍以及Excel处理沉降数据的特点以及优势 PAGEREF _Toc327128784 \h 3 HYPERLINK \l _Toc327128785 2.1沉降观测的介绍 PAGEREF _Toc327128785 \h 3 HYPERLINK \l _Toc327128786 2.1.1 沉降观测的目的和意义 PAGEREF _Toc327128786 \h 3 HYPERLINK \l _Toc327128787 2.2.2 建筑物沉降信息获取的方法的发展 PAGEREF _Toc327128787 \h 5 HYPERLINK \l _Toc327128788 2.2.3 建筑物沉降变形信息预测的发展 PAGEREF _Toc327128788 \h 5 HYPERLINK \l _Toc327128789 2.2 Excel处理沉降数据的特点以及优势 PAGEREF _Toc327128789 \h 6 HYPERLINK \l _Toc327128790 2.2.1 Excel的工作表与4维数据 PAGEREF _Toc327128790 \h 6 HYPERLINK \l _Toc327128791 2.2.2 图与表的互动 PAGEREF _Toc327128791 \h 7 HYPERLINK \