Excel Phasor Diagram Builder

[Dave Loucks]

I found that I needed to draw  phasor diagrams for some IEEE papers I was writing that would render properly when typeset.  I've included another article on how to export a scalable vector diagram, but here I just wanted to talk about the program I wrote that creates the diagram in the first place. 

Previously I had simply used a drawing program (like PowerPoint or Inkscape), but I wanted a diagram that was accurate to the degree.

So, I created this Excel program.  To use:

• Cell B4: Enter in desired power factor
• Cells B7-B17: Enter in any harmonic percentages
• Cell B19: Enter power flow direction (+/-)
• Cells Y2-Y3: Enter any scaling factors
  If these are left at the defaults of "1" for both voltage and current, each vector will be the same length (1).
• Click to select either diagram, and select File->Print.  Only the selected diagram will print.
  If you are wanting to publish these diagrams, print to a PDF format and then refer to this other article on how to extract the diagram in a scalable vector format suitable for typesetting.

Here's a video that explains how to use this 1-phase phasor diagram builder: http://pps2.com/v/s/1/opd.php

I've also added a 3-phase phasor diagram builder.  Just plug in the 3 phasor's names (Ia, Va, Vab, etc.), the magnitude and phase angle (in degrees) and you will plot the 3 phasors.

Here's a video that explains how to use the 3-phase phasor diagram builder: http://pps2.com/v/s/1/tpd.php

Thirdly, if you are interested in creating stacked vector diagrams (vector connected to end of other vector), I wrote another article where I show how to do that (article actually on comparing differences between summed absolute values of impedance versus summing real (R) and reactive (X) components and I show graphically the differences using stacked vector diagrams).   Click to jump to that other article (or click on spreadsheet image immediately below): http://pps2.com/smf/index.php?topic=46.msg53#msg53