Category: Excel, Power BI & Google Sheets

Excel filterable Heatmaps for Asset Condition over time online

A method for showing condition heatmaps is using Excel to display the condition of the elements over time. Another post Heatmaps for visualising exterior and interior space conditions uses D3.js heatmaps. The good part of this is that you can use filters to explore the information and drill down into the data. Video (4min) I

BIM back capture Building Services Data Part 2 -Systems

In the first article here regarding capturing building services data on existing buildings, the focus was mainly on discrete components that sit in a system, with for instance lights, there may be an issue regarding which circuit they are linked to which switch or circuit fused in a sub-board, and this could easily be added