Guys, does anyone have any software or a spreadsheet with calculations for transformers?

 

Hammond design guide for rectifier use.

 

I wanted simple software or a spreadsheet to calculate single-phase transformers up to 500VA

 

https://www.newark.com/transformer-turns-calculator

 

Guys, does anyone have any software or a spreadsheet with calculations for transformers?

50Hz transformers or high-frequency switched-mode transformers?

 

The question is a bit unclear, and it is not likely to be in a spread sheet format. What portion of the design do you seek a tool for? Size?, Power? Frequency Response? Efficiency? Linearity? Or saturation characteristics?
My point being that transformer design is a broad area and so there are a lot of different formulas that get used.

 

Guys, does anyone have any software or a spreadsheet with calculations for transformers?

Over the years, I have never really found any definitive sources or explanations of designing E-I or Toroidal transformers.

 

Guys, does anyone have any software or a spreadsheet with calculations for transformers?

For a 50/ 60 Hz power transformer, use the generic formula>
1 Sq Inch Core area = 30 VA, VA is proportional to Square of Area => 2 Sq Inch = 120 VA
Winding is ~ 6 turns / Volt
This is for E-I metal core laminations at the normal power frequency.
Not for air / powdered iron / ferrite cores.

 

Audio transformers are a bit more demanding than average power transformers because they need to avoid distortion. (Transformers used to be a very large part of audio power amplifiers.) And still, avoiding distortion of non-linear operation is still a big deal. Transformers for assorted other signals also have additional requirements.

 

The particular purpose of the Transformer changes everything.
The Frequency of operation changes everything.
The Style of Core changes everything.
The Material that the Core is made of changes everything.
The Duty-Cycle changes everything.

For Mains-Powered Power-Supply Transformers,
purchase a commercially available Toroidal-Transformer, with an adequate VA-rating,
then wind your own Secondary(s).
Add Secondary-Turns until You get the exact Voltage You need.

There are general "guidelines" for other Transformer applications.
.
.
.

 

OR, for an easier to deal with arrangement, and mounting, use a "Signal" brand power transformer. Good quality and honest specifications.

 

50Hz transformers or high-frequency switched-mode transformers?

I am looking for a Transformer Design Excel Sheet covering 50 Hz & 60 Hz, 3-Phase Transformers, including:
• Dry-Type Transformers
• Oil-Immersed Transformers
• Power Transformers
If you have a suitable design calculation Excel sheet, could you please share it here? If email is more convenient, I can provide my email address for receiving the file.

 

I am looking for a Transformer Design Excel Sheet covering 50 Hz & 60 Hz, 3-Phase Transformers, including:

What is the object of your design, unique application? or design in general? Production etc?
Lots of info out there, Youtube etc

 

Incidentally, three phase toroidal transformers are usually constructed using 3 1ph uniquely-separate transformers rather than on a single frame as is usually done with 3-1ph E.I. versions.

 

Incidentally, three phase toroidal transformers are usually constructed using 3 1ph uniquely-separate transformers rather than on a single frame as is usually done with 3-1ph E.I. versions.

Max is correct!! I am trying to imagine a "three-phase toroidal transformer". It would require more than three axis, which gets really complicated.

 

Guys, does anyone have any software or a spreadsheet with calculations for transformers?

What transformer(s) did you have in mind? Create a spreadsheet in Excel (or similar) and add your math to your spreadsheet.

You can transform Excel formulas into static values or build electrical transformer calculations using specific Excel formulas depending on your exact goal.

Ron

 

3ph mains transformers are typically mounted together in the same stamped laminar-constructed steel frame, but actually operate as three 1ph independant transformers.

 

I am trying to imagine a "three-phase toroidal transformer".

I think winding all 3 windings on a single toroid would work. That way the magnetic flux from each winding would be contained within the core and be able to cut the turns of each individual winding. Of course the core would have to be sized to handle the maximum flux. The windings could be wired Y or delta.

 

I recently made a spreadsheet with Claude Opus 4.8, which I asked to be complete, 50-60 Hz and switched-mode.
Have a look and have fun.

 

I think winding all 3 windings on a single toroid would work.
View attachment 370901

You Think ???
So far done using 3 separate cores!!