My Newly Constructed Excel HUD Multifamily REAC Database Allows Retrieval of All Inspection Scores by Year.

I have constructed a new Excel database HERE showing ALL HUD Multifamily REAC inspection scores as of today, with a breakout for Oregon. I took HUD data and added a (calendar) YEAR field to make viewing inspections by year easier to see.

The default view in the pivot table I constructed shows an alpha list of Oregon properties and a count of inspections by year; double clicking on the count for a specific property IN a specific year will extract the data for that year in a separate worksheet showing you the REAC score(s) for that year. (Data for Oregon shows 107 REAC inspections this year). You can use other filters to extract data for other states, as well as by metro area and county name.

Because of the large number or records the file I created is in Excel 2007 format.Some users report when they save Excel 2007 files they end up with a compressed .zip file extension. My suggestion is to RIGHT CLICK and save the file to your PC. Then navigate to the file you downloaded and look at its file extension. IF it appears as .ZIP extension, change the .ZIP extension to Excel 2007 extension (.xlsx), and THEN open the file with Excel 2007.

After downloading and opening look at the READ ME tab to see additional notes, and link to the HUD web page where I downloaded the data.

Originally created and posted on the Oregon Housing Blog.