Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 10 of 10

Which point has max sum of value within a specific radius

This is a discussion on Which point has max sum of value within a specific radius within the MapPoint Desktop Discussion forums, part of the Map Forums category; Hello This is my first post on any forum! So apologies for the undoubted newbie mistakes. Current Version: Map point ...

  1. #1
    tcrumbleholme is offline Junior Member White Belt
    Join Date
    Aug 2010
    Posts
    2

    Which point has max sum of value within a specific radius

    Hello

    This is my first post on any forum! So apologies for the undoubted newbie mistakes.

    Current Version: Map point 2009

    I have imported data detailing quantities sold by postcode. This is then plotted showing me my best selling areas.

    What I am trying to do is find the exact point that has the most sales within a 50 mile radius from that point.

    Is this possible? How would I do it?

    Many thanks

    t

  2. #2
    Mattys Consulting's Avatar
    Mattys Consulting is offline Senior Member Black Belt
    Join Date
    Dec 2002
    Posts
    1,040

    Re: Which point has max sum of value within a specific radius

    Hi tcrumbleholme,

    Draw a 50 mile radius using the Radius tool on the Drawing Toolbar
    Right-click on it to Export to Excel
    Sort your result.
    Michael R Mattys
    Business Process Developers
    www.mattysconsulting.com

  3. #3
    tcrumbleholme is offline Junior Member White Belt
    Join Date
    Aug 2010
    Posts
    2

    Re: Which point has max sum of value within a specific radius

    Thanks Mattys

    I wanted to be a bit more creative than that, I was wondering if Mappoint could iterate where the best location would be that has the most sales within a 50 mile radius.

    Many thanks


    Tom

  4. #4
    Mattys Consulting's Avatar
    Mattys Consulting is offline Senior Member Black Belt
    Join Date
    Dec 2002
    Posts
    1,040

    Re: Which point has max sum of value within a specific radius

    Hi Tom,

    A shaded area map would show where the most sales occur, of course.

    After that, you'd need code to automate the solution for each of your chosen points.

    It seems to me that either Eric Frost or Richard Marsden (Winwaed) have posted methods using Excel VBA or .Net to draw radii.

    Maybe here? ---> Drawing Circles Around a List of Lat/Lons
    Last edited by Mattys Consulting; 08-17-2010 at 09:29 AM.
    Michael R Mattys
    Business Process Developers
    www.mattysconsulting.com

  5. #5
    Winwaed's Avatar
    Winwaed is offline Mapping-Tools.com Black Belt
    Join Date
    Feb 2004
    Location
    Irving,Texas
    Posts
    1,859
    Blog Entries
    60

    Re: Which point has max sum of value within a specific radius

    You may also want to try experimenting with our MPCluster product.
    See MPCluster: Cluster Analysis for Microsoft MapPoint
    There's a free trial, but licenses cost US$100

    This currently only works with pushpin point data, but you can tell it to find clusters within specific distance and number constraints. Output can be to Excel, central pushpins, and/or boundary shapes.

    Richard
    Winwaed Software Technology LLC
    http://www.winwaed.com
    See http://www.mapping-tools.com for MapPoint Tools

  6. #6
    Martijnvc is offline Junior Member White Belt
    Join Date
    Aug 2010
    Posts
    3

    Re: Which point has max sum of value within a specific radius

    I'm fighting the same issue of quantifying sales gravity points. I am interested in MPCluster.

    It is however unclear to me if MPCluster is capable of including sales volume per pushpin instead of using the number of pushpins to determine clusters. Using the count of pushpins suggests equal sales per customer which does not hold in most cases.

  7. #7
    Winwaed's Avatar
    Winwaed is offline Mapping-Tools.com Black Belt
    Join Date
    Feb 2004
    Location
    Irving,Texas
    Posts
    1,859
    Blog Entries
    60

    Re: Which point has max sum of value within a specific radius

    Sorry - yes, I've just read back through your thread this morning - I missed your point about shaded area.

    Yes MPCluster currently only works with pushpin points, and not shaded areas.

    What sort of timescale are you working with? Shaded area support is on the "to do" list but I can't see it happening in the next month...


    Richard
    Winwaed Software Technology LLC
    http://www.winwaed.com
    See http://www.mapping-tools.com for MapPoint Tools

  8. #8
    Martijnvc is offline Junior Member White Belt
    Join Date
    Aug 2010
    Posts
    3

    Re: Which point has max sum of value within a specific radius

    I don't want to steal this thread, but I guess as we're having similar troubles, tcrumbleholme doesn't mind me interrupting

    Anyway:
    Pushpin points do hold information don't they? So, I guess we'd rather cluster around pushpin points based on sales volume (being information it holds; pushpin points with weightings so to say) then that we can't cluster at all on sales volume but just customer counts (being one customer = one pushpin).

    Or, do you intent to say with "Yes MPCluster currently only works with pushpin points, and not shaded areas." that MPCluster is currently unable to incorporate any other information besides one pushpin is one customer sort of thing?

    Timescale? Suppose you don't mean me? At least I don't get it

    Appreciate the help and would definitely be interested in aqcuiring your software in case it is capable of incorporating e.g. sales volumes for imported data to cluster on (my boss permitting the expenses obviously )

  9. #9
    Winwaed's Avatar
    Winwaed is offline Mapping-Tools.com Black Belt
    Join Date
    Feb 2004
    Location
    Irving,Texas
    Posts
    1,859
    Blog Entries
    60

    Re: Which point has max sum of value within a specific radius

    MPCluster works with the positions of data points.

    As a future extension, then adding volumes (weights) would be one possibility. This would probably work as another set of constraints.

    Although it might seem that shaded area would be identical, note that shaded areas have an extent. Support would probably have to work with the CENTROID of each area.

    Richard
    Winwaed Software Technology LLC
    http://www.winwaed.com
    See http://www.mapping-tools.com for MapPoint Tools

  10. #10
    Martijnvc is offline Junior Member White Belt
    Join Date
    Aug 2010
    Posts
    3

    Re: Which point has max sum of value within a specific radius

    Well, if this functionality is added in the upcoming months, please keep me posted!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 08-14-2010, 04:34 AM
  2. how to zoom to a specific area ?
    By marcick in forum Development
    Replies: 0
    Last Post: 07-11-2008, 06:27 AM
  3. How to draw radius circle of a specific altitude...
    By Learner in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 03-24-2006, 04:17 AM
  4. The real da Vinci Code (Map Point Specific)
    By Gizz in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 04-04-2005, 06:57 AM
  5. specific map demographics
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 03-02-2005, 04:30 PM

Tags for this Thread

Posting Permissions

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


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57