8. WORKSHEET FACILITY › 8.5 Product Operation › 8.5.1 Worksheet Facility › 8.5.1.4 Entering a Worksheet
8.5.1.4 Entering a Worksheet
This section describes how to enter the values from a
worksheet into the Capacity Planner data set.
/--------------------- 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 |
|ENTER___ TEST01 Testing Worksheets - CPU Stnd. Appl. C10 Modified 25JUL97 |
|________ WRK001 Worksheet Built From WKL Stnd. Appl. Wk1 Entered 19SEP97 |
|****************************** BOTTOM OF DATA ********************************|
| |
| |
| |
| |
| |
| |
| |
\------------------------------------------------------------------------------/
Figure 8-16. Entering Worksheet Values Catalog Display
Figure 8-16 shows the Capacity Planner Worksheet Catalog
screen, displaying all the available worksheets.
/----------------------- Select CAPAPU Values for Entry -----------------------\
|Command ===> Scroll ===> PAGE |
| |
|Worksheet Name: WK1R01 - WORKSHEET WITH 9 CAPAPUS |
| |
| |
| |
|CMD Select CAPAPUS 1-8 to display the available CAPAPU9s Entered APU|
|--- ------------------------------------------------------------ --------- ---|
| S 0 1 |
| 1 2 |
| PG000000 3 |
| CAPAPU4 4 |
| CAPAPU5 5 |
| CAPAPU6 6 |
| CAPAPU7 7 |
| CAPAPU8 8 |
\------------------------------------------------------------------------------/\
Figure 8-17. Selecting Nine CAPAPU Values
Figures 8-17 and 8-18 shows the screen sequence when you are
selecting nine CAPAPUs.
/------------------------------------------------------------------------------ \
| Entering Worksheet Inquiry : WK1R01 - WORKSHEET WITH 9 CAPAPUS |
|Command ===> Scroll ===> PAGE |
| |
|Capacity Planner File: R01 - RESOURCE ELEM FILE WITH CAPAPU |
| |
|Selected |
| CAPAPU : 0 |
| CAPAPU2 : 1 |
| CAPAPU3 : PG000000 |
| CAPAPU4 : CAPAPU4 |
| CAPAPU5 : CAPAPU5 |
| CAPAPU6 : CAPAPU6 |
| CAPAPU7 : CAPAPU7 |
| CAPAPU8 : CAPAPU8 |
| CAPAPU9 : CAPAPU9 |
| |
| VARIABLE ACTUAL WORKSHEET |
| SYSID HOUR DATE NAME VALUE VALUE |
| ----- --------- --------- -------- ----------- ------------ |
| S008 10 06FEB1998 PPATCBTM 0:16:29.68 ____________ |
| S008 10 13FEB1998 PPATCBTM 0:14:15.31 ____________ |
| S008 10 20FEB1998 PPATCBTM 0:14:05.62 ____________ |
| S008 10 27FEB1998 PPATCBTM 0:15:57.92 ____________ |
| S008 10 06MAR1998 PPATCBTM 0:12:45.77 ____________ |
\------------------------------------------------------------------------------/
Figure 8-18. Worksheet Inquiry With Nine CAPAPUs
/------------------------ Select CAPAPU Values for Entry ----------------------\
|Command ===> Scroll ===> PAGE |
| |
|Worksheet Name: WK1R02 - WORKSHEET WITH 8 CAPAPUS |
| |
| |
| |
|CMD Select the CAPAPU(S) to which you wish to enter worksheets Entered APU|
|--- ------------------------------------------------------------ --------- ---|
| S 0 1 |
| 1 2 |
| PG000000 3 |
| CAPAPU4 4 |
| CAPAPU5 5 |
| CAPAPU6 6 |
| CAPAPU7 7 |
| CAPAPU8 8 |
\------------------------------------------------------------------------------/
Figure 8-19. Selecting Eight CAPAPU Values
Figures 8-19 and 8-20 show the screen sequence when you are
selecting 8 CAPAPUs.
/------------------------------------------------------------------------------\
| Entering Worksheet Inquiry : WK1R02 - WORKSHEET WITH 8 CAPAPUS |
|Command ===> Scroll ===> PAGE |
| |
|Capacity Planner File: R02 - RESOURCE ELEM FILE WITH CAPAPU |
| |
|Selected |
| CAPAPU : 0 |
| CAPAPU2 : 1 |
| CAPAPU3 : PG000000 |
| CAPAPU4 : CAPAPU4 |
| CAPAPU5 : CAPAPU5 |
| CAPAPU6 : CAPAPU6 |
| CAPAPU7 : CAPAPU7 |
| CAPAPU8 : CAPAPU8 |
| |
| VARIABLE ACTUAL WORKSHEET |
| SYSID HOUR DATE NAME VALUE VALUE |
| ----- --------- --------- -------- ----------- ------------ |
| S008 10 13FEB1998 PPATCBTM 0:14:15.31 ____________ |
| S008 10 20FEB1998 PPATCBTM 0:14:05.62 ____________ |
| S008 10 27FEB1998 PPATCBTM 0:15:57.92 ____________ |
| S008 10 06MAR1998 PPATCBTM 0:12:45.77 ____________ |
| S008 10 13MAR1998 PPATCBTM 0:14:22.87 ____________ |
| S008 10 20MAR1998 PPATCBTM 0:13:23.37 ____________ |
\------------------------------------------------------------------------------/
Figure 8-20. Worksheet Inquiry With Eight CAPAPUs
/------------------------------ Worksheet Entry ------------------------------\
|Command ===> Scroll ===> CSR |
| |
| Entering Worksheet Inquiry: TEST02 - Further Batch Activity Projections |
| |
| Capacity Planner File: BA2 - Batch Activity File - System Level |
| |
| VARIABLE ACTUAL WORKSHEET |
|Cmd SYSID HOUR DATE NAME VALUE VALUE |
| - ----- ---- ------- -------- ------------ ------------ |
| _ S008 10 31JAN1998 AVRAGBAT 2360 ____________ |
| _ S008 10 28FEB1998 AVRAGBAT 3465 ____________ |
| _ S008 10 31MAR1998 AVRAGBAT 5665 ____________ |
| _ S008 10 30APR1998 AVRAGBAT 7571 ____________ |
| _ S008 10 31MAY1998 AVRAGBAT 8774 ____________ |
| _ S008 10 30JUN1998 AVRAGBAT ____________ |
| _ S008 10 31JUL1998 AVRAGBAT ____________ |
| _ S008 10 31AUG1998 AVRAGBAT ____________ |
| _ S008 10 30SEP1998 AVRAGBAT ____________ |
| _ S008 10 31OCT1998 AVRAGBAT ____________ |
| _ S008 10 30NOV1998 AVRAGBAT ____________ |
| _ S008 10 31DEC1998 AVRAGBAT ____________ |
| _ S008 10 31JAN1999 AVRAGBAT ____________ |
| _ S008 10 28FEB1999 AVRAGBAT ____________ |
|******************************* BOTTOM OF DATA ********************************|
\------------------------------------------------------------------------------/
Figure 8-21. Entering Worksheet Values - Resource Element File
Figure 8-21 shows the Worksheet Entry screen for Resource
Element files.
/------------------------------ Worksheet Entry ------------------------------\
|Command ===> Scroll ===> CSR |
| |
| Entering Worksheet Inquiry: TEST03 - Process INV BEF File |
| |
| Business Element File: INV - Invoice Files |
| |
| VARIABLE ACTUAL WORKSHEET |
|Cmd DATE NAME VALUE VALUE |
| - ------- -------- ------------ ------------ |
| _ 31JAN1998 ORDERS 859839 ____________ |
| _ 28FEB1998 ORDERS 1087935 ____________ |
| _ 31MAR1998 ORDERS 1349796 ____________ |
| _ 30APR1998 ORDERS 1589798 ____________ |
| _ 31MAY1998 ORDERS 1770987 ____________ |
| _ 30JUN1998 ORDERS ____________ |
| _ 31JUL1998 ORDERS ____________ |
| _ 31AUG1998 ORDERS ____________ |
| _ 30SEP1998 ORDERS ____________ |
| _ 31OCT1998 ORDERS ____________ |
| _ 30NOV1998 ORDERS ____________ |
| _ 31DEC1998 ORDERS ____________ |
| _ 31JAN1999 ORDERS ____________ |
| _ 28FEB1999 ORDERS ____________ |
|******************************* BOTTOM OF DATA ********************************|
\------------------------------------------------------------------------------/
Figure 8-22. Entering Worksheet Values - Business Element File
Figure 8-22 shows the Worksheet Entry screen for Business
Element files.
Copyright © 2014 CA.
All rights reserved.
|
|