You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by wi...@compuserve.com on 2013/08/01 16:13:17 UTC

Data Analysis in OpenOffice Calc - Fast Fourier Transform analysis

Hi AOO Users,

Does anybody know whether there are any data analysis add-ons for AOO Calac V4.0.0?  I am particularly interested in a Fast Fourier Transform routine similar to the one available in the DA extension for MS Excel.  Has anyone written an FFT  add-on function for AOO Calc?

I have a package written for MS Excel which simulates the mixing of two sinusoidal waves and displays both the input and output waveforms on a virtual oscilloscope that uses the graphing feature.  The package also has a virtual spectrum analyser that will show the harmonic content of the product waveform but this needs to use the FFT function which is available in MS Excel.  I don’t currently use MS Office and would like to run the package in AOO but without an FFT function, I cant use the spectrum analyser to show the harmonic content of the combined waveforms.

There are many applications for this type of simulation package and It would be good to be able to use AOO Calc instead of having to rely on MS Excel!

Advice on how to go about creating a suitable function would be most appreciated if there are no functions currently available.

Regards

Geoff Williams

Re: Data Analysis in OpenOffice Calc - Fast Fourier Transform analysis

Posted by Andrew Douglas Pitonyak <an...@pitonyak.org>.
Sadly, I am not aware of FFT functionality for AOO.


On 08/01/2013 10:13 AM, wils_mail@compuserve.com wrote:
> Hi AOO Users,
>
> Does anybody know whether there are any data analysis add-ons for AOO Calac V4.0.0?  I am particularly interested in a Fast Fourier Transform routine similar to the one available in the DA extension for MS Excel.  Has anyone written an FFT  add-on function for AOO Calc?
>
> I have a package written for MS Excel which simulates the mixing of two sinusoidal waves and displays both the input and output waveforms on a virtual oscilloscope that uses the graphing feature.  The package also has a virtual spectrum analyser that will show the harmonic content of the product waveform but this needs to use the FFT function which is available in MS Excel.  I don’t currently use MS Office and would like to run the package in AOO but without an FFT function, I cant use the spectrum analyser to show the harmonic content of the combined waveforms.
>
> There are many applications for this type of simulation package and It would be good to be able to use AOO Calc instead of having to rely on MS Excel!
>
> Advice on how to go about creating a suitable function would be most appreciated if there are no functions currently available.
>
> Regards
>
> Geoff Williams

-- 
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org