170 likes | 205 Views
Learn how to organize design concepts, develop formulas in Excel, verify with PSPICE, and build circuits for immediate verification. Discover the advantages of using Excel for graphical tradeoff analysis and why it boosts students' design confidence. Fix incorrect formulas by understanding underlying concepts. Enhance your design skills and satisfaction by creating interactive, self-paced designs with Excel.
E N D
Proposed Design Flow • Analysis • Get concepts organized • Spreadsheet • Graph what formulation means • PSPICE • Verify spreadsheet and formulation • Build circuit • What is missing in simulation?
Using EXCEL • Why use a spreadsheet? • Get students into design • Promote confidence in abilities • Why EXCEL? • Everybody's got OFFICE • Easy to use - it's a spreadsheet • Can program, if must - VBA
Problems of Design • Confidence: algebra right? • Visualization: what’s going on? • PSPICE “magic”: what’s it doing? • Design?? Buried
Fix • Derive equations • Put in EXCEL • Graph design tradeoffs • Verify with PSPICE • Immediate design verification
Example • Design of CE Amp • Determine resistors • Meet specs
Equations as Algebra Formula Box using NAMED variables
Tradeoff Plots Optimize design graphically
Change Input Immediate Update
Paste Data into PSPICE Paste EXCEL PSPICE
Process • Is spreadsheet working? • No? - formulas wrong? • If formulas wrong - concept wrong? • Fix concept • Fix formula • Fix spreadsheet
Advantages of EXCEL • Builds confidence in skills • Satisfaction – built a working tool • Interest through interactivity • Self-paced • Design up front and visual • Easy exploration of design