
Home  Forums  Rules  Articles  diyAudio Store  Gallery  Wiki  Blogs  Register  Donations  FAQ  Calendar  Search  Today's Posts  Mark Forums Read  Search 
Software Tools SPICE, PCB CAD, speaker design and measurement software, calculators 

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 

Thread Tools  Search this Thread 
15th June 2013, 01:28 PM  #1 
diyAudio Member

Using Excel "Solver" for MOSFET SPICE params
Motivated by Pierre Touzelet's 2007 AX article for deriving Triode params with Microsoft Excel, I made a video showing how to use "Graph Grabber" and "Solver" to create basic, level 1 spice params for MOSFETs:
https://www.youtube.com/watch?v=2vh1RbBJa0 The equations in the columns: Id(sat) = (KP/2) * ((Vgsvt)^2)*(1+Lambda*Vds) where KP is mu * Cox * (W/L) I figger "saturation" to be 90% of the current yielded at the maximum Vds for each set of Vgs curves  and test for this. Unsaturated data is thus nulled so that no error term is calculated. Pierre minimized "sum of the squared errors" for triodes. In the case of MOSFETs the saturation currents differ by orders of magnitude so "goodness of fit", "maximizing Rsquareds" were calculated. Rather than simply letting "Solver" do its thing, you might want to manually iterate the approximations to derive params which best suit your application. 
18th June 2013, 11:38 PM  #2 
diyAudio Member

For the linear part of the curve:
Id=KP*((2(VgsVto)*Vds)Vds^2)*(1+ Lambda*Vds) Good at first crack, but Vgs really isn't Vgs as RS gets in the way. What I've done is create an effective Vgs by multiplying the observed drain current by an approximated RS. Then let "Solver" find Vto, kappa, lambda and RS. Now, I'm wondering if it will work! 
19th June 2013, 03:44 PM  #3  
diyAudio Member

Quote:
FWIW, the datasheets and IRF's spice models don't seem to agree except for the first couple of Vgs series above Vto 

20th April 2015, 11:09 PM  #4 
diyAudio Member
Join Date: Dec 2011

Thanks for the work. I'm looking into using this for another FET; would you be able to attach or post a link to the spreadsheet, so that I can understand how you calculate error, etc? Thanks!

Thread Tools  Search this Thread 


Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
Seas Excel W22's in open baffle, need more midbass "oomph"  architect7  MultiWay  23  27th April 2013 07:15 PM 
FS: Excel w15cy (x10), Peerless "XLS 8" (x4), LCY, EMU1820M, TC2+  Archmage  Swap Meet  16  12th February 2012 08:19 AM 
SB Acoustics 6" Params  TurboFC3S  MultiWay  15  20th February 2009 02:43 PM 
FS: Seas Excel TL Home Towers "Thors" Houston/Austin pickup only  kappa546  Swap Meet  15  1st September 2008 04:12 PM 
Marantz imperial 7G 12" TS params  D.A.R.R.Y.L.  MultiWay  0  10th December 2004 07:51 AM 
New To Site?  Need Help? 