| ASME B31.3
Calculator |
| Bibek Bhattacharyya / Bhatta from Kaneka
Engineering Corporation has released this MS Excel spreadsheet to our community.
This spreadsheet will perform an internal pressure thickness requirement and weld
branch reinforcement calculation consistent with ASME B31.3. |
|
| Pressure Drop via the Karman Method |
| Mr. Daan Le Roux of SASOL shares his
spreadsheet based on the Karman pressure drop method as featured in the June 2006 edition
of CEP Magazine. |
|
| Chemical Plant Cost Estimation |
| Ever wonder what really goes
into estimating the cost of a world scale chemical production facility? Here is a
sample of such a spreadsheet used for a project in India. Build your own from this
sample which includes virtually all of the economics that need to be considered. |
|
2005 MS Excel Spreadsheet Competition
These are some of the best entries received during the 2005 spreadsheet competition:Steam Tracing (Winner) (Excel 2007 version here)
Vapor Pressure from Antoine Coefficients
Column Diameter and HETP Calculation
Packed Column Scrubber Design
Reactor Particle Size and Velocity Calculation
Condensate Line Sizing |
|
| Two Phase Flow in Pipes |
| Download this easy to use
spreadsheet to estimate pressure losses in pipes with two-phase flow. |
|
| Various Chemical Engineering
Calculation Spreadsheets |
| Zip file with Excel
spreadsheets including calculations such as: unsteady state heat transfer, horizontal
vessel calibration data, catenary equations, compressible flow calculations, cone and
circle geometry, control valve sizing, dewpoints of acidic gases, duct calculations,
orifice sizing, packed scrubber design, flat plate deflections, pump performances, and
rectangular weir flow. These spreadsheet provided by Mr. Neil Stone of Esco Engineering. |
|
| Filtration Spreadsheets from Dr. Richard
Holdich |
| Calculations include specific
surface area, compressible cake at constant pressure, compressible cake at constant flow,
power law equation, pressure leaf clarification costing, and rotary vacuum
filtration. Complete with documentation. Files are in Excel format, download
as a zip file. |
|
| Vessel Pressure via the SRK Equation of State |
| Use this Excel spreadsheet to
find the pressure inside a vessel via the SRK equation of state (EOS). Brought to
you by the Direction of Software Corner, Somak
Mukherjee |
|
| Fired Furnace Excess Air Calculation |
| Calculate the excess air
volume required for a hydrocarbon furnace with the Orsat analysis. Excel spreadsheet
provided by the Direction of Software Corner, Somak
Mukherjee |
|
| Financial Calculation Spreadsheet |
| You know what a chore it is
to optimize a chemical process and get to the bottom line. Then you make some
changes and have to do it all over again. Here a great spreadsheet that should ease
you pain substantially! |
|
| Water Properties Program |
| Download this small helper
program so that you have the properties of water at your fingertips. The link above
is a direct link to the executable file. This program was graciously donated the
Resource Page by Pablo Coronel at pcorone@unity.ncsu.edu
|
|
| Physical Properties DataBank AddIn for
Excel |
| This Excel AddIn contains a
moderate databank of chemicals and a nice array of physical properties. It also
contains Excel functions that can be pasted into worksheets (be sure you have one open
first). You'll find the AddIn under the Tools menu. |
|
| Units Conversions |
| These handy little programs
are just about everywhere. There a good and bad side to this one. The bad side
is that is runs in DOS, the good side is that it shows many different conversions at once. |
|
| The Reactor Lab |
| A fantastic program designed
to help students gain a better understanding of reactor simulations...and best of
all....it's free! |
|
| Insulation Calculation Programs |
| Two programs included to help
you with insulation calculations. The "Economic Thickness Calculator" will
recommend the appropriate insulation thickness based on energy savings. The
"Insulated Pipe Temperature Prediction Spreadsheet" will help you predict the
temperature inside a pipe and linear heat loss. |
|
| Vapor Pressure of Binary Liquid Mixtures |
| Use this spreadsheet to find
the vapor pressure of binary liquid mixtures. Based on fugacity corrected values
from Antoines Law, this spreadsheet give accurate results with minimal inputs. |
|
| Physical Property Data Spreadsheet |
| This spreadsheet for Excel 97
contains data such as boiling and freezing points, critical data, density, vapor and
liquid heat capacities, liquid viscosity, vapor pressures, and more for 468 chemicals. |
|
| Cooling Tower Calculator |
| This handy little DOS program
will calculate the tower characteristic or cold water temperature for a given cooling
tower with just a few inputs. (See Cooling Tower
article here at the "Resource Page") |
|
Pipe Size Optimization for Carbon and Stainless
Steel Pipes
(Excel 2007 version here) |
| This simple spreadsheet will
calculate the most economical pipe diameter for a system based on flowrate, fluid density,
and fluid viscosity. The sheet is to be used for turbulent flow in carbon or
stainless steel pipes. It is designed to run on Excel 97 or higher and utilizes the
Solver function so it must be installed as well. |
|
| Validating Binary VLE Data |
| Check the thermodynamic
consistency of your binary VLE data with this easy to follow analysis. Complete with
spreadsheet to save you time! |
|
| Costing Distillation Columns |
| Enter some basic data and
this EXCEL ADD-IN will do the rest. Check out the specifications of the program. |
|
