隧道监控量测电子表格计算.xls

资源描述

隧道监控量测电子表格计算.xls

《隧道监控量测电子表格计算.xls》由会员分享，可在线阅读，更多相关《隧道监控量测电子表格计算.xls（16页珍藏版）》请在冰豆网上搜索。

隧道监控量测电子表格计算.xls

福厦高速铁路ZD-1合同段现场监控量测记录表合同段第1页隧道名称隧道桩号D1K39+320量测断面编号测线编号量测时间温度观测值温度修正值修正后观测值相对第一次收敛值相对上次收敛值间隔时间收敛速度备注年月日尺孔位置尺孔位置平均值mmmmmmmmmmmmmmmmmmdmm/dD520065302210.20324.6310.20324.6310.20324.630.00010.20324.630.00D520065312510.20316.9410.20316.9410.20316.94-0.03610.20316.907.737.7317.73D52006612310.20314.8310.20314.8310.20314.83-0.01210.20314.829.812.0912.09D52006622610.20313.5710.20313.5710.20313.57-0.04810.20313.5211.111.3011.30D52006632610.20312.6010.20312.6010.20312.60-0.04810.20312.5512.080.9710.97D52006642410.20311.7810.20311.7810.20311.78-0.02410.20311.7612.870.8010.80D52006652510.20311.0110.20311.0110.20311.01-0.03610.20310.9713.660.7810.78D52006662210.20310.2710.20310.2710.20310.270.00010.20310.2714.360.7010.70D52006672010.2039.5510.2039.5510.2039.550.02410.2039.5715.060.7010.70测量者记录者测线布置图施工单位自检意见：

现场技术负责人：

年月日厦门福厦高速铁路ZD-1合同段现场监控量测记录表合同段第1页隧道名称隧道桩号D1K39+320量测断面编号测线编号量测时间温度观测值温度修正值修正后观测值相对第一次收敛值相对上次收敛值间隔时间收敛速度备注年月日尺孔位置尺孔位置平均值mmmmmmmmmmmmmmmmmmdmm/dD42006622510.2038.8310.2038.8310.2038.83-0.03610.2038.7915.840.7810.78D42006632310.2038.2210.2038.2210.2038.22-0.01210.2038.2116.420.5910.59D42006642210.2037.6310.2037.6310.2037.630.00010.2037.6317.000.5810.58D42006652410.2037.1110.2037.1110.2037.11-0.02410.2037.0917.540.5410.54D42006662210.2036.6210.2036.6210.2036.620.00010.2036.6218.010.4710.47D42006672310.2036.2410.2036.2410.2036.24-0.01210.2036.2318.400.3910.39D42006682410.2036.0110.2036.0110.2036.01-0.02410.2035.9918.640.2410.24D42006692610.2035.7910.2035.7910.2035.79-0.04810.2035.7418.890.2410.24D420066102710.2035.6610.2035.6610.2035.66-0.06010.2035.6019.030.1410.14测量者记录者测线布置图施工单位自检意见：

现场技术负责人:

年月日厦门福厦高速铁路ZD-1合同段现场监控量测记录表合同段第1页隧道名称隧道桩号D1K39+320量测断面编号测线编号量测时间温度观测值温度修正值修正后观测值相对第一次收敛值相对上次收敛值间隔时间收敛速度备注年月日尺孔位置尺孔位置平均值mmmmmmmmmmmmmmmmmmdmm/dD420066112610.2035.5710.2035.5710.2035.57-0.04810.2035.5219.110.0810.08D420066122610.2035.5710.2035.5710.2035.57-0.04810.2035.5219.110.0010.00D420066132710.2035.5710.2035.5710.2035.57-0.06010.2035.5119.120.0110.01D420066142510.2035.5710.2035.5710.2035.57-0.03610.2035.5319.10-0.021（0.02）D420066152610.2035.5710.2035.5710.2035.57-0.04810.2035.5219.110.0110.01D420066162510.2035.5710.2035.5710.2035.57-0.03610.2035.5319.10-0.011（0.01）D420066172610.2035.5710.2035.5710.2035.57-0.04810.2035.5219.110.0110.01D420066182810.2035.5710.2035.5710.2035.57-0.07210.2035.5019.130.0210.02D420066193010.2035.5710.2035.5710.2035.57-0.09610.2035.4719.160.0210.02测量者记录者测线布置图施工单位自检意见：

现场技术负责人：

年月日厦门福厦高速铁路ZD-1合同段现场监控量测记录表合同段第1页隧道名称隧道桩号D1K39+320量测断面编号测线编号量测时间温度观测值温度修正值修正后观测值相对第一次收敛值相对上次收敛值间隔时间收敛速度备注年月日尺孔位置尺孔位置平均值mmmmmmmmmmmmmmmmmmdmm/dD520065303110.2035.5710.2035.5710.2035.57-0.10810.2035.4619.170.0110.01D520065312810.2035.5710.2035.5710.2035.57-0.07210.2035.5019.13-0.041（0.04）D52006612710.2035.5710.2035.5710.2035.57-0.06010.2035.5119.12-0.01-300.00D52006623210.2035.5710.2035.5710.2035.57-0.12010.2035.4519.180.0610.06D52006633310.2035.5710.2035.5710.2035.57-0.13210.2035.4419.190.0110.01D52006643410.2035.5710.2035.5710.2035.57-0.14410.2035.4319.200.0110.01D52006653310.2035.5710.2035.5710.2035.57-0.13210.2035.4419.19-0.011（0.01）D52006663210.2035.5710.2035.5710.2035.57-0.12010.2035.4519.18-0.011（0.01）D52006673110.2035.5710.2035.5710.2035.57-0.10810.2035.4619.17-0.011（0.01）测量者记录者测线布置图施工单位自检意见：

现场技术负责人：

年月日厦门量测数据的处理与回归分析一、建立位移（U）随时间（T）发展的时态函数，根据量测数据分别进行下列函数：

1、对数函数U=a+b/lg（1+T）；2、指数函数U=a*e-（b/T）；3、双曲函数U=T/（a+bT）的回归计算。

时间T实测收敛值U回归值UU-U1、对数函数U=20.397-4.490/lg（1+T）r=3.287第01天7.7370.442、指数函数U=17.499e（-0.956/T）第02天9.8110-0.61r=-0.9193、双曲函数U=T/（0.0830.055*T）第03天11.1112-1.05r=0.964第04天12.0813-1.19以上三种回归方程,函数33的相关系数r的绝对值最靠近11,第05天12.8714-1.17回归精度较高.故选用该回归方程来预测D1K39+320隧道的最终收敛情况.第06天13.6615-0.95第07天14.3615-0.68第08天15.0615-0.32第09天15.84160.18第10天16.42160.54第11天17.00160.92第12天17.54161.30备注第13天18.01161.63平均值:

U=14.37第14天18.40171.90标准差:

S=（U-U）2/n=0.29第15天18.64172.03变异系数:

Sr=S/U*100=2.03（U-U）2=19.210里程桩号:

D1K39+320隧道围岩类别:

二、根据量测数据和选取的回归方程绘制：

位移量（U）与时间（T）的变化关系图时间T收敛值U（mm）收敛率U/Umax*100时间T收敛值U（mm）收敛率U/Umax*100时间T收敛值U（mm）收敛率U/Umax*100514.0476.812017.0092.984017.6296.36三、量测数据处理结果1、推算出最终位移量：

Umax=18.28mm2、推算出基本稳定时间：

第40天以后，开挖面距该量测断面m，围岩收敛值达17.62mm,收敛率达96.3680；位移速度为0.01mm/天0.2mm/天故围岩基本稳定。

3、评定:

该段围岩稳定性较差,初期支护4040天后该围岩收敛完成、形成自稳,可进行二.次衬砌。

计算:

校核:

日期:

71012131415151516161616161717收敛变化关系图12345678910111213141505101520时间（T）位移量（U）-1/lg（1+t）Ub（-1/lg（1+t）*（-1/lg（1+t）a-3.321928095218.5284.49010805711.0352062720.39698592-25.66521646-2.09590327453.059452444.392810535-20.56500293-1.660964047108.52878172.758801567-18.44998864-1.43067655

展开阅读全文