Data:
I have several Datasheets of the following structure:
Column 1 = Time (0.001 - 2.000 ms)
Column 2 to 5 = Acceleration signals
Column 6 to 14 = EMG-Signals of different muscles
All columns have a length of 2000 rows.

Analysis:
For the analysis of the muscular power I need the mean power
frequency (MPF) of all the EMG signals. Therefore a FFT of the
muscle-signals with a window of 50 values is quiet useful.

In addition of the MPF over the rows 250 to 1250 I need the
MPF of the sections from row 250 to 500 and from row 501 to 1250.
I only need the real values, not the imaginary ones. It would be
of great help, if the output data is a worksheet with the
8 columns like the muscles EMG signals in the original datasheet.

Finally I need the mean and the median values of the frequency
spectrum for each period of each muscle. They can be stored in a
separate column of the "frequency worksheet".

It would be of great help, if anyone could give me assistance in
writing such a script or tell me, if there are any build-in functions
to record the manual steps (like a macrorecording in Excel).

Thank you in advance for your help.