1 / 16

Excel for Circuit Design: Build Confidence and Verify with SPICE

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.

melsonj
Download Presentation

Excel for Circuit Design: Build Confidence and Verify with SPICE

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Proposed Design Flow • Analysis • Get concepts organized • Spreadsheet • Graph what formulation means • PSPICE • Verify spreadsheet and formulation • Build circuit • What is missing in simulation?

  2. 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

  3. Problems of Design • Confidence: algebra right? • Visualization: what’s going on? • PSPICE “magic”: what’s it doing? • Design?? Buried

  4. Fix • Derive equations • Put in EXCEL • Graph design tradeoffs • Verify with PSPICE • Immediate design verification

  5. Example • Design of CE Amp • Determine resistors • Meet specs

  6. Spreadsheet Set-up

  7. Data Input

  8. Equations as Algebra Formula Box using NAMED variables

  9. Tradeoff Plots Optimize design graphically

  10. Tradeoff Plots

  11. Change Input Immediate Update

  12. Paste Data into PSPICE Paste EXCEL PSPICE

  13. Verification using PSPICE

  14. Process • Is spreadsheet working? • No? - formulas wrong? • If formulas wrong - concept wrong? • Fix concept • Fix formula • Fix spreadsheet

  15. 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

  16. Web Page for Details

More Related