Download AXL ASAS Interface for Microsoft Excel

AXL User Manual
Running AXL
Column and row numbers in a formula can be made absolute by prefixing them with dollar signs. Therefore the
formula in cell B9 can be rewritten as:
=axldisplace($A$4,$A9,$B$6,B$8)
which when copied to C10 gives:
=axldisplace($A$4,$A10,$B$6,C$8)
which evaluates to:
=axldisplace("C:\ALPHA;PLAT;JACK",2030,401,"Y")
as required.
Use of named cells can also be useful when requiring invariant data access. By naming cell A4 ‘model’, use can
be made of this name in the function cells and behaves as though giving an absolute address. Thus ‘model’ is
synonymous with $a$4.
The formula in cell B9 becomes:
=axldisplace(model,$A9,$B$6,B$8)
The formula in cell B9 can be copied over the whole of the table B9:D14 to give the required table as follows:
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
A:
C:\ALPHA
PLAT
JACK
=A1&";"&A2&";"&A3
B:
Loadcase
401
Node
2020
2030
2040
3020
3030
3040
X
=axldisplace(model,$A9,$B$6,B$8)
Contains proprietary and confidential information of ANSYS, Inc. and its subsidiaries and affiliates.
C:
D:
Y
Z
Page 3-3