Hi,
I am hoping that this is the right forum for this question. I know that there are "programs" to calculate Minimum Phase from Magnitude including programs based in Excel. I am looking for a Macro method that I can integrate into my own spreadsheet programs that will take a Magnitude and calculate the Minimum Phase. I know it will use FFT but I am not certain how to get there. Any guidance or an actual Macro would be very much appreciated. Thanks,
Jay
I am hoping that this is the right forum for this question. I know that there are "programs" to calculate Minimum Phase from Magnitude including programs based in Excel. I am looking for a Macro method that I can integrate into my own spreadsheet programs that will take a Magnitude and calculate the Minimum Phase. I know it will use FFT but I am not certain how to get there. Any guidance or an actual Macro would be very much appreciated. Thanks,
Jay
I have .NET source for integral transform (better than FFT), but not willing to give the source or convert to Excel macro. I would use VituixCAD Calculator tool which is able to convert hundreds of responses at once. Speed is 30...35 ms per file with ca. 500 data rows (Core i5 2.7GHz, SSD).
Of course it has some limits e.g. fixed frequency range 10...22000 with 48 pts/oct.
Of course it has some limits e.g. fixed frequency range 10...22000 with 48 pts/oct.
Last edited:
🙂 No intention to be selfish or guru. Just try to protect work and rights of original inventors (not me). Unfortunately this kind of numerical methods are quite difficult to find from www.
You need the Hilbert transform. This video supposedly walks through doing it in Excel. The application is geophysics but the math is universal (warning the video has an annoying musical accompaniment for no apparent reason).
https://www.youtube.com/watch?v=fFQmIcCuNhg
Hi Kimmo,
I know of Virtuix and I very much apprectiate the program. I have been playing around with it and have provided some feedback. This is really for my own edification and to allow me to expand upon some excel "programs" that I have been developing.
Thanks for your wonderful software,
Jay
Hi Scott,
Unfortunately, I may be dense but I likely need more of a step by step. Let's say that I am taking 750 data points that are measured log based. I believe that I need to covert this to a linear base that is at least twice the frequency of interest and add in interpolated values beyond my measured frequencies above and below my measured values. A step by step from here (with corrections, if necessary) to bring me home is what I am looking for. Sorry for being so dense.
Jay
Might be the most straight forward to contact Charlie Laub and ask if he's willing to help or make VBA version from Minimum Phase Extractor 2.0. Integral transform needs no more than 80 rows of VBA code including kernel initialization (and no FFT). Auto detection of LF & HF slopes needs some extra code or formulas if not entered manually.
That method is incredibly accurate - at least when all frequency points are calculated and slope estimation is correct.
That method is incredibly accurate - at least when all frequency points are calculated and slope estimation is correct.
- Status
- Not open for further replies.