VBA与MATLAB混合编程在传感器优化布置中的应用

Application of mixed-programming of VB and MATLAB in optimal sensor placement

传感器优化布置是结构健康监测系统实施的关键技术之一。介绍了基于粒子群算法的传感器优化布置方法。MATLAB具有强大的计算和图形处理能力,VBA具有良好的用户界面,将二者有机结合,可开发出功能强大的软件。详细介绍了一种基于组件对象模型(COM)的MATLAB与VBA混合编程方法。以凯威特型单层球面网壳为例,利用VBA作为AutoCAD二次开发工具,调用MATLAB编写的粒子群算法,实现传感器优化布置。

Optimal sensor placement is one of the core technologies in the implementation of health monitoring projects of structures. Inthisartical,optimal sensor placement based on particle swarm algorithmwas introduced. MATLAB is powerful in mathematic analysis and graphics processing while VBA is with favorable user interfaces,thus software combing the two will be more powerful. A method of Mixed-Programming of VBA and MATLAB based on component object model（ COM） was introduced in detail. VBA wasadopted as the secondary development tool of AutoCAD with Kiewitt single-layer Latticed spherical shell to obtain optimal sensor placement.