Abstract:In the process of the stability analysis with MOSES software, it is often necessary to calculate multiple draft conditions. There are at least 12 wind angles under each draft condition to obtain the corresponding wind tilt arm, initial metacentric height, area ratio and other data. Manually extracting these data takes long time and is easy to make mistakes. Therefore, the VBA module embedded in Office software is used to extract the stability analysis results of offshore floating structures quickly and accurately through the secondary development program. The advantage of this method is that the operation platform is simple, there is no need to install complex program software, and it can be used as long as there is Office software. The extracted wind tilt arm, the first water inlet point, the second water inlet point and other data are arranged in rows, and the results are clear at a glance for subsequent analysis.