上海市排烟系统设计计算公式基于Excel VBA的自定义函数的开发

摘要

针对上海市排烟系统设计中的计算问题，利用Excel中内置的VBA语言将《建筑防排烟技术规程》中的排烟计算公式开发为自定义函数，并在Excel中制作排烟计算表，实现了输入参数后自动计算得到结果，提高了设计效率。%According to the problem of calculation of exhaust system design in Shanghai,Custom Functions is devel-oped on the formulae of exhaust system in Technical Specification for Building Smoke control through the Excel VBA . The exhaust calculation table is designed in the Excel,which can calculate to achieve the outcome of the input parameters auto-matically,so that it improves the efficiency of design.