Category: Excel, Power BI & Google Sheets

In the previous post “Stock Data 1. Capture via API and Excel from Web” I used Excel to grab some data from the Web & show it as a Table inside Excel. After bringing the data in I had trouble creating a chart from the Table. So, after messing around with the Charts again today

I started looking at getting financial data from the Web, looking at the NZX (NZ stock Exchange) but no-one had free API’s. Actually Quandl did but it was only monthly on overall stocks/bonds and stops the previous month. So I spent a little time fluffing with their free API before realising that was the case.

After writing the previous post on web scraping and the example given of using Google Spreadsheet to obtain a web table I started wondering about Excel. I was aware that it had a web connection so decided to explore those. This first video shows how to automate the data scraping  from websites into Excel: Then

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

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 &

In the previous post  How to show CAD drawings on a Web Page I talked about posting CAD drawings to a web page for access to the information. In this post I want to talk about having Data in the CAD file that you can extract to Excel. In DraftSight you can create attribute blocks

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

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

For new assets, if BIM models are used for design/construction then the modeled services are available for use in FM stage of the project. If there are existing assets that are partially through their lifecycle and services data is required for them, then you will need to consider the level of information that you require