Author: Max Drake

Python 1. Starting with Python

Why would I want to use Python? I give an explanation at the bottom of background to how I selected this programme.  After exploring Python tutorials, I decided that I could use Python to do help me do the following things that I have been working on, hopefully in a more integrated environment, rather than

Building Data Wrangling for Analysis using Power BI, Knime, Excel & SQL Express

This is the LINK to the report. The idea is to use powerBI to display data about different elements on a Dashboard so you can drill into the data. In the above screenshot I have tables showing Standard, Upper & Lower Baselife Data with conditions by colour and a map referencing where the properties are

Knime Database Connections

I use Knime for re-structuring data. What is Knime? From their website: At KNIME,  we build software for fast, easy and intuitive access to advanced data science, helping organizations drive innovation. Our KNIME Analytics Platform is the leading open solution for data-driven innovation, designed for discovering the potential hidden in data, mining for fresh insights,

Download Excel Macro for testing extraction data from 3D PDF’s

Please download and play with the data extraction process from 3D PDF’s to Excel. This is a  a reduced functionality demonstration version of the Excel Macro developed for extracting information from 3D PDF’s. The Macro only works on Room data from the 3D PDF’s. There are also samples of 3D PDF files with Data &

Data Capture from raster files with Revit

Most Asset Management Property Portfolios will consist of existing buildings. Generally new buildings coming into the portfolio will be a small percentage of the total. Information about existing buildings will most probably be scanned (Raster) plans and documents from the original As-Built construction drawing set, with some small updates in CAD (Computer Aided Drawing). This

Why use BIM for Data Capture for New & Existing Buildings?

Modern Asset & Facilities Management use information about their assets to plan and maintain them in a Fit for Purpose state so that they can fulfill their space function to maximise their asset value. To do this you require information about the buildings so that you can use predictive tools to: Effectively budget to maintain

Revit Add-Ins for Data Extraction- My personal choice

Note, these are my personal views and I am getting no remuneration from any of the products organizations below. There usually pops up a post/article about a list of add-ins  for Revit that you find to help you in your workflow. Most of the ones are directed at day to day design workflow. ArchSmarter via