An Overview of the CAM-TOOL

 

Splash Screen Worksheet and Navigation

 

After clicking on the “Enable Macros” button, the user will be presented with the CAM-TOOL Splash Screen as shown below:

Main Screen
 


§         Users will see the standard Microsoft Excel menus and the names of the worksheets at the top and bottom of the screen in the CAM-TOOL.

 

§         The splash screen includes the CAM-TOOL image icon highlighted in black in the above image and CAM-TOOL copyright and acknowledgement information in the bottom-half of the screen.

§         The splash screen contains a navigation menu that indicates all of the standard worksheets provided in the CAM-TOOL. The navigation menu contains three sections:

 

1.      (Buttons 1 – 7): The top seven command buttons direct the user to the worksheets that capture data about the system under cost allocation. These worksheets contain data concerning system background information, the benefiting programs, and the methodology of allocation, which includes the ALLOCATION_STRUCTURE, FUNCTIONAL_MODULES, SUB_MODULES, Details, and the Weighting System worksheets.

 

2.      (Buttons 8 – 11): The middle four buttons direct the user to the worksheets that track system functionality usage by benefiting program. These sheets help determine and calculate the “fair share” of cost allocation for the benefiting programs.

3.       (Buttons 12 – 15): The bottom 4 buttons direct the user to the optional CAM-TOOL worksheets which include creating a summary by benefiting program, formatting data from the ALL_SYSTEM_USAGE and SHARED_USAGE_LOE worksheets, and accessing all files in the help menu.

 

Menu

1. SYSTEM_INFORMATION: any relevant information supplied about the system undergoing cost allocation

 

2. BENEFITING_PROGRAMS: a listing of programs that will benefit from the system development and program related information

 

3. ALLOCATION_STRUCTURE: information on the methodology of allocation, which includes definitions of the levels of allocation (i.e., functional module, submodule, and detail) and the selected allocation base(s).

 

4. FUNCTIONAL_MODULES: all high-level system development categories

 

5. SUB_MODULES: all secondary-level system development categories

 

6. DETAILS: all third-level system development categories

 

7. WEIGHTING_SYSTEM: an explanation of how complexity of the system development effort will be measured, if the selected allocation base does not measure level of effort

 

8. ALL_SYSTEM_USAGE: the usage (i.e., benefit) of the system by each benefiting  program

 

9. SYSTEM_USER_COUNTS: a copy of the ALL_SYSTEM_USAGE worksheet with the user counts (i.e., recipients or caseloads) assigned for each benefiting program

 

10. SHARED_USAGE_LOE: the calculated level of effort values for shared system usage used to calculate the cost allocation plan

 

11. COST_ALLOCATION_PLAN: the final cost allocation percentages based on the results in the SHARED_USAGE_LOE worksheet

 

12. PROGRAM_SUMMARY: a summary of the system functionality usage by benefiting program

 

13. FORMAT_ALL_SYSTEM_USAGE: is a copy of the ALL_SYSTEM_USAGE worksheet for formatting

 

14. FORMAT_SHARED_USAGE: is a copy of the SHARED_USAGE_LOE worksheet for formatting

 

15. HELP: provides a listing of the CAM-TOOL help files related to all of the worksheets

The CAM-TOOL Worksheet Format

 

 

The following screenshot is an example of the SYSTEM_INFORMATION worksheet:

Worksheet