How to get displacement with frequency from harmonic analysis

[rupika]

Hi all,
I did harmonic analysis for a pin supported beam. I want to FRF function from it. To do that I went through this procedure. TimeHist Postpro->variable viewer-> select the node point-> DOF solution -> Y component. Then click on list. Then I got UY values corresponding to the frequency. But I want only UY values as I want to plot it in excel sheet. How can I get only UY values with respect to frequency? I think I have to write a command for it. But I do not know the command for that. Please help me.I have attached the data I got from analysis.

 

[juzz]

Hello, Rupika!

First you have to know that you could arrange your data in Excel directly:
1. First select column where the data is located and use the Excel command "Text to columns" from "Data" menu, setting delimiter to space only and checking that consecutive delimiters to be treated as one. Now you will have data in different columns
2. After checking that data was correctly arranged in columns, get rid of the blank columns in front of frequencies by deleting them.
3. Select all table and sort by frequency column. All headers will move to the end. Delete them. Now you will have in columns B the needed displacement vs. frequency (in column A) and you could construct desired graph.

In Ansys you could obtain only the displacements by transferring the variable into an array:

1. Define an array using *DIM command having same length as the variable
2. Move the content of the variable into the array using VGET command.
3. Put the content of the array into a file using the following commands sequence

*cfopen,...
*vwrite,...
(format descriptors)
*cfclose

(search on help for details regarding each command)

Also, you could plot your results directly in Ansys by using functions of Variable Viewer.

Success!

Juzz

I have put the modified Excel file in attach.