SPICE Transformer Model Spreadsheet - diyAudio
Go Back   Home > Forums > Amplifiers > Tubes / Valves

Tubes / Valves All about our sweet vacuum tubes :) Threads about Musical Instrument Amps of all kinds should be in the Instruments & Amps forum

Please consider donating to help us continue to serve you.

Ads on/off / Custom Title / More PMs / More album space / Advanced printing & mass image saving
Reply
 
Thread Tools Search this Thread
Old 21st January 2011, 03:21 PM   #1
diyAudio Member
 
Join Date: May 2005
Location: Stittsville, Ontario, Canada
Default SPICE Transformer Model Spreadsheet

Some time ago I posted a spreadsheet for generating the parameters for a transformer SPICE model. I have received some recent emails asking questions about it, and I have also seen the recent post from pweaudiotech with his spreadsheets. This has jogged my memory and made me remember that I made a much improved version over a year ago.

It generates the SPICE model as well a just the parameters.
It will generate models for single ended, push pull, ultralinear, with or without multiple speaker taps.

Use is simple, instructions are included on the first sheet of the spreadsheet.

Attached is a screen shot showing the simplest case, a SE transformer with a single output. The xls file (zipped) is also attached.

The usual caveats apply :
This is a model, reality will be slightly different.
It does not model core effects ie saturation etc.

The parameters I have listed for various transformers may or may not be accurate, I have taken them from data sheets, from websites, from wherever, and in some cases where information was not available, just guessed. So put whatever numbers you think best in here.
Also, in some cases I have added multiple speaker taps to transformers that dont really have them, just to play around with them.
Attached Images
File Type: jpg ScreenShot.jpg (133.7 KB, 960 views)
Attached Files
File Type: zip Transformer Models Rev4.zip (72.3 KB, 790 views)
__________________
Robert McLean
  Reply With Quote
Old 1st February 2012, 10:15 PM   #2
diyAudio Member
 
Join Date: Feb 2012
Default Thanks a lot!

Thank you very much for this interesting and helpful model.

Best regards,
Jose Angel Jimenez
  Reply With Quote
Old 18th February 2012, 05:15 PM   #3
jakruby is offline jakruby  South Africa
diyAudio Member
 
Join Date: Jun 2007
sorry to sound foolish but how does one create the model in LTSpice?
  Reply With Quote
Old 18th February 2012, 08:34 PM   #4
diyAudio Member
 
payloadde's Avatar
 
Join Date: Mar 2008
Quote:
Originally Posted by jakruby View Post
sorry to sound foolish but how does one create the model in LTSpice?
Transformer Models

How do I build a transformer model?

The best way would be to draft a model with coupled inductors
with a mutual inductance statement placed as a SPICE directive
on the schematic. See the section on mutual Inductance for more
information. Inductors participating in a mutual inductance
will be drawn with a phasing dot.

The following example demonstrates a transformer with 1:3 turns
ratio (one to nine inductance ratio) with a sine wave input and
simulates for 0.1ms. The K is set to 1 to model a transformer
with no leakage inductance.

see page 185 of the manual: http://ltspice.linear.com/software/scad3.pdf
Attached Images
File Type: jpg Clipboard01.jpg (34.4 KB, 611 views)
__________________
Judge: This court appreciates that you invented physics, Mr.Newton, but unfortunately you can't have a patent on it.
  Reply With Quote
Old 18th February 2012, 08:52 PM   #5
diyAudio Member
 
Join Date: Jan 2002
Location: nowhere
Thanks man! Great work.
oh...
  Reply With Quote
Old 18th February 2012, 08:58 PM   #6
jakruby is offline jakruby  South Africa
diyAudio Member
 
Join Date: Jun 2007
sorry i understand how to define simple transformers as you have just posted but i meant how do i create the model to use with one of the transformers from robert maclean's spreadsheet. specifically how do i name the resistors 'Rp1' & inductors 'Ls1' etc to match the model text. i tried putting the value of the resistor as 'Rp1" but i get a "Can't find definition of model "RP1"" message.
  Reply With Quote
Old 18th February 2012, 09:56 PM   #7
diyAudio Member
 
payloadde's Avatar
 
Join Date: Mar 2008
Why don't you just add a normal R in series with L and give it the value calculated from spreadsheet
or right-klick on L and fill in the calculated value of R as <Series Resistance>
__________________
Judge: This court appreciates that you invented physics, Mr.Newton, but unfortunately you can't have a patent on it.
  Reply With Quote
Old 18th February 2012, 10:00 PM   #8
diyAudio Member
 
Join Date: Jan 2002
Location: nowhere
Quote:
Originally Posted by jakruby View Post
sorry i understand how to define simple transformers as you have just posted but i meant how do i create the model to use with one of the transformers from robert maclean's spreadsheet. specifically how do i name the resistors 'Rp1' & inductors 'Ls1' etc to match the model text. i tried putting the value of the resistor as 'Rp1" but i get a "Can't find definition of model "RP1"" message.
I havent tried yet, but isn't it just to copy the blue text in the worksheet into a 'spice directive' and stick that into the schem?
  Reply With Quote
Old 18th February 2012, 10:19 PM   #9
diyAudio Member
 
Join Date: Jan 2002
Location: nowhere
hmmm...I just tried and I also have trouble getting it to work. I drew up an exact replica of the transformer schem, and inserted the spice directive, and get 'Rp1: Missing resistance value.'
Of course I could type all values in manually, but that kinda makes the spreadsheet useless doesn't it?
  Reply With Quote
Old 18th February 2012, 10:19 PM   #10
gootee is offline gootee  United States
diyAudio Member
 
Join Date: Nov 2006
Location: Indiana
Blog Entries: 1
Quote:
Originally Posted by jakruby View Post
sorry i understand how to define simple transformers as you have just posted but i meant how do i create the model to use with one of the transformers from robert maclean's spreadsheet. specifically how do i name the resistors 'Rp1' & inductors 'Ls1' etc to match the model text. i tried putting the value of the resistor as 'Rp1" but i get a "Can't find definition of model "RP1"" message.
In LTSpice, you could use {Rp1} for the resistor's value and then have a .param spice directive to define Rp1, like .param Rp1=27.

There is a very good paper about modeling transformers, at :

http://www.onsemi.com/pub_link/Collateral/AN1679-D.PDF

Based on that paper, I made a spice model for a two-winding transformer for which you only need to insert simple measurements, and spice calculates the model parameters. It can be downloaded from here:

Spice Component and Circuit Modeling and Simulation
  Reply With Quote

Reply


Hide this!Advertise here!
Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Transformer SPICE Excel Spreadsheet pweaudiotech Software Tools 22 25th April 2014 12:50 PM
spice model for UL output transformer? docali Tubes / Valves 30 5th May 2013 12:52 AM
Power Transformer Spice Model classd4sure Power Supplies 3 20th July 2006 03:50 PM
output transformer spice model Paracelsus Tubes / Valves 6 9th September 2005 02:52 PM
SPICE model Prune Parts 6 16th October 2004 03:22 PM


New To Site? Need Help?

All times are GMT. The time now is 04:12 PM.


vBulletin Optimisation provided by vB Optimise (Pro) - vBulletin Mods & Addons Copyright © 2014 DragonByte Technologies Ltd.
Copyright 1999-2014 diyAudio

Content Relevant URLs by vBSEO 3.3.2