8. WORKSHEET FACILITY › 8.5 Product Operation › 8.5.1 Worksheet Facility › 8.5.1.2 Modifying a Worksheet
8.5.1.2 Modifying a Worksheet
This section of the Product Operation section describes how
to use the Worksheet Catalog and modify an existing Worksheet
definition.
/--------------------- Capacity Planner Worksheet Catalog ---------------------\
|Command ===> Scroll ===> CSR |
| |
|Commands: Apply, Create, End, Enter, Help, Menu, Modify, Produce, Return, |
| Select |
| |
|Command Name Title File Status |
|-------- ------ --------------------------------------- ---- ---------------- |
|________ BEF001 Business Element File - Invoice File BF1 Produced 08AUG97 |
|MODIFY TEST01 Testing Worksheets - CPU Stnd. Appl. C10 Modified 25JUL97 |
|________ WRK001 Worksheet Built From WKL Stnd. Appl. Wk1 Entered 19SEP97 |
|****************************** BOTTOM OF DATA ********************************|
| |
| |
| |
| |
| |
| |
| |
\------------------------------------------------------------------------------/
Figure 8-10. Capacity Planner Worksheet Catalog
The Capacity Planner Worksheet Catalog appears after you have
created worksheet definition and any time you enter the
CATALOG Primary Command when displaying the Worksheet
Function screen (see Figure 8-3). In this case, you are
going to modify the worksheet definition for TEST01.
The Worksheet Catalog is a scrollable display showing the
names of created worksheets, the title of the worksheet
definition, the input Capacity Planner file, and worksheet
status. Similar to the Worksheet Function Menu many commands
can be entered either on the Primary Command Line or as line
commands.
The commands available on this screen have some
characteristics in common: when used on the Primary Command
Line you can specify the worksheet name at the same time, for
example, CREATE TEST02; all commands entered as line
commands, except Insert, operate on the worksheet catalog
line the cursor is on. A short description of the worksheet
commands follows:
o MODIFY (or Modify)--Used to update an existing
worksheet.
o CREATE--Used to create a new worksheet definition.
o PRODUCE (or Produce)--Used to produce a worksheet (that is,
run a job to create the Worksheet Report).
o ENTER--Used to enter the values on a worksheet into the
Capacity Planner in anticipation of applying them to the
Capacity Planner database.
o APPLY--Takes the information you entered for the worksheet
and creates a SAS file that will be placed in your Capacity
Planner database (see Section 3.1 for a description of
this file).
o INSERT--An alias for CREATE.
o DELETE--Used to delete a worksheet definition from the
Worksheet Catalog.
The following commands are also available on this screen:
o HELP--Used to see the HELP screen associated with this
screen.
o MENU--Used to display the Worksheet Function Menu. See
Section 8.5.1.1 for a description of this menu.
o END--Used to return to the Capacity Planner Main Menu.
o RETURN--An alias for END.
/--------------------------- Worksheet Definition ----------------------------\
|Command ===> Scroll ===> PAGE |
| |
| Modifying Worksheet Inquiry: TEST01 - Testing Worksheets - CPU Stnd. Appl. |
| |
|Report Title ===> Testing the Worksheet Facility - CPU Activity Tracking |
|Selection criteria: |
| Input file ===> C10 (fff) - RESOURCE ELEM FILE WITH CA |
| SYSID ===> SYS1 |
| ZONE ===> 1 |
| Specify CAPAPU values ===> N (Y/N) |
| |
|Number of previous weeks ===> 12 (1-9999) |
|Number of future weeks ===> 24 (1-9999) |
|Specify Extended Options ===> Y (Y/N) |
| |
| Name Label Line One Label Line Two Output Format Include Forecast |
| -------- -------------- -------------- --------------- ---------------- |
| CPUPCBSY CPU Percent Busy MAPCT. NO |
| CPUADJPC CPU Adjusted PCBUSY 600S MAPCT. NO |
| ________ ______________ ______________ _______________ ___ |
| ________ ______________ ______________ _______________ ___ |
| ________ ______________ ______________ _______________ ___ |
| ________ ______________ ______________ _______________ ___ |
\------------------------------------------------------------------------------/
Figure 8-11. Modifying a Worksheet Definition
Figure 8-11 shows the Worksheet Definition screen with the
values filled in from the created worksheet. Once you make
the desired changes, you can enter END to save the worksheet
or, if you make a mistake, you can enter CANCEL to lose the
modifications.
/--------------------- Capacity Planner Worksheet Catalog ---------------------\
|Command ===> Scroll ===> CSR |
| |
|Commands: Apply, Create, End, Enter, Help, Menu, Modify, Produce, Return, |
| Select |
| |
|Command Name Title File Status |
|-------- ------ --------------------------------------- ---- ---------------- |
|________ BEF001 Business Element File - Invoice File BF1 Produced 10AUG91 |
|________ TEST01 Testing Worksheets - CPU Stnd. Appl. C10 Modified 27JUL91 |
|________ WRK001 Worksheet Built From WKL Stnd. Appl. Wk1 Entered 21SEP91 |
|****************************** BOTTOM OF DATA ********************************|
| |
| |
| |
| |
| |
| |
| |
\------------------------------------------------------------------------------/\
Figure 8-12. Capacity Planner Worksheet Catalog after Modification
After the modifications are complete and END is entered on
the Worksheet Definition screen, you again see the Worksheet
Catalog with worksheet TEST01 showing a new modified date.
Copyright © 2014 CA.
All rights reserved.
|
|