Excel's Fourier Analysis should be a function, so that results upd

G

Guest

Excel's Fourier Analysis (FFT) Add-In is very useful, except that the user
must manually run it each time the input column's data changes in order to
see the new output data. Why not make this a function, so that FFT results
are updated automatically whenever the input is changed?

I'd love to see, for example, "FFT" and "IFFT" (inverse FFT) functions in a
future version of Excel.
 
D

Dana DeLouis

Bob. I have a Radix-2 Fourier Transform vba function. However, I wrote it
using vba's full 28 digit precision. (Variant arrays). I plan to re-write
it using double precision. However, I've been testing different ideas for
speed and haven't quite finished it yet. Give me a few weeks to finish it.
If you drop me a note with your email address, I'll send you an update when
ready.
 
G

Guest

BobM said:
Excel's Fourier Analysis (FFT) Add-In is very useful, except that the user
must manually run it each time the input column's data changes in order to
see the new output data. Why not make this a function, so that FFT results
are updated automatically whenever the input is changed?

I'd love to see, for example, "FFT" and "IFFT" (inverse FFT) functions in a
future version of Excel.

Bob, How can I use the Excel's Fourier Analysis (FFT) Add-in? Could you,
please, hemp me on that? I want to make the FFT of a signal that's in a
clolumn of an excel file. How I can do?

Please, answer me...
Many thanks in advance for your courtesy.
With my best whises and best regards,
Sandro
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top