Category: Data Extraction

Architectural Colour Schedule in Excel

         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

Revit internal condition over time GIF

         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

Google Sheets ImportFEED, Import HTML & ImportXML

         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

Learning UiPath RPA (Robotic Process Automation)

         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

Finding leads for my Services Website- web scraping? Targeting business URL’s-Part 3

         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