+ Reply to Thread
Results 1 to 7 of 7

Thread: Vector Diagram for Voltage and Current

  1. #1
    Registered User
    Join Date
    11-15-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2007
    Posts
    31

    Vector Diagram for Voltage and Current

    Does anyone have a code for plotting a vector diagram for voltage and current. The three phase voltages are 120 degrees apart. The current angles have to be plotted with respect to the corresponding voltage vector.

  2. #2
    Forum Guru pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2010
    Posts
    5,150

    Re: Vector Diagram for Voltage and Current

    Here is an old one that may do

    3 Ph Current sine waves.xls
    regards pike

    If the solution helped please donate
    here to the RSPCA

    Sites worth visiting;

    J&R Solutions - royUK

    AJP Excel Information - Andy Pope

    Spreadsheet Toolbox

    VBA for smarties - snb

  3. #3
    Registered User
    Join Date
    11-15-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2007
    Posts
    31

    Re: Vector Diagram for Voltage and Current

    Thanks Pike for your post. This is not exactly what I was looking for. I am attaching an excel file as an example. In sheet AC_Meter, all the electrical parameters are computed. Sheet1 contains a dummy of what the vector diagram should look like. The longer arms are the voltage vectors. These are always at 0, 120 and 240 degrees. In column F of sheet1, I compute the angle offset for the current vector with respect to the voltage vector. These are to be plotted as the smaller arms.

    Is there any way that excel charting or vb programming can plot this diagram ?

    Any help will be greatly appreciated.
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    here
    MS-Off Ver
    2002/XP
    Posts
    1,237

    Re: Vector Diagram for Voltage and Current

    Unfortunately, my knowledge of AC electricity is limited. What little I do remember is that it involved a bit of trigonometry and often used polar coordinates (and the subsequent conversions of polar to rectangular coordinates).

    It looks like each vector is simply a line connecting the origin (0,0) with its endpoint. Can I assume you know how to calculate the coordinates of each endpoint? If you can calculate the coordinates of each endpoint, then you simply need to put them in a table, maybe like this:

    vector 1
    0 0
    x1 y1
    vector 2
    0 0
    x2 y2
    vector 3
    0 0
    x3 y3...

    Once you have some kind of table like that, you can simply plot each of those series on a scatter plot and you should get your vector diagram.
    Last edited by MrShorty; 01-11-2012 at 04:33 PM.

  5. #5
    Forum Guru pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2010
    Posts
    5,150

    Re: Vector Diagram for Voltage and Current

    Another old file which might be okVector Addition .xls
    regards pike

    If the solution helped please donate
    here to the RSPCA

    Sites worth visiting;

    J&R Solutions - royUK

    AJP Excel Information - Andy Pope

    Spreadsheet Toolbox

    VBA for smarties - snb

  6. #6
    Registered User
    Join Date
    11-15-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2007
    Posts
    31

    Re: Vector Diagram for Voltage and Current

    Thanks MrShorty and Pike for your contributions. MrShorty's solution appears to be simpler to implement since all the angles are computed. Took a look at Pike's file. I will take some time to understand what has been done before attempting it. Thanks anyway for your assistance.

  7. #7
    Forum Guru pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2010
    Posts
    5,150

    Re: Vector Diagram for Voltage and Current

    No problem, I think you will find it does the samething as MrShorty's suggestion
    regards pike

    If the solution helped please donate
    here to the RSPCA

    Sites worth visiting;

    J&R Solutions - royUK

    AJP Excel Information - Andy Pope

    Spreadsheet Toolbox

    VBA for smarties - snb

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.2.0