Application Center - Maplesoft

Discrete Fourier Transfom and Inverse Fourier Transform

You can switch back to the summary page by clicking here.

Discrete Fourier Analysis for Excel Files

? Harald Kammerer, GERB Schwingungsisolierungen, Germany

August 2008

This application allows to import time history data from an Excel file. The first column of the file has to contain the time, the other columns have to contain the signal data. In this example the Excel files are stored in the directory c:\mapletemp. Please try some other places. Somtime you will get an error message because some input values are not valid at the beginning. If you change it everything should work fine.

 Complete path of the Excel Input Files    The data must be in columns of the Excel file. The first column contains the time data in constant steps, the column of the corresponding signal values can be selected. Input File      Here the file to edit to be selected from the list. Number of Table Headers    This is the number of the table headers or otherwise not to be considered top lines. Column of the Signal Values    Here is the column in which the observed signal values are. Number of Time Steps taken into account ≤ Number of Actual Time Steps in the Data File    The number of lines of the table which are considered may be limited. If the actual number available to be taken into account, you can enter 0, otherwise is a number less than or equal to the maximum indicated on the right to be given.      Note: If the time history in the Excel file starts from a complete number of cycles, including initial value and end value the number of time steps which taken into account has to be reduce by 1. ≤
 Time History      The representation of the time history is done automatically by change of the above requirements or when loading a new file by clicking on the button 'Time History'. Spectrum      For the presentation of amplitude spectrum click the button 'Amplitude Spectrum', for the phase spectrum click the button 'Phase Spectrum'. Limits for the Plot of the Amplitude Spectrum      Here, the frequency range of the representation is selected. Click on 'Amplitude Spectrum' effect again set to the extreme values. Minimum: Maximum:      Peak:         at f =
 Lower Cutoff Frequency Upper Cutoff Frequency Minimum Amplitude Maximum Peaks
 Filter    After using the button 'Amplitude Spectrum' the result can be filtered according the setting of the four rotatory switches. Save Frequency Spectrum into the Excel File      The filtered frequency spectrum is saved into the above given Excel file.      Note: The Excel file must consist at least three sheets. The amplitude is written to sheet 2, the phase to sheet 3. Existing data will be overwritten! Save Filtered Time History into the Excel File      The filtered time history is saved into the above given Excel file.      Note: The Excel file must consist at least four sheets. The filtered time history is written to sheet 4. Existing data will be overwritten!

Legal Notice: The copyright for this application is owned by the author(s). Neither Maplesoft nor the author are responsible for any errors contained within and are not liable for any damages resulting from the use of this material.. This application is intended for non-commercial, non-profit use only. Contact the author for permission if you wish to use this application in for-profit activities.