Category: Excel, Power BI & Google Sheets

My son in law, Karl Reece is playing in the Canoe Polo 2018 World Championships Welland Canada for team USA. I am very impressed with his accomplishments. Come on USA & NZ. Games played, won/lost based on Groups in table below at the end of 4/8/2018 at Canoe Polo 2018 World Championships Welland Canada.  I

The last few posts have been looking at data from the Web into Excel or using API’s. Then doing some graphics with the data. Excel is a bit static. You have captured the data from the web and you have to send someone your workbook to view. They may not update the data, so it

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