数值分析电路并不意味着你要购买昂贵的模拟器。使用 Microsoft ® Excel 的功能，通常可用的工程师的计算机上，很容易你可以很多常见的电路计算。虽然这不会取代你最喜欢的口味，它可以是香料的一个强大的工具，以解决专门的问题，或获得的直觉。Maxim > App Notes > Amplifier and Comparator Circuits
Keywords: PSPICE modeling op amps, op amp SPICE models, non-ideal op amp simulation, circuit analysis, Mar 25, 2003
opamps, opamp
APPLICATION NOTE 1947
Exact Circuit Analysis with Microsoft Excel
Abstract: Analyzing circuits numerically doesn't mean you have to buy an expensive simulator. With the
capabilities of Microsoft Excel, commonly available on engineers' computers, you can easily do many
common circuit calculations. While this won't replace your favorite flavor of SPICE, it can be a powerful tool to
solve a dedicated problem or gain intuition.
Setting up a Simulation
The first thing you need to know is how to use Excel's COMPLEX function. The complex function family allows you
to work directly with the complex numbers th……
