Excel VBA在钢筋算量中的应用  

Application of Excel VBA in the Calculation of Reinforcing Steel Bar

作　　者：王庆华[1] 耿豪劼 沈华[1] 

机构地区：[1]南通职业大学建筑工程学院,江苏南通226007

出　　处：《南通职业大学学报》2016年第3期100-104,共5页Journal of Nantong Vocational University

基　　金：2015年江苏省高等学校大学生创新创业训练计划项目(201511052019Y)

摘　　要：为实用、便捷地将平法表示的混凝土结构施工图中的钢筋部分转化成易于理解的钢筋算量表单,通过在Excel中编写VBA程序,自动生成钢筋算量输入表单,填写数据后,经过计算机分析处理,自动生成输出表单,达到根据平法施工图钢筋自动翻样和算量的目的,既提高了工作效率,也可为开发其他方面的建筑自动化专业软件提供借鉴与参考。This paper attempts to turn the reinforcement bars into understandable bar calculation sheets in the concrete structure construction drawing with plane integration expression method in a practical and convenient way. With the Excel VBA program, automatic generation of bars quantity is put into the form, the data is filled in, and the output form is generated automatically through the computer analysis and processing, which achieves the purpose of automatic forming bar sheets and calculating the amount of bars according to the plane integration expression method and improves the efficiency. At the same time, it is also an important ref- erence for developing other software of building automation.

关 键 词：Excel VBA 二次开发 钢筋算量 钢筋表单 平法 结构施工图 

分 类 号：TU723.3[建筑科学—建筑技术科学]