Go Back   Home > Forums > >

Software Tools SPICE, PCB CAD, speaker design and measurement software, calculators

Electronics Calculators Excel Workbook
Electronics Calculators Excel Workbook
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
Old 31st May 2018, 11:32 PM   #1
pweaudiotech is offline pweaudiotech  United States
diyAudio Member
pweaudiotech's Avatar
Join Date: Feb 2008
Default Electronics Calculators Excel Workbook

(Updated 6/5/2018)
Electronics Calculators Excel Workbook (elecalc.xls)
Index (with links to calculator worksheets)
Sheet1 SPICE Power Transformers Calculator Worksheet
Sheet2 SPICE Output Transformers Calculator Worksheet
Sheet3 2-Stage Transistor Amplifier Calculator Worksheet
Sheet4 Passive Filters Calculator Worksheet
Sheet5 Active OpAmp Equalizer Calculator Worksheet
Sheet6 Ohm's Law Calculator Worksheet

New Download Links:

Excel Workbook File

Zipped Excel .xls File

Right Button Mouse Click on the Downloaded File to Access 'Properties' at the Bottom of the Context Menu and Click the 'Unblock' Button if it Appears to Allow Computer Program Compatibility ...

Last edited by pweaudiotech; 2nd July 2018 at 06:13 AM.
  Reply With Quote
Old 19th May 2020, 09:43 PM   #2
woodo is offline woodo  Australia
diyAudio Member
Join Date: Jun 2018
Hi, I used elecalc to come up with the spice model for the edcore xpwr 144 power transformer (240v ac in Australia at 50 hz). I notice you need to input the inductance value of the primary and the default value was 10H. How do you determine this for a transformer. I don't see any value on the Edcor specifications.

I use this in a 5ar4/6sn7/300b valve/tube power amp. modelled B+ voltages are a bit higher than actual about 15%.

The model for the output transformer looks reasonable. I used the gsxe 3500 8 15w model. I didn't use ltspice though, I'm trying to learn microcap and imported the spice model into microcap which seems straightforward enough.

Appreciate any pointers. Thanks for the elecalc, very useful.
Attached Images
File Type: jpg power xfmr.JPG (315.9 KB, 73 views)

Last edited by woodo; 19th May 2020 at 09:55 PM. Reason: correction
  Reply With Quote
Old 19th May 2020, 11:30 PM   #3
woodo is offline woodo  Australia
diyAudio Member
Join Date: Jun 2018
I saw in jdrouins thread on a similar amp he added in the second audio channel. This seem to fix the over voltages. Thanks.
  Reply to this post


Electronics Calculators Excel WorkbookHide this!Advertise here!
Thread Tools

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

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Workbook Electronics Calculators pweaudiotech Software Tools 11 2nd July 2018 06:19 AM
Box calculators Chrispy61 Software Tools 3 18th March 2018 07:34 PM
FS: Speakers (Scan Speak, Seas Excel), Electronics (Tube Amps, Preamps) etc. PHilgeman Swap Meet 8 28th October 2008 03:22 AM

New To Site? Need Help?

All times are GMT. The time now is 09:46 AM.

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