+ Reply to Thread
Results 1 to 9 of 9

Diving Shapes into equal points

  1. #1
    Registered User
    Join Date
    07-29-2010
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    53

    Diving Shapes into equal points

    Hey I am trying to do something in excel using vba and struggling a fraction. What I am trying to do is divide a shape into equal points. Say a square, dividing it into 4 or more points equidistant from each other..The trick is the shape will change to any shape imaginable and I still need the program to give me a series of points within that shape. Is there a program or a function that would allow me to do such a thing, or does anyone have any ideas how i might do this. Thank You..

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

    Re: Diving Shapes into equal points

    maybe
    Please Login or Register  to view this content.
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

  3. #3
    Registered User
    Join Date
    07-29-2010
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    53

    Re: Diving Shapes into equal points

    This code is great but not exactly what I was looking for, I thing i phrased the question wrong so I will try again...I need a code, given any different shape, will find points equidistant inside the shape, not point on the shape. So for example say a square 10 x 10 m. I need to find points that are equidistant from each other inside that 10 x 10 m square shape. So say if it was one point it would be right in the middle, 4 points would be at like (2.5 2.5), (7.5,2.5), (2.5,7.5) and (7.5,7.5). This is what i need, if there is anyone that can help in any way I would greatly appreciate it thank you
    Last edited by stanysurfer; 07-30-2010 at 07:24 PM.

  4. #4
    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: Diving Shapes into equal points

    So say if it was one point it would be right in the middle, 4 points would be at like (2.5 2.5), (7.5,2.5), (2.5,7.5) and (7.5,7.5).
    That's four points equidistant from a single point, not equidistant from one another.

    The problem is not trivial, especially if the shape is irregular or not convex, unless you want a trivial solution (find any interior point, and then compute points on a vanishingly small circle about it).

    What's the application?
    Entia non sunt multiplicanda sine necessitate

  5. #5
    Registered User
    Join Date
    07-29-2010
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    53

    Re: Diving Shapes into equal points

    The application is for finding estimation variance for mining leases to use for an optimum drilling strategy. So basically if the user enters a series of coordinates, that will make a shape, such as a large mining lease. I need to be able to divide that area (whatever size or shape it may be) into equal points, INSIDE the area/shape. Basically I need to work out the estimation variance for that shape, and for that i need to divide the shape into a series of points, so that I can use the required formula.....Does this make more sense? Cheers Guys
    Last edited by shg; 07-30-2010 at 08:18 PM. Reason: deleted quote

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

  7. #7
    Registered User
    Join Date
    07-29-2010
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    53

    Re: Diving Shapes into equal points

    This kind of helps, but once again this talks about diving the polygon into a number of equal areas within that polygon on N sides...I need smething similar but with points instead of ares...
    Last edited by shg; 07-31-2010 at 08:47 PM.

  8. #8
    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: Diving Shapes into equal points

    The points of interest are presumably the circumcenters of the subdivided areas, no?

    I think you have a tiger by the tail.

  9. #9
    Registered User
    Join Date
    07-29-2010
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    53

    Re: Diving Shapes into equal points

    Yeah I think that would be correct, pretty hard you rekon?? Hmmmm
    Going to be harder than I thought
    Last edited by shg; 07-31-2010 at 08:47 PM. Reason: deleted quote

+ 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