Blog Posts

Learn how to perform load calculations in Tas using Hevacomp geometry. Heat loss reports, duct & pipe sizing. Admittance calculations. HVAC Simulation.

In this lesson, we’ll take a look at performance – specifically, we’ll learn how to use time our macros and use dictionaries to make them really fast!

What is Smart Glass and is it the future of glazing? ‘Smart Glass’ is glazing that has changeable light and solar transmission values, there are a number of different types of Smart Glass that use different types of technology to alter these properties such as electrochromic, thermochromic and photochromic glazing. Electrochromic glazing has its light

In this lesson, we’ll continue where we left off and add some extra functionality to our macro. We’d like to extend our macro to check for duplicate zone names, sort the new zones into zone groups and read the existing zones in the file.

In this lesson, we’ll write a macro that can read zone names from an excel spreadsheet and add them to an existing 3D modeller file. We’ll then modify our macro to create zone groups for the new zones, and we’ll also add the option to read out the existing zones list from the 3D modeller file.

In this post, I’ll run through how to get ready to write your first Excel macro. If you haven’t already, I suggest you read the intro post to find out more. With each post in this series, there will be a written explanation and video.