I am looking for a simple excel spreadsheet to calc. transformers, no. of turns, power etc.

Question

I am looking for a starter spreadsheet excel '2003' prefered to calculate transformers (home made) small amps and volts. These are for my experiments and I want to be as accurate as possible. I also am looking for the same for 555/556 ic's for timing. Any help is appreciated, thanks in advance.

Former Member · Accepted Answer

Yes I saw these and I am using the 555 software and that is great but I would still like the opportunity to see the numbers and formulas to make my own transformers. With compiled software you see nothing but the end results and for the most part that is fine. However in excel you get to see everything, unless the formulas are hidden. I appreciate the information though, thanks still looking for the excel spreadsheet to work out the transformer...

I found software as you said, it looks to helpful I wanted to pass this alone to you http://www.electronics2000.co.uk/ it does a lot of calcs for all kinds of things including 555 ic's, power, resistance, and lots of other calcs. Thanks to all for your help.

gihu · Answer

Hi Timothy,

For the 555 I hope this link could be helpfull:

http://www.schematica.com/555_timer_design/555_timer_free.html

For the transformer, if you google it you can find software like in this link:

http://www.electronicecircuits.com/electronic-software/transformer-calculation-software

But I think building your own transformer won't be so easy like the 555...

Hope that helps,

Miguel

D_Hersey · Answer

The analysis of t-formers has gotten a little easier since some one figured out to reflect the secondary parasitics over to the primary (or vice-versa) so they could be lumped and the t-former sorta modeled as an inductor. As far as n turns primary, that is a trade-off between leakage inductance and parasitic capacitance, as well as mechanical and economic factors. There are all sorts of core materials that are used in transformers because there are all kinds of frequency and bandwidth regimes in which they are employed. Broadband transformers are different. Signal transformers are different than power transformers. There are T-line transformers. Coupling transformers for impedance matching. . . Different kinds of magnet wire are available, square wire, litzendrath wire. . . There are all kind of cores and winding schemes. . . I am proud to state as a citizen of the four-star city, that the first commercial operation to make transformers in large quantities was Thoradson in Chicago. Between the turn-of-the-century and the advent of WWII we were a high-tech capital. Transformers are darn interesting, both on paper and in the meatspace. As a prior poster indicated you aren't gonna become a T-former wonk in a day. ============