Report Output and Formatting

A Comparison Report will automatically generate three formats: HTML, PNG and CSV. Each of these sub-reports contains the same data, however each is formatted appropriately for the output style. Since these formats are created automatically it is important that NO file extension is specified when defining the filename. The default report when accessed in the Comparison panel is the HTML, which contains links to the other sub-reports.

THe CSV sub-report contains comma separated text values which can be read into a text editor or spreadsheet application. This is the simplest formatting, with the first row containing column headings starting with Period, followed by each Scenario Name, and the Current Scenario. Each subsequent row represents a single planning period beginning with 'initial conditions' (P:0). The following is an example of a CSV Comparison Report consisting of one scenario and the Current conditions.

	  Period,scenariotestB,Current
	  0,4.4432104E7,4.4432104E7
	  1,4.4943138E7,4.566059E7
	  2,4.5393265E7,4.6760114E7
	  3,4.5637859E7,4.7669956E7
	  4,4.5805681E7,4.8435461E7
	  5,4.5923224E7,4.9054688E7
	  ...
	

The PNG sub-report created by the Comparison Writer is a line chart representation of the information contained in the CSV file. Each scenario is represented by a single colour coded line and identified by a legend to the right of the chart. The X-axis is labelled with all planning periods and the Y-axis is automatically scaled to fit the data contained in the scenario reports. The following example is the PNG line chart derived from the above CSV file.

Figure 122. Comparison Writer PNG Sub-Report


The PNG line chart provides an excellent visual comparison tool of the final scenario outcomes, and can be useful in determining an overall trend in the scenario solutions as compared to one another. Detailed values of each scenario can be further examined in a well defined and formatted HTML table. The HTML table contains similar information to the CSV and PNG sub-report however it is formatted in an easy to read table with each scenario represented by a column, and each row representing a single planning period. The following example illustrates the HTML version of the above CSV and PNG sub-reports.

Figure 123. Comparison Writer HTML Table


...