FFT calculation

[ArtZ]

Hi,

I've been using the FFT analysis tool in Excel but find that it's
clunky because the FFT calculation is not "live".

Could someone either post the Excel code for an FFT and inverse FFT or
point me in the direction of where I can find the code?

I've spent a fair amount of time Google searching but can't find a
worksheet which calculates an FFT and inverse FFT from scratch, only
can find worksheet examples using the Analysis Toolpak FFT.

Thanks,

Art

 

[Leith Ross]

Hello Art,

Not sure what you mean by "live". Are you looking to use this on Rea
Time Data (RTD)? There are "C" DLL libraries available if you want FFT
with faster execution times. You could also look into purchasing
specialized math program as well. Not likely you will find a Fas
Fourier Transform written using Excel worksheet functions and/or VBA
unless the programmer was doing it for a math class, a masochist, o
insane, since it is already available in the Analysis ToolPak.

Sincerely,
Leith Ros