Jeff Bagby and Charlie Out great things with Excel, very detailed, active, passive crossover and woofer had prepared programs
Passive Crossover Designer
Excel application for designing passive crossovers and equalization The purpose of the this spreadsheet is to allow the user to accurately simulate the frequency, phase, and impedance of a two or three way speaker with crossover using imported data files of the actual measured responses. The data file types used correspond to Liberty Instruments “Imp” and “Audiosuite” frd type frequency response data, and zma /zda impedance data files. Sample data files have been included with this spreadsheet to allow the user to experiment and gain a better working knowledge of the program.
I have included woofer, midrange, and tweeter frd and zma files, as well as standard 90 dB, 8 ohm, and 4 ohm files. The latter group are useful for simulating textbook crossover types. Explanation of these files and their use is covered at the bottom of the User Guide.
Woofer Box and Circuit Designer – The most accurate Sealed, Vented, and Passive Radiator modeling tool available – Complete with amplifier modeling and the ability to include room and baffle effects in the response
Active Crossover Designer
(ACD) – A set of tools for designing active loudspeaker crossovers using a series of linked Excel spreadsheets. Complete control of transfer function using pole and zero notation. Generates “advanced biquad” coefficients for the MiniDSP crossovers. Core tools are extensible via extensions.