EBA Using Excel - 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 CALC Sheets
• Avoids confusing worksheets; creates smaller, manageable formulas.
• Easier to create, review, debug and resuse.

 

CALC SHEET

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

 

OFFSET / GAIN ERROR SHEETS

• Enter Design Spec
  • Offset or Gain Error
  • Relevant Conditions
• Calc Errors
  • Enter all Error Sources
  • Get Sensitivities from Calc sheet.
  • Calculate Errors
• Calc Total Errors – WCA and RSS
• Compare Totals to Spec.

 

NEXT UP

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

Back to EBA Series