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:

  1. 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
  2. Compare vented box and sealed box response simulations on the same graph
  3. Simulate almost all types standard active crossovers, user specified Q and center frequency for Linkwitz Riley, Butterworth, etc
  4. Set Qa/Ql/Qp losses
  5. Parametric and sallen key EQ modelling
  6. Simulate effects of adding extra mass to the cone and shows new T/S parameters of driver when mass added
  7. Simulate extra circuit resistance in cabling/xover/amplifier
  8. Calculate frequency of 1st port resonance
  9. Calculate usable xmax of driver based on voice coil length and gap height, with more complex calculation for cone overdrive
  10. Compare real world to measured results, user enters measured frequency response data
  11. Model the response contribution of car cabin gain and room gain
  12. Model transfer function of vented and sealed systems including effect of active filters/EQ
  13. Model phase and group delay of sealed and vented systems, including effects of active filters/EQ
  14. Model electrical impedance of sealed and vented systems with circuit resistance effects and voice coil inductance
  15. Model port air speed including effects of active filters/EQ
  16. Model cone excursion of vented and sealed systems including effect of active filters/EQ
  17. Model excursion limited SPL at given power level of vented and sealed systems including effect of active filters/EQ
  18. Model port contribution to system SPL including effect of active filters/EQ and SPL caused by leaks
  19. Model phase and group delay response separately of active filters/EQ
  20. Model transfer function response of active filters/EQ
  21. Calculate components required for 2cd sallen key active EQ and schematic provided
  22. 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

 

Download excelsub.zip

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