
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.



Spreadsheets
These Steam Tables in Excel spreadsheet can be used to provide steam property including steam enthalpy, saturation temperature, density and viscosity.
This spreadsheet estimates pressure drop in steam pipelines. The spreadsheet incorporates steam tables eliminating the need to manually look up steam physical properties.
This 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.
Specifying centrifugal pumps is a common problem for Process Engineers. This useful spreadsheet can be used for preliminary designs.
This spreadsheet estimates pressure drop in gas pipelines. The user can select a range of standard pipe sizes and allows for pipe fittings.
This 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.