DIY Heatmap "Infrared Thermal Image" using the Black and Decker TLD100
Ranked #1,352 in Home & Garden, #21,745 overall
DIY Heatmap using the TLD100 from Black and Decker and your computer
Photo courtesy Martin Tod at Flickr.com
Checking for "Heat Thieves" in the Walls, Floors and Ceilings
Look through walls like Superman!
Take a picture of an outer wall in your house (one where the opposite side is the outdoors). Print it out and draw a grid so you have about one foot squares (here's a picture of our family room with the Holiday trimmings and detritus). Here, I used Excel (version 2002).
By selecting "Format -> Sheet -> Background" and selecting the picture, you can have the picture in the background. This comes in handy if you lose paperwork frequently too. Print out the picture and start taking readings for every square. You'll want to be no more than a couple of feet from the place you're taking the readings so you can get accurate results. Unfortunately, I can't currently get the background to print, so I took a "snapshot" of it (press and hold the control button and press "Print Screen", then open a paint program and paste it in there).
Heatmap - Fill in the numbers
Now that you've made your DIY heatmap, take a look at the differences. You'll see that near our Christmas tree, there's a big difference. This is a chimney wall where (eventually) there'll be a wood stove or pellet stove, but right now, it's a big heat sink! Quick and Easy Excel Heatmap
Using conditional formatting for a better visual representation
Okay, so now you have a picture with a lot of numbers on it. Looks confusing and messy, yes? Here's a trick in Excel that will help you better visualize what's happening:Select all the numbers in your spreadsheet by clicking on the upper left hand corner and dragging down and to the right to where the last number is on the lower right-hand corner.
Under the "Format" menu, select "Conditional Formatting".
Condition 1 will be "Cell Value Is" "Between" 1 and 58. You can look over your numbers and see where the low point is, then select a number a couple of degrees above that.
Click the "Format..." button to the right, and use a dark blue color for the font. Click Okay.
Click the "Add..." button in the lower portion of the dialog box. Condition 2 will be "Cell Value Is" Between" 59 and 64 or what ever your middle average temperatures are.
Click the "Format..." button to the right, and use a dark green color for the font. Click Okay.
Do the same with the high end, choosing a dark red color for the font. Click Okay, then Okay again. Your numbers should now come up in color! Too bad there's only three conditions.
Find the TLD100 at Amazon
Your Color Heatmap
Now you can see where you need to focus your efforts!
Heatmap Alternative
Another way to the same result.
Instead of getting fancy like I did above, you can always paste a picture next to the spreadsheet, as illustrated below. Here, all you have to do is go to the menu bar, select "Insert" -> Picture -> From File... and choose the picture. Resize it and set it next to the heatmap, and it prints, too.
You can do more on your own without paying for a professional home energy audit and save yourself hundreds of dollars by following the comprehensive "Home Energy Audit handbook" by Dave Anderson. He gives you a comprehensive guide, several excel spreadsheets (not like the one I described here), and solutions to the "heat thieves" and energy losses that are in your home. "thermal camera" rental
Updated 4/3/2011
You can rent thermal imaging cameras by the day/week or month. Prices range from $299/day up as of this update, but it's always worth a look if you have the means, or if you're a contractor and want to "wow" the customer with this technology. Do a search on "thermal camera" rental .Another way to maximize your $ would be to get several neighbors together and split the rental fee. Make a day of it, be sure the one who is taking the pictures is the designated driver as well. Get the pics from all of the houses, then send it back (be sure the d.d. is the one that packs it back up too!).
Reader Feedback
Questions Comments Compliments or Complaints?
We'd love to hear from you!
-
Reply
-
Joseph Harper
Jun 15, 2011 @ 7:43 pm | delete
- nice one! this is really helpful. thank you for putting up this great lens!
_____________________________________
get the perfect DIY conservatory to improve the look and feel of your home!
-
-
Reply
-
Adrian Forbes
Dec 13, 2010 @ 7:11 pm | delete
- Great article. I was thinking about picking up one of those handheld temperature guns and a method for plotting it. Being a software engineer, I like your Excel method.
-
-
Reply
-
aperkins
Apr 3, 2011 @ 7:04 am | delete
- Thanks Adrian! I've just updated this lens with information re: thermal imaging camera rentals. Still too expensive for me and many casual users/homeowners, but I'm glad to see that they're becoming available.
-
Links to other Energy Saving Information
- Home Energy Expert Tips
- Find out what an Energy Expert has worked out for the typical home user. I'm using it to find all the leaks in my house!
Related Lenses
Check these lenses too!
Find it on eBay
Twitter Search
-
- Tamelawqy
- NEW BLACK & DECKER THERMAL LEAK DETECTOR: Exceptional customer service and unparalleled product expertise. 100%... http://t.co/QLsm5KCV
-
- cawepokax
- Black & Decker TLD100 Thermal Leak Detector (Tools & Home Improvement): Black & Decker TLD100 Thermal Leak Detec... http://t.co/pfnTfLLd
-
- Mamielbl
- http://t.co/nqwejT3u Black & Decker TLD100 Thermal Leak Detector Black and Decker
-
- Maryjanesgdv
- http://t.co/V77G6Sg9 Black & Decker TLD100 Thermal Leak Detector Black and Decker
-
- Fondaaxkj
- http://t.co/1e2EVLat Black & Decker TLD100 Thermal Leak Detector Black and Decker
by aperkins
Computer tech, avid gardener, dabbler in LED grow lights,and a scrimshander for over 25 years more »
- 37 featured lenses
- Winner of 7 trophies!
- Top lens » LED Grow Lights - Make Your Own or Buy Them Cheap!
Explore related pages
- Black & Decker TLD100 Thermal Leak Detector Reviewed Black & Decker TLD100 Thermal Leak Detector Reviewed
- Color: Meaning, Symbolism and Psychology Color: Meaning, Symbolism and Psychology
- Black Cats Need Adoptive Homes Black Cats Need Adoptive Homes
- Modern Throw Pillows Modern Throw Pillows
- Black Wall Clocks Black Wall Clocks
- Use a Heat Map to Boost Website Usability! Use a Heat Map to Boost Website Usability!