I'm ready to subscribe! Where do I sign up?
CALCPlus
Currently in Preview Mode This is only a preview of this page which is available in the ChE Plus premium section offered by The Chemical Engineers' Resource Page. It is designed to allow potential subscribers to review the content available before deciding to purchase. The links to the information below will direct you to a Member Sign Up Page. Purchase ChE Plus today for a one time fee of only $34.99 USD. |
| CalcPlus gives ChE Plus subscribers access to Microsoft Excel™ spreadsheets to aid in calculation procedures and for use as calculation tools. Each spreadsheet is classified as a "spreadsheet tool" or a "calculation procedure". Many of the spreadsheets contain "Help" sheets to assist you in calculating some of the required information to solve your problem. English (or Imperial) and Metric units are included for all spreadsheets unless otherwise indicated. If you have an idea for a spreadsheet development, let us know. | If you spot an error in one of the spreadsheets, please email us at support@cheresources.com |
Download by right-clicking and select "Save As"
|
Packed
Tower Design [Download Spreadsheet ] |
| Spreadsheet Tool Perfect for the design of randomly packed towers, this spreadsheet tool takes you step by step through the design process and contain data for the most common types of packings. |
|
Activated
Carbon Filter Design [Download Spreadsheet ] |
| Spreadsheet Tool Utilizing the Freundlich Isotherm correlation, this spreadsheet tool is ideal for designing activated carbon filter beds to be used for gas purification. |
|
Spherical
Tank Volume Calculator [Download Spreadsheet ] |
| Spreadsheet Tool Use this tool to quickly calculate the volume of liquid in a spherical storage tank based on the radius of the tank and the height of the liquid in the tank. |
|
Boiling
Point Elevation Calculator [Download Spreadsheet ] |
| Spreadsheet Tool This spreadsheet tool will allow the users to program in calculations needing the boiling point elevations of the most common fluids used in industrial evaporation. Quickly provides the boiling point elevations from the popular chart appearing in Perry's Chemical Engineers' Handbook. The spreadsheet uses a detailed algorithm to "read" the chart on the fly with the solids concentration and the solution temperature. Compounds included are: NaOH, CaCl2, NaCl, KOH, KCl, MgCl2, H2SO4, Glycerol, Kraft Liquor, Citric Acid, Sucrose, NaNO3, (NH4)2SO4, K2CO3, Ca(NO3)2, HNO3, LiNO3, and LiCl. You can insert worksheets and build onto this workbook or extract the calculator for use in existing calculation to avoid looking up the BPE's. Spreadsheet includes both English and Metric units of measure. |
|
Sieve
Tray Tower Hydraulic Design [Download Spreadsheet ] |
| Calculation Procedure Use this handy spreadsheet to perform hydraulic designs and checks on sieve tray columns. With minimal inputs, get the estimated tray efficiency, flooding velocity, tower diameter, tray area, and hole areas. Also get a general design for the trays as well as tower pressure drop information. Tower specification summary included. This spreadsheet is nicely illustrated and included the equations for the major calculations. |
|
Water
Hammer Pressure Development
[Download Spreadsheet ] |
| Calculation Procedure Define your fluid flow system and this calculation procedures will take you through the step by step calculations to find the minimum recommended valve closing time as well as the resulting pressure experienced if the valve closes too quickly. Help sheets included are the standard pipe sizes and listings of standard fluid and pipe material properties. All equations and units are shown so that you can easily follow the calculation. |
|
Flooding
Velocity in Vertical Shell and Tube Condensers
[Download Spreadsheet ] |
| Calculation Procedure Calculating the flooding velocity for shell and tube condensers with upflow vapors is crucial to a successful design. Use the spreadsheet to determine the maximum design velocity and compare it to your actual velocity. This calculation can handle both square end and angle cut tube ends. Help sheets available include a liquid density worksheet, vapor density worksheet, surface tension worksheet, liquid viscosity worksheet, and tube data lookup chart. All equations and units are shown so that you can easily follow the calculation. |
|
Vertical
Vapor-Liquid Separator Sizing
[Download Spreadsheet ] |
| Calculation Procedure Sizing a vapor-liquid separator is part art and part science. This spreadsheet covers scenarios from moderate carryover to minimal carryover as well sizing vessel with and without mesh pads. Use the recommended sizing factors or enter your own. Customization options include the ability to change the way the spreadsheet sizes the vessel based on the operating pressure. Output includes a dimension drawing and details of the calculation performed. Help sheets included are pipe/connection sizes, liquid density worksheet, and a vapor density worksheet. All equations and units are shown so that you can easily follow the calculation. |
|
Batch
Heating/Cooling Calculations
[Download Spreadsheet ] |
| Calculation Procedure Scenarios included are non-isothermal batch heating, isothermal batch heating (steam), and non-isothermal batch cooling. Output values include heating/cooling time, heat load, service side outlet temperature at startup, and service side outlet temperature at final batch temperature. Help sheets included are steam tables and estimated overall heat transfer coefficients for agitated and non-agitated tanks. Calculation is valid for submersion style plate coils or integral jackets. All equations and units are shown so that you can easily follow the calculation. |
|
Storage
Bin Sizing [Download Spreadsheet ] |
| Calculation Procedure Perform preliminary sizing for storage bin used for bulk solids. Capable of handling 2:1 Elliptical, ASME Flanged & Dished, or flat heads. Outputs include a preliminary dimension drawing and a graph showing the volume of the vessel correlated to the height in the vessel. Help sheets include a table of minimum slide angle for various bulk solids as well details of the head styles. All equations and units are shown so that you can easily follow the calculation. |
|
Curve
Fitting Tool [Download Spreadsheet ] |
| Spreadsheet Tool Enter your X and Y values and this tool instantly provides coefficients for an eigth order polynomial fit. Additionally, you can enter an X value and this sheet will return the corresponding Y value (reading the chart). |
|
Blend
Viscosity Tool [Download Spreadsheet ] |
| Spreadsheet Tool Easily calculate the viscosity of a petroleum blend based on both the Refutas Method and the Method of Louis. Includes a sample calculation. |
|
Heat
Exchanger Performance Chart Tool
[Download Spreadsheet (English Units)] [Download Spreadsheet (Metric Units)] |
| Spreadsheet Tool Correlate performance data for a heat exchanger into easy-to-read charts. Enter your performance information, and with a click of the mouse, this spreadsheet will construct all of the necessary charts for future benchmarking of the unit. |
|
Standard
Pipe Properties Tables [Download Spreadsheet] |
| Spreadsheet Tool Standard pipe properties charts for carbon and stainless steel. Properties includes are: nominal size, outer diameter, inside diameter, schedule number, wall thickness, and flow area. Carbon steel includes ANSI and DIN standards. Stainless steel is given in ANSI format and ANSI standards converted to metric units. |
|
Standard
Pipe Properties Tool [Download Spreadsheet] |
| Spreadsheet Tool If you have a calculation that you'd like to build that includes the need to input pipe sizes, build your calculation around this handy tool. Design includes pull down boxes that read values from the standard pipe tables and returns the pipe properties. By adding sheets to this workbook, you can begin building your own calculation easily. |