world logo

Mapping-Tools logo MPCluster

Cluster Analysis for Microsoft MapPoint®

Guided Tour of MPCluster: Writing the cluster data to Microsoft® Excel®

As well as drawing the cluster data, MPCluster can write the cluster information to a Microsoft Excel workbook.

Summary cluster listing

Summary of cluster sizes and positions

MPCluster's Excel output takes two forms. First, there's a Summary worksheet which lists each cluster, the coordinates of its central location, and the number of component data points (eg. pushpins).

Component pushpin listing

Individual pushpin listings for each cluster

Secondly, MPCluster lists the individual component data points for each cluster. These listings can be written in one large worksheet, or individual worksheets for each cluster (as in the example on the right). These listings include information on the parent cluster, name of the parent dataset, and all of the data point's data fields.

Excel options on MPCluster's main panel

Controlling MPCluster's Excel output

MPCluster's Excel output is controlled by two check boxes in the Display Options box.

The first of these enables the export option. The second controls whether the data point listings for each cluster are separated out into individual worksheets. All of the 'orphan' data points (ie. those which are not included in a cluster) can also be listed in their own worksheet.

The cluster run parameters can also be written to their own Excel worksheet. MPCluster typically requires a little bit of expeimentation, so it is useful to have these parameters recorded for future reference.

After calculating the clusters, it is also possible to manually modify the resulting boundary shapes. The pushpins contained by these modified shapes can be exported to Excel using the cluster annotation management dialog box.

Next, we look at the MPCluster cluster annotation management options.

Buy MPCluster Now!