Summary
Keywords
Full Transcript
Welcome to electrical engineering - with Excel. This is a series of videos, to help you make excel workbooks, for various electrical engineering problems, and circuit calculators. In this video, we will explore the use of Excel, with Laplace transforms, and working in the S-domain. We will generate a magnitude and phase plot of a simple 1-pole resistor-capacitor low pass filter. The Excel workbook for a simple RC Low Pass Filter https://github.com/oldhackEE/Electrical-Engineering-With-Excel/blob/dfce7df97ffef72fa5958fdc6253895c71ff4f03/s-Domain%20-%20RC%20Low%20Pass%20Filter%20Complete.xlsm 0:00 Introduction 01:36 Laplace Transform Review 3:37 Transfer Function of Low-Pass RC Filter Example 05:14 Logarithmically Spaced Frequency Points 07:25 Making the Complex Variable s 09:15 Using Excel Imaginary Functions 10:26 Making the Transfer Function 12:08 Calculating the Magnitude 12:35 Create the Magnitude Plot 14:11 Create the Phase Plot Correction: 3:48 Formula should be eo/ei = (1/sc)/(R+1/sc) Electrical Engineering With Excel Laplace Transforms Bode Plots Excel Imaginary Functions IMSUM IMSUB IMPRODUCT IMDIV IMPOWER IMABS IMARGUMENT
