Spreadsheets for Plant Design

ChemEngSoftware develops spreadsheet templates for use in designing chemical and pharmaceutical manufacturing facilities.

PipeSize is a comprehensive, user-friendly, template for sizing pipes. It does a super job at very low cost. Use the physical properties and pipe material sizes provided with PipeSize, or add your own.

TankJkt predicts heat transfer in jacketed vessels and tanks. Choose from half-pipe, conventional, and dimple jacket styles. Internal coils also supported. All kinds of agitators. And, physical properties are included for more than 100 jacket fluids.

TankVolume calculates the filled volume of vertical and horizontal vessels at any fill level. The tank heads may be flat, elliptical, spherical, torispherical (F&D), conical or guppy (horizontal tanks only). All head dimensions are user defined. The vessel shells may be circular or elliptical. A datasheet is automatically prepared that includes a graph of fill level vs. volume.

VentManifold calculates the pressure profile in a vent or flare manifold system. Make sure your relief valves aren't handicapped by an inadequate manifold system! NFPA-30 requires the assumption that all vessels within a single fire zone relieve simultaneously. VentManifold is the tool you need to model simultaneously relieving tanks.

The free Pump Datasheet template does simple calculations to complete a centrifugal pump datasheet. It uses American (English) units only, but you could easily modify it for your own units and design. Requires Excel 97 or 2000. Download Pump Datasheet now.

Inquire by email about other templates: VOC Condenser, Elastic Center Pipe Stress Method, Emergency Vent Calculation.

We will solve your plant design problems for a fee. Please write with a short description of your problem. Include your telephone number and suggest times you can talk and we will call you to discuss the particulars. Or request a written response.

Our work envelops a 20-year period. It began with an Apple ][+, Applesoft Basic and Assembly Language. By 1989 we were marketing spreadsheet templates for Lotus and Excel. Current work is focused on Excel 97.