Report Output and Formatting

This 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 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. In addition, an area chart, shaded in pink, depicts the actual target set in the target charts for the indicator you have chosen. The lines are the values acheived in the scenario, the area chart depicts the targets set for the indicator you have chosen. The following example is a PNG sub-report generated by a Range Indicator Compare Report.

Figure 125. Range Indicator Compare Report 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.