Excel Calc Overview

 

Here's one approach (of many possibilities) to implement an EBA using Excel.

Back to EBA Series

 

GOALS

• What are reasonable goals for an EBA in a spreadsheet?
  • Straightforward to enter data, formulas and read results.
  • Easy to review and debug.
  • Scalable to larger circuits and systems.
  • Modular for reuse in other designs.
  • Customizable for various specification and error types.
• Many possible ways to implement!
• Modify, adjust for your applications.

 

3 WORKSHEETS

• OFFSET, GAIN and CIRCUIT Sheets
• Avoids confusing worksheets; creates smaller, manageable formulas.

 

CIRCUIT CALC

• For a specific circuit block, calculates
  • Signal Gains
  • Offset Sensitivities
  • Gain Sensitivities

OFFSET & GAIN ERROR SHEETS

• Enter Design Spec
  • Max Offset or Gain Error (Error Budget)
• Calc Errors
  • Enter all Error Sources
  • Get Sensitivities from Calc sheet.
  • Calculate Errors
• Calc Total Errors – WCA and RSS
• PASS if Total < Spec!

 

NEXT UP

Time to take a basic amplifier and then walk it through an Excel EBA.

Back to EBA Series