Jump to content
mano112aprmw

Importing load from Excel

Recommended Posts

Hi everyone am working in Hypermesh(Aerospace) profile, i want to import load from excel which has nodal coordinates(or Element ID) and XYZ component forces .

How to do this??

Thanks. :)

Share this post


Link to post
Share on other sites

@Prakash He want to IMPORT load defined in Excel file, not INTERPOLATE as you suggest. Maybe the resultant is not so different, but that's not the same.

@mano112aprmw Do you know something about TCL programming? I think you can export Excel into CSV format et write a TCL script to read & apply to your model.

Share this post


Link to post
Share on other sites
Guest

@Q.Nguyen-Dai My mistake.

 

@mano112aprmw

One way is to have forces/moments in the form of .dat file which you can directly import in OptiStruct profile (.dat format is shown in image)

Here is a script to Create force on nodes using box selection. The Force and the box coordinates are defined in an external csv-file and force magnitude is divided to number of nodes that fall under this box.

LoadsImport2.PNG

ImportLoads.PNG

Share this post


Link to post
Share on other sites

Hi,

I have an ideal.

Thinking that excel is also very powerful to process data,

you can use its formulas to generate a *.fem file then import to hypermesh

example with node coordinates and force components,

I will generate GRID data, CONM2 (mass elems) at those grids, and FORCE on them,

after import to your model,

you can easily to use panel tool>equivalence to stick CONM2 to your nodes, then delete CONM2:

Capture.thumb.PNG.3818dc4e0fd677bc534b6e68ed2f4ca2.PNG

 

sample excel:

excel_to_fem.xlsx

 

 

Rahul R likes this

Share this post


Link to post
Share on other sites
1 hour ago, Q.Nguyen-Dai said:

Yeah, for "small" & "average" analysis, that's ok.

But for "big" (>1.E+6 nodes), maybe you hit Excel limitation :)

 

:D it's high probability with him - students often like to do big one

Share this post


Link to post
Share on other sites
On 5.5.2017 at 5:41 AM, Prakash Pagadala said:

@Q.Nguyen-Dai My mistake.

 

@mano112aprmw

One way is to have forces/moments in the form of .dat file which you can directly import in OptiStruct profile (.dat format is shown in image)

Here is a script to Create force on nodes using box selection. The Force and the box coordinates are defined in an external csv-file and force magnitude is divided to number of nodes that fall under this box.

 

ImportLoads.PNG

 

 

@Prakash Pagadala, how can I import the .dat file?

Share this post


Link to post
Share on other sites
Guest

Hi @Johannes

 

You can import .dat file in OptiStruct/Nastran profile in HyperMesh.

 

Goto Import>>Solver Deck>> Change file type to All file formats>> Select the .dat file>> Import. 

Share this post


Link to post
Share on other sites
On 05/05/2017 at 6:53 AM, tinh said:

Hi,

I have an ideal.

Thinking that excel is also very powerful to process data,

you can use its formulas to generate a *.fem file then import to hypermesh

example with node coordinates and force components,

I will generate GRID data, CONM2 (mass elems) at those grids, and FORCE on them,

after import to your model,

you can easily to use panel tool>equivalence to stick CONM2 to your nodes, then delete CONM2:

Capture.thumb.PNG.3818dc4e0fd677bc534b6e68ed2f4ca2.PNG

 

sample excel:

excel_to_fem.xlsx

 

 

Hi @tinh,

 

How would this Excel to FEM model be adjusted if you want to use it to create only pressures at x_node, y_node, z_node instead of Force components? 

 

Cheers

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
You are posting as a guest. If you have an account, please sign in.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...