Author Topic: Excel Calculator  (Read 1839 times)

madbean

  • Administrator
  • Electron Doctor
  • *****
  • Posts: 7535
  • Brian
    • View Profile
Excel Calculator
« on: December 18, 2014, 08:00:12 AM »
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!

I own madbeanpedals (duh). I am part owner of Function F(X).

sonarchotic

  • Solder Ninja
  • ****
  • Posts: 371
  • Noth Cackalaky
    • View Profile
Re: Excel Calculator
« Reply #1 on: December 18, 2014, 08:16:12 AM »
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.
« Last Edit: December 18, 2014, 05:16:18 PM by sonarchotic »

Leevibe

  • Electron Doctor
  • *****
  • Posts: 2144
  • Lee
    • View Profile
Re: Excel Calculator
« Reply #2 on: December 18, 2014, 08:25:40 AM »
Very cool! Thanks for sharing this.
my website - Formula Electronics

davent

  • Electron Doctor
  • *****
  • Posts: 1902
  • Hamilton ON
    • View Profile
Re: Excel Calculator
« Reply #3 on: December 21, 2014, 11:04:46 PM »
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
"If you always do what you always did- you always get what you always got." - Unknown

If my photos are missing again... they're hosted by photobucket... and as of 06/2017 being held hostage... to be continued?

jalmonsalmon

  • Stompbox Star
  • ***
  • Posts: 196
  • John
    • View Profile
Re: Excel Calculator
« Reply #4 on: December 24, 2014, 01:47:03 PM »
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!
Information is not knowledge
Knowledge is not wisdom
Wisdom is not truth
Truth is not beauty
Beauty is not love
Love is not music
Music is THE BEST . .

madbean

  • Administrator
  • Electron Doctor
  • *****
  • Posts: 7535
  • Brian
    • View Profile
Re: Excel Calculator
« Reply #5 on: September 08, 2017, 06:54:22 PM »
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.
I own madbeanpedals (duh). I am part owner of Function F(X).

Lubdar

  • Solder Ninja
  • ****
  • Posts: 257
    • View Profile
Re: Excel Calculator
« Reply #6 on: September 08, 2017, 09:30:50 PM »
Thanks!!! This is really helpful :)
(--c^.^)--c