hypercube
asked on
Fourier Analysis Excel 2007 array size error
This is Excel 2007. I did a Fourier Analysis over an array of 512 real numbers yielding an array of 512 complex numbers.
Then I tried to do a 2nd array of the same size.
The function errors out saying that the arrays need to be sized a power of 2. 512 is a power of two.
The exact row numbers are x3:x514.
514 -3 +1 is 512 rows of course......
Please help!
Then I tried to do a 2nd array of the same size.
The function errors out saying that the arrays need to be sized a power of 2. 512 is a power of two.
The exact row numbers are x3:x514.
514 -3 +1 is 512 rows of course......
Please help!
Also I want to see how are you populating the 2nd array? You might want to try this to check if it is actually a 512 sized array?
Sid
'~~> Replace MyArray with the name of the array
Debug.Print Ubound(MyArray)
Sid
ASKER
I didn't do anything re: arrays really.
I just used the Fourier Analysis Input Range and Output Range pretty much like I said originally.
$E$3:$E$514
$H$3:$H$514
Just for the heck of it I did this:
I ran it over 256 cells and got the results.
Then I repeated those cells to get 256
Then I did an Inverse over the 512 and it worked fine.
The Inverse values are purely real as expected.
But, when I try to format them down to 1 or 2 decimal places they don't change at all!
I don't know how to do the Debug.Print Unbound thing......
I just used the Fourier Analysis Input Range and Output Range pretty much like I said originally.
$E$3:$E$514
$H$3:$H$514
Just for the heck of it I did this:
I ran it over 256 cells and got the results.
Then I repeated those cells to get 256
Then I did an Inverse over the 512 and it worked fine.
The Inverse values are purely real as expected.
But, when I try to format them down to 1 or 2 decimal places they don't change at all!
I don't know how to do the Debug.Print Unbound thing......
I used the same range and didn't get an error?
Sid
Sid
BTW when I say Error I am referring to your main array size error.
Sid
Sid
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Now it says that all the complex numbers have to have the same suffix either "i" or "j" but they were generated by Excel!!
I don't get the error you show to work on...
I don't get the error you show to work on...
Can you upload your file?
Sid
Sid
ASKER
I did find an error. One of the input arrays had some blank cells in it. Seems to be working better now.
Gr8 :)
Sid
Sid
ASKER
I likely would not have noticed this little pastel icon/button nor known what to do with it. It helped quite a bit in fixing this problem!
Sid