Archive for January 12, 2012

BLS Data to Excel Format & Source Code

Last month, I published BLS Data in Excel format. This can be helpful for anyone who ever wants to really dig into the data but doesn’t have the time to pull data out of the atrocious BLS data tables.

I’m going to try to make this something of a monthly thing, putting these data files on my website as soon as I can convert them so that the latest BLS data is always available in a helpful format.

Additionally, I’ve added the files for employment by metro. It’s only up till September, 2011, but it’s still some super cool data.

January 2012 BLS Files

A Tables (Employment/Unemployment)

B Tables (Employment By Industry)

State Employment/Unemployment

State Employment By Industry

Metro Employment up to September 2011

Brief Interruption To Beg

This took a not-insignificant amount of time and if you use it in anything resembling a professional capacity, I’d really appreciate a beer as a way of saying thank you.

 

BLS-To-Excel Application

For those of you who are a little more interested in the data and willing to follow a lot of directions, I’ve decided to publish the program I use for this so that you’re not reliant on me to publish this every month. I do mostly Microsoft development, so you’ll need Windows to run the project

BLS Data To Excel Setup

I’ve also loaded the project to github so you can go download the source code and make it better.

BLS-Data-To-CSV on github

The code is a disaster in a large part because the BLS data is something of a disaster. However, the app itself contains some helpful tutorials on how to get the data and make everything work.

It looks awful. But if you follow the directions, it works.

This will never be a professional application, but I’ll update it as I can. If you happen to have any talent in design, my “thing” is translating designs to reality. So if you want to send me even a screenshot of how you think this app should work, I’m happy to¬†incorporate¬†that into the next version.