[Lt72884]

I have finished a CFD run with openFOAM via the CFDOF workbench in Ondsel engineering suite (freecad core) but i closed the graphs before i could save them

however, i have the post processing force.dat file that was created. Is it possible to plot that data using excel? IE, somehow convert it to a csv?

i tried to use pyDATview to open the .dat file but it wouldnt. Usually pydatview works pretty well, but no this time.

this is a small snippet from the file i opened in notepad++

thanks for any help. I just want to plot it easily

# Force
# CofR : (0.000000000000000e+00 0.000000000000000e+00 0.000000000000000e+00)
#
# Time total_x total_y total_z pressure_x pressure_y pressure_z viscous_x viscous_y viscous_z
1 6.272490977400709e+02 2.436146278154886e-01 -3.099310501700163e-02 5.889497044284985e+02 2.433590399975305e-01 -3.100520366418902e-02 3.829939331157232e+01 2.555878179580612e-04 1.209864718738446e-05
2 7.984014931343739e+02 5.239188791923335e-01 -3.418934469470757e-01 7.599499178283725e+02 5.239201798234463e-01 -3.421633206661934e-01 3.845157530600147e+01 -1.300631112780557e-06 2.698737191176505e-04
3 8.836569721913074e+02 8.415569399213817e-02 1.046067912510396e+00 8.449776401414927e+02 8.426535990823947e-02 1.046860701382111e+00 3.867933204981473e+01 -1.096659161013004e-04 -7.927888717141930e-04
4 9.296442953065176e+02 2.214478647583240e-02 -1.267454470567073e+00 8.907069322371585e+02 2.225261370247011e-02 -1.267400005468660e+00 3.893736306935914e+01 -1.078272266377141e-04 -5.446509841311047e-05
5 9.322536796656141e+02 1.846195200753127e-02 7.267577690696538e-02 8.930506797894407e+02 1.851017732296256e-02 7.262844633698151e-02 3.920299987617337e+01 -4.822531543129157e-05 4.733056998386839e-05
6 9.326229847075065e+02 4.318312427959840e-01 2.862076844254740e-01 8.931643076947771e+02 4.320381567560903e-01 2.860461272223791e-01 3.945867701272937e+01 -2.069139601062404e-04 1.615572030949284e-04
7 9.090721799742681e+02 2.242345204456122e-01 -6.349590076208431e-02 8.693644130967657e+02 2.242635543606788e-01 -6.339576249625445e-02 3.970776687750238e+01 -2.903391506655613e-05 -1.001382658298522e-04
8 8.874761275685722e+02 1.248719061619086e+00 -5.216489585254133e-02 8.475176599815366e+02 1.248915521201477e+00 -5.236926366765893e-02 3.995846758703571e+01 -1.964595823910529e-04 2.043678151176002e-04
9 8.623096534041821e+02 1.109723583172472e+00 -2.525066963699041e-01 8.220914315260679e+02 1.110205902261661e+00 -2.527149216168603e-01 4.021822187811419e+01 -4.823190891891661e-04 2.082252469561053e-04
10 8.532426012426300e+02 3.782455466729902e-01 -2.848741131708384e-01 8.127434930775221e+02

[Lt72884]

well, that was interesting. I changed the file extension of force.dat to force.txt, and pydatview opens it right up and plots it all for me.. If you have never used that app, i highly suggest it.

here is a picture of the graph. Thanks and i hope this helps someone

However, i would still like to learn other ways of graphing, preferably in excel so i can get pretty colors. I know how to use excel, i would just need to know how to get the data over