Simple frontend to view the data in the excel files submitted to Recovery.gov
Each agency has a number of files available: http://www.recovery.gov/?q=content/agencies.

Example page where Excel files a listed
http://www.recovery.gov/?q=content/agency-summary&agency_code=72

check the recovery_gov_scraper folder for scrapers.

recovery_weekly.php - handles downloading the files


row7_excel_parser.php - parses a number of agencies that use the same excel template.

Current  weeklyreport_WR*.xls files being parsed

./row7_excel_parser.php usaid
./row7_excel_parser.php doe
./row7_excel_parser.php usaid
./row7_excel_parser.php dot
./row7_excel_parser.php va
./row7_excel_parser.php fcc
./row7_excel_parser.php nasa
./row7_excel_parser.php nsf
./row7_excel_parser.php sba
./row7_excel_parser.php ssa


This is work in progress - there may be data missing. If you catch it before I do
let me know. 

to install frontend app

cd /path/to/apache2/document/root/

git clone git://github.com/chaunceyt/recovery_gov.git

mysqladmin create reportfilesDB -uuser -p
mysql reportfiles  < recovery_gov/app/config/sql/reportfiles.sql -uuser -p
cd recovery_gov/app
chmod -R 777 tmp/
http://domain.com/recovery_gov/