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

分项（部）名称：共页，第页部位平均值均方差nMfcuSfcuλ1λ26C3057.051234567891011121314151617181920156.357.757.556.857.456.63170000000按GBJ107规定公式计算评定：n10-1415-19≥20λ11.151.050.95λ20.90汇总计算人：校核人：项目技术负责人：填报日期：每组强度值Fcu•i（MPa）非统计法合格判定系数评定结论合格1、统计方法：n≥10组时，Mfcu－λ1•Sfcu≥Fcu•k；Fcu•min≥λ2•Fcuk。2、非统计方法：n10组时，Mfcu≥1.15Fcu•k；Fcu•min≥0.95Fcu•k。0.8528.534.50.95Fcu•k1.15Fcu•kMfcu－λ1•Sfcuλ2•Fcu•kFcu•kFcu•minFcu•k砼方量（m³）56.3试块组数抗折强度（MPa）合格判定系数计算数据（MPa）设计强度最小值施工单位：浇筑台班（个）水泥混凝土抗压强度统计评定表五层养护方法工程名称：分项（部）名称：共页，第页部位平均值均方差nMfcuSfcuλ1λ220C2526.150.7390.950.851234567891011121314151617181920125.726.126.526.526.626.126.225.325.626.626.22528.126.32526.325.52726.825.56600000000按GBJ107规定公式计算评定：n10-1415-19≥20λ11.151.050.95水泥混凝土抗压强度统计评定表2#3#4#天面层养护方法施工单位：工程名称：浇筑台班（个）0.95Fcu•k试块组数抗折强度（MPa）合格判定系数计算数据（MPa）设计强度最小值1.15Fcu•kMfcu－λ1•Sfcuλ2•Fcu•kFcu•kFcu•minFcu•k砼方量（m³）25.44321.25每组强度值Fcu•i（MPa）2525统计法合格判定系数评定结论合格1、统计方法：n≥10组时，Mfcu－λ1•Sfcu≥Fcu•k；Fcu•min≥λ2•Fcuk。λ20.90汇总计算人：校核人：项目技术负责人：填报日期：合格判定系数评定结论合格2、非统计方法：n10组时，Mfcu≥1.15Fcu•k；Fcu•min≥0.95Fcu•k。0.8523456789101112131415161718192033293306322632953204000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002345678910111213141516171819206817027027086816866406557086866257906926256926507297186500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000工程名称：分项（部）名称：施工单位：桩号部位平均值均方差nMfcuSfcuλ1λ24C3550.5501234567891011121314151648.351.151.351.5按GBJ107规定公式计算评定：n10-1415-19≥20λ11.151.050.95λ20.900.85评定结论1、统计方法：n≥10组时，Mfcu－λ1•Sfcu≥Fcu•k；Fcu•min≥λ2•Fcuk。2、非统计方法：n10组时，Mfcu≥1.15Fcu•k；Fcu•min≥0.95Fcu•k。合格判定系数非统计法浇筑台班（个）养护方法计算数据（MPa）合格判定系数基础Fcu•min48.3Fcu•k0.9Fcu•k砼方量（m³）0.95Fcu•k1.15Fcu•kMfcu－λ1•Sfcu水泥混凝土抗压强度统计评定表设计强度最小值试块组数抗折强度（MPa）33.2540.25每组强度值Fcu•i（MPa）汇总计算人：校核人：项目技术负责人：填报日期：工程名称：分项（部）名称：施工单位：桩号部位平均值均方差nMfcuSfcuλ1λ211C4057.5275.1851.150.901234567891011121314151661.75863.853.754.653.566.359.356.34857.6按GBJ107规定公式计算评定：n10-1415-19≥20水泥混凝土抗压强度统计评定表基础最小值养护方法砼方量（m³）浇筑台班（个）Fcu•kFcu•minFcu•k0.95Fcu•k1.15Fcu•k试块组数抗折强度（MPa）合格判定系数计算数据（MPa）设计强度4840Mfcu－λ1•Sfcu51.565每组强度值Fcu•i（MPa）统计法合格判定系数评定结论λ11.151.050.95λ20.90汇总计算人：校核人：项目技术负责人：填报日期：合格判定系数评定结论1、统计方法：n≥10组时，Mfcu－λ1•Sfcu≥Fcu•k；Fcu•min≥λ2•Fcuk。2、非统计方法：n10组时，Mfcu≥1.15Fcu•k；Fcu•min≥0.95Fcu•k。0.85共页，第页171819201234567892332.892611.212631.692652.2500000000000000000000000000000000000000000000000000000000000合格养护方法计算数据（MPa）λ2•Fcu•kMfcu－λ1•Sfcu水泥混凝土抗压强度统计评定表每组强度值Fcu•i（MPa）填报日期：共页，第页171819201234567893806.8933644070.442883.692981.162862.254395.693516.493169.69000000000000000000000000000000000000000000000000000000水泥混凝土抗压强度统计评定表养护方法计算数据（MPa）Mfcu－λ1•Sfcuλ2•Fcu•k51.56536每组强度值Fcu•i（MPa）合格填报日期：合格101112131415161718192000000000000000000000000000000000000000000000000000000000000000000000000000000101112131415161718192023043317.76000000000000000000000000000000000000000000000000000000000000000000000000000工程名称：分项（部）名称：施工单位：桩号部位平均值均方差nMfcuSfcuλ1λ230C3537.5001.7371.600.8512345678910111213141516353637383940353637383940353637383940353637383940353637383940按GBJ107规定公式计算评定：n10-1415-24≥25λ11.701.651.60λ20.9034.7210.95Fcu•k1.15Fcu•kMfcu－λ1•SfcuFcu•min35Fcu•k0.9Fcu•k31.5水泥混凝土抗压强度统计评定表设计强度最小值试块组数抗折强度（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。合格判定系数统计法汇总计算人：校核人：项目技术负责人：填报日期：合格不合格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),合格,不合格))共页，第页1718192012345678900000000000000122512961369144400000122512961369144400000122512961369144400000122512961369144400000122512961369144400000000034.721λ2•Fcu•kMfcu－λ1•Sfcu29.75水泥混凝土抗压强度统计评定表每组强度值Fcu•i（MPa）养护方法计算数据（MPa）合格填报日期：IF(E18=统计法,IF(AND(Q8=K8,G8=T8),合格,不合格),IF(AND(E8=O8,G8=M8),合格,不合格))101112131415161718192000000000000152116000000000001521160000000000015211600000000000152116000000000001521160000000000000000000000桩基41.839.94340.538.235.84346.94432.939.940.942.64138.838.33233.439.240.235.236.336.73735.437.237.833.533.633.733.13331.535.939.436.444.247.64645.338.533.233.844423844.547.344.835.748.349.950.837.236.736.545.549.450.332.834.132.434.939.836.738.340.336.345.145.845.539.240.936.234.733.432.135.137.937.636.542.743.646.34447.537.835.537.738.738.537.437.635.936.137.937.233.645.343.439.749.648.650.144.936.234.339.444.147.737.234.330.437.23836.638.538.837.142.438.7404947.44134.335.135.838.239.338.644.535.135.346.342.637.536.131.933.744.139.233.830.5