Go Back   Home > Forums > >
Home Forums Rules Articles diyAudio Store Blogs Gallery Wiki Register Donations FAQ Calendar Search Today's Posts Mark Forums Read

Software Tools SPICE, PCB CAD, speaker design and measurement software, calculators

How to calculate SPL with filters in Excel
How to calculate SPL with filters in Excel
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 26th September 2017, 09:28 PM   #11
Windforce85 is offline Windforce85  Poland
diyAudio Member
 
Join Date: Nov 2014
Nice, it also works. Could you also help with Linkwitz transform transfer function in the same fashion?
  Reply With Quote
Old 26th September 2017, 10:24 PM   #12
djoffe is offline djoffe  United States
diyAudio Member
 
Join Date: Oct 2008
save me a lookup...show the polynomial in s form of the transfer function you seek.
__________________
www.akitika.com Featuring the GT-102 Power Amp and PR-101 Preamp kits
www.updatemydynaco.com Featuring upgrades for classic Dynaco Solid State Equipment
  Reply With Quote
Old 26th September 2017, 10:28 PM   #13
Windforce85 is offline Windforce85  Poland
diyAudio Member
 
Join Date: Nov 2014
By the time I managed to solve it different way, all done. Thanks for your effort! I will show something when it will be ready.

Cheers,
Damian
  Reply With Quote
Old 16th October 2017, 08:36 PM   #14
Windforce85 is offline Windforce85  Poland
diyAudio Member
 
Join Date: Nov 2014
I managed to create this excel tool which is simulating various drivers in sealed boxes. You can apply various filters, low pass, high pass, Linkwitz transform and even set auto-gain for LT output to not exceed input level. Drivers are simulated in two channels (red, green) which can be compared and amp/box channels can be joined to quick comparison of drivers in same boxes or same amplifier power. Many interesting graps is displayed, SPL, magnitude response, electrical and acoustical, power drawn from amplifier (apparent) and power dissipated in driver (true), voltages and power, EQ'ed or not, and power or excursion limited SPL (not shown)...

Click the image to open in full size.

But I still have the trouble in evaluating box stuffing influence on impedance and especially on Qb and Fb values. I did much on my own but I need your help in evaluating formula to calculate Vb (volume) and Fb (resonance f) with given Qb alignment, for example Q=0,5 or 0,71. It would be easy if there was no box losses taken into account. But they are here and I cannot solve the box electrical model in order to find Vb and fb with given Qb (alignment Q) and Qa (absorbtion)...

If someone evaluate such a formula for me I can even give this spreadsheet to him for free.
Click the image to open in full size.

Last edited by Windforce85; 16th October 2017 at 08:41 PM.
  Reply With Quote
Old 7th November 2017, 10:43 AM   #15
Windforce85 is offline Windforce85  Poland
diyAudio Member
 
Join Date: Nov 2014
Can someone help me on influence of driver's inductance on SPL and excursion? Now it is calculated from purely mechanical box-driver model so it can't take inductance into account. I saw in many software that large inductances makes SPL descending at higher frequencies and 'peaky' around box resonance. How to calculate it? Thanks!
  Reply With Quote

Reply


How to calculate SPL with filters in ExcelHide 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

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to calculate series notch filters merlin el mago Multi-Way 41 14th March 2014 11:47 AM
anyone know how to calculate this?? kendt Construction Tips 2 7th January 2014 08:04 PM
Calculate SPL exuviae Subwoofers 3 5th July 2006 07:51 AM
help ! how to calculate?????????? bogdan_borko Solid State 3 18th January 2006 10:15 PM
EMI ac line filters & RFI ac line filters. Are they one and the same? KevinLee Parts 1 8th January 2003 12:18 AM


New To Site? Need Help?

All times are GMT. The time now is 01:01 PM.


Search Engine Optimisation provided by DragonByte SEO (Pro) - vBulletin Mods & Addons Copyright © 2018 DragonByte Technologies Ltd.
Resources saved on this page: MySQL 15.00%
vBulletin Optimisation provided by vB Optimise (Pro) - vBulletin Mods & Addons Copyright © 2018 DragonByte Technologies Ltd.
Copyright ©1999-2018 diyAudio
Wiki