Spreadsheets

You use spreadsheet macros for the final presentation of the SMF data. The Spreadsheet Reporter extracts measurement data from SMF dump data and finally converts it into a Working Set which then contains your individual performance data. Just load and view your performance data by feeding the spreadsheet macros with a selected Working Set.

The Spreadsheet Reporter provides several sample spreadsheet macros to help you in viewing and analyzing performance data at a glance. Examples of available spreadsheets are Workload Activity Trend Report or DASD Activity Report.

Certain spreadsheet macros require as input a Working Set derived from a Report Listing (Report Working Set), while other spreadsheets require a Working Set derived from Overview Records (Overview Working Set).

How to create Working Sets provides information about which spreadsheet macro requires which type of Working Set.

If you want to write your own spreadsheet macros, you can use the registry entry

HKEY_CURRENT_USER -> SOFTWARE -> VB and VBA Program Settings ->
RMF Spreadsheet Reporter -> JEnvironment -> path

to access the Spreadsheet Reporter working set directory, for example,

C:\Documents and Settings\Administrator\Application Data\RMF\
RMF Spreadsheet Reporter\WorkingSets

To view this registry entry, open the Windows Registry Editor by typing regedit into a command prompt.

In previous versions of the RMF™ Spreadsheet Reporter, the registry entry

HKEY_CURRENT_USER -> SOFTWARE -> VB and VBA Program Settings ->
RMF Spreadsheet Reporter -> Environment -> path

was used to store the working set directory.