New Excel/Browser Tool Provides Easy Way To See Up to Date Details of Oregon HUD Grantee Spending.

I have constructed a very simple Excel workbook (HERE) that allows users to easily find detailed Oregon HUD grantee spending reports, for HUD grantees selected by the user. (Data for HUD is currently updated through June 30, 2009).

Here's how it works.

• The user simply selects the name of the HUD grantee from a pull down list of more than 180 current or past Oregon HUD grant recipients in Row 1.
• A formula returns a custom hyperlink for that grantee in Row 2. (Note: Because of some coding errors/variations in original source data I have added a Row 3 with an alternate hyperlink).
  
• When the user clicks the hyperlink in Row 2, their web browser will then display an UP TO DATE multi year summary of federal grant spending for the selected grantee, including a summary of spending by program.(Note that while ALL grantee names in the spreadsheet ARE Oregon HUD grantees, SOME grantees may have also have grants from OTHER federal agencies that are included in the results shown).
• Try the link in Row 3 if link in Row 2 does not work.
• Within the summary page open in the web browser, the user can choose to narrow the time period to a single fiscal year, choose the level of detail, and also whether to display OR download the data. An additional option allows the user to see ONLY Recovery Act spending for that grantee.
• Fiscal years shown in the data are ALL Federal Fiscal years, starting Oct 1.

EXAMPLE: Clicking the link in Row 2 for the opening/default entry in the database (Oregon Housing and Community Services) will take you to their summary HERE. It shows a total of $92 Million+ in federal grant spending, and if refined to FY 2009, a total of $41 Million. Refined further, the data shows a total of $ 14.6 million in Recovery Act spending for OHCS in FY 2009.

NOTES :

1. The usaspending,gov grant database used as the source data (HERE) includes ONLY grantee and NOT sub grantee information. Grant Database does NOT include loans, or tax credits; a separate database is used to search for contracts.
2. Certain cells in the workbook are password protected to prevent inadvertent data entry errors.
3. USAspending.gov grant spending data is regularly updated on a monthly or bi-monthly basis. As of this writing, the HUD data is current as of June 30, 2009.
4. After pasting data using both Row 2 and 3 code IF you still get no data, OR if the data returned is clearly for the WRONG grantee, please add a comment below with the NAME of the grantee selected or drop me an email with the link provided in the database. As time permits I will investigate and post correct links, if available.

A permanent link to the Excel database has been added in right pane of blog; look for Oregon HUD Grantee Spending Excel Lookup.

If you want a LARGE Excel database with ALL HUD grantees and spending for FY 2009, see my prior post HERE.

Originally created and posted on the Oregon Housing Blog.