Category: Data Analysis

Obvibase database with Google Sheets I was thinking about my expenses Form/Sheet process Spending Tracker that I’m very pleased with. A method to capture my spending. My concern is that the sheet will bloat over time with older records. I was surprised that one of my big sheets in Excel could not be opened in

Background I have written a post on showing internal building fabric condition over time in this article Revit Internal Condition over Time.I was not, at the time, happy with the presentation of the information as it was a series of screenshots that I then put in as slides to step through the process. Two things

I thought I’d have a look at QGis again now that it has been updated. I’m always wow’d by what people can do with the GIS mapping. Unfortunately for me I’m an amateur playing in this area. I did a cartography course at Uni way back and enjoy exploring some mapping tools. As QGis and

I wrote a post on using Excel filterable Heatmaps for Asset Condition over time online. This was an excel file on my OneDrive that I then embedded in a web page. I had filtered the columns so that you could filter columns to do forecasting for building items that would need work to be done

Further to my previous post Google Sheets “GOOGLEFINANCE()” for free Stock data that started with referencing 5 things that Excel couldn’t do but Google Sheets can, I wanted to explore a few of the features mentioned in that video. It mentioned the following Google Sheet Functions: ImportFEED(), Import HTML() &ImportXML() 1. ImportFeed() Well, I followed

Further to my previous post on 12 Free Productivity Tools for Win 10 (initially 8 but I added some more) I have since found a few more free programmes that can help with productivity. RocketDock RocketDock is a task bar, but it looks a bit like the Apple Task Bar and can be configured in

Macro Tools Following on from Macro productivity tools using AlternativeTo I came across: SikuliX automates anything you see on the screen of your desktop computer running Windows, Mac or some Linux/Unix. It uses image recognition powered by OpenCV to identify and control GUI components. This is handy in cases when there is no easy access to

While at Wellington City Council working on Strategic Assets, one of the exercises of the Building Asset Team Leader, Tane Dunne,  was to work out what the top major cost items were for the assets over a period of time, in this case 50 years. The assets were captured by the SPM  survey team of

At the end of the last post I put a few steps for my process: Part 1.Initially broad targeting. Harvesting personal emails with searches which include gmail.com etc. Part 2. I need to find some Facility Management Directories and do a web crawl on some of those. To do that I could use the Firefox

Well, its never as simple as what is shown in the videos.  This post follows on from my earlier post part 1. This time I try running through the process and getting a workflow going. 1. Google Trends I did play with this a bit an terms that started popping up were “Computer-aided facility management”