Watts, Volts, Amps, Ohms Calculator (Excel)

I know that this post has nothing to do with finance, but others might find it helpful.

 

It is important to remember to click the “Clear Inputs” button to start over or to enter new inputs. 

Enter any two of the four electrical measurements in the yellow cells and the other two will be calculated (in red).

O = Resistance in Ohms

A = Current in Amps

V = Voltage in Volts

W = Power in Watts

The calculated units can be converted to:

Micro

Milli

No Change

Kilo

Mega

The abbreviations for these sizes will appear to the left of the changes.

The calculations are in hidden columns. Unhide between columns N and P. The formulas are on the “Formulas” sheet.

Download: http://pistulka.com/Excel_Shared/Electricity.xlsm

Don Pistulka
Don Pistulka

Retired Credit Union CFO - Finance
Background: over 40 years in investments, asset/Liability management, banking, securities trader.
Worked for: California Credit Union, WesCorp, CalFed S&L, Crocker Bank, Carroll McEntee, Federal Home Loan Bank Board (D.C.), Western Asset Management, Security Pacific National Bank.

Leave a Reply

Your email address will not be published. Required fields are marked *