Blog Posts

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.

Coding is going to form an important part of the energy modelling of the future, but many feel overwhelmed by the prospect and don’t know where to start. Sound familiar? If so, this blog post series is for you. All you need is Tas and Excel.

Modelling hybrid ventilation units for part L2 and EPC purposes Hybrid ventilation units have become very popular in recent years, often being used in priority schools as a lower energy alternative to mechanical ventilation or air conditioning. The units are available from a variety of manufacturers and often have a range of different ‘ventilation modes’

UK Weather data sets guide There are so many different weather files available these days and with a large number of assessments, each specifying weather data files to use it can be hard to keep track of which weather files are required for which assessments. We’ve put together a guide outlining most of the applicable