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

量测数据的处理与回归分析一、建立位移（U）随时间（T）发展的时态函数，根据量测数据分别进行下列函数：1、对数函数 U=a+b/lg（1+T）；2、指数函数 U=a*e时 间 T第01天第02天第03天第04天第05天第06天第07天第08天第09天第10天第11天第12天第13天第14天第15天实测收敛值U7.739.8111.1112.0812.8713.6614.3615.0615.8416.4217.0017.5418.0118.4018.64回归值 U71012131415151516161616161717-（b/T）；3、双曲函数 U=T/（a+bT）的回归计算。1、对数函数U=2、指数函数U=3、双曲函数U=20.39717.499T/(-e (0.0834.490/lg（1+T）r=3.287-0.956/T)r=0.055r=以上三种回归方程, 函数-0.919*T)0.964U-U0.44-0.61-1.05-1.19-1.17-0.95-0.68-0.320.180.540.921.301.631.902.033的相关系数r的绝对值最靠近1,D1K39+320 ××隧道回归精度较高.故选用该回归方程来预测的最终收敛情况.备 注平均值:标准差:变异系数U=14.372S=√∑(U-U)/n=0.292.03围岩类别:％Ⅴ: Sr=S/U*100％=D1K39+320 ××隧道2里程桩号:19.210∑（U-U）=二、根据量测数据和选取的回归方程绘制：位移量（U）与时间（T）的变化关系图收敛变化关系图18 16 14 12 10 8 6 4 2 0 1位移量(U)10 7 12 16 16 16 17 17 16 16 15 15 15 14 13 23456789时间(T)收敛值U（mm）17.00101112131415时 间 T5收敛值U（mm）14.04收敛率U/Umax*100％76.81时 间 T20收敛率时 间 TU/Umax*100％92.9840收敛值U（mm）17.62收敛率U/Umax*100％96.36三、量测数据处理结果1、推算出最终位移量：Umax=2、推算出基本稳定时间： 第17.62围岩收敛值达故围岩基本稳定。mm,收敛率达18.284096.36mm天以后，开挖面距该量测断面％≥80％；位移速度为0.01m，mm/天≤0.2mm/天3、评定:该段围岩稳定性较差,初期支护次衬砌。计算:

校核:

40天后该围岩收敛完成、形成自稳,可进行二.日期:

-1/lg(1+t)-3.321928095b∑U

4.490108057218.528

(-1/lg(1+t))*(-a

11.0352062720.39698592

-25.66521646-2.095903274-1.660964047-1.430676558-1.285097209-1.183294662-1.107309365-1.047951637

-1-0.960252568-0.926628408-0.897711718-0.87250287-0.850274154-0.830482024-19.47097659

53.05945244108.5287817147.9048625176.1594308197.1807136213.3570708226.1621124236.5378422245.1095905252.3069807258.4342022263.7123429268.3057912272.3392334275.90891093195.007318

4.3928105352.7588015672.0468354141.6514748361.4001862581.226134031.098202634

10.9220849940.8586402070.8058863280.7612612570.7229661360.68970039231.37019086

-20.56500293-18.44998864-17.27971147-16.54434147-16.15907191-15.90096248-15.77795985-15.836-15.76926767-15.75268294-15.74945437-15.71377668-15.64674498-15.48350685

-256.2936887

1/t

lnU

(1/t)2

(1/t)*lnUb

a

1/T

10.50.333333333

0.250.20.1666666670.142857143

0.1250.111111111

0.10.0909090910.0833333330.0769230770.0714285710.0666666673.318228993

2.0445912642.2836061262.4076655692.4913856162.5552097742.6141789852.6644465642.7117765832.7622858292.7986218992.8332133442.8647120112.8909271592.9124593542.92552437939.76060446

10.250.1111111110.06250.040.0277777780.0204081630.0156250.012345679

0.010.0082644630.0069444440.005917160.0051020410.0044444441.580440283

2.044591264-0.955804668

1.1418030630.802555190.6228464040.5110419550.4356964980.3806352230.3389720730.3069206480.279862190.2575648490.2387260010.2223790120.2080328110.1950349597.98666214

17.49903174.1803534385.2148569415.7968534946.2070022876.5290969876.8339317687.099275497.3537322357.6302230027.8322845358.0270978538.2065749078.357459848.4824194918.558692889

10.50.333333333

0.250.20.1666666670.142857143

0.1250.111111111

0.10.0909090910.0833333330.0769230770.0714285710.0666666673.318228993

106.3098552

1/U

0.129433083(1/t)*(1/t)

1(1/U)*(1/t)0.129433083b

0.0546971

a

0.0825864910.1019160210.0900252070.0827951650.0776759360.0732278850.0696378830.0664187040.0631472590.0608939230.0588235290.0569995440.0555247080.0543419190.0536365591.094497326

0.250.1111111110.06250.040.0277777780.0204081630.0156250.012345679

0.010.0082644630.0069444440.005917160.0051020410.0044444441.580440283

0.0509580110.0300084020.0206987910.0155351870.0122046480.0099482690.0083023380.0070163620.0060893920.0053475940.0047499620.0042711310.0038815660.0035757710.312020507

0.0167529230.0103868750.0081045380.0068550390.0060335510.0053623230.0048494350.0044114440.0039875760.003708070.0034602080.0032489480.0030829930.0029530440.00287688

0.086073848