CFD Online Logo CFD Online URL
www.cfd-online.com
[Sponsors]
Home > Forums > General Forums > Structural Mechanics

problem in importing force-time data from excel into ansys

Register Blogs Members List Search Today's Posts Mark Forums Read

Like Tree2Likes
  • 1 Post By dky
  • 1 Post By Gweher

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
Old   October 24, 2017, 05:57
Default problem in importing force-time data from excel into ansys
  #1
dky
New Member
 
Deepak Yadav
Join Date: Oct 2017
Posts: 1
Rep Power: 0
dky is on a distinguished road
I'm doing a simulation in transient structural in workbench 17.1, when I try to import force-time history from excel-2010 into workbench using .XML files, it is showing that 'either the specified location is incorrect or the source at that location contains no data'. So can somebody please give me the solution of this problem.

Thanks
Rana Nasser likes this.
dky is offline   Reply With Quote

Old   October 26, 2017, 07:57
Default
  #2
New Member
 
Rana Nasser
Join Date: Sep 2017
Posts: 6
Rep Power: 8
Rana Nasser is on a distinguished road
Quote:
Originally Posted by dky View Post
I'm doing a simulation in transient structural in workbench 17.1, when I try to import force-time history from excel-2010 into workbench using .XML files, it is showing that 'either the specified location is incorrect or the source at that location contains no data'. So can somebody please give me the solution of this problem.

Thanks
I have the same problem with importing acceleration-time history from excel-2016 into WB 15.1 I tried to import the data in ".XML" formats or ".txt" format ,but all my trials gave the same error of yours!
Rana Nasser is offline   Reply With Quote

Old   November 1, 2017, 11:09
Default Our problem has been solved!!
  #3
New Member
 
Rana Nasser
Join Date: Sep 2017
Posts: 6
Rep Power: 8
Rana Nasser is on a distinguished road
transient-acc in put.jpg

transient-acc in put2.jpg

transient-acc in put3.jpg
like the attached pictures I use Windows Copy and Paste to put acceleration-time history into an acceleration load in Transient Structural.

Someone sent me this method and I found it works.
Rana Nasser is offline   Reply With Quote

Old   November 22, 2017, 10:25
Default
  #4
Senior Member
 
Gweher's Avatar
 
Gwenael H.
Join Date: Mar 2011
Location: Switzerland
Posts: 392
Rep Power: 20
Gweher will become famous soon enough
There are some issues when you try to import or even with copy / paste sometimes. When you use the copy/paste be sure to select the 1st cell of the table as Nasser showed otherwise partial paste could occur.

You can also take advantage of the external data module to import .txt / .csv files but unfortunately you canít define acceleration directly but displacement and velocities are supported.
Rana Nasser likes this.
Gweher is offline   Reply With Quote

Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
courant number increases to rather large values 6863523 OpenFOAM Running, Solving & CFD 22 July 5, 2023 23:48
AnSYS Icepak - defining a report solution, problem (time steps) chris92jc ANSYS 0 August 17, 2015 11:33
mixerVesselAMI2D's mass is not balancing sharonyue OpenFOAM Running, Solving & CFD 6 June 10, 2013 09:34
Low Mixing time Problem Mavier CFX 5 April 29, 2013 00:00
Importing 3D data as CEL into ANSYS CFX 11.0 Dave W. CFX 9 October 19, 2007 08:18


All times are GMT -4. The time now is 11:23.