Inverse Fourier Transform in VBA Excel

http://www.excelforum.com/excel-programming-vba-macros/476198-how-can-i-call-fourier-analysis-from-a-visual-basic-macro.html

Please provide me in a sample worksheet. I can't do it from the link.

You're correct, the link only tells you what to do, not how to do it. You are going to have to do some of your own work or hire someone who can do it for you. Free advice only goes so far, at some point you have to expend some of your own effort/money. Hint: you're at that point.

If I was to provide you with a sample sheet, how would you be able to use it?

How would you trouble shoot it? How would you adapt it to your question?

Start from the beginning and not from the end.

Lay it out on paper and then start making your Excel sheet. Using the link I provided you should be able to use Fourier in VBA.

If this is not the case then you need to start even earlier.

How about another web search?

I can't get the thing to work either after several tries. maybe the input range for the inverse transformation was not set up properly (needs phase vector).

Yup.

What's with the 8th and 9th ambiguity?

Are they all "suspect" values?

True RMS I'm guessing. 50,60 or 400Hz fundamental?

What instrumentation did you use for data collection?

Tell us a tale!

What do you intend to do with the time domain? The reason most instruments that give you this kind of information is so that you can consider the effects that those harmonics have on other equipment. From the magnitude of the primary current, I might surmise that you are attempting to calculate the actual peak voltage that is being expressed across a power factor correction capacitor. To do this, you will have to consider if they are additive or subtractive at any instant in time. Then as you sum up the contributing voltages you may discover that you are punching holes in you power factor correction capacitor by exceeding the rated voltage. This causes many of them to eventually catch on fire. The fire department will usually just let them burn unless the power pole is threatened by the flames. Been there, seen it.

I was under the impression that phase shift considerations are taken care of inside the equipment calculations for harmonic content. Otherwise, the information would be essentially useless.