EN | 中文

gallery/fea_logo_2019
VBA Excel macros For Offshore FEA

Home  Projects  >  Femap API Excel Macros

gallery/offshore_ship_hull

  set of VBA Excel Femap API macros For FEA Offshore tasks

Figure 1. Parts of the MS Excel based user interface for engineering application

Development of a set of software tools (macros) as part of a project to automate analysis of the numerous load cases for a special offshore vessel (Heavy lifting ship) “Pioneering Spirit”.

 

Pioneering Spirit (formerly “Pieter Schelte”) is a vessel with a dynamic principle of positioning. The ship designed for mounting and dismantling large offshore structures: oil and gas production platforms, elements of gas and oil pipelines etc.

 

Tools have been used: Femap API + MS Excel + VBA + Femap WinWrap Basic.

 

 

 

 

Figure 2. Parts of the MS Excel based user interface and data output

for engineering application

The project scope

Macro set functionalities and features:

  • Initial data input, post-processed results report and user interface are based on MS Excel;
  • Automation of load sets (hydrostatic, wave, wind, load) creation and application to defined parts of the vessel's structure FE model depending on lifting appliances load conditions;
  • Automated analysis sets creation, running, and control of completion;
  • Automated post-processing of NX Nastran analysis results and reporting to the defined tables in Microsoft Excel spreadsheets;
  • Auto-updating of the ship FEM space orientation relative to the base coordinate system;
  • Auto-updating of lifting appliance loading conditions and positions relative to the vessel main deck;
  • A computing of the new centers of gravity and reporting obtained coordinates data to Excel tables for the next iteration of engineering analysis procedures (new load parameters calculations as new input data).

The dimension of the target offshore ship FEM model is about 0.5 million elements. The average speed of one “operation” (applying hydrostatic pressure to the hull elements of a ship’s hull (around 180 thousand plate elements ) is about 20 seconds.

 

Figure 3. Visualization of the applied "wave" hydrostatic load on the  FEM of "testing" vessel ship hull

gallery/ui2
gallery/ui1
gallery/shiphullfem_wave1