Author Archives: admin

About admin

I own and run smartprocessdesign.com

Calculate Renewable Energy Requirements

Regardless how you feel about the issue, most people would agree that the Copenhagen Climate Conference certainly didn’t resolve very much.  But don’t worry – this post isn’t going to inundate you with more vague talk about climate change and … Continue reading

Share
Posted in Environment / Climate Change, Renewable Energy / Conservation | Tagged , , , , , | 1 Comment

Microsoft Patch Causing Blue Screen of Death

This beset a few people I know: KB977165 (aka MS10-015) is causing some people to get the blue screen of death. A solution for some, which did not work for me: http://www.krebsonsecurity.com/2010/02/new-patches-cause-bsod-for-some-windows-xp-users/ Edit: Microsoft has withdrawn the patch for now. … Continue reading

Share
Posted in Computers | Tagged , , , | Leave a comment

Use VLOOKUP and HLOOKUP to use Data Tables in Calculations

Small Excel tip today: use the Excel functions VLOOKUP and HLOOKUP to allow you to use tables of data in your calculations. You can configure these commands to “look for the closest match” or to “only find an exact match” … Continue reading

Share
Posted in Excel | Tagged , , , , , | 1 Comment

Consider Finned Tubes to Increase Surface Area

This post will introduce the practice of adding fins to shell-and-tube heat exchanger tubes to increase the surface area, and discuss when to consider it and when to avoid it. This is not a post about air coolers. Image of … Continue reading

Share
Posted in Fired Heaters, Heat Exchange | Tagged , , , , | 3 Comments

Salary Comparison & Prediction Tools

It’s a new year, and maybe time for new jobs! Or at least performance reviews. Knowing your “fair salary,” or the “going market rate” that is paid for your position, can be very helpful. It’s also great to know when … Continue reading

Share
Posted in Career Advice | Tagged , , , , | 1 Comment