Transformer SPICE Excel Spreadsheet

Status
This old topic is closed. If you want to reopen this topic, contact a moderator using the "Report Post" button.
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.
 
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:
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...
 
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:
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)
 
Updated CALCXLS Group:
NOTE:
The pwecalc.xls Workbook contains all Worksheets


(MAIN FOLDER)
CALCXLS
Main Folder URL:
CALCXLS

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

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

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

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

***PWE ELECTRONICS CALCULATOR EXCEL SPREADSHEETS
Download URL:
pwecalc.xls (workbook protect/unprotect password: protect)
pwecalc.xls

***TRANSFORMER RATIO CALCULATOR AND SPICE SUBCIRCUIT GENERATOR EXCEL SPREADSHEET
Download URL:
xfrmcalc.xls (workbook protect/unprotect password: xfrmcalc)
xfrmcalc.xls

***TRANSISTOR SPICE MODEL FILE GENERATOR EXCEL SPREADSHEET
Download URL:
xstrcalc.xls (workbook 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)
 
Updated CALCXLS Group:
NOTE:
The pwecalc.xls Workbook contains all Worksheets


(MAIN FOLDER)
CALCXLS
Main Folder URL:
CALCXLS


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


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


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


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


***PWE ELECTRONICS CALCULATOR EXCEL SPREADSHEETS
Download URL:
pwecalc.xls
pwecalc.xls (workbook protect/unprotect password: protect)


***TRANSFORMER RATIO CALCULATOR AND SPICE SUBCIRCUIT GENERATOR EXCEL SPREADSHEET
Download URL:
xfrmcalc.xls
xfrmcalc.xls (workbook protect/unprotect password: xfrmcalc)


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


***(These Workbooks require that you have VBA [Visual Basic for Applications] for Excel Installed in order to access the Print Feature)
 
Updated CALCXLS Group:
NOTE:
The pwecalc.xls Workbook contains all Worksheets


(MAIN FOLDER)
CALCXLS
Main Folder URL:
CALCXLS - Folder Shared from Box.net - Free Online File Storage

CLASS A TRANSISTOR AMPLIFIER CALCULATOR EXCEL SPREADSHEET
Download URL:
ampcalc.xls - File Shared from Box.net - Free Online File Storage
ampcalc.xls (workbook protect/unprotect password: ampcalc)


***DIODE SPICE MODEL FILE GENERATOR EXCEL SPREADSHEET
Download URL:
diodecalc.xls - File Shared from Box.net - Free Online File Storage
diodecalc.xls (workbook protect/unprotect password: diodecalc)


ELECTRONICS CALCULATOR EXCEL SPREADSHEET
Download URL:
eleccalc.xls - File Shared from Box.net - Free Online File Storage
eleccalc.xls (workbook protect/unprotect password: eleccalc)


INDUCTOR/TRANSFORMER PARAMETER CALCULATOR EXCEL SPREADSHEET
Download URL:
indcalc.xls - File Shared from Box.net - Free Online File Storage
indcalc.xls (workbook protect/unprotect password: indcalc)


***PWE ELECTRONICS CALCULATOR EXCEL SPREADSHEETS
Download URL:
pwecalc.xls - File Shared from Box.net - Free Online File Storage
pwecalc.xls (workbook protect/unprotect password: protect)


RESISTOR VOLTAGE DIVIDER CALCULATOR EXCEL SPREADSHEET
Download URL:
rdivcalc.xls - File Shared from Box.net - Free Online File Storage
rdivcalc.xls (workbook protect/unprotect password: rdivcalc)


***TRANSFORMER RATIO CALCULATOR AND SPICE SUBCIRCUIT GENERATOR EXCEL SPREADSHEET
Download URL:
xfrmcalc.xls - File Shared from Box.net - Free Online File Storage
xfrmcalc.xls (workbook protect/unprotect password: xfrmcalc)


***TRANSISTOR SPICE MODEL FILE GENERATOR EXCEL SPREADSHEET
Download URL:
xstrcalc.xls - File Shared from Box.net - Free Online File Storage
xstrcalc.xls (workbook protect/unprotect password: xstrcalc)


***(These Workbooks require that you have VBA [Visual Basic for Applications] for Excel Installed in order to access the Special Print Feature)
 
Updated CALCXLS Group:
NOTE:
The pwecalc.xls Workbook contains all Worksheets


(MAIN FOLDER)
CALCXLS
Main Folder URL:
CALCXLS - Folder Shared from Box.net - Free Online File Storage

CLASS A TRANSISTOR AMPLIFIER CALCULATOR EXCEL SPREADSHEET
Download URL:
ampcalc.xls - File Shared from Box.net - Free Online File Storage
ampcalc.xls (workbook protect/unprotect password: ampcalc)


***DIODE SPICE MODEL FILE GENERATOR EXCEL SPREADSHEET
Download URL:
diodecalc.xls - File Shared from Box.net - Free Online File Storage
diodecalc.xls (workbook protect/unprotect password: diodecalc)


ELECTRONICS CALCULATOR EXCEL SPREADSHEET
Download URL:
eleccalc.xls - File Shared from Box.net - Free Online File Storage
eleccalc.xls (workbook protect/unprotect password: eleccalc)


INDUCTOR/TRANSFORMER PARAMETER CALCULATOR EXCEL SPREADSHEET
Download URL:
indcalc.xls - File Shared from Box.net - Free Online File Storage
indcalc.xls (workbook protect/unprotect password: indcalc)


***PWE ELECTRONICS CALCULATOR EXCEL SPREADSHEETS
Download URL:
pwecalc.xls - File Shared from Box.net - Free Online File Storage
pwecalc.xls (workbook protect/unprotect password: protect)


RESISTOR/cAPACITOR CALCULATOR EXCEL SPREADSHEETS
Download URL:
rccalc.xls - File Shared from Box.net - Free Online File Storage
rccalc.xls (workbook protect/unprotect password: rccalc)


RESISTOR VOLTAGE DIVIDER CALCULATOR EXCEL SPREADSHEET
Download URL:
rdivcalc.xls - File Shared from Box.net - Free Online File Storage
rdivcalc.xls (workbook protect/unprotect password: rdivcalc)


***TRANSFORMER RATIO CALCULATOR AND SPICE SUBCIRCUIT GENERATOR EXCEL SPREADSHEET
Download URL:
xfrmcalc.xls - File Shared from Box.net - Free Online File Storage
xfrmcalc.xls (workbook protect/unprotect password: xfrmcalc)


***TRANSISTOR SPICE MODEL FILE GENERATOR EXCEL SPREADSHEET
Download URL:
xstrcalc.xls - File Shared from Box.net - Free Online File Storage
xstrcalc.xls (workbook protect/unprotect password: xstrcalc)


***(These Workbooks require that you have VBA [Visual Basic for Applications] for

Excel Installed in order to access the Special Print Feature)
 
Updated CALCXLS Group:
NOTE:
The pwecalc.xls Workbook contains all Worksheets


(MAIN FOLDER)
CALCXLS
Main Folder URL:
CALCXLS - Folder Shared from Box.net - Free Online File Storage

CLASS A TRANSISTOR AMPLIFIER CALCULATOR EXCEL SPREADSHEET
Download URL:
ampcalc.xls - File Shared from Box.net - Free Online File Storage
ampcalc.xls (workbook protect/unprotect password: ampcalc)


***DIODE SPICE MODEL FILE GENERATOR EXCEL SPREADSHEET
Download URL:
diodecalc.xls - File Shared from Box.net - Free Online File Storage
diodecalc.xls (workbook protect/unprotect password: diodecalc)


ELECTRONICS CALCULATOR EXCEL SPREADSHEET
Download URL:
eleccalc.xls - File Shared from Box.net - Free Online File Storage
eleccalc.xls (workbook protect/unprotect password: eleccalc)


INDUCTOR/TRANSFORMER PARAMETER CALCULATOR EXCEL SPREADSHEET
Download URL:
indcalc.xls - File Shared from Box.net - Free Online File Storage
indcalc.xls (workbook protect/unprotect password: indcalc)


***PWE ELECTRONICS CALCULATOR EXCEL SPREADSHEETS
Download URL:
pwecalc.xls - File Shared from Box.net - Free Online File Storage
pwecalc.xls (workbook protect/unprotect password: protect)


RESISTOR/CAPACITOR CALCULATOR EXCEL SPREADSHEETS
Download URL:
rccalc.xls - File Shared from Box.net - Free Online File Storage
rccalc.xls (workbook protect/unprotect password: rccalc)


RESISTOR VOLTAGE DIVIDER CALCULATOR EXCEL SPREADSHEET
Download URL:
rdivcalc.xls - File Shared from Box.net - Free Online File Storage
rdivcalc.xls (workbook protect/unprotect password: rdivcalc)


***TRANSFORMER RATIO CALCULATOR AND SPICE SUBCIRCUIT GENERATOR EXCEL SPREADSHEET
Download URL:
xfrmcalc.xls - File Shared from Box.net - Free Online File Storage
xfrmcalc.xls (workbook protect/unprotect password: xfrmcalc)


***TRANSISTOR SPICE MODEL FILE GENERATOR EXCEL SPREADSHEET
Download URL:
xstrcalc.xls - File Shared from Box.net - Free Online File Storage
xstrcalc.xls (workbook protect/unprotect password: xstrcalc)


***(These Workbooks require that you have VBA [Visual Basic for Applications] for

Excel Installed in order to access the Special Print Feature)
 
Definitions of My Excel Worksheet Calculators:
*(THESE CALCULATORS REQUIRE THAT YOU HAVE VBA INSTALLED FOR EXCEL)
NOTE: the pwecalc.xls Workbook contains all Calculators (password: protect)
IMPORTANT! Any changes to default values 'saved' will alter the original Workbooks/Worksheets.

Some of the formulas utilized are simplified versions of more accurate electronics mathematics…

ampcalc.xls (password: ampcalc)
A one-stage Class A NPN Transistor Amplifier Calculator
The additional Voltage of Base to Emitter vs. Collector Current requires separate Input Values and the accompanying chart shows the results.

*diodecalc.xls (password: diodecalc)
This is actually a Diode SPICE Model File Generator that will create a simple Model File with the file extension .MOD in 'My Documents' that can be used in compatible Electronics CAD SPICE Programs. The Input Values shown are for a standard 1N4148/1N914 Diode and can be changed to suit your requirements.

eleccalc.xls (password: eleccalc)
This is an Ohm's Law Calculator for Calculating Voltage, Resistance, Amperage or Power determined by two other Input Values. It includes a standard Ohm's Law 'Pie Chart' for reference.

indcalc.xls (password: indcalc)
This is an Inductor/Transformer Parameter Calculator for Advanced Users.

rccalc.xls (password: rccalc)
This is actually four separate Resistor/Capacitor Frequency Filter Calculators. Each one on a separate Worksheet. Low Pass Frequency Filter, High Pass Frequency Filter, Bandpass Frequency Filter and Notch Frequency (Twin T) Filter Caculators.

rdivcalc.xls (password: rdivcalc)
A simple Resistor Divider Calculator for calculating the Output Voltage dependent on two resistors connected in series to ground and the Input Voltage.

*xfrmcalc.xls (password: xfrmcalc)
This is actually a Transformer SPICE Model File Generator that will create a simple Subcircuit File with the file extension .CIR in 'My Documents' that can be used in compatible Electronics CAD SPICE Programs. There are five separate Transformer Calculators to allow a wide range of Input Values. The Final chosen Design Values are then entered into the simple Transformer Model at the top right of the page for creation of the Subcircuit.

*xstrcalc.xls (password: xstrcalc)
This is actually a Transistor SPICE Model File Generator that will create a simple Model File with the file extension .MOD in 'My Documents' that can be used in compatible Electronics CAD SPICE Programs. The Input Values shown are for a standard 2N2222A Transistor and can be changed to suit your requirements.
 
Status
This old topic is closed. If you want to reopen this topic, contact a moderator using the "Report Post" button.