Report Output and Formatting

A Route Cost Report will automatically generate three formats: HTML, PNG and CSV. It is important that NO file extension is included when defining the filename parametre since the ".html", ".png" and ".csv" files are automatically created. The default report provided by the Report Writer is the HTML, however this format provides links to the other two formats.

The CSV sub-report contains comma separated text values which can be read into a text editor or spreadsheet application. This sub-report contains the simplest formatting, with the first row containing the column headings and subsequent rows containing values for each period. The first column in the table contains the period number, with a column heading of 'PERIOD'. Subsequent columns contain the values relating to length of road, costs and volumes hauled. The following shows a sample of a CSV format file:

	    PERIOD,YEAR,PERIODWIDTH,LENGTH,BUILTLENGTH,BUILD_EXPENSE,HAUL_EXPENSE,MAINTAIN_EXPENSE,TOTAL,
	    VOLUME,AVERAGEHAULDIST,AVERAGEBUILDCOST,AVERAGEHAULCOST,AVERAGEMAINTCOST
	    0,0,5,0,0,0,0,0,0,0,0,0,0,0
	    1,5,5,4253303,1733248,3466497,4906222,1756111,10128831,748661,95.12,4.63,6.55,2.34
	    2,10,5,4055006,1028734,2057469,5613469,1634763,9305702,752150,105.66,2.73,7.46,2.17
	    3,15,5,3790095,691204,1382409,5170484,1567058,8119950,695746,103.94,1.98,7.43,2.25
	    4,20,5,4052580,662998,1325996,4954767,1642319,7923082,695132,99.93,1.90,7.12,2.36
	    5,25,5,3237515,387554,775109,4144989,1395679,6315777,628028,92.62,1.23,6.60,2.22
	    ...
	  

The HTML sub-report contains a table holding similar information to the CSV report.

Besides the table, the HTML report also contains a title, the name of the scenario, an embedded PNG version of the report, optional supplementary HTML data (additionalHTML), a link to the CSV sub-report, and a link to an index report.

Figure 119. Route Cost HTML Table

The figure shows a truncated example of the HTML table.


The PNG sub-report shows a stacked-bar chart with one bar for each period, and one stack for each type of road cost. The PNG chart only contains a subset of the information found in the HTML table; build, haul and maintain costs. The Y-axis is automatically scaled to fit the data, and labeled with the units parameter. The X-axis displays period numbers.

Figure 120. Route Cost .png Report

The figure shows an example of the .png report.