- Part of the code was taken from senuba91 in this Original Post
- The idea came from the Eng, PHD, colleague, friend, Damian Gargicevich.
- The Time Data should be in seconds, days or the common date format of Excel, and both columns should be sorted in function of the time. Both ascending and descending sorts are allowed.
If you want to use a Time Column with a Date format. A date format is made of days, not seconds. You can find an adaptation for this purpose below. - The sampling rate should be constant or as constant as possible.
- This is a matritial formula. This formula should be accepted with "Control + Shift + Enter"
- The number of cells as a result, should be two columns and at least half of the biggest natural number with an integer logarithm with base 2. (if you have 2300 samples, the last 252 samples will be ignored (because is greater than 2048) and the result will have 1024 rows)
=PerformAFFT(TimeAsRange, DataAsRange, [Optional] TrueForPeriodFalseForFrequency, [Optional] TrueForDaysOrDateFalseForSecond)
-
TimeAsRange: Column with Time Data, You could use time in seconds or in days (Days should be used in excel Date Format)
If you wan't to use the time in days (Or date format), TrueForDaysOrDateFalseForSecond should be True! -
DataAsRange: Column with your numerical Data.
-
TrueForPeriodFalseForFrequency: If it is true, the output unit will be seconds per revolution instead of hertz
-
TrueForDaysOrDateFalseForSecond: Check TimeAsRange explanation, also the name is quite self explanatory.
First Column: Frequency in Hertz [or seconds per revolution]
Second Column: Amplitud in the same unit as Data