Analyse Nodes Frequency

Source Data

This function analyses the text values of each node and produces a frequency report that looks globally across the whole tree structure.

Figure 34 – Analyse Nodes Frequency Source Data Example

Key Steps

To analyse the frequency of lobe values in source Delimited Path data, follow the steps below.

Step #

Step Detail

1

Select the column or row that contains the outline structure source data that you want to analyse.

NOTE: this function is only applicable to Delimited Path source data.

2

Click on the “Analyse Node Frequency” button in the TreeWiz Ribbon Menu in the Tools section

3

Edit the parameters in the Parameters Form that is activated. Because this function is only applicable to Delimited Path source data, the function input parameters are the same. You are not creating any outline structures, so the Excel Parameters aren’t required.

4

Click on “OK’ to perform the function or “Cancel” to exit

5

The function will perform, and a new worksheet will be created that contains the output results (see screenshot)

6

Click on “Cancel” or the form close icon to close the form.

7

 

Table 19: Group by Column Offset Key Steps

Parameters

The following dialog / form appears, containing the parameters required to analyse node frequency.

Figure 35 – Analyse Nodes Frequency Parameters Form

The table below describes the parameters in more detail.

Table 20: Group by Column Offset Parameters Description Table

Property Name

Description

Data Type

Function Parameters

Delimiter

String that separates the lobes in the delimited path

String

Alternate Delimiter

Second delimiter

String

Source Range

Source Range Address

The source range for this function will be detected as the current active selection when the function is invoked.

The address is shown to the right of the Refresh button.

This source range can be changed after function invocation.

n/a

Refresh

Click on the “Refresh” button to update the source selection.

 

Results

The Analyse Nodes Frequency creates a report worksheet containing the results of the analysis.

The columns for this report are:

  1. Node value – the literal string for each lobe of the input paths
  2. Node Freq – the global count for each instance of the node literal string value

Refer to the figure below for an example of the report output.

Figure 36 – Analyse Nodes Frequency Report Output