Download Pipe and Storage Tank Heat Loss Calculators

17 Votes
tank heat transfer loss calculator

Series of four (4) MS Excel spreadsheets including calculations for the heat loss from horizontal and vertical storage tanks as well as heat loss from piping systems. Includes a detailed PDF document covering usage of the spreadsheets.

Basis of the work is from community member "KC" and additional contribution for "Enrico Lammers".

See this forum entry for more information

3/27/13 - Added the article that forms the basis for this method. Thanks to Art Montemayor for contributing this.

Disclaimer: All software provided "As-Is" with no warranty, expressed or implied, available. See our Terms of Use for more information.

gpcshf

May 22 2011 04:55 AM

thanks for share

Hyper

May 07 2012 04:18 AM

can i use this file for spherical tank????

i want to calculate insulation for a propene spherical tank(operation temp. is -40 c)

HSP Inc

Jul 11 2012 02:31 PM

Surprisingly detailed, complete and very methodical

fouadram

May 06 2013 09:44 AM

Thanks alot.

Michael_K

Jun 25 2013 03:06 AM

What contains the last update (24.06.2013) ? Could You update description?

Chris Haslego

Jun 27 2013 07:24 AM

What contains the last update (24.06.2013) ? Could You update description?

Yes, only the file description was changed. The forum discussion URL that was included in the description was in error and has been corrected to the right address. No changes to the file itself were made on June 24, 2013.

Mladjan

Jul 15 2015 08:50 AM

Thanks for this useful spreadsheet upload!

I have a question regarding horizontal storage tank that is located inside the building. When I set ambient temperature +5*C I got errors with values in row F118:F128.

I suppose that I need to change the formula for ΔT as absolute value of subtraction for calculation of Nusselt Number?

Thanks in advance.

Mladjan.