The
Passive Crossover Designer is a crossover simulation and speaker design tool built into an Excel spreadsheet. The original passive crossover design tool has now been expanded to include a box model, an impedance modeler, and a full active crossover design section for each driver than can be used along with the passive crossover features if desired. New to version 6.0 is the inclusion and update of the "
Passive Crossover Design Calculator" which includes many electrical and acoustic textbook calculator tools.
This spreadsheet will produce the frequency, phase and impedance response of 2 way, 2.5 Way standard and cascaded versions, and 3 way parallel systems, as well as 2 way series, 2.5 combined series/parallel designs, and can even be used to design 3 way series networks. It is designed to work with actual driver frequency and impedance data in the form of .frd and .zma/zda files which can be imported into the program.
It makes use of full x,y,z geometric location of the individual drive units and gives you a movable listening axis, both vertical and horizontal which will allow you to see the driver summation at almost any point in the front hemisphere of the speaker. This model now includes driver directivity, so off-axis simulations will also include directivity response variations as well. This proprietary tool offers very accurate simulations of the summed and individual drivers response at various axial locations.
The program has individual sections for woofer, tweeter, and midrange circuits, each with SPL and Impedance charts, as well as System charts that show summed SPL response, approximated power response, phase response, system impedance, and crossover transfer functions. There is a section for system input impedance equalization also.
Other features include - options for two woofers, or two midranges, and either wired in series or parallel, automatic calculation of L-Pads, Zobels and series RLC compensation circuits at the click of a button, user selectable built-in or imported Target responses that are overlaid with the driver's response in each section. And all crossover values can be continuously changed via "spinners" with the response will changing in real-time on the charts, allowing for quick curve-fitting of the response or impedance curves.
As mentioned above, the program includes an accurate box design tool with the ability to model the response of both vented and sealed systems. This add-in includes a unique and proprietary impedance modeler that will accurately model the impedance of the woofer in the box used and allow you to use this impedance curve in the crossover design section if desired. In addition, an active crossover section is included that contains high and low pass slopes up to eighth order, five band parametric equalizer (for each section), Linkwitz Transform, and level and delay adjustments. This section can be used with the box model to design subwoofers using active EQ and filters.
The program includes the ability to save out all individual driver, crossover (active or passive), and system SPL and Impedance responses to frd and zma files that can be used in other software. It has the ability to print or save charts, and a special system summary print-out page for your project. Included are Pop-up parts layout schematics for each crossover section. And finally, it also contains the ability to save all session data to very small files that can be imported again later thereby resetting all settings in the file to match the previous session or project. This gives you the ability to create a library of crossover designs while taking up very little space on your drive.
The file requires Excel 2000 or higher with Service Pack 1 and 2 installed and must have the Analysis Toolpak and Analysis Toolpak VBA installed in the add-ins, and security must be set to allow running of macros.
There is an additional download available that includes a 35 page User Guide in pdf file format and several sample files that can be imported to demonstrate the programs features.
Click here to jump to the Passive Crossover Designer 6.20 download section
Version 6.1 Update Info: Corrected error on Box Model page with Fb and Vent diameter not showing in vented mode. Corrected error on System Description page that showed some values that were turned off. Changed the way phase response was exported into an frd file for the summed response. And, added driver polarity buttons to the charts, so you can change the polarity of the midrange and tweeter and without scrolling down.
The Version 6.11 release fixes a bug in the overlay routine.
The Version 6.12 release corrects an error in the impedance overlay routine.
The Version 6.20 release corrects an error in the 2.5-way power response calculation.
Spreadsheet (and all previous versions), its VBA Modules, and its file structure -
© Copyright 2001- 2008
Jeff Bagby - File Design, Structure, Mathematics, and selected VBA routines
Paul Verdone - Selected VBA routines
File is Free for personal DIY Speaker Design use.
Commercial use is prohibited without prior authorization of the author
Info: click here to Email Jeff Bagby