+ Reply to Thread
Results 1 to 7 of 7

Vector Diagram for Voltage and Current

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

    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 Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Vector Diagram for Voltage and Current

    Here is an old one that may do

    3 Ph Current sine waves.xls
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

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

    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
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,837

    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 05:33 PM.

  5. #5
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Vector Diagram for Voltage and Current

    Another old file which might be okVector Addition .xls

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

    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 Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Vector Diagram for Voltage and Current

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

+ 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.6.0 RC 1