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

分项（部）名称：共页，第页部位平均值均方差nMfcuSfcuλ1λ238C2532.572.7661.600.851234567891011121314151617181920135.834.631.531.436.635.835.934.436.233.933.435.428.427.933.733.93433.631.628.9128234.234.834.130.930.637.334.6312729.832.13234.331.728.927.330.230.1117000000按GBJ107规定公式计算评定：n10-1415-24≥25λ11.701.651.60λ20.90汇总计算人：校核人：项目技术负责人：填报日期：施工单位：浇筑台班（个）水泥混凝土抗压强度统计评定表五层养护方法工程名称：试块组数抗折强度（MPa）合格判定系数计算数据（MPa）设计强度最小值Mfcu－λ1•Sfcuλ2•Fcu•kFcu•kFcu•min0.9Fcu•k砼方量（m³）2722.50.95Fcu•k1.15Fcu•k28.14821.25每组强度值Fcu•i（MPa）统计法合格判定系数评定结论合格1、统计方法：n≥10组时，Mfcu－λ1•Sfcu≥0.9Fcu•k；Fcu•min≥λ2•Fcuk。2、非统计方法：n10组时，Mfcu≥1.15Fcu•k；Fcu•min≥0.95Fcu•k。0.85分项（部）名称：共页，第页部位平均值均方差nMfcuSfcuλ1λ212C3036.733.6851.700.901234567891011121314151617181920141.437.732.930.13534.943.93937.437.136.834.61714000000按GBJ107规定公式计算评定：n10-1415-24≥25λ11.701.651.60λ20.90每组强度值Fcu•i（MPa）统计法合格判定系数评定结论合格1、统计方法：n≥10组时，Mfcu－λ1•Sfcu≥0.9Fcu•k；Fcu•min≥λ2•Fcuk。2、非统计方法：n10组时，Mfcu≥1.15Fcu•k；Fcu•min≥0.95Fcu•k。0.850.95Fcu•k1.15Fcu•kMfcu－λ1•Sfcuλ2•Fcu•k30.12730.46827Fcu•kFcu•min0.9Fcu•k砼方量（m³）试块组数抗折强度（MPa）合格判定系数计算数据（MPa）设计强度最小值浇筑台班（个）水泥混凝土抗压强度统计评定表2#3#4#天面层养护方法施工单位：工程名称：汇总计算人：校核人：项目技术负责人：填报日期：2345678910111213141516171819201197992986134012821289118313101149111612538077781136114911561129999835121111639559361391119796172988810301024117610058357459129060000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000234567891011121314151617181920142110829061225121819271521139913761354119700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000工程名称：分项（部）名称：施工单位：桩号部位平均值均方差nMfcuSfcuλ1λ24C3550.5501234567891011121314151648.351.151.351.5按GBJ107规定公式计算评定：n10-1415-24≥25λ11.701.651.60λ20.9040.250.95Fcu•k1.15Fcu•kMfcu－λ1•SfcuFcu•min48.3Fcu•k0.9Fcu•k33.25水泥混凝土抗压强度统计评定表设计强度最小值试块组数抗折强度（MPa）基础每组强度值Fcu•i（MPa）砼方量（m³）浇筑台班（个）养护方法计算数据（MPa）合格判定系数0.85评定结论1、统计方法：n≥10组时，Mfcu－λ1•Sfcu≥0.9Fcu•k；Fcu•min≥λ2•Fcuk。2、非统计方法：n10组时，Mfcu≥1.15Fcu•k；Fcu•min≥0.95Fcu•k。合格判定系数非统计法汇总计算人：校核人：项目技术负责人：填报日期：工程名称：分项（部）名称：施工单位：桩号部位平均值均方差nMfcuSfcuλ1λ211C4057.5275.1851.700.901234567891011121314151661.75863.853.754.653.566.359.356.34857.6按GBJ107规定公式计算评定：n10-1415-24≥25每组强度值Fcu•i（MPa）统计法合格判定系数评定结论1.15Fcu•kMfcu－λ1•Sfcu483648.713Fcu•kFcu•min0.9Fcu•k砼方量（m³）0.95Fcu•k试块组数抗折强度（MPa）合格判定系数计算数据（MPa）设计强度最小值浇筑台班（个）水泥混凝土抗压强度统计评定表基础养护方法λ11.701.651.60λ20.90汇总计算人：校核人：项目技术负责人：填报日期：合格判定系数评定结论1、统计方法：n≥10组时，Mfcu－λ1•Sfcu≥0.9Fcu•k；Fcu•min≥λ2•Fcuk。2、非统计方法：n10组时，Mfcu≥1.15Fcu•k；Fcu•min≥0.95Fcu•k。0.85共页，第页171819201234567892332.892611.212631.692652.2500000000000000000000000000000000000000000000000000000000000λ2•Fcu•kMfcu－λ1•Sfcu水泥混凝土抗压强度统计评定表每组强度值Fcu•i（MPa）养护方法计算数据（MPa）合格填报日期：共页，第页171819201234567893806.8933644070.442883.692981.162862.254395.693516.493169.69000000000000000000000000000000000000000000000000000000每组强度值Fcu•i（MPa）合格Mfcu－λ1•Sfcuλ2•Fcu•k48.71336计算数据（MPa）水泥混凝土抗压强度统计评定表养护方法填报日期：合格101112131415161718192000000000000000000000000000000000000000000000000000000000000000000000000000000101112131415161718192023043317.76000000000000000000000000000000000000000000000000000000000000000000000000000工程名称：分项（部）名称：施工单位：桩号部位平均值均方差nMfcuSfcuλ1λ230C3537.5001.7371.600.8512345678910111213141516353637383940353637383940353637383940353637383940353637383940按GBJ107规定公式计算评定：n10-1415-24≥25λ11.701.651.60λ20.90计算数据（MPa）合格判定系数0.85评定结论1、统计方法：n≥10组时，Mfcu－λ1•Sfcu≥0.9Fcu•k；Fcu•min≥λ2•Fcuk。2、非统计方法：n10组时，Mfcu≥1.15Fcu•k；Fcu•min≥0.95Fcu•k。合格判定系数统计法每组强度值Fcu•i（MPa）砼方量（m³）浇筑台班（个）养护方法Fcu•min35Fcu•k0.9Fcu•k31.5水泥混凝土抗压强度统计评定表设计强度最小值试块组数抗折强度（MPa）34.7210.95Fcu•k1.15Fcu•kMfcu－λ1•Sfcu汇总计算人：校核人：项目技术负责人：填报日期：合格不合格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),合格,不合格))共页，第页17181920123456789000000000000001225129613691444000001225129613691444000001225129613691444000001225129613691444000001225129613691444000000000计算数据（MPa）合格每组强度值Fcu•i（MPa）养护方法水泥混凝土抗压强度统计评定表34.721λ2•Fcu•kMfcu－λ1•Sfcu29.75填报日期：IF(E18=统计法,IF(AND(Q8=K8,G8=T8),合格,不合格),IF(AND(E8=O8,G8=M8),合格,不合格))101112131415161718192000000000000152116000000000001521160000000000015211600000000000152116000000000001521160000000000000000000000