A spreadsheet that can do spectral magnitude and phase - diyAudio
Go Back   Home > Forums > Design & Build > Software Tools

Software Tools SPICE, PCB CAD, speaker design and measurement software, calculators

Please consider donating to help us continue to serve you.

Ads on/off / Custom Title / More PMs / More album space / Advanced printing & mass image saving
Reply
 
Thread Tools Search this Thread
Old 27th August 2011, 09:19 PM   #1
gpapag is offline gpapag  Greece
diyAudio Member
 
gpapag's Avatar
 
Join Date: Nov 2002
Location: Athens-Greece
Default A spreadsheet that can do spectral magnitude and phase

Hi all

The concept, the push and the main mathematical formulas are all from SY. (*see references)
I put the bricks together.

4096 is the max data points that excel can perform Fourier analysis on.
The free program I use to convert wav. Files to .txt (“Watex_1”) can do max 4096. (Download Watex 1.0 Free - Wave to txt-file converter - Softpedia )

I import the .txt data on column C (C2:C4097).
Then, I select:
[Tools],
[Data Analysis],
[Fourier Analysis], [Input Range (C2:C4097), Output Range (E2:E4097)].

Then, I input in shell “W3” the number in seconds (exact) of the duration of the wave file that was converted to text.

In shell “W6” I input the number of samples that I used in the wav.to .txt converter program.

After inputing all this data, the diagrams take their shape.

You can have a look on the spreadsheet ( it is unlocked, no macros), test it by importing your wav. to txt file and tell me if you find anything wrong.

Regards
George

*references:
http://www.diyaudio.com/forums/analo...ml#post2679588
http://www.diyaudio.com/forums/analo...ml#post2679603
http://www.diyaudio.com/forums/analo...ml#post2679611
http://www.diyaudio.com/forums/analo...ml#post2679630
http://www.diyaudio.com/forums/analo...ml#post2679631
http://www.diyaudio.com/forums/analo...ml#post2680499
http://www.diyaudio.com/forums/analo...ml#post2680588
Attached Images
File Type: jpg Screenshot.JPG (108.7 KB, 141 views)
Attached Files
File Type: zip Home_brewed FFT Plots V1.zip (689.6 KB, 31 views)
__________________
["Second Law is a bitch." - SY] ["The Road To Heaven:Specify the performance & accept the design. The Road To Hell:Specify the design & accept the performance"-Bruno Putzeys]

Last edited by gpapag; 27th August 2011 at 09:32 PM.
  Reply With Quote
Old 2nd November 2011, 10:51 AM   #2
just another
diyAudio Moderator
 
wintermute's Avatar
 
Join Date: Aug 2003
Location: Sydney
Blog Entries: 22
Hi George, I think that amount of effort at least deserves a response!!!

I assume that this was done as a learning exercise, as I know you know other (much easier) ways to get fft data from wav files

I stumbled across this post because I was looking at your thread history to find the Y out thread, as I was feeling the need to solder something (now that I have completed my crossovers), and there is a packet from Greece that needs assembly!

Tony.
__________________
Any intelligence I may appear to have is purely artificial!
Some of my photos
  Reply With Quote
Old 16th December 2011, 08:30 AM   #3
gpapag is offline gpapag  Greece
diyAudio Member
 
gpapag's Avatar
 
Join Date: Nov 2002
Location: Athens-Greece
Hi Tony
Thanks for visiting and commenting.
Yes, you are right. There are less masochistic programs to do FFT.
But I had to pay a closer look at the suggestion of SY about the phase (in addition to amplitude) diagram of an FFT. The other FFT programs to which I have access to, donít do this.
Alas, 4096 data points is really restricting. The remedy was to reduce the time slice. So with a a very short sample (small fraction of a second), I can go high in frequency.
The diagram 3 is very helpful, as it shows the waveform of the sampled input after the sampling. There I can easily watch for any inappropriate sampling, as in this case, the waveform will look distorted. (apart from the resulting spiky FFT).
All in all, it was a learning exercise and this, remains a learning tool for me.
Regards
George
__________________
["Second Law is a bitch." - SY] ["The Road To Heaven:Specify the performance & accept the design. The Road To Hell:Specify the design & accept the performance"-Bruno Putzeys]
  Reply With Quote
Old 16th December 2011, 10:48 AM   #4
gpapag is offline gpapag  Greece
diyAudio Member
 
gpapag's Avatar
 
Join Date: Nov 2002
Location: Athens-Greece
Quote:
There are less masochistic programs to do FFT
He he. I can't help it, but I still remember what a tedious process was to make the Sinclair ZX Spectrum (1kB RAM, audio cassette as mass storage and BASICA software) print a primitively simple diagram!
__________________
["Second Law is a bitch." - SY] ["The Road To Heaven:Specify the performance & accept the design. The Road To Hell:Specify the design & accept the performance"-Bruno Putzeys]
  Reply With Quote
Old 17th December 2011, 09:11 AM   #5
just another
diyAudio Moderator
 
wintermute's Avatar
 
Join Date: Aug 2003
Location: Sydney
Blog Entries: 22
ah yes, I remember being utterly disapointed that our comodore 1526 printer (with our commodore 64) could not print graphics. It was a text only dot matrix printer.

But that didn't deter me. The printer had the ability to print user defined characters, so I wrote a program in assembler that would take an image and convert it into (I think it was 8X8) programable characters and output it on the printer. 6502 assembler is horrid!! But it actually worked. The only problem was the images were tiny

Tony.
__________________
Any intelligence I may appear to have is purely artificial!
Some of my photos
  Reply With Quote
Old 18th December 2011, 07:37 PM   #6
gpapag is offline gpapag  Greece
diyAudio Member
 
gpapag's Avatar
 
Join Date: Nov 2002
Location: Athens-Greece
Graphics printer back then?
Were you reading science fiction that extensively?
__________________
["Second Law is a bitch." - SY] ["The Road To Heaven:Specify the performance & accept the design. The Road To Hell:Specify the design & accept the performance"-Bruno Putzeys]
  Reply With Quote
Old 18th December 2011, 08:15 PM   #7
just another
diyAudio Moderator
 
wintermute's Avatar
 
Join Date: Aug 2003
Location: Sydney
Blog Entries: 22
Haha I think my first science fiction was in year nine at school (1981) Robert Heinlein "Assignment in Eternity"

Even earlier than that my Dad brought home some pictures that had been printed on a mainframe printer. Very clever, it overlaid different characters to increase the density to achive from black to grey. you had to look at it from a distance of course.

Tony.
__________________
Any intelligence I may appear to have is purely artificial!
Some of my photos
  Reply With Quote
Old 18th December 2011, 08:25 PM   #8
gpapag is offline gpapag  Greece
diyAudio Member
 
gpapag's Avatar
 
Join Date: Nov 2002
Location: Athens-Greece
So, no one can blame you. It was the environment you grew-up in
__________________
["Second Law is a bitch." - SY] ["The Road To Heaven:Specify the performance & accept the design. The Road To Hell:Specify the design & accept the performance"-Bruno Putzeys]
  Reply With Quote

Reply


Hide this!Advertise here!
Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Spectral schematics audiorogert Solid State 16 16th August 2010 10:37 PM
Spectral audiorogert Solid State 0 17th November 2008 01:04 AM
Formulae for calculating crossover magnitude and phase based on component values alexclaber Multi-Way 33 19th May 2008 08:06 AM
Question about transfer function magnitude. massappeal129 Subwoofers 4 16th August 2007 10:21 PM
sign magnitude DAC Bernhard Digital Source 0 30th January 2007 01:40 PM


New To Site? Need Help?

All times are GMT. The time now is 04:28 AM.


vBulletin Optimisation provided by vB Optimise (Pro) - vBulletin Mods & Addons Copyright © 2014 DragonByte Technologies Ltd.
Copyright ©1999-2014 diyAudio

Content Relevant URLs by vBSEO 3.3.2