隧道监控量测电子表格计算 - 副本

关州电站现场监控量测记录表 合同 劳动合同范本免费下载装修合同范本免费下载租赁合同免费下载房屋买卖合同下载劳务合同范本下载 段：CI标第1页隧道名称1#隧道量测断面编号K0+720测线编号量测时间温度观测值相对第一次值相对上次值间隔时间收敛速度备注年月日℃xyz▲x▲y▲z▲x▲y▲z▲sdmm/dk0-7202011121429503.821501865.8842113.269k0-7202011112429503.819501865.8892113.268-25-1-25-1515k0-7202011113429503.820501865.8892113.267-15-210-1111k0-7202011114429503.818501865.8852113.266-31-3-2-4-1414k0-7202011115429503.817501865.8842113.268-40-1-1-12111k0-7202011116429503.821501865.8862113.267-02-241-1515k0-7202011117429503.816501865.8892113.267-55-2-53-0616k0-7202011129429503.819501865.8892113.269-25-0302313k0-72020111211429503.817501865.8852113.267-41-2-2-4-2422k0-72020111213429503.816501865.8862113.269-52-0-011121k0-72020111215429503.817501865.8862113.267-42-21-1-2121k0-72020111220429503.821501865.8882113.266-04-343-1451k0-72020111225429503.817501865.8882113.267-44-2-3-11451测量者：曹盼良现场技术负责人：年月日关州电站现场监控量测记录表合同段：CI标第2页隧道名称1#隧道量测断面编号K0+730测线编号量测时间温度观测值相对第一次值相对上次值间隔时间收敛速度备注年月日℃xyz▲x▲y▲z▲x▲y▲z▲sdmm/dk0-7302011121429502.676501855.9492114.099k0-7302011112429502.677501855.9492114.09710-210-2111k0-7302011113429502.680501855.9462114.0964-3-32-3-1414k0-7302011114429502.678501855.9462114.0962-3-3-100111k0-7302011115429502.679501855.9492114.0963-0-3130313k0-7302011116429502.679501855.9472114.0983-2-1-1-22212k0-7302011117429502.676501855.9472114.098-0-2-1-30-1313k0-7302011129429502.674501855.9512114.096-22-3-24-2515k0-73020111211429502.671501855.9522114.098-53-1-312322k0-73020111213429502.673501855.9512114.098-32-12-1-0221k0-73020111215429502.672501855.9522114.097-43-2-11-1121k0-73020111220429502.672501855.9492114.096-40-3-1-3-1351k0-73020111225429502.679501855.9502114.09831-1712751测量者：曹盼良现场技术负责人：年月日关州电站现场监控量测记录表合同段：CI标第3页隧道名称1#隧道量测断面编号K0-30测线编号量测时间温度观测值相对第一次值相对上次值间隔时间收敛速度备注年月日℃xyz▲x▲y▲z▲x▲y▲z▲sdmm/dk0-302011112422429809.114502522.7892114.517k0-302011112525429809.114502522.7902114.518-011-011212k0-302011112623429809.111502522.7902114.518-311-3-00313k0-302011112726429809.113502522.7902114.519-112201212k0-302011112826429809.110502522.7912114.519-422-31-0313k0-302011112924429809.110502522.7912114.519-422-010111k0-302011113025429809.116502522.7922114.51823161-1616k0-30201112122429809.117502522.7902114.5173101-3-0313k0-30201112420429809.114502522.7922114.520033-323331k0-30201112721429809.118502522.7922114.51743040-3431k0-302011121022429809.116502522.7922114.520233-202231k0-302011121323429809.116502522.7902114.5192120-2-0231k0-302011121624429809.111502522.7892114.519-302-6-1-0632k0-302011121924429809.113502522.7912114.519-12232-0431测量者：曹盼良现场技术负责人：年月日关州电站现场监控量测记录表合同段：CI标第4页隧道名称1#隧道量测断面编号K0-10测线编号量测时间温度观测值相对第一次值相对上次值间隔时间收敛速度备注年月日℃xyz▲x▲y▲z▲x▲y▲z▲sdmm/dk0-102011112422429819.847502505.9132114.507k0-102011112525429819.846502505.9152114.507-120-120212k0-102011112623429819.847502505.9142114.508-0111-11111k0-102011112726429819.844502505.9152114.510-323-311313k0-102011112826429819.846502505.9152114.507-12020-3212k0-102011112924429819.846502505.9152114.510-1230-03010k0-102011113025429819.845502505.9162114.508-231-11-1212k0-10201112122429819.844502505.9152114.508-321-1-1-1111k0-10201112420429819.848502505.9162114.508131311331k0-10201112721429819.848502505.9152114.5081211-1-0130k0-102011121022429819.848502505.9152114.508121-000030k0-102011121323429819.845502505.9152114.508-221-3-0-0331k0-102011121624429819.844502505.9162114.510-333-112130k0-112011121924429819.847502505.9142114.508-0112-2-2331测量者：曹盼良现场技术负责人：年月日关州电站现场监控量测记录表1#引水隧洞量测数据的处理与回归 分析 定性数据统计分析pdf销售业绩分析模板建筑结构震害分析销售进度分析表京东商城竞争战略分析 一、建立位移（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=#REF!-#REF!/lg（1+T）r=#REF!-1/lg(1+t)∑Ub(-1/lg(1+t))*(-1/lg(1+t))a1/tlnU(1/t)2(1/t)*lnUba1/T1/U(1/t)*(1/t)(1/U)*(1/t)ba第01天-1.73#NUM!#NUM!2、指数函数U=#NUM!e(#NUM!/T)-3.321928095#REF!#REF!11.03520627#REF!5.7342492061#NUM!1#NUM!#NUM!#NUM!1-0.57931352051-0.5793135205#REF!#REF!第02天0.57#NUM!#NUM!r=#NUM!-2.095903274#NUM!4.392810535-1.1902378850.5-0.56583142680.25-0.2829157134#NUM!0.51.7609112430.250.88045562150.33560415513、双曲函数U=T/(#REF!#REF!*T)第03天-1.88#NUM!#NUM!-1.660964047#NUM!2.7588015673.1184464260.3333333333#NUM!0.1111111111#NUM!0.32016520350.3333333333-0.53262548740.1111111111-0.17754182913.100808406r=#REF!第04天-1.35#NUM!#NUM!以上三种回归方程,函数#NUM!的相关系数r的绝对值最靠近1,-1.430676558#NUM!2.0468354141.9353876830.25#NUM!0.0625#NUM!#NUM!0.25-0.73921962530.0625-0.18480490630.2836899098第05天4.34#NUM!#NUM!回归精度较高.故选用该回归方程来预测#REF!-1.285097209#NUM!1.651474836-5.5832044110.21.4689285140.040.2937857029#NUM!0.20.23017197910.040.04603439580.5464456544的最终收敛情况.第06天-4.77#NUM!#NUM!-1.183294662#NUM!1.4001862585.6441675230.1666666667#NUM!0.0277777778#NUM!2.157750980.1666666667-0.20964910370.0277777778-0.03494151730.05297914第07天2.68#NUM!#NUM!-1.107309365#NUM!1.22613403-2.9643478140.14285714290.98472396970.02040816330.1406748528#NUM!0.14285714290.37354232170.02040816330.05336318880.0439527467第08天-2.10#NUM!#NUM!-1.047951637#NUM!1.0982026342.202664290.125#NUM!0.015625#NUM!0.96968129640.125-0.47576548170.015625-0.05947068520.1395338661第09天#REF!#NUM!#REF!-1#NUM!1#REF!0.1111111111#REF!0.012345679#REF!#NUM!0.1111111111#REF!0.012345679#REF!0.2263527936第10天#REF!#NUM!#REF!-0.9602525678#NUM!0.9220849939#REF!0.1#REF!0.01#REF!#REF!0.1#REF!0.01#REF!#REF!第11天#REF!#NUM!#REF!-0.926628408#NUM!0.8586402066#REF!0.0909090909#REF!0.0082644628#REF!#REF!0.0909090909#REF!0.0082644628#REF!#REF!第12天#REF!#NUM!#REF!备注-0.8977117175#NUM!0.8058863277#REF!0.0833333333#REF!0.0069444444#REF!#REF!0.0833333333#REF!0.0069444444#REF!#REF!第13天#REF!#NUM!#REF!平均值:U=#NUM!-0.8725028695#NUM!0.7612612574#REF!0.0769230769#REF!0.0059171598#REF!#REF!0.0769230769#REF!0.0059171598#REF!#REF!第14天#REF!#NUM!#REF!标准差:S=√∑(U-U)2/n=#NUM!-0.8502741537#NUM!0.7229661365#REF!0.0714285714#REF!0.0051020408#REF!#REF!0.0714285714#REF!0.0051020408#REF!#REF!第15天#REF!#NUM!#REF!变异系数:Sr=S/U*100％=#NUM!％-0.8304820237#NUM!0.6897003917#REF!0.0666666667#REF!0.0044444444#REF!#REF!0.0666666667#REF!0.0044444444#REF!#REF!∑（U-U）2=#NUM!里程桩号:#REF!围岩类别:Ⅴ-19.47097659#NUM!31.37019086#REF!3.318228993#NUM!1.580440283#NUM!#REF!3.318228993#REF!1.580440283#REF!#REF!二、根据量测数据和选取的回归方程绘制：位移量（U）与时间（T）的变化关系图#NUM!#NUM!#REF!时间T收敛值U（mm）收敛率U/Umax*100％时间T收敛值U（mm）收敛率U/Umax*100％时间T收敛值U（mm）收敛率U/Umax*100％5#NUM!#NUM!20#NUM!#NUM!40#NUM!#NUM!三、量测数据处理结果1、推算出最终位移量：Umax=#NUM!mm2、推算出基本稳定时间：第#NUM!天以后，开挖面距该量测断面m，围岩收敛值达#NUM!mm,收敛率达#NUM!％≥80％；位移速度为#NUM!mm/天≤0.2mm/天故围岩基本稳定。3、评定:该段围岩稳定性较差,初期支护#NUM!天后该围岩收敛完成、形成自稳,可进行二.次衬砌。计算:校核:日期:____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.10612292007.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.104024242007.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回归分析观测：计算：