ECE 304 Using PSPICE with WORD and EXCEL Table of Contents Introduction........................................................................................................................6 Creating a Schematic ........................................................................................................6 Figure 1: ....................................................................................................................7 Current mirror schematic. Note the emitter-leg resistors of value RE = 1kΩ.................. 7 Setting Font Sizes on the Schematic ................................................................................7 Figure 2 .....................................................................................................................7 Menu for setting font characteristics and labels for currents and voltages on the schematic........................................................................................................................ 7 Figure 3 .....................................................................................................................8 Menu found in OPTIONS/DESIGN TEMPLATE from the main schematic toolbar................. 8 Running a Q-point Simulation ...........................................................................................8 Figure 4: ....................................................................................................................8 Screen dump of simulation settings for the Q-point simulation. ..................................... 8 Figure 5: ....................................................................................................................9 Screen dump showing how OUTPUT FILE can be accessed from PROBE........................ 9 Figure 6: ....................................................................................................................9 Q-point data for bipolar transistors when applied DC voltage is DC = 12 V. This data has been formatted by copying it from the PSPICE OUTPUT FILE into EXCEL and using the EXCEL menu DATA/TEXT TO COLUMNS ....................................................................... 9 Pasting Schematics into WORD .........................................................................................9 Figure 7: ..................................................................................................................10 Current-mirror circuit..................................................................................................... 10 DC I-V Characteristics of Current Mirror Using PROBE....................................................10 Figure 8: ..................................................................................................................10 Screen dump of simulation settings for DC sweep of global parameter DC ................ 10 Pasting a Probe Plot into Word ...................................................................................10 Figure 9: ..................................................................................................................11 PROBE plot of DC I-V curve for the current mirror in Figure 1 using PASTE SPECIAL/PICTURE (macro Ctrl+P). This figure is not WYSIWYG (what you see is what you get). Compliance voltage label is added in WORD................................................. 11 Figure 10: ................................................................................................................11 PROBE plot for current mirror in Figure 1 using PASTE SPECIAL/DEVICE INDEPENDENT BITMAP (macro Ctrl+D). This figure is WYSIWYG. ....................................................... 11 Pasting PSpice Probe Data into Excel ........................................................................12 Figure 11: ................................................................................................................12 Screen dump from EXCEL showing selection of chart type using the chart wizard. ..... 12 Figure 12: ................................................................................................................13 Example EXCEL chart of the data in Figure 10. ............................................................ 13 Pasting Excel Charts and Tables into Word ................................................................13 DC determination of Norton Resistance: Using PSPICE D() for Derivative......................13 Figure 13: ................................................................................................................13 Reciprocal of derivative of the DC I-V plot of Figure 9 to find the output resistance of the mirror. .....................................................................................................................13 Norton Resistance of Current Mirror: AC Frequency Sweep and Macros.......................14 Figure 14: ................................................................................................................14 Screen dump showing the AC-sweep simulation settings. We sweep frequency on a log scale by DECADE from 1 Hz to 1 GHz. .................................................................... 14 Copyright by John R. Brews Page 1 12/30/01Figure 15: ................................................................................................................15 Screen dump of MACROS menu showing the definition of several macros................... 15 Figure 16: ................................................................................................................15 Norton resistance of current mirror vs. frequency. ....................................................... 15 AC Mirror Current in Response to Sinusoidal Output Voltage: Transient Analysis .........15 Figure 17: ................................................................................................................16 Simulation settings for transient analysis. A parametric sweep of the amplitude of the AC voltage, variable VAMPL is used............................................................................ 16 Figure 18: ................................................................................................................16 Setup for the global parameter VAMPL that determines the amplitude of the sinusoidal voltage across the mirror. A VALUE LIST of three amplitudes is used to get a family of curves.