Functional Interface to Microsoft Excel

When ANSYS AQWA is installed, a Microsoft® Excel® add-in is made available to permit direct interrogation of the ANSYS AQWA database via the insert function facility. This allows for custom report generation, plotting and additional post-processing that can be defined by the user.

The extraction of response amplitude operator information from a diffraction analysis

 

Available Functions

FUNCTIONS

DESCRIPTION

Aqlcogcoord

Returns x, y or z coordinate of a structure center of gravity

Aqlcoord

Returns x, y or z coordinate of a node

Aqlelcent

Returns x, y or z coordinate of a diffracting element' centroid

Aqlelpres

Returns pressure at element centroid

Aqlfrequency

Returns wave frequencies analyzed in ANSYS AQWA LINE

Aqlglobals

Returns global parameters

Aqlmessage

Returns error message for a given aql error flag number

Aqlndirns

Returns number of wave directions for structure

Aqlnfreqs

Returns number of wave frequencies for structure

Aqlnlines

Returns number of mooring lines in model

Aqlnstructs

Returns number of structures in model

Aqlposition

Returns position of a structure for time history analysis

Aqlrao

Returns RAO information from hydrodynamic database

Aqlrao2

Returns interpolated RAO information from hydrodynamic database

Aqlstatmooring

Returns mooring line information for static (ANSYS AQWA LIBRIUM) analysis

Aqlstatposcog

Returns position of CoG for static (ANSYS AQWA LIBRIUM) analysis

Aqlstatposnod

Returns position of specified node for static (ANSYS AQWA LIBRIUM) analysis

Aqlthacccog

Returns acceleration of cog for time history analysis

Aqltharticulation

Returns articulation reactions for time history analysis

Aqlthfender

Returns fender information for time history analysis

Aqlthmooring

Returns mooring line information for time history analysis

Aqlthnumsteps

Returns number of time steps for time history analysis

Aqlthposcog

Returns position of CoG for time history analysis

Aqlthtime

Returns time associated with time step in time history analysis

Aqlthvelcog

Returns velocity of cog for time history analysis

Aqlwavedirn

Returns wave directions analyzed in ANSYS AQWA LINE

Aqlzcge

Returns ZCGE parameter for structure in ANSYS AQWA LINE analysis