路基、路面压实度评定EXCEL自动计算表

1、路路基基、路路面面压压实实度度评评定定表表 评定编号：2016-071/1-0001施工单位合 同 号监理单位工程部位试验项目路段桩号试验单位保 证 率99测点位置压实度(%)试验编号备注桩号横距(m)98.0097.0096.0097.0098.0099.0096.0095.0095.0095.0095.0095.0095.0095.0095.0095.0095.0095.0095.0095.0095.0095.0095.0095.0095.0095.0095.00测点数 (点) 频率 (点/100m)标准值(%) 规定值(%)规定极值(%)代表值(%)得分10196.30 结论： 评定人：

2、 复核人：技术负责人：第 1 / 4 页路路基基、路路面面压压实实度度评评定定表表0 评定编号：2016-071/1-0001施工单位0合 同 号0监理单位0工程部位0试验项目灌砂法测定压实度试验路段桩号0试验单位0保 证 率99测点位置压实度(%)试验编号备注桩号横距(m)96.5096.5096.5096.5096.5096.5096.5096.5096.5096.5096.5096.5096.5096.5096.5096.5096.5096.5096.5096.5096.5096.5096.5096.5096.5096.5096.50测点数 (点) 频率 (点/100m)标准值(%) 规

3、定值(%)规定极值(%)代表值(%)得分10196.30 结论： 评定人： 复核人：技术负责人：第 2 / 4 页路路基基、路路面面压压实实度度评评定定表表0 评定编号：2016-071/1-0001施工单位0合 同 号0监理单位0工程部位0试验项目灌砂法测定压实度试验路段桩号0试验单位0保 证 率99测点位置压实度(%)试验编号备注桩号横距(m)96.5097.5096.5097.5096.5097.5096.5097.5096.5097.5096.5097.5096.5097.5096.5097.5096.5097.5096.5097.5096.5097.5096.5097.5096.50

4、97.5097.50测点数 (点) 频率 (点/100m)标准值(%) 规定值(%)规定极值(%)代表值(%)得分10196.30 结论： 评定人： 复核人：技术负责人：第 3 / 4 页路路基基、路路面面压压实实度度评评定定表表0 评定编号：2016-071/1-0001施工单位0合 同 号0监理单位0工程部位0试验项目灌砂法测定压实度试验路段桩号0试验单位0保 证 率99测点位置压实度(%)试验编号备注桩号横距(m)96.5097.5096.5097.5096.5097.5096.5097.5096.5097.5096.5097.5096.5097.5096.5097.5096.5097.

5、5096.5097.50测点数 (点) 频率 (点/100m)标准值(%) 规定值(%)规定极值(%)代表值(%)得分10196.30 结论： 评定人： 复核人：技术负责人：第 4 / 4 页路路基基、路路面面压压实实度度评评定定表表0 评定编号：2016-071/1-0001施工单位0合 同 号0监理单位0工程部位0试验项目灌砂法测定压实度试验路段桩号0试验单位0保 证 率99测点位置压实度(%)试验编号备注桩号横距(m)测点数 (点) 频率 (点/100m)标准值(%) 规定值(%)规定极值(%)代表值(%)得分10196.30 结论： 评定人： 复核人：技术负责人：第 5 / 4 页压压

6、 实实 度度 结结 果果 评评 定定 表表输入压实度结果标准差0.898596398.0096.5096.5096.50平均值96.4950597.0096.5097.5097.50检测点数10196.0096.5096.5096.50保证率990.23697.0096.5097.5097.50保证率950.16698.0096.5096.5096.50保证率900.12999.0096.5097.5097.509096.496.0096.5096.5096.509596.395.0096.5097.5097.509996.395.0096.5096.5096.50900.23195.0096

7、.5097.5097.50950.16495.0096.5096.5096.50990.12895.0096.5097.5097.509096.395.0096.5096.5096.509596.395.0096.5097.5097.509996.495.0096.5096.5096.5095.0096.5097.5097.5095.0096.5096.5096.5095.0096.5097.5097.5095.0096.5096.5096.5095.0096.5097.5097.5095.0096.5096.5095.0096.5097.5095.0096.5096.5095.0096.50

8、97.5095.0096.5096.5095.0096.5097.5095.0096.5097.50评定结果评定结果选择保证率系数(99,95,90)选择保证率系数(99,95,90)95平均值平均值96.596.50标准差标准差0.8990.899检测点数检测点数101101代表值代表值96.396.30如果检测点数大于100平均值96.50标准差0.899检测点数101代表值96.3压压 实实 度度 结结 果果 评评 定定 表表输入压实度结果保证系数检测点数99检测点数95检测点数222.50124.465234.02131.686342.27141.177451.67650.953561

9、.37460.823671.18870.734781.0680.67890.96690.629100.892100.5810110.833110.54611120.785120.51812130.744130.49413140.708140.47314150.678150.45515160.651160.438316170.626170.42317180.605180.4118190.586190.39819200.568200.38720210.552210.37621220.537220.36722230.523230.35823240.51240.3524250.498250.34225

10、260.487260.33526270.477270.32827280.467280.32228290.458290.31629300.449300.3130310.442310.30631320.436320.30132330.429330.29733340.423340.29234350.416350.28835360.409360.28436370.403370.27937380.396380.27538390.390390.27039400.383400.26640410.379410.26341420.374420.26042430.370430.25743440.366440.25

11、444450.362450.25245460.357460.24946470.353470.24647480.349480.24348490.344490.24049500.34500.23750510.337510.23551520.334520.23352530.330530.23153540.327540.22954550.324550.22755560.321560.22456570.318570.22257580.314580.22058590.311590.21859600.308600.21660610.306610.21461620.303620.21362630.301630

12、.21163640.299640.20964650.297650.20865660.294660.20666670.292670.20467680.290680.20268690.287690.20169700.285700.19970710.283710.19871720.281720.19672730.279730.19573740.277740.19474750.276750.19375760.274760.19176770.272770.19077780.270780.18978790.268790.18779800.266800.18680810.264810.18581820.26

13、3820.18482830.261830.18383840.259840.18284850.258850.18185860.256860.17986870.254870.17887880.252880.17788890.251890.17689900.249900.17590910.248910.17491920.246920.17392930.245930.17293940.244940.17194950.243950.17195960.241960.17096970.240970.16997980.239980.16898990.237990.167991000.2361000.16610

14、0大于1000.231大于1000.164大于10090201761.0890.8190.6860.6030.5440.50.4660.4370.4140.3930.3760.3610.3470.3350.3240.3140.3050.29730.2890.2820.2750.2690.2640.2580.2530.2480.2440.2390.2360.2320.2290.2260.2230.2190.2160.2130.2090.2060.2040.2020.1990.1970.1950.1930.191保证系数0.1880.1860.1840.1820.1810.1790.1770.1760.1740.17