As an Excel user, I’m always looking for ways to automate repetitive tasks and make my workflow more efficient. That’s where Office Scripts come in. The way office scripts are advertised out of the box is that they’re a feature in Excel that enables you to automate tasks by recording your actions and replay them whenever I want. you can…
Digital
Just like Crocs or Carhartt, digital twins are all the rage right now, offering a new way to simulate, monitor, and optimise physical assets. But here’s the catch: not every client needs—or even wants—a digital twin. There’s a lot of buzz around digital twins, but the key is to align these powerful tools with what the client actually needs, not…
Leaders’ constant expression of busyness can significantly impact team performance and morale. It sets a negative example, leading team members to feel pressured to appear busy to seem important. This pressure sets the scene for a slew of bad habits and poor optics. Leaders who consistently portray themselves as busy may encourage similar behaviours in their team, fostering a culture…
In a previous post, “Extracting IFC Metadata Directly in Power BI Using Power Query,” we explored how to use Power Query in PowerBI to directly extract metadata from IFC files using a Power Query shared by Shift Construction. If you haven’t read that post, I recommend checking it out first for context. A few people reached out as they found…
If you work with Industry Foundation Classes (IFC) files and want an easy way to access and analyze the metadata, there’s a great article you should check out. “How to extract data from IFC files” by Matthew Osment on Medium demonstrates how to use Power Query in Power BI to directly extract metadata from an IFC file. Matthew also provides…
Artificial Intelligence (AI) has exploded since the public release of ChatGPT, bringing the power of AI to the masses at a low cost has changed the way that many of us work and interact with the world. However, there are concerns around the privacy and security of using online, privately owned large language models (LLMs). These concerns include data privacy…
Journal scripting once offered a quick fix for converting Revit model and family units; it helped speed up the process, but it had the habit of failing on certain family types or dialogue boxes. To tackle this, I developed an add-in, which I shared on revit.com.au; which both overcame the errors that caused the journal to stumble, and was also…
Are you interested in data science but unsure if it’s the right career path for you? One of the best ways to find out is by exploring the subject through some of the excellent free courses offered by some of the world’s top universities. Whether you’re just curious or seriously considering a career in data science, these free resources from…
An old colleague shared this fantastic Excel file with me when I needed to bulk rename files. Our IT policies didn’t allow us to install useful tools such as Better File Rename. The Excel file contains VBA macros that list folder contents and rename files, and it has now become my go-to method to bulk rename files as you can…
I was asked about a problematic Revit model with 57,000 purgeable material assets. “Just purge them”, you say, but the problem is that even using a shift+click to select the assets locked up the user’s Revit for around 30 minutes while Revit thought about its life choices. I had experience previously purging elements using the performance advisor, but that doesn’t…