Tuesday, March 4, 2014

Use of Microsoft Office Excel in Chemical engineering calculations.

In Chemical engineering, people need to solve lot of problems in the process calculations. If done by manual method these calculations consume more time and often creates confusion. On the other hand we can use simulation software to solve small material balance  to mighty design calculations, but they are too expensive to install for personal use. Even though some free simulation software are available, they are restricted to some calculations only. Then what is the solution? Here comes Microsoft Office Excel. In Microsoft Excel you can perform small arithmetic operations like addition, subtraction, multiplication, blah blah . to complex problems like iterations for a required case.

Use of Excel in Chemical Engineering Calculations.
Microsoft Excel is equipped with some predefined functions along with charts (includes line,bar,pie charts,etc.,) which are very helpful to solve the process calculations. For example cost of production can be compared between different process by using charts for a given compound. You can also define your own function in Excel if you know VBA (Visual Basic Application) programming, which can reduce your hectic work considerably. Microsoft Excel can handle lot of information which can be compiled for the given instructions. This is particularly useful in doing the material balance calculations in stream wise across different sections like reactor, columns, strippers, etc.,
A lot of predefined and calculated excel sheets are available in internet. Here are some useful websites.

  1. http://www.chemsof.com/
  2. http://excelcalculations.blogspot.in/p/chemical-engineering-calculations.html
  3. http://www.mycheme.com/category/spreadsheets/

Invest your time in learning excel and  you can easily solve complex problems in Microsoft Office Excel.
Donate us to provide better content by clicking the ads.