DTCE logoDTCE - Design Tools for Chemical Engineers
Books show, spreadsheets show & do

Home

About me?

Transport, Blending & Storage
Transport logo

Download?Download TranStoB.zip (205kB zipped). This EPOC database icon data file contains spreadsheets to help with the design of transport, storage and blending systems in a chemical plant.

Structure

The embedded spreadsheets cover the following topics:-
Friction factors - correlations from Colebrook, Steffenson-Serghides, Chen, Churchill, Swarmee-Jain, Hagen-Poiseuillen, Wilson-Azad,
Long pipeline design - Panhandle, Weymouth, Oliphant, Spitzglass & AGA correlations
Process pipe design with compressible and incompressible fluids
Process pipe design with 2-phases - Lockhart-Martinelli, Coker-Kern, Blackwell correlations, and condensate line design
Economic pipe design - brute force, analytical
Valve and fitting types - ball, plug (cock), gate, butterfly, check, and foot valves, elbows, T-pieces, contractions, enlargements, entrances, exits & orifices
Pipeline losses with fitting -equivalent length, velocity head, K, 2-K and 3-K methods
Relief valve system design - for liquids, & gases
Control valve sizing - valve characteristics, trim, quick-opening, linear, equal percent & hyperbolic
Pumps design - centrifugal
Compressor design - adiabatic & isothermal
Storage vessel design and more..

Usage

The desired embedded objects should be copied into project a project file, and the input data edited for its intended purpose.

For example, open up the TranStoB database to see the following:-
Transport, Storage & Blending example

Now search for "3-K" (to design a piping system with fittings using the latest 3-K correlations):-
Transport, Storage & Blending example

Highlight the 3-K spreadsheet with a stylus tap and copy it (ctrl-C) as below:-
Transport, Storage & Blending example

Now switch to your project file and embed the object (Ctrl-V) thus:-
Transport, Storage & Blending example

Open the spreadsheet and insert the required data in the "INPUT" data section thus:-
Transport, Storage & Blending example
Note that fluid density and viscosity can be calculated via ChemProp. Carry on entering pipeline data, the number and types of fittings until completed.

Having entered the data, pan to the bottom for the calculated pressure drop and outlet pressure:-
Transport, Storage & Blending example

Last updated 2001-09-22 - Created using FrontPage by Jeff HarmedMail me? All copyrights © reserved