Category: Excel, Power BI & Google Sheets

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

AutoIt v3 is a freeware BASIC-like scripting language designed for automating the Windows GUI and general scripting. It uses a combination of simulated keystrokes, mouse movement and window/control manipulation in order to automate tasks in a way not possible or reliable with other languages (e.g. VBScript and SendKeys). AutoIt is also very small, self-contained and

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

While at Wellington City Council working on Strategic Assets, one of the exercises of the Building Asset Team Leader, Tane Dunne,  was to work out what the top major cost items were for the assets over a period of time, in this case 50 years. The assets were captured by the SPM  survey team of

It’s not often one comes across a tool that looks really really interesting where you think you can get some great leverage, but from what I have seen so far Coda.io looks really useful. I’m even starting this post off with a Part 1 as I expect to be doing quite a lot of exploration

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

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

Following on from the previous post  I want to try and be able to update a Google Sheet from a web page via the link. I will be following this video: Unfortunately there is not a link to code for this addition, unlike videos 1 & 2 so I’ll need to write it from looking

I like it when I find some useful code and it works straight away. When it doesn’t I end up spending an awful lot of time trying to figure out what is happening. turning the programmers dark magic into something comprehensible. Continuing on from the previous post I started to look at the output and

Getting data from the web and being able to manipulate it and display it on your own website. Using Google sheets to refresh the data at specified intervals allows you to get live feed from sites that do not have an API for drawing the data down. At the end of the last post I