Math for Reactive Circuits: Using Excel's Muscle (00i2)

Показать описание

EXCEL FILE LINK BELOW!
The math associated with reactive circuits can be VERY intimidating.
The purpose of this video is to show how we can use Excel's number crunching muscle to perform the the analysis of a simple circuit containing a reactive element (a capacitor).

=== EXCEL FILE LINK (ZIP FILE) ===

----------------------------
00:05 Introductions
01:14 Preparing Excel for the Festivities
01:33 Step 1: Reveal the "Developer" Tab
02:45 Step 2: Install the "Analysis Toolpak"
04:04 Introduction to Excel's Functions for Complex Math
04:16 COMPLEX
04:49 IMAGINARY
05:01 IMREAL
05:11 IMABS
05:29 IMSUB
05:49 IMSUM
06:06 IMDIV
06:24 IMPRODUCT
06:47 Introduction to Our Circuit
09:12 EXCEL: Setting Up Our Spreadsheet
09:33 STEP 1: Setup Cells for the Component Values
10:04 STEP 2: Setup a Column for Frequencies in Hz
10:49 STEP 3: Setup a Column for the Frequency in Radians/Sec
12:11 STEP 4: Setup a Column for the Impedance of Each Component
15:09 STEP 5: Setup a Column for the Complex Voltage Gain
16:30 STEP 6: Setup a Column for the Magnitude of the Voltage Gain
17:06 STEP 7: Setup a Column for the Phase Response
18:50 STEP 8: Setup a Column for the Voltage Gain in dB
19:35 STEP 9: Graphing Your Result
20:30 Final Comments and Toodle-Oots
-----------------------------