Category: Data Analysis

QGis Madeira Basic conns to Maps/.csv’s/Databases

          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

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

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