This is an Excel workbook calculating the Fourier transform of a signal.
[sociallocker]
[/sociallocker]
2010-09-24
Fourier Transform
Previous Post: Animated Roller Coaster in Excel
Next Post: Basic 3D-2D (Perspective) Visualization
This is an Excel workbook calculating the Fourier transform of a signal.
[sociallocker][/sociallocker]
I need to look deeper into this. It might just be some arbitrary scaling.
Hello, George. Why do we divide the “cos” and “sin” totals by 20000?
Hi, George;
It is very good one, I love it. I am learning how to use it properly. I plug in my own data points and time blocks such that I copy and paste my data points under Custom 4, and time blocks at Column 3, changed stop frequency to 10000, then choose Function #4 and run, I do not get an appropriate fourier transform. My data points is 2000 and time increase is 0.005. what should I do in order to make it work with any my own data points?
Thanks,
I want to build an inverse as well as a DFT both direct and inverse. I’ve been too busy lately with insurance claims and a contract I need to finish.
I have since discovered that having a second spread sheet opened slows the process. Once I close the second spreadsheet performance picks up considerably and it becomes very usable.
Its very nice. Ever considered an “inverse transform” option ?
Thanks. What was the largest data points you used besides the demo version?
Yes that’s easy to do, except it’s going to be slow. I chose the limits you see there for speed reasons.
Hi George, Any thoughts? If considering speed, what would be a realistic data point limit? Thanks.
10X of the current limit.
How many points you need?