Showing posts with label Spread sheet. Show all posts
Showing posts with label Spread sheet. Show all posts

Friday, February 24, 2017

Top five courses for entry level Process Engineers

Process Engineering is much complex discipline in the field of Chemical Engineering. This field will challenge you like anything. While operating the process plant you may encounter with plethora of problems that need immediate attention, without which the result won't be pleasing. As a young engineer coming straight out of college you will have the enthusiasm and energy to prove your self in the process field. This kind of attitude is good but you are bound to do several mistakes in this period. Without knowing where to start and what to learn in the industry is the biggest dilemma that many of us are facing now a days. In order to proceed in this process field you should equip yourself with some special skills. These skills can be learn through several courses that are available to all now a days.

Here are the top 5 courses for entry level process engineers that are helpful for career progression.

1. Process Simulation Software Course

Process simulation software like Aspen Hysys, CHEMCAD,PRO II, HTRI etc., are very helpful in solving real time problems in process industry. With the help of these simulation software you can do
  • Optimization of a given process
  • Equipment sizing
  • Cost estimation
  • Process modelling
  • Estimation of mixture properties at various given conditions like P,V,T etc.,

    Image Source : Google/AspenTech
    The advantage of these simulation software is, they will calculate the real values rather than ideal values by using various property methods. Process Engineers who are familiar with this kind of simulation software will have edge in the interviews conducted for experienced process engineer jobs.
    Here are some of the institutes that are offering Process Simulation software course in India.

     

     2. Health, Safety and Environment Course

     

    Now a days Health, Safety and Environment (HSE) courses are available everywhere (Online/Offline) to learn. These HSE courses will boost your career in Chemical Process Industry. The main objective of these courses will be providing various methods and techniques to run the process industry cleaner and safer. At the same time this course will educate the participants to identify and manage any sort of problem that occurred during the operation. Here you will be exposed to lot of case studies, after all learning from failures is the best learning. Don't forget to get a certificate if you want to pursue these courses.
    Here are some HSEcourse qualifications that are available to learn

    In India you can find HSE courses at

     

    3. Process Engineering Course 

     

    Chemical Engineering will give you a glimpse of what is what and whats happening in a process industry. But the real challenge is designing a process industry itself. It involves sizing of various equipment like vessels, reactors, heat exchangers, absorbers, distillation columns, piping, pumps etc., Designing of relief valves, knock out vessels, decanters, two phase line sizing, project organization and various types of diagrams like PFD, PID is not common thing and we don't learn those things in our college life. So in order to be a complete process design engineer its better to pursue this course. Following are some of the institutes that are offering process engineering course in India.
    Some of the institutes offer placement assistance after successful completion of the course. Please do some research before enrolling in a particular institute.

     

    4. Microsoft Excel for Engineers Course

     

    Microsoft Excel is a not just a application to fill some tabular columns and generating some charts based on the data, in real process world it is more than that. In a process industry you will deal with many kind of reports like Daily production report, Steam balance report, MIS report, downtime report, vendor evaluation etc., Also you will encounter with various calculations which are to be done quickly yet repeatedly. This can be better handled in Microsoft Excel. In Microsoft Excel you can do the complex calculations by using various mathematical, accounting functions. Also if you master Macros in excel you can literally do anything in Excel if you give sufficient data to Excel for processing. You can learn this course either online or offline. here are some of the best resources which I came across the internet for learning Microsoft Excel.
      Lot of resources are available for learning Microsoft Excel in online mode, this will save your time and help in easy access of the content.

      5. Part Time Business Management Course

       

      This course is especially for those who have time constraint to do full time management degree. Trust me, Process engineers with a management degree are hot cakes in job market and they have higher chances of elevation in career. Those who don't have sufficient time to engage in a full time course should opt for a part time or distance course, as this course will make you a key person from process as well as corporate side in a company. You can even do an executive MBA course after attaining sufficient experience in your job, the duration of this course is generally one year. Following links will provide you the information of some institutes that are offering part time courses in business management.
        Hope the information is helpful to you, please do like the page and subscribe for RSS feed.

        Saturday, May 16, 2015

        Excel calculator for LMTD

        LMTD, Log mean temperature difference is the temperature driving force for heat transfer in flow systems. When you are calculating heat transfer by overall heat transfer coefficient (U), you should not simply multiply temperature difference of hot stream or cold stream. Multiplying this temperature difference doesn't account the overall driving force.

        Saturday, November 1, 2014

        Excel Tutorial - 1 : Mass balance calculation using Microsoft Excel

        We know that out there in this free information world, lot of soft-wares are available which ease the complexity of work. What if we can design our own mini super ninja software ( actually Excel files) to reduce our repetitive actions while calculating . Lets get started how to do simple calculations in excel.

        In this tutorial neutralization of Sulphuric acid ( H2SO4 )   by Sodium hydroxide ( NaOH )was considered. Go through the problem statement given in the below image.

        Chemineering.blogspot.com Excel tutorial

        At first mention the Chemical reaction in one of the cells (A1 or B5 etc.,). Mention the molecular weights separately in a cell. This is important to put the value in a single cell ( L6 for H2O, L7 for NaOH, L8 for H2SO4, L9 for Na2SO4) it should not contain any alphabets. If you enter alphabets in the molecular weights column it will result in error.
        Now we have given the H2SO4 quantity that should be neutralized. Put this value in a separate cell (D11) and convert it in to moles by dividing the mass with molecular weight mentioned in L8 cell.

        Chemineering.blogspot.com Excel tutorial

        Now use this moles and multiply this moles with 2 , as 1 mole of H2SO4 requires 2 moles of NaOH for Neutralization which would result in formation of 1 mole of Na2SO4 and 2 moles of H2O.

        Chemineering.blogspot.com Excel tutorial


        Chemineering.blogspot.com Excel tutorial

        Multiply the moles by molecular weight in cell E17 to get the mass of NaOH required for neutralization.

        Chemineering.blogspot.com Excel tutorial

        Similarly do it for H2O & Na2SO4

        Chemineering.blogspot.com Excel tutorial

        Mass used for reaction should be equal to mass produced in the reaction.


        Chemineering.blogspot.com Excel tutorial


        Please feel free to put up your doubts and queries below.

        To download the Excel file click the link

        Mass Balance

        Saturday, March 8, 2014

        Pressure measurement calculations in U - Tube and Inclined tube manometers using Microsoft Office Excel.

        Pressure is defined as the force exerted per unit area. In Chemical, Mechanical and Civil Engineering works pressure measurement is important in determining the frictional losses, velocity ( Using Hagen Poiseuille equation), pipe line size, etc., Also the pressure difference will indicate the type of pump, compressor to be used in liquids and gases. In order to measure the pressure difference existing in a pipe, we can use a U -Tube manometer. The two ends of the U - Tube manometer are connected to pipe in such a way that one end will be at upstream and the other in stream. Due to the pressure difference in pipe the level in the manometer limbs will differ, we will use this difference for pressure drop calculation. For this type manometer , density of manometer liquid should be higher than the density of liquid in pipe.U- tube manometer is used for normal pressure difference calculation in pipelines.
        Inclined Tube Manometer calculation using Microsoft excelU Tube Manometer calculation using Microsoft excel

        Where as inclined tube manometer is used for measuring small differences in pressure, here enlargement is provided in the vertical leg so that the movement of meniscus in the enlargement is negligible within the operating range of the instrument.
        You can Download the pressure difference calculation Excel sheet here. It includes pressure conversion feature.
        https://www.dropbox.com/s/6g2qu2umjn4w86r/U-tube%20manometer.xlsx

        Donate us to provide better content , just by clicking the ads.

        Excel file for pressure calculation in manometer.



        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.