March 18th, 2011
This post is an adaptation of Ted Ngai’s climatic visualization techniques with Matlab which can be seen here:
The only problem is that Ted’s scripts use Matlab, which is a commercial software and quite expensive. On the other hand, Microsoft Excel can be found on almost every machine!
I have adapted his script which uses Matlab to generate the heatmaps into Excel. Download the Excel file here:
It isn’t that hard to work out, but even then I will give a small tutorial:
- Click on the IMPORT .EPW button and select an EPW file. This will import the weather data into Excel automatically.
- View the worksheets Ta, RH, Bn, Dh for the automatically generated heatmaps.
Here are some screenshots for the Riyadh EPW file:
Ta: Dry bulb temperature
RH: Relative humidity
Bn: Direct beam radiation
Dh: Diffused horizontal radiation
If you print these as a PDF, they can be used Illustrator or other vector-based imaging programs.
Tags: excel, heatmap, weather
This entry was posted on Friday, March 18th, 2011 at 2:44 PM.
Category: Tools, Tutorials.
You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.
5,246 Responses to this post.« Older Comments « Older Comments
Leave a Reply
You must be logged in to post a comment.