Using CHAS Data with the CPMP

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 to cpmp@hud.gov. If the tool is working, let us know that too. Your feedback is important to the success of this tool!

CPMP User Manual Quick Links

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 (http://socds.huduser.org/scripts/odbic.exe/chas/index.htm).

    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 (http://socds.huduser.org/scripts/odbic.exe/CHAS/statetable.htm) 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
 
Content Archived: May 9, 2012