Last time I showed you how to set up a reasonably complex design in a spreadsheet: a common emitter bipolar transistor amplifier. Having the design in a spreadsheet makes it easy to do “what if” scenarios and see the effects on the design almost immediately. Another advantage that spreadsheets offer…
Source: Optimizing the Spread: More Spreadsheet Circuit Design Tricks