[Logo: Homes and Communities: U.S. Department of Housing and Urban Development] Commmunity Planning and Development
[Vea la versión en español de esta página] [Contact Us] [Display the text version of this page] [Search/Index]
 
U.S. Department of Housing and Urban Development

Community Planning and Development
- About CPD
- Consolidated Planning
- - Tools and Guidance
- - Local Conplans
- - Regulations
- - Conplan Improvement Initiative

HUD news

Homes

Resources

Communities

Working with HUD

Tools
Webcasts
Mailing lists
RSS Feeds
Help

[The U.S. government's official web portal]  

Using CHAS Data with the CPMP
- -
 Information by State
 Print version
 
-
Helpful Tools 		-
Contact Us
If you need help using the CPMP, or have a suggestion on how to make the CPMP more useful, send us an eMail or call 1-877-483-8282. If the tool is working, let us know that too. Your feedback is important to the success of this tool!

-
In This Section 		-

CPMP User Manual
-   Download Instructions (including WinZip)
-   Organization of the Tool
-   Step 1: Initialize the CPMP
-   Step 2: Create Your Strategic Plan
- Using the CHAS Website Data
-   Step 3: Create Your First Action Plan
-   Step 4: Create Your First CAPER
-   Step 5: Repeat Steps 3 and 4 for Each Subsequent Program Year
-   Submission Instructions
CPMP User Manual - Word | PDF


The CPMP tool has been modified to allow you to easily copy and paste your census data into the CPMP.

Find your data worksheet on the CHAS website and Copy and Paste

  1. From the Housing Needs tab of Needs.xls, click the link to Housing Needs - Comprehensive Housing Affordability Strategy (CHAS) Data Housing Problems.

    Image of Housing Needs Table

  2. A new browser window should open and display the CHAS Website.

    Image of the top of the CHAS Data Website

  3. Scroll down below the main block of text and click on the Click here to view non-frames version of CHAS.

    Image showing the link to the non-frames version of the CHAS Website

    The non-frames version of CHAS will let you choose your area's data.

  4. On the first page in the non-frames series, make appropriate choices and click the Submit button.

    Image of the first page in the non-frames version of the CHAS Website

  5. On the next two pages, make more choices and then click Submit.

  6. Having now submitted three pages worth of choices, you should be presented with a spreadsheet of data.

    Image of the fourth page in the non-frames version of the CHAS Website, a spreadsheet of data

  7. Scroll to the bottom of the spreadsheet, where you should see a button labeled CPMP HSGNeed Data, One-Step Paste. Click this button.

    Image of the button for doing a CPMP HSGNeed Data, One-Step Paste

  8. An Excel file will display in your browser with columns that mimic the CPMP.

  9. Select the data in columns E and F; then press CTRL+C.

    Image showing a portion of the columns which mimic CPMP, with data selected

  10. Go back to the Housing Needs table in CPMP and place your cursor in cell E7.

    Excel detail showing Housing Needs Table with cell E7 clicked, just before pasting in data from CHAS by pressing CTRL-V

  11. Press CTRL+V. Both columns of CHAS data will be pasted into the correct locations on your CPMP Housing Needs table.

    Excel detail showing Housing Needs Table, just after pasting in data from CHAS by pressing CTRL-V
 
  Follow this link to go  Back to Top   
----------
FOIA Privacy Web Policies and Important Links  Home [logo: Fair Housing and Equal Opportunity]
[Logo: HUD seal] U.S. Department of Housing and Urban Development
451 7th Street S.W., Washington, DC 20410
Telephone: (202) 708-1112   TTY: (202) 708-1455
Find the address of a HUD office near you