![]() ![]() ![]() The first parameter is the real part, the second parameter is the imaginary part, and the "j" specifies the standard engineering complex notation where j = √-1. Excel spreadsheet calculates RC impedance. Now, to set this up in Excel we build a spreadsheet with entries for the R, the C, and a frequency sweep as shown in Figure 2.įigure 2. The derivation of the equations for Z in is shown in Figure 1. The equation for Z in is simply the sum of the impedances of the individual components in series. This is the kind of equivalent circuit you might see for a large value electrolytic bypass capacitor. For example, let's calculate the input impedance of the circuit in Figure 1. The complex function family allows you to work directly with the complex numbers that we need in circuit analysis. The first thing you need to know is how to use Excel's COMPLEX function. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |