25 Years of Programming
An open source source for C, C++, OWL, BASIC, MDB, XLS, DOT, and more...

Home Projects Up Sitemap Search Blog Forum+Chat About Us Privacy Terms of Use Feedback FAQ Images Services Payments Humor Music

Language translation
by Google is available
when JavaScript enabled.
Google Translate
is an alternative.

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.

Download:

electricxls.zip: About 58 KB. The zip file contains both the Excel 5.0 and Excel 2003 versions. There are no differences between the two versions. Rename the one you want to ELECTRIC.XLS after download.

Online Ohm's Law Calculator

Ohm's Law: V = I * R, EMF_(Volts) = Current_(Amperes) * Resistance_(Ohms)

Power equation: Watts = Volts * Amps

Instructions:

Enter the two values that are known, leaving the unknown value blank.
Be consistent in your use of units: Volts, Amps, Ohms. Don't mix Volts with MilliAmps or MegOhms.
Click Calculate to solve for the unknown value.

Voltage_(Volts)	Current_(Amps)	Resistance_(Ohms)	Power_(Watts)
V = I * R	I = V / R	R = V / I	W = V * I

Online calculator for Series and Parallel Resistors, Inductors, Capacitors

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 = N₁ + N₂ + N₃...

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/N₁ + 1/N₂ + 1/N₃...)

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.

Instructions:

Type or paste the component values into the box. The units for all must be the same.
The data should contain only the characters .-+0123456789eE. Scientific notation is allowed. For example, 1 MegOhm can be written as 1000000, 1e6, 1e+6 or 1e+06.
Click Calculate.
The output units are the same you used for the input values.

Type or paste values,	Series Resistance Series Inductance Parallel Capacitance Total = N₁ + N₂ + N₃...	Parallel Resistance Parallel Inductance Series Capacitance Total = 1 / (1/N₁ + 1/N₂ + 1/N₃...)

Screenshots of the Excel worksheets

Series and parallel resistance

Screenshot of the series and parallel resistance worksheet. It also calculates the voltage drop, current, and power dissipation through each resistor.

Series and parallel capacitance

Screenshot of the series and parallel capacitance worksheet

Ohm's Law calculations

Screenshot of the Ohm's Law worksheet for voltage, current, and resistance

Frequency and wavelength

Screenshot of the frequency and wavelength calculation worksheet, with some calculations for antenna design.