基于影响矩阵的风电机组螺栓疲劳寿命分析--ExceI VBA开发

摘要

The relationship between the stress of wind turbine bolts and the external load is usually nonlinear, in other words, the stress doesnˊt change linearly with the external load. However, fatigue analysis softwares (e.g.FE-Safe, nCode,etc.) available now can only be used if the stress changes linearly with the external load, thus theyˊre not suitable for the fatigue life analysis of wind turbine bolts. In this article, procedures of the influence Matrix-based fatigue life analysis of wind turbine bolts are introduced. Be-sides, an Excel VBA program is developed for analysis procedures, and the hub-main shaft bolted connection is taken as an exam-ple to describe in detail program operations for various procedures. Finally, the MatrixVB add-in and rainflow counting algorithm used in the Excel VBA program are briefly described.%通常情况下，风电机组螺栓应力对外载呈现出非线性关系，即应力不随外载线性变化。而现有的疲劳分析软件(如FE- Safe、 nCode等)应用的前提条件都是应力随外载线性变化，故现有的疲劳分析软件对风电机组螺栓疲劳寿命的计算并不适用。文章介绍基于影响矩阵的风电机组螺栓疲劳寿命分析步骤，以轮毂与主轴连接螺栓为例并结合Excel VBA二次开发程序详细介绍各个步骤的具体实现方式，最后简单介绍该二次开发程序中用到的MatrixVB插件及雨流计数算法。