Engineering Jobs by Discipline

I talked before about what states are hiring engineers and where all the engineering jobs are. Best estimate there are something like 44,000 engineering jobs open nationally right now. The census says that in 2008 84,000 people graduated with engineering degrees. Engineering shortage? I think not. Probably my 44,000 search was not broad enough to include the kinds of jobs engineering graduates might go into. But still, that's nowhere near a shortage, is it Corporate America?

So what kind of engineers are being hired right now? Software engineers.

Making up almost half of open jobs software engineers have it made. If we have a shortage of engineers, maybe it's that kind of engineer. The problem is we're recruiting people into a very diverse field without specifying what we really want or really need. I was curious how this stacked up to major choice and pulled a some numbers from a local university to give a breakdown:

You can tell mechanical and civil/structural majors are heavily overrepresented. People are probably going into these fields and finding the jobs aren't there. This is all magnified when certain geographic areas (Detroit vs Silicon Valley) have very different focuses even when colleges might be more diverse. Chemical and electrical engineering majors are a little closer to the national average of open jobs and software/computer engineering heavily underrepresented.

I'm a bit torn by including software engineers here. There's a big difference between "computer engineer" and a programmer. Many job openings ask for a degreed engineer when what they really need is a programmer. But if they're asking for an engineering degree that becomes a part of the requirement that job seekers have to meet even when it's unlike other engineering disciplines. Given the low numbers though it's possible those with other degrees, or no degrees at all, are filling the gap for these open software jobs. That is if anyone is even hiring.

Engineers good business people?

Apparently some engineer got booted off some British version of The Apprentice because the British Donald Trump (Lord Sugar?) doesn't think engineers are good at business. The engineer in question goes on to defend himself by citing other successful engineers such as: Bill Gates, James Dyson and Mark Zuckerberg.

 

Now first of all, I'm not sure a "programmer" is always an engineer. I have mad respect for Bill Gates but neither he nor Zuckerberg completed college. And both are largely known for their programming skills. Given the days of early computers Gates might have more street cred as an engineer since "programming" in its infancy was hardware driven. I'm not saying their both not successful and smart, just that I wouldn't necessarily lump them into an umbrella family of engineers for every single purpose. James Dyson, however, designed the best vacuum I ever used and appears to be like the Tony Stark of vacuum cleaners. Though I'm not entirely sure he has a degree in education that would make all three of them just general genius types. I mean two of them dropped out of Harvard. You gotta figure in many cases have you the advantages to get into Harvard you're already at a good spot (whether that's social upbringing advantages or just pure raw natural talent).

 

Second of all, this argument always makes me think of Tom Smykowski from the movie Office Space who defends his job by saying he's necessary because engineers aren't good with people. I know a great many liasons and systems analysts and project coordinators who it would seem have the same responsibility: go between from the technical to the customer (one could almost argue the highly paid Program Manager fulfills this role as well). It's not so much I think that engineers and technical folks are not good with people, but that their technical skills are valued in such a way that's how management wants them to spend 100% of their time. Versus you can hire somebody else to be the facilitator or communicator. But it does seem to be the trap that engineers and probably scientists fall into.

 

What do you think, does that hold technical people back? What about the other way, are liasons and communicators valued in the same way technical employees are?

Excel-Fu: Selection Boxes and Cost

I thought it might be handy to post some of the tips and tricks I've been learning lately in various software programs. Because in order to teach myself I had to go scouring the internet for different sources, and maybe someone else is trying to do the same thing (plus the best way to remember something seems to be to teach it to somebody else, or if that fails write it down in the indelible ink of the internet).

Say you're considering building an assembly and have different options for different parts that would result in total cost differences. For my example I'm only using two components, but if you had a lot you might want something more automated. In the end what I needed was several drop down boxes where each option would reflect its cost and then add to a total below.

So here's how you'd do that which should be helpful if you've been trying to implement drop downs in Excel, use a lookup table, or figure out how to pull and use data from a selected drop down value.

In order to use a drop down you need what Excel considers developers tools. In order to turn this tab in, you go to File-> Excel Options. There, depending on your version of Microsoft Office, it might be under the popular tab, or might be under the "customize ribbon" tab. You want to have the "show developer tab" checked.

Then you go into your developer tab, click "insert" and there should be a drop down of various options. The one I'm using is the Form Controls -> Combo Box. But I imagine a lot of this stuff would work on either types of controls and boxes.

This will turn your mouse into a little plus sign. Go ahead and drag how big you want your box over wherever you want it. Then right click it and select Format Control.

But let's backtrack. First you're going to need some data for all this. I have two sets of options for my two widgets. You can locate this in another sheet of your excel document, but here I've stuck mine on the same sheet so it's clear what I'm doing.

Now back to your format control. It gives you three options to fill in in the "control" tab. Input range, cell link, and drop down lines. If I'm building the box for my first widget (options A through C) my input range is I3:I5. You can type this in, or just put your mouse in the box then drag your mouse over the cells you want. For right now, you don't care about the cost, only your "names". Cell link is the actual cell where your drop down value is going to be stored. I usually select the cell that seems most inhabited by my drop down box. Drop down lines is the number of values I have, 3 in this case, and I usually select 3-D shading cause why not, it's pretty.

Now you've got a drop down box that has some values in it that you can select. If it's bugging out at this point, you've probably messed something up in switching between sheets, so re-check your values and make sure they're still calling out the cells you want.

Next you'll need two columns to the right. One I've hidden because its sole purpose is to grab the "name" from the drop down. The problem with excel and drop down menus is it just correlates values to numbers. If you try to copy the value of your drop down it will just be a number of 1 through N where N is the number of options you have. In order to get that number to correspond to the value, you have to use a kind of silly workaround formula, the OFFSET formula.

In this case it's =OFFSET(the cell directly above my "names" table,the cell that my drop down box is storing its info in,0). The 0 is the actual offset value. Or in my case, =OFFSET(I2,C3,0). This is all important too because it means you need a row above your names table as you can see I had above. Now no matter which value you select in drop down, the column should mirror that value. Since you don't really need this column again later you can hide it (right click the whole column, select hide).

Next to callout the price value of your component you'll use the tables I showed a few figures up. This is the next colum over and uses the VLOOKUP function.

So the values I want here are =VLOOKUP(the value I'm converting, my WHOLE lookup table, 2, FALSE) or in my case =VLOOKUP(F3,I3:J5,2,FALSE). The 2 is because the value I want is in the 2nd column. If you were selecting a larger table you could specify any column you want. The F3 cell is where I used offset to grab the "name" value from the drop down. The false is to indicate I want only an exact match (for the name) rather than a partial match.

So now you can have drop downs with selected values, connect them to prices, and of course you can use a sum value (=SUM(G3:G7) ) to nab your costs and make a total further down.

Some of these methods are probably cheap workarounds, but still I hope you learned something. If you didn't and were bored sorry. Maybe you can write in with your badass software tricks.

AutoCAD: Back in Mac

Soon you'll be able to run AutoCAD on a Mac and even an iPhone and iPad. This is supposedly so designs can be changed "in the field." I'd like to see a real AutoCAD user modify something on an iPhone. I'm sure that's very effective.

 

I can tell you exactly how this is going to go down by the tweet I just read when I tried to google for more information: AutoCAD on mac? great now will have to ask my dad to teach me the program. A bunch of 15 year old mac fanbabies have no f-ing clue what this program does and think it's in their best interest to learn it. For what purpose? Who knows. They do know you don't use AutoCAD to make wallpapers, youtube videos, or ipod songs right? That you need to actually design something not just poach lazily off other people's work like some Adobe-lite program? This is not Elements, get back in the kiddie pool. To all you real CAD users out there who for whatever ridiculous reason use a mac; welcome back.