For pressure vessels gasketed joints, obtaining a uniform bolt load distribution is mandatory in order to ensure leak-free service of the joint. However, due to the elastic interaction phenomenon, it is difficult to achieve a uniform bolt load distribution. To address this difficulty, standards recommend tightening sequences that have shown good performance. However, these sequences have to be carried out in several passes; in addition, the standards point out that each assembler should develop its particular tightening sequences. In order to overcome these disadvantages, it is possible to find methods that provide a particular tightening sequence with which a uniform bolt load is obtained in a single pass tightening sequence. The most popular method is the Elastic Interaction Coefficients Method (EICM). In previous works [1,2], a new methodology called Tetraparametric Assembly Method (TAM) was developed for ASME Ring Type Joints (RTJ). In comparison with the EICM, the TAM provides very accurate results with much lower cost. In this work, the TAM has been implemented in Microsoft Excel (programmed in Visual Basic for Application), to obtain in a few seconds an optimal tightening sequence for most RTJ (NPS, Class and SCHD) for any target load and any assembly pattern using one or two passes.
展开▼
机译：对于压力容器垫圈，获得均匀的螺栓载荷分布是强制性的，以确保接头的无泄漏服务。然而，由于弹性相互作用现象，难以实现均匀的螺栓载荷分布。为了解决这个困难，标准建议紧缩序列，这些序列表现出了良好的性能。然而，这些序列必须在几次通行证中进行;此外，标准指出，每个汇编器都应发展其特定的收紧序列。为了克服这些缺点，可以找到提供特定拧紧序列的方法，其中在单次通过紧固序列中获得均匀的螺栓载荷。最流行的方法是弹性相互作用系数方法（EICM）。在以前的作品中，为ASME环形接头（RTJ）开发了一种称为Tetraparametric组件方法（TAM）的新方法。与EICM相比，TAM提供了非常准确的结果，成本较低。在这项工作中，TAM已经在Microsoft Excel（在Visual Basic for Application中编程）实现，以便在几秒钟内获得用于任何目标负载和任何组装模式的大多数RTJ（NPS，Class和Schd）的最佳收紧序列一两次通过。
展开▼
