The ALL_SYSTEM_USAGE Worksheet

 

§         Click on the ALL_SYSTEM_USAGE button.

System Usage Screen

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.

System Usage Screen

 

 

 

 

 

 

System Usage ButtonSystem Usage Values

§   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 Button

§   System Usage ScreenEnter 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.

System Usage Button
 


§   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.


·   System Usage EntryTally 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 System Usage Screenbenefiting 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.

 

§   System Usage SizeCopy 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.

 

 

§   System Usage ButtonCreate 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.

 

 

§   System Usage ButtonFormat 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.