Excel Design Calc Series
Design Tools
- Save time with complex circuit calculations and documention.
- Learn cool Excel techniques for engineering.
- Use as templates - copy, modify for other circuits / designs.
Excellent for hands-on EE learning!
- Change a value, predict the outcome, see what happens!
- Develop intuitition and reinforce theory and equations.
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 FILTERS
| Topic / Link | Desciption | File Type |
| RC Low Pass Filter vs Freq | Find the Magnitude (dB) and Phase of an RC Filter using standard Built-In Functions. | *.xlsx |
OP AMPS
| Topic / Link | Desciption | File Type |
| Op Amp Gain and Bandwidth | A simple example to get familiar with both Op Amp gain calculations and VBA code. BONUS: explore how gain effects bandwidth! (VBA Code) | *.xlsm |
SIGNAL PROCESSNG
| Topic / Link | Desciption | File Type |
| Sine Wave Generator | Generate sine waves varying the frequency, amplitude, phase and offset. (VBA Code) | *.xlsm |
| Create waveforms with the Fourier Series | Create square waves, sawtooths, etc., using only sine waves. Enter coefficients and watch waveforms take shape. (VBA Code) | *.xlsm |