Has anyone heard about Fourier transforms on Excel? Google didn't have any quick obvious hits. Excel would be a cheap easy way demonstrate FFTs in the classroom. The first column would be phase angle and 2nd column would calculate A1sin(w1*t + phi1) + A2sin(w2*t + phi2) etc. for a time domain signal. Go down 256 cells and start something like the divide and conquer approach. The A1, A2, A3 . . . An and phi1, phi2, phi3, . . . phin would output in the cells dedicated to various frequency ranges. Bret Cahill
FFTs On Excel
Started by ●November 12, 2010
Reply by ●November 12, 20102010-11-12
Has anyone heard about Fourier transforms on Excel? Google didn't have any quick obvious hits. Excel would be a cheap easy way demonstrate FFTs in the classroom. The first column would be phase angle and 2nd column would calculate A1sin(w1*t + phi1) + A2sin(w2*t + phi2) etc. for a time domain signal. Go down 256 cells and start something like the divide and conquer approach. A1, A2, A3 . . . An and phi1, phi2, phi3, . . . phin would output in cells dedicated to various frequency ranges. Bret Cahill
Reply by ●November 12, 20102010-11-12
Has anyone ever heard about Fourier transforms on Excel? Google didn't have any quick obvious hits. Excel would be a cheap easy way demonstrate FFTs in the classroom. The first column would be phase angle and 2nd column would calculate A1sin(w1*t + phi1) + A2sin(w2*t + phi2) etc. for a time domain signal. Go down 256 cells and start something like the divide and conquer approach. A1, A2, A3 . . . An and phi1, phi2, phi3, . . . phin would output in two column of cells dedicated to various frequency ranges. Bret Cahill
Reply by ●November 12, 20102010-11-12
On Fri, 12 Nov 2010 08:09:26 -0800 (PST), Bret Cahill wrote:> Has anyone ever heard about Fourier transforms on Excel? Google > didn't > have any quick obvious hits. > > Excel would be a cheap easy way demonstrate FFTs in the classroom. > > The first column would be phase angle and 2nd column would calculate > A1sin(w1*t + phi1) + A2sin(w2*t + phi2) etc. for a time domain > signal. > > Go down 256 cells and start something like the divide and conquer > approach. > > A1, A2, A3 . . . An and phi1, phi2, phi3, . . . phin would output > in two column of cells dedicated to various frequency ranges. > > Bret CahillWrong, listen to me I know whatthe fuck I am talking about. X=55~>645.44 by 67%^,,,gh Got it? Now fuck off. -- Don't FUCK with me. I'm tuff. And stupid but don't dare FUCK with me.
Reply by ●November 12, 20102010-11-12
On Fri, 12 Nov 2010 11:52:01 -0500, Nancy Norelli <ms.n@hushmail.com> wrote:>On Fri, 12 Nov 2010 08:09:26 -0800 (PST), Bret Cahill wrote: > >> Has anyone ever heard about Fourier transforms on Excel? Google >> didn't >> have any quick obvious hits. >> >> Excel would be a cheap easy way demonstrate FFTs in the classroom. >> >> The first column would be phase angle and 2nd column would calculate >> A1sin(w1*t + phi1) + A2sin(w2*t + phi2) etc. for a time domain >> signal. >> >> Go down 256 cells and start something like the divide and conquer >> approach. >> >> A1, A2, A3 . . . An and phi1, phi2, phi3, . . . phin would output >> in two column of cells dedicated to various frequency ranges. >> >> Bret Cahill > >Wrong, listen to me I know whatthe fuck I am talking about. > >X=55~>645.44 by 67%^,,,gh > >Got it? > >Now fuck off. >-- >Don't FUCK with me. I'm tuff. And stupid but don't dare FUCK with me.Nancy, I think your error is that you've completely neglected the effects of time and termperature. Without these factors it is not possible to accurately estimate time to mortality. Eric Jacobsen Minister of Algorithms Abineau Communications http://www.abineau.com
Reply by ●November 12, 20102010-11-12
Bret Cahill wrote:> Has anyone heard about Fourier transforms on Excel? Google didn't > have any quick obvious hits.Seriously? Google: Excel fourier --> About 335,000 results (0.23 seconds) Google: Excel fft --> About 364,000 results (0.24 seconds) First hit: How to do a Fast Fourier Transform (FFT) in Microsoft Excel http://www.ehow.com/how_4670778_fourier-transform-fft-microsoft-excel.html In which universe did you actually do the Google search?
Reply by ●November 12, 20102010-11-12
Tools->Data Analysis->Fourier Analysis if not there go to Tools->Add ins and add the Analysis toolpak
Reply by ●November 12, 20102010-11-12
On Fri, 12 Nov 2010 17:00:41 GMT, Eric Jacobsen wrote:> On Fri, 12 Nov 2010 11:52:01 -0500, Nancy Norelli <ms.n@hushmail.com> > wrote: > >>On Fri, 12 Nov 2010 08:09:26 -0800 (PST), Bret Cahill wrote: >> >>> Has anyone ever heard about Fourier transforms on Excel? Google >>> didn't >>> have any quick obvious hits. >>> >>> Excel would be a cheap easy way demonstrate FFTs in the classroom. >>> >>> The first column would be phase angle and 2nd column would calculate >>> A1sin(w1*t + phi1) + A2sin(w2*t + phi2) etc. for a time domain >>> signal. >>> >>> Go down 256 cells and start something like the divide and conquer >>> approach. >>> >>> A1, A2, A3 . . . An and phi1, phi2, phi3, . . . phin would output >>> in two column of cells dedicated to various frequency ranges. >>> >>> Bret Cahill >> >>Wrong, listen to me I know whatthe fuck I am talking about. >> >>X=55~>645.44 by 67%^,,,gh >> >>Got it? >> >>Now fuck off. >>-- >>Don't FUCK with me. I'm tuff. And stupid but don't dare FUCK with me. > > Nancy, > > I think your error is that you've completely neglected the effects of > time and termperature. Without these factors it is not possible to > accurately estimate time to mortality. > > Eric Jacobsen > Minister of Algorithms > Abineau Communications > http://www.abineau.comblah blah blah who are you to tell ME what I do and don't know. I have children who do that. Revised: 5N^2 + N + 20 is O(N^2). I use a complicated algorithm to determine the FFTs chosen on any given day from a pool of 6.023x10*23 The exact details will have to remain a secret, but I can tell you that it involves fibonacci sequences, monte carlo methods, differential equations, recursion, neural networks, priority queues, referential transparency, lambda calculus, bipartite graphs, the phase of the moon and the tire pressure of John Cleese's bicycle. -- Don't FUCK with me. I'm tuff. And stupid but don't dare FUCK with me.
Reply by ●November 12, 20102010-11-12
Greg Neill wrote:> Bret Cahill wrote: >> Has anyone heard about Fourier transforms on Excel? Google didn't >> have any quick obvious hits. > > Seriously? > > Google: Excel fourier --> About 335,000 results (0.23 seconds) > > Google: Excel fft --> About 364,000 results (0.24 seconds) > First hit: How to do a Fast Fourier Transform (FFT) in Microsoft Excel > http://www.ehow.com/how_4670778_fourier-transform-fft-microsoft-excel.html > > In which universe did you actually do the Google search?Nuts and Volts mag had a good article a few years ago, with accompanying excell spreadsheet.
Reply by ●November 12, 20102010-11-12
On Fri, 12 Nov 2010 13:40:03 -0500, Nancy Norelli <ms.n@hushmail.com> wrote:>On Fri, 12 Nov 2010 17:00:41 GMT, Eric Jacobsen wrote: > >> On Fri, 12 Nov 2010 11:52:01 -0500, Nancy Norelli <ms.n@hushmail.com> >> wrote: >> >>>On Fri, 12 Nov 2010 08:09:26 -0800 (PST), Bret Cahill wrote: >>> >>>> Has anyone ever heard about Fourier transforms on Excel? Google >>>> didn't >>>> have any quick obvious hits. >>>> >>>> Excel would be a cheap easy way demonstrate FFTs in the classroom. >>>> >>>> The first column would be phase angle and 2nd column would calculate >>>> A1sin(w1*t + phi1) + A2sin(w2*t + phi2) etc. for a time domain >>>> signal. >>>> >>>> Go down 256 cells and start something like the divide and conquer >>>> approach. >>>> >>>> A1, A2, A3 . . . An and phi1, phi2, phi3, . . . phin would output >>>> in two column of cells dedicated to various frequency ranges. >>>> >>>> Bret Cahill >>> >>>Wrong, listen to me I know whatthe fuck I am talking about. >>> >>>X=55~>645.44 by 67%^,,,gh >>> >>>Got it? >>> >>>Now fuck off. >>>-- >>>Don't FUCK with me. I'm tuff. And stupid but don't dare FUCK with me. >> >> Nancy, >> >> I think your error is that you've completely neglected the effects of >> time and termperature. Without these factors it is not possible to >> accurately estimate time to mortality. >> >> Eric Jacobsen >> Minister of Algorithms >> Abineau Communications >> http://www.abineau.com > >blah blah blah > >who are you to tell ME what I do and don't know. I have children who >do that. > >Revised: > >5N^2 + N + 20 is O(N^2). > >I use a complicated algorithm to determine the FFTs chosen on any >given day from a pool of 6.023x10*23 > >The exact details will have to remain a secret, but I can tell you >that it involves fibonacci sequences, monte carlo methods, >differential equations, recursion, neural networks, priority queues, >referential transparency, lambda calculus, bipartite graphs, the phase >of the moon and the tire pressure of John Cleese's bicycle. >-- >Don't FUCK with me. I'm tuff. And stupid but don't dare FUCK with me.Well, clearly, your results are not going to be valuable or significant if you're not using Markov models, Mersenne primes, and parabolic interpolation. Didn't your kids tell you that? Eric Jacobsen Minister of Algorithms Abineau Communications http://www.abineau.com
