1. Welcome to our site! Electro Tech is an online community (with over 170,000 members) who enjoy talking about and building electronic circuits, projects and gadgets. To participate you need to register. Registration is free. Click here to register now.
    Dismiss Notice

[Help]3phase graphic using excel

Discussion in 'Members Lounge' started by Silent_Sense, Mar 31, 2009.

  1. Silent_Sense

    Silent_Sense New Member

    Joined:
    Mar 21, 2009
    Messages:
    8
    Likes:
    0
    hello guys, i need ur help again hehe..
    can u give me some information or something to help me to make 3phase graphic using excel?
    3 sinus graphic in one graphic..
    There are 3 variable (a,b,c)
    my graphic start from 10 degrees(a), so, b will be start from 130degrees, c will be 250degrees..that`s right?
    what i must compare to make it likes sinus graphic?:confused:
    current and load?
    In this case, That degrees using for sign of my graphic that start from 10, 130, and 250 degrees..
    I try to googling..but i can`t..
    So, i try to get information here..
    I love this forum (sure):D
    Thx b4..
     
    Last edited: Mar 31, 2009
  2. JimB

    JimB Super Moderator Most Helpful Member

    Joined:
    Sep 11, 2004
    Messages:
    6,393
    Likes:
    593
    Location:
    Peterhead, Scotland
    Like this?
     

    Attached Files:

  3. Silent_Sense

    Silent_Sense New Member

    Joined:
    Mar 21, 2009
    Messages:
    8
    Likes:
    0
    That`s right..
    but in my case, it`s start from 10degrees (line Blue)-
    130degrees(line red)-
    250degrees(line blue) ..
    can u give me excel file??
    so i can modify that file..
    I using Micrs.Office 07..
    u can send to my email
    matiascst@yahoo.com
    1 again, if i using current and torque to make graphic like that??
    Thx a lot b4..:D
     
  4. dave

    Dave New Member

    Joined:
    Jan 12, 1997
    Messages:
    -
    Likes:
    0


     
  5. JimB

    JimB Super Moderator Most Helpful Member

    Joined:
    Sep 11, 2004
    Messages:
    6,393
    Likes:
    593
    Location:
    Peterhead, Scotland

    OK, lets keep the discussion in the forum.

    Refering to the attached screen shot.

    1 Set up a series of data points for the x-axis, I have used 0 to 720 degrees in 10 degree steps.

    2 Set up the phase differences, I used 0, 120 and 240 degrees.
    You can use 10, 130 and 250 if you wish.

    3 Set the formula for the first cell.
    Excel uses radians for the Sin() function, so (2*PI()..../360) converts the degrees to radians.
    B4 the cell with the degrees. (actually it would be better written as $B4.
    $C$3 the cell with the phase difference. The other columns will be $D$3 and $E$3.

    Now copy the formula to the other cells.

    4 Select all four colomns of data and click on the "Scatter" chart icon, in the pop-up box click on the "Scatter with smooth lines" icon.

    Job done! enjoy your pretty picture.

    JimB
     

    Attached Files:

  6. Silent_Sense

    Silent_Sense New Member

    Joined:
    Mar 21, 2009
    Messages:
    8
    Likes:
    0
    Waw..very cool picture..
    thx a lot sir..
    but how to make pic like this..
    [​IMG]
    when i input a, so b n c can be change..so we have the resultan of that picture..:D
    Hehe..i`m sorry if i many ask to you hehe..
    i just wanna learn more..
     

Share This Page