Pool Heat Transfer Tools Spreadsheet

[mas985]

I recently added the "Pool Heat Transfer Tools" spreadsheet to my list here if anyone is interested. I have been working on this one for some time and attempting to calibrate the results against my own pool. It gets pretty close to actual pool water temperature. Here is a list of features:

• Heat Txfr - Estimates heat loss and gain from a full heat transfer model that includes the effects of the sun, solar panels, NG heater, heat pump, and environmental conditions. It downloads weather data from the internet based upon your location so an internet connection is required. It will also estimate the amount of water lost per day/week due to evaporation.
  
  Heaters - Compares operation costs of NG heaters and Heat pumps in a simpler format than above.
  
  Pipe Loss - Estimates the heat loss from a pipe with or without insulation.
  
  Pipe Freeze - Estimates how long it would take for a pipe to freeze.

One of the biggest challenges was to get the Sky Temperature estimate correct for the radiative losses. There are many models for this but the one that seemed to work the best for my situation was to measure my own sky temperature and calculate the emissivity . Unfortunately, this may not work well for all locations which is why I would be interested in other's experiences.

Most of the formulas used are from established sources such as: RSPEC

Download Pool Heat Transfer Tools Here

Keep in mind that this is still a work in progress and far from perfect but feedback and suggestions are always welcome.

 

[chem geek]

I can download your other spreadsheets, but for this one I get the following error:

403. That’s an error.
We're sorry, but you do not have access to this page. That’s all we know.

 

[mas985]

My mistake. Forgot to set the permission. Please try it again.

 

[bobodaclown]

Hello Mark,
Getting a Microsoft Visual Basic for Applications issue.
Compile error in hidden module: TimeFunctions
This error commonly occures when code is incompatible with the version, platform, or architecture of this application.

compile error in hidden module: TimeFunctions

 

[mas985]

Currently, the SS is Windows only. I am working on a version that will hopefully work on both.

 

[chem geek]

I get an error as well as I use a Mac:

Run-time error '438':

Object doesn't support this property or method

As soon as you have a version that works on the Mac, I'll take a look.

 

[mas985]

Thanks to Richard, the spreadsheet now works for Macs too.

 

[mas985]

I found an issue with the weather update table query in the SS so if you were having trouble try this new version (same link): Download Pool Heat Transfer Tools Here