2010-09-24

# Fourier Transform

Previous Post: Animated Roller Coaster in Excel

Next Post: Basic 3D-2D (Perspective) Visualization

Science, Engineering, Games in Excel & VBA

Primary Navigation Menu

2010-09-24

Previous Post: Animated Roller Coaster in Excel

Next Post: Basic 3D-2D (Perspective) Visualization

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.