Here is a handy little Excel spreadsheet I use all the time. Here's what it does:
Calculates the end result of two resistors in parallel.
Calculates the corner frequency of a single pole HP/LP filter.
It's easy to use!
Thanks for the spreadsheet! I'm about to start a 'Software for Techs' class that I believe is mostly based in Excel. I'll try and add anything I come across that could be useful for audio.
Very cool! Thanks for sharing this.
Not sure this is the right place for this or is there a calculator thread, anyways... reverse parallel resistor calculator, you enter you target value and acceptable tolerance % and it spits out all the pairs that satisfy your criteria. I've used this one a lot over the years.
http://www.sengpielaudio.com/calculator-parallel.htm
Thanks for this sheet...
oh btw... if you want to get rid of those #DIV/0! (divided by 0 ) errors toss this formula in there
=IF(ISERROR(1/((1/A3)+(1/B3))),"",1/((1/A3)+(1/B3))) and drag it down for the resistors and this
=IF(ISERROR(1/(6.28*E3*F3)),"",(1/(6.28*E3*F3))) for the caps :-)
Divie errors bug me LOL
thanks again!
Here's an updated version of the Formulas Excel sheet. I've added the following:
LC Filter (inductor/cap filter)
Resistor Drop (for finding the correct resistor value and wattage it requires for a specific voltage drop)
LM317 (for outputting specific voltages based on two resistors with the LM317)
Examples for each in the first row.
Thanks!!! This is really helpful :)
I made a Google Sheets version of this, available without Excel software. Hope it's useful. You can find it here (https://docs.google.com/spreadsheets/d/1-Lj1HM2A51_SqUntL8HsPrKpfJv8HGvfhqbAebOrDtA/edit#gid=0).