Appendix B. QUICK START TUTORIAL › B.1 Quick Start Tutorial for CPU Planning › B.1.3 Create the CPU Worksheet

B.1.3 Create the CPU Worksheet

Use the following procedure to create a worksheet using
forecast and history from the CA MICS Capacity Planner
database as input.

 1. Choose Option 3 or the Capacity Planner Worksheet
    Facility from the Capacity Planner main screen.

    The history and the forecast data created in previous
    steps in this appendix will be used as input.

 2. Enter CREATE on the command line to create a new
    worksheet.

 3. Enter the following:

    a. Use the file recorded in Section C.1.1, Step 2 as
       the Input File.

    b. Specify Zone 1 (or the Zone that you selected).

    c. Specify your site dependent SYSID.

    d. Specify CPUPCBSY and Y to include Forecast.

 4. Press ENTER and then PF3 or END

 5. Type PRODUCE to generate the Worksheet creation job.

 6. After the job is complete, TYPE the word ENTER on the
    same line where you typed PRODUCE.

 7. Enter worksheet forecast in the worksheet forecast
    column.  Press PF3 or END when complete.

 8. Type the word APPLY on the same line to generate a job
    that applies the worksheet forecast.

 9. The worksheet file is now stored in your Private capacity
    file.

    You can verify the worksheet's existence using MWF 4;3;1
    (see figure B-5).

/---------------------  Capacity Planning Data Base Files  ---------------------\
|Command ===>                                                  Scroll ===> PAGE |
|                                                                               |
|Catalog       ===> PRIVATE (PRIVATE/SHARED)   ---------Line Commands-----------|
|Catalog group ===> QUICKS                     |A Add Notes B Browse  S Select ||
|Select mode   ===> EXECUTE (EXECUTE/MODIFY)   |M Modify    E Execute I Insert ||
|Name (subset) ===> ___                        |R Repeat    C Copy    D Delete ||
|                                              ---------------------------------|
|                                                                               |
|Cmd    Name                    Title                    Type       Status      |
| -   --------  ----------------------------------------   -   -----------------|
| _   QC1       Quick Start Monthly CPU Data               F   Forecast Only    |
| _   QC2       Quick Start (QC1)                          F   Forecst/WorkSheet|
|****************************** BOTTOM OF DATA  ********************************|
|                                                                               |
|                                                                               |
|                                                                               |
|                                                                               |
|                                                                               |
|                                                                               |
|                                                                               |
|                                                                               |
|                                                                               |
|                                                                               |
\------------------------------------------------------------------------------/

 Figure B-5.  Repeating an Inquiry

NOTE: It should say Forecst/Worksheet

10. Go to MWF 4;3;4 to copy your WorkSheet to
    sharedprefix.CAPACITY database.

    Specify Merge Forecast = Y

/---------------------  Private File Definition Selection  ---------------------\
|Command ===>                                                  Scroll ===> PAGE |
|                                                                               |
|Userid:  RUEDA02                           Catalog group         ===> QUICKS   |
|Prefix:                                    Name (subset display) ===> __       |
|Merge private forecast file ===> Y (Y/N)                                       |
|                                                                               |
|Line Cmds: S Select                                                            |
|                                                                               |
|Cmd    Name                    Title                    Type       Status      |
| -   --------  ----------------------------------------   -   -----------------|
| _   QC1       Quick Start Monthly CPU Data               F   Forecast Only    |
| S   QC2       Quick Start (QC1)                          F   Forecst/Worksheet|
|****************************** BOTTOM OF DATA  ********************************|
|                                                                               |
|                                                                               |
|                                                                               |
|                                                                               |
|                                                                               |
|                                                                               |
|                                                                               |
\------------------------------------------------------------------------------/

 Figure B-6.  Private File Definition Selection Screen

11. A SAS PROC CONTENTS executed on your
    sharedprefix.CAPACITY will report the existence of
    history, forecast, and worksheet files. (See naming
    convention as described in Section 4.4 of this guide).