Continue to Site

Welcome to our site!

Electro Tech is an online community (with over 170,000 members) who enjoy talking about and building electronic circuits, projects and gadgets. To participate you need to register. Registration is free. Click here to register now.

  • Welcome to our site! Electro Tech is an online community (with over 170,000 members) who enjoy talking about and building electronic circuits, projects and gadgets. To participate you need to register. Registration is free. Click here to register now.

Bode plot for opamp circuit is different depending if LTspice used, or Excel...why?

Status
Not open for further replies.

Flyback

Well-Known Member
Hello,
Please can you advise on why the Bode plot for an opamp circuit is different depending on whether I use LTspice to get it , or when I calculate it in Excel?
(If I do the Bode plots for a simple, passive RC circuit, then they are the same whether I use Excel or LTspice)
The below shows the opamp schematic in question, and the bode plots, plus LTspice simulation.
For example, at 50.31KHz…
Excel gives a gain of -6.74dB & phase of 163 degrees
LTspice gives a gain of –9.202dB & phase of 155 degrees
Also, as you can see, at low frequencies of around 1Hz, the gain and phase are massively different between Excel and LTspice.
The LTspice bode plot is the red one and the phase is a broken line.
Do you know the reason for the differences?
 

Attachments

  • EXCEL _GAIN VS FREQ.jpg
    EXCEL _GAIN VS FREQ.jpg
    43.5 KB · Views: 598
  • EXCEL _PHASE VS FREQ.jpg
    EXCEL _PHASE VS FREQ.jpg
    42.4 KB · Views: 508
  • LTspice_Bode plot.pdf
    34.9 KB · Views: 363
  • Schematic _Type 2_FREQ DOMAIN.pdf
    7 KB · Views: 366
  • Type 2_bode.asc
    1.9 KB · Views: 352
I would question your ability to model an opamp in Excel
 
But the opamp has a massive DC gain......and in any case, when you get above 10Hz or so, the opamp factors just disappear.....and it is just Zfb/Zin.

opamps with feedback have characteristics which don't depend on the opamp parameters..i thought that was the whole poinf of opamps with feedback...the output depends on zfb and zin and not the opamp parameters?
 
By the time you get to your stated frequency of 50kHz, the specific opamp model has a large effect on what happens, as do parasitic capacitances. Sounds like you need to compare three cases: A Spice circuit using an ideal voltage-controlled voltage source, a spice circuit containing a specific opamp model, and an Excel simulation using an ideal voltage-controlled voltage source.
 
Status
Not open for further replies.

Latest threads

New Articles From Microcontroller Tips

Back
Top