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.