diyAudio

diyAudio (https://www.diyaudio.com/forums/index.php)
-   Software Tools (https://www.diyaudio.com/forums/software-tools/)
-   -   Transformer SPICE Excel Spreadsheet (https://www.diyaudio.com/forums/software-tools/180618-transformer-spice-excel-spreadsheet.html)

pweaudiotech 7th January 2011 12:09 AM

Empty Post ...
 
Empty Post ...

AndrewT 8th January 2011 11: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 03: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 03: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 11th January 2011 04:19 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 04: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 12:30 PM

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 08: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 16th January 2011 11:26 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 09: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)


All times are GMT. The time now is 09:09 PM.


Search Engine Optimisation provided by DragonByte SEO (Pro) - vBulletin Mods & Addons Copyright © 2018 DragonByte Technologies Ltd.
Resources saved on this page: MySQL 17.65%
vBulletin Optimisation provided by vB Optimise (Pro) - vBulletin Mods & Addons Copyright © 2018 DragonByte Technologies Ltd.
Copyright ©1999-2018 diyAudio

Wiki