《_隧道监控量测电子表格计算.xls》由会员分享，可在线阅读，更多相关《_隧道监控量测电子表格计算.xls（16页珍藏版）》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、福厦高速铁路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.73D52
2、006612310.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.80D5200665
3、2510.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+32
4、0量测断面编号测线编号量测时间温度观 测 值温度修正值修 正 后观 测 值相 对第一次收敛值相 对上 次收敛值间隔时间收敛 速度备注年月日尺孔位置尺孔位置平均值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
5、.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.24D42006692
6、610.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量测断面编号测线编号量测时间温度观 测 值温度修正值修 正 后观 测 值相 对第一次收敛值相 对上 次收敛值间隔时间收敛 速度备注年月日尺孔位置尺孔位
7、置平均值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.
8、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.0
9、2D420066193010.2035.5710.2035.5710.2035.57-0.09610.2035.4719.160.0210.02测量者记录者测线布置图施工单位自检意见：现场技术负责人：年 月 日 厦门福厦高速铁路ZD-1合同段现 场 监 控 量 测 记 录 表 合同段第 1 页隧道名称 隧道桩号D1K39+320量测断面编号测线编号量测时间温度观 测 值温度修正值修 正 后观 测 值相 对第一次收敛值相 对上 次收敛值间隔时间收敛 速度备注年月日尺孔位置尺孔位置平均值mmmmmmmmmmmmmmmmmmdmm/dD520065303110.2035.5710.2035.5710
10、.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.13
11、210.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.
12、17-0.011(0.01)测量者记录者测线布置图施工单位自检意见：现场技术负责人：年 月 日 厦门福厦高速铁路ZD-1合同段现 场 监 控 量 测 记 录 表 合同段第 1 页隧道名称 隧道桩号D1K39+320量测断面编号测线编号量测时间温度观 测 值温度修正值修 正 后观 测 值相 对第一次收敛值相 对上 次收敛值间隔时间收敛 速度备注年月日尺孔位置尺孔位置平均值mmmmmmmmmmmmmmmmmmdmm/dD420066293010.2035.5710.2035.5710.2035.57-0.09610.2035.4719.16-0.011(0.01)D420066303210.203
13、5.5710.2035.5710.2035.57-0.12010.2035.4519.180.0210.02D42006713310.2035.5710.2035.5710.2035.57-0.13210.2035.4419.190.0110.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=
14、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以上三种回归方程,函数3 3的相关系数r的绝对值最靠近1 1,第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
15、第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.047
16、6.812017.0092.984017.6296.36三、量测数据处理结果1、推算出最终位移量：Umax=18.28mm2、推算出基本稳定时间：第40天以后，开挖面距该量测断面m，围岩收敛值达17.62mm,收敛率达96.3680；位移速度为0.01mm/天0.2mm/天故围岩基本稳定。3、评定:该段围岩稳定性较差,初期支护4040天后该围岩收敛完成、形成自稳,可进行二.次衬砌。计算:校核:日期:7 10 12 13 14 15 15 15 16 16 16 16 16 17 17 收敛变化关系图1234567891011121314150 5 10 15 20 时间(T)位移量(U)-1/
17、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.430676558147.90486252.046835414-17.27971147-1.285097209176.15943081.651474836-16.54434147-1.183294662197.180
18、71361.400186258-16.15907191-1.107309365213.35707081.22613403-15.90096248-1.047951637226.16211241.098202634-15.77795985-1236.53784221-15.836-0.960252568245.10959050.922084994-15.76926767-0.926628408252.30698070.858640207-15.75268294-0.897711718258.43420220.805886328-15.74945437-0.87250287263.71234290
19、.761261257-15.71377668-0.850274154268.30579120.722966136-15.64674498-0.830482024272.33923340.689700392-15.48350685-19.47097659275.908910931.37019086-256.29368873195.0073181/tlnU(1/t)2(1/t)*lnUba1/T12.04459126412.044591264-0.95580466817.499031710.52.2836061260.251.1418030634.1803534380.50.3333333332.
20、4076655690.1111111110.802555195.2148569410.3333333330.252.4913856160.06250.6228464045.7968534940.250.22.5552097740.040.5110419556.2070022870.20.1666666672.6141789850.0277777780.4356964986.5290969870.1666666670.1428571432.6644465640.0204081630.3806352236.8339317680.1428571430.1252.7117765830.0156250.
21、3389720737.099275490.1250.1111111112.7622858290.0123456790.3069206487.3537322350.1111111110.12.7986218990.010.279862197.6302230020.10.0909090912.8332133440.0082644630.2575648497.8322845350.0909090910.0833333332.8647120110.0069444440.2387260018.0270978530.0833333330.0769230772.8909271590.005917160.22
22、23790128.2065749070.0769230770.0714285712.9124593540.0051020410.2080328118.357459840.0714285710.0666666672.9255243790.0044444440.1950349598.4824194910.0666666673.31822899339.760604461.5804402837.986662148.5586928893.318228993106.30985521/U(1/t)*(1/t)(1/U)*(1/t)ba0.12943308310.1294330830.05469710.082
23、5864910.1019160210.250.0509580110.0167529230.0900252070.1111111110.0300084020.0103868750.0827951650.06250.0206987910.0081045380.0776759360.040.0155351870.0068550390.0732278850.0277777780.0122046480.0060335510.0696378830.0204081630.0099482690.0053623230.0664187040.0156250.0083023380.0048494350.063147
24、2590.0123456790.0070163620.0044114440.0608939230.010.0060893920.0039875760.0588235290.0082644630.0053475940.003708070.0569995440.0069444440.0047499620.0034602080.0555247080.005917160.0042711310.0032489480.0543419190.0051020410.0038815660.0030829930.0536365590.0044444440.0035757710.0029530441.0944973
25、261.5804402830.3120205070.002876880.086073848_DK211+970_DK211+970_右右侧侧上上导导拱拱顶顶_沉沉降降观观测测记记录录表表观测次数 观测时间各观测点的沉降情况备注测点_1_测点_2_高程本次累积下沉高程本次下沉 累积下沉/m下沉/mm/m/mm/mm/mm12007.4.4/67.1280022007.4.567.1217732007.4.667.11381542007.4.767.1131852007.4.867.10822062007.4.967.10712172007.4.1067.10702182007.4.1167.10
26、612292007.4.1267.106022102007.4.1367.106022112007.4.1467.106022122007.4.1567.105123132007.4.1667.105023142007.4.1767.105023152007.4.1867.105023162007.4.1967.105023172007.4.2067.104124182007.4.2167.105024192007.4.2267.104024202007.4.2367.105024212007.4.2467.104024222007.4.2567.105024232007.4.2667.104
27、024242007.4.2767.105024252007.4.2867.104024262007.4.2967.105024272007.4.3067.104024282007.5.167.105024292007.5.267.104024302007.5.367.105024312007.5.467.104024322007.5.567.105024332007.5.667.104024342007.5.767.105024352007.5.867.104024362007.5.967.105024372007.5.1067.104024382007.5.1167.105024392007.5.1267.104024回归分析观测：计算：