Changing CMF Analyzer report data to spreadsheet format

This tutorial uses this sample file to demonstrate how the Spreadsheet Converter changes your CMF Analyzer report data into spreadsheet format. The converted sample files also show how you can use Excel to manipulate the data to produce graphics or specialized reports.

To change CMF Analyzer report data into spreadsheet format

1. Transfer the Spreadsheet Converter (CX98SSCX.XLA) to your PC.Using any file transfer method, be sure to download the converter program as binary. Refer to Installing-the-Spreadsheet-Converter-on-your-PC for additional information.
2. Copy the sample file CX98REPG from the BBSAMP library to one of your data sets, or edit the copy in UBBSAMP.
3. Create a job card for CX98REPG, and modify the SYSUT2 DD statement to designate the data set that is to receive the output containing the CMF Analyzer reports.
4. Run the job.This task creates a file containing sample CMF Analyzer reports.
5. Download the output data set to your PC using any file transfer method.Be sure to transfer in ASCII mode and rename the file using the .txt extension. For this tutorial, you can name your file tutorial.txt.
6. Open the Spreadsheet Converter (CX98SSCX.XLA) in Excel.
   • On Excel 2003 and earlier
     1. Select Add-ins from the Tools menu.

     2. Select CMF Spreadsheet Converter from the Add-Ins Available list box.

        

   • On Excel 2007 and later
     1. Click the Office button in the top left corner of the Excel window.
     2. Select Open.
     3. Locate the Spreadsheet Converter.

7. Run the Spreadsheet Converter by selecting Convert CMF Reports.A dialog box opens to display a list of your report files.

   When you select your file (such as, tutorial.txt) from the list, it will be converted automatically into Excel spreadsheets by using templates designed specifically for the CMF Analyzer reports.

   When the conversion is complete, you should see the Conversion Log, with the names of the converted reports displayed on tabs at the bottom of the screen. The tabs can be scrolled by using the arrows on the lower left of the screen.

8. Use your mouse to select the CMF Summary Report.The report displayed should look similar to the following figure. In this particular spreadsheet, a line graph was added to provide visual comparison between CPU, DASD, and TSO information.

   

9. Select the tab for the CPU Utilization Report.The report displayed should look similar to the following figure. In this particular spreadsheet, a bar chart was generated to compare performance between systems

   

10. Select the Workload Manager Map Report tab.The report displayed should look similar to the following figure. It is difficult to display time-sensitive data as columns of figures. In this example, the polar plot graphic quickly shows the times when goals were not met.

    

Select other reports to see how the data has been enhanced by using the Excel tools.

You can also use these sample reports to experiment with the Excel tools before converting your own reports.