## Electronic Circuit Design Tools

Beyond the pad and pencil, a tool was needed to learn, explore, verify, document and share circuit designs! Excel was a good choice, not only because it's widelly used, but for its capability. Many topics stretched both my engineering knowledge and Excel skills.

• Play with the input values.

• Discover the effect on the output.

• Expand or customize the file for your own designs.

Op Amps | ||

Calculate gains and voltages of basic Inverting and Non-Inverting amplifier configs. |
||

Calculate positive and negative voltage gains and output voltage. |
||

Convert input current to an output voltage (trans-impedance amp) with offset voltage. |
||

Given amplifier gain and Unity Gain Frequency, find the signal bandwidth and settling time to any percent. |
||

Find op amp output errors due to Input Offset Voltage, both initial and temperture drift errors. |
||

Fnd op amp output errors due to Input Bias Current, both initial and temperture drift errors. |
||

Filters and Networks |
||

Calculate the 1st order magnitude and phase (single pole) of an RC Low Pass Filter on a log frequency scale. |
||

Calculate the 2nd order response (complex conjugate pair of poles) of an RLC LP Fiter. |
||

ADC Input Drivers |
||

How can you translate a Single-Ended +/-5V signal to a Single-Ended 0 to 5V signal of the ADC's input range? This calculator tool shows you how. |
||

Digital Logic |
||

Experiemnt with AND, OR, NOT fucntions, try your own combinations. |
||

Get under the hood of a counter built with T Flip-Flops. Expand it by adding bits. |
||

Noise |
||

What is noise density vs. frequency and Vout (RMS) given a voltage noise source (white) with amplifer (K) of bandwidth (fc)? |
||

Signals |
||

Create waveforms by entering Fourier Series coefficients (VBA code) |
||

Image Processing |
||

Explore Imgae Processing with simple rectangles and gradients using VBA code. |
||

General |
||

Convert a ratio to decibels. |