§
Click on the ALL_SYSTEM_USAGE button.
The user will be presented with
the ALL_SYSTEM_USAGE worksheet as shown below:
§ The above screenshot of the ALL_SYSTEM_USAGE worksheet has been pre-populated with data. The allocation hierarchy information has been copied to this worksheet using the “Copy to the ALL_SYSTEM_USAGE Worksheet” button located on the DETAILS worksheet.
§ This worksheet captures:
· The functional module, sub-module, and detail from the DETAILS worksheet.
· The usage_type (e.g., direct or shared) - indicates whether the system functionality is shared by 2 or more programs (usage_type = shared) or is only used by one program (i.e., usage_type =Direct). The gray highlighting in this column indicates that this designation is determined by the CAM-TOOL based on program usage assignment, which is indicated by “X” in the program columns as shown in the screenshot.
· The weight_type and weight – indicates the weight value and the type of weight associated to the specific system functionality. The weight type is the descriptive label of the weight entered into the weight column. These columns are used when the allocation base does not measure level of effort. The complete description of the weighting system should be indicated on the WEIGHTING_SYSTEM worksheet.
· The num_small and num_large columns contain totals of the number of small programs and the number of large programs using the system functionality. This calculation is based on the PROGRAM_SIZE designation on the BENEFITING_PROGRAMS worksheet. The gray highlighting in these two columns indicate that these totals are calculated by the CAM-TOOL.
· The remainder of the columns (e.g., FS, TANF) capture the benefiting program usage of the system functionality. Benefiting program usage is indicated by a capital “X”. Marking a cell with a “X” under a benefiting program column indicates that the program will use or benefit from the development of the system functionality located on that row. The CAM-TOOL will automatically insert the abbreviations of the benefiting programs that are located on the BENEFITING_PROGRAM worksheet into the ALL_SYSTEM_USAGE worksheet header when information from the DETAIL tab is copied to this worksheet.
§ Enter Weights or Base Values: Allows the user to enter multiple weight, weight type,
and base value assignments for system functionality. The “Enter Weights or Base
Values” window containing all of the system functionality on the
ALL_SYSTEM_USAGE worksheet will appear after clicking on this button.
§ The user can select to enter weights and types or base
values and then select the system functionality components to insert weights
and type or base values into the worksheet.
§ In this screenshot, the user has selected to add base
values. All “Management” alerts have been selected and a value of 15 has been
entered. If the allocation base is hours, for example, then “15” means fifteen
hours of development.
§ The user clicks on the “Insert Data” button to insert the
information on to the ALL_SYSTEM_USAGE worksheet for the selected system
functionality.
§ Entering weight types is optional when entering weight
values.
§ However, if the user has selected to insert base values,
then the weight type field is disabled.
§ The user has the option to “Select All” and “Clear Selections”
in the list box of items. In addition, the user may delete values entered.
§ The total items selected in the list box are indicated at
the top of the “Enter Weights or Base Values” window.
§ Enter Usage =”X”:
Allows the user to enter multiple benefiting program usage assignments.
§ The “Enter Usage By Program” window will appear after
clicking on this button.
§ The user selects to enter usage=”X” for the benefiting
programs selected in the benefiting program drop-down box and selects system
functionality that the program will use.
§ In this screenshot, the user has selected the benefiting
program “FS” for Food Stamps, and has selected 15 items in the list box to
assign usage = “X”.
§ The user clicks the “Update Usage = “X” to add Xs to the
worksheet.
§ To correct or update usage assignments the user can click
on the ‘Show Selected Program Usage = “X”’ button. The ‘Show Selected Program
Usage = “X”’ button will highlight the system functionality items that
currently have usage=”X” on the worksheet for the benefiting program selected
in the drop-down box. The user can update system functionality selections in
the list box and click on “Update Usage = “X” button. The cells under the
drop-down box program that are related to the system functionality selected in
the list box will be updated with an “X”.
§ When the user changes the selected benefiting program
(e.g., FS) in the drop-down box, the CAM-TOOL will ask if the user wants the
list box to display the system functionality items that currently have
usage=”X” for the selected program.
§ The user has the option to “Select All” and “Clear
Selections” in the list box of items.
· The total items selected in the list box are indicated at
the top of the window.
· Tally Usage by Program Size: Allows the user to calculate the number of small and the
number of large programs using the system functionality based on the usage =”X”
assignment in the
benefiting program columns.
§ This
screenshot shows the CAM-TOOL calculations of the number of small and large
programs that use the different system functionality in the worksheet rows.
§ These
calculations are based on the number of usage=”X” assignments in the benefiting
program columns and the PROGRAM_SIZE indicator (e.g., Large or Small) on the
Benefiting_Program worksheet as highlighted in the screenshots on the right.
§ The CAM-TOOL will automatically initiate the “Tally
Usage By Program Size” button when the “Copy for System User Counts” button is
clicked. Therefore, the user does not have to use this button, unless they
would like to have an interim calculation of the usage by program size.
§ Copy for System User Counts: Copies the information on this worksheet to the
SYSTEM_USER_COUNTS worksheet for assignment of user counts to help calculate
the “fair share” for all benefiting programs based on the benefiting program
usage assignments.
§ Create Program Base Summary (ALL): is an optional button indicated by the italics of the
button. This button will create a summary of usage by benefiting program on the
PROGRAM_SUMMARY worksheet. For example, if a benefiting program only uses 45 of
100 system functionality components, then the 45 components will be listed for
that benefiting program on the PROGRAM_SUMMARY worksheet. Read the section on
the PROGRAM_SUMMARY worksheet for more details.
§ Format ALL_SYSTEM_USAGE (Copy): is an optional button that allows the user to copy the
information on this worksheet to the worksheet Format_ALL_SYSTEM_USAGE for any
desired formatting purposes or other analysis. Read the section on the
FORMAT_ALL_SYSTEM_USAGE worksheet for more details.