I have an excel spreadsheet of joint angles corresponding with time. Is there any way to convert this file format into the .MOT file format that I need for OpenSim motions?
Thanks
Creating .MOT file from excel
- Dimitar Stanev
- Posts: 1096
- Joined: Fri Jan 31, 2014 5:14 am
Re: Creating .MOT file from excel
Hi,
You can copy the data from the excel and paste them into a .mot file, with the values separated by "tab". Also, you have to add a header in the beginning, where you add some description of the data (columns, rows. etc) and you also add the names of the columns after the header.
You can copy the data from the excel and paste them into a .mot file, with the values separated by "tab". Also, you have to add a header in the beginning, where you add some description of the data (columns, rows. etc) and you also add the names of the columns after the header.
Code: Select all
Coordinates
version=1
nRows=618
nColumns=7
inDegrees=yes
Units are S.I. units (second, meters, Newtons, ...)
Angles are in degrees.
endheader
time blockToGround_xRotation blockToGround_yRotation blockToGround_zRotation blockToGround_xTranslation blockToGround_yTranslation blockToGround_zTranslation
0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000
...
- Murat Bakkal
- Posts: 1
- Joined: Mon Nov 12, 2018 1:04 pm
Re: Creating .MOT file from excel
Hello,
I want to do the same thing, but I can not open a mot file. What am I missing? I do not have a place to paste the data into.
I want to do the same thing, but I can not open a mot file. What am I missing? I do not have a place to paste the data into.
Re: Creating .MOT file from excel
Open an excel spreadsheet, paste your data, edit the header, column data to match with mot file format, save the file as a tab delimited file with the extension .mot