Category: Data Extraction

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

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

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” 

People have their skills. I’m a bit of a techie and love to dive deep into things. Being freelance you have to be versatile though. Like having a modicum of understanding of accounts for tax and skills for running a business. One area I find challenging is marketing. I tend to get work by word

I can’t actually recollect who had told me that you could go backwards in Revit versions by exporting to IFC and then opening a new project and bringing in the IFC into a previous version. I know Matt Cantwell was doing quite a lot of work with bringing information in from IFC’s but not the

I don’t usually do ceramic tile finishes, but I’ve just had the opportunity of doing some on a recent project. There are floor tiles and wall tiles and feature tiles for an accessible toilet that I will use as an example. This is near the finished set-out for them, a few more dims and schedules

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 for

Web Scraper I was looking at Firefox addins and came across a couple of web scraping add ins. Data scrapper and web scraper. The first one I couldn’t get working and the 2nd one I had to watch a video before I could get the settings sorted. Recently, about 4 months ago, I added a

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