混凝土抗压强度统计评定表(excel自动计算)

水泥混凝土抗压强度统计评定表 工程 路基工程安全技术交底工程项目施工成本控制工程量增项单年度零星工程技术标正投影法基本原理 名称：分项（部）名称：五层施工单位：共页，第页部位砼方量（m³）浇筑台班（个）养护 方法 快递客服问题件处理详细方法山木方法pdf计算方法pdf华与华方法下载八字理论方法下载 试块组数抗折强度（MPa）合格判定系数计算数据（MPa）设计强度平均值均方差最小值nFcu•kMfcuSfcuFcu•minλ1λ20.9Fcu•k0.95Fcu•k1.15Fcu•kMfcu－λ1•Sfcuλ2•Fcu•k4C5053.5048.247.557.5每组强度值Fcu•i（MPa）1234567891011121314151617181920123456789101112131415161718192056.260.948.248.73158.443708.812323.242371.690000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000按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汇总计算人：校核人：项目技术负责人：填报日期：水泥混凝土抗压强度统计评定表工程名称：分项（部）名称：2#3#4#天面层施工单位：共页，第页部位砼方量（m³）浇筑台班（个）养护方法试块组数抗折强度（MPa）合格判定系数计算数据（MPa）设计强度平均值均方差最小值nFcu•kMfcuSfcuFcu•minλ1λ20.9Fcu•k0.95Fcu•k1.15Fcu•kMfcu－λ1•Sfcuλ2•Fcu•k12C3050.983.189471.700.902745.55427每组强度值Fcu•i（MPa）1234567891011121314151617181920123456789101112131415161718192049.548.552.751.653.955.247.747.452.74749.256.32450.252352.252777.292662.562905.213047.042275.292246.762777.2922092420.643169.6900000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000按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汇总计算人：校核人：项目技术负责人：填报日期：水泥混凝土抗压强度统计评定表工程名称：分项（部）名称：基础施工单位：共页，第页桩号部位砼方量（m³）浇筑台班（个）养护方法试块组数抗折强度（MPa）合格判定系数计算数据（MPa）设计强度平均值均方差最小值nFcu•kMfcuSfcuFcu•minλ1λ20.9Fcu•k0.95Fcu•k1.15Fcu•kMfcu－λ1•Sfcuλ2•Fcu•k4C3550.55048.333.2540.25每组强度值Fcu•i（MPa）1234567891011121314151617181920123456789101112131415161718192048.351.151.351.52332.892611.212631.692652.250000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000按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汇总计算人：校核人：项目技术负责人：填报日期：水泥混凝土抗压强度统计评定表工程名称：分项（部）名称：基础施工单位：共页，第页桩号部位砼方量（m³）浇筑台班（个）养护方法试块组数抗折强度（MPa）合格判定系数计算数据（MPa）设计强度平均值均方差最小值nFcu•kMfcuSfcuFcu•minλ1λ20.9Fcu•k0.95Fcu•k1.15Fcu•kMfcu－λ1•Sfcuλ2•Fcu•k11C4057.5275.185481.700.903648.71336每组强度值Fcu•i（MPa）1234567891011121314151617181920123456789101112131415161718192061.75863.853.754.653.566.359.356.34857.63806.8933644070.442883.692981.162862.254395.693516.493169.6923043317.76000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000按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汇总计算人：校核人：项目技术负责人：填报日期：水泥混凝土抗压强度统计评定表工程名称：分项（部）名称：施工单位：共页，第页桩号部位砼方量（m³）浇筑台班（个）养护方法试块组数抗折强度（MPa）合格判定系数计算数据（MPa）设计强度平均值均方差最小值nFcu•kMfcuSfcuFcu•minλ1λ20.9Fcu•k0.95Fcu•k1.15Fcu•kMfcu－λ1•Sfcuλ2•Fcu•k30C3537.5001.737351.600.8531.534.72129.75每组强度值Fcu•i（MPa）1234567891011121314151617181920123456789101112131415161718192000000000000000000000353637383940000001225129613691444152116000000000003536373839400000012251296136914441521160000000000035363738394000000122512961369144415211600000000000353637383940000001225129613691444152116000000000003536373839400000012251296136914441521160000000000000000000000000000000按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汇总计算人：校核人：项目技术负责人：填报日期：合格不合格IF(AND(Q8>=K8,G8>=T8),"合格","不合格")IF(AND(E8>=O8,G8>=M8),"合格","不合格")合格IF(E18="统计法",D26,K26)IF(E18="统计法",IF(AND(Q8>=K8,G8>=T8),"合格","不合格"),IF(AND(E8>=O8,G8>=M8),"合格","不合格"))