Before you use the spreadsheet which is contained in the package I recommend that you read general introduction to the CSV reporting feature. The spreadsheet helps to generate reports on comma separated files. In addition the spreadsheet offers some pre-defined reports based on the layout of the SMF 113 reporting tool.
In order to use the spreadsheet you must first download the result CSV data with the extension RSLDATA to your workstation. Make sure you use ASCII to EBCDIC conversion for the download. Then you can start the spreadsheet and create a copy to start a new report or extend an existing report by adding the CSV data. Please refer to Opening and deleting CSV data sheets.
The next step is to create charts. There are two worksheets for creating charts. The Main worksheet creates charts from the opened CSV data and the CompRep worksheet creates a new worksheet from one selected data item across a set of other instances. For example LPAR Busy for multiple systems. Please refer to Create Comparison Charts for this feature. There is no sample for this feature. It might also be necessary to resort the CSV data worksheet to generate a meaningful result.
For creating charts directly from the CSV data sheet it is recommended to read first the topic “Create charts on CSV data”. After including the CSV data into the new spreadsheet it is recommended to use a pre-defined reporting set:
You find this drop-down list at the bottom of the Single Chart Area. By selecting a report all fields are filled in automatically:
And you only have to press to generate the chart, example the cache
Statistics report for a z13 system: