<Overview> <OpenRep> <Main> <CompRep>

OpenDef worksheet: Open CSV File

 

The OpenDef worksheet assist you in maintaining the CSV data files which are included in the workbook. The CSV files are listed on the worksheet  with the sheet name , information how many data rows are contained on the sheet , a description of the data  and the source file name.  The description must be typed in by the user of the workbook. If the workbook is generated from the “Generic Reports” spreadsheet the first CSV file is named “Initial CSV Report” and it is suggested to give it a more meaningful name. 

The worksheet contains the following commands:

       Open New Report: presents a file dialog and lets you select a CSV file. The drop down list below the “Open New Report “ button:  helps you to define how the columns are converted into the workbook. The default is that Excel will automatically determine whether a column contains numbers, dates, times or strings. But in some cases the interpretation of numbers and strings is misleading. For that purpose it is possible to set the column fix to be included as a string. The drop down list provides some examples for CSV files which are generated by the z/OS AVTEST tool set. The report which is probably most often generated and which needs some special treatment is the “LPAR Activity Report”. If you process this report select the respective entry.

In cases where you process SMF data which is not supported by any of the pre-defined reports and for which the “Default” does not provide a meaningful column you can define your own mapping. For this purpose select the   entry of the drop-down list and use the  worksheet to define the mapping. The most likely reason for using a special column mapping is for hexa-decimal numbers. Because some hexa-decimal numbers contain letter the value is automatically interpreted as a string and those which do not are interpreted as integer numbers. This is often very confusing and it is advised to include such columns completely as string values.

       Load for Reporting is a drop-down box which allows to select the report from which charts can be generated. The selected report is used on the Main and CompRep worksheets. The drop-down list is also available on these worksheets. The selected CSV data sheet is marked with an orange bar  in the CSV table.

       Delete CSV Report helps you to delete a CSV data sheet and all of its related charts. In order to delete a CSV data file you MUST place the cursor on the row of the CSV report in table . If the the cursor is misplaced or if the row does not contain a valid CSV data sheet description a message is shown that nothing will take place:

If the row contains a valid report, the report name is displayed and a confirmation to continue is requested. For example if you placed the cursor into the row of CSVREP01 the following message is displayed:

If you answer with “Yes” the report and all of its dependent charts are removed from the workbook. In the following example Chart_Trx1 and Chart_RTD3  have been created from data of CSV sheet CSVREP02. If CSVREP02 should be deleted the two charts would be deleted also. Charts which depend on other CSVREPnn worksheets are not effected as well as charts which depend on comparison data sheets, like Chart_Serv_4 which depends on Data_Serv_4. Even if Data_Serv_4 has been created from columns of CSVREP02 the data sheet and its chart remain in the workbook. The deletion of such charts and data sheets must be done manually. If you plan to remove a Data_ sheet make sure to also remove all of its depending Chart_ sheets because otherwise unresolved references remain in the workbook.

 Create a copy of the workbook allows to create a completely new spreadsheet which contains all the content of the existing workbook. You can then delete and add CSV files as you wish.