Learn how to exploit Microsoft Excel to enhance your work as process engineer.

If you’ve ever had to work with spreadsheets that you inherited from other people, chances are they were riddled with obsolete range names that do not point to valid addresses anymore. Getting rid of those one by one by pressing the delete button is tedious and you may accidentally delete a name too many in the process. Tracking range names down however is not too difficult using a bit of visual basic code. Read the rest of this entry »

In planning and manhour forecasting you will repeatedly have to count the number of workdays within a certain date interval. In case the dates are all fridays or mondays this is easy of course, but if they are not, you cannot just count weeks and multiply by 5. Counting workdays gets even more complex if you want to account for public holidays as well.

Counting workdays by user defined function in VBA

In MS-Excel you can easily automate the process of counting workdays by using Visual Basic. And because it runs so fast, the algorithm can be quite ‘dumb’ : just run by each date in the interval, decide if it is a workday and if it is, count it:
Read the rest of this entry »

In an earlier post I have drawn attention to the VBA addin for steam properties as written by Bernhard Spang from Hamburg in Germany. Based on the popularity of that post I have decided to make another spreadheet available that is in turn based on this VBA code.

Steam Calcs V1.0 is a spreadsheet that allows the calculation of three quite common steam operations:

  • Adiabatic letdown (through a valve)
  • Isentropic letdown (through an expander)
  • Desuperheating with condensate
Download Steam Calcs V1.0

Read the rest of this entry »

Now updated for KG-Tower v5.0

One of the more annoying activities associated with tower rating is the fact that data in electronic format (from a process simulator) needs to be re-entered manually into the tower rating software. Not only is this activity useless in itself, it also provides opportunity for human error.

Read the rest of this entry »

When organizing your working day or week, you can greatly enhance your efficiency (of that ouf your team for that matter) by clearly defining priorities for your tasks.

A good method of setting priorities is the ABCDE Method that I came across in one of Brian Tracy’s personal productivity CD’s. This method requires that you review your list of tasks, before you begin, and put an A, B, C, D or E next to each one. The very act of performing this exercise and thinking through your tasks before you start work will dramatically increase your efficiency and effectiveness once you begin working.

Read the rest of this entry »


    Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 72 bytes) in /home/pzvn313114/domains/falchemist.com/public_html/wordpress/wp-content/themes/template_v007a/functions.php on line 958