For what it’s worth, here’s an update to my multi-dimensional employment/ unemployment chart. I don’t think I’ve goofed anything up. The full spreadsheet is available here if you’d care to track down and critique my number crunching. I do appreciate error catching as accuracy is always of importance to an engineer. :)
I’ve modified it so that future updates will be semi-automatic and require less manual labor on my part. Otherwise, I don’t think I’d bother with it any further. As it now stands, a few minutes intense effort after the next BLS report and you should be gifted with another update. Whoopee!
Update – Viewing/browsing spreadsheets offline vs. online:
Yes, the SkyDrive viewing setup is marginally useful, and a reader has suggested that I modify the spreadsheet so as to make it more readable online. That would, however, reduce its structural functionality.
A better approach is to download the spreadsheet and browse offline. The file can be downloaded to your computer by clicking on the “Download” button near the upper left-hand corner of the viewable spreadsheet window. If you do not have Excel installed on your machine, you may download the Excel Viewer here without charge.
Again, the employment spreadsheet is to be found here. Readers not familiar with spreadsheet structure: please note the sheet tabs at the bottom of the window. Just click on a tab and you will then be viewing a different sheet.
Update II: Gallup unemployment/underemployment numbers. If you’ve not as yet had your fill, here’s a bit more cud to chew on:
March 8, 2012
U.S. Unemployment Up in February
Underemployment is 19.1%, up from 18.7% in January
by Dennis Jacobe, Chief Economist
PRINCETON, NJ — U.S. unemployment, as measured by Gallup without seasonal adjustment, increased to 9.1% in February from 8.6% in January and 8.5% in December.
Cont’d. . .
And, no, I’m not Mr. Jacobe’s doppelganger. Though it might be interesting to see how my percentage table would look with his raw numbers. It’s also interesting to see how Gallup’s survey methodology differs from that of the Bureau of Labor Statistics. You can find that at the end of the Gallup survey writeup.