REGISTER | LOGIN
Home    Bloggers    Blogs    Article Archives    Messages    About Us   
Tw  |  Fb  |  In  |  Rss
Excel Tunes Up your Schematic Files
5/9/2019

< Previous   Image 5 of 11      Next >

Figure 3
Click here for larger image 
Change cell contents from text into formulae that reference values.

Click here for larger image

Change cell contents from text into formulae that reference values.

< Previous   Image 5 of 11      Next >

Return to Article

TucsonMike
TucsonMike
5/15/2019 8:54:53 AM
User Rank
Blogger
Linking LTSpice to Excel
Hey Kendall, 

 

Very nice article and useful linking of LTSpice to Excel. You must have a lot of fun with this kind of capability. 

50%
50%
Who Knew
Who Knew
5/13/2019 11:01:05 AM
User Rank
Newbie
Excellent!
Also worth noting, LTspice lets you parameterize component values directly from within LTspice.  You can set up conditions that drive a calculated value prior to simulation.   There's also quite a good Yahoo group dedicated to all things LTspice.  

50%
50%
More Blogs from The Filter Wizard Remastered
There’s a further cool thing you can do with a spreadsheet that most SPICEs can’t. That’s to use the spreadsheet ‘solver’ functionality to adjust component values in the search for a better-fitting circuit – or even to find a set of component values for a circuit you can’t otherwise design.
You now need to adjust component values to achieve some system goal, such as predefined frequency response or time behaviour, and there’s no closed method for working out those values.
The required selectivity of a customer design implied four-pole filters with about 10% bandwidth (passband width about 10% of the centre frequency). There was a catch---a tight power budget
Now, our customer doesn’t want to buy big, expensive, high quality capacitors to build an active filter with this response. So, having established the principle of optimizing in the analogue domain, let’s look at whether need to make any changes in order to use it to create a digital filter – which we’ll be able to implement on the Cypress PSoC 3
flash poll
educational resources
 
follow Planet Analog on Twitter
Planet Analog Twitter Feed
like us on facebook
our partners
Planet Analog
About Us     Contact Us     Help     Register     Twitter     Facebook     RSS