| Name |
Date Added |
Availability |
Fitting Experimental Data to the Antoine Equation - Simple The Antoine equation describes the relationship between the vapour pressure and temperature of a liquid. This worksheet calculates the empirical coefficients for a given set of data. | 17-05-2005 | |
|
Equilibrium Stages Required to Separate a Propane/Pentane Mixture A propane-pentane feed at 10 bar is to be separated in a multistage distillation unit to a required purity of both components. This worksheet will calculate the required number of theoretical stages required. Data describing propane-pentane equilibrium composition is supplied. | 17-05-2005 | |
|
Pressure Loss and Liquid Flow Through Pipe Networks A storage tank with water at a constant height feeds a piping system. Ths worksheet will calculate the flowrate and the frictional pressure loss in the piping system. | 17-05-2005 | |
|
Flowrate Between Two Reservoirs A pump transfers from one reservoir to another reservoir. Check valves are placed either side of the pump and experimental head/flowrate data for the pump is available. This worksheet calculates the flowrate. | 17-05-2005 | |
|
Heating an Oil Stream under PI Control A cold oil stream is being heated in a stirred tank. The dynamic change in temperature in the tank is modelled by an ordinary differential equation. The temperature of the liquid in the tank is driven to a set point via a PI controller, which alters the heat added to the system. | 17-05-2005 | |
|
Model of a Single-Component Vaporiser under PI control This worksheet develops a simple model of a single-component vaporiser via a heat and mass balance. The vaporiser maintains a constant temperature via PI control that modifies the heat added. The governing differential equations are solved numerically. | 17-05-2005 | |
|
The Transient Draining of Liquid From One Tank to Another with a Pump with mathcad A pump drains liquid from one tank into another identical tank. It is positioned midway between each tank, connected by a pipe at the bottom of each tank. The flow is opposed by friction in the connecting pipe. This worksheet models the transient change in liquid height in each tank. | 17-05-2005 | |
|
Energy Transfer Across a Heat Exchanger Heat is being transferred from a hot to a cold stream across a heat exchanger according to the schematic below. The mass flowrates, input temperatures and specific heat capacities of both streams are known, as well as the heat transfer coefficient and heat transfer area. This worksheet will calculate the temperature of both output streams. | 17-05-2005 | |
|
Pressure Drop Through a Pipe of a Power Law Fluid A power law fluid (for which rheological data is available) is to be pumped through a pipe. This worksheet will calculate the maximum flowrate and the associated pressure drop if the flow is to be kept laminar. | 17-05-2005 | |
|
Liquid Flow Through Pumps in Parallel Two pumps in parallel pump water from a reservoir. Experimental data describing the head/flowrate relationship for each pump is available. This worksheet will calculate the flowrate at the exit piping | 17-05-2005 | |
|
Binary Distillation with the McCabe-Thiele Method A propane-pentane feed is separated in a multistage distillation unit to a required purity of both components. This worksheet calculate the required number of theoretical stages via the McCabe-Thiele method. | 17-05-2005 | |
|
2D Linear Interpolation Linear interpolation is a common scientific and engineering concept - it's the process of estimating intermediate values from a series of X-Y points by connecting adjacent points
with a straight line. This worksheet contains a program that will perform 2-D linear interpolation across two independent variables to give an interpolated value of the dependent variable. | 13-06-2005 | |
|
Pressure Drop Through a Venturi Meter Water flows through a venturi flow meter. This worksheet will calculate the pressure drop. | 17-05-2005 | |
|
Calculating the Specific Enthalpy of Ethanol This worksheet will calculate the specific enthalpy of ethanol with respect to a reference temperature. | 17-05-2005 | |
|
Liquid Flow Through a Pump A pipe receives water from a centrifugal pump. This worksheet will calculate the flowrate through the pipe. | 17-05-2005 | |
|
Pressure Drop Through a Pipe of a Two-Phase Fluid A mixture of gas and oil flow through a pipeline. This worksheet will use the Lockhart-Martinelli correlation to find the two-phase pressure gradient. | 17-05-2005 | |
|
Vapour/Liquid Equilibria of an Acetonitrile/Nitrobenzene Mixture The worksheet will calculate the bubble and dewpoint of two acetonitrile/nitrobenzene mixtures. | 17-05-2005 | |
|
Heat Transfer Coefficient for Pool Boiling of Water This worksheet will calculate the heat transfer coefficient for the pool boiling of water from a surface using the Forster & Zuber correlation. | 17-05-2005 | |
|
Fitting Experimenta Data to the Antoine Equation - Refined The Antoine equation describes the relationship between the vapour pressure and temperature of a liquid. This worksheet calculates the empirical coefficients for a given set of data. It produces an initial set of values for these quantities using a matrix inverse technique. It then attempt to refine the values; this may not necessarily give a better fit. The worksheet then picks the set of empirical parameters which gives the lowest sum of the squares of the errors. | 17-05-2005 | |
|
Heating an Oil Stream Through Three Steam-Heated Tanks Cold oil is being heated by steam through three tanks connected in series. The transient change in temperature in the three tanks is modelled by three coupled ordinary differential equations. The equations are solved numerically. The validity of the solutions is checked by comparing the numerical results to the analytical solution. | 17-05-2005 | |
|
Model of a Single-Component Vaporiser This worksheet develops a simple model of a single-component vaporiser via a heat and mass balance. The governing differential equations are then solved numerically. | 17-05-2005 | |
|
Automatic Optimisation of Controller Gains A cold oil stream is being heated in a stirred tank. The dynamic change in temperature in the tank is modelled by an ordinary differential equation. The temperature of the liquid in the tank is driven to a set point via a PI controller, which alters the heat added to the system. Rise time and overshoot are minimised via automatic optimisation of the controller gains | 31-05-2005 | |
|