Simulate circuits in a spreadsheet with some 'ladderal thinking'
April 23, 2010 | Kendall Castor-Perry | 222900659
Kendall Castor-Perry explains how to use a ladder analysis technique to simulate circuits in a spreadsheet
Page 1 of 5Click here to see all articles by Analog Guru Kendall Castor-Perry
So, filter fans, I hope you tried out my recent spreadsheet-modified simulation schematic method (Excel tunes up your schematic files). Its a nice way of creating small circuit chunks with calculated component values, especially when the sums cant be carried out using the math capabilities of your simulators preprocessor.
But say you now need to adjust component values to achieve some system goal, such as frequency response or predefined time behaviour, and theres no closed method for working out those values. You have to spend quite a bit of money to get proper circuit optimization features in a SPICE-compatible simulator; none of the free or affordable packages support it (QUCS looks intriguing, but its SPICE compatibility is very poor). And in todays busy world, its hard to find the time to write bespoke analysis and optimization programs. I count myself lucky that I had to do lots of that in the past because its such a good way of learning about practical circuit calculations.
In An Excelent Fit, Sir! we saw that the Solver tool in a spreadsheet can mold the
coefficients of a factorized transfer function to fit a frequency response specification. Thats useful if you can define the transfer function first, and then implement it with a suitable topology. Now, if youre comfortable turning transfer functions into component values and interconnections, then congratulations, youre a filter designer!
Lets assume, though, that this time youve got to optimize the response of an existing circuit without altering the topology, and that it isnt a simple cascade of second-order biquad blocks. Maybe its like Figure 1 the bandpass filter from
Please login to post your comment - click here
- No news
MOST POPULAR NEWS
- Slideshow: Top 10 sensor trends to follow
- Slideshow: Twelve shakers and movers in MEMS
- NXP staff strike for more pay
- Tech-based firm makes fun of engineers - not cool
- Google prototypes depth-sensing mobile phone
- VTT develops printable e-nose sensor
- The future of video surveillance is hyperspectral
- Integrated analog: what's missing?
- Microsoft preps next time-of-flight sensor for Kinect
- Opinion: the hyperspectral era has already begun
- Piezo-nanowires boost fingerprint resolution
- Top ten CMOS image sensor vendors ranked
- Qualcomm leads, Intel lags in smartphone processor market
- Covidien to swallow pill camera firm
- Depth-sensing image sensor array touted for smartphones
- Hall-Effect Sensor ICs for Motor Control
- Improving Voltage Regulation without Remote Sense Wires
- Mixed Signal Design and Verification for complex SoCs
- An Introduction to Rigid-Flex PCB Design Best Practices
- 4-20 mA, Loop Powered, Thermocouple System Using ARM
- EMC Compliant RS-485 Transceiver Protection Circuits
- Isolated 4-Channel, Thermocouple/RTD Temperature Measurement System with 0.5Â°C Accuracy