Category: Data Extraction

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 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

Revit- Crowd seating, visual numbering, colouring ordered and random

          Capturing auditoria, theatres etc for AM/FM and for ongoing use of the model for seating planning can be useful. With numbered seating you can allocate different prices for different seating, you can also change pricing for different event configurations for multi-purpose arrangements. I have done seating on a number of buildings in Wellington when working

Revit Room/Door/Colour Schedules & Key Schedules

          I’ve started work at an Architectural firm and am trying to setup some room, door, window and colour schedules. Currently the office uses excel to do their Room schedules then puts the excel sheet on a title block to issue. The danger with this process is that you update something in Revit and you have