Jump to content


File Information

  • Submitted: Feb 28 2011 12:48 PM
  • Last Updated: Jun 24 2013 02:58 PM
  • File Size: 4.15MB
  • Views: 49451
  • Downloads: 13,424

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.

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

i want to calculate insulation for a propene spherical tank(operation temp. is -40 c)
Surprisingly detailed, complete and very methodical

Thanks alot.

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.

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.



Aug 09 2015 12:20 AM

I want to know can pipe heat loss calculatior be used for steam also

Random Files

user(s) are online (in the past 15 minutes)

members, guests, anonymous users