promise899
New Member
- Joined
- Feb 18, 2022
- Messages
- 9
- Office Version
- 2016
- Platform
- Windows
Hi All,
I want to do fourier transform in excel. Data analysis - fourier analysis can be selected from the menu option, and the operation can be performed. Excel performs the fourier transform for multiples of 2 data starting from 2^1 to 2^12 (2,4,8....4096). I have 600000 data for Vx and 600000 for Vy. Since Excel allows for a maximum of 4096 data, I need to do a minimum of 600000 / 4096 = 146 times for Vx. Same for Vy. Can this be done with VBA without doing it manually?
As a summary, I made the fourier transform between B2:B4097 once in the excel . From here on, I want it to transform 145 times in the same way. Also for column D. If possible, go all the way to the end of the data. Thank you.
Note. I tried to upload my excel file but size of it exceed (4.2 mb). So it can be downloaded from this web link
I want to do fourier transform in excel. Data analysis - fourier analysis can be selected from the menu option, and the operation can be performed. Excel performs the fourier transform for multiples of 2 data starting from 2^1 to 2^12 (2,4,8....4096). I have 600000 data for Vx and 600000 for Vy. Since Excel allows for a maximum of 4096 data, I need to do a minimum of 600000 / 4096 = 146 times for Vx. Same for Vy. Can this be done with VBA without doing it manually?
As a summary, I made the fourier transform between B2:B4097 once in the excel . From here on, I want it to transform 145 times in the same way. Also for column D. If possible, go all the way to the end of the data. Thank you.
Note. I tried to upload my excel file but size of it exceed (4.2 mb). So it can be downloaded from this web link
Last edited: