Transformer SPICE Excel Spreadsheet

pweaudiotech · 11:11 PM

I spent the last few days designing a Transformer SPICE Excel Spreadsheet. It allows user to experiment with various Transformer Ratios as well as Generate a very basic SPICE Subcircuit File (Filename: XFRMR.CIR). Default location of the Generated Subcircuit File is My Documents.

DOWNLOAD URL:
xfrmcalc.xls - File Shared from Box.net

AndrewT · 8th January 2011, 10:09 AM

Hi PW,
unlock the data input cells. Use CTRL+mouse right click to select multiple non contiguous cells.
Protect the sheet. You can use "blank" as the nil password and that allows anyone to unprotect the sheet, if they feel the need to alter or add to your spreadsheet. This protection saves a new user from corrupting your spreadsheet.

Reload your spreadsheet.

pweaudiotech · 10th January 2011, 02:32 AM

I have done some editing of the Transformer SPICE Excel Spreadsheet. I also password protected the Workbook (includes worksheet xfrmcalc.xls). I established a new 'link' for the TRANSFORMER RATIO CALCULATOR AND SPICE SUBCIRCUIT GENERATOR EXCEL SPREADSHEET
xfrmcalc.xls at: xfrmcalc.xls

andrewlebon · 10th January 2011, 02:47 AM

hi pweaaudiotech
greetings can it be used to design simple torridal transformers
is there any software to design torridals
thanking you
andrew lebon

pweaudiotech · 03:21 PM

Here are 3 of my recent designs...Excel Spreadsheets to help with SPICE File Creation for Diodes, Transformers and Transistors. All of these are in the early stage of development. Although functional they do require that Parameters are entered manually.

MAIN FOLDER (CONTAINS SPREADSHEETS):
CALCXLS

Folder URL:
CALCXLS

DIODE SPICE MODEL FILE GENERATOR EXCEL SPREADSHEET
diodecalc.xls
Download URL:
diodecalc.xls

TRANSFORMER RATIO CALCULATOR AND SPICE SUBCIRCUIT GENERATOR EXCEL SPREADSHEET
xfrmcalc.xls
Download URL:
xfrmcalc.xls

TRANSISTOR SPICE MODEL FILE GENERATOR EXCEL SPREADSHEET
xstrcalc.xls
Download URL:
xstrcalc.xls

AndrewT · 11th January 2011, 03:38 PM

why do the excell (read only) displays not fill out to the edges?
unprotect workbook does not accept blank (nil) entry.

pweaudiotech · 12th January 2011, 11:30 AM

The protect/unprotect password for each workbook is same as name of the workbook: diodecalc, xfrmcalc, xstrcalc. If you desire to change the display to show greater accuracy (more decimal places) this is easily done by accessing the "number" function oh the taskbar and altering it to customize...

pweaudiotech · 14th January 2011, 07:52 AM

Tips on operating CALCXLS Worksheets...
You must have Formula Calculations set to Automatic for Calculations to occur as such.
You must have VBA (Visual Basic for Applications) installed for the Print Feature to operate.

pweaudiotech · 10:36 AM

Updated CALCXLS Group:

(MAIN FOLDER)
CALCXLS
Main Folder URL:
CALCXLS

***DIODE SPICE MODEL FILE GENERATOR EXCEL SPREADSHEET
diodecalc.xls (worksheet protect/unprotect password: diodecalc)
Download URL:
diodecalc.xls

ELECTRONICS CALCULATOR EXCEL SPREADSHEET
eleccalc.xls (worksheet protect/unprotect password: eleccalc)
Download URL:
eleccalc.xls

INDUCTOR/TRANSFORMER PARAMETER CALCULATOR EXCEL SPREADSHEET
indcalc.xls (worksheet protect/unprotect password: indcalc)
Download URL:
indcalc.xls

***TRANSFORMER RATIO CALCULATOR AND SPICE SUBCIRCUIT GENERATOR EXCEL SPREADSHEET
Download URL:
xfrmcalc.xls (worksheet protect/unprotect password: xfrmcalc)
xfrmcalc.xls
NOTE: SPICE Subcircuit File Generated is Now Named: XFRM1SEC.CIR

***TRANSISTOR SPICE MODEL FILE GENERATOR EXCEL SPREADSHEET
xstrcalc.xls (worksheet protect/unprotect password: xstrcalc)
Download URL:
xstrcalc.xls

After Download 'Right Mouse Button Click' On the File and Go to Properties and 'Unblock' File If You Wish To Edit...

***(These Worksheets require that you have VBA [Visual Basic for Applications] for Excel Installed in order to access the Print Feature)

pweaudiotech · 17th January 2011, 08:00 AM

Updated CALCXLS Group:

(MAIN FOLDER)
CALCXLS
Main Folder URL:
CALCXLS

CLASS A TRANSISTOR AMPLIFIER CALCULATOR EXCEL SPREADSHEET
Download URL:
ampcalc.xls (worksheet protect/unprotect password: ampcalc)
ampcalc.xls

***DIODE SPICE MODEL FILE GENERATOR EXCEL SPREADSHEET
Download URL:
diodecalc.xls (worksheet protect/unprotect password: diodecalc)
diodecalc.xls

ELECTRONICS CALCULATOR EXCEL SPREADSHEET
Download URL:
eleccalc.xls (worksheet protect/unprotect password: eleccalc)
eleccalc.xls

INDUCTOR/TRANSFORMER PARAMETER CALCULATOR EXCEL SPREADSHEET
Download URL:
indcalc.xls (worksheet protect/unprotect password: indcalc)
indcalc.xls

***TRANSFORMER RATIO CALCULATOR AND SPICE SUBCIRCUIT GENERATOR EXCEL

SPREADSHEET
Download URL:
xfrmcalc.xls (worksheet protect/unprotect password: xfrmcalc)
xfrmcalc.xls

***TRANSISTOR SPICE MODEL FILE GENERATOR EXCEL SPREADSHEET
Download URL:
xstrcalc.xls (worksheet protect/unprotect password: xstrcalc)
xstrcalc.xls

***(These Worksheets require that you have VBA [Visual Basic for Applications] for Excel Installed in order to access the Print Feature)

6th January 2011, 11:09 PM	#1
pweaudiotech diyAudio Member Join Date: Feb 2008	Transformer SPICE Excel Spreadsheet I spent the last few days designing a Transformer SPICE Excel Spreadsheet. It allows user to experiment with various Transformer Ratios as well as Generate a very basic SPICE Subcircuit File (Filename: XFRMR.CIR). Default location of the Generated Subcircuit File is My Documents. DOWNLOAD URL: xfrmcalc.xls - File Shared from Box.net Last edited by pweaudiotech; 6th January 2011 at 11:11 PM.

11th January 2011, 03:19 PM	#5
pweaudiotech diyAudio Member Join Date: Feb 2008	Here are 3 of my recent designs...Excel Spreadsheets to help with SPICE File Creation for Diodes, Transformers and Transistors. All of these are in the early stage of development. Although functional they do require that Parameters are entered manually. MAIN FOLDER (CONTAINS SPREADSHEETS): CALCXLS Folder URL: CALCXLS DIODE SPICE MODEL FILE GENERATOR EXCEL SPREADSHEET diodecalc.xls Download URL: diodecalc.xls TRANSFORMER RATIO CALCULATOR AND SPICE SUBCIRCUIT GENERATOR EXCEL SPREADSHEET xfrmcalc.xls Download URL: xfrmcalc.xls TRANSISTOR SPICE MODEL FILE GENERATOR EXCEL SPREADSHEET xstrcalc.xls Download URL: xstrcalc.xls Last edited by pweaudiotech; 11th January 2011 at 03:21 PM.

16th January 2011, 10:26 AM	#9
pweaudiotech diyAudio Member Join Date: Feb 2008	Updated CALCXLS Group: (MAIN FOLDER) CALCXLS Main Folder URL: CALCXLS *DIODE SPICE MODEL FILE GENERATOR EXCEL SPREADSHEET diodecalc.xls (worksheet protect/unprotect password: diodecalc) Download URL: diodecalc.xls ELECTRONICS CALCULATOR EXCEL SPREADSHEET eleccalc.xls (worksheet protect/unprotect password: eleccalc) Download URL: eleccalc.xls INDUCTOR/TRANSFORMER PARAMETER CALCULATOR EXCEL SPREADSHEET indcalc.xls (worksheet protect/unprotect password: indcalc) Download URL: indcalc.xls TRANSFORMER RATIO CALCULATOR AND SPICE SUBCIRCUIT GENERATOR EXCEL SPREADSHEET Download URL: xfrmcalc.xls (worksheet protect/unprotect password: xfrmcalc) xfrmcalc.xls NOTE: SPICE Subcircuit File Generated is Now Named: XFRM1SEC.CIR TRANSISTOR SPICE MODEL FILE GENERATOR EXCEL SPREADSHEET xstrcalc.xls (worksheet protect/unprotect password: xstrcalc) Download URL: xstrcalc.xls After Download 'Right Mouse Button Click' On the File and Go to Properties and 'Unblock' File If You Wish To Edit... (These Worksheets require that you have VBA [Visual Basic for Applications] for Excel Installed in order to access the Print Feature) Last edited by pweaudiotech; 16th January 2011 at 10:36 AM.*

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Easy Horn Excel Spreadsheet	soho54	Subwoofers	55	20th March 2013 08:02 PM
An Excel spreadsheet for DIY Tonearm's Effective Mass Calculation.	Padel	Analogue Source	16	7th April 2011 07:48 AM
Log Faker's Excel Spreadsheet HERE!	Stocker	Parts	0	25th October 2006 01:58 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


	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

8th January 2011, 10:09 AM	#2
AndrewT diyAudio Member Join Date: Jul 2004 Location: Scottish Borders	Hi PW, unlock the data input cells. Use CTRL+mouse right click to select multiple non contiguous cells. Protect the sheet. You can use "blank" as the nil password and that allows anyone to unprotect the sheet, if they feel the need to alter or add to your spreadsheet. This protection saves a new user from corrupting your spreadsheet. Reload your spreadsheet.

10th January 2011, 02:32 AM	#3
pweaudiotech diyAudio Member Join Date: Feb 2008	I have done some editing of the Transformer SPICE Excel Spreadsheet. I also password protected the Workbook (includes worksheet xfrmcalc.xls). I established a new 'link' for the TRANSFORMER RATIO CALCULATOR AND SPICE SUBCIRCUIT GENERATOR EXCEL SPREADSHEET xfrmcalc.xls at: xfrmcalc.xls

10th January 2011, 02:47 AM	#4
andrewlebon diyAudio Member Join Date: Feb 2008	hi pweaaudiotech greetings can it be used to design simple torridal transformers is there any software to design torridals thanking you andrew lebon

11th January 2011, 03:38 PM	#6
AndrewT diyAudio Member Join Date: Jul 2004 Location: Scottish Borders	why do the excell (read only) displays not fill out to the edges? unprotect workbook does not accept blank (nil) entry.

12th January 2011, 11:30 AM	#7
pweaudiotech diyAudio Member Join Date: Feb 2008	The protect/unprotect password for each workbook is same as name of the workbook: diodecalc, xfrmcalc, xstrcalc. If you desire to change the display to show greater accuracy (more decimal places) this is easily done by accessing the "number" function oh the taskbar and altering it to customize...

14th January 2011, 07:52 AM	#8
pweaudiotech diyAudio Member Join Date: Feb 2008	Tips on operating CALCXLS Worksheets... You must have Formula Calculations set to Automatic for Calculations to occur as such. You must have VBA (Visual Basic for Applications) installed for the Print Feature to operate.

17th January 2011, 08:00 AM	#10
pweaudiotech diyAudio Member Join Date: Feb 2008	Updated CALCXLS Group: (MAIN FOLDER) CALCXLS Main Folder URL: CALCXLS CLASS A TRANSISTOR AMPLIFIER CALCULATOR EXCEL SPREADSHEET Download URL: ampcalc.xls (worksheet protect/unprotect password: ampcalc) ampcalc.xls *DIODE SPICE MODEL FILE GENERATOR EXCEL SPREADSHEET Download URL: diodecalc.xls (worksheet protect/unprotect password: diodecalc) diodecalc.xls ELECTRONICS CALCULATOR EXCEL SPREADSHEET Download URL: eleccalc.xls (worksheet protect/unprotect password: eleccalc) eleccalc.xls INDUCTOR/TRANSFORMER PARAMETER CALCULATOR EXCEL SPREADSHEET Download URL: indcalc.xls (worksheet protect/unprotect password: indcalc) indcalc.xls TRANSFORMER RATIO CALCULATOR AND SPICE SUBCIRCUIT GENERATOR EXCEL SPREADSHEET Download URL: xfrmcalc.xls (worksheet protect/unprotect password: xfrmcalc) xfrmcalc.xls TRANSISTOR SPICE MODEL FILE GENERATOR EXCEL SPREADSHEET Download URL: xstrcalc.xls (worksheet protect/unprotect password: xstrcalc) xstrcalc.xls *(These Worksheets require that you have VBA [Visual Basic for Applications] for Excel Installed in order to access the Print Feature)

New To Site?	Need Help?
Register to Participate Search Privacy Statement Contact Us	Frequently Asked Questions Did you forget your password? Mark Forums Read