公路桥梁技术状况评定分值计算EXCEL表格(梁桥-拱桥)_第1页
公路桥梁技术状况评定分值计算EXCEL表格(梁桥-拱桥)_第2页
公路桥梁技术状况评定分值计算EXCEL表格(梁桥-拱桥)_第3页
公路桥梁技术状况评定分值计算EXCEL表格(梁桥-拱桥)_第4页
公路桥梁技术状况评定分值计算EXCEL表格(梁桥-拱桥)_第5页
已阅读5页,还剩22页未读 继续免费阅读

下载本文档

版权说明:本文档由用户提供并上传,收益归属内容提供方,若内容存在侵权,请进行举报或认领

文档简介

★计算结果★,,项目名称:,,,,,,梁式桥各部件权重及得分,,,,,,,,,

,,部位,得分,部位等级,权重,总体得分,总体等级,部位,类别,评价部件,权重,得分,部位,类别,评价部件,权重,得分

,,上部结构,47.46,4类,0.4,70.26,3类,上部结构,1,上部承重构件,0.85,41.16,下部结构,9,河床,0.07,89.09

,,下部结构,89.58,2类,0.4,,,,2,上部一般构件,/,/,,10,调治构造物,/,/

,,桥面系,77.24,3类,0.2,,,,3,支座,0.15,84.22,桥面系,11,桥面铺装,0.47,80.52

,,最高等级类别,指标类别,,,,,下部结构,4,翼墙、耳墙,0.02,91.12,,12,伸缩缝装置,0.29,64.55

,,,1类,2类,3类,4类,5类,,5,锥坡、护坡,0.01,91.12,,13,人行道,/,/

,,3类,0,20,35,—,—,,6,桥墩,0.31,88.86,,14,栏杆、护栏,0.12,84.69

,,4类,0,25,40,50,—,,7,桥台,0.31,80.52,,15,排水系统,0.12,88.42

,,5类,0,35,45,60,100,,8,墩台基础,0.29,100.00,,16,照明。标志,/,/

,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,

上部结构,1、上部承重构件,,,该部件若不存在则整个表格不输入,若存在且无病害,在后端输入“1”——>,,,,,,,,,,<——,,,

,部件技术评定,病害检测指标扣分值,,,,病害数,扣分,,,,,构件最终得分,同类病害构件数,比例(%),平均得分,构件总数数n,部件得分

,,病害1,病害2,病害3,病害4,,1,2,3,4,总扣分值,,,,,,

,构件1,25,,,,1,25.00,0.00,0.00,0.00,25.00,75.00,4,66.67,77.35,9,41.16

,构件2,50,25,,,2,50.00,8.84,0.00,0.00,58.84,41.16,1,16.67,,,

,构件3,45,,,,1,45.00,0.00,0.00,0.00,45.00,55.00,1,16.67,,对应t值,

,构件4,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,8.300,

,构件5,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,,

,,,,,,,,,,,,,,,,,,

上部结构,2、一般构件,,,该部件若不存在则整个表格不输入,若存在且无病害,在后端输入“1”——>,,,,,,,,,,<——,,,

,部件技术评定,病害检测指标扣分值,,,,病害数,扣分,,,,,构件最终得分,同类病害构件数,比例(%),平均得分,构件总数数n,部件得分

,,病害1,病害2,病害3,病害4,,1,2,3,4,总扣分值,,,,,,

,构件1,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,#DIV/0!,,#NUM!

,构件2,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,,

,构件3,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,对应t值,

,构件4,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,#N/A,

,构件5,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,,

,,,,,,,,,,,,,,,,,,

上部结构,3、支座,,,该部件若不存在则整个表格不输入,若存在且无病害,在后端输入“1”——>,,,,,,,,,,<——,,,

,部件技术评定,病害检测指标扣分值,,,,病害数,扣分,,,,,构件最终得分,同类病害构件数,比例(%),平均得分,构件总数数n,部件得分

,,病害1,病害2,病害3,病害4,,1,2,3,4,总扣分值,,,,,,

,构件1,35,,,,1,35.00,0.00,0.00,0.00,35.00,65.00,12,200.00,94.17,72,84.22

,构件2,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,,

,构件3,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,对应t值,

,构件4,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,3.520,

,构件5,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,,

,,,,,,,,,,,,,,,,,,

下部结构,4、翼墙、耳墙,,,该部件若不存在则整个表格不输入,若存在且无病害,在后端输入“1”——>,,,,,,,,,,<——,,,

,部件技术评定,病害检测指标扣分值,,,,病害数,扣分,,,,,构件最终得分,同类病害构件数,比例(%),平均得分,构件总数数n,部件得分

,,病害1,病害2,病害3,病害4,,1,2,3,4,总扣分值,,,,,,

,构件1,25,,,,1,25.00,0.00,0.00,0.00,25.00,75.00,1,16.67,93.75,4,91.12

,构件2,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,,

,构件3,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,对应t值,

,构件4,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,9.500,

,构件5,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,,

,,,,,,,,,,,,,,,,,,

下部结构,5、锥坡、护坡,,,该部件若不存在则整个表格不输入,若存在且无病害,在后端输入“1”——>,,,,,,,,,,<——,,,

,部件技术评定,病害检测指标扣分值,,,,病害数,扣分,,,,,构件最终得分,同类病害构件数,比例(%),平均得分,构件总数数n,部件得分

,,病害1,病害2,病害3,病害4,,1,2,3,4,总扣分值,,,,,,

,构件1,25,,,,1,25.00,0.00,0.00,0.00,25.00,75.00,1,16.67,93.75,4,91.12

,构件2,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,,

,构件3,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,对应t值,

,构件4,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,9.500,

,构件5,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,,

,,,,,,,,,,,,,,,,,,

下部结构,6、桥墩,,,该部件若不存在则整个表格不输入,若存在且无病害,在后端输入“1”——>,,,,,,,,,,<——,,,

,部件技术评定,病害检测指标扣分值,,,,病害数,扣分,,,,,构件最终得分,同类病害构件数,比例(%),平均得分,构件总数数n,部件得分

,,病害1,病害2,病害3,病害4,,1,2,3,4,总扣分值,,,,,,

,构件1,25,,,,1,25.00,0.00,0.00,0.00,25.00,75.00,2,33.33,91.67,6,88.86

,构件2,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,,

,构件3,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,对应t值,

,构件4,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,8.900,

,构件5,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,,

,,,,,,,,,,,,,,,,,,

下部结构,7、桥台,,,该部件若不存在则整个表格不输入,若存在且无病害,在后端输入“1”——>,,,,,,,,,,<——,,,

,部件技术评定,病害检测指标扣分值,,,,病害数,扣分,,,,,构件最终得分,同类病害构件数,比例(%),平均得分,构件总数数n,部件得分

,,病害1,病害2,病害3,病害4,,1,2,3,4,总扣分值,,,,,,

,构件1,25,,,,1,25.00,0.00,0.00,0.00,25.00,75.00,4,66.67,83.33,6,80.52

,构件2,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,,

,构件3,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,对应t值,

,构件4,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,8.900,

,构件5,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,,

,,,,,,,,,,,,,,,,,,

下部结构,8、墩台基础,,,该部件若不存在则整个表格不输入,若存在且无病害,在后端输入“1”——>,,,,,,,,,1,<——,,,

,部件技术评定,病害检测指标扣分值,,,,病害数,扣分,,,,,构件最终得分,同类病害构件数,比例(%),平均得分,构件总数数n,部件得分

,,病害1,病害2,病害3,病害4,,1,2,3,4,总扣分值,,,,,,

,构件1,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,#DIV/0!,,100.00

,构件2,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,,

,构件3,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,对应t值,

,构件4,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,#N/A,

,构件5,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,,

,,,,,,,,,,,,,,,,,,

下部结构,9、河床,,,该部件若不存在则整个表格不输入,若存在且无病害,在后端输入“1”——>,,,,,,,,,,<——,,,

,部件技术评定,病害检测指标扣分值,,,,病害数,扣分,,,,,构件最终得分,同类病害构件数,比例(%),平均得分,构件总数数n,部件得分

,,病害1,病害2,病害3,病害4,,1,2,3,4,总扣分值,,,,,,

,构件1,25,,,,1,25.00,0.00,0.00,0.00,25.00,75.00,1,16.67,91.67,3,89.09

,构件2,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,,

,构件3,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,对应t值,

,构件4,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,9.700,

,构件5,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,,

,,,,,,,,,,,,,,,,,,

下部结构,10、调治构造物,,,该部件若不存在则整个表格不输入,若存在且无病害,在后端输入“1”——>,,,,,,,,,,<——,,,

,部件技术评定,病害检测指标扣分值,,,,病害数,扣分,,,,,构件最终得分,同类病害构件数,比例(%),平均得分,构件总数数n,部件得分

,,病害1,病害2,病害3,病害4,,1,2,3,4,总扣分值,,,,,,

,构件1,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,#DIV/0!,,#NUM!

,构件2,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,,

,构件3,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,对应t值,

,构件4,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,#N/A,

,构件5,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,,

,,,,,,,,,,,,,,,,,,

桥面系,11、桥面铺装,,,该部件若不存在则整个表格不输入,若存在且无病害,在后端输入“1”——>,,,,,,,,,,<——,,,

,部件技术评定,病害检测指标扣分值,,,,病害数,扣分,,,,,构件最终得分,同类病害构件数,比例(%),平均得分,构件总数数n,部件得分

,,病害1,病害2,病害3,病害4,,1,2,3,4,总扣分值,,,,,,

,构件1,25,,,,1,25.00,0.00,0.00,0.00,25.00,75.00,4,66.67,83.33,6,80.52

,构件2,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,,

,构件3,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,对应t值,

,构件4,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,8.900,

,构件5,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,,

,,,,,,,,,,,,,,,,,,

桥面系,12、伸缩缝装置,,,该部件若不存在则整个表格不输入,若存在且无病害,在后端输入“1”——>,,,,,,,,,,<——,,,

,部件技术评定,病害检测指标扣分值,,,,病害数,扣分,,,,,构件最终得分,同类病害构件数,比例(%),平均得分,构件总数数n,部件得分

,,病害1,病害2,病害3,病害4,,1,2,3,4,总扣分值,,,,,,

,构件1,25,25,,,2,25.00,13.26,0.00,0.00,38.26,61.74,1,16.67,68.37,2,64.55

,构件2,25,,,,1,25.00,0.00,0.00,0.00,25.00,75.00,1,16.67,,,

,构件3,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,对应t值,

,构件4,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,10.000,

,构件5,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,,

,,,,,,,,,,,,,,,,,,

桥面系,13、人行道,,,该部件若不存在则整个表格不输入,若存在且无病害,在后端输入“1”——>,,,,,,,,,,<——,,,

,部件技术评定,病害检测指标扣分值,,,,病害数,扣分,,,,,构件最终得分,同类病害构件数,比例(%),平均得分,构件总数数n,部件得分

,,病害1,病害2,病害3,病害4,,1,2,3,4,总扣分值,,,,,,

,构件1,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,#DIV/0!,,#NUM!

,构件2,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,,

,构件3,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,对应t值,

,构件4,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,#N/A,

,构件5,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,,

,,,,,,,,,,,,,,,,,,

桥面系,14、栏杆、护栏,,,该部件若不存在则整个表格不输入,若存在且无病害,在后端输入“1”——>,,,,,,,,,,<——,,,

,部件技术评定,病害检测指标扣分值,,,,病害数,扣分,,,,,构件最终得分,同类病害构件数,比例(%),平均得分,构件总数数n,部件得分

,,病害1,病害2,病害3,病害4,,1,2,3,4,总扣分值,,,,,,

,构件1,25,,,,1,25.00,0.00,0.00,0.00,25.00,75.00,2,33.33,87.50,6,84.69

,构件2,25,,,,1,25.00,0.00,0.00,0.00,25.00,75.00,1,16.67,,,

,构件3,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,对应t值,

,构件4,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,8.900,

,构件5,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,,

,,,,,,,,,,,,,,,,,,

桥面系,15、防、排水系统,,,该部件若不存在则整个表格不输入,若存在且无病害,在后端输入“1”——>,,,,,,,,,,<——,,,

,部件技术评定,病害检测指标扣分值,,,,病害数,扣分,,,,,构件最终得分,同类病害构件数,比例(%),平均得分,构件总数数n,部件得分

,,病害1,病害2,病害3,病害4,,1,2,3,4,总扣分值,,,,,,

,构件1,25,,,,1,25.00,0.00,0.00,0.00,25.00,75.00,4,66.67,91.67,12,88.42

,构件2,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,,

,构件3,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,对应t值,

,构件4,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,7.700,

,构件5,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,,

,,,,,,,,,,,,,,,,,,

桥面系,16、照明、标志,,,该部件若不存在则整个表格不输入,若存在且无病害,在后端输入“1”——>,,,,,,,,,,<——,,,

,部件技术评定,病害检测指标扣分值,,,,病害数,扣分,,,,,构件最终得分,同类病害构件数,比例(%),平均得分,构件总数数n,部件得分

,,病害1,病害2,病害3,病害4,,1,2,3,4,总扣分值,,,,,,

,构件1,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,#DIV/0!,,#NUM!

,构件2,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,,

,构件3,,,,,0,0.00,0.00,0.00,0.00,0.00,0.00,,0.00,,对应t值,

,构件4,,,,,0,0.00,0.00,0.00,0.00,0.0

温馨提示

  • 1. 本站所有资源如无特殊说明,都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
  • 2. 本站的文档不包含任何第三方提供的附件图纸等,如果需要附件,请联系上传者。文件的所有权益归上传用户所有。
  • 3. 本站RAR压缩包中若带图纸,网页内容里面会有图纸预览,若没有图纸预览就没有图纸。
  • 4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
  • 5. 人人文库网仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对用户上传分享的文档内容本身不做任何修改或编辑,并不能对任何下载内容负责。
  • 6. 下载文件中如有侵权或不适当内容,请与我们联系,我们立即纠正。
  • 7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。

评论

0/150

提交评论