Excel Subwoofer Designer
Here is a Microsoft Excel spreadsheet that I have made which models the
response of vented box systems and sealed box systems. It is based on Brian
Steele's spreadsheet (diysubwoofers.org), but I have modified it to provide more
functions to aid in designing a subwoofer. Some of the functions of this
modified spreadsheet are:
- Alignment Comparisons - calculate box size/tuning for Thiele and Small
vented/sealed box alignments such as SBB4/BB4, SC4/C4, QB3/SQB3, etc and
different sealed box Qtc's
- Compare vented box and sealed box response simulations on the same graph
- Simulate almost all types standard active crossovers, user specified Q and
center frequency for Linkwitz Riley, Butterworth, etc
- Set Qa/Ql/Qp losses
- Parametric and sallen key EQ modelling
- Simulate effects of adding extra mass to the cone and shows new T/S
parameters of driver when mass added
- Simulate extra circuit resistance in cabling/xover/amplifier
- Calculate frequency of 1st port resonance
- Calculate usable xmax of driver based on voice coil length and gap height,
with more complex calculation for cone overdrive
- Compare real world to measured results, user enters measured frequency
response data
- Model the response contribution of car cabin gain and room gain
- Model transfer function of vented and sealed systems including effect of
active filters/EQ
- Model phase and group delay of sealed and vented systems, including
effects of active filters/EQ
- Model electrical impedance of sealed and vented systems with circuit
resistance effects and voice coil inductance
- Model port air speed including effects of active filters/EQ
- Model cone excursion of vented and sealed systems including effect of
active filters/EQ
- Model excursion limited SPL at given power level of vented and sealed
systems including effect of active filters/EQ
- Model port contribution to system SPL including effect of active
filters/EQ and SPL caused by leaks
- Model phase and group delay response separately of active filters/EQ
- Model transfer function response of active filters/EQ
- Calculate components required for 2cd sallen key active EQ and schematic
provided
- Help notes throughout entire spreadsheet - move mouse pointer over the red
tag to see help note, more on this in Introductory tab in spreadsheet
It's an easy to use spreadsheet too. As stated above, there's also
help notes right throughout the spreadsheet in case something doesn't make
sense. Please contact me if you have a problem with it though.
Click the link below to download Excel Subwoofer Designer
Alternate Link excelsub.zip
(6.5mb)
You will need Winzip to extract the Microsoft Excel spreadsheet. You can
download a free copy of winzip from http://www.winzip.com/
I would like to hear any comments, suggestions, etc about this spreadsheet.
Please email them too macky888@wasp.net.au Back to
homepage
BACK