Help us improve your experience.

Let us know what you think.

Do you have time for a two-minute survey?

 

Other Files

 

You can also load trending input from any file, as long as the file has the proper file format. To load this file, select Traffic > Trending > Other Files. You are prompted to specify the location of the trending file. The recommended name for this file is trending.trending.<runcode>..The file should contain the <COLUMN>, <START>, and </START> tags and have the following comma-separated format:

Note

Files in this comma-separated format can be opened automatically in Report Viewer. Go to the File Manager window, right-click on the file, and choose “Open in Report Viewer” from the drop-down menu. The <COLUMN>, <START>, and </START> tags enable the file to be read by the Report Viewer.

Trending Window

Once the data is read in, NorthStar Planner will filter out any entries with too many “Undetermined Values” such as negative numbers. How many undetermined values is too many? In NorthStar Planner, for a polynomial of degree k, the data should have no more than k undetermined values. For linear or exponential, the data should have no more than one undetermined value. Otherwise, the data is omitted from the analysis.

Note

For traffic files generated by the NorthStar Planner, a “-1” is often used for a period lacking traffic data. In Trending, a “0” zero value is also ignored so that the projection from the non-zero values are more accurate.

Figure 112: “Bad” or “Undetermined” Data Points are Discarded
“Bad” or “Undetermined” Data
Points are Discarded
Figure 113: Trending Window
Trending Window

Column

Description

Node, Intf (gray)

The node and interface to which the traffic data points and trending data points in that row correspond. Link indicates the corresponding link name and Type indicates the trunk type. Note that other fields may be present in this gray section, depending on the.input data.

Pdn (white)

These columns contain the period data based on your NorthStar Planner data file or trending.<runcode> input file.

Pdntrend (red)

These columns contain the forecasted data. The number of trending data points is based on the specified # to Forecast.

RSq (green)

The coefficient of determination. It is a value between 0 and 1, where 1 indicates that the curve fitting matched the data perfectly.

GoodDataCt (blue)

The number of good data points included in the trending analysis. Bad data points (typically values of ”-1” or “0”) are automatically omitted.

Field

Description

# to Forecast

TThe number of data points to forecast. Press <Enter> after specifying a value. The trending table will then automatically update.

Linear / Exponential / Polynomial

The type of regression to be performed.

Data

Data can be viewed and processed in two forms: either Raw (raw traffic data numbers) or Util (Raw/BW) (the traffic utilization on each trunk). The Util view is the more useful and interesting.

Moving Average

This number is used to “smooth out” any outliers in the data. If the value is set to “3”, then each data point is the arithmetic average of the traffic value in the previous, current and next time interval of the original data. If the value is set to “5”, then each data point is the average of the values of the two previous, the current, and the two following time intervals in the original data.

Adv Filter

Allows you to display only selected rows in the table. For example, if your Data value is set to Util (Raw/BW), then you might query for Pd5trend > 1.0 to identify where traffic may exceed trunk capacity five periods in the future.

Show Chart

Displays a line chart of the raw and trending data points corresponding to the selected row in the trending table. See Figure 114 .

Highlight All

Highlights all entries on the Map. Highlight all nodes in the table, all nodes and links in the table, or all links in the table along with their end nodes.

Exclude Pds

Allows you to exclude selected periods of data from the regression.

Save

Saves the current table into a TRENDING.<runcode> file.

Save as bblink

Creates a link file (in bblink format), called TRENDING_BBLINK.<runcode>, from the rows currently displayed in the table.

To Traffic Matrix

Generates the corresponding traffic matrix input file, TRENDING_TMATRIX.<runcode>, for the specified trending period. Use this file as an input to the Traffic Matrix feature, accessible via Design > T-Solve in a multitude of traffic engineering studies.

For more information on this feature, see Growth.