myChemE

  • Increase font size
  • Default font size
  • Decrease font size
Home Spreadsheets
Spreadsheets

spreadsht

Chemical engineering technical problems often need to be tackled by calculation. There are many standard calculation methods - including estimation of pressure drops in pipelines and specification of process equipment (e.g. pumps). The advent of the spreadsheet is a powerful design tool which can be used to lay out standard methods in a format which can be used again and again. This section presents a number of process engineering calculations in MS Excel Spreadsheets.

 

Distillation Model

distillation_model_small

This spreadsheet presents a simplified model of a distillation column.  Download it for free.

 

Steam Tables in Excel

These Steam Tables in Excel spreadsheet can be used to provide steam property including steam enthalpy, saturation temperature, density and viscosity.

 

Manhours Worked Spreadsheet

calender

Our handy spreadsheet allows you to record your manhours worked.  NEW - Revised for the 2012 calendar year.

 

Steam Hydraulics Spreadsheet

Pipework at a chemical facilityThis spreadsheet estimates pressure drop in steam pipelines.  The spreadsheet incorporates steam tables eliminating the need to manually look up steam physical properties.

 

 

Liquid Pressure Drop Spreadsheet

Water flowing from a tapThis spreadsheet estimates pressure drop for liquid flow in pipes.  The user can select a range of standard pipe sizes and allows for pipe fittings as well as changes in elevation.

 

Pump Sizing Datasheet

pump_smallSpecifying centrifugal pumps is a common problem for Process Engineers.  This useful spreadsheet can be used for preliminary designs.

 

Gas Pressure Drop Spreadsheet

This spreadsheet estimates pressure drop in gas pipelines.  The user can select a range of standard pipe sizes and allows for pipe fittings.

 

 

Periodic Table

Periodic TableThis article provides links to several MS Excel spreadsheet versions of the period table, presenting a range of data on the elements including chemical symbol, atomic number and atomic weight.