Previous Topic: 8.3.1 Worksheet ReportNext Topic: 8.4 Forecasting Technique Tutorial


8.3.2 Worksheet Effect Report


The Worksheet Effect Report displays information from CA MICS
Capacity Planner Files and Forecasts and shows the results of
entered worksheet information.

Figure 8-2 shows a sample Worksheet Effect Report generated
from the Workload Standard Application.  The title lines of
the report lists the SYSID, ZONE, CAPAPU(s), and the report
title you specify on the worksheet screen.

The body of the report consists of columns that correspond to
the time periods you select with the rows showing the data
elements that you selected. Each data element row consists of
the actual value selected, the optionally selected forecast
lines, and a line corresponding to the worksheet values you
enter (if present).  A footer section has a Comment block for
any text you wish to place there.

Capacity Planning Worksheet Effect Report Workload Consumption by Customer Area Payroll Department DEC97 JAN98 FEB98 MAR98 APR98 MAY98 JUN98 JUL98 AUG98 ____________________________________________________________________ _____________________________________________________________ |Batch Jobs | | | | | | | | | | | Actuals | 7895 | 6665 | 34664 | . | . | . | . | . | . | | | | | | | | | | | | |Forecast Batch | | | | | | | | | | | Jobs | 7666 | 8909 | 9886 | 10200 | 11849 | 14004 | 15794 | 18865 | 21786 | | | | | | | | | | | | |User Projection | | | | | | | | | | | Batch Jobs | 9000 | 9300 | 10000 | 11000 | 13000 | 15500 | 17000 | 23000 | 25000 | |--------------------+----------+----------+----------+----------+----------+----------+----------+----------+----------| | | | | | | | | | | | |CICS Transactions | | | | | | | | | | | Address Updates | | | | | | | | | | | | | | | | | | | | | |Forecasted Address | | | | | | | | | | | Updates | | | | | | | | | | | | | | | | | | | | | |User Projection | | | | | | | | | | | Address Updates | _________ | _________ | _________ | _________ | _________ | _________ | _________ | _________ | _________ | |--------------------+----------+----------+----------+----------+----------+----------+----------+----------+----------| | | | | | | | | | | | |CICS Transactions | | | | | | | | | | | Employee Adds | | | | | | | | | | | | | | | | | | | | | |User Projection | | | | | | | | | | | Employee Adds | _________ | _________ | _________ | _________ | _________ | _________ | _________ | _________ | _________ | |--------------------+----------+----------+----------+----------+----------+----------+----------+----------+----------| | | | | | | | | | | | |CICS Transactions | | | | | | | | | | | Employee Change | | | | | | | | | | | of Status | | | | | | | | | | | | | | | | | | | | | |Forecasted Change | | | | | | | | | | | of Status Trans | | | | | | | | | | | | | | | | | | | | | |User Projection | | | | | | | | | | | Change Of Status | _________ | _________ | _________ | _________ | _________ | _________ | _________ | _________ | _________ | |--------------------+----------+----------+----------+----------+----------+----------+----------+----------+----------| +------------------------------------------------------------------------------------------------------------------------------- INSTRUCTIONS: USER COMMENTS:_______________________________________ Please update these forecasted values with your anticipated _____________________________________________________ usage values. If you wish to specify a percentage growth _____________________________________________________ rate, place in the first blank space, if you wish to modify _____________________________________________________ each month, place modification in corresponding column of _____________________________________________________ report. If you have any questions, call the Capacity _____________________________________________________ Planning Department at X5000. If you have any comments, _____________________________________________________ please use the space at the left. Thank you.


 Figure 8-2. Worksheet Effect Report