Vectors operation in Excel

I made this spreadsheet to help me calculate the return current in unbalanced three phase loads. In this case the data to enter is the power factor and the magnitude of the current in each phase. The table will show the return current in complex number, polar and rectangular form. The chart will show the vector representing the current in the neutral conductor (in black).

Download the file

The next spreadsheet calculates and plots the voltages across a resistor and an inductor (it can be easily changed to capacitor) in a series circuit. 

Download the file

Plot sine waves with Excel

During my study I had to draw and calculate sine waves pretty often. I used Excel to plot them and calculate their sums or product.

This first file calculates and plots 3 sine waves in the same chart from their function (amplitude, frequency, shift and offset):

Download the file


The second file calculates and plots 2 sine waves from their function and their product, very useful to see the usage of power when voltage and current are not in phase:

Download the file


The third file calculates and plots 2 sine waves from their function and their sum. It also plots the phasor diagram at 0 degrees:

Download the file

Low-pass filter and integrator in Excel

Today I want to publish a couple of useful spreadsheet I made to solve electrical circuits.
The first is an integrator circuit: a pulsing DC voltage charges a capacitor in steps. This spreadsheet calculates the voltages across the capacitor over time. It's a pretty complex formula to do it manually.

Download the file

The second spreadsheet calculates the frequency response in a series RLC circuit, in this case the voltage is taken across the capacitor, therefore it's a low-pass filter.

Download the file