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   Ads   Donate   Humor

Electric.xls - Ohm's Law calculations

Microsoft Excel spreadsheet with worksheets for Ohm's Law, series and parallel calculations for resistance, capacitance, and inductance, and frequency and wavelength calculations useful in antenna design. There is a page for creating an impedance calculator, but it's incomplete and at present 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.

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.

Screenshots:

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.

 

 

Valid HTML 4.01 Transitional Valid CSS
View content labeling at ICRA.
Copyright ©2007 Steven Whitney. Last modified 09/25/2007.