Appendix: PSpice and Excel Using a Low-pass Filter ExampleAppendix: PSpice and Excel Using a Low-pass Filter ExampleIntroductionProblemAnalysisOrganization of a project in CapturePlacing filesThe project managerNaming filesBack-up of filesE-mail of filesSimulation hierarchy and parts storageSimulation hierarchy and separate simulationsSuperposition of plots from different simulation profilesSummary of file managementPSpice simulation of the designUsing variablesUse of evaluator circuitsSimulation profilesPlots in ProbeSingle-frequency performance analysisMany-frequency performance analysisSummary of PSpice simulationSimulation using PSpice with ExcelVerification using Excel with PSpiceMaking comparisons between formulas and PSpice using ExcelNamed variables in ExcelMaking a plot in ExcelAdding PSpice data to an Excel plotThe "freeze-data" feature and multiple plotsFiltering PSpice dataMaking a worksheet into a functionSummary of use of PSpice with ExcelAdjusting PSpice AccuracyExploring accuracy of the thermal voltageSummary of accuracyOverall summaryReferencesExercisesAppendix: PSPICE and EXCEL Using a Low-pass Filter Example Introduction................................................................................................................................... 2 Problem ........................................................................................................................................ 2 Analysis ........................................................................................................................................ 2 Organization of a project in CAPTURE ........................................................................................... 4 Placing files............................................................................................................................... 4 The project manager................................................................................................................. 5 Naming files .............................................................................................................................. 7 Back-up of files ......................................................................................................................... 7 E-mail of files ............................................................................................................................ 9 Simulation hierarchy and parts storage.................................................................................... 9 Simulation hierarchy and separate simulations........................................................................ 9 Superposition of plots from different simulation profiles......................................................... 12 Summary of file management................................................................................................. 14 PSPICE simulation of the design ................................................................................................. 15 Using variables ....................................................................................................................... 15 Use of evaluator circuits ......................................................................................................... 16 Simulation profiles .................................................................................................................. 16 Plots in Probe ......................................................................................................................... 17 Single-frequency performance analysis ................................................................................. 18 Many-frequency performance analysis................................................................................... 20 Summary of PSpice simulation............................................................................................... 23 Simulation using PSPICE with EXCEL .......................................................................................... 24 Verification using Excel with PSpice....................................................................................... 24 Making comparisons between formulas and PSpice using Excel .......................................... 25 Named variables in Excel ....................................................................................................... 25 Making a plot in Excel............................................................................................................. 26 Adding PSpice data to an Excel plot ...................................................................................... 32 The "freeze-data" feature and multiple plots .......................................................................... 33 Filtering PSpice data............................................................................................................... 37 Making a worksheet into a function ........................................................................................ 38 Summary of use of PSpice with Excel.................................................................................... 39 Adjusting PSPICE Accuracy ........................................................................................................ 40 Exploring accuracy of the thermal voltage.............................................................................. 41 Summary of accuracy .............................................................................................................43 Overall summary ........................................................................................................................ 44 References ................................................................................................................................. 44 Exercises.................................................................................................................................... 44 Copyright by John R Brews Page 1 6/24/2003Appendix: PSPICE and EXCEL Using a Low-pass Filter Example Introduction Although an introduction to the detail of PSPICE and EXCEL is not an objective of the book, we need a description of a few features that play a prominent role. Just to be concrete, these features are described using a very simple low-pass filter. Here is the example. Problem For a source of known source resistance RS, design a