Transformer SPICE Excel Spreadsheet - diyAudio
Go Back   Home > Forums > Design & Build > Software Tools

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
Reply
 
Thread Tools Search this Thread
Old 6th January 2011, 11:09 PM   #1
diyAudio Member
 
pweaudiotech's Avatar
 
Join Date: Feb 2008
Default 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.
  Reply With Quote
Old 8th January 2011, 10:09 AM   #2
AndrewT is offline AndrewT  Scotland
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.
__________________
regards Andrew T.
  Reply With Quote
Old 10th January 2011, 02:32 AM   #3
diyAudio Member
 
pweaudiotech's Avatar
 
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
  Reply With Quote
Old 10th January 2011, 02:47 AM   #4
diyAudio Member
 
andrewlebon's Avatar
 
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
  Reply With Quote
Old 11th January 2011, 03:19 PM   #5
diyAudio Member
 
pweaudiotech's Avatar
 
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.
  Reply With Quote
Old 11th January 2011, 03:38 PM   #6
AndrewT is offline AndrewT  Scotland
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.
__________________
regards Andrew T.
  Reply With Quote
Old 12th January 2011, 11:30 AM   #7
diyAudio Member
 
pweaudiotech's Avatar
 
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...
  Reply With Quote
Old 14th January 2011, 07:52 AM   #8
diyAudio Member
 
pweaudiotech's Avatar
 
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.
  Reply With Quote
Old 16th January 2011, 10:26 AM   #9
diyAudio Member
 
pweaudiotech's Avatar
 
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.
  Reply With Quote
Old 17th January 2011, 08:00 AM   #10
diyAudio Member
 
pweaudiotech's Avatar
 
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)
  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
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


New To Site? Need Help?

All times are GMT. The time now is 02:48 AM.


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