TL alignment tables in excel - diyAudio
Go Back   Home > Forums > Loudspeakers > Full Range

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 18th March 2010, 11:18 AM   #1
Henkjan is offline Henkjan  Netherlands
diyAudio Member
 
Henkjan's Avatar
 
Join Date: Jan 2006
Location: Berkel en Rodenrijs
Default TL alignment tables in excel

continued form this thread

some time ago weidok and I have made an excel sheet for easier working with MJK's great TL allignment tables. After some feedback from Martin and from users here and on another forum, here is the latest version, including tools like multiple drivers, results in both metric and imperial units, and a sketch showing a simple folded cabinet. Enjoy, and is there are any suggestions for improvements, please post them here.

Please note: the sheet uses a custom function to read between the lines in the tables (LaGrange interpolation), so you must enable macros in excel for it to work. for the same reason the sheet will not run in OpenOffice (sorry, that's still work in progress). To protect the formulas from accidental overwriting, the sheets are protected so entry can only be made in the right cells; there is no password on them, so if you want to modify them, just remove the protection.

there are also other sheets out there, maybe we can collect them here, what works for me might not be the easiest for the next guy....
Attached Files
File Type: zip TL alignment v3.1 english.zip (30.8 KB, 406 views)
  Reply With Quote
Old 29th March 2010, 01:09 PM   #2
diyAudio Member
 
Join Date: Sep 2004
Location: MT
This is great. Just the kind of box I would like to build. But I am kind of a noob. Well not completely but to this kind of enclosure anyways.

Here are the specs that I have for the speaker I would like to use. But they don't quite match up with the entries in the sheet. Any help would be great. Really would like to try out a TL.

5" speaker
Woofer: Fs: 100 Hz, Qts: 0.93, Re: 4.2 Ohm, Qes: 1.3, Qms: 3.2, Le: 0.54 mH, Vas: 2.1 liters, Znom 4 Ohm

Do I need more data?

Thanks a bunch......
  Reply With Quote
Old 29th March 2010, 05:28 PM   #3
Henkjan is offline Henkjan  Netherlands
diyAudio Member
 
Henkjan's Avatar
 
Join Date: Jan 2006
Location: Berkel en Rodenrijs
I have used the same terminology as Martin did in his article, so use the following:
fd=fs
Qtd=Qts

and for the allignment tables you'll also need Sd (driver area in cm2) and BL (force factor) in N/A
  Reply With Quote
Old 12th February 2011, 04:58 PM   #4
diyAudio Member
 
Join Date: Feb 2011
Default Henkjan, Thanks for your work! 2 questions:

I recently built a TL using old labyrinth guidelines (fs 1/4 wave length and slightly bigger than sd cross section) working somewhat blindly I lined the walls with egg crate foam and stuffed first half. The drivers are close to closed end. I like the sound sound pretty good actually, but I've been looking for more reliable method to design and ran into M J King's work (thanks).

And subsequently Keith Webb's and your .xls sheets. Good work and thanks!

I understand what everything in your sheet means except for two things. 'Peak value Dt' and 'Factor Dr'. I went back and skimmed over M J King's work to find and figure out what Dz (in Keith's sheet) and Dr are but saw no mention of them in the formulas or illustrations. I will go back to M J King's site and read more carefully all his findings to get a better understanding of it all, in due time.

In the meantime I am wondering if I need to concern myself with these two numbers. Even if I'm ok with specs of rest of default system. If so, what to look for? What is normal range and what is trouble for design?
  Reply With Quote
Old 12th February 2011, 05:49 PM   #5
frugal-phile(tm)
diyAudio Moderator
 
planet10's Avatar
 
Join Date: Oct 2001
Location: Victoria, BC, NA, Sol III
Blog Entries: 5
Thanx Henjan, i started working over the one posted on Martin's site, but didn't get far due to no time.

dave
__________________
community sites t-linespeakers.org, frugal-horn.com, frugal-phile.com ........ commercial site planet10-HiFi
p10-hifi forum here at diyA
  Reply With Quote
Old 13th February 2011, 01:31 AM   #6
MJK is offline MJK  United States
Account disabled at member's request
 
Join Date: Feb 2002
Location: Clifton Park, NY
Quote:
Originally Posted by sbdabbler View Post
I understand what everything in your sheet means except for two things. 'Peak value Dt' and 'Factor Dr'.
The factors Dz and Dr in the Excel spreadsheet are scale factors that are used to calculate the TL geometry. They are defined in the Alignment Tables article on page 3 and looked up in the article's Tables on pages 11 and 12. They are not related to any physical dimensions.

Martin
  Reply With Quote
Old 13th February 2011, 02:01 PM   #7
Henkjan is offline Henkjan  Netherlands
diyAudio Member
 
Henkjan's Avatar
 
Join Date: Jan 2006
Location: Berkel en Rodenrijs
With this thread alive, I would like to take the opportunity to ask if there are any "OO gurus" out there: I would like to make the lagrange interpolation also work in OO, but I cannot get the VBA formulas translated into the OO basic.
  Reply With Quote
Old 13th February 2011, 04:03 PM   #8
diyAudio Member
 
Join Date: Feb 2011
Thanks, Martin.

The TL's I built are a pair. I eventually want to make 5 or more, space permitting. While I like the sound of the ones I built, with the thick sounding bass extension, and unforced mids, I did need to tame resonances with crossover parts.

I'm thinking of making another pair with the same drivers (basically the drivers from Elsinore project) using your formulas for flared. If I like the results, I will move the current ones to surround duty.

Btw, I am using Woofer Tester 3 to get driver parameters. Including BL Product. Expressed in N/Amp. Hopefully this is a uniform industry standard, since Keith's Excel sheet is using expression Tm. The default number (9.2 Tm) is in typical range of N/Amp with drivers I test using WT3. The Peerless 7" woofer I'm using is 8.6 N/Amp, for instance.
  Reply With Quote
Old 13th February 2011, 08:28 PM   #9
diyAudio Member
 
grindstone's Avatar
 
Join Date: Jun 2007
Location: GMT-6
thanks for sharing! yeah OOo or libreoffice would be good for some but those things are too enormous for lots of people too so some crude interpolation would be more portable and run in smaller things like gnumeric. eons ago, I used to just used to populate tables and then use HLOOKUP and VLOOKUP and sorta bash it out linearly. might be way wrong/haven't looked, etc., but if linear isn't good enough, maybe you can just bang it out
Math Forum - Ask Dr. Math

probably everybody has their own customized versions of that original great excel sheet. i remember one of the first things i did is add calculations to just enter into both hornresp and martins sheets so there was no thinking required
  Reply With Quote
Old 13th February 2011, 09:42 PM   #10
Henkjan is offline Henkjan  Netherlands
diyAudio Member
 
Henkjan's Avatar
 
Join Date: Jan 2006
Location: Berkel en Rodenrijs
in a test version in OO I have used linear interpolation (with a built-in function) of the log values of the table, that is probably "close enough" for this purpose
  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
P17 MTM TL help on MK's alignment tables led7 Multi-Way 7 18th May 2007 10:25 AM
Augspurger's alignment tables Dave Jones Multi-Way 22 14th April 2007 10:13 PM
Using MJK´s alignment tables VelluPiri Multi-Way 2 23rd October 2006 02:22 PM
please help with MJK's alignment tables just a guy Subwoofers 61 11th August 2006 06:40 PM


New To Site? Need Help?

All times are GMT. The time now is 04:57 PM.


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