基于Excel VBA的混凝土抗压强度评定方法  

Evaluation Method for Compressive Strength of Concrete Based on Excel VBA

作　　者：邢伟 XING Wei(Hebei Guangtong Road and Bridge Group Co.,Ltd.,Handan 056001,China)

机构地区：[1]河北广通路桥集团有限公司,邯郸市056001

出　　处：《北方交通》2020年第12期37-40,共4页Northern Communications

摘　　要：新版《公路工程质量检验评定标准》要求试件组数大于等于10时的混凝土抗压强度采用数理统计方法进行评定,通过开发的ExcelVBA程序自动计算各统计值并判定强度合格性,提高了计算效率;同时用程序自动形成直方图,判定试验数据的有效性,实现了对生产过程的全面管理。The new edition of Highway Engineering Quality Inspection and Evaluation Standard requires that the compressive strength of concrete should be evaluated by mathematical statistics method when the number of test piece groups is greater than or equal to 10.The statistical values are calculated automatically by ExcelVBA program developed in the paper and the strength qualification is determined,so as to improve the calculation efficiency;meanwhile a histogram is automatically formed by the program,so as to determine the validity of the test data,and realize the overall management of production process.

关 键 词：混凝土 抗压强度 ExcelVBA程序 统计分析 直方图 试验有效性 

分 类 号：U445.57[建筑科学—桥梁与隧道工程]