+ Reply to Thread
Results 1 to 5 of 5

Sorting Node Coordinates of a Circle

  1. #1
    Registered User
    Join Date
    03-10-2016
    Location
    Houston, TX
    MS-Off Ver
    2013/2016
    Posts
    6

    Sorting Node Coordinates of a Circle

    I have a couple of tables containing node coordinates of a circle. I need a formula to compare and sort them in either clockwise or counterclockwise sequence, so when modeled I could join the nodes and make the cirlce. I would highly appreciate the help. Thanks
    Attached Files Attached Files

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Sorting Node Coordinates of a Circle

    They are already in CCW order ...
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    03-10-2016
    Location
    Houston, TX
    MS-Off Ver
    2013/2016
    Posts
    6

    Re: Sorting Node Coordinates of a Circle

    Correct, individually they are, I need to have a single table with the nodes in CW/CCW sequence from both tables

  4. #4
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,082

    Re: Sorting Node Coordinates of a Circle

    If you move table 1 (B3:E6) to below your existing table 2 (ie G27) so that you have one table then put this formula into K3 and drag down you'll get the radians (0 being 12 oclock, pi/2 being 3 o'clock, pi being 6 o'clock etc etc.) Regardless of whether you follow this or not the main thing is that all these are now numbered by rotational position so all you have to do is sort your table based on the newly formed column K values and you'll have them in order. (you should maybe copy and paste as values before you sort)

    The formula is a little complicated due to the fact I wasn't sure if your circle centre would always be (0,0) so I had to take into account the possibility that it may be centred elsewhere. Hope this works

    Please Login or Register  to view this content.
    Last edited by Crooza; 03-15-2016 at 01:05 AM.
    Happy with my advice? Click on the * reputation button below

  5. #5
    Registered User
    Join Date
    03-10-2016
    Location
    Houston, TX
    MS-Off Ver
    2013/2016
    Posts
    6

    Re: Sorting Node Coordinates of a Circle

    Thanks for the help Crooza, I appreciate it. It works fine for what I have to do. Thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Get Node Key from selected Node in TreeView
    By mile990 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-02-2016, 04:55 PM
  2. Circle of 3D Coordinates
    By stockgoblin42 in forum Excel General
    Replies: 9
    Last Post: 04-05-2015, 10:03 PM
  3. XML node to column
    By sdgenxr in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-01-2015, 08:28 PM
  4. Circle within Circle Chart
    By meetukalra in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 07-18-2014, 06:47 AM
  5. Replies: 4
    Last Post: 12-17-2012, 11:45 PM
  6. How do I set up a circle within a circle chart?
    By Ken in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-04-2006, 07:45 AM
  7. Convert point coordinates -> pixel coordinates
    By Zorro in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-31-2006, 10:30 PM

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