Allan, I tried the old Mac versions of Excel before (2004) and I was never able to run macros. In my case simply it wouldn’t run no matter what and I got so frustrated I eventually gave up. This was not because of the division with zero which it is not uncommon in my worksheets. Windows Excel let you get away with that usually so unless it’s widespread I don’t worry about. Please let me know if you figure it out. Thanks, George
George, Thanks, just as I suspected. I will let you know if I get anywhere, but since I am frustrated, I believe I will write my own C routine. Too bad I am unable to use yours, as it is a really nice tool.
George, Thanks again for your prompt answer. I am now suspecting my problem is a Windows-Mac Excel incompatibility, since I am using Mac’s. One has “MS Excel for Mac 2004” (supposedly equivalent to Excel 2003), and another has “MS Excel for Mac 2011” (supposedly equivalent to Excel 2010) (aka Bill Gates strikes again). Neither versions work. I am trying to edit the macros, but so far I have had no luck in getting them run through to the end. I get a divide by zero run time exception with the later version of Excel, and nowhere on the earlier version. BTW, I have never encountered a Windows-Mac incompatibility with Excel previously. Oh well, I guess that I will just have to write my own version of your great tool. Thanks again for your help.
Thanks for your prompt reply, but that is not the problem I am having. It appears that I am using an older version of Excel that doesn’t support the macros you are using. I assume that one has to use MS Office 2010 or later. True?
Allan, the fuctions are defined in column N to S and the index (1 or 2 , etc) just defined the order. You need to go in one of those columns and change the formula yourself to get the right function then change the index so that the model uses your custom function. George
Yours looks like a useful tool that I would like to use. However, the version (“Fourier4.xls”) I downloaded from this site doesn’t work. If I change the input “Function #” to anything other than “1”, the output does not change. As downloaded, there are constants in columns H, I, J, K and L. Any suggestions? Is there another site I can download your tool. Any help would be appreciated, as it would save me much time, since I would not have to write my own version. Thanks.
Hi! I have done some experiments in Neuroscience to see the membrane resonance of neurons. I am applying sine waves {sin(2pi*t/1000)*(t/2000))}. However, in my previous software I just asked it for doing, and now with the new one, I have to find equations… I was wondering if you can help me on it, please!
Thanks a lot!
The file has been updated. You’re probably using 2007 which is very very slow. I added a DoEvents in the macro Do loop and now it’s running in 2007 too but extremely slowly. Anything is fast in 2003 or earlier versions.
Good luck!
Allan, I tried the old Mac versions of Excel before (2004) and I was never able to run macros. In my case simply it wouldn’t run no matter what and I got so frustrated I eventually gave up. This was not because of the division with zero which it is not uncommon in my worksheets. Windows Excel let you get away with that usually so unless it’s widespread I don’t worry about. Please let me know if you figure it out. Thanks, George
George, Thanks, just as I suspected. I will let you know if I get anywhere, but since I am frustrated, I believe I will write my own C routine. Too bad I am unable to use yours, as it is a really nice tool.
Allan, I am using 2003. In 2003 or earlier go to: Tools-> Macro -> Security -> Low (or Medium). Save then close and then re-open the sheet. George
George, Thanks again for your prompt answer. I am now suspecting my problem is a Windows-Mac Excel incompatibility, since I am using Mac’s. One has “MS Excel for Mac 2004” (supposedly equivalent to Excel 2003), and another has “MS Excel for Mac 2011” (supposedly equivalent to Excel 2010) (aka Bill Gates strikes again). Neither versions work. I am trying to edit the macros, but so far I have had no luck in getting them run through to the end. I get a divide by zero run time exception with the later version of Excel, and nowhere on the earlier version. BTW, I have never encountered a Windows-Mac incompatibility with Excel previously. Oh well, I guess that I will just have to write my own version of your great tool. Thanks again for your help.
Thanks for your prompt reply, but that is not the problem I am having. It appears that I am using an older version of Excel that doesn’t support the macros you are using. I assume that one has to use MS Office 2010 or later. True?
Allan, the fuctions are defined in column N to S and the index (1 or 2 , etc) just defined the order. You need to go in one of those columns and change the formula yourself to get the right function then change the index so that the model uses your custom function. George
Yours looks like a useful tool that I would like to use. However, the version (“Fourier4.xls”) I downloaded from this site doesn’t work. If I change the input “Function #” to anything other than “1”, the output does not change. As downloaded, there are constants in columns H, I, J, K and L. Any suggestions? Is there another site I can download your tool. Any help would be appreciated, as it would save me much time, since I would not have to write my own version. Thanks.
Your FFT Excel program is a very nice teaching tool — thanks for making it available. Well done !
Thanks Paul!
Hi! I have done some experiments in Neuroscience to see the membrane resonance of neurons. I am applying sine waves {sin(2pi*t/1000)*(t/2000))}. However, in my previous software I just asked it for doing, and now with the new one, I have to find equations… I was wondering if you can help me on it, please!
Thanks a lot!
Alan, Sure I will help you but I didn’t understand the question. Be more detailed.
The file has been updated. You’re probably using 2007 which is very very slow. I added a DoEvents in the macro Do loop and now it’s running in 2007 too but extremely slowly. Anything is fast in 2003 or earlier versions.
I can’t seem to open this – anyone else have this problem?
I had… not openning