隧道施工引起地表沉降Peck公式参数反分析程序与云数据库

Back-analysis Code and Cloud Database of Peck Formula Parameters for Ground Settlement Induced by Tunnel Construction

世界各地实际监测数据已表明Peck公式是预测隧道施工引起地表沉降的简单、实用、有效的方法,其使用关键是依赖于地区经验而确定公式参数。我国在过去几十年中,尤其近十几年大量的地铁建设中,积累了大量的现场隧道施工引起地面沉降的监测数据,若将这些数据(即使极小比例的数据)反分析计算得到的Peck公式参数共享起来,对指导未来的隧道建设必定大有裨益。本文基于Microsoft Excel VBA开发了一款名为ZJUPECK程序,方便广大工程师快速实现Peck公式参数反分析计算;同时,本文基于Office 365云端Excel建立了Peck公式参数云数据库,为广大工程师提供参数参考和数据共享平台。

Actual monitoring data around the world has shown that Peck formula is a simple,practical and effective method for predicting ground settlement induced by tunnel construction.The key step of its application is to estimate formula parameters based on regional experience.In the past few decades,especially in the past decade,a large number of subway construction in China has accumulated a large number of monitoring data of ground settlement induced by tunnel construction.If the back-analysis calculated Peck formula parameters based on these data(even a very small proportion of them)are shared,it will be of great benefit to Chinses future tunnel constructions.In this paper,a program named ZJUPECK is developed based on Microsoft Excel VBA,which is convenient for engineers to realize the back-analysis calculation of Peck formula parameters quickly.In addition,a cloud database of Peck formula parameters is established based on Office 365 cloud Excel,which provides parameter reference and data sharing platform for engineers.