基于VBA的法兰带压密封夹具设计

针对压力容器和管道法兰带压密封夹具设计中存在的难点，以弯曲梁理论为基础，建立了法兰夹具力学模型，推导出了更接近实际的夹具强度计算公式。依据泄漏介质温度、压力、法兰外周长、法兰副的连接间隙、连接螺栓的个数、夹具材料的许用应力及夹具强度计算公式，采用VBA编制了夹具设计智能化软件。应用实例证明了该软件的实用性和易用性，初步实现了压力容器和管道法兰夹具设计的智能化。

Flange Clamps Design On- line Sealing Based on VBA

The mechanical model and recommendable strength calculation formula of flange clamp were proposed by the bent beam theory, according to the difficulty for flange clamp design on-line sealing in the pressure vessel and pipeline. The intelligent clamp design software is made by using VBA, and based on leaking media temperature, pressure, leaking flange outer circumference, joint clearance of the flange, joint bolt numbers, working allowable stress and strength calculation formula of flange clamp. When the data of in-set measurement,technical requirements and design's information are inputted, the intelligent software will automatically compute and mark sizes and output clamp working drawing. The application of this software has shown that it is simple and easy to apply. The intelligent pressure vessel and pipeline flange clamp design was achieved preliminarily.