TANKJKT spreadsheet template Heat ... - Pipe sizing …

1 UINS TJ 02 February 2015 1 TANKJKT spreadsheet template Heat Transfer Calculations for Jacketed Tanks Copyright 2001, 2015 by Stephen Hall, PE Introduction TANKJKT is an easy to use powerful spreadsheet template that calculates the rate of heating or cooling of tanks due to heat transfer from jackets and internal coils. Vessel heat transfer is complicated. It involves five resistances to heat flow each of which is dependent on specific conditions. Correlations have been developed for many different cases ( , half pipe coil jackets, turbine impellers, etc.). But other cases (dimple jackets, conventional jackets with nozzles) are either poorly researched or are proprietary and not available for use in this, or any, open product.

2 Our challenge when designing TANKJKT was to keep the data entry as simple and intuitive as possible while maintaining a comprehensive feature set. We think you'll agree that this goal was met. Data Input is gathered onto a single worksheet, described in detail in these instructions. The results of the calculations are given on a "datasheet" that matches the look of all of 's spreadsheet templates. Fluid Data are included for most common heat transfer fluids. Because the data is regressed against temperature, jacket heat transfer calculations are very fast, accurate, and easily tested with alternative fluids. TANKJKT 2 Table of Contents Quick Start .. 3 Quick Results .. 4 System Requirements.

3 5 Orientation and Initial Setup .. 6 Data Input Worksheet .. 8 Vessel Data .. 10 Jacket .. 12 Half pipe Coil Jacket (Limpet Coil) .. 12 Conventional Jacket .. 13 Dimple Jacket .. 14 Bottom Head Jacket .. 14 Internal Coils .. 15 Heat Transfer Fluid .. 15 Flow Rate Data .. 15 Vessel Fluid Data .. 18 Agitator Data .. 19 Environmental Conditions .. 20 Datasheet .. 21 Timeline .. 23 Flow Rate Calculations .. 25 Experimentally Determined Pressure Drop .. 26 Outside Heat Transfer Calculations .. 27 Half pipe Coil Jacket (Limpet Coil) .. 27 Conventional Jacket .. 27 Dimple Jacket .. 29 Internal Coil .. 29 Inside Heat Transfer Calculations .. 30 Agitator Power Calculations .. 34 Agitator Power Transferred to the Process Fluid.

4 35 Depth of Vortex .. 35 Fluid Data Worksheet .. 36 Data Tables Worksheet .. 40 PictElements Worksheet (HIDDEN) .. 40 Saved Calcs Worksheet .. 41 Result Details .. 41 Nomenclature .. 43 References .. 45 TANKJKT 3 Quick Start Perform your first heat transfer calculation by following these steps: 1. Ensure that Macros are enabled 2. Navigate to the Data Input worksheet 3. Use the dropdown boxes, radio buttons, check boxes and input fields to enter data about your tank and fluids. Input fields are displayed in RED text. 4. See the results! TANKJKT 4 Quick Results Results are displayed on the Data Input worksheet. These can be printed, but the intent is to give immediate feedback so changes to the inputs can be made before finalizing the calculation and printing a datasheet.

5 The heat transfer film coefficients are listed for the process and heat transfer fluid sides of each heat transfer surface. TANKJKT uses these, together with wall resistance and fouling, to calculate the overall heat transfer coefficient, U. Next, the flow rate, velocity and pressure drop for each of the surfaces are reiterated. The values are the same as those in the Flow Rate in Side Wall Jacket section described previously. The temperature and heat flow results are listed for each heat transfer surface and the top head. Inlet and outlet temperatures for the heat transfer fluid are given, along with the amount of heat transferred through each surface. A positive value for heat transfer indicates a heating effect; negative means cooling.

6 When combined with power input from the agitator, the total heat transfer is computed. Based on the volume of process fluid that was input in the Vessel Data section, the instantaneous rate of heating or cooling is calculated and displayed. The picture of the tank provides visual confirmation that the jacket, coil, baffles, impeller and liquid level are configured as you intended. This picture is not to any scale except that the blue shading indicating fill level accurately indicates the percent of sidewall covered by liquid. You might see messages on screen, just to the right of the Vessel Fluid Data input area. When present they warn of unusual or unexpected parameters that you might want to correct.

7 TANKJKT 5 System Requirements Personal computer running Microsoft Excel with Visual Basic for Applications (VBA). This requirement means that Open Office and other programs capable of opening and editing basic Excel worksheets will not work VBA is required. Excel 97 on the Mac lacks VBA and is therefore incompatible, however Office 2010 on the Mac is compatible Excel must be configured to allow macros to run. This can be done through Security settings, or by enabling macros each time TANKJKT is opened TANKJKT 6 Orientation and Initial Setup TANKJKT consists of six main worksheets. When you open the program you must enable macros, if your Excel security settings are set to Medium or High.

8 The Data Input worksheet should then be displayed. The main worksheets are: Data Input Enter tank, agitator and fluid (heat transfer fluid and process liquid) on this worksheet, and view the calculation results Datasheet Print a datasheet that documents the configuration of the tank system and presents the heat transfer calculation results Timeline Create and print a datasheet that shows the temperature change of the process fluid over time Fluid Data Add new heat transfer fluids to the database Data Tables See lookup values for various parameters. This worksheet contains intermediate calculations Saved Calcs Saved calculations are stored on this worksheet Although TANKJKT is ready to use immediately, there are a few things you might want to adjust to improve your experience.

9 Change the Logo You can replace the chemengsoftware logo on the datasheets with your own logo. First, unprotect the datasheet. Then right click on the logo followed by left click on the logo. This selects it without opening the hyperlink. Hit the Delete key to get rid of it, then paste your own logo in its place. Please remember to protect the worksheet again so you don t make inadvertent changes to it. Enter company info This is a good time to customize your copy by entering your basic company information into the Project Data section on the Data Input worksheet. Set up the printer Select all of the worksheets and then use the print settings dialog to establish your paper size. As shipped, TANKJKT is configured for 8 x 11 paper.

10 Outside of the you will probably want to choose A4 size. Configure decimals TANKJKT uses the function =TEXT(value, format) for many of the displayed numbers, especially on the datasheets. For example, the formula =TEXT(PI(), ) displays the value of to five decimal places, If you are in a country that uses a different convention than the for displaying thousand separators or decimals, then you ll want to change this. TANKJKT 7 Your computer country setup does not affect the TEXT formulas as used in TANKJKT . We provided an easy to use tool to adjust the formatting in TANKJKT . Instead of hard coding the number formats in all those =TEXT formulas, we use a named cell value to get the format.