|
|
|
|
|
Step 1: Initialize the CPMP for the Grantee Program
|
Task 1: To Open the CPMP Main Worksheet:
- Navigate to the CPMP_ver2 directory on your computer.
- Double-click the file called 1CPMP.xls.
MS Excel will launch and a message box will appear asking if you want to Enable Macros. Click Yes.
|
Note: While on most occasions, you want to disable most macros because that is how viruses are perpetuated, for this application, the macros are what give the tool life and help you to save time by prefilling certain elements.
|
- You will be brought to the beginning of the CPMP Main Worksheet in the CPMP tool.
- Click on the Step 1 link. You will be brought to the Step 1 section of the tool.
Task 2: To Complete the Consolidated Plan Cover Worksheet:
- Click the ConPlan Cover button. You will be brought to the Consolidated Plan Cover Worksheet.
- Complete the relevant information. All necessary fields that are colored light blue should be completed with the appropriate information. Drop-down lists have been provided for certain standard information.
|
Note: Certain fields in this worksheet are linked to other documents in the tool. By failing to fill in some fields, your personalized information may not be passed on to other tool documents.
|
Scroll down to the bottom of the worksheet and click the CPMP Main Worksheet button. You will be returned to the Step 1 section of the tool.
Task 3: Complete the Grantee Information Worksheet:
- Click the Grantee Information button. You will be brought to the Grantee Information Worksheet.
- Complete the relevant information. All necessary fields that are colored light blue should be completed with the appropriate information. Drop-down lists have been provided for certain standard information.
|
Note: Certain fields in this worksheet are linked to other documents in the tool. By failing to fill in certain information, you may encounter default values where you need a customized value.
|
- Scroll down to the bottom of the worksheet and click the CPMP Main Worksheet button. You will be returned to the Step 1 section of the tool.
Choose File and select Save. Or you may simply click the Save button on your Word/Excel Toolbar. Please remember to save your work frequently. There is nothing more annoying than completing a bunch of fields only to lose your work. By saving frequently you minimize the amount of data that can be lost if something bad happens.
Task 4: Go to Step 2:
- Click the Go to Step 2 button.
|
|
|