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 gain paths to find the difference between the two inputs. |
| op-amp-bandwidth-settling-time.xlsx | Calc and compare bandwidth and settling times for Non-Inverting vs. Inverting Amplfiers. |
| op-amp-voff-ibias-errors.xlsx | How will Voff and Ibias impact your op amp's error? Reduce the error with a simple trick. |
ANALOG DESIGN TOOLKIT
| Topic / Link | Description |
| analog design toolkit1.htm | • 25 Key Analog Circuits & Concepts
• Excel calculations ready for your project • Handy reference of theory & equations |
DIGITAL
| Topic / Link | Description |
| Digital_Basic_Logic_Gates.xlsx | Play and learn basic Logic Gates (AND, OR, NOT, NAND, NOR) using Excel's built-in functions. |
| Digital_Logic_Up_Counters_T_FF.xlsx | Create Up Counters (2 and 3 bit) using a simple T Flip-Flop. |
| Create_8x8_Image_-_BW_Grad,Rect.xlsm | Explore image processing by drawing a rectangle or gray scale gradient. Uses VBA. |
WAVEFORMS & ANALYSIS
| Topic / Link | Description |
| Sine_Wave.htm | Generate sine waves with a simple VBA function. |
| Tri_Wave.htm | Generate triangle waveforms with a simple VBA function. |
| Fourier_Series.htm | Create waveforms by summing multiple sinewaves together (Fourier Series Synthesis) using VBA. |
| FFT_Sinewave.xlsx | Pick a signal frequency, select a sampling frequency, then check out the sampled waveform and FFT spectral plot. |
| create-waveforms-sine-pulse-tri-ramp.xlsm | Create a Pulse Train & Ramp in addition to Sine and Triangle waveforms. |