25 Years of Programming
An open source source for C, C++, OWL, BASIC, MDB, XLS, DOT, and more...
Electrical calculations - Excel worksheets, and online calculator: Ohm's Law, series and parallel resistance, capacitance, and inductance
Electric.xls is a Microsoft Excel spreadsheet with worksheets for Ohm's Law, series and parallel calculations for resistance, capacitance, and inductance, voltage drop, and frequency and wavelength calculations useful in antenna design. There is a page for creating an impedance calculator, but it's incomplete and currently not useful. It has an RS-232 serial communications pin definition table. A similar table and some other notes about RS-232 are on the page RS-232 Notes.
Farther down this page is an Ohm's Law calculator for doing the computations online, as well as a calculator for series and parallel resistance, capacitance, and inductance.
Ohm's Law: V = I * R, EMF(Volts) = Current(Amperes) * Resistance(Ohms)
Power equation: Watts = Volts * Amps
|V = I * R||I = V / R||R = V / I||W = V * I|
The formula for computing resistors or inductors in series is the same, and it is the same formula for computing capacitors in parallel. It is the simple sum of all the values: Total = N1 + N2 + N3...
The formula for computing resistors or inductors in parallel is the same, and it is the same formula for computing capacitors in series. It is: Total = 1 / (1/N1 + 1/N2 + 1/N3...)
To calculate a more complicated circuit where you have some components in series mixed with others that are in parallel: draw a diagram of the circuit; reduce all the occurrences of simple series components (such as pairs) to their single equivalent value; reduce all the occurrences of simple parallel components to their single equivalent values; keep repeating until the circuit is simplified as much as possible. Keep the series and parallel calculations separate. For example, if there is one resistor that is in series with two others that are in parallel with each other, calculate the parallel ones first, then use that value in the series calculation with the first resistor.
|Type or paste values,
Total = N1 + N2 + N3...
Total = 1 / (1/N1 + 1/N2 + 1/N3...)
Copyright ©2012 Steven Whitney. Last modified Sun 07/29/2012 12:05:06 -0700.