Welcome to MapForums!

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

## 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. 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. ## 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

3. 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. ## 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.

5. ## 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

6. 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. ## Re: Which point has max sum of value within a specific radius

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

8. 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. ## 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

10. 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!