砼试块抗压强度统计评定表(excel自动计算)

水泥混凝土试块抗压强度统计评定表单位工程名称：一、盘龙山塘综合整治工程分项（部）名称：护坡工程施工单位：金华市成泰水利建设有限公司共2页，第1页部位坝体C20砼砼方量（m³）170.5浇筑台班（个）1.15Fcu•k养护方法标养试块组数抗压强度（MPa）合格判定系数计算数据（MPa）设计强度平均值均方差最小值nFcu•kMfcuSfcuFcu•minλ1λ20.9Fcu•k0.95Fcu•k1.15Fcu•kMfcu－λ1•Sfcuλ2•Fcu•k4C2023.401.40022.61923每组强度值Fcu•i（MPa）1234567891011121314151617181920123456789101112131415161718192022.722.624.322.40000515.29510.76590.49501.76000000000000000024.122.923.723.9580.81524.41561.69571.21000000000000000024.423.422.723.7595.36547.56515.29561.69000000000000000023.7333333322.9666666723.5666666723.3333333323.4563.2711111527.4677778555.3877778544.4444444547.56000000000000000000000000000000000000000000000000000000000000000000000000000按GBJ107规定公式计算评定：非统计法合格判定系数n10-1415-24≥25评定结论合格1、统计方法：n≥10组时，Mfcu－λ1•Sfcu≥0.9Fcu•k；Fcu•min≥λ2•Fcuk。λ11.701.651.602、非统计方法：n<10组时，Mfcu≥1.15Fcu•k；Fcu•min≥0.95Fcu•k。λ20.900.85汇总计算人：校核人：项目技术负责人：填报日期：2015.01.30水泥混凝土试块抗压强度统计评定表单位工程名称：二、兰田山塘综合整治工程分项（部）名称：护坡工程施工单位：金华市成泰水利建设有限公司共3页，第2页部位坝体C20砼砼方量（m³）浇筑台班（个）1.15Fcu•k养护方法标养试块组数抗压强度（MPa）合格判定系数计算数据（MPa）设计强度平均值均方差最小值nFcu•kMfcuSfcuFcu•minλ1λ20.9Fcu•k0.95Fcu•k1.15Fcu•kMfcu－λ1•Sfcuλ2•Fcu•k6C2023.601.30022.31923每组强度值Fcu•i（MPa）123456789101112131415161718192012345678910111213141516171819202323.323.123.824.924.4000000529542.89533.61566.44620.01595.360000000000000024.223.623.223.322.825.2585.64556.96538.24542.89519.84635.040000000000000023.922.724.122.323.923571.21515.29580.81497.29571.215290000000000000023.723.223.4666666723.1333333323.8666666724.223.59444444561.69538.24550.6844444535.1511111569.6177778585.64556.697808600000000000000000000000000000000000000000000000000000按GBJ107规定公式计算评定：非统计法合格判定系数n10-1415-24≥25评定结论合格1、统计方法：n≥10组时，Mfcu－λ1•Sfcu≥0.9Fcu•k；Fcu•min≥λ2•Fcuk。λ11.701.651.602、非统计方法：n<10组时，Mfcu≥1.15Fcu•k；Fcu•min≥0.95Fcu•k。λ20.900.85汇总计算人：校核人：项目技术负责人：填报日期：2015.01.30水泥混凝土试块抗压强度统计评定表单位工程名称：三、小仰下山塘综合整治工程分项（部）名称：护坡工程施工单位：金华市成泰水利建设有限公司共3页，第2页部位坝体C20砼砼方量（m³）浇筑台班（个）1.15Fcu•k养护方法标养试块组数抗压强度（MPa）合格判定系数计算数据（MPa）设计强度平均值均方差最小值nFcu•kMfcuSfcuFcu•minλ1λ20.9Fcu•k0.95Fcu•k1.15Fcu•kMfcu－λ1•Sfcuλ2•Fcu•k5C2023.500.60022.91923每组强度值Fcu•i（MPa）1234567891011121314151617181920123456789101112131415161718192022.923.62323.323.1000524.41556.96529542.89533.610000000000000002423.222.923.623.6576538.24524.41556.96556.9600000000000000023.223.823.923.524.3538.24566.44571.21552.25590.4900000000000000023.3666666723.5333333323.2666666723.4666666723.6666666723.46546.0011111553.8177778541.3377778550.6844444560.1111111550.3716000000000000000000000000000000000000000000000000000000按GBJ107规定公式计算评定：非统计法合格判定系数n10-1415-24≥25评定结论合格1、统计方法：n≥10组时，Mfcu－λ1•Sfcu≥0.9Fcu•k；Fcu•min≥λ2•Fcuk。λ11.701.651.602、非统计方法：n<10组时，Mfcu≥1.15Fcu•k；Fcu•min≥0.95Fcu•k。λ20.900.85汇总计算人：校核人：项目技术负责人：填报日期：2015.01.30水泥混凝土试块抗压强度统计评定表单位工程名称：四、千岙山塘综合整治工程分项（部）名称：护坡工程施工单位：金华市成泰水利建设有限公司共3页，第2页部位坝体C20砼砼方量（m³）浇筑台班（个）1.15Fcu•k养护方法标养试块组数抗压强度（MPa）合格判定系数计算数据（MPa）设计强度平均值均方差最小值nFcu•kMfcuSfcuFcu•minλ1λ20.9Fcu•k0.95Fcu•k1.15Fcu•kMfcu－λ1•Sfcuλ2•Fcu•k6C2023.601.20022.41923每组强度值Fcu•i（MPa）1234567891011121314151617181920123456789101112131415161718192022.923.523.425.425.222.500524.41552.25547.56645.16635.04506.250000000000000024.222.423.123.124.123585.64501.76533.61533.61580.815290000000000000024.523.82422.723.123.8600.25566.44576515.29533.61566.440000000000000023.8666666723.2333333323.523.7333333324.1333333323.123.59444444569.6177778539.7877778552.25563.2711111582.4177778533.61556.697808600000000000000000000000000000000000000000000000000000按GBJ107规定公式计算评定：非统计法合格判定系数n10-1415-24≥25评定结论合格1、统计方法：n≥10组时，Mfcu－λ1•Sfcu≥0.9Fcu•k；Fcu•min≥λ2•Fcuk。λ11.701.651.602、非统计方法：n<10组时，Mfcu≥1.15Fcu•k；Fcu•min≥0.95Fcu•k。λ20.900.85汇总计算人：校核人：项目技术负责人：填报日期：2015.01.30水泥混凝土试块抗压强度统计评定表单位工程名称：五、西岙山塘综合整治工程分项（部）名称：护坡工程施工单位：金华市成泰水利建设有限公司共2页，第1页部位坝体C20砼砼方量（m³）浇筑台班（个）1.15Fcu•k养护方法标养试块组数抗压强度（MPa）合格判定系数计算数据（MPa）设计强度平均值均方差最小值nFcu•kMfcuSfcuFcu•minλ1λ20.9Fcu•k0.95Fcu•k1.15Fcu•kMfcu－λ1•Sfcuλ2•Fcu•k7C2022.703.10019.61923每组强度值Fcu•i（MPa）1234567891011121314151617181920123456789101112131415161718192023.222.822.320.423.423.923.60538.24519.84497.29416.16547.56571.21556.96000000000000024.323.421.222.425.123.222.4590.49547.56449.44501.76630.01538.24501.76000000000000022.621.419.620.72324.723.8510.76457.96384.16428.49529610.09566.44000000000000023.3666666722.5333333321.0333333321.1666666723.8333333323.9333333323.2666666722.73333333546.0011111507.7511111442.4011111448.0277778568.0277778572.8044444541.3377778516.80444440000000000000000000000000000000000000000000000000000按GBJ107规定公式计算评定：非统计法合格判定系数n10-1415-24≥25评定结论合格1、统计方法：n≥10组时，Mfcu－λ1•Sfcu≥0.9Fcu•k；Fcu•min≥λ2•Fcuk。λ11.701.651.602、非统计方法：n<10组时，Mfcu≥1.15Fcu•k；Fcu•min≥0.95Fcu•k。λ20.900.85汇总计算人：校核人：项目技术负责人：填报日期：2015.01.30水泥混凝土试块抗压强度统计评定表单位工程名称：六、肖坑山塘综合整治工程分项（部）名称：护坡工程施工单位：金华市成泰水利建设有限公司共3页，第3页部位护坡C20砼砼方量（m³）浇筑台班（个）1.15Fcu•k养护方法标养试块组数抗压强度（MPa）合格判定系数计算数据（MPa）设计强度平均值均方差最小值nFcu•kMfcuSfcuFcu•minλ1λ20.9Fcu•k0.95Fcu•k1.15Fcu•kMfcu－λ1•Sfcuλ2•Fcu•k9C2023.202.00021.21923每组强度值Fcu•i（MPa）1234567891011121314151617181920123456789101112131415161718192024.923.621.42321.923.525.222.522.7620.01556.96457.96529479.61552.25635.04506.25515.290000000000022.824.221.921.223.223.622.823.123.5519.84585.64479.61449.44538.24556.96519.84533.61552.250000000000023.522.623.223.722.62323.423.924.2552.25510.76538.24561.69510.76529547.56571.21585.640000000000023.7333333323.4666666722.1666666722.6333333322.5666666723.3666666723.823.1666666723.4666666723.15185185563.2711111550.6844444491.3611111512.2677778509.2544444546.0011111566.44536.6944444550.6844444536.008244200000000000000000000000000000000000000000000000000按GBJ107规定公式计算评定：非统计法合格判定系数n10-1415-24≥25评定结论合格1、统计方法：n≥10组时，Mfcu－λ1•Sfcu≥0.9Fcu•k；Fcu•min≥λ2•Fcuk。λ11.701.651.602、非统计方法：n<10组时，Mfcu≥1.15Fcu•k；Fcu•min≥0.95Fcu•k。λ20.900.85汇总计算人：校核人：项目技术负责人：填报日期：2015.01.30