Excel Design Calculators

 

Design Tools

• Learn Excel techniques for circuit design.
• Save time with ready-to-run files.
• Copy sections / sheets for your own circuits as needed.

Excellent for hands-on EE learning!

• Change a value, predict the outcome, see what happens!
• Develop intuitition for theory and equations.
  

Design Notes

• Handy circuit notes.
• Learn Excel strategy: formulas, built-in functions, VBA code.
   

NOTE! Windows may block a macro-enabled file (*.xlsm) from running - Good Precaution! To unblock, right-click on file, select Properties - Security and then check UNBLOCK.

  

ANALOG

Topic / Link	Description
RC-low-pass-filter-vs-f.xlsx	Find an RC Filter's (1st order) Magnitude (dB) and Phase using Excel's standard built-in functions.
LCR-low-pass-filter-vs-f.xlsx	Calculate an LC Filter's (2nd order) Magnitude (dB) and Phase using Excel's complex functions - IMSUM(), IMPRODUCT(), IMDIV(), etc.
thermistor-vs-temp-linearize.xlsx	Find the highly-nonlinear Thermistor resistance vs. T. Then linearize the voltage with a simple series resistor.
ratio-perc-ppm-bits-dB.xlsx	Convert easily between units of ratio, percent, ppm, bits and dB.

 

OP AMPS

Topic / Link	Description
op-amp-gain-basic.xlsx	Find the gains and output of the Non-Inverting and Inverting Amplfiers.
op-amp-diff-amp.xlsx	Calc the Diff Amp's pos and neg paths to find the difference between the two input voltages.
op-amp-bandwidth-settling-time.xlsx	Calc and compare bandwidth and settling times for Non-Inverting vs. Inverting Amplfiers.