170 likes | 204 Views
Proposed Design Flow. Analysis Get concepts organized Spreadsheet Graph what formulation means PS PICE Verify spreadsheet and formulation Build circuit What is missing in simulation?. Using E XCEL. Why use a spreadsheet? Get students into design Promote confidence in abilities
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