Category: Data Analysis

         I was looking at the GlideApps showcase and the Bogdan Popa created a News App. In it he uses IMPORTXML in Google Sheets to pull in web data that he filters to different tables. A nice app. I started thinking about what other import formulas does Google Sheets have, I know it has GOOGLEFINANCE

         The first process I did Architectural Colour Schedule in Excel used VLookup() to lookup a table on a separate sheet, but it did not show you the choice of selections. This time I want to be able, when looking up a room finish, to see what the selections are, so that I can choose

        The last post I tried to use AirTable to create a Colour Schedule from a Revit export. Thinking I could use the Database to cross reference items in the room such as doors/windows etc to be able to pull those in to make the colour scheme planning more comprehensive. It didn’t work. Along the way

        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

        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