Actual Cost – Enter updates to original budget for an Interim Cost Allocation Plan update or to finalize a Cost Allocation Plan. Command Button. Copy to the Sub_Modules Worksheet command button. This button copies the functional module to the Sub_Modules worksheet. Clicking this button opens a message box asking if you wish to preserve or delete existing data on the Sub_Modules worksheet. Figure 14 Save Sub Module Data Clicking Yes will save existing data on the Sub_Modules worksheet. Functional Modules names will be transferred to the Sub_Modules worksheet, making any necessary additions, changes, and deletions to Functional Module names already on the Sub_Modules worksheet. Clicking No will replace all data on the Sub_Modules Worksheet with the new Functional Module names. Clicking Cancel closes the message box; you will remain in the Functional Modules Worksheet. Required Fields needed for the CAM-TOOL automated calculations. Functional Module. Data Copied To Worksheet. None. Data Copied From Worksheet. Functional Module names will be copied to the Sub_Modules worksheet for further breakdown. Worksheet Calculations. None. Constraints and None. The Sub_Modules Worksheet Click on the Sub_Modules menu option to open the Sub_Modules worksheet, as shown in Figure 15. Figure 15 Sub_Modules Worksheet Copying Names from Functional Modules Overview. When you complete entry of the Functional Modules, and click the command button to Copy to the Sub_Modules Worksheet, this worksheet will display the functional module names copied from the Functional Modules worksheet, as shown in Figure 15 above.
Base Value Required Numeric Copied Entry Required field. Copied from All System Usage worksheet Num_Small Required Numeric Calculated Required field. Copied from All System Usage worksheet Num_Large Required Numeric Calculated Required field. Copied from All System Usage worksheet Usage Required Alphanumeric Copied Entry Required field. Copied from All System Usage worksheet. Xs replaced with recipient counts by Assign the Benefiting Programs Worksheet Recipient Counts command button or by Assign Recipient Counts by Program command button. Shared Usage LOE Worksheet Functional Module Required Alphanumeric Copied Entry Required field. Copied from Recipient Counts worksheet. Sub Module Required Alphanumeric Copied Entry Required field. Copied from Recipient Counts worksheet. Detail Required Alphanumeric Copied Entry Required field. Copied from Recipient Counts worksheet. Program Abbrev Required Alphanumeric Copied Required field. Copied from Recipient Counts worksheet. Usage Type Required Alphanumeric Calculated Required field. Copied from Recipient Counts worksheet. Weight Type Required Alphanumeric Copied Entry Required with weighting system. Copied from Recipient Counts worksheet. Weight Required Numeric Copied Entry Required with weighting system. Copied from Recipient Counts worksheet. Base Value Required Numeric Copied Entry Required field. Copied from All System Usage Counts worksheet. Num_Small Required Numeric Calculated Required field. Copied from Recipient Counts worksheet. Num_Large Required Numeric Calculated Required field. Copied from Recipient Counts worksheet.