Is it possible to import load data based on an excel?

Vinicius_Petrucci

Hello

I received about 4 load conditions from a client. Each condition has about 1277 load inputs. The Excel has x, y, z and the pressure value. Is there any way to automate the creation of load cases and add them all to Mecway?

The client's mesh is 20x20mm and the model's is 4x4mm

Victor

There isn't a general way to input a pressure field. Some alternatives:

If the x,y,z values correspond to nodes or elements in the mesh, you could write a Python script or use a spreadsheet, perhaps with face node coordinates obtained from Solution->Table.

If you can fit the values to a 2D function, which sounds like it could be achievable for that 4x4 patch which might have only about 50 points, you could enter the formula for that function in the pressure load.

How should the pressure values be interpolated between points? For instance, is it a regular grid with linear interpolation or a point cloud where perhaps the nearest point's value is good enough?

Vinicius_Petrucci

Thanks, I'll think of something along those lines.