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
- Plan to re-open Rousset fab requires investors
- Micron Italian job cuts get global criticism
- Memory, firms, fabless climb chip vendor ranking
- European Commission intervenes in Micron Italian jobs case
- S3 preps DAC product with a twist
- The Filter Wizard: on being analog AND open
- Samsung leads chip capex ranking
- Opinion: Europe must back the Rousset Phoenix
- MEMS, magnetics set to lead sensor market rebound
- Startup launches record resolution 150Mpixel sensor
- What is an ampere?
- Samsung drives MEMS combo sensor market up, ST benefits
- Mentor buys Berkeley DA after Cadence lawsuit
- Jobs saved at Micron Italy, say reports
- Will China Conquer MEMS?
- Sensor Hardware Technology Overview
- 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