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:
<COLUMN> TextColName1,TextColName2,...,TextColNameN,DataColName1,DataColName2,...,DataCol NameM <START> MYDATUM1,Chicago,100200112,100601536,100400624,100601536 MYDATUM2,Jersey,20045634,20135645,22411224,21044335 # This is a comment </START>
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.
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.
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.
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.
These columns contain the period data based on your NorthStar Planner data file or trending.<runcode> input file.
These columns contain the forecasted data. The number of trending data points is based on the specified # to Forecast.
The coefficient of determination. It is a value between 0 and 1, where 1 indicates that the curve fitting matched the data perfectly.
The number of good data points included in the trending analysis. Bad data points (typically values of ”-1” or “0”) are automatically omitted.
# 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 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.
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.
Allows you to display only selected rows in the table.
For example, if your Data value is set to
Displays a line chart of the raw and trending data points corresponding to the selected row in the trending table. See Figure 114 .
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.
Allows you to exclude selected periods of data from the regression.
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.